ALTER TABLE `process`
ADD COLUMN `app_prc` ENUM('YES', 'NO') NULL AFTER `allow_prc`;

CREATE TABLE `school_flag` (
   `serial_scf` int(11) NOT NULL AUTO_INCREMENT,
   `name_scf` varchar(100) DEFAULT NULL,
   `alias_scf` varchar(100) DEFAULT NULL,
   `type_scf` SET('SETUP','YEAR') DEFAULT NULL,
   `status_scf` enum('ACTIVE','INACTIVE') DEFAULT 'ACTIVE',
   PRIMARY KEY (`serial_scf`)
 ) ENGINE=InnoDB AUTO_INCREMENT=1;

CREATE TABLE `flag_year` (
   `serial_fly` int(11) NOT NULL AUTO_INCREMENT,
   `serial_scf` int NOT NULL,
   `serial_scy` int NOT NULL,
   `status_fly` enum('ACTIVE','INACTIVE') DEFAULT 'ACTIVE',
   PRIMARY KEY (`serial_fly`),
   FOREIGN KEY (`serial_scy`) REFERENCES school_year (serial_scy),
   FOREIGN KEY (`serial_scf`) REFERENCES school_flag (serial_scf)
 ) ENGINE=InnoDB AUTO_INCREMENT=1;

INSERT INTO `process` (`serial_prc`, `prc_serial_prc`, `name_prc`, `link_prc`, `weight_prc`, `status_prc`) VALUES ('837', '52', 'Menu App', 'laravel/public/menuApp/user-menu', '200.00', 'LOCKABLE');

insert into allowed_pages_by_process values(837,'menuappcontroller@getusermenu');
