]> git.mxchange.org Git - friendica.git/blob - doc/database/db_check-full-text-search.md
Merge pull request #13724 from Raroun/Fix-for-Issue-#13637---Photo-caption-prevents...
[friendica.git] / doc / database / db_check-full-text-search.md
1 Table check-full-text-search
2 ===========
3
4 Check for a full text search match in user defined channels before storing the message in the system
5
6 Fields
7 ------
8
9 | Field      | Description                              | Type         | Null | Key | Default | Extra |
10 | ---------- | ---------------------------------------- | ------------ | ---- | --- | ------- | ----- |
11 | pid        | The ID of the process                    | int unsigned | NO   | PRI | NULL    |       |
12 | searchtext | Simplified text for the full text search | mediumtext   | YES  |     | NULL    |       |
13
14 Indexes
15 ------------
16
17 | Name       | Fields               |
18 | ---------- | -------------------- |
19 | PRIMARY    | pid                  |
20 | searchtext | FULLTEXT, searchtext |
21
22
23 Return to [database documentation](help/database)