SQL

CREATE TABLE `package_cleanup_rule`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `enabled` INTEGER DEFAULT 0 NOT NULL,
  `owner_id` INTEGER DEFAULT 0 NOT NULL,
  `type` TEXT NOT NULL,
  `keep_count` INTEGER DEFAULT 0 NOT NULL,
  `keep_pattern` TEXT DEFAULT '' NOT NULL,
  `remove_days` INTEGER DEFAULT 0 NOT NULL,
  `remove_pattern` TEXT DEFAULT '' NOT NULL,
  `match_full_name` INTEGER DEFAULT 0 NOT NULL,
  `created_unix` INTEGER DEFAULT 0 NOT NULL,
  `updated_unix` INTEGER DEFAULT 0 NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
enabled INTEGER Rename | Drop
owner_id INTEGER Rename | Drop
type TEXT Rename | Drop
keep_count INTEGER Rename | Drop
keep_pattern TEXT Rename | Drop
remove_days INTEGER Rename | Drop
remove_pattern TEXT Rename | Drop
match_full_name INTEGER Rename | Drop
created_unix INTEGER Rename | Drop
updated_unix INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_package_cleanup_rule_enabled enabled SQL 
CREATE INDEX `IDX_package_cleanup_rule_enabled`
ON `package_cleanup_rule` (`enabled`)
Drop
IDX_package_cleanup_rule_owner_id owner_id SQL 
CREATE INDEX `IDX_package_cleanup_rule_owner_id`
ON `package_cleanup_rule` (`owner_id`)
Drop
IDX_package_cleanup_rule_type type SQL 
CREATE INDEX `IDX_package_cleanup_rule_type`
ON `package_cleanup_rule` (`type`)
Drop
UQE_package_cleanup_rule_s
  • owner_id
  • type
 ✓ SQL 
CREATE UNIQUE INDEX `UQE_package_cleanup_rule_s`
ON `package_cleanup_rule` (`owner_id`,`type`)
Drop