Query

event_store.db — dead_letters

SQL

CREATE TABLE dead_letters  (
  id TEXT PRIMARY KEY,
  source TEXT NOT NULL,
  error TEXT NOT NULL,
  payload TEXT,
  dedupe_key TEXT,
  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 TEXT ✓ ✓ Rename | Drop
source TEXT Rename | Drop
error TEXT Rename | Drop
payload TEXT ✓ Rename | Drop
dedupe_key TEXT ✓ Rename | Drop
created_at TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_dead_letters_dedupe dedupe_key ✓ SQL 
CREATE UNIQUE INDEX idx_dead_letters_dedupe
ON dead_letters (dedupe_key)
Drop
sqlite_autoindex_dead_letters_1 id ✓ SQL
-- no sql found --
 Drop