From e2cdc9734a84499a55f933450729533c8dfb4250 Mon Sep 17 00:00:00 2001 From: Dirk Meyer Date: Mon, 20 Jan 2003 06:10:35 +0000 Subject: PowerDNS is an advanced DNS server, which allows for several different backends. Current backends include MySQL, PostgreSQL, bind, etc. WWW: http://www.powerdns.com/ License: GPL Patches obtained from: OpenBSD --- dns/powerdns-devel/files/pdns_mysql.sql | 38 +++++++++++++++++++++++++++++++++ 1 file changed, 38 insertions(+) create mode 100644 dns/powerdns-devel/files/pdns_mysql.sql (limited to 'dns/powerdns-devel/files/pdns_mysql.sql') diff --git a/dns/powerdns-devel/files/pdns_mysql.sql b/dns/powerdns-devel/files/pdns_mysql.sql new file mode 100644 index 000000000000..278c5d56c61c --- /dev/null +++ b/dns/powerdns-devel/files/pdns_mysql.sql @@ -0,0 +1,38 @@ +create table domains ( + id INT auto_increment, + 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, + primary key (id) +)type=InnoDB; + +CREATE UNIQUE INDEX name_index ON domains(name); + +CREATE TABLE records ( + id INT auto_increment, + 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, + primary key(id) +)type=InnoDB; + +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 records TO pdns; -- cgit v1.2.3