-- Cleanup script for live server - run this BEFORE importing live_database.sql
-- This will remove any existing views/tables that might conflict

DROP VIEW IF EXISTS `registrations_with_delegate_types`;
DROP VIEW IF EXISTS `dietary_summary`;
DROP VIEW IF EXISTS `recent_product_activities`;
DROP VIEW IF EXISTS `recent_registration_activities`;
DROP VIEW IF EXISTS `registrations_with_delegate_products`;
DROP VIEW IF EXISTS `registration_analytics`;
DROP VIEW IF EXISTS `registration_stats`;
DROP VIEW IF EXISTS `special_assistance_summary`;

-- Also drop any tables with these names (in case they exist as tables instead of views)
DROP TABLE IF EXISTS `registrations_with_delegate_types`;
DROP TABLE IF EXISTS `dietary_summary`;
DROP TABLE IF EXISTS `recent_product_activities`;
DROP TABLE IF EXISTS `recent_registration_activities`;
DROP TABLE IF EXISTS `registrations_with_delegate_products`;
DROP TABLE IF EXISTS `registration_analytics`;
DROP TABLE IF EXISTS `registration_stats`;
DROP TABLE IF EXISTS `special_assistance_summary`;
