SQL

CREATE TABLE `task`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `doer_id` INTEGER NULL,
  `owner_id` INTEGER NULL,
  `repo_id` INTEGER NULL,
  `type` INTEGER NULL,
  `status` INTEGER NULL,
  `start_time` INTEGER NULL,
  `end_time` INTEGER NULL,
  `payload_content` TEXT NULL,
  `message` TEXT NULL,
  `created` INTEGER NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
doer_id INTEGER ✓ Rename | Drop
owner_id INTEGER ✓ Rename | Drop
repo_id INTEGER ✓ Rename | Drop
type INTEGER ✓ Rename | Drop
status INTEGER ✓ Rename | Drop
start_time INTEGER ✓ Rename | Drop
end_time INTEGER ✓ Rename | Drop
payload_content TEXT ✓ Rename | Drop
message TEXT ✓ Rename | Drop
created INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_task_doer_id doer_id SQL 
CREATE INDEX `IDX_task_doer_id`
ON `task` (`doer_id`)
Drop
IDX_task_owner_id owner_id SQL 
CREATE INDEX `IDX_task_owner_id`
ON `task` (`owner_id`)
Drop
IDX_task_repo_id repo_id SQL 
CREATE INDEX `IDX_task_repo_id`
ON `task` (`repo_id`)
Drop
IDX_task_status status SQL 
CREATE INDEX `IDX_task_status`
ON `task` (`status`)
Drop