SQL

CREATE TABLE `action_runner_token`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `token` TEXT NULL,
  `owner_id` INTEGER NULL,
  `repo_id` INTEGER NULL,
  `is_active` INTEGER NULL,
  `created` INTEGER NULL,
  `updated` INTEGER NULL,
  `deleted` INTEGER NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER Rename | Drop
token TEXT Rename | Drop
owner_id INTEGER Rename | Drop
repo_id INTEGER Rename | Drop
is_active INTEGER Rename | Drop
created INTEGER Rename | Drop
updated INTEGER Rename | Drop
deleted INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_action_runner_token_owner_id owner_id SQL
CREATE INDEX `IDX_action_runner_token_owner_id`
ON `action_runner_token` (`owner_id`)
Drop
IDX_action_runner_token_repo_id repo_id SQL
CREATE INDEX `IDX_action_runner_token_repo_id`
ON `action_runner_token` (`repo_id`)
Drop
UQE_action_runner_token_token token SQL
CREATE UNIQUE INDEX `UQE_action_runner_token_token`
ON `action_runner_token` (`token`)
Drop