SQL

CREATE TABLE `lfs_lock`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `repo_id` INTEGER NOT NULL,
  `owner_id` INTEGER NOT NULL,
  `path` TEXT NULL,
  `created` DATETIME NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
repo_id INTEGER Rename | Drop
owner_id INTEGER Rename | Drop
path TEXT ✓ Rename | Drop
created DATETIME ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_lfs_lock_owner_id owner_id SQL 
CREATE INDEX `IDX_lfs_lock_owner_id`
ON `lfs_lock` (`owner_id`)
Drop
IDX_lfs_lock_repo_id repo_id SQL 
CREATE INDEX `IDX_lfs_lock_repo_id`
ON `lfs_lock` (`repo_id`)
Drop