summaryrefslogtreecommitdiff
path: root/dns/powerdns-devel/files/pdns_postgresql.sql
diff options
context:
space:
mode:
authorcvs2svn <cvs2svn@FreeBSD.org>2005-01-21 15:36:45 +0000
committercvs2svn <cvs2svn@FreeBSD.org>2005-01-21 15:36:45 +0000
commit7011c19a8c96a2f8fb7c04d61cb28cdc507584a6 (patch)
tree22c0efaf2b6bb5b461389f9bac9542c7e3a5909a /dns/powerdns-devel/files/pdns_postgresql.sql
parentNow buildable on 4.x, still broken on >= 5.x. (diff)
This commit was manufactured by cvs2svn to create tag 'RELEASE_4_11_0'.release/4.11.0
Diffstat (limited to 'dns/powerdns-devel/files/pdns_postgresql.sql')
-rw-r--r--dns/powerdns-devel/files/pdns_postgresql.sql40
1 files changed, 0 insertions, 40 deletions
diff --git a/dns/powerdns-devel/files/pdns_postgresql.sql b/dns/powerdns-devel/files/pdns_postgresql.sql
deleted file mode 100644
index c700a2aa6dc2..000000000000
--- a/dns/powerdns-devel/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;