DROP TABLE IF EXISTS tb_carousel;受影响的行 0时间 0005sSQLCREATE TABLE tb_carousel carousel_id int11 NOT NULL AUTO_INCREMENT COMMENT 首页轮播图主键id carousel_url varchar100 CHARACTER SET utf8 COLLATE utf8_gene

CREATE TABLE tb_carousel ( carousel_id int(11) NOT NULL AUTO_INCREMENT COMMENT '首页轮播图主键id', carousel_url varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '轮播图', redirect_url varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ''##'' COMMENT '点击后的跳转地址(默认不跳转)', carousel_rank int(11) NOT NULL DEFAULT 0 COMMENT '排序值(字段越大越靠前)', is_deleted tinyint(4) NOT NULL DEFAULT 0 COMMENT '删除标识字段(0-未删除 1-已删除)', create_time datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间', create_user int(11) NOT NULL DEFAULT 0 COMMENT '创建者id', update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', update_user int(11) NULL DEFAULT 0 COMMENT '修改者id', PRIMARY KEY (carousel_id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '轮播图表' ROW_FORMAT = Dynamic;

将`update_time`的数据类型改为`timestamp`，并将默认值设为`CURRENT_TIMESTAMP`