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