ALTER TABLE `recap_payment_detail` ADD COLUMN `edited_rpd` ENUM('YES', 'NO') NULL AFTER `number_ticket_rpd`, ADD COLUMN `serial_usr_edit_rpd` INT NULL AFTER `edited_rpd`, ADD COLUMN `date_edit_rpd` DATETIME NULL AFTER `serial_usr_edit_rpd`, ADD INDEX `rpd_usr_edit_idx` (`serial_usr_edit_rpd` ASC); ALTER TABLE `recap_payment_detail` ADD CONSTRAINT `rpd_usr_edit` FOREIGN KEY (`serial_usr_edit_rpd`) REFERENCES `user` (`serial_usr`) ON DELETE NO ACTION ON UPDATE NO ACTION;