SQL

CREATE TABLE `package`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `owner_id` INTEGER NOT NULL,
  `repo_id` INTEGER NULL,
  `type` TEXT NOT NULL,
  `name` TEXT NOT NULL,
  `lower_name` TEXT NOT NULL,
  `semver_compatible` INTEGER DEFAULT 0 NOT NULL,
  `is_internal` INTEGER DEFAULT 0 NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
owner_id INTEGER Rename | Drop
repo_id INTEGER ✓ Rename | Drop
type TEXT Rename | Drop
name TEXT Rename | Drop
lower_name TEXT Rename | Drop
semver_compatible INTEGER Rename | Drop
is_internal INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_package_lower_name lower_name SQL 
CREATE INDEX `IDX_package_lower_name`
ON `package` (`lower_name`)
Drop
IDX_package_owner_id owner_id SQL 
CREATE INDEX `IDX_package_owner_id`
ON `package` (`owner_id`)
Drop
IDX_package_repo_id repo_id SQL 
CREATE INDEX `IDX_package_repo_id`
ON `package` (`repo_id`)
Drop
IDX_package_type type SQL 
CREATE INDEX `IDX_package_type`
ON `package` (`type`)
Drop
UQE_package_s
  • owner_id
  • type
  • lower_name
 ✓ SQL 
CREATE UNIQUE INDEX `UQE_package_s`
ON `package` (`owner_id`,`type`,`lower_name`)
Drop