| 1 | CREATE TYPE "public"."diff_side" AS ENUM('deletions', 'additions');--> statement-breakpoint |
| 2 | CREATE TYPE "public"."pull_request_review_state |
| 3 | ALTER TYPE "public"."issue_event_type |
| 4 | CREATE TABLE "pull_request_review" ( |
| 5 | "id" text PRIMARY KEY |
| 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 |
| 12 | CONSTRAINT "pull_request_review_id_unique" UNIQUE |
| 13 | ); |
| 14 | --> statement-breakpoint |
| 15 | CREATE TABLE "pull_request_review_comment" ( |
| 16 | "id" text PRIMARY KEY |
| 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 |
| 23 | CONSTRAINT "pull_request_review_comment_id_unique" UNIQUE |
| 24 | ); |
| 25 | --> statement-breakpoint |
| 26 | ALTER TABLE "pull_request" ADD COLUMN |
| 27 | ALTER TABLE "pull_request_review" ADD |
| 28 | ALTER TABLE "pull_request_review" ADD |
| 29 | ALTER TABLE "pull_request_review_comment" ADD |
| 30 | CREATE INDEX "pull_request_review_pull_idx" ON |
| 31 | CREATE INDEX "pull_request_review_comment_review_idx" ON |