here's mine. no extras in the table name, no duplicate column
CREATE TABLE IF NOT EXISTS log_entries (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
type varchar(45) DEFAULT NULL,
message text,
time int(11) NOT NULL,
datetime datetime NOT NULL,
ip int(11) NOT NULL,
url varchar(255) NOT NULL,
PRIMARY KEY (id),
KEY type (type),
KEY ip (ip),
KEY url (url),
KEY time (time),
KEY datetime (datetime)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;