🕸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.
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.