CREATE TABLE `222TPR` (
  `TPRCodigo` int(11) NOT NULL AUTO_INCREMENT,
  `TPRNombre` char(100) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `TPRCodAgente` int(11) NOT NULL DEFAULT '0',
  `TPRCodExterno` char(0) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `TPRBloque1` char(255) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `TPREspecial` char(0) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `TPRLink1_HOT` int(11) NOT NULL,
  `TPRFecha1` date NOT NULL,
  `TPRHora1` time DEFAULT NULL,
  `TPRLista1` enum('Todo o nada','Mínimo') COLLATE utf8_spanish_ci NOT NULL,
  `TPRCant1` int(11) DEFAULT NULL,
  `TPRCheckbox1` bit(1) NOT NULL DEFAULT b'0',
  `TPRTimeStamp1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`TPRCodigo`),
  KEY `222TPR-222HOT` (`TPRLink1_HOT`),
  CONSTRAINT `222TPR-222HOT` FOREIGN KEY (`TPRLink1_HOT`) REFERENCES `222HOT` (`HOTCodigo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;