/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 50727 Source Host : localhost:3306 Source Database : nerp-db Target Server Type : MYSQL Target Server Version : 50727 File Encoding : 65001 Date: 2022-05-11 13:42:54 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for gen_table -- ---------------------------- DROP TABLE IF EXISTS `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='代码生成业务表'; -- ---------------------------- -- Records of gen_table -- ---------------------------- -- ---------------------------- -- Table structure for 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) 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='代码生成业务表字段'; -- ---------------------------- -- Records of gen_table_column -- ---------------------------- -- ---------------------------- -- Table structure for qrtz_blob_triggers -- ---------------------------- DROP TABLE IF EXISTS `qrtz_blob_triggers`; CREATE TABLE `qrtz_blob_triggers` ( `sched_name` varchar(120) NOT NULL, `trigger_name` varchar(200) NOT NULL, `trigger_group` varchar(200) NOT NULL, `blob_data` blob, PRIMARY KEY (`sched_name`,`trigger_name`,`trigger_group`), CONSTRAINT `qrtz_blob_triggers_ibfk_1` FOREIGN KEY (`sched_name`, `trigger_name`, `trigger_group`) REFERENCES `qrtz_triggers` (`sched_name`, `trigger_name`, `trigger_group`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- ---------------------------- -- Records of qrtz_blob_triggers -- ---------------------------- -- ---------------------------- -- Table structure for qrtz_calendars -- ---------------------------- DROP TABLE IF EXISTS `qrtz_calendars`; CREATE TABLE `qrtz_calendars` ( `sched_name` varchar(120) NOT NULL, `calendar_name` varchar(200) NOT NULL, `calendar` blob NOT NULL, PRIMARY KEY (`sched_name`,`calendar_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- ---------------------------- -- Records of qrtz_calendars -- ---------------------------- -- ---------------------------- -- Table structure for qrtz_cron_triggers -- ---------------------------- DROP TABLE IF EXISTS `qrtz_cron_triggers`; CREATE TABLE `qrtz_cron_triggers` ( `sched_name` varchar(120) NOT NULL, `trigger_name` varchar(200) NOT NULL, `trigger_group` varchar(200) NOT NULL, `cron_expression` varchar(200) NOT NULL, `time_zone_id` varchar(80) DEFAULT NULL, PRIMARY KEY (`sched_name`,`trigger_name`,`trigger_group`), CONSTRAINT `qrtz_cron_triggers_ibfk_1` FOREIGN KEY (`sched_name`, `trigger_name`, `trigger_group`) REFERENCES `qrtz_triggers` (`sched_name`, `trigger_name`, `trigger_group`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- ---------------------------- -- Records of qrtz_cron_triggers -- ---------------------------- INSERT INTO `qrtz_cron_triggers` VALUES ('ElfScheduler', 'TASK_CLASS_NAME1', 'DEFAULT', '0/10 * * * * ?', 'Asia/Shanghai'); INSERT INTO `qrtz_cron_triggers` VALUES ('ElfScheduler', 'TASK_CLASS_NAME2', 'DEFAULT', '0/15 * * * * ?', 'Asia/Shanghai'); INSERT INTO `qrtz_cron_triggers` VALUES ('ElfScheduler', 'TASK_CLASS_NAME3', 'DEFAULT', '0/20 * * * * ?', 'Asia/Shanghai'); INSERT INTO `qrtz_cron_triggers` VALUES ('ElfScheduler', 'TASK_CLASS_NAME4', 'SYSTEM', '0 0 12 * * ?', 'Asia/Shanghai'); INSERT INTO `qrtz_cron_triggers` VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME1', 'DEFAULT', '0/10 * * * * ?', 'Asia/Shanghai'); INSERT INTO `qrtz_cron_triggers` VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME2', 'DEFAULT', '0/15 * * * * ?', 'Asia/Shanghai'); INSERT INTO `qrtz_cron_triggers` VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME3', 'DEFAULT', '0/20 * * * * ?', 'Asia/Shanghai'); -- ---------------------------- -- Table structure for qrtz_fired_triggers -- ---------------------------- DROP TABLE IF EXISTS `qrtz_fired_triggers`; CREATE TABLE `qrtz_fired_triggers` ( `sched_name` varchar(120) NOT NULL, `entry_id` varchar(95) NOT NULL, `trigger_name` varchar(200) NOT NULL, `trigger_group` varchar(200) NOT NULL, `instance_name` varchar(200) NOT NULL, `fired_time` bigint(13) NOT NULL, `sched_time` bigint(13) NOT NULL, `priority` int(11) NOT NULL, `state` varchar(16) NOT NULL, `job_name` varchar(200) DEFAULT NULL, `job_group` varchar(200) DEFAULT NULL, `is_nonconcurrent` varchar(1) DEFAULT NULL, `requests_recovery` varchar(1) DEFAULT NULL, PRIMARY KEY (`sched_name`,`entry_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- ---------------------------- -- Records of qrtz_fired_triggers -- ---------------------------- -- ---------------------------- -- Table structure for qrtz_job_details -- ---------------------------- DROP TABLE IF EXISTS `qrtz_job_details`; CREATE TABLE `qrtz_job_details` ( `sched_name` varchar(120) NOT NULL, `job_name` varchar(200) NOT NULL, `job_group` varchar(200) NOT NULL, `description` varchar(250) DEFAULT NULL, `job_class_name` varchar(250) NOT NULL, `is_durable` varchar(1) NOT NULL, `is_nonconcurrent` varchar(1) NOT NULL, `is_update_data` varchar(1) NOT NULL, `requests_recovery` varchar(1) NOT NULL, `job_data` blob, PRIMARY KEY (`sched_name`,`job_name`,`job_group`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- ---------------------------- -- Records of qrtz_job_details -- ---------------------------- INSERT INTO `qrtz_job_details` VALUES ('ElfScheduler', 'TASK_CLASS_NAME1', 'DEFAULT', null, 'com.jiayue.quartz.util.QuartzDisallowConcurrentExecution', '0', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000F5441534B5F50524F504552544945537372001F636F6D2E6A69617975652E71756172747A2E646F6D61696E2E5379734A6F6200000000000000010200084C000A636F6E63757272656E747400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C000C696E766F6B6554617267657471007E00094C00086A6F6247726F757071007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C00076A6F624E616D6571007E00094C000D6D697366697265506F6C69637971007E00094C000673746174757371007E000978720029636F6D2E6A69617975652E636F6D6D6F6E2E636F72652E646F6D61696E2E4175646974456E7469747900000000000000010200054C0008637265617465427971007E00094C000A63726561746554696D657400194C6A6176612F74696D652F4C6F63616C4461746554696D653B4C000672656D61726B71007E00094C0008757064617465427971007E00094C000A75706461746554696D6571007E000C78720028636F6D2E6A69617975652E636F6D6D6F6E2E636F72652E646F6D61696E2E42617365456E7469747900000000000000010200024C0006706172616D7371007E00034C000B73656172636856616C756571007E00097870707074000561646D696E7372000D6A6176612E74696D652E536572955D84BA1B2248B20C00007870770A05000007E40C071006E37874000070707400013174000E302F3130202A202A202A202A203F74001172795461736B2E72794E6F506172616D7374000744454641554C547372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000000000001740018E7B3BBE7BB9FE9BB98E8AEA4EFBC88E697A0E58F82EFBC8974000133740001317800); INSERT INTO `qrtz_job_details` VALUES ('ElfScheduler', 'TASK_CLASS_NAME2', 'DEFAULT', null, 'com.jiayue.quartz.util.QuartzDisallowConcurrentExecution', '0', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000F5441534B5F50524F504552544945537372001F636F6D2E6A69617975652E71756172747A2E646F6D61696E2E5379734A6F6200000000000000010200084C000A636F6E63757272656E747400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C000C696E766F6B6554617267657471007E00094C00086A6F6247726F757071007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C00076A6F624E616D6571007E00094C000D6D697366697265506F6C69637971007E00094C000673746174757371007E000978720029636F6D2E6A69617975652E636F6D6D6F6E2E636F72652E646F6D61696E2E4175646974456E7469747900000000000000010200054C0008637265617465427971007E00094C000A63726561746554696D657400194C6A6176612F74696D652F4C6F63616C4461746554696D653B4C000672656D61726B71007E00094C0008757064617465427971007E00094C000A75706461746554696D6571007E000C78720028636F6D2E6A69617975652E636F6D6D6F6E2E636F72652E646F6D61696E2E42617365456E7469747900000000000000010200024C0006706172616D7371007E00034C000B73656172636856616C756571007E00097870707074000561646D696E7372000D6A6176612E74696D652E536572955D84BA1B2248B20C00007870770A05000007E40C071006E37874000070707400013174000E302F3135202A202A202A202A203F74001572795461736B2E7279506172616D7328277279272974000744454641554C547372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000000000002740018E7B3BBE7BB9FE9BB98E8AEA4EFBC88E69C89E58F82EFBC8974000133740001317800); INSERT INTO `qrtz_job_details` VALUES ('ElfScheduler', 'TASK_CLASS_NAME3', 'DEFAULT', null, 'com.jiayue.quartz.util.QuartzDisallowConcurrentExecution', '0', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000F5441534B5F50524F504552544945537372001F636F6D2E6A69617975652E71756172747A2E646F6D61696E2E5379734A6F6200000000000000010200084C000A636F6E63757272656E747400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C000C696E766F6B6554617267657471007E00094C00086A6F6247726F757071007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C00076A6F624E616D6571007E00094C000D6D697366697265506F6C69637971007E00094C000673746174757371007E000978720029636F6D2E6A69617975652E636F6D6D6F6E2E636F72652E646F6D61696E2E4175646974456E7469747900000000000000010200054C0008637265617465427971007E00094C000A63726561746554696D657400194C6A6176612F74696D652F4C6F63616C4461746554696D653B4C000672656D61726B71007E00094C0008757064617465427971007E00094C000A75706461746554696D6571007E000C78720028636F6D2E6A69617975652E636F6D6D6F6E2E636F72652E646F6D61696E2E42617365456E7469747900000000000000010200024C0006706172616D7371007E00034C000B73656172636856616C756571007E00097870707074000561646D696E7372000D6A6176612E74696D652E536572955D84BA1B2248B20C00007870770A05000007E40C071006E37874000070707400013174000E302F3230202A202A202A202A203F74003872795461736B2E72794D756C7469706C65506172616D7328277279272C20747275652C20323030304C2C203331362E3530442C203130302974000744454641554C547372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000000000003740018E7B3BBE7BB9FE9BB98E8AEA4EFBC88E5A49AE58F82EFBC8974000133740001317800); INSERT INTO `qrtz_job_details` VALUES ('ElfScheduler', 'TASK_CLASS_NAME4', 'SYSTEM', null, 'com.jiayue.quartz.util.QuartzDisallowConcurrentExecution', '0', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000F5441534B5F50524F504552544945537372001F636F6D2E6A69617975652E71756172747A2E646F6D61696E2E5379734A6F6200000000000000010200084C000A636F6E63757272656E747400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C000C696E766F6B6554617267657471007E00094C00086A6F6247726F757071007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C00076A6F624E616D6571007E00094C000D6D697366697265506F6C69637971007E00094C000673746174757371007E000978720029636F6D2E6A69617975652E636F6D6D6F6E2E636F72652E646F6D61696E2E4175646974456E7469747900000000000000010200054C0008637265617465427971007E00094C000A63726561746554696D657400194C6A6176612F74696D652F4C6F63616C4461746554696D653B4C000672656D61726B71007E00094C0008757064617465427971007E00094C000A75706461746554696D6571007E000C78720028636F6D2E6A69617975652E636F6D6D6F6E2E636F72652E646F6D61696E2E42617365456E7469747900000000000000010200024C0006706172616D7371007E00034C000B73656172636856616C756571007E00097870707074000561646D696E7372000D6A6176612E74696D652E536572955D84BA1B2248B20C00007870770A05000007E40C160D02C77874000070707400013174000C302030203132202A202A203F74001D706F77657253746174696F6E53796E635461736B2E73796E634461746174000653595354454D7372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000000000004740027E5908CE6ADA5E59CBAE7AB99E4B8BBE695B0E68DAEE4B88EE69E84E5BBBAE7BB84E7BB87E6A09174000132740001317800); INSERT INTO `qrtz_job_details` VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME1', 'DEFAULT', null, 'com.ruoyi.quartz.util.QuartzDisallowConcurrentExecution', '0', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000F5441534B5F50524F504552544945537372001E636F6D2E72756F79692E71756172747A2E646F6D61696E2E5379734A6F6200000000000000010200084C000A636F6E63757272656E747400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C000C696E766F6B6554617267657471007E00094C00086A6F6247726F757071007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C00076A6F624E616D6571007E00094C000D6D697366697265506F6C69637971007E00094C000673746174757371007E000978720027636F6D2E72756F79692E636F6D6D6F6E2E636F72652E646F6D61696E2E42617365456E7469747900000000000000010200074C0008637265617465427971007E00094C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C0006706172616D7371007E00034C000672656D61726B71007E00094C000B73656172636856616C756571007E00094C0008757064617465427971007E00094C000A75706461746554696D6571007E000C787074000561646D696E7372000E6A6176612E7574696C2E44617465686A81014B59741903000078707708000001763C3CD3A078707400007070707400013174000E302F3130202A202A202A202A203F74001172795461736B2E72794E6F506172616D7374000744454641554C547372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000000000001740018E7B3BBE7BB9FE9BB98E8AEA4EFBC88E697A0E58F82EFBC8974000133740001317800); INSERT INTO `qrtz_job_details` VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME2', 'DEFAULT', null, 'com.ruoyi.quartz.util.QuartzDisallowConcurrentExecution', '0', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000F5441534B5F50524F504552544945537372001E636F6D2E72756F79692E71756172747A2E646F6D61696E2E5379734A6F6200000000000000010200084C000A636F6E63757272656E747400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C000C696E766F6B6554617267657471007E00094C00086A6F6247726F757071007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C00076A6F624E616D6571007E00094C000D6D697366697265506F6C69637971007E00094C000673746174757371007E000978720027636F6D2E72756F79692E636F6D6D6F6E2E636F72652E646F6D61696E2E42617365456E7469747900000000000000010200074C0008637265617465427971007E00094C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C0006706172616D7371007E00034C000672656D61726B71007E00094C000B73656172636856616C756571007E00094C0008757064617465427971007E00094C000A75706461746554696D6571007E000C787074000561646D696E7372000E6A6176612E7574696C2E44617465686A81014B59741903000078707708000001763C3CD3A078707400007070707400013174000E302F3135202A202A202A202A203F74001572795461736B2E7279506172616D7328277279272974000744454641554C547372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000000000002740018E7B3BBE7BB9FE9BB98E8AEA4EFBC88E69C89E58F82EFBC8974000133740001317800); INSERT INTO `qrtz_job_details` VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME3', 'DEFAULT', null, 'com.ruoyi.quartz.util.QuartzDisallowConcurrentExecution', '0', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000F5441534B5F50524F504552544945537372001E636F6D2E72756F79692E71756172747A2E646F6D61696E2E5379734A6F6200000000000000010200084C000A636F6E63757272656E747400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C000C696E766F6B6554617267657471007E00094C00086A6F6247726F757071007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C00076A6F624E616D6571007E00094C000D6D697366697265506F6C69637971007E00094C000673746174757371007E000978720027636F6D2E72756F79692E636F6D6D6F6E2E636F72652E646F6D61696E2E42617365456E7469747900000000000000010200074C0008637265617465427971007E00094C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C0006706172616D7371007E00034C000672656D61726B71007E00094C000B73656172636856616C756571007E00094C0008757064617465427971007E00094C000A75706461746554696D6571007E000C787074000561646D696E7372000E6A6176612E7574696C2E44617465686A81014B59741903000078707708000001763C3CD3A078707400007070707400013174000E302F3230202A202A202A202A203F74003872795461736B2E72794D756C7469706C65506172616D7328277279272C20747275652C20323030304C2C203331362E3530442C203130302974000744454641554C547372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000000000003740018E7B3BBE7BB9FE9BB98E8AEA4EFBC88E5A49AE58F82EFBC8974000133740001317800); -- ---------------------------- -- Table structure for qrtz_locks -- ---------------------------- DROP TABLE IF EXISTS `qrtz_locks`; CREATE TABLE `qrtz_locks` ( `sched_name` varchar(120) NOT NULL, `lock_name` varchar(40) NOT NULL, PRIMARY KEY (`sched_name`,`lock_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- ---------------------------- -- Records of qrtz_locks -- ---------------------------- INSERT INTO `qrtz_locks` VALUES ('ElfScheduler', 'STATE_ACCESS'); INSERT INTO `qrtz_locks` VALUES ('ElfScheduler', 'TRIGGER_ACCESS'); INSERT INTO `qrtz_locks` VALUES ('RuoyiScheduler', 'STATE_ACCESS'); INSERT INTO `qrtz_locks` VALUES ('RuoyiScheduler', 'TRIGGER_ACCESS'); -- ---------------------------- -- Table structure for qrtz_paused_trigger_grps -- ---------------------------- DROP TABLE IF EXISTS `qrtz_paused_trigger_grps`; CREATE TABLE `qrtz_paused_trigger_grps` ( `sched_name` varchar(120) NOT NULL, `trigger_group` varchar(200) NOT NULL, PRIMARY KEY (`sched_name`,`trigger_group`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- ---------------------------- -- Records of qrtz_paused_trigger_grps -- ---------------------------- -- ---------------------------- -- Table structure for qrtz_scheduler_state -- ---------------------------- DROP TABLE IF EXISTS `qrtz_scheduler_state`; CREATE TABLE `qrtz_scheduler_state` ( `sched_name` varchar(120) NOT NULL, `instance_name` varchar(200) NOT NULL, `last_checkin_time` bigint(13) NOT NULL, `checkin_interval` bigint(13) NOT NULL, PRIMARY KEY (`sched_name`,`instance_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- ---------------------------- -- Records of qrtz_scheduler_state -- ---------------------------- INSERT INTO `qrtz_scheduler_state` VALUES ('ElfScheduler', 'icelake1652182795490', '1652183970325', '15000'); INSERT INTO `qrtz_scheduler_state` VALUES ('RuoyiScheduler', 'anxl1607477196845', '1607477260959', '15000'); -- ---------------------------- -- Table structure for qrtz_simple_triggers -- ---------------------------- DROP TABLE IF EXISTS `qrtz_simple_triggers`; CREATE TABLE `qrtz_simple_triggers` ( `sched_name` varchar(120) NOT NULL, `trigger_name` varchar(200) NOT NULL, `trigger_group` varchar(200) NOT NULL, `repeat_count` bigint(7) NOT NULL, `repeat_interval` bigint(12) NOT NULL, `times_triggered` bigint(10) NOT NULL, PRIMARY KEY (`sched_name`,`trigger_name`,`trigger_group`), CONSTRAINT `qrtz_simple_triggers_ibfk_1` FOREIGN KEY (`sched_name`, `trigger_name`, `trigger_group`) REFERENCES `qrtz_triggers` (`sched_name`, `trigger_name`, `trigger_group`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- ---------------------------- -- Records of qrtz_simple_triggers -- ---------------------------- -- ---------------------------- -- Table structure for qrtz_simprop_triggers -- ---------------------------- DROP TABLE IF EXISTS `qrtz_simprop_triggers`; CREATE TABLE `qrtz_simprop_triggers` ( `sched_name` varchar(120) NOT NULL, `trigger_name` varchar(200) NOT NULL, `trigger_group` varchar(200) NOT NULL, `str_prop_1` varchar(512) DEFAULT NULL, `str_prop_2` varchar(512) DEFAULT NULL, `str_prop_3` varchar(512) DEFAULT NULL, `int_prop_1` int(11) DEFAULT NULL, `int_prop_2` int(11) DEFAULT NULL, `long_prop_1` bigint(20) DEFAULT NULL, `long_prop_2` bigint(20) DEFAULT NULL, `dec_prop_1` decimal(13,4) DEFAULT NULL, `dec_prop_2` decimal(13,4) DEFAULT NULL, `bool_prop_1` varchar(1) DEFAULT NULL, `bool_prop_2` varchar(1) DEFAULT NULL, PRIMARY KEY (`sched_name`,`trigger_name`,`trigger_group`), CONSTRAINT `qrtz_simprop_triggers_ibfk_1` FOREIGN KEY (`sched_name`, `trigger_name`, `trigger_group`) REFERENCES `qrtz_triggers` (`sched_name`, `trigger_name`, `trigger_group`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- ---------------------------- -- Records of qrtz_simprop_triggers -- ---------------------------- -- ---------------------------- -- Table structure for qrtz_triggers -- ---------------------------- DROP TABLE IF EXISTS `qrtz_triggers`; CREATE TABLE `qrtz_triggers` ( `sched_name` varchar(120) NOT NULL, `trigger_name` varchar(200) NOT NULL, `trigger_group` varchar(200) NOT NULL, `job_name` varchar(200) NOT NULL, `job_group` varchar(200) NOT NULL, `description` varchar(250) DEFAULT NULL, `next_fire_time` bigint(13) DEFAULT NULL, `prev_fire_time` bigint(13) DEFAULT NULL, `priority` int(11) DEFAULT NULL, `trigger_state` varchar(16) NOT NULL, `trigger_type` varchar(8) NOT NULL, `start_time` bigint(13) NOT NULL, `end_time` bigint(13) DEFAULT NULL, `calendar_name` varchar(200) DEFAULT NULL, `misfire_instr` smallint(2) DEFAULT NULL, `job_data` blob, PRIMARY KEY (`sched_name`,`trigger_name`,`trigger_group`), KEY `sched_name` (`sched_name`,`job_name`,`job_group`), CONSTRAINT `qrtz_triggers_ibfk_1` FOREIGN KEY (`sched_name`, `job_name`, `job_group`) REFERENCES `qrtz_job_details` (`sched_name`, `job_name`, `job_group`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- ---------------------------- -- Records of qrtz_triggers -- ---------------------------- INSERT INTO `qrtz_triggers` VALUES ('ElfScheduler', 'TASK_CLASS_NAME1', 'DEFAULT', 'TASK_CLASS_NAME1', 'DEFAULT', null, '1652182800000', '-1', '5', 'PAUSED', 'CRON', '1652182795000', '0', null, '2', ''); INSERT INTO `qrtz_triggers` VALUES ('ElfScheduler', 'TASK_CLASS_NAME2', 'DEFAULT', 'TASK_CLASS_NAME2', 'DEFAULT', null, '1652182800000', '-1', '5', 'PAUSED', 'CRON', '1652182795000', '0', null, '2', ''); INSERT INTO `qrtz_triggers` VALUES ('ElfScheduler', 'TASK_CLASS_NAME3', 'DEFAULT', 'TASK_CLASS_NAME3', 'DEFAULT', null, '1652182800000', '-1', '5', 'PAUSED', 'CRON', '1652182795000', '0', null, '2', ''); INSERT INTO `qrtz_triggers` VALUES ('ElfScheduler', 'TASK_CLASS_NAME4', 'SYSTEM', 'TASK_CLASS_NAME4', 'SYSTEM', null, '1652241600000', '-1', '5', 'PAUSED', 'CRON', '1652182795000', '0', null, '1', ''); INSERT INTO `qrtz_triggers` VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME1', 'DEFAULT', 'TASK_CLASS_NAME1', 'DEFAULT', null, '1607477200000', '-1', '5', 'PAUSED', 'CRON', '1607477197000', '0', null, '2', ''); INSERT INTO `qrtz_triggers` VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME2', 'DEFAULT', 'TASK_CLASS_NAME2', 'DEFAULT', null, '1607477205000', '-1', '5', 'PAUSED', 'CRON', '1607477197000', '0', null, '2', ''); INSERT INTO `qrtz_triggers` VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME3', 'DEFAULT', 'TASK_CLASS_NAME3', 'DEFAULT', null, '1607477200000', '-1', '5', 'PAUSED', 'CRON', '1607477197000', '0', null, '2', ''); -- ---------------------------- -- Table structure for 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) 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=6 DEFAULT CHARSET=utf8mb4 COMMENT='参数配置表'; -- ---------------------------- -- Records of sys_config -- ---------------------------- INSERT INTO `sys_config` VALUES ('1', '主框架页-默认皮肤样式名称', 'sys.index.skinName', 'skin-blue', 'Y', 'admin', '2020-12-07 16:06:28', '', null, '蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow'); INSERT INTO `sys_config` VALUES ('2', '用户管理-账号初始密码', 'sys.user.initPassword', '123456', 'Y', 'admin', '2020-12-07 16:06:28', '', null, '初始化密码 123456'); INSERT INTO `sys_config` VALUES ('3', '主框架页-侧边栏主题', 'sys.index.sideTheme', 'theme-dark', 'Y', 'admin', '2020-12-07 16:06:28', '', null, '深色主题theme-dark，浅色主题theme-light'); INSERT INTO `sys_config` VALUES ('4', '账号自助-验证码开关', 'sys.account.captchaOnOff', 'false', 'Y', 'admin', '2021-07-19 13:04:39', 'admin', '2021-08-04 10:41:47', '是否开启登录验证码功能（true开启，false关闭）'); INSERT INTO `sys_config` VALUES ('5', '账号自助-是否开启用户注册功能', 'sys.account.registerUser', 'false', 'Y', 'admin', '2021-08-03 14:11:29', 'admin', '2021-08-04 10:41:56', '是否开启注册用户功能（true开启，false关闭）'); -- ---------------------------- -- Table structure for 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) 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=65 DEFAULT CHARSET=utf8mb4 COMMENT='字典数据表'; -- ---------------------------- -- Records of sys_dict_data -- ---------------------------- INSERT INTO `sys_dict_data` VALUES ('1', '1', '男', '0', 'sys_user_sex', '', '', 'Y', '0', 'admin', '2020-12-07 16:06:28', '', null, '性别男'); INSERT INTO `sys_dict_data` VALUES ('2', '2', '女', '1', 'sys_user_sex', '', '', 'N', '0', 'admin', '2020-12-07 16:06:28', '', null, '性别女'); INSERT INTO `sys_dict_data` VALUES ('3', '3', '未知', '2', 'sys_user_sex', '', '', 'N', '0', 'admin', '2020-12-07 16:06:28', '', null, '性别未知'); INSERT INTO `sys_dict_data` VALUES ('4', '1', '显示', '0', 'sys_show_hide', '', 'primary', 'Y', '0', 'admin', '2020-12-07 16:06:28', '', null, '显示菜单'); INSERT INTO `sys_dict_data` VALUES ('5', '2', '隐藏', '1', 'sys_show_hide', '', 'danger', 'N', '0', 'admin', '2020-12-07 16:06:28', '', null, '隐藏菜单'); INSERT INTO `sys_dict_data` VALUES ('6', '1', '正常', '0', 'sys_normal_disable', '', 'primary', 'Y', '0', 'admin', '2020-12-07 16:06:28', '', null, '正常状态'); INSERT INTO `sys_dict_data` VALUES ('7', '2', '停用', '1', 'sys_normal_disable', '', 'danger', 'N', '0', 'admin', '2020-12-07 16:06:28', '', null, '停用状态'); INSERT INTO `sys_dict_data` VALUES ('8', '1', '正常', '0', 'sys_job_status', '', 'primary', 'Y', '0', 'admin', '2020-12-07 16:06:28', '', null, '正常状态'); INSERT INTO `sys_dict_data` VALUES ('9', '2', '暂停', '1', 'sys_job_status', '', 'danger', 'N', '0', 'admin', '2020-12-07 16:06:28', '', null, '停用状态'); INSERT INTO `sys_dict_data` VALUES ('10', '1', '默认', 'DEFAULT', 'sys_job_group', '', '', 'Y', '0', 'admin', '2020-12-07 16:06:28', '', null, '默认分组'); INSERT INTO `sys_dict_data` VALUES ('11', '2', '系统', 'SYSTEM', 'sys_job_group', '', '', 'N', '0', 'admin', '2020-12-07 16:06:28', '', null, '系统分组'); INSERT INTO `sys_dict_data` VALUES ('12', '1', '是', 'Y', 'sys_yes_no', '', 'primary', 'Y', '0', 'admin', '2020-12-07 16:06:28', '', null, '系统默认是'); INSERT INTO `sys_dict_data` VALUES ('13', '2', '否', 'N', 'sys_yes_no', '', 'danger', 'N', '0', 'admin', '2020-12-07 16:06:28', '', null, '系统默认否'); INSERT INTO `sys_dict_data` VALUES ('14', '1', '通知', '1', 'sys_notice_type', '', 'warning', 'Y', '0', 'admin', '2020-12-07 16:06:28', '', null, '通知'); INSERT INTO `sys_dict_data` VALUES ('15', '2', '公告', '2', 'sys_notice_type', '', 'success', 'N', '0', 'admin', '2020-12-07 16:06:28', '', null, '公告'); INSERT INTO `sys_dict_data` VALUES ('16', '1', '正常', '0', 'sys_notice_status', '', 'primary', 'Y', '0', 'admin', '2020-12-07 16:06:28', '', null, '正常状态'); INSERT INTO `sys_dict_data` VALUES ('17', '2', '关闭', '1', 'sys_notice_status', '', 'danger', 'N', '0', 'admin', '2020-12-07 16:06:28', '', null, '关闭状态'); INSERT INTO `sys_dict_data` VALUES ('18', '1', '新增', '1', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2020-12-07 16:06:28', '', null, '新增操作'); INSERT INTO `sys_dict_data` VALUES ('19', '2', '修改', '2', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2020-12-07 16:06:28', '', null, '修改操作'); INSERT INTO `sys_dict_data` VALUES ('20', '3', '删除', '3', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2020-12-07 16:06:28', '', null, '删除操作'); INSERT INTO `sys_dict_data` VALUES ('21', '4', '授权', '4', 'sys_oper_type', '', 'primary', 'N', '0', 'admin', '2020-12-07 16:06:28', '', null, '授权操作'); INSERT INTO `sys_dict_data` VALUES ('22', '5', '导出', '5', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2020-12-07 16:06:28', '', null, '导出操作'); INSERT INTO `sys_dict_data` VALUES ('23', '6', '导入', '6', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2020-12-07 16:06:28', '', null, '导入操作'); INSERT INTO `sys_dict_data` VALUES ('24', '7', '强退', '7', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2020-12-07 16:06:28', '', null, '强退操作'); INSERT INTO `sys_dict_data` VALUES ('25', '8', '生成代码', '8', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2020-12-07 16:06:28', '', null, '生成操作'); INSERT INTO `sys_dict_data` VALUES ('26', '9', '清空数据', '9', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2020-12-07 16:06:28', '', null, '清空操作'); INSERT INTO `sys_dict_data` VALUES ('27', '1', '成功', '0', 'sys_common_status', '', 'primary', 'N', '0', 'admin', '2020-12-07 16:06:28', '', null, '正常状态'); INSERT INTO `sys_dict_data` VALUES ('28', '2', '失败', '1', 'sys_common_status', '', 'danger', 'N', '0', 'admin', '2020-12-07 16:06:28', '', null, '停用状态'); INSERT INTO `sys_dict_data` VALUES ('29', '0', '光伏电站', '1', 'itil_station_type', null, 'default', 'N', '0', 'admin', '2021-07-19 16:08:40', '', null, '光伏电站'); INSERT INTO `sys_dict_data` VALUES ('30', '0', '风力电站', '2', 'itil_station_type', null, 'default', 'N', '0', 'admin', '2021-07-19 16:08:55', '', null, '风力电站'); INSERT INTO `sys_dict_data` VALUES ('31', '1', '北京市', '110000', 'itil_area_code', null, 'default', 'N', '0', 'admin', '2021-07-19 16:11:57', '', null, '北京市'); INSERT INTO `sys_dict_data` VALUES ('32', '2', '天津市', '120000', 'itil_area_code', null, 'default', 'N', '0', 'admin', '2021-07-19 16:12:25', '', null, '天津市'); INSERT INTO `sys_dict_data` VALUES ('33', '3', '河北省', '130000', 'itil_area_code', null, 'default', 'N', '0', 'admin', '2021-07-19 16:12:25', '', null, '河北省'); INSERT INTO `sys_dict_data` VALUES ('34', '4', '山西省', '140000', 'itil_area_code', null, 'default', 'N', '0', 'admin', '2021-07-19 16:12:25', '', null, '山西省'); INSERT INTO `sys_dict_data` VALUES ('35', '5', '内蒙古自治区', '150000', 'itil_area_code', null, 'default', 'N', '0', 'admin', '2021-07-19 16:12:25', '', null, '内蒙古自治区'); INSERT INTO `sys_dict_data` VALUES ('36', '6', '辽宁省', '210000', 'itil_area_code', null, 'default', 'N', '0', 'admin', '2021-07-19 16:12:25', '', null, '辽宁省'); INSERT INTO `sys_dict_data` VALUES ('37', '7', '吉林省', '220000', 'itil_area_code', null, 'default', 'N', '0', 'admin', '2021-07-19 16:12:25', '', null, '吉林省'); INSERT INTO `sys_dict_data` VALUES ('38', '8', '黑龙江省', '230000', 'itil_area_code', null, 'default', 'N', '0', 'admin', '2021-07-19 16:12:25', '', null, '黑龙江省'); INSERT INTO `sys_dict_data` VALUES ('39', '9', '上海市', '310000', 'itil_area_code', null, 'default', 'N', '0', 'admin', '2021-07-19 16:12:25', '', null, '上海市'); INSERT INTO `sys_dict_data` VALUES ('40', '10', '江苏省', '320000', 'itil_area_code', null, 'default', 'N', '0', 'admin', '2021-07-19 16:12:25', '', null, '江苏省'); INSERT INTO `sys_dict_data` VALUES ('41', '11', '浙江省', '330000', 'itil_area_code', null, 'default', 'N', '0', 'admin', '2021-07-19 16:12:25', '', null, '浙江省'); INSERT INTO `sys_dict_data` VALUES ('42', '12', '安徽省', '340000', 'itil_area_code', null, 'default', 'N', '0', 'admin', '2021-07-19 16:12:25', '', null, '安徽省'); INSERT INTO `sys_dict_data` VALUES ('43', '13', '福建省', '350000', 'itil_area_code', null, 'default', 'N', '0', 'admin', '2021-07-19 16:12:25', '', null, '福建省'); INSERT INTO `sys_dict_data` VALUES ('44', '14', '江西省', '360000', 'itil_area_code', null, 'default', 'N', '0', 'admin', '2021-07-19 16:12:25', '', null, '江西省'); INSERT INTO `sys_dict_data` VALUES ('45', '15', '山东省', '370000', 'itil_area_code', null, 'default', 'N', '0', 'admin', '2021-07-19 16:12:25', '', null, '山东省'); INSERT INTO `sys_dict_data` VALUES ('46', '16', '河南省', '410000', 'itil_area_code', null, 'default', 'N', '0', 'admin', '2021-07-19 16:12:25', '', null, '河南省'); INSERT INTO `sys_dict_data` VALUES ('47', '17', '湖北省', '420000', 'itil_area_code', null, 'default', 'N', '0', 'admin', '2021-07-19 16:12:25', '', null, '湖北省'); INSERT INTO `sys_dict_data` VALUES ('48', '18', '湖南省', '430000', 'itil_area_code', null, 'default', 'N', '0', 'admin', '2021-07-19 16:12:25', '', null, '湖南省'); INSERT INTO `sys_dict_data` VALUES ('49', '19', '广东省', '440000', 'itil_area_code', null, 'default', 'N', '0', 'admin', '2021-07-19 16:12:25', '', null, '广东省'); INSERT INTO `sys_dict_data` VALUES ('50', '20', '广西壮族自治区', '450000', 'itil_area_code', null, 'default', 'N', '0', 'admin', '2021-07-19 16:12:25', '', null, '广西壮族自治区'); INSERT INTO `sys_dict_data` VALUES ('51', '21', '海南省', '460000', 'itil_area_code', null, 'default', 'N', '0', 'admin', '2021-07-19 16:12:25', '', null, '海南省'); INSERT INTO `sys_dict_data` VALUES ('52', '22', '重庆市', '500000', 'itil_area_code', null, 'default', 'N', '0', 'admin', '2021-07-19 16:12:25', '', null, '重庆市'); INSERT INTO `sys_dict_data` VALUES ('53', '23', '四川省', '510000', 'itil_area_code', null, 'default', 'N', '0', 'admin', '2021-07-19 16:12:25', '', null, '四川省'); INSERT INTO `sys_dict_data` VALUES ('54', '24', '贵州省', '520000', 'itil_area_code', null, 'default', 'N', '0', 'admin', '2021-07-19 16:12:25', '', null, '贵州省'); INSERT INTO `sys_dict_data` VALUES ('55', '25', '云南省', '530000', 'itil_area_code', null, 'default', 'N', '0', 'admin', '2021-07-19 16:12:25', '', null, '云南省'); INSERT INTO `sys_dict_data` VALUES ('56', '26', '西藏自治区', '540000', 'itil_area_code', null, 'default', 'N', '0', 'admin', '2021-07-19 16:12:25', '', null, '西藏自治区'); INSERT INTO `sys_dict_data` VALUES ('57', '27', '陕西省', '610000', 'itil_area_code', null, 'default', 'N', '0', 'admin', '2021-07-19 16:12:25', '', null, '陕西省'); INSERT INTO `sys_dict_data` VALUES ('58', '28', '甘肃省', '620000', 'itil_area_code', null, 'default', 'N', '0', 'admin', '2021-07-19 16:12:25', '', null, '甘肃省'); INSERT INTO `sys_dict_data` VALUES ('59', '29', '青海省', '630000', 'itil_area_code', null, 'default', 'N', '0', 'admin', '2021-07-19 16:12:25', '', null, '青海省'); INSERT INTO `sys_dict_data` VALUES ('60', '30', '宁夏回族自治区', '640000', 'itil_area_code', null, 'default', 'N', '0', 'admin', '2021-07-19 16:12:25', '', null, '宁夏回族自治区'); INSERT INTO `sys_dict_data` VALUES ('61', '31', '新疆维吾尔自治区', '650000', 'itil_area_code', null, 'default', 'N', '0', 'admin', '2021-07-19 16:12:25', '', null, '新疆维吾尔自治区'); INSERT INTO `sys_dict_data` VALUES ('62', '32', '台湾省', '710000', 'itil_area_code', null, 'default', 'N', '0', 'admin', '2021-07-19 16:12:25', '', null, '台湾省'); INSERT INTO `sys_dict_data` VALUES ('63', '33', '香港特别行政区', '810000', 'itil_area_code', null, 'default', 'N', '0', 'admin', '2021-07-19 16:12:25', '', null, '香港特别行政区'); INSERT INTO `sys_dict_data` VALUES ('64', '34', '澳门特别行政区', '820000', 'itil_area_code', null, 'default', 'N', '0', 'admin', '2021-07-19 16:12:25', '', null, '澳门特别行政区'); -- ---------------------------- -- Table structure for 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) 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=13 DEFAULT CHARSET=utf8mb4 COMMENT='字典类型表'; -- ---------------------------- -- Records of sys_dict_type -- ---------------------------- INSERT INTO `sys_dict_type` VALUES ('1', '用户性别', 'sys_user_sex', '0', 'admin', '2020-12-07 16:06:28', '', null, '用户性别列表'); INSERT INTO `sys_dict_type` VALUES ('2', '菜单状态', 'sys_show_hide', '0', 'admin', '2020-12-07 16:06:28', '', null, '菜单状态列表'); INSERT INTO `sys_dict_type` VALUES ('3', '系统开关', 'sys_normal_disable', '0', 'admin', '2020-12-07 16:06:28', '', null, '系统开关列表'); INSERT INTO `sys_dict_type` VALUES ('4', '任务状态', 'sys_job_status', '0', 'admin', '2020-12-07 16:06:28', '', null, '任务状态列表'); INSERT INTO `sys_dict_type` VALUES ('5', '任务分组', 'sys_job_group', '0', 'admin', '2020-12-07 16:06:28', '', null, '任务分组列表'); INSERT INTO `sys_dict_type` VALUES ('6', '系统是否', 'sys_yes_no', '0', 'admin', '2020-12-07 16:06:28', '', null, '系统是否列表'); INSERT INTO `sys_dict_type` VALUES ('7', '通知类型', 'sys_notice_type', '0', 'admin', '2020-12-07 16:06:28', '', null, '通知类型列表'); INSERT INTO `sys_dict_type` VALUES ('8', '通知状态', 'sys_notice_status', '0', 'admin', '2020-12-07 16:06:28', '', null, '通知状态列表'); INSERT INTO `sys_dict_type` VALUES ('9', '操作类型', 'sys_oper_type', '0', 'admin', '2020-12-07 16:06:28', '', null, '操作类型列表'); INSERT INTO `sys_dict_type` VALUES ('10', '系统状态', 'sys_common_status', '0', 'admin', '2020-12-07 16:06:28', '', null, '登录状态列表'); INSERT INTO `sys_dict_type` VALUES ('11', '行政区划代码', 'itil_area_code', '0', 'admin', '2021-07-19 16:10:18', 'admin', '2021-07-19 16:10:57', '省份代码列表'); INSERT INTO `sys_dict_type` VALUES ('12', '场站类型', 'itil_station_type', '0', 'admin', '2021-07-19 16:05:00', '', null, '场站类型列表'); -- ---------------------------- -- Table structure for 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) 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=5 DEFAULT CHARSET=utf8mb4 COMMENT='定时任务调度表'; -- ---------------------------- -- Records of sys_job -- ---------------------------- INSERT INTO `sys_job` VALUES ('1', '系统默认（无参）', 'DEFAULT', 'ryTask.ryNoParams', '0/10 * * * * ?', '3', '1', '1', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_job` VALUES ('2', '系统默认（有参）', 'DEFAULT', 'ryTask.ryParams(\'ry\')', '0/15 * * * * ?', '3', '1', '1', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_job` VALUES ('3', '系统默认（多参）', 'DEFAULT', 'ryTask.ryMultipleParams(\'ry\', true, 2000L, 316.50D, 100)', '0/20 * * * * ?', '3', '1', '1', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_job` VALUES ('4', '同步场站主数据与构建组织树', 'SYSTEM', 'powerStationSyncTask.syncData', '0 0 12 * * ?', '2', '1', '1', 'admin', '2020-12-22 13:02:56', '', null, ''); -- ---------------------------- -- Table structure for 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) 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='定时任务调度日志表'; -- ---------------------------- -- Records of sys_job_log -- ---------------------------- -- ---------------------------- -- Table structure for sys_logininfor -- ---------------------------- DROP TABLE IF EXISTS `sys_logininfor`; CREATE TABLE `sys_logininfor` ( `info_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '访问ID', `user_name` varchar(50) DEFAULT '' COMMENT '用户账号', `ipaddr` varchar(50) DEFAULT '' COMMENT '登录IP地址', `login_location` varchar(255) DEFAULT '' COMMENT '登录地点', `browser` varchar(50) DEFAULT '' COMMENT '浏览器类型', `os` varchar(50) DEFAULT '' COMMENT '操作系统', `status` char(1) DEFAULT '0' COMMENT '登录状态（0成功 1失败）', `msg` varchar(255) DEFAULT '' COMMENT '提示消息', `login_time` datetime DEFAULT NULL COMMENT '访问时间', PRIMARY KEY (`info_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统访问记录'; -- ---------------------------- -- Records of sys_logininfor -- ---------------------------- -- ---------------------------- -- Table structure for 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) 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='菜单权限表'; -- ---------------------------- -- Records of sys_menu -- ---------------------------- INSERT INTO `sys_menu` VALUES ('1', '系统管理', '0', '80', 'system', null, null, '1', '0', 'M', '0', '0', '', 'system', 'admin', '2020-12-07 16:06:28', 'admin', '2020-12-09 15:16:36', '系统管理目录'); INSERT INTO `sys_menu` VALUES ('2', '系统监控', '0', '81', 'monitor', null, null, '1', '0', 'M', '0', '0', '', 'monitor', 'admin', '2020-12-07 16:06:28', 'admin', '2020-12-09 15:16:53', '系统监控目录'); INSERT INTO `sys_menu` VALUES ('3', '系统工具', '0', '89', 'tool', null, null, '1', '0', 'M', '0', '0', '', 'tool', 'admin', '2020-12-07 16:06:28', 'admin', '2020-12-09 15:18:36', '系统工具目录'); INSERT INTO `sys_menu` VALUES ('4', '嘉越官网', '0', '99', 'http://www.jiayuepowertech.com', null, null, '0', '0', 'M', '0', '0', '', 'guide', 'admin', '2020-12-07 16:06:28', 'admin', '2020-12-08 14:37:50', '嘉越官网地址'); INSERT INTO `sys_menu` VALUES ('100', '用户管理', '1', '1', 'user', 'system/user/index', null, '1', '0', 'C', '0', '0', 'system:user:list', 'user', 'admin', '2020-12-07 16:06:28', '', null, '用户管理菜单'); INSERT INTO `sys_menu` VALUES ('101', '角色管理', '1', '2', 'role', 'system/role/index', null, '1', '0', 'C', '0', '0', 'system:role:list', 'peoples', 'admin', '2020-12-07 16:06:28', '', null, '角色管理菜单'); INSERT INTO `sys_menu` VALUES ('102', '菜单管理', '1', '3', 'menu', 'system/menu/index', null, '1', '0', 'C', '0', '0', 'system:menu:list', 'tree-table', 'admin', '2020-12-07 16:06:28', '', null, '菜单管理菜单'); INSERT INTO `sys_menu` VALUES ('103', '组织管理', '1', '4', 'unit', 'system/unit/index', null, '1', '0', 'C', '0', '0', 'system:unit:list', 'tree', 'admin', '2020-12-07 16:06:28', 'admin', '2020-12-25 10:09:57', '组织管理菜单'); INSERT INTO `sys_menu` VALUES ('104', '岗位管理', '1', '5', 'post', 'system/post/index', null, '1', '0', 'C', '0', '0', 'system:post:list', 'post', 'admin', '2020-12-07 16:06:28', '', null, '岗位管理菜单'); INSERT INTO `sys_menu` VALUES ('105', '字典管理', '1', '6', 'dict', 'system/dict/index', null, '1', '0', 'C', '0', '0', 'system:dict:list', 'dict', 'admin', '2020-12-07 16:06:28', '', null, '字典管理菜单'); INSERT INTO `sys_menu` VALUES ('106', '参数设置', '1', '7', 'config', 'system/config/index', null, '1', '0', 'C', '0', '0', 'system:config:list', 'edit', 'admin', '2020-12-07 16:06:28', '', null, '参数设置菜单'); INSERT INTO `sys_menu` VALUES ('107', '通知公告', '1', '8', 'notice', 'system/notice/index', null, '1', '0', 'C', '0', '0', 'system:notice:list', 'message', 'admin', '2020-12-07 16:06:28', '', null, '通知公告菜单'); INSERT INTO `sys_menu` VALUES ('108', '日志管理', '1', '9', 'log', '', null, '1', '0', 'M', '0', '0', '', 'log', 'admin', '2020-12-07 16:06:28', '', null, '日志管理菜单'); INSERT INTO `sys_menu` VALUES ('109', '在线用户', '2', '1', 'online', 'monitor/online/index', null, '1', '0', 'C', '0', '0', 'monitor:online:list', 'online', 'admin', '2020-12-07 16:06:28', '', null, '在线用户菜单'); INSERT INTO `sys_menu` VALUES ('110', '定时任务', '2', '2', 'job', 'monitor/job/index', null, '1', '0', 'C', '0', '0', 'monitor:job:list', 'job', 'admin', '2020-12-07 16:06:28', '', null, '定时任务菜单'); INSERT INTO `sys_menu` VALUES ('111', '数据监控', '2', '3', 'druid', 'monitor/druid/index', null, '1', '0', 'C', '0', '0', 'monitor:druid:list', 'druid', 'admin', '2020-12-07 16:06:28', '', null, '数据监控菜单'); INSERT INTO `sys_menu` VALUES ('112', '服务监控', '2', '4', 'server', 'monitor/server/index', null, '1', '0', 'C', '0', '0', 'monitor:server:list', 'server', 'admin', '2020-12-07 16:06:28', '', null, '服务监控菜单'); INSERT INTO `sys_menu` VALUES ('113', '缓存监控', '2', '5', 'cache', 'monitor/cache/index', null, '1', '0', 'C', '0', '0', 'monitor:cache:list', 'redis', 'admin', '2020-12-07 16:06:28', '', null, '缓存监控菜单'); INSERT INTO `sys_menu` VALUES ('114', '表单构建', '3', '1', 'build', 'tool/build/index', null, '1', '0', 'C', '0', '0', 'tool:build:list', 'build', 'admin', '2020-12-07 16:06:28', '', null, '表单构建菜单'); INSERT INTO `sys_menu` VALUES ('115', '代码生成', '3', '2', 'gen', 'tool/gen/index', null, '1', '0', 'C', '0', '0', 'tool:gen:list', 'code', 'admin', '2020-12-07 16:06:28', '', null, '代码生成菜单'); INSERT INTO `sys_menu` VALUES ('116', '系统接口', '3', '3', 'swagger', 'tool/swagger/index', null, '1', '0', 'C', '0', '0', 'tool:swagger:list', 'swagger', 'admin', '2020-12-07 16:06:28', '', null, '系统接口菜单'); INSERT INTO `sys_menu` VALUES ('500', '操作日志', '108', '1', 'operlog', 'monitor/operlog/index', null, '1', '0', 'C', '0', '0', 'monitor:operlog:list', 'form', 'admin', '2020-12-07 16:06:28', '', null, '操作日志菜单'); INSERT INTO `sys_menu` VALUES ('501', '登录日志', '108', '2', 'logininfor', 'monitor/logininfor/index', null, '1', '0', 'C', '0', '0', 'monitor:logininfor:list', 'logininfor', 'admin', '2020-12-07 16:06:28', '', null, '登录日志菜单'); INSERT INTO `sys_menu` VALUES ('1001', '用户查询', '100', '1', '', '', null, '1', '0', 'F', '0', '0', 'system:user:query', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1002', '用户新增', '100', '2', '', '', null, '1', '0', 'F', '0', '0', 'system:user:add', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1003', '用户修改', '100', '3', '', '', null, '1', '0', 'F', '0', '0', 'system:user:edit', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1004', '用户删除', '100', '4', '', '', null, '1', '0', 'F', '0', '0', 'system:user:remove', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1005', '用户导出', '100', '5', '', '', null, '1', '0', 'F', '0', '0', 'system:user:export', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1006', '用户导入', '100', '6', '', '', null, '1', '0', 'F', '0', '0', 'system:user:import', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1007', '重置密码', '100', '7', '', '', null, '1', '0', 'F', '0', '0', 'system:user:resetPwd', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1008', '角色查询', '101', '1', '', '', null, '1', '0', 'F', '0', '0', 'system:role:query', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1009', '角色新增', '101', '2', '', '', null, '1', '0', 'F', '0', '0', 'system:role:add', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1010', '角色修改', '101', '3', '', '', null, '1', '0', 'F', '0', '0', 'system:role:edit', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1011', '角色删除', '101', '4', '', '', null, '1', '0', 'F', '0', '0', 'system:role:remove', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1012', '角色导出', '101', '5', '', '', null, '1', '0', 'F', '0', '0', 'system:role:export', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1013', '菜单查询', '102', '1', '', '', null, '1', '0', 'F', '0', '0', 'system:menu:query', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1014', '菜单新增', '102', '2', '', '', null, '1', '0', 'F', '0', '0', 'system:menu:add', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1015', '菜单修改', '102', '3', '', '', null, '1', '0', 'F', '0', '0', 'system:menu:edit', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1016', '菜单删除', '102', '4', '', '', null, '1', '0', 'F', '0', '0', 'system:menu:remove', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1017', '组织单元查询', '103', '1', '', '', null, '1', '0', 'F', '0', '0', 'system:unit:query', '#', 'admin', '2020-12-07 16:06:28', 'admin', '2020-12-25 10:10:20', ''); INSERT INTO `sys_menu` VALUES ('1018', '组织单元新增', '103', '2', '', '', null, '1', '0', 'F', '0', '0', 'system:unit:add', '#', 'admin', '2020-12-07 16:06:28', 'admin', '2020-12-25 10:10:42', ''); INSERT INTO `sys_menu` VALUES ('1019', '组织单元修改', '103', '3', '', '', null, '1', '0', 'F', '0', '0', 'system:unit:edit', '#', 'admin', '2020-12-07 16:06:28', 'admin', '2020-12-25 10:11:00', ''); INSERT INTO `sys_menu` VALUES ('1020', '组织单元删除', '103', '4', '', '', null, '1', '0', 'F', '0', '0', 'system:unit:remove', '#', 'admin', '2020-12-07 16:06:28', 'admin', '2020-12-25 10:11:13', ''); INSERT INTO `sys_menu` VALUES ('1021', '岗位查询', '104', '1', '', '', null, '1', '0', 'F', '0', '0', 'system:post:query', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1022', '岗位新增', '104', '2', '', '', null, '1', '0', 'F', '0', '0', 'system:post:add', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1023', '岗位修改', '104', '3', '', '', null, '1', '0', 'F', '0', '0', 'system:post:edit', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1024', '岗位删除', '104', '4', '', '', null, '1', '0', 'F', '0', '0', 'system:post:remove', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1025', '岗位导出', '104', '5', '', '', null, '1', '0', 'F', '0', '0', 'system:post:export', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1026', '字典查询', '105', '1', '#', '', null, '1', '0', 'F', '0', '0', 'system:dict:query', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1027', '字典新增', '105', '2', '#', '', null, '1', '0', 'F', '0', '0', 'system:dict:add', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1028', '字典修改', '105', '3', '#', '', null, '1', '0', 'F', '0', '0', 'system:dict:edit', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1029', '字典删除', '105', '4', '#', '', null, '1', '0', 'F', '0', '0', 'system:dict:remove', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1030', '字典导出', '105', '5', '#', '', null, '1', '0', 'F', '0', '0', 'system:dict:export', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1031', '参数查询', '106', '1', '#', '', null, '1', '0', 'F', '0', '0', 'system:config:query', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1032', '参数新增', '106', '2', '#', '', null, '1', '0', 'F', '0', '0', 'system:config:add', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1033', '参数修改', '106', '3', '#', '', null, '1', '0', 'F', '0', '0', 'system:config:edit', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1034', '参数删除', '106', '4', '#', '', null, '1', '0', 'F', '0', '0', 'system:config:remove', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1035', '参数导出', '106', '5', '#', '', null, '1', '0', 'F', '0', '0', 'system:config:export', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1036', '公告查询', '107', '1', '#', '', null, '1', '0', 'F', '0', '0', 'system:notice:query', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1037', '公告新增', '107', '2', '#', '', null, '1', '0', 'F', '0', '0', 'system:notice:add', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1038', '公告修改', '107', '3', '#', '', null, '1', '0', 'F', '0', '0', 'system:notice:edit', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1039', '公告删除', '107', '4', '#', '', null, '1', '0', 'F', '0', '0', 'system:notice:remove', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1040', '操作查询', '500', '1', '#', '', null, '1', '0', 'F', '0', '0', 'monitor:operlog:query', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1041', '操作删除', '500', '2', '#', '', null, '1', '0', 'F', '0', '0', 'monitor:operlog:remove', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1042', '日志导出', '500', '4', '#', '', null, '1', '0', 'F', '0', '0', 'monitor:operlog:export', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1043', '登录查询', '501', '1', '#', '', null, '1', '0', 'F', '0', '0', 'monitor:logininfor:query', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1044', '登录删除', '501', '2', '#', '', null, '1', '0', 'F', '0', '0', 'monitor:logininfor:remove', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1045', '日志导出', '501', '3', '#', '', null, '1', '0', 'F', '0', '0', 'monitor:logininfor:export', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1046', '在线查询', '109', '1', '#', '', null, '1', '0', 'F', '0', '0', 'monitor:online:query', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1047', '批量强退', '109', '2', '#', '', null, '1', '0', 'F', '0', '0', 'monitor:online:batchLogout', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1048', '单条强退', '109', '3', '#', '', null, '1', '0', 'F', '0', '0', 'monitor:online:forceLogout', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1049', '任务查询', '110', '1', '#', '', null, '1', '0', 'F', '0', '0', 'monitor:job:query', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1050', '任务新增', '110', '2', '#', '', null, '1', '0', 'F', '0', '0', 'monitor:job:add', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1051', '任务修改', '110', '3', '#', '', null, '1', '0', 'F', '0', '0', 'monitor:job:edit', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1052', '任务删除', '110', '4', '#', '', null, '1', '0', 'F', '0', '0', 'monitor:job:remove', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1053', '状态修改', '110', '5', '#', '', null, '1', '0', 'F', '0', '0', 'monitor:job:changeStatus', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1054', '任务导出', '110', '7', '#', '', null, '1', '0', 'F', '0', '0', 'monitor:job:export', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1055', '生成查询', '115', '1', '#', '', null, '1', '0', 'F', '0', '0', 'tool:gen:query', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1056', '生成修改', '115', '2', '#', '', null, '1', '0', 'F', '0', '0', 'tool:gen:edit', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1057', '生成删除', '115', '3', '#', '', null, '1', '0', 'F', '0', '0', 'tool:gen:remove', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1058', '导入代码', '115', '2', '#', '', null, '1', '0', 'F', '0', '0', 'tool:gen:import', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1059', '预览代码', '115', '4', '#', '', null, '1', '0', 'F', '0', '0', 'tool:gen:preview', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); INSERT INTO `sys_menu` VALUES ('1060', '生成代码', '115', '5', '#', '', null, '1', '0', 'F', '0', '0', 'tool:gen:code', '#', 'admin', '2020-12-07 16:06:28', '', null, ''); -- ---------------------------- -- Table structure for 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) 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=9 DEFAULT CHARSET=utf8mb4 COMMENT='通知公告表'; -- ---------------------------- -- Records of sys_notice -- ---------------------------- INSERT INTO `sys_notice` VALUES ('3', '喜报 | 公司声雷达风能感知与探测系统成功入选2021年辽宁省工业高质量发展推荐产品目录名单', '2', 0x3C703EE8BF91E697A5EFBC8CE8BEBDE5AE81E79C81E5B7A5E4B89AE5928CE4BFA1E681AFE58C96E58E85E58F91E5B883E4BA8632303231E5B9B4E8BEBDE5AE81E79C81E5B7A5E4B89AE9AB98E8B4A8E9878FE58F91E5B195E68EA8E88D90E4BAA7E59381E79BAEE5BD95E5908DE58D95EFBC8CE585ACE58FB8E5A3B0E99BB7E8BEBEE9A38EE883BDE6849FE79FA5E4B88EE68EA2E6B58BE7B3BBE7BB9FE68890E58A9FE585A5E98089E380823C2F703E3C703E266E6273703B266E6273703B266E6273703B266E6273703BE5B7A5E4B89AE9AB98E8B4A8E9878FE58F91E5B195E68EA8E88D90E4BAA7E59381E79BAEE5BD95E79A84E68EA8E587BAEFBC8CE697A8E59CA8E68EA8E8BF9BE2809CE695B0E5AD97E8BEBDE5AE81E38081E588B6E980A0E5BCBAE79C81E2809DE5BBBAE8AEBEEFBC8CE68F90E58D87E8BEBDE5AE81E79C81E5B7A5E4B89AE4BC98E8B4A8E4BAA7E59381E79FA5E5908DE5BAA6E5928CE5BDB1E5938DE58A9BEFBC8CE68EA8E58AA8E4BAA7E4B89AE993BEE4B88AE4B88BE6B8B8E4BC81E4B89AE4BE9BE99C80E5AFB9E68EA5E58D8FE4BD9CE9858DE5A597EFBC8CE8AEA9E4BC98E8B4A8E4BC81E4B89AE4BAABE58F97E69BB4E5A49AE4BC98E683A0E694BFE7AD96EFBC8CE5BC95E9A286E4BC81E4B89AE59091E9AB98E7ABAFE58C96E38081E699BAE883BDE58C96E38081E789B9E889B2E58C96E5928CE7BBBFE889B2E58C96E696B9E59091E8BF88E8BF9BE38082E7BB8FE8BF87E7A4BEE4BC9AE5BE81E99B86E38081E5B882E7BAA7E5889DE5AEA1E38081E79C81E7BAA7E5A48DE6A0B8E38081E4B893E5AEB6E8AF84E4BC98E38081E79C81E79BB4E983A8E997A8E6848FE8A781E5BE81E6B182E7AD89E7A88BE5BA8FEFBC8CE585B1E585A5E98089313833E688B7E4BC81E4B89AE38081343031E4B8AAE4BAA7E59381E38082E68DAEE68289EFBC8CE6ADA4E6ACA1E585A5E98089E79A84E4BC81E4B89AE4B8BBE8A681E698AFE59BBDE5AEB6E9AB98E696B0E68A80E69CAFE4BC81E4B89AE38081E68898E795A5E680A7E696B0E585B4E4BC81E4B89AE38081E79C81E995BFE8B4A8E9878FE5A596E4BC81E4B89AE38081E8A18CE4B89AE9BE99E5A4B4E4BC81E4B89AE38081E588B6E980A0E4B89AE99A90E5BDA2E586A0E5869BE4BC81E4B89AE38081E2809CE4B893E7B2BEE789B9E696B0E2809DE7AD89E7AB9EE4BA89E58A9BE5BCBAE38081E5B8A6E58AA8E58A9BE5BCBAE79A84E68891E79C81E4BC98E7A780E4BC81E4B89AE380823C2F703E3C7020636C6173733D22716C2D616C69676E2D63656E746572223E3C696D67207372633D22687474703A2F2F7777772E6A6961797565706F776572746563682E636F6D2F7573657266696C65732F696D616765732F32303231303630343136323033352D32323238303934363337333933393531362E6A7067223E3C2F703E3C7020636C6173733D22716C2D616C69676E2D63656E746572223E3C696D67207372633D22687474703A2F2F7777772E6A6961797565706F776572746563682E636F6D2F7573657266696C65732F696D616765732F32303231303630343136323034312D38353238363539363237373732383637322E6A7067223E3C2F703E3C7020636C6173733D22716C2D616C69676E2D63656E746572223E3C696D67207372633D22687474703A2F2F7777772E6A6961797565706F776572746563682E636F6D2F7573657266696C65732F696D616765732F32303231303630343136323035302D32373036303131343430363034393235322E6A7067223E3C2F703E3C7020636C6173733D22716C2D616C69676E2D63656E746572223E3C696D67207372633D22687474703A2F2F7777772E6A6961797565706F776572746563682E636F6D2F7573657266696C65732F696D616765732F32303231303630343136323132362D35363633313432343833363831343430302E6A7067223E3C2F703E3C7020636C6173733D22716C2D616C69676E2D63656E746572223E3C696D67207372633D22687474703A2F2F7777772E6A6961797565706F776572746563682E636F6D2F7573657266696C65732F696D616765732F32303231303630343136323133332D323234363131313637373935393536312E6A7067223E3C2F703E3C703E3C62723E3C2F703E, '0', 'admin', '2021-07-30 15:23:37', '', null, null); INSERT INTO `sys_notice` VALUES ('4', '喜报 | 嘉越电力获批沈阳市企业技术中心', '2', 0x3C703EE8BF91E697A5EFBC8CE6B288E998B3E5B882E5B7A5E4BFA1E5B180E58F91E5B883E4BA8632303231E5B9B4E68B9FE8AEA4E5AE9AE5B882E7BAA7E4BC81E4B89AE68A80E69CAFE4B8ADE5BF83E5908DE58D95EFBC8CE59889E8B68AE794B5E58A9BE68890E4B8BA3239E5AEB6E585B7E69C89E6B288E998B3E5B882E4BC81E4B89AE68A80E69CAFE4B8ADE5BF83E8B584E6A0BCE8AEA4E5AE9AE79A84E4BC81E4B89AE4B98BE4B880E380823C2F703E3C7020636C6173733D22716C2D616C69676E2D63656E746572223E3C696D67207372633D22687474703A2F2F7777772E6A6961797565706F776572746563682E636F6D2F7573657266696C65732F696D616765732F32303231303532313136353332312D38303932363338343137313437303939322E6A7067223E3C2F703E3C703E266E6273703B266E6273703B266E6273703B266E6273703BE4BE9DE68DAEE3808AE6B288E998B3E5B882E4BC81E4B89AE68A80E69CAFE4B8ADE5BF83E8AEA4E5AE9AE7AEA1E79086E58A9EE6B395E3808BEFBC8CE4BC81E4B89AE68A80E69CAFE4B8ADE5BF83E698AFE4BC81E4B89AE8AEBEE7AB8BE79A84E585B7E69C89E8BE83E9AB98E5B182E6ACA1E5928CE6B0B4E5B9B3E79A84E7A094E7A9B6E5BC80E58F91E69CBAE69E84EFBC8CE698AFE4BC81E4B89AE68A80E69CAFE5889BE696B0E4BD93E7B3BBE79A84E6A0B8E5BF83EFBC8CE698AFE4BC81E4B89AE68A80E69CAFE8BF9BE6ADA5E5928CE68A80E69CAFE5889BE696B0E79A84E4B8BBE8A681E68A80E69CAFE4BE9DE68998E38082E4BC81E4B89AE68A80E69CAFE4B8ADE5BF83E69CACE79D80E4B8BAE4BC81E4B89AE58F91E5B195E68F90E4BE9BE68A80E69CAFE694AFE68C81EFBC8CE5A29EE5BCBAE4BC81E4B89AE79A84E5B882E59CBAE7AB9EE4BA89E883BDE58A9BE38081E7BB8FE6B58EE69588E79B8AE5928CE58F91E5B195E5908EE58AB2EFBC8CE4B88DE4BBA5E887AAE8BAABE890A5E588A9E4B8BAE79BAEE79A84EFBC8CE5BCBAE8B083E5B882E59CBAE6848FE8AF86E38081E695B4E4BD93E6848FE8AF86E38081E69588E79B8AE6848FE8AF86E5928CE5889BE696B0E6848FE8AF86E380823C2F703E3C703E266E6273703B266E6273703B266E6273703B266E6273703BE69CACE6ACA1E88EB7E689B9E5B882E7BAA7E4BC81E4B89AE68A80E69CAFE4B8ADE5BF83EFBC8CE698AFE5AFB9E585ACE58FB8E79A84E68A80E69CAFE7A094E58F91E5928CE5889BE696B0E5AE9EE58A9BE79A84E58F88E4B880E6ACA1E8AEA4E58FAFEFBC8CE585ACE58FB8E5B086E4BBA5E6ADA4E88DA3E8AA89E4B8BAE5A591E69CBAE5928CE58AA8E58A9B2C20E5AE8CE59684E4BC81E4B89AE68A80E69CAFE5889BE696B0E4BD93E7B3BB2C20E68A93E5A5BDE4BC81E4B89AE68A80E69CAFE4B8ADE5BF83E5BBBAE8AEBEE38082E4B88BE4B880E6ADA5EFBC8CE585ACE58FB8E5B086E7BBA7E7BBADE7A789E689BFE2809CE887AAE4B8BBE5889BE696B0EFBC8CE8BFBDE6B182E58D93E8B68AEFBC8CE9878DE8AF9AE5AE88E4BFA1EFBC8CE4BC98E8B4A8E69C8DE58AA1E2809DE79A84E4BC81E4B89AE7B2BEE7A59EEFBC8CE5A4A7E58A9BE68EA8E8BF9BE2809CE4BBA5E4BC81E4B89AE5889BE696B0E4B8BAE4B8BBE4BD93E38081E4BAA7E5ADA6E7A094E794A8E79BB8E7BB93E59088E2809DE79A84E68A80E69CAFE5889BE696B0E4BD93E7B3BBE5BBBAE8AEBEEFBC8CE7A7AFE69E81E4B88EE4B8ADE59BBDE794B5E58A9BE7A791E5ADA6E7A094E7A9B6E999A2E38081E4B8ADE59BBDE794B5E5AD90E7A791E68A80E99B86E59BA2E38081E4B88AE6B5B7E4BAA4E9809AE5A4A7E5ADA6E38081E58C97E4BAACE79086E5B7A5E5A4A7E5ADA6E38081E4B89CE58C97E5A4A7E5ADA6E38081E6B288E998B3E5B7A5E4B89AE5A4A7E5ADA6E38081E6B288E998B3E5B7A5E7A88BE5ADA6E999A2E7AD89E9AB98E6A0A1E5928CE7A791E7A094E999A2E68980E4BAA7E5ADA6E7A094E6B7B1E5BAA6E59088E4BD9CEFBC8CE6B7B1E58C96E4BC81E4B89AE68A80E69CAFE5889BE696B0E883BDE58A9BEFBC8CE8819AE784A6E4BC81E4B89AE6A0B8E5BF83E4B89AE58AA1EFBC8CE9878DE8A786E5AFB9E696B0E68A80E69CAFE38081E696B0E4BAA7E59381E79A84E7A094E58F91E68A95E585A5EFBC8CE4BBA5E68A80E69CAFE7A094E58F91E5889BE696B0E58F91E5B195E69DA5E68F90E58D87E4BC81E4B89AE79A84E6A0B8E5BF83E7AB9EE4BA89E58A9BE5928CE59381E7898CE5BDB1E5938DE58A9BEFBC8CE68993E980A0E8A18CE4B89AE6A087E69D86E585B8E88C83E380823C2F703E, '0', 'admin', '2021-07-30 15:24:10', '', null, null); INSERT INTO `sys_notice` VALUES ('5', '五一劳动节放假通知及温馨提示', '1', 0x3C703E3C696D67207372633D22687474703A2F2F7777772E6A6961797565706F776572746563682E636F6D2F7573657266696C65732F696D616765732F32303231303433303134323834392D39353939333538393838393235383134342E6A7067223E3C2F703E, '0', 'admin', '2021-07-30 15:24:53', '', null, null); INSERT INTO `sys_notice` VALUES ('6', '公司参加第十九届中国国际人才交流大会•辽宁揭榜挂帅科洽会', '2', 0x3C703E2020202032303231E5B9B434E69C883237E697A5EFBC8CE794B1E8BEBDE5AE81E79C81E5A794E7BB84E7BB87E983A8E38081E8BEBDE5AE81E79C81E7A791E68A80E58E85E38081E6B288E998B3E5B882E4BABAE6B091E694BFE5BA9CE7AD89E58D95E4BD8DE585B1E5908CE4B8BBE58A9EEFBC8CE4B89CE58C97E7A791E68A80E5A4A7E5B882E59CBAE689BFE58A9EE79A84E7ACACE58D81E4B99DE5B18AE4B8ADE59BBDE59BBDE99985E4BABAE6898DE4BAA4E6B581E5A4A7E4BC9AE280A2E8BEBDE5AE81E68FADE6A69CE68C82E5B885E7A791E6B4BDE4BC9AEFBC88E4BBA5E4B88BE7AE80E7A7B0E8BEBDE5AE81E7A791E6B4BDE4BC9AEFBC89E59CA8E6B288E998B3E99A86E9878DE5BC80E5B995E38082E8BEBDE5AE81E79C81E4BABAE6B091E694BFE5BA9CE589AFE79C81E995BFE78E8BE6988EE78E89E5AEA3E5B883E5A4A7E4BC9AE5BC80E5B995E5B9B6E8AEB2E8AF9DE38082E59BBDE5AEB6E887AAE784B6E7A791E5ADA6E59FBAE98791E5A794E589AFE4B8BBE4BBBBE9AB98E7919EE5B9B3E38081E7A791E68A80E983A8E59BBDE99985E4BABAE6898DE4BAA4E6B581E4B8ADE5BF83E589AFE4B8BBE4BBBBE5A48FE585B5E4BBA5E58F8AE79C81E5A496E9AB98E6A0A1E38081E7A791E7A094E999A2E68980E4B893E5AEB6E5ADA6E88085E5928CE79C81E58685E4BC81E4B89AE4BBA3E8A1A8E7BAA632303030E4BABAE58F82E58AA0E4BC9AE8AEAEE380823C2F703E3C7020636C6173733D22716C2D616C69676E2D63656E746572223E3C696D67207372633D22687474703A2F2F7777772E6A6961797565706F776572746563682E636F6D2F7573657266696C65732F696D616765732F32303231303433303134333232372D37393933343535353234353536333339322E6A7067223E3C2F703E3C7020636C6173733D22716C2D616C69676E2D63656E746572223E3C696D67207372633D22687474703A2F2F7777772E6A6961797565706F776572746563682E636F6D2F7573657266696C65732F696D616765732F32303231303433303134333233322D36353431363730383236323633373235362E6A7067223E3C2F703E3C7020636C6173733D22716C2D616C69676E2D63656E746572223EE8BEBDE5AE81E7A791E6B4BDE4BC9AE6B4BBE58AA8E78EB0E59CBA3C2F703E3C703E266E6273703B266E6273703B266E6273703B266E6273703BE69CACE5B18AE8BEBDE5AE81E7A791E6B4BDE4BC9AE59BB4E7BB95E2809CE699BAE6B187E8BEBDE5AE81E585B1E8B08BE68CAFE585B4EFBC8CE699BAE695ACE8BEBDE5AE81E5889BE696B0E697B6E4BBA3E2809DE8BF99E4B880E4B8BBE9A298EFBC8CE59CA8E585A8E79C81E5BE81E99B86E4BA86323030E4BD99E9A1B9E68A80E69CAFE99C80E6B182EFBC8CE5879DE7BB83E5BDA2E688903733E9A1B9E2809CE68FADE6A69CE68C82E5B885E2809DE7A791E68A80E694BBE585B3E9A1B9E79BAEE6A69CE58D95E99DA2E59091E79C81E5A496E58F91E5B883EFBC8CE585B6E4B8AD3633E4B8AAE9A1B9E79BAEE59CA8E4BC9AE4B88AE8BF9BE8A18CE4BA86E6B4BDE8B088E5AFB9E68EA5E38082E59889E8B68AE794B5E58A9BE4BD9CE4B8BAE2809CE68FADE6A69CE68C82E5B885E2809DE7A791E68A80E694BBE585B3E9A1B9E79BAEE79A84E79B9FE4B8BBE58D95E4BD8DE4B98BE4B880E58F97E98280E58F82E58AA0E6ADA4E6ACA1E6B4BBE58AA8E380823C2F703E3C7020636C6173733D22716C2D616C69676E2D63656E746572223E3C696D67207372633D22687474703A2F2F7777772E6A6961797565706F776572746563682E636F6D2F7573657266696C65732F696D616765732F32303231303433303134333332382D34333535343534343430323238363430382E6A7067223E3C2F703E3C7020636C6173733D22716C2D616C69676E2D63656E746572223EE8BEBDE5AE81E79C81E4BABAE6B091E694BFE5BA9CE589AFE79C81E995BFE78E8BE6988EE78E89E7AD89E9A286E5AFBCE4B880E8A18CE588B0E88194E79B9FE99C80E6B182E6A69CE58F82E8A7823C2F703E3C7020636C6173733D22716C2D616C69676E2D63656E746572223E3C696D67207372633D22687474703A2F2F7777772E6A6961797565706F776572746563682E636F6D2F7573657266696C65732F696D616765732F32303231303433303134333430352D39383231393637343733323533363038302E6A7067223E3C2F703E3C7020636C6173733D22716C2D616C69676E2D63656E746572223EE5B195E4BD8DE78EB0E59CBA20C2B720E59889E8B68AE794B5E58A9BE68A80E69CAFE589AFE680BBE58898E5AE9DE889AFE8AEB2E8A7A3E585ACE58FB8E4BAA7E593813C2F703E3C703E266E6273703B266E6273703B266E6273703B266E6273703BE69CACE6ACA1E5B195E4BC9AE59889E8B68AE794B5E58A9BE5B8A6E69DA5E79A84E9A38EE794B5E59CBAE6B094E8B1A1E79B91E6B58BE5A3B0E99BB7E8BEBEE5B9BFE58F97E585B3E6B3A8EFBC8CE5B195E58FB0E5898DE592A8E8AFA2E6B4BDE8B088E79A84E4B89AE58685E4BABAE5A3ABE7BB9CE7BB8EE4B88DE7BB9DE38082E4B88EE4BCA0E7BB9FE79A84E9A38EE794B5E59CBAE6B58BE9A38EE6898BE6AEB5E59BBAE5AE9AE5BC8FE6B58BE9A38EE5A194E79BB8E6AF94EFBC8CE59FBAE4BA8EE696B0E4B880E4BBA3E4BFA1E681AFE68A80E69CAFE79A84E9A38EE794B5E59CBAE6B094E8B1A1E79B91E6B58BE5A3B0E99BB7E8BEBEE883BDE5A49FE5AE9EE78EB0E9A38EE8B584E6BA90E5928CE9A38EE586B5E79A84E9AB98E7B2BEE5BAA6E38081E7B2BEE7BB86E58C96E6849FE79FA5E5928CE68EA2E6B58BEFBC8CE58FAFE4BBA5E6B58BE9878FE9AB98E5B182E38081E5A49AE5B182E38081E5A49AE782B9E79A84E9A38EE695B0E68DAEEFBC8CE9998DE4BD8EE6B58BE9A38EE5A194E59E82E79BB4E5A496E68EA8E5928CE6B0B4E5B9B3E5A496E68EA8E5BC95E8B5B7E79A84E6B58BE9878FE4B88DE7A1AEE5AE9AE680A7EFBC8CE585B7E69C89E58FAFE99DA0E680A7E9AB98E38081E5AE89E585A8E680A7E5A5BDE38081E7BBBCE59088E68890E69CACE4BD8EE38081E8BF90E8A18CE7BBB4E68AA4E4BEBFE68DB7E38081E983A8E7BDB2E7AE80E58D95E38081E98082E5BA94E680A7E5A5BDE7AD89E8AFB8E5A49AE789B9E782B9EFBC8CE58FAFE6BBA1E8B6B3E9A38EE794B5E8A18CE4B89AE6B689E58F8AE588B0E6B58BE9A38EE99C80E6B182E79A84E68980E69C89E5BA94E794A8E59CBAE699AFEFBC8CE585B6E5B9BFE6B39BE68EA8E5B9BFE5BA94E794A8E5B086E69E81E5A4A7E68F90E58D87E9A38EE883BDE8B584E6BA90E588A9E794A8E78E87E5928CE8BDACE58C96E78E87EFBC8CE5A29EE58AA0E9A38EE794B5E59CBAE69588E78E87E5928CE69588E79B8AEFBC8CE58AA9E68EA8E9A38EE794B5E4BAA7E4B89AE4BC98E58C96E58D87E7BAA7E38081E68F90E8B4A8E5A29EE69588E5928CE58FAFE68C81E7BBADE58F91E5B195E380823C2F703E3C7020636C6173733D22716C2D616C69676E2D63656E746572223E3C696D67207372633D22687474703A2F2F7777772E6A6961797565706F776572746563682E636F6D2F7573657266696C65732F696D616765732F32303231303433303134333435342D343637343233393435363635333539352E6A7067223E3C2F703E3C7020636C6173733D22716C2D616C69676E2D63656E746572223EE8BEBDE5AE81E7A791E6B4BDE4BC9AE6B4BBE58AA8E4B98BE88194E79B9FE99C80E6B182E6A69CE58CBAE59F9FE78EB0E59CBAE79B9BE586B53C2F703E3C703E3C62723E3C2F703E, '0', 'admin', '2021-07-30 15:25:47', '', null, null); INSERT INTO `sys_notice` VALUES ('7', '公司受邀出席2021首届“雷达与未来”全球峰会分论坛并做精彩报告', '2', 0x3C703E266E6273703B266E6273703B266E6273703B266E6273703B32303231E5B9B434E69C883232E697A5EFBC8CE794B1E4B8ADE59BBDE99BB7E8BEBEE8A18CE4B89AE7A791E68A80E5A794E58F91E8B5B7E79A84E9A696E5B18AE2809CE99BB7E8BEBEE4B88EE69CAAE69DA5E2809DE585A8E79083E5B3B0E4BC9AE59CA8E58D97E4BAACE59BBDE99985E58D9AE8A788E4B8ADE5BF83E68890E58A9FE4B8BEE58A9EE38082E69CACE5B18AE5B3B0E4BC9AE794B1E4B8ADE59BBDE794B5E5AD90E7A791E68A80E99B86E59BA2E69C89E99990E585ACE58FB8E38081E4B8ADE59BBDE99BB7E8BEBEE8A18CE4B89AE58D8FE4BC9AE38081E4B8ADE59BBDE794B5E5AD90E4BFA1E681AFE4BAA7E4B89AE99B86E59BA2E69C89E99990E585ACE58FB8E88194E59088E4B8BBE58A9EEFBC8CE4B8BAE69C9FE4B8A4E5A4A9E38082E58D9AE8A788E4BC9AE590B8E5BC95E4BA86E59BBDE58685E5A496E8BF91343030E5AEB6E99BB7E8BEBEE58F8AE794B5E5AD90E4BFA1E681AFE9BE99E5A4B4E4BC81E4B89AE38081E78BACE8A792E585BDE4BC81E4B89AE38081E9AB98E68890E995BFE680A7E4B8ADE5B08FE59E8BE4BC81E4B89AE58F82E5B195E4BAA4E6B581EFBC8CE5B195E587BAE8A784E6A8A1E980BE34E4B887E5B9B3E7B1B3EFBC8CE8BF91E799BEE9A1B9E5B195E59381E9A696E6ACA1E4BAAEE79BB8EFBC8CE4B893E4B89AE8A782E4BC97E8BEBE33E4B887E4BD99E4BABAE6ACA1EFBC8CE695B4E4BD93E8A784E6A8A1E7A9BAE5898DE380823C2F703E3C7020636C6173733D22716C2D616C69676E2D63656E746572223E3C696D67207372633D22687474703A2F2F7777772E6A6961797565706F776572746563682E636F6D2F7573657266696C65732F696D616765732F32303231303432393137303134352D383437303530303330373135373633362E6A7067223E3C2F703E3C7020636C6173733D22716C2D616C69676E2D63656E746572223E32303231E9A696E5B18AE2809CE99BB7E8BEBEE4B88EE69CAAE69DA5E2809DE585A8E79083E5B3B0E4BC9AE78EB0E59CBA3C2F703E3C703E266E6273703B266E6273703B266E6273703B266E6273703BE69CACE5B18AE58D9AE8A788E4BC9AE4BBA5E2809CE68EA8E58AA8E696B0E697B6E4BBA3E5889BE696B0EFBC8CE69E84E5BBBAE696B0E58F91E5B195E6A0BCE5B180E2809DE4B8BAE5AE97E697A8EFBC8CE4BBA5E2809CE99BB7E8BEBEE6849FE79FA5E4B896E7958CEFBC8CE585B1E5889BE695B0E699BAE69CAAE69DA5E2809DE4B8BAE4B8BBE9A298EFBC8CE5AE89E68E92E4BA863138E4B8AAE2809CE99BB7E8BEBEE4B88EE2809DE7B3BBE58897E4B8BBE9A298E58886E8AEBAE59D9BEFBC8CE6B6B5E79B96E4BA86E99BB7E8BEBEE58F8AE585B6E5BA94E794A8E79A84E59084E4B8AAE9A286E59F9FEFBC8CE6B7B1E5BAA6E7A094E8AEA8E2809CE7A9BAE38081E5A4A9E38081E59CB0E38081E6B5B7E38081E7BD91E2809DE4B88DE5908CE7A9BAE997B4E4B8ADE99BB7E8BEBEE6849FE79FA5E4B896E7958CE79A84E68A80E69CAFE5898DE6B2BFE5928CE58F91E5B195E8B68BE58ABFE380823C2F703E3C703E266E6273703B266E6273703B266E6273703B266E6273703BE5A4A7E4BC9AE7ACACE4BA8CE5A4A9EFBC8834E69C883233E697A5EFBC89EFBC8CE2809CE99BB7E8BEBEE4B88EE78EAFE5A283E6B2BBE79086E2809DE58886E8AEBAE59D9BE6ADA3E5BC8FE68B89E5BC80E5B8B7E5B995EFBC8CE585ABE4BD8DE79BB8E585B3E9A286E59F9FE4B893E5AEB6E38081E5ADA6E88085E58886E588ABE4B8BAE5B9BFE5A4A7E58F82E4BC9AE794A8E688B7E5B8A6E69DA5E7B2BEE5BDA9E68AA5E5918AE38082E68AA5E5918AE58685E5AEB9E59BB4E7BB95E68891E59BBDE78EB0E998B6E6AEB5E7949FE68081E78EAFE4BF9DE783ADE782B9E997AEE9A298EFBC8CE690ADE5BBBAE4BAA7E38081E5ADA6E38081E7A094E38081E794A8E4BAA4E6B581E59088E4BD9CE5B9B3E58FB0EFBC8CE5B0B1E8B584E6BA90E88A82E7BAA6E4B88EE78EAFE5A283E4BF9DE68AA4E694BFE7AD96E8B68BE58ABFE38081E78EAFE4BF9DE4BFA1E681AFE58C96E79B91E7AEA1E7AD89E58685E5AEB9EFBC8CE4B8BAE99BB7E8BEBEE4B88EE78EAFE5A283E6B2BBE79086E9A286E59F9FE58685E79A84E4BB8EE4B89AE4BABAE59198E5B8A6E69DA5E4B880E59CBAE8AFA6E5B0BDE8808CE58F88E5AE9EE59CA8E79A84E68A80E69CAFE79B9BE5AEB4E380823C2F703E3C703E266E6273703B266E6273703B266E6273703B266E6273703BE8BEBDE5AE81E79C81E794B5E7BD91E4B88EE88A82E883BDE9878DE782B9E5AE9EE9AA8CE5AEA4E68A80E69CAFE9A1BEE997AEE38081E6B288E998B3E5B7A5E7A88BE5ADA6E999A2E9AB98E7BAA7E5B7A5E7A88BE5B888E38081E6B288E998B3E59889E8B68AE794B5E58A9BE7A791E68A80E69C89E99990E585ACE58FB8E68A80E69CAFE589AFE680BBE58898E5AE9DE889AFE4BD9CE4B8BAE6BC94E8AEB2E59889E5AEBEE4B98BE4B880E4BD9CE9A298E4B8BAE3808AE5A3B0E99BB7E8BEBEE59CA8E7B2BEE7BB86E58C96E6B58BE9A38EE9A286E59F9FE79A84E5BA94E794A8E3808BE79A84E4B8BBE697A8E6BC94E8AEB2E380823C2F703E3C7020636C6173733D22716C2D616C69676E2D63656E746572223E3C696D67207372633D22687474703A2F2F7777772E6A6961797565706F776572746563682E636F6D2F7573657266696C65732F696D616765732F32303231303432393137303233322D35373030373630373231323239303136382E6A7067223E3C2F703E3C7020636C6173733D22716C2D616C69676E2D63656E746572223EE58898E5AE9DE889AFE4BD9CE9A298E4B8BAE3808AE5A3B0E99BB7E8BEBEE59CA8E7B2BEE7BB86E58C96E6B58BE9A38EE9A286E59F9FE79A84E5BA94E794A8E3808BE79A84E4B8BBE697A8E6BC94E8AEB23C2F703E3C703E266E6273703B266E6273703B266E6273703B266E6273703BE59CA8E68AA5E5918AE4B8ADEFBC8CE58898E5AE9DE889AFE4BB8EE8A18CE4B89AE8838CE699AFE5928CE58F91E5B195E8B68BE58ABFE38081E7B2BEE7BB86E58C96E6B58BE9A38EE99C80E6B182E38081E5BD93E5898DE6B58BE9A38EE79A84E5B180E99990E680A7E38081E8A18CE4B89AE7979BE782B9E38081E5BA94E794A8E59CBAE699AFE38081E4BAA7E59381E585B3E994AEE68A80E69CAFE58F8AE680A7E883BDE68C87E6A087E38081E585B8E59E8BE6A188E4BE8BE7AD89E587A0E4B8AAE696B9E99DA2E585A8E99DA2E4BB8BE7BB8DE4BA86E5A3B0E99BB7E8BEBEE59CA8E7B2BEE7BB86E58C96E6B58BE9A38EE68A80E69CAFE9A286E59F9FE79A84E58F91E5B195E8BF87E7A88BE4BBA5E58F8AE78EB0E69C89E78AB6E586B5EFBC8CE5B9B6E4B88EE58F82E4BC9AE4BABAE59198E8BF9BE8A18CE4BA86E6B7B1E585A5E4BAA4E6B581E4B88EE8AEA8E8AEBAE380823C2F703E3C7020636C6173733D22716C2D616C69676E2D63656E746572223E3C696D67207372633D22687474703A2F2F7777772E6A6961797565706F776572746563682E636F6D2F7573657266696C65732F696D616765732F32303231303432393137303232372D33303738383631333930323430343930342E6A7067223E3C2F703E3C7020636C6173733D22716C2D616C69676E2D63656E746572223E32303231E9A696E5B18AE2809CE99BB7E8BEBEE4B88EE69CAAE69DA5E2809DE585A8E79083E5B3B0E4BC9AE4B98BE99BB7E8BEBEE4B88EE78EAFE5A283E6B2BBE79086E58886E8AEBAE59D9BE6BC94E8AEB2E59889E5AEBEE59088E5BDB13C2F703E3C703E3C62723E3C2F703E, '0', 'admin', '2021-07-30 15:26:35', '', null, null); INSERT INTO `sys_notice` VALUES ('8', '公司参加第五届新能源发电运营与后服务研讨会', '2', 0x3C7020636C6173733D22716C2D616C69676E2D63656E746572223E3C696D67207372633D22687474703A2F2F7777772E6A6961797565706F776572746563682E636F6D2F7573657266696C65732F696D616765732F32303231303432393136353631332D34313938383231333936353636393237322E6A7067223E3C2F703E3C7020636C6173733D22716C2D616C69676E2D63656E746572223E32303231E5B9B4E7ACACE4BA94E5B18AE696B0E883BDE6BA90E794B5E7AB99E8BF90E890A5E58F8AE5908EE69C8DE58AA1E7A094E8AEA8E4BC9AE7ADBEE588B0E78EB0E59CBA3C2F703E3C703E266E6273703B266E6273703B266E6273703B266E6273703B32303231E5B9B434E69C883233E697A5EFBC8CE794B1E4B8ADE59BBDE58589E4BC8FE8A18CE4B89AE58D8FE4BC9AE38081E58589E4BC8FE58091E88194E59088E4B8BBE58A9EE79A84E7ACACE4BA94E5B18AE696B0E883BDE6BA90E58F91E794B5E8BF90E890A5E4B88EE5908EE69C8DE58AA1E7A094E8AEA8E4BC9AE59CA8E4B8ADE59BBDE8818CE5B7A5E4B98BE5AEB6E9A5ADE5BA97E9A1BAE588A9E58FACE5BC80EFBC8CE69DA5E887AAE696B0E883BDE6BA90E794B5E7AB99E68A95E8B584E4BC81E4B89AE38081E7ACACE4B889E696B9E6A380E6B58BE8AEA4E8AF81E69CBAE69E84E38081E8BF90E7BBB4E585ACE58FB8E4BBA5E58F8AE8AEBEE5A487E7AD89E9A286E59F9FE79A84333530E4BD99E4BABAE58F82E4B88EE4BA86E6ADA4E6ACA1E8AEBAE59D9BEFBC8CE585B1E5908CE68EA2E8AEA8E696B0E5BDA2E58ABFE4B88BE79A84E696B0E883BDE6BA90E794B5E7AB99E8BF90E890A5E380823C2F703E3C703E266E6273703B266E6273703B266E6273703B266E6273703BE6B288E998B3E59889E8B68AE794B5E58A9BE7A791E68A80E69C89E99990E585ACE58FB8E68A80E69CAFE680BBE5B7A5E586AFE7AD96E58F97E98280E587BAE5B8ADE9A38EE794B5E59CBAE8BF90E7BBB4E58F8AE68A80E694B9E58886E8AEBAE59D9BEFBC8CE5B9B6E4BD9CE9A298E4B8BAE3808AE5A3B0E99BB7E8BEBEE7B2BEE7BB86E58C96E6B58BE9A38EE79A84E4BC98E58ABFE58F8AE585B6E59CA8E9A38EE794B5E59CBAE8BF90E8A18CE7BBB4E68AA4E4B8ADE79A84E5BA94E794A8E3808BE79A84E4B8BBE697A8E6BC94E8AEB2E380823C2F703E3C7020636C6173733D22716C2D616C69676E2D63656E746572223E3C696D67207372633D22687474703A2F2F7777772E6A6961797565706F776572746563682E636F6D2F7573657266696C65732F696D616765732F32303231303432393136353633362D34323634313330323130353033393336302E6A7067223E3C2F703E3C7020636C6173733D22716C2D616C69676E2D63656E746572223EE586AFE7AD96E4BD9CE9A298E4B8BAE3808AE5A3B0E99BB7E8BEBEE7B2BEE7BB86E58C96E6B58BE9A38EE79A84E4BC98E58ABFE58F8AE585B6E59CA8E9A38EE794B5E59CBAE8BF90E8A18CE7BBB4E68AA4E4B8ADE79A84E5BA94E794A8E3808BE79A84E4B8BBE697A8E6BC94E8AEB23C2F703E3C703E266E6273703B266E6273703B266E6273703B266E6273703BE6BC94E8AEB2E68C87E587BAEFBC8CE68F90E8B4A8E5A29EE69588E5B086E698AFE8A18CE4B89AE58F91E5B195E79A84E69CACE8B4A8E8AF89E6B182E38082E7AB9EE4BBB7E5928CE5B9B3E4BBB7E697B6E4BBA3E588B0E69DA5EFBC8CE98787E794A8E7B2BEE7BB86E58C96E6B58BE9A38EE696B9E6A188E69DA5E9998DE4BD8EE68A95E8B584E5928CE8BF90E890A5E9A38EE999A9E698AFE8A18CE4B89AE79A84E5BF85E784B6E98089E68BA9E38082E59889E8B68AE794B5E58A9BE68F90E4BE9BE79A84E9AB98E7B2BEE5BAA6E6B58BE9A38EE5A3B0E99BB7E8BEBEEFBC8CE98787E794A8E79BB8E68EA7E5A3B0E998B5E58897EFBC8CE588A9E794A8E6B98DE6B581E5908EE59091E695A3E5B084E5A3B0E6B3A2E79A84E5A49AE699AEE58B92E69588E5BA94E8AEA1E7AE97E9A38EE9809FE38081E9A38EE59091EFBC8CE59CA8E4B88DE69EB6E8AEBEE6B58BE9A38EE5A194E79A84E68385E586B5E4B88BEFBC8CE58FAFE6B58BE9878F31306D2D3230306DE9AB98E5BAA6E79A84E6B094E8B1A1E4BFA1E681AFEFBC8CE585B7E69C89E4BD8EE68890E69CACE38081E9AB98E7B2BEE5BAA6E38081E5A49AE58A9FE883BDE38081E69893E983A8E7BDB2E38081E5B9BFE98082E5BA94E7AD89E789B9E782B9E38082E4BAA7E59381E58FAFE5BA94E794A8E4BA8EE587A0E4B98EE68980E69C89E59CBAE699AFEFBC8CE5B0A4E585B6E698AFE4BABAE58FA3E5AF86E99B86E38081E5BEAEE8A782E59CB0E5BDA2E5A48DE69D82E4BBA5E58F8AE4BCA0E7BB9FE6B58BE9A38EE5A194E983A8E7BDB2E59BB0E99ABEE79A84E59CB0E696B9E38082E78EB0E59CBAE6B09BE59BB4E783ADE78388EFBC8CE585ACE58FB8E68F90E4BE9BE79A84E8A18CE4B89AE8A7A3E586B3E696B9E6A188E88EB7E5BE97E4BA86E58F82E4BC9AE4BABAE59198E79A84E8AEA4E58FAFE5928CE7A7AFE69E81E79A84E8AF84E4BBB7E380823C2F703E3C7020636C6173733D22716C2D616C69676E2D63656E746572223E3C696D67207372633D22687474703A2F2F7777772E6A6961797565706F776572746563682E636F6D2F7573657266696C65732F696D616765732F32303231303432393136353635372D33333233313439333530343731373934382E6A7067223E3C2F703E3C7020636C6173733D22716C2D616C69676E2D63656E746572223E32303231E5B9B4E7ACACE4BA94E5B18AE696B0E883BDE6BA90E794B5E7AB99E8BF90E890A5E58F8AE5908EE69C8DE58AA1E7A094E8AEA8E4BC9AE78EB0E59CBA3C2F703E3C703E3C62723E3C2F703E, '0', 'admin', '2021-07-30 15:27:24', '', null, null); -- ---------------------------- -- Table structure for 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) 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 '操作人员', `unit_name` varchar(50) DEFAULT '' COMMENT '组织单元名称', `oper_url` varchar(255) DEFAULT '' COMMENT '请求URL', `oper_ip` varchar(50) 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='操作日志记录'; -- ---------------------------- -- Records of sys_oper_log -- ---------------------------- -- ---------------------------- -- Table structure for 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) 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='岗位信息表'; -- ---------------------------- -- Records of sys_post -- ---------------------------- INSERT INTO `sys_post` VALUES ('1', 'ceo', '董事长', '1', '0', 'admin', '2020-12-07 16:06:27', '', null, ''); INSERT INTO `sys_post` VALUES ('2', 'se', '项目经理', '2', '0', 'admin', '2020-12-07 16:06:27', '', null, ''); INSERT INTO `sys_post` VALUES ('3', 'hr', '人力资源', '3', '0', 'admin', '2020-12-07 16:06:27', '', null, ''); INSERT INTO `sys_post` VALUES ('4', 'user', '普通员工', '4', '0', 'admin', '2020-12-07 16:06:27', '', null, ''); -- ---------------------------- -- Table structure for 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) 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 '菜单树选择项是否关联显示', `unit_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=4 DEFAULT CHARSET=utf8mb4 COMMENT='角色信息表'; -- ---------------------------- -- Records of sys_role -- ---------------------------- INSERT INTO `sys_role` VALUES ('1', '超级管理员', 'admin', '1', '1', '1', '1', '0', '0', 'admin', '2020-12-07 16:06:27', '', null, '超级管理员'); INSERT INTO `sys_role` VALUES ('2', '普通角色', 'common', '2', '1', '1', '1', '0', '0', 'admin', '2020-12-07 16:06:27', '', '2020-12-10 14:25:06', '普通角色'); INSERT INTO `sys_role` VALUES ('3', '场站角色', 'station', '9', '4', '1', '1', '0', '2', 'admin', '2020-12-23 14:09:54', 'admin', '2020-12-28 17:01:21', '123'); -- ---------------------------- -- Table structure for 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 COMMENT='角色和菜单关联表'; -- ---------------------------- -- Records of sys_role_menu -- ---------------------------- 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'); -- ---------------------------- -- Table structure for sys_role_unit -- ---------------------------- DROP TABLE IF EXISTS `sys_role_unit`; CREATE TABLE `sys_role_unit` ( `role_id` bigint(20) NOT NULL COMMENT '角色ID', `unit_id` bigint(20) NOT NULL COMMENT '组织单元ID', PRIMARY KEY (`role_id`,`unit_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='角色和组织单元关联表'; -- ---------------------------- -- Records of sys_role_unit -- ---------------------------- -- ---------------------------- -- Table structure for sys_unit -- ---------------------------- DROP TABLE IF EXISTS `sys_unit`; CREATE TABLE `sys_unit` ( `unit_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '组织单元id', `unit_no` varchar(32) DEFAULT NULL COMMENT '组织单元编号', `parent_id` bigint(20) DEFAULT '0' COMMENT '父组织单元id', `ancestors` varchar(50) DEFAULT '' COMMENT '祖级列表', `unit_name` varchar(30) DEFAULT '' COMMENT '组织单元名称', `unit_category` 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 '更新时间', `remark` varchar(500) DEFAULT NULL COMMENT '备注', PRIMARY KEY (`unit_id`) ) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8mb4 COMMENT='组织单元表'; -- ---------------------------- -- Records of sys_unit -- ---------------------------- INSERT INTO `sys_unit` VALUES ('100', 'JIAYUE', '0', '0', 'JIAYUEPOWER', 'default', '0', 'admin', '02489633337', 'jiayue@jiayuepowertech.com', '0', '0', 'admin', '2020-12-24 14:18:03', 'system', '2021-05-19 14:17:17', ''); -- ---------------------------- -- Table structure for sys_user -- ---------------------------- DROP TABLE IF EXISTS `sys_user`; CREATE TABLE `sys_user` ( `user_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户ID', `unit_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(50) 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=2 DEFAULT CHARSET=utf8mb4 COMMENT='用户信息表'; -- ---------------------------- -- Records of sys_user -- ---------------------------- INSERT INTO `sys_user` VALUES ('1', '100', 'admin', '系统管理员', '00', 'syjy@jiayuepowertech.com', '15888888888', '0', '', '$2a$10$PSC3hXU/vV0SSB1KOb1cX.iUaJVhCn6m1pu4.GmX3LbfjcTAdg4OS', '0', '0', '127.0.0.1', '2022-05-10 17:27:43', 'admin', '2020-12-07 16:06:27', '', '2022-05-10 19:57:57', '超级管理员'); -- ---------------------------- -- Table structure for 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 COMMENT='用户与岗位关联表'; -- ---------------------------- -- Records of sys_user_post -- ---------------------------- INSERT INTO `sys_user_post` VALUES ('1', '1'); INSERT INTO `sys_user_post` VALUES ('2', '2'); INSERT INTO `sys_user_post` VALUES ('3', '2'); -- ---------------------------- -- Table structure for 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 COMMENT='用户和角色关联表'; -- ---------------------------- -- Records of sys_user_role -- ---------------------------- INSERT INTO `sys_user_role` VALUES ('1', '1'); INSERT INTO `sys_user_role` VALUES ('2', '2');