Merge remote-tracking branch 'upstream/2022.09-rc' into pagecache

[friendica.git] / static / dbstructure.config.php

diff --git a/static/dbstructure.config.php b/static/dbstructure.config.php
index bd5cdd93e8a74720eba03c9044bb9c06319ff61b..01c593f68d828fee8208ebc470460377d84c69d0 100644 (file)
--- a/static/dbstructure.config.php
+++ b/static/dbstructure.config.php
@@ -55,7 +55,7 @@
 use Friendica\Database\DBA;
 
 if (!defined('DB_UPDATE_VERSION')) {
-       define('DB_UPDATE_VERSION', 1482);
+       define('DB_UPDATE_VERSION', 1483);
 }
 
 return [
@@ -795,7 +795,7 @@ return [
                        "conversation" => ["type" => "varbinary(383)", "comment" => ""],
                        "type" => ["type" => "varchar(64)", "comment" => "Type of the activity"],
                        "object-type" => ["type" => "varchar(64)", "comment" => "Type of the object activity"],
-                       "object-object-type" => ["type" => "varchar(64)", "comment" => "Type of the object's object activity"],                 
+                       "object-object-type" => ["type" => "varchar(64)", "comment" => "Type of the object's object activity"],
                        "received" => ["type" => "datetime", "comment" => "Receiving date"],
                        "activity" => ["type" => "mediumtext", "comment" => "The JSON activity"],
                        "signer" => ["type" => "varchar(255)", "comment" => ""],
@@ -1051,6 +1051,18 @@ return [
                        "uid" => ["uid"],
                ]
        ],
+       "pagecache" => [
+               "comment" => "Stores temporary data",
+               "fields" => [
+                       "page" => ["type" => "varbinary(255)", "not null" => "1", "primary" => "1", "comment" => "Page"],
+                       "content" => ["type" => "mediumtext", "comment" => "Page content"],
+                       "fetched" => ["type" => "datetime", "comment" => "date when the page had been fetched"],
+               ],
+               "indexes" => [
+                       "PRIMARY" => ["page"],
+                       "fetched" => ["fetched"],
+               ],
+       ],
        "parsed_url" => [
                "comment" => "cache for 'parse_url' queries",
                "fields" => [