Index: lams_common/db/sql/insert_test_data.sql =================================================================== diff -u -r85b8cf34fb47be6c60cfec9fd59e65939b7938c3 -r6b6c1309ed5e0a188bce91147b685835220f7893 --- lams_common/db/sql/insert_test_data.sql (.../insert_test_data.sql) (revision 85b8cf34fb47be6c60cfec9fd59e65939b7938c3) +++ lams_common/db/sql/insert_test_data.sql (.../insert_test_data.sql) (revision 6b6c1309ed5e0a188bce91147b685835220f7893) @@ -140,278 +140,278 @@ -- 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, +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, +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) values -(1,1,'Notebook Template','Notebook',10,20,null, +(1,1,'Notebook Template','Notebook',10,20,null,'Help Text for Activity', 1,null,null,0, -null,1,'20050101','Offline Instructions ', +null,1,'20050101','Offline Instructions ',0, null,null,1,1, null,null,null,'NotebookImage'); -insert into lams_learning_activity (activity_id,activity_ui_id,description,title,xcoord,ycoord,parent_activity_id, +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, +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) values -(2,2,'NoticeBoard Template','NoticeBoard',10,20,null, +(2,2,'NoticeBoard Template','NoticeBoard',10,20,null,'Help Text for Activity', 1,null,null,0, -null,2,'20050101','Offline Instructions ', +null,2,'20050101','Offline Instructions ',0, null,null,2,2, null,null,null,'NoticeBoardImage'); -insert into lams_learning_activity (activity_id,activity_ui_id,description,title,xcoord,ycoord,parent_activity_id, +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, +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) values -(3,3,'Multiple Choice Template','Multiple Choice',10,20,null, +(3,3,'Multiple Choice Template','Multiple Choice',10,20,null,'Help Text for Activity', 1,null,null,0, -null,3,'20050101','Offline Instructions ', +null,3,'20050101','Offline Instructions ',0, null,null,3,3, null,null,null,'MultipleChoiceImage'); -insert into lams_learning_activity (activity_id,activity_ui_id,description,title,xcoord,ycoord,parent_activity_id, +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, +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) values -(4,4,'Question and Answer Template','Question and Answer',10,20,null, +(4,4,'Question and Answer Template','Question and Answer',10,20,null,'Help Text for Activity', 1,null,null,0, -null,4,'20050101','Offline Instructions ', +null,4,'20050101','Offline Instructions ',0, null,null,4,4, null,null,null,'QAImage'); -insert into lams_learning_activity (activity_id,activity_ui_id,description,title,xcoord,ycoord,parent_activity_id, +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, +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) values -(5,5,'MessageBoard Template','MessageBoard',10,20,null, +(5,5,'MessageBoard Template','MessageBoard',10,20,null,'Help Text for Activity', 1,null,null,0, -null,5,'20050101','Offline Instructions ', +null,5,'20050101','Offline Instructions ',0, null,null,5,5, null,null,null,'MBImage'); -insert into lams_learning_activity (activity_id,activity_ui_id,description,title,xcoord,ycoord,parent_activity_id, +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, +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) values -(6,6,'Survey Template','Survey',10,20,null, +(6,6,'Survey Template','Survey',10,20,null,'Help Text for Activity', 1,null,null,0, -null,6,'20050101','Offline Instructions ', +null,6,'20050101','Offline Instructions ',0, null,null,6,6, null,null,null,'SurveyImage'); -insert into lams_learning_activity (activity_id,activity_ui_id,description,title,xcoord,ycoord,parent_activity_id, +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, +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) values -(7,7,'Chat Template','Chat',10,20,null, +(7,7,'Chat Template','Chat',10,20,null,'Help Text for Activity', 1,null,null,0, -null,7,'20050101','Offline Instructions ', +null,7,'20050101','Offline Instructions ',0, null,null,7,7, null,null,null,'ChatImage'); -insert into lams_learning_activity (activity_id,activity_ui_id,description,title,xcoord,ycoord,parent_activity_id, +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, +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) values -(8,8,'Shared Resources Template','Shared Resources',10,20,null, +(8,8,'Shared Resources Template','Shared Resources',10,20,null,'Help Text for Activity', 1,null,null,0, -null,8,'20050101','Offline Instructions ', +null,8,'20050101','Offline Instructions ',0, null,null,8,8, null,null,null,'SRImage'); -insert into lams_learning_activity (activity_id,activity_ui_id,description,title,xcoord,ycoord,parent_activity_id, +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, +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) values -(9,9,'Voting Template','Voting',10,20,null, +(9,9,'Voting Template','Voting',10,20,null,'Help Text for Activity', 1,null,null,0, -null,9,'20050101','Offline Instructions ', +null,9,'20050101','Offline Instructions ',0, null,null,9,9, null,null,null,'VotingImage'); -insert into lams_learning_activity (activity_id,activity_ui_id,description,title,xcoord,ycoord,parent_activity_id, +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, +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) values -(10,10,'Submit Files Template','Submit Files',10,20,null, +(10,10,'Submit Files Template','Submit Files',10,20,null,'Help Text for Activity', 1,null,null,0, -null,10,'20050101','Offline Instructions ', +null,10,'20050101','Offline Instructions ',0, null,null,10,10, null,null,null,'SubmitFilesImage'); -insert into lams_learning_activity (activity_id,activity_ui_id,description,title,xcoord,ycoord,parent_activity_id, +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, +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) values -(11,11,'Instant Messaging Template','Instant Messaging',10,20,null, +(11,11,'Instant Messaging Template','Instant Messaging',10,20,null,'Help Text for Activity', 1,null,null,0, -null,11,'20050101','Offline Instructions ', +null,11,'20050101','Offline Instructions ',0, null,null,11,11, null,null,null,'IMImage'); insert into lams_learning_activity -(activity_id,activity_ui_id,description,title,xcoord,ycoord,parent_activity_id, +(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, +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) values -(12,12,'Optional Activity Description','Optional Activity Title',10,20,null, +(12,12,'Optional Activity Description','Optional Activity Title',10,20,null,'Help Text for Activity', 8,null,1,0, -1,null,'20050101','Offline Instructions ', +1,null,'20050101','Offline Instructions ',0, 5,3,null,null, null,'20050101','20050101','image'); insert into lams_learning_activity -(activity_id,activity_ui_id,description,title,xcoord,ycoord,parent_activity_id, +(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, +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) values -(13,13,'Parallel Activity Description','Parallel Activity Title',10,20,null, +(13,13,'Parallel Activity Description','Parallel Activity Title',10,20,null,'Help Text for Activity', 7,null,1,0, -1,null,'20050101','Parallel Activity Offline Instructions ', +1,null,'20050101','Parallel Activity Offline Instructions ',0, null,null,null,null, null,null,null,'image'); insert into lams_learning_activity -(activity_id,activity_ui_id,description,title,xcoord,ycoord,parent_activity_id, +(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, +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) values -(14,14,'Sequence Activity Description','Sequence Activity Title',10,20,null, +(14,14,'Sequence Activity Description','Sequence Activity Title',10,20,null,'Help Text for Activity', 9,null,1,0, -1,null,'20050101','Sequence Activity Offline Instructions ', +1,null,'20050101','Sequence Activity Offline Instructions ',0, null,null,null,null, null,null,null,'image'); insert into lams_learning_activity -(activity_id,activity_ui_id,description,title,xcoord,ycoord,parent_activity_id, +(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, +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) values -(15,1,'Notebook Activity Description','Notebook Activity Title',10,20,null, +(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 ', +1,1,'20050101','Notebook Activity Offline Instructions ',0, null,null,1,12, null,null,null,'image'); insert into lams_learning_activity -(activity_id,activity_ui_id,description,title,xcoord,ycoord,parent_activity_id, +(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, +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) values -(16,2,'NoticeBoard Activity','NoticeBoard Activity',10,20,12, +(16,2,'NoticeBoard Activity','NoticeBoard Activity',10,20,12,'Help Text for Activity', 1,null,0,0, -1,2,'20050101','NoticeBoard Activity Offline Instructions ', +1,2,'20050101','NoticeBoard Activity Offline Instructions ',0, null,null,2,13, null,null,null,'image'); insert into lams_learning_activity -(activity_id,activity_ui_id,description,title,xcoord,ycoord,parent_activity_id, +(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, +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) values -(17,3,'Multiple Choice Activity ','Multiple Choice',10,20,12, +(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 ', +1,3,'20050101','Tool Activity Offline Instructions ',0, null,null,3,14, null,null,null,'image'); insert into lams_learning_activity -(activity_id,activity_ui_id,description,title,xcoord,ycoord,parent_activity_id, +(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, +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) values -(18,4,'Question and Answer Activity','Question and Answer',10,20,13, +(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 ', +1,4,'20050101','Tool Activity Offline Instructions ',0, null,null,4,15, null,null,null,'image'); insert into lams_learning_activity -(activity_id,activity_ui_id,description,title,xcoord,ycoord,parent_activity_id, +(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, +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) values -(19,5,'Message Board Activity','Message Board',10,20,13, -1,100,1,0, -1,5,'20050101','Tool Activity Offline Instructions ', +(19,5,'Message Board Activity','Message Board',10,20,13,'Help Text for Activity', +1,null,1,0, +1,5,'20050101','Tool Activity Offline Instructions ',0, null,null,5,16, null,null,null,'image'); insert into lams_learning_activity -(activity_id,activity_ui_id,description,title,xcoord,ycoord,parent_activity_id, +(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, +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) values -(20,6,'Survey Activity','Survey Title',10,20,14, +(20,6,'Survey Activity','Survey Title',10,20,14,'Help Text for Activity', 1,null,0,0, -1,6,'20050101','Tool Activity Offline Instructions ', +1,6,'20050101','Tool Activity Offline Instructions ',0, null,null,6,17, null,null,null,'image'); insert into lams_learning_activity -(activity_id,activity_ui_id,description,title,xcoord,ycoord,parent_activity_id, +(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, +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) values -(21,7,'Chat Activity','Chat Title',10,20,14, +(21,7,'Chat Activity','Chat Title',10,20,14,'Help Text for Activity', 1,null,1,0, -1,7,'20050101','Tool Activity Offline Instructions ', +1,7,'20050101','Tool Activity Offline Instructions ',0, null,null,7,18, null,null,null,'image'); insert into lams_learning_activity -(activity_id,activity_ui_id,description,title,xcoord,ycoord,parent_activity_id, +(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, +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) values -(22,8,'Shared Resources Activity','Shared Resources',10,20,14, +(22,8,'Shared Resources Activity','Shared Resources',10,20,14,'Help Text for Activity', 1,null,2,0, -1,8,'20050101','Tool Activity Offline Instructions ', +1,8,'20050101','Tool Activity Offline Instructions ',0, null,null,8,19, null,null,null,'image'); @@ -452,8 +452,5 @@ parent_learning_design_id,workspace_folder_id) values (1,'Test Learning Design','Test Learning Design title',15,1,1,0,1, - 'Help Text',1,'20041223','1.0',null,1); - - - + 'Help Text',1,'20041223','1.0',null,1); SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file