mec-cloud_-intelligent-manufacturing_crm/sql/ry-vue_2023-06-14.sql

# ************************************************************
# Sequel Pro SQL dump
# Version 4541
#
# http://www.sequelpro.com/
# https://github.com/sequelpro/sequelpro
#
# Host: 127.0.0.1 (MySQL 5.7.42)
# Database: ry-vue
# Generation Time: 2023-06-13 23:07:13 +0000
# ************************************************************


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


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

LOCK TABLES `gen_table` WRITE;
/*!40000 ALTER TABLE `gen_table` DISABLE KEYS */;

INSERT INTO `gen_table` (`table_id`, `table_name`, `table_comment`, `sub_table_name`, `sub_table_fk_name`, `class_name`, `tpl_category`, `package_name`, `module_name`, `business_name`, `function_name`, `function_author`, `gen_type`, `gen_path`, `options`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES
	(1,X'7379735F74656E616E74',X'E7A79FE688B7E4BFA1E681AFE8A1A8',NULL,NULL,X'53797354656E616E74',X'63727564',X'636F6D2E72756F79692E73797374656D',X'73797374656D',X'74656E616E74',X'E7A79FE688B7E4BFA1E681AF',X'72756F7969',X'30',X'2F',X'7B22706172656E744D656E754964223A317D',X'61646D696E','2023-06-03 08:26:39',X'','2023-06-03 08:30:11',NULL);

/*!40000 ALTER TABLE `gen_table` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table gen_table_column
# ------------------------------------------------------------

DROP TABLE IF EXISTS `gen_table_column`;

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

LOCK TABLES `gen_table_column` WRITE;
/*!40000 ALTER TABLE `gen_table_column` DISABLE KEYS */;

INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`)
VALUES
	(1,X'31',X'74656E616E745F6964',X'E7A79FE688B74944',X'626967696E7428323029',X'4C6F6E67',X'74656E616E744964',X'31',X'31',NULL,X'31',NULL,NULL,NULL,X'4551',X'696E707574',X'',1,X'61646D696E','2023-06-03 08:26:39',X'','2023-06-03 08:30:11'),
	(2,X'31',X'74656E616E745F6E616D65',X'E7A79FE688B7E5908DE7A7B0',X'766172636861722831303029',X'537472696E67',X'74656E616E744E616D65',X'30',X'30',X'31',X'31',X'31',X'31',X'31',X'4C494B45',X'696E707574',X'',2,X'61646D696E','2023-06-03 08:26:39',X'','2023-06-03 08:30:11'),
	(3,X'31',X'74656E616E745F636F6465',X'E7A79FE688B7E7BC96E58FB7EFBC88E585ACE58FB8E7BB9FE4B880E4BFA1E794A8E4BBA3E7A081EFBC89',X'6368617228313829',X'537472696E67',X'74656E616E74436F6465',X'30',X'30',X'31',X'31',X'31',X'31',X'31',X'4551',X'696E707574',X'',3,X'61646D696E','2023-06-03 08:26:39',X'','2023-06-03 08:30:11'),
	(4,X'31',X'6F776E6572',X'E8B49FE8B4A3E4BABA',X'7661726368617228353029',X'537472696E67',X'6F776E6572',X'30',X'30',NULL,X'31',X'31',X'31',X'31',X'4551',X'696E707574',X'',4,X'61646D696E','2023-06-03 08:26:39',X'','2023-06-03 08:30:11'),
	(5,X'31',X'636F6E746163745F696E666F',X'E88194E7B3BBE696B9E5BC8F',X'7661726368617228353029',X'537472696E67',X'636F6E74616374496E666F',X'30',X'30',NULL,X'31',X'31',X'31',X'31',X'4551',X'696E707574',X'',5,X'61646D696E','2023-06-03 08:26:39',X'','2023-06-03 08:30:11'),
	(6,X'31',X'61646472657373',X'E59CB0E59D80',X'766172636861722832303029',X'537472696E67',X'61646472657373',X'30',X'30',NULL,X'31',X'31',X'31',X'31',X'4551',X'696E707574',X'',6,X'61646D696E','2023-06-03 08:26:39',X'','2023-06-03 08:30:11'),
	(7,X'31',X'6372656174655F6279',X'E5889BE5BBBAE4BABA',X'7661726368617228363429',X'537472696E67',X'6372656174654279',X'30',X'30',X'31',X'31',NULL,NULL,NULL,X'4551',X'696E707574',X'',7,X'61646D696E','2023-06-03 08:26:39',X'','2023-06-03 08:30:11'),
	(8,X'31',X'6372656174655F74696D65',X'E5889BE5BBBAE697B6E997B4',X'6461746574696D65',X'44617465',X'63726561746554696D65',X'30',X'30',X'31',X'31',NULL,NULL,NULL,X'4551',X'6461746574696D65',X'',8,X'61646D696E','2023-06-03 08:26:39',X'','2023-06-03 08:30:11'),
	(9,X'31',X'69735F64656C',X'E698AFE590A6E588A0E999A42830EFBC9AE69CAAE588A0E999A4EFBC8C31E5B7B2E588A0E999A429',X'63686172283129',X'537472696E67',X'697344656C',X'30',X'30',X'31',X'31',X'31',X'31',X'31',X'4551',X'696E707574',X'',9,X'61646D696E','2023-06-03 08:26:39',X'','2023-06-03 08:30:11');

/*!40000 ALTER TABLE `gen_table_column` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table qrtz_blob_triggers
# ------------------------------------------------------------

DROP TABLE IF EXISTS `qrtz_blob_triggers`;

CREATE TABLE `qrtz_blob_triggers` (
  `sched_name` varchar(120) COLLATE utf8_bin NOT NULL COMMENT '调度名称',
  `trigger_name` varchar(200) COLLATE utf8_bin NOT NULL COMMENT 'qrtz_triggers表trigger_name的外键',
  `trigger_group` varchar(200) COLLATE utf8_bin NOT NULL COMMENT 'qrtz_triggers表trigger_group的外键',
  `blob_data` blob COMMENT '存放持久化Trigger对象',
  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=utf8 COLLATE=utf8_bin COMMENT='Blob类型的触发器表';



# Dump of table qrtz_calendars
# ------------------------------------------------------------

DROP TABLE IF EXISTS `qrtz_calendars`;

CREATE TABLE `qrtz_calendars` (
  `sched_name` varchar(120) COLLATE utf8_bin NOT NULL COMMENT '调度名称',
  `calendar_name` varchar(200) COLLATE utf8_bin NOT NULL COMMENT '日历名称',
  `calendar` blob NOT NULL COMMENT '存放持久化calendar对象',
  PRIMARY KEY (`sched_name`,`calendar_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='日历信息表';



# Dump of table qrtz_cron_triggers
# ------------------------------------------------------------

DROP TABLE IF EXISTS `qrtz_cron_triggers`;

CREATE TABLE `qrtz_cron_triggers` (
  `sched_name` varchar(120) COLLATE utf8_bin NOT NULL COMMENT '调度名称',
  `trigger_name` varchar(200) COLLATE utf8_bin NOT NULL COMMENT 'qrtz_triggers表trigger_name的外键',
  `trigger_group` varchar(200) COLLATE utf8_bin NOT NULL COMMENT 'qrtz_triggers表trigger_group的外键',
  `cron_expression` varchar(200) COLLATE utf8_bin NOT NULL COMMENT 'cron表达式',
  `time_zone_id` varchar(80) COLLATE utf8_bin DEFAULT NULL COMMENT '时区',
  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=utf8 COLLATE=utf8_bin COMMENT='Cron类型的触发器表';



# Dump of table qrtz_fired_triggers
# ------------------------------------------------------------

DROP TABLE IF EXISTS `qrtz_fired_triggers`;

CREATE TABLE `qrtz_fired_triggers` (
  `sched_name` varchar(120) COLLATE utf8_bin NOT NULL COMMENT '调度名称',
  `entry_id` varchar(95) COLLATE utf8_bin NOT NULL COMMENT '调度器实例id',
  `trigger_name` varchar(200) COLLATE utf8_bin NOT NULL COMMENT 'qrtz_triggers表trigger_name的外键',
  `trigger_group` varchar(200) COLLATE utf8_bin NOT NULL COMMENT 'qrtz_triggers表trigger_group的外键',
  `instance_name` varchar(200) COLLATE utf8_bin NOT NULL COMMENT '调度器实例名',
  `fired_time` bigint(13) NOT NULL COMMENT '触发的时间',
  `sched_time` bigint(13) NOT NULL COMMENT '定时器制定的时间',
  `priority` int(11) NOT NULL COMMENT '优先级',
  `state` varchar(16) COLLATE utf8_bin NOT NULL COMMENT '状态',
  `job_name` varchar(200) COLLATE utf8_bin DEFAULT NULL COMMENT '任务名称',
  `job_group` varchar(200) COLLATE utf8_bin DEFAULT NULL COMMENT '任务组名',
  `is_nonconcurrent` varchar(1) COLLATE utf8_bin DEFAULT NULL COMMENT '是否并发',
  `requests_recovery` varchar(1) COLLATE utf8_bin DEFAULT NULL COMMENT '是否接受恢复执行',
  PRIMARY KEY (`sched_name`,`entry_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='已触发的触发器表';



# Dump of table qrtz_job_details
# ------------------------------------------------------------

DROP TABLE IF EXISTS `qrtz_job_details`;

CREATE TABLE `qrtz_job_details` (
  `sched_name` varchar(120) COLLATE utf8_bin NOT NULL COMMENT '调度名称',
  `job_name` varchar(200) COLLATE utf8_bin NOT NULL COMMENT '任务名称',
  `job_group` varchar(200) COLLATE utf8_bin NOT NULL COMMENT '任务组名',
  `description` varchar(250) COLLATE utf8_bin DEFAULT NULL COMMENT '相关介绍',
  `job_class_name` varchar(250) COLLATE utf8_bin NOT NULL COMMENT '执行任务类名称',
  `is_durable` varchar(1) COLLATE utf8_bin NOT NULL COMMENT '是否持久化',
  `is_nonconcurrent` varchar(1) COLLATE utf8_bin NOT NULL COMMENT '是否并发',
  `is_update_data` varchar(1) COLLATE utf8_bin NOT NULL COMMENT '是否更新数据',
  `requests_recovery` varchar(1) COLLATE utf8_bin NOT NULL COMMENT '是否接受恢复执行',
  `job_data` blob COMMENT '存放持久化job对象',
  PRIMARY KEY (`sched_name`,`job_name`,`job_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='任务详细信息表';



# Dump of table qrtz_locks
# ------------------------------------------------------------

DROP TABLE IF EXISTS `qrtz_locks`;

CREATE TABLE `qrtz_locks` (
  `sched_name` varchar(120) COLLATE utf8_bin NOT NULL COMMENT '调度名称',
  `lock_name` varchar(40) COLLATE utf8_bin NOT NULL COMMENT '悲观锁名称',
  PRIMARY KEY (`sched_name`,`lock_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='存储的悲观锁信息表';



# Dump of table qrtz_paused_trigger_grps
# ------------------------------------------------------------

DROP TABLE IF EXISTS `qrtz_paused_trigger_grps`;

CREATE TABLE `qrtz_paused_trigger_grps` (
  `sched_name` varchar(120) COLLATE utf8_bin NOT NULL COMMENT '调度名称',
  `trigger_group` varchar(200) COLLATE utf8_bin NOT NULL COMMENT 'qrtz_triggers表trigger_group的外键',
  PRIMARY KEY (`sched_name`,`trigger_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='暂停的触发器表';



# Dump of table qrtz_scheduler_state
# ------------------------------------------------------------

DROP TABLE IF EXISTS `qrtz_scheduler_state`;

CREATE TABLE `qrtz_scheduler_state` (
  `sched_name` varchar(120) COLLATE utf8_bin NOT NULL COMMENT '调度名称',
  `instance_name` varchar(200) COLLATE utf8_bin NOT NULL COMMENT '实例名称',
  `last_checkin_time` bigint(13) NOT NULL COMMENT '上次检查时间',
  `checkin_interval` bigint(13) NOT NULL COMMENT '检查间隔时间',
  PRIMARY KEY (`sched_name`,`instance_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='调度器状态表';



# Dump of table qrtz_simple_triggers
# ------------------------------------------------------------

DROP TABLE IF EXISTS `qrtz_simple_triggers`;

CREATE TABLE `qrtz_simple_triggers` (
  `sched_name` varchar(120) COLLATE utf8_bin NOT NULL COMMENT '调度名称',
  `trigger_name` varchar(200) COLLATE utf8_bin NOT NULL COMMENT 'qrtz_triggers表trigger_name的外键',
  `trigger_group` varchar(200) COLLATE utf8_bin NOT NULL COMMENT 'qrtz_triggers表trigger_group的外键',
  `repeat_count` bigint(7) NOT NULL COMMENT '重复的次数统计',
  `repeat_interval` bigint(12) NOT NULL COMMENT '重复的间隔时间',
  `times_triggered` bigint(10) NOT NULL COMMENT '已经触发的次数',
  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=utf8 COLLATE=utf8_bin COMMENT='简单触发器的信息表';



# Dump of table qrtz_simprop_triggers
# ------------------------------------------------------------

DROP TABLE IF EXISTS `qrtz_simprop_triggers`;

CREATE TABLE `qrtz_simprop_triggers` (
  `sched_name` varchar(120) COLLATE utf8_bin NOT NULL COMMENT '调度名称',
  `trigger_name` varchar(200) COLLATE utf8_bin NOT NULL COMMENT 'qrtz_triggers表trigger_name的外键',
  `trigger_group` varchar(200) COLLATE utf8_bin NOT NULL COMMENT 'qrtz_triggers表trigger_group的外键',
  `str_prop_1` varchar(512) COLLATE utf8_bin DEFAULT NULL COMMENT 'String类型的trigger的第一个参数',
  `str_prop_2` varchar(512) COLLATE utf8_bin DEFAULT NULL COMMENT 'String类型的trigger的第二个参数',
  `str_prop_3` varchar(512) COLLATE utf8_bin DEFAULT NULL COMMENT 'String类型的trigger的第三个参数',
  `int_prop_1` int(11) DEFAULT NULL COMMENT 'int类型的trigger的第一个参数',
  `int_prop_2` int(11) DEFAULT NULL COMMENT 'int类型的trigger的第二个参数',
  `long_prop_1` bigint(20) DEFAULT NULL COMMENT 'long类型的trigger的第一个参数',
  `long_prop_2` bigint(20) DEFAULT NULL COMMENT 'long类型的trigger的第二个参数',
  `dec_prop_1` decimal(13,4) DEFAULT NULL COMMENT 'decimal类型的trigger的第一个参数',
  `dec_prop_2` decimal(13,4) DEFAULT NULL COMMENT 'decimal类型的trigger的第二个参数',
  `bool_prop_1` varchar(1) COLLATE utf8_bin DEFAULT NULL COMMENT 'Boolean类型的trigger的第一个参数',
  `bool_prop_2` varchar(1) COLLATE utf8_bin DEFAULT NULL COMMENT 'Boolean类型的trigger的第二个参数',
  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=utf8 COLLATE=utf8_bin COMMENT='同步机制的行锁表';



# Dump of table qrtz_triggers
# ------------------------------------------------------------

DROP TABLE IF EXISTS `qrtz_triggers`;

CREATE TABLE `qrtz_triggers` (
  `sched_name` varchar(120) COLLATE utf8_bin NOT NULL COMMENT '调度名称',
  `trigger_name` varchar(200) COLLATE utf8_bin NOT NULL COMMENT '触发器的名字',
  `trigger_group` varchar(200) COLLATE utf8_bin NOT NULL COMMENT '触发器所属组的名字',
  `job_name` varchar(200) COLLATE utf8_bin NOT NULL COMMENT 'qrtz_job_details表job_name的外键',
  `job_group` varchar(200) COLLATE utf8_bin NOT NULL COMMENT 'qrtz_job_details表job_group的外键',
  `description` varchar(250) COLLATE utf8_bin DEFAULT NULL COMMENT '相关介绍',
  `next_fire_time` bigint(13) DEFAULT NULL COMMENT '上一次触发时间（毫秒）',
  `prev_fire_time` bigint(13) DEFAULT NULL COMMENT '下一次触发时间（默认为-1表示不触发）',
  `priority` int(11) DEFAULT NULL COMMENT '优先级',
  `trigger_state` varchar(16) COLLATE utf8_bin NOT NULL COMMENT '触发器状态',
  `trigger_type` varchar(8) COLLATE utf8_bin NOT NULL COMMENT '触发器的类型',
  `start_time` bigint(13) NOT NULL COMMENT '开始时间',
  `end_time` bigint(13) DEFAULT NULL COMMENT '结束时间',
  `calendar_name` varchar(200) COLLATE utf8_bin DEFAULT NULL COMMENT '日程表名称',
  `misfire_instr` smallint(2) DEFAULT NULL COMMENT '补偿执行的策略',
  `job_data` blob COMMENT '存放持久化job对象',
  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=utf8 COLLATE=utf8_bin COMMENT='触发器详细信息表';



# Dump of table sys_config
# ------------------------------------------------------------

DROP TABLE IF EXISTS `sys_config`;

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

LOCK TABLES `sys_config` WRITE;
/*!40000 ALTER TABLE `sys_config` DISABLE KEYS */;

INSERT INTO `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES
	(1,X'E4B8BBE6A186E69EB6E9A1B52DE9BB98E8AEA4E79AAEE882A4E6A0B7E5BC8FE5908DE7A7B0',X'7379732E696E6465782E736B696E4E616D65',X'736B696E2D626C7565',X'59',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E8939DE889B220736B696E2D626C7565E38081E7BBBFE889B220736B696E2D677265656EE38081E7B4ABE889B220736B696E2D707572706C65E38081E7BAA2E889B220736B696E2D726564E38081E9BB84E889B220736B696E2D79656C6C6F77'),
	(2,X'E794A8E688B7E7AEA1E790862DE8B4A6E58FB7E5889DE5A78BE5AF86E7A081',X'7379732E757365722E696E697450617373776F7264',X'313233343536',X'59',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E5889DE5A78BE58C96E5AF86E7A08120313233343536'),
	(3,X'E4B8BBE6A186E69EB6E9A1B52DE4BEA7E8BEB9E6A08FE4B8BBE9A298',X'7379732E696E6465782E736964655468656D65',X'7468656D652D6461726B',X'59',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E6B7B1E889B2E4B8BBE9A2987468656D652D6461726BEFBC8CE6B585E889B2E4B8BBE9A2987468656D652D6C69676874'),
	(4,X'E8B4A6E58FB7E887AAE58AA92DE9AA8CE8AF81E7A081E5BC80E585B3',X'7379732E6163636F756E742E63617074636861456E61626C6564',X'66616C7365',X'59',X'61646D696E','2023-05-25 16:54:11',X'61646D696E','2023-05-25 18:14:44',X'E698AFE590A6E5BC80E590AFE9AA8CE8AF81E7A081E58A9FE883BDEFBC8874727565E5BC80E590AFEFBC8C66616C7365E585B3E997ADEFBC89'),
	(5,X'E8B4A6E58FB7E887AAE58AA92DE698AFE590A6E5BC80E590AFE794A8E688B7E6B3A8E5868CE58A9FE883BD',X'7379732E6163636F756E742E726567697374657255736572',X'66616C7365',X'59',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E698AFE590A6E5BC80E590AFE6B3A8E5868CE794A8E688B7E58A9FE883BDEFBC8874727565E5BC80E590AFEFBC8C66616C7365E585B3E997ADEFBC89'),
	(6,X'E794A8E688B7E799BBE5BD952DE9BB91E5908DE58D95E58897E8A1A8',X'7379732E6C6F67696E2E626C61636B49504C697374',X'',X'59',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E8AEBEE7BDAEE799BBE5BD954950E9BB91E5908DE58D95E99990E588B6EFBC8CE5A49AE4B8AAE58CB9E9858DE9A1B9E4BBA53BE58886E99A94EFBC8CE694AFE68C81E58CB9E9858DEFBC882AE9809AE9858DE38081E7BD91E6AEB5EFBC89');

/*!40000 ALTER TABLE `sys_config` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table sys_dept
# ------------------------------------------------------------

DROP TABLE IF EXISTS `sys_dept`;

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

LOCK TABLES `sys_dept` WRITE;
/*!40000 ALTER TABLE `sys_dept` DISABLE KEYS */;

INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `ancestors`, `dept_name`, `order_num`, `leader`, `phone`, `email`, `status`, `del_flag`, `create_by`, `create_time`, `update_by`, `update_time`)
VALUES
	(100,0,X'30',X'E7A791E68A80E99B86E59BA2',0,X'E88BA5E4BE9D',X'3135383838383838383838',X'72794071712E636F6D',X'30',X'30',X'61646D696E','2023-05-25 16:54:10',X'61646D696E','2023-05-25 18:13:59'),
	(101,100,X'302C313030',X'E58C97E4BAACE585ACE58FB8',1,X'E88BA5E4BE9D',X'3135383838383838383838',X'72794071712E636F6D',X'30',X'30',X'61646D696E','2023-05-25 16:54:10',X'61646D696E','2023-05-25 18:13:41'),
	(102,100,X'302C313030',X'E995BFE6B299E58886E585ACE58FB8',2,X'E88BA5E4BE9D',X'3135383838383838383838',X'72794071712E636F6D',X'30',X'32',X'61646D696E','2023-05-25 16:54:10',X'',NULL),
	(103,101,X'302C3130302C313031',X'E7A094E58F91E983A8E997A8',1,X'E88BA5E4BE9D',X'3135383838383838383838',X'72794071712E636F6D',X'30',X'30',X'61646D696E','2023-05-25 16:54:10',X'',NULL),
	(104,101,X'302C3130302C313031',X'E5B882E59CBAE983A8E997A8',2,X'E88BA5E4BE9D',X'3135383838383838383838',X'72794071712E636F6D',X'30',X'32',X'61646D696E','2023-05-25 16:54:10',X'',NULL),
	(105,101,X'302C3130302C313031',X'E6B58BE8AF95E983A8E997A8',3,X'E88BA5E4BE9D',X'3135383838383838383838',X'72794071712E636F6D',X'30',X'32',X'61646D696E','2023-05-25 16:54:10',X'',NULL),
	(106,101,X'302C3130302C313031',X'E8B4A2E58AA1E983A8E997A8',4,X'E88BA5E4BE9D',X'3135383838383838383838',X'72794071712E636F6D',X'30',X'32',X'61646D696E','2023-05-25 16:54:10',X'',NULL),
	(107,101,X'302C3130302C313031',X'E8BF90E7BBB4E983A8E997A8',5,X'E88BA5E4BE9D',X'3135383838383838383838',X'72794071712E636F6D',X'30',X'32',X'61646D696E','2023-05-25 16:54:10',X'',NULL),
	(108,102,X'302C3130302C313032',X'E5B882E59CBAE983A8E997A8',1,X'E88BA5E4BE9D',X'3135383838383838383838',X'72794071712E636F6D',X'30',X'32',X'61646D696E','2023-05-25 16:54:10',X'',NULL),
	(109,102,X'302C3130302C313032',X'E8B4A2E58AA1E983A8E997A8',2,X'E88BA5E4BE9D',X'3135383838383838383838',X'72794071712E636F6D',X'30',X'32',X'61646D696E','2023-05-25 16:54:10',X'',NULL),
	(110,103,X'302C3130302C3130312C313033',X'E5898DE7ABAF31E7BB84',1,NULL,NULL,NULL,X'30',X'30',X'687461646D696E','2023-06-10 10:11:54',X'',NULL);

/*!40000 ALTER TABLE `sys_dept` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table sys_dict_data
# ------------------------------------------------------------

DROP TABLE IF EXISTS `sys_dict_data`;

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

LOCK TABLES `sys_dict_data` WRITE;
/*!40000 ALTER TABLE `sys_dict_data` DISABLE KEYS */;

INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES
	(1,1,X'E794B7',X'30',X'7379735F757365725F736578',X'',X'',X'59',X'30',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E680A7E588ABE794B7'),
	(2,2,X'E5A5B3',X'31',X'7379735F757365725F736578',X'',X'',X'4E',X'30',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E680A7E588ABE5A5B3'),
	(3,3,X'E69CAAE79FA5',X'32',X'7379735F757365725F736578',X'',X'',X'4E',X'30',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E680A7E588ABE69CAAE79FA5'),
	(4,1,X'E698BEE7A4BA',X'30',X'7379735F73686F775F68696465',X'',X'7072696D617279',X'59',X'30',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E698BEE7A4BAE88F9CE58D95'),
	(5,2,X'E99A90E8978F',X'31',X'7379735F73686F775F68696465',X'',X'64616E676572',X'4E',X'30',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E99A90E8978FE88F9CE58D95'),
	(6,1,X'E6ADA3E5B8B8',X'30',X'7379735F6E6F726D616C5F64697361626C65',X'',X'7072696D617279',X'59',X'30',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E6ADA3E5B8B8E78AB6E68081'),
	(7,2,X'E5819CE794A8',X'31',X'7379735F6E6F726D616C5F64697361626C65',X'',X'64616E676572',X'4E',X'30',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E5819CE794A8E78AB6E68081'),
	(8,1,X'E6ADA3E5B8B8',X'30',X'7379735F6A6F625F737461747573',X'',X'7072696D617279',X'59',X'30',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E6ADA3E5B8B8E78AB6E68081'),
	(9,2,X'E69A82E5819C',X'31',X'7379735F6A6F625F737461747573',X'',X'64616E676572',X'4E',X'30',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E5819CE794A8E78AB6E68081'),
	(10,1,X'E9BB98E8AEA4',X'44454641554C54',X'7379735F6A6F625F67726F7570',X'',X'',X'59',X'30',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E9BB98E8AEA4E58886E7BB84'),
	(11,2,X'E7B3BBE7BB9F',X'53595354454D',X'7379735F6A6F625F67726F7570',X'',X'',X'4E',X'30',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E7B3BBE7BB9FE58886E7BB84'),
	(12,1,X'E698AF',X'59',X'7379735F7965735F6E6F',X'',X'7072696D617279',X'59',X'30',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E7B3BBE7BB9FE9BB98E8AEA4E698AF'),
	(13,2,X'E590A6',X'4E',X'7379735F7965735F6E6F',X'',X'64616E676572',X'4E',X'30',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E7B3BBE7BB9FE9BB98E8AEA4E590A6'),
	(14,1,X'E9809AE79FA5',X'31',X'7379735F6E6F746963655F74797065',X'',X'7761726E696E67',X'59',X'30',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E9809AE79FA5'),
	(15,2,X'E585ACE5918A',X'32',X'7379735F6E6F746963655F74797065',X'',X'73756363657373',X'4E',X'30',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E585ACE5918A'),
	(16,1,X'E6ADA3E5B8B8',X'30',X'7379735F6E6F746963655F737461747573',X'',X'7072696D617279',X'59',X'30',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E6ADA3E5B8B8E78AB6E68081'),
	(17,2,X'E585B3E997AD',X'31',X'7379735F6E6F746963655F737461747573',X'',X'64616E676572',X'4E',X'30',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E585B3E997ADE78AB6E68081'),
	(18,99,X'E585B6E4BB96',X'30',X'7379735F6F7065725F74797065',X'',X'696E666F',X'4E',X'30',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E585B6E4BB96E6938DE4BD9C'),
	(19,1,X'E696B0E5A29E',X'31',X'7379735F6F7065725F74797065',X'',X'696E666F',X'4E',X'30',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E696B0E5A29EE6938DE4BD9C'),
	(20,2,X'E4BFAEE694B9',X'32',X'7379735F6F7065725F74797065',X'',X'696E666F',X'4E',X'30',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E4BFAEE694B9E6938DE4BD9C'),
	(21,3,X'E588A0E999A4',X'33',X'7379735F6F7065725F74797065',X'',X'64616E676572',X'4E',X'30',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E588A0E999A4E6938DE4BD9C'),
	(22,4,X'E68E88E69D83',X'34',X'7379735F6F7065725F74797065',X'',X'7072696D617279',X'4E',X'30',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E68E88E69D83E6938DE4BD9C'),
	(23,5,X'E5AFBCE587BA',X'35',X'7379735F6F7065725F74797065',X'',X'7761726E696E67',X'4E',X'30',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E5AFBCE587BAE6938DE4BD9C'),
	(24,6,X'E5AFBCE585A5',X'36',X'7379735F6F7065725F74797065',X'',X'7761726E696E67',X'4E',X'30',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E5AFBCE585A5E6938DE4BD9C'),
	(25,7,X'E5BCBAE98080',X'37',X'7379735F6F7065725F74797065',X'',X'64616E676572',X'4E',X'30',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E5BCBAE98080E6938DE4BD9C'),
	(26,8,X'E7949FE68890E4BBA3E7A081',X'38',X'7379735F6F7065725F74797065',X'',X'7761726E696E67',X'4E',X'30',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E7949FE68890E6938DE4BD9C'),
	(27,9,X'E6B885E7A9BAE695B0E68DAE',X'39',X'7379735F6F7065725F74797065',X'',X'64616E676572',X'4E',X'30',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E6B885E7A9BAE6938DE4BD9C'),
	(28,1,X'E68890E58A9F',X'30',X'7379735F636F6D6D6F6E5F737461747573',X'',X'7072696D617279',X'4E',X'30',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E6ADA3E5B8B8E78AB6E68081'),
	(29,2,X'E5A4B1E8B4A5',X'31',X'7379735F636F6D6D6F6E5F737461747573',X'',X'64616E676572',X'4E',X'30',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E5819CE794A8E78AB6E68081');

/*!40000 ALTER TABLE `sys_dict_data` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table sys_dict_type
# ------------------------------------------------------------

DROP TABLE IF EXISTS `sys_dict_type`;

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

LOCK TABLES `sys_dict_type` WRITE;
/*!40000 ALTER TABLE `sys_dict_type` DISABLE KEYS */;

INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES
	(1,X'E794A8E688B7E680A7E588AB',X'7379735F757365725F736578',X'30',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E794A8E688B7E680A7E588ABE58897E8A1A8'),
	(2,X'E88F9CE58D95E78AB6E68081',X'7379735F73686F775F68696465',X'30',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E88F9CE58D95E78AB6E68081E58897E8A1A8'),
	(3,X'E7B3BBE7BB9FE5BC80E585B3',X'7379735F6E6F726D616C5F64697361626C65',X'30',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E7B3BBE7BB9FE5BC80E585B3E58897E8A1A8'),
	(4,X'E4BBBBE58AA1E78AB6E68081',X'7379735F6A6F625F737461747573',X'30',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E4BBBBE58AA1E78AB6E68081E58897E8A1A8'),
	(5,X'E4BBBBE58AA1E58886E7BB84',X'7379735F6A6F625F67726F7570',X'30',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E4BBBBE58AA1E58886E7BB84E58897E8A1A8'),
	(6,X'E7B3BBE7BB9FE698AFE590A6',X'7379735F7965735F6E6F',X'30',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E7B3BBE7BB9FE698AFE590A6E58897E8A1A8'),
	(7,X'E9809AE79FA5E7B1BBE59E8B',X'7379735F6E6F746963655F74797065',X'30',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E9809AE79FA5E7B1BBE59E8BE58897E8A1A8'),
	(8,X'E9809AE79FA5E78AB6E68081',X'7379735F6E6F746963655F737461747573',X'30',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E9809AE79FA5E78AB6E68081E58897E8A1A8'),
	(9,X'E6938DE4BD9CE7B1BBE59E8B',X'7379735F6F7065725F74797065',X'30',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E6938DE4BD9CE7B1BBE59E8BE58897E8A1A8'),
	(10,X'E7B3BBE7BB9FE78AB6E68081',X'7379735F636F6D6D6F6E5F737461747573',X'30',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E799BBE5BD95E78AB6E68081E58897E8A1A8');

/*!40000 ALTER TABLE `sys_dict_type` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table sys_job
# ------------------------------------------------------------

DROP TABLE IF EXISTS `sys_job`;

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

LOCK TABLES `sys_job` WRITE;
/*!40000 ALTER TABLE `sys_job` DISABLE KEYS */;

INSERT INTO `sys_job` (`job_id`, `job_name`, `job_group`, `invoke_target`, `cron_expression`, `misfire_policy`, `concurrent`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES
	(1,X'E7B3BBE7BB9FE9BB98E8AEA4EFBC88E697A0E58F82EFBC89',X'44454641554C54',X'72795461736B2E72794E6F506172616D73',X'302F3130202A202A202A202A203F',X'33',X'31',X'31',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X''),
	(2,X'E7B3BBE7BB9FE9BB98E8AEA4EFBC88E69C89E58F82EFBC89',X'44454641554C54',X'72795461736B2E7279506172616D73282772792729',X'302F3135202A202A202A202A203F',X'33',X'31',X'31',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X''),
	(3,X'E7B3BBE7BB9FE9BB98E8AEA4EFBC88E5A49AE58F82EFBC89',X'44454641554C54',X'72795461736B2E72794D756C7469706C65506172616D7328277279272C20747275652C20323030304C2C203331362E3530442C2031303029',X'302F3230202A202A202A202A203F',X'33',X'31',X'31',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'');

/*!40000 ALTER TABLE `sys_job` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table sys_job_log
# ------------------------------------------------------------

DROP TABLE IF EXISTS `sys_job_log`;

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



# Dump of table 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) COLLATE utf8_bin DEFAULT '' COMMENT '用户账号',
  `ipaddr` varchar(128) COLLATE utf8_bin DEFAULT '' COMMENT '登录IP地址',
  `login_location` varchar(255) COLLATE utf8_bin DEFAULT '' COMMENT '登录地点',
  `browser` varchar(50) COLLATE utf8_bin DEFAULT '' COMMENT '浏览器类型',
  `os` varchar(50) COLLATE utf8_bin DEFAULT '' COMMENT '操作系统',
  `status` char(1) COLLATE utf8_bin DEFAULT '0' COMMENT '登录状态（0成功 1失败）',
  `msg` varchar(255) COLLATE utf8_bin DEFAULT '' COMMENT '提示消息',
  `login_time` datetime DEFAULT NULL COMMENT '访问时间',
  PRIMARY KEY (`info_id`),
  KEY `idx_sys_logininfor_s` (`status`),
  KEY `idx_sys_logininfor_lt` (`login_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='系统访问记录';

LOCK TABLES `sys_logininfor` WRITE;
/*!40000 ALTER TABLE `sys_logininfor` DISABLE KEYS */;

INSERT INTO `sys_logininfor` (`info_id`, `user_name`, `ipaddr`, `login_location`, `browser`, `os`, `status`, `msg`, `login_time`)
VALUES
	(100,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'57696E646F7773203130',X'30',X'E799BBE5BD95E68890E58A9F','2023-05-25 16:57:56'),
	(101,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'57696E646F7773203130',X'30',X'E799BBE5BD95E68890E58A9F','2023-05-25 18:02:29'),
	(102,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'57696E646F7773203130',X'30',X'E98080E587BAE68890E58A9F','2023-05-25 18:15:02'),
	(103,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'57696E646F7773203130',X'30',X'E799BBE5BD95E68890E58A9F','2023-05-25 18:15:04'),
	(104,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-03 07:12:22'),
	(105,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-03 08:22:11'),
	(106,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'31',X'E794A8E688B7E4B88DE5AD98E59CA82FE5AF86E7A081E99499E8AFAF','2023-06-10 01:48:44'),
	(107,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'31',X'E5AF86E7A081E8BE93E585A5E99499E8AFAF31E6ACA1','2023-06-10 01:48:44'),
	(108,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'31',X'E794A8E688B7E4B88DE5AD98E59CA82FE5AF86E7A081E99499E8AFAF','2023-06-10 01:48:47'),
	(109,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'31',X'E5AF86E7A081E8BE93E585A5E99499E8AFAF32E6ACA1','2023-06-10 01:48:47'),
	(110,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'31',X'E794A8E688B7E4B88DE5AD98E59CA82FE5AF86E7A081E99499E8AFAF','2023-06-10 01:48:56'),
	(111,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'31',X'E5AF86E7A081E8BE93E585A5E99499E8AFAF33E6ACA1','2023-06-10 01:48:56'),
	(112,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'31',X'E794A8E688B7E4B88DE5AD98E59CA82FE5AF86E7A081E99499E8AFAF','2023-06-10 01:49:26'),
	(113,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'31',X'E5AF86E7A081E8BE93E585A5E99499E8AFAF34E6ACA1','2023-06-10 01:49:26'),
	(114,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-10 01:51:09'),
	(115,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-10 03:39:27'),
	(116,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-10 04:31:57'),
	(117,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E98080E587BAE68890E58A9F','2023-06-10 04:57:46'),
	(118,X'687461646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-10 04:58:02'),
	(119,X'687461646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E98080E587BAE68890E58A9F','2023-06-10 04:58:20'),
	(120,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-10 04:58:30'),
	(121,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E98080E587BAE68890E58A9F','2023-06-10 04:59:26'),
	(122,X'687461646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-10 04:59:38'),
	(123,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-10 07:02:36'),
	(124,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E98080E587BAE68890E58A9F','2023-06-10 07:20:52'),
	(125,X'687461646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-10 07:20:58'),
	(126,X'687461646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E98080E587BAE68890E58A9F','2023-06-10 07:31:43'),
	(127,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-10 07:33:38'),
	(128,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E98080E587BAE68890E58A9F','2023-06-10 07:42:49'),
	(129,X'687461646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-10 07:43:03'),
	(130,X'687461646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E98080E587BAE68890E58A9F','2023-06-10 07:44:35'),
	(131,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-10 07:44:39'),
	(132,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-10 08:34:42'),
	(133,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E98080E587BAE68890E58A9F','2023-06-10 08:43:23'),
	(134,X'687461646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-10 08:43:29'),
	(135,X'687461646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E98080E587BAE68890E58A9F','2023-06-10 08:48:15'),
	(136,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-10 08:48:22'),
	(137,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E98080E587BAE68890E58A9F','2023-06-10 08:56:22'),
	(138,X'687461646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-10 08:56:29'),
	(139,X'687461646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E98080E587BAE68890E58A9F','2023-06-10 08:56:40'),
	(140,X'687461646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-10 08:56:44'),
	(141,X'687461646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E98080E587BAE68890E58A9F','2023-06-10 08:56:50'),
	(142,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-10 08:56:54'),
	(143,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E98080E587BAE68890E58A9F','2023-06-10 08:57:48'),
	(144,X'687461646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-10 08:57:54'),
	(145,X'687461646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E98080E587BAE68890E58A9F','2023-06-10 08:58:10'),
	(146,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-10 08:58:15'),
	(147,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E98080E587BAE68890E58A9F','2023-06-10 08:58:48'),
	(148,X'687461646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-10 08:58:53'),
	(149,X'687461646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E98080E587BAE68890E58A9F','2023-06-10 09:03:54'),
	(150,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-10 09:04:01'),
	(151,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E98080E587BAE68890E58A9F','2023-06-10 09:04:23'),
	(152,X'687461646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-10 09:04:29'),
	(153,X'687461646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E98080E587BAE68890E58A9F','2023-06-10 09:05:13'),
	(154,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-10 09:05:17'),
	(155,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E98080E587BAE68890E58A9F','2023-06-10 09:24:56'),
	(156,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-10 09:25:08'),
	(157,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E98080E587BAE68890E58A9F','2023-06-10 09:26:54'),
	(158,X'687461646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-10 09:28:54'),
	(159,X'687461646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E98080E587BAE68890E58A9F','2023-06-10 09:32:59'),
	(160,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-10 09:33:03'),
	(161,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E98080E587BAE68890E58A9F','2023-06-10 09:34:39'),
	(162,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-10 09:34:44'),
	(163,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E98080E587BAE68890E58A9F','2023-06-10 09:36:08'),
	(164,X'687461646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-10 09:36:13'),
	(165,X'687461646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-10 10:10:43'),
	(166,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-10 13:58:08'),
	(167,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-11 05:25:58'),
	(168,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-11 07:34:28'),
	(169,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-11 08:28:26'),
	(170,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E98080E587BAE68890E58A9F','2023-06-11 09:05:28'),
	(171,X'7A68303161646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'31',X'E5AF86E7A081E8BE93E585A5E99499E8AFAF31E6ACA1','2023-06-11 09:05:37'),
	(172,X'7A68303161646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'31',X'E794A8E688B7E4B88DE5AD98E59CA82FE5AF86E7A081E99499E8AFAF','2023-06-11 09:05:37'),
	(173,X'7A68303161646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-11 09:05:42'),
	(174,X'7A68303161646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E98080E587BAE68890E58A9F','2023-06-11 09:05:48'),
	(175,X'7A68303261646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-11 09:06:09'),
	(176,X'7A68303261646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E98080E587BAE68890E58A9F','2023-06-11 09:06:16'),
	(177,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-11 09:06:22'),
	(178,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-12 15:01:36'),
	(179,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-12 16:11:11'),
	(180,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-13 14:49:32'),
	(181,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E98080E587BAE68890E58A9F','2023-06-13 15:18:10'),
	(182,X'7A68303161646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-13 15:18:16'),
	(183,X'7A68303161646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E98080E587BAE68890E58A9F','2023-06-13 15:20:48'),
	(184,X'7A68303161646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-13 15:20:54'),
	(185,X'7A68303161646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E98080E587BAE68890E58A9F','2023-06-13 15:22:22'),
	(186,X'7A68303161646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-13 15:23:44'),
	(187,X'7A68303161646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E98080E587BAE68890E58A9F','2023-06-13 15:37:19'),
	(188,X'7A68303161646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-13 15:37:26'),
	(189,X'7A68303161646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E98080E587BAE68890E58A9F','2023-06-13 16:04:31'),
	(190,X'7A68303161646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-13 16:04:38'),
	(191,X'7A68303161646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E98080E587BAE68890E58A9F','2023-06-13 16:07:27'),
	(192,X'7A68303161646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-13 16:07:38'),
	(193,X'7A68303161646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E98080E587BAE68890E58A9F','2023-06-13 16:13:16'),
	(194,X'7A68303161646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-13 16:16:00'),
	(195,X'7A68303161646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-13 16:16:14'),
	(196,X'7A68303161646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E98080E587BAE68890E58A9F','2023-06-13 16:22:43'),
	(197,X'7A68303161646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-13 16:22:55');

/*!40000 ALTER TABLE `sys_logininfor` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table sys_menu
# ------------------------------------------------------------

DROP TABLE IF EXISTS `sys_menu`;

CREATE TABLE `sys_menu` (
  `menu_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
  `menu_name` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '菜单名称',
  `parent_id` bigint(20) DEFAULT '0' COMMENT '父菜单ID',
  `order_num` int(4) DEFAULT '0' COMMENT '显示顺序',
  `path` varchar(200) COLLATE utf8_bin DEFAULT '' COMMENT '路由地址',
  `component` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '组件路径',
  `query` varchar(255) COLLATE utf8_bin 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) COLLATE utf8_bin DEFAULT '' COMMENT '菜单类型（M目录 C菜单 F按钮）',
  `visible` char(1) COLLATE utf8_bin DEFAULT '0' COMMENT '菜单状态（0显示 1隐藏）',
  `status` char(1) COLLATE utf8_bin DEFAULT '0' COMMENT '菜单状态（0正常 1停用）',
  `perms` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '权限标识',
  `icon` varchar(100) COLLATE utf8_bin DEFAULT '#' COMMENT '菜单图标',
  `create_by` varchar(64) COLLATE utf8_bin DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) COLLATE utf8_bin DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) COLLATE utf8_bin DEFAULT '' COMMENT '备注',
  PRIMARY KEY (`menu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='菜单权限表';

LOCK TABLES `sys_menu` WRITE;
/*!40000 ALTER TABLE `sys_menu` DISABLE KEYS */;

INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES
	(1,X'E7B3BBE7BB9FE7AEA1E79086',0,1,X'73797374656D',NULL,X'',1,0,X'4D',X'30',X'30',X'',X'73797374656D',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X'E7B3BBE7BB9FE7AEA1E79086E79BAEE5BD95'),
	(2,X'E7B3BBE7BB9FE79B91E68EA7',0,2,X'6D6F6E69746F72',NULL,X'',1,0,X'4D',X'30',X'30',X'',X'6D6F6E69746F72',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X'E7B3BBE7BB9FE79B91E68EA7E79BAEE5BD95'),
	(3,X'E7B3BBE7BB9FE5B7A5E585B7',0,3,X'746F6F6C',NULL,X'',1,0,X'4D',X'30',X'30',X'',X'746F6F6C',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X'E7B3BBE7BB9FE5B7A5E585B7E79BAEE5BD95'),
	(4,X'E88BA5E4BE9DE5AE98E7BD91',0,4,X'687474703A2F2F72756F79692E766970',NULL,X'',0,0,X'4D',X'30',X'30',X'',X'6775696465',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X'E88BA5E4BE9DE5AE98E7BD91E59CB0E59D80'),
	(100,X'E794A8E688B7E7AEA1E79086',1,1,X'75736572',X'73797374656D2F757365722F696E646578',X'',1,0,X'43',X'30',X'30',X'73797374656D3A757365723A6C697374',X'75736572',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X'E794A8E688B7E7AEA1E79086E88F9CE58D95'),
	(101,X'E8A792E889B2E7AEA1E79086',1,2,X'726F6C65',X'73797374656D2F726F6C652F696E646578',X'',1,0,X'43',X'30',X'30',X'73797374656D3A726F6C653A6C697374',X'70656F706C6573',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X'E8A792E889B2E7AEA1E79086E88F9CE58D95'),
	(102,X'E88F9CE58D95E7AEA1E79086',1,3,X'6D656E75',X'73797374656D2F6D656E752F696E646578',X'',1,0,X'43',X'30',X'30',X'73797374656D3A6D656E753A6C697374',X'747265652D7461626C65',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X'E88F9CE58D95E7AEA1E79086E88F9CE58D95'),
	(103,X'E983A8E997A8E7AEA1E79086',1,4,X'64657074',X'73797374656D2F646570742F696E646578',X'',1,0,X'43',X'30',X'30',X'73797374656D3A646570743A6C697374',X'74726565',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X'E983A8E997A8E7AEA1E79086E88F9CE58D95'),
	(104,X'E5B297E4BD8DE7AEA1E79086',1,5,X'706F7374',X'73797374656D2F706F73742F696E646578',X'',1,0,X'43',X'30',X'30',X'73797374656D3A706F73743A6C697374',X'706F7374',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X'E5B297E4BD8DE7AEA1E79086E88F9CE58D95'),
	(105,X'E5AD97E585B8E7AEA1E79086',1,6,X'64696374',X'73797374656D2F646963742F696E646578',X'',1,0,X'43',X'30',X'30',X'73797374656D3A646963743A6C697374',X'64696374',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X'E5AD97E585B8E7AEA1E79086E88F9CE58D95'),
	(106,X'E58F82E695B0E8AEBEE7BDAE',1,7,X'636F6E666967',X'73797374656D2F636F6E6669672F696E646578',X'',1,0,X'43',X'30',X'30',X'73797374656D3A636F6E6669673A6C697374',X'65646974',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X'E58F82E695B0E8AEBEE7BDAEE88F9CE58D95'),
	(107,X'E9809AE79FA5E585ACE5918A',1,8,X'6E6F74696365',X'73797374656D2F6E6F746963652F696E646578',X'',1,0,X'43',X'30',X'30',X'73797374656D3A6E6F746963653A6C697374',X'6D657373616765',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X'E9809AE79FA5E585ACE5918AE88F9CE58D95'),
	(108,X'E697A5E5BF97E7AEA1E79086',1,9,X'6C6F67',X'',X'',1,0,X'4D',X'30',X'30',X'',X'6C6F67',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X'E697A5E5BF97E7AEA1E79086E88F9CE58D95'),
	(109,X'E59CA8E7BABFE794A8E688B7',2,1,X'6F6E6C696E65',X'6D6F6E69746F722F6F6E6C696E652F696E646578',X'',1,0,X'43',X'30',X'30',X'6D6F6E69746F723A6F6E6C696E653A6C697374',X'6F6E6C696E65',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X'E59CA8E7BABFE794A8E688B7E88F9CE58D95'),
	(110,X'E5AE9AE697B6E4BBBBE58AA1',2,2,X'6A6F62',X'6D6F6E69746F722F6A6F622F696E646578',X'',1,0,X'43',X'30',X'30',X'6D6F6E69746F723A6A6F623A6C697374',X'6A6F62',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X'E5AE9AE697B6E4BBBBE58AA1E88F9CE58D95'),
	(111,X'E695B0E68DAEE79B91E68EA7',2,3,X'6472756964',X'6D6F6E69746F722F64727569642F696E646578',X'',1,0,X'43',X'30',X'30',X'6D6F6E69746F723A64727569643A6C697374',X'6472756964',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X'E695B0E68DAEE79B91E68EA7E88F9CE58D95'),
	(112,X'E69C8DE58AA1E79B91E68EA7',2,4,X'736572766572',X'6D6F6E69746F722F7365727665722F696E646578',X'',1,0,X'43',X'30',X'30',X'6D6F6E69746F723A7365727665723A6C697374',X'736572766572',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X'E69C8DE58AA1E79B91E68EA7E88F9CE58D95'),
	(113,X'E7BC93E5AD98E79B91E68EA7',2,5,X'6361636865',X'6D6F6E69746F722F63616368652F696E646578',X'',1,0,X'43',X'30',X'30',X'6D6F6E69746F723A63616368653A6C697374',X'7265646973',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X'E7BC93E5AD98E79B91E68EA7E88F9CE58D95'),
	(114,X'E7BC93E5AD98E58897E8A1A8',2,6,X'63616368654C697374',X'6D6F6E69746F722F63616368652F6C697374',X'',1,0,X'43',X'30',X'30',X'6D6F6E69746F723A63616368653A6C697374',X'72656469732D6C697374',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X'E7BC93E5AD98E58897E8A1A8E88F9CE58D95'),
	(115,X'E8A1A8E58D95E69E84E5BBBA',3,1,X'6275696C64',X'746F6F6C2F6275696C642F696E646578',X'',1,0,X'43',X'30',X'30',X'746F6F6C3A6275696C643A6C697374',X'6275696C64',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X'E8A1A8E58D95E69E84E5BBBAE88F9CE58D95'),
	(116,X'E4BBA3E7A081E7949FE68890',3,2,X'67656E',X'746F6F6C2F67656E2F696E646578',X'',1,0,X'43',X'30',X'30',X'746F6F6C3A67656E3A6C697374',X'636F6465',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X'E4BBA3E7A081E7949FE68890E88F9CE58D95'),
	(117,X'E7B3BBE7BB9FE68EA5E58FA3',3,3,X'73776167676572',X'746F6F6C2F737761676765722F696E646578',X'',1,0,X'43',X'30',X'30',X'746F6F6C3A737761676765723A6C697374',X'73776167676572',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X'E7B3BBE7BB9FE68EA5E58FA3E88F9CE58D95'),
	(500,X'E6938DE4BD9CE697A5E5BF97',108,1,X'6F7065726C6F67',X'6D6F6E69746F722F6F7065726C6F672F696E646578',X'',1,0,X'43',X'30',X'30',X'6D6F6E69746F723A6F7065726C6F673A6C697374',X'666F726D',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X'E6938DE4BD9CE697A5E5BF97E88F9CE58D95'),
	(501,X'E799BBE5BD95E697A5E5BF97',108,2,X'6C6F67696E696E666F72',X'6D6F6E69746F722F6C6F67696E696E666F722F696E646578',X'',1,0,X'43',X'30',X'30',X'6D6F6E69746F723A6C6F67696E696E666F723A6C697374',X'6C6F67696E696E666F72',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X'E799BBE5BD95E697A5E5BF97E88F9CE58D95'),
	(1000,X'E794A8E688B7E69FA5E8AFA2',100,1,X'',X'',X'',1,0,X'46',X'30',X'30',X'73797374656D3A757365723A7175657279',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1001,X'E794A8E688B7E696B0E5A29E',100,2,X'',X'',X'',1,0,X'46',X'30',X'30',X'73797374656D3A757365723A616464',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1002,X'E794A8E688B7E4BFAEE694B9',100,3,X'',X'',X'',1,0,X'46',X'30',X'30',X'73797374656D3A757365723A65646974',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1003,X'E794A8E688B7E588A0E999A4',100,4,X'',X'',X'',1,0,X'46',X'30',X'30',X'73797374656D3A757365723A72656D6F7665',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1004,X'E794A8E688B7E5AFBCE587BA',100,5,X'',X'',X'',1,0,X'46',X'30',X'30',X'73797374656D3A757365723A6578706F7274',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1005,X'E794A8E688B7E5AFBCE585A5',100,6,X'',X'',X'',1,0,X'46',X'30',X'30',X'73797374656D3A757365723A696D706F7274',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1006,X'E9878DE7BDAEE5AF86E7A081',100,7,X'',X'',X'',1,0,X'46',X'30',X'30',X'73797374656D3A757365723A7265736574507764',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1007,X'E8A792E889B2E69FA5E8AFA2',101,1,X'',X'',X'',1,0,X'46',X'30',X'30',X'73797374656D3A726F6C653A7175657279',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1008,X'E8A792E889B2E696B0E5A29E',101,2,X'',X'',X'',1,0,X'46',X'30',X'30',X'73797374656D3A726F6C653A616464',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1009,X'E8A792E889B2E4BFAEE694B9',101,3,X'',X'',X'',1,0,X'46',X'30',X'30',X'73797374656D3A726F6C653A65646974',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1010,X'E8A792E889B2E588A0E999A4',101,4,X'',X'',X'',1,0,X'46',X'30',X'30',X'73797374656D3A726F6C653A72656D6F7665',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1011,X'E8A792E889B2E5AFBCE587BA',101,5,X'',X'',X'',1,0,X'46',X'30',X'30',X'73797374656D3A726F6C653A6578706F7274',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1012,X'E88F9CE58D95E69FA5E8AFA2',102,1,X'',X'',X'',1,0,X'46',X'30',X'30',X'73797374656D3A6D656E753A7175657279',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1013,X'E88F9CE58D95E696B0E5A29E',102,2,X'',X'',X'',1,0,X'46',X'30',X'30',X'73797374656D3A6D656E753A616464',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1014,X'E88F9CE58D95E4BFAEE694B9',102,3,X'',X'',X'',1,0,X'46',X'30',X'30',X'73797374656D3A6D656E753A65646974',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1015,X'E88F9CE58D95E588A0E999A4',102,4,X'',X'',X'',1,0,X'46',X'30',X'30',X'73797374656D3A6D656E753A72656D6F7665',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1016,X'E983A8E997A8E69FA5E8AFA2',103,1,X'',X'',X'',1,0,X'46',X'30',X'30',X'73797374656D3A646570743A7175657279',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1017,X'E983A8E997A8E696B0E5A29E',103,2,X'',X'',X'',1,0,X'46',X'30',X'30',X'73797374656D3A646570743A616464',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1018,X'E983A8E997A8E4BFAEE694B9',103,3,X'',X'',X'',1,0,X'46',X'30',X'30',X'73797374656D3A646570743A65646974',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1019,X'E983A8E997A8E588A0E999A4',103,4,X'',X'',X'',1,0,X'46',X'30',X'30',X'73797374656D3A646570743A72656D6F7665',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1020,X'E5B297E4BD8DE69FA5E8AFA2',104,1,X'',X'',X'',1,0,X'46',X'30',X'30',X'73797374656D3A706F73743A7175657279',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1021,X'E5B297E4BD8DE696B0E5A29E',104,2,X'',X'',X'',1,0,X'46',X'30',X'30',X'73797374656D3A706F73743A616464',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1022,X'E5B297E4BD8DE4BFAEE694B9',104,3,X'',X'',X'',1,0,X'46',X'30',X'30',X'73797374656D3A706F73743A65646974',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1023,X'E5B297E4BD8DE588A0E999A4',104,4,X'',X'',X'',1,0,X'46',X'30',X'30',X'73797374656D3A706F73743A72656D6F7665',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1024,X'E5B297E4BD8DE5AFBCE587BA',104,5,X'',X'',X'',1,0,X'46',X'30',X'30',X'73797374656D3A706F73743A6578706F7274',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1025,X'E5AD97E585B8E69FA5E8AFA2',105,1,X'23',X'',X'',1,0,X'46',X'30',X'30',X'73797374656D3A646963743A7175657279',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1026,X'E5AD97E585B8E696B0E5A29E',105,2,X'23',X'',X'',1,0,X'46',X'30',X'30',X'73797374656D3A646963743A616464',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1027,X'E5AD97E585B8E4BFAEE694B9',105,3,X'23',X'',X'',1,0,X'46',X'30',X'30',X'73797374656D3A646963743A65646974',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1028,X'E5AD97E585B8E588A0E999A4',105,4,X'23',X'',X'',1,0,X'46',X'30',X'30',X'73797374656D3A646963743A72656D6F7665',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1029,X'E5AD97E585B8E5AFBCE587BA',105,5,X'23',X'',X'',1,0,X'46',X'30',X'30',X'73797374656D3A646963743A6578706F7274',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1030,X'E58F82E695B0E69FA5E8AFA2',106,1,X'23',X'',X'',1,0,X'46',X'30',X'30',X'73797374656D3A636F6E6669673A7175657279',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1031,X'E58F82E695B0E696B0E5A29E',106,2,X'23',X'',X'',1,0,X'46',X'30',X'30',X'73797374656D3A636F6E6669673A616464',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1032,X'E58F82E695B0E4BFAEE694B9',106,3,X'23',X'',X'',1,0,X'46',X'30',X'30',X'73797374656D3A636F6E6669673A65646974',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1033,X'E58F82E695B0E588A0E999A4',106,4,X'23',X'',X'',1,0,X'46',X'30',X'30',X'73797374656D3A636F6E6669673A72656D6F7665',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1034,X'E58F82E695B0E5AFBCE587BA',106,5,X'23',X'',X'',1,0,X'46',X'30',X'30',X'73797374656D3A636F6E6669673A6578706F7274',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1035,X'E585ACE5918AE69FA5E8AFA2',107,1,X'23',X'',X'',1,0,X'46',X'30',X'30',X'73797374656D3A6E6F746963653A7175657279',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1036,X'E585ACE5918AE696B0E5A29E',107,2,X'23',X'',X'',1,0,X'46',X'30',X'30',X'73797374656D3A6E6F746963653A616464',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1037,X'E585ACE5918AE4BFAEE694B9',107,3,X'23',X'',X'',1,0,X'46',X'30',X'30',X'73797374656D3A6E6F746963653A65646974',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1038,X'E585ACE5918AE588A0E999A4',107,4,X'23',X'',X'',1,0,X'46',X'30',X'30',X'73797374656D3A6E6F746963653A72656D6F7665',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1039,X'E6938DE4BD9CE69FA5E8AFA2',500,1,X'23',X'',X'',1,0,X'46',X'30',X'30',X'6D6F6E69746F723A6F7065726C6F673A7175657279',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1040,X'E6938DE4BD9CE588A0E999A4',500,2,X'23',X'',X'',1,0,X'46',X'30',X'30',X'6D6F6E69746F723A6F7065726C6F673A72656D6F7665',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1041,X'E697A5E5BF97E5AFBCE587BA',500,3,X'23',X'',X'',1,0,X'46',X'30',X'30',X'6D6F6E69746F723A6F7065726C6F673A6578706F7274',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1042,X'E799BBE5BD95E69FA5E8AFA2',501,1,X'23',X'',X'',1,0,X'46',X'30',X'30',X'6D6F6E69746F723A6C6F67696E696E666F723A7175657279',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1043,X'E799BBE5BD95E588A0E999A4',501,2,X'23',X'',X'',1,0,X'46',X'30',X'30',X'6D6F6E69746F723A6C6F67696E696E666F723A72656D6F7665',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1044,X'E697A5E5BF97E5AFBCE587BA',501,3,X'23',X'',X'',1,0,X'46',X'30',X'30',X'6D6F6E69746F723A6C6F67696E696E666F723A6578706F7274',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1045,X'E8B4A6E688B7E8A7A3E99481',501,4,X'23',X'',X'',1,0,X'46',X'30',X'30',X'6D6F6E69746F723A6C6F67696E696E666F723A756E6C6F636B',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1046,X'E59CA8E7BABFE69FA5E8AFA2',109,1,X'23',X'',X'',1,0,X'46',X'30',X'30',X'6D6F6E69746F723A6F6E6C696E653A7175657279',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1047,X'E689B9E9878FE5BCBAE98080',109,2,X'23',X'',X'',1,0,X'46',X'30',X'30',X'6D6F6E69746F723A6F6E6C696E653A62617463684C6F676F7574',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1048,X'E58D95E69DA1E5BCBAE98080',109,3,X'23',X'',X'',1,0,X'46',X'30',X'30',X'6D6F6E69746F723A6F6E6C696E653A666F7263654C6F676F7574',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1049,X'E4BBBBE58AA1E69FA5E8AFA2',110,1,X'23',X'',X'',1,0,X'46',X'30',X'30',X'6D6F6E69746F723A6A6F623A7175657279',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1050,X'E4BBBBE58AA1E696B0E5A29E',110,2,X'23',X'',X'',1,0,X'46',X'30',X'30',X'6D6F6E69746F723A6A6F623A616464',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1051,X'E4BBBBE58AA1E4BFAEE694B9',110,3,X'23',X'',X'',1,0,X'46',X'30',X'30',X'6D6F6E69746F723A6A6F623A65646974',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1052,X'E4BBBBE58AA1E588A0E999A4',110,4,X'23',X'',X'',1,0,X'46',X'30',X'30',X'6D6F6E69746F723A6A6F623A72656D6F7665',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1053,X'E78AB6E68081E4BFAEE694B9',110,5,X'23',X'',X'',1,0,X'46',X'30',X'30',X'6D6F6E69746F723A6A6F623A6368616E6765537461747573',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1054,X'E4BBBBE58AA1E5AFBCE587BA',110,6,X'23',X'',X'',1,0,X'46',X'30',X'30',X'6D6F6E69746F723A6A6F623A6578706F7274',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1055,X'E7949FE68890E69FA5E8AFA2',116,1,X'23',X'',X'',1,0,X'46',X'30',X'30',X'746F6F6C3A67656E3A7175657279',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1056,X'E7949FE68890E4BFAEE694B9',116,2,X'23',X'',X'',1,0,X'46',X'30',X'30',X'746F6F6C3A67656E3A65646974',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1057,X'E7949FE68890E588A0E999A4',116,3,X'23',X'',X'',1,0,X'46',X'30',X'30',X'746F6F6C3A67656E3A72656D6F7665',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1058,X'E5AFBCE585A5E4BBA3E7A081',116,4,X'23',X'',X'',1,0,X'46',X'30',X'30',X'746F6F6C3A67656E3A696D706F7274',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1059,X'E9A284E8A788E4BBA3E7A081',116,5,X'23',X'',X'',1,0,X'46',X'30',X'30',X'746F6F6C3A67656E3A70726576696577',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1060,X'E7949FE68890E4BBA3E7A081',116,6,X'23',X'',X'',1,0,X'46',X'30',X'30',X'746F6F6C3A67656E3A636F6465',X'23',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(1061,X'E7A79FE688B7E4BFA1E681AF',1,1,X'74656E616E74',X'73797374656D2F74656E616E742F696E646578',NULL,1,0,X'43',X'30',X'30',X'73797374656D3A74656E616E743A6C697374',X'736572766572',X'61646D696E','2023-06-03 08:36:08',X'61646D696E','2023-06-03 08:53:14',X'E7A79FE688B7E4BFA1E681AFE88F9CE58D95'),
	(1062,X'E7A79FE688B7E4BFA1E681AFE69FA5E8AFA2',1061,1,X'23',X'',NULL,1,0,X'46',X'30',X'30',X'73797374656D3A74656E616E743A7175657279',X'23',X'61646D696E','2023-06-03 08:36:08',X'',NULL,X''),
	(1063,X'E7A79FE688B7E4BFA1E681AFE696B0E5A29E',1061,2,X'23',X'',NULL,1,0,X'46',X'30',X'30',X'73797374656D3A74656E616E743A616464',X'23',X'61646D696E','2023-06-03 08:36:08',X'',NULL,X''),
	(1064,X'E7A79FE688B7E4BFA1E681AFE4BFAEE694B9',1061,3,X'23',X'',NULL,1,0,X'46',X'30',X'30',X'73797374656D3A74656E616E743A65646974',X'23',X'61646D696E','2023-06-03 08:36:08',X'',NULL,X''),
	(1065,X'E7A79FE688B7E4BFA1E681AFE588A0E999A4',1061,4,X'23',X'',NULL,1,0,X'46',X'30',X'30',X'73797374656D3A74656E616E743A72656D6F7665',X'23',X'61646D696E','2023-06-03 08:36:08',X'',NULL,X''),
	(1066,X'E7A79FE688B7E4BFA1E681AFE5AFBCE587BA',1061,5,X'23',X'',NULL,1,0,X'46',X'30',X'30',X'73797374656D3A74656E616E743A6578706F7274',X'23',X'61646D696E','2023-06-03 08:36:08',X'',NULL,X'');

/*!40000 ALTER TABLE `sys_menu` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table sys_notice
# ------------------------------------------------------------

DROP TABLE IF EXISTS `sys_notice`;

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

LOCK TABLES `sys_notice` WRITE;
/*!40000 ALTER TABLE `sys_notice` DISABLE KEYS */;

INSERT INTO `sys_notice` (`notice_id`, `notice_title`, `notice_type`, `notice_content`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES
	(1,X'E6B8A9E9A6A8E68F90E98692EFBC9A323031382D30372D303120E88BA5E4BE9DE696B0E78988E69CACE58F91E5B883E595A6',X'32',X'E696B0E78988E69CACE58685E5AEB9',X'30',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E7AEA1E79086E59198'),
	(2,X'E7BBB4E68AA4E9809AE79FA5EFBC9A323031382D30372D303120E88BA5E4BE9DE7B3BBE7BB9FE5878CE699A8E7BBB4E68AA4',X'31',X'E7BBB4E68AA4E58685E5AEB9',X'30',X'61646D696E','2023-05-25 16:54:11',X'',NULL,X'E7AEA1E79086E59198');

/*!40000 ALTER TABLE `sys_notice` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table sys_oper_log
# ------------------------------------------------------------

DROP TABLE IF EXISTS `sys_oper_log`;

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

LOCK TABLES `sys_oper_log` WRITE;
/*!40000 ALTER TABLE `sys_oper_log` DISABLE KEYS */;

INSERT INTO `sys_oper_log` (`oper_id`, `title`, `business_type`, `method`, `request_method`, `operator_type`, `oper_name`, `dept_name`, `oper_url`, `oper_ip`, `oper_location`, `oper_param`, `json_result`, `status`, `error_msg`, `oper_time`, `cost_time`)
VALUES
	(100,X'E794A8E688B7E7AEA1E79086',3,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797355736572436F6E74726F6C6C65722E72656D6F76652829',X'44454C455445',1,X'61646D696E',NULL,X'2F73797374656D2F757365722F32',X'3132372E302E302E31',X'E58685E7BD914950',X'7B7D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-05-25 18:11:13',30),
	(101,X'E983A8E997A8E7AEA1E79086',3,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797344657074436F6E74726F6C6C65722E72656D6F76652829',X'44454C455445',1,X'61646D696E',NULL,X'2F73797374656D2F646570742F313039',X'3132372E302E302E31',X'E58685E7BD914950',X'7B7D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-05-25 18:13:13',13),
	(102,X'E983A8E997A8E7AEA1E79086',3,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797344657074436F6E74726F6C6C65722E72656D6F76652829',X'44454C455445',1,X'61646D696E',NULL,X'2F73797374656D2F646570742F313038',X'3132372E302E302E31',X'E58685E7BD914950',X'7B7D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-05-25 18:13:14',13),
	(103,X'E983A8E997A8E7AEA1E79086',3,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797344657074436F6E74726F6C6C65722E72656D6F76652829',X'44454C455445',1,X'61646D696E',NULL,X'2F73797374656D2F646570742F313032',X'3132372E302E302E31',X'E58685E7BD914950',X'7B7D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-05-25 18:13:15',14),
	(104,X'E983A8E997A8E7AEA1E79086',3,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797344657074436F6E74726F6C6C65722E72656D6F76652829',X'44454C455445',1,X'61646D696E',NULL,X'2F73797374656D2F646570742F313037',X'3132372E302E302E31',X'E58685E7BD914950',X'7B7D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-05-25 18:13:17',12),
	(105,X'E983A8E997A8E7AEA1E79086',3,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797344657074436F6E74726F6C6C65722E72656D6F76652829',X'44454C455445',1,X'61646D696E',NULL,X'2F73797374656D2F646570742F313036',X'3132372E302E302E31',X'E58685E7BD914950',X'7B7D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-05-25 18:13:18',14),
	(106,X'E983A8E997A8E7AEA1E79086',3,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797344657074436F6E74726F6C6C65722E72656D6F76652829',X'44454C455445',1,X'61646D696E',NULL,X'2F73797374656D2F646570742F313035',X'3132372E302E302E31',X'E58685E7BD914950',X'7B7D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-05-25 18:13:20',13),
	(107,X'E983A8E997A8E7AEA1E79086',3,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797344657074436F6E74726F6C6C65722E72656D6F76652829',X'44454C455445',1,X'61646D696E',NULL,X'2F73797374656D2F646570742F313034',X'3132372E302E302E31',X'E58685E7BD914950',X'7B7D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-05-25 18:13:22',15),
	(108,X'E983A8E997A8E7AEA1E79086',2,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797344657074436F6E74726F6C6C65722E656469742829',X'505554',1,X'61646D696E',NULL,X'2F73797374656D2F64657074',X'3132372E302E302E31',X'E58685E7BD914950',X'7B22616E636573746F7273223A22302C313030222C226368696C6472656E223A5B5D2C22646570744964223A3130312C22646570744E616D65223A22E58C97E4BAACE585ACE58FB8222C22656D61696C223A2272794071712E636F6D222C226C6561646572223A22E88BA5E4BE9D222C226F726465724E756D223A312C22706172616D73223A7B7D2C22706172656E744964223A3130302C22706172656E744E616D65223A22E88BA5E4BE9DE7A791E68A80222C2270686F6E65223A223135383838383838383838222C22737461747573223A2230222C227570646174654279223A2261646D696E227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-05-25 18:13:41',23),
	(109,X'E983A8E997A8E7AEA1E79086',2,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797344657074436F6E74726F6C6C65722E656469742829',X'505554',1,X'61646D696E',NULL,X'2F73797374656D2F64657074',X'3132372E302E302E31',X'E58685E7BD914950',X'7B22616E636573746F7273223A2230222C226368696C6472656E223A5B5D2C22646570744964223A3130302C22646570744E616D65223A22E7A791E68A80E99B86E59BA2222C22656D61696C223A2272794071712E636F6D222C226C6561646572223A22E88BA5E4BE9D222C226F726465724E756D223A302C22706172616D73223A7B7D2C22706172656E744964223A302C2270686F6E65223A223135383838383838383838222C22737461747573223A2230222C227570646174654279223A2261646D696E227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-05-25 18:13:59',16),
	(110,X'E58F82E695B0E7AEA1E79086',2,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E537973436F6E666967436F6E74726F6C6C65722E656469742829',X'505554',1,X'61646D696E',NULL,X'2F73797374656D2F636F6E666967',X'3132372E302E302E31',X'E58685E7BD914950',X'7B22636F6E6669674964223A342C22636F6E6669674B6579223A227379732E6163636F756E742E63617074636861456E61626C6564222C22636F6E6669674E616D65223A22E8B4A6E58FB7E887AAE58AA92DE9AA8CE8AF81E7A081E5BC80E585B3222C22636F6E66696754797065223A224E222C22636F6E66696756616C7565223A2274727565222C226372656174654279223A2261646D696E222C2263726561746554696D65223A22323032332D30352D32352031363A35343A3131222C22706172616D73223A7B7D2C2272656D61726B223A22E698AFE590A6E5BC80E590AFE9AA8CE8AF81E7A081E58A9FE883BDEFBC8874727565E5BC80E590AFEFBC8C66616C7365E585B3E997ADEFBC89222C227570646174654279223A2261646D696E227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-05-25 18:14:25',20),
	(111,X'E58F82E695B0E7AEA1E79086',2,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E537973436F6E666967436F6E74726F6C6C65722E656469742829',X'505554',1,X'61646D696E',NULL,X'2F73797374656D2F636F6E666967',X'3132372E302E302E31',X'E58685E7BD914950',X'7B22636F6E6669674964223A342C22636F6E6669674B6579223A227379732E6163636F756E742E63617074636861456E61626C6564222C22636F6E6669674E616D65223A22E8B4A6E58FB7E887AAE58AA92DE9AA8CE8AF81E7A081E5BC80E585B3222C22636F6E66696754797065223A2259222C22636F6E66696756616C7565223A2266616C7365222C226372656174654279223A2261646D696E222C2263726561746554696D65223A22323032332D30352D32352031363A35343A3131222C22706172616D73223A7B7D2C2272656D61726B223A22E698AFE590A6E5BC80E590AFE9AA8CE8AF81E7A081E58A9FE883BDEFBC8874727565E5BC80E590AFEFBC8C66616C7365E585B3E997ADEFBC89222C227570646174654279223A2261646D696E222C2275706461746554696D65223A22323032332D30352D32352031383A31343A3235227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-05-25 18:14:44',23),
	(112,X'E4BBA3E7A081E7949FE68890',6,X'636F6D2E72756F79692E67656E657261746F722E636F6E74726F6C6C65722E47656E436F6E74726F6C6C65722E696D706F72745461626C65536176652829',X'504F5354',1,X'61646D696E',NULL,X'2F746F6F6C2F67656E2F696D706F72745461626C65',X'3132372E302E302E31',X'E58685E7BD914950',X'7B227461626C6573223A227379735F74656E616E74227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-03 08:26:39',1000),
	(113,X'E4BBA3E7A081E7949FE68890',2,X'636F6D2E72756F79692E67656E657261746F722E636F6E74726F6C6C65722E47656E436F6E74726F6C6C65722E65646974536176652829',X'505554',1,X'61646D696E',NULL,X'2F746F6F6C2F67656E',X'3132372E302E302E31',X'E58685E7BD914950',X'7B22627573696E6573734E616D65223A2274656E616E74222C22636C6173734E616D65223A2253797354656E616E74222C22636F6C756D6E73223A5B7B226361704A6176614669656C64223A2254656E616E744964222C22636F6C756D6E436F6D6D656E74223A22E7A79FE688B74944222C22636F6C756D6E4964223A312C22636F6C756D6E4E616D65223A2274656E616E745F6964222C22636F6C756D6E54797065223A22626967696E7428323029222C226372656174654279223A2261646D696E222C2263726561746554696D65223A22323032332D30362D30332030383A32363A3339222C226469637454797065223A22222C2265646974223A66616C73652C2268746D6C54797065223A22696E707574222C22696E6372656D656E74223A747275652C22696E73657274223A747275652C226973496E6372656D656E74223A2231222C226973496E73657274223A2231222C226973506B223A2231222C226A6176614669656C64223A2274656E616E744964222C226A61766154797065223A224C6F6E67222C226C697374223A66616C73652C22706172616D73223A7B7D2C22706B223A747275652C227175657279223A66616C73652C22717565727954797065223A224551222C227265717569726564223A66616C73652C22736F7274223A312C227375706572436F6C756D6E223A66616C73652C227461626C654964223A312C227570646174654279223A22222C22757361626C65436F6C756D6E223A66616C73657D2C7B226361704A6176614669656C64223A2254656E616E744E616D65222C22636F6C756D6E436F6D6D656E74223A22E7A79FE688B7E5908DE7A7B0222C22636F6C756D6E4964223A322C22636F6C756D6E4E616D65223A2274656E616E745F6E616D65222C22636F6C756D6E54797065223A22766172636861722831303029222C226372656174654279223A2261646D696E222C2263726561746554696D65223A22323032332D30362D30332030383A32363A3339222C226469637454797065223A22222C2265646974223A747275652C2268746D6C54797065223A22696E707574222C22696E6372656D656E74223A66616C73652C22696E73657274223A747275652C22697345646974223A2231222C226973496E6372656D656E74223A2230222C226973496E73657274223A2231222C2269734C697374223A2231222C226973506B223A2230222C2269735175657279223A2231222C2269735265717569726564223A2231222C226A6176614669656C64223A2274656E616E744E616D65222C226A61766154797065223A22537472696E67222C226C697374223A747275652C22706172616D73223A7B7D2C22706B223A66616C73652C227175657279223A747275652C22717565727954797065223A224C494B45222C227265717569726564223A747275652C22736F7274223A322C227375706572436F6C756D6E223A66616C73652C227461626C654964223A312C227570646174654279223A22222C22757361626C65436F6C756D6E223A66616C73657D2C7B226361704A6176614669656C64223A2254656E616E74436F6465222C22636F6C756D6E436F6D6D656E74223A22E7A79FE688B7E7BC96E58FB7EFBC88E585ACE58FB8E7BB9FE4B880E4BFA1E794A8E4BBA3E7A081EFBC89222C22636F6C756D6E4964223A332C22636F6C756D6E4E616D65223A2274656E616E745F636F6465222C22636F6C756D6E54797065223A226368617228313829222C226372656174654279223A2261646D696E222C2263726561746554696D65223A22323032332D30362D30332030383A32363A3339222C226469637454797065223A22222C2265646974223A747275652C2268746D6C54797065223A22696E707574222C22696E6372656D656E74223A66616C73652C22696E73657274223A747275652C22697345646974223A2231222C226973496E6372656D656E74223A2230222C226973496E73657274223A2231222C2269734C697374223A2231222C226973506B223A2230222C2269735175657279223A2231222C2269735265717569726564223A2231222C226A6176614669656C64223A2274656E616E74436F6465222C226A61766154797065223A22537472696E67222C226C697374223A747275652C22706172616D73223A7B7D2C22706B223A66616C73652C227175657279223A747275652C22717565727954797065223A224551222C227265717569726564223A747275652C22736F7274223A332C227375706572436F6C756D6E223A66616C73652C227461626C654964223A312C227570646174654279223A22222C22757361626C65436F6C756D6E223A66616C73657D2C7B226361704A6176614669656C64223A224F776E6572222C22636F6C756D6E436F6D6D656E74223A22E8B49FE8B4A3E4BABA222C22636F6C756D6E4964223A342C22636F6C756D6E4E616D65223A226F776E6572222C22636F6C756D6E54797065223A227661726368617228353029222C226372656174654279223A2261646D696E222C2263726561746554696D65223A22323032332D30362D30332030383A32363A3339222C226469637454797065223A22222C2265646974223A747275652C2268746D6C54797065223A22696E707574222C22696E6372656D656E74223A66616C73652C22696E73657274223A747275652C22697345646974223A2231222C226973496E6372656D656E74223A2230222C226973496E73657274223A2231222C2269734C697374223A2231222C226973506B223A2230222C2269735175657279223A2231222C226A6176614669656C64',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-03 08:30:11',107),
	(114,X'E4BBA3E7A081E7949FE68890',8,X'636F6D2E72756F79692E67656E657261746F722E636F6E74726F6C6C65722E47656E436F6E74726F6C6C65722E626174636847656E436F64652829',X'474554',1,X'61646D696E',NULL,X'2F746F6F6C2F67656E2F626174636847656E436F6465',X'3132372E302E302E31',X'E58685E7BD914950',X'7B227461626C6573223A227379735F74656E616E74227D',NULL,0,NULL,'2023-06-03 08:34:55',88),
	(115,X'E7A79FE688B7E4BFA1E681AF',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797354656E616E74436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'61646D696E',NULL,X'2F73797374656D2F74656E616E74',X'3132372E302E302E31',X'E58685E7BD914950',X'7B2263726561746554696D65223A22323032332D30362D30332031363A35303A3239222C22706172616D73223A7B7D2C2274656E616E74436F6465223A2233313331303030304D443032353137313244222C2274656E616E744964223A312C2274656E616E744E616D65223A224854227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-03 08:50:29',87),
	(116,X'E7A79FE688B7E4BFA1E681AF',2,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797354656E616E74436F6E74726F6C6C65722E656469742829',X'505554',1,X'61646D696E',NULL,X'2F73797374656D2F74656E616E74',X'3132372E302E302E31',X'E58685E7BD914950',X'7B22636F6E74616374496E666F223A223138393132333431323334222C226372656174654279223A22222C2263726561746554696D65223A22323032332D30362D30332031363A35303A3239222C22697344656C223A2230222C226F776E6572223A227A68616E6773616E222C22706172616D73223A7B7D2C2274656E616E74436F6465223A2233313331303030304D443032353137313244222C2274656E616E744964223A312C2274656E616E744E616D65223A224854227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-03 08:50:58',22),
	(117,X'E88F9CE58D95E7AEA1E79086',2,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E5379734D656E75436F6E74726F6C6C65722E656469742829',X'505554',1,X'61646D696E',NULL,X'2F73797374656D2F6D656E75',X'3132372E302E302E31',X'E58685E7BD914950',X'7B226368696C6472656E223A5B5D2C22636F6D706F6E656E74223A2273797374656D2F74656E616E742F696E646578222C2263726561746554696D65223A22323032332D30362D30332030383A33363A3038222C2269636F6E223A22736572766572222C2269734361636865223A2230222C2269734672616D65223A2231222C226D656E754964223A313036312C226D656E754E616D65223A22E7A79FE688B7E4BFA1E681AF222C226D656E7554797065223A2243222C226F726465724E756D223A312C22706172616D73223A7B7D2C22706172656E744964223A312C2270617468223A2274656E616E74222C227065726D73223A2273797374656D3A74656E616E743A6C697374222C22737461747573223A2230222C227570646174654279223A2261646D696E222C2276697369626C65223A2230227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-03 08:53:14',35),
	(118,X'E794A8E688B7E7AEA1E79086',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797355736572436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'61646D696E',NULL,X'2F73797374656D2F75736572',X'3132372E302E302E31',X'E58685E7BD914950',X'7B2261646D696E223A66616C73652C226372656174654279223A2261646D696E222C226E69636B4E616D65223A22E68192E6B3B0222C22706172616D73223A7B7D2C22706F7374496473223A5B5D2C22726F6C65496473223A5B5D2C22737461747573223A2230222C22757365724964223A322C22757365724E616D65223A22687461646D696E227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-10 04:57:39',288),
	(119,X'E8A792E889B2E7AEA1E79086',4,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E537973526F6C65436F6E74726F6C6C65722E73656C6563744175746855736572416C6C2829',X'505554',1,X'61646D696E',NULL,X'2F73797374656D2F726F6C652F61757468557365722F73656C656374416C6C',X'3132372E302E302E31',X'E58685E7BD914950',X'7B22726F6C654964223A2232222C2275736572496473223A2232227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-10 04:59:17',20),
	(120,X'E8A792E889B2E7AEA1E79086',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E537973526F6C65436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'687461646D696E',NULL,X'2F73797374656D2F726F6C65',X'3132372E302E302E31',X'E58685E7BD914950',X'7B2261646D696E223A66616C73652C226372656174654279223A22687461646D696E222C2264657074436865636B5374726963746C79223A747275652C2264657074496473223A5B5D2C22666C6167223A66616C73652C226D656E75436865636B5374726963746C79223A747275652C226D656E75496473223A5B345D2C22706172616D73223A7B7D2C22726F6C654964223A332C22726F6C654B6579223A22646576222C22726F6C654E616D65223A22646576222C22726F6C65536F7274223A302C22737461747573223A2230227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-10 08:47:17',65),
	(121,X'E8A792E889B2E7AEA1E79086',2,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E537973526F6C65436F6E74726F6C6C65722E6461746153636F70652829',X'505554',1,X'61646D696E',NULL,X'2F73797374656D2F726F6C652F6461746153636F7065',X'3132372E302E302E31',X'E58685E7BD914950',X'7B2261646D696E223A66616C73652C2263726561746554696D65223A22323032332D30362D31302030383A34373A3137222C226461746153636F7065223A2232222C2264656C466C6167223A2230222C2264657074436865636B5374726963746C79223A747275652C2264657074496473223A5B3130302C3130312C3130335D2C22666C6167223A66616C73652C226D656E75436865636B5374726963746C79223A747275652C22706172616D73223A7B7D2C22726F6C654964223A332C22726F6C654B6579223A22646576222C22726F6C654E616D65223A22646576222C22726F6C65536F7274223A302C22737461747573223A2230227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-10 08:49:10',68),
	(122,X'E8A792E889B2E7AEA1E79086',2,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E537973526F6C65436F6E74726F6C6C65722E6461746153636F70652829',X'505554',1,X'61646D696E',NULL,X'2F73797374656D2F726F6C652F6461746153636F7065',X'3132372E302E302E31',X'E58685E7BD914950',X'7B2261646D696E223A66616C73652C2263726561746554696D65223A22323032332D30362D31302030383A34373A3137222C226461746153636F7065223A2232222C2264656C466C6167223A2230222C2264657074436865636B5374726963746C79223A66616C73652C2264657074496473223A5B3130335D2C22666C6167223A66616C73652C226D656E75436865636B5374726963746C79223A747275652C22706172616D73223A7B7D2C22726F6C654964223A332C22726F6C654B6579223A22646576222C22726F6C654E616D65223A22646576222C22726F6C65536F7274223A302C22737461747573223A2230227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-10 08:56:07',39),
	(123,X'E794A8E688B7E7AEA1E79086',4,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797355736572436F6E74726F6C6C65722E696E7365727441757468526F6C652829',X'505554',1,X'61646D696E',NULL,X'2F73797374656D2F757365722F61757468526F6C65',X'3132372E302E302E31',X'E58685E7BD914950',X'7B22726F6C65496473223A2233222C22757365724964223A2232227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-10 08:57:35',45),
	(124,X'E8A792E889B2E7AEA1E79086',2,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E537973526F6C65436F6E74726F6C6C65722E656469742829',X'505554',1,X'61646D696E',NULL,X'2F73797374656D2F726F6C65',X'3132372E302E302E31',X'E58685E7BD914950',X'7B2261646D696E223A66616C73652C2263726561746554696D65223A22323032332D30362D31302030383A34373A3137222C226461746153636F7065223A2232222C2264656C466C6167223A2230222C2264657074436865636B5374726963746C79223A66616C73652C22666C6167223A66616C73652C226D656E75436865636B5374726963746C79223A747275652C226D656E75496473223A5B312C3130332C313031362C313031372C313031382C313031392C345D2C22706172616D73223A7B7D2C22726F6C654964223A332C22726F6C654B6579223A22646576222C22726F6C654E616D65223A22646576222C22726F6C65536F7274223A302C22737461747573223A2230222C227570646174654279223A2261646D696E227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-10 08:58:43',68),
	(125,X'E794A8E688B7E7AEA1E79086',2,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797355736572436F6E74726F6C6C65722E656469742829',X'505554',1,X'61646D696E',NULL,X'2F73797374656D2F75736572',X'3132372E302E302E31',X'E58685E7BD914950',X'7B2261646D696E223A66616C73652C22617661746172223A22222C226372656174654279223A2261646D696E222C2263726561746554696D65223A22323032332D30362D31302030343A35373A3339222C2264656C466C6167223A2230222C22646570744964223A3130302C22656D61696C223A22222C226C6F67696E44617465223A22323032332D30362D31302031363A35383A3533222C226C6F67696E4970223A223132372E302E302E31222C226E69636B4E616D65223A22E68192E6B3B0222C22706172616D73223A7B7D2C2270686F6E656E756D626572223A22222C22706F7374496473223A5B5D2C22726F6C65496473223A5B335D2C22726F6C6573223A5B7B2261646D696E223A66616C73652C226461746153636F7065223A2232222C2264657074436865636B5374726963746C79223A66616C73652C22666C6167223A66616C73652C226D656E75436865636B5374726963746C79223A66616C73652C22706172616D73223A7B7D2C22726F6C654964223A332C22726F6C654B6579223A22646576222C22726F6C654E616D65223A22646576222C22726F6C65536F7274223A302C22737461747573223A2230227D5D2C22736578223A2230222C22737461747573223A2230222C227570646174654279223A2261646D696E222C22757365724964223A322C22757365724E616D65223A22687461646D696E227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-10 09:04:19',79),
	(126,X'E8A792E889B2E7AEA1E79086',2,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E537973526F6C65436F6E74726F6C6C65722E656469742829',X'505554',1,X'61646D696E',NULL,X'2F73797374656D2F726F6C65',X'3132372E302E302E31',X'E58685E7BD914950',X'7B2261646D696E223A66616C73652C2263726561746554696D65223A22323032332D30362D31302030383A34373A3137222C226461746153636F7065223A2232222C2264656C466C6167223A2230222C2264657074436865636B5374726963746C79223A66616C73652C22666C6167223A66616C73652C226D656E75436865636B5374726963746C79223A747275652C226D656E75496473223A5B312C3130302C313030302C313030312C313030322C313030332C313030342C313030352C313030362C3130312C313030372C313030382C313030392C313031302C313031312C3130322C313031322C313031332C313031342C313031352C3130332C313031362C313031372C313031382C313031392C345D2C22706172616D73223A7B7D2C22726F6C654964223A332C22726F6C654B6579223A22646576222C22726F6C654E616D65223A22646576222C22726F6C65536F7274223A302C22737461747573223A2230222C227570646174654279223A2261646D696E227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-10 09:25:36',81),
	(127,X'E8A792E889B2E7AEA1E79086',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E537973526F6C65436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'687461646D696E',NULL,X'2F73797374656D2F726F6C65',X'3132372E302E302E31',X'E58685E7BD914950',X'7B2261646D696E223A66616C73652C226372656174654279223A22687461646D696E222C2264657074436865636B5374726963746C79223A747275652C2264657074496473223A5B5D2C22666C6167223A66616C73652C226D656E75436865636B5374726963746C79223A747275652C226D656E75496473223A5B312C3130302C313030302C313030312C313030322C313030332C313030342C313030352C313030365D2C22706172616D73223A7B7D2C22726F6C654964223A342C22726F6C654B6579223A2264657631222C22726F6C654E616D65223A2264657631222C22726F6C65536F7274223A302C22737461747573223A2230227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-10 09:32:16',61),
	(128,X'E8A792E889B2E7AEA1E79086',2,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E537973526F6C65436F6E74726F6C6C65722E6461746153636F70652829',X'505554',1,X'61646D696E',NULL,X'2F73797374656D2F726F6C652F6461746153636F7065',X'3132372E302E302E31',X'E58685E7BD914950',X'7B2261646D696E223A66616C73652C2263726561746554696D65223A22323032332D30362D31302030393A33323A3136222C226461746153636F7065223A2232222C2264656C466C6167223A2230222C2264657074436865636B5374726963746C79223A747275652C2264657074496473223A5B3130302C3130312C3130335D2C22666C6167223A66616C73652C226D656E75436865636B5374726963746C79223A747275652C22706172616D73223A7B7D2C22726F6C654964223A342C22726F6C654B6579223A2264657631222C22726F6C654E616D65223A2264657631222C22726F6C65536F7274223A302C22737461747573223A2230227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-10 09:36:04',41),
	(129,X'E983A8E997A8E7AEA1E79086',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797344657074436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'687461646D696E',NULL,X'2F73797374656D2F64657074',X'3132372E302E302E31',X'E58685E7BD914950',X'7B22616E636573746F7273223A22302C3130302C3130312C313033222C226368696C6472656E223A5B5D2C226372656174654279223A22687461646D696E222C22646570744E616D65223A22E5898DE7ABAF31E7BB84222C226F726465724E756D223A312C22706172616D73223A7B7D2C22706172656E744964223A3130332C22737461747573223A2230227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-10 10:11:55',49),
	(130,X'E7A79FE688B7E4BFA1E681AF',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797354656E616E74436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'61646D696E',NULL,X'2F73797374656D2F74656E616E74',X'3132372E302E302E31',X'E58685E7BD914950',X'7B2263726561746554696D65223A22323032332D30362D31312031363A32393A3034222C22706172616D73223A7B7D2C2274656E616E74436F6465223A2233313331303030304D443032353137313232222C2274656E616E744964223A322C2274656E616E744E616D65223A225A4832227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-11 08:29:04',79),
	(131,X'E7A79FE688B7E4BFA1E681AF',2,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797354656E616E74436F6E74726F6C6C65722E656469742829',X'505554',1,X'61646D696E',NULL,X'2F73797374656D2F74656E616E74',X'3132372E302E302E31',X'E58685E7BD914950',X'7B226372656174654279223A22222C2263726561746554696D65223A22323032332D30362D31312031363A32393A3034222C22697344656C223A2230222C22706172616D73223A7B7D2C2274656E616E74436F6465223A2233313331303030304D443032353137313232222C2274656E616E744964223A322C2274656E616E744E616D65223A225A48227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-11 08:29:12',29),
	(132,X'E7A79FE688B7E4BFA1E681AF',2,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797354656E616E74436F6E74726F6C6C65722E656469742829',X'505554',1,X'61646D696E',NULL,X'2F73797374656D2F74656E616E74',X'3132372E302E302E31',X'E58685E7BD914950',X'7B22636F6E74616374496E666F223A223133393132333431323334222C226372656174654279223A22222C2263726561746554696D65223A22323032332D30362D31312031363A32393A3034222C22697344656C223A2230222C226F776E6572223A224C53222C22706172616D73223A7B7D2C2274656E616E74436F6465223A2233313331303030304D443032353137313232222C2274656E616E744964223A322C2274656E616E744E616D65223A225A48227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-11 08:29:45',23),
	(133,X'E7A79FE688B7E4BFA1E681AF',2,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797354656E616E74436F6E74726F6C6C65722E656469742829',X'505554',1,X'61646D696E',NULL,X'2F73797374656D2F74656E616E74',X'3132372E302E302E31',X'E58685E7BD914950',X'7B22636F6E74616374496E666F223A223138393132333431323334222C226372656174654279223A22222C2263726561746554696D65223A22323032332D30362D30332031363A35303A3239222C22697344656C223A2230222C226F776E6572223A225A53222C22706172616D73223A7B7D2C2274656E616E74436F6465223A2233313331303030304D443032353137313244222C2274656E616E744964223A312C2274656E616E744E616D65223A224854227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-11 08:29:53',18),
	(134,X'E7A79FE688B7E4BFA1E681AF',2,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797354656E616E74436F6E74726F6C6C65722E656469742829',X'505554',1,X'61646D696E',NULL,X'2F73797374656D2F74656E616E74',X'3132372E302E302E31',X'E58685E7BD914950',X'7B22636F6E74616374496E666F223A223138393132333431323334222C226372656174654279223A22222C2263726561746554696D65223A22323032332D30362D30332031363A35303A3239222C22697344656C223A2230222C226F776E6572223A225A53222C22706172616D73223A7B7D2C2274656E616E74436F6465223A2233313331303030304D443032353137313244222C2274656E616E744964223A312C2274656E616E744E616D65223A225A4831227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-11 08:30:07',25),
	(135,X'E7A79FE688B7E4BFA1E681AF',2,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797354656E616E74436F6E74726F6C6C65722E656469742829',X'505554',1,X'61646D696E',NULL,X'2F73797374656D2F74656E616E74',X'3132372E302E302E31',X'E58685E7BD914950',X'7B22636F6E74616374496E666F223A223133393132333431323334222C226372656174654279223A22222C2263726561746554696D65223A22323032332D30362D31312031363A32393A3034222C22697344656C223A2230222C226F776E6572223A224C53222C22706172616D73223A7B7D2C2274656E616E74436F6465223A2233313331303030304D443032353137313232222C2274656E616E744964223A322C2274656E616E744E616D65223A225A4832227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-11 08:30:12',22),
	(136,X'E794A8E688B7E7AEA1E79086',2,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797355736572436F6E74726F6C6C65722E656469742829',X'505554',1,X'61646D696E',NULL,X'2F73797374656D2F75736572',X'3132372E302E302E31',X'E58685E7BD914950',X'7B2261646D696E223A66616C73652C22617661746172223A22222C226372656174654279223A2261646D696E222C2263726561746554696D65223A22323032332D30362D31302030343A35373A3339222C2264656C466C6167223A2230222C2264657074223A7B22616E636573746F7273223A2230222C226368696C6472656E223A5B5D2C22646570744964223A3130302C22646570744E616D65223A22E7A791E68A80E99B86E59BA2222C226C6561646572223A22E88BA5E4BE9D222C226F726465724E756D223A302C22706172616D73223A7B7D2C22706172656E744964223A302C22737461747573223A2230227D2C22646570744964223A3130302C22656D61696C223A22222C226C6F67696E44617465223A22323032332D30362D31302031383A31303A3433222C226C6F67696E4970223A223132372E302E302E31222C226E69636B4E616D65223A22E7A79FE688B73031222C22706172616D73223A7B7D2C2270686F6E656E756D626572223A22222C22706F7374496473223A5B5D2C22726F6C65496473223A5B335D2C22726F6C6573223A5B7B2261646D696E223A66616C73652C226461746153636F7065223A2232222C2264657074436865636B5374726963746C79223A66616C73652C22666C6167223A66616C73652C226D656E75436865636B5374726963746C79223A66616C73652C22706172616D73223A7B7D2C22726F6C654964223A332C22726F6C654B6579223A22646576222C22726F6C654E616D65223A22646576222C22726F6C65536F7274223A302C22737461747573223A2230227D5D2C22736578223A2230222C22737461747573223A2230222C227570646174654279223A2261646D696E222C22757365724964223A322C22757365724E616D65223A22687461646D696E227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-11 08:30:43',128),
	(137,X'E794A8E688B7E7AEA1E79086',2,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797355736572436F6E74726F6C6C65722E656469742829',X'505554',1,X'61646D696E',NULL,X'2F73797374656D2F75736572',X'3132372E302E302E31',X'E58685E7BD914950',X'7B2261646D696E223A66616C73652C22617661746172223A22222C226372656174654279223A2261646D696E222C2263726561746554696D65223A22323032332D30362D31302030343A35373A3339222C2264656C466C6167223A2230222C2264657074223A7B22616E636573746F7273223A2230222C226368696C6472656E223A5B5D2C22646570744964223A3130302C22646570744E616D65223A22E7A791E68A80E99B86E59BA2222C226C6561646572223A22E88BA5E4BE9D222C226F726465724E756D223A302C22706172616D73223A7B7D2C22706172656E744964223A302C22737461747573223A2230227D2C22646570744964223A3130302C22656D61696C223A22222C226C6F67696E44617465223A22323032332D30362D31302031383A31303A3433222C226C6F67696E4970223A223132372E302E302E31222C226E69636B4E616D65223A22E7A79FE688B73031E7AEA1E79086E59198222C22706172616D73223A7B7D2C2270686F6E656E756D626572223A22222C22706F7374496473223A5B5D2C22726F6C65496473223A5B335D2C22726F6C6573223A5B7B2261646D696E223A66616C73652C226461746153636F7065223A2232222C2264657074436865636B5374726963746C79223A66616C73652C22666C6167223A66616C73652C226D656E75436865636B5374726963746C79223A66616C73652C22706172616D73223A7B7D2C22726F6C654964223A332C22726F6C654B6579223A22646576222C22726F6C654E616D65223A22646576222C22726F6C65536F7274223A302C22737461747573223A2230227D5D2C22736578223A2230222C22737461747573223A2230222C227570646174654279223A2261646D696E222C22757365724964223A322C22757365724E616D65223A22687461646D696E227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-11 08:30:59',83),
	(138,X'E794A8E688B7E7AEA1E79086',3,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797355736572436F6E74726F6C6C65722E72656D6F76652829',X'44454C455445',1,X'61646D696E',NULL,X'2F73797374656D2F757365722F32',X'3132372E302E302E31',X'E58685E7BD914950',X'7B7D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-11 08:31:10',64),
	(139,X'E794A8E688B7E7AEA1E79086',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797355736572436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'61646D696E',NULL,X'2F73797374656D2F75736572',X'3132372E302E302E31',X'E58685E7BD914950',X'7B2261646D696E223A66616C73652C226372656174654279223A2261646D696E222C226E69636B4E616D65223A22E7A79FE688B73031E7AEA1E79086E59198222C22706172616D73223A7B7D2C22706F7374496473223A5B5D2C22726F6C65496473223A5B5D2C22737461747573223A2230222C22757365724964223A332C22757365724E616D65223A227A68303161646D696E227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-11 08:32:34',147),
	(140,X'E794A8E688B7E7AEA1E79086',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797355736572436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'61646D696E',NULL,X'2F73797374656D2F75736572',X'3132372E302E302E31',X'E58685E7BD914950',X'7B2261646D696E223A66616C73652C226372656174654279223A2261646D696E222C226E69636B4E616D65223A22E7A79FE688B73032E7AEA1E79086E59198222C22706172616D73223A7B7D2C22706F7374496473223A5B5D2C22726F6C65496473223A5B5D2C22737461747573223A2230222C22757365724964223A342C22757365724E616D65223A227A68303261646D696E227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-11 08:32:56',148);

/*!40000 ALTER TABLE `sys_oper_log` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table sys_post
# ------------------------------------------------------------

DROP TABLE IF EXISTS `sys_post`;

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

LOCK TABLES `sys_post` WRITE;
/*!40000 ALTER TABLE `sys_post` DISABLE KEYS */;

INSERT INTO `sys_post` (`post_id`, `post_code`, `post_name`, `post_sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES
	(1,X'63656F',X'E891A3E4BA8BE995BF',1,X'30',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(2,X'7365',X'E9A1B9E79BAEE7BB8FE79086',2,X'30',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(3,X'6872',X'E4BABAE58A9BE8B584E6BA90',3,X'30',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X''),
	(4,X'75736572',X'E699AEE9809AE59198E5B7A5',4,X'30',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X'');

/*!40000 ALTER TABLE `sys_post` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table sys_role
# ------------------------------------------------------------

DROP TABLE IF EXISTS `sys_role`;

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

LOCK TABLES `sys_role` WRITE;
/*!40000 ALTER TABLE `sys_role` DISABLE KEYS */;

INSERT INTO `sys_role` (`role_id`, `role_name`, `role_key`, `role_sort`, `data_scope`, `menu_check_strictly`, `dept_check_strictly`, `status`, `del_flag`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES
	(1,X'E8B685E7BAA7E7AEA1E79086E59198',X'61646D696E',1,X'31',1,1,X'30',X'30',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X'E8B685E7BAA7E7AEA1E79086E59198'),
	(2,X'E699AEE9809AE8A792E889B2',X'636F6D6D6F6E',2,X'32',1,1,X'30',X'30',X'61646D696E','2023-05-25 16:54:10',X'',NULL,X'E699AEE9809AE8A792E889B2'),
	(3,X'646576',X'646576',0,X'32',1,0,X'30',X'30',X'687461646D696E','2023-06-10 08:47:17',X'61646D696E','2023-06-10 09:25:36',NULL),
	(4,X'64657631',X'64657631',0,X'32',1,1,X'30',X'30',X'687461646D696E','2023-06-10 09:32:16',X'','2023-06-10 09:36:04',NULL);

/*!40000 ALTER TABLE `sys_role` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table sys_role_dept
# ------------------------------------------------------------

DROP TABLE IF EXISTS `sys_role_dept`;

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

LOCK TABLES `sys_role_dept` WRITE;
/*!40000 ALTER TABLE `sys_role_dept` DISABLE KEYS */;

INSERT INTO `sys_role_dept` (`role_id`, `dept_id`)
VALUES
	(2,100),
	(2,101),
	(2,105),
	(3,103),
	(4,100),
	(4,101),
	(4,103);

/*!40000 ALTER TABLE `sys_role_dept` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table sys_role_menu
# ------------------------------------------------------------

DROP TABLE IF EXISTS `sys_role_menu`;

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

LOCK TABLES `sys_role_menu` WRITE;
/*!40000 ALTER TABLE `sys_role_menu` DISABLE KEYS */;

INSERT INTO `sys_role_menu` (`role_id`, `menu_id`)
VALUES
	(2,1),
	(2,2),
	(2,3),
	(2,4),
	(2,100),
	(2,101),
	(2,102),
	(2,103),
	(2,104),
	(2,105),
	(2,106),
	(2,107),
	(2,108),
	(2,109),
	(2,110),
	(2,111),
	(2,112),
	(2,113),
	(2,114),
	(2,115),
	(2,116),
	(2,117),
	(2,500),
	(2,501),
	(2,1000),
	(2,1001),
	(2,1002),
	(2,1003),
	(2,1004),
	(2,1005),
	(2,1006),
	(2,1007),
	(2,1008),
	(2,1009),
	(2,1010),
	(2,1011),
	(2,1012),
	(2,1013),
	(2,1014),
	(2,1015),
	(2,1016),
	(2,1017),
	(2,1018),
	(2,1019),
	(2,1020),
	(2,1021),
	(2,1022),
	(2,1023),
	(2,1024),
	(2,1025),
	(2,1026),
	(2,1027),
	(2,1028),
	(2,1029),
	(2,1030),
	(2,1031),
	(2,1032),
	(2,1033),
	(2,1034),
	(2,1035),
	(2,1036),
	(2,1037),
	(2,1038),
	(2,1039),
	(2,1040),
	(2,1041),
	(2,1042),
	(2,1043),
	(2,1044),
	(2,1045),
	(2,1046),
	(2,1047),
	(2,1048),
	(2,1049),
	(2,1050),
	(2,1051),
	(2,1052),
	(2,1053),
	(2,1054),
	(2,1055),
	(2,1056),
	(2,1057),
	(2,1058),
	(2,1059),
	(2,1060),
	(3,1),
	(3,4),
	(3,100),
	(3,101),
	(3,102),
	(3,103),
	(3,1000),
	(3,1001),
	(3,1002),
	(3,1003),
	(3,1004),
	(3,1005),
	(3,1006),
	(3,1007),
	(3,1008),
	(3,1009),
	(3,1010),
	(3,1011),
	(3,1012),
	(3,1013),
	(3,1014),
	(3,1015),
	(3,1016),
	(3,1017),
	(3,1018),
	(3,1019),
	(4,1),
	(4,100),
	(4,1000),
	(4,1001),
	(4,1002),
	(4,1003),
	(4,1004),
	(4,1005),
	(4,1006);

/*!40000 ALTER TABLE `sys_role_menu` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table sys_tenant
# ------------------------------------------------------------

DROP TABLE IF EXISTS `sys_tenant`;

CREATE TABLE `sys_tenant` (
  `tenant_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '租户ID',
  `tenant_name` varchar(100) NOT NULL DEFAULT '' COMMENT '租户名称',
  `tenant_code` char(18) NOT NULL DEFAULT '' COMMENT '租户编号（公司统一信用代码）',
  `owner` varchar(50) DEFAULT NULL COMMENT '负责人',
  `contact_info` varchar(50) DEFAULT NULL COMMENT '联系方式',
  `address` varchar(200) DEFAULT NULL COMMENT '地址',
  `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `is_del` char(1) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '0' COMMENT '是否删除(0：未删除，1已删除)',
  `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`tenant_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='租户信息表';

LOCK TABLES `sys_tenant` WRITE;
/*!40000 ALTER TABLE `sys_tenant` DISABLE KEYS */;

INSERT INTO `sys_tenant` (`tenant_id`, `tenant_name`, `tenant_code`, `owner`, `contact_info`, `address`, `create_by`, `create_time`, `is_del`, `update_by`, `update_time`)
VALUES
	(1,'ZH1','31310000MD0251712D','ZS','18912341234',NULL,X'','2023-06-03 16:50:29',X'30',NULL,NULL),
	(2,'ZH2','31310000MD02517122','LS','13912341234',NULL,X'','2023-06-11 16:29:04',X'30',NULL,NULL);

/*!40000 ALTER TABLE `sys_tenant` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table sys_tenant_menu
# ------------------------------------------------------------

DROP TABLE IF EXISTS `sys_tenant_menu`;

CREATE TABLE `sys_tenant_menu` (
  `tenant_id` bigint(20) NOT NULL COMMENT '租户ID',
  `menu_id` bigint(20) NOT NULL COMMENT '菜单ID',
  PRIMARY KEY (`tenant_id`,`menu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='角色和菜单关联表';

LOCK TABLES `sys_tenant_menu` WRITE;
/*!40000 ALTER TABLE `sys_tenant_menu` DISABLE KEYS */;

INSERT INTO `sys_tenant_menu` (`tenant_id`, `menu_id`)
VALUES
	(1,1),
	(1,100),
	(1,101),
	(1,103),
	(1,1000),
	(1,1001),
	(1,1002),
	(1,1003),
	(1,1004),
	(1,1005),
	(1,1006),
	(1,1007),
	(1,1008),
	(1,1009),
	(1,1010),
	(1,1011),
	(1,1016),
	(1,1017),
	(1,1018),
	(1,1019),
	(2,1),
	(2,100),
	(2,101),
	(2,103),
	(2,1000),
	(2,1001),
	(2,1002),
	(2,1003),
	(2,1004),
	(2,1005),
	(2,1006),
	(2,1007),
	(2,1008),
	(2,1009),
	(2,1010),
	(2,1011),
	(2,1016),
	(2,1017),
	(2,1018),
	(2,1019);

/*!40000 ALTER TABLE `sys_tenant_menu` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table sys_user
# ------------------------------------------------------------

DROP TABLE IF EXISTS `sys_user`;

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

LOCK TABLES `sys_user` WRITE;
/*!40000 ALTER TABLE `sys_user` DISABLE KEYS */;

INSERT INTO `sys_user` (`user_id`, `dept_id`, `user_name`, `nick_name`, `user_type`, `email`, `phonenumber`, `sex`, `avatar`, `password`, `status`, `del_flag`, `login_ip`, `login_date`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `tenant_id`)
VALUES
	(1,103,X'61646D696E',X'E8B685E7BAA7E7AEA1E79086E59198',X'3030',X'7279403136332E636F6D',X'3135383838383838383838',X'31',X'',X'24326124313024374A4237323079756256535A765549307245714B2F2E5671474F5A54482E756C75333364484F6942453842794F684A497264417532',X'30',X'30',X'3132372E302E302E31','2023-06-13 22:49:31',X'61646D696E','2023-05-25 16:54:10',X'','2023-06-13 14:49:31',X'E7AEA1E79086E59198',NULL),
	(2,100,X'687461646D696E',X'E7AEA1E79086E59198',X'3030',X'',X'',X'30',X'',X'243261243130245A7064784F6C4B565764394D2E305A2E7156694C6465434E7566494257737244646D79437379515163633666763045797759313175',X'30',X'32',X'3132372E302E302E31','2023-06-10 18:10:43',X'61646D696E','2023-06-10 04:57:39',X'61646D696E','2023-06-11 08:30:59',NULL,NULL),
	(3,NULL,X'7A68303161646D696E',X'E7A79FE688B73031E7AEA1E79086E59198',X'3031',X'',X'',X'30',X'',X'24326124313024755933462E794F2F626E447A2E657469636F704C572E6A45316A2E314276354B3973486A4B4659462E3946766E3570414F6F5A5A61',X'30',X'30',X'3132372E302E302E31','2023-06-14 00:22:56',X'61646D696E','2023-06-11 08:32:34',X'','2023-06-13 16:22:55',NULL,1),
	(4,NULL,X'7A68303261646D696E',X'E7A79FE688B73032E7AEA1E79086E59198',X'3031',X'',X'',X'30',X'',X'243261243130244B386B74416B726F6776794B5145557731704856376533394D55766B69566C727732547754315232436B63334848774D4E6D4B5247',X'30',X'30',X'3132372E302E302E31','2023-06-11 17:06:10',X'61646D696E','2023-06-11 08:32:56',X'','2023-06-11 09:06:09',NULL,2);

/*!40000 ALTER TABLE `sys_user` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table sys_user_post
# ------------------------------------------------------------

DROP TABLE IF EXISTS `sys_user_post`;

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

LOCK TABLES `sys_user_post` WRITE;
/*!40000 ALTER TABLE `sys_user_post` DISABLE KEYS */;

INSERT INTO `sys_user_post` (`user_id`, `post_id`)
VALUES
	(1,1);

/*!40000 ALTER TABLE `sys_user_post` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table sys_user_role
# ------------------------------------------------------------

DROP TABLE IF EXISTS `sys_user_role`;

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

LOCK TABLES `sys_user_role` WRITE;
/*!40000 ALTER TABLE `sys_user_role` DISABLE KEYS */;

INSERT INTO `sys_user_role` (`user_id`, `role_id`)
VALUES
	(1,1);

/*!40000 ALTER TABLE `sys_user_role` ENABLE KEYS */;
UNLOCK TABLES;



/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;