Merge pull request #11841 from Quix0r/cleanups/type-hints-documentation

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

diff --git a/doc/database/db_cache.md b/doc/database/db_cache.md
index f5691d08a6f266f5fc93c56cd1dd28170e073850..27a11daa66c7dbe8af06a5ae292b7ec2ff6d5aac 100644 (file)
--- a/doc/database/db_cache.md
+++ b/doc/database/db_cache.md
@@ -3,11 +3,23 @@ Table cache
 
 Stores temporary data
 
-| Field        | Description                        | Type         | Null | Key | Default             | Extra |
-| ------------ | ---------------------------------- | ------------ | ---- | --- | ------------------- | ----- |
-| k            | cache key                          | varchar(255) | NO   | PRI | NULL                |       |
-| v            | cached serialized value            | text         | NO   |     | NULL                |       |
-| expires      | datetime of cache expiration       | datetime     | NO   | MUL | 0001-01-01 00:00:00 |       |
-| updated      | datetime of cache insertion        | datetime     | NO   | MUL | 0001-01-01 00:00:00 |       |
+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)