建议增加索引避免关键字功能

[duckeaty]

Please make sure of the following things

• [X] I have read the documentation.
• [X] I'm sure there are no duplicate issues or discussions.
• [X] I'm sure this feature is not implemented.
• [X] I'm sure it's a reasonable and popular requirement.

Description of the feature / 需求描述

在群晖上挂载本地盘发现会出现@eaDir，设置为隐藏后任然能搜索出来。能不能增加一个关键字框，对期内的关键字避免索引，可以在数据库增加触发器来完成。

Suggested solution / 实现思路

以屏闭@eaDir为例：

基本不影响索引建立速度，其实测效果非常好，可以完全避免@eadir进索引，方法如下： 在数据库的x_search_nodes表增加触发器，在insert前对比关键字并阻止入库：

DELIMITER //
CREATE TRIGGER trg_before_insert_check
BEFORE INSERT ON x_search_nodes
FOR EACH ROW
BEGIN
    IF LOCATE('@eaDir', NEW.name) > 0 OR LOCATE('@eaDir', NEW.parent) > 0 THEN
        SIGNAL SQLSTATE '45000'
        SET MESSAGE_TEXT = 'Insert is not allowed for names or parent containing "@eaDir"';
    END IF;
END;
//
DELIMITER ;

Additional context / 附件

https://github.com/alist-org/alist/discussions/6563alist在挂载群晖时显示@eaDir及索引后搜索会出现@eaDir的解决方法，附改MYSQL后搜索慢的解决方法

[welcome[bot]]

Thanks for opening your first issue here! Be sure to follow the issue template!