CREATE TABLE areas ( id int(11) NOT NULL auto_increment, short_name varchar(10) NOT NULL default '', long_name varchar(200) NOT NULL default '', PRIMARY KEY (id), KEY short_name (short_name) ) TYPE=MyISAM; CREATE TABLE stats ( id bigint(20) unsigned NOT NULL auto_increment, aid int(11) NOT NULL default '0', uid int(11) NOT NULL default '0', login_name varchar(15) NOT NULL default '', full_name varchar(50) NOT NULL default '', cpu int(11) NOT NULL default '0', mem int(11) NOT NULL default '0', conn int(11) NOT NULL default '0', disk_blocks bigint(20) NOT NULL default '0', procs int(11) NOT NULL default '0', sess int(11) NOT NULL default '0', month int(11) NOT NULL default '0', year year(4) NOT NULL default '2004', PRIMARY KEY (id) ) TYPE=MyISAM;