ALTER TABLE "community_posts" ADD COLUMN "paired_post_id" uuid;--> statement-breakpoint
ALTER TABLE "community_posts" ADD CONSTRAINT "community_posts_paired_post_id_community_posts_id_fk" FOREIGN KEY ("paired_post_id") REFERENCES "public"."community_posts"("id") ON DELETE set null ON UPDATE no action;--> statement-breakpoint
CREATE INDEX "community_posts_paired_post_idx" ON "community_posts" USING btree ("paired_post_id");