SQL

CREATE TABLE `package_version`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `package_id` INTEGER NOT NULL,
  `creator_id` INTEGER DEFAULT 0 NOT NULL,
  `version` TEXT NOT NULL,
  `lower_version` TEXT NOT NULL,
  `created_unix` INTEGER NOT NULL,
  `is_internal` INTEGER DEFAULT 0 NOT NULL,
  `metadata_json` TEXT NULL,
  `download_count` INTEGER DEFAULT 0 NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
package_id INTEGER Rename | Drop
creator_id INTEGER Rename | Drop
version TEXT Rename | Drop
lower_version TEXT Rename | Drop
created_unix INTEGER Rename | Drop
is_internal INTEGER Rename | Drop
metadata_json TEXT ✓ Rename | Drop
download_count INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_package_version_created_unix created_unix SQL 
CREATE INDEX `IDX_package_version_created_unix`
ON `package_version` (`created_unix`)
Drop
IDX_package_version_is_internal is_internal SQL 
CREATE INDEX `IDX_package_version_is_internal`
ON `package_version` (`is_internal`)
Drop
IDX_package_version_lower_version lower_version SQL 
CREATE INDEX `IDX_package_version_lower_version`
ON `package_version` (`lower_version`)
Drop
IDX_package_version_package_id package_id SQL 
CREATE INDEX `IDX_package_version_package_id`
ON `package_version` (`package_id`)
Drop
UQE_package_version_s
  • package_id
  • lower_version
 ✓ SQL 
CREATE UNIQUE INDEX `UQE_package_version_s`
ON `package_version` (`package_id`,`lower_version`)
Drop