SQL

CREATE TABLE `pull_request`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `type` INTEGER NULL,
  `status` INTEGER NULL,
  `conflicted_files` TEXT NULL,
  `commits_ahead` INTEGER NULL,
  `commits_behind` INTEGER NULL,
  `changed_protected_files` TEXT NULL,
  `issue_id` INTEGER NULL,
  `index` INTEGER NULL,
  `head_repo_id` INTEGER NULL,
  `base_repo_id` INTEGER NULL,
  `head_branch` TEXT NULL,
  `base_branch` TEXT NULL,
  `merge_base` TEXT NULL,
  `allow_maintainer_edit` INTEGER DEFAULT 0 NOT NULL,
  `has_merged` INTEGER NULL,
  `merged_commit_id` TEXT NULL,
  `merger_id` INTEGER NULL,
  `merged_unix` INTEGER NULL,
  `flow` INTEGER DEFAULT 0 NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
type INTEGER ✓ Rename | Drop
status INTEGER ✓ Rename | Drop
conflicted_files TEXT ✓ Rename | Drop
commits_ahead INTEGER ✓ Rename | Drop
commits_behind INTEGER ✓ Rename | Drop
changed_protected_files TEXT ✓ Rename | Drop
issue_id INTEGER ✓ Rename | Drop
index INTEGER ✓ Rename | Drop
head_repo_id INTEGER ✓ Rename | Drop
base_repo_id INTEGER ✓ Rename | Drop
head_branch TEXT ✓ Rename | Drop
base_branch TEXT ✓ Rename | Drop
merge_base TEXT ✓ Rename | Drop
allow_maintainer_edit INTEGER Rename | Drop
has_merged INTEGER ✓ Rename | Drop
merged_commit_id TEXT ✓ Rename | Drop
merger_id INTEGER ✓ Rename | Drop
merged_unix INTEGER ✓ Rename | Drop
flow INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_pull_request_base_repo_id base_repo_id SQL 
CREATE INDEX `IDX_pull_request_base_repo_id`
ON `pull_request` (`base_repo_id`)
Drop
IDX_pull_request_has_merged has_merged SQL 
CREATE INDEX `IDX_pull_request_has_merged`
ON `pull_request` (`has_merged`)
Drop
IDX_pull_request_head_repo_id head_repo_id SQL 
CREATE INDEX `IDX_pull_request_head_repo_id`
ON `pull_request` (`head_repo_id`)
Drop
IDX_pull_request_issue_id issue_id SQL 
CREATE INDEX `IDX_pull_request_issue_id`
ON `pull_request` (`issue_id`)
Drop
IDX_pull_request_merged_unix merged_unix SQL 
CREATE INDEX `IDX_pull_request_merged_unix`
ON `pull_request` (`merged_unix`)
Drop
IDX_pull_request_merger_id merger_id SQL 
CREATE INDEX `IDX_pull_request_merger_id`
ON `pull_request` (`merger_id`)
Drop