SQL

CREATE TABLE `action_schedule`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `title` TEXT NULL,
  `specs` TEXT NULL,
  `repo_id` INTEGER NULL,
  `owner_id` INTEGER NULL,
  `workflow_id` TEXT NULL,
  `trigger_user_id` INTEGER NULL,
  `ref` TEXT NULL,
  `commit_sha` TEXT NULL,
  `event` TEXT NULL,
  `event_payload` TEXT NULL,
  `content` BLOB NULL,
  `created` INTEGER NULL,
  `updated` INTEGER NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
title TEXT ✓ Rename | Drop
specs TEXT ✓ Rename | Drop
repo_id INTEGER ✓ Rename | Drop
owner_id INTEGER ✓ Rename | Drop
workflow_id TEXT ✓ Rename | Drop
trigger_user_id INTEGER ✓ Rename | Drop
ref TEXT ✓ Rename | Drop
commit_sha TEXT ✓ Rename | Drop
event TEXT ✓ Rename | Drop
event_payload TEXT ✓ Rename | Drop
content BLOB ✓ Rename | Drop
created INTEGER ✓ Rename | Drop
updated INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_action_schedule_owner_id owner_id SQL 
CREATE INDEX `IDX_action_schedule_owner_id`
ON `action_schedule` (`owner_id`)
Drop
IDX_action_schedule_repo_id repo_id SQL 
CREATE INDEX `IDX_action_schedule_repo_id`
ON `action_schedule` (`repo_id`)
Drop