File manager

File manager - Edit - /home/c14075/dragmet-ural.ru/www/bitrix/modules/im/install/db/mysql/install.sql

Back
CREATE TABLE b_im_chat( ID int(18) not null auto_increment, PARENT_ID int(18) null DEFAULT 0, PARENT_MID int(18) null DEFAULT 0, TITLE varchar(255) null, DESCRIPTION text null, COLOR varchar(255) null, TYPE char(1) null, EXTRANET char(1) null, AUTHOR_ID int(18) not null, AVATAR int(18) null, PIN_MESSAGE_ID int(18) null DEFAULT 0, CALL_TYPE smallint(1) DEFAULT 0, CALL_NUMBER varchar(20) NULL, ENTITY_TYPE varchar(50) NULL, ENTITY_ID varchar(255) NULL, ENTITY_DATA_1 varchar(255) null, ENTITY_DATA_2 varchar(255) null, ENTITY_DATA_3 varchar(255) null, DISK_FOLDER_ID int(18) null, MESSAGE_COUNT int(18) DEFAULT 0, USER_COUNT int(18) DEFAULT 0, PREV_MESSAGE_ID int(18) null, LAST_MESSAGE_ID int(18) null, LAST_MESSAGE_STATUS varchar(50) DEFAULT 'received', DATE_CREATE datetime null, PRIMARY KEY (ID), KEY IX_IM_CHAT_1 (AUTHOR_ID, TYPE), KEY IX_IM_CHAT_2 (ENTITY_TYPE, ENTITY_ID, AUTHOR_ID), KEY IX_IM_CHAT_3 (CALL_NUMBER, AUTHOR_ID), KEY IX_IM_CHAT_4 (TYPE), KEY IX_IM_CHAT_5 (PARENT_ID, PARENT_MID) ); CREATE TABLE b_im_chat_index ( CHAT_ID int(11) not null, SEARCH_CONTENT mediumtext null, SEARCH_TITLE varchar(511) null, PRIMARY KEY (CHAT_ID), KEY IX_IM_CHAT_INDEX_1 (SEARCH_TITLE) ); CREATE TABLE b_im_message( ID int(18) not null auto_increment, CHAT_ID int(18) not null, AUTHOR_ID int(18) not null, MESSAGE text null, MESSAGE_OUT text null, DATE_CREATE datetime not null, EMAIL_TEMPLATE varchar(255) null, NOTIFY_TYPE smallint(2) DEFAULT 0, NOTIFY_MODULE varchar(255) null, NOTIFY_EVENT varchar(255) null, NOTIFY_TAG varchar(255) null, NOTIFY_SUB_TAG varchar(255) null, NOTIFY_TITLE varchar(255) null, NOTIFY_BUTTONS text null, NOTIFY_READ char(1) DEFAULT 'N', IMPORT_ID int(18) null, PRIMARY KEY (ID), KEY IX_IM_MESS_2 (NOTIFY_TAG, AUTHOR_ID), KEY IX_IM_MESS_3 (NOTIFY_SUB_TAG, AUTHOR_ID), KEY IX_IM_MESS_4 (CHAT_ID, NOTIFY_READ), KEY IX_IM_MESS_5 (CHAT_ID, DATE_CREATE), KEY IX_IM_MESS_6 (AUTHOR_ID), KEY IX_IM_MESS_8 (NOTIFY_TYPE, DATE_CREATE) ); CREATE TABLE b_im_message_index( MESSAGE_ID int(11) NOT NULL, SEARCH_CONTENT mediumtext null, PRIMARY KEY (MESSAGE_ID) ); CREATE TABLE b_im_message_param ( ID int(18) not null auto_increment, MESSAGE_ID INT(11) NOT NULL, PARAM_NAME VARCHAR(100) NOT NULL, PARAM_VALUE VARCHAR(100) NULL, PARAM_JSON text null, PRIMARY KEY (ID), KEY IX_B_IM_MESSAGE_PARAM_1 (MESSAGE_ID, PARAM_NAME), KEY IX_B_IM_MESSAGE_PARAM_2 (PARAM_NAME, PARAM_VALUE(50), MESSAGE_ID) ); CREATE TABLE b_im_message_favorite ( ID int(18) not null auto_increment, USER_ID int(18) not null, CHAT_ID INT(11) NOT NULL, MESSAGE_ID INT(11) NOT NULL, DATE_CREATE datetime not null, UNIQUE KEY pk_b_im_message_favorite (ID), KEY IX_B_IM_MESSAGE_FAVORITE_1 (USER_ID, DATE_CREATE DESC), KEY IX_B_IM_MESSAGE_FAVORITE_2 (CHAT_ID, DATE_CREATE DESC) ); CREATE TABLE b_im_status ( USER_ID int(18) not null, COLOR varchar(255) null, STATUS varchar(50) default 'online', STATUS_TEXT varchar(255) null, IDLE datetime null, DESKTOP_LAST_DATE datetime null, MOBILE_LAST_DATE datetime null, EVENT_ID int(18) null, EVENT_UNTIL_DATE datetime null, INVITED char(1) default 'N', PRIMARY KEY (USER_ID), INDEX IX_IM_STATUS_EUD (EVENT_UNTIL_DATE) ); CREATE TABLE b_im_relation ( ID int(18) not null auto_increment, CHAT_ID int(18) not null, MESSAGE_TYPE char(1) default 'P', USER_ID int(18) not null, START_ID int(18) DEFAULT 0, UNREAD_ID int(18) DEFAULT 0, LAST_ID int(18) DEFAULT 0, LAST_SEND_ID int(18) DEFAULT 0, LAST_FILE_ID int(18) DEFAULT 0, LAST_READ datetime null, STATUS smallint(1) DEFAULT 0, CALL_STATUS smallint(1) DEFAULT 0, MESSAGE_STATUS varchar(50) DEFAULT 'received', NOTIFY_BLOCK char(1) DEFAULT 'N', MANAGER char(1) DEFAULT 'N', COUNTER int(18) DEFAULT 0, START_COUNTER int(18) DEFAULT 0, PRIMARY KEY (ID), KEY IX_IM_REL_2 (USER_ID, MESSAGE_TYPE, STATUS), KEY IX_IM_REL_3 (USER_ID, MESSAGE_TYPE, CHAT_ID), KEY IX_IM_REL_4 (USER_ID, STATUS), KEY IX_IM_REL_5 (MESSAGE_TYPE, STATUS), KEY IX_IM_REL_6 (CHAT_ID, USER_ID), KEY IX_IM_REL_8 (STATUS, COUNTER) ); CREATE TABLE b_im_recent( USER_ID int(18) not null, ITEM_TYPE char(1) default 'P' not null, ITEM_ID int(18) not null, ITEM_MID int(18) not null, ITEM_CID int(18) DEFAULT 0, ITEM_RID int(18) DEFAULT 0, ITEM_OLID int(18) DEFAULT 0, PINNED char(1) DEFAULT 'N', UNREAD char(1) DEFAULT 'N', DATE_MESSAGE datetime null, DATE_UPDATE datetime null, PRIMARY KEY (USER_ID, ITEM_TYPE, ITEM_ID), KEY IX_IM_REC_1 (ITEM_TYPE, ITEM_ID), KEY IX_IM_REC_2 (DATE_UPDATE), KEY IX_IM_REC_3 (ITEM_RID), KEY IX_IM_REC_4 (ITEM_MID) ); CREATE TABLE b_im_last_search ( ID int(18) not null auto_increment, USER_ID int(18) not null, DIALOG_ID varchar(50) not null, ITEM_CID int(18) not null DEFAULT 0, ITEM_RID int(18) not null DEFAULT 0, PRIMARY KEY PK_B_IM_LAST_SEARCH (ID DESC), KEY IX_IM_LS_2 (USER_ID, DIALOG_ID) ); CREATE TABLE b_im_bot( BOT_ID int(18) not null, MODULE_ID VARCHAR(50) not null, CODE VARCHAR(50) not null, TYPE char(1) default 'B' not null, CLASS VARCHAR(255), LANG VARCHAR(50) default '', METHOD_BOT_DELETE VARCHAR(255), METHOD_MESSAGE_ADD VARCHAR(255), METHOD_MESSAGE_UPDATE VARCHAR(255), METHOD_MESSAGE_DELETE VARCHAR(255), METHOD_WELCOME_MESSAGE VARCHAR(255), TEXT_PRIVATE_WELCOME_MESSAGE text, TEXT_CHAT_WELCOME_MESSAGE text, COUNT_COMMAND int(18) DEFAULT 0, COUNT_MESSAGE int(18) DEFAULT 0, COUNT_CHAT int(18) DEFAULT 0, COUNT_USER int(18) DEFAULT 0, APP_ID varchar(128) NULL, VERIFIED char(1) DEFAULT 'N', OPENLINE char(1) DEFAULT 'N', PRIMARY KEY PK_B_IM_BOT (BOT_ID) ); CREATE TABLE b_im_bot_chat( ID int(18) not null auto_increment, BOT_ID int(18) not null, CHAT_ID int(18) not null, PRIMARY KEY PK_B_IM_BOT_CHAT (ID), KEY IX_IM_BC_1 (BOT_ID, CHAT_ID) ); CREATE TABLE b_im_bot_token( ID int(18) not null auto_increment, TOKEN varchar(32) null, DATE_CREATE datetime not null, DATE_EXPIRE datetime null, BOT_ID int(18) default 0, DIALOG_ID varchar(255) not null, PRIMARY KEY PK_B_IM_BOT_TOKEN (ID), KEY IX_IM_BOT_TOKEN_1 (DATE_EXPIRE, BOT_ID), KEY IX_IM_BOT_TOKEN_2 (TOKEN) ); CREATE TABLE b_im_command( ID int(18) not null auto_increment, MODULE_ID VARCHAR(50) not null, BOT_ID int(18) default 0, APP_ID varchar(128) NULL, COMMAND varchar(255) not null, COMMON char(1) default 'N', HIDDEN char(1) default 'N', EXTRANET_SUPPORT char(1) default 'N', SONET_SUPPORT char(1) default 'N', CLASS VARCHAR(255) null, METHOD_COMMAND_ADD VARCHAR(255) null, METHOD_LANG_GET VARCHAR(255) null, PRIMARY KEY PK_B_IM_COMMAND (ID), KEY IX_IM_COMMAND_1 (BOT_ID) ); CREATE TABLE b_im_command_lang ( ID int(18) not null auto_increment, COMMAND_ID int(18) not null, LANGUAGE_ID char(2) not null, TITLE varchar(255) null, PARAMS varchar(255) null, PRIMARY KEY PK_B_IM_COMMAND_LANG (ID), UNIQUE UX_B_IM_COMMAND_LANG (COMMAND_ID, LANGUAGE_ID) ); CREATE TABLE b_im_app( ID int(18) not null auto_increment, MODULE_ID VARCHAR(50) not null, BOT_ID int(18) default 0, APP_ID varchar(128) NULL, CODE varchar(255) not null, HASH varchar(32) NULL, REGISTERED varchar(32) default 'N', ICON_FILE_ID int(18) null, CONTEXT varchar(128) NULL, IFRAME varchar(255) null, IFRAME_WIDTH int(18) null, IFRAME_HEIGHT int(18) null, IFRAME_POPUP char(1) default 'N', JS varchar(255) null, HIDDEN char(1) default 'N', EXTRANET_SUPPORT char(1) default 'N', LIVECHAT_SUPPORT char(1) default 'N', CLASS VARCHAR(255) null, METHOD_LANG_GET VARCHAR(255) null, PRIMARY KEY PK_B_IM_APP (ID), KEY IX_IM_APP_1 (BOT_ID) ); CREATE TABLE b_im_app_lang ( ID int(18) not null auto_increment, APP_ID int(18) not null, LANGUAGE_ID char(2) not null, TITLE varchar(255) null, DESCRIPTION varchar(255) null, COPYRIGHT varchar(255) null, PRIMARY KEY PK_B_APP_LANG (ID), UNIQUE UX_B_APP_LANG (APP_ID, LANGUAGE_ID) ); CREATE TABLE b_im_alias ( ID int(18) not null auto_increment, ALIAS varchar(255) not null, DATE_CREATE datetime, ENTITY_TYPE varchar(255) not null, ENTITY_ID varchar(255) not null, PRIMARY KEY PK_B_IM_ALIAS (ID), UNIQUE UX_B_IM_ALIAS (ALIAS), INDEX IX_IM_ALIAS_2 (ENTITY_TYPE(100), ENTITY_ID(100)) ); CREATE TABLE b_im_external_avatar ( ID int(11) NOT NULL auto_increment, LINK_MD5 varchar(32) NOT NULL, AVATAR_ID int(11) NOT NULL, PRIMARY KEY PK_B_IM_EXTERNAL_AVATAR (ID), KEY IX_IMOL_NA_1 (LINK_MD5) ); CREATE TABLE b_im_no_relation_permission_disk ( ID int(11) NOT NULL auto_increment, CHAT_ID int(18) null, USER_ID int(18) null, ACTIVE_TO datetime null, PRIMARY KEY PK_B_IM_NO_RELATION_PERMISSION_DISK (ID), KEY IX_IM_USER_ID_CHAT_ID (USER_ID, CHAT_ID) ); CREATE TABLE b_im_call ( ID int not null auto_increment, TYPE int, INITIATOR_ID int, IS_PUBLIC char(1) not null default 'N', PUBLIC_ID varchar(32), PROVIDER varchar(32), ENTITY_TYPE varchar(32), ENTITY_ID varchar(32), PARENT_ID int, STATE varchar(50), START_DATE datetime, END_DATE datetime, CHAT_ID int, LOG_URL varchar(2000), PRIMARY KEY PK_B_IM_CALL(ID), UNIQUE KEY IX_B_IM_CALL_PID(PUBLIC_ID), INDEX IX_B_IM_CALL_ENT_ID_2(ENTITY_TYPE, ENTITY_ID, TYPE, PROVIDER, END_DATE), INDEX IX_B_IM_CALL_CHAT_ID(CHAT_ID) ); CREATE TABLE b_im_call_user ( CALL_ID int not null, USER_ID int not null, STATE varchar(50), FIRST_JOINED datetime, LAST_SEEN datetime, IS_MOBILE char(1), SHARED_SCREEN char(1), RECORDED char(1), PRIMARY KEY PK_B_IM_CALL_USER(CALL_ID, USER_ID) ); CREATE TABLE b_im_permission ( ID int(18) not null auto_increment, CHAT_ID int(18) DEFAULT 0, USER_ID int(18) DEFAULT 0, DATE_CREATE datetime not null, AUTHOR_ID int(18) DEFAULT 0, PERM_USER_PROMOTE char(1) DEFAULT 'N', PERM_CHAT_INFO char(1) DEFAULT 'N', PERM_USER_ADD char(1) DEFAULT 'N', PERM_USER_REMOVE char(1) DEFAULT 'N', PERM_MESSAGE_SEND char(1) DEFAULT 'N', PERM_MESSAGE_EDIT char(1) DEFAULT 'N', PERM_MESSAGE_DELETE char(1) DEFAULT 'N', PERM_MESSAGE_RICH char(1) DEFAULT 'N', PERM_MESSAGE_PIN char(1) DEFAULT 'N', PERM_MESSAGE_POLL char(1) DEFAULT 'N', PRIMARY KEY PK_B_IM_PERMISSION (ID), KEY IX_IM_PERM_1 (CHAT_ID, USER_ID) ); CREATE TABLE b_im_permission_duration ( ID int(18) not null auto_increment, PERMISSION_ID int(18) DEFAULT 0, DATE_REMOVE datetime not null, PRIMARY KEY PK_B_IM_PERMISSION_DURATION (ID), KEY IX_IM_PERM_DUR_1 (PERMISSION_ID), KEY IX_IM_PERM_DUR_2 (DATE_REMOVE) ); CREATE TABLE b_im_permission_log ( ID int(18) not null auto_increment, CHAT_ID int(18) DEFAULT 0, USER_ID int(18) not null, TEXT char(1) DEFAULT 'N', DATE_CREATE datetime not null, PRIMARY KEY PK_B_IM_PERMISSION_LOG (ID), KEY IX_IM_PERM_LOG_1 (CHAT_ID, USER_ID), KEY IX_IM_PERM_LOG_2 (DATE_CREATE) ); CREATE TABLE b_im_block_user( ID int(18) not null auto_increment, CHAT_ID int(18) not null, USER_ID int(18) not null, BLOCK_DATE datetime default null, PRIMARY KEY PK_B_IM_BLOCK_USER (ID) ); CREATE TABLE b_im_conference( ID int(18) not null auto_increment, ALIAS_ID int(18) not null, PASSWORD text, INVITATION text, IS_BROADCAST char(1) not null default 'N', CONFERENCE_START datetime, CONFERENCE_END datetime, PRIMARY KEY PK_B_IM_CONFERENCE(ID) ); CREATE TABLE b_im_conference_user_role( CONFERENCE_ID int not null, USER_ID int not null, ROLE varchar(64), PRIMARY KEY PK_B_IM_CONFERENCE_USER_ROLE(CONFERENCE_ID, USER_ID) ); CREATE TABLE b_im_option_group( `ID` INT UNSIGNED AUTO_INCREMENT, `NAME` VARCHAR(255) NULL, `USER_ID` INT UNSIGNED NULL, `SORT` INT UNSIGNED NOT NULL, `DATE_CREATE` DATETIME NOT NULL, `CREATE_BY_ID` INT UNSIGNED NOT NULL, `DATE_MODIFY` DATETIME NULL, `MODIFY_BY_ID` INT UNSIGNED NULL, PRIMARY KEY `PK_B_IM_OPTION_GROUP` (`ID`) ); CREATE TABLE b_im_option_state( `GROUP_ID` INT UNSIGNED NOT NULL, `NAME` VARCHAR(64) NOT NULL , `VALUE` VARCHAR(255) NULL, PRIMARY KEY `PK_B_IM_OPTION_STATE` (`GROUP_ID`, `NAME`) ); CREATE TABLE b_im_option_access( `ID` INT UNSIGNED AUTO_INCREMENT, `GROUP_ID` INT UNSIGNED NOT NULL, `ACCESS_CODE` VARCHAR(100), PRIMARY KEY `PK_B_IM_OPTION_ACCESS` (`ID`), UNIQUE INDEX `UX_B_IM_OPTION_ACCESS_1` (`GROUP_ID`, `ACCESS_CODE`) ); CREATE TABLE b_im_option_user( `USER_ID` INT UNSIGNED NOT NULL, `NOTIFY_GROUP_ID` INT UNSIGNED NOT NULL, `GENERAL_GROUP_ID` INT UNSIGNED NOT NULL, PRIMARY KEY `PK_B_IM_OPTION_USER` (`USER_ID`) ); CREATE TABLE b_im_message_uuid( `UUID` VARCHAR(36) NOT NULL, `MESSAGE_ID` INT UNSIGNED NULL, `DATE_CREATE` DATETIME NOT NULL, PRIMARY KEY `PK_B_IM_MESSAGE_UUID` (`UUID`), INDEX `UX_B_IM_MESSAGE_DATE_CREATE` (`DATE_CREATE`), INDEX `UX_B_IM_MESSAGE_UUID_MESSAGE_ID` (`MESSAGE_ID`) );

| ver. 1.4 | Github | . | PHP 7.4.33 | Generation time: 0.27 | proxy | phpinfo | Settings