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

说明请注册2个店家。注意店家id和店铺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:13:07
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for jfshop
-- ----------------------------
DROP TABLE IF EXISTS `jfshop`;
CREATE TABLE `jfshop` (
  `shop_id` int NOT NULL COMMENT 'id=user_id',
  `sname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '店铺名称',
  `slogo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'logo',
  `sdesc` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '主营类目',
  `audit_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '审核人',
  `shop_audit` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '0待审核1通过-1不通过',
  `audit_ts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '审核时间',
  `audit_msg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '不通过的原因',
  `total_score` int DEFAULT NULL COMMENT '总评分',
  `avg_score` int DEFAULT NULL COMMENT '平均分',
  `state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '0关闭店铺1营业中',
  `score_num` int DEFAULT NULL COMMENT '评价人数',
  `cts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '创建时间',
  `business_img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '营业执照',
  `province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '省',
  `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '城市',
  `district` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '区',
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '详细地址',
  PRIMARY KEY (`shop_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='店铺';

-- ----------------------------
-- Records of jfshop
-- ----------------------------
INSERT INTO `jfshop` VALUES ('101', '小田超市', '/profile/upload/2026/05/18/08-05logo_20260518160015A036.png', '食品类、日用品类、家居家电类、服装鞋帽类、电子产品类等‌。其中，食品类是超市的核心品类，涵盖生鲜食品、冷冻食品、零食饮料等，满足消费者日常饮食需求', 'admin', '1', '2026-05-18 16:01:45', '', null, null, '1', null, '2026-05-18 16:00:48', '/profile/upload/2026/05/18/123_20260518160047A037.jpeg', '北京市', '北京市', '东城区', '北京路12号');
INSERT INTO `jfshop` VALUES ('102', '可可服装店', '/profile/upload/2026/05/18/1233_20260518160542A038.jpg', '涵盖休闲装、正装、针织衫、衬衫、外套等，满足日常通勤与社交穿着需求', 'admin', '1', '2026-05-18 16:08:05', '', null, null, '1', null, '2026-05-18 16:06:24', '/profile/upload/2026/05/18/1112_20260518160623A039.jpeg', '河北省', '秦皇岛市', '北戴河区', '武田123号');