Displaying 1 result from an estimated 1 matches for "icon_id".
Did you mean:
con_id
2006 Jun 28
0
ActiveRecord mapping users to icons
...ecord or structure the tables or
both so that it''s clear either of those are the desired intent.
Below is more detail, appreciate any thoughts.
TABLES
------
CREATE TABLE users (
id INT NOT NULL AUTO_INCREMENT,
username VARCHAR(32) NOT NULL,
/* main thought is to add another icon_id key column here
that maps directly to the single primary icon or is null if
there is none, but can''t seem to get AR to use this */
PRIMARY KEY (id)
) type=InnoDB CHARACTER SET utf8;
CREATE TABLE user_icons (
id INT NOT NULL AUTO_INCREMENT,
user_id INT NOT NULL,...