X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=985a6421108f9bd10e51cbe64724c0584c4704ee;hb=270d1aeb41eec8ec41ec3931c4513ef061ec434e;hp=8c4ab5baee6ad41ad80a83f6692fe6366d812354;hpb=d29bad0cb29ae6fbfa63e4fe9d6168036895b0c7;p=friendica.git diff --git a/database.sql b/database.sql index 8c4ab5baee..985a642110 100644 --- a/database.sql +++ b/database.sql @@ -1,6 +1,6 @@ -- ------------------------------------------ -- Friendica 2021.03-dev (Red Hot Poker) --- DB_UPDATE_VERSION 1388 +-- DB_UPDATE_VERSION 1389 -- ------------------------------------------ @@ -1560,10 +1560,13 @@ CREATE VIEW `post-view` AS SELECT `contact`.`thumb` AS `contact-avatar`, `contact`.`network` AS `contact-network`, `contact`.`blocked` AS `contact-blocked`, + `contact`.`hidden` AS `contact-hidden`, `contact`.`readonly` AS `contact-readonly`, + `contact`.`archive` AS `contact-archive`, `contact`.`pending` AS `contact-pending`, `contact`.`rel` AS `contact-rel`, `contact`.`uid` AS `contact-uid`, + `contact`.`contact-type` AS `contact-contact-type`, IF (`item`.`network` IN ('apub', 'dfrn', 'dspr', 'stat'), true, `contact`.`writable`) AS `writable`, `contact`.`self` AS `self`, `contact`.`id` AS `cid`,