ALTER TABLE CANDIDACY ADD COLUMN PARTIAL_TIME TINYINT(1) DEFAULT 0;
ALTER TABLE CANDIDACY ADD COLUMN FREQUENT_OTHER_DEGREES TINYINT(1) DEFAULT 0;
ALTER TABLE CANDIDACY ADD COLUMN NUMBER_OF_PREVIOUS_CANDIDACIES INT(11);
ALTER TABLE CANDIDACY ADD COLUMN NUMBER_OF_PREVIOUS_ENROLMENTS INT(11);
ALTER TABLE CANDIDACY ADD COLUMN PAYMENT_MODE TEXT DEFAULT NULL;

ALTER TABLE PARTY ADD COLUMN PROFESSION_SECTOR_TYPE TEXT DEFAULT NULL;
ALTER TABLE PARTY ADD COLUMN PROFESSION_CONDITION_TYPE TEXT DEFAULT NULL;
ALTER TABLE PARTY ADD COLUMN MOTHER_LITERARY_HABILITATION_TYPE TEXT DEFAULT NULL;
ALTER TABLE PARTY ADD COLUMN MOTHER_PROFESSION_SECTOR_TYPE TEXT DEFAULT NULL;
ALTER TABLE PARTY ADD COLUMN FATHER_LITERARY_HABILITATION_TYPE TEXT DEFAULT NULL;
ALTER TABLE PARTY ADD COLUMN FATHER_PROFESSION_SECTOR_TYPE TEXT DEFAULT NULL;

ALTER TABLE PRECEDENT_DEGREE_INFORMATION ADD COLUMN FORMER_LITERARY_HABILITATIONS TEXT DEFAULT NULL;
ALTER TABLE PRECEDENT_DEGREE_INFORMATION ADD COLUMN NUMBER_OF_FAILS INT(11);
ALTER TABLE PRECEDENT_DEGREE_INFORMATION ADD COLUMN SECONDARY_SCHOOL_TYPE TEXT DEFAULT NULL;

ALTER TABLE PARTY ADD COLUMN KEY_SECOND_NATIONALITY INT(11);