pinakes/migrations/postgres/V14__perceptual_hash.sql

-- V14: Perceptual hash for duplicate detection
-- Add perceptual hash column for image similarity detection

ALTER TABLE media_items ADD COLUMN perceptual_hash TEXT;

-- Index for perceptual hash lookups
CREATE INDEX idx_media_phash ON media_items(perceptual_hash) WHERE perceptual_hash IS NOT NULL;