SQL

CREATE TABLE `action_run`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `title` TEXT NULL,
  `repo_id` INTEGER NULL,
  `owner_id` INTEGER NULL,
  `workflow_id` TEXT NULL,
  `index` INTEGER NULL,
  `trigger_user_id` INTEGER NULL,
  `schedule_id` INTEGER NULL,
  `ref` TEXT NULL,
  `commit_sha` TEXT NULL,
  `is_fork_pull_request` INTEGER NULL,
  `need_approval` INTEGER NULL,
  `approved_by` INTEGER NULL,
  `event` TEXT NULL,
  `event_payload` TEXT NULL,
  `trigger_event` TEXT NULL,
  `status` INTEGER NULL,
  `version` INTEGER DEFAULT 0 NULL,
  `started` INTEGER NULL,
  `stopped` INTEGER NULL,
  `previous_duration` INTEGER NULL,
  `created` INTEGER NULL,
  `updated` INTEGER NULL,
  `raw_concurrency` TEXT NULL,
  `concurrency_group` TEXT DEFAULT '' NOT NULL,
  `concurrency_cancel` INTEGER DEFAULT FALSE NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
title TEXT ✓ Rename | Drop
repo_id INTEGER ✓ Rename | Drop
owner_id INTEGER ✓ Rename | Drop
workflow_id TEXT ✓ Rename | Drop
index INTEGER ✓ Rename | Drop
trigger_user_id INTEGER ✓ Rename | Drop
schedule_id INTEGER ✓ Rename | Drop
ref TEXT ✓ Rename | Drop
commit_sha TEXT ✓ Rename | Drop
is_fork_pull_request INTEGER ✓ Rename | Drop
need_approval INTEGER ✓ Rename | Drop
approved_by INTEGER ✓ Rename | Drop
event TEXT ✓ Rename | Drop
event_payload TEXT ✓ Rename | Drop
trigger_event TEXT ✓ Rename | Drop
status INTEGER ✓ Rename | Drop
version INTEGER ✓ Rename | Drop
started INTEGER ✓ Rename | Drop
stopped INTEGER ✓ Rename | Drop
previous_duration INTEGER ✓ Rename | Drop
created INTEGER ✓ Rename | Drop
updated INTEGER ✓ Rename | Drop
raw_concurrency TEXT ✓ Rename | Drop
concurrency_group TEXT Rename | Drop
concurrency_cancel INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_action_run_approved_by approved_by SQL 
CREATE INDEX `IDX_action_run_approved_by`
ON `action_run` (`approved_by`)
Drop
IDX_action_run_index index SQL 
CREATE INDEX `IDX_action_run_index`
ON `action_run` (`index`)
Drop
IDX_action_run_owner_id owner_id SQL 
CREATE INDEX `IDX_action_run_owner_id`
ON `action_run` (`owner_id`)
Drop
IDX_action_run_ref ref SQL 
CREATE INDEX `IDX_action_run_ref`
ON `action_run` (`ref`)
Drop
IDX_action_run_repo_concurrency
  • repo_id
  • concurrency_group
 SQL 
CREATE INDEX `IDX_action_run_repo_concurrency`
ON `action_run` (`repo_id`,`concurrency_group`)
Drop
IDX_action_run_status status SQL 
CREATE INDEX `IDX_action_run_status`
ON `action_run` (`status`)
Drop
IDX_action_run_trigger_user_id trigger_user_id SQL 
CREATE INDEX `IDX_action_run_trigger_user_id`
ON `action_run` (`trigger_user_id`)
Drop
IDX_action_run_workflow_id workflow_id SQL 
CREATE INDEX `IDX_action_run_workflow_id`
ON `action_run` (`workflow_id`)
Drop
UQE_action_run_repo_index
  • repo_id
  • index
 ✓ SQL 
CREATE UNIQUE INDEX `UQE_action_run_repo_index`
ON `action_run` (`repo_id`,`index`)
Drop