-- Table structure for table `zones`

CREATE TABLE `zones` (
  `id` int(11) NOT NULL auto_increment,
  `zone` varchar(65) NOT NULL,                  -- qupps.biz
  PRIMARY KEY  (`id`),
  UNIQUE KEY `zones_zone` (`zone`)
);

-- Table structure for table `rrset`

CREATE TABLE `rrset` (
  `id` int(11) NOT NULL auto_increment,
  `zid` int(11) NOT NULL,                       -- zones.id
  `ttl` int(11) NOT NULL default '86400',       -- 3600
  `host` varchar(65) NOT NULL,                  -- www
  `type` varchar(6) NOT NULL,                   -- A
  `data` varchar(255) NOT NULL,                 -- 192.168.1.17
  PRIMARY KEY  (`id`),
  KEY `rrset_zid` (`zid`)
);

-- Table structure for table `axfr`

CREATE TABLE `axfr` (
  `id` int(11) NOT NULL auto_increment,
  `zone` varchar(65) NOT NULL,                  -- qupps.biz
  `ip` varchar(65) NOT NULL,                    -- 192.168.1.20
  PRIMARY KEY  (`id`)
);