Last change
on this file since 764 was 751, checked in by Kris Deugau, 8 years ago |
/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 size:
847 bytes
|
Line | |
---|
1 | -- Update formally known types from https://www.iana.org/assignments/dns-parameters/
|
---|
2 | COPY rectypes (val, name, stdflag, listorder, alphaorder) FROM stdin;
|
---|
3 | 52 TLSA 5 255 255
|
---|
4 | 53 SMIMEA 5 255 255
|
---|
5 | 56 NINFO 5 255 255
|
---|
6 | 57 RKEY 5 255 255
|
---|
7 | 58 TALINK 5 255 255
|
---|
8 | 59 CDS 5 255 255
|
---|
9 | 60 CDNSKEY 5 255 255
|
---|
10 | 61 OPENPGPKEY 5 255 255
|
---|
11 | 62 CSYNC 5 255 255
|
---|
12 | 104 NID 5 255 255
|
---|
13 | 105 L32 5 255 255
|
---|
14 | 106 L64 5 255 255
|
---|
15 | 107 LP 5 255 255
|
---|
16 | 108 EUI48 5 255 255
|
---|
17 | 109 EUI64 5 255 255
|
---|
18 | 255 * 5 255 255
|
---|
19 | 256 URI 5 255 255
|
---|
20 | 257 CAA 5 255 255
|
---|
21 | 258 AVC 5 255 255
|
---|
22 | \.
|
---|
23 |
|
---|
24 | -- Add a new pseudotype instead of overloading CNAME handling
|
---|
25 | COPY rectypes (val, name, stdflag, listorder, alphaorder) FROM stdin;
|
---|
26 | 65300 ALIAS 2 16 255
|
---|
27 | \.
|
---|
28 |
|
---|
29 | -- And add a place to cache some data for the new type
|
---|
30 | ALTER TABLE records ADD COLUMN auxdata text;
|
---|
31 |
|
---|
32 | -- Update dbversion
|
---|
33 | UPDATE misc SET value='1.4.1' WHERE key='dbversion';
|
---|
Note:
See
TracBrowser
for help on using the repository browser.