-- MySQL dump 10.13  Distrib 5.5.60, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: sviet_oil
-- ------------------------------------------------------
-- Server version	5.5.60-0ubuntu0.14.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 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 `directions`
--

DROP TABLE IF EXISTS `directions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `directions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `disease_id` int(11) DEFAULT NULL,
  `oil_id` int(11) DEFAULT NULL,
  `direction` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `params` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_495867ECD8355341` (`disease_id`),
  KEY `IDX_495867EC34B25D89` (`oil_id`),
  CONSTRAINT `FK_495867EC34B25D89` FOREIGN KEY (`oil_id`) REFERENCES `oils` (`id`),
  CONSTRAINT `FK_495867ECD8355341` FOREIGN KEY (`disease_id`) REFERENCES `diseases` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `directions`
--

LOCK TABLES `directions` WRITE;
/*!40000 ALTER TABLE `directions` DISABLE KEYS */;
INSERT INTO `directions` VALUES (2,15,31,'rub into your head','null'),(3,19,31,'Ð’Ñ‚Ð¸Ñ€Ð°Ñ‚ÑŒ Ð² Ð¿Ð¾Ð´Ñ€ÐµÐ±ÐµÑ€ÑŒÐµ ÑÐ»ÐµÐ²Ð° Ð¸ Ð¿Ð¾ÑÐµÑ€ÐµÐ´Ð¸Ð½Ðµ. Ð’Ñ‚Ð¸Ñ€Ð°Ñ‚ÑŒ 2-3 Ñ€Ð°Ð·Ð° Ð² Ð´ÐµÐ½ÑŒ Ð² ÑÑ‚ÑƒÐ¿Ð½Ð¸.','null'),(4,19,42,'ÐœÐ°Ð·Ð°Ñ‚ÑŒ Ð¶Ð¸Ð²Ð¾Ñ‚, Ð½Ð°Ñ‚Ð¸Ñ€Ð°Ñ‚ÑŒ Ð¿Ð¾Ð´Ð¾ÑˆÐ²Ñ‹ ÑÑ‚ÑƒÐ¿Ð½ÐµÐ¹','null'),(5,19,44,'ÐœÐ°Ð·Ð°Ñ‚ÑŒ Ð¶Ð¸Ð²Ð¾Ñ‚, Ð²Ñ‚Ð¸Ñ€Ð°Ñ‚ÑŒ Ð² Ð¿Ð¾Ð´Ð¾ÑˆÐ²Ñ‹','null'),(6,20,31,'Ð’Ñ‚Ð¸Ñ€Ð°Ñ‚ÑŒ Ð² ÑÑ‚ÑƒÐ¿Ð½Ð¸, Ð²Ñ‚Ð¸Ñ€Ð°Ñ‚ÑŒ Ð² Ð¾Ð±Ð»Ð°ÑÑ‚ÑŒ Ð¶Ð¸Ð²Ð¾Ñ‚Ð°','null'),(7,20,42,'Ð’Ñ‚Ð¸Ñ€Ð°Ñ‚ÑŒ Ð² Ð¾Ð±Ð»Ð°ÑÑ‚ÑŒ Ð¶Ð¸Ð²Ð¾Ñ‚Ð°, Ð²Ñ‚Ð¸Ñ€Ð°Ñ‚ÑŒ Ð² ÑÑ‚ÑƒÐ¿Ð½Ð¸\n','null'),(8,20,44,'Ð’Ñ‚Ð¸Ñ€Ð°Ñ‚ÑŒ Ð² ÑÑ‚ÑƒÐ¿Ð½Ð¸, Ð²Ñ‚Ð¸Ñ€Ð°Ñ‚ÑŒ Ñ‚ÑƒÐ´Ð°, Ð³Ð´Ðµ Ð±Ð¾Ð»Ð¸Ñ‚.','null'),(9,21,1,'Ð¿Ñ€Ð¸Ð½Ð¸Ð¼Ð°Ñ‚ÑŒ Ð²Ð¾Ð²Ð½ÑƒÑ‚Ñ€ÑŒ Ð¿Ð¾ 3-4 ÐºÐ°Ð¿Ð»Ð¸ Ñ‚Ñ€Ð¸ Ñ€Ð°Ð·Ð° Ð² Ð´ÐµÐ½ÑŒ, Ð½Ð°Ñ‚Ð¸Ñ€Ð°Ñ‚ÑŒ ÑÑ‚ÑƒÐ¿Ð½Ð¸','null'),(10,21,42,'Ð’Ñ‚Ð¸Ñ€Ð°Ñ‚ÑŒ Ð² Ð¾Ð±Ð»Ð°ÑÑ‚ÑŒ Ð¶Ð¸Ð²Ð¾Ñ‚Ð°, Ð²Ñ‚Ð¸Ñ€Ð°Ñ‚ÑŒ Ð² ÑÑ‚ÑƒÐ¿Ð½Ð¸.','null'),(11,1,41,'Ð’Ñ‚Ð¸Ñ€Ð°Ñ‚ÑŒ Ð² ÑÑ‚ÑƒÐ¿Ð½Ð¸, Ð¼Ð°Ð·Ð°Ñ‚ÑŒ Ð²Ð¸ÑÐºÐ¸, Ð·Ð°Ñ‚Ñ‹Ð»Ð¾Ðº','null'),(12,22,31,'Ð²Ñ‚Ð¸Ñ€Ð°Ñ‚ÑŒ Ð² ÑÑ‚ÑƒÐ¿Ð½Ð¸, Ð¿Ð¸Ñ‚ÑŒ Ð²Ð¾Ð²Ð½ÑƒÑ‚Ñ€ÑŒ','null');
/*!40000 ALTER TABLE `directions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `diseases`
--

DROP TABLE IF EXISTS `diseases`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `diseases` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `health_id` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_F7620647A08E947C` (`health_id`),
  CONSTRAINT `FK_F7620647A08E947C` FOREIGN KEY (`health_id`) REFERENCES `healths` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `diseases`
--

LOCK TABLES `diseases` WRITE;
/*!40000 ALTER TABLE `diseases` DISABLE KEYS */;
INSERT INTO `diseases` VALUES (1,1,'Ð²Ñ‹ÑÐ¾ÐºÐ¾Ðµ Ð´Ð°Ð²Ð»ÐµÐ½Ð¸Ðµ','Ð³Ð¸Ð¿ÐµÑ€Ñ‚Ð¾Ð½Ð¸Ñ'),(15,15,'headache','pain in the head'),(19,20,'ÐŸÐ°Ð½ÐºÑ€ÐµÐ°Ñ‚Ð¸Ñ‚','Ð’Ð¾ÑÐ¿Ð°Ð»ÐµÐ½Ð¸Ðµ Ð¿Ð¾Ð´Ð¶ÐµÐ»ÑƒÐ´Ð¾Ñ‡Ð½Ð¾Ð¹ Ð¶ÐµÐ»ÐµÐ·Ñ‹'),(20,20,'Ð¥Ð¾Ð»ÐµÑ†Ð¸ÑÑ‚Ð¸Ñ‚','Ð’Ð¾ÑÐ¿Ð°Ð»ÐµÐ½Ð¸Ðµ Ð¶ÐµÐ»Ñ‡Ð½Ð¾Ð³Ð¾ Ð¿ÑƒÐ·Ñ‹Ñ€Ñ'),(21,20,'Ð“Ð°Ð·Ñ‹ Ð² ÐºÐ¸ÑˆÐµÑ‡Ð½Ð¸ÐºÐµ','Ð“Ð°Ð·Ñ‹ Ð² ÐºÐ¸ÑˆÐµÑ‡Ð½Ð¸ÐºÐµ Ñ€Ð°Ð·Ð»Ð¸Ñ‡Ð½Ð¾Ð¹ ÑÑ‚Ð¸Ð¼Ð¾Ð»Ð¾Ð³Ð¸Ð¸'),(22,20,'Ð”Ð¸Ð°Ð±ÐµÑ‚','Ð”Ð¸Ð°Ð±ÐµÑ‚ - Ð¿Ð¾Ð²Ñ‹ÑˆÐµÐ½Ð½Ð¾Ðµ ÑÐ¾Ð´ÐµÑ€Ð¶Ð°Ð½Ð¸Ðµ ÑÐ°Ñ…Ð°Ñ€Ð° Ð² ÐºÑ€Ð¾Ð²Ð¸');
/*!40000 ALTER TABLE `diseases` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `healths`
--

DROP TABLE IF EXISTS `healths`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `healths` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `healths`
--

LOCK TABLES `healths` WRITE;
/*!40000 ALTER TABLE `healths` DISABLE KEYS */;
INSERT INTO `healths` VALUES (1,'Ð¡ÐµÑ€Ð´ÐµÑ‡Ð½Ð¾-ÑÐ¾ÑÑƒÐ´Ð¸ÑÑ‚Ð°Ñ ÑÐ¸ÑÑ‚ÐµÐ¼Ð°','Ð¡ÐµÑ€Ð´ÐµÑ‡Ð½Ð¾-ÑÐ¾ÑÑƒÐ´Ð¸ÑÑ‚Ð°Ñ ÑÐ¸ÑÑ‚ÐµÐ¼Ð°, ÑÐµÑ€Ð´Ñ†Ðµ, ÑÐ¾ÑÑƒÐ´Ñ‹'),(15,'Head, brain, neurology','everything related to head problems'),(20,'ÐÐ°Ñ€ÑƒÑˆÐµÐ½Ð¸Ñ Ð¿Ð¸Ñ‰ÐµÐ²Ð°Ñ€ÐµÐ½Ð¸Ñ','ÐÐµÑÐ²Ð°Ñ€ÐµÐ½Ð¸Ðµ, Ð±Ð¾Ð»Ð¸ Ð² Ð¿Ð¾Ð´Ð²Ð·Ð´Ð¾ÑˆÐ½Ð¾Ð¹ Ð¾Ð±Ð»Ð°ÑÑ‚Ð¸, Ð¿Ð°Ð½ÐºÑ€ÐµÐ°Ñ‚Ð¸Ñ‚, Ñ…Ð¾Ð»ÐµÑ†Ð¸ÑÑ‚Ð¸Ñ‚\n');
/*!40000 ALTER TABLE `healths` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `oils`
--

DROP TABLE IF EXISTS `oils`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oils` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `oils`
--

LOCK TABLES `oils` WRITE;
/*!40000 ALTER TABLE `oils` DISABLE KEYS */;
INSERT INTO `oils` VALUES (1,'Peppermint','peppermint oil is a good oil '),(15,'Balance','good oil'),(30,'Rosemary','ddd oil'),(31,'Lemon','ÐœÐ°ÑÐ»Ð¾ ÑˆÐ¸Ñ€Ð¾ÐºÐ¾Ð³Ð¾ Ð½Ð°Ð·Ð½Ð°Ñ‡ÐµÐ½Ð¸Ñ'),(37,'DDR aaaa','good oil a  aaaa'),(38,'Onguard','aaa oil'),(41,'Lavander','Ð›Ð°Ð²Ð°Ð½Ð´Ð° Ð¿Ð¾Ð¼Ð¾Ð³Ð°ÐµÑ‚ Ð¿Ñ€Ð¸ Ð³Ð¾Ð»Ð¾Ð²Ð½Ð¾Ð¹ Ð±Ð¾Ð»Ð¸, Ð¿Ð¾Ð¼Ð¾Ð³Ð°ÐµÑ‚ ÑÐ¾ ÑÐ½Ð¾Ð¼, ÑƒÐ»ÑƒÑ‡ÑˆÐ°ÐµÑ‚ Ð¼Ð¸Ñ€ÐºÐ¾Ñ„Ð»Ð¾Ñ€Ñƒ, Ð·Ð°Ð¶Ð¸Ð²Ð»ÑÐµÑ‚ Ñ€Ð°Ð½ÐºÐ¸, ÑÐ¾Ð»Ð½ÐµÑ‡Ð½Ñ‹Ðµ Ð¾Ð¶Ð¾Ð³Ð¸'),(42,'DigestZen','ÐœÐ°ÑÐ»Ð¾ Ð´Ð»Ñ ÑƒÐ»ÑƒÑ‡ÑˆÐµÐ½Ð¸Ñ Ð¿Ð¸Ñ‰ÐµÐ²Ð°Ñ€ÐµÐ½Ð¸Ñ'),(43,'Basil','Ð£ÑÐ¿Ð¾ÐºÐ°Ð¸Ð²Ð°ÐµÑ‚ Ð½ÐµÑ€Ð²Ð½ÑƒÑŽ ÑÐ¸ÑÑ‚ÐµÐ¼Ñƒ, Ð¿Ð¾Ð¼Ð¾Ð³Ð°ÐµÑ‚ Ð¿Ñ€Ð¸ Ð°ÑÑ‚Ð¼Ðµ, Ð³Ð°ÑÑ‚Ñ€Ð¸Ñ‚Ðµ, ÑÐ¿Ð°Ð·Ð¼Ð°Ñ… ÐºÐ¸ÑˆÐµÑ‡Ð½Ð¸ÐºÐ°, Ð´Ð¸Ð°Ð±ÐµÑ‚Ðµ, Ð½Ð°Ñ€ÑƒÑˆÐµÐ½Ð¸ÑÑ… Ð¿Ð¸Ñ‰ÐµÐ²Ð°Ñ€ÐµÐ½Ð¸Ñ.'),(44,'Clary Sage','ÐÐ½Ñ‚Ð¸Ð±Ð°ÐºÑ‚ÐµÑ€Ð¸Ð°Ð»ÑŒÐ½Ð¾Ðµ Ð´ÐµÐ¹ÑÑ‚Ð²Ð¸Ðµ, Ð°Ð½Ñ‚Ð¸Ð´ÐµÐ¿Ñ€ÐµÑÑÐ°Ð½Ñ‚, Ð¿Ñ€Ð¾Ñ‚Ð¸Ð²Ð¾Ð³Ñ€Ð¸Ð±ÐºÐ¾Ð²Ð¾Ðµ, Ð¿Ñ€Ð¾Ñ‚Ð¸Ð²Ð¾Ð²Ð¾ÑÐ¿Ð°Ð»Ð¸Ñ‚ÐµÐ»ÑŒÐ½Ð¾Ðµ, Ð³Ð¾Ñ€Ð¼Ð¾Ð½Ð°Ð»ÑŒÐ½Ñ‹Ð¹ Ð±Ð°Ð»Ð°Ð½Ñ, Ð¿Ð¾Ð¼Ð¾Ð³Ð°ÐµÑ‚ Ð¿Ñ€Ð¸ Ð·Ð°Ð±Ð¾Ð»ÐµÐ²Ð°Ð½Ð¸ÑÑ… Ð¿Ð¸Ñ‰');
/*!40000 ALTER TABLE `oils` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `roles`
--

DROP TABLE IF EXISTS `roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `roles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `roles`
--

LOCK TABLES `roles` WRITE;
/*!40000 ALTER TABLE `roles` DISABLE KEYS */;
/*!40000 ALTER TABLE `roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tags`
--

DROP TABLE IF EXISTS `tags`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tags` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tags`
--

LOCK TABLES `tags` WRITE;
/*!40000 ALTER TABLE `tags` DISABLE KEYS */;
INSERT INTO `tags` VALUES (1,' [Select a tag]'),(2,'Ð³Ð¸Ð¿ÐµÑ€Ñ‚Ð¾Ð½Ð¸Ñ'),(3,'Ð´Ð¾Ð»Ð³Ð¾Ð»ÐµÑ‚Ð¸Ðµ'),(4,'Ð¿Ð°Ð½ÐºÑ€ÐµÐ°Ñ‚Ð¸Ñ‚'),(5,'Ñ…Ð¾Ð»Ð¸Ñ†ÐµÑÑ‚Ð¸Ñ‚'),(6,'Ñ…Ð¾Ð»ÐµÑ†Ð¸ÑÑ‚Ð¸Ñ‚'),(7,'Ð½ÐµÑÐ²Ð°Ñ€ÐµÐ½Ð¸Ðµ'),(8,'DigestZen'),(9,'Basil'),(10,'Ð½ÐµÑ€Ð²Ð½Ð°Ñ ÑÐ¸ÑÑ‚ÐµÐ¼Ð°'),(11,'Ð°ÑÑ‚Ð¼Ð°'),(12,'Ð³Ð°ÑÑ‚Ñ€Ð¸Ñ‚'),(13,'Ð³Ð°Ð·Ñ‹'),(14,'ÑƒÐºÑƒÑÑ‹ Ð½Ð°ÑÐµÐºÐ¾Ð¼Ñ‹Ñ…'),(15,'ÐÐ½Ñ‚Ð¸Ð´ÐµÐ¿Ñ€ÐµÑÑÐ°Ð½Ñ‚'),(16,'Ð°Ð½Ñ‚Ð¸Ð±Ð°ÐºÑ‚ÐµÑ€Ð¸Ð°Ð»ÑŒÐ½Ð¾Ðµ'),(17,'Ð¿Ñ€Ð¾Ñ‚Ð¸Ð²Ð¾Ð³Ñ€Ð¸Ð±ÐºÐ¾Ð²Ð¾Ðµ'),(18,'Ð¿Ñ€Ð¾Ñ‚Ð¸Ð²Ð¾Ð²Ð¾ÑÐ¿Ð°Ð»Ð¸Ñ‚ÐµÐ»ÑŒÐ½Ð¾Ðµ'),(19,'Ð³Ð¾Ñ€Ð¼Ð¾Ð½Ð°Ð»ÑŒÐ½Ñ‹Ð¹ Ð±Ð°Ð»Ð°Ð½Ñ'),(20,'Ð¼ÐµÐ½ÑÑ‚Ñ€ÑƒÐ°Ñ†Ð¸Ð¸'),(21,'Ð¿Ð¸Ñ‰ÐµÐ²Ð°Ñ€ÐµÐ½Ð¸Ðµ'),(22,'Ð²Ñ‹ÑÐ¾ÐºÐ¾Ðµ Ð´Ð°Ð²Ð»ÐµÐ½Ð¸Ðµ'),(23,'Lavander'),(24,'Ð³Ð¾Ð»Ð¾Ð²Ð½Ð°Ñ Ð±Ð¾Ð»ÑŒ'),(25,'ÑÐ¾Ð½'),(26,'Ð¼Ð¸ÐºÑ€Ð¾Ñ„Ð»Ð¾Ñ€Ð°'),(27,'Ð´Ð¸Ð°Ð±ÐµÑ‚'),(28,'ÑÐ°Ñ…Ð°Ñ€ Ð² ÐºÑ€Ð¾Ð²Ð¸'),(29,'lemon'),(30,'Ð¿Ð¸Ñ‰ÐµÐ²Ð°Ñ€ÐµÐ½Ð¸Ðµ');
/*!40000 ALTER TABLE `tags` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tags_diseases`
--

DROP TABLE IF EXISTS `tags_diseases`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tags_diseases` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tag_id` int(11) DEFAULT NULL,
  `disease_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_9DF49A5EBAD26311` (`tag_id`),
  KEY `IDX_9DF49A5ED8355341` (`disease_id`),
  CONSTRAINT `FK_9DF49A5EBAD26311` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`),
  CONSTRAINT `FK_9DF49A5ED8355341` FOREIGN KEY (`disease_id`) REFERENCES `diseases` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tags_diseases`
--

LOCK TABLES `tags_diseases` WRITE;
/*!40000 ALTER TABLE `tags_diseases` DISABLE KEYS */;
INSERT INTO `tags_diseases` VALUES (1,1,NULL),(2,2,1),(3,3,15),(4,4,19),(5,7,19),(6,7,20),(7,6,20),(8,13,21),(9,7,21),(10,22,1),(11,27,22),(12,28,22),(13,29,22),(14,30,22);
/*!40000 ALTER TABLE `tags_diseases` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tags_oils`
--

DROP TABLE IF EXISTS `tags_oils`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tags_oils` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tag_id` int(11) DEFAULT NULL,
  `oil_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_AE4609BBAD26311` (`tag_id`),
  KEY `IDX_AE4609B34B25D89` (`oil_id`),
  CONSTRAINT `FK_AE4609B34B25D89` FOREIGN KEY (`oil_id`) REFERENCES `oils` (`id`),
  CONSTRAINT `FK_AE4609BBAD26311` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tags_oils`
--

LOCK TABLES `tags_oils` WRITE;
/*!40000 ALTER TABLE `tags_oils` DISABLE KEYS */;
INSERT INTO `tags_oils` VALUES (3,4,42),(4,5,NULL),(5,6,42),(6,7,42),(7,8,42),(8,9,43),(9,10,43),(10,11,43),(11,12,43),(12,13,43),(13,14,43),(14,15,44),(15,16,44),(16,17,44),(17,18,44),(18,19,44),(19,20,44),(20,21,44),(21,23,41),(22,24,41),(23,25,41),(24,26,41),(25,7,NULL);
/*!40000 ALTER TABLE `tags_oils` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tokens`
--

DROP TABLE IF EXISTS `tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tokens` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `allowed` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `restricted` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_AA5A118EA76ED395` (`user_id`),
  CONSTRAINT `FK_AA5A118EA76ED395` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tokens`
--

LOCK TABLES `tokens` WRITE;
/*!40000 ALTER TABLE `tokens` DISABLE KEYS */;
INSERT INTO `tokens` VALUES (1,2,'1ddabe6bf56f965388ee57e4fc390744','*','','1418115591');
/*!40000 ALTER TABLE `tokens` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `access_token` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
  `emailConfirmed` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'SVIET','sviet.ru@gmail.com','123456','',1),(2,'Giang Nguyen','tn.hoanggiang@gmail.com','123456',NULL,1);
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users_roles`
--

DROP TABLE IF EXISTS `users_roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users_roles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_51498A8ED60322AC` (`role_id`),
  KEY `IDX_51498A8EA76ED395` (`user_id`),
  CONSTRAINT `FK_51498A8EA76ED395` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
  CONSTRAINT `FK_51498A8ED60322AC` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users_roles`
--

LOCK TABLES `users_roles` WRITE;
/*!40000 ALTER TABLE `users_roles` DISABLE KEYS */;
/*!40000 ALTER TABLE `users_roles` 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 2020-05-20 12:16:17
