This patch cleans up kohastructure.sql a bit:
* moved the table definition to above the ending comments
* added a "drop table..." statement
---
installer/data/mysql/kohastructure.sql | 21 +++++++++++----------
1 files changed, 11 insertions(+), 10 deletions(-)
diff --git a/installer/data/mysql/kohastructure.sql
b/installer/data/mysql/kohastructure.sql
index a4b5bfa..3bac24f 100644
--- a/installer/data/mysql/kohastructure.sql
+++ b/installer/data/mysql/kohastructure.sql
@@ -2299,19 +2299,11 @@ CREATE TABLE `borrower_message_transport_preferences` (
CONSTRAINT `borrower_message_transport_preferences_ibfk_2` FOREIGN KEY
(`message_transport_type`) REFERENCES `message_transport_types`
(`message_transport_type`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40103 SET [EMAIL PROTECTED] */;
-/*!40101 SET [EMAIL PROTECTED] */;
-/*!40014 SET [EMAIL PROTECTED] */;
-/*!40014 SET [EMAIL PROTECTED] */;
-/*!40101 SET [EMAIL PROTECTED] */;
-/*!40101 SET [EMAIL PROTECTED] */;
-/*!40101 SET [EMAIL PROTECTED] */;
-/*!40111 SET [EMAIL PROTECTED] */;
-
--
-- Table structure for the table branch_transfer_limits
--
+DROP TABLE IF EXISTS `branch_transfer_limits`;
CREATE TABLE branch_transfer_limits (
limitId int(8) NOT NULL auto_increment,
toBranch varchar(4) NOT NULL,
@@ -2319,4 +2311,13 @@ CREATE TABLE branch_transfer_limits (
itemtype varchar(4) NOT NULL,
PRIMARY KEY (limitId)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
\ No newline at end of file
+
+/*!40103 SET [EMAIL PROTECTED] */;
+/*!40101 SET [EMAIL PROTECTED] */;
+/*!40014 SET [EMAIL PROTECTED] */;
+/*!40014 SET [EMAIL PROTECTED] */;
+/*!40101 SET [EMAIL PROTECTED] */;
+/*!40101 SET [EMAIL PROTECTED] */;
+/*!40101 SET [EMAIL PROTECTED] */;
+/*!40111 SET [EMAIL PROTECTED] */;
+
--
1.5.6
_______________________________________________
Koha-patches mailing list
[email protected]
http://lists.koha.org/mailman/listinfo/koha-patches
