SQL

CREATE TABLE `action_task`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `job_id` INTEGER NULL,
  `attempt` INTEGER NULL,
  `runner_id` INTEGER NULL,
  `status` INTEGER NULL,
  `started` INTEGER NULL,
  `stopped` INTEGER NULL,
  `repo_id` INTEGER NULL,
  `owner_id` INTEGER NULL,
  `commit_sha` TEXT NULL,
  `is_fork_pull_request` INTEGER NULL,
  `token_hash` TEXT NULL,
  `token_salt` TEXT NULL,
  `token_last_eight` TEXT NULL,
  `log_filename` TEXT NULL,
  `log_in_storage` INTEGER NULL,
  `log_length` INTEGER NULL,
  `log_size` INTEGER NULL,
  `log_indexes` BLOB NULL,
  `log_expired` INTEGER NULL,
  `created` INTEGER NULL,
  `updated` INTEGER NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
job_id INTEGER ✓ Rename | Drop
attempt INTEGER ✓ Rename | Drop
runner_id INTEGER ✓ Rename | Drop
status INTEGER ✓ Rename | Drop
started INTEGER ✓ Rename | Drop
stopped 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
token_hash TEXT ✓ Rename | Drop
token_salt TEXT ✓ Rename | Drop
token_last_eight TEXT ✓ Rename | Drop
log_filename TEXT ✓ Rename | Drop
log_in_storage INTEGER ✓ Rename | Drop
log_length INTEGER ✓ Rename | Drop
log_size INTEGER ✓ Rename | Drop
log_indexes BLOB ✓ Rename | Drop
log_expired INTEGER ✓ Rename | Drop
created INTEGER ✓ Rename | Drop
updated INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_action_task_commit_sha commit_sha SQL 
CREATE INDEX `IDX_action_task_commit_sha`
ON `action_task` (`commit_sha`)
Drop
IDX_action_task_owner_id owner_id SQL 
CREATE INDEX `IDX_action_task_owner_id`
ON `action_task` (`owner_id`)
Drop
IDX_action_task_repo_id repo_id SQL 
CREATE INDEX `IDX_action_task_repo_id`
ON `action_task` (`repo_id`)
Drop
IDX_action_task_runner_id runner_id SQL 
CREATE INDEX `IDX_action_task_runner_id`
ON `action_task` (`runner_id`)
Drop
IDX_action_task_started started SQL 
CREATE INDEX `IDX_action_task_started`
ON `action_task` (`started`)
Drop
IDX_action_task_status status SQL 
CREATE INDEX `IDX_action_task_status`
ON `action_task` (`status`)
Drop
IDX_action_task_stopped_log_expired
  • stopped
  • log_expired
 SQL 
CREATE INDEX `IDX_action_task_stopped_log_expired`
ON `action_task` (`stopped`,`log_expired`)
Drop
IDX_action_task_token_last_eight token_last_eight SQL 
CREATE INDEX `IDX_action_task_token_last_eight`
ON `action_task` (`token_last_eight`)
Drop
IDX_action_task_updated updated SQL 
CREATE INDEX `IDX_action_task_updated`
ON `action_task` (`updated`)
Drop
UQE_action_task_token_hash token_hash ✓ SQL 
CREATE UNIQUE INDEX `UQE_action_task_token_hash`
ON `action_task` (`token_hash`)
Drop