ALTER TABLE `email_log` 
ADD COLUMN `debtor_cards` VARCHAR(45) NULL AFTER `text_email_ema`;


ALTER TABLE `email_log` 
CHANGE COLUMN `debtor_cards` `debtor_cards_ema` VARCHAR(45) NULL DEFAULT NULL ,
ADD COLUMN `value_debt_ema` DECIMAL(10,2) NULL AFTER `debtor_cards_ema`;

INSERT INTO `process` (`serial_prc`, `prc_serial_prc`, `name_prc`, `link_prc`, `weight_prc`, `status_prc`) VALUES ('815', '402', 'Reporte de cartas de deudores', 'laravel/public/reportdebtorcard', '1', 'LOCKABLE');
insert into allowed_pages_by_process values (815,'reportdebtorcardcontroller@getindex');
insert into allowed_pages_by_process values (815,'reportdebtorcardcontroller@postdates');
insert into allowed_pages_by_process values (815,'reportdebtorcardcontroller@poststudents');
insert into allowed_pages_by_process values (815,'reportdebtorcardcontroller@poststudentsexcel');
insert into allowed_pages_by_process values (815,'reportdebtorcardcontroller@postsaveemaillog');

ALTER TABLE `email_log` 
ADD COLUMN `note_text_ema` TEXT NULL AFTER `status_ema`,
ADD COLUMN `date_to_pay_ema` DATE NULL AFTER `note_text_ema`,
ADD COLUMN `fulfilled_ema` ENUM('YES', 'NO') NULL AFTER `date_to_pay_ema`;
