alter table `CANDIDATE_REGISTRATION_EMAIL_TEMPLATES` drop EMAIL_BODY_TUITION_PAYED, drop EMAIL_SUBJECT_TUITION_PAYED;
alter table `CANDIDACY_SCHOOL_EMAIL_TEMPLATES` add `EMAIL_BODY_TUITION_PAYED` text, add `EMAIL_SUBJECT_TUITION_PAYED` text;
