SQL

CREATE TABLE `commit_status_index`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `repo_id` INTEGER NULL,
  `sha` TEXT NULL,
  `max_index` INTEGER 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
max_index INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_commit_status_index_max_index max_index SQL 
CREATE INDEX `IDX_commit_status_index_max_index`
ON `commit_status_index` (`max_index`)
Drop
UQE_commit_status_index_repo_sha
  • repo_id
  • sha
 ✓ SQL 
CREATE UNIQUE INDEX `UQE_commit_status_index_repo_sha`
ON `commit_status_index` (`repo_id`,`sha`)
Drop