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