diff options
| author | Tomek Mrugalski <tomek@isc.org> | 2021-06-18 10:13:02 +0200 |
|---|---|---|
| committer | Tomek Mrugalski <tomek@isc.org> | 2021-10-28 12:31:41 +0200 |
| commit | 33f84490753e358346e7e7160a88cb35a846ef24 (patch) | |
| tree | 8a59023848dbf41b77e1996f9757bb9adc020d9c /src/share/database/scripts/pgsql/dhcpdb_create.pgsql | |
| parent | a6a14254342838d5c78f73d1e4f4ac1c196fc74f (diff) | |
[#90] Added missing constraints
Diffstat (limited to 'src/share/database/scripts/pgsql/dhcpdb_create.pgsql')
| -rw-r--r-- | src/share/database/scripts/pgsql/dhcpdb_create.pgsql | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/src/share/database/scripts/pgsql/dhcpdb_create.pgsql b/src/share/database/scripts/pgsql/dhcpdb_create.pgsql index 715708ae49..a0ade2e3c8 100644 --- a/src/share/database/scripts/pgsql/dhcpdb_create.pgsql +++ b/src/share/database/scripts/pgsql/dhcpdb_create.pgsql @@ -1281,8 +1281,10 @@ CREATE TABLE dhcp6_subnet_server ( server_id BIGINT NOT NULL, modification_ts TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (subnet_id, server_id), - CONSTRAINT fk_dhcp6_subnet_server_server_id FOREIGN KEY (server_id) REFERENCES dhcp6_server (id), - CONSTRAINT fk_dhcp6_subnet_server_subnet_id FOREIGN KEY (subnet_id) REFERENCES dhcp6_subnet (subnet_id), + CONSTRAINT fk_dhcp6_subnet_server_server_id + FOREIGN KEY (server_id) REFERENCES dhcp6_server (id) ON DELETE NO ACTION ON UPDATE NO ACTION, + CONSTRAINT fk_dhcp6_subnet_server_subnet_id + FOREIGN KEY (subnet_id) REFERENCES dhcp6_subnet (subnet_id) ON DELETE CASCADE ON UPDATE NO ACTION, UNIQUE (subnet_id, server_id) ); CREATE INDEX dhcp6_subnet_server_idx1 ON dhcp6_subnet_server(server_id); |