country_setup.sql

Java的框架

USE PRRM;

INSERT INTO COUNTRY VALUES ('AF','AFGHANISTAN','Afghanistan','AFG','004');
INSERT INTO COUNTRY VALUES ('AL','ALBANIA','Albania','ALB','008');
INSERT INTO COUNTRY VALUES ('DZ','ALGERIA','Algeria','DZA','012');
INSERT INTO COUNTRY VALUES ('AS','AMERICAN SAMOA','American Samoa','ASM','016');
INSERT INTO COUNTRY VALUES ('AD','ANDORRA','Andorra','AND','020');
INSERT INTO COUNTRY VALUES ('AO','ANGOLA','Angola','AGO','024');
INSERT INTO COUNTRY VALUES ('AI','ANGUILLA','Anguilla','AIA','660');
INSERT INTO COUNTRY VALUES ('AQ','ANTARCTICA','Antarctica',NULL,NULL);
INSERT INTO COUNTRY VALUES ('AG','ANTIGUA AND BARBUDA','Antigua and Barbuda','ATG','028');
INSERT INTO COUNTRY VALUES ('AR','ARGENTINA','Argentina','ARG','032');
INSERT INTO COUNTRY VALUES ('AM','ARMENIA','Armenia','ARM','051');
INSERT INTO COUNTRY VALUES ('AW','ARUBA','Aruba','ABW','533');
INSERT INTO COUNTRY VALUES ('AU','AUSTRALIA','Australia','AUS','036');
INSERT INTO COUNTRY VALUES ('AT','AUSTRIA','Austria','AUT','040');
INSERT INTO COUNTRY VALUES ('AZ','AZERBAIJAN','Azerbaijan','AZE','031');
INSERT INTO COUNTRY VALUES ('BS','BAHAMAS','Bahamas','BHS','044');
INSERT INTO COUNTRY VALUES ('BH','BAHRAIN','Bahrain','BHR','048');
INSERT INTO COUNTRY VALUES ('BD','BANGLADESH','Bangladesh','BGD','050');
INSERT INTO COUNTRY VALUES ('BB','BARBADOS','Barbados','BRB','052');
INSERT INTO COUNTRY VALUES ('BY','BELARUS','Belarus','BLR','112');
INSERT INTO COUNTRY VALUES ('BE','BELGIUM','Belgium','BEL','056');
INSERT INTO COUNTRY VALUES ('BZ','BELIZE','Belize','BLZ','084');
INSERT INTO COUNTRY VALUES ('BJ','BENIN','Benin','BEN','204');
INSERT INTO COUNTRY VALUES ('BM','BERMUDA','Bermuda','BMU','060');
INSERT INTO COUNTRY VALUES ('BT','BHUTAN','Bhutan','BTN','064');
INSERT INTO COUNTRY VALUES ('BO','BOLIVIA','Bolivia','BOL','068');
INSERT INTO COUNTRY VALUES ('BA','BOSNIA AND HERZEGOVINA','Bosnia and Herzegovina','BIH','070');
INSERT INTO COUNTRY VALUES ('BW','BOTSWANA','Botswana','BWA','072');
INSERT INTO COUNTRY VALUES ('BV','BOUVET ISLAND','Bouvet Island',NULL,NULL);
INSERT INTO COUNTRY VALUES ('BR','BRAZIL','Brazil','BRA','076');
INSERT INTO COUNTRY VALUES ('IO','BRITISH INDIAN OCEAN TERRITORY','British Indian Ocean Territory',NULL,NULL);
INSERT INTO COUNTRY VALUES ('BN','BRUNEI DARUSSALAM','Brunei Darussalam','BRN','096');
INSERT INTO COUNTRY VALUES ('BG','BULGARIA','Bulgaria','BGR','100');
INSERT INTO COUNTRY VALUES ('BF','BURKINA FASO','Burkina Faso','BFA','854');
INSERT INTO COUNTRY VALUES ('BI','BURUNDI','Burundi','BDI','108');
INSERT INTO COUNTRY VALUES ('KH','CAMBODIA','Cambodia','KHM','116');
INSERT INTO COUNTRY VALUES ('CM','CAMEROON','Cameroon','CMR','120');
INSERT INTO COUNTRY VALUES ('CA','CANADA','Canada','CAN','124');
INSERT INTO COUNTRY VALUES ('CV','CAPE VERDE','Cape Verde','CPV','132');
INSERT INTO COUNTRY VALUES ('KY','CAYMAN ISLANDS','Cayman Islands','CYM','136');
INSERT INTO COUNTRY VALUES ('CF','CENTRAL AFRICAN REPUBLIC','Central African Republic','CAF','140');
INSERT INTO COUNTRY VALUES ('TD','CHAD','Chad','TCD','148');
INSERT INTO COUNTRY VALUES ('CL','CHILE','Chile','CHL','152');
INSERT INTO COUNTRY VALUES ('CN','CHINA','China','CHN','156');
INSERT INTO COUNTRY VALUES ('CX','CHRISTMAS ISLAND','Christmas Island',NULL,NULL);
INSERT INTO COUNTRY VALUES ('CC','COCOS (KEELING) ISLANDS','Cocos (Keeling) Islands',NULL,NULL);
INSERT INTO COUNTRY VALUES ('CO','COLOMBIA','Colombia','COL','170');
INSERT INTO COUNTRY VALUES ('KM','COMOROS','Comoros','COM','174');
INSERT INTO COUNTRY VALUES ('CG','CONGO','Congo','COG','178');
INSERT INTO COUNTRY VALUES ('CD','CONGO, THE DEMOCRATIC REPUBLIC OF THE','Congo, the Democratic Republic of the','COD','180');
INSERT INTO COUNTRY VALUES ('CK','COOK ISLANDS','Cook Islands','COK','184');
INSERT INTO COUNTRY VALUES ('CR','COSTA RICA','Costa Rica','CRI','188');
INSERT INTO COUNTRY VALUES ('CI','COTE D\'IVOIRE','Cote D\'Ivoire','CIV','384');
INSERT INTO COUNTRY VALUES ('HR','CROATIA','Croatia','HRV','191');
INSERT INTO COUNTRY VALUES ('CU','CUBA','Cuba','CUB','192');
INSERT INTO COUNTRY VALUES ('CY','CYPRUS','Cyprus','CYP','196');
INSERT INTO COUNTRY VALUES ('CZ','CZECH REPUBLIC','Czech Republic','CZE','203');
INSERT INTO COUNTRY VALUES ('DK','DENMARK','Denmark','DNK','208');
INSERT INTO COUNTRY VALUES ('DJ','DJIBOUTI','Djibouti','DJI','262');
INSERT INTO COUNTRY VALUES ('DM','DOMINICA','Dominica','DMA','212');
INSERT INTO COUNTRY VALUES ('DO','DOMINICAN REPUBLIC','Dominican Republic','DOM','214');
INSERT INTO COUNTRY VALUES ('EC','ECUADOR','Ecuador','ECU','218');
INSERT INTO COUNTRY VALUES ('EG','EGYPT','Egypt','EGY','818');
INSERT INTO COUNTRY VALUES ('SV','EL SALVADOR','El Salvador','SLV','222');
INSERT INTO COUNTRY VALUES ('GQ','EQUATORIAL GUINEA','Equatorial Guinea','GNQ','226');
INSERT INTO COUNTRY VALUES ('ER','ERITREA','Eritrea','ERI','232');
INSERT INTO COUNTRY VALUES ('EE','ESTONIA','Estonia','EST','233');
INSERT INTO COUNTRY VALUES ('ET','ETHIOPIA','Ethiopia','ETH','231');
INSERT INTO COUNTRY VALUES ('FK','FALKLAND ISLANDS (MALVINAS)','Falkland Islands (Malvinas)','FLK','238');
INSERT INTO COUNTRY VALUES ('FO','FAROE ISLANDS','Faroe Islands','FRO','234');
INSERT INTO COUNTRY VALUES ('FJ','FIJI','Fiji','FJI','242');
INSERT INTO COUNTRY VALUES ('FI','FINLAND','Finland','FIN','246');
INSERT INTO COUNTRY VALUES ('FR','FRANCE','France','FRA','250');
INSERT INTO COUNTRY VALUES ('GF','FRENCH GUIANA','French Guiana','GUF','254');
INSERT INTO COUNTRY VALUES ('PF','FRENCH POLYNESIA','French Polynesia','PYF','258');
INSERT INTO COUNTRY VALUES ('TF','FRENCH SOUTHERN TERRITORIES','French Southern Territories',NULL,NULL);
INSERT INTO COUNTRY VALUES ('GA','GABON','Gabon','GAB','266');
INSERT INTO COUNTRY VALUES ('GM','GAMBIA','Gambia','GMB','270');
INSERT INTO COUNTRY VALUES ('GE','GEORGIA','Georgia','GEO','268');
INSERT INTO COUNTRY VALUES ('DE','GERMANY','Germany','DEU','276');
INSERT INTO COUNTRY VALUES ('GH','GHANA','Ghana','GHA','288');
INSERT INTO COUNTRY VALUES ('GI','GIBRALTAR','Gibraltar','GIB','292');
INSERT INTO COUNTRY VALUES ('GR','GREECE','Greece','GRC','300');
INSERT INTO COUNTRY VALUES ('GL','GREENLAND','Greenland','GRL','304');
INSERT INTO COUNTRY VALUES ('GD','GRENADA','Grenada','GRD','308');
INSERT INTO COUNTRY VALUES ('GP','GUADELOUPE','Guadeloupe','GLP','312');
INSERT INTO COUNTRY VALUES ('GU','GUAM','Guam','GUM','316');
INSERT INTO COUNTRY VALUES ('GT','GUATEMALA','Guatemala','GTM','320');
INSERT INTO COUNTRY VALUES ('GN','GUINEA','Guinea','GIN','324');
INSERT INTO COUNTRY VALUES ('GW','GUINEA-BISSAU','Guinea-Bissau','GNB','624');
INSERT INTO COUNTRY VALUES ('GY','GUYANA','Guyana','GUY','328');
INSERT INTO COUNTRY VALUES ('HT','HAITI','Haiti','HTI','332');
INSERT INTO COUNTRY VALUES ('HM','HEARD ISLAND AND MCDONALD ISLANDS','Heard Island and Mcdonald Islands',NULL,NULL);
INSERT INTO COUNTRY VALUES ('VA','HOLY SEE (VATICAN CITY STATE)','Holy See (Vatican City State)','VAT','336');
INSERT INTO COUNTRY VALUES ('HN','HONDURAS','Honduras','HND','340');
INSERT INTO COUNTRY VALUES ('HK','HONG KONG','Hong Kong','HKG','344');
INSERT INTO COUNTRY VALUES ('HU','HUNGARY','Hungary','HUN','348');
INSERT INTO COUNTRY VALUES ('IS','ICELAND','Iceland','ISL','352');
INSERT INTO COUNTRY VALUES ('IN','INDIA','India','IND','356');
INSERT INTO COUNTRY VALUES ('ID','INDONESIA','Indonesia','IDN','360');
INSERT INTO COUNTRY VALUES ('IR','IRAN, ISLAMIC REPUBLIC OF','Iran, Islamic Republic of','IRN','364');
INSERT INTO COUNTRY VALUES ('IQ','IRAQ','Iraq','IRQ','368');
INSERT INTO COUNTRY VALUES ('IE','IRELAND','Ireland','IRL','372');
INSERT INTO COUNTRY VALUES ('IL','ISRAEL','Israel','ISR','376');
INSERT INTO COUNTRY VALUES ('IT','ITALY','Italy','ITA','380');
INSERT INTO COUNTRY VALUES ('JM','JAMAICA','Jamaica','JAM','388');
INSERT INTO COUNTRY VALUES ('JP','JAPAN','Japan','JPN','392');
INSERT INTO COUNTRY VALUES ('JO','JORDAN','Jordan','JOR','400');
INSERT INTO COUNTRY VALUES ('KZ','KAZAKHSTAN','Kazakhstan','KAZ','398');
INSERT INTO COUNTRY VALUES ('KE','KENYA','Kenya','KEN','404');
INSERT INTO COUNTRY VALUES ('KI','KIRIBATI','Kiribati','KIR','296');
INSERT INTO COUNTRY VALUES ('KP','KOREA, DEMOCRATIC PEOPLE\'S REPUBLIC OF','Korea, Democratic People\'s Republic of','PRK','408');
INSERT INTO COUNTRY VALUES ('KR','KOREA, REPUBLIC OF','Korea, Republic of','KOR','410');
INSERT INTO COUNTRY VALUES ('KW','KUWAIT','Kuwait','KWT','414');
INSERT INTO COUNTRY VALUES ('KG','KYRGYZSTAN','Kyrgyzstan','KGZ','417');
INSERT INTO COUNTRY VALUES ('LA','LAO PEOPLE\'S DEMOCRATIC REPUBLIC','Lao People\'s Democratic Republic','LAO','418');
INSERT INTO COUNTRY VALUES ('LV','LATVIA','Latvia','LVA','428');
INSERT INTO COUNTRY VALUES ('LB','LEBANON','Lebanon','LBN','422');
INSERT INTO COUNTRY VALUES ('LS','LESOTHO','Lesotho','LSO','426');