From: Andrew Moore <[email protected]> This patch cleans up kohastructure.sql a bit: * moved the table definition to above the ending comments * added a "drop table..." statement
Signed-off-by: Galen Charlton <[email protected]> --- 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 c6381b6..fe924e6 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -2300,19 +2300,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 time_zo...@old_time_zone */; -/*!40101 SET sql_mo...@old_sql_mode */; -/*!40014 SET foreign_key_chec...@old_foreign_key_checks */; -/*!40014 SET unique_chec...@old_unique_checks */; -/*!40101 SET character_set_clie...@old_character_set_client */; -/*!40101 SET character_set_resul...@old_character_set_results */; -/*!40101 SET collation_connecti...@old_collation_connection */; -/*!40111 SET sql_not...@old_sql_notes */; - -- -- 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, @@ -2320,4 +2312,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 time_zo...@old_time_zone */; +/*!40101 SET sql_mo...@old_sql_mode */; +/*!40014 SET foreign_key_chec...@old_foreign_key_checks */; +/*!40014 SET unique_chec...@old_unique_checks */; +/*!40101 SET character_set_clie...@old_character_set_client */; +/*!40101 SET character_set_resul...@old_character_set_results */; +/*!40101 SET collation_connecti...@old_collation_connection */; +/*!40111 SET sql_not...@old_sql_notes */; + -- 1.5.5.GIT _______________________________________________ Koha-patches mailing list [email protected] http://lists.koha.org/mailman/listinfo/koha-patches
