| 1 | -- MySQL dump 10.13 Distrib 5.7.27, for FreeBSD11.2 (amd64)
|
|---|
| 2 | --
|
|---|
| 3 | -- Host: 172.25.7.13 Database:
|
|---|
| 4 | -- ------------------------------------------------------
|
|---|
| 5 | -- Server version 5.7.27
|
|---|
| 6 |
|
|---|
| 7 | /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
|---|
| 8 | /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
|---|
| 9 | /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
|---|
| 10 | /*!40101 SET NAMES utf8 */;
|
|---|
| 11 | /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
|
|---|
| 12 | /*!40103 SET TIME_ZONE='+00:00' */;
|
|---|
| 13 | /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
|
|---|
| 14 | /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
|
|---|
| 15 | /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
|
|---|
| 16 | /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
|
|---|
| 17 |
|
|---|
| 18 | --
|
|---|
| 19 | -- Current Database: `net_snmp`
|
|---|
| 20 | --
|
|---|
| 21 |
|
|---|
| 22 | CREATE DATABASE /*!32312 IF NOT EXISTS*/ `net_snmp` /*!40100 DEFAULT CHARACTER SET latin1 */;
|
|---|
| 23 |
|
|---|
| 24 | USE `net_snmp`;
|
|---|
| 25 |
|
|---|
| 26 | --
|
|---|
| 27 | -- Table structure for table `notifications`
|
|---|
| 28 | --
|
|---|
| 29 |
|
|---|
| 30 | DROP TABLE IF EXISTS `notifications`;
|
|---|
| 31 | /*!40101 SET @saved_cs_client = @@character_set_client */;
|
|---|
| 32 | /*!40101 SET character_set_client = utf8 */;
|
|---|
| 33 | CREATE TABLE `notifications` (
|
|---|
| 34 | `trap_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
|
|---|
| 35 | `date_time` datetime NOT NULL,
|
|---|
| 36 | `host` varchar(255) NOT NULL,
|
|---|
| 37 | `auth` varchar(255) NOT NULL,
|
|---|
| 38 | `type` enum('get','getnext','response','set','trap','getbulk','inform','trap2','report') NOT NULL,
|
|---|
| 39 | `version` enum('v1','v2c','unsupported(v2u)','v3') NOT NULL,
|
|---|
| 40 | `request_id` int(11) unsigned NOT NULL,
|
|---|
| 41 | `snmpTrapOID` varchar(1024) NOT NULL,
|
|---|
| 42 | `transport` varchar(255) NOT NULL,
|
|---|
| 43 | `security_model` enum('snmpV1','snmpV2c','USM') NOT NULL,
|
|---|
| 44 | `v3msgid` int(11) unsigned DEFAULT NULL,
|
|---|
| 45 | `v3security_level` enum('noAuthNoPriv','authNoPriv','authPriv') DEFAULT NULL,
|
|---|
| 46 | `v3context_name` varchar(32) DEFAULT NULL,
|
|---|
| 47 | `v3context_engine` varchar(64) DEFAULT NULL,
|
|---|
| 48 | `v3security_name` varchar(32) DEFAULT NULL,
|
|---|
| 49 | `v3security_engine` varchar(64) DEFAULT NULL,
|
|---|
| 50 | PRIMARY KEY (`trap_id`),
|
|---|
| 51 | KEY `trap_id_idx1` (`trap_id`) USING BTREE
|
|---|
| 52 | ) ENGINE=InnoDB AUTO_INCREMENT=91971071 DEFAULT CHARSET=latin1;
|
|---|
| 53 | /*!40101 SET character_set_client = @saved_cs_client */;
|
|---|
| 54 |
|
|---|
| 55 | --
|
|---|
| 56 | -- Table structure for table `varbinds`
|
|---|
| 57 | --
|
|---|
| 58 |
|
|---|
| 59 | DROP TABLE IF EXISTS `varbinds`;
|
|---|
| 60 | /*!40101 SET @saved_cs_client = @@character_set_client */;
|
|---|
| 61 | /*!40101 SET character_set_client = utf8 */;
|
|---|
| 62 | CREATE TABLE `varbinds` (
|
|---|
| 63 | `trap_id` int(11) unsigned NOT NULL DEFAULT '0',
|
|---|
| 64 | `oid` varchar(1024) NOT NULL,
|
|---|
| 65 | `type` enum('boolean','integer','bit','octet','null','oid','ipaddress','counter','unsigned','timeticks','opaque','unused1','counter64','unused2') NOT NULL,
|
|---|
| 66 | `value` blob NOT NULL,
|
|---|
| 67 | KEY `trap_id` (`trap_id`),
|
|---|
| 68 | CONSTRAINT `trap_id_fk` FOREIGN KEY (`trap_id`) REFERENCES `notifications` (`trap_id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|---|
| 69 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|---|
| 70 | /*!40101 SET character_set_client = @saved_cs_client */;
|
|---|
| 71 |
|
|---|
