diff options
| author | Tomek Mrugalski <tomek@isc.org> | 2021-06-18 10:18:26 +0200 |
|---|---|---|
| committer | Tomek Mrugalski <tomek@isc.org> | 2021-10-28 12:31:41 +0200 |
| commit | afea833b38a2dec0e8bc788c87256af059501f62 (patch) | |
| tree | ac4f2646c7c83af2145cd741ab7fd08be6684d50 /src/share/database/scripts/pgsql/dhcpdb_create.pgsql | |
| parent | 8b2675373b9cd0482237dee30086289a0db25827 (diff) | |
[#90] Added dhcp4_shared_network_server table
Diffstat (limited to 'src/share/database/scripts/pgsql/dhcpdb_create.pgsql')
| -rw-r--r-- | src/share/database/scripts/pgsql/dhcpdb_create.pgsql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/src/share/database/scripts/pgsql/dhcpdb_create.pgsql b/src/share/database/scripts/pgsql/dhcpdb_create.pgsql index bad07f6937..56759802c9 100644 --- a/src/share/database/scripts/pgsql/dhcpdb_create.pgsql +++ b/src/share/database/scripts/pgsql/dhcpdb_create.pgsql @@ -1521,6 +1521,23 @@ CREATE TRIGGER dhcp4_shared_network_modification_ts_update FOR EACH ROW EXECUTE PROCEDURE modification_ts_update(); + +-- Now we need to create a relationship between defined shared networks and the servers +CREATE TABLE dhcp4_shared_network_server ( + shared_network_id BIGINT NOT NULL, + server_id BIGINT NOT NULL, + modification_ts TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, + PRIMARY KEY (shared_network_id, server_id), + CONSTRAINT fk_dhcp4_shared_network_server_server_id FOREIGN KEY (server_id) + REFERENCES dhcp4_server (id) ON DELETE CASCADE ON UPDATE NO ACTION, + CONSTRAINT fk_dhcp4_shared_network_server_shared_network_id FOREIGN KEY (shared_network_id) + REFERENCES dhcp4_shared_network (id) ON DELETE CASCADE ON UPDATE NO ACTION +); +CREATE INDEX dhcp4_shared_network_server_idx1 ON dhcp4_shared_network_server (modification_ts); +CREATE INDEX dhcp4_shared_network_server_idx2 ON dhcp4_shared_network_server (server_id); + + + -- Create a list of IPv4 subnets CREATE TABLE dhcp4_subnet ( subnet_id SERIAL PRIMARY KEY NOT NULL, |