SQL

CREATE TABLE `action_tasks_version`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `owner_id` INTEGER NULL,
  `repo_id` INTEGER NULL,
  `version` INTEGER NULL,
  `created_unix` INTEGER NULL,
  `updated_unix` INTEGER NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
owner_id INTEGER ✓ Rename | Drop
repo_id INTEGER ✓ Rename | Drop
version INTEGER ✓ Rename | Drop
created_unix INTEGER ✓ Rename | Drop
updated_unix INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_action_tasks_version_repo_id repo_id SQL 
CREATE INDEX `IDX_action_tasks_version_repo_id`
ON `action_tasks_version` (`repo_id`)
Drop
UQE_action_tasks_version_owner_repo
  • owner_id
  • repo_id
 ✓ SQL 
CREATE UNIQUE INDEX `UQE_action_tasks_version_owner_repo`
ON `action_tasks_version` (`owner_id`,`repo_id`)
Drop