db design for use with radump_to_dns_db.py. See https://gist.github.com/mbrownnycnyc/6158144 for writer.

argus_dnsdb.sql

-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version  5.5.20


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


--
-- Create schema argus_dnsdb
--

CREATE DATABASE IF NOT EXISTS argus_dnsdb;
USE argus_dnsdb;

--
-- Definition of table `hosts`
--

DROP TABLE IF EXISTS `hosts`;
CREATE TABLE `hosts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `host` varchar(128) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hosts`
--

/*!40000 ALTER TABLE `hosts` DISABLE KEYS */;
/*!40000 ALTER TABLE `hosts` ENABLE KEYS */;


--
-- Definition of table `main`
--

DROP TABLE IF EXISTS `main`;
CREATE TABLE `main` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `flow_uid` int(10) unsigned NOT NULL,
  `flow_seq` int(10) unsigned NOT NULL,
  `qtime` double(18,6) NOT NULL,
  `nsclient_id` int(10) unsigned NOT NULL,
  `nsserver_id` int(10) unsigned NOT NULL,
  `qtype_id` int(10) unsigned NOT NULL,
  `qname_host_id` int(10) unsigned NOT NULL,
  `atype_id` int(10) unsigned NOT NULL,
  `aname_host_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `main`
--

/*!40000 ALTER TABLE `main` DISABLE KEYS */;
/*!40000 ALTER TABLE `main` ENABLE KEYS */;


--
-- Definition of table `nsclients`
--

DROP TABLE IF EXISTS `nsclients`;
CREATE TABLE `nsclients` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ipv4addr` varchar(64) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `nsclients`
--

/*!40000 ALTER TABLE `nsclients` DISABLE KEYS */;
/*!40000 ALTER TABLE `nsclients` ENABLE KEYS */;


--
-- Definition of table `nsservers`
--

DROP TABLE IF EXISTS `nsservers`;
CREATE TABLE `nsservers` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ipv4addr` varchar(64) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `nsservers`
--

/*!40000 ALTER TABLE `nsservers` DISABLE KEYS */;
/*!40000 ALTER TABLE `nsservers` ENABLE KEYS */;


--
-- Definition of table `nstypes`
--

DROP TABLE IF EXISTS `nstypes`;
CREATE TABLE `nstypes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nstype` varchar(15) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `nstypes`
--

/*!40000 ALTER TABLE `nstypes` DISABLE KEYS */;
INSERT INTO `nstypes` (`id`,`nstype`) VALUES 
 (1,'A'),
 (2,'NS'),
 (3,'MD'),
 (4,'MF'),
 (5,'CNAME'),
 (6,'SOA'),
 (7,'MB'),
 (8,'MG'),
 (9,'MR'),
 (10,'NULL'),
 (11,'WKS'),
 (12,'PTR'),
 (13,'HINFO'),
 (14,'MINFO'),
 (15,'MX'),
 (16,'TXT'),
 (17,'RP'),
 (18,'AFSDB'),
 (19,'X25'),
 (20,'ISDN'),
 (21,'RT'),
 (22,'NSAP'),
 (23,'NSAP_PTR'),
 (24,'SIG'),
 (25,'KEY'),
 (26,'PX'),
 (27,'GPOS'),
 (28,'AAAA'),
 (29,'LOC'),
 (30,'NXT'),
 (31,'EID'),
 (32,'NIMLOC'),
 (33,'SRV'),
 (34,'ATMA'),
 (35,'NAPTR'),
 (36,'A6'),
 (37,'DNAME'),
 (38,'OPT'),
 (39,'UINFO'),
 (40,'UID'),
 (41,'GID'),
 (42,'UNSPEC'),
 (43,'UNSPECA'),
 (44,'TKEY'),
 (45,'TSIG'),
 (46,'IXFR'),
 (47,'AXFR'),
 (48,'MAILB'),
 (49,'MAILA'),
 (50,'ANY');
/*!40000 ALTER TABLE `nstypes` ENABLE KEYS */;




/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;