/*
|
Navicat Premium Data Transfer
|
|
Source Server : localhost
|
Source Server Type : MySQL
|
Source Server Version : 80020 (8.0.20)
|
Source Host : localhost:3306
|
Source Schema : wgcloud
|
|
Target Server Type : MySQL
|
Target Server Version : 80020 (8.0.20)
|
File Encoding : 65001
|
|
Date: 01/12/2025 22:16:14
|
*/
|
|
SET NAMES utf8mb4;
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
-- ----------------------------
|
-- Table structure for account_info
|
-- ----------------------------
|
DROP TABLE IF EXISTS `account_info`;
|
CREATE TABLE `account_info` (
|
`ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
`ACCOUNT` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`EMAIL` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`PASSWD` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`ACCOUNT_KEY` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`REMARK` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`CREATE_TIME` timestamp NULL DEFAULT NULL,
|
PRIMARY KEY (`ID`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of account_info
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for app_info
|
-- ----------------------------
|
DROP TABLE IF EXISTS `app_info`;
|
CREATE TABLE `app_info` (
|
`ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
`HOST_NAME` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`APP_PID` char(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`CREATE_TIME` timestamp NULL DEFAULT NULL,
|
`APP_NAME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`CPU_PER` double(8, 2) NULL DEFAULT NULL,
|
`MEM_PER` double(10, 2) NULL DEFAULT NULL,
|
`APP_TYPE` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`STATE` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`ACTIVE` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`READ_BYTES` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`WRITES_BYTES` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`THREADS_NUM` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`GATHER_PID` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`GROUP_ID` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`APP_TIMES` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
PRIMARY KEY (`ID`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of app_info
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for app_state
|
-- ----------------------------
|
DROP TABLE IF EXISTS `app_state`;
|
CREATE TABLE `app_state` (
|
`ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
`APP_INFO_ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`CPU_PER` double(8, 2) NULL DEFAULT NULL,
|
`MEM_PER` double(10, 2) NULL DEFAULT NULL,
|
`CREATE_TIME` timestamp NULL DEFAULT NULL,
|
`THREADS_NUM` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
PRIMARY KEY (`ID`) USING BTREE,
|
INDEX `APP_STAT_INDEX`(`APP_INFO_ID` ASC, `CREATE_TIME` ASC) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of app_state
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for cpu_state
|
-- ----------------------------
|
DROP TABLE IF EXISTS `cpu_state`;
|
CREATE TABLE `cpu_state` (
|
`ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
`HOST_NAME` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`USER_PER` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`SYS` double(8, 2) NULL DEFAULT NULL,
|
`IDLE` double(8, 2) NULL DEFAULT NULL,
|
`IOWAIT` double(8, 2) NULL DEFAULT NULL,
|
`IRQ` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`SOFT` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`CREATE_TIME` timestamp NULL DEFAULT NULL,
|
PRIMARY KEY (`ID`) USING BTREE,
|
INDEX `CPU_ACC_HOST_INDEX`(`HOST_NAME` ASC, `CREATE_TIME` ASC) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of cpu_state
|
-- ----------------------------
|
INSERT INTO `cpu_state` VALUES ('1580113940405420032', '192.168.137.1', NULL, 28.91, NULL, NULL, NULL, NULL, '2022-10-12 16:31:30');
|
INSERT INTO `cpu_state` VALUES ('1580114183683440640', '192.168.137.1', NULL, 30.47, NULL, NULL, NULL, NULL, '2022-10-12 16:32:27');
|
INSERT INTO `cpu_state` VALUES ('1580114305297285120', '192.168.0.108', NULL, 33.79, NULL, NULL, NULL, NULL, '2022-10-12 16:32:59');
|
INSERT INTO `cpu_state` VALUES ('1580114426932101120', '192.168.137.1', NULL, 27.88, NULL, NULL, NULL, NULL, '2022-10-12 16:33:29');
|
INSERT INTO `cpu_state` VALUES ('1580114791828160512', '192.168.0.108', NULL, 25.98, NULL, NULL, NULL, NULL, '2022-10-12 16:34:31');
|
INSERT INTO `cpu_state` VALUES ('1580114913462976512', '192.168.0.108', NULL, 26.54, NULL, NULL, NULL, NULL, '2022-10-12 16:35:00');
|
INSERT INTO `cpu_state` VALUES ('1580115399993851904', '192.168.0.108', NULL, 20.70, NULL, NULL, NULL, NULL, '2022-10-12 16:36:59');
|
INSERT INTO `cpu_state` VALUES ('1580115886516338688', '192.168.0.108', NULL, 14.23, NULL, NULL, NULL, NULL, '2022-10-12 16:38:59');
|
INSERT INTO `cpu_state` VALUES ('1580116373055602688', '192.168.0.108', NULL, 30.47, NULL, NULL, NULL, NULL, '2022-10-12 16:40:59');
|
INSERT INTO `cpu_state` VALUES ('1580116859599060992', '192.168.0.108', NULL, 15.77, NULL, NULL, NULL, NULL, '2022-10-12 16:42:59');
|
INSERT INTO `cpu_state` VALUES ('1580117346142519296', '192.168.0.108', NULL, 43.36, NULL, NULL, NULL, NULL, '2022-10-12 16:44:59');
|
INSERT INTO `cpu_state` VALUES ('1580117832665006080', '192.168.0.108', NULL, 16.93, NULL, NULL, NULL, NULL, '2022-10-12 16:46:59');
|
INSERT INTO `cpu_state` VALUES ('1580118319174909952', '192.168.0.108', NULL, 9.23, NULL, NULL, NULL, NULL, '2022-10-12 16:48:59');
|
INSERT INTO `cpu_state` VALUES ('1580118903688921088', '192.168.0.108', NULL, 71.15, NULL, NULL, NULL, NULL, '2022-10-12 16:50:59');
|
|
-- ----------------------------
|
-- Table structure for cpu_temperatures
|
-- ----------------------------
|
DROP TABLE IF EXISTS `cpu_temperatures`;
|
CREATE TABLE `cpu_temperatures` (
|
`ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
`HOST_NAME` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`CORE_INDEX` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`CRIT` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`INPUT` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`MAX` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`CREATE_TIME` timestamp NULL DEFAULT NULL,
|
PRIMARY KEY (`ID`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of cpu_temperatures
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for custom_info
|
-- ----------------------------
|
DROP TABLE IF EXISTS `custom_info`;
|
CREATE TABLE `custom_info` (
|
`ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
`CUSTOM_NAME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`CUSTOM_SHELL` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`CREATE_TIME` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
|
`HOST_NAME` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`ACTIVE` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`STATE` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`RESULT_EXP` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`GROUP_ID` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`CUSTOM_VALUE` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
PRIMARY KEY (`ID`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of custom_info
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for custom_state
|
-- ----------------------------
|
DROP TABLE IF EXISTS `custom_state`;
|
CREATE TABLE `custom_state` (
|
`ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
`CUSTOM_INFO_ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`CREATE_TIME` timestamp NULL DEFAULT NULL,
|
`CUSTOM_VALUE` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
PRIMARY KEY (`ID`) USING BTREE,
|
INDEX `CUSTOM_STAT_INDEX`(`CUSTOM_INFO_ID` ASC, `CREATE_TIME` ASC) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of custom_state
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for db_info
|
-- ----------------------------
|
DROP TABLE IF EXISTS `db_info`;
|
CREATE TABLE `db_info` (
|
`ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
`DBTYPE` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`USER_NAME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`PASSWD` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`DBURL` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`CREATE_TIME` timestamp NULL DEFAULT NULL,
|
`DB_STATE` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`ALIAS_NAME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`ACCOUNT` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
PRIMARY KEY (`ID`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of db_info
|
-- ----------------------------
|
INSERT INTO `db_info` VALUES ('1596835671211900928', 'mysql', 'root', 'rootroot', 'jdbc:mysql://localhost:3306/wgcloud?characterEncoding=utf-8&characterSetResults=utf8&autoReconnect=true&useSSL=false&allowMultiQueries=true&allowPublicKeyRetrieval=true', '2022-12-05 17:46:52', '1', '本地数据库', NULL);
|
|
-- ----------------------------
|
-- Table structure for db_table
|
-- ----------------------------
|
DROP TABLE IF EXISTS `db_table`;
|
CREATE TABLE `db_table` (
|
`ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
`TABLE_NAME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`WHERE_VAL` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`CREATE_TIME` timestamp NULL DEFAULT NULL,
|
`REMARK` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`TABLE_COUNT` bigint NULL DEFAULT NULL,
|
`DBINFO_ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`ACTIVE` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`STATE` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`RESULT_EXP` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
PRIMARY KEY (`ID`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of db_table
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for db_table_count
|
-- ----------------------------
|
DROP TABLE IF EXISTS `db_table_count`;
|
CREATE TABLE `db_table_count` (
|
`ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
`DB_TABLE_ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`TABLE_COUNT` bigint NULL DEFAULT NULL,
|
`CREATE_TIME` timestamp NULL DEFAULT NULL,
|
PRIMARY KEY (`ID`) USING BTREE,
|
INDEX `DBTABLE_ID_CREATE_TIME`(`DB_TABLE_ID` ASC, `CREATE_TIME` ASC) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of db_table_count
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for dce_info
|
-- ----------------------------
|
DROP TABLE IF EXISTS `dce_info`;
|
CREATE TABLE `dce_info` (
|
`ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
`HOST_NAME` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`CREATE_TIME` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
|
`ACTIVE` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`RES_TIMES` int NULL DEFAULT NULL,
|
`REMARK` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`GROUP_ID` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`ACCOUNT` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
PRIMARY KEY (`ID`) USING BTREE,
|
INDEX `DCE_INFO_HOSTNAME_INDEX`(`HOST_NAME` ASC) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of dce_info
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for dce_state
|
-- ----------------------------
|
DROP TABLE IF EXISTS `dce_state`;
|
CREATE TABLE `dce_state` (
|
`ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
`DCE_ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`RES_TIMES` int NULL DEFAULT NULL,
|
`CREATE_TIME` timestamp NULL DEFAULT NULL,
|
PRIMARY KEY (`ID`) USING BTREE,
|
INDEX `DCE_STATE_DCEID_INDEX`(`DCE_ID` ASC, `CREATE_TIME` ASC) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of dce_state
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for desk_io
|
-- ----------------------------
|
DROP TABLE IF EXISTS `desk_io`;
|
CREATE TABLE `desk_io` (
|
`ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
`FILE_STSTEM` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`READ_COUNT` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`WRITE_OUNT` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`READ_BYTES` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`WRITE_BYTES` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`READ_TIME` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`WRITE_TIME` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`CREATE_TIME` timestamp NULL DEFAULT NULL,
|
`HOST_NAME` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
PRIMARY KEY (`ID`) USING BTREE,
|
INDEX `DISO_IO_HOST_INDEX`(`HOST_NAME` ASC) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of desk_io
|
-- ----------------------------
|
INSERT INTO `desk_io` VALUES ('1580114183977041920', 'F:', '1279031', '172717', '88G', '2G', '618', '125', '2022-10-12 16:32:27', '192.168.137.1');
|
INSERT INTO `desk_io` VALUES ('1580114183977041921', 'E:', '774973', '809732', '9G', '15G', '202', '212', '2022-10-12 16:32:27', '192.168.137.1');
|
INSERT INTO `desk_io` VALUES ('1580114183977041922', 'D:', '659188', '910389', '20G', '14G', '181', '267', '2022-10-12 16:32:27', '192.168.137.1');
|
INSERT INTO `desk_io` VALUES ('1580114183977041923', 'C:', '6246612', '4467160', '211G', '192G', '4715', '1802', '2022-10-12 16:32:27', '192.168.137.1');
|
INSERT INTO `desk_io` VALUES ('1580114913613971456', 'F:', '1279318', '172748', '88G', '2G', '618', '125', '2022-10-12 16:35:00', '192.168.0.108');
|
INSERT INTO `desk_io` VALUES ('1580114913613971457', 'E:', '775014', '810228', '9G', '15G', '202', '212', '2022-10-12 16:35:00', '192.168.0.108');
|
INSERT INTO `desk_io` VALUES ('1580114913613971458', 'D:', '660320', '910987', '20G', '14G', '181', '267', '2022-10-12 16:35:00', '192.168.0.108');
|
INSERT INTO `desk_io` VALUES ('1580114913613971459', 'C:', '6255742', '4471326', '211G', '192G', '4718', '1803', '2022-10-12 16:35:00', '192.168.0.108');
|
|
-- ----------------------------
|
-- Table structure for disk_smart
|
-- ----------------------------
|
DROP TABLE IF EXISTS `disk_smart`;
|
CREATE TABLE `disk_smart` (
|
`ID` char(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
|
`HOST_NAME` char(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
|
`FILE_STSTEM` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
|
`DISK_STATE` char(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
|
`POWER_HOURS` char(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
|
`POWER_COUNT` char(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
|
`TEMPERATURE` char(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
|
`CREATE_TIME` timestamp NULL DEFAULT NULL,
|
PRIMARY KEY (`ID`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of disk_smart
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for disk_state
|
-- ----------------------------
|
DROP TABLE IF EXISTS `disk_state`;
|
CREATE TABLE `disk_state` (
|
`ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
`HOST_NAME` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`FILE_STSTEM` char(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`DISK_SIZE` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`USED` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`AVAIL` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`USE_PER` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`DATE_STR` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`CREATE_TIME` timestamp NULL DEFAULT NULL,
|
PRIMARY KEY (`ID`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of disk_state
|
-- ----------------------------
|
INSERT INTO `disk_state` VALUES ('1580114183926710272', '192.168.137.1', 'F:', '85.0G', '50.43G', '34.57G', '59.33%', NULL, '2022-10-12 16:32:27');
|
INSERT INTO `disk_state` VALUES ('1580114183926710273', '192.168.137.1', 'E:', '100.0G', '96.24G', '3.76G', '96.24%', NULL, '2022-10-12 16:32:27');
|
INSERT INTO `disk_state` VALUES ('1580114183926710274', '192.168.137.1', 'D:', '180.0G', '151.49G', '28.51G', '84.16%', NULL, '2022-10-12 16:32:27');
|
INSERT INTO `disk_state` VALUES ('1580114183926710275', '192.168.137.1', 'C:', '110.69G', '98.0G', '12.69G', '88.53%', NULL, '2022-10-12 16:32:27');
|
INSERT INTO `disk_state` VALUES ('1580114913588805632', '192.168.0.108', 'F:', '85.0G', '50.43G', '34.57G', '59.33%', NULL, '2022-10-12 16:35:00');
|
INSERT INTO `disk_state` VALUES ('1580114913588805633', '192.168.0.108', 'E:', '100.0G', '96.24G', '3.76G', '96.24%', NULL, '2022-10-12 16:35:00');
|
INSERT INTO `disk_state` VALUES ('1580114913588805634', '192.168.0.108', 'D:', '180.0G', '151.49G', '28.51G', '84.16%', NULL, '2022-10-12 16:35:00');
|
INSERT INTO `disk_state` VALUES ('1580114913588805635', '192.168.0.108', 'C:', '110.69G', '98.17G', '12.53G', '88.68%', NULL, '2022-10-12 16:35:00');
|
|
-- ----------------------------
|
-- Table structure for docker_info
|
-- ----------------------------
|
DROP TABLE IF EXISTS `docker_info`;
|
CREATE TABLE `docker_info` (
|
`ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
`HOST_NAME` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`DOCKER_ID` char(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`DOCKER_NAME` char(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`SYSTEM_TIME` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`MEM_PER` double(8, 0) NULL DEFAULT NULL,
|
`STATE` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`CREATE_TIME` timestamp NULL DEFAULT NULL,
|
`USER_TIME` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`ACTIVE` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`APP_TYPE` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`DOCKER_IMAGE` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`DOCKER_PORT` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`DOCKER_COMMAND` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`DOCKER_CREATED` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`DOCKER_SIZE` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`DOCKER_STATUS` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`GATHER_DOCKER_NAMES` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`GROUP_ID` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
PRIMARY KEY (`ID`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of docker_info
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for docker_state
|
-- ----------------------------
|
DROP TABLE IF EXISTS `docker_state`;
|
CREATE TABLE `docker_state` (
|
`ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
`DOCKER_INFO_ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`CPU_PER` double(8, 0) NULL DEFAULT NULL,
|
`MEM_PER` double(8, 0) NULL DEFAULT NULL,
|
`CREATE_TIME` timestamp NULL DEFAULT NULL,
|
PRIMARY KEY (`ID`) USING BTREE,
|
INDEX `DOCKER_STATE_INDEX`(`DOCKER_INFO_ID` ASC, `CREATE_TIME` ASC) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of docker_state
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for equipment
|
-- ----------------------------
|
DROP TABLE IF EXISTS `equipment`;
|
CREATE TABLE `equipment` (
|
`ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
`NAME` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`XINGHAO` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`PERSON` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`DEPT` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`CODE` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`PRICE` double(10, 2) NULL DEFAULT NULL,
|
`GONGYINGSHANG` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`CAIGOU_DATE` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`REMARK` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`CREATE_TIME` timestamp NULL DEFAULT NULL,
|
`ACCOUNT` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
PRIMARY KEY (`ID`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of equipment
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for file_safe
|
-- ----------------------------
|
DROP TABLE IF EXISTS `file_safe`;
|
CREATE TABLE `file_safe` (
|
`ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
`HOST_NAME` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`FILE_NAME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`STATE` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`FILE_PATH` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`ACTIVE` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`FILE_SIGN` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`FILE_MODTIME` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`CREATE_TIME` timestamp NULL DEFAULT NULL,
|
PRIMARY KEY (`ID`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of file_safe
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for file_warn
|
-- ----------------------------
|
DROP TABLE IF EXISTS `file_warn`;
|
CREATE TABLE `file_warn` (
|
`ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
`FILE_PATH` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`FILE_SIZE` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`WARN_CHARS` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`CREATE_TIME` timestamp NULL DEFAULT NULL,
|
`WARN_ROWS` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`HOST_NAME` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`REMARK` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`ACTIVE` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`FILE_NAME_PREFIX` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`FILE_TYPE` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
PRIMARY KEY (`ID`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of file_warn
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for file_warn_state
|
-- ----------------------------
|
DROP TABLE IF EXISTS `file_warn_state`;
|
CREATE TABLE `file_warn_state` (
|
`ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
`WAR_CONTENT` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
|
`CREATE_TIME` timestamp NULL DEFAULT NULL,
|
`FILE_WARN_ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`FILE_PATH` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
PRIMARY KEY (`ID`) USING BTREE,
|
INDEX `FILE_WARN_ID_INDEX`(`FILE_WARN_ID` ASC) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of file_warn_state
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for heath_monitor
|
-- ----------------------------
|
DROP TABLE IF EXISTS `heath_monitor`;
|
CREATE TABLE `heath_monitor` (
|
`ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
`APP_NAME` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`HEATH_URL` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`CREATE_TIME` timestamp NULL DEFAULT NULL,
|
`HEATH_STATUS` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`RES_TIMES` int NULL DEFAULT NULL,
|
`ACTIVE` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`RES_KEYWORD` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`METHOD` char(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`POST_STR` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`RES_NO_KEYWORD` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`HEADER_JSON` varchar(1500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`ACCOUNT` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
PRIMARY KEY (`ID`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of heath_monitor
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for heath_state
|
-- ----------------------------
|
DROP TABLE IF EXISTS `heath_state`;
|
CREATE TABLE `heath_state` (
|
`ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
`HEATH_ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`CREATE_TIME` timestamp NULL DEFAULT NULL,
|
`RES_TIMES` int NULL DEFAULT NULL,
|
PRIMARY KEY (`ID`) USING BTREE,
|
INDEX `HEATH_ID_CREATE_TIME`(`HEATH_ID` ASC, `CREATE_TIME` ASC) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of heath_state
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for host_disk_per
|
-- ----------------------------
|
DROP TABLE IF EXISTS `host_disk_per`;
|
CREATE TABLE `host_disk_per` (
|
`ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
`HOST_NAME` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`DISK_SUM_PER` double NULL DEFAULT NULL,
|
`CREATE_TIME` timestamp NULL DEFAULT NULL,
|
PRIMARY KEY (`ID`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of host_disk_per
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for host_group
|
-- ----------------------------
|
DROP TABLE IF EXISTS `host_group`;
|
CREATE TABLE `host_group` (
|
`ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
`GROUP_NAME` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`CREATE_TIME` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
|
`REMARK` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`GROUP_TYPE` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
PRIMARY KEY (`ID`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of host_group
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for intrusion_info
|
-- ----------------------------
|
DROP TABLE IF EXISTS `intrusion_info`;
|
CREATE TABLE `intrusion_info` (
|
`ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
`HOST_NAME` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`LSMOD` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
|
`PASSWD_INFO` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`CRONTAB` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
|
`PROMISC` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`RPCINFO` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
|
`CREATE_TIME` timestamp NULL DEFAULT NULL,
|
PRIMARY KEY (`ID`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of intrusion_info
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for log_info
|
-- ----------------------------
|
DROP TABLE IF EXISTS `log_info`;
|
CREATE TABLE `log_info` (
|
`ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
`HOST_NAME` char(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`INFO_CONTENT` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
|
`STATE` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`CREATE_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
PRIMARY KEY (`ID`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of log_info
|
-- ----------------------------
|
INSERT INTO `log_info` VALUES ('1579987713828978688', '定时清空历史趋势图数据完成', '每天8:10清空20天前的监控历史趋势图数据，任务完成', '2', '2022-10-12 08:10:00');
|
INSERT INTO `log_info` VALUES ('1580113940975845376', '主机已恢复上线：192.168.137.1', '主机已恢复上线：192.168.137.1', '3', '2022-10-12 16:31:35');
|
INSERT INTO `log_info` VALUES ('1580114305414725632', '主机已恢复上线：192.168.0.108', '主机已恢复上线：192.168.0.108', '3', '2022-10-12 16:33:02');
|
INSERT INTO `log_info` VALUES ('1580116335357198336', '主机下线告警：192.168.137.1', '主机可能已下线：192.168.137.1', '1', '2022-10-12 16:41:06');
|
INSERT INTO `log_info` VALUES ('1596046836488077312', '主机下线告警：192.168.137.1', '主机可能已下线：192.168.137.1', '1', '2022-11-25 15:43:13');
|
INSERT INTO `log_info` VALUES ('1596046836488077313', '主机下线告警：192.168.0.108', '主机可能已下线：192.168.0.108', '1', '2022-11-25 15:43:13');
|
INSERT INTO `log_info` VALUES ('1596048254729060352', 'admin添加snmp设备监测信息：192.168.8.150', 'snmp设备：F1060', '2', '2022-11-25 15:48:51');
|
INSERT INTO `log_info` VALUES ('1596078293734522880', '主机下线告警：192.168.0.108', '主机可能已下线：192.168.0.108', '1', '2022-11-25 17:48:13');
|
INSERT INTO `log_info` VALUES ('1596078293734522881', '主机下线告警：192.168.137.1', '主机可能已下线：192.168.137.1', '1', '2022-11-25 17:48:13');
|
INSERT INTO `log_info` VALUES ('1596086484006469632', 'snmp设备监测告警：192.168.8.150(F1060)', 'snmp设备：192.168.8.150(F1060)，可能已下线', '1', '2022-11-25 18:20:46');
|
INSERT INTO `log_info` VALUES ('1596087675172028416', 'snmp设备监测告警：192.168.8.150(F1060)', 'snmp设备：192.168.8.150(F1060)，可能已下线', '1', '2022-11-25 18:25:30');
|
INSERT INTO `log_info` VALUES ('1596088358872940544', 'snmp设备监测告警：192.168.8.150(F1060)', 'snmp设备：192.168.8.150(F1060)，可能已下线', '1', '2022-11-25 18:28:13');
|
INSERT INTO `log_info` VALUES ('1596682974651351040', '主机下线告警：192.168.137.1', '主机可能已下线：192.168.137.1', '1', '2022-11-27 09:51:00');
|
INSERT INTO `log_info` VALUES ('1596682974651351041', '主机下线告警：192.168.0.108', '主机可能已下线：192.168.0.108', '1', '2022-11-27 09:51:00');
|
INSERT INTO `log_info` VALUES ('1596684083247841280', 'admin修改snmp设备监测信息：192.168.8.150', 'snmp设备：F1060', '2', '2022-11-27 09:55:25');
|
INSERT INTO `log_info` VALUES ('1596684534445899776', '主机下线告警：192.168.0.108', '主机可能已下线：192.168.0.108', '1', '2022-11-27 09:57:12');
|
INSERT INTO `log_info` VALUES ('1596684534445899777', '主机下线告警：192.168.137.1', '主机可能已下线：192.168.137.1', '1', '2022-11-27 09:57:12');
|
INSERT INTO `log_info` VALUES ('1596685365677260800', 'admin修改snmp设备监测信息：192.168.8.150', 'snmp设备：F1060', '2', '2022-11-27 10:00:30');
|
INSERT INTO `log_info` VALUES ('1596685638856474624', 'admin修改snmp设备监测信息：192.168.8.150', 'snmp设备：F1060', '2', '2022-11-27 10:01:35');
|
INSERT INTO `log_info` VALUES ('1596692254012080128', 'admin修改snmp设备监测信息：192.168.8.150', 'snmp设备：F1060', '2', '2022-11-27 10:27:53');
|
INSERT INTO `log_info` VALUES ('1596699670745317376', '主机下线告警：192.168.137.1', '主机可能已下线：192.168.137.1', '1', '2022-11-27 10:57:21');
|
INSERT INTO `log_info` VALUES ('1596699670745317377', '主机下线告警：192.168.0.108', '主机可能已下线：192.168.0.108', '1', '2022-11-27 10:57:21');
|
INSERT INTO `log_info` VALUES ('1596731128000151552', '主机下线告警：192.168.137.1', '主机可能已下线：192.168.137.1', '1', '2022-11-27 13:02:21');
|
INSERT INTO `log_info` VALUES ('1596731128000151553', '主机下线告警：192.168.0.108', '主机可能已下线：192.168.0.108', '1', '2022-11-27 13:02:21');
|
INSERT INTO `log_info` VALUES ('1596762585292734464', '主机下线告警：192.168.0.108', '主机可能已下线：192.168.0.108', '1', '2022-11-27 15:07:21');
|
INSERT INTO `log_info` VALUES ('1596762585292734465', '主机下线告警：192.168.137.1', '主机可能已下线：192.168.137.1', '1', '2022-11-27 15:07:21');
|
INSERT INTO `log_info` VALUES ('1596794042568540160', '主机下线告警：192.168.0.108', '主机可能已下线：192.168.0.108', '1', '2022-11-27 17:12:21');
|
INSERT INTO `log_info` VALUES ('1596794042568540161', '主机下线告警：192.168.137.1', '主机可能已下线：192.168.137.1', '1', '2022-11-27 17:12:21');
|
INSERT INTO `log_info` VALUES ('1596825499844345856', '主机下线告警：192.168.0.108', '主机可能已下线：192.168.0.108', '1', '2022-11-27 19:17:21');
|
INSERT INTO `log_info` VALUES ('1596825499844345857', '主机下线告警：192.168.137.1', '主机可能已下线：192.168.137.1', '1', '2022-11-27 19:17:21');
|
INSERT INTO `log_info` VALUES ('1596834091406327808', '主机下线告警：192.168.0.108', '主机可能已下线：192.168.0.108', '1', '2022-11-27 19:51:29');
|
INSERT INTO `log_info` VALUES ('1596834091406327809', '主机下线告警：192.168.137.1', '主机可能已下线：192.168.137.1', '1', '2022-11-27 19:51:29');
|
INSERT INTO `log_info` VALUES ('1596835671262232576', 'admin添加数据源监测信息：本地数据库', '数据库类型：mysql', '2', '2022-11-27 19:57:46');
|
INSERT INTO `log_info` VALUES ('1596836702465425408', '主机下线告警：192.168.137.1', '主机可能已下线：192.168.137.1', '1', '2022-11-27 20:01:52');
|
INSERT INTO `log_info` VALUES ('1596836702465425409', '主机下线告警：192.168.0.108', '主机可能已下线：192.168.0.108', '1', '2022-11-27 20:01:52');
|
INSERT INTO `log_info` VALUES ('1596839336307982336', '主机下线告警：192.168.0.108', '主机可能已下线：192.168.0.108', '1', '2022-11-27 20:12:20');
|
INSERT INTO `log_info` VALUES ('1596839336307982337', '主机下线告警：192.168.137.1', '主机可能已下线：192.168.137.1', '1', '2022-11-27 20:12:20');
|
INSERT INTO `log_info` VALUES ('1596842419050119168', '主机下线告警：192.168.137.1', '主机可能已下线：192.168.137.1', '1', '2022-11-27 20:24:35');
|
INSERT INTO `log_info` VALUES ('1596842419050119169', '主机下线告警：192.168.0.108', '主机可能已下线：192.168.0.108', '1', '2022-11-27 20:24:35');
|
INSERT INTO `log_info` VALUES ('1596842701498744832', 'admin删除主机：192.168.0.108', '主机：null', '2', '2022-11-27 20:25:42');
|
INSERT INTO `log_info` VALUES ('1596842711854481408', 'admin删除主机：192.168.137.1', '主机：null', '2', '2022-11-27 20:25:45');
|
INSERT INTO `log_info` VALUES ('1596854035179241472', 'admin修改snmp设备监测信息：192.168.8.150', 'snmp设备：F1060', '2', '2022-11-27 21:10:44');
|
INSERT INTO `log_info` VALUES ('1596857217959723008', 'admin修改snmp设备监测信息：192.168.8.150', 'snmp设备：F1060', '2', '2022-11-27 21:23:23');
|
INSERT INTO `log_info` VALUES ('1596857268131987456', 'admin修改snmp设备监测信息：192.168.8.150', 'snmp设备：F1060', '2', '2022-11-27 21:23:35');
|
INSERT INTO `log_info` VALUES ('1596860020878868480', '保存snmp设备监测错误', 'org.springframework.jdbc.BadSqlGrammarException: \r\n### Error updating database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'INTERFACE_NAME_OID = \'1.3.6.1.2.1.31.1.1.1.1\'\n \n \n ACTUAL_SPEED_OID = \'1.\' at line 47\r\n### The error may exist in file [D:\\project\\v3.4.1源码(正式版) 2\\v3.4.1源码(正式版)\\源码\\server\\wgcloud-server\\target\\classes\\mybatis\\mapper\\SnmpInfoMapper.xml]\r\n### The error may involve com.wgcloud.mapper.SnmpInfoMapper.updateById-Inline\r\n### The error occurred while setting parameters\r\n### SQL: UPDATE SNMP_INFO SET HOST_NAME = ?, ACTIVE = ?, REMARK = ?, RECV_OID = ?, SENT_OID = ?, SNMP_COMMUNITY = ?, SNMP_PORT = ?, SNMP_VERSION = ?, CPU_PER_OID = ?, MEM_SIZE_OID = ?, MEM_TOTAL_SIZE_OID = ?, INTERFACE_STATUS_OID = ? INTERFACE_NAME_OID = ? ACTUAL_SPEED_OID = ? WORK_MTU_OID = ? ACTUAL_MTU_OID = ? LOOPBACK_OID = ? DESCRIPTION_OID = ? WHERE ID = ?\r\n### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'INTERFACE_NAME_OID = \'1.3.6.1.2.1.31.1.1.1.1\'\n \n \n ACTUAL_SPEED_OID = \'1.\' at line 47\n; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'INTERFACE_NAME_OID = \'1.3.6.1.2.1.31.1.1.1.1\'\n \n \n ACTUAL_SPEED_OID = \'1.\' at line 47', '2', '2022-11-27 21:34:31');
|
INSERT INTO `log_info` VALUES ('1596865252610408448', 'admin修改snmp设备监测信息：192.168.8.150', 'snmp设备：F1060', '2', '2022-11-27 21:55:19');
|
INSERT INTO `log_info` VALUES ('1597504818295996416', 'admin修改snmp设备监测信息：192.168.8.150', 'snmp设备：F1060', '2', '2022-11-29 16:16:43');
|
INSERT INTO `log_info` VALUES ('1597505432518262784', 'admin修改snmp设备监测信息：192.168.8.150', 'snmp设备：F1060', '2', '2022-11-29 16:19:09');
|
INSERT INTO `log_info` VALUES ('1599581172608925696', 'snmp设备监测告警：192.168.8.150(F1060)', 'snmp设备：192.168.8.150(F1060)，可能已下线', '1', '2022-12-05 09:47:24');
|
INSERT INTO `log_info` VALUES ('1599582998255239168', 'admin修改snmp设备监测信息：192.168.3.150', 'snmp设备：F1060', '2', '2022-12-05 09:54:40');
|
INSERT INTO `log_info` VALUES ('1599586208432914432', 'snmp设备监测已恢复：192.168.3.150(F1060)', 'snmp设备监测已恢复：192.168.3.150(F1060)', '3', '2022-12-05 10:07:25');
|
INSERT INTO `log_info` VALUES ('1599659498509828096', '主机拓扑图生成错误', 'java.lang.StringIndexOutOfBoundsException: String index out of range: -1', '2', '2022-12-05 14:58:39');
|
INSERT INTO `log_info` VALUES ('1982330853958746112', '主机拓扑图生成错误', 'java.lang.StringIndexOutOfBoundsException: String index out of range: -1', '2', '2025-10-26 14:18:00');
|
INSERT INTO `log_info` VALUES ('1995476132979408896', '查询资产信息错误', 'org.springframework.jdbc.BadSqlGrammarException: \r\n### Error querying database. Cause: java.sql.SQLSyntaxErrorException: Table \'wgcloud.inspection_task\' doesn\'t exist\r\n### The error may exist in file [D:\\project\\tssw\\target\\classes\\mybatis\\mapper\\InspectionTaskMapper.xml]\r\n### The error may involve com.wgcloud.mapper.InspectionTaskMapper.selectByParams-Inline\r\n### The error occurred while setting parameters\r\n### SQL: SELECT count(0) FROM INSPECTION_TASK\r\n### Cause: java.sql.SQLSyntaxErrorException: Table \'wgcloud.inspection_task\' doesn\'t exist\n; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Table \'wgcloud.inspection_task\' doesn\'t exist', '2', '2025-12-01 20:52:38');
|
INSERT INTO `log_info` VALUES ('1995476149660155904', '查询资产信息错误', 'org.springframework.jdbc.BadSqlGrammarException: \r\n### Error querying database. Cause: java.sql.SQLSyntaxErrorException: Table \'wgcloud.failure_logging\' doesn\'t exist\r\n### The error may exist in file [D:\\project\\tssw\\target\\classes\\mybatis\\mapper\\FailureLoggingMapper.xml]\r\n### The error may involve com.wgcloud.mapper.FailureLoggingMapper.selectByParams-Inline\r\n### The error occurred while setting parameters\r\n### SQL: SELECT count(0) FROM FAILURE_LOGGING\r\n### Cause: java.sql.SQLSyntaxErrorException: Table \'wgcloud.failure_logging\' doesn\'t exist\n; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Table \'wgcloud.failure_logging\' doesn\'t exist', '2', '2025-12-01 20:52:42');
|
|
-- ----------------------------
|
-- Table structure for mail_set
|
-- ----------------------------
|
DROP TABLE IF EXISTS `mail_set`;
|
CREATE TABLE `mail_set` (
|
`ID` char(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
|
`SEND_MAIL` char(60) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
|
`FROM_MAIL_NAME` char(60) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
|
`FROM_PWD` char(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
|
`SMTP_HOST` char(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
|
`SMTP_PORT` char(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
|
`SMTP_SSL` char(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
|
`TO_MAIL` varchar(300) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
|
`CPU_PER` char(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
|
`CREATE_TIME` timestamp NULL DEFAULT NULL,
|
`MEM_PER` char(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
|
`HEATH_PER` char(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
|
PRIMARY KEY (`ID`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of mail_set
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for mem_state
|
-- ----------------------------
|
DROP TABLE IF EXISTS `mem_state`;
|
CREATE TABLE `mem_state` (
|
`ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
`HOST_NAME` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`TOTAL` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`USED` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`FREE` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`USE_PER` double(8, 2) NULL DEFAULT NULL,
|
`CREATE_TIME` timestamp NULL DEFAULT NULL,
|
PRIMARY KEY (`ID`) USING BTREE,
|
INDEX `MEM_ACC_HOST_INDEX`(`HOST_NAME` ASC, `CREATE_TIME` ASC) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of mem_state
|
-- ----------------------------
|
INSERT INTO `mem_state` VALUES ('1580113940577386496', '192.168.137.1', NULL, NULL, NULL, 81.00, '2022-10-12 16:31:30');
|
INSERT INTO `mem_state` VALUES ('1580114183725383680', '192.168.137.1', NULL, NULL, NULL, 82.00, '2022-10-12 16:32:27');
|
INSERT INTO `mem_state` VALUES ('1580114305314062336', '192.168.0.108', NULL, NULL, NULL, 84.00, '2022-10-12 16:32:59');
|
INSERT INTO `mem_state` VALUES ('1580114426948878336', '192.168.137.1', NULL, NULL, NULL, 84.00, '2022-10-12 16:33:29');
|
INSERT INTO `mem_state` VALUES ('1580114791891075072', '192.168.0.108', NULL, NULL, NULL, 83.00, '2022-10-12 16:34:31');
|
INSERT INTO `mem_state` VALUES ('1580114913525891072', '192.168.0.108', NULL, NULL, NULL, 83.00, '2022-10-12 16:35:00');
|
INSERT INTO `mem_state` VALUES ('1580115400019017728', '192.168.0.108', NULL, NULL, NULL, 84.00, '2022-10-12 16:36:59');
|
INSERT INTO `mem_state` VALUES ('1580115886575058944', '192.168.0.108', NULL, NULL, NULL, 83.00, '2022-10-12 16:38:59');
|
INSERT INTO `mem_state` VALUES ('1580116373110128640', '192.168.0.108', NULL, NULL, NULL, 84.00, '2022-10-12 16:40:59');
|
INSERT INTO `mem_state` VALUES ('1580116859653586944', '192.168.0.108', NULL, NULL, NULL, 85.00, '2022-10-12 16:42:59');
|
INSERT INTO `mem_state` VALUES ('1580117346163490816', '192.168.0.108', NULL, NULL, NULL, 86.00, '2022-10-12 16:44:59');
|
INSERT INTO `mem_state` VALUES ('1580117832685977600', '192.168.0.108', NULL, NULL, NULL, 87.00, '2022-10-12 16:46:59');
|
INSERT INTO `mem_state` VALUES ('1580118319216852992', '192.168.0.108', NULL, NULL, NULL, 79.00, '2022-10-12 16:48:59');
|
INSERT INTO `mem_state` VALUES ('1580118903739252736', '192.168.0.108', NULL, NULL, NULL, 83.00, '2022-10-12 16:50:59');
|
|
-- ----------------------------
|
-- Table structure for netio_state
|
-- ----------------------------
|
DROP TABLE IF EXISTS `netio_state`;
|
CREATE TABLE `netio_state` (
|
`ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
`HOST_NAME` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`RXPCK` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`TXPCK` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`RXBYT` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`TXBYT` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`CREATE_TIME` timestamp NULL DEFAULT NULL,
|
`DROPIN` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`DROPOUT` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`NET_CONNECTIONS` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
PRIMARY KEY (`ID`) USING BTREE,
|
INDEX `NETIO_ACC_HOST_INDEX`(`HOST_NAME` ASC, `CREATE_TIME` ASC) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of netio_state
|
-- ----------------------------
|
INSERT INTO `netio_state` VALUES ('1580113940619329536', '192.168.137.1', '415.67', '169.67', '551.32', '11.63', '2022-10-12 16:31:30', '0.0', '0.0', '405');
|
INSERT INTO `netio_state` VALUES ('1580114183750549504', '192.168.137.1', '395.0', '137.33', '522.75', '8.41', '2022-10-12 16:32:27', '0.0', '0.0', '397');
|
INSERT INTO `netio_state` VALUES ('1580114305326645248', '192.168.0.108', '43.0', '51.0', '18.39', '14.47', '2022-10-12 16:32:59', '0.0', '0.0', '417');
|
INSERT INTO `netio_state` VALUES ('1580114426961461248', '192.168.137.1', '52.0', '41.33', '11.15', '14.61', '2022-10-12 16:33:29', '0.0', '0.0', '465');
|
INSERT INTO `netio_state` VALUES ('1580114791907852288', '192.168.0.108', '12.33', '17.33', '1.93', '1.92', '2022-10-12 16:34:31', '0.0', '0.0', '547');
|
INSERT INTO `netio_state` VALUES ('1580114913534279680', '192.168.0.108', '62.0', '65.33', '14.23', '9.74', '2022-10-12 16:35:00', '0.0', '0.0', '491');
|
INSERT INTO `netio_state` VALUES ('1580115400027406336', '192.168.0.108', '8.33', '13.33', '3.51', '1.29', '2022-10-12 16:36:59', '0.0', '0.0', '398');
|
INSERT INTO `netio_state` VALUES ('1580115886587641856', '192.168.0.108', '11.33', '12.67', '2.25', '1.63', '2022-10-12 16:38:59', '0.0', '0.0', '389');
|
INSERT INTO `netio_state` VALUES ('1580116373126905856', '192.168.0.108', '9.67', '12.33', '1.63', '1.03', '2022-10-12 16:40:59', '0.0', '0.0', '395');
|
INSERT INTO `netio_state` VALUES ('1580116859674558464', '192.168.0.108', '185.33', '72.67', '225.69', '13.12', '2022-10-12 16:42:59', '0.0', '0.0', '446');
|
INSERT INTO `netio_state` VALUES ('1580117346180268032', '192.168.0.108', '295.67', '178.67', '322.65', '41.23', '2022-10-12 16:44:59', '0.0', '0.0', '429');
|
INSERT INTO `netio_state` VALUES ('1580117832694366208', '192.168.0.108', '19.67', '21.67', '2.36', '9.19', '2022-10-12 16:46:59', '0.0', '0.0', '405');
|
INSERT INTO `netio_state` VALUES ('1580118319233630208', '192.168.0.108', '6.33', '6.0', '1.14', '1.16', '2022-10-12 16:48:59', '0.0', '0.0', '416');
|
INSERT INTO `netio_state` VALUES ('1580118903751835648', '192.168.0.108', '5.33', '4.67', '1.61', '1.31', '2022-10-12 16:50:59', '0.0', '0.0', '401');
|
|
-- ----------------------------
|
-- Table structure for ospf_info
|
-- ----------------------------
|
DROP TABLE IF EXISTS `ospf_info`;
|
CREATE TABLE `ospf_info` (
|
`ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
`HOST_NAME` char(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`INFO_CONTENT` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
|
`STATE` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`CREATE_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
`AREA_NUM` char(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`MONITOR_ID` char(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`MONITOR_IP` char(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`MONITOR_USERNAME` char(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`MONITOR_PASSWORD` char(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
PRIMARY KEY (`ID`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of ospf_info
|
-- ----------------------------
|
INSERT INTO `ospf_info` VALUES ('1984796042100604928', '192.168.0.24', '栾城北国', NULL, '2025-11-02 09:33:46', NULL, NULL, NULL, NULL, NULL);
|
INSERT INTO `ospf_info` VALUES ('1984797190165495808', '192.168.1.56', '正定核心', NULL, '2025-11-02 09:38:20', NULL, NULL, NULL, NULL, NULL);
|
INSERT INTO `ospf_info` VALUES ('1984797911589978112', '192.168.3.21', '交换机02', NULL, '2025-11-02 09:41:12', NULL, NULL, NULL, NULL, NULL);
|
INSERT INTO `ospf_info` VALUES ('1984799156094500864', '192.168.4.52', '测试', NULL, '2025-11-02 09:46:09', '', '1995486712243027968', '192.168.0.2', 'admin', 'admin');
|
INSERT INTO `ospf_info` VALUES ('1984800382022451200', '192.168.6.35', '交换机03', NULL, '2025-11-02 09:51:01', '6', '1995474620278505472', '192.168.0.1', 'adminbg', 'admin');
|
|
-- ----------------------------
|
-- Table structure for ospf_monitor
|
-- ----------------------------
|
DROP TABLE IF EXISTS `ospf_monitor`;
|
CREATE TABLE `ospf_monitor` (
|
`ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
`HOST_NAME` char(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`INFO_CONTENT` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
|
`STATE` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`CREATE_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
`USERNAME` char(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`PASSWORD` char(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
PRIMARY KEY (`ID`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of ospf_monitor
|
-- ----------------------------
|
INSERT INTO `ospf_monitor` VALUES ('1995474620278505472', '192.168.0.1', '核心交换01', NULL, '2025-12-01 20:46:38', 'adminbg', 'admin');
|
INSERT INTO `ospf_monitor` VALUES ('1995486712243027968', '192.168.0.2', '核心02', NULL, '2025-12-01 21:34:41', 'admin', 'admin');
|
|
-- ----------------------------
|
-- Table structure for port_info
|
-- ----------------------------
|
DROP TABLE IF EXISTS `port_info`;
|
CREATE TABLE `port_info` (
|
`ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
`PORT` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`PORT_NAME` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`STATE` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`CREATE_TIME` timestamp NULL DEFAULT NULL,
|
`HOST_NAME` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`ACTIVE` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`TELNET_IP` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`GROUP_ID` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
PRIMARY KEY (`ID`) USING BTREE,
|
INDEX `PORT_HOST_NAME_INDEX`(`HOST_NAME` ASC) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of port_info
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for shell_info
|
-- ----------------------------
|
DROP TABLE IF EXISTS `shell_info`;
|
CREATE TABLE `shell_info` (
|
`ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
`SHELL` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`CREATE_TIME` timestamp NULL DEFAULT NULL,
|
`STATE` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`SHELL_NAME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`SHELL_TYPE` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`SHELL_TIME` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`SHELL_DAY` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`ACCOUNT` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
PRIMARY KEY (`ID`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of shell_info
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for shell_state
|
-- ----------------------------
|
DROP TABLE IF EXISTS `shell_state`;
|
CREATE TABLE `shell_state` (
|
`ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
`SHELL_ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`HOST_NAME` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`CREATE_TIME` timestamp NULL DEFAULT NULL,
|
`STATE` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`SHELL` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`SHELL_TIME` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
PRIMARY KEY (`ID`) USING BTREE,
|
INDEX `SHELL_STATE_INDEX2`(`SHELL_ID` ASC) USING BTREE,
|
INDEX `SHELL_STATE_INDEX1`(`HOST_NAME` ASC) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of shell_state
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for snmp_info
|
-- ----------------------------
|
DROP TABLE IF EXISTS `snmp_info`;
|
CREATE TABLE `snmp_info` (
|
`ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
`HOST_NAME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`BYTES_RECV` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`BYTES_SENT` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`RECV_AVG` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`SENT_AVG` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`STATE` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`ACTIVE` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`CREATE_TIME` timestamp NULL DEFAULT NULL,
|
`SNMP_UNIT` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`REMARK` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`RECV_OID` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`SENT_OID` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`SNMP_COMMUNITY` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`SNMP_PORT` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`SNMP_VERSION` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`ACCOUNT` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`CPU_PER_OID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`MEM_SIZE_OID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`MEM_TOTAL_SIZE_OID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`CPU_PER` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`MEM_PER` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`INTERFACE_STATUS_OID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`ACTUAL_SPEED_OID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`WORK_MTU_OID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`ACTUAL_MTU_OID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`LOOPBACK_OID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`DESCRIPTION_OID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`INTERFACE_NAME_OID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
PRIMARY KEY (`ID`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of snmp_info
|
-- ----------------------------
|
INSERT INTO `snmp_info` VALUES ('1596048254674534400', '192.168.3.150', '204', '216', '0.0', '0.0', '1', '1', '2022-12-05 18:07:22', 'byte', 'F1060', '1.3.6.1.2.1.2.2.1.10.1\r\n1.3.6.1.2.1.2.2.1.10.2', '1.3.6.1.2.1.2.2.1.16.1\r\n1.3.6.1.2.1.2.2.1.16.2', 'public', '161', '1', NULL, '1.3.6.1.4.1.25506.2.6.1.1.1.1.6.25', '1.3.6.1.4.1.25506.2.6.1.1.1.1.8.25', '', '96.0', '0', '1.3.6.1.2.1.2.2.1.8', '1.3.6.1.2.1.2.2.1.5', '', '1.3.6.1.2.1.10.7.2.1.19', '1.3.6.1.4.1.25506.2.95.2.3.0', '1.3.6.1.2.1.2.2.1.2', '1.3.6.1.2.1.31.1.1.1.1');
|
|
-- ----------------------------
|
-- Table structure for snmp_interface_info
|
-- ----------------------------
|
DROP TABLE IF EXISTS `snmp_interface_info`;
|
CREATE TABLE `snmp_interface_info` (
|
`ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
`CREATE_TIME` timestamp NULL DEFAULT NULL,
|
`HOST_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`INTERFACE_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`IS_UP` int NULL DEFAULT NULL COMMENT '1/启用 2/未启用',
|
`INET_ADDRESS_IPV4_MASK` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'ip',
|
`ACTUAL_SPEED` int NULL DEFAULT NULL COMMENT '速率',
|
`WORK_MTU` int NULL DEFAULT NULL COMMENT '工作模式',
|
`ACTUAL_MTU` int NULL DEFAULT NULL COMMENT '双工模式',
|
`LOOPBACK` int NULL DEFAULT NULL COMMENT '环回检测',
|
`DESCRIPTION` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
PRIMARY KEY (`ID`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of snmp_interface_info
|
-- ----------------------------
|
INSERT INTO `snmp_interface_info` VALUES ('1597537593627639808', '2022-11-29 18:26:58', '192.168.8.150', 'GigabitEthernet1/0/0', 1, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/0');
|
INSERT INTO `snmp_interface_info` VALUES ('1597537593627639809', '2022-11-29 18:26:58', '192.168.8.150', 'GigabitEthernet1/0/1', 2, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/1');
|
INSERT INTO `snmp_interface_info` VALUES ('1597537593627639810', '2022-11-29 18:26:58', '192.168.8.150', 'GigabitEthernet1/0/2', 1, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/2');
|
INSERT INTO `snmp_interface_info` VALUES ('1597537593627639811', '2022-11-29 18:26:58', '192.168.8.150', 'GigabitEthernet1/0/3', 2, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/3');
|
INSERT INTO `snmp_interface_info` VALUES ('1597537593627639812', '2022-11-29 18:26:58', '192.168.8.150', 'GigabitEthernet1/0/4', 2, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/4');
|
INSERT INTO `snmp_interface_info` VALUES ('1597537593627639813', '2022-11-29 18:26:58', '192.168.8.150', 'GigabitEthernet1/0/5', 2, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/5');
|
INSERT INTO `snmp_interface_info` VALUES ('1597537593627639814', '2022-11-29 18:26:58', '192.168.8.150', 'GigabitEthernet1/0/6', 2, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/6');
|
INSERT INTO `snmp_interface_info` VALUES ('1597537593627639815', '2022-11-29 18:26:58', '192.168.8.150', 'GigabitEthernet1/0/7', 2, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/7');
|
INSERT INTO `snmp_interface_info` VALUES ('1597537593627639816', '2022-11-29 18:26:58', '192.168.8.150', 'GigabitEthernet1/0/8', 2, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/8');
|
INSERT INTO `snmp_interface_info` VALUES ('1597537593627639817', '2022-11-29 18:26:58', '192.168.8.150', 'GigabitEthernet1/0/9', 2, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/9');
|
INSERT INTO `snmp_interface_info` VALUES ('1597537593627639818', '2022-11-29 18:26:58', '192.168.8.150', 'GigabitEthernet1/0/10', 2, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/10');
|
INSERT INTO `snmp_interface_info` VALUES ('1597537593627639819', '2022-11-29 18:26:58', '192.168.8.150', 'GigabitEthernet1/0/11', 2, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/11');
|
INSERT INTO `snmp_interface_info` VALUES ('1597537593627639820', '2022-11-29 18:26:58', '192.168.8.150', 'GigabitEthernet1/0/12', 2, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/12');
|
INSERT INTO `snmp_interface_info` VALUES ('1597537593627639821', '2022-11-29 18:26:58', '192.168.8.150', 'GigabitEthernet1/0/13', 2, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/13');
|
INSERT INTO `snmp_interface_info` VALUES ('1597537593627639822', '2022-11-29 18:26:58', '192.168.8.150', 'GigabitEthernet1/0/14', 2, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/14');
|
INSERT INTO `snmp_interface_info` VALUES ('1597537593627639823', '2022-11-29 18:26:58', '192.168.8.150', 'GigabitEthernet1/0/15', 2, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/15');
|
INSERT INTO `snmp_interface_info` VALUES ('1597537593627639824', '2022-11-29 18:26:58', '192.168.8.150', 'GigabitEthernet1/0/16', 2, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/16');
|
INSERT INTO `snmp_interface_info` VALUES ('1597537593627639825', '2022-11-29 18:26:58', '192.168.8.150', 'GigabitEthernet1/0/17', 2, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/17');
|
INSERT INTO `snmp_interface_info` VALUES ('1597537593627639826', '2022-11-29 18:26:58', '192.168.8.150', 'GigabitEthernet1/0/18', 2, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/18');
|
INSERT INTO `snmp_interface_info` VALUES ('1597537593627639827', '2022-11-29 18:26:58', '192.168.8.150', 'GigabitEthernet1/0/19', 2, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/19');
|
INSERT INTO `snmp_interface_info` VALUES ('1597537593627639828', '2022-11-29 18:26:58', '192.168.8.150', 'GigabitEthernet1/0/20', 2, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/20');
|
INSERT INTO `snmp_interface_info` VALUES ('1597537593627639829', '2022-11-29 18:26:58', '192.168.8.150', 'GigabitEthernet1/0/21', 2, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/21');
|
INSERT INTO `snmp_interface_info` VALUES ('1597537593627639830', '2022-11-29 18:26:58', '192.168.8.150', 'GigabitEthernet1/0/22', 2, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/22');
|
INSERT INTO `snmp_interface_info` VALUES ('1597537593627639831', '2022-11-29 18:26:58', '192.168.8.150', 'GigabitEthernet1/0/23', 2, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/23');
|
INSERT INTO `snmp_interface_info` VALUES ('1597537593627639832', '2022-11-29 18:26:58', '192.168.8.150', 'NULL0', 1, NULL, 1000000000, NULL, NULL, NULL, 'NULL0');
|
INSERT INTO `snmp_interface_info` VALUES ('1597537593627639833', '2022-11-29 18:26:58', '192.168.8.150', 'InLoopBack0', 1, NULL, 0, NULL, NULL, NULL, 'InLoopBack0');
|
INSERT INTO `snmp_interface_info` VALUES ('1597537593627639834', '2022-11-29 18:26:58', '192.168.8.150', 'Register-Tunnel0', 1, NULL, 0, NULL, NULL, NULL, 'Register-Tunnel0');
|
INSERT INTO `snmp_interface_info` VALUES ('1599707004006432768', '2022-12-05 18:07:26', '192.168.3.150', 'GigabitEthernet1/0/0', 1, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/0');
|
INSERT INTO `snmp_interface_info` VALUES ('1599707004006432769', '2022-12-05 18:07:26', '192.168.3.150', 'GigabitEthernet1/0/1', 2, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/1');
|
INSERT INTO `snmp_interface_info` VALUES ('1599707004006432770', '2022-12-05 18:07:26', '192.168.3.150', 'GigabitEthernet1/0/2', 1, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/2');
|
INSERT INTO `snmp_interface_info` VALUES ('1599707004006432771', '2022-12-05 18:07:26', '192.168.3.150', 'GigabitEthernet1/0/3', 2, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/3');
|
INSERT INTO `snmp_interface_info` VALUES ('1599707004006432772', '2022-12-05 18:07:26', '192.168.3.150', 'GigabitEthernet1/0/4', 2, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/4');
|
INSERT INTO `snmp_interface_info` VALUES ('1599707004006432773', '2022-12-05 18:07:26', '192.168.3.150', 'GigabitEthernet1/0/5', 2, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/5');
|
INSERT INTO `snmp_interface_info` VALUES ('1599707004006432774', '2022-12-05 18:07:26', '192.168.3.150', 'GigabitEthernet1/0/6', 2, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/6');
|
INSERT INTO `snmp_interface_info` VALUES ('1599707004006432775', '2022-12-05 18:07:26', '192.168.3.150', 'GigabitEthernet1/0/7', 2, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/7');
|
INSERT INTO `snmp_interface_info` VALUES ('1599707004006432776', '2022-12-05 18:07:26', '192.168.3.150', 'GigabitEthernet1/0/8', 2, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/8');
|
INSERT INTO `snmp_interface_info` VALUES ('1599707004006432777', '2022-12-05 18:07:26', '192.168.3.150', 'GigabitEthernet1/0/9', 2, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/9');
|
INSERT INTO `snmp_interface_info` VALUES ('1599707004006432778', '2022-12-05 18:07:26', '192.168.3.150', 'GigabitEthernet1/0/10', 2, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/10');
|
INSERT INTO `snmp_interface_info` VALUES ('1599707004006432779', '2022-12-05 18:07:26', '192.168.3.150', 'GigabitEthernet1/0/11', 2, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/11');
|
INSERT INTO `snmp_interface_info` VALUES ('1599707004006432780', '2022-12-05 18:07:26', '192.168.3.150', 'GigabitEthernet1/0/12', 2, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/12');
|
INSERT INTO `snmp_interface_info` VALUES ('1599707004006432781', '2022-12-05 18:07:26', '192.168.3.150', 'GigabitEthernet1/0/13', 2, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/13');
|
INSERT INTO `snmp_interface_info` VALUES ('1599707004006432782', '2022-12-05 18:07:26', '192.168.3.150', 'GigabitEthernet1/0/14', 2, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/14');
|
INSERT INTO `snmp_interface_info` VALUES ('1599707004006432783', '2022-12-05 18:07:26', '192.168.3.150', 'GigabitEthernet1/0/15', 2, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/15');
|
INSERT INTO `snmp_interface_info` VALUES ('1599707004006432784', '2022-12-05 18:07:26', '192.168.3.150', 'GigabitEthernet1/0/16', 2, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/16');
|
INSERT INTO `snmp_interface_info` VALUES ('1599707004006432785', '2022-12-05 18:07:26', '192.168.3.150', 'GigabitEthernet1/0/17', 2, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/17');
|
INSERT INTO `snmp_interface_info` VALUES ('1599707004006432786', '2022-12-05 18:07:26', '192.168.3.150', 'GigabitEthernet1/0/18', 2, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/18');
|
INSERT INTO `snmp_interface_info` VALUES ('1599707004006432787', '2022-12-05 18:07:26', '192.168.3.150', 'GigabitEthernet1/0/19', 2, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/19');
|
INSERT INTO `snmp_interface_info` VALUES ('1599707004006432788', '2022-12-05 18:07:26', '192.168.3.150', 'GigabitEthernet1/0/20', 2, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/20');
|
INSERT INTO `snmp_interface_info` VALUES ('1599707004006432789', '2022-12-05 18:07:26', '192.168.3.150', 'GigabitEthernet1/0/21', 2, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/21');
|
INSERT INTO `snmp_interface_info` VALUES ('1599707004006432790', '2022-12-05 18:07:26', '192.168.3.150', 'GigabitEthernet1/0/22', 2, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/22');
|
INSERT INTO `snmp_interface_info` VALUES ('1599707004006432791', '2022-12-05 18:07:26', '192.168.3.150', 'GigabitEthernet1/0/23', 2, NULL, 1000000000, NULL, 1, NULL, 'GigabitEthernet1/0/23');
|
INSERT INTO `snmp_interface_info` VALUES ('1599707004006432792', '2022-12-05 18:07:26', '192.168.3.150', 'NULL0', 1, NULL, 1000000000, NULL, NULL, NULL, 'NULL0');
|
INSERT INTO `snmp_interface_info` VALUES ('1599707004006432793', '2022-12-05 18:07:26', '192.168.3.150', 'InLoopBack0', 1, NULL, 0, NULL, NULL, NULL, 'InLoopBack0');
|
INSERT INTO `snmp_interface_info` VALUES ('1599707004006432794', '2022-12-05 18:07:26', '192.168.3.150', 'Register-Tunnel0', 1, NULL, 0, NULL, NULL, NULL, 'Register-Tunnel0');
|
|
-- ----------------------------
|
-- Table structure for snmp_state
|
-- ----------------------------
|
DROP TABLE IF EXISTS `snmp_state`;
|
CREATE TABLE `snmp_state` (
|
`ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
`SNMP_INFO_ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`RECV_AVG` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`SENT_AVG` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`CPU_PER` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`MEM_PER` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`CREATE_TIME` timestamp NULL DEFAULT NULL,
|
PRIMARY KEY (`ID`) USING BTREE,
|
INDEX `SNMP_ID_CREATE_TIME`(`SNMP_INFO_ID` ASC, `CREATE_TIME` ASC) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of snmp_state
|
-- ----------------------------
|
INSERT INTO `snmp_state` VALUES ('1596051294978703360', '1596048254674534400', '0.0', '0.0', '0', '0', '2022-11-25 16:00:44');
|
INSERT INTO `snmp_state` VALUES ('1596056403636781056', '1596048254674534400', '0.0', '0.0', '0', '0', '2022-11-25 16:20:44');
|
INSERT INTO `snmp_state` VALUES ('1596061390668431360', '1596048254674534400', '0.0', '0.0', '0', '0', '2022-11-25 16:40:44');
|
INSERT INTO `snmp_state` VALUES ('1596066377700081664', '1596048254674534400', '0.0', '0.0', '0', '0', '2022-11-25 17:00:44');
|
INSERT INTO `snmp_state` VALUES ('1596071486353965056', '1596048254674534400', '0.0', '0.0', '0', '0', '2022-11-25 17:20:44');
|
INSERT INTO `snmp_state` VALUES ('1596076473385615360', '1596048254674534400', '0.0', '0.0', '0', '0', '2022-11-25 17:40:44');
|
INSERT INTO `snmp_state` VALUES ('1596081460408877056', '1596048254674534400', '0.0', '0.0', '0', '0', '2022-11-25 18:00:44');
|
INSERT INTO `snmp_state` VALUES ('1596682446156464128', '1596048254674534400', '0.0', '0.0', '0', '0', '2022-11-27 09:48:31');
|
INSERT INTO `snmp_state` VALUES ('1596684005934235648', '1596048254674534400', '0.0', '0.0', '0', '0', '2022-11-27 09:54:43');
|
INSERT INTO `snmp_state` VALUES ('1596688992957497344', '1596048254674534400', '0', '0', '0', '0', '2022-11-27 10:14:43');
|
INSERT INTO `snmp_state` VALUES ('1596694101623963648', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-11-27 10:34:43');
|
INSERT INTO `snmp_state` VALUES ('1596699142229458944', '1596048254674534400', '0.0', '0.0', '97.0', '0', '2022-11-27 10:54:51');
|
INSERT INTO `snmp_state` VALUES ('1596704129252720640', '1596048254674534400', '0.0', '0.0', '97.0', '0', '2022-11-27 11:14:51');
|
INSERT INTO `snmp_state` VALUES ('1596709237919186944', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-11-27 11:34:51');
|
INSERT INTO `snmp_state` VALUES ('1596714224946642944', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-11-27 11:54:51');
|
INSERT INTO `snmp_state` VALUES ('1596719211974098944', '1596048254674534400', '0.0', '0.0', '95.0', '0', '2022-11-27 12:14:51');
|
INSERT INTO `snmp_state` VALUES ('1596724320632176640', '1596048254674534400', '0.0', '0.0', '95.0', '0', '2022-11-27 12:34:51');
|
INSERT INTO `snmp_state` VALUES ('1596729307659632640', '1596048254674534400', '0.0', '0.0', '95.0', '0', '2022-11-27 12:54:51');
|
INSERT INTO `snmp_state` VALUES ('1596734294695477248', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-11-27 13:14:51');
|
INSERT INTO `snmp_state` VALUES ('1596739403349360640', '1596048254674534400', '0.0', '0.0', '97.0', '0', '2022-11-27 13:34:51');
|
INSERT INTO `snmp_state` VALUES ('1596744390381010944', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-11-27 13:54:51');
|
INSERT INTO `snmp_state` VALUES ('1596749499043282944', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-11-27 14:14:51');
|
INSERT INTO `snmp_state` VALUES ('1596754486070738944', '1596048254674534400', '0.0', '0.0', '97.0', '0', '2022-11-27 14:34:51');
|
INSERT INTO `snmp_state` VALUES ('1596759473102389248', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-11-27 14:54:51');
|
INSERT INTO `snmp_state` VALUES ('1596764581756272640', '1596048254674534400', '0.0', '0.0', '97.0', '0', '2022-11-27 15:14:51');
|
INSERT INTO `snmp_state` VALUES ('1596769568796311552', '1596048254674534400', '0.0', '0.0', '97.0', '0', '2022-11-27 15:34:51');
|
INSERT INTO `snmp_state` VALUES ('1596774555811184640', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-11-27 15:54:51');
|
INSERT INTO `snmp_state` VALUES ('1596779664477650944', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-11-27 16:14:51');
|
INSERT INTO `snmp_state` VALUES ('1596784651500912640', '1596048254674534400', '0.0', '0.0', '97.0', '0', '2022-11-27 16:34:51');
|
INSERT INTO `snmp_state` VALUES ('1596789760163184640', '1596048254674534400', '0.0', '0.0', '97.0', '0', '2022-11-27 16:54:51');
|
INSERT INTO `snmp_state` VALUES ('1596794747190640640', '1596048254674534400', '0.0', '0.0', '97.0', '0', '2022-11-27 17:14:51');
|
INSERT INTO `snmp_state` VALUES ('1596799734218096640', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-11-27 17:34:51');
|
INSERT INTO `snmp_state` VALUES ('1596804842880368640', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-11-27 17:54:51');
|
INSERT INTO `snmp_state` VALUES ('1596809829916213248', '1596048254674534400', '0.0', '0.0', '97.0', '0', '2022-11-27 18:14:51');
|
INSERT INTO `snmp_state` VALUES ('1596814938574290944', '1596048254674534400', '0.0', '0.0', '97.0', '0', '2022-11-27 18:34:51');
|
INSERT INTO `snmp_state` VALUES ('1596819925605941248', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-11-27 18:54:51');
|
INSERT INTO `snmp_state` VALUES ('1596824912633397248', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-11-27 19:14:51');
|
INSERT INTO `snmp_state` VALUES ('1596830021291474944', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-11-27 19:34:51');
|
INSERT INTO `snmp_state` VALUES ('1596833562877886464', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-11-27 19:49:00');
|
INSERT INTO `snmp_state` VALUES ('1596836173932789760', '1596048254674534400', '0.0', '0.0', '97.0', '0', '2022-11-27 19:59:22');
|
INSERT INTO `snmp_state` VALUES ('1596838807804706816', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-11-27 20:09:50');
|
INSERT INTO `snmp_state` VALUES ('1596841890546843648', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-11-27 20:22:05');
|
INSERT INTO `snmp_state` VALUES ('1596851666559303680', '1596048254674534400', '0.0', '0.0', '99.0', '0', '2022-11-27 21:00:56');
|
INSERT INTO `snmp_state` VALUES ('1596854274221015040', '1596048254674534400', '0.0', '0.0', '99.0', '0', '2022-11-27 21:11:18');
|
INSERT INTO `snmp_state` VALUES ('1596859261252665344', '1596048254674534400', '0.0', '0.0', '99.0', '0', '2022-11-27 21:31:18');
|
INSERT INTO `snmp_state` VALUES ('1596860385280000000', '1596048254674534400', '0.0', '0.0', '99.0', '0', '2022-11-27 21:35:35');
|
INSERT INTO `snmp_state` VALUES ('1596865631016321024', '1596048254674534400', '0.0', '0.0', '99.0', '0', '2022-11-27 21:56:25');
|
INSERT INTO `snmp_state` VALUES ('1596867982888402944', '1596048254674534400', '0.0', '0.0', '99.0', '0', '2022-11-27 22:05:46');
|
INSERT INTO `snmp_state` VALUES ('1597407667297583104', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-11-29 09:50:17');
|
INSERT INTO `snmp_state` VALUES ('1597412654329233408', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-11-29 10:10:17');
|
INSERT INTO `snmp_state` VALUES ('1597417762987311104', '1596048254674534400', '0.0', '0.0', '95.0', '0', '2022-11-29 10:30:17');
|
INSERT INTO `snmp_state` VALUES ('1597419309267812352', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-11-29 10:36:33');
|
INSERT INTO `snmp_state` VALUES ('1597421237246754816', '1596048254674534400', '0.0', '0.0', '95.0', '0', '2022-11-29 10:44:12');
|
INSERT INTO `snmp_state` VALUES ('1597422344043888640', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-11-29 10:48:36');
|
INSERT INTO `snmp_state` VALUES ('1597427331075538944', '1596048254674534400', '0.0', '0.0', '95.0', '0', '2022-11-29 11:08:36');
|
INSERT INTO `snmp_state` VALUES ('1597429862526746624', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-11-29 11:18:29');
|
INSERT INTO `snmp_state` VALUES ('1597431478680158208', '1596048254674534400', '0.0', '0.0', '95.0', '0', '2022-11-29 11:24:54');
|
INSERT INTO `snmp_state` VALUES ('1597435463826800640', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-11-29 11:40:44');
|
INSERT INTO `snmp_state` VALUES ('1597436323294216192', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-11-29 11:44:09');
|
INSERT INTO `snmp_state` VALUES ('1597441310309089280', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-11-29 12:04:09');
|
INSERT INTO `snmp_state` VALUES ('1597442163615072256', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-11-29 12:07:22');
|
INSERT INTO `snmp_state` VALUES ('1597447150650916864', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-11-29 12:27:22');
|
INSERT INTO `snmp_state` VALUES ('1597452259313188864', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-11-29 12:47:22');
|
INSERT INTO `snmp_state` VALUES ('1597457246340644864', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-11-29 13:07:22');
|
INSERT INTO `snmp_state` VALUES ('1597462233359712256', '1596048254674534400', '0.0', '0.0', '93.0', '0', '2022-11-29 13:27:22');
|
INSERT INTO `snmp_state` VALUES ('1597467342026178560', '1596048254674534400', '0.0', '0.0', '100.0', '0', '2022-11-29 13:47:22');
|
INSERT INTO `snmp_state` VALUES ('1597472329057828864', '1596048254674534400', '0.0', '0.0', '95.0', '0', '2022-11-29 14:07:22');
|
INSERT INTO `snmp_state` VALUES ('1597477316076896256', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-11-29 14:27:22');
|
INSERT INTO `snmp_state` VALUES ('1597482424747556864', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-11-29 14:47:22');
|
INSERT INTO `snmp_state` VALUES ('1597487411775012864', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-11-29 15:07:22');
|
INSERT INTO `snmp_state` VALUES ('1597492520433090560', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-11-29 15:27:22');
|
INSERT INTO `snmp_state` VALUES ('1597497507464740864', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-11-29 15:47:22');
|
INSERT INTO `snmp_state` VALUES ('1597498569684811776', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-11-29 15:51:30');
|
INSERT INTO `snmp_state` VALUES ('1597499478762455040', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-11-29 15:55:06');
|
INSERT INTO `snmp_state` VALUES ('1597504049337466880', '1596048254674534400', '0.0', '0.0', '95.0', '0', '2022-11-29 16:13:16');
|
INSERT INTO `snmp_state` VALUES ('1597509036356534272', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-11-29 16:33:16');
|
INSERT INTO `snmp_state` VALUES ('1597511959627038720', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-11-29 16:44:42');
|
INSERT INTO `snmp_state` VALUES ('1597517548771999744', '1596048254674534400', '0.0', '0.0', '95.0', '0', '2022-11-29 17:06:55');
|
INSERT INTO `snmp_state` VALUES ('1597522535799455744', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-11-29 17:26:55');
|
INSERT INTO `snmp_state` VALUES ('1597527644465922048', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-11-29 17:46:55');
|
INSERT INTO `snmp_state` VALUES ('1597532631493378048', '1596048254674534400', '0.0', '0.0', '97.0', '0', '2022-11-29 18:06:55');
|
INSERT INTO `snmp_state` VALUES ('1597537618516639744', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-11-29 18:26:55');
|
INSERT INTO `snmp_state` VALUES ('1599586249591619584', '1596048254674534400', '0.0', '0.0', '94.0', '0', '2022-12-05 10:07:22');
|
INSERT INTO `snmp_state` VALUES ('1599591358253891584', '1596048254674534400', '0.0', '0.0', '95.0', '0', '2022-12-05 10:27:22');
|
INSERT INTO `snmp_state` VALUES ('1599596345310707712', '1596048254674534400', '0.0', '0.0', '95.0', '0', '2022-12-05 10:47:22');
|
INSERT INTO `snmp_state` VALUES ('1599601332308803584', '1596048254674534400', '0.0', '0.0', '95.0', '0', '2022-12-05 11:07:22');
|
INSERT INTO `snmp_state` VALUES ('1599606440966881280', '1596048254674534400', '0.0', '0.0', '95.0', '0', '2022-12-05 11:27:22');
|
INSERT INTO `snmp_state` VALUES ('1599611427994337280', '1596048254674534400', '0.0', '0.0', '95.0', '0', '2022-12-05 11:47:22');
|
INSERT INTO `snmp_state` VALUES ('1599616415025987584', '1596048254674534400', '0.0', '0.0', '95.0', '0', '2022-12-05 12:07:22');
|
INSERT INTO `snmp_state` VALUES ('1599621523684065280', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-12-05 12:27:22');
|
INSERT INTO `snmp_state` VALUES ('1599626510711521280', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-12-05 12:47:22');
|
INSERT INTO `snmp_state` VALUES ('1599631619373793280', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-12-05 13:07:22');
|
INSERT INTO `snmp_state` VALUES ('1599636606401249280', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-12-05 13:27:22');
|
INSERT INTO `snmp_state` VALUES ('1599641593432899584', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-12-05 13:47:22');
|
INSERT INTO `snmp_state` VALUES ('1599646702095171584', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-12-05 14:07:22');
|
INSERT INTO `snmp_state` VALUES ('1599651689118433280', '1596048254674534400', '0.0', '0.0', '95.0', '0', '2022-12-05 14:27:22');
|
INSERT INTO `snmp_state` VALUES ('1599656676150083584', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-12-05 14:47:22');
|
INSERT INTO `snmp_state` VALUES ('1599661784808161280', '1596048254674534400', '0.0', '0.0', '95.0', '0', '2022-12-05 15:07:22');
|
INSERT INTO `snmp_state` VALUES ('1599666771835617280', '1596048254674534400', '0.0', '0.0', '95.0', '0', '2022-12-05 15:27:22');
|
INSERT INTO `snmp_state` VALUES ('1599671880497889280', '1596048254674534400', '0.0', '0.0', '95.0', '0', '2022-12-05 15:47:22');
|
INSERT INTO `snmp_state` VALUES ('1599676867529539584', '1596048254674534400', '0.0', '0.0', '95.0', '0', '2022-12-05 16:07:22');
|
INSERT INTO `snmp_state` VALUES ('1599681854552801280', '1596048254674534400', '0.0', '0.0', '95.0', '0', '2022-12-05 16:27:22');
|
INSERT INTO `snmp_state` VALUES ('1599686963219267584', '1596048254674534400', '0.0', '0.0', '95.0', '0', '2022-12-05 16:47:22');
|
INSERT INTO `snmp_state` VALUES ('1599691950246723584', '1596048254674534400', '0.0', '0.0', '95.0', '0', '2022-12-05 17:07:22');
|
INSERT INTO `snmp_state` VALUES ('1599697058908995584', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-12-05 17:27:22');
|
INSERT INTO `snmp_state` VALUES ('1599702045932257280', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-12-05 17:47:22');
|
INSERT INTO `snmp_state` VALUES ('1599707032963907584', '1596048254674534400', '0.0', '0.0', '96.0', '0', '2022-12-05 18:07:22');
|
|
-- ----------------------------
|
-- Table structure for sys_load_state
|
-- ----------------------------
|
DROP TABLE IF EXISTS `sys_load_state`;
|
CREATE TABLE `sys_load_state` (
|
`ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
`HOST_NAME` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`ONE_LOAD` double(8, 2) NULL DEFAULT NULL,
|
`FIVE_LOAD` double(8, 2) NULL DEFAULT NULL,
|
`FIFTEEN_LOAD` double(8, 2) NULL DEFAULT NULL,
|
`USERS` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`CREATE_TIME` timestamp NULL DEFAULT NULL,
|
PRIMARY KEY (`ID`) USING BTREE,
|
INDEX `LOAD_ACC_HOST_INDEX`(`HOST_NAME` ASC, `CREATE_TIME` ASC) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of sys_load_state
|
-- ----------------------------
|
INSERT INTO `sys_load_state` VALUES ('1580113940644495360', '192.168.137.1', 0.00, 0.00, 0.00, NULL, '2022-10-12 16:31:30');
|
INSERT INTO `sys_load_state` VALUES ('1580114183767326720', '192.168.137.1', 0.00, 0.00, 0.00, NULL, '2022-10-12 16:32:27');
|
INSERT INTO `sys_load_state` VALUES ('1580114305339228160', '192.168.0.108', 0.00, 0.00, 0.00, NULL, '2022-10-12 16:32:59');
|
INSERT INTO `sys_load_state` VALUES ('1580114426969849856', '192.168.137.1', 3.64, 1.27, 0.47, NULL, '2022-10-12 16:33:29');
|
INSERT INTO `sys_load_state` VALUES ('1580114791920435200', '192.168.0.108', 0.00, 0.00, 0.00, NULL, '2022-10-12 16:34:31');
|
INSERT INTO `sys_load_state` VALUES ('1580114913555251200', '192.168.0.108', 0.00, 0.00, 0.00, NULL, '2022-10-12 16:35:00');
|
INSERT INTO `sys_load_state` VALUES ('1580115400039989248', '192.168.0.108', 0.12, 0.06, 0.03, NULL, '2022-10-12 16:36:59');
|
INSERT INTO `sys_load_state` VALUES ('1580115886600224768', '192.168.0.108', 0.07, 0.08, 0.04, NULL, '2022-10-12 16:38:59');
|
INSERT INTO `sys_load_state` VALUES ('1580116373160460288', '192.168.0.108', 0.03, 0.07, 0.04, NULL, '2022-10-12 16:40:59');
|
INSERT INTO `sys_load_state` VALUES ('1580116859699724288', '192.168.0.108', 0.08, 0.07, 0.04, NULL, '2022-10-12 16:42:59');
|
INSERT INTO `sys_load_state` VALUES ('1580117346188656640', '192.168.0.108', 0.83, 0.32, 0.14, NULL, '2022-10-12 16:44:59');
|
INSERT INTO `sys_load_state` VALUES ('1580117832706949120', '192.168.0.108', 0.36, 0.29, 0.15, NULL, '2022-10-12 16:46:59');
|
INSERT INTO `sys_load_state` VALUES ('1580118319246213120', '192.168.0.108', 0.21, 0.24, 0.15, NULL, '2022-10-12 16:48:59');
|
INSERT INTO `sys_load_state` VALUES ('1580118903764418560', '192.168.0.108', 1.50, 0.47, 0.23, NULL, '2022-10-12 16:50:59');
|
|
-- ----------------------------
|
-- Table structure for system_info
|
-- ----------------------------
|
DROP TABLE IF EXISTS `system_info`;
|
CREATE TABLE `system_info` (
|
`ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
`HOST_NAME` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`PLATFORM` char(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`CPU_PER` double(8, 2) NULL DEFAULT NULL,
|
`MEM_PER` double(8, 2) NULL DEFAULT NULL,
|
`CPU_CORE_NUM` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`CREATE_TIME` timestamp NULL DEFAULT NULL,
|
`CPU_XH` char(150) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`STATE` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`BOOT_TIME` bigint NULL DEFAULT NULL,
|
`PROCS` char(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`PLATFORM_VERSION` char(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`UPTIME` bigint NULL DEFAULT NULL,
|
`GROUP_ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`REMARK` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`TOTAL_MEM` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`SUBMIT_SECONDS` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`AGENT_VER` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`BYTES_RECV` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`BYTES_SENT` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`RXBYT` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`TXBYT` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`WIN_CONSOLE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`HOST_NAME_EXT` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`FIVE_LOAD` double(8, 2) NULL DEFAULT NULL,
|
`FIFTEEN_LOAD` double(8, 2) NULL DEFAULT NULL,
|
`NET_CONNECTIONS` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`SWAP_MEM_PER` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`TOTAL_SWAP_MEM` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`ACCOUNT` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
PRIMARY KEY (`ID`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of system_info
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for tcp_state
|
-- ----------------------------
|
DROP TABLE IF EXISTS `tcp_state`;
|
CREATE TABLE `tcp_state` (
|
`ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
`HOST_NAME` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`ACTIVE` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`PASSIVE` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`RETRANS` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`DATE_STR` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`CREATE_TIME` timestamp NULL DEFAULT NULL,
|
PRIMARY KEY (`ID`) USING BTREE,
|
INDEX `TCP_ACC_HOST_INDEX`(`HOST_NAME` ASC, `CREATE_TIME` ASC) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of tcp_state
|
-- ----------------------------
|
|
SET FOREIGN_KEY_CHECKS = 1;
|
