From 3e87e8e3153ec82d1c3c2cea32dd910323949455 Mon Sep 17 00:00:00 2001
From: skotlex <skotlex@54d463be-8e91-2dee-dedb-b68131a5f0ec>
Date: Tue, 9 May 2006 19:28:58 +0000
Subject: - Fix on pc_skill which fixes overlapping when one gets more than one
 bonus for the same skill. - Updated main.sql's loginlog table structure. -
 Added svn_update6533.sql to update the loginlog structure as suggested by
 theultramage.

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6533 54d463be-8e91-2dee-dedb-b68131a5f0ec
---
 sql-files/main.sql            | 3 ++-
 sql-files/upgrade_svn6533.sql | 2 ++
 2 files changed, 4 insertions(+), 1 deletion(-)
 create mode 100644 sql-files/upgrade_svn6533.sql

(limited to 'sql-files')

diff --git a/sql-files/main.sql b/sql-files/main.sql
index f60f36594..718f811e9 100644
--- a/sql-files/main.sql
+++ b/sql-files/main.sql
@@ -407,10 +407,11 @@ CREATE TABLE `sc_data` (
 DROP TABLE IF EXISTS `loginlog`;
 CREATE TABLE `loginlog` (
   `time` datetime NOT NULL default '0000-00-00 00:00:00',
-  `ip` varchar(64) NOT NULL default '',
+  `ip` char(15) NOT NULL default '',
   `user` varchar(32) NOT NULL default '',
   `rcode` tinyint(4) NOT NULL default '0',
   `log` varchar(255) NOT NULL default ''
+  KEY (`ip`),
 ) TYPE=MyISAM;
 
 --
diff --git a/sql-files/upgrade_svn6533.sql b/sql-files/upgrade_svn6533.sql
new file mode 100644
index 000000000..5dffe0293
--- /dev/null
+++ b/sql-files/upgrade_svn6533.sql
@@ -0,0 +1,2 @@
+ALTER TABLE `loginlog` CHANGE `ip` `ip` CHAR( 15 ) NOT NULL
+ALTER TABLE `loginlog` ADD INDEX ( `ip` ( 15 ) )
-- 
cgit v1.2.3-60-g2f50