SQL

CREATE TABLE `repo_transfer`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `doer_id` INTEGER NULL,
  `recipient_id` INTEGER NULL,
  `repo_id` INTEGER NULL,
  `team_i_ds` TEXT NULL,
  `created_unix` INTEGER NOT NULL,
  `updated_unix` INTEGER NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
doer_id INTEGER ✓ Rename | Drop
recipient_id INTEGER ✓ Rename | Drop
repo_id INTEGER ✓ Rename | Drop
team_i_ds TEXT ✓ Rename | Drop
created_unix INTEGER Rename | Drop
updated_unix INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_repo_transfer_created_unix created_unix SQL 
CREATE INDEX `IDX_repo_transfer_created_unix`
ON `repo_transfer` (`created_unix`)
Drop
IDX_repo_transfer_updated_unix updated_unix SQL 
CREATE INDEX `IDX_repo_transfer_updated_unix`
ON `repo_transfer` (`updated_unix`)
Drop