diff options
| author | skotlex <skotlex@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2006-09-05 14:29:51 +0000 |
|---|---|---|
| committer | skotlex <skotlex@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2006-09-05 14:29:51 +0000 |
| commit | 60528c704e9acff79f6a0615a8621c12a7c0ebd7 (patch) | |
| tree | 745e222247d0a1d4a8888d754bcdf36633471e37 /sql-files | |
| parent | 01178e5cbb6ab83262e4c13cc65fa094c00da4c2 (diff) | |
| download | hercules-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
Diffstat (limited to 'sql-files')
| -rw-r--r-- | sql-files/main.sql | 2 | ||||
| -rw-r--r-- | sql-files/upgrade_svn8630.sql | 1 |
2 files changed, 2 insertions, 1 deletions
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';
|