alter table `OCCUPATION_PERIOD` add `OID_EXAMS_PERIOD_FOR_EXAMS_FIRST_SEMESTER` bigint unsigned, add `OID_EXAMS_PERIOD_FOR_GRADE_SUBMISSION_SPECIAL_SEASON` bigint unsigned, add `OID_EXAMS_PERIOD_FOR_GRADE_SUBMISSION_SECOND_SEMESTER` bigint unsigned, add `OID_EXAMS_PERIOD_FOR_GRADE_SUBMISSIONK_FIRST_SEMESTER` bigint unsigned, add `OID_EXAMS_PERIOD_FOR_EXAMS_SECOND_SEMESTER` bigint unsigned, add `OID_EXAMS_PERIOD_FOR_EXAMS_SPECIAL_SEASON` bigint unsigned;
create table `EXAMS_PERIOD` (`OID` bigint unsigned, `OID_PERIOD_GRADE_SUBMISSION_SECOND_SEMESTER` bigint unsigned, `CREATION_ENTITY` text, `CREATION_ENTITY_DATE` text, `OID_PERIOD_EXAMS_SECOND_SEMESTER` bigint unsigned, `OID_EXECUTION_COURSE` bigint unsigned, `OID_PERIOD_EXAMS_FIRST_SEMESTER` bigint unsigned, `UPDATE_ENTITY` text, `UPDATE_ENTITY_DATE` timestamp NULL default NULL, `OID_PERIOD_EXAMS_SPECIAL_SEASON` bigint unsigned, `OID_PERIOD_GRADE_SUBMISSION_SPECIAL_SEASON` bigint unsigned, `OID_ROOT_DOMAIN_OBJECT` bigint unsigned, `OID_PERIOD_GRADE_SUBMISSION_FIRST_SEMESTER` bigint unsigned, `ID_INTERNAL` int(11) NOT NULL auto_increment, primary key (ID_INTERNAL), index (OID), index (OID_ROOT_DOMAIN_OBJECT)) type=InnoDB, character set latin1;
alter table `EXECUTION_COURSE` add `OID_EXAMS_PERIOD` bigint unsigned;
