Code:
ALTER TABLE `users votes`,
ADD UNIQUE `voting key` ( `userid` , `forumtopicid` , `replyid` )
http://i.imgur.com/PUzJY.png
Shouldn't the above prevent duplicate entries of userid, forumtopicid and replyid together?!?
If I seperate "voting key" into two uniques: userid & forumtopicd; userid & replyid. Then it works perfectly but I can't shake the feeling that it could and should be done on 1 unique key.