Add missing Twitter API routes for IDs

[friendica.git] / database.sql

diff --git a/database.sql b/database.sql
index d1c73cc048f3f606932d629760f3f8145188cd47..4179932ad8d767ae859db57dd5573d8dcdcdcc5c 100644 (file)
--- a/database.sql
+++ b/database.sql
@@ -1,6 +1,6 @@
 -- ------------------------------------------
 -- Friendica 2021.12-rc (Siberian Iris)
--- DB_UPDATE_VERSION 1446
+-- DB_UPDATE_VERSION 1448
 -- ------------------------------------------
 
 
@@ -601,6 +601,9 @@ CREATE TABLE IF NOT EXISTS `fcontact` (
        `alias` varchar(255) NOT NULL DEFAULT '' COMMENT '',
        `pubkey` text COMMENT '',
        `updated` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '',
+       `interacting_count` int unsigned DEFAULT 0 COMMENT 'Number of contacts this contact interactes with',
+       `interacted_count` int unsigned DEFAULT 0 COMMENT 'Number of contacts that interacted with this contact',
+       `post_count` int unsigned DEFAULT 0 COMMENT 'Number of posts and comments',
         PRIMARY KEY(`id`),
         INDEX `addr` (`addr`(32)),
         UNIQUE INDEX `url` (`url`(190)),
@@ -824,7 +827,8 @@ CREATE TABLE IF NOT EXISTS `notification` (
        `target-uri-id` int unsigned COMMENT 'Item-uri id of the related post',
        `parent-uri-id` int unsigned COMMENT 'Item-uri id of the parent of the related post',
        `created` datetime COMMENT '',
-       `seen` boolean DEFAULT '0' COMMENT '',
+       `seen` boolean DEFAULT '0' COMMENT 'Seen on the desktop',
+       `dismissed` boolean DEFAULT '0' COMMENT 'Dismissed via the API',
         PRIMARY KEY(`id`),
         UNIQUE INDEX `uid_vid_type_actor-id_target-uri-id` (`uid`,`vid`,`type`,`actor-id`,`target-uri-id`),
         INDEX `vid` (`vid`),