From 60528c704e9acff79f6a0615a8621c12a7c0ebd7 Mon Sep 17 00:00:00 2001 From: skotlex Date: Tue, 5 Sep 2006 14:29:51 +0000 Subject: - Fixed connect_until field being a smallint rather than int in the login table (upgrade with upgrade_svn8630.sql) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8630 54d463be-8e91-2dee-dedb-b68131a5f0ec --- sql-files/main.sql | 2 +- sql-files/upgrade_svn8630.sql | 1 + 2 files changed, 2 insertions(+), 1 deletion(-) create mode 100644 sql-files/upgrade_svn8630.sql (limited to 'sql-files') diff --git a/sql-files/main.sql b/sql-files/main.sql index ecf8fd01b..17846b319 100644 --- a/sql-files/main.sql +++ b/sql-files/main.sql @@ -400,7 +400,7 @@ CREATE TABLE `login` ( `email` varchar(60) NOT NULL default '', `level` tinyint(3) NOT NULL default '0', `error_message` smallint(11) unsigned NOT NULL default '0', - `connect_until` smallint(11) unsigned NOT NULL default '0', + `connect_until` 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', diff --git a/sql-files/upgrade_svn8630.sql b/sql-files/upgrade_svn8630.sql new file mode 100644 index 000000000..a94dbf116 --- /dev/null +++ b/sql-files/upgrade_svn8630.sql @@ -0,0 +1 @@ +ALTER TABLE `login` MODIFY `connect_until` int(11) unsigned NOT NULL default '0'; -- cgit v1.2.3-60-g2f50