From e1906e85ed4521c96066ce130869615c304c2a7a Mon Sep 17 00:00:00 2001 From: Edwin Groothuis Date: Fri, 5 Sep 2003 07:41:35 +0000 Subject: Massive repo-copies request: net->dns (partly devel->dns) The category "dns" has been added, now is the time to move the dns-related ports to the new world. Is there anyone who is brave enough to complete this difficult job? ;) PR: ports/56020 Submitted by: Kimura Fuyuki Approved by: portmgr --- net/powerdns/files/pdns_postgresql.sql | 40 ---------------------------------- 1 file changed, 40 deletions(-) delete mode 100644 net/powerdns/files/pdns_postgresql.sql (limited to 'net/powerdns/files/pdns_postgresql.sql') diff --git a/net/powerdns/files/pdns_postgresql.sql b/net/powerdns/files/pdns_postgresql.sql deleted file mode 100644 index c700a2aa6dc2..000000000000 --- a/net/powerdns/files/pdns_postgresql.sql +++ /dev/null @@ -1,40 +0,0 @@ -create table domains ( - id SERIAL PRIMARY KEY, - name VARCHAR(255) NOT NULL, - master VARCHAR(20) DEFAULT NULL, - last_check INT DEFAULT NULL, - type VARCHAR(6) NOT NULL, - notified_serial INT DEFAULT NULL, - account VARCHAR(40) DEFAULT NULL -); -CREATE UNIQUE INDEX name_index ON domains(name); - -CREATE TABLE records ( - id SERIAL PRIMARY KEY, - 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, - CONSTRAINT domain_exists - FOREIGN KEY(domain_id) REFERENCES domains(id) - ON DELETE CASCADE -); - -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 -); - -GRANT SELECT ON supermasters TO pdns; -GRANT ALL ON domains TO pdns; -GRANT ALL ON domains_id_seq TO pdns; -GRANT ALL ON records TO pdns; -GRANT ALL ON records_id_seq TO pdns; -- cgit v1.2.3