SET FOREIGN_KEY_CHECKS=0;

insert into lams_workspace values(1,null,'ROOT');
insert into lams_workspace values(2,null,'MACQUIRE UNIVERSITY');
insert into lams_workspace values(3,null,'MELCOE');
insert into lams_workspace values(4,null,'LAMS');
insert into lams_workspace values(5,null,'MAMS');
insert into lams_workspace values(6,null,'Manpreet Minhas');

INSERT INTO lams_organisation VALUES (1, 'Root', 'Root Organisation',null,1,NOW(),1);
INSERT INTO lams_organisation VALUES (2, 'Maquarie Uni', 'Macquarie University',1,2,NOW(),2);
INSERT INTO lams_organisation VALUES (3, 'MELCOE', 'Macquarie E-learning Center',2,3,NOW(),3);
INSERT INTO lams_organisation VALUES (4, 'LAMS', 'Lams Project Team',3,3,NOW(),4);
INSERT INTO lams_organisation VALUES (5, 'MAMS', 'Mams Project Team',3,3,NOW(),5);


INSERT INTO lams_user_organisation VALUES (1, 1, 1);
INSERT INTO lams_user_organisation VALUES (2, 2, 2);
INSERT INTO lams_user_organisation VALUES (3, 3, 2);
INSERT INTO lams_user_organisation VALUES (4, 4, 2);
INSERT INTO lams_user_organisation VALUES (5, 2, 3);
INSERT INTO lams_user_organisation VALUES (6, 3, 3);

INSERT INTO lams_user_organisation VALUES (7, 4, 4);
INSERT INTO lams_user_organisation VALUES (8, 2, 4);
INSERT INTO lams_user_organisation VALUES (9, 3, 4);
INSERT INTO lams_user_organisation VALUES (10,5, 4);



INSERT INTO lams_user_organisation_role VALUES (1, 1, 1);
INSERT INTO lams_user_organisation_role VALUES (2, 2, 2);
INSERT INTO lams_user_organisation_role VALUES (3, 2, 3);
INSERT INTO lams_user_organisation_role VALUES (4, 2, 4);
INSERT INTO lams_user_organisation_role VALUES (5, 3, 2);
INSERT INTO lams_user_organisation_role VALUES (6, 3, 3);
INSERT INTO lams_user_organisation_role VALUES (7, 3, 4);
INSERT INTO lams_user_organisation_role VALUES (8, 4, 2);
INSERT INTO lams_user_organisation_role VALUES (9, 4, 3);
INSERT INTO lams_user_organisation_role VALUES (10, 4, 4);
INSERT INTO lams_user_organisation_role VALUES (11, 4, 5);
INSERT INTO lams_user_organisation_role VALUES (12, 5, 4);
INSERT INTO lams_user_organisation_role VALUES (13, 5, 5);
INSERT INTO lams_user_organisation_role VALUES (14, 6, 3);

INSERT INTO lams_user_organisation_role VALUES (15, 7, 3);
INSERT INTO lams_user_organisation_role VALUES (16, 8, 3);
INSERT INTO lams_user_organisation_role VALUES (17, 9, 3);
INSERT INTO lams_user_organisation_role VALUES (18, 10,3);

-- themes and styles 
INSERT INTO lams_css_style (style_id, theme_ve_id) VALUES (1,1);
INSERT INTO lams_css_property (property_id, style_id, name, value, style_subset, type) VALUES (1, 1, "borderStyle", "outset", NULL, 1);
INSERT INTO lams_css_property (property_id, style_id, name, value, style_subset, type) VALUES (2, 1, "color", "12452097", "_tf", 3);
INSERT INTO lams_css_property (property_id, style_id, name, value, style_subset, type) VALUES (3, 1, "rollOverColor", "16711680", NULL, 2);

INSERT INTO lams_css_style (style_id,theme_ve_id) VALUES (2,2);
INSERT INTO lams_css_property (property_id, style_id, name, value, style_subset, type) VALUES (4, 2, "display", "block", "_tf", 1);
INSERT INTO lams_css_property (property_id, style_id, name, value, style_subset, type) VALUES (5, 2, "selectionColor", "16711681", NULL, 3);

INSERT INTO lams_css_theme_ve (theme_ve_id, name, description, parent_id, theme_flag) VALUES (1, "ruby", "cut down ruby theme for testing", null, 1);
INSERT INTO lams_css_theme_ve (theme_ve_id, name, description, parent_id, theme_flag) VALUES (2, "button", null, 1, 0);

-- users
INSERT INTO lams_user VALUES(1, 'sysadmin','sysadmin','Mr','Fei','Yang',null,null,null,'Sydney','NSW','Australia',null,null,null,null,'fyang@melcoe.mq.edu.au',0,NOW(),1,null,1,'en','au',1);
INSERT INTO lams_user VALUES(2, 'test','test','Mr','Kevin','Han',null,null,null,'Sydney','NSW','Australia',null,null,null,null,'khan@melcoe.mq.edu.au',0,NOW(),3,null,2,'mi','nz',1);
INSERT INTO lams_user VALUES(3, 'lamskh01','dummy','Mr','Jacky','Fang',null,null,null,'Sydney','NSW','Australia',null,null,null,null,'jfang@melcoe.mq.edu.au',0,NOW(),2,null,3,'en','nz',1);

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,
base_organisation_id)
values
(4,'mmmmmmm','mmmmmmm','Ms','Mary','Morgan','99','First Ave',null,
'Parramatta','NSW','Australia','0295099999','0298939999','0499999999',
'0299999999','mmmmmmm@xx.os',
0,'20041223',1,6,4);

insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id)
values(1,null,'ROOT',1,1,'20041223','20041223',1);

insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id)
values(2,1,'MACQUAIRE UNIVERSITY',2,1,'20041223','20041223',1);

insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id)
values(3,1,'MELCOE',3,1,'20041223','20041223',1);

insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id)
values(4,1,'LAMS',4,1,'20041223','20041223',1);

insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id)
values(5,1,'MAMS',5,1,'20041223','20041223',1);

insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id)
values(6,4,'Manpreet Minhas Workspace',6,4,'20041223','20041223',1);

insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id)
values(7,6,'Manpreet Minhas Run Sequences Folder',6,4,'20041223','20041223',2);

insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id)
values(8,6,'Documents',6,4,'20041223','20041223',1);

insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id)
values(9,6,'Pictures',6,4,'20041223','20041223',1);

insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id)
values(10,6,'Media',6,4,'20041223','20041223',1);

insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id)
values(11,10,'Songs',6,4,'20041223','20041223',1);

insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id)
values(12,10,'Movies',6,4,'20041223','20041223',1);


update lams_workspace set root_folder_id = 1 where workspace_id = 1;
update lams_workspace set root_folder_id = 2 where workspace_id = 2;
update lams_workspace set root_folder_id = 3 where workspace_id = 3;
update lams_workspace set root_folder_id = 4 where workspace_id = 4;
update lams_workspace set root_folder_id = 5 where workspace_id = 5;
update lams_workspace set root_folder_id = 6 where workspace_id = 6;


-- Populates the lams_learning_library table with default libraries

insert into lams_learning_library (learning_library_id,description,title,create_date_time) values (1,'Notebook','Notebook','20050207');
insert into lams_learning_library (learning_library_id,description,title,create_date_time) values (2,'NoticeBoard','NoticeBoard','20050207');
insert into lams_learning_library (learning_library_id,description,title,create_date_time) values (3,'Multiple Choice Questions','Multiple Choice','20050207');
insert into lams_learning_library (learning_library_id,description,title,create_date_time) values (4,'Questions and Answer','Question And Answer','20050207');
insert into lams_learning_library (learning_library_id,description,title,create_date_time) values (5,'Message Board','Message Board','20050207');
insert into lams_learning_library (learning_library_id,description,title,create_date_time) values (6,'Survey','Survey','20050207');
insert into lams_learning_library (learning_library_id,description,title,create_date_time) values (7,'Chat','Chat','20050207');
insert into lams_learning_library (learning_library_id,description,title,create_date_time) values (8,'Shared Resources','Shared Resources','20050207');
insert into lams_learning_library (learning_library_id,description,title,create_date_time) values (9,'Voting','Voting','20050207');
insert into lams_learning_library (learning_library_id,description,title,create_date_time) values (10,'Submit Files','Submit Files','20050207');
insert into lams_learning_library (learning_library_id,description,title,create_date_time) values (11,'Instant Messaging','Instant Messaging','20050207');

-- Populates the lams_tool table with default tools corresponding to each of the above libraries

insert into lams_tool (tool_id,tool_signature,service_name,tool_display_name,description,tool_identifier,tool_version,default_tool_content_id,
grouping_support_type_id,supports_define_later_flag,supports_run_offline_flag,supports_moderation_flag,supports_contribute_flag,
learner_url,author_url,define_later_url,export_portfolio_url,monitor_url,contribute_url,moderation_url,
valid_flag,learning_library_id)
values(1,'notebook_signature','notebookService','Notebook','Notebook Description','notebook','1.1',1,
2,0,1,0,1,
'learner_url','author_url','define_later_url','export_portfolio_url','monitor_url','contribute_url','moderation_url',
1,1);

insert into lams_tool (tool_id,tool_signature,service_name,tool_display_name,description,tool_identifier,tool_version,default_tool_content_id,
grouping_support_type_id,supports_define_later_flag,supports_run_offline_flag,supports_moderation_flag,supports_contribute_flag,
learner_url,author_url,define_later_url,export_portfolio_url,monitor_url,contribute_url,moderation_url,
valid_flag,learning_library_id)
values(2,'noticeboard_signature','noticeboardService','Noticeboard','Noticeboard Description','noticeboard','1.1',2,
2,1,1,0,1,
'learner_url','author_url','define_later_url','export_portfolio_url','monitor_url','contribute_url','moderation_url',
1,2);

insert into lams_tool (tool_id,tool_signature,service_name,tool_display_name,description,tool_identifier,tool_version,default_tool_content_id,
grouping_support_type_id,supports_define_later_flag,supports_run_offline_flag,supports_moderation_flag,supports_contribute_flag,
learner_url,author_url,define_later_url,export_portfolio_url,monitor_url,contribute_url,moderation_url,
valid_flag,learning_library_id)
values(3,'multiple_choice_signature','multipleChoiceService','Multiple Choice','Multiple Coice Description','multiple choice','1.1',3,
2,1,1,1,1,
'learner_url','author_url','define_later_url','export_portfolio_url','monitor_url','contribute_url','moderation_url',
1,3);

insert into lams_tool (tool_id,tool_signature,service_name,tool_display_name,description,tool_identifier,tool_version,default_tool_content_id,
grouping_support_type_id,supports_define_later_flag,supports_run_offline_flag,supports_moderation_flag,supports_contribute_flag,
learner_url,author_url,define_later_url,export_portfolio_url,monitor_url,contribute_url,moderation_url,
valid_flag,learning_library_id)
values(4,'question_answer_signature','questionAnswerService','Question and Answers','Question and Answers Description','q & a','1.1',4,
2,1,1,1,1,
'learner_url','author_url','define_later_url','export_portfolio_url','monitor_url','contribute_url','moderation_url',
1,4);

insert into lams_tool (tool_id,tool_signature,service_name,tool_display_name,description,tool_identifier,tool_version,default_tool_content_id,
grouping_support_type_id,supports_define_later_flag,supports_run_offline_flag,supports_moderation_flag,supports_contribute_flag,
learner_url,author_url,define_later_url,export_portfolio_url,monitor_url,contribute_url,moderation_url,
valid_flag,learning_library_id)
values(5,'message_board_signature','messageBoardService','Message Board','Message Board Description','forum','1.1',5,
2,1,1,1,1,
'learner_url','author_url','define_later_url','export_portfolio_url','monitor_url','contribute_url','moderation_url',
1,5);

insert into lams_tool (tool_id,tool_signature,service_name,tool_display_name,description,tool_identifier,tool_version,default_tool_content_id,
grouping_support_type_id,supports_define_later_flag,supports_run_offline_flag,supports_moderation_flag,supports_contribute_flag,
learner_url,author_url,define_later_url,export_portfolio_url,monitor_url,contribute_url,moderation_url,
valid_flag,learning_library_id)
values(6,'survey_signature','surveyService','Survey','Survey Description','survey','1.1',6,
2,1,1,1,1,
'/lams_tool_survey/tool/survey/survey.do?method=loadQuestionnaire','/lams_tool_survey/tool/survey/authoring.do?method=loadSurvey','define_later_url','export_portfolio_url',
'/lams_tool_survey/tool/survey/report.do?method=loadMonitorReport','contribute_url','moderation_url',
1,6);

insert into lams_tool (tool_id,tool_signature,service_name,tool_display_name,description,tool_identifier,tool_version,default_tool_content_id,
grouping_support_type_id,supports_define_later_flag,supports_run_offline_flag,supports_moderation_flag,supports_contribute_flag,
learner_url,author_url,define_later_url,export_portfolio_url,monitor_url,contribute_url,moderation_url,
valid_flag,learning_library_id)
values(7,'chat_signature','chatService','Chat','Chat Description','chat','1.1',7,
2,1,1,1,1,
'learner_url','author_url','define_later_url','export_portfolio_url','monitor_url','contribute_url','moderation_url',
1,7);

insert into lams_tool (tool_id,tool_signature,service_name,tool_display_name,description,tool_identifier,tool_version,default_tool_content_id,
grouping_support_type_id,supports_define_later_flag,supports_run_offline_flag,supports_moderation_flag,supports_contribute_flag,
learner_url,author_url,define_later_url,export_portfolio_url,monitor_url,contribute_url,moderation_url,
valid_flag,learning_library_id)
values(8,'shared_resources_signature','sharedResourcesService','Shared Resources','Shared Resources Description','shared resources','1.1',8,
2,1,0,1,1,
'learner_url','author_url','define_later_url','export_portfolio_url','monitor_url','contribute_url','moderation_url',
1,8);


insert into lams_tool (tool_id,tool_signature,service_name,tool_display_name,description,tool_identifier,tool_version,default_tool_content_id,
grouping_support_type_id,supports_define_later_flag,supports_run_offline_flag,supports_moderation_flag,supports_contribute_flag,
learner_url,author_url,define_later_url,export_portfolio_url,monitor_url,contribute_url,moderation_url,
valid_flag,learning_library_id)
values(9,'voting_signature','votingService','Voting','Voting Description','voting','1.1',9,
2,1,1,1,1,
'learner_url','author_url','define_later_url','export_portfolio_url','monitor_url','contribute_url','moderation_url',
1,9);


insert into lams_tool (tool_id,tool_signature,service_name,tool_display_name,description,tool_identifier,tool_version,default_tool_content_id,
grouping_support_type_id,supports_define_later_flag,supports_run_offline_flag,supports_moderation_flag,supports_contribute_flag,
learner_url,author_url,define_later_url,export_portfolio_url,monitor_url,contribute_url,moderation_url,
valid_flag,learning_library_id)
values(10,'submit_files_signature','submitFilesService','Submit Files','Submit Files Description','submit files','1.1',10,
2,1,1,1,1,
'learner_url','author_url','define_later_url','export_portfolio_url','monitor_url','contribute_url','moderation_url',
1,10);


insert into lams_tool (tool_id,tool_signature,service_name,tool_display_name,description,tool_identifier,tool_version,default_tool_content_id,
grouping_support_type_id,supports_define_later_flag,supports_run_offline_flag,supports_moderation_flag,supports_contribute_flag,
learner_url,author_url,define_later_url,export_portfolio_url,monitor_url,contribute_url,moderation_url,
valid_flag,learning_library_id)
values(11,'instant_messaging_signature','instantMessagingService','Instant Messaging','Instant Messaging Description','instant messaging','1.1',11,
2,1,1,1,1,
'learner_url','author_url','define_later_url','export_portfolio_url','monitor_url','contribute_url','moderation_url',
1,11);

-- Populates the lams_tool_content table with dummy default content for all above tools

insert into lams_tool_content (tool_content_id,tool_id) values (1,1);
insert into lams_tool_content (tool_content_id,tool_id) values (2,2);
insert into lams_tool_content (tool_content_id,tool_id) values (3,3);
insert into lams_tool_content (tool_content_id,tool_id) values (4,4);
insert into lams_tool_content (tool_content_id,tool_id) values (5,5);
insert into lams_tool_content (tool_content_id,tool_id) values (6,6);
insert into lams_tool_content (tool_content_id,tool_id) values (7,7);
insert into lams_tool_content (tool_content_id,tool_id) values (8,8);
insert into lams_tool_content (tool_content_id,tool_id) values (9,9);
insert into lams_tool_content (tool_content_id,tool_id) values (10,10);
insert into lams_tool_content (tool_content_id,tool_id) values (11,11);
insert into lams_tool_content (tool_content_id,tool_id) values (12,1);
insert into lams_tool_content (tool_content_id,tool_id) values (13,2);
insert into lams_tool_content (tool_content_id,tool_id) values (14,3);
insert into lams_tool_content (tool_content_id,tool_id) values (15,4);
insert into lams_tool_content (tool_content_id,tool_id) values (16,5);
insert into lams_tool_content (tool_content_id,tool_id) values (17,6);
insert into lams_tool_content (tool_content_id,tool_id) values (18,7);
insert into lams_tool_content (tool_content_id,tool_id) values (19,8);
insert into lams_tool_content (tool_content_id,tool_id) values (20,4);
insert into lams_tool_content (tool_content_id,tool_id) values (21,4);
insert into lams_tool_content (tool_content_id,tool_id) values(22,4);
insert into lams_tool_content (tool_content_id,tool_id) values(23,2);
insert into lams_tool_content (tool_content_id,tool_id) values(24,7);
insert into lams_tool_content (tool_content_id,tool_id) values(25,3);
insert into lams_tool_content (tool_content_id,tool_id) values(26,6);

--insert a testing grouping
insert into lams_grouping values(99,99,1,2,-1,0,-1);
insert into lams_grouping values(100,100,2,1,-1,0,-1);		
INSERT INTO lams_grouping values(101, NULL, 3, NULL, NULL, 89, NULL);

insert into lams_group values(87,99,1);
insert into lams_group values(88,100,1);
insert into lams_group values(89, 101, 1);
insert into lams_group values(90, 101, 1);

insert into lams_user_group values(1,87);
insert into lams_user_group values(1,88);
insert into lams_user_group values(2,88);
insert into lams_user_group values(2, 90);
insert into lams_user_group values(3, 89);

insert into lams_lesson values (1, 1, 1,'Test_Lesson','This is for testing', '2005-02-23 17:37:25', 1, 101,3, NULL,'2005-02-25 17:37:25',NULL,'2005-02-26 17:37:25' );

-- Populates the lams_learning_activity table with default activity templates that would be avaialbe to the
-- author in the left panel and a default dummy learning_design defination 

insert into lams_learning_activity (activity_id,activity_ui_id,description,title,xcoord,ycoord,parent_activity_id,help_text,
learning_activity_type_id,grouping_id,order_id,define_later_flag,
learning_design_id,learning_library_id,create_date_time,run_offline_flag,
max_number_of_options,min_number_of_options,tool_id,tool_content_id,
gate_activity_level_id,gate_start_time_offset,gate_end_time_offset,library_activity_ui_image,
grouping_support_type_id, apply_grouping_flag,activity_category_id)
values
(1,1,'Notebook Template','Notebook',10,20,null,'Help Text for Activity',
1,null,0,0,
null,1,'20050101',0,
null,null,1,1,
null,null,null,'/lams/images/icon_journal.swf',
1,0,1);

insert into lams_learning_activity (activity_id,activity_ui_id,description,title,xcoord,ycoord,parent_activity_id,help_text,
learning_activity_type_id,grouping_id,order_id,define_later_flag,
learning_design_id,learning_library_id,create_date_time,run_offline_flag,
max_number_of_options,min_number_of_options,tool_id,tool_content_id,
gate_activity_level_id,gate_start_time_offset,gate_end_time_offset,library_activity_ui_image,
grouping_support_type_id, apply_grouping_flag,activity_category_id)
values
(2,2,'NoticeBoard Template','NoticeBoard',10,20,null,'Help Text for Activity',
1,null,0,0,
null,2,'20050101',0,
null,null,2,2,
null,null,null,'/lams/images/icon_noticeboard.swf',
1,0,1);

insert into lams_learning_activity (activity_id,activity_ui_id,description,title,xcoord,ycoord,parent_activity_id,help_text,
learning_activity_type_id,grouping_id,order_id,define_later_flag,
learning_design_id,learning_library_id,create_date_time,run_offline_flag,
max_number_of_options,min_number_of_options,tool_id,tool_content_id,
gate_activity_level_id,gate_start_time_offset,gate_end_time_offset,library_activity_ui_image,
grouping_support_type_id, apply_grouping_flag,activity_category_id)
values
(3,3,'Multiple Choice Template','Multiple Choice',10,20,null,'Help Text for Activity',
1,null,0,0,
null,3,'20050101',0,
null,null,3,3,
null,null,null,'missing.swf',
1,0,1);

insert into lams_learning_activity (activity_id,activity_ui_id,description,title,xcoord,ycoord,parent_activity_id,help_text,
learning_activity_type_id,grouping_id,order_id,define_later_flag,
learning_design_id,learning_library_id,create_date_time,run_offline_flag,
max_number_of_options,min_number_of_options,tool_id,tool_content_id,
gate_activity_level_id,gate_start_time_offset,gate_end_time_offset,library_activity_ui_image,
grouping_support_type_id, apply_grouping_flag,activity_category_id)
values
(4,4,'Question and Answer Template','Question and Answer',10,20,null,'Help Text for Activity',
1,null,0,0,
null,4,'20050101',0,
null,null,4,4,
null,null,null,'/lams/tool/laqa/images/icon_questionanswer.swf',
1,0,1);

insert into lams_learning_activity (activity_id,activity_ui_id,description,title,xcoord,ycoord,parent_activity_id,help_text,
learning_activity_type_id,grouping_id,order_id,define_later_flag,
learning_design_id,learning_library_id,create_date_time,run_offline_flag,
max_number_of_options,min_number_of_options,tool_id,tool_content_id,
gate_activity_level_id,gate_start_time_offset,gate_end_time_offset,library_activity_ui_image,
grouping_support_type_id, apply_grouping_flag,activity_category_id)
values
(5,5,'MessageBoard Template','MessageBoard',10,20,null,'Help Text for Activity',
1,null,0,0,
null,5,'20050101',0,
null,null,5,5,
null,null,null,'/lams/images/icon_messageboard.swf',
1,0,1);

insert into lams_learning_activity (activity_id,activity_ui_id,description,title,xcoord,ycoord,parent_activity_id,help_text,
learning_activity_type_id,grouping_id,order_id,define_later_flag,
learning_design_id,learning_library_id,create_date_time,run_offline_flag,
max_number_of_options,min_number_of_options,tool_id,tool_content_id,
gate_activity_level_id,gate_start_time_offset,gate_end_time_offset,library_activity_ui_image,
grouping_support_type_id, apply_grouping_flag,activity_category_id)
values
(6,6,'Survey Template','Survey',10,20,null,'Help Text for Activity',
1,null,0,0,
null,6,'20050101',0,
null,null,6,6,
null,null,null,'/lams/images/icon_survey.swf',
1,0,1);

insert into lams_learning_activity (activity_id,activity_ui_id,description,title,xcoord,ycoord,parent_activity_id,help_text,
learning_activity_type_id,grouping_id,order_id,define_later_flag,
learning_design_id,learning_library_id,create_date_time,run_offline_flag,
max_number_of_options,min_number_of_options,tool_id,tool_content_id,
gate_activity_level_id,gate_start_time_offset,gate_end_time_offset,library_activity_ui_image,
grouping_support_type_id, apply_grouping_flag,activity_category_id)
values
(7,7,'Chat Template','Chat',10,20,null,'Help Text for Activity',
1,null,0,0,
null,7,'20050101',0,
null,null,7,7,
null,null,null,'/lams/images/icon_chat.swf',
1,0,1);

insert into lams_learning_activity (activity_id,activity_ui_id,description,title,xcoord,ycoord,parent_activity_id,help_text,
learning_activity_type_id,grouping_id,order_id,define_later_flag,
learning_design_id,learning_library_id,create_date_time,run_offline_flag,
max_number_of_options,min_number_of_options,tool_id,tool_content_id,
gate_activity_level_id,gate_start_time_offset,gate_end_time_offset,library_activity_ui_image,
grouping_support_type_id, apply_grouping_flag,activity_category_id)
values
(8,8,'Shared Resources Template','Shared Resources',10,20,null,'Help Text for Activity',
1,null,0,0,
null,8,'20050101',0,
null,null,8,8,
null,null,null,'/lams/images/icon_singleresource.swf',
1,0,1);

insert into lams_learning_activity (activity_id,activity_ui_id,description,title,xcoord,ycoord,parent_activity_id,help_text,
learning_activity_type_id,grouping_id,order_id,define_later_flag,
learning_design_id,learning_library_id,create_date_time,run_offline_flag,
max_number_of_options,min_number_of_options,tool_id,tool_content_id,
gate_activity_level_id,gate_start_time_offset,gate_end_time_offset,library_activity_ui_image,
grouping_support_type_id, apply_grouping_flag,activity_category_id)
values
(9,9,'Voting Template','Voting',10,20,null,'Help Text for Activity',
1,null,0,0,
null,9,'20050101',0,
null,null,9,9,
null,null,null,'/lams/images/icon_ranking.swf',
1,0,1);

insert into lams_learning_activity (activity_id,activity_ui_id,description,title,xcoord,ycoord,parent_activity_id,help_text,
learning_activity_type_id,grouping_id,order_id,define_later_flag,
learning_design_id,learning_library_id,create_date_time,run_offline_flag,
max_number_of_options,min_number_of_options,tool_id,tool_content_id,
gate_activity_level_id,gate_start_time_offset,gate_end_time_offset,library_activity_ui_image,
grouping_support_type_id, apply_grouping_flag,activity_category_id)
values
(10,10,'Submit Files Template','Submit Files',10,20,null,'Help Text for Activity',
1,null,0,0,
null,10,'20050101',0,
null,null,10,10,
null,null,null,'/lams/images/icon_reportsubmission.swf',
1,0,1);

insert into lams_learning_activity (activity_id,activity_ui_id,description,title,xcoord,ycoord,parent_activity_id,help_text,
learning_activity_type_id,grouping_id,order_id,define_later_flag,
learning_design_id,learning_library_id,create_date_time,run_offline_flag,
max_number_of_options,min_number_of_options,tool_id,tool_content_id,
gate_activity_level_id,gate_start_time_offset,gate_end_time_offset,library_activity_ui_image,
grouping_support_type_id, apply_grouping_flag,activity_category_id)
values
(11,11,'Instant Messaging Template','Instant Messaging',10,20,null,'Help Text for Activity',
1,null,0,0,
null,11,'20050101',0,
null,null,11,11,
null,null,null,'missing.swf',
1,0,1);

insert into lams_learning_activity
(activity_id,activity_ui_id,description,title,xcoord,ycoord,parent_activity_id,help_text,
learning_activity_type_id,grouping_id,order_id,define_later_flag,
learning_design_id,learning_library_id,create_date_time,run_offline_flag,
max_number_of_options,min_number_of_options,tool_id,tool_content_id,
gate_activity_level_id,gate_start_time_offset,gate_end_time_offset,library_activity_ui_image,
grouping_support_type_id, apply_grouping_flag,activity_category_id)
values
(12,12,'Optional Activity Description','Optional Activity Title',10,20,null,'Help Text for Activity',
7,null,1,0,
1,null,'20050101',0,
1,1,null,null,
null,'20050101','20050101','missing.swf',
3,1,1);

insert into lams_learning_activity
(activity_id,activity_ui_id,description,title,xcoord,ycoord,parent_activity_id,help_text,
learning_activity_type_id,grouping_id,order_id,define_later_flag,
learning_design_id,learning_library_id,create_date_time,run_offline_flag,
max_number_of_options,min_number_of_options,tool_id,tool_content_id,
gate_activity_level_id,gate_start_time_offset,gate_end_time_offset,library_activity_ui_image,
grouping_support_type_id, apply_grouping_flag,activity_category_id)
values
(13,13,'Parallel Activity Description','Parallel Activity Title',10,20,null,'Help Text for Activity',
6,null,1,0,
1,null,'20050101',0,
null,null,null,null,
null,null,null,'missing.swf',
1,0,1);

insert into lams_learning_activity
(activity_id,activity_ui_id,description,title,xcoord,ycoord,parent_activity_id,help_text,
learning_activity_type_id,grouping_id,order_id,define_later_flag,
learning_design_id,learning_library_id,create_date_time,run_offline_flag,
max_number_of_options,min_number_of_options,tool_id,tool_content_id,
gate_activity_level_id,gate_start_time_offset,gate_end_time_offset,library_activity_ui_image,
grouping_support_type_id, apply_grouping_flag,activity_category_id)
values
(14,14,'Sequence Activity Description','Sequence Activity Title',10,20,null,'Help Text for Activity',
8,null,1,0,
1,null,'20050101',0,
null,null,null,null,
null,null,null,'missing.swf',
1,0,1);

insert into lams_learning_activity
(activity_id,activity_ui_id,description,title,xcoord,ycoord,parent_activity_id,help_text,
learning_activity_type_id,grouping_id,order_id,define_later_flag,
learning_design_id,learning_library_id,create_date_time,run_offline_flag,
max_number_of_options,min_number_of_options,tool_id,tool_content_id,
gate_activity_level_id,gate_start_time_offset,gate_end_time_offset,library_activity_ui_image,
grouping_support_type_id, apply_grouping_flag,activity_category_id)
values
(15,1,'Notebook Activity Description','Notebook Activity Title',10,20,null,'Help Text for Activity',
1,null,1,0,
1,1,'20050101',0,
null,null,1,12,
null,null,null,'/lams/images/icon_journal.swf',
1,0,1);

insert into lams_learning_activity
(activity_id,activity_ui_id,description,title,xcoord,ycoord,parent_activity_id,help_text,
learning_activity_type_id,grouping_id,order_id,define_later_flag,
learning_design_id,learning_library_id,create_date_time,run_offline_flag,
max_number_of_options,min_number_of_options,tool_id,tool_content_id,
gate_activity_level_id,gate_start_time_offset,gate_end_time_offset,library_activity_ui_image,
grouping_support_type_id, apply_grouping_flag,activity_category_id)
values
(16,2,'NoticeBoard Activity','NoticeBoard Activity',10,20,12,'Help Text for Activity',
1,null,0,0,
1,2,'20050101',0,
null,null,2,13,
null,null,null,'/lams/images/icon_noticeboard.swf',
1,0,1);

insert into lams_learning_activity
(activity_id,activity_ui_id,description,title,xcoord,ycoord,parent_activity_id,help_text,
learning_activity_type_id,grouping_id,order_id,define_later_flag,
learning_design_id,learning_library_id,create_date_time,run_offline_flag,
max_number_of_options,min_number_of_options,tool_id,tool_content_id,
gate_activity_level_id,gate_start_time_offset,gate_end_time_offset,library_activity_ui_image,
grouping_support_type_id, apply_grouping_flag,activity_category_id)
values
(17,3,'Multiple Choice Activity ','Multiple Choice',10,20,12,'Help Text for Activity',
1,null,1,0,
1,3,'20050101',0,
null,null,3,14,
null,null,null,'missing.swf',
1,0,1);

insert into lams_learning_activity
(activity_id,activity_ui_id,description,title,xcoord,ycoord,parent_activity_id,help_text,
learning_activity_type_id,grouping_id,order_id,define_later_flag,
learning_design_id,learning_library_id,create_date_time,run_offline_flag,
max_number_of_options,min_number_of_options,tool_id,tool_content_id,
gate_activity_level_id,gate_start_time_offset,gate_end_time_offset,library_activity_ui_image,
grouping_support_type_id, apply_grouping_flag,activity_category_id)
values
(18,4,'Question and Answer Activity','Question and Answer',10,20,13,'Help Text for Activity',
1,null,0,1,
1,4,'20050101',0,
null,null,4,15,
null,null,null,'/lams/tool/laqa/images/icon_questionanswer.swf',
1,0,1);

insert into lams_learning_activity
(activity_id,activity_ui_id,description,title,xcoord,ycoord,parent_activity_id,help_text,
learning_activity_type_id,grouping_id,order_id,define_later_flag,
learning_design_id,learning_library_id,create_date_time,run_offline_flag,
max_number_of_options,min_number_of_options,tool_id,tool_content_id,
gate_activity_level_id,gate_start_time_offset,gate_end_time_offset,library_activity_ui_image,
grouping_support_type_id, apply_grouping_flag,activity_category_id)
values
(19,5,'Message Board Activity','Message Board',10,20,13,'Help Text for Activity',
1,100,1,0,
1,5,'20050101',0,
null,null,5,16,
null,null,null,'/lams/images/icon_messageboard.swf',
1,0,1);

insert into lams_learning_activity
(activity_id,activity_ui_id,description,title,xcoord,ycoord,parent_activity_id,help_text,
learning_activity_type_id,grouping_id,order_id,define_later_flag,
learning_design_id,learning_library_id,create_date_time,run_offline_flag,
max_number_of_options,min_number_of_options,tool_id,tool_content_id,
gate_activity_level_id,gate_start_time_offset,gate_end_time_offset,library_activity_ui_image,
grouping_support_type_id, apply_grouping_flag,activity_category_id)
values
(20,6,'Survey Activity','Survey Title',10,20,null,'Help Text for Activity',
1,null,0,1,
1,6,'20050101',0,
null,null,6,17,
null,null,null,'/lams/images/icon_survey.swf',
1,0,1);

insert into lams_learning_activity
(activity_id,activity_ui_id,
description,title,help_text,
xcoord,ycoord,
parent_activity_id,parent_ui_id,learning_activity_type_id,
grouping_id,grouping_ui_id,order_id,define_later_flag,
learning_design_id,learning_library_id,create_date_time,
run_offline_flag,
max_number_of_options,min_number_of_options,options_instructions,
tool_id,tool_content_id,
gate_activity_level_id,gate_open_flag,
gate_start_time_offset,gate_end_time_offset,
gate_start_date_time,gate_end_date_time,
library_activity_ui_image,
create_grouping_id,create_grouping_ui_id,
library_activity_id,
grouping_support_type_id, apply_grouping_flag,activity_category_id)
values
(21,7,
'Chat Activity Description','Chat Title','Help Text for Chat Activity',
10,20,
null,null,1,
99,99,0,0,
1,7,'20050101',
1,
null,null,null,
7,18,
null,null,
null,null,
null,null,
'/lams/images/icon_chat.swf',
null,null,
7,
2,1,1);

insert into lams_learning_activity
(activity_id,activity_ui_id,description,title,xcoord,ycoord,parent_activity_id,help_text,
learning_activity_type_id,grouping_id,order_id,define_later_flag,
learning_design_id,learning_library_id,create_date_time,run_offline_flag,
max_number_of_options,min_number_of_options,tool_id,tool_content_id,
gate_activity_level_id,gate_start_time_offset,gate_end_time_offset,library_activity_ui_image,
grouping_support_type_id, apply_grouping_flag,activity_category_id)
values
(22,8,'Shared Resources Activity','Shared Resources',10,20,14,'Help Text for Activity',
1,null,0,0,
1,8,'20050101',0,
null,null,8,19,
null,null,null,'/lams/images/icon_singleresource.swf',
1,0,1);

-- Sample GroupingActivity with RandomGrouping 

insert into lams_learning_activity
(activity_id,activity_ui_id,
description,title,help_text,
xcoord,ycoord,
parent_activity_id,parent_ui_id,learning_activity_type_id,
grouping_id,grouping_ui_id,order_id,define_later_flag,
learning_design_id,learning_library_id,create_date_time,
run_offline_flag,
max_number_of_options,min_number_of_options,options_instructions,
tool_id,tool_content_id,
gate_activity_level_id,gate_open_flag,
gate_start_time_offset,gate_end_time_offset,
gate_start_date_time,gate_end_date_time,
library_activity_ui_image,
create_grouping_id,create_grouping_ui_id,
library_activity_id,
grouping_support_type_id, apply_grouping_flag,activity_category_id)
values
(23,23,
'Random Grouping Activity Description','RandomGroupingActivity Title','Help Text for RandomGroupingActivity',
10,20,
null,null,2,
null,null,0,0,
1,null,'20050101',
0,
null,null,null,
null,null,
null,null,
null,null,
null,null,
'missing.swf',
99,99,
null,
1,0,1);

insert into lams_learning_activity
(activity_id,activity_ui_id,
description,title,help_text,
xcoord,ycoord,
parent_activity_id,parent_ui_id,learning_activity_type_id,
grouping_id,grouping_ui_id,order_id,define_later_flag,
learning_design_id,learning_library_id,create_date_time,
run_offline_flag,
max_number_of_options,min_number_of_options,options_instructions,
tool_id,tool_content_id,
gate_activity_level_id,gate_open_flag,
gate_start_time_offset,gate_end_time_offset,
gate_start_date_time,gate_end_date_time,
library_activity_ui_image,
create_grouping_id,create_grouping_ui_id,
library_activity_id,
grouping_support_type_id, apply_grouping_flag,activity_category_id)
values
(24,24,
'QNA Activity Description','QNA Activity Title','Help Text for QNA Activity',
10,20,
null,null,1,
99,99,0,1,
1,4,'20050101',
1,
null,null,null,
4,20,
null,null,
null,null,
null,null,
'/lams/tool/laqa/images/icon_questionanswer.swf',
null,null,
4,
2,1,1);

insert into lams_learning_activity
(activity_id,activity_ui_id,
description,title,help_text,
xcoord,ycoord,
parent_activity_id,parent_ui_id,learning_activity_type_id,
grouping_id,grouping_ui_id,order_id,define_later_flag,
learning_design_id,learning_library_id,create_date_time,
run_offline_flag,
max_number_of_options,min_number_of_options,options_instructions,
tool_id,tool_content_id,
gate_activity_level_id,gate_open_flag,
gate_start_time_offset,gate_end_time_offset,
gate_start_date_time,gate_end_date_time,
library_activity_ui_image,
create_grouping_id,create_grouping_ui_id,
library_activity_id,
grouping_support_type_id, apply_grouping_flag,activity_category_id)
values
(25,25,
'QNA Activity Description','QNA Activity Title','Help Text for QNA Activity',
10,20,
14,14,1,
null,null,1,1,
1,4,'20050101',
1,
null,null,null,
4,21,
null,null,
null,null,
null,null,
'/lams/tool/laqa/images/icon_questionanswer.swf',
null,null,
4,
1,0,1);



insert into lams_learning_activity
(activity_id,activity_ui_id,
description,title,help_text,
xcoord,ycoord,
parent_activity_id,parent_ui_id,learning_activity_type_id,
grouping_id,grouping_ui_id,order_id,define_later_flag,
learning_design_id,learning_library_id,create_date_time,
run_offline_flag,
max_number_of_options,min_number_of_options,options_instructions,
tool_id,tool_content_id,
gate_activity_level_id,gate_open_flag,
gate_start_time_offset,gate_end_time_offset,
gate_start_date_time,gate_end_date_time,
library_activity_ui_image,
create_grouping_id,create_grouping_ui_id,
library_activity_id,
grouping_support_type_id, apply_grouping_flag,activity_category_id)
values
(26,26,
'Synch Gate','Synch Gate Activity','Help Text for Synch Gate',
10,20,
null,null,3,
null,null,0,0,
1,null,'20050101',
0,
null,null,null,
null,null,
3,0,
null,null,
null,null,
'missing.swf',
null,null,
null,
1,0,1);

insert into lams_learning_activity
(activity_id,activity_ui_id,
description,title,help_text,
xcoord,ycoord,
parent_activity_id,parent_ui_id,learning_activity_type_id,
grouping_id,grouping_ui_id,order_id,define_later_flag,
learning_design_id,learning_library_id,create_date_time,
run_offline_flag,
max_number_of_options,min_number_of_options,options_instructions,
tool_id,tool_content_id,
gate_activity_level_id,gate_open_flag,
gate_start_time_offset,gate_end_time_offset,
gate_start_date_time,gate_end_date_time,
library_activity_ui_image,
create_grouping_id,create_grouping_ui_id,
library_activity_id,
grouping_support_type_id, apply_grouping_flag,activity_category_id)
values
(27,27,
'Schedule Gate','Schedule Gate Activity','Help Text for Schedule Gate',
10,20,
null,null,4,
null,null,0,0,
1,null,'20050101',
0,
null,null,null,
null,null,
3,0,
1,2,
null,null,
'missing.swf',
null,null,
null,
1,0,1);

insert into lams_learning_activity
(activity_id,activity_ui_id,
description,title,help_text,
xcoord,ycoord,
parent_activity_id,parent_ui_id,learning_activity_type_id,
grouping_id,grouping_ui_id,order_id,define_later_flag,
learning_design_id,learning_library_id,create_date_time,
run_offline_flag,
max_number_of_options,min_number_of_options,options_instructions,
tool_id,tool_content_id,
gate_activity_level_id,gate_open_flag,
gate_start_time_offset,gate_end_time_offset,
gate_start_date_time,gate_end_date_time,
library_activity_ui_image,
create_grouping_id,create_grouping_ui_id,
library_activity_id,
grouping_support_type_id, apply_grouping_flag,activity_category_id)
values
(28,28,
'Permission Gate','Permission Gate Activity','Help Text for Permission Gate',
10,20,
null,null,5,
null,null,0,0,
1,null,'20050101',
0,
null,null,null,
null,null,
3,0,
null,null,
null,null,
'missing.swf',
null,null,
null,
1,0,1);

-- Populates the lams_learning_transition table with various transitions for the dummy design 

insert into lams_learning_transition(transition_id,transition_ui_id,description,title,to_activity_id,from_activity_id,learning_design_id,create_date_time,to_ui_id,from_ui_id)
values(1,1,'Survey to Synch gate','Survey to Synch gate',26,20,1,'20050207',26,6);

insert into lams_learning_transition(transition_id,transition_ui_id,description,title,to_activity_id,from_activity_id,learning_design_id,create_date_time,to_ui_id,from_ui_id)
values(2,2,'Synch gate to Notebook','Synch gate to Notebook',15,26,1,'20050207',1,26);

insert into lams_learning_transition(transition_id,transition_ui_id,description,title,to_activity_id,from_activity_id,learning_design_id,create_date_time,to_ui_id,from_ui_id)
values(3,3,'Notebook to GroupingActivity','Notebook to GroupingActivity',23,15,1,'20050207',23,1);

insert into lams_learning_transition(transition_id,transition_ui_id,description,title,to_activity_id,from_activity_id,learning_design_id,create_date_time,to_ui_id,from_ui_id)
values(4,4,'GroupingActivity to Schedule gate','GroupingActivity to Schedule gate',27,23,1,'20050207',27,23);

insert into lams_learning_transition(transition_id,transition_ui_id,description,title,to_activity_id,from_activity_id,learning_design_id,create_date_time,to_ui_id,from_ui_id)
values(5,5,'Schedule gate to Chat','Schedule gate to Chat',21,27,1,'20050207',7,27);

insert into lams_learning_transition(transition_id,transition_ui_id,description,title,to_activity_id,from_activity_id,learning_design_id,create_date_time,to_ui_id,from_ui_id)
values(6,6,'Chat to QNA','Chat to QNA',24,21,1,'20050207',24,7);

insert into lams_learning_transition(transition_id,transition_ui_id,description,title,to_activity_id,from_activity_id,learning_design_id,create_date_time,to_ui_id,from_ui_id)
values(7,7,'QNA to Permission gate','QNA to Permission gate',28,24,1,'20050207',28,24);

insert into lams_learning_transition(transition_id,transition_ui_id,description,title,to_activity_id,from_activity_id,learning_design_id,create_date_time,to_ui_id,from_ui_id)
values(8,8,'Permission gate to OptionsActivity','Permission gate to OptionsActivity',12,28,1,'20050207',12,28);

--insert into lams_learning_transition(transition_id,transition_ui_id,description,title,to_activity_id,from_activity_id,learning_design_id,create_date_time,to_ui_id,from_ui_id)
--values(6,6,'OptionsActivity to Notebook','OptionsActivity to Notebook',16,12,1,'20050207',2,12);

--insert into lams_learning_transition(transition_id,transition_ui_id,description,title,to_activity_id,from_activity_id,learning_design_id,create_date_time,to_ui_id,from_ui_id)
--values(7,7,'Notebook to MultipleChoice','Notebook to MultipleChoice',17,16,1,'20050207',3,2);

--insert into lams_learning_transition(transition_id,transition_ui_id,description,title,to_activity_id,from_activity_id,learning_design_id,create_date_time,to_ui_id,from_ui_id)
--values(8,8,'MultipleChoice to ParallelActivity','MultipleChoice to ParallelActivity',13,17,1,'20050207',13,3);

insert into lams_learning_transition(transition_id,transition_ui_id,description,title,to_activity_id,from_activity_id,learning_design_id,create_date_time,to_ui_id,from_ui_id)
values(9,9,'OptionsActivity to ParallelActivity','OptionsActivity to ParallelActivity',13,12,1,'20050207',13,12);

--insert into lams_learning_transition(transition_id,transition_ui_id,description,title,to_activity_id,from_activity_id,learning_design_id,create_date_time,to_ui_id,from_ui_id)
--values(9,9,'ParallelActivity to QNA','ParallelActivity to QNA',18,13,1,'20050207',4,13);

--insert into lams_learning_transition(transition_id,transition_ui_id,description,title,to_activity_id,from_activity_id,learning_design_id,create_date_time,to_ui_id,from_ui_id)
--values(10,10,'QNA to MessageBoard','QNA to MessageBoard',19,18,1,'20050207',5,4);

insert into lams_learning_transition(transition_id,transition_ui_id,description,title,to_activity_id,from_activity_id,learning_design_id,create_date_time,to_ui_id,from_ui_id)
values(10,10,'ParallelActivity to SequenceActivity','ParallelActivity to SequenceActivity',14,13,1,'20050207',14,13);

--insert into lams_learning_transition(transition_id,transition_ui_id,description,title,to_activity_id,from_activity_id,learning_design_id,create_date_time,to_ui_id,from_ui_id)
--values(12,12,'SequenceActivity to Shared Resources','SequenceActivity to Shared Resources',22,14,1,'20050207',8,14);

--insert into lams_learning_transition(transition_id,transition_ui_id,description,title,to_activity_id,from_activity_id,learning_design_id,create_date_time,to_ui_id,from_ui_id)
--values(13,13,'Shared Resources to QNA','Shared Resources to QNA',25,22,1,'20050207',25,8);


insert into lams_learning_design(learning_design_ui_id,description,title,first_activity_id,max_id,valid_design_flag,
								 read_only_flag,user_id,help_text,copy_type_id,create_date_time,version,
								 parent_learning_design_id,workspace_folder_id,
								 online_instructions,offline_instructions)
								values
								(1,'Test Learning Design','Test Learning Design title',20,1,1,0,1,
								'Help Text',1,'20041223','1.0',null,2,
								'Online instructions', 'Offline instructions');		

-- insert the test data for the content repository
INSERT INTO lams_cr_credential (credential_id, name, password) VALUES (1, 'atool','atool');
INSERT INTO lams_cr_credential (credential_id, name, password) VALUES (2, 'workspaceManager','flashClient');

INSERT INTO lams_cr_workspace  (workspace_id, name) VALUES (1, 'atoolWorkspace');
INSERT INTO lams_cr_workspace  (workspace_id, name) VALUES (2, 'atoolWorkspace2');
INSERT INTO lams_cr_workspace  (workspace_id, name) VALUES (3, 'flashClientsWorkspace');


INSERT INTO lams_cr_workspace_credential  (wc_id, workspace_id, credential_id) VALUES  (1, 1,1);
INSERT INTO lams_cr_workspace_credential  (wc_id, workspace_id, credential_id) VALUES  (2, 2,1);
INSERT INTO lams_cr_workspace_credential  (wc_id, workspace_id, credential_id) VALUES  (3, 3,2);

-- SubmitFiles Tool related information
INSERT INTO lams_cr_credential (credential_id, name, password) VALUES (3, 'SubmitFilesLogin','SubmitFilesPassword');
INSERT INTO lams_cr_workspace  (workspace_id, name) VALUES (4, 'SubmitFilesWorkspace');
INSERT INTO lams_cr_workspace_credential  (wc_id, workspace_id, credential_id) VALUES  (4,4,3);

INSERT INTO lams_cr_node (node_id, workspace_id, type, created_date_time, path, next_version_id) VALUES (1, 1, 'DATANODE', 20050106103100, "/test",3);
INSERT INTO lams_cr_node_version (nv_id, node_id, version_id, created_date_time)
VALUES (1, 1, 1, 20050106103100);
INSERT INTO lams_cr_node_version (nv_id, node_id, version_id, created_date_time)
VALUES (2, 1, 2, 20050106110000);

INSERT INTO lams_cr_node_version_property( id, nv_id, name, value, type) VALUES (1,1,"APPSPEC","abcd",1);
INSERT INTO lams_cr_node_version_property( id, nv_id, name, value, type) VALUES (2,1,"VERSIONDESC","Initial Version.",1);
INSERT INTO lams_cr_node_version_property( id, nv_id, name, value, type) VALUES (3,2,"APPSEC","The quick brown fox jumped over the lazy dog.",1);
INSERT INTO lams_cr_node_version_property( id, nv_id, name, value, type) VALUES (4,2,"VERSIONDESC","The second version.",1);

-- Note : this file node is missing its file as can't setup the repository
INSERT INTO lams_cr_node (node_id, workspace_id, type, created_date_time, path, next_version_id) VALUES (2, 1, 'FILENODE', 20050106103100, "", 2);
INSERT INTO lams_cr_node_version (nv_id, node_id, version_id, created_date_time)
VALUES (3, 2, 1, 20050106103100);
INSERT INTO lams_cr_node_version_property( id, nv_id, name, value, type) VALUES (5,3,"VERSIONDESC","Initial Version.",1);
INSERT INTO lams_cr_node_version_property( id, nv_id, name, value, type) VALUES (6,3,"FILENAME","nofile.txt",1);
INSERT INTO lams_cr_node_version_property( id, nv_id, name, value, type) VALUES (7,3,"MIMETYPE","unknown/unknown",1);														

INSERT INTO lams_workspace_folder_content VALUES (1,1,'Document','Test Description','20050101','20050101',2,NULL,NULL,'DOC');
INSERT INTO lams_workspace_folder_content VALUES (2,1,'Text File','Test Description','20050101','20050101',2,NULL,NULL,'TXT');
INSERT INTO lams_workspace_folder_content VALUES (3,1,'Text File','Test Description','20050101','20050101',3,NULL,NULL,'TXT');
INSERT INTO lams_workspace_folder_content VALUES (4,1,'Gif File','Test Description','20050101','20050101',3,NULL,NULL,'GIF');
INSERT INTO lams_workspace_folder_content VALUES (5,1,'Gif2 File','Test Description','20050101','20050101',3,NULL,NULL,'GIF');
INSERT INTO lams_workspace_folder_content VALUES (6,1,'Text2 File','Test Description','20050101','20050101',3,NULL,NULL,'TXT');

SET FOREIGN_KEY_CHECKS=1;