DROP TABLE IF EXISTS dns_records;
CREATE TABLE dns_records (
   zone          text not NULL,
   host          text,
   ttl           int(11) default NULL,
   type          varchar(10),
   mx_priority   varchar(5) default NULL,
   data          text,
   resp_person   text,
   serial        varchar(20) default NULL,
   refresh       varchar(11) default NULL,
   retry         varchar(11) default NULL,
   expire        varchar(11) default NULL,
   minimum       varchar(11) default NULL,
   INDEX         zone_host_index (zone(30), host(30)),
   INDEX         type_index (type(8))
);

DROP TABLE IF EXISTS dns_ptrrecords;
CREATE TABLE dns_ptrrecords (
   zone          text not NULL,
   host          text,
   ttl           int(11) default NULL,
   type          varchar(10),
   mx_priority   varchar(5) default NULL,
   data          text,
   resp_person   text,
   serial        varchar(20) default NULL,
   refresh       varchar(11) default NULL,
   retry         varchar(11) default NULL,
   expire        varchar(11) default NULL,
   minimum       varchar(11) default NULL,
   INDEX         zone_host_index (zone(30), host(30)),
   INDEX         type_index (type(8))
);

CREATE VIEW vdns AS
  SELECT * from dns_records
  UNION
  SELECT * from dns_ptrrecords;


DROP TABLE IF EXISTS xfr_table;
CREATE TABLE xfr_table (
    zone         text,
    client       text,
    INDEX        zone_client_index (zone(30), client(30))
);

DROP TABLE IF EXISTS hits;
CREATE TABLE hits (
    zone         text not NULL,
    nr           bigint(20) default 0,
    PRIMARY KEY  (zone(30))
);