Changes:

[friendica.git] / database.sql

diff --git a/database.sql b/database.sql
index 7663b71590c22ff0c568b1b02af0b48385a9833f..6df09b14b962c44ac0976a8c590ab0ddc0e1a612 100644 (file)
--- 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
 --