File manager - Edit - /home/c14075/dragmet-ural.ru/www/bitrix/ammina/regions/db/sypexgeo/info/import.sql
Back
DROP TABLE IF EXISTS `sxgeo_cities`; CREATE TABLE IF NOT EXISTS `sxgeo_cities` ( `id` mediumint(8) unsigned NOT NULL, `region_id` mediumint(8) unsigned NOT NULL, `name_ru` varchar(128) NOT NULL, `name_en` varchar(128) NOT NULL, `lat` decimal(10,5) NOT NULL, `lon` decimal(10,5) NOT NULL, `okato` varchar(20) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Информация о городах для SxGeo 2.2'; DROP TABLE IF EXISTS `sxgeo_regions`; CREATE TABLE IF NOT EXISTS `sxgeo_regions` ( `id` mediumint(8) unsigned NOT NULL, `iso` varchar(7) NOT NULL, `country` char(2) NOT NULL, `name_ru` varchar(128) NOT NULL, `name_en` varchar(128) NOT NULL, `timezone` varchar(30) NOT NULL, `okato` char(4) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Информация о регионах для SxGeo 2.2'; DROP TABLE IF EXISTS `sxgeo_country`; CREATE TABLE IF NOT EXISTS `sxgeo_country` ( `id` tinyint(3) unsigned NOT NULL, `iso` char(2) NOT NULL, `continent` char(2) NOT NULL, `name_ru` varchar(128) NOT NULL, `name_en` varchar(128) NOT NULL, `lat` decimal(6,2) NOT NULL, `lon` decimal(6,2) NOT NULL, `timezone` varchar(30) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Информация о странах для SxGeo 2.2';
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0.26 |
proxy
|
phpinfo
|
Settings