/*!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.6.18-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: ais
-- ------------------------------------------------------
-- Server version	10.6.18-MariaDB-0ubuntu0.22.04.1

/*!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 */;
/*!40101 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 */;

--
-- Table structure for table `countries`
--

DROP TABLE IF EXISTS `countries`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `countries` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `region` varchar(191) DEFAULT NULL,
  `code` char(2) DEFAULT NULL,
  `name` varchar(191) DEFAULT NULL,
  `name_ru` varchar(191) DEFAULT NULL,
  `flag` varchar(191) DEFAULT NULL,
  `is_bio` tinyint(1) NOT NULL DEFAULT 0,
  `is_notify` tinyint(1) DEFAULT 0,
  `is_parsing_fd` tinyint(1) DEFAULT 1,
  `count_fake` int(11) NOT NULL DEFAULT 0,
  `count_real` int(11) NOT NULL DEFAULT 0,
  `count_fake_r` int(11) NOT NULL DEFAULT 0,
  `count_real_r` int(11) NOT NULL DEFAULT 0,
  `comments` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `countries_code_unique` (`code`),
  KEY `countries_region_index` (`region`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `countries`
--

LOCK TABLES `countries` WRITE;
/*!40000 ALTER TABLE `countries` DISABLE KEYS */;
INSERT INTO `countries` VALUES (1,'America','ar','Argentina','Аргентина','🇦🇷',0,0,0,260,0,0,0,NULL),(2,'America','bs','Bahamas','Багамы','🇧🇸',0,0,0,81,0,0,0,NULL),(3,'America','bb','Barbados','Барбадос','🇧🇧',0,0,0,82,0,0,0,NULL),(4,'America','bz','Belize','Белиз','🇧🇿',0,0,0,80,0,0,0,NULL),(5,'America','br','Brazil','Бразилия','🇧🇷',1,0,0,281,0,0,0,NULL),(6,'America','bo','Bolivia','Боливия','🇧🇴',0,0,0,80,0,0,0,NULL),(7,'America','ca','Canada','Канада','🇨🇦',1,1,1,2109,0,2094,1,NULL),(8,'America','cl','Chile','Чили','🇨🇱',0,0,0,150,0,0,0,NULL),(9,'America','co','Colombia','Колумбия','🇨🇴',1,0,0,1268,0,0,0,NULL),(10,'America','ec','Ecuador','Эквадор','🇪🇨',1,1,1,186,0,0,0,NULL),(11,'America','gy','Guyana','Гайана','🇬🇾',0,0,0,39,0,0,0,NULL),(12,'America','jm','Jamaica','Ямайка','🇯🇲',0,0,0,80,0,0,0,NULL),(13,'America','mx','Mexico','Мексика','🇲🇽',1,0,0,3005,0,0,0,NULL),(14,'America','py','Paraguay','Парагвай','🇵🇾',0,0,0,108,0,0,0,NULL),(15,'America','pe','Peru','Перу','🇵🇪',0,0,0,599,0,0,0,NULL),(16,'America','tt','Trinidad and Tobago','Тринидад и Тобаго','🇹🇹',0,0,0,20,0,0,0,NULL),(17,'America','uy','Uruguay','Уругвай','🇺🇾',0,0,0,80,0,0,0,NULL),(18,'Europe','al','Albania','Албания','🇦🇱',0,0,0,82,0,0,0,NULL),(19,'Europe','am','Armenia','Армения','🇦🇲',0,0,0,4574,9,1070,0,NULL),(20,'Europe','az','Azerbaijan','Азербайджан','🇦🇿',0,0,0,1294,0,0,0,NULL),(21,'Europe','be','Belgium','Бельгия','🇧🇪',0,0,0,573,0,0,0,NULL),(22,'Europe','ba','Bosnia and Herzegovina','Босния и Герцеговина','🇧🇦',0,0,0,80,0,0,0,NULL),(23,'Europe','hr','Croatia','Хорватия','🇭🇷',0,0,0,1634,0,0,0,NULL),(24,'Europe','cy','Cyprus','Кипр','🇨🇾',0,0,0,180,0,0,0,'дети нужны \r\ninfonicosia@state.gov'),(25,'Europe','fr','France','Франция','🇫🇷',0,0,0,1838,2,0,0,'Дети до 14 не нужны\r\nPARISVISAINQUIRY@state.gov'),(26,'Europe','gr','Greece','Греция','🇬🇷',0,0,0,177,0,0,0,NULL),(27,'Europe','it','Italy','Италия','🇮🇹',0,0,0,1708,1,0,0,'Рим - RomeVisa@state.gov\r\nМилан - usvisamilan@state.gov\r\nНеаполь - NIVNaples@state.gov - дети нужны\r\nФлоренция - VisaFlorence@state.gov\r\nПереводчик по запросу'),(28,'Europe','ie','Ireland','Ирландия','🇮🇪',0,0,0,180,0,0,0,NULL),(29,'Europe','kv','Kosovo','Косово','🇽🇰',0,0,0,81,0,0,0,NULL),(30,'Europe','mk','North Macedonia','Македония','🇲🇰',0,0,0,80,0,0,0,NULL),(31,'Europe','nl','Netherlands','Нидерланды','🇳🇱',0,0,0,179,0,0,0,NULL),(32,'Europe','pt','Portugal','Португалия','🇵🇹',0,0,0,180,0,0,0,'ТЕСТ'),(33,'Europe','rs','Serbia','Сербия','🇷🇸',0,0,0,2346,3,0,0,NULL),(34,'Europe','es','Spain and Andorra','Испания','🇪🇸',0,0,0,5164,5,876,0,NULL),(35,'Europe','tr','Turkiye','Турция','🇹🇷',0,0,0,1884,1,567,1,'Без переводчика\r\nesee_contactus+tr+info+en@visaops.net'),(36,'Europe','gb','United Kingdom','Великобритания','🇬🇧',0,0,0,764,0,0,0,NULL),(37,'Middle East','il','Israel','Израиль','🇮🇱',0,0,0,2257,1,0,0,'set-up - Russia, no residence'),(38,'Middle East','ae','United Arab Emirates','ОАЭ','🇦🇪',0,0,0,2225,0,0,0,NULL),(39,'Middle East','ir','Iran','Иран','🇮🇷',0,0,0,0,0,0,0,NULL),(40,'Africa','ao','Angola','Ангола','🇦🇴',0,0,0,80,0,0,0,NULL),(41,'Africa','cm','Cameroon','Камерун','🇨🇲',0,0,0,80,0,0,0,NULL),(42,'Africa','cv','Cabo Verde','Кабо Верде','🇨🇻',0,0,0,80,0,0,0,NULL),(43,'Africa','cd','Democratic Republic of the Congo','Конго','🇨🇬',0,0,0,35,0,0,0,NULL),(44,'Africa','et','Ethiopia','Эфиопия','🇪🇹',0,0,0,20,0,0,0,NULL),(45,'Africa','ke','Kenya','Кения','🇰🇪',0,0,0,20,0,0,0,NULL),(46,'Africa','rw','Rwanda','Руанда','🇷🇼',0,0,0,20,0,0,0,NULL),(47,'Africa','sn','Senegal','Сенегал','🇸🇳',0,0,0,80,0,0,0,NULL),(48,'Africa','tz','Tanzania','Танзания','🇹🇿',0,0,0,20,0,0,0,NULL),(49,'Africa','za','South Africa','Южная Африка','🇿🇦',0,0,0,80,0,0,0,NULL),(50,'Africa','ug','Uganda','Уганда','🇺🇬',0,0,0,20,0,0,0,NULL),(51,'Africa','zm','Zambia','Замбия','🇿🇲',0,0,0,20,0,0,0,NULL),(52,'America','do','Dominican Republic','Доминиканская Республика','🇩🇴',0,0,1,468,0,0,0,NULL);
/*!40000 ALTER TABLE `countries` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cities`
--

DROP TABLE IF EXISTS `cities`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cities` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `country_id` bigint(20) unsigned DEFAULT NULL,
  `name` varchar(191) DEFAULT NULL,
  `name_ru` varchar(191) DEFAULT NULL,
  `is_notify` tinyint(1) NOT NULL DEFAULT 0,
  `count_clients` int(11) NOT NULL DEFAULT 0,
  `count_active` int(11) NOT NULL DEFAULT 0,
  `count_paused` int(11) NOT NULL DEFAULT 0,
  `count_hidden` int(11) NOT NULL DEFAULT 0,
  `last_parsing` int(11) DEFAULT NULL,
  `last_notify` int(11) DEFAULT NULL,
  `last_parsing_b1b2` int(11) DEFAULT NULL,
  `last_parsing_f1` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cities_country_id_foreign` (`country_id`),
  CONSTRAINT `cities_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cities`
--

LOCK TABLES `cities` WRITE;
/*!40000 ALTER TABLE `cities` DISABLE KEYS */;
INSERT INTO `cities` VALUES (1,42,'Praia','Прая',0,0,0,0,0,NULL,NULL,NULL,NULL),(2,32,'Lisbon','Лиссабон',0,0,0,0,0,NULL,NULL,NULL,NULL),(3,34,'Madrid','Мадрид',0,0,0,0,0,NULL,NULL,NULL,NULL),(4,27,'Florence','Флоренция',0,1,0,0,0,1683724539,NULL,1683724539,NULL),(5,27,'Milan','Милан',0,1,0,0,0,1683724540,NULL,1683724540,NULL),(6,27,'Naples','Неаполь',0,1,0,0,0,1683724542,NULL,1683724542,NULL),(7,27,'Rome','Рим',0,1,0,0,0,1683724543,NULL,1683724543,NULL),(8,28,'Dublin','Дублин',0,0,0,0,0,NULL,NULL,NULL,NULL),(9,36,'Belfast','Белфаст',0,0,0,0,0,NULL,NULL,NULL,NULL),(10,36,'London','Лондон',0,0,0,0,0,NULL,NULL,NULL,NULL),(11,44,'Addis Ababa','Аддис-Абеба',0,0,0,0,0,NULL,NULL,NULL,NULL),(12,40,'Luanda','Луанда',0,0,0,0,0,NULL,NULL,NULL,NULL),(13,30,'Skopje','Скопье',0,0,0,0,0,NULL,NULL,NULL,NULL),(14,9,'Bogota','Богота',0,0,0,0,0,NULL,NULL,NULL,NULL),(15,NULL,'Medellín','Медельин',0,0,0,0,0,NULL,NULL,NULL,NULL),(16,1,'Buenos Aires','Буэнос-Айрес',0,0,0,0,0,NULL,NULL,NULL,NULL),(17,21,'Brussels','Брюссель',0,0,0,0,0,NULL,NULL,NULL,NULL),(18,31,'Amsterdam','Амстердам',0,0,0,0,0,NULL,NULL,NULL,NULL),(19,25,'Paris','Париж',0,0,0,0,0,NULL,NULL,NULL,NULL),(20,41,'Yaounde','Яунде',0,0,0,0,0,NULL,NULL,NULL,NULL),(21,46,'Kigali','Кигали',0,0,0,0,0,NULL,NULL,NULL,NULL),(22,43,'Kinshasa','Киншаса',0,0,0,0,0,NULL,NULL,NULL,NULL),(23,47,'Dakar','Дакар',0,0,0,0,0,NULL,NULL,NULL,NULL),(24,38,'Abu Dhabi','Абу-Даби',0,0,0,0,0,NULL,NULL,NULL,NULL),(25,38,'Dubai','Дубай',0,0,0,0,0,NULL,NULL,NULL,NULL),(26,3,'Bridgetown','Бриджтаун',0,0,0,0,0,NULL,NULL,NULL,NULL),(27,2,'Nassau','Нассау',0,0,0,0,0,NULL,NULL,NULL,NULL),(28,12,'Kingston','Кингстон',0,0,0,0,0,NULL,NULL,NULL,NULL),(29,5,'Brasilia','Бразилиа',0,0,0,0,0,NULL,NULL,NULL,NULL),(30,5,'Rio de Janeiro','Рио-де-Жанейро',0,0,0,0,0,NULL,NULL,NULL,NULL),(31,5,'Sao Paulo','Сан-Паулу',0,0,0,0,0,NULL,NULL,NULL,NULL),(32,5,'Recife','Ресифи',0,0,0,0,0,NULL,NULL,NULL,NULL),(33,5,'Porto Alegre','Порту-Алегри',0,0,0,0,0,NULL,NULL,NULL,NULL),(34,NULL,'Santa Efigenia','Санта-Ифижения',0,0,0,0,0,NULL,NULL,NULL,NULL),(35,13,'Ciudad Juarez','Сьюдад-Хуарес',0,0,0,0,0,NULL,NULL,NULL,NULL),(36,13,'Guadalajara','Гвадалахара',0,0,0,0,0,NULL,NULL,NULL,NULL),(37,13,'Hermosillo','Эрмосильо',0,0,0,0,0,NULL,NULL,NULL,NULL),(38,13,'Matamoros','Матаморос',0,0,0,0,0,NULL,NULL,NULL,NULL),(39,13,'Merida','Мерида',0,0,0,0,0,NULL,NULL,NULL,NULL),(40,13,'Mexico City','Мехико',0,0,0,0,0,NULL,NULL,NULL,NULL),(41,NULL,'Santa Catarina','Санта-Катарина',0,0,0,0,0,NULL,NULL,NULL,NULL),(42,13,'Nogales','Ногалес',0,0,0,0,0,NULL,NULL,NULL,NULL),(43,13,'Tijuana','Тихуана',0,0,0,0,0,NULL,NULL,NULL,NULL),(44,NULL,'Chihuahua','Чиуауа',0,0,0,0,0,NULL,NULL,NULL,NULL),(45,NULL,'Guadalajara','Гвадалахара',0,0,0,0,0,NULL,NULL,NULL,NULL),(46,NULL,'Hermosillo','Эрмосильо',0,0,0,0,0,NULL,NULL,NULL,NULL),(47,NULL,'Mexicali','Мехикали',0,0,0,0,0,NULL,NULL,NULL,NULL),(48,13,'Monterrey','Монтеррей',0,0,0,0,0,NULL,NULL,NULL,NULL),(49,NULL,'Piedras Negras','Пьедрас-Неграс',0,0,0,0,0,NULL,NULL,NULL,NULL),(50,13,'Nuevo Laredo','Нуэво-Ларедо',0,0,0,0,0,NULL,NULL,NULL,NULL),(51,7,'Calgary','Калгари',0,0,0,0,0,NULL,NULL,NULL,NULL),(52,7,'Halifax','Галифакс',0,0,0,0,0,NULL,NULL,NULL,NULL),(53,7,'Montreal','Монреаль',0,0,0,0,0,NULL,NULL,NULL,NULL),(54,7,'Ottawa','Оттава',0,0,0,0,0,NULL,NULL,NULL,NULL),(55,7,'Quebec City','Квебек',0,0,0,0,0,NULL,NULL,NULL,NULL),(56,7,'Toronto','Торонто',0,0,0,0,0,NULL,NULL,NULL,NULL),(57,7,'Vancouver','Ванкувер',0,0,0,0,0,NULL,NULL,NULL,NULL),(58,37,'Tel Aviv','Тель-Авив',0,2,0,0,0,1684974263,NULL,1684974263,NULL),(59,37,'Jerusalem','Иерусалим',0,0,0,0,0,NULL,NULL,NULL,NULL),(60,4,'Belmopan','Бельмопан',0,0,0,0,0,NULL,NULL,NULL,NULL),(61,11,'Georgetown','Джорджтаун',0,0,0,0,0,NULL,NULL,NULL,NULL),(62,16,'Port of Spain','Порт-оф-Спейн',0,0,0,0,0,NULL,NULL,NULL,NULL),(63,49,'Cape Town','Кейптаун',0,0,0,0,0,NULL,NULL,NULL,NULL),(64,49,'Durban','Дурбан',0,0,0,0,0,NULL,NULL,NULL,NULL),(65,49,'Johannesburg','Йоханнесбург',0,0,0,0,0,NULL,NULL,NULL,NULL),(66,45,'Nairobi','Найроби',0,0,0,0,0,NULL,NULL,NULL,NULL),(67,48,'Dar Es Salaam','Дар-эс-Салам',0,0,0,0,0,NULL,NULL,NULL,NULL),(68,50,'Kampala','Кампала',0,0,0,0,0,NULL,NULL,NULL,NULL),(69,6,'La Paz','Ла-Пас',0,0,0,0,0,NULL,NULL,NULL,NULL),(70,10,'Guayaquil','Гуаякиль',0,0,0,0,0,NULL,NULL,NULL,NULL),(71,10,'Quito','Кито',0,0,0,0,0,NULL,NULL,NULL,NULL),(72,14,'Asunción','Асунсьо́н',0,0,0,0,0,NULL,NULL,NULL,NULL),(73,8,'Santiago','Сантьяго',0,0,0,0,0,NULL,NULL,NULL,NULL),(74,17,'Montevideo','Монтевидео',0,0,0,0,0,NULL,NULL,NULL,NULL),(75,15,'Lima','Лима',0,0,0,0,0,NULL,NULL,NULL,NULL),(76,24,'Embassy in Nicosia','Никосия',0,0,0,0,0,NULL,NULL,NULL,NULL),(77,26,'Athens','Афины',0,0,0,0,0,NULL,NULL,NULL,NULL),(78,23,'Zagreb','Загреб',0,0,0,0,0,NULL,NULL,NULL,NULL),(79,22,'Sarajevo','Сараево',0,0,0,0,0,NULL,NULL,NULL,NULL),(80,19,'Yerevan','Ереван',0,4,4,0,0,1685285077,NULL,1685285077,NULL),(81,33,'Belgrade','Белград',0,4,3,0,0,1685288039,NULL,1685288039,NULL),(82,35,'Ankara','Анкара',0,0,0,0,0,NULL,NULL,NULL,NULL),(83,35,'İstanbul','Стамбул',0,2,1,0,0,1685280982,NULL,1685280982,NULL),(84,18,'Tirana','Тирана',0,0,0,0,0,NULL,NULL,NULL,NULL),(85,20,'Baku','Баку',0,0,0,0,0,NULL,NULL,NULL,NULL),(86,51,'Lusaka','Лусака',0,0,0,0,0,NULL,NULL,NULL,NULL),(87,29,'Pristina','Приштина',0,0,0,0,0,NULL,NULL,NULL,NULL),(88,52,'Santo Domingo','Санто Доминго',0,0,0,0,0,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `cities` 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 */;

-- Dump completed on 2025-01-08  9:32:38
