X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=doc%2Fdatabase%2Fdb_2fa_trusted_browser.md;h=18126b49fc9f07d1f806128a6bf3488a620e4b4f;hb=c9d829a679d716db7b63bdb81f9a1318bad51dc7;hp=29be4646a728df4cb485f86269f3b825b34a6ad6;hpb=84ab5d61594ed92e0e28415d6c33df267a3636c5;p=friendica.git diff --git a/doc/database/db_2fa_trusted_browser.md b/doc/database/db_2fa_trusted_browser.md index 29be4646a7..18126b49fc 100644 --- a/doc/database/db_2fa_trusted_browser.md +++ b/doc/database/db_2fa_trusted_browser.md @@ -1,13 +1,33 @@ Table 2fa_trusted_browser =========== + Two-factor authentication trusted browsers -| Field | Description | Type | Null | Key | Default | Extra | -| ----- | ----------- | ---- | ---- | --- | ------- | ----- | -| cookie_hash | Trusted cookie hash | varchar(80) | YES | PRI | | | -| uid | User ID | mediumint unsigned | YES | | | | -| user_agent | User agent string | text | NO | | | | -| created | Datetime the trusted browser was recorded | datetime | YES | | | | -| last_used | Datetime the trusted browser was last used | datetime | NO | | | | +Fields +------ + +| Field | Description | Type | Null | Key | Default | Extra | +| ----------- | ---------------------------------------------- | ------------------ | ---- | --- | ------- | ----- | +| cookie_hash | Trusted cookie hash | varchar(80) | NO | PRI | NULL | | +| uid | User ID | mediumint unsigned | NO | | NULL | | +| user_agent | User agent string | text | YES | | NULL | | +| trusted | Whenever this browser should be trusted or not | boolean | NO | | 1 | | +| created | Datetime the trusted browser was recorded | datetime | NO | | NULL | | +| last_used | Datetime the trusted browser was last used | datetime | YES | | NULL | | + +Indexes +------------ + +| Name | Fields | +| ------- | ----------- | +| PRIMARY | cookie_hash | +| uid | uid | + +Foreign Keys +------------ + +| Field | Target Table | Target Field | +|-------|--------------|--------------| +| uid | [user](help/database/db_user) | uid | Return to [database documentation](help/database)