ALTER TABLE `mydb`.`account` 
ADD COLUMN `bank_code` VARCHAR(45) NULL DEFAULT '' AFTER `bank_id`;

-- 페이윈 은행코드 추가
UPDATE `mydb`.`account` SET `bank_code` = '071' WHERE (`idx` = '1');
UPDATE `mydb`.`account` SET `bank_code` = '081' WHERE (`idx` = '2');
UPDATE `mydb`.`account` SET `bank_code` = '045' WHERE (`idx` = '3');
UPDATE `mydb`.`account` SET `bank_code` = '088' WHERE (`idx` = '4');
UPDATE `mydb`.`account` SET `bank_code` = '002' WHERE (`idx` = '5');
UPDATE `mydb`.`account` SET `bank_code` = '089' WHERE (`idx` = '6');
UPDATE `mydb`.`account` SET `bank_code` = '090' WHERE (`idx` = '7');
UPDATE `mydb`.`account` SET `bank_code` = '003' WHERE (`idx` = '8');
UPDATE `mydb`.`account` SET `bank_code` = '004' WHERE (`idx` = '9');
UPDATE `mydb`.`account` SET `bank_code` = '007' WHERE (`idx` = '10');
UPDATE `mydb`.`account` SET `bank_code` = '011' WHERE (`idx` = '11');
UPDATE `mydb`.`account` SET `bank_code` = '020' WHERE (`idx` = '12');
UPDATE `mydb`.`account` SET `bank_code` = '023' WHERE (`idx` = '13');
UPDATE `mydb`.`account` SET `bank_code` = '027' WHERE (`idx` = '14');
UPDATE `mydb`.`account` SET `bank_code` = '031' WHERE (`idx` = '15');
UPDATE `mydb`.`account` SET `bank_code` = '032' WHERE (`idx` = '16');
UPDATE `mydb`.`account` SET `bank_code` = '034' WHERE (`idx` = '17');
UPDATE `mydb`.`account` SET `bank_code` = '035' WHERE (`idx` = '18');
UPDATE `mydb`.`account` SET `bank_code` = '037' WHERE (`idx` = '19');
UPDATE `mydb`.`account` SET `bank_code` = '039' WHERE (`idx` = '20');
UPDATE `mydb`.`account` SET `bank_code` = '209' WHERE (`idx` = '21');
UPDATE `mydb`.`account` SET `bank_code` = '050' WHERE (`idx` = '22');
UPDATE `mydb`.`account` SET `bank_code` = '048' WHERE (`idx` = '24');
UPDATE `mydb`.`account` SET `bank_code` = '230' WHERE (`idx` = '25');
UPDATE `mydb`.`account` SET `bank_code` = '0' WHERE (`idx` = '26');
UPDATE `mydb`.`account` SET `bank_code` = '0' WHERE (`idx` = '27');
UPDATE `mydb`.`account` SET `bank_code` = '0' WHERE (`idx` = '28');
UPDATE `mydb`.`account` SET `bank_code` = '267' WHERE (`idx` = '29');
UPDATE `mydb`.`account` SET `bank_code` = '0' WHERE (`idx` = '30');
UPDATE `mydb`.`account` SET `bank_code` = '0' WHERE (`idx` = '31');
UPDATE `mydb`.`account` SET `bank_code` = '007' WHERE (`idx` = '32');
UPDATE `mydb`.`account` SET `bank_code` = '092' WHERE (`idx` = '33');
