From 2386e33dbba4c561f3ce465cf1a0970d52b8efd5 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. Signed-off-by: Katrin Fischer Signed-off-by: Marcel de Rooy Signed-off-by: Jonathan Druart --- 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 3cdee18be9..b0d6cf2b31 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -3923,6 +3923,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, @@ -3956,6 +3957,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, @@ -3971,6 +3973,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.39.2