X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=6df09b14b962c44ac0976a8c590ab0ddc0e1a612;hb=33c7abd376346651fbf5ebefd73b13db14557924;hp=7663b71590c22ff0c568b1b02af0b48385a9833f;hpb=64894f9d6f436bbfc439538a6743e497f87af22c;p=friendica.git

diff --git a/database.sql b/database.sql
index 7663b71590..6df09b14b9 100644
--- a/database.sql
+++ b/database.sql
@@ -1,6 +1,6 @@
 -- ------------------------------------------
 -- Friendica 2022.09-dev (Giant Rhubarb)
--- DB_UPDATE_VERSION 1477
+-- DB_UPDATE_VERSION 1479
 -- ------------------------------------------
 
 
@@ -1716,6 +1716,24 @@ CREATE TABLE IF NOT EXISTS `user-contact` (
 	FOREIGN KEY (`uri-id`) REFERENCES `item-uri` (`id`) ON UPDATE RESTRICT ON DELETE CASCADE
 ) DEFAULT COLLATE utf8mb4_general_ci COMMENT='User specific public contact data';
 
+--
+-- TABLE arrived-activity
+--
+CREATE TABLE IF NOT EXISTS `arrived-activity` (
+	`object-id` varbinary(255) NOT NULL COMMENT 'object id of the incoming activity',
+	`received` datetime COMMENT 'Receiving date',
+	 PRIMARY KEY(`object-id`)
+) ENGINE=MEMORY DEFAULT COLLATE utf8mb4_general_ci COMMENT='Id of arrived activities';
+
+--
+-- TABLE fetched-activity
+--
+CREATE TABLE IF NOT EXISTS `fetched-activity` (
+	`object-id` varbinary(255) NOT NULL COMMENT 'object id of fetched activity',
+	`received` datetime COMMENT 'Receiving date',
+	 PRIMARY KEY(`object-id`)
+) ENGINE=MEMORY DEFAULT COLLATE utf8mb4_general_ci COMMENT='Id of fetched activities';
+
 --
 -- TABLE worker-ipc
 --