From 5ae0fd893caadd79f58b3b917210f686a92a6e2f Mon Sep 17 00:00:00 2001 From: Robin Sheat Date: Tue, 11 Oct 2011 15:32:53 +1300 Subject: [PATCH] Bug 5668 - fix comments in the SQL definition so MySQL doesn't choke MySQL gets unhappy about SQL comments having three '-' in a row to begin them. --- installer/data/mysql/kohastructure.sql | 12 ++++++------ 1 files changed, 6 insertions(+), 6 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index e073e0f..6777260 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -2654,15 +2654,15 @@ CREATE TABLE `fieldmapping` ( -- koha to keyword mapping PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; ---- ---- 'Ratings' table. This tracks the star ratings set by borrowers. ---- +-- +-- 'Ratings' table. This tracks the star ratings set by borrowers. +-- 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 - `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 + `value` tinyint(1) NOT NULL, -- the rating, from 1-5 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP, PRIMARY KEY (`borrowernumber`,`biblionumber`), KEY `ratings_borrowers_fk_1` (`borrowernumber`), -- 1.7.4.1