| 1 | CREATE TYPE "public"."diff_side" AS ENUM('deletions', 'additions');--> statement-breakpoint |
| 2 | CREATE TYPE "public"."pull_request_review_state" AS ENUM('commented', 'approved', 'changes_requested');--> statement-breakpoint |
| 3 | ALTER TYPE "public"."issue_event_type" ADD VALUE 'ready_for_review';--> statement-breakpoint |
| 4 | CREATE TABLE "pull_request_review" ( |
| 5 | "id" text PRIMARY KEY NOT NULL, |
| 6 | "pullRequestId" text NOT NULL, |
| 7 | "authorId" text NOT NULL, |
| 8 | "state" "pull_request_review_state" NOT NULL, |
| 9 | "body" text, |
| 10 | "commitSha" text NOT NULL, |
| 11 | "createdAt" timestamp with time zone DEFAULT now() NOT NULL, |
| 12 | CONSTRAINT "pull_request_review_id_unique" UNIQUE("id") |
| 13 | ); |
| 14 | --> statement-breakpoint |
| 15 | CREATE TABLE "pull_request_review_comment" ( |
| 16 | "id" text PRIMARY KEY NOT NULL, |
| 17 | "reviewId" text NOT NULL, |
| 18 | "path" text NOT NULL, |
| 19 | "side" "diff_side" NOT NULL, |
| 20 | "line" integer NOT NULL, |
| 21 | "body" text NOT NULL, |
| 22 | "createdAt" timestamp with time zone DEFAULT now() NOT NULL, |
| 23 | CONSTRAINT "pull_request_review_comment_id_unique" UNIQUE("id") |
| 24 | ); |
| 25 | --> statement-breakpoint |
| 26 | ALTER TABLE "pull_request" ADD COLUMN "draft" boolean DEFAULT false NOT NULL;--> statement-breakpoint |
| 27 | ALTER TABLE "pull_request_review" ADD CONSTRAINT "pull_request_review_pullRequestId_pull_request_id_fk" FOREIGN KEY ("pullRequestId") REFERENCES "public"."pull_request"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 28 | ALTER TABLE "pull_request_review" ADD CONSTRAINT "pull_request_review_authorId_user_id_fk" FOREIGN KEY ("authorId") REFERENCES "public"."user"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 29 | ALTER TABLE "pull_request_review_comment" ADD CONSTRAINT "pull_request_review_comment_reviewId_pull_request_review_id_fk" FOREIGN KEY ("reviewId") REFERENCES "public"."pull_request_review"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 30 | CREATE INDEX "pull_request_review_pull_idx" ON "pull_request_review" USING btree ("pullRequestId","createdAt");--> statement-breakpoint |
| 31 | CREATE INDEX "pull_request_review_comment_review_idx" ON "pull_request_review_comment" USING btree ("reviewId"); |