Example 2: Mapping Between To-one Relationships

New Schema (version 2)

CREATE TABLE game (
 id int(11) NOT NULL auto_increment,
 name varchar(255) default NULL,
 website varchar(255) default NULL,
 search_data varchar(255) default NULL,
 game_genre int(11) NOT NULL default '0'
 PRIMARY KEY  (id)
);

CREATE TABLE game_type (
 id int(11) NOT NULL auto_increment,
 name varchar(255) default NULL,
 PRIMARY KEY  (id)
);