Example 1: Mapping Scalar Column Values

Legacy Schema (simplified, version 1)

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

New Schema (simplified, version 1)

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,
 PRIMARY KEY  (id)
);