diff options
| author | ultramage <ultramage@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2008-01-10 20:57:56 +0000 |
|---|---|---|
| committer | ultramage <ultramage@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2008-01-10 20:57:56 +0000 |
| commit | f9e689d36895ff10c03fc3c488da28693636d454 (patch) | |
| tree | d3d4bdcb1f7b04c450aaf50ebdc9c958d6ab3e78 | |
| parent | af5a784f2c5aef2055b3133b82b1eff4a5e64e75 (diff) | |
| download | hercules-f9e689d36895ff10c03fc3c488da28693636d454.tar.gz hercules-f9e689d36895ff10c03fc3c488da28693636d454.tar.bz2 hercules-f9e689d36895ff10c03fc3c488da28693636d454.tar.xz hercules-f9e689d36895ff10c03fc3c488da28693636d454.zip | |
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
| -rw-r--r-- | sql-files/main.sql | 2 | ||||
| -rw-r--r-- | 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 ''; |