Bugzilla – Attachment 5833 Details for
Bug 5668
Star ratings in the opac
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 5668 - fix comments in the SQL definition so MySQL doesn't choke
Bug-5668---fix-comments-in-the-SQL-definition-so-M.patch (text/plain), 1.54 KB, created by
Robin Sheat
on 2011-10-11 02:34:01 UTC
(
hide
)
Description:
Bug 5668 - fix comments in the SQL definition so MySQL doesn't choke
Filename:
MIME Type:
Creator:
Robin Sheat
Created:
2011-10-11 02:34:01 UTC
Size:
1.54 KB
patch
obsolete
>From 5ae0fd893caadd79f58b3b917210f686a92a6e2f Mon Sep 17 00:00:00 2001 >From: Robin Sheat <robin@catalyst.net.nz> >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
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 5668
:
3034
|
3035
|
5097
|
5098
|
5136
|
5137
|
5792
|
5794
|
5833
|
7116
|
7165
|
7166
|
7215
|
7604
|
7798
|
8027
|
8199
|
8202
|
8312
|
8326
|
8359
|
8459
|
8514
|
8537
|
8548
|
8613
|
8704
|
8705
|
8706
|
9159
|
9163
|
9164