From f9e689d36895ff10c03fc3c488da28693636d454 Mon Sep 17 00:00:00 2001 From: ultramage Date: Thu, 10 Jan 2008 20:57:56 +0000 Subject: Fix to the sql files, password column length must be 32, to store md5 hashes =_= git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12049 54d463be-8e91-2dee-dedb-b68131a5f0ec --- sql-files/main.sql | 2 +- sql-files/upgrade_svn12043.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/sql-files/main.sql b/sql-files/main.sql index 5c5a7a0e6..f3d1a947c 100644 --- a/sql-files/main.sql +++ b/sql-files/main.sql @@ -393,7 +393,7 @@ DROP TABLE IF EXISTS `login`; CREATE TABLE `login` ( `account_id` int(11) unsigned NOT NULL auto_increment, `userid` varchar(23) NOT NULL default '', - `user_pass` varchar(23) NOT NULL default '', + `user_pass` varchar(32) 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', diff --git a/sql-files/upgrade_svn12043.sql b/sql-files/upgrade_svn12043.sql index c811bab91..7c3f0980b 100644 --- a/sql-files/upgrade_svn12043.sql +++ b/sql-files/upgrade_svn12043.sql @@ -1,5 +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 `login` MODIFY COLUMN `user_pass` VARCHAR(32) 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-70-g09d2