The default database name is mydns
, although a different name may be
specified by using the database
variable in mydns.conf
.
The MyDNS source code always specifies each column name explicitly when it's
doing queries, so go ahead and add as many custom columns to the MySQL tables
that you want. For example, you could put username
and password
columns in the soa
table if you wanted, or a comments
column
in the ptr
table.
The table layouts described here are for the tables created on a MySQL
database. If you're using PostgreSQL, the fields are pretty much the same;
however, the field types are slightly different. You can run
mydns --create-tables
to see the exact table structures.