From d81fe809b6a65d8aaef9a33708f31ee54bf0306c Mon Sep 17 00:00:00 2001 From: Mark Tompsett Date: Wed, 13 May 2015 12:35:30 -0400 Subject: [PATCH] Bug 14053 - Fix cut and paste mistake (255) does not belong in the key definition. TEST PLAN ---------- 1) Back up db. 2) $ git reset --hard origin/master 3) $ git bz apply 14053 -- do not apply this patch. 4) in your mysql client: > DROP DATABASE koha_library; > CREATE DATABASE koha_library; > QUIT; 5) Navigate to staff client -- blows up in step 3 6) $ git bz apply 14053 -- apply just this final patch 7) repeat step 4. 8) Navigate to staff client -- everything proceeds smoothly. 9) run koha qa test tools --- installer/data/mysql/kohastructure.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 0e60796..44c252f 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -2904,7 +2904,7 @@ CREATE TABLE `aqbooksellers` ( -- information about the vendors listed in acquis PRIMARY KEY (`id`), KEY `listprice` (`listprice`), KEY `invoiceprice` (`invoiceprice`), - KEY `name` (`name`(255)), + KEY `name` (`name`), CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- 2.1.4