blob: f496f17955d284f2e18ad983025f8d356b323bfe [file] [log] [blame]
Wes Hardaker0ec088a2010-10-11 14:11:17 +00001USE net_snmp;
2DROP TABLE IF EXISTS notifications;
3CREATE TABLE IF NOT EXISTS `notifications` (
4 `trap_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
5 `date_time` datetime NOT NULL,
6 `host` varchar(255) NOT NULL,
7 `auth` varchar(255) NOT NULL,
8 `type` ENUM('get','getnext','response','set','trap','getbulk','inform','trap2','report') NOT NULL,
9 `version` ENUM('v1','v2c', 'unsupported(v2u)','v3') NOT NULL,
10 `request_id` int(11) unsigned NOT NULL,
11 `snmpTrapOID` varchar(1024) NOT NULL,
12 `transport` varchar(255) NOT NULL,
13 `security_model` ENUM('snmpV1','snmpV2c','USM') NOT NULL,
14 `v3msgid` int(11) unsigned,
15 `v3security_level` ENUM('noAuthNoPriv','authNoPriv','authPriv'),
16 `v3context_name` varchar(32),
17 `v3context_engine` varchar(64),
18 `v3security_name` varchar(32),
19 `v3security_engine` varchar(64),
20 PRIMARY KEY (`trap_id`)
21) ENGINE=InnoDB DEFAULT CHARSET=latin1;
22
23
24DROP TABLE IF EXISTS varbinds;
25CREATE TABLE IF NOT EXISTS `varbinds` (
26 `trap_id` int(11) unsigned NOT NULL default '0',
27 `oid` varchar(1024) NOT NULL,
28 `type` ENUM('boolean','integer','bit','octet','null','oid','ipaddress','counter','unsigned','timeticks','opaque','unused1','counter64','unused2') NOT NULL,
29 `value` blob NOT NULL,
30 KEY `trap_id` (`trap_id`)
31) ENGINE=InnoDB DEFAULT CHARSET=latin1;