CREATE TABLE tb_goods_category category_id bigint20 NOT NULL AUTO_INCREMENT COMMENT 分类id category_level tinyint4 NOT NULL DEFAULT 0 COMMENT 分类级别1-一级分类 2-二级分类 3-三级分类 parent_id bigint20 NOT NULL DE
将第8行的datetime(0)改为TIMESTAMP(0)即可:
CREATE TABLE `tb_goods_category` (
`category_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '分类id',
`category_level` tinyint(4) NOT NULL DEFAULT 0 COMMENT '分类级别(1-一级分类 2-二级分类 3-三级分类)',
`parent_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '父分类id',
`category_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '分类名称',
`category_rank` int(11) NOT NULL DEFAULT 0 COMMENT '排序值(字段越大越靠前)',
`is_deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT '删除标识字段(0-未删除 1-已删除)',
`create_time` TIMESTAMP(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
`create_user` int(11) NOT NULL DEFAULT 0 COMMENT '创建者id',
`update_time` TIMESTAMP(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '修改时间',
`update_user` int(11) NULL DEFAULT 0 COMMENT '修改者id',
PRIMARY KEY (`category_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 107 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '分类表' ROW_FORMAT = Dynamic;
``
原文地址: http://www.cveoy.top/t/topic/hpHa 著作权归作者所有。请勿转载和采集!