summaryrefslogtreecommitdiffstats
path: root/create_database.sql
diff options
context:
space:
mode:
authorArun Persaud <arun@nubati.net>2012-09-22 12:38:58 -0700
committerArun Persaud <arun@nubati.net>2012-09-22 12:46:27 -0700
commit14f6017a5b84d70320bde9d6e074ea8ac948a85e (patch)
tree6ad038518dff9737042501929a8919f622652c8d /create_database.sql
parent90e831805a19358ab5a76c569181f72bc3534cb8 (diff)
downloade-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.sql4
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',