若依通用商城-测试数据直接复制使用-jfgoods

注意店铺id和你自己的店铺id一致

/*
Navicat MySQL Data Transfer

Source Server         : 127
Source Server Version : 80022
Source Host           : 127.0.0.1:3306
Source Database       : shop_ry

Target Server Type    : MYSQL
Target Server Version : 80022
File Encoding         : 65001

Date: 2026-05-18 16:16:01
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for jfgoods
-- ----------------------------
DROP TABLE IF EXISTS `jfgoods`;
CREATE TABLE `jfgoods` (
  `good_id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
  `gname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '商品名称',
  `main_img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '商品主图',
  `gimgs` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '轮播图',
  `gdesc` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '商品详情',
  `gaudit` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '0待审核1通过-1不通过',
  `audit_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '审核员',
  `audit_ts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '审核时间',
  `is_pub` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '1上架0下架',
  `total_score` int DEFAULT NULL COMMENT '总评分',
  `avg_score` int DEFAULT NULL COMMENT '评分',
  `score_num` int DEFAULT NULL COMMENT '评价人数',
  `cts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '创建时间',
  `type_id` int NOT NULL COMMENT '分类',
  `stock` int NOT NULL COMMENT '库存',
  `sales` int NOT NULL DEFAULT '0' COMMENT '销量',
  `shop_id` int NOT NULL COMMENT '店家',
  `price` decimal(10,2) NOT NULL COMMENT '展示价格',
  `spec` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '规格',
  `audit_msg` varchar(255) DEFAULT NULL COMMENT '驳回理由',
  PRIMARY KEY (`good_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='商品';

-- ----------------------------
-- Records of jfgoods
-- ----------------------------
INSERT INTO `jfgoods` VALUES ('1', 'iPhone 15 Pro Max 256G', '/profile/upload/2026/05/18/1_20260518154900A031.jpeg', '/profile/upload/2026/05/18/1_20260518154911A032.jpeg,/profile/upload/2026/05/18/1-1_20260518154911A033.jpg', '<p>最新款苹果手机，钛金属边框，A17 Pro芯片。</p>', '0', 'admin', '2023-10-01 10:00:00', '1', '500', '5', '100', '2023-10-01 09:00:00', '1', '100', '50', '101', '9999.00', '[{\"name\":\"官方标配\",\"price\":\"9999.00\",\"stock\":\"100\"}]', null);
INSERT INTO `jfgoods` VALUES ('2', '联想ThinkPad X1 商务本', '/profile/upload/2026/05/18/2_20260518154743A028.jpeg', '/profile/upload/2026/05/18/2-1_20260518154758A029.jpg,/profile/upload/2026/05/18/2_20260518154805A030.jpeg', '<p>轻薄便携，商务办公首选，高性能处理器。</p>', '0', 'admin', '2023-10-01 10:05:00', '1', '400', '4', '80', '2023-10-01 09:05:00', '2', '50', '20', '101', '8999.00', '[{\"name\":\"i7/16G/512G\",\"price\":\"8999.00\",\"stock\":\"50\"}]', null);
INSERT INTO `jfgoods` VALUES ('3', '海尔智能滚筒洗衣机', '/profile/upload/2026/05/18/3_20260518154649A025.png', '/profile/upload/2026/05/18/3_20260518154659A026.png,/profile/upload/2026/05/18/3-1_20260518154659A027.jpeg', '<p>10公斤大容量，智能除菌，静音运行。</p>', '0', 'admin', '2023-10-01 10:10:00', '1', '300', '4', '60', '2023-10-01 09:10:00', '3', '30', '15', '101', '2499.00', '[{\"name\":\"10kg直驱\",\"price\":\"2499.00\",\"stock\":\"30\"}]', null);
INSERT INTO `jfgoods` VALUES ('4', '纯棉简约男士T恤', '/profile/upload/2026/05/18/4_20260518154531A022.jpeg', '/profile/upload/2026/05/18/4_20260518154540A023.jpeg,/profile/upload/2026/05/18/4-1_20260518154546A024.jpg', '<p>100%纯棉，吸汗透气，夏季必备。</p>', '0', 'admin', '2023-10-01 10:15:00', '1', '200', '5', '200', '2023-10-01 09:15:00', '4', '500', '300', '102', '99.00', '[{\"name\":\"白色 XL\",\"price\":\"99.00\",\"stock\":\"200\"},{\"name\":\"绿色 XL\",\"price\":\"99.00\",\"stock\":\"300\"}]', null);
INSERT INTO `jfgoods` VALUES ('5', '真皮商务男士公文包', '/profile/upload/2026/05/18/5_20260518154435A019.jpg', '/profile/upload/2026/05/18/5_20260518154443A020.jpg,/profile/upload/2026/05/18/5-1_20260518154443A021.jpeg', '<p>头层牛皮制作，耐用大方，多功能隔层。</p>', '0', 'admin', '2023-10-01 10:20:00', '1', '150', '4', '40', '2023-10-01 09:20:00', '5', '80', '25', '102', '399.00', '[{\"name\":\"黑色\",\"price\":\"399.00\",\"stock\":\"80\"}]', null);
INSERT INTO `jfgoods` VALUES ('6', '专业户外登山背包', '/profile/upload/2026/05/18/6_20260518154318A016.png', '/profile/upload/2026/05/18/6_20260518154348A017.png,/profile/upload/2026/05/18/6-2_20260518154348A018.jpeg', '<p>大容量防水登山包，人体工学设计。</p>', '0', 'admin', '2023-10-01 10:25:00', '1', '180', '5', '90', '2023-10-01 09:25:00', '6', '60', '45', '101', '258.00', '[{\"name\":\"50L 蓝色\",\"price\":\"258.00\",\"stock\":\"60\"}]', null);
INSERT INTO `jfgoods` VALUES ('7', '雅诗兰黛小棕瓶精华', '/profile/upload/2026/05/18/7_20260518154218A013.jpg', '/profile/upload/2026/05/18/7_20260518154228A014.jpg,/profile/upload/2026/05/18/7-1_20260518154229A015.jpg', '<p>修护肌肤，淡化细纹，夜间修护神器。</p>', '0', 'admin', '2023-10-01 10:30:00', '1', '600', '5', '500', '2023-10-01 09:30:00', '7', '300', '150', '101', '560.00', '[{\"name\":\"30ml\",\"price\":\"560.00\",\"stock\":\"200\"},{\"name\":\"50ml\",\"price\":\"780.00\",\"stock\":\"100\"}]', null);
INSERT INTO `jfgoods` VALUES ('8', '18K玫瑰金钻石项链', '/profile/upload/2026/05/18/8_20260518154128A010.jpg', '/profile/upload/2026/05/18/8_20260518154134A011.jpg,/profile/upload/2026/05/18/8-1_20260518154135A012.jpg', '<p>璀璨钻石，精致工艺，彰显优雅气质。</p>', '0', 'admin', '2023-10-01 10:35:00', '1', '100', '5', '20', '2023-10-01 09:35:00', '8', '10', '5', '101', '3999.00', '[{\"name\":\"40cm\",\"price\":\"3999.00\",\"stock\":\"10\"}]', null);
INSERT INTO `jfgoods` VALUES ('9', '进口车厘子 JJ级 2kg', '/profile/upload/2026/05/18/9_20260518154025A007.jpg', '/profile/upload/2026/05/18/9_20260518154033A008.jpg,/profile/upload/2026/05/18/9-1_20260518154041A009.jpeg', '<p>智利进口，新鲜采摘，果肉饱满。</p>', '0', 'admin', '2023-10-01 10:40:00', '1', '80', '4', '1000', '2023-10-01 09:40:00', '9', '50', '200', '101', '199.00', '[{\"name\":\"2kg JJ级\",\"price\":\"199.00\",\"stock\":\"50\"}]', null);
INSERT INTO `jfgoods` VALUES ('10', '婴幼儿配方奶粉 3段', '/profile/upload/2026/05/18/10_20260518153911A004.jpeg', '/profile/upload/2026/05/18/10_20260518153920A005.jpeg,/profile/upload/2026/05/18/10-1_20260518153927A006.jpg', '<p>富含益生元，宝宝易吸收，荷兰原装进口。</p>', '0', 'admin', '2023-10-01 10:45:00', '1', '250', '5', '300', '2023-10-01 09:45:00', '10', '100', '80', '101', '288.00', '[{\"name\":\"800g\",\"price\":\"288.00\",\"stock\":\"100\"}]', null);
INSERT INTO `jfgoods` VALUES ('11', '北欧布艺双人沙发', '/profile/upload/2026/05/18/11_20260518153754A001.jpg', '/profile/upload/2026/05/18/11_20260518153811A002.jpg,/profile/upload/2026/05/18/11-1_20260518153812A003.jpg', '<p>简约时尚，高弹海绵，久坐不塌。</p>', '0', 'admin', '2023-10-01 10:50:00', '1', '120', '4', '30', '2023-10-01 09:50:00', '11', '20', '10', '101', '1599.00', '[{\"name\":\"三人位 灰色\",\"price\":\"1599.00\",\"stock\":\"20\"}]', null);