sqxp/docs/sql/dev_clear_biz_orders.sql

-- 清空客户订单及关联数据（仅开发/调试使用，切勿在生产执行）
-- 执行前请自行备份。MySQL：source 本文件 或 mysql ... < dev_clear_biz_orders.sql

SET FOREIGN_KEY_CHECKS = 0;

TRUNCATE TABLE `biz_order_status_log_his`;
TRUNCATE TABLE `biz_order_status_log`;
TRUNCATE TABLE `biz_order_item`;
TRUNCATE TABLE `biz_order_his`;
TRUNCATE TABLE `biz_order_adjust_his`;
TRUNCATE TABLE `biz_order_adjust`;
TRUNCATE TABLE `biz_wechat_pay`;
TRUNCATE TABLE `biz_refund_his`;
TRUNCATE TABLE `biz_refund`;
TRUNCATE TABLE `biz_settlement_his`;
TRUNCATE TABLE `biz_settlement`;
TRUNCATE TABLE `biz_invoice`;
TRUNCATE TABLE `biz_deliverer_review_his`;
TRUNCATE TABLE `biz_deliverer_review`;
TRUNCATE TABLE `biz_delivery_warning_his`;
TRUNCATE TABLE `biz_delivery_warning`;
TRUNCATE TABLE `biz_delivery_task_item`;
TRUNCATE TABLE `biz_delivery_task_his`;
TRUNCATE TABLE `biz_delivery_task`;
TRUNCATE TABLE `biz_order`;

SET FOREIGN_KEY_CHECKS = 1;