alter table orders 
add column customer_name varchar(100) after location_id,
add column carrier_name varchar(50) after carrier_code,
add column ready_date datetime after status,
add column piece_count int default 0 after ready_date,
add column total_weight int default 0 after piece_count,
add column pro_number varchar(50) after total_weight;
