ALTER TABLE `PROFESSORSHIP` ADD COLUMN IS_FULL_MAJOR TINYINT(1) DEFAULT 0;
ALTER TABLE `PROFESSORSHIP` ADD COLUMN PERIOD_TYPE TEXT;