-- Fix UGC Content Creator schema: rename content_niches→niche_tags (matches Rust model)
ALTER TABLE ugc_content_creator_profiles
  ADD COLUMN IF NOT EXISTS niche_tags TEXT[] DEFAULT '{}';

UPDATE ugc_content_creator_profiles
SET niche_tags = COALESCE(content_niches, '{}')
WHERE niche_tags IS NULL;
