-- Migration: 00033_add_review_and_moderation_indexes
-- Description: Add missing review_id indexes for comments/responses and item_id index for moderation_queue
-- Date: 2025-12-30

CREATE INDEX idx_comments_review_id
  ON comments(review_id, status, published_at DESC);

CREATE INDEX idx_responses_review_id
  ON responses(review_id, status, published_at DESC);

CREATE INDEX idx_moderation_queue_item
  ON moderation_queue(item_id);
