kaneo (minimalist kanban) fork to experiment adding a tangled integration
github.com/usekaneo/kaneo
1CREATE TABLE "apikey" (
2 "id" text PRIMARY KEY NOT NULL,
3 "name" text,
4 "start" text,
5 "prefix" text,
6 "key" text NOT NULL,
7 "user_id" text NOT NULL,
8 "refill_interval" integer,
9 "refill_amount" integer,
10 "last_refill_at" timestamp,
11 "enabled" boolean DEFAULT true,
12 "rate_limit_enabled" boolean DEFAULT true,
13 "rate_limit_time_window" integer DEFAULT 86400000,
14 "rate_limit_max" integer DEFAULT 10,
15 "request_count" integer DEFAULT 0,
16 "remaining" integer,
17 "last_request" timestamp,
18 "expires_at" timestamp,
19 "created_at" timestamp NOT NULL,
20 "updated_at" timestamp NOT NULL,
21 "permissions" text,
22 "metadata" text
23);
24--> statement-breakpoint
25ALTER TABLE "apikey" ADD CONSTRAINT "apikey_user_id_user_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."user"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
26CREATE INDEX "apikey_key_idx" ON "apikey" USING btree ("key");--> statement-breakpoint
27CREATE INDEX "apikey_userId_idx" ON "apikey" USING btree ("user_id");