CREATE TABLE logs ( id BIGINT NOT NULL AUTO_INCREMENT, timestamp INT(16) NOT NULL DEFAULT 0, type INT NOT NULL DEFAULT 0, data VARCHAR(256) NOT NULL DEFAULT 'NONE', PRIMARY KEY (id) ) TYPE=MyISAM AUTO_INCREMENT=1;