SQL

CREATE TABLE `project_issue`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `issue_id` INTEGER NULL,
  `project_id` INTEGER NULL,
  `project_board_id` INTEGER NULL,
  `sorting` INTEGER DEFAULT 0 NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
issue_id INTEGER ✓ Rename | Drop
project_id INTEGER ✓ Rename | Drop
project_board_id INTEGER ✓ Rename | Drop
sorting INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_project_issue_issue_id issue_id SQL 
CREATE INDEX `IDX_project_issue_issue_id`
ON `project_issue` (`issue_id`)
Drop
IDX_project_issue_project_board_id project_board_id SQL 
CREATE INDEX `IDX_project_issue_project_board_id`
ON `project_issue` (`project_board_id`)
Drop
IDX_project_issue_project_id project_id SQL 
CREATE INDEX `IDX_project_issue_project_id`
ON `project_issue` (`project_id`)
Drop