From 6ce257ced4a9665ae46740c8c70b262e184ff512 Mon Sep 17 00:00:00 2001
From: mveron <veron@veron.ch>
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