diff options
| author | Lance <Lance@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2006-05-31 08:44:43 +0000 |
|---|---|---|
| committer | Lance <Lance@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2006-05-31 08:44:43 +0000 |
| commit | f2fd4a251da74bb8311c321e800f8fce9f5e5fef (patch) | |
| tree | 89c1589e3348e636cad26312c024380dc30c8180 /sql-files/upgrade_svn6868.sql | |
| parent | 28b5e759f5e55f9b9ba508403dce2d02b98c154b (diff) | |
| download | hercules-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.sql | 3 |
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 |