[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