Create table failed

ERROR: CREATE TABLE failed.

Here’s the script.

CREATE TABLE sb_incidents
(incident_id int(4) NOT NULL AUTO_INCREMENT
,date date(8) NULL
,reported_by text NULL
,address text(20) NULL
,violation text(20) NULL
,note text(500) NULL
,PRIMARY KEY (incident_id)
) ENGINE InnoDB DEFAULT CHARACTER SET latin1 COLLATE=latin1_swedish_ci;