SQL

CREATE TABLE `action_run_job`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `run_id` INTEGER NULL,
  `repo_id` INTEGER NULL,
  `owner_id` INTEGER NULL,
  `commit_sha` TEXT NULL,
  `is_fork_pull_request` INTEGER NULL,
  `name` TEXT NULL,
  `attempt` INTEGER NULL,
  `workflow_payload` BLOB NULL,
  `job_id` TEXT NULL,
  `needs` TEXT NULL,
  `runs_on` TEXT NULL,
  `task_id` INTEGER NULL,
  `status` INTEGER NULL,
  `started` INTEGER NULL,
  `stopped` INTEGER NULL,
  `created` INTEGER NULL,
  `updated` INTEGER NULL,
  `raw_concurrency` TEXT NULL,
  `is_concurrency_evaluated` INTEGER 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
run_id INTEGER ✓ Rename | Drop
repo_id INTEGER ✓ Rename | Drop
owner_id INTEGER ✓ Rename | Drop
commit_sha TEXT ✓ Rename | Drop
is_fork_pull_request INTEGER ✓ Rename | Drop
name TEXT ✓ Rename | Drop
attempt INTEGER ✓ Rename | Drop
workflow_payload BLOB ✓ Rename | Drop
job_id TEXT ✓ Rename | Drop
needs TEXT ✓ Rename | Drop
runs_on TEXT ✓ Rename | Drop
task_id INTEGER ✓ Rename | Drop
status INTEGER ✓ Rename | Drop
started INTEGER ✓ Rename | Drop
stopped INTEGER ✓ Rename | Drop
created INTEGER ✓ Rename | Drop
updated INTEGER ✓ Rename | Drop
raw_concurrency TEXT ✓ Rename | Drop
is_concurrency_evaluated INTEGER ✓ Rename | Drop
concurrency_group TEXT Rename | Drop
concurrency_cancel INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_action_run_job_commit_sha commit_sha SQL 
CREATE INDEX `IDX_action_run_job_commit_sha`
ON `action_run_job` (`commit_sha`)
Drop
IDX_action_run_job_owner_id owner_id SQL 
CREATE INDEX `IDX_action_run_job_owner_id`
ON `action_run_job` (`owner_id`)
Drop
IDX_action_run_job_repo_concurrency
  • repo_id
  • concurrency_group
 SQL 
CREATE INDEX `IDX_action_run_job_repo_concurrency`
ON `action_run_job` (`repo_id`,`concurrency_group`)
Drop
IDX_action_run_job_run_id run_id SQL 
CREATE INDEX `IDX_action_run_job_run_id`
ON `action_run_job` (`run_id`)
Drop
IDX_action_run_job_status status SQL 
CREATE INDEX `IDX_action_run_job_status`
ON `action_run_job` (`status`)
Drop
IDX_action_run_job_updated updated SQL 
CREATE INDEX `IDX_action_run_job_updated`
ON `action_run_job` (`updated`)
Drop