New field "publish" for channels

[friendica.git] / database.sql

diff --git a/database.sql b/database.sql
index 53166dc6eb8153a0409abfbce1f8120dad465b82..ecc295841fa8b09bf4ad4a742cb6bb26bf04ae45 100644 (file)
--- a/database.sql
+++ b/database.sql
@@ -1,6 +1,6 @@
 -- ------------------------------------------
 -- Friendica 2024.03-dev (Yellow Archangel)
--- DB_UPDATE_VERSION 1545
+-- DB_UPDATE_VERSION 1546
 -- ------------------------------------------
 
 
@@ -482,7 +482,7 @@ CREATE TABLE IF NOT EXISTS `attach` (
 -- TABLE cache
 --
 CREATE TABLE IF NOT EXISTS `cache` (
-       `k` varbinary(255) NOT NULL COMMENT 'cache key',
+       `k` varchar(255) NOT NULL COMMENT 'cache key',
        `v` mediumtext COMMENT 'cached serialized value',
        `expires` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'datetime of cache expiration',
        `updated` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'datetime of cache insertion',
@@ -505,6 +505,7 @@ CREATE TABLE IF NOT EXISTS `channel` (
        `full-text-search` varchar(1023) COMMENT 'Full text search pattern, see https://mariadb.com/kb/en/full-text-index-overview/#in-boolean-mode',
        `media-type` smallint unsigned COMMENT 'Filtered media types',
        `languages` mediumtext COMMENT 'Desired languages',
+       `publish` boolean COMMENT 'publish channel content',
         PRIMARY KEY(`id`),
         INDEX `uid` (`uid`),
        FOREIGN KEY (`uid`) REFERENCES `user` (`uid`) ON UPDATE RESTRICT ON DELETE CASCADE