You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
73 lines
2.0 KiB
MySQL
73 lines
2.0 KiB
MySQL
3 weeks ago
|
|
||
|
|
|
||
|
|
# 删除所有的历史数据：
|
||
|
|
TRUNCATE TABLE act_hi_actinst;
|
||
|
|
TRUNCATE TABLE act_hi_attachment;
|
||
|
|
TRUNCATE TABLE act_hi_comment;
|
||
|
|
TRUNCATE TABLE act_hi_detail;
|
||
|
|
TRUNCATE TABLE act_hi_entitylink;TRUNCATE TABLE act_hi_identitylink;
|
||
|
|
TRUNCATE TABLE act_hi_procinst;
|
||
|
|
TRUNCATE TABLE act_hi_taskinst;
|
||
|
|
TRUNCATE TABLE act_hi_tsk_log;
|
||
|
|
TRUNCATE TABLE act_hi_varinst;
|
||
|
|
|
||
|
|
TRUNCATE TABLE po_details;
|
||
|
|
TRUNCATE TABLE po_inquiry;
|
||
|
|
TRUNCATE TABLE po_message;
|
||
|
|
TRUNCATE TABLE po_purchase;
|
||
|
|
TRUNCATE TABLE po_purchase_approve;
|
||
|
|
TRUNCATE TABLE po_purchase_approve_line;
|
||
|
|
TRUNCATE TABLE po_purchase_line;
|
||
|
|
TRUNCATE TABLE po_purchase_record;
|
||
|
|
TRUNCATE TABLE po_quotation;
|
||
|
|
TRUNCATE TABLE po_sm_print;
|
||
|
|
TRUNCATE TABLE po_sm_print_line;
|
||
|
|
TRUNCATE TABLE po_vendor_score;
|
||
|
|
TRUNCATE TABLE po_vendor_score_line;
|
||
|
|
TRUNCATE TABLE po_vendor_score_template;
|
||
|
|
TRUNCATE TABLE pro_feedback;
|
||
|
|
TRUNCATE TABLE pro_feedback_new;
|
||
|
|
TRUNCATE TABLE pro_mrp;
|
||
|
|
|
||
|
|
TRUNCATE TABLE pro_task;
|
||
|
|
TRUNCATE TABLE pro_task_issue;
|
||
|
|
TRUNCATE TABLE pro_trans_consume;
|
||
|
|
TRUNCATE TABLE pro_trans_order;
|
||
|
|
TRUNCATE TABLE pro_user_workstation;
|
||
|
|
TRUNCATE TABLE pro_workorder;
|
||
|
|
TRUNCATE TABLE pro_workorder_bom;
|
||
|
|
TRUNCATE TABLE pro_workorder_detail;
|
||
|
|
TRUNCATE TABLE pro_workorder_feedback;
|
||
|
|
TRUNCATE TABLE pro_workorder_feedback_line;
|
||
|
|
TRUNCATE TABLE pro_workorder_process;
|
||
|
|
TRUNCATE TABLE pro_workorder_record;
|
||
|
|
TRUNCATE TABLE pro_workrecord;
|
||
|
|
TRUNCATE TABLE re_reverse_audit;
|
||
|
|
TRUNCATE TABLE sm_sales;
|
||
|
|
TRUNCATE TABLE sm_sales_line;
|
||
|
|
TRUNCATE TABLE sm_sales_record;
|
||
|
|
|
||
|
|
TRUNCATE TABLE wm_product_salse;
|
||
|
|
TRUNCATE TABLE wm_product_salse_line;
|
||
|
|
TRUNCATE TABLE wm_item_recpt;
|
||
|
|
TRUNCATE TABLE wm_item_recpt_line;
|
||
|
|
|
||
|
|
TRUNCATE TABLE wm_issue_header;
|
||
|
|
TRUNCATE TABLE wm_product_recpt;
|
||
|
|
TRUNCATE TABLE wm_product_recpt_line;
|
||
|
|
TRUNCATE TABLE wm_product_recpt_line_copy;
|
||
|
|
TRUNCATE TABLE wm_records;
|
||
|
|
TRUNCATE TABLE wm_stock_pandian;
|
||
|
|
TRUNCATE TABLE wm_stock_pandian_line;
|
||
|
|
TRUNCATE TABLE wm_material_stock_start_period;
|
||
|
|
TRUNCATE TABLE wm_material_stock;
|
||
|
|
|
||
|
|
|
||
|
|
TRUNCATE TABLE wm_rt_vendor;
|
||
|
|
TRUNCATE TABLE wm_rt_vendor_line;
|
||
|
|
|
||
|
|
|
||
|
|
TRUNCATE TABLE wm_rt_issue;
|
||
|
|
TRUNCATE TABLE wm_rt_issue_line;
|
||
|
|
|