259 lines
10 KiB
SQL
259 lines
10 KiB
SQL
/*
|
|
Navicat Premium Data Transfer
|
|
|
|
Source Server : 192.168.4.95
|
|
Source Server Type : MySQL
|
|
Source Server Version : 100621 (10.6.21-MariaDB-0ubuntu0.22.04.2)
|
|
Source Host : 192.168.4.95:3306
|
|
Source Schema : APM_DB
|
|
|
|
Target Server Type : MySQL
|
|
Target Server Version : 100621 (10.6.21-MariaDB-0ubuntu0.22.04.2)
|
|
File Encoding : 65001
|
|
|
|
Date: 17/06/2025 16:15:29
|
|
*/
|
|
|
|
SET NAMES utf8mb4;
|
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for amfApmData
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `amfApmData`;
|
|
CREATE TABLE `amfApmData` (
|
|
`sysNo` tinyint(1) NOT NULL DEFAULT 0,
|
|
`cpu_usage_amf` float NOT NULL DEFAULT 0,
|
|
`cpu_usage_sys` float NOT NULL DEFAULT 0,
|
|
`memsize_amf` int NOT NULL DEFAULT 0,
|
|
`memsize_sys` int NOT NULL DEFAULT 0,
|
|
`mem_usage_sys` float NOT NULL DEFAULT 0,
|
|
`disk_partition` int NOT NULL DEFAULT 1,
|
|
`partition1_total` int NOT NULL DEFAULT 0,
|
|
`partition1_used` int NOT NULL DEFAULT 0,
|
|
`partition2_total` int NOT NULL DEFAULT 0,
|
|
`partition2_used` int NOT NULL DEFAULT 0,
|
|
`partition3_total` int NOT NULL DEFAULT 0,
|
|
`partition3_used` int NOT NULL DEFAULT 0,
|
|
`partition4_total` int NOT NULL DEFAULT 0,
|
|
`partition4_used` int NOT NULL DEFAULT 0,
|
|
`apm_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
PRIMARY KEY (`sysNo`, `apm_datetime`) USING BTREE
|
|
) ENGINE = MyISAM CHARACTER SET = gb2312 COLLATE = gb2312_chinese_ci ROW_FORMAT = Fixed;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for ausfApmData
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `ausfApmData`;
|
|
CREATE TABLE `ausfApmData` (
|
|
`sysNo` tinyint(1) NOT NULL DEFAULT 0,
|
|
`cpu_usage_ausf` float NOT NULL DEFAULT 0,
|
|
`cpu_usage_sys` float NOT NULL DEFAULT 0,
|
|
`memsize_ausf` int NOT NULL DEFAULT 0,
|
|
`memsize_sys` int NOT NULL DEFAULT 0,
|
|
`mem_usage_sys` float NOT NULL DEFAULT 0,
|
|
`disk_partition` int NOT NULL DEFAULT 1,
|
|
`partition1_total` int NOT NULL DEFAULT 0,
|
|
`partition1_used` int NOT NULL DEFAULT 0,
|
|
`partition2_total` int NOT NULL DEFAULT 0,
|
|
`partition2_used` int NOT NULL DEFAULT 0,
|
|
`partition3_total` int NOT NULL DEFAULT 0,
|
|
`partition3_used` int NOT NULL DEFAULT 0,
|
|
`partition4_total` int NOT NULL DEFAULT 0,
|
|
`partition4_used` int NOT NULL DEFAULT 0,
|
|
`apm_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
PRIMARY KEY (`sysNo`, `apm_datetime`) USING BTREE
|
|
) ENGINE = MyISAM CHARACTER SET = gb2312 COLLATE = gb2312_chinese_ci ROW_FORMAT = Fixed;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for emsApmData
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `emsApmData`;
|
|
CREATE TABLE `emsApmData` (
|
|
`sysNo` tinyint(1) NOT NULL DEFAULT 0,
|
|
`cpu_usage_sys` float NOT NULL DEFAULT 0,
|
|
`memsize_sys` int NOT NULL DEFAULT 0,
|
|
`mem_usage_sys` float NOT NULL DEFAULT 0,
|
|
`disk_partition` int NOT NULL DEFAULT 1,
|
|
`partition1_total` int NOT NULL DEFAULT 0,
|
|
`partition1_used` int NOT NULL DEFAULT 0,
|
|
`partition2_total` int NOT NULL DEFAULT 0,
|
|
`partition2_used` int NOT NULL DEFAULT 0,
|
|
`partition3_total` int NOT NULL DEFAULT 0,
|
|
`partition3_used` int NOT NULL DEFAULT 0,
|
|
`partition4_total` int NOT NULL DEFAULT 0,
|
|
`partition4_used` int NOT NULL DEFAULT 0,
|
|
`apm_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
PRIMARY KEY (`sysNo`, `apm_datetime`) USING BTREE
|
|
) ENGINE = MyISAM CHARACTER SET = gb2312 COLLATE = gb2312_chinese_ci ROW_FORMAT = Fixed;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for imsApmData
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `imsApmData`;
|
|
CREATE TABLE `imsApmData` (
|
|
`sysNo` tinyint(1) NOT NULL DEFAULT 0,
|
|
`cpu_usage_ims` float NOT NULL DEFAULT 0,
|
|
`cpu_usage_sys` float NOT NULL DEFAULT 0,
|
|
`memsize_ims` int NOT NULL DEFAULT 0,
|
|
`memsize_sys` int NOT NULL DEFAULT 0,
|
|
`mem_usage_sys` float NOT NULL DEFAULT 0,
|
|
`disk_partition` int NOT NULL DEFAULT 1,
|
|
`partition1_total` int NOT NULL DEFAULT 0,
|
|
`partition1_used` int NOT NULL DEFAULT 0,
|
|
`partition2_total` int NOT NULL DEFAULT 0,
|
|
`partition2_used` int NOT NULL DEFAULT 0,
|
|
`partition3_total` int NOT NULL DEFAULT 0,
|
|
`partition3_used` int NOT NULL DEFAULT 0,
|
|
`partition4_total` int NOT NULL DEFAULT 0,
|
|
`partition4_used` int NOT NULL DEFAULT 0,
|
|
`apm_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
PRIMARY KEY (`sysNo`, `apm_datetime`) USING BTREE
|
|
) ENGINE = MyISAM CHARACTER SET = gb2312 COLLATE = gb2312_chinese_ci ROW_FORMAT = Fixed;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for nrfApmData
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `nrfApmData`;
|
|
CREATE TABLE `nrfApmData` (
|
|
`sysNo` tinyint(1) NOT NULL DEFAULT 0,
|
|
`cpu_usage_nrf` float NOT NULL DEFAULT 0,
|
|
`cpu_usage_sys` float NOT NULL DEFAULT 0,
|
|
`memsize_nrf` int NOT NULL DEFAULT 0,
|
|
`memsize_sys` int NOT NULL DEFAULT 0,
|
|
`mem_usage_sys` float NOT NULL DEFAULT 0,
|
|
`disk_partition` int NOT NULL DEFAULT 1,
|
|
`partition1_total` int NOT NULL DEFAULT 0,
|
|
`partition1_used` int NOT NULL DEFAULT 0,
|
|
`partition2_total` int NOT NULL DEFAULT 0,
|
|
`partition2_used` int NOT NULL DEFAULT 0,
|
|
`partition3_total` int NOT NULL DEFAULT 0,
|
|
`partition3_used` int NOT NULL DEFAULT 0,
|
|
`partition4_total` int NOT NULL DEFAULT 0,
|
|
`partition4_used` int NOT NULL DEFAULT 0,
|
|
`apm_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
PRIMARY KEY (`sysNo`, `apm_datetime`) USING BTREE
|
|
) ENGINE = MyISAM CHARACTER SET = gb2312 COLLATE = gb2312_chinese_ci ROW_FORMAT = Fixed;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for nssfApmData
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `nssfApmData`;
|
|
CREATE TABLE `nssfApmData` (
|
|
`sysNo` tinyint(1) NOT NULL DEFAULT 0,
|
|
`cpu_usage_nssf` float NOT NULL DEFAULT 0,
|
|
`cpu_usage_sys` float NOT NULL DEFAULT 0,
|
|
`memsize_nssf` int NOT NULL DEFAULT 0,
|
|
`memsize_sys` int NOT NULL DEFAULT 0,
|
|
`mem_usage_sys` float NOT NULL DEFAULT 0,
|
|
`disk_partition` int NOT NULL DEFAULT 1,
|
|
`partition1_total` int NOT NULL DEFAULT 0,
|
|
`partition1_used` int NOT NULL DEFAULT 0,
|
|
`partition2_total` int NOT NULL DEFAULT 0,
|
|
`partition2_used` int NOT NULL DEFAULT 0,
|
|
`partition3_total` int NOT NULL DEFAULT 0,
|
|
`partition3_used` int NOT NULL DEFAULT 0,
|
|
`partition4_total` int NOT NULL DEFAULT 0,
|
|
`partition4_used` int NOT NULL DEFAULT 0,
|
|
`apm_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
PRIMARY KEY (`sysNo`, `apm_datetime`) USING BTREE
|
|
) ENGINE = MyISAM CHARACTER SET = gb2312 COLLATE = gb2312_chinese_ci ROW_FORMAT = Fixed;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for pcfApmData
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `pcfApmData`;
|
|
CREATE TABLE `pcfApmData` (
|
|
`sysNo` tinyint(1) NOT NULL DEFAULT 0,
|
|
`cpu_usage_pcf` float NOT NULL DEFAULT 0,
|
|
`cpu_usage_sys` float NOT NULL DEFAULT 0,
|
|
`memsize_pcf` int NOT NULL DEFAULT 0,
|
|
`memsize_sys` int NOT NULL DEFAULT 0,
|
|
`mem_usage_sys` float NOT NULL DEFAULT 0,
|
|
`disk_partition` int NOT NULL DEFAULT 1,
|
|
`partition1_total` int NOT NULL DEFAULT 0,
|
|
`partition1_used` int NOT NULL DEFAULT 0,
|
|
`partition2_total` int NOT NULL DEFAULT 0,
|
|
`partition2_used` int NOT NULL DEFAULT 0,
|
|
`partition3_total` int NOT NULL DEFAULT 0,
|
|
`partition3_used` int NOT NULL DEFAULT 0,
|
|
`partition4_total` int NOT NULL DEFAULT 0,
|
|
`partition4_used` int NOT NULL DEFAULT 0,
|
|
`apm_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
PRIMARY KEY (`sysNo`, `apm_datetime`) USING BTREE
|
|
) ENGINE = MyISAM CHARACTER SET = gb2312 COLLATE = gb2312_chinese_ci ROW_FORMAT = Fixed;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for smfApmData
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `smfApmData`;
|
|
CREATE TABLE `smfApmData` (
|
|
`sysNo` tinyint(1) NOT NULL DEFAULT 0,
|
|
`cpu_usage_smf` float NOT NULL DEFAULT 0,
|
|
`cpu_usage_sys` float NOT NULL DEFAULT 0,
|
|
`memsize_smf` int NOT NULL DEFAULT 0,
|
|
`memsize_sys` int NOT NULL DEFAULT 0,
|
|
`mem_usage_sys` float NOT NULL DEFAULT 0,
|
|
`disk_partition` int NOT NULL DEFAULT 1,
|
|
`partition1_total` int NOT NULL DEFAULT 0,
|
|
`partition1_used` int NOT NULL DEFAULT 0,
|
|
`partition2_total` int NOT NULL DEFAULT 0,
|
|
`partition2_used` int NOT NULL DEFAULT 0,
|
|
`partition3_total` int NOT NULL DEFAULT 0,
|
|
`partition3_used` int NOT NULL DEFAULT 0,
|
|
`partition4_total` int NOT NULL DEFAULT 0,
|
|
`partition4_used` int NOT NULL DEFAULT 0,
|
|
`apm_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
PRIMARY KEY (`sysNo`, `apm_datetime`) USING BTREE
|
|
) ENGINE = MyISAM CHARACTER SET = gb2312 COLLATE = gb2312_chinese_ci ROW_FORMAT = Fixed;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for udmApmData
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `udmApmData`;
|
|
CREATE TABLE `udmApmData` (
|
|
`sysNo` tinyint(1) NOT NULL DEFAULT 0,
|
|
`cpu_usage_udm` float NOT NULL DEFAULT 0,
|
|
`cpu_usage_sys` float NOT NULL DEFAULT 0,
|
|
`memsize_udm` int NOT NULL DEFAULT 0,
|
|
`memsize_sys` int NOT NULL DEFAULT 0,
|
|
`mem_usage_sys` float NOT NULL DEFAULT 0,
|
|
`disk_partition` int NOT NULL DEFAULT 1,
|
|
`partition1_total` int NOT NULL DEFAULT 0,
|
|
`partition1_used` int NOT NULL DEFAULT 0,
|
|
`partition2_total` int NOT NULL DEFAULT 0,
|
|
`partition2_used` int NOT NULL DEFAULT 0,
|
|
`partition3_total` int NOT NULL DEFAULT 0,
|
|
`partition3_used` int NOT NULL DEFAULT 0,
|
|
`partition4_total` int NOT NULL DEFAULT 0,
|
|
`partition4_used` int NOT NULL DEFAULT 0,
|
|
`apm_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
PRIMARY KEY (`sysNo`, `apm_datetime`) USING BTREE
|
|
) ENGINE = MyISAM CHARACTER SET = gb2312 COLLATE = gb2312_chinese_ci ROW_FORMAT = Fixed;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for upfApmData
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `upfApmData`;
|
|
CREATE TABLE `upfApmData` (
|
|
`sysNo` tinyint(1) NOT NULL DEFAULT 0,
|
|
`cpu_usage_upf` float NOT NULL DEFAULT 0,
|
|
`cpu_usage_sys` float NOT NULL DEFAULT 0,
|
|
`memsize_upf` int NOT NULL DEFAULT 0,
|
|
`memsize_sys` int NOT NULL DEFAULT 0,
|
|
`mem_usage_sys` float NOT NULL DEFAULT 0,
|
|
`disk_partition` int NOT NULL DEFAULT 1,
|
|
`partition1_total` int NOT NULL DEFAULT 0,
|
|
`partition1_used` int NOT NULL DEFAULT 0,
|
|
`partition2_total` int NOT NULL DEFAULT 0,
|
|
`partition2_used` int NOT NULL DEFAULT 0,
|
|
`partition3_total` int NOT NULL DEFAULT 0,
|
|
`partition3_used` int NOT NULL DEFAULT 0,
|
|
`partition4_total` int NOT NULL DEFAULT 0,
|
|
`partition4_used` int NOT NULL DEFAULT 0,
|
|
`apm_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
PRIMARY KEY (`sysNo`, `apm_datetime`) USING BTREE
|
|
) ENGINE = MyISAM CHARACTER SET = gb2312 COLLATE = gb2312_chinese_ci ROW_FORMAT = Fixed;
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1;
|