danieldaum.net / kaneo
kaneo (minimalist kanban) fork to experiment adding a tangled integration github.com/usekaneo/kaneo
0
fork

Configure Feed

Select the types of activity you want to include in your feed.

kaneo / apps / api / drizzle / 0015_add_comment_and_archival.sql
at 39e2dfae265f26c8d6d888a560f50ab2d5d58b3f 14 lines 873 B view raw
Ivan Bobchenkov fix(api): consolidate migrations into single 0015 without duplicate asset table
ebb9b67d
1CREATE TABLE "comment" ( 2 "id" text PRIMARY KEY NOT NULL, 3 "task_id" text NOT NULL, 4 "user_id" text NOT NULL, 5 "content" text NOT NULL, 6 "created_at" timestamp DEFAULT now() NOT NULL, 7 "updated_at" timestamp DEFAULT now() NOT NULL 8); 9--> statement-breakpoint 10ALTER TABLE "project" ADD COLUMN "archived_at" timestamp;--> statement-breakpoint 11ALTER TABLE "comment" ADD CONSTRAINT "comment_task_id_task_id_fk" FOREIGN KEY ("task_id") REFERENCES "public"."task"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint 12ALTER TABLE "comment" ADD CONSTRAINT "comment_user_id_user_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."user"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint 13CREATE INDEX "comment_task_idx" ON "comment" USING btree ("task_id");--> statement-breakpoint 14CREATE INDEX "comment_user_idx" ON "comment" USING btree ("user_id");