%PDF- %PDF-
Server IP : 37.220.80.31 / Your IP : 3.15.15.217 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/report/install/db/mysql/ |
Upload File : |
CREATE TABLE `b_report` ( `ID` int(11) unsigned NOT NULL AUTO_INCREMENT, `OWNER_ID` varchar(20) NULL, `TITLE` varchar(255) NOT NULL, `DESCRIPTION` text NULL, `CREATED_DATE` datetime NOT NULL, `CREATED_BY` int(11) unsigned NOT NULL, `SETTINGS` text NULL, `MARK_DEFAULT` smallint unsigned NULL, PRIMARY KEY (`ID`), KEY `OWNER_ID` (`OWNER_ID`) ); CREATE TABLE IF NOT EXISTS `b_report_sharing` ( ID int(11) NOT NULL AUTO_INCREMENT, REPORT_ID int(11) NOT NULL DEFAULT 0, ENTITY varchar(50) NOT NULL, RIGHTS varchar(50) NOT NULL, PRIMARY KEY (ID), INDEX IX_ENTITY (ENTITY), INDEX IX_REPORT_ID (REPORT_ID) ); CREATE TABLE IF NOT EXISTS `b_report_visual_report_widget` ( ID int (11) NOT NULL AUTO_INCREMENT, GID varchar(255) NOT NULL, VIEW_KEY varchar(255) NOT NULL, WIDGET_CLASS varchar(255) NOT NULL, BOARD_ID varchar(255) NOT NULL, DASHBOARD_ROW_ID int(11) NOT NULL, WEIGHT varchar(25) NOT NULL DEFAULT "", CATEGORY_KEY varchar(255) NOT NULL DEFAULT "", OWNER_ID INT DEFAULT 0 NOT NULL, IS_PATTERN BOOLEAN DEFAULT false, PARENT_WIDGET_ID INT DEFAULT 0 NOT NULL, CREATED_DATE datetime NOT NULL, UPDATED_DATE datetime NOT NULL, PRIMARY KEY (ID), INDEX IX_BOARD_ID (BOARD_ID) ); CREATE TABLE IF NOT EXISTS `b_report_visual_report_entity` ( ID int(11) NOT NULL AUTO_INCREMENT, GID varchar(255) NOT NULL, WIDGET_ID int(11) NOT NULL, WEIGHT int(4) NOT NULL DEFAULT 0, REPORT_CLASS varchar(255), CREATED_DATE datetime NOT NULL, UPDATED_DATE datetime NOT NULL, PRIMARY KEY (ID), INDEX IX_WIDGET_ID (WIDGET_ID) ); CREATE TABLE IF NOT EXISTS `b_report_visual_report_configuration` ( ID int(11) NOT NULL AUTO_INCREMENT, GID varchar(255) NOT NULL, WEIGHT int(4) NOT NULL DEFAULT 0, CREATED_DATE datetime NOT NULL, UPDATED_DATE datetime NOT NULL, UKEY varchar(255) NOT NULL, CONFIGURATION_FIELD_CLASS varchar(255) NOT NULL, SETTINGS text NULL, PRIMARY KEY (ID) ); CREATE TABLE IF NOT EXISTS `b_report_visual_report_entity_config` ( REPORT_ID int(11) NOT NULL, CONFIGURATION_ID int(11) NOT NULL, PRIMARY KEY (REPORT_ID, CONFIGURATION_ID), INDEX IX_CONFIG_REPORT (CONFIGURATION_ID, REPORT_ID) ); CREATE TABLE IF NOT EXISTS `b_report_visual_report_widget_config` ( WIDGET_ID int(11) NOT NULL, CONFIGURATION_ID int(11) NOT NULL, PRIMARY KEY (WIDGET_ID, CONFIGURATION_ID), INDEX IX_CONFIG_WIDGET (CONFIGURATION_ID, WIDGET_ID) ); CREATE TABLE IF NOT EXISTS `b_report_visual_report_dashboard_row` ( ID int(11) NOT NULL AUTO_INCREMENT, GID varchar(255) NOT NULL, BOARD_ID int(11) NOT NULL, WEIGHT int(4) NOT NULL DEFAULT 0, CREATED_DATE datetime NOT NULL, UPDATED_DATE datetime NOT NULL, LAYOUT_MAP TEXT NOT NULL, PRIMARY KEY (ID) ); CREATE TABLE IF NOT EXISTS `b_report_visual_report_dashboard` ( ID int(11) NOT NULL AUTO_INCREMENT, GID varchar(255) NOT NULL, VERSION varchar(255) NOT NULL DEFAULT '', BOARD_KEY varchar(255) NOT NULL, USER_ID INT DEFAULT 0 NOT NULL, CREATED_DATE datetime NOT NULL, UPDATED_DATE datetime NOT NULL, PRIMARY KEY (ID) );