From e93eb2a5ac4a0221ea999b04cf7c29957ee07df2 Mon Sep 17 00:00:00 2001
From: puzhibing <393733352@qq.com>
Date: 星期六, 14 二月 2026 01:22:38 +0800
Subject: [PATCH] 提交配置文件

---
 sql/xprt_account.sql |  206 +++++++++++++++++++++++++++++++++++++++-----------
 1 files changed, 159 insertions(+), 47 deletions(-)

diff --git a/sql/xprt_account.sql b/sql/xprt_account.sql
index 3940945..ed0f244 100644
--- a/sql/xprt_account.sql
+++ b/sql/xprt_account.sql
@@ -11,7 +11,7 @@
  Target Server Version : 80019 (8.0.19)
  File Encoding         : 65001
 
- Date: 12/02/2026 14:23:06
+ Date: 14/02/2026 00:59:38
 */
 
 SET NAMES utf8mb4;
@@ -68,12 +68,13 @@
   `create_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建人',
   `update_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '修改人',
   PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '权限组设置' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '权限组设置' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of sys_group
 -- ----------------------------
 INSERT INTO `sys_group` VALUES (1, '超级管理员', '', 1, 0, '2026-02-09 18:12:12', '2026-02-09 18:12:25', '', '');
+INSERT INTO `sys_group` VALUES (4, '管理后台权限', '备注', 1, 0, '2026-02-13 23:13:03', '2026-02-13 23:13:03', '开发', '开发');
 
 -- ----------------------------
 -- Table structure for sys_group_menu
@@ -197,6 +198,30 @@
 INSERT INTO `sys_group_menu` VALUES (1, 216);
 INSERT INTO `sys_group_menu` VALUES (1, 217);
 INSERT INTO `sys_group_menu` VALUES (1, 218);
+INSERT INTO `sys_group_menu` VALUES (4, 101);
+INSERT INTO `sys_group_menu` VALUES (4, 202);
+INSERT INTO `sys_group_menu` VALUES (4, 203);
+INSERT INTO `sys_group_menu` VALUES (4, 402);
+INSERT INTO `sys_group_menu` VALUES (4, 20101);
+INSERT INTO `sys_group_menu` VALUES (4, 20401);
+INSERT INTO `sys_group_menu` VALUES (4, 20402);
+INSERT INTO `sys_group_menu` VALUES (4, 20501);
+INSERT INTO `sys_group_menu` VALUES (4, 30101);
+INSERT INTO `sys_group_menu` VALUES (4, 30102);
+INSERT INTO `sys_group_menu` VALUES (4, 30103);
+INSERT INTO `sys_group_menu` VALUES (4, 30104);
+INSERT INTO `sys_group_menu` VALUES (4, 30105);
+INSERT INTO `sys_group_menu` VALUES (4, 30106);
+INSERT INTO `sys_group_menu` VALUES (4, 30201);
+INSERT INTO `sys_group_menu` VALUES (4, 30202);
+INSERT INTO `sys_group_menu` VALUES (4, 30203);
+INSERT INTO `sys_group_menu` VALUES (4, 30204);
+INSERT INTO `sys_group_menu` VALUES (4, 30301);
+INSERT INTO `sys_group_menu` VALUES (4, 30302);
+INSERT INTO `sys_group_menu` VALUES (4, 30303);
+INSERT INTO `sys_group_menu` VALUES (4, 30304);
+INSERT INTO `sys_group_menu` VALUES (4, 40101);
+INSERT INTO `sys_group_menu` VALUES (4, 40102);
 INSERT INTO `sys_group_menu` VALUES (122, 110);
 INSERT INTO `sys_group_menu` VALUES (122, 111);
 INSERT INTO `sys_group_menu` VALUES (122, 112);
@@ -743,12 +768,14 @@
   `create_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人',
   `update_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '修改人',
   PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 139 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色信息表' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 141 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色信息表' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of sys_role
 -- ----------------------------
 INSERT INTO `sys_role` VALUES (1, 1, '超级管理员', '', 0, '2026-02-09 18:10:58', '2026-02-09 18:10:58', 'admin', 'admin');
+INSERT INTO `sys_role` VALUES (139, 4, '管理员1', '123', 1, '2026-02-13 23:29:05', '2026-02-13 23:29:32', '开发', '开发');
+INSERT INTO `sys_role` VALUES (140, 4, '管理员', '123', 0, '2026-02-13 23:29:41', '2026-02-13 23:29:41', '开发', '开发');
 
 -- ----------------------------
 -- Table structure for sys_role_dept
@@ -787,12 +814,13 @@
   `create_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建人',
   `update_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '修改人',
   PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 949 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户信息表' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 950 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户信息表' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of sys_user
 -- ----------------------------
-INSERT INTO `sys_user` VALUES (948, '开发', '1', 'admin', '18888888888', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '', 0, '备注', 0, '2026-02-09 18:08:42', '2026-02-09 18:08:53', '', '');
+INSERT INTO `sys_user` VALUES (948, '开发', '1', 'admin', '18888888888', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '', 0, '备注', 0, '2026-02-09 18:08:42', '2026-02-14 00:09:05', '', '开发');
+INSERT INTO `sys_user` VALUES (949, '张三', '001', '13350010001', '13350010001', '$2a$10$JtTjRGkjGl6xDWd7Y3NfNuatn25xZetIoHmFkRIuQPu6fqjIsUUsK', '', 0, '', 0, '2026-02-13 23:24:44', '2026-02-14 00:09:16', '开发', '开发');
 
 -- ----------------------------
 -- Table structure for sys_user_post
@@ -1517,6 +1545,8 @@
 INSERT INTO `sys_user_role` VALUES (944, 127);
 INSERT INTO `sys_user_role` VALUES (946, 1);
 INSERT INTO `sys_user_role` VALUES (947, 138);
+INSERT INTO `sys_user_role` VALUES (948, 1);
+INSERT INTO `sys_user_role` VALUES (949, 1);
 
 -- ----------------------------
 -- Table structure for xp_app_user
@@ -1537,7 +1567,7 @@
   PRIMARY KEY (`id`) USING BTREE,
   INDEX `idx_phone`(`phone_number` ASC) USING BTREE COMMENT '手机号',
   INDEX `idx_ctime`(`create_time` ASC) USING BTREE COMMENT '创建时间'
-) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '小程序用户' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '小程序用户' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of xp_app_user
@@ -1836,12 +1866,16 @@
   `full_money` decimal(10, 2) NOT NULL COMMENT '满减金额',
   `money` decimal(10, 2) NOT NULL COMMENT '金额',
   `expiration_time` datetime NOT NULL COMMENT '过期时间',
-  `status` int NOT NULL DEFAULT 1 COMMENT '状态(1=未使用，2=已使用，3=已过期)',
+  `status` int NOT NULL DEFAULT 1 COMMENT '状态(1=未使用，2=已使用，3=已过期  0=待领取)',
   `coupon_type` int NOT NULL DEFAULT 1 COMMENT '优惠券类型(1=抵扣，2=满减)',
   `app_user_id` bigint NOT NULL COMMENT '用户id',
   `coupon_id` bigint NOT NULL COMMENT '优惠券发放id',
   `activity_id` bigint NOT NULL COMMENT '活动id',
+  `use_time` datetime NULL DEFAULT NULL COMMENT '使用时间',
+  `coupon_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '优惠券名称',
   `activity_type` int NOT NULL DEFAULT 1 COMMENT '活动类型(1=注册，2=邀请，3=红包)',
+  `time_json` json NULL COMMENT '使用时间规则',
+  `open_city_id` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开通城市id集合',
   `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
   `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
   `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -1851,7 +1885,7 @@
   INDEX `idx_uid`(`app_user_id` ASC) USING BTREE COMMENT '用户id索引',
   INDEX `idx_cid`(`coupon_id` ASC) USING BTREE COMMENT '优惠券id索引',
   INDEX `idx_aid_atype`(`activity_id` ASC, `activity_type` ASC) USING BTREE COMMENT '活动id类型复合索引'
-) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户优惠券' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户优惠券' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of xp_app_user_coupon_0
@@ -1866,12 +1900,16 @@
   `full_money` decimal(10, 2) NOT NULL COMMENT '满减金额',
   `money` decimal(10, 2) NOT NULL COMMENT '金额',
   `expiration_time` datetime NOT NULL COMMENT '过期时间',
-  `status` int NOT NULL DEFAULT 1 COMMENT '状态(1=未使用，2=已使用，3=已过期)',
+  `status` int NOT NULL DEFAULT 1 COMMENT '状态(1=未使用，2=已使用，3=已过期  0=待领取)',
   `coupon_type` int NOT NULL DEFAULT 1 COMMENT '优惠券类型(1=抵扣，2=满减)',
   `app_user_id` bigint NOT NULL COMMENT '用户id',
   `coupon_id` bigint NOT NULL COMMENT '优惠券发放id',
   `activity_id` bigint NOT NULL COMMENT '活动id',
+  `use_time` datetime NULL DEFAULT NULL COMMENT '使用时间',
+  `coupon_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '优惠券名称',
   `activity_type` int NOT NULL DEFAULT 1 COMMENT '活动类型(1=注册，2=邀请，3=红包)',
+  `time_json` json NULL COMMENT '使用时间规则',
+  `open_city_id` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开通城市id集合',
   `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
   `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
   `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -1881,7 +1919,7 @@
   INDEX `idx_uid`(`app_user_id` ASC) USING BTREE COMMENT '用户id索引',
   INDEX `idx_cid`(`coupon_id` ASC) USING BTREE COMMENT '优惠券id索引',
   INDEX `idx_aid_atype`(`activity_id` ASC, `activity_type` ASC) USING BTREE COMMENT '活动id类型复合索引'
-) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户优惠券' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户优惠券' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of xp_app_user_coupon_1
@@ -1896,12 +1934,16 @@
   `full_money` decimal(10, 2) NOT NULL COMMENT '满减金额',
   `money` decimal(10, 2) NOT NULL COMMENT '金额',
   `expiration_time` datetime NOT NULL COMMENT '过期时间',
-  `status` int NOT NULL DEFAULT 1 COMMENT '状态(1=未使用，2=已使用，3=已过期)',
+  `status` int NOT NULL DEFAULT 1 COMMENT '状态(1=未使用，2=已使用，3=已过期  0=待领取)',
   `coupon_type` int NOT NULL DEFAULT 1 COMMENT '优惠券类型(1=抵扣，2=满减)',
   `app_user_id` bigint NOT NULL COMMENT '用户id',
   `coupon_id` bigint NOT NULL COMMENT '优惠券发放id',
   `activity_id` bigint NOT NULL COMMENT '活动id',
+  `use_time` datetime NULL DEFAULT NULL COMMENT '使用时间',
+  `coupon_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '优惠券名称',
   `activity_type` int NOT NULL DEFAULT 1 COMMENT '活动类型(1=注册，2=邀请，3=红包)',
+  `time_json` json NULL COMMENT '使用时间规则',
+  `open_city_id` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开通城市id集合',
   `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
   `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
   `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -1911,7 +1953,7 @@
   INDEX `idx_uid`(`app_user_id` ASC) USING BTREE COMMENT '用户id索引',
   INDEX `idx_cid`(`coupon_id` ASC) USING BTREE COMMENT '优惠券id索引',
   INDEX `idx_aid_atype`(`activity_id` ASC, `activity_type` ASC) USING BTREE COMMENT '活动id类型复合索引'
-) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户优惠券' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户优惠券' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of xp_app_user_coupon_10
@@ -1926,12 +1968,16 @@
   `full_money` decimal(10, 2) NOT NULL COMMENT '满减金额',
   `money` decimal(10, 2) NOT NULL COMMENT '金额',
   `expiration_time` datetime NOT NULL COMMENT '过期时间',
-  `status` int NOT NULL DEFAULT 1 COMMENT '状态(1=未使用，2=已使用，3=已过期)',
+  `status` int NOT NULL DEFAULT 1 COMMENT '状态(1=未使用，2=已使用，3=已过期  0=待领取)',
   `coupon_type` int NOT NULL DEFAULT 1 COMMENT '优惠券类型(1=抵扣，2=满减)',
   `app_user_id` bigint NOT NULL COMMENT '用户id',
   `coupon_id` bigint NOT NULL COMMENT '优惠券发放id',
   `activity_id` bigint NOT NULL COMMENT '活动id',
+  `use_time` datetime NULL DEFAULT NULL COMMENT '使用时间',
+  `coupon_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '优惠券名称',
   `activity_type` int NOT NULL DEFAULT 1 COMMENT '活动类型(1=注册，2=邀请，3=红包)',
+  `time_json` json NULL COMMENT '使用时间规则',
+  `open_city_id` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开通城市id集合',
   `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
   `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
   `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -1941,7 +1987,7 @@
   INDEX `idx_uid`(`app_user_id` ASC) USING BTREE COMMENT '用户id索引',
   INDEX `idx_cid`(`coupon_id` ASC) USING BTREE COMMENT '优惠券id索引',
   INDEX `idx_aid_atype`(`activity_id` ASC, `activity_type` ASC) USING BTREE COMMENT '活动id类型复合索引'
-) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户优惠券' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户优惠券' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of xp_app_user_coupon_11
@@ -1956,12 +2002,16 @@
   `full_money` decimal(10, 2) NOT NULL COMMENT '满减金额',
   `money` decimal(10, 2) NOT NULL COMMENT '金额',
   `expiration_time` datetime NOT NULL COMMENT '过期时间',
-  `status` int NOT NULL DEFAULT 1 COMMENT '状态(1=未使用，2=已使用，3=已过期)',
+  `status` int NOT NULL DEFAULT 1 COMMENT '状态(1=未使用，2=已使用，3=已过期  0=待领取)',
   `coupon_type` int NOT NULL DEFAULT 1 COMMENT '优惠券类型(1=抵扣，2=满减)',
   `app_user_id` bigint NOT NULL COMMENT '用户id',
   `coupon_id` bigint NOT NULL COMMENT '优惠券发放id',
   `activity_id` bigint NOT NULL COMMENT '活动id',
+  `use_time` datetime NULL DEFAULT NULL COMMENT '使用时间',
+  `coupon_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '优惠券名称',
   `activity_type` int NOT NULL DEFAULT 1 COMMENT '活动类型(1=注册，2=邀请，3=红包)',
+  `time_json` json NULL COMMENT '使用时间规则',
+  `open_city_id` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开通城市id集合',
   `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
   `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
   `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -1971,7 +2021,7 @@
   INDEX `idx_uid`(`app_user_id` ASC) USING BTREE COMMENT '用户id索引',
   INDEX `idx_cid`(`coupon_id` ASC) USING BTREE COMMENT '优惠券id索引',
   INDEX `idx_aid_atype`(`activity_id` ASC, `activity_type` ASC) USING BTREE COMMENT '活动id类型复合索引'
-) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户优惠券' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户优惠券' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of xp_app_user_coupon_12
@@ -1986,12 +2036,16 @@
   `full_money` decimal(10, 2) NOT NULL COMMENT '满减金额',
   `money` decimal(10, 2) NOT NULL COMMENT '金额',
   `expiration_time` datetime NOT NULL COMMENT '过期时间',
-  `status` int NOT NULL DEFAULT 1 COMMENT '状态(1=未使用，2=已使用，3=已过期)',
+  `status` int NOT NULL DEFAULT 1 COMMENT '状态(1=未使用，2=已使用，3=已过期  0=待领取)',
   `coupon_type` int NOT NULL DEFAULT 1 COMMENT '优惠券类型(1=抵扣，2=满减)',
   `app_user_id` bigint NOT NULL COMMENT '用户id',
   `coupon_id` bigint NOT NULL COMMENT '优惠券发放id',
   `activity_id` bigint NOT NULL COMMENT '活动id',
+  `use_time` datetime NULL DEFAULT NULL COMMENT '使用时间',
+  `coupon_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '优惠券名称',
   `activity_type` int NOT NULL DEFAULT 1 COMMENT '活动类型(1=注册，2=邀请，3=红包)',
+  `time_json` json NULL COMMENT '使用时间规则',
+  `open_city_id` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开通城市id集合',
   `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
   `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
   `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -2001,7 +2055,7 @@
   INDEX `idx_uid`(`app_user_id` ASC) USING BTREE COMMENT '用户id索引',
   INDEX `idx_cid`(`coupon_id` ASC) USING BTREE COMMENT '优惠券id索引',
   INDEX `idx_aid_atype`(`activity_id` ASC, `activity_type` ASC) USING BTREE COMMENT '活动id类型复合索引'
-) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户优惠券' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户优惠券' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of xp_app_user_coupon_13
@@ -2016,12 +2070,16 @@
   `full_money` decimal(10, 2) NOT NULL COMMENT '满减金额',
   `money` decimal(10, 2) NOT NULL COMMENT '金额',
   `expiration_time` datetime NOT NULL COMMENT '过期时间',
-  `status` int NOT NULL DEFAULT 1 COMMENT '状态(1=未使用，2=已使用，3=已过期)',
+  `status` int NOT NULL DEFAULT 1 COMMENT '状态(1=未使用，2=已使用，3=已过期  0=待领取)',
   `coupon_type` int NOT NULL DEFAULT 1 COMMENT '优惠券类型(1=抵扣，2=满减)',
   `app_user_id` bigint NOT NULL COMMENT '用户id',
   `coupon_id` bigint NOT NULL COMMENT '优惠券发放id',
   `activity_id` bigint NOT NULL COMMENT '活动id',
+  `use_time` datetime NULL DEFAULT NULL COMMENT '使用时间',
+  `coupon_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '优惠券名称',
   `activity_type` int NOT NULL DEFAULT 1 COMMENT '活动类型(1=注册，2=邀请，3=红包)',
+  `time_json` json NULL COMMENT '使用时间规则',
+  `open_city_id` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开通城市id集合',
   `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
   `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
   `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -2031,7 +2089,7 @@
   INDEX `idx_uid`(`app_user_id` ASC) USING BTREE COMMENT '用户id索引',
   INDEX `idx_cid`(`coupon_id` ASC) USING BTREE COMMENT '优惠券id索引',
   INDEX `idx_aid_atype`(`activity_id` ASC, `activity_type` ASC) USING BTREE COMMENT '活动id类型复合索引'
-) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户优惠券' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户优惠券' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of xp_app_user_coupon_14
@@ -2046,12 +2104,16 @@
   `full_money` decimal(10, 2) NOT NULL COMMENT '满减金额',
   `money` decimal(10, 2) NOT NULL COMMENT '金额',
   `expiration_time` datetime NOT NULL COMMENT '过期时间',
-  `status` int NOT NULL DEFAULT 1 COMMENT '状态(1=未使用，2=已使用，3=已过期)',
+  `status` int NOT NULL DEFAULT 1 COMMENT '状态(1=未使用，2=已使用，3=已过期  0=待领取)',
   `coupon_type` int NOT NULL DEFAULT 1 COMMENT '优惠券类型(1=抵扣，2=满减)',
   `app_user_id` bigint NOT NULL COMMENT '用户id',
   `coupon_id` bigint NOT NULL COMMENT '优惠券发放id',
   `activity_id` bigint NOT NULL COMMENT '活动id',
+  `use_time` datetime NULL DEFAULT NULL COMMENT '使用时间',
+  `coupon_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '优惠券名称',
   `activity_type` int NOT NULL DEFAULT 1 COMMENT '活动类型(1=注册，2=邀请，3=红包)',
+  `time_json` json NULL COMMENT '使用时间规则',
+  `open_city_id` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开通城市id集合',
   `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
   `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
   `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -2061,7 +2123,7 @@
   INDEX `idx_uid`(`app_user_id` ASC) USING BTREE COMMENT '用户id索引',
   INDEX `idx_cid`(`coupon_id` ASC) USING BTREE COMMENT '优惠券id索引',
   INDEX `idx_aid_atype`(`activity_id` ASC, `activity_type` ASC) USING BTREE COMMENT '活动id类型复合索引'
-) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户优惠券' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户优惠券' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of xp_app_user_coupon_15
@@ -2076,12 +2138,16 @@
   `full_money` decimal(10, 2) NOT NULL COMMENT '满减金额',
   `money` decimal(10, 2) NOT NULL COMMENT '金额',
   `expiration_time` datetime NOT NULL COMMENT '过期时间',
-  `status` int NOT NULL DEFAULT 1 COMMENT '状态(1=未使用，2=已使用，3=已过期)',
+  `status` int NOT NULL DEFAULT 1 COMMENT '状态(1=未使用，2=已使用，3=已过期  0=待领取)',
   `coupon_type` int NOT NULL DEFAULT 1 COMMENT '优惠券类型(1=抵扣，2=满减)',
   `app_user_id` bigint NOT NULL COMMENT '用户id',
   `coupon_id` bigint NOT NULL COMMENT '优惠券发放id',
   `activity_id` bigint NOT NULL COMMENT '活动id',
+  `use_time` datetime NULL DEFAULT NULL COMMENT '使用时间',
+  `coupon_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '优惠券名称',
   `activity_type` int NOT NULL DEFAULT 1 COMMENT '活动类型(1=注册，2=邀请，3=红包)',
+  `time_json` json NULL COMMENT '使用时间规则',
+  `open_city_id` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开通城市id集合',
   `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
   `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
   `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -2091,7 +2157,7 @@
   INDEX `idx_uid`(`app_user_id` ASC) USING BTREE COMMENT '用户id索引',
   INDEX `idx_cid`(`coupon_id` ASC) USING BTREE COMMENT '优惠券id索引',
   INDEX `idx_aid_atype`(`activity_id` ASC, `activity_type` ASC) USING BTREE COMMENT '活动id类型复合索引'
-) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户优惠券' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户优惠券' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of xp_app_user_coupon_16
@@ -2106,12 +2172,16 @@
   `full_money` decimal(10, 2) NOT NULL COMMENT '满减金额',
   `money` decimal(10, 2) NOT NULL COMMENT '金额',
   `expiration_time` datetime NOT NULL COMMENT '过期时间',
-  `status` int NOT NULL DEFAULT 1 COMMENT '状态(1=未使用，2=已使用，3=已过期)',
+  `status` int NOT NULL DEFAULT 1 COMMENT '状态(1=未使用，2=已使用，3=已过期  0=待领取)',
   `coupon_type` int NOT NULL DEFAULT 1 COMMENT '优惠券类型(1=抵扣，2=满减)',
   `app_user_id` bigint NOT NULL COMMENT '用户id',
   `coupon_id` bigint NOT NULL COMMENT '优惠券发放id',
   `activity_id` bigint NOT NULL COMMENT '活动id',
+  `use_time` datetime NULL DEFAULT NULL COMMENT '使用时间',
+  `coupon_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '优惠券名称',
   `activity_type` int NOT NULL DEFAULT 1 COMMENT '活动类型(1=注册，2=邀请，3=红包)',
+  `time_json` json NULL COMMENT '使用时间规则',
+  `open_city_id` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开通城市id集合',
   `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
   `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
   `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -2121,7 +2191,7 @@
   INDEX `idx_uid`(`app_user_id` ASC) USING BTREE COMMENT '用户id索引',
   INDEX `idx_cid`(`coupon_id` ASC) USING BTREE COMMENT '优惠券id索引',
   INDEX `idx_aid_atype`(`activity_id` ASC, `activity_type` ASC) USING BTREE COMMENT '活动id类型复合索引'
-) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户优惠券' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户优惠券' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of xp_app_user_coupon_17
@@ -2136,12 +2206,16 @@
   `full_money` decimal(10, 2) NOT NULL COMMENT '满减金额',
   `money` decimal(10, 2) NOT NULL COMMENT '金额',
   `expiration_time` datetime NOT NULL COMMENT '过期时间',
-  `status` int NOT NULL DEFAULT 1 COMMENT '状态(1=未使用，2=已使用，3=已过期)',
+  `status` int NOT NULL DEFAULT 1 COMMENT '状态(1=未使用，2=已使用，3=已过期  0=待领取)',
   `coupon_type` int NOT NULL DEFAULT 1 COMMENT '优惠券类型(1=抵扣，2=满减)',
   `app_user_id` bigint NOT NULL COMMENT '用户id',
   `coupon_id` bigint NOT NULL COMMENT '优惠券发放id',
   `activity_id` bigint NOT NULL COMMENT '活动id',
+  `use_time` datetime NULL DEFAULT NULL COMMENT '使用时间',
+  `coupon_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '优惠券名称',
   `activity_type` int NOT NULL DEFAULT 1 COMMENT '活动类型(1=注册，2=邀请，3=红包)',
+  `time_json` json NULL COMMENT '使用时间规则',
+  `open_city_id` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开通城市id集合',
   `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
   `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
   `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -2151,7 +2225,7 @@
   INDEX `idx_uid`(`app_user_id` ASC) USING BTREE COMMENT '用户id索引',
   INDEX `idx_cid`(`coupon_id` ASC) USING BTREE COMMENT '优惠券id索引',
   INDEX `idx_aid_atype`(`activity_id` ASC, `activity_type` ASC) USING BTREE COMMENT '活动id类型复合索引'
-) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户优惠券' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户优惠券' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of xp_app_user_coupon_18
@@ -2166,12 +2240,16 @@
   `full_money` decimal(10, 2) NOT NULL COMMENT '满减金额',
   `money` decimal(10, 2) NOT NULL COMMENT '金额',
   `expiration_time` datetime NOT NULL COMMENT '过期时间',
-  `status` int NOT NULL DEFAULT 1 COMMENT '状态(1=未使用，2=已使用，3=已过期)',
+  `status` int NOT NULL DEFAULT 1 COMMENT '状态(1=未使用，2=已使用，3=已过期  0=待领取)',
   `coupon_type` int NOT NULL DEFAULT 1 COMMENT '优惠券类型(1=抵扣，2=满减)',
   `app_user_id` bigint NOT NULL COMMENT '用户id',
   `coupon_id` bigint NOT NULL COMMENT '优惠券发放id',
   `activity_id` bigint NOT NULL COMMENT '活动id',
+  `use_time` datetime NULL DEFAULT NULL COMMENT '使用时间',
+  `coupon_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '优惠券名称',
   `activity_type` int NOT NULL DEFAULT 1 COMMENT '活动类型(1=注册，2=邀请，3=红包)',
+  `time_json` json NULL COMMENT '使用时间规则',
+  `open_city_id` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开通城市id集合',
   `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
   `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
   `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -2181,7 +2259,7 @@
   INDEX `idx_uid`(`app_user_id` ASC) USING BTREE COMMENT '用户id索引',
   INDEX `idx_cid`(`coupon_id` ASC) USING BTREE COMMENT '优惠券id索引',
   INDEX `idx_aid_atype`(`activity_id` ASC, `activity_type` ASC) USING BTREE COMMENT '活动id类型复合索引'
-) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户优惠券' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户优惠券' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of xp_app_user_coupon_19
@@ -2196,12 +2274,16 @@
   `full_money` decimal(10, 2) NOT NULL COMMENT '满减金额',
   `money` decimal(10, 2) NOT NULL COMMENT '金额',
   `expiration_time` datetime NOT NULL COMMENT '过期时间',
-  `status` int NOT NULL DEFAULT 1 COMMENT '状态(1=未使用，2=已使用，3=已过期)',
+  `status` int NOT NULL DEFAULT 1 COMMENT '状态(1=未使用，2=已使用，3=已过期  0=待领取)',
   `coupon_type` int NOT NULL DEFAULT 1 COMMENT '优惠券类型(1=抵扣，2=满减)',
   `app_user_id` bigint NOT NULL COMMENT '用户id',
   `coupon_id` bigint NOT NULL COMMENT '优惠券发放id',
   `activity_id` bigint NOT NULL COMMENT '活动id',
+  `use_time` datetime NULL DEFAULT NULL COMMENT '使用时间',
+  `coupon_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '优惠券名称',
   `activity_type` int NOT NULL DEFAULT 1 COMMENT '活动类型(1=注册，2=邀请，3=红包)',
+  `time_json` json NULL COMMENT '使用时间规则',
+  `open_city_id` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开通城市id集合',
   `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
   `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
   `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -2211,7 +2293,7 @@
   INDEX `idx_uid`(`app_user_id` ASC) USING BTREE COMMENT '用户id索引',
   INDEX `idx_cid`(`coupon_id` ASC) USING BTREE COMMENT '优惠券id索引',
   INDEX `idx_aid_atype`(`activity_id` ASC, `activity_type` ASC) USING BTREE COMMENT '活动id类型复合索引'
-) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户优惠券' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户优惠券' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of xp_app_user_coupon_2
@@ -2226,12 +2308,16 @@
   `full_money` decimal(10, 2) NOT NULL COMMENT '满减金额',
   `money` decimal(10, 2) NOT NULL COMMENT '金额',
   `expiration_time` datetime NOT NULL COMMENT '过期时间',
-  `status` int NOT NULL DEFAULT 1 COMMENT '状态(1=未使用，2=已使用，3=已过期)',
+  `status` int NOT NULL DEFAULT 1 COMMENT '状态(1=未使用，2=已使用，3=已过期  0=待领取)',
   `coupon_type` int NOT NULL DEFAULT 1 COMMENT '优惠券类型(1=抵扣，2=满减)',
   `app_user_id` bigint NOT NULL COMMENT '用户id',
   `coupon_id` bigint NOT NULL COMMENT '优惠券发放id',
   `activity_id` bigint NOT NULL COMMENT '活动id',
+  `use_time` datetime NULL DEFAULT NULL COMMENT '使用时间',
+  `coupon_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '优惠券名称',
   `activity_type` int NOT NULL DEFAULT 1 COMMENT '活动类型(1=注册，2=邀请，3=红包)',
+  `time_json` json NULL COMMENT '使用时间规则',
+  `open_city_id` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开通城市id集合',
   `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
   `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
   `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -2241,7 +2327,7 @@
   INDEX `idx_uid`(`app_user_id` ASC) USING BTREE COMMENT '用户id索引',
   INDEX `idx_cid`(`coupon_id` ASC) USING BTREE COMMENT '优惠券id索引',
   INDEX `idx_aid_atype`(`activity_id` ASC, `activity_type` ASC) USING BTREE COMMENT '活动id类型复合索引'
-) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户优惠券' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户优惠券' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of xp_app_user_coupon_3
@@ -2256,12 +2342,16 @@
   `full_money` decimal(10, 2) NOT NULL COMMENT '满减金额',
   `money` decimal(10, 2) NOT NULL COMMENT '金额',
   `expiration_time` datetime NOT NULL COMMENT '过期时间',
-  `status` int NOT NULL DEFAULT 1 COMMENT '状态(1=未使用，2=已使用，3=已过期)',
+  `status` int NOT NULL DEFAULT 1 COMMENT '状态(1=未使用，2=已使用，3=已过期  0=待领取)',
   `coupon_type` int NOT NULL DEFAULT 1 COMMENT '优惠券类型(1=抵扣，2=满减)',
   `app_user_id` bigint NOT NULL COMMENT '用户id',
   `coupon_id` bigint NOT NULL COMMENT '优惠券发放id',
   `activity_id` bigint NOT NULL COMMENT '活动id',
+  `use_time` datetime NULL DEFAULT NULL COMMENT '使用时间',
+  `coupon_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '优惠券名称',
   `activity_type` int NOT NULL DEFAULT 1 COMMENT '活动类型(1=注册，2=邀请，3=红包)',
+  `time_json` json NULL COMMENT '使用时间规则',
+  `open_city_id` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开通城市id集合',
   `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
   `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
   `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -2271,7 +2361,7 @@
   INDEX `idx_uid`(`app_user_id` ASC) USING BTREE COMMENT '用户id索引',
   INDEX `idx_cid`(`coupon_id` ASC) USING BTREE COMMENT '优惠券id索引',
   INDEX `idx_aid_atype`(`activity_id` ASC, `activity_type` ASC) USING BTREE COMMENT '活动id类型复合索引'
-) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户优惠券' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户优惠券' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of xp_app_user_coupon_4
@@ -2286,12 +2376,16 @@
   `full_money` decimal(10, 2) NOT NULL COMMENT '满减金额',
   `money` decimal(10, 2) NOT NULL COMMENT '金额',
   `expiration_time` datetime NOT NULL COMMENT '过期时间',
-  `status` int NOT NULL DEFAULT 1 COMMENT '状态(1=未使用，2=已使用，3=已过期)',
+  `status` int NOT NULL DEFAULT 1 COMMENT '状态(1=未使用，2=已使用，3=已过期  0=待领取)',
   `coupon_type` int NOT NULL DEFAULT 1 COMMENT '优惠券类型(1=抵扣，2=满减)',
   `app_user_id` bigint NOT NULL COMMENT '用户id',
   `coupon_id` bigint NOT NULL COMMENT '优惠券发放id',
   `activity_id` bigint NOT NULL COMMENT '活动id',
+  `use_time` datetime NULL DEFAULT NULL COMMENT '使用时间',
+  `coupon_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '优惠券名称',
   `activity_type` int NOT NULL DEFAULT 1 COMMENT '活动类型(1=注册，2=邀请，3=红包)',
+  `time_json` json NULL COMMENT '使用时间规则',
+  `open_city_id` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开通城市id集合',
   `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
   `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
   `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -2301,7 +2395,7 @@
   INDEX `idx_uid`(`app_user_id` ASC) USING BTREE COMMENT '用户id索引',
   INDEX `idx_cid`(`coupon_id` ASC) USING BTREE COMMENT '优惠券id索引',
   INDEX `idx_aid_atype`(`activity_id` ASC, `activity_type` ASC) USING BTREE COMMENT '活动id类型复合索引'
-) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户优惠券' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户优惠券' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of xp_app_user_coupon_5
@@ -2316,12 +2410,16 @@
   `full_money` decimal(10, 2) NOT NULL COMMENT '满减金额',
   `money` decimal(10, 2) NOT NULL COMMENT '金额',
   `expiration_time` datetime NOT NULL COMMENT '过期时间',
-  `status` int NOT NULL DEFAULT 1 COMMENT '状态(1=未使用，2=已使用，3=已过期)',
+  `status` int NOT NULL DEFAULT 1 COMMENT '状态(1=未使用，2=已使用，3=已过期  0=待领取)',
   `coupon_type` int NOT NULL DEFAULT 1 COMMENT '优惠券类型(1=抵扣，2=满减)',
   `app_user_id` bigint NOT NULL COMMENT '用户id',
   `coupon_id` bigint NOT NULL COMMENT '优惠券发放id',
   `activity_id` bigint NOT NULL COMMENT '活动id',
+  `use_time` datetime NULL DEFAULT NULL COMMENT '使用时间',
+  `coupon_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '优惠券名称',
   `activity_type` int NOT NULL DEFAULT 1 COMMENT '活动类型(1=注册，2=邀请，3=红包)',
+  `time_json` json NULL COMMENT '使用时间规则',
+  `open_city_id` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开通城市id集合',
   `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
   `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
   `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -2331,7 +2429,7 @@
   INDEX `idx_uid`(`app_user_id` ASC) USING BTREE COMMENT '用户id索引',
   INDEX `idx_cid`(`coupon_id` ASC) USING BTREE COMMENT '优惠券id索引',
   INDEX `idx_aid_atype`(`activity_id` ASC, `activity_type` ASC) USING BTREE COMMENT '活动id类型复合索引'
-) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户优惠券' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户优惠券' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of xp_app_user_coupon_6
@@ -2346,12 +2444,16 @@
   `full_money` decimal(10, 2) NOT NULL COMMENT '满减金额',
   `money` decimal(10, 2) NOT NULL COMMENT '金额',
   `expiration_time` datetime NOT NULL COMMENT '过期时间',
-  `status` int NOT NULL DEFAULT 1 COMMENT '状态(1=未使用，2=已使用，3=已过期)',
+  `status` int NOT NULL DEFAULT 1 COMMENT '状态(1=未使用，2=已使用，3=已过期  0=待领取)',
   `coupon_type` int NOT NULL DEFAULT 1 COMMENT '优惠券类型(1=抵扣，2=满减)',
   `app_user_id` bigint NOT NULL COMMENT '用户id',
   `coupon_id` bigint NOT NULL COMMENT '优惠券发放id',
   `activity_id` bigint NOT NULL COMMENT '活动id',
+  `use_time` datetime NULL DEFAULT NULL COMMENT '使用时间',
+  `coupon_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '优惠券名称',
   `activity_type` int NOT NULL DEFAULT 1 COMMENT '活动类型(1=注册，2=邀请，3=红包)',
+  `time_json` json NULL COMMENT '使用时间规则',
+  `open_city_id` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开通城市id集合',
   `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
   `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
   `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -2361,7 +2463,7 @@
   INDEX `idx_uid`(`app_user_id` ASC) USING BTREE COMMENT '用户id索引',
   INDEX `idx_cid`(`coupon_id` ASC) USING BTREE COMMENT '优惠券id索引',
   INDEX `idx_aid_atype`(`activity_id` ASC, `activity_type` ASC) USING BTREE COMMENT '活动id类型复合索引'
-) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户优惠券' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户优惠券' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of xp_app_user_coupon_7
@@ -2376,12 +2478,16 @@
   `full_money` decimal(10, 2) NOT NULL COMMENT '满减金额',
   `money` decimal(10, 2) NOT NULL COMMENT '金额',
   `expiration_time` datetime NOT NULL COMMENT '过期时间',
-  `status` int NOT NULL DEFAULT 1 COMMENT '状态(1=未使用，2=已使用，3=已过期)',
+  `status` int NOT NULL DEFAULT 1 COMMENT '状态(1=未使用，2=已使用，3=已过期  0=待领取)',
   `coupon_type` int NOT NULL DEFAULT 1 COMMENT '优惠券类型(1=抵扣，2=满减)',
   `app_user_id` bigint NOT NULL COMMENT '用户id',
   `coupon_id` bigint NOT NULL COMMENT '优惠券发放id',
   `activity_id` bigint NOT NULL COMMENT '活动id',
+  `use_time` datetime NULL DEFAULT NULL COMMENT '使用时间',
+  `coupon_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '优惠券名称',
   `activity_type` int NOT NULL DEFAULT 1 COMMENT '活动类型(1=注册，2=邀请，3=红包)',
+  `time_json` json NULL COMMENT '使用时间规则',
+  `open_city_id` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开通城市id集合',
   `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
   `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
   `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -2391,7 +2497,7 @@
   INDEX `idx_uid`(`app_user_id` ASC) USING BTREE COMMENT '用户id索引',
   INDEX `idx_cid`(`coupon_id` ASC) USING BTREE COMMENT '优惠券id索引',
   INDEX `idx_aid_atype`(`activity_id` ASC, `activity_type` ASC) USING BTREE COMMENT '活动id类型复合索引'
-) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户优惠券' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户优惠券' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of xp_app_user_coupon_8
@@ -2406,12 +2512,16 @@
   `full_money` decimal(10, 2) NOT NULL COMMENT '满减金额',
   `money` decimal(10, 2) NOT NULL COMMENT '金额',
   `expiration_time` datetime NOT NULL COMMENT '过期时间',
-  `status` int NOT NULL DEFAULT 1 COMMENT '状态(1=未使用，2=已使用，3=已过期)',
+  `status` int NOT NULL DEFAULT 1 COMMENT '状态(1=未使用，2=已使用，3=已过期  0=待领取)',
   `coupon_type` int NOT NULL DEFAULT 1 COMMENT '优惠券类型(1=抵扣，2=满减)',
   `app_user_id` bigint NOT NULL COMMENT '用户id',
   `coupon_id` bigint NOT NULL COMMENT '优惠券发放id',
   `activity_id` bigint NOT NULL COMMENT '活动id',
+  `use_time` datetime NULL DEFAULT NULL COMMENT '使用时间',
+  `coupon_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '优惠券名称',
   `activity_type` int NOT NULL DEFAULT 1 COMMENT '活动类型(1=注册，2=邀请，3=红包)',
+  `time_json` json NULL COMMENT '使用时间规则',
+  `open_city_id` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开通城市id集合',
   `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
   `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
   `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -2421,7 +2531,7 @@
   INDEX `idx_uid`(`app_user_id` ASC) USING BTREE COMMENT '用户id索引',
   INDEX `idx_cid`(`coupon_id` ASC) USING BTREE COMMENT '优惠券id索引',
   INDEX `idx_aid_atype`(`activity_id` ASC, `activity_type` ASC) USING BTREE COMMENT '活动id类型复合索引'
-) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户优惠券' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户优惠券' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of xp_app_user_coupon_9
@@ -2479,11 +2589,13 @@
   `create_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建人',
   `update_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '修改人',
   PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '运维人员' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '运维人员' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of xp_operations_user
 -- ----------------------------
+INSERT INTO `xp_operations_user` VALUES (1, '张三', '7355608', '{\"id\":\"1\",\"name\":\"头像.jpg\",\"url\":\"\nhttps://pss.bdstatic.com/static/superman/img/topnav/newfanyi-da0cea8f7e.png\"}', '123456', '1888888888', '备注', 1, NULL, NULL, NULL, NULL, NULL, 0, '2026-02-13 14:21:34', '2026-02-13 14:23:13', '', '');
+INSERT INTO `xp_operations_user` VALUES (2, '李四', '7355609', '{\"id\":\"1\",\"name\":\"头像.jpg\",\"url\":\"\nhttps://pss.bdstatic.com/static/superman/img/topnav/newfanyi-da0cea8f7e.png\"}', '123456', '1888888889', '备注', 1, NULL, NULL, NULL, NULL, NULL, 0, '2026-02-13 14:23:14', '2026-02-13 14:23:38', '', '');
 
 -- ----------------------------
 -- Table structure for xp_operations_user_notification

--
Gitblit v1.7.1