Domovská stránka Prehľadávať Pomoc
Registrovať Prihlásiť sa
renceng
/
EIS
1
0
Fork 0
Súbory Issues 0 Pull requesty 0 Wiki
Strom: 329e57b3b5
Branche Tagy
EIS
/
data
/
青牛EIS清库脚本.sql

青牛EIS清库脚本.sql 2.0 KB
História Raw

12345678910111213141516171819202122232425262728293031323334353637383940 
  1. delete from eis_base_route_qnym.biz_eis_route_carry_task;
    2. 

  2. delete from eis_base_route_qnym.biz_eis_route_carry_task_his;
    3. 

  3. delete from eis_base_route_qnym.biz_eis_route_carry_task_cb;
    4. 

  4. delete from eis_base_route_qnym.biz_eis_route_carry_task_cb_h;
    5. 

  5. delete from eis_base_route_qnym.biz_eis_route_ctar_loc_his;
    6. 

  6. delete from eis_base_route_qnym.biz_eis_route_ctar_loc_dt;
    7. 

  7. delete from eis_base_route_qnym.biz_eis_route_ctar_loc_dt_h;
    8. 

  8. delete from eis_base_route_qnym.biz_eis_route_ctar_loc_dt_s;
    9. 

  9. delete from eis_base_route_qnym.biz_eis_route_ctar_loc_dt_s_h;
    10. 

  10. delete from eis_qnym.allotment_task_record;
    11. 

  11. delete from eis_qnym.allotment_task_record_his;
    12. 

  12. delete from eis_qnym.biz_inbound_task;
    13. 

  13. delete from eis_qnym.biz_inbound_task_his;
    14. 

  14. delete from eis_qnym.biz_inbound_task_detail;
    15. 

  15. delete from eis_qnym.biz_inbound_task_detail_his;
    16. 

  16. delete from eis_qnym.biz_outbound_task;
    17. 

  17. delete from eis_qnym.biz_outbound_task_his;
    18. 

  18. delete from eis_qnym.biz_outbound_task_detail;
    19. 

  19. delete from eis_qnym.biz_outbound_task_detail_his;
    20. 

  20. delete from eis_qnym.biz_outbound_task_detail_dismantle;
    21. 

  21. delete from eis_qnym.biz_outbound_task_detail_dismantle_his;
    22. 

  22. delete from eis_qnym.biz_outbound_task_detail_item;
    23. 

  23. delete from eis_qnym.biz_outbound_task_detail_item_his;
    24. 

  24. delete from eis_qnym.container_task_dismantle;
    25. 

  25. delete from eis_qnym.container_task_dismantle_his;
    26. 

  26. delete from eis_qnym.container_info;
    27. 

  27. delete from eis_qnym.container_info_detail;
    28. 

  28. delete from eis_qnym.container_store_change;
    29. 

  29. delete from eis_qnym.container_task;
    30. 

  30. delete from eis_qnym.container_task_his;
    31. 

  31. delete from eis_qnym.dismantling_location_hit_record;
    32. 

  32. delete from eis_qnym.dismantling_location_hit_record_his;
    33. 

  33. delete from eis_qnym.plg_fx_api_log;
    34. 

  34. delete from eis_qnym.wms_carry_task;
    35. 

  35. delete from eis_qnym.wms_carry_task_his;
    36. 

  36. delete from eis_qnym.print_task;
    37. 

  37. delete from eis_qnym.order_log;
    38. 

  38. delete from eis_qnym.biz_outbound_task_detail_dismantle_grid;
    39. 

  39. delete from eis_qnym.biz_outbound_task_detail_dismantle_grid_his;
    40. 

  40. update eis_qnym.grid_info set apply_volume = 0,bill_flag = 0,last_flag = 0,supply_flag = 0,fall_grid = 0,scan_finish = 0;
    41.