Index: lams_tool_laqa/db/model/lams_tool_qa.clay =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/db/model/lams_tool_qa.clay,v diff -u -r1.21 -r1.22 --- lams_tool_laqa/db/model/lams_tool_qa.clay 31 Aug 2006 08:40:23 -0000 1.21 +++ lams_tool_laqa/db/model/lams_tool_qa.clay 20 Sep 2006 15:01:56 -0000 1.22 @@ -150,8 +150,8 @@ - + @@ -394,7 +394,7 @@ - + @@ -415,11 +415,17 @@ - + + + + + + + - + 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.40 -r1.41 --- lams_tool_laqa/db/sql/create_lams_tool_qa.sql 31 Aug 2006 08:40:23 -0000 1.40 +++ lams_tool_laqa/db/sql/create_lams_tool_qa.sql 20 Sep 2006 15:01:56 -0000 1.41 @@ -1,3 +1,25 @@ +-- Copyright (C) 2005 LAMS Foundation (http://lamsfoundation.org) +-- ============================================================= +-- License Information: http://lamsfoundation.org/licensing/lams/2.0/ +-- +-- This program is free software; you can redistribute it and/or modify +-- it under the terms of the GNU General Public License version 2.0 as +-- published by the Free Software Foundation. +-- +-- This program is distributed in the hope that it will be useful, +-- but WITHOUT ANY WARRANTY; without even the implied warranty of +-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +-- GNU General Public License for more details. +-- +-- You should have received a copy of the GNU General Public License +-- along with this program; if not, write to the Free Software +-- Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301-- USA +-- +-- http://www.gnu.org/licenses/gpl.txt +-- **************************************************************** +-- +-- $Id$ + CREATE TABLE tl_laqa11_content ( uid BIGINT(20) NOT NULL AUTO_INCREMENT , qa_content_id BIGINT(20) NOT NULL @@ -52,7 +74,8 @@ CREATE TABLE tl_laqa11_que_content ( uid BIGINT(20) NOT NULL AUTO_INCREMENT , question TEXT - , display_order INT(5) + , feedback TEXT + , display_order INT(5) DEFAULT 1 , qa_content_id BIGINT(20) NOT NULL , PRIMARY KEY (uid) , INDEX (qa_content_id) @@ -97,3 +120,5 @@ INSERT INTO tl_laqa11_que_content (question, display_order, qa_content_id) VALUES ('Sample Question 1?',1,1); + + Index: lams_tool_laqa/db/sql/drop_lams_tool_qa.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/db/sql/drop_lams_tool_qa.sql,v diff -u -r1.12 -r1.13 --- lams_tool_laqa/db/sql/drop_lams_tool_qa.sql 4 Apr 2006 01:45:44 -0000 1.12 +++ lams_tool_laqa/db/sql/drop_lams_tool_qa.sql 20 Sep 2006 15:01:56 -0000 1.13 @@ -1,3 +1,24 @@ +-- Copyright (C) 2005 LAMS Foundation (http://lamsfoundation.org) +-- ============================================================= +-- License Information: http://lamsfoundation.org/licensing/lams/2.0/ +-- +-- This program is free software; you can redistribute it and/or modify +-- it under the terms of the GNU General Public License version 2.0 as +-- published by the Free Software Foundation. +-- +-- This program is distributed in the hope that it will be useful, +-- but WITHOUT ANY WARRANTY; without even the implied warranty of +-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +-- GNU General Public License for more details. +-- +-- You should have received a copy of the GNU General Public License +-- along with this program; if not, write to the Free Software +-- Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301-- USA +-- +-- http://www.gnu.org/licenses/gpl.txt +-- **************************************************************** +-- + -- $Id$ SET FOREIGN_KEY_CHECKS=0; 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.11 -r1.12 --- lams_tool_laqa/db/sql/insert_tool_qa_data.sql 2 Apr 2006 20:30:22 -0000 1.11 +++ lams_tool_laqa/db/sql/insert_tool_qa_data.sql 20 Sep 2006 15:01:56 -0000 1.12 @@ -1,5 +1,26 @@ +-- Copyright (C) 2005 LAMS Foundation (http://lamsfoundation.org) +-- ============================================================= +-- License Information: http://lamsfoundation.org/licensing/lams/2.0/ +-- +-- This program is free software; you can redistribute it and/or modify +-- it under the terms of the GNU General Public License version 2.0 as +-- published by the Free Software Foundation. +-- +-- This program is distributed in the hope that it will be useful, +-- but WITHOUT ANY WARRANTY; without even the implied warranty of +-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +-- GNU General Public License for more details. +-- +-- You should have received a copy of the GNU General Public License +-- along with this program; if not, write to the Free Software +-- Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301-- USA +-- +-- http://www.gnu.org/licenses/gpl.txt +-- **************************************************************** +-- + -- $Id$ -- test data for content table --- test data for content table + Index: lams_tool_laqa/db/sql/library_insert.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/db/sql/library_insert.sql,v diff -u -r1.6 -r1.7 --- lams_tool_laqa/db/sql/library_insert.sql 21 Mar 2006 06:26:10 -0000 1.6 +++ lams_tool_laqa/db/sql/library_insert.sql 20 Sep 2006 15:01:56 -0000 1.7 @@ -1,3 +1,24 @@ +-- Copyright (C) 2005 LAMS Foundation (http://lamsfoundation.org) +-- ============================================================= +-- License Information: http://lamsfoundation.org/licensing/lams/2.0/ +-- +-- This program is free software; you can redistribute it and/or modify +-- it under the terms of the GNU General Public License version 2.0 as +-- published by the Free Software Foundation. +-- +-- This program is distributed in the hope that it will be useful, +-- but WITHOUT ANY WARRANTY; without even the implied warranty of +-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +-- GNU General Public License for more details. +-- +-- You should have received a copy of the GNU General Public License +-- along with this program; if not, write to the Free Software +-- Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301-- USA +-- +-- http://www.gnu.org/licenses/gpl.txt +-- **************************************************************** +-- + -- $Id$ INSERT INTO lams_learning_library Index: lams_tool_laqa/db/sql/tool_insert.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/db/sql/tool_insert.sql,v diff -u -r1.20 -r1.21 --- lams_tool_laqa/db/sql/tool_insert.sql 8 Sep 2006 05:12:17 -0000 1.20 +++ lams_tool_laqa/db/sql/tool_insert.sql 20 Sep 2006 15:01:56 -0000 1.21 @@ -1,3 +1,24 @@ +-- Copyright (C) 2005 LAMS Foundation (http://lamsfoundation.org) +-- ============================================================= +-- License Information: http://lamsfoundation.org/licensing/lams/2.0/ +-- +-- This program is free software; you can redistribute it and/or modify +-- it under the terms of the GNU General Public License version 2.0 as +-- published by the Free Software Foundation. +-- +-- This program is distributed in the hope that it will be useful, +-- but WITHOUT ANY WARRANTY; without even the implied warranty of +-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +-- GNU General Public License for more details. +-- +-- You should have received a copy of the GNU General Public License +-- along with this program; if not, write to the Free Software +-- Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301-- USA +-- +-- http://www.gnu.org/licenses/gpl.txt +-- **************************************************************** +-- + -- $Id$ INSERT INTO lams_tool