@@ -, +, @@ --- installer/data/mysql/atomicupdate/bug_9021.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) --- a/installer/data/mysql/atomicupdate/bug_9021.sql +++ a/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 ); --