/* 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: 14/02/2026 00:59:38 */ 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 = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '权限组设置' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of sys_group -- ---------------------------- INSERT INTO `sys_group` VALUES (1, '超级管理员', '', 1, 0, '2026-02-09 18:12:12', '2026-02-09 18:12:25', '', ''); INSERT INTO `sys_group` VALUES (4, '管理后台权限', '备注', 1, 0, '2026-02-13 23:13:03', '2026-02-13 23:13:03', '开发', '开发'); -- ---------------------------- -- Table structure for sys_group_menu -- ---------------------------- 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, 110); INSERT INTO `sys_group_menu` VALUES (1, 111); INSERT INTO `sys_group_menu` VALUES (1, 112); INSERT INTO `sys_group_menu` VALUES (1, 113); INSERT INTO `sys_group_menu` VALUES (1, 114); INSERT INTO `sys_group_menu` VALUES (1, 115); INSERT INTO `sys_group_menu` VALUES (1, 116); INSERT INTO `sys_group_menu` VALUES (1, 117); INSERT INTO `sys_group_menu` VALUES (1, 118); INSERT INTO `sys_group_menu` VALUES (1, 119); INSERT INTO `sys_group_menu` VALUES (1, 120); INSERT INTO `sys_group_menu` VALUES (1, 121); INSERT INTO `sys_group_menu` VALUES (1, 122); INSERT INTO `sys_group_menu` VALUES (1, 123); INSERT INTO `sys_group_menu` VALUES (1, 124); INSERT INTO `sys_group_menu` VALUES (1, 125); INSERT INTO `sys_group_menu` VALUES (1, 126); INSERT INTO `sys_group_menu` VALUES (1, 127); INSERT INTO `sys_group_menu` VALUES (1, 128); INSERT INTO `sys_group_menu` VALUES (1, 129); INSERT INTO `sys_group_menu` VALUES (1, 130); INSERT INTO `sys_group_menu` VALUES (1, 131); INSERT INTO `sys_group_menu` VALUES (1, 132); INSERT INTO `sys_group_menu` VALUES (1, 133); INSERT INTO `sys_group_menu` VALUES (1, 134); INSERT INTO `sys_group_menu` VALUES (1, 135); INSERT INTO `sys_group_menu` VALUES (1, 136); INSERT INTO `sys_group_menu` VALUES (1, 137); INSERT INTO `sys_group_menu` VALUES (1, 138); INSERT INTO `sys_group_menu` VALUES (1, 139); INSERT INTO `sys_group_menu` VALUES (1, 140); INSERT INTO `sys_group_menu` VALUES (1, 141); INSERT INTO `sys_group_menu` VALUES (1, 142); INSERT INTO `sys_group_menu` VALUES (1, 143); INSERT INTO `sys_group_menu` VALUES (1, 144); INSERT INTO `sys_group_menu` VALUES (1, 145); INSERT INTO `sys_group_menu` VALUES (1, 146); INSERT INTO `sys_group_menu` VALUES (1, 147); INSERT INTO `sys_group_menu` VALUES (1, 148); INSERT INTO `sys_group_menu` VALUES (1, 149); INSERT INTO `sys_group_menu` VALUES (1, 150); INSERT INTO `sys_group_menu` VALUES (1, 151); INSERT INTO `sys_group_menu` VALUES (1, 152); INSERT INTO `sys_group_menu` VALUES (1, 153); INSERT INTO `sys_group_menu` VALUES (1, 154); INSERT INTO `sys_group_menu` VALUES (1, 155); INSERT INTO `sys_group_menu` VALUES (1, 156); INSERT INTO `sys_group_menu` VALUES (1, 157); INSERT INTO `sys_group_menu` VALUES (1, 158); INSERT INTO `sys_group_menu` VALUES (1, 159); INSERT INTO `sys_group_menu` VALUES (1, 160); INSERT INTO `sys_group_menu` VALUES (1, 161); INSERT INTO `sys_group_menu` VALUES (1, 162); INSERT INTO `sys_group_menu` VALUES (1, 163); INSERT INTO `sys_group_menu` VALUES (1, 164); INSERT INTO `sys_group_menu` VALUES (1, 165); INSERT INTO `sys_group_menu` VALUES (1, 166); INSERT INTO `sys_group_menu` VALUES (1, 167); INSERT INTO `sys_group_menu` VALUES (1, 168); INSERT INTO `sys_group_menu` VALUES (1, 169); INSERT INTO `sys_group_menu` VALUES (1, 170); INSERT INTO `sys_group_menu` VALUES (1, 171); INSERT INTO `sys_group_menu` VALUES (1, 172); INSERT INTO `sys_group_menu` VALUES (1, 173); INSERT INTO `sys_group_menu` VALUES (1, 174); INSERT INTO `sys_group_menu` VALUES (1, 175); INSERT INTO `sys_group_menu` VALUES (1, 176); INSERT INTO `sys_group_menu` VALUES (1, 177); INSERT INTO `sys_group_menu` VALUES (1, 178); INSERT INTO `sys_group_menu` VALUES (1, 179); INSERT INTO `sys_group_menu` VALUES (1, 180); INSERT INTO `sys_group_menu` VALUES (1, 181); INSERT INTO `sys_group_menu` VALUES (1, 182); INSERT INTO `sys_group_menu` VALUES (1, 183); INSERT INTO `sys_group_menu` VALUES (1, 184); INSERT INTO `sys_group_menu` VALUES (1, 185); INSERT INTO `sys_group_menu` VALUES (1, 186); INSERT INTO `sys_group_menu` VALUES (1, 187); INSERT INTO `sys_group_menu` VALUES (1, 188); INSERT INTO `sys_group_menu` VALUES (1, 189); INSERT INTO `sys_group_menu` VALUES (1, 190); INSERT INTO `sys_group_menu` VALUES (1, 191); INSERT INTO `sys_group_menu` VALUES (1, 192); INSERT INTO `sys_group_menu` VALUES (1, 193); INSERT INTO `sys_group_menu` VALUES (1, 194); INSERT INTO `sys_group_menu` VALUES (1, 195); INSERT INTO `sys_group_menu` VALUES (1, 196); INSERT INTO `sys_group_menu` VALUES (1, 197); INSERT INTO `sys_group_menu` VALUES (1, 198); INSERT INTO `sys_group_menu` VALUES (1, 199); INSERT INTO `sys_group_menu` VALUES (1, 200); INSERT INTO `sys_group_menu` VALUES (1, 201); INSERT INTO `sys_group_menu` VALUES (1, 202); INSERT INTO `sys_group_menu` VALUES (1, 203); INSERT INTO `sys_group_menu` VALUES (1, 204); INSERT INTO `sys_group_menu` VALUES (1, 205); INSERT INTO `sys_group_menu` VALUES (1, 206); INSERT INTO `sys_group_menu` VALUES (1, 207); INSERT INTO `sys_group_menu` VALUES (1, 208); INSERT INTO `sys_group_menu` VALUES (1, 209); INSERT INTO `sys_group_menu` VALUES (1, 210); INSERT INTO `sys_group_menu` VALUES (1, 211); INSERT INTO `sys_group_menu` VALUES (1, 212); INSERT INTO `sys_group_menu` VALUES (1, 213); INSERT INTO `sys_group_menu` VALUES (1, 214); INSERT INTO `sys_group_menu` VALUES (1, 215); INSERT INTO `sys_group_menu` VALUES (1, 216); INSERT INTO `sys_group_menu` VALUES (1, 217); INSERT INTO `sys_group_menu` VALUES (1, 218); INSERT INTO `sys_group_menu` VALUES (4, 101); INSERT INTO `sys_group_menu` VALUES (4, 202); INSERT INTO `sys_group_menu` VALUES (4, 203); INSERT INTO `sys_group_menu` VALUES (4, 402); INSERT INTO `sys_group_menu` VALUES (4, 20101); INSERT INTO `sys_group_menu` VALUES (4, 20401); INSERT INTO `sys_group_menu` VALUES (4, 20402); INSERT INTO `sys_group_menu` VALUES (4, 20501); INSERT INTO `sys_group_menu` VALUES (4, 30101); INSERT INTO `sys_group_menu` VALUES (4, 30102); INSERT INTO `sys_group_menu` VALUES (4, 30103); INSERT INTO `sys_group_menu` VALUES (4, 30104); INSERT INTO `sys_group_menu` VALUES (4, 30105); INSERT INTO `sys_group_menu` VALUES (4, 30106); INSERT INTO `sys_group_menu` VALUES (4, 30201); INSERT INTO `sys_group_menu` VALUES (4, 30202); INSERT INTO `sys_group_menu` VALUES (4, 30203); INSERT INTO `sys_group_menu` VALUES (4, 30204); INSERT INTO `sys_group_menu` VALUES (4, 30301); INSERT INTO `sys_group_menu` VALUES (4, 30302); INSERT INTO `sys_group_menu` VALUES (4, 30303); INSERT INTO `sys_group_menu` VALUES (4, 30304); INSERT INTO `sys_group_menu` VALUES (4, 40101); INSERT INTO `sys_group_menu` VALUES (4, 40102); INSERT INTO `sys_group_menu` VALUES (122, 110); INSERT INTO `sys_group_menu` VALUES (122, 111); INSERT INTO `sys_group_menu` VALUES (122, 112); 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-09 18:10:58', 'admin', 'admin'); INSERT INTO `sys_role` VALUES (139, 4, '管理员1', '123', 1, '2026-02-13 23:29:05', '2026-02-13 23:29:32', '开发', '开发'); INSERT INTO `sys_role` VALUES (140, 4, '管理员', '123', 0, '2026-02-13 23:29:41', '2026-02-13 23:29:41', '开发', '开发'); -- ---------------------------- -- Table structure for sys_role_dept -- ---------------------------- 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 = 950 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户信息表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of sys_user -- ---------------------------- INSERT INTO `sys_user` VALUES (948, '开发', '1', 'admin', '18888888888', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '', 0, '备注', 0, '2026-02-09 18:08:42', '2026-02-14 00:09:05', '', '开发'); INSERT INTO `sys_user` VALUES (949, '张三', '001', '13350010001', '13350010001', '$2a$10$JtTjRGkjGl6xDWd7Y3NfNuatn25xZetIoHmFkRIuQPu6fqjIsUUsK', '', 0, '', 0, '2026-02-13 23:24:44', '2026-02-14 00:09:16', '开发', '开发'); -- ---------------------------- -- Table structure for sys_user_post -- ---------------------------- 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); -- ---------------------------- -- Table structure for xp_app_user -- ---------------------------- DROP TABLE IF EXISTS `xp_app_user`; CREATE TABLE `xp_app_user` ( `id` bigint NOT NULL AUTO_INCREMENT, `nick_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '昵称', `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '头像', `phone_number` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '手机号', `gender` int NULL DEFAULT NULL COMMENT '性别', `open_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '微信openid', `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_phone`(`phone_number` ASC) USING BTREE COMMENT '手机号', INDEX `idx_ctime`(`create_time` ASC) USING BTREE COMMENT '创建时间' ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '小程序用户' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of xp_app_user -- ---------------------------- -- ---------------------------- -- Table structure for xp_app_user_0 -- ---------------------------- DROP TABLE IF EXISTS `xp_app_user_0`; CREATE TABLE `xp_app_user_0` ( `id` bigint NOT NULL AUTO_INCREMENT, `nick_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '昵称', `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '头像', `phone_number` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '手机号', `gender` int NULL DEFAULT NULL COMMENT '性别', `open_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '微信openid', `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_phone`(`phone_number` ASC) USING BTREE COMMENT '手机号', INDEX `idx_ctime`(`create_time` ASC) USING BTREE COMMENT '创建时间' ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '小程序用户' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of xp_app_user_0 -- ---------------------------- -- ---------------------------- -- Table structure for xp_app_user_1 -- ---------------------------- DROP TABLE IF EXISTS `xp_app_user_1`; CREATE TABLE `xp_app_user_1` ( `id` bigint NOT NULL AUTO_INCREMENT, `nick_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '昵称', `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '头像', `phone_number` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '手机号', `gender` int NULL DEFAULT NULL COMMENT '性别', `open_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '微信openid', `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_phone`(`phone_number` ASC) USING BTREE COMMENT '手机号', INDEX `idx_ctime`(`create_time` ASC) USING BTREE COMMENT '创建时间' ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '小程序用户' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of xp_app_user_1 -- ---------------------------- -- ---------------------------- -- Table structure for xp_app_user_2 -- ---------------------------- DROP TABLE IF EXISTS `xp_app_user_2`; CREATE TABLE `xp_app_user_2` ( `id` bigint NOT NULL AUTO_INCREMENT, `nick_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '昵称', `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '头像', `phone_number` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '手机号', `gender` int NULL DEFAULT NULL COMMENT '性别', `open_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '微信openid', `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_phone`(`phone_number` ASC) USING BTREE COMMENT '手机号', INDEX `idx_ctime`(`create_time` ASC) USING BTREE COMMENT '创建时间' ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '小程序用户' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of xp_app_user_2 -- ---------------------------- -- ---------------------------- -- Table structure for xp_app_user_3 -- ---------------------------- DROP TABLE IF EXISTS `xp_app_user_3`; CREATE TABLE `xp_app_user_3` ( `id` bigint NOT NULL AUTO_INCREMENT, `nick_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '昵称', `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '头像', `phone_number` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '手机号', `gender` int NULL DEFAULT NULL COMMENT '性别', `open_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '微信openid', `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_phone`(`phone_number` ASC) USING BTREE COMMENT '手机号', INDEX `idx_ctime`(`create_time` ASC) USING BTREE COMMENT '创建时间' ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '小程序用户' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of xp_app_user_3 -- ---------------------------- -- ---------------------------- -- Table structure for xp_app_user_4 -- ---------------------------- DROP TABLE IF EXISTS `xp_app_user_4`; CREATE TABLE `xp_app_user_4` ( `id` bigint NOT NULL AUTO_INCREMENT, `nick_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '昵称', `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '头像', `phone_number` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '手机号', `gender` int NULL DEFAULT NULL COMMENT '性别', `open_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '微信openid', `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_phone`(`phone_number` ASC) USING BTREE COMMENT '手机号', INDEX `idx_ctime`(`create_time` ASC) USING BTREE COMMENT '创建时间' ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '小程序用户' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of xp_app_user_4 -- ---------------------------- -- ---------------------------- -- Table structure for xp_app_user_5 -- ---------------------------- DROP TABLE IF EXISTS `xp_app_user_5`; CREATE TABLE `xp_app_user_5` ( `id` bigint NOT NULL AUTO_INCREMENT, `nick_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '昵称', `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '头像', `phone_number` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '手机号', `gender` int NULL DEFAULT NULL COMMENT '性别', `open_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '微信openid', `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_phone`(`phone_number` ASC) USING BTREE COMMENT '手机号', INDEX `idx_ctime`(`create_time` ASC) USING BTREE COMMENT '创建时间' ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '小程序用户' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of xp_app_user_5 -- ---------------------------- -- ---------------------------- -- Table structure for xp_app_user_6 -- ---------------------------- DROP TABLE IF EXISTS `xp_app_user_6`; CREATE TABLE `xp_app_user_6` ( `id` bigint NOT NULL AUTO_INCREMENT, `nick_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '昵称', `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '头像', `phone_number` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '手机号', `gender` int NULL DEFAULT NULL COMMENT '性别', `open_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '微信openid', `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_phone`(`phone_number` ASC) USING BTREE COMMENT '手机号', INDEX `idx_ctime`(`create_time` ASC) USING BTREE COMMENT '创建时间' ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '小程序用户' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of xp_app_user_6 -- ---------------------------- -- ---------------------------- -- Table structure for xp_app_user_7 -- ---------------------------- DROP TABLE IF EXISTS `xp_app_user_7`; CREATE TABLE `xp_app_user_7` ( `id` bigint NOT NULL AUTO_INCREMENT, `nick_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '昵称', `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '头像', `phone_number` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '手机号', `gender` int NULL DEFAULT NULL COMMENT '性别', `open_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '微信openid', `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_phone`(`phone_number` ASC) USING BTREE COMMENT '手机号', INDEX `idx_ctime`(`create_time` ASC) USING BTREE COMMENT '创建时间' ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '小程序用户' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of xp_app_user_7 -- ---------------------------- -- ---------------------------- -- Table structure for xp_app_user_8 -- ---------------------------- DROP TABLE IF EXISTS `xp_app_user_8`; CREATE TABLE `xp_app_user_8` ( `id` bigint NOT NULL AUTO_INCREMENT, `nick_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '昵称', `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '头像', `phone_number` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '手机号', `gender` int NULL DEFAULT NULL COMMENT '性别', `open_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '微信openid', `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_phone`(`phone_number` ASC) USING BTREE COMMENT '手机号', INDEX `idx_ctime`(`create_time` ASC) USING BTREE COMMENT '创建时间' ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '小程序用户' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of xp_app_user_8 -- ---------------------------- -- ---------------------------- -- Table structure for xp_app_user_9 -- ---------------------------- DROP TABLE IF EXISTS `xp_app_user_9`; CREATE TABLE `xp_app_user_9` ( `id` bigint NOT NULL AUTO_INCREMENT, `nick_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '昵称', `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '头像', `phone_number` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '手机号', `gender` int NULL DEFAULT NULL COMMENT '性别', `open_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '微信openid', `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_phone`(`phone_number` ASC) USING BTREE COMMENT '手机号', INDEX `idx_ctime`(`create_time` ASC) USING BTREE COMMENT '创建时间' ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '小程序用户' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of xp_app_user_9 -- ---------------------------- -- ---------------------------- -- 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', `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 = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户优惠券' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of xp_app_user_coupon -- ---------------------------- -- ---------------------------- -- 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 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', `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 = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户优惠券' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of xp_app_user_coupon_0 -- ---------------------------- -- ---------------------------- -- 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 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', `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 = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户优惠券' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of xp_app_user_coupon_1 -- ---------------------------- -- ---------------------------- -- 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 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', `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 = 1 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 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', `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 = 1 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 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', `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 = 1 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 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', `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 = 1 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 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', `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 = 1 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 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', `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 = 1 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 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', `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 = 1 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 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', `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 = 1 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 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', `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 = 1 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 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', `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 = 1 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 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', `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 = 1 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 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', `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 = 1 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 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', `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 = 1 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 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', `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 = 1 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 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', `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 = 1 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 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', `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 = 1 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 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', `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 = 1 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 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', `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 = 1 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 = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '运维人员' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of xp_operations_user -- ---------------------------- INSERT INTO `xp_operations_user` VALUES (1, '张三', '7355608', '{\"id\":\"1\",\"name\":\"头像.jpg\",\"url\":\"\nhttps://pss.bdstatic.com/static/superman/img/topnav/newfanyi-da0cea8f7e.png\"}', '123456', '1888888888', '备注', 1, NULL, NULL, NULL, NULL, NULL, 0, '2026-02-13 14:21:34', '2026-02-13 14:23:13', '', ''); INSERT INTO `xp_operations_user` VALUES (2, '李四', '7355609', '{\"id\":\"1\",\"name\":\"头像.jpg\",\"url\":\"\nhttps://pss.bdstatic.com/static/superman/img/topnav/newfanyi-da0cea8f7e.png\"}', '123456', '1888888889', '备注', 1, NULL, NULL, NULL, NULL, NULL, 0, '2026-02-13 14:23:14', '2026-02-13 14:23:38', '', ''); -- ---------------------------- -- Table structure for xp_operations_user_notification -- ---------------------------- 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 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_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 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_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 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_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 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_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 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_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 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_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 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_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 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_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 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_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 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_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 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_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 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_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 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_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 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_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 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_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 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_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 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_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 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_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 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_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 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_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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '运维人员资质证书审核记录' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of xp_qualification_audit -- ---------------------------- SET FOREIGN_KEY_CHECKS = 1;