SQL

CREATE TABLE `dbfs_meta`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `full_path` TEXT NOT NULL,
  `block_size` INTEGER NOT NULL,
  `file_size` INTEGER NOT NULL,
  `create_timestamp` INTEGER NOT NULL,
  `modify_timestamp` INTEGER NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
full_path TEXT Rename | Drop
block_size INTEGER Rename | Drop
file_size INTEGER Rename | Drop
create_timestamp INTEGER Rename | Drop
modify_timestamp INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
UQE_dbfs_meta_full_path full_path ✓ SQL 
CREATE UNIQUE INDEX `UQE_dbfs_meta_full_path`
ON `dbfs_meta` (`full_path`)
Drop