Index: lams_common/db/sql/shaun/all.sql
===================================================================
diff -u -re90a09d59b85defc3e163b54698b326f842d9a63 -r5c156dd9fe8bc13cdf41a03a75fd17ba2a3b1ae8
--- lams_common/db/sql/shaun/all.sql	(.../all.sql)	(revision e90a09d59b85defc3e163b54698b326f842d9a63)
+++ lams_common/db/sql/shaun/all.sql	(.../all.sql)	(revision 5c156dd9fe8bc13cdf41a03a75fd17ba2a3b1ae8)
@@ -580,8 +580,8 @@
 
 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,disabled_flag,create_date,authentication_method_id,workspace_id, flash_theme_id,html_theme_id,locale_id)
-values(34,'japanese','japanese','Dr','Japanese','Test','33','Japanese Ave',null,'Tokyo',null,'Japan',
-'0211111111','0211111112','0411111111','0211111113','japanese@xx.os',0,'20041223',1,33,1,2,24);
+values(34,'japanese','japanese','Dr','Japanese','Test','34','Japanese Ave',null,'Tokyo',null,'Japan',
+'0211111111','0211111112','0411111111','0211111113','japanese@xx.os',0,'20041223',1,34,1,2,24);
 
 -- need a new user_organisation_id for each row, user_id must match user_id created in the lams_user
 -- belongs to course Playpen, Class Everybody
@@ -597,6 +597,30 @@
 INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (215,77,2);
 
 
+-- ms_MY
+-- need a new workspace_id and the name changes for each user.
+insert into lams_workspace_folder(workspace_folder_id,parent_folder_id,name,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id)
+values(35,null,'Malay Workspace',35,now(),now(),1);
+insert into lams_workspace (workspace_id, default_fld_id, name) values (35,35,'Malay Test');
+
+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,disabled_flag,create_date,authentication_method_id,workspace_id, flash_theme_id,html_theme_id,locale_id)
+values(35,'malay','malay','Dr','Malay','Test','35','Malay Ave',null,'Kuala Lumpur',null,'Malaysia',
+'0211111111','0211111112','0411111111','0211111113','malay@xx.os',0,'20041223',1,35,1,2,25);
+
+-- need a new user_organisation_id for each row, user_id must match user_id created in the lams_user
+-- belongs to course Playpen, Class Everybody
+INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (78, 2, 35);
+INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (79, 3, 35);
+
+-- need a new user_organisation_role_id for each row, use the same role_ids (3,5,2) for author, learner, teacher
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (210,78,3);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (211,78,5);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (212,78,2);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (213,79,4);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (214,79,5);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (215,79,2);
+
 SET FOREIGN_KEY_CHECKS=1;
 
 
