@@ -, +, @@ --- installer/data/mysql/kohastructure.sql | 1 - installer/data/mysql/updatedatabase.pl | 1 + 2 files changed, 1 insertion(+), 1 deletion(-) --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -2331,7 +2331,6 @@ CREATE TABLE `message_queue` ( `from_address` mediumtext, `content_type` text, PRIMARY KEY (`message_id`), - KEY `message_id` (`message_id`), KEY `borrowernumber` (`borrowernumber`), KEY `message_transport_type` (`message_transport_type`), CONSTRAINT `messageq_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, --- a/installer/data/mysql/updatedatabase.pl +++ a/installer/data/mysql/updatedatabase.pl @@ -5639,6 +5639,7 @@ if(C4::Context->preference("Version") < TransformToNum($DBversion) ) { $DBversion = "XXX"; if (C4::Context->preference("Version") < TransformToNum($DBversion)) { $dbh->do("ALTER TABLE message_queue ADD PRIMARY KEY (message_id);"); + $dbh->do("ALTER TABLE message_queue DROP KEY message_id;"); print "Upgrade to $DBversion done (redefine the field message_id as PRIMARY KEY of message_queue)\n"; SetVersion ($DBversion); } --