]> git.mxchange.org Git - friendica.git/blob - doc/database/db_parsed_url.md
Merge remote-tracking branch 'origin/2022.12-rc' into fixes
[friendica.git] / doc / database / db_parsed_url.md
1 Table parsed_url
2 ===========
3
4 cache for 'parse_url' queries
5
6 Fields
7 ------
8
9 | Field    | Description                       | Type       | Null | Key | Default             | Extra |
10 | -------- | --------------------------------- | ---------- | ---- | --- | ------------------- | ----- |
11 | url_hash | page url hash                     | binary(64) | NO   | PRI | NULL                |       |
12 | guessing | is the 'guessing' mode active?    | boolean    | NO   | PRI | 0                   |       |
13 | oembed   | is the data the result of oembed? | boolean    | NO   | PRI | 0                   |       |
14 | url      | page url                          | text       | NO   |     | NULL                |       |
15 | content  | page data                         | mediumtext | YES  |     | NULL                |       |
16 | created  | datetime of creation              | datetime   | NO   |     | 0001-01-01 00:00:00 |       |
17 | expires  | datetime of expiration            | datetime   | NO   |     | 0001-01-01 00:00:00 |       |
18
19 Indexes
20 ------------
21
22 | Name    | Fields                     |
23 | ------- | -------------------------- |
24 | PRIMARY | url_hash, guessing, oembed |
25 | created | created                    |
26 | expires | expires                    |
27
28
29 Return to [database documentation](help/database)