0008_clumsy_supernaut.sql18 lines · main

1	CREATE TABLE "function_logs" (
2	"id" text PRIMARY KEY NOT NULL,
3	"project_id" text NOT NULL,
4	"deployment_id" text NOT NULL,
5	"invocation_id" text NOT NULL,
6	"function_name" varchar(128) NOT NULL,
7	"status" varchar(8) NOT NULL,
8	"duration_ms" varchar(12) NOT NULL,
9	"touched_tables" jsonb NOT NULL,
10	"user_logs_json" jsonb NOT NULL,
11	"err_code" text,
12	"err_message" text,
13	"created_at" timestamp with time zone DEFAULT now() NOT NULL
14	);
15	--> statement-breakpoint
16	ALTER TABLE "function_logs" ADD CONSTRAINT "function_logs_project_id_projects_id_fk" FOREIGN KEY ("project_id") REFERENCES "public"."projects"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
17	ALTER TABLE "function_logs" ADD CONSTRAINT "function_logs_deployment_id_deployments_id_fk" FOREIGN KEY ("deployment_id") REFERENCES "public"."deployments"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
18	CREATE INDEX "function_logs_project_created_idx" ON "function_logs" USING btree ("project_id","created_at");