CREATE TABLE `222CLI` (
  `CLICodigo` int(11) NOT NULL AUTO_INCREMENT,
  `CLICodAgente` int(11) NOT NULL DEFAULT '0',
  `CLICodExterno` char(0) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `CLINombre` char(100) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `CLILinea1` char(60) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `CLILinea2` char(60) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `CLILinea3` char(10) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `CLITel1` char(100) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `CLITel2` char(100) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `CLIEmail1` char(40) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `CLILink1_HOT` int(11) NOT NULL,
  `CLILink1_USR` int(11) DEFAULT NULL,
  `CLIEspecial` char(0) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `CLICheckbox1` bit(1) DEFAULT b'0',
  `CLITimeStamp1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`CLICodigo`),
  KEY `CLILink1_HOT-CLIEmail1` (`CLILink1_HOT`,`CLIEmail1`),
  KEY `222CLI-222USR` (`CLILink1_USR`),
  CONSTRAINT `222CLI-222HOT` FOREIGN KEY (`CLILink1_HOT`) REFERENCES `222HOT` (`HOTCodigo`),
  CONSTRAINT `222CLI-222USR` FOREIGN KEY (`CLILink1_USR`) REFERENCES `222USR` (`USRCodigo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;