X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=doc%2Fdatabase%2Fdb_delayed-post.md;h=8ab3ff08e47cd7c16d69c5847f488d4afbbc1a09;hb=a10f55bb85b503c098ea1642adf4e9bda26e6746;hp=d9faab2890b8d4b288b57207f3f80255bc93a120;hpb=3d74d0a49c07162f6745e9576139a4823bb2af9d;p=friendica.git diff --git a/doc/database/db_delayed-post.md b/doc/database/db_delayed-post.md index d9faab2890..8ab3ff08e4 100644 --- a/doc/database/db_delayed-post.md +++ b/doc/database/db_delayed-post.md @@ -9,17 +9,19 @@ Fields | Field | Description | Type | Null | Key | Default | Extra | | ------- | ---------------------------------------------- | ------------------ | ---- | --- | ------- | -------------- | | id | | int unsigned | NO | PRI | NULL | auto_increment | -| uri | URI of the post that will be distributed later | varchar(255) | YES | | NULL | | +| uri | URI of the post that will be distributed later | varbinary(383) | YES | | NULL | | | uid | Owner User id | mediumint unsigned | YES | | NULL | | | delayed | delay time | datetime | YES | | NULL | | +| wid | Workerqueue id | int unsigned | YES | | NULL | | Indexes ------------ -| Name | Fields | -|------|--------| -| PRIMARY | id | +| Name | Fields | +| ------- | --------------------- | +| PRIMARY | id | | uid_uri | UNIQUE, uid, uri(190) | +| wid | wid | Foreign Keys ------------ @@ -27,5 +29,6 @@ Foreign Keys | Field | Target Table | Target Field | |-------|--------------|--------------| | uid | [user](help/database/db_user) | uid | +| wid | [workerqueue](help/database/db_workerqueue) | id | Return to [database documentation](help/database)