| 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)
);