Changeset 300

Timestamp:

04/11/12 13:15:22 (13 years ago)

Author:

Kris Deugau

Message:

/trunk

Added missing NS records for initial default reverse zone records
Tweak metadata on NS and CNAME rectypes entries so they're available
for reverse zones
Tweak list order metadata so that NS and CNAME end up at the bottom
of the list for reverse zones
[ log fixup: see #26 ]

File:

• trunk/dns.sql (modified) (6 diffs)

trunk/dns.sql

@@ -54 +54 @@
 1       1       hostmaster.ADMINDOMAIN:ns1.ADMINDOMAIN  6       3600:900:1048576:2560   3600    
 2       1       unused-%r.ADMINDOMAIN   65283   ZONE    3600    
+3       1       DOMAIN  2       ns2.example.com 0       0       0       7200    \N
+4       1       DOMAIN  2       ns1.example.com 0       0       0       7200    \N
 \.
 
@@ -156 +158 @@
 COPY rectypes (val, name, stdflag, listorder, alphaorder) FROM stdin;
 1       A       1       1       1
-2       NS      1       5       37
+2       NS      2       9       37
 3       MD      5       255     29
 4       MF      5       255     30
-5       CNAME   1       7       9
+5       CNAME   2       11      9
 6       SOA     0       0       53
 7       MB      5       255     28
@@ -166 +168 @@
 10      NULL    5       255     43
 11      WKS     5       255     64
-12      PTR     3       10      46
+12      PTR     3       5       46
 13      HINFO   5       255     18
 14      MINFO   5       255     32
-15      MX      1       6       34
-16      TXT     1       8       60
+15      MX      1       10      34
+16      TXT     1       12      60
 17      RP      4       255     48
 18      AFSDB   5       255     4
@@ -187 +189 @@
 31      EID     5       255     15
 32      NIMLOC  5       255     36
-33      SRV     1       9       55
+33      SRV     1       13      55
 34      ATMA    5       255     6
 35      NAPTR   5       255     35
@@ -226 +228 @@
 65280   A+PTR   2       2       2
 65281   AAAA+PTR        2       4       4
-65282   PTR template    3       11      2
-65283   A+PTR template  3       12      2
-65284   AAAA+PTR template       3       13      2
+65282   PTR template    3       6       2
+65283   A+PTR template  3       7       2
+65284   AAAA+PTR template       8       13      2
 \.
 
@@ -299 +301 @@
 SELECT pg_catalog.setval('misc_misc_id_seq', 2, false);
 SELECT pg_catalog.setval('default_records_record_id_seq', 8, false);
-SELECT pg_catalog.setval('default_rev_records_record_id_seq', 3, false);
+SELECT pg_catalog.setval('default_rev_records_record_id_seq', 5, false);
 SELECT pg_catalog.setval('domains_domain_id_seq', 1, false);
 SELECT pg_catalog.setval('groups_group_id_seq', 2, false);