-- Referencia usada para las actividades creadas para migración de notas cuando un estudiante se cambia de paralelo.

ALTER TABLE `activity` 
ADD COLUMN `act_reference` INT(11) NULL DEFAULT NULL AFTER `status_act`;

-- Referencia usada para las actividades creadas para migración de notas cuando un estudiante se cambia de materia optativa.

ALTER TABLE `opt_activity` 
ADD COLUMN `opa_reference` INT(11) NULL DEFAULT NULL AFTER `status_opa`;

-- Process y allowed pages para la migración de los estudiantes materias obligatorias y optativas
-- Fernando Salas rfsalas@rutatec.com
-- Fecha: 2017-02-02
insert into process (serial_prc,prc_serial_prc,name_prc,link_prc,weight_prc)
values(618,(select serial_prc from process as pr where pr.name_prc like '%Estudiantes%' 
and pr.link_prc='#'and pr.prc_serial_prc 
in(select serial_prc from process as p where p.name_prc like '%Configuración%' and p.prc_serial_prc is null)),
'Migración de Calificaciones','laravel/public/migrationGrades',1.00);


-- allowed pages by process
insert into allowed_pages_by_process(serial_prc,url_dsc)
values
(618,'migrationgradescontroller@postsubjectwithsameconfiguration'),
(618,'migrationgradescontroller@postmigrationoblgrades'),
(618,'migrationgradescontroller@postoptionalsubjectwithsameconfiguration'),
(618,'migrationgradescontroller@postMigrationoptgrades'),
(618,'migrationgradescontroller@getindex'),
(618,'migrationgradescontroller@postsearchstudent'),
(618,'migrationgradescontroller@poststudentdetail'),
(618,'migrationgradescontroller@postoptativemigrationgrades'),
(618,'migrationgradescontroller@postconfirmationmandatorymigration'),
(618,'migrationgradescontroller@postconfirmationoptativemigration');