event_log

CREATE TABLE IF NOT EXISTS `{PREFIX}event_log` (
`id` integer NOT NULL AUTO_INCREMENT,
`eventid` integer DEFAULT 0,
`createdon` integer NOT NULL DEFAULT 0,
`type` tinyint NOT NULL DEFAULT 1 COMMENT '1- information, 2 - warning, 3- error',
`user` integer NOT NULL DEFAULT 0 COMMENT 'link to user table',
`usertype` tinyint NOT NULL DEFAULT 0 COMMENT '0 - manager, 1 - web',
`source` varchar(50) NOT NULL DEFAULT '',
`description` text,
PRIMARY KEY(`id`),
KEY `user`(`user`)
) ENGINE=MyISAM COMMENT='Stores event and error logs';