TIMESTAMP在MySQL5.5中的行为:
1.第一个未设置默认值的TIMESTAMP NOT NULL字段隐式默认值:CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
2.后面未设置默认值的TIMESTAMP NOT NULL字段隐式默认值:0000-00-00 00:00:00
3.不支持多个CURRENT_TIMESTAMP 默认值
5.5的建表语句类似这样:
CREATE TABLE `audit_log` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `ent_id` int(10) unsigned NOT NULL DEFAULT '0', `rule_id` int(10) unsigned NOT NULL DEFAULT '0', `rules_detail` varchar(2048) NOT NULL DEFAULT '' COMMENT '规则详情', `sender_email` varchar(512) NOT NULL DEFAULT '' COMMENT '发件人被审核邮箱', `receiver_email` varchar(512) NOT NULL DEFAULT '' COMMENT '收件人邮箱', `subject` varchar(512) NOT NULL DEFAULT '' COMMENT '主题', `createtime` timestamp NOT NULL DEFAULT CURRENT_TIMES.........