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
|