-- Migration: Remove context_fingerprint column as part of simplification
-- This aligns with the architectural separation where cognitive features moved to codex-dreams

-- Drop the column if it exists
ALTER TABLE memories DROP COLUMN IF EXISTS context_fingerprint;

-- Ensure the unique constraint is only on content_hash
ALTER TABLE memories DROP CONSTRAINT IF EXISTS memories_content_hash_context_fingerprint_key;
ALTER TABLE memories ADD CONSTRAINT memories_content_hash_key UNIQUE (content_hash);