alter table `QUALIFICATION` add `FREE_QUALIFICATION_TYPE` text;



-- Inserted at 2011-01-18T12:55:34.986Z

create table `CANDIDACY_PROPERTIES` (`UPDATE_ENTITY` text, `OID` bigint unsigned, `OID_DEGREE_CURRICULAR_PLAN` bigint unsigned, `UPDATE_ENTITY_DATE` timestamp NULL default NULL, `NOT_AVAILABLE` tinyint(1), `OID_EXECUTION_YEAR` bigint unsigned, `CREATION_ENTITY_DATE` text, `CREATION_ENTITY` text, `HIDDEN` tinyint(1), `OID_ROOT_DOMAIN_OBJECT` bigint unsigned, `ID_INTERNAL` int(11) NOT NULL auto_increment, primary key (ID_INTERNAL), index (OID), index (OID_DEGREE_CURRICULAR_PLAN), index (OID_EXECUTION_YEAR), index (OID_ROOT_DOMAIN_OBJECT)) type=InnoDB, character set latin1;



-- Inserted at 2011-01-19T10:05:58.710Z

create table `SIBS_IMPORT_REPORT` (`UPDATE_ENTITY` text, `OID` bigint unsigned, `OID_SIBS_IMPORTED_FILE` bigint unsigned, `UPDATE_ENTITY_DATE` timestamp NULL default NULL, `OID_POOL` bigint unsigned, `CREATION_ENTITY_DATE` text, `CREATION_ENTITY` text, `OID_ROOT_DOMAIN_OBJECT` bigint unsigned, `OID_IMPORT_RESULT` bigint unsigned, `ID_INTERNAL` int(11) NOT NULL auto_increment, primary key (ID_INTERNAL), index (OID), index (OID_POOL), index (OID_ROOT_DOMAIN_OBJECT)) type=InnoDB, character set latin1;
