SQL

CREATE TABLE `webauthn_credential`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `name` TEXT NULL,
  `lower_name` TEXT NULL,
  `user_id` INTEGER NULL,
  `credential_id` BLOB NULL,
  `public_key` BLOB NULL,
  `attestation_type` TEXT NULL,
  `aaguid` BLOB NULL,
  `sign_count` INTEGER NULL,
  `clone_warning` INTEGER NULL,
  `created_unix` INTEGER NULL,
  `updated_unix` INTEGER NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
name TEXT ✓ Rename | Drop
lower_name TEXT ✓ Rename | Drop
user_id INTEGER ✓ Rename | Drop
credential_id BLOB ✓ Rename | Drop
public_key BLOB ✓ Rename | Drop
attestation_type TEXT ✓ Rename | Drop
aaguid BLOB ✓ Rename | Drop
sign_count INTEGER ✓ Rename | Drop
clone_warning INTEGER ✓ Rename | Drop
created_unix INTEGER ✓ Rename | Drop
updated_unix INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_webauthn_credential_created_unix created_unix SQL 
CREATE INDEX `IDX_webauthn_credential_created_unix`
ON `webauthn_credential` (`created_unix`)
Drop
IDX_webauthn_credential_credential_id credential_id SQL 
CREATE INDEX `IDX_webauthn_credential_credential_id`
ON `webauthn_credential` (`credential_id`)
Drop
IDX_webauthn_credential_updated_unix updated_unix SQL 
CREATE INDEX `IDX_webauthn_credential_updated_unix`
ON `webauthn_credential` (`updated_unix`)
Drop
IDX_webauthn_credential_user_id user_id SQL 
CREATE INDEX `IDX_webauthn_credential_user_id`
ON `webauthn_credential` (`user_id`)
Drop
UQE_webauthn_credential_s
  • lower_name
  • user_id
 ✓ SQL 
CREATE UNIQUE INDEX `UQE_webauthn_credential_s`
ON `webauthn_credential` (`lower_name`,`user_id`)
Drop