SQL

CREATE TABLE `access`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `user_id` INTEGER NULL,
  `repo_id` INTEGER NULL,
  `mode` INTEGER NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
user_id INTEGER ✓ Rename | Drop
repo_id INTEGER ✓ Rename | Drop
mode INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
UQE_access_s
  • user_id
  • repo_id
 ✓ SQL 
CREATE UNIQUE INDEX `UQE_access_s`
ON `access` (`user_id`,`repo_id`)
Drop