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 $$
版权声明:本文为weixin_29100399原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。