7 lines
322 B
SQL
7 lines
322 B
SQL
-- 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;
|