-- ============================================================
-- PHASE 2 DELTA — run this ONLY if you already deployed Phase 1
-- and imported its schema.sql. If you're installing fresh, just
-- use database/schema.sql (already includes this) and skip this file.
--
-- What this does: Phase 0/1 seeded categories for news, blog, and
-- podcast, but not audio or video — a gap that only became visible
-- once Phase 2 needed category dropdowns for those two types. This
-- adds the missing rows. No table structure changes; safe to run
-- on a live database.
-- ============================================================

INSERT INTO categories (name, slug, type) VALUES
('Field Reports', 'field-reports', 'audio'),
('Campus Voices', 'campus-voices', 'audio'),
('Sports Audio', 'sports-audio', 'audio'),
('Audio Editorials', 'audio-editorials', 'audio'),
('Campus Events', 'campus-events-video', 'video'),
('Sports Highlights', 'sports-highlights', 'video'),
('Mini-Documentaries', 'mini-documentaries', 'video'),
('Explainers', 'explainers', 'video');
