Index: lams_tool_laqa/.classpath =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/.classpath,v diff -u -r1.3 -r1.4 --- lams_tool_laqa/.classpath 1 Jul 2005 04:53:49 -0000 1.3 +++ lams_tool_laqa/.classpath 22 Aug 2005 00:26:15 -0000 1.4 @@ -3,8 +3,8 @@ - + Index: lams_tool_laqa/build.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/build.xml,v diff -u -r1.9 -r1.10 --- lams_tool_laqa/build.xml 28 Jul 2005 03:50:11 -0000 1.9 +++ lams_tool_laqa/build.xml 22 Aug 2005 00:25:34 -0000 1.10 @@ -207,8 +207,8 @@ - - + + Index: lams_tool_laqa/db/sql/activity_insert.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/db/sql/activity_insert.sql,v diff -u -r1.2 -r1.3 --- lams_tool_laqa/db/sql/activity_insert.sql 21 Jun 2005 22:50:48 -0000 1.2 +++ lams_tool_laqa/db/sql/activity_insert.sql 22 Aug 2005 00:23:52 -0000 1.3 @@ -23,8 +23,6 @@ , learning_library_id , create_date_time , run_offline_flag -, offline_instructions -, online_instructions , max_number_of_options , min_number_of_options , options_instructions @@ -63,8 +61,6 @@ , ${learning_library_id} , NOW() , 0 -, 'Do it yourself' -, 'Do it in LAMS' , NULL , NULL , NULL 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.8 -r1.9 --- lams_tool_laqa/db/sql/create_lams_tool_qa.sql 20 Jul 2005 23:49:50 -0000 1.8 +++ lams_tool_laqa/db/sql/create_lams_tool_qa.sql 22 Aug 2005 00:23:52 -0000 1.9 @@ -1,4 +1,4 @@ -CREATE TABLE lams.tl_laqa11_content ( +CREATE TABLE tl_laqa11_content ( qa_content_id BIGINT(20) NOT NULL , title VARCHAR(250) NOT NULL DEFAULT 'Questions and Answers' , instructions VARCHAR(250) NOT NULL DEFAULT 'Please, take a minute to answer the following questions.' @@ -19,7 +19,7 @@ , PRIMARY KEY (qa_content_id) )TYPE=InnoDB; -CREATE TABLE lams.tl_laqa11_session ( +CREATE TABLE tl_laqa11_session ( qa_session_id BIGINT(20) NOT NULL , session_start_date DATETIME , session_end_date DATETIME @@ -31,7 +31,7 @@ REFERENCES lams.tl_laqa11_content (qa_content_id) )TYPE=InnoDB; -CREATE TABLE lams.tl_laqa11_que_usr ( +CREATE TABLE tl_laqa11_que_usr ( que_usr_id BIGINT(20) NOT NULL , username VARCHAR(100) , qa_session_id BIGINT(20) NOT NULL @@ -42,7 +42,7 @@ REFERENCES lams.tl_laqa11_session (qa_session_id) )TYPE=InnoDB; -CREATE TABLE lams.tl_laqa11_que_content ( +CREATE TABLE tl_laqa11_que_content ( qa_que_content_id BIGINT(20) NOT NULL , question VARCHAR(255) , display_order INT(5) @@ -53,7 +53,7 @@ REFERENCES lams.tl_laqa11_content (qa_content_id) )TYPE=InnoDB; -CREATE TABLE lams.tl_laqa11_usr_resp ( +CREATE TABLE tl_laqa11_usr_resp ( response_id BIGINT(20) NOT NULL , hidden TINYINT(1) DEFAULT 0 , answer VARCHAR(255) @@ -70,7 +70,7 @@ REFERENCES lams.tl_laqa11_que_usr (que_usr_id) )TYPE=InnoDB; -CREATE TABLE lams.tl_laqa11_uploadedFile ( +CREATE TABLE tl_laqa11_uploadedFile ( submissionId BIGINT(20) NOT NULL AUTO_INCREMENT , uuid VARCHAR(255) NOT NULL , isOnline_File TINYINT(1) NOT NULL 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.2 -r1.3 --- lams_tool_laqa/db/sql/drop_lams_tool_qa.sql 22 Jul 2005 00:42:07 -0000 1.2 +++ lams_tool_laqa/db/sql/drop_lams_tool_qa.sql 22 Aug 2005 00:23:52 -0000 1.3 @@ -1,7 +1,7 @@ -DROP TABLE IF EXISTS lams.tl_laqa11_usr_resp; -DROP TABLE IF EXISTS lams.tl_laqa11_que_usr; -DROP TABLE IF EXISTS lams.tl_laqa11_que_content; -DROP TABLE IF EXISTS lams.tl_laqa11_session; -DROP TABLE IF EXISTS lams.tl_laqa11_content; -DROP TABLE IF EXISTS lams.tl_laqa11_uploadedFile; +DROP TABLE IF EXISTS tl_laqa11_usr_resp; +DROP TABLE IF EXISTS tl_laqa11_que_usr; +DROP TABLE IF EXISTS tl_laqa11_que_content; +DROP TABLE IF EXISTS tl_laqa11_session; +DROP TABLE IF EXISTS tl_laqa11_uploadedFile; +DROP TABLE IF EXISTS tl_laqa11_content; 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.2 -r1.3 --- lams_tool_laqa/db/sql/tool_insert.sql 21 Jun 2005 22:50:48 -0000 1.2 +++ lams_tool_laqa/db/sql/tool_insert.sql 22 Aug 2005 00:23:52 -0000 1.3 @@ -8,6 +8,8 @@ service_name, tool_display_name, description, +tool_identifier, +tool_version, learning_library_id, default_tool_content_id, valid_flag, @@ -31,6 +33,8 @@ 'qaService', 'Question and Answer', 'Question and Answer Tool Description', +'qa', +'1.1', NULL, NULL, 0,