CREATE TABLE IF NOT EXISTS `embassies` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `countryCode` int(11) NOT NULL,
  `Name` varchar(128) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

ALTER TABLE `persons` ADD `PassportIssuingAuthority` VARCHAR( 64 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
ADD `PassportIssuingDate` DATE NULL ,
ADD `PassportExpirationDate` DATE NULL AFTER `IDType`; 
ALTER TABLE `persons` ADD `Embassy` INT NOT NULL AFTER `Nationality`;
