Query

event_store.db — stream_cursors

SQL

CREATE TABLE stream_cursors  (
  stream     TEXT NOT NULL DEFAULT 'events',
  reducer    TEXT NOT NULL,
  cursor     INTEGER NOT NULL,
  updated_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
  PRIMARY KEY (stream, reducer)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
stream TEXT ✓ Rename | Drop
reducer TEXT ✓ Rename | Drop
cursor INTEGER Rename | Drop
updated_at TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_stream_cursors_updated updated_at SQL 
CREATE INDEX idx_stream_cursors_updated
ON stream_cursors (updated_at)
Drop
sqlite_autoindex_stream_cursors_1
  • stream
  • reducer
 ✓ SQL
-- no sql found --
 Drop