We are now setting the corresponding worker id

[friendica.git] / database.sql

diff --git a/database.sql b/database.sql
index 8f0e41cecf4c8e9081dfd27511f4cad59a8d0399..a16bf24cf302edbf91ad934b60b4982639b2df68 100644 (file)
--- a/database.sql
+++ b/database.sql
@@ -1,6 +1,6 @@
 -- ------------------------------------------
 -- Friendica 2022.09-dev (Giant Rhubarb)
--- DB_UPDATE_VERSION 1469
+-- DB_UPDATE_VERSION 1474
 -- ------------------------------------------
 
 
@@ -297,6 +297,7 @@ CREATE TABLE IF NOT EXISTS `2fa_trusted_browser` (
        `cookie_hash` varchar(80) NOT NULL COMMENT 'Trusted cookie hash',
        `uid` mediumint unsigned NOT NULL COMMENT 'User ID',
        `user_agent` text COMMENT 'User agent string',
+       `trusted` boolean NOT NULL DEFAULT '1' COMMENT 'Whenever this browser should be trusted or not',
        `created` datetime NOT NULL COMMENT 'Datetime the trusted browser was recorded',
        `last_used` datetime COMMENT 'Datetime the trusted browser was last used',
         PRIMARY KEY(`cookie_hash`),
@@ -723,6 +724,42 @@ CREATE TABLE IF NOT EXISTS `hook` (
         UNIQUE INDEX `hook_file_function` (`hook`,`file`,`function`)
 ) DEFAULT COLLATE utf8mb4_general_ci COMMENT='addon hook registry';
 
+--
+-- TABLE inbox-entry
+--
+CREATE TABLE IF NOT EXISTS `inbox-entry` (
+       `id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID',
+       `activity-id` varbinary(255) COMMENT 'id of the incoming activity',
+       `object-id` varbinary(255) COMMENT '',
+       `in-reply-to-id` varbinary(255) COMMENT '',
+       `type` varchar(64) COMMENT 'Type of the activity',
+       `object-type` varchar(64) COMMENT 'Type of the object activity',
+       `object-object-type` varchar(64) COMMENT 'Type of the object\'s object activity',
+       `received` datetime COMMENT 'Receiving date',
+       `activity` mediumtext COMMENT 'The JSON activity',
+       `signer` varchar(255) COMMENT '',
+       `push` boolean NOT NULL DEFAULT '0' COMMENT '',
+       `wid` int unsigned COMMENT 'Workerqueue id',
+        PRIMARY KEY(`id`),
+        UNIQUE INDEX `activity-id` (`activity-id`),
+        INDEX `object-id` (`object-id`),
+        INDEX `received` (`received`),
+        INDEX `wid` (`wid`),
+       FOREIGN KEY (`wid`) REFERENCES `workerqueue` (`id`) ON UPDATE RESTRICT ON DELETE CASCADE
+) DEFAULT COLLATE utf8mb4_general_ci COMMENT='Incoming activity';
+
+--
+-- TABLE inbox-entry-receiver
+--
+CREATE TABLE IF NOT EXISTS `inbox-entry-receiver` (
+       `queue-id` int unsigned NOT NULL COMMENT '',
+       `uid` mediumint unsigned NOT NULL COMMENT 'User id',
+        PRIMARY KEY(`queue-id`,`uid`),
+        INDEX `uid` (`uid`),
+       FOREIGN KEY (`queue-id`) REFERENCES `inbox-entry` (`id`) ON UPDATE RESTRICT ON DELETE CASCADE,
+       FOREIGN KEY (`uid`) REFERENCES `user` (`uid`) ON UPDATE RESTRICT ON DELETE CASCADE
+) DEFAULT COLLATE utf8mb4_general_ci COMMENT='Receiver for the incoming activity';
+
 --
 -- TABLE inbox-status
 --
@@ -1216,13 +1253,13 @@ CREATE TABLE IF NOT EXISTS `post-link` (
 CREATE TABLE IF NOT EXISTS `post-media` (
        `id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID',
        `uri-id` int unsigned NOT NULL COMMENT 'Id of the item-uri table entry that contains the item uri',
-       `url` text NOT NULL COMMENT 'Media URL',
+       `url` varbinary(1024) NOT NULL COMMENT 'Media URL',
        `type` tinyint unsigned NOT NULL DEFAULT 0 COMMENT 'Media type',
        `mimetype` varchar(60) COMMENT '',
        `height` smallint unsigned COMMENT 'Height of the media',
        `width` smallint unsigned COMMENT 'Width of the media',
-       `size` mediumint unsigned COMMENT 'Media size',
-       `preview` varbinary(255) COMMENT 'Preview URL',
+       `size` bigint unsigned COMMENT 'Media size',
+       `preview` varbinary(512) COMMENT 'Preview URL',
        `preview-height` smallint unsigned COMMENT 'Height of the preview picture',
        `preview-width` smallint unsigned COMMENT 'Width of the preview picture',
        `description` text COMMENT '',