homeio

1CREATE TABLE IF NOT EXISTS "scheduled_task_executions" (
2  "id" text PRIMARY KEY NOT NULL,
3  "task_id" text NOT NULL REFERENCES "scheduled_tasks"("id") ON DELETE CASCADE,
4  "status" text NOT NULL,
5  "output" text,
6  "started_at" timestamp with time zone DEFAULT now() NOT NULL,
7  "duration_ms" integer
8);
9
10CREATE INDEX IF NOT EXISTS "scheduled_task_executions_task_id_idx" ON "scheduled_task_executions" ("task_id");
11CREATE INDEX IF NOT EXISTS "scheduled_task_executions_started_at_idx" ON "scheduled_task_executions" ("started_at" DESC);
12