SQL

CREATE TABLE `issue_pin`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `repo_id` INTEGER NOT NULL,
  `issue_id` INTEGER NOT NULL,
  `is_pull` INTEGER NOT NULL,
  `pin_order` INTEGER DEFAULT 0 NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
repo_id INTEGER Rename | Drop
issue_id INTEGER Rename | Drop
is_pull INTEGER Rename | Drop
pin_order INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
UQE_issue_pin_s
  • repo_id
  • issue_id
 ✓ SQL 
CREATE UNIQUE INDEX `UQE_issue_pin_s`
ON `issue_pin` (`repo_id`,`issue_id`)
Drop