Index: lams_common/db/sql/insert_test_data.sql
===================================================================
diff -u -r63cfec31786d311b9aa03d9a03b9a200cb60ecfe -r1f475f1357aa1248cd4c31dc6dae4b3473142511
--- lams_common/db/sql/insert_test_data.sql	(.../insert_test_data.sql)	(revision 63cfec31786d311b9aa03d9a03b9a200cb60ecfe)
+++ lams_common/db/sql/insert_test_data.sql	(.../insert_test_data.sql)	(revision 1f475f1357aa1248cd4c31dc6dae4b3473142511)
@@ -18,107 +18,132 @@
 -- 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,create_date_time)
+grouping_support_type_id,supports_run_offline_flag,
+learner_url, learner_preview_url, learner_progress_url, author_url, define_later_url, 
+export_pfolio_learner_url, export_pfolio_class_url, monitor_url,contribute_url, moderation_url,
+language_file, valid_flag,learning_library_id,create_date_time)
 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,now());
+2,1,
+'learner_url','learner_url','learner_url','author_url','define_later_url',
+'export_portfolio_learner_url','export_portfolio_learner_url','monitor_url','contribute_url','moderation_url',
+'toolsig.ApplicationResources',1,1,now());
 
 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,create_date_time)
+grouping_support_type_id,supports_run_offline_flag,
+learner_url, learner_preview_url, learner_progress_url, author_url, define_later_url, 
+export_pfolio_learner_url, export_pfolio_class_url, monitor_url,contribute_url, moderation_url,
+language_file, valid_flag,learning_library_id,create_date_time)
 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,now());
+2,1,
+'learner_url','learner_url','learner_url','author_url','define_later_url',
+'export_portfolio_learner_url','export_portfolio_learner_url','monitor_url','contribute_url','moderation_url',
+'toolsig.ApplicationResources',1,2,now());
 
 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,create_date_time)
+grouping_support_type_id,supports_run_offline_flag,
+learner_url, learner_preview_url, learner_progress_url, author_url, define_later_url, 
+export_pfolio_learner_url, export_pfolio_class_url, monitor_url,contribute_url, moderation_url,
+language_file, valid_flag,learning_library_id,create_date_time)
 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,now());
+2,1,
+'learner_url','learner_url','learner_url','author_url','define_later_url',
+'export_portfolio_learner_url','export_portfolio_learner_url','monitor_url','contribute_url','moderation_url',
+'toolsig.ApplicationResources',1,3,now());
 
 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,create_date_time)
+grouping_support_type_id,supports_run_offline_flag,
+learner_url, learner_preview_url, learner_progress_url, author_url, define_later_url, 
+export_pfolio_learner_url, export_pfolio_class_url, monitor_url,contribute_url, moderation_url,
+language_file, valid_flag,learning_library_id,create_date_time)
 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,now());
+2,1,
+'learner_url','learner_url','learner_url','author_url','define_later_url',
+'export_portfolio_learner_url','export_portfolio_learner_url','monitor_url','contribute_url','moderation_url',
+'toolsig.ApplicationResources',1,4,now());
 
 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,create_date_time)
+grouping_support_type_id,supports_run_offline_flag,
+learner_url, learner_preview_url, learner_progress_url, author_url, define_later_url, 
+export_pfolio_learner_url, export_pfolio_class_url, monitor_url,contribute_url, moderation_url,
+language_file, valid_flag,learning_library_id,create_date_time)
 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,now());
+2,1,
+'learner_url','learner_url','learner_url','author_url','define_later_url',
+'export_portfolio_learner_url','export_portfolio_learner_url','monitor_url','contribute_url','moderation_url',
+'toolsig.ApplicationResources',1,5,now());
 
 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,create_date_time)
+grouping_support_type_id,supports_run_offline_flag,
+learner_url, learner_preview_url, learner_progress_url, author_url, define_later_url, 
+export_pfolio_learner_url, export_pfolio_class_url, monitor_url,contribute_url, moderation_url,
+language_file, valid_flag,learning_library_id,create_date_time)
 values(6,'survey_signature','srvyService','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',
+2,1,
+'/lams_tool_survey/tool/survey/survey.do?method=loadQuestionnaire',
+'/lams_tool_survey/tool/survey/survey.do?method=loadQuestionnaire',
+'/lams_tool_survey/tool/survey/survey.do?method=loadQuestionnaire',
+'/lams_tool_survey/tool/survey/authoring.do?method=loadSurvey','define_later_url',
+'export_portfolio_learner_url','export_portfolio_learner_url',
 '/lams_tool_survey/tool/survey/report.do?method=loadMonitorReport','contribute_url','moderation_url',
-1,6,now());
+'toolsig.ApplicationResources',1,6,now());
 
 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,create_date_time)
+grouping_support_type_id,supports_run_offline_flag,
+learner_url, learner_preview_url, learner_progress_url, author_url, define_later_url, 
+export_pfolio_learner_url, export_pfolio_class_url, monitor_url,contribute_url, moderation_url,
+language_file, valid_flag,learning_library_id,create_date_time)
 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,now());
+2,1,
+'learner_url','learner_url','learner_url','author_url','define_later_url',
+'export_portfolio_learner_url','export_portfolio_learner_url','monitor_url','contribute_url','moderation_url',
+'toolsig.ApplicationResources',1,7,now());
 
 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,create_date_time)
+grouping_support_type_id,supports_run_offline_flag,
+learner_url, learner_preview_url, learner_progress_url, author_url, define_later_url, 
+export_pfolio_learner_url, export_pfolio_class_url, monitor_url,contribute_url, moderation_url,
+language_file, valid_flag,learning_library_id,create_date_time)
 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,now());
+2,1,
+'learner_url','learner_url','learner_url','author_url','define_later_url',
+'export_portfolio_learner_url','export_portfolio_learner_url','monitor_url','contribute_url','moderation_url',
+'toolsig.ApplicationResources',1,8,now());
 
 
 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,create_date_time)
+grouping_support_type_id,supports_run_offline_flag,
+learner_url, learner_preview_url, learner_progress_url, author_url, define_later_url, 
+export_pfolio_learner_url, export_pfolio_class_url, monitor_url,contribute_url, moderation_url,
+language_file, valid_flag,learning_library_id,create_date_time)
 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,now());
+2,1,
+'learner_url','learner_url','learner_url','author_url','define_later_url',
+'export_portfolio_learner_url','export_portfolio_learner_url','monitor_url','contribute_url','moderation_url',
+'toolsig.ApplicationResources',1,9,now());
 
 
 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,create_date_time)
+grouping_support_type_id,supports_run_offline_flag,
+learner_url, learner_preview_url, learner_progress_url, author_url, define_later_url, 
+export_pfolio_learner_url, export_pfolio_class_url, monitor_url,contribute_url, moderation_url,
+language_file, valid_flag,learning_library_id,create_date_time)
 values(10,'submit_files_signature','sbService','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,now());
+2,1,
+'learner_url','learner_url','learner_url','author_url','define_later_url',
+'export_portfolio_learner_url','export_portfolio_learner_url','monitor_url','contribute_url','moderation_url',
+'toolsig.ApplicationResources',1,10,now());
 
 
 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,create_date_time)
+grouping_support_type_id,supports_run_offline_flag,
+learner_url, learner_preview_url, learner_progress_url, author_url, define_later_url, 
+export_pfolio_learner_url, export_pfolio_class_url, monitor_url,contribute_url, moderation_url,
+language_file, valid_flag,learning_library_id,create_date_time)
 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,now());
+2,1,
+'learner_url','learner_url','learner_url','author_url','define_later_url',
+'export_portfolio_learner_url','export_portfolio_learner_url','monitor_url','contribute_url','moderation_url',
+'toolsig.ApplicationResources',1,11,now());
 
 -- Populates the lams_tool_content table with dummy default content for all above tools
 
@@ -175,289 +200,289 @@
 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)
+grouping_support_type_id, apply_grouping_flag,activity_category_id,language_file)
 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,'/images/icon_journal.swf',
-1,0,1);
+1,0,1,'toolsig.ApplicationResources');
 
 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)
+grouping_support_type_id, apply_grouping_flag,activity_category_id,language_file)
 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,'/images/icon_noticeboard.swf',
-1,0,1);
+1,0,1,'toolsig.ApplicationResources');
 
 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)
+grouping_support_type_id, apply_grouping_flag,activity_category_id,language_file)
 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);
+1,0,1,'toolsig.ApplicationResources');
 
 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)
+grouping_support_type_id, apply_grouping_flag,activity_category_id,language_file)
 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,'tool/laqa/images/icon_questionanswer.swf',
-1,0,1);
+1,0,1,'toolsig.ApplicationResources');
 
 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)
+grouping_support_type_id, apply_grouping_flag,activity_category_id,language_file)
 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,'/images/icon_messageboard.swf',
-1,0,1);
+1,0,1,'toolsig.ApplicationResources');
 
 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)
+grouping_support_type_id, apply_grouping_flag,activity_category_id,language_file)
 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,'/images/icon_survey.swf',
-1,0,1);
+1,0,1,'toolsig.ApplicationResources');
 
 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)
+grouping_support_type_id, apply_grouping_flag,activity_category_id,language_file)
 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,'/images/icon_chat.swf',
-1,0,1);
+1,0,1,'toolsig.ApplicationResources');
 
 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)
+grouping_support_type_id, apply_grouping_flag,activity_category_id,language_file)
 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,'/images/icon_singleresource.swf',
-1,0,1);
+1,0,1,'toolsig.ApplicationResources');
 
 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)
+grouping_support_type_id, apply_grouping_flag,activity_category_id,language_file)
 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,'/images/icon_ranking.swf',
-1,0,1);
+1,0,1,'toolsig.ApplicationResources');
 
 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)
+grouping_support_type_id, apply_grouping_flag,activity_category_id,language_file)
 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,'/images/icon_reportsubmission.swf',
-1,0,1);
+1,0,1,'toolsig.ApplicationResources');
 
 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)
+grouping_support_type_id, apply_grouping_flag,activity_category_id,language_file)
 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);
+1,0,1,'toolsig.ApplicationResources');
 
 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)
+grouping_support_type_id, apply_grouping_flag,activity_category_id,language_file)
 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);
+3,1,1,'toolsig.ApplicationResources');
 
 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)
+grouping_support_type_id, apply_grouping_flag,activity_category_id,language_file)
 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);
+1,0,1,'toolsig.ApplicationResources');
 
 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)
+grouping_support_type_id, apply_grouping_flag,activity_category_id,language_file)
 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);
+1,0,1,'toolsig.ApplicationResources');
 
 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)
+grouping_support_type_id, apply_grouping_flag,activity_category_id,language_file)
 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,'/images/icon_journal.swf',
-1,0,1);
+1,0,1,'toolsig.ApplicationResources');
 
 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)
+grouping_support_type_id, apply_grouping_flag,activity_category_id,language_file)
 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,'/images/icon_noticeboard.swf',
-1,0,1);
+1,0,1,'toolsig.ApplicationResources');
 
 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)
+grouping_support_type_id, apply_grouping_flag,activity_category_id,language_file)
 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);
+1,0,1,'toolsig.ApplicationResources');
 
 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)
+grouping_support_type_id, apply_grouping_flag,activity_category_id,language_file)
 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,'tool/laqa/images/icon_questionanswer.swf',
-1,0,1);
+1,0,1,'toolsig.ApplicationResources');
 
 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)
+grouping_support_type_id, apply_grouping_flag,activity_category_id,language_file)
 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,'/images/icon_messageboard.swf',
-1,0,1);
+1,0,1,'toolsig.ApplicationResources');
 
 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)
+grouping_support_type_id, apply_grouping_flag,activity_category_id,language_file)
 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,'/images/icon_survey.swf',
-1,0,1);
+1,0,1,'toolsig.ApplicationResources');
 
 insert into lams_learning_activity
 (activity_id,activity_ui_id,
@@ -475,7 +500,7 @@
 library_activity_ui_image,
 create_grouping_id,create_grouping_ui_id,
 library_activity_id,
-grouping_support_type_id, apply_grouping_flag,activity_category_id)
+grouping_support_type_id, apply_grouping_flag,activity_category_id,language_file)
 values
 (21,7,
 'Chat Activity Description','Chat Title','Help Text for Chat Activity',
@@ -492,22 +517,22 @@
 '/images/icon_chat.swf',
 null,null,
 7,
-2,1,1);
+2,1,1,'toolsig.ApplicationResources');
 
 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)
+grouping_support_type_id, apply_grouping_flag,activity_category_id,language_file)
 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,'/images/icon_singleresource.swf',
-1,0,1);
+1,0,1,'toolsig.ApplicationResources');
 
 -- Sample GroupingActivity with RandomGrouping 
 
@@ -527,7 +552,7 @@
 library_activity_ui_image,
 create_grouping_id,create_grouping_ui_id,
 library_activity_id,
-grouping_support_type_id, apply_grouping_flag,activity_category_id)
+grouping_support_type_id, apply_grouping_flag,activity_category_id,language_file)
 values
 (23,23,
 'Random Grouping Activity Description','RandomGroupingActivity Title','Help Text for RandomGroupingActivity',
@@ -544,7 +569,7 @@
 'missing.swf',
 99,99,
 null,
-1,0,1);
+1,0,1,'toolsig.ApplicationResources');
 
 insert into lams_learning_activity
 (activity_id,activity_ui_id,
@@ -562,7 +587,7 @@
 library_activity_ui_image,
 create_grouping_id,create_grouping_ui_id,
 library_activity_id,
-grouping_support_type_id, apply_grouping_flag,activity_category_id)
+grouping_support_type_id, apply_grouping_flag,activity_category_id,language_file)
 values
 (30,30,
 'Chosen Grouping Activity Description','ChosenroupingActivity Title','Help Text for ChosenGroupingActivity',
@@ -579,7 +604,7 @@
 'missing.swf',
 100,100,
 null,
-1,0,1);
+1,0,1,'toolsig.ApplicationResources');
 
 insert into lams_learning_activity
 (activity_id,activity_ui_id,
@@ -597,7 +622,7 @@
 library_activity_ui_image,
 create_grouping_id,create_grouping_ui_id,
 library_activity_id,
-grouping_support_type_id, apply_grouping_flag,activity_category_id)
+grouping_support_type_id, apply_grouping_flag,activity_category_id,language_file)
 values
 (24,24,
 'QNA Activity Description','QNA Activity Title','Help Text for QNA Activity',
@@ -614,7 +639,7 @@
 'tool/laqa/images/icon_questionanswer.swf',
 null,null,
 4,
-2,1,1);
+2,1,1,'toolsig.ApplicationResources');
 
 insert into lams_learning_activity
 (activity_id,activity_ui_id,
@@ -632,7 +657,7 @@
 library_activity_ui_image,
 create_grouping_id,create_grouping_ui_id,
 library_activity_id,
-grouping_support_type_id, apply_grouping_flag,activity_category_id)
+grouping_support_type_id, apply_grouping_flag,activity_category_id,language_file)
 values
 (25,25,
 'QNA Activity Description','QNA Activity Title','Help Text for QNA Activity',
@@ -649,7 +674,7 @@
 'tool/laqa/images/icon_questionanswer.swf',
 null,null,
 4,
-1,0,1);
+1,0,1,'toolsig.ApplicationResources');
 
 
 
@@ -669,7 +694,7 @@
 library_activity_ui_image,
 create_grouping_id,create_grouping_ui_id,
 library_activity_id,
-grouping_support_type_id, apply_grouping_flag,activity_category_id)
+grouping_support_type_id, apply_grouping_flag,activity_category_id,language_file)
 values
 (26,26,
 'Synch Gate','Synch Gate Activity','Help Text for Synch Gate',
@@ -686,7 +711,7 @@
 'missing.swf',
 null,null,
 null,
-1,0,1);
+1,0,1,'toolsig.ApplicationResources');
 
 insert into lams_learning_activity
 (activity_id,activity_ui_id,
@@ -704,7 +729,7 @@
 library_activity_ui_image,
 create_grouping_id,create_grouping_ui_id,
 library_activity_id,
-grouping_support_type_id, apply_grouping_flag,activity_category_id)
+grouping_support_type_id, apply_grouping_flag,activity_category_id,language_file)
 values
 (27,27,
 'Schedule Gate','Schedule Gate Activity','Help Text for Schedule Gate',
@@ -721,7 +746,7 @@
 'missing.swf',
 null,null,
 null,
-1,0,1);
+1,0,1,'toolsig.ApplicationResources');
 
 insert into lams_learning_activity
 (activity_id,activity_ui_id,
@@ -739,7 +764,7 @@
 library_activity_ui_image,
 create_grouping_id,create_grouping_ui_id,
 library_activity_id,
-grouping_support_type_id, apply_grouping_flag,activity_category_id)
+grouping_support_type_id, apply_grouping_flag,activity_category_id,language_file)
 values
 (28,28,
 'Permission Gate','Permission Gate Activity','Help Text for Permission Gate',
@@ -756,7 +781,7 @@
 'missing.swf',
 null,null,
 null,
-1,0,1);
+1,0,1,'toolsig.ApplicationResources');
 
 -- Populates the lams_learning_transition table with various transitions for the dummy design 
 
@@ -830,14 +855,14 @@
 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)
+grouping_support_type_id, apply_grouping_flag,activity_category_id,language_file)
 values
 (31,2,'Survey Activity','Survey Title',10,20,null,'Help Text for Activity',
 1,null,0,1,
 2,6,'20050101',0,
 null,null,6,27,
 null,null,null,'/images/icon_survey.swf',
-1,0,1);
+1,0,1,'toolsig.ApplicationResources');
 
 insert into lams_tool_content (tool_content_id,tool_id) values(27,6);
 
