-- 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`;

-- Bug 65076 (rio) - set the deleted of the required fields to 0 [not deleted]
UPDATE config_export_fields
SET deleted = 0
WHERE module='Fee' AND suffix='LWRyoshushoHakko_AN'
AND field IN (
	'nyushitsu',    
	'gessha',   
	'kyozai',        
	'test',    
	'koushuukai',    
	'tokubetsu',
	'shidoukanren',    
	'msp');

-- albert (63940) remove saikenka_flg and saikenka_date 
ALTER TABLE sms_fee DROP COLUMN `saikenka_flg`;
ALTER TABLE sms_fee DROP COLUMN `saikenka_date`;