Query

event_store.db — leader_leases

SQL

CREATE TABLE leader_leases  (
  name TEXT PRIMARY KEY,
  holder TEXT NOT NULL,
  lease_expires_at TEXT NOT NULL,
  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
name TEXT ✓ ✓ Rename | Drop
holder TEXT Rename | Drop
lease_expires_at TEXT Rename | Drop
updated_at TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_leader_leases_expires lease_expires_at SQL 
CREATE INDEX idx_leader_leases_expires
ON leader_leases (lease_expires_at)
Drop
sqlite_autoindex_leader_leases_1 name ✓ SQL
-- no sql found --
 Drop