ALTER TABLE PROFESSORSHIP ADD KEY_TEACHER INT;
UPDATE PROFESSORSHIP SET KEY_TEACHER = KEY_BASE_TEACHER;

ALTER TABLE EVENT ADD COLUMN KEY_GRATUITY_PAYMENT_PLAN INT(11) NULL;

ALTER TABLE PROJECT_SUBMISSION ADD COLUMN TEACHER_OBSERVATION LONGTEXT;