SQL

CREATE TABLE `package_property`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `ref_type` INTEGER NOT NULL,
  `ref_id` INTEGER NOT NULL,
  `name` TEXT NOT NULL,
  `value` TEXT NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
ref_type INTEGER Rename | Drop
ref_id INTEGER Rename | Drop
name TEXT Rename | Drop
value TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_package_property_name name SQL 
CREATE INDEX `IDX_package_property_name`
ON `package_property` (`name`)
Drop
IDX_package_property_ref_id ref_id SQL 
CREATE INDEX `IDX_package_property_ref_id`
ON `package_property` (`ref_id`)
Drop
IDX_package_property_ref_type ref_type SQL 
CREATE INDEX `IDX_package_property_ref_type`
ON `package_property` (`ref_type`)
Drop