deploy-zabbix5.0.zip

-- MariaDB dump 10.19 Distrib 10.11.2-MariaDB, for Linux (x86_64) -- -- Host: localhost Database: zabbix -- ------------------------------------------------------ -- Server version 10.11.2-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 `acknowledges` -- DROP TABLE IF EXISTS `acknowledges`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `acknowledges` ( `acknowledgeid` bigint(20) unsigned NOT NULL, `userid` bigint(20) unsigned NOT NULL, `eventid` bigint(20) unsigned NOT NULL, `clock` int(11) NOT NULL DEFAULT 0, `message` varchar(2048) NOT NULL DEFAULT '', `action` int(11) NOT NULL DEFAULT 0, `old_severity` int(11) NOT NULL DEFAULT 0, `new_severity` int(11) NOT NULL DEFAULT 0, PRIMARY KEY (`acknowledgeid`), KEY `acknowledges_1` (`userid`), KEY `acknowledges_2` (`eventid`), KEY `acknowledges_3` (`clock`), CONSTRAINT `c_acknowledges_1` FOREIGN KEY (`userid`) REFERENCES `users` (`userid`) ON DELETE CASCADE, CONSTRAINT `c_acknowledges_2` FOREIGN KEY (`eventid`) REFERENCES `events` (`eventid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `acknowledges` -- LOCK TABLES `acknowledges` WRITE; /*!40000 ALTER TABLE `acknowledges` DISABLE KEYS */; /*!40000 ALTER TABLE `acknowledges` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `actions` -- DROP TABLE IF EXISTS `actions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `actions` ( `actionid` bigint(20) unsigned NOT NULL, `name` varchar(255) NOT NULL DEFAULT '', `eventsource` int(11) NOT NULL DEFAULT 0, `evaltype` int(11) NOT NULL DEFAULT 0, `status` int(11) NOT NULL DEFAULT 0, `esc_period` varchar(255) NOT NULL DEFAULT '1h', `formula` varchar(255) NOT NULL DEFAULT '', `pause_suppressed` int(11) NOT NULL DEFAULT 1, PRIMARY KEY (`actionid`), UNIQUE KEY `actions_2` (`name`), KEY `actions_1` (`eventsource`,`status`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `actions` -- LOCK TABLES `actions` WRITE; /*!40000 ALTER TABLE `actions` DISABLE KEYS */; INSERT INTO `actions` VALUES (2,'Auto discovery. Linux servers.',1,0,1,'0','',1), (3,'Report problems to Zabbix administrators',0,0,1,'1h','',1), (4,'Report not supported items',3,0,1,'1h','',1), (5,'Report not supported low level discovery rules',3,0,1,'1h','',1), (6,'Report unknown triggers',3,0,1,'1h','',1), (7,'Auto registration Linux',2,0,0,'1h','',1), (8,'Auto registration Windows',2,0,0,'1h','',1); /*!40000 ALTER TABLE `actions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `alerts` -- DROP TABLE IF EXISTS `alerts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `alerts` ( `alertid` bigint(20) unsigned NOT NULL, `actionid` bigint(20) unsigned NOT NULL, `eventid` bigint(20) unsigned NOT NULL, `userid` bigint(20) unsigned DEFAULT NULL, `clock` int(11) NOT NULL DEFAULT 0, `mediatypeid` bigint(20) unsigned DEFAULT NULL, `sendto` varchar(1024) NOT NULL DEFAULT '', `subject` varchar(255) NOT NULL DEFAULT '', `message` text NOT NULL, `status` int(11) NOT NULL DEFAULT 0, `retries` int(11) NOT NULL DEFAULT 0, `error` varchar(2048) NOT NULL DEFAULT '', `esc_step` int(11) NOT NULL DEFAULT 0, `alerttype` int(11) NOT NULL DEFAULT 0, `p_eventid` bigint(20) unsigned DEFAULT NULL, `acknowledgeid` bigint(20) unsigned DEFAULT NULL, `parameters` text NOT NULL, PRIMARY KEY (`alertid`), KEY `alerts_1` (`actionid`), KEY `alerts_2` (`clock`), KEY `alerts_3` (`eventid`), KEY `alerts_4` (`status`), KEY `alerts_5` (`mediatypeid`), KEY `alerts_6` (`userid`), KEY `alerts_7` (`p_eventid`), KEY `alerts_8` (`acknowledgeid`), CONSTRAINT `c_alerts_1` FOREIGN KEY (`actionid`) REFERENCES `actions` (`actionid`) ON DELETE CASCADE, CONSTRAINT `c_alerts_2` FOREIGN KEY (`eventid`) REFERENCES `events` (`eventid`) ON DELETE CASCADE, CONSTRAINT `c_alerts_3` FOREIGN KEY (`userid`) REFERENCES `users` (`userid`) ON DELETE CASCADE, CONSTRAINT `c_alerts_4` FOREIGN KEY (`mediatypeid`) REFERENCES `media_type` (`mediatypeid`) ON DELETE CASCADE, CONSTRAINT `c_alerts_5` FOREIGN KEY (`p_eventid`) REFERENCES `events` (`eventid`) ON DELETE CASCADE, CONSTRAINT `c_alerts_6` FOREIGN KEY (`acknowledgeid`) REFERENCES `acknowledges` (`acknowledgeid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `alerts` -- LOCK TABLES `alerts` WRITE; /*!40000 ALTER TABLE `alerts` DISABLE KEYS */; /*!40000 ALTER TABLE `alerts` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `application_discovery` -- DROP TABLE IF EXISTS `application_discovery`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `application_discovery` ( `application_discoveryid` bigint(20) unsigned NOT NULL, `applicationid` bigint(20) unsigned NOT NULL, `application_prototypeid` bigint(20) unsigned NOT NULL, `name` varchar(255) NOT NULL DEFAULT '', `lastcheck` int(11) NOT NULL DEFAULT 0, `ts_delete` int(11) NOT NULL DEFAULT 0, PRIMARY KEY (`application_discoveryid`), KEY `application_discovery_1` (`applicationid`), KEY `application_discovery_2` (`application_prototypeid`), CONSTRAINT `c_application_discovery_1` FOREIGN KEY (`applicationid`) REFERENCES `applications` (`applicationid`) ON DELETE CASCADE, CONSTRAINT `c_application_discovery_2` FOREIGN KEY (`application_prototypeid`) REFERENCES `application_prototype` (`application_prototypeid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `application_discovery` -- LOCK TABLES `application_discovery` WRITE; /*!40000 ALTER TABLE `application_discovery` DISABLE KEYS */; INSERT INTO `application_discovery` VALUES (1,1878,131,'Disk {#DEVNAME}',1682059275,0), (2,1879,13,'Filesystem {#FSNAME}',1682057207,0), (3,1880,13,'Filesystem {#FSNAME}',1682057207,0), (4,1881,15,'Interface {#IFNAME}',1682057209,0); /*!40000 ALTER TABLE `application_discovery` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `application_prototype` -- DROP TABLE IF EXISTS `application_prototype`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `application_prototype` ( `application_prototypeid` bigint(20) unsigned NOT NULL, `itemid` bigint(20) unsigned NOT NULL, `templateid` bigint(20) unsigned DEFAULT NULL, `name` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`application_prototypeid`), KEY `application_prototype_1` (`itemid`), KEY `application_prototype_2` (`templateid`), CONSTRAINT `c_application_prototype_1` FOREIGN KEY (`itemid`) REFERENCES `items` (`itemid`) ON DELETE CASCADE, CONSTRAINT `c_application_prototype_2` FOREIGN KEY (`templateid`) REFERENCES `application_prototype` (`application_prototypeid`) ON DELETE CASCADE ) ENGINE=Inno