Quickfix for hashtags in usernames in shared posts

[friendica.git] / database.sql

diff --git a/database.sql b/database.sql
index 7102b40df63003654416751f65a71599c18954b2..b6dcb8ab7ff5f2ee849bdcc4f7dbee3065ca888e 100644 (file)
--- a/database.sql
+++ b/database.sql
@@ -1,6 +1,6 @@
 -- ------------------------------------------
 -- Friendica 2021.06-rc (Siberian Iris)
--- DB_UPDATE_VERSION 1422
+-- DB_UPDATE_VERSION 1424
 -- ------------------------------------------
 
 
@@ -120,6 +120,7 @@ CREATE TABLE IF NOT EXISTS `contact` (
        `photo` varchar(255) DEFAULT '' COMMENT 'Link to the profile photo of the contact',
        `thumb` varchar(255) DEFAULT '' COMMENT 'Link to the profile photo (thumb size)',
        `micro` varchar(255) DEFAULT '' COMMENT 'Link to the profile photo (micro size)',
+       `header` varchar(255) COMMENT 'Header picture',
        `site-pubkey` text COMMENT '',
        `issued-id` varchar(255) NOT NULL DEFAULT '' COMMENT '',
        `dfrn-id` varchar(255) NOT NULL DEFAULT '' COMMENT '',
@@ -339,10 +340,12 @@ CREATE TABLE IF NOT EXISTS `apcontact` (
        `outbox` varchar(255) COMMENT '',
        `sharedinbox` varchar(255) COMMENT '',
        `manually-approve` boolean COMMENT '',
+       `discoverable` boolean COMMENT 'Mastodon extension: true if profile is published in their directory',
        `nick` varchar(255) NOT NULL DEFAULT '' COMMENT '',
        `name` varchar(255) COMMENT '',
        `about` text COMMENT '',
        `photo` varchar(255) COMMENT '',
+       `header` varchar(255) COMMENT 'Header picture',
        `addr` varchar(255) COMMENT '',
        `alias` varchar(255) COMMENT '',
        `pubkey` text COMMENT '',
@@ -2256,6 +2259,7 @@ CREATE VIEW `owner-view` AS SELECT
        `contact`.`photo` AS `photo`,
        `contact`.`thumb` AS `thumb`,
        `contact`.`micro` AS `micro`,
+       `contact`.`header` AS `header`,
        `contact`.`site-pubkey` AS `site-pubkey`,
        `contact`.`issued-id` AS `issued-id`,
        `contact`.`dfrn-id` AS `dfrn-id`,