X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=doc%2Fdatabase%2Fdb_parsed_url.md;h=1752cd0b5b1e8fea5018102e20e70a245d70143d;hb=9581b05603e6ee4e250738c159ed2e67b3fb2eeb;hp=8f8bd7bdd78e0a4f163c93214cb5b5004490d258;hpb=a827f948c867ceebf60d82b0740032512be23302;p=friendica.git diff --git a/doc/database/db_parsed_url.md b/doc/database/db_parsed_url.md index 8f8bd7bdd7..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) | 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 | | + +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)