-- Drop all existing tables to start fresh
DROP TABLE IF EXISTS "auth_users" CASCADE;
DROP TABLE IF EXISTS "inventory_items" CASCADE;
DROP TABLE IF EXISTS "memberships" CASCADE;
DROP TABLE IF EXISTS "activity_log" CASCADE;
DROP TABLE IF EXISTS "alerts" CASCADE;
DROP TABLE IF EXISTS "ai_analyses" CASCADE;
DROP TABLE IF EXISTS "organizations" CASCADE;
DROP TABLE IF EXISTS "pickup_slots" CASCADE;
DROP TABLE IF EXISTS "order_items" CASCADE;
DROP TABLE IF EXISTS "orders" CASCADE;
DROP TABLE IF EXISTS "stock_analysis" CASCADE;
DROP TABLE IF EXISTS "pantry_items" CASCADE;
DROP TABLE IF EXISTS "categories" CASCADE;
DROP TABLE IF EXISTS "users" CASCADE;

-- Drop all types
DROP TYPE IF EXISTS "public"."alert_type" CASCADE;
DROP TYPE IF EXISTS "public"."item_condition" CASCADE;
DROP TYPE IF EXISTS "public"."order_status" CASCADE;
DROP TYPE IF EXISTS "public"."org_role" CASCADE;
DROP TYPE IF EXISTS "public"."org_status" CASCADE;
DROP TYPE IF EXISTS "public"."platform_role" CASCADE;

