alter table `CANDIDACY_SCHOOL_EMAIL_TEMPLATES` add `EMAIL_BODY_CANDIDACY_STATE_HAS_CHANGE_TO_NOT_ADMITTED` text, add `EMAIL_BODY_CANDIDACY_STATE_HAS_CHANGE_TO_ADMITTED` text, add `EMAIL_SUBJECT_CANDIDACY_STATE_HAS_CHANGE_TO_EXCLUDED` text, add `EMAIL_BODY_CANDIDACY_STATE_HAS_CHANGE_TO_EXCLUDED` text, add `EMAIL_SUBJECT_CANDIDACY_STATE_HAS_CHANGE_TO_NOT_ADMITTED` text, add `EMAIL_BODY_CANDIDACY_STATE_HAS_CHANGE_TO_SUBSTITUTE` text, add `EMAIL_SUBJECT_CANDIDACY_STATE_HAS_CHANGE_TO_SUBSTITUTE` text, add `EMAIL_SUBJECT_CANDIDACY_STATE_HAS_CHANGE_TO_ADMITTED` text;
 