Query

event_store.db — slack_deliveries

SQL

CREATE TABLE slack_deliveries  (
  delivery_fp TEXT PRIMARY KEY,
  data TEXT NOT NULL,
  created_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
  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
delivery_fp TEXT ✓ ✓ Rename | Drop
data TEXT Rename | Drop
created_at TEXT Rename | Drop
updated_at TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_slack_deliveries_kind None SQL 
CREATE INDEX idx_slack_deliveries_kind
ON slack_deliveries(json_extract(data, '$.kind'))
Drop
idx_slack_deliveries_updated_at updated_at SQL 
CREATE INDEX idx_slack_deliveries_updated_at
ON slack_deliveries(updated_at)
Drop
sqlite_autoindex_slack_deliveries_1 delivery_fp ✓ SQL
-- no sql found --
 Drop