SQL

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

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_repo_indexer_status_s
  • repo_id
  • indexer_type
 SQL 
CREATE INDEX `IDX_repo_indexer_status_s`
ON `repo_indexer_status` (`repo_id`,`indexer_type`)
Drop