kaneo (minimalist kanban) fork to experiment adding a tangled integration
github.com/usekaneo/kaneo
1CREATE TABLE "device_code" (
2 "id" text PRIMARY KEY NOT NULL,
3 "device_code" text NOT NULL,
4 "user_code" text NOT NULL,
5 "user_id" text,
6 "expires_at" timestamp NOT NULL,
7 "status" text NOT NULL,
8 "last_polled_at" timestamp,
9 "polling_interval" integer,
10 "client_id" text,
11 "scope" text
12);
13--> statement-breakpoint
14ALTER TABLE "device_code" ADD CONSTRAINT "device_code_user_id_user_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."user"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint
15CREATE UNIQUE INDEX "device_code_device_code_uidx" ON "device_code" USING btree ("device_code");--> statement-breakpoint
16CREATE UNIQUE INDEX "device_code_user_code_uidx" ON "device_code" USING btree ("user_code");--> statement-breakpoint
17CREATE INDEX "device_code_user_id_idx" ON "device_code" USING btree ("user_id");