-- Migration: Remove file duplicate constraint
-- Purpose: Allow duplicate files by removing unique constraint on checksum_sha256, size_bytes, and mime_type
-- Date: 2026-05-13

-- Drop the unique constraint that prevents duplicate files
ALTER TABLE files DROP CONSTRAINT IF EXISTS uq_files_content_dedupe;
