diff options
| -rw-r--r-- | src/share/database/scripts/mysql/dhcpdb_create.mysql | 1 | ||||
| -rw-r--r-- | src/share/database/scripts/mysql/upgrade_018_to_019.sh.in | 1 |
2 files changed, 2 insertions, 0 deletions
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 |