From 309df47c03212cb95c17f3d3c59d10f84fd17c13 Mon Sep 17 00:00:00 2001 From: Thomas Markwalder Date: Wed, 21 Jun 2023 10:46:57 -0400 Subject: [PATCH] [#2909] Readd not null constraint --- src/share/database/scripts/mysql/dhcpdb_create.mysql | 1 + src/share/database/scripts/mysql/upgrade_018_to_019.sh.in | 1 + 2 files changed, 2 insertions(+) diff --git a/src/share/database/scripts/mysql/dhcpdb_create.mysql b/src/share/database/scripts/mysql/dhcpdb_create.mysql index 53fdd0c28f..d05ccaede0 100644 --- a/src/share/database/scripts/mysql/dhcpdb_create.mysql +++ b/src/share/database/scripts/mysql/dhcpdb_create.mysql @@ -5707,6 +5707,7 @@ ALTER TABLE ipv6_reservations MODIFY COLUMN address VARCHAR(39) DEFAULT NULL; UPDATE ipv6_reservations set address = NULL; ALTER TABLE ipv6_reservations MODIFY COLUMN address BINARY(16); UPDATE ipv6_reservations set address = binaddr; +ALTER TABLE ipv6_reservations MODIFY COLUMN address BINARY(16) NOT NULL; ALTER TABLE ipv6_reservations DROP COLUMN binaddr; -- Convert binary lease6 address to text diff --git a/src/share/database/scripts/mysql/upgrade_018_to_019.sh.in b/src/share/database/scripts/mysql/upgrade_018_to_019.sh.in index 7f7557d767..c9f123676c 100644 --- a/src/share/database/scripts/mysql/upgrade_018_to_019.sh.in +++ b/src/share/database/scripts/mysql/upgrade_018_to_019.sh.in @@ -83,6 +83,7 @@ ALTER TABLE ipv6_reservations MODIFY COLUMN address VARCHAR(39) DEFAULT NULL; UPDATE ipv6_reservations set address = NULL; ALTER TABLE ipv6_reservations MODIFY COLUMN address BINARY(16); UPDATE ipv6_reservations set address = binaddr; +ALTER TABLE ipv6_reservations MODIFY COLUMN address BINARY(16) NOT NULL; ALTER TABLE ipv6_reservations DROP COLUMN binaddr; -- Convert binary lease6 address to text -- 2.47.2