From fa0c6f874cb85db8cac41bf3a7be260686239e65 Mon Sep 17 00:00:00 2001
From: ultramage <ultramage@54d463be-8e91-2dee-dedb-b68131a5f0ec>
Date: Thu, 10 Jan 2008 15:35:23 +0000
Subject: 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
---
 sql-files/main.sql             | 8 ++++----
 sql-files/upgrade_svn12043.sql | 5 +++++
 2 files changed, 9 insertions(+), 4 deletions(-)
 create mode 100644 sql-files/upgrade_svn12043.sql

(limited to 'sql-files')

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 '';
-- 
cgit v1.2.3-60-g2f50