ALTER TABLE `payment_button` 
ADD COLUMN `url_return` VARCHAR(500) NULL DEFAULT NULL AFTER `xml_process`,
ADD COLUMN `login` VARCHAR(500) NULL DEFAULT NULL AFTER `url_return`,
ADD COLUMN `trankey` VARCHAR(500) NULL DEFAULT NULL AFTER `login`;

ALTER TABLE `payment_button` 
CHANGE COLUMN `type_pbn` `type_pbn` ENUM('PAYCLUB', 'ALIGNET', 'WALLET_P2P') NULL DEFAULT NULL ;

-- opciones en current referred
ALTER TABLE `current_deferred` 
ADD COLUMN `requestid` VARCHAR(45) NULL DEFAULT NULL AFTER `serial_scy`,
ADD COLUMN `expiration_date` VARCHAR(100) NULL DEFAULT NULL AFTER `requestid`;

ALTER TABLE `current_deferred` 
CHANGE COLUMN `confirm_status_cdf` `confirm_status_cdf` VARCHAR(45) NOT NULL DEFAULT 'NEW' ;

-- información del pagina web de la entidad del bo´ton de pagos
ALTER TABLE `payment_button` 
ADD COLUMN `url_web_page_bank` VARCHAR(500) NULL DEFAULT NULL AFTER `path_logo`;




ALTER TABLE `payment_button` 
CHANGE COLUMN `type_pbn` `type_pbn` ENUM('PAYCLUB', 'ALIGNET', 'WALLET_P2P') NULL DEFAULT NULL AFTER `trankey`,
CHANGE COLUMN `debts_pbn` `debts_pbn` ENUM('YES', 'NO') NULL DEFAULT NULL AFTER `type_pbn`,
CHANGE COLUMN `payphone_url_api` `payphone_url_api` VARCHAR(500) NULL DEFAULT NULL AFTER `debts_pbn`,
CHANGE COLUMN `partner_pbn` `partner_pbn` VARCHAR(200) NULL DEFAULT NULL AFTER `payphone_url_api`;

