X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=doc%2Fdatabase%2Fdb_post-media.md;h=de3b0e43cd1520de46497f890b96c6ce89adcf16;hb=4095e6c9be01943c3b074d9a9061a01ff5fafcee;hp=58f1ed7030074154a1e65cb03874f0ef17c43578;hpb=31db9dbef7f6a4f98a6c29d15493bcffb0c39929;p=friendica.git diff --git a/doc/database/db_post-media.md b/doc/database/db_post-media.md index 58f1ed7030..de3b0e43cd 100644 --- a/doc/database/db_post-media.md +++ b/doc/database/db_post-media.md @@ -4,24 +4,24 @@ Attached media | Field | Description | Type | Null | Key | Default | Extra | | ----- | ----------- | ---- | ---- | --- | ------- | ----- | -| id | sequential ID | int unsigned | YES | PRI | NULL | auto_increment | -| uri-id | Id of the item-uri table entry that contains the item uri | int unsigned | YES | | NULL | | -| url | Media URL | varbinary(511) | YES | | NULL | | -| type | Media type | tinyint unsigned | YES | | 0 | | -| mimetype | | varchar(60) | NO | | NULL | | -| height | Height of the media | smallint unsigned | NO | | NULL | | -| width | Width of the media | smallint unsigned | NO | | NULL | | -| size | Media size | int unsigned | NO | | NULL | | -| preview | Preview URL | varbinary(255) | NO | | NULL | | -| preview-height | Height of the preview picture | smallint unsigned | NO | | NULL | | -| preview-width | Width of the preview picture | smallint unsigned | NO | | NULL | | -| description | | text | NO | | NULL | | -| name | Name of the media | varchar(255) | NO | | NULL | | -| author-url | URL of the author of the media | varbinary(255) | NO | | NULL | | -| author-name | Name of the author of the media | varchar(255) | NO | | NULL | | -| author-image | Image of the author of the media | varbinary(255) | NO | | NULL | | -| publisher-url | URL of the publisher of the media | varbinary(255) | NO | | NULL | | -| publisher-name | Name of the publisher of the media | varchar(255) | NO | | NULL | | -| publisher-image | Image of the publisher of the media | varbinary(255) | NO | | NULL | | +| id | sequential ID | int unsigned | NO | PRI | NULL | auto_increment | +| uri-id | Id of the item-uri table entry that contains the item uri | int unsigned | NO | | NULL | | +| url | Media URL | varbinary(511) | NO | | NULL | | +| type | Media type | tinyint unsigned | NO | | 0 | | +| mimetype | | varchar(60) | YES | | NULL | | +| height | Height of the media | smallint unsigned | YES | | NULL | | +| width | Width of the media | smallint unsigned | YES | | NULL | | +| size | Media size | int unsigned | YES | | NULL | | +| preview | Preview URL | varbinary(255) | YES | | NULL | | +| preview-height | Height of the preview picture | smallint unsigned | YES | | NULL | | +| preview-width | Width of the preview picture | smallint unsigned | YES | | NULL | | +| description | | text | YES | | NULL | | +| name | Name of the media | varchar(255) | YES | | NULL | | +| author-url | URL of the author of the media | varbinary(255) | YES | | NULL | | +| author-name | Name of the author of the media | varchar(255) | YES | | NULL | | +| author-image | Image of the author of the media | varbinary(255) | YES | | NULL | | +| publisher-url | URL of the publisher of the media | varbinary(255) | YES | | NULL | | +| publisher-name | Name of the publisher of the media | varchar(255) | YES | | NULL | | +| publisher-image | Image of the publisher of the media | varbinary(255) | YES | | NULL | | Return to [database documentation](help/database)