The network is now just a 4 character field

[friendica.git] / src / Database / DBStructure.php

diff --git a/src/Database/DBStructure.php b/src/Database/DBStructure.php
index 12cf71861d6609f60a602013ec8112bd0273d24d..f87d90d1967edbc92a7cd5a0499fb4abe9932a25 100644 (file)
--- a/src/Database/DBStructure.php
+++ b/src/Database/DBStructure.php
@@ -665,7 +665,7 @@ class DBStructure
                                "comment" => "registered addons",
                                "fields" => [
                                                "id" => ["type" => "int", "not null" => "1", "extra" => "auto_increment", "primary" => "1", "comment" => ""],
-                                               "name" => ["type" => "varchar(190)", "not null" => "1", "default" => "", "comment" => ""],
+                                               "name" => ["type" => "varbinary(190)", "not null" => "1", "default" => "", "comment" => ""],
                                                "version" => ["type" => "varchar(255)", "not null" => "1", "default" => "", "comment" => ""],
                                                "installed" => ["type" => "boolean", "not null" => "1", "default" => "0", "comment" => ""],
                                                "hidden" => ["type" => "boolean", "not null" => "1", "default" => "0", "comment" => ""],
@@ -775,7 +775,7 @@ class DBStructure
                                                "remote_self" => ["type" => "boolean", "not null" => "1", "default" => "0", "comment" => ""],
                                                "rel" => ["type" => "tinyint", "not null" => "1", "default" => "0", "comment" => ""],
                                                "duplex" => ["type" => "boolean", "not null" => "1", "default" => "0", "comment" => ""],
-                                               "network" => ["type" => "varchar(255)", "not null" => "1", "default" => "", "comment" => ""],
+                                               "network" => ["type" => "char(4)", "not null" => "1", "default" => "", "comment" => ""],
                                                "name" => ["type" => "varchar(255)", "not null" => "1", "default" => "", "comment" => ""],
                                                "nick" => ["type" => "varchar(255)", "not null" => "1", "default" => "", "comment" => ""],
                                                "location" => ["type" => "varchar(255)", "not null" => "1", "default" => "", "comment" => ""],
@@ -844,8 +844,8 @@ class DBStructure
                                                "alias_uid" => ["alias(32)", "uid"],
                                                "pending_uid" => ["pending", "uid"],
                                                "blocked_uid" => ["blocked", "uid"],
-                                               "uid_rel_network_poll" => ["uid", "rel", "network(4)", "poll(64)", "archive"],
-                                               "uid_network_batch" => ["uid", "network(4)", "batch(64)"],
+                                               "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"],
                                                "nick_uid" => ["nick(32)", "uid"],
@@ -932,7 +932,7 @@ class DBStructure
                                                "poll" => ["type" => "varchar(255)", "not null" => "1", "default" => "", "comment" => ""],
                                                "confirm" => ["type" => "varchar(255)", "not null" => "1", "default" => "", "comment" => ""],
                                                "priority" => ["type" => "tinyint", "not null" => "1", "default" => "0", "comment" => ""],
-                                               "network" => ["type" => "varchar(32)", "not null" => "1", "default" => "", "comment" => ""],
+                                               "network" => ["type" => "char(4)", "not null" => "1", "default" => "", "comment" => ""],
                                                "alias" => ["type" => "varchar(255)", "not null" => "1", "default" => "", "comment" => ""],
                                                "pubkey" => ["type" => "text", "comment" => ""],
                                                "updated" => ["type" => "datetime", "not null" => "1", "default" => NULL_DATE, "comment" => ""],
@@ -996,7 +996,7 @@ class DBStructure
                                                "contact-type" => ["type" => "tinyint", "not null" => "1", "default" => "-1", "comment" => ""],
                                                "hide" => ["type" => "boolean", "not null" => "1", "default" => "0", "comment" => ""],
                                                "nsfw" => ["type" => "boolean", "not null" => "1", "default" => "0", "comment" => ""],
-                                               "network" => ["type" => "varchar(255)", "not null" => "1", "default" => "", "comment" => ""],
+                                               "network" => ["type" => "char(4)", "not null" => "1", "default" => "", "comment" => ""],
                                                "addr" => ["type" => "varchar(255)", "not null" => "1", "default" => "", "comment" => ""],
                                                "notify" => ["type" => "text", "comment" => ""],
                                                "alias" => ["type" => "varchar(255)", "not null" => "1", "default" => "", "comment" => ""],
@@ -1009,7 +1009,7 @@ class DBStructure
                                                "name" => ["name(64)"],
                                                "nick" => ["nick(32)"],
                                                "addr" => ["addr(64)"],
-                                               "hide_network_updated" => ["hide", "network(4)", "updated"],
+                                               "hide_network_updated" => ["hide", "network", "updated"],
                                                "updated" => ["updated"],
                                                ]
                                ];
@@ -1069,7 +1069,7 @@ class DBStructure
                                                "registered-users" => ["type" => "int", "not null" => "1", "default" => "0", "comment" => ""],
                                                "poco" => ["type" => "varchar(255)", "not null" => "1", "default" => "", "comment" => ""],
                                                "noscrape" => ["type" => "varchar(255)", "not null" => "1", "default" => "", "comment" => ""],
-                                               "network" => ["type" => "varchar(32)", "not null" => "1", "default" => "", "comment" => ""],
+                                               "network" => ["type" => "char(4)", "not null" => "1", "default" => "", "comment" => ""],
                                                "platform" => ["type" => "varchar(255)", "not null" => "1", "default" => "", "comment" => ""],
                                                "created" => ["type" => "datetime", "not null" => "1", "default" => NULL_DATE, "comment" => ""],
                                                "last_poco_query" => ["type" => "datetime", "default" => NULL_DATE, "comment" => ""],
@@ -1085,14 +1085,14 @@ class DBStructure
                                "comment" => "addon hook registry",
                                "fields" => [
                                                "id" => ["type" => "int", "not null" => "1", "extra" => "auto_increment", "primary" => "1", "comment" => ""],
-                                               "hook" => ["type" => "varchar(255)", "not null" => "1", "default" => "", "comment" => ""],
-                                               "file" => ["type" => "varchar(255)", "not null" => "1", "default" => "", "comment" => ""],
-                                               "function" => ["type" => "varchar(255)", "not null" => "1", "default" => "", "comment" => ""],
+                                               "hook" => ["type" => "varbinary(100)", "not null" => "1", "default" => "", "comment" => ""],
+                                               "file" => ["type" => "varbinary(200)", "not null" => "1", "default" => "", "comment" => ""],
+                                               "function" => ["type" => "varbinary(200)", "not null" => "1", "default" => "", "comment" => ""],
                                                "priority" => ["type" => "smallint", "not null" => "1", "default" => "0", "comment" => ""],
                                                ],
                                "indexes" => [
                                                "PRIMARY" => ["id"],
-                                               "hook_file_function" => ["UNIQUE", "hook(50)","file(80)","function(60)"],
+                                               "hook_file_function" => ["UNIQUE", "hook", "file", "function"],
                                                ]
                                ];
                $database["intro"] = [
@@ -1177,7 +1177,7 @@ class DBStructure
                                                "origin" => ["type" => "boolean", "not null" => "1", "default" => "0", "comment" => ""],
                                                "forum_mode" => ["type" => "tinyint", "not null" => "1", "default" => "0", "comment" => ""],
                                                "mention" => ["type" => "boolean", "not null" => "1", "default" => "0", "comment" => ""],
-                                               "network" => ["type" => "varchar(32)", "not null" => "1", "default" => "", "comment" => ""],
+                                               "network" => ["type" => "char(4)", "not null" => "1", "default" => "", "comment" => ""],
                                                "rendered-hash" => ["type" => "varchar(32)", "not null" => "1", "default" => "", "comment" => ""],
                                                "rendered-html" => ["type" => "mediumtext", "comment" => ""],
                                                "global" => ["type" => "boolean", "not null" => "1", "default" => "0", "comment" => ""],
@@ -1193,8 +1193,8 @@ class DBStructure
                                                "uid_contactid_id" => ["uid","contact-id","id"],
                                                "uid_created" => ["uid","created"],
                                                "uid_unseen_contactid" => ["uid","unseen","contact-id"],
-                                               "uid_network_received" => ["uid","network(4)","received"],
-                                               "uid_network_commented" => ["uid","network(4)","commented"],
+                                               "uid_network_received" => ["uid","network","received"],
+                                               "uid_network_commented" => ["uid","network","commented"],
                                                "uid_thrparent" => ["uid","thr-parent(190)"],
                                                "uid_parenturi" => ["uid","parent-uri(190)"],
                                                "uid_contactid_created" => ["uid","contact-id","created"],
@@ -1549,7 +1549,7 @@ class DBStructure
                                "fields" => [
                                                "id" => ["type" => "int", "not null" => "1", "extra" => "auto_increment", "primary" => "1", "comment" => ""],
                                                "cid" => ["type" => "int", "not null" => "1", "default" => "0", "relation" => ["contact" => "id"], "comment" => "Message receiver"],
-                                               "network" => ["type" => "varchar(32)", "not null" => "1", "default" => "", "comment" => "Receiver's network"],
+                                               "network" => ["type" => "char(4)", "not null" => "1", "default" => "", "comment" => "Receiver's network"],
                                                "guid" => ["type" => "varchar(255)", "not null" => "1", "default" => "", "comment" => "Unique GUID of the message"],
                                                "created" => ["type" => "datetime", "not null" => "1", "default" => NULL_DATE, "comment" => "Date, when the message was created"],
                                                "last" => ["type" => "datetime", "not null" => "1", "default" => NULL_DATE, "comment" => "Date of last trial"],
@@ -1671,7 +1671,7 @@ class DBStructure
                                                "origin" => ["type" => "boolean", "not null" => "1", "default" => "0", "comment" => ""],
                                                "forum_mode" => ["type" => "tinyint", "not null" => "1", "default" => "0", "comment" => ""],
                                                "mention" => ["type" => "boolean", "not null" => "1", "default" => "0", "comment" => ""],
-                                               "network" => ["type" => "varchar(32)", "not null" => "1", "default" => "", "comment" => ""],
+                                               "network" => ["type" => "char(4)", "not null" => "1", "default" => "", "comment" => ""],
                                                ],
                                "indexes" => [
                                                "PRIMARY" => ["iid"],