Index: lams_tool_nb/db/sql/insert_lams_tool_nb_data.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_nb/db/sql/Attic/insert_lams_tool_nb_data.sql,v diff -u -r1.4 -r1.5 --- lams_tool_nb/db/sql/insert_lams_tool_nb_data.sql 14 Jul 2005 02:26:50 -0000 1.4 +++ lams_tool_nb/db/sql/insert_lams_tool_nb_data.sql 15 Sep 2005 05:37:43 -0000 1.5 @@ -51,4 +51,44 @@ LAST_INSERT_ID(), 'test', 'test', - 'INCOMPLETE'); \ No newline at end of file + 'NOT_ATTEMPTED'); + +-- Data needed to run the examples on the noticeboard starter page + +INSERT INTO tl_lanb11_content ( uid, + nb_content_id, + title, + content, + online_instructions, + offline_instructions, + define_later, + force_offline, + content_in_use, + creator_user_id, + date_created, + date_updated) +VALUES (null, + '355', + 'Welcome', + 'Welcome to these activities', + 'Enter the online instructions here', + 'Enter the offline instructions here', + 0, + 0, + 0, + NULL, + now(), + NULL); + + INSERT INTO tl_lanb11_session ( uid, + nb_session_id, + nb_content_uid, + session_start_date, + session_end_date, + session_status) +VALUES (null, + '455', + LAST_INSERT_ID(), + now(), + now(), + 'NOT_ATTEMPTED'); \ No newline at end of file