Bug 5668 - fix comments in the SQL definition so MySQL doesn't choke

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Bug 5668 - fix comments in the SQL definition so MySQL doesn't choke

Robin Sheat-2
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

_______________________________________________
Koha-patches mailing list
[hidden email]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-patches
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/