Index: lams_tool_laqa/db/sql/create_lams_tool_qa.sql =================================================================== diff -u -r63a14a82c79d87539f49f17e2b57e930d8e70bb0 -r339224163d7ed472c4fa6c30fe92445aa0715cbe --- lams_tool_laqa/db/sql/create_lams_tool_qa.sql (.../create_lams_tool_qa.sql) (revision 63a14a82c79d87539f49f17e2b57e930d8e70bb0) +++ lams_tool_laqa/db/sql/create_lams_tool_qa.sql (.../create_lams_tool_qa.sql) (revision 339224163d7ed472c4fa6c30fe92445aa0715cbe) @@ -28,7 +28,7 @@ , PRIMARY KEY (qa_session_id) , INDEX (qa_content_id) , CONSTRAINT FK_tl_laqa11_session_1 FOREIGN KEY (qa_content_id) - REFERENCES lams.tl_laqa11_content (qa_content_id) + REFERENCES tl_laqa11_content (qa_content_id) )TYPE=InnoDB; CREATE TABLE tl_laqa11_que_usr ( @@ -39,7 +39,7 @@ , PRIMARY KEY (que_usr_id) , INDEX (qa_session_id) , CONSTRAINT FK_tl_laqa11_que_usr_2 FOREIGN KEY (qa_session_id) - REFERENCES lams.tl_laqa11_session (qa_session_id) + REFERENCES tl_laqa11_session (qa_session_id) )TYPE=InnoDB; CREATE TABLE tl_laqa11_que_content ( @@ -50,7 +50,7 @@ , PRIMARY KEY (qa_que_content_id) , INDEX (qa_content_id) , CONSTRAINT FK_tl_laqa11_que_content_1 FOREIGN KEY (qa_content_id) - REFERENCES lams.tl_laqa11_content (qa_content_id) + REFERENCES tl_laqa11_content (qa_content_id) )TYPE=InnoDB; CREATE TABLE tl_laqa11_usr_resp ( @@ -64,10 +64,10 @@ , PRIMARY KEY (response_id) , INDEX (qa_que_content_id) , CONSTRAINT FK_tl_laqa11_usr_resp_2 FOREIGN KEY (qa_que_content_id) - REFERENCES lams.tl_laqa11_que_content (qa_que_content_id) + REFERENCES tl_laqa11_que_content (qa_que_content_id) , INDEX (que_usr_id) , CONSTRAINT FK_tl_laqa11_usr_resp_3 FOREIGN KEY (que_usr_id) - REFERENCES lams.tl_laqa11_que_usr (que_usr_id) + REFERENCES tl_laqa11_que_usr (que_usr_id) )TYPE=InnoDB; CREATE TABLE tl_laqa11_uploadedFile ( @@ -79,7 +79,7 @@ , PRIMARY KEY (submissionId) , INDEX (qa_content_id) , CONSTRAINT FK_tl_laqa11_que_content_1_1 FOREIGN KEY (qa_content_id) - REFERENCES lams.tl_laqa11_content (qa_content_id) + REFERENCES tl_laqa11_content (qa_content_id) )TYPE=InnoDB; Index: lams_tool_nb/db/sql/create_lams_tool_nb.sql =================================================================== diff -u -r1ed92d529de656ca2944d772c590207736157018 -r339224163d7ed472c4fa6c30fe92445aa0715cbe --- lams_tool_nb/db/sql/create_lams_tool_nb.sql (.../create_lams_tool_nb.sql) (revision 1ed92d529de656ca2944d772c590207736157018) +++ lams_tool_nb/db/sql/create_lams_tool_nb.sql (.../create_lams_tool_nb.sql) (revision 339224163d7ed472c4fa6c30fe92445aa0715cbe) @@ -24,7 +24,7 @@ , PRIMARY KEY (uid) , INDEX (nb_content_uid) , CONSTRAINT FK_tl_lanb11_session_1 FOREIGN KEY (nb_content_uid) - REFERENCES lams.tl_lanb11_content (uid) + REFERENCES tl_lanb11_content (uid) )TYPE=InnoDB; CREATE TABLE tl_lanb11_user ( @@ -37,7 +37,7 @@ , PRIMARY KEY (uid) , INDEX (nb_session_uid) , CONSTRAINT FK_tl_lanb11_user_1 FOREIGN KEY (nb_session_uid) - REFERENCES lams.tl_lanb11_session (uid) + REFERENCES tl_lanb11_session (uid) )TYPE=InnoDB; @@ -51,7 +51,7 @@ , PRIMARY KEY (attachment_id) , INDEX (nb_content_uid) , CONSTRAINT FK_tl_lanb11_attachment_1 FOREIGN KEY (nb_content_uid) - REFERENCES lams.tl_lanb11_content (uid) + REFERENCES tl_lanb11_content (uid) )TYPE=InnoDB; -- Default Content For Noticeboard Tool