CREATE TABLE `routerinterfacedata` (
  `devname` varchar(100) DEFAULT NULL,
  `infname` varchar(100) DEFAULT NULL,
  `inbits` double(23,5) DEFAULT NULL,
  `outbits` double(23,5) DEFAULT NULL,
  `inerror` double(23,5) DEFAULT NULL,
  `outerror` double(23,5) DEFAULT NULL,
  `indiscards` double(5,5) DEFAULT NULL,
  `outdiscard` double(5,5) DEFAULT NULL,
  `ifqlen` int(11) DEFAULT NULL,
  `ifspeed` int(11) DEFAULT NULL,
  `inhcbits` double(5,5) DEFAULT NULL,
  `outhcbits` double(5,5) DEFAULT NULL,
  `time` datetime DEFAULT NULL,
  `dcid` int(10) unsigned NOT NULL,
  `level` int(10) unsigned NOT NULL,
  `infid` int(10) unsigned NOT NULL,
  KEY `devinfdcid` (`devname`,`infname`,`dcid`)
)