3.1 The `soa' table
The `soa' table contains one row for each zone for which the server is
authoritative.
The default values for the various timer fields are from RFC 1537.
- `id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY' (MySQL)
- `id SERIAL NOT NULL PRIMARY KEY' (PostgreSQL)
- A unique number identifying this zone.
- `origin CHAR(255) NOT NULL' (MySQL)
- `origin VARCHAR(255) NOT NULL' (PostgreSQL)
- The name of this zone. (Unique key)
ex: example.com.
- `ns CHAR(255) NOT NULL' (MySQL)
- `ns VARCHAR(255) NOT NULL' (PostgreSQL)
- The name of the name server that was the original or primary source of data
for this zone. (meaningless to MyDNS)
ex: primary.example.com.
- `mbox CHAR(255) NOT NULL' (MySQL)
- `mbox VARCHAR(255) NOT NULL' (PostgreSQL)
- A name which specifies the mailbox of the person responsible for this zone.
This should be specified in the mailbox-as-domain-name format where the
`@' character is replaced with a dot. (meaningless to MyDNS)
ex: postmaster.example.com.
- `serial INT UNSIGNED NOT NULL DEFAULT '1'' (MySQL)
- `serial INTEGER NOT NULL DEFAULT 1' (PostgreSQL)
- A "version number" for this zone. DNS servers that rely on AXFR for zone transfers
use this to determine when updates have occurred. Popular values to use are
the Unix timestamp or a date in the form YYYYMMDD. (see section 4.4 Zone transfers).
ex: 20020529
- `refresh INT UNSIGNED NOT NULL DEFAULT '28800'' (MySQL)
- `refresh INTEGER NOT NULL DEFAULT 28800' (PostgreSQL)
- The number of seconds after which slave nameservers should check to see if
this zone has been changed. If the zone's serial number has changed, the
slave nameserver initiates a zone transfer.
(meaningless to MyDNS)
ex: 10800
- `retry INT UNSIGNED NOT NULL DEFAULT '7200'' (MySQL)
- `retry INTEGER NOT NULL DEFAULT 7200' (PostgreSQL)
- This specifies the number of seconds a slave nameserver should wait before
retrying if it attmepts to transfer this zone but fails.
(meaningless to MyDNS)
ex: 3600
- `expire INT UNSIGNED NOT NULL DEFAULT '604800'' (MySQL)
- `expire INTEGER NOT NULL DEFAULT 604800' (PostgreSQL)
- If for expire seconds the primary server cannot be reached,
all information about the zone is invalidated on the secondary
servers (i.e., they are no longer authoritative for that zone).
(meaningless to MyDNS)
ex: 60400
- `minimum INT UNSIGNED NOT NULL DEFAULT '86400'' (MySQL)
- `minimum INTEGER NOT NULL DEFAULT 86400' (PostgreSQL)
- The minimum TTL field that should be exported with any RR from this zone. If any
RR in the database has a lower TTL, this TTL is sent instead.
ex: 86400
- `ttl INT UNSIGNED NOT NULL DEFAULT '86400'' (MySQL)
- `ttl INTEGER NOT NULL DEFAULT 86400' (PostgreSQL)
- The number of seconds that this zone may be cached before the
source of the information should again be consulted. Zero values are
interpreted to mean that the zone should not be cached.
ex: 86400
