Wes Hardaker | 0ec088a | 2010-10-11 14:11:17 +0000 | [diff] [blame] | 1 | USE net_snmp; |
| 2 | DROP TABLE IF EXISTS notifications; |
| 3 | CREATE 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 | |
| 24 | DROP TABLE IF EXISTS varbinds; |
| 25 | CREATE 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; |