Index: lams_common/db/sql/insert_users.sql
===================================================================
diff -u -rba7daf01c61baa25aa7ca3f26a8972640481dd66 -r0a5b7d7ed6f549400c3179f6756c5466e84564f1
--- lams_common/db/sql/insert_users.sql	(.../insert_users.sql)	(revision ba7daf01c61baa25aa7ca3f26a8972640481dd66)
+++ lams_common/db/sql/insert_users.sql	(.../insert_users.sql)	(revision 0a5b7d7ed6f549400c3179f6756c5466e84564f1)
@@ -74,7 +74,7 @@
 city,state,country,day_phone,evening_phone,mobile_phone,fax,email,
 disabled_flag,create_date,authentication_method_id,workspace_id,
 locale_language, locale_country, flash_theme_id, html_theme_id)
-VALUES(1, 'sysadmin','sysadmin','Mr','Fei','Yang',null,null,null,
+VALUES(1, 'sysadmin',SHA1('sysadmin'),'Mr','Fei','Yang',null,null,null,
 'Sydney','NSW','Australia',null,null,null,null,'fyang@melcoe.mq.edu.au',
 0,NOW(),1,null,
 'en','au',1,3);
@@ -83,7 +83,7 @@
 city,state,country,day_phone,evening_phone,mobile_phone,fax,email,
 disabled_flag,create_date,authentication_method_id,workspace_id,
 locale_language, locale_country, flash_theme_id, html_theme_id)
-VALUES(2, 'test','test','Dr','Testing','LDAP',null,null,null,
+VALUES(2, 'test',SHA1('test'),'Dr','Testing','LDAP',null,null,null,
 'Sydney','NSW','Australia',null,null,null,null,'test@xx.xx.xx',
 0,NOW(),3,null,
 'mi','nz',1,3);
@@ -92,7 +92,7 @@
 city,state,country,day_phone,evening_phone,mobile_phone,fax,email,
 disabled_flag,create_date,authentication_method_id,workspace_id,
 locale_language, locale_country, flash_theme_id, html_theme_id)
-VALUES(3, 'lamskh01','dummy','Mr','Jacky','Fang',null,null,null,
+VALUES(3, 'lamskh01',SHA1('dummy'),'Mr','Jacky','Fang',null,null,null,
 'Sydney','NSW','Australia',null,null,null,null,'jfang@melcoe.mq.edu.au',
 0,NOW(),2,null,
 'en','nz',1,3);
@@ -103,7 +103,7 @@
 disabled_flag,create_date,authentication_method_id,workspace_id,
 flash_theme_id, html_theme_id)
 values
-(4,'mmm','mmm','Ms','Mary','Morgan','99','First Ave',null,
+(4,'mmm',SHA1('mmm'),'Ms','Mary','Morgan','99','First Ave',null,
 'Parramatta','NSW','Australia','0295099999','0298939999','0499999999',
 '0299999999','mmmmmmm@xx.os',
 0,'20041223',1,4,1,3);
@@ -114,7 +114,7 @@
 disabled_flag,create_date,authentication_method_id,workspace_id,
 flash_theme_id, html_theme_id)
 values
-(5,'test1','test1','Dr','One','Test','1','Test Ave',null,
+(5,'test1',SHA1('test1'),'Dr','One','Test','1','Test Ave',null,
 'Nowhere','NSW','Australia','0211111111','0211111112','0411111111',
 '0211111113','test1@xx.os',
 0,'20041223',1,5,1,3);
@@ -125,7 +125,7 @@
 disabled_flag,create_date,authentication_method_id,workspace_id,
 flash_theme_id, html_theme_id)
 values
-(6,'test2','test2','Dr','Two','Test','2','Test Ave',null,
+(6,'test2',SHA1('test2'),'Dr','Two','Test','2','Test Ave',null,
 'Nowhere','NSW','Australia','0211111111','0211111112','0411111111',
 '0211111113','test2@xx.os',
 0,'20041223',1,6,1,3);
@@ -136,7 +136,7 @@
 disabled_flag,create_date,authentication_method_id,workspace_id,
 flash_theme_id, html_theme_id)
 values
-(7,'test3','test3','Dr','Three','Test','3','Test Ave',null,
+(7,'test3',SHA1('test3'),'Dr','Three','Test','3','Test Ave',null,
 'Nowhere','NSW','Australia','0211111111','0211111112','0411111111',
 '0211111113','test3@xx.os',
 0,'20041223',1,7,1,3);
@@ -147,7 +147,7 @@
 disabled_flag,create_date,authentication_method_id,workspace_id,
 flash_theme_id, html_theme_id)
 values
-(8,'test4','test4','Dr','Four','Test','4','Test Ave',null,
+(8,'test4',SHA1('test4'),'Dr','Four','Test','4','Test Ave',null,
 'Nowhere','NSW','Australia','0211111111','0211111112','0411111111',
 '0211111113','test4@xx.os',
 0,'20041223',1,8,1,3);