真正的伟人,能在愚昧和喧嚣的物质世界中,静心倾听荒漠的声音。——深泉学院(美国)

自用sql,我建站时每张表必备如下字段:

DROP TABLE IF EXISTS `common_template`;
CREATE TABLE `common_template` (
`id` bigint(0) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
`is_deleted` tinyint(0) UNSIGNED NOT NULL DEFAULT 0 COMMENT '逻辑删除字段 0未删除 1已删除',
`gmt_create` datetime(0) NOT NULL COMMENT '现在时表示主动式创建',
`gmt_modified` datetime(0) NOT NULL COMMENT '过去分词表示被动式更新',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;