X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=doc%2Fdatabase%2Fdb_delayed-post.md;h=8ab3ff08e47cd7c16d69c5847f488d4afbbc1a09;hb=a10f55bb85b503c098ea1642adf4e9bda26e6746;hp=16c31e46e23a8a97e40b55e6d883b7d54628d381;hpb=96f07c7288a0b9a2433ad66ee6cef21612d90264;p=friendica.git diff --git a/doc/database/db_delayed-post.md b/doc/database/db_delayed-post.md index 16c31e46e2..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)