File snmptt.sql of Package snmptt

CREATE TABLE `snmptt` (
	  `id` mediumint(9) NOT NULL auto_increment,
	  `eventname` varchar(50) default NULL,
	  `eventid` varchar(50) default NULL,
	  `trapoid` varchar(100) default NULL,
	  `enterprise` varchar(100) default NULL,
	  `community` varchar(20) default NULL,
	  `hostname` varchar(100) default NULL,
	  `agentip` varchar(16) default NULL,
	  `category` varchar(20) default NULL,
	  `severity` varchar(20) default NULL,
	  `uptime` varchar(20) default NULL,
	  `traptime` varchar(30) default NULL,
	  `formatline` varchar(255) default NULL,
	  `trapread` int(11) default '0',
	  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE `snmptt_archive` (
	  `id` mediumint(9) NOT NULL auto_increment,
	  `snmptt_id` mediumint(9) NOT NULL,
	  `eventname` varchar(50) default NULL,
	  `eventid` varchar(50) default NULL,
	  `trapoid` varchar(100) default NULL,
	  `enterprise` varchar(100) default NULL,
	  `community` varchar(20) default NULL,
	  `hostname` varchar(100) default NULL,
	  `agentip` varchar(16) default NULL,
	  `category` varchar(20) default NULL,
	  `severity` varchar(20) default NULL,
	  `uptime` varchar(20) default NULL,
	  `traptime` varchar(30) default NULL,
	  `formatline` varchar(255) default NULL,
	  `trapread` int(11) default '0',
	  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `snmptt_unknown` (
	  `id` mediumint(9) NOT NULL auto_increment,
	  `trapoid` varchar(100) default NULL,
	  `enterprise` varchar(100) default NULL,
	  `community` varchar(20) default NULL,
	  `hostname` varchar(100) default NULL,
	  `agentip` varchar(16) default NULL,
	  `uptime` varchar(20) default NULL,
	  `traptime` varchar(30) default NULL,
	  `formatline` varchar(255) default NULL,
	  `trapread` int(11) default '0',
	  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `snmptt_jobs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(50) NOT NULL,
  `jobstate` int(5) NOT NULL,
  `count` int(11) NOT NULL,
  `jobtime` int(50) NOT NULL,
  `message` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `snmptt_statistics` (
  `stat_time` varchar(30) DEFAULT NULL,
  `total_received` bigint(20) DEFAULT NULL,
  `total_translated` bigint(20) DEFAULT NULL,
  `total_ignored` bigint(20) DEFAULT NULL,
  `total_unknown` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
openSUSE Build Service is sponsored by