-- campo para registrar si los documentos de la actividad obligatoria fueron descargados
ALTER TABLE `activity`
ADD COLUMN `download_attachment_act` ENUM('YES', 'NO') NULL AFTER `id_canvas`;

-- campo para registrar si los documentos de la actividad optativa fueron descargados
ALTER TABLE `opt_activity`
ADD COLUMN `download_attachment_opa` ENUM('YES', 'NO') NULL AFTER `id_canvas`;

-- registro de proceso, se debe asignar a docentes
insert into process(serial_prc,prc_serial_prc, name_prc, link_prc, weight_prc, status_prc, id_exclusion)
values (740,199,'Descarga portafolio','laravel/public/portfolio',406.00,'LOCKABLE', null);

-- allowed_pages_by_process
insert into allowed_pages_by_process(serial_prc, url_dsc)
values (740,'portfoliocontroller@getindex');
insert into allowed_pages_by_process(serial_prc, url_dsc)
values (740,'portfoliocontroller@getsubjects');
insert into allowed_pages_by_process(serial_prc, url_dsc)
values (740,'portfoliocontroller@getperiod');
insert into allowed_pages_by_process(serial_prc, url_dsc)
values (740,'portfoliocontroller@getsubperiod');
insert into allowed_pages_by_process(serial_prc, url_dsc)
values (740,'portfoliocontroller@postsearch');
insert into allowed_pages_by_process(serial_prc, url_dsc)
values (740,'portfoliocontroller@postdelete');
insert into allowed_pages_by_process(serial_prc, url_dsc)
values (740,'portfoliocontroller@postcheckdownloadfile');