From 7e2050e10051d3cdbd3022cafcf61f4f1b388887 Mon Sep 17 00:00:00 2001 From: Julian Maurice Date: Fri, 13 Apr 2012 11:38:56 +0200 Subject: [PATCH] Bug 7954: fix kohastructure.sql Replace '---' by '--' as MySQL seems to consider only the two last dashes as the start of a comment. Also add a missing 'DROP TABLE IF EXISTS' before 'CREATE TABLE' --- installer/data/mysql/kohastructure.sql | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 71eaeb0..a210293 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -1545,6 +1545,7 @@ CREATE TABLE `patronimage` ( -- this table is MyISAM, InnoDB tables are growing only and this table is filled/emptied/filled/emptied... -- so MyISAM is better in this case +DROP TABLE IF EXISTS `pending_offline_operations`; CREATE TABLE `pending_offline_operations` ( `operationid` int(11) NOT NULL AUTO_INCREMENT, `userid` varchar(30) NOT NULL, @@ -2819,9 +2820,9 @@ CREATE TABLE IF NOT EXISTS `social_data` ( DROP TABLE IF EXISTS ratings; CREATE TABLE ratings ( - borrowernumber int(11) NOT NULL, --- the borrower this rating is for - biblionumber int(11) NOT NULL, --- the biblio it's for - rating_value tinyint(1) NOT NULL, --- the rating, from 1-5 + borrowernumber int(11) NOT NULL, -- the borrower this rating is for + biblionumber int(11) NOT NULL, -- the biblio it's for + rating_value tinyint(1) NOT NULL, -- the rating, from 1-5 timestamp timestamp NOT NULL default CURRENT_TIMESTAMP, PRIMARY KEY (borrowernumber,biblionumber), CONSTRAINT ratings_ibfk_1 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE, -- 1.7.9.5