diff options
| author | ultramage <ultramage@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2008-01-10 15:35:23 +0000 |
|---|---|---|
| committer | ultramage <ultramage@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2008-01-10 15:35:23 +0000 |
| commit | fa0c6f874cb85db8cac41bf3a7be260686239e65 (patch) | |
| tree | da469937c15095baa50e7b4547cecfdfee0c6741 /sql-files | |
| parent | a2185d8ccf800a0d5412a19404218c7a99921fdf (diff) | |
| download | hercules-fa0c6f874cb85db8cac41bf3a7be260686239e65.tar.gz hercules-fa0c6f874cb85db8cac41bf3a7be260686239e65.tar.bz2 hercules-fa0c6f874cb85db8cac41bf3a7be260686239e65.tar.xz hercules-fa0c6f874cb85db8cac41bf3a7be260686239e65.zip | |
Another round of login server cleaning
* fixed passwordencrypt on SQL not behaving correctly (since r10753)
* corrected some column lengths in the login db (username, password,...)
* fixed some places which used wfifo without first reallocating it
* removed interserver packet 0x7532 (Request to end connection), as there was no code that actually sent this packet
* moved RFIFOSKIP actions to execute as soon as possible
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12043 54d463be-8e91-2dee-dedb-b68131a5f0ec
Diffstat (limited to 'sql-files')
| -rw-r--r-- | sql-files/main.sql | 8 | ||||
| -rw-r--r-- | sql-files/upgrade_svn12043.sql | 5 |
2 files changed, 9 insertions, 4 deletions
diff --git a/sql-files/main.sql b/sql-files/main.sql index e19b7567f..5c5a7a0e6 100644 --- a/sql-files/main.sql +++ b/sql-files/main.sql @@ -93,7 +93,7 @@ CREATE TABLE `charlog` ( `char_msg` varchar(255) NOT NULL default 'char select', `account_id` int(11) NOT NULL default '0', `char_num` tinyint(4) NOT NULL default '0', - `name` varchar(255) NOT NULL default '', + `name` varchar(23) NOT NULL default '', `str` int(11) unsigned NOT NULL default '0', `agi` int(11) unsigned NOT NULL default '0', `vit` int(11) unsigned NOT NULL default '0', @@ -392,8 +392,8 @@ CREATE TABLE `ipbanlist` ( DROP TABLE IF EXISTS `login`; CREATE TABLE `login` ( `account_id` int(11) unsigned NOT NULL auto_increment, - `userid` varchar(255) NOT NULL default '', - `user_pass` varchar(32) NOT NULL default '', + `userid` varchar(23) NOT NULL default '', + `user_pass` varchar(23) NOT NULL default '', `lastlogin` datetime NOT NULL default '0000-00-00 00:00:00', `sex` enum('M','F','S') NOT NULL default 'M', `logincount` mediumint(9) unsigned NOT NULL default '0', @@ -453,7 +453,7 @@ DROP TABLE IF EXISTS `loginlog`; CREATE TABLE `loginlog` ( `time` datetime NOT NULL default '0000-00-00 00:00:00', `ip` int(10) unsigned NOT NULL default '0', - `user` varchar(32) NOT NULL default '', + `user` varchar(23) NOT NULL default '', `rcode` tinyint(4) NOT NULL default '0', `log` varchar(255) NOT NULL default '', INDEX (`ip`) diff --git a/sql-files/upgrade_svn12043.sql b/sql-files/upgrade_svn12043.sql new file mode 100644 index 000000000..c811bab91 --- /dev/null +++ b/sql-files/upgrade_svn12043.sql @@ -0,0 +1,5 @@ +ALTER TABLE `login` MODIFY COLUMN `userid` VARCHAR(23) NOT NULL default ''; +ALTER TABLE `login` MODIFY COLUMN `user_pass` VARCHAR(23) NOT NULL default ''; + +ALTER TABLE `loginlog` MODIFY COLUMN `user` VARCHAR(23) NOT NULL default ''; +ALTER TABLE `charlog` MODIFY COLUMN `name` VARCHAR(23) NOT NULL default ''; |