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

(-)a/installer/data/mysql/kohastructure.sql (-1 lines)
Lines 2331-2337 CREATE TABLE `message_queue` ( Link Here
2331
  `from_address` mediumtext,
2331
  `from_address` mediumtext,
2332
  `content_type` text,
2332
  `content_type` text,
2333
  PRIMARY KEY (`message_id`),
2333
  PRIMARY KEY (`message_id`),
2334
  KEY `message_id` (`message_id`),
2335
  KEY `borrowernumber` (`borrowernumber`),
2334
  KEY `borrowernumber` (`borrowernumber`),
2336
  KEY `message_transport_type` (`message_transport_type`),
2335
  KEY `message_transport_type` (`message_transport_type`),
2337
  CONSTRAINT `messageq_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
2336
  CONSTRAINT `messageq_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +1 lines)
Lines 5639-5644 if(C4::Context->preference("Version") < TransformToNum($DBversion) ) { Link Here
5639
$DBversion = "XXX";
5639
$DBversion = "XXX";
5640
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
5640
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
5641
    $dbh->do("ALTER TABLE message_queue ADD PRIMARY KEY (message_id);");
5641
    $dbh->do("ALTER TABLE message_queue ADD PRIMARY KEY (message_id);");
5642
    $dbh->do("ALTER TABLE message_queue DROP KEY message_id;");
5642
    print "Upgrade to $DBversion done (redefine the field message_id as PRIMARY KEY of message_queue)\n";
5643
    print "Upgrade to $DBversion done (redefine the field message_id as PRIMARY KEY of message_queue)\n";
5643
    SetVersion ($DBversion);
5644
    SetVersion ($DBversion);
5644
}
5645
}
5645
- 

Return to bug 7793