From 14f6017a5b84d70320bde9d6e074ea8ac948a85e Mon Sep 17 00:00:00 2001
From: Arun Persaud <arun@nubati.net>
Date: Sat, 22 Sep 2012 12:38:58 -0700
Subject: 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
---
 create_database.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'create_database.sql')

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',
-- 
cgit v1.2.3-18-g5258

