3.2 The `rr' table
The `rr' table contains all non-SOA resource record types.
It has a unique key on the combination of zone, name, type, and data.
- `id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY' (MySQL)
- `id SERIAL NOT NULL PRIMARY KEY' (PostgreSQL)
- A unique number identifying this record.
- `zone INT UNSIGNED NOT NULL' (MySQL)
- `zone INTEGER NOT NULL' (PostgreSQL)
- The ID of the zone (from the `soa' table) to which this resource record belongs. (see section 3.1 The `soa' table).
For PostgreSQL databases, this column is also created with `FOREIGN KEY (zone) REFERENCES soa (id) ON DELETE CASCADE'.
- `name CHAR(64) NOT NULL' (MySQL)
- `name VARCHAR(64) NOT NULL' (PostgreSQL)
- The name that this RR describes. Wildcard values such as `*' or `*.sub' are
supported, and this field can contain a FQDN or just a hostname. It may contain
out-of-zone data if this is a glue record.
ex: foo
ex: foo.example.com.
- `type ENUM('A','AAAA','CNAME','HINFO','MX','NS','PTR','RP','SRV','TXT') NOT NULL' (MySQL)
- `type VARCHAR(5) NOT NULL CHECK (type='A' OR type='AAAA' OR type='CNAME' OR type='HINFO' OR type='MX' OR type='NS' OR type='PTR' OR type='RP' OR type='SRV' OR type='TXT')' (PostgreSQL)
- The type of resource record. (see section 3.3 Supported RR types).
- `data CHAR(128) NOT NULL' (MySQL)
- `data VARCHAR(128) NOT NULL' (PostgreSQL)
- The data associated with this resource record. See section 3.3 Supported RR types for
specifications and examples of the type of data each record type should contain.
- `aux INT UNSIGNED NOT NULL' (MySQL)
- `aux INTEGER NOT NULL default 0' (PostgreSQL)
- An auxillary numeric value in addition to data. For `MX' records,
this field specifies the preference. For `SRV' records, this field
specifies the priority.
- `ttl INT UNSIGNED NOT NULL DEFAULT '86400'' (MySQL)
- `ttl INTEGER NOT NULL default 86400' (PostgreSQL)
- The time interval that this resource record may be cached before the
source of the information should again be consulted. Zero values are
interpreted to mean that the RR can only be used for the transaction
in progress, and should not be cached.
