]> git.mxchange.org Git - friendica.git/blobdiff - static/dbstructure.config.php
Remove poke feature
[friendica.git] / static / dbstructure.config.php
index 79da57a2bbc4fa37b28c61f6891195a826cb29d6..df5115dcb41c09d114e7f3775b921ede1bacd3a7 100644 (file)
@@ -55,7 +55,7 @@
 use Friendica\Database\DBA;
 
 if (!defined('DB_UPDATE_VERSION')) {
-       define('DB_UPDATE_VERSION', 1476);
+       define('DB_UPDATE_VERSION', 1478);
 }
 
 return [
@@ -692,6 +692,20 @@ return [
                        "uri-id" => ["UNIQUE", "uri-id"],
                ]
        ],
+       "fetch-entry" => [
+               "comment" => "",
+               "fields" => [
+                       "id" => ["type" => "int unsigned", "not null" => "1", "extra" => "auto_increment", "primary" => "1", "comment" => "sequential ID"],
+                       "url" => ["type" => "varbinary(255)", "comment" => "url that awaiting to be fetched"],
+                       "created" => ["type" => "datetime", "not null" => "1", "default" => DBA::NULL_DATETIME, "comment" => "Creation date of the fetch request"],
+                       "wid" => ["type" => "int unsigned", "foreign" => ["workerqueue" => "id"], "comment" => "Workerqueue id"],               ],
+               "indexes" => [
+                       "PRIMARY" => ["id"],
+                       "url" => ["UNIQUE", "url"],
+                       "created" => ["created"],
+                       "wid" => ["wid"],
+               ]
+       ],
        "fsuggest" => [
                "comment" => "friend suggestion stuff",
                "fields" => [
@@ -1709,6 +1723,28 @@ return [
                        "uri-id_uid" => ["UNIQUE", "uri-id", "uid"],
                ]
        ],
+       "arrived-activity" => [
+               "comment" => "Id of arrived activities",
+               "fields" => [
+                       "object-id" => ["type" => "varbinary(255)", "not null" => "1", "primary" => "1", "comment" => "object id of the incoming activity"],
+                       "received" => ["type" => "datetime", "comment" => "Receiving date"],
+               ],
+               "indexes" => [
+                       "PRIMARY" => ["object-id"],
+               ],
+               "engine" => "MEMORY",
+       ],
+       "processed-activity" => [
+               "comment" => "Id of processed activities",
+               "fields" => [
+                       "object-id" => ["type" => "varbinary(255)", "not null" => "1", "primary" => "1", "comment" => "object id of the incoming activity"],
+                       "received" => ["type" => "datetime", "comment" => "Receiving date"],
+               ],
+               "indexes" => [
+                       "PRIMARY" => ["object-id"],
+               ],
+               "engine" => "MEMORY",
+       ],
        "worker-ipc" => [
                "comment" => "Inter process communication between the frontend and the worker",
                "fields" => [