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

(-)a/installer/data/mysql/atomicupdate/bug_xxxxx.perl (+3 lines)
Lines 10-15 if( CheckVersion( $DBversion ) ) { Link Here
10
        $dbh->do( "ALTER TABLE deletedborrowers ADD COLUMN lang VARCHAR(25) NOT NULL DEFAULT 'default' AFTER lastseen" );
10
        $dbh->do( "ALTER TABLE deletedborrowers ADD COLUMN lang VARCHAR(25) NOT NULL DEFAULT 'default' AFTER lastseen" );
11
    }
11
    }
12
12
13
    # Add test on existene of this key
14
    ALTER TABLE message_transports DROP FOREIGN KEY message_transports_ibfk_3;
15
13
    $dbh->do( "INSERT IGNORE INTO systempreferences (variable,value,options,explanation,type)
16
    $dbh->do( "INSERT IGNORE INTO systempreferences (variable,value,options,explanation,type)
14
        VALUES ('TranslateNotices',  '0',  NULL,  'Allow notices to be translated',  'YesNo') ");
17
        VALUES ('TranslateNotices',  '0',  NULL,  'Allow notices to be translated',  'YesNo') ");
15
18
(-)a/installer/data/mysql/kohastructure.sql (-2 lines)
Lines 2579-2585 CREATE TABLE `message_transports` ( Link Here
2579
  KEY `letter_module` (`letter_module`,`letter_code`),
2579
  KEY `letter_module` (`letter_module`,`letter_code`),
2580
  CONSTRAINT `message_transports_ibfk_1` FOREIGN KEY (`message_attribute_id`) REFERENCES `message_attributes` (`message_attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2580
  CONSTRAINT `message_transports_ibfk_1` FOREIGN KEY (`message_attribute_id`) REFERENCES `message_attributes` (`message_attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2581
  CONSTRAINT `message_transports_ibfk_2` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`) ON DELETE CASCADE ON UPDATE CASCADE,
2581
  CONSTRAINT `message_transports_ibfk_2` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`) ON DELETE CASCADE ON UPDATE CASCADE,
2582
  CONSTRAINT `message_transports_ibfk_3` FOREIGN KEY (`letter_module`, `letter_code`, `branchcode`) REFERENCES `letter` (`module`, `code`, `branchcode`) ON DELETE CASCADE ON UPDATE CASCADE
2583
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2582
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2584
2583
2585
--
2584
--
2586
- 

Return to bug 17762