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