ALTER TABLE `payment_method` CHANGE COLUMN `type_pym` `type_pym` ENUM('CARD','PAYCHECK','DEBIT','TRANSFER','PAYROLL') NULL ; UPDATE `payment_method` SET `type_pym`='TRANSFER' WHERE `serial_pym`='4'; UPDATE `payment_method` SET `type_pym`='PAYROLL' WHERE `serial_pym`='5'; UPDATE `payment_method` SET `requires_owner_info_pym`='YES' WHERE `serial_pym`='4'; UPDATE `payment_method` SET `requires_owner_info_pym`='YES' WHERE `serial_pym`='5';