/*
|
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;
|
