From cbe62fed566632875694e99e247d9653fec9cb57 Mon Sep 17 00:00:00 2001 From: Francis Dupont Date: Wed, 20 Feb 2019 13:37:17 +0100 Subject: [PATCH] [460-update-mysql-database-schema-for-dhcpv6--align-on-dhcpv4] Renamed dhcp6_subnet_id in dhcp6_pd_pool too --- src/share/database/scripts/mysql/dhcpdb_create.mysql | 4 +++- src/share/database/scripts/mysql/upgrade_7.0_to_8.0.sh.in | 4 +++- 2 files changed, 6 insertions(+), 2 deletions(-) diff --git a/src/share/database/scripts/mysql/dhcpdb_create.mysql b/src/share/database/scripts/mysql/dhcpdb_create.mysql index 5247e55630..286900206f 100644 --- a/src/share/database/scripts/mysql/dhcpdb_create.mysql +++ b/src/share/database/scripts/mysql/dhcpdb_create.mysql @@ -1807,11 +1807,13 @@ ALTER TABLE dhcp6_global_parameter REFERENCES parameter_data_type (id); --- Rename dhcp6_subnet_id column of dhcp6_pool +-- Rename dhcp6_subnet_id column of dhcp6_pool and dhcp6_pd_pool ALTER TABLE dhcp6_pool CHANGE dhcp6_subnet_id subnet_id INT(10) UNSIGNED NOT NULL; +ALTER TABLE dhcp6_pd_pool + CHANGE dhcp6_subnet_id subnet_id INT(10) UNSIGNED NOT NULL; # Update the schema version number UPDATE schema_version diff --git a/src/share/database/scripts/mysql/upgrade_7.0_to_8.0.sh.in b/src/share/database/scripts/mysql/upgrade_7.0_to_8.0.sh.in index 070f7547f5..775541e971 100644 --- a/src/share/database/scripts/mysql/upgrade_7.0_to_8.0.sh.in +++ b/src/share/database/scripts/mysql/upgrade_7.0_to_8.0.sh.in @@ -490,11 +490,13 @@ ALTER TABLE dhcp6_global_parameter REFERENCES parameter_data_type (id); --- Rename dhcp6_subnet_id column of dhcp6_pool +-- Rename dhcp6_subnet_id column of dhcp6_pool and dhcp6_pd_pool ALTER TABLE dhcp6_pool CHANGE dhcp6_subnet_id subnet_id INT(10) UNSIGNED NOT NULL; +ALTER TABLE dhcp6_pd_pool + CHANGE dhcp6_subnet_id subnet_id INT(10) UNSIGNED NOT NULL; # Update the schema version number UPDATE schema_version -- 2.47.2