Skip to content

error db script #2

Description

@arielsom

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 ;

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions