SQL

CREATE TABLE `protected_branch`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `repo_id` INTEGER NULL,
  `branch_name` TEXT NULL,
  `can_push` INTEGER DEFAULT 0 NOT NULL,
  `enable_whitelist` INTEGER NULL,
  `whitelist_user_i_ds` TEXT NULL,
  `whitelist_team_i_ds` TEXT NULL,
  `enable_merge_whitelist` INTEGER DEFAULT 0 NOT NULL,
  `whitelist_deploy_keys` INTEGER DEFAULT 0 NOT NULL,
  `merge_whitelist_user_i_ds` TEXT NULL,
  `merge_whitelist_team_i_ds` TEXT NULL,
  `enable_status_check` INTEGER DEFAULT 0 NOT NULL,
  `status_check_contexts` TEXT NULL,
  `enable_approvals_whitelist` INTEGER DEFAULT 0 NOT NULL,
  `approvals_whitelist_user_i_ds` TEXT NULL,
  `approvals_whitelist_team_i_ds` TEXT NULL,
  `required_approvals` INTEGER DEFAULT 0 NOT NULL,
  `block_on_rejected_reviews` INTEGER DEFAULT 0 NOT NULL,
  `block_on_official_review_requests` INTEGER DEFAULT 0 NOT NULL,
  `block_on_outdated_branch` INTEGER DEFAULT 0 NOT NULL,
  `dismiss_stale_approvals` INTEGER DEFAULT 0 NOT NULL,
  `ignore_stale_approvals` INTEGER DEFAULT 0 NOT NULL,
  `require_signed_commits` INTEGER DEFAULT 0 NOT NULL,
  `protected_file_patterns` TEXT NULL,
  `unprotected_file_patterns` TEXT NULL,
  `created_unix` INTEGER NULL,
  `updated_unix` INTEGER NULL,
  `can_force_push` INTEGER DEFAULT 0 NOT NULL,
  `enable_force_push_allowlist` INTEGER DEFAULT 0 NOT NULL,
  `force_push_allowlist_user_i_ds` TEXT NULL,
  `force_push_allowlist_team_i_ds` TEXT NULL,
  `force_push_allowlist_deploy_keys` INTEGER DEFAULT 0 NOT NULL,
  `block_admin_merge_override` INTEGER DEFAULT 0 NOT NULL,
  `priority` INTEGER DEFAULT 0 NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
repo_id INTEGER ✓ Rename | Drop
branch_name TEXT ✓ Rename | Drop
can_push INTEGER Rename | Drop
enable_whitelist INTEGER ✓ Rename | Drop
whitelist_user_i_ds TEXT ✓ Rename | Drop
whitelist_team_i_ds TEXT ✓ Rename | Drop
enable_merge_whitelist INTEGER Rename | Drop
whitelist_deploy_keys INTEGER Rename | Drop
merge_whitelist_user_i_ds TEXT ✓ Rename | Drop
merge_whitelist_team_i_ds TEXT ✓ Rename | Drop
enable_status_check INTEGER Rename | Drop
status_check_contexts TEXT ✓ Rename | Drop
enable_approvals_whitelist INTEGER Rename | Drop
approvals_whitelist_user_i_ds TEXT ✓ Rename | Drop
approvals_whitelist_team_i_ds TEXT ✓ Rename | Drop
required_approvals INTEGER Rename | Drop
block_on_rejected_reviews INTEGER Rename | Drop
block_on_official_review_requests INTEGER Rename | Drop
block_on_outdated_branch INTEGER Rename | Drop
dismiss_stale_approvals INTEGER Rename | Drop
ignore_stale_approvals INTEGER Rename | Drop
require_signed_commits INTEGER Rename | Drop
protected_file_patterns TEXT ✓ Rename | Drop
unprotected_file_patterns TEXT ✓ Rename | Drop
created_unix INTEGER ✓ Rename | Drop
updated_unix INTEGER ✓ Rename | Drop
can_force_push INTEGER Rename | Drop
enable_force_push_allowlist INTEGER Rename | Drop
force_push_allowlist_user_i_ds TEXT ✓ Rename | Drop
force_push_allowlist_team_i_ds TEXT ✓ Rename | Drop
force_push_allowlist_deploy_keys INTEGER Rename | Drop
block_admin_merge_override INTEGER Rename | Drop
priority INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
UQE_protected_branch_s
  • repo_id
  • branch_name
 ✓ SQL 
CREATE UNIQUE INDEX `UQE_protected_branch_s`
ON `protected_branch` (`repo_id`,`branch_name`)
Drop