Check out Janggi (Korean Chess), our featured variant for December, 2024.


[ Help | Earliest Comments | Latest Comments ]
[ List All Subjects of Discussion | Create New Subject of Discussion ]
[ List Earliest Comments Only For Pages | Games | Rated Pages | Rated Games | Subjects of Discussion ]

Single Comment

[Subject Thread] [Add Response]
🕸Fergus Duniho wrote on Sat, Mar 10, 2012 01:21 PM UTC:
Having read some more about MySQL, I think the table might look like this:

create table Likes (
    ItemID blob,
    UserID blob,
    Freq tinyint,
    Rating tinyint,
    primary key (ItemID, UserID),
    key (ItemID),
    key (UserID)
);

I removed UniqID, because I learned that a key can be made from multiple
fields.