kaneo (minimalist kanban) fork to experiment adding a tangled integration
github.com/usekaneo/kaneo
1CREATE TABLE "external_link" (
2 "id" text PRIMARY KEY NOT NULL,
3 "task_id" text NOT NULL,
4 "integration_id" text NOT NULL,
5 "resource_type" text NOT NULL,
6 "external_id" text NOT NULL,
7 "url" text NOT NULL,
8 "title" text,
9 "metadata" text,
10 "created_at" timestamp DEFAULT now() NOT NULL,
11 "updated_at" timestamp DEFAULT now() NOT NULL
12);
13--> statement-breakpoint
14CREATE TABLE "integration" (
15 "id" text PRIMARY KEY NOT NULL,
16 "project_id" text NOT NULL,
17 "type" text NOT NULL,
18 "config" text NOT NULL,
19 "is_active" boolean DEFAULT true,
20 "created_at" timestamp DEFAULT now() NOT NULL,
21 "updated_at" timestamp DEFAULT now() NOT NULL
22);
23--> statement-breakpoint
24ALTER TABLE "external_link" ADD CONSTRAINT "external_link_task_id_task_id_fk" FOREIGN KEY ("task_id") REFERENCES "public"."task"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint
25ALTER TABLE "external_link" ADD CONSTRAINT "external_link_integration_id_integration_id_fk" FOREIGN KEY ("integration_id") REFERENCES "public"."integration"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint
26ALTER TABLE "integration" ADD CONSTRAINT "integration_project_id_project_id_fk" FOREIGN KEY ("project_id") REFERENCES "public"."project"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint
27CREATE INDEX "external_link_taskId_idx" ON "external_link" USING btree ("task_id");--> statement-breakpoint
28CREATE INDEX "external_link_integrationId_idx" ON "external_link" USING btree ("integration_id");--> statement-breakpoint
29CREATE INDEX "external_link_externalId_idx" ON "external_link" USING btree ("external_id");--> statement-breakpoint
30CREATE INDEX "external_link_resourceType_idx" ON "external_link" USING btree ("resource_type");--> statement-breakpoint
31CREATE INDEX "integration_projectId_idx" ON "integration" USING btree ("project_id");--> statement-breakpoint
32CREATE INDEX "integration_type_idx" ON "integration" USING btree ("type");