Index: lams_tool_chat/db/sql/create_lams_tool_chat.sql =================================================================== diff -u -r62c0d1eb5c28094e0719349e883324f592807cd4 -r34c66fb7023ee64ab44d876ae375236e69400fe9 --- lams_tool_chat/db/sql/create_lams_tool_chat.sql (.../create_lams_tool_chat.sql) (revision 62c0d1eb5c28094e0719349e883324f592807cd4) +++ lams_tool_chat/db/sql/create_lams_tool_chat.sql (.../create_lams_tool_chat.sql) (revision 34c66fb7023ee64ab44d876ae375236e69400fe9) @@ -1,6 +1,7 @@ -- CVS ID: $Id$ SET FOREIGN_KEY_CHECKS=0; + drop table if exists tl_lachat11_attachment; drop table if exists tl_lachat11_chat; drop table if exists tl_lachat11_message; @@ -18,7 +19,30 @@ alter table tl_lachat11_session add index FK96E446B1A3926E3 (chat_uid), add constraint FK96E446B1A3926E3 foreign key (chat_uid) references tl_lachat11_chat (uid); alter table tl_lachat11_user add index FK4EB82169C8469FC (chat_session_uid), add constraint FK4EB82169C8469FC foreign key (chat_session_uid) references tl_lachat11_session (uid); -INSERT INTO tl_lachat11_chat (title,instructions,online_instructions,offline_instructions,tool_content_id,run_offline,lock_on_finished,filtering_enabled, content_in_use,define_later, reflect_on_activity) -VALUES("LAMS Chat","Chat Instruction","Online instructions","Offline instructions",${default_content_id},0,0,0,0,0,0); +INSERT INTO tl_lachat11_chat ( + title, + instructions, + online_instructions, + offline_instructions, + tool_content_id, + run_offline, + lock_on_finished, + filtering_enabled, + content_in_use, + define_later, + reflect_on_activity) +VALUES( + "Chat", + "Instructions", + "", + "", + ${default_content_id}, + 0, + 0, + 0, + 0, + 0, + 0 +); SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Index: lams_tool_nb/db/sql/create_lams_tool_nb.sql =================================================================== diff -u -r4aae0391a4892385de3df761a655e0ab8b1c0183 -r34c66fb7023ee64ab44d876ae375236e69400fe9 --- lams_tool_nb/db/sql/create_lams_tool_nb.sql (.../create_lams_tool_nb.sql) (revision 4aae0391a4892385de3df761a655e0ab8b1c0183) +++ lams_tool_nb/db/sql/create_lams_tool_nb.sql (.../create_lams_tool_nb.sql) (revision 34c66fb7023ee64ab44d876ae375236e69400fe9) @@ -73,10 +73,10 @@ content_in_use, date_created) VALUES (${default_content_id}, - 'Welcome', - 'Welcome to these activities', - 'Enter the online instructions here', - 'Enter the offline instructions here', + 'Noticeboard', + 'Content', + '', + '', 0, 0, 0, Index: lams_tool_notebook/db/sql/create_lams_tool_notebook.sql =================================================================== diff -u -r1d4d39bc99bceeb2f3400228a83823b8cd67c6da -r34c66fb7023ee64ab44d876ae375236e69400fe9 --- lams_tool_notebook/db/sql/create_lams_tool_notebook.sql (.../create_lams_tool_notebook.sql) (revision 1d4d39bc99bceeb2f3400228a83823b8cd67c6da) +++ lams_tool_notebook/db/sql/create_lams_tool_notebook.sql (.../create_lams_tool_notebook.sql) (revision 34c66fb7023ee64ab44d876ae375236e69400fe9) @@ -13,7 +13,28 @@ alter table tl_lantbk11_session add index FKB7C198E2FC940906 (notebook_uid), add constraint FKB7C198E2FC940906 foreign key (notebook_uid) references tl_lantbk11_notebook (uid); alter table tl_lantbk11_user add index FKCB8A58FFA3B0FADF (notebook_session_uid), add constraint FKCB8A58FFA3B0FADF foreign key (notebook_session_uid) references tl_lantbk11_session (uid); -INSERT INTO tl_lantbk11_notebook (title,instructions,online_instructions,offline_instructions,tool_content_id,run_offline,lock_on_finished,content_in_use,define_later, allow_rich_editor) -VALUES("LAMS Notebook","Notebook Instruction","Online instructions","Offline instructions",${default_content_id},0,0,0,0,0); +INSERT INTO tl_lantbk11_notebook ( + title, + instructions, + online_instructions, + offline_instructions, + tool_content_id, + run_offline, + lock_on_finished, + content_in_use, + define_later, + allow_rich_editor) +VALUES( + "Notebook", + "Instructions", + "", + "", + ${default_content_id}, + 0, + 0, + 0, + 0, + 0 +); SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Index: lams_tool_scribe/db/sql/create_lams_tool_scribe.sql =================================================================== diff -u -rc4e396e4c1ef24c04d7f25d8c2a8be2b62e35d53 -r34c66fb7023ee64ab44d876ae375236e69400fe9 --- lams_tool_scribe/db/sql/create_lams_tool_scribe.sql (.../create_lams_tool_scribe.sql) (revision c4e396e4c1ef24c04d7f25d8c2a8be2b62e35d53) +++ lams_tool_scribe/db/sql/create_lams_tool_scribe.sql (.../create_lams_tool_scribe.sql) (revision 34c66fb7023ee64ab44d876ae375236e69400fe9) @@ -36,10 +36,10 @@ auto_select_scribe) VALUES( 1, - "LAMS Scribe", - "Scribe Instruction", - "Online instructions", - "Offline instructions", + "Scribe", + "Instructions", + "", + "", ${default_content_id}, 0, 1,