Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save softsolution/0fe8bf099ebc1d38c36a to your computer and use it in GitHub Desktop.
Save softsolution/0fe8bf099ebc1d38c36a to your computer and use it in GitHub Desktop.
UPDATE cms_geo_regions SET name='Крым и Севастополь', country_id = '3159' WHERE id = 10227;
UPDATE cms_geo_cities SET country_id = '3159' WHERE region_id = 10227;
UPDATE cms_geo_cities SET name = 'Гусь-Хрустальный' WHERE id = 3451;
INSERT INTO `cms_geo_cities` (`country_id`, `region_id`, `name`) VALUES ('3159', '3784', 'Весьегонск');
INSERT INTO `cms_geo_cities` (`country_id`, `region_id`, `name`) VALUES ('3159', '5191', 'Лермонтов');
INSERT INTO `cms_geo_cities` (`country_id`, `region_id`, `name`) VALUES ('3159', '4861', 'Новомичуринск');
INSERT INTO `cms_geo_cities` (`country_id`, `region_id`, `name`) VALUES ('3159', '3827', 'Городовиковск');
INSERT INTO `cms_geo_cities` (`country_id`, `region_id`, `name`) VALUES ('3159', '3827', 'Лагань');
INSERT INTO `cms_geo_cities` (`country_id`, `region_id`, `name`) VALUES ('3159', '3296', 'Межгорье');
INSERT INTO `cms_geo_cities` (`country_id`, `region_id`, `name`) VALUES ('3159', '3296', 'Агидель');
INSERT INTO `cms_geo_cities` (`country_id`, `region_id`, `name`) VALUES ('3159', '4503', 'Великий Новгород');
INSERT INTO `cms_geo_cities` (`country_id`, `region_id`, `name`) VALUES ('3159', '4481', 'Островной');
INSERT INTO `cms_geo_cities` (`country_id`, `region_id`, `name`) VALUES ('3159', '4481', 'Гаджиево');
INSERT INTO `cms_geo_cities` (`country_id`, `region_id`, `name`) VALUES ('3159', '4312', 'Юбилейный');
UPDATE cms_geo_cities SET name = 'Наро-Фоминск' WHERE id = 4403;
INSERT INTO `cms_geo_cities` (`country_id`, `region_id`, `name`) VALUES ('3159', '4227', 'Данков');
INSERT INTO `cms_geo_cities` (`country_id`, `region_id`, `name`) VALUES ('3159', '4052', 'Новокубанск');
INSERT INTO `cms_geo_cities` (`country_id`, `region_id`, `name`) VALUES ('3159', '4052', 'Гулькевичи');
INSERT INTO `cms_geo_cities` (`country_id`, `region_id`, `name`) VALUES ('3159', '3952', 'Сосновка');
INSERT INTO `cms_geo_cities` (`country_id`, `region_id`, `name`) VALUES ('3159', '3952', 'Полысаево');
INSERT INTO `cms_geo_cities` (`country_id`, `region_id`, `name`) VALUES ('3159', '3841', 'Сосенский');
INSERT INTO `cms_geo_cities` (`country_id`, `region_id`, `name`) VALUES ('3159', '3761', 'Ладушкин');
INSERT INTO `cms_geo_cities` (`country_id`, `region_id`, `name`) VALUES ('3159', '5600', 'Козловка');
INSERT INTO `cms_geo_cities` (`country_id`, `region_id`, `name`) VALUES ('3159', '5507', 'Южноуральск');
INSERT INTO `cms_geo_cities` (`country_id`, `region_id`, `name`) VALUES ('3159', '5507', 'Миньяр');
INSERT INTO `cms_geo_cities` (`country_id`, `region_id`, `name`) VALUES ('3159', '5507', 'Нязепетровск');
INSERT INTO `cms_geo_cities` (`country_id`, `region_id`, `name`) VALUES ('3159', '3371', 'Сельцо');
INSERT INTO `cms_geo_cities` (`country_id`, `region_id`, `name`) VALUES ('3159', '3282', 'Нариманов');
UPDATE cms_geo_cities SET name = 'Голицыно' WHERE id = 4338;
UPDATE cms_geo_cities SET name = 'Дзержинский' WHERE id = 4341;
UPDATE cms_geo_cities SET name = 'Гаврилов-Ям' WHERE id = 5634;
@softsolution
Copy link
Author

Регион Украина?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment