+/- table definition

Query 

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
)
Use Shift + Up/Down to navigate recently-executed queries
delete expression index : create index : drop insert select : advanced select table : alter table : create table : drop trigger : create trigger : drop update view : create view : drop