Index: lams_common/db/sql/insert_types_data.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/sql/insert_types_data.sql,v
diff -u -r1.43 -r1.44
--- lams_common/db/sql/insert_types_data.sql	17 Aug 2006 02:19:15 -0000	1.43
+++ lams_common/db/sql/insert_types_data.sql	18 Aug 2006 05:20:07 -0000	1.44
@@ -198,6 +198,8 @@
 VALUES (17, 'el', null, 'Ελληνικά');
 INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description) 
 VALUES (18, 'nl', null, 'Nederlands');
+INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description) 
+VALUES (19, 'ar', 'JO', 'عربي');
 
 -- which current tool supports the old 1.0.x tools?
 INSERT INTO lams_tool_import_support VALUES (1, 'lafrum11', 'messageboard');
Index: lams_common/db/sql/shaun/all.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/sql/shaun/Attic/all.sql,v
diff -u -r1.2 -r1.3
--- lams_common/db/sql/shaun/all.sql	14 Aug 2006 06:18:22 -0000	1.2
+++ lams_common/db/sql/shaun/all.sql	18 Aug 2006 05:20:07 -0000	1.3
@@ -427,6 +427,30 @@
 INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (172,63,5);
 INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (173,63,2);
 
+
+
+-- 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(28,null,'Arabic Workspace',28,now(),now(),1);
+insert into lams_workspace (workspace_id, default_fld_id, name) values (28,28,'Arabic Test');
+--insert into lams_workspace_folder (workspace_id, workspace_folder_id) values (11,11);
+
+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(28,'arabic','arabic','Dr','Arabic','Test','28','Arabic Ave',null,'Amman',null,'Jordan','0211111111','0211111112','0411111111','0211111113','arabic@xx.os',0,'20041223',1,28,1,3,19);
+
+-- 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 (64, 2, 28);
+INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (65, 3, 28);
+
+-- 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 (174,64,3);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (175,64,5);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (176,64,2);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (177,65,4);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (178,65,5);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (179,65,2);
+
 SET FOREIGN_KEY_CHECKS=1;