-- 2. em_order_legacy_upgrade（无 order_id，但有 create_time 时间戳）
DELETE FROM em_order_legacy_upgrade WHERE create_time < UNIX_TIMESTAMP('2026-06-15 00:00:00');

-- 3. em_order_payment（有 order_id 和 created_at）
DELETE FROM em_order_payment WHERE created_at < '2026-06-15 00:00:00';

-- 4. em_order_required（只有 order_id，无时间字段，需关联主表删除孤儿数据）
DELETE FROM em_order_required WHERE order_id NOT IN (SELECT id FROM em_order);

START TRANSACTION;

DELETE FROM em_order_list WHERE order_id IN (SELECT id FROM em_order WHERE create_time < UNIX_TIMESTAMP('2026-06-15 00:00:00'));
DELETE FROM em_stock_usage WHERE order_id IN (SELECT id FROM em_order WHERE create_time < UNIX_TIMESTAMP('2026-06-15 00:00:00'));
DELETE FROM em_coupon_usage WHERE order_id IN (SELECT id FROM em_order WHERE create_time < UNIX_TIMESTAMP('2026-06-15 00:00:00'));
DELETE FROM em_order WHERE create_time < UNIX_TIMESTAMP('2026-06-15 00:00:00');

COMMIT;