
alter table INDIVIDUAL_CANDIDACY add column KEY_PRECEDENT_DEGREE_INFORMATION int(11), add index (KEY_PRECEDENT_DEGREE_INFORMATION);
alter table INDIVIDUAL_CANDIDACY add column KEY_SELECTED_DEGREE int(11), add index (KEY_SELECTED_DEGREE);
alter table INDIVIDUAL_CANDIDACY add column OTHER_EDUCATION text;
alter table INDIVIDUAL_CANDIDACY add column PROFESSIONAL_STATUS text;

-- drop table if exists CANDIDACY_PRECEDENT_DEGREE_INFORMATION;
create table CANDIDACY_PRECEDENT_DEGREE_INFORMATION (
  `ID_INTERNAL` int(11) NOT NULL auto_increment,
  `OJB_CONCRETE_CLASS` text,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) NOT NULL,
  `CONCLUSION_DATE` text,
  `CONCLUSION_GRADE` text,
  `DEGREE_DESIGNATION` text,
  `CYCLE_TYPE` varchar(250) DEFAULT NULL,
  `KEY_CANDIDACY` int(11) NOT NULL,
  `KEY_INSTITUTION` int(11),
  `KEY_STUDENT_CURRICULAR_PLAN` int(11),
  primary key (ID_INTERNAL),
  index (KEY_CANDIDACY),
  index (KEY_INSTITUTION),
  index (KEY_ROOT_DOMAIN_OBJECT),
  index (KEY_STUDENT_CURRICULAR_PLAN)
) type=InnoDB ;
