From f57d0d490ec5c985dc44d27c9fd3f74aca0a44d7 Mon Sep 17 00:00:00 2001
From: skotlex <skotlex@54d463be-8e91-2dee-dedb-b68131a5f0ec>
Date: Thu, 11 May 2006 21:26:14 +0000
Subject: - Fixed the definition of the KEY in the loginlog, thanks to
 TheUltraMage

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6559 54d463be-8e91-2dee-dedb-b68131a5f0ec
---
 Changelog-Trunk.txt | 2 ++
 sql-files/main.sql  | 2 +-
 2 files changed, 3 insertions(+), 1 deletion(-)

diff --git a/Changelog-Trunk.txt b/Changelog-Trunk.txt
index f9f5018a5..8e40c2e58 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/05/11
+	* Fixed the definition of the KEY in the loginlog, thanks to TheUltraMage
+	  [Skotlex]
 	* NPC_POWERUP and NPC_AGIUP now cause a increase in hit/flee (respectively)
 	  of 40% per level. [Skotlex]
 	* Changed a bit the MAX_ZENY checks in trade.c to prevent overflows.
diff --git a/sql-files/main.sql b/sql-files/main.sql
index 718f811e9..eb77388fa 100644
--- a/sql-files/main.sql
+++ b/sql-files/main.sql
@@ -411,7 +411,7 @@ CREATE TABLE `loginlog` (
   `user` varchar(32) NOT NULL default '',
   `rcode` tinyint(4) NOT NULL default '0',
   `log` varchar(255) NOT NULL default ''
-  KEY (`ip`),
+  INDEX (`ip`),
 ) TYPE=MyISAM;
 
 --
-- 
cgit v1.2.3-70-g09d2