SQL

CREATE TABLE `gpg_key`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `owner_id` INTEGER NOT NULL,
  `key_id` TEXT NOT NULL,
  `primary_key_id` TEXT NULL,
  `content` TEXT NOT NULL,
  `created_unix` INTEGER NULL,
  `expired_unix` INTEGER NULL,
  `added_unix` INTEGER NULL,
  `emails` TEXT NULL,
  `verified` INTEGER DEFAULT 0 NOT NULL,
  `can_sign` INTEGER NULL,
  `can_encrypt_comms` INTEGER NULL,
  `can_encrypt_storage` INTEGER NULL,
  `can_certify` INTEGER NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
owner_id INTEGER Rename | Drop
key_id TEXT Rename | Drop
primary_key_id TEXT ✓ Rename | Drop
content TEXT Rename | Drop
created_unix INTEGER ✓ Rename | Drop
expired_unix INTEGER ✓ Rename | Drop
added_unix INTEGER ✓ Rename | Drop
emails TEXT ✓ Rename | Drop
verified INTEGER Rename | Drop
can_sign INTEGER ✓ Rename | Drop
can_encrypt_comms INTEGER ✓ Rename | Drop
can_encrypt_storage INTEGER ✓ Rename | Drop
can_certify INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_gpg_key_key_id key_id SQL 
CREATE INDEX `IDX_gpg_key_key_id`
ON `gpg_key` (`key_id`)
Drop
IDX_gpg_key_owner_id owner_id SQL 
CREATE INDEX `IDX_gpg_key_owner_id`
ON `gpg_key` (`owner_id`)
Drop