country_setup.sql

Java的框架

INSERT INTO COUNTRY VALUES ('LR','LIBERIA','Liberia','LBR','430');
INSERT INTO COUNTRY VALUES ('LY','LIBYAN ARAB JAMAHIRIYA','Libyan Arab Jamahiriya','LBY','434');
INSERT INTO COUNTRY VALUES ('LI','LIECHTENSTEIN','Liechtenstein','LIE','438');
INSERT INTO COUNTRY VALUES ('LT','LITHUANIA','Lithuania','LTU','440');
INSERT INTO COUNTRY VALUES ('LU','LUXEMBOURG','Luxembourg','LUX','442');
INSERT INTO COUNTRY VALUES ('MO','MACAO','Macao','MAC','446');
INSERT INTO COUNTRY VALUES ('MK','MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF','Macedonia, the Former Yugoslav Republic of','MKD','807');
INSERT INTO COUNTRY VALUES ('MG','MADAGASCAR','Madagascar','MDG','450');
INSERT INTO COUNTRY VALUES ('MW','MALAWI','Malawi','MWI','454');
INSERT INTO COUNTRY VALUES ('MY','MALAYSIA','Malaysia','MYS','458');
INSERT INTO COUNTRY VALUES ('MV','MALDIVES','Maldives','MDV','462');
INSERT INTO COUNTRY VALUES ('ML','MALI','Mali','MLI','466');
INSERT INTO COUNTRY VALUES ('MT','MALTA','Malta','MLT','470');
INSERT INTO COUNTRY VALUES ('MH','MARSHALL ISLANDS','Marshall Islands','MHL','584');
INSERT INTO COUNTRY VALUES ('MQ','MARTINIQUE','Martinique','MTQ','474');
INSERT INTO COUNTRY VALUES ('MR','MAURITANIA','Mauritania','MRT','478');
INSERT INTO COUNTRY VALUES ('MU','MAURITIUS','Mauritius','MUS','480');
INSERT INTO COUNTRY VALUES ('YT','MAYOTTE','Mayotte',NULL,NULL);
INSERT INTO COUNTRY VALUES ('MX','MEXICO','Mexico','MEX','484');
INSERT INTO COUNTRY VALUES ('FM','MICRONESIA, FEDERATED STATES OF','Micronesia, Federated States of','FSM','583');
INSERT INTO COUNTRY VALUES ('MD','MOLDOVA, REPUBLIC OF','Moldova, Republic of','MDA','498');
INSERT INTO COUNTRY VALUES ('MC','MONACO','Monaco','MCO','492');
INSERT INTO COUNTRY VALUES ('MN','MONGOLIA','Mongolia','MNG','496');
INSERT INTO COUNTRY VALUES ('MS','MONTSERRAT','Montserrat','MSR','500');
INSERT INTO COUNTRY VALUES ('MA','MOROCCO','Morocco','MAR','504');
INSERT INTO COUNTRY VALUES ('MZ','MOZAMBIQUE','Mozambique','MOZ','508');
INSERT INTO COUNTRY VALUES ('MM','MYANMAR','Myanmar','MMR','104');
INSERT INTO COUNTRY VALUES ('NA','NAMIBIA','Namibia','NAM','516');
INSERT INTO COUNTRY VALUES ('NR','NAURU','Nauru','NRU','520');
INSERT INTO COUNTRY VALUES ('NP','NEPAL','Nepal','NPL','524');
INSERT INTO COUNTRY VALUES ('NL','NETHERLANDS','Netherlands','NLD','528');
INSERT INTO COUNTRY VALUES ('AN','NETHERLANDS ANTILLES','Netherlands Antilles','ANT','530');
INSERT INTO COUNTRY VALUES ('NC','NEW CALEDONIA','New Caledonia','NCL','540');
INSERT INTO COUNTRY VALUES ('NZ','NEW ZEALAND','New Zealand','NZL','554');
INSERT INTO COUNTRY VALUES ('NI','NICARAGUA','Nicaragua','NIC','558');
INSERT INTO COUNTRY VALUES ('NE','NIGER','Niger','NER','562');
INSERT INTO COUNTRY VALUES ('NG','NIGERIA','Nigeria','NGA','566');
INSERT INTO COUNTRY VALUES ('NU','NIUE','Niue','NIU','570');
INSERT INTO COUNTRY VALUES ('NF','NORFOLK ISLAND','Norfolk Island','NFK','574');
INSERT INTO COUNTRY VALUES ('MP','NORTHERN MARIANA ISLANDS','Northern Mariana Islands','MNP','580');
INSERT INTO COUNTRY VALUES ('NO','NORWAY','Norway','NOR','578');
INSERT INTO COUNTRY VALUES ('OM','OMAN','Oman','OMN','512');
INSERT INTO COUNTRY VALUES ('PK','PAKISTAN','Pakistan','PAK','586');
INSERT INTO COUNTRY VALUES ('PW','PALAU','Palau','PLW','585');
INSERT INTO COUNTRY VALUES ('PS','PALESTINIAN TERRITORY, OCCUPIED','Palestinian Territory, Occupied',NULL,NULL);
INSERT INTO COUNTRY VALUES ('PA','PANAMA','Panama','PAN','591');
INSERT INTO COUNTRY VALUES ('PG','PAPUA NEW GUINEA','Papua New Guinea','PNG','598');
INSERT INTO COUNTRY VALUES ('PY','PARAGUAY','Paraguay','PRY','600');
INSERT INTO COUNTRY VALUES ('PE','PERU','Peru','PER','604');
INSERT INTO COUNTRY VALUES ('PH','PHILIPPINES','Philippines','PHL','608');
INSERT INTO COUNTRY VALUES ('PN','PITCAIRN','Pitcairn','PCN','612');
INSERT INTO COUNTRY VALUES ('PL','POLAND','Poland','POL','616');
INSERT INTO COUNTRY VALUES ('PT','PORTUGAL','Portugal','PRT','620');
INSERT INTO COUNTRY VALUES ('PR','PUERTO RICO','Puerto Rico','PRI','630');
INSERT INTO COUNTRY VALUES ('QA','QATAR','Qatar','QAT','634');
INSERT INTO COUNTRY VALUES ('RE','REUNION','Reunion','REU','638');
INSERT INTO COUNTRY VALUES ('RO','ROMANIA','Romania','ROM','642');
INSERT INTO COUNTRY VALUES ('RU','RUSSIAN FEDERATION','Russian Federation','RUS','643');
INSERT INTO COUNTRY VALUES ('RW','RWANDA','Rwanda','RWA','646');
INSERT INTO COUNTRY VALUES ('SH','SAINT HELENA','Saint Helena','SHN','654');
INSERT INTO COUNTRY VALUES ('KN','SAINT KITTS AND NEVIS','Saint Kitts and Nevis','KNA','659');
INSERT INTO COUNTRY VALUES ('LC','SAINT LUCIA','Saint Lucia','LCA','662');
INSERT INTO COUNTRY VALUES ('PM','SAINT PIERRE AND MIQUELON','Saint Pierre and Miquelon','SPM','666');
INSERT INTO COUNTRY VALUES ('VC','SAINT VINCENT AND THE GRENADINES','Saint Vincent and the Grenadines','VCT','670');
INSERT INTO COUNTRY VALUES ('WS','SAMOA','Samoa','WSM','882');
INSERT INTO COUNTRY VALUES ('SM','SAN MARINO','San Marino','SMR','674');
INSERT INTO COUNTRY VALUES ('ST','SAO TOME AND PRINCIPE','Sao Tome and Principe','STP','678');
INSERT INTO COUNTRY VALUES ('SA','SAUDI ARABIA','Saudi Arabia','SAU','682');
INSERT INTO COUNTRY VALUES ('SN','SENEGAL','Senegal','SEN','686');
INSERT INTO COUNTRY VALUES ('CS','SERBIA AND MONTENEGRO','Serbia and Montenegro',NULL,NULL);
INSERT INTO COUNTRY VALUES ('SC','SEYCHELLES','Seychelles','SYC','690');
INSERT INTO COUNTRY VALUES ('SL','SIERRA LEONE','Sierra Leone','SLE','694');
INSERT INTO COUNTRY VALUES ('SG','SINGAPORE','Singapore','SGP','702');
INSERT INTO COUNTRY VALUES ('SK','SLOVAKIA','Slovakia','SVK','703');
INSERT INTO COUNTRY VALUES ('SI','SLOVENIA','Slovenia','SVN','705');
INSERT INTO COUNTRY VALUES ('SB','SOLOMON ISLANDS','Solomon Islands','SLB','090');
INSERT INTO COUNTRY VALUES ('SO','SOMALIA','Somalia','SOM','706');
INSERT INTO COUNTRY VALUES ('ZA','SOUTH AFRICA','South Africa','ZAF','710');
INSERT INTO COUNTRY VALUES ('GS','SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS','South Georgia and the South Sandwich Islands',NULL,NULL);
INSERT INTO COUNTRY VALUES ('ES','SPAIN','Spain','ESP','724');
INSERT INTO COUNTRY VALUES ('LK','SRI LANKA','Sri Lanka','LKA','144');
INSERT INTO COUNTRY VALUES ('SD','SUDAN','Sudan','SDN','736');
INSERT INTO COUNTRY VALUES ('SR','SURINAME','Suriname','SUR','740');
INSERT INTO COUNTRY VALUES ('SJ','SVALBARD AND JAN MAYEN','Svalbard and Jan Mayen','SJM','744');
INSERT INTO COUNTRY VALUES ('SZ','SWAZILAND','Swaziland','SWZ','748');
INSERT INTO COUNTRY VALUES ('SE','SWEDEN','Sweden','SWE','752');
INSERT INTO COUNTRY VALUES ('CH','SWITZERLAND','Switzerland','CHE','756');
INSERT INTO COUNTRY VALUES ('SY','SYRIAN ARAB REPUBLIC','Syrian Arab Republic','SYR','760');
INSERT INTO COUNTRY VALUES ('TW','TAIWAN, PROVINCE OF CHINA','Taiwan, Province of China','TWN','158');
INSERT INTO COUNTRY VALUES ('TJ','TAJIKISTAN','Tajikistan','TJK','762');
INSERT INTO COUNTRY VALUES ('TZ','TANZANIA, UNITED REPUBLIC OF','Tanzania, United Republic of','TZA','834');
INSERT INTO COUNTRY VALUES ('TH','THAILAND','Thailand','THA','764');
INSERT INTO COUNTRY VALUES ('TL','TIMOR-LESTE','Timor-Leste',NULL,NULL);
INSERT INTO COUNTRY VALUES ('TG','TOGO','Togo','TGO','768');
INSERT INTO COUNTRY VALUES ('TK','TOKELAU','Tokelau','TKL','772');
INSERT INTO COUNTRY VALUES ('TO','TONGA','Tonga','TON','776');
INSERT INTO COUNTRY VALUES ('TT','TRINIDAD AND TOBAGO','Trinidad and Tobago','TTO','780');
INSERT INTO COUNTRY VALUES ('TN','TUNISIA','Tunisia','TUN','788');
INSERT INTO COUNTRY VALUES ('TR','TURKEY','Turkey','TUR','792');
INSERT INTO COUNTRY VALUES ('TM','TURKMENISTAN','Turkmenistan','TKM','795');
INSERT INTO COUNTRY VALUES ('TC','TURKS AND CAICOS ISLANDS','Turks and Caicos Islands','TCA','796');
INSERT INTO COUNTRY VALUES ('TV','TUVALU','Tuvalu','TUV','798');
INSERT INTO COUNTRY VALUES ('UG','UGANDA','Uganda','UGA','800');
INSERT INTO COUNTRY VALUES ('UA','UKRAINE','Ukraine','UKR','804');
INSERT INTO COUNTRY VALUES ('AE','UNITED ARAB EMIRATES','United Arab Emirates','ARE','784');
INSERT INTO COUNTRY VALUES ('GB','UNITED KINGDOM','United Kingdom','GBR','826');
INSERT INTO COUNTRY VALUES ('US','UNITED STATES','United States','USA','840');
INSERT INTO COUNTRY VALUES ('UM','UNITED STATES MINOR OUTLYING ISLANDS','United States Minor Outlying Islands',NULL,NULL);
INSERT INTO COUNTRY VALUES ('UY','URUGUAY','Uruguay','URY','858');
INSERT INTO COUNTRY VALUES ('UZ','UZBEKISTAN','Uzbekistan','UZB','860');
INSERT INTO COUNTRY VALUES ('VU','VANUATU','Vanuatu','VUT','548');
INSERT INTO COUNTRY VALUES ('VE','VENEZUELA','Venezuela','VEN','862');
INSERT INTO COUNTRY VALUES ('VN','VIET NAM','Viet Nam','VNM','704');
INSERT INTO COUNTRY VALUES ('VG','VIRGIN ISLANDS, BRITISH','Virgin Islands, British','VGB','092');
INSERT INTO COUNTRY VALUES ('VI','VIRGIN ISLANDS, U.S.','Virgin Islands, U.s.','VIR','850');
INSERT INTO COUNTRY VALUES ('WF','WALLIS AND FUTUNA','Wallis and Futuna','WLF','876');
INSERT INTO COUNTRY VALUES ('EH','WESTERN SAHARA','Western Sahara','ESH','732');
INSERT INTO COUNTRY VALUES ('YE','YEMEN','Yemen','YEM','887');
INSERT INTO COUNTRY VALUES ('ZM','ZAMBIA','Zambia','ZMB','894');
INSERT INTO COUNTRY VALUES ('ZW','ZIMBABWE','Zimbabwe','ZWE','716');