Cold_Api/conf/warning_type.sql

/*
 Navicat Premium Data Transfer

 Source Server         : cold_baota
 Source Server Type    : MySQL
 Source Server Version : 80025 (8.0.25-220701)
 Source Host           : 127.0.0.1:40306
 Source Schema         : cold

 Target Server Type    : MySQL
 Target Server Version : 80025 (8.0.25-220701)
 File Encoding         : 65001

 Date: 13/09/2024 09:26:47
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for warning_type
-- ----------------------------
DROP TABLE IF EXISTS `warning_type`;
CREATE TABLE `warning_type` (
  `ID` int NOT NULL AUTO_INCREMENT,
  `t_name` varchar(256) DEFAULT NULL,
  `t__tips` longtext,
  `t__notice` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=1015 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of warning_type
-- ----------------------------
BEGIN;
INSERT INTO `warning_type` (`ID`, `t_name`, `t__tips`, `t__notice`) VALUES (1, '温度超上限报警', '温度超上限报警,1,1,0,0,99999,0,0,0,0,0,0,0,0,1,0,0,0|', 1);
INSERT INTO `warning_type` (`ID`, `t_name`, `t__tips`, `t__notice`) VALUES (2, '温度超下限报警', '温度超下限报警,1,1,0,0,99999,0,0,0,0,0,0,0,0,1,0,0,0|', 1);
INSERT INTO `warning_type` (`ID`, `t_name`, `t__tips`, `t__notice`) VALUES (3, '温度恢复正常', '温度恢复正常,0,1,0,0,99999,0,0,0,0,0,0,0,0,1,0,0,0|', 1);
INSERT INTO `warning_type` (`ID`, `t_name`, `t__tips`, `t__notice`) VALUES (4, '湿度超上限报警', '湿度超上限报警,1,1,0,0,99999,0,0,0,0,0,0,0,0,1,0,0,0|', 1);
INSERT INTO `warning_type` (`ID`, `t_name`, `t__tips`, `t__notice`) VALUES (5, '湿度超下限报警', '湿度超下限报警,1,1,0,0,99999,0,0,0,0,0,0,0,0,1,0,0,0|', 1);
INSERT INTO `warning_type` (`ID`, `t_name`, `t__tips`, `t__notice`) VALUES (6, '湿度恢复正常', '湿度恢复正常,0,1,0,0,99999,0,0,0,0,0,0,0,0,1,0,0,0|', 1);
INSERT INTO `warning_type` (`ID`, `t_name`, `t__tips`, `t__notice`) VALUES (7, '温度超上限预警', '温度超上限预警,0,1,0,0,99999,0,0,0,0,0,0,0,0,0,0,0,0|', 1);
INSERT INTO `warning_type` (`ID`, `t_name`, `t__tips`, `t__notice`) VALUES (8, '温度超下限预警', '温度超下限预警,0,1,0,0,99999,0,0,0,0,0,0,0,0,0,0,0,0|', 1);
INSERT INTO `warning_type` (`ID`, `t_name`, `t__tips`, `t__notice`) VALUES (9, '温度预警恢复正常', '温度预警恢复正常,0,1,0,0,99999,0,0,0,0,0,0,0,0,0,0,0,0|', 1);
INSERT INTO `warning_type` (`ID`, `t_name`, `t__tips`, `t__notice`) VALUES (10, '湿度超上限预警', '湿度超上限预警,0,1,0,0,99999,0,0,0,0,0,0,0,0,0,0,0,0|', 1);
INSERT INTO `warning_type` (`ID`, `t_name`, `t__tips`, `t__notice`) VALUES (11, '湿度超下限预警', '湿度超下限预警,0,1,0,0,99999,0,0,0,0,0,0,0,0,0,0,0,0|', 1);
INSERT INTO `warning_type` (`ID`, `t_name`, `t__tips`, `t__notice`) VALUES (12, '湿度预警恢复正常', '湿度预警恢复正常,0,1,0,0,99999,0,0,0,0,0,0,0,0,0,0,0,0|', 1);
INSERT INTO `warning_type` (`ID`, `t_name`, `t__tips`, `t__notice`) VALUES (101, '主机报警', '主机报警,0,1,0,0,99999,0,0,0,0,0,0,0,0,0,0,0,0|', 0);
INSERT INTO `warning_type` (`ID`, `t_name`, `t__tips`, `t__notice`) VALUES (102, '操作日志', '操作日志,0,1,0,0,99999,0,0,0,0,0,0,0,0,0,0,0,0|', 0);
INSERT INTO `warning_type` (`ID`, `t_name`, `t__tips`, `t__notice`) VALUES (103, '普通日志', '普通日志,0,1,0,0,99999,0,0,0,0,0,0,0,0,0,0,0,0|', 0);
INSERT INTO `warning_type` (`ID`, `t_name`, `t__tips`, `t__notice`) VALUES (109, '市电断电报警', '市电断电报警,0,1,0,0,99999,0,0,0,0,0,0,0,0,0,0,0,0|', 1);
INSERT INTO `warning_type` (`ID`, `t_name`, `t__tips`, `t__notice`) VALUES (110, '市电已恢复', '市电已恢复,0,1,0,0,99999,0,0,0,0,0,0,0,0,0,0,0,0|', 1);
INSERT INTO `warning_type` (`ID`, `t_name`, `t__tips`, `t__notice`) VALUES (111, '电池电量低报警', '电池电量低报警,0,1,0,0,99999,0,0,0,0,0,0,0,0,0,0,0,0|', 1);
INSERT INTO `warning_type` (`ID`, `t_name`, `t__tips`, `t__notice`) VALUES (112, '电池电量恢复', '电池电量恢复,0,1,0,0,99999,0,0,0,0,0,0,0,0,0,0,0,0|', 1);
INSERT INTO `warning_type` (`ID`, `t_name`, `t__tips`, `t__notice`) VALUES (113, '传感器故障报警', '传感器故障报警,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0|', 1);
INSERT INTO `warning_type` (`ID`, `t_name`, `t__tips`, `t__notice`) VALUES (114, '传感器恢复', '传感器恢复,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0|', 1);
INSERT INTO `warning_type` (`ID`, `t_name`, `t__tips`, `t__notice`) VALUES (115, '开始监测任务', '开始监测任务,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0|', 1);
INSERT INTO `warning_type` (`ID`, `t_name`, `t__tips`, `t__notice`) VALUES (116, '中途打印任务', '中途打印任务,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0|', 1);
INSERT INTO `warning_type` (`ID`, `t_name`, `t__tips`, `t__notice`) VALUES (117, '结束监测任务', '结束监测任务,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0|', 1);
INSERT INTO `warning_type` (`ID`, `t_name`, `t__tips`, `t__notice`) VALUES (1001, '设备状态异常', '设备状态异常,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0|', 1);
INSERT INTO `warning_type` (`ID`, `t_name`, `t__tips`, `t__notice`) VALUES (1002, '用户余额通知', '用户余额通知,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0|', 1);
INSERT INTO `warning_type` (`ID`, `t_name`, `t__tips`, `t__notice`) VALUES (1003, '用户消息通知', '用户消息通知,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0|', 1);
INSERT INTO `warning_type` (`ID`, `t_name`, `t__tips`, `t__notice`) VALUES (1011, '报警策略异常', '报警策略异常,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0|', 0);
INSERT INTO `warning_type` (`ID`, `t_name`, `t__tips`, `t__notice`) VALUES (1012, '传感器数据异常', '传感器数据异常,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0|', 0);
INSERT INTO `warning_type` (`ID`, `t_name`, `t__tips`, `t__notice`) VALUES (1013, '系统预警通知', '系统预警通知,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0|', 0);
INSERT INTO `warning_type` (`ID`, `t_name`, `t__tips`, `t__notice`) VALUES (1014, '运维预警通知', '运维预警通知,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0|', 0);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;