X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=static%2Fdbstructure.config.php;h=64c9bdff1f7cec3afda6e0dc3a8a7a7ffa6ed7d4;hb=02a76cfcfd9df468503570ce1b0046c78c68e5cf;hp=b7a37708cd76d84ff3ac06e5e61009f4eb4ce972;hpb=be394b573dbdbd098cfca2d2349896fd08477b50;p=friendica.git

diff --git a/static/dbstructure.config.php b/static/dbstructure.config.php
index b7a37708cd..64c9bdff1f 100644
--- a/static/dbstructure.config.php
+++ b/static/dbstructure.config.php
@@ -56,7 +56,7 @@ use Friendica\Database\DBA;
 
 // This file is required several times during the test in DbaDefinition which justifies this condition
 if (!defined('DB_UPDATE_VERSION')) {
-	define('DB_UPDATE_VERSION', 1537);
+	define('DB_UPDATE_VERSION', 1542);
 }
 
 return [
@@ -1551,7 +1551,8 @@ return [
 			"event-id" => ["event-id"],
 			"psid" => ["psid"],
 			"author-id_uid" => ["author-id", "uid"],
-			"author-id_received" => ["author-id", "received"],
+			"author-id_created" => ["author-id", "created"],
+			"owner-id_created" => ["owner-id", "created"],
 			"parent-uri-id_uid" => ["parent-uri-id", "uid"],
 			"uid_wall_received" => ["uid", "wall", "received"],
 			"uid_contactid" => ["uid", "contact-id"],
@@ -1601,11 +1602,18 @@ return [
 			"post-user-id" => ["post-user-id"],
 			"commented" => ["commented"],
 			"received" => ["received"],
+			"author-id_created" => ["author-id", "created"],
+			"owner-id_created" => ["owner-id", "created"],
 			"uid_received" => ["uid", "received"],
 			"uid_wall_received" => ["uid", "wall", "received"],
 			"uid_commented" => ["uid", "commented"],
+			"uid_received" => ["uid", "received"],
+			"uid_created" => ["uid", "created"],
 			"uid_starred" => ["uid", "starred"],
 			"uid_mention" => ["uid", "mention"],
+			"contact-id_commented" => ["contact-id", "commented"],
+			"contact-id_received" => ["contact-id", "received"],
+			"contact-id_created" => ["contact-id", "created"],
 		]
 	],
 	"post-user-notification" => [
@@ -1858,6 +1866,17 @@ return [
 			"uid_application-id" => ["uid", "application-id"],
 		]
 	],
+	"check-full-text-search" => [
+		"comment" => "Check for a full text search match in user defined channels before storing the message in the system",
+		"fields" => [
+			"pid" => ["type" => "int unsigned", "not null" => "1", "primary" => "1", "comment" => "The ID of the process"],
+			"searchtext" => ["type" => "mediumtext", "comment" => "Simplified text for the full text search"],
+		],
+		"indexes" => [
+			"PRIMARY" => ["pid"],
+			"searchtext" => ["FULLTEXT", "searchtext"],
+		],
+	],
 	"userd" => [
 		"comment" => "Deleted usernames",
 		"fields" => [