diff options
Diffstat (limited to 'sql-files')
| -rw-r--r-- | sql-files/main.sql | 4 | ||||
| -rw-r--r-- | sql-files/upgrade_svn12464.sql | 2 |
2 files changed, 4 insertions, 2 deletions
diff --git a/sql-files/main.sql b/sql-files/main.sql index 4b3b551cd..5ea065677 100644 --- a/sql-files/main.sql +++ b/sql-files/main.sql @@ -427,10 +427,10 @@ CREATE TABLE `login` ( `email` varchar(39) NOT NULL default '', `level` tinyint(3) NOT NULL default '0', `error_message` smallint(11) unsigned NOT NULL default '0', - `connect_until` int(11) unsigned NOT NULL default '0', + `expiration_time` int(11) unsigned NOT NULL default '0', `last_ip` varchar(100) NOT NULL default '', `memo` smallint(11) unsigned NOT NULL default '0', - `ban_until` int(11) unsigned NOT NULL default '0', + `unban_time` int(11) unsigned NOT NULL default '0', `state` int(11) unsigned NOT NULL default '0', PRIMARY KEY (`account_id`), KEY `name` (`userid`) diff --git a/sql-files/upgrade_svn12464.sql b/sql-files/upgrade_svn12464.sql new file mode 100644 index 000000000..85b1d336d --- /dev/null +++ b/sql-files/upgrade_svn12464.sql @@ -0,0 +1,2 @@ +ALTER TABLE `login` CHANGE `connect_until` `expiration_time` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0'
+ALTER TABLE `login` CHANGE `ban_until` `unban_time` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0'
|