alter table accept_orders add arrival_date DATE COMMENT "着荷日" after receiver_name;
alter table orders add arrival_date DATE COMMENT "着荷日" after receiver_name;
alter table shippings add arrival_date DATE COMMENT "着荷日" after receiver_name;

update master_app_production.warehouses_customers set request_time = "0900" where request_time like '%9時%';
update master_app_production.warehouses_customers set request_time = "0900" where request_time like '%９時%';
update master_app_production.warehouses_customers set request_time = "1000" where request_time like '%10時%';
update master_app_production.warehouses_customers set request_time = "1000" where request_time like '%１０時%';
update master_app_production.warehouses_customers set request_time = "0900" where request_time like '%AM%';

alter table master_app_production.deliveries add trucking_store_number int(11) after id;
alter table master_app_production.deliveries add trucking_id int(11) after id;

alter table master_app_production.product_categories add trucking_note_description varchar(40) after kana_name;
alter table master_app_production.truckings add note_flag_code smallint(6) after kana_name;

/*
alter table shippings add print_trucking_note_date datetime after print_sheet_date;
create table trucking_notes (
  id int(11) not null auto_increment primary key,
  target_date date,
  shipping_id int(11),
  trucking_note_number varchar(40),
  shipment_customer_id int(11),
  delivery_id int(11),
  trucking_id int(11),
  print_fax_header_date datetime,
  deleated_at datetime,
  created_at datetime,
  updated_at datetime
) type=InnoDB;
INSERT INTO menus SET id=94, menu_category_id=7, name='trucking_notes_lists', disp_name='送状一覧', disp_sort=79, created_at=NOW(), updated_at=NOW();
*/