From 3f51b7776d64b7a1bd05590771162abe9364a359 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Wed, 22 Aug 2012 14:48:00 +0200 Subject: [PATCH] Bug 7793: Followup: Remove the message_queue.message_id KEY --- installer/data/mysql/kohastructure.sql | 1 - installer/data/mysql/updatedatabase.pl | 1 + 2 files changed, 1 insertion(+), 1 deletion(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index c41ac27..725bcaa 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/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, diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 8a041e1..2350369 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/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); } -- 1.7.10.4