Advertisement
Guest User

Untitled

a guest
Aug 28th, 2015
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.39 KB | None | 0 0
  1. --
  2. -- SCRIPT [AddCountries]
  3. --
  4. INSERT INTO Core.Countries (Code, Name) VALUES
  5. ('AD', 'Andorra'),
  6. ('AE', 'United Arab Emirates'),
  7. ('AF', 'Afghanistan'),
  8. ('AG', 'Antigua and Barbuda'),
  9. ('AI', 'Anguilla'),
  10. ('AL', 'Albania'),
  11. ('AM', 'Armenia'),
  12. ('AO', 'Angola'),
  13. ('AQ', 'Antarctica'),
  14. ('AR', 'Argentina'),
  15. ('AS', 'American Samoa'),
  16. ('AT', 'Austria'),
  17. ('AU', 'Australia'),
  18. ('AW', 'Aruba'),
  19. ('AX', 'Åland'),
  20. ('AZ', 'Azerbaijan'),
  21. ('BA', 'Bosnia and Herzegovina'),
  22. ('BB', 'Barbados'),
  23. ('BD', 'Bangladesh'),
  24. ('BE', 'Belgium'),
  25. ('BF', 'Burkina Faso'),
  26. ('BG', 'Bulgaria'),
  27. ('BH', 'Bahrain'),
  28. ('BI', 'Burundi'),
  29. ('BJ', 'Benin'),
  30. ('BL', 'Saint Barthélemy'),
  31. ('BM', 'Bermuda'),
  32. ('BN', 'Brunei'),
  33. ('BO', 'Bolivia'),
  34. ('BQ', 'Bonaire'),
  35. ('BR', 'Brazil'),
  36. ('BS', 'Bahamas'),
  37. ('BT', 'Bhutan'),
  38. ('BV', 'Bouvet Island'),
  39. ('BW', 'Botswana'),
  40. ('BY', 'Belarus'),
  41. ('BZ', 'Belize'),
  42. ('CA', 'Canada'),
  43. ('CC', 'Cocos [Keeling] Islands'),
  44. ('CD', 'Democratic Republic of the Congo'),
  45. ('CF', 'Central African Republic'),
  46. ('CG', 'Republic of the Congo'),
  47. ('CH', 'Switzerland'),
  48. ('CI', 'Ivory Coast'),
  49. ('CK', 'Cook Islands'),
  50. ('CL', 'Chile'),
  51. ('CM', 'Cameroon'),
  52. ('CN', 'China'),
  53. ('CO', 'Colombia'),
  54. ('CR', 'Costa Rica'),
  55. ('CU', 'Cuba'),
  56. ('CV', 'Cape Verde'),
  57. ('CW', 'Curacao'),
  58. ('CX', 'Christmas Island'),
  59. ('CY', 'Cyprus'),
  60. ('CZ', 'Czech Republic'),
  61. ('DE', 'Germany'),
  62. ('DJ', 'Djibouti'),
  63. ('DK', 'Denmark'),
  64. ('DM', 'Dominica'),
  65. ('DO', 'Dominican Republic'),
  66. ('DZ', 'Algeria'),
  67. ('EC', 'Ecuador'),
  68. ('EE', 'Estonia'),
  69. ('EG', 'Egypt'),
  70. ('EH', 'Western Sahara'),
  71. ('ER', 'Eritrea'),
  72. ('ES', 'Spain'),
  73. ('ET', 'Ethiopia'),
  74. ('FI', 'Finland'),
  75. ('FJ', 'Fiji'),
  76. ('FK', 'Falkland Islands'),
  77. ('FM', 'Micronesia'),
  78. ('FO', 'Faroe Islands'),
  79. ('FR', 'France'),
  80. ('GA', 'Gabon'),
  81. ('GB', 'United Kingdom'),
  82. ('GD', 'Grenada'),
  83. ('GE', 'Georgia'),
  84. ('GF', 'French Guiana'),
  85. ('GG', 'Guernsey'),
  86. ('GH', 'Ghana'),
  87. ('GI', 'Gibraltar'),
  88. ('GL', 'Greenland'),
  89. ('GM', 'Gambia'),
  90. ('GN', 'Guinea'),
  91. ('GP', 'Guadeloupe'),
  92. ('GQ', 'Equatorial Guinea'),
  93. ('GR', 'Greece'),
  94. ('GS', 'South Georgia and the South Sandwich Islands'),
  95. ('GT', 'Guatemala'),
  96. ('GU', 'Guam'),
  97. ('GW', 'Guinea-Bissau'),
  98. ('GY', 'Guyana'),
  99. ('HK', 'Hong Kong'),
  100. ('HM', 'Heard Island and McDonald Islands'),
  101. ('HN', 'Honduras'),
  102. ('HR', 'Croatia'),
  103. ('HT', 'Haiti'),
  104. ('HU', 'Hungary'),
  105. ('ID', 'Indonesia'),
  106. ('IE', 'Ireland'),
  107. ('IL', 'Israel'),
  108. ('IM', 'Isle of Man'),
  109. ('IN', 'India'),
  110. ('IO', 'British Indian Ocean Territory'),
  111. ('IQ', 'Iraq'),
  112. ('IR', 'Iran'),
  113. ('IS', 'Iceland'),
  114. ('IT', 'Italy'),
  115. ('JE', 'Jersey'),
  116. ('JM', 'Jamaica'),
  117. ('JO', 'Jordan'),
  118. ('JP', 'Japan'),
  119. ('KE', 'Kenya'),
  120. ('KG', 'Kyrgyzstan'),
  121. ('KH', 'Cambodia'),
  122. ('KI', 'Kiribati'),
  123. ('KM', 'Comoros'),
  124. ('KN', 'Saint Kitts and Nevis'),
  125. ('KP', 'North Korea'),
  126. ('KR', 'South Korea'),
  127. ('KW', 'Kuwait'),
  128. ('KY', 'Cayman Islands'),
  129. ('KZ', 'Kazakhstan'),
  130. ('LA', 'Laos'),
  131. ('LB', 'Lebanon'),
  132. ('LC', 'Saint Lucia'),
  133. ('LI', 'Liechtenstein'),
  134. ('LK', 'Sri Lanka'),
  135. ('LR', 'Liberia'),
  136. ('LS', 'Lesotho'),
  137. ('LT', 'Lithuania'),
  138. ('LU', 'Luxembourg'),
  139. ('LV', 'Latvia'),
  140. ('LY', 'Libya'),
  141. ('MA', 'Morocco'),
  142. ('MC', 'Monaco'),
  143. ('MD', 'Moldova'),
  144. ('ME', 'Montenegro'),
  145. ('MF', 'Saint Martin'),
  146. ('MG', 'Madagascar'),
  147. ('MH', 'Marshall Islands'),
  148. ('MK', 'Macedonia'),
  149. ('ML', 'Mali'),
  150. ('MM', 'Myanmar [Burma]'),
  151. ('MN', 'Mongolia'),
  152. ('MO', 'Macao'),
  153. ('MP', 'Northern Mariana Islands'),
  154. ('MQ', 'Martinique'),
  155. ('MR', 'Mauritania'),
  156. ('MS', 'Montserrat'),
  157. ('MT', 'Malta'),
  158. ('MU', 'Mauritius'),
  159. ('MV', 'Maldives'),
  160. ('MW', 'Malawi'),
  161. ('MX', 'Mexico'),
  162. ('MY', 'Malaysia'),
  163. ('MZ', 'Mozambique'),
  164. ('NA', 'Namibia'),
  165. ('NC', 'New Caledonia'),
  166. ('NE', 'Niger'),
  167. ('NF', 'Norfolk Island'),
  168. ('NG', 'Nigeria'),
  169. ('NI', 'Nicaragua'),
  170. ('NL', 'Netherlands'),
  171. ('NO', 'Norway'),
  172. ('NP', 'Nepal'),
  173. ('NR', 'Nauru'),
  174. ('NU', 'Niue'),
  175. ('NZ', 'New Zealand'),
  176. ('OM', 'Oman'),
  177. ('PA', 'Panama'),
  178. ('PE', 'Peru'),
  179. ('PF', 'French Polynesia'),
  180. ('PG', 'Papua New Guinea'),
  181. ('PH', 'Philippines'),
  182. ('PK', 'Pakistan'),
  183. ('PL', 'Poland'),
  184. ('PM', 'Saint Pierre and Miquelon'),
  185. ('PN', 'Pitcairn Islands'),
  186. ('PR', 'Puerto Rico'),
  187. ('PS', 'Palestine'),
  188. ('PT', 'Portugal'),
  189. ('PW', 'Palau'),
  190. ('PY', 'Paraguay'),
  191. ('QA', 'Qatar'),
  192. ('RE', 'Réunion'),
  193. ('RO', 'Romania'),
  194. ('RS', 'Serbia'),
  195. ('RU', 'Russia'),
  196. ('RW', 'Rwanda'),
  197. ('SA', 'Saudi Arabia'),
  198. ('SB', 'Solomon Islands'),
  199. ('SC', 'Seychelles'),
  200. ('SD', 'Sudan'),
  201. ('SE', 'Sweden'),
  202. ('SG', 'Singapore'),
  203. ('SH', 'Saint Helena'),
  204. ('SI', 'Slovenia'),
  205. ('SJ', 'Svalbard and Jan Mayen'),
  206. ('SK', 'Slovakia'),
  207. ('SL', 'Sierra Leone'),
  208. ('SM', 'San Marino'),
  209. ('SN', 'Senegal'),
  210. ('SO', 'Somalia'),
  211. ('SR', 'Suriname'),
  212. ('SS', 'South Sudan'),
  213. ('ST', 'São Tomé and Príncipe'),
  214. ('SV', 'El Salvador'),
  215. ('SX', 'Sint Maarten'),
  216. ('SY', 'Syria'),
  217. ('SZ', 'Swaziland'),
  218. ('TC', 'Turks and Caicos Islands'),
  219. ('TD', 'Chad'),
  220. ('TF', 'French Southern Territories'),
  221. ('TG', 'Togo'),
  222. ('TH', 'Thailand'),
  223. ('TJ', 'Tajikistan'),
  224. ('TK', 'Tokelau'),
  225. ('TL', 'East Timor'),
  226. ('TM', 'Turkmenistan'),
  227. ('TN', 'Tunisia'),
  228. ('TO', 'Tonga'),
  229. ('TR', 'Turkey'),
  230. ('TT', 'Trinidad and Tobago'),
  231. ('TV', 'Tuvalu'),
  232. ('TW', 'Taiwan'),
  233. ('TZ', 'Tanzania'),
  234. ('UA', 'Ukraine'),
  235. ('UG', 'Uganda'),
  236. ('UM', 'U.S. Minor Outlying Islands'),
  237. ('US', 'United States'),
  238. ('UY', 'Uruguay'),
  239. ('UZ', 'Uzbekistan'),
  240. ('VA', 'Vatican City'),
  241. ('VC', 'Saint Vincent and the Grenadines'),
  242. ('VE', 'Venezuela'),
  243. ('VG', 'British Virgin Islands'),
  244. ('VI', 'U.S. Virgin Islands'),
  245. ('VN', 'Vietnam'),
  246. ('VU', 'Vanuatu'),
  247. ('WF', 'Wallis and Futuna'),
  248. ('WS', 'Samoa'),
  249. ('XK', 'Kosovo'),
  250. ('YE', 'Yemen'),
  251. ('YT', 'Mayotte'),
  252. ('ZA', 'South Africa'),
  253. ('ZM', 'Zambia'),
  254. ('ZW', 'Zimbabwe')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement