create table INTERNSHIP_CANDIDACY (
  `AREA` text,
  `AREA_CODE` text,
  `BIRTHDAY` text,
  `CANDIDACY_CODE` int(11),
  `DEGREE` text,
  `DOCUMENT_ID_NUMBER` text,
  `EMAIL` text,
  `EMISSION_DATE_OF_DOCUMENT_ID` text,
  `EMISSION_DATE_OF_PASSPORT` text,
  `EMISSION_LOCATION_OF_DOCUMENT_ID` text,
  `EMISSION_LOCATION_OF_PASSPORT` text,
  `ENGLISH` text,
  `EXPIRATION_DATE_OF_DOCUMENT_ID` text,
  `EXPIRATION_DATE_OF_PASSPORT` text,
  `FRENCH` text,
  `GENDER` text,
  `GERMAN` text,
  `ID_INTERNAL` int(11) NOT NULL auto_increment,
  `KEY_COUNTRY_OF_BIRTH` int(11),
  `KEY_FIRST_DESTINATION` int(11),
  `KEY_ROOT_DOMAIN_OBJECT` int(11),
  `KEY_SECOND_DESTINATION` int(11),
  `KEY_THIRD_DESTINATION` int(11),
  `KEY_UNIVERSITY` int(11),
  `MOBILE_PHONE` text,
  `NAME` text,
  `PARISH_OF_BIRTH` text,
  `PASSPORT_ID_NUMBER` text,
  `PREVIOUS_CANDIDACY` tinyint(1),
  `SPANISH` text,
  `STREET` text,
  `STUDENT_NUMBER` text,
  `STUDENT_YEAR` int(11),
  `TELEPHONE` text,
  primary key (ID_INTERNAL),
  index (KEY_COUNTRY_OF_BIRTH),
  index (KEY_FIRST_DESTINATION),
  index (KEY_ROOT_DOMAIN_OBJECT),
  index (KEY_SECOND_DESTINATION),
  index (KEY_THIRD_DESTINATION),
  index (KEY_UNIVERSITY)
) type=InnoDB ;