ALTER TABLE PROFESSORSHIP DROP KEY_BASE_TEACHER;
ALTER TABLE PROFESSORSHIP ADD KEY_FUTURE_TEACHER int(11);
ALTER TABLE PROFESSORSHIP ADD KEY `KEY_FUTURE_TEACHER` (`KEY_FUTURE_TEACHER`);