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.67 -r1.68
--- lams_common/db/sql/insert_types_data.sql	17 Jul 2007 01:34:13 -0000	1.67
+++ lams_common/db/sql/insert_types_data.sql	17 Sep 2007 05:41:43 -0000	1.68
@@ -251,6 +251,8 @@
 VALUES (22, 'vi', 'VN', 'Tiếng Việt', 'LTR');
 INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction) 
 VALUES (23, 'zh', 'TW', 'Chinese (Taiwan)', 'LTR');
+INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction) 
+VALUES (24, 'ja', 'JP', 'Japanese (Japan)', 'LTR');
 
 -- 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.10 -r1.11
--- lams_common/db/sql/shaun/all.sql	1 Dec 2006 03:33:37 -0000	1.10
+++ lams_common/db/sql/shaun/all.sql	17 Sep 2007 05:41:43 -0000	1.11
@@ -546,6 +546,57 @@
 INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (202,73,5);
 INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (203,73,2);
 
+
+-- zh_CN
+-- 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(33,null,'Chinese Workspace',33,now(),now(),1);
+insert into lams_workspace (workspace_id, default_fld_id, name) values (33,33,'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_id)
+values(33,'china','china','Dr','Chinese','Test','33','Chinese Ave',null,'Beijing',null,'China',
+'0211111111','0211111112','0411111111','0211111113','chinese@xx.os',0,'20041223',1,33,1,2,5);
+
+-- 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 (74, 2, 33);
+INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (75, 3, 33);
+
+-- 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 (204,74,3);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (205,74,5);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (206,74,2);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (207,75,4);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (208,75,5);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (209,75,2);
+
+
+-- ja_JP
+-- 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(34,null,'Japanese Workspace',34,now(),now(),1);
+insert into lams_workspace (workspace_id, default_fld_id, name) values (34,34,'Japanese 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(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);
+
+-- 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 (76, 2, 34);
+INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (77, 3, 34);
+
+-- 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,76,3);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (211,76,5);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (212,76,2);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (213,77,4);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (214,77,5);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (215,77,2);
+
+
 SET FOREIGN_KEY_CHECKS=1;