I have 3 tables:
Users: _id_, username
Movies: _id_, title
Friends: _#id1, #id2_, accepted
I'm with InnoDB, everything is working like that. But, even if friends' primary-key is (users.id, users.id), 2 rows like that are accepted by MySQL:
1) (1, 2)
2) (2, 1)
Is there a way to consider these 2 rows as a duplicate key for MySQL ?
Thanks for your help.