SQL

CREATE TABLE `package_blob_upload`  (
  `id` TEXT PRIMARY KEY NOT NULL,
  `bytes_received` INTEGER DEFAULT 0 NOT NULL,
  `hash_state_bytes` BLOB NULL,
  `created_unix` INTEGER NOT NULL,
  `updated_unix` INTEGER NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ Rename | Drop
bytes_received INTEGER Rename | Drop
hash_state_bytes BLOB ✓ Rename | Drop
created_unix INTEGER Rename | Drop
updated_unix INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_package_blob_upload_updated_unix updated_unix SQL 
CREATE INDEX `IDX_package_blob_upload_updated_unix`
ON `package_blob_upload` (`updated_unix`)
Drop
sqlite_autoindex_package_blob_upload_1 id ✓ SQL
-- no sql found --
 Drop