Use Comments table from PowerDNS original schema instead of custom fields.

[edmondas]

          The comments textbox in Poweradmin UI uses a different database field and table than PowerDNS. The comments table is available starting from Powerdns 3.x, but there was no such table when Poweradmin was started (PDNS 2.x at that time), so another location was created. Perhaps I should rethink how it might be changed.

Originally posted by @edmondas in #514 (comment)

[mkriegs]

Doing some upgrade script to copy conntent from old schema to PowerDNS Schema ?
UI needs to use new Content after upgrade

[darknight7]

I'm new here and I'm impressed by how polished poweradmin looks and feels. Comments are key to keep track of what is what without external tools, notebooks and so on, with poweradmin I can only write comments about zones right now while I understand powerdns supports per-record comments. I'm quite surprised that this issue doesn't attract much more traffic.
Thank you for your work so far.

[edmondas]

@darknight7 Thanks for pointing this out, but I couldn't find PowerDNS to have this feature, i.e. to store additional information (e.g. a comment) for each record. I even looked at the latest database schema and couldn't find a similar field.
https://github.com/PowerDNS/pdns/blob/master/modules/gmysqlbackend/schema.mysql.sql