[数仓]二、离线数仓（业务数据采集）

 在电商系统中，SPU（Standard Product Unit）和SKU（Stock Keeping Unit）是商品管理中常见的概念：

    
  
    
 1. SPU（Standard Product Unit）：
    
 SPU是标准化产品单元，它指的是具有相同属性、功能和外观的产品组。
    
 通常来说，同一个SPU下的产品在功能上是一致的，但可能存在一些细微的差异，比如颜色、尺寸等变量。
    
 在电商系统中，SPU通常用来表示一组类似的产品，方便管理和展示。
    
  
    
 2. SKU（Stock Keeping Unit）：
    
 SKU是库存管理单位，是在特定商品下具有独特标识的产品个体。
    
 每个SKU一般对应着具体的产品属性，比如颜色、尺寸、版本等。
    
 具有不同属性的产品会有不同的SKU。SKU在电商系统中用于标识具体的产品个体，便于准确记录和管理库存。
    
  
    
 简单来说，SPU是针对一组相似产品的单元，而SKU是针对具体产品的唯一标识单元，
    
 用于区分不同的产品属性和库存管理。在电商系统中，SPU和SKU的使用有助于管理和展示商品信息，
    
 提高系统的效率和用户体验。

 SET NAMES utf8mb4;

    
 SET FOREIGN_KEY_CHECKS = 0;
    
  
    
 -- ----------------------------
    
 -- Table structure for activity_info
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `activity_info`;
    
 CREATE TABLE `activity_info`  (
    
   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '活动id',
    
   `activity_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '活动名称',
    
   `activity_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '活动类型（1：满减，2：折扣）',
    
   `activity_desc` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '活动描述',
    
   `start_time` datetime NULL DEFAULT NULL COMMENT '开始时间',
    
   `end_time` datetime NULL DEFAULT NULL COMMENT '结束时间',
    
   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    
   `operate_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    
   PRIMARY KEY (`id`) USING BTREE
    
 ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '活动表' ROW_FORMAT = DYNAMIC;
    
  
    
 -- ----------------------------
    
 -- Records of activity_info
    
 -- ----------------------------
    
 INSERT INTO `activity_info` VALUES (1, '小米手机专场', '3101', '小米手机满减2', '2022-01-13 01:01:54', '2023-06-19 00:00:00', '2022-05-27 00:00:00', NULL);
    
 INSERT INTO `activity_info` VALUES (2, 'CAREMiLLE口红满两个8折', '3102', 'CAREMiLLE口红满两个8折', '2022-01-13 01:01:54', '2023-06-19 00:00:00', '2022-05-27 00:00:00', NULL);
    
 INSERT INTO `activity_info` VALUES (3, '联想活动专场满减', '3101', '联想活动专场满减', '2022-01-13 01:01:54', '2023-06-19 00:00:00', '2022-05-27 00:00:00', NULL);
    
 INSERT INTO `activity_info` VALUES (4, 'TCL全场9折', '3103', 'TCL全场9折', '2022-01-13 01:01:54', '2023-06-19 00:00:00', '2022-05-27 00:00:00', NULL);

 -- ----------------------------

    
 -- Table structure for activity_rule
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `activity_rule`;
    
 CREATE TABLE `activity_rule`  (
    
   `id` int NOT NULL AUTO_INCREMENT COMMENT '编号',
    
   `activity_id` int NULL DEFAULT NULL COMMENT '活动id',
    
   `activity_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '活动类型',
    
   `condition_amount` decimal(16, 2) NULL DEFAULT NULL COMMENT '满减金额',
    
   `condition_num` bigint NULL DEFAULT NULL COMMENT '满减件数',
    
   `benefit_amount` decimal(16, 2) NULL DEFAULT NULL COMMENT '优惠金额',
    
   `benefit_discount` decimal(10, 2) NULL DEFAULT NULL COMMENT '优惠折扣',
    
   `benefit_level` bigint NULL DEFAULT NULL COMMENT '优惠级别',
    
   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    
   `operate_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    
   PRIMARY KEY (`id`) USING BTREE
    
 ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '活动规则表' ROW_FORMAT = DYNAMIC;
    
  
    
 -- ----------------------------
    
 -- Records of activity_rule
    
 -- ----------------------------
    
 INSERT INTO `activity_rule` VALUES (1, 1, '3101', 5000.00, NULL, 500.00, NULL, 1, '2022-02-13 01:08:32', NULL);
    
 INSERT INTO `activity_rule` VALUES (2, 1, '3101', 8000.00, NULL, 900.00, NULL, 2, '2022-02-13 01:08:32', NULL);
    
 INSERT INTO `activity_rule` VALUES (3, 2, '3102', NULL, 2, NULL, 8.50, 1, '2022-02-13 01:08:32', NULL);
    
 INSERT INTO `activity_rule` VALUES (4, 3, '3101', 5000.00, NULL, 250.00, NULL, 1, '2022-02-13 01:08:32', NULL);
    
 INSERT INTO `activity_rule` VALUES (5, 4, '3103', NULL, NULL, NULL, 9.00, 1, '2022-02-13 01:08:32', NULL);

 -- ----------------------------

    
 -- Table structure for activity_sku
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `activity_sku`;
    
 CREATE TABLE `activity_sku`  (
    
   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
    
   `activity_id` bigint NULL DEFAULT NULL COMMENT '活动id ',
    
   `sku_id` bigint NULL DEFAULT NULL COMMENT 'sku_id',
    
   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    
   `operate_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    
   PRIMARY KEY (`id`) USING BTREE
    
 ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '活动商品关联表' ROW_FORMAT = DYNAMIC;
    
  
    
 -- ----------------------------
    
 -- Records of activity_sku
    
 -- ----------------------------
    
 INSERT INTO `activity_sku` VALUES (1, 1, 1, '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `activity_sku` VALUES (2, 1, 2, '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `activity_sku` VALUES (3, 1, 3, '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `activity_sku` VALUES (4, 2, 26, '2021-12-14 00:00:00', NULL);

 -- ----------------------------

    
 -- Table structure for base_attr_info
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `base_attr_info`;
    
 CREATE TABLE `base_attr_info`  (
    
   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
    
   `attr_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '属性名称',
    
   `category_id` bigint NULL DEFAULT NULL COMMENT '分类id',
    
   `category_level` int NULL DEFAULT NULL COMMENT '分类层级',
    
   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    
   `operate_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    
   PRIMARY KEY (`id`) USING BTREE
    
 ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '属性表' ROW_FORMAT = DYNAMIC;
    
  
    
 -- ----------------------------
    
 -- Records of base_attr_info
    
 -- ----------------------------
    
 INSERT INTO `base_attr_info` VALUES (23, '运行内存33', 61, 3, '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_attr_info` VALUES (24, '机身内存', 61, 3, '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_attr_info` VALUES (25, '处理器', 287, 3, '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_attr_info` VALUES (26, '显卡', 287, 3, '2021-12-14 00:00:00', NULL);

 -- ----------------------------

    
 -- Table structure for base_attr_value
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `base_attr_value`;
    
 CREATE TABLE `base_attr_value`  (
    
   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
    
   `value_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '属性值名称',
    
   `attr_id` bigint NULL DEFAULT NULL COMMENT '属性id',
    
   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    
   `operate_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    
   PRIMARY KEY (`id`) USING BTREE
    
 ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '属性值表' ROW_FORMAT = DYNAMIC;
    
  
    
 -- ----------------------------
    
 -- Records of base_attr_value
    
 -- ----------------------------
    
 INSERT INTO `base_attr_value` VALUES (1, '红色', 18, '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_attr_value` VALUES (2, '白色', 18, '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_attr_value` VALUES (3, '红色', 19, '2021-12-14 00:00:00', NULL);

 -- ----------------------------

    
 -- Table structure for base_category1
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `base_category1`;
    
 CREATE TABLE `base_category1`  (
    
   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '一级品类id',
    
   `name` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '一级品类名称',
    
   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    
   `operate_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    
   PRIMARY KEY (`id`) USING BTREE
    
 ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '一级品类表' ROW_FORMAT = DYNAMIC;
    
  
    
 -- ----------------------------
    
 -- Records of base_category1
    
 -- ----------------------------
    
 INSERT INTO `base_category1` VALUES (1, '图书、音像、电子书刊', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_category1` VALUES (2, '手机', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_category1` VALUES (3, '家用电器', '2021-12-14 00:00:00', NULL);

 -- ----------------------------

    
 -- Table structure for base_category2
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `base_category2`;
    
 CREATE TABLE `base_category2`  (
    
   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '二级品类id',
    
   `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '二级品类名称',
    
   `category1_id` bigint NULL DEFAULT NULL COMMENT '一级品类编号',
    
   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    
   `operate_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    
   PRIMARY KEY (`id`) USING BTREE
    
 ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '二级品类表' ROW_FORMAT = DYNAMIC;
    
  
    
 -- ----------------------------
    
 -- Records of base_category2
    
 -- ----------------------------
    
 INSERT INTO `base_category2` VALUES (1, '电子书刊', 1, '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_category2` VALUES (2, '音像', 1, '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_category2` VALUES (3, '英文原版', 1, '2021-12-14 00:00:00', NULL);

 -- ----------------------------

    
 -- Table structure for base_category3
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `base_category3`;
    
 CREATE TABLE `base_category3`  (
    
   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '三级品类id',
    
   `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '三级品类名称',
    
   `category2_id` bigint NULL DEFAULT NULL COMMENT '二级品类编号',
    
   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    
   `operate_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    
   PRIMARY KEY (`id`) USING BTREE
    
 ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '三级品类表' ROW_FORMAT = DYNAMIC;
    
  
    
 -- ----------------------------
    
 -- Records of base_category3
    
 -- ----------------------------
    
 INSERT INTO `base_category3` VALUES (1, '电子书', 1, '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_category3` VALUES (2, '网络原创', 1, '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_category3` VALUES (3, '数字杂志', 1, '2021-12-14 00:00:00', NULL);

 -- ----------------------------

    
 -- Table structure for base_dic
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `base_dic`;
    
 CREATE TABLE `base_dic`  (
    
   `dic_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '编号',
    
   `dic_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '编码名称',
    
   `parent_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '父编号',
    
   `create_time` datetime NULL DEFAULT NULL COMMENT '创建日期',
    
   `operate_time` datetime NULL DEFAULT NULL COMMENT '修改日期',
    
   PRIMARY KEY (`dic_code`) USING BTREE
    
 ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;
    
  
    
 -- ----------------------------
    
 -- Records of base_dic
    
 -- ----------------------------
    
 INSERT INTO `base_dic` VALUES ('07', '退单状态', NULL, '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_dic` VALUES ('0701', '商家审核中', '07', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_dic` VALUES ('0702', '商家审核通过', '07', '2021-12-14 00:00:00', NULL);

 -- ----------------------------

    
 -- Table structure for base_province
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `base_province`;
    
 CREATE TABLE `base_province`  (
    
   `id` bigint NOT NULL COMMENT 'id',
    
   `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '省份名称',
    
   `region_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '地区id',
    
   `area_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '地区编码',
    
   `iso_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '旧版国际标准地区编码，供可视化使用',
    
   `iso_3166_2` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '新版国际标准地区编码，供可视化使用',
    
   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    
   `operate_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    
   PRIMARY KEY (`id`) USING BTREE
    
 ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '省份表' ROW_FORMAT = DYNAMIC;
    
  
    
 -- ----------------------------
    
 -- Records of base_province
    
 -- ----------------------------
    
 INSERT INTO `base_province` VALUES (1, '北京', '1', '110000', 'CN-11', 'CN-BJ', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_province` VALUES (2, '天津', '1', '120000', 'CN-12', 'CN-TJ', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_province` VALUES (3, '山西', '1', '140000', 'CN-14', 'CN-SX', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_province` VALUES (4, '内蒙古', '1', '150000', 'CN-15', 'CN-NM', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_province` VALUES (5, '河北', '1', '130000', 'CN-13', 'CN-HE', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_province` VALUES (6, '上海', '2', '310000', 'CN-31', 'CN-SH', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_province` VALUES (7, '江苏', '2', '320000', 'CN-32', 'CN-JS', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_province` VALUES (8, '浙江', '2', '330000', 'CN-33', 'CN-ZJ', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_province` VALUES (9, '安徽', '2', '340000', 'CN-34', 'CN-AH', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_province` VALUES (10, '福建', '2', '350000', 'CN-35', 'CN-FJ', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_province` VALUES (11, '江西', '2', '360000', 'CN-36', 'CN-JX', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_province` VALUES (12, '山东', '2', '370000', 'CN-37', 'CN-SD', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_province` VALUES (13, '重庆', '6', '500000', 'CN-50', 'CN-CQ', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_province` VALUES (14, '台湾', '2', '710000', 'CN-71', 'CN-TW', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_province` VALUES (15, '黑龙江', '3', '230000', 'CN-23', 'CN-HL', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_province` VALUES (16, '吉林', '3', '220000', 'CN-22', 'CN-JL', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_province` VALUES (17, '辽宁', '3', '210000', 'CN-21', 'CN-LN', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_province` VALUES (18, '陕西', '7', '610000', 'CN-61', 'CN-SN', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_province` VALUES (19, '甘肃', '7', '620000', 'CN-62', 'CN-GS', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_province` VALUES (20, '青海', '7', '630000', 'CN-63', 'CN-QH', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_province` VALUES (21, '宁夏', '7', '640000', 'CN-64', 'CN-NX', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_province` VALUES (22, '新疆', '7', '650000', 'CN-65', 'CN-XJ', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_province` VALUES (23, '河南', '4', '410000', 'CN-41', 'CN-HA', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_province` VALUES (24, '湖北', '4', '420000', 'CN-42', 'CN-HB', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_province` VALUES (25, '湖南', '4', '430000', 'CN-43', 'CN-HN', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_province` VALUES (26, '广东', '5', '440000', 'CN-44', 'CN-GD', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_province` VALUES (27, '广西', '5', '450000', 'CN-45', 'CN-GX', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_province` VALUES (28, '海南', '5', '460000', 'CN-46', 'CN-HI', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_province` VALUES (29, '香港', '5', '810000', 'CN-91', 'CN-HK', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_province` VALUES (30, '澳门', '5', '820000', 'CN-92', 'CN-MO', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_province` VALUES (31, '四川', '6', '510000', 'CN-51', 'CN-SC', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_province` VALUES (32, '贵州', '6', '520000', 'CN-52', 'CN-GZ', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_province` VALUES (33, '云南', '6', '530000', 'CN-53', 'CN-YN', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_province` VALUES (34, '西藏', '6', '540000', 'CN-54', 'CN-XZ', '2021-12-14 00:00:00', NULL);

 -- ----------------------------

    
 -- Table structure for base_region
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `base_region`;
    
 CREATE TABLE `base_region`  (
    
   `id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '地区id',
    
   `region_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '地区名称',
    
   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    
   `operate_time` datetime NULL DEFAULT NULL
    
 ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '地区表' ROW_FORMAT = DYNAMIC;
    
  
    
 -- ----------------------------
    
 -- Records of base_region
    
 -- ----------------------------
    
 INSERT INTO `base_region` VALUES ('1', '华北', '2020-05-01 11:20:40', NULL);
    
 INSERT INTO `base_region` VALUES ('2', '华东', '2020-05-01 11:20:40', NULL);
    
 INSERT INTO `base_region` VALUES ('3', '东北', '2020-05-01 11:20:40', NULL);
    
 INSERT INTO `base_region` VALUES ('4', '华中', '2020-05-01 11:20:40', NULL);
    
 INSERT INTO `base_region` VALUES ('5', '华南', '2020-05-01 11:20:40', NULL);
    
 INSERT INTO `base_region` VALUES ('6', '西南', '2020-05-01 11:20:40', NULL);
    
 INSERT INTO `base_region` VALUES ('7', '西北', '2020-05-01 11:20:40', NULL);

 -- ----------------------------

    
 -- Table structure for base_trademark
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `base_trademark`;
    
 CREATE TABLE `base_trademark`  (
    
   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
    
   `tm_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '品牌名称',
    
   `logo_url` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '品牌logo的图片路径',
    
   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    
   `operate_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    
   PRIMARY KEY (`id`) USING BTREE
    
 ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '品牌表' ROW_FORMAT = DYNAMIC;
    
  
    
 -- ----------------------------
    
 -- Records of base_trademark
    
 -- ----------------------------
    
 INSERT INTO `base_trademark` VALUES (1, 'Redmi', NULL, '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_trademark` VALUES (2, '苹果', '/static/default.jpg2323', '2021-12-14 00:00:00', NULL);

 -- ----------------------------

    
 -- Table structure for cart_info -- 少了两个字段
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `cart_info`;
    
 CREATE TABLE `cart_info`  (
    
   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
    
   `user_id` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户id',
    
   `sku_id` bigint NULL DEFAULT NULL COMMENT 'skuid',
    
   `cart_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '放入购物车时价格',
    
   `sku_num` int NULL DEFAULT NULL COMMENT '数量',
    
   `img_url` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商品图片地址',
    
   `sku_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'sku名称 (冗余)',
    
   `is_checked` int NULL DEFAULT NULL COMMENT '是否被选中',
    
   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    
   `operate_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    
   `is_ordered` bigint NULL DEFAULT NULL COMMENT '是否已经下单',
    
   `order_time` datetime NULL DEFAULT NULL COMMENT '下单时间',
    
   `source_type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '来源类型',
    
   `source_id` bigint(20) NULL DEFAULT NULL COMMENT '来源编号',
    
   PRIMARY KEY (`id`) USING BTREE,
    
   INDEX `idx_uid`(`user_id` ASC) USING BTREE
    
 ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '购物车表' ROW_FORMAT = DYNAMIC;

 -- ----------------------------

    
 -- Table structure for comment_info
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `comment_info`;
    
 CREATE TABLE `comment_info`  (
    
   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
    
   `user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
    
   `nick_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户昵称',
    
   `head_img` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    
   `sku_id` bigint NULL DEFAULT NULL COMMENT 'skuid',
    
   `spu_id` bigint NULL DEFAULT NULL COMMENT 'spuid',
    
   `order_id` bigint NULL DEFAULT NULL COMMENT '订单编号',
    
   `appraise` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '评价 1 好评 2 中评 3 差评',
    
   `comment_txt` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '评价内容',
    
   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    
   `operate_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    
   PRIMARY KEY (`id`) USING BTREE
    
 ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '商品评论表' ROW_FORMAT = DYNAMIC;

 -- ----------------------------

    
 -- Table structure for coupon_info
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `coupon_info`;
    
 CREATE TABLE `coupon_info`  (
    
   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '购物券编号',
    
   `coupon_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '购物券名称',
    
   `coupon_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '购物券类型 1 现金券 2 折扣券 3 满减券 4 满件打折券',
    
   `condition_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '满额数',
    
   `condition_num` bigint NULL DEFAULT NULL COMMENT '满件数',
    
   `activity_id` bigint NULL DEFAULT NULL COMMENT '活动编号',
    
   `benefit_amount` decimal(16, 2) NULL DEFAULT NULL COMMENT '减免金额',
    
   `benefit_discount` decimal(10, 2) NULL DEFAULT NULL COMMENT '折扣',
    
   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    
   `range_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '范围类型 1、商品(spuid) 2、品类(三级分类id) 3、品牌',
    
   `limit_num` int NOT NULL DEFAULT 0 COMMENT '最多领用次数',
    
   `taken_count` int NOT NULL DEFAULT 0 COMMENT '已领用次数',
    
   `start_time` datetime NULL DEFAULT NULL COMMENT '可以领取的开始时间',
    
   `end_time` datetime NULL DEFAULT NULL COMMENT '可以领取的结束时间',
    
   `operate_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    
   `expire_time` datetime NULL DEFAULT NULL COMMENT '过期时间',
    
   `range_desc` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '范围描述',
    
   PRIMARY KEY (`id`) USING BTREE
    
 ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '优惠券信息表' ROW_FORMAT = DYNAMIC;
    
  
    
 -- ----------------------------
    
 -- Records of coupon_info
    
 -- ----------------------------
    
 INSERT INTO `coupon_info` VALUES (1, '口红品类券满99减30', '3201', 99.00, NULL, NULL, 30.00, NULL, '2022-06-06 00:00:00', '3301', 100, 0, '2022-02-13 01:15:41', '2023-12-13 01:15:58', NULL, '2023-12-13 01:15:58', NULL);
    
 INSERT INTO `coupon_info` VALUES (2, '口红品类券满199减70', '3201', 199.00, NULL, NULL, 70.00, NULL, '2022-05-20 00:00:00', '3301', 100, 0, '2022-02-13 01:15:41', '2023-12-13 01:15:58', NULL, '2023-12-13 01:15:58', NULL);

 -- ----------------------------

    
 -- Table structure for coupon_range
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `coupon_range`;
    
 CREATE TABLE `coupon_range`  (
    
   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '购物券编号',
    
   `coupon_id` bigint NOT NULL DEFAULT 0 COMMENT '优惠券id',
    
   `range_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '范围类型 1、商品(spuid) 2、品类(三级分类id) 3、品牌',
    
   `range_id` bigint NOT NULL DEFAULT 0,
    
   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    
   `operate_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    
   PRIMARY KEY (`id`) USING BTREE
    
 ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '优惠券范围表' ROW_FORMAT = DYNAMIC;
    
  
    
 -- ----------------------------
    
 -- Records of coupon_range
    
 -- ----------------------------
    
 INSERT INTO `coupon_range` VALUES (1, 1, '3301', 477, '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `coupon_range` VALUES (2, 2, '3301', 477, '2021-12-14 00:00:00', NULL);

 -- ----------------------------

    
 -- Table structure for coupon_use
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `coupon_use`;
    
 CREATE TABLE `coupon_use`  (
    
   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
    
   `coupon_id` bigint NULL DEFAULT NULL COMMENT '购物券ID',
    
   `user_id` bigint NULL DEFAULT NULL COMMENT '用户ID',
    
   `order_id` bigint NULL DEFAULT NULL COMMENT '订单ID',
    
   `coupon_status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '购物券状态（1：未使用 2：已使用）',
    
   `get_time` datetime NULL DEFAULT NULL COMMENT '获取时间',
    
   `using_time` datetime NULL DEFAULT NULL COMMENT '使用时间',
    
   `used_time` datetime NULL DEFAULT NULL COMMENT '支付时间',
    
   `expire_time` datetime NULL DEFAULT NULL COMMENT '过期时间',
    
   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    
   `operate_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    
   PRIMARY KEY (`id`) USING BTREE
    
 ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '优惠券领用表' ROW_FORMAT = DYNAMIC;

 -- ----------------------------

    
 -- Table structure for favor_info
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `favor_info`;
    
 CREATE TABLE `favor_info`  (
    
   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
    
   `user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
    
   `sku_id` bigint NULL DEFAULT NULL COMMENT 'skuid',
    
   `spu_id` bigint NULL DEFAULT NULL COMMENT 'spuid',
    
   `is_cancel` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否已取消 0 正常 1 已取消',
    
   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    
   `operate_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    
   PRIMARY KEY (`id`) USING BTREE
    
 ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '商品收藏表' ROW_FORMAT = DYNAMIC;

 -- ----------------------------

    
 -- Table structure for order_detail
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `order_detail`;
    
 CREATE TABLE `order_detail`  (
    
   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
    
   `order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
    
   `sku_id` bigint NULL DEFAULT NULL COMMENT 'sku_id',
    
   `sku_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'sku名称（冗余)',
    
   `img_url` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '图片链接（冗余)',
    
   `order_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '购买价格(下单时sku价格）',
    
   `sku_num` bigint NULL DEFAULT NULL COMMENT '购买个数',
    
   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    
   `source_type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '来源类型',
    
   `source_id` bigint(20) NULL DEFAULT NULL COMMENT '来源编号',
    
   `split_total_amount` decimal(16, 2) NULL DEFAULT NULL,
    
   `split_activity_amount` decimal(16, 2) NULL DEFAULT NULL,
    
   `split_coupon_amount` decimal(16, 2) NULL DEFAULT NULL,
    
   `operate_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    
   PRIMARY KEY (`id`) USING BTREE
    
 ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '订单明细表' ROW_FORMAT = DYNAMIC;

 -- ----------------------------

    
 -- Table structure for order_detail_activity
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `order_detail_activity`;
    
 CREATE TABLE `order_detail_activity`  (
    
   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
    
   `order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
    
   `order_detail_id` bigint NULL DEFAULT NULL COMMENT '订单明细id',
    
   `activity_id` bigint NULL DEFAULT NULL COMMENT '活动id',
    
   `activity_rule_id` bigint NULL DEFAULT NULL COMMENT '活动规则id',
    
   `sku_id` bigint NULL DEFAULT NULL COMMENT 'skuid',
    
   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    
   `operate_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    
   PRIMARY KEY (`id`) USING BTREE
    
 ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '订单明细活动关联表' ROW_FORMAT = DYNAMIC;

 -- ----------------------------

    
 -- Table structure for order_detail_coupon
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `order_detail_coupon`;
    
 CREATE TABLE `order_detail_coupon`  (
    
   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
    
   `order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
    
   `order_detail_id` bigint NULL DEFAULT NULL COMMENT '订单明细id',
    
   `coupon_id` bigint NULL DEFAULT NULL COMMENT '购物券id',
    
   `coupon_use_id` bigint NULL DEFAULT NULL COMMENT '购物券领用id',
    
   `sku_id` bigint NULL DEFAULT NULL COMMENT 'skuid',
    
   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    
   `operate_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    
   PRIMARY KEY (`id`) USING BTREE
    
 ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '订单明细优惠券关联表' ROW_FORMAT = DYNAMIC;

 -- ----------------------------

    
 -- Table structure for order_info
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `order_info`;
    
 CREATE TABLE `order_info`  (
    
   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
    
   `consignee` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '收货人',
    
   `consignee_tel` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '收件人电话',
    
   `total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总金额',
    
   `order_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '订单状态',
    
   `user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
    
   `payment_way` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '付款方式',
    
   `delivery_address` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '送货地址',
    
   `order_comment` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '订单备注',
    
   `out_trade_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '订单交易编号（第三方支付用)',
    
   `trade_body` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '订单描述(第三方支付用)',
    
   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    
   `operate_time` datetime NULL DEFAULT NULL COMMENT '操作时间',
    
   `expire_time` datetime NULL DEFAULT NULL COMMENT '失效时间',
    
   `process_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '进度状态',
    
   `tracking_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '物流单编号',
    
   `parent_order_id` bigint NULL DEFAULT NULL COMMENT '父订单编号',
    
   `img_url` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '图片链接',
    
   `province_id` int NULL DEFAULT NULL COMMENT '省份id',
    
   `activity_reduce_amount` decimal(16, 2) NULL DEFAULT NULL COMMENT '活动减免金额',
    
   `coupon_reduce_amount` decimal(16, 2) NULL DEFAULT NULL COMMENT '优惠券减免金额',
    
   `original_total_amount` decimal(16, 2) NULL DEFAULT NULL COMMENT '原始总金额',
    
   `feight_fee` decimal(16, 2) NULL DEFAULT NULL COMMENT '运费金额',
    
   `feight_fee_reduce` decimal(16, 2) NULL DEFAULT NULL COMMENT '运费减免金额',
    
   `refundable_time` datetime NULL DEFAULT NULL COMMENT '可退款时间（签收后30天）',
    
   PRIMARY KEY (`id`) USING BTREE,
    
   INDEX `idx_uid_status`(`order_status` ASC, `user_id` ASC) USING BTREE
    
 ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '订单表' ROW_FORMAT = DYNAMIC;

 -- ----------------------------

    
 -- Table structure for order_refund_info
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `order_refund_info`;
    
 CREATE TABLE `order_refund_info`  (
    
   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
    
   `user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
    
   `order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
    
   `sku_id` bigint NULL DEFAULT NULL COMMENT 'skuid',
    
   `refund_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '退款类型',
    
   `refund_num` bigint NULL DEFAULT NULL COMMENT '退货件数',
    
   `refund_amount` decimal(16, 2) NULL DEFAULT NULL COMMENT '退款金额',
    
   `refund_reason_type` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '原因类型',
    
   `refund_reason_txt` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '原因内容',
    
   `refund_status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '退款状态（0：待审批 1：已退款）',
    
   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    
   `operate_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    
   PRIMARY KEY (`id`) USING BTREE
    
 ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '退单表' ROW_FORMAT = DYNAMIC;

 -- ----------------------------

    
 -- Table structure for order_status_log
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `order_status_log`;
    
 CREATE TABLE `order_status_log`  (
    
   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
    
   `order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
    
   `order_status` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '订单状态',
    
   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    
   `operate_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    
   PRIMARY KEY (`id`) USING BTREE
    
 ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '订单状态流水表' ROW_FORMAT = DYNAMIC;

 -- ----------------------------

    
 -- Table structure for payment_info
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `payment_info`;
    
 CREATE TABLE `payment_info`  (
    
   `id` int NOT NULL AUTO_INCREMENT COMMENT '编号',
    
   `out_trade_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '对外业务编号',
    
   `order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
    
   `user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
    
   `payment_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '支付类型（微信 支付宝）',
    
   `trade_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '交易编号',
    
   `total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额',
    
   `subject` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '交易内容',
    
   `payment_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '支付状态',
    
   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    
   `callback_time` datetime NULL DEFAULT NULL COMMENT '回调时间',
    
   `callback_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '回调信息',
    
   `operate_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    
   PRIMARY KEY (`id`) USING BTREE
    
 ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '支付信息表' ROW_FORMAT = DYNAMIC;

 -- ----------------------------

    
 -- Table structure for refund_payment
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `refund_payment`;
    
 CREATE TABLE `refund_payment`  (
    
   `id` int NOT NULL AUTO_INCREMENT COMMENT '编号',
    
   `out_trade_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '对外业务编号',
    
   `order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
    
   `sku_id` bigint NULL DEFAULT NULL COMMENT 'skuid',
    
   `payment_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '支付类型（微信 支付宝）',
    
   `trade_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '交易编号',
    
   `total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '退款金额',
    
   `subject` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '交易内容',
    
   `refund_status` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '退款状态',
    
   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    
   `callback_time` datetime NULL DEFAULT NULL COMMENT '回调时间',
    
   `callback_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '回调信息',
    
   `operate_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    
   PRIMARY KEY (`id`) USING BTREE,
    
   INDEX `idx_out_trade_no`(`out_trade_no` ASC) USING BTREE,
    
   INDEX `idx_order_id`(`order_id` ASC) USING BTREE
    
 ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '退款支付表' ROW_FORMAT = DYNAMIC;

 -- ----------------------------

    
 -- Table structure for sku_attr_value
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `sku_attr_value`;
    
 CREATE TABLE `sku_attr_value`  (
    
   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
    
   `attr_id` bigint NULL DEFAULT NULL COMMENT '平台属性id（冗余)',
    
   `value_id` bigint NULL DEFAULT NULL COMMENT '平台属性值id',
    
   `sku_id` bigint NULL DEFAULT NULL COMMENT 'skuid',
    
   `attr_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '平台属性名称',
    
   `value_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '平台属性值名称',
    
   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    
   `operate_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    
   PRIMARY KEY (`id`) USING BTREE
    
 ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'sku平台属性值关联表' ROW_FORMAT = DYNAMIC;
    
  
    
 -- ----------------------------
    
 -- Records of sku_attr_value
    
 -- ----------------------------
    
 INSERT INTO `sku_attr_value` VALUES (1, 106, 176, 1, '手机一级1', '安卓手机', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `sku_attr_value` VALUES (2, 107, 177, 1, '二级手机2', '小米', '2021-12-14 00:00:00', NULL);

 -- ----------------------------

    
 -- Table structure for sku_info
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `sku_info`;
    
 CREATE TABLE `sku_info`  (
    
   `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'skuid',
    
   `spu_id` bigint NULL DEFAULT NULL COMMENT 'spuid',
    
   `price` decimal(10, 0) NULL DEFAULT NULL COMMENT '价格',
    
   `sku_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'sku名称',
    
   `sku_desc` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商品规格描述',
    
   `weight` decimal(10, 2) NULL DEFAULT NULL COMMENT '重量',
    
   `tm_id` bigint NULL DEFAULT NULL COMMENT '品牌id(冗余)',
    
   `category3_id` bigint NULL DEFAULT NULL COMMENT '三级品类id（冗余)',
    
   `sku_default_img` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '默认显示图片地址(冗余)',
    
   `is_sale` tinyint NOT NULL DEFAULT 0 COMMENT '是否在售（1：是 0：否）',
    
   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    
   `operate_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    
   PRIMARY KEY (`id`) USING BTREE
    
 ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'sku表' ROW_FORMAT = DYNAMIC;

 -- ----------------------------

    
 -- Table structure for sku_sale_attr_value
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `sku_sale_attr_value`;
    
 CREATE TABLE `sku_sale_attr_value`  (
    
   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
    
   `sku_id` bigint NULL DEFAULT NULL COMMENT 'sku_id',
    
   `spu_id` int NULL DEFAULT NULL COMMENT 'spu_id(冗余)',
    
   `sale_attr_value_id` bigint NULL DEFAULT NULL COMMENT '销售属性值id',
    
   `sale_attr_id` bigint NULL DEFAULT NULL COMMENT '销售属性id',
    
   `sale_attr_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '销售属性名称',
    
   `sale_attr_value_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '销售属性值名称',
    
   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    
   `operate_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    
   PRIMARY KEY (`id`) USING BTREE
    
 ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'sku销售属性值表' ROW_FORMAT = DYNAMIC;

 -- ----------------------------

    
 -- Table structure for spu_info
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `spu_info`;
    
 CREATE TABLE `spu_info`  (
    
   `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'spu_id',
    
   `spu_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'spu名称',
    
   `description` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述信息',
    
   `category3_id` bigint NULL DEFAULT NULL COMMENT '三级品类id',
    
   `tm_id` bigint NULL DEFAULT NULL COMMENT '品牌id',
    
   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    
   `operate_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    
   PRIMARY KEY (`id`) USING BTREE
    
 ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'spu表' ROW_FORMAT = DYNAMIC;
    
  
    
 -- ----------------------------
    
 -- Records of spu_info
    
 -- ----------------------------
    
 INSERT INTO `spu_info` VALUES (1, '小米12sultra', '小米10', 61, 1, '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `spu_info` VALUES (2, 'Redmi 10X', 'Redmi 10X', 61, 1, '2021-12-14 00:00:00', NULL);

 -- ----------------------------

    
 -- Table structure for spu_sale_attr
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `spu_sale_attr`;
    
 CREATE TABLE `spu_sale_attr`  (
    
   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号(业务中无关联)',
    
   `spu_id` bigint NULL DEFAULT NULL COMMENT '商品id',
    
   `base_sale_attr_id` bigint NULL DEFAULT NULL COMMENT '销售属性id',
    
   `sale_attr_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '销售属性名称(冗余)',
    
   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    
   `operate_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    
   PRIMARY KEY (`id`) USING BTREE
    
 ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'spu销售属性表' ROW_FORMAT = DYNAMIC;
    
  
    
 -- ----------------------------
    
 -- Records of spu_sale_attr
    
 -- ----------------------------
    
 INSERT INTO `spu_sale_attr` VALUES (1, 1, 1, '颜色', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `spu_sale_attr` VALUES (2, 1, 2, '版本', '2021-12-14 00:00:00', NULL);

 -- ----------------------------

    
 -- Table structure for spu_sale_attr_value
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `spu_sale_attr_value`;
    
 CREATE TABLE `spu_sale_attr_value`  (
    
   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '销售属性值编号',
    
   `spu_id` bigint NULL DEFAULT NULL COMMENT 'spuid',
    
   `base_sale_attr_id` bigint NULL DEFAULT NULL COMMENT '销售属性id',
    
   `sale_attr_value_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '销售属性值名称',
    
   `sale_attr_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '销售属性名称(冗余)',
    
   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    
   `operate_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    
   PRIMARY KEY (`id`) USING BTREE
    
 ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'spu销售属性值表' ROW_FORMAT = DYNAMIC;
    
  
    
 -- ----------------------------
    
 -- Records of spu_sale_attr_value
    
 -- ----------------------------
    
 INSERT INTO `spu_sale_attr_value` VALUES (1, 1, 1, '冷杉绿', '颜色', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `spu_sale_attr_value` VALUES (2, 1, 1, '经典黑', '颜色', '2021-12-14 00:00:00', NULL);

 -- ----------------------------

    
 -- Table structure for user_address
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `user_address`;
    
 CREATE TABLE `user_address`  (
    
   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
    
   `user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
    
   `province_id` bigint NULL DEFAULT NULL COMMENT '省份id',
    
   `user_address` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户地址',
    
   `consignee` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '收件人',
    
   `phone_num` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系方式',
    
   `is_default` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否是默认',
    
   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    
   `operate_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    
   PRIMARY KEY (`id`) USING BTREE
    
 ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户地址表' ROW_FORMAT = DYNAMIC;

 -- ----------------------------

    
 -- Table structure for user_info
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `user_info`;
    
 CREATE TABLE `user_info`  (
    
   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
    
   `login_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户名称',
    
   `nick_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户昵称',
    
   `passwd` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户密码',
    
   `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户姓名',
    
   `phone_num` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号',
    
   `email` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邮箱',
    
   `head_img` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '头像',
    
   `user_level` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户级别',
    
   `birthday` date NULL DEFAULT NULL COMMENT '用户生日',
    
   `gender` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '性别 M男,F女',
    
   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    
   `operate_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    
   `status` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '状态',
    
   PRIMARY KEY (`id`) USING BTREE
    
 ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户表' ROW_FORMAT = DYNAMIC;
    
  
    
 -- ----------------------------
    
 -- Records of user_info
    
 -- ----------------------------
    
 INSERT INTO `user_info` VALUES (1, '5vifw38y83', '亮政', NULL, '马亮政', '13624443478', '5vifw38y83@163.com', NULL, '3', '1998-05-08', 'M', '2022-06-08 00:00:00', NULL, NULL);
    
 INSERT INTO `user_info` VALUES (2, 'maoddwb', '珍贞', NULL, '韩珍贞', '13796741171', 'maoddwb@0355.net', NULL, '3', '1987-12-08', 'F', '2022-06-08 00:00:00', NULL, NULL);

 -- ----------------------------

    
 -- Table structure for promotion_pos
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `promotion_pos`;
    
 CREATE TABLE `promotion_pos`  (
    
   `id` bigint NOT NULL COMMENT '营销坑位id',
    
   `pos_location` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '营销坑位位置',
    
   `pos_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '营销坑位类型：banner,宫格,列表, 瀑布',
    
   `promotion_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '营销类型：算法、固定、搜索',
    
   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    
   `operate_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    
   PRIMARY KEY (`id`) USING BTREE
    
 ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '营销坑位表' ROW_FORMAT = DYNAMIC;
    
  
    
 -- ----------------------------
    
 -- Records of promotion_pos
    
 -- ----------------------------
    
 INSERT INTO `promotion_pos` VALUES (1, '首页banner', '4201', '4101', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `promotion_pos` VALUES (2, '首页下方瀑布推荐', '4204', '4102', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `promotion_pos` VALUES (3, '搜索页排行列表', '4203', '4102', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `promotion_pos` VALUES (4, '详情页下方9宫格', '4202', '4102', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `promotion_pos` VALUES (5, '购物车底部瀑布', '4104', '4102', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `promotion_pos` VALUES (6, '我的页底部瀑布', '4104', '4102', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `promotion_pos` VALUES (7, '新品精选-新发现瀑布', '4204', '4101', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `promotion_pos` VALUES (8, '双十一活动页瀑布', '4204', '4101', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `promotion_pos` VALUES (9, '双十一活动banner', '4201', '4101', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `promotion_pos` VALUES (10, '商品搜索结果列表瀑布', '4204', '4103', '2021-12-14 00:00:00', NULL);

 -- ----------------------------

    
 -- Table structure for promotion_refer
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `promotion_refer`;
    
 CREATE TABLE `promotion_refer`  (
    
   `id` bigint NOT NULL COMMENT '外部营销渠道id',
    
   `refer_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '外部营销渠道名称',
    
   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    
   `operate_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    
   PRIMARY KEY (`id`) USING BTREE
    
 ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '营销渠道表' ROW_FORMAT = DYNAMIC;
    
  
    
 -- ----------------------------
    
 -- Records of promotion_refer
    
 -- ----------------------------
    
 INSERT INTO `promotion_refer` VALUES (1, '百度推广', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `promotion_refer` VALUES (2, '小红书软文', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `promotion_refer` VALUES (3, '手机推送消息', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `promotion_refer` VALUES (4, '微信公众号', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `promotion_refer` VALUES (5, '微博推广', '2021-12-14 00:00:00', NULL);

 -- ----------------------------

    
 -- Table structure for seckill_goods
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `seckill_goods`;
    
 CREATE TABLE `seckill_goods`  (
    
   `id` bigint NOT NULL AUTO_INCREMENT,
    
   `spu_id` bigint NULL DEFAULT NULL COMMENT 'spu_id',
    
   `sku_id` bigint NULL DEFAULT NULL COMMENT 'sku_id',
    
   `sku_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标题',
    
   `sku_default_img` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商品图片',
    
   `price` decimal(10, 2) NULL DEFAULT NULL COMMENT '原价格',
    
   `cost_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '秒杀价格',
    
   `create_time` datetime NULL DEFAULT NULL COMMENT '添加日期',
    
   `check_time` datetime NULL DEFAULT NULL COMMENT '审核日期',
    
   `status` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '审核状态',
    
   `start_time` datetime NULL DEFAULT NULL COMMENT '开始时间',
    
   `end_time` datetime NULL DEFAULT NULL COMMENT '结束时间',
    
   `num` int NULL DEFAULT NULL COMMENT '秒杀商品数',
    
   `stock_count` int NULL DEFAULT NULL COMMENT '剩余库存数',
    
   `sku_desc` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述',
    
   PRIMARY KEY (`id`) USING BTREE
    
 ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

 -- ----------------------------

    
 -- Table structure for sku_image
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `sku_image`;
    
 CREATE TABLE `sku_image`  (
    
   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
    
   `sku_id` bigint NULL DEFAULT NULL COMMENT 'skuid',
    
   `img_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '图片名称（冗余）',
    
   `img_url` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '图片路径(冗余)',
    
   `spu_img_id` bigint NULL DEFAULT NULL COMMENT 'spu图片id',
    
   `is_default` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否默认',
    
   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    
   `operate_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    
   PRIMARY KEY (`id`) USING BTREE
    
 ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '库存单元图片表' ROW_FORMAT = DYNAMIC;

 -- ----------------------------

    
 -- Table structure for spu_image
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `spu_image`;
    
 CREATE TABLE `spu_image`  (
    
   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
    
   `spu_id` bigint NULL DEFAULT NULL COMMENT '商品id',
    
   `img_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '图片名称',
    
   `img_url` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '图片路径',
    
   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    
   `operate_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    
   PRIMARY KEY (`id`) USING BTREE
    
 ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'spu图片表' ROW_FORMAT = DYNAMIC;
    
  
    
 -- ----------------------------
    
 -- Records of spu_image
    
 -- ----------------------------
    
 INSERT INTO `spu_image` VALUES (1, 1, '2ff0882c9607e57c.jpg2', 'http://47.93.148.192:8080/group1/M00/00/01/rBHu8l-rfvmAIpgZAAIvrX6L9fo612.jpg', NULL, NULL);
    
 INSERT INTO `spu_image` VALUES (2, 1, 'ead186426badb626.jpg3', 'http://47.93.148.192:8080/group1/M00/00/01/rBHu8l-rfvmAHpFuAACTenfIJWo734.jpg', NULL, NULL);

 -- ----------------------------

    
 -- Table structure for spu_poster
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `spu_poster`;
    
 CREATE TABLE `spu_poster`  (
    
   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
    
   `spu_id` bigint NULL DEFAULT NULL COMMENT '商品id',
    
   `img_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件名称',
    
   `img_url` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件路径',
    
   `create_time` datetime NOT NULL COMMENT '创建时间',
    
   `operate_time` datetime NOT NULL COMMENT '更新时间',
    
   `is_deleted` tinyint NOT NULL DEFAULT 0 COMMENT '逻辑删除 1（true）已删除， 0（false）未删除',
    
   PRIMARY KEY (`id`) USING BTREE
    
 ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '商品海报表' ROW_FORMAT = DYNAMIC;

 -- ----------------------------

    
 -- Table structure for ware_info
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `ware_info`;
    
 CREATE TABLE `ware_info`  (
    
   `id` bigint NOT NULL,
    
   `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    
   `address` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    
   `areacode` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    
   PRIMARY KEY (`id`) USING BTREE
    
 ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

 -- ----------------------------

    
 -- Table structure for ware_order_task
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `ware_order_task`;
    
 CREATE TABLE `ware_order_task`  (
    
   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
    
   `order_id` bigint NULL DEFAULT NULL COMMENT '订单编号',
    
   `consignee` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '收货人',
    
   `consignee_tel` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '收货人电话',
    
   `delivery_address` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '送货地址',
    
   `order_comment` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '订单备注',
    
   `payment_way` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '付款方式 1:在线付款 2:货到付款',
    
   `task_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工作单状态',
    
   `order_body` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '订单描述',
    
   `tracking_no` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '物流单号',
    
   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    
   `ware_id` bigint NULL DEFAULT NULL COMMENT '仓库编号',
    
   `task_comment` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工作单备注',
    
   PRIMARY KEY (`id`) USING BTREE
    
 ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '库存工作单表 库存工作单表' ROW_FORMAT = DYNAMIC;

 -- ----------------------------

    
 -- Table structure for ware_order_task_detail
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `ware_order_task_detail`;
    
 CREATE TABLE `ware_order_task_detail`  (
    
   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
    
   `sku_id` bigint NULL DEFAULT NULL COMMENT 'sku_id',
    
   `sku_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'sku名称',
    
   `sku_num` int NULL DEFAULT NULL COMMENT '购买个数',
    
   `task_id` bigint NULL DEFAULT NULL COMMENT '工作单编号',
    
   `refund_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    
   PRIMARY KEY (`id`) USING BTREE
    
 ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '库存工作单明细表 库存工作单明细表' ROW_FORMAT = DYNAMIC;

 -- ----------------------------

    
 -- Table structure for ware_sku
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `ware_sku`;
    
 CREATE TABLE `ware_sku`  (
    
   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
    
   `sku_id` bigint NULL DEFAULT NULL COMMENT 'skuid',
    
   `warehouse_id` bigint NULL DEFAULT NULL COMMENT '仓库id',
    
   `stock` int NULL DEFAULT NULL COMMENT '库存数',
    
   `stock_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '存货名称',
    
   `stock_locked` int NULL DEFAULT NULL COMMENT '锁定库存数',
    
   PRIMARY KEY (`id`) USING BTREE
    
 ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'sku与仓库关联表' ROW_FORMAT = DYNAMIC;

 -- ----------------------------

    
 -- Table structure for cms_banner
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `cms_banner`;
    
 CREATE TABLE `cms_banner`  (
    
   `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'ID',
    
   `title` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '标题',
    
   `image_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '图片地址',
    
   `link_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '链接地址',
    
   `sort` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序',
    
   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    
   `operate_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    
   PRIMARY KEY (`id`) USING BTREE
    
 ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '首页banner表' ROW_FORMAT = DYNAMIC;

 -- ----------------------------

    
 -- Table structure for base_frontend_param
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `base_frontend_param`;
    
 CREATE TABLE `base_frontend_param`  (
    
   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
    
   `code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '属性名称',
    
   `delete_id` bigint NULL DEFAULT NULL COMMENT '分类id',
    
   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    
   `operate_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    
   PRIMARY KEY (`id`) USING BTREE
    
 ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '前端数据保护表' ROW_FORMAT = DYNAMIC;

 -- ----------------------------

    
 -- Table structure for base_sale_attr
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `base_sale_attr`;
    
 CREATE TABLE `base_sale_attr`  (
    
   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
    
   `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '销售属性名称',
    
   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    
   `operate_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    
   PRIMARY KEY (`id`) USING BTREE
    
 ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '基本销售属性表' ROW_FORMAT = DYNAMIC;
    
  
    
 -- ----------------------------
    
 -- Records of base_sale_attr
    
 -- ----------------------------
    
 INSERT INTO `base_sale_attr` VALUES (1, '颜色', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_sale_attr` VALUES (2, '版本', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_sale_attr` VALUES (3, '尺码', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_sale_attr` VALUES (4, '类别', '2021-12-14 00:00:00', NULL);
    
 INSERT INTO `base_sale_attr` VALUES (5, '处理器或显卡', NULL, NULL);

 -- ----------------------------

    
 -- Table structure for financial_sku_cost
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `financial_sku_cost`;
    
 CREATE TABLE `financial_sku_cost`  (
    
   `id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    
   `sku_id` bigint NULL DEFAULT NULL COMMENT 'sku_id',
    
   `sku_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'sku名称',
    
   `busi_date` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '业务日期',
    
   `is_lastest` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否最近',
    
   `sku_cost` decimal(16, 2) NULL DEFAULT NULL COMMENT '商品结算成本',
    
   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    
   PRIMARY KEY (`id`) USING BTREE
    
 ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

 -- ----------------------------

    
 -- Table structure for z_log 
    
 -- ----------------------------
    
 DROP TABLE IF EXISTS `z_log`;
    
 CREATE TABLE `z_log`  (
    
   `id` bigint NOT NULL AUTO_INCREMENT,
    
   `log` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    
   PRIMARY KEY (`id`) USING BTREE
    
 ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

 01_mysql-community-common-5.7.16-1.el7.x86_64.rpm

    
 02_mysql-community-libs-5.7.16-1.el7.x86_64.rpm
    
 03_mysql-community-libs-compat-5.7.16-1.el7.x86_64.rpm
    
 04_mysql-community-client-5.7.16-1.el7.x86_64.rpm
    
 05_mysql-community-server-5.7.16-1.el7.x86_64.rpm
    
 mysql-connector-java-5.1.27-bin.jar

 install_mysql.sh

    
 mysql-community-client-8.0.31-1.el7.x86_64.rpm
    
 mysql-community-client-plugins-8.0.31-1.el7.x86_64.rpm
    
 mysql-community-common-8.0.31-1.el7.x86_64.rpm
    
 mysql-community-icu-data-files-8.0.31-1.el7.x86_64.rpm
    
 mysql-community-libs-8.0.31-1.el7.x86_64.rpm
    
 mysql-community-libs-compat-8.0.31-1.el7.x86_64.rpm
    
 mysql-community-server-8.0.31-1.el7.x86_64.rpm
    
 mysql-connector-j-8.0.31.jar

 #!/bin/bash

    
  
    
 set -x
    
 [ "$(whoami)" = "root" ] || exit 1
    
 [ "$(ls *.rpm | wc -l)" = "7" ] || exit 1
    
 test -f mysql-community-client-8.0.31-1.el7.x86_64.rpm && \
    
 test -f mysql-community-client-plugins-8.0.31-1.el7.x86_64.rpm && \
    
 test -f mysql-community-common-8.0.31-1.el7.x86_64.rpm && \
    
 test -f mysql-community-icu-data-files-8.0.31-1.el7.x86_64.rpm && \
    
 test -f mysql-community-libs-8.0.31-1.el7.x86_64.rpm && \
    
 test -f mysql-community-libs-compat-8.0.31-1.el7.x86_64.rpm && \
    
 test -f mysql-community-server-8.0.31-1.el7.x86_64.rpm || exit 1
    
  
    
 # 卸载MySQL
    
 systemctl stop mysql mysqld 2>/dev/null
    
 rpm -qa | grep -i 'mysql\|mariadb' | xargs -n1 rpm -e --nodeps 2>/dev/null
    
 rm -rf /var/lib/mysql /var/log/mysqld.log /usr/lib64/mysql /etc/my.cnf /usr/my.cnf
    
  
    
 set -e
    
 # 安装并启动MySQL
    
 yum install -y *.rpm >/dev/null 2>&1
    
 systemctl start mysqld
    
  
    
 #更改密码级别并重启MySQL
    
 sed -i '/\[mysqld\]/avalidate_password.length=4\nvalidate_password.policy=0' /etc/my.cnf
    
 systemctl restart mysqld
    
  
    
 # 更改MySQL配置
    
 tpass=$(cat /var/log/mysqld.log | grep "temporary password" | awk '{print $NF}')
    
 cat << EOF | mysql -uroot -p"${tpass}" --connect-expired-password >/dev/null 2>&1
    
 set password='000000';
    
 update mysql.user set host='%' where user='root';
    
 alter user 'root'@'%' identified with mysql_native_password by '000000';
    
 flush privileges;
    
 EOF

 mysql> show tables;

    
 +------------------------+
    
|Tables_in_gmall|

    
 +------------------------+
    
|activity_info|

    
|activity_rule|

    
|activity_sku|

    
|base_attr_info|

    
|base_attr_value|

    
|base_category1|

    
|base_category2|

    
|base_category3|

    
|base_dic|

    
|base_frontend_param|

    
|base_province|

    
|base_region|

    
|base_sale_attr|

    
|base_trademark|

    
|cart_info|

    
|cms_banner|

    
|comment_info|

    
|coupon_info|

    
|coupon_range|

    
|coupon_use|

    
|favor_info|

    
|financial_sku_cost|

    
|order_detail|

    
|order_detail_activity|

    
|order_detail_coupon|

    
|order_info|

    
|order_refund_info|

    
|order_status_log|

    
|payment_info|

    
|promotion_pos|

    
|promotion_refer|

    
|refund_payment|

    
|seckill_goods|

    
|sku_attr_value|

    
|sku_image|

    
|sku_info|

    
|sku_sale_attr_value|

    
|spu_image|

    
|spu_info|

    
|spu_poster|

    
|spu_sale_attr|

    
|spu_sale_attr_value|

    
|user_address|

    
|user_info|

    
|ware_info|

    
|ware_order_task|

    
|ware_order_task_detail|

    
|ware_sku|

    
|z_log|

    
 +------------------------+
    
 49 rows in set (0.00 sec)

 logging.level.root=info

    
  
    
 spring.datasource.driver-class-name=com.mysql.jdbc.Driver
    
 spring.datasource.url=jdbc:mysql://hadoop102:3306/gmall?characterEncoding=utf-8&useSSL=false&serverTimezone=GMT%2B8
    
 spring.datasource.username=root
    
 spring.datasource.password=000000
    
  
    
 logging.pattern.console=%m%n
    
 mybatis-plus.global-config.db-config.field-strategy=not_null
    
  
    
 #业务日期
    
 mock.date=2020-06-14
    
 #是否重置  注意：第一次执行必须设置为1，后续不需要重置不用设置为1
    
 mock.clear=1
    
 #是否重置用户 注意：第一次执行必须设置为1，后续不需要重置不用设置为1
    
 mock.clear.user=1
    
  
    
 #生成新用户数量
    
 mock.user.count=100
    
 #男性比例
    
 mock.user.male-rate=20
    
 #用户数据变化概率
    
 mock.user.update-rate:20
    
  
    
 #收藏取消比例
    
 mock.favor.cancel-rate=10
    
 #收藏数量
    
 mock.favor.count=100
    
  
    
 #每个用户添加购物车的概率
    
 mock.cart.user-rate=50
    
 #每次每个用户最多添加多少种商品进购物车
    
 mock.cart.max-sku-count=8 
    
 #每个商品最多买几个
    
 mock.cart.max-sku-num=3 
    
  
    
 #购物车来源  用户查询，商品推广，智能推荐, 促销活动
    
 mock.cart.source-type-rate=60:20:10:10
    
  
    
 #用户下单比例
    
 mock.order.user-rate=50
    
 #用户从购物中购买商品比例
    
 mock.order.sku-rate=50
    
 #是否参加活动
    
 mock.order.join-activity=1
    
 #是否使用购物券
    
 mock.order.use-coupon=1
    
 #购物券领取人数
    
 mock.coupon.user-count=100
    
  
    
 #支付比例
    
 mock.payment.rate=70
    
 #支付方式 支付宝：微信 ：银联
    
 mock.payment.payment-type=30:60:10
    
  
    
  
    
 #评价比例 好：中：差：自动
    
 mock.comment.appraise-rate=30:10:10:50
    
  
    
 #退款原因比例：质量问题 商品描述与实际描述不一致 缺货 号码不合适 拍错 不想买了 其他
    
 mock.refund.reason-rate=30:10:20:5:15:5:5

 export HADOOP_COMMON_HOME=/opt/module/hadoop-3.1.3

    
 ​​​​​​​export HADOOP_MAPRED_HOME=/opt/module/hadoop-3.1.3
    
 export HIVE_HOME=/opt/module/hive
    
 export ZOOKEEPER_HOME=/opt/module/zookeeper-3.5.7
    
 export ZOOCFGDIR=/opt/module/zookeeper-3.5.7/conf

 Available commands:

    
   codegen            Generate code to interact with database records
    
   create-hive-table     Import a table definition into Hive
    
   eval               Evaluate a SQL statement and display the results
    
   export             Export an HDFS directory to a database table
    
   help               List available commands
    
   import             Import a table from a database to HDFS
    
   import-all-tables     Import tables from a database to HDFS
    
   import-mainframe    Import datasets from a mainframe server to HDFS
    
   job                Work with saved jobs
    
   list-databases        List available databases on a server
    
   list-tables           List available tables in a database
    
   merge              Merge results of incremental imports
    
   metastore           Run a standalone Sqoop metastore
    
   version            Display version information

 information_schema

    
 metastore
    
 mysql
    
 oozie
    
 performance_schema

 bin/sqoop import \

    
 --connect jdbc:mysql://hadoop102:3306/gmall \
    
 --username root \
    
 --password 000000 \
    
 --table user_info \
    
 --columns id,login_name \
    
 --where "id>=10 and id<=30" \
    
 --target-dir /test \
    
 --delete-target-dir \
    
 --fields-terminated-by '\t' \
    
 --num-mappers 2 \
    
 --split-by id

 #! /bin/bash

    
  
    
 APP=gmall
    
 sqoop=/opt/module/sqoop/bin/sqoop
    
  
    
 if [ -n "$2" ] ;then
    
    do_date=$2
    
 else 
    
    echo "请传入日期参数"
    
    exit
    
 fi 
    
  
    
 import_data(){
    
 $sqoop import \
    
 --connect jdbc:mysql://hadoop102:3306/$APP \
    
 --username root \
    
 --password 000000 \
    
 --target-dir /origin_data/$APP/db/$1/$do_date \
    
 --delete-target-dir \
    
 --query "$2 where \$CONDITIONS" \
    
 --num-mappers 1 \
    
 --fields-terminated-by '\t' \
    
 --compress \
    
 --compression-codec lzop \
    
 --null-string '\ N' \
    
 --null-non-string '\ N'
    
  
    
 hadoop jar /opt/module/hadoop-3.1.3/share/hadoop/common/hadoop-lzo-0.4.20.jar com.hadoop.compression.lzo.DistributedLzoIndexer /origin_data/$APP/db/$1/$do_date
    
 }
    
  
    
 import_order_info(){
    
   import_data order_info "select
    
                         id, 
    
                         total_amount, 
    
                         order_status, 
    
                         user_id, 
    
                         payment_way,
    
                         delivery_address,
    
                         out_trade_no, 
    
                         create_time, 
    
                         operate_time,
    
                         expire_time,
    
                         tracking_no,
    
                         province_id,
    
                         activity_reduce_amount,
    
                         coupon_reduce_amount,                            
    
                         original_total_amount,
    
                         feight_fee,
    
                         feight_fee_reduce      
    
                     from order_info"
    
 }
    
  
    
 import_coupon_use(){
    
   import_data coupon_use "select
    
                       id,
    
                       coupon_id,
    
                       user_id,
    
                       order_id,
    
                       coupon_status,
    
                       get_time,
    
                       using_time,
    
                       used_time,
    
                       expire_time
    
                     from coupon_use"
    
 }
    
  
    
 import_order_status_log(){
    
   import_data order_status_log "select
    
                               id,
    
                               order_id,
    
                               order_status,
    
                               operate_time
    
                             from order_status_log"
    
 }
    
  
    
 import_user_info(){
    
   import_data "user_info" "select 
    
                         id,
    
                         login_name,
    
                         nick_name,
    
                         name,
    
                         phone_num,
    
                         email,
    
                         user_level, 
    
                         birthday,
    
                         gender,
    
                         create_time,
    
                         operate_time
    
                       from user_info"
    
 }
    
  
    
 import_order_detail(){
    
   import_data order_detail "select 
    
                           id,
    
                           order_id, 
    
                           sku_id,
    
                           sku_name,
    
                           order_price,
    
                           sku_num, 
    
                           create_time,
    
                           source_type,
    
                           source_id,
    
                           split_total_amount,
    
                           split_activity_amount,
    
                           split_coupon_amount
    
                         from order_detail"
    
 }
    
  
    
 import_payment_info(){
    
   import_data "payment_info"  "select 
    
                             id,  
    
                             out_trade_no, 
    
                             order_id, 
    
                             user_id, 
    
                             payment_type, 
    
                             trade_no, 
    
                             total_amount,  
    
                             subject, 
    
                             payment_status,
    
                             create_time,
    
                             callback_time 
    
                           from payment_info"
    
 }
    
  
    
 import_comment_info(){
    
   import_data comment_info "select
    
                           id,
    
                           user_id,
    
                           sku_id,
    
                           spu_id,
    
                           order_id,
    
                           appraise,
    
                           create_time
    
                         from comment_info"
    
 }
    
  
    
 import_order_refund_info(){
    
   import_data order_refund_info "select
    
                             id,
    
                             user_id,
    
                             order_id,
    
                             sku_id,
    
                             refund_type,
    
                             refund_num,
    
                             refund_amount,
    
                             refund_reason_type,
    
                             refund_status,
    
                             create_time
    
                           from order_refund_info"
    
 }
    
  
    
 import_sku_info(){
    
   import_data sku_info "select 
    
                       id,
    
                       spu_id,
    
                       price,
    
                       sku_name,
    
                       sku_desc,
    
                       weight,
    
                       tm_id,
    
                       category3_id,
    
                       is_sale,
    
                       create_time
    
                     from sku_info"
    
 }
    
  
    
 import_base_category1(){
    
   import_data "base_category1" "select 
    
                               id,
    
                               name 
    
                             from base_category1"
    
 }
    
  
    
 import_base_category2(){
    
   import_data "base_category2" "select
    
                               id,
    
                               name,
    
                               category1_id 
    
                             from base_category2"
    
 }
    
  
    
 import_base_category3(){
    
   import_data "base_category3" "select
    
                               id,
    
                               name,
    
                               category2_id
    
                             from base_category3"
    
 }
    
  
    
 import_base_province(){
    
   import_data base_province "select
    
                           id,
    
                           name,
    
                           region_id,
    
                           area_code,
    
                           iso_code,
    
                           iso_3166_2
    
                         from base_province"
    
 }
    
  
    
 import_base_region(){
    
   import_data base_region "select
    
                           id,
    
                           region_name
    
                         from base_region"
    
 }
    
  
    
 import_base_trademark(){
    
   import_data base_trademark "select
    
                             id,
    
                             tm_name
    
                           from base_trademark"
    
 }
    
  
    
 import_spu_info(){
    
   import_data spu_info "select
    
                         id,
    
                         spu_name,
    
                         category3_id,
    
                         tm_id
    
                       from spu_info"
    
 }
    
  
    
 import_favor_info(){
    
   import_data favor_info "select
    
                       id,
    
                       user_id,
    
                       sku_id,
    
                       spu_id,
    
                       is_cancel,
    
                       create_time,
    
                       cancel_time
    
                     from favor_info"
    
 }
    
  
    
 import_cart_info(){
    
   import_data cart_info "select
    
                     id,
    
                     user_id,
    
                     sku_id,
    
                     cart_price,
    
                     sku_num,
    
                     sku_name,
    
                     create_time,
    
                     operate_time,
    
                     is_ordered,
    
                     order_time,
    
                     source_type,
    
                     source_id
    
                   from cart_info"
    
 }
    
  
    
 import_coupon_info(){
    
   import_data coupon_info "select
    
                       id,
    
                       coupon_name,
    
                       coupon_type,
    
                       condition_amount,
    
                       condition_num,
    
                       activity_id,
    
                       benefit_amount,
    
                       benefit_discount,
    
                       create_time,
    
                       range_type,
    
                       limit_num,
    
                       taken_count,
    
                       start_time,
    
                       end_time,
    
                       operate_time,
    
                       expire_time
    
                     from coupon_info"
    
 }
    
  
    
 import_activity_info(){
    
   import_data activity_info "select
    
                           id,
    
                           activity_name,
    
                           activity_type,
    
                           start_time,
    
                           end_time,
    
                           create_time
    
                         from activity_info"
    
 }
    
  
    
 import_activity_rule(){
    
     import_data activity_rule "select
    
                                 id,
    
                                 activity_id,
    
                                 activity_type,
    
                                 condition_amount,
    
                                 condition_num,
    
                                 benefit_amount,
    
                                 benefit_discount,
    
                                 benefit_level
    
                             from activity_rule"
    
 }
    
  
    
 import_base_dic(){
    
     import_data base_dic "select
    
                         dic_code,
    
                         dic_name,
    
                         parent_code,
    
                         create_time,
    
                         operate_time
    
                       from base_dic"
    
 }
    
  
    
  
    
 import_order_detail_activity(){
    
     import_data order_detail_activity "select
    
                                                             id,
    
                                                             order_id,
    
                                                             order_detail_id,
    
                                                             activity_id,
    
                                                             activity_rule_id,
    
                                                             sku_id,
    
                                                             create_time
    
                                                         from order_detail_activity"
    
 }
    
  
    
  
    
 import_order_detail_coupon(){
    
     import_data order_detail_coupon "select
    
                                                             id,
    
 								                                                order_id,
    
                                                             order_detail_id,
    
                                                             coupon_id,
    
                                                             coupon_use_id,
    
                                                             sku_id,
    
                                                             create_time
    
                                                         from order_detail_coupon"
    
 }
    
  
    
  
    
 import_refund_payment(){
    
     import_data refund_payment "select
    
                                                     id,
    
                                                     out_trade_no,
    
                                                     order_id,
    
                                                     sku_id,
    
                                                     payment_type,
    
                                                     trade_no,
    
                                                     total_amount,
    
                                                     subject,
    
                                                     refund_status,
    
                                                     create_time,
    
                                                     callback_time
    
                                                 from refund_payment"                                                    
    
  
    
 }
    
  
    
 import_sku_attr_value(){
    
     import_data sku_attr_value "select
    
                                                 id,
    
                                                 attr_id,
    
                                                 value_id,
    
                                                 sku_id,
    
                                                 attr_name,
    
                                                 value_name
    
                                             from sku_attr_value"
    
 }
    
  
    
  
    
 import_sku_sale_attr_value(){
    
     import_data sku_sale_attr_value "select
    
                                                         id,
    
                                                         sku_id,
    
                                                         spu_id,
    
                                                         sale_attr_value_id,
    
                                                         sale_attr_id,
    
                                                         sale_attr_name,
    
                                                         sale_attr_value_name
    
                                                     from sku_sale_attr_value"
    
 }
    
  
    
 case $1 in
    
   "order_info")
    
      import_order_info
    
 ;;
    
   "base_category1")
    
      import_base_category1
    
 ;;
    
   "base_category2")
    
      import_base_category2
    
 ;;
    
   "base_category3")
    
      import_base_category3
    
 ;;
    
   "order_detail")
    
      import_order_detail
    
 ;;
    
   "sku_info")
    
      import_sku_info
    
 ;;
    
   "user_info")
    
      import_user_info
    
 ;;
    
   "payment_info")
    
      import_payment_info
    
 ;;
    
   "base_province")
    
      import_base_province
    
 ;;
    
   "base_region")
    
      import_base_region
    
 ;;
    
   "base_trademark")
    
      import_base_trademark
    
 ;;
    
   "activity_info")
    
       import_activity_info
    
 ;;
    
   "cart_info")
    
       import_cart_info
    
 ;;
    
   "comment_info")
    
       import_comment_info
    
 ;;
    
   "coupon_info")
    
       import_coupon_info
    
 ;;
    
   "coupon_use")
    
       import_coupon_use
    
 ;;
    
   "favor_info")
    
       import_favor_info
    
 ;;
    
   "order_refund_info")
    
       import_order_refund_info
    
 ;;
    
   "order_status_log")
    
       import_order_status_log
    
 ;;
    
   "spu_info")
    
       import_spu_info
    
 ;;
    
   "activity_rule")
    
       import_activity_rule
    
 ;;
    
   "base_dic")
    
       import_base_dic
    
 ;;
    
   "order_detail_activity")
    
       import_order_detail_activity
    
 ;;
    
   "order_detail_coupon")
    
       import_order_detail_coupon
    
 ;;
    
   "refund_payment")
    
       import_refund_payment
    
 ;;
    
   "sku_attr_value")
    
       import_sku_attr_value
    
 ;;
    
   "sku_sale_attr_value")
    
       import_sku_sale_attr_value
    
 ;;
    
   "all")
    
    import_base_category1
    
    import_base_category2
    
    import_base_category3
    
    import_order_info
    
    import_order_detail
    
    import_sku_info
    
    import_user_info
    
    import_payment_info
    
    import_base_region
    
    import_base_province
    
    import_base_trademark
    
    import_activity_info
    
    import_cart_info
    
    import_comment_info
    
    import_coupon_use
    
    import_coupon_info
    
    import_favor_info
    
    import_order_refund_info
    
    import_order_status_log
    
    import_spu_info
    
    import_activity_rule
    
    import_base_dic
    
    import_order_detail_activity
    
    import_order_detail_coupon
    
    import_refund_payment
    
    import_sku_attr_value
    
    import_sku_sale_attr_value
    
 ;;
    
 esac