Server IP : 85.193.89.191 / Your IP : 3.145.83.126 Web Server : Apache System : Linux 956367-cx40159.tmweb.ru 3.10.0-1160.105.1.el7.x86_64 #1 SMP Thu Dec 7 15:39:45 UTC 2023 x86_64 User : bitrix ( 600) PHP Version : 8.1.27 Disable Function : NONE MySQL : OFF | cURL : OFF | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/bitrix/www/bitrix/modules/messageservice/install/db/mysql/ |
Upload File : |
CREATE TABLE b_messageservice_message ( ID int(18) auto_increment, TYPE varchar(30) not null, SENDER_ID varchar(50) not null, AUTHOR_ID int(18) not null default 0, MESSAGE_FROM varchar(260) null, MESSAGE_TO varchar(50) not null, MESSAGE_HEADERS longtext null, MESSAGE_BODY longtext not null, DATE_INSERT datetime null, DATE_EXEC datetime null, NEXT_EXEC datetime null, SUCCESS_EXEC char(1) not null default 'N', EXEC_ERROR varchar(255) null, STATUS_ID int(18) not null default 0, EXTERNAL_ID varchar(128) null, EXTERNAL_STATUS varchar(128) null, CLUSTER_GROUP int null, PRIMARY KEY (ID), INDEX B_MESSAGESERVICE_MESSAGE_1(DATE_EXEC), INDEX B_MESSAGESERVICE_MESSAGE_2(SUCCESS_EXEC, CLUSTER_GROUP), INDEX B_MESSAGESERVICE_MESSAGE_3(SENDER_ID, EXTERNAL_ID) ); CREATE TABLE b_messageservice_rest_app ( ID int(18) not null auto_increment, APP_ID varchar(128) not null, CODE varchar(128) not null, TYPE varchar(30) not null, HANDLER varchar(1000) not null, DATE_ADD datetime null, AUTHOR_ID int(18) not null default 0, PRIMARY KEY (ID), UNIQUE INDEX B_MESSAGESERVICE_REST_APP_1(APP_ID, CODE) ); CREATE TABLE b_messageservice_rest_app_lang ( ID int(18) not null auto_increment, APP_ID int(18) not null, LANGUAGE_ID char(2) not null, NAME varchar(500) null, APP_NAME varchar(500) null, DESCRIPTION varchar(1000) null, PRIMARY KEY (ID) ); CREATE TABLE b_messageservice_incoming_message ( ID int(18) not null auto_increment, REQUEST_BODY longtext null, DATE_EXEC datetime null, SENDER_ID varchar(50) not null, EXTERNAL_ID varchar(128) null, PRIMARY KEY (ID), UNIQUE INDEX UX_MS_INCOMING_MESSAGE_1(SENDER_ID, EXTERNAL_ID) ); CREATE TABLE b_messageservice_restriction ( ID int not null auto_increment, CODE varchar(128) not null, COUNTER int, DATE_CREATE DATE not null, ADDITIONAL_PARAMS text not null, PRIMARY KEY (ID), UNIQUE INDEX UX_MESSAGESERVISE_RESTRICTION_1(CODE, DATE_CREATE) );