text: 
  
  DROP TABLE IF EXISTS `gen_table`;
  
  CREATE TABLE `gen_table` (
                               `table_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
                               `table_name` varchar(200) COLLATE utf8mb4_bin DEFAULT '' COMMENT '表名称',
                               `table_comment` varchar(500) COLLATE utf8mb4_bin DEFAULT '' COMMENT '表描述',
                               `sub_table_name` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '关联子表的表名',
                               `sub_table_fk_name` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '子表关联的外键名',
                               `class_name` varchar(100) COLLATE utf8mb4_bin DEFAULT '' COMMENT '实体类名称',
                               `tpl_category` varchar(200) COLLATE utf8mb4_bin DEFAULT 'crud' COMMENT '使用的模板（crud单表操作 tree树表操作 sub主子表操作）',
                               `package_name` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '生成包路径',
                               `module_name` varchar(30) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '生成模块名',
                               `business_name` varchar(30) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '生成业务名',
                               `function_name` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '生成功能名',
                               `function_author` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '生成功能作者',
                               `gen_type` char(1) COLLATE utf8mb4_bin DEFAULT '0' COMMENT '生成代码方式（0zip压缩包 1自定义路径）',
                               `gen_path` varchar(200) COLLATE utf8mb4_bin DEFAULT '/' COMMENT '生成路径（不填默认项目路径）',
                               `options` varchar(1000) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '其它生成选项',
                               `create_by` varchar(64) COLLATE utf8mb4_bin DEFAULT '' COMMENT '创建者',
                               `create_time` datetime DEFAULT NULL COMMENT '创建时间',
                               `update_by` varchar(64) COLLATE utf8mb4_bin DEFAULT '' COMMENT '更新者',
                               `update_time` datetime DEFAULT NULL COMMENT '更新时间',
                               `remark` varchar(500) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注',
                               PRIMARY KEY (`table_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='代码生成业务表';
  
  /*Data for the table `gen_table` */
  
  insert  into `gen_table`(`table_id`,`table_name`,`table_comment`,`sub_table_name`,`sub_table_fk_name`,`class_name`,`tpl_category`,`package_name`,`module_name`,`business_name`,`function_name`,`function_author`,`gen_type`,`gen_path`,`options`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) values (1,'sana_nodes','sana 节点信息','',NULL,'SanaNodes','crud','com.ruoyi.sana','sana','nodes','sana配置','tiger.w','0','/','{\"parentMenuId\":\"2000\",\"treeName\":\"\",\"treeParentCode\":\"\",\"parentMenuName\":\"sana\",\"treeCode\":\"\"}','admin','2021-10-20 10:53:01','','2021-10-20 11:08:39','');
  
  /*Table structure for table `gen_table_column` */
  
  DROP TABLE IF EXISTS `gen_table_column`;
  
  CREATE TABLE `gen_table_column` (
                                      `column_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
                                      `table_id` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '归属表编号',
                                      `column_name` varchar(200) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '列名称',
                                      `column_comment` varchar(500) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '列描述',
                                      `column_type` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '列类型',
                                      `java_type` varchar(500) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'JAVA类型',
                                      `java_field` varchar(200) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'JAVA字段名',
                                      `is_pk` char(1) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '是否主键（1是）',
                                      `is_increment` char(1) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '是否自增（1是）',
                                      `is_required` char(1) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '是否必填（1是）',
                                      `is_insert` char(1) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '是否为插入字段（1是）',
                                      `is_edit` char(1) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '是否编辑字段（1是）',
                                      `is_list` char(1) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '是否列表字段（1是）',
                                      `is_query` char(1) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '是否查询字段（1是）',
                                      `query_type` varchar(200) COLLATE utf8mb4_bin DEFAULT 'EQ' COMMENT '查询方式（等于、不等于、大于、小于、范围）',
                                      `html_type` varchar(200) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '显示类型（文本框、文本域、下拉框、复选框、单选框、日期控件）',
                                      `dict_type` varchar(200) COLLATE utf8mb4_bin DEFAULT '' COMMENT '字典类型',
                                      `sort` int(11) DEFAULT NULL COMMENT '排序',
                                      `create_by` varchar(64) COLLATE utf8mb4_bin DEFAULT '' COMMENT '创建者',
                                      `create_time` datetime DEFAULT NULL COMMENT '创建时间',
                                      `update_by` varchar(64) COLLATE utf8mb4_bin DEFAULT '' COMMENT '更新者',
                                      `update_time` datetime DEFAULT NULL COMMENT '更新时间',
                                      PRIMARY KEY (`column_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='代码生成业务表字段';
  
  /*Data for the table `gen_table_column` */
  
  insert  into `gen_table_column`(`column_id`,`table_id`,`column_name`,`column_comment`,`column_type`,`java_type`,`java_field`,`is_pk`,`is_increment`,`is_required`,`is_insert`,`is_edit`,`is_list`,`is_query`,`query_type`,`html_type`,`dict_type`,`sort`,`create_by`,`create_time`,`update_by`,`update_time`) values (1,'1','id','id','bigint(20)','Long','id','1','1',NULL,'1',NULL,NULL,NULL,'EQ','input','',1,'admin','2021-10-20 10:53:01',NULL,'2021-10-20 11:08:39'),(2,'1','name','名称','varchar(64)','String','name','0','0','1','1','1','1','1','LIKE','input','',2,'admin','2021-10-20 10:53:01',NULL,'2021-10-20 11:08:39'),(3,'1','dashboard_auth','Dashboard Authrization','varchar(1024)','String','dashboardAuth','0','0',NULL,'1','1','1',NULL,'EQ','input','',3,'admin','2021-10-20 10:53:01',NULL,'2021-10-20 11:08:39'),(4,'1','api_endpoint','api endpoint','varchar(512)','String','apiEndpoint','0','0',NULL,'1','1','1',NULL,'EQ','input','',4,'admin','2021-10-20 10:53:01',NULL,'2021-10-20 11:08:39'),(5,'1','debug_api_endpoint','debug api endpoint','varchar(512)','String','debugApiEndpoint','0','0',NULL,'1','1','1',NULL,'EQ','input','',5,'admin','2021-10-20 10:53:01',NULL,'2021-10-20 11:08:39'),(6,'1','remark','备注','varchar(512)','String','remark','0','0',NULL,'1','1','1',NULL,'EQ','textarea','',6,'admin','2021-10-20 10:53:01',NULL,'2021-10-20 11:08:39'),(7,'1','create_time','','datetime','Date','createTime','0','0',NULL,'1',NULL,NULL,NULL,'EQ','datetime','',7,'admin','2021-10-20 10:53:01',NULL,'2021-10-20 11:08:39');
  
  /*Table structure for table `sana_nodes` */
  
  DROP TABLE IF EXISTS `sana_nodes`;
  
  CREATE TABLE `sana_nodes` (
                                `id` bigint(20) NOT NULL AUTO_INCREMENT,
                                `name` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL,
                                `dashboard_auth` varchar(1024) COLLATE utf8mb4_bin DEFAULT NULL,
                                `api_endpoint` varchar(512) COLLATE utf8mb4_bin DEFAULT NULL,
                                `debug_api_endpoint` varchar(512) COLLATE utf8mb4_bin DEFAULT NULL,
                                `remark` varchar(512) COLLATE utf8mb4_bin DEFAULT NULL,
                                `create_time` datetime DEFAULT NULL,
                                PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
  
  /*Data for the table `sana_nodes` */
  
  insert  into `sana_nodes`(`id`,`name`,`dashboard_auth`,`api_endpoint`,`debug_api_endpoint`,`remark`,`create_time`) values (2,'Node8','1','http://120.79.4.84:3651','http://120.79.4.84:3653','1','2021-10-20 13:27:30'),(3,'Node7','','http://120.79.4.84:3648','http://120.79.4.84:3650','','2021-10-20 13:34:01');
  
  /*Table structure for table `sys_config` */
  
  DROP TABLE IF EXISTS `sys_config`;
  
  CREATE TABLE `sys_config` (
                                `config_id` int(5) NOT NULL AUTO_INCREMENT COMMENT '参数主键',
                                `config_name` varchar(100) COLLATE utf8mb4_bin DEFAULT '' COMMENT '参数名称',
                                `config_key` varchar(100) COLLATE utf8mb4_bin DEFAULT '' COMMENT '参数键名',
                                `config_value` varchar(500) COLLATE utf8mb4_bin DEFAULT '' COMMENT '参数键值',
                                `config_type` char(1) COLLATE utf8mb4_bin DEFAULT 'N' COMMENT '系统内置（Y是 N否）',
                                `create_by` varchar(64) COLLATE utf8mb4_bin DEFAULT '' COMMENT '创建者',
                                `create_time` datetime DEFAULT NULL COMMENT '创建时间',
                                `update_by` varchar(64) COLLATE utf8mb4_bin DEFAULT '' COMMENT '更新者',
                                `update_time` datetime DEFAULT NULL COMMENT '更新时间',
                                `remark` varchar(500) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注',
                                PRIMARY KEY (`config_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='参数配置表';
  
  /*Data for the table `sys_config` */
  
  insert  into `sys_config`(`config_id`,`config_name`,`config_key`,`config_value`,`config_type`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) values (1,'主框架页-默认皮肤样式名称','sys.index.skinName','skin-blue','Y','admin','2021-10-20 10:28:45','',NULL,'蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow'),(2,'用户管理-账号初始密码','sys.user.initPassword','123456','Y','admin','2021-10-20 10:28:45','',NULL,'初始化密码 123456'),(3,'主框架页-侧边栏主题','sys.index.sideTheme','theme-dark','Y','admin','2021-10-20 10:28:45','',NULL,'深黑主题theme-dark，浅色主题theme-light，深蓝主题theme-blue'),(4,'账号自助-是否开启用户注册功能','sys.account.registerUser','false','Y','admin','2021-10-20 10:28:45','',NULL,'是否开启注册用户功能（true开启，false关闭）'),(5,'用户管理-密码字符范围','sys.account.chrtype','0','Y','admin','2021-10-20 10:28:45','',NULL,'默认任意字符范围，0任意（密码可以输入任意字符），1数字（密码只能为0-9数字），2英文字母（密码只能为a-z和A-Z字母），3字母和数字（密码必须包含字母，数字）,4字母数字和特殊字符（目前支持的特殊字符包括：~!@#$%^&*()-=_+）'),(6,'用户管理-初始密码修改策略','sys.account.initPasswordModify','0','Y','admin','2021-10-20 10:28:45','',NULL,'0：初始密码修改策略关闭，没有任何提示，1：提醒用户，如果未修改初始密码，则在登录时就会提醒修改密码对话框'),(7,'用户管理-账号密码更新周期','sys.account.passwordValidateDays','0','Y','admin','2021-10-20 10:28:45','',NULL,'密码更新周期（填写数字，数据初始化值为0不限制，若修改必须为大于0小于365的正整数），如果超过这个周期登录系统时，则在登录时就会提醒修改密码对话框'),(8,'主框架页-菜单导航显示风格','sys.index.menuStyle','default','Y','admin','2021-10-20 10:28:45','',NULL,'菜单导航显示风格（default为左侧导航菜单，topnav为顶部导航菜单）'),(9,'主框架页-是否开启页脚','sys.index.footer','true','Y','admin','2021-10-20 10:28:45','',NULL,'是否开启底部页脚显示（true显示，false隐藏）'),(10,'主框架页-是否开启页签','sys.index.tagsView','true','Y','admin','2021-10-20 10:28:45','',NULL,'是否开启菜单多页签显示（true显示，false隐藏）');
  
  /*Table structure for table `sys_dept` */
  
  DROP TABLE IF EXISTS `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) COLLATE utf8mb4_bin DEFAULT '' COMMENT '祖级列表',
                              `dept_name` varchar(30) COLLATE utf8mb4_bin DEFAULT '' COMMENT '部门名称',
                              `order_num` int(4) DEFAULT '0' COMMENT '显示顺序',
                              `leader` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '负责人',
                              `phone` varchar(11) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '联系电话',
                              `email` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '邮箱',
                              `status` char(1) COLLATE utf8mb4_bin DEFAULT '0' COMMENT '部门状态（0正常 1停用）',
                              `del_flag` char(1) COLLATE utf8mb4_bin DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
                              `create_by` varchar(64) COLLATE utf8mb4_bin DEFAULT '' COMMENT '创建者',
                              `create_time` datetime DEFAULT NULL COMMENT '创建时间',
                              `update_by` varchar(64) COLLATE utf8mb4_bin DEFAULT '' COMMENT '更新者',
                              `update_time` datetime DEFAULT NULL COMMENT '更新时间',
                              PRIMARY KEY (`dept_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=200 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='部门表';
  
  /*Data for the table `sys_dept` */
  
  insert  into `sys_dept`(`dept_id`,`parent_id`,`ancestors`,`dept_name`,`order_num`,`leader`,`phone`,`email`,`status`,`del_flag`,`create_by`,`create_time`,`update_by`,`update_time`) values (100,0,'0','若依科技',0,'若依','15888888888','ry@qq.com','0','0','admin','2021-10-20 10:28:26','',NULL),(101,100,'0,100','深圳总公司',1,'若依','15888888888','ry@qq.com','0','0','admin','2021-10-20 10:28:26','',NULL),(102,100,'0,100','长沙分公司',2,'若依','15888888888','ry@qq.com','0','0','admin','2021-10-20 10:28:26','',NULL),(103,101,'0,100,101','研发部门',1,'若依','15888888888','ry@qq.com','0','0','admin','2021-10-20 10:28:26','',NULL),(104,101,'0,100,101','市场部门',2,'若依','15888888888','ry@qq.com','0','0','admin','2021-10-20 10:28:26','',NULL),(105,101,'0,100,101','测试部门',3,'若依','15888888888','ry@qq.com','0','0','admin','2021-10-20 10:28:26','',NULL),(106,101,'0,100,101','财务部门',4,'若依','15888888888','ry@qq.com','0','0','admin','2021-10-20 10:28:26','',NULL),(107,101,'0,100,101','运维部门',5,'若依','15888888888','ry@qq.com','0','0','admin','2021-10-20 10:28:26','',NULL),(108,102,'0,100,102','市场部门',1,'若依','15888888888','ry@qq.com','0','0','admin','2021-10-20 10:28:26','',NULL),(109,102,'0,100,102','财务部门',2,'若依','15888888888','ry@qq.com','0','0','admin','2021-10-20 10:28:26','',NULL);
  
  /*Table structure for table `sys_dict_data` */
  
  DROP TABLE IF EXISTS `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) COLLATE utf8mb4_bin DEFAULT '' COMMENT '字典标签',
                                   `dict_value` varchar(100) COLLATE utf8mb4_bin DEFAULT '' COMMENT '字典键值',
                                   `dict_type` varchar(100) COLLATE utf8mb4_bin DEFAULT '' COMMENT '字典类型',
                                   `css_class` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '样式属性（其他样式扩展）',
                                   `list_class` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '表格回显样式',
                                   `is_default` char(1) COLLATE utf8mb4_bin DEFAULT 'N' COMMENT '是否默认（Y是 N否）',
                                   `status` char(1) COLLATE utf8mb4_bin DEFAULT '0' COMMENT '状态（0正常 1停用）',
                                   `create_by` varchar(64) COLLATE utf8mb4_bin DEFAULT '' COMMENT '创建者',
                                   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
                                   `update_by` varchar(64) COLLATE utf8mb4_bin DEFAULT '' COMMENT '更新者',
                                   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
                                   `remark` varchar(500) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注',
                                   PRIMARY KEY (`dict_code`)
  ) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='字典数据表';
  
  /*Data for the table `sys_dict_data` */
  
  insert  into `sys_dict_data`(`dict_code`,`dict_sort`,`dict_label`,`dict_value`,`dict_type`,`css_class`,`list_class`,`is_default`,`status`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) values (1,1,'男','0','sys_user_sex','','','Y','0','admin','2021-10-20 10:28:43','',NULL,'性别男'),(2,2,'女','1','sys_user_sex','','','N','0','admin','2021-10-20 10:28:43','',NULL,'性别女'),(3,3,'未知','2','sys_user_sex','','','N','0','admin','2021-10-20 10:28:43','',NULL,'性别未知'),(4,1,'显示','0','sys_show_hide','','primary','Y','0','admin','2021-10-20 10:28:43','',NULL,'显示菜单'),(5,2,'隐藏','1','sys_show_hide','','danger','N','0','admin','2021-10-20 10:28:43','',NULL,'隐藏菜单'),(6,1,'正常','0','sys_normal_disable','','primary','Y','0','admin','2021-10-20 10:28:43','',NULL,'正常状态'),(7,2,'停用','1','sys_normal_disable','','danger','N','0','admin','2021-10-20 10:28:43','',NULL,'停用状态'),(8,1,'正常','0','sys_job_status','','primary','Y','0','admin','2021-10-20 10:28:43','',NULL,'正常状态'),(9,2,'暂停','1','sys_job_status','','danger','N','0','admin','2021-10-20 10:28:43','',NULL,'停用状态'),(10,1,'默认','DEFAULT','sys_job_group','','','Y','0','admin','2021-10-20 10:28:43','',NULL,'默认分组'),(11,2,'系统','SYSTEM','sys_job_group','','','N','0','admin','2021-10-20 10:28:43','',NULL,'系统分组'),(12,1,'是','Y','sys_yes_no','','primary','Y','0','admin','2021-10-20 10:28:43','',NULL,'系统默认是'),(13,2,'否','N','sys_yes_no','','danger','N','0','admin','2021-10-20 10:28:43','',NULL,'系统默认否'),(14,1,'通知','1','sys_notice_type','','warning','Y','0','admin','2021-10-20 10:28:43','',NULL,'通知'),(15,2,'公告','2','sys_notice_type','','success','N','0','admin','2021-10-20 10:28:43','',NULL,'公告'),(16,1,'正常','0','sys_notice_status','','primary','Y','0','admin','2021-10-20 10:28:43','',NULL,'正常状态'),(17,2,'关闭','1','sys_notice_status','','danger','N','0','admin','2021-10-20 10:28:44','',NULL,'关闭状态'),(18,99,'其他','0','sys_oper_type','','info','N','0','admin','2021-10-20 10:28:44','',NULL,'其他操作'),(19,1,'新增','1','sys_oper_type','','info','N','0','admin','2021-10-20 10:28:44','',NULL,'新增操作'),(20,2,'修改','2','sys_oper_type','','info','N','0','admin','2021-10-20 10:28:44','',NULL,'修改操作'),(21,3,'删除','3','sys_oper_type','','danger','N','0','admin','2021-10-20 10:28:44','',NULL,'删除操作'),(22,4,'授权','4','sys_oper_type','','primary','N','0','admin','2021-10-20 10:28:44','',NULL,'授权操作'),(23,5,'导出','5','sys_oper_type','','warning','N','0','admin','2021-10-20 10:28:44','',NULL,'导出操作'),(24,6,'导入','6','sys_oper_type','','warning','N','0','admin','2021-10-20 10:28:44','',NULL,'导入操作'),(25,7,'强退','7','sys_oper_type','','danger','N','0','admin','2021-10-20 10:28:44','',NULL,'强退操作'),(26,8,'生成代码','8','sys_oper_type','','warning','N','0','admin','2021-10-20 10:28:44','',NULL,'生成操作'),(27,9,'清空数据','9','sys_oper_type','','danger','N','0','admin','2021-10-20 10:28:44','',NULL,'清空操作'),(28,1,'成功','0','sys_common_status','','primary','N','0','admin','2021-10-20 10:28:44','',NULL,'正常状态'),(29,2,'失败','1','sys_common_status','','danger','N','0','admin','2021-10-20 10:28:44','',NULL,'停用状态');
  
  /*Table structure for table `sys_dict_type` */
  
  DROP TABLE IF EXISTS `sys_dict_type`;
  
  CREATE TABLE `sys_dict_type` (
                                   `dict_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '字典主键',
                                   `dict_name` varchar(100) COLLATE utf8mb4_bin DEFAULT '' COMMENT '字典名称',
                                   `dict_type` varchar(100) COLLATE utf8mb4_bin DEFAULT '' COMMENT '字典类型',
                                   `status` char(1) COLLATE utf8mb4_bin DEFAULT '0' COMMENT '状态（0正常 1停用）',
                                   `create_by` varchar(64) COLLATE utf8mb4_bin DEFAULT '' COMMENT '创建者',
                                   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
                                   `update_by` varchar(64) COLLATE utf8mb4_bin DEFAULT '' COMMENT '更新者',
                                   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
                                   `remark` varchar(500) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注',
                                   PRIMARY KEY (`dict_id`),
                                   UNIQUE KEY `dict_type` (`dict_type`)
  ) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='字典类型表';
  
  /*Data for the table `sys_dict_type` */
  
  insert  into `sys_dict_type`(`dict_id`,`dict_name`,`dict_type`,`status`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) values (1,'用户性别','sys_user_sex','0','admin','2021-10-20 10:28:42','',NULL,'用户性别列表'),(2,'菜单状态','sys_show_hide','0','admin','2021-10-20 10:28:42','',NULL,'菜单状态列表'),(3,'系统开关','sys_normal_disable','0','admin','2021-10-20 10:28:42','',NULL,'系统开关列表'),(4,'任务状态','sys_job_status','0','admin','2021-10-20 10:28:42','',NULL,'任务状态列表'),(5,'任务分组','sys_job_group','0','admin','2021-10-20 10:28:42','',NULL,'任务分组列表'),(6,'系统是否','sys_yes_no','0','admin','2021-10-20 10:28:42','',NULL,'系统是否列表'),(7,'通知类型','sys_notice_type','0','admin','2021-10-20 10:28:42','',NULL,'通知类型列表'),(8,'通知状态','sys_notice_status','0','admin','2021-10-20 10:28:42','',NULL,'通知状态列表'),(9,'操作类型','sys_oper_type','0','admin','2021-10-20 10:28:42','',NULL,'操作类型列表'),(10,'系统状态','sys_common_status','0','admin','2021-10-20 10:28:42','',NULL,'登录状态列表');
  
  /*Table structure for table `sys_job` */
  
  DROP TABLE IF EXISTS `sys_job`;
  
  CREATE TABLE `sys_job` (
                             `job_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务ID',
                             `job_name` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '任务名称',
                             `job_group` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT 'DEFAULT' COMMENT '任务组名',
                             `invoke_target` varchar(500) COLLATE utf8mb4_bin NOT NULL COMMENT '调用目标字符串',
                             `cron_expression` varchar(255) COLLATE utf8mb4_bin DEFAULT '' COMMENT 'cron执行表达式',
                             `misfire_policy` varchar(20) COLLATE utf8mb4_bin DEFAULT '3' COMMENT '计划执行错误策略（1立即执行 2执行一次 3放弃执行）',
                             `concurrent` char(1) COLLATE utf8mb4_bin DEFAULT '1' COMMENT '是否并发执行（0允许 1禁止）',
                             `status` char(1) COLLATE utf8mb4_bin DEFAULT '0' COMMENT '状态（0正常 1暂停）',
                             `create_by` varchar(64) COLLATE utf8mb4_bin DEFAULT '' COMMENT '创建者',
                             `create_time` datetime DEFAULT NULL COMMENT '创建时间',
                             `update_by` varchar(64) COLLATE utf8mb4_bin DEFAULT '' COMMENT '更新者',
                             `update_time` datetime DEFAULT NULL COMMENT '更新时间',
                             `remark` varchar(500) COLLATE utf8mb4_bin DEFAULT '' COMMENT '备注信息',
                             PRIMARY KEY (`job_id`,`job_name`,`job_group`)
  ) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='定时任务调度表';
  
  /*Data for the table `sys_job` */
  
  insert  into `sys_job`(`job_id`,`job_name`,`job_group`,`invoke_target`,`cron_expression`,`misfire_policy`,`concurrent`,`status`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) values (1,'系统默认（无参）','DEFAULT','ryTask.ryNoParams','0/10 * * * * ?','3','1','1','admin','2021-10-20 10:28:49','',NULL,''),(2,'系统默认（有参）','DEFAULT','ryTask.ryParams(\'ry\')','0/15 * * * * ?','3','1','1','admin','2021-10-20 10:28:49','',NULL,''),(3,'系统默认（多参）','DEFAULT','ryTask.ryMultipleParams(\'ry\', true, 2000L, 316.50D, 100)','0/20 * * * * ?','3','1','1','admin','2021-10-20 10:28:49','',NULL,'');
  
  /*Table structure for table `sys_job_log` */
  
  DROP TABLE IF EXISTS `sys_job_log`;
  
  CREATE TABLE `sys_job_log` (
                                 `job_log_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务日志ID',
                                 `job_name` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT '任务名称',
                                 `job_group` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT '任务组名',
                                 `invoke_target` varchar(500) COLLATE utf8mb4_bin NOT NULL COMMENT '调用目标字符串',
                                 `job_message` varchar(500) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '日志信息',
                                 `status` char(1) COLLATE utf8mb4_bin DEFAULT '0' COMMENT '执行状态（0正常 1失败）',
                                 `exception_info` varchar(2000) COLLATE utf8mb4_bin DEFAULT '' COMMENT '异常信息',
                                 `create_time` datetime DEFAULT NULL COMMENT '创建时间',
                                 PRIMARY KEY (`job_log_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='定时任务调度日志表';
  
  /*Data for the table `sys_job_log` */
  
  /*Table structure for table `sys_logininfor` */
  
  DROP TABLE IF EXISTS `sys_logininfor`;
  
  CREATE TABLE `sys_logininfor` (
                                    `info_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '访问ID',
                                    `login_name` varchar(50) COLLATE utf8mb4_bin DEFAULT '' COMMENT '登录账号',
                                    `ipaddr` varchar(128) COLLATE utf8mb4_bin DEFAULT '' COMMENT '登录IP地址',
                                    `login_location` varchar(255) COLLATE utf8mb4_bin DEFAULT '' COMMENT '登录地点',
                                    `browser` varchar(50) COLLATE utf8mb4_bin DEFAULT '' COMMENT '浏览器类型',
                                    `os` varchar(50) COLLATE utf8mb4_bin DEFAULT '' COMMENT '操作系统',
                                    `status` char(1) COLLATE utf8mb4_bin DEFAULT '0' COMMENT '登录状态（0成功 1失败）',
                                    `msg` varchar(255) COLLATE utf8mb4_bin DEFAULT '' COMMENT '提示消息',
                                    `login_time` datetime DEFAULT NULL COMMENT '访问时间',
                                    PRIMARY KEY (`info_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=123 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='系统访问记录';
  
  /*Data for the table `sys_logininfor` */
  
  insert  into `sys_logininfor`(`info_id`,`login_name`,`ipaddr`,`login_location`,`browser`,`os`,`status`,`msg`,`login_time`) values (100,'admin','127.0.0.1','内网IP','Chrome 9','Windows 10','0','登录成功','2021-10-20 10:31:50'),(101,'admin','127.0.0.1','内网IP','Chrome 9','Windows 10','1','验证码错误','2021-10-20 10:35:34'),(102,'admin','127.0.0.1','内网IP','Chrome 9','Windows 10','0','登录成功','2021-10-20 10:35:37'),(103,'admin','127.0.0.1','内网IP','Chrome 9','Windows 10','0','登录成功','2021-10-20 11:03:14'),(104,'admin','127.0.0.1','内网IP','Chrome 9','Windows 10','0','登录成功','2021-10-20 11:08:14'),(105,'admin','127.0.0.1','内网IP','Chrome 9','Windows 10','0','登录成功','2021-10-20 11:25:30'),(106,'admin','127.0.0.1','内网IP','Chrome 9','Windows 10','0','登录成功','2021-10-20 11:30:06'),(107,'admin','127.0.0.1','内网IP','Chrome 9','Windows 10','0','登录成功','2021-10-20 13:23:33'),(108,'admin','127.0.0.1','内网IP','Chrome 9','Windows 10','0','登录成功','2021-10-20 13:27:16'),(109,'admin','127.0.0.1','内网IP','Chrome 9','Windows 10','0','登录成功','2021-10-20 13:32:27'),(110,'admin','127.0.0.1','内网IP','Chrome 9','Windows 10','0','登录成功','2021-10-20 13:49:46'),(111,'admin','127.0.0.1','内网IP','Chrome 9','Windows 10','0','登录成功','2021-10-20 14:02:56'),(112,'admin','127.0.0.1','内网IP','Chrome 9','Windows 10','0','登录成功','2021-10-20 14:11:00'),(113,'admin','127.0.0.1','内网IP','Chrome 9','Windows 10','0','登录成功','2021-10-20 14:12:19'),(114,'admin','127.0.0.1','内网IP','Chrome 9','Windows 10','1','验证码错误','2021-10-20 14:15:14'),(115,'admin','127.0.0.1','内网IP','Chrome 9','Windows 10','0','登录成功','2021-10-20 14:15:17'),(116,'admin','127.0.0.1','内网IP','Chrome 9','Windows 10','0','登录成功','2021-10-20 14:17:00'),(117,'admin','127.0.0.1','内网IP','Chrome 9','Windows 10','0','登录成功','2021-10-20 14:21:58'),(118,'admin','127.0.0.1','内网IP','Chrome 9','Windows 10','0','登录成功','2021-10-20 14:24:43'),(119,'admin','127.0.0.1','内网IP','Chrome 9','Windows 10','0','登录成功','2021-10-20 14:30:12'),(120,'admin','127.0.0.1','内网IP','Chrome 9','Windows 10','0','登录成功','2021-10-20 14:34:40'),(121,'admin','127.0.0.1','内网IP','Chrome 9','Windows 10','0','登录成功','2021-10-20 14:36:56'),(122,'admin','127.0.0.1','内网IP','Chrome 9','Windows 10','0','登录成功','2021-10-20 14:38:55');
  
  /*Table structure for table `sys_menu` */
  
  DROP TABLE IF EXISTS `sys_menu`;
  
  CREATE TABLE `sys_menu` (
                              `menu_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
                              `menu_name` varchar(50) COLLATE utf8mb4_bin NOT NULL COMMENT '菜单名称',
                              `parent_id` bigint(20) DEFAULT '0' COMMENT '父菜单ID',
                              `order_num` int(4) DEFAULT '0' COMMENT '显示顺序',
                              `url` varchar(200) COLLATE utf8mb4_bin DEFAULT '#' COMMENT '请求地址',
                              `target` varchar(20) COLLATE utf8mb4_bin DEFAULT '' COMMENT '打开方式（menuItem页签 menuBlank新窗口）',
                              `menu_type` char(1) COLLATE utf8mb4_bin DEFAULT '' COMMENT '菜单类型（M目录 C菜单 F按钮）',
                              `visible` char(1) COLLATE utf8mb4_bin DEFAULT '0' COMMENT '菜单状态（0显示 1隐藏）',
                              `is_refresh` char(1) COLLATE utf8mb4_bin DEFAULT '1' COMMENT '是否刷新（0刷新 1不刷新）',
                              `perms` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '权限标识',
                              `icon` varchar(100) COLLATE utf8mb4_bin DEFAULT '#' COMMENT '菜单图标',
                              `create_by` varchar(64) COLLATE utf8mb4_bin DEFAULT '' COMMENT '创建者',
                              `create_time` datetime DEFAULT NULL COMMENT '创建时间',
                              `update_by` varchar(64) COLLATE utf8mb4_bin DEFAULT '' COMMENT '更新者',
                              `update_time` datetime DEFAULT NULL COMMENT '更新时间',
                              `remark` varchar(500) COLLATE utf8mb4_bin DEFAULT '' COMMENT '备注',
                              PRIMARY KEY (`menu_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2008 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='菜单权限表';
  
  /*Data for the table `sys_menu` */
  
  insert  into `sys_menu`(`menu_id`,`menu_name`,`parent_id`,`order_num`,`url`,`target`,`menu_type`,`visible`,`is_refresh`,`perms`,`icon`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) values (1,'系统管理',0,1,'#','','M','0','1','','fa fa-gear','admin','2021-10-20 10:28:31','',NULL,'系统管理目录'),(2,'系统监控',0,2,'#','','M','0','1','','fa fa-video-camera','admin','2021-10-20 10:28:31','',NULL,'系统监控目录'),(3,'系统工具',0,3,'#','','M','0','1','','fa fa-bars','admin','2021-10-20 10:28:31','',NULL,'系统工具目录'),(100,'用户管理',1,1,'/system/user','','C','0','1','system:user:view','fa fa-user-o','admin','2021-10-20 10:28:31','',NULL,'用户管理菜单'),(101,'角色管理',1,2,'/system/role','','C','0','1','system:role:view','fa fa-user-secret','admin','2021-10-20 10:28:31','',NULL,'角色管理菜单'),(102,'菜单管理',1,3,'/system/menu','','C','0','1','system:menu:view','fa fa-th-list','admin','2021-10-20 10:28:31','',NULL,'菜单管理菜单'),(103,'部门管理',1,4,'/system/dept','','C','0','1','system:dept:view','fa fa-outdent','admin','2021-10-20 10:28:31','',NULL,'部门管理菜单'),(104,'岗位管理',1,5,'/system/post','','C','0','1','system:post:view','fa fa-address-card-o','admin','2021-10-20 10:28:31','',NULL,'岗位管理菜单'),(105,'字典管理',1,6,'/system/dict','','C','0','1','system:dict:view','fa fa-bookmark-o','admin','2021-10-20 10:28:31','',NULL,'字典管理菜单'),(106,'参数设置',1,7,'/system/config','','C','0','1','system:config:view','fa fa-sun-o','admin','2021-10-20 10:28:31','',NULL,'参数设置菜单'),(107,'通知公告',1,8,'/system/notice','','C','0','1','system:notice:view','fa fa-bullhorn','admin','2021-10-20 10:28:31','',NULL,'通知公告菜单'),(108,'日志管理',1,9,'#','','M','0','1','','fa fa-pencil-square-o','admin','2021-10-20 10:28:31','',NULL,'日志管理菜单'),(109,'在线用户',2,1,'/monitor/online','','C','0','1','monitor:online:view','fa fa-user-circle','admin','2021-10-20 10:28:31','',NULL,'在线用户菜单'),(110,'定时任务',2,2,'/monitor/job','','C','0','1','monitor:job:view','fa fa-tasks','admin','2021-10-20 10:28:31','',NULL,'定时任务菜单'),(111,'数据监控',2,3,'/monitor/data','','C','0','1','monitor:data:view','fa fa-bug','admin','2021-10-20 10:28:31','',NULL,'数据监控菜单'),(112,'服务监控',2,4,'/monitor/server','','C','0','1','monitor:server:view','fa fa-server','admin','2021-10-20 10:28:31','',NULL,'服务监控菜单'),(113,'缓存监控',2,5,'/monitor/cache','','C','0','1','monitor:cache:view','fa fa-cube','admin','2021-10-20 10:28:31','',NULL,'缓存监控菜单'),(114,'表单构建',3,1,'/tool/build','','C','0','1','tool:build:view','fa fa-wpforms','admin','2021-10-20 10:28:31','',NULL,'表单构建菜单'),(115,'代码生成',3,2,'/tool/gen','','C','0','1','tool:gen:view','fa fa-code','admin','2021-10-20 10:28:31','',NULL,'代码生成菜单'),(116,'系统接口',3,3,'/tool/swagger','','C','0','1','tool:swagger:view','fa fa-gg','admin','2021-10-20 10:28:31','',NULL,'系统接口菜单'),(500,'操作日志',108,1,'/monitor/operlog','','C','0','1','monitor:operlog:view','fa fa-address-book','admin','2021-10-20 10:28:31','',NULL,'操作日志菜单'),(501,'登录日志',108,2,'/monitor/logininfor','','C','0','1','monitor:logininfor:view','fa fa-file-image-o','admin','2021-10-20 10:28:31','',NULL,'登录日志菜单'),(1000,'用户查询',100,1,'#','','F','0','1','system:user:list','#','admin','2021-10-20 10:28:31','',NULL,''),(1001,'用户新增',100,2,'#','','F','0','1','system:user:add','#','admin','2021-10-20 10:28:32','',NULL,''),(1002,'用户修改',100,3,'#','','F','0','1','system:user:edit','#','admin','2021-10-20 10:28:32','',NULL,''),(1003,'用户删除',100,4,'#','','F','0','1','system:user:remove','#','admin','2021-10-20 10:28:32','',NULL,''),(1004,'用户导出',100,5,'#','','F','0','1','system:user:export','#','admin','2021-10-20 10:28:32','',NULL,''),(1005,'用户导入',100,6,'#','','F','0','1','system:user:import','#','admin','2021-10-20 10:28:32','',NULL,''),(1006,'重置密码',100,7,'#','','F','0','1','system:user:resetPwd','#','admin','2021-10-20 10:28:32','',NULL,''),(1007,'角色查询',101,1,'#','','F','0','1','system:role:list','#','admin','2021-10-20 10:28:32','',NULL,''),(1008,'角色新增',101,2,'#','','F','0','1','system:role:add','#','admin','2021-10-20 10:28:32','',NULL,''),(1009,'角色修改',101,3,'#','','F','0','1','system:role:edit','#','admin','2021-10-20 10:28:32','',NULL,''),(1010,'角色删除',101,4,'#','','F','0','1','system:role:remove','#','admin','2021-10-20 10:28:32','',NULL,''),(1011,'角色导出',101,5,'#','','F','0','1','system:role:export','#','admin','2021-10-20 10:28:32','',NULL,''),(1012,'菜单查询',102,1,'#','','F','0','1','system:menu:list','#','admin','2021-10-20 10:28:32','',NULL,''),(1013,'菜单新增',102,2,'#','','F','0','1','system:menu:add','#','admin','2021-10-20 10:28:32','',NULL,''),(1014,'菜单修改',102,3,'#','','F','0','1','system:menu:edit','#','admin','2021-10-20 10:28:32','',NULL,''),(1015,'菜单删除',102,4,'#','','F','0','1','system:menu:remove','#','admin','2021-10-20 10:28:32','',NULL,''),(1016,'部门查询',103,1,'#','','F','0','1','system:dept:list','#','admin','2021-10-20 10:28:32','',NULL,''),(1017,'部门新增',103,2,'#','','F','0','1','system:dept:add','#','admin','2021-10-20 10:28:32','',NULL,''),(1018,'部门修改',103,3,'#','','F','0','1','system:dept:edit','#','admin','2021-10-20 10:28:32','',NULL,''),(1019,'部门删除',103,4,'#','','F','0','1','system:dept:remove','#','admin','2021-10-20 10:28:32','',NULL,''),(1020,'岗位查询',104,1,'#','','F','0','1','system:post:list','#','admin','2021-10-20 10:28:32','',NULL,''),(1021,'岗位新增',104,2,'#','','F','0','1','system:post:add','#','admin','2021-10-20 10:28:32','',NULL,''),(1022,'岗位修改',104,3,'#','','F','0','1','system:post:edit','#','admin','2021-10-20 10:28:32','',NULL,''),(1023,'岗位删除',104,4,'#','','F','0','1','system:post:remove','#','admin','2021-10-20 10:28:32','',NULL,''),(1024,'岗位导出',104,5,'#','','F','0','1','system:post:export','#','admin','2021-10-20 10:28:32','',NULL,''),(1025,'字典查询',105,1,'#','','F','0','1','system:dict:list','#','admin','2021-10-20 10:28:32','',NULL,''),(1026,'字典新增',105,2,'#','','F','0','1','system:dict:add','#','admin','2021-10-20 10:28:32','',NULL,''),(1027,'字典修改',105,3,'#','','F','0','1','system:dict:edit','#','admin','2021-10-20 10:28:32','',NULL,''),(1028,'字典删除',105,4,'#','','F','0','1','system:dict:remove','#','admin','2021-10-20 10:28:32','',NULL,''),(1029,'字典导出',105,5,'#','','F','0','1','system:dict:export','#','admin','2021-10-20 10:28:32','',NULL,''),(1030,'参数查询',106,1,'#','','F','0','1','system:config:list','#','admin','2021-10-20 10:28:32','',NULL,''),(1031,'参数新增',106,2,'#','','F','0','1','system:config:add','#','admin','2021-10-20 10:28:32','',NULL,''),(1032,'参数修改',106,3,'#','','F','0','1','system:config:edit','#','admin','2021-10-20 10:28:32','',NULL,''),(1033,'参数删除',106,4,'#','','F','0','1','system:config:remove','#','admin','2021-10-20 10:28:32','',NULL,''),(1034,'参数导出',106,5,'#','','F','0','1','system:config:export','#','admin','2021-10-20 10:28:32','',NULL,''),(1035,'公告查询',107,1,'#','','F','0','1','system:notice:list','#','admin','2021-10-20 10:28:32','',NULL,''),(1036,'公告新增',107,2,'#','','F','0','1','system:notice:add','#','admin','2021-10-20 10:28:32','',NULL,''),(1037,'公告修改',107,3,'#','','F','0','1','system:notice:edit','#','admin','2021-10-20 10:28:32','',NULL,''),(1038,'公告删除',107,4,'#','','F','0','1','system:notice:remove','#','admin','2021-10-20 10:28:32','',NULL,''),(1039,'操作查询',500,1,'#','','F','0','1','monitor:operlog:list','#','admin','2021-10-20 10:28:32','',NULL,''),(1040,'操作删除',500,2,'#','','F','0','1','monitor:operlog:remove','#','admin','2021-10-20 10:28:32','',NULL,''),(1041,'详细信息',500,3,'#','','F','0','1','monitor:operlog:detail','#','admin','2021-10-20 10:28:32','',NULL,''),(1042,'日志导出',500,4,'#','','F','0','1','monitor:operlog:export','#','admin','2021-10-20 10:28:32','',NULL,''),(1043,'登录查询',501,1,'#','','F','0','1','monitor:logininfor:list','#','admin','2021-10-20 10:28:32','',NULL,''),(1044,'登录删除',501,2,'#','','F','0','1','monitor:logininfor:remove','#','admin','2021-10-20 10:28:32','',NULL,''),(1045,'日志导出',501,3,'#','','F','0','1','monitor:logininfor:export','#','admin','2021-10-20 10:28:32','',NULL,''),(1046,'账户解锁',501,4,'#','','F','0','1','monitor:logininfor:unlock','#','admin','2021-10-20 10:28:32','',NULL,''),(1047,'在线查询',109,1,'#','','F','0','1','monitor:online:list','#','admin','2021-10-20 10:28:32','',NULL,''),(1048,'批量强退',109,2,'#','','F','0','1','monitor:online:batchForceLogout','#','admin','2021-10-20 10:28:32','',NULL,''),(1049,'单条强退',109,3,'#','','F','0','1','monitor:online:forceLogout','#','admin','2021-10-20 10:28:32','',NULL,''),(1050,'任务查询',110,1,'#','','F','0','1','monitor:job:list','#','admin','2021-10-20 10:28:32','',NULL,''),(1051,'任务新增',110,2,'#','','F','0','1','monitor:job:add','#','admin','2021-10-20 10:28:32','',NULL,''),(1052,'任务修改',110,3,'#','','F','0','1','monitor:job:edit','#','admin','2021-10-20 10:28:32','',NULL,''),(1053,'任务删除',110,4,'#','','F','0','1','monitor:job:remove','#','admin','2021-10-20 10:28:32','',NULL,''),(1054,'状态修改',110,5,'#','','F','0','1','monitor:job:changeStatus','#','admin','2021-10-20 10:28:32','',NULL,''),(1055,'任务详细',110,6,'#','','F','0','1','monitor:job:detail','#','admin','2021-10-20 10:28:32','',NULL,''),(1056,'任务导出',110,7,'#','','F','0','1','monitor:job:export','#','admin','2021-10-20 10:28:32','',NULL,''),(1057,'生成查询',115,1,'#','','F','0','1','tool:gen:list','#','admin','2021-10-20 10:28:32','',NULL,''),(1058,'生成修改',115,2,'#','','F','0','1','tool:gen:edit','#','admin','2021-10-20 10:28:32','',NULL,''),(1059,'生成删除',115,3,'#','','F','0','1','tool:gen:remove','#','admin','2021-10-20 10:28:32','',NULL,''),(1060,'预览代码',115,4,'#','','F','0','1','tool:gen:preview','#','admin','2021-10-20 10:28:32','',NULL,''),(1061,'生成代码',115,5,'#','','F','0','1','tool:gen:code','#','admin','2021-10-20 10:28:32','',NULL,''),(2000,'sana',0,0,'#','menuItem','C','0','1','sana','fa fa-shopping-bag','admin','2021-10-20 10:55:05','admin','2021-10-20 10:55:17',''),(2001,'sana配置',2000,1,'/sana/nodes','','C','0','1','sana:nodes:view','#','admin','2021-10-20 10:56:15','',NULL,'sana配置菜单'),(2002,'sana配置查询',2001,1,'#','','F','0','1','sana:nodes:list','#','admin','2021-10-20 10:56:15','',NULL,''),(2003,'sana配置新增',2001,2,'#','','F','0','1','sana:nodes:add','#','admin','2021-10-20 10:56:15','',NULL,''),(2004,'sana配置修改',2001,3,'#','','F','0','1','sana:nodes:edit','#','admin','2021-10-20 10:56:15','',NULL,''),(2005,'sana配置删除',2001,4,'#','','F','0','1','sana:nodes:remove','#','admin','2021-10-20 10:56:15','',NULL,''),(2006,'sana配置导出',2001,5,'#','','F','0','1','sana:nodes:export','#','admin','2021-10-20 10:56:15','',NULL,''),(2007,'矿机监控',2000,2,'/sana/dashboard','menuItem','C','0','1','sana:dashboard:view','fa fa-space-shuttle','admin','2021-10-20 13:25:14','admin','2021-10-20 13:25:33','');
  
  /*Table structure for table `sys_notice` */
  
  DROP TABLE IF EXISTS `sys_notice`;
  
  CREATE TABLE `sys_notice` (
                                `notice_id` int(4) NOT NULL AUTO_INCREMENT COMMENT '公告ID',
                                `notice_title` varchar(50) COLLATE utf8mb4_bin NOT NULL COMMENT '公告标题',
                                `notice_type` char(1) COLLATE utf8mb4_bin NOT NULL COMMENT '公告类型（1通知 2公告）',
                                `notice_content` varchar(2000) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '公告内容',
                                `status` char(1) COLLATE utf8mb4_bin DEFAULT '0' COMMENT '公告状态（0正常 1关闭）',
                                `create_by` varchar(64) COLLATE utf8mb4_bin DEFAULT '' COMMENT '创建者',
                                `create_time` datetime DEFAULT NULL COMMENT '创建时间',
                                `update_by` varchar(64) COLLATE utf8mb4_bin DEFAULT '' COMMENT '更新者',
                                `update_time` datetime DEFAULT NULL COMMENT '更新时间',
                                `remark` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注',
                                PRIMARY KEY (`notice_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='通知公告表';
  
  /*Data for the table `sys_notice` */
  
  insert  into `sys_notice`(`notice_id`,`notice_title`,`notice_type`,`notice_content`,`status`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) values (1,'温馨提醒：2018-07-01 若依新版本发布啦','2','新版本内容','0','admin','2021-10-20 10:28:51','',NULL,'管理员'),(2,'维护通知：2018-07-01 若依系统凌晨维护','1','维护内容','0','admin','2021-10-20 10:28:51','',NULL,'管理员');
  
  /*Table structure for table `sys_oper_log` */
  
  DROP TABLE IF EXISTS `sys_oper_log`;
  
  CREATE TABLE `sys_oper_log` (
                                  `oper_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志主键',
                                  `title` varchar(50) COLLATE utf8mb4_bin DEFAULT '' COMMENT '模块标题',
                                  `business_type` int(2) DEFAULT '0' COMMENT '业务类型（0其它 1新增 2修改 3删除）',
                                  `method` varchar(100) COLLATE utf8mb4_bin DEFAULT '' COMMENT '方法名称',
                                  `request_method` varchar(10) COLLATE utf8mb4_bin DEFAULT '' COMMENT '请求方式',
                                  `operator_type` int(1) DEFAULT '0' COMMENT '操作类别（0其它 1后台用户 2手机端用户）',
                                  `oper_name` varchar(50) COLLATE utf8mb4_bin DEFAULT '' COMMENT '操作人员',
                                  `dept_name` varchar(50) COLLATE utf8mb4_bin DEFAULT '' COMMENT '部门名称',
                                  `oper_url` varchar(255) COLLATE utf8mb4_bin DEFAULT '' COMMENT '请求URL',
                                  `oper_ip` varchar(128) COLLATE utf8mb4_bin DEFAULT '' COMMENT '主机地址',
                                  `oper_location` varchar(255) COLLATE utf8mb4_bin DEFAULT '' COMMENT '操作地点',
                                  `oper_param` varchar(2000) COLLATE utf8mb4_bin DEFAULT '' COMMENT '请求参数',
                                  `json_result` varchar(2000) COLLATE utf8mb4_bin DEFAULT '' COMMENT '返回参数',
                                  `status` int(1) DEFAULT '0' COMMENT '操作状态（0正常 1异常）',
                                  `error_msg` varchar(2000) COLLATE utf8mb4_bin DEFAULT '' COMMENT '错误消息',
                                  `oper_time` datetime DEFAULT NULL COMMENT '操作时间',
                                  PRIMARY KEY (`oper_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=126 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='操作日志记录';
  
  /*Data for the table `sys_oper_log` */
  
  /*Table structure for table `sys_post` */
  
  DROP TABLE IF EXISTS `sys_post`;
  
  CREATE TABLE `sys_post` (
                              `post_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '岗位ID',
                              `post_code` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT '岗位编码',
                              `post_name` varchar(50) COLLATE utf8mb4_bin NOT NULL COMMENT '岗位名称',
                              `post_sort` int(4) NOT NULL COMMENT '显示顺序',
                              `status` char(1) COLLATE utf8mb4_bin NOT NULL COMMENT '状态（0正常 1停用）',
                              `create_by` varchar(64) COLLATE utf8mb4_bin DEFAULT '' COMMENT '创建者',
                              `create_time` datetime DEFAULT NULL COMMENT '创建时间',
                              `update_by` varchar(64) COLLATE utf8mb4_bin DEFAULT '' COMMENT '更新者',
                              `update_time` datetime DEFAULT NULL COMMENT '更新时间',
                              `remark` varchar(500) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注',
                              PRIMARY KEY (`post_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='岗位信息表';
  
  /*Data for the table `sys_post` */
  
  insert  into `sys_post`(`post_id`,`post_code`,`post_name`,`post_sort`,`status`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) values (1,'ceo','董事长',1,'0','admin','2021-10-20 10:28:29','',NULL,''),(2,'se','项目经理',2,'0','admin','2021-10-20 10:28:29','',NULL,''),(3,'hr','人力资源',3,'0','admin','2021-10-20 10:28:29','',NULL,''),(4,'user','普通员工',4,'0','admin','2021-10-20 10:28:29','',NULL,'');
  
  /*Table structure for table `sys_role` */
  
  DROP TABLE IF EXISTS `sys_role`;
  
  CREATE TABLE `sys_role` (
                              `role_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '角色ID',
                              `role_name` varchar(30) COLLATE utf8mb4_bin NOT NULL COMMENT '角色名称',
                              `role_key` varchar(100) COLLATE utf8mb4_bin NOT NULL COMMENT '角色权限字符串',
                              `role_sort` int(4) NOT NULL COMMENT '显示顺序',
                              `data_scope` char(1) COLLATE utf8mb4_bin DEFAULT '1' COMMENT '数据范围（1：全部数据权限 2：自定数据权限 3：本部门数据权限 4：本部门及以下数据权限）',
                              `status` char(1) COLLATE utf8mb4_bin NOT NULL COMMENT '角色状态（0正常 1停用）',
                              `del_flag` char(1) COLLATE utf8mb4_bin DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
                              `create_by` varchar(64) COLLATE utf8mb4_bin DEFAULT '' COMMENT '创建者',
                              `create_time` datetime DEFAULT NULL COMMENT '创建时间',
                              `update_by` varchar(64) COLLATE utf8mb4_bin DEFAULT '' COMMENT '更新者',
                              `update_time` datetime DEFAULT NULL COMMENT '更新时间',
                              `remark` varchar(500) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注',
                              PRIMARY KEY (`role_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='角色信息表';
  
  /*Data for the table `sys_role` */
  
  insert  into `sys_role`(`role_id`,`role_name`,`role_key`,`role_sort`,`data_scope`,`status`,`del_flag`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) values (1,'超级管理员','admin',1,'1','0','0','admin','2021-10-20 10:28:30','',NULL,'超级管理员'),(2,'普通角色','common',2,'2','0','0','admin','2021-10-20 10:28:30','admin','2021-10-20 10:54:20','普通角色');
  
  /*Table structure for table `sys_role_dept` */
  
  DROP TABLE IF EXISTS `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 COLLATE=utf8mb4_bin COMMENT='角色和部门关联表';
  
  /*Data for the table `sys_role_dept` */
  
  insert  into `sys_role_dept`(`role_id`,`dept_id`) values (2,100),(2,101),(2,105);
  
  /*Table structure for table `sys_role_menu` */
  
  DROP TABLE IF EXISTS `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 COLLATE=utf8mb4_bin COMMENT='角色和菜单关联表';
  
  /*Data for the table `sys_role_menu` */
  
  insert  into `sys_role_menu`(`role_id`,`menu_id`) values (2,1),(2,2),(2,3),(2,100),(2,101),(2,102),(2,103),(2,104),(2,105),(2,106),(2,107),(2,108),(2,109),(2,110),(2,111),(2,112),(2,113),(2,114),(2,115),(2,116),(2,500),(2,501),(2,1000),(2,1001),(2,1002),(2,1003),(2,1004),(2,1005),(2,1006),(2,1007),(2,1008),(2,1009),(2,1010),(2,1011),(2,1012),(2,1013),(2,1014),(2,1015),(2,1016),(2,1017),(2,1018),(2,1019),(2,1020),(2,1021),(2,1022),(2,1023),(2,1024),(2,1025),(2,1026),(2,1027),(2,1028),(2,1029),(2,1030),(2,1031),(2,1032),(2,1033),(2,1034),(2,1035),(2,1036),(2,1037),(2,1038),(2,1039),(2,1040),(2,1041),(2,1042),(2,1043),(2,1044),(2,1045),(2,1046),(2,1047),(2,1048),(2,1049),(2,1050),(2,1051),(2,1052),(2,1053),(2,1054),(2,1055),(2,1056),(2,1057),(2,1058),(2,1059),(2,1060),(2,1061);
  
  /*Table structure for table `sys_user` */
  
  DROP TABLE IF EXISTS `sys_user`;
  
  CREATE TABLE `sys_user` (
                              `user_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
                              `dept_id` bigint(20) DEFAULT NULL COMMENT '部门ID',
                              `login_name` varchar(30) COLLATE utf8mb4_bin NOT NULL COMMENT '登录账号',
                              `user_name` varchar(30) COLLATE utf8mb4_bin DEFAULT '' COMMENT '用户昵称',
                              `user_type` varchar(2) COLLATE utf8mb4_bin DEFAULT '00' COMMENT '用户类型（00系统用户 01注册用户）',
                              `email` varchar(50) COLLATE utf8mb4_bin DEFAULT '' COMMENT '用户邮箱',
                              `phonenumber` varchar(11) COLLATE utf8mb4_bin DEFAULT '' COMMENT '手机号码',
                              `sex` char(1) COLLATE utf8mb4_bin DEFAULT '0' COMMENT '用户性别（0男 1女 2未知）',
                              `avatar` varchar(100) COLLATE utf8mb4_bin DEFAULT '' COMMENT '头像路径',
                              `password` varchar(50) COLLATE utf8mb4_bin DEFAULT '' COMMENT '密码',
                              `salt` varchar(20) COLLATE utf8mb4_bin DEFAULT '' COMMENT '盐加密',
                              `status` char(1) COLLATE utf8mb4_bin DEFAULT '0' COMMENT '帐号状态（0正常 1停用）',
                              `del_flag` char(1) COLLATE utf8mb4_bin DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
                              `login_ip` varchar(128) COLLATE utf8mb4_bin DEFAULT '' COMMENT '最后登录IP',
                              `login_date` datetime DEFAULT NULL COMMENT '最后登录时间',
                              `pwd_update_date` datetime DEFAULT NULL COMMENT '密码最后更新时间',
                              `create_by` varchar(64) COLLATE utf8mb4_bin DEFAULT '' COMMENT '创建者',
                              `create_time` datetime DEFAULT NULL COMMENT '创建时间',
                              `update_by` varchar(64) COLLATE utf8mb4_bin DEFAULT '' COMMENT '更新者',
                              `update_time` datetime DEFAULT NULL COMMENT '更新时间',
                              `remark` varchar(500) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注',
                              PRIMARY KEY (`user_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='用户信息表';
  
  /*Data for the table `sys_user` */
  
  insert  into `sys_user`(`user_id`,`dept_id`,`login_name`,`user_name`,`user_type`,`email`,`phonenumber`,`sex`,`avatar`,`password`,`salt`,`status`,`del_flag`,`login_ip`,`login_date`,`pwd_update_date`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) values (1,103,'admin','若依','00','ry@163.com','15888888888','1','','29c67a30398638269fe600f73a054934','111111','0','0','127.0.0.1','2021-10-20 14:38:55','2021-10-20 10:28:27','admin','2021-10-20 10:28:27','','2021-10-20 14:38:55','管理员'),(2,105,'ry','若依','00','ry@qq.com','15666666666','1','','8e6d98b90472783cc73c17047ddccf36','222222','0','0','127.0.0.1','2021-10-20 10:28:27','2021-10-20 10:28:27','admin','2021-10-20 10:28:27','',NULL,'测试员');
  
  /*Table structure for table `sys_user_online` */
  
  DROP TABLE IF EXISTS `sys_user_online`;
  
  CREATE TABLE `sys_user_online` (
                                     `sessionId` varchar(50) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '用户会话id',
                                     `login_name` varchar(50) COLLATE utf8mb4_bin DEFAULT '' COMMENT '登录账号',
                                     `dept_name` varchar(50) COLLATE utf8mb4_bin DEFAULT '' COMMENT '部门名称',
                                     `ipaddr` varchar(128) COLLATE utf8mb4_bin DEFAULT '' COMMENT '登录IP地址',
                                     `login_location` varchar(255) COLLATE utf8mb4_bin DEFAULT '' COMMENT '登录地点',
                                     `browser` varchar(50) COLLATE utf8mb4_bin DEFAULT '' COMMENT '浏览器类型',
                                     `os` varchar(50) COLLATE utf8mb4_bin DEFAULT '' COMMENT '操作系统',
                                     `status` varchar(10) COLLATE utf8mb4_bin DEFAULT '' COMMENT '在线状态on_line在线off_line离线',
                                     `start_timestamp` datetime DEFAULT NULL COMMENT 'session创建时间',
                                     `last_access_time` datetime DEFAULT NULL COMMENT 'session最后访问时间',
                                     `expire_time` int(5) DEFAULT '0' COMMENT '超时时间，单位为分钟',
                                     PRIMARY KEY (`sessionId`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='在线用户记录';
  
  /*Data for the table `sys_user_online` */
  /*Table structure for table `sys_user_post` */
  
  DROP TABLE IF EXISTS `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 COLLATE=utf8mb4_bin COMMENT='用户与岗位关联表';
  
  /*Data for the table `sys_user_post` */
  
  insert  into `sys_user_post`(`user_id`,`post_id`) values (1,1),(2,2);
  
  /*Table structure for table `sys_user_role` */
  
  DROP TABLE IF EXISTS `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 COLLATE=utf8mb4_bin COMMENT='用户和角色关联表';
  
  /*Data for the table `sys_user_role` */
  
  insert  into `sys_user_role`(`user_id`,`role_id`) values (1,1),(2,2);
  