SQL

CREATE TABLE `action_task_output`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `task_id` INTEGER NULL,
  `output_key` TEXT NULL,
  `output_value` TEXT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
task_id INTEGER ✓ Rename | Drop
output_key TEXT ✓ Rename | Drop
output_value TEXT ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_action_task_output_task_id task_id SQL 
CREATE INDEX `IDX_action_task_output_task_id`
ON `action_task_output` (`task_id`)
Drop
UQE_action_task_output_task_id_output_key
  • task_id
  • output_key
 ✓ SQL 
CREATE UNIQUE INDEX `UQE_action_task_output_task_id_output_key`
ON `action_task_output` (`task_id`,`output_key`)
Drop