summaryrefslogtreecommitdiff
path: root/sql-files
diff options
context:
space:
mode:
Diffstat (limited to 'sql-files')
-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