--
-- Table structure for table `dns_zone`
--

CREATE TABLE dns_zone (
  zone_id int(10) unsigned NOT NULL auto_increment,
  group_id bigint(20) NOT NULL default '1',
  agent varchar(128) default NULL,
  password_clear varchar(64) default NULL,
  active enum('Y','N') NOT NULL default 'Y',
  zone varchar(255) NOT NULL default '',
  timestamp int(10) unsigned NOT NULL default '0',
  default_TTL int(10) unsigned default NULL,
  soa_MNAME varchar(255) default NULL,
  soa_RNAME varchar(255) default NULL,
  soa_SERIAL int(10) unsigned default NULL,
  soa_REFRESH int(10) unsigned default NULL,
  soa_RETRY int(10) unsigned default NULL,
  soa_EXPIRE int(10) unsigned default NULL,
  soa_MINIMUM int(10) unsigned default NULL,
  max_a int(11) NOT NULL default '5',
  PRIMARY KEY  (zone_id),
  UNIQUE KEY zone (zone),
  KEY timestamp (timestamp)
) TYPE=MyISAM;

--
-- Table structure for table `dns_entry`
--

CREATE TABLE dns_entry (
  entry_id int(10) unsigned NOT NULL auto_increment,
  zone_id int(10) unsigned NOT NULL default '0',
  level enum('1','2','3','4') NOT NULL default '4',
  owner varchar(255) NOT NULL default '@',
  class enum('CH','CS','HS','IN') NOT NULL default 'IN',
  ttl int(10) unsigned default NULL,
  type enum('A','CNAME','HINFO','MB','MD','MF','MG','MINFO','MR','MX','NS','NULL','PTR','TXT','WKS','AFSDB','ISDN','RP','RT','X25','PX') NOT NULL default 'A',
  rdata text NOT NULL,
  PRIMARY KEY  (entry_id),
  KEY zone_id (zone_id),
  FULLTEXT KEY rdata (rdata)
) TYPE=MyISAM;

--
-- Table structure for table `_defaults_`
--

CREATE TABLE _defaults_ (
  subsystem varchar(64) NOT NULL default '',
  variable varchar(128) NOT NULL default '',
  value varchar(128) default NULL,
  NOTES text,
  sortkey varchar(64) NOT NULL default '',
  PRIMARY KEY  (subsystem,variable,sortkey)
) TYPE=MyISAM;

--
-- Dumping data for table `_defaults_`
--

INSERT INTO _defaults_ VALUES ('dns','soa_REFRESH','86400','86400 = 1d','');
INSERT INTO _defaults_ VALUES ('dns','soa_RETRY','7200','7200 = 2h','');
INSERT INTO _defaults_ VALUES ('dns','soa_EXPIRE','604800','604800 = 1W','');
INSERT INTO _defaults_ VALUES ('dns','soa_MINIMUM','3600','3600 = 1h\nUsed for negative cacheing See RFC 2308','');
INSERT INTO _defaults_ VALUES ('dns','soa_MNAME','a.ns.lizard.org.uk.','The MASTER server','');
INSERT INTO _defaults_ VALUES ('dns','soa_RNAME','hostmaster.lizard.org.uk.','The responsibe person, replace first dot with \'@\'','');
INSERT INTO _defaults_ VALUES ('dns','default_TTL','86400','86400 = 1d','');