
create table `SECOND_CYCLE_CANDIDACY_PAYMENT_CODE_POOL` (`UPDATE_ENTITY` text, `OID` bigint unsigned, `NEXT_VALUE` int(11), `UPDATE_ENTITY_DATE` timestamp NULL default NULL, `CREATION_ENTITY_DATE` text, `CREATION_ENTITY` text, `OID_ROOT_DOMAIN_OBJECT` bigint unsigned, `ID_INTERNAL` int(11) NOT NULL auto_increment, primary key (ID_INTERNAL), index (OID)) type=InnoDB, character set latin1;
alter table `ROOT_DOMAIN_OBJECT` add `OID_PAYMENT_CODE_POOL` bigint unsigned;
alter table `CANDIDACY` add `OID_PAYMENT_CODE` bigint unsigned;
alter table `PAYMENT_CODE` add `OID_PAYMENT_CODE_POOL` bigint unsigned, add `OID_CANDIDACY` bigint unsigned, add index (OID_PAYMENT_CODE_POOL);

alter table `PAYMENT_CODE` add `SIBS_TRANSACTION_ID` text, add `WHEN_REGISTERED` timestamp NULL default NULL, add `COMMENTS` text, add `AMOUNT` text;

alter table `GENERIC_FILE` add `HIGHEST_CODE` text, add `OID_PAYMENT_CODE_POOL` bigint unsigned, add `LOWEST_CODE` text, add index (OID_PAYMENT_CODE_POOL);

create table `CANDIDACY_PERIOD` (`UPDATE_ENTITY` text, `OID` bigint unsigned, `START_DATE_DATE_TIME` timestamp NULL default NULL, `END_DATE_DATE_TIME` timestamp NULL default NULL, `UPDATE_ENTITY_DATE` timestamp NULL default NULL, `COST` text, `CREATION_ENTITY_DATE` text, `CREATION_ENTITY` text, `OJB_CONCRETE_CLASS` varchar(255) NOT NULL DEFAULT '', `OID_ROOT_DOMAIN_OBJECT` bigint unsigned, `OID_EXECUTION_PERIOD` bigint unsigned, `ID_INTERNAL` int(11) NOT NULL auto_increment, primary key (ID_INTERNAL), index (OID), index (OID_ROOT_DOMAIN_OBJECT), index (OID_EXECUTION_PERIOD)) type=InnoDB, character set latin1;
create table `DEGREE_CURRICULAR_PLAN_CANDIDACY_PERIOD` (`OID_CANDIDACY_PERIOD` bigint unsigned, `OID_DEGREE_CURRICULAR_PLAN` bigint unsigned, primary key (OID_CANDIDACY_PERIOD, OID_DEGREE_CURRICULAR_PLAN), index (OID_CANDIDACY_PERIOD), index (OID_DEGREE_CURRICULAR_PLAN)) type=InnoDB, character set latin1;
