X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=doc%2Fdatabase%2Fdb_parsed_url.md;h=1752cd0b5b1e8fea5018102e20e70a245d70143d;hb=d26b0ed5a2b5cd66954816096ba87c05043826f0;hp=bf4b7117f59f3d950fe060f9fc24b7eb05e6422e;hpb=31db9dbef7f6a4f98a6c29d15493bcffb0c39929;p=friendica.git diff --git a/doc/database/db_parsed_url.md b/doc/database/db_parsed_url.md index bf4b7117f5..1752cd0b5b 100644 --- a/doc/database/db_parsed_url.md +++ b/doc/database/db_parsed_url.md @@ -1,15 +1,29 @@ Table parsed_url =========== -cache for 'parse_url' queries - -| Field | Description | Type | Null | Key | Default | Extra | -| ----- | ----------- | ---- | ---- | --- | ------- | ----- | -| url_hash | page url hash | binary(64) | YES | PRI | NULL | | -| guessing | is the 'guessing' mode active? | boolean | YES | PRI | 0 | | -| oembed | is the data the result of oembed? | boolean | YES | PRI | 0 | | -| url | page url | text | YES | | NULL | | -| content | page data | mediumtext | NO | | NULL | | -| created | datetime of creation | datetime | YES | | 0001-01-01 00:00:00 | | -| expires | datetime of expiration | datetime | YES | | 0001-01-01 00:00:00 | | + +cache for 'parse_url' queries + +Fields +------ + +| Field | Description | Type | Null | Key | Default | Extra | +| -------- | --------------------------------- | ---------- | ---- | --- | ------------------- | ----- | +| url_hash | page url hash | binary(64) | NO | PRI | NULL | | +| guessing | is the 'guessing' mode active? | boolean | NO | PRI | 0 | | +| oembed | is the data the result of oembed? | boolean | NO | PRI | 0 | | +| url | page url | text | NO | | NULL | | +| content | page data | mediumtext | YES | | NULL | | +| created | datetime of creation | datetime | NO | | 0001-01-01 00:00:00 | | +| expires | datetime of expiration | datetime | NO | | 0001-01-01 00:00:00 | | + +Indexes +------------ + +| Name | Fields | +| ------- | -------------------------- | +| PRIMARY | url_hash, guessing, oembed | +| created | created | +| expires | expires | + Return to [database documentation](help/database)