From 48b63d8bf6012219e18e241d122e8122e91dce1f Mon Sep 17 00:00:00 2001 From: Andrei Pavel Date: Mon, 30 Aug 2021 14:55:14 +0300 Subject: [PATCH] [#2063] DROP FOREIGN KEY for MySQL 5 compatibility --- src/share/database/scripts/mysql/dhcpdb_create.mysql | 4 ++-- src/share/database/scripts/mysql/upgrade_010_to_011.sh.in | 4 ++-- 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 b1f2de4538..e04ea8933d 100644 --- a/src/share/database/scripts/mysql/dhcpdb_create.mysql +++ b/src/share/database/scripts/mysql/dhcpdb_create.mysql @@ -4018,14 +4018,14 @@ UPDATE schema_version # Add a constraint that any state value added to the lease4 must # map to a value in the lease_state table. Note we have to drop # the foreign keys first, then add them back. -ALTER TABLE lease4 DROP CONSTRAINT fk_lease4_state; +ALTER TABLE lease4 DROP FOREIGN KEY fk_lease4_state; DROP INDEX lease4_by_state_expire ON lease4; CREATE INDEX lease4_by_expire_state ON lease4 (expire ASC, state ASC); ALTER TABLE lease4 ADD CONSTRAINT fk_lease4_state FOREIGN KEY (state) REFERENCES lease_state (state); -ALTER TABLE lease6 DROP CONSTRAINT fk_lease6_state; +ALTER TABLE lease6 DROP FOREIGN KEY fk_lease6_state; CREATE INDEX lease6_by_expire_state ON lease6 (expire ASC, state ASC); DROP INDEX lease6_by_state_expire ON lease6; ALTER TABLE lease6 diff --git a/src/share/database/scripts/mysql/upgrade_010_to_011.sh.in b/src/share/database/scripts/mysql/upgrade_010_to_011.sh.in index 7a484e6d3b..c5f512abb3 100644 --- a/src/share/database/scripts/mysql/upgrade_010_to_011.sh.in +++ b/src/share/database/scripts/mysql/upgrade_010_to_011.sh.in @@ -57,14 +57,14 @@ mysql "$@" <