summaryrefslogtreecommitdiff
path: root/sql-files
diff options
context:
space:
mode:
authorultramage <ultramage@54d463be-8e91-2dee-dedb-b68131a5f0ec>2008-01-10 20:57:56 +0000
committerultramage <ultramage@54d463be-8e91-2dee-dedb-b68131a5f0ec>2008-01-10 20:57:56 +0000
commitf9e689d36895ff10c03fc3c488da28693636d454 (patch)
treed3d4bdcb1f7b04c450aaf50ebdc9c958d6ab3e78 /sql-files
parentaf5a784f2c5aef2055b3133b82b1eff4a5e64e75 (diff)
downloadhercules-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
Diffstat (limited to 'sql-files')
-rw-r--r--sql-files/main.sql2
-rw-r--r--sql-files/upgrade_svn12043.sql2
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 '';