File manager - Edit - /home/c14075/dragmet-ural.ru/www/bitrix/modules/ammina.regions/install/db/mysql/to.1.6.0.sql
Back
CREATE TABLE IF NOT EXISTS `am_regions_country_lang` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `COUNTRY_ID` int(11) NOT NULL, `LID` char(2) NOT NULL, `NAME` varchar(255) NOT NULL, PRIMARY KEY (`ID`), KEY `IX_COUNTRYLID` (`COUNTRY_ID`,`LID`), KEY `IX_LIDNAME` (`LID`,`NAME`) ); INSERT INTO am_regions_country_lang (`COUNTRY_ID`, `LID`, `NAME`) (SELECT `ID`, 'en', `NAME_EN` FROM `am_regions_country`); ALTER TABLE `am_regions_country` DROP `NAME_EN`, CHANGE `NAME_RU` `NAME` VARCHAR(255) NULL DEFAULT NULL; CREATE TABLE IF NOT EXISTS `am_regions_region_lang` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `REGION_ID` int(11) NOT NULL, `LID` char(2) NOT NULL, `NAME` varchar(255) NOT NULL, PRIMARY KEY (`ID`), KEY `IX_REGIONLID` (`REGION_ID`,`LID`), KEY `IX_LIDNAME` (`LID`,`NAME`) ); INSERT INTO am_regions_region_lang (`REGION_ID`, `LID`, `NAME`) (SELECT `ID`, 'en', `NAME_EN` FROM `am_regions_region`); ALTER TABLE `am_regions_region` DROP `NAME_EN`, CHANGE `NAME_RU` `NAME` VARCHAR(255) NULL DEFAULT NULL; CREATE TABLE IF NOT EXISTS `am_regions_city_lang` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `CITY_ID` int(11) NOT NULL, `LID` char(2) NOT NULL, `NAME` varchar(255) NOT NULL, PRIMARY KEY (`ID`), KEY `IX_CITYLID` (`CITY_ID`,`LID`), KEY `IX_LIDNAME` (`LID`,`NAME`) ); INSERT INTO am_regions_city_lang (`CITY_ID`, `LID`, `NAME`) (SELECT `ID`, 'en', `NAME_EN` FROM `am_regions_city`); ALTER TABLE `am_regions_city` DROP `NAME_EN`, CHANGE `NAME_RU` `NAME` VARCHAR(255) NULL DEFAULT NULL; ALTER TABLE `am_regions_domain` ADD `NAME_LANG` LONGTEXT NULL DEFAULT NULL AFTER `NAME`; ALTER TABLE `am_regions_domain_var` ADD `VALUE_LANG` LONGTEXT NULL DEFAULT NULL AFTER `VALUE`; ALTER TABLE `am_regions_content` ADD `CONTENT_LANG` LONGTEXT NULL DEFAULT NULL AFTER `CONTENT`;
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0.27 |
proxy
|
phpinfo
|
Settings