Subversion Repositories oidplus

Rev

Rev 1244 | Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | RSS feed

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