SQL

CREATE TABLE `issue_assignees`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `assignee_id` INTEGER NULL,
  `issue_id` INTEGER NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER Rename | Drop
assignee_id INTEGER Rename | Drop
issue_id INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_issue_assignees_assignee_id assignee_id SQL
CREATE INDEX `IDX_issue_assignees_assignee_id`
ON `issue_assignees` (`assignee_id`)
Drop
IDX_issue_assignees_issue_id issue_id SQL
CREATE INDEX `IDX_issue_assignees_issue_id`
ON `issue_assignees` (`issue_id`)
Drop