Index: lams_tool_nb/db/sql/insert_lams_tool_nb_data.sql =================================================================== diff -u -ra02e171c220ed0f514811bc3cc610fbcd14063da -racd5c06f37206bdfa7505c8ce0786ba3e079be78 --- lams_tool_nb/db/sql/insert_lams_tool_nb_data.sql (.../insert_lams_tool_nb_data.sql) (revision a02e171c220ed0f514811bc3cc610fbcd14063da) +++ lams_tool_nb/db/sql/insert_lams_tool_nb_data.sql (.../insert_lams_tool_nb_data.sql) (revision acd5c06f37206bdfa7505c8ce0786ba3e079be78) @@ -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