From 33f84490753e358346e7e7160a88cb35a846ef24 Mon Sep 17 00:00:00 2001 From: Tomek Mrugalski Date: Fri, 18 Jun 2021 10:13:02 +0200 Subject: [#90] Added missing constraints --- src/share/database/scripts/pgsql/dhcpdb_create.pgsql | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) (limited to 'src/share/database/scripts/pgsql/dhcpdb_create.pgsql') 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); -- cgit v1.2.3