[Err] 1136 - Column count doesn't match value count at row 1
[Err] CREATE TABLE `yx_store_product_reply` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '评论ID',
`uid` bigint(20) NOT NULL COMMENT '用户ID',
`oid` bigint(20) NOT NULL COMMENT '订单ID',
`unique` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '唯一id',
`product_id` bigint(20) NOT NULL COMMENT '产品id',
`reply_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'product' COMMENT '某种商品类型(普通商品、秒杀商品)',
`product_score` tinyint(1) NOT NULL COMMENT '商品分数',
`service_score` tinyint(1) NOT NULL COMMENT '服务分数',
`comment` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '评论内容',
`pics` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '评论图片',
`create_time` datetime NOT NULL COMMENT '评论时间',
`update_time` datetime DEFAULT NULL,
`merchant_reply_content` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '管理员回复内容',
`merchant_reply_time` datetime DEFAULT NULL COMMENT '管理员回复时间',
`is_del` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0未删除1已删除',
`is_reply` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0未回复1已回复',
PRIMARY KEY (`id`) USING BTREE,
KEY `add_time` (`create_time`) USING BTREE,
KEY `parent_id` (`reply_type`) USING BTREE,
KEY `is_del` (`is_del`) USING BTREE,
KEY `product_score` (`product_score`) USING BTREE,
KEY `service_score` (`service_score`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='评论表';
-- ----------------------------
-- Records of yx_store_product_reply
-- ----------------------------
INSERT INTO `yx_store_product_reply` VALUES ('3', '43', '67', 'c1907f2efeff48168c119ee28ddcac42', '8', 'product', '5', '5', '棒棒哒', '', '2020-09-12 17:45:11', null, null, null, '1', '0');
INSERT INTO `yx_store_product_reply` VALUES ('4', '25', '12', 'b939e8e54f1e411496aea25295e9da2b', '1', 'product', '5', '5', '商品很好', '', '2021-04-27 15:56:20', null, null, null, '0', '0');
-- ----------------------------
-- Table structure for yx_store_product_rule
-- ----------------------------
DROP TABLE IF EXISTS `yx_store_product_rule`;
CREATE TABLE `yx_store_product_rule` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`rule_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '规格名称',
`rule_value` json NOT NULL COMMENT '规格值',
`create_time` datetime DEFAULT NULL,
`update_time` datetime DEFAULT NULL,
`is_del` tinyint(1) DEFAULT '0',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='商品规则值(规格)表';
-- ----------------------------
-- Records of yx_store_product_rule
-- ----------------------------
INSERT INTO `yx_store_product_rule` VALUES ('10', '图文', '[{\"value\": \"纸张\", \"detail\": [\"A4\", \"A3\"]}, {\"value\": \"颜色\", \"detail\": [\"白色\", \"红色\"]}]', '2020-06-29 13:46:52', '2020-06-29 15:57:28');
INSERT INTO `yx_store_product_rule` VALUES ('24', '手机', '[{\"value\": \"颜色\", \"detail\": [\"黑色\", \"白色\"]}, {\"value\": \"尺寸\", \"detail\": [\"5寸\", \"7寸\"]}]', '2020-06-29 15:55:51', '2020-07-04 19:50:14');
INSERT INTO `yx_store_product_rule` VALUES ('25', '选择件数', '[{\"value\": \"容量\", \"detail\": [\"350ml\", \"550ml\", \"1.8L\", \"6L\", \"12L\"]}, {\"value\": \"1*20\", \"detail\": [\"550\"]}]', '2021-04-21 13:59:16', '2021-04-28 11:14:21');
-- ----------------------------
-- Table structure for yx_store_seckill
-- ----------------------------
DROP TABLE IF EXISTS `yx_store_seckill`;
CREATE TABLE `yx_store_seckill` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '商品秒杀产品表id',
`product_id` bigint(20) unsigned NOT NULL COMMENT '商品id',
`image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '推荐图',
`images` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '轮播图',
`title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '活动标题',
`info` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '
[Msg] Finished - Unsuccessfully
--------------------------------------------------