use hi_inventory_config;
UPDATE storage_bin set occupancy_state = '0';
UPDATE container_management set current_position_id = NULL, 
current_position = NULL, kuwei_id = NULL, `status` = '0', resting_state = '0', 
current_link = NULL;
TRUNCATE table material_container;
use hi_move_task;
DELETE FROM task_info;
DELETE FROM agv_task_queue;
DELETE FROM blanking_record;
-- storage-in
use hi_storage_in;
TRUNCATE enter_stock_order;
TRUNCATE enter_stock_row;


-- storage-out
use hi_storage_out
TRUNCATE leave_stock_order;
TRUNCATE leave_stock_row;


-- inventory-statistic
use hi_inventory_statistic
TRUNCATE abnormal_material_register;


-- inventory-job-mgmt
use hi_inventory_job_mgmt
TRUNCATE material_stock;
TRUNCATE transfer_order;
TRUNCATE transfer_order_row;
TRUNCATE transfer_container_info;
TRUNCATE transfer_material_info;
TRUNCATE warehouse_transfer_order;
TRUNCATE inventory_change_log;