Index: lams_tool_laqa/db/sql/create_lams_tool_qa.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/db/sql/create_lams_tool_qa.sql,v diff -u -r1.21 -r1.22 --- lams_tool_laqa/db/sql/create_lams_tool_qa.sql 15 Feb 2006 14:20:47 -0000 1.21 +++ lams_tool_laqa/db/sql/create_lams_tool_qa.sql 16 Feb 2006 04:19:28 -0000 1.22 @@ -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 =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/db/sql/Attic/insert_tool_qa_data.sql,v diff -u -r1.4 -r1.5 --- lams_tool_laqa/db/sql/insert_tool_qa_data.sql 6 Dec 2005 00:31:47 -0000 1.4 +++ lams_tool_laqa/db/sql/insert_tool_qa_data.sql 16 Feb 2006 04:19:28 -0000 1.5 @@ -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; -