summaryrefslogtreecommitdiffstats
path: root/src/share/database
diff options
context:
space:
mode:
authorFrancis Dupont <fdupont@isc.org>2024-07-27 11:11:38 +0200
committerFrancis Dupont <fdupont@isc.org>2024-09-04 15:10:45 +0200
commitc6cb1c76af6f6433a9f2a2fe7b2c6fda211fab80 (patch)
tree267d92e8768057a66b8b84c33a2c682102b39cb3 /src/share/database
parent[#1387] Fixes for CI (2) (diff)
downloadkea-c6cb1c76af6f6433a9f2a2fe7b2c6fda211fab80.tar.xz
kea-c6cb1c76af6f6433a9f2a2fe7b2c6fda211fab80.zip
[#1387] Synchronized upgrade scripts
Diffstat (limited to 'src/share/database')
-rw-r--r--src/share/database/scripts/mysql/dhcpdb_create.mysql4
-rw-r--r--src/share/database/scripts/pgsql/dhcpdb_create.pgsql4
2 files changed, 4 insertions, 4 deletions
diff --git a/src/share/database/scripts/mysql/dhcpdb_create.mysql b/src/share/database/scripts/mysql/dhcpdb_create.mysql
index 59e478ba9a..3eeb495a3d 100644
--- a/src/share/database/scripts/mysql/dhcpdb_create.mysql
+++ b/src/share/database/scripts/mysql/dhcpdb_create.mysql
@@ -6010,7 +6010,7 @@ UPDATE schema_version
-- This line concludes the schema upgrade to version 24.0.
--- This line starts the schema upgrade to version 25.0
+-- This line starts the schema upgrade to version 25.0.
-- Add prefix exclude option to IPv6 reservations.
ALTER TABLE ipv6_reservations
@@ -6021,7 +6021,7 @@ ALTER TABLE ipv6_reservations
UPDATE schema_version
SET version = '25', minor = '0';
--- This line concludes the schema upgrade to version 25.0
+-- This line concludes the schema upgrade to version 25.0.
# Notes:
#
diff --git a/src/share/database/scripts/pgsql/dhcpdb_create.pgsql b/src/share/database/scripts/pgsql/dhcpdb_create.pgsql
index 0bed48e86b..90e9d52a77 100644
--- a/src/share/database/scripts/pgsql/dhcpdb_create.pgsql
+++ b/src/share/database/scripts/pgsql/dhcpdb_create.pgsql
@@ -6471,12 +6471,12 @@ UPDATE schema_version
-- This line concludes the schema upgrade to version 24.0.
--- This line starts the schema upgrade to version 25.0
+-- This line starts the schema upgrade to version 25.0.
-- Add prefix exclude option to IPv6 reservations.
ALTER TABLE ipv6_reservations
ADD COLUMN excluded_prefix INET DEFAULT NULL,
- ADD COLUMN excluded_prefix_len SMALLINT NOT NULL;
+ ADD COLUMN excluded_prefix_len SMALLINT NOT NULL DEFAULT '0';
-- Update the schema version number.
UPDATE schema_version