summaryrefslogtreecommitdiff
path: root/sql-files/upgrade_svn6868.sql
diff options
context:
space:
mode:
authorLance <Lance@54d463be-8e91-2dee-dedb-b68131a5f0ec>2006-05-31 08:44:43 +0000
committerLance <Lance@54d463be-8e91-2dee-dedb-b68131a5f0ec>2006-05-31 08:44:43 +0000
commitf2fd4a251da74bb8311c321e800f8fce9f5e5fef (patch)
tree89c1589e3348e636cad26312c024380dc30c8180 /sql-files/upgrade_svn6868.sql
parent28b5e759f5e55f9b9ba508403dce2d02b98c154b (diff)
downloadhercules-f2fd4a251da74bb8311c321e800f8fce9f5e5fef.tar.gz
hercules-f2fd4a251da74bb8311c321e800f8fce9f5e5fef.tar.bz2
hercules-f2fd4a251da74bb8311c321e800f8fce9f5e5fef.tar.xz
hercules-f2fd4a251da74bb8311c321e800f8fce9f5e5fef.zip
[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
Diffstat (limited to 'sql-files/upgrade_svn6868.sql')
-rw-r--r--sql-files/upgrade_svn6868.sql3
1 files changed, 2 insertions, 1 deletions
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