From 08473537fcea7e14b049b0fba86d5f49bed01f2c Mon Sep 17 00:00:00 2001 From: ultramage Date: Sat, 19 May 2007 09:46:11 +0000 Subject: * SQL files fixup - extended convert_engine_myisam and added innodb version - changed the max. email length to 39 (to match value in source code) - added comment for storage/guild storage picklog entries - changed SETs to ENUMs, which is the proper data type in logs - fixed incorrect defaults, shortened mapname lengths to 11 - use upgrade_svn10575_*.sql to apply changes git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@10575 54d463be-8e91-2dee-dedb-b68131a5f0ec --- sql-files/convert_engine.sql | 22 ---------------------- 1 file changed, 22 deletions(-) delete mode 100644 sql-files/convert_engine.sql (limited to 'sql-files/convert_engine.sql') diff --git a/sql-files/convert_engine.sql b/sql-files/convert_engine.sql deleted file mode 100644 index 9db50748e..000000000 --- a/sql-files/convert_engine.sql +++ /dev/null @@ -1,22 +0,0 @@ --- --- eAthena Database Converter ( InnoDB -> MyISAM ) by Jaguar --- - -ALTER TABLE `sc_data` DROP FOREIGN KEY `scdata_ibfk_1`, DROP FOREIGN KEY `scdata_ibfk_2`; -ALTER TABLE `guild` DROP FOREIGN KEY `guild_ibfk_1`; -ALTER TABLE `guild_alliance` DROP FOREIGN KEY `guild_alliance_ibfk_1`, DROP FOREIGN KEY `guild_alliance_ibfk_2`; -ALTER TABLE `guild_expulsion` DROP FOREIGN KEY `guild_expulsion_ibfk_1`; -ALTER TABLE `guild_member` DROP FOREIGN KEY `guild_member_ibfk_1`, DROP FOREIGN KEY `guild_member_ibfk_2`; -ALTER TABLE `guild_position` DROP FOREIGN KEY `guild_position_ibfk_1`; -ALTER TABLE `guild_skill` DROP FOREIGN KEY `guild_skill_ibfk_1`; -ALTER TABLE `guild_storage` DROP FOREIGN KEY `guild_storage_ibfk_1`; -ALTER TABLE `sc_data` TYPE = MYISAM; -ALTER TABLE `login` TYPE = MYISAM; -ALTER TABLE `char` TYPE = MYISAM; -ALTER TABLE `guild` TYPE = MYISAM; -ALTER TABLE `guild_alliance` TYPE = MYISAM; -ALTER TABLE `guild_expulsion` TYPE = MYISAM; -ALTER TABLE `guild_member` TYPE = MYISAM; -ALTER TABLE `guild_position` TYPE = MYISAM; -ALTER TABLE `guild_skill` TYPE = MYISAM; -ALTER TABLE `guild_storage` TYPE = MYISAM; -- cgit v1.2.3-70-g09d2