Index: lams_tool_laqa/conf/hibernate/mappings/QaUploadedFile.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/conf/hibernate/mappings/Attic/QaUploadedFile.hbm.xml,v diff -u -r1.6 -r1.7 --- lams_tool_laqa/conf/hibernate/mappings/QaUploadedFile.hbm.xml 9 Feb 2006 20:02:08 -0000 1.6 +++ lams_tool_laqa/conf/hibernate/mappings/QaUploadedFile.hbm.xml 14 Feb 2006 16:37:37 -0000 1.7 @@ -7,7 +7,7 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Index: lams_tool_laqa/conf/hibernate/mappings/org/QaQueContent.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/conf/hibernate/mappings/org/Attic/QaQueContent.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/conf/hibernate/mappings/org/QaQueContent.hbm.xml 14 Feb 2006 16:37:37 -0000 1.1 @@ -0,0 +1,80 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Index: lams_tool_laqa/conf/hibernate/mappings/org/QaQueUsr.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/conf/hibernate/mappings/org/Attic/QaQueUsr.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/conf/hibernate/mappings/org/QaQueUsr.hbm.xml 14 Feb 2006 16:37:37 -0000 1.1 @@ -0,0 +1,86 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Index: lams_tool_laqa/conf/hibernate/mappings/org/QaSession.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/conf/hibernate/mappings/org/Attic/QaSession.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/conf/hibernate/mappings/org/QaSession.hbm.xml 14 Feb 2006 16:37:37 -0000 1.1 @@ -0,0 +1,86 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Index: lams_tool_laqa/conf/hibernate/mappings/org/QaUploadedFile.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/conf/hibernate/mappings/org/Attic/QaUploadedFile.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/conf/hibernate/mappings/org/QaUploadedFile.hbm.xml 14 Feb 2006 16:37:37 -0000 1.1 @@ -0,0 +1,71 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + Index: lams_tool_laqa/conf/hibernate/mappings/org/QaUsrResp.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/conf/hibernate/mappings/org/Attic/QaUsrResp.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/conf/hibernate/mappings/org/QaUsrResp.hbm.xml 14 Feb 2006 16:37:37 -0000 1.1 @@ -0,0 +1,105 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 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.8 -r1.9 --- lams_tool_laqa/db/model/lams_tool_qa.clay 9 Feb 2006 20:02:07 -0000 1.8 +++ lams_tool_laqa/db/model/lams_tool_qa.clay 14 Feb 2006 16:37:37 -0000 1.9 @@ -259,8 +259,8 @@ - + @@ -272,8 +272,8 @@ - + @@ -493,7 +493,7 @@ - +
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.16 -r1.17 --- lams_tool_laqa/db/sql/create_lams_tool_qa.sql 9 Feb 2006 20:02:08 -0000 1.16 +++ lams_tool_laqa/db/sql/create_lams_tool_qa.sql 14 Feb 2006 16:37:36 -0000 1.17 @@ -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 ( uid BIGINT(20) NOT NULL AUTO_INCREMENT , que_usr_id BIGINT(20) NOT NULL , username VARCHAR(100) @@ -43,7 +43,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) @@ -54,7 +54,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) @@ -71,7 +71,7 @@ REFERENCES lams.tl_laqa11_que_usr (uid) )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.5 -r1.6 --- lams_tool_laqa/db/sql/drop_lams_tool_qa.sql 6 Dec 2005 00:31:47 -0000 1.5 +++ lams_tool_laqa/db/sql/drop_lams_tool_qa.sql 14 Feb 2006 16:37:36 -0000 1.6 @@ -1,7 +1,9 @@ - +USE LAMS; +SET FOREIGN_KEY_CHECKS=0; 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; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Fisheye: Tag 1.4 refers to a dead (removed) revision in file `lams_tool_laqa/db/sql/tl_laqa11_uploadedFile.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 1.4 refers to a dead (removed) revision in file `lams_tool_laqa/db/sql/tl_laqa11_uploadedFiles.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/QaUploadedFile.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/Attic/QaUploadedFile.hbm.xml,v diff -u -r1.4 -r1.5 --- lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/QaUploadedFile.hbm.xml 29 Nov 2005 05:41:23 -0000 1.4 +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/QaUploadedFile.hbm.xml 14 Feb 2006 16:37:37 -0000 1.5 @@ -7,7 +7,7 @@