40 files changed, 0 insertions, 2232 deletions
diff --git a/nz-admin/db/2020-04-30.sql b/nz-admin/db/2020-04-30.sql
deleted file mode 100644
index 34b57a2c..00000000
--- a/nz-admin/db/2020-04-30.sql
+++ /dev/null
@@ -1,15 +0,0 @@
-/*
-   idc_traffic表结构变更
-   1. 增加字段如下： host、port、version、community、auth
-   2. 删除字段如下： asset_id
-*/
-
--- 增加字段
-alter table idc_traffic add column host varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ip地址';
-alter table idc_traffic add column port  int(10) NOT NULL COMMENT 'snmp端口 默认为161';
-alter table idc_traffic add column version int(1) NOT NULL COMMENT 'snmp版本 默认为2';
-alter table idc_traffic add column community varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'snmp团体名 默认为public';
-alter table idc_traffic add column auth varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'snmp认证信息 json格式';
-
--- 删除字段
-alter table idc_traffic drop asset_id;
-\ No newline at end of file
diff --git a/nz-admin/db/2020-05-06.sql b/nz-admin/db/2020-05-06.sql
deleted file mode 100644
index 276e2b79..00000000
--- a/nz-admin/db/2020-05-06.sql
+++ /dev/null
@@ -1,51 +0,0 @@
-/*
-   alert_rule表结构变更
-     1. 结构变更字段如下： receiver
-
-   conf_event表新增traffic数据
-
-   idc_traffic表增加 insert，update，delete 触发器，修改 conf_event 表 value值加一
-*/
-
-
--- 结构变更
-alter table alert_rule modify column receiver varchar(64);
-
--- conf_event 新增数据
-INSERT INTO `conf_event` VALUES ('idc_traffic', 0);
-
-
--- idc_traffic表新增 insert，update，delete 触发器
-
--- ----------------------------
--- Triggers structure for table idc_traffic
--- ----------------------------
-DROP TRIGGER IF EXISTS `tri_idc_traffic_insert`;
-delimiter ;;
-CREATE TRIGGER `tri_idc_traffic_insert` AFTER INSERT ON `idc_traffic` FOR EACH ROW begin
- update conf_event t set t.value = t.value +1 where t.table = 'idc_traffic';
-end
-;;
-delimiter ;
-
--- ----------------------------
--- Triggers structure for table idc_traffic
--- ----------------------------
-DROP TRIGGER IF EXISTS `tri_idc_traffic_update`;
-delimiter ;;
-CREATE TRIGGER `tri_idc_traffic_update` AFTER UPDATE ON `idc_traffic` FOR EACH ROW begin
- update conf_event t set t.value = t.value +1 where t.table = 'idc_traffic';
-end
-;;
-delimiter ;
-
--- ----------------------------
--- Triggers structure for table idc_traffic
--- ----------------------------
-DROP TRIGGER IF EXISTS `tri_idc_traffic_delete`;
-delimiter ;;
-CREATE TRIGGER `tri_idc_traffic_delete` AFTER DELETE ON `idc_traffic` FOR EACH ROW begin
- update conf_event t set t.value = t.value +1 where t.table = 'idc_traffic';
-end
-;;
-delimiter ;
-\ No newline at end of file
diff --git a/nz-admin/db/2020-05-12.sql b/nz-admin/db/2020-05-12.sql
deleted file mode 100644
index c2aa17d3..00000000
--- a/nz-admin/db/2020-05-12.sql
+++ /dev/null
@@ -1,11 +0,0 @@
-/*
-    sys_config 增加 测试邮件发送模板信息
-*/
-
--- 增加内置
-INSERT INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (NULL, 'test_email_send_template', '<html><head><meta http-equiv=\"content-type\" content=\"text/html; charset=UTF-8\"></head><body><div style=\"padding:40px 0; height:auto; min-height:100px; text-align:center;\"><span align=\"center\" style=\"margin:0 auto; min-width:290px; max-width:750px;\">Nezha test sending email.</span></div></body></html>', 1, NULL);
-
-/**
- *  sys_config 增加reset 表信息
- */
-INSERT INTO `sys_config`(`param_key`, `param_value`, `status`, `remark`) VALUES ('reset_table_infos', '[\"Delete from account\",\"Delete from alert_rule where build_in !=1 \",\"Delete from asset\",\"Delete from cabinet\",\"Delete from chart\",\"Delete from chart_element\",\"Delete from endpoint\",\"Delete from idc\",\"Delete from maintenance_record\",\"Delete from model\",\"Delete from module where build_in !=1 \",\"Delete from panel\",\"Delete from project where build_in !=1 \",\"Delete from prom_server\",\"Delete from snmp_mib\",\"Delete from sys_dict where type IN (\'assetType\',\'vendor\')\",\"Delete from idc_traffic\",\"Delete from sys_user where username!=\'admin\'\"]', 1, '清空项目数据信息');
-\ No newline at end of file
diff --git a/nz-admin/db/2020-05-15.sql b/nz-admin/db/2020-05-15.sql
deleted file mode 100644
index 47e49ef3..00000000
--- a/nz-admin/db/2020-05-15.sql
+++ /dev/null
@@ -1,24 +0,0 @@
-/*
-   panel表结构变更
-   1. 增加字段如下： type、link、build_in
-
-   chart表结构变更
-   1. 增加字段如下： pid、build_in
-
-   chart_element表结构变更
-   1. 增加字段如下： build_in
-*/
-
--- panel增加字段
-alter table panel add column type varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'dashboard' COMMENT 'panel类型 可选值：dashboard，asset，project，module，endpoint, model 默认值：dashboard';
-alter table panel add column link int(10) COMMENT '关联id, 当type ！= dashboard 时不能为空';
-alter table panel add column build_in char(1) NOT NULL DEFAULT '0' COMMENT '是否内置 1:内置，0：非内置，默认：0';
-
-
--- chart增加字段
-alter table chart add column pid int(10) COMMENT '模板id';
-alter table chart add column build_in char(1) NOT NULL DEFAULT '0' COMMENT '是否内置 1:内置，0：非内置，默认：0';
-
-
--- chart_element增加字段
-alter table chart_element add column build_in char(1) NOT NULL DEFAULT '0' COMMENT '是否内置 1:内置，0：非内置，默认：0';
-\ No newline at end of file
diff --git a/nz-admin/db/2020-05-18.sql b/nz-admin/db/2020-05-18.sql
deleted file mode 100644
index 658741b0..00000000
--- a/nz-admin/db/2020-05-18.sql
+++ /dev/null
@@ -1,6 +0,0 @@
-/*
-   sys_config 增加 model chart 模板字段
-*/
-
--- sys_config表增加数据
-INSERT INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (75, 'model_chart_tpl', '{\"title\":\"\",\"type\":\"line\",\"span\":12,\"height\":400,\"unit\":2,\"elements\":[{\"expression\":\"up\",\"type\":\"normal\"}]}', 1, NULL);
-\ No newline at end of file
diff --git a/nz-admin/db/2020-05-27.sql b/nz-admin/db/2020-05-27.sql
deleted file mode 100644
index f47993f3..00000000
--- a/nz-admin/db/2020-05-27.sql
+++ /dev/null
@@ -1,2 +0,0 @@
--- sys_dict 新增图表类型alertList
-INSERT INTO `sys_dict`(`name`, `type`, `code`, `value`, `i18n_code`, `order_num`, `remark`, `del_flag`, `operator`, `op_time`, `seq`) VALUES ( '图表类型', 'chartType', 7, 'alertList', '', 0, '告警', 0, 1, '2020-05-27 17:50:33', NULL);
diff --git a/nz-admin/db/2020-06-04.sql b/nz-admin/db/2020-06-04.sql
deleted file mode 100644
index 30154c60..00000000
--- a/nz-admin/db/2020-06-04.sql
+++ /dev/null
@@ -1,9 +0,0 @@
-/*
-    alert_rule表结构变更
-   1. 增加字段如下： operator、threshold、unit
-*/
-
--- alert_rule增加字段
-alter table alert_rule add column operator varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL  COMMENT '比较符号';
-alter table alert_rule add column threshold bigint NOT NULL COMMENT '阈值';
-alter table alert_rule add column unit int(10) NOT NULL COMMENT '单位';
-\ No newline at end of file
diff --git a/nz-admin/db/2020-06-08.sql b/nz-admin/db/2020-06-08.sql
deleted file mode 100644
index c368377b..00000000
--- a/nz-admin/db/2020-06-08.sql
+++ /dev/null
@@ -1,13 +0,0 @@
-/*
-    panel表结构变更
-   1. 增加字段如下： prev、next
-
-   sys_config 增加 project chart 模板字段
-*/
-
--- panel加字段
-alter table panel add column prev int(10) NOT NULL  COMMENT '前一个panel';
-alter table panel add column next int(10) NOT NULL COMMENT '后一个panel';
-
--- sysConfig增加projectInfo 模板字段
-INSERT INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (NULL, 'project_chart_tpl', '{\"title\":\"project Chart\",\"type\":\"projectInfo\",\"span\":12,\"height\":400,\"unit\":2}', 1, NULL);
-\ No newline at end of file
diff --git a/nz-admin/db/2020-06-12.sql b/nz-admin/db/2020-06-12.sql
deleted file mode 100644
index 3f191872..00000000
--- a/nz-admin/db/2020-06-12.sql
+++ /dev/null
@@ -1,55 +0,0 @@
-/*
-    新增 asset_tag 表、asset_tag 表增加关联conf_event触发器
-*/
-
-
-SET NAMES utf8mb4;
-SET FOREIGN_KEY_CHECKS = 0;
-
--- ----------------------------
--- Table structure for asset_tag
--- ----------------------------
-DROP TABLE IF EXISTS `asset_tag`;
-CREATE TABLE `asset_tag`  (
-  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
-  `asset_id` int(10) NOT NULL COMMENT '资产id',
-  `tag` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'key',
-  `value` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'value',
-  `seq` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '全局唯一UUID，用于导入撤销',
-  PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-
--- ----------------------------
--- Triggers structure for table asset_tag
--- ----------------------------
-DROP TRIGGER IF EXISTS `tri_asset_insert_copy1`;
-delimiter ;;
-CREATE TRIGGER `tri_asset_insert_copy1` AFTER INSERT ON `asset_tag` FOR EACH ROW begin
- update conf_event t set t.value = t.value +1 where t.table = 'asset';
-end
-;;
-delimiter ;
-
--- ----------------------------
--- Triggers structure for table asset_tag
--- ----------------------------
-DROP TRIGGER IF EXISTS `tri_asset_update_copy1`;
-delimiter ;;
-CREATE TRIGGER `tri_asset_update_copy1` AFTER UPDATE ON `asset_tag` FOR EACH ROW begin
- update conf_event t set t.value = t.value +1 where t.table = 'asset';
-end
-;;
-delimiter ;
-
--- ----------------------------
--- Triggers structure for table asset_tag
--- ----------------------------
-DROP TRIGGER IF EXISTS `tri_asset_delete_copy1`;
-delimiter ;;
-CREATE TRIGGER `tri_asset_delete_copy1` AFTER DELETE ON `asset_tag` FOR EACH ROW begin
- update conf_event t set t.value = t.value +1 where t.table = 'asset';
-end
-;;
-delimiter ;
-
-SET FOREIGN_KEY_CHECKS = 1;
-\ No newline at end of file
diff --git a/nz-admin/db/2020-06-16.sql b/nz-admin/db/2020-06-16.sql
deleted file mode 100644
index b1a296ff..00000000
--- a/nz-admin/db/2020-06-16.sql
+++ /dev/null
@@ -1,18 +0,0 @@
-/*
-    account 表结构变更
-
-    -- 增加字段如下： params
-    -- 删除字段如下： auth_type、user、pwd、private_key、user_tip、password_tip、relogin_password_tip
-*/
-
--- 增加字段
-alter table account add column params varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  COMMENT '根据协议不同内容不同，json对象保存';
-alter table account modify port int(10) not null;
--- 删除字段
-alter table account drop auth_type;
-alter table account drop user;
-alter table account drop pwd;
-alter table account drop private_key;
-alter table account drop user_tip;
-alter table account drop password_tip;
-alter table account drop relogin_password_tip;
-\ No newline at end of file
diff --git a/nz-admin/db/2020-06-30.sql b/nz-admin/db/2020-06-30.sql
deleted file mode 100644
index 06ad1af6..00000000
--- a/nz-admin/db/2020-06-30.sql
+++ /dev/null
@@ -1,15 +0,0 @@
-
-/**
- *  创建asset_feature表
- * 
- * */
-DROP TABLE IF EXISTS `asset_feature`;
-CREATE TABLE `asset_feature`  (
-  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
-  `asset_id` int(10) NOT NULL COMMENT '资产id',
-  `item` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
-  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
-  `source` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '采集方式，ssh/snmp',
-  `update_at` datetime(0) NOT NULL COMMENT '更新时间',
-  PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-\ No newline at end of file
diff --git a/nz-admin/db/2020-07-02.sql b/nz-admin/db/2020-07-02.sql
deleted file mode 100644
index 87d027d8..00000000
--- a/nz-admin/db/2020-07-02.sql
+++ /dev/null
@@ -1,14 +0,0 @@
-/**
- * 新增link表
- */
-DROP TABLE IF EXISTS `link`;
-CREATE TABLE `link`  (
-  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
-  `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称',
-  `create_by` int(10) NULL DEFAULT NULL COMMENT '创建人id',
-  `url` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'url',
-  `prev` int(10) NOT NULL COMMENT '前一个panel 记录前一个link.id\r\n\r\n如果前面没有内容了，记录为 0',
-  `next` int(10) NOT NULL COMMENT '后一个panel 记录后一个link.id\r\n\r\n如果后面没有内容了，记录为 -1	',
-  `build_in` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '1:内置，0：非内置，默认：0',
-  PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-\ No newline at end of file
diff --git a/nz-admin/db/2020-08-14.sql b/nz-admin/db/2020-08-14.sql
deleted file mode 100644
index 4ff5caed..00000000
--- a/nz-admin/db/2020-08-14.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-/**
- * 配置表中增加 asset 表头信息
- * 告警规则增加内置告警
- */
- INSERT INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (101, 'asset_export_header', '{\"cn\":{\"sn\":\"sn码\",\"type\":\"资产类型\",\"vendor\":\"厂商\",\"model\":\"型号\",\"idc\":\"数据中心\",\"cabinet\":\"机柜\",\"cabinetStart\":\"开始U位\",\"cabinetEnd\":\"结束U位\",\"host\":\"主机地址\",\"state\":\"状态\",\"purchaseDate\":\"购买日期\",\"sshPort\":\"ssh端口\",\"sshUsername\":\"ssh用户名\",\"method\":\"ssh认证方式\",\"sshPassword\":\"密码\",\"key\":\"密钥\",\"passwordKey\":\"密钥密码\",\"telnetPort\":\"telnet端口\",\"telnetUsername\":\"telnet用户名\",\"userTip\":\"用户提示\",\"telnetPassword\":\"密码\",\"passwordTip\":\"密码提示\",\"reloginTip\":\"重启提示\",\"snmPort\":\"snmp端口\",\"community\":\"团体名\",\"contextName\":\"上下文名称\",\"version\":\"协议版本\",\"snmpUsername\":\"用户名\",\"securityLevel\":\"安全级别\",\"snmpPassword\":\"密码\",\"authProtocol\":\"用户认证协议\",\"privProtocol\":\"加密协议\",\"privPassword\":\"加密密码\",\"tags\":\"资产标签\",\"ipmiHost\":\"ipmi地址\",\"ipmiPort\":\"ipmi端口\",\"exporter\":\"Exporter\"},\"en\":{\"sn\":\"Sn\",\"type\":\"Type\",\"vendor\":\"Vendor\",\"model\":\"Model\",\"idc\":\"IDC\",\"cabinet\":\"Cabinet\",\"cabinetStart\":\"CabinetStart\",\"cabinetEnd\":\"CabinetEnd\",\"host\":\"Host\",\"state\":\"State\",\"purchaseDate\":\"PurchaseDate\",\"sshPort\":\"Port\",\"sshUsername\":\"SSHUserName\",\"method\":\"Methed\",\"sshPassword\":\"SSHPassword\",\"key\":\"PrivateKey\",\"passwordKey\":\"KeyPassword\",\"telnetPort\":\"TELNETPort\",\"telnetUsername\":\"TELNETUserName\",\"userTip\":\"UserTip\",\"telnetPassword\":\"TELNETPassword\",\"passwordTip\":\"PasswordTip\",\"reloginTip\":\"ReloginTip\",\"snmPort\":\"SnmPort\",\"community\":\"Community\",\"contextName\":\"ContextName\",\"version\":\"Version\",\"snmpUsername\":\"SNMPUser\",\"securityLevel\":\"SecurityLevel\",\"snmpPassword\":\"SNMPPassword\",\"authProtocol\":\"AuthProtocol\",\"privProtocol\":\"PrivProtocol\",\"privPassword\":\"PrivPassword\",\"tags\":\"Tags\",\"ipmiHost\":\"IpmiHost\",\"ipmiPort\":\"IpmiPort\",\"exporter\":\"Exporter\"}}', 1, NULL);
-
- INSERT INTO `alert_rule` (`id`, `alert_name`, `expr`, `last`, `severity`, `summary`, `description`, `receiver`, `build_in`, `operator`, `threshold`, `unit`) VALUES ('1', 'snmpTrap', ' ', '60', 'high', NULL, NULL, NULL, '1', '>', '0', '0');
-\ No newline at end of file
diff --git a/nz-admin/db/2020-08-25.sql b/nz-admin/db/2020-08-25.sql
deleted file mode 100644
index 8bf47725..00000000
--- a/nz-admin/db/2020-08-25.sql
+++ /dev/null
@@ -1,50 +0,0 @@
-/**
- *  新增 图谱图配置表 和 拓扑图图标表
- */
-
-/*
- Navicat Premium Data Transfer
-
- Source Server         : nz-prometheus
- Source Server Type    : MySQL
- Source Server Version : 100214
- Source Host           : 192.168.40.42:3306
- Source Schema         : nz
-
- Target Server Type    : MySQL
- Target Server Version : 100214
- File Encoding         : 65001
-
- Date: 25/08/2020 11:26:29
-*/
-
-SET NAMES utf8mb4;
-SET FOREIGN_KEY_CHECKS = 0;
-
--- ----------------------------
--- Table structure for project_topo
--- ----------------------------
-DROP TABLE IF EXISTS `project_topo`;
-CREATE TABLE `project_topo`  (
-  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
-  `project_id` int(10) NOT NULL COMMENT 'project  id',
-  `topo` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '拓扑图配置信息',
-  `update_at` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
-  `update_by` int(10) NULL DEFAULT NULL COMMENT '更新人id',
-  PRIMARY KEY (`id`) USING BTREE,
-  UNIQUE INDEX `uni_projectid`(`project_id`) USING BTREE COMMENT '唯一索引'
-) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-
--- ----------------------------
--- Table structure for project_topo_icon
--- ----------------------------
-DROP TABLE IF EXISTS `project_topo_icon`;
-CREATE TABLE `project_topo_icon`  (
-  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
-  `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'icon名称',
-  `bytes` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'icon图片字节',
-  `type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '截取自图片后缀，支持jpg，jpeg，png，gif',
-  PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-
-SET FOREIGN_KEY_CHECKS = 1;
-\ No newline at end of file
diff --git a/nz-admin/db/2020-08-27.sql b/nz-admin/db/2020-08-27.sql
deleted file mode 100644
index d9dc246d..00000000
--- a/nz-admin/db/2020-08-27.sql
+++ /dev/null
@@ -1,6 +0,0 @@
-/**
- * 1. 结构变更 , sys_config 表 ,param_value 增大
- * 2. asset 导入导出表头信息改变 , 结构 map  , key=language , value={key=cellName,value=cellCommand}
- */
-alter table sys_config modify column param_value varchar(10000);
-update sys_config set param_value = "{\"cn\":{\"*SN码\":\"资产序列号，唯一标识(必填) \\n示例: A0420200101\",\"*资产类型\":\"设备类型（必填） \\n示例: server\",\"*厂商\":\"厂商（必填） \\n示例: Cisco\",\"*型号\":\"型号(必填) \\n示例: CISCO-UCS-C220\",\"*数据中心\":\"数据中心(必填) \\n示例: 北京电信中心机房\",\"机柜\":\"机柜 \\n示例: cabinet-001\",\"开始U位\":\"机柜开始位置 此信息一般和机柜结束位置联合使用 \\n示例: 1\",\"结束U位\":\"机柜结束位置 此信息一般与机柜开始位置联合使用 \\n示例: 2\",\"*主机地址\":\"主机地址(必填),IP格式 \\n示例: 172.0.0.1\",\"状态\":\"资产状态，默认: 在库 1为在库，2为出库 \\n示例: 1\",\"购买日期\":\"购买日期 \\n示例: 2020/2/25\",\"SSH账号端口\":\"SSH连接端口 \\n示例: 22\",\"SSH账号登录名\":\"SSH账号登录名 \\n示例: root\",\"SSH登录认证方式\":\"SSH登录认证方式 密码登录:password,密钥登录:key \\n示例: password\",\"SSH登录密码\":\"SSH登录密码 认证方式为password时登录密码 \\n示例: xxxxx\",\"SSH登录密钥\":\"SSH登录密钥 \\n示例: ssh-rsa CFdv7Jez6K...\",\"SSH密钥密码\":\"SSH密钥密码 \\n示例: xxxxx\",\"TELNET账号端口\":\"TELNET账号端口 \\n示例: 23\",\"TELNET账号登录名\":\"TELNET账号登录名 \\n示例: root\",\"TELNET用户名提示\":\"TELNET用户名提示 \\n示例: user\",\"TELNET登录密码\":\"TELNET登录密码 \\n示例: xxxxx\",\"TELNET密码提示\":\"TELNET密码提示 \\n示例: pass\",\"TELNET重启密码提示\":\"TELNET重启密码提示 \\n示例: pass\",\"SNMP账号端口\":\"SNMP账号端口 \\n示例: 161\",\"SNMP团体名\":\"SNMP团体名 \\n示例: public\",\"SNMP上下文名称\":\"SNMP上下文名称 \\n示例: 80002b8046h\",\"SNMP协议版本\":\"SNMP协议版本 支持V2和V3 \\n示例: 2\",\"SNMP用户名\":\"SNMPV3版本时,登录用户名 \\n示例: root\",\"SNMP安全级别\":\"SNMP安全级别 noAuthNoPriv(不认证不加密) authNoPriv(认证不加密) authPriv(认证且加密) \\n示例: noAuthNoPriv\",\"SNMP用户密码\":\"SNMP用户密码, 根据安全级别选择填写 \\n示例: xxxxx\",\"SNMP认证协议\":\"SNMP用户认证协议 MD5、SHA \\n示例: MD5\",\"SNMP加密协议\":\"SNMP加密协议 AES、DES \\n示例: AES\",\"SNMP加密密码\":\"SNMP加密密码 \\n示例: xxxxx\",\"资产标签\":\"资产标签,tag信息,格式: key=value 如需填写多个请使用回车换行 \\n示例: isOpen=true \\n isHighPerformance=true\",\"ipmi地址\":\"ipmi地址 \\n示例: 172.0.0.1\",\"ipmi端口\":\"ipmi端口 \\n示例: 623\",\"Exporter\":\"是否安装内置node_exporter，1：安装，0：不安装 \\n示例：1\"},\"en\":{\"*Sn\":\"Asset serial number, unique identifier (required) \\nExample: A0420200101\",\"*Type\":\"Asset type (required) \\nExample: server\",\"*Vendor\":\"Vendor (required) \\nExample: Cisco\",\"*Model\":\"Model (required) \\nExample: CISCO-UCS-C220\",\"*IDC\":\"Data Center (Required) \\nExample: Beijing Telecom Center Computer Room\",\"Cabinet\":\"Cabinet \\nExample: cabinet-001\",\"Cabinet Start\":\"Cabinet start position This information is generally used in conjunction with the cabinet end position \\nExample: 1\",\"Cabinet End\":\"Cabinet end position This information is generally used in conjunction with the cabinet start position \\nExample: 2\",\"*Host\":\"Host address (required), IP format \\nExample: 172.0.0.1\",\"State\":\"Asset status, default: In stock, 1 means in stock, 2 means not in stock \\nExample: 1\",\"PurchaseDate\":\"Purchase date \\nExample: 2020/2/25\",\"SSH Account Port\":\"SSH account connection port \\nExample: 22\",\"SSH UserName\":\"SSH account login name \\nExample: root\",\"Methed\":\"SSH login authentication method, Password login: password, key login: key \\nExample: password\",\"SSH Password\":\"SSH login password The login password when the authentication method is password \\nExample: xxxxx\",\"PrivateKey\":\"SSH login key file \\nExample: ssh-rsa CFdv7Jez6K...\",\"Key Password\":\"SSH key password \\nExample: xxxxx\",\"TELNET Port\":\"TELNET account port \\nExample: 23\",\"TELNET Username\":\"TELNET account login name \\nExample: root\",\"User Tip\":\"TELNET username prompt \\nExample: user\",\"TELNET Password\":\"TELNET login password \\nExample: xxxxx\",\"Password Tip\":\"TELNET password prompt \\nExample: pass\",\"Relogin Tip\":\"TELNET relogin password prompt \\nExample: pass\",\"SNMP port\":\"SNMP account port \\nExample: 161\",\"Community\":\"SNMP community name \\nExample: public\",\"Context Name\":\"SNMP context name \\nExample: 80002b8046h\",\"Version\":\"SNMP protocol version supports V2 and V3 \\nExample: 2\",\"SNMP User\":\"In SNMPV3 version, login user name\\nExample: root\",\"SecurityLevel\":\"SNMP security level noAuthNoPriv (no authentication and no encryption) authNoPriv (authentication and no encryption) authPriv (authentication and encryption) \\nExample: noAuthNoPriv\",\"SNMP Password\":\"SNMP user password, fill in according to the security level \\nExample: xxxxx\",\"Auth Protocol\":\"SNMP auth protocol MD5, SHA \\nExample: MD5\",\"Priv Protocol\":\"SNMP priv protocol AES, DES \\nExample: AES\",\"Priv Password\":\"SNMP priv password \\nExample: xxxxx\",\"Tags\":\"Asset tag information, format: key=value If you need to fill in more than one, please use carriage return and line feed \\nExample: isOpen=true \\n isHighPerformance=true\",\"Ipmi Host\":\"Ipmi address \\nExample: 172.0.0.1\",\"Ipmi Port\":\"Ipmi port \\nExample: 623\",\"Exporter\":\"Whether to install the built-in node_exporter, 1: install, 0: not install \\nExample: 1\"}}" where param_key = "asset_export_header";
-\ No newline at end of file
diff --git a/nz-admin/db/2020-09-01.sql b/nz-admin/db/2020-09-01.sql
deleted file mode 100644
index 61ae643f..00000000
--- a/nz-admin/db/2020-09-01.sql
+++ /dev/null
@@ -1,43 +0,0 @@
-/**
- * 初始化sql 缺失字段默认值等 sql
- */
-
-ALTER TABLE `sys_config`
-MODIFY COLUMN `param_value`  longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL AFTER `param_key`;
-
-ALTER TABLE `idc_traffic`
-MODIFY COLUMN `port`  int(10) NOT NULL DEFAULT 161 COMMENT 'snmp端口 默认为161' AFTER `host`,
-MODIFY COLUMN `version`  int(1) NOT NULL DEFAULT 2 COMMENT 'snmp版本 默认为2' AFTER `port`,
-MODIFY COLUMN `community`  varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'public' COMMENT 'snmp团体名 默认为public' AFTER `version`;
-
-ALTER TABLE `alert_rule`
-MODIFY COLUMN `alert_name`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '告警名称' AFTER `id`,
-MODIFY COLUMN `expr`  varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '运算表达式' AFTER `alert_name`,
-MODIFY COLUMN `last`  int(11) NULL COMMENT '持续时间,单位s' AFTER `expr`,
-MODIFY COLUMN `severity`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '告警级别' AFTER `last`;
-
-ALTER TABLE `alert_message`
-MODIFY COLUMN `hash_key`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'redis hash key' AFTER `dc_id`;
-
-ALTER TABLE `sys_user`
-MODIFY COLUMN `lang`  varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '默认语言' AFTER `create_time`,
-MODIFY COLUMN `source`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'system' COMMENT '用户来源\r\n可选值：\r\n\r\nsystem（系统内注册用户）\r\n\r\nldap （ldap认证用户）\r\n\r\n默认：system' AFTER `lang`;
-
-ALTER TABLE `prom_server`
-MODIFY COLUMN `port`  int(10) NOT NULL DEFAULT 9090 COMMENT '端口 默认9090' AFTER `host`,
-MODIFY COLUMN `status`  int(1) NOT NULL DEFAULT 0 COMMENT '默认：0， 1：可用，0：prometheus server 不可用，-1：configagent不可用，-2：都不可用' AFTER `type`;
-
-
-ALTER TABLE `sys_area`
-MODIFY COLUMN `pids`  varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 0 COMMENT '所有父id' AFTER `pid`;
-
-ALTER TABLE `sys_log`
-MODIFY COLUMN `user_id`  int(10) NOT NULL COMMENT '用户名' AFTER `id`,
-MODIFY COLUMN `operation`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户操作' AFTER `user_id`,
-MODIFY COLUMN `type`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '可选值\r\n\r\nasset\r\n\r\nendpoint\r\n\r\nproject\r\n\r\nmodule\r\n\r\nalert rule\r\n\r\nalert message\r\n\r\npanel\r\n\r\nchart\r\n\r\ndatacenter\r\n\r\ncabinet' AFTER `operation`,
-MODIFY COLUMN `opera_id`  varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '记录操作类型的id' AFTER `type`,
-MODIFY COLUMN `method`  varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '请求方法' AFTER `opera_id`,
-MODIFY COLUMN `time`  bigint(19) NULL COMMENT '执行时长(毫秒)' AFTER `params`,
-MODIFY COLUMN `ip`  varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'IP地址' AFTER `time`,
-MODIFY COLUMN `create_date`  datetime NOT NULL COMMENT '创建时间' AFTER `exception`;
-
diff --git a/nz-admin/db/2020-09-08.sql b/nz-admin/db/2020-09-08.sql
deleted file mode 100644
index 73783c13..00000000
--- a/nz-admin/db/2020-09-08.sql
+++ /dev/null
@@ -1,8 +0,0 @@
-/*
- * alert_rule 表增加 seq 导入唯一标识列
- *
- * sys_config 表增加 rule 表头
- */
- alter table alert_rule add column seq varchar(64) COMMENT '导入唯一标识 全局唯一，用于导入撤销';
-
-INSERT INTO sys_config(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (NULL, 'rule_export_header', '{\"cn\":{\"*告警规则名称\":\"告警规则名称(必填) \\n示例: cpuAlert\",\"*运算表达式\":\"运算表达式(必填) \\n示例: 100-(avg(irate(node_cpu_seconds_total{mode=\'idle\'}[5m])) by(instance)* 100)\",\"*比较符号\":\"比较符号(必填) 可选: >,<,<=,>=,==,!= \\n示例: >\",\"*阈值\":\"阈值(必填) \\n示例: 10\",\"*单位\":\"单位(必填) 可选: \\nMisc: none,short,percent(0-100),percent(0.0-1.0),local format\\nData: bits,bytes,kilobytes,megabytes,gigabytes,terabytes,petabytes\\nDataRate: packets/sec,bits/sec,bytes/sec,kilobytes/sec,kilobits/sec,megabytes/sec,megabits/sec,gigabytes/sec,gigabits/sec,terabytes/sec,terabits/sec,petabytes/sec,petabits/sec\\nTime: Hertz(1/s),nanoseconds(ns),microseconds(us),milliseconds(ms),seconds(s),minutes(m),hours(h),days(d)\\n示例: short\",\"*持续时间\":\"持续时间(必填),默认单位（秒） \\n示例:60\",\"*告警级别\":\"告警级别(必填) 可选 high、medium、low \\n示例: high\",\"*告警摘要\":\"告警摘要(必填) \\n示例: cpu告警\",\"*告警详细描述\":\"告警详细描述(必填) \\n示例: cpu使用率超过10%的告警规则\",\"告警通知人\":\"告警通知人，多个使用逗号分隔 \\n示例: admin / admin,root\"},\"en\":{\"*AlertName\":\"Alert rule name (required) \\nExample: cpuAlert\",\"*Expr\":\"Operation expression (required) \\nExample: 100-(avg(irate(node_cpu_seconds_total{mode=\'idle\')[5m])) by(instance)* 100)\",\"*Operator\":\"Operation symbol (required) Optional: >,<,<=,>=,==,!= \\nExample:>\",\"*Threshold\":\"Threshold (required) \\nExample: 10\",\"*Unit\":\"Unit (required) Optional: \\nMisc: none,short,percent(0-100),percent(0.0-1.0),local format\\nData: bits,bytes,kilobytes,megabytes,gigabytes,terabytes,petabytes\\nDataRate: packets/sec,bits/sec,bytes/sec,kilobytes/sec,kilobits/sec,megabytes/sec,megabits/sec,gigabytes/sec,gigabits/sec,terabytes/sec,terabits/sec,petabytes/sec,petabits/sec\\nTime: Hertz(1/s),nanoseconds(ns),microseconds(us),milliseconds(ms),seconds(s),minutes(m),hours(h),days(d)\\nExample:short\",\"*Last\":\"Last (required), the default unit (seconds) \\nExample: 60\",\"*Severity\":\"Alert severity (required) optional high, medium, low \\nExample: high\",\"*Summary\":\"Alert summary \\nExample: Cpu warning\",\"*Description\":\"Alert description \\nExample: Alarm rule for cpu usage exceeding 10%\",\"Receiver\":\"Alert receiver, separated by commas \\nExample: admin / admin,root\"}}', 1, NULL);
-\ No newline at end of file
diff --git a/nz-admin/db/2020-09-17.sql b/nz-admin/db/2020-09-17.sql
deleted file mode 100644
index 8e532e5f..00000000
--- a/nz-admin/db/2020-09-17.sql
+++ /dev/null
@@ -1,17 +0,0 @@
-/*
- * panel chart chart_element 表增加 seq 导入唯一标识列
- *
- * sys_config 表增加 chart 表头
- *
- * alert_rule 表 threshold 改为 double 类型
- */
-
- alter table panel add column seq varchar(64) COMMENT '导入唯一标识 全局唯一，用于导入撤销';
- alter table chart add column seq varchar(64) COMMENT '导入唯一标识 全局唯一，用于导入撤销';
- alter table chart_element add column seq varchar(64) COMMENT '导入唯一标识 全局唯一，用于导入撤销';
-
-
-INSERT INTO sys_config(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (NULL, 'chart_export_header', '{\"cn\":{\"*面板\":\"面板名称(必填) \\n示例: 系统面板\",\"*图表名称\":\"图表名称(必填) \\n示例: CPU使用率\",\"*图表类型\":\"图表类型(必填) 可选: line,bar,table,stackArea,singleStat,url,,alertList \\n示例: line\",\"*宽度\":\"宽度(必填) 可选：1-12 \\n示例: 10\",\"*高度\":\"高度(必填),默认单位（px/像素） \\n示例:400\",\"单位\":\"单位(必填) 可选: \\nMisc: none,short,percent(0-100),percent(0.0-1.0),local format\\nData: bits,bytes,kilobytes,megabytes,gigabytes,terabytes,petabytes\\nDataRate: packets/sec,bits/sec,bytes/sec,kilobytes/sec,kilobits/sec,megabytes/sec,megabits/sec,gigabytes/sec,gigabits/sec,terabytes/sec,terabits/sec,petabytes/sec,petabits/sec\\nTime: Hertz(1/s),nanoseconds(ns),microseconds(us),milliseconds(ms),seconds(s),minutes(m),hours(h),days(d)\\n示例: short\",\"*参数\":\"单位 根据type不同，内容不同，格式为JSON格式 \\n示例: {\\\"statistics\\\":\\\"average\\\"}\",\"表达式\":\"当type=line，bar，stackArea时，包含 elements key，值为对象数组。\\n 示例:[{\\\"expression\\\":\\\"sum(up)\\\",\\\"legend\\\":\\\"test\\\"}]\"},\"en\":{\"*Panel Name\":\"Panel(Required) \\nExample: System panel\",\"*Chart Title\":\"Chart title(Required) \\nExample: CPU usage\",\"*Chart Type\":\"Chart type(Required) Optional: line,bar,table,stackArea,singleStat,url,,alertList \\nExample: line\",\"*Width\":\"width(Required) Optional：1-12 \\nExample: 10\",\"*Height\":\"height(Required),Default unit（px/Pixel） \\nExample:400\",\"Unit\":\"unit(Required) Optional: \\nMisc: none,short,percent(0-100),percent(0.0-1.0),local format\\nData: bits,bytes,kilobytes,megabytes,gigabytes,terabytes,petabytes\\nDataRate: packets/sec,bits/sec,bytes/sec,kilobytes/sec,kilobits/sec,megabytes/sec,megabits/sec,gigabytes/sec,gigabits/sec,terabytes/sec,terabits/sec,petabytes/sec,petabits/sec\\nTime: Hertz(1/s),nanoseconds(ns),microseconds(us),milliseconds(ms),seconds(s),minutes(m),hours(h),days(d)\\nExample: short\",\"*Parameter\":\"Parameters match type，The format is JSON format \\nExample: {\\\"statistics\\\":\\\"average\\\"}\",\"Expressions\":\"When the type is line, table, stackArea, singleStat, histogram, it contains elements key and the value is an object array.\\nExample:[{\\\"expression\\\":\\\"sum(up)\\\",\\\"legend\\\":\\\"test\\\"}]\"}}', 1, NULL);
-
-
- alter table alert_rule modify  column threshold double(20,5) not null COMMENT "阈值";
-\ No newline at end of file
diff --git a/nz-admin/db/2020-09-27.sql b/nz-admin/db/2020-09-27.sql
deleted file mode 100644
index 8504fa52..00000000
--- a/nz-admin/db/2020-09-27.sql
+++ /dev/null
@@ -1,10 +0,0 @@
-/**
- * 修改表字段类型
- * 增加 endpoint 导入导出表头
- */
-ALTER TABLE `alert_message`
-MODIFY COLUMN `summary`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '告警摘要' AFTER `severity`,
-MODIFY COLUMN `description`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '告警描述' AFTER `summary`,
-MODIFY COLUMN `labels`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '告警labels信息' AFTER `description`;
-
-INSERT INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (NULL, 'endpoint_export_header', '{\"cn\":{\"*系统\":\"系统名称(必填) \\n示例: Nezha\",\"*组件\":\"组件名称(必填) \\n示例: node_exporter\",\"*组件类型\":\"组件类型(必填) 可选: HTTP、SNMP 当type = SNMP时，组件必须存在 \\n示例: HTTP\",\"资产序列号\":\"资产序列号(非必填) 与 主机地址 不能同时为空 \\n示例: A0420200101\",\"端口号\":\"端口号 范围0-65535 \\n示例: 9100\",\"参数\":\"端点查询参数，JSON格式， \\n示例: {\\\"key\\\":\\\"value\\\"}\",\"*路径\":\"路径（必填） 请求路径，\\n示例: /metrics\",\"主机地址\":\"主机地址（非必填） 与 资产序列号 不能同时为空 \\n示例; 127.0.0.1\"},\"en\":{\"*Project Name\":\"Project Name(Required) \\nExample: Nezha\",\"*Module Name\":\"Module Name(Required) \\nExample: node_exporter\",\"*Module Type\":\"Module type(Required) Optional: HTTP or SNMP，When type = SNMP, the component must exist \\nExample: HTTP\",\"Sn\":\"Asset serial number(Not required) And host address cannot be empty at the same time \\nExample: A0420200101\",\"Port\":\"Port number range 0-65535 \\nExample: 9100\",\"Parameter\":\"Endpoint query parameters, JSON format  \\nExample: {\\\"key\\\":\\\"value\\\"}\",\"*Path\":\"Path (required) Request path \\nExample: /metrics\",\"Host\":\"Host address (not required) and asset serial number cannot be empty at the same time \\nExample; 127.0.0.1\"}}', 1, NULL);
-\ No newline at end of file
diff --git a/nz-admin/db/2020-09-28.sql b/nz-admin/db/2020-09-28.sql
deleted file mode 100644
index 36c174a1..00000000
--- a/nz-admin/db/2020-09-28.sql
+++ /dev/null
@@ -1,6 +0,0 @@
-/**
- * 增加 asset,model 类型 charts 导入导出表头
- */
-
-INSERT INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (null, 'asset_chart_export_header', '{\"cn\":{\"*图表名称\":\"图表名称(必填) \\n示例: CPU使用率\",\"*图表类型\":\"图表类型(必填) 可选: line,bar,table,stackArea,singleStat,url,,alertList \\n示例: line\",\"*宽度\":\"宽度(必填) 可选：1-12 \\n示例: 10\",\"*高度\":\"高度(必填),默认单位（px/像素） \\n示例:400\",\"单位\":\"单位(必填) 可选: \\nMisc: none,short,percent(0-100),percent(0.0-1.0),local format\\nData: bits,bytes,kilobytes,megabytes,gigabytes,terabytes,petabytes\\nDataRate: packets/sec,bits/sec,bytes/sec,kilobytes/sec,kilobits/sec,megabytes/sec,megabits/sec,gigabytes/sec,gigabits/sec,terabytes/sec,terabits/sec,petabytes/sec,petabits/sec\\nTime: Hertz(1/s),nanoseconds(ns),microseconds(us),milliseconds(ms),seconds(s),minutes(m),hours(h),days(d)\\n示例: short\",\"*参数\":\"单位 根据type不同，内容不同，格式为JSON格式 \\n示例: {\\\"statistics\\\":\\\"average\\\"}\",\"元素\":\"当type=line，bar，stackArea时，包含 elements key，值为对象数组。\\n 示例:[{\\\"expression\\\":\\\"sum(up)\\\",\\\"legend\\\":\\\"test\\\"}]\"},\"en\":{\"*Chart Title\":\"Chart title(Required) \\nExample: CPU usage\",\"*Chart Type\":\"Chart type(Required) Optional: line,bar,table,stackArea,singleStat,url,,alertList \\nExample: line\",\"*Width\":\"width(Required) Optional：1-12 \\nExample: 10\",\"*Height\":\"height(Required),Default unit（px/Pixel） \\nExample:400\",\"Unit\":\"unit(Required) Optional: \\nMisc: none,short,percent(0-100),percent(0.0-1.0),local format\\nData: bits,bytes,kilobytes,megabytes,gigabytes,terabytes,petabytes\\nDataRate: packets/sec,bits/sec,bytes/sec,kilobytes/sec,kilobits/sec,megabytes/sec,megabits/sec,gigabytes/sec,gigabits/sec,terabytes/sec,terabits/sec,petabytes/sec,petabits/sec\\nTime: Hertz(1/s),nanoseconds(ns),microseconds(us),milliseconds(ms),seconds(s),minutes(m),hours(h),days(d)\\nExample: short\",\"*Parameter\":\"Parameters match type，The format is JSON format \\nExample: {\\\"statistics\\\":\\\"average\\\"}\",\"Elements\":\"When the type is line, table, stackArea, singleStat, histogram, it contains elements key and the value is an object array.\\nExample:[{\\\"expression\\\":\\\"sum(up)\\\",\\\"legend\\\":\\\"test\\\"}]\"}}', 1, NULL);
-INSERT INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (null, 'model_chart_export_header', '{\"cn\":{\"*图表名称\":\"图表名称(必填)支持{{asset.sn}},{{asset.host}},{{asset.tag.[key]}},{{asset.tag.key}}取值替换 \\n示例: CPU使用率\",\"*图表类型\":\"图表类型(必填) 可选: line,bar,table,stackArea,singleStat,url,,alertList \\n示例: line\",\"*宽度\":\"宽度(必填) 可选：1-12 \\n示例: 10\",\"*高度\":\"高度(必填),默认单位（px/像素） \\n示例:400\",\"单位\":\"单位(必填) 可选: \\nMisc: none,short,percent(0-100),percent(0.0-1.0),local format\\nData: bits,bytes,kilobytes,megabytes,gigabytes,terabytes,petabytes\\nDataRate: packets/sec,bits/sec,bytes/sec,kilobytes/sec,kilobits/sec,megabytes/sec,megabits/sec,gigabytes/sec,gigabits/sec,terabytes/sec,terabits/sec,petabytes/sec,petabits/sec\\nTime: Hertz(1/s),nanoseconds(ns),microseconds(us),milliseconds(ms),seconds(s),minutes(m),hours(h),days(d)\\n示例: short\",\"*参数\":\"单位 根据type不同，内容不同，格式为JSON格式 ,支持{{asset.sn}},{{asset.host}},{{asset.tag.[key]}},{{asset.tag.key}}取值替换  \\n示例: {\\\"statistics\\\":\\\"average\\\"}\",\"元素\":\"当type=line，bar，stackArea时，包含 elements key，值为对象数组，其中 expression 支持{{asset.sn}},{{asset.host}},{{asset.tag.[key]}},{{asset.tag.key}}取值替换 \\n 示例:[{\\\"expression\\\":\\\"sum(up)\\\",\\\"legend\\\":\\\"test\\\"}]\"},\"en\":{\"*Chart Title\":\"Chart title(Required) Support {{asset.sn}},{{asset.host}},{{asset.tag.[key]}},{{asset.tag.key}} value replacement \\nExample: CPU usage\",\"*Chart Type\":\"Chart type(Required) Optional: line,bar,table,stackArea,singleStat,url,,alertList \\nExample: line\",\"*Width\":\"width(Required) Optional：1-12 \\nExample: 10\",\"*Height\":\"height(Required),Default unit（px/Pixel） \\nExample:400\",\"Unit\":\"unit(Required) Optional: \\nMisc: none,short,percent(0-100),percent(0.0-1.0),local format\\nData: bits,bytes,kilobytes,megabytes,gigabytes,terabytes,petabytes\\nDataRate: packets/sec,bits/sec,bytes/sec,kilobytes/sec,kilobits/sec,megabytes/sec,megabits/sec,gigabytes/sec,gigabits/sec,terabytes/sec,terabits/sec,petabytes/sec,petabits/sec\\nTime: Hertz(1/s),nanoseconds(ns),microseconds(us),milliseconds(ms),seconds(s),minutes(m),hours(h),days(d)\\nExample: short\",\"*Parameter\":\"Parameters match type，The format is JSON format,Support {{asset.sn}},{{asset.host}},{{asset.tag.[key]}},{{asset.tag.key}} value replacement \\nExample: {\\\"statistics\\\":\\\"average\\\"}\",\"Elements\":\"When the type is line, table, stackArea, singleStat, histogram, it contains elements key and the value is an object array.The expression support {{asset.sn}},{{asset.host}},{{asset.tag.[key]}},{{asset.tag.key}} value replacement \\nExample:[{\\\"expression\\\":\\\"sum(up)\\\",\\\"legend\\\":\\\"test\\\"}]\"}}', 1, NULL);
-\ No newline at end of file
diff --git a/nz-admin/db/2020-09-29.sql b/nz-admin/db/2020-09-29.sql
deleted file mode 100644
index 59626059..00000000
--- a/nz-admin/db/2020-09-29.sql
+++ /dev/null
@@ -1,33 +0,0 @@
-/**
- * 增加 asset,model 类型 charts 导入导出表头
- */
-
-INSERT INTO `sys_config` VALUES (null, 'default_cabinet_usize', '40', 1, '机柜默认U位值');
-
-
-
-TRUNCATE sys_area;
-INSERT INTO `sys_area` VALUES ('1', 'Aktau', '0', '0', '73.063460', '50.223100', '{\"cn\":\"Aktau\",\"en\":\"Aktau\"}');
-INSERT INTO `sys_area` VALUES ('2', 'Aktubinsk', '0', '0', '57.100000', '50.170000', '{\"cn\":\"Aktubinsk\",\"en\":\"Aktubinsk\"}');
-INSERT INTO `sys_area` VALUES ('3', 'Almaty', '0', '0', '76.928611', '43.256667', '{\"cn\":\"Almaty\",\"en\":\"Almaty\"}');
-INSERT INTO `sys_area` VALUES ('4', 'Nur-Sultan', '0', '0', '71.450000', '51.166666', '{\"cn\":\"Nur-Sultan\",\"en\":\"Nur-Sultan\"}');
-INSERT INTO `sys_area` VALUES ('5', 'Atyrau', '0', '0', '51.883333', '47.116667', '{\"cn\":\"Atyrau\",\"en\":\"Atyrau\"}');
-INSERT INTO `sys_area` VALUES ('6', 'Karaganda', '0', '0', '73.100000', '49.500000', '{\"cn\":\"Karaganda\",\"en\":\"Karaganda\"}');
-INSERT INTO `sys_area` VALUES ('7', 'Kokshetau', '0', '0', '69.400000', '53.283333', '{\"cn\":\"Kokshetau\",\"en\":\"Kokshetau\"}');
-INSERT INTO `sys_area` VALUES ('8', 'Kostanay', '0', '0', '63.606160', '53.227440', '{\"cn\":\"Kostanay\",\"en\":\"Kostanay\"}');
-INSERT INTO `sys_area` VALUES ('9', 'Kyzylorda', '0', '0', '65.495400', '44.854740', '{\"cn\":\"Kyzylorda\",\"en\":\"Kyzylorda\"}');
-INSERT INTO `sys_area` VALUES ('10', 'Pavlodar', '0', '0', '76.966666', '52.283333', '{\"cn\":\"Pavlodar\",\"en\":\"Pavlodar\"}');
-INSERT INTO `sys_area` VALUES ('11', 'Petropavl', '0', '0', '69.150000', '54.866666', '{\"cn\":\"Petropavl\",\"en\":\"Petropavl\"}');
-INSERT INTO `sys_area` VALUES ('12', 'Semey', '0', '0', '80.266694', '50.426749', '{\"cn\":\"Semey\",\"en\":\"Semey\"}');
-INSERT INTO `sys_area` VALUES ('13', 'Shymkent', '0', '0', '69.600000', '42.300000', '{\"cn\":\"Shymkent\",\"en\":\"Shymkent\"}');
-INSERT INTO `sys_area` VALUES ('14', 'Taldykurgan', '0', '0', '78.383333', '45.016666', '{\"cn\":\"Taldykurgan\",\"en\":\"Taldykurgan\"}');
-INSERT INTO `sys_area` VALUES ('15', 'Taraz', '0', '0', '71.366667', '42.900000', '{\"cn\":\"Taraz\",\"en\":\"Taraz\"}');
-INSERT INTO `sys_area` VALUES ('16', 'Uralsk', '0', '0', '51.434590', '51.249110', '{\"cn\":\"Uralsk\",\"en\":\"Uralsk\"}');
-INSERT INTO `sys_area` VALUES ('17', 'Ust-Kamenogorsk', '0', '0', '82.600000', '49.966666', '{\"cn\":\"Öskemen\",\"en\":\"Öskemen\"}');
-INSERT INTO `sys_area` VALUES ('18', 'Zhezkazgan', '0', '0', '67.766667', '47.783333', '{\"cn\":\"Zhezkazgan\",\"en\":\"Zhezkazgan\"}');
-
-
-
-update module set project_id=1 where id=1;
-
-delete project where id=2;
-\ No newline at end of file
diff --git a/nz-admin/db/2020-10-13.sql b/nz-admin/db/2020-10-13.sql
deleted file mode 100644
index adc26270..00000000
--- a/nz-admin/db/2020-10-13.sql
+++ /dev/null
@@ -1,21 +0,0 @@
-/**
- * 增加  国际化对应关系 格式为JSON, 例如： flagName : { codeValue: {"en":"","cn":"","ru":""} }
- * 取消 asset 导入 ipmi host port 字段
- * 更改 内置 exporter 上传路径及名称
- */
-INSERT INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (NULL, 'i18n_mapping', '{\"assetState\":{\"1\":{\"en\":\"In stock\",\"cn\":\"在库\",\"ru\":\"\"},\"2\":{\"en\":\"Not in stock\",\"cn\":\"出库\",\"ru\":\"\"}}}', 1, NULL);
-
-DELETE from sys_config where param_key = "asset_export_header";
-INSERT INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (NULL, 'asset_export_header', '{\"cn\":{\"*SN码\":\"资产序列号，唯一标识(必填) \\n示例: A0420200101\",\"*资产类型\":\"设备类型（必填） \\n示例: server\",\"*厂商\":\"厂商（必填） \\n示例: Cisco\",\"*型号\":\"型号(必填) \\n示例: CISCO-UCS-C220\",\"*数据中心\":\"数据中心(必填) \\n示例: 北京电信中心机房\",\"机柜\":\"机柜 \\n示例: cabinet-001\",\"开始U位\":\"机柜开始位置 此信息一般和机柜结束位置联合使用 \\n示例: 1\",\"结束U位\":\"机柜结束位置 此信息一般与机柜开始位置联合使用 \\n示例: 2\",\"*主机地址\":\"主机地址(必填),IP格式 \\n示例: 172.0.0.1\",\"状态\":\"资产状态，默认: 在库 1为在库，2为出库 \\n示例: 1\",\"购买日期\":\"购买日期 \\n示例: 2020/2/25\",\"SSH账号端口\":\"SSH连接端口 \\n示例: 22\",\"SSH账号登录名\":\"SSH账号登录名 \\n示例: root\",\"SSH登录认证方式\":\"SSH登录认证方式 密码登录:password,密钥登录:key \\n示例: password\",\"SSH登录密码\":\"SSH登录密码 认证方式为password时登录密码 \\n示例: xxxxx\",\"SSH登录密钥\":\"SSH登录密钥 \\n示例: ssh-rsa CFdv7Jez6K...\",\"SSH密钥密码\":\"SSH密钥密码 \\n示例: xxxxx\",\"TELNET账号端口\":\"TELNET账号端口 \\n示例: 23\",\"TELNET账号登录名\":\"TELNET账号登录名 \\n示例: root\",\"TELNET用户名提示\":\"TELNET用户名提示 \\n示例: user\",\"TELNET登录密码\":\"TELNET登录密码 \\n示例: xxxxx\",\"TELNET密码提示\":\"TELNET密码提示 \\n示例: pass\",\"TELNET重启密码提示\":\"TELNET重启密码提示 \\n示例: pass\",\"SNMP账号端口\":\"SNMP账号端口 \\n示例: 161\",\"SNMP团体名\":\"SNMP团体名 \\n示例: public\",\"SNMP上下文名称\":\"SNMP上下文名称 \\n示例: 80002b8046h\",\"SNMP协议版本\":\"SNMP协议版本 支持V2和V3 \\n示例: 2\",\"SNMP用户名\":\"SNMPV3版本时,登录用户名 \\n示例: root\",\"SNMP安全级别\":\"SNMP安全级别 noAuthNoPriv(不认证不加密) authNoPriv(认证不加密) authPriv(认证且加密) \\n示例: noAuthNoPriv\",\"SNMP用户密码\":\"SNMP用户密码, 根据安全级别选择填写 \\n示例: xxxxx\",\"SNMP认证协议\":\"SNMP用户认证协议 MD5、SHA \\n示例: MD5\",\"SNMP加密协议\":\"SNMP加密协议 AES、DES \\n示例: AES\",\"SNMP加密密码\":\"SNMP加密密码 \\n示例: xxxxx\",\"资产标签\":\"资产标签,tag信息,格式: key=value 如需填写多个请使用回车换行 \\n示例: isOpen=true \\n isHighPerformance=true\",\"Exporter\":\"是否安装内置node_exporter，1：安装，0：不安装 \\n示例：1\"},\"en\":{\"*Sn\":\"Asset serial number, unique identifier (required) \\nExample: A0420200101\",\"*Type\":\"Asset type (required) \\nExample: server\",\"*Vendor\":\"Vendor (required) \\nExample: Cisco\",\"*Model\":\"Model (required) \\nExample: CISCO-UCS-C220\",\"*IDC\":\"Data Center (Required) \\nExample: Beijing Telecom Center Computer Room\",\"Cabinet\":\"Cabinet \\nExample: cabinet-001\",\"Cabinet Start\":\"Cabinet start position This information is generally used in conjunction with the cabinet end position \\nExample: 1\",\"Cabinet End\":\"Cabinet end position This information is generally used in conjunction with the cabinet start position \\nExample: 2\",\"*Host\":\"Host address (required), IP format \\nExample: 172.0.0.1\",\"State\":\"Asset status, default: In stock, 1 means in stock, 2 means not in stock \\nExample: 1\",\"PurchaseDate\":\"Purchase date \\nExample: 2020/2/25\",\"SSH Account Port\":\"SSH account connection port \\nExample: 22\",\"SSH UserName\":\"SSH account login name \\nExample: root\",\"Methed\":\"SSH login authentication method, Password login: password, key login: key \\nExample: password\",\"SSH Password\":\"SSH login password The login password when the authentication method is password \\nExample: xxxxx\",\"PrivateKey\":\"SSH login key file \\nExample: ssh-rsa CFdv7Jez6K...\",\"Key Password\":\"SSH key password \\nExample: xxxxx\",\"TELNET Port\":\"TELNET account port \\nExample: 23\",\"TELNET Username\":\"TELNET account login name \\nExample: root\",\"User Tip\":\"TELNET username prompt \\nExample: user\",\"TELNET Password\":\"TELNET login password \\nExample: xxxxx\",\"Password Tip\":\"TELNET password prompt \\nExample: pass\",\"Relogin Tip\":\"TELNET relogin password prompt \\nExample: pass\",\"SNMP port\":\"SNMP account port \\nExample: 161\",\"Community\":\"SNMP community name \\nExample: public\",\"Context Name\":\"SNMP context name \\nExample: 80002b8046h\",\"Version\":\"SNMP protocol version supports V2 and V3 \\nExample: 2\",\"SNMP User\":\"In SNMPV3 version, login user name\\nExample: root\",\"SecurityLevel\":\"SNMP security level noAuthNoPriv (no authentication and no encryption) authNoPriv (authentication and no encryption) authPriv (authentication and encryption) \\nExample: noAuthNoPriv\",\"SNMP Password\":\"SNMP user password, fill in according to the security level \\nExample: xxxxx\",\"Auth Protocol\":\"SNMP auth protocol MD5, SHA \\nExample: MD5\",\"Priv Protocol\":\"SNMP priv protocol AES, DES \\nExample: AES\",\"Priv Password\":\"SNMP priv password \\nExample: xxxxx\",\"Tags\":\"Asset tag information, format: key=value If you need to fill in more than one, please use carriage return and line feed \\nExample: isOpen=true \\n isHighPerformance=true\",\"Exporter\":\"Whether to install the built-in node_exporter, 1: install, 0: not install \\nExample: 1\"}}', 1, 'alert_message导出表头');
-
-delete from sys_config where param_key = "node_exporter_name";
-INSERT INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (NULL, 'node_exporter_name', 'node-exporter-1.0.0-1.x86_64.rpm', 1, '内置 node_exporter 压缩包名称');
-
-delete from sys_config where param_key = "node_exporter_path";
-INSERT INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (NULL, 'node_exporter_path', './build_node_exporter', 1, '内置 node_exporter 项目中的路径');
-
-delete from sys_config where param_key = "node_exporter_target_path";
-INSERT INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (NULL, 'node_exporter_target_path', '/tmp/nezha', 1, '内置node_exporter安装路径');
-
-delete from sys_config where param_key = "chart_export_header";
-INSERT INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (NULL, 'chart_export_header', '{\"cn\":{\"*面板\":\"面板名称(必填) \\n示例: 系统面板\",\"*图表名称\":\"图表名称(必填) \\n示例: CPU使用率\",\"*图表类型\":\"图表类型(必填) 可选: line,bar,table,stackArea,singleStat,url,,alertList \\n示例: line\",\"*宽度\":\"宽度(必填) 可选：1-12 \\n示例: 10\",\"*高度\":\"高度(必填),默认单位（px/像素） \\n示例:400\",\"单位\":\"单位(必填) 可选: \\nMisc: none,short,percent(0-100),percent(0.0-1.0),local format\\nData: bits,bytes,kilobytes,megabytes,gigabytes,terabytes,petabytes\\nDataRate: packets/sec,bits/sec,bytes/sec,kilobytes/sec,kilobits/sec,megabytes/sec,megabits/sec,gigabytes/sec,gigabits/sec,terabytes/sec,terabits/sec,petabytes/sec,petabits/sec\\nTime: Hertz(1/s),nanoseconds(ns),microseconds(us),milliseconds(ms),seconds(s),minutes(m),hours(h),days(d)\\n示例: short\",\"*参数\":\"单位 根据type不同，内容不同，格式为JSON格式 \\n示例: {\\\"statistics\\\":\\\"average\\\"}\",\"元素\":\"当type=line，bar，stackArea时，包含 elements key，值为对象数组。\\n 示例:[{\\\"expression\\\":\\\"sum(up)\\\",\\\"legend\\\":\\\"test\\\"}]\"},\"en\":{\"*Panel Name\":\"Panel(Required) \\nExample: System panel\",\"*Chart Title\":\"Chart title(Required) \\nExample: CPU usage\",\"*Chart Type\":\"Chart type(Required) Optional: line,bar,table,stackArea,singleStat,url,,alertList \\nExample: line\",\"*Width\":\"width(Required) Optional：1-12 \\nExample: 10\",\"*Height\":\"height(Required),Default unit（px/Pixel） \\nExample:400\",\"Unit\":\"unit(Required) Optional: \\nMisc: none,short,percent(0-100),percent(0.0-1.0),local format\\nData: bits,bytes,kilobytes,megabytes,gigabytes,terabytes,petabytes\\nDataRate: packets/sec,bits/sec,bytes/sec,kilobytes/sec,kilobits/sec,megabytes/sec,megabits/sec,gigabytes/sec,gigabits/sec,terabytes/sec,terabits/sec,petabytes/sec,petabits/sec\\nTime: Hertz(1/s),nanoseconds(ns),microseconds(us),milliseconds(ms),seconds(s),minutes(m),hours(h),days(d)\\nExample: short\",\"*Parameter\":\"Parameters match type，The format is JSON format \\nExample: {\\\"statistics\\\":\\\"average\\\"}\",\"Elements\":\"When the type is line, table, stackArea, singleStat, histogram, it contains elements key and the value is an object array.\\nExample:[{\\\"expression\\\":\\\"sum(up)\\\",\\\"legend\\\":\\\"test\\\"}]\"}}', 1, NULL);
-\ No newline at end of file
diff --git a/nz-admin/db/2020-10-15.sql b/nz-admin/db/2020-10-15.sql
deleted file mode 100644
index 84b24986..00000000
--- a/nz-admin/db/2020-10-15.sql
+++ /dev/null
@@ -1,51 +0,0 @@
-/**
- * 修改导入导出表头信息
- */
-delete from sys_config where param_key = "alert_export_header";
-INSERT INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (NULL, 'alert_export_header', '{\"cn\":{\"ID\":\"ID\",\"告警名称\":\"告警名称\",\"数据中心\":\"数据中心\",\"应用名称\":\"应用名称\",\"组件名称\":\"组件名称\",\"Endpoint\":\"Endpoint\",\"主机地址\":\"主机地址\",\"告警tag信息\":\"告警tag信息\",\"告警级别\":\"告警级别\",\"告警摘要\":\"告警摘要\",\"告警描述\":\"告警描述\",\"开始时间\":\"开始时间\",\"结束时间\":\"结束时间\",\"状态\":\"状态\"},\"en\":{\"ID\":\"ID\",\"Alert Name\":\"Alert Name\",\"Datacenter\":\"Datacenter\",\"Project\":\"Project\",\"Module\":\"Module\",\"Endpoint\":\"Endpoint\",\"Asset\":\"Asset\",\"Labels\":\"Labels\",\"Severity\":\"Severity\",\"Summary\":\"Summary\",\"Description\":\"Description\",\"StartAt\":\"StartAt\",\"EndAt\":\"EndAt\",\"State\":\"State\"}}', 1, 'alert_message导出表头');
-
-delete from sys_config where param_key = "rule_export_header";
-INSERT INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (NULL, 'rule_export_header', '{\"cn\":{\"*告警规则名称\":\"告警规则名称(必填) \\n示例: cpuAlert\",\"*运算表达式\":\"运算表达式(必填) \\n示例: 100-(avg(irate(node_cpu_seconds_total{mode=\'idle\'}[5m])) by(instance)* 100)\",\"*比较符号\":\"比较符号(必填) 可选: >,<,<=,>=,==,!= \\n示例: >\",\"*阈值\":\"阈值(必填) \\n示例: 10\",\"*单位\":\"单位(必填) 可选: \\nMisc: none,short,percent(0-100),percent(0.0-1.0),local format\\nData: bits,bytes,kilobytes,megabytes,gigabytes,terabytes,petabytes\\nDataRate: packets/sec,bits/sec,bytes/sec,kilobytes/sec,kilobits/sec,megabytes/sec,megabits/sec,gigabytes/sec,gigabits/sec,terabytes/sec,terabits/sec,petabytes/sec,petabits/sec\\nTime: Hertz(1/s),nanoseconds(ns),microseconds(us),milliseconds(ms),seconds(s),minutes(m),hours(h),days(d)\\n示例: short\",\"*持续时间\":\"持续时间(必填),默认单位（秒） \\n示例:60\",\"*告警级别\":\"告警级别(必填) 可选 P1、P2、P3 \\n示例: P1\",\"*告警摘要\":\"告警摘要(必填) \\n示例: cpu告警\",\"*告警详细描述\":\"告警详细描述(必填) \\n示例: cpu使用率超过10%的告警规则\",\"告警通知人\":\"告警通知人，多个使用逗号分隔 \\n示例: admin / admin,root\"},\"en\":{\"*AlertName\":\"Alert rule name (required) \\nExample: cpuAlert\",\"*Expr\":\"Operation expression (required) \\nExample: 100-(avg(irate(node_cpu_seconds_total{mode=\'idle\')[5m])) by(instance)* 100)\",\"*Operator\":\"Operation symbol (required) Optional: >,<,<=,>=,==,!= \\nExample:>\",\"*Threshold\":\"Threshold (required) \\nExample: 10\",\"*Unit\":\"Unit (required) Optional: \\nMisc: none,short,percent(0-100),percent(0.0-1.0),local format\\nData: bits,bytes,kilobytes,megabytes,gigabytes,terabytes,petabytes\\nDataRate: packets/sec,bits/sec,bytes/sec,kilobytes/sec,kilobits/sec,megabytes/sec,megabits/sec,gigabytes/sec,gigabits/sec,terabytes/sec,terabits/sec,petabytes/sec,petabits/sec\\nTime: Hertz(1/s),nanoseconds(ns),microseconds(us),milliseconds(ms),seconds(s),minutes(m),hours(h),days(d)\\nExample:short\",\"*Last\":\"Last (required), the default unit (seconds) \\nExample: 60\",\"*Severity\":\"Alert severity (required) optional P1, P2, P3 \\nExample: P1\",\"*Summary\":\"Alert summary \\nExample: Cpu warning\",\"*Description\":\"Alert description \\nExample: Alarm rule for cpu usage exceeding 10%\",\"Receiver\":\"Alert receiver, separated by commas \\nExample: admin / admin,root\"}}', 1, NULL);
-
-delete from sys_config where param_key = "asset_chart_export_header";
-INSERT INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (NULL, 'asset_chart_export_header', '{\"cn\":{\"*图表名称\":\"图表名称(必填) \\n示例: CPU使用率\",\"*图表类型\":\"图表类型(必填) 可选: 曲线图,柱状图,表格,堆叠区域图,SingleStat,URL,告警列表 \\n示例: 曲线图\",\"*宽度\":\"宽度(必填) 可选：1-12 \\n示例: 10\",\"*高度\":\"高度(必填),默认单位（px/像素） \\n示例:400\",\"单位\":\"单位(必填) 可选: \\nMisc: none,short,percent(0-100),percent(0.0-1.0),local format\\nData: bits,bytes,kilobytes,megabytes,gigabytes,terabytes,petabytes\\nDataRate: packets/sec,bits/sec,bytes/sec,kilobytes/sec,kilobits/sec,megabytes/sec,megabits/sec,gigabytes/sec,gigabits/sec,terabytes/sec,terabits/sec,petabytes/sec,petabits/sec\\nTime: Hertz(1/s),nanoseconds(ns),microseconds(us),milliseconds(ms),seconds(s),minutes(m),hours(h),days(d)\\n示例: short\",\"*参数\":\"单位 根据type不同，内容不同，格式为JSON格式 \\n示例: {\\\"statistics\\\":\\\"average\\\"}\",\"元素\":\"当type=line，bar，stackArea时，包含 elements key，值为对象数组。\\n 示例:[{\\\"expression\\\":\\\"sum(up)\\\",\\\"legend\\\":\\\"test\\\"}]\"},\"en\":{\"*Chart Title\":\"Chart title(Required) \\nExample: CPU usage\",\"*Chart Type\":\"Chart type(Required) Optional: Line Chart,Histogram,Table,Stack Area,SingleStat,URL,Alert list \\nExample: Line Chart\",\"*Width\":\"width(Required) Optional：1-12 \\nExample: 10\",\"*Height\":\"height(Required),Default unit（px/Pixel） \\nExample:400\",\"Unit\":\"unit(Required) Optional: \\nMisc: none,short,percent(0-100),percent(0.0-1.0),local format\\nData: bits,bytes,kilobytes,megabytes,gigabytes,terabytes,petabytes\\nDataRate: packets/sec,bits/sec,bytes/sec,kilobytes/sec,kilobits/sec,megabytes/sec,megabits/sec,gigabytes/sec,gigabits/sec,terabytes/sec,terabits/sec,petabytes/sec,petabits/sec\\nTime: Hertz(1/s),nanoseconds(ns),microseconds(us),milliseconds(ms),seconds(s),minutes(m),hours(h),days(d)\\nExample: short\",\"*Parameter\":\"Parameters match type，The format is JSON format \\nExample: {\\\"statistics\\\":\\\"average\\\"}\",\"Elements\":\"When the type is line, table, stackArea, singleStat, histogram, it contains elements key and the value is an object array.\\nExample:[{\\\"expression\\\":\\\"sum(up)\\\",\\\"legend\\\":\\\"test\\\"}]\"}}', 1, NULL);
-
-delete from sys_config where param_key = "model_chart_export_header";
-INSERT INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (NULL, 'model_chart_export_header', '{\"cn\":{\"*图表名称\":\"图表名称(必填)支持{{asset.sn}},{{asset.host}},{{asset.tag.[key]}},{{asset.tag.key}}取值替换 \\n示例: CPU使用率\",\"*图表类型\":\"图表类型(必填) 可选: 曲线图,柱状图,表格,堆叠区域图,SingleStat,URL,告警列表 \\n示例: 曲线图\",\"*宽度\":\"宽度(必填) 可选：1-12 \\n示例: 10\",\"*高度\":\"高度(必填),默认单位（px/像素） \\n示例:400\",\"单位\":\"单位(必填) 可选: \\nMisc: none,short,percent(0-100),percent(0.0-1.0),local format\\nData: bits,bytes,kilobytes,megabytes,gigabytes,terabytes,petabytes\\nDataRate: packets/sec,bits/sec,bytes/sec,kilobytes/sec,kilobits/sec,megabytes/sec,megabits/sec,gigabytes/sec,gigabits/sec,terabytes/sec,terabits/sec,petabytes/sec,petabits/sec\\nTime: Hertz(1/s),nanoseconds(ns),microseconds(us),milliseconds(ms),seconds(s),minutes(m),hours(h),days(d)\\n示例: short\",\"*参数\":\"单位 根据type不同，内容不同，格式为JSON格式 ,支持{{asset.sn}},{{asset.host}},{{asset.tag.[key]}},{{asset.tag.key}}取值替换  \\n示例: {\\\"statistics\\\":\\\"average\\\"}\",\"元素\":\"当type=line，bar，stackArea时，包含 elements key，值为对象数组，其中 expression 支持{{asset.sn}},{{asset.host}},{{asset.tag.[key]}},{{asset.tag.key}}取值替换 \\n 示例:[{\\\"expression\\\":\\\"sum(up)\\\",\\\"legend\\\":\\\"test\\\"}]\"},\"en\":{\"*Chart Title\":\"Chart title(Required) Support {{asset.sn}},{{asset.host}},{{asset.tag.[key]}},{{asset.tag.key}} value replacement \\nExample: CPU usage\",\"*Chart Type\":\"Chart type(Required) Optional: Line Chart,Histogram,Table,Stack Area,SingleStat,URL,Alert list \\nExample: Line Chart\",\"*Width\":\"width(Required) Optional：1-12 \\nExample: 10\",\"*Height\":\"height(Required),Default unit（px/Pixel） \\nExample:400\",\"Unit\":\"unit(Required) Optional: \\nMisc: none,short,percent(0-100),percent(0.0-1.0),local format\\nData: bits,bytes,kilobytes,megabytes,gigabytes,terabytes,petabytes\\nDataRate: packets/sec,bits/sec,bytes/sec,kilobytes/sec,kilobits/sec,megabytes/sec,megabits/sec,gigabytes/sec,gigabits/sec,terabytes/sec,terabits/sec,petabytes/sec,petabits/sec\\nTime: Hertz(1/s),nanoseconds(ns),microseconds(us),milliseconds(ms),seconds(s),minutes(m),hours(h),days(d)\\nExample: short\",\"*Parameter\":\"Parameters match type，The format is JSON format,Support {{asset.sn}},{{asset.host}},{{asset.tag.[key]}},{{asset.tag.key}} value replacement \\nExample: {\\\"statistics\\\":\\\"average\\\"}\",\"Elements\":\"When the type is line, table, stackArea, singleStat, histogram, it contains elements key and the value is an object array.The expression support {{asset.sn}},{{asset.host}},{{asset.tag.[key]}},{{asset.tag.key}} value replacement \\nExample:[{\\\"expression\\\":\\\"sum(up)\\\",\\\"legend\\\":\\\"test\\\"}]\"}}', 1, NULL);
-
-delete from sys_config where param_key = "i18n_mapping";
-INSERT INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (NULL, 'i18n_mapping', '{\"assetState\":{\"1\":{\"en\":\"In stock\",\"cn\":\"在库\",\"ru\":\"\"},\"2\":{\"en\":\"Not in stock\",\"cn\":\"出库\",\"ru\":\"\"}},\"chartType\":{\"en\":{\"line\":\"Line Chart\",\"bar\":\"Histogram\",\"table\":\"Table\",\"stackArea\":\"Stack Area\",\"singleStat\":\"SingleStat\",\"url\":\"URL\",\"alertList\":\"Alert list\"},\"cn\":{\"line\":\"曲线图\",\"bar\":\"柱状图\",\"table\":\"表格\",\"stackArea\":\"堆叠区域图\",\"singleStat\":\"SingleStat\",\"url\":\"URL\",\"alertList\":\"告警列表\"}}}', 1, NULL);
-
-delete from sys_config where param_key = "map_center_config";
-INSERT INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (NULL, 'map_center_config', '{\"longitude\":34.33,\"latitude\":45.44,\"zoom\":2}', 1, NULL);
-
-ALTER TABLE alert_rule MODIFY COLUMN `last` int(10) NOT NULL;
-ALTER TABLE alert_rule MODIFY COLUMN `severity` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '告警级别';
-ALTER TABLE alert_rule MODIFY COLUMN `operator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '比较符号';
-ALTER TABLE alert_rule MODIFY COLUMN `threshold` Double(20,5) COMMENT '阈值';
-
-ALTER TABLE prom_server MODIFY COLUMN `status` INT(1) NOT NULL DEFAULT 0;
-
-ALTER TABLE sys_log MODIFY COLUMN `user_id` INT(10) NOT NULL DEFAULT -1;
-ALTER TABLE sys_log MODIFY COLUMN `opera_id` VARCHAR(512)	CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT "-1";
-
-ALTER TABLE sys_user MODIFY COLUMN `lang` VARCHAR(4)	CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'en';
-ALTER TABLE sys_user MODIFY COLUMN `source` VARCHAR(32)	CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'system';
-
-update alert_rule set severity = "P1" where severity = "high";
-update alert_rule set severity = "P2" where severity = "medium";
-update alert_rule set severity = "P3" where severity = "low";
-
-update alert_message set severity = "P1" where severity = "high";
-update alert_message set severity = "P2" where severity = "medium";
-update alert_message set severity = "P3" where severity = "low";
-
-delete from sys_dict where type = 'alertInterval';
-
-update alert_rule set severity = "P1" where severity = "high";
-update alert_rule set severity = "P2" where severity = "medium";
-update alert_rule set severity = "P3" where severity = "low";
-
-update alert_message set severity = "P1" where severity = "high";
-update alert_message set severity = "P2" where severity = "medium";
-update alert_message set severity = "P3" where severity = "low";
-\ No newline at end of file
diff --git a/nz-admin/db/2020-10-16.sql b/nz-admin/db/2020-10-16.sql
deleted file mode 100644
index 4d9185ef..00000000
--- a/nz-admin/db/2020-10-16.sql
+++ /dev/null
@@ -1,9 +0,0 @@
-/**
- * 修改导入导出表头信息
- */
-delete from sys_config where param_key = "asset_export_header";
-INSERT INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (NULL, 'asset_export_header', '{\"cn\":{\"*SN码\":\"资产序列号，唯一标识(必填) \\n示例: A0420200101\",\"*资产类型\":\"设备类型（必填） \\n示例: server\",\"*厂商\":\"厂商（必填） \\n示例: Cisco\",\"*型号\":\"型号(必填) \\n示例: CISCO-UCS-C220\",\"*数据中心\":\"数据中心(必填) \\n示例: 北京电信中心机房\",\"机柜\":\"机柜 \\n示例: cabinet-001\",\"开始U位\":\"机柜开始位置 此信息一般和机柜结束位置联合使用 \\n示例: 1\",\"结束U位\":\"机柜结束位置 此信息一般与机柜开始位置联合使用 \\n示例: 2\",\"*主机地址\":\"主机地址(必填),IP格式 \\n示例: 172.0.0.1\",\"状态\":\"资产状态，可选: 在库、出库 \\n示例: 在库\",\"购买日期\":\"购买日期 \\n示例: 2020/2/25\",\"SSH账号端口\":\"SSH连接端口 \\n示例: 22\",\"SSH账号登录名\":\"SSH账号登录名 \\n示例: root\",\"SSH登录认证方式\":\"SSH登录认证方式 密码登录:password,密钥登录:key \\n示例: password\",\"SSH登录密码\":\"SSH登录密码 认证方式为password时登录密码 \\n示例: xxxxx\",\"SSH登录密钥\":\"SSH登录密钥 \\n示例: ssh-rsa CFdv7Jez6K...\",\"SSH密钥密码\":\"SSH密钥密码 \\n示例: xxxxx\",\"TELNET账号端口\":\"TELNET账号端口 \\n示例: 23\",\"TELNET账号登录名\":\"TELNET账号登录名 \\n示例: root\",\"TELNET用户名提示\":\"TELNET用户名提示 \\n示例: user\",\"TELNET登录密码\":\"TELNET登录密码 \\n示例: xxxxx\",\"TELNET密码提示\":\"TELNET密码提示 \\n示例: pass\",\"TELNET重启密码提示\":\"TELNET重启密码提示 \\n示例: pass\",\"SNMP账号端口\":\"SNMP账号端口 \\n示例: 161\",\"SNMP团体名\":\"SNMP团体名 \\n示例: public\",\"SNMP上下文名称\":\"SNMP上下文名称 \\n示例: 80002b8046h\",\"SNMP协议版本\":\"SNMP协议版本 支持V2和V3 \\n示例: 2\",\"SNMP用户名\":\"SNMPV3版本时,登录用户名 \\n示例: root\",\"SNMP安全级别\":\"SNMP安全级别 noAuthNoPriv(不认证不加密) authNoPriv(认证不加密) authPriv(认证且加密) \\n示例: noAuthNoPriv\",\"SNMP用户密码\":\"SNMP用户密码, 根据安全级别选择填写 \\n示例: xxxxx\",\"SNMP认证协议\":\"SNMP用户认证协议 MD5、SHA \\n示例: MD5\",\"SNMP加密协议\":\"SNMP加密协议 AES、DES \\n示例: AES\",\"SNMP加密密码\":\"SNMP加密密码 \\n示例: xxxxx\",\"资产标签\":\"资产标签,tag信息,格式: key=value 如需填写多个请使用回车换行 \\n示例: isOpen=true \\n isHighPerformance=true\",\"Exporter\":\"是否安装内置node_exporter，1：安装，0：不安装 \\n示例：1\"},\"en\":{\"*Sn\":\"Asset serial number, unique identifier (required) \\nExample: A0420200101\",\"*Type\":\"Asset type (required) \\nExample: server\",\"*Vendor\":\"Vendor (required) \\nExample: Cisco\",\"*Model\":\"Model (required) \\nExample: CISCO-UCS-C220\",\"*IDC\":\"Data Center (Required) \\nExample: Beijing Telecom Center Computer Room\",\"Cabinet\":\"Cabinet \\nExample: cabinet-001\",\"Cabinet Start\":\"Cabinet start position This information is generally used in conjunction with the cabinet end position \\nExample: 1\",\"Cabinet End\":\"Cabinet end position This information is generally used in conjunction with the cabinet start position \\nExample: 2\",\"*Host\":\"Host address (required), IP format \\nExample: 172.0.0.1\",\"State\":\"Asset status, optional: In stock or Not in stock \\nExample: In stock\",\"PurchaseDate\":\"Purchase date \\nExample: 2020/2/25\",\"SSH Account Port\":\"SSH account connection port \\nExample: 22\",\"SSH UserName\":\"SSH account login name \\nExample: root\",\"Methed\":\"SSH login authentication method, Password login: password, key login: key \\nExample: password\",\"SSH Password\":\"SSH login password The login password when the authentication method is password \\nExample: xxxxx\",\"PrivateKey\":\"SSH login key file \\nExample: ssh-rsa CFdv7Jez6K...\",\"Key Password\":\"SSH key password \\nExample: xxxxx\",\"TELNET Port\":\"TELNET account port \\nExample: 23\",\"TELNET Username\":\"TELNET account login name \\nExample: root\",\"User Tip\":\"TELNET username prompt \\nExample: user\",\"TELNET Password\":\"TELNET login password \\nExample: xxxxx\",\"Password Tip\":\"TELNET password prompt \\nExample: pass\",\"Relogin Tip\":\"TELNET relogin password prompt \\nExample: pass\",\"SNMP port\":\"SNMP account port \\nExample: 161\",\"Community\":\"SNMP community name \\nExample: public\",\"Context Name\":\"SNMP context name \\nExample: 80002b8046h\",\"Version\":\"SNMP protocol version supports V2 and V3 \\nExample: 2\",\"SNMP User\":\"In SNMPV3 version, login user name\\nExample: root\",\"SecurityLevel\":\"SNMP security level noAuthNoPriv (no authentication and no encryption) authNoPriv (authentication and no encryption) authPriv (authentication and encryption) \\nExample: noAuthNoPriv\",\"SNMP Password\":\"SNMP user password, fill in according to the security level \\nExample: xxxxx\",\"Auth Protocol\":\"SNMP auth protocol MD5, SHA \\nExample: MD5\",\"Priv Protocol\":\"SNMP priv protocol AES, DES \\nExample: AES\",\"Priv Password\":\"SNMP priv password \\nExample: xxxxx\",\"Tags\":\"Asset tag information, format: key=value If you need to fill in more than one, please use carriage return and line feed \\nExample: isOpen=true \\n isHighPerformance=true\",\"Exporter\":\"Whether to install the built-in node_exporter, 1: install, 0: not install \\nExample: 1\"}}', 1, 'alert_message导出表头');
-
-
-delete from sys_config where param_key = "i18n_mapping";
-INSERT INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (NULL, 'i18n_mapping', '{\"assetState\":{\"en\":{\"1\":\"In stock\",\"2\":\"Not in stock\"},\"cn\":{\"1\":\"在库\",\"2\":\"出库\"}},\"chartType\":{\"en\":{\"line\":\"Line Chart\",\"bar\":\"Histogram\",\"table\":\"Table\",\"stackArea\":\"Stack Area\",\"singleStat\":\"SingleStat\",\"url\":\"URL\",\"alertList\":\"Alert list\"},\"cn\":{\"line\":\"曲线图\",\"bar\":\"柱状图\",\"table\":\"表格\",\"stackArea\":\"堆叠区域图\",\"singleStat\":\"SingleStat\",\"url\":\"URL\",\"alertList\":\"告警列表\"}}}', 1, NULL);
diff --git a/nz-admin/db/2020-10-20.sql b/nz-admin/db/2020-10-20.sql
deleted file mode 100644
index 651fe6ee..00000000
--- a/nz-admin/db/2020-10-20.sql
+++ /dev/null
@@ -1,16 +0,0 @@
-/**
- * 修改导入导出表头信息
- */
-delete from sys_config where param_key = "i18n_mapping";
-INSERT INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (NULL, 'i18n_mapping', '{\"assetState\":{\"en\":{\"1\":\"In stock\",\"2\":\"Not in stock\"},\"cn\":{\"1\":\"在库\",\"2\":\"出库\"}},\"chartType\":{\"en\":{\"line\":\"Line Chart\",\"bar\":\"Histogram\",\"table\":\"Table\",\"stackArea\":\"Stack Area\",\"singleStat\":\"SingleStat\",\"url\":\"URL\",\"alertList\":\"Alert list\",\"text\":\"Text\"},\"cn\":{\"line\":\"曲线图\",\"bar\":\"柱状图\",\"table\":\"表格\",\"stackArea\":\"堆叠区域图\",\"singleStat\":\"SingleStat\",\"url\":\"URL\",\"alertList\":\"告警列表\",\"text\":\"文本\"}}}', 1, NULL);
-
-delete from sys_config where param_key = "chart_export_header";
-INSERT INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (NULL, 'chart_export_header', '{\"cn\":{\"*面板\":\"面板名称(必填) \\n示例: 系统面板\",\"*图表名称\":\"图表名称(必填) \\n示例: CPU使用率\",\"*图表类型\":\"图表类型(必填) 可选: 曲线图,柱状图,表格,堆叠区域图,SingleStat,URL,告警列表,文本 \\n示例: 曲线图\",\"*宽度\":\"宽度(必填) 可选：1-12 \\n示例: 10\",\"*高度\":\"高度(必填),默认单位（px/像素） \\n示例:400\",\"单位\":\"单位(必填) 可选: \\nMisc: none,short,percent(0-100),percent(0.0-1.0),local format\\nData: bits,bytes,kilobytes,megabytes,gigabytes,terabytes,petabytes\\nDataRate: packets/sec,bits/sec,bytes/sec,kilobytes/sec,kilobits/sec,megabytes/sec,megabits/sec,gigabytes/sec,gigabits/sec,terabytes/sec,terabits/sec,petabytes/sec,petabits/sec\\nTime: Hertz(1/s),nanoseconds(ns),microseconds(us),milliseconds(ms),seconds(s),minutes(m),hours(h),days(d)\\n示例: short\",\"*参数\":\"单位 根据type不同，内容不同，格式为JSON格式 \\n示例: {\\\"statistics\\\":\\\"average\\\"}\",\"元素\":\"当type=line，bar，stackArea时，包含 elements key，值为对象数组。\\n 示例:[{\\\"expression\\\":\\\"sum(up)\\\",\\\"legend\\\":\\\"test\\\"}]\"},\"en\":{\"*Panel Name\":\"Panel(Required) \\nExample: System panel\",\"*Chart Title\":\"Chart title(Required) \\nExample: CPU usage\",\"*Chart Type\":\"Chart type(Required) Optional: Line Chart,Histogram,Table,Stack Area,SingleStat,URL,Alert list,Text \\nExample: Line Chart\",\"*Width\":\"width(Required) Optional：1-12 \\nExample: 10\",\"*Height\":\"height(Required),Default unit（px/Pixel） \\nExample:400\",\"Unit\":\"unit(Required) Optional: \\nMisc: none,short,percent(0-100),percent(0.0-1.0),local format\\nData: bits,bytes,kilobytes,megabytes,gigabytes,terabytes,petabytes\\nDataRate: packets/sec,bits/sec,bytes/sec,kilobytes/sec,kilobits/sec,megabytes/sec,megabits/sec,gigabytes/sec,gigabits/sec,terabytes/sec,terabits/sec,petabytes/sec,petabits/sec\\nTime: Hertz(1/s),nanoseconds(ns),microseconds(us),milliseconds(ms),seconds(s),minutes(m),hours(h),days(d)\\nExample: short\",\"*Parameter\":\"Parameters match type，The format is JSON format \\nExample: {\\\"statistics\\\":\\\"average\\\"}\",\"Elements\":\"When the type is line, table, stackArea, singleStat, histogram, it contains elements key and the value is an object array.\\nExample:[{\\\"expression\\\":\\\"sum(up)\\\",\\\"legend\\\":\\\"test\\\"}]\"}}', 1, NULL);
-
-delete from sys_config where param_key = "asset_chart_export_header";
-INSERT INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (NULL, 'asset_chart_export_header', '{\"cn\":{\"*图表名称\":\"图表名称(必填) \\n示例: CPU使用率\",\"*图表类型\":\"图表类型(必填) 可选: 曲线图,柱状图,表格,堆叠区域图,SingleStat,URL,告警列表,文本 \\n示例: 曲线图\",\"*宽度\":\"宽度(必填) 可选：1-12 \\n示例: 10\",\"*高度\":\"高度(必填),默认单位（px/像素） \\n示例:400\",\"单位\":\"单位(必填) 可选: \\nMisc: none,short,percent(0-100),percent(0.0-1.0),local format\\nData: bits,bytes,kilobytes,megabytes,gigabytes,terabytes,petabytes\\nDataRate: packets/sec,bits/sec,bytes/sec,kilobytes/sec,kilobits/sec,megabytes/sec,megabits/sec,gigabytes/sec,gigabits/sec,terabytes/sec,terabits/sec,petabytes/sec,petabits/sec\\nTime: Hertz(1/s),nanoseconds(ns),microseconds(us),milliseconds(ms),seconds(s),minutes(m),hours(h),days(d)\\n示例: short\",\"*参数\":\"单位 根据type不同，内容不同，格式为JSON格式 \\n示例: {\\\"statistics\\\":\\\"average\\\"}\",\"元素\":\"当type=line，bar，stackArea时，包含 elements key，值为对象数组。\\n 示例:[{\\\"expression\\\":\\\"sum(up)\\\",\\\"legend\\\":\\\"test\\\"}]\"},\"en\":{\"*Chart Title\":\"Chart title(Required) \\nExample: CPU usage\",\"*Chart Type\":\"Chart type(Required) Optional: Line Chart,Histogram,Table,Stack Area,SingleStat,URL,Alert list,Text \\nExample: Line Chart\",\"*Width\":\"width(Required) Optional：1-12 \\nExample: 10\",\"*Height\":\"height(Required),Default unit（px/Pixel） \\nExample:400\",\"Unit\":\"unit(Required) Optional: \\nMisc: none,short,percent(0-100),percent(0.0-1.0),local format\\nData: bits,bytes,kilobytes,megabytes,gigabytes,terabytes,petabytes\\nDataRate: packets/sec,bits/sec,bytes/sec,kilobytes/sec,kilobits/sec,megabytes/sec,megabits/sec,gigabytes/sec,gigabits/sec,terabytes/sec,terabits/sec,petabytes/sec,petabits/sec\\nTime: Hertz(1/s),nanoseconds(ns),microseconds(us),milliseconds(ms),seconds(s),minutes(m),hours(h),days(d)\\nExample: short\",\"*Parameter\":\"Parameters match type，The format is JSON format \\nExample: {\\\"statistics\\\":\\\"average\\\"}\",\"Elements\":\"When the type is line, table, stackArea, singleStat, histogram, it contains elements key and the value is an object array.\\nExample:[{\\\"expression\\\":\\\"sum(up)\\\",\\\"legend\\\":\\\"test\\\"}]\"}}', 1, NULL);
-
-delete from sys_config where param_key = "model_chart_export_header";
-INSERT INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (NULL, 'model_chart_export_header', '{\"cn\":{\"*图表名称\":\"图表名称(必填)支持{{asset.sn}},{{asset.host}},{{asset.tag.[key]}},{{asset.tag.key}}取值替换 \\n示例: CPU使用率\",\"*图表类型\":\"图表类型(必填) 可选: 曲线图,柱状图,表格,堆叠区域图,SingleStat,URL,告警列表,文本 \\n示例: 曲线图\",\"*宽度\":\"宽度(必填) 可选：1-12 \\n示例: 10\",\"*高度\":\"高度(必填),默认单位（px/像素） \\n示例:400\",\"单位\":\"单位(必填) 可选: \\nMisc: none,short,percent(0-100),percent(0.0-1.0),local format\\nData: bits,bytes,kilobytes,megabytes,gigabytes,terabytes,petabytes\\nDataRate: packets/sec,bits/sec,bytes/sec,kilobytes/sec,kilobits/sec,megabytes/sec,megabits/sec,gigabytes/sec,gigabits/sec,terabytes/sec,terabits/sec,petabytes/sec,petabits/sec\\nTime: Hertz(1/s),nanoseconds(ns),microseconds(us),milliseconds(ms),seconds(s),minutes(m),hours(h),days(d)\\n示例: short\",\"*参数\":\"单位 根据type不同，内容不同，格式为JSON格式 ,支持{{asset.sn}},{{asset.host}},{{asset.tag.[key]}},{{asset.tag.key}}取值替换  \\n示例: {\\\"statistics\\\":\\\"average\\\"}\",\"元素\":\"当type=line，bar，stackArea时，包含 elements key，值为对象数组，其中 expression 支持{{asset.sn}},{{asset.host}},{{asset.tag.[key]}},{{asset.tag.key}}取值替换 \\n 示例:[{\\\"expression\\\":\\\"sum(up)\\\",\\\"legend\\\":\\\"test\\\"}]\"},\"en\":{\"*Chart Title\":\"Chart title(Required) Support {{asset.sn}},{{asset.host}},{{asset.tag.[key]}},{{asset.tag.key}} value replacement \\nExample: CPU usage\",\"*Chart Type\":\"Chart type(Required) Optional: Line Chart,Histogram,Table,Stack Area,SingleStat,URL,Alert list,Text \\nExample: Line Chart\",\"*Width\":\"width(Required) Optional：1-12 \\nExample: 10\",\"*Height\":\"height(Required),Default unit（px/Pixel） \\nExample:400\",\"Unit\":\"unit(Required) Optional: \\nMisc: none,short,percent(0-100),percent(0.0-1.0),local format\\nData: bits,bytes,kilobytes,megabytes,gigabytes,terabytes,petabytes\\nDataRate: packets/sec,bits/sec,bytes/sec,kilobytes/sec,kilobits/sec,megabytes/sec,megabits/sec,gigabytes/sec,gigabits/sec,terabytes/sec,terabits/sec,petabytes/sec,petabits/sec\\nTime: Hertz(1/s),nanoseconds(ns),microseconds(us),milliseconds(ms),seconds(s),minutes(m),hours(h),days(d)\\nExample: short\",\"*Parameter\":\"Parameters match type，The format is JSON format,Support {{asset.sn}},{{asset.host}},{{asset.tag.[key]}},{{asset.tag.key}} value replacement \\nExample: {\\\"statistics\\\":\\\"average\\\"}\",\"Elements\":\"When the type is line, table, stackArea, singleStat, histogram, it contains elements key and the value is an object array.The expression support {{asset.sn}},{{asset.host}},{{asset.tag.[key]}},{{asset.tag.key}} value replacement \\nExample:[{\\\"expression\\\":\\\"sum(up)\\\",\\\"legend\\\":\\\"test\\\"}]\"}}', 1, NULL);
-
-INSERT INTO `sys_dict`(`id`, `name`, `type`, `code`, `value`, `i18n_code`, `order_num`, `remark`, `del_flag`, `operator`, `op_time`, `seq`) VALUES (NULL, '图表类型', 'chartType', 8, 'text', '', 8, '告警', 0, 1, '2020-05-27 17:50:33', NULL);
diff --git a/nz-admin/db/2020-11-10.sql b/nz-admin/db/2020-11-10.sql
deleted file mode 100644
index fea9249f..00000000
--- a/nz-admin/db/2020-11-10.sql
+++ /dev/null
@@ -1,30 +0,0 @@
-/**
- * asset state 增加停用状态
- * asset 导入导出表头信息更改
- */
-INSERT INTO `sys_dict`(`id`, `name`, `type`, `code`, `value`, `i18n_code`, `order_num`, `remark`, `del_flag`, `operator`, `op_time`, `seq`) VALUES (NULL, '资产状态', 'assetState', 3, '停用', '', 0, '停用', 0, 0, '2020-11-09 14:19:49', NULL);
-
-DELETE FROM sys_config WHERE param_key = "i18n_mapping";
-INSERT INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (NULL, 'i18n_mapping', '{\"assetState\":{\"en\":{\"1\":\"In stock\",\"2\":\"Not in stock\",\"3\":\"Suspended\"},\"cn\":{\"1\":\"在库\",\"2\":\"出库\",\"3\":\"停用\"}},\"chartType\":{\"en\":{\"line\":\"Line Chart\",\"bar\":\"Histogram\",\"table\":\"Table\",\"stackArea\":\"Stack Area\",\"singleStat\":\"SingleStat\",\"url\":\"URL\",\"alertList\":\"Alert list\",\"text\":\"Text\"},\"cn\":{\"line\":\"曲线图\",\"bar\":\"柱状图\",\"table\":\"表格\",\"stackArea\":\"堆叠区域图\",\"singleStat\":\"SingleStat\",\"url\":\"URL\",\"alertList\":\"告警列表\",\"text\":\"文本\"}}}', 1, NULL);
-
-delete from sys_config where param_key = "asset_export_header";
-INSERT INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (NULL, 'asset_export_header', '{\"cn\":{\"*SN码\":\"资产序列号，唯一标识(必填) \\n示例: A0420200101\",\"*资产类型\":\"设备类型（必填） \\n示例: server\",\"*厂商\":\"厂商（必填） \\n示例: Cisco\",\"*型号\":\"型号(必填) \\n示例: CISCO-UCS-C220\",\"*数据中心\":\"数据中心(必填) \\n示例: 北京电信中心机房\",\"机柜\":\"机柜 \\n示例: cabinet-001\",\"开始U位\":\"机柜开始位置 此信息一般和机柜结束位置联合使用 \\n示例: 1\",\"结束U位\":\"机柜结束位置 此信息一般与机柜开始位置联合使用 \\n示例: 2\",\"*主机地址\":\"主机地址(必填),IP格式 \\n示例: 172.0.0.1\",\"状态\":\"资产状态，可选: 在库、出库、停用 \\n示例: 在库\",\"购买日期\":\"购买日期 \\n示例: 2020/2/25\",\"SSH账号端口\":\"SSH连接端口 \\n示例: 22\",\"SSH账号登录名\":\"SSH账号登录名 \\n示例: root\",\"SSH登录认证方式\":\"SSH登录认证方式 密码登录:password,密钥登录:key \\n示例: password\",\"SSH登录密码\":\"SSH登录密码 认证方式为password时登录密码 \\n示例: xxxxx\",\"SSH登录密钥\":\"SSH登录密钥 \\n示例: ssh-rsa CFdv7Jez6K...\",\"SSH密钥密码\":\"SSH密钥密码 \\n示例: xxxxx\",\"TELNET账号端口\":\"TELNET账号端口 \\n示例: 23\",\"TELNET账号登录名\":\"TELNET账号登录名 \\n示例: root\",\"TELNET用户名提示\":\"TELNET用户名提示 \\n示例: user\",\"TELNET登录密码\":\"TELNET登录密码 \\n示例: xxxxx\",\"TELNET密码提示\":\"TELNET密码提示 \\n示例: pass\",\"TELNET重启密码提示\":\"TELNET重启密码提示 \\n示例: pass\",\"SNMP账号端口\":\"SNMP账号端口 \\n示例: 161\",\"SNMP团体名\":\"SNMP团体名 \\n示例: public\",\"SNMP上下文名称\":\"SNMP上下文名称 \\n示例: 80002b8046h\",\"SNMP协议版本\":\"SNMP协议版本 支持V2和V3 \\n示例: 2\",\"SNMP用户名\":\"SNMPV3版本时,登录用户名 \\n示例: root\",\"SNMP安全级别\":\"SNMP安全级别 noAuthNoPriv(不认证不加密) authNoPriv(认证不加密) authPriv(认证且加密) \\n示例: noAuthNoPriv\",\"SNMP用户密码\":\"SNMP用户密码, 根据安全级别选择填写 \\n示例: xxxxx\",\"SNMP认证协议\":\"SNMP用户认证协议 MD5、SHA \\n示例: MD5\",\"SNMP加密协议\":\"SNMP加密协议 AES、DES \\n示例: AES\",\"SNMP加密密码\":\"SNMP加密密码 \\n示例: xxxxx\",\"资产标签\":\"资产标签,tag信息,格式: key=value 如需填写多个请使用回车换行 \\n示例: isOpen=true \\n isHighPerformance=true\",\"Exporter\":\"是否安装内置node_exporter，1：安装，0：不安装 \\n示例：1\"},\"en\":{\"*Sn\":\"Asset serial number, unique identifier (required) \\nExample: A0420200101\",\"*Type\":\"Asset type (required) \\nExample: server\",\"*Vendor\":\"Vendor (required) \\nExample: Cisco\",\"*Model\":\"Model (required) \\nExample: CISCO-UCS-C220\",\"*IDC\":\"Data Center (Required) \\nExample: Beijing Telecom Center Computer Room\",\"Cabinet\":\"Cabinet \\nExample: cabinet-001\",\"Cabinet Start\":\"Cabinet start position This information is generally used in conjunction with the cabinet end position \\nExample: 1\",\"Cabinet End\":\"Cabinet end position This information is generally used in conjunction with the cabinet start position \\nExample: 2\",\"*Host\":\"Host address (required), IP format \\nExample: 172.0.0.1\",\"State\":\"Asset status, optional: In stock, Not in stock or Suspended \\nExample: In stock\",\"PurchaseDate\":\"Purchase date \\nExample: 2020/2/25\",\"SSH Account Port\":\"SSH account connection port \\nExample: 22\",\"SSH UserName\":\"SSH account login name \\nExample: root\",\"Methed\":\"SSH login authentication method, Password login: password, key login: key \\nExample: password\",\"SSH Password\":\"SSH login password The login password when the authentication method is password \\nExample: xxxxx\",\"PrivateKey\":\"SSH login key file \\nExample: ssh-rsa CFdv7Jez6K...\",\"Key Password\":\"SSH key password \\nExample: xxxxx\",\"TELNET Port\":\"TELNET account port \\nExample: 23\",\"TELNET Username\":\"TELNET account login name \\nExample: root\",\"User Tip\":\"TELNET username prompt \\nExample: user\",\"TELNET Password\":\"TELNET login password \\nExample: xxxxx\",\"Password Tip\":\"TELNET password prompt \\nExample: pass\",\"Relogin Tip\":\"TELNET relogin password prompt \\nExample: pass\",\"SNMP port\":\"SNMP account port \\nExample: 161\",\"Community\":\"SNMP community name \\nExample: public\",\"Context Name\":\"SNMP context name \\nExample: 80002b8046h\",\"Version\":\"SNMP protocol version supports V2 and V3 \\nExample: 2\",\"SNMP User\":\"In SNMPV3 version, login user name\\nExample: root\",\"SecurityLevel\":\"SNMP security level noAuthNoPriv (no authentication and no encryption) authNoPriv (authentication and no encryption) authPriv (authentication and encryption) \\nExample: noAuthNoPriv\",\"SNMP Password\":\"SNMP user password, fill in according to the security level \\nExample: xxxxx\",\"Auth Protocol\":\"SNMP auth protocol MD5, SHA \\nExample: MD5\",\"Priv Protocol\":\"SNMP priv protocol AES, DES \\nExample: AES\",\"Priv Password\":\"SNMP priv password \\nExample: xxxxx\",\"Tags\":\"Asset tag information, format: key=value If you need to fill in more than one, please use carriage return and line feed \\nExample: isOpen=true \\n isHighPerformance=true\",\"Exporter\":\"Whether to install the built-in node_exporter, 1: install, 0: not install \\nExample: 1\"}}', 1, 'asset导出表头');
-
-
-/*  module endpoint 表增加 labels 列 */
-ALTER TABLE module ADD COLUMN labels VARCHAR (256) COMMENT '使用json对象保存{"key":"value"}';
-ALTER TABLE endpoint ADD COLUMN labels VARCHAR (256) COMMENT '使用json对象保存{"key":"value"}';
-
-/*  endpoint 导入导出表头增加 label 列  */
-DELETE FROM sys_config WHERE param_key = "endpoint_export_header";
-INSERT INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (NULL, 'endpoint_export_header', '{\"cn\":{\"*系统\":\"系统名称(必填) \\n示例: Nezha\",\"*组件\":\"组件名称(必填) \\n示例: node_exporter\",\"*组件类型\":\"组件类型(必填) 可选: HTTP、SNMP 当type = SNMP时，组件必须存在 \\n示例: HTTP\",\"资产序列号\":\"资产序列号(非必填) 与 主机地址 不能同时为空 \\n示例: A0420200101\",\"端口号\":\"端口号 范围0-65535 \\n示例: 9100\",\"参数\":\"端点查询参数，JSON格式， \\n示例: {\\\"key\\\":\\\"value\\\"}\",\"标签\":\"标签，JSON格式， \\n示例: {\\\"key\\\":\\\"value\\\"}\",\"*路径\":\"路径（必填） 请求路径，\\n示例: /metrics\",\"主机地址\":\"主机地址（非必填） 与 资产序列号 不能同时为空 \\n示例; 127.0.0.1\"},\"en\":{\"*Project Name\":\"Project Name(Required) \\nExample: Nezha\",\"*Module Name\":\"Module Name(Required) \\nExample: node_exporter\",\"*Module Type\":\"Module type(Required) Optional: HTTP or SNMP，When type = SNMP, the component must exist \\nExample: HTTP\",\"Sn\":\"Asset serial number(Not required) And host address cannot be empty at the same time \\nExample: A0420200101\",\"Port\":\"Port number range 0-65535 \\nExample: 9100\",\"Parameter\":\"Endpoint query parameters, JSON format  \\nExample: {\\\"key\\\":\\\"value\\\"}\",\"Labels\":\"Endpoint lebel, JSON format  \\nExample: {\\\"key\\\":\\\"value\\\"}\",\"*Path\":\"Path (required) Request path \\nExample: /metrics\",\"Host\":\"Host address (not required) and asset serial number cannot be empty at the same time \\nExample; 127.0.0.1\"}}', 1, NULL);
-
-
-
-/**
- * idc 取消 area_id 列， 增加 longitude、latitude、state 三列
- */
-ALTER TABLE idc DROP COLUMN area_id;
-ALTER TABLE idc ADD COLUMN `longitude` DOUBLE (8,5) COMMENT '经度 -180,180';
-ALTER TABLE idc ADD COLUMN `latitude` DOUBLE (8,5)  COMMENT '纬度 -90，90';
-ALTER TABLE idc ADD COLUMN `state` VARCHAR (8) NOT NULL DEFAULT 'ON' COMMENT '可选值：ON,OFF 默认：ON';
-\ No newline at end of file
diff --git a/nz-admin/db/2020-11-17.sql b/nz-admin/db/2020-11-17.sql
deleted file mode 100644
index b74c043e..00000000
--- a/nz-admin/db/2020-11-17.sql
+++ /dev/null
@@ -1,46 +0,0 @@
-/**
- * 
- * rule chatr 相关的导入模板批注信息更改，unit 增加 YYYY-MM-DD HH:mm:ss,MM/DD/YYYY h:mm:ss a  两项
- * sys_config 表增加 system_version 系统版本
- */
-
-DELETE FROM sys_config WHERE param_key = "rule_export_header";
-INSERT INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (NULL, 'rule_export_header', '{\"cn\":{\"*告警规则名称\":\"告警规则名称(必填) \\n示例: cpuAlert\",\"*运算表达式\":\"运算表达式(必填) \\n示例: 100-(avg(irate(node_cpu_seconds_total{mode=\'idle\'}[5m])) by(instance)* 100)\",\"*比较符号\":\"比较符号(必填) 可选: >,<,<=,>=,==,!= \\n示例: >\",\"*阈值\":\"阈值(必填) \\n示例: 10\",\"*单位\":\"单位(必填) 可选: \\nMisc: none,short,percent(0-100),percent(0.0-1.0),local format\\nData: bits,bytes,kilobytes,megabytes,gigabytes,terabytes,petabytes\\nDataRate: packets/sec,bits/sec,bytes/sec,kilobytes/sec,kilobits/sec,megabytes/sec,megabits/sec,gigabytes/sec,gigabits/sec,terabytes/sec,terabits/sec,petabytes/sec,petabits/sec\\nTime: Hertz(1/s),nanoseconds(ns),microseconds(us),milliseconds(ms),seconds(s),minutes(m),hours(h),days(d),YYYY-MM-DD HH:mm:ss,MM/DD/YYYY h:mm:ss a \\n示例: short\",\"*持续时间\":\"持续时间(必填),默认单位（秒） \\n示例:60\",\"*告警级别\":\"告警级别(必填) 可选 P1、P2、P3 \\n示例: P1\",\"*告警摘要\":\"告警摘要(必填) \\n示例: cpu告警\",\"*告警详细描述\":\"告警详细描述(必填) \\n示例: cpu使用率超过10%的告警规则\",\"告警通知人\":\"告警通知人，多个使用逗号分隔 \\n示例: admin / admin,root\"},\"en\":{\"*AlertName\":\"Alert rule name (required) \\nExample: cpuAlert\",\"*Expr\":\"Operation expression (required) \\nExample: 100-(avg(irate(node_cpu_seconds_total{mode=\'idle\')[5m])) by(instance)* 100)\",\"*Operator\":\"Operation symbol (required) Optional: >,<,<=,>=,==,!= \\nExample:>\",\"*Threshold\":\"Threshold (required) \\nExample: 10\",\"*Unit\":\"Unit (required) Optional: \\nMisc: none,short,percent(0-100),percent(0.0-1.0),local format\\nData: bits,bytes,kilobytes,megabytes,gigabytes,terabytes,petabytes\\nDataRate: packets/sec,bits/sec,bytes/sec,kilobytes/sec,kilobits/sec,megabytes/sec,megabits/sec,gigabytes/sec,gigabits/sec,terabytes/sec,terabits/sec,petabytes/sec,petabits/sec\\nTime: Hertz(1/s),nanoseconds(ns),microseconds(us),milliseconds(ms),seconds(s),minutes(m),hours(h),days(d),YYYY-MM-DD HH:mm:ss,MM/DD/YYYY h:mm:ss a \\nExample:short\",\"*Last\":\"Last (required), the default unit (seconds) \\nExample: 60\",\"*Severity\":\"Alert severity (required) optional P1, P2, P3 \\nExample: P1\",\"*Summary\":\"Alert summary \\nExample: Cpu warning\",\"*Description\":\"Alert description \\nExample: Alarm rule for cpu usage exceeding 10%\",\"Receiver\":\"Alert receiver, separated by commas \\nExample: admin / admin,root\"}}', 1, NULL);
-
-DELETE FROM sys_config WHERE param_key = "chart_export_header";
-INSERT INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (NULL, 'chart_export_header', '{\"cn\":{\"*面板\":\"面板名称(必填) \\n示例: 系统面板\",\"*图表名称\":\"图表名称(必填) \\n示例: CPU使用率\",\"*图表类型\":\"图表类型(必填) 可选: 曲线图,柱状图,表格,堆叠区域图,SingleStat,URL,告警列表,文本 \\n示例: 曲线图\",\"*宽度\":\"宽度(必填) 可选：1-12 \\n示例: 10\",\"*高度\":\"高度(必填),默认单位（px/像素） \\n示例:400\",\"单位\":\"单位(必填) 可选: \\nMisc: none,short,percent(0-100),percent(0.0-1.0),local format\\nData: bits,bytes,kilobytes,megabytes,gigabytes,terabytes,petabytes\\nDataRate: packets/sec,bits/sec,bytes/sec,kilobytes/sec,kilobits/sec,megabytes/sec,megabits/sec,gigabytes/sec,gigabits/sec,terabytes/sec,terabits/sec,petabytes/sec,petabits/sec\\nTime: Hertz(1/s),nanoseconds(ns),microseconds(us),milliseconds(ms),seconds(s),minutes(m),hours(h),days(d),YYYY-MM-DD HH:mm:ss,MM/DD/YYYY h:mm:ss a \\n示例: short\",\"*参数\":\"单位 根据type不同，内容不同，格式为JSON格式 \\n示例: {\\\"statistics\\\":\\\"average\\\"}\",\"元素\":\"当type=line，bar，stackArea时，包含 elements key，值为对象数组。\\n 示例:[{\\\"expression\\\":\\\"sum(up)\\\",\\\"legend\\\":\\\"test\\\"}]\"},\"en\":{\"*Panel Name\":\"Panel(Required) \\nExample: System panel\",\"*Chart Title\":\"Chart title(Required) \\nExample: CPU usage\",\"*Chart Type\":\"Chart type(Required) Optional: Line Chart,Histogram,Table,Stack Area,SingleStat,URL,Alert list,Text \\nExample: Line Chart\",\"*Width\":\"width(Required) Optional：1-12 \\nExample: 10\",\"*Height\":\"height(Required),Default unit（px/Pixel） \\nExample:400\",\"Unit\":\"unit(Required) Optional: \\nMisc: none,short,percent(0-100),percent(0.0-1.0),local format\\nData: bits,bytes,kilobytes,megabytes,gigabytes,terabytes,petabytes\\nDataRate: packets/sec,bits/sec,bytes/sec,kilobytes/sec,kilobits/sec,megabytes/sec,megabits/sec,gigabytes/sec,gigabits/sec,terabytes/sec,terabits/sec,petabytes/sec,petabits/sec\\nTime: Hertz(1/s),nanoseconds(ns),microseconds(us),milliseconds(ms),seconds(s),minutes(m),hours(h),days(d),YYYY-MM-DD HH:mm:ss,MM/DD/YYYY h:mm:ss a \\nExample: short\",\"*Parameter\":\"Parameters match type，The format is JSON format \\nExample: {\\\"statistics\\\":\\\"average\\\"}\",\"Elements\":\"When the type is line, table, stackArea, singleStat, histogram, it contains elements key and the value is an object array.\\nExample:[{\\\"expression\\\":\\\"sum(up)\\\",\\\"legend\\\":\\\"test\\\"}]\"}}', 1, NULL);
-
-DELETE FROM sys_config WHERE param_key = "asset_chart_export_header";
-INSERT INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (NULL, 'asset_chart_export_header', '{\"cn\":{\"*图表名称\":\"图表名称(必填) \\n示例: CPU使用率\",\"*图表类型\":\"图表类型(必填) 可选: 曲线图,柱状图,表格,堆叠区域图,SingleStat,URL,告警列表,文本 \\n示例: 曲线图\",\"*宽度\":\"宽度(必填) 可选：1-12 \\n示例: 10\",\"*高度\":\"高度(必填),默认单位（px/像素） \\n示例:400\",\"单位\":\"单位(必填) 可选: \\nMisc: none,short,percent(0-100),percent(0.0-1.0),local format\\nData: bits,bytes,kilobytes,megabytes,gigabytes,terabytes,petabytes\\nDataRate: packets/sec,bits/sec,bytes/sec,kilobytes/sec,kilobits/sec,megabytes/sec,megabits/sec,gigabytes/sec,gigabits/sec,terabytes/sec,terabits/sec,petabytes/sec,petabits/sec\\nTime: Hertz(1/s),nanoseconds(ns),microseconds(us),milliseconds(ms),seconds(s),minutes(m),hours(h),days(d),YYYY-MM-DD HH:mm:ss,MM/DD/YYYY h:mm:ss a \\n示例: short\",\"*参数\":\"单位 根据type不同，内容不同，格式为JSON格式 \\n示例: {\\\"statistics\\\":\\\"average\\\"}\",\"元素\":\"当type=line，bar，stackArea时，包含 elements key，值为对象数组。\\n 示例:[{\\\"expression\\\":\\\"sum(up)\\\",\\\"legend\\\":\\\"test\\\"}]\"},\"en\":{\"*Chart Title\":\"Chart title(Required) \\nExample: CPU usage\",\"*Chart Type\":\"Chart type(Required) Optional: Line Chart,Histogram,Table,Stack Area,SingleStat,URL,Alert list,Text \\nExample: Line Chart\",\"*Width\":\"width(Required) Optional：1-12 \\nExample: 10\",\"*Height\":\"height(Required),Default unit（px/Pixel） \\nExample:400\",\"Unit\":\"unit(Required) Optional: \\nMisc: none,short,percent(0-100),percent(0.0-1.0),local format\\nData: bits,bytes,kilobytes,megabytes,gigabytes,terabytes,petabytes\\nDataRate: packets/sec,bits/sec,bytes/sec,kilobytes/sec,kilobits/sec,megabytes/sec,megabits/sec,gigabytes/sec,gigabits/sec,terabytes/sec,terabits/sec,petabytes/sec,petabits/sec\\nTime: Hertz(1/s),nanoseconds(ns),microseconds(us),milliseconds(ms),seconds(s),minutes(m),hours(h),days(d),YYYY-MM-DD HH:mm:ss,MM/DD/YYYY h:mm:ss a \\nExample: short\",\"*Parameter\":\"Parameters match type，The format is JSON format \\nExample: {\\\"statistics\\\":\\\"average\\\"}\",\"Elements\":\"When the type is line, table, stackArea, singleStat, histogram, it contains elements key and the value is an object array.\\nExample:[{\\\"expression\\\":\\\"sum(up)\\\",\\\"legend\\\":\\\"test\\\"}]\"}}', 1, NULL);
-
-DELETE FROM sys_config WHERE param_key = "model_chart_export_header";
-INSERT INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (NULL, 'model_chart_export_header', '{\"cn\":{\"*图表名称\":\"图表名称(必填)支持{{asset.sn}},{{asset.host}},{{asset.tag.[key]}},{{asset.tag.key}}取值替换 \\n示例: CPU使用率\",\"*图表类型\":\"图表类型(必填) 可选: 曲线图,柱状图,表格,堆叠区域图,SingleStat,URL,告警列表,文本 \\n示例: 曲线图\",\"*宽度\":\"宽度(必填) 可选：1-12 \\n示例: 10\",\"*高度\":\"高度(必填),默认单位（px/像素） \\n示例:400\",\"单位\":\"单位(必填) 可选: \\nMisc: none,short,percent(0-100),percent(0.0-1.0),local format\\nData: bits,bytes,kilobytes,megabytes,gigabytes,terabytes,petabytes\\nDataRate: packets/sec,bits/sec,bytes/sec,kilobytes/sec,kilobits/sec,megabytes/sec,megabits/sec,gigabytes/sec,gigabits/sec,terabytes/sec,terabits/sec,petabytes/sec,petabits/sec\\nTime: Hertz(1/s),nanoseconds(ns),microseconds(us),milliseconds(ms),seconds(s),minutes(m),hours(h),days(d),YYYY-MM-DD HH:mm:ss,MM/DD/YYYY h:mm:ss a \\n示例: short\",\"*参数\":\"单位 根据type不同，内容不同，格式为JSON格式 ,支持{{asset.sn}},{{asset.host}},{{asset.tag.[key]}},{{asset.tag.key}}取值替换  \\n示例: {\\\"statistics\\\":\\\"average\\\"}\",\"元素\":\"当type=line，bar，stackArea时，包含 elements key，值为对象数组，其中 expression 支持{{asset.sn}},{{asset.host}},{{asset.tag.[key]}},{{asset.tag.key}}取值替换 \\n 示例:[{\\\"expression\\\":\\\"sum(up)\\\",\\\"legend\\\":\\\"test\\\"}]\"},\"en\":{\"*Chart Title\":\"Chart title(Required) Support {{asset.sn}},{{asset.host}},{{asset.tag.[key]}},{{asset.tag.key}} value replacement \\nExample: CPU usage\",\"*Chart Type\":\"Chart type(Required) Optional: Line Chart,Histogram,Table,Stack Area,SingleStat,URL,Alert list,Text \\nExample: Line Chart\",\"*Width\":\"width(Required) Optional：1-12 \\nExample: 10\",\"*Height\":\"height(Required),Default unit（px/Pixel） \\nExample:400\",\"Unit\":\"unit(Required) Optional: \\nMisc: none,short,percent(0-100),percent(0.0-1.0),local format\\nData: bits,bytes,kilobytes,megabytes,gigabytes,terabytes,petabytes\\nDataRate: packets/sec,bits/sec,bytes/sec,kilobytes/sec,kilobits/sec,megabytes/sec,megabits/sec,gigabytes/sec,gigabits/sec,terabytes/sec,terabits/sec,petabytes/sec,petabits/sec\\nTime: Hertz(1/s),nanoseconds(ns),microseconds(us),milliseconds(ms),seconds(s),minutes(m),hours(h),days(d),YYYY-MM-DD HH:mm:ss,MM/DD/YYYY h:mm:ss a \\nExample: short\",\"*Parameter\":\"Parameters match type，The format is JSON format,Support {{asset.sn}},{{asset.host}},{{asset.tag.[key]}},{{asset.tag.key}} value replacement \\nExample: {\\\"statistics\\\":\\\"average\\\"}\",\"Elements\":\"When the type is line, table, stackArea, singleStat, histogram, it contains elements key and the value is an object array.The expression support {{asset.sn}},{{asset.host}},{{asset.tag.[key]}},{{asset.tag.key}} value replacement \\nExample:[{\\\"expression\\\":\\\"sum(up)\\\",\\\"legend\\\":\\\"test\\\"}]\"}}', 1, NULL);
-
-DELETE FROM sys_config WHERE param_key = "system_version";
-INSERT INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (NULL, 'system_version', '1.2', 1, 'nezha系统版本');
-
-/**
- * 更新 alert message 邮件发送模板
- */
-update sys_config set  param_value = "<html><head><meta http-equiv=\"content-type\" content=\"text/html; charset=UTF-8\"></head><body><div style=\"padding:40px 0; height:auto; min-height:100px; text-align:center;\"><span align=\"center\" style=\"margin:0 auto; min-width:290px; max-width:750px;\">${alertMessage.description}</span></div></body></html>" where param_key = "email_template";
-
-
-/**
- * 创建endpoint_state表
- */
-DROP TABLE IF EXISTS `endpoint_state`;
-CREATE TABLE `endpoint_state`  (
-  `id` int(11) NOT NULL,
-  `endpoint_id` int(11) NOT NULL,
-  `create_time` datetime(0) NULL DEFAULT NULL,
-  `state` int(11) NULL DEFAULT NULL,
-  PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-
-/**
- * 创建sysconfig数据
- */
-DELETE FROM sys_config WHERE param_key = "endpoint_alert_rule";
-INSERT INTO `sys_config`(`param_key`, `param_value`, `status`, `remark`) VALUES ('endpoint_alert_rule', '{\"alertName\": \"0\",\"for\": \"30s\",\"expr\": \"up{endpoint!=\'\'}>-1\"}', 1, NULL);
-DELETE FROM sys_config WHERE param_key = "endpoint_alert_push";
-INSERT INTO `sys_config`(`param_key`, `param_value`, `status`, `remark`) VALUES ('endpoint_alert_push', '1', 1, NULL);
diff --git a/nz-admin/db/2020-11-19.sql b/nz-admin/db/2020-11-19.sql
deleted file mode 100644
index a8cbabac..00000000
--- a/nz-admin/db/2020-11-19.sql
+++ /dev/null
@@ -1,34 +0,0 @@
-/**
- * 新增 notification_script notification_script表
- */
-
- -- ----------------------------
--- Table structure for notification_script
--- ----------------------------
-DROP TABLE IF EXISTS `notification_script`;
- CREATE TABLE `notification_script` (
-  `id` int(10) NOT NULL AUTO_INCREMENT,
-  `name` varchar(64) NOT NULL COMMENT '通知方式名称，唯一主键',
-  `file_path` varchar(256) DEFAULT NULL COMMENT '脚本路径，路径为 nz-web所在服务器路径',
-  PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;
-
-
- -- ----------------------------
--- Table structure for user_notification
--- ----------------------------
-DROP TABLE IF EXISTS `user_notification`;
-CREATE TABLE `user_notification` (
-  `id` int(10) NOT NULL AUTO_INCREMENT,
-  `user_id` int(10) NOT NULL COMMENT '用户id',
-  `script_id` int(10) NOT NULL COMMENT '脚本id',
-  `account` varchar(256) NOT NULL COMMENT '通知账号',
-  PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4;
-
-
-/**
- * sys_config 系统配置表新增 query_max_series 限制 prometheus query_range 接口 result 数组大小
- */
-DELETE FROM sys_config where param_key = "query_max_series";
-INSERT INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (NULL, 'query_max_series', '50', 1, '限制 prometheus query_range 接口 result 数组大小 区间范围[-1 - 1000] -1表示不限制');
-\ No newline at end of file
diff --git a/nz-admin/db/2020-11-20.sql b/nz-admin/db/2020-11-20.sql
deleted file mode 100644
index 5a67f996..00000000
--- a/nz-admin/db/2020-11-20.sql
+++ /dev/null
@@ -1,9 +0,0 @@
-/**
- * 1. sys_config 增加 alert 导出最大条数限制 param_key = export_max_line
- * 2. sys_config 增加 endpoint 状态采集调度周期设置 param_key = endpoint_query_interval 单位 s
- */
-DELETE from sys_config where param_key = "export_max_line";
-INSERT INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (NULL, 'export_max_line', '10000', 1, '告警导出最大行数');
-
-DELETE from sys_config where param_key = "endpoint_query_interval";
-INSERT INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (NULL, 'endpoint_query_interval', '30', 1, 'endpoint 状态采集定时任务周期 单位 s 秒，默认和 prometheus scrape_interval 保持一致');
diff --git a/nz-admin/db/2020-11-22.sql b/nz-admin/db/2020-11-22.sql
deleted file mode 100644
index b4e8780e..00000000
--- a/nz-admin/db/2020-11-22.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-
- /**
-  * chart 新增 weight 字段 , 作为排序使用, prev,next 暂时弃用
-  */
- ALTER TABLE chart ADD COLUMN weight INT(10) NOT NULL DEFAULT 0;
- ALTER TABLE chart MODIFY COLUMN `prev` int(10);
- ALTER TABLE chart MODIFY COLUMN `next` int(10);
-\ No newline at end of file
diff --git a/nz-admin/db/2020-11-25.sql b/nz-admin/db/2020-11-25.sql
deleted file mode 100644
index b22c22f4..00000000
--- a/nz-admin/db/2020-11-25.sql
+++ /dev/null
@@ -1,10 +0,0 @@
-/**
- * endpoint 导入导出表头更改
- */
-DELETE from sys_config where param_key = "endpoint_export_header";
-INSERT INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (NULL, 'endpoint_export_header', '{\"cn\":{\"*系统\":\"系统名称(必填) \\n示例: Nezha\",\"*组件\":\"组件名称(必填) \\n示例: node_exporter\",\"*组件类型\":\"组件类型(必填) 可选: HTTP、SNMP 当type = SNMP时，组件必须存在 \\n示例: HTTP\",\"资产序列号\":\"资产序列号(非必填) 与 主机地址 不能同时为空 \\n示例: A0420200101\",\"端口号\":\"端口号 范围0-65535 \\n示例: 9100\",\"参数\":\"端点查询参数，JSON格式， \\n示例: {\\\"key\\\":\\\"value\\\"}\",\"标签\":\"标签，JSON格式， \\n示例: {\\\"key\\\":\\\"value\\\"}\",\"*路径\":\"路径（必填） 请求路径，\\n示例: /metrics\",\"主机地址\":\"主机地址（非必填） 与 资产序列号 不能同时为空 \\n示例: 127.0.0.1\",\"启用\":\"启用状态（非必填） 可选 0:停用 1:启用,为空时默认为1 \\n示例: 1\"},\"en\":{\"*Project Name\":\"Project Name(Required) \\nExample: Nezha\",\"*Module Name\":\"Module Name(Required) \\nExample: node_exporter\",\"*Module Type\":\"Module type(Required) Optional: HTTP or SNMP，When type = SNMP, the component must exist \\nExample: HTTP\",\"Sn\":\"Asset serial number(Not required) And host address cannot be empty at the same time \\nExample: A0420200101\",\"Port\":\"Port number range 0-65535 \\nExample: 9100\",\"Parameter\":\"Endpoint query parameters, JSON format  \\nExample: {\\\"key\\\":\\\"value\\\"}\",\"Labels\":\"Endpoint lebel, JSON format  \\nExample: {\\\"key\\\":\\\"value\\\"}\",\"*Path\":\"Path (required) Request path \\nExample: /metrics\",\"Host\":\"Host address (not required) and asset serial number cannot be empty at the same time \\nExample: 127.0.0.1\",\"Enabled\":\"Enable state (not required) Optional values 0: Disable 1: Enable, when empty, the default is 1 \\nExample: 1\"}}', 1, NULL);
-
-/**
- * endpoint 增加 enabled 启用状态
- */
-ALTER TABLE endpoint ADD `enabled` INT(4) NOT NULL DEFAULT 1 COMMENT '可选值\r\n\r\n0：停用\r\n\r\n1：启用';
-\ No newline at end of file
diff --git a/nz-admin/db/2020-11-26.sql b/nz-admin/db/2020-11-26.sql
deleted file mode 100644
index 81dfdeb8..00000000
--- a/nz-admin/db/2020-11-26.sql
+++ /dev/null
@@ -1,5 +0,0 @@
-/**
- * nezha 高可用模式设置
- */
-INSERT INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (NULL, 'ha_mode', '2', 1, '1：Nezha，mariadb，redis分别部署 ,2：nezha，mariadb，redis共同部署在一台设备');
-INSERT INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (NULL, 'ha_vip', '192.168.40.42', 1, '当 ha_mode = 2时有效，记录nz-web对外提供的 vip');
-\ No newline at end of file
diff --git a/nz-admin/db/2020-12-03.sql b/nz-admin/db/2020-12-03.sql
deleted file mode 100644
index 24dd96c8..00000000
--- a/nz-admin/db/2020-12-03.sql
+++ /dev/null
@@ -1,56 +0,0 @@
-/**
- * 新增 角色 菜单表 , 其中 角色内置 admin\common 两个角色
- */
-DROP TABLE IF EXISTS `sys_role_menu`;
-CREATE TABLE `sys_role_menu` (
-  `id` int(10) NOT NULL AUTO_INCREMENT,
-  `role_id` int(10) NOT NULL,
-  `menu_id` int(10) NOT NULL,
-  PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8mb4;
-
-DROP TABLE IF EXISTS `sys_menu`;
-CREATE TABLE `sys_menu` (
-  `id` int(10) NOT NULL AUTO_INCREMENT,
-  `name` varchar(64) NOT NULL,
-  `code` varchar(64) NOT NULL COMMENT '唯一主键，前端根据此字段判断是否显示按钮或菜单',
-  `i18n` varchar(64) NOT NULL,
-  `parent_id` int(10) NOT NULL,
-  `perms` varchar(512) DEFAULT NULL COMMENT '多个用逗号分隔，后台根据此字段判断用户是否有权限访问接口',
-  `type` int(1) NOT NULL COMMENT '1：菜单 2：按钮',
-  `route` varchar(512) DEFAULT NULL,
-  `order_num` int(10) NOT NULL COMMENT '默认： 1',
-  PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4;
-
-
-DROP TABLE IF EXISTS `sys_role`;
-CREATE TABLE `sys_role` (
-  `id` int(10) NOT NULL AUTO_INCREMENT,
-  `name` varchar(64) NOT NULL,
-  `i18n` varchar(64) NOT NULL,
-  `remark` varchar(256) DEFAULT NULL,
-  `build_in` int(1) NOT NULL DEFAULT 0 COMMENT '可选值：\r\n\r\n0：非内置\r\n\r\n1：内置',
-  PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4;
-
-INSERT INTO `sys_role`(`id`, `name`, `i18n`, `remark`, `build_in`) VALUES (1, 'admin', 'admin', '系统内置管理员角色', 1);
-INSERT INTO `sys_role`(`id`, `name`, `i18n`, `remark`, `build_in`) VALUES (2, 'common', 'common', '系统内置普通用户角色', 1);
-
-
-DROP TABLE IF EXISTS `sys_role_menu`;
-CREATE TABLE `sys_role_menu` (
-  `id` int(10) NOT NULL AUTO_INCREMENT,
-  `role_id` int(10) NOT NULL,
-  `menu_id` int(10) NOT NULL,
-  PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8mb4;
-
-
-DROP TABLE IF EXISTS `sys_user_role`;
-CREATE TABLE `sys_user_role` (
-  `id` int(10) NOT NULL AUTO_INCREMENT,
-  `user_id` int(10) NOT NULL,
-  `role_id` int(10) NOT NULL,
-  PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4;
-\ No newline at end of file
diff --git a/nz-admin/db/2020-12-04.sql b/nz-admin/db/2020-12-04.sql
deleted file mode 100644
index 86524770..00000000
--- a/nz-admin/db/2020-12-04.sql
+++ /dev/null
@@ -1,5 +0,0 @@
-/**
- *  配置表中增加开发人员账号配置,用以限制菜单接口权限
- */
-DELETE from sys_config where param_key = "develop_admin";
-INSERT INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (NULL, 'develop_admin', 'admin', 1, NULL);
-\ No newline at end of file
diff --git a/nz-admin/db/2020-12-16.sql b/nz-admin/db/2020-12-16.sql
deleted file mode 100644
index 956f6ea6..00000000
--- a/nz-admin/db/2020-12-16.sql
+++ /dev/null
@@ -1,377 +0,0 @@
-/**
- * 初始化 角色和菜单相关数据
- */
-
--- ----------------------------
--- Records of sys_user_role
--- ----------------------------
-TRUNCATE sys_user_role;
-
-INSERT INTO sys_user_role ( role_id, user_id )
-SELECT sr.id,su.user_id FROM sys_role sr,sys_user su WHERE sr.name = "admin" AND su.username = "admin"
-UNION
-SELECT sr.id,su.user_id FROM sys_role sr,sys_user su WHERE sr.name = "common" AND su.username != "admin";
-
--- ----------------------------
--- Records of sys_role_menu
--- ----------------------------
-TRUNCATE sys_role_menu;
-INSERT INTO `sys_role_menu` VALUES (4505, 1, 512);
-INSERT INTO `sys_role_menu` VALUES (4506, 1, 513);
-INSERT INTO `sys_role_menu` VALUES (4507, 1, 2);
-INSERT INTO `sys_role_menu` VALUES (4508, 1, 514);
-INSERT INTO `sys_role_menu` VALUES (4509, 1, 515);
-INSERT INTO `sys_role_menu` VALUES (4510, 1, 516);
-INSERT INTO `sys_role_menu` VALUES (4511, 1, 517);
-INSERT INTO `sys_role_menu` VALUES (4512, 1, 518);
-INSERT INTO `sys_role_menu` VALUES (4513, 1, 519);
-INSERT INTO `sys_role_menu` VALUES (4514, 1, 520);
-INSERT INTO `sys_role_menu` VALUES (4515, 1, 521);
-INSERT INTO `sys_role_menu` VALUES (4516, 1, 522);
-INSERT INTO `sys_role_menu` VALUES (4517, 1, 523);
-INSERT INTO `sys_role_menu` VALUES (4518, 1, 524);
-INSERT INTO `sys_role_menu` VALUES (4519, 1, 525);
-INSERT INTO `sys_role_menu` VALUES (4520, 1, 526);
-INSERT INTO `sys_role_menu` VALUES (4521, 1, 527);
-INSERT INTO `sys_role_menu` VALUES (4522, 1, 528);
-INSERT INTO `sys_role_menu` VALUES (4523, 1, 529);
-INSERT INTO `sys_role_menu` VALUES (4524, 1, 18);
-INSERT INTO `sys_role_menu` VALUES (4525, 1, 19);
-INSERT INTO `sys_role_menu` VALUES (4526, 1, 20);
-INSERT INTO `sys_role_menu` VALUES (4527, 1, 1301);
-INSERT INTO `sys_role_menu` VALUES (4528, 1, 1302);
-INSERT INTO `sys_role_menu` VALUES (4529, 1, 1303);
-INSERT INTO `sys_role_menu` VALUES (4530, 1, 1304);
-INSERT INTO `sys_role_menu` VALUES (4531, 1, 1305);
-INSERT INTO `sys_role_menu` VALUES (4532, 1, 801);
-INSERT INTO `sys_role_menu` VALUES (4533, 1, 802);
-INSERT INTO `sys_role_menu` VALUES (4534, 1, 803);
-INSERT INTO `sys_role_menu` VALUES (4535, 1, 301);
-INSERT INTO `sys_role_menu` VALUES (4536, 1, 302);
-INSERT INTO `sys_role_menu` VALUES (4537, 1, 303);
-INSERT INTO `sys_role_menu` VALUES (4538, 1, 304);
-INSERT INTO `sys_role_menu` VALUES (4539, 1, 305);
-INSERT INTO `sys_role_menu` VALUES (4540, 1, 306);
-INSERT INTO `sys_role_menu` VALUES (4541, 1, 307);
-INSERT INTO `sys_role_menu` VALUES (4542, 1, 308);
-INSERT INTO `sys_role_menu` VALUES (4543, 1, 2101);
-INSERT INTO `sys_role_menu` VALUES (4544, 1, 309);
-INSERT INTO `sys_role_menu` VALUES (4545, 1, 2102);
-INSERT INTO `sys_role_menu` VALUES (4546, 1, 310);
-INSERT INTO `sys_role_menu` VALUES (4547, 1, 2103);
-INSERT INTO `sys_role_menu` VALUES (4548, 1, 311);
-INSERT INTO `sys_role_menu` VALUES (4549, 1, 2104);
-INSERT INTO `sys_role_menu` VALUES (4550, 1, 312);
-INSERT INTO `sys_role_menu` VALUES (4551, 1, 2105);
-INSERT INTO `sys_role_menu` VALUES (4552, 1, 2106);
-INSERT INTO `sys_role_menu` VALUES (4553, 1, 2107);
-INSERT INTO `sys_role_menu` VALUES (4554, 1, 2108);
-INSERT INTO `sys_role_menu` VALUES (4555, 1, 2109);
-INSERT INTO `sys_role_menu` VALUES (4556, 1, 2110);
-INSERT INTO `sys_role_menu` VALUES (4557, 1, 1601);
-INSERT INTO `sys_role_menu` VALUES (4558, 1, 1602);
-INSERT INTO `sys_role_menu` VALUES (4559, 1, 1603);
-INSERT INTO `sys_role_menu` VALUES (4560, 1, 1604);
-INSERT INTO `sys_role_menu` VALUES (4561, 1, 1605);
-INSERT INTO `sys_role_menu` VALUES (4562, 1, 1606);
-INSERT INTO `sys_role_menu` VALUES (4563, 1, 1607);
-INSERT INTO `sys_role_menu` VALUES (4564, 1, 1608);
-INSERT INTO `sys_role_menu` VALUES (4565, 1, 1101);
-INSERT INTO `sys_role_menu` VALUES (4566, 1, 1102);
-INSERT INTO `sys_role_menu` VALUES (4567, 1, 1103);
-INSERT INTO `sys_role_menu` VALUES (4568, 1, 1104);
-INSERT INTO `sys_role_menu` VALUES (4569, 1, 1105);
-INSERT INTO `sys_role_menu` VALUES (4570, 1, 601);
-INSERT INTO `sys_role_menu` VALUES (4571, 1, 602);
-INSERT INTO `sys_role_menu` VALUES (4572, 1, 603);
-INSERT INTO `sys_role_menu` VALUES (4573, 1, 604);
-INSERT INTO `sys_role_menu` VALUES (4574, 1, 605);
-INSERT INTO `sys_role_menu` VALUES (4575, 1, 606);
-INSERT INTO `sys_role_menu` VALUES (4576, 1, 607);
-INSERT INTO `sys_role_menu` VALUES (4577, 1, 608);
-INSERT INTO `sys_role_menu` VALUES (4578, 1, 609);
-INSERT INTO `sys_role_menu` VALUES (4579, 1, 610);
-INSERT INTO `sys_role_menu` VALUES (4580, 1, 611);
-INSERT INTO `sys_role_menu` VALUES (4581, 1, 612);
-INSERT INTO `sys_role_menu` VALUES (4582, 1, 613);
-INSERT INTO `sys_role_menu` VALUES (4583, 1, 614);
-INSERT INTO `sys_role_menu` VALUES (4584, 1, 615);
-INSERT INTO `sys_role_menu` VALUES (4585, 1, 616);
-INSERT INTO `sys_role_menu` VALUES (4586, 1, 617);
-INSERT INTO `sys_role_menu` VALUES (4587, 1, 618);
-INSERT INTO `sys_role_menu` VALUES (4588, 1, 619);
-INSERT INTO `sys_role_menu` VALUES (4589, 1, 620);
-INSERT INTO `sys_role_menu` VALUES (4590, 1, 621);
-INSERT INTO `sys_role_menu` VALUES (4591, 1, 622);
-INSERT INTO `sys_role_menu` VALUES (4592, 1, 623);
-INSERT INTO `sys_role_menu` VALUES (4593, 1, 1401);
-INSERT INTO `sys_role_menu` VALUES (4594, 1, 1402);
-INSERT INTO `sys_role_menu` VALUES (4595, 1, 1403);
-INSERT INTO `sys_role_menu` VALUES (4596, 1, 1404);
-INSERT INTO `sys_role_menu` VALUES (4597, 1, 1405);
-INSERT INTO `sys_role_menu` VALUES (4598, 1, 1406);
-INSERT INTO `sys_role_menu` VALUES (4599, 1, 1407);
-INSERT INTO `sys_role_menu` VALUES (4600, 1, 1408);
-INSERT INTO `sys_role_menu` VALUES (4601, 1, 1409);
-INSERT INTO `sys_role_menu` VALUES (4602, 1, 1410);
-INSERT INTO `sys_role_menu` VALUES (4603, 1, 1411);
-INSERT INTO `sys_role_menu` VALUES (4604, 1, 1412);
-INSERT INTO `sys_role_menu` VALUES (4605, 1, 901);
-INSERT INTO `sys_role_menu` VALUES (4606, 1, 902);
-INSERT INTO `sys_role_menu` VALUES (4607, 1, 903);
-INSERT INTO `sys_role_menu` VALUES (4608, 1, 904);
-INSERT INTO `sys_role_menu` VALUES (4609, 1, 905);
-INSERT INTO `sys_role_menu` VALUES (4610, 1, 906);
-INSERT INTO `sys_role_menu` VALUES (4611, 1, 907);
-INSERT INTO `sys_role_menu` VALUES (4612, 1, 908);
-INSERT INTO `sys_role_menu` VALUES (4613, 1, 909);
-INSERT INTO `sys_role_menu` VALUES (4614, 1, 910);
-INSERT INTO `sys_role_menu` VALUES (4615, 1, 401);
-INSERT INTO `sys_role_menu` VALUES (4616, 1, 402);
-INSERT INTO `sys_role_menu` VALUES (4617, 1, 403);
-INSERT INTO `sys_role_menu` VALUES (4618, 1, 1701);
-INSERT INTO `sys_role_menu` VALUES (4619, 1, 1702);
-INSERT INTO `sys_role_menu` VALUES (4620, 1, 1703);
-INSERT INTO `sys_role_menu` VALUES (4621, 1, 1704);
-INSERT INTO `sys_role_menu` VALUES (4622, 1, 1705);
-INSERT INTO `sys_role_menu` VALUES (4623, 1, 1706);
-INSERT INTO `sys_role_menu` VALUES (4624, 1, 1707);
-INSERT INTO `sys_role_menu` VALUES (4625, 1, 1708);
-INSERT INTO `sys_role_menu` VALUES (4626, 1, 1709);
-INSERT INTO `sys_role_menu` VALUES (4627, 1, 1710);
-INSERT INTO `sys_role_menu` VALUES (4628, 1, 1711);
-INSERT INTO `sys_role_menu` VALUES (4629, 1, 1712);
-INSERT INTO `sys_role_menu` VALUES (4630, 1, 1201);
-INSERT INTO `sys_role_menu` VALUES (4631, 1, 1713);
-INSERT INTO `sys_role_menu` VALUES (4632, 1, 1202);
-INSERT INTO `sys_role_menu` VALUES (4633, 1, 1203);
-INSERT INTO `sys_role_menu` VALUES (4634, 1, 1204);
-INSERT INTO `sys_role_menu` VALUES (4635, 1, 1205);
-INSERT INTO `sys_role_menu` VALUES (4636, 1, 1501);
-INSERT INTO `sys_role_menu` VALUES (4637, 1, 1502);
-INSERT INTO `sys_role_menu` VALUES (4638, 1, 1503);
-INSERT INTO `sys_role_menu` VALUES (4639, 1, 1504);
-INSERT INTO `sys_role_menu` VALUES (4640, 1, 1505);
-INSERT INTO `sys_role_menu` VALUES (4641, 1, 1506);
-INSERT INTO `sys_role_menu` VALUES (4642, 1, 1507);
-INSERT INTO `sys_role_menu` VALUES (4643, 1, 1508);
-INSERT INTO `sys_role_menu` VALUES (4644, 1, 1509);
-INSERT INTO `sys_role_menu` VALUES (4645, 1, 1510);
-INSERT INTO `sys_role_menu` VALUES (4646, 1, 1511);
-INSERT INTO `sys_role_menu` VALUES (4647, 1, 1512);
-INSERT INTO `sys_role_menu` VALUES (4648, 1, 1513);
-INSERT INTO `sys_role_menu` VALUES (4649, 1, 1514);
-INSERT INTO `sys_role_menu` VALUES (4650, 1, 501);
-INSERT INTO `sys_role_menu` VALUES (4651, 1, 502);
-INSERT INTO `sys_role_menu` VALUES (4652, 1, 503);
-INSERT INTO `sys_role_menu` VALUES (4653, 1, 504);
-INSERT INTO `sys_role_menu` VALUES (4654, 1, 505);
-INSERT INTO `sys_role_menu` VALUES (4655, 1, 506);
-INSERT INTO `sys_role_menu` VALUES (4656, 1, 507);
-INSERT INTO `sys_role_menu` VALUES (4657, 1, 508);
-INSERT INTO `sys_role_menu` VALUES (4658, 1, 509);
-INSERT INTO `sys_role_menu` VALUES (4659, 1, 510);
-INSERT INTO `sys_role_menu` VALUES (4660, 1, 511);
-INSERT INTO `sys_role_menu` VALUES (4661, 2, 1505);
-INSERT INTO `sys_role_menu` VALUES (4662, 2, 1601);
-INSERT INTO `sys_role_menu` VALUES (4663, 2, 2);
-INSERT INTO `sys_role_menu` VALUES (4664, 2, 803);
-INSERT INTO `sys_role_menu` VALUES (4665, 2, 1411);
-INSERT INTO `sys_role_menu` VALUES (4666, 2, 516);
-INSERT INTO `sys_role_menu` VALUES (4667, 2, 1412);
-INSERT INTO `sys_role_menu` VALUES (4668, 2, 1606);
-INSERT INTO `sys_role_menu` VALUES (4669, 2, 615);
-INSERT INTO `sys_role_menu` VALUES (4670, 2, 1607);
-INSERT INTO `sys_role_menu` VALUES (4671, 2, 1608);
-INSERT INTO `sys_role_menu` VALUES (4672, 2, 905);
-INSERT INTO `sys_role_menu` VALUES (4673, 2, 618);
-INSERT INTO `sys_role_menu` VALUES (4674, 2, 1514);
-INSERT INTO `sys_role_menu` VALUES (4675, 2, 910);
-INSERT INTO `sys_role_menu` VALUES (4676, 2, 623);
-INSERT INTO `sys_role_menu` VALUES (4677, 2, 529);
-INSERT INTO `sys_role_menu` VALUES (4678, 2, 403);
-INSERT INTO `sys_role_menu` VALUES (4679, 2, 20);
-INSERT INTO `sys_role_menu` VALUES (4680, 2, 2101);
-INSERT INTO `sys_role_menu` VALUES (4681, 2, 312);
-INSERT INTO `sys_role_menu` VALUES (4682, 2, 1305);
-INSERT INTO `sys_role_menu` VALUES (4683, 2, 509);
-
-
-
--- ----------------------------
--- Records of sys_menu
--- ----------------------------
-TRUNCATE sys_menu;
-INSERT INTO `sys_menu` VALUES (1, 'dashboard', 'dashboard', 'dashboard.title', 0, 'sys:config:list,project:list,idc:taffic:list,idc:list,overview:stat,project:topo:list,module:stat,project:topo:icon:info', 1, '', 1);
-INSERT INTO `sys_menu` VALUES (2, 'overview', 'overview', 'dashboard.overview.title', 1, 'sys:config:list,project:list,idc:taffic:list,idc:list,overview:stat,project:topo:list,module:stat,project:topo:icon:info', 1, '/overview', 1);
-INSERT INTO `sys_menu` VALUES (3, 'panel', 'panel', 'dashboard.panel.title', 1, 'panel:list,chart:list,panel:modify,chart:modify,chart:weights', 1, '/panel', 2);
-INSERT INTO `sys_menu` VALUES (4, 'explore', 'explore', 'dashboard.metricPreview.title', 1, 'panel:list', 1, '/explore', 3);
-INSERT INTO `sys_menu` VALUES (5, 'asset', 'asset', 'overall.asset', 0, 'asset:tag:key,asset:list,sys:user:list,asset:filter,model:list,asset:info', 1, '/asset', 2);
-INSERT INTO `sys_menu` VALUES (6, 'project', 'project', 'overall.project', 0, 'module:list,sys:user:list,project:list,project:info,project:topo:icon:list,module:stat,project:topo:icon:info,endpoint:list,project:topo:list,asset:info,asset:list,alert:message:list,idc:list,alert:rule:list,panel:list', 1, '/project', 3);
-INSERT INTO `sys_menu` VALUES (7, 'alert', 'alert', 'alert.alert', 0, 'idc:list,alert:message:list,asset:list,module:list,project:list', 1, '', 4);
-INSERT INTO `sys_menu` VALUES (8, 'alertList', 'alertList', 'alert.alertList', 7, 'idc:list,alert:message:list,asset:list,module:list,project:list,asset:info,endpoint:list,alert:rule:list', 1, '/alertList', 1);
-INSERT INTO `sys_menu` VALUES (9, 'alertConfig', 'alertConfig', 'alert.alertConfig', 7, 'alert:rule:list,asset:list,alert:rule:stat,alert:rule:stat', 1, '/alertConfig', 2);
-INSERT INTO `sys_menu` VALUES (10, 'settings', 'settings', 'overall.config', 0, 'alert:script:list,sys:user:list', 1, '', 5);
-INSERT INTO `sys_menu` VALUES (11, 'account', 'account', 'config.account.account', 10, 'alert:script:list,sys:user:list', 1, '/account', 1);
-INSERT INTO `sys_menu` VALUES (12, 'role', 'role', 'config.roles.roles', 10, 'sys:role:list,sys:role:menu', 1, '/roles', 2);
-INSERT INTO `sys_menu` VALUES (13, 'promServer', 'promServer', 'config.promServer.promServerList', 10, 'idc:list,promserver:list', 1, '/promServer', 3);
-INSERT INTO `sys_menu` VALUES (14, 'dc', 'dc', 'config.dc.dc', 10, 'idc:list,sys:user:list,cabinet:list', 1, '/dc', 4);
-INSERT INTO `sys_menu` VALUES (15, 'model', 'model', 'config.model.model', 10, 'model:list', 1, '/model', 5);
-INSERT INTO `sys_menu` VALUES (16, 'mib', 'mib', 'config.mib.mib', 10, 'sys:mib:list', 1, '/mib', 6);
-INSERT INTO `sys_menu` VALUES (17, 'system', 'system', 'config.system.system', 10, 'sys:config:list,sys:link:list,alert:script:list,sys:link:modify', 1, '/system', 7);
-INSERT INTO `sys_menu` VALUES (18, 'terminalLog', 'terminalLog', 'config.terminallog.terminallog', 10, 'terminal:log:list', 1, '/terminalLog', 8);
-INSERT INTO `sys_menu` VALUES (19, 'operationLog', 'operationLog', 'config.operationlog.operationlog', 10, 'sys:log:list', 1, '/operationLog', 9);
-INSERT INTO `sys_menu` VALUES (20, 'about', 'about', 'overall.about', 10, 'sys:about:info', 1, '/about', 10);
-INSERT INTO `sys_menu` VALUES (21, 'header', 'header', 'buttons.header.header', 0, NULL, 1, '', 0);
-INSERT INTO `sys_menu` VALUES (301, 'panel_toAdd', 'panel_toAdd', 'buttons.panel.toAdd', 3, NULL, 2, '', 10);
-INSERT INTO `sys_menu` VALUES (302, 'panel_toEdit', 'panel_toEdit', 'buttons.panel.toEdit', 3, NULL, 2, '', 15);
-INSERT INTO `sys_menu` VALUES (303, 'panel_delete', 'panel_delete', 'buttons.panel.delete', 3, 'panel:delete', 2, '', 20);
-INSERT INTO `sys_menu` VALUES (304, 'panel_save', 'panel_save', 'buttons.panel.save', 3, 'panel:save,panel:update', 2, '', 25);
-INSERT INTO `sys_menu` VALUES (305, 'panel_chart_toAdd', 'panel_chart_toAdd', 'buttons.panel.chart.toAdd', 3, 'module:list', 2, '', 30);
-INSERT INTO `sys_menu` VALUES (306, 'panel_chart_import', 'panel_chart_import', 'buttons.panel.chart.import', 3, 'chart:import,chart:import:template,chart:cancel:import', 2, '', 35);
-INSERT INTO `sys_menu` VALUES (307, 'panel_chart_export', 'panel_chart_export', 'buttons.panel.chart.export', 3, 'chart:export', 2, '', 40);
-INSERT INTO `sys_menu` VALUES (308, 'panel_chart_toEdit', 'panel_chart_toEdit', 'buttons.panel.chart.toEdit', 3, 'module:list', 2, '', 45);
-INSERT INTO `sys_menu` VALUES (309, 'panel_chart_save', 'panel_chart_save', 'buttons.panel.chart.save', 3, 'chart:save,chart:update', 2, '', 50);
-INSERT INTO `sys_menu` VALUES (310, 'panel_chart_delete', 'panel_chart_delete', 'buttons.panel.chart.delete', 3, 'chart:delete', 2, '', 55);
-INSERT INTO `sys_menu` VALUES (311, 'panel_chart_duplicate', 'panel_chart_duplicate', 'buttons.panel.chart.duplicate', 3, 'chart:duplicate', 2, '', 60);
-INSERT INTO `sys_menu` VALUES (312, 'panel_view', 'panel_view', 'buttons.panel.view', 3, 'panel:list,chart:list,panel:modify,chart:modify,chart:weights', 2, '', 5);
-INSERT INTO `sys_menu` VALUES (401, 'explore_chart_toAdd', 'explore_chart_toAdd', 'buttons.explore.toAdd', 4, 'module:list', 2, '', 10);
-INSERT INTO `sys_menu` VALUES (402, 'explore_chart_save', 'explore_chart_save', 'buttons.explore.save', 4, 'chart:save', 2, '', 15);
-INSERT INTO `sys_menu` VALUES (403, 'explore_view', 'explore_view', 'buttons.explore.view', 4, NULL, 2, '', 5);
-INSERT INTO `sys_menu` VALUES (501, 'asset_toAdd', 'asset_toAdd', 'buttons.asset.toAdd', 5, 'sys:user:list,sys:dict:all,idc:list,asset:tag:key,model:list', 2, '', 10);
-INSERT INTO `sys_menu` VALUES (502, 'asset_toEdit', 'asset_toEdit', 'buttons.asset.toEdit', 5, 'sys:user:list,sys:dict:all,idc:list,asset:tag:key,cabinet:list,cabinet:u:info,model:list', 2, '', 15);
-INSERT INTO `sys_menu` VALUES (503, 'asset_toBatchEdit', 'asset_toBatchEdit', 'buttons.asset.toBatchEdit', 5, 'sys:user:list', 2, '', 20);
-INSERT INTO `sys_menu` VALUES (504, 'asset_delete', 'asset_delete', 'buttons.asset.delete', 5, 'asset:delete', 2, '', 25);
-INSERT INTO `sys_menu` VALUES (505, 'asset_save', 'asset_save', 'buttons.asset.save', 5, 'asset:save,asset:update,asset:batch:update', 2, '', 30);
-INSERT INTO `sys_menu` VALUES (506, 'asset_import', 'asset_import', 'buttons.asset.import', 5, 'asset:import,asset:import:template,asset:cancel:import', 2, '', 35);
-INSERT INTO `sys_menu` VALUES (507, 'asset_export', 'asset_export', 'buttons.asset.export', 5, 'asset:export', 2, '', 40);
-INSERT INTO `sys_menu` VALUES (508, 'asset_connect', 'asset_connect', 'buttons.asset.connect', 5, NULL, 2, '', 45);
-INSERT INTO `sys_menu` VALUES (509, 'asset_endpoint_view', 'asset_endpoint_view', 'buttons.asset.endpoint.view', 5, 'endpoint:list,model:list', 2, '', 50);
-INSERT INTO `sys_menu` VALUES (510, 'asset_endpoint_toAdd', 'asset_endpoint_toAdd', 'buttons.asset.endpoint.toAdd', 5, 'module:list,asset:list,idc:list,project:list,model:list,sys:dict:all', 2, '', 55);
-INSERT INTO `sys_menu` VALUES (511, 'asset_endpoint_toEdit', 'asset_endpoint_toEdit', 'buttons.asset.endpoint.toEdit', 5, 'asset:list,project:list,module:list', 2, '', 60);
-INSERT INTO `sys_menu` VALUES (512, 'asset_endpoint_delete', 'asset_endpoint_delete', 'buttons.asset.endpoint.delete', 5, 'endpoint:delete', 2, '', 65);
-INSERT INTO `sys_menu` VALUES (513, 'asset_endpoint_save', 'asset_endpoint_save', 'buttons.asset.endpoint.save', 5, 'endpoint:save,endpoint:update', 2, '', 70);
-INSERT INTO `sys_menu` VALUES (514, 'asset_endpoint_import', 'asset_endpoint_import', 'buttons.asset.endpoint.import', 5, 'endpoint:import,endpoint:import:template,endpoint:cancel:import', 2, '', 75);
-INSERT INTO `sys_menu` VALUES (515, 'asset_endpoint_export', 'asset_endpoint_export', 'buttons.asset.endpoint.export', 5, 'endpoint:export', 2, '', 80);
-INSERT INTO `sys_menu` VALUES (516, 'asset_alerts_view', 'asset_alerts_view', 'buttons.asset.alerts.view', 5, 'idc:list,alert:message:list,model:list', 2, '', 85);
-INSERT INTO `sys_menu` VALUES (517, 'asset_alerts_delete', 'asset_alerts_delete', 'buttons.asset.alerts.delete', 5, 'alert:message:update', 2, '', 90);
-INSERT INTO `sys_menu` VALUES (518, 'asset_alerts_export', 'asset_alerts_export', 'buttons.asset.alerts.export', 5, 'alert:message:export', 2, '', 95);
-INSERT INTO `sys_menu` VALUES (519, 'asset_chart_toAdd', 'asset_chart_toAdd', 'buttons.asset.chart.toAdd', 5, 'module:list', 2, '', 100);
-INSERT INTO `sys_menu` VALUES (520, 'asset_chart_import', 'asset_chart_import', 'buttons.asset.chart.import', 5, 'chart:import,chart:import:template,chart:cancel:import', 2, '', 105);
-INSERT INTO `sys_menu` VALUES (521, 'asset_chart_export', 'asset_chart_export', 'buttons.asset.chart.export', 5, 'chart:export', 2, '', 110);
-INSERT INTO `sys_menu` VALUES (522, 'asset_chart_toEdit', 'asset_chart_toEdit', 'buttons.asset.chart.toEdit', 5, 'module:list', 2, '', 115);
-INSERT INTO `sys_menu` VALUES (523, 'asset_chart_save', 'asset_chart_save', 'buttons.asset.chart.save', 5, 'chart:save,chart:update', 2, '', 120);
-INSERT INTO `sys_menu` VALUES (524, 'asset_chart_delete', 'asset_chart_delete', 'buttons.asset.chart.delete', 5, 'chart:delete', 2, '', 125);
-INSERT INTO `sys_menu` VALUES (525, 'asset_chart_duplicate', 'asset_chart_duplicate', 'buttons.asset.chart.duplicate', 5, 'chart:duplicate', 2, '', 130);
-INSERT INTO `sys_menu` VALUES (526, 'asset_chart_sync', 'asset_chart_sync', 'buttons.asset.chart.sync', 5, 'model:sync:chart,panel:list', 2, '', 135);
-INSERT INTO `sys_menu` VALUES (527, 'asset_vendor_toAdd', 'asset_vendor_toAdd', 'buttons.asset.vendor.toAdd', 5, 'sys:dict:all', 2, '', 140);
-INSERT INTO `sys_menu` VALUES (528, 'asset_vendor_save', 'asset_vendor_save', 'buttons.asset.vendor.save', 5, 'model:save,sys:dict:save', 2, '', 145);
-INSERT INTO `sys_menu` VALUES (529, 'asset_view', 'asset_view', 'buttons.asset.view', 5, 'asset:tag:key,asset:list,sys:user:list,asset:filter,model:list,asset:info', 2, '', 5);
-INSERT INTO `sys_menu` VALUES (601, 'project_toEdit', 'project_toEdit', 'buttons.project.toEdit', 6, NULL, 2, '', 10);
-INSERT INTO `sys_menu` VALUES (602, 'project_save', 'project_save', 'buttons.project.save', 6, 'project:save,project:update', 2, '', 15);
-INSERT INTO `sys_menu` VALUES (603, 'project_delete', 'project_delete', 'buttons.project.delete', 6, 'project:delete', 2, '', 20);
-INSERT INTO `sys_menu` VALUES (604, 'project_topo_edit', 'project_topo_edit', 'buttons.project.topo.edit', 6, 'project:topo:icon:save', 2, '', 25);
-INSERT INTO `sys_menu` VALUES (605, 'project_topo_save', 'project_topo_save', 'buttons.project.topo.save', 6, 'project:topo:update', 2, '', 30);
-INSERT INTO `sys_menu` VALUES (606, 'project_module_toEdit', 'project_module_toEdit', 'buttons.project.module.toEdit', 6, 'sys:mib:tree', 2, '', 40);
-INSERT INTO `sys_menu` VALUES (607, 'project_module_save', 'project_module_save', 'buttons.project.module.save', 6, 'module:save,module:update', 2, '', 45);
-INSERT INTO `sys_menu` VALUES (608, 'project_module_delete', 'project_module_delete', 'buttons.project.module.delete', 6, 'module:delete', 2, '', 50);
-INSERT INTO `sys_menu` VALUES (609, 'project_endpoint_toAdd', 'project_endpoint_toAdd', 'buttons.project.endpoint.toAdd', 6, 'asset:list,idc:list,model:list,sys:dict:all', 2, '', 55);
-INSERT INTO `sys_menu` VALUES (610, 'project_endpoint_toEdit', 'project_endpoint_toEdit', 'buttons.project.endpoint.toEdit', 6, 'asset:list', 2, '', 60);
-INSERT INTO `sys_menu` VALUES (611, 'project_endpoint_delete', 'project_endpoint_delete', 'buttons.project.endpoint.delete', 6, 'endpoint:delete', 2, '', 65);
-INSERT INTO `sys_menu` VALUES (612, 'project_endpoint_save', 'project_endpoint_save', 'buttons.project.endpoint.save', 6, 'endpoint:save,endpoint:update', 2, '', 70);
-INSERT INTO `sys_menu` VALUES (613, 'project_endpoint_import', 'project_endpoint_import', 'buttons.project.endpoint.import', 6, 'endpoint:import,endpoint:import:template,endpoint:cancel:import', 2, '', 75);
-INSERT INTO `sys_menu` VALUES (614, 'project_endpoint_export', 'project_endpoint_export', 'buttons.project.endpoint.export', 6, 'endpoint:export', 2, '', 80);
-INSERT INTO `sys_menu` VALUES (615, 'project_endpoint_alerts_view', 'project_endpoint_alerts_view', 'buttons.project.endpoint.alerts.view', 6, 'asset:list,idc:list,alert:message:list', 2, '', 85);
-INSERT INTO `sys_menu` VALUES (616, 'project_endpoint_alerts_delete', 'project_endpoint_alerts_delete', 'buttons.project.endpoint.alerts.delete', 6, 'alert:message:update', 2, '', 90);
-INSERT INTO `sys_menu` VALUES (617, 'project_endpoint_alerts_export', 'project_endpoint_alerts_export', 'buttons.project.endpoint.alerts.export', 6, 'alert:message:export', 2, '', 95);
-INSERT INTO `sys_menu` VALUES (618, 'project_endpoint_query_chart_view', 'project_endpoint_query_chart_view', 'buttons.project.endpoint.query.view', 6, 'asset:list,panel:list', 2, '', 100);
-INSERT INTO `sys_menu` VALUES (619, 'project_endpoint_query_chart_toAdd', 'project_endpoint_query_chart_toAdd', 'buttons.project.endpoint.query.toAdd', 6, 'module:list', 2, '', 105);
-INSERT INTO `sys_menu` VALUES (620, 'project_endpoint_query_chart_save', 'project_endpoint_query_chart_save', 'buttons.project.endpoint.query.save', 6, 'chart:save,chart:update', 2, '', 110);
-INSERT INTO `sys_menu` VALUES (621, 'project_toAdd', 'project_toAdd', 'buttons.header.add.project', 6, NULL, 2, '', 5);
-INSERT INTO `sys_menu` VALUES (622, 'project_module_toAdd', 'project_module_toAdd', 'buttons.header.add.module', 6, NULL, 2, '', 35);
-INSERT INTO `sys_menu` VALUES (623, 'project_view', 'project_view', 'buttons.project.view', 6, 'module:list,sys:user:list,project:list,project:info,project:topo:icon:list,module:stat,project:topo:icon:info,endpoint:list,project:topo:list,asset:info,asset:list,alert:message:list,idc:list,alert:rule:list,panel:list', 2, '', 3);
-INSERT INTO `sys_menu` VALUES (801, 'message_delete', 'message_delete', 'buttons.message.delete', 8, 'alert:message:update', 2, '', 10);
-INSERT INTO `sys_menu` VALUES (802, 'message_export', 'message_export', 'buttons.message.export', 8, 'alert:message:export', 2, '', 15);
-INSERT INTO `sys_menu` VALUES (803, 'message_view', 'message_view', 'buttons.message.view', 8, 'idc:list,alert:message:list,asset:list,module:list,project:list,asset:info,endpoint:list,alert:rule:list', 2, '', 5);
-INSERT INTO `sys_menu` VALUES (901, 'rule_toAdd', 'rule_toAdd', 'buttons.rule.toAdd', 9, 'sys:user:list', 2, '', 10);
-INSERT INTO `sys_menu` VALUES (902, 'rule_toEdit', 'rule_toEdit', 'buttons.rule.toEdit', 9, 'sys:user:list', 2, '', 15);
-INSERT INTO `sys_menu` VALUES (903, 'rule_delete', 'rule_delete', 'buttons.rule.delete', 9, 'alert:rule:delete', 2, '', 20);
-INSERT INTO `sys_menu` VALUES (904, 'rule_save', 'rule_save', 'buttons.rule.save', 9, 'alert:rule:save,alert:rule:update', 2, '', 25);
-INSERT INTO `sys_menu` VALUES (905, 'rule_alerts_view', 'rule_alerts_view', 'buttons.rule.alerts.view', 9, 'idc:list,alert:message:list,asset:list,asset:info,endpoint:list,alert:rule:stat', 2, '', 30);
-INSERT INTO `sys_menu` VALUES (906, 'rule_alerts_delete', 'rule_alerts_delete', 'buttons.rule.alerts.delete', 9, 'alert:message:update', 2, '', 35);
-INSERT INTO `sys_menu` VALUES (907, 'rule_alerts_export', 'rule_alerts_export', 'buttons.rule.alerts.export', 9, 'alert:message:export', 2, '', 40);
-INSERT INTO `sys_menu` VALUES (908, 'rule_import', 'rule_import', 'overall.importExcel', 9, 'alert:rule:import,alert:rule:cancel:import,alert:rule:template', 2, '', 45);
-INSERT INTO `sys_menu` VALUES (909, 'rule_export', 'rule_export', 'overall.exportExcel', 9, 'alert:rule:export', 2, '', 50);
-INSERT INTO `sys_menu` VALUES (910, 'rule_view', 'rule_view', 'buttons.rule.view', 9, 'alert:rule:list,asset:list,alert:rule:stat', 2, '', 5);
-INSERT INTO `sys_menu` VALUES (1101, 'account_toAdd', 'account_toAdd', 'buttons.account.toAdd', 11, 'sys:role:list', 2, '', 10);
-INSERT INTO `sys_menu` VALUES (1102, 'account_toEdit', 'account_toEdit', 'buttons.account.toEdit', 11, 'sys:role:list', 2, '', 15);
-INSERT INTO `sys_menu` VALUES (1103, 'account_delete', 'account_delete', 'buttons.account.delete', 11, 'sys:user:delete', 2, '', 20);
-INSERT INTO `sys_menu` VALUES (1104, 'account_save', 'account_save', 'buttons.account.save', 11, 'sys:user:save,sys:user:update', 2, '', 25);
-INSERT INTO `sys_menu` VALUES (1105, 'account_view', 'account_view', 'buttons.account.view', 11, 'alert:script:list,sys:user:list', 2, '', 5);
-INSERT INTO `sys_menu` VALUES (1201, 'role_toAdd', 'role_toAdd', 'buttons.role.toAdd', 12, 'sys:menu:list', 2, '', 10);
-INSERT INTO `sys_menu` VALUES (1202, 'role_toEdit', 'role_toEdit', 'buttons.role.toEdit', 12, 'sys:role:menu', 2, '', 15);
-INSERT INTO `sys_menu` VALUES (1203, 'role_delete', 'role_delete', 'buttons.role.delete', 12, 'sys:role:delete', 2, '', 20);
-INSERT INTO `sys_menu` VALUES (1204, 'role_save', 'role_save', 'buttons.role.save', 12, 'sys:role:save,sys:role:update', 2, '', 25);
-INSERT INTO `sys_menu` VALUES (1205, 'role_view', 'role_view', 'buttons.role.view', 12, 'sys:role:list,sys:role:menu', 2, '', 5);
-INSERT INTO `sys_menu` VALUES (1301, 'prom_toAdd', 'prom_toAdd', 'buttons.prom.toAdd', 13, NULL, 2, '', 10);
-INSERT INTO `sys_menu` VALUES (1302, 'prom_toEdit', 'prom_toEdit', 'buttons.prom.toEdit', 13, NULL, 2, '', 15);
-INSERT INTO `sys_menu` VALUES (1303, 'prom_delete', 'prom_delete', 'buttons.prom.delete', 13, 'promserver:delete', 2, '', 20);
-INSERT INTO `sys_menu` VALUES (1304, 'prom_save', 'prom_save', 'buttons.prom.save', 13, 'promserver:save,promserver:update', 2, '', 25);
-INSERT INTO `sys_menu` VALUES (1305, 'prom_view', 'prom_view', 'buttons.prom.view', 13, 'idc:list,promserver:list', 2, '', 5);
-INSERT INTO `sys_menu` VALUES (1401, 'dc_toAdd', 'dc_toAdd', 'buttons.dc.toAdd', 14, NULL, 2, '', 7);
-INSERT INTO `sys_menu` VALUES (1402, 'dc_toEdit', 'dc_toEdit', 'buttons.dc.toEdit', 14, NULL, 2, '', 10);
-INSERT INTO `sys_menu` VALUES (1403, 'dc_delete', 'dc_delete', 'buttons.dc.delete', 14, 'idc:delete', 2, '', 15);
-INSERT INTO `sys_menu` VALUES (1404, 'dc_save', 'dc_save', 'buttons.dc.save', 14, 'idc:save,idc:update', 2, '', 20);
-INSERT INTO `sys_menu` VALUES (1405, 'dc_trafficSetting', 'dc_trafficSetting', 'buttons.dc.trafficSetting', 14, 'asset:list,idc:taffic:list,sys:mib:browser', 2, '', 25);
-INSERT INTO `sys_menu` VALUES (1406, 'dc_trafficSetting_save', 'dc_trafficSetting_save', 'buttons.dc.trafficSettingSave', 14, 'idc:taffic:update', 2, '', 30);
-INSERT INTO `sys_menu` VALUES (1407, 'dc_cabinet_toAdd', 'dc_cabinet_toAdd', 'buttons.dc.cabinet.toAdd', 14, NULL, 2, '', 45);
-INSERT INTO `sys_menu` VALUES (1408, 'dc_cabinet_toEdit', 'dc_cabinet_toEdit', 'buttons.dc.cabinet.toEdit', 14, NULL, 2, '', 50);
-INSERT INTO `sys_menu` VALUES (1409, 'dc_cabinet_delete', 'dc_cabinet_delete', 'buttons.dc.cabinet.delete', 14, 'cabinet:delete', 2, '', 55);
-INSERT INTO `sys_menu` VALUES (1410, 'dc_cabinet_save', 'dc_cabinet_save', 'buttons.dc.cabinet.save', 14, 'cabinet:save,cabinet:update', 2, '', 60);
-INSERT INTO `sys_menu` VALUES (1411, 'dc_view', 'dc_view', 'buttons.dc.view', 14, 'idc:list,sys:user:list,cabinet:list', 2, '', 5);
-INSERT INTO `sys_menu` VALUES (1412, 'dc_cabinet_view', 'dc_cabinet_view', 'buttons.dc.cabinet.view', 14, 'cabinet:list', 2, '', 40);
-INSERT INTO `sys_menu` VALUES (1501, 'model_toAdd', 'model_toAdd', 'buttons.model.toAdd', 15, 'sys:dict:all', 2, '', 10);
-INSERT INTO `sys_menu` VALUES (1502, 'model_toEdit', 'model_toEdit', 'buttons.model.toEdit', 15, 'sys:dict:all', 2, '', 15);
-INSERT INTO `sys_menu` VALUES (1503, 'model_delete', 'model_delete', 'buttons.model.delete', 15, 'model:delete', 2, '', 20);
-INSERT INTO `sys_menu` VALUES (1504, 'model_save', 'model_save', 'buttons.model.save', 15, 'model:save,model:update,sys:dict:save', 2, '', 25);
-INSERT INTO `sys_menu` VALUES (1505, 'model_chart_view', 'model_chart_view', 'buttons.model.chart.view', 15, 'panel:list,chart:list,module:list', 2, '', 30);
-INSERT INTO `sys_menu` VALUES (1506, 'model_chart_toAdd', 'model_chart_toAdd', 'buttons.model.chart.toAdd', 15, 'module:list', 2, '', 35);
-INSERT INTO `sys_menu` VALUES (1507, 'model_chart_import', 'model_chart_import', 'buttons.model.chart.import', 15, 'chart:import,chart:import:template,chart:cancel:import', 2, '', 40);
-INSERT INTO `sys_menu` VALUES (1508, 'model_chart_export', 'model_chart_export', 'buttons.model.chart.export', 15, 'chart:export', 2, '', 45);
-INSERT INTO `sys_menu` VALUES (1509, 'model_chart_toEdit', 'model_chart_toEdit', 'buttons.model.chart.toEdit', 15, 'module:list', 2, '', 50);
-INSERT INTO `sys_menu` VALUES (1510, 'model_chart_save', 'model_chart_save', 'buttons.model.chart.save', 15, 'chart:save,chart:update', 2, '', 55);
-INSERT INTO `sys_menu` VALUES (1511, 'model_chart_delete', 'model_chart_delete', 'buttons.model.chart.delete', 15, 'chart:delete', 2, '', 60);
-INSERT INTO `sys_menu` VALUES (1512, 'model_chart_duplicate', 'model_chart_duplicate', 'buttons.model.chart.duplicate', 15, 'chart:duplicate', 2, '', 65);
-INSERT INTO `sys_menu` VALUES (1513, 'model_chart_sync', 'model_chart_sync', 'buttons.model.chart.sync', 15, 'model:sync:chart', 2, '', 70);
-INSERT INTO `sys_menu` VALUES (1514, 'model_view', 'model_view', 'buttons.model.view', 15, 'model:list', 2, '', 5);
-INSERT INTO `sys_menu` VALUES (1601, 'snmp_file_download', 'snmp_file_download', 'buttons.snmp.download', 16, 'sys:mib:download', 2, '', 10);
-INSERT INTO `sys_menu` VALUES (1602, 'snmp_file_toAdd', 'snmp_file_toAdd', 'buttons.snmp.toAdd', 16, 'model:list', 2, '', 15);
-INSERT INTO `sys_menu` VALUES (1603, 'snmp_file_toEdit', 'snmp_file_toEdit', 'buttons.snmp.toEdit', 16, 'model:list', 2, '', 20);
-INSERT INTO `sys_menu` VALUES (1604, 'snmp_file_delete', 'snmp_file_delete', 'buttons.snmp.delete', 16, 'sys:mib:delete', 2, '', 25);
-INSERT INTO `sys_menu` VALUES (1605, 'snmp_file_save', 'snmp_file_save', 'buttons.snmp.save', 16, 'sys:mib:update,sys:mib:save', 2, '', 30);
-INSERT INTO `sys_menu` VALUES (1606, 'snmp_browser_export', 'snmp_browser_export', 'buttons.snmp.browserExport', 16, 'sys:mib:tree,model:list,asset:list,sys:mib:browser', 2, '', 40);
-INSERT INTO `sys_menu` VALUES (1607, 'snmp_file_view', 'snmp_file_view', 'buttons.snmp.view', 16, 'sys:mib:list', 2, '', 5);
-INSERT INTO `sys_menu` VALUES (1608, 'snmp_browser_view', 'snmp_browser_view', 'buttons.snmp.browserView', 16, 'sys:mib:tree,model:list,asset:list', 2, '', 35);
-INSERT INTO `sys_menu` VALUES (1701, 'system_basic_save', 'system_basic_save', 'buttons.system.basic', 17, 'sys:config:update', 2, '', 0);
-INSERT INTO `sys_menu` VALUES (1702, 'system_email_save', 'system_email_save', 'buttons.system.email', 17, 'sys:config:update', 2, '', 0);
-INSERT INTO `sys_menu` VALUES (1703, 'system_terminal_save', 'system_terminal_save', 'buttons.system.terminal', 17, 'sys:config:update', 2, '', 0);
-INSERT INTO `sys_menu` VALUES (1704, 'system_ldap_save', 'system_ldap_save', 'buttons.system.ldap', 17, 'sys:config:update', 2, '', 0);
-INSERT INTO `sys_menu` VALUES (1705, 'system_notification_add', 'system_notification_add', 'buttons.system.notification.add', 17, 'alert:script:save', 2, '', 0);
-INSERT INTO `sys_menu` VALUES (1706, 'system_notification_toEdit', 'system_notification_toEdit', 'buttons.system.notification.toEdit', 17, NULL, 2, '', 0);
-INSERT INTO `sys_menu` VALUES (1707, 'system_notification_save', 'system_notification_save', 'buttons.system.notification.save', 17, 'alert:script:save,alert:script:update', 2, '', 0);
-INSERT INTO `sys_menu` VALUES (1708, 'system_notification_delete', 'system_notification_delete', 'buttons.system.notification.delete', 17, 'alert:script:delete', 2, '', 0);
-INSERT INTO `sys_menu` VALUES (1709, 'system_link_add', 'system_link_add', 'buttons.system.link.add', 17, 'sys:link:save', 2, '', 0);
-INSERT INTO `sys_menu` VALUES (1710, 'system_link_toEdit', 'system_link_toEdit', 'buttons.system.link.toEdit', 17, NULL, 2, '', 0);
-INSERT INTO `sys_menu` VALUES (1711, 'system_link_save', 'system_link_save', 'buttons.system.link.save', 17, 'sys:link:save,sys:link:update', 2, '', 0);
-INSERT INTO `sys_menu` VALUES (1712, 'system_link_delete', 'system_link_delete', 'buttons.system.link.delete', 17, 'sys:link:delete', 2, '', 0);
-INSERT INTO `sys_menu` VALUES (1713, 'system_reset_reset', 'system_reset_reset', 'buttons.system.reset', 17, 'sys:config:reset', 2, '', 0);
-INSERT INTO `sys_menu` VALUES (2101, 'header_link', 'header_link', 'buttons.header.link', 21, 'sys:link:list', 2, '', 0);
-INSERT INTO `sys_menu` VALUES (2102, 'header_terminal', 'header_terminal', 'buttons.header.terminal', 21, NULL, 2, '', 0);
-INSERT INTO `sys_menu` VALUES (2103, 'header_terminal_upload', 'header_terminal_upload', 'buttons.header.terminalUpload', 21, 'terminal:upload', 2, '', 0);
-INSERT INTO `sys_menu` VALUES (2104, 'header_terminal_download', 'header_terminal_download', 'buttons.header.terminalDownload', 21, 'terminal:download', 2, '', 0);
-INSERT INTO `sys_menu` VALUES (2105, 'header_add', 'header_add', 'buttons.header.add.view', 21, NULL, 2, '', 0);
-INSERT INTO `sys_menu` VALUES (2106, 'header_add_project', 'header_add_project', 'buttons.header.add.project', 21, NULL, 2, '', 0);
-INSERT INTO `sys_menu` VALUES (2107, 'header_add_module', 'header_add_module', 'buttons.header.add.module', 21, 'project:list,sys:mib:tree', 2, '', 0);
-INSERT INTO `sys_menu` VALUES (2108, 'header_add_endpoint', 'header_add_endpoint', 'buttons.header.add.endpoint', 21, 'module:list,asset:list,idc:list,model:list,sys:dict:all,project:list,module:list', 2, '', 0);
-INSERT INTO `sys_menu` VALUES (2109, 'header_add_rule', 'header_add_rule', 'buttons.header.add.rule', 21, 'sys:user:list', 2, '', 0);
-INSERT INTO `sys_menu` VALUES (2110, 'header_add_asset', 'header_add_asset', 'buttons.header.add.asset', 21, 'sys:user:list,sys:dict:all,idc:list,asset:tag:key,model:list', 2, '', 0);
-\ No newline at end of file
diff --git a/nz-admin/db/2020-12-18.sql b/nz-admin/db/2020-12-18.sql
deleted file mode 100644
index b935d64f..00000000
--- a/nz-admin/db/2020-12-18.sql
+++ /dev/null
@@ -1,10 +0,0 @@
-/**
- * 系统内置 project 更名为 Common
- */
-update project set name = 'Common' where id = 1;
-
-/**
- *  ldap template 查询超时时间
- */
-DELETE from sys_config where param_key = "ldap_query_timeout";
-INSERT INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (NULL, 'ldap_query_timeout', '3000', 1, 'ldap template 查询超时时间，单位 milliseconds 毫秒');
-\ No newline at end of file
diff --git a/nz-admin/db/2020-12-25.sql b/nz-admin/db/2020-12-25.sql
deleted file mode 100644
index 7ca63032..00000000
--- a/nz-admin/db/2020-12-25.sql
+++ /dev/null
@@ -1,5 +0,0 @@
-/**
- * 系统初始角色 admin/common remark备注信息变更为英文
- */
-update sys_role set remark = 'The system built-in administrator role' where name = 'admin';
-update sys_role set remark = 'The system build-in common user role' where name = 'common';
-\ No newline at end of file
diff --git a/nz-admin/db/2021-01-12.sql b/nz-admin/db/2021-01-12.sql
deleted file mode 100644
index cc4eca88..00000000
--- a/nz-admin/db/2021-01-12.sql
+++ /dev/null
@@ -1,11 +0,0 @@
-/**
- *  1.dashboard panel 导入模板表头批注信息更新
- *  2. panel 表 新增 pid、weight 列
- */
-
-DELETE from `sys_config` where param_key = "chart_export_header";
-INSERT INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (NULL, 'chart_export_header', '{\"cn\":{\"*面板\":\"面板名称(必填) \\n示例: 系统面板/主面板  （使用 / 作为字符分隔，表示 父子节点关系）\",\"*图表名称\":\"图表名称(必填) \\n示例: CPU使用率\",\"*图表类型\":\"图表类型(必填) 可选: 曲线图,柱状图,表格,堆叠区域图,SingleStat,URL,告警列表,文本 \\n示例: 曲线图\",\"*宽度\":\"宽度(必填) 可选：1-12 \\n示例: 10\",\"*高度\":\"高度(必填),默认单位（px/像素） \\n示例:400\",\"单位\":\"单位(必填) 可选: \\nMisc: none,short,percent(0-100),percent(0.0-1.0),local format\\nData: bits,bytes,kilobytes,megabytes,gigabytes,terabytes,petabytes\\nDataRate: packets/sec,bits/sec,bytes/sec,kilobytes/sec,kilobits/sec,megabytes/sec,megabits/sec,gigabytes/sec,gigabits/sec,terabytes/sec,terabits/sec,petabytes/sec,petabits/sec\\nTime: Hertz(1/s),nanoseconds(ns),microseconds(us),milliseconds(ms),seconds(s),minutes(m),hours(h),days(d),YYYY-MM-DD HH:mm:ss,MM/DD/YYYY h:mm:ss a \\n示例: short\",\"*参数\":\"单位 根据type不同，内容不同，格式为JSON格式 \\n示例: {\\\"statistics\\\":\\\"average\\\"}\",\"元素\":\"当type=line，bar，stackArea时，包含 elements key，值为对象数组。\\n 示例:[{\\\"expression\\\":\\\"sum(up)\\\",\\\"legend\\\":\\\"test\\\"}]\"},\"en\":{\"*Panel Name\":\"Panel(Required) \\nExample: System panel/Main panel (use / as a character separation to indicate the relationship between parent and child nodes)\",\"*Chart Title\":\"Chart title(Required) \\nExample: CPU usage\",\"*Chart Type\":\"Chart type(Required) Optional: Line Chart,Histogram,Table,Stack Area,SingleStat,URL,Alert list,Text \\nExample: Line Chart\",\"*Width\":\"width(Required) Optional：1-12 \\nExample: 10\",\"*Height\":\"height(Required),Default unit（px/Pixel） \\nExample:400\",\"Unit\":\"unit(Required) Optional: \\nMisc: none,short,percent(0-100),percent(0.0-1.0),local format\\nData: bits,bytes,kilobytes,megabytes,gigabytes,terabytes,petabytes\\nDataRate: packets/sec,bits/sec,bytes/sec,kilobytes/sec,kilobits/sec,megabytes/sec,megabits/sec,gigabytes/sec,gigabits/sec,terabytes/sec,terabits/sec,petabytes/sec,petabits/sec\\nTime: Hertz(1/s),nanoseconds(ns),microseconds(us),milliseconds(ms),seconds(s),minutes(m),hours(h),days(d),YYYY-MM-DD HH:mm:ss,MM/DD/YYYY h:mm:ss a \\nExample: short\",\"*Parameter\":\"Parameters match type，The format is JSON format \\nExample: {\\\"statistics\\\":\\\"average\\\"}\",\"Elements\":\"When the type is line, table, stackArea, singleStat, histogram, it contains elements key and the value is an object array.\\nExample:[{\\\"expression\\\":\\\"sum(up)\\\",\\\"legend\\\":\\\"test\\\"}]\"}}', 1, NULL);
-
-
-ALTER TABLE panel ADD COLUMN pid int(10) NOT NULL DEFAULT 0 COMMENT '父id';
-ALTER TABLE panel ADD COLUMN weight int(10) NOT NULL DEFAULT 0 COMMENT '排序';
-\ No newline at end of file
diff --git a/nz-admin/db/2021-01-13.sql b/nz-admin/db/2021-01-13.sql
deleted file mode 100644
index 439cea3e..00000000
--- a/nz-admin/db/2021-01-13.sql
+++ /dev/null
@@ -1,5 +0,0 @@
-/**
- *  1.alert rule 导入模板表头批注信息更新, Description 取消必填
- */
-DELETE from `sys_config` where param_key = "rule_export_header";
-INSERT INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (NULL, 'rule_export_header', '{\"cn\":{\"*告警规则名称\":\"告警规则名称(必填) \\n示例: cpuAlert\",\"*运算表达式\":\"运算表达式(必填) \\n示例: 100-(avg(irate(node_cpu_seconds_total{mode=\'idle\'}[5m])) by(instance)* 100)\",\"*比较符号\":\"比较符号(必填) 可选: >,<,<=,>=,==,!= \\n示例: >\",\"*阈值\":\"阈值(必填) \\n示例: 10\",\"*单位\":\"单位(必填) 可选: \\nMisc: none,short,percent(0-100),percent(0.0-1.0),local format\\nData: bits,bytes,kilobytes,megabytes,gigabytes,terabytes,petabytes\\nDataRate: packets/sec,bits/sec,bytes/sec,kilobytes/sec,kilobits/sec,megabytes/sec,megabits/sec,gigabytes/sec,gigabits/sec,terabytes/sec,terabits/sec,petabytes/sec,petabits/sec\\nTime: Hertz(1/s),nanoseconds(ns),microseconds(us),milliseconds(ms),seconds(s),minutes(m),hours(h),days(d),YYYY-MM-DD HH:mm:ss,MM/DD/YYYY h:mm:ss a \\n示例: short\",\"*持续时间\":\"持续时间(必填),默认单位（秒） \\n示例:60\",\"*告警级别\":\"告警级别(必填) 可选 P1、P2、P3 \\n示例: P1\",\"*告警摘要\":\"告警摘要(必填) \\n示例: cpu告警\",\"告警详细描述\":\"告警详细描述 \\n示例: cpu使用率超过10%的告警规则\",\"告警通知人\":\"告警通知人，多个使用逗号分隔 \\n示例: admin / admin,root\"},\"en\":{\"*AlertName\":\"Alert rule name (required) \\nExample: cpuAlert\",\"*Expr\":\"Operation expression (required) \\nExample: 100-(avg(irate(node_cpu_seconds_total{mode=\'idle\')[5m])) by(instance)* 100)\",\"*Operator\":\"Operation symbol (required) Optional: >,<,<=,>=,==,!= \\nExample:>\",\"*Threshold\":\"Threshold (required) \\nExample: 10\",\"*Unit\":\"Unit (required) Optional: \\nMisc: none,short,percent(0-100),percent(0.0-1.0),local format\\nData: bits,bytes,kilobytes,megabytes,gigabytes,terabytes,petabytes\\nDataRate: packets/sec,bits/sec,bytes/sec,kilobytes/sec,kilobits/sec,megabytes/sec,megabits/sec,gigabytes/sec,gigabits/sec,terabytes/sec,terabits/sec,petabytes/sec,petabits/sec\\nTime: Hertz(1/s),nanoseconds(ns),microseconds(us),milliseconds(ms),seconds(s),minutes(m),hours(h),days(d),YYYY-MM-DD HH:mm:ss,MM/DD/YYYY h:mm:ss a \\nExample:short\",\"*Last\":\"Last (required), the default unit (seconds) \\nExample: 60\",\"*Severity\":\"Alert severity (required) optional P1, P2, P3 \\nExample: P1\",\"*Summary\":\"Alert summary \\nExample: Cpu warning\",\"Description\":\"Alert description \\nExample: Alarm rule for cpu usage exceeding 10%\",\"Receiver\":\"Alert receiver, separated by commas \\nExample: admin / admin,root\"}}', 1, NULL);
-\ No newline at end of file
diff --git a/nz-admin/db/init.sql b/nz-admin/db/init.sql
deleted file mode 100644
index 2d5db6c1..00000000
--- a/nz-admin/db/init.sql
+++ /dev/null
@@ -1,1112 +0,0 @@
--- 初始化sql文件
--- 每次提交代码涉及数据库变更的，都需要在db 目录下新建 sql 文件保存变更的 sql 语句。
--- sql文件命名格式：yyyy-mm-dd.sql，例 2020-01-01.sql，文件头部注释说明变更缘由或变更内容
-
-
-/*
- Navicat Premium Data Transfer
-
- Source Server         : 192.168.40.126
- Source Server Type    : MySQL
- Source Server Version : 100223
- Source Host           : 192.168.40.126:3306
- Source Schema         : nezha
-
- Target Server Type    : MySQL
- Target Server Version : 100223
- File Encoding         : 65001
-
- Date: 22/04/2020 14:22:23
-*/
-
-SET NAMES utf8mb4;
-SET FOREIGN_KEY_CHECKS = 0;
-
--- ----------------------------
--- Table structure for account
--- ----------------------------
-DROP TABLE IF EXISTS `account`;
-CREATE TABLE `account`  (
-  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
-  `asset_id` int(10) NOT NULL COMMENT '资产id',
-  `protocol` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '协议，可选值：SSH，TELNET。统一大写',
-  `auth_type` int(10) NOT NULL COMMENT '认证类型，1：密码，2：私钥证书，ssh可选1、2，telnet可选1',
-  `user` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名',
-  `pwd` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
-  `private_key` varchar(4096) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '私钥',
-  `port` int(10) NULL DEFAULT NULL COMMENT '端口，ssh默认：22,telnet默认：23',
-  `user_tip` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名提示，telnet协议有效，用于自动登录，默认值：login',
-  `password_tip` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码提示，telnet协议有效，用于自动登录，默认值：password',
-  `relogin_password_tip` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '重新登陆提示，telnet协议有效，用于relogin自动登录\r\n\r\n默认值：password',
-  `seq` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '全局唯一，用于导入撤销',
-  PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 57 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-
--- ----------------------------
--- Table structure for alert_message
--- ----------------------------
-DROP TABLE IF EXISTS `alert_message`;
-CREATE TABLE `alert_message`  (
-  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
-  `severity` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '告警级别',
-  `summary` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '告警摘要',
-  `description` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '告警描述',
-  `labels` varchar(2048) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '告警labels信息',
-  `start_at` datetime(0) NULL DEFAULT NULL COMMENT '开始时间',
-  `end_at` datetime(0) NULL DEFAULT NULL COMMENT '结束时间',
-  `state` int(10) NULL DEFAULT NULL COMMENT '状态1:pending,2:Expired',
-  `rule_id` int(10) NOT NULL COMMENT '告警规则ID',
-  `project_id` int(10) NULL DEFAULT NULL COMMENT '关联project id',
-  `module_id` int(10) NULL DEFAULT NULL COMMENT '关联module id',
-  `endpoint_id` int(10) NULL DEFAULT NULL COMMENT '关联endpoint id',
-  `asset_id` int(10) NULL DEFAULT NULL COMMENT '关联资产id',
-  `dc_id` int(10) NULL DEFAULT NULL COMMENT '关联idc id',
-  `hash_key` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'redis hash key',
-  `remark` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注 记录手动关闭记录信息，格式\r\n\r\ntime     username\r\n\r\nmessage',
-  PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 1599 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-
--- ----------------------------
--- Table structure for alert_rule
--- ----------------------------
-DROP TABLE IF EXISTS `alert_rule`;
-CREATE TABLE `alert_rule`  (
-  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键id',
-  `alert_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '告警名称',
-  `expr` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '运算表达式',
-  `last` int(11) NOT NULL COMMENT '持续时间,单位s',
-  `severity` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '告警级别',
-  `summary` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '告警摘要',
-  `description` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '告警详细描述',
-  `receiver` int(11) NULL DEFAULT NULL COMMENT '通知用户组',
-  `build_in` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '1：内置，0：非内置，默认：0\r\n\r\n内置规则不允许编辑删除，系统内置一条 snmptrap 规则',
-  PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 35 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-
--- ----------------------------
--- Table structure for asset
--- ----------------------------
-DROP TABLE IF EXISTS `asset`;
-CREATE TABLE `asset`  (
-  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
-  `sn` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '资产序列化，唯一标识',
-  `model_id` int(10) NOT NULL COMMENT '产品型号',
-  `idc_id` int(10) NOT NULL COMMENT '数据中心id',
-  `cabinet_id` int(10) NULL DEFAULT NULL COMMENT '机柜编号',
-  `cabinet_start` int(10) NULL DEFAULT NULL COMMENT '需要验证开始结束u位内没有已占用u位，且不小于 model.u_size ',
-  `cabinet_end` int(10) NULL DEFAULT NULL,
-  `host` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主机地址',
-  `ipmi` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'ipmi配置信息',
-  `state` int(10) NOT NULL COMMENT '资产状态',
-  `purchase_date` date NULL DEFAULT NULL COMMENT '购买日期',
-  `create_at` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
-  `update_at` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
-  `create_by` int(10) NULL DEFAULT NULL COMMENT '添加人',
-  `update_by` int(10) NULL DEFAULT NULL COMMENT '最后更新人',
-  `seq` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '全局唯一，用于导入撤销',
-  PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 151 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-
--- ----------------------------
--- Table structure for asset_ping
--- ----------------------------
-DROP TABLE IF EXISTS `asset_ping`;
-CREATE TABLE `asset_ping`  (
-  `host` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ip地址',
-  `status` int(1) NOT NULL COMMENT '是否可达 可达为1 不可达为0',
-  `rtt` double(7, 2) NULL DEFAULT NULL COMMENT '传输的时间延迟Round-Trip Time ，单位：ms',
-  `last_update` datetime(0) NULL DEFAULT NULL COMMENT '最后更新时间'
-) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-
--- ----------------------------
--- Table structure for cabinet
--- ----------------------------
-DROP TABLE IF EXISTS `cabinet`;
-CREATE TABLE `cabinet`  (
-  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
-  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '机柜名称',
-  `idc_id` int(10) NOT NULL COMMENT '数据中心id',
-  `u_size` int(10) NULL DEFAULT NULL COMMENT 'u位容量',
-  `remark` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
-  `seq` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '全局唯一，用于导入撤销',
-  `x` int(10) NULL DEFAULT NULL COMMENT '在机房的那一列',
-  `y` int(10) NULL DEFAULT NULL COMMENT '在机房的那一行',
-  PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 48 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-
--- ----------------------------
--- Table structure for chart
--- ----------------------------
-DROP TABLE IF EXISTS `chart`;
-CREATE TABLE `chart`  (
-  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
-  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
-  `span` int(10) NOT NULL DEFAULT 12,
-  `height` int(10) NOT NULL DEFAULT 100,
-  `create_at` datetime(0) NOT NULL,
-  `type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'line,bar,table',
-  `panel_id` int(10) UNSIGNED NOT NULL,
-  `unit` int(10) NOT NULL DEFAULT 2 COMMENT '单位',
-  `prev` int(10) NOT NULL COMMENT '记录前一个chart.id\r\n\r\n如果前面没有内容了，记录为 0',
-  `next` int(10) NOT NULL COMMENT '记录后一个chart.id\r\n\r\n如果后面没有内容了，记录为 -1',
-  `param` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '用于记录不同type类型对应的param',
-  PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 554 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-
--- ----------------------------
--- Table structure for chart_element
--- ----------------------------
-DROP TABLE IF EXISTS `chart_element`;
-CREATE TABLE `chart_element`  (
-  `id` int(10) NOT NULL AUTO_INCREMENT,
-  `expression` varchar(4096) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'nomal: up{asset=\"192.168.40.40\",module=\"kafka\"}',
-  `type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'normal,expert',
-  `chart_id` int(10) UNSIGNED NOT NULL,
-  `legend` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
-  PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 1305 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-
--- ----------------------------
--- Table structure for conf_event
--- ----------------------------
-DROP TABLE IF EXISTS `conf_event`;
-CREATE TABLE `conf_event`  (
-  `table` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
-  `value` bigint(20) NULL DEFAULT 0,
-  PRIMARY KEY (`table`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-
--- ----------------------------
--- Records of conf_event
--- ----------------------------
-INSERT INTO `conf_event` VALUES ('asset', 0);
-INSERT INTO `conf_event` VALUES ('endpoint', 69);
-INSERT INTO `conf_event` VALUES ('idc', 5);
-INSERT INTO `conf_event` VALUES ('module', 16);
-INSERT INTO `conf_event` VALUES ('rule', 0);
-INSERT INTO `conf_event` VALUES ('scrape_interval', 0);
-INSERT INTO `conf_event` VALUES ('server', 3);
-INSERT INTO `conf_event` VALUES ('storage_local_retention', 0);
-
--- ----------------------------
--- Table structure for endpoint
--- ----------------------------
-DROP TABLE IF EXISTS `endpoint`;
-CREATE TABLE `endpoint`  (
-  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
-  `module_id` int(10) NOT NULL COMMENT '组件id',
-  `asset_id` int(10) NOT NULL COMMENT '资产id',
-  `host` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'exporter地址',
-  `port` int(10) NULL DEFAULT NULL COMMENT 'export端口',
-  `param` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'exporter参数,json格式,示例：{\"keys\":\"values\"}',
-  `path` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请求路径，默认 /metric',
-  `seq` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '导入唯一标识 用于导入撤销',
-  PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 338 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-
--- ----------------------------
--- Table structure for idc
--- ----------------------------
-DROP TABLE IF EXISTS `idc`;
-CREATE TABLE `idc`  (
-  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键自增',
-  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称',
-  `location` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '位置',
-  `tel` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系电话',
-  `principal` int(10) NULL DEFAULT NULL COMMENT '机房负责人',
-  `seq` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '全局唯一，用于导入撤销',
-  `area_id` int(10) NULL DEFAULT NULL COMMENT '关联sys_area',
-  `x` int(10) NULL DEFAULT NULL COMMENT '列',
-  `y` int(10) NULL DEFAULT NULL COMMENT '行',
-  PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 89 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-
--- ----------------------------
--- Table structure for maintenance_record
--- ----------------------------
-DROP TABLE IF EXISTS `maintenance_record`;
-CREATE TABLE `maintenance_record`  (
-  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
-  `asset_id` int(10) NULL DEFAULT NULL COMMENT '资产id',
-  `content` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '维修内容',
-  `create_at` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
-  `create_by` int(10) NULL DEFAULT NULL COMMENT '添加人',
-  `update_at` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
-  `update_by` int(10) NULL DEFAULT NULL COMMENT '更新人',
-  PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-
--- ----------------------------
--- Table structure for metadata_label
--- ----------------------------
-DROP TABLE IF EXISTS `metadata_label`;
-CREATE TABLE `metadata_label`  (
-  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
-  `metric_id` int(10) NOT NULL COMMENT '指标ID',
-  `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'label名称',
-  `value` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'lable值',
-  PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 271062 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-
--- ----------------------------
--- Table structure for metadata_metric
--- ----------------------------
-DROP TABLE IF EXISTS `metadata_metric`;
-CREATE TABLE `metadata_metric`  (
-  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
-  `metric` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '指标名称',
-  `type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '指标类型 默认：-',
-  `help` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述信息',
-  `unit` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '单位',
-  PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 6089 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-
--- ----------------------------
--- Table structure for model
--- ----------------------------
-DROP TABLE IF EXISTS `model`;
-CREATE TABLE `model`  (
-  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
-  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '型号名称',
-  `vendor` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '厂商',
-  `type` int(10) NULL DEFAULT NULL COMMENT '类型',
-  `remark` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
-  `seq` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '全局唯一，用于导入撤销',
-  `usize` int(10) NULL DEFAULT NULL COMMENT '大于0',
-  PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 78 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-
--- ----------------------------
--- Table structure for module
--- ----------------------------
-DROP TABLE IF EXISTS `module`;
-CREATE TABLE `module`  (
-  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
-  `project_id` int(10) NOT NULL COMMENT '系统id',
-  `type` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'module类型 可选值http，snmp',
-  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '组件名称',
-  `port` int(10) NOT NULL COMMENT 'export默认端口 type=snmp时，默认 161',
-  `param` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'exporter默认参数',
-  `path` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '默认请求路径，默认 /metric',
-  `remark` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
-  `build_in` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '1:内置，0：非内置，默认：0',
-  `seq` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '导入唯一标识 用于导入撤销',
-  `snmp_param` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT 'snmp配置参数,保存格式为json',
-  `snmp_yml` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT 'snmp_exporter需要的配置部分,由web端生成保存',
-  PRIMARY KEY (`id`) USING BTREE,
-  UNIQUE INDEX `uk_projectId_name`(`project_id`, `name`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 58 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-
--- ----------------------------
--- Records of module
--- ----------------------------
-INSERT INTO `module` VALUES (1, 2, 'http', 'node_exporter', 9100, '', '/metrics', NULL, '1', NULL, NULL, NULL);
-
--- ----------------------------
--- Table structure for panel
--- ----------------------------
-DROP TABLE IF EXISTS `panel`;
-CREATE TABLE `panel`  (
-  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
-  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
-  `create_by` int(10) NULL DEFAULT NULL,
-  PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 284 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-
--- ----------------------------
--- Table structure for project
--- ----------------------------
-DROP TABLE IF EXISTS `project`;
-CREATE TABLE `project`  (
-  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
-  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '应用名称',
-  `remark` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述信息',
-  `build_in` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '1:内置，0：非内置，默认：0',
-  `seq` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '导入唯一标识 用于导入撤销',
-  PRIMARY KEY (`id`) USING BTREE,
-  UNIQUE INDEX `uk_name`(`name`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 61 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-
--- ----------------------------
--- Records of project
--- ----------------------------
-INSERT INTO `project` VALUES (1, 'system', '系统内置project，展示系统基础信息', '1', NULL);
-INSERT INTO `project` VALUES (2, 'node_exporter', '系统内置project', '1', NULL);
-
--- ----------------------------
--- Table structure for prom_server
--- ----------------------------
-DROP TABLE IF EXISTS `prom_server`;
-CREATE TABLE `prom_server`  (
-  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键id',
-  `idc_id` int(10) NOT NULL COMMENT '所在idc',
-  `host` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '部署ip',
-  `port` int(10) NOT NULL COMMENT '端口 默认9090',
-  `type` int(10) NOT NULL COMMENT '1:global,负责汇聚所有per-datacenter采集的数据及告警配置\r\n\r\n2:per-datacenter，负责根据exporter配置采集监测数据',
-  `status` int(1) NOT NULL COMMENT '默认：0， 1：可用，0：prometheus server 不可用，-1：configagent不可用，-2：都不可用',
-  `check_time` datetime(1) NULL DEFAULT NULL COMMENT '最后操作时间',
-  PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-
--- ----------------------------
--- Table structure for qrtz_blob_triggers
--- ----------------------------
-DROP TABLE IF EXISTS `qrtz_blob_triggers`;
-CREATE TABLE `qrtz_blob_triggers`  (
-  `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
-  `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
-  `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
-  `BLOB_DATA` blob NULL,
-  PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE,
-  INDEX `SCHED_NAME`(`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`) ON DELETE RESTRICT ON UPDATE RESTRICT
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-
--- ----------------------------
--- Table structure for qrtz_calendars
--- ----------------------------
-DROP TABLE IF EXISTS `qrtz_calendars`;
-CREATE TABLE `qrtz_calendars`  (
-  `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
-  `CALENDAR_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
-  `CALENDAR` blob NOT NULL,
-  PRIMARY KEY (`SCHED_NAME`, `CALENDAR_NAME`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-
--- ----------------------------
--- Table structure for qrtz_cron_triggers
--- ----------------------------
-DROP TABLE IF EXISTS `qrtz_cron_triggers`;
-CREATE TABLE `qrtz_cron_triggers`  (
-  `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
-  `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
-  `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
-  `CRON_EXPRESSION` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
-  `TIME_ZONE_ID` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
-  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`) ON DELETE RESTRICT ON UPDATE RESTRICT
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-
--- ----------------------------
--- Table structure for qrtz_fired_triggers
--- ----------------------------
-DROP TABLE IF EXISTS `qrtz_fired_triggers`;
-CREATE TABLE `qrtz_fired_triggers`  (
-  `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
-  `ENTRY_ID` varchar(95) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
-  `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
-  `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
-  `INSTANCE_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
-  `FIRED_TIME` bigint(13) NOT NULL,
-  `SCHED_TIME` bigint(13) NOT NULL,
-  `PRIORITY` int(11) NOT NULL,
-  `STATE` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
-  `JOB_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
-  `JOB_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
-  `IS_NONCONCURRENT` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
-  `REQUESTS_RECOVERY` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
-  PRIMARY KEY (`SCHED_NAME`, `ENTRY_ID`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-
--- ----------------------------
--- Table structure for qrtz_job_details
--- ----------------------------
-DROP TABLE IF EXISTS `qrtz_job_details`;
-CREATE TABLE `qrtz_job_details`  (
-  `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
-  `JOB_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
-  `JOB_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
-  `DESCRIPTION` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
-  `JOB_CLASS_NAME` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
-  `IS_DURABLE` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
-  `IS_NONCONCURRENT` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
-  `IS_UPDATE_DATA` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
-  `REQUESTS_RECOVERY` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
-  `JOB_DATA` blob NULL,
-  PRIMARY KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-
--- ----------------------------
--- Table structure for qrtz_locks
--- ----------------------------
-DROP TABLE IF EXISTS `qrtz_locks`;
-CREATE TABLE `qrtz_locks`  (
-  `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
-  `LOCK_NAME` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
-  PRIMARY KEY (`SCHED_NAME`, `LOCK_NAME`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-
--- ----------------------------
--- Records of qrtz_locks
--- ----------------------------
-INSERT INTO `qrtz_locks` VALUES ('NeZhaScheduler', 'STATE_ACCESS');
-INSERT INTO `qrtz_locks` VALUES ('NeZhaScheduler', 'TRIGGER_ACCESS');
-
--- ----------------------------
--- Table structure for qrtz_paused_trigger_grps
--- ----------------------------
-DROP TABLE IF EXISTS `qrtz_paused_trigger_grps`;
-CREATE TABLE `qrtz_paused_trigger_grps`  (
-  `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
-  `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
-  PRIMARY KEY (`SCHED_NAME`, `TRIGGER_GROUP`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-
--- ----------------------------
--- Table structure for qrtz_scheduler_state
--- ----------------------------
-DROP TABLE IF EXISTS `qrtz_scheduler_state`;
-CREATE TABLE `qrtz_scheduler_state`  (
-  `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
-  `INSTANCE_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
-  `LAST_CHECKIN_TIME` bigint(13) NOT NULL,
-  `CHECKIN_INTERVAL` bigint(13) NOT NULL,
-  PRIMARY KEY (`SCHED_NAME`, `INSTANCE_NAME`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-
--- ----------------------------
--- Records of qrtz_scheduler_state
--- ----------------------------
-INSERT INTO `qrtz_scheduler_state` VALUES ('NeZhaScheduler', 'www.puppet-foreman.com1576734310869', 1576743748484, 15000);
-
--- ----------------------------
--- Table structure for qrtz_simple_triggers
--- ----------------------------
-DROP TABLE IF EXISTS `qrtz_simple_triggers`;
-CREATE TABLE `qrtz_simple_triggers`  (
-  `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
-  `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
-  `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
-  `REPEAT_COUNT` bigint(7) NOT NULL,
-  `REPEAT_INTERVAL` bigint(12) NOT NULL,
-  `TIMES_TRIGGERED` bigint(10) NOT NULL,
-  PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) 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`) ON DELETE RESTRICT ON UPDATE RESTRICT
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-
--- ----------------------------
--- Table structure for qrtz_simprop_triggers
--- ----------------------------
-DROP TABLE IF EXISTS `qrtz_simprop_triggers`;
-CREATE TABLE `qrtz_simprop_triggers`  (
-  `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
-  `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
-  `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
-  `STR_PROP_1` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
-  `STR_PROP_2` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
-  `STR_PROP_3` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
-  `INT_PROP_1` int(11) NULL DEFAULT NULL,
-  `INT_PROP_2` int(11) NULL DEFAULT NULL,
-  `LONG_PROP_1` bigint(20) NULL DEFAULT NULL,
-  `LONG_PROP_2` bigint(20) NULL DEFAULT NULL,
-  `DEC_PROP_1` decimal(13, 4) NULL DEFAULT NULL,
-  `DEC_PROP_2` decimal(13, 4) NULL DEFAULT NULL,
-  `BOOL_PROP_1` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
-  `BOOL_PROP_2` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
-  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`) ON DELETE RESTRICT ON UPDATE RESTRICT
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-
--- ----------------------------
--- Table structure for qrtz_triggers
--- ----------------------------
-DROP TABLE IF EXISTS `qrtz_triggers`;
-CREATE TABLE `qrtz_triggers`  (
-  `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
-  `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
-  `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
-  `JOB_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
-  `JOB_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
-  `DESCRIPTION` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
-  `NEXT_FIRE_TIME` bigint(13) NULL DEFAULT NULL,
-  `PREV_FIRE_TIME` bigint(13) NULL DEFAULT NULL,
-  `PRIORITY` int(11) NULL DEFAULT NULL,
-  `TRIGGER_STATE` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
-  `TRIGGER_TYPE` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
-  `START_TIME` bigint(13) NOT NULL,
-  `END_TIME` bigint(13) NULL DEFAULT NULL,
-  `CALENDAR_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
-  `MISFIRE_INSTR` smallint(2) NULL DEFAULT NULL,
-  `JOB_DATA` blob NULL,
-  PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE,
-  INDEX `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`) ON DELETE RESTRICT ON UPDATE RESTRICT
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-
--- ----------------------------
--- Table structure for snmp_mib
--- ----------------------------
-DROP TABLE IF EXISTS `snmp_mib`;
-CREATE TABLE `snmp_mib`  (
-  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键id',
-  `name` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'mib文件名称，默认去掉后缀',
-  `file_name` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '二进制文件名称',
-  `content` mediumblob NOT NULL COMMENT 'mib二进制文件',
-  `models` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '为空时：所有型号适用\r\n\r\n不为空时：可关联多个型号，用逗号分隔，如：1,2,3',
-  `remark` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '备注',
-  `update_by` int(10) NULL DEFAULT NULL COMMENT '更新人',
-  `update_at` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
-  `tree` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'MIB文件解析tree',
-  PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 77 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-
--- ----------------------------
--- Table structure for sys_area
--- ----------------------------
-DROP TABLE IF EXISTS `sys_area`;
-CREATE TABLE `sys_area`  (
-  `id` int(10) NOT NULL AUTO_INCREMENT,
-  `name` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称',
-  `pid` int(10) NOT NULL DEFAULT 0 COMMENT '父id，没有为 0 ',
-  `pids` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '所有父id',
-  `longitude` double(11, 6) NOT NULL COMMENT '经度',
-  `latitude` double(11, 6) NOT NULL COMMENT '纬度',
-  `i18n` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'i18n内容，json对象保存，key为语言简称，value为对应翻译',
-  PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 98 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-
--- ----------------------------
--- Records of sys_area
--- ----------------------------
-INSERT INTO `sys_area` VALUES (5, 'Almaty', 0, '0', 76.928611, 43.256667, '{\"cn\":\"Almaty\",\"en\":\"Almaty\"}');
-INSERT INTO `sys_area` VALUES (6, 'Shymkent', 0, '0', 69.600000, 42.300000, '{\"cn\":\"Shymkent\",\"en\":\"Shymkent\"}');
-INSERT INTO `sys_area` VALUES (7, 'Qaraghandy', 0, '0', 73.100000, 49.800000, '{\"cn\":\"Qaraghandy\",\"en\":\"Qaraghandy\"}');
-INSERT INTO `sys_area` VALUES (8, 'Taraz', 0, '0', 71.366667, 42.900000, '{\"cn\":\"Taraz\",\"en\":\"Taraz\"}');
-INSERT INTO `sys_area` VALUES (9, 'Astana', 0, '0', 71.450000, 51.166666, '{\"cn\":\"Astana\",\"en\":\"Astana\"}');
-INSERT INTO `sys_area` VALUES (10, 'Pavlodar', 0, '0', 76.966666, 52.283333, '{\"cn\":\"Pavlodar\",\"en\":\"Pavlodar\"}');
-INSERT INTO `sys_area` VALUES (11, 'Öskemen', 0, '0', 82.600000, 49.966666, '{\"cn\":\"Öskemen\",\"en\":\"Öskemen\"}');
-INSERT INTO `sys_area` VALUES (12, 'Semey', 0, '0', 80.266694, 50.426749, '{\"cn\":\"Semey\",\"en\":\"Semey\"}');
-INSERT INTO `sys_area` VALUES (13, 'Qyzylorda', 0, '0', 65.500000, 44.850000, '{\"cn\":\"Qyzylorda\",\"en\":\"Qyzylorda\"}');
-INSERT INTO `sys_area` VALUES (14, 'Aqtöbe', 0, '0', 57.183333, 50.300000, '{\"cn\":\"Aqtöbe\",\"en\":\"Aqtöbe\"}');
-INSERT INTO `sys_area` VALUES (15, 'Qostanay', 0, '0', 63.633333, 53.216666, '{\"cn\":\"Qostanay\",\"en\":\"Qostanay\"}');
-INSERT INTO `sys_area` VALUES (16, 'Petropavl', 0, '0', 69.150000, 54.866666, '{\"cn\":\"Petropavl\",\"en\":\"Petropavl\"}');
-INSERT INTO `sys_area` VALUES (17, 'Oral', 0, '0', 51.366667, 51.233333, '{\"cn\":\"Oral\",\"en\":\"Oral\"}');
-INSERT INTO `sys_area` VALUES (18, 'Atyraū', 0, '0', 51.883333, 47.116667, '{\"cn\":\"Atyraū\",\"en\":\"Atyraū\"}');
-INSERT INTO `sys_area` VALUES (19, 'Temirtaū', 0, '0', 72.964643, 50.054938, '{\"cn\":\"Temirtaū\",\"en\":\"Temirtaū\"}');
-INSERT INTO `sys_area` VALUES (20, 'Kökshetaū', 0, '0', 69.400000, 53.283333, '{\"cn\":\"Kökshetaū\",\"en\":\"Kökshetaū\"}');
-INSERT INTO `sys_area` VALUES (21, 'Ekibastuz', 0, '0', 75.322869, 51.723714, '{\"cn\":\"Ekibastuz\",\"en\":\"Ekibastuz\"}');
-INSERT INTO `sys_area` VALUES (22, 'Rudnyy', 0, '0', 63.116772, 52.972903, '{\"cn\":\"Rudnyy\",\"en\":\"Rudnyy\"}');
-INSERT INTO `sys_area` VALUES (23, 'Zhezqazghan', 0, '0', 67.766667, 47.783333, '{\"cn\":\"Zhezqazghan\",\"en\":\"Zhezqazghan\"}');
-INSERT INTO `sys_area` VALUES (24, 'Türkistan', 0, '0', 68.222892, 43.299228, '{\"cn\":\"Türkistan\",\"en\":\"Türkistan\"}');
-INSERT INTO `sys_area` VALUES (25, 'Taldyqorghan', 0, '0', 78.383333, 45.016666, '{\"cn\":\"Taldyqorghan\",\"en\":\"Taldyqorghan\"}');
-INSERT INTO `sys_area` VALUES (26, 'Balkhash', 0, '0', 74.995000, 46.848056, '{\"cn\":\"Balkhash\",\"en\":\"Balkhash\"}');
-INSERT INTO `sys_area` VALUES (27, 'Sarqan', 0, '0', 79.915449, 45.411259, '{\"cn\":\"Sarqan\",\"en\":\"Sarqan\"}');
-INSERT INTO `sys_area` VALUES (28, 'Kentaū', 0, '0', 68.504631, 43.516721, '{\"cn\":\"Kentaū\",\"en\":\"Kentaū\"}');
-INSERT INTO `sys_area` VALUES (29, 'Ridder', 0, '0', 83.512868, 50.344129, '{\"cn\":\"Ridder\",\"en\":\"Ridder\"}');
-INSERT INTO `sys_area` VALUES (30, 'Arqalyq', 0, '0', 66.920267, 50.249146, '{\"cn\":\"Arqalyq\",\"en\":\"Arqalyq\"}');
-INSERT INTO `sys_area` VALUES (31, 'Zyryanovsk', 0, '0', 84.273182, 49.726540, '{\"cn\":\"Zyryanovsk\",\"en\":\"Zyryanovsk\"}');
-INSERT INTO `sys_area` VALUES (32, 'Zhitiqara', 0, '0', 61.198936, 52.190190, '{\"cn\":\"Zhitiqara\",\"en\":\"Zhitiqara\"}');
-INSERT INTO `sys_area` VALUES (33, 'Ayagöz', 0, '0', 80.434372, 47.964473, '{\"cn\":\"Ayagöz\",\"en\":\"Ayagöz\"}');
-INSERT INTO `sys_area` VALUES (34, 'Arys', 0, '0', 68.808701, 42.430155, '{\"cn\":\"Arys\",\"en\":\"Arys\"}');
-INSERT INTO `sys_area` VALUES (35, 'Shū', 0, '0', 73.759192, 43.603340, '{\"cn\":\"Shū\",\"en\":\"Shū\"}');
-INSERT INTO `sys_area` VALUES (36, 'Qapshaghay', 0, '0', 77.065781, 43.862107, '{\"cn\":\"Qapshaghay\",\"en\":\"Qapshaghay\"}');
-INSERT INTO `sys_area` VALUES (37, 'Qarataū', 0, '0', 70.467681, 43.178687, '{\"cn\":\"Qarataū\",\"en\":\"Qarataū\"}');
-INSERT INTO `sys_area` VALUES (38, 'Qulsary', 0, '0', 54.016667, 46.983333, '{\"cn\":\"Qulsary\",\"en\":\"Qulsary\"}');
-INSERT INTO `sys_area` VALUES (39, 'Zharkent', 0, '0', 80.006549, 44.166600, '{\"cn\":\"Zharkent\",\"en\":\"Zharkent\"}');
-INSERT INTO `sys_area` VALUES (40, 'Atbasar', 0, '0', 68.359963, 51.806522, '{\"cn\":\"Atbasar\",\"en\":\"Atbasar\"}');
-INSERT INTO `sys_area` VALUES (41, 'Esik', 0, '0', 77.440348, 43.358857, '{\"cn\":\"Esik\",\"en\":\"Esik\"}');
-INSERT INTO `sys_area` VALUES (42, 'Aksay', 0, '0', 52.997815, 51.168099, '{\"cn\":\"Aksay\",\"en\":\"Aksay\"}');
-INSERT INTO `sys_area` VALUES (43, 'Aral', 0, '0', 61.666667, 46.800000, '{\"cn\":\"Aral\",\"en\":\"Aral\"}');
-INSERT INTO `sys_area` VALUES (44, 'Beyneu', 0, '0', 55.100000, 45.183333, '{\"cn\":\"Beyneu\",\"en\":\"Beyneu\"}');
-INSERT INTO `sys_area` VALUES (45, 'Balyqshy', 0, '0', 51.866667, 47.066667, '{\"cn\":\"Balyqshy\",\"en\":\"Balyqshy\"}');
-INSERT INTO `sys_area` VALUES (46, 'Shīeli', 0, '0', 66.738872, 44.168817, '{\"cn\":\"Shīeli\",\"en\":\"Shīeli\"}');
-INSERT INTO `sys_area` VALUES (47, 'Alga', 0, '0', 57.330543, 49.900418, '{\"cn\":\"Alga\",\"en\":\"Alga\"}');
-INSERT INTO `sys_area` VALUES (48, 'Oktyabr’sk', 0, '0', 57.419142, 49.469124, '{\"cn\":\"Oktyabr’sk\",\"en\":\"Oktyabr’sk\"}');
-INSERT INTO `sys_area` VALUES (49, 'Shalqar', 0, '0', 59.600000, 47.833333, '{\"cn\":\"Shalqar\",\"en\":\"Shalqar\"}');
-INSERT INTO `sys_area` VALUES (50, 'Shemonaīkha', 0, '0', 81.912128, 50.628114, '{\"cn\":\"Shemonaīkha\",\"en\":\"Shemonaīkha\"}');
-INSERT INTO `sys_area` VALUES (51, 'Ereymentaū', 0, '0', 73.102651, 51.623636, '{\"cn\":\"Ereymentaū\",\"en\":\"Ereymentaū\"}');
-INSERT INTO `sys_area` VALUES (52, 'Khromtaū', 0, '0', 58.440034, 50.251173, '{\"cn\":\"Khromtaū\",\"en\":\"Khromtaū\"}');
-INSERT INTO `sys_area` VALUES (53, 'Lengir', 0, '0', 69.885821, 42.181518, '{\"cn\":\"Lengir\",\"en\":\"Lengir\"}');
-INSERT INTO `sys_area` VALUES (54, 'Makīnsk', 0, '0', 70.419112, 52.632900, '{\"cn\":\"Makīnsk\",\"en\":\"Makīnsk\"}');
-INSERT INTO `sys_area` VALUES (55, 'Oytal', 0, '0', 73.228205, 42.890255, '{\"cn\":\"Oytal\",\"en\":\"Oytal\"}');
-INSERT INTO `sys_area` VALUES (56, 'Qarazhal', 0, '0', 70.857056, 48.040210, '{\"cn\":\"Qarazhal\",\"en\":\"Qarazhal\"}');
-INSERT INTO `sys_area` VALUES (57, 'Boralday', 0, '0', 76.857778, 43.360278, '{\"cn\":\"Boralday\",\"en\":\"Boralday\"}');
-INSERT INTO `sys_area` VALUES (58, 'Üshtöbe', 0, '0', 77.980067, 45.252006, '{\"cn\":\"Üshtöbe\",\"en\":\"Üshtöbe\"}');
-INSERT INTO `sys_area` VALUES (59, 'Zhosaly', 0, '0', 64.078056, 45.487778, '{\"cn\":\"Zhosaly\",\"en\":\"Zhosaly\"}');
-INSERT INTO `sys_area` VALUES (60, 'Atasū', 0, '0', 71.644688, 48.686593, '{\"cn\":\"Atasū\",\"en\":\"Atasū\"}');
-INSERT INTO `sys_area` VALUES (61, 'Emba', 0, '0', 58.150422, 48.829814, '{\"cn\":\"Emba\",\"en\":\"Emba\"}');
-INSERT INTO `sys_area` VALUES (62, 'Zaysan', 0, '0', 84.881108, 47.467831, '{\"cn\":\"Zaysan\",\"en\":\"Zaysan\"}');
-INSERT INTO `sys_area` VALUES (63, 'Derzhavīnsk', 0, '0', 66.315570, 51.099223, '{\"cn\":\"Derzhavīnsk\",\"en\":\"Derzhavīnsk\"}');
-INSERT INTO `sys_area` VALUES (64, 'Uryzhar', 0, '0', 81.629393, 47.093020, '{\"cn\":\"Uryzhar\",\"en\":\"Uryzhar\"}');
-INSERT INTO `sys_area` VALUES (65, 'Maqat', 0, '0', 53.316667, 47.650000, '{\"cn\":\"Maqat\",\"en\":\"Maqat\"}');
-INSERT INTO `sys_area` VALUES (66, 'Esil', 0, '0', 66.408409, 51.954949, '{\"cn\":\"Esil\",\"en\":\"Esil\"}');
-INSERT INTO `sys_area` VALUES (67, 'Taiynsha', 0, '0', 69.759873, 53.846646, '{\"cn\":\"Taiynsha\",\"en\":\"Taiynsha\"}');
-INSERT INTO `sys_area` VALUES (68, 'Qulan', 0, '0', 72.720661, 42.910104, '{\"cn\":\"Qulan\",\"en\":\"Qulan\"}');
-INSERT INTO `sys_area` VALUES (69, 'Otar', 0, '0', 75.216174, 43.538130, '{\"cn\":\"Otar\",\"en\":\"Otar\"}');
-INSERT INTO `sys_area` VALUES (70, 'Būlaevo', 0, '0', 70.441549, 54.905963, '{\"cn\":\"Būlaevo\",\"en\":\"Būlaevo\"}');
-INSERT INTO `sys_area` VALUES (71, 'Aqadyr', 0, '0', 72.858255, 48.260598, '{\"cn\":\"Aqadyr\",\"en\":\"Aqadyr\"}');
-INSERT INTO `sys_area` VALUES (72, 'Ertis', 0, '0', 75.457750, 53.333649, '{\"cn\":\"Ertis\",\"en\":\"Ertis\"}');
-INSERT INTO `sys_area` VALUES (73, 'Shar', 0, '0', 81.048515, 49.585591, '{\"cn\":\"Shar\",\"en\":\"Shar\"}');
-INSERT INTO `sys_area` VALUES (74, 'Makhambet', 0, '0', 51.583333, 47.666667, '{\"cn\":\"Makhambet\",\"en\":\"Makhambet\"}');
-INSERT INTO `sys_area` VALUES (75, 'Zhangaözen', 0, '0', 52.800000, 43.300000, '{\"cn\":\"Zhangaözen\",\"en\":\"Zhangaözen\"}');
-INSERT INTO `sys_area` VALUES (76, 'Aqsū', 0, '0', 71.957606, 52.444223, '{\"cn\":\"Aqsū\",\"en\":\"Aqsū\"}');
-INSERT INTO `sys_area` VALUES (77, 'Zhänibek', 0, '0', 46.847052, 49.422073, '{\"cn\":\"Zhänibek\",\"en\":\"Zhänibek\"}');
-INSERT INTO `sys_area` VALUES (78, 'Qarqaraly', 0, '0', 75.472858, 49.412873, '{\"cn\":\"Qarqaraly\",\"en\":\"Qarqaraly\"}');
-INSERT INTO `sys_area` VALUES (79, 'Qusmuryn', 0, '0', 64.619771, 52.451073, '{\"cn\":\"Qusmuryn\",\"en\":\"Qusmuryn\"}');
-INSERT INTO `sys_area` VALUES (80, 'Bayghanīn', 0, '0', 55.875121, 48.689755, '{\"cn\":\"Bayghanīn\",\"en\":\"Bayghanīn\"}');
-INSERT INTO `sys_area` VALUES (81, 'Osakarovka', 0, '0', 72.570891, 50.562193, '{\"cn\":\"Osakarovka\",\"en\":\"Osakarovka\"}');
-INSERT INTO `sys_area` VALUES (82, 'Bestöbe', 0, '0', 73.095919, 52.497951, '{\"cn\":\"Bestöbe\",\"en\":\"Bestöbe\"}');
-INSERT INTO `sys_area` VALUES (83, 'Tobyl', 0, '0', 62.581014, 52.696575, '{\"cn\":\"Tobyl\",\"en\":\"Tobyl\"}');
-INSERT INTO `sys_area` VALUES (84, 'Zholymbet', 0, '0', 71.712454, 51.742113, '{\"cn\":\"Zholymbet\",\"en\":\"Zholymbet\"}');
-INSERT INTO `sys_area` VALUES (85, 'Kishkeneköl', 0, '0', 72.340793, 53.635894, '{\"cn\":\"Kishkeneköl\",\"en\":\"Kishkeneköl\"}');
-INSERT INTO `sys_area` VALUES (86, 'Qazaly', 0, '0', 62.107500, 45.762778, '{\"cn\":\"Qazaly\",\"en\":\"Qazaly\"}');
-INSERT INTO `sys_area` VALUES (87, 'Chapaev', 0, '0', 51.166667, 50.200000, '{\"cn\":\"Chapaev\",\"en\":\"Chapaev\"}');
-INSERT INTO `sys_area` VALUES (88, 'Torghay', 0, '0', 63.498056, 49.633889, '{\"cn\":\"Torghay\",\"en\":\"Torghay\"}');
-INSERT INTO `sys_area` VALUES (89, 'Fort-Shevchenko', 0, '0', 50.263880, 44.506544, '{\"cn\":\"Fort-Shevchenko\",\"en\":\"Fort-Shevchenko\"}');
-INSERT INTO `sys_area` VALUES (90, 'Aqtaū', 0, '0', 51.166666, 43.650000, '{\"cn\":\"Aqtaū\",\"en\":\"Aqtaū\"}');
-INSERT INTO `sys_area` VALUES (91, 'Saryshagan', 0, '0', 73.619167, 46.119167, '{\"cn\":\"Saryshagan\",\"en\":\"Saryshagan\"}');
-INSERT INTO `sys_area` VALUES (92, 'Shongzhy', 0, '0', 79.465819, 43.538134, '{\"cn\":\"Shongzhy\",\"en\":\"Shongzhy\"}');
-INSERT INTO `sys_area` VALUES (93, 'Serebryansk', 0, '0', 83.295612, 49.684134, '{\"cn\":\"Serebryansk\",\"en\":\"Serebryansk\"}');
-INSERT INTO `sys_area` VALUES (94, 'Zhaltyr', 0, '0', 69.835519, 51.628321, '{\"cn\":\"Zhaltyr\",\"en\":\"Zhaltyr\"}');
-INSERT INTO `sys_area` VALUES (95, 'Sharbaqty', 0, '0', 78.155562, 52.490866, '{\"cn\":\"Sharbaqty\",\"en\":\"Sharbaqty\"}');
-INSERT INTO `sys_area` VALUES (96, 'Būrylbaytal', 0, '0', 74.017766, 44.939840, '{\"cn\":\"Būrylbaytal\",\"en\":\"Būrylbaytal\"}');
-INSERT INTO `sys_area` VALUES (97, 'testCity', 0, '0', 6760.000000, 5586.000000, '{\"cn\":\"测试城市\",\"en\":\"testCity\"}');
-
--- ----------------------------
--- Table structure for sys_config
--- ----------------------------
-DROP TABLE IF EXISTS `sys_config`;
-CREATE TABLE `sys_config`  (
-  `id` bigint(19) NOT NULL AUTO_INCREMENT,
-  `param_key` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'key',
-  `param_value` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT 'value',
-  `status` tinyint(4) NULL DEFAULT 1 COMMENT '状态   0：隐藏   1：显示',
-  `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
-  PRIMARY KEY (`id`) USING BTREE,
-  UNIQUE INDEX `param_key`(`param_key`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 71 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统配置表' ROW_FORMAT = Compact;
-
--- ----------------------------
--- Records of sys_config
--- ----------------------------
-INSERT INTO `sys_config` VALUES (3, 'alert_api', '192.168.40.247:8080', 1, 'test');
-INSERT INTO `sys_config` VALUES (4, 'alert_path_prefix', '/nz-admin', 1, NULL);
-INSERT INTO `sys_config` VALUES (5, 'alert_interval', '60', 1, NULL);
-INSERT INTO `sys_config` VALUES (6, 'init_project_system', '1', 1, '内置 project：system');
-INSERT INTO `sys_config` VALUES (7, 'init_module_node_exporter', '1', 1, '内置 module: node_exporter');
-INSERT INTO `sys_config` VALUES (8, 'node_exporter_target_path', '/opt/nezha/node_exporter', 1, '内置 node_exporter 安装路径');
-INSERT INTO `sys_config` VALUES (9, 'node_exporter_path', 'build_node_exporter', 1, '内置 node_exporter 项目中的路径');
-INSERT INTO `sys_config` VALUES (10, 'node_exporter_name', 'node_exporter.tar.gz', 1, '内置 node_exporter 压缩包名称');
-INSERT INTO `sys_config` VALUES (11, 'node_exporter_shell_name', 'init_exporter.sh', 1, '内置 node_exporter 初始执行脚本名称');
-INSERT INTO `sys_config` VALUES (12, 'asset_ping_switch', 'on', 1, '主机连通性检查开关，on：开启，off：关闭');
-INSERT INTO `sys_config` VALUES (13, 'asset_ping_command', 'fping -f {filename} -e', 1, 'fping命令');
-INSERT INTO `sys_config` VALUES (14, 'confagent_port', '8989', 1, 'confagent内置端口');
-INSERT INTO `sys_config` VALUES (15, 'confagent_path', '/nz-confagent', 1, 'confagent内置路径');
-INSERT INTO `sys_config` VALUES (16, 'confagent_api', '192.168.40.247:8989', 1, 'confagent内置api');
-INSERT INTO `sys_config` VALUES (17, 'telnet_user_tip', 'ogin:', 1, 'telnet用户名提示');
-INSERT INTO `sys_config` VALUES (18, 'telnet_password_tip', 'assword:', 1, 'telnet密码提示');
-INSERT INTO `sys_config` VALUES (19, 'telnet_relogin_password_tip', 'assword:', 1, 'telnet relogin密码提示');
-INSERT INTO `sys_config` VALUES (20, 'max_terminal_num', '30', 1, '一个登陆用户最多允许打开窗口数量');
-INSERT INTO `sys_config` VALUES (21, 'ldap_address', 'ldap://192.168.40.130:389/', 1, NULL);
-INSERT INTO `sys_config` VALUES (22, 'ldap_dn', 'cn=root,dc=bifang,dc=com', 1, NULL);
-INSERT INTO `sys_config` VALUES (23, 'ldap_password', '111111', 1, NULL);
-INSERT INTO `sys_config` VALUES (30, 'ldap_user_filter', 'uid', 1, NULL);
-INSERT INTO `sys_config` VALUES (31, 'ldap_mapping', '{\"email\":\"mail\"}', 1, NULL);
-INSERT INTO `sys_config` VALUES (32, 'ldap_enable', 'on', 1, NULL);
-INSERT INTO `sys_config` VALUES (33, 'geoJson', '{\"type\":\"FeatureCollection\",\"features\":[{\"type\":\"Feature\",\"properties\":{\"name\":\"Akmola Province\"},\"geometry\":{\"type\":\"Polygon\",\"coordinates\":[\"@@ÔdƊĳʪèāƂNŎǀ\\\\ǔ§DȆȨC˔ŷǈƾ»ìƞ¦ƪXÄĢʈĤÉŤļÂRƌÐŁLĉǂâHƚƬјƬËjĜĚɐUűȞW¿ūǖCĠŋŘLOôŘXAĆτEUąȦu˖ĴƖǯiŗĥ¾ąȸùʒCĶȺΜ¦¾ėeǩŸήë¿ͦSà¥@ԣǛƭMŅǸd|ȊÙɱmƛ½ŧƉŗzɥ^čƂJŞ³ƍûȳAÓǃ¹ǋvĽśƿYÛ·äÏċ©ĥąré͕R[ȔťĂˇÇɷƑL¥ǭ}ëígšĽŵ«ÖïȽõƩ]nŀéò̧Éćþ˭Úĥ˵ÍǵÀCɰ¢RȪʏJ̯ƻȓnēſËȏBΣďÇŬüĵɡʓĊįsÙŤĝŇŴštÓġƹosÆ®ƾǧĸļƄÞȌ³²řBĞƪRȚÐĞɦŊÂPȖ\",\"@@ÒõƒkƈĊ¿Ŧǽrĭſ\"],\"encodeOffsets\":[[67591,53693],[72928,52338]]}},{\"type\":\"Feature\",\"properties\":{\"name\":\"Aktobe Province\"},\"geometry\":{\"type\":\"MultiPolygon\",\"coordinates\":[[\"@@Л̉ƸƬŨLŖĴf\"],[\"@@ƖʆǎĀǬQ˄˄zŜı²^żÙÊČÀâŀƾø¥ĎfƤŏpDĔƒXƊğȢdçȦţɶāͤŒêºƺƴĈÄ¦ĨľÿÆøǂ]ɎxưŧƶÉª¼ƪOǮĈʸx¼ŚfÓŜRĬćįƴ«ĎĭҚ¿ĊğʠPƸŞdŬƘŤĝО[՞ŲĴδĺdȊNķưCŶ·đǜĿŹ©SƇƢ¢¾ǁńġĎſƂũÀŏƃeǇ×Ņį§ŏƽȰȳď¯ĒƱʠƙƦäĢÅåė|Û˴ã̖ůȶʃĔƗƂđɗǑƝÅǇĻΫŻɳƛ̱ªrðɯǞĵ^ŗƬųĖӅQyֱ͟έXiǯ́_̡țǩƍϗϑåTćơbŏÍŭɡӵŋ੉ʁřؾŝǦsĞĿŖyŘҥĮʋĆǽŮħǆįŜÆɂCŖ²ǄmƬƇŠ~Ƣ÷Ą¦ǬaŔƍƗgíџļ@ǄȂƅyǝĆ\"]],\"encodeOffsets\":[[[60468,46905]],[[54918,50423]]]}},{\"type\":\"Feature\",\"properties\":{\"name\":\"Almaty\"},\"geometry\":{\"type\":\"Polygon\",\"coordinates\":[\"@@ʴ¤wēČěıĵhűèÏƮ\"],\"encodeOffsets\":[[78580,44354]]}},{\"type\":\"Feature\",\"properties\":{\"name\":\"Almaty Province\"},\"geometry\":{\"type\":\"Polygon\",\"coordinates\":[\"@@ĖŘӠ͜ɴ~ʶŀʄXτƨċŤ¬ĨÁľϾÜûĪXÚÒǼP÷ҐŦ¤ɒŬĦņûƊŞ˶ǃłO¤ïϒ˄ʩϞŖƢI«֚ȭɘOĜßɸÝƶƇÃŦ×ĘȟĮŋJħÖÛĎEɪŃÝKĿęǧÄ̃YĵńƛBƱā˧ȅ÷ǙPɕȉ×»|ɩšŶęŒnªąĀuĈýÁŅ¸ǃWƳňʑȒ̑ÅōĀuFơǏCǕőŜĽȿĩǵ¶ûXƷªħė]ǭǰϵxƃŤƏĄdĚɧ}ʍÌų¸š͏GƿÂ̛\\\\ǁaá¼ʭNţÙƻfƭ½űÐƕiùħ_ƅĈʉä×ȔĆŞˇøă¾ʠǘ_Ķ¤È]ĲƇĪǝòǅ^șņFǶĵĒɧĦǶ˧oİ~ÊɺAĀç̬ĨŦĤ\",\"@@ÐƭŲçĶgĲċĜxĔʳ£\"],\"encodeOffsets\":[[75839,47106],[78580,44354]]}},{\"type\":\"Feature\",\"properties\":{\"name\":\"Astana\"},\"geometry\":{\"type\":\"Polygon\",\"coordinates\":[\"@@ĮƀǾqÀťƇĉƑlÑö\"],\"encodeOffsets\":[[72928,52338]]}},{\"type\":\"Feature\",\"properties\":{\"name\":\"Atyrau\"},\"geometry\":{\"type\":\"Polygon\",\"coordinates\":[\"@@ֺÃݒÇɸ©ЬŋOĔʾUȊvǠŞҦȺʒì´ĮǨTĴΤ£UğłVŌ·ŜhȂéĜDBǀÜƤĐIOȠĴ¬π}̰ȈǞąƆzȁ@ǃѠĻîƘhƎbœ¥ǫøă}ơƈşnƫ±ǃDŕÅɁİśĨǅǾŭʌąҦĭzŗŀŕtĝ́nƑĘÓgãƖǛ\\\\īĊǽŷƱXɍ_ŝϓÕɯEÝĳǯĥЯEǦʎcǄē¨Ŕę¸źǯĺÓʅtď°ǑãȩŭÛĥjoØı¢ȳt÷ū¥ǷYēóƑc«ỚŁįí³ĉčIYŏ±û}ƃǃīí°ƿ¨ċöı\\\\ȋö°ȯn^â̤ªÜ¤çŚǡǸǅˈËAȩɾċ¬ϯ^ȥâſǅâYĀŋŦ¼Ȥ\"],\"encodeOffsets\":[[48242,49392]]}},{\"type\":\"Feature\",\"properties\":{\"name\":\"East Kazakhstan\"},\"geometry\":{\"type\":\"Polygon\",\"coordinates\":[\"@@΢Ĺʜ¿ǘ¨ǦȜŊÙnkȆƅ[Ç²DĒƳąŠįĖŊ¸ːƸæžȰc̚ɒͤѣ̀ϟPúĠÒʐÌȬǀCĢɜµkɐµįǵ̒zȁŐ[ʬ¾˲ÉňǼ{ƞĔKÞƬgʔðǤhȰ·ˆŹ[¯ȎǏüǍaÇƄåȀBȒıƘÛǸȷXġ̼[ĀÁǦbðãŦöµÐĮČV˜ǸÖƙƃȎ»FÙČ¥GÑĊûȴqJıƛǻeřımÁöÿŗřÿ©ñŧ³œBċ«˽CęûŷÑǁöΣyÝÔÙDǯėí_ßɗJ̗ǝǩŶȅÏzѹ˳ðȉĪʫ¨·Ɖǣ̹¡ƣŗ̏±ƫķTťñƭ\\\\ËčFÕÜIĨĭŌėȠťØÄƵƈɷÞěàɗP֙ȮJ¬ơ®ϝŕ˃ʪϑ£ðŁP˵ǄƉŝŅüūĥɑť£ȡ^ûāɉĎĠpŸƸsǔ~ÜǊÔbɂđŎǿŐĴŐǔWŲŢŢæ·ÏĀ\\\\ĔǚŇèEÂʿǌ^¶кŘøú[ǂĴâƾ¾ȎŲYÜ\"],\"encodeOffsets\":[[79562,51428]]}},{\"type\":\"Feature\",\"properties\":{\"name\":\"Jambyl Province\"},\"geometry\":{\"type\":\"Polygon\",\"coordinates\":[\"@@ቒP٢I׸Aੈ@ģħťè̫ ÿɹB}Éį˨pǵɨĥĶđEǵȚŅǆ]Ǟñƈĩ^ı£Ç`ĵʟǗĄ½ˈ÷ąŝØȓʊãƆćęţŭ˵pͅŪďSƣŦũśÜÑɝsͯŵÿ]ƛËǹ®ōƟI¼ǅǫcƓĖȷǻØƉmɍĄȏÅęɇmąƛƭsƷ÷çǗŐâȫźơ¾dǒċŌǩŚʇªďZĒĝhļŀļǨvɜĲŒěвÃȠ»ÊŅ͐ėƆýɬǗȘ\"],\"encodeOffsets\":[[70725,47104]]}},{\"type\":\"Feature\",\"properties\":{\"name\":\"Karagandy Province\"},\"geometry\":{\"type\":\"Polygon\",\"coordinates\":[\"@@ɴƜάżǈļƞÆɘǒƁĒēƘɢƬ±Ĩ̐¦ġƎȖB¢ɚجğɤ¸nĂʠV˸ȾŊzĠƾƼĺǢÎ˨ʒɞƲOĲˬäņŰŹômĔṴ̏ƼʐIQȩ¡DɯǶ¿˶ÎĦˮÙĈý̨ÊêñmĿƪ^ȾöÕðŶ¬ľhŢìîǮ~K¦ɸƒˈÈŦā\\\\ȓ͖QqêĆ®ĦČªãÐÜ¸ǀZľŜǌuǄºBÔȴƎüŝ´ƁI]ĎɦŘy̠Ýdēµũ¬ĝĹÃwīČɀTƀȒ¯˶ǑLçƘÙǡÏŏÝÇƖUˊŤˀbÀŦ}ǂ®ư´þɆtŀµŌˌÂ¤ȚxƪčǔaǐïƽĆ±ZÛȍűƽ½ĳá\\\\ǁ÷ùйŗ]µˀǋFÁňçǙ[ēÐÿΈåšűšǓXĳŏȀŏĒōɁÓaÛǉ} ǓƷtoŷğɊčüĂȢ]øҏǻOÙÑĩWÛüϽĽħÂţ«ƧČσʃWʵĿɳ}ӟ͛ĕŗੇ@׷B١JቑOۡBࢿ@Ťȡ|ȋ[ڇhʱǵČșƐǗtгǀɥ¬˥ĀĝIȗĊǥĔŤ͛îËO\"],\"encodeOffsets\":[[64461,48324]]}},{\"type\":\"Feature\",\"properties\":{\"name\":\"Kostanay Province\"},\"geometry\":{\"type\":\"Polygon\",\"coordinates\":[\"@@RȃþŁũʊűƗuƽÛìǑŎDKœÃ§DįŜBPʹŦBÅǏHſjáɂW[ëǃNTŇğEY˝OȕŉÁĝɥșÏƩQĝŚA´±ȋƃÝĻǨķƽtÅƺpÔĢŢsňųĞÚţİtʔĉɢĶûÈūΤĐȐAƀÌźóŅů˫ãPıɝƱ˧ʑǡÍƻĹğƽŉy˷ȽʟUmāɣ·ثĠ¡əȕAĢƍ̏¥²ħɡƫȵʄ̕Ű˳ä{ÜæĘġÆƥãʟƚđƲĐ°ȯȴŐƾİ¨ņǈØƄf¿ŐƁŪčƀŃĢ½ǂơ¡TƈźªǛŀ®Ēŵ¸ƯDĸȉMşÌêʫ°ǟNÁŮͯDī|NŶɣĀŇläǒEˀƔǦA̎ǈïƈŝ^DĴŅlEĐĺTʊǲŊ¦ŜäƎéÎɒ£ƜWĺ˭Ôġèū§Ń¸ƥRÏļŤĘŊ±ƒÐÈƋTƧāªȁX˜ƘûĞƄƜƾRø×ƀlŎÉƾ[ö˪IĚėĞNŚǬɰOÒâ̰pʈÄƲBмĂɎYȤÐŬÿİuƀΞĠĪĈøŘjĀÝ\"],\"encodeOffsets\":[[67662,55952]]}},{\"type\":\"Feature\",\"properties\":{\"name\":\"Kyzylorda Province\"},\"geometry\":{\"type\":\"Polygon\",\"coordinates\":[\"@@ÌP͜íēţǦȘĉĞJ˦ÿɦ«дƿǘsȚƏǶċʲڈgȌ\\\\Ȣ{ţ@Çňí¾ûãùɩÇăǼıŀSċj̵eǯċĶÓŴoØėɆŝāû\\\\ŏăąÉĕƅsĥîŵԏȏċ«ࠍӛß`rȒD̺Ʌãʇδ̽ǦƵȂÏjͭƑ֩zёªङŏȧYӡдʋȐŔĭª࠽ӺŁvʌ·ĊƧă˵ϹǆМ¢ÖĲWlłǓéSĈæϘϒǪƎ̢Ȝ̂`jǰήWֲ͠zӆRŴĕŘƫĶ]ɰǝqï̲©\"],\"encodeOffsets\":[[64461,48324]]}},{\"type\":\"Feature\",\"properties\":{\"name\":\"Mangystau Province\"},\"geometry\":{\"type\":\"Polygon\",\"coordinates\":[\"@@аFǰĦÞĴɰFϔÖŞɎ`ƲWǾŸĬĉǜ[äƕÔhƒė̂mŞǥŚؽصƩ@Ӂ@ַFᎭĿN̓ãƷŞǙȂƓȈDÖƟŪҽ˞խùӯƕЧ˗AŦÑŞ|ĎļňĚȬÎØ]ĞĿÐşōQǙ®ȡŝǚĕÎè˳~ʰĪĩÐŋƦ{ńŃĈ{ƌÃ̃¬ƯüSƈÖĎβŮTǬřČ@ĂÆŀ\\\\ĈįGķʐìņ}žŠŘǔŢ¼ʔNʒąƼT͆ǭWȂĨŲG˴ŝ̭ĻăùóŹșˏPÃĲwľĸŖǶPúǘŶŚmǤÊƞfɬW;ȢĹ©äƧÎěĺĩvÈƿŨȯkÕāɱƧƕǎ̙ÊJúöƈ\"],\"encodeOffsets\":[[54469,47117]]}},{\"type\":\"Feature\",\"properties\":{\"name\":\"North Kazakhstan\"},\"geometry\":{\"type\":\"Polygon\",\"coordinates\":[\"@@ʲÂݶĺ¨¢Ș{ǮîǴiǞfĬãÆö°̲HĔƘǀµIĸȨµ©Вjƶ±îïɸ¿Ⱦł˜GǂǝƱŜơǎķý°ȋȓ_ƬȯĸüǌuA¹ȞNŰ˼ĔŜèvĹľŧµĉĲŞàĀ͖ÔĥȞǮIRÆȾ¨ÝǕȧjǵʷƆñŢœűOsŁĠ{ŜÐĺǗƁúÙĳŜIȈĸąȗŝµÇƨͥTÀέìŷfǪ½ĘΛ¥ȹDĵʑȷú½ĆĦjŘƕǰ˕ĳȥvVĆσFBąŗWPóŗKğŌǕDÀŬȝXŲɏVęiěƫÌїƙƫáGĊǁłK ÏQƋĻÁÊţʇģÃġƩWƝ¥¼ëǇƽ˓ŸȧDCȅǓ¨ƿ[ōƁMçĂʩƉĴÓcZ˞ĠFSňǄM\\\\ìɁXiâƀǐGAÆťOʺśACİÄ¨LŔōCëǒƾÜƘvʉŲŪýłQȄ\"],\"encodeOffsets\":[[67662,55952]]}},{\"type\":\"Feature\",\"properties\":{\"name\":\"Pavlodar Province\"},\"geometry\":{\"type\":\"Polygon\",\"coordinates\":[\"@@ǦĲƪtâÔƞkǸËĔėĆĪyĸƦkðĸÎɄ˦ƖCĢȈ|ԔƊ²ĊȀǘx°ÖŰĭĹşģǭCĒĻڪͻӊʭͲ΁Ϫэ˔˳Ɇ˥̙ɑȯdŽƷåˏŉ·İĕĆşƴCđÈ±Ɔ\\\\lȅÚmŉǥțǗ§ʛÀΡĺą²ƾǏðǓbƩĎșwÁ£ŋˋĿ¶Ʌs³ýƯǁť~¿ʿaˉţƕVÈŐÞǢÐƗÚKè˵ǒȑ°ſȿSċ®xĬĺÄ«Ğ¶ŪcĔ̟ÞŨƊƜ¾ɲnȉÚ{ǷcNņǜƮ@Ԥß¦Ƨ¶ÈȘŞĆȇķśJĴùÚǘƂĹśÏğ|tłŲPšŔ\"],\"encodeOffsets\":[[75202,54718]]}},{\"type\":\"Feature\",\"properties\":{\"name\":\"South Kazakhstan Province\"},\"geometry\":{\"type\":\"Polygon\",\"coordinates\":[\"@@à_ࠎӜČ¬ԐȐŶítĦĖƆĆÊĄ[ŐĂüɅŞ×ĘųpĵÔČfǰi̶TČĿǻĲÈĄɪäú½üŇî@Èࣀ@ۢAǘȗþɫĘƅņ͏¼ÉÄȟĜбıőuɛĻǧĻĿĞgYđĐʈ©ǪřČŋcǑƢ½ȬŹ áǘŏdğíEģñ«ėƃĀſÓƋƿƳÏe˷ÑùċÇLƅŋɓÓCġȡŝƇơÅcJǻxōĝFʅĞȭŦĤĀ@ĘĕIeľč]ō¢̱±փ\\\\ċ̒×͒҅ºFΤÎm\"],\"encodeOffsets\":[[67657,43355]]}},{\"type\":\"Feature\",\"properties\":{\"name\":\"West Kazakhstan\"},\"geometry\":{\"type\":\"Polygon\",\"coordinates\":[\"@@áĿċ¿ÚÉ]ŻĲ±yś˃˃ǫRǍÿƕʅ̯ȇο~ĳ«PȟďJÛƣAƿěCȁêśgŋ¸ŁUVĠΣ¤ĳǧS³ĭʑëҥȹǟŝȉuʽVPēЫŌɷªݑÈֹÄZ̓îɉäʌѤĨ~ŘĜŤǷĜĸѲɼÒƞƆăĈĤĚÈîŜŴĹƪĉƀţđŚřƴqʜðƄĆƟȪã̀ƌKǐòİĒʘÄsȮ͎bɚŨǴ~òĎǢèIŀ̚üФ¨ƓǬÂ`÷Ƅ¢îļĐǒqȶîȘɽȌ¨ĪЪ\\\\ƴÇhıÈÙ̮ËĠ¯ÀťèɆ½ķȓŊý\"],\"encodeOffsets\":[[55853,51741]]}}],\"UTF8Encoding\":true}', 1, NULL);
-INSERT INTO `sys_config` VALUES (35, 'email_enable', 'off', 1, NULL);
-INSERT INTO `sys_config` VALUES (36, 'generator_path', '/opt/nezha/nz-web/generator', 1, 'generator路径');
-INSERT INTO `sys_config` VALUES (37, 'email_smtp_host', 'smtp.163.com', 1, NULL);
-INSERT INTO `sys_config` VALUES (38, 'email_smtp_port', '25', 1, NULL);
-INSERT INTO `sys_config` VALUES (39, 'email_smtp_account', '[email protected]', 1, NULL);
-INSERT INTO `sys_config` VALUES (40, 'email_smtp_password', 'XORTBFYKFTFLTADZ', 1, NULL);
-INSERT INTO `sys_config` VALUES (41, 'email_send_account', '[email protected]', 1, NULL);
-INSERT INTO `sys_config` VALUES (42, 'email_test_reciver', '[email protected]', 1, NULL);
-INSERT INTO `sys_config` VALUES (43, 'email_ssl_flag', 'off', 1, NULL);
-INSERT INTO `sys_config` VALUES (44, 'email_tls_flag', 'off', 1, NULL);
-INSERT INTO `sys_config` VALUES (45, 'asset_ping_interval', '16000', 1, NULL);
-INSERT INTO `sys_config` VALUES (46, 'scrape_interval', '15', 1, NULL);
-INSERT INTO `sys_config` VALUES (47, 'storage_local_retention', '15', 1, NULL);
-INSERT INTO `sys_config` VALUES (48, 'system_name', 'Nezha', 1, NULL);
-INSERT INTO `sys_config` VALUES (49, 'ldap_ou', 'Dev', 1, NULL);
-INSERT INTO `sys_config` VALUES (50, 'timezone', '8', 1, NULL);
-INSERT INTO `sys_config` VALUES (51, 'default_cabinet_uszie', '40', 1, '机柜默认U位值');
-INSERT INTO `sys_config` VALUES (52, 'export_pagesize', '1000', 1, 'alert_message到处时默认的每批次查询数量');
-INSERT INTO `sys_config` VALUES (53, 'alert_export_header', '{\"zh\":{\"id\":\"唯一标识\",\"alertName\":\"告警规则名称\",\"datacenter\":\"机房名称\",\"project\":\"应用名称\",\"module\":\"组件名称\",\"endpoint\":\"Endpoint\",\"asset\":\"主机地址\",\"labels\":\"告警tag信息\",\"severity\":\"告警级别\",\"summary\":\"告警摘要\",\"description\":\"告警描述\",\"startAt\":\"开始时间\",\"endAt\":\"结束时间\",\"state\":\"状态\"},\"en\":{\"id\":\"ID\",\"alertName\":\"alertName\",\"datacenter\":\"datacenter\",\"project\":\"project\",\"module\":\"module\",\"endpoint\":\"endpoint\",\"asset\":\"asset\",\"labels\":\"labels\",\"severity\":\"severity\",\"summary\":\"summary\",\"description\":\"description\",\"startAt\":\"startAt\",\"endAt\":\"endAt\",\"state\":\"state\"}}', 1, 'alert_message导出表头');
-INSERT INTO `sys_config` VALUES (54, 'alert_notify_interval', '50', 1, '单位：s');
-INSERT INTO `sys_config` VALUES (69, 'email_template', '<html><head><meta http-equiv=\"content-type\" content=\"text/html; charset=UTF-8\"></head><body><div style=\"padding:40px 0; height:auto; min-height:100px; text-align:center;\"><span align=\"center\" style=\"margin:0 auto; min-width:290px; max-width:750px;\">${description}</span></div></body></html>', 1, '邮件模板');
-INSERT INTO `sys_config` VALUES (70, 'email_smtp_protocol', 'smtp', 1, NULL);
-
--- ----------------------------
--- Table structure for sys_dict
--- ----------------------------
-DROP TABLE IF EXISTS `sys_dict`;
-CREATE TABLE `sys_dict`  (
-  `id` bigint(19) NOT NULL AUTO_INCREMENT,
-  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字典名称',
-  `type` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字典类型',
-  `code` int(11) NOT NULL COMMENT '字典码',
-  `value` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字典值',
-  `i18n_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'i18n code',
-  `order_num` int(11) NOT NULL DEFAULT 0 COMMENT '排序',
-  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
-  `del_flag` tinyint(4) NOT NULL DEFAULT 0 COMMENT '删除标记  1：删除，0：未删除',
-  `operator` bigint(19) NOT NULL COMMENT '操作人',
-  `op_time` datetime(0) NOT NULL COMMENT '操作时间',
-  `seq` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '全局唯一，用于导入撤销',
-  PRIMARY KEY (`id`) USING BTREE,
-  UNIQUE INDEX `type`(`type`, `code`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 217 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统字典表' ROW_FORMAT = Compact;
-
--- ----------------------------
--- Records of sys_dict
--- ----------------------------
-INSERT INTO `sys_dict` VALUES (3, '资产状态', 'assetState', 1, '在线', '', 0, '在线', 0, 0, '2019-11-25 14:54:43', NULL);
-INSERT INTO `sys_dict` VALUES (4, '资产状态', 'assetState', 2, '下线', '', 0, '下线', 0, 0, '2019-11-25 14:54:46', NULL);
-INSERT INTO `sys_dict` VALUES (5, '认证类型', 'authType', 1, 'Password', '', 0, '密码认证', 0, 0, '2019-11-28 10:45:46', NULL);
-INSERT INTO `sys_dict` VALUES (6, '认证类型', 'authType', 2, 'Certificate', '', 0, '证书认证', 0, 0, '2019-11-28 10:46:59', NULL);
-INSERT INTO `sys_dict` VALUES (112, '图表类型', 'chartType', 1, 'line', '', 1, '折线图', 0, 1, '2019-12-13 17:53:19', NULL);
-INSERT INTO `sys_dict` VALUES (113, '图表类型', 'chartType', 2, 'bar', '', 2, '条形图', 0, 1, '2019-12-13 17:53:19', NULL);
-INSERT INTO `sys_dict` VALUES (114, '图表类型', 'chartType', 3, 'table', '', 3, '表格', 0, 1, '2019-12-13 17:53:19', NULL);
-INSERT INTO `sys_dict` VALUES (115, '表达式类型', 'exprType', 1, 'normal', '', 1, '简单表达式', 0, 1, '2019-12-13 17:53:19', NULL);
-INSERT INTO `sys_dict` VALUES (116, '表达式类型', 'exprType', 2, 'expert', '', 2, '用户输入表达式', 0, 1, '2019-12-13 17:53:19', NULL);
-INSERT INTO `sys_dict` VALUES (117, '告警周期', 'alertInterval', 0, '17', '', 0, NULL, 0, 0, '2019-12-27 15:56:35', NULL);
-INSERT INTO `sys_dict` VALUES (141, '图表类型', 'chartType', 4, 'stackArea', '', 4, '堆栈面积图', 0, 1, '2019-12-13 17:53:19', NULL);
-INSERT INTO `sys_dict` VALUES (212, '图表类型', 'chartType', 5, 'singleStat', '', 5, 'singleStat', 0, 1, '2020-03-31 10:57:30', NULL);
-INSERT INTO `sys_dict` VALUES (213, '图表类型', 'chartType', 6, 'url', '', 6, 'url', 0, 1, '2020-03-31 10:57:33', NULL);
-
--- ----------------------------
--- Table structure for sys_i18n
--- ----------------------------
-DROP TABLE IF EXISTS `sys_i18n`;
-CREATE TABLE `sys_i18n`  (
-  `id` bigint(19) NOT NULL COMMENT '主键',
-  `code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'i18n code',
-  `lang` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '语言',
-  `value` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '翻译值',
-  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '备注信息',
-  `operator` bigint(19) NOT NULL COMMENT '操作人',
-  `op_time` datetime(0) NOT NULL COMMENT '操作时间',
-  `del_flag` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '0正常，1删除',
-  PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'i18n信息表' ROW_FORMAT = Compact;
-
--- ----------------------------
--- Table structure for sys_log
--- ----------------------------
-DROP TABLE IF EXISTS `sys_log`;
-CREATE TABLE `sys_log`  (
-  `id` int(10) NOT NULL AUTO_INCREMENT,
-  `user_id` int(10) NULL DEFAULT NULL COMMENT '用户名',
-  `operation` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户操作',
-  `type` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '可选值\r\n\r\nasset\r\n\r\nendpoint\r\n\r\nproject\r\n\r\nmodule\r\n\r\nalert rule\r\n\r\nalert message\r\n\r\npanel\r\n\r\nchart\r\n\r\ndatacenter\r\n\r\ncabinet',
-  `opera_id` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '记录操作类型的id',
-  `method` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请求方法',
-  `params` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '请求参数',
-  `time` bigint(19) NOT NULL COMMENT '执行时长(毫秒)',
-  `ip` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'IP地址',
-  `state` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '请求结果',
-  `response` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
-  `exception` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
-  `create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
-  PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 124 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统日志表' ROW_FORMAT = Compact;
-
--- ----------------------------
--- Table structure for sys_user
--- ----------------------------
-DROP TABLE IF EXISTS `sys_user`;
-CREATE TABLE `sys_user`  (
-  `user_id` int(10) NOT NULL AUTO_INCREMENT,
-  `username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名',
-  `password` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
-  `salt` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '盐',
-  `email` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
-  `status` tinyint(4) NULL DEFAULT NULL COMMENT '状态  0：禁用   1：正常',
-  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
-  `lang` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '默认语言',
-  `source` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'system' COMMENT '用户来源\r\n可选值：\r\n\r\nsystem（系统内注册用户）\r\n\r\nldap （ldap认证用户）\r\n\r\n默认：system',
-  PRIMARY KEY (`user_id`) USING BTREE,
-  UNIQUE INDEX `username`(`username`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 48 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统用户表' ROW_FORMAT = Compact;
-
--- ----------------------------
--- Records of sys_user
--- ----------------------------
-INSERT INTO `sys_user` VALUES (1, 'admin', 'e1153123d7d180ceeb820d577ff119876678732a68eef4e6ffc0b1f06a01f91b', 'YzcmCZNvbXocrsz9dm8e', '[email protected]', 1, '2016-11-11 11:11:11', 'zh', 'system');
-
--- ----------------------------
--- Table structure for terminal_log
--- ----------------------------
-DROP TABLE IF EXISTS `terminal_log`;
-CREATE TABLE `terminal_log`  (
-  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
-  `host` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '登录主机',
-  `port` int(10) NULL DEFAULT NULL COMMENT '端口',
-  `uuid` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'uuid',
-  `protocol` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '可选值：SSH，TELNET。统一大写',
-  `auth_type` int(10) NULL DEFAULT NULL COMMENT '认证类型，1：密码，2：私钥证书\r\n\r\nssh可选值：1、2\r\n\r\ntelnet可选值：1',
-  `user` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '登录主机用户名',
-  `cmd` varchar(4096) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户输入命令',
-  `user_id` int(10) NOT NULL COMMENT 'nezha系统内用户id',
-  `time` datetime(0) NOT NULL COMMENT '时间',
-  `status` int(1) NOT NULL COMMENT '状态：0：发送失败（没有通过ssh或telnet发送成功）\r\n\r\n1：发送成功',
-  PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 3236 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-
--- ----------------------------
--- Table structure for user_group
--- ----------------------------
-DROP TABLE IF EXISTS `user_group`;
-CREATE TABLE `user_group`  (
-  `id` int(10) NOT NULL AUTO_INCREMENT,
-  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户组名',
-  `description` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户组描述',
-  PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-
--- ----------------------------
--- Table structure for user_group_rel
--- ----------------------------
-DROP TABLE IF EXISTS `user_group_rel`;
-CREATE TABLE `user_group_rel`  (
-  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
-  `user_id` int(10) NOT NULL COMMENT '用户id',
-  `group_id` int(10) NOT NULL COMMENT '用户组id',
-  PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-
-
--- ----------------------------
--- Table structure for idc_traffic
--- ----------------------------
-DROP TABLE IF EXISTS `idc_traffic`;
-CREATE TABLE `idc_traffic`  (
-  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
-  `idc_id` int(10) NOT NULL COMMENT '	数据中心id',
-  `asset_id` int(10) NOT NULL COMMENT '资产Id',
-  `direction` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '流量方向 可选值 rx：接收流量\r\n\r\ntx：发送流量',
-  `ifindex` int(10) NOT NULL COMMENT '端口号',
-  `ifdescr` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '端口描述',
-  `tags` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标签 格式为json对象',
-  PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-
--- ----------------------------
--- Triggers structure for table alert_rule
--- ----------------------------
-DROP TRIGGER IF EXISTS `tri_alert_rule_insert`;
-delimiter ;;
-CREATE TRIGGER `tri_alert_rule_insert` AFTER INSERT ON `alert_rule` FOR EACH ROW begin
- update conf_event t set t.value = t.value +1 where t.table = 'rule';
-end
-;;
-delimiter ;
-
--- ----------------------------
--- Triggers structure for table alert_rule
--- ----------------------------
-DROP TRIGGER IF EXISTS `tri_alert_rule_update`;
-delimiter ;;
-CREATE TRIGGER `tri_alert_rule_update` AFTER UPDATE ON `alert_rule` FOR EACH ROW begin
- update conf_event t set t.value = t.value +1 where t.table = 'rule';
-end
-;;
-delimiter ;
-
--- ----------------------------
--- Triggers structure for table alert_rule
--- ----------------------------
-DROP TRIGGER IF EXISTS `tri_alert_rule_delete`;
-delimiter ;;
-CREATE TRIGGER `tri_alert_rule_delete` AFTER DELETE ON `alert_rule` FOR EACH ROW begin
- update conf_event t set t.value = t.value +1 where t.table = 'rule';
-end
-;;
-delimiter ;
-
--- ----------------------------
--- Triggers structure for table asset
--- ----------------------------
-DROP TRIGGER IF EXISTS `tri_asset_insert`;
-delimiter ;;
-CREATE TRIGGER `tri_asset_insert` AFTER INSERT ON `asset` FOR EACH ROW begin
- update conf_event t set t.value = t.value +1 where t.table = 'asset';
-end
-;;
-delimiter ;
-
--- ----------------------------
--- Triggers structure for table asset
--- ----------------------------
-DROP TRIGGER IF EXISTS `tri_asset_update`;
-delimiter ;;
-CREATE TRIGGER `tri_asset_update` AFTER UPDATE ON `asset` FOR EACH ROW begin
- update conf_event t set t.value = t.value +1 where t.table = 'asset';
-end
-;;
-delimiter ;
-
--- ----------------------------
--- Triggers structure for table asset
--- ----------------------------
-DROP TRIGGER IF EXISTS `tri_asset_delete`;
-delimiter ;;
-CREATE TRIGGER `tri_asset_delete` AFTER DELETE ON `asset` FOR EACH ROW begin
- update conf_event t set t.value = t.value +1 where t.table = 'asset';
-end
-;;
-delimiter ;
-
--- ----------------------------
--- Triggers structure for table endpoint
--- ----------------------------
-DROP TRIGGER IF EXISTS `tri_endpoint_insert`;
-delimiter ;;
-CREATE TRIGGER `tri_endpoint_insert` AFTER INSERT ON `endpoint` FOR EACH ROW begin
- update conf_event t set t.value = t.value +1 where t.table = 'endpoint';
-end
-;;
-delimiter ;
-
--- ----------------------------
--- Triggers structure for table endpoint
--- ----------------------------
-DROP TRIGGER IF EXISTS `tri_endpoint_update`;
-delimiter ;;
-CREATE TRIGGER `tri_endpoint_update` AFTER UPDATE ON `endpoint` FOR EACH ROW begin
- update conf_event t set t.value = t.value +1 where t.table = 'endpoint';
-end
-;;
-delimiter ;
-
--- ----------------------------
--- Triggers structure for table endpoint
--- ----------------------------
-DROP TRIGGER IF EXISTS `tri_endpoint_delete`;
-delimiter ;;
-CREATE TRIGGER `tri_endpoint_delete` AFTER DELETE ON `endpoint` FOR EACH ROW begin
- update conf_event t set t.value = t.value +1 where t.table = 'endpoint';
-end
-;;
-delimiter ;
-
--- ----------------------------
--- Triggers structure for table idc
--- ----------------------------
-DROP TRIGGER IF EXISTS `tri_idc_insert`;
-delimiter ;;
-CREATE TRIGGER `tri_idc_insert` AFTER INSERT ON `idc` FOR EACH ROW begin
- update conf_event t set t.value = t.value +1 where t.table = 'idc';
-end
-;;
-delimiter ;
-
--- ----------------------------
--- Triggers structure for table idc
--- ----------------------------
-DROP TRIGGER IF EXISTS `tri_idc_update`;
-delimiter ;;
-CREATE TRIGGER `tri_idc_update` AFTER UPDATE ON `idc` FOR EACH ROW begin
- update conf_event t set t.value = t.value +1 where t.table = 'idc';
-end
-;;
-delimiter ;
-
--- ----------------------------
--- Triggers structure for table idc
--- ----------------------------
-DROP TRIGGER IF EXISTS `tri_idc_delete`;
-delimiter ;;
-CREATE TRIGGER `tri_idc_delete` AFTER DELETE ON `idc` FOR EACH ROW begin
- update conf_event t set t.value = t.value +1 where t.table = 'idc';
-end
-;;
-delimiter ;
-
--- ----------------------------
--- Triggers structure for table module
--- ----------------------------
-DROP TRIGGER IF EXISTS `tri_module_insert`;
-delimiter ;;
-CREATE TRIGGER `tri_module_insert` AFTER INSERT ON `module` FOR EACH ROW begin
- update conf_event t set t.value = t.value +1 where t.table = 'module';
-end
-;;
-delimiter ;
-
--- ----------------------------
--- Triggers structure for table module
--- ----------------------------
-DROP TRIGGER IF EXISTS `tri_module_update`;
-delimiter ;;
-CREATE TRIGGER `tri_module_update` AFTER UPDATE ON `module` FOR EACH ROW begin
- update conf_event t set t.value = t.value +1 where t.table = 'module';
-end
-;;
-delimiter ;
-
--- ----------------------------
--- Triggers structure for table module
--- ----------------------------
-DROP TRIGGER IF EXISTS `tri_module_delete`;
-delimiter ;;
-CREATE TRIGGER `tri_module_delete` AFTER DELETE ON `module` FOR EACH ROW begin
- update conf_event t set t.value = t.value +1 where t.table = 'module';
-end
-;;
-delimiter ;
-
--- ----------------------------
--- Triggers structure for table prom_server
--- ----------------------------
-DROP TRIGGER IF EXISTS `tri_prom_server_insert`;
-delimiter ;;
-CREATE TRIGGER `tri_prom_server_insert` AFTER INSERT ON `prom_server` FOR EACH ROW begin
-   update conf_event t set t.value = t.value +1 where t.table = 'server';
-end
-;;
-delimiter ;
-
--- ----------------------------
--- Triggers structure for table prom_server
--- ----------------------------
-DROP TRIGGER IF EXISTS `tri_prom_server_update`;
-delimiter ;;
-CREATE TRIGGER `tri_prom_server_update` AFTER UPDATE ON `prom_server` FOR EACH ROW begin
- -- 只是 check_time 变化，不更新 conf_event表数据
- if NEW.host != OLD.host or NEW.port !=OLD.port or NEW.type != OLD.type or NEW.status != OLD.status or NEW.idc_id != OLD.idc_id THEN
-   update conf_event t set t.value = t.value +1 where t.table = 'server';
- end if;
-end
-;;
-delimiter ;
-
--- ----------------------------
--- Triggers structure for table prom_server
--- ----------------------------
-DROP TRIGGER IF EXISTS `tri_prom_server_delete`;
-delimiter ;;
-CREATE TRIGGER `tri_prom_server_delete` AFTER DELETE ON `prom_server` FOR EACH ROW begin
-   update conf_event t set t.value = t.value +1 where t.table = 'server';
-end
-;;
-delimiter ;
-
--- ----------------------------
--- Triggers structure for table sys_config
--- ----------------------------
-DROP TRIGGER IF EXISTS `tri_scrape_interval_update`;
-delimiter ;;
-CREATE TRIGGER `tri_scrape_interval_update` AFTER UPDATE ON `sys_config` FOR EACH ROW begin
-  if NEW.param_key='scrape_interval' then
-	  update conf_event t set t.value = t.value +1 where t.table = 'scrape_interval';
-	end if;
-end
-;;
-delimiter ;
-
--- ----------------------------
--- Triggers structure for table sys_config
--- ----------------------------
-DROP TRIGGER IF EXISTS `tri_storage_local_retention_update`;
-delimiter ;;
-CREATE TRIGGER `tri_storage_local_retention_update` AFTER UPDATE ON `sys_config` FOR EACH ROW begin
-  if NEW.param_key='storage_local_retention' then
-	  update conf_event t set t.value = t.value +1 where t.table = 'storage_local_retention';
-	end if;
-end
-;;
-delimiter ;
-
-SET FOREIGN_KEY_CHECKS = 1;