summaryrefslogtreecommitdiff
path: root/sql-files/convert_engine.sql
diff options
context:
space:
mode:
authorskotlex <skotlex@54d463be-8e91-2dee-dedb-b68131a5f0ec>2006-09-12 21:18:09 +0000
committerskotlex <skotlex@54d463be-8e91-2dee-dedb-b68131a5f0ec>2006-09-12 21:18:09 +0000
commit3300d6861d4402be626816af041a8a1e1a1cfc48 (patch)
tree5dd9c465f304a3ff55eb8bdaec94f68e4f2f7249 /sql-files/convert_engine.sql
parent53c3ffb76f89f96279ddd950b2b3d011e854b4e1 (diff)
downloadhercules-3300d6861d4402be626816af041a8a1e1a1cfc48.tar.gz
hercules-3300d6861d4402be626816af041a8a1e1a1cfc48.tar.bz2
hercules-3300d6861d4402be626816af041a8a1e1a1cfc48.tar.xz
hercules-3300d6861d4402be626816af041a8a1e1a1cfc48.zip
- Updated convert_engine.sql to use TYPE instead of ENGINE to be compatible with Mysql 4 installations.
- case_sensitive is now off by default due to performance issues. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8726 54d463be-8e91-2dee-dedb-b68131a5f0ec
Diffstat (limited to 'sql-files/convert_engine.sql')
-rw-r--r--sql-files/convert_engine.sql20
1 files changed, 10 insertions, 10 deletions
diff --git a/sql-files/convert_engine.sql b/sql-files/convert_engine.sql
index ecff06072..98bdec409 100644
--- a/sql-files/convert_engine.sql
+++ b/sql-files/convert_engine.sql
@@ -10,13 +10,13 @@ ALTER TABLE `guild_member` DROP FOREIGN KEY `guild_member_ibfk_1`, DROP FOREIGN
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` ENGINE = MYISAM;
-ALTER TABLE `login` ENGINE = MYISAM;
-ALTER TABLE `char` ENGINE = MYISAM;
-ALTER TABLE `guild` ENGINE = MYISAM;
-ALTER TABLE `guild_alliance` ENGINE = MYISAM;
-ALTER TABLE `guild_expulsion` ENGINE = MYISAM;
-ALTER TABLE `guild_member` ENGINE = MYISAM;
-ALTER TABLE `guild_position` ENGINE = MYISAM;
-ALTER TABLE `guild_skill` ENGINE = MYISAM;
-ALTER TABLE `guild_storage` ENGINE = MYISAM;
+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;