SQL

CREATE TABLE `repo_archiver`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `repo_id` INTEGER NULL,
  `type` INTEGER NULL,
  `status` INTEGER NULL,
  `commit_id` TEXT NULL,
  `created_unix` INTEGER NOT NULL,
  `can_view_hidden_files` INTEGER DEFAULT 0 NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
repo_id INTEGER ✓ Rename | Drop
type INTEGER ✓ Rename | Drop
status INTEGER ✓ Rename | Drop
commit_id TEXT ✓ Rename | Drop
created_unix INTEGER Rename | Drop
can_view_hidden_files INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_repo_archiver_created_unix created_unix SQL 
CREATE INDEX `IDX_repo_archiver_created_unix`
ON `repo_archiver` (`created_unix`)
Drop
IDX_repo_archiver_repo_id repo_id SQL 
CREATE INDEX `IDX_repo_archiver_repo_id`
ON `repo_archiver` (`repo_id`)
Drop
UQE_repo_archiver_s
  • repo_id
  • type
  • commit_id
  • can_view_hidden_files
 ✓ SQL 
CREATE UNIQUE INDEX `UQE_repo_archiver_s`
ON `repo_archiver` (`repo_id`,`type`,`commit_id`,`can_view_hidden_files`)
Drop