Index: lams_common/db/sql/insert_types_data.sql
===================================================================
diff -u -ra9f90226ad1b3c5f88ce9d551cbec46c8e4bb005 -r9ea6e437478e6cb7bbb7a64a14a5f379df3e0b95
--- lams_common/db/sql/insert_types_data.sql	(.../insert_types_data.sql)	(revision a9f90226ad1b3c5f88ce9d551cbec46c8e4bb005)
+++ lams_common/db/sql/insert_types_data.sql	(.../insert_types_data.sql)	(revision 9ea6e437478e6cb7bbb7a64a14a5f379df3e0b95)
@@ -292,6 +292,8 @@
 VALUES (27, 'ca', 'ES', 'Català', 'LTR', 'ca');
 INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction, fckeditor_code) 
 VALUES (28, 'sl', 'SI', 'Slovenščina', 'LTR', 'sl');
+INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction, fckeditor_code) 
+VALUES (29, 'es', 'MX', 'Español (Mexico)', 'LTR', 'es');
 
 -- 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
===================================================================
diff -u -rab6d81f7bcbac1e35d83f6da2aa02d067b26f601 -r9ea6e437478e6cb7bbb7a64a14a5f379df3e0b95
--- lams_common/db/sql/shaun/all.sql	(.../all.sql)	(revision ab6d81f7bcbac1e35d83f6da2aa02d067b26f601)
+++ lams_common/db/sql/shaun/all.sql	(.../all.sql)	(revision 9ea6e437478e6cb7bbb7a64a14a5f379df3e0b95)
@@ -694,4 +694,28 @@
 INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (238,85,5);
 INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (239,85,2);
 
+-- es_MX
+-- 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(39,null,'Mexican Workspace',39,now(),now(),1);
+insert into lams_workspace (workspace_id, default_fld_id, name) values (39,39,'Mexican 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(39,'mexico','mexico','Dr','Mexico','Test','39','Mexico Ave',null,'Mexico City',null,'Mexico',
+'0211111111','0211111112','0411111111','0211111113','mexico@example.com',0,'20100329',1,39,1,2,29);
+
+-- 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 (86, 2, 39);
+INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (87, 3, 39);
+
+-- 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 (240,86,3);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (241,86,5);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (242,86,2);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (243,87,4);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (244,87,5);
+INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (245,87,2);
+
 update lams_user set password=SHA1(password) where user_id>8;