Merge pull request chenlinzhong#8 from arthasking123/master

chenlinzhong · web-flow · commit 8d78298b635d · 2022-03-11T21:03:26.000+08:00
update dq_stat time field
diff --git a/dq.sql b/dq.sql
@@ -37,8 +37,8 @@ CREATE TABLE `dq_stat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `u_key` varchar(255) NOT NULL DEFAULT '',
  `num` int(11) NOT NULL DEFAULT '0',
- `create_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
- `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+ `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
+ `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `u_key` (`u_key`)
 ) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;
