kaneo (minimalist kanban) fork to experiment adding a tangled integration
github.com/usekaneo/kaneo
1CREATE TABLE "asset" (
2 "id" text PRIMARY KEY NOT NULL,
3 "workspace_id" text NOT NULL,
4 "project_id" text NOT NULL,
5 "task_id" text,
6 "activity_id" text,
7 "object_key" text NOT NULL,
8 "filename" text NOT NULL,
9 "mime_type" text NOT NULL,
10 "size" integer NOT NULL,
11 "kind" text DEFAULT 'image' NOT NULL,
12 "surface" text DEFAULT 'description' NOT NULL,
13 "created_by" text,
14 "created_at" timestamp DEFAULT now() NOT NULL,
15 CONSTRAINT "asset_object_key_unique" UNIQUE("object_key")
16);
17--> statement-breakpoint
18ALTER TABLE "asset" ADD CONSTRAINT "asset_workspace_id_workspace_id_fk" FOREIGN KEY ("workspace_id") REFERENCES "public"."workspace"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint
19ALTER TABLE "asset" ADD CONSTRAINT "asset_project_id_project_id_fk" FOREIGN KEY ("project_id") REFERENCES "public"."project"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint
20ALTER TABLE "asset" ADD CONSTRAINT "asset_task_id_task_id_fk" FOREIGN KEY ("task_id") REFERENCES "public"."task"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint
21ALTER TABLE "asset" ADD CONSTRAINT "asset_activity_id_activity_id_fk" FOREIGN KEY ("activity_id") REFERENCES "public"."activity"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint
22ALTER TABLE "asset" ADD CONSTRAINT "asset_created_by_user_id_fk" FOREIGN KEY ("created_by") REFERENCES "public"."user"("id") ON DELETE set null ON UPDATE cascade;--> statement-breakpoint
23CREATE INDEX "asset_workspaceId_idx" ON "asset" USING btree ("workspace_id");--> statement-breakpoint
24CREATE INDEX "asset_projectId_idx" ON "asset" USING btree ("project_id");--> statement-breakpoint
25CREATE INDEX "asset_taskId_idx" ON "asset" USING btree ("task_id");--> statement-breakpoint
26CREATE INDEX "asset_activityId_idx" ON "asset" USING btree ("activity_id");