SQL

CREATE TABLE inbox_raw  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  source TEXT NOT NULL,
  payload TEXT NOT NULL,
  received_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  processed BOOLEAN DEFAULT 0,
  processed_at DATETIME,
  error TEXT,
  dedupe_key TEXT,
  payload_json TEXT
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
source TEXT Rename | Drop
payload TEXT Rename | Drop
received_at DATETIME ✓ Rename | Drop
processed BOOLEAN ✓ Rename | Drop
processed_at DATETIME ✓ Rename | Drop
error TEXT ✓ Rename | Drop
dedupe_key TEXT ✓ Rename | Drop
payload_json TEXT ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_inbox_raw_dedupe_unique dedupe_key ✓ SQL 
CREATE UNIQUE INDEX idx_inbox_raw_dedupe_unique
ON inbox_raw(dedupe_key) WHERE dedupe_key IS NOT NULL
Drop
idx_inbox_raw_processed
  • processed
  • received_at
 SQL 
CREATE INDEX idx_inbox_raw_processed
ON inbox_raw(processed, received_at)
Drop