[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