| 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/search/install/db/mysql/ |
Upload File : |
CREATE TABLE b_search_phrase ( ID INT(18) NOT NULL auto_increment, TIMESTAMP_X DATETIME NOT NULL, SITE_ID CHAR(2) NOT NULL, RESULT_COUNT INT(11) NOT NULL, PAGES INT(11) NOT NULL, SESSION_ID VARCHAR(32) NOT NULL, PHRASE VARCHAR(250), TAGS VARCHAR(250), URL_TO TEXT, URL_TO_404 CHAR(1), URL_TO_SITE_ID CHAR(2), STAT_SESS_ID INT(18), EVENT1 VARCHAR(50), PRIMARY KEY PK_B_SEARCH_PHRASE (ID), KEY IND_PK_B_SEARCH_PHRASE_SESS_PH (SESSION_ID, PHRASE(50)), KEY IND_PK_B_SEARCH_PHRASE_SESS_TG (SESSION_ID, TAGS(50)), KEY IND_PK_B_SEARCH_PHRASE_TIME (TIMESTAMP_X) );