Merge pull request #7752 from kPherox/develop

[friendica.git] / static / dbstructure.config.php

diff --git a/static/dbstructure.config.php b/static/dbstructure.config.php
index aca6cf16b3d65489adb812990f3b87a38270370f..53f8a8ed44b8b1a3a36b8e057ec5bfcadedb5b7a 100755 (executable)
--- a/static/dbstructure.config.php
+++ b/static/dbstructure.config.php
@@ -34,7 +34,7 @@
 use Friendica\Database\DBA;
 
 if (!defined('DB_UPDATE_VERSION')) {
-       define('DB_UPDATE_VERSION', 1320);
+       define('DB_UPDATE_VERSION', 1323);
 }
 
 return [
@@ -44,13 +44,13 @@ return [
                        "id" => ["type" => "mediumint unsigned", "not null" => "1", "extra" => "auto_increment", "primary" => "1", "comment" => "Password ID for revocation"],
                        "uid" => ["type" => "mediumint unsigned", "not null" => "1", "relation" => ["user" => "uid"], "comment" => "User ID"],
                        "description" => ["type" => "varchar(255)", "comment" => "Description of the usage of the password"],
-                       "hashed_password" => ["type" => "varchar(255)", "not null" => "1", "primary" => "1", "comment" => "Hashed password"],
+                       "hashed_password" => ["type" => "varchar(255)", "not null" => "1", "comment" => "Hashed password"],
                        "generated" => ["type" => "datetime", "not null" => "1", "comment" => "Datetime the password was generated"],
                        "last_used" => ["type" => "datetime", "comment" => "Datetime the password was last used"],
                ],
                "indexes" => [
                        "PRIMARY" => ["id"],
-                       "uid_description" => ["uid", "description"],
+                       "uid_description" => ["uid", "description(190)"],
                ]
        ],
        "2fa_recovery_codes" => [
@@ -763,6 +763,7 @@ return [
                        "inform" => ["type" => "mediumtext", "comment" => "Additional receivers of the linked item"],
                        "queue_count" => ["type" => "mediumint", "not null" => "1", "default" => "0", "comment" => "Initial number of delivery recipients, used as item.delivery_queue_count"],
                        "queue_done" => ["type" => "mediumint", "not null" => "1", "default" => "0", "comment" => "Number of successful deliveries, used as item.delivery_queue_done"],
+                       "queue_failed" => ["type" => "mediumint", "not null" => "1", "default" => "0", "comment" => "Number of unsuccessful deliveries, used as item.delivery_queue_failed"],
                        "activitypub" => ["type" => "mediumint", "not null" => "1", "default" => "0", "comment" => "Number of successful deliveries via ActivityPub"],
                        "dfrn" => ["type" => "mediumint", "not null" => "1", "default" => "0", "comment" => "Number of successful deliveries via DFRN"],
                        "legacy_dfrn" => ["type" => "mediumint", "not null" => "1", "default" => "0", "comment" => "Number of successful deliveries via legacy DFRN"],