CREATE TABLE `{$prefix}log` (
	`id` INT NOT NULL AUTO_INCREMENT ,
	`user_id` INT NULL DEFAULT NULL,
	`type_id` INT NOT NULL ,
	`severity_id` TINYINT NOT NULL ,
	`message` VARCHAR( 255 ) NOT NULL ,
	`data` BLOB NULL DEFAULT NULL,
	`timestamp` DATETIME NOT NULL ,
	PRIMARY KEY ( `id` )
);

CREATE TABLE `{$prefix}log_severities` (
	`id` TINYINT NOT NULL AUTO_INCREMENT ,
	`name` VARCHAR( 255 ),
	PRIMARY KEY ( `id` )
);

INSERT INTO `{$prefix}log_severities` (`name`) VALUES
	('debug'),
	('info'),
	('notice'),
	('warning'),
	('err'),
	('crit'),
	('alert'),
	('emerg');

CREATE TABLE `{$prefix}log_types` (
	`id` INT NOT NULL AUTO_INCREMENT ,
	`module` VARCHAR( 100 ) NOT NULL ,
	`type` VARCHAR( 100 ) NOT NULL ,
	PRIMARY KEY ( `id` ),
	UNIQUE KEY module_type ( `module` , `type` )
);

INSERT INTO `{$prefix}log_types` (`module`,`type`) VALUES
	('habari','default');