X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=doc%2Fdatabase%2Fdb_2fa_recovery_codes.md;h=69c34e6547d83fc994486b9659d092140d3e1874;hb=c608d857077cc3c830637dbcbd40a92f842f456d;hp=4263763693ba249b5eb60eb94afe1bea9f8d5221;hpb=fd30df7300d9de5b2316b86ccc38053cec69dfe1;p=friendica.git diff --git a/doc/database/db_2fa_recovery_codes.md b/doc/database/db_2fa_recovery_codes.md index 4263763693..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)