homeio

1CREATE TABLE IF NOT EXISTS "notifications" (
2	"id" text PRIMARY KEY NOT NULL,
3	"title" text NOT NULL,
4	"body" text NOT NULL,
5	"kind" text DEFAULT 'info' NOT NULL,
6	"read" boolean DEFAULT false NOT NULL,
7	"created_at" timestamp with time zone DEFAULT now() NOT NULL
8);
9--> statement-breakpoint
10CREATE TABLE IF NOT EXISTS "scheduled_tasks" (
11	"id" text PRIMARY KEY NOT NULL,
12	"label" text NOT NULL,
13	"task_type" text NOT NULL,
14	"task_config" jsonb DEFAULT '{}'::jsonb NOT NULL,
15	"cron_expression" text NOT NULL,
16	"enabled" boolean DEFAULT true NOT NULL,
17	"last_run_at" timestamp with time zone,
18	"last_run_status" text,
19	"last_run_output" text,
20	"next_run_at" timestamp with time zone,
21	"created_at" timestamp with time zone DEFAULT now() NOT NULL,
22	"updated_at" timestamp with time zone DEFAULT now() NOT NULL
23);
24--> statement-breakpoint
25CREATE INDEX IF NOT EXISTS "notifications_created_at_idx" ON "notifications" USING btree ("created_at" DESC NULLS LAST);
26--> statement-breakpoint
27CREATE INDEX IF NOT EXISTS "scheduled_tasks_next_run_at_idx" ON "scheduled_tasks" USING btree ("next_run_at");
28--> statement-breakpoint
29DROP TABLE IF EXISTS "instance_config";
30