%PDF- %PDF-
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`) );