X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=doc%2Fdatabase%2Fdb_2fa_recovery_codes.md;h=69c34e6547d83fc994486b9659d092140d3e1874;hb=c608d857077cc3c830637dbcbd40a92f842f456d;hp=22c4d85e3d931f76a39061b7f3b866746758336c;hpb=4095e6c9be01943c3b074d9a9061a01ff5fafcee;p=friendica.git diff --git a/doc/database/db_2fa_recovery_codes.md b/doc/database/db_2fa_recovery_codes.md index 22c4d85e3d..69c34e6547 100644 --- a/doc/database/db_2fa_recovery_codes.md +++ b/doc/database/db_2fa_recovery_codes.md @@ -1,12 +1,30 @@ Table 2fa_recovery_codes =========== + Two-factor authentication recovery codes -| Field | Description | Type | Null | Key | Default | Extra | -| ----- | ----------- | ---- | ---- | --- | ------- | ----- | -| uid | User ID | mediumint unsigned | NO | PRI | NULL | | -| code | Recovery code string | varchar(50) | NO | PRI | NULL | | -| generated | Datetime the code was generated | datetime | NO | | NULL | | -| used | Datetime the code was used | datetime | YES | | NULL | | +Fields +------ + +| Field | Description | Type | Null | Key | Default | Extra | +| --------- | ------------------------------- | ------------------ | ---- | --- | ------- | ----- | +| uid | User ID | mediumint unsigned | NO | PRI | NULL | | +| code | Recovery code string | varchar(50) | NO | PRI | NULL | | +| generated | Datetime the code was generated | datetime | NO | | NULL | | +| used | Datetime the code was used | datetime | YES | | NULL | | + +Indexes +------------ + +| Name | Fields | +| ------- | --------- | +| PRIMARY | uid, code | + +Foreign Keys +------------ + +| Field | Target Table | Target Field | +|-------|--------------|--------------| +| uid | [user](help/database/db_user) | uid | Return to [database documentation](help/database)