+ "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"],
+ ],
+ ],