| -- ── Run this once in your Supabase SQL editor ────────────────────── | |
| -- Two tables only. No chat_history table — raw messages live in | |
| -- session_state; only distilled knowledge is persisted. | |
| -- Per-paper memory: corrections, self-revisions, established facts, | |
| -- and compressed conversation summaries (sliding window). | |
| CREATE TABLE IF NOT EXISTS memory_paper ( | |
| id UUID PRIMARY KEY DEFAULT gen_random_uuid(), | |
| paper_id TEXT NOT NULL, | |
| type TEXT NOT NULL, -- 'correction' | 'self_revision' | 'established_fact' | 'conversation_summary' | |
| content TEXT NOT NULL, | |
| turn_range TEXT, -- e.g. "1-5" — which turns this summary covers | |
| created_at TIMESTAMPTZ DEFAULT NOW() | |
| ); | |
| CREATE INDEX IF NOT EXISTS idx_memory_paper_paper_id ON memory_paper(paper_id); | |
| CREATE INDEX IF NOT EXISTS idx_memory_paper_type ON memory_paper(type); | |
| -- Global user memory: expertise signals and style preferences | |
| -- that carry across all papers. | |
| CREATE TABLE IF NOT EXISTS memory_user ( | |
| id UUID PRIMARY KEY DEFAULT gen_random_uuid(), | |
| type TEXT NOT NULL, -- 'expertise_signal' | 'style_preference' | |
| content TEXT NOT NULL, | |
| created_at TIMESTAMPTZ DEFAULT NOW() | |
| ); | |
| CREATE INDEX IF NOT EXISTS idx_memory_user_type ON memory_user(type); | |