Kyoo/api/drizzle/0016_mqueue.sql
2025-03-18 22:05:45 +01:00

9 lines
353 B
SQL

CREATE TABLE "kyoo"."mqueue" (
"id" uuid PRIMARY KEY DEFAULT gen_random_uuid() NOT NULL,
"kind" varchar(255) NOT NULL,
"message" jsonb NOT NULL,
"attempt" integer DEFAULT 0 NOT NULL,
"created_at" timestamp with time zone DEFAULT now() NOT NULL
);
--> statement-breakpoint
CREATE INDEX "mqueue_created" ON "kyoo"."mqueue" USING btree ("created_at");