查看: 3405|回复: 0

商派OMS ERP一键清理数据库数据脚本

[复制链接]
发表于 2017-9-30 14:41:40 | 显示全部楼层 |阅读模式
/*订单*/
truncate sdb_ome_orders;

/*统计*/
truncate sdb_omeanalysts_orderstime;

/*入库单*/
truncate sdb_taoguaniostockorder_iso;
truncate sdb_taoguaniostockorder_iso_items;

/*发货*/
truncate sdb_ome_delivery;
truncate sdb_ome_delivery_items;
truncate sdb_ome_delivery_items_detail;
truncate sdb_ome_delivery_order;
truncate sdb_ome_delivery_sync;
truncate sdb_wms_delivery;
truncate sdb_wms_delivery_bill;
truncate sdb_wms_delivery_items;
truncate sdb_wms_delivery_items_storage_life;

truncate sdb_ome_reship;
truncate sdb_ome_reship_items;
truncate sdb_ome_return_product;
truncate sdb_ome_return_product_items;
truncate sdb_ome_return_product_tmall;
truncate sdb_ome_return_process_items;
truncate sdb_logisticsaccounts_estimate;

/*财务*/
truncate sdb_ome_refund_apply;
truncate sdb_ome_refund_apply_tmall;
truncate sdb_ome_refunds;
truncate sdb_purchase_purchase_refunds;
truncate sdb_purchase_credit_sheet;

truncate sdb_ome_payments;
truncate sdb_purchase_purchase_payments;

truncate sdb_sales_aftersale_items;
truncate sdb_sales_aftersale;

truncate sdb_ome_sales;
truncate sdb_ome_sales_items;

/*日志*/
truncate sdb_wms_delivery_log;
truncate sdb_ome_api_log;
truncate sdb_ome_batch_log;
truncate sdb_ome_gift_logs;
truncate sdb_ome_operation_log;
truncate sdb_omeanalysts_logistics_analysts;
truncate sdb_pam_log;
truncate sdb_wms_delivery_log;
truncate sdb_eccommon_analysis_logs;
truncate sdb_omeanalysts_branch_product_stock_detail;
truncate sdb_omeanalysts_ome_salestatistics;
truncate sdb_omeanalysts_sale_products;
truncate sdb_omeanalysts_relate;
truncate sdb_ome_payments;
truncate sdb_purchase_purchase_payments;
使用 高级模式(可批量传图、插入视频等)
您需要登录后才可以回帖 登录 | 立即注册

扫描二维码联系我们

快速回复 返回列表