/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!50503 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `russian_federation_regions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `russian_federation_regions` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=90 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `russian_federation_regions` WRITE; /*!40000 ALTER TABLE `russian_federation_regions` DISABLE KEYS */; INSERT INTO `russian_federation_regions` VALUES (1,'Adygeya, Respublika'),(2,'Aginskiy Buryatskiy avtonomnyy'),(3,'Altay, Respublika'),(4,'Altayskiy kray'),(5,'Amurskaya oblast\''),(6,'Arkhangel\'skaya oblast\''),(7,'Astrakhanskaya oblast\''),(8,'Bashkortostan, Respublika'),(9,'Belgorodskaya oblast\''),(10,'Bryanskaya oblast\''),(11,'Buryatiya, Respublika'),(12,'Chechenskaya Respublika'),(13,'Chelyabinskaya oblast\''),(14,'Chitinskaya oblast\''),(15,'Chukotskiy avtonomnyy okrug'),(16,'Chuvashskaya Respublika'),(17,'Dagestan, Respublika'),(18,'Evenkiyskiy avtonomnyy okrug'),(19,'Ingushskaya Respublika'),(20,'Irkutskaya oblast\''),(21,'Ivanovskaya oblast\''),(22,'Kabardino-Balkarskaya'),(23,'Kaliningradskaya oblast\''),(24,'Kalmykiya, Respublika'),(25,'Kaluzhskaya oblast\''),(26,'Kamchatskaya oblast\''),(27,'Karachayevo-Cherkesskaya Respublika'),(28,'Kareliya, Respublika'),(29,'Kemerovskaya oblast\''),(30,'Khabarovskiy kray'),(31,'Khakasiya, Respublika'),(32,'Khanty-Mansiyskiy avtonomnyy okrug'),(33,'Kirovskaya oblast\''),(34,'Komi-Permyatskiy avtonomnyy okrug'),(35,'Komi, Respublika'),(36,'Koryakskiy avtonomnyy okrug'),(37,'Kostromskaya oblast\''),(38,'Krasnodarskiy kray'),(39,'Krasnoyarskiy kray'),(40,'Kurganskaya oblast\''),(41,'Kurskaya oblast\''),(42,'Leningradskaya oblast\''),(43,'Lipetskaya oblast\''),(44,'Magadanskaya oblast\''),(45,'Mariy El, Respublika'),(46,'Mordoviya, Respublika'),(47,'Moskovskaya oblast\''),(48,'Moskva'),(49,'Murmanskaya oblast\''),(50,'Nenetskiy avtonomnyy okrug'),(51,'Nizhegorodskaya oblast\''),(52,'Novgorodskaya oblast\''),(53,'Novosibirskaya oblast\''),(54,'Omskaya oblast\''),(55,'Orenburgskaya oblast\''),(56,'Orlovskaya oblast\''),(57,'Penzenskaya oblast\''),(58,'Permskaya oblast\''),(59,'Primorskiy kray'),(60,'Pskovskaya oblast\''),(61,'Rostovskaya oblast\''),(62,'Ryazanskaya oblast\''),(63,'Sakha, Respublika [Yakutiya]'),(64,'Sakhalinskaya oblast\''),(65,'Samarskaya oblast\''),(66,'Sankt-Peterburg'),(67,'Saratovskaya oblast\''),(68,'Severnaya Osetiya, Respublika'),(69,'Smolenskaya oblast\''),(70,'Stavropol\'skiy kray'),(71,'Sverdlovskaya oblast\''),(72,'Tambovskaya oblast\''),(73,'Tatarstan, Respublika'),(74,'Taymyrskiy (Dolgano-Nenetskiy)'),(75,'Tomskaya oblast\''),(76,'Tul\'skaya oblast\''),(77,'Tverskaya oblast\''),(78,'Tyumenskaya oblast\''),(79,'Tyva, Respublika [Tuva]'),(80,'Udmurtskaya Respublika'),(81,'Ul\'yanovskaya oblast\''),(82,'Ust\'-Ordynskiy Buryatskiy'),(83,'Vladimirskaya oblast\''),(84,'Volgogradskaya oblast\''),(85,'Vologodskaya oblast\''),(86,'Voronezhskaya oblast\''),(87,'Yamalo-Nenetskiy avtonomnyy okrug'),(88,'Yaroslavskaya oblast\''),(89,'Yevreyskaya avtonomnaya oblast\''); /*!40000 ALTER TABLE `russian_federation_regions` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;