CREATE TABLE `TPR` (
  `tpr_id` int(11) NOT NULL AUTO_INCREMENT,
  `tpr_name` char(100) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `tpr_description` char(255) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `tpr_hot_id` int(11) NOT NULL,
  `tpr_restriction` enum('Todo o nada','Mínimo') COLLATE utf8_spanish_ci NOT NULL,
  `tpr_min_nights` int(11) DEFAULT NULL,
  `tpr_enabled` bit(1) NOT NULL DEFAULT b'0',
  `tpr_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `tpr_created` timestamp NOT NULL DEFAULT '1970-01-01 00:00:00',
  PRIMARY KEY (`tpr_id`),
  KEY `tpr_hot_id` (`tpr_hot_id`),
  CONSTRAINT `TPR-HOT` FOREIGN KEY (`tpr_hot_id`) REFERENCES `HOT` (`hot_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;