Changeset 751

Timestamp:

06/01/17 16:36:44 (7 years ago)

Author:

Kris Deugau

Message:

/trunk

SQL definition updates in dns.sql and dns-upd-1.4.1.sql:

• Update IANA RR type list
• Add new ALIAS pseudotype mainly for "CNAME at domain root" support
• Add new column on records table required by new pseudotype

Location:

trunk

Files:

• dns-upd-1.4.1.sql (modified) (1 diff)
• dns.sql (modified) (6 diffs)

trunk/dns-upd-1.4.1.sql

@@ +1 @@
+-- Update formally known types from https://www.iana.org/assignments/dns-parameters/
+COPY rectypes (val, name, stdflag, listorder, alphaorder) FROM stdin;
+52      TLSA    5       255     255
+53      SMIMEA  5       255     255
+56      NINFO   5       255     255
+57      RKEY    5       255     255
+58      TALINK  5       255     255
+59      CDS     5       255     255
+60      CDNSKEY 5       255     255
+61      OPENPGPKEY      5       255     255
+62      CSYNC   5       255     255
+104     NID     5       255     255
+105     L32     5       255     255
+106     L64     5       255     255
+107     LP      5       255     255
+108     EUI48   5       255     255
+109     EUI64   5       255     255
+255     *       5       255     255
+256     URI     5       255     255
+257     CAA     5       255     255
+258     AVC     5       255     255
+\.
+
 -- Add a new pseudotype instead of overloading CNAME handling
 COPY rectypes (val, name, stdflag, listorder, alphaorder) FROM stdin;
 65300   ALIAS   2       16      255
 \.
+
+-- And add a place to cache some data for the new type
+ALTER TABLE records ADD COLUMN auxdata text;
+
+-- Update dbversion
+UPDATE misc SET value='1.4.1' WHERE key='dbversion';

trunk/dns.sql

@@ -191 +191 @@
     stamp TIMESTAMP WITH TIME ZONE DEFAULT 'epoch' NOT NULL,
     expires boolean DEFAULT 'n' NOT NULL,
-    stampactive boolean DEFAULT 'n' NOT NULL
+    stampactive boolean DEFAULT 'n' NOT NULL,
+    auxdata text
 );
 CREATE INDEX rec_domain_index ON records USING btree (domain_id);
@@ -206 +207 @@
 
 -- Types are required.  NB:  these are vaguely read-only too
--- data from http://www.iana.org/assignments/dns-parameters
+-- data from https://www.iana.org/assignments/dns-parameters
 COPY rectypes (val, name, stdflag, listorder, alphaorder) FROM stdin;
 1       A       1       1       1
@@ -259 +260 @@
 50      NSEC3   5       255     41
 51      NSEC3PARAM      5       255     42
+52      TLSA    5       255     255
+53      SMIMEA  5       255     255
 55      HIP     5       255     19
+56      NINFO   5       255     255
+57      RKEY    5       255     255
+58      TALINK  5       255     255
+59      CDS     5       255     255
+60      CDNSKEY 5       255     255
+61      OPENPGPKEY      5       255     255
+62      CSYNC   5       255     255
 99      SPF     5       255     54
 100     UINFO   5       255     62
@@ -265 +275 @@
 102     GID     5       255     16
 103     UNSPEC  5       255     63
+104     NID     5       255     255
+105     L32     5       255     255
+106     L64     5       255     255
+107     LP      5       255     255
+108     EUI48   5       255     255
+109     EUI64   5       255     255
 249     TKEY    5       255     58
 250     TSIG    5       255     59
@@ -271 +287 @@
 253     MAILB   5       255     27
 254     MAILA   5       255     26
+255     *       5       255     255
+256     URI     5       255     255
+257     CAA     5       255     255
+258     AVC     5       255     255
 32768   TA      5       255     57
 32769   DLV     5       255     11
@@ -283 +303 @@
 65284   AAAA+PTR template       2       8       2
 65285   Delegation      2       9       2
+65300   ALIAS   2       15      255
 \.