Last change
on this file since 839 was 751, checked in by Kris Deugau, 7 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
|
Rev | Line | |
---|
[751] | 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 |
|
---|
[750] | 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 | \.
|
---|
[751] | 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.