diff options
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 |