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