From 6a4efc38aa9c95cd7ca51fb74378f4cf73ccbd19 Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Tue, 9 Feb 2016 14:52:45 +0000 Subject: [PATCH] Bug 9021 [QA Followup] - Fix ENGINE, don't create index on FK Signed-off-by: Mark Tompsett Signed-off-by: Jonathan Druart --- installer/data/mysql/atomicupdate/bug_9021.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/installer/data/mysql/atomicupdate/bug_9021.sql b/installer/data/mysql/atomicupdate/bug_9021.sql index f729d26..176acae 100644 --- a/installer/data/mysql/atomicupdate/bug_9021.sql +++ b/installer/data/mysql/atomicupdate/bug_9021.sql @@ -5,8 +5,8 @@ CREATE TABLE sms_providers ( UNIQUE ( name ) -) ENGINE = INNODB CHARACTER SET utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -ALTER TABLE borrowers ADD sms_provider_id INT( 11 ) NULL DEFAULT NULL AFTER smsalertnumber, ADD INDEX ( sms_provider_id ); +ALTER TABLE borrowers ADD sms_provider_id INT( 11 ) NULL DEFAULT NULL AFTER smsalertnumber; -ALTER TABLE borrowers ADD FOREIGN KEY ( sms_provider_id ) REFERENCES sms_providers ( id ); +ALTER TABLE borrowers ADD FOREIGN KEY ( sms_provider_id ) REFERENCES sms_providers ( id ); -- 2.7.0