From 8864471c4dfd906d00b183c55404ede3ccea57e9 Mon Sep 17 00:00:00 2001 From: Henri-Damien LAURENT Date: Mon, 17 Nov 2008 18:00:06 +0100 Subject: [PATCH] adding "DROP TABLE" commands to several table definitions in kohastructure.sql Signed-off-by: Galen Charlton --- installer/data/mysql/kohastructure.sql | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 53da4fe656..a7a710aabe 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -1936,6 +1936,7 @@ CREATE TABLE `tags` ( -- Table structure for table `tags_all` -- +DROP TABLE IF EXISTS `tags_all`; CREATE TABLE `tags_all` ( `tag_id` int(11) NOT NULL auto_increment, `borrowernumber` int(11) NOT NULL, @@ -1956,6 +1957,7 @@ CREATE TABLE `tags_all` ( -- Table structure for table `tags_approval` -- +DROP TABLE IF EXISTS `tags_approval`; CREATE TABLE `tags_approval` ( `term` varchar(255) NOT NULL, `approved` int(1) NOT NULL default '0', @@ -1972,6 +1974,7 @@ CREATE TABLE `tags_approval` ( -- Table structure for table `tags_index` -- +DROP TABLE IF EXISTS `tags_index`; CREATE TABLE `tags_index` ( `term` varchar(255) NOT NULL, `biblionumber` int(11) NOT NULL, @@ -2179,6 +2182,7 @@ CREATE TABLE `tmp_holdsqueue` ( -- Table structure for table `message_queue` -- +DROP TABLE IF EXISTS `message_queue`; CREATE TABLE `message_queue` ( `message_id` int(11) NOT NULL auto_increment, `borrowernumber` int(11) default NULL, -- 2.39.5