Index: lams_common/db/sql/insert_lams_users.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/sql/insert_lams_users.sql,v
diff -u -r1.6.2.3 -r1.6.2.4
--- lams_common/db/sql/insert_lams_users.sql	30 Jun 2016 08:50:31 -0000	1.6.2.3
+++ lams_common/db/sql/insert_lams_users.sql	25 Nov 2016 00:48:13 -0000	1.6.2.4
@@ -101,7 +101,7 @@
 VALUES(1, 'sysadmin',SHA1('sysadmin'),'The','System','Administrator',null,null,null,
 'Sydney','NSW','Australia',null,null,null,null,'sysadmin@x.x',
 0,NOW(),1,51,
-1,1,2,28);
+1,1,2,'Etc/GMT');
 
 INSERT INTO lams_user (user_id,login,password,title,first_name,last_name,address_line_1,address_line_2,address_line_3,
 city,state,country,day_phone,evening_phone,mobile_phone,fax,email,
@@ -110,7 +110,7 @@
 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,
-3,1,2,28);
+3,1,2,'Etc/GMT');
 
 INSERT INTO lams_user (user_id,login,password,title,first_name,last_name,address_line_1,address_line_2,address_line_3,
 city,state,country,day_phone,evening_phone,mobile_phone,fax,email,
@@ -119,7 +119,7 @@
 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,
-1,1,2,28);
+1,1,2,'Etc/GMT');
 
 insert into lams_user (user_id,login,password,title,first_name,last_name,address_line_1,address_line_2,address_line_3,
 city,state,country,day_phone,evening_phone,mobile_phone,
@@ -130,7 +130,7 @@
 (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,1,2,28);
+0,'20041223',1,4,1,1,2,'Etc/GMT');
 
 insert into lams_user (user_id,login,password,title,first_name,last_name,address_line_1,address_line_2,address_line_3,
 city,state,country,day_phone,evening_phone,mobile_phone,
@@ -141,7 +141,7 @@
 (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,1,2,28);
+0,'20041223',1,5,1,1,2,'Etc/GMT');
 
 insert into lams_user (user_id,login,password,title,first_name,last_name,address_line_1,address_line_2,address_line_3,
 city,state,country,day_phone,evening_phone,mobile_phone,
@@ -152,7 +152,7 @@
 (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,1,2,28);
+0,'20041223',1,6,1,1,2,'Etc/GMT');
 
 insert into lams_user (user_id,login,password,title,first_name,last_name,address_line_1,address_line_2,address_line_3,
 city,state,country,day_phone,evening_phone,mobile_phone,
@@ -163,7 +163,7 @@
 (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,1,2,28);
+0,'20041223',1,7,1,1,2,'Etc/GMT');
 
 insert into lams_user (user_id,login,password,title,first_name,last_name,address_line_1,address_line_2,address_line_3,
 city,state,country,day_phone,evening_phone,mobile_phone,
@@ -174,7 +174,7 @@
 (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,1,2,28);
+0,'20041223',1,8,1,1,2,'Etc/GMT');
 
 --- sysadmin only belongs to root and public
 INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (1, 1, 1);