Index: lams_tool_laqa/conf/hibernate/mappings/QaUploadedFile.hbm.xml =================================================================== diff -u -r69f36134758d85e347893150aa05da3ba9479159 -rccffbc14f13eb5942c42fba71ac76dbe89acd957 --- lams_tool_laqa/conf/hibernate/mappings/QaUploadedFile.hbm.xml (.../QaUploadedFile.hbm.xml) (revision 69f36134758d85e347893150aa05da3ba9479159) +++ lams_tool_laqa/conf/hibernate/mappings/QaUploadedFile.hbm.xml (.../QaUploadedFile.hbm.xml) (revision ccffbc14f13eb5942c42fba71ac76dbe89acd957) @@ -7,7 +7,7 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Index: lams_tool_laqa/conf/hibernate/mappings/org/QaQueContent.hbm.xml =================================================================== diff -u --- lams_tool_laqa/conf/hibernate/mappings/org/QaQueContent.hbm.xml (revision 0) +++ lams_tool_laqa/conf/hibernate/mappings/org/QaQueContent.hbm.xml (revision ccffbc14f13eb5942c42fba71ac76dbe89acd957) @@ -0,0 +1,80 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Index: lams_tool_laqa/conf/hibernate/mappings/org/QaQueUsr.hbm.xml =================================================================== diff -u --- lams_tool_laqa/conf/hibernate/mappings/org/QaQueUsr.hbm.xml (revision 0) +++ lams_tool_laqa/conf/hibernate/mappings/org/QaQueUsr.hbm.xml (revision ccffbc14f13eb5942c42fba71ac76dbe89acd957) @@ -0,0 +1,86 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Index: lams_tool_laqa/conf/hibernate/mappings/org/QaSession.hbm.xml =================================================================== diff -u --- lams_tool_laqa/conf/hibernate/mappings/org/QaSession.hbm.xml (revision 0) +++ lams_tool_laqa/conf/hibernate/mappings/org/QaSession.hbm.xml (revision ccffbc14f13eb5942c42fba71ac76dbe89acd957) @@ -0,0 +1,86 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Index: lams_tool_laqa/conf/hibernate/mappings/org/QaUploadedFile.hbm.xml =================================================================== diff -u --- lams_tool_laqa/conf/hibernate/mappings/org/QaUploadedFile.hbm.xml (revision 0) +++ lams_tool_laqa/conf/hibernate/mappings/org/QaUploadedFile.hbm.xml (revision ccffbc14f13eb5942c42fba71ac76dbe89acd957) @@ -0,0 +1,71 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + Index: lams_tool_laqa/conf/hibernate/mappings/org/QaUsrResp.hbm.xml =================================================================== diff -u --- lams_tool_laqa/conf/hibernate/mappings/org/QaUsrResp.hbm.xml (revision 0) +++ lams_tool_laqa/conf/hibernate/mappings/org/QaUsrResp.hbm.xml (revision ccffbc14f13eb5942c42fba71ac76dbe89acd957) @@ -0,0 +1,105 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Index: lams_tool_laqa/db/model/lams_tool_qa.clay =================================================================== diff -u -r69f36134758d85e347893150aa05da3ba9479159 -rccffbc14f13eb5942c42fba71ac76dbe89acd957 --- lams_tool_laqa/db/model/lams_tool_qa.clay (.../lams_tool_qa.clay) (revision 69f36134758d85e347893150aa05da3ba9479159) +++ lams_tool_laqa/db/model/lams_tool_qa.clay (.../lams_tool_qa.clay) (revision ccffbc14f13eb5942c42fba71ac76dbe89acd957) @@ -259,8 +259,8 @@ - + @@ -272,8 +272,8 @@ - + @@ -493,7 +493,7 @@ - +
Index: lams_tool_laqa/db/sql/create_lams_tool_qa.sql =================================================================== diff -u -r69f36134758d85e347893150aa05da3ba9479159 -rccffbc14f13eb5942c42fba71ac76dbe89acd957 --- lams_tool_laqa/db/sql/create_lams_tool_qa.sql (.../create_lams_tool_qa.sql) (revision 69f36134758d85e347893150aa05da3ba9479159) +++ lams_tool_laqa/db/sql/create_lams_tool_qa.sql (.../create_lams_tool_qa.sql) (revision ccffbc14f13eb5942c42fba71ac76dbe89acd957) @@ -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 =================================================================== diff -u -re4fa840a72a71bfd8608fbb2ac359e59832bf881 -rccffbc14f13eb5942c42fba71ac76dbe89acd957 --- lams_tool_laqa/db/sql/drop_lams_tool_qa.sql (.../drop_lams_tool_qa.sql) (revision e4fa840a72a71bfd8608fbb2ac359e59832bf881) +++ lams_tool_laqa/db/sql/drop_lams_tool_qa.sql (.../drop_lams_tool_qa.sql) (revision ccffbc14f13eb5942c42fba71ac76dbe89acd957) @@ -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 ccffbc14f13eb5942c42fba71ac76dbe89acd957 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 ccffbc14f13eb5942c42fba71ac76dbe89acd957 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 =================================================================== diff -u -r2ed80d3b7bc85a25e8a2925a25a1dcddf673831e -rccffbc14f13eb5942c42fba71ac76dbe89acd957 --- lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/QaUploadedFile.hbm.xml (.../QaUploadedFile.hbm.xml) (revision 2ed80d3b7bc85a25e8a2925a25a1dcddf673831e) +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/QaUploadedFile.hbm.xml (.../QaUploadedFile.hbm.xml) (revision ccffbc14f13eb5942c42fba71ac76dbe89acd957) @@ -7,7 +7,7 @@