Index: lams_common/db/sql/insert_test_data.sql =================================================================== diff -u -r60b4f19e6e897384015702a56309abb837b76165 -r950ffe777776ecffa7f99e02b9674f0c71d382ab --- lams_common/db/sql/insert_test_data.sql (.../insert_test_data.sql) (revision 60b4f19e6e897384015702a56309abb837b76165) +++ lams_common/db/sql/insert_test_data.sql (.../insert_test_data.sql) (revision 950ffe777776ecffa7f99e02b9674f0c71d382ab) @@ -60,60 +60,82 @@ -- 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,default_tool_content_id,supports_grouping_flag,supports_define_later_flag, -learner_url,author_url,define_later_url,export_portfolio_url,monitor_url,valid_flag,learning_library_id) -values(1,'notebook_signature','notebookService','Notebook','Notebook Description',1,0,0, -'learner_url','author_url','define_later_url','export_portfolio_url','monitor_url',1,1); +insert into lams_tool (tool_id,tool_signature,service_name,tool_display_name,description,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,valid_flag,learning_library_id,create_date_time) +values(1,'notebook_signature','notebookService','Notebook','Notebook Description',1,1,0, +1,1,1, +'learner_url','author_url','define_later_url','export_portfolio_url','monitor_url',1,1,'2005-02-25 17:37:25'); -insert into lams_tool (tool_id,tool_signature,service_name,tool_display_name,description,default_tool_content_id,supports_grouping_flag,supports_define_later_flag, -learner_url,author_url,define_later_url,export_portfolio_url,monitor_url,valid_flag,learning_library_id) -values(2,'noticeboard_signature','noticeboardService','Noticeboard','Noticeboard Description',2,0,0, -'learner_url','author_url','define_later_url','export_portfolio_url','monitor_url',1,2); +insert into lams_tool (tool_id,tool_signature,service_name,tool_display_name,description,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,valid_flag,learning_library_id,create_date_time) +values(2,'noticeboard_signature','noticeboardService','Noticeboard','Noticeboard Description',2,1,0, +1,1,1, +'learner_url','author_url','define_later_url','export_portfolio_url','monitor_url',1,2,'2005-02-25 17:37:25'); -insert into lams_tool (tool_id,tool_signature,service_name,tool_display_name,description,default_tool_content_id,supports_grouping_flag,supports_define_later_flag, -learner_url,author_url,define_later_url,export_portfolio_url,monitor_url,valid_flag,learning_library_id) -values(3,'multiple_choice_signature','multipleChoiceService','Multiple Choice','Multiple Coice Description',3,0,0, -'learner_url','author_url','define_later_url','export_portfolio_url','monitor_url',1,3); +insert into lams_tool (tool_id,tool_signature,service_name,tool_display_name,description,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,valid_flag,learning_library_id,create_date_time) +values(3,'multiple_choice_signature','multipleChoiceService','Multiple Choice','Multiple Coice Description',3,3,0, +1,1,1, +'learner_url','author_url','define_later_url','export_portfolio_url','monitor_url',1,3,'2005-02-25 17:37:25'); -insert into lams_tool (tool_id,tool_signature,service_name,tool_display_name,description,default_tool_content_id,supports_grouping_flag,supports_define_later_flag, -learner_url,author_url,define_later_url,export_portfolio_url,monitor_url,valid_flag,learning_library_id) -values(4,'question_answer_signature','questionAnswerService','Question and Answers','Question and Answers Description',4,0,0, -'learner_url','author_url','define_later_url','export_portfolio_url','monitor_url',1,4); +insert into lams_tool (tool_id,tool_signature,service_name,tool_display_name,description,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,valid_flag,learning_library_id,create_date_time) +values(4,'question_answer_signature','questionAnswerService','Question and Answers','Question and Answers Description',4,3,0, +1,1,1, +'learner_url','author_url','define_later_url','export_portfolio_url','monitor_url',1,4,'2005-02-25 17:37:25'); -insert into lams_tool (tool_id,tool_signature,service_name,tool_display_name,description,default_tool_content_id,supports_grouping_flag,supports_define_later_flag, -learner_url,author_url,define_later_url,export_portfolio_url,monitor_url,valid_flag,learning_library_id) -values(5,'message_board_signature','messageBoardService','Message Board','Message Board Description',5,1,0, -'learner_url','author_url','define_later_url','export_portfolio_url','monitor_url',1,5); +insert into lams_tool (tool_id,tool_signature,service_name,tool_display_name,description,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,valid_flag,learning_library_id,create_date_time) +values(5,'message_board_signature','messageBoardService','Message Board','Message Board Description',5,3,0, +1,1,1, +'learner_url','author_url','define_later_url','export_portfolio_url','monitor_url',1,5,'2005-02-25 17:37:25'); -insert into lams_tool (tool_id,tool_signature,service_name,tool_display_name,description,default_tool_content_id,supports_grouping_flag,supports_define_later_flag, -learner_url,author_url,define_later_url,export_portfolio_url,monitor_url,valid_flag,learning_library_id) -values(6,'survey_signature','surveyService','Survey','Survey Description',6,0,0, -'/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',1,6); +insert into lams_tool (tool_id,tool_signature,service_name,tool_display_name,description,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,valid_flag,learning_library_id,create_date_time) +values(6,'survey_signature','surveyService','Survey','Survey Description',6,1,0, +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',1,6,'2005-02-25 17:37:25'); -insert into lams_tool (tool_id,tool_signature,service_name,tool_display_name,description,default_tool_content_id,supports_grouping_flag,supports_define_later_flag, -learner_url,author_url,define_later_url,export_portfolio_url,monitor_url,valid_flag,learning_library_id) -values(7,'chat_signature','chatService','Chat','Chat Description',7,1,0, -'learner_url','author_url','define_later_url','export_portfolio_url','monitor_url',1,7); +insert into lams_tool (tool_id,tool_signature,service_name,tool_display_name,description,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,valid_flag,learning_library_id,create_date_time) +values(7,'chat_signature','chatService','Chat','Chat Description',7,3,0, +1,1,1, +'learner_url','author_url','define_later_url','export_portfolio_url','monitor_url',1,7,'2005-02-25 17:37:25'); -insert into lams_tool (tool_id,tool_signature,service_name,tool_display_name,description,default_tool_content_id,supports_grouping_flag,supports_define_later_flag, -learner_url,author_url,define_later_url,export_portfolio_url,monitor_url,valid_flag,learning_library_id) -values(8,'shared_resources_signature','sharedResourcesService','Shared Resources','Shared Resources Description',8,0,0, -'learner_url','author_url','define_later_url','export_portfolio_url','monitor_url',1,8); +insert into lams_tool (tool_id,tool_signature,service_name,tool_display_name,description,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,valid_flag,learning_library_id,create_date_time) +values(8,'shared_resources_signature','sharedResourcesService','Shared Resources','Shared Resources Description',8,3,0, +1,1,1, +'learner_url','author_url','define_later_url','export_portfolio_url','monitor_url',1,8,'2005-02-25 17:37:25'); -insert into lams_tool (tool_id,tool_signature,service_name,tool_display_name,description,default_tool_content_id,supports_grouping_flag,supports_define_later_flag, -learner_url,author_url,define_later_url,export_portfolio_url,monitor_url,valid_flag,learning_library_id) -values(9,'voting_signature','votingService','Voting','Voting Description',9,1,0, -'learner_url','author_url','define_later_url','export_portfolio_url','monitor_url',1,9); +insert into lams_tool (tool_id,tool_signature,service_name,tool_display_name,description,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,valid_flag,learning_library_id,create_date_time) +values(9,'voting_signature','votingService','Voting','Voting Description',9,3,0, +1,1,1, +'learner_url','author_url','define_later_url','export_portfolio_url','monitor_url',1,9,'2005-02-25 17:37:25'); -insert into lams_tool (tool_id,tool_signature,service_name,tool_display_name,description,default_tool_content_id,supports_grouping_flag,supports_define_later_flag, -learner_url,author_url,define_later_url,export_portfolio_url,monitor_url,valid_flag,learning_library_id) -values(10,'submit_files_signature','submitFilesService','Submit Files','Submit Files Description',10,0,0, -'learner_url','author_url','define_later_url','export_portfolio_url','monitor_url',1,10); +insert into lams_tool (tool_id,tool_signature,service_name,tool_display_name,description,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,valid_flag,learning_library_id,create_date_time) +values(10,'submit_files_signature','submitFilesService','Submit Files','Submit Files Description',10,1,0, +1,1,1, +'learner_url','author_url','define_later_url','export_portfolio_url','monitor_url',1,10,'2005-02-25 17:37:25'); -insert into lams_tool (tool_id,tool_signature,service_name,tool_display_name,description,default_tool_content_id,supports_grouping_flag,supports_define_later_flag, -learner_url,author_url,define_later_url,export_portfolio_url,monitor_url,valid_flag,learning_library_id) -values(11,'instant_messaging_signature','instantMessagingService','Instant Messaging','Instant Messaging Description',11,0,0, -'learner_url','author_url','define_later_url','export_portfolio_url','monitor_url',1,11); +insert into lams_tool (tool_id,tool_signature,service_name,tool_display_name,description,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,valid_flag,learning_library_id,create_date_time) +values(11,'instant_messaging_signature','instantMessagingService','Instant Messaging','Instant Messaging Description',11,1,0, +1,1,1, +'learner_url','author_url','define_later_url','export_portfolio_url','monitor_url',1,11,'2005-02-25 17:37:25'); -- Populates the lams_tool_content table with dummy default content for all above tools @@ -164,250 +186,290 @@ learning_activity_type_id,grouping_id,order_id,define_later_flag, learning_design_id,learning_library_id,create_date_time,offline_instructions,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) +gate_activity_level_id,gate_start_time_offset,gate_end_time_offset,library_activity_ui_image, +grouping_support_type_id, apply_grouping_flag,online_instructions,activity_category_id) values (1,1,'Notebook Template','Notebook',10,20,null,'Help Text for Activity', 1,null,0,0, null,1,'20050101','Offline Instructions ',0, null,null,1,1, -null,null,null,'NotebookImage'); +null,null,null,'NotebookImage', +1,0,'Online Instructions',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,offline_instructions,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) +gate_activity_level_id,gate_start_time_offset,gate_end_time_offset,library_activity_ui_image, +grouping_support_type_id, apply_grouping_flag,online_instructions,activity_category_id) values (2,2,'NoticeBoard Template','NoticeBoard',10,20,null,'Help Text for Activity', 1,null,0,0, null,2,'20050101','Offline Instructions ',0, null,null,2,2, -null,null,null,'NoticeBoardImage'); +null,null,null,'NoticeBoardImage', +1,0,'Online Instructions',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,offline_instructions,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) +gate_activity_level_id,gate_start_time_offset,gate_end_time_offset,library_activity_ui_image, +grouping_support_type_id, apply_grouping_flag,online_instructions,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','Offline Instructions ',0, null,null,3,3, -null,null,null,'MultipleChoiceImage'); +null,null,null,'MultipleChoiceImage', +1,0,'Online Instructions',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,offline_instructions,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) +gate_activity_level_id,gate_start_time_offset,gate_end_time_offset,library_activity_ui_image, +grouping_support_type_id, apply_grouping_flag,online_instructions,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','Offline Instructions ',0, null,null,4,4, -null,null,null,'QAImage'); +null,null,null,'QAImage', +1,0,'Online Instructions',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,offline_instructions,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) +gate_activity_level_id,gate_start_time_offset,gate_end_time_offset,library_activity_ui_image, +grouping_support_type_id, apply_grouping_flag,online_instructions,activity_category_id) values (5,5,'MessageBoard Template','MessageBoard',10,20,null,'Help Text for Activity', 1,null,0,0, null,5,'20050101','Offline Instructions ',0, null,null,5,5, -null,null,null,'MBImage'); +null,null,null,'MBImage', +1,0,'Online Instructions',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,offline_instructions,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) +gate_activity_level_id,gate_start_time_offset,gate_end_time_offset,library_activity_ui_image, +grouping_support_type_id, apply_grouping_flag,online_instructions,activity_category_id) values (6,6,'Survey Template','Survey',10,20,null,'Help Text for Activity', 1,null,0,0, null,6,'20050101','Offline Instructions ',0, null,null,6,6, -null,null,null,'SurveyImage'); +null,null,null,'SurveyImage', +1,0,'Online Instructions',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,offline_instructions,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) +gate_activity_level_id,gate_start_time_offset,gate_end_time_offset,library_activity_ui_image, +grouping_support_type_id, apply_grouping_flag,online_instructions,activity_category_id) values (7,7,'Chat Template','Chat',10,20,null,'Help Text for Activity', 1,null,0,0, null,7,'20050101','Offline Instructions ',0, null,null,7,7, -null,null,null,'ChatImage'); +null,null,null,'ChatImage', +1,0,'Online Instructions',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,offline_instructions,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) +gate_activity_level_id,gate_start_time_offset,gate_end_time_offset,library_activity_ui_image, +grouping_support_type_id, apply_grouping_flag,online_instructions,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','Offline Instructions ',0, null,null,8,8, -null,null,null,'SRImage'); +null,null,null,'SRImage', +1,0,'Online Instructions',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,offline_instructions,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) +gate_activity_level_id,gate_start_time_offset,gate_end_time_offset,library_activity_ui_image, +grouping_support_type_id, apply_grouping_flag,online_instructions,activity_category_id) values (9,9,'Voting Template','Voting',10,20,null,'Help Text for Activity', 1,null,0,0, null,9,'20050101','Offline Instructions ',0, null,null,9,9, -null,null,null,'VotingImage'); +null,null,null,'VotingImage', +1,0,'Online Instructions',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,offline_instructions,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) +gate_activity_level_id,gate_start_time_offset,gate_end_time_offset,library_activity_ui_image, +grouping_support_type_id, apply_grouping_flag,online_instructions,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','Offline Instructions ',0, null,null,10,10, -null,null,null,'SubmitFilesImage'); +null,null,null,'SubmitFilesImage', +1,0,'Online Instructions',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,offline_instructions,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) +gate_activity_level_id,gate_start_time_offset,gate_end_time_offset,library_activity_ui_image, +grouping_support_type_id, apply_grouping_flag,online_instructions,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','Offline Instructions ',0, null,null,11,11, -null,null,null,'IMImage'); +null,null,null,'IMImage', +1,0,'Online Instructions',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,offline_instructions,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) +gate_activity_level_id,gate_start_time_offset,gate_end_time_offset,library_activity_ui_image, +grouping_support_type_id, apply_grouping_flag,online_instructions,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','Offline Instructions ',0, 1,1,null,null, -null,'20050101','20050101','image'); +null,'20050101','20050101','image', +1,0,'Online Instructions',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,offline_instructions,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) +gate_activity_level_id,gate_start_time_offset,gate_end_time_offset,library_activity_ui_image, +grouping_support_type_id, apply_grouping_flag,online_instructions,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','Parallel Activity Offline Instructions ',0, null,null,null,null, -null,null,null,'image'); +null,null,null,'image', +1,0,'Online Instructions',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,offline_instructions,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) +gate_activity_level_id,gate_start_time_offset,gate_end_time_offset,library_activity_ui_image, +grouping_support_type_id, apply_grouping_flag,online_instructions,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','Sequence Activity Offline Instructions ',0, null,null,null,null, -null,null,null,'image'); +null,null,null,'image', +1,0,'Online Instructions',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,offline_instructions,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) +gate_activity_level_id,gate_start_time_offset,gate_end_time_offset,library_activity_ui_image, +grouping_support_type_id, apply_grouping_flag,online_instructions,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','Notebook Activity Offline Instructions ',0, null,null,1,12, -null,null,null,'image'); +null,null,null,'image', +1,0,'Online Instructions',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,offline_instructions,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) +gate_activity_level_id,gate_start_time_offset,gate_end_time_offset,library_activity_ui_image, +grouping_support_type_id, apply_grouping_flag,online_instructions,activity_category_id) values (16,2,'NoticeBoard Activity','NoticeBoard Activity',10,20,12,'Help Text for Activity', 1,null,0,0, 1,2,'20050101','NoticeBoard Activity Offline Instructions ',0, null,null,2,13, -null,null,null,'image'); +null,null,null,'image', +1,0,'Online Instructions',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,offline_instructions,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) +gate_activity_level_id,gate_start_time_offset,gate_end_time_offset,library_activity_ui_image, +grouping_support_type_id, apply_grouping_flag,online_instructions,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','Tool Activity Offline Instructions ',0, null,null,3,14, -null,null,null,'image'); +null,null,null,'image', +1,0,'Online Instructions',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,offline_instructions,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) +gate_activity_level_id,gate_start_time_offset,gate_end_time_offset,library_activity_ui_image, +grouping_support_type_id, apply_grouping_flag,online_instructions,activity_category_id) values (18,4,'Question and Answer Activity','Question and Answer',10,20,13,'Help Text for Activity', 1,null,0,0, 1,4,'20050101','Tool Activity Offline Instructions ',0, null,null,4,15, -null,null,null,'image'); +null,null,null,'image', +1,0,'Online Instructions',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,offline_instructions,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) +gate_activity_level_id,gate_start_time_offset,gate_end_time_offset,library_activity_ui_image, +grouping_support_type_id, apply_grouping_flag,online_instructions,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','Tool Activity Offline Instructions ',0, null,null,5,16, -null,null,null,'image'); +null,null,null,'image', +1,0,'Online Instructions',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,offline_instructions,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) +gate_activity_level_id,gate_start_time_offset,gate_end_time_offset,library_activity_ui_image, +grouping_support_type_id, apply_grouping_flag,online_instructions,activity_category_id) values (20,6,'Survey Activity','Survey Title',10,20,null,'Help Text for Activity', 1,null,0,0, 1,6,'20050101','Tool Activity Offline Instructions ',0, null,null,6,17, -null,null,null,'image'); +null,null,null,'image', +1,0,'Online Instructions',1); insert into lams_learning_activity (activity_id,activity_ui_id, @@ -424,7 +486,8 @@ gate_start_date_time,gate_end_date_time, library_activity_ui_image, create_grouping_id,create_grouping_ui_id, -library_activity_id) +library_activity_id, +grouping_support_type_id, apply_grouping_flag,online_instructions,activity_category_id) values (21,7, 'Chat Activity Description','Chat Title','Help Text for Chat Activity', @@ -440,20 +503,23 @@ null,null, 'ChatImage', null,null, -7); +7, +1,0,'Online Instructions',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,offline_instructions,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) +gate_activity_level_id,gate_start_time_offset,gate_end_time_offset,library_activity_ui_image, +grouping_support_type_id, apply_grouping_flag,online_instructions,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','Tool Activity Offline Instructions ',0, null,null,8,19, -null,null,null,'image'); +null,null,null,'image', +1,0,'Online Instructions',1); -- Sample GroupingActivity with RandomGrouping @@ -472,7 +538,8 @@ gate_start_date_time,gate_end_date_time, library_activity_ui_image, create_grouping_id,create_grouping_ui_id, -library_activity_id) +library_activity_id, +grouping_support_type_id, apply_grouping_flag,online_instructions,activity_category_id) values (23,23, 'Random Grouping Activity Description','RandomGroupingActivity Title','Help Text for RandomGroupingActivity', @@ -488,7 +555,8 @@ null,null, 'RandomGroupingActivityImage', 99,99, -null); +null, +1,0,'Online Instructions',1); insert into lams_learning_activity (activity_id,activity_ui_id, @@ -505,7 +573,8 @@ gate_start_date_time,gate_end_date_time, library_activity_ui_image, create_grouping_id,create_grouping_ui_id, -library_activity_id) +library_activity_id, +grouping_support_type_id, apply_grouping_flag,online_instructions,activity_category_id) values (24,24, 'QNA Activity Description','QNA Activity Title','Help Text for QNA Activity', @@ -521,7 +590,8 @@ null,null, 'QNAImage', null,null, -4); +4, +1,0,'Online Instructions',1); insert into lams_learning_activity (activity_id,activity_ui_id, @@ -538,7 +608,8 @@ gate_start_date_time,gate_end_date_time, library_activity_ui_image, create_grouping_id,create_grouping_ui_id, -library_activity_id) +library_activity_id, +grouping_support_type_id, apply_grouping_flag,online_instructions,activity_category_id) values (25,25, 'QNA Activity Description','QNA Activity Title','Help Text for QNA Activity', @@ -554,7 +625,8 @@ null,null, 'QNAImage', null,null, -4); +4, +1,0,'Online Instructions',1); -- Populates the lams_learning_transition table with various transitions for the dummy design