CREATE TABLE `ROL` (
  `rol_id` int(11) NOT NULL AUTO_INCREMENT,
  `rol_from_resource` enum('all','USR','HOT','RES') COLLATE utf8_spanish_ci NOT NULL,
  `rol_from_registry` int(11) NOT NULL,
  `rol_name` enum('admin') COLLATE utf8_spanish_ci NOT NULL,
  `rol_to_resource` enum('all','USR','HOT','RES') COLLATE utf8_spanish_ci NOT NULL,
  `rol_to_registry` int(11) NOT NULL,
  `rol_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `rol_created` timestamp NOT NULL DEFAULT '1970-01-01 00:00:00',
  PRIMARY KEY (`rol_id`),
  UNIQUE KEY `tuple_identifier` (`rol_from_resource`,`rol_from_registry`,`rol_to_resource`,`rol_to_registry`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;