X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=718855804214984dd43913b0a3bc571b2aff0752;hb=8841519c0dfae069aff6bee6325fa868e4b9b641;hp=528932846297541c0bf83d90dd06d34608a88a40;hpb=ef1c73fb6b6c20429ecb9f617252babc6954016c;p=friendica.git

diff --git a/database.sql b/database.sql
index 5289328462..7188558042 100644
--- a/database.sql
+++ b/database.sql
@@ -1,6 +1,6 @@
 -- ------------------------------------------
--- Friendica 2018.08-dev (The Tazmans Flax-lily)
--- DB_UPDATE_VERSION 1281
+-- Friendica 2018.12-dev (The Tazmans Flax-lily)
+-- 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';