SQL

CREATE TABLE `issue_user`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `uid` INTEGER NULL,
  `issue_id` INTEGER NULL,
  `is_read` INTEGER NULL,
  `is_mentioned` INTEGER NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
uid INTEGER ✓ Rename | Drop
issue_id INTEGER ✓ Rename | Drop
is_read INTEGER ✓ Rename | Drop
is_mentioned INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_issue_user_issue_id issue_id SQL 
CREATE INDEX `IDX_issue_user_issue_id`
ON `issue_user` (`issue_id`)
Drop
IDX_issue_user_uid uid SQL 
CREATE INDEX `IDX_issue_user_uid`
ON `issue_user` (`uid`)
Drop
UQE_issue_user_uid_to_issue
  • uid
  • issue_id
 ✓ SQL 
CREATE UNIQUE INDEX `UQE_issue_user_uid_to_issue`
ON `issue_user` (`uid`,`issue_id`)
Drop