SQL

CREATE TABLE raw_webhooks  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  source TEXT NOT NULL,
  -- e.g. 'beds24'
    payload TEXT NOT NULL,
  -- JSON string
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  processed_status TEXT DEFAULT 'pending' -- pending,
  processed,
  failed
)

+ Add column

Columns

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

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_raw_webhooks_created_at created_at SQL 
CREATE INDEX idx_raw_webhooks_created_at
ON raw_webhooks(created_at)
Drop