From f2fd4a251da74bb8311c321e800f8fce9f5e5fef Mon Sep 17 00:00:00 2001 From: Lance Date: Wed, 31 May 2006 08:44:43 +0000 Subject: [Improved]: - SQL upgrade file for the new loginlog. Thanks to ultramage. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6883 54d463be-8e91-2dee-dedb-b68131a5f0ec --- sql-files/upgrade_svn6868.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'sql-files') diff --git a/sql-files/upgrade_svn6868.sql b/sql-files/upgrade_svn6868.sql index dc9d69906..000237297 100644 --- a/sql-files/upgrade_svn6868.sql +++ b/sql-files/upgrade_svn6868.sql @@ -1 +1,2 @@ -ALTER TABLE `loginlog` CHANGE `ip` `ip` INT( 10 ) UNSIGNED NOT NULL; +UPDATE `loginlog` SET `ip` = inet_aton(`ip`); +ALTER TABLE `loginlog` CHANGE `ip` `ip` INT( 10 ) UNSIGNED ZEROFILL NOT NULL DEFAULT '0'; \ No newline at end of file -- cgit v1.2.3-70-g09d2