SQL

CREATE TABLE `lfs_meta_object`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `oid` TEXT NOT NULL,
  `size` INTEGER NOT NULL,
  `repository_id` INTEGER NOT NULL,
  `created_unix` INTEGER NULL,
  `updated_unix` INTEGER NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
oid TEXT Rename | Drop
size INTEGER Rename | Drop
repository_id INTEGER Rename | Drop
created_unix INTEGER ✓ Rename | Drop
updated_unix INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_lfs_meta_object_oid oid SQL 
CREATE INDEX `IDX_lfs_meta_object_oid`
ON `lfs_meta_object` (`oid`)
Drop
IDX_lfs_meta_object_repository_id repository_id SQL 
CREATE INDEX `IDX_lfs_meta_object_repository_id`
ON `lfs_meta_object` (`repository_id`)
Drop
IDX_lfs_meta_object_updated_unix updated_unix SQL 
CREATE INDEX `IDX_lfs_meta_object_updated_unix`
ON `lfs_meta_object` (`updated_unix`)
Drop
UQE_lfs_meta_object_s
  • oid
  • repository_id
 ✓ SQL 
CREATE UNIQUE INDEX `UQE_lfs_meta_object_s`
ON `lfs_meta_object` (`oid`,`repository_id`)
Drop