USE elites_business_listing;

-- Remove only the known Phase 4 demonstration records.
-- This does not touch businesses registered by real users.
DELETE r FROM reviews r
JOIN businesses b ON b.id=r.business_id
WHERE b.slug IN ('zamzam-restaurant','hanaa-modest-wear','techhub-solutions');

DELETE s FROM business_services s
JOIN businesses b ON b.id=s.business_id
WHERE b.slug IN ('zamzam-restaurant','hanaa-modest-wear','techhub-solutions');

DELETE v FROM business_views v
JOIN businesses b ON b.id=v.business_id
WHERE b.slug IN ('zamzam-restaurant','hanaa-modest-wear','techhub-solutions');

DELETE e FROM business_enquiries e
JOIN businesses b ON b.id=e.business_id
WHERE b.slug IN ('zamzam-restaurant','hanaa-modest-wear','techhub-solutions');

DELETE FROM businesses
WHERE slug IN ('zamzam-restaurant','hanaa-modest-wear','techhub-solutions');

DELETE FROM users
WHERE email='demo.owner@example.com'
  AND role='business_owner';

-- Verify that the known demo records are gone:
SELECT COUNT(*) AS remaining_demo_businesses
FROM businesses
WHERE slug IN ('zamzam-restaurant','hanaa-modest-wear','techhub-solutions');