/* Navicat Premium Dump SQL Source Server : 陈坤本地 Source Server Type : MySQL Source Server Version : 80019 (8.0.19) Source Host : 192.168.110.34:3306 Source Schema : xprt_account Target Server Type : MySQL Target Server Version : 80019 (8.0.19) File Encoding : 65001 Date: 26/02/2026 16:56:02 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for sys_dept -- ---------------------------- DROP TABLE IF EXISTS `sys_dept`; CREATE TABLE `sys_dept` ( `dept_id` bigint NOT NULL AUTO_INCREMENT COMMENT '部门id', `parent_id` bigint NULL DEFAULT 0 COMMENT '父部门id', `ancestors` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '祖级列表', `dept_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '部门名称', `order_num` int NULL DEFAULT 0 COMMENT '显示顺序', `leader` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '负责人', `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系电话', `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邮箱', `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '部门状态（0正常 1停用）', `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）', `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`dept_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 110 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '部门表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of sys_dept -- ---------------------------- INSERT INTO `sys_dept` VALUES (100, 0, '0', '小鹏科技', 0, '小鹏', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2023-10-02 14:09:09', '', NULL); INSERT INTO `sys_dept` VALUES (101, 100, '0,100', '深圳总公司', 1, '小鹏', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2023-10-02 14:09:09', '', NULL); INSERT INTO `sys_dept` VALUES (102, 100, '0,100', '长沙分公司', 2, '小鹏', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2023-10-02 14:09:09', '', NULL); INSERT INTO `sys_dept` VALUES (103, 101, '0,100,101', '研发部门', 1, '小鹏', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2023-10-02 14:09:09', '', NULL); INSERT INTO `sys_dept` VALUES (104, 101, '0,100,101', '市场部门', 2, '小鹏', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2023-10-02 14:09:09', '', NULL); INSERT INTO `sys_dept` VALUES (105, 101, '0,100,101', '测试部门', 3, '小鹏', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2023-10-02 14:09:09', '', NULL); INSERT INTO `sys_dept` VALUES (106, 101, '0,100,101', '财务部门', 4, '小鹏', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2023-10-02 14:09:09', '', NULL); INSERT INTO `sys_dept` VALUES (107, 101, '0,100,101', '运维部门', 5, '小鹏', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2023-10-02 14:09:09', '', NULL); INSERT INTO `sys_dept` VALUES (108, 102, '0,100,102', '市场部门', 1, '小鹏', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2023-10-02 14:09:09', '', NULL); INSERT INTO `sys_dept` VALUES (109, 102, '0,100,102', '财务部门', 2, '小鹏', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2023-10-02 14:09:09', '', NULL); -- ---------------------------- -- Table structure for sys_group -- ---------------------------- DROP TABLE IF EXISTS `sys_group`; CREATE TABLE `sys_group` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id', `group_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '组名称', `remarks` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '备注', `group_type` int NULL DEFAULT 1 COMMENT '分组类型 1=管理端 2=运维app', `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 '修改时间', `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 = 7 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-26 09:11:08', '', '开发'); INSERT INTO `sys_group` VALUES (4, '管理后台权限', '备注', 1, 0, '2026-02-13 23:13:03', '2026-02-13 23:13:03', '开发', '开发'); INSERT INTO `sys_group` VALUES (5, '管理员', '管理员权限', 1, 0, '2026-02-14 17:57:38', '2026-02-14 17:58:21', '开发', '开发'); INSERT INTO `sys_group` VALUES (6, '管理后台权限管理', '备注必填', 1, 0, '2026-02-25 14:21:41', '2026-02-25 14:21:41', '开发', '开发'); -- ---------------------------- -- Table structure for sys_group_menu -- ---------------------------- DROP TABLE IF EXISTS `sys_group_menu`; CREATE TABLE `sys_group_menu` ( `group_id` bigint NOT NULL COMMENT '权限组ID', `menu_id` bigint NOT NULL COMMENT '菜单ID', PRIMARY KEY (`group_id`, `menu_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色和菜单关联表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of sys_group_menu -- ---------------------------- INSERT INTO `sys_group_menu` VALUES (1, 1); INSERT INTO `sys_group_menu` VALUES (1, 402); INSERT INTO `sys_group_menu` VALUES (1, 403); INSERT INTO `sys_group_menu` VALUES (1, 404); INSERT INTO `sys_group_menu` VALUES (1, 405); INSERT INTO `sys_group_menu` VALUES (1, 406); INSERT INTO `sys_group_menu` VALUES (1, 2013); INSERT INTO `sys_group_menu` VALUES (1, 2015); INSERT INTO `sys_group_menu` VALUES (1, 2031); INSERT INTO `sys_group_menu` VALUES (1, 4011); INSERT INTO `sys_group_menu` VALUES (1, 4012); INSERT INTO `sys_group_menu` VALUES (1, 4013); INSERT INTO `sys_group_menu` VALUES (1, 4014); INSERT INTO `sys_group_menu` VALUES (1, 5022); INSERT INTO `sys_group_menu` VALUES (1, 5023); INSERT INTO `sys_group_menu` VALUES (1, 5024); INSERT INTO `sys_group_menu` VALUES (1, 5031); INSERT INTO `sys_group_menu` VALUES (1, 6013); INSERT INTO `sys_group_menu` VALUES (1, 6021); INSERT INTO `sys_group_menu` VALUES (1, 6022); INSERT INTO `sys_group_menu` VALUES (1, 6023); INSERT INTO `sys_group_menu` VALUES (1, 6024); INSERT INTO `sys_group_menu` VALUES (1, 6025); INSERT INTO `sys_group_menu` VALUES (1, 6026); INSERT INTO `sys_group_menu` VALUES (1, 6051); INSERT INTO `sys_group_menu` VALUES (1, 6061); INSERT INTO `sys_group_menu` VALUES (1, 6062); INSERT INTO `sys_group_menu` VALUES (1, 6063); INSERT INTO `sys_group_menu` VALUES (1, 7041); INSERT INTO `sys_group_menu` VALUES (1, 8021); INSERT INTO `sys_group_menu` VALUES (1, 20111); INSERT INTO `sys_group_menu` VALUES (1, 20112); INSERT INTO `sys_group_menu` VALUES (1, 20113); INSERT INTO `sys_group_menu` VALUES (1, 20114); INSERT INTO `sys_group_menu` VALUES (1, 20115); INSERT INTO `sys_group_menu` VALUES (1, 20131); INSERT INTO `sys_group_menu` VALUES (1, 20132); INSERT INTO `sys_group_menu` VALUES (1, 20133); INSERT INTO `sys_group_menu` VALUES (1, 20134); INSERT INTO `sys_group_menu` VALUES (1, 20151); INSERT INTO `sys_group_menu` VALUES (1, 20152); INSERT INTO `sys_group_menu` VALUES (1, 20153); INSERT INTO `sys_group_menu` VALUES (1, 20154); INSERT INTO `sys_group_menu` VALUES (1, 20211); INSERT INTO `sys_group_menu` VALUES (1, 20221); INSERT INTO `sys_group_menu` VALUES (1, 20222); INSERT INTO `sys_group_menu` VALUES (1, 30111); INSERT INTO `sys_group_menu` VALUES (1, 30112); INSERT INTO `sys_group_menu` VALUES (1, 30113); INSERT INTO `sys_group_menu` VALUES (1, 30114); INSERT INTO `sys_group_menu` VALUES (1, 30115); INSERT INTO `sys_group_menu` VALUES (1, 30121); INSERT INTO `sys_group_menu` VALUES (1, 30122); INSERT INTO `sys_group_menu` VALUES (1, 30123); INSERT INTO `sys_group_menu` VALUES (1, 30124); INSERT INTO `sys_group_menu` VALUES (1, 30125); INSERT INTO `sys_group_menu` VALUES (1, 30126); INSERT INTO `sys_group_menu` VALUES (1, 30127); INSERT INTO `sys_group_menu` VALUES (1, 30131); INSERT INTO `sys_group_menu` VALUES (1, 30211); INSERT INTO `sys_group_menu` VALUES (1, 30221); INSERT INTO `sys_group_menu` VALUES (1, 30222); INSERT INTO `sys_group_menu` VALUES (1, 30223); INSERT INTO `sys_group_menu` VALUES (1, 30224); INSERT INTO `sys_group_menu` VALUES (1, 30225); INSERT INTO `sys_group_menu` VALUES (1, 30232); INSERT INTO `sys_group_menu` VALUES (1, 40711); INSERT INTO `sys_group_menu` VALUES (1, 50112); INSERT INTO `sys_group_menu` VALUES (1, 50113); INSERT INTO `sys_group_menu` VALUES (1, 50114); INSERT INTO `sys_group_menu` VALUES (1, 50115); INSERT INTO `sys_group_menu` VALUES (1, 50116); INSERT INTO `sys_group_menu` VALUES (1, 50117); INSERT INTO `sys_group_menu` VALUES (1, 50118); INSERT INTO `sys_group_menu` VALUES (1, 50119); INSERT INTO `sys_group_menu` VALUES (1, 50120); INSERT INTO `sys_group_menu` VALUES (1, 50121); INSERT INTO `sys_group_menu` VALUES (1, 50132); INSERT INTO `sys_group_menu` VALUES (1, 50133); INSERT INTO `sys_group_menu` VALUES (1, 50134); INSERT INTO `sys_group_menu` VALUES (1, 60112); INSERT INTO `sys_group_menu` VALUES (1, 60113); INSERT INTO `sys_group_menu` VALUES (1, 60114); INSERT INTO `sys_group_menu` VALUES (1, 60115); INSERT INTO `sys_group_menu` VALUES (1, 60116); INSERT INTO `sys_group_menu` VALUES (1, 60117); INSERT INTO `sys_group_menu` VALUES (1, 70112); INSERT INTO `sys_group_menu` VALUES (1, 70113); INSERT INTO `sys_group_menu` VALUES (1, 70114); INSERT INTO `sys_group_menu` VALUES (1, 70115); INSERT INTO `sys_group_menu` VALUES (1, 70116); INSERT INTO `sys_group_menu` VALUES (1, 70117); INSERT INTO `sys_group_menu` VALUES (1, 70118); INSERT INTO `sys_group_menu` VALUES (1, 70211); INSERT INTO `sys_group_menu` VALUES (1, 70212); INSERT INTO `sys_group_menu` VALUES (1, 70213); INSERT INTO `sys_group_menu` VALUES (1, 70221); INSERT INTO `sys_group_menu` VALUES (1, 70241); INSERT INTO `sys_group_menu` VALUES (1, 70242); INSERT INTO `sys_group_menu` VALUES (1, 70243); INSERT INTO `sys_group_menu` VALUES (1, 70253); INSERT INTO `sys_group_menu` VALUES (1, 80111); INSERT INTO `sys_group_menu` VALUES (1, 80112); INSERT INTO `sys_group_menu` VALUES (1, 80113); INSERT INTO `sys_group_menu` VALUES (1, 80121); INSERT INTO `sys_group_menu` VALUES (1, 80122); 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 (5, 2); INSERT INTO `sys_group_menu` VALUES (5, 3); INSERT INTO `sys_group_menu` VALUES (5, 4); INSERT INTO `sys_group_menu` VALUES (5, 201); INSERT INTO `sys_group_menu` VALUES (5, 202); INSERT INTO `sys_group_menu` VALUES (5, 203); INSERT INTO `sys_group_menu` VALUES (5, 301); INSERT INTO `sys_group_menu` VALUES (5, 302); INSERT INTO `sys_group_menu` VALUES (5, 401); INSERT INTO `sys_group_menu` VALUES (5, 402); INSERT INTO `sys_group_menu` VALUES (5, 403); INSERT INTO `sys_group_menu` VALUES (5, 404); INSERT INTO `sys_group_menu` VALUES (5, 405); INSERT INTO `sys_group_menu` VALUES (5, 406); INSERT INTO `sys_group_menu` VALUES (5, 407); INSERT INTO `sys_group_menu` VALUES (5, 2011); INSERT INTO `sys_group_menu` VALUES (5, 2012); INSERT INTO `sys_group_menu` VALUES (5, 2013); INSERT INTO `sys_group_menu` VALUES (5, 2014); INSERT INTO `sys_group_menu` VALUES (5, 2015); INSERT INTO `sys_group_menu` VALUES (5, 2021); INSERT INTO `sys_group_menu` VALUES (5, 3011); INSERT INTO `sys_group_menu` VALUES (5, 3012); INSERT INTO `sys_group_menu` VALUES (5, 3013); INSERT INTO `sys_group_menu` VALUES (5, 3021); INSERT INTO `sys_group_menu` VALUES (5, 3022); INSERT INTO `sys_group_menu` VALUES (5, 4071); INSERT INTO `sys_group_menu` VALUES (5, 4072); INSERT INTO `sys_group_menu` VALUES (5, 4073); INSERT INTO `sys_group_menu` VALUES (5, 4074); INSERT INTO `sys_group_menu` VALUES (6, 2); INSERT INTO `sys_group_menu` VALUES (6, 3); INSERT INTO `sys_group_menu` VALUES (6, 4); INSERT INTO `sys_group_menu` VALUES (6, 5); INSERT INTO `sys_group_menu` VALUES (6, 6); INSERT INTO `sys_group_menu` VALUES (6, 201); INSERT INTO `sys_group_menu` VALUES (6, 202); INSERT INTO `sys_group_menu` VALUES (6, 203); INSERT INTO `sys_group_menu` VALUES (6, 301); INSERT INTO `sys_group_menu` VALUES (6, 302); INSERT INTO `sys_group_menu` VALUES (6, 401); INSERT INTO `sys_group_menu` VALUES (6, 402); INSERT INTO `sys_group_menu` VALUES (6, 403); INSERT INTO `sys_group_menu` VALUES (6, 404); INSERT INTO `sys_group_menu` VALUES (6, 405); INSERT INTO `sys_group_menu` VALUES (6, 406); INSERT INTO `sys_group_menu` VALUES (6, 407); INSERT INTO `sys_group_menu` VALUES (6, 501); INSERT INTO `sys_group_menu` VALUES (6, 502); INSERT INTO `sys_group_menu` VALUES (6, 503); INSERT INTO `sys_group_menu` VALUES (6, 601); INSERT INTO `sys_group_menu` VALUES (6, 602); INSERT INTO `sys_group_menu` VALUES (6, 605); INSERT INTO `sys_group_menu` VALUES (6, 606); INSERT INTO `sys_group_menu` VALUES (6, 2011); INSERT INTO `sys_group_menu` VALUES (6, 2012); INSERT INTO `sys_group_menu` VALUES (6, 2013); INSERT INTO `sys_group_menu` VALUES (6, 2014); INSERT INTO `sys_group_menu` VALUES (6, 2015); INSERT INTO `sys_group_menu` VALUES (6, 2021); INSERT INTO `sys_group_menu` VALUES (6, 2022); INSERT INTO `sys_group_menu` VALUES (6, 2031); INSERT INTO `sys_group_menu` VALUES (6, 3011); INSERT INTO `sys_group_menu` VALUES (6, 3012); INSERT INTO `sys_group_menu` VALUES (6, 3013); INSERT INTO `sys_group_menu` VALUES (6, 3021); INSERT INTO `sys_group_menu` VALUES (6, 3022); INSERT INTO `sys_group_menu` VALUES (6, 3023); INSERT INTO `sys_group_menu` VALUES (6, 4011); INSERT INTO `sys_group_menu` VALUES (6, 4012); INSERT INTO `sys_group_menu` VALUES (6, 4013); INSERT INTO `sys_group_menu` VALUES (6, 4014); INSERT INTO `sys_group_menu` VALUES (6, 4071); INSERT INTO `sys_group_menu` VALUES (6, 5011); INSERT INTO `sys_group_menu` VALUES (6, 5013); INSERT INTO `sys_group_menu` VALUES (6, 5022); INSERT INTO `sys_group_menu` VALUES (6, 5023); INSERT INTO `sys_group_menu` VALUES (6, 5024); INSERT INTO `sys_group_menu` VALUES (6, 5031); INSERT INTO `sys_group_menu` VALUES (6, 6011); INSERT INTO `sys_group_menu` VALUES (6, 6013); INSERT INTO `sys_group_menu` VALUES (6, 6023); INSERT INTO `sys_group_menu` VALUES (6, 6024); INSERT INTO `sys_group_menu` VALUES (6, 6025); INSERT INTO `sys_group_menu` VALUES (6, 6026); INSERT INTO `sys_group_menu` VALUES (6, 6051); INSERT INTO `sys_group_menu` VALUES (6, 6061); INSERT INTO `sys_group_menu` VALUES (6, 6062); INSERT INTO `sys_group_menu` VALUES (6, 6063); INSERT INTO `sys_group_menu` VALUES (6, 20111); INSERT INTO `sys_group_menu` VALUES (6, 20112); INSERT INTO `sys_group_menu` VALUES (6, 20113); INSERT INTO `sys_group_menu` VALUES (6, 20114); INSERT INTO `sys_group_menu` VALUES (6, 20115); INSERT INTO `sys_group_menu` VALUES (6, 20131); INSERT INTO `sys_group_menu` VALUES (6, 20132); INSERT INTO `sys_group_menu` VALUES (6, 20133); INSERT INTO `sys_group_menu` VALUES (6, 20134); INSERT INTO `sys_group_menu` VALUES (6, 20151); INSERT INTO `sys_group_menu` VALUES (6, 20152); INSERT INTO `sys_group_menu` VALUES (6, 20153); INSERT INTO `sys_group_menu` VALUES (6, 20154); INSERT INTO `sys_group_menu` VALUES (6, 20211); INSERT INTO `sys_group_menu` VALUES (6, 20221); INSERT INTO `sys_group_menu` VALUES (6, 20222); INSERT INTO `sys_group_menu` VALUES (6, 30111); INSERT INTO `sys_group_menu` VALUES (6, 30112); INSERT INTO `sys_group_menu` VALUES (6, 30113); INSERT INTO `sys_group_menu` VALUES (6, 30114); INSERT INTO `sys_group_menu` VALUES (6, 30115); INSERT INTO `sys_group_menu` VALUES (6, 30121); INSERT INTO `sys_group_menu` VALUES (6, 30122); INSERT INTO `sys_group_menu` VALUES (6, 30123); INSERT INTO `sys_group_menu` VALUES (6, 30124); INSERT INTO `sys_group_menu` VALUES (6, 30125); INSERT INTO `sys_group_menu` VALUES (6, 30126); INSERT INTO `sys_group_menu` VALUES (6, 30127); INSERT INTO `sys_group_menu` VALUES (6, 30131); INSERT INTO `sys_group_menu` VALUES (6, 30211); INSERT INTO `sys_group_menu` VALUES (6, 30221); INSERT INTO `sys_group_menu` VALUES (6, 30222); INSERT INTO `sys_group_menu` VALUES (6, 30223); INSERT INTO `sys_group_menu` VALUES (6, 30224); INSERT INTO `sys_group_menu` VALUES (6, 30225); INSERT INTO `sys_group_menu` VALUES (6, 30232); INSERT INTO `sys_group_menu` VALUES (6, 40711); INSERT INTO `sys_group_menu` VALUES (6, 50112); INSERT INTO `sys_group_menu` VALUES (6, 50113); INSERT INTO `sys_group_menu` VALUES (6, 50114); INSERT INTO `sys_group_menu` VALUES (6, 50115); INSERT INTO `sys_group_menu` VALUES (6, 50116); INSERT INTO `sys_group_menu` VALUES (6, 50117); INSERT INTO `sys_group_menu` VALUES (6, 50118); INSERT INTO `sys_group_menu` VALUES (6, 50119); INSERT INTO `sys_group_menu` VALUES (6, 50120); INSERT INTO `sys_group_menu` VALUES (6, 50121); INSERT INTO `sys_group_menu` VALUES (6, 50132); INSERT INTO `sys_group_menu` VALUES (6, 50133); INSERT INTO `sys_group_menu` VALUES (6, 50134); INSERT INTO `sys_group_menu` VALUES (6, 60112); INSERT INTO `sys_group_menu` VALUES (6, 60113); INSERT INTO `sys_group_menu` VALUES (6, 60114); INSERT INTO `sys_group_menu` VALUES (6, 60115); INSERT INTO `sys_group_menu` VALUES (6, 60116); INSERT INTO `sys_group_menu` VALUES (6, 60117); INSERT INTO `sys_group_menu` VALUES (122, 110); INSERT INTO `sys_group_menu` VALUES (122, 111); INSERT INTO `sys_group_menu` VALUES (122, 112); INSERT INTO `sys_group_menu` VALUES (122, 113); INSERT INTO `sys_group_menu` VALUES (122, 114); INSERT INTO `sys_group_menu` VALUES (122, 115); INSERT INTO `sys_group_menu` VALUES (122, 116); INSERT INTO `sys_group_menu` VALUES (122, 117); INSERT INTO `sys_group_menu` VALUES (122, 118); INSERT INTO `sys_group_menu` VALUES (122, 119); INSERT INTO `sys_group_menu` VALUES (122, 120); INSERT INTO `sys_group_menu` VALUES (122, 121); INSERT INTO `sys_group_menu` VALUES (122, 122); INSERT INTO `sys_group_menu` VALUES (122, 123); INSERT INTO `sys_group_menu` VALUES (122, 124); INSERT INTO `sys_group_menu` VALUES (122, 125); INSERT INTO `sys_group_menu` VALUES (122, 126); INSERT INTO `sys_group_menu` VALUES (122, 127); INSERT INTO `sys_group_menu` VALUES (122, 128); INSERT INTO `sys_group_menu` VALUES (122, 129); INSERT INTO `sys_group_menu` VALUES (122, 130); INSERT INTO `sys_group_menu` VALUES (122, 131); INSERT INTO `sys_group_menu` VALUES (122, 132); INSERT INTO `sys_group_menu` VALUES (122, 133); INSERT INTO `sys_group_menu` VALUES (122, 134); INSERT INTO `sys_group_menu` VALUES (122, 135); INSERT INTO `sys_group_menu` VALUES (122, 136); INSERT INTO `sys_group_menu` VALUES (122, 137); INSERT INTO `sys_group_menu` VALUES (122, 138); INSERT INTO `sys_group_menu` VALUES (122, 139); INSERT INTO `sys_group_menu` VALUES (122, 140); INSERT INTO `sys_group_menu` VALUES (122, 141); INSERT INTO `sys_group_menu` VALUES (122, 142); INSERT INTO `sys_group_menu` VALUES (122, 143); INSERT INTO `sys_group_menu` VALUES (122, 144); INSERT INTO `sys_group_menu` VALUES (122, 145); INSERT INTO `sys_group_menu` VALUES (122, 146); INSERT INTO `sys_group_menu` VALUES (122, 147); INSERT INTO `sys_group_menu` VALUES (122, 148); INSERT INTO `sys_group_menu` VALUES (122, 149); INSERT INTO `sys_group_menu` VALUES (122, 150); INSERT INTO `sys_group_menu` VALUES (122, 151); INSERT INTO `sys_group_menu` VALUES (122, 152); INSERT INTO `sys_group_menu` VALUES (122, 153); INSERT INTO `sys_group_menu` VALUES (122, 154); INSERT INTO `sys_group_menu` VALUES (122, 155); INSERT INTO `sys_group_menu` VALUES (122, 156); INSERT INTO `sys_group_menu` VALUES (122, 157); INSERT INTO `sys_group_menu` VALUES (122, 158); INSERT INTO `sys_group_menu` VALUES (122, 159); INSERT INTO `sys_group_menu` VALUES (122, 160); INSERT INTO `sys_group_menu` VALUES (122, 161); INSERT INTO `sys_group_menu` VALUES (122, 162); INSERT INTO `sys_group_menu` VALUES (122, 163); INSERT INTO `sys_group_menu` VALUES (122, 164); INSERT INTO `sys_group_menu` VALUES (122, 165); INSERT INTO `sys_group_menu` VALUES (122, 166); INSERT INTO `sys_group_menu` VALUES (122, 167); INSERT INTO `sys_group_menu` VALUES (122, 168); INSERT INTO `sys_group_menu` VALUES (122, 169); INSERT INTO `sys_group_menu` VALUES (122, 170); INSERT INTO `sys_group_menu` VALUES (122, 171); INSERT INTO `sys_group_menu` VALUES (122, 172); INSERT INTO `sys_group_menu` VALUES (122, 173); INSERT INTO `sys_group_menu` VALUES (122, 174); INSERT INTO `sys_group_menu` VALUES (122, 175); INSERT INTO `sys_group_menu` VALUES (122, 176); INSERT INTO `sys_group_menu` VALUES (122, 177); INSERT INTO `sys_group_menu` VALUES (122, 178); INSERT INTO `sys_group_menu` VALUES (122, 179); INSERT INTO `sys_group_menu` VALUES (122, 180); INSERT INTO `sys_group_menu` VALUES (122, 181); INSERT INTO `sys_group_menu` VALUES (122, 182); INSERT INTO `sys_group_menu` VALUES (122, 183); INSERT INTO `sys_group_menu` VALUES (122, 184); INSERT INTO `sys_group_menu` VALUES (122, 185); INSERT INTO `sys_group_menu` VALUES (122, 186); INSERT INTO `sys_group_menu` VALUES (122, 187); INSERT INTO `sys_group_menu` VALUES (122, 188); INSERT INTO `sys_group_menu` VALUES (122, 189); INSERT INTO `sys_group_menu` VALUES (122, 190); INSERT INTO `sys_group_menu` VALUES (122, 191); INSERT INTO `sys_group_menu` VALUES (122, 192); INSERT INTO `sys_group_menu` VALUES (122, 214); INSERT INTO `sys_group_menu` VALUES (122, 217); INSERT INTO `sys_group_menu` VALUES (122, 218); INSERT INTO `sys_group_menu` VALUES (125, 1); INSERT INTO `sys_group_menu` VALUES (125, 2); INSERT INTO `sys_group_menu` VALUES (125, 3); INSERT INTO `sys_group_menu` VALUES (125, 4); INSERT INTO `sys_group_menu` VALUES (125, 5); INSERT INTO `sys_group_menu` VALUES (125, 6); INSERT INTO `sys_group_menu` VALUES (125, 7); INSERT INTO `sys_group_menu` VALUES (125, 8); INSERT INTO `sys_group_menu` VALUES (125, 9); INSERT INTO `sys_group_menu` VALUES (125, 10); INSERT INTO `sys_group_menu` VALUES (125, 11); INSERT INTO `sys_group_menu` VALUES (125, 12); INSERT INTO `sys_group_menu` VALUES (125, 13); INSERT INTO `sys_group_menu` VALUES (125, 14); INSERT INTO `sys_group_menu` VALUES (125, 15); INSERT INTO `sys_group_menu` VALUES (125, 16); INSERT INTO `sys_group_menu` VALUES (125, 17); INSERT INTO `sys_group_menu` VALUES (125, 18); INSERT INTO `sys_group_menu` VALUES (125, 19); INSERT INTO `sys_group_menu` VALUES (125, 20); INSERT INTO `sys_group_menu` VALUES (125, 21); INSERT INTO `sys_group_menu` VALUES (125, 22); INSERT INTO `sys_group_menu` VALUES (125, 23); INSERT INTO `sys_group_menu` VALUES (125, 24); INSERT INTO `sys_group_menu` VALUES (125, 25); INSERT INTO `sys_group_menu` VALUES (125, 26); INSERT INTO `sys_group_menu` VALUES (125, 27); INSERT INTO `sys_group_menu` VALUES (125, 28); INSERT INTO `sys_group_menu` VALUES (125, 29); INSERT INTO `sys_group_menu` VALUES (125, 30); INSERT INTO `sys_group_menu` VALUES (125, 31); INSERT INTO `sys_group_menu` VALUES (125, 32); INSERT INTO `sys_group_menu` VALUES (125, 33); INSERT INTO `sys_group_menu` VALUES (125, 34); INSERT INTO `sys_group_menu` VALUES (125, 35); INSERT INTO `sys_group_menu` VALUES (125, 36); INSERT INTO `sys_group_menu` VALUES (125, 37); INSERT INTO `sys_group_menu` VALUES (125, 38); INSERT INTO `sys_group_menu` VALUES (125, 39); INSERT INTO `sys_group_menu` VALUES (125, 40); INSERT INTO `sys_group_menu` VALUES (125, 41); INSERT INTO `sys_group_menu` VALUES (125, 42); INSERT INTO `sys_group_menu` VALUES (125, 43); INSERT INTO `sys_group_menu` VALUES (125, 44); INSERT INTO `sys_group_menu` VALUES (125, 45); INSERT INTO `sys_group_menu` VALUES (125, 46); INSERT INTO `sys_group_menu` VALUES (125, 48); INSERT INTO `sys_group_menu` VALUES (125, 49); INSERT INTO `sys_group_menu` VALUES (125, 50); INSERT INTO `sys_group_menu` VALUES (125, 51); INSERT INTO `sys_group_menu` VALUES (125, 52); INSERT INTO `sys_group_menu` VALUES (125, 53); INSERT INTO `sys_group_menu` VALUES (125, 54); INSERT INTO `sys_group_menu` VALUES (125, 55); INSERT INTO `sys_group_menu` VALUES (125, 56); INSERT INTO `sys_group_menu` VALUES (125, 57); INSERT INTO `sys_group_menu` VALUES (125, 58); INSERT INTO `sys_group_menu` VALUES (125, 59); INSERT INTO `sys_group_menu` VALUES (125, 60); INSERT INTO `sys_group_menu` VALUES (125, 61); INSERT INTO `sys_group_menu` VALUES (125, 62); INSERT INTO `sys_group_menu` VALUES (125, 63); INSERT INTO `sys_group_menu` VALUES (125, 64); INSERT INTO `sys_group_menu` VALUES (125, 65); INSERT INTO `sys_group_menu` VALUES (125, 66); INSERT INTO `sys_group_menu` VALUES (125, 67); INSERT INTO `sys_group_menu` VALUES (125, 68); INSERT INTO `sys_group_menu` VALUES (125, 69); INSERT INTO `sys_group_menu` VALUES (125, 70); INSERT INTO `sys_group_menu` VALUES (125, 71); INSERT INTO `sys_group_menu` VALUES (125, 72); INSERT INTO `sys_group_menu` VALUES (125, 73); INSERT INTO `sys_group_menu` VALUES (125, 74); INSERT INTO `sys_group_menu` VALUES (125, 75); INSERT INTO `sys_group_menu` VALUES (125, 110); INSERT INTO `sys_group_menu` VALUES (125, 111); INSERT INTO `sys_group_menu` VALUES (125, 112); INSERT INTO `sys_group_menu` VALUES (125, 113); INSERT INTO `sys_group_menu` VALUES (125, 114); INSERT INTO `sys_group_menu` VALUES (125, 115); INSERT INTO `sys_group_menu` VALUES (125, 116); INSERT INTO `sys_group_menu` VALUES (125, 117); INSERT INTO `sys_group_menu` VALUES (125, 118); INSERT INTO `sys_group_menu` VALUES (125, 119); INSERT INTO `sys_group_menu` VALUES (125, 120); INSERT INTO `sys_group_menu` VALUES (125, 121); INSERT INTO `sys_group_menu` VALUES (125, 122); INSERT INTO `sys_group_menu` VALUES (125, 123); INSERT INTO `sys_group_menu` VALUES (125, 124); INSERT INTO `sys_group_menu` VALUES (125, 125); INSERT INTO `sys_group_menu` VALUES (125, 126); INSERT INTO `sys_group_menu` VALUES (125, 127); INSERT INTO `sys_group_menu` VALUES (125, 128); INSERT INTO `sys_group_menu` VALUES (125, 129); INSERT INTO `sys_group_menu` VALUES (125, 130); INSERT INTO `sys_group_menu` VALUES (125, 131); INSERT INTO `sys_group_menu` VALUES (125, 132); INSERT INTO `sys_group_menu` VALUES (125, 133); INSERT INTO `sys_group_menu` VALUES (125, 134); INSERT INTO `sys_group_menu` VALUES (125, 135); INSERT INTO `sys_group_menu` VALUES (125, 136); INSERT INTO `sys_group_menu` VALUES (125, 137); INSERT INTO `sys_group_menu` VALUES (125, 138); INSERT INTO `sys_group_menu` VALUES (125, 139); INSERT INTO `sys_group_menu` VALUES (125, 140); INSERT INTO `sys_group_menu` VALUES (125, 141); INSERT INTO `sys_group_menu` VALUES (125, 142); INSERT INTO `sys_group_menu` VALUES (125, 143); INSERT INTO `sys_group_menu` VALUES (125, 144); INSERT INTO `sys_group_menu` VALUES (125, 145); INSERT INTO `sys_group_menu` VALUES (125, 146); INSERT INTO `sys_group_menu` VALUES (125, 147); INSERT INTO `sys_group_menu` VALUES (125, 148); INSERT INTO `sys_group_menu` VALUES (125, 149); INSERT INTO `sys_group_menu` VALUES (125, 150); INSERT INTO `sys_group_menu` VALUES (125, 151); INSERT INTO `sys_group_menu` VALUES (125, 152); INSERT INTO `sys_group_menu` VALUES (125, 153); INSERT INTO `sys_group_menu` VALUES (125, 154); INSERT INTO `sys_group_menu` VALUES (125, 155); INSERT INTO `sys_group_menu` VALUES (125, 156); INSERT INTO `sys_group_menu` VALUES (125, 157); INSERT INTO `sys_group_menu` VALUES (125, 158); INSERT INTO `sys_group_menu` VALUES (125, 159); INSERT INTO `sys_group_menu` VALUES (125, 160); INSERT INTO `sys_group_menu` VALUES (125, 161); INSERT INTO `sys_group_menu` VALUES (125, 162); INSERT INTO `sys_group_menu` VALUES (125, 163); INSERT INTO `sys_group_menu` VALUES (125, 164); INSERT INTO `sys_group_menu` VALUES (125, 165); INSERT INTO `sys_group_menu` VALUES (125, 166); INSERT INTO `sys_group_menu` VALUES (125, 167); INSERT INTO `sys_group_menu` VALUES (125, 168); INSERT INTO `sys_group_menu` VALUES (125, 169); INSERT INTO `sys_group_menu` VALUES (125, 170); INSERT INTO `sys_group_menu` VALUES (125, 171); INSERT INTO `sys_group_menu` VALUES (125, 172); INSERT INTO `sys_group_menu` VALUES (125, 173); INSERT INTO `sys_group_menu` VALUES (125, 174); INSERT INTO `sys_group_menu` VALUES (125, 175); INSERT INTO `sys_group_menu` VALUES (125, 176); INSERT INTO `sys_group_menu` VALUES (125, 177); INSERT INTO `sys_group_menu` VALUES (125, 178); INSERT INTO `sys_group_menu` VALUES (125, 179); INSERT INTO `sys_group_menu` VALUES (125, 180); INSERT INTO `sys_group_menu` VALUES (125, 181); INSERT INTO `sys_group_menu` VALUES (125, 182); INSERT INTO `sys_group_menu` VALUES (125, 183); INSERT INTO `sys_group_menu` VALUES (125, 184); INSERT INTO `sys_group_menu` VALUES (125, 185); INSERT INTO `sys_group_menu` VALUES (125, 186); INSERT INTO `sys_group_menu` VALUES (125, 187); INSERT INTO `sys_group_menu` VALUES (125, 188); INSERT INTO `sys_group_menu` VALUES (125, 189); INSERT INTO `sys_group_menu` VALUES (125, 190); INSERT INTO `sys_group_menu` VALUES (125, 191); INSERT INTO `sys_group_menu` VALUES (125, 192); INSERT INTO `sys_group_menu` VALUES (125, 193); INSERT INTO `sys_group_menu` VALUES (125, 194); INSERT INTO `sys_group_menu` VALUES (125, 195); INSERT INTO `sys_group_menu` VALUES (125, 196); INSERT INTO `sys_group_menu` VALUES (125, 197); INSERT INTO `sys_group_menu` VALUES (125, 198); INSERT INTO `sys_group_menu` VALUES (125, 199); INSERT INTO `sys_group_menu` VALUES (125, 200); INSERT INTO `sys_group_menu` VALUES (125, 201); INSERT INTO `sys_group_menu` VALUES (125, 202); INSERT INTO `sys_group_menu` VALUES (125, 203); INSERT INTO `sys_group_menu` VALUES (125, 204); INSERT INTO `sys_group_menu` VALUES (125, 205); INSERT INTO `sys_group_menu` VALUES (125, 206); INSERT INTO `sys_group_menu` VALUES (125, 207); INSERT INTO `sys_group_menu` VALUES (125, 208); INSERT INTO `sys_group_menu` VALUES (125, 209); INSERT INTO `sys_group_menu` VALUES (125, 210); INSERT INTO `sys_group_menu` VALUES (125, 211); INSERT INTO `sys_group_menu` VALUES (125, 212); INSERT INTO `sys_group_menu` VALUES (125, 213); INSERT INTO `sys_group_menu` VALUES (125, 214); INSERT INTO `sys_group_menu` VALUES (125, 215); INSERT INTO `sys_group_menu` VALUES (125, 216); INSERT INTO `sys_group_menu` VALUES (125, 217); INSERT INTO `sys_group_menu` VALUES (125, 218); INSERT INTO `sys_group_menu` VALUES (127, 119); INSERT INTO `sys_group_menu` VALUES (127, 120); INSERT INTO `sys_group_menu` VALUES (127, 121); INSERT INTO `sys_group_menu` VALUES (127, 122); INSERT INTO `sys_group_menu` VALUES (127, 123); INSERT INTO `sys_group_menu` VALUES (127, 124); INSERT INTO `sys_group_menu` VALUES (127, 125); INSERT INTO `sys_group_menu` VALUES (127, 126); INSERT INTO `sys_group_menu` VALUES (127, 131); INSERT INTO `sys_group_menu` VALUES (127, 132); INSERT INTO `sys_group_menu` VALUES (127, 133); INSERT INTO `sys_group_menu` VALUES (127, 134); INSERT INTO `sys_group_menu` VALUES (127, 135); INSERT INTO `sys_group_menu` VALUES (127, 136); INSERT INTO `sys_group_menu` VALUES (127, 137); INSERT INTO `sys_group_menu` VALUES (127, 138); INSERT INTO `sys_group_menu` VALUES (127, 139); INSERT INTO `sys_group_menu` VALUES (127, 140); INSERT INTO `sys_group_menu` VALUES (127, 143); INSERT INTO `sys_group_menu` VALUES (127, 146); INSERT INTO `sys_group_menu` VALUES (127, 147); INSERT INTO `sys_group_menu` VALUES (127, 148); INSERT INTO `sys_group_menu` VALUES (127, 149); INSERT INTO `sys_group_menu` VALUES (127, 150); INSERT INTO `sys_group_menu` VALUES (127, 151); INSERT INTO `sys_group_menu` VALUES (128, 110); INSERT INTO `sys_group_menu` VALUES (128, 111); INSERT INTO `sys_group_menu` VALUES (128, 112); INSERT INTO `sys_group_menu` VALUES (128, 113); INSERT INTO `sys_group_menu` VALUES (128, 114); INSERT INTO `sys_group_menu` VALUES (128, 115); INSERT INTO `sys_group_menu` VALUES (128, 116); INSERT INTO `sys_group_menu` VALUES (128, 117); INSERT INTO `sys_group_menu` VALUES (128, 118); INSERT INTO `sys_group_menu` VALUES (128, 119); INSERT INTO `sys_group_menu` VALUES (128, 120); INSERT INTO `sys_group_menu` VALUES (128, 121); INSERT INTO `sys_group_menu` VALUES (128, 122); INSERT INTO `sys_group_menu` VALUES (128, 123); INSERT INTO `sys_group_menu` VALUES (128, 124); INSERT INTO `sys_group_menu` VALUES (128, 125); INSERT INTO `sys_group_menu` VALUES (128, 126); INSERT INTO `sys_group_menu` VALUES (128, 127); INSERT INTO `sys_group_menu` VALUES (128, 128); INSERT INTO `sys_group_menu` VALUES (128, 129); INSERT INTO `sys_group_menu` VALUES (128, 130); INSERT INTO `sys_group_menu` VALUES (128, 131); INSERT INTO `sys_group_menu` VALUES (128, 132); INSERT INTO `sys_group_menu` VALUES (128, 133); INSERT INTO `sys_group_menu` VALUES (128, 134); INSERT INTO `sys_group_menu` VALUES (128, 135); INSERT INTO `sys_group_menu` VALUES (128, 136); INSERT INTO `sys_group_menu` VALUES (128, 137); INSERT INTO `sys_group_menu` VALUES (128, 138); INSERT INTO `sys_group_menu` VALUES (128, 139); INSERT INTO `sys_group_menu` VALUES (128, 140); INSERT INTO `sys_group_menu` VALUES (128, 141); INSERT INTO `sys_group_menu` VALUES (128, 142); INSERT INTO `sys_group_menu` VALUES (128, 143); INSERT INTO `sys_group_menu` VALUES (128, 144); INSERT INTO `sys_group_menu` VALUES (128, 145); INSERT INTO `sys_group_menu` VALUES (128, 146); INSERT INTO `sys_group_menu` VALUES (128, 147); INSERT INTO `sys_group_menu` VALUES (128, 148); INSERT INTO `sys_group_menu` VALUES (128, 149); INSERT INTO `sys_group_menu` VALUES (128, 150); INSERT INTO `sys_group_menu` VALUES (128, 151); INSERT INTO `sys_group_menu` VALUES (128, 152); INSERT INTO `sys_group_menu` VALUES (128, 153); INSERT INTO `sys_group_menu` VALUES (128, 154); INSERT INTO `sys_group_menu` VALUES (128, 155); INSERT INTO `sys_group_menu` VALUES (128, 156); INSERT INTO `sys_group_menu` VALUES (128, 157); INSERT INTO `sys_group_menu` VALUES (128, 158); INSERT INTO `sys_group_menu` VALUES (128, 159); INSERT INTO `sys_group_menu` VALUES (128, 160); INSERT INTO `sys_group_menu` VALUES (128, 161); INSERT INTO `sys_group_menu` VALUES (128, 162); INSERT INTO `sys_group_menu` VALUES (128, 163); INSERT INTO `sys_group_menu` VALUES (128, 164); INSERT INTO `sys_group_menu` VALUES (128, 165); INSERT INTO `sys_group_menu` VALUES (128, 166); INSERT INTO `sys_group_menu` VALUES (128, 167); INSERT INTO `sys_group_menu` VALUES (128, 168); INSERT INTO `sys_group_menu` VALUES (128, 169); INSERT INTO `sys_group_menu` VALUES (128, 170); INSERT INTO `sys_group_menu` VALUES (128, 171); INSERT INTO `sys_group_menu` VALUES (128, 172); INSERT INTO `sys_group_menu` VALUES (128, 173); INSERT INTO `sys_group_menu` VALUES (128, 174); INSERT INTO `sys_group_menu` VALUES (128, 175); INSERT INTO `sys_group_menu` VALUES (128, 176); INSERT INTO `sys_group_menu` VALUES (128, 177); INSERT INTO `sys_group_menu` VALUES (128, 178); INSERT INTO `sys_group_menu` VALUES (128, 179); INSERT INTO `sys_group_menu` VALUES (128, 180); INSERT INTO `sys_group_menu` VALUES (128, 181); INSERT INTO `sys_group_menu` VALUES (128, 182); INSERT INTO `sys_group_menu` VALUES (128, 183); INSERT INTO `sys_group_menu` VALUES (128, 184); INSERT INTO `sys_group_menu` VALUES (128, 185); INSERT INTO `sys_group_menu` VALUES (128, 186); INSERT INTO `sys_group_menu` VALUES (128, 187); INSERT INTO `sys_group_menu` VALUES (128, 188); INSERT INTO `sys_group_menu` VALUES (128, 189); INSERT INTO `sys_group_menu` VALUES (128, 190); INSERT INTO `sys_group_menu` VALUES (128, 191); INSERT INTO `sys_group_menu` VALUES (128, 192); INSERT INTO `sys_group_menu` VALUES (128, 193); INSERT INTO `sys_group_menu` VALUES (128, 194); INSERT INTO `sys_group_menu` VALUES (128, 195); INSERT INTO `sys_group_menu` VALUES (128, 196); INSERT INTO `sys_group_menu` VALUES (128, 197); INSERT INTO `sys_group_menu` VALUES (128, 198); INSERT INTO `sys_group_menu` VALUES (128, 199); INSERT INTO `sys_group_menu` VALUES (128, 200); INSERT INTO `sys_group_menu` VALUES (128, 201); INSERT INTO `sys_group_menu` VALUES (128, 202); INSERT INTO `sys_group_menu` VALUES (128, 203); INSERT INTO `sys_group_menu` VALUES (128, 204); INSERT INTO `sys_group_menu` VALUES (128, 205); INSERT INTO `sys_group_menu` VALUES (128, 206); INSERT INTO `sys_group_menu` VALUES (128, 207); INSERT INTO `sys_group_menu` VALUES (128, 208); INSERT INTO `sys_group_menu` VALUES (128, 209); INSERT INTO `sys_group_menu` VALUES (128, 210); INSERT INTO `sys_group_menu` VALUES (128, 211); INSERT INTO `sys_group_menu` VALUES (128, 212); INSERT INTO `sys_group_menu` VALUES (128, 213); INSERT INTO `sys_group_menu` VALUES (128, 214); INSERT INTO `sys_group_menu` VALUES (128, 215); INSERT INTO `sys_group_menu` VALUES (128, 216); INSERT INTO `sys_group_menu` VALUES (128, 217); INSERT INTO `sys_group_menu` VALUES (128, 218); INSERT INTO `sys_group_menu` VALUES (129, 110); INSERT INTO `sys_group_menu` VALUES (129, 111); INSERT INTO `sys_group_menu` VALUES (129, 112); INSERT INTO `sys_group_menu` VALUES (129, 113); INSERT INTO `sys_group_menu` VALUES (129, 114); INSERT INTO `sys_group_menu` VALUES (129, 115); INSERT INTO `sys_group_menu` VALUES (129, 116); INSERT INTO `sys_group_menu` VALUES (129, 117); INSERT INTO `sys_group_menu` VALUES (129, 118); INSERT INTO `sys_group_menu` VALUES (129, 119); INSERT INTO `sys_group_menu` VALUES (129, 120); INSERT INTO `sys_group_menu` VALUES (129, 121); INSERT INTO `sys_group_menu` VALUES (129, 122); INSERT INTO `sys_group_menu` VALUES (129, 123); INSERT INTO `sys_group_menu` VALUES (129, 124); INSERT INTO `sys_group_menu` VALUES (129, 125); INSERT INTO `sys_group_menu` VALUES (129, 126); INSERT INTO `sys_group_menu` VALUES (129, 127); INSERT INTO `sys_group_menu` VALUES (129, 128); INSERT INTO `sys_group_menu` VALUES (129, 129); INSERT INTO `sys_group_menu` VALUES (129, 130); INSERT INTO `sys_group_menu` VALUES (129, 131); INSERT INTO `sys_group_menu` VALUES (129, 132); INSERT INTO `sys_group_menu` VALUES (129, 133); INSERT INTO `sys_group_menu` VALUES (129, 134); INSERT INTO `sys_group_menu` VALUES (129, 135); INSERT INTO `sys_group_menu` VALUES (129, 136); INSERT INTO `sys_group_menu` VALUES (129, 137); INSERT INTO `sys_group_menu` VALUES (129, 138); INSERT INTO `sys_group_menu` VALUES (129, 139); INSERT INTO `sys_group_menu` VALUES (129, 140); INSERT INTO `sys_group_menu` VALUES (129, 141); INSERT INTO `sys_group_menu` VALUES (129, 142); INSERT INTO `sys_group_menu` VALUES (129, 143); INSERT INTO `sys_group_menu` VALUES (129, 144); INSERT INTO `sys_group_menu` VALUES (129, 145); INSERT INTO `sys_group_menu` VALUES (129, 146); INSERT INTO `sys_group_menu` VALUES (129, 147); INSERT INTO `sys_group_menu` VALUES (129, 148); INSERT INTO `sys_group_menu` VALUES (129, 149); INSERT INTO `sys_group_menu` VALUES (129, 150); INSERT INTO `sys_group_menu` VALUES (129, 151); INSERT INTO `sys_group_menu` VALUES (129, 152); INSERT INTO `sys_group_menu` VALUES (129, 153); INSERT INTO `sys_group_menu` VALUES (129, 154); INSERT INTO `sys_group_menu` VALUES (129, 155); INSERT INTO `sys_group_menu` VALUES (129, 156); INSERT INTO `sys_group_menu` VALUES (129, 157); INSERT INTO `sys_group_menu` VALUES (129, 158); INSERT INTO `sys_group_menu` VALUES (129, 159); INSERT INTO `sys_group_menu` VALUES (129, 160); INSERT INTO `sys_group_menu` VALUES (129, 161); INSERT INTO `sys_group_menu` VALUES (129, 162); INSERT INTO `sys_group_menu` VALUES (129, 163); INSERT INTO `sys_group_menu` VALUES (129, 164); INSERT INTO `sys_group_menu` VALUES (129, 165); INSERT INTO `sys_group_menu` VALUES (129, 166); INSERT INTO `sys_group_menu` VALUES (129, 167); INSERT INTO `sys_group_menu` VALUES (129, 168); INSERT INTO `sys_group_menu` VALUES (129, 169); INSERT INTO `sys_group_menu` VALUES (129, 170); INSERT INTO `sys_group_menu` VALUES (129, 171); INSERT INTO `sys_group_menu` VALUES (129, 172); INSERT INTO `sys_group_menu` VALUES (129, 173); INSERT INTO `sys_group_menu` VALUES (129, 174); INSERT INTO `sys_group_menu` VALUES (129, 175); INSERT INTO `sys_group_menu` VALUES (129, 176); INSERT INTO `sys_group_menu` VALUES (129, 177); INSERT INTO `sys_group_menu` VALUES (129, 178); INSERT INTO `sys_group_menu` VALUES (129, 179); INSERT INTO `sys_group_menu` VALUES (129, 180); INSERT INTO `sys_group_menu` VALUES (129, 181); INSERT INTO `sys_group_menu` VALUES (129, 182); INSERT INTO `sys_group_menu` VALUES (129, 183); INSERT INTO `sys_group_menu` VALUES (129, 184); INSERT INTO `sys_group_menu` VALUES (129, 185); INSERT INTO `sys_group_menu` VALUES (129, 186); INSERT INTO `sys_group_menu` VALUES (129, 187); INSERT INTO `sys_group_menu` VALUES (129, 188); INSERT INTO `sys_group_menu` VALUES (129, 189); INSERT INTO `sys_group_menu` VALUES (129, 190); INSERT INTO `sys_group_menu` VALUES (129, 191); INSERT INTO `sys_group_menu` VALUES (129, 192); INSERT INTO `sys_group_menu` VALUES (129, 214); INSERT INTO `sys_group_menu` VALUES (129, 216); INSERT INTO `sys_group_menu` VALUES (129, 217); INSERT INTO `sys_group_menu` VALUES (129, 218); INSERT INTO `sys_group_menu` VALUES (137, 119); INSERT INTO `sys_group_menu` VALUES (137, 120); INSERT INTO `sys_group_menu` VALUES (137, 135); INSERT INTO `sys_group_menu` VALUES (137, 136); INSERT INTO `sys_group_menu` VALUES (137, 137); INSERT INTO `sys_group_menu` VALUES (137, 138); INSERT INTO `sys_group_menu` VALUES (137, 139); INSERT INTO `sys_group_menu` VALUES (137, 140); INSERT INTO `sys_group_menu` VALUES (137, 143); INSERT INTO `sys_group_menu` VALUES (137, 146); INSERT INTO `sys_group_menu` VALUES (137, 147); INSERT INTO `sys_group_menu` VALUES (137, 148); INSERT INTO `sys_group_menu` VALUES (137, 149); INSERT INTO `sys_group_menu` VALUES (138, 152); -- ---------------------------- -- Table structure for sys_post -- ---------------------------- DROP TABLE IF EXISTS `sys_post`; CREATE TABLE `sys_post` ( `post_id` bigint NOT NULL AUTO_INCREMENT COMMENT '岗位ID', `post_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '岗位编码', `post_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '岗位名称', `post_sort` int NOT NULL COMMENT '显示顺序', `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '状态（0正常 1停用）', `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`post_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '岗位信息表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of sys_post -- ---------------------------- INSERT INTO `sys_post` VALUES (1, 'ceo', '董事长', 1, '0', 'admin', '2023-10-02 14:09:09', '', NULL, ''); INSERT INTO `sys_post` VALUES (2, 'se', '项目经理', 2, '0', 'admin', '2023-10-02 14:09:09', '', NULL, ''); INSERT INTO `sys_post` VALUES (3, 'hr', '人力资源', 3, '0', 'admin', '2023-10-02 14:09:09', '', NULL, ''); INSERT INTO `sys_post` VALUES (4, 'user', '普通员工', 4, '0', 'admin', '2023-10-02 14:09:09', '', NULL, ''); -- ---------------------------- -- Table structure for sys_role -- ---------------------------- DROP TABLE IF EXISTS `sys_role`; CREATE TABLE `sys_role` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '角色ID', `group_id` bigint NOT NULL COMMENT '权限组id', `role_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '角色名称', `remarks` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '备注', `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 '修改时间', `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 = 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-25 15:00:55', '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, 6, '管理员', '123', 0, '2026-02-13 23:29:41', '2026-02-26 09:17:56', '开发', ''); -- ---------------------------- -- Table structure for sys_role_dept -- ---------------------------- DROP TABLE IF EXISTS `sys_role_dept`; CREATE TABLE `sys_role_dept` ( `role_id` bigint NOT NULL COMMENT '角色ID', `dept_id` bigint NOT NULL COMMENT '部门ID', PRIMARY KEY (`role_id`, `dept_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色和部门关联表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of sys_role_dept -- ---------------------------- INSERT INTO `sys_role_dept` VALUES (2, 100); INSERT INTO `sys_role_dept` VALUES (2, 101); INSERT INTO `sys_role_dept` VALUES (2, 105); -- ---------------------------- -- Table structure for sys_user -- ---------------------------- DROP TABLE IF EXISTS `sys_user`; CREATE TABLE `sys_user` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '用户ID', `nick_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用户昵称', `unique_number` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '唯一值编号', `user_account` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用户账号', `phone_number` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '手机号码', `password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '密码', `avatar` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '头像地址', `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '帐号状态 是否禁用（0正常 1停用）', `remarks` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '备注', `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 '修改时间', `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 = 951 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户信息表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of sys_user -- ---------------------------- INSERT INTO `sys_user` VALUES (1, '开发', '1', 'admin', '18888888888', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '', 0, '备注', 0, '2026-02-09 18:08:42', '2026-02-26 10:55:58', '', '开发'); 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', '开发', '开发'); INSERT INTO `sys_user` VALUES (950, '李四', '1372910191239', '372910191239', '15787628921', '$2a$10$mArxH7DuDmMkr9vo71Fkhu7pzRD3Cm3/s/0DGlooBD1oNXmbaB/4S', '', 0, '', 0, '2026-02-24 16:16:12', '2026-02-24 16:16:12', '开发', '开发'); -- ---------------------------- -- Table structure for sys_user_post -- ---------------------------- DROP TABLE IF EXISTS `sys_user_post`; CREATE TABLE `sys_user_post` ( `user_id` bigint NOT NULL COMMENT '用户ID', `post_id` bigint NOT NULL COMMENT '岗位ID', PRIMARY KEY (`user_id`, `post_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户与岗位关联表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of sys_user_post -- ---------------------------- INSERT INTO `sys_user_post` VALUES (1, 1); INSERT INTO `sys_user_post` VALUES (2, 2); -- ---------------------------- -- Table structure for sys_user_role -- ---------------------------- DROP TABLE IF EXISTS `sys_user_role`; CREATE TABLE `sys_user_role` ( `user_id` bigint NOT NULL COMMENT '用户ID', `role_id` bigint NOT NULL COMMENT '角色ID', PRIMARY KEY (`user_id`, `role_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户和角色关联表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of sys_user_role -- ---------------------------- INSERT INTO `sys_user_role` VALUES (1, 1); INSERT INTO `sys_user_role` VALUES (211, 125); INSERT INTO `sys_user_role` VALUES (213, 119); INSERT INTO `sys_user_role` VALUES (214, 128); INSERT INTO `sys_user_role` VALUES (215, 128); INSERT INTO `sys_user_role` VALUES (216, 128); INSERT INTO `sys_user_role` VALUES (217, 128); INSERT INTO `sys_user_role` VALUES (218, 122); INSERT INTO `sys_user_role` VALUES (219, 125); INSERT INTO `sys_user_role` VALUES (220, 125); INSERT INTO `sys_user_role` VALUES (221, 125); INSERT INTO `sys_user_role` VALUES (222, 124); INSERT INTO `sys_user_role` VALUES (223, 124); INSERT INTO `sys_user_role` VALUES (224, 127); INSERT INTO `sys_user_role` VALUES (225, 127); INSERT INTO `sys_user_role` VALUES (226, 127); INSERT INTO `sys_user_role` VALUES (228, 124); INSERT INTO `sys_user_role` VALUES (231, 119); INSERT INTO `sys_user_role` VALUES (232, 128); INSERT INTO `sys_user_role` VALUES (233, 119); INSERT INTO `sys_user_role` VALUES (234, 119); INSERT INTO `sys_user_role` VALUES (235, 119); INSERT INTO `sys_user_role` VALUES (236, 119); INSERT INTO `sys_user_role` VALUES (237, 119); INSERT INTO `sys_user_role` VALUES (238, 119); INSERT INTO `sys_user_role` VALUES (240, 128); INSERT INTO `sys_user_role` VALUES (241, 122); INSERT INTO `sys_user_role` VALUES (242, 124); INSERT INTO `sys_user_role` VALUES (243, 129); INSERT INTO `sys_user_role` VALUES (244, 129); INSERT INTO `sys_user_role` VALUES (245, 129); INSERT INTO `sys_user_role` VALUES (246, 129); INSERT INTO `sys_user_role` VALUES (247, 129); INSERT INTO `sys_user_role` VALUES (248, 129); INSERT INTO `sys_user_role` VALUES (249, 129); INSERT INTO `sys_user_role` VALUES (250, 127); INSERT INTO `sys_user_role` VALUES (251, 127); INSERT INTO `sys_user_role` VALUES (252, 127); INSERT INTO `sys_user_role` VALUES (253, 124); INSERT INTO `sys_user_role` VALUES (254, 124); INSERT INTO `sys_user_role` VALUES (255, 119); INSERT INTO `sys_user_role` VALUES (256, 119); INSERT INTO `sys_user_role` VALUES (257, 119); INSERT INTO `sys_user_role` VALUES (258, 119); INSERT INTO `sys_user_role` VALUES (259, 119); INSERT INTO `sys_user_role` VALUES (260, 119); INSERT INTO `sys_user_role` VALUES (261, 119); INSERT INTO `sys_user_role` VALUES (262, 119); INSERT INTO `sys_user_role` VALUES (263, 119); INSERT INTO `sys_user_role` VALUES (264, 119); INSERT INTO `sys_user_role` VALUES (265, 119); INSERT INTO `sys_user_role` VALUES (266, 119); INSERT INTO `sys_user_role` VALUES (267, 119); INSERT INTO `sys_user_role` VALUES (268, 119); INSERT INTO `sys_user_role` VALUES (269, 124); INSERT INTO `sys_user_role` VALUES (270, 124); INSERT INTO `sys_user_role` VALUES (271, 119); INSERT INTO `sys_user_role` VALUES (272, 127); INSERT INTO `sys_user_role` VALUES (273, 124); INSERT INTO `sys_user_role` VALUES (274, 124); INSERT INTO `sys_user_role` VALUES (275, 124); INSERT INTO `sys_user_role` VALUES (276, 119); INSERT INTO `sys_user_role` VALUES (277, 124); INSERT INTO `sys_user_role` VALUES (278, 124); INSERT INTO `sys_user_role` VALUES (279, 119); INSERT INTO `sys_user_role` VALUES (280, 119); INSERT INTO `sys_user_role` VALUES (281, 119); INSERT INTO `sys_user_role` VALUES (282, 119); INSERT INTO `sys_user_role` VALUES (283, 124); INSERT INTO `sys_user_role` VALUES (284, 119); INSERT INTO `sys_user_role` VALUES (285, 119); INSERT INTO `sys_user_role` VALUES (286, 119); INSERT INTO `sys_user_role` VALUES (287, 119); INSERT INTO `sys_user_role` VALUES (288, 119); INSERT INTO `sys_user_role` VALUES (289, 119); INSERT INTO `sys_user_role` VALUES (290, 119); INSERT INTO `sys_user_role` VALUES (291, 119); INSERT INTO `sys_user_role` VALUES (292, 119); INSERT INTO `sys_user_role` VALUES (293, 119); INSERT INTO `sys_user_role` VALUES (294, 119); INSERT INTO `sys_user_role` VALUES (295, 119); INSERT INTO `sys_user_role` VALUES (296, 119); INSERT INTO `sys_user_role` VALUES (297, 127); INSERT INTO `sys_user_role` VALUES (303, 125); INSERT INTO `sys_user_role` VALUES (306, 124); INSERT INTO `sys_user_role` VALUES (307, 124); INSERT INTO `sys_user_role` VALUES (308, 124); INSERT INTO `sys_user_role` VALUES (309, 124); INSERT INTO `sys_user_role` VALUES (310, 119); INSERT INTO `sys_user_role` VALUES (311, 119); INSERT INTO `sys_user_role` VALUES (312, 119); INSERT INTO `sys_user_role` VALUES (313, 119); INSERT INTO `sys_user_role` VALUES (314, 129); INSERT INTO `sys_user_role` VALUES (315, 124); INSERT INTO `sys_user_role` VALUES (316, 129); INSERT INTO `sys_user_role` VALUES (317, 124); INSERT INTO `sys_user_role` VALUES (318, 124); INSERT INTO `sys_user_role` VALUES (319, 124); INSERT INTO `sys_user_role` VALUES (320, 124); INSERT INTO `sys_user_role` VALUES (321, 124); INSERT INTO `sys_user_role` VALUES (322, 124); INSERT INTO `sys_user_role` VALUES (323, 119); INSERT INTO `sys_user_role` VALUES (324, 119); INSERT INTO `sys_user_role` VALUES (325, 119); INSERT INTO `sys_user_role` VALUES (326, 119); INSERT INTO `sys_user_role` VALUES (327, 119); INSERT INTO `sys_user_role` VALUES (328, 119); INSERT INTO `sys_user_role` VALUES (329, 119); INSERT INTO `sys_user_role` VALUES (330, 119); INSERT INTO `sys_user_role` VALUES (331, 119); INSERT INTO `sys_user_role` VALUES (332, 124); INSERT INTO `sys_user_role` VALUES (333, 124); INSERT INTO `sys_user_role` VALUES (334, 124); INSERT INTO `sys_user_role` VALUES (335, 119); INSERT INTO `sys_user_role` VALUES (336, 119); INSERT INTO `sys_user_role` VALUES (337, 119); INSERT INTO `sys_user_role` VALUES (338, 119); INSERT INTO `sys_user_role` VALUES (339, 119); INSERT INTO `sys_user_role` VALUES (340, 119); INSERT INTO `sys_user_role` VALUES (341, 119); INSERT INTO `sys_user_role` VALUES (342, 119); INSERT INTO `sys_user_role` VALUES (343, 124); INSERT INTO `sys_user_role` VALUES (344, 119); INSERT INTO `sys_user_role` VALUES (345, 119); INSERT INTO `sys_user_role` VALUES (346, 119); INSERT INTO `sys_user_role` VALUES (347, 124); INSERT INTO `sys_user_role` VALUES (348, 119); INSERT INTO `sys_user_role` VALUES (349, 119); INSERT INTO `sys_user_role` VALUES (350, 119); INSERT INTO `sys_user_role` VALUES (351, 119); INSERT INTO `sys_user_role` VALUES (352, 119); INSERT INTO `sys_user_role` VALUES (353, 119); INSERT INTO `sys_user_role` VALUES (354, 119); INSERT INTO `sys_user_role` VALUES (355, 119); INSERT INTO `sys_user_role` VALUES (358, 119); INSERT INTO `sys_user_role` VALUES (359, 119); INSERT INTO `sys_user_role` VALUES (360, 119); INSERT INTO `sys_user_role` VALUES (361, 124); INSERT INTO `sys_user_role` VALUES (362, 124); INSERT INTO `sys_user_role` VALUES (363, 119); INSERT INTO `sys_user_role` VALUES (364, 119); INSERT INTO `sys_user_role` VALUES (379, 119); INSERT INTO `sys_user_role` VALUES (380, 119); INSERT INTO `sys_user_role` VALUES (381, 119); INSERT INTO `sys_user_role` VALUES (382, 119); INSERT INTO `sys_user_role` VALUES (383, 119); INSERT INTO `sys_user_role` VALUES (384, 119); INSERT INTO `sys_user_role` VALUES (385, 119); INSERT INTO `sys_user_role` VALUES (386, 128); INSERT INTO `sys_user_role` VALUES (387, 127); INSERT INTO `sys_user_role` VALUES (388, 127); INSERT INTO `sys_user_role` VALUES (389, 127); INSERT INTO `sys_user_role` VALUES (390, 119); INSERT INTO `sys_user_role` VALUES (391, 124); INSERT INTO `sys_user_role` VALUES (392, 119); INSERT INTO `sys_user_role` VALUES (393, 119); INSERT INTO `sys_user_role` VALUES (394, 119); INSERT INTO `sys_user_role` VALUES (395, 119); INSERT INTO `sys_user_role` VALUES (396, 119); INSERT INTO `sys_user_role` VALUES (397, 119); INSERT INTO `sys_user_role` VALUES (398, 119); INSERT INTO `sys_user_role` VALUES (399, 119); INSERT INTO `sys_user_role` VALUES (400, 119); INSERT INTO `sys_user_role` VALUES (401, 119); INSERT INTO `sys_user_role` VALUES (402, 119); INSERT INTO `sys_user_role` VALUES (403, 119); INSERT INTO `sys_user_role` VALUES (404, 119); INSERT INTO `sys_user_role` VALUES (405, 119); INSERT INTO `sys_user_role` VALUES (406, 119); INSERT INTO `sys_user_role` VALUES (407, 119); INSERT INTO `sys_user_role` VALUES (408, 127); INSERT INTO `sys_user_role` VALUES (409, 119); INSERT INTO `sys_user_role` VALUES (410, 119); INSERT INTO `sys_user_role` VALUES (411, 119); INSERT INTO `sys_user_role` VALUES (412, 119); INSERT INTO `sys_user_role` VALUES (413, 119); INSERT INTO `sys_user_role` VALUES (414, 119); INSERT INTO `sys_user_role` VALUES (415, 127); INSERT INTO `sys_user_role` VALUES (416, 127); INSERT INTO `sys_user_role` VALUES (417, 127); INSERT INTO `sys_user_role` VALUES (418, 127); INSERT INTO `sys_user_role` VALUES (419, 127); INSERT INTO `sys_user_role` VALUES (420, 122); INSERT INTO `sys_user_role` VALUES (421, 122); INSERT INTO `sys_user_role` VALUES (422, 127); INSERT INTO `sys_user_role` VALUES (423, 127); INSERT INTO `sys_user_role` VALUES (424, 124); INSERT INTO `sys_user_role` VALUES (425, 129); INSERT INTO `sys_user_role` VALUES (426, 129); INSERT INTO `sys_user_role` VALUES (427, 124); INSERT INTO `sys_user_role` VALUES (428, 127); INSERT INTO `sys_user_role` VALUES (429, 119); INSERT INTO `sys_user_role` VALUES (430, 119); INSERT INTO `sys_user_role` VALUES (431, 124); INSERT INTO `sys_user_role` VALUES (432, 119); INSERT INTO `sys_user_role` VALUES (433, 119); INSERT INTO `sys_user_role` VALUES (434, 119); INSERT INTO `sys_user_role` VALUES (435, 124); INSERT INTO `sys_user_role` VALUES (436, 124); INSERT INTO `sys_user_role` VALUES (437, 124); INSERT INTO `sys_user_role` VALUES (438, 119); INSERT INTO `sys_user_role` VALUES (439, 124); INSERT INTO `sys_user_role` VALUES (440, 119); INSERT INTO `sys_user_role` VALUES (441, 119); INSERT INTO `sys_user_role` VALUES (442, 124); INSERT INTO `sys_user_role` VALUES (443, 124); INSERT INTO `sys_user_role` VALUES (444, 119); INSERT INTO `sys_user_role` VALUES (445, 119); INSERT INTO `sys_user_role` VALUES (446, 124); INSERT INTO `sys_user_role` VALUES (447, 119); INSERT INTO `sys_user_role` VALUES (448, 127); INSERT INTO `sys_user_role` VALUES (449, 124); INSERT INTO `sys_user_role` VALUES (450, 119); INSERT INTO `sys_user_role` VALUES (451, 119); INSERT INTO `sys_user_role` VALUES (452, 119); INSERT INTO `sys_user_role` VALUES (453, 119); INSERT INTO `sys_user_role` VALUES (454, 119); INSERT INTO `sys_user_role` VALUES (455, 119); INSERT INTO `sys_user_role` VALUES (456, 119); INSERT INTO `sys_user_role` VALUES (457, 124); INSERT INTO `sys_user_role` VALUES (458, 128); INSERT INTO `sys_user_role` VALUES (459, 119); INSERT INTO `sys_user_role` VALUES (460, 119); INSERT INTO `sys_user_role` VALUES (461, 119); INSERT INTO `sys_user_role` VALUES (462, 119); INSERT INTO `sys_user_role` VALUES (463, 119); INSERT INTO `sys_user_role` VALUES (464, 119); INSERT INTO `sys_user_role` VALUES (465, 119); INSERT INTO `sys_user_role` VALUES (466, 124); INSERT INTO `sys_user_role` VALUES (467, 128); INSERT INTO `sys_user_role` VALUES (468, 128); INSERT INTO `sys_user_role` VALUES (469, 128); INSERT INTO `sys_user_role` VALUES (470, 119); INSERT INTO `sys_user_role` VALUES (471, 128); INSERT INTO `sys_user_role` VALUES (472, 128); INSERT INTO `sys_user_role` VALUES (473, 128); INSERT INTO `sys_user_role` VALUES (474, 128); INSERT INTO `sys_user_role` VALUES (475, 128); INSERT INTO `sys_user_role` VALUES (476, 128); INSERT INTO `sys_user_role` VALUES (477, 128); INSERT INTO `sys_user_role` VALUES (478, 119); INSERT INTO `sys_user_role` VALUES (479, 119); INSERT INTO `sys_user_role` VALUES (480, 119); INSERT INTO `sys_user_role` VALUES (481, 119); INSERT INTO `sys_user_role` VALUES (482, 119); INSERT INTO `sys_user_role` VALUES (483, 119); INSERT INTO `sys_user_role` VALUES (484, 119); INSERT INTO `sys_user_role` VALUES (485, 119); INSERT INTO `sys_user_role` VALUES (486, 119); INSERT INTO `sys_user_role` VALUES (487, 124); INSERT INTO `sys_user_role` VALUES (488, 124); INSERT INTO `sys_user_role` VALUES (489, 119); INSERT INTO `sys_user_role` VALUES (490, 119); INSERT INTO `sys_user_role` VALUES (491, 119); INSERT INTO `sys_user_role` VALUES (492, 127); INSERT INTO `sys_user_role` VALUES (493, 119); INSERT INTO `sys_user_role` VALUES (494, 119); INSERT INTO `sys_user_role` VALUES (495, 119); INSERT INTO `sys_user_role` VALUES (496, 119); INSERT INTO `sys_user_role` VALUES (497, 119); INSERT INTO `sys_user_role` VALUES (498, 124); INSERT INTO `sys_user_role` VALUES (499, 119); INSERT INTO `sys_user_role` VALUES (500, 119); INSERT INTO `sys_user_role` VALUES (501, 119); INSERT INTO `sys_user_role` VALUES (502, 119); INSERT INTO `sys_user_role` VALUES (503, 119); INSERT INTO `sys_user_role` VALUES (504, 119); INSERT INTO `sys_user_role` VALUES (505, 119); INSERT INTO `sys_user_role` VALUES (506, 119); INSERT INTO `sys_user_role` VALUES (507, 119); INSERT INTO `sys_user_role` VALUES (508, 119); INSERT INTO `sys_user_role` VALUES (509, 119); INSERT INTO `sys_user_role` VALUES (510, 119); INSERT INTO `sys_user_role` VALUES (511, 119); INSERT INTO `sys_user_role` VALUES (512, 119); INSERT INTO `sys_user_role` VALUES (513, 119); INSERT INTO `sys_user_role` VALUES (514, 119); INSERT INTO `sys_user_role` VALUES (515, 119); INSERT INTO `sys_user_role` VALUES (516, 119); INSERT INTO `sys_user_role` VALUES (517, 119); INSERT INTO `sys_user_role` VALUES (518, 124); INSERT INTO `sys_user_role` VALUES (519, 119); INSERT INTO `sys_user_role` VALUES (520, 124); INSERT INTO `sys_user_role` VALUES (521, 124); INSERT INTO `sys_user_role` VALUES (522, 124); INSERT INTO `sys_user_role` VALUES (523, 119); INSERT INTO `sys_user_role` VALUES (524, 119); INSERT INTO `sys_user_role` VALUES (525, 119); INSERT INTO `sys_user_role` VALUES (526, 119); INSERT INTO `sys_user_role` VALUES (527, 119); INSERT INTO `sys_user_role` VALUES (528, 119); INSERT INTO `sys_user_role` VALUES (529, 119); INSERT INTO `sys_user_role` VALUES (530, 119); INSERT INTO `sys_user_role` VALUES (531, 119); INSERT INTO `sys_user_role` VALUES (532, 119); INSERT INTO `sys_user_role` VALUES (533, 119); INSERT INTO `sys_user_role` VALUES (534, 119); INSERT INTO `sys_user_role` VALUES (535, 119); INSERT INTO `sys_user_role` VALUES (536, 119); INSERT INTO `sys_user_role` VALUES (537, 119); INSERT INTO `sys_user_role` VALUES (538, 119); INSERT INTO `sys_user_role` VALUES (539, 119); INSERT INTO `sys_user_role` VALUES (540, 129); INSERT INTO `sys_user_role` VALUES (542, 119); INSERT INTO `sys_user_role` VALUES (543, 124); INSERT INTO `sys_user_role` VALUES (544, 124); INSERT INTO `sys_user_role` VALUES (545, 124); INSERT INTO `sys_user_role` VALUES (546, 119); INSERT INTO `sys_user_role` VALUES (547, 119); INSERT INTO `sys_user_role` VALUES (548, 124); INSERT INTO `sys_user_role` VALUES (549, 127); INSERT INTO `sys_user_role` VALUES (550, 119); INSERT INTO `sys_user_role` VALUES (551, 128); INSERT INTO `sys_user_role` VALUES (552, 128); INSERT INTO `sys_user_role` VALUES (553, 124); INSERT INTO `sys_user_role` VALUES (554, 124); INSERT INTO `sys_user_role` VALUES (555, 124); INSERT INTO `sys_user_role` VALUES (556, 124); INSERT INTO `sys_user_role` VALUES (557, 124); INSERT INTO `sys_user_role` VALUES (558, 119); INSERT INTO `sys_user_role` VALUES (559, 119); INSERT INTO `sys_user_role` VALUES (560, 119); INSERT INTO `sys_user_role` VALUES (561, 119); INSERT INTO `sys_user_role` VALUES (562, 119); INSERT INTO `sys_user_role` VALUES (563, 119); INSERT INTO `sys_user_role` VALUES (564, 119); INSERT INTO `sys_user_role` VALUES (565, 119); INSERT INTO `sys_user_role` VALUES (566, 119); INSERT INTO `sys_user_role` VALUES (567, 119); INSERT INTO `sys_user_role` VALUES (568, 119); INSERT INTO `sys_user_role` VALUES (569, 119); INSERT INTO `sys_user_role` VALUES (570, 119); INSERT INTO `sys_user_role` VALUES (571, 119); INSERT INTO `sys_user_role` VALUES (572, 124); INSERT INTO `sys_user_role` VALUES (573, 119); INSERT INTO `sys_user_role` VALUES (574, 119); INSERT INTO `sys_user_role` VALUES (575, 119); INSERT INTO `sys_user_role` VALUES (576, 119); INSERT INTO `sys_user_role` VALUES (577, 119); INSERT INTO `sys_user_role` VALUES (578, 119); INSERT INTO `sys_user_role` VALUES (579, 119); INSERT INTO `sys_user_role` VALUES (580, 124); INSERT INTO `sys_user_role` VALUES (581, 129); INSERT INTO `sys_user_role` VALUES (582, 119); INSERT INTO `sys_user_role` VALUES (583, 119); INSERT INTO `sys_user_role` VALUES (584, 119); INSERT INTO `sys_user_role` VALUES (585, 124); INSERT INTO `sys_user_role` VALUES (586, 124); INSERT INTO `sys_user_role` VALUES (587, 119); INSERT INTO `sys_user_role` VALUES (588, 119); INSERT INTO `sys_user_role` VALUES (589, 119); INSERT INTO `sys_user_role` VALUES (590, 119); INSERT INTO `sys_user_role` VALUES (591, 119); INSERT INTO `sys_user_role` VALUES (592, 119); INSERT INTO `sys_user_role` VALUES (593, 124); INSERT INTO `sys_user_role` VALUES (594, 119); INSERT INTO `sys_user_role` VALUES (595, 119); INSERT INTO `sys_user_role` VALUES (596, 124); INSERT INTO `sys_user_role` VALUES (597, 124); INSERT INTO `sys_user_role` VALUES (598, 124); INSERT INTO `sys_user_role` VALUES (599, 119); INSERT INTO `sys_user_role` VALUES (600, 119); INSERT INTO `sys_user_role` VALUES (601, 119); INSERT INTO `sys_user_role` VALUES (602, 124); INSERT INTO `sys_user_role` VALUES (603, 124); INSERT INTO `sys_user_role` VALUES (604, 124); INSERT INTO `sys_user_role` VALUES (605, 124); INSERT INTO `sys_user_role` VALUES (606, 127); INSERT INTO `sys_user_role` VALUES (607, 119); INSERT INTO `sys_user_role` VALUES (608, 119); INSERT INTO `sys_user_role` VALUES (609, 119); INSERT INTO `sys_user_role` VALUES (610, 119); INSERT INTO `sys_user_role` VALUES (611, 125); INSERT INTO `sys_user_role` VALUES (613, 119); INSERT INTO `sys_user_role` VALUES (614, 119); INSERT INTO `sys_user_role` VALUES (615, 119); INSERT INTO `sys_user_role` VALUES (616, 119); INSERT INTO `sys_user_role` VALUES (617, 119); INSERT INTO `sys_user_role` VALUES (618, 119); INSERT INTO `sys_user_role` VALUES (619, 119); INSERT INTO `sys_user_role` VALUES (620, 119); INSERT INTO `sys_user_role` VALUES (621, 119); INSERT INTO `sys_user_role` VALUES (622, 119); INSERT INTO `sys_user_role` VALUES (623, 119); INSERT INTO `sys_user_role` VALUES (624, 119); INSERT INTO `sys_user_role` VALUES (625, 119); INSERT INTO `sys_user_role` VALUES (626, 119); INSERT INTO `sys_user_role` VALUES (627, 119); INSERT INTO `sys_user_role` VALUES (628, 119); INSERT INTO `sys_user_role` VALUES (629, 119); INSERT INTO `sys_user_role` VALUES (630, 119); INSERT INTO `sys_user_role` VALUES (631, 119); INSERT INTO `sys_user_role` VALUES (632, 119); INSERT INTO `sys_user_role` VALUES (633, 124); INSERT INTO `sys_user_role` VALUES (634, 119); INSERT INTO `sys_user_role` VALUES (636, 119); INSERT INTO `sys_user_role` VALUES (637, 119); INSERT INTO `sys_user_role` VALUES (638, 119); INSERT INTO `sys_user_role` VALUES (639, 119); INSERT INTO `sys_user_role` VALUES (640, 124); INSERT INTO `sys_user_role` VALUES (641, 119); INSERT INTO `sys_user_role` VALUES (642, 119); INSERT INTO `sys_user_role` VALUES (643, 119); INSERT INTO `sys_user_role` VALUES (644, 119); INSERT INTO `sys_user_role` VALUES (645, 119); INSERT INTO `sys_user_role` VALUES (646, 124); INSERT INTO `sys_user_role` VALUES (647, 124); INSERT INTO `sys_user_role` VALUES (648, 119); INSERT INTO `sys_user_role` VALUES (649, 124); INSERT INTO `sys_user_role` VALUES (650, 119); INSERT INTO `sys_user_role` VALUES (651, 137); INSERT INTO `sys_user_role` VALUES (652, 119); INSERT INTO `sys_user_role` VALUES (653, 119); INSERT INTO `sys_user_role` VALUES (654, 119); INSERT INTO `sys_user_role` VALUES (655, 119); INSERT INTO `sys_user_role` VALUES (656, 124); INSERT INTO `sys_user_role` VALUES (657, 119); INSERT INTO `sys_user_role` VALUES (658, 119); INSERT INTO `sys_user_role` VALUES (659, 119); INSERT INTO `sys_user_role` VALUES (660, 119); INSERT INTO `sys_user_role` VALUES (661, 119); INSERT INTO `sys_user_role` VALUES (662, 127); INSERT INTO `sys_user_role` VALUES (663, 119); INSERT INTO `sys_user_role` VALUES (664, 119); INSERT INTO `sys_user_role` VALUES (665, 127); INSERT INTO `sys_user_role` VALUES (666, 119); INSERT INTO `sys_user_role` VALUES (667, 124); INSERT INTO `sys_user_role` VALUES (668, 119); INSERT INTO `sys_user_role` VALUES (669, 119); INSERT INTO `sys_user_role` VALUES (670, 119); INSERT INTO `sys_user_role` VALUES (671, 119); INSERT INTO `sys_user_role` VALUES (672, 137); INSERT INTO `sys_user_role` VALUES (673, 119); INSERT INTO `sys_user_role` VALUES (674, 119); INSERT INTO `sys_user_role` VALUES (675, 119); INSERT INTO `sys_user_role` VALUES (676, 119); INSERT INTO `sys_user_role` VALUES (677, 137); INSERT INTO `sys_user_role` VALUES (678, 119); INSERT INTO `sys_user_role` VALUES (679, 119); INSERT INTO `sys_user_role` VALUES (680, 119); INSERT INTO `sys_user_role` VALUES (681, 119); INSERT INTO `sys_user_role` VALUES (682, 119); INSERT INTO `sys_user_role` VALUES (683, 119); INSERT INTO `sys_user_role` VALUES (684, 119); INSERT INTO `sys_user_role` VALUES (685, 119); INSERT INTO `sys_user_role` VALUES (686, 119); INSERT INTO `sys_user_role` VALUES (687, 119); INSERT INTO `sys_user_role` VALUES (688, 119); INSERT INTO `sys_user_role` VALUES (689, 119); INSERT INTO `sys_user_role` VALUES (690, 119); INSERT INTO `sys_user_role` VALUES (691, 119); INSERT INTO `sys_user_role` VALUES (692, 119); INSERT INTO `sys_user_role` VALUES (693, 119); INSERT INTO `sys_user_role` VALUES (694, 124); INSERT INTO `sys_user_role` VALUES (695, 119); INSERT INTO `sys_user_role` VALUES (696, 119); INSERT INTO `sys_user_role` VALUES (697, 119); INSERT INTO `sys_user_role` VALUES (698, 119); INSERT INTO `sys_user_role` VALUES (699, 119); INSERT INTO `sys_user_role` VALUES (700, 119); INSERT INTO `sys_user_role` VALUES (701, 119); INSERT INTO `sys_user_role` VALUES (702, 119); INSERT INTO `sys_user_role` VALUES (703, 119); INSERT INTO `sys_user_role` VALUES (704, 119); INSERT INTO `sys_user_role` VALUES (705, 119); INSERT INTO `sys_user_role` VALUES (706, 119); INSERT INTO `sys_user_role` VALUES (707, 119); INSERT INTO `sys_user_role` VALUES (708, 119); INSERT INTO `sys_user_role` VALUES (709, 119); INSERT INTO `sys_user_role` VALUES (710, 119); INSERT INTO `sys_user_role` VALUES (711, 119); INSERT INTO `sys_user_role` VALUES (712, 119); INSERT INTO `sys_user_role` VALUES (713, 119); INSERT INTO `sys_user_role` VALUES (714, 119); INSERT INTO `sys_user_role` VALUES (715, 119); INSERT INTO `sys_user_role` VALUES (716, 119); INSERT INTO `sys_user_role` VALUES (717, 119); INSERT INTO `sys_user_role` VALUES (718, 119); INSERT INTO `sys_user_role` VALUES (719, 119); INSERT INTO `sys_user_role` VALUES (720, 119); INSERT INTO `sys_user_role` VALUES (721, 119); INSERT INTO `sys_user_role` VALUES (722, 119); INSERT INTO `sys_user_role` VALUES (723, 119); INSERT INTO `sys_user_role` VALUES (724, 119); INSERT INTO `sys_user_role` VALUES (725, 119); INSERT INTO `sys_user_role` VALUES (726, 119); INSERT INTO `sys_user_role` VALUES (727, 119); INSERT INTO `sys_user_role` VALUES (728, 119); INSERT INTO `sys_user_role` VALUES (729, 119); INSERT INTO `sys_user_role` VALUES (730, 119); INSERT INTO `sys_user_role` VALUES (731, 124); INSERT INTO `sys_user_role` VALUES (732, 119); INSERT INTO `sys_user_role` VALUES (733, 119); INSERT INTO `sys_user_role` VALUES (734, 119); INSERT INTO `sys_user_role` VALUES (735, 119); INSERT INTO `sys_user_role` VALUES (736, 124); INSERT INTO `sys_user_role` VALUES (737, 119); INSERT INTO `sys_user_role` VALUES (739, 127); INSERT INTO `sys_user_role` VALUES (740, 124); INSERT INTO `sys_user_role` VALUES (741, 124); INSERT INTO `sys_user_role` VALUES (742, 124); INSERT INTO `sys_user_role` VALUES (743, 124); INSERT INTO `sys_user_role` VALUES (744, 137); INSERT INTO `sys_user_role` VALUES (745, 119); INSERT INTO `sys_user_role` VALUES (746, 119); INSERT INTO `sys_user_role` VALUES (747, 119); INSERT INTO `sys_user_role` VALUES (748, 124); INSERT INTO `sys_user_role` VALUES (749, 119); INSERT INTO `sys_user_role` VALUES (754, 119); INSERT INTO `sys_user_role` VALUES (755, 119); INSERT INTO `sys_user_role` VALUES (756, 137); INSERT INTO `sys_user_role` VALUES (757, 124); INSERT INTO `sys_user_role` VALUES (758, 119); INSERT INTO `sys_user_role` VALUES (759, 119); INSERT INTO `sys_user_role` VALUES (763, 129); INSERT INTO `sys_user_role` VALUES (764, 124); INSERT INTO `sys_user_role` VALUES (765, 119); INSERT INTO `sys_user_role` VALUES (766, 119); INSERT INTO `sys_user_role` VALUES (767, 119); INSERT INTO `sys_user_role` VALUES (768, 124); INSERT INTO `sys_user_role` VALUES (769, 119); INSERT INTO `sys_user_role` VALUES (770, 137); INSERT INTO `sys_user_role` VALUES (771, 119); INSERT INTO `sys_user_role` VALUES (772, 119); INSERT INTO `sys_user_role` VALUES (773, 122); INSERT INTO `sys_user_role` VALUES (774, 127); INSERT INTO `sys_user_role` VALUES (775, 119); INSERT INTO `sys_user_role` VALUES (776, 119); INSERT INTO `sys_user_role` VALUES (777, 124); INSERT INTO `sys_user_role` VALUES (778, 137); INSERT INTO `sys_user_role` VALUES (779, 119); INSERT INTO `sys_user_role` VALUES (780, 119); INSERT INTO `sys_user_role` VALUES (781, 119); INSERT INTO `sys_user_role` VALUES (782, 119); INSERT INTO `sys_user_role` VALUES (783, 124); INSERT INTO `sys_user_role` VALUES (784, 137); INSERT INTO `sys_user_role` VALUES (785, 119); INSERT INTO `sys_user_role` VALUES (786, 119); INSERT INTO `sys_user_role` VALUES (787, 119); INSERT INTO `sys_user_role` VALUES (788, 119); INSERT INTO `sys_user_role` VALUES (789, 124); INSERT INTO `sys_user_role` VALUES (790, 137); INSERT INTO `sys_user_role` VALUES (791, 119); INSERT INTO `sys_user_role` VALUES (794, 119); INSERT INTO `sys_user_role` VALUES (796, 119); INSERT INTO `sys_user_role` VALUES (797, 119); INSERT INTO `sys_user_role` VALUES (798, 119); INSERT INTO `sys_user_role` VALUES (799, 137); INSERT INTO `sys_user_role` VALUES (800, 124); INSERT INTO `sys_user_role` VALUES (801, 124); INSERT INTO `sys_user_role` VALUES (802, 137); INSERT INTO `sys_user_role` VALUES (803, 119); INSERT INTO `sys_user_role` VALUES (804, 119); INSERT INTO `sys_user_role` VALUES (805, 119); INSERT INTO `sys_user_role` VALUES (806, 119); INSERT INTO `sys_user_role` VALUES (807, 119); INSERT INTO `sys_user_role` VALUES (808, 119); INSERT INTO `sys_user_role` VALUES (809, 125); INSERT INTO `sys_user_role` VALUES (810, 119); INSERT INTO `sys_user_role` VALUES (811, 119); INSERT INTO `sys_user_role` VALUES (812, 119); INSERT INTO `sys_user_role` VALUES (813, 119); INSERT INTO `sys_user_role` VALUES (814, 119); INSERT INTO `sys_user_role` VALUES (815, 119); INSERT INTO `sys_user_role` VALUES (816, 119); INSERT INTO `sys_user_role` VALUES (817, 119); INSERT INTO `sys_user_role` VALUES (818, 119); INSERT INTO `sys_user_role` VALUES (820, 119); INSERT INTO `sys_user_role` VALUES (821, 119); INSERT INTO `sys_user_role` VALUES (822, 119); INSERT INTO `sys_user_role` VALUES (823, 119); INSERT INTO `sys_user_role` VALUES (824, 119); INSERT INTO `sys_user_role` VALUES (825, 119); INSERT INTO `sys_user_role` VALUES (826, 119); INSERT INTO `sys_user_role` VALUES (827, 119); INSERT INTO `sys_user_role` VALUES (828, 119); INSERT INTO `sys_user_role` VALUES (829, 127); INSERT INTO `sys_user_role` VALUES (830, 125); INSERT INTO `sys_user_role` VALUES (831, 125); INSERT INTO `sys_user_role` VALUES (832, 122); INSERT INTO `sys_user_role` VALUES (833, 122); INSERT INTO `sys_user_role` VALUES (834, 124); INSERT INTO `sys_user_role` VALUES (835, 137); INSERT INTO `sys_user_role` VALUES (836, 119); INSERT INTO `sys_user_role` VALUES (837, 119); INSERT INTO `sys_user_role` VALUES (838, 119); INSERT INTO `sys_user_role` VALUES (839, 119); INSERT INTO `sys_user_role` VALUES (840, 125); INSERT INTO `sys_user_role` VALUES (841, 127); INSERT INTO `sys_user_role` VALUES (842, 124); INSERT INTO `sys_user_role` VALUES (843, 119); INSERT INTO `sys_user_role` VALUES (844, 137); INSERT INTO `sys_user_role` VALUES (845, 119); INSERT INTO `sys_user_role` VALUES (846, 119); INSERT INTO `sys_user_role` VALUES (847, 137); INSERT INTO `sys_user_role` VALUES (848, 119); INSERT INTO `sys_user_role` VALUES (849, 119); INSERT INTO `sys_user_role` VALUES (850, 119); INSERT INTO `sys_user_role` VALUES (851, 119); INSERT INTO `sys_user_role` VALUES (852, 119); INSERT INTO `sys_user_role` VALUES (853, 127); INSERT INTO `sys_user_role` VALUES (854, 124); INSERT INTO `sys_user_role` VALUES (855, 119); INSERT INTO `sys_user_role` VALUES (856, 137); INSERT INTO `sys_user_role` VALUES (857, 137); INSERT INTO `sys_user_role` VALUES (858, 119); INSERT INTO `sys_user_role` VALUES (859, 119); INSERT INTO `sys_user_role` VALUES (860, 124); INSERT INTO `sys_user_role` VALUES (861, 119); INSERT INTO `sys_user_role` VALUES (862, 119); INSERT INTO `sys_user_role` VALUES (863, 119); INSERT INTO `sys_user_role` VALUES (864, 137); INSERT INTO `sys_user_role` VALUES (865, 124); INSERT INTO `sys_user_role` VALUES (866, 137); INSERT INTO `sys_user_role` VALUES (867, 119); INSERT INTO `sys_user_role` VALUES (868, 119); INSERT INTO `sys_user_role` VALUES (869, 119); INSERT INTO `sys_user_role` VALUES (870, 119); INSERT INTO `sys_user_role` VALUES (871, 119); INSERT INTO `sys_user_role` VALUES (872, 119); INSERT INTO `sys_user_role` VALUES (873, 119); INSERT INTO `sys_user_role` VALUES (874, 119); INSERT INTO `sys_user_role` VALUES (875, 124); INSERT INTO `sys_user_role` VALUES (876, 137); INSERT INTO `sys_user_role` VALUES (877, 119); INSERT INTO `sys_user_role` VALUES (878, 119); INSERT INTO `sys_user_role` VALUES (879, 119); INSERT INTO `sys_user_role` VALUES (880, 119); INSERT INTO `sys_user_role` VALUES (881, 119); INSERT INTO `sys_user_role` VALUES (882, 119); INSERT INTO `sys_user_role` VALUES (883, 119); INSERT INTO `sys_user_role` VALUES (884, 127); INSERT INTO `sys_user_role` VALUES (885, 119); INSERT INTO `sys_user_role` VALUES (886, 119); INSERT INTO `sys_user_role` VALUES (887, 119); INSERT INTO `sys_user_role` VALUES (888, 119); INSERT INTO `sys_user_role` VALUES (889, 119); INSERT INTO `sys_user_role` VALUES (890, 119); INSERT INTO `sys_user_role` VALUES (891, 119); INSERT INTO `sys_user_role` VALUES (892, 119); INSERT INTO `sys_user_role` VALUES (893, 119); INSERT INTO `sys_user_role` VALUES (894, 124); INSERT INTO `sys_user_role` VALUES (895, 124); INSERT INTO `sys_user_role` VALUES (896, 119); INSERT INTO `sys_user_role` VALUES (897, 137); INSERT INTO `sys_user_role` VALUES (898, 124); INSERT INTO `sys_user_role` VALUES (899, 119); INSERT INTO `sys_user_role` VALUES (900, 119); INSERT INTO `sys_user_role` VALUES (901, 119); INSERT INTO `sys_user_role` VALUES (902, 137); INSERT INTO `sys_user_role` VALUES (903, 137); INSERT INTO `sys_user_role` VALUES (904, 124); INSERT INTO `sys_user_role` VALUES (905, 137); INSERT INTO `sys_user_role` VALUES (906, 119); INSERT INTO `sys_user_role` VALUES (907, 119); INSERT INTO `sys_user_role` VALUES (908, 119); INSERT INTO `sys_user_role` VALUES (909, 127); INSERT INTO `sys_user_role` VALUES (910, 124); INSERT INTO `sys_user_role` VALUES (911, 137); INSERT INTO `sys_user_role` VALUES (912, 119); INSERT INTO `sys_user_role` VALUES (913, 124); INSERT INTO `sys_user_role` VALUES (914, 137); INSERT INTO `sys_user_role` VALUES (915, 137); INSERT INTO `sys_user_role` VALUES (916, 119); INSERT INTO `sys_user_role` VALUES (917, 119); INSERT INTO `sys_user_role` VALUES (918, 119); INSERT INTO `sys_user_role` VALUES (919, 119); INSERT INTO `sys_user_role` VALUES (920, 119); INSERT INTO `sys_user_role` VALUES (921, 119); INSERT INTO `sys_user_role` VALUES (922, 119); INSERT INTO `sys_user_role` VALUES (923, 119); INSERT INTO `sys_user_role` VALUES (924, 119); INSERT INTO `sys_user_role` VALUES (925, 119); INSERT INTO `sys_user_role` VALUES (926, 119); INSERT INTO `sys_user_role` VALUES (927, 119); INSERT INTO `sys_user_role` VALUES (928, 119); INSERT INTO `sys_user_role` VALUES (929, 119); INSERT INTO `sys_user_role` VALUES (930, 119); INSERT INTO `sys_user_role` VALUES (931, 119); INSERT INTO `sys_user_role` VALUES (932, 119); INSERT INTO `sys_user_role` VALUES (933, 119); INSERT INTO `sys_user_role` VALUES (934, 119); INSERT INTO `sys_user_role` VALUES (935, 119); INSERT INTO `sys_user_role` VALUES (936, 124); INSERT INTO `sys_user_role` VALUES (937, 119); INSERT INTO `sys_user_role` VALUES (938, 128); INSERT INTO `sys_user_role` VALUES (939, 119); INSERT INTO `sys_user_role` VALUES (940, 119); INSERT INTO `sys_user_role` VALUES (941, 119); INSERT INTO `sys_user_role` VALUES (942, 119); INSERT INTO `sys_user_role` VALUES (943, 119); 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); INSERT INTO `sys_user_role` VALUES (950, 140); -- ---------------------------- -- Table structure for undo_log -- ---------------------------- DROP TABLE IF EXISTS `undo_log`; CREATE TABLE `undo_log` ( `branch_id` bigint NOT NULL COMMENT 'branch transaction id', `xid` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'global transaction id', `context` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'undo_log context,such as serialization', `rollback_info` longblob NOT NULL COMMENT 'rollback info', `log_status` int 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` ASC, `branch_id` ASC) USING BTREE, INDEX `ix_log_created`(`log_created` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'AT transaction mode undo table' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of undo_log -- ---------------------------- -- ---------------------------- -- Table structure for xp_app_user_coupon -- ---------------------------- DROP TABLE IF EXISTS `xp_app_user_coupon`; CREATE TABLE `xp_app_user_coupon` ( `id` bigint NOT NULL AUTO_INCREMENT, `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=已过期 0=待领取)', `coupon_type` int NOT NULL DEFAULT 1 COMMENT '优惠券类型(1=抵扣，2=满减)', `app_user_id` bigint NOT NULL COMMENT '用户id', `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号', `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 '修改时间', `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, 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 AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户优惠券' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of xp_app_user_coupon -- ---------------------------- INSERT INTO `xp_app_user_coupon` VALUES (2, 10.00, 10.00, '2026-03-08 09:16:43', 1, 1, 1, NULL, 1, 1, NULL, '优惠券', 1, '[{\"time\": [\"08:00-12:00\", \"13:30-17:30\", \"17:30-23:59\"], \"type\": 3, \"typeStr\": 0}]', NULL, 0, '2026-02-26 09:17:52', '2026-02-26 09:45:15', '', ''); -- ---------------------------- -- Table structure for xp_app_user_coupon_0 -- ---------------------------- DROP TABLE IF EXISTS `xp_app_user_coupon_0`; CREATE TABLE `xp_app_user_coupon_0` ( `id` bigint NOT NULL, `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=已过期 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 '修改时间', `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 '修改人', `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号', PRIMARY KEY (`id`) USING BTREE, 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; -- ---------------------------- -- Records of xp_app_user_coupon_0 -- ---------------------------- INSERT INTO `xp_app_user_coupon_0` VALUES (1, 10.00, 10.00, '2026-03-08 09:16:43', 1, 1, 1, 1, 1, NULL, '优惠券', 1, '[{\"time\": [\"08:00-12:00\", \"13:30-17:30\", \"17:30-23:59\"], \"type\": 3, \"typeStr\": 0}]', NULL, 0, '2026-02-26 09:17:52', '2026-02-26 09:18:41', '', '', NULL); -- ---------------------------- -- Table structure for xp_app_user_coupon_1 -- ---------------------------- DROP TABLE IF EXISTS `xp_app_user_coupon_1`; CREATE TABLE `xp_app_user_coupon_1` ( `id` bigint NOT NULL, `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=已过期 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 '修改时间', `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 '修改人', `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号', PRIMARY KEY (`id`) USING BTREE, 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; -- ---------------------------- -- Records of xp_app_user_coupon_1 -- ---------------------------- INSERT INTO `xp_app_user_coupon_1` VALUES (3, 10.00, 10.00, '2026-01-01 09:16:43', 1, 1, 1, 1, 1, NULL, '优惠券', 1, '[{\"time\": [\"08:00-12:00\", \"13:30-17:30\", \"17:30-23:59\"], \"type\": 3, \"typeStr\": 0}]', NULL, 0, '2026-02-26 09:17:52', '2026-02-26 11:10:09', '', '', '18888888888'); INSERT INTO `xp_app_user_coupon_1` VALUES (4, 10.00, 10.00, '2026-08-01 09:16:43', 1, 1, 1, 1, 1, NULL, '优惠券', 1, '[{\"time\": [\"08:00-12:00\", \"13:30-17:30\", \"17:30-23:59\"], \"type\": 3, \"typeStr\": 0}]', NULL, 0, '2026-02-26 09:17:52', '2026-02-26 11:10:10', '', '', '18888888888'); -- ---------------------------- -- Table structure for xp_app_user_coupon_10 -- ---------------------------- DROP TABLE IF EXISTS `xp_app_user_coupon_10`; CREATE TABLE `xp_app_user_coupon_10` ( `id` bigint NOT NULL, `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=已过期 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 '修改时间', `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 '修改人', `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号', PRIMARY KEY (`id`) USING BTREE, 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; -- ---------------------------- -- Records of xp_app_user_coupon_10 -- ---------------------------- -- ---------------------------- -- Table structure for xp_app_user_coupon_11 -- ---------------------------- DROP TABLE IF EXISTS `xp_app_user_coupon_11`; CREATE TABLE `xp_app_user_coupon_11` ( `id` bigint NOT NULL, `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=已过期 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 '修改时间', `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 '修改人', `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号', PRIMARY KEY (`id`) USING BTREE, 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; -- ---------------------------- -- Records of xp_app_user_coupon_11 -- ---------------------------- -- ---------------------------- -- Table structure for xp_app_user_coupon_12 -- ---------------------------- DROP TABLE IF EXISTS `xp_app_user_coupon_12`; CREATE TABLE `xp_app_user_coupon_12` ( `id` bigint NOT NULL, `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=已过期 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 '修改时间', `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 '修改人', `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号', PRIMARY KEY (`id`) USING BTREE, 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; -- ---------------------------- -- Records of xp_app_user_coupon_12 -- ---------------------------- -- ---------------------------- -- Table structure for xp_app_user_coupon_13 -- ---------------------------- DROP TABLE IF EXISTS `xp_app_user_coupon_13`; CREATE TABLE `xp_app_user_coupon_13` ( `id` bigint NOT NULL, `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=已过期 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 '修改时间', `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 '修改人', `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号', PRIMARY KEY (`id`) USING BTREE, 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; -- ---------------------------- -- Records of xp_app_user_coupon_13 -- ---------------------------- -- ---------------------------- -- Table structure for xp_app_user_coupon_14 -- ---------------------------- DROP TABLE IF EXISTS `xp_app_user_coupon_14`; CREATE TABLE `xp_app_user_coupon_14` ( `id` bigint NOT NULL, `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=已过期 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 '修改时间', `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 '修改人', `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号', PRIMARY KEY (`id`) USING BTREE, 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; -- ---------------------------- -- Records of xp_app_user_coupon_14 -- ---------------------------- -- ---------------------------- -- Table structure for xp_app_user_coupon_15 -- ---------------------------- DROP TABLE IF EXISTS `xp_app_user_coupon_15`; CREATE TABLE `xp_app_user_coupon_15` ( `id` bigint NOT NULL, `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=已过期 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 '修改时间', `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 '修改人', `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号', PRIMARY KEY (`id`) USING BTREE, 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; -- ---------------------------- -- Records of xp_app_user_coupon_15 -- ---------------------------- -- ---------------------------- -- Table structure for xp_app_user_coupon_16 -- ---------------------------- DROP TABLE IF EXISTS `xp_app_user_coupon_16`; CREATE TABLE `xp_app_user_coupon_16` ( `id` bigint NOT NULL, `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=已过期 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 '修改时间', `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 '修改人', `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号', PRIMARY KEY (`id`) USING BTREE, 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; -- ---------------------------- -- Records of xp_app_user_coupon_16 -- ---------------------------- -- ---------------------------- -- Table structure for xp_app_user_coupon_17 -- ---------------------------- DROP TABLE IF EXISTS `xp_app_user_coupon_17`; CREATE TABLE `xp_app_user_coupon_17` ( `id` bigint NOT NULL, `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=已过期 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 '修改时间', `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 '修改人', `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号', PRIMARY KEY (`id`) USING BTREE, 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; -- ---------------------------- -- Records of xp_app_user_coupon_17 -- ---------------------------- -- ---------------------------- -- Table structure for xp_app_user_coupon_18 -- ---------------------------- DROP TABLE IF EXISTS `xp_app_user_coupon_18`; CREATE TABLE `xp_app_user_coupon_18` ( `id` bigint NOT NULL, `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=已过期 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 '修改时间', `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 '修改人', `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号', PRIMARY KEY (`id`) USING BTREE, 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; -- ---------------------------- -- Records of xp_app_user_coupon_18 -- ---------------------------- -- ---------------------------- -- Table structure for xp_app_user_coupon_19 -- ---------------------------- DROP TABLE IF EXISTS `xp_app_user_coupon_19`; CREATE TABLE `xp_app_user_coupon_19` ( `id` bigint NOT NULL, `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=已过期 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 '修改时间', `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 '修改人', `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号', PRIMARY KEY (`id`) USING BTREE, 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; -- ---------------------------- -- Records of xp_app_user_coupon_19 -- ---------------------------- -- ---------------------------- -- Table structure for xp_app_user_coupon_2 -- ---------------------------- DROP TABLE IF EXISTS `xp_app_user_coupon_2`; CREATE TABLE `xp_app_user_coupon_2` ( `id` bigint NOT NULL, `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=已过期 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 '修改时间', `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 '修改人', `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号', PRIMARY KEY (`id`) USING BTREE, 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; -- ---------------------------- -- Records of xp_app_user_coupon_2 -- ---------------------------- -- ---------------------------- -- Table structure for xp_app_user_coupon_3 -- ---------------------------- DROP TABLE IF EXISTS `xp_app_user_coupon_3`; CREATE TABLE `xp_app_user_coupon_3` ( `id` bigint NOT NULL, `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=已过期 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 '修改时间', `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 '修改人', `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号', PRIMARY KEY (`id`) USING BTREE, 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; -- ---------------------------- -- Records of xp_app_user_coupon_3 -- ---------------------------- -- ---------------------------- -- Table structure for xp_app_user_coupon_4 -- ---------------------------- DROP TABLE IF EXISTS `xp_app_user_coupon_4`; CREATE TABLE `xp_app_user_coupon_4` ( `id` bigint NOT NULL, `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=已过期 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 '修改时间', `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 '修改人', `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号', PRIMARY KEY (`id`) USING BTREE, 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; -- ---------------------------- -- Records of xp_app_user_coupon_4 -- ---------------------------- -- ---------------------------- -- Table structure for xp_app_user_coupon_5 -- ---------------------------- DROP TABLE IF EXISTS `xp_app_user_coupon_5`; CREATE TABLE `xp_app_user_coupon_5` ( `id` bigint NOT NULL, `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=已过期 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 '修改时间', `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 '修改人', `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号', PRIMARY KEY (`id`) USING BTREE, 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; -- ---------------------------- -- Records of xp_app_user_coupon_5 -- ---------------------------- -- ---------------------------- -- Table structure for xp_app_user_coupon_6 -- ---------------------------- DROP TABLE IF EXISTS `xp_app_user_coupon_6`; CREATE TABLE `xp_app_user_coupon_6` ( `id` bigint NOT NULL, `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=已过期 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 '修改时间', `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 '修改人', `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号', PRIMARY KEY (`id`) USING BTREE, 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; -- ---------------------------- -- Records of xp_app_user_coupon_6 -- ---------------------------- -- ---------------------------- -- Table structure for xp_app_user_coupon_7 -- ---------------------------- DROP TABLE IF EXISTS `xp_app_user_coupon_7`; CREATE TABLE `xp_app_user_coupon_7` ( `id` bigint NOT NULL, `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=已过期 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 '修改时间', `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 '修改人', `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号', PRIMARY KEY (`id`) USING BTREE, 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; -- ---------------------------- -- Records of xp_app_user_coupon_7 -- ---------------------------- -- ---------------------------- -- Table structure for xp_app_user_coupon_8 -- ---------------------------- DROP TABLE IF EXISTS `xp_app_user_coupon_8`; CREATE TABLE `xp_app_user_coupon_8` ( `id` bigint NOT NULL, `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=已过期 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 '修改时间', `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 '修改人', `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号', PRIMARY KEY (`id`) USING BTREE, 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; -- ---------------------------- -- Records of xp_app_user_coupon_8 -- ---------------------------- -- ---------------------------- -- Table structure for xp_app_user_coupon_9 -- ---------------------------- DROP TABLE IF EXISTS `xp_app_user_coupon_9`; CREATE TABLE `xp_app_user_coupon_9` ( `id` bigint NOT NULL, `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=已过期 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 '修改时间', `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 '修改人', `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号', PRIMARY KEY (`id`) USING BTREE, 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; -- ---------------------------- -- Records of xp_app_user_coupon_9 -- ---------------------------- -- ---------------------------- -- Table structure for xp_operations_position -- ---------------------------- DROP TABLE IF EXISTS `xp_operations_position`; CREATE TABLE `xp_operations_position` ( `operations_user_id` bigint NOT NULL COMMENT '运维人员id', `position_id` bigint NOT NULL COMMENT '岗位id', PRIMARY KEY (`operations_user_id`, `position_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '运维人员岗位中间表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of xp_operations_position -- ---------------------------- -- ---------------------------- -- Table structure for xp_operations_role -- ---------------------------- DROP TABLE IF EXISTS `xp_operations_role`; CREATE TABLE `xp_operations_role` ( `operations_user_id` bigint NOT NULL COMMENT '运维人员id', `role_id` bigint NOT NULL COMMENT '角色id', PRIMARY KEY (`operations_user_id`, `role_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '运维人员角色中间表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of xp_operations_role -- ---------------------------- -- ---------------------------- -- Table structure for xp_operations_user -- ---------------------------- DROP TABLE IF EXISTS `xp_operations_user`; CREATE TABLE `xp_operations_user` ( `id` bigint NOT NULL AUTO_INCREMENT, `nick_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '名称', `unique_number` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '唯一编号', `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '头像', `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '密码', `phone_number` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '手机号', `remarks` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '备注', `status` tinyint(1) NULL DEFAULT NULL COMMENT '状态 1=启用 0=禁用', `id_card_front` json NULL COMMENT '身份证正面', `id_card_back` json NULL COMMENT '身份证背面', `driver_license` json NULL COMMENT '驾驶证', `certificate_of_no_criminal_record` json NULL COMMENT '无犯罪记录正面', `training_graduation_certificate` json NULL COMMENT '培训结业证', `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 '修改时间', `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 = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '运维人员' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of xp_operations_user -- ---------------------------- INSERT INTO `xp_operations_user` VALUES (1, '13540694412', '13540694412', '', '$2a$10$MfYilBHA77EgemfzNoTwvet8BOOgDAcrKI3c7/pdDds09SXCOy4f2', '13540694412', '', 1, '{\"id\": \"5712c89d-aebf-4bef-a40e-6fb8112ef2b8\", \"url\": \"https://we-park-life.oss-cn-beijing.aliyuncs.com/img/K4vqtLmVc6.png\", \"name\": \"测试.jpg\"}', '{\"id\": \"a073c469-f070-4597-ba4d-6272726ae14e\", \"url\": \"https://we-park-life.oss-cn-beijing.aliyuncs.com/img/K4vqtLmVc6.png\", \"name\": \"测试.jpg\"}', '{\"id\": \"6b3c130a-9e4c-4d9c-8b70-1e27a5f368bf\", \"url\": \"https://we-park-life.oss-cn-beijing.aliyuncs.com/img/K4vqtLmVc6.png\", \"name\": \"测试.jpg\"}', '{\"id\": \"c6ae6729-11dd-4e29-8bd2-01500ac4e3e0\", \"url\": \"https://we-park-life.oss-cn-beijing.aliyuncs.com/img/K4vqtLmVc6.png\", \"name\": \"测试.jpg\"}', '{\"id\": \"01df547e-df15-4fca-9ee8-ee81690ae204\", \"url\": \"https://we-park-life.oss-cn-beijing.aliyuncs.com/img/K4vqtLmVc6.png\", \"name\": \"测试.jpg\"}', 0, '2026-02-23 21:43:31', '2026-02-24 18:44:51', '', ''); INSERT INTO `xp_operations_user` VALUES (2, '18981886651', '18981886651', '', '$2a$10$MfYilBHA77EgemfzNoTwvet8BOOgDAcrKI3c7/pdDds09SXCOy4f2', '18981886651', '', 1, NULL, NULL, NULL, NULL, NULL, 0, '2026-02-23 21:43:56', '2026-02-24 08:59:53', '', ''); INSERT INTO `xp_operations_user` VALUES (3, '13880841924', '13880841924', '', '$2a$10$MfYilBHA77EgemfzNoTwvet8BOOgDAcrKI3c7/pdDds09SXCOy4f2', '13880841924', '', 1, '{\"id\": \"386242ab-aef3-47a6-91f5-074eb90a2737\", \"url\": \"https://we-park-life.oss-cn-beijing.aliyuncs.com/img/K4vqtLmVc6.png\", \"name\": \"测试.jpg\"}', '{\"id\": \"20c95e47-ee71-4073-8c44-365fceefcd37\", \"url\": \"https://we-park-life.oss-cn-beijing.aliyuncs.com/img/K4vqtLmVc6.png\", \"name\": \"测试.jpg\"}', '{\"id\": \"51ea0435-3d99-4cf7-ba87-4f9201d7e76c\", \"url\": \"https://we-park-life.oss-cn-beijing.aliyuncs.com/img/K4vqtLmVc6.png\", \"name\": \"测试.jpg\"}', '{\"id\": \"e79863a0-e27e-477c-a5f4-ccf0025e8f1d\", \"url\": \"https://we-park-life.oss-cn-beijing.aliyuncs.com/img/K4vqtLmVc6.png\", \"name\": \"测试.jpg\"}', '{\"id\": \"1dcacb42-0949-495d-bf81-769c993eca10\", \"url\": \"https://we-park-life.oss-cn-beijing.aliyuncs.com/img/K4vqtLmVc6.png\", \"name\": \"测试.jpg\"}', 0, '2026-02-23 21:44:28', '2026-02-24 22:12:21', '', ''); INSERT INTO `xp_operations_user` VALUES (4, '13980792023', '13980792023', '', '$2a$10$MfYilBHA77EgemfzNoTwvet8BOOgDAcrKI3c7/pdDds09SXCOy4f2', '13980792023', '', 1, NULL, NULL, NULL, NULL, NULL, 0, '2026-02-23 21:44:33', '2026-02-24 08:59:54', '', ''); -- ---------------------------- -- Table structure for xp_operations_user_notification -- ---------------------------- DROP TABLE IF EXISTS `xp_operations_user_notification`; CREATE TABLE `xp_operations_user_notification` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id', `notification_type` int NOT NULL DEFAULT 1 COMMENT '通知类型1新任务通知 2任务状态通知 3排班变动通知 4公告通知 5新事故通知 6事故状态通知', `notification_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '通知内容', `operations_user_id` bigint NOT NULL COMMENT '通知人员id', `data_id` bigint NOT 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 '修改时间', `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 = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '运维人员消息通知表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of xp_operations_user_notification -- ---------------------------- -- ---------------------------- -- Table structure for xp_operations_user_notification_0 -- ---------------------------- DROP TABLE IF EXISTS `xp_operations_user_notification_0`; CREATE TABLE `xp_operations_user_notification_0` ( `id` bigint NOT NULL COMMENT '自增id', `notification_type` int NOT NULL DEFAULT 1 COMMENT '通知类型1新任务通知 2任务状态通知 3排班变动通知 4公告通知 5新事故通知 6事故状态通知', `notification_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '通知内容', `operations_user_id` bigint NOT NULL COMMENT '通知人员id', `data_id` bigint NOT 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 '修改时间', `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; -- ---------------------------- -- Records of xp_operations_user_notification_0 -- ---------------------------- -- ---------------------------- -- Table structure for xp_operations_user_notification_1 -- ---------------------------- DROP TABLE IF EXISTS `xp_operations_user_notification_1`; CREATE TABLE `xp_operations_user_notification_1` ( `id` bigint NOT NULL COMMENT '自增id', `notification_type` int NOT NULL DEFAULT 1 COMMENT '通知类型1新任务通知 2任务状态通知 3排班变动通知 4公告通知 5新事故通知 6事故状态通知', `notification_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '通知内容', `operations_user_id` bigint NOT NULL COMMENT '通知人员id', `data_id` bigint NOT 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 '修改时间', `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; -- ---------------------------- -- Records of xp_operations_user_notification_1 -- ---------------------------- -- ---------------------------- -- Table structure for xp_operations_user_notification_10 -- ---------------------------- DROP TABLE IF EXISTS `xp_operations_user_notification_10`; CREATE TABLE `xp_operations_user_notification_10` ( `id` bigint NOT NULL COMMENT '自增id', `notification_type` int NOT NULL DEFAULT 1 COMMENT '通知类型1新任务通知 2任务状态通知 3排班变动通知 4公告通知 5新事故通知 6事故状态通知', `notification_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '通知内容', `operations_user_id` bigint NOT NULL COMMENT '通知人员id', `data_id` bigint NOT 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 '修改时间', `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; -- ---------------------------- -- Records of xp_operations_user_notification_10 -- ---------------------------- -- ---------------------------- -- Table structure for xp_operations_user_notification_11 -- ---------------------------- DROP TABLE IF EXISTS `xp_operations_user_notification_11`; CREATE TABLE `xp_operations_user_notification_11` ( `id` bigint NOT NULL COMMENT '自增id', `notification_type` int NOT NULL DEFAULT 1 COMMENT '通知类型1新任务通知 2任务状态通知 3排班变动通知 4公告通知 5新事故通知 6事故状态通知', `notification_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '通知内容', `operations_user_id` bigint NOT NULL COMMENT '通知人员id', `data_id` bigint NOT 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 '修改时间', `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; -- ---------------------------- -- Records of xp_operations_user_notification_11 -- ---------------------------- -- ---------------------------- -- Table structure for xp_operations_user_notification_12 -- ---------------------------- DROP TABLE IF EXISTS `xp_operations_user_notification_12`; CREATE TABLE `xp_operations_user_notification_12` ( `id` bigint NOT NULL COMMENT '自增id', `notification_type` int NOT NULL DEFAULT 1 COMMENT '通知类型1新任务通知 2任务状态通知 3排班变动通知 4公告通知 5新事故通知 6事故状态通知', `notification_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '通知内容', `operations_user_id` bigint NOT NULL COMMENT '通知人员id', `data_id` bigint NOT 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 '修改时间', `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; -- ---------------------------- -- Records of xp_operations_user_notification_12 -- ---------------------------- -- ---------------------------- -- Table structure for xp_operations_user_notification_13 -- ---------------------------- DROP TABLE IF EXISTS `xp_operations_user_notification_13`; CREATE TABLE `xp_operations_user_notification_13` ( `id` bigint NOT NULL COMMENT '自增id', `notification_type` int NOT NULL DEFAULT 1 COMMENT '通知类型1新任务通知 2任务状态通知 3排班变动通知 4公告通知 5新事故通知 6事故状态通知', `notification_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '通知内容', `operations_user_id` bigint NOT NULL COMMENT '通知人员id', `data_id` bigint NOT 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 '修改时间', `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; -- ---------------------------- -- Records of xp_operations_user_notification_13 -- ---------------------------- -- ---------------------------- -- Table structure for xp_operations_user_notification_14 -- ---------------------------- DROP TABLE IF EXISTS `xp_operations_user_notification_14`; CREATE TABLE `xp_operations_user_notification_14` ( `id` bigint NOT NULL COMMENT '自增id', `notification_type` int NOT NULL DEFAULT 1 COMMENT '通知类型1新任务通知 2任务状态通知 3排班变动通知 4公告通知 5新事故通知 6事故状态通知', `notification_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '通知内容', `operations_user_id` bigint NOT NULL COMMENT '通知人员id', `data_id` bigint NOT 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 '修改时间', `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; -- ---------------------------- -- Records of xp_operations_user_notification_14 -- ---------------------------- -- ---------------------------- -- Table structure for xp_operations_user_notification_15 -- ---------------------------- DROP TABLE IF EXISTS `xp_operations_user_notification_15`; CREATE TABLE `xp_operations_user_notification_15` ( `id` bigint NOT NULL COMMENT '自增id', `notification_type` int NOT NULL DEFAULT 1 COMMENT '通知类型1新任务通知 2任务状态通知 3排班变动通知 4公告通知 5新事故通知 6事故状态通知', `notification_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '通知内容', `operations_user_id` bigint NOT NULL COMMENT '通知人员id', `data_id` bigint NOT 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 '修改时间', `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; -- ---------------------------- -- Records of xp_operations_user_notification_15 -- ---------------------------- -- ---------------------------- -- Table structure for xp_operations_user_notification_16 -- ---------------------------- DROP TABLE IF EXISTS `xp_operations_user_notification_16`; CREATE TABLE `xp_operations_user_notification_16` ( `id` bigint NOT NULL COMMENT '自增id', `notification_type` int NOT NULL DEFAULT 1 COMMENT '通知类型1新任务通知 2任务状态通知 3排班变动通知 4公告通知 5新事故通知 6事故状态通知', `notification_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '通知内容', `operations_user_id` bigint NOT NULL COMMENT '通知人员id', `data_id` bigint NOT 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 '修改时间', `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; -- ---------------------------- -- Records of xp_operations_user_notification_16 -- ---------------------------- -- ---------------------------- -- Table structure for xp_operations_user_notification_17 -- ---------------------------- DROP TABLE IF EXISTS `xp_operations_user_notification_17`; CREATE TABLE `xp_operations_user_notification_17` ( `id` bigint NOT NULL COMMENT '自增id', `notification_type` int NOT NULL DEFAULT 1 COMMENT '通知类型1新任务通知 2任务状态通知 3排班变动通知 4公告通知 5新事故通知 6事故状态通知', `notification_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '通知内容', `operations_user_id` bigint NOT NULL COMMENT '通知人员id', `data_id` bigint NOT 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 '修改时间', `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; -- ---------------------------- -- Records of xp_operations_user_notification_17 -- ---------------------------- -- ---------------------------- -- Table structure for xp_operations_user_notification_18 -- ---------------------------- DROP TABLE IF EXISTS `xp_operations_user_notification_18`; CREATE TABLE `xp_operations_user_notification_18` ( `id` bigint NOT NULL COMMENT '自增id', `notification_type` int NOT NULL DEFAULT 1 COMMENT '通知类型1新任务通知 2任务状态通知 3排班变动通知 4公告通知 5新事故通知 6事故状态通知', `notification_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '通知内容', `operations_user_id` bigint NOT NULL COMMENT '通知人员id', `data_id` bigint NOT 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 '修改时间', `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; -- ---------------------------- -- Records of xp_operations_user_notification_18 -- ---------------------------- -- ---------------------------- -- Table structure for xp_operations_user_notification_19 -- ---------------------------- DROP TABLE IF EXISTS `xp_operations_user_notification_19`; CREATE TABLE `xp_operations_user_notification_19` ( `id` bigint NOT NULL COMMENT '自增id', `notification_type` int NOT NULL DEFAULT 1 COMMENT '通知类型1新任务通知 2任务状态通知 3排班变动通知 4公告通知 5新事故通知 6事故状态通知', `notification_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '通知内容', `operations_user_id` bigint NOT NULL COMMENT '通知人员id', `data_id` bigint NOT 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 '修改时间', `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; -- ---------------------------- -- Records of xp_operations_user_notification_19 -- ---------------------------- -- ---------------------------- -- Table structure for xp_operations_user_notification_2 -- ---------------------------- DROP TABLE IF EXISTS `xp_operations_user_notification_2`; CREATE TABLE `xp_operations_user_notification_2` ( `id` bigint NOT NULL COMMENT '自增id', `notification_type` int NOT NULL DEFAULT 1 COMMENT '通知类型1新任务通知 2任务状态通知 3排班变动通知 4公告通知 5新事故通知 6事故状态通知', `notification_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '通知内容', `operations_user_id` bigint NOT NULL COMMENT '通知人员id', `data_id` bigint NOT 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 '修改时间', `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; -- ---------------------------- -- Records of xp_operations_user_notification_2 -- ---------------------------- -- ---------------------------- -- Table structure for xp_operations_user_notification_3 -- ---------------------------- DROP TABLE IF EXISTS `xp_operations_user_notification_3`; CREATE TABLE `xp_operations_user_notification_3` ( `id` bigint NOT NULL COMMENT '自增id', `notification_type` int NOT NULL DEFAULT 1 COMMENT '通知类型1新任务通知 2任务状态通知 3排班变动通知 4公告通知 5新事故通知 6事故状态通知', `notification_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '通知内容', `operations_user_id` bigint NOT NULL COMMENT '通知人员id', `data_id` bigint NOT 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 '修改时间', `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; -- ---------------------------- -- Records of xp_operations_user_notification_3 -- ---------------------------- -- ---------------------------- -- Table structure for xp_operations_user_notification_4 -- ---------------------------- DROP TABLE IF EXISTS `xp_operations_user_notification_4`; CREATE TABLE `xp_operations_user_notification_4` ( `id` bigint NOT NULL COMMENT '自增id', `notification_type` int NOT NULL DEFAULT 1 COMMENT '通知类型1新任务通知 2任务状态通知 3排班变动通知 4公告通知 5新事故通知 6事故状态通知', `notification_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '通知内容', `operations_user_id` bigint NOT NULL COMMENT '通知人员id', `data_id` bigint NOT 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 '修改时间', `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; -- ---------------------------- -- Records of xp_operations_user_notification_4 -- ---------------------------- -- ---------------------------- -- Table structure for xp_operations_user_notification_5 -- ---------------------------- DROP TABLE IF EXISTS `xp_operations_user_notification_5`; CREATE TABLE `xp_operations_user_notification_5` ( `id` bigint NOT NULL COMMENT '自增id', `notification_type` int NOT NULL DEFAULT 1 COMMENT '通知类型1新任务通知 2任务状态通知 3排班变动通知 4公告通知 5新事故通知 6事故状态通知', `notification_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '通知内容', `operations_user_id` bigint NOT NULL COMMENT '通知人员id', `data_id` bigint NOT 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 '修改时间', `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; -- ---------------------------- -- Records of xp_operations_user_notification_5 -- ---------------------------- -- ---------------------------- -- Table structure for xp_operations_user_notification_6 -- ---------------------------- DROP TABLE IF EXISTS `xp_operations_user_notification_6`; CREATE TABLE `xp_operations_user_notification_6` ( `id` bigint NOT NULL COMMENT '自增id', `notification_type` int NOT NULL DEFAULT 1 COMMENT '通知类型1新任务通知 2任务状态通知 3排班变动通知 4公告通知 5新事故通知 6事故状态通知', `notification_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '通知内容', `operations_user_id` bigint NOT NULL COMMENT '通知人员id', `data_id` bigint NOT 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 '修改时间', `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; -- ---------------------------- -- Records of xp_operations_user_notification_6 -- ---------------------------- -- ---------------------------- -- Table structure for xp_operations_user_notification_7 -- ---------------------------- DROP TABLE IF EXISTS `xp_operations_user_notification_7`; CREATE TABLE `xp_operations_user_notification_7` ( `id` bigint NOT NULL COMMENT '自增id', `notification_type` int NOT NULL DEFAULT 1 COMMENT '通知类型1新任务通知 2任务状态通知 3排班变动通知 4公告通知 5新事故通知 6事故状态通知', `notification_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '通知内容', `operations_user_id` bigint NOT NULL COMMENT '通知人员id', `data_id` bigint NOT 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 '修改时间', `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; -- ---------------------------- -- Records of xp_operations_user_notification_7 -- ---------------------------- -- ---------------------------- -- Table structure for xp_operations_user_notification_8 -- ---------------------------- DROP TABLE IF EXISTS `xp_operations_user_notification_8`; CREATE TABLE `xp_operations_user_notification_8` ( `id` bigint NOT NULL COMMENT '自增id', `notification_type` int NOT NULL DEFAULT 1 COMMENT '通知类型1新任务通知 2任务状态通知 3排班变动通知 4公告通知 5新事故通知 6事故状态通知', `notification_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '通知内容', `operations_user_id` bigint NOT NULL COMMENT '通知人员id', `data_id` bigint NOT 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 '修改时间', `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; -- ---------------------------- -- Records of xp_operations_user_notification_8 -- ---------------------------- -- ---------------------------- -- Table structure for xp_operations_user_notification_9 -- ---------------------------- DROP TABLE IF EXISTS `xp_operations_user_notification_9`; CREATE TABLE `xp_operations_user_notification_9` ( `id` bigint NOT NULL COMMENT '自增id', `notification_type` int NOT NULL DEFAULT 1 COMMENT '通知类型1新任务通知 2任务状态通知 3排班变动通知 4公告通知 5新事故通知 6事故状态通知', `notification_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '通知内容', `operations_user_id` bigint NOT NULL COMMENT '通知人员id', `data_id` bigint NOT 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 '修改时间', `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; -- ---------------------------- -- Records of xp_operations_user_notification_9 -- ---------------------------- -- ---------------------------- -- Table structure for xp_qualification_audit -- ---------------------------- DROP TABLE IF EXISTS `xp_qualification_audit`; CREATE TABLE `xp_qualification_audit` ( `id` bigint NOT NULL AUTO_INCREMENT, `operations_user_id` bigint NOT NULL COMMENT '运维人员id', `id_card_front` json NOT NULL COMMENT '身份证正面', `id_card_back` json NOT NULL COMMENT '身份证背面', `driver_license` json NOT NULL COMMENT '驾驶证', `certificate_of_no_criminal_record` json NOT NULL COMMENT '无犯罪记录正面', `training_graduation_certificate` json NOT NULL COMMENT '培训结业证', `audit_user_id` bigint NULL DEFAULT NULL COMMENT '审核人id', `audit_time` datetime NULL DEFAULT NULL COMMENT '审核时间', `audit_status` int NOT NULL DEFAULT 1 COMMENT '审核状态 1待审核 2审核通过 3审核驳回', `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 '修改时间', `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, INDEX `idx_uid`(`operations_user_id` ASC) USING BTREE COMMENT '用户id', INDEX `idx_status`(`audit_status` ASC) USING BTREE COMMENT '状态', INDEX `idx_time`(`audit_time` ASC) USING BTREE COMMENT '时间' ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '运维人员资质证书审核记录' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of xp_qualification_audit -- ---------------------------- SET FOREIGN_KEY_CHECKS = 1;