--- installer/data/mysql/kohastructure.sql | 5 +++++ 1 files changed, 5 insertions(+), 0 deletions(-)
diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 09aaf97..fa93a05 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, -- 1.5.6 _______________________________________________ Koha-patches mailing list [email protected] http://lists.koha.org/mailman/listinfo/koha-patches
