Bugzilla – Attachment 9172 Details for
Bug 7954
Errors in kohastructure.sql
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
fix kohastructure.sql
0001-Bug-7954-fix-kohastructure.sql.patch (text/plain), 1.81 KB, created by
Julian Maurice
on 2012-04-13 09:40:38 UTC
(
hide
)
Description:
fix kohastructure.sql
Filename:
MIME Type:
Creator:
Julian Maurice
Created:
2012-04-13 09:40:38 UTC
Size:
1.81 KB
patch
obsolete
>From 7e2050e10051d3cdbd3022cafcf61f4f1b388887 Mon Sep 17 00:00:00 2001 >From: Julian Maurice <julian.maurice@biblibre.com> >Date: Fri, 13 Apr 2012 11:38:56 +0200 >Subject: [PATCH] Bug 7954: fix kohastructure.sql > >Replace '---' by '--' as MySQL seems to consider only the two last >dashes as the start of a comment. >Also add a missing 'DROP TABLE IF EXISTS' before 'CREATE TABLE' >--- > installer/data/mysql/kohastructure.sql | 7 ++++--- > 1 file changed, 4 insertions(+), 3 deletions(-) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 71eaeb0..a210293 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -1545,6 +1545,7 @@ CREATE TABLE `patronimage` ( > -- this table is MyISAM, InnoDB tables are growing only and this table is filled/emptied/filled/emptied... > -- so MyISAM is better in this case > >+DROP TABLE IF EXISTS `pending_offline_operations`; > CREATE TABLE `pending_offline_operations` ( > `operationid` int(11) NOT NULL AUTO_INCREMENT, > `userid` varchar(30) NOT NULL, >@@ -2819,9 +2820,9 @@ CREATE TABLE IF NOT EXISTS `social_data` ( > > 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 >- rating_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 >+ rating_value tinyint(1) NOT NULL, -- the rating, from 1-5 > timestamp timestamp NOT NULL default CURRENT_TIMESTAMP, > PRIMARY KEY (borrowernumber,biblionumber), > CONSTRAINT ratings_ibfk_1 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE, >-- >1.7.9.5 >
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 7954
: 9172