summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorskotlex <skotlex@54d463be-8e91-2dee-dedb-b68131a5f0ec>2006-09-05 14:29:51 +0000
committerskotlex <skotlex@54d463be-8e91-2dee-dedb-b68131a5f0ec>2006-09-05 14:29:51 +0000
commit60528c704e9acff79f6a0615a8621c12a7c0ebd7 (patch)
tree745e222247d0a1d4a8888d754bcdf36633471e37
parent01178e5cbb6ab83262e4c13cc65fa094c00da4c2 (diff)
downloadhercules-60528c704e9acff79f6a0615a8621c12a7c0ebd7.tar.gz
hercules-60528c704e9acff79f6a0615a8621c12a7c0ebd7.tar.bz2
hercules-60528c704e9acff79f6a0615a8621c12a7c0ebd7.tar.xz
hercules-60528c704e9acff79f6a0615a8621c12a7c0ebd7.zip
- 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
-rw-r--r--Changelog-Trunk.txt3
-rw-r--r--sql-files/main.sql2
-rw-r--r--sql-files/upgrade_svn8630.sql1
3 files changed, 5 insertions, 1 deletions
diff --git a/Changelog-Trunk.txt b/Changelog-Trunk.txt
index 3a4810cac..cd0db0742 100644
--- a/Changelog-Trunk.txt
+++ b/Changelog-Trunk.txt
@@ -3,6 +3,9 @@ Date Added
AS OF SVN REV. 5091, WE ARE NOW USING TRUNK. ALL UNTESTED BUGFIXES/FEATURES GO INTO TRUNK.
IF YOU HAVE A WORKING AND TESTED BUGFIX PUT IT INTO STABLE AS WELL AS TRUNK.
+2006/09/05
+ * Fixed connect_until field being a smallint rather than int in the login
+ table (upgrade with upgrade_svn8630.sql) [Skotlex]
2006/09/04
* Fixed crash when using Adaptation during an Encore. [Skotlex]
* Should have fixed manner being reset to 0 on logout while muted.
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';