]> git.mxchange.org Git - friendica.git/blobdiff - database.sql
Remove links from search text
[friendica.git] / database.sql
index 25f94cac85bbe11cca9a411e0eba4d13487396ad..a2b5887752e0d1cc4e0da2febd4f0a493871eaf2 100644 (file)
@@ -2090,6 +2090,7 @@ CREATE VIEW `post-user-view` AS SELECT
        `author`.`blocked` AS `author-blocked`,
        `author`.`hidden` AS `author-hidden`,
        `author`.`updated` AS `author-updated`,
+       `author`.`contact-type` AS `author-contact-type`,
        `author`.`gsid` AS `author-gsid`,
        `author`.`baseurl` AS `author-baseurl`,
        `post-user`.`owner-id` AS `owner-id`,
@@ -2274,6 +2275,7 @@ CREATE VIEW `post-thread-user-view` AS SELECT
        `author`.`blocked` AS `author-blocked`,
        `author`.`hidden` AS `author-hidden`,
        `author`.`updated` AS `author-updated`,
+       `author`.`contact-type` AS `author-contact-type`,
        `author`.`gsid` AS `author-gsid`,
        `post-thread-user`.`owner-id` AS `owner-id`,
        `owner`.`uri-id` AS `owner-uri-id`,
@@ -2442,6 +2444,7 @@ CREATE VIEW `post-view` AS SELECT
        `author`.`blocked` AS `author-blocked`,
        `author`.`hidden` AS `author-hidden`,
        `author`.`updated` AS `author-updated`,
+       `author`.`contact-type` AS `author-contact-type`,
        `author`.`gsid` AS `author-gsid`,
        `post`.`owner-id` AS `owner-id`,
        `owner`.`uri-id` AS `owner-uri-id`,
@@ -2587,6 +2590,7 @@ CREATE VIEW `post-thread-view` AS SELECT
        `author`.`blocked` AS `author-blocked`,
        `author`.`hidden` AS `author-hidden`,
        `author`.`updated` AS `author-updated`,
+       `author`.`contact-type` AS `author-contact-type`,
        `author`.`gsid` AS `author-gsid`,
        `post-thread`.`owner-id` AS `owner-id`,
        `owner`.`uri-id` AS `owner-uri-id`,