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.22 -r1.23 --- lams_tool_laqa/db/sql/create_lams_tool_qa.sql 16 Feb 2006 04:19:28 -0000 1.22 +++ lams_tool_laqa/db/sql/create_lams_tool_qa.sql 19 Feb 2006 14:10:20 -0000 1.23 @@ -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 =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/db/sql/Attic/insert_tool_qa_data.sql,v diff -u -r1.5 -r1.6 --- lams_tool_laqa/db/sql/insert_tool_qa_data.sql 16 Feb 2006 04:19:28 -0000 1.5 +++ lams_tool_laqa/db/sql/insert_tool_qa_data.sql 19 Feb 2006 14:10:20 -0000 1.6 @@ -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; +