source: trunk/dns-upd-1.4.1.sql

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