-- clear-domain-data.sql: delete every row the e2e orchestrations can duplicate. -- Runs on the LOCAL dev D1 only (wrangler d1 execute --local). Does NOT touch -- regions/bounds/creds, staff users/roles, superadmins, users, or KV/consts. -- Order = children first (the local D1 enforces foreign keys). PRAGMA foreign_keys = OFF; -- slots (vendor snippets reference slots) DELETE FROM vendor_snippets; DELETE FROM delivery_slot_info; -- coupons chain (sku refs / order refs) DELETE FROM reserved_coupons; DELETE FROM coupon_applicable_products; DELETE FROM coupon_applicable_users; DELETE FROM coupon_usage; DELETE FROM coupons; -- orders + financial chain (also referenced by complaints/incidents) DELETE FROM refunds; DELETE FROM payments; DELETE FROM order_items; DELETE FROM order_status; DELETE FROM complaints; DELETE FROM user_incidents; DELETE FROM orders; -- product leaning rows DELETE FROM special_deals; DELETE FROM product_reviews; DELETE FROM cart_items; -- groupings DELETE FROM product_group_membership; DELETE FROM product_group_info; -- tags (product_tags refs skus) DELETE FROM product_tags; DELETE FROM product_tag_info; -- skus + products DELETE FROM sku_features; DELETE FROM product_combos; DELETE FROM product_market_stats; DELETE FROM product_skus; DELETE FROM product_info; -- stores DELETE FROM store_info; -- upload lifecycle junk DELETE FROM upload_url_status; PRAGMA foreign_keys = ON;