Bugzilla – Attachment 68051 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.77 KB, created by
Marcel de Rooy
on 2017-10-13 07:44:38 UTC
(
hide
)
Description:
Bug 19422 - Missing DROP TABLES in kohastructure.sql
Filename:
MIME Type:
Creator:
Marcel de Rooy
Created:
2017-10-13 07:44:38 UTC
Size:
1.77 KB
patch
obsolete
>From b80a617ab956c45feb5a32397b14c62e64306e3f 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 >Content-Type: text/plain; charset=utf-8 > >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> > >Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> >--- > 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 eb02c95..7b1c920 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -3922,6 +3922,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, >@@ -3955,6 +3956,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, >@@ -3970,6 +3972,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.1.4
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