text: /*
   Navicat Premium Data Transfer
  
   Source Server         : 101.37.69.49
   Source Server Type    : MySQL
   Source Server Version : 80022
   Source Host           : 101.37.69.49:3306
   Source Schema         : mall-pms
  
   Target Server Type    : MySQL
   Target Server Version : 80022
   File Encoding         : 65001
  
   Date: 11/01/2021 23:59:59
  */
  
  SET NAMES utf8mb4;
  SET FOREIGN_KEY_CHECKS = 0;
  
  -- ----------------------------
  -- Table structure for pms_attr
  -- ----------------------------
  DROP TABLE IF EXISTS `pms_attr`;
  CREATE TABLE `pms_attr`  (
    `id` bigint(0) NOT NULL AUTO_INCREMENT,
    `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '属性名称',
    `category_id` bigint(0) NOT NULL COMMENT '分类ID',
    `gmt_create` datetime(0) NULL DEFAULT NULL,
    `gmt_modified` datetime(0) NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE,
    INDEX `fk_pms_attr_pms_category`(`category_id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '商品属性表' ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of pms_attr
  -- ----------------------------
  INSERT INTO `pms_attr` VALUES (1, '上市日期', 2, NULL, NULL);
  INSERT INTO `pms_attr` VALUES (3, '上市时间', 24, NULL, NULL);
  INSERT INTO `pms_attr` VALUES (4, '季节', 24, NULL, NULL);
  INSERT INTO `pms_attr` VALUES (5, '上市时间', 47, NULL, NULL);
  INSERT INTO `pms_attr` VALUES (6, '适合季节', 47, NULL, NULL);
  INSERT INTO `pms_attr` VALUES (7, '1', 26, NULL, NULL);
  INSERT INTO `pms_attr` VALUES (8, '2', 26, NULL, NULL);
  INSERT INTO `pms_attr` VALUES (9, '3', 26, NULL, NULL);
  INSERT INTO `pms_attr` VALUES (10, '3', 31, NULL, NULL);
  INSERT INTO `pms_attr` VALUES (11, '223', 31, NULL, NULL);
  
  -- ----------------------------
  -- Table structure for pms_brand
  -- ----------------------------
  DROP TABLE IF EXISTS `pms_brand`;
  CREATE TABLE `pms_brand`  (
    `id` bigint(0) NOT NULL AUTO_INCREMENT,
    `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '品牌名称',
    `first_letter` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '检索首字母',
    `logo_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '品牌logo图片地址',
    `sort` int(0) NULL DEFAULT NULL COMMENT '排序',
    `status` tinyint(0) NULL DEFAULT NULL COMMENT '状态: 1-正常 0-禁用',
    `gmt_create` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    `gmt_modified` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '商品品牌表' ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of pms_brand
  -- ----------------------------
  INSERT INTO `pms_brand` VALUES (3, '有来', 'Y', NULL, 1, 1, NULL, NULL);
  
  -- ----------------------------
  -- Table structure for pms_category
  -- ----------------------------
  DROP TABLE IF EXISTS `pms_category`;
  CREATE TABLE `pms_category`  (
    `id` bigint(0) NOT NULL AUTO_INCREMENT,
    `parent_id` bigint(0) NOT NULL,
    `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '分类名称',
    `level` int(0) NULL DEFAULT NULL COMMENT '层级',
    `icon_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '图标地址',
    `sort` int(0) NULL DEFAULT NULL COMMENT '排序',
    `status` tinyint(1) NULL DEFAULT 1 COMMENT '显示状态: 0-隐藏 1-显示',
    `gmt_create` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    `gmt_modified` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 49 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '商品分类表' ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of pms_category
  -- ----------------------------
  INSERT INTO `pms_category` VALUES (1, 0, '手机数码', 1, NULL, 1, 1, NULL, NULL);
  INSERT INTO `pms_category` VALUES (2, 1, '手机通讯', 2, '', 1, 1, NULL, NULL);
  INSERT INTO `pms_category` VALUES (23, 0, '男装女装', 1, NULL, 4, 1, NULL, NULL);
  INSERT INTO `pms_category` VALUES (24, 23, '男装', 2, '', 1, 1, NULL, NULL);
  INSERT INTO `pms_category` VALUES (25, 1, '运营商', 2, '', 2, 1, NULL, NULL);
  INSERT INTO `pms_category` VALUES (26, 2, '全面屏手机', 3, 'http://101.37.69.49:9000/default/01d9990b90644628a07821de0992e758.jpg', 1, 1, NULL, NULL);
  INSERT INTO `pms_category` VALUES (27, 25, '合约机', 3, 'http://101.37.69.49:9000/default/16d47b13686a4553b032309f4759f00b.jpg', 1, 1, NULL, NULL);
  INSERT INTO `pms_category` VALUES (28, 2, '游戏手机', 3, 'http://101.37.69.49:9000/default/31f775c1ca274f7596b4a65644b4c809.jpg', 2, 1, NULL, NULL);
  INSERT INTO `pms_category` VALUES (29, 2, '老人机', 3, 'http://101.37.69.49:9000/default/b49b3ee9094d46b08cedb71d4dff60fc.jpg', 3, 1, NULL, NULL);
  INSERT INTO `pms_category` VALUES (30, 2, '拍照手机', 3, 'http://101.37.69.49:9000/default/a49bc9b9bd2f4f3ca7785504b3a7d4b9.jpg', 4, 1, NULL, NULL);
  INSERT INTO `pms_category` VALUES (31, 2, '女性手机', 3, 'http://101.37.69.49:9000/default/06641133b058483498ffa9545ef48cc7.jpg', 5, 1, NULL, NULL);
  INSERT INTO `pms_category` VALUES (32, 25, '选好卡', 3, 'http://101.37.69.49:9000/default/45064f5b8d6149ff914bba384de2e1f8.jpg', 2, 1, NULL, NULL);
  INSERT INTO `pms_category` VALUES (33, 25, '办套餐', 3, 'http://101.37.69.49:9000/default/17487856ba6e4b08abff76af67350f31.jpg', 3, 1, NULL, NULL);
  INSERT INTO `pms_category` VALUES (34, 0, '礼品鲜花', 1, NULL, 2, 1, NULL, NULL);
  INSERT INTO `pms_category` VALUES (35, 34, '礼品', 2, NULL, 1, 1, NULL, NULL);
  INSERT INTO `pms_category` VALUES (36, 34, '鲜花', 2, NULL, 2, 1, NULL, NULL);
  INSERT INTO `pms_category` VALUES (37, 35, '公益摆件', 3, 'http://101.37.69.49:9000/default/751d6ee6b35a455b9c10a4bce4d4819a.jpg', 1, 1, NULL, NULL);
  INSERT INTO `pms_category` VALUES (38, 35, '创意礼品', 3, 'http://101.37.69.49:9000/default/e81d79d5194c455a8c81f56b5d84a4ba.jpg', 2, 1, NULL, NULL);
  INSERT INTO `pms_category` VALUES (39, 36, '鲜花', 3, 'http://101.37.69.49:9000/default/37b979582f9146f5b1bdee099386fa40.jpg', 1, 1, NULL, NULL);
  INSERT INTO `pms_category` VALUES (40, 36, '每周一花', 3, 'http://101.37.69.49:9000/default/0d95d423fba740baaf30560dc9831beb.jpg', 2, 1, NULL, NULL);
  INSERT INTO `pms_category` VALUES (41, 36, '卡通花束', 3, 'http://101.37.69.49:9000/default/04ee2f1e914145fd9f37bd5b0854f0bd.jpg', 3, 1, NULL, NULL);
  INSERT INTO `pms_category` VALUES (42, 36, '永生花', 3, 'http://101.37.69.49:9000/default/9353c6ec84f24939be0633a8ea89a0e9.jpg', 4, 1, NULL, NULL);
  INSERT INTO `pms_category` VALUES (44, 24, '男士T恤', 3, 'http://101.37.69.49:9000/default/0be1041fd35a4b80b2e2eabc56bb7532.jpg', 1, 1, NULL, NULL);
  INSERT INTO `pms_category` VALUES (47, 43, '上装', 3, 'http://101.37.69.49:9000/default/5e8e741773b447b0a6a61f67401f4e24.jpg', 2, 1, NULL, NULL);
  
  -- ----------------------------
  -- Table structure for pms_sku
  -- ----------------------------
  DROP TABLE IF EXISTS `pms_sku`;
  CREATE TABLE `pms_sku`  (
    `id` bigint(0) NOT NULL AUTO_INCREMENT,
    `spu_id` bigint(0) NOT NULL COMMENT '商品id',
    `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'SKU名称',
    `code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'SKU编码',
    `spec_value_ids` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '规格ID集合',
    `pic_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'SKU图片',
    `origin_price` bigint(0) NOT NULL COMMENT '原价',
    `price` bigint(0) NOT NULL COMMENT '现价',
    `stock` int(0) NOT NULL DEFAULT 0 COMMENT '库存',
    `gmt_create` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    `gmt_modified` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE,
    INDEX `fk_pms_sku_pms_spu`(`spu_id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 181 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '商品库存表' ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of pms_sku
  -- ----------------------------
  INSERT INTO `pms_sku` VALUES (1, 45, '古黛妃 短袖t恤女夏装2019新款韩版宽松 粉 M ', '1609327278984', '1609327260839,1609327268527', 'http://101.37.69.49:9000/default/9ce3c8b5415640cea247d53f80d9f35d.jpg', 9900, 19900, 9999, NULL, NULL);
  INSERT INTO `pms_sku` VALUES (152, 45, '古黛妃 短袖t恤女夏装2019新款韩版宽松 粉 L ', '1609327278984', '1609327260839,1609327271672', 'http://101.37.69.49:9000/default/9ce3c8b5415640cea247d53f80d9f35d.jpg', 9900, 19900, 9999, NULL, NULL);
  INSERT INTO `pms_sku` VALUES (153, 45, '古黛妃 短袖t恤女夏装2019新款韩版宽松 粉 XL ', '1609327278985', '1609327260839,1609327275785', 'http://101.37.69.49:9000/default/9ce3c8b5415640cea247d53f80d9f35d.jpg', 9900, 19900, 9999, NULL, NULL);
  INSERT INTO `pms_sku` VALUES (154, 45, '古黛妃 短袖t恤女夏装2019新款韩版宽松 蓝 M ', '1609327278985', '1609327264431,1609327268527', 'http://101.37.69.49:9000/default/9ce3c8b5415640cea247d53f80d9f35d.jpg', 9900, 19900, 9999, NULL, NULL);
  INSERT INTO `pms_sku` VALUES (155, 45, '古黛妃 短袖t恤女夏装2019新款韩版宽松 蓝 L ', '1609327278985', '1609327264431,1609327271672', 'http://101.37.69.49:9000/default/9ce3c8b5415640cea247d53f80d9f35d.jpg', 9900, 19900, 9999, NULL, NULL);
  INSERT INTO `pms_sku` VALUES (156, 45, '古黛妃 短袖t恤女夏装2019新款韩版宽松 蓝 XL ', '1609327278985', '1609327264431,1609327275785', 'http://101.37.69.49:9000/default/9ce3c8b5415640cea247d53f80d9f35d.jpg', 9900, 19900, 9999, NULL, NULL);
  INSERT INTO `pms_sku` VALUES (157, 45, '古黛妃 短袖t恤女夏装2019新款韩版宽松 白 M ', '1609327278985', '1609327268527,1609327278984', 'http://101.37.69.49:9000/default/9ce3c8b5415640cea247d53f80d9f35d.jpg', 9900, 19900, 9999, NULL, NULL);
  INSERT INTO `pms_sku` VALUES (158, 45, '古黛妃 短袖t恤女夏装2019新款韩版宽松 白 L ', '1609327278985', '1609327271672,1609327278984', 'http://101.37.69.49:9000/default/9ce3c8b5415640cea247d53f80d9f35d.jpg', 9900, 19900, 9999, NULL, NULL);
  INSERT INTO `pms_sku` VALUES (159, 45, '古黛妃 短袖t恤女夏装2019新款韩版宽松 白 XL ', '1609327278985', '1609327275785,1609327278984', 'http://101.37.69.49:9000/default/9ce3c8b5415640cea247d53f80d9f35d.jpg', 9900, 19900, 9999, NULL, NULL);
  
  -- ----------------------------
  -- Table structure for pms_spec
  -- ----------------------------
  DROP TABLE IF EXISTS `pms_spec`;
  CREATE TABLE `pms_spec`  (
    `id` bigint(0) NOT NULL AUTO_INCREMENT,
    `category_id` bigint(0) NOT NULL COMMENT '分类id',
    `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '规格名称',
    `gmt_create` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    `gmt_modified` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE,
    INDEX `fk_pms_spec_pms_category`(`category_id`) USING BTREE,
    CONSTRAINT `fk_pms_spec_pms_category` FOREIGN KEY (`category_id`) REFERENCES `pms_category` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
  ) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '商品规格表' ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of pms_spec
  -- ----------------------------
  INSERT INTO `pms_spec` VALUES (1, 2, '颜色', NULL, NULL);
  INSERT INTO `pms_spec` VALUES (2, 2, '版本', NULL, NULL);
  INSERT INTO `pms_spec` VALUES (3, 24, '颜色', NULL, NULL);
  INSERT INTO `pms_spec` VALUES (4, 24, '尺寸', NULL, NULL);
  INSERT INTO `pms_spec` VALUES (6, 47, '颜色', NULL, NULL);
  INSERT INTO `pms_spec` VALUES (7, 47, '尺寸', NULL, NULL);
  INSERT INTO `pms_spec` VALUES (8, 26, '1', NULL, NULL);
  INSERT INTO `pms_spec` VALUES (9, 26, '3', NULL, NULL);
  
  -- ----------------------------
  -- Table structure for pms_spu
  -- ----------------------------
  DROP TABLE IF EXISTS `pms_spu`;
  CREATE TABLE `pms_spu`  (
    `id` bigint(0) NOT NULL AUTO_INCREMENT,
    `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '商品名称',
    `category_id` bigint(0) NOT NULL COMMENT '商品类型id',
    `brand_id` bigint(0) NULL DEFAULT NULL COMMENT '商品品牌id',
    `origin_price` bigint(0) NOT NULL COMMENT '原价',
    `price` bigint(0) NOT NULL COMMENT '现价',
    `sales` int(0) NULL DEFAULT 0 COMMENT '销量',
    `pic_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '商品主图',
    `pic_urls` json NULL COMMENT '商品相册',
    `unit` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '单位',
    `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '商品简介',
    `detail` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '商品详情',
    `status` tinyint(0) NULL DEFAULT NULL COMMENT '商品状态：0-下架 1-上架',
    `gmt_create` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    `gmt_modified` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE,
    INDEX `fk_pms_spu_pms_brand`(`brand_id`) USING BTREE,
    INDEX `fk_pms_spu_pms_category`(`category_id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 49 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '商品表' ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of pms_spu
  -- ----------------------------
  INSERT INTO `pms_spu` VALUES (45, '古黛妃 短袖t恤女夏装2019新款韩版宽松', 47, 3, 9900, 19900, 0, 'http://101.37.69.49:9000/default/9ce3c8b5415640cea247d53f80d9f35d.jpg', '[\"http://101.37.69.49:9000/default/9ce3c8b5415640cea247d53f80d9f35d.jpg\"]', '件', '商品简介', '<p>商品详情</p>', 1, NULL, NULL);
  
  -- ----------------------------
  -- Table structure for pms_spu_attr_value
  -- ----------------------------
  DROP TABLE IF EXISTS `pms_spu_attr_value`;
  CREATE TABLE `pms_spu_attr_value`  (
    `id` bigint(0) NOT NULL AUTO_INCREMENT,
    `spu_id` bigint(0) NOT NULL,
    `attr_id` bigint(0) NULL DEFAULT NULL,
    `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '属性名称(冗余字段)',
    `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '属性值',
    `gmt_create` datetime(0) NULL DEFAULT NULL,
    `gmt_modified` datetime(0) NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE,
    INDEX `fk_pms_spu_attribute_pms_attr`(`name`) USING BTREE,
    INDEX `fk_pms_spu_attribute_pms_spu`(`spu_id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 42 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '商品属性项表' ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of pms_spu_attr_value
  -- ----------------------------
  INSERT INTO `pms_spu_attr_value` VALUES (35, 45, 5, '上市时间', '2020-12-30', NULL, NULL);
  INSERT INTO `pms_spu_attr_value` VALUES (36, 45, 6, '适合季节', '春/秋', NULL, NULL);
  
  -- ----------------------------
  -- Table structure for pms_spu_spec_value
  -- ----------------------------
  DROP TABLE IF EXISTS `pms_spu_spec_value`;
  CREATE TABLE `pms_spu_spec_value`  (
    `id` bigint(0) NOT NULL,
    `spu_id` bigint(0) NULL DEFAULT NULL,
    `spec_id` bigint(0) NULL DEFAULT NULL,
    `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
    `gmt_create` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0),
    `gmt_modified` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0),
    PRIMARY KEY (`id`) USING BTREE,
    INDEX `fk_pms_sku_specification_pms_sku`(`spu_id`) USING BTREE,
    INDEX `fk_pms_sku_specification_pms_specification`(`spec_id`) USING BTREE
  ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '商品规格关联表' ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of pms_spu_spec_value
  -- ----------------------------
  INSERT INTO `pms_spu_spec_value` VALUES (1608802056776, 38, 1, '湖光秋色', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1608802062976, 38, 1, '碧海星辰', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1608802070118, 38, 1, '静默星空', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1608802076696, 38, 2, '6+128G', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1608802116726, 38, 2, '8+128G', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1608802138192, 38, 2, '8+256G', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609000033689, 39, 1, '1', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609000035657, 39, 2, '2', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609000038179, 39, 1, '3', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609000040282, 39, 2, '4', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609000055065, 39, 1, '4', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609000056291, 39, 2, '5', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609000644446, 40, 1, '1', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609000645513, 40, 2, '2', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609000647035, 40, 1, '3', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609000648202, 40, 2, '4', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609000649901, 40, 1, '5', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609000651182, 40, 2, '6', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609042088936, 41, 1, '1', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609042089916, 41, 2, '2', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609042091253, 41, 1, '3', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609042092450, 41, 2, '4', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609042094404, 41, 1, '5', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609042095699, 41, 2, '6', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609042347511, 42, 1, '1', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609042348372, 42, 2, '2', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609042349850, 42, 1, '3', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609042350769, 42, 2, '4', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609042352933, 42, 1, '5', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609042353617, 42, 2, '6', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609042602199, 43, 1, '1', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609042603267, 43, 2, '2', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609042604496, 43, 1, '3', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609042605719, 43, 2, '4', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609043070853, 43, 1, '5', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609069095406, 44, 3, '粉色', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609069098669, 44, 3, '蓝色', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609069102134, 44, 3, '白色', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609069106105, 44, 4, 'M', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609069109683, 44, 4, 'L', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609069113091, 44, 4, 'XL', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609327260839, 45, 6, '粉', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609327264431, 45, 6, '蓝', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609327268527, 45, 7, 'M', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609327271672, 45, 7, 'L', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609327275785, 45, 7, 'XL', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609327278984, 45, 6, '白', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609329141929, 46, 6, '蓝', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609329145746, 46, 7, 'M', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609329150111, 46, 6, '绿', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609329153393, 46, 7, 'L', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609329157057, 46, 7, 'XL', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609465174892, 47, 6, '黄', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609465178593, 47, 6, '蓝', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609465182665, 47, 6, '绿', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609465184422, 47, 7, 'M', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609465189213, 47, 7, 'L', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609465196239, 47, 7, 'XL', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609861048903, 48, 8, '水水水水', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609861053728, 48, 9, '22222', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609861060714, 48, 8, '1111', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609861063662, 48, 8, '3223232', NULL, NULL);
  INSERT INTO `pms_spu_spec_value` VALUES (1609861160023, 48, 9, '112332', NULL, NULL);
  
  -- ----------------------------
  -- Table structure for undo_log
  -- ----------------------------
  DROP TABLE IF EXISTS `undo_log`;
  CREATE TABLE `undo_log`  (
    `branch_id` bigint(0) NOT NULL COMMENT 'branch transaction id',
    `xid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'global transaction id',
    `context` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'undo_log context,such as serialization',
    `rollback_info` longblob NOT NULL COMMENT 'rollback info',
    `log_status` int(0) NOT NULL COMMENT '0:normal status,1:defense status',
    `log_created` datetime(6) NOT NULL COMMENT 'create datetime',
    `log_modified` datetime(6) NOT NULL COMMENT 'modify datetime',
    UNIQUE INDEX `ux_undo_log`(`xid`, `branch_id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'AT transaction mode undo table' ROW_FORMAT = Dynamic;
  
  SET FOREIGN_KEY_CHECKS = 1;
  