SQL

CREATE TABLE `package_blob`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `size` INTEGER DEFAULT 0 NOT NULL,
  `hash_md5` TEXT NOT NULL,
  `hash_sha1` TEXT NOT NULL,
  `hash_sha256` TEXT NOT NULL,
  `hash_sha512` TEXT NOT NULL,
  `created_unix` INTEGER NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
size INTEGER Rename | Drop
hash_md5 TEXT Rename | Drop
hash_sha1 TEXT Rename | Drop
hash_sha256 TEXT Rename | Drop
hash_sha512 TEXT Rename | Drop
created_unix INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_package_blob_created_unix created_unix SQL 
CREATE INDEX `IDX_package_blob_created_unix`
ON `package_blob` (`created_unix`)
Drop
IDX_package_blob_hash_md5 hash_md5 SQL 
CREATE INDEX `IDX_package_blob_hash_md5`
ON `package_blob` (`hash_md5`)
Drop
IDX_package_blob_hash_sha1 hash_sha1 SQL 
CREATE INDEX `IDX_package_blob_hash_sha1`
ON `package_blob` (`hash_sha1`)
Drop
IDX_package_blob_hash_sha256 hash_sha256 SQL 
CREATE INDEX `IDX_package_blob_hash_sha256`
ON `package_blob` (`hash_sha256`)
Drop
IDX_package_blob_hash_sha512 hash_sha512 SQL 
CREATE INDEX `IDX_package_blob_hash_sha512`
ON `package_blob` (`hash_sha512`)
Drop
UQE_package_blob_md5 hash_md5 ✓ SQL 
CREATE UNIQUE INDEX `UQE_package_blob_md5`
ON `package_blob` (`hash_md5`)
Drop
UQE_package_blob_sha1 hash_sha1 ✓ SQL 
CREATE UNIQUE INDEX `UQE_package_blob_sha1`
ON `package_blob` (`hash_sha1`)
Drop
UQE_package_blob_sha256 hash_sha256 ✓ SQL 
CREATE UNIQUE INDEX `UQE_package_blob_sha256`
ON `package_blob` (`hash_sha256`)
Drop
UQE_package_blob_sha512 hash_sha512 ✓ SQL 
CREATE UNIQUE INDEX `UQE_package_blob_sha512`
ON `package_blob` (`hash_sha512`)
Drop