Rev 1244 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed
Rev | Author | Line No. | Line |
---|---|---|---|
1244 | daniel-mar | 1 | -- This file (wellknown_other_mssql.sql) contains ASN.1 and IRI names of OIDs which are either |
2 | -- a) Root OIDs |
||
3 | -- b) Unicode labels which are long arcs |
||
4 | -- c) Standardized ASN.1 identifiers |
||
5 | -- d) OIDs where potential users of this software can register OIDs in these arcs (e.g. an "identified organization" arc) |
||
6 | -- Use the tool dev/generate_wellknown_other_mssql to generate this file |
||
7 | |||
8 | SET ANSI_PADDING ON |
||
9 | GO |
||
10 | |||
11 | -- 0 |
||
12 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:0', 'itu-t', '1', '1'); |
||
13 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:0', 'ccitt', '1', '1'); |
||
14 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:0', 'itu-r', '0', '1'); |
||
15 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:0', 'ITU-T', '0', '1'); |
||
16 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:0', 'ITU-R', '0', '1'); |
||
17 | |||
18 | -- 0.0 |
||
19 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:0.0', 'recommendation', '0', '1'); |
||
20 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:0.0', 'Recommendation', '0', '1'); |
||
21 | |||
22 | -- 0.0.1 |
||
23 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:0.0.1', 'a', '1', '1'); |
||
24 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:0.0.1', 'A', '0', '1'); |
||
25 | |||
26 | -- 0.0.2 |
||
27 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:0.0.2', 'b', '1', '1'); |
||
28 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:0.0.2', 'B', '0', '1'); |
||
29 | |||
30 | -- 0.0.3 |
||
31 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:0.0.3', 'c', '1', '1'); |
||
32 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:0.0.3', 'C', '0', '1'); |
||
33 | |||
34 | -- 0.0.4 |
||
35 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:0.0.4', 'd', '1', '1'); |
||
36 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:0.0.4', 'D', '0', '1'); |
||
37 | |||
38 | -- 0.0.5 |
||
39 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:0.0.5', 'e', '1', '1'); |
||
40 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:0.0.5', 'E', '0', '1'); |
||
41 | |||
42 | -- 0.0.6 |
||
43 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:0.0.6', 'f', '1', '1'); |
||
44 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:0.0.6', 'F', '0', '1'); |
||
45 | |||
46 | -- 0.0.7 |
||
47 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:0.0.7', 'g', '1', '1'); |
||
48 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:0.0.7', 'G', '0', '1'); |
||
49 | |||
50 | -- 0.0.8 |
||
51 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:0.0.8', 'h', '1', '1'); |
||
52 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:0.0.8', 'H', '0', '1'); |
||
53 | |||
54 | -- 0.0.9 |
||
55 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:0.0.9', 'i', '1', '1'); |
||
56 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:0.0.9', 'I', '0', '1'); |
||
57 | |||
58 | -- 0.0.10 |
||
59 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:0.0.10', 'j', '1', '1'); |
||
60 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:0.0.10', 'J', '0', '1'); |
||
61 | |||
62 | -- 0.0.11 |
||
63 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:0.0.11', 'k', '1', '1'); |
||
64 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:0.0.11', 'K', '0', '1'); |
||
65 | |||
66 | -- 0.0.12 |
||
67 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:0.0.12', 'l', '1', '1'); |
||
68 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:0.0.12', 'L', '0', '1'); |
||
69 | |||
70 | -- 0.0.13 |
||
71 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:0.0.13', 'm', '1', '1'); |
||
72 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:0.0.13', 'M', '0', '1'); |
||
73 | |||
74 | -- 0.0.14 |
||
75 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:0.0.14', 'n', '1', '1'); |
||
76 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:0.0.14', 'N', '0', '1'); |
||
77 | |||
78 | -- 0.0.15 |
||
79 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:0.0.15', 'o', '1', '1'); |
||
80 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:0.0.15', 'O', '0', '1'); |
||
81 | |||
82 | -- 0.0.16 |
||
83 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:0.0.16', 'p', '1', '1'); |
||
84 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:0.0.16', 'P', '0', '1'); |
||
85 | |||
86 | -- 0.0.17 |
||
87 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:0.0.17', 'q', '1', '1'); |
||
88 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:0.0.17', 'Q', '0', '1'); |
||
89 | |||
90 | -- 0.0.18 |
||
91 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:0.0.18', 'r', '1', '1'); |
||
92 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:0.0.18', 'R', '0', '1'); |
||
93 | |||
94 | -- 0.0.19 |
||
95 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:0.0.19', 's', '1', '1'); |
||
96 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:0.0.19', 'S', '0', '1'); |
||
97 | |||
98 | -- 0.0.20 |
||
99 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:0.0.20', 't', '1', '1'); |
||
100 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:0.0.20', 'T', '0', '1'); |
||
101 | |||
102 | -- 0.0.21 |
||
103 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:0.0.21', 'u', '1', '1'); |
||
104 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:0.0.21', 'U', '0', '1'); |
||
105 | |||
106 | -- 0.0.22 |
||
107 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:0.0.22', 'v', '1', '1'); |
||
108 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:0.0.22', 'V', '0', '1'); |
||
109 | |||
110 | -- 0.0.23 |
||
111 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:0.0.23', 'w', '1', '1'); |
||
112 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:0.0.23', 'W', '0', '1'); |
||
113 | |||
114 | -- 0.0.24 |
||
115 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:0.0.24', 'x', '1', '1'); |
||
116 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:0.0.24', 'X', '0', '1'); |
||
117 | |||
118 | -- 0.0.25 |
||
119 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:0.0.25', 'y', '1', '1'); |
||
120 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:0.0.25', 'Y', '0', '1'); |
||
121 | |||
122 | -- 0.0.26 |
||
123 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:0.0.26', 'z', '1', '1'); |
||
124 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:0.0.26', 'Z', '0', '1'); |
||
125 | |||
126 | -- 0.1 |
||
127 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:0.1', 'question', '1', '1'); |
||
128 | |||
129 | -- 0.2 |
||
130 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:0.2', 'administration', '1', '1'); |
||
131 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:0.2', 'Administration', '0', '1'); |
||
132 | |||
133 | -- 0.3 |
||
134 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:0.3', 'network-operator', '1', '1'); |
||
135 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:0.3', 'Network-Operator', '0', '1'); |
||
136 | |||
137 | -- 0.4 |
||
138 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:0.4', 'identified-organization', '1', '1'); |
||
139 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:0.4', 'Identified-Organization', '0', '1'); |
||
140 | |||
141 | -- 0.4.0 |
||
142 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:0.4.0', 'etsi', '0', '1'); |
||
143 | |||
144 | -- 0.4.0.127 |
||
145 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:0.4.0.127', 'reserved', '0', '1'); |
||
146 | |||
147 | -- 0.4.0.127.0 |
||
148 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:0.4.0.127.0', 'etsi-identified-organization', '0', '1'); |
||
149 | |||
150 | -- 1 |
||
151 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:1', 'iso', '1', '1'); |
||
152 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:1', 'ISO', '0', '1'); |
||
153 | |||
154 | -- 1.0 |
||
155 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:1.0', 'standard', '0', '1'); |
||
156 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:1.0', 'Standard', '0', '1'); |
||
157 | |||
158 | -- 1.1 |
||
159 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:1.1', 'registration-authority', '1', '1'); |
||
160 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:1.1', 'Registration-Authority', '0', '1'); |
||
161 | |||
162 | -- 1.1.19785 |
||
163 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:1.1.19785', 'cbeff', '0', '1'); |
||
164 | |||
165 | -- 1.1.19785.0 |
||
166 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:1.1.19785.0', 'biometric-organization', '0', '1'); |
||
167 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:1.1.19785.0', 'organization', '0', '1'); |
||
168 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:1.1.19785.0', 'organizations', '0', '1'); |
||
169 | |||
170 | -- 1.2 |
||
171 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:1.2', 'member-body', '1', '1'); |
||
172 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:1.2', 'Member-Body', '0', '1'); |
||
173 | |||
174 | -- 1.2.276.0 |
||
175 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:1.2.276.0', 'din-certco', '0', '1'); |
||
176 | |||
177 | -- 1.2.616.1 |
||
178 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:1.2.616.1', 'organization', '0', '1'); |
||
179 | |||
180 | -- 1.2.826.0 |
||
181 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:1.2.826.0', 'national', '0', '1'); |
||
182 | |||
183 | -- 1.2.826.0.1 |
||
184 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:1.2.826.0.1', 'eng-ltd', '0', '1'); |
||
185 | |||
186 | -- 1.2.840.1 |
||
187 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:1.2.840.1', 'organization', '0', '1'); |
||
188 | |||
189 | -- 1.2.840.113556 |
||
190 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:1.2.840.113556', 'microsoft', '0', '1'); |
||
191 | |||
192 | -- 1.2.840.113556.2 |
||
193 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:1.2.840.113556.2', 'dicom', '0', '1'); |
||
194 | |||
195 | -- 1.3 |
||
196 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:1.3', 'identified-organization', '1', '1'); |
||
197 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:1.3', 'Identified-Organization', '0', '1'); |
||
198 | |||
199 | -- 1.3.6 |
||
200 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:1.3.6', 'dod', '0', '1'); |
||
201 | |||
202 | -- 1.3.6.1 |
||
203 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:1.3.6.1', 'internet', '0', '1'); |
||
204 | |||
205 | -- 1.3.6.1.2 |
||
206 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:1.3.6.1.2', 'mgmt', '0', '1'); |
||
207 | |||
208 | -- 1.3.6.1.2.1 |
||
209 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:1.3.6.1.2.1', 'mib-2', '0', '1'); |
||
210 | |||
211 | -- 1.3.6.1.4 |
||
212 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:1.3.6.1.4', 'private', '0', '1'); |
||
213 | |||
214 | -- 1.3.6.1.4.1 |
||
215 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:1.3.6.1.4.1', 'enterprise', '0', '1'); |
||
216 | |||
217 | -- 1.3.6.1.4.1.12798.1 |
||
218 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:1.3.6.1.4.1.12798.1', 'member', '0', '1'); |
||
219 | |||
220 | -- 1.3.6.1.4.1.37476.9000 |
||
221 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:1.3.6.1.4.1.37476.9000', 'freeoid', '0', '1'); |
||
222 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:1.3.6.1.4.1.37476.9000', 'freesub', '0', '1'); |
||
223 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:1.3.6.1.4.1.37476.9000', 'FreeOID', '0', '1'); |
||
224 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:1.3.6.1.4.1.37476.9000', 'FreeSub', '0', '1'); |
||
225 | |||
226 | -- 1.3.6.1.4.1.37553.8 |
||
227 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:1.3.6.1.4.1.37553.8', 'weid', '0', '1'); |
||
228 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:1.3.6.1.4.1.37553.8', 'weid', '0', '1'); |
||
229 | |||
230 | -- 1.3.6.1.4.1.37553.8.8 |
||
231 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:1.3.6.1.4.1.37553.8.8', 'private-weid', '0', '1'); |
||
232 | |||
233 | -- 1.3.6.1.4.1.37553.8.9 |
||
234 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:1.3.6.1.4.1.37553.8.9', 'ns', '0', '1'); |
||
235 | |||
236 | -- 1.3.6.1.4.1.37553.8.9.17704 |
||
237 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:1.3.6.1.4.1.37553.8.9.17704', 'dns', '0', '1'); |
||
238 | |||
239 | -- 1.3.6.1.4.1.37553.8.9.1439221 |
||
240 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:1.3.6.1.4.1.37553.8.9.1439221', 'uuid', '0', '1'); |
||
241 | |||
242 | -- 2 |
||
243 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:2', 'joint-iso-itu-t', '1', '1'); |
||
244 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:2', 'joint-iso-ccitt', '1', '1'); |
||
245 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:2', 'Joint-ISO-ITU-T', '0', '1'); |
||
246 | |||
247 | -- 2.1 |
||
248 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:2.1', 'asn1', '0', '1'); |
||
249 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:2.1', 'ASN.1', '1', '1'); |
||
250 | |||
251 | -- 2.16 |
||
252 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:2.16', 'country', '0', '1'); |
||
253 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:2.16', 'Country', '1', '1'); |
||
254 | |||
255 | -- 2.16.158.1 |
||
256 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:2.16.158.1', 'organization', '0', '1'); |
||
257 | |||
258 | -- 2.16.344.1 |
||
259 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:2.16.344.1', 'organization', '0', '1'); |
||
260 | |||
261 | -- 2.16.840.1 |
||
262 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:2.16.840.1', 'organization', '0', '1'); |
||
263 | |||
264 | -- 2.16.840.1.113883 |
||
265 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:2.16.840.1.113883', 'hl7', '0', '1'); |
||
266 | |||
267 | -- 2.16.840.1.113883.3 |
||
268 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:2.16.840.1.113883.3', 'externalUseRoots', '0', '1'); |
||
269 | |||
270 | -- 2.16.840.1.113883.6 |
||
271 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:2.16.840.1.113883.6', 'externalCodeSystems', '0', '1'); |
||
272 | |||
273 | -- 2.16.840.1.113883.13 |
||
274 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:2.16.840.1.113883.13', 'externalValueSets', '0', '1'); |
||
275 | |||
276 | -- 2.23 |
||
277 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:2.23', 'international-organizations', '0', '1'); |
||
278 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:2.23', 'International-Organizations', '1', '1'); |
||
279 | |||
280 | -- 2.25 |
||
281 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:2.25', 'uuid', '0', '1'); |
||
282 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:2.25', 'UUID', '1', '1'); |
||
283 | |||
284 | -- 2.27 |
||
285 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:2.27', 'tag-based', '0', '1'); |
||
286 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:2.27', 'nid', '0', '1'); |
||
287 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:2.27', 'Tag-Based', '1', '1'); |
||
288 | |||
289 | -- 2.40 |
||
290 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:2.40', 'upu', '0', '1'); |
||
291 | |||
292 | -- 2.40.2 |
||
293 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:2.40.2', 'member-body', '0', '1'); |
||
294 | |||
295 | -- 2.40.3 |
||
296 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:2.40.3', 'identified-organization', '0', '1'); |
||
297 | |||
298 | -- 2.41 |
||
299 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:2.41', 'bip', '0', '1'); |
||
300 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:2.41', 'BIP', '1', '1'); |
||
301 | |||
302 | -- 2.42 |
||
303 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:2.42', 'telebiometrics', '0', '1'); |
||
304 | |||
305 | -- 2.48 |
||
306 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:2.48', 'cybersecurity', '0', '1'); |
||
307 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:2.48', 'Cybersecurity', '1', '1'); |
||
308 | |||
309 | -- 2.49 |
||
310 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:2.49', 'alerting', '0', '1'); |
||
311 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:2.49', 'Alerting', '1', '1'); |
||
312 | |||
313 | -- 2.49.0 |
||
314 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:2.49.0', 'wmo', '0', '1'); |
||
315 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:2.49.0', 'WMO', '0', '1'); |
||
316 | |||
317 | -- 2.49.0.0 |
||
318 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:2.49.0.0', 'authority', '0', '1'); |
||
319 | |||
320 | -- 2.49.0.1 |
||
321 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:2.49.0.1', 'country-msg', '0', '1'); |
||
322 | |||
323 | -- 2.49.0.2 |
||
324 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:2.49.0.2', 'org', '0', '1'); |
||
325 | |||
326 | -- 2.49.0.3 |
||
327 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:2.49.0.3', 'org-msg', '0', '1'); |
||
328 | |||
329 | -- 2.50 |
||
330 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:2.50', 'ors', '0', '1'); |
||
331 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:2.50', 'ORS', '1', '1'); |
||
332 | |||
333 | -- 2.51 |
||
334 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:2.51', 'gs1', '0', '1'); |
||
335 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:2.51', 'GS1', '1', '1'); |
||
336 | |||
337 | -- 2.999 |
||
338 | INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:2.999', 'example', '0', '1'); |
||
339 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:2.999', 'Example', '1', '1'); |
||
340 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:2.999', 'Exemple', '1', '1'); |
||
341 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:2.999', 'Ejemplo', '1', '1'); |
||
342 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:2.999', CAST(CAST(N'' AS XML).value('xs:base64Binary("2KfZhNmF2KvYp9mE")', 'varbinary(MAX)') AS VARCHAR(255)), '1', '1'); |
||
343 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:2.999', CAST(CAST(N'' AS XML).value('xs:base64Binary("6IyD5L6L")', 'varbinary(MAX)') AS VARCHAR(255)), '1', '1'); |
||
344 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:2.999', CAST(CAST(N'' AS XML).value('xs:base64Binary("0J/RgNC40LzQtdGA")', 'varbinary(MAX)') AS VARCHAR(255)), '1', '1'); |
||
345 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:2.999', CAST(CAST(N'' AS XML).value('xs:base64Binary("7JiI7KCc")', 'varbinary(MAX)') AS VARCHAR(255)), '1', '1'); |
||
346 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:2.999', CAST(CAST(N'' AS XML).value('xs:base64Binary("5L6L")', 'varbinary(MAX)') AS VARCHAR(255)), '1', '1'); |
||
347 | INSERT INTO [iri] (oid, name, longarc, well_known) VALUES ('oid:2.999', 'Beispiel', '1', '1'); |
||
348 | |||
1367 | daniel-mar | 349 | -- Generator "generate_wellknown_other_mssql" checksum 55f8f00d |