Index: lams_common/db/sql/insert_users.sql =================================================================== diff -u -r8a4d69bf6159f6bcd910eb930d77016e255619e9 -r97aa67b6a42f9850df8cf58cdb99e159868219e2 --- lams_common/db/sql/insert_users.sql (.../insert_users.sql) (revision 8a4d69bf6159f6bcd910eb930d77016e255619e9) +++ lams_common/db/sql/insert_users.sql (.../insert_users.sql) (revision 97aa67b6a42f9850df8cf58cdb99e159868219e2) @@ -70,15 +70,15 @@ INSERT INTO lams_organisation (organisation_id, name, code, description, parent_organisation_id, organisation_type_id, create_date, workspace_id, locale_language, locale_country, organisation_state_id) VALUES (1, 'Root', null, 'Root Organisation',null,1,NOW(),1,'en','AU',1); INSERT INTO lams_organisation (organisation_id, name, code, description, parent_organisation_id, organisation_type_id, create_date, workspace_id, locale_language, locale_country, organisation_state_id) - VALUES (2, 'Playpen', 'PP101', 'Developers Playpen',1,2,NOW(),2,'en','US',1); + VALUES (2, 'Playpen', 'PP101', 'Developers Playpen',1,2,NOW(),2,'en','AU',1); INSERT INTO lams_organisation (organisation_id, name, code, description, parent_organisation_id, organisation_type_id, create_date, workspace_id, locale_language, locale_country, organisation_state_id) - VALUES (3, 'Everybody', null, 'All People In Course',2,3,NOW(),null,'en','US',1); + VALUES (3, 'Everybody', null, 'All People In Course',2,3,NOW(),null,'en','AU',1); INSERT INTO lams_organisation (organisation_id, name, code, description, parent_organisation_id, organisation_type_id, create_date, workspace_id, locale_language, locale_country, organisation_state_id) - VALUES (4, 'Mathematics 1', 'MATH111', 'Mathematics 1',1,2,NOW(),3,'zh','CN',1); + VALUES (4, 'Mathematics 1', 'MATH111', 'Mathematics 1',1,2,NOW(),3,'zh','',1); INSERT INTO lams_organisation (organisation_id, name, code, description, parent_organisation_id, organisation_type_id, create_date, workspace_id, locale_language, locale_country, organisation_state_id) - VALUES (5, 'Tutorial Group A', 'TUTA', 'Tutorial Group A',4,3,NOW(),null,'zh','CN',1); + VALUES (5, 'Tutorial Group A', 'TUTA', 'Tutorial Group A',4,3,NOW(),null,'zh','',1); INSERT INTO lams_organisation (organisation_id, name, code, description, parent_organisation_id, organisation_type_id, create_date, workspace_id, locale_language, locale_country, organisation_state_id) - VALUES (6, 'Tutorial Group B', 'TUTB', 'Tutorial Group B',4,3,NOW(),null,'zh','CN',1); + VALUES (6, 'Tutorial Group B', 'TUTB', 'Tutorial Group B',4,3,NOW(),null,'zh','',1); -- users INSERT INTO lams_user (user_id,login,password,title,first_name,last_name,address_line_1,address_line_2,address_line_3,