SQL

CREATE TABLE `commit_status`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `index` INTEGER NULL,
  `repo_id` INTEGER NULL,
  `state` TEXT NOT NULL,
  `sha` TEXT NOT NULL,
  `target_url` TEXT NULL,
  `description` TEXT NULL,
  `context_hash` TEXT NULL,
  `context` TEXT NULL,
  `creator_id` INTEGER NULL,
  `created_unix` INTEGER NULL,
  `updated_unix` INTEGER NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
index INTEGER ✓ Rename | Drop
repo_id INTEGER ✓ Rename | Drop
state TEXT Rename | Drop
sha TEXT Rename | Drop
target_url TEXT ✓ Rename | Drop
description TEXT ✓ Rename | Drop
context_hash TEXT ✓ Rename | Drop
context TEXT ✓ Rename | Drop
creator_id INTEGER ✓ Rename | Drop
created_unix INTEGER ✓ Rename | Drop
updated_unix INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_commit_status_context_hash context_hash SQL 
CREATE INDEX `IDX_commit_status_context_hash`
ON `commit_status` (`context_hash`)
Drop
IDX_commit_status_created_unix created_unix SQL 
CREATE INDEX `IDX_commit_status_created_unix`
ON `commit_status` (`created_unix`)
Drop
IDX_commit_status_index index SQL 
CREATE INDEX `IDX_commit_status_index`
ON `commit_status` (`index`)
Drop
IDX_commit_status_repo_id repo_id SQL 
CREATE INDEX `IDX_commit_status_repo_id`
ON `commit_status` (`repo_id`)
Drop
IDX_commit_status_sha sha SQL 
CREATE INDEX `IDX_commit_status_sha`
ON `commit_status` (`sha`)
Drop
IDX_commit_status_updated_unix updated_unix SQL 
CREATE INDEX `IDX_commit_status_updated_unix`
ON `commit_status` (`updated_unix`)
Drop
UQE_commit_status_repo_sha_index
  • index
  • repo_id
  • sha
 ✓ SQL 
CREATE UNIQUE INDEX `UQE_commit_status_repo_sha_index`
ON `commit_status` (`index`,`repo_id`,`sha`)
Drop