summaryrefslogtreecommitdiff
path: root/nz-admin/db/2020-11-19.sql
diff options
context:
space:
mode:
Diffstat (limited to 'nz-admin/db/2020-11-19.sql')
-rw-r--r--nz-admin/db/2020-11-19.sql34
1 files changed, 0 insertions, 34 deletions
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