ALTER TABLE `student_by_course` 
CHANGE COLUMN `status_stc` `status_stc` ENUM('ACTIVE','INACTIVE','RETIRED') NOT NULL DEFAULT 'ACTIVE';