Changeset 751 for trunk/dns-upd-1.4.1.sql

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

File:

• trunk/dns-upd-1.4.1.sql (modified) (1 diff)

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';