SQL

CREATE TABLE `action_runner`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `uuid` TEXT NULL,
  `name` TEXT NULL,
  `version` TEXT NULL,
  `owner_id` INTEGER NULL,
  `repo_id` INTEGER NULL,
  `description` TEXT NULL,
  `base` INTEGER NULL,
  `repo_range` TEXT NULL,
  `token_hash` TEXT NULL,
  `token_salt` TEXT NULL,
  `last_online` INTEGER NULL,
  `last_active` INTEGER NULL,
  `agent_labels` TEXT NULL,
  `created` INTEGER NULL,
  `updated` INTEGER NULL,
  `deleted` INTEGER NULL,
  `ephemeral` INTEGER DEFAULT 0 NOT NULL,
  `is_disabled` INTEGER DEFAULT 0 NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
uuid TEXT ✓ Rename | Drop
name TEXT ✓ Rename | Drop
version TEXT ✓ Rename | Drop
owner_id INTEGER ✓ Rename | Drop
repo_id INTEGER ✓ Rename | Drop
description TEXT ✓ Rename | Drop
base INTEGER ✓ Rename | Drop
repo_range TEXT ✓ Rename | Drop
token_hash TEXT ✓ Rename | Drop
token_salt TEXT ✓ Rename | Drop
last_online INTEGER ✓ Rename | Drop
last_active INTEGER ✓ Rename | Drop
agent_labels TEXT ✓ Rename | Drop
created INTEGER ✓ Rename | Drop
updated INTEGER ✓ Rename | Drop
deleted INTEGER ✓ Rename | Drop
ephemeral INTEGER Rename | Drop
is_disabled INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_action_runner_last_active last_active SQL 
CREATE INDEX `IDX_action_runner_last_active`
ON `action_runner` (`last_active`)
Drop
IDX_action_runner_last_online last_online SQL 
CREATE INDEX `IDX_action_runner_last_online`
ON `action_runner` (`last_online`)
Drop
IDX_action_runner_owner_id owner_id SQL 
CREATE INDEX `IDX_action_runner_owner_id`
ON `action_runner` (`owner_id`)
Drop
IDX_action_runner_repo_id repo_id SQL 
CREATE INDEX `IDX_action_runner_repo_id`
ON `action_runner` (`repo_id`)
Drop
UQE_action_runner_token_hash token_hash ✓ SQL 
CREATE UNIQUE INDEX `UQE_action_runner_token_hash`
ON `action_runner` (`token_hash`)
Drop
UQE_action_runner_uuid uuid ✓ SQL 
CREATE UNIQUE INDEX `UQE_action_runner_uuid`
ON `action_runner` (`uuid`)
Drop