CREATE TABLE `CLI` (
  `cli_id` int(11) NOT NULL AUTO_INCREMENT,
  `cli_name` char(100) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `cli_first_name` char(60) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `cli_last_name` char(60) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `cli_ci` char(10) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `cli_cellphone` char(100) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `cli_phone` char(100) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `cli_email` char(40) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `cli_hot_id` int(11) NOT NULL,
  `cli_usr_id` int(11) DEFAULT NULL,
  `CLICheckbox1` bit(1) DEFAULT b'0',
  `cli_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `cli_created` timestamp NOT NULL DEFAULT '1970-01-01 00:00:00',
  PRIMARY KEY (`cli_id`),
  KEY `cli_hot_id-cli_email` (`cli_hot_id`,`cli_email`),
  KEY `cli_usr_id` (`cli_usr_id`),
  CONSTRAINT `CLI-HOT` FOREIGN KEY (`cli_hot_id`) REFERENCES `HOT` (`hot_id`),
  CONSTRAINT `CLI-USR` FOREIGN KEY (`cli_usr_id`) REFERENCES `USR` (`usr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;