SQL

CREATE TABLE `deploy_key`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `key_id` INTEGER NULL,
  `repo_id` INTEGER NULL,
  `name` TEXT NULL,
  `fingerprint` TEXT NULL,
  `mode` INTEGER DEFAULT 1 NOT NULL,
  `created_unix` INTEGER NULL,
  `updated_unix` INTEGER NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
key_id INTEGER ✓ Rename | Drop
repo_id INTEGER ✓ Rename | Drop
name TEXT ✓ Rename | Drop
fingerprint TEXT ✓ Rename | Drop
mode INTEGER Rename | Drop
created_unix INTEGER ✓ Rename | Drop
updated_unix INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_deploy_key_key_id key_id SQL 
CREATE INDEX `IDX_deploy_key_key_id`
ON `deploy_key` (`key_id`)
Drop
IDX_deploy_key_repo_id repo_id SQL 
CREATE INDEX `IDX_deploy_key_repo_id`
ON `deploy_key` (`repo_id`)
Drop
UQE_deploy_key_s
  • key_id
  • repo_id
 ✓ SQL 
CREATE UNIQUE INDEX `UQE_deploy_key_s`
ON `deploy_key` (`key_id`,`repo_id`)
Drop