Example 4: Mapping an Attribute to a New Row with a To-one Relationship

Legacy Schema (additions only):

CREATE TABLE games (
 game_id int(11) NOT NULL auto_increment,
 game_name varchar(80) NOT NULL default '',
 game_keywords varchar(200) NOT NULL default '',
 game_url varchar(70) NOT NULL default '',
 game_genre int(11) NOT NULL default '0',
 game_vendor varchar(255) NOT NULL default '',
 game_usersubmitid int(10) NOT NULL
 PRIMARY KEY  (game_id)
);