Continued:

[friendica.git] / database.sql

diff --git a/database.sql b/database.sql
index 9c98c614a904d3104ba69c024791eac483961cbd..62d5f5ffd7c69bbfc1b5e8c0396ab50ae567101c 100644 (file)
--- a/database.sql
+++ b/database.sql
@@ -190,7 +190,7 @@ CREATE TABLE IF NOT EXISTS `contact` (
        `info` mediumtext COMMENT '',
        `notify_new_posts` boolean NOT NULL DEFAULT '0' COMMENT '',
        `fetch_further_information` tinyint unsigned NOT NULL DEFAULT 0 COMMENT '',
-       `ffi_keyword_denylist` text COMMENT '',
+       `ffi_keyword_blacklist` text COMMENT '',
        `photo` varbinary(383) DEFAULT '' COMMENT 'Link to the profile photo of the contact',
        `thumb` varbinary(383) DEFAULT '' COMMENT 'Link to the profile photo (thumb size)',
        `micro` varbinary(383) DEFAULT '' COMMENT 'Link to the profile photo (micro size)',
@@ -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',
@@ -1929,7 +1929,7 @@ CREATE TABLE IF NOT EXISTS `user-contact` (
        `notify_new_posts` boolean COMMENT '',
        `remote_self` tinyint unsigned COMMENT '0 => No mirroring, 1-2 => Mirror as own post, 3 => Mirror as reshare',
        `fetch_further_information` tinyint unsigned COMMENT '0 => None, 1 => Fetch information, 3 => Fetch keywords, 2 => Fetch both',
-       `ffi_keyword_denylist` text COMMENT '',
+       `ffi_keyword_blacklist` text COMMENT '',
        `subhub` boolean COMMENT '',
        `hub-verify` varbinary(383) COMMENT '',
        `protocol` char(4) COMMENT 'Protocol of the contact',
@@ -2944,7 +2944,7 @@ CREATE VIEW `owner-view` AS SELECT
        `contact`.`bd` AS `bd`,
        `contact`.`notify_new_posts` AS `notify_new_posts`,
        `contact`.`fetch_further_information` AS `fetch_further_information`,
-       `contact`.`ffi_keyword_denylist` AS `ffi_keyword_denylist`,
+       `contact`.`ffi_keyword_blacklist` AS `ffi_keyword_blacklist`,
        `user`.`parent-uid` AS `parent-uid`,
        `user`.`guid` AS `guid`,
        `user`.`nickname` AS `nickname`,
@@ -3152,7 +3152,7 @@ CREATE VIEW `account-user-view` AS SELECT
        `ucontact`.`deleted` AS `deleted`,
        `ucontact`.`notify_new_posts` AS `notify_new_posts`,
        `ucontact`.`fetch_further_information` AS `fetch_further_information`,
-       `ucontact`.`ffi_keyword_denylist` AS `ffi_keyword_denylist`,
+       `ucontact`.`ffi_keyword_blacklist` AS `ffi_keyword_blacklist`,
        `ucontact`.`rating` AS `rating`,
        `ucontact`.`readonly` AS `readonly`,
        `ucontact`.`blocked` AS `blocked`,