ruoyi cloud配置启动

最新推荐文章于 2024-06-28 14:29:02 发布
最新推荐文章于 2024-06-28 14:29:02 发布
阅读量858 收藏
点赞数
分类专栏： 集群 nacos docker 文章标签： 容器 kubernetes
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_42037607/article/details/124467123
版权
集群 同时被 3 个专栏收录
10 篇文章 1 订阅
订阅专栏
docker
9 篇文章 3 订阅
订阅专栏
nacos
5 篇文章 0 订阅
订阅专栏

1.配置nacos所用到的数据库

/*
MySQL Data Transfer
Source Host: localhost
Source Database: ry-config
Target Host: localhost
Target Database: ry-config
Date: 2022/4/27 21:20:15
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for config_info
-- ----------------------------
CREATE TABLE `config_info` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `data_id` varchar(255) COLLATE utf8_bin NOT NULL COMMENT 'data_id',
  `group_id` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `content` longtext COLLATE utf8_bin NOT NULL COMMENT 'content',
  `md5` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT 'md5',
  `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  `src_user` text COLLATE utf8_bin COMMENT 'source user',
  `src_ip` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT 'source ip',
  `app_name` varchar(128) COLLATE utf8_bin DEFAULT NULL,
  `tenant_id` varchar(128) COLLATE utf8_bin DEFAULT '' COMMENT '租户字段',
  `c_desc` varchar(256) COLLATE utf8_bin DEFAULT NULL,
  `c_use` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `effect` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `type` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `c_schema` text COLLATE utf8_bin,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_configinfo_datagrouptenant` (`data_id`,`group_id`,`tenant_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_info';

-- ----------------------------
-- Table structure for config_info_aggr
-- ----------------------------
CREATE TABLE `config_info_aggr` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `data_id` varchar(255) COLLATE utf8_bin NOT NULL COMMENT 'data_id',
  `group_id` varchar(255) COLLATE utf8_bin NOT NULL COMMENT 'group_id',
  `datum_id` varchar(255) COLLATE utf8_bin NOT NULL COMMENT 'datum_id',
  `content` longtext COLLATE utf8_bin NOT NULL COMMENT '内容',
  `gmt_modified` datetime NOT NULL COMMENT '修改时间',
  `app_name` varchar(128) COLLATE utf8_bin DEFAULT NULL,
  `tenant_id` varchar(128) COLLATE utf8_bin DEFAULT '' COMMENT '租户字段',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_configinfoaggr_datagrouptenantdatum` (`data_id`,`group_id`,`tenant_id`,`datum_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='增加租户字段';

-- ----------------------------
-- Table structure for config_info_beta
-- ----------------------------
CREATE TABLE `config_info_beta` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `data_id` varchar(255) COLLATE utf8_bin NOT NULL COMMENT 'data_id',
  `group_id` varchar(128) COLLATE utf8_bin NOT NULL COMMENT 'group_id',
  `app_name` varchar(128) COLLATE utf8_bin DEFAULT NULL COMMENT 'app_name',
  `content` longtext COLLATE utf8_bin NOT NULL COMMENT 'content',
  `beta_ips` varchar(1024) COLLATE utf8_bin DEFAULT NULL COMMENT 'betaIps',
  `md5` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT 'md5',
  `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  `src_user` text COLLATE utf8_bin COMMENT 'source user',
  `src_ip` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT 'source ip',
  `tenant_id` varchar(128) COLLATE utf8_bin DEFAULT '' COMMENT '租户字段',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_configinfobeta_datagrouptenant` (`data_id`,`group_id`,`tenant_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_info_beta';

-- ----------------------------
-- Table structure for config_info_tag
-- ----------------------------
CREATE TABLE `config_info_tag` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `data_id` varchar(255) COLLATE utf8_bin NOT NULL COMMENT 'data_id',
  `group_id` varchar(128) COLLATE utf8_bin NOT NULL COMMENT 'group_id',
  `tenant_id` varchar(128) COLLATE utf8_bin DEFAULT '' COMMENT 'tenant_id',
  `tag_id` varchar(128) COLLATE utf8_bin NOT NULL COMMENT 'tag_id',
  `app_name` varchar(128) COLLATE utf8_bin DEFAULT NULL COMMENT 'app_name',
  `content` longtext COLLATE utf8_bin NOT NULL COMMENT 'content',
  `md5` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT 'md5',
  `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  `src_user` text COLLATE utf8_bin COMMENT 'source user',
  `src_ip` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT 'source ip',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_configinfotag_datagrouptenanttag` (`data_id`,`group_id`,`tenant_id`,`tag_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_info_tag';

-- ----------------------------
-- Table structure for config_tags_relation
-- ----------------------------
CREATE TABLE `config_tags_relation` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `tag_name` varchar(128) COLLATE utf8_bin NOT NULL COMMENT 'tag_name',
  `tag_type` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT 'tag_type',
  `data_id` varchar(255) COLLATE utf8_bin NOT NULL COMMENT 'data_id',
  `group_id` varchar(128) COLLATE utf8_bin NOT NULL COMMENT 'group_id',
  `tenant_id` varchar(128) COLLATE utf8_bin DEFAULT '' COMMENT 'tenant_id',
  `nid` bigint(20) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`nid`),
  UNIQUE KEY `uk_configtagrelation_configidtag` (`id`,`tag_name`,`tag_type`),
  KEY `idx_tenant_id` (`tenant_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_tag_relation';

-- ----------------------------
-- Table structure for gen_table
-- ----------------------------
CREATE TABLE `gen_table` (
  `table_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `table_name` varchar(200) DEFAULT '' COMMENT '表名称',
  `table_comment` varchar(500) DEFAULT '' COMMENT '表描述',
  `sub_table_name` varchar(64) DEFAULT NULL COMMENT '关联子表的表名',
  `sub_table_fk_name` varchar(64) DEFAULT NULL COMMENT '子表关联的外键名',
  `class_name` varchar(100) DEFAULT '' COMMENT '实体类名称',
  `tpl_category` varchar(200) DEFAULT 'crud' COMMENT '使用的模板（crud单表操作 tree树表操作）',
  `package_name` varchar(100) DEFAULT NULL COMMENT '生成包路径',
  `module_name` varchar(30) DEFAULT NULL COMMENT '生成模块名',
  `business_name` varchar(30) DEFAULT NULL COMMENT '生成业务名',
  `function_name` varchar(50) DEFAULT NULL COMMENT '生成功能名',
  `function_author` varchar(50) DEFAULT NULL COMMENT '生成功能作者',
  `gen_type` char(1) DEFAULT '0' COMMENT '生成代码方式（0zip压缩包 1自定义路径）',
  `gen_path` varchar(200) DEFAULT '/' COMMENT '生成路径（不填默认项目路径）',
  `options` varchar(1000) DEFAULT NULL COMMENT '其它生成选项',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`table_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='代码生成业务表';

-- ----------------------------
-- Table structure for gen_table_column
-- ----------------------------
CREATE TABLE `gen_table_column` (
  `column_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `table_id` varchar(64) DEFAULT NULL COMMENT '归属表编号',
  `column_name` varchar(200) DEFAULT NULL COMMENT '列名称',
  `column_comment` varchar(500) DEFAULT NULL COMMENT '列描述',
  `column_type` varchar(100) DEFAULT NULL COMMENT '列类型',
  `java_type` varchar(500) DEFAULT NULL COMMENT 'JAVA类型',
  `java_field` varchar(200) DEFAULT NULL COMMENT 'JAVA字段名',
  `is_pk` char(1) DEFAULT NULL COMMENT '是否主键（1是）',
  `is_increment` char(1) DEFAULT NULL COMMENT '是否自增（1是）',
  `is_required` char(1) DEFAULT NULL COMMENT '是否必填（1是）',
  `is_insert` char(1) DEFAULT NULL COMMENT '是否为插入字段（1是）',
  `is_edit` char(1) DEFAULT NULL COMMENT '是否编辑字段（1是）',
  `is_list` char(1) DEFAULT NULL COMMENT '是否列表字段（1是）',
  `is_query` char(1) DEFAULT NULL COMMENT '是否查询字段（1是）',
  `query_type` varchar(200) DEFAULT 'EQ' COMMENT '查询方式（等于、不等于、大于、小于、范围）',
  `html_type` varchar(200) DEFAULT NULL COMMENT '显示类型（文本框、文本域、下拉框、复选框、单选框、日期控件）',
  `dict_type` varchar(200) DEFAULT '' COMMENT '字典类型',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`column_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='代码生成业务表字段';

-- ----------------------------
-- Table structure for group_capacity
-- ----------------------------
CREATE TABLE `group_capacity` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `group_id` varchar(128) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'Group ID，空字符表示整个集群',
  `quota` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '配额，0表示使用默认值',
  `usage` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '使用量',
  `max_size` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '单个配置大小上限，单位为字节，0表示使用默认值',
  `max_aggr_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '聚合子配置最大个数，，0表示使用默认值',
  `max_aggr_size` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '单个聚合数据的子配置大小上限，单位为字节，0表示使用默认值',
  `max_history_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最大变更历史数量',
  `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_group_id` (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='集群、各Group容量信息表';

-- ----------------------------
-- Table structure for his_config_info
-- ----------------------------
CREATE TABLE `his_config_info` (
  `id` bigint(64) unsigned NOT NULL,
  `nid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `data_id` varchar(255) COLLATE utf8_bin NOT NULL,
  `group_id` varchar(128) COLLATE utf8_bin NOT NULL,
  `app_name` varchar(128) COLLATE utf8_bin DEFAULT NULL COMMENT 'app_name',
  `content` longtext COLLATE utf8_bin NOT NULL,
  `md5` varchar(32) COLLATE utf8_bin DEFAULT NULL,
  `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `src_user` text COLLATE utf8_bin,
  `src_ip` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `op_type` char(10) COLLATE utf8_bin DEFAULT NULL,
  `tenant_id` varchar(128) COLLATE utf8_bin DEFAULT '' COMMENT '租户字段',
  PRIMARY KEY (`nid`),
  KEY `idx_gmt_create` (`gmt_create`),
  KEY `idx_gmt_modified` (`gmt_modified`),
  KEY `idx_did` (`data_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='多租户改造';

-- ----------------------------
-- Table structure for permissions
-- ----------------------------
CREATE TABLE `permissions` (
  `role` varchar(50) NOT NULL,
  `resource` varchar(255) NOT NULL,
  `action` varchar(8) NOT NULL,
  UNIQUE KEY `uk_role_permission` (`role`,`resource`,`action`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for roles
-- ----------------------------
CREATE TABLE `roles` (
  `username` varchar(50) NOT NULL,
  `role` varchar(50) NOT NULL,
  UNIQUE KEY `idx_user_role` (`username`,`role`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for sys_config
-- ----------------------------
CREATE TABLE `sys_config` (
  `config_id` int(5) NOT NULL AUTO_INCREMENT COMMENT '参数主键',
  `config_name` varchar(100) DEFAULT '' COMMENT '参数名称',
  `config_key` varchar(100) DEFAULT '' COMMENT '参数键名',
  `config_value` varchar(500) DEFAULT '' COMMENT '参数键值',
  `config_type` char(1) DEFAULT 'N' COMMENT '系统内置（Y是 N否）',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`config_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COMMENT='参数配置表';

-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
CREATE TABLE `sys_dept` (
  `dept_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '部门id',
  `parent_id` bigint(20) DEFAULT '0' COMMENT '父部门id',
  `ancestors` varchar(50) DEFAULT '' COMMENT '祖级列表',
  `dept_name` varchar(30) DEFAULT '' COMMENT '部门名称',
  `order_num` int(4) DEFAULT '0' COMMENT '显示顺序',
  `leader` varchar(20) DEFAULT NULL COMMENT '负责人',
  `phone` varchar(11) DEFAULT NULL COMMENT '联系电话',
  `email` varchar(50) DEFAULT NULL COMMENT '邮箱',
  `status` char(1) DEFAULT '0' COMMENT '部门状态（0正常 1停用）',
  `del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`dept_id`)
) ENGINE=InnoDB AUTO_INCREMENT=110 DEFAULT CHARSET=utf8mb4 COMMENT='部门表';

-- ----------------------------
-- Table structure for sys_dict_data
-- ----------------------------
CREATE TABLE `sys_dict_data` (
  `dict_code` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '字典编码',
  `dict_sort` int(4) DEFAULT '0' COMMENT '字典排序',
  `dict_label` varchar(100) DEFAULT '' COMMENT '字典标签',
  `dict_value` varchar(100) DEFAULT '' COMMENT '字典键值',
  `dict_type` varchar(100) DEFAULT '' COMMENT '字典类型',
  `css_class` varchar(100) DEFAULT NULL COMMENT '样式属性（其他样式扩展）',
  `list_class` varchar(100) DEFAULT NULL COMMENT '表格回显样式',
  `is_default` char(1) DEFAULT 'N' COMMENT '是否默认（Y是 N否）',
  `status` char(1) DEFAULT '0' COMMENT '状态（0正常 1停用）',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`dict_code`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COMMENT='字典数据表';

-- ----------------------------
-- Table structure for sys_dict_type
-- ----------------------------
CREATE TABLE `sys_dict_type` (
  `dict_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '字典主键',
  `dict_name` varchar(100) DEFAULT '' COMMENT '字典名称',
  `dict_type` varchar(100) DEFAULT '' COMMENT '字典类型',
  `status` char(1) DEFAULT '0' COMMENT '状态（0正常 1停用）',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`dict_id`),
  UNIQUE KEY `dict_type` (`dict_type`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COMMENT='字典类型表';

-- ----------------------------
-- Table structure for sys_job
-- ----------------------------
CREATE TABLE `sys_job` (
  `job_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务ID',
  `job_name` varchar(64) NOT NULL DEFAULT '' COMMENT '任务名称',
  `job_group` varchar(64) NOT NULL DEFAULT 'DEFAULT' COMMENT '任务组名',
  `invoke_target` varchar(500) NOT NULL COMMENT '调用目标字符串',
  `cron_expression` varchar(255) DEFAULT '' COMMENT 'cron执行表达式',
  `misfire_policy` varchar(20) DEFAULT '3' COMMENT '计划执行错误策略（1立即执行 2执行一次 3放弃执行）',
  `concurrent` char(1) DEFAULT '1' COMMENT '是否并发执行（0允许 1禁止）',
  `status` char(1) DEFAULT '0' COMMENT '状态（0正常 1暂停）',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT '' COMMENT '备注信息',
  PRIMARY KEY (`job_id`,`job_name`,`job_group`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='定时任务调度表';

-- ----------------------------
-- Table structure for sys_job_log
-- ----------------------------
CREATE TABLE `sys_job_log` (
  `job_log_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务日志ID',
  `job_name` varchar(64) NOT NULL COMMENT '任务名称',
  `job_group` varchar(64) NOT NULL COMMENT '任务组名',
  `invoke_target` varchar(500) NOT NULL COMMENT '调用目标字符串',
  `job_message` varchar(500) DEFAULT NULL COMMENT '日志信息',
  `status` char(1) DEFAULT '0' COMMENT '执行状态（0正常 1失败）',
  `exception_info` varchar(2000) DEFAULT '' COMMENT '异常信息',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`job_log_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='定时任务调度日志表';

-- ----------------------------
-- Table structure for sys_logininfor
-- ----------------------------
CREATE TABLE `sys_logininfor` (
  `info_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '访问ID',
  `user_name` varchar(50) DEFAULT '' COMMENT '用户账号',
  `ipaddr` varchar(128) DEFAULT '' COMMENT '登录IP地址',
  `status` char(1) DEFAULT '0' COMMENT '登录状态（0成功 1失败）',
  `msg` varchar(255) DEFAULT '' COMMENT '提示信息',
  `access_time` datetime DEFAULT NULL COMMENT '访问时间',
  PRIMARY KEY (`info_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统访问记录';

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
CREATE TABLE `sys_menu` (
  `menu_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
  `menu_name` varchar(50) NOT NULL COMMENT '菜单名称',
  `parent_id` bigint(20) DEFAULT '0' COMMENT '父菜单ID',
  `order_num` int(4) DEFAULT '0' COMMENT '显示顺序',
  `path` varchar(200) DEFAULT '' COMMENT '路由地址',
  `component` varchar(255) DEFAULT NULL COMMENT '组件路径',
  `query` varchar(255) DEFAULT NULL COMMENT '路由参数',
  `is_frame` int(1) DEFAULT '1' COMMENT '是否为外链（0是 1否）',
  `is_cache` int(1) DEFAULT '0' COMMENT '是否缓存（0缓存 1不缓存）',
  `menu_type` char(1) DEFAULT '' COMMENT '菜单类型（M目录 C菜单 F按钮）',
  `visible` char(1) DEFAULT '0' COMMENT '菜单状态（0显示 1隐藏）',
  `status` char(1) DEFAULT '0' COMMENT '菜单状态（0正常 1停用）',
  `perms` varchar(100) DEFAULT NULL COMMENT '权限标识',
  `icon` varchar(100) DEFAULT '#' COMMENT '菜单图标',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT '' COMMENT '备注',
  PRIMARY KEY (`menu_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1061 DEFAULT CHARSET=utf8mb4 COMMENT='菜单权限表';

-- ----------------------------
-- Table structure for sys_notice
-- ----------------------------
CREATE TABLE `sys_notice` (
  `notice_id` int(4) NOT NULL AUTO_INCREMENT COMMENT '公告ID',
  `notice_title` varchar(50) NOT NULL COMMENT '公告标题',
  `notice_type` char(1) NOT NULL COMMENT '公告类型（1通知 2公告）',
  `notice_content` longblob COMMENT '公告内容',
  `status` char(1) DEFAULT '0' COMMENT '公告状态（0正常 1关闭）',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`notice_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='通知公告表';

-- ----------------------------
-- Table structure for sys_oper_log
-- ----------------------------
CREATE TABLE `sys_oper_log` (
  `oper_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志主键',
  `title` varchar(50) DEFAULT '' COMMENT '模块标题',
  `business_type` int(2) DEFAULT '0' COMMENT '业务类型（0其它 1新增 2修改 3删除）',
  `method` varchar(100) DEFAULT '' COMMENT '方法名称',
  `request_method` varchar(10) DEFAULT '' COMMENT '请求方式',
  `operator_type` int(1) DEFAULT '0' COMMENT '操作类别（0其它 1后台用户 2手机端用户）',
  `oper_name` varchar(50) DEFAULT '' COMMENT '操作人员',
  `dept_name` varchar(50) DEFAULT '' COMMENT '部门名称',
  `oper_url` varchar(255) DEFAULT '' COMMENT '请求URL',
  `oper_ip` varchar(128) DEFAULT '' COMMENT '主机地址',
  `oper_location` varchar(255) DEFAULT '' COMMENT '操作地点',
  `oper_param` varchar(2000) DEFAULT '' COMMENT '请求参数',
  `json_result` varchar(2000) DEFAULT '' COMMENT '返回参数',
  `status` int(1) DEFAULT '0' COMMENT '操作状态（0正常 1异常）',
  `error_msg` varchar(2000) DEFAULT '' COMMENT '错误消息',
  `oper_time` datetime DEFAULT NULL COMMENT '操作时间',
  PRIMARY KEY (`oper_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='操作日志记录';

-- ----------------------------
-- Table structure for sys_post
-- ----------------------------
CREATE TABLE `sys_post` (
  `post_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '岗位ID',
  `post_code` varchar(64) NOT NULL COMMENT '岗位编码',
  `post_name` varchar(50) NOT NULL COMMENT '岗位名称',
  `post_sort` int(4) NOT NULL COMMENT '显示顺序',
  `status` char(1) NOT NULL COMMENT '状态（0正常 1停用）',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`post_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COMMENT='岗位信息表';

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
CREATE TABLE `sys_role` (
  `role_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '角色ID',
  `role_name` varchar(30) NOT NULL COMMENT '角色名称',
  `role_key` varchar(100) NOT NULL COMMENT '角色权限字符串',
  `role_sort` int(4) NOT NULL COMMENT '显示顺序',
  `data_scope` char(1) DEFAULT '1' COMMENT '数据范围（1：全部数据权限 2：自定数据权限 3：本部门数据权限 4：本部门及以下数据权限）',
  `menu_check_strictly` tinyint(1) DEFAULT '1' COMMENT '菜单树选择项是否关联显示',
  `dept_check_strictly` tinyint(1) DEFAULT '1' COMMENT '部门树选择项是否关联显示',
  `status` char(1) NOT NULL COMMENT '角色状态（0正常 1停用）',
  `del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='角色信息表';

-- ----------------------------
-- Table structure for sys_role_dept
-- ----------------------------
CREATE TABLE `sys_role_dept` (
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  `dept_id` bigint(20) NOT NULL COMMENT '部门ID',
  PRIMARY KEY (`role_id`,`dept_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='角色和部门关联表';

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
CREATE TABLE `sys_role_menu` (
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  `menu_id` bigint(20) NOT NULL COMMENT '菜单ID',
  PRIMARY KEY (`role_id`,`menu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='角色和菜单关联表';

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
CREATE TABLE `sys_user` (
  `user_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '部门ID',
  `user_name` varchar(30) NOT NULL COMMENT '用户账号',
  `nick_name` varchar(30) NOT NULL COMMENT '用户昵称',
  `user_type` varchar(2) DEFAULT '00' COMMENT '用户类型（00系统用户）',
  `email` varchar(50) DEFAULT '' COMMENT '用户邮箱',
  `phonenumber` varchar(11) DEFAULT '' COMMENT '手机号码',
  `sex` char(1) DEFAULT '0' COMMENT '用户性别（0男 1女 2未知）',
  `avatar` varchar(100) DEFAULT '' COMMENT '头像地址',
  `password` varchar(100) DEFAULT '' COMMENT '密码',
  `status` char(1) DEFAULT '0' COMMENT '帐号状态（0正常 1停用）',
  `del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  `login_ip` varchar(128) DEFAULT '' COMMENT '最后登录IP',
  `login_date` datetime DEFAULT NULL COMMENT '最后登录时间',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='用户信息表';

-- ----------------------------
-- Table structure for sys_user_post
-- ----------------------------
CREATE TABLE `sys_user_post` (
  `user_id` bigint(20) NOT NULL COMMENT '用户ID',
  `post_id` bigint(20) NOT NULL COMMENT '岗位ID',
  PRIMARY KEY (`user_id`,`post_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户与岗位关联表';

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
CREATE TABLE `sys_user_role` (
  `user_id` bigint(20) NOT NULL COMMENT '用户ID',
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  PRIMARY KEY (`user_id`,`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户和角色关联表';

-- ----------------------------
-- Table structure for tenant_capacity
-- ----------------------------
CREATE TABLE `tenant_capacity` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `tenant_id` varchar(128) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'Tenant ID',
  `quota` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '配额，0表示使用默认值',
  `usage` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '使用量',
  `max_size` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '单个配置大小上限，单位为字节，0表示使用默认值',
  `max_aggr_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '聚合子配置最大个数',
  `max_aggr_size` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '单个聚合数据的子配置大小上限，单位为字节，0表示使用默认值',
  `max_history_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最大变更历史数量',
  `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_tenant_id` (`tenant_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='租户容量信息表';

-- ----------------------------
-- Table structure for tenant_info
-- ----------------------------
CREATE TABLE `tenant_info` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `kp` varchar(128) COLLATE utf8_bin NOT NULL COMMENT 'kp',
  `tenant_id` varchar(128) COLLATE utf8_bin DEFAULT '' COMMENT 'tenant_id',
  `tenant_name` varchar(128) COLLATE utf8_bin DEFAULT '' COMMENT 'tenant_name',
  `tenant_desc` varchar(256) COLLATE utf8_bin DEFAULT NULL COMMENT 'tenant_desc',
  `create_source` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT 'create_source',
  `gmt_create` bigint(20) NOT NULL COMMENT '创建时间',
  `gmt_modified` bigint(20) NOT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_tenant_info_kptenantid` (`kp`,`tenant_id`),
  KEY `idx_tenant_id` (`tenant_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='tenant_info';

-- ----------------------------
-- Table structure for users
-- ----------------------------
CREATE TABLE `users` (
  `username` varchar(50) NOT NULL,
  `password` varchar(500) NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  PRIMARY KEY (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `config_info` VALUES ('1', 'application-dev.yml', 'DEFAULT_GROUP', 0x737072696E673A0A20206D61696E3A0A20202020616C6C6F772D63697263756C61722D7265666572656E6365733A20747275650A20202020616C6C6F772D6265616E2D646566696E6974696F6E2D6F766572726964696E673A20747275650A20206175746F636F6E6669677572653A0A202020206578636C7564653A20636F6D2E616C69626162612E64727569642E737072696E672E626F6F742E6175746F636F6E6669677572652E447275696444617461536F757263654175746F436F6E6669677572650A20206D76633A0A20202020706174686D617463683A0A2020202020206D61746368696E672D73747261746567793A20616E745F706174685F6D6174636865720A2020636C6F75643A0A2020202073656E74696E656C3A0A20202020202066696C7465723A0A2020202020202020232073656E74696E656C20E59CA820737072696E67626F6F7420322E362E7820E4B88DE585BCE5AEB9E997AEE9A298E79A84E5A484E790860A2020202020202020656E61626C65643A2066616C73650A0A2320666569676E20E9858DE7BDAE0A666569676E3A0A202073656E74696E656C3A0A20202020656E61626C65643A20747275650A20206F6B687474703A0A20202020656E61626C65643A20747275650A202068747470636C69656E743A0A20202020656E61626C65643A2066616C73650A2020636C69656E743A0A20202020636F6E6669673A0A20202020202064656661756C743A0A2020202020202020636F6E6E65637454696D656F75743A2031303030300A20202020202020207265616454696D656F75743A2031303030300A2020636F6D7072657373696F6E3A0A20202020726571756573743A0A202020202020656E61626C65643A20747275650A20202020726573706F6E73653A0A202020202020656E61626C65643A20747275650A0A2320E69AB4E99CB2E79B91E68EA7E7ABAFE782B90A6D616E6167656D656E743A0A2020656E64706F696E74733A0A202020207765623A0A2020202020206578706F737572653A0A2020202020202020696E636C7564653A20272A270A, 'e6a8dafc6fcec97f777836bea3ed5028', '2020-05-20 12:00:00', '2022-01-14 02:20:19', 0x6E61636F73, '0:0:0:0:0:0:0:1', '', '', '通用配置', 'null', 'null', 'yaml', 0x6E756C6C);
INSERT INTO `config_info` VALUES ('2', 'ruoyi-gateway-dev.yml', 'DEFAULT_GROUP', 0x737072696E673A0A202072656469733A0A20202020686F73743A206C6F63616C686F73740A20202020706F72743A20363337390A2020202070617373776F72643A200A2020636C6F75643A0A20202020676174657761793A0A202020202020646973636F766572793A0A20202020202020206C6F6361746F723A0A202020202020202020206C6F776572436173655365727669636549643A20747275650A20202020202020202020656E61626C65643A20747275650A202020202020726F757465733A0A20202020202020202320E8AEA4E8AF81E4B8ADE5BF830A20202020202020202D2069643A2072756F79692D617574680A202020202020202020207572693A206C623A2F2F72756F79692D617574680A20202020202020202020707265646963617465733A0A2020202020202020202020202D20506174683D2F617574682F2A2A0A2020202020202020202066696C746572733A0A2020202020202020202020202320E9AA8CE8AF81E7A081E5A484E790860A2020202020202020202020202D2043616368655265717565737446696C7465720A2020202020202020202020202D2056616C6964617465436F646546696C7465720A2020202020202020202020202D2053747269705072656669783D310A20202020202020202320E4BBA3E7A081E7949FE688900A20202020202020202D2069643A2072756F79692D67656E0A202020202020202020207572693A206C623A2F2F72756F79692D67656E0A20202020202020202020707265646963617465733A0A2020202020202020202020202D20506174683D2F636F64652F2A2A0A2020202020202020202066696C746572733A0A2020202020202020202020202D2053747269705072656669783D310A20202020202020202320E5AE9AE697B6E4BBBBE58AA10A20202020202020202D2069643A2072756F79692D6A6F620A202020202020202020207572693A206C623A2F2F72756F79692D6A6F620A20202020202020202020707265646963617465733A0A2020202020202020202020202D20506174683D2F7363686564756C652F2A2A0A2020202020202020202066696C746572733A0A2020202020202020202020202D2053747269705072656669783D310A20202020202020202320E7B3BBE7BB9FE6A8A1E59D970A20202020202020202D2069643A2072756F79692D73797374656D0A202020202020202020207572693A206C623A2F2F72756F79692D73797374656D0A20202020202020202020707265646963617465733A0A2020202020202020202020202D20506174683D2F73797374656D2F2A2A0A2020202020202020202066696C746572733A0A2020202020202020202020202D2053747269705072656669783D310A20202020202020202320E69687E4BBB6E69C8DE58AA10A20202020202020202D2069643A2072756F79692D66696C650A202020202020202020207572693A206C623A2F2F72756F79692D66696C650A20202020202020202020707265646963617465733A0A2020202020202020202020202D20506174683D2F66696C652F2A2A0A2020202020202020202066696C746572733A0A2020202020202020202020202D2053747269705072656669783D310A0A2320E5AE89E585A8E9858DE7BDAE0A73656375726974793A0A20202320E9AA8CE8AF81E7A0810A2020636170746368613A0A20202020656E61626C65643A20747275650A20202020747970653A206D6174680A20202320E998B2E6ADA2585353E694BBE587BB0A20207873733A0A20202020656E61626C65643A20747275650A202020206578636C75646555726C733A0A2020202020202D202F73797374656D2F6E6F746963650A20202320E4B88DE6A0A1E9AA8CE799BDE5908DE58D950A202069676E6F72653A0A202020207768697465733A0A2020202020202D202F617574682F6C6F676F75740A2020202020202D202F617574682F6C6F67696E0A2020202020202D202F617574682F72656769737465720A2020202020202D202F2A2F76322F6170692D646F63730A2020202020202D202F637372660A, '2f5a6b5a4ccf20b5801c5cf842456ec6', '2020-05-14 14:17:55', '2021-07-30 09:07:14', null, '0:0:0:0:0:0:0:1', '', '', '网关模块', 'null', 'null', 'yaml', 0x6E756C6C);
INSERT INTO `config_info` VALUES ('3', 'ruoyi-auth-dev.yml', 'DEFAULT_GROUP', 0x737072696E673A200D0A202072656469733A0D0A20202020686F73743A206C6F63616C686F73740D0A20202020706F72743A20363337390D0A2020202070617373776F72643A200D0A, 'b7354e1eb62c2d846d44a796d9ec6930', '2020-11-20 00:00:00', '2021-02-28 21:06:58', null, '0:0:0:0:0:0:0:1', '', '', '认证中心', 'null', 'null', 'yaml', 0x6E756C6C);
INSERT INTO `config_info` VALUES ('4', 'ruoyi-monitor-dev.yml', 'DEFAULT_GROUP', 0x2320737072696E670D0A737072696E673A200D0A202073656375726974793A0D0A20202020757365723A0D0A2020202020206E616D653A2072756F79690D0A20202020202070617373776F72643A203132333435360D0A2020626F6F743A0D0A2020202061646D696E3A0D0A20202020202075693A0D0A20202020202020207469746C653A20E88BA5E4BE9DE69C8DE58AA1E78AB6E68081E79B91E68EA70D0A, 'd8997d0707a2fd5d9fc4e8409da38129', '2020-11-20 00:00:00', '2020-12-21 16:28:07', null, '0:0:0:0:0:0:0:1', '', '', '监控中心', 'null', 'null', 'yaml', 0x6E756C6C);
INSERT INTO `config_info` VALUES ('5', 'ruoyi-system-dev.yml', 'DEFAULT_GROUP', 0x2320737072696E67E9858DE7BDAE0D0A737072696E673A200D0A202072656469733A0D0A20202020686F73743A206C6F63616C686F73740D0A20202020706F72743A20363337390D0A2020202070617373776F72643A200D0A202064617461736F757263653A0D0A2020202064727569643A0D0A202020202020737461742D766965772D736572766C65743A0D0A2020202020202020656E61626C65643A20747275650D0A20202020202020206C6F67696E557365726E616D653A2061646D696E0D0A20202020202020206C6F67696E50617373776F72643A203132333435360D0A2020202064796E616D69633A0D0A20202020202064727569643A0D0A2020202020202020696E697469616C2D73697A653A20350D0A20202020202020206D696E2D69646C653A20350D0A20202020202020206D61784163746976653A2032300D0A20202020202020206D6178576169743A2036303030300D0A202020202020202074696D654265747765656E4576696374696F6E52756E734D696C6C69733A2036303030300D0A20202020202020206D696E457669637461626C6549646C6554696D654D696C6C69733A203330303030300D0A202020202020202076616C69646174696F6E51756572793A2053454C45435420312046524F4D204455414C0D0A2020202020202020746573745768696C6549646C653A20747275650D0A2020202020202020746573744F6E426F72726F773A2066616C73650D0A2020202020202020746573744F6E52657475726E3A2066616C73650D0A2020202020202020706F6F6C507265706172656453746174656D656E74733A20747275650D0A20202020202020206D6178506F6F6C507265706172656453746174656D656E74506572436F6E6E656374696F6E53697A653A2032300D0A202020202020202066696C746572733A20737461742C736C66346A0D0A2020202020202020636F6E6E656374696F6E50726F706572746965733A2064727569642E737461742E6D6572676553716C5C3D747275653B64727569642E737461742E736C6F7753716C4D696C6C69735C3D353030300D0A20202020202064617461736F757263653A0D0A202020202020202020202320E4B8BBE5BA93E695B0E68DAEE6BA900D0A202020202020202020206D61737465723A0D0A2020202020202020202020206472697665722D636C6173732D6E616D653A20636F6D2E6D7973716C2E636A2E6A6462632E4472697665720D0A20202020202020202020202075726C3A206A6462633A6D7973716C3A2F2F6C6F63616C686F73743A333330362F72792D636C6F75643F757365556E69636F64653D7472756526636861726163746572456E636F64696E673D75746638267A65726F4461746554696D654265686176696F723D636F6E76657274546F4E756C6C2675736553534C3D747275652673657276657254696D657A6F6E653D474D54253242380D0A202020202020202020202020757365726E616D653A20726F6F740D0A20202020202020202020202070617373776F72643A20616263403132330D0A202020202020202020202320E4BB8EE5BA93E695B0E68DAEE6BA900D0A202020202020202020202320736C6176653A0D0A2020202020202020202020202320757365726E616D653A200D0A202020202020202020202020232070617373776F72643A200D0A202020202020202020202020232075726C3A200D0A20202020202020202020202023206472697665722D636C6173732D6E616D653A200D0A202020202020232073656174613A2074727565202020202320E5BC80E590AF7365617461E4BBA3E79086EFBC8CE5BC80E590AFE5908EE9BB98E8AEA4E6AF8FE4B8AAE695B0E68DAEE6BA90E983BDE4BBA3E79086EFBC8CE5A682E69E9CE69F90E4B8AAE4B88DE99C80E8A681E4BBA3E79086E58FAFE58D95E78BACE585B3E997AD0D0A0D0A23207365617461E9858DE7BDAE0D0A73656174613A0D0A20202320E9BB98E8AEA4E585B3E997ADEFBC8CE5A682E99C80E590AFE794A8737072696E672E64617461736F757263652E64796E616D692E7365617461E99C80E8A681E5908CE697B6E5BC80E590AF0D0A2020656E61626C65643A2066616C73650D0A20202320536561746120E5BA94E794A8E7BC96E58FB7EFBC8CE9BB98E8AEA4E4B8BA20247B737072696E672E6170706C69636174696F6E2E6E616D657D0D0A20206170706C69636174696F6E2D69643A20247B737072696E672E6170706C69636174696F6E2E6E616D657D0D0A20202320536561746120E4BA8BE58AA1E7BB84E7BC96E58FB7EFBC8CE794A8E4BA8E20544320E99B86E7BEA4E5908D0D0A202074782D736572766963652D67726F75703A20247B737072696E672E6170706C69636174696F6E2E6E616D657D2D67726F75700D0A20202320E585B3E997ADE887AAE58AA8E4BBA3E790860D0A2020656E61626C652D6175746F2D646174612D736F757263652D70726F78793A2066616C73650D0A20202320E69C8DE58AA1E9858DE7BDAEE9A1B90D0A2020736572766963653A0D0A202020202320E8999AE68B9FE7BB84E5928CE58886E7BB84E79A84E698A0E5B0840D0A202020207667726F75702D6D617070696E673A0D0A20202020202072756F79692D73797374656D2D67726F75703A2064656661756C740D0A2020636F6E6669673A0D0A20202020747970653A206E61636F730D0A202020206E61636F733A0D0A202020202020736572766572416464723A203132372E302E302E313A383834380D0A20202020202067726F75703A2053454154415F47524F55500D0A2020202020206E616D6573706163653A0D0A202072656769737472793A0D0A20202020747970653A206E61636F730D0A202020206E61636F733A0D0A2020202020206170706C69636174696F6E3A2073656174612D7365727665720D0A2020202020207365727665722D616464723A203132372E302E302E313A383834380D0A2020202020206E616D6573706163653A0D0A0D0A23206D796261746973E9858DE7BDAE0D0A6D7962617469733A0D0A202020202320E6909CE7B4A2E68C87E5AE9AE58C85E588ABE5908D0D0A2020202074797065416C69617365735061636B6167653A20636F6D2E72756F79692E73797374656D0D0A202020202320E9858DE7BDAE6D6170706572E79A84E689ABE68F8FEFBC8CE689BEE588B0E68980E69C89E79A846D61707065722E786D6CE698A0E5B084E69687E4BBB60D0A202020206D61707065724C6F636174696F6E733A20636C617373706174683A6D61707065722F2A2A2F2A2E786D6C0D0A0D0A232073776167676572E9858DE7BDAE0D0A737761676765723A0D0A20207469746C653A20E7B3BBE7BB9FE6A8A1E59D97E68EA5E58FA3E69687E6A1A30D0A20206C6963656E73653A20506F77657265642042792072756F79690D0A20206C6963656E736555726C3A2068747470733A2F2F72756F79692E766970, 'b6b5d7998b57d31255808241490cab84', '2020-11-20 00:00:00', '2022-03-25 23:48:53', null, '10.10.10.101', '', '', '系统模块', 'null', 'null', 'yaml', 0x6E756C6C);
INSERT INTO `config_info` VALUES ('6', 'ruoyi-gen-dev.yml', 'DEFAULT_GROUP', 0x2320737072696E67E9858DE7BDAE0D0A737072696E673A200D0A202072656469733A0D0A20202020686F73743A206C6F63616C686F73740D0A20202020706F72743A20363337390D0A2020202070617373776F72643A200D0A202064617461736F757263653A200D0A202020206472697665722D636C6173732D6E616D653A20636F6D2E6D7973716C2E636A2E6A6462632E4472697665720D0A2020202075726C3A206A6462633A6D7973716C3A2F2F6C6F63616C686F73743A333330362F72792D636C6F75643F757365556E69636F64653D7472756526636861726163746572456E636F64696E673D75746638267A65726F4461746554696D654265686176696F723D636F6E76657274546F4E756C6C2675736553534C3D747275652673657276657254696D657A6F6E653D474D54253242380D0A20202020757365726E616D653A20726F6F740D0A2020202070617373776F72643A20616263403132330D0A0D0A23206D796261746973E9858DE7BDAE0D0A6D7962617469733A0D0A202020202320E6909CE7B4A2E68C87E5AE9AE58C85E588ABE5908D0D0A2020202074797065416C69617365735061636B6167653A20636F6D2E72756F79692E67656E2E646F6D61696E0D0A202020202320E9858DE7BDAE6D6170706572E79A84E689ABE68F8FEFBC8CE689BEE588B0E68980E69C89E79A846D61707065722E786D6CE698A0E5B084E69687E4BBB60D0A202020206D61707065724C6F636174696F6E733A20636C617373706174683A6D61707065722F2A2A2F2A2E786D6C0D0A0D0A232073776167676572E9858DE7BDAE0D0A737761676765723A0D0A20207469746C653A20E4BBA3E7A081E7949FE68890E68EA5E58FA3E69687E6A1A30D0A20206C6963656E73653A20506F77657265642042792072756F79690D0A20206C6963656E736555726C3A2068747470733A2F2F72756F79692E7669700D0A0D0A2320E4BBA3E7A081E7949FE688900D0A67656E3A200D0A20202320E4BD9CE880850D0A2020617574686F723A2072756F79690D0A20202320E9BB98E8AEA4E7949FE68890E58C85E8B7AFE5BE842073797374656D20E99C80E694B9E68890E887AAE5B7B1E79A84E6A8A1E59D97E5908DE7A7B020E5A6822073797374656D206D6F6E69746F7220746F6F6C0D0A20207061636B6167654E616D653A20636F6D2E72756F79692E73797374656D0D0A20202320E887AAE58AA8E58EBBE999A4E8A1A8E5898DE7BC80EFBC8CE9BB98E8AEA4E698AF66616C73650D0A20206175746F52656D6F76655072653A2066616C73650D0A20202320E8A1A8E5898DE7BC80EFBC88E7949FE68890E7B1BBE5908DE4B88DE4BC9AE58C85E590ABE8A1A8E5898DE7BC80EFBC8CE5A49AE4B8AAE794A8E98097E58FB7E58886E99A94EFBC890D0A20207461626C655072656669783A207379735F0D0A, 'dfecb6977b1637081ff78a534b7eef6a', '2020-11-20 00:00:00', '2022-03-25 23:48:29', null, '10.10.10.101', '', '', '代码生成', 'null', 'null', 'yaml', 0x6E756C6C);
INSERT INTO `config_info` VALUES ('7', 'ruoyi-job-dev.yml', 'DEFAULT_GROUP', 0x2320737072696E67E9858DE7BDAE0D0A737072696E673A200D0A202072656469733A0D0A20202020686F73743A206C6F63616C686F73740D0A20202020706F72743A20363337390D0A2020202070617373776F72643A200D0A202064617461736F757263653A0D0A202020206472697665722D636C6173732D6E616D653A20636F6D2E6D7973716C2E636A2E6A6462632E4472697665720D0A2020202075726C3A206A6462633A6D7973716C3A2F2F6C6F63616C686F73743A333330362F72792D636C6F75643F757365556E69636F64653D7472756526636861726163746572456E636F64696E673D75746638267A65726F4461746554696D654265686176696F723D636F6E76657274546F4E756C6C2675736553534C3D747275652673657276657254696D657A6F6E653D474D54253242380D0A20202020757365726E616D653A20726F6F740D0A2020202070617373776F72643A20616263403132330D0A0D0A23206D796261746973E9858DE7BDAE0D0A6D7962617469733A0D0A202020202320E6909CE7B4A2E68C87E5AE9AE58C85E588ABE5908D0D0A2020202074797065416C69617365735061636B6167653A20636F6D2E72756F79692E6A6F622E646F6D61696E0D0A202020202320E9858DE7BDAE6D6170706572E79A84E689ABE68F8FEFBC8CE689BEE588B0E68980E69C89E79A846D61707065722E786D6CE698A0E5B084E69687E4BBB60D0A202020206D61707065724C6F636174696F6E733A20636C617373706174683A6D61707065722F2A2A2F2A2E786D6C0D0A0D0A232073776167676572E9858DE7BDAE0D0A737761676765723A0D0A20207469746C653A20E5AE9AE697B6E4BBBBE58AA1E68EA5E58FA3E69687E6A1A30D0A20206C6963656E73653A20506F77657265642042792072756F79690D0A20206C6963656E736555726C3A2068747470733A2F2F72756F79692E7669700D0A, '628f5792fbe40530176de07568ef9bff', '2020-11-20 00:00:00', '2022-03-25 23:48:13', null, '10.10.10.101', '', '', '定时任务', 'null', 'null', 'yaml', 0x6E756C6C);
INSERT INTO `config_info` VALUES ('8', 'ruoyi-file-dev.yml', 'DEFAULT_GROUP', 0x2320E69CACE59CB0E69687E4BBB6E4B88AE4BCA0202020200D0A66696C653A0D0A20202020646F6D61696E3A20687474703A2F2F3132372E302E302E313A393330300D0A20202020706174683A20443A2F72756F79692F75706C6F6164506174680D0A202020207072656669783A202F737461746963730D0A0D0A232046617374444653E9858DE7BDAE0D0A666466733A0D0A2020646F6D61696E3A20687474703A2F2F382E3132392E3233312E31320D0A2020736F54696D656F75743A20333030300D0A2020636F6E6E65637454696D656F75743A20323030300D0A2020747261636B65724C6973743A20382E3132392E3233312E31323A32323132320D0A0D0A23204D696E696FE9858DE7BDAE0D0A6D696E696F3A0D0A202075726C3A20687474703A2F2F382E3132392E3233312E31323A393030300D0A20206163636573734B65793A206D696E696F61646D696E0D0A20207365637265744B65793A206D696E696F61646D696E0D0A20206275636B65744E616D653A2074657374, '5382b93f3d8059d6068c0501fdd41195', '2020-11-20 00:00:00', '2020-12-21 21:01:59', null, '0:0:0:0:0:0:0:1', '', '', '文件服务', 'null', 'null', 'yaml', 0x6E756C6C);
INSERT INTO `config_info` VALUES ('9', 'sentinel-ruoyi-gateway', 'DEFAULT_GROUP', 0x5B0D0A202020207B0D0A2020202020202020227265736F75726365223A202272756F79692D61757468222C0D0A202020202020202022636F756E74223A203530302C0D0A2020202020202020226772616465223A20312C0D0A2020202020202020226C696D6974417070223A202264656661756C74222C0D0A2020202020202020227374726174656779223A20302C0D0A202020202020202022636F6E74726F6C4265686176696F72223A20300D0A202020207D2C0D0A097B0D0A2020202020202020227265736F75726365223A202272756F79692D73797374656D222C0D0A202020202020202022636F756E74223A20313030302C0D0A2020202020202020226772616465223A20312C0D0A2020202020202020226C696D6974417070223A202264656661756C74222C0D0A2020202020202020227374726174656779223A20302C0D0A202020202020202022636F6E74726F6C4265686176696F72223A20300D0A202020207D2C0D0A097B0D0A2020202020202020227265736F75726365223A202272756F79692D67656E222C0D0A202020202020202022636F756E74223A203230302C0D0A2020202020202020226772616465223A20312C0D0A2020202020202020226C696D6974417070223A202264656661756C74222C0D0A2020202020202020227374726174656779223A20302C0D0A202020202020202022636F6E74726F6C4265686176696F72223A20300D0A202020207D2C0D0A097B0D0A2020202020202020227265736F75726365223A202272756F79692D6A6F62222C0D0A202020202020202022636F756E74223A203330302C0D0A2020202020202020226772616465223A20312C0D0A2020202020202020226C696D6974417070223A202264656661756C74222C0D0A2020202020202020227374726174656779223A20302C0D0A202020202020202022636F6E74726F6C4265686176696F72223A20300D0A202020207D0D0A5D, '9f3a3069261598f74220bc47958ec252', '2020-11-20 00:00:00', '2020-11-20 00:00:00', null, '0:0:0:0:0:0:0:1', '', '', '限流策略', 'null', 'null', 'json', 0x6E756C6C);
INSERT INTO `his_config_info` VALUES ('7', '1', 'ruoyi-job-dev.yml', 'DEFAULT_GROUP', '', 0x2320737072696E67E9858DE7BDAE0D0A737072696E673A200D0A202072656469733A0D0A20202020686F73743A206C6F63616C686F73740D0A20202020706F72743A20363337390D0A2020202070617373776F72643A200D0A202064617461736F757263653A0D0A202020206472697665722D636C6173732D6E616D653A20636F6D2E6D7973716C2E636A2E6A6462632E4472697665720D0A2020202075726C3A206A6462633A6D7973716C3A2F2F6C6F63616C686F73743A333330362F72792D636C6F75643F757365556E69636F64653D7472756526636861726163746572456E636F64696E673D75746638267A65726F4461746554696D654265686176696F723D636F6E76657274546F4E756C6C2675736553534C3D747275652673657276657254696D657A6F6E653D474D54253242380D0A20202020757365726E616D653A20726F6F740D0A2020202070617373776F72643A2070617373776F72640D0A0D0A23206D796261746973E9858DE7BDAE0D0A6D7962617469733A0D0A202020202320E6909CE7B4A2E68C87E5AE9AE58C85E588ABE5908D0D0A2020202074797065416C69617365735061636B6167653A20636F6D2E72756F79692E6A6F622E646F6D61696E0D0A202020202320E9858DE7BDAE6D6170706572E79A84E689ABE68F8FEFBC8CE689BEE588B0E68980E69C89E79A846D61707065722E786D6CE698A0E5B084E69687E4BBB60D0A202020206D61707065724C6F636174696F6E733A20636C617373706174683A6D61707065722F2A2A2F2A2E786D6C0D0A0D0A232073776167676572E9858DE7BDAE0D0A737761676765723A0D0A20207469746C653A20E5AE9AE697B6E4BBBBE58AA1E68EA5E58FA3E69687E6A1A30D0A20206C6963656E73653A20506F77657265642042792072756F79690D0A20206C6963656E736555726C3A2068747470733A2F2F72756F79692E7669700D0A, 'd6dfade9a2c93c463ae857cd503cb172', '2022-03-25 23:48:13', '2022-03-25 23:48:13', null, '10.10.10.101', 'U', '');
INSERT INTO `his_config_info` VALUES ('6', '2', 'ruoyi-gen-dev.yml', 'DEFAULT_GROUP', '', 0x2320737072696E67E9858DE7BDAE0D0A737072696E673A200D0A202072656469733A0D0A20202020686F73743A206C6F63616C686F73740D0A20202020706F72743A20363337390D0A2020202070617373776F72643A200D0A202064617461736F757263653A200D0A202020206472697665722D636C6173732D6E616D653A20636F6D2E6D7973716C2E636A2E6A6462632E4472697665720D0A2020202075726C3A206A6462633A6D7973716C3A2F2F6C6F63616C686F73743A333330362F72792D636C6F75643F757365556E69636F64653D7472756526636861726163746572456E636F64696E673D75746638267A65726F4461746554696D654265686176696F723D636F6E76657274546F4E756C6C2675736553534C3D747275652673657276657254696D657A6F6E653D474D54253242380D0A20202020757365726E616D653A20726F6F740D0A2020202070617373776F72643A2070617373776F72640D0A0D0A23206D796261746973E9858DE7BDAE0D0A6D7962617469733A0D0A202020202320E6909CE7B4A2E68C87E5AE9AE58C85E588ABE5908D0D0A2020202074797065416C69617365735061636B6167653A20636F6D2E72756F79692E67656E2E646F6D61696E0D0A202020202320E9858DE7BDAE6D6170706572E79A84E689ABE68F8FEFBC8CE689BEE588B0E68980E69C89E79A846D61707065722E786D6CE698A0E5B084E69687E4BBB60D0A202020206D61707065724C6F636174696F6E733A20636C617373706174683A6D61707065722F2A2A2F2A2E786D6C0D0A0D0A232073776167676572E9858DE7BDAE0D0A737761676765723A0D0A20207469746C653A20E4BBA3E7A081E7949FE68890E68EA5E58FA3E69687E6A1A30D0A20206C6963656E73653A20506F77657265642042792072756F79690D0A20206C6963656E736555726C3A2068747470733A2F2F72756F79692E7669700D0A0D0A2320E4BBA3E7A081E7949FE688900D0A67656E3A200D0A20202320E4BD9CE880850D0A2020617574686F723A2072756F79690D0A20202320E9BB98E8AEA4E7949FE68890E58C85E8B7AFE5BE842073797374656D20E99C80E694B9E68890E887AAE5B7B1E79A84E6A8A1E59D97E5908DE7A7B020E5A6822073797374656D206D6F6E69746F7220746F6F6C0D0A20207061636B6167654E616D653A20636F6D2E72756F79692E73797374656D0D0A20202320E887AAE58AA8E58EBBE999A4E8A1A8E5898DE7BC80EFBC8CE9BB98E8AEA4E698AF66616C73650D0A20206175746F52656D6F76655072653A2066616C73650D0A20202320E8A1A8E5898DE7BC80EFBC88E7949FE68890E7B1BBE5908DE4B88DE4BC9AE58C85E590ABE8A1A8E5898DE7BC80EFBC8CE5A49AE4B8AAE794A8E98097E58FB7E58886E99A94EFBC890D0A20207461626C655072656669783A207379735F0D0A, '8c79f64a4cca9b821a03dc8b27a2d8eb', '2022-03-25 23:48:29', '2022-03-25 23:48:29', null, '10.10.10.101', 'U', '');
INSERT INTO `his_config_info` VALUES ('5', '3', 'ruoyi-system-dev.yml', 'DEFAULT_GROUP', '', 0x2320737072696E67E9858DE7BDAE0D0A737072696E673A200D0A202072656469733A0D0A20202020686F73743A206C6F63616C686F73740D0A20202020706F72743A20363337390D0A2020202070617373776F72643A200D0A202064617461736F757263653A0D0A2020202064727569643A0D0A202020202020737461742D766965772D736572766C65743A0D0A2020202020202020656E61626C65643A20747275650D0A20202020202020206C6F67696E557365726E616D653A2061646D696E0D0A20202020202020206C6F67696E50617373776F72643A203132333435360D0A2020202064796E616D69633A0D0A20202020202064727569643A0D0A2020202020202020696E697469616C2D73697A653A20350D0A20202020202020206D696E2D69646C653A20350D0A20202020202020206D61784163746976653A2032300D0A20202020202020206D6178576169743A2036303030300D0A202020202020202074696D654265747765656E4576696374696F6E52756E734D696C6C69733A2036303030300D0A20202020202020206D696E457669637461626C6549646C6554696D654D696C6C69733A203330303030300D0A202020202020202076616C69646174696F6E51756572793A2053454C45435420312046524F4D204455414C0D0A2020202020202020746573745768696C6549646C653A20747275650D0A2020202020202020746573744F6E426F72726F773A2066616C73650D0A2020202020202020746573744F6E52657475726E3A2066616C73650D0A2020202020202020706F6F6C507265706172656453746174656D656E74733A20747275650D0A20202020202020206D6178506F6F6C507265706172656453746174656D656E74506572436F6E6E656374696F6E53697A653A2032300D0A202020202020202066696C746572733A20737461742C736C66346A0D0A2020202020202020636F6E6E656374696F6E50726F706572746965733A2064727569642E737461742E6D6572676553716C5C3D747275653B64727569642E737461742E736C6F7753716C4D696C6C69735C3D353030300D0A20202020202064617461736F757263653A0D0A202020202020202020202320E4B8BBE5BA93E695B0E68DAEE6BA900D0A202020202020202020206D61737465723A0D0A2020202020202020202020206472697665722D636C6173732D6E616D653A20636F6D2E6D7973716C2E636A2E6A6462632E4472697665720D0A20202020202020202020202075726C3A206A6462633A6D7973716C3A2F2F6C6F63616C686F73743A333330362F72792D636C6F75643F757365556E69636F64653D7472756526636861726163746572456E636F64696E673D75746638267A65726F4461746554696D654265686176696F723D636F6E76657274546F4E756C6C2675736553534C3D747275652673657276657254696D657A6F6E653D474D54253242380D0A202020202020202020202020757365726E616D653A20726F6F740D0A20202020202020202020202070617373776F72643A2070617373776F72640D0A202020202020202020202320E4BB8EE5BA93E695B0E68DAEE6BA900D0A202020202020202020202320736C6176653A0D0A2020202020202020202020202320757365726E616D653A200D0A202020202020202020202020232070617373776F72643A200D0A202020202020202020202020232075726C3A200D0A20202020202020202020202023206472697665722D636C6173732D6E616D653A200D0A202020202020232073656174613A2074727565202020202320E5BC80E590AF7365617461E4BBA3E79086EFBC8CE5BC80E590AFE5908EE9BB98E8AEA4E6AF8FE4B8AAE695B0E68DAEE6BA90E983BDE4BBA3E79086EFBC8CE5A682E69E9CE69F90E4B8AAE4B88DE99C80E8A681E4BBA3E79086E58FAFE58D95E78BACE585B3E997AD0D0A0D0A23207365617461E9858DE7BDAE0D0A73656174613A0D0A20202320E9BB98E8AEA4E585B3E997ADEFBC8CE5A682E99C80E590AFE794A8737072696E672E64617461736F757263652E64796E616D692E7365617461E99C80E8A681E5908CE697B6E5BC80E590AF0D0A2020656E61626C65643A2066616C73650D0A20202320536561746120E5BA94E794A8E7BC96E58FB7EFBC8CE9BB98E8AEA4E4B8BA20247B737072696E672E6170706C69636174696F6E2E6E616D657D0D0A20206170706C69636174696F6E2D69643A20247B737072696E672E6170706C69636174696F6E2E6E616D657D0D0A20202320536561746120E4BA8BE58AA1E7BB84E7BC96E58FB7EFBC8CE794A8E4BA8E20544320E99B86E7BEA4E5908D0D0A202074782D736572766963652D67726F75703A20247B737072696E672E6170706C69636174696F6E2E6E616D657D2D67726F75700D0A20202320E585B3E997ADE887AAE58AA8E4BBA3E790860D0A2020656E61626C652D6175746F2D646174612D736F757263652D70726F78793A2066616C73650D0A20202320E69C8DE58AA1E9858DE7BDAEE9A1B90D0A2020736572766963653A0D0A202020202320E8999AE68B9FE7BB84E5928CE58886E7BB84E79A84E698A0E5B0840D0A202020207667726F75702D6D617070696E673A0D0A20202020202072756F79692D73797374656D2D67726F75703A2064656661756C740D0A2020636F6E6669673A0D0A20202020747970653A206E61636F730D0A202020206E61636F733A0D0A202020202020736572766572416464723A203132372E302E302E313A383834380D0A20202020202067726F75703A2053454154415F47524F55500D0A2020202020206E616D6573706163653A0D0A202072656769737472793A0D0A20202020747970653A206E61636F730D0A202020206E61636F733A0D0A2020202020206170706C69636174696F6E3A2073656174612D7365727665720D0A2020202020207365727665722D616464723A203132372E302E302E313A383834380D0A2020202020206E616D6573706163653A0D0A0D0A23206D796261746973E9858DE7BDAE0D0A6D7962617469733A0D0A202020202320E6909CE7B4A2E68C87E5AE9AE58C85E588ABE5908D0D0A2020202074797065416C69617365735061636B6167653A20636F6D2E72756F79692E73797374656D0D0A202020202320E9858DE7BDAE6D6170706572E79A84E689ABE68F8FEFBC8CE689BEE588B0E68980E69C89E79A846D61707065722E786D6CE698A0E5B084E69687E4BBB60D0A202020206D61707065724C6F636174696F6E733A20636C617373706174683A6D61707065722F2A2A2F2A2E786D6C0D0A0D0A232073776167676572E9858DE7BDAE0D0A737761676765723A0D0A20207469746C653A20E7B3BBE7BB9FE6A8A1E59D97E68EA5E58FA3E69687E6A1A30D0A20206C6963656E73653A20506F77657265642042792072756F79690D0A20206C6963656E736555726C3A2068747470733A2F2F72756F79692E766970, '26650028d48ca98b672573275cc9770b', '2022-03-25 23:48:53', '2022-03-25 23:48:53', null, '10.10.10.101', 'U', '');
INSERT INTO `roles` VALUES ('nacos', 'ROLE_ADMIN');
INSERT INTO `sys_config` VALUES ('1', '主框架页-默认皮肤样式名称', 'sys.index.skinName', 'skin-blue', 'Y', 'admin', '2022-03-25 23:20:38', '', null, '蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow');
INSERT INTO `sys_config` VALUES ('2', '用户管理-账号初始密码', 'sys.user.initPassword', '123456', 'Y', 'admin', '2022-03-25 23:20:38', '', null, '初始化密码 123456');
INSERT INTO `sys_config` VALUES ('3', '主框架页-侧边栏主题', 'sys.index.sideTheme', 'theme-dark', 'Y', 'admin', '2022-03-25 23:20:38', '', null, '深色主题theme-dark，浅色主题theme-light');
INSERT INTO `sys_config` VALUES ('4', '账号自助-是否开启用户注册功能', 'sys.account.registerUser', 'false', 'Y', 'admin', '2022-03-25 23:20:38', '', null, '是否开启注册用户功能（true开启，false关闭）');
INSERT INTO `sys_dept` VALUES ('100', '0', '0', '若依科技', '0', '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-03-25 23:20:23', '', null);
INSERT INTO `sys_dept` VALUES ('101', '100', '0,100', '深圳总公司', '1', '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-03-25 23:20:23', '', null);
INSERT INTO `sys_dept` VALUES ('102', '100', '0,100', '长沙分公司', '2', '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-03-25 23:20:23', '', null);
INSERT INTO `sys_dept` VALUES ('103', '101', '0,100,101', '研发部门', '1', '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-03-25 23:20:23', '', null);
INSERT INTO `sys_dept` VALUES ('104', '101', '0,100,101', '市场部门', '2', '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-03-25 23:20:23', '', null);
INSERT INTO `sys_dept` VALUES ('105', '101', '0,100,101', '测试部门', '3', '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-03-25 23:20:23', '', null);
INSERT INTO `sys_dept` VALUES ('106', '101', '0,100,101', '财务部门', '4', '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-03-25 23:20:23', '', null);
INSERT INTO `sys_dept` VALUES ('107', '101', '0,100,101', '运维部门', '5', '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-03-25 23:20:23', '', null);
INSERT INTO `sys_dept` VALUES ('108', '102', '0,100,102', '市场部门', '1', '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-03-25 23:20:23', '', null);
INSERT INTO `sys_dept` VALUES ('109', '102', '0,100,102', '财务部门', '2', '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-03-25 23:20:23', '', null);
INSERT INTO `sys_dict_data` VALUES ('1', '1', '男', '0', 'sys_user_sex', '', '', 'Y', '0', 'admin', '2022-03-25 23:20:35', '', null, '性别男');
INSERT INTO `sys_dict_data` VALUES ('2', '2', '女', '1', 'sys_user_sex', '', '', 'N', '0', 'admin', '2022-03-25 23:20:35', '', null, '性别女');
INSERT INTO `sys_dict_data` VALUES ('3', '3', '未知', '2', 'sys_user_sex', '', '', 'N', '0', 'admin', '2022-03-25 23:20:35', '', null, '性别未知');
INSERT INTO `sys_dict_data` VALUES ('4', '1', '显示', '0', 'sys_show_hide', '', 'primary', 'Y', '0', 'admin', '2022-03-25 23:20:35', '', null, '显示菜单');
INSERT INTO `sys_dict_data` VALUES ('5', '2', '隐藏', '1', 'sys_show_hide', '', 'danger', 'N', '0', 'admin', '2022-03-25 23:20:35', '', null, '隐藏菜单');
INSERT INTO `sys_dict_data` VALUES ('6', '1', '正常', '0', 'sys_normal_disable', '', 'primary', 'Y', '0', 'admin', '2022-03-25 23:20:35', '', null, '正常状态');
INSERT INTO `sys_dict_data` VALUES ('7', '2', '停用', '1', 'sys_normal_disable', '', 'danger', 'N', '0', 'admin', '2022-03-25 23:20:36', '', null, '停用状态');
INSERT INTO `sys_dict_data` VALUES ('8', '1', '正常', '0', 'sys_job_status', '', 'primary', 'Y', '0', 'admin', '2022-03-25 23:20:36', '', null, '正常状态');
INSERT INTO `sys_dict_data` VALUES ('9', '2', '暂停', '1', 'sys_job_status', '', 'danger', 'N', '0', 'admin', '2022-03-25 23:20:36', '', null, '停用状态');
INSERT INTO `sys_dict_data` VALUES ('10', '1', '默认', 'DEFAULT', 'sys_job_group', '', '', 'Y', '0', 'admin', '2022-03-25 23:20:36', '', null, '默认分组');
INSERT INTO `sys_dict_data` VALUES ('11', '2', '系统', 'SYSTEM', 'sys_job_group', '', '', 'N', '0', 'admin', '2022-03-25 23:20:36', '', null, '系统分组');
INSERT INTO `sys_dict_data` VALUES ('12', '1', '是', 'Y', 'sys_yes_no', '', 'primary', 'Y', '0', 'admin', '2022-03-25 23:20:36', '', null, '系统默认是');
INSERT INTO `sys_dict_data` VALUES ('13', '2', '否', 'N', 'sys_yes_no', '', 'danger', 'N', '0', 'admin', '2022-03-25 23:20:36', '', null, '系统默认否');
INSERT INTO `sys_dict_data` VALUES ('14', '1', '通知', '1', 'sys_notice_type', '', 'warning', 'Y', '0', 'admin', '2022-03-25 23:20:36', '', null, '通知');
INSERT INTO `sys_dict_data` VALUES ('15', '2', '公告', '2', 'sys_notice_type', '', 'success', 'N', '0', 'admin', '2022-03-25 23:20:36', '', null, '公告');
INSERT INTO `sys_dict_data` VALUES ('16', '1', '正常', '0', 'sys_notice_status', '', 'primary', 'Y', '0', 'admin', '2022-03-25 23:20:36', '', null, '正常状态');
INSERT INTO `sys_dict_data` VALUES ('17', '2', '关闭', '1', 'sys_notice_status', '', 'danger', 'N', '0', 'admin', '2022-03-25 23:20:36', '', null, '关闭状态');
INSERT INTO `sys_dict_data` VALUES ('18', '1', '新增', '1', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2022-03-25 23:20:36', '', null, '新增操作');
INSERT INTO `sys_dict_data` VALUES ('19', '2', '修改', '2', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2022-03-25 23:20:36', '', null, '修改操作');
INSERT INTO `sys_dict_data` VALUES ('20', '3', '删除', '3', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2022-03-25 23:20:36', '', null, '删除操作');
INSERT INTO `sys_dict_data` VALUES ('21', '4', '授权', '4', 'sys_oper_type', '', 'primary', 'N', '0', 'admin', '2022-03-25 23:20:36', '', null, '授权操作');
INSERT INTO `sys_dict_data` VALUES ('22', '5', '导出', '5', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2022-03-25 23:20:36', '', null, '导出操作');
INSERT INTO `sys_dict_data` VALUES ('23', '6', '导入', '6', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2022-03-25 23:20:36', '', null, '导入操作');
INSERT INTO `sys_dict_data` VALUES ('24', '7', '强退', '7', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2022-03-25 23:20:36', '', null, '强退操作');
INSERT INTO `sys_dict_data` VALUES ('25', '8', '生成代码', '8', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2022-03-25 23:20:37', '', null, '生成操作');
INSERT INTO `sys_dict_data` VALUES ('26', '9', '清空数据', '9', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2022-03-25 23:20:37', '', null, '清空操作');
INSERT INTO `sys_dict_data` VALUES ('27', '1', '成功', '0', 'sys_common_status', '', 'primary', 'N', '0', 'admin', '2022-03-25 23:20:37', '', null, '正常状态');
INSERT INTO `sys_dict_data` VALUES ('28', '2', '失败', '1', 'sys_common_status', '', 'danger', 'N', '0', 'admin', '2022-03-25 23:20:37', '', null, '停用状态');
INSERT INTO `sys_dict_type` VALUES ('1', '用户性别', 'sys_user_sex', '0', 'admin', '2022-03-25 23:20:34', '', null, '用户性别列表');
INSERT INTO `sys_dict_type` VALUES ('2', '菜单状态', 'sys_show_hide', '0', 'admin', '2022-03-25 23:20:34', '', null, '菜单状态列表');
INSERT INTO `sys_dict_type` VALUES ('3', '系统开关', 'sys_normal_disable', '0', 'admin', '2022-03-25 23:20:34', '', null, '系统开关列表');
INSERT INTO `sys_dict_type` VALUES ('4', '任务状态', 'sys_job_status', '0', 'admin', '2022-03-25 23:20:34', '', null, '任务状态列表');
INSERT INTO `sys_dict_type` VALUES ('5', '任务分组', 'sys_job_group', '0', 'admin', '2022-03-25 23:20:34', '', null, '任务分组列表');
INSERT INTO `sys_dict_type` VALUES ('6', '系统是否', 'sys_yes_no', '0', 'admin', '2022-03-25 23:20:34', '', null, '系统是否列表');
INSERT INTO `sys_dict_type` VALUES ('7', '通知类型', 'sys_notice_type', '0', 'admin', '2022-03-25 23:20:35', '', null, '通知类型列表');
INSERT INTO `sys_dict_type` VALUES ('8', '通知状态', 'sys_notice_status', '0', 'admin', '2022-03-25 23:20:35', '', null, '通知状态列表');
INSERT INTO `sys_dict_type` VALUES ('9', '操作类型', 'sys_oper_type', '0', 'admin', '2022-03-25 23:20:35', '', null, '操作类型列表');
INSERT INTO `sys_dict_type` VALUES ('10', '系统状态', 'sys_common_status', '0', 'admin', '2022-03-25 23:20:35', '', null, '登录状态列表');
INSERT INTO `sys_job` VALUES ('1', '系统默认（无参）', 'DEFAULT', 'ryTask.ryNoParams', '0/10 * * * * ?', '3', '1', '1', 'admin', '2022-03-25 23:20:39', '', null, '');
INSERT INTO `sys_job` VALUES ('2', '系统默认（有参）', 'DEFAULT', 'ryTask.ryParams(\'ry\')', '0/15 * * * * ?', '3', '1', '1', 'admin', '2022-03-25 23:20:39', '', null, '');
INSERT INTO `sys_job` VALUES ('3', '系统默认（多参）', 'DEFAULT', 'ryTask.ryMultipleParams(\'ry\', true, 2000L, 316.50D, 100)', '0/20 * * * * ?', '3', '1', '1', 'admin', '2022-03-25 23:20:39', '', null, '');
INSERT INTO `sys_menu` VALUES ('1', '系统管理', '0', '1', 'system', null, '', '1', '0', 'M', '0', '0', '', 'system', 'admin', '2022-03-25 23:20:25', '', null, '系统管理目录');
INSERT INTO `sys_menu` VALUES ('2', '系统监控', '0', '2', 'monitor', null, '', '1', '0', 'M', '0', '0', '', 'monitor', 'admin', '2022-03-25 23:20:25', '', null, '系统监控目录');
INSERT INTO `sys_menu` VALUES ('3', '系统工具', '0', '3', 'tool', null, '', '1', '0', 'M', '0', '0', '', 'tool', 'admin', '2022-03-25 23:20:25', '', null, '系统工具目录');
INSERT INTO `sys_menu` VALUES ('4', '若依官网', '0', '4', 'http://ruoyi.vip', null, '', '0', '0', 'M', '0', '0', '', 'guide', 'admin', '2022-03-25 23:20:25', '', null, '若依官网地址');
INSERT INTO `sys_menu` VALUES ('100', '用户管理', '1', '1', 'user', 'system/user/index', '', '1', '0', 'C', '0', '0', 'system:user:list', 'user', 'admin', '2022-03-25 23:20:25', '', null, '用户管理菜单');
INSERT INTO `sys_menu` VALUES ('101', '角色管理', '1', '2', 'role', 'system/role/index', '', '1', '0', 'C', '0', '0', 'system:role:list', 'peoples', 'admin', '2022-03-25 23:20:25', '', null, '角色管理菜单');
INSERT INTO `sys_menu` VALUES ('102', '菜单管理', '1', '3', 'menu', 'system/menu/index', '', '1', '0', 'C', '0', '0', 'system:menu:list', 'tree-table', 'admin', '2022-03-25 23:20:25', '', null, '菜单管理菜单');
INSERT INTO `sys_menu` VALUES ('103', '部门管理', '1', '4', 'dept', 'system/dept/index', '', '1', '0', 'C', '0', '0', 'system:dept:list', 'tree', 'admin', '2022-03-25 23:20:25', '', null, '部门管理菜单');
INSERT INTO `sys_menu` VALUES ('104', '岗位管理', '1', '5', 'post', 'system/post/index', '', '1', '0', 'C', '0', '0', 'system:post:list', 'post', 'admin', '2022-03-25 23:20:25', '', null, '岗位管理菜单');
INSERT INTO `sys_menu` VALUES ('105', '字典管理', '1', '6', 'dict', 'system/dict/index', '', '1', '0', 'C', '0', '0', 'system:dict:list', 'dict', 'admin', '2022-03-25 23:20:25', '', null, '字典管理菜单');
INSERT INTO `sys_menu` VALUES ('106', '参数设置', '1', '7', 'config', 'system/config/index', '', '1', '0', 'C', '0', '0', 'system:config:list', 'edit', 'admin', '2022-03-25 23:20:25', '', null, '参数设置菜单');
INSERT INTO `sys_menu` VALUES ('107', '通知公告', '1', '8', 'notice', 'system/notice/index', '', '1', '0', 'C', '0', '0', 'system:notice:list', 'message', 'admin', '2022-03-25 23:20:25', '', null, '通知公告菜单');
INSERT INTO `sys_menu` VALUES ('108', '日志管理', '1', '9', 'log', '', '', '1', '0', 'M', '0', '0', '', 'log', 'admin', '2022-03-25 23:20:26', '', null, '日志管理菜单');
INSERT INTO `sys_menu` VALUES ('109', '在线用户', '2', '1', 'online', 'monitor/online/index', '', '1', '0', 'C', '0', '0', 'monitor:online:list', 'online', 'admin', '2022-03-25 23:20:26', '', null, '在线用户菜单');
INSERT INTO `sys_menu` VALUES ('110', '定时任务', '2', '2', 'job', 'monitor/job/index', '', '1', '0', 'C', '0', '0', 'monitor:job:list', 'job', 'admin', '2022-03-25 23:20:26', '', null, '定时任务菜单');
INSERT INTO `sys_menu` VALUES ('111', 'Sentinel控制台', '2', '3', 'http://localhost:8718', '', '', '0', '0', 'C', '0', '0', 'monitor:sentinel:list', 'sentinel', 'admin', '2022-03-25 23:20:26', '', null, '流量控制菜单');
INSERT INTO `sys_menu` VALUES ('112', 'Nacos控制台', '2', '4', 'http://localhost:8848/nacos', '', '', '0', '0', 'C', '0', '0', 'monitor:nacos:list', 'nacos', 'admin', '2022-03-25 23:20:26', '', null, '服务治理菜单');
INSERT INTO `sys_menu` VALUES ('113', 'Admin控制台', '2', '5', 'http://localhost:9100/login', '', '', '0', '0', 'C', '0', '0', 'monitor:server:list', 'server', 'admin', '2022-03-25 23:20:26', '', null, '服务监控菜单');
INSERT INTO `sys_menu` VALUES ('114', '表单构建', '3', '1', 'build', 'tool/build/index', '', '1', '0', 'C', '0', '0', 'tool:build:list', 'build', 'admin', '2022-03-25 23:20:26', '', null, '表单构建菜单');
INSERT INTO `sys_menu` VALUES ('115', '代码生成', '3', '2', 'gen', 'tool/gen/index', '', '1', '0', 'C', '0', '0', 'tool:gen:list', 'code', 'admin', '2022-03-25 23:20:26', '', null, '代码生成菜单');
INSERT INTO `sys_menu` VALUES ('116', '系统接口', '3', '3', 'http://localhost:8080/swagger-ui/index.html', '', '', '0', '0', 'C', '0', '0', 'tool:swagger:list', 'swagger', 'admin', '2022-03-25 23:20:26', '', null, '系统接口菜单');
INSERT INTO `sys_menu` VALUES ('500', '操作日志', '108', '1', 'operlog', 'system/operlog/index', '', '1', '0', 'C', '0', '0', 'system:operlog:list', 'form', 'admin', '2022-03-25 23:20:26', '', null, '操作日志菜单');
INSERT INTO `sys_menu` VALUES ('501', '登录日志', '108', '2', 'logininfor', 'system/logininfor/index', '', '1', '0', 'C', '0', '0', 'system:logininfor:list', 'logininfor', 'admin', '2022-03-25 23:20:26', '', null, '登录日志菜单');
INSERT INTO `sys_menu` VALUES ('1001', '用户查询', '100', '1', '', '', '', '1', '0', 'F', '0', '0', 'system:user:query', '#', 'admin', '2022-03-25 23:20:26', '', null, '');
INSERT INTO `sys_menu` VALUES ('1002', '用户新增', '100', '2', '', '', '', '1', '0', 'F', '0', '0', 'system:user:add', '#', 'admin', '2022-03-25 23:20:26', '', null, '');
INSERT INTO `sys_menu` VALUES ('1003', '用户修改', '100', '3', '', '', '', '1', '0', 'F', '0', '0', 'system:user:edit', '#', 'admin', '2022-03-25 23:20:26', '', null, '');
INSERT INTO `sys_menu` VALUES ('1004', '用户删除', '100', '4', '', '', '', '1', '0', 'F', '0', '0', 'system:user:remove', '#', 'admin', '2022-03-25 23:20:26', '', null, '');
INSERT INTO `sys_menu` VALUES ('1005', '用户导出', '100', '5', '', '', '', '1', '0', 'F', '0', '0', 'system:user:export', '#', 'admin', '2022-03-25 23:20:26', '', null, '');
INSERT INTO `sys_menu` VALUES ('1006', '用户导入', '100', '6', '', '', '', '1', '0', 'F', '0', '0', 'system:user:import', '#', 'admin', '2022-03-25 23:20:26', '', null, '');
INSERT INTO `sys_menu` VALUES ('1007', '重置密码', '100', '7', '', '', '', '1', '0', 'F', '0', '0', 'system:user:resetPwd', '#', 'admin', '2022-03-25 23:20:26', '', null, '');
INSERT INTO `sys_menu` VALUES ('1008', '角色查询', '101', '1', '', '', '', '1', '0', 'F', '0', '0', 'system:role:query', '#', 'admin', '2022-03-25 23:20:26', '', null, '');
INSERT INTO `sys_menu` VALUES ('1009', '角色新增', '101', '2', '', '', '', '1', '0', 'F', '0', '0', 'system:role:add', '#', 'admin', '2022-03-25 23:20:26', '', null, '');
INSERT INTO `sys_menu` VALUES ('1010', '角色修改', '101', '3', '', '', '', '1', '0', 'F', '0', '0', 'system:role:edit', '#', 'admin', '2022-03-25 23:20:26', '', null, '');
INSERT INTO `sys_menu` VALUES ('1011', '角色删除', '101', '4', '', '', '', '1', '0', 'F', '0', '0', 'system:role:remove', '#', 'admin', '2022-03-25 23:20:26', '', null, '');
INSERT INTO `sys_menu` VALUES ('1012', '角色导出', '101', '5', '', '', '', '1', '0', 'F', '0', '0', 'system:role:export', '#', 'admin', '2022-03-25 23:20:26', '', null, '');
INSERT INTO `sys_menu` VALUES ('1013', '菜单查询', '102', '1', '', '', '', '1', '0', 'F', '0', '0', 'system:menu:query', '#', 'admin', '2022-03-25 23:20:26', '', null, '');
INSERT INTO `sys_menu` VALUES ('1014', '菜单新增', '102', '2', '', '', '', '1', '0', 'F', '0', '0', 'system:menu:add', '#', 'admin', '2022-03-25 23:20:26', '', null, '');
INSERT INTO `sys_menu` VALUES ('1015', '菜单修改', '102', '3', '', '', '', '1', '0', 'F', '0', '0', 'system:menu:edit', '#', 'admin', '2022-03-25 23:20:26', '', null, '');
INSERT INTO `sys_menu` VALUES ('1016', '菜单删除', '102', '4', '', '', '', '1', '0', 'F', '0', '0', 'system:menu:remove', '#', 'admin', '2022-03-25 23:20:26', '', null, '');
INSERT INTO `sys_menu` VALUES ('1017', '部门查询', '103', '1', '', '', '', '1', '0', 'F', '0', '0', 'system:dept:query', '#', 'admin', '2022-03-25 23:20:27', '', null, '');
INSERT INTO `sys_menu` VALUES ('1018', '部门新增', '103', '2', '', '', '', '1', '0', 'F', '0', '0', 'system:dept:add', '#', 'admin', '2022-03-25 23:20:27', '', null, '');
INSERT INTO `sys_menu` VALUES ('1019', '部门修改', '103', '3', '', '', '', '1', '0', 'F', '0', '0', 'system:dept:edit', '#', 'admin', '2022-03-25 23:20:27', '', null, '');
INSERT INTO `sys_menu` VALUES ('1020', '部门删除', '103', '4', '', '', '', '1', '0', 'F', '0', '0', 'system:dept:remove', '#', 'admin', '2022-03-25 23:20:27', '', null, '');
INSERT INTO `sys_menu` VALUES ('1021', '岗位查询', '104', '1', '', '', '', '1', '0', 'F', '0', '0', 'system:post:query', '#', 'admin', '2022-03-25 23:20:27', '', null, '');
INSERT INTO `sys_menu` VALUES ('1022', '岗位新增', '104', '2', '', '', '', '1', '0', 'F', '0', '0', 'system:post:add', '#', 'admin', '2022-03-25 23:20:27', '', null, '');
INSERT INTO `sys_menu` VALUES ('1023', '岗位修改', '104', '3', '', '', '', '1', '0', 'F', '0', '0', 'system:post:edit', '#', 'admin', '2022-03-25 23:20:27', '', null, '');
INSERT INTO `sys_menu` VALUES ('1024', '岗位删除', '104', '4', '', '', '', '1', '0', 'F', '0', '0', 'system:post:remove', '#', 'admin', '2022-03-25 23:20:27', '', null, '');
INSERT INTO `sys_menu` VALUES ('1025', '岗位导出', '104', '5', '', '', '', '1', '0', 'F', '0', '0', 'system:post:export', '#', 'admin', '2022-03-25 23:20:27', '', null, '');
INSERT INTO `sys_menu` VALUES ('1026', '字典查询', '105', '1', '#', '', '', '1', '0', 'F', '0', '0', 'system:dict:query', '#', 'admin', '2022-03-25 23:20:27', '', null, '');
INSERT INTO `sys_menu` VALUES ('1027', '字典新增', '105', '2', '#', '', '', '1', '0', 'F', '0', '0', 'system:dict:add', '#', 'admin', '2022-03-25 23:20:27', '', null, '');
INSERT INTO `sys_menu` VALUES ('1028', '字典修改', '105', '3', '#', '', '', '1', '0', 'F', '0', '0', 'system:dict:edit', '#', 'admin', '2022-03-25 23:20:27', '', null, '');
INSERT INTO `sys_menu` VALUES ('1029', '字典删除', '105', '4', '#', '', '', '1', '0', 'F', '0', '0', 'system:dict:remove', '#', 'admin', '2022-03-25 23:20:27', '', null, '');
INSERT INTO `sys_menu` VALUES ('1030', '字典导出', '105', '5', '#', '', '', '1', '0', 'F', '0', '0', 'system:dict:export', '#', 'admin', '2022-03-25 23:20:27', '', null, '');
INSERT INTO `sys_menu` VALUES ('1031', '参数查询', '106', '1', '#', '', '', '1', '0', 'F', '0', '0', 'system:config:query', '#', 'admin', '2022-03-25 23:20:27', '', null, '');
INSERT INTO `sys_menu` VALUES ('1032', '参数新增', '106', '2', '#', '', '', '1', '0', 'F', '0', '0', 'system:config:add', '#', 'admin', '2022-03-25 23:20:27', '', null, '');
INSERT INTO `sys_menu` VALUES ('1033', '参数修改', '106', '3', '#', '', '', '1', '0', 'F', '0', '0', 'system:config:edit', '#', 'admin', '2022-03-25 23:20:27', '', null, '');
INSERT INTO `sys_menu` VALUES ('1034', '参数删除', '106', '4', '#', '', '', '1', '0', 'F', '0', '0', 'system:config:remove', '#', 'admin', '2022-03-25 23:20:27', '', null, '');
INSERT INTO `sys_menu` VALUES ('1035', '参数导出', '106', '5', '#', '', '', '1', '0', 'F', '0', '0', 'system:config:export', '#', 'admin', '2022-03-25 23:20:27', '', null, '');
INSERT INTO `sys_menu` VALUES ('1036', '公告查询', '107', '1', '#', '', '', '1', '0', 'F', '0', '0', 'system:notice:query', '#', 'admin', '2022-03-25 23:20:27', '', null, '');
INSERT INTO `sys_menu` VALUES ('1037', '公告新增', '107', '2', '#', '', '', '1', '0', 'F', '0', '0', 'system:notice:add', '#', 'admin', '2022-03-25 23:20:27', '', null, '');
INSERT INTO `sys_menu` VALUES ('1038', '公告修改', '107', '3', '#', '', '', '1', '0', 'F', '0', '0', 'system:notice:edit', '#', 'admin', '2022-03-25 23:20:27', '', null, '');
INSERT INTO `sys_menu` VALUES ('1039', '公告删除', '107', '4', '#', '', '', '1', '0', 'F', '0', '0', 'system:notice:remove', '#', 'admin', '2022-03-25 23:20:27', '', null, '');
INSERT INTO `sys_menu` VALUES ('1040', '操作查询', '500', '1', '#', '', '', '1', '0', 'F', '0', '0', 'system:operlog:query', '#', 'admin', '2022-03-25 23:20:27', '', null, '');
INSERT INTO `sys_menu` VALUES ('1041', '操作删除', '500', '2', '#', '', '', '1', '0', 'F', '0', '0', 'system:operlog:remove', '#', 'admin', '2022-03-25 23:20:27', '', null, '');
INSERT INTO `sys_menu` VALUES ('1042', '日志导出', '500', '4', '#', '', '', '1', '0', 'F', '0', '0', 'system:operlog:export', '#', 'admin', '2022-03-25 23:20:28', '', null, '');
INSERT INTO `sys_menu` VALUES ('1043', '登录查询', '501', '1', '#', '', '', '1', '0', 'F', '0', '0', 'system:logininfor:query', '#', 'admin', '2022-03-25 23:20:28', '', null, '');
INSERT INTO `sys_menu` VALUES ('1044', '登录删除', '501', '2', '#', '', '', '1', '0', 'F', '0', '0', 'system:logininfor:remove', '#', 'admin', '2022-03-25 23:20:28', '', null, '');
INSERT INTO `sys_menu` VALUES ('1045', '日志导出', '501', '3', '#', '', '', '1', '0', 'F', '0', '0', 'system:logininfor:export', '#', 'admin', '2022-03-25 23:20:28', '', null, '');
INSERT INTO `sys_menu` VALUES ('1046', '在线查询', '109', '1', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:online:query', '#', 'admin', '2022-03-25 23:20:28', '', null, '');
INSERT INTO `sys_menu` VALUES ('1047', '批量强退', '109', '2', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:online:batchLogout', '#', 'admin', '2022-03-25 23:20:28', '', null, '');
INSERT INTO `sys_menu` VALUES ('1048', '单条强退', '109', '3', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:online:forceLogout', '#', 'admin', '2022-03-25 23:20:28', '', null, '');
INSERT INTO `sys_menu` VALUES ('1049', '任务查询', '110', '1', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:job:query', '#', 'admin', '2022-03-25 23:20:28', '', null, '');
INSERT INTO `sys_menu` VALUES ('1050', '任务新增', '110', '2', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:job:add', '#', 'admin', '2022-03-25 23:20:28', '', null, '');
INSERT INTO `sys_menu` VALUES ('1051', '任务修改', '110', '3', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:job:edit', '#', 'admin', '2022-03-25 23:20:28', '', null, '');
INSERT INTO `sys_menu` VALUES ('1052', '任务删除', '110', '4', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:job:remove', '#', 'admin', '2022-03-25 23:20:28', '', null, '');
INSERT INTO `sys_menu` VALUES ('1053', '状态修改', '110', '5', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:job:changeStatus', '#', 'admin', '2022-03-25 23:20:28', '', null, '');
INSERT INTO `sys_menu` VALUES ('1054', '任务导出', '110', '7', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:job:export', '#', 'admin', '2022-03-25 23:20:28', '', null, '');
INSERT INTO `sys_menu` VALUES ('1055', '生成查询', '115', '1', '#', '', '', '1', '0', 'F', '0', '0', 'tool:gen:query', '#', 'admin', '2022-03-25 23:20:28', '', null, '');
INSERT INTO `sys_menu` VALUES ('1056', '生成修改', '115', '2', '#', '', '', '1', '0', 'F', '0', '0', 'tool:gen:edit', '#', 'admin', '2022-03-25 23:20:28', '', null, '');
INSERT INTO `sys_menu` VALUES ('1057', '生成删除', '115', '3', '#', '', '', '1', '0', 'F', '0', '0', 'tool:gen:remove', '#', 'admin', '2022-03-25 23:20:28', '', null, '');
INSERT INTO `sys_menu` VALUES ('1058', '导入代码', '115', '2', '#', '', '', '1', '0', 'F', '0', '0', 'tool:gen:import', '#', 'admin', '2022-03-25 23:20:28', '', null, '');
INSERT INTO `sys_menu` VALUES ('1059', '预览代码', '115', '4', '#', '', '', '1', '0', 'F', '0', '0', 'tool:gen:preview', '#', 'admin', '2022-03-25 23:20:28', '', null, '');
INSERT INTO `sys_menu` VALUES ('1060', '生成代码', '115', '5', '#', '', '', '1', '0', 'F', '0', '0', 'tool:gen:code', '#', 'admin', '2022-03-25 23:20:28', '', null, '');
INSERT INTO `sys_notice` VALUES ('1', '温馨提醒：2018-07-01 若依新版本发布啦', '2', 0xE696B0E78988E69CACE58685E5AEB9, '0', 'admin', '2022-03-25 23:20:40', '', null, '管理员');
INSERT INTO `sys_notice` VALUES ('2', '维护通知：2018-07-01 若依系统凌晨维护', '1', 0xE7BBB4E68AA4E58685E5AEB9, '0', 'admin', '2022-03-25 23:20:40', '', null, '管理员');
INSERT INTO `sys_post` VALUES ('1', 'ceo', '董事长', '1', '0', 'admin', '2022-03-25 23:20:24', '', null, '');
INSERT INTO `sys_post` VALUES ('2', 'se', '项目经理', '2', '0', 'admin', '2022-03-25 23:20:24', '', null, '');
INSERT INTO `sys_post` VALUES ('3', 'hr', '人力资源', '3', '0', 'admin', '2022-03-25 23:20:24', '', null, '');
INSERT INTO `sys_post` VALUES ('4', 'user', '普通员工', '4', '0', 'admin', '2022-03-25 23:20:24', '', null, '');
INSERT INTO `sys_role` VALUES ('1', '超级管理员', 'admin', '1', '1', '1', '1', '0', '0', 'admin', '2022-03-25 23:20:25', '', null, '超级管理员');
INSERT INTO `sys_role` VALUES ('2', '普通角色', 'common', '2', '2', '1', '1', '0', '0', 'admin', '2022-03-25 23:20:25', '', null, '普通角色');
INSERT INTO `sys_role_dept` VALUES ('2', '100');
INSERT INTO `sys_role_dept` VALUES ('2', '101');
INSERT INTO `sys_role_dept` VALUES ('2', '105');
INSERT INTO `sys_role_menu` VALUES ('2', '1');
INSERT INTO `sys_role_menu` VALUES ('2', '2');
INSERT INTO `sys_role_menu` VALUES ('2', '3');
INSERT INTO `sys_role_menu` VALUES ('2', '4');
INSERT INTO `sys_role_menu` VALUES ('2', '100');
INSERT INTO `sys_role_menu` VALUES ('2', '101');
INSERT INTO `sys_role_menu` VALUES ('2', '102');
INSERT INTO `sys_role_menu` VALUES ('2', '103');
INSERT INTO `sys_role_menu` VALUES ('2', '104');
INSERT INTO `sys_role_menu` VALUES ('2', '105');
INSERT INTO `sys_role_menu` VALUES ('2', '106');
INSERT INTO `sys_role_menu` VALUES ('2', '107');
INSERT INTO `sys_role_menu` VALUES ('2', '108');
INSERT INTO `sys_role_menu` VALUES ('2', '109');
INSERT INTO `sys_role_menu` VALUES ('2', '110');
INSERT INTO `sys_role_menu` VALUES ('2', '111');
INSERT INTO `sys_role_menu` VALUES ('2', '112');
INSERT INTO `sys_role_menu` VALUES ('2', '113');
INSERT INTO `sys_role_menu` VALUES ('2', '114');
INSERT INTO `sys_role_menu` VALUES ('2', '115');
INSERT INTO `sys_role_menu` VALUES ('2', '116');
INSERT INTO `sys_role_menu` VALUES ('2', '500');
INSERT INTO `sys_role_menu` VALUES ('2', '501');
INSERT INTO `sys_role_menu` VALUES ('2', '1000');
INSERT INTO `sys_role_menu` VALUES ('2', '1001');
INSERT INTO `sys_role_menu` VALUES ('2', '1002');
INSERT INTO `sys_role_menu` VALUES ('2', '1003');
INSERT INTO `sys_role_menu` VALUES ('2', '1004');
INSERT INTO `sys_role_menu` VALUES ('2', '1005');
INSERT INTO `sys_role_menu` VALUES ('2', '1006');
INSERT INTO `sys_role_menu` VALUES ('2', '1007');
INSERT INTO `sys_role_menu` VALUES ('2', '1008');
INSERT INTO `sys_role_menu` VALUES ('2', '1009');
INSERT INTO `sys_role_menu` VALUES ('2', '1010');
INSERT INTO `sys_role_menu` VALUES ('2', '1011');
INSERT INTO `sys_role_menu` VALUES ('2', '1012');
INSERT INTO `sys_role_menu` VALUES ('2', '1013');
INSERT INTO `sys_role_menu` VALUES ('2', '1014');
INSERT INTO `sys_role_menu` VALUES ('2', '1015');
INSERT INTO `sys_role_menu` VALUES ('2', '1016');
INSERT INTO `sys_role_menu` VALUES ('2', '1017');
INSERT INTO `sys_role_menu` VALUES ('2', '1018');
INSERT INTO `sys_role_menu` VALUES ('2', '1019');
INSERT INTO `sys_role_menu` VALUES ('2', '1020');
INSERT INTO `sys_role_menu` VALUES ('2', '1021');
INSERT INTO `sys_role_menu` VALUES ('2', '1022');
INSERT INTO `sys_role_menu` VALUES ('2', '1023');
INSERT INTO `sys_role_menu` VALUES ('2', '1024');
INSERT INTO `sys_role_menu` VALUES ('2', '1025');
INSERT INTO `sys_role_menu` VALUES ('2', '1026');
INSERT INTO `sys_role_menu` VALUES ('2', '1027');
INSERT INTO `sys_role_menu` VALUES ('2', '1028');
INSERT INTO `sys_role_menu` VALUES ('2', '1029');
INSERT INTO `sys_role_menu` VALUES ('2', '1030');
INSERT INTO `sys_role_menu` VALUES ('2', '1031');
INSERT INTO `sys_role_menu` VALUES ('2', '1032');
INSERT INTO `sys_role_menu` VALUES ('2', '1033');
INSERT INTO `sys_role_menu` VALUES ('2', '1034');
INSERT INTO `sys_role_menu` VALUES ('2', '1035');
INSERT INTO `sys_role_menu` VALUES ('2', '1036');
INSERT INTO `sys_role_menu` VALUES ('2', '1037');
INSERT INTO `sys_role_menu` VALUES ('2', '1038');
INSERT INTO `sys_role_menu` VALUES ('2', '1039');
INSERT INTO `sys_role_menu` VALUES ('2', '1040');
INSERT INTO `sys_role_menu` VALUES ('2', '1041');
INSERT INTO `sys_role_menu` VALUES ('2', '1042');
INSERT INTO `sys_role_menu` VALUES ('2', '1043');
INSERT INTO `sys_role_menu` VALUES ('2', '1044');
INSERT INTO `sys_role_menu` VALUES ('2', '1045');
INSERT INTO `sys_role_menu` VALUES ('2', '1046');
INSERT INTO `sys_role_menu` VALUES ('2', '1047');
INSERT INTO `sys_role_menu` VALUES ('2', '1048');
INSERT INTO `sys_role_menu` VALUES ('2', '1049');
INSERT INTO `sys_role_menu` VALUES ('2', '1050');
INSERT INTO `sys_role_menu` VALUES ('2', '1051');
INSERT INTO `sys_role_menu` VALUES ('2', '1052');
INSERT INTO `sys_role_menu` VALUES ('2', '1053');
INSERT INTO `sys_role_menu` VALUES ('2', '1054');
INSERT INTO `sys_role_menu` VALUES ('2', '1055');
INSERT INTO `sys_role_menu` VALUES ('2', '1056');
INSERT INTO `sys_role_menu` VALUES ('2', '1057');
INSERT INTO `sys_role_menu` VALUES ('2', '1058');
INSERT INTO `sys_role_menu` VALUES ('2', '1059');
INSERT INTO `sys_role_menu` VALUES ('2', '1060');
INSERT INTO `sys_user` VALUES ('1', '103', 'admin', '若依', '00', 'ry@163.com', '15888888888', '1', '', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '127.0.0.1', '2022-03-25 23:20:24', 'admin', '2022-03-25 23:20:24', '', null, '管理员');
INSERT INTO `sys_user` VALUES ('2', '105', 'ry', '若依', '00', 'ry@qq.com', '15666666666', '1', '', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '127.0.0.1', '2022-03-25 23:20:24', 'admin', '2022-03-25 23:20:24', '', null, '测试员');
INSERT INTO `sys_user_post` VALUES ('1', '1');
INSERT INTO `sys_user_post` VALUES ('2', '2');
INSERT INTO `sys_user_role` VALUES ('1', '1');
INSERT INTO `sys_user_role` VALUES ('2', '2');
INSERT INTO `users` VALUES ('nacos', '$2a$10$EuWPZHzz32dJN7jexM34MOeYirDdFAZm2kuWj7VEOJhhZkDrxfvUu', '1');

2.启动nacos2.0.4

frank_jxust
关注
专栏目录
Ruoyi-Cloud-Plus_使用Docker部署分布式微服务系统_Docker部署系统_002_Idea配置_构建镜像---SpringCloud工作笔记201
添柴程序猿的专栏
04-01 220
这里的Docker是需要自己创建的.上面显示的SpringBoot的内容也是,通过点击Run Configuration Type,然后在列表选择Docker之类的就可以了。然后继续来看,如何开启一个端口来让外部访问:这里的几个步骤,整合了官网的安装过程,这样整合以后,就可以直接看着安装了.看到下面有个terminal,打开,然后点击向下那个箭头,找到,刚刚配置的SSH,以后,然后再去。然后打开idea的terminal窗口,然后下拉箭头选择,我们连接的服务器,然后。可以看到在这里弹出的框中选择就可以了,
ruoyi-cloud 启动踩过的坑
m0_56708916的博客
05-26 1357
1：nacos下载 安装 配置 最终结果是这样的 官网下载--解压就好了，实在不会的加我QQ:3245792286 2：nacos修改配置文件 1）找到图中的文件打开，记事本就能打开。 2）改成自己的相关配置 3创建数据库：（默认已经拉取代码 ，在ruoyi里面找到sql，下面SQL图中的位置） 1）新建数据库ry-cloud 运行SQLry_20210210.sqlquartz.sql SQL图 2）运行SQLry_config_20210228.sql ...
ruoyi-cloud开发配置
weixin_62799021的博客
05-16 1520
配置文件实际上是存储在ry-config里的，redis默认没密码,mysql设置自己的密码。出错的模块检查nacos有没有改数据库配置，项目里有没有配置nacos账户和密码。右键编辑nacos\conf\application.properties。修改nacos\conf\application.properties,由于我们开启了鉴权，需要在各模块添加nacos的用户和密码,在下面粘上若依的配置,修改自己的数据库地址和密码。双击nacos\bin\startup.cmd。找到mysql的配置。
RuoYi-Cloud 部署
mole的专栏
02-11 1067
偌依微服务框架的部署实战
RuoYi-Cloud部署实战（手动部署）
冰可乐味儿的深哥哥、
04-17 2926
1.若依源码和架构 2.准备工作 3.本地部署步骤 4.上云部署步骤（手动）
从零开始有图：若依前端分离框架RuoYi-Vue(Vue2版本)的配置与运行
m0_74865737的博客
08-04 2887
从零开始有图：若依前端分离框架RuoYi-Vue(Vue2版本)的配置与运行
若依微服务版本RuoYi-Cloud从配置到运行详细教程
weixin_52861960的博客
06-03 2302
若依微服务版本RuoYi-Cloud从配置到运行详细教程。
配置文件 - RuoyiCloud启动配置
zs1972551648的博客
03-06 5638
若依 cloud 初次启动 配置文件
RuoYiCloud.rar
08-20
在配置Sentinel时，需要在RuoYiCloud的配置文件（如`application.yml`或`application.properties`）中指定Sentinel的地址和端口，以便服务启动后能够连接到Sentinel控制台。Sentinel控制台提供了丰富的监控和管理...
若依框架（RuoYi-Cloud 微服务版本）
08-30
- **集成示例**：在若依框架中，通过简单的配置即可启动Spring Boot应用，并利用Spring Cloud Alibaba提供的组件来实现服务注册、服务调用、配置管理等功能。 ##### 2. 权限管理系统 - **RBAC模型**：若依框架采用...
十、RuoYi-Cloud部署实战
qq_41590713的博客
05-09 578
5、微服务默认启动加载 nacos中 服务名-激活的环境.yml 文件，所以线上的配置可以全部写在nacos中。4、nacos集群内地址为 his-nacos.his:8848。3、环境变量 PARAMS 可以动态指定配置文件中任意的值。1、容器默认以8080端口启动。1、下载nacos数据库文件。
RuoYi_Cloud本地搭建
最新发布
2301_79456272的博客
06-28 1142
电脑左下角设置——更新和安全——windos安全中心——防火墙和网络防护——下面的高级设置——入站规则——新建规则——选端口——填3306——一直下一步——填上信息就可以。如果启动没成功，我遇到的问题可能是mysql没有打开远程链接或者电脑防火墙不允许外界访问。然后进入mysql——再查询是否开启权限，如果root前面是localhost则并未开启。复制绝对路径——打开数据库——右键ruoyi_cloud数据库——运行sql文件。打开idea——打开sql 模块。服务列表正常显示~~~~ok。
ruoyi-cloud版本最新环境部署 - 详细步骤
yinshuilan的专栏
03-23 4323
安装nginx(具体步骤参考。，npm会自动安装好。
从0开始搭建若依微服务项目 RuoYi-Cloud（保姆式教程 一）
全栈技术分享，项目分享，资料分享
01-28 8629
一直想做一款后台管理系统，看了很多优秀的开源项目但是发现没有合适的。于是利用空闲休息时间开 始自己写了一套后台系统。如此有了若依。她可以用于所有的Web应用程序，如网站管理后台，网站会 员中心，CMS，CRM，OA。所有前端后台代码封装过后十分精简易上手，出错概率低。同时支持移动 客户端访问。系统会陆续更新一些实用功能。性别男，若依是给女儿取的名字（寓意：你若不离不弃，我必生死相依） 若依是一套全部开源的快速开发平台，毫无保留给个人及企业免费使用。
若依项目springcloud启动
蠢蠢欲动的猫
04-11 3899
熟练使用springboot相关技术了解springcloud相关技术电脑配置可以支持。
若依微服务版启动（RuoYi-Cloud）教程
cs_dnzk的博客
01-04 4376
新建数据库ry-config，在此数据库下执行ry_config_20231204.sql这个sql文件。（注意：这个数据库的作用就是在nacos启动后去ry-config中读取配置信息，执行错误会导致nacos获取不到服务。(执行此命令，即可登录）。启动前先去Nacos的解压目录下的conf下的application.properties文件中，【找到自己的nacos安装目录】找到nacos下的bin目录下的startup.cmd【nacos启动脚本】， 修改启动模式为：standalone。
RuoYi-Cloud 若依微服务版启动教程
weixin_47425074的博客
05-06 1553
内容
若依cloud本地启动步骤
u011620393的博客
05-12 2188
若依cloud本地启动步骤 1、从git上clone代码下来 git clone https://gitee.com/y_project/RuoYi-Cloud.git 2、执行项目中的SQL文件 新增本地数据库，本地数据库名称为：ry-cloud quartz.sql ry_20210210.sql ry_config_20210228.sql ry_seata_20210128.sql 3、安装本地nacos (1)、配置nacos的config下的文件 打开application.properti
ruoyi cloud启动nacos
05-25
要在Ruoyi Cloud中启动Nacos，需要进行以下步骤： 1. 在Ruoyi Cloud控制台中，进入应用管理，创建一个新的应用，并选择Java语言。 2. 在新应用的“部署设置”中，选择“容器服务”并创建一个新的容器服务。 3. 在...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

frank_jxust

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值