/*
SQLyog Community Edition- MySQL GUI v7.14 
MySQL - 5.1.30-community : Database - appointmentsdb
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*Table structure for table `country` */

DROP TABLE IF EXISTS `country`;

CREATE TABLE `country` (
  `code` char(2) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `country` */

insert  into `country`(`code`,`name`) values ('AD','Andorra');
insert  into `country`(`code`,`name`) values ('AE','United Arab Emirates');
insert  into `country`(`code`,`name`) values ('AF','Afghanistan');
insert  into `country`(`code`,`name`) values ('AG','Antigua and Barbuda');
insert  into `country`(`code`,`name`) values ('AI','Anguilla');
insert  into `country`(`code`,`name`) values ('AL','Albania');
insert  into `country`(`code`,`name`) values ('AM','Armenia');
insert  into `country`(`code`,`name`) values ('AN','Netherlands Antilles');
insert  into `country`(`code`,`name`) values ('AO','Angola');
insert  into `country`(`code`,`name`) values ('AQ','Antarctica');
insert  into `country`(`code`,`name`) values ('AR','Argentina');
insert  into `country`(`code`,`name`) values ('AT','Austria');
insert  into `country`(`code`,`name`) values ('AU','Australia');
insert  into `country`(`code`,`name`) values ('AW','Aruba');
insert  into `country`(`code`,`name`) values ('AZ','Azerbaijan');
insert  into `country`(`code`,`name`) values ('BA','Bosnia and Herzegovina');
insert  into `country`(`code`,`name`) values ('BB','Barbados');
insert  into `country`(`code`,`name`) values ('BD','Bangladesh');
insert  into `country`(`code`,`name`) values ('BE','Belgium');
insert  into `country`(`code`,`name`) values ('BF','Burkina Faso');
insert  into `country`(`code`,`name`) values ('BG','Bulgaria');
insert  into `country`(`code`,`name`) values ('BH','Bahrain');
insert  into `country`(`code`,`name`) values ('BJ','Benin');
insert  into `country`(`code`,`name`) values ('BM','Bermuda');
insert  into `country`(`code`,`name`) values ('BN','Brunei');
insert  into `country`(`code`,`name`) values ('BO','Bolivia');
insert  into `country`(`code`,`name`) values ('BR','Brazil');
insert  into `country`(`code`,`name`) values ('BS','Bahamas');
insert  into `country`(`code`,`name`) values ('BT','Bhutan');
insert  into `country`(`code`,`name`) values ('BW','Botswana');
insert  into `country`(`code`,`name`) values ('BY','Belarus');
insert  into `country`(`code`,`name`) values ('BZ','Belize');
insert  into `country`(`code`,`name`) values ('CA','Canada');
insert  into `country`(`code`,`name`) values ('CD','Democratic Repubilic of Congo');
insert  into `country`(`code`,`name`) values ('CF','Central African Republic');
insert  into `country`(`code`,`name`) values ('CG','Congo');
insert  into `country`(`code`,`name`) values ('CH','Switzerland');
insert  into `country`(`code`,`name`) values ('CI','Cote D\'Ivoire');
insert  into `country`(`code`,`name`) values ('CL','Chile');
insert  into `country`(`code`,`name`) values ('CM','Cameroon');
insert  into `country`(`code`,`name`) values ('CN','China');
insert  into `country`(`code`,`name`) values ('CO','Columbia');
insert  into `country`(`code`,`name`) values ('CR','Costa Rica');
insert  into `country`(`code`,`name`) values ('CS','Serbia and Montenegro');
insert  into `country`(`code`,`name`) values ('CU','Cuba');
insert  into `country`(`code`,`name`) values ('CV','Cape Verde');
insert  into `country`(`code`,`name`) values ('CW','Cook Islands');
insert  into `country`(`code`,`name`) values ('CX','Christmas Island');
insert  into `country`(`code`,`name`) values ('CY','Cyprus');
insert  into `country`(`code`,`name`) values ('CZ','Czech Republic');
insert  into `country`(`code`,`name`) values ('DE','Germany');
insert  into `country`(`code`,`name`) values ('DJ','Djibouti');
insert  into `country`(`code`,`name`) values ('DK','Denmark');
insert  into `country`(`code`,`name`) values ('DM','Dominica');
insert  into `country`(`code`,`name`) values ('DO','Dominican Republic');
insert  into `country`(`code`,`name`) values ('DZ','Algeria');
insert  into `country`(`code`,`name`) values ('EC','Ecuador');
insert  into `country`(`code`,`name`) values ('EE','Estonia');
insert  into `country`(`code`,`name`) values ('EG','Egypt');
insert  into `country`(`code`,`name`) values ('ER','Eritrea');
insert  into `country`(`code`,`name`) values ('ES','Spain');
insert  into `country`(`code`,`name`) values ('ET','Ethiopia');
insert  into `country`(`code`,`name`) values ('FI','Finland');
insert  into `country`(`code`,`name`) values ('FJ','Fiji');
insert  into `country`(`code`,`name`) values ('FK','Falkland Islands');
insert  into `country`(`code`,`name`) values ('FM','Micronesia');
insert  into `country`(`code`,`name`) values ('FO','Faroe Islands');
insert  into `country`(`code`,`name`) values ('FP','French Polynesia');
insert  into `country`(`code`,`name`) values ('FR','France');
insert  into `country`(`code`,`name`) values ('GA','Gabon');
insert  into `country`(`code`,`name`) values ('GB','United Kingdom');
insert  into `country`(`code`,`name`) values ('GD','Grenada');
insert  into `country`(`code`,`name`) values ('GE','Georgia');
insert  into `country`(`code`,`name`) values ('GF','French Guiana');
insert  into `country`(`code`,`name`) values ('GG','Guernsey');
insert  into `country`(`code`,`name`) values ('GH','Ghana');
insert  into `country`(`code`,`name`) values ('GI','Gibraltar');
insert  into `country`(`code`,`name`) values ('GL','Greenland');
insert  into `country`(`code`,`name`) values ('GM','Gambia');
insert  into `country`(`code`,`name`) values ('GN','Guinea');
insert  into `country`(`code`,`name`) values ('GP','Guadeloupe');
insert  into `country`(`code`,`name`) values ('GQ','Equatorial Guinea');
insert  into `country`(`code`,`name`) values ('GR','Greece');
insert  into `country`(`code`,`name`) values ('GS','South Georgia');
insert  into `country`(`code`,`name`) values ('GT','Guatemala');
insert  into `country`(`code`,`name`) values ('GW','Guinea-Bissau');
insert  into `country`(`code`,`name`) values ('GY','Guyana');
insert  into `country`(`code`,`name`) values ('HN','Honduras');
insert  into `country`(`code`,`name`) values ('HR','Croatia');
insert  into `country`(`code`,`name`) values ('HT','Haiti');
insert  into `country`(`code`,`name`) values ('HU','Hungary');
insert  into `country`(`code`,`name`) values ('ID','Indonesia');
insert  into `country`(`code`,`name`) values ('IE','Ireland');
insert  into `country`(`code`,`name`) values ('IL','Israel');
insert  into `country`(`code`,`name`) values ('IM','Isle of Man');
insert  into `country`(`code`,`name`) values ('IN','India');
insert  into `country`(`code`,`name`) values ('IQ','Iraq');
insert  into `country`(`code`,`name`) values ('IR','Iran');
insert  into `country`(`code`,`name`) values ('IS','Iceland');
insert  into `country`(`code`,`name`) values ('IT','Italy');
insert  into `country`(`code`,`name`) values ('JE','Jersey');
insert  into `country`(`code`,`name`) values ('JM','Jamaica');
insert  into `country`(`code`,`name`) values ('JO','Jordan');
insert  into `country`(`code`,`name`) values ('JP','Japan');
insert  into `country`(`code`,`name`) values ('KE','Kenya');
insert  into `country`(`code`,`name`) values ('KG','Kyrgyzstan');
insert  into `country`(`code`,`name`) values ('KH','Cambodia');
insert  into `country`(`code`,`name`) values ('KI','Kiribati');
insert  into `country`(`code`,`name`) values ('KM','Comoros');
insert  into `country`(`code`,`name`) values ('KN','Saint Kitts and Nevis');
insert  into `country`(`code`,`name`) values ('KP','North Korea');
insert  into `country`(`code`,`name`) values ('KR','South Korea');
insert  into `country`(`code`,`name`) values ('KW','Kuwait');
insert  into `country`(`code`,`name`) values ('KY','Cayman Islands');
insert  into `country`(`code`,`name`) values ('KZ','Kazakhstan');
insert  into `country`(`code`,`name`) values ('LA','Laos');
insert  into `country`(`code`,`name`) values ('LB','Lebanon');
insert  into `country`(`code`,`name`) values ('LC','Saint Lucia');
insert  into `country`(`code`,`name`) values ('LI','Liechtenstein');
insert  into `country`(`code`,`name`) values ('LK','Sri Lanka');
insert  into `country`(`code`,`name`) values ('LR','Liberia');
insert  into `country`(`code`,`name`) values ('LS','Lesotho');
insert  into `country`(`code`,`name`) values ('LT','Lithuania');
insert  into `country`(`code`,`name`) values ('LU','Luxembourg');
insert  into `country`(`code`,`name`) values ('LV','Latvia');
insert  into `country`(`code`,`name`) values ('LY','Libya');
insert  into `country`(`code`,`name`) values ('MA','Macau');
insert  into `country`(`code`,`name`) values ('MB','Martinique');
insert  into `country`(`code`,`name`) values ('MC','Monaco');
insert  into `country`(`code`,`name`) values ('MD','Moldova');
insert  into `country`(`code`,`name`) values ('MG','Madagascar');
insert  into `country`(`code`,`name`) values ('MH','Marshall Islands');
insert  into `country`(`code`,`name`) values ('MK','Macedonia');
insert  into `country`(`code`,`name`) values ('ML','Mali');
insert  into `country`(`code`,`name`) values ('MM','Myanmar');
insert  into `country`(`code`,`name`) values ('MN','Mongolia');
insert  into `country`(`code`,`name`) values ('MR','Mauritania');
insert  into `country`(`code`,`name`) values ('MS','Montserrat');
insert  into `country`(`code`,`name`) values ('MT','Malta');
insert  into `country`(`code`,`name`) values ('MU','Mauritius');
insert  into `country`(`code`,`name`) values ('MV','Maldives');
insert  into `country`(`code`,`name`) values ('MW','Malawi');
insert  into `country`(`code`,`name`) values ('MX','Mexico');
insert  into `country`(`code`,`name`) values ('MY','Malaysia');
insert  into `country`(`code`,`name`) values ('MZ','Mozambique');
insert  into `country`(`code`,`name`) values ('NA','Namibia');
insert  into `country`(`code`,`name`) values ('NC','New Caledonia');
insert  into `country`(`code`,`name`) values ('NE','Niger');
insert  into `country`(`code`,`name`) values ('NF','Norfolk Island');
insert  into `country`(`code`,`name`) values ('NG','Nigeria');
insert  into `country`(`code`,`name`) values ('NI','Nicaragua');
insert  into `country`(`code`,`name`) values ('NL','Netherlands');
insert  into `country`(`code`,`name`) values ('NO','Norway');
insert  into `country`(`code`,`name`) values ('NP','Nepal');
insert  into `country`(`code`,`name`) values ('NR','Nauru');
insert  into `country`(`code`,`name`) values ('NU','Niue');
insert  into `country`(`code`,`name`) values ('NZ','New Zealand');
insert  into `country`(`code`,`name`) values ('OM','Oman');
insert  into `country`(`code`,`name`) values ('PA','Panama');
insert  into `country`(`code`,`name`) values ('PE','Peru');
insert  into `country`(`code`,`name`) values ('PG','Papua New Guinea');
insert  into `country`(`code`,`name`) values ('PH','Philippines');
insert  into `country`(`code`,`name`) values ('PK','Pakistan');
insert  into `country`(`code`,`name`) values ('PL','Poland');
insert  into `country`(`code`,`name`) values ('PM','Saint Pierre and Miquelon');
insert  into `country`(`code`,`name`) values ('PN','Pitcairn Islands');
insert  into `country`(`code`,`name`) values ('PT','Portugal');
insert  into `country`(`code`,`name`) values ('PW','Palau');
insert  into `country`(`code`,`name`) values ('PY','Paraguay');
insert  into `country`(`code`,`name`) values ('QA','Qatar');
insert  into `country`(`code`,`name`) values ('RE','Reunion');
insert  into `country`(`code`,`name`) values ('RO','Romania');
insert  into `country`(`code`,`name`) values ('RU','Russia');
insert  into `country`(`code`,`name`) values ('RW','Rwanda');
insert  into `country`(`code`,`name`) values ('SA','Saudi Arabia');
insert  into `country`(`code`,`name`) values ('SB','Solomon Islands');
insert  into `country`(`code`,`name`) values ('SC','Seychelles');
insert  into `country`(`code`,`name`) values ('SD','Sudan');
insert  into `country`(`code`,`name`) values ('SE','Sweden');
insert  into `country`(`code`,`name`) values ('SG','Singapore');
insert  into `country`(`code`,`name`) values ('SH','Saint Helena');
insert  into `country`(`code`,`name`) values ('SI','Slovenia');
insert  into `country`(`code`,`name`) values ('SJ','Svalbard');
insert  into `country`(`code`,`name`) values ('SK','Slovakia');
insert  into `country`(`code`,`name`) values ('SL','Sierra Leone');
insert  into `country`(`code`,`name`) values ('SM','San Marino');
insert  into `country`(`code`,`name`) values ('SN','Senegal');
insert  into `country`(`code`,`name`) values ('SO','Somalia');
insert  into `country`(`code`,`name`) values ('SR','Suriname');
insert  into `country`(`code`,`name`) values ('ST','Sao Tome & Principe');
insert  into `country`(`code`,`name`) values ('SV','El Salvador');
insert  into `country`(`code`,`name`) values ('SY','Syria');
insert  into `country`(`code`,`name`) values ('SZ','Swaziland');
insert  into `country`(`code`,`name`) values ('TC','Turks and Caicos Islands');
insert  into `country`(`code`,`name`) values ('TD','Chad');
insert  into `country`(`code`,`name`) values ('TG','Togo');
insert  into `country`(`code`,`name`) values ('TH','Thailand');
insert  into `country`(`code`,`name`) values ('TJ','Tajikistan');
insert  into `country`(`code`,`name`) values ('TK','Tokelau');
insert  into `country`(`code`,`name`) values ('TL','East Timor');
insert  into `country`(`code`,`name`) values ('TM','Turkmenistan');
insert  into `country`(`code`,`name`) values ('TN','Tunisia');
insert  into `country`(`code`,`name`) values ('TO','Tonga');
insert  into `country`(`code`,`name`) values ('TR','Turkey');
insert  into `country`(`code`,`name`) values ('TT','Trinidad and Tobago');
insert  into `country`(`code`,`name`) values ('TV','Tuvalu');
insert  into `country`(`code`,`name`) values ('TW','Taiwan');
insert  into `country`(`code`,`name`) values ('TZ','Tanzania');
insert  into `country`(`code`,`name`) values ('UA','Ukraine');
insert  into `country`(`code`,`name`) values ('UG','Uganda');
insert  into `country`(`code`,`name`) values ('US','United States');
insert  into `country`(`code`,`name`) values ('UY','Uruguay');
insert  into `country`(`code`,`name`) values ('UZ','Uzbekistan');
insert  into `country`(`code`,`name`) values ('VA','Vatican City');
insert  into `country`(`code`,`name`) values ('VC','Saint Vincent and the Grenadines');
insert  into `country`(`code`,`name`) values ('VE','Venezuela');
insert  into `country`(`code`,`name`) values ('VG','British Virgin Islands');
insert  into `country`(`code`,`name`) values ('VN','Vietnam');
insert  into `country`(`code`,`name`) values ('VU','Vanuatu');
insert  into `country`(`code`,`name`) values ('WF','Wallis and Futuna');
insert  into `country`(`code`,`name`) values ('WS','Samoa');
insert  into `country`(`code`,`name`) values ('YE','Yemen');
insert  into `country`(`code`,`name`) values ('YT','Mayotte');
insert  into `country`(`code`,`name`) values ('ZA','South Africa');
insert  into `country`(`code`,`name`) values ('ZM','Zambia');
insert  into `country`(`code`,`name`) values ('ZW','Zimbabwe');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;