SQL

CREATE TABLE `issue_label`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `issue_id` INTEGER NULL,
  `label_id` INTEGER NULL
)

+ Add column

Columns

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

+ Add index

Indexes

Name Columns Unique SQL Drop?
UQE_issue_label_s
  • issue_id
  • label_id
 ✓ SQL 
CREATE UNIQUE INDEX `UQE_issue_label_s`
ON `issue_label` (`issue_id`,`label_id`)
Drop