Index: lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20110228_updateTo236.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20110228_updateTo236.sql,v diff -u -r1.1.2.2 -r1.1.2.3 --- lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20110228_updateTo236.sql 11 Apr 2011 05:18:14 -0000 1.1.2.2 +++ lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20110228_updateTo236.sql 8 May 2011 10:55:13 -0000 1.1.2.3 @@ -12,13 +12,13 @@ uid BIGINT(20) NOT NULL AUTO_INCREMENT , rating float , user_id BIGINT(20) NOT NULL - , response_id BIGINT(20) NOT NULL + , message_id BIGINT(20) NOT NULL , PRIMARY KEY (uid) , INDEX (user_id) , CONSTRAINT FK_tl_lafrum11_message_rating_1 FOREIGN KEY (user_id) REFERENCES tl_lafrum11_forum_user (uid) , INDEX (response_id) - , CONSTRAINT FK_tl_lafrum11_message_rating_2 FOREIGN KEY (response_id) + , CONSTRAINT FK_tl_lafrum11_message_rating_2 FOREIGN KEY (message_id) REFERENCES tl_lafrum11_message (uid) )TYPE=InnoDB;