%PDF- %PDF- 403WebShell
403Webshell
Server IP : 37.220.80.31  /  Your IP : 18.117.119.7
Web Server : Apache/2.4.52 (Ubuntu)
System : Linux 3051455-guretool.twc1.net 5.15.0-107-generic #117-Ubuntu SMP Fri Apr 26 12:26:49 UTC 2024 x86_64
User : www-root ( 1010)
PHP Version : 7.4.33
Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,
MySQL : OFF  |  cURL : ON  |  WGET : OFF  |  Perl : OFF  |  Python : OFF  |  Sudo : OFF  |  Pkexec : OFF
Directory :  /var/www/www-root/data/www/dev.artlot24.ru/bitrix/modules/search/install/db/mysql/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ Back ]     

Current File : /var/www/www-root/data/www/dev.artlot24.ru/bitrix/modules/search/install/db/mysql/install.sql
CREATE TABLE b_search_content
(
	ID INT(11) NOT NULL auto_increment,
	DATE_CHANGE DATETIME NOT NULL,
	MODULE_ID VARCHAR(50) NOT NULL,
	ITEM_ID VARCHAR(255) NOT NULL,
	CUSTOM_RANK INT(11) NOT NULL DEFAULT 0,
	USER_ID INT(11),
	ENTITY_TYPE_ID VARCHAR(50),
	ENTITY_ID VARCHAR(255),
	URL TEXT,
	TITLE TEXT,
	BODY LONGTEXT,
	TAGS TEXT,
	PARAM1 TEXT,
	PARAM2 TEXT,
	UPD varchar(32),
	DATE_FROM DATETIME,
	DATE_TO DATETIME,
	PRIMARY KEY PK_B_SEARCH_CONTENT (ID),
	UNIQUE UX_B_SEARCH_CONTENT (MODULE_ID, ITEM_ID),
	KEY IX_B_SEARCH_CONTENT_1 (MODULE_ID, PARAM1(50), PARAM2(50)),
	KEY IX_B_SEARCH_CONTENT_2 (ENTITY_ID(50), ENTITY_TYPE_ID)
);

CREATE TABLE b_search_content_text
(
	SEARCH_CONTENT_ID INT(11) NOT NULL,
	SEARCH_CONTENT_MD5 CHAR(32) NOT NULL,
	SEARCHABLE_CONTENT LONGTEXT,
	PRIMARY KEY PK_B_SEARCH_CONTENT_TEXT (SEARCH_CONTENT_ID)
);

CREATE TABLE b_search_content_param
(
	SEARCH_CONTENT_ID INT(11) NOT NULL,
	PARAM_NAME VARCHAR(100) NOT NULL,
	PARAM_VALUE VARCHAR(100) NOT NULL,
	KEY IX_B_SEARCH_CONTENT_PARAM (SEARCH_CONTENT_ID, PARAM_NAME),
	KEY IX_B_SEARCH_CONTENT_PARAM_1 (PARAM_NAME, PARAM_VALUE(50), SEARCH_CONTENT_ID)
);

CREATE TABLE b_search_content_right
(
	SEARCH_CONTENT_ID INT(11) NOT NULL,
	GROUP_CODE VARCHAR(100) NOT NULL,
	UNIQUE UX_B_SEARCH_CONTENT_RIGHT (SEARCH_CONTENT_ID, GROUP_CODE)
);

CREATE TABLE b_search_user_right
(
	USER_ID INT(11) NOT NULL,
	GROUP_CODE VARCHAR(100) NOT NULL,
	UNIQUE UX_B_SEARCH_USER_RIGHT (USER_ID, GROUP_CODE)
);

CREATE TABLE b_search_content_site
(
	SEARCH_CONTENT_ID INT(18) NOT NULL,
	SITE_ID CHAR(2) NOT NULL,
	URL TEXT,
	PRIMARY KEY PK_B_IBLOCK_SITE (SEARCH_CONTENT_ID, SITE_ID)
);

CREATE TABLE b_search_content_stem
(
	SEARCH_CONTENT_ID INT(11) NOT NULL,
	LANGUAGE_ID CHAR(2) NOT NULL,
	STEM INT(11) NOT NULL,
	TF FLOAT NOT NULL,
	PS FLOAT NOT NULL,
	UNIQUE KEY UX_B_SEARCH_CONTENT_STEM (STEM, LANGUAGE_ID, TF, PS, SEARCH_CONTENT_ID),
	KEY IND_B_SEARCH_CONTENT_STEM (SEARCH_CONTENT_ID)
)
DELAY_KEY_WRITE=1;

CREATE TABLE b_search_stem
(
	ID INT(11) NOT NULL auto_increment,
	STEM VARCHAR(50) BINARY NOT NULL,
	PRIMARY KEY PK_B_SEARCH_STEM (ID),
	UNIQUE KEY UX_B_SEARCH_STEM (STEM)
);

CREATE TABLE b_search_content_title
(
	SEARCH_CONTENT_ID INT(11) NOT NULL,
	SITE_ID CHAR(2) NOT NULL,
	POS INT(11) NOT NULL,
	WORD VARCHAR(100) NOT NULL,
	UNIQUE KEY UX_B_SEARCH_CONTENT_TITLE (SITE_ID, WORD, SEARCH_CONTENT_ID, POS),
	KEY IND_B_SEARCH_CONTENT_TITLE (SEARCH_CONTENT_ID)
)
DELAY_KEY_WRITE=1;

CREATE TABLE b_search_content_freq
(
	STEM INT NOT NULL DEFAULT '0',
	LANGUAGE_ID CHAR(2) NOT NULL,
	SITE_ID CHAR(2),
	FREQ FLOAT,
	TF FLOAT,
	UNIQUE KEY UX_B_SEARCH_CONTENT_FREQ (STEM, LANGUAGE_ID, SITE_ID)
);

CREATE TABLE b_search_custom_rank
(
	ID INT(11) NOT NULL auto_increment,
	APPLIED CHAR(1) NOT NULL DEFAULT 'N',
	`RANK` INT(11) NOT NULL DEFAULT 0,
	SITE_ID CHAR(2) NOT NULL,
	MODULE_ID VARCHAR(200) NOT NULL,
	PARAM1 TEXT,
	PARAM2 TEXT,
	ITEM_ID VARCHAR(255),
	PRIMARY KEY PK_B_SEARCH_CUSTOM_RANK (ID),
	KEY IND_B_SEARCH_CUSTOM_RANK (SITE_ID,MODULE_ID)
);

CREATE TABLE b_search_tags
(
	SEARCH_CONTENT_ID INT(11) NOT NULL,
	SITE_ID CHAR(2) NOT NULL,
	NAME VARCHAR(255) binary NOT NULL,
	PRIMARY KEY PK_B_SEARCH_TAGS (SEARCH_CONTENT_ID, SITE_ID, NAME),
	KEY IX_B_SEARCH_TAGS_0 (NAME)
)
DELAY_KEY_WRITE=1;

CREATE TABLE b_search_suggest
(
	ID INT(11) NOT NULL auto_increment,
	SITE_ID CHAR(2) NOT NULL,
	FILTER_MD5 VARCHAR(32) NOT NULL,
	PHRASE VARCHAR(250) NOT NULL,
	RATE FLOAT NOT NULL,
	TIMESTAMP_X DATETIME NOT NULL,
	RESULT_COUNT INT(11) NOT NULL,
	PRIMARY KEY PK_B_SEARCH_SUGGEST (ID),
	KEY IND_B_SEARCH_SUGGEST (FILTER_MD5, PHRASE(50), RATE),
	KEY IND_B_SEARCH_SUGGEST_PHRASE (PHRASE(50), RATE),
	KEY IND_B_SEARCH_SUGGEST_TIME (TIMESTAMP_X)
);

Youez - 2016 - github.com/yon3zu
LinuXploit