Query

data — SyncJob

SQL

CREATE TABLE "SyncJob"  (
  "id" integer PRIMARY KEY,
  "status" text NOT NULL,
  "pages_done" integer NOT NULL DEFAULT 0,
  "pages_total" integer,
  "error" text,
  "started_at" text NOT NULL DEFAULT CURRENT_TIMESTAMP,
  "finished_at" text
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
status TEXT Rename | Drop
pages_done INTEGER Rename | Drop
pages_total INTEGER ✓ Rename | Drop
error TEXT ✓ Rename | Drop
started_at TEXT Rename | Drop
finished_at TEXT ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?