diff options
Diffstat (limited to 'src/share/database/scripts/pgsql/dhcpdb_create.pgsql')
| -rw-r--r-- | src/share/database/scripts/pgsql/dhcpdb_create.pgsql | 15 |
1 files changed, 13 insertions, 2 deletions
diff --git a/src/share/database/scripts/pgsql/dhcpdb_create.pgsql b/src/share/database/scripts/pgsql/dhcpdb_create.pgsql index 8052ca53ef..29bdcf608f 100644 --- a/src/share/database/scripts/pgsql/dhcpdb_create.pgsql +++ b/src/share/database/scripts/pgsql/dhcpdb_create.pgsql @@ -1,4 +1,4 @@ --- Copyright (C) 2012-2016 Internet Systems Consortium. +-- Copyright (C) 2012-2017 Internet Systems Consortium, Inc. ("ISC") -- This Source Code Form is subject to the terms of the Mozilla Public -- License, v. 2.0. If a copy of the MPL was not distributed with this @@ -261,7 +261,7 @@ INSERT INTO dhcp_option_scope VALUES (3, 'host'); -- -- Table structure for table hosts. -- --- Primary key and unique contraints automatically create indexes, +-- Primary key and unique constraints automatically create indexes, -- foreign key constraints do not. CREATE TABLE hosts ( host_id SERIAL PRIMARY KEY NOT NULL, @@ -483,6 +483,17 @@ UPDATE schema_version -- Schema 3.0 specification ends here. +-- This is a placeholder for the changes between 3.0 and 3.1. We have added a +-- missing 'client-id' host reservation type entry that had been accidentally +-- omitted when the 2.0 -> 3.0 upgrade script was created. +-- Also, new flexible identifier has been added. +INSERT INTO host_identifier_type VALUES (4, 'flex-id'); + +-- Set 3.1 schema version. +UPDATE schema_version + SET version = '3', minor = '1'; + + -- Commit the script transaction. COMMIT; |