-- ESTANDARIZACION DE NOMBRES DE TIPO DE CALCULO 

-- AÑO LECTIVO
ALTER TABLE `school_year` 
CHANGE COLUMN `use_truncate_scy` `type_calculation_scy` ENUM('TRUNCATED','ROUNDED') NOT NULL DEFAULT 'TRUNCATED' ;

-- SUBPERIOD
ALTER TABLE `subperiod` 
ADD COLUMN `type_calculation_sbp` ENUM('TRUNCATED','ROUNDED') NOT NULL DEFAULT 'TRUNCATED' AFTER `grade_input_sbp`;

-- PERIOD
ALTER TABLE `period` 
ADD COLUMN `type_calculation_prd` ENUM('TRUNCATED','ROUNDED') NOT NULL DEFAULT 'TRUNCATED' AFTER `max_grade_date_prd`;