CREATE TABLE `222PRE` (
  `PRECodigo` int(11) NOT NULL AUTO_INCREMENT,
  `PRENombre` char(0) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `PRECodAgente` int(11) NOT NULL DEFAULT '0',
  `PRECodExterno` char(0) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `PRELink1_HOT` int(11) NOT NULL,
  `PRELink1_TPR` int(11) NOT NULL,
  `PRELink1_PLA` int(11) NOT NULL,
  `PRELink1_THA` int(11) NOT NULL,
  `PREMonto1` double NOT NULL,
  `PREMonto2` double NOT NULL,
  `PREMonto3` double NOT NULL,
  `PREMonto4` double NOT NULL,
  `PREMonto5` double NOT NULL,
  `PREMonto6` double NOT NULL,
  `PREMonto7` double NOT NULL,
  `PREMonto8` double NOT NULL,
  `PREMonto9` double NOT NULL,
  `PREMonto10` double NOT NULL,
  `PREMonto11` double NOT NULL,
  `PREMonto12` double NOT NULL,
  `PREMonto13` double NOT NULL,
  `PRETimeStamp1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`PRECodigo`),
  UNIQUE KEY `PRELink1_HOT-PRELink1_TPR-PRELink1_PLA-PRELink1_THA` (`PRELink1_HOT`,`PRELink1_TPR`,`PRELink1_PLA`,`PRELink1_THA`),
  KEY `222PRE-222TPR` (`PRELink1_TPR`),
  KEY `222PRE-222PLA` (`PRELink1_PLA`),
  KEY `222PRE-222THA` (`PRELink1_THA`),
  CONSTRAINT `222PRE-222HOT` FOREIGN KEY (`PRELink1_HOT`) REFERENCES `222HOT` (`HOTCodigo`),
  CONSTRAINT `222PRE-222PLA` FOREIGN KEY (`PRELink1_PLA`) REFERENCES `222PLA` (`PLACodigo`),
  CONSTRAINT `222PRE-222THA` FOREIGN KEY (`PRELink1_THA`) REFERENCES `222THA` (`THACodigo`),
  CONSTRAINT `222PRE-222TPR` FOREIGN KEY (`PRELink1_TPR`) REFERENCES `222TPR` (`TPRCodigo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;