Index: lams_common/db/sql/insert_test_data.sql =================================================================== RCS file: /usr/local/cvsroot/lams_common/db/sql/Attic/insert_test_data.sql,v diff -u -r1.31 -r1.32 --- lams_common/db/sql/insert_test_data.sql 10 Mar 2005 06:15:34 -0000 1.31 +++ lams_common/db/sql/insert_test_data.sql 13 Mar 2005 22:38:56 -0000 1.32 @@ -1,7 +1,3 @@ -# Connection: ROOT LOCAL -# Host: localhost -# Saved: 2005-03-10 17:19:17 -# SET FOREIGN_KEY_CHECKS=0; INSERT INTO lams_organisation VALUES (1, 'Root', 'Root Organisation',null,1,NOW(),null); @@ -38,7 +34,14 @@ -insert into lams_workspace_folder (parent_folder_id,name,workspace_id) values(null,'Trial',1); +insert into lams_workspace_folder +(parent_folder_id,name,workspace_id, +user_id,create_date_time,last_modified_date_time, +lams_workspace_folder_type_id) + values +(null,'Test Workspace',1, +1,'20042312','20042312', +1); -- Populates the lams_learning_library table with default libraries @@ -58,59 +61,59 @@ -- 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) +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'); +'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,supports_grouping_flag,supports_define_later_flag, -learner_url,author_url,define_later_url,export_portfolio_url,monitor_url) +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'); +'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,supports_grouping_flag,supports_define_later_flag, -learner_url,author_url,define_later_url,export_portfolio_url,monitor_url) +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'); +'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,supports_grouping_flag,supports_define_later_flag, -learner_url,author_url,define_later_url,export_portfolio_url,monitor_url) +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'); +'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,supports_grouping_flag,supports_define_later_flag, -learner_url,author_url,define_later_url,export_portfolio_url,monitor_url) +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'); +'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,supports_grouping_flag,supports_define_later_flag, -learner_url,author_url,define_later_url,export_portfolio_url,monitor_url) +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, -'learner_url','author_url','define_later_url','export_portfolio_url','monitor_url'); +'learner_url','author_url','define_later_url','export_portfolio_url','monitor_url',1,6); 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) +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'); +'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,supports_grouping_flag,supports_define_later_flag, -learner_url,author_url,define_later_url,export_portfolio_url,monitor_url) +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'); +'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,supports_grouping_flag,supports_define_later_flag, -learner_url,author_url,define_later_url,export_portfolio_url,monitor_url) +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'); +'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,supports_grouping_flag,supports_define_later_flag, -learner_url,author_url,define_later_url,export_portfolio_url,monitor_url) +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'); +'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,supports_grouping_flag,supports_define_later_flag, -learner_url,author_url,define_later_url,export_portfolio_url,monitor_url) +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'); +'learner_url','author_url','define_later_url','export_portfolio_url','monitor_url',1,11); -- Populates the lams_tool_content table with dummy default content for all above tools @@ -164,7 +167,7 @@ values (1,1,'Notebook Template','Notebook',10,20,null,'Help Text for Activity', 1,null,0,0, -null,1,'20050101','Offline Instructions ',0, +null,1,'20050101','Offline Instructions ',0, null,null,1,1, null,null,null,'NotebookImage');