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 ;
here's mine. no extras in the table name, no duplicate column
CREATE TABLE IF NOT EXISTS
log_entries(idint(10) unsigned NOT NULL AUTO_INCREMENT,typevarchar(45) DEFAULT NULL,messagetext,timeint(11) NOT NULL,datetimedatetime NOT NULL,ipint(11) NOT NULL,urlvarchar(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 ;