Index: lams_tool_laqa/db/model/lams_tool_qa.clay =================================================================== diff -u -rdb35a7570ddebdb6d078ffee52c09234941f5f9a -r7e9ec88b3ebb98e346843941ecfb09f57a244a10 --- lams_tool_laqa/db/model/lams_tool_qa.clay (.../lams_tool_qa.clay) (revision db35a7570ddebdb6d078ffee52c09234941f5f9a) +++ lams_tool_laqa/db/model/lams_tool_qa.clay (.../lams_tool_qa.clay) (revision 7e9ec88b3ebb98e346843941ecfb09f57a244a10) @@ -150,8 +150,8 @@ - + @@ -394,7 +394,7 @@ - + @@ -415,11 +415,17 @@ - + + + + + + + - + Index: lams_tool_laqa/db/sql/create_lams_tool_qa.sql =================================================================== diff -u -rdb35a7570ddebdb6d078ffee52c09234941f5f9a -r7e9ec88b3ebb98e346843941ecfb09f57a244a10 --- lams_tool_laqa/db/sql/create_lams_tool_qa.sql (.../create_lams_tool_qa.sql) (revision db35a7570ddebdb6d078ffee52c09234941f5f9a) +++ lams_tool_laqa/db/sql/create_lams_tool_qa.sql (.../create_lams_tool_qa.sql) (revision 7e9ec88b3ebb98e346843941ecfb09f57a244a10) @@ -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 =================================================================== diff -u -rb6ad397fa2c77005e983bcd721381fe2afa30a10 -r7e9ec88b3ebb98e346843941ecfb09f57a244a10 --- lams_tool_laqa/db/sql/drop_lams_tool_qa.sql (.../drop_lams_tool_qa.sql) (revision b6ad397fa2c77005e983bcd721381fe2afa30a10) +++ lams_tool_laqa/db/sql/drop_lams_tool_qa.sql (.../drop_lams_tool_qa.sql) (revision 7e9ec88b3ebb98e346843941ecfb09f57a244a10) @@ -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 =================================================================== diff -u -r48cbfb560fbb7e9865f8f21b2787f1dba32d7a6f -r7e9ec88b3ebb98e346843941ecfb09f57a244a10 --- lams_tool_laqa/db/sql/insert_tool_qa_data.sql (.../insert_tool_qa_data.sql) (revision 48cbfb560fbb7e9865f8f21b2787f1dba32d7a6f) +++ lams_tool_laqa/db/sql/insert_tool_qa_data.sql (.../insert_tool_qa_data.sql) (revision 7e9ec88b3ebb98e346843941ecfb09f57a244a10) @@ -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 =================================================================== diff -u -r7ccf5d3c25b72c66f23cad4ff1da528cff36d875 -r7e9ec88b3ebb98e346843941ecfb09f57a244a10 --- lams_tool_laqa/db/sql/library_insert.sql (.../library_insert.sql) (revision 7ccf5d3c25b72c66f23cad4ff1da528cff36d875) +++ lams_tool_laqa/db/sql/library_insert.sql (.../library_insert.sql) (revision 7e9ec88b3ebb98e346843941ecfb09f57a244a10) @@ -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 =================================================================== diff -u -r29061495077c3902e109677c6e7c0bb15723b544 -r7e9ec88b3ebb98e346843941ecfb09f57a244a10 --- lams_tool_laqa/db/sql/tool_insert.sql (.../tool_insert.sql) (revision 29061495077c3902e109677c6e7c0bb15723b544) +++ lams_tool_laqa/db/sql/tool_insert.sql (.../tool_insert.sql) (revision 7e9ec88b3ebb98e346843941ecfb09f57a244a10) @@ -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