SQL

CREATE TABLE `push_mirror`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `repo_id` INTEGER NULL,
  `remote_name` TEXT NULL,
  `remote_address` TEXT NULL,
  `sync_on_commit` INTEGER DEFAULT 1 NOT NULL,
  `interval` INTEGER NULL,
  `created_unix` INTEGER NULL,
  `last_update` INTEGER NULL,
  `last_error` TEXT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
repo_id INTEGER ✓ Rename | Drop
remote_name TEXT ✓ Rename | Drop
remote_address TEXT ✓ Rename | Drop
sync_on_commit INTEGER Rename | Drop
interval INTEGER ✓ Rename | Drop
created_unix INTEGER ✓ Rename | Drop
last_update INTEGER ✓ Rename | Drop
last_error TEXT ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_push_mirror_last_update last_update SQL 
CREATE INDEX `IDX_push_mirror_last_update`
ON `push_mirror` (`last_update`)
Drop
IDX_push_mirror_repo_id repo_id SQL 
CREATE INDEX `IDX_push_mirror_repo_id`
ON `push_mirror` (`repo_id`)
Drop