X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=c5fd49ba011446974ed85da26e4714944be95931;hb=b1999459afe1f955e7373f4b4894b44324b10e1e;hp=155feb6706daefaa7c02570ae21f52d5e5502749;hpb=28d13f80605e5f2fa1ee2e42fda8cd58ed17ee47;p=friendica.git diff --git a/database.sql b/database.sql index 155feb6706..c5fd49ba01 100644 --- a/database.sql +++ b/database.sql @@ -1,6 +1,6 @@ -- ------------------------------------------ -- Friendica 3.5.1-dev (Asparagus) --- DB_UPDATE_VERSION 1210 +-- DB_UPDATE_VERSION 1205 -- ------------------------------------------ @@ -328,6 +328,7 @@ CREATE TABLE IF NOT EXISTS `gcontact` ( `gender` varchar(32) NOT NULL DEFAULT '', `birthday` varchar(32) NOT NULL DEFAULT '0000-00-00', `community` tinyint(1) NOT NULL DEFAULT 0, + `contact-type` tinyint(1) NOT NULL DEFAULT -1, `hide` tinyint(1) NOT NULL DEFAULT 0, `nsfw` tinyint(1) NOT NULL DEFAULT 0, `network` varchar(255) NOT NULL DEFAULT '', @@ -654,6 +655,8 @@ CREATE TABLE IF NOT EXISTS `notify` ( `seen` tinyint(1) NOT NULL DEFAULT 0, `verb` varchar(255) NOT NULL DEFAULT '', `otype` varchar(16) NOT NULL DEFAULT '', + `name_cache` tinytext, + `msg_name` mediumtext, PRIMARY KEY(`id`), INDEX `uid` (`uid`) ) DEFAULT CHARSET=utf8mb4;