alter table master_app_production.customers add charge_show_warehouse_total_flag_code smallint(6) after charge_sheet_type_code;
alter table master_app_production.customers add charge_show_daily_total_flag_code smallint(6) after charge_sheet_type_code;
alter table master_app_production.customers add charge_show_payment_flag_code smallint(6) after charge_sheet_type_code;

#ここは会社ごとに設定を換える
update master_app_production.customers set charge_show_warehouse_total_flag_code=0;
update master_app_production.customers set charge_show_daily_total_flag_code=0;
update master_app_production.customers set charge_show_payment_flag_code=0;


