Query

event_store.db — schedules

SQL

CREATE TABLE schedules  (
  id TEXT PRIMARY KEY,
  name TEXT NOT NULL,
  cron TEXT NOT NULL,
  job_type TEXT NOT NULL,
  params TEXT,
  enabled INTEGER DEFAULT 1,
  next_run_at 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'))
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ ✓ Rename | Drop
name TEXT Rename | Drop
cron TEXT Rename | Drop
job_type TEXT Rename | Drop
params TEXT ✓ Rename | Drop
enabled INTEGER ✓ Rename | Drop
next_run_at TEXT ✓ Rename | Drop
created_at TEXT Rename | Drop
updated_at TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_schedules_1 id ✓ SQL
-- no sql found --
 Drop