Query

event_store.db — signal_fps

SQL

CREATE TABLE signal_fps  (
  fp TEXT PRIMARY KEY,
  status TEXT NOT NULL CHECK (status IN ('new','open','fired','throttled','suppressed','failed')),
  signal_type TEXT,
  signal_id TEXT,
  watcher_id TEXT,
  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')),
  FOREIGN KEY (signal_id) REFERENCES signals(id) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED,
  FOREIGN KEY (watcher_id) REFERENCES watchers(id) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
fp TEXT ✓ ✓ Rename | Drop
status TEXT Rename | Drop
signal_type TEXT ✓ Rename | Drop
signal_id TEXT ✓ Rename | Drop
watcher_id TEXT ✓ Rename | Drop
created_at TEXT Rename | Drop
updated_at TEXT Rename | Drop

Foreign Keys

Column Destination
watcher_id watchers.id
signal_id signals.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_signal_fps_status
  • status
  • updated_at
 SQL 
CREATE INDEX idx_signal_fps_status
ON signal_fps (status, updated_at)
Drop
sqlite_autoindex_signal_fps_1 fp ✓ SQL
-- no sql found --
 Drop