Adding more than 1 suggested similar game fails about ifdb-suggestion-tracker HOT 4 CLOSED

This happens because column fromgame in table crossrecs defined as primary key, so only one entry can be suggested for every game.
I tried setting created as a primary key for example, the suggestions function is back to work as intended.

from ifdb-suggestion-tracker.

@Durafen, what about putting a new id column in the table as the primary key and remove fromgame as a primary key? id seems to be the default primary key column name. Or maybe it doesn't even need a primary key?

from ifdb-suggestion-tracker.

Both of this options will work.
Removing the unique primary index is the easier way (no need for coding, only table altering).

from ifdb-suggestion-tracker.

It's better to have a unique key, so another simple option may be to set created as primary unique key.

MariaDB [ifdb]> DESCRIBE crossrecs;
+----------+-------------+------+-----+---------+-------+
| Field    | Type        | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| fromgame | varchar(32) | NO   | PRI | NULL    |       |
| togame   | varchar(32) | NO   |     | NULL    |       |
| userid   | varchar(32) | NO   | MUL | NULL    |       |
| notes    | mediumtext  | YES  |     | NULL    |       |
| created  | datetime    | NO   |     | NULL    |       |
+----------+-------------+------+-----+---------+-------+

@dfabulich Opinion? Which way is going to be more suitable?

from ifdb-suggestion-tracker.