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.91 -r1.92
--- lams_common/db/sql/insert_types_data.sql	6 Nov 2009 06:48:33 -0000	1.91
+++ lams_common/db/sql/insert_types_data.sql	5 Jan 2010 01:21:10 -0000	1.92
@@ -288,6 +288,8 @@
 VALUES (25, 'ms', 'MY', 'Malay (Malaysia)', 'LTR', 'ms');
 INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction, fckeditor_code) 
 VALUES (26, 'tr', 'TR', 'Türkçe', 'LTR', 'tr');
+INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction, fckeditor_code) 
+VALUES (27, 'ca', 'ES', 'Català', 'LTR', 'ca');
 
 -- which current tool supports the old 1.0.x tools?
 INSERT INTO lams_tool_import_support VALUES (1, 'lafrum11', 'messageboard');
@@ -309,4 +311,4 @@
   (1,'moodle','moodle','moodle','moodle','mdl','http://localhost/moodle/mod/lamstwo/userinfo.php?ts=%timestamp%&un=%username%&hs=%hash%', '', 'http://dummy','\0',7);
 
 -- initialise db version
-INSERT INTO patches VALUES ('lams', 02040002, NOW(), 'F');
\ No newline at end of file
+INSERT INTO patches VALUES ('lams', 02040002, NOW(), 'F');
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.17 -r1.18
--- lams_common/db/sql/shaun/all.sql	28 Aug 2009 05:04:04 -0000	1.17
+++ lams_common/db/sql/shaun/all.sql	5 Jan 2010 01:21:10 -0000	1.18
@@ -625,7 +625,7 @@
 -- tr_TR
 -- 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(36,null,'Malay Workspace',36,now(),now(),1);
+values(36,null,'Turkish Workspace',36,now(),now(),1);
 insert into lams_workspace (workspace_id, default_fld_id, name) values (36,36,'Turkish 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,
@@ -646,4 +646,28 @@
 INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (226,81,5);
 INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (227,81,2);
 
+-- ca_ES
+-- 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(37,null,'Catalan Workspace',37,now(),now(),1);
+insert into lams_workspace (workspace_id, default_fld_id, name) values (37,37,'Catalan 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(37,'catalan','catalan','Dr','Catalan','Test','37','Las Ramblas',null,'Barcelona',null,'Catalunya',
+'0211111111','0211111112','0411111111','0211111113','catalan@example.com',0,'20100105',1,37,1,2,27);
+
+-- 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 (82, 2, 37);
+INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (83, 3, 37);
+
+-- 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 (228,82,3);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (229,82,5);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (230,82,2);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (231,83,4);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (232,83,5);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (233,83,2);
+
 update lams_user set password=SHA1(password) where user_id>8;