CREATE TABLE `YEAR_STUDENT_SPECIAL_SITUATION_CODE` (                                                
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,                                                                                      
  `KEY_EXECUTION_YEAR` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT '1',
  `KEY_SPECIAL_SITUATION_CODE` int(11) DEFAULT NULL,
  `KEY_STUDENT` int(11) DEFAULT NULL,
  `OID` bigint(20) unsigned DEFAULT NULL,
  `OID_EXECUTION_YEAR` bigint(20) unsigned DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) unsigned DEFAULT NULL,
  `OID_SPECIAL_SITUATION_CODE` bigint(20) unsigned DEFAULT NULL,
  `OID_STUDENT` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `KEY_EXECUTION_YEAR` (`KEY_EXECUTION_YEAR`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `KEY_SPECIAL_SITUATION_CODE` (`KEY_SPECIAL_SITUATION_CODE`),
  KEY `KEY_STUDENT` (`KEY_STUDENT`),
  KEY `OID` (`OID`),
  KEY `OID_EXECUTION_YEAR` (`OID_EXECUTION_YEAR`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`),
  KEY `OID_SPECIAL_SITUATION_CODE` (`OID_SPECIAL_SITUATION_CODE`),
  KEY `OID_STUDENT` (`OID_STUDENT`)
) ENGINE=INNODB DEFAULT CHARSET=latin1;