SQL

CREATE TABLE `commit_sync_status`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `repo_id` INTEGER NOT NULL,
  `commit_sha` TEXT NOT NULL,
  `branch` TEXT NULL,
  `is_synced` INTEGER DEFAULT 0 NULL,
  `synced_at` INTEGER DEFAULT 0 NULL,
  `sync_log` TEXT NULL,
  `created_at` INTEGER DEFAULT 0 NULL,
  `updated_at` INTEGER DEFAULT 0 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
branch TEXT ✓ Rename | Drop
is_synced INTEGER ✓ Rename | Drop
synced_at INTEGER ✓ Rename | Drop
sync_log TEXT ✓ Rename | Drop
created_at INTEGER ✓ Rename | Drop
updated_at INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_commit_sync_status_repo_id repo_id SQL 
CREATE INDEX `IDX_commit_sync_status_repo_id`
ON `commit_sync_status` (`repo_id`)
Drop