nodeMonitor.sql 1.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051
  1. /*
  2. Navicat Premium Data Transfer
  3. Source Server : localhost
  4. Source Server Type : MySQL
  5. Source Server Version : 50734
  6. Source Host : localhost:3306
  7. Source Schema : nodeMonitor
  8. Target Server Type : MySQL
  9. Target Server Version : 50734
  10. File Encoding : 65001
  11. Date: 02/11/2022 15:40:06
  12. */
  13. SET NAMES utf8mb4;
  14. SET FOREIGN_KEY_CHECKS = 0;
  15. -- ----------------------------
  16. -- Table structure for node
  17. -- ----------------------------
  18. DROP TABLE IF EXISTS `node`;
  19. CREATE TABLE `node` (
  20. `id` int(11) NOT NULL AUTO_INCREMENT,
  21. `name` varchar(128) NOT NULL COMMENT '服务器名称',
  22. `host` varchar(20) NOT NULL COMMENT '服务器IP',
  23. `port` int(11) NOT NULL COMMENT '服务器端口',
  24. `url` text NOT NULL COMMENT '服务器切换地址',
  25. `update_at` datetime DEFAULT NULL COMMENT '更新时间',
  26. `create_at` datetime DEFAULT NULL COMMENT '创建时间',
  27. PRIMARY KEY (`id`)
  28. ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4;
  29. -- ----------------------------
  30. -- Table structure for pinglog
  31. -- ----------------------------
  32. DROP TABLE IF EXISTS `pinglog`;
  33. CREATE TABLE `pinglog` (
  34. `id` int(11) NOT NULL AUTO_INCREMENT,
  35. `maxdelay` varchar(64) DEFAULT NULL COMMENT '最大延迟',
  36. `mindelay` varchar(64) DEFAULT NULL COMMENT '最小延迟',
  37. `avgdelay` varchar(64) DEFAULT NULL COMMENT '平均延迟',
  38. `losspk` varchar(64) DEFAULT NULL COMMENT '丢包率',
  39. `update_at` datetime DEFAULT NULL COMMENT '更新时间',
  40. `create_at` datetime DEFAULT NULL COMMENT '创建时间',
  41. `host` varchar(128) DEFAULT NULL COMMENT '服务器IP',
  42. PRIMARY KEY (`id`)
  43. ) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4;
  44. SET FOREIGN_KEY_CHECKS = 1;