warning_type.sql 6.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869
  1. /*
  2. Navicat Premium Data Transfer
  3. Source Server : cold_baota
  4. Source Server Type : MySQL
  5. Source Server Version : 80025 (8.0.25-220701)
  6. Source Host : 127.0.0.1:40306
  7. Source Schema : cold
  8. Target Server Type : MySQL
  9. Target Server Version : 80025 (8.0.25-220701)
  10. File Encoding : 65001
  11. Date: 13/09/2024 09:26:47
  12. */
  13. SET NAMES utf8mb4;
  14. SET FOREIGN_KEY_CHECKS = 0;
  15. -- ----------------------------
  16. -- Table structure for warning_type
  17. -- ----------------------------
  18. DROP TABLE IF EXISTS `warning_type`;
  19. CREATE TABLE `warning_type` (
  20. `ID` int NOT NULL AUTO_INCREMENT,
  21. `t_name` varchar(256) DEFAULT NULL,
  22. `t__tips` longtext,
  23. `t__notice` int NOT NULL DEFAULT '0',
  24. PRIMARY KEY (`ID`)
  25. ) ENGINE=InnoDB AUTO_INCREMENT=1015 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
  26. -- ----------------------------
  27. -- Records of warning_type
  28. -- ----------------------------
  29. BEGIN;
  30. 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);
  31. 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);
  32. 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);
  33. 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);
  34. 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);
  35. 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);
  36. 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);
  37. 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);
  38. 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);
  39. 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);
  40. 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);
  41. 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);
  42. 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);
  43. 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);
  44. 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);
  45. 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);
  46. 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);
  47. 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);
  48. 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);
  49. 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);
  50. 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);
  51. 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);
  52. 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);
  53. 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);
  54. 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);
  55. 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);
  56. 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);
  57. 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);
  58. 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);
  59. 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);
  60. 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);
  61. COMMIT;
  62. SET FOREIGN_KEY_CHECKS = 1;