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

New Schema (version 3, additions only):

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',
 publisher int(11) NOT NULL default '0'
 PRIMARY KEY  (id)
);

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