--Envio de alertas
--school setup
ALTER TABLE school_setup ADD COLUMN send_low_grades_alert_sst ENUM('YES','NO') NOT NULL DEFAULT 'NO' AFTER use_subperiods_adjustments_sst,
ADD COLUMN send_attendance_alert_sst ENUM('YES','NO') NOT NULL DEFAULT 'NO' AFTER send_low_grades_alert_sst,
ADD COLUMN low_grade_alert_reciever_sst SET('PARENTS','COURSE_DIRECTOR','SECTION_DIRECTORS') DEFAULT NULL AFTER send_attendance_alert_sst,
ADD COLUMN attendance_alert_reciever_day_sst SET('PARENTS','COURSE_DIRECTOR','SECTION_DIRECTORS') DEFAULT NULL AFTER low_grade_alert_reciever_sst,
ADD COLUMN attendance_alert_reciever_class_sst SET('PARENTS','COURSE_DIRECTOR','SECTION_DIRECTORS') DEFAULT NULL AFTER attendance_alert_reciever_day_sst;



--section_by_year
ALTER TABLE section_by_year ADD COLUMN serial_emp int(11) AFTER serial_set, ADD constraint fk_section_director FOREIGN KEY(serial_emp) REFERENCES employee(serial_emp) ;