SQL

CREATE TABLE `action_artifact`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `run_id` INTEGER NULL,
  `runner_id` INTEGER NULL,
  `repo_id` INTEGER NULL,
  `owner_id` INTEGER NULL,
  `commit_sha` TEXT NULL,
  `storage_path` TEXT NULL,
  `file_size` INTEGER NULL,
  `file_compressed_size` INTEGER NULL,
  `content_encoding` TEXT NULL,
  `artifact_path` TEXT NULL,
  `artifact_name` TEXT NULL,
  `status` INTEGER NULL,
  `created_unix` INTEGER NULL,
  `updated_unix` INTEGER NULL,
  `expired_unix` INTEGER NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
run_id INTEGER ✓ Rename | Drop
runner_id INTEGER ✓ Rename | Drop
repo_id INTEGER ✓ Rename | Drop
owner_id INTEGER ✓ Rename | Drop
commit_sha TEXT ✓ Rename | Drop
storage_path TEXT ✓ Rename | Drop
file_size INTEGER ✓ Rename | Drop
file_compressed_size INTEGER ✓ Rename | Drop
content_encoding TEXT ✓ Rename | Drop
artifact_path TEXT ✓ Rename | Drop
artifact_name TEXT ✓ Rename | Drop
status INTEGER ✓ Rename | Drop
created_unix INTEGER ✓ Rename | Drop
updated_unix INTEGER ✓ Rename | Drop
expired_unix INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_action_artifact_artifact_name artifact_name SQL 
CREATE INDEX `IDX_action_artifact_artifact_name`
ON `action_artifact` (`artifact_name`)
Drop
IDX_action_artifact_artifact_path artifact_path SQL 
CREATE INDEX `IDX_action_artifact_artifact_path`
ON `action_artifact` (`artifact_path`)
Drop
IDX_action_artifact_expired_unix expired_unix SQL 
CREATE INDEX `IDX_action_artifact_expired_unix`
ON `action_artifact` (`expired_unix`)
Drop
IDX_action_artifact_repo_id repo_id SQL 
CREATE INDEX `IDX_action_artifact_repo_id`
ON `action_artifact` (`repo_id`)
Drop
IDX_action_artifact_run_id run_id SQL 
CREATE INDEX `IDX_action_artifact_run_id`
ON `action_artifact` (`run_id`)
Drop
IDX_action_artifact_status status SQL 
CREATE INDEX `IDX_action_artifact_status`
ON `action_artifact` (`status`)
Drop
IDX_action_artifact_updated_unix updated_unix SQL 
CREATE INDEX `IDX_action_artifact_updated_unix`
ON `action_artifact` (`updated_unix`)
Drop
UQE_action_artifact_runid_name_path
  • run_id
  • artifact_path
  • artifact_name
 ✓ SQL 
CREATE UNIQUE INDEX `UQE_action_artifact_runid_name_path`
ON `action_artifact` (`run_id`,`artifact_path`,`artifact_name`)
Drop