## SQL schema

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `dns_record` (
  `record_id` int(11) NOT NULL AUTO_INCREMENT,
  `zone_id` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `type` varchar(10) DEFAULT NULL,
  `content` mediumtext,
  `ttl` int(11) DEFAULT NULL,
  `prio` int(11) DEFAULT NULL,
  `change_date` int(11) DEFAULT NULL,
  PRIMARY KEY (`record_id`),
  KEY `zone_id` (`zone_id`),
  KEY `nametype` (`name`,`type`)
) ENGINE=InnoDB AUTO_INCREMENT=32115 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `dns_supermaster` (
  `ip` varchar(25) NOT NULL,
  `nameserver` varchar(255) NOT NULL,
  `account` varchar(40) NOT NULL DEFAULT '',
  PRIMARY KEY (`ip`,`nameserver`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `dns_zone` (
  `zone_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `master` varchar(128) DEFAULT NULL,
  `last_check` int(11) DEFAULT NULL,
  `type` varchar(6) NOT NULL,
  `notified_serial` int(11) DEFAULT NULL,
  `account` varchar(40) DEFAULT NULL,
  `client_id` int(11) DEFAULT NULL,
  `service_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`zone_id`),
  UNIQUE KEY `name` (`name`),
  KEY `client_service` (`client_id`,`service_id`)
) ENGINE=InnoDB AUTO_INCREMENT=702 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;





## PDNS config, powerdns 2.9.22
gmysql-basic-query=SELECT content,ttl,prio,type,zone_id,name FROM dns_record WHERE type='%s' AND name='%s'
gmysql-id-query=SELECT content,ttl,prio,type,zone_id,name FROM dns_record WHERE type='%s' AND name='%s' AND zone_id=%d
gmysql-any-query=SELECT content,ttl,prio,type,zone_id,name FROM dns_record WHERE name='%s'
gmysql-any-id-query=SELECT content,ttl,prio,type,zone_id,name FROM dns_record WHERE name='%s' AND zone_id=%d
gmysql-list-query=SELECT content,ttl,prio,type,zone_id,name FROM dns_record WHERE zone_id=%d
gmysql-master-zone-query=SELECT master FROM dns_zone WHERE name='%s' AND type='SLAVE'
gmysql-info-zone-query=SELECT zone_id,name,master,last_check,notified_serial,type FROM dns_zone WHERE name='%s'
gmysql-info-all-slaves-query=SELECT zone_id,name,master,last_check,type FROM dns_zone WHERE type='SLAVE'
gmysql-supermaster-query=SELECT account FROM dns_supermaster WHERE ip='%s' AND nameserver='%s'
gmysql-insert-slave-query=INSERT INTO dns_zone (type,name,master,account) VALUES ('SLAVE','%s','%s','%s')
gmysql-insert-record-query=INSERT INTO dns_record (content,ttl,prio,type,zone_id,name) VALUES ('%s',%d,%d,'%s',%d,'%s')
gmysql-update-serial-query=UPDATE dns_zone SET notified_serial=%d WHERE zone_id=%d
gmysql-update-lastcheck-query=UPDATE dns_zone SET last_check=%d WHERE zone_id=%d
gmysql-info-all-master-query=SELECT zone_id,name,master,last_check,notified_serial,type FROM dns_zone WHERE type='MASTER'
gmysql-delete-zone-query=delete FROM dns_record WHERE zone_id=%d