summaryrefslogtreecommitdiff
path: root/dns/powerdns-devel/files/pdns_mysql.sql
diff options
context:
space:
mode:
Diffstat (limited to 'dns/powerdns-devel/files/pdns_mysql.sql')
-rw-r--r--dns/powerdns-devel/files/pdns_mysql.sql50
1 files changed, 0 insertions, 50 deletions
diff --git a/dns/powerdns-devel/files/pdns_mysql.sql b/dns/powerdns-devel/files/pdns_mysql.sql
deleted file mode 100644
index 0db1b8665734..000000000000
--- a/dns/powerdns-devel/files/pdns_mysql.sql
+++ /dev/null
@@ -1,50 +0,0 @@
-CREATE TABLE domains (
- id INT auto_increment,
- name VARCHAR(255) NOT NULL,
- type VARCHAR(6) NOT NULL,
- master VARCHAR(40) DEFAULT NULL,
- account VARCHAR(40) DEFAULT NULL,
- notified_serial INT DEFAULT NULL,
- last_check INT DEFAULT NULL,
-CONSTRAINT pk_id
- PRIMARY KEY (id),
-CONSTRAINT unq_name
- UNIQUE (name)
-) type=InnoDB;
-
-
-CREATE TABLE records (
- id INT auto_increment,
- domain_id INT DEFAULT NULL,
- name VARCHAR(255) DEFAULT NULL,
- type VARCHAR(6) DEFAULT NULL,
- ttl INT DEFAULT NULL,
- prio INT DEFAULT NULL,
- content VARCHAR(255) DEFAULT NULL,
- change_date INT DEFAULT NULL,
-CONSTRAINT pk_id
- PRIMARY KEY (id),
-CONSTRAINT fk_domainid
- FOREIGN KEY (domain_id)
- REFERENCES domains(id)
- ON UPDATE CASCADE
- ON DELETE CASCADE
-) type=InnoDB;
-
-CREATE INDEX idx_rdomainid ON records(domain_id);
-CREATE INDEX idx_rname ON records(name);
-CREATE INDEX idx_rname_rtype ON records(name,type);
-
-
-CREATE TABLE supermasters (
- ip VARCHAR(40) NOT NULL,
- nameserver VARCHAR(255) NOT NULL,
- account VARCHAR(40) DEFAULT NULL
-);
-
-CREATE INDEX idx_smip_smns ON supermasters(ip,nameserver);
-
-
-GRANT SELECT ON supermasters TO powerdns;
-GRANT ALL ON domains TO powerdns;
-GRANT ALL ON records TO powerdns;