[Koha-patches] [PATCH] Bug 5668 - fix comments in the SQL definition so MySQL doesn't choke

Robin Sheat robin at catalyst.net.nz
Tue Oct 11 04:34:22 CEST 2011


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



More information about the Koha-patches mailing list