Index: lams_common/db/sql/insert_types_data.sql =================================================================== diff -u -r7c06d9adee78c99dd6151735c95016f1e0b0f360 -rab6d81f7bcbac1e35d83f6da2aa02d067b26f601 --- lams_common/db/sql/insert_types_data.sql (.../insert_types_data.sql) (revision 7c06d9adee78c99dd6151735c95016f1e0b0f360) +++ lams_common/db/sql/insert_types_data.sql (.../insert_types_data.sql) (revision ab6d81f7bcbac1e35d83f6da2aa02d067b26f601) @@ -290,6 +290,8 @@ 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'); +INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction, fckeditor_code) +VALUES (28, 'sl', 'SI', 'Slovenian', 'LTR', 'sl'); -- 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 -r9c053cb3e90265140e0e960960c89a0ab539052a -rab6d81f7bcbac1e35d83f6da2aa02d067b26f601 --- lams_common/db/sql/shaun/all.sql (.../all.sql) (revision 9c053cb3e90265140e0e960960c89a0ab539052a) +++ lams_common/db/sql/shaun/all.sql (.../all.sql) (revision ab6d81f7bcbac1e35d83f6da2aa02d067b26f601) @@ -670,4 +670,28 @@ 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); +-- sl_SI +-- 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(38,null,'Slovenian Workspace',38,now(),now(),1); +insert into lams_workspace (workspace_id, default_fld_id, name) values (38,38,'Slovenian 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(38,'slovenian','slovenian','Dr','Slovenian','Test','38','Slovenia Ave',null,'Ljubljana',null,'Slovenija', +'0211111111','0211111112','0411111111','0211111113','slovenian@example.com',0,'20100309',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 (84, 2, 38); +INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (85, 3, 38); + +-- 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 (234,84,3); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (235,84,5); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (236,84,2); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (237,85,4); +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); + update lams_user set password=SHA1(password) where user_id>8;