diff options
| author | Tomek Mrugalski <tomek@isc.org> | 2021-06-18 12:44:51 +0200 |
|---|---|---|
| committer | Tomek Mrugalski <tomek@isc.org> | 2021-10-28 12:31:41 +0200 |
| commit | 5281de721a9362c4cd040d953f66c3d406d19c3c (patch) | |
| tree | 5bd7a3758a2cd606dd265272e4773160b7a50e08 /src/share/database/scripts/pgsql/dhcpdb_create.pgsql | |
| parent | 55f0c5e29cc1e114ee592ab58a443e8fc43826ae (diff) | |
[#90] tag shortened to 64 bytes
Diffstat (limited to 'src/share/database/scripts/pgsql/dhcpdb_create.pgsql')
| -rw-r--r-- | src/share/database/scripts/pgsql/dhcpdb_create.pgsql | 5 |
1 files changed, 2 insertions, 3 deletions
diff --git a/src/share/database/scripts/pgsql/dhcpdb_create.pgsql b/src/share/database/scripts/pgsql/dhcpdb_create.pgsql index 56759802c9..a3e1a6979a 100644 --- a/src/share/database/scripts/pgsql/dhcpdb_create.pgsql +++ b/src/share/database/scripts/pgsql/dhcpdb_create.pgsql @@ -1106,7 +1106,7 @@ INSERT INTO ddns_replace_client_name_types (type, name) VALUES -- Create table for DHCPv6 servers CREATE TABLE dhcp6_server ( id SERIAL PRIMARY KEY NOT NULL, - tag VARCHAR(256) NOT NULL, + tag VARCHAR(64) NOT NULL, description TEXT DEFAULT NULL, modification_ts TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, UNIQUE(tag) @@ -1294,7 +1294,6 @@ CREATE TRIGGER dhcp6_subnet_server_modification_ts_update FOR EACH ROW EXECUTE PROCEDURE modification_ts_update(); - -- Create table for storing global DHCPv6 parameters. CREATE TABLE dhcp6_global_parameter ( id SERIAL PRIMARY KEY NOT NULL, @@ -1430,7 +1429,7 @@ CREATE INDEX dhcp6_audit_idx2 ON dhcp6_audit (revision_id); -- Create table for DHCPv4 servers CREATE TABLE dhcp4_server ( id SERIAL PRIMARY KEY NOT NULL, - tag VARCHAR(256) NOT NULL, + tag VARCHAR(64) NOT NULL, description TEXT DEFAULT NULL, modification_ts TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, UNIQUE(tag) |