Index: lams_common/db/sql/insert_users.sql =================================================================== diff -u -rfef86e6ad47f2ca7468d42de92b6276ba728e5c4 -r5732eae12edb6d5513ae073b1a0f1563deb175ab --- lams_common/db/sql/insert_users.sql (.../insert_users.sql) (revision fef86e6ad47f2ca7468d42de92b6276ba728e5c4) +++ lams_common/db/sql/insert_users.sql (.../insert_users.sql) (revision 5732eae12edb6d5513ae073b1a0f1563deb175ab) @@ -25,6 +25,7 @@ insert into lams_workspace (workspace_id, name, default_fld_id) values(6,'Two Test',6); insert into lams_workspace (workspace_id, name, default_fld_id) values(7,'Three Test',7); insert into lams_workspace (workspace_id, name, default_fld_id) values(8,'Four Test',8); +insert into lams_workspace (workspace_id, name, default_fld_id, def_run_seq_fld_id) values(9,'Moodle Test',9,24); 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(1,null,'ROOT',1,'20041223','20041223',1); @@ -56,6 +57,12 @@ 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(8,null,'Four Test Workspace',8,'20041223','20041223',1); +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(9,1,'Moodle Test',1,'20041223','20041223',1); + +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(24,9,'Lesson Sequence Folder',1,'20041223','20041223',2); + insert into lams_wkspc_wkspc_folder (id, workspace_id, workspace_folder_id) values (1, 1,1); insert into lams_wkspc_wkspc_folder (id, workspace_id, workspace_folder_id) values (2, 2,2); insert into lams_wkspc_wkspc_folder (id, workspace_id, workspace_folder_id) values (3, 2,22); @@ -66,6 +73,7 @@ insert into lams_wkspc_wkspc_folder (id, workspace_id, workspace_folder_id) values (8, 6,6); insert into lams_wkspc_wkspc_folder (id, workspace_id, workspace_folder_id) values (9, 7,7); insert into lams_wkspc_wkspc_folder (id, workspace_id, workspace_folder_id) values (10, 8,8); +insert into lams_wkspc_wkspc_folder (id, workspace_id, workspace_folder_id) values (11, 9,9); INSERT INTO lams_organisation (organisation_id, name, code, description, parent_organisation_id, organisation_type_id, create_date, workspace_id, locale_id, organisation_state_id) VALUES (1, 'Root', null, 'Root Organisation',null,1,NOW(),1,1,1); @@ -79,7 +87,10 @@ VALUES (5, 'Tutorial Group A', 'TUTA', 'Tutorial Group A',4,3,NOW(),null,2,1); INSERT INTO lams_organisation (organisation_id, name, code, description, parent_organisation_id, organisation_type_id, create_date, workspace_id, locale_id, organisation_state_id) VALUES (6, 'Tutorial Group B', 'TUTB', 'Tutorial Group B',4,3,NOW(),null,2,1); +INSERT INTO lams_organisation (organisation_id, name, code, description, parent_organisation_id, organisation_type_id, create_date, workspace_id, locale_id, organisation_state_id) + VALUES (7, 'Moodle', 'Moodle', 'Moodle Test',1,2,NOW(),9,1,1); + -- users 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,