-- Migration: Add content_hash column for file deduplication
-- Date: 2026-05-14
-- Usage: psql -U accusys -d momentry -f migrate_add_content_hash.sql

ALTER TABLE videos ADD COLUMN IF NOT EXISTS content_hash TEXT;
CREATE INDEX IF NOT EXISTS idx_videos_content_hash ON videos(content_hash) WHERE content_hash IS NOT NULL;