SQL

CREATE TABLE `repo_redirect`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `owner_id` INTEGER NULL,
  `lower_name` TEXT NOT NULL,
  `redirect_repo_id` INTEGER NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
owner_id INTEGER ✓ Rename | Drop
lower_name TEXT Rename | Drop
redirect_repo_id INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_repo_redirect_lower_name lower_name SQL 
CREATE INDEX `IDX_repo_redirect_lower_name`
ON `repo_redirect` (`lower_name`)
Drop
UQE_repo_redirect_s
  • owner_id
  • lower_name
 ✓ SQL 
CREATE UNIQUE INDEX `UQE_repo_redirect_s`
ON `repo_redirect` (`owner_id`,`lower_name`)
Drop