Index: lams_tool_laqa/db/sql/create_lams_tool_qa.sql =================================================================== diff -u -r3c0157a30f00131b7c63609a87f3042230f8942a -r239cb45d5be82c508b6f13e33673bf8b87016619 --- lams_tool_laqa/db/sql/create_lams_tool_qa.sql (.../create_lams_tool_qa.sql) (revision 3c0157a30f00131b7c63609a87f3042230f8942a) +++ lams_tool_laqa/db/sql/create_lams_tool_qa.sql (.../create_lams_tool_qa.sql) (revision 239cb45d5be82c508b6f13e33673bf8b87016619) @@ -1,4 +1,4 @@ -CREATE TABLE lams.tl_laqa11_content ( +CREATE TABLE tl_laqa11_content ( uid BIGINT(20) NOT NULL AUTO_INCREMENT , qa_content_id BIGINT(20) NOT NULL , title VARCHAR(250) NOT NULL DEFAULT 'Questions and Answers' @@ -20,7 +20,7 @@ , PRIMARY KEY (uid) )TYPE=InnoDB; -CREATE TABLE lams.tl_laqa11_session ( +CREATE TABLE tl_laqa11_session ( uid BIGINT(20) NOT NULL AUTO_INCREMENT , qa_session_id BIGINT(20) NOT NULL , session_start_date DATETIME @@ -30,10 +30,10 @@ , PRIMARY KEY (uid) , INDEX (qa_content_id) , CONSTRAINT FK_tl_laqa11_session_1 FOREIGN KEY (qa_content_id) - REFERENCES lams.tl_laqa11_content (uid) + REFERENCES tl_laqa11_content (uid) )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) @@ -42,21 +42,21 @@ , PRIMARY KEY (uid) , INDEX (qa_session_id) , CONSTRAINT FK_tl_laqa11_que_usr_1 FOREIGN KEY (qa_session_id) - REFERENCES lams.tl_laqa11_session (uid) + REFERENCES tl_laqa11_session (uid) )TYPE=InnoDB; -CREATE TABLE lams.tl_laqa11_que_content ( +CREATE TABLE tl_laqa11_que_content ( uid BIGINT(20) NOT NULL AUTO_INCREMENT , question VARCHAR(255) , display_order INT(5) , qa_content_id BIGINT(20) NOT NULL , PRIMARY KEY (uid) , INDEX (qa_content_id) , CONSTRAINT FK_tl_laqa11_que_content_1 FOREIGN KEY (qa_content_id) - REFERENCES lams.tl_laqa11_content (uid) + REFERENCES tl_laqa11_content (uid) )TYPE=InnoDB; -CREATE TABLE lams.tl_laqa11_usr_resp ( +CREATE TABLE tl_laqa11_usr_resp ( response_id BIGINT(20) NOT NULL AUTO_INCREMENT , hidden TINYINT(1) DEFAULT 0 , answer VARCHAR(255) @@ -67,13 +67,13 @@ , PRIMARY KEY (response_id) , INDEX (que_usr_id) , CONSTRAINT FK_tl_laqa11_usr_resp_3 FOREIGN KEY (que_usr_id) - REFERENCES lams.tl_laqa11_que_usr (uid) + REFERENCES tl_laqa11_que_usr (uid) , INDEX (qa_que_content_id) , CONSTRAINT FK_tl_laqa11_usr_resp_2 FOREIGN KEY (qa_que_content_id) - REFERENCES lams.tl_laqa11_que_content (uid) + REFERENCES tl_laqa11_que_content (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 @@ -82,7 +82,7 @@ , PRIMARY KEY (submissionId) , INDEX (qa_content_id) , CONSTRAINT FK_tl_laqa11_uploadedfile_1 FOREIGN KEY (qa_content_id) - REFERENCES lams.tl_laqa11_content (uid) + REFERENCES tl_laqa11_content (uid) )TYPE=InnoDB; -- data for content table