SQL

CREATE TABLE `dbfs_data`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `revision` INTEGER NOT NULL,
  `meta_id` INTEGER NOT NULL,
  `blob_offset` INTEGER NOT NULL,
  `blob_size` INTEGER NOT NULL,
  `blob_data` BLOB NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
revision INTEGER Rename | Drop
meta_id INTEGER Rename | Drop
blob_offset INTEGER Rename | Drop
blob_size INTEGER Rename | Drop
blob_data BLOB Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_dbfs_data_meta_offset
  • meta_id
  • blob_offset
 SQL 
CREATE INDEX `IDX_dbfs_data_meta_offset`
ON `dbfs_data` (`meta_id`,`blob_offset`)
Drop