From e1906e85ed4521c96066ce130869615c304c2a7a Mon Sep 17 00:00:00 2001
From: Edwin Groothuis <edwin@FreeBSD.org>
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 <fuyuki@nigredo.org>
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

