-- This is a copy of live_database.sql with DEFINER clauses removed from VIEWs
-- to avoid MySQL privilege errors during import

-- Copy the entire content from live_database.sql but replace:
-- CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW
-- with:
-- CREATE VIEW

-- The problematic lines that need to be changed:
-- Line 383: CREATE VIEW `dietary_summary` AS SELECT...
-- Line 386: CREATE VIEW `recent_product_activities` AS SELECT...  
-- Line 389: CREATE VIEW `registration_stats` AS SELECT...
-- Line 392: CREATE VIEW `special_assistance_summary` AS SELECT...
