Example 3: Mapping an Attribute to a To-one Relationship

Legacy Schema (version 3, additions only):

CREATE TABLE games (
 game_id int(10) unsigned 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 tinyint(3) unsigned NOT NULL default '0',
 game_vendor varchar(255) NOT NULL default ''
 PRIMARY KEY  (game_id)
);