Bugzilla – Attachment 67781 Details for
Bug 19422
kohastructure.sql missing DROP TABLES
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 19422 - Missing DROP TABLES in kohastructure.sql
Bug-19422---Missing-DROP-TABLES-in-kohastructuresq.patch (text/plain), 1.68 KB, created by
Katrin Fischer
on 2017-10-07 12:31:40 UTC
(
hide
)
Description:
Bug 19422 - Missing DROP TABLES in kohastructure.sql
Filename:
MIME Type:
Creator:
Katrin Fischer
Created:
2017-10-07 12:31:40 UTC
Size:
1.68 KB
patch
obsolete
>From f7ae6726fa4c0ba0eb930a28b0411cefe32bfe2c Mon Sep 17 00:00:00 2001 >From: David Bourgault <david.bourgault@inlibro.com> >Date: Fri, 6 Oct 2017 08:42:32 -0400 >Subject: [PATCH] Bug 19422 - Missing DROP TABLES in kohastructure.sql > >Adds DROP TABLE statements to the following tables > - article_requests > - biblio_metadata > - deletedbiblio_metadata > >Test plan : >Clean your database by running 'mysql < kohastructure.sql'. >Without patch you'll get error messages. >With patch everything will work fine, no warnings. > >Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de> >--- > installer/data/mysql/kohastructure.sql | 3 +++ > 1 file changed, 3 insertions(+) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 2edd37117e..2cbb1cec0c 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -3920,6 +3920,7 @@ CREATE TABLE IF NOT EXISTS `housebound_role` ( > -- Table structure for table 'article_requests' > -- > >+DROP TABLE IF EXISTS `article_requests`; > CREATE TABLE `article_requests` ( > `id` int(11) NOT NULL AUTO_INCREMENT, > `borrowernumber` int(11) NOT NULL, >@@ -3953,6 +3954,7 @@ CREATE TABLE `article_requests` ( > -- Table structure for table `biblio_metadata` > -- > >+DROP TABLE IF EXISTS `biblio_metadata`; > CREATE TABLE biblio_metadata ( > `id` INT(11) NOT NULL AUTO_INCREMENT, > `biblionumber` INT(11) NOT NULL, >@@ -3968,6 +3970,7 @@ CREATE TABLE biblio_metadata ( > -- Table structure for table `deletedbiblio_metadata` > -- > >+DROP TABLE IF EXISTS `deletedbiblio_metadata`; > CREATE TABLE deletedbiblio_metadata ( > `id` INT(11) NOT NULL AUTO_INCREMENT, > `biblionumber` INT(11) NOT NULL, >-- >2.11.0
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 19422
:
67705
|
67781
|
68051
|
68084