SQL

CREATE TABLE `commit_sync_log`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `repo_id` INTEGER NOT NULL,
  `commit_sha` TEXT NOT NULL,
  `branch` TEXT NOT NULL,
  `user_id` INTEGER NOT NULL,
  `sync_mode` TEXT NULL,
  `status` TEXT NULL,
  `error_message` TEXT NULL,
  `sync_log` TEXT NULL,
  `file_count` INTEGER DEFAULT 0 NULL,
  `created_at` INTEGER 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
user_id INTEGER Rename | Drop
sync_mode TEXT ✓ Rename | Drop
status TEXT ✓ Rename | Drop
error_message TEXT ✓ Rename | Drop
sync_log TEXT ✓ Rename | Drop
file_count INTEGER ✓ Rename | Drop
created_at INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_commit_sync_log_repo_id repo_id SQL 
CREATE INDEX `IDX_commit_sync_log_repo_id`
ON `commit_sync_log` (`repo_id`)
Drop
IDX_commit_sync_log_user_id user_id SQL 
CREATE INDEX `IDX_commit_sync_log_user_id`
ON `commit_sync_log` (`user_id`)
Drop