SQL

CREATE TABLE `public_key`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `owner_id` INTEGER NOT NULL,
  `name` TEXT NOT NULL,
  `fingerprint` TEXT NOT NULL,
  `content` TEXT NOT NULL,
  `mode` INTEGER DEFAULT 2 NOT NULL,
  `type` INTEGER DEFAULT 1 NOT NULL,
  `login_source_id` INTEGER DEFAULT 0 NOT NULL,
  `created_unix` INTEGER NULL,
  `updated_unix` INTEGER NULL,
  `verified` 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
name TEXT Rename | Drop
fingerprint TEXT Rename | Drop
content TEXT Rename | Drop
mode INTEGER Rename | Drop
type INTEGER Rename | Drop
login_source_id INTEGER Rename | Drop
created_unix INTEGER ✓ Rename | Drop
updated_unix INTEGER ✓ Rename | Drop
verified INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_public_key_fingerprint fingerprint SQL 
CREATE INDEX `IDX_public_key_fingerprint`
ON `public_key` (`fingerprint`)
Drop
IDX_public_key_owner_id owner_id SQL 
CREATE INDEX `IDX_public_key_owner_id`
ON `public_key` (`owner_id`)
Drop