CREATE TABLE myTable (
    id INT NOT NULL AUTO_INCREMENT,
    atTime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL AUTO_INCREMENT,
    stuff varchar(100) NULL,
    CONSTRAINT myTable_PK PRIMARY KEY (id)
)
ENGINE=InnoDB
DEFAULT CHARSET=latin1
COLLATE=latin1_swedish_ci ;