[Pdns-users] sql schema

[Posner, Sebastian]

Thomas Andrews wrote:

> 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?
> 
> In the 'records' table, I understand what the obvious fields are, but
> what is 'domain_id', 'prio', and 'change_date' used for?
>
> Also, what is the purpose of the 'supermasters' table?

I would recommend viewing the Oracle backend's section about the database scheme

http://doc.powerdns.com/oracle.html#id559505

Most content/field names are identical; only table "domains" is called "zones" here for what I can see.


But it's a point; the backends' database schemes seem to suffer from DIC-Syndrome*.


Sebastian
*: http://www.iks-jena.de/mitarb/lutz/usenet/Fachbegriffe.der.Informatik.html#311 (german)