X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=doc%2Fdatabase%2Fdb_openwebauth-token.md;h=c330623d92319eaae3209123d8dd7716d315ee82;hb=59c436b442112344c3e2fa01b1b7e824df6c1e06;hp=3b2cab372658274a5f1eacaf43886254baea1990;hpb=31db9dbef7f6a4f98a6c29d15493bcffb0c39929;p=friendica.git diff --git a/doc/database/db_openwebauth-token.md b/doc/database/db_openwebauth-token.md index 3b2cab3726..c330623d92 100644 --- a/doc/database/db_openwebauth-token.md +++ b/doc/database/db_openwebauth-token.md @@ -1,14 +1,33 @@ Table openwebauth-token =========== + Store OpenWebAuth token to verify contacts -| Field | Description | Type | Null | Key | Default | Extra | -| ----- | ----------- | ---- | ---- | --- | ------- | ----- | -| id | sequential ID | int unsigned | YES | PRI | NULL | auto_increment | -| uid | User id - currently unused | mediumint unsigned | YES | | 0 | | -| type | Verify type | varchar(32) | YES | | | | -| token | A generated token | varchar(255) | YES | | | | -| meta | | varchar(255) | YES | | | | -| created | datetime of creation | datetime | YES | | 0001-01-01 00:00:00 | | +Fields +------ + +| Field | Description | Type | Null | Key | Default | Extra | +| ------- | -------------------------- | ------------------ | ---- | --- | ------------------- | -------------- | +| id | sequential ID | int unsigned | NO | PRI | NULL | auto_increment | +| uid | User id - currently unused | mediumint unsigned | NO | | 0 | | +| type | Verify type | varchar(32) | NO | | | | +| token | A generated token | varchar(255) | NO | | | | +| meta | | varchar(255) | NO | | | | +| created | datetime of creation | datetime | NO | | 0001-01-01 00:00:00 | | + +Indexes +------------ + +| Name | Fields | +| ------- | ------ | +| PRIMARY | id | +| uid | uid | + +Foreign Keys +------------ + +| Field | Target Table | Target Field | +|-------|--------------|--------------| +| uid | [user](help/database/db_user) | uid | Return to [database documentation](help/database)