From d0e954f07780ee06071e874c6a21fd951a5d6fda Mon Sep 17 00:00:00 2001 From: ultramage Date: Thu, 3 Apr 2008 12:46:55 +0000 Subject: 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 --- sql-files/main.sql | 4 ++-- sql-files/upgrade_svn12464.sql | 2 ++ 2 files changed, 4 insertions(+), 2 deletions(-) create mode 100644 sql-files/upgrade_svn12464.sql (limited to 'sql-files') 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' -- cgit v1.2.3-60-g2f50