- 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

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;