From 2767b6ff1a9324f42f095518ce2c385aeab99c4b Mon Sep 17 00:00:00 2001 From: Henri-Damien LAURENT Date: Wed, 27 Jan 2010 21:31:41 +0100 Subject: [PATCH] kohstructure.sql not wrking with mysql5.0 Removing USING BTREE Signed-off-by: Galen Charlton --- installer/data/mysql/kohastructure.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 3045f13e49..a74b4569cf 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -1032,7 +1032,7 @@ CREATE TABLE `creator_batches` ( `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `branch_code` varchar(10) NOT NULL DEFAULT 'NB', `creator` char(15) NOT NULL DEFAULT 'Labels', - PRIMARY KEY (`label_id`) USING BTREE, + PRIMARY KEY (`label_id`), KEY `branch_fk_constraint` (`branch_code`), KEY `item_fk_constraint` (`item_number`), KEY `borrower_fk_constraint` (`borrower_number`), @@ -1052,7 +1052,7 @@ CREATE TABLE `creator_images` ( `image_id` int(4) NOT NULL AUTO_INCREMENT, `imagefile` mediumblob, `image_name` char(20) NOT NULL DEFAULT 'DEFAULT', - PRIMARY KEY (`image_id`) USING BTREE, + PRIMARY KEY (`image_id`), UNIQUE KEY `image_name_index` (`image_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; @@ -1078,7 +1078,7 @@ CREATE TABLE `creator_layouts` ( `format_string` varchar(210) NOT NULL DEFAULT 'barcode', `layout_xml` text NOT NULL, `creator` char(15) NOT NULL DEFAULT 'Labels', - PRIMARY KEY (`layout_id`) USING BTREE + PRIMARY KEY (`layout_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- @@ -1442,7 +1442,7 @@ CREATE TABLE `printers_profile` ( `units` char(20) NOT NULL default 'POINT', `creator` char(15) NOT NULL DEFAULT 'Labels', PRIMARY KEY (`profile_id`), - UNIQUE KEY `printername` (`printer_name`,`template_id`,`paper_bin`,`creator`) USING BTREE + UNIQUE KEY `printername` (`printer_name`,`template_id`,`paper_bin`,`creator`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- 2.20.1