CREATE TABLE `222USR` (
  `USRCodigo` int(11) NOT NULL AUTO_INCREMENT,
  `USRCodAgente` int(11) NOT NULL DEFAULT '0',
  `USRCodExterno` char(0) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `USRNombre` char(100) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `USRLinea1` char(60) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `USRLinea2` char(60) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `USRLinea3` char(40) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `USRTel1` char(100) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `USRTel2` char(100) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `USREmail1` char(40) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `USRLink1_HOT` int(11) NOT NULL,
  `USREspecial` char(0) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `USRCheckbox1` bit(1) NOT NULL DEFAULT b'0',
  `USRTimeStamp1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`USRCodigo`),
  KEY `USREmail1` (`USREmail1`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;