1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456 |
- # ************************************************************
- # 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-18 10:19:43 +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`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC 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`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC 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`) USING BTREE,
- 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 ROW_FORMAT=DYNAMIC 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`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC 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`) USING BTREE,
- 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 ROW_FORMAT=DYNAMIC 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`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC 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`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC 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`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC 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`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC 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`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC 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`) USING BTREE,
- 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 ROW_FORMAT=DYNAMIC 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`) USING BTREE,
- 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 ROW_FORMAT=DYNAMIC 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`) USING BTREE,
- KEY `sched_name` (`sched_name`,`job_name`,`job_group`) USING BTREE,
- 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 ROW_FORMAT=DYNAMIC 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`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC 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 '更新时间',
- `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户ID',
- PRIMARY KEY (`dept_id`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC 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`, `tenant_id`)
- 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',NULL),
- (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',NULL),
- (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,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,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,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,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,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,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,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,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,NULL),
- (111,0,X'30',X'5A483031E585ACE58FB8',0,X'',X'',NULL,X'30',X'30',X'',NULL,X'7A68303161646D696E','2023-06-18 03:52:49',1),
- (112,111,X'302C313131',X'E58C97E4BAACE58886E585ACE58FB8',1,NULL,NULL,NULL,X'30',X'30',X'7A68303161646D696E','2023-06-17 16:27:49',X'',NULL,1),
- (113,111,X'302C313131',X'E4B88AE6B5B7E58886E585ACE58FB8',1,NULL,NULL,NULL,X'30',X'30',X'7A68303161646D696E','2023-06-18 01:54:28',X'7A68303161646D696E','2023-06-18 03:52:38',1),
- (114,111,X'302C313131',X'E58D97E4BAACE58886E585ACE58FB8',2,NULL,NULL,NULL,X'30',X'30',X'7A68303161646D696E','2023-06-18 01:58:30',X'7A68303161646D696E','2023-06-18 03:52:22',1),
- (115,111,X'302C313131',X'E6ADA6E6B189E58886E585ACE58FB8',2,NULL,NULL,NULL,X'30',X'30',X'7A68303161646D696E','2023-06-18 03:51:14',X'7A68303161646D696E','2023-06-18 03:52:27',1),
- (116,111,X'302C313131',X'E995BFE6B299E58886E585ACE58FB8',2,NULL,NULL,NULL,X'30',X'30',X'7A68303161646D696E','2023-06-18 03:52:02',X'7A68303161646D696E','2023-06-18 03:52:32',1);
- /*!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`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC 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`) USING BTREE,
- UNIQUE KEY `dict_type` (`dict_type`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC 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`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC 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`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC 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`) USING BTREE,
- KEY `idx_sys_logininfor_s` (`status`) USING BTREE,
- KEY `idx_sys_logininfor_lt` (`login_time`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC 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'),
- (198,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'57696E646F7773203130',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-16 13:57:32'),
- (199,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'57696E646F7773203130',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-16 14:02:34'),
- (200,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'57696E646F7773203130',X'30',X'E98080E587BAE68890E58A9F','2023-06-16 14:11:03'),
- (201,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'57696E646F7773203130',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-16 14:11:09'),
- (202,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'57696E646F7773203130',X'30',X'E98080E587BAE68890E58A9F','2023-06-16 15:02:14'),
- (203,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'57696E646F7773203130',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-16 15:02:16'),
- (204,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'57696E646F7773203130',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-16 15:28:44'),
- (205,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'57696E646F7773203130',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-16 15:29:44'),
- (206,X'61646D696E',X'3139322E3136382E3131302E3532',X'E58685E7BD914950',X'4368726F6D65203131',X'57696E646F7773203130',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-16 16:11:39'),
- (207,X'7A68303161646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-17 08:03:54'),
- (208,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-17 08:05:46'),
- (209,X'7A68303161646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-17 08:21:54'),
- (210,X'313233343536',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'31',X'E799BBE5BD95E794A8E688B7EFBC9A31323334353620E4B88DE5AD98E59CA8','2023-06-17 09:18:00'),
- (211,X'7A68303161646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-17 09:18:09'),
- (212,X'7A68303161646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'31',X'E5AF86E7A081E8BE93E585A5E99499E8AFAF31E6ACA1','2023-06-17 10:30:29'),
- (213,X'7A68303161646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'31',X'E794A8E688B7E4B88DE5AD98E59CA82FE5AF86E7A081E99499E8AFAF','2023-06-17 10:30:29'),
- (214,X'7A68303161646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-17 10:30:36'),
- (215,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-17 10:43:47'),
- (216,X'7A68303161646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'31',X'E794A8E688B7E4B88DE5AD98E59CA82FE5AF86E7A081E99499E8AFAF','2023-06-17 11:12:59'),
- (217,X'7A68303161646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'31',X'E5AF86E7A081E8BE93E585A5E99499E8AFAF31E6ACA1','2023-06-17 11:12:59'),
- (218,X'7A68303161646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-17 11:13:04'),
- (219,X'7A68303161646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-17 15:10:22'),
- (220,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-17 15:21:30'),
- (221,X'7A68303161646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-17 15:52:08'),
- (222,X'7A68303161646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-18 01:53:12'),
- (223,X'7A68303161646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'31',X'E5AF86E7A081E8BE93E585A5E99499E8AFAF31E6ACA1','2023-06-18 02:23:56'),
- (224,X'7A68303161646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'31',X'E794A8E688B7E4B88DE5AD98E59CA82FE5AF86E7A081E99499E8AFAF','2023-06-18 02:23:56'),
- (225,X'7A68303161646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-18 02:24:04'),
- (226,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-18 04:14:14'),
- (227,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-18 05:08:45'),
- (228,X'7A68303161646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-18 05:10:02'),
- (229,X'7A683031757365725F626A',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'31',X'E799BBE5BD95E794A8E688B7EFBC9A7A683031757365725F626A20E4B88DE5AD98E59CA8','2023-06-18 06:20:45'),
- (230,X'7A683031757365725F626A',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-18 06:21:21'),
- (231,X'7A68303161646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-18 06:23:45'),
- (232,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-18 07:35:56'),
- (233,X'7A68303161646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-18 07:41:31'),
- (234,X'61646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-18 07:56:34'),
- (235,X'7A68303161646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-18 08:23:19'),
- (236,X'7A68303261646D696E',X'3132372E302E302E31',X'E58685E7BD914950',X'4368726F6D65203131',X'4D6163204F532058',X'30',X'E799BBE5BD95E68890E58A9F','2023-06-18 10:15:49');
- /*!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`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC 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,6,X'687474703A2F2F72756F79692E766970',NULL,X'',0,0,X'4D',X'30',X'30',X'',X'6775696465',X'61646D696E','2023-05-25 16:54:10',X'61646D696E','2023-06-16 14:40:46',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''),
- (1073,X'E695B0E68DAEE5BC95E6938E',0,4,X'64617461',NULL,NULL,1,0,X'4D',X'30',X'30',X'',X'64726167',X'61646D696E','2023-06-16 14:31:40',X'61646D696E','2023-06-16 14:47:28',X''),
- (1074,X'E695B0E68DAEE6BA90E9858DE7BDAE',1073,1,X'64617461',X'73797374656D2F646174612F696E646578',NULL,1,0,X'43',X'30',X'30',X'',X'23',X'61646D696E','2023-06-16 14:33:35',X'61646D696E','2023-06-16 14:34:57',X''),
- (1075,X'E997A8E688B7E5BC95E6938E',0,5,X'706F7274616C456E67696E65',NULL,NULL,1,0,X'4D',X'30',X'30',X'',X'72656469732D6C697374',X'61646D696E','2023-06-16 14:38:37',X'61646D696E','2023-06-16 14:47:55',X''),
- (1076,X'E7A79FE688B7E7AEA1E79086',1075,1,X'706F7274616C456E67696E65',X'73797374656D2F506F7274616C456E67696E652F696E646578',NULL,1,0,X'43',X'30',X'30',NULL,X'23',X'61646D696E','2023-06-16 14:39:51',X'',NULL,X''),
- (1077,X'E5889BE5BBBAE695B0E68DAEE8A1A8',3,4,X'646174617368656574',NULL,NULL,1,0,X'4D',X'30',X'30',NULL,X'666F726D',X'61646D696E','2023-06-16 14:57:55',X'',NULL,X''),
- (1078,X'6D7973716CE695B0E68DAEE8A1A8',1077,1,X'646174617368656574',X'746F6F6C2F6461746173686565742F696E646578',NULL,1,0,X'43',X'30',X'30',NULL,X'646F63756D656E746174696F6E',X'61646D696E','2023-06-16 14:58:41',X'',NULL,X''),
- (1079,X'73716C736572766572E695B0E68DAEE8A1A8',1077,2,X'73716C736572766572',X'746F6F6C2F6461746173686565742F73716C536572766572',NULL,1,0,X'43',X'30',X'30',NULL,X'646F63756D656E746174696F6E',X'61646D696E','2023-06-16 14:59:13',X'',NULL,X''),
- (1080,X'E8BEBEE6A2A6E695B0E68DAEE8A1A8',1077,3,X'646D',X'746F6F6C2F6461746173686565742F646D',NULL,1,0,X'43',X'30',X'30',NULL,X'646F63756D656E746174696F6E',X'61646D696E','2023-06-16 14:59:41',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`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC 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`) USING BTREE,
- KEY `idx_sys_oper_log_bt` (`business_type`) USING BTREE,
- KEY `idx_sys_oper_log_s` (`status`) USING BTREE,
- KEY `idx_sys_oper_log_ot` (`oper_time`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC 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),
- (141,X'E88F9CE58D95E7AEA1E79086',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E5379734D656E75436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'61646D696E',NULL,X'2F73797374656D2F6D656E75',X'3132372E302E302E31',X'E58685E7BD914950',X'7B226368696C6472656E223A5B5D2C226372656174654279223A2261646D696E222C2269734361636865223A2230222C2269734672616D65223A2231222C226D656E754E616D65223A22E695B0E68DAEE5BA93E5BC95E6938E222C226D656E7554797065223A224D222C226F726465724E756D223A342C22706172616D73223A7B7D2C22706172656E744964223A302C2270617468223A2273222C22737461747573223A2230222C2276697369626C65223A2230227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-16 14:31:40',31),
- (142,X'E88F9CE58D95E7AEA1E79086',2,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E5379734D656E75436F6E74726F6C6C65722E656469742829',X'505554',1,X'61646D696E',NULL,X'2F73797374656D2F6D656E75',X'3132372E302E302E31',X'E58685E7BD914950',X'7B226368696C6472656E223A5B5D2C2263726561746554696D65223A22323032332D30362D31362031343A33313A3430222C2269636F6E223A2223222C2269734361636865223A2230222C2269734672616D65223A2231222C226D656E754964223A313037332C226D656E754E616D65223A22E695B0E68DAEE5BA93E5BC95E6938E222C226D656E7554797065223A224D222C226F726465724E756D223A342C22706172616D73223A7B7D2C22706172656E744964223A302C2270617468223A2264617461222C227065726D73223A22222C22737461747573223A2230222C227570646174654279223A2261646D696E222C2276697369626C65223A2230227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-16 14:32:38',20),
- (143,X'E88F9CE58D95E7AEA1E79086',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E5379734D656E75436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'61646D696E',NULL,X'2F73797374656D2F6D656E75',X'3132372E302E302E31',X'E58685E7BD914950',X'7B226368696C6472656E223A5B5D2C226372656174654279223A2261646D696E222C2269734361636865223A2230222C2269734672616D65223A2231222C226D656E754E616D65223A22E695B0E68DAEE6BA90E9858DE7BDAE222C226D656E7554797065223A2243222C226F726465724E756D223A312C22706172616D73223A7B7D2C22706172656E744964223A313037332C2270617468223A2273797374656D2F646174612F696E646578222C22737461747573223A2230222C2276697369626C65223A2230227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-16 14:33:35',23),
- (144,X'E88F9CE58D95E7AEA1E79086',2,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E5379734D656E75436F6E74726F6C6C65722E656469742829',X'505554',1,X'61646D696E',NULL,X'2F73797374656D2F6D656E75',X'3132372E302E302E31',X'E58685E7BD914950',X'7B226368696C6472656E223A5B5D2C22636F6D706F6E656E74223A2273797374656D2F646174612F696E646578222C2263726561746554696D65223A22323032332D30362D31362031343A33333A3335222C2269636F6E223A2223222C2269734361636865223A2230222C2269734672616D65223A2231222C226D656E754964223A313037342C226D656E754E616D65223A22E695B0E68DAEE6BA90E9858DE7BDAE222C226D656E7554797065223A2243222C226F726465724E756D223A312C22706172616D73223A7B7D2C22706172656E744964223A313037332C2270617468223A2264617461222C227065726D73223A22222C22737461747573223A2230222C227570646174654279223A2261646D696E222C2276697369626C65223A2230227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-16 14:34:57',21),
- (145,X'E88F9CE58D95E7AEA1E79086',2,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E5379734D656E75436F6E74726F6C6C65722E656469742829',X'505554',1,X'61646D696E',NULL,X'2F73797374656D2F6D656E75',X'3132372E302E302E31',X'E58685E7BD914950',X'7B226368696C6472656E223A5B5D2C2263726561746554696D65223A22323032332D30362D31362031343A33313A3430222C2269636F6E223A2223222C2269734361636865223A2230222C2269734672616D65223A2231222C226D656E754964223A313037332C226D656E754E616D65223A22E695B0E68DAEE5BC95E6938E222C226D656E7554797065223A224D222C226F726465724E756D223A342C22706172616D73223A7B7D2C22706172656E744964223A302C2270617468223A2264617461222C227065726D73223A22222C22737461747573223A2230222C227570646174654279223A2261646D696E222C2276697369626C65223A2230227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-16 14:37:43',116),
- (146,X'E88F9CE58D95E7AEA1E79086',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E5379734D656E75436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'61646D696E',NULL,X'2F73797374656D2F6D656E75',X'3132372E302E302E31',X'E58685E7BD914950',X'7B226368696C6472656E223A5B5D2C226372656174654279223A2261646D696E222C2269734361636865223A2230222C2269734672616D65223A2231222C226D656E754E616D65223A22E997A8E688B7E5BC95E6938E222C226D656E7554797065223A224D222C226F726465724E756D223A362C22706172616D73223A7B7D2C22706172656E744964223A302C2270617468223A22706F7274616C456E67696E65222C22737461747573223A2230222C2276697369626C65223A2230227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-16 14:38:37',22),
- (147,X'E88F9CE58D95E7AEA1E79086',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E5379734D656E75436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'61646D696E',NULL,X'2F73797374656D2F6D656E75',X'3132372E302E302E31',X'E58685E7BD914950',X'7B226368696C6472656E223A5B5D2C22636F6D706F6E656E74223A2273797374656D2F506F7274616C456E67696E652F696E646578222C226372656174654279223A2261646D696E222C2269734361636865223A2230222C2269734672616D65223A2231222C226D656E754E616D65223A22E7A79FE688B7E7AEA1E79086222C226D656E7554797065223A2243222C226F726465724E756D223A312C22706172616D73223A7B7D2C22706172656E744964223A313037352C2270617468223A22706F7274616C456E67696E65222C22737461747573223A2230222C2276697369626C65223A2230227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-16 14:39:51',71),
- (148,X'E88F9CE58D95E7AEA1E79086',2,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E5379734D656E75436F6E74726F6C6C65722E656469742829',X'505554',1,X'61646D696E',NULL,X'2F73797374656D2F6D656E75',X'3132372E302E302E31',X'E58685E7BD914950',X'7B226368696C6472656E223A5B5D2C2263726561746554696D65223A22323032332D30352D32352031363A35343A3130222C2269636F6E223A226775696465222C2269734361636865223A2230222C2269734672616D65223A2230222C226D656E754964223A342C226D656E754E616D65223A22E88BA5E4BE9DE5AE98E7BD91222C226D656E7554797065223A224D222C226F726465724E756D223A362C22706172616D73223A7B7D2C22706172656E744964223A302C2270617468223A22687474703A2F2F72756F79692E766970222C227065726D73223A22222C227175657279223A22222C22737461747573223A2230222C227570646174654279223A2261646D696E222C2276697369626C65223A2230227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-16 14:40:46',29),
- (149,X'E88F9CE58D95E7AEA1E79086',2,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E5379734D656E75436F6E74726F6C6C65722E656469742829',X'505554',1,X'61646D696E',NULL,X'2F73797374656D2F6D656E75',X'3132372E302E302E31',X'E58685E7BD914950',X'7B226368696C6472656E223A5B5D2C2263726561746554696D65223A22323032332D30362D31362031343A33383A3337222C2269636F6E223A2223222C2269734361636865223A2230222C2269734672616D65223A2231222C226D656E754964223A313037352C226D656E754E616D65223A22E997A8E688B7E5BC95E6938E222C226D656E7554797065223A224D222C226F726465724E756D223A352C22706172616D73223A7B7D2C22706172656E744964223A302C2270617468223A22706F7274616C456E67696E65222C227065726D73223A22222C22737461747573223A2230222C227570646174654279223A2261646D696E222C2276697369626C65223A2230227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-16 14:41:01',20),
- (150,X'E88F9CE58D95E7AEA1E79086',2,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E5379734D656E75436F6E74726F6C6C65722E656469742829',X'505554',1,X'61646D696E',NULL,X'2F73797374656D2F6D656E75',X'3132372E302E302E31',X'E58685E7BD914950',X'7B226368696C6472656E223A5B5D2C2263726561746554696D65223A22323032332D30362D31362031343A33313A3430222C2269636F6E223A2264726167222C2269734361636865223A2230222C2269734672616D65223A2231222C226D656E754964223A313037332C226D656E754E616D65223A22E695B0E68DAEE5BC95E6938E222C226D656E7554797065223A224D222C226F726465724E756D223A342C22706172616D73223A7B7D2C22706172656E744964223A302C2270617468223A2264617461222C227065726D73223A22222C22737461747573223A2230222C227570646174654279223A2261646D696E222C2276697369626C65223A2230227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-16 14:47:28',19),
- (151,X'E88F9CE58D95E7AEA1E79086',2,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E5379734D656E75436F6E74726F6C6C65722E656469742829',X'505554',1,X'61646D696E',NULL,X'2F73797374656D2F6D656E75',X'3132372E302E302E31',X'E58685E7BD914950',X'7B226368696C6472656E223A5B5D2C2263726561746554696D65223A22323032332D30362D31362031343A33383A3337222C2269636F6E223A2272656469732D6C697374222C2269734361636865223A2230222C2269734672616D65223A2231222C226D656E754964223A313037352C226D656E754E616D65223A22E997A8E688B7E5BC95E6938E222C226D656E7554797065223A224D222C226F726465724E756D223A352C22706172616D73223A7B7D2C22706172656E744964223A302C2270617468223A22706F7274616C456E67696E65222C227065726D73223A22222C22737461747573223A2230222C227570646174654279223A2261646D696E222C2276697369626C65223A2230227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-16 14:47:55',17),
- (152,X'E88F9CE58D95E7AEA1E79086',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E5379734D656E75436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'61646D696E',NULL,X'2F73797374656D2F6D656E75',X'3132372E302E302E31',X'E58685E7BD914950',X'7B226368696C6472656E223A5B5D2C226372656174654279223A2261646D696E222C2269636F6E223A22666F726D222C2269734361636865223A2230222C2269734672616D65223A2231222C226D656E754E616D65223A22E5889BE5BBBAE695B0E68DAEE8A1A8222C226D656E7554797065223A224D222C226F726465724E756D223A342C22706172616D73223A7B7D2C22706172656E744964223A332C2270617468223A22646174617368656574222C22737461747573223A2230222C2276697369626C65223A2230227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-16 14:57:55',27),
- (153,X'E88F9CE58D95E7AEA1E79086',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E5379734D656E75436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'61646D696E',NULL,X'2F73797374656D2F6D656E75',X'3132372E302E302E31',X'E58685E7BD914950',X'7B226368696C6472656E223A5B5D2C22636F6D706F6E656E74223A22746F6F6C2F6461746173686565742F696E646578222C226372656174654279223A2261646D696E222C2269636F6E223A22646F63756D656E746174696F6E222C2269734361636865223A2230222C2269734672616D65223A2231222C226D656E754E616D65223A226D7973716CE695B0E68DAEE8A1A8222C226D656E7554797065223A2243222C226F726465724E756D223A312C22706172616D73223A7B7D2C22706172656E744964223A313037372C2270617468223A22646174617368656574222C227065726D73223A22222C22737461747573223A2230222C2276697369626C65223A2230227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-16 14:58:41',14),
- (154,X'E88F9CE58D95E7AEA1E79086',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E5379734D656E75436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'61646D696E',NULL,X'2F73797374656D2F6D656E75',X'3132372E302E302E31',X'E58685E7BD914950',X'7B226368696C6472656E223A5B5D2C22636F6D706F6E656E74223A22746F6F6C2F6461746173686565742F73716C536572766572222C226372656174654279223A2261646D696E222C2269636F6E223A22646F63756D656E746174696F6E222C2269734361636865223A2230222C2269734672616D65223A2231222C226D656E754E616D65223A2273716C736572766572E695B0E68DAEE8A1A8222C226D656E7554797065223A2243222C226F726465724E756D223A322C22706172616D73223A7B7D2C22706172656E744964223A313037372C2270617468223A2273716C736572766572222C227065726D73223A22222C22737461747573223A2230222C2276697369626C65223A2230227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-16 14:59:13',17),
- (155,X'E88F9CE58D95E7AEA1E79086',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E5379734D656E75436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'61646D696E',NULL,X'2F73797374656D2F6D656E75',X'3132372E302E302E31',X'E58685E7BD914950',X'7B226368696C6472656E223A5B5D2C22636F6D706F6E656E74223A22746F6F6C2F6461746173686565742F646D222C226372656174654279223A2261646D696E222C2269636F6E223A22646F63756D656E746174696F6E222C2269734361636865223A2230222C2269734672616D65223A2231222C226D656E754E616D65223A22E8BEBEE6A2A6E695B0E68DAEE8A1A8222C226D656E7554797065223A2243222C226F726465724E756D223A332C22706172616D73223A7B7D2C22706172656E744964223A313037372C2270617468223A22646D222C22737461747573223A2230222C2276697369626C65223A2230227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-16 14:59:41',17),
- (156,X'E983A8E997A8E7AEA1E79086',2,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797344657074436F6E74726F6C6C65722E656469742829',X'505554',1,X'7A68303161646D696E',NULL,X'2F73797374656D2F64657074',X'3132372E302E302E31',X'E58685E7BD914950',X'7B22616E636573746F7273223A2230222C226368696C6472656E223A5B5D2C22646570744964223A3131312C22646570744E616D65223A225A483031E585ACE58FB832222C226C6561646572223A22222C226F726465724E756D223A302C22706172616D73223A7B7D2C22706172656E744964223A302C2270686F6E65223A22222C22737461747573223A2230222C227570646174654279223A227A68303161646D696E227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-17 16:26:55',107),
- (157,X'E983A8E997A8E7AEA1E79086',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797344657074436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'7A68303161646D696E',NULL,X'2F73797374656D2F64657074',X'3132372E302E302E31',X'E58685E7BD914950',X'7B22616E636573746F7273223A22302C313131222C226368696C6472656E223A5B5D2C226372656174654279223A227A68303161646D696E222C22646570744E616D65223A22E58C97E4BAACE58886E585ACE58FB8222C226F726465724E756D223A312C22706172616D73223A7B7D2C22706172656E744964223A3131312C22737461747573223A2230227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-17 16:27:49',90),
- (158,X'E983A8E997A8E7AEA1E79086',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797344657074436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'7A68303161646D696E',NULL,X'2F73797374656D2F64657074',X'3132372E302E302E31',X'E58685E7BD914950',X'7B22616E636573746F7273223A22302C313131222C226368696C6472656E223A5B5D2C226372656174654279223A227A68303161646D696E222C22646570744E616D65223A22E4B88AE6B5B7E58886E585ACE58FB8222C226F726465724E756D223A322C22706172616D73223A7B7D2C22706172656E744964223A3131312C22737461747573223A2230227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-18 01:54:28',102),
- (159,X'E983A8E997A8E7AEA1E79086',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797344657074436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'7A68303161646D696E',NULL,X'2F73797374656D2F64657074',X'3132372E302E302E31',X'E58685E7BD914950',X'7B22616E636573746F7273223A22302C313131222C226368696C6472656E223A5B5D2C226372656174654279223A227A68303161646D696E222C22646570744E616D65223A22E58D97E4BAACE58886E585ACE58FB8222C226F726465724E756D223A312C22706172616D73223A7B7D2C22706172656E744964223A3131312C22737461747573223A2230222C2274656E616E744964223A317D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-18 01:58:30',634),
- (160,X'E983A8E997A8E7AEA1E79086',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797344657074436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'7A68303161646D696E',NULL,X'2F73797374656D2F64657074',X'3132372E302E302E31',X'E58685E7BD914950',X'7B22616E636573746F7273223A22302C313131222C226368696C6472656E223A5B5D2C226372656174654279223A227A68303161646D696E222C22646570744E616D65223A22E6ADA6E6B189E58886E585ACE58FB8222C226F726465724E756D223A312C22706172616D73223A7B7D2C22706172656E744964223A3131312C22737461747573223A2230222C2274656E616E744964223A317D',NULL,1,X'6E657374656420657863657074696F6E206973206F72672E6170616368652E6962617469732E7265666C656374696F6E2E5265666C656374696F6E457863657074696F6E3A205468657265206973206E6F2067657474657220666F722070726F7065727479206E616D6564202774656E616E745F69642720696E2027636C61737320636F6D2E72756F79692E636F6D6D6F6E2E636F72652E646F6D61696E2E656E746974792E5379734465707427','2023-06-18 02:02:06',66),
- (161,X'E983A8E997A8E7AEA1E79086',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797344657074436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'7A68303161646D696E',NULL,X'2F73797374656D2F64657074',X'3132372E302E302E31',X'E58685E7BD914950',X'7B22616E636573746F7273223A22302C313131222C226368696C6472656E223A5B5D2C226372656174654279223A227A68303161646D696E222C22646570744E616D65223A22E6ADA6E6B189E58886E585ACE58FB8222C226F726465724E756D223A312C22706172616D73223A7B7D2C22706172656E744964223A3131312C22737461747573223A2230222C2274656E616E744964223A317D',NULL,1,X'6E657374656420657863657074696F6E206973206F72672E6170616368652E6962617469732E7265666C656374696F6E2E5265666C656374696F6E457863657074696F6E3A205468657265206973206E6F2067657474657220666F722070726F7065727479206E616D6564202774656E616E745F69642720696E2027636C61737320636F6D2E72756F79692E636F6D6D6F6E2E636F72652E646F6D61696E2E656E746974792E5379734465707427','2023-06-18 02:24:28',42),
- (162,X'E983A8E997A8E7AEA1E79086',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797344657074436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'7A68303161646D696E',NULL,X'2F73797374656D2F64657074',X'3132372E302E302E31',X'E58685E7BD914950',X'7B22616E636573746F7273223A22302C313131222C226368696C6472656E223A5B5D2C226372656174654279223A227A68303161646D696E222C22646570744E616D65223A22E6ADA6E6B189E58886E585ACE58FB8222C226F726465724E756D223A312C22706172616D73223A7B7D2C22706172656E744964223A3131312C22737461747573223A2230222C2274656E616E744964223A317D',NULL,1,X'6E657374656420657863657074696F6E206973206F72672E6170616368652E6962617469732E7265666C656374696F6E2E5265666C656374696F6E457863657074696F6E3A205468657265206973206E6F2067657474657220666F722070726F7065727479206E616D6564202774656E616E745F69642720696E2027636C61737320636F6D2E72756F79692E636F6D6D6F6E2E636F72652E646F6D61696E2E656E746974792E5379734465707427','2023-06-18 02:32:32',422),
- (163,X'E983A8E997A8E7AEA1E79086',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797344657074436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'7A68303161646D696E',NULL,X'2F73797374656D2F64657074',X'3132372E302E302E31',X'E58685E7BD914950',X'7B22616E636573746F7273223A22302C313131222C226368696C6472656E223A5B5D2C226372656174654279223A227A68303161646D696E222C22646570744E616D65223A22E6ADA6E6B189E58886E585ACE58FB8222C226F726465724E756D223A312C22706172616D73223A7B7D2C22706172656E744964223A3131312C22737461747573223A2230222C2274656E616E744964223A317D',NULL,1,X'6E657374656420657863657074696F6E206973206F72672E6170616368652E6962617469732E7265666C656374696F6E2E5265666C656374696F6E457863657074696F6E3A205468657265206973206E6F2067657474657220666F722070726F7065727479206E616D6564202774656E616E745F69642720696E2027636C61737320636F6D2E72756F79692E636F6D6D6F6E2E636F72652E646F6D61696E2E656E746974792E5379734465707427','2023-06-18 02:34:18',92),
- (164,X'E983A8E997A8E7AEA1E79086',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797344657074436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'7A68303161646D696E',NULL,X'2F73797374656D2F64657074',X'3132372E302E302E31',X'E58685E7BD914950',X'7B22616E636573746F7273223A22302C313131222C226368696C6472656E223A5B5D2C226372656174654279223A227A68303161646D696E222C22646570744E616D65223A22E6ADA6E6B189E58886E585ACE58FB8222C226F726465724E756D223A312C22706172616D73223A7B7D2C22706172656E744964223A3131312C22737461747573223A2230222C2274656E616E744964223A317D',NULL,1,X'6E657374656420657863657074696F6E206973206F72672E6170616368652E6962617469732E7265666C656374696F6E2E5265666C656374696F6E457863657074696F6E3A205468657265206973206E6F2067657474657220666F722070726F7065727479206E616D6564202774656E616E745F69642720696E2027636C61737320636F6D2E72756F79692E636F6D6D6F6E2E636F72652E646F6D61696E2E656E746974792E5379734465707427','2023-06-18 02:47:50',138),
- (165,X'E983A8E997A8E7AEA1E79086',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797344657074436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'7A68303161646D696E',NULL,X'2F73797374656D2F64657074',X'3132372E302E302E31',X'E58685E7BD914950',X'7B22616E636573746F7273223A22302C313131222C226368696C6472656E223A5B5D2C226372656174654279223A227A68303161646D696E222C22646570744E616D65223A22E6ADA6E6B189E58886E585ACE58FB8222C226F726465724E756D223A312C22706172616D73223A7B7D2C22706172656E744964223A3131312C22737461747573223A2230222C2274656E616E744964223A317D',NULL,1,X'6E657374656420657863657074696F6E206973206F72672E6170616368652E6962617469732E7265666C656374696F6E2E5265666C656374696F6E457863657074696F6E3A205468657265206973206E6F2067657474657220666F722070726F7065727479206E616D6564202774656E616E745F69642720696E2027636C61737320636F6D2E72756F79692E636F6D6D6F6E2E636F72652E646F6D61696E2E656E746974792E5379734465707427','2023-06-18 02:51:04',140),
- (166,X'E983A8E997A8E7AEA1E79086',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797344657074436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'7A68303161646D696E',NULL,X'2F73797374656D2F64657074',X'3132372E302E302E31',X'E58685E7BD914950',X'7B22616E636573746F7273223A22302C313131222C226368696C6472656E223A5B5D2C226372656174654279223A227A68303161646D696E222C22646570744E616D65223A22E6ADA6E6B189E58886E585ACE58FB8222C226F726465724E756D223A312C22706172616D73223A7B7D2C22706172656E744964223A3131312C22737461747573223A2230222C2274656E616E744964223A317D',NULL,1,X'6E657374656420657863657074696F6E206973206F72672E6170616368652E6962617469732E7265666C656374696F6E2E5265666C656374696F6E457863657074696F6E3A205468657265206973206E6F2067657474657220666F722070726F7065727479206E616D6564202774656E616E745F69642720696E2027636C61737320636F6D2E72756F79692E636F6D6D6F6E2E636F72652E646F6D61696E2E656E746974792E5379734465707427','2023-06-18 02:52:33',207),
- (167,X'E983A8E997A8E7AEA1E79086',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797344657074436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'7A68303161646D696E',NULL,X'2F73797374656D2F64657074',X'3132372E302E302E31',X'E58685E7BD914950',X'7B22616E636573746F7273223A22302C313131222C226368696C6472656E223A5B5D2C226372656174654279223A227A68303161646D696E222C22646570744E616D65223A22E6ADA6E6B189E58886E585ACE58FB8222C226F726465724E756D223A312C22706172616D73223A7B7D2C22706172656E744964223A3131312C22737461747573223A2230222C2274656E616E744964223A317D',NULL,1,X'6E657374656420657863657074696F6E206973206F72672E6170616368652E6962617469732E7265666C656374696F6E2E5265666C656374696F6E457863657074696F6E3A205468657265206973206E6F2067657474657220666F722070726F7065727479206E616D6564202774656E616E745F69642720696E2027636C61737320636F6D2E72756F79692E636F6D6D6F6E2E636F72652E646F6D61696E2E656E746974792E5379734465707427','2023-06-18 02:55:23',312),
- (168,X'E983A8E997A8E7AEA1E79086',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797344657074436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'7A68303161646D696E',NULL,X'2F73797374656D2F64657074',X'3132372E302E302E31',X'E58685E7BD914950',X'7B22616E636573746F7273223A22302C313131222C226368696C6472656E223A5B5D2C226372656174654279223A227A68303161646D696E222C22646570744E616D65223A22E6ADA6E6B189E58886E585ACE58FB8222C226F726465724E756D223A312C22706172616D73223A7B7D2C22706172656E744964223A3131312C22737461747573223A2230222C2274656E616E744964223A317D',NULL,1,X'6E657374656420657863657074696F6E206973206F72672E6170616368652E6962617469732E7265666C656374696F6E2E5265666C656374696F6E457863657074696F6E3A205468657265206973206E6F2067657474657220666F722070726F7065727479206E616D6564202774656E616E745F69642720696E2027636C61737320636F6D2E72756F79692E636F6D6D6F6E2E636F72652E646F6D61696E2E656E746974792E5379734465707427','2023-06-18 03:05:03',160),
- (169,X'E983A8E997A8E7AEA1E79086',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797344657074436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'7A68303161646D696E',NULL,X'2F73797374656D2F64657074',X'3132372E302E302E31',X'E58685E7BD914950',X'7B22616E636573746F7273223A22302C313131222C226368696C6472656E223A5B5D2C226372656174654279223A227A68303161646D696E222C22646570744E616D65223A22E6ADA6E6B189E58886E585ACE58FB8222C226F726465724E756D223A312C22706172616D73223A7B7D2C22706172656E744964223A3131312C22737461747573223A2230222C2274656E616E744964223A317D',NULL,1,X'6E657374656420657863657074696F6E206973206F72672E6170616368652E6962617469732E7265666C656374696F6E2E5265666C656374696F6E457863657074696F6E3A205468657265206973206E6F2067657474657220666F722070726F7065727479206E616D6564202774656E616E745F69642720696E2027636C61737320636F6D2E72756F79692E636F6D6D6F6E2E636F72652E646F6D61696E2E656E746974792E5379734465707427','2023-06-18 03:08:16',115),
- (170,X'E983A8E997A8E7AEA1E79086',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797344657074436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'7A68303161646D696E',NULL,X'2F73797374656D2F64657074',X'3132372E302E302E31',X'E58685E7BD914950',X'7B22616E636573746F7273223A22302C313131222C226368696C6472656E223A5B5D2C226372656174654279223A227A68303161646D696E222C22646570744E616D65223A22E6ADA6E6B189E58886E585ACE58FB8222C226F726465724E756D223A312C22706172616D73223A7B7D2C22706172656E744964223A3131312C22737461747573223A2230222C2274656E616E744964223A317D',NULL,1,X'6E657374656420657863657074696F6E206973206F72672E6170616368652E6962617469732E7265666C656374696F6E2E5265666C656374696F6E457863657074696F6E3A205468657265206973206E6F2067657474657220666F722070726F7065727479206E616D6564202774656E616E745F69642720696E2027636C61737320636F6D2E72756F79692E636F6D6D6F6E2E636F72652E646F6D61696E2E656E746974792E5379734465707427','2023-06-18 03:09:28',107),
- (171,X'E983A8E997A8E7AEA1E79086',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797344657074436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'7A68303161646D696E',NULL,X'2F73797374656D2F64657074',X'3132372E302E302E31',X'E58685E7BD914950',X'7B22616E636573746F7273223A22302C313131222C226368696C6472656E223A5B5D2C226372656174654279223A227A68303161646D696E222C22646570744E616D65223A22E6ADA6E6B189E58886E585ACE58FB8222C226F726465724E756D223A312C22706172616D73223A7B7D2C22706172656E744964223A3131312C22737461747573223A2230222C2274656E616E744964223A317D',NULL,1,X'6E657374656420657863657074696F6E206973206F72672E6170616368652E6962617469732E7265666C656374696F6E2E5265666C656374696F6E457863657074696F6E3A205468657265206973206E6F2067657474657220666F722070726F7065727479206E616D6564202774656E616E745F69642720696E2027636C61737320636F6D2E72756F79692E636F6D6D6F6E2E636F72652E646F6D61696E2E656E746974792E5379734465707427','2023-06-18 03:11:15',143),
- (172,X'E983A8E997A8E7AEA1E79086',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797344657074436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'7A68303161646D696E',NULL,X'2F73797374656D2F64657074',X'3132372E302E302E31',X'E58685E7BD914950',X'7B22616E636573746F7273223A22302C313131222C226368696C6472656E223A5B5D2C226372656174654279223A227A68303161646D696E222C22646570744E616D65223A22E6ADA6E6B189E58886E585ACE58FB8222C226F726465724E756D223A312C22706172616D73223A7B7D2C22706172656E744964223A3131312C22737461747573223A2230222C2274656E616E744964223A317D',NULL,1,X'6E657374656420657863657074696F6E206973206F72672E6170616368652E6962617469732E7265666C656374696F6E2E5265666C656374696F6E457863657074696F6E3A205468657265206973206E6F2067657474657220666F722070726F7065727479206E616D6564202774656E616E745F69642720696E2027636C61737320636F6D2E72756F79692E636F6D6D6F6E2E636F72652E646F6D61696E2E656E746974792E5379734465707427','2023-06-18 03:13:39',110),
- (173,X'E983A8E997A8E7AEA1E79086',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797344657074436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'7A68303161646D696E',NULL,X'2F73797374656D2F64657074',X'3132372E302E302E31',X'E58685E7BD914950',X'7B22616E636573746F7273223A22302C313131222C226368696C6472656E223A5B5D2C226372656174654279223A227A68303161646D696E222C22646570744E616D65223A22E6ADA6E6B189E58886E585ACE58FB8222C226F726465724E756D223A312C22706172616D73223A7B7D2C22706172656E744964223A3131312C22737461747573223A2230222C2274656E616E744964223A317D',NULL,1,X'6E657374656420657863657074696F6E206973206F72672E6170616368652E6962617469732E7265666C656374696F6E2E5265666C656374696F6E457863657074696F6E3A205468657265206973206E6F2067657474657220666F722070726F7065727479206E616D6564202774656E616E745F69642720696E2027636C61737320636F6D2E72756F79692E636F6D6D6F6E2E636F72652E646F6D61696E2E656E746974792E5379734465707427','2023-06-18 03:19:52',49),
- (174,X'E983A8E997A8E7AEA1E79086',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797344657074436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'7A68303161646D696E',NULL,X'2F73797374656D2F64657074',X'3132372E302E302E31',X'E58685E7BD914950',X'7B22616E636573746F7273223A22302C313131222C226368696C6472656E223A5B5D2C226372656174654279223A227A68303161646D696E222C22646570744E616D65223A22E6ADA6E6B189E58886E585ACE58FB8222C226F726465724E756D223A312C22706172616D73223A7B7D2C22706172656E744964223A3131312C22737461747573223A2230222C2274656E616E744964223A317D',NULL,1,X'6E657374656420657863657074696F6E206973206F72672E6170616368652E6962617469732E7265666C656374696F6E2E5265666C656374696F6E457863657074696F6E3A205468657265206973206E6F2067657474657220666F722070726F7065727479206E616D6564202774656E616E745F69642720696E2027636C61737320636F6D2E72756F79692E636F6D6D6F6E2E636F72652E646F6D61696E2E656E746974792E5379734465707427','2023-06-18 03:42:52',216034),
- (175,X'E983A8E997A8E7AEA1E79086',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797344657074436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'7A68303161646D696E',NULL,X'2F73797374656D2F64657074',X'3132372E302E302E31',X'E58685E7BD914950',X'7B22616E636573746F7273223A22302C313131222C226368696C6472656E223A5B5D2C226372656174654279223A227A68303161646D696E222C22646570744E616D65223A22E6ADA6E6B189E58886E585ACE58FB8222C226F726465724E756D223A312C22706172616D73223A7B7D2C22706172656E744964223A3131312C22737461747573223A2230222C2274656E616E744964223A317D',NULL,1,X'6E657374656420657863657074696F6E206973206F72672E6170616368652E6962617469732E7265666C656374696F6E2E5265666C656374696F6E457863657074696F6E3A205468657265206973206E6F2067657474657220666F722070726F7065727479206E616D6564202774656E616E745F69642720696E2027636C61737320636F6D2E72756F79692E636F6D6D6F6E2E636F72652E646F6D61696E2E656E746974792E5379734465707427','2023-06-18 03:44:06',2838),
- (176,X'E983A8E997A8E7AEA1E79086',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797344657074436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'7A68303161646D696E',NULL,X'2F73797374656D2F64657074',X'3132372E302E302E31',X'E58685E7BD914950',X'7B22616E636573746F7273223A22302C313131222C226368696C6472656E223A5B5D2C226372656174654279223A227A68303161646D696E222C22646570744E616D65223A22E6ADA6E6B189E58886E585ACE58FB8222C226F726465724E756D223A312C22706172616D73223A7B7D2C22706172656E744964223A3131312C22737461747573223A2230222C2274656E616E744964223A317D',NULL,1,X'6E657374656420657863657074696F6E206973206F72672E6170616368652E6962617469732E7265666C656374696F6E2E5265666C656374696F6E457863657074696F6E3A205468657265206973206E6F2067657474657220666F722070726F7065727479206E616D6564202774656E616E745F69643131312720696E2027636C61737320636F6D2E72756F79692E636F6D6D6F6E2E636F72652E646F6D61696E2E656E746974792E5379734465707427','2023-06-18 03:46:03',110),
- (177,X'E983A8E997A8E7AEA1E79086',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797344657074436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'7A68303161646D696E',NULL,X'2F73797374656D2F64657074',X'3132372E302E302E31',X'E58685E7BD914950',X'7B22616E636573746F7273223A22302C313131222C226368696C6472656E223A5B5D2C226372656174654279223A227A68303161646D696E222C22646570744E616D65223A22E6ADA6E6B189E58886E585ACE58FB8222C226F726465724E756D223A312C22706172616D73223A7B7D2C22706172656E744964223A3131312C22737461747573223A2230222C2274656E616E744964223A317D',NULL,1,X'6E657374656420657863657074696F6E206973206F72672E6170616368652E6962617469732E7265666C656374696F6E2E5265666C656374696F6E457863657074696F6E3A205468657265206973206E6F2067657474657220666F722070726F7065727479206E616D6564202774656E616E745F69642720696E2027636C61737320636F6D2E72756F79692E636F6D6D6F6E2E636F72652E646F6D61696E2E656E746974792E5379734465707427','2023-06-18 03:49:09',109),
- (178,X'E983A8E997A8E7AEA1E79086',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797344657074436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'7A68303161646D696E',NULL,X'2F73797374656D2F64657074',X'3132372E302E302E31',X'E58685E7BD914950',X'7B22616E636573746F7273223A22302C313131222C226368696C6472656E223A5B5D2C226372656174654279223A227A68303161646D696E222C22646570744E616D65223A22E6ADA6E6B189E58886E585ACE58FB8222C226F726465724E756D223A312C22706172616D73223A7B7D2C22706172656E744964223A3131312C22737461747573223A2230222C2274656E616E744964223A317D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-18 03:51:14',82),
- (179,X'E983A8E997A8E7AEA1E79086',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797344657074436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'7A68303161646D696E',NULL,X'2F73797374656D2F64657074',X'3132372E302E302E31',X'E58685E7BD914950',X'7B22616E636573746F7273223A22302C313131222C226368696C6472656E223A5B5D2C226372656174654279223A227A68303161646D696E222C22646570744E616D65223A22E995BFE6B299E58886E585ACE58FB8222C226F726465724E756D223A312C22706172616D73223A7B7D2C22706172656E744964223A3131312C22737461747573223A2230222C2274656E616E744964223A317D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-18 03:52:02',40),
- (180,X'E983A8E997A8E7AEA1E79086',2,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797344657074436F6E74726F6C6C65722E656469742829',X'505554',1,X'7A68303161646D696E',NULL,X'2F73797374656D2F64657074',X'3132372E302E302E31',X'E58685E7BD914950',X'7B22616E636573746F7273223A22302C313131222C226368696C6472656E223A5B5D2C22646570744964223A3131342C22646570744E616D65223A22E58D97E4BAACE58886E585ACE58FB8222C226F726465724E756D223A322C22706172616D73223A7B7D2C22706172656E744964223A3131312C22706172656E744E616D65223A225A483031E585ACE58FB832222C22737461747573223A2230222C2274656E616E744964223A312C227570646174654279223A227A68303161646D696E227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-18 03:52:22',120),
- (181,X'E983A8E997A8E7AEA1E79086',2,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797344657074436F6E74726F6C6C65722E656469742829',X'505554',1,X'7A68303161646D696E',NULL,X'2F73797374656D2F64657074',X'3132372E302E302E31',X'E58685E7BD914950',X'7B22616E636573746F7273223A22302C313131222C226368696C6472656E223A5B5D2C22646570744964223A3131352C22646570744E616D65223A22E6ADA6E6B189E58886E585ACE58FB8222C226F726465724E756D223A322C22706172616D73223A7B7D2C22706172656E744964223A3131312C22706172656E744E616D65223A225A483031E585ACE58FB832222C22737461747573223A2230222C2274656E616E744964223A312C227570646174654279223A227A68303161646D696E227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-18 03:52:27',70),
- (182,X'E983A8E997A8E7AEA1E79086',2,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797344657074436F6E74726F6C6C65722E656469742829',X'505554',1,X'7A68303161646D696E',NULL,X'2F73797374656D2F64657074',X'3132372E302E302E31',X'E58685E7BD914950',X'7B22616E636573746F7273223A22302C313131222C226368696C6472656E223A5B5D2C22646570744964223A3131362C22646570744E616D65223A22E995BFE6B299E58886E585ACE58FB8222C226F726465724E756D223A322C22706172616D73223A7B7D2C22706172656E744964223A3131312C22706172656E744E616D65223A225A483031E585ACE58FB832222C22737461747573223A2230222C2274656E616E744964223A312C227570646174654279223A227A68303161646D696E227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-18 03:52:32',73),
- (183,X'E983A8E997A8E7AEA1E79086',2,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797344657074436F6E74726F6C6C65722E656469742829',X'505554',1,X'7A68303161646D696E',NULL,X'2F73797374656D2F64657074',X'3132372E302E302E31',X'E58685E7BD914950',X'7B22616E636573746F7273223A22302C313131222C226368696C6472656E223A5B5D2C22646570744964223A3131332C22646570744E616D65223A22E4B88AE6B5B7E58886E585ACE58FB8222C226F726465724E756D223A312C22706172616D73223A7B7D2C22706172656E744964223A3131312C22706172656E744E616D65223A225A483031E585ACE58FB832222C22737461747573223A2230222C2274656E616E744964223A312C227570646174654279223A227A68303161646D696E227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-18 03:52:38',63),
- (184,X'E983A8E997A8E7AEA1E79086',2,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797344657074436F6E74726F6C6C65722E656469742829',X'505554',1,X'7A68303161646D696E',NULL,X'2F73797374656D2F64657074',X'3132372E302E302E31',X'E58685E7BD914950',X'7B22616E636573746F7273223A2230222C226368696C6472656E223A5B5D2C22646570744964223A3131312C22646570744E616D65223A225A483031E585ACE58FB8222C226C6561646572223A22222C226F726465724E756D223A302C22706172616D73223A7B7D2C22706172656E744964223A302C2270686F6E65223A22222C22737461747573223A2230222C2274656E616E744964223A312C227570646174654279223A227A68303161646D696E227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-18 03:52:49',55),
- (185,X'E794A8E688B7E7AEA1E79086',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797355736572436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'7A68303161646D696E',NULL,X'2F73797374656D2F75736572',X'3132372E302E302E31',X'E58685E7BD914950',X'7B2261646D696E223A66616C73652C226372656174654279223A227A68303161646D696E222C22646570744964223A3131322C226E69636B4E616D65223A227A683031757365725F626A222C22706172616D73223A7B7D2C22706F7374496473223A5B5D2C22726F6C65496473223A5B5D2C22736578223A2230222C22737461747573223A2230222C2274656E616E7441646D696E223A66616C73652C22757365724964223A352C22757365724E616D65223A22E58C97E4BAACE59198E5B7A5227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-18 05:15:53',270),
- (186,X'E794A8E688B7E7AEA1E79086',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797355736572436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'7A68303161646D696E',NULL,X'2F73797374656D2F75736572',X'3132372E302E302E31',X'E58685E7BD914950',X'7B2261646D696E223A66616C73652C226372656174654279223A227A68303161646D696E222C226E69636B4E616D65223A22E7A79FE688B73031E6B58BE8AF95222C22706172616D73223A7B7D2C22706F7374496473223A5B5D2C22726F6C65496473223A5B5D2C22737461747573223A2230222C2274656E616E7441646D696E223A66616C73652C22757365724964223A362C22757365724E616D65223A227A68303174657374227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-18 07:48:47',222),
- (187,X'E794A8E688B7E7AEA1E79086',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797355736572436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'7A68303161646D696E',NULL,X'2F73797374656D2F75736572',X'3132372E302E302E31',X'E58685E7BD914950',X'7B2261646D696E223A66616C73652C226372656174654279223A227A68303161646D696E222C226E69636B4E616D65223A22E7A79FE688B73031E6B58BE8AF95E794A8E688B732222C22706172616D73223A7B7D2C22706F7374496473223A5B5D2C22726F6C65496473223A5B5D2C22737461747573223A2230222C2274656E616E7441646D696E223A66616C73652C2274656E616E744964223A312C22757365724964223A372C22757365724E616D65223A227A6830317465737432227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-18 08:24:18',216),
- (188,X'E794A8E688B7E7AEA1E79086',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797355736572436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'7A68303161646D696E',NULL,X'2F73797374656D2F75736572',X'3132372E302E302E31',X'E58685E7BD914950',X'7B2261646D696E223A66616C73652C226372656174654279223A227A68303161646D696E222C226E69636B4E616D65223A22E7A79FE688B73031E6B58BE8AF9533222C22706172616D73223A7B7D2C22706F7374496473223A5B5D2C22726F6C65496473223A5B5D2C22737461747573223A2230222C2274656E616E7441646D696E223A66616C73652C2274656E616E744964223A312C22757365724964223A382C22757365724E616D65223A227A6830317465737433227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-18 09:10:14',161),
- (189,X'E794A8E688B7E7AEA1E79086',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797355736572436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'7A68303161646D696E',NULL,X'2F73797374656D2F75736572',X'3132372E302E302E31',X'E58685E7BD914950',X'7B2261646D696E223A66616C73652C226372656174654279223A227A68303161646D696E222C226E69636B4E616D65223A22E7A79FE688B73031E6B58BE8AF95E794A8E688B734222C22706172616D73223A7B7D2C22706F7374496473223A5B5D2C22726F6C65496473223A5B5D2C22737461747573223A2230222C2274656E616E7441646D696E223A66616C73652C2274656E616E744964223A312C22757365724964223A392C22757365724E616D65223A227A6830317465737434227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-18 10:05:05',751),
- (190,X'E794A8E688B7E7AEA1E79086',1,X'636F6D2E72756F79692E7765622E636F6E74726F6C6C65722E73797374656D2E53797355736572436F6E74726F6C6C65722E6164642829',X'504F5354',1,X'7A68303261646D696E',NULL,X'2F73797374656D2F75736572',X'3132372E302E302E31',X'E58685E7BD914950',X'7B2261646D696E223A66616C73652C226372656174654279223A227A68303261646D696E222C226E69636B4E616D65223A22E7A79FE688B73032E6B58BE8AF95E794A8E688B731222C22706172616D73223A7B7D2C22706F7374496473223A5B5D2C22726F6C65496473223A5B5D2C22737461747573223A2230222C2274656E616E7441646D696E223A66616C73652C2274656E616E744964223A322C22757365724964223A31302C22757365724E616D65223A227A6830327465737431227D',X'7B226D7367223A22E6938DE4BD9CE68890E58A9F222C22636F6465223A3230307D',0,NULL,'2023-06-18 10:16:53',241);
- /*!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`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC 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`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC 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`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC 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`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC 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`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC 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`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC 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`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC 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-18 15:56:34',X'61646D696E','2023-05-25 16:54:10',X'','2023-06-18 07:56:34',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,111,X'7A68303161646D696E',X'E7A79FE688B73031E7AEA1E79086E59198',X'3031',X'',X'',X'30',X'',X'24326124313024755933462E794F2F626E447A2E657469636F704C572E6A45316A2E314276354B3973486A4B4659462E3946766E3570414F6F5A5A61',X'30',X'30',X'3132372E302E302E31','2023-06-18 16:23:19',X'61646D696E','2023-06-11 08:32:34',X'','2023-06-18 08:23:19',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-18 18:15:49',X'61646D696E','2023-06-11 08:32:56',X'','2023-06-18 10:15:48',NULL,2),
- (5,112,X'7A683031757365725F626A',X'E7A79FE688B730315FE58C97E4BAACE59198E5B7A5',X'3030',X'',X'',X'30',X'',X'24326124313024586A627075536236644D744E2F4A767A6B476D49564F38425341794D70496A47395654787767436D4154696A35372E67476C667A32',X'30',X'30',X'3132372E302E302E31','2023-06-18 14:21:22',X'7A68303161646D696E','2023-06-18 05:15:53',X'','2023-06-18 06:21:21',NULL,1),
- (6,111,X'7A68303174657374',X'E7A79FE688B73031E6B58BE8AF95',X'3030',X'',X'',X'30',X'',X'243261243130246A795859666678507164482E5A7A74364973795957654A6A7563574E424F756634566B4934414C426C6A716641324F5369744C4D43',X'30',X'30',X'',NULL,X'7A68303161646D696E','2023-06-18 07:48:47',X'',NULL,NULL,1),
- (7,111,X'7A6830317465737432',X'E7A79FE688B73031E6B58BE8AF95E794A8E688B732',X'3030',X'',X'',X'30',X'',X'243261243130246173502F6B48314A7262416E37484F534F50354F307578745749645A76426C39726E56714B6B732E4B2E3265794876724C61594A69',X'30',X'30',X'',NULL,X'7A68303161646D696E','2023-06-18 08:24:18',X'',NULL,NULL,1),
- (8,NULL,X'7A6830317465737433',X'E7A79FE688B73031E6B58BE8AF9533',X'3030',X'',X'',X'30',X'',X'24326124313024315151723974614D4275484B677A66306164412F37654555374F316E526E546367704B4F4A4B766F513076317372416E757A715443',X'30',X'30',X'',NULL,X'7A68303161646D696E','2023-06-18 09:10:14',X'',NULL,NULL,1),
- (9,NULL,X'7A6830317465737434',X'E7A79FE688B73031E6B58BE8AF95E794A8E688B734',X'3030',X'',X'',X'30',X'',X'24326124313024624A4B5564474D67534443316B4B706862644B334A2E53674344364F54454F6775794A734F75316B50626A54783865725176525275',X'30',X'30',X'',NULL,X'7A68303161646D696E','2023-06-18 10:05:05',X'',NULL,NULL,1),
- (10,NULL,X'7A6830327465737431',X'E7A79FE688B73032E6B58BE8AF95E794A8E688B731',X'3030',X'',X'',X'30',X'',X'2432612431302445395867454B6C4C4E644B4F48614F6548693545754F502E726253574E34505A305339556E71514849782E324C4461742F6A4E6B65',X'30',X'30',X'',NULL,X'7A68303261646D696E','2023-06-18 10:16:53',X'',NULL,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`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC 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`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC 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 */;
|