From 3300d6861d4402be626816af041a8a1e1a1cfc48 Mon Sep 17 00:00:00 2001 From: skotlex Date: Tue, 12 Sep 2006 21:18:09 +0000 Subject: - 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 --- Changelog-Trunk.txt | 2 ++ conf-tmpl/Changelog.txt | 3 +++ conf-tmpl/login_athena.conf | 7 +++++-- sql-files/convert_engine.sql | 20 ++++++++++---------- 4 files changed, 20 insertions(+), 12 deletions(-) diff --git a/Changelog-Trunk.txt b/Changelog-Trunk.txt index c16b0ffa5..8e5358c99 100644 --- a/Changelog-Trunk.txt +++ b/Changelog-Trunk.txt @@ -4,6 +4,8 @@ AS OF SVN REV. 5091, WE ARE NOW USING TRUNK. ALL UNTESTED BUGFIXES/FEATURES GO IF YOU HAVE A WORKING AND TESTED BUGFIX PUT IT INTO STABLE AS WELL AS TRUNK. 2006/09/12 + * Updated convert_engine.sql to use TYPE instead of ENGINE to be compatible + with Mysql 4 installations. [Skotlex] * Moved the morph restrictions from skill_additional_effect to mob_class_change, so that SA_MONOCELL will not convert clones, emperium, or treasure boxes. [Skotlex] diff --git a/conf-tmpl/Changelog.txt b/conf-tmpl/Changelog.txt index 0244ea2e1..aa1c380ea 100644 --- a/conf-tmpl/Changelog.txt +++ b/conf-tmpl/Changelog.txt @@ -1,5 +1,8 @@ Date Added +2006/09/12 + * case_sensitive is now off by default due to performance issues + (login_athena.conf). [Skotlex] 2006/09/11 * Corrected name of config settings pc_luk_status_def, mob_luk_status_def (status.conf) [Skotlex] diff --git a/conf-tmpl/login_athena.conf b/conf-tmpl/login_athena.conf index c04dac984..beb6b6169 100644 --- a/conf-tmpl/login_athena.conf +++ b/conf-tmpl/login_athena.conf @@ -50,8 +50,11 @@ ladminallowip: all // This prevents usage of >& log.file console: off -// Are login's case sensitive? -case_sensitive: on +// Are login's case sensitive (SQL only)? +// WARNING: Note that turning this on will cause login queries to use BINARY +// searches, which disable the table's index and cause severe performance +// penalties on large tables. +case_sensitive: off // Gamemaster password, used with the @gm command to obtain GM commands (level of gm set with level_new_gm parameter). // NOTICE: You should also change this one. 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; -- cgit v1.2.3-60-g2f50