GitBucket
Newer
/*
Navicat Premium Data Transfer
Source Server : 111.198.10.15-mysql8
Source Server Type : MySQL
Source Server Version : 80016
Source Host : 111.198.10.15:11336
Source Schema : casic_template
Target Server Type : MySQL
Target Server Version : 80016
File Encoding : 65001
Date: 23/05/2022 19:07:51
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for reptile_product_info
-- ----------------------------
DROP TABLE IF EXISTS `reptile_product_info`;
CREATE TABLE `reptile_product_info` (
`id` bigint(20) NOT NULL COMMENT '主键',
`price` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '最低价格',
`description` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '其他信息',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`key_id` bigint(20) NULL DEFAULT NULL COMMENT '关键字主键',
`actual_price` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '到手价',
`discount` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '打折信息',
`flag` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '0 正常 1 页面失效 2 价格偏高',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品信息' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of reptile_product_info
-- ----------------------------
INSERT INTO `reptile_product_info` VALUES (1528691620673748993, '10.80', '中糖白砂糖408g 优级白糖食糖蔗糖 冲饮调味品 烹饪烘焙原料 中粮出品', '2022-05-23 10:57:30', 1523964630460866562, '10.80', '满2件，总价打9折', '0');
INSERT INTO `reptile_product_info` VALUES (1528691636930871297, '49.80', '中糖玫瑰红糖块192g 风味花色食糖 产妇红糖水冲饮 玫瑰枸杞味小袋装 中粮出品', '2022-05-23 10:57:30', 1524204690590474242, '49.80', '满2件，总价打8折', '0');
-- ----------------------------
-- Table structure for reptile_search_keys
-- ----------------------------
DROP TABLE IF EXISTS `reptile_search_keys`;
CREATE TABLE `reptile_search_keys` (
`id` bigint(20) NOT NULL COMMENT '主键',
`sku_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '产品名称',
`search_time` datetime(0) NULL DEFAULT NULL COMMENT '最后检索时间',
`keep_days` int(11) NULL DEFAULT NULL COMMENT '保留时间（天）',
`sku_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品地址',
`price` decimal(10, 2) NULL DEFAULT NULL COMMENT '设定价格',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '关键字管理' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of reptile_search_keys
-- ----------------------------
INSERT INTO `reptile_search_keys` VALUES (1523964630460866562, '中糖优级白砂糖408g', '2022-05-23 10:57:30', NULL, 'https://item.jd.com/100031924630.html', 10.00);
INSERT INTO `reptile_search_keys` VALUES (1524204690590474242, '中糖玫瑰红糖192g', '2022-05-23 10:57:30', NULL, 'https://item.jd.com/100017856469.html', 49.80);
-- ----------------------------
-- Table structure for sys_area
-- ----------------------------
DROP TABLE IF EXISTS `sys_area`;
CREATE TABLE `sys_area` (
`ID` bigint(20) NOT NULL COMMENT '编码',
`PID` bigint(20) NULL DEFAULT NULL COMMENT '父级',
`AREA_NAME` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域名称',
`SIMPLE_NAME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域简称',
`LNG` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '经度',
`LAT` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '纬度',
`LEVEL` int(11) NULL DEFAULT NULL COMMENT '层级',
`PIDS` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '全部父级别',
`NUM` tinyint(4) NULL DEFAULT NULL COMMENT '排序',
`SYNC_ID` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '同步id',
`SYNC_PID` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '同步父ID',
`IS_SYNC` tinyint(4) NULL DEFAULT NULL COMMENT '是否同步',
`TENANT_ID` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色和菜单关联表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_area
-- ----------------------------
INSERT INTO `sys_area` VALUES (110000, 0, '北京', '北京', '116.405289', '39.904987', 1, '[0],', 1, NULL, NULL, NULL, NULL);
INSERT INTO `sys_area` VALUES (110100, 110000, '北京市', '北京', '116.405289', '39.904987', 2, '[0],[110000],', 1, NULL, NULL, NULL, NULL);
INSERT INTO `sys_area` VALUES (110101, 110100, '东城区', '东城', '116.418755', '39.917545', 3, '[0],[110000],[110100],', 3, NULL, NULL, NULL, NULL);
-- ----------------------------
-- Table structure for sys_config
-- ----------------------------
DROP TABLE IF EXISTS `sys_config`;
CREATE TABLE `sys_config` (
`ID` bigint(20) NOT NULL,
`VALUE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '变量值(相关json串)',
`TARGET_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '变量KEY',
`CLASS_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类名全称(保留)',
`DESCRIPTION` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '变量描述',
`TENANT_ID` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统配置表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_config
-- ----------------------------
INSERT INTO `sys_config` VALUES (1, '1.0.0.191209_alpha', 'casic.base.version', NULL, '版本号', NULL);
INSERT INTO `sys_config` VALUES (2, 'false', 'casic.db.init.enable', NULL, '默认启用', NULL);
INSERT INTO `sys_config` VALUES (3, 'false', 'casic.db.init.enable', NULL, '默认启用', NULL);
INSERT INTO `sys_config` VALUES (4, 'C:\\casic\\tmp\\', 'casic.file.uploadPath', NULL, '上传路径配置', NULL);
INSERT INTO `sys_config` VALUES (5, 'file:C:\\casic\\tmp\\', 'spring.resources.static-locations', NULL, '静态文件配置', NULL);
INSERT INTO `sys_config` VALUES (6, 'C:\\casic\\tmp\\', 'casic.file.uploadPath', NULL, '上传路径配置', NULL);
INSERT INTO `sys_config` VALUES (9, '150', 'casic.base.device.offLine', NULL, '设备离线时间判定(分钟)', NULL);
INSERT INTO `sys_config` VALUES (10, 'true', 'casic.base.user.onLineListenerEnable', NULL, '默认不开启（是否开启用户在线状态）', NULL);
-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept` (
`ID` bigint(20) NOT NULL COMMENT '主键id',
`NUM` tinyint(4) NULL DEFAULT NULL COMMENT '排序',
`PID` bigint(20) NULL DEFAULT NULL COMMENT '父部门ID',
`PIDS` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '父级IDS',
`SIMPLE_NAME` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '简称',
`FULL_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '全称',
`TIPS` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标签',
`VERSION` int(11) NULL DEFAULT NULL COMMENT '版本（乐观锁保留字段）',
`SYNC_ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '外部组织ID',
`SYNC_PID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '外部父类主键',
`IS_SYNC` tinyint(4) NULL DEFAULT NULL COMMENT '是否同步数据 1为同步',
`IS_PARENT` tinyint(4) NULL DEFAULT NULL COMMENT '是否是父类',
`IP_SEGMENT` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录IP段限制(逗号拼接)',
`DEPT_TYPE` char(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '组织类型(03 公司 04 部门/组)',
`TENANT_ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',
`CREATE_USER` bigint(20) NULL DEFAULT NULL COMMENT '创建用户',
`UPDATE_USER` bigint(20) NULL DEFAULT NULL COMMENT '修改用户',
`CREATE_TIME` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`UPDATE_TIME` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
`DEL_FLAG` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '删除标识',
PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '部门表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_dept
-- ----------------------------
INSERT INTO `sys_dept` VALUES (0, 1, -1, NULL, '顶级', '顶级', NULL, NULL, NULL, NULL, 0, 0, NULL, '03', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO `sys_dept` VALUES (24, 1, 0, '[0],', '运行指挥调度中心', '运行指挥调度中心', NULL, NULL, NULL, NULL, 0, 0, NULL, '03', '1', NULL, NULL, NULL, NULL, '0');
INSERT INTO `sys_dept` VALUES (1394541964580085762, 2, 0, '[0],', '203', '203所', NULL, NULL, NULL, NULL, 0, 0, NULL, '03', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO `sys_dept` VALUES (1429999819396530178, 1, 0, '[0],', '中国航天科工1', '中国航天科工集团203所', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '03', NULL, 1, 1, '2021-08-24 02:51:40', '2021-08-24 03:26:40', '0');
-- ----------------------------
-- Table structure for sys_dict
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict`;
CREATE TABLE `sys_dict` (
`ID` bigint(20) UNSIGNED NOT NULL COMMENT '主键id',
`NUM` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '排序',
`PID` bigint(20) NULL DEFAULT NULL COMMENT '父级字典',
`NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
`TIPS` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '提示',
`CODE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '值',
`TENANT_ID` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '字典表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_dict
-- ----------------------------
INSERT INTO `sys_dict` VALUES (35, '0', 0, '账号状态', NULL, 'accountStatus', NULL);
INSERT INTO `sys_dict` VALUES (36, '1', 35, '启用', NULL, '1', NULL);
INSERT INTO `sys_dict` VALUES (37, '2', 35, '已冻结', NULL, '2', NULL);
INSERT INTO `sys_dict` VALUES (38, '3', 35, '已删除', NULL, '3', NULL);
INSERT INTO `sys_dict` VALUES (57, '0', 0, '日志类型', NULL, 'logType', NULL);
INSERT INTO `sys_dict` VALUES (58, '0', 57, '业务日志', NULL, '0', NULL);
INSERT INTO `sys_dict` VALUES (59, '1', 57, '异常日志', NULL, '1', NULL);
INSERT INTO `sys_dict` VALUES (75, '0', 0, '组织类型', '组织类型', 'deptType', NULL);
INSERT INTO `sys_dict` VALUES (76, '1', 75, '公司', NULL, '03', NULL);
INSERT INTO `sys_dict` VALUES (77, '2', 75, '组/部门', NULL, '04', NULL);
INSERT INTO `sys_dict` VALUES (159, '0', 0, '数据权限类型', NULL, 'dataScopeType', NULL);
INSERT INTO `sys_dict` VALUES (160, '0', 159, '所有数据', NULL, '1', NULL);
INSERT INTO `sys_dict` VALUES (161, '0', 159, '所属及下级部门', NULL, '2', NULL);
INSERT INTO `sys_dict` VALUES (162, '0', 159, '本部门', NULL, '3', NULL);
INSERT INTO `sys_dict` VALUES (163, '0', 159, '自定义', NULL, '4', NULL);
INSERT INTO `sys_dict` VALUES (165, '0', 0, '区域类型', NULL, 'levelType', NULL);
INSERT INTO `sys_dict` VALUES (166, '0', 165, '省级', NULL, '1', NULL);
INSERT INTO `sys_dict` VALUES (167, '0', 165, '市级', NULL, '2', NULL);
INSERT INTO `sys_dict` VALUES (168, '0', 165, '区级', NULL, '3', NULL);
INSERT INTO `sys_dict` VALUES (169, '0', 165, '街道', NULL, '4', NULL);
INSERT INTO `sys_dict` VALUES (170, '0', 165, '社区', NULL, '5', NULL);
INSERT INTO `sys_dict` VALUES (171, '0', 165, '网格', NULL, '6', NULL);
INSERT INTO `sys_dict` VALUES (172, '0', 165, '责任网格', NULL, '7', NULL);
INSERT INTO `sys_dict` VALUES (1191959474021052418, '0', 0, '状态', NULL, 'sysStatus', NULL);
INSERT INTO `sys_dict` VALUES (1191959474033635330, '1', 1191959474021052418, '启用', NULL, '1', NULL);
INSERT INTO `sys_dict` VALUES (1191959474037829633, '2', 1191959474021052418, '禁用', NULL, '2', NULL);
INSERT INTO `sys_dict` VALUES (1191961164497457154, '0', 0, '性别', NULL, 'sysSex', NULL);
INSERT INTO `sys_dict` VALUES (1191961164510040066, '1', 1191961164497457154, '男', NULL, '1', NULL);
INSERT INTO `sys_dict` VALUES (1191961164535205890, '2', 1191961164497457154, '女', NULL, '2', NULL);
INSERT INTO `sys_dict` VALUES (1345920683299459074, '0', 0, '性别', NULL, 'sex', NULL);
INSERT INTO `sys_dict` VALUES (1345920683299459075, '0', 1345920683299459074, '男', NULL, '1', NULL);
INSERT INTO `sys_dict` VALUES (1345920683366567938, '0', 1345920683299459074, '女', NULL, '2', NULL);
INSERT INTO `sys_dict` VALUES (1392315332146458625, '0', 0, '资源类型', NULL, 'resourceType', NULL);
INSERT INTO `sys_dict` VALUES (1392315332163235841, '1', 1392315332146458625, '菜单', NULL, '03', NULL);
INSERT INTO `sys_dict` VALUES (1392315332175818753, '2', 1392315332146458625, '按钮', NULL, '04', NULL);
INSERT INTO `sys_dict` VALUES (1392315332200984577, '0', 1392315332146458625, '系统', NULL, '02', NULL);
INSERT INTO `sys_dict` VALUES (1392315332213567489, '5', 1392315332146458625, '移动端模块', NULL, '05', NULL);
INSERT INTO `sys_dict` VALUES (1397019628332453889, '0', 0, '结果集类型', NULL, 'viewResType', NULL);
INSERT INTO `sys_dict` VALUES (1397019628403757057, '0', 1397019628332453889, '实体对象', NULL, '1', NULL);
INSERT INTO `sys_dict` VALUES (1397019628462477313, '0', 1397019628332453889, '集合', NULL, '2', NULL);
INSERT INTO `sys_dict` VALUES (1397021674825650177, '0', 0, '访问类型', 'view视图是访问类型', 'viewRouteType', NULL);
INSERT INTO `sys_dict` VALUES (1397021674846621697, '0', 1397021674825650177, '资源库', NULL, '1', NULL);
INSERT INTO `sys_dict` VALUES (1397021674896953345, '0', 1397021674825650177, '接口', NULL, '2', NULL);
-- ----------------------------
-- Table structure for sys_login_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_login_log`;
CREATE TABLE `sys_login_log` (
`ID` bigint(20) NOT NULL COMMENT '主键',
`LOG_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '日志名称',
`USER_ID` bigint(20) NULL DEFAULT NULL COMMENT '管理员id',
`CREATE_TIME` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`SUCCEED` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否执行成功',
`MESSAGE` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '具体消息',
`IP` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录ip',
`TENANT_ID` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '登录记录' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_login_log
-- ----------------------------
-- ----------------------------
-- Table structure for sys_operation_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_operation_log`;
CREATE TABLE `sys_operation_log` (
`ID` bigint(20) NOT NULL COMMENT '主键',
`LOG_TYPE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '日志类型',
`LOG_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '日志名称',
`USER_ID` bigint(20) NULL DEFAULT NULL COMMENT '用户id',
`CLASS_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类名称',
`METHOD` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '方法名称',
`CREATE_TIME` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`SUCCEED` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否成功',
`MESSAGE` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注',
`TENANT_ID` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',
`APP_ID` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '应用',
PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '操作日志' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_operation_log
-- ----------------------------
-- ----------------------------
-- Table structure for sys_person
-- ----------------------------
DROP TABLE IF EXISTS `sys_person`;
CREATE TABLE `sys_person` (
`ID` bigint(20) NOT NULL COMMENT '主键',
`TENANT_ID` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',
`CREATE_USER` bigint(20) NULL DEFAULT NULL COMMENT '创建用户',
`UPDATE_USER` bigint(20) NULL DEFAULT NULL COMMENT '修改用户',
`CREATE_TIME` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`UPDATE_TIME` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
`DEL_FLAG` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '删除标识',
`PERSON_NAME` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名',
`SEX` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别(1:男 2:女)',
`CARD_TYPE` char(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '证件类型',
`ID_CARD_NO` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '证件号码',
`DEPTID` bigint(20) NULL DEFAULT NULL COMMENT '所属部门',
`PERSON_TYPE` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '人员类型',
`REMARKS` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
`PERSON_CODE` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '人员编码',
`NATION` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '民族',
`BIRTHDAY` datetime(0) NULL DEFAULT NULL COMMENT '出生日期',
`PHOTO` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '证件照',
`PHONE` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话号码',
PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '人员信息管理' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_person
-- ----------------------------
-- ----------------------------
-- Table structure for sys_resource
-- ----------------------------
DROP TABLE IF EXISTS `sys_resource`;
CREATE TABLE `sys_resource` (
`ID` bigint(20) NOT NULL COMMENT '主键id',
`PID` bigint(20) NULL DEFAULT NULL COMMENT '父ID',
`CODE` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单编号',
`P_CODE` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单父编号',
`P_CODES` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '当前菜单的所有父菜单编号',
`NAME` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单名称',
`ICON` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单图标',
`URL` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'URL地址',
`NUM` tinyint(4) NULL DEFAULT NULL COMMENT '菜单排序号',
`LEVELS` tinyint(4) NULL DEFAULT NULL COMMENT '菜单层级',
`IS_MENU` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否是菜单（1：是 0：不是）',
`TIPS` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
`IS_OPEN` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否打开: 1:打开 0:不打开',
`RESOURCE_TYPE` char(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '资源类型',
`CREATE_USER` bigint(20) NULL DEFAULT NULL COMMENT '创建用户',
`UPDATE_USER` bigint(20) NULL DEFAULT NULL COMMENT '修改用户',
`CREATE_TIME` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`UPDATE_TIME` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
`DEL_FLAG` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '删除标志',
`TENANT_ID` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',
`STATUS` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态',
PRIMARY KEY (`ID`) USING BTREE,
INDEX `AK_KEY_CODE`(`CODE`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '菜单表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_resource
-- ----------------------------
INSERT INTO `sys_resource` VALUES (105, 0, 'system', '0', '[0],', '系统管理', 'icon-setting', '/system', 4, 1, '1', NULL, '1', '03', NULL, 1, NULL, '2022-05-05 11:12:23', '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (106, 105, 'mgr', 'system', '[0],[system]', '用户管理', NULL, '/sys/mgr', 1, 3, '1', NULL, '0', '03', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (107, 106, 'mgr_add', 'mgr', '[0],[system],[mgr]', '添加用户', NULL, '/sys/mgr/add', 1, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (108, 106, 'mgr_edit', 'mgr', '[0],[system],[mgr]', '修改用户', NULL, '/sys/mgr/update', 2, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (109, 106, 'mgr_delete', 'mgr', '[0],[system],[mgr]', '删除用户', NULL, '/sys/mgr/delete', 3, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (110, 106, 'mgr_reset', 'mgr', '[0],[system],[mgr]', '重置密码', NULL, '/sys/mgr/reset', 4, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (111, 106, 'mgr_freeze', 'mgr', '[0],[system],[mgr]', '冻结用户', NULL, '/sys/mgr/freeze', 5, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (112, 106, 'mgr_unfreeze', 'mgr', '[0],[system],[mgr]', '解除冻结用户', NULL, '/sys/mgr/unfreeze', 6, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (113, 106, 'mgr_setRole', 'mgr', '[0],[system],[mgr]', '分配角色', NULL, '/sys/mgr/roleAssign', 7, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (114, 105, 'role', 'system', '[0],[system]', '角色管理', NULL, '/sys/role', 2, 3, '1', NULL, '0', '03', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (115, 114, 'role_add', 'role', '[0],[system],[role]', '添加角色', NULL, '/sys/role/add', 1, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (116, 114, 'role_edit', 'role', '[0],[system],[role]', '修改角色', NULL, '/sys/role/update', 2, 4, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (117, 114, 'role_remove', 'role', '[0],[system],[role]', '删除角色', NULL, '/sys/role/delete', 3, 4, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (118, 114, 'role_setAuthority', 'role', '[0],[system],[role]', '配置权限', NULL, '/sys/role/funcAuthor', 4, 4, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (119, 105, 'menu', 'system', '[0],[system]', '资源管理', NULL, '/sys/resource', 4, 3, '1', NULL, '0', '03', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (120, 119, 'menu_add', 'menu', '[0],[system],[menu]', '添加菜单', NULL, '/sys/resource/add', 1, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (121, 119, 'menu_edit', 'menu', '[0],[system],[menu]', '修改菜单', NULL, '/sys/resource/update', 2, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (122, 119, 'menu_remove', 'menu', '[0],[system],[menu]', '删除菜单', NULL, '/sys/resource/delete', 3, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (128, 105, 'log', 'system', '[0],[system]', '日志管理', NULL, '/sys/log', 6, 3, '1', NULL, '0', '03', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (131, 105, 'dept', 'system', '[0],[system]', '组织管理', NULL, '/sys/dept', 3, 3, '1', NULL, '0', '03', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (132, 105, 'dict', 'system', '[0],[system]', '字典管理', NULL, '/sys/dict', 4, 3, '1', NULL, '0', '03', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (133, 105, 'loginLog', 'system', '[0],[system]', '登录日志', NULL, '/sys/loginLog', 6, 3, '1', NULL, '0', '03', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (134, 128, 'log_clean', 'log', '[0],[system],[log]', '清空日志', NULL, '/sys/log/delLog', 3, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (135, 131, 'dept_add', 'dept', '[0],[system],[dept]', '添加部门', NULL, '/sys/dept/add', 1, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (136, 131, 'dept_update', 'dept', '[0],[system],[dept]', '修改部门', NULL, '/sys/dept/update', 1, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (137, 131, 'dept_delete', 'dept', '[0],[system],[dept]', '删除部门', NULL, '/sys/dept/delete', 1, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (138, 132, 'dict_add', 'dict', '[0],[system],[dict]', '添加字典', NULL, '/sys/dict/add', 1, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (139, 132, 'dict_update', 'dict', '[0],[system],[dict]', '修改字典', NULL, '/sys/dict/update', 1, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (140, 132, 'dict_delete', 'dict', '[0],[system],[dict]', '删除字典', NULL, '/sys/dict/delete', 1, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (151, 119, 'menu_list', 'menu', '[0],[system],[menu]', '菜单列表', NULL, '/sys/resource/list', 5, 2, '0', NULL, '0', '0', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (153, 131, 'dept_list', 'dept', '[0],[system],[dept]', '部门列表', NULL, '/sys/dept/list', 5, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (154, 131, 'dept_detail', 'dept', '[0],[system],[dept]', '部门详情', NULL, '/sys/dept/detail', 6, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (156, 132, 'dict_list', 'dict', '[0],[system],[dict]', '字典列表', NULL, '/sys/dict/list', 5, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (157, 132, 'dict_detail', 'dict', '[0],[system],[dict]', '字典详情', NULL, '/sys/dict/detail', 6, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (158, 128, 'log_list', 'log', '[0],[system],[log]', '日志列表', NULL, '/sys/log/list', 2, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (159, 128, 'log_detail', 'log', '[0],[system],[log]', '日志详情', NULL, '/sys/log/detail', 3, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (160, 133, 'del_login_log', 'loginLog', '[0],[system],[loginLog]', '清空登录日志', NULL, '/sys/loginLog/delLoginLog', 1, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (161, 133, 'login_log_list', 'loginLog', '[0],[system],[loginLog]', '登录日志列表', NULL, '/sys/loginLog/list', 2, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (164, 114, 'role_list', 'role', '[0],[system],[role]', '角色列表', NULL, '/sys/role/list', 7, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (167, 106, 'mgr_list', 'mgr', '[0],[system],[mgr]', '用户列表', NULL, '/sys/mgr/list', 10, 3, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (1138364388198715393, 114, 'data_author', 'role', '[0],[system],[role]', '数据权限', '', '/sys/role/dataAuthor', 0, 4, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (1170945119300976642, 105, 'AreaAdmin', 'system', '[0],[system]', '区域管理', NULL, '/sys/area', 0, 3, '1', NULL, '0', '03', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (1191975090689810434, 1170945119300976642, 'area_listPage', 'AreaAdmin', '[0],[system],[AreaAdmin]', '区域列表', NULL, '/sys/area/listPage', 0, 4, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (1191975312815955969, 1170945119300976642, 'area_add', 'AreaAdmin', '[0],[system],[AreaAdmin]', '新增区域', NULL, '/sys/area/add', 0, 4, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (1191975427559530497, 1170945119300976642, 'area_update', 'AreaAdmin', '[0],[system],[AreaAdmin]', '修改区域', NULL, '/sys/area/update', 0, 4, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (1191975543687225346, 1170945119300976642, 'area_delete', 'AreaAdmin', '[0],[system],[AreaAdmin]', '区域删除', NULL, '/sys/area/delete', 0, 4, '0', NULL, '0', '04', NULL, NULL, NULL, NULL, '0', NULL, NULL);
INSERT INTO `sys_resource` VALUES (1522171999793766401, 0, 'reptile', '0', '[0],', '商品管理', 'eye-open', '/reptile', 0, 1, '1', NULL, '0', '03', 1, 1, '2022-05-05 11:11:00', '2022-05-05 11:35:12', '0', NULL, '0');
INSERT INTO `sys_resource` VALUES (1522172865447780353, 1522171999793766401, 'reptile_search', 'reptile', '[0],[reptile],', '商品设置', '', '/reptile/search', 0, 2, '1', NULL, '0', '03', 1, 1, '2022-05-05 11:14:26', '2022-05-10 08:53:00', '0', NULL, '0');
INSERT INTO `sys_resource` VALUES (1522173077155274753, 1522171999793766401, 'reptile_price', 'reptile', '[0],[reptile],', '价格监测', '', '/reptile/priceList', 0, 2, '1', NULL, '0', '03', 1, 1, '2022-05-05 11:15:17', '2022-05-10 08:53:10', '0', NULL, '0');
INSERT INTO `sys_resource` VALUES (1522405425708822530, 1522172865447780353, 'reptile_search_add', 'reptile_search', '[0],[reptile],[reptile_search],', '商品搜索新增', '', '/reptile/search/add', 0, 3, '0', NULL, '0', '04', 1, 1, '2022-05-06 02:38:33', '2022-05-06 05:09:26', '0', NULL, '0');
INSERT INTO `sys_resource` VALUES (1522405642315264002, 1522172865447780353, 'reptile_search_update', 'reptile_search', '[0],[reptile],[reptile_search],', '商品搜索修改', '', '/reptile/search/update', 0, 3, '0', NULL, '0', '04', 1, NULL, '2022-05-06 02:39:25', NULL, '0', NULL, '0');
INSERT INTO `sys_resource` VALUES (1522405843251785730, 1522172865447780353, 'reptile_search_del', 'reptile_search', '[0],[reptile],[reptile_search],', '商品搜索删除', '', '/reptile/search/del', 0, 3, '0', NULL, '0', '04', 1, NULL, '2022-05-06 02:40:13', NULL, '0', NULL, '0');
-- ----------------------------
-- Table structure for sys_rm_relation
-- ----------------------------
DROP TABLE IF EXISTS `sys_rm_relation`;
CREATE TABLE `sys_rm_relation` (
`ID` bigint(20) NOT NULL COMMENT '主键',
`MENUID` bigint(20) NULL DEFAULT NULL COMMENT '菜单id',
`ROLEID` bigint(20) NULL DEFAULT NULL COMMENT '角色id',
`UPDATE_TIME` datetime(0) NULL DEFAULT NULL COMMENT '授权时间',
`OPERATOR_ID` bigint(20) NULL DEFAULT NULL COMMENT '授权人',
`TENANT_ID` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色菜单关联表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_rm_relation
-- ----------------------------
INSERT INTO `sys_rm_relation` VALUES (1194891673196265473, 105, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673196265474, 106, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673208848386, 107, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673217236994, 108, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673229819905, 109, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673238208513, 110, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673242402818, 111, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673250791425, 112, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673259180033, 113, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673263374337, 167, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673275957250, 128, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673284345858, 134, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673288540161, 158, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673296928770, 159, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673305317377, 131, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673313705986, 135, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673326288897, 136, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673326288898, 153, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673326288899, 154, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673326288900, 132, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673326288901, 156, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673326288902, 157, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673326288903, 133, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673326288904, 160, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673326288905, 161, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673326288906, 1168369906893717505, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673326288907, 1168369777864343554, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673326288908, 1170934621285220354, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673326288909, 1170935130016546817, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673326288910, 1170935355133231106, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673326288911, 1170939307476221953, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673326288912, 1170939523600318466, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673326288913, 1170939766588932098, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673326288914, 1168370044903096321, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673326288915, 1170941832166211585, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673326288916, 1170942027352342530, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673326288917, 1170942185649569793, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673326288918, 1189810347002793986, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673326288919, 200, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673326288920, 201, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673326288921, 1194788842992730113, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673326288922, 1194789102381072385, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673326288923, 1194795177033498625, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673326288924, 1194795340913344513, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673326288925, 1194796808567422977, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1194891673326288926, 1194796989341925377, 2, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1250353203450036225, 1182546302671015938, 1250347287224860674, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1250353203735248898, 1182546403170734082, 1250347287224860674, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1250353204154679298, 1184387539707572225, 1250347287224860674, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1250353204527972353, 1186813543084404738, 1250347287224860674, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1250353204838350850, 1186813633945612289, 1250347287224860674, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1250353205228421121, 1249520875247345666, 1250347287224860674, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1250353205589131265, 1184361201089064962, 1250347287224860674, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1250353206037921793, 1184385317674364930, 1250347287224860674, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1250353206356688898, 1184385517826551810, 1250347287224860674, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1250353206595764226, 1249521519790235650, 1250347287224860674, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1250353206893559810, 1190106905569067010, 1250347287224860674, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1250353207229104130, 1190107032039915522, 1250347287224860674, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1306475635612172290, 1249886835296804865, 1306475449720619010, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1306475635658309634, 1249886956348612609, 1306475449720619010, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1306475635704446978, 1249892466862956546, 1306475449720619010, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1306475635742195714, 1249892623960612865, 1306475449720619010, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1306475635784138754, 1249892811274035202, 1306475449720619010, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1306475635817693186, 1249887161739485185, 1306475449720619010, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1306475635859636225, 1250258759696883713, 1306475449720619010, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1306476139650072577, 1249886835296804865, 1306475193322815490, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1306476139679432706, 1249887161739485185, 1306475193322815490, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1308679001930186754, 1182546302671015938, 1177032669154869250, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1308679001997295617, 1182546403170734082, 1177032669154869250, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1308679001997295618, 1184361047745310722, 1177032669154869250, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1308679001997295619, 1186813543084404738, 1177032669154869250, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1308679001997295620, 1186813633945612289, 1177032669154869250, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1308679001997295621, 1249534216221073409, 1177032669154869250, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1308679001997295622, 1250676232969261057, 1177032669154869250, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1308679001997295623, 1190106905569067010, 1177032669154869250, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1308679001997295624, 1190107032039915522, 1177032669154869250, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1308679001997295625, 1253210953987518465, 1177032669154869250, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1308679002060210178, 1253211130970370049, 1177032669154869250, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1308679002060210179, 1253211309794521089, 1177032669154869250, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1308679002060210180, 1253580307568644097, 1177032669154869250, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1308679002060210181, 1253580465610018818, 1177032669154869250, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1308679333347311618, 1182546302671015938, 1177029396838580225, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1308679333347311619, 1182546403170734082, 1177029396838580225, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1308679333347311620, 1184361047745310722, 1177029396838580225, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1308679333414420482, 1186813543084404738, 1177029396838580225, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1308679333414420483, 1186813633945612289, 1177029396838580225, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1308679333414420484, 1249534040244854786, 1177029396838580225, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1308679333414420485, 1190106905569067010, 1177029396838580225, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1308679333414420486, 1190107032039915522, 1177029396838580225, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1308679333414420487, 1192639165635657730, 1177029396838580225, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1308679333414420488, 1249165468888838145, 1177029396838580225, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1308679333414420489, 1182546489808277505, 1177029396838580225, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1351414348539432962, 1182546302671015938, 1177032145621843969, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1351414348572987393, 1182546403170734082, 1177032145621843969, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1351414348589764609, 1184361047745310722, 1177032145621843969, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1351414348598153217, 1186813543084404738, 1177032145621843969, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1351414348606541825, 1186813633945612289, 1177032145621843969, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1351414348614930434, 1249534216221073409, 1177032145621843969, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1351414348623319041, 1190106905569067010, 1177032145621843969, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1351414348631707650, 1190107032039915522, 1177032145621843969, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1351414348640096258, 1192639165635657730, 1177032145621843969, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1351414348640096259, 1250346360147648514, 1177032145621843969, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1351414348648484865, 1250346662682796033, 1177032145621843969, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1351414348656873474, 1250346817381310465, 1177032145621843969, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1351414348661067778, 1252101166637871106, 1177032145621843969, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1351414348669456385, 1252101290181095426, 1177032145621843969, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1351414348677844993, 1252189180261064705, 1177032145621843969, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1351414348686233601, 1252101453339521026, 1177032145621843969, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1351414348694622209, 1252101576131964929, 1177032145621843969, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1351414348703010817, 1252101756730306562, 1177032145621843969, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1351414348703010818, 1252101908379561986, 1177032145621843969, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1351414348711399425, 1255382188074835969, 1177032145621843969, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1351414348719788034, 1253210953987518465, 1177032145621843969, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1351414348728176642, 1253211130970370049, 1177032145621843969, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1351414348778508290, 1253211309794521089, 1177032145621843969, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1351414348786896898, 1253580307568644097, 1177032145621843969, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1351414348786896899, 1253580465610018818, 1177032145621843969, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1351414348795285506, 1253587694581043202, 1177032145621843969, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1351414348803674114, 1253587902274588674, 1177032145621843969, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1351414348812062722, 1253588530782654466, 1177032145621843969, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1351414348820451329, 1253588857049174017, 1177032145621843969, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1351414348828839938, 1253589043213357057, 1177032145621843969, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1351414348833034241, 1253877334609350658, 1177032145621843969, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1351414348841422849, 1253877668740190209, 1177032145621843969, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1351414348845617153, 1254243407665942529, 1177032145621843969, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1351414348854005761, 1254243579959562242, 1177032145621843969, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406213030014978, 105, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406213411696642, 106, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406214581907457, 107, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406215567568897, 108, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406217345953794, 109, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406218499387393, 110, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406219141115905, 111, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406220739145729, 112, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406225755533313, 113, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406226414039041, 167, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406230289575938, 114, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406234160918530, 115, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406234639069185, 116, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406237818351618, 117, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406238762070017, 118, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406240716615682, 164, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406241924575234, 1138364388198715393, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406243883315202, 119, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406245061914626, 120, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406245917552641, 121, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406246571864066, 122, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406247574302722, 151, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406248589324290, 128, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406250296406017, 134, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406250954911745, 158, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406252192231426, 159, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406253043675137, 131, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406253546991618, 135, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406254398435329, 136, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406255010803713, 137, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406255648337922, 153, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406256151654402, 154, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406256478810114, 132, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406257649020929, 138, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406258320109570, 139, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406260102688770, 140, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406260694085633, 156, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406261247733762, 157, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406261973348354, 133, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406262422138881, 160, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406262896095233, 161, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406264213106689, 1522171999793766401, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406265253294082, 1522172865447780353, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406267413360642, 1522405425708822530, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406268029923330, 1522405642315264002, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406270651363329, 1522405843251785730, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522406272371027970, 1522173077155274753, 1, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522768272160813057, 1522171999793766401, 1398227452970446850, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522768272198561793, 1522172865447780353, 1398227452970446850, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522768272227921922, 1522405425708822530, 1398227452970446850, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522768272261476353, 1522405642315264002, 1398227452970446850, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522768272295030786, 1522405843251785730, 1398227452970446850, NULL, NULL, NULL);
INSERT INTO `sys_rm_relation` VALUES (1522768272324390913, 1522173077155274753, 1398227452970446850, NULL, NULL, NULL);
-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
`ID` bigint(20) NOT NULL COMMENT '主键id',
`NUM` tinyint(4) NULL DEFAULT NULL COMMENT '序号',
`PID` bigint(20) NULL DEFAULT NULL COMMENT '父角色ID',
`NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色名称',
`DEPT_ID` bigint(20) NULL DEFAULT NULL COMMENT '部门ID',
`VERSION` int(11) NULL DEFAULT NULL COMMENT '保留字段(暂时没用）',
`TIPS` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '提示',
`DATASCOPE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '数据权限',
`IS_DEFAULT` smallint(6) NULL DEFAULT NULL COMMENT '是否是默认角色(同步)',
`DATA_SCOPE_TYPE` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '数据权限类型( 1 所有数据 2 当前及子级部门 3 本部门 4 自定义)',
`CREATE_USER` bigint(20) NULL DEFAULT NULL COMMENT '创建用户',
`UPDATE_USER` bigint(20) NULL DEFAULT NULL COMMENT '修改用户',
`CREATE_TIME` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`UPDATE_TIME` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
`DEL_FLAG` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '删除状态',
`TENANT_ID` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_role
-- ----------------------------
INSERT INTO `sys_role` VALUES (1, 1, 0, '超级管理员', 0, 1, 'administrator', '0,24', 0, '1', NULL, NULL, NULL, NULL, '0', NULL);
INSERT INTO `sys_role` VALUES (1398227452970446850, 99, 1, '普通管理角色', 24, NULL, 'normalAdmin', '1394541964580085762', 0, '4', NULL, 1, NULL, '2022-05-07 02:40:17', '0', NULL);
-- ----------------------------
-- Table structure for sys_ru_relation
-- ----------------------------
DROP TABLE IF EXISTS `sys_ru_relation`;
CREATE TABLE `sys_ru_relation` (
`ID` bigint(20) NOT NULL COMMENT '主键',
`USERID` bigint(20) NULL DEFAULT NULL COMMENT '用户id',
`ROLEID` bigint(20) NULL DEFAULT NULL COMMENT '角色id',
`UPDATE_TIME` datetime(0) NULL DEFAULT NULL COMMENT '授权时间',
`OPERATOR_ID` bigint(20) NULL DEFAULT NULL COMMENT '授权人',
`TENANT_ID` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色人员关联表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_ru_relation
-- ----------------------------
INSERT INTO `sys_ru_relation` VALUES (1397015476227346433, 1, 1, NULL, NULL, NULL);
INSERT INTO `sys_ru_relation` VALUES (1437409763343548417, 1398227662819864577, 1398227452970446850, NULL, NULL, NULL);
INSERT INTO `sys_ru_relation` VALUES (1522768776743972866, 1455378140255043585, 0, NULL, NULL, NULL);
INSERT INTO `sys_ru_relation` VALUES (1522772389828620289, 1522766259515650049, 0, NULL, NULL, NULL);
-- ----------------------------
-- Table structure for sys_table_view_config
-- ----------------------------
DROP TABLE IF EXISTS `sys_table_view_config`;
CREATE TABLE `sys_table_view_config` (
`ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`VIEW_KEY` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '视图key值',
`SQL_CONTENT` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '执行sql',
`TITLE` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题',
`RES_TYPE` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '1 实体对象 2 集合',
`REMARKS` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注信息',
`PARAMS_NUM` int(3) NULL DEFAULT 0 COMMENT '参数个数',
`ROUTE_TYPE` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '转发类型(1 本地库读取 2 接口访问 3 转换数据)',
`HOST` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请求地址',
`RULE_CLASS` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '转换规则类',
PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_table_view_config
-- ----------------------------
INSERT INTO `sys_table_view_config` VALUES (1, 'data_demo', 'SELECT * FROM sys_user where name = {0} or name like {1}', '数据前置查询测试', '2', NULL, 1, '1', NULL, NULL);
-- ----------------------------
-- Table structure for sys_tenant
-- ----------------------------
DROP TABLE IF EXISTS `sys_tenant`;
CREATE TABLE `sys_tenant` (
`ID` bigint(20) NULL DEFAULT NULL COMMENT '自增主键',
`TENANT_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户名称',
`TENANT_CODE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户编码',
`LINK_PERSON` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系人',
`TEL` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话',
`CLEARDAY` int(11) NULL DEFAULT NULL COMMENT '历史数据保存天数',
`FLAG` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态',
`TS` datetime(0) NULL DEFAULT NULL COMMENT '更新时间戳'
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '租户管理' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_tenant
-- ----------------------------
-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
`ID` bigint(20) NOT NULL COMMENT '主键id',
`AVATAR` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '头像',
`ACCOUNT` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '账号',
`PASSWORD` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
`SALT` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'md5密码盐',
`NAME` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名字',
`BIRTHDAY` datetime(0) NULL DEFAULT NULL COMMENT '生日',
`SEX` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别',
`EMAIL` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电子邮件',
`PHONE` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话',
`ROLE_ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色id(停用)',
`DEPT_ID` bigint(20) NULL DEFAULT NULL COMMENT '部门ID',
`STATUS` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态',
`VERSION` int(11) NULL DEFAULT NULL COMMENT '保留字段',
`SYNC_ID` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '原ID',
`SYNC_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '原名称',
`SYNC_PWD` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '同步密码',
`SYNC_DEPTID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '同步组织ID',
`IS_SYNC` smallint(6) NULL DEFAULT 0 COMMENT '是否是同步数据',
`LOGIN_IP` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录限制IP',
`LOGIN_MAC` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录MAC地址',
`POSITION_LNG` decimal(19, 8) NULL DEFAULT NULL COMMENT '定位经度',
`POSITION_LAT` decimal(19, 8) NULL DEFAULT NULL COMMENT '定位纬度',
`ATTR1` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '预留字段',
`LAST_TIME` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '登录时间',
`CREATE_USER` bigint(20) NULL DEFAULT NULL COMMENT '创建用户',
`UPDATE_USER` bigint(20) NULL DEFAULT NULL COMMENT '修改用户',
`CREATE_TIME` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`UPDATE_TIME` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
`DEL_FLAG` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '删除状态',
`TENANT_ID` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (`ID`) USING BTREE,
UNIQUE INDEX `AK_CONSTRAINT_ACCOUNT`(`ACCOUNT`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '管理员表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_user
-- ----------------------------
INSERT INTO `sys_user` VALUES (1, 'girl.gif', 'admin', '270fa3ef938fb1277d1ab23e9971566a', 'jg8q8', '超级管理员', '2017-05-04 16:00:00', '1', 'sn93@qq.com', '18200000000', '1,1398227452970446850', 24, '1', 25, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, '2022-05-23 10:57:45', NULL, NULL, '2016-01-29 00:49:53', NULL, '0', NULL);
INSERT INTO `sys_user` VALUES (1398227662819864577, NULL, 'yxjc', '765c9be598b4b9e2bf420369940f2cff', 'vznm9', '运行监测管理员', '2021-05-27 16:00:00', '1', NULL, NULL, '1398227452970446850', 24, '1', NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, '2021-06-04 07:20:44', NULL, 1, '2021-05-28 10:40:27', '2021-09-13 13:36:08', '0', NULL);
INSERT INTO `sys_user` VALUES (1432263995607232513, NULL, 'test001', '2500cb733d0aaabd475d211c55942d8c', 'tbl2c', '测试用户1', '1988-11-25 16:00:00', '1', '472853529@qq.com', '18600202639', NULL, 24, '1', NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, '2021-08-30 08:48:41', 1, NULL, '2021-08-30 08:48:41', NULL, '0', NULL);
INSERT INTO `sys_user` VALUES (1455378140255043585, NULL, '测试', '6c089e9ff40b2b8b567ff4d6c40cc20a', '34a9g', 'yxw', '2021-10-31 16:00:00', '0', '', '', '[\"1398227452970446850\"]', 1429999819396530178, '1', NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, '2021-11-02 03:36:07', 1, NULL, '2021-11-02 03:36:03', NULL, '0', NULL);
INSERT INTO `sys_user` VALUES (1522766259515650049, NULL, 'casic', '270fa3ef938fb1277d1ab23e9971566a', 'jg8q8', '管理员', '2022-05-18 16:00:00', '0', '', '', '1398227452970446850', 1394541964580085762, '1', NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, '2022-05-11 02:07:05', 1, 1, '2022-05-07 02:32:23', '2022-05-07 02:37:16', '0', NULL);
-- ----------------------------
-- Table structure for sys_user_device
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_device`;
CREATE TABLE `sys_user_device` (
`ID` bigint(20) NOT NULL,
`IMEI` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户设备IMEI号',
`USER_ID` bigint(20) NULL DEFAULT NULL COMMENT '用户ID',
`NETWORK_NUMBER` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '入网号',
`TARGET_ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '同步数据ID',
`LAST_TIME` timestamp(0) NULL DEFAULT NULL COMMENT '最后在线时间',
`POSITION_LNG` decimal(19, 8) NULL DEFAULT NULL COMMENT '经度',
`POSITION_LAT` decimal(19, 8) NULL DEFAULT NULL COMMENT '纬度',
`DEVICE_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备名称',
`TENANT_ID` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_user_device
-- ----------------------------
-- ----------------------------
-- Function structure for getAreaParentList
-- ----------------------------
DROP FUNCTION IF EXISTS `getAreaParentList`;
delimiter ;;
CREATE FUNCTION `getAreaParentList`(rootId integer)
RETURNS varchar(512) CHARSET utf8
NO SQL
BEGIN
DECLARE sParentList VARCHAR(1000);
DECLARE sParentTemp VARCHAR(1000);
SET sParentTemp =CAST(rootId AS CHAR);
WHILE sParentTemp IS NOT NULL DO
IF (sParentList IS NOT NULL) THEN
SET sParentList = CONCAT('[',sParentTemp,'],',sParentList,',');
ELSE
SET sParentList = CONCAT('[',sParentTemp,']');
END IF;
SELECT GROUP_CONCAT(PID) INTO sParentTemp FROM sys_area WHERE FIND_IN_SET(ID,sParentTemp)>0;
END WHILE;
RETURN sParentList;
END
;;
delimiter ;
-- ----------------------------
-- Function structure for getDeptPids
-- ----------------------------
DROP FUNCTION IF EXISTS `getDeptPids`;
delimiter ;;
CREATE FUNCTION `getDeptPids`(rootId VARCHAR(1000))
RETURNS varchar(1000) CHARSET utf8
NO SQL
BEGIN
DECLARE sParentList VARCHAR(1000);
DECLARE sParentTemp VARCHAR(1000);
SET sParentTemp =CAST(rootId AS CHAR);
WHILE sParentTemp IS NOT NULL DO
IF (sParentList IS NOT NULL) THEN
SET sParentList = CONCAT('[',sParentTemp,'],',sParentList,'');
ELSE
SET sParentList = CONCAT('[',sParentTemp,']');
END IF;
SELECT GROUP_CONCAT(PID) INTO sParentTemp FROM SYS_DEPT WHERE FIND_IN_SET(ID,sParentTemp)>0;
END WHILE;
RETURN sParentList;
END
;;
delimiter ;
-- ----------------------------
-- Function structure for getMenuParentCodes
-- ----------------------------
DROP FUNCTION IF EXISTS `getMenuParentCodes`;
delimiter ;;
CREATE FUNCTION `getMenuParentCodes`(rootId varchar(512))
RETURNS varchar(512) CHARSET utf8
READS SQL DATA
BEGIN
DECLARE sParentList VARCHAR(1000);
DECLARE sParentTemp VARCHAR(100);
SET sParentTemp =rootId ;
WHILE sParentTemp IS NOT NULL DO
IF (sParentList IS NOT NULL) THEN
SET sParentList = CONCAT('[',sParentTemp,'],',sParentList,'');
ELSE
SET sParentList = CONCAT('[',sParentTemp,']');
END IF;
SELECT GROUP_CONCAT(p_code) INTO sParentTemp FROM SYS_MENU WHERE FIND_IN_SET(CODE,sParentTemp)>0;
END WHILE;
RETURN sParentList;
END
;;
delimiter ;
SET FOREIGN_KEY_CHECKS = 1;