| 1 | CREATE TYPE "public"."pull_request_state" AS ENUM('open', 'closed', 'merged');--> statement-breakpoint |
| 2 | CREATE TABLE "pull_request" ( |
| 3 | "id" text PRIMARY KEY |
| 4 | "number" integer NOT NULL |
| 5 | "title" text NOT NULL |
| 6 | "body" text, |
| 7 | "state" "pull_request_state" DEFAULT |
| 8 | "baseRepositoryId" text NOT NULL |
| 9 | "baseRef" text NOT NULL |
| 10 | "headRepositoryId" text NOT NULL |
| 11 | "headRef" text NOT NULL |
| 12 | "headSha" text NOT NULL |
| 13 | "mergeCommitSha" text, |
| 14 | "authorId" text NOT NULL |
| 15 | "closedAt" timestamp, |
| 16 | "mergedAt" timestamp, |
| 17 | "createdAt" timestamp DEFAULT |
| 18 | "updatedAt" timestamp DEFAULT |
| 19 | CONSTRAINT "pull_request_id_unique" UNIQUE |
| 20 | ); |
| 21 | --> statement-breakpoint |
| 22 | ALTER TABLE "pull_request" ADD |
| 23 | ALTER TABLE "pull_request" ADD |
| 24 | ALTER TABLE "pull_request" ADD |
| 25 | CREATE UNIQUE INDEX "pull_request_base_number_idx" ON |
| 26 | CREATE UNIQUE INDEX "pull_request_open_branch_idx" ON |
| 27 | CREATE INDEX "pull_request_head_idx" ON |
| 28 | CREATE INDEX "pull_request_base_state_idx" ON |