CREATE TABLE `222C2D` (
  `C2DCodigo` int(11) NOT NULL AUTO_INCREMENT,
  `C2DNombre` char(100) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `C2DCodAgente` int(11) NOT NULL DEFAULT '0',
  `C2DLink1_CIU` int(11) NOT NULL,
  `C2DLink1_DES` int(11) NOT NULL,
  `C2DEspecial` char(0) COLLATE utf8_spanish_ci NOT NULL,
  `C2DTimeStamp1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`C2DCodigo`),
  KEY `C2DLink1_CIU` (`C2DLink1_CIU`),
  KEY `C2DLink1_DES` (`C2DLink1_DES`),
  CONSTRAINT `222C2D-222CIU` FOREIGN KEY (`C2DLink1_CIU`) REFERENCES `222CIU` (`CIUCodigo`),
  CONSTRAINT `222C2D-222DES` FOREIGN KEY (`C2DLink1_DES`) REFERENCES `222DES` (`DESCodigo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;