CREATE TABLE `CIU` (
  `ciu_id` int(11) NOT NULL AUTO_INCREMENT,
  `ciu_name` char(80) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `ciu_enabled` bit(1) NOT NULL DEFAULT b'0',
  `ciu_country` enum('---','Afganistan','Africa del Sur','Albania','Alemania','Andorra','Angola','Antigua y Barbuda','Antillas Holandesas','Arabia Saudita','Argelia','Argentina','Armenia','Aruba','Australia','Austria','Azerbaijan','Bahamas','Bahrain','Bangladesh','Barbados','Belarusia','Belgica','Belice','Benin','Bermudas','Bolivia','Bosnia','Botswana','Brasil','Brunei Darussulam','Bulgaria','Burkina Faso','Burundi','Butan','Camboya','Camerun','Canada','Cape Verde','Chad','Chile','China','Chipre','Colombia','Comoros','Congo','Corea del Norte','Corea del Sur','Costa de Marfíl','Costa Rica','Croacia','Cuba','Dinamarca','Djibouti','Dominica','Ecuador','Egipto','El Salvador','Emiratos Arabes Unidos','Eritrea','Eslovenia','Espana','Estados Unidos','Estonia','Etiopia','Fiji','Filipinas','Finlandia','Francia','Gabon','Gambia','Georgia','Ghana','Granada','Grecia','Groenlandia','Guadalupe','Guam','Guatemala','Guayana Francesa','Guerney','Guinea','Guinea Bissau','Guinea Equatorial','Guyana','Haiti','Holanda','Honduras','Hong Kong','Hungria','India','Indonesia','Irak','Iran','Irlanda','Islandia','Islas Caiman','Islas Faroe','Islas Malvinas','Islas Marshall','Islas Solomon','Islas Virgenes Britanicas','Islas Virgenes (U.S.)','Israel','Italia','Jamaica','Japon','Jersey','Jordania','Kazakhstan','Kenia','Kiribati','Kuwait','Kyrgyzstan','Laos','Latvia','Lesotho','Libano','Liberia','Libia','Liechtenstein','Lituania','Luxemburgo','Macao','Macedonia','Madagascar','Malasia','Malawi','Maldivas','Mali','Malta','Marruecos','Martinica','Mauricio','Mauritania','Mexico','Micronesia','Moldova','Monaco','Mongolia','Mozambique','Myanmar (Burma)','Namibia','Nepal','Nicaragua','Niger','Nigeria','Noruega','Nueva Caledonia','Nueva Zelandia','Oman','Pakistan','Palestina','Panama','Papua Nueva Guinea','Paraguay','Peru','Polinesia Francesa','Polonia','Portugal','Puerto Rico','Qatar','Reino Unido','Republica Centroafricana','Republica Checa','Republica Democratica del Congo','Republica Dominicana','Republica Eslovaca','Reunion','Ruanda','Rumania','Rusia','Sahara','Samoa','San Cristobal-Nevis (St. Kitts)','San Marino','San Vincente y las Granadinas','Santa Helena','Santa Lucia','Santa Sede (Vaticano)','Sao Tome y Principe','Senegal','Seychelles','Sierra Leona','Singapur','Siria','Somalia','Sri Lanka (Ceilan)','Sudan','Suecia','Suiza','Sur Africa','Surinam','Swaziland','Tailandia','Taiwan','Tajikistan','Tanzania','Timor Oriental','Togo','Tokelau','Tonga','Trinidad y Tobago','Tunisia','Turkmenistan','Turquia','Ucrania','Uganda','Union Europea','Uruguay','Uzbekistan','Venezuela','Vanuatu','Vietnam','Yemen','Yugoslavia','Zambia','Zimbabwe') COLLATE utf8_spanish_ci NOT NULL,
  `ciu_destiny` char(255) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `ciu_airport` char(4) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `ciu_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `ciu_created` timestamp NOT NULL DEFAULT '1970-01-01 00:00:00',
  PRIMARY KEY (`ciu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;