592k1PPG

1
2CREATE TABLE IF NOT EXISTS `beer_tag_db`.`countries` (
3  `CountryId` INT(11) NOT NULL AUTO_INCREMENT,
4  `CountryCode` VARCHAR(2) NOT NULL,
5  `CountryName` VARCHAR(45) NOT NULL,
6  PRIMARY KEY (`CountryId`))
7ENGINE = InnoDB
8DEFAULT CHARACTER SET = utf8;
9
10INSERT INTO `countries`(CountryCode, CountryName) VALUES ('AF','Afghanistan'),('AX', 'Aland Islands'),('AL','Albania'),('DZ','Algeria'),('AS','American Samoa'),('AD','Andorra'),('AO','Angola'),('AI','Anguilla'),('AQ','Antarctica'),('AG','Antigua And Barbuda'),('AR','Argentina'),('AM','Armenia'),('AW','Aruba'),('AU','Australia'),('AT','Austria'),('AZ','Azerbaijan'),
11 ('BS','Bahamas'),('BH','Bahrain'),('BD','Bangladesh'),('BB','Barbados'),('BY','Belarus'),('BE','Belgium'),('BZ','Belize'),('BJ','Benin'),('BM','Bermuda'),('BT','Bhutan'),('BO','Bolivia'),('BA','Bosnia And Herzegovina'),('BW','Botswana'),('BV', 'Bouvet Island'),('BR','Brazil'),('IO','BritishIndianOceanTerritory'),('BN','Brunei Darussalam'),('BG','Bulgaria'),('BF','Burkina Faso'),('BI','Burundi'),
12    ('KH','Cambodia'),('CM','Cameroon'),('CA','Canada'),('CV','Cape Verde'),('KY','Cayman Islands'),('CF','Central African Republic'),('TD','Chad'),('CL','Chile'),('CN','China'),('CX','Christmas Island'),('CC','Cocos Keeling Islands'),('CO','Colombia'),('KM','Comoros'),('CG','Congo'),('CD','Congo Democratic Republic'),('CK','Cook Islands'),('CR','Costa Rica'),('CI','Cote D\'Ivoire'),('HR','Croatia'),('CU','Cuba'),('CY','Cyprus'),('CZ','Czech Republic'),
13    ('DK','Denmark'),('DJ','Djibouti'),('DM','Dominica'),('DO','Dominican Republic'),('EC','Ecuador'),('EG','Egypt'),('SV','El Salvador'),('GQ','Equatorial Guinea'),('ER','Eritrea'),('EE','Estonia'),('ET','Ethiopia'),('FK','Falkland Islands'),('FO','Faroe Islands'),('FJ','Fiji'),('FI','Finland'),('FR','France'),('GF','French Guiana'),('PF','French Polynesia'),('TF','French Southern Territories'),
14    ('GA','Gabon'),('GM','Gambia'),('GE','Georgia'),('DE','Germany'),('GH','Ghana'),('GI','Gibraltar'),('GR','Greece'),('GL','Greenland'),('GD','Grenada'),('GP','Guadeloupe'),('GU','Guam'),('GT','Guatemala'),('GG','Guernsey'),('GN','Guinea'),('GW','Guinea Bissau'),('GY','Guyana'),
15    ('HT','Haiti'),('HM','Heard Island McDonald Islands'),('VA','Holy See Vatican City State'),('HN','Honduras'),('HK','Hong Kong'),('HU','Hungary'),
16    ('IS','Iceland'),('IN','India'),('ID','Indonesia'),('IR','Iran'),('IQ','Iraq'),('IE','Ireland'),('IM','Isle Of Man'),('IL','Israel'),('IT','Italy'),('JM','Jamaica'),('JP','Japan'),('JE','Jersey'),('JO','Jordan'),('KZ','Kazakhstan'),('KE','Kenya'),('KI','Kiribati'),('KR','Korea'),('KW','Kuwait'),('KG','Kyrgyzstan'),
17    ('LA','Lao Peoples Democratic Republic'),('LV','Latvia'),('LB','Lebanon'),('LS','Lesotho'),('LR','Liberia'),('LY','Libyan Arab Jamahiriya'),('LI','Liechtenstein'),('LT','Lithuania'),('LU','Luxembourg'),('MO','Macao'),('MK','Macedonia'),('MG','Madagascar'),('MW','Malawi'),('MY','Malaysia'),('MV','Maldives'),('ML','Mali'),('MT','Malta'),
18	('MH','Marshall Islands'),('MQ','Martinique'),('MR','Mauritania'),('MU','Mauritius'),('YT','Mayotte'),('MX','Mexico'),('FM','Micronesia'),('MD','Moldova'),('MC','Monaco'),('MN','Mongolia'),('ME','Montenegro'),('MS','Montserrat'),('MA','Morocco'),('MZ','Mozambique'),('MM','Myanmar'),('NA','Namibia'),('NR','Nauru'),('NP','Nepal'),('NL','Netherlands'),('AN','Netherlands Antilles'),('NC','New Caledonia'),('NZ','New Zealand'),('NI','Nicaragua'),('NE','Niger'),('NG','Nigeria'),('NU','Niue'),('NF','Norfolk Island'),
19	('MP','Northern Mariana Islands'),('NO','Norway'),('OM','Oman'),('PK','Pakistan'),('PW','Palau'),('PS','Palestinian Territory'),('PA','Panama'),('PG','Papua New Guinea'),('PY','Paraguay'),('PE','Peru'),('PH','Philippines'),('PN','Pitcairn'),('PL','Poland'),('PT','Portugal'),('PR','Puerto Rico'),('QA','Qatar'),('RE','Reunion'),('RO','Romania'),('RU','Russian Federation'),
20	('RW','Rwanda'),('BL','Saint Barthelemy'),('SH','SaintHelena'),('KN','Saint Kitts And Nevis'),('LC','Saint Lucia'),('MF','Saint Martin'),('PM','Saint Pierre And Miquelon'),('VC','Saint Vincent And Grenadines'),('WS','Samoa'),('SM','San Marino'),('ST','SaoTome And Principe'),('SA','Saudi Arabia'),('SN','Senegal'),('RS','Serbia'),('SC','Seychelles'),('SL','SierraLeone'),('SG','Singapore'),('SK','Slovakia'),('SI','Slovenia'),('SB','Solomon Islands'),('SO','Somalia'),('ZA','South Africa'),('GS','South Georgia And Sandwich Isl'),('ES','Spain'),
21	('LK','Sri Lanka'),('SD','Sudan'),('SR','Suriname'),('SJ','Svalbard And Jan Mayen'),('SZ','Swaziland'),('SE','Sweden'),('CH','Switzerland'),('SY','Syrian Arab Republic'),('TW','Taiwan'),('TJ','Tajikistan'),('TZ','Tanzania'),('TH','Thailand'),('TL','Timor Leste'),('TG','Togo'),('TK','Tokelau'),('TO','Tonga'),('TT','Trinidad And Tobago'),('TN','Tunisia'),('TR','Turkey'),
22	('TM','Turkmenistan'),('TC','Turks And Caicos Islands'),('TV','Tuvalu'),('UG','Uganda'),('UA','Ukraine'),('AE','United Arab Emirates'),('GB','United Kingdom'),('US','United States'),('UM','United States Out lying Islands'),('UY','Uruguay'),('UZ','Uzbekistan'),('VU','Vanuatu'),('VE','Venezuela'),('VN','Viet Nam'),('VG','Virgin Islands British'),
23	('VI','Virgin Islands US'),('WF','Wallis And Futuna'),('EH','Western Sahara'),('YE','Yemen'),('ZM','Zambia'),('ZW','Zimbabwе');