1 DROP TABLE IF EXISTS "certOwners";
2 CREATE TABLE "certOwners" (
4 "created" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
5 "modified" timestamp NULL DEFAULT NULL,
6 "deleted" timestamp NULL DEFAULT NULL,
10 DROP TABLE IF EXISTS "users";
11 CREATE TABLE "users" (
13 "email" varchar(255) NOT NULL DEFAULT '',
14 "password" varchar(255) NOT NULL DEFAULT '',
15 "fname" varchar(255) NOT NULL DEFAULT '',
16 "mname" varchar(255) NOT NULL DEFAULT '',
17 "lname" varchar(255) NOT NULL DEFAULT '',
18 "suffix" varchar(50) NOT NULL DEFAULT '',
20 "verified" boolean NOT NULL DEFAULT 'false',
21 "ccid" int NOT NULL DEFAULT '0',
22 "regid" int NOT NULL DEFAULT '0',
23 "locid" int NOT NULL DEFAULT '0',
24 "listme" boolean NOT NULL DEFAULT 'false',
25 "contactinfo" varchar(255) NOT NULL DEFAULT '',
26 "language" varchar(5) NOT NULL DEFAULT '',
29 CREATE INDEX ON "users" ("ccid");
30 CREATE INDEX ON "users" ("regid");
31 CREATE INDEX ON "users" ("locid");
32 CREATE INDEX ON "users" ("email");
33 CREATE INDEX ON "users" ("verified");
36 DROP TABLE IF EXISTS "organisations";
37 CREATE TABLE IF NOT EXISTS "organisations" (
39 "name" varchar(64) NOT NULL,
40 "state" varchar(2) NOT NULL,
41 "province" varchar(128) NOT NULL,
42 "city" varchar(128) NOT NULL,
43 "contactEmail" varchar(100) NOT NULL,
44 "creator" int NOT NULL,
46 "postal_address" text,
50 DROP TABLE IF EXISTS "domains";
51 CREATE TABLE "domains" (
54 "domain" varchar(255) NOT NULL,
55 "created" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
56 "modified" timestamp NULL DEFAULT NULL,
57 "deleted" timestamp NULL DEFAULT NULL,
60 CREATE INDEX ON "domains" ("memid");
61 CREATE INDEX ON "domains" ("domain");
62 CREATE INDEX ON "domains" ("deleted");
64 DROP TABLE IF EXISTS "emails";
65 CREATE TABLE "emails" (
67 "memid" int NOT NULL DEFAULT '0',
68 "email" varchar(255) NOT NULL DEFAULT '',
69 "created" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
70 "modified" timestamp NULL DEFAULT NULL,
71 "deleted" timestamp NULL DEFAULT NULL,
74 CREATE INDEX ON "emails" ("memid");
75 CREATE INDEX ON "emails" ("deleted");
76 CREATE INDEX ON "emails" ("email");
78 DROP TABLE IF EXISTS "emailPinglog";
79 DROP TABLE IF EXISTS "domainPinglog";
81 DROP TYPE IF EXISTS "emailPingType";
82 CREATE TYPE "emailPingType" AS ENUM ('fast', 'active');
83 DROP TYPE IF EXISTS "pingState";
84 CREATE TYPE "pingState" AS ENUM ('open', 'success', 'failed');
86 CREATE TABLE "emailPinglog" (
87 "when" timestamp NOT NULL,
89 "email" varchar(255) NOT NULL,
90 "type" "emailPingType" NOT NULL,
91 "status" "pingState" NOT NULL,
92 "result" varchar(255) NOT NULL,
93 "challenge" varchar(255) NULL DEFAULT NULL
96 DROP TABLE IF EXISTS "pingconfig";
98 DROP TYPE IF EXISTS "pingType";
99 CREATE TYPE "pingType" AS ENUM ('email', 'ssl', 'http', 'dns');
101 CREATE TABLE "pingconfig" (
102 "id" serial NOT NULL,
103 "domainid" int NOT NULL,
104 "type" "pingType" NOT NULL,
105 "info" varchar(255) NOT NULL,
106 "deleted" timestamp NULL DEFAULT NULL,
111 CREATE TABLE "domainPinglog" (
112 "when" TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
113 "configId" int NOT NULL,
114 "state" "pingState" NOT NULL,
115 "challenge" varchar(16),
116 "result" varchar(255)
119 DROP TABLE IF EXISTS "baddomains";
120 CREATE TABLE "baddomains" (
121 "domain" varchar(255) NOT NULL DEFAULT ''
125 DROP TABLE IF EXISTS "alerts";
126 CREATE TABLE "alerts" (
127 "memid" int NOT NULL DEFAULT '0',
128 "general" boolean NOT NULL DEFAULT 'false',
129 "country" boolean NOT NULL DEFAULT 'false',
130 "regional" boolean NOT NULL DEFAULT 'false',
131 "radius" boolean NOT NULL DEFAULT 'false',
132 PRIMARY KEY ("memid")
135 DROP TABLE IF EXISTS "user_agreements";
136 CREATE TABLE "user_agreements" (
137 "id" serial NOT NULL,
138 "memid" int NOT NULL,
139 "secmemid" int DEFAULT NULL,
140 "document" varchar(50) DEFAULT NULL,
141 "date" timestamp DEFAULT NULL,
142 "active" boolean NOT NULL,
143 "method" varchar(100) NOT NULL,
144 "comment" varchar(100) DEFAULT NULL,
148 DROP TABLE IF EXISTS "certs";
150 DROP TYPE IF EXISTS "mdType";
151 CREATE TYPE "mdType" AS ENUM('md5','sha1','sha256','sha512');
153 DROP TYPE IF EXISTS "csrType";
154 CREATE TYPE "csrType" AS ENUM ('CSR', 'SPKAC');
156 CREATE TABLE "certs" (
157 "id" serial NOT NULL,
158 "memid" int NOT NULL DEFAULT '0',
159 "serial" varchar(50) NOT NULL DEFAULT '',
160 "keytype" char(2) NOT NULL DEFAULT 'NS',
161 "codesign" boolean NOT NULL DEFAULT 'false',
162 "md" "mdType" NOT NULL DEFAULT 'sha512',
163 "profile" int NOT NULL,
164 "caid" int NULL DEFAULT NULL,
166 "csr_name" varchar(255) NOT NULL DEFAULT '',
167 "csr_type" "csrType" NOT NULL,
168 "crt_name" varchar(255) NOT NULL DEFAULT '',
169 "created" timestamp NULL DEFAULT NULL,
170 "modified" timestamp NULL DEFAULT NULL,
171 "revoked" timestamp NULL DEFAULT NULL,
172 "expire" timestamp NULL DEFAULT NULL,
173 "renewed" boolean NOT NULL DEFAULT 'false',
174 "disablelogin" boolean NOT NULL DEFAULT 'false',
175 "pkhash" char(40) DEFAULT NULL,
176 "certhash" char(40) DEFAULT NULL,
177 "description" varchar(100) NOT NULL DEFAULT '',
180 CREATE INDEX ON "certs" ("pkhash");
181 CREATE INDEX ON "certs" ("revoked");
182 CREATE INDEX ON "certs" ("created");
183 CREATE INDEX ON "certs" ("memid");
184 CREATE INDEX ON "certs" ("serial");
185 CREATE INDEX ON "certs" ("expire");
186 CREATE INDEX ON "certs" ("crt_name");
190 DROP TABLE IF EXISTS "certAvas";
191 CREATE TABLE "certAvas" (
192 "certId" int NOT NULL,
193 "name" varchar(20) NOT NULL,
194 "value" varchar(255) NOT NULL,
196 PRIMARY KEY ("certId", "name")
199 DROP TABLE IF EXISTS "clientcerts";
200 CREATE TABLE "clientcerts" (
202 "disablelogin" boolean NOT NULL DEFAULT 'false',
207 DROP TABLE IF EXISTS "profiles";
208 CREATE TABLE "profiles" (
209 "id" serial NOT NULL,
210 "keyname" varchar(60) NOT NULL,
211 "include" varchar(200) NOT NULL,
212 "requires" varchar(200) NOT NULL,
213 "name" varchar(100) NOT NULL,
218 DROP TABLE IF EXISTS "subjectAlternativeNames";
220 DROP TYPE IF EXISTS "SANType";
221 CREATE TYPE "SANType" AS ENUM ('email', 'DNS');
223 CREATE TABLE "subjectAlternativeNames" (
224 "certId" int NOT NULL,
225 "contents" varchar(50) NOT NULL,
226 "type" "SANType" NOT NULL
229 DROP TABLE IF EXISTS "cacerts";
230 CREATE TABLE "cacerts" (
231 "id" serial NOT NULL,
232 "keyname" varchar(60) NOT NULL,
233 "link" varchar(160) NOT NULL,
234 "parentRoot" int NOT NULL,
235 "validFrom" timestamp NULL DEFAULT NULL,
236 "validTo" timestamp NULL DEFAULT NULL,
241 DROP TABLE IF EXISTS "jobs";
243 DROP TYPE IF EXISTS "jobType";
244 CREATE TYPE "jobType" AS ENUM ('sign', 'revoke');
245 DROP TYPE IF EXISTS "jobState";
246 CREATE TYPE "jobState" AS ENUM ('open', 'done', 'error');
249 CREATE TABLE "jobs" (
250 "id" serial NOT NULL,
251 "targetId" int NOT NULL,
252 "task" "jobType" NOT NULL,
253 "state" "jobState" NOT NULL DEFAULT 'open',
254 "warning" smallint NOT NULL DEFAULT '0',
256 "executeTo" VARCHAR(11),
260 CREATE INDEX ON "jobs" ("state");
262 DROP TABLE IF EXISTS "notary";
264 DROP TYPE IF EXISTS "notaryType";
265 CREATE TYPE "notaryType" AS enum('Face to Face Meeting', 'TOPUP', 'TTP-Assisted', 'Nucleus Bonus');
267 CREATE TABLE "notary" (
268 "id" serial NOT NULL,
269 "from" int NOT NULL DEFAULT '0',
270 "to" int NOT NULL DEFAULT '0',
271 # total points that have been entered
272 "points" int NOT NULL DEFAULT '0',
273 # awarded and the "experience points" are calculated virtually
274 # Face to Face is default, TOPUP is for the remaining 30Points after two TTP
275 # TTP is default ttp assurance
276 "method" "notaryType" NOT NULL DEFAULT 'Face to Face Meeting',
277 "location" varchar(255) NOT NULL DEFAULT '',
278 "date" varchar(255) NOT NULL DEFAULT '',
279 # date when assurance was entered
280 "when" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
282 "expire" timestamp NULL DEFAULT NULL,
284 "sponsor" int NOT NULL DEFAULT '0',
285 # date when assurance was deleted (or 0)
286 "deleted" timestamp NULL DEFAULT NULL,
290 CREATE INDEX ON "notary"("from");
291 CREATE INDEX ON "notary"("to");
292 CREATE INDEX ON "notary"("when");
293 CREATE INDEX ON "notary"("method");
296 DROP TABLE IF EXISTS "cats_passed";
297 CREATE TABLE "cats_passed" (
298 "id" serial NOT NULL,
299 "user_id" int NOT NULL,
300 "variant_id" int NOT NULL,
301 "pass_date" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
302 "language" varchar(5) NOT NULL DEFAULT '',
303 "version" varchar(10) NOT NULL DEFAULT '',
305 UNIQUE ("user_id","variant_id","pass_date")
308 # --------------------------------------------------------
311 # Table structure for table "cats_type"
314 DROP TABLE IF EXISTS "cats_type";
315 CREATE TABLE "cats_type" (
316 "id" serial NOT NULL,
317 "type_text" varchar(255) NOT NULL,
322 DROP TABLE IF EXISTS "arbitrations";
323 CREATE TABLE IF NOT EXISTS "arbitrations" (
325 "arbitration" varchar(20) NOT NULL,
326 PRIMARY KEY ("user","arbitration")
329 DROP TABLE IF EXISTS "user_groups";
331 DROP TYPE IF EXISTS "userGroup";
332 CREATE TYPE "userGroup" AS enum('supporter','arbitrator','blockedassuree','blockedassurer','blockedlogin','ttp-assurer','ttp-applicant', 'codesigning', 'orgassurer', 'blockedcert', 'nucleus-assurer');
334 CREATE TABLE IF NOT EXISTS "user_groups" (
335 "id" serial NOT NULL,
337 "permission" "userGroup" NOT NULL,
338 "granted" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
339 "deleted" timestamp NULL DEFAULT NULL,
340 "grantedby" int NOT NULL,
341 "revokedby" int DEFAULT NULL,
345 DROP TABLE IF EXISTS "org_admin";
347 DROP TYPE IF EXISTS "yesno";
348 CREATE TYPE "yesno" AS enum('y', 'n');
351 CREATE TABLE IF NOT EXISTS "org_admin" (
352 "orgid" int NOT NULL,
353 "memid" int NOT NULL,
354 "master" "yesno" NOT NULL,
355 "creator" int NOT NULL,
356 "created" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
357 "deleter" int NULL DEFAULT NULL,
358 "deleted" timestamp NULL DEFAULT NULL
360 CREATE INDEX ON "org_admin"("orgid", "memid");
363 DROP TABLE IF EXISTS "adminLog";
364 CREATE TABLE "adminLog" (
365 "when" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
367 "admin" int NOT NULL,
368 "type" varchar(100) NOT NULL DEFAULT '',
369 "information" varchar(50) NOT NULL DEFAULT ''
371 CREATE INDEX ON "adminLog"("when");
374 DROP TABLE IF EXISTS "schemeVersion";
375 CREATE TABLE "schemeVersion" (
376 "version" smallint NOT NULL,
377 PRIMARY KEY ("version")
379 INSERT INTO "schemeVersion" (version) VALUES(16);
381 DROP TABLE IF EXISTS `passwordResetTickets`;
382 CREATE TABLE `passwordResetTickets` (
383 `id` serial NOT NULL,
384 `memid` int NOT NULL,
385 `creator` int NOT NULL,
386 `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
387 `used` timestamp NULL DEFAULT NULL,
388 `token` varchar(32) NOT NULL,
389 `private_token` varchar(255) NOT NULL,
394 /* Create table countryIsoCode' */
396 DROP TABLE IF EXISTS `countryIsoCode`;
397 CREATE TABLE `countryIsoCode` (
398 `id` serial NOT NULL,
399 `english` text NOT NULL,
400 `code2` varchar(2) NOT NULL,
401 `code3` varchar(3) NOT NULL,
402 `obp_id` int NOT NULL,
406 /* Fill table countryIsoCode' */
407 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Andorra', 'AD', 'AND', 020);
408 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('United Arab Emirates (the)', 'AE', 'ARE', 784);
409 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Afghanistan', 'AF', 'AFG', 004);
410 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Antigua and Barbuda', 'AG', 'ATG', 028);
411 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Anguilla', 'AI', 'AIA', 660);
412 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Albania', 'AL', 'ALB', 008);
413 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Armenia', 'AM', 'ARM', 051);
414 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Angola', 'AO', 'AGO', 024);
415 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Antarctica', 'AQ', 'ATA', 010);
416 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Argentina', 'AR', 'ARG', 032);
417 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('American Samoa', 'AS', 'ASM', 016);
418 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Austria', 'AT', 'AUT', 040);
419 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Australia', 'AU', 'AUS', 036);
420 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Aruba', 'AW', 'ABW', 533);
421 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Ă…land Islands', 'AX', 'ALA', 248);
422 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Azerbaijan', 'AZ', 'AZE', 031);
423 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Bosnia and Herzegovina', 'BA', 'BIH', 070);
424 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Barbados', 'BB', 'BRB', 052);
425 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Bangladesh', 'BD', 'BGD', 050);
426 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Belgium', 'BE', 'BEL', 056);
427 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Burkina Faso', 'BF', 'BFA', 854);
428 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Bulgaria', 'BG', 'BGR', 100);
429 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Bahrain', 'BH', 'BHR', 048);
430 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Burundi', 'BI', 'BDI', 108);
431 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Benin', 'BJ', 'BEN', 204);
432 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Saint Barthélemy', 'BL', 'BLM', 652);
433 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Bermuda', 'BM', 'BMU', 060);
434 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Brunei Darussalam', 'BN', 'BRN', 096);
435 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Bolivia (Plurinational State of)', 'BO', 'BOL', 068);
436 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Bonaire, Sint Eustatius and Saba', 'BQ', 'BES', 535);
437 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Brazil', 'BR', 'BRA', 076);
438 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Bahamas (the)', 'BS', 'BHS', 044);
439 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Bhutan', 'BT', 'BTN', 064);
440 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Bouvet Island', 'BV', 'BVT', 074);
441 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Botswana', 'BW', 'BWA', 072);
442 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Belarus', 'BY', 'BLR', 112);
443 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Belize', 'BZ', 'BLZ', 084);
444 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Canada', 'CA', 'CAN', 124);
445 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Cocos (Keeling) Islands (the)', 'CC', 'CCK', 166);
446 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Congo (the Democratic Republic of the)', 'CD', 'COD', 180);
447 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Central African Republic (the)', 'CF', 'CAF', 140);
448 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Congo (the)', 'CG', 'COG', 178);
449 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Switzerland', 'CH', 'CHE', 756);
450 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('CĂ´te d`Ivoire', 'CI', 'CIV', 384);
451 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Cook Islands (the)', 'CK', 'COK', 184);
452 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Chile', 'CL', 'CHL', 152);
453 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Cameroon', 'CM', 'CMR', 120);
454 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('China', 'CN', 'CHN', 156);
455 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Colombia', 'CO', 'COL', 170);
456 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Costa Rica', 'CR', 'CRI', 188);
457 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Cuba', 'CU', 'CUB', 192);
458 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Cabo Verde', 'CV', 'CPV', 132);
459 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Curaçao', 'CW', 'CUW', 531);
460 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Christmas Island', 'CX', 'CXR', 162);
461 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Cyprus', 'CY', 'CYP', 196);
462 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Czech Republic (the)', 'CZ', 'CZE', 203);
463 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Germany', 'DE', 'DEU', 276);
464 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Djibouti', 'DJ', 'DJI', 262);
465 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Denmark', 'DK', 'DNK', 208);
466 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Dominica', 'DM', 'DMA', 212);
467 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Dominican Republic (the)', 'DO', 'DOM', 214);
468 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Algeria', 'DZ', 'DZA', 012);
469 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Ecuador', 'EC', 'ECU', 218);
470 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Estonia', 'EE', 'EST', 233);
471 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Egypt', 'EG', 'EGY', 818);
472 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Western Sahara*', 'EH', 'ESH', 732);
473 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Eritrea', 'ER', 'ERI', 232);
474 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Spain', 'ES', 'ESP', 724);
475 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Ethiopia', 'ET', 'ETH', 231);
476 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Finland', 'FI', 'FIN', 246);
477 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Fiji', 'FJ', 'FJI', 242);
478 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Falkland Islands (the) [Malvinas]', 'FK', 'FLK', 238);
479 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Micronesia (Federated States of)', 'FM', 'FSM', 583);
480 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Faroe Islands (the)', 'FO', 'FRO', 234);
481 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('France', 'FR', 'FRA', 250);
482 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Gabon', 'GA', 'GAB', 266);
483 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('United Kingdom of Great Britain and Northern Ireland (the)', 'GB', 'GBR', 826);
484 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Grenada', 'GD', 'GRD', 308);
485 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Georgia', 'GE', 'GEO', 268);
486 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('French Guiana', 'GF', 'GUF', 254);
487 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Guernsey', 'GG', 'GGY', 831);
488 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Ghana', 'GH', 'GHA', 288);
489 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Gibraltar', 'GI', 'GIB', 292);
490 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Greenland', 'GL', 'GRL', 304);
491 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Gambia (the)', 'GM', 'GMB', 270);
492 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Guinea', 'GN', 'GIN', 324);
493 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Guadeloupe', 'GP', 'GLP', 312);
494 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Equatorial Guinea', 'GQ', 'GNQ', 226);
495 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Greece', 'GR', 'GRC', 300);
496 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('South Georgia and the South Sandwich Islands', 'GS', 'SGS', 239);
497 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Guatemala', 'GT', 'GTM', 320);
498 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Guam', 'GU', 'GUM', 316);
499 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Guinea-Bissau', 'GW', 'GNB', 624);
500 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Guyana', 'GY', 'GUY', 328);
501 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Hong Kong', 'HK', 'HKG', 344);
502 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Heard Island and McDonald Islands', 'HM', 'HMD', 334);
503 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Honduras', 'HN', 'HND', 340);
504 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Croatia', 'HR', 'HRV', 191);
505 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Haiti', 'HT', 'HTI', 332);
506 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Hungary', 'HU', 'HUN', 348);
507 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Indonesia', 'ID', 'IDN', 360);
508 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Ireland', 'IE', 'IRL', 372);
509 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Israel', 'IL', 'ISR', 376);
510 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Isle of Man', 'IM', 'IMN', 833);
511 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('India', 'IN', 'IND', 356);
512 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('British Indian Ocean Territory (the)', 'IO', 'IOT', 086);
513 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Iraq', 'IQ', 'IRQ', 368);
514 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Iran (Islamic Republic of)', 'IR', 'IRN', 364);
515 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Iceland', 'IS', 'ISL', 352);
516 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Italy', 'IT', 'ITA', 380);
517 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Jersey', 'JE', 'JEY', 832);
518 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Jamaica', 'JM', 'JAM', 388);
519 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Jordan', 'JO', 'JOR', 400);
520 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Japan', 'JP', 'JPN', 392);
521 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Kenya', 'KE', 'KEN', 404);
522 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Kyrgyzstan', 'KG', 'KGZ', 417);
523 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Cambodia', 'KH', 'KHM', 116);
524 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Kiribati', 'KI', 'KIR', 296);
525 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Comoros (the)', 'KM', 'COM', 174);
526 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Saint Kitts and Nevis', 'KN', 'KNA', 659);
527 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Korea (the Democratic People`s Republic of)', 'KP', 'PRK', 408);
528 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Korea (the Republic of)', 'KR', 'KOR', 410);
529 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Kuwait', 'KW', 'KWT', 414);
530 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Cayman Islands (the)', 'KY', 'CYM', 136);
531 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Kazakhstan', 'KZ', 'KAZ', 398);
532 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Lao People`s Democratic Republic (the)', 'LA', 'LAO', 418);
533 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Lebanon', 'LB', 'LBN', 422);
534 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Saint Lucia', 'LC', 'LCA', 662);
535 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Liechtenstein', 'LI', 'LIE', 438);
536 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Sri Lanka', 'LK', 'LKA', 144);
537 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Liberia', 'LR', 'LBR', 430);
538 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Lesotho', 'LS', 'LSO', 426);
539 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Lithuania', 'LT', 'LTU', 440);
540 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Luxembourg', 'LU', 'LUX', 442);
541 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Latvia', 'LV', 'LVA', 428);
542 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Libya', 'LY', 'LBY', 434);
543 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Morocco', 'MA', 'MAR', 504);
544 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Monaco', 'MC', 'MCO', 492);
545 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Moldova (the Republic of)', 'MD', 'MDA', 498);
546 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Montenegro', 'ME', 'MNE', 499);
547 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Saint Martin (French part)', 'MF', 'MAF', 663);
548 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Madagascar', 'MG', 'MDG', 450);
549 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Marshall Islands (the)', 'MH', 'MHL', 584);
550 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Macedonia (the former Yugoslav Republic of)', 'MK', 'MKD', 807);
551 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Mali', 'ML', 'MLI', 466);
552 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Myanmar', 'MM', 'MMR', 104);
553 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Mongolia', 'MN', 'MNG', 496);
554 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Macao', 'MO', 'MAC', 446);
555 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Northern Mariana Islands (the)', 'MP', 'MNP', 580);
556 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Martinique', 'MQ', 'MTQ', 474);
557 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Mauritania', 'MR', 'MRT', 478);
558 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Montserrat', 'MS', 'MSR', 500);
559 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Malta', 'MT', 'MLT', 470);
560 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Mauritius', 'MU', 'MUS', 480);
561 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Maldives', 'MV', 'MDV', 462);
562 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Malawi', 'MW', 'MWI', 454);
563 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Mexico', 'MX', 'MEX', 484);
564 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Malaysia', 'MY', 'MYS', 458);
565 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Mozambique', 'MZ', 'MOZ', 508);
566 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Namibia', 'NA', 'NAM', 516);
567 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('New Caledonia', 'NC', 'NCL', 540);
568 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Niger (the)', 'NE', 'NER', 562);
569 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Norfolk Island', 'NF', 'NFK', 574);
570 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Nigeria', 'NG', 'NGA', 566);
571 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Nicaragua', 'NI', 'NIC', 558);
572 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Netherlands (the)', 'NL', 'NLD', 528);
573 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Norway', 'NO', 'NOR', 578);
574 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Nepal', 'NP', 'NPL', 524);
575 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Nauru', 'NR', 'NRU', 520);
576 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Niue', 'NU', 'NIU', 570);
577 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('New Zealand', 'NZ', 'NZL', 554);
578 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Oman', 'OM', 'OMN', 512);
579 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Panama', 'PA', 'PAN', 591);
580 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Peru', 'PE', 'PER', 604);
581 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('French Polynesia', 'PF', 'PYF', 258);
582 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Papua New Guinea', 'PG', 'PNG', 598);
583 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Philippines (the)', 'PH', 'PHL', 608);
584 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Pakistan', 'PK', 'PAK', 586);
585 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Poland', 'PL', 'POL', 616);
586 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Saint Pierre and Miquelon', 'PM', 'SPM', 666);
587 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Pitcairn', 'PN', 'PCN', 612);
588 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Puerto Rico', 'PR', 'PRI', 630);
589 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Palestine, State of', 'PS', 'PSE', 275);
590 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Portugal', 'PT', 'PRT', 620);
591 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Palau', 'PW', 'PLW', 585);
592 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Paraguay', 'PY', 'PRY', 600);
593 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Qatar', 'QA', 'QAT', 634);
594 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('RĂ©union', 'RE', 'REU', 638);
595 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Romania', 'RO', 'ROU', 642);
596 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Serbia', 'RS', 'SRB', 688);
597 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Russian Federation (the)', 'RU', 'RUS', 643);
598 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Rwanda', 'RW', 'RWA', 646);
599 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Saudi Arabia', 'SA', 'SAU', 682);
600 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Solomon Islands', 'SB', 'SLB', 090);
601 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Seychelles', 'SC', 'SYC', 690);
602 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Sudan (the)', 'SD', 'SDN', 729);
603 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Sweden', 'SE', 'SWE', 752);
604 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Singapore', 'SG', 'SGP', 702);
605 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Saint Helena, Ascension and Tristan da Cunha', 'SH', 'SHN', 654);
606 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Slovenia', 'SI', 'SVN', 705);
607 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Svalbard and Jan Mayen', 'SJ', 'SJM', 744);
608 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Slovakia', 'SK', 'SVK', 703);
609 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Sierra Leone', 'SL', 'SLE', 694);
610 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('San Marino', 'SM', 'SMR', 674);
611 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Senegal', 'SN', 'SEN', 686);
612 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Somalia', 'SO', 'SOM', 706);
613 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Suriname', 'SR', 'SUR', 740);
614 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('South Sudan', 'SS', 'SSD', 728);
615 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Sao Tome and Principe', 'ST', 'STP', 678);
616 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('El Salvador', 'SV', 'SLV', 222);
617 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Sint Maarten (Dutch part)', 'SX', 'SXM', 534);
618 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Syrian Arab Republic', 'SY', 'SYR', 760);
619 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Swaziland', 'SZ', 'SWZ', 748);
620 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Turks and Caicos Islands (the)', 'TC', 'TCA', 796);
621 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Chad', 'TD', 'TCD', 148);
622 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('French Southern Territories (the)', 'TF', 'ATF', 260);
623 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Togo', 'TG', 'TGO', 768);
624 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Thailand', 'TH', 'THA', 764);
625 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Tajikistan', 'TJ', 'TJK', 762);
626 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Tokelau', 'TK', 'TKL', 772);
627 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Timor-Leste', 'TL', 'TLS', 626);
628 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Turkmenistan', 'TM', 'TKM', 795);
629 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Tunisia', 'TN', 'TUN', 788);
630 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Tonga', 'TO', 'TON', 776);
631 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Turkey', 'TR', 'TUR', 792);
632 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Trinidad and Tobago', 'TT', 'TTO', 780);
633 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Tuvalu', 'TV', 'TUV', 798);
634 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Taiwan (Province of China)', 'TW', 'TWN', 158);
635 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Tanzania, United Republic of', 'TZ', 'TZA', 834);
636 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Ukraine', 'UA', 'UKR', 804);
637 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Uganda', 'UG', 'UGA', 800);
638 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('United States Minor Outlying Islands (the)', 'UM', 'UMI', 581);
639 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('United States of America (the)', 'US', 'USA', 840);
640 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Uruguay', 'UY', 'URY', 858);
641 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Uzbekistan', 'UZ', 'UZB', 860);
642 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Holy See (the)', 'VA', 'VAT', 336);
643 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Saint Vincent and the Grenadines', 'VC', 'VCT', 670);
644 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Venezuela (Bolivarian Republic of)', 'VE', 'VEN', 862);
645 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Virgin Islands (British)', 'VG', 'VGB', 092);
646 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Virgin Islands (U.S.)', 'VI', 'VIR', 850);
647 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Viet Nam', 'VN', 'VNM', 704);
648 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Vanuatu', 'VU', 'VUT', 548);
649 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Wallis and Futuna', 'WF', 'WLF', 876);
650 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Samoa', 'WS', 'WSM', 882);
651 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Yemen', 'YE', 'YEM', 887);
652 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Mayotte', 'YT', 'MYT', 175);
653 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('South Africa', 'ZA', 'ZAF', 710);
654 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Zambia', 'ZM', 'ZMB', 894);
655 INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Zimbabwe', 'ZW', 'ZWE', 716);