1 files changed, 0 insertions, 52 deletions
diff --git a/dns/powerdns-devel/files/pdns_postgresql.sql b/dns/powerdns-devel/files/pdns_postgresql.sql
deleted file mode 100644
index 481cc98b21b6..000000000000
--- a/dns/powerdns-devel/files/pdns_postgresql.sql
+++ /dev/null
@@ -1,52 +0,0 @@
-CREATE TABLE domains (
-	id SERIAL,
-	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)
-);
-
-
-CREATE TABLE records (
-	id SERIAL,
-	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
-);
-
-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 domains_id_seq TO powerdns;
-GRANT ALL ON records TO powerdns;
-GRANT ALL ON records_id_seq TO powerdns;