ALTER TABLE `level_section_year` ADD `course_director_grade_weight_lsy` DECIMAL( 5, 2 ) NULL DEFAULT NULL AFTER `teacher_grade_weight_lsy` ; ALTER TABLE `level_section_year` CHANGE `discipline_lsy` `discipline_lsy` ENUM( 'SUPERVISOR', 'TEACHERS', 'BOTH', 'COURSE_DIRECTOR', 'BOTH_1', 'BOTH_2', 'ALL' ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL;