Table Definition - DNSZone
Submitted by Synthetic Dreams on Fri, 08/15/2014 - 15:13
| Field | Type | Read-only | Description |
|---|---|---|---|
| ID | Integer | Yes | Primary Key (unique ID) for row |
| Name | Char | Yes* | Domain name / Network Address. *Must be specified for INSERT statements |
| Reverse | Integer | Yes | Reverse Lookup Zone (0 = No, 1 = Yes) |
| Type | Integer | Yes | Zone type (1 = Primary, 2 = Secondary, 3 = Stub) |
| DSIntegrated | Integer | Yes* | Zone is Active Directory integrated (0 = No, 1 = Yes). *Must be specified for INSERT statements |
| Scavenge | Integer | Yes | Stale resource record scavenging active (0 = No, 1 = Yes) |
| ScavengeNoRefresh | Integer | No | Scavenging no-refresh interval (in seconds) |
| ScavengeRefresh | Integer | No | Scavenging refresh interval (in seconds) |
| FileName | Char | Yes | Zone file name |
| Master | Char | Yes | Master server (for secondary and stub type zones. NULL for primary zones) |
| Paused | Integer | No | Zone is paused (0 = No, 1 = Yes) |
Usage Notes
- INSERT and DELETE statements run against the 'DNSZone' table will create and delete DNS zones on the target server, respectively
- As noted, the 'Name' and 'DSIntegrated' fields must be specified, at minimum, for INSERT statements. Any non read-only field may also be specified in INSERT statements to be applied to newly created zones
- To INSERT a reverse lookup zone, name should be formatted in reverse format with "in-addr.arpa" TLD suffix. E.g. "0.168.192.in-addr.arpa" for the 192.168.0/24 network
- INSERT statements run against the 'DNSZone' table will create the corresponding domain entry in the 'DNSDomain' table
- DELETE statements run against the 'DNSZone' table will delete corresponding entries in the 'DNSDomain' and 'DNSRecord' tables
