CREATE TABLE `PLA` (
  `pla_id` int(11) NOT NULL AUTO_INCREMENT,
  `PLANombre` char(80) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `PLACodAgente` int(11) NOT NULL DEFAULT '0',
  `pla_hot_id` int(11) NOT NULL DEFAULT '0',
  `PLALista1` enum('---','Habitación','Persona') COLLATE utf8_spanish_ci NOT NULL,
  `PLABloque1` char(0) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `PLACheckbox1` bit(1) NOT NULL DEFAULT b'0',
  `PLACheckbox2` bit(1) NOT NULL DEFAULT b'0',
  `PLACheckbox3` bit(1) NOT NULL DEFAULT b'0',
  `PLACheckbox4` bit(1) NOT NULL DEFAULT b'0',
  `PLAEspecial` char(0) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `PLAFecha1` date DEFAULT NULL,
  `PLACant1` int(11) NOT NULL DEFAULT '0',
  `PLALista2` enum('---','Añadir','Añadir/Restar','Porcentaje','Precio distinto') COLLATE utf8_spanish_ci NOT NULL,
  `PLACheckbox5` bit(1) NOT NULL DEFAULT b'0',
  `PLACheckbox6` bit(1) NOT NULL DEFAULT b'0',
  `pla_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `pla_created` timestamp NOT NULL DEFAULT '1970-01-01 00:00:00',
  PRIMARY KEY (`pla_id`),
  KEY `pla_hot_id` (`pla_hot_id`),
  CONSTRAINT `PLA-HOT` FOREIGN KEY (`pla_hot_id`) REFERENCES `HOT` (`hot_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;