You are viewing a plain text version of this content. The canonical link for it is here.

Posted to notifications@shenyu.apache.org by GitBox <gi...@apache.org> on 2022/06/20 08:30:48 UTC

[GitHub] [incubator-shenyu] yu199195 commented on a diff in pull request #3583: [type:refactor] Refactor timestamp(0) to timestamp(3) to support millisecond storage

yu199195 commented on code in PR #3583:
URL: https://github.com/apache/incubator-shenyu/pull/3583#discussion_r901394946


##########
db/init/mysql/schema.sql:
##########
@@ -30,8 +30,8 @@ CREATE TABLE `alert_template`  (
   `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'alert template name',
   `strategy_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'alert template strategy name',
   `content` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'alert template content',
-  `date_created` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT 'create time',
-  `date_updated` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT 'update time',
+  `date_created` timestamp(3) NOT NULL DEFAULT CURRENT_timestamp(3) COMMENT 'create time',

Review Comment:
   modify to CURRENT_TIMESTAMP(3)



-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shenyu.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org