summaryrefslogtreecommitdiff
path: root/sql-files/upgrade_svn12043.sql
diff options
context:
space:
mode:
authorultramage <ultramage@54d463be-8e91-2dee-dedb-b68131a5f0ec>2008-01-10 15:35:23 +0000
committerultramage <ultramage@54d463be-8e91-2dee-dedb-b68131a5f0ec>2008-01-10 15:35:23 +0000
commitfa0c6f874cb85db8cac41bf3a7be260686239e65 (patch)
treeda469937c15095baa50e7b4547cecfdfee0c6741 /sql-files/upgrade_svn12043.sql
parenta2185d8ccf800a0d5412a19404218c7a99921fdf (diff)
downloadhercules-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/upgrade_svn12043.sql')
-rw-r--r--sql-files/upgrade_svn12043.sql5
1 files changed, 5 insertions, 0 deletions
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 '';