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.9 -r1.10 --- lams_tool_laqa/db/sql/create_lams_tool_qa.sql 22 Aug 2005 00:23:52 -0000 1.9 +++ lams_tool_laqa/db/sql/create_lams_tool_qa.sql 31 Oct 2005 04:30:31 -0000 1.10 @@ -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 =================================================================== RCS file: /usr/local/cvsroot/lams_tool_nb/db/sql/create_lams_tool_nb.sql,v diff -u -r1.10 -r1.11 --- lams_tool_nb/db/sql/create_lams_tool_nb.sql 26 Aug 2005 02:49:21 -0000 1.10 +++ lams_tool_nb/db/sql/create_lams_tool_nb.sql 31 Oct 2005 04:30:30 -0000 1.11 @@ -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