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_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.  
  349. -- Generator "generate_wellknown_other_mssql" checksum 55f8f00d
  350.