-- sql para la administración de grupos para estadísticos y adición del campo status a la tabla subject_parent

ALTER TABLE `subject_parent` 
ADD COLUMN `status_sbpt` ENUM('ACTIVE', 'INACTIVE') NULL DEFAULT 'ACTIVE' AFTER `description`;

-- process
insert into process(serial_prc,prc_serial_prc,name_prc,link_prc,weight_prc)
values(604,600,'Grupos para Estadísticos','laravel/public/subjectParent',2.00);
-- allowed pages
insert into allowed_pages_by_process(serial_prc,url_dsc)
values
(604,'subjectparentcontroller@getindex'),
(604,'subjectparentcontroller@getshowcreatesubjectparent'),
(604,'subjectparentcontroller@postcreatesubjectparent'),
(604,'subjectparentcontroller@posteditsubjectparent'),
(604,'subjectparentcontroller@getshoweditsubjectparent');

-- sql para la administración de las materias en laravel

-- process
insert into process(serial_prc,prc_serial_prc,name_prc,link_prc,weight_prc)
values(605,49,'Administración de materias','laravel/public/catSubject',52.00);

-- allowed pages
insert into allowed_pages_by_process(serial_prc,url_dsc)
values
(605,'catsubjectcontroller@getindex'),
(605,'catsubjectcontroller@geteditsubjectparent'),
(605,'catsubjectcontroller@getloadcatsubject');







