[Pdns-users] SQL implementation questions

[Martin Kuchar]

The SOA record is as full text line recorded in one cell. Is this good
choice ? It can not be better to have serial, refresh, retry, expire and
minimum in separate columns or rows ? Its hard to parse and can be hole for
future editing.

Anybody know, how to get soa serial in one mysql select command ??

There is TTL column in SOA row. It is used for something, or the TTL in SOA
text line is sufficient ?

There are TTL columns for each records too. Are the TTL here used too, or is
used the one from SOA line ? Can be TTL of record independent to TTL from
SOA line ?

The prio column can be used to any records ? I know them only with MX, but
it works for NS too ? Can this be used for A too ???

best regards,
Martin Kuchar