alter table `FILE` add `OID_CAREER_WORKSHOP_CONFIRMATION_EVENT` bigint unsigned;
alter table `CAREER_WORKSHOP_APPLICATION` add `OID_CAREER_WORKSHOP_CONFIRMATION` bigint unsigned;
alter table `CAREER_WORKSHOP_APPLICATION_EVENT` add `OID_CAREER_WORKSHOP_CONFIRMATION_EVENT` bigint unsigned;
create table `CAREER_WORKSHOP_CONFIRMATION_EVENT` (`LAST_UPDATE` timestamp NULL default NULL, `OID` bigint unsigned, `OID_CONFIRMATIONS` bigint unsigned, `OID_CAREER_WORKSHOP_APPLICATION_EVENT` bigint unsigned, `END_DATE` timestamp NULL default NULL, `BEGIN_DATE` timestamp NULL default NULL, `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;
create table `CAREER_WORKSHOP_CONFIRMATION` (`OID` bigint unsigned, `CONFIRMATION` tinyint(1), `OID_CAREER_WORKSHOP_CONFIRMATION_EVENT` bigint unsigned, `OID_STUDENT` bigint unsigned, `SEAL_STAMP` timestamp NULL default NULL, `OID_ROOT_DOMAIN_OBJECT` bigint unsigned, `OID_CAREER_WORKSHOP_APPLICATION` bigint unsigned, `CONFIRMATION_CODE` text, `ID_INTERNAL` int(11) NOT NULL auto_increment, primary key (ID_INTERNAL), index (OID), index (OID_CAREER_WORKSHOP_CONFIRMATION_EVENT), index (OID_STUDENT), index (OID_ROOT_DOMAIN_OBJECT)) type=InnoDB, character set latin1;
