create table `CANDIDACY_QUESTION` (`UPDATE_ENTITY` text, `OID` bigint unsigned, `OID_CANDIDACY` bigint unsigned, `UPDATE_ENTITY_DATE` timestamp NULL default NULL, `DETAILED_ANSWER` text, `CREATION_ENTITY_DATE` text, `CREATION_ENTITY` text, `OID_ROOT_DOMAIN_OBJECT` bigint unsigned, `TYPE` text, `ANSWER` tinyint(1), `ID_INTERNAL` int(11) NOT NULL auto_increment, primary key (ID_INTERNAL), index (OID), index (OID_CANDIDACY), index (OID_ROOT_DOMAIN_OBJECT)) type=InnoDB, character set latin1;
create table `LANGUAGE_SKILL` (`UPDATE_ENTITY` text, `READING_SKILL` int(11), `OID` bigint unsigned, `LANGUAGE` text, `SPEECH_SKILL` int(11), `WRITING_SKILL` int(11), `UPDATE_ENTITY_DATE` timestamp NULL default NULL, `OID_PERSON` bigint unsigned, `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_PERSON), index (OID_ROOT_DOMAIN_OBJECT)) type=InnoDB, character set latin1;
alter table `QUALIFICATION` add `DEGREE_DURATION` text, add `MONTH` text;
alter table `CAREER` add `FUNCTION_DESCRIPTION` text, add `AREA` text, add `BEGIN_MONTH` text, add `END_MONTH` text, add `OID_COUNTRY` bigint unsigned, add `OID_PERSON` bigint unsigned, add `DEPARTMENT` text, add index (OID_PERSON), add index (OID_COUNTRY);
