ALTER TABLE `student` 
ADD COLUMN `id_altiora_std` VARCHAR(200) NULL AFTER `serial_nnt2`;

ALTER TABLE `student` 
ADD COLUMN `id_shipping_address_std` VARCHAR(200) NULL AFTER `id_altiora_std`;

ALTER TABLE `total_invoice` 
ADD COLUMN `id_altiora_invoice_ttl` VARCHAR(200) NULL AFTER `result_safi`,
ADD COLUMN `number_ttl` VARCHAR(45) NULL AFTER `id_altiora_invoice_ttl`,
ADD COLUMN `invoice_procces_ttl` ENUM('INVOICE', 'POSTING') NULL AFTER `number_ttl`;


ALTER TABLE `total_invoice` 
ADD COLUMN `date_invoice_altiora_ttl` DATETIME NULL AFTER `invoice_procces_ttl`,
ADD COLUMN `date_posting_altiora_ttl` DATETIME NULL AFTER `date_invoice_altiora_ttl`;


ALTER TABLE `payment_detail_total_invoice` 
ADD COLUMN `id_register_altiora_pdt` VARCHAR(200) NULL AFTER `serial_pdt_dets`,
ADD COLUMN `date_register_altiora_pdt` DATETIME NULL AFTER `id_register_altiora_pdt`,
ADD COLUMN `status_register_pdt` ENUM('REGISTER', 'POSTING') NULL AFTER `date_register_altiora_pdt`;

ALTER TABLE `payment_detail_total_invoice` 
ADD COLUMN `date_posting_altiora_pdt` DATETIME NULL AFTER `date_register_altiora_pdt`;

ALTER TABLE `student` 
ADD COLUMN `id_emai_altiora_std` VARCHAR(200) NULL AFTER `id_shipping_address_std`;


ALTER TABLE `payment_detail_total_invoice` 
ADD COLUMN `entry_number_pdt` INT NULL AFTER `id_register_altiora_pdt`;

ALTER TABLE `payment_detail_total_invoice` 
CHANGE COLUMN `status_register_pdt` `status_register_pdt` ENUM('REGISTER', 'POSTING', 'APLICATION') CHARACTER SET 'latin1' NULL DEFAULT NULL ;

INSERT INTO `process` (`serial_prc`, `prc_serial_prc`, `name_prc`, `link_prc`, `weight_prc`, `status_prc`) VALUES ('872', '156', 'Facturación F', 'laravel/public/invoicealtiora', '1', 'LOCKABLE');


insert into allowed_pages_by_process values(872,'invoicealtioracontroller@getindex');
insert into allowed_pages_by_process values(872,'invoicealtioracontroller@postdates');
insert into allowed_pages_by_process values(872,'invoicealtioracontroller@getstudents');
insert into allowed_pages_by_process values(872,'invoicealtioracontroller@postinvoice');
insert into allowed_pages_by_process values(872,'invoicealtioracontroller@postreport');
insert into allowed_pages_by_process values(872,'inscriptionreportcontroller@postinvoicedata');
insert into allowed_pages_by_process values(872,'inscriptionreportcontroller@postsaveinvoicedata');

insert into allowed_pages_by_process values(754,'reportpaymentscontroller@postStudents');

insert into allowed_pages_by_process values(867,'inscriptionreportcontroller@postinvoicedata');
insert into allowed_pages_by_process values(867,'inscriptionreportcontroller@postsaveinvoicedata');