From 5ab1781bab5b6718107937236a3fee7b06232910 Mon Sep 17 00:00:00 2001 From: Andrew Moore Date: Tue, 11 Nov 2008 14:47:51 -0600 Subject: [PATCH] adding "DROP TABLE" commands to several table definitions in kohastructure.sql Signed-off-by: Galen Charlton --- installer/data/mysql/kohastructure.sql | 5 +++++ 1 file changed, 5 insertions(+) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 09aaf9773f..fa93a059a3 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -942,6 +942,7 @@ CREATE TABLE `ethnicity` ( -- Table structure for table `hold_fill_targets` -- +DROP TABLE IF EXISTS `hold_fill_targets`; CREATE TABLE hold_fill_targets ( `borrowernumber` int(11) NOT NULL, `biblionumber` int(11) NOT NULL, @@ -1958,6 +1959,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, @@ -1978,6 +1980,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', @@ -1994,6 +1997,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, @@ -2202,6 +2206,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.2