ALTER TABLE `payment_method` 
ADD COLUMN `type_pym` ENUM('CARD','PAYCHECK','DEBIT') NULL AFTER `requires_credit_card_pym`;

UPDATE `payment_method` SET `type_pym`='CARD' WHERE `serial_pym`='1';
UPDATE `payment_method` SET `type_pym`='PAYCHECK' WHERE `serial_pym`='3';
UPDATE `payment_method` SET `type_pym`='CARD' WHERE `serial_pym`='4';
UPDATE `payment_method` SET `type_pym`='DEBIT' WHERE `serial_pym`='5';