Merge pull request #12407 from HankG/friendica-api-photo-endpoint-updates

[friendica.git] / doc / database / db_cache.md

diff --git a/doc/database/db_cache.md b/doc/database/db_cache.md
index 333adaa2c1ccf56b3bfc55caa121cf2a7228e8f3..27a11daa66c7dbe8af06a5ae292b7ec2ff6d5aac 100644 (file)
--- a/doc/database/db_cache.md
+++ b/doc/database/db_cache.md
@@ -1,11 +1,25 @@
 Table cache
 ===========
 
-| Field        | Description                        | Type         | Null | Key | Default             | Extra |
-| ------------ | ---------------------------------- | ------------ | ---- | --- | ------------------- | ----- |
-| k            | horizontal width + url or resource | varchar(255) | NO   | PRI | NULL                |       |
-| v            | OEmbed response from site          | text         | NO   |     | NULL                |       |
-| updated      | datetime of cache insertion        | datetime     | NO   | MUL | 0000-00-00 00:00:00 |       |
-| expire_mode  |                                    | int(11)      | NO   |     | 0                   |       |
+Stores temporary data
+
+Fields
+------
+
+| Field   | Description                  | Type           | Null | Key | Default             | Extra |
+| ------- | ---------------------------- | -------------- | ---- | --- | ------------------- | ----- |
+| k       | cache key                    | varbinary(255) | NO   | PRI | NULL                |       |
+| v       | cached serialized value      | mediumtext     | YES  |     | NULL                |       |
+| expires | datetime of cache expiration | datetime       | NO   |     | 0001-01-01 00:00:00 |       |
+| updated | datetime of cache insertion  | datetime       | NO   |     | 0001-01-01 00:00:00 |       |
+
+Indexes
+------------
+
+| Name      | Fields     |
+| --------- | ---------- |
+| PRIMARY   | k          |
+| k_expires | k, expires |
+
 
 Return to [database documentation](help/database)