[Koha-patches] [PATCH 21/22] adding "DROP TABLE" commands to several table definitions in kohastructure.sql
Andrew Moore
andrew.moore at liblime.com
Tue Nov 11 21:47:51 CET 2008
---
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
More information about the Koha-patches
mailing list