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

(-)a/installer/data/mysql/kohastructure.sql (+1 lines)
Lines 2308-2313 CREATE TABLE `message_queue` ( Link Here
2308
  `to_address` mediumtext,
2308
  `to_address` mediumtext,
2309
  `from_address` mediumtext,
2309
  `from_address` mediumtext,
2310
  `content_type` text,
2310
  `content_type` text,
2311
  PRIMARY KEY (`message_id`),
2311
  KEY `message_id` (`message_id`),
2312
  KEY `message_id` (`message_id`),
2312
  KEY `borrowernumber` (`borrowernumber`),
2313
  KEY `borrowernumber` (`borrowernumber`),
2313
  KEY `message_transport_type` (`message_transport_type`),
2314
  KEY `message_transport_type` (`message_transport_type`),
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +7 lines)
Lines 4994-4999 if ( C4::Context->preference("Version") lt TransformToNum($DBversion) ) { Link Here
4994
    SetVersion($DBversion);
4994
    SetVersion($DBversion);
4995
}
4995
}
4996
4996
4997
$DBversion = "XXX";
4998
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
4999
    $dbh->do("ALTER TABLE message_queue ADD PRIMARY KEY (message_id);");
5000
    print "Upgrade to $DBversion done (redefine the field message_id as PRIMARY KEY of message_queue)\n";
5001
    SetVersion ($DBversion);
5002
}
5003
4997
=head1 FUNCTIONS
5004
=head1 FUNCTIONS
4998
5005
4999
=head2 DropAllForeignKeys($table)
5006
=head2 DropAllForeignKeys($table)
5000
- 

Return to bug 7793