CREATE TABLE TESTTABLE ( testid int(11) unsigned not NULL auto_increment, testcolumn varchar(255) NOT NULL default '', othertestcolumn varchar(255) NOT NULL default '', PRIMARY KEY (testid) ) ENGINE=InnoDB;