1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
|
CREATE TABLE "domains" (
"id" SERIAL NOT NULL,
"name" VARCHAR(255) NOT NULL,
"type" VARCHAR(6) NOT NULL,
"master" VARCHAR(40) NOT NULL DEFAULT '',
"account" VARCHAR(40) NOT NULL DEFAULT '',
"notified_serial" INTEGER DEFAULT NULL,
"last_check" INTEGER DEFAULT NULL,
"status" CHAR(1) NOT NULL DEFAULT 'A',
CONSTRAINT "pk_domains_id"
PRIMARY KEY ("id"),
CONSTRAINT "unq_domains_name"
UNIQUE ("name")
);
CREATE INDEX "idx_domains_status_type" ON "domains" ("status","type");
CREATE TABLE "records" (
"id" SERIAL NOT NULL,
"domain_id" INTEGER NOT NULL,
"name" VARCHAR(255) NOT NULL,
"type" VARCHAR(6) NOT NULL,
"ttl" INTEGER DEFAULT NULL,
"prio" INTEGER DEFAULT NULL,
"content" VARCHAR(255) NOT NULL,
"change_date" INTEGER DEFAULT NULL,
CONSTRAINT "pk_records_id"
PRIMARY KEY ("id"),
CONSTRAINT "fk_records_domainid"
FOREIGN KEY ("domain_id")
REFERENCES domains ("id")
ON UPDATE CASCADE
ON DELETE CASCADE
);
CREATE INDEX "idx_records_name_type" ON "records" ("name","type");
CREATE INDEX "idx_records_type" ON "records" ("type");
CREATE TABLE "supermasters" (
"ip" VARCHAR(40) NOT NULL,
"nameserver" VARCHAR(255) NOT NULL,
"account" VARCHAR(40) NOT NULL DEFAULT ''
);
CREATE INDEX "idx_smaster_ip_ns" 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";
|
