SQL

CREATE TABLE `package_file`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `version_id` INTEGER NOT NULL,
  `blob_id` INTEGER NOT NULL,
  `name` TEXT NOT NULL,
  `lower_name` TEXT NOT NULL,
  `composite_key` TEXT NULL,
  `is_lead` INTEGER DEFAULT 0 NOT NULL,
  `created_unix` INTEGER NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
version_id INTEGER Rename | Drop
blob_id INTEGER Rename | Drop
name TEXT Rename | Drop
lower_name TEXT Rename | Drop
composite_key TEXT ✓ Rename | Drop
is_lead INTEGER Rename | Drop
created_unix INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_package_file_blob_id blob_id SQL 
CREATE INDEX `IDX_package_file_blob_id`
ON `package_file` (`blob_id`)
Drop
IDX_package_file_composite_key composite_key SQL 
CREATE INDEX `IDX_package_file_composite_key`
ON `package_file` (`composite_key`)
Drop
IDX_package_file_created_unix created_unix SQL 
CREATE INDEX `IDX_package_file_created_unix`
ON `package_file` (`created_unix`)
Drop
IDX_package_file_lower_name lower_name SQL 
CREATE INDEX `IDX_package_file_lower_name`
ON `package_file` (`lower_name`)
Drop
IDX_package_file_version_id version_id SQL 
CREATE INDEX `IDX_package_file_version_id`
ON `package_file` (`version_id`)
Drop
UQE_package_file_s
  • version_id
  • lower_name
  • composite_key
 ✓ SQL 
CREATE UNIQUE INDEX `UQE_package_file_s`
ON `package_file` (`version_id`,`lower_name`,`composite_key`)
Drop