Query

event_store.db — memory_items

SQL

CREATE TABLE memory_items  (
  id TEXT NOT NULL,
  namespace TEXT NOT NULL,
  kind TEXT NOT NULL,
  text TEXT NOT NULL,
  tags TEXT,
  source_event_ids TEXT,
  source TEXT,
  salience REAL DEFAULT 0.0,
  decay_days INTEGER,
  pinned INTEGER DEFAULT 0,
  about_date TEXT,
  meta TEXT,
  created_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
  PRIMARY KEY (namespace, id)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ Rename | Drop
namespace TEXT ✓ Rename | Drop
kind TEXT Rename | Drop
text TEXT Rename | Drop
tags TEXT ✓ Rename | Drop
source_event_ids TEXT ✓ Rename | Drop
source TEXT ✓ Rename | Drop
salience REAL ✓ Rename | Drop
decay_days INTEGER ✓ Rename | Drop
pinned INTEGER ✓ Rename | Drop
about_date TEXT ✓ Rename | Drop
meta TEXT ✓ Rename | Drop
created_at TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_memory_items_namespace
  • namespace
  • created_at
 SQL 
CREATE INDEX idx_memory_items_namespace
ON memory_items (namespace, created_at)
Drop
sqlite_autoindex_memory_items_1
  • namespace
  • id
 ✓ SQL
-- no sql found --
 Drop