Index: lams_tool_chat/db/sql/create_lams_tool_chat.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_chat/db/sql/create_lams_tool_chat.sql,v diff -u -r1.12 -r1.13 --- lams_tool_chat/db/sql/create_lams_tool_chat.sql 4 Sep 2006 02:17:42 -0000 1.12 +++ lams_tool_chat/db/sql/create_lams_tool_chat.sql 31 Oct 2006 04:16:34 -0000 1.13 @@ -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 =================================================================== RCS file: /usr/local/cvsroot/lams_tool_nb/db/sql/create_lams_tool_nb.sql,v diff -u -r1.17 -r1.18 --- lams_tool_nb/db/sql/create_lams_tool_nb.sql 19 Sep 2006 06:37:25 -0000 1.17 +++ lams_tool_nb/db/sql/create_lams_tool_nb.sql 31 Oct 2006 04:22:52 -0000 1.18 @@ -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 =================================================================== RCS file: /usr/local/cvsroot/lams_tool_notebook/db/sql/create_lams_tool_notebook.sql,v diff -u -r1.4 -r1.5 --- lams_tool_notebook/db/sql/create_lams_tool_notebook.sql 27 Jul 2006 06:06:45 -0000 1.4 +++ lams_tool_notebook/db/sql/create_lams_tool_notebook.sql 31 Oct 2006 04:19:36 -0000 1.5 @@ -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 =================================================================== RCS file: /usr/local/cvsroot/lams_tool_scribe/db/sql/create_lams_tool_scribe.sql,v diff -u -r1.8 -r1.9 --- lams_tool_scribe/db/sql/create_lams_tool_scribe.sql 24 Oct 2006 06:49:34 -0000 1.8 +++ lams_tool_scribe/db/sql/create_lams_tool_scribe.sql 31 Oct 2006 04:18:20 -0000 1.9 @@ -36,10 +36,10 @@ auto_select_scribe) VALUES( 1, - "LAMS Scribe", - "Scribe Instruction", - "Online instructions", - "Offline instructions", + "Scribe", + "Instructions", + "", + "", ${default_content_id}, 0, 1,