imcs_yj_be/doc/22清除数据脚本-20220104.sql

USE zuihou_defaults_yj;
-- 清空相关示范线相关表数据
TRUNCATE TABLE c_common_login_log;
TRUNCATE TABLE c_common_opt_log;

USE zuihou_base_yj_0000;
TRUNCATE TABLE c_common_login_log;
TRUNCATE TABLE c_common_opt_log;
TRUNCATE TABLE imcs_a_auto_node;
TRUNCATE TABLE imcs_a_auto_node_log;
TRUNCATE TABLE imcs_external_wms_info;
TRUNCATE TABLE imcs_external_wms_detail_info;
TRUNCATE TABLE imcs_external_agv_info;
TRUNCATE TABLE imcs_external_agv_detail_info;
TRUNCATE TABLE imcs_o_order;
TRUNCATE TABLE imcs_o_order_product;
TRUNCATE TABLE imcs_p_plan;
TRUNCATE TABLE imcs_p_plan_product;
TRUNCATE TABLE imcs_t_task;
TRUNCATE TABLE imcs_t_task_node;
TRUNCATE TABLE imcs_t_workpiece;
TRUNCATE TABLE imcs_tenant_repair;
TRUNCATE TABLE imcs_tenant_maintenance_log;
TRUNCATE TABLE imcs_wms_product;
TRUNCATE TABLE imcs_wms_product_detail;
TRUNCATE TABLE imcs_wms_shelves;
TRUNCATE TABLE imcs_wms_stock_info;
TRUNCATE TABLE imcs_wms_warehouse;
TRUNCATE TABLE imcs_wms_warehouse_log;
TRUNCATE TABLE imcs_wms_warehouse_type;
TRUNCATE TABLE imcs_s_schedule_frequency;
TRUNCATE TABLE imcs_s_schedule_month;
TRUNCATE TABLE imcs_s_schedule_user;
TRUNCATE TABLE imcs_s_schedule_user_change;
TRUNCATE TABLE imcs_s_schedule_user_change_date;
TRUNCATE TABLE imcs_s_schedule_user_date;
TRUNCATE TABLE imcs_s_shelves;
TRUNCATE TABLE imcs_s_stock_info;
TRUNCATE TABLE imcs_s_stock_log;
TRUNCATE TABLE imcs_s_storge;
TRUNCATE TABLE imcs_s_storge_tray_conf;
TRUNCATE TABLE imcs_s_storge_type;