ALTER TABLE `tm1852020`.`group_payment_button` 
ADD COLUMN `type_gpb` ENUM('currentDefered', 'current', 'register') NULL DEFAULT 'currentDefered' AFTER `serial_pbn`;

CREATE TABLE `tm1852020`.`payment_method_wizard` (
  `serial_pmw` INT NOT NULL AUTO_INCREMENT,
  `name_pmw` VARCHAR(300) NULL,
  `alias_pmw` ENUM('currentDefered' ,'current', 'others') NULL,
  `status_pmw` ENUM('ACTIVE', 'INACTIVE') NULL,
  PRIMARY KEY (`serial_pmw`));

ALTER TABLE `tm1852020`.`group_payment_button` 
ADD COLUMN `serial_pmw` INT NULL AFTER `serial_pbn`,
ADD INDEX `fk_gpb_pmw_idx` (`serial_pmw` ASC);
ALTER TABLE `tm1852020`.`group_payment_button` 
ADD CONSTRAINT `fk_gpb_pmw`
  FOREIGN KEY (`serial_pmw`)
  REFERENCES `tm1852020`.`payment_method_wizard` (`serial_pmw`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION;


INSERT INTO `tm1852020`.`payment_method_wizard` (`serial_pmw`, `name_pmw`, `alias_pmw`, `status_pmw`) VALUES ('1', ' Pago en línea todo el año 10 meses sinintereses. ', 'currentDefered', 'ACTIVE');
INSERT INTO `tm1852020`.`payment_method_wizard` (`serial_pmw`, `name_pmw`, `alias_pmw`, `status_pmw`) VALUES ('2', 'Pago en línea carta de pago 1 de 10', 'current', 'ACTIVE');
INSERT INTO `tm1852020`.`payment_method_wizard` (`serial_pmw`, `name_pmw`, `alias_pmw`, `status_pmw`) VALUES ('3', ' Contado (efectivo, cheque o tarjeta corriente) \"Por favor imprima el detalle\" ', 'cash', 'ACTIVE');
