Index: lams_common/build.xml
===================================================================
diff -u -r1c31dbd6b844bffd77d86babab9592e8267cc462 -r2e71958d5ce8fd25642197ffcf432754daa7cf00
--- lams_common/build.xml (.../build.xml) (revision 1c31dbd6b844bffd77d86babab9592e8267cc462)
+++ lams_common/build.xml (.../build.xml) (revision 2e71958d5ce8fd25642197ffcf432754daa7cf00)
@@ -276,6 +276,21 @@
+
Index: lams_common/db/sql/shaun/lams_user_bulgarian.sql
===================================================================
diff -u
--- lams_common/db/sql/shaun/lams_user_bulgarian.sql (revision 0)
+++ lams_common/db/sql/shaun/lams_user_bulgarian.sql (revision 2e71958d5ce8fd25642197ffcf432754daa7cf00)
@@ -0,0 +1,23 @@
+SET FOREIGN_KEY_CHECKS=0;
+
+-- need a new workspace_id and the name changes for each user.
+insert into lams_workspace_folder(workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id)
+values(11,null,'Bulgarian Workspace',11,11,now(),now(),1);
+insert into lams_workspace (workspace_id, root_folder_id, name) values (11,null,'Bulgarian 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_language,locale_country)
+values(11,'bulgarian','bulgarian','Dr','Bulgarian','Test','11','Bulgarian Ave',null,'Sofia',null,'Bulgaria','0211111111','0211111112','0411111111','0211111113','bulgarian@xx.os',0,'20041223',1,11,1,3,'bg',null);
+
+-- 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 (34, 2, 11);
+INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (35, 3, 11);
+
+-- need a new user_organisation_role_id for each row, use the same role_ids (3,4,6) for author, learner, teacher
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (82,34,3);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (83,34,4);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (84,34,6);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (85,35,4);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (86,35,6);
+
+SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file
Index: lams_common/db/sql/shaun/lams_user_chinese.sql
===================================================================
diff -u
--- lams_common/db/sql/shaun/lams_user_chinese.sql (revision 0)
+++ lams_common/db/sql/shaun/lams_user_chinese.sql (revision 2e71958d5ce8fd25642197ffcf432754daa7cf00)
@@ -0,0 +1,24 @@
+SET FOREIGN_KEY_CHECKS=0;
+
+-- need a new workspace_id and the name changes for each user.
+insert into lams_workspace_folder(workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id)
+values(12,null,'Chinese Workspace',12,12,now(),now(),1);
+insert into lams_workspace (workspace_id, root_folder_id, name) values (12,null,'Chinese 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_language,locale_country)
+values(12,'chinese','chinese','Dr','Chinese','Test','12','Chinese Ave',null,'Beijing',null,'China','0211111111','0211111112','0411111111','0211111113','chinese@xx.os',0,'20041223',1,12,1,3,'zh',null);
+
+-- 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 (36, 2, 12);
+INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (37, 3, 12);
+
+-- need a new user_organisation_role_id for each row, use the same role_ids (3,4,6) for author, learner, teacher
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (87,36,3);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (88,36,4);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (89,36,6);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (90,37,4);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (91,37,6);
+
+
+SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file
Index: lams_common/db/sql/shaun/lams_user_french.sql
===================================================================
diff -u
--- lams_common/db/sql/shaun/lams_user_french.sql (revision 0)
+++ lams_common/db/sql/shaun/lams_user_french.sql (revision 2e71958d5ce8fd25642197ffcf432754daa7cf00)
@@ -0,0 +1,23 @@
+SET FOREIGN_KEY_CHECKS=0;
+
+-- need a new workspace_id and the name changes for each user.
+insert into lams_workspace_folder(workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id)
+values(10,null,'French Workspace',10,10,now(),now(),1);
+insert into lams_workspace (workspace_id, root_folder_id, name) values (10,null,'French 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_language,locale_country)
+values(10,'french','french','Dr','French','Test','10','French Ave',null,'Paris',null,'France','0211111111','0211111112','0411111111','0211111113','french@xx.os',0,'20041223',1,10,1,3,'fr',null);
+
+-- 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 (32, 2, 10);
+INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (33, 3, 10);
+
+-- need a new user_organisation_role_id for each row, use the same role_ids (3,4,6) for author, learner, teacher
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (77,32,3);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (78,32,4);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (79,32,6);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (80,33,4);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (81,33,6);
+
+SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file
Index: lams_common/db/sql/shaun/lams_user_german.sql
===================================================================
diff -u
--- lams_common/db/sql/shaun/lams_user_german.sql (revision 0)
+++ lams_common/db/sql/shaun/lams_user_german.sql (revision 2e71958d5ce8fd25642197ffcf432754daa7cf00)
@@ -0,0 +1,23 @@
+SET FOREIGN_KEY_CHECKS=0;
+
+-- need a new workspace_id and the name changes for each user.
+insert into lams_workspace_folder(workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id)
+values(13,null,'German Workspace',13,13, now(),now(),1);
+insert into lams_workspace (workspace_id, root_folder_id, name) values (13,null,'German 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_language,locale_country)
+values(13,'german','german','Dr','German','Test','13', 'German Ave',null,'Berlin',null,'Germany','0211111111','0211111112','0411111111','0211111113','german@xx.os',0,'20041223',1,13,1,3,'de',null);
+
+-- 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 (38, 2, 13);
+INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (39, 3, 13);
+
+-- need a new user_organisation_role_id for each row, use the same role_ids (3,4,6) for author, learner, teacher
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (92,38,3);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (93,38,4);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (94,38,6);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (95,39,4);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (96,39,6);
+
+SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file
Index: lams_common/db/sql/shaun/lams_user_hungarian.sql
===================================================================
diff -u
--- lams_common/db/sql/shaun/lams_user_hungarian.sql (revision 0)
+++ lams_common/db/sql/shaun/lams_user_hungarian.sql (revision 2e71958d5ce8fd25642197ffcf432754daa7cf00)
@@ -0,0 +1,23 @@
+SET FOREIGN_KEY_CHECKS=0;
+
+-- need a new workspace_id and the name changes for each user.
+insert into lams_workspace_folder(workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id)
+values(21,null,'Hungarian Workspace',21,21, now(),now(),1);
+insert into lams_workspace (workspace_id, root_folder_id, name) values (21,null,'Hungarian 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_language,locale_country)
+values(21,'hungarian','hungarian','Dr','Hungarian','Test','21', 'Hungarian Ave',null,'Bukarest',null,'Hungry','0211111111','0211111112','0411111111','0211111113','hungarian@xx.os',0,'20041223',1,21,1,3,'hu',null);
+
+-- 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 (54, 2, 21);
+INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (55, 3, 21);
+
+-- need a new user_organisation_role_id for each row, use the same role_ids (3,4,6) for author, learner, teacher
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (132,54,3);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (133,54,4);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (134,54,6);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (135,55,4);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (136,55,6);
+
+SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file
Index: lams_common/db/sql/shaun/lams_user_italian.sql
===================================================================
diff -u
--- lams_common/db/sql/shaun/lams_user_italian.sql (revision 0)
+++ lams_common/db/sql/shaun/lams_user_italian.sql (revision 2e71958d5ce8fd25642197ffcf432754daa7cf00)
@@ -0,0 +1,24 @@
+SET FOREIGN_KEY_CHECKS=0;
+
+-- need a new workspace_id and the name changes for each user.
+insert into lams_workspace_folder(workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id)
+values(16,null,'Italian Workspace',16,16, now(),now(),1);
+insert into lams_workspace (workspace_id, root_folder_id, name) values (16,null,'Italian 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_language,locale_country)
+values(16,'italian','italian','Dr','Italian','Test','16', 'Italian Ave',null,'Rome',null,'Italy','0211111111','0211111112','0411111111','0211111113','italian@xx.os',0,'20041223',1,16,1,3,'it',null);
+
+-- 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 (44, 2, 16);
+INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (45, 3, 16);
+
+-- need a new user_organisation_role_id for each row, use the same role_ids (3,4,6) for author, learner, teacher
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (107,44,3);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (108,44,4);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (109,44,6);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (110,45,4);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (111,45,6);
+
+
+SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file
Index: lams_common/db/sql/shaun/lams_user_korean.sql
===================================================================
diff -u
--- lams_common/db/sql/shaun/lams_user_korean.sql (revision 0)
+++ lams_common/db/sql/shaun/lams_user_korean.sql (revision 2e71958d5ce8fd25642197ffcf432754daa7cf00)
@@ -0,0 +1,24 @@
+SET FOREIGN_KEY_CHECKS=0;
+
+-- need a new workspace_id and the name changes for each user.
+insert into lams_workspace_folder(workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id)
+values(18,null,'Korean Workspace',18,18, now(),now(),1);
+insert into lams_workspace (workspace_id, root_folder_id, name) values (18,null,'Korean 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_language,locale_country)
+values(18,'korean','korean','Dr','Korean','Test','18', 'Korean Ave',null,'Seoul',null,'Korea','0211111111','0211111112','0411111111','0211111113','korean@xx.os',0,'20041223',1,18,1,3,'ko',null);
+
+-- 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 (48, 2, 18);
+INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (49, 3, 18);
+
+-- need a new user_organisation_role_id for each row, use the same role_ids (3,4,6) for author, learner, teacher
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (117,48,3);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (118,48,4);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (119,48,6);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (120,49,4);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (121,49,6);
+
+
+SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file
Index: lams_common/db/sql/shaun/lams_user_maori.sql
===================================================================
diff -u
--- lams_common/db/sql/shaun/lams_user_maori.sql (revision 0)
+++ lams_common/db/sql/shaun/lams_user_maori.sql (revision 2e71958d5ce8fd25642197ffcf432754daa7cf00)
@@ -0,0 +1,23 @@
+SET FOREIGN_KEY_CHECKS=0;
+
+-- need a new workspace_id and the name changes for each user.
+insert into lams_workspace_folder(workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id)
+values(20,null,'Maori Workspace',20,20, now(),now(),1);
+insert into lams_workspace (workspace_id, root_folder_id, name) values (20,null,'Maori 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_language,locale_country)
+values(20,'maori','maori','Dr','Maori','Test','20', 'Maori Ave',null,'Auckland',null,'New Zealand','0211111111','0211111112','0411111111','0211111113','maori@xx.os',0,'20041223',1,20,1,3,'mi','nz');
+
+-- 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 (52, 2, 20);
+INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (53, 3, 20);
+
+-- need a new user_organisation_role_id for each row, use the same role_ids (3,4,6) for author, learner, teacher
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (127,52,3);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (128,52,4);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (129,52,6);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (130,53,4);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (131,53,6);
+
+SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file
Index: lams_common/db/sql/shaun/lams_user_norwegian.sql
===================================================================
diff -u
--- lams_common/db/sql/shaun/lams_user_norwegian.sql (revision 0)
+++ lams_common/db/sql/shaun/lams_user_norwegian.sql (revision 2e71958d5ce8fd25642197ffcf432754daa7cf00)
@@ -0,0 +1,23 @@
+SET FOREIGN_KEY_CHECKS=0;
+
+-- need a new workspace_id and the name changes for each user.
+insert into lams_workspace_folder(workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id)
+values(14,null,'Norwegian Workspace',14,14, now(),now(),1);
+insert into lams_workspace (workspace_id, root_folder_id, name) values (14,null,'Norwegian 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_language,locale_country)
+values(14,'norwegian','norwegian','Dr','Norwegian','Test','14', 'Norwegian Ave',null,'Oslo',null,'Norway','0211111111','0211111112','0411111111','0211111113','norwegian@xx.os',0,'20041223',1,14,1,3,'no',null);
+
+-- 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 (40, 2, 14);
+INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (41, 3, 14);
+
+-- need a new user_organisation_role_id for each row, use the same role_ids (3,4,6) for author, learner, teacher
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (97,40,3);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (98,40,4);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (99,40,6);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (100,41,4);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (101,41,6);
+
+SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file
Index: lams_common/db/sql/shaun/lams_user_polish.sql
===================================================================
diff -u
--- lams_common/db/sql/shaun/lams_user_polish.sql (revision 0)
+++ lams_common/db/sql/shaun/lams_user_polish.sql (revision 2e71958d5ce8fd25642197ffcf432754daa7cf00)
@@ -0,0 +1,24 @@
+SET FOREIGN_KEY_CHECKS=0;
+
+-- need a new workspace_id and the name changes for each user.
+insert into lams_workspace_folder(workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id)
+values(17,null,'Polish Workspace',17,17, now(),now(),1);
+insert into lams_workspace (workspace_id, root_folder_id, name) values (17,null,'Polish 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_language,locale_country)
+values(17,'polish','polish','Dr','Polish','Test','17', 'Polish Ave',null,'Warsaw',null,'Poland','0211111111','0211111112','0411111111','0211111113','polish@xx.os',0,'20041223',1,17,1,3,'pl',null);
+
+-- 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 (46, 2, 17);
+INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (47, 3, 17);
+
+-- need a new user_organisation_role_id for each row, use the same role_ids (3,4,6) for author, learner, teacher
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (112,46,3);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (113,46,4);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (114,46,6);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (115,47,4);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (116,47,6);
+
+
+SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file
Index: lams_common/db/sql/shaun/lams_user_portbr.sql
===================================================================
diff -u
--- lams_common/db/sql/shaun/lams_user_portbr.sql (revision 0)
+++ lams_common/db/sql/shaun/lams_user_portbr.sql (revision 2e71958d5ce8fd25642197ffcf432754daa7cf00)
@@ -0,0 +1,23 @@
+SET FOREIGN_KEY_CHECKS=0;
+
+-- need a new workspace_id and the name changes for each user.
+insert into lams_workspace_folder(workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id)
+values(15,null,'Portuguese Workspace',15,15, now(),now(),1);
+insert into lams_workspace (workspace_id, root_folder_id, name) values (15,null,'Portuguese 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_language,locale_country)
+values(15,'portuguese','portuguese','Dr','Portuguese','Test','15', 'Portuguese Ave',null,'Brasilia',null,'Brazil','0211111111','0211111112','0411111111','0211111113','portuguese@xx.os',0,'20041223',1,15,1,3,'pt','br');
+
+-- 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 (42, 2, 15);
+INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (43, 3, 15);
+
+-- need a new user_organisation_role_id for each row, use the same role_ids (3,4,6) for author, learner, teacher
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (102,42,3);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (103,42,4);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (104,42,6);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (105,43,4);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (106,43,6);
+
+SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file
Index: lams_common/db/sql/shaun/lams_user_spanish.sql
===================================================================
diff -u
--- lams_common/db/sql/shaun/lams_user_spanish.sql (revision 0)
+++ lams_common/db/sql/shaun/lams_user_spanish.sql (revision 2e71958d5ce8fd25642197ffcf432754daa7cf00)
@@ -0,0 +1,24 @@
+SET FOREIGN_KEY_CHECKS=0;
+
+-- need a new workspace_id and the name changes for each user.
+insert into lams_workspace_folder(workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id)
+values(19,null,'Spanish Workspace',19,19, now(),now(),1);
+insert into lams_workspace (workspace_id, root_folder_id, name) values (19,null,'Spanish 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_language,locale_country)
+values(19,'spanish','spanish','Dr','Spanish','Test','19', 'Spanish Ave',null,'Madrid',null,'Spain','0211111111','0211111112','0411111111','0211111113','spanish@xx.os',0,'20041223',1,19,1,3,'es',null);
+
+-- 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 (50, 2, 19);
+INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (51, 3, 19);
+
+-- need a new user_organisation_role_id for each row, use the same role_ids (3,4,6) for author, learner, teacher
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (122,50,3);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (123,50,4);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (124,50,6);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (125,51,4);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (126,51,6);
+
+
+SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file
Index: lams_common/db/sql/shaun/lams_user_swedish.sql
===================================================================
diff -u
--- lams_common/db/sql/shaun/lams_user_swedish.sql (revision 0)
+++ lams_common/db/sql/shaun/lams_user_swedish.sql (revision 2e71958d5ce8fd25642197ffcf432754daa7cf00)
@@ -0,0 +1,24 @@
+SET FOREIGN_KEY_CHECKS=0;
+
+-- need a new workspace_id and the name changes for each user.
+insert into lams_workspace_folder(workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id)
+values(9,null,'Swedish Workspace',9,9,now(),now(),1);
+insert into lams_workspace (workspace_id, root_folder_id, name) values (9,9,'Swedish 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_language,locale_country)
+values(9,'swedish','swedish','Dr','Sweden','Test','9','Swedish Ave',null,'Stockholm',null,'Sweden','0211111111','0211111112','0411111111','0211111113','swedish@xx.os',0,'20041223',1,9,1,3,'sv',null);
+
+-- 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 (30, 2, 9);
+INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (31, 3, 9);
+
+-- need a new user_organisation_role_id for each row, use the same role_ids (3,4,6) for author, learner, teacher
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (72,30,3);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (73,30,4);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (74,30,6);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (75,31,4);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (76,31,6);
+
+
+SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file