From 08473537fcea7e14b049b0fba86d5f49bed01f2c Mon Sep 17 00:00:00 2001
From: ultramage <ultramage@54d463be-8e91-2dee-dedb-b68131a5f0ec>
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

