CREATE TABLE IF NOT EXISTS Game ( turn int(10) unsigned NOT NULL, provinces int(10) unsigned NOT NULL default '0', forts int(10) unsigned NOT NULL default '0', income int(10) unsigned NOT NULL default '0', gemincome int(10) unsigned NOT NULL default '0', research int(10) unsigned NOT NULL default '0', dominion int(10) unsigned NOT NULL default '0', armysize int(10) unsigned NOT NULL default '0', victorypoints int(10) unsigned NOT NULL default '0', nation varchar(25) NOT NULL COMMENT 'id # or name', PRIMARY KEY (turn, nation),)