SQL

CREATE TABLE `collaboration`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `repo_id` INTEGER NOT NULL,
  `user_id` INTEGER NOT NULL,
  `mode` INTEGER DEFAULT 2 NOT NULL,
  `created_unix` INTEGER NULL,
  `updated_unix` INTEGER NULL
)

+ Add column

Columns

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

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_collaboration_created_unix created_unix SQL 
CREATE INDEX `IDX_collaboration_created_unix`
ON `collaboration` (`created_unix`)
Drop
IDX_collaboration_repo_id repo_id SQL 
CREATE INDEX `IDX_collaboration_repo_id`
ON `collaboration` (`repo_id`)
Drop
IDX_collaboration_updated_unix updated_unix SQL 
CREATE INDEX `IDX_collaboration_updated_unix`
ON `collaboration` (`updated_unix`)
Drop
IDX_collaboration_user_id user_id SQL 
CREATE INDEX `IDX_collaboration_user_id`
ON `collaboration` (`user_id`)
Drop
UQE_collaboration_s
  • repo_id
  • user_id
 ✓ SQL 
CREATE UNIQUE INDEX `UQE_collaboration_s`
ON `collaboration` (`repo_id`,`user_id`)
Drop