insert into master_app_production.code_types set id=74, disp_name="口座タイプ", j_name="口座タイプ", e_name="Account Type";
insert into master_app_production.code_masters set code_type_id=74, code_number=1, disp_sort=1, disp_name="口座1", j_name="口座1", invalid_flag_code=0, created_at=NOW(), updated_at=NOW();
insert into master_app_production.code_masters set code_type_id=74, code_number=2, disp_sort=2, disp_name="口座2", j_name="口座2", invalid_flag_code=0, created_at=NOW(), updated_at=NOW();
insert into master_app_production.code_masters set code_type_id=74, code_number=3, disp_sort=3, disp_name="口座3", j_name="口座3", invalid_flag_code=0, created_at=NOW(), updated_at=NOW();
insert into master_app_production.code_masters set code_type_id=74, code_number=4, disp_sort=4, disp_name="口座4", j_name="口座4", invalid_flag_code=0, created_at=NOW(), updated_at=NOW();
insert into master_app_production.code_masters set code_type_id=74, code_number=5, disp_sort=5, disp_name="口座5", j_name="口座5", invalid_flag_code=0, created_at=NOW(), updated_at=NOW();

alter table master_app_production.suppliers change account_number account_number_1 varchar(200) ;
alter table master_app_production.suppliers add account_number_2 varchar(200) after account_number_1;
alter table master_app_production.suppliers add account_number_3 varchar(200) after account_number_2;
alter table master_app_production.suppliers add account_number_4 varchar(200) after account_number_3;
alter table master_app_production.suppliers add account_number_5 varchar(200) after account_number_4;

alter table master_app_production.customers add account_type_code smallint(6) after print_stock_date;
update master_app_production.customers set account_type_code=1;

INSERT into master_app_production.master_helps set table_name='customers', col_name = 'account_type_code', title = '口座区分', help='請求書に表示するお振込先を得意先ごとに設定したい場合、口座の種類を設定します。', created_at=NOW(), updated_at=NOW();


