-- aumento campo al análisis de rendimiento

ALTER TABLE `subject_course_range_observation` 
DROP FOREIGN KEY `fk_subject_course_range_observation_serial_sbc`;
ALTER TABLE `subject_course_range_observation` 
CHANGE COLUMN `serial_sbc` `serial_sbc` INT(11) NULL ,
ADD COLUMN `serial_lop` INT(11) NULL AFTER `serial_sbc`;
ALTER TABLE `subject_course_range_observation` 
ADD CONSTRAINT `fk_subject_course_range_observation_serial_sbc`
  FOREIGN KEY (`serial_sbc`)
  REFERENCES `subject_course` (`serial_sbc`);

ALTER TABLE `subject_course_strategy` 
DROP FOREIGN KEY `fk_subject_course_strategy_serial_sbc`;
ALTER TABLE `subject_course_strategy` 
CHANGE COLUMN `serial_sbc` `serial_sbc` INT(11) NULL ,
ADD COLUMN `serial_lop` INT(11) NULL AFTER `serial_sbc`;
ALTER TABLE `subject_course_strategy` 
ADD CONSTRAINT `fk_subject_course_strategy_serial_sbc`
  FOREIGN KEY (`serial_sbc`)
  REFERENCES `subject_course` (`serial_sbc`);