博客

4.11. logging 日志表的设计

CREATE TABLE `logging` (

`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,

`tag` ENUM(‘unknow’,’www’,’user’,’admin’) NOT NULL DEFAULT ‘unknow’ COMMENT ‘日志标签’,

`time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘产生时间’,

`facility` ENUM(‘bank’,’unionpay’,’sms’,’email’) NOT NULL COMMENT ‘类别’,

`priority` ENUM(‘info’,’warning’,’error’,’critical’,’exception’,’debug’) NOT NULL COMMENT ‘级别’,

`message` VARCHAR(512) NOT NULL COMMENT ‘内容’,

PRIMARY KEY (`id`)

)

COMMENT=’日志表’

COLLATE=’utf8_general_ci’

ENGINE=InnoDB

AUTO_INCREMENT=2;

分区日志表

delimiter $$