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

New Schema (additions only):

CREATE TABLE user (
 id int(11) NOT NULL auto_increment,
 legacy_userid in(11) default 0,
 PRIMARY KEY  (id)
);

CREATE TABLE game_edits (
 id int(11) NOT NULL auto_increment,
 edited_field varchar(255) default NULL,
 new_value varchar(255) default NULL,
 edited_row int(11) NOT NULL default 0,
 user_id int(11) NOT NULL default 0,
 submission_datetime datetime default NULL,
 PRIMARY KEY  (id)
);