| Server IP : 80.87.202.40 / Your IP : 216.73.216.169 Web Server : Apache System : Linux rospirotorg.ru 5.14.0-539.el9.x86_64 #1 SMP PREEMPT_DYNAMIC Thu Dec 5 22:26:13 UTC 2024 x86_64 User : bitrix ( 600) PHP Version : 8.2.27 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /home/bitrix/ext_www/rospirotorg.ru/bitrix/modules/im/install/db/pgsql/ |
Upload File : |
CREATE INDEX tx_b_im_chat_index_search_content ON b_im_chat_index USING GIN (to_tsvector('english', search_content));
CREATE INDEX tx_b_im_chat_index_search_title ON b_im_chat_index USING GIN (to_tsvector('english', search_title));
CREATE INDEX tx_b_im_message_index_search_content ON b_im_message_index USING GIN (to_tsvector('english', search_content));
CREATE INDEX tx_b_im_link_url_index_search_content ON b_im_link_url_index USING GIN (to_tsvector('english', search_content));
CREATE INDEX tx_b_im_link_calendar_index_search_content ON b_im_link_calendar_index USING GIN (to_tsvector('english', search_content));