View | Details | Raw Unified | Return to bug 9021
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_9021.sql (-4 / +3 lines)
Lines 5-12 CREATE TABLE sms_providers ( Link Here
5
   UNIQUE (
5
   UNIQUE (
6
       name
6
       name
7
   )
7
   )
8
) ENGINE = INNODB CHARACTER SET utf8;
8
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
9
9
10
ALTER TABLE borrowers ADD sms_provider_id INT( 11 ) NULL DEFAULT NULL AFTER smsalertnumber, ADD INDEX ( sms_provider_id );
10
ALTER TABLE borrowers ADD sms_provider_id INT( 11 ) NULL DEFAULT NULL AFTER smsalertnumber;
11
11
12
ALTER TABLE borrowers ADD FOREIGN KEY ( sms_provider_id ) REFERENCES  sms_providers ( id );
12
ALTER TABLE borrowers ADD FOREIGN KEY ( sms_provider_id ) REFERENCES sms_providers ( id );
13
- 

Return to bug 9021