-- Clear all sales data for testing
-- This removes all orders, tickets purchased, and chits purchased
-- Does NOT affect events, menu_items, event_tickets, profiles, or other configuration data

-- Delete in order to respect foreign key constraints

-- 1. Delete all chits (drink/food items purchased)
DELETE FROM chits;

-- 2. Delete all order tickets (tickets purchased)
DELETE FROM order_tickets;

-- 3. Delete all orders
DELETE FROM orders;

-- Verify the data is cleared
SELECT 'Orders cleared' as status, COUNT(*) as remaining FROM orders
UNION ALL
SELECT 'Order tickets cleared', COUNT(*) FROM order_tickets
UNION ALL
SELECT 'Chits cleared', COUNT(*) FROM chits;
