From bb2ff03ff7d53ba5e95d0e063c8acc5ea60ce7e6 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 (cherry picked from commit 2386e33dbba4c561f3ce465cf1a0970d52b8efd5) Signed-off-by: Fridolin Somers --- 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 3af0246e45..4408784f00 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -3916,6 +3916,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, @@ -3949,6 +3950,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, @@ -3966,6 +3968,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.5