kaneo (minimalist kanban) fork to experiment adding a tangled integration
github.com/usekaneo/kaneo
1CREATE TABLE "github_integration" (
2 "id" text PRIMARY KEY NOT NULL,
3 "project_id" text NOT NULL,
4 "repository_owner" text NOT NULL,
5 "repository_name" text NOT NULL,
6 "installation_id" integer,
7 "is_active" boolean DEFAULT true,
8 "created_at" timestamp DEFAULT now() NOT NULL,
9 "updated_at" timestamp DEFAULT now() NOT NULL,
10 CONSTRAINT "github_integration_project_id_unique" UNIQUE("project_id")
11);
12--> statement-breakpoint
13ALTER TABLE "github_integration" ADD CONSTRAINT "github_integration_project_id_project_id_fk" FOREIGN KEY ("project_id") REFERENCES "public"."project"("id") ON DELETE cascade ON UPDATE cascade;