Query

event_store.db — memory_journal

SQL

CREATE TABLE memory_journal  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  namespace TEXT NOT NULL,
  payload TEXT NOT NULL,
  created_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now'))
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
namespace TEXT Rename | Drop
payload TEXT Rename | Drop
created_at TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_memory_journal_namespace
  • namespace
  • id
 SQL 
CREATE INDEX idx_memory_journal_namespace
ON memory_journal (namespace, id)
Drop