diff options
author | Arun Persaud <arun@nubati.net> | 2012-09-22 12:38:58 -0700 |
---|---|---|
committer | Arun Persaud <arun@nubati.net> | 2012-09-22 12:46:27 -0700 |
commit | 14f6017a5b84d70320bde9d6e074ea8ac948a85e (patch) | |
tree | 6ad038518dff9737042501929a8919f622652c8d /create_database.sql | |
parent | 90e831805a19358ab5a76c569181f72bc3534cb8 (diff) | |
download | e-DoKo-14f6017a5b84d70320bde9d6e074ea8ac948a85e.tar.gz e-DoKo-14f6017a5b84d70320bde9d6e074ea8ac948a85e.tar.bz2 e-DoKo-14f6017a5b84d70320bde9d6e074ea8ac948a85e.zip |
updated to better password hash: use crypt instead of md5
the upgrade will be done automatically when a user logs in, password recovery is still based
on md5, but that should be OK, since it's a random generated password anyway
Diffstat (limited to 'create_database.sql')
-rw-r--r-- | create_database.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/create_database.sql b/create_database.sql index 3d5a1d4..dc70a0b 100644 --- a/create_database.sql +++ b/create_database.sql @@ -38,7 +38,7 @@ DROP TABLE IF EXISTS `Version`; CREATE TABLE `Version` ( - `version` int NOT NULL default '0' + `version` int NOT NULL default '5' ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- @@ -360,7 +360,7 @@ CREATE TABLE `User` ( `id` int(11) NOT NULL auto_increment, `fullname` varchar(64) default NULL, `email` varchar(64) default NULL, - `password` varchar(32) default NULL, + `password` varchar(62) default NULL, `timezone` varchar(64) default 'Europe/London', `last_login` timestamp NOT NULL default '0000-00-00 00:00:00', `create_date` timestamp NOT NULL default '0000-00-00 00:00:00', |