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.18 -r1.19
--- lams_common/db/sql/shaun/all.sql	5 Jan 2010 01:21:10 -0000	1.18
+++ lams_common/db/sql/shaun/all.sql	8 Mar 2010 23:00:30 -0000	1.19
@@ -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;
