text: /*!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 utf8 */;
  /*!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 `locales`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `locales` (
    `id` smallint(3) unsigned NOT NULL AUTO_INCREMENT,
    `language_id` smallint(3) unsigned NOT NULL,
    `country_id` smallint(3) unsigned NOT NULL,
    `official_language` tinyint(1) unsigned NOT NULL DEFAULT '0',
    `default_country` tinyint(1) unsigned DEFAULT NULL,
    `app_default` tinyint(1) unsigned NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    KEY `language_id` (`language_id`),
    KEY `country_id` (`country_id`),
    KEY `official_language` (`official_language`),
    KEY `default_country` (`default_country`),
    KEY `app_default` (`app_default`),
    CONSTRAINT `fk_locales_countries` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON UPDATE CASCADE,
    CONSTRAINT `fk_locales_languages` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON UPDATE CASCADE
  ) ENGINE=InnoDB AUTO_INCREMENT=342 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `locales`
  --
  
  LOCK TABLES `locales` WRITE;
  /*!40000 ALTER TABLE `locales` DISABLE KEYS */;
  INSERT INTO `locales` VALUES (1,3,147,0,0,0),(2,3,226,1,0,0),(3,4,63,1,0,0),(4,5,2,0,0,0),(5,5,21,0,0,0),(6,5,52,0,0,0),(7,5,56,0,0,0),(8,5,59,0,0,0),(9,5,60,0,0,0),(10,5,61,0,0,0),(11,5,95,0,0,0),(12,5,97,0,0,0),(13,5,102,0,0,0),(14,5,108,0,0,0),(15,5,112,0,0,0),(16,5,116,0,0,0),(17,5,125,0,0,0),(18,5,126,0,0,0),(19,5,138,0,0,0),(20,5,159,0,0,0),(21,5,169,0,0,0),(22,5,173,0,0,0),(23,5,178,1,0,0),(24,5,181,0,0,0),(25,5,191,0,0,0),(26,5,195,0,0,0),(27,5,198,0,0,0),(28,5,205,0,0,0),(29,5,224,0,0,0),(30,6,96,1,0,0),(31,10,31,1,0,0),(32,11,20,1,0,0),(33,14,17,1,0,0),(34,14,96,0,0,0),(35,15,43,0,0,0),(36,15,96,0,0,0),(37,16,69,1,0,0),(38,17,1,0,0,0),(39,17,62,0,0,0),(40,17,69,0,0,0),(41,17,100,0,0,0),(42,19,50,1,0,0),(43,20,71,1,0,0),(44,21,53,0,0,0),(45,21,78,0,0,0),(46,22,11,0,0,0),(47,22,18,0,0,0),(48,22,38,0,0,0),(49,22,51,0,0,0),(50,22,100,0,0,0),(51,22,118,0,0,0),(52,22,123,0,0,0),(53,23,29,1,0,0),(54,24,49,0,0,0),(55,24,83,0,0,0),(56,25,4,0,0,0),(57,25,5,0,0,0),(58,25,11,0,0,0),(59,25,12,0,0,0),(60,25,16,0,0,0),(61,25,18,0,0,0),(62,25,22,0,0,0),(63,25,24,0,0,0),(64,25,28,0,0,0),(65,25,30,0,0,0),(66,25,32,0,0,0),(67,25,33,0,0,0),(68,25,34,0,0,0),(69,25,38,0,0,0),(70,25,40,0,0,0),(71,25,42,0,0,0),(72,25,48,0,0,0),(73,25,49,0,0,0),(74,25,51,0,0,0),(75,25,53,0,0,0),(76,25,54,0,0,0),(77,25,61,0,0,0),(78,25,64,0,0,0),(79,25,65,0,0,0),(80,25,66,0,0,0),(81,25,67,0,0,0),(82,25,71,1,0,1),(83,25,72,0,0,0),(84,25,75,0,0,0),(85,25,76,0,0,0),(86,25,77,0,0,0),(87,25,79,0,0,0),(88,25,87,0,0,0),(89,25,88,0,0,0),(90,25,94,0,0,0),(91,25,95,0,0,0),(92,25,96,0,0,0),(93,25,101,0,0,0),(94,25,104,0,0,0),(95,25,107,0,0,0),(96,25,109,0,0,0),(97,25,113,0,0,0),(98,25,117,0,0,0),(99,25,120,0,0,0),(100,25,121,0,0,0),(101,25,129,0,0,0),(102,25,130,0,0,0),(103,25,135,0,0,0),(104,25,136,0,0,0),(105,25,139,0,0,0),(106,25,140,0,0,0),(107,25,141,0,0,0),(108,25,143,0,0,0),(109,25,145,0,0,0),(110,25,147,0,0,0),(111,25,150,0,0,0),(112,25,151,0,0,0),(113,25,153,0,0,0),(114,25,156,0,0,0),(115,25,157,0,0,0),(116,25,158,0,0,0),(117,25,163,0,0,0),(118,25,164,0,0,0),(119,25,165,0,0,0),(120,25,168,0,0,0),(121,25,171,0,0,0),(122,25,177,0,0,0),(123,25,179,0,0,0),(124,25,180,0,0,0),(125,25,181,0,0,0),(126,25,182,0,0,0),(127,25,183,0,0,0),(128,25,184,0,0,0),(129,25,185,0,0,0),(130,25,188,0,0,0),(131,25,196,0,0,0),(132,25,197,0,0,0),(133,25,203,0,0,0),(134,25,206,0,0,0),(135,25,208,0,0,0),(136,25,209,0,0,0),(137,25,211,0,0,0),(138,25,213,0,0,0),(139,25,230,1,0,0),(140,25,216,0,0,0),(141,25,218,0,0,0),(142,25,219,0,0,0),(143,25,221,0,0,0),(144,25,223,0,0,0),(145,25,226,0,0,0),(146,25,227,0,0,0),(147,25,229,0,0,0),(148,27,10,0,0,0),(149,27,26,0,0,0),(150,27,27,0,0,0),(151,27,32,0,0,0),(152,27,41,0,0,0),(153,27,44,0,0,0),(154,27,45,0,0,0),(155,27,46,0,0,0),(156,27,55,0,0,0),(157,27,57,0,0,0),(158,27,62,0,0,0),(159,27,82,0,0,0),(160,27,85,0,0,0),(161,27,89,0,0,0),(162,27,144,0,0,0),(163,27,152,0,0,0),(164,27,160,0,0,0),(165,27,161,0,0,0),(166,27,164,0,0,0),(167,27,172,0,0,0),(168,27,194,0,0,0),(169,27,230,0,0,0),(170,27,214,0,0,0),(171,27,217,0,0,0),(172,28,58,1,0,0),(173,29,62,1,0,0),(174,30,3,0,0,0),(175,30,98,0,0,0),(176,31,64,1,0,0),(177,33,53,0,0,0),(178,33,68,0,0,0),(179,34,18,0,0,0),(180,34,19,0,0,0),(181,34,22,0,0,0),(182,34,23,0,0,0),(183,34,33,0,0,0),(184,34,35,0,0,0),(185,34,36,0,0,0),(186,34,37,0,0,0),(187,34,38,0,0,0),(188,34,39,0,0,0),(189,34,42,0,0,0),(190,34,52,0,0,0),(191,34,56,0,0,0),(192,34,69,1,0,0),(193,34,70,0,0,0),(194,34,74,0,0,0),(195,34,80,0,0,0),(196,34,81,0,0,0),(197,34,82,0,0,0),(198,34,91,0,0,0),(199,34,108,0,0,0),(200,34,123,0,0,0),(201,34,126,0,0,0),(202,34,127,0,0,0),(203,34,129,0,0,0),(204,34,132,0,0,0),(205,34,137,0,0,0),(206,34,138,0,0,0),(207,34,141,0,0,0),(208,34,148,0,0,0),(209,34,149,0,0,0),(210,34,162,0,0,0),(211,34,167,0,0,0),(212,34,174,0,0,0),(213,34,177,0,0,0),(214,34,180,0,0,0),(215,34,190,0,0,0),(216,34,195,0,0,0),(217,34,198,0,0,0),(218,34,200,0,0,0),(219,34,205,0,0,0),(220,34,221,0,0,0),(221,34,222,0,0,0),(222,34,225,0,0,0),(223,35,153,1,0,0),(224,36,94,1,0,0),(225,37,71,1,0,0),(226,38,62,1,0,0),(227,40,96,1,0,0),(228,41,76,0,0,0),(229,41,149,0,0,0),(230,41,151,0,0,0),(231,42,96,1,0,0),(232,43,15,0,0,0),(233,43,90,0,0,0),(234,44,92,1,0,0),(235,45,7,1,0,0),(236,50,99,1,0,0),(237,51,38,0,0,0),(238,51,100,1,1,0),(239,51,189,0,0,0),(240,53,103,1,0,0),(241,56,73,1,0,0),(242,57,114,1,0,0),(243,58,78,1,0,0),(244,59,106,1,0,0),(245,60,96,1,0,0),(246,61,110,0,0,0),(247,61,111,0,0,0),(248,62,96,1,0,0),(249,64,105,1,0,0),(250,66,9,0,0,0),(251,66,35,0,0,0),(252,66,36,0,0,0),(253,66,37,0,0,0),(254,67,115,1,0,0),(255,68,122,1,0,0),(256,69,124,1,0,0),(257,70,129,1,0,0),(258,72,131,1,0,0),(259,73,96,1,0,0),(260,74,134,1,0,0),(261,76,96,1,0,0),(262,77,25,0,0,0),(263,77,145,0,0,0),(264,77,183,0,0,0),(265,78,140,1,0,0),(266,79,133,1,0,0),(267,81,96,0,0,0),(268,81,155,0,0,0),(269,82,13,0,0,0),(270,82,18,0,0,0),(271,82,153,0,0,0),(272,82,192,0,0,0),(273,85,63,0,0,0),(274,85,104,0,0,0),(275,87,166,1,0,0),(276,88,3,1,0,0),(277,89,9,0,0,0),(278,89,27,0,0,0),(279,89,38,0,0,0),(280,89,47,0,0,0),(281,89,82,0,0,0),(282,89,86,0,0,0),(283,89,123,0,0,0),(284,89,135,0,0,0),(285,89,146,0,0,0),(286,89,170,1,0,0),(287,89,193,0,0,0),(288,90,26,0,0,0),(289,90,57,0,0,0),(290,90,161,0,0,0),(291,91,38,1,0,0),(292,92,22,1,0,0),(293,93,128,0,0,0),(294,93,175,0,0,0),(295,94,31,0,0,0),(296,94,105,0,0,0),(297,94,114,0,0,0),(298,94,128,0,0,0),(299,94,176,0,0,0),(300,94,212,0,0,0),(301,95,177,1,0,0),(302,97,165,1,0,0),(303,98,36,1,0,0),(304,100,119,1,0,0),(305,101,187,1,0,0),(306,102,185,1,0,0),(307,104,229,1,0,0),(308,105,52,0,0,0),(309,105,63,0,0,0),(310,105,104,0,0,0),(311,105,191,0,0,0),(312,106,6,0,0,0),(313,106,131,0,0,0),(314,111,64,0,0,0),(315,111,182,0,0,0),(316,112,35,0,0,0),(317,112,104,0,0,0),(318,112,211,0,0,0),(319,112,213,0,0,0),(320,113,96,0,0,0),(321,113,119,0,0,0),(322,113,145,0,0,0),(323,113,183,0,0,0),(324,114,96,1,0,0),(325,115,202,1,0,0),(326,116,201,1,0,0),(327,117,61,0,0,0),(328,117,63,0,0,0),(329,118,204,1,0,0),(330,121,206,1,0,0),(331,122,49,0,0,0),(332,122,207,0,0,0),(333,124,176,1,0,0),(334,126,212,1,0,0),(335,127,96,0,0,0),(336,127,165,0,0,0),(337,129,220,1,0,0),(338,131,190,1,0,0),(339,133,23,0,0,0),(340,133,151,0,0,0),(341,135,226,1,0,0);
  /*!40000 ALTER TABLE `locales` 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 */;