diff options
| author | ultramage <ultramage@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2008-04-03 12:46:55 +0000 |
|---|---|---|
| committer | ultramage <ultramage@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2008-04-03 12:46:55 +0000 |
| commit | d0e954f07780ee06071e874c6a21fd951a5d6fda (patch) | |
| tree | a87399e2e7832889cdc66e03bba4534d75f22d74 /sql-files | |
| parent | f21ecb9bfff371fb5db70fd3423673391e610ee9 (diff) | |
| download | hercules-d0e954f07780ee06071e874c6a21fd951a5d6fda.tar.gz hercules-d0e954f07780ee06071e874c6a21fd951a5d6fda.tar.bz2 hercules-d0e954f07780ee06071e874c6a21fd951a5d6fda.tar.xz hercules-d0e954f07780ee06071e874c6a21fd951a5d6fda.zip | |
Renamed 'connect_until_time' to 'expiration_time'.
Renamed 'ban_until_time' to 'unban_time'.
this also applies to login table columns (see upgrade_svn12464.sql).
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12464 54d463be-8e91-2dee-dedb-b68131a5f0ec
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'
|