53 lines
1.4 KiB
SQL
53 lines
1.4 KiB
SQL
-- 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;
|