-- sandi 62922 03.1_TechnoSMS【Willway】_BAnk Transfer Function (export)
ALTER TABLE bankexport_salesnos ADD COLUMN itakusha_cd VARCHAR(10);
ALTER TABLE bankactions_history ADD COLUMN hojin_id TINYINT(1);
ALTER TABLE bankactions_history ADD COLUMN master_bank_account_id VARCHAR(36);
ALTER TABLE bankactions_history ADD COLUMN bank_code VARCHAR(4);


-- mon (63780) manually added record on master_city table
-- please import the file under masterc_city/masterc_city_FINAL.csv once the record are not yet available on the targeted environment

-- mon (64090)
ALTER TABLE shohin DROP COLUMN apply_tajigyobu;

-- Bug 64131 (rio)  - remove tsukinaka_seikyu column
ALTER TABLE shohin_kingaku DROP COLUMN `tsukinaka_seikyu`;