From 6ce257ced4a9665ae46740c8c70b262e184ff512 Mon Sep 17 00:00:00 2001 From: mveron Date: Thu, 12 Apr 2012 22:17:02 +0200 Subject: [PATCH] Bug 5668 Error during during insall with web installer, Step 3 Content-Type: text/plain; charset="utf-8" --- installer/data/mysql/kohastructure.sql | 7 ++++--- 1 files 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.2.5