X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=doc%2Fdatabase%2Fdb_delayed-post.md;h=8ab3ff08e47cd7c16d69c5847f488d4afbbc1a09;hb=d26b0ed5a2b5cd66954816096ba87c05043826f0;hp=732131a602a1c0c602adc8300d91e64daeb20284;hpb=31db9dbef7f6a4f98a6c29d15493bcffb0c39929;p=friendica.git diff --git a/doc/database/db_delayed-post.md b/doc/database/db_delayed-post.md index 732131a602..8ab3ff08e4 100644 --- a/doc/database/db_delayed-post.md +++ b/doc/database/db_delayed-post.md @@ -1,12 +1,34 @@ Table delayed-post =========== + Posts that are about to be distributed at a later time -| Field | Description | Type | Null | Key | Default | Extra | -| ----- | ----------- | ---- | ---- | --- | ------- | ----- | -| id | | int unsigned | YES | PRI | NULL | auto_increment | -| uri | URI of the post that will be distributed later | varchar(255) | NO | | NULL | | -| uid | Owner User id | mediumint unsigned | NO | | NULL | | -| delayed | delay time | datetime | NO | | NULL | | +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 | 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 | +| uid_uri | UNIQUE, uid, uri(190) | +| wid | wid | + +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)