From b80a617ab956c45feb5a32397b14c62e64306e3f 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 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 Signed-off-by: Marcel de Rooy --- 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