> Is it possible to modify the structure of the records table, to add new fields?
You can add as many columns as you need; that will not interfere with
PowerDNS Auth operation. (You can also rename existing columns, but
you'd need to redefine the queries PowerDNS uses, so I don't recommend
you doing that.)
-JP