alter table `CANDIDACY` add `INFORMATION_SOURCE_TYPE` text, add `QUALIFICATIONS_BAG` text, add `OID_DEGREE_CURRICULAR_PLAN` bigint unsigned, add index (OID_DEGREE_CURRICULAR_PLAN);
create table `FILE_RAW_DATA` (`CONTENT_KEY` text, `OID` bigint unsigned, `OID_FILE_SUPPORT` bigint unsigned, `CONTENT` blob, `ID_INTERNAL` int(11) NOT NULL auto_increment, primary key (ID_INTERNAL), index (OID), index (OID_FILE_SUPPORT)) type=InnoDB, character set latin1;
create table `LOCAL_FILE_TO_DELETE` (`OID` bigint unsigned, `OID_FILE_SUPPORT` bigint unsigned, `FILE_PATH` text, `ID_INTERNAL` int(11) NOT NULL auto_increment, primary key (ID_INTERNAL), index (OID), index (OID_FILE_SUPPORT)) type=InnoDB, character set latin1;
create table `FILE_SUPPORT` (`OID` bigint unsigned, `ID_INTERNAL` int(11) NOT NULL auto_increment, primary key (ID_INTERNAL), index (OID)) type=InnoDB, character set latin1;
create table `CANDIDATE_REGISTRATION_EMAIL_TEMPLATES` (`UPDATE_ENTITY` text, `OID` bigint unsigned, `UPDATE_ENTITY_DATE` timestamp NULL default NULL, `EMAIL_SUBJECT_WITH_LOGIN_INFORMATION` text, `EMAIL_BODY_WITH_LOGIN_INFORMATION` text, `CREATION_ENTITY_DATE` text, `CREATION_ENTITY` text, `EMAIL_SUBJECT_WITH_LINK_FOR_REGISTRATION` text, `OID_ROOT_DOMAIN_OBJECT` bigint unsigned, `EMAIL_BODY_WITH_LINK_FOR_REGISTRATION` 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;
alter table `CANDIDACY_DOCUMENT` add `DOCUMENT_TYPE` text;
create table `GENERIC_FILE` (`DISPLAY_NAME` text, `CONTENT_KEY` text, `CONTENT_TYPE` text, `OID` bigint unsigned, `OID_CANDIDACY_DOCUMENT` bigint unsigned, `OID_FILE_SUPPORT` bigint unsigned, `FILENAME` text, `UPLOAD_TIME` timestamp NULL default NULL, `PERMITTED_GROUP` text, `OID_STORAGE` bigint unsigned, `OJB_CONCRETE_CLASS` varchar(255) NOT NULL DEFAULT '', `ID_INTERNAL` int(11) NOT NULL auto_increment, primary key (ID_INTERNAL), index (OID), index (OID_FILE_SUPPORT), index (OID_STORAGE)) type=InnoDB, character set latin1;
create table `CANDIDATE_LOGIN_REQUEST` (`UPDATE_ENTITY` text, `HASH` text, `OID` bigint unsigned, `UPDATE_ENTITY_DATE` timestamp NULL default NULL, `CANDIDATE_EMAIL` text, `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), index (OID_ROOT_DOMAIN_OBJECT)) type=InnoDB, character set latin1;
create table `FILE_STORAGE_CONFIGURATION` (`OID` bigint unsigned, `OID_FILE_SUPPORT` bigint unsigned, `FILE_TYPE` text, `OID_STORAGE` bigint unsigned, `ID_INTERNAL` int(11) NOT NULL auto_increment, primary key (ID_INTERNAL), index (OID), index (OID_FILE_SUPPORT), index (OID_STORAGE)) type=InnoDB, character set latin1;
create table `SECOND_CYCLE_CANDIDACY_REFERENCE` (`COMPANY` text, `OID` bigint unsigned, `NAME` text, `OID_SECOND_CYCLE_CANDIDACY` bigint unsigned, `CREATION_ENTITY` text, `CREATION_ENTITY_DATE` text, `REFERENCE_ORDER` int(11), `UPDATE_ENTITY` text, `UPDATE_ENTITY_DATE` timestamp NULL default NULL, `EMAIL` text, `POSITION` text, `OID_ROOT_DOMAIN_OBJECT` bigint unsigned, `ID_INTERNAL` int(11) NOT NULL auto_increment, primary key (ID_INTERNAL), index (OID), index (OID_SECOND_CYCLE_CANDIDACY), index (OID_ROOT_DOMAIN_OBJECT)) type=InnoDB, character set latin1;
create table `FILE_STORAGE` (`OID` bigint unsigned, `TABLE_NAME` text, `NAME` text, `PATH` text, `TREE_DIRECTORIES_NAME_LENGTH` int(11), `OJB_CONCRETE_CLASS` varchar(255) NOT NULL DEFAULT '', `HOST` text, `PORT` int(11), `OID_FILE_SUPPORT` bigint unsigned, `DB_NAME` text, `USERNAME` text, `PASSWORD` text, `ID_INTERNAL` int(11) NOT NULL auto_increment, primary key (ID_INTERNAL), index (OID), index (OID_FILE_SUPPORT)) type=InnoDB, character set latin1;
