| 1 | ALTER TABLE "repository" RENAME COLUMN "organizationId" TO "organization_id";--> statement-breakpoint |
| 2 | ALTER TABLE "repository" RENAME COLUMN "ownerId" TO "owner_id";--> statement-breakpoint |
| 3 | ALTER TABLE "repository" RENAME COLUMN "defaultBranch" TO "default_branch";--> statement-breakpoint |
| 4 | ALTER TABLE "repository" RENAME COLUMN "lastPushedAt" TO "last_pushed_at";--> statement-breakpoint |
| 5 | ALTER TABLE "repository" RENAME COLUMN "parentRepositoryId" TO "parent_repository_id";--> statement-breakpoint |
| 6 | ALTER TABLE "repository" RENAME COLUMN "createdAt" TO "created_at";--> statement-breakpoint |
| 7 | ALTER TABLE "repository" RENAME COLUMN "updatedAt" TO "updated_at";--> statement-breakpoint |
| 8 | ALTER TABLE "repository_language_index" RENAME COLUMN "repositoryId" TO "repository_id";--> statement-breakpoint |
| 9 | ALTER TABLE "repository_language_index" RENAME COLUMN "indexedCommitSha" TO "indexed_commit_sha";--> statement-breakpoint |
| 10 | ALTER TABLE "repository_language_index" RENAME COLUMN "updatedAt" TO "updated_at";--> statement-breakpoint |
| 11 | ALTER TABLE "repository_language_stat" RENAME COLUMN "repositoryId" TO "repository_id";--> statement-breakpoint |
| 12 | ALTER TABLE "repository_path_commit" RENAME COLUMN "repositoryId" TO "repository_id";--> statement-breakpoint |
| 13 | ALTER TABLE "repository_path_commit" RENAME COLUMN "commitSha" TO "commit_sha";--> statement-breakpoint |
| 14 | ALTER TABLE "repository_path_commit" RENAME COLUMN "committedAt" TO "committed_at";--> statement-breakpoint |
| 15 | ALTER TABLE "repository_ref_index" RENAME COLUMN "repositoryId" TO "repository_id";--> statement-breakpoint |
| 16 | ALTER TABLE "repository_ref_index" RENAME COLUMN "indexedCommitSha" TO "indexed_commit_sha";--> statement-breakpoint |
| 17 | ALTER TABLE "repository_ref_index" RENAME COLUMN "updatedAt" TO "updated_at";--> statement-breakpoint |
| 18 | ALTER TABLE "stars" RENAME COLUMN "userId" TO "user_id";--> statement-breakpoint |
| 19 | ALTER TABLE "stars" RENAME COLUMN "repositoryId" TO "repository_id";--> statement-breakpoint |
| 20 | ALTER TABLE "stars" RENAME COLUMN "createdAt" TO "created_at";--> statement-breakpoint |
| 21 | ALTER TABLE "stars" RENAME COLUMN "updatedAt" TO "updated_at";--> statement-breakpoint |
| 22 | ALTER TABLE "pull_request" RENAME COLUMN "issueId" TO "issue_id";--> statement-breakpoint |
| 23 | ALTER TABLE "pull_request" RENAME COLUMN "baseRepositoryId" TO "base_repository_id";--> statement-breakpoint |
| 24 | ALTER TABLE "pull_request" RENAME COLUMN "baseRef" TO "base_ref";--> statement-breakpoint |
| 25 | ALTER TABLE "pull_request" RENAME COLUMN "headRepositoryId" TO "head_repository_id";--> statement-breakpoint |
| 26 | ALTER TABLE "pull_request" RENAME COLUMN "headRef" TO "head_ref";--> statement-breakpoint |
| 27 | ALTER TABLE "pull_request" RENAME COLUMN "headSha" TO "head_sha";--> statement-breakpoint |
| 28 | ALTER TABLE "pull_request" RENAME COLUMN "mergeCommitSha" TO "merge_commit_sha";--> statement-breakpoint |
| 29 | ALTER TABLE "pull_request" RENAME COLUMN "mergedAt" TO "merged_at";--> statement-breakpoint |
| 30 | ALTER TABLE "pull_request_review" RENAME COLUMN "pullRequestId" TO "pull_request_id";--> statement-breakpoint |
| 31 | ALTER TABLE "pull_request_review" RENAME COLUMN "authorId" TO "author_id";--> statement-breakpoint |
| 32 | ALTER TABLE "pull_request_review" RENAME COLUMN "commitSha" TO "commit_sha";--> statement-breakpoint |
| 33 | ALTER TABLE "pull_request_review" RENAME COLUMN "dismissedById" TO "dismissed_by_id";--> statement-breakpoint |
| 34 | ALTER TABLE "pull_request_review" RENAME COLUMN "dismissalMessage" TO "dismissal_message";--> statement-breakpoint |
| 35 | ALTER TABLE "pull_request_review" RENAME COLUMN "createdAt" TO "created_at";--> statement-breakpoint |
| 36 | ALTER TABLE "pull_request_review" RENAME COLUMN "submittedAt" TO "submitted_at";--> statement-breakpoint |
| 37 | ALTER TABLE "pull_request_review_comment" RENAME COLUMN "pullRequestId" TO "pull_request_id";--> statement-breakpoint |
| 38 | ALTER TABLE "pull_request_review_comment" RENAME COLUMN "reviewId" TO "review_id";--> statement-breakpoint |
| 39 | ALTER TABLE "pull_request_review_comment" RENAME COLUMN "inReplyToId" TO "in_reply_to_id";--> statement-breakpoint |
| 40 | ALTER TABLE "pull_request_review_comment" RENAME COLUMN "authorId" TO "author_id";--> statement-breakpoint |
| 41 | ALTER TABLE "pull_request_review_comment" RENAME COLUMN "startSide" TO "start_side";--> statement-breakpoint |
| 42 | ALTER TABLE "pull_request_review_comment" RENAME COLUMN "startLine" TO "start_line";--> statement-breakpoint |
| 43 | ALTER TABLE "pull_request_review_comment" RENAME COLUMN "commitSha" TO "commit_sha";--> statement-breakpoint |
| 44 | ALTER TABLE "pull_request_review_comment" RENAME COLUMN "diffHunk" TO "diff_hunk";--> statement-breakpoint |
| 45 | ALTER TABLE "pull_request_review_comment" RENAME COLUMN "createdAt" TO "created_at";--> statement-breakpoint |
| 46 | ALTER TABLE "pull_request_review_comment" RENAME COLUMN "updatedAt" TO "updated_at";--> statement-breakpoint |
| 47 | ALTER TABLE "issue" RENAME COLUMN "repositoryId" TO "repository_id";--> statement-breakpoint |
| 48 | ALTER TABLE "issue" RENAME COLUMN "isPullRequest" TO "is_pull_request";--> statement-breakpoint |
| 49 | ALTER TABLE "issue" RENAME COLUMN "authorId" TO "author_id";--> statement-breakpoint |
| 50 | ALTER TABLE "issue" RENAME COLUMN "closedById" TO "closed_by_id";--> statement-breakpoint |
| 51 | ALTER TABLE "issue" RENAME COLUMN "commentCount" TO "comment_count";--> statement-breakpoint |
| 52 | ALTER TABLE "issue" RENAME COLUMN "closedAt" TO "closed_at";--> statement-breakpoint |
| 53 | ALTER TABLE "issue" RENAME COLUMN "createdAt" TO "created_at";--> statement-breakpoint |
| 54 | ALTER TABLE "issue" RENAME COLUMN "updatedAt" TO "updated_at";--> statement-breakpoint |
| 55 | ALTER TABLE "issue_assignee" RENAME COLUMN "issueId" TO "issue_id";--> statement-breakpoint |
| 56 | ALTER TABLE "issue_assignee" RENAME COLUMN "userId" TO "user_id";--> statement-breakpoint |
| 57 | ALTER TABLE "issue_comment" RENAME COLUMN "issueId" TO "issue_id";--> statement-breakpoint |
| 58 | ALTER TABLE "issue_comment" RENAME COLUMN "authorId" TO "author_id";--> statement-breakpoint |
| 59 | ALTER TABLE "issue_comment" RENAME COLUMN "createdAt" TO "created_at";--> statement-breakpoint |
| 60 | ALTER TABLE "issue_comment" RENAME COLUMN "updatedAt" TO "updated_at";--> statement-breakpoint |
| 61 | ALTER TABLE "issue_event" RENAME COLUMN "issueId" TO "issue_id";--> statement-breakpoint |
| 62 | ALTER TABLE "issue_event" RENAME COLUMN "actorId" TO "actor_id";--> statement-breakpoint |
| 63 | ALTER TABLE "issue_event" RENAME COLUMN "labelName" TO "label_name";--> statement-breakpoint |
| 64 | ALTER TABLE "issue_event" RENAME COLUMN "assigneeUsername" TO "assignee_username";--> statement-breakpoint |
| 65 | ALTER TABLE "issue_event" RENAME COLUMN "oldTitle" TO "old_title";--> statement-breakpoint |
| 66 | ALTER TABLE "issue_event" RENAME COLUMN "newTitle" TO "new_title";--> statement-breakpoint |
| 67 | ALTER TABLE "issue_event" RENAME COLUMN "sourceIssueId" TO "source_issue_id";--> statement-breakpoint |
| 68 | ALTER TABLE "issue_event" RENAME COLUMN "commitSha" TO "commit_sha";--> statement-breakpoint |
| 69 | ALTER TABLE "issue_event" RENAME COLUMN "createdAt" TO "created_at";--> statement-breakpoint |
| 70 | ALTER TABLE "issue_label" RENAME COLUMN "issueId" TO "issue_id";--> statement-breakpoint |
| 71 | ALTER TABLE "issue_label" RENAME COLUMN "labelId" TO "label_id";--> statement-breakpoint |
| 72 | ALTER TABLE "issue_reference" RENAME COLUMN "sourceType" TO "source_type";--> statement-breakpoint |
| 73 | ALTER TABLE "issue_reference" RENAME COLUMN "sourceId" TO "source_id";--> statement-breakpoint |
| 74 | ALTER TABLE "issue_reference" RENAME COLUMN "sourceRepositoryId" TO "source_repository_id";--> statement-breakpoint |
| 75 | ALTER TABLE "issue_reference" RENAME COLUMN "sourceIssueId" TO "source_issue_id";--> statement-breakpoint |
| 76 | ALTER TABLE "issue_reference" RENAME COLUMN "targetIssueId" TO "target_issue_id";--> statement-breakpoint |
| 77 | ALTER TABLE "issue_reference" RENAME COLUMN "actorId" TO "actor_id";--> statement-breakpoint |
| 78 | ALTER TABLE "issue_reference" RENAME COLUMN "createdAt" TO "created_at";--> statement-breakpoint |
| 79 | ALTER TABLE "label" RENAME COLUMN "repositoryId" TO "repository_id";--> statement-breakpoint |
| 80 | ALTER TABLE "label" RENAME COLUMN "createdAt" TO "created_at";--> statement-breakpoint |
| 81 | ALTER TABLE "label" RENAME COLUMN "updatedAt" TO "updated_at";--> statement-breakpoint |
| 82 | ALTER TABLE "repository_collaborator" RENAME COLUMN "repositoryId" TO "repository_id";--> statement-breakpoint |
| 83 | ALTER TABLE "repository_collaborator" RENAME COLUMN "userId" TO "user_id";--> statement-breakpoint |
| 84 | ALTER TABLE "repository_collaborator" RENAME COLUMN "invitedById" TO "invited_by_id";--> statement-breakpoint |
| 85 | ALTER TABLE "repository_collaborator" RENAME COLUMN "createdAt" TO "created_at";--> statement-breakpoint |
| 86 | ALTER TABLE "repository_collaborator" RENAME COLUMN "acceptedAt" TO "accepted_at";--> statement-breakpoint |
| 87 | ALTER TABLE "repository_team" RENAME COLUMN "repositoryId" TO "repository_id";--> statement-breakpoint |
| 88 | ALTER TABLE "repository_team" RENAME COLUMN "teamId" TO "team_id";--> statement-breakpoint |
| 89 | ALTER TABLE "repository_team" RENAME COLUMN "createdAt" TO "created_at";--> statement-breakpoint |
| 90 | ALTER TABLE "organization_pinned_repository" RENAME COLUMN "organizationId" TO "organization_id";--> statement-breakpoint |
| 91 | ALTER TABLE "organization_pinned_repository" RENAME COLUMN "repositoryId" TO "repository_id";--> statement-breakpoint |
| 92 | ALTER TABLE "organization_public_member" RENAME COLUMN "organizationId" TO "organization_id";--> statement-breakpoint |
| 93 | ALTER TABLE "organization_public_member" RENAME COLUMN "userId" TO "user_id";--> statement-breakpoint |
| 94 | ALTER TABLE "organization_settings" RENAME COLUMN "organizationId" TO "organization_id";--> statement-breakpoint |
| 95 | ALTER TABLE "organization_settings" RENAME COLUMN "basePermission" TO "base_permission";--> statement-breakpoint |
| 96 | ALTER TABLE "organization_settings" RENAME COLUMN "membersCanCreatePublicRepositories" TO "members_can_create_public_repositories";--> statement-breakpoint |
| 97 | ALTER TABLE "organization_settings" RENAME COLUMN "membersCanCreatePrivateRepositories" TO "members_can_create_private_repositories";--> statement-breakpoint |
| 98 | ALTER TABLE "organization_settings" RENAME COLUMN "allowPrivateForks" TO "allow_private_forks";--> statement-breakpoint |
| 99 | ALTER TABLE "organization_settings" RENAME COLUMN "defaultBranch" TO "default_branch";--> statement-breakpoint |
| 100 | ALTER TABLE "organization_settings" RENAME COLUMN "updatedAt" TO "updated_at";--> statement-breakpoint |
| 101 | ALTER TABLE "repository_redirect" RENAME COLUMN "ownerName" TO "owner_name";--> statement-breakpoint |
| 102 | ALTER TABLE "repository_redirect" RENAME COLUMN "repositoryId" TO "repository_id";--> statement-breakpoint |
| 103 | ALTER TABLE "repository_redirect" RENAME COLUMN "createdAt" TO "created_at";--> statement-breakpoint |
| 104 | ALTER TABLE "repository_transfer" RENAME COLUMN "repositoryId" TO "repository_id";--> statement-breakpoint |
| 105 | ALTER TABLE "repository_transfer" RENAME COLUMN "toUserId" TO "to_user_id";--> statement-breakpoint |
| 106 | ALTER TABLE "repository_transfer" RENAME COLUMN "toOrganizationId" TO "to_organization_id";--> statement-breakpoint |
| 107 | ALTER TABLE "repository_transfer" RENAME COLUMN "requestedById" TO "requested_by_id";--> statement-breakpoint |
| 108 | ALTER TABLE "repository_transfer" RENAME COLUMN "createdAt" TO "created_at";--> statement-breakpoint |
| 109 | ALTER TABLE "team_maintainer" RENAME COLUMN "teamId" TO "team_id";--> statement-breakpoint |
| 110 | ALTER TABLE "team_maintainer" RENAME COLUMN "userId" TO "user_id";--> statement-breakpoint |
| 111 | ALTER TABLE "release" RENAME COLUMN "repositoryId" TO "repository_id";--> statement-breakpoint |
| 112 | ALTER TABLE "release" RENAME COLUMN "tagName" TO "tag_name";--> statement-breakpoint |
| 113 | ALTER TABLE "release" RENAME COLUMN "isDraft" TO "is_draft";--> statement-breakpoint |
| 114 | ALTER TABLE "release" RENAME COLUMN "isPrerelease" TO "is_prerelease";--> statement-breakpoint |
| 115 | ALTER TABLE "release" RENAME COLUMN "authorId" TO "author_id";--> statement-breakpoint |
| 116 | ALTER TABLE "release" RENAME COLUMN "publishedAt" TO "published_at";--> statement-breakpoint |
| 117 | ALTER TABLE "release" RENAME COLUMN "createdAt" TO "created_at";--> statement-breakpoint |
| 118 | ALTER TABLE "release" RENAME COLUMN "updatedAt" TO "updated_at";--> statement-breakpoint |
| 119 | ALTER TABLE "release_asset" RENAME COLUMN "releaseId" TO "release_id";--> statement-breakpoint |
| 120 | ALTER TABLE "release_asset" RENAME COLUMN "repositoryId" TO "repository_id";--> statement-breakpoint |
| 121 | ALTER TABLE "release_asset" RENAME COLUMN "contentType" TO "content_type";--> statement-breakpoint |
| 122 | ALTER TABLE "release_asset" RENAME COLUMN "downloadCount" TO "download_count";--> statement-breakpoint |
| 123 | ALTER TABLE "release_asset" RENAME COLUMN "uploaderId" TO "uploader_id";--> statement-breakpoint |
| 124 | ALTER TABLE "release_asset" RENAME COLUMN "createdAt" TO "created_at";--> statement-breakpoint |
| 125 | ALTER TABLE "pull_request" DROP CONSTRAINT "pull_request_issueId_unique";--> statement-breakpoint |
| 126 | ALTER TABLE "repository" DROP CONSTRAINT "repository_organizationId_organization_id_fk"; |
| 127 | --> statement-breakpoint |
| 128 | ALTER TABLE "repository" DROP CONSTRAINT "repository_ownerId_user_id_fk"; |
| 129 | --> statement-breakpoint |
| 130 | ALTER TABLE "repository" DROP CONSTRAINT "repository_parentRepositoryId_repository_id_fk"; |
| 131 | --> statement-breakpoint |
| 132 | ALTER TABLE "repository_language_index" DROP CONSTRAINT "repository_language_index_repositoryId_repository_id_fk"; |
| 133 | --> statement-breakpoint |
| 134 | ALTER TABLE "repository_language_stat" DROP CONSTRAINT "repository_language_stat_repositoryId_repository_id_fk"; |
| 135 | --> statement-breakpoint |
| 136 | ALTER TABLE "repository_path_commit" DROP CONSTRAINT "repository_path_commit_repositoryId_repository_id_fk"; |
| 137 | --> statement-breakpoint |
| 138 | ALTER TABLE "repository_ref_index" DROP CONSTRAINT "repository_ref_index_repositoryId_repository_id_fk"; |
| 139 | --> statement-breakpoint |
| 140 | ALTER TABLE "stars" DROP CONSTRAINT "stars_userId_user_id_fk"; |
| 141 | --> statement-breakpoint |
| 142 | ALTER TABLE "stars" DROP CONSTRAINT "stars_repositoryId_repository_id_fk"; |
| 143 | --> statement-breakpoint |
| 144 | ALTER TABLE "pull_request" DROP CONSTRAINT "pull_request_issueId_issue_id_fk"; |
| 145 | --> statement-breakpoint |
| 146 | ALTER TABLE "pull_request" DROP CONSTRAINT "pull_request_baseRepositoryId_repository_id_fk"; |
| 147 | --> statement-breakpoint |
| 148 | ALTER TABLE "pull_request" DROP CONSTRAINT "pull_request_headRepositoryId_repository_id_fk"; |
| 149 | --> statement-breakpoint |
| 150 | ALTER TABLE "pull_request_review" DROP CONSTRAINT "pull_request_review_pullRequestId_pull_request_id_fk"; |
| 151 | --> statement-breakpoint |
| 152 | ALTER TABLE "pull_request_review" DROP CONSTRAINT "pull_request_review_authorId_user_id_fk"; |
| 153 | --> statement-breakpoint |
| 154 | ALTER TABLE "pull_request_review" DROP CONSTRAINT "pull_request_review_dismissedById_user_id_fk"; |
| 155 | --> statement-breakpoint |
| 156 | ALTER TABLE "pull_request_review_comment" DROP CONSTRAINT "pull_request_review_comment_pullRequestId_pull_request_id_fk"; |
| 157 | --> statement-breakpoint |
| 158 | ALTER TABLE "pull_request_review_comment" DROP CONSTRAINT "pull_request_review_comment_reviewId_pull_request_review_id_fk"; |
| 159 | --> statement-breakpoint |
| 160 | ALTER TABLE "pull_request_review_comment" DROP CONSTRAINT "pull_request_review_comment_inReplyToId_pull_request_review_comment_id_fk"; |
| 161 | --> statement-breakpoint |
| 162 | ALTER TABLE "pull_request_review_comment" DROP CONSTRAINT "pull_request_review_comment_authorId_user_id_fk"; |
| 163 | --> statement-breakpoint |
| 164 | ALTER TABLE "issue" DROP CONSTRAINT "issue_repositoryId_repository_id_fk"; |
| 165 | --> statement-breakpoint |
| 166 | ALTER TABLE "issue" DROP CONSTRAINT "issue_authorId_user_id_fk"; |
| 167 | --> statement-breakpoint |
| 168 | ALTER TABLE "issue" DROP CONSTRAINT "issue_closedById_user_id_fk"; |
| 169 | --> statement-breakpoint |
| 170 | ALTER TABLE "issue_assignee" DROP CONSTRAINT "issue_assignee_issueId_issue_id_fk"; |
| 171 | --> statement-breakpoint |
| 172 | ALTER TABLE "issue_assignee" DROP CONSTRAINT "issue_assignee_userId_user_id_fk"; |
| 173 | --> statement-breakpoint |
| 174 | ALTER TABLE "issue_comment" DROP CONSTRAINT "issue_comment_issueId_issue_id_fk"; |
| 175 | --> statement-breakpoint |
| 176 | ALTER TABLE "issue_comment" DROP CONSTRAINT "issue_comment_authorId_user_id_fk"; |
| 177 | --> statement-breakpoint |
| 178 | ALTER TABLE "issue_event" DROP CONSTRAINT "issue_event_issueId_issue_id_fk"; |
| 179 | --> statement-breakpoint |
| 180 | ALTER TABLE "issue_event" DROP CONSTRAINT "issue_event_actorId_user_id_fk"; |
| 181 | --> statement-breakpoint |
| 182 | ALTER TABLE "issue_event" DROP CONSTRAINT "issue_event_sourceIssueId_issue_id_fk"; |
| 183 | --> statement-breakpoint |
| 184 | ALTER TABLE "issue_label" DROP CONSTRAINT "issue_label_issueId_issue_id_fk"; |
| 185 | --> statement-breakpoint |
| 186 | ALTER TABLE "issue_label" DROP CONSTRAINT "issue_label_labelId_label_id_fk"; |
| 187 | --> statement-breakpoint |
| 188 | ALTER TABLE "issue_reference" DROP CONSTRAINT "issue_reference_sourceRepositoryId_repository_id_fk"; |
| 189 | --> statement-breakpoint |
| 190 | ALTER TABLE "issue_reference" DROP CONSTRAINT "issue_reference_sourceIssueId_issue_id_fk"; |
| 191 | --> statement-breakpoint |
| 192 | ALTER TABLE "issue_reference" DROP CONSTRAINT "issue_reference_targetIssueId_issue_id_fk"; |
| 193 | --> statement-breakpoint |
| 194 | ALTER TABLE "issue_reference" DROP CONSTRAINT "issue_reference_actorId_user_id_fk"; |
| 195 | --> statement-breakpoint |
| 196 | ALTER TABLE "label" DROP CONSTRAINT "label_repositoryId_repository_id_fk"; |
| 197 | --> statement-breakpoint |
| 198 | ALTER TABLE "repository_collaborator" DROP CONSTRAINT "repository_collaborator_repositoryId_repository_id_fk"; |
| 199 | --> statement-breakpoint |
| 200 | ALTER TABLE "repository_collaborator" DROP CONSTRAINT "repository_collaborator_userId_user_id_fk"; |
| 201 | --> statement-breakpoint |
| 202 | ALTER TABLE "repository_collaborator" DROP CONSTRAINT "repository_collaborator_invitedById_user_id_fk"; |
| 203 | --> statement-breakpoint |
| 204 | ALTER TABLE "repository_team" DROP CONSTRAINT "repository_team_repositoryId_repository_id_fk"; |
| 205 | --> statement-breakpoint |
| 206 | ALTER TABLE "repository_team" DROP CONSTRAINT "repository_team_teamId_team_id_fk"; |
| 207 | --> statement-breakpoint |
| 208 | ALTER TABLE "organization_pinned_repository" DROP CONSTRAINT "organization_pinned_repository_organizationId_organization_id_fk"; |
| 209 | --> statement-breakpoint |
| 210 | ALTER TABLE "organization_pinned_repository" DROP CONSTRAINT "organization_pinned_repository_repositoryId_repository_id_fk"; |
| 211 | --> statement-breakpoint |
| 212 | ALTER TABLE "organization_public_member" DROP CONSTRAINT "organization_public_member_organizationId_organization_id_fk"; |
| 213 | --> statement-breakpoint |
| 214 | ALTER TABLE "organization_public_member" DROP CONSTRAINT "organization_public_member_userId_user_id_fk"; |
| 215 | --> statement-breakpoint |
| 216 | ALTER TABLE "organization_settings" DROP CONSTRAINT "organization_settings_organizationId_organization_id_fk"; |
| 217 | --> statement-breakpoint |
| 218 | ALTER TABLE "repository_redirect" DROP CONSTRAINT "repository_redirect_repositoryId_repository_id_fk"; |
| 219 | --> statement-breakpoint |
| 220 | ALTER TABLE "repository_transfer" DROP CONSTRAINT "repository_transfer_repositoryId_repository_id_fk"; |
| 221 | --> statement-breakpoint |
| 222 | ALTER TABLE "repository_transfer" DROP CONSTRAINT "repository_transfer_toUserId_user_id_fk"; |
| 223 | --> statement-breakpoint |
| 224 | ALTER TABLE "repository_transfer" DROP CONSTRAINT "repository_transfer_toOrganizationId_organization_id_fk"; |
| 225 | --> statement-breakpoint |
| 226 | ALTER TABLE "repository_transfer" DROP CONSTRAINT "repository_transfer_requestedById_user_id_fk"; |
| 227 | --> statement-breakpoint |
| 228 | ALTER TABLE "team_maintainer" DROP CONSTRAINT "team_maintainer_teamId_team_id_fk"; |
| 229 | --> statement-breakpoint |
| 230 | ALTER TABLE "team_maintainer" DROP CONSTRAINT "team_maintainer_userId_user_id_fk"; |
| 231 | --> statement-breakpoint |
| 232 | ALTER TABLE "release" DROP CONSTRAINT "release_repositoryId_repository_id_fk"; |
| 233 | --> statement-breakpoint |
| 234 | ALTER TABLE "release" DROP CONSTRAINT "release_authorId_user_id_fk"; |
| 235 | --> statement-breakpoint |
| 236 | ALTER TABLE "release_asset" DROP CONSTRAINT "release_asset_releaseId_release_id_fk"; |
| 237 | --> statement-breakpoint |
| 238 | ALTER TABLE "release_asset" DROP CONSTRAINT "release_asset_repositoryId_repository_id_fk"; |
| 239 | --> statement-breakpoint |
| 240 | ALTER TABLE "release_asset" DROP CONSTRAINT "release_asset_uploaderId_user_id_fk"; |
| 241 | --> statement-breakpoint |
| 242 | DROP INDEX "stars_userId_repositoryId_index";--> statement-breakpoint |
| 243 | DROP INDEX "repository_org_slug_idx";--> statement-breakpoint |
| 244 | DROP INDEX "repository_owner_slug_idx";--> statement-breakpoint |
| 245 | DROP INDEX "pull_request_open_branch_idx";--> statement-breakpoint |
| 246 | DROP INDEX "pull_request_head_idx";--> statement-breakpoint |
| 247 | DROP INDEX "pull_request_base_state_idx";--> statement-breakpoint |
| 248 | DROP INDEX "pull_request_review_pull_idx";--> statement-breakpoint |
| 249 | DROP INDEX "pull_request_review_pending_idx";--> statement-breakpoint |
| 250 | DROP INDEX "pull_request_review_comment_review_idx";--> statement-breakpoint |
| 251 | DROP INDEX "pull_request_review_comment_reply_idx";--> statement-breakpoint |
| 252 | DROP INDEX "pull_request_review_comment_pull_idx";--> statement-breakpoint |
| 253 | DROP INDEX "issue_repo_number_idx";--> statement-breakpoint |
| 254 | DROP INDEX "issue_repo_kind_state_idx";--> statement-breakpoint |
| 255 | DROP INDEX "issue_repo_updated_idx";--> statement-breakpoint |
| 256 | DROP INDEX "issue_comment_issue_idx";--> statement-breakpoint |
| 257 | DROP INDEX "issue_event_issue_idx";--> statement-breakpoint |
| 258 | DROP INDEX "issue_reference_source_target_idx";--> statement-breakpoint |
| 259 | DROP INDEX "issue_reference_target_idx";--> statement-breakpoint |
| 260 | DROP INDEX "issue_reference_source_issue_idx";--> statement-breakpoint |
| 261 | DROP INDEX "label_repo_name_idx";--> statement-breakpoint |
| 262 | DROP INDEX "label_repo_idx";--> statement-breakpoint |
| 263 | DROP INDEX "repository_collaborator_repository_user_idx";--> statement-breakpoint |
| 264 | DROP INDEX "repository_collaborator_user_idx";--> statement-breakpoint |
| 265 | DROP INDEX "repository_team_team_idx";--> statement-breakpoint |
| 266 | DROP INDEX "repository_redirect_name_idx";--> statement-breakpoint |
| 267 | DROP INDEX "repository_redirect_repository_idx";--> statement-breakpoint |
| 268 | DROP INDEX "release_repository_tag_idx";--> statement-breakpoint |
| 269 | DROP INDEX "release_repository_created_idx";--> statement-breakpoint |
| 270 | DROP INDEX "release_asset_release_name_idx";--> statement-breakpoint |
| 271 | DROP INDEX "release_asset_repository_idx";--> statement-breakpoint |
| 272 | ALTER TABLE "repository_language_index" DROP CONSTRAINT "repository_language_index_repositoryId_ref_pk";--> statement-breakpoint |
| 273 | ALTER TABLE "repository_language_stat" DROP CONSTRAINT "repository_language_stat_repositoryId_ref_language_pk";--> statement-breakpoint |
| 274 | ALTER TABLE "repository_path_commit" DROP CONSTRAINT "repository_path_commit_repositoryId_ref_path_pk";--> statement-breakpoint |
| 275 | ALTER TABLE "repository_ref_index" DROP CONSTRAINT "repository_ref_index_repositoryId_ref_pk";--> statement-breakpoint |
| 276 | ALTER TABLE "issue_assignee" DROP CONSTRAINT "issue_assignee_issueId_userId_pk";--> statement-breakpoint |
| 277 | ALTER TABLE "issue_label" DROP CONSTRAINT "issue_label_issueId_labelId_pk";--> statement-breakpoint |
| 278 | ALTER TABLE "repository_team" DROP CONSTRAINT "repository_team_repositoryId_teamId_pk";--> statement-breakpoint |
| 279 | ALTER TABLE "organization_pinned_repository" DROP CONSTRAINT "organization_pinned_repository_organizationId_repositoryId_pk";--> statement-breakpoint |
| 280 | ALTER TABLE "organization_public_member" DROP CONSTRAINT "organization_public_member_organizationId_userId_pk";--> statement-breakpoint |
| 281 | ALTER TABLE "team_maintainer" DROP CONSTRAINT "team_maintainer_teamId_userId_pk";--> statement-breakpoint |
| 282 | ALTER TABLE "repository_language_index" ADD CONSTRAINT "repository_language_index_repository_id_ref_pk" PRIMARY KEY("repository_id","ref");--> statement-breakpoint |
| 283 | ALTER TABLE "repository_language_stat" ADD CONSTRAINT "repository_language_stat_repository_id_ref_language_pk" PRIMARY KEY("repository_id","ref","language");--> statement-breakpoint |
| 284 | ALTER TABLE "repository_path_commit" ADD CONSTRAINT "repository_path_commit_repository_id_ref_path_pk" PRIMARY KEY("repository_id","ref","path");--> statement-breakpoint |
| 285 | ALTER TABLE "repository_ref_index" ADD CONSTRAINT "repository_ref_index_repository_id_ref_pk" PRIMARY KEY("repository_id","ref");--> statement-breakpoint |
| 286 | ALTER TABLE "issue_assignee" ADD CONSTRAINT "issue_assignee_issue_id_user_id_pk" PRIMARY KEY("issue_id","user_id");--> statement-breakpoint |
| 287 | ALTER TABLE "issue_label" ADD CONSTRAINT "issue_label_issue_id_label_id_pk" PRIMARY KEY("issue_id","label_id");--> statement-breakpoint |
| 288 | ALTER TABLE "repository_team" ADD CONSTRAINT "repository_team_repository_id_team_id_pk" PRIMARY KEY("repository_id","team_id");--> statement-breakpoint |
| 289 | ALTER TABLE "organization_pinned_repository" ADD CONSTRAINT "organization_pinned_repository_organization_id_repository_id_pk" PRIMARY KEY("organization_id","repository_id");--> statement-breakpoint |
| 290 | ALTER TABLE "organization_public_member" ADD CONSTRAINT "organization_public_member_organization_id_user_id_pk" PRIMARY KEY("organization_id","user_id");--> statement-breakpoint |
| 291 | ALTER TABLE "team_maintainer" ADD CONSTRAINT "team_maintainer_team_id_user_id_pk" PRIMARY KEY("team_id","user_id");--> statement-breakpoint |
| 292 | ALTER TABLE "repository" ADD CONSTRAINT "repository_organization_id_organization_id_fk" FOREIGN KEY ("organization_id") REFERENCES "public"."organization"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 293 | ALTER TABLE "repository" ADD CONSTRAINT "repository_owner_id_user_id_fk" FOREIGN KEY ("owner_id") REFERENCES "public"."user"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 294 | ALTER TABLE "repository" ADD CONSTRAINT "repository_parent_repository_id_repository_id_fk" FOREIGN KEY ("parent_repository_id") REFERENCES "public"."repository"("id") ON DELETE set null ON UPDATE no action;--> statement-breakpoint |
| 295 | ALTER TABLE "repository_language_index" ADD CONSTRAINT "repository_language_index_repository_id_repository_id_fk" FOREIGN KEY ("repository_id") REFERENCES "public"."repository"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 296 | ALTER TABLE "repository_language_stat" ADD CONSTRAINT "repository_language_stat_repository_id_repository_id_fk" FOREIGN KEY ("repository_id") REFERENCES "public"."repository"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 297 | ALTER TABLE "repository_path_commit" ADD CONSTRAINT "repository_path_commit_repository_id_repository_id_fk" FOREIGN KEY ("repository_id") REFERENCES "public"."repository"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 298 | ALTER TABLE "repository_ref_index" ADD CONSTRAINT "repository_ref_index_repository_id_repository_id_fk" FOREIGN KEY ("repository_id") REFERENCES "public"."repository"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 299 | ALTER TABLE "stars" ADD CONSTRAINT "stars_user_id_user_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."user"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 300 | ALTER TABLE "stars" ADD CONSTRAINT "stars_repository_id_repository_id_fk" FOREIGN KEY ("repository_id") REFERENCES "public"."repository"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 301 | ALTER TABLE "pull_request" ADD CONSTRAINT "pull_request_issue_id_issue_id_fk" FOREIGN KEY ("issue_id") REFERENCES "public"."issue"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 302 | ALTER TABLE "pull_request" ADD CONSTRAINT "pull_request_base_repository_id_repository_id_fk" FOREIGN KEY ("base_repository_id") REFERENCES "public"."repository"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 303 | ALTER TABLE "pull_request" ADD CONSTRAINT "pull_request_head_repository_id_repository_id_fk" FOREIGN KEY ("head_repository_id") REFERENCES "public"."repository"("id") ON DELETE set null ON UPDATE no action;--> statement-breakpoint |
| 304 | ALTER TABLE "pull_request_review" ADD CONSTRAINT "pull_request_review_pull_request_id_pull_request_id_fk" FOREIGN KEY ("pull_request_id") REFERENCES "public"."pull_request"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 305 | ALTER TABLE "pull_request_review" ADD CONSTRAINT "pull_request_review_author_id_user_id_fk" FOREIGN KEY ("author_id") REFERENCES "public"."user"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 306 | ALTER TABLE "pull_request_review" ADD CONSTRAINT "pull_request_review_dismissed_by_id_user_id_fk" FOREIGN KEY ("dismissed_by_id") REFERENCES "public"."user"("id") ON DELETE set null ON UPDATE no action;--> statement-breakpoint |
| 307 | ALTER TABLE "pull_request_review_comment" ADD CONSTRAINT "pull_request_review_comment_pull_request_id_pull_request_id_fk" FOREIGN KEY ("pull_request_id") REFERENCES "public"."pull_request"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 308 | ALTER TABLE "pull_request_review_comment" ADD CONSTRAINT "pull_request_review_comment_review_id_pull_request_review_id_fk" FOREIGN KEY ("review_id") REFERENCES "public"."pull_request_review"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 309 | ALTER TABLE "pull_request_review_comment" ADD CONSTRAINT "pull_request_review_comment_in_reply_to_id_pull_request_review_comment_id_fk" FOREIGN KEY ("in_reply_to_id") REFERENCES "public"."pull_request_review_comment"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 310 | ALTER TABLE "pull_request_review_comment" ADD CONSTRAINT "pull_request_review_comment_author_id_user_id_fk" FOREIGN KEY ("author_id") REFERENCES "public"."user"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 311 | ALTER TABLE "issue" ADD CONSTRAINT "issue_repository_id_repository_id_fk" FOREIGN KEY ("repository_id") REFERENCES "public"."repository"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 312 | ALTER TABLE "issue" ADD CONSTRAINT "issue_author_id_user_id_fk" FOREIGN KEY ("author_id") REFERENCES "public"."user"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 313 | ALTER TABLE "issue" ADD CONSTRAINT "issue_closed_by_id_user_id_fk" FOREIGN KEY ("closed_by_id") REFERENCES "public"."user"("id") ON DELETE set null ON UPDATE no action;--> statement-breakpoint |
| 314 | ALTER TABLE "issue_assignee" ADD CONSTRAINT "issue_assignee_issue_id_issue_id_fk" FOREIGN KEY ("issue_id") REFERENCES "public"."issue"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 315 | ALTER TABLE "issue_assignee" ADD CONSTRAINT "issue_assignee_user_id_user_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."user"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 316 | ALTER TABLE "issue_comment" ADD CONSTRAINT "issue_comment_issue_id_issue_id_fk" FOREIGN KEY ("issue_id") REFERENCES "public"."issue"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 317 | ALTER TABLE "issue_comment" ADD CONSTRAINT "issue_comment_author_id_user_id_fk" FOREIGN KEY ("author_id") REFERENCES "public"."user"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 318 | ALTER TABLE "issue_event" ADD CONSTRAINT "issue_event_issue_id_issue_id_fk" FOREIGN KEY ("issue_id") REFERENCES "public"."issue"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 319 | ALTER TABLE "issue_event" ADD CONSTRAINT "issue_event_actor_id_user_id_fk" FOREIGN KEY ("actor_id") REFERENCES "public"."user"("id") ON DELETE set null ON UPDATE no action;--> statement-breakpoint |
| 320 | ALTER TABLE "issue_event" ADD CONSTRAINT "issue_event_source_issue_id_issue_id_fk" FOREIGN KEY ("source_issue_id") REFERENCES "public"."issue"("id") ON DELETE set null ON UPDATE no action;--> statement-breakpoint |
| 321 | ALTER TABLE "issue_label" ADD CONSTRAINT "issue_label_issue_id_issue_id_fk" FOREIGN KEY ("issue_id") REFERENCES "public"."issue"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 322 | ALTER TABLE "issue_label" ADD CONSTRAINT "issue_label_label_id_label_id_fk" FOREIGN KEY ("label_id") REFERENCES "public"."label"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 323 | ALTER TABLE "issue_reference" ADD CONSTRAINT "issue_reference_source_repository_id_repository_id_fk" FOREIGN KEY ("source_repository_id") REFERENCES "public"."repository"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 324 | ALTER TABLE "issue_reference" ADD CONSTRAINT "issue_reference_source_issue_id_issue_id_fk" FOREIGN KEY ("source_issue_id") REFERENCES "public"."issue"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 325 | ALTER TABLE "issue_reference" ADD CONSTRAINT "issue_reference_target_issue_id_issue_id_fk" FOREIGN KEY ("target_issue_id") REFERENCES "public"."issue"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 326 | ALTER TABLE "issue_reference" ADD CONSTRAINT "issue_reference_actor_id_user_id_fk" FOREIGN KEY ("actor_id") REFERENCES "public"."user"("id") ON DELETE set null ON UPDATE no action;--> statement-breakpoint |
| 327 | ALTER TABLE "label" ADD CONSTRAINT "label_repository_id_repository_id_fk" FOREIGN KEY ("repository_id") REFERENCES "public"."repository"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 328 | ALTER TABLE "repository_collaborator" ADD CONSTRAINT "repository_collaborator_repository_id_repository_id_fk" FOREIGN KEY ("repository_id") REFERENCES "public"."repository"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 329 | ALTER TABLE "repository_collaborator" ADD CONSTRAINT "repository_collaborator_user_id_user_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."user"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 330 | ALTER TABLE "repository_collaborator" ADD CONSTRAINT "repository_collaborator_invited_by_id_user_id_fk" FOREIGN KEY ("invited_by_id") REFERENCES "public"."user"("id") ON DELETE set null ON UPDATE no action;--> statement-breakpoint |
| 331 | ALTER TABLE "repository_team" ADD CONSTRAINT "repository_team_repository_id_repository_id_fk" FOREIGN KEY ("repository_id") REFERENCES "public"."repository"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 332 | ALTER TABLE "repository_team" ADD CONSTRAINT "repository_team_team_id_team_id_fk" FOREIGN KEY ("team_id") REFERENCES "public"."team"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 333 | ALTER TABLE "organization_pinned_repository" ADD CONSTRAINT "organization_pinned_repository_organization_id_organization_id_fk" FOREIGN KEY ("organization_id") REFERENCES "public"."organization"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 334 | ALTER TABLE "organization_pinned_repository" ADD CONSTRAINT "organization_pinned_repository_repository_id_repository_id_fk" FOREIGN KEY ("repository_id") REFERENCES "public"."repository"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 335 | ALTER TABLE "organization_public_member" ADD CONSTRAINT "organization_public_member_organization_id_organization_id_fk" FOREIGN KEY ("organization_id") REFERENCES "public"."organization"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 336 | ALTER TABLE "organization_public_member" ADD CONSTRAINT "organization_public_member_user_id_user_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."user"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 337 | ALTER TABLE "organization_settings" ADD CONSTRAINT "organization_settings_organization_id_organization_id_fk" FOREIGN KEY ("organization_id") REFERENCES "public"."organization"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 338 | ALTER TABLE "repository_redirect" ADD CONSTRAINT "repository_redirect_repository_id_repository_id_fk" FOREIGN KEY ("repository_id") REFERENCES "public"."repository"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 339 | ALTER TABLE "repository_transfer" ADD CONSTRAINT "repository_transfer_repository_id_repository_id_fk" FOREIGN KEY ("repository_id") REFERENCES "public"."repository"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 340 | ALTER TABLE "repository_transfer" ADD CONSTRAINT "repository_transfer_to_user_id_user_id_fk" FOREIGN KEY ("to_user_id") REFERENCES "public"."user"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 341 | ALTER TABLE "repository_transfer" ADD CONSTRAINT "repository_transfer_to_organization_id_organization_id_fk" FOREIGN KEY ("to_organization_id") REFERENCES "public"."organization"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 342 | ALTER TABLE "repository_transfer" ADD CONSTRAINT "repository_transfer_requested_by_id_user_id_fk" FOREIGN KEY ("requested_by_id") REFERENCES "public"."user"("id") ON DELETE set null ON UPDATE no action;--> statement-breakpoint |
| 343 | ALTER TABLE "team_maintainer" ADD CONSTRAINT "team_maintainer_team_id_team_id_fk" FOREIGN KEY ("team_id") REFERENCES "public"."team"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 344 | ALTER TABLE "team_maintainer" ADD CONSTRAINT "team_maintainer_user_id_user_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."user"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 345 | ALTER TABLE "release" ADD CONSTRAINT "release_repository_id_repository_id_fk" FOREIGN KEY ("repository_id") REFERENCES "public"."repository"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 346 | ALTER TABLE "release" ADD CONSTRAINT "release_author_id_user_id_fk" FOREIGN KEY ("author_id") REFERENCES "public"."user"("id") ON DELETE set null ON UPDATE no action;--> statement-breakpoint |
| 347 | ALTER TABLE "release_asset" ADD CONSTRAINT "release_asset_release_id_release_id_fk" FOREIGN KEY ("release_id") REFERENCES "public"."release"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 348 | ALTER TABLE "release_asset" ADD CONSTRAINT "release_asset_repository_id_repository_id_fk" FOREIGN KEY ("repository_id") REFERENCES "public"."repository"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint |
| 349 | ALTER TABLE "release_asset" ADD CONSTRAINT "release_asset_uploader_id_user_id_fk" FOREIGN KEY ("uploader_id") REFERENCES "public"."user"("id") ON DELETE set null ON UPDATE no action;--> statement-breakpoint |
| 350 | CREATE UNIQUE INDEX "stars_user_id_repository_id_index" ON "stars" USING btree ("user_id","repository_id");--> statement-breakpoint |
| 351 | CREATE UNIQUE INDEX "repository_org_slug_idx" ON "repository" USING btree ("organization_id","slug") WHERE "repository"."organization_id" is not null;--> statement-breakpoint |
| 352 | CREATE UNIQUE INDEX "repository_owner_slug_idx" ON "repository" USING btree ("owner_id","slug") WHERE "repository"."organization_id" is null;--> statement-breakpoint |
| 353 | CREATE UNIQUE INDEX "pull_request_open_branch_idx" ON "pull_request" USING btree ("base_repository_id","base_ref","head_repository_id","head_ref") WHERE "pull_request"."state" = 'open';--> statement-breakpoint |
| 354 | CREATE INDEX "pull_request_head_idx" ON "pull_request" USING btree ("head_repository_id");--> statement-breakpoint |
| 355 | CREATE INDEX "pull_request_base_state_idx" ON "pull_request" USING btree ("base_repository_id","state");--> statement-breakpoint |
| 356 | CREATE INDEX "pull_request_review_pull_idx" ON "pull_request_review" USING btree ("pull_request_id","created_at");--> statement-breakpoint |
| 357 | CREATE UNIQUE INDEX "pull_request_review_pending_idx" ON "pull_request_review" USING btree ("pull_request_id","author_id") WHERE "pull_request_review"."submitted_at" is null;--> statement-breakpoint |
| 358 | CREATE INDEX "pull_request_review_comment_review_idx" ON "pull_request_review_comment" USING btree ("review_id");--> statement-breakpoint |
| 359 | CREATE INDEX "pull_request_review_comment_reply_idx" ON "pull_request_review_comment" USING btree ("in_reply_to_id");--> statement-breakpoint |
| 360 | CREATE INDEX "pull_request_review_comment_pull_idx" ON "pull_request_review_comment" USING btree ("pull_request_id");--> statement-breakpoint |
| 361 | CREATE UNIQUE INDEX "issue_repo_number_idx" ON "issue" USING btree ("repository_id","number");--> statement-breakpoint |
| 362 | CREATE INDEX "issue_repo_kind_state_idx" ON "issue" USING btree ("repository_id","is_pull_request","state");--> statement-breakpoint |
| 363 | CREATE INDEX "issue_repo_updated_idx" ON "issue" USING btree ("repository_id","updated_at");--> statement-breakpoint |
| 364 | CREATE INDEX "issue_comment_issue_idx" ON "issue_comment" USING btree ("issue_id","created_at");--> statement-breakpoint |
| 365 | CREATE INDEX "issue_event_issue_idx" ON "issue_event" USING btree ("issue_id","created_at");--> statement-breakpoint |
| 366 | CREATE UNIQUE INDEX "issue_reference_source_target_idx" ON "issue_reference" USING btree ("source_type","source_id","target_issue_id");--> statement-breakpoint |
| 367 | CREATE INDEX "issue_reference_target_idx" ON "issue_reference" USING btree ("target_issue_id","created_at");--> statement-breakpoint |
| 368 | CREATE INDEX "issue_reference_source_issue_idx" ON "issue_reference" USING btree ("source_issue_id");--> statement-breakpoint |
| 369 | CREATE UNIQUE INDEX "label_repo_name_idx" ON "label" USING btree ("repository_id","name");--> statement-breakpoint |
| 370 | CREATE INDEX "label_repo_idx" ON "label" USING btree ("repository_id");--> statement-breakpoint |
| 371 | CREATE UNIQUE INDEX "repository_collaborator_repository_user_idx" ON "repository_collaborator" USING btree ("repository_id","user_id");--> statement-breakpoint |
| 372 | CREATE INDEX "repository_collaborator_user_idx" ON "repository_collaborator" USING btree ("user_id");--> statement-breakpoint |
| 373 | CREATE INDEX "repository_team_team_idx" ON "repository_team" USING btree ("team_id");--> statement-breakpoint |
| 374 | CREATE UNIQUE INDEX "repository_redirect_name_idx" ON "repository_redirect" USING btree (lower("owner_name"),"slug");--> statement-breakpoint |
| 375 | CREATE INDEX "repository_redirect_repository_idx" ON "repository_redirect" USING btree ("repository_id");--> statement-breakpoint |
| 376 | CREATE UNIQUE INDEX "release_repository_tag_idx" ON "release" USING btree ("repository_id","tag_name");--> statement-breakpoint |
| 377 | CREATE INDEX "release_repository_created_idx" ON "release" USING btree ("repository_id","created_at");--> statement-breakpoint |
| 378 | CREATE UNIQUE INDEX "release_asset_release_name_idx" ON "release_asset" USING btree ("release_id","name");--> statement-breakpoint |
| 379 | CREATE INDEX "release_asset_repository_idx" ON "release_asset" USING btree ("repository_id");--> statement-breakpoint |
| 380 | ALTER TABLE "pull_request" ADD CONSTRAINT "pull_request_issueId_unique" UNIQUE("issue_id"); |