Example 2: Mapping Between To-one Relationships

Legacy Schema (version 2)

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'
 PRIMARY KEY  (game_id)
);

CREATE TABLE game_genre (
 game_genre_id int(10) unsigned NOT NULL auto_increment,
 game_genre_name varchar(30) default NULL,
 PRIMARY KEY  (game_genre_id)
);