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