[Pdns-users] sql schema
Thomas Andrews
tandrews at grok.co.za
Mon Jun 27 18:01:31 UTC 2011
Hi,
Can anybody point me at some documentation about what is supposed to go
into the various fields in the db?
Specifically what is the purpose of the 'domains' table?
CREATE TABLE domains (
id INTEGER PRIMARY KEY,
name VARCHAR(255) NOT NULL,
master VARCHAR(128) DEFAULT NULL,
last_check INTEGER DEFAULT NULL,
type VARCHAR(6) NOT NULL,
notified_serial INTEGER DEFAULT NULL,
account VARCHAR(40) DEFAULT NULL
);
In the 'records' table, I understand what the obvious fields are, but
what is 'domain_id', 'prio', and 'change_date' used for?
CREATE TABLE records (
id INTEGER PRIMARY KEY,
domain_id INTEGER DEFAULT NULL,
name VARCHAR(255) DEFAULT NULL,
type VARCHAR(6) DEFAULT NULL,
content VARCHAR(255) DEFAULT NULL,
ttl INTEGER DEFAULT NULL,
prio INTEGER DEFAULT NULL,
change_date INTEGER DEFAULT NULL
);
Also, what is the purpose of the 'supermasters' table?
CREATE TABLE supermasters (
ip VARCHAR(25) NOT NULL,
nameserver VARCHAR(255) NOT NULL,
account VARCHAR(40) DEFAULT NULL
);
I am using sqlite3 as a back-end. There appears to be no web-interface
for this, so I'm wondering if these records are just a legacy from one
of the other back-ends which can interface to powerdns.
Many thanks,
Thomas
More information about the Pdns-users
mailing list