From d93918ce8e9267d886cf54dbffaeb20be28ba4e3 Mon Sep 17 00:00:00 2001 From: David Bourgault 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. --- 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 2edd371..2cbb1ce 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.7.4