SQL

CREATE TABLE `mirror`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `repo_id` INTEGER NULL,
  `interval` INTEGER NULL,
  `enable_prune` INTEGER DEFAULT 1 NOT NULL,
  `updated_unix` INTEGER NULL,
  `next_update_unix` INTEGER NULL,
  `lfs_enabled` INTEGER DEFAULT 0 NOT NULL,
  `lfs_endpoint` TEXT NULL,
  `remote_address` TEXT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
repo_id INTEGER ✓ Rename | Drop
interval INTEGER ✓ Rename | Drop
enable_prune INTEGER Rename | Drop
updated_unix INTEGER ✓ Rename | Drop
next_update_unix INTEGER ✓ Rename | Drop
lfs_enabled INTEGER Rename | Drop
lfs_endpoint TEXT ✓ Rename | Drop
remote_address TEXT ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_mirror_next_update_unix next_update_unix SQL 
CREATE INDEX `IDX_mirror_next_update_unix`
ON `mirror` (`next_update_unix`)
Drop
IDX_mirror_repo_id repo_id SQL 
CREATE INDEX `IDX_mirror_repo_id`
ON `mirror` (`repo_id`)
Drop
IDX_mirror_updated_unix updated_unix SQL 
CREATE INDEX `IDX_mirror_updated_unix`
ON `mirror` (`updated_unix`)
Drop