DROP DATABASE IF EXISTS gamestats;
CREATE DATABASE gamestats;
USE gamestats;
CREATE TABLE games ( 
  source char(32) NOT NULL, 
  gameid char(64) NOT NULL, 
  platform char(32) NOT NULL, 
  name char(64) NOT NULL, 
  category char(64) NOT NULL, 
  subcategory char(64) NOT NULL, 
  reldate date, 
  physics int 
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
