Merge pull request #5719 from annando/notices-yeah

[friendica.git/.git] / database.sql

diff --git a/database.sql b/database.sql
index 5289328..60d4b1c 100644 (file)
--- a/database.sql
+++ b/database.sql
@@ -1,6 +1,6 @@
 -- ------------------------------------------
 -- Friendica 2018.08-dev (The Tazmans Flax-lily)
--- DB_UPDATE_VERSION 1281
+-- DB_UPDATE_VERSION 1283
 -- ------------------------------------------
 
 
@@ -1173,6 +1173,18 @@ CREATE TABLE IF NOT EXISTS `userd` (
         INDEX `username` (`username`(32))
 ) DEFAULT COLLATE utf8mb4_general_ci COMMENT='Deleted usernames';
 
+--
+-- TABLE user-contact
+--
+CREATE TABLE IF NOT EXISTS `user-contact` (
+       `cid` int unsigned NOT NULL DEFAULT 0 COMMENT 'Contact id of the linked public contact',
+       `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'User id',
+       `blocked` boolean COMMENT 'Contact is completely blocked for this user',
+       `ignored` boolean COMMENT 'Posts from this contact are ignored',
+       `collapsed` boolean COMMENT 'Posts from this contact are collapsed',
+        PRIMARY KEY(`uid`,`cid`)
+) DEFAULT COLLATE utf8mb4_general_ci COMMENT='User specific public contact data';
+
 --
 -- TABLE user-item
 --
@@ -1180,6 +1192,7 @@ CREATE TABLE IF NOT EXISTS `user-item` (
        `iid` int unsigned NOT NULL DEFAULT 0 COMMENT 'Item id',
        `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'User id',
        `hidden` boolean NOT NULL DEFAULT '0' COMMENT 'Marker to hide an item from the user',
+       `ignored` boolean COMMENT 'Ignore this thread if set',
         PRIMARY KEY(`uid`,`iid`)
 ) DEFAULT COLLATE utf8mb4_general_ci COMMENT='User specific item data';