Query

event_store.db — opportunity_memory

SQL

CREATE TABLE opportunity_memory  (
  key TEXT PRIMARY KEY,
  last_surfaced_at TEXT,
  surfaced_count INTEGER DEFAULT 0,
  last_candidate_id TEXT,
  last_kind TEXT,
  last_subject TEXT,
  last_raw TEXT,
  last_summary TEXT,
  updated_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now'))
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
key TEXT ✓ ✓ Rename | Drop
last_surfaced_at TEXT ✓ Rename | Drop
surfaced_count INTEGER ✓ Rename | Drop
last_candidate_id TEXT ✓ Rename | Drop
last_kind TEXT ✓ Rename | Drop
last_subject TEXT ✓ Rename | Drop
last_raw TEXT ✓ Rename | Drop
last_summary TEXT ✓ Rename | Drop
updated_at TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_opportunity_memory_updated updated_at SQL 
CREATE INDEX idx_opportunity_memory_updated
ON opportunity_memory (updated_at)
Drop
sqlite_autoindex_opportunity_memory_1 key ✓ SQL
-- no sql found --
 Drop