| Server IP : 37.220.80.31 / Your IP : 52.15.52.31 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/location/install/db/mysql/ |
Upload File : |
CREATE TABLE IF NOT EXISTS b_location(
`ID` INT NOT NULL AUTO_INCREMENT,
`CODE` VARCHAR(100) NOT NULL,
`EXTERNAL_ID` VARCHAR(255) NULL,
`SOURCE_CODE` VARCHAR(15) NULL,
`LATITUDE` DECIMAL(8, 6) NULL,
`LONGITUDE` DECIMAL(9, 6) NULL,
`TIMESTAMP_X` TIMESTAMP NOT NULL,
`TYPE` INT NOT NULL,
PRIMARY KEY (`ID`),
UNIQUE INDEX (`CODE`),
UNIQUE INDEX IX_LOC_SE(`EXTERNAL_ID`, `SOURCE_CODE`),
INDEX IX_LOC_LAT(`LATITUDE`),
INDEX IX_LOC_LON(`LONGITUDE`),
INDEX IX_LOC_T(`TYPE`)
);
CREATE TABLE IF NOT EXISTS b_location_name(
`LOCATION_ID` INT NOT NULL,
`LANGUAGE_ID` CHAR(2) NOT NULL,
`NAME` VARCHAR(1000) NOT NULL,
`NAME_NORMALIZED` VARCHAR(1000) NOT NULL,
PRIMARY KEY (`LOCATION_ID`,`LANGUAGE_ID`),
INDEX IX_LOC_LNN(`NAME_NORMALIZED`(200), `LANGUAGE_ID`)
);
CREATE TABLE IF NOT EXISTS b_location_hierarchy(
`ANCESTOR_ID` INT NOT NULL,
`DESCENDANT_ID` INT NOT NULL,
`LEVEL` INT NOT NULL,
PRIMARY KEY (`ANCESTOR_ID`, `DESCENDANT_ID`),
INDEX IX_LOC_LH_D(`DESCENDANT_ID`)
);
CREATE TABLE IF NOT EXISTS b_location_field(
`LOCATION_ID` INT NOT NULL,
`TYPE` INT NOT NULL,
`VALUE` VARCHAR(255) NULL,
PRIMARY KEY (`LOCATION_ID`, `TYPE`),
INDEX IDX_BLLFL_VAL(`VALUE`)
);
CREATE TABLE IF NOT EXISTS b_location_address(
`ID` INT NOT NULL AUTO_INCREMENT,
`LOCATION_ID` INT DEFAULT 0,
`LANGUAGE_ID` CHAR(2) NOT NULL,
`LATITUDE` DECIMAL(8, 6) NULL,
`LONGITUDE` DECIMAL(9, 6) NULL,
PRIMARY KEY (`ID`),
INDEX IX_LOC_BLA_LOC(`LOCATION_ID`)
);
CREATE TABLE IF NOT EXISTS b_location_addr_fld(
`ADDRESS_ID` INT NOT NULL,
`TYPE` INT NOT NULL,
`VALUE` VARCHAR(1024) NULL,
`VALUE_NORMALIZED` VARCHAR(1024) NULL,
PRIMARY KEY (`ADDRESS_ID`, `TYPE`),
INDEX IDX_BLAFL_VAL(`VALUE`),
INDEX IX_LOC_LNN(`VALUE_NORMALIZED`(200))
);
CREATE TABLE IF NOT EXISTS b_location_addr_link(
`ADDRESS_ID` INT NOT NULL,
`ENTITY_ID` VARCHAR(100) NOT NULL,
`ENTITY_TYPE` VARCHAR(50) NOT NULL,
PRIMARY KEY (`ADDRESS_ID`, `ENTITY_ID`, `ENTITY_TYPE`),
INDEX IDX_BLAL_EI_ET(`ENTITY_ID`, `ENTITY_TYPE`)
);
CREATE TABLE IF NOT EXISTS b_location_source(
`CODE` VARCHAR(15) NOT NULL,
`NAME` VARCHAR(255) NOT NULL,
`CONFIG` longtext,
PRIMARY KEY (`CODE`)
);