ALTER TABLE CANDIDACY ADD COLUMN LANDLORD_CONTACT varchar(255);
ALTER TABLE CANDIDACY ADD COLUMN ACADEMIC_COORDINATOR_EMAIL varchar(255);
ALTER TABLE CANDIDACY ADD COLUMN ACADEMIC_COORDINATOR_NAME varchar(255);
ALTER TABLE CANDIDACY ADD COLUMN SCHOLARSHIP tinyint(1);
ALTER TABLE CANDIDACY ADD COLUMN YEAR_OF_STUDY int(2);
ALTER TABLE CANDIDACY ADD COLUMN ORIGIN_DEGREE_CYCLE varchar(50);
ALTER TABLE CANDIDACY ADD COLUMN NUMBER_OF_YEARS_IN_HIGHER_EDUCATION int(2);
ALTER TABLE CANDIDACY ADD COLUMN PROLONGATION tinyint(1);
ALTER TABLE CANDIDACY ADD COLUMN DURATION varchar(50);
ALTER TABLE CANDIDACY ADD COLUMN ORIGIN_DEGREE_NAME varchar(255);
