alter table `CANDIDACY` add `OID_CANDIDACY_PAYMENT_DETAILS` bigint unsigned, add `PAYMENT_TYPE` text;
alter table `PAYMENT_CODE` add `OID_CANDIDACY_PAYMENT_DETAIL` bigint unsigned;
create table `CANDIDACY_PAYMENT_DETAILS` (`OID` bigint unsigned, `OID_PAYMENT_CODE` bigint unsigned, `OID_SECOND_CYCLE_CANDIDACY` bigint unsigned, `CREATION_ENTITY` text, `CREATION_ENTITY_DATE` text, `AMOUNT` text, `OJB_CONCRETE_CLASS` varchar(255) NOT NULL DEFAULT '', `UPDATE_ENTITY` text, `WHEN_REGISTERED` timestamp NULL default NULL, `UPDATE_ENTITY_DATE` timestamp NULL default NULL, `PAYED` tinyint(1), `OID_ROOT_DOMAIN_OBJECT` 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;



-- Inserted at 2011-02-25T08:22:14.299Z

alter table `CANDIDACY_PERIOD` add `OID_CANDIDACY_COST_DETAIL` bigint unsigned, add index (OID_CANDIDACY_COST_DETAIL);
create table `CANDIDACY_COST_DETAIL` (`UPDATE_ENTITY` text, `OID` bigint unsigned, `UPDATE_ENTITY_DATE` timestamp NULL default NULL, `COST` text, `CREATION_ENTITY_DATE` text, `CREATION_ENTITY` text, `OID_ROOT_DOMAIN_OBJECT` bigint unsigned, `PAYPAL_CODE` text, `ID_INTERNAL` int(11) NOT NULL auto_increment, primary key (ID_INTERNAL), index (OID), index (OID_ROOT_DOMAIN_OBJECT)) type=InnoDB, character set latin1;
