Index: lams_tool_laqa/db/sql/create_lams_tool_qa.sql =================================================================== diff -u -r239cb45d5be82c508b6f13e33673bf8b87016619 -r9cacd7b6b6af51e9957ef4d4ef497a3c3b298633 --- lams_tool_laqa/db/sql/create_lams_tool_qa.sql (.../create_lams_tool_qa.sql) (revision 239cb45d5be82c508b6f13e33673bf8b87016619) +++ lams_tool_laqa/db/sql/create_lams_tool_qa.sql (.../create_lams_tool_qa.sql) (revision 9cacd7b6b6af51e9957ef4d4ef497a3c3b298633) @@ -86,7 +86,7 @@ )TYPE=InnoDB; -- data for content table -INSERT INTO tl_laqa11_content (qa_content_id, creation_date) VALUES (${default_content_id}, NOW()); +INSERT INTO tl_laqa11_content (qa_content_id, creation_date, questions_sequenced) VALUES (${default_content_id}, NOW(),1); -- data for content questions table -INSERT INTO tl_laqa11_que_content (question, display_order, qa_content_id) VALUES ('What is the capital of Russia?',1,${default_content_id}); \ No newline at end of file +INSERT INTO tl_laqa11_que_content (question, display_order, qa_content_id) VALUES ('What is the capital of Russia?',1,1); \ No newline at end of file Index: lams_tool_laqa/db/sql/insert_tool_qa_data.sql =================================================================== diff -u -re4fa840a72a71bfd8608fbb2ac359e59832bf881 -r9cacd7b6b6af51e9957ef4d4ef497a3c3b298633 --- lams_tool_laqa/db/sql/insert_tool_qa_data.sql (.../insert_tool_qa_data.sql) (revision e4fa840a72a71bfd8608fbb2ac359e59832bf881) +++ lams_tool_laqa/db/sql/insert_tool_qa_data.sql (.../insert_tool_qa_data.sql) (revision 9cacd7b6b6af51e9957ef4d4ef497a3c3b298633) @@ -1,20 +1,21 @@ - +SET FOREIGN_KEY_CHECKS=0; -- test data for content table -- test data for content table INSERT INTO tl_laqa11_content (qa_content_id, - creation_date + creation_date, + questions_sequenced ) VALUES (10, - NOW()); + NOW(),1); -- test data for content questions table -INSERT INTO tl_laqa11_que_content (qa_que_content_id, +INSERT INTO tl_laqa11_que_content (uid, question, display_order, - qa_content_id) VALUES (20,'What is the name of this activity?',1,10); + qa_content_id) VALUES (20,'What is the name of this activity?',1,1); +SET FOREIGN_KEY_CHECKS=1; -