SQL

CREATE TABLE `commit_status_summary`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `repo_id` INTEGER NULL,
  `sha` TEXT NOT NULL,
  `state` TEXT NOT NULL,
  `target_url` TEXT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
repo_id INTEGER ✓ Rename | Drop
sha TEXT Rename | Drop
state TEXT Rename | Drop
target_url TEXT ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_commit_status_summary_repo_id repo_id SQL 
CREATE INDEX `IDX_commit_status_summary_repo_id`
ON `commit_status_summary` (`repo_id`)
Drop
IDX_commit_status_summary_sha sha SQL 
CREATE INDEX `IDX_commit_status_summary_sha`
ON `commit_status_summary` (`sha`)
Drop
UQE_commit_status_summary_repo_id_sha
  • repo_id
  • sha
 ✓ SQL 
CREATE UNIQUE INDEX `UQE_commit_status_summary_repo_id_sha`
ON `commit_status_summary` (`repo_id`,`sha`)
Drop