X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=226c15133579f55e659b8443843fac82450e0b89;hb=c1226bff071c38e708e91f5ba07436c88cfaa737;hp=65da2f7cffa4e5032ed1fcf8cd6db69f6b241522;hpb=4cc52cef6b84e02687be5e306ef333060dcc8f53;p=friendica.git diff --git a/database.sql b/database.sql index 65da2f7cff..226c151335 100644 --- a/database.sql +++ b/database.sql @@ -1560,6 +1560,9 @@ CREATE VIEW `post-view` AS SELECT `contact`.`thumb` AS `contact-avatar`, `contact`.`network` AS `contact-network`, `contact`.`blocked` AS `contact-blocked`, + `contact`.`readonly` AS `contact-readonly`, + `contact`.`pending` AS `contact-pending`, + `contact`.`rel` AS `contact-rel`, `contact`.`uid` AS `contact-uid`, IF (`item`.`network` IN ('apub', 'dfrn', 'dspr', 'stat'), true, `contact`.`writable`) AS `writable`, `contact`.`self` AS `self`,