Some small performance tweaks (indexes)

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

diff --git a/static/dbstructure.config.php b/static/dbstructure.config.php
index e9232f07243f89b41d442173c7f0c3f449715adb..b5849fb7fc83ff198c70fd42bcb908b49df054dc 100755 (executable)
--- a/static/dbstructure.config.php
+++ b/static/dbstructure.config.php
@@ -54,7 +54,7 @@
 use Friendica\Database\DBA;
 
 if (!defined('DB_UPDATE_VERSION')) {
-       define('DB_UPDATE_VERSION', 1359);
+       define('DB_UPDATE_VERSION', 1361);
 }
 
 return [
@@ -190,19 +190,20 @@ return [
                        "PRIMARY" => ["id"],
                        "uid_name" => ["uid", "name(190)"],
                        "self_uid" => ["self", "uid"],
-                       "alias_uid" => ["alias(32)", "uid"],
+                       "alias_uid" => ["alias(96)", "uid"],
                        "pending_uid" => ["pending", "uid"],
                        "blocked_uid" => ["blocked", "uid"],
                        "uid_rel_network_poll" => ["uid", "rel", "network", "poll(64)", "archive"],
                        "uid_network_batch" => ["uid", "network", "batch(64)"],
-                       "addr_uid" => ["addr(32)", "uid"],
-                       "nurl_uid" => ["nurl(32)", "uid"],
+                       "addr_uid" => ["addr(96)", "uid"],
+                       "nurl_uid" => ["nurl(96)", "uid"],
                        "nick_uid" => ["nick(32)", "uid"],
-                       "attag_uid" => ["attag(32)", "uid"],
+                       "attag_uid" => ["attag(96)", "uid"],
                        "dfrn-id" => ["dfrn-id(64)"],
                        "issued-id" => ["issued-id(64)"],
                        "network_uid_lastupdate" => ["network", "uid", "last-update"],
-                       "uid_lastitem" => ["uid", "last-item"],                 
+                       "uid_network_self_lastupdate" => ["uid", "network", "self", "last-update"],
+                       "uid_lastitem" => ["uid", "last-item"],
                        "gsid" => ["gsid"]
                ]
        ],
@@ -729,6 +730,7 @@ return [
                        "resource-id" => ["resource-id"],
                        "deleted_changed" => ["deleted", "changed"],
                        "uid_wall_changed" => ["uid", "wall", "changed"],
+                       "uid_unseen_wall" => ["uid", "unseen", "wall"],
                        "mention_uid_id" => ["mention", "uid", "id"],
                        "uid_eventid" => ["uid", "event-id"],
                        "icid" => ["icid"],
@@ -1461,6 +1463,7 @@ return [
                        "done_priority_created" => ["done", "priority", "created"],
                        "done_priority_next_try" => ["done", "priority", "next_try"],
                        "done_pid_next_try" => ["done", "pid", "next_try"],
+                       "done_pid_retrial" => ["done", "pid", "retrial"],
                        "done_pid_priority_created" => ["done", "pid", "priority", "created"]
                ]
        ],