SQL

CREATE TABLE `action_task_step`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `name` TEXT NULL,
  `task_id` INTEGER NULL,
  `index` INTEGER NULL,
  `repo_id` INTEGER NULL,
  `status` INTEGER NULL,
  `log_index` INTEGER NULL,
  `log_length` INTEGER NULL,
  `started` INTEGER NULL,
  `stopped` INTEGER NULL,
  `created` INTEGER NULL,
  `updated` INTEGER NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
name TEXT ✓ Rename | Drop
task_id INTEGER ✓ Rename | Drop
index INTEGER ✓ Rename | Drop
repo_id INTEGER ✓ Rename | Drop
status INTEGER ✓ Rename | Drop
log_index INTEGER ✓ Rename | Drop
log_length INTEGER ✓ Rename | Drop
started INTEGER ✓ Rename | Drop
stopped INTEGER ✓ Rename | Drop
created INTEGER ✓ Rename | Drop
updated INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_action_task_step_index index SQL 
CREATE INDEX `IDX_action_task_step_index`
ON `action_task_step` (`index`)
Drop
IDX_action_task_step_repo_id repo_id SQL 
CREATE INDEX `IDX_action_task_step_repo_id`
ON `action_task_step` (`repo_id`)
Drop
IDX_action_task_step_status status SQL 
CREATE INDEX `IDX_action_task_step_status`
ON `action_task_step` (`status`)
Drop
IDX_action_task_step_task_id task_id SQL 
CREATE INDEX `IDX_action_task_step_task_id`
ON `action_task_step` (`task_id`)
Drop
UQE_action_task_step_task_index
  • task_id
  • index
 ✓ SQL 
CREATE UNIQUE INDEX `UQE_action_task_step_task_index`
ON `action_task_step` (`task_id`,`index`)
Drop