USE pdns;
 
CREATE TABLE domains
(
id              INT          AUTO_INCREMENT,
name            VARCHAR(255) NOT NULL,
master          VARCHAR(128) DEFAULT NULL,
last_check      INT          DEFAULT NULL,
type            VARCHAR(6)   NOT NULL,
notified_serial INT          DEFAULT NULL,
account         VARCHAR(40)  DEFAULT NULL,
solusvm_cid     INT          DEFAULT NULL,
PRIMARY KEY (id)
) type=InnoDB;
 
CREATE UNIQUE INDEX name_index ON domains(name);
 
CREATE TABLE records
(
id              INT          AUTO_INCREMENT,
domain_id       INT          DEFAULT NULL,
name            VARCHAR(255) DEFAULT NULL,
type            VARCHAR(6)   DEFAULT NULL,
content         VARCHAR(255) DEFAULT NULL,
ttl             INT          DEFAULT NULL,
prio            INT          DEFAULT NULL,
change_date     INT          DEFAULT NULL,
PRIMARY KEY(id)
) type=InnoDB;
 
CREATE INDEX rec_name_index ON records(name);
CREATE INDEX nametype_index ON records(name,type);
CREATE INDEX domain_id ON records(domain_id);
 
CREATE TABLE supermasters
(
ip              VARCHAR(25)  NOT NULL,
nameserver      VARCHAR(255) NOT NULL,
account         VARCHAR(40)  DEFAULT NULL
) type=InnoDB;
