SQL

CREATE TABLE `two_factor`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `uid` INTEGER NULL,
  `secret` TEXT NULL,
  `scratch_salt` TEXT NULL,
  `scratch_hash` TEXT NULL,
  `last_used_passcode` TEXT NULL,
  `created_unix` INTEGER NULL,
  `updated_unix` INTEGER NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
uid INTEGER ✓ Rename | Drop
secret TEXT ✓ Rename | Drop
scratch_salt TEXT ✓ Rename | Drop
scratch_hash TEXT ✓ Rename | Drop
last_used_passcode TEXT ✓ Rename | Drop
created_unix INTEGER ✓ Rename | Drop
updated_unix INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_two_factor_created_unix created_unix SQL 
CREATE INDEX `IDX_two_factor_created_unix`
ON `two_factor` (`created_unix`)
Drop
IDX_two_factor_updated_unix updated_unix SQL 
CREATE INDEX `IDX_two_factor_updated_unix`
ON `two_factor` (`updated_unix`)
Drop
UQE_two_factor_uid uid ✓ SQL 
CREATE UNIQUE INDEX `UQE_two_factor_uid`
ON `two_factor` (`uid`)
Drop