
Nick Asenov - 2013-03-27 17:28:32 -
In reply to message 1 from Marios Pavlou
Hello,
Depends on how we will track users-per IP or via our own login system, we can extend table `vots` adding a column for IP/username, and (id,username) must be an unique key-this limits votes for a single product per user_name(because vots.id references to articles.id).
Also depend on how must be the system behaviour we can choose how to insert data into table `vots` (against its UNIQUE KEY (id,username)): by "insert ignore","insert...on duplicate key update" or even "replace into table..."
Regards