Query

event_store.db — memory_embeddings

SQL

CREATE TABLE memory_embeddings  (
  namespace TEXT NOT NULL,
  memory_id TEXT NOT NULL,
  model TEXT NOT NULL,
  dim INTEGER NOT NULL,
  vector TEXT NOT NULL,
  updated_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
  PRIMARY KEY (namespace, memory_id),
  FOREIGN KEY (namespace, memory_id) REFERENCES memory_items(namespace, id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
namespace TEXT ✓ Rename | Drop
memory_id TEXT ✓ Rename | Drop
model TEXT Rename | Drop
dim INTEGER Rename | Drop
vector TEXT Rename | Drop
updated_at TEXT Rename | Drop

Foreign Keys

Column Destination
namespace memory_items.namespace
memory_id memory_items.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_memory_embeddings_updated
  • namespace
  • updated_at
 SQL 
CREATE INDEX idx_memory_embeddings_updated
ON memory_embeddings (namespace, updated_at DESC)
Drop
sqlite_autoindex_memory_embeddings_1
  • namespace
  • memory_id
 ✓ SQL
-- no sql found --
 Drop