-- Announcement remake cleanup
-- Optional: run this once if old test announcements/notification-bell rows are still showing.
-- The PHP files also do this automatically when loaded.

UPDATE csr_notifications
SET is_read = 1
WHERE COALESCE(reference_type, '') = 'announcement';

UPDATE csr_announcements
SET expires_at = NULL;
