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

(-)a/installer/data/mysql/atomicupdate/bug_xxxxx.perl (-1 / +3 lines)
Lines 11-17 if( CheckVersion( $DBversion ) ) { Link Here
11
    }
11
    }
12
12
13
    # Add test on existene of this key
13
    # Add test on existene of this key
14
    ALTER TABLE message_transports DROP FOREIGN KEY message_transports_ibfk_3;
14
    $dbh->do( "ALTER TABLE message_transports DROP FOREIGN KEY message_transports_ibfk_3 ");
15
    $dbh->do( "ALTER TABLE letter DROP PRIMARY KEY ");
16
    $dbh->do( "ALTER TABLE letter ADD PRIMARY KEY (`module`, `code`, `branchcode`, `message_transport_type`, `lang`) ");
15
17
16
    $dbh->do( "INSERT IGNORE INTO systempreferences (variable,value,options,explanation,type)
18
    $dbh->do( "INSERT IGNORE INTO systempreferences (variable,value,options,explanation,type)
17
        VALUES ('TranslateNotices',  '0',  NULL,  'Allow notices to be translated',  'YesNo') ");
19
        VALUES ('TranslateNotices',  '0',  NULL,  'Allow notices to be translated',  'YesNo') ");
(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 2529-2535 CREATE TABLE `letter` ( -- table for all notice templates in Koha Link Here
2529
  `content` text, -- body text for the notice or slip
2529
  `content` text, -- body text for the notice or slip
2530
  `message_transport_type` varchar(20) NOT NULL DEFAULT 'email', -- transport type for this notice
2530
  `message_transport_type` varchar(20) NOT NULL DEFAULT 'email', -- transport type for this notice
2531
  `lang` varchar(25) NOT NULL DEFAULT 'default', -- lang of the notice
2531
  `lang` varchar(25) NOT NULL DEFAULT 'default', -- lang of the notice
2532
  PRIMARY KEY  (`module`,`code`, `branchcode`, `message_transport_type`),
2532
  PRIMARY KEY  (`module`,`code`, `branchcode`, `message_transport_type`, `lang`),
2533
  CONSTRAINT `message_transport_type_fk` FOREIGN KEY (`message_transport_type`)
2533
  CONSTRAINT `message_transport_type_fk` FOREIGN KEY (`message_transport_type`)
2534
  REFERENCES `message_transport_types` (`message_transport_type`) ON DELETE CASCADE ON UPDATE CASCADE
2534
  REFERENCES `message_transport_types` (`message_transport_type`) ON DELETE CASCADE ON UPDATE CASCADE
2535
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2535
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2536
- 

Return to bug 17762