Clawdie AI
cc37d2c8cf
--- Build: pass | Tests: pass - 603 passed (44 files) --- Build: pass | Tests: pass — Tests 603 passed (603)
22 lines
646 B
SQL
22 lines
646 B
SQL
-- ai_brain base schema
|
|
-- Date: 10.mar.2026
|
|
--
|
|
-- Prerequisites:
|
|
-- CREATE EXTENSION IF NOT EXISTS pgcrypto;
|
|
-- CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
|
|
-- CREATE EXTENSION IF NOT EXISTS vector;
|
|
--
|
|
-- Apply this first, then clawdie-brain-hybrid-upgrade.sql
|
|
|
|
CREATE TABLE IF NOT EXISTS memories (
|
|
id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
|
|
created_at TIMESTAMPTZ DEFAULT NOW(),
|
|
session_id TEXT,
|
|
importance INTEGER DEFAULT 2,
|
|
summary TEXT NOT NULL,
|
|
topics TEXT[] DEFAULT '{}',
|
|
key_facts TEXT[] DEFAULT '{}',
|
|
decisions TEXT[] DEFAULT '{}',
|
|
first_message TEXT,
|
|
message_count INTEGER DEFAULT 0
|
|
);
|