alter table `PRECEDENT_DEGREE_INFORMATION` add `PRECEDENT_DEGREE_DESIGNATION` text, add `NUMBER_OF_ENROLMENTS_IN_PREVIOUS_DEGREES` int(11), add `MOBILITY_PROGRAM_DURATION` text, add `PRECEDENT_SCHOOL_LEVEL` text, add `OID_PERSONAL_INGRESSION_DATA` bigint unsigned, add `OID_PRECEDENT_INSTITUTION` bigint unsigned, add `OID_REGISTRATION` bigint unsigned, add index (OID_REGISTRATION), add index (OID_PERSONAL_INGRESSION_DATA), add index (OID_PRECEDENT_INSTITUTION);
create table `PERSONAL_INGRESSION_DATA` (
`OID` bigint unsigned, 
`MARITAL_STATUS` text, 
`GRANT_OWNER_TYPE` text,
`DISLOCATED_FROM_PERMANENT_RESIDENCE` tinyint(1),
`PROFESSIONAL_CONDITION` text,
`PROFESSION_TYPE` text,
`MOTHER_SCHOOL_LEVEL` text,  
`MOTHER_PROFESSION_TYPE` text,
`MOTHER_PROFESSIONAL_CONDITION` text,
`FATHER_SCHOOL_LEVEL` text, 
`FATHER_PROFESSION_TYPE` text,
`FATHER_PROFESSIONAL_CONDITION` text, 
`SPOUSE_SCHOOL_LEVEL` text, 
`SPOUSE_PROFESSION_TYPE` text,
`SPOUSE_PROFESSIONAL_CONDITION` text, 
`OID_STUDENT` bigint unsigned, 
`OID_EXECUTION_YEAR` bigint unsigned,
`OID_DISTRICT_SUBDIVISION_OF_RESIDENCE` bigint unsigned, 
`OID_SCHOOL_TIME_DISTRICT_SUB_DIVISION_OF_RESIDENCE` bigint unsigned,
`OID_COUNTRY_OF_RESIDENCE` bigint unsigned,  
`OID_GRANT_OWNER_PROVIDER` bigint unsigned,
`OID_ROOT_DOMAIN_OBJECT` bigint unsigned, 
`ID_INTERNAL` int(11) NOT NULL auto_increment, 
primary key (ID_INTERNAL), 
index (OID), 
index (OID_COUNTRY_OF_RESIDENCE), 
index (OID_DISTRICT_SUBDIVISION_OF_RESIDENCE), 
index (OID_EXECUTION_YEAR), 
index (OID_GRANT_OWNER_PROVIDER), 
index (OID_STUDENT), 
index (OID_SCHOOL_TIME_DISTRICT_SUB_DIVISION_OF_RESIDENCE), 
index (OID_ROOT_DOMAIN_OBJECT)) ENGINE=InnoDB, character set latin1;
