59 lines
9.4 KiB
SQL
59 lines
9.4 KiB
SQL
-- MariaDB dump 10.19 Distrib 10.6.16-MariaDB, for debian-linux-gnu (x86_64)
|
|
--
|
|
-- Host: 192.168.2.219 Database: omc_db
|
|
-- ------------------------------------------------------
|
|
-- Server version 10.3.38-MariaDB
|
|
|
|
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
|
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
|
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
|
/*!40101 SET NAMES utf8mb4 */;
|
|
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
|
|
/*!40103 SET TIME_ZONE='+00:00' */;
|
|
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
|
|
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
|
|
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
|
|
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
|
|
|
|
--
|
|
-- Table structure for table `config`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `config`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `config` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`module_name` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
|
|
`config_tag` varchar(32) NOT NULL,
|
|
`title_json` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
|
|
`value` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
|
|
`value_json` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
|
|
`update_time` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
|
|
`comment` varchar(255) DEFAULT NULL,
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
UNIQUE KEY `idx_uni_mod_tag` (`module_name`,`config_tag`) USING BTREE
|
|
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `config`
|
|
--
|
|
|
|
LOCK TABLES `config` WRITE;
|
|
/*!40000 ALTER TABLE `config` DISABLE KEYS */;
|
|
INSERT INTO `config` VALUES (1,'Alarm','historyDuration','{\"cn\": \"历史告警保留时间间隔(天)\", \"en\": \"History alarm duration(day)\"}','90',NULL,'2023-07-25 20:41:18',NULL),(2,'LOG','logDuration','{\"cn\": \"日志保留时间(天)\", \"en\": \"Log saved duration(day)\"}','90',NULL,'2023-05-08 17:40:28',NULL),(3,'LOG','logCapacity','{\"cn\": \"日志占用空间(MB)\", \"en\": \"Log occupation space(MB)\"}','1344',NULL,'2023-08-02 17:20:39',NULL),(4,'PM','pmBackupTask','{\"cn\": \"性能数据报表定期备份(天)\", \"en\": \"PM data backup task(day)\"}','',NULL,'2023-09-08 13:59:09',NULL),(5,'Alarm','syncTaskPeriod','{\"cn\": \"告警同步周期时长(小时)\", \"en\": \"Alarm sync task period(小时)\"}','24','{\"alarmEnd\":\"2023-08-21 00:00:00\",\"alarmStart\":\"2023-08-08 00:00:00\",\"syncTaskPeriod\":\"23\",\"unit\":\"hour\"}','2023-08-10 20:03:38',NULL),(6,'Alarm','displayFilter','{\"cn\": \"告警显示过滤设置\", \"en\": \"Alarm filter setting\"}','','{\"ne_type\":\"\",\"ne_id\":\"\",\"orig_severity\":\"\",\"alarm_code\":\"\",\"pv_flag\":\"\"}','2023-12-26 10:13:07',NULL),(7,'Alarm','autoAlarmAck','{\"cn\": \"告警自动确认设置\", \"en\": \"Alarm automatic ack setting\"}','','{\"alarm_status\":\"0\",\"alarm_type\":\"EquipmentAlarm\",\"orig_severity\":\"Major\",\"ack_user\":\"admin\"}','2023-07-28 08:07:02',NULL),(8,'PM','keepPMCKpi','{\"cn\": \"删除指标保留时长(天)\", \"en\": \"Keep custom pm kpi duration(day)\"}','4',NULL,'2023-07-29 11:01:45',NULL),(9,'Security','sessionExpires','{\"cn\": \"登录会话超时时长(秒)\", \"en\": \"User\'s session expires(second)\"}','1800000',NULL,'2023-07-31 09:45:17',NULL),(10,'Alarm','forwardAlarm','{\"cn\": \"告警前转接口设置\", \"en\": \"Alarm forward interface\"}',NULL,'[{\"interface\":\"Email\",\"to_user\":[]},{\"interface\":\"SMS\",\"to_user\":[\"138111112222\"]}]','2024-02-23 14:57:04',NULL),(17,'Security','highRisk','{\"cn\":\"高危指令设置\",\"en\":\"High risk instruction settings\"}','1','[{\"timePart\":\"04:00:00,06:00:00\",\"text\":\"请不要重复111\"},{\"timePart\":\"07:00:00,14:00:00\",\"text\":\"请不要重复22222\"},{\"timePart\":\"09:00:00,15:00:00\",\"text\":\"请不要重复3333\"}]','2023-08-16 11:23:37',NULL),(18,'Gold','goldSet','{\"cn\":\"黄金指标设置\",\"en\":\"Gold Index Setting\"}',NULL,'{\"goldWeek\":\"1\",\"omc_name\":\"23123\",\"login_url\":\"231231\",\"handshake_url\":\"321312\",\"grant_type\":\"321312\",\"user_name\":\"32131\",\"user_key\":\"22321\",\"max_data_len\":\"231\",\"kpi_report_url\":\"1231231\",\"time_out\":\"2131\"}','2023-08-13 18:15:01',NULL),(19,'Security','userTimeSet','{\"cn\":\"账号有效期设置\",\"en\":\"Account validity period setting\"}','18000',NULL,'2023-08-10 14:18:57',NULL),(20,'Security','pwdStrong','{\"cn\":\"密码强度设置\",\"en\":\"Account validity period setting\"}',NULL,'{\"pwdMinLength\":\"4\",\"pwdTime\":\"12\",\"strongNum\":\"1\",\"outTimeMsg\":\"密码有效期已过,请联系管理员进行修改密码\"}','2023-08-14 20:18:21',NULL),(22,'Nbi','nbiSet','{\"cn\":\"北向接口设置\",\"en\":\"Interface settings\"}',NULL,'{\"listeningAddress\":\"21312222222222222222\",\"listeningPort\":\"312\",\"nbiFileTime\":\"12312312\"}','2023-08-20 14:30:07',NULL),(25,'SystemMonitor','cpuThreshold','{\"cn\":\"CPU阈值及告警级别设置\",\"en\":\"threshold of CPU settings\"}',NULL,'{\"Major\":\"60\",\"Minor\":\"50\",\"Critical\":\"80\",\"Warning\":\"90\",\"Event\":\"75\"}','2023-08-15 18:06:13',NULL),(26,'SystemMonitor','sampleTime','{\"cn\":\"系统监控采样时间设置\",\"en\":\"settings\"}',NULL,'{\"sampleTime\":\"120\"}','2023-09-04 14:53:24',NULL),(27,'SystemMonitor','fileThreshold','{\"cn\":\"文件资源阈值及告警级别设置\",\"en\":\"threshold of file threshold settings\"}',NULL,'{\"type\":\"cpuThreshold\",\"Major\":\"12\",\"Minor\":\"\",\"Critical\":\"\",\"Warning\":\"\",\"Event\":\"\"}','2023-08-15 18:44:18',NULL),(28,'SystemMonitor','RAMThreshold','{\"cn\":\"内存阈值及告警级别设置\",\"en\":\"threshold of RAM threshold settings\"}',NULL,'{\"Major\":\"\", \"Minor\": \"\",\"Critical\": \"\",\"Warning\": \"\",\"Event\":\"\"}','2023-08-15 17:34:22',NULL),(29,'SystemMonitor','backupHandle','{\"cn\":\"手动备份设置\",\"en\":\"Periodic backup Settings\"}',NULL,'{\"isAuto\":\"1\",\"backup_way\":\"1\",\"backup_value\":\"2\",\"backup_time\":\"2023-08-30 18:41:00\",\"backup_medium\":\"/usr/backup\"}','2023-09-05 11:44:24','backup_way:备份方式,backup_value:备份内容,backup_time:备份时间,backup_medium:备份介质,isAuto:是否开启自动备份,\"backup_cycle\":备份周期'),(30,'SystemMonitor','databaseThreshold','{\"cn\":\"数据库阈值及告警级别设置\",\"en\":\"threshold of database settings\"}',NULL,'{\"Major\":\"\", \"Minor\": \"\",\"Critical\": \"\",\"Warning\": \"\",\"Event\":\"\"}','2023-08-15 17:32:55',NULL),(31,'LOG','remoteLogSet','{\"cn\":\"日志远程输出设置\",\"en\":\"Log Remote Output Settings\"}',NULL,'{\"logIp\":\"8.8.8.8\",\"logDirectory\":\"/tmp\"}','2023-10-30 18:37:25',NULL),(32,'MML','operationSet','{\"cn\":\"操作维护接口设置\",\"en\":\"Operation settings\"}',NULL,'{\"listeningAddress\":\"192.168.1.100\",\"listeningPort\":32130}','2023-10-20 11:35:40',NULL),(33,'LOG','ftpLogSet','{\"cn\":\"FTP日志文件接口设置\",\"en\":\"FTP Log File Interface Settings\"}','7','{\"agreement\":\"sftp\",\"ftpLog\":\"12\",\"toIp\":\"192.168.4.130\",\"directory\":\"/usr/local/omc/databse\"}','2023-09-05 11:42:01',NULL),(34,'NF','NfConfigSet','{\"cn\":\"自动备份任务备份时间设置\",\"en\":\"Automatic backup task backup time setting\n\n\"}','24',NULL,'2023-08-21 18:05:03',NULL),(35,'SystemMonitor','backupCycle','{\"cn\":\"周期备份设置\",\"en\":\"Periodic backup Settings\"}',NULL,'{\"isAuto\":\"1\",\"backup_way\":\"1\",\"backup_cycle\":\"5\",\"backup_value\":\"0\",\"backup_time\":\"08:00:00\",\"backup_medium\":\"/usr/local/omc/backup\"}','2023-09-05 11:44:21','backup_way:备份方式,backup_value:备份内容,backup_time:备份时间,backup_medium:备份介质,isAuto:是否开启自动备份,\"backup_cycle\":备份周期'),(36,'Security','loginSecurity','{\"cn\":\"登录策略设置\",\"en\":\"Login Security setting\"}','','{\"logintime_range\":\"08:00:00 - 18:00:00\",\"switch\":\"0\",\"ipRange\":\"192.168.4.1/192.168.21.333/192.168.21.114/192.168.2.119/192.168.88.192/192.168.2.112\",\"password_limit_time\":\"60\",\"limit_num\":\"5\"}','2023-08-28 15:01:07','\"logintime_range\":\"允许登录时间范围\",\"start_IP\":\"开始IP\",\"end_IP\":\"结束IP\",\"password_limit_time\":\"密码错误限定时间\",\"limit_num\":\"限时内密码最大错误次数\"'),(37,'System','logo','{\"cn\":\"系统LOGO\",\"en\":\"System LOGO\"}','logo30.png','','2023-09-20 19:40:03',''),(42,'System','href','{\"cn\":\"官方链接\",\"en\":\"Href\"}','https://www.agrandtech.com.cn/',NULL,'2023-10-12 14:19:51',NULL),(43,'BackUp','BackUpSaveTime','{\"cn\": \"网元配置文件保留时间(天)\", \"en\": \"Retention time of network element configuration files(day)\"}','30',NULL,'2023-10-21 16:08:20',NULL);
|
|
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
|
|
|
|
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
|
|
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
|
|
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
|
|
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
|
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|
|
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
|
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
|
|
|
-- Dump completed on 2024-03-06 17:27:01
|