CREATE TABLE `222ROL` (
  `ROLCodigo` int(11) NOT NULL AUTO_INCREMENT,
  `ROLNombre` char(100) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `ROLCodAgente` int(11) NOT NULL DEFAULT '0',
  `ROLLista1` enum('all','222USR','222HOT','222RES') COLLATE utf8_spanish_ci NOT NULL,
  `ROLCant1` int(11) NOT NULL,
  `ROLLista2` enum('admin') COLLATE utf8_spanish_ci NOT NULL,
  `ROLLista3` enum('all','222USR','222HOT','222RES') COLLATE utf8_spanish_ci NOT NULL,
  `ROLCant2` int(11) NOT NULL,
  `ROLTimeStamp1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`ROLCodigo`),
  KEY `ROLLista1-ROLCant1-ROLLista3-ROLCant2` (`ROLLista1`,`ROLCant1`,`ROLLista3`,`ROLCant2`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;