-- Migration 017: Add zielgruppen (target groups) to event categories
-- Links categories to user groups for visibility filtering
ALTER TABLE veranstaltung_kategorien
    ADD COLUMN IF NOT EXISTS zielgruppen TEXT[] NOT NULL DEFAULT '{}';

-- Comment for documentation
COMMENT ON COLUMN veranstaltung_kategorien.zielgruppen IS 'Array of Authentik group names this category is linked to';
