text: -- MySQL dump 10.13  Distrib 5.7.16, for Win32 (AMD64)
  --
  -- Host: localhost    Database: nsign
  -- ------------------------------------------------------
  -- Server version	5.5.53
  
  /*!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 `dish_ingredients`
  --
  
  DROP TABLE IF EXISTS `dish_ingredients`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `dish_ingredients` (
    `dish_id` int(11) NOT NULL,
    `ingredient_id` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `dish_ingredients`
  --
  
  LOCK TABLES `dish_ingredients` WRITE;
  /*!40000 ALTER TABLE `dish_ingredients` DISABLE KEYS */;
  INSERT INTO `dish_ingredients` VALUES (19,2),(19,9),(19,11),(1,1),(1,2),(1,4),(1,5),(2,1),(2,9),(2,15),(5,1),(5,4),(5,6),(5,14),(5,16),(7,1),(7,3),(7,4),(7,5),(6,2),(6,4),(6,5),(6,11),(6,13),(6,18),(4,2),(4,3),(4,4),(4,5),(4,10),(4,11),(4,19);
  /*!40000 ALTER TABLE `dish_ingredients` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `dishes`
  --
  
  DROP TABLE IF EXISTS `dishes`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `dishes` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(50) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `dishes`
  --
  
  LOCK TABLES `dishes` WRITE;
  /*!40000 ALTER TABLE `dishes` DISABLE KEYS */;
  INSERT INTO `dishes` VALUES (1,'Жареная картошка'),(2,'Суп солянка'),(3,'Суп вермишелевый'),(4,'Зелёные щи с крапивой'),(5,'Винегрет '),(6,'Лазанья'),(7,'Жаркое в горшочках');
  /*!40000 ALTER TABLE `dishes` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `ingredients`
  --
  
  DROP TABLE IF EXISTS `ingredients`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `ingredients` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(50) NOT NULL,
    `isHidden` tinyint(1) DEFAULT '0',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `ingredients`
  --
  
  LOCK TABLES `ingredients` WRITE;
  /*!40000 ALTER TABLE `ingredients` DISABLE KEYS */;
  INSERT INTO `ingredients` VALUES (1,'Картофель',0),(2,'Лук репчатый',0),(3,'Чеснок',0),(4,'Соль ',0),(5,'Перец ',0),(6,'Масло растительное ',0),(7,'Курица ',0),(8,'Шампиньоны ',0),(9,'Капуста квашеная ',0),(10,'Морковь ',0),(11,'Зелень ',0),(12,'Маслины ',0),(13,'Томатная паста ',0),(14,'Свекла',0),(15,'Огурец ',0),(16,'Зеленый горошек',0),(17,'Сливки',0),(18,'Листы лазаньи',0),(19,'Крапива',0);
  /*!40000 ALTER TABLE `ingredients` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `migration`
  --
  
  DROP TABLE IF EXISTS `migration`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `migration` (
    `version` varchar(180) NOT NULL,
    `apply_time` int(11) DEFAULT NULL,
    PRIMARY KEY (`version`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `migration`
  --
  
  LOCK TABLES `migration` WRITE;
  /*!40000 ALTER TABLE `migration` DISABLE KEYS */;
  INSERT INTO `migration` VALUES ('m000000_000000_base',1493197231),('m170420_151210_create_dishes_table',1493197234),('m170420_151614_create_ingredients_table',1493197234),('m170420_151629_create_dish_ingredients_table',1493197234);
  /*!40000 ALTER TABLE `migration` 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 2017-04-26 12:38:04
  