JhGomezR

CREATE TABLE IF NOT EXISTS `pais` (
  `id_pais` int(11) NOT NULL AUTO_INCREMENT,
  `pais_code` char(2) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `pais_name` varchar(100) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `pais_currency_code` char(3) COLLATE utf8_spanish_ci DEFAULT NULL,
  `pais_fips_code` char(2) COLLATE utf8_spanish_ci DEFAULT NULL,
  `pais_iso_numeric` char(4) COLLATE utf8_spanish_ci DEFAULT NULL,
  `pais_codecall` char(3) COLLATE utf8_spanish_ci NOT NULL,
  `pais_north` varchar(30) COLLATE utf8_spanish_ci DEFAULT NULL,
  `pais_south` varchar(30) COLLATE utf8_spanish_ci DEFAULT NULL,

JhGomezR

CREATE TABLE IF NOT EXISTS `continente` (
  `id_continente` int(11) NOT NULL AUTO_INCREMENT,
  `codigo` char(2) COLLATE utf8_spanish_ci DEFAULT NULL,
  `nombre` varchar(100) COLLATE utf8_spanish_ci DEFAULT NULL,
  `estado` int(1) DEFAULT '1',
  PRIMARY KEY (`id_continente`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

INSERT INTO `continente` (`id_continente`, `codigo`, `nombre`, `estado`) VALUES
	(1, 'EU', 'Europe', 0),