CREATE TABLE `222HAB` (
  `HABCodigo` int(11) NOT NULL AUTO_INCREMENT,
  `HABNombre` char(100) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `HABCodAgente` int(11) NOT NULL DEFAULT '0',
  `HABLink1_THA` int(11) NOT NULL,
  `HABTimeStamp1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`HABCodigo`),
  KEY `HABLink1_THA` (`HABLink1_THA`),
  CONSTRAINT `222HAB-222THA` FOREIGN KEY (`HABLink1_THA`) REFERENCES `222THA` (`THACodigo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;