text: -- MySQL dump 10.13  Distrib 8.0.26, for Linux (x86_64)
  --
  -- Host: 127.0.0.1    Database: evo_rec_sys_v2
  -- ------------------------------------------------------
  -- Server version	8.0.26-0ubuntu0.20.04.3
  
  /*!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 */;
  
  --
  -- Table structure for table `cf_users_normalised_data`
  --
  
  DROP TABLE IF EXISTS `cf_users_normalised_data`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `cf_users_normalised_data` (
    `user_id` int NOT NULL,
    `gender` float DEFAULT NULL,
    `age` float DEFAULT NULL,
    `height` float DEFAULT NULL,
    `weight` float DEFAULT NULL,
    `activity_level` float DEFAULT NULL,
    `bread_pref` float DEFAULT NULL,
    `cereal_pref` float DEFAULT NULL,
    `dairy_pref` float DEFAULT NULL,
    `egg_pref` float DEFAULT NULL,
    `fish_pref` float DEFAULT NULL,
    `fruits_pref` float DEFAULT NULL,
    `grains_pref` float DEFAULT NULL,
    `legumes_pref` float DEFAULT NULL,
    `meat_pref` float DEFAULT NULL,
    `nuts_pref` float DEFAULT NULL,
    `pasta_pref` float DEFAULT NULL,
    `poultry_pref` float DEFAULT NULL,
    `seafood_pref` float DEFAULT NULL,
    `vegetables_pref` float DEFAULT NULL,
    `days_pref` float DEFAULT NULL,
    `minutes_pref` float DEFAULT NULL,
    `balance_pref` float DEFAULT NULL,
    `bicycling_pref` float DEFAULT NULL,
    `conditioning_pref` float DEFAULT NULL,
    `dancing_pref` float DEFAULT NULL,
    `running_pref` float DEFAULT NULL,
    `sports_pref` float DEFAULT NULL,
    `walking_pref` float DEFAULT NULL,
    `water_pref` float DEFAULT NULL,
    `wellbeing` float DEFAULT NULL,
    PRIMARY KEY (`user_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `cf_users_normalised_data`
  --
  
  LOCK TABLES `cf_users_normalised_data` WRITE;
  /*!40000 ALTER TABLE `cf_users_normalised_data` DISABLE KEYS */;
  INSERT INTO `cf_users_normalised_data` VALUES (0,0,0.48235,0.60909,0.45,0.33333,1,1,0.6,0.6,0,1,0.8,0,0.8,1,1,0.8,0,1,0.71429,0.00833,0,0,0,1,0.4,0.2,1,0.8,0),(1,1,0.25882,0.53636,0.7,0,1,1,1,1,1,1,1,1,0.2,1,0.6,0.8,0,1,0.57143,0.5,0,1,1,1,1,0.2,0.2,0.2,0),(2,1,0.45882,0.63636,0.52,0.33333,0.4,0.6,1,0.6,0.8,0.8,0.8,0.8,1,1,1,1,0.6,0.8,0.42857,1,0,0.6,0,0,0,0,0.6,0.6,0.33333),(3,1,0.30588,0.56364,0.9,0.66667,0.4,0.2,0.4,0.4,0.4,0.2,0.2,0.2,0.4,0,0.2,0.4,0.4,0.2,0,0,0,0,0,0.2,0,0.2,0.2,0,0),(4,0,0.4,0.48182,0.25,0.33333,0.6,0.2,0.4,1,1,1,0.8,0.8,0.8,1,0,0.4,0.4,1,0.28571,0.20833,1,0.8,0.6,0.4,0.4,0.4,1,0.4,1),(5,0,0.10588,0.47273,0.35,0.66667,1,1,1,0.4,0.2,1,1,0.4,0.4,1,1,0.2,0.2,1,0.71429,0.25,1,1,1,1,0,1,1,1,0),(6,1,0.18824,0.53636,0.36,0.66667,0.2,0.8,0.8,0,1,1,1,1,1,1,1,1,0.2,0.8,0.57143,1,0,0,1,0,0.2,0.8,1,0,1),(7,0,0.25882,0.42727,0.2,0.66667,1,0.6,1,1,1,1,0.8,1,1,1,1,0.8,0.6,0.8,0.85714,0.54167,0.8,1,0.6,0.6,1,0.8,0.8,0.8,1),(8,1,0.35294,0.54545,0.53,0.66667,0.8,0.6,0.8,0.6,0.8,0.4,0.8,0.8,0.8,0.6,0.6,0.6,0,0.6,0.57143,0.41667,0,0.8,0,0,0,0.4,0.6,1,0),(9,0,0.11765,0.52727,0.37,0,1,0.6,0.6,1,0.6,1,1,0.6,1,0.2,0.4,0.4,0.4,0.8,0,0.25,0,0,0,1,0.6,0.4,1,1,0),(10,1,0.27059,0.6,0.46,0.33333,0.8,0.6,0.8,1,0.6,0.6,0.8,0.8,0.8,0.4,1,0.8,1,0.8,0.57143,0.5,0.8,0.8,0.6,0.8,0.4,0.2,0.6,0.8,1),(11,1,0.03529,0.36364,0.12,1,1,1,1,0.6,0.2,1,0.8,0.6,1,0.8,0.6,1,0.4,0.8,0.57143,1,0.6,1,0.6,1,1,1,0.8,0.8,1),(12,0,0.10588,0.45455,0.25,0,1,0.6,0.8,0.6,1,1,1,1,1,1,1,1,1,1,0.14286,1,0,0,1,1,1,0.4,1,0.6,1),(13,0,0.09412,0.48182,0.27,0.33333,0,0,0,1,0.2,1,0,0.2,0.2,1,0,0,1,1,0.71429,0.58333,1,1,1,1,1,1,1,0,0.33333),(14,0,0.12941,0.5,0.35,0.33333,1,1,0.6,0.6,0.2,0,0.6,0.6,1,0.6,0.6,1,0.2,0.6,0,0.5,0,0,0.6,1,0.4,0.4,1,0,1),(15,0,0.10588,0.45455,0.1,0.33333,1,0.6,1,0.8,0.6,1,0.8,0.8,0.8,0.8,0.6,0.8,0.6,1,0.42857,0.5,0.4,0.8,1,1,1,0.6,1,0.6,0.66667),(16,0,0.11765,0.36364,0.3,0,0.2,0.2,0.6,0.6,0.6,0,0,0.2,0.2,0,0.6,0.6,0.6,0.4,0,0,0,0,0,0.4,0.2,0,0.2,0,0),(17,0,0.09412,0.43636,0.28,0,1,0.6,0.6,1,1,1,1,0.8,0.6,1,0.8,1,1,1,0.28571,1,0,0,0,1,0.2,0,1,0,0),(18,1,0.10588,0.58182,0.68,0.33333,0,0.2,0.2,0.4,0.4,0.4,0.4,0.4,0.4,0.2,0.4,0,0.4,0.4,0.28571,0.66667,0,0.2,0.2,0.2,1,1,1,0.6,0),(19,0,0.47059,0.54545,0.33,0.33333,1,1,1,1,1,1,1,1,0.6,0.4,0.4,0.8,0.2,1,0.57143,0.5,0,0,0.8,0.6,0,0.2,1,0,1),(20,1,0.27059,0.67273,0.6,0.33333,0.4,0.8,0.8,0.6,0.6,0.4,0.8,0.6,0.6,0.4,0.8,0.6,0.4,0.4,0.28571,0.5,0,1,0.6,0.6,0.2,0.6,0.6,0.8,0.33333),(21,0,0.28235,0.58182,0.48,0.33333,1,0.6,0.8,1,0.4,0.8,0.8,0.8,1,1,0.8,0.8,0.6,0.8,0.28571,0.25,0,0,0,1,0.4,0.4,0.8,0,0),(22,1,0.27059,0.54545,0.35,0.66667,1,1,0.8,1,0.2,1,0.8,0.2,1,1,0.6,0.8,0,1,0.71429,0.625,0,0,1,1,0.8,0.2,0.6,0.6,1),(23,1,0.54118,0.54545,0.59,0.66667,0.8,0,0.4,0,0.4,0.4,0.6,0.6,0,0.4,0.4,0.2,0.6,0.8,0.71429,0.66667,0,0.2,1,0.6,0,0.2,0.2,0,0),(24,0,0.32941,0.39091,0.36,0,0.4,0.2,0.2,0.4,0.4,0.4,0.4,0.4,0.4,0.2,0.4,0.4,0.2,0.4,0,0,0,0,0,0.2,0,0,0.2,0,0),(25,1,0.29412,0.47273,0.48,1,0.6,0.6,0.6,0.8,0.4,0.4,0.4,0.4,0.8,0.4,0.4,0.4,0.2,0.2,0.85714,1,0,0.4,0.4,0.6,0.6,0.6,1,0.6,0.33333),(26,1,0.27059,0.54545,0.6,0,0.6,0.6,0.6,1,1,1,1,0.8,1,0.6,0.6,1,1,0.8,0.14286,0.16667,0,0.4,1,0.4,0,0.6,1,0.6,0),(27,1,0.22353,0.6,0.3,0,0.8,0.8,1,1,1,0.8,0.8,0.6,0.8,0.6,0.6,0.4,0.4,0.4,0.28571,1,0,0.2,1,0,0.8,0.6,1,0,1),(28,0,0.24706,0.47273,0.5,0.33333,0.4,0.2,0.2,0.4,0.4,0.4,0.4,0.2,0.4,0.4,0,0.4,0,0.8,0.42857,0.25,0,0,0.4,1,0,0,1,0,0),(29,1,0.21176,0.47273,0.34,0.33333,1,0.6,0.8,1,0.8,0.4,0.6,0.4,1,0.4,0.6,0.6,0,0.2,0.14286,0.16667,0,0,1,1,0.4,0,1,0,1),(30,0,0.07059,0.42727,0.25,0.33333,0.4,0.2,0.2,0.6,0.4,0.4,0.4,0.2,0.6,0.4,0.6,0,0.6,0.6,0.71429,0.5,0,0.2,0.4,0.4,0.4,0.4,0.2,0.2,0),(31,0,0.07059,0.45455,0.257,1,0,0,0,0.4,0.4,1,0.6,0.2,0.2,0.6,0.8,0.4,0.8,1,1,0.5,0,0.4,1,1,0.6,1,0.8,1,0),(32,0,0.07059,0.36364,0.17,0,0.6,0.4,0.6,0.4,0,0.8,0.6,0.6,0.4,0.4,0.4,0.4,0,0.4,0.28571,0.5,0.4,0.2,0.6,0.6,0.2,0.6,0.4,0.6,0.33333),(33,0,0.32941,0.50909,0.28,0.33333,0.6,0,0.2,0.6,1,1,0.8,1,0.2,1,0.2,0.2,0.4,1,0.57143,0.41667,0.4,0,0.6,0.4,0.4,0.2,0.4,0,1),(34,1,0.25882,0.54545,0.4,0.66667,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.04167,0,1,1,0.2,1,1,1,0,0),(35,1,0.16471,0.66364,0.35,0.33333,0.2,0.2,0,0.2,0.2,0.4,0.4,0.4,0.4,0.2,0.2,0.2,0.2,0.4,0.28571,0.41667,0,0,0.2,0,0.2,0,0.4,0,1),(36,0,0.34118,0.41818,0.37,0,1,0.6,0.6,0.8,1,1,0.8,0.6,1,0,0.4,0.4,1,0.8,0,0,0,0,0,0.8,0.8,0.8,0.8,0,0.33333),(37,1,0.28235,0.67273,0.7,0,1,0.8,0.8,1,0.8,1,0.6,0.8,1,0.6,1,1,1,0.8,0.14286,0.16667,0,0,0,0,0,0,1,0,0),(38,1,0.24706,0.52727,0.45,0,0.8,0.8,1,0.8,0.6,0.8,0.6,0.4,1,0.4,0.4,0.8,0.8,0.8,0,0,0,0,0,0.4,0.2,0,0.8,0.6,0),(39,0,0.23529,0.4,0.25,0.66667,0.6,0.6,0.6,0.6,0.4,0.4,0.2,0.2,0.6,0.2,0.4,0.4,0.2,0.2,0.57143,0.5,0.4,0,1,1,1,0.8,0.8,0.2,0),(40,0,0.37647,0.49091,0.3,0.33333,1,0.8,0.4,0.8,1,0.4,0.8,0.6,1,0.8,1,1,1,0.2,0.42857,0.5,0,0.2,0,1,0,0,1,0,0.33333),(41,1,0.25882,0.6,0.8,0.33333,0.8,0.2,1,1,0.6,1,1,1,1,0.6,0.8,1,0.6,0.8,0.42857,0.5,0.2,0.2,0.6,0.6,0,0.2,1,1,0),(42,0,0.43529,0.51818,0.8,0,0.8,0.6,0.4,0.6,0.6,0.8,0.8,0.8,0.2,0.8,0.8,0.8,0.8,0.8,0.14286,0.75,0,0,0,0.8,0,0.2,1,0.8,0),(43,1,0.32941,0.76364,0.65,0.33333,0.8,0.8,0.6,0.8,0.8,0.4,0.8,0.6,0.6,0.8,0.8,0.4,0.6,0.8,0.28571,0.5,0,0.4,1,0,0.2,0,1,0.2,1),(44,0,0.25882,0.47273,0.49,0.33333,0.8,0.8,0.6,1,1,1,0.8,0.8,0.6,0.8,0.6,1,0.8,1,0.42857,0.5,0.2,0.2,0.4,0.4,0.2,0.2,0.8,0.4,0),(45,0,0.27059,0.48182,0.44,0.33333,0.6,0.6,1,0.8,1,1,0.8,0.6,1,0.6,0.8,1,1,0.8,0.71429,0.16667,0.4,0.2,0.6,1,0.8,0.8,1,1,0),(46,1,0.32941,0.58182,0.397,0.33333,0.8,0.8,1,0.6,1,1,1,1,1,1,0.8,0.6,1,1,0.42857,0.41667,0,1,0,0,1,0.8,0.8,0.6,0),(47,1,0.48235,0.5,0.45,0.33333,0.4,0.4,0.8,0.4,0.2,0.4,0.6,0.6,0.6,0.6,0.6,0.6,0.2,0.4,0.14286,0.75,0,0.8,0,0,0,0.6,0.2,0,0),(48,1,0.44706,0.5,0.29,0.66667,0.4,1,0.8,0.8,1,1,0.8,1,0.4,0.8,0.8,1,0.6,1,0.71429,0.75,0.6,0.8,1,0,0,0.4,0.8,0.6,1),(49,1,0.08235,0.63636,0.84,0.33333,0.8,0.8,0.8,1,0.4,0.6,0.2,0.2,1,0,1,0,0,0,0.28571,0.25,0,0.4,0.6,0,0.4,0.6,0.4,0.6,0),(50,1,0.52941,0.58182,0.44,0,1,0,0.6,0.6,0.6,1,0.6,1,0.6,1,0.6,1,1,1,0.42857,0.08333,0,0,0,1,0.6,0.6,1,0,1),(51,1,0.23529,0.55455,0.34,0.66667,1,0.8,0.8,1,0.8,0.8,1,0.6,1,1,1,0.8,0.6,0.8,0.28571,0.41667,0.4,1,0.6,0.6,0.8,0,1,0.8,0.33333),(52,0,0.18824,0.53636,0.35,0,1,1,1,0.8,0.8,1,1,0.8,0.8,1,1,1,0.6,1,0.14286,0.5,1,0,1,0,0,0.8,1,1,1),(53,1,0.21176,0.8,0.56,0.66667,0.8,0.8,0.6,1,0.8,1,0.8,1,1,0.8,0.8,1,0,1,0.57143,0.5,0,1,1,0,1,0.4,0.8,0,1),(54,1,0.42353,0.60909,0.49,0.33333,1,0,0.8,0.8,0.4,0.8,0.8,0.6,0.8,0.8,0.4,0.8,0.4,0.8,0.28571,0.33333,0.4,0.8,0.8,0,1,0.8,1,0.6,0.33333),(55,1,0.08235,0.62727,0.34,0.33333,0.8,0.8,1,0.6,0.6,1,0.8,0.8,0.8,0.8,1,0.8,0.8,0.8,0.28571,0.25,0,0.8,0.8,0.2,1,1,0.6,0,1),(56,0,0.32941,0.45455,0.4,0.33333,1,0,0.4,0.4,1,1,0.8,0.8,1,0.8,0.8,1,1,1,0.71429,0.375,0,0,1,1,0.8,0.8,0.8,0.8,0),(57,0,0.29412,0.45455,0.39,0.33333,0.2,0.4,0.4,0.2,0.2,0.6,0.6,0.6,0.2,0.2,0.2,0.6,0.4,0.6,0.85714,0.25,0,0,0,0.2,0,0,0.4,0,0),(58,1,0.25882,0.59091,0.69,0,0.6,0.4,0.6,0.4,0.2,0.6,0.4,0.2,0.4,0.2,0.4,0.6,0.2,0.4,0.57143,0.75,0,0,0.4,0.4,0.2,0.2,0.4,0.4,0),(59,1,0.30588,0.61818,0.8,0,1,1,1,1,0.8,0.8,0.8,0.6,1,0.4,0.6,1,1,0.8,0,0,0,0,0,1,0,0,0.4,0.4,0),(60,1,0.31765,0.59091,0.5,0.66667,0.8,0.6,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.6,1,1,0.8,0.8,0.42857,0.5,0,0,0.8,0,0.6,0.6,0.4,0.4,0),(61,1,0.25882,0.48182,0.34,0.33333,1,1,1,0.4,0.4,1,0.8,0.2,1,0.4,1,0.6,0.6,0.2,0.42857,0.5,1,0.6,0.6,0,0.6,0.4,1,0.6,1),(62,0,0.25882,0.42727,0.47,0.33333,0.8,0,0.2,1,0.2,0.4,0.4,0.6,0.2,0.4,0.6,0.2,0.4,0.4,0,0,0,0,0,0.8,0.8,0,1,0,0),(63,1,0.17647,0.59091,0.3,0,1,0.8,0,0.4,0.6,0.8,0.8,0.8,0.8,0.6,1,1,1,1,0.28571,0.25,0,0,0.2,0.2,0.2,0.2,1,0,0.33333),(64,1,0.27059,0.53636,0.52,0.33333,0.6,0.8,0.8,0.8,0.6,0.8,0.8,0.6,0.6,0.4,0.6,0.8,0.8,0.8,0.71429,0.33333,0,0.2,0.8,0.4,1,0.6,1,0.2,1),(65,0,0.38824,0.47273,0.37,0.33333,1,0.6,0.6,1,1,1,1,1,0.8,0.8,0.8,1,0.6,1,0.57143,0.25,1,0,0.2,0.4,0,0,0.6,0,0),(66,1,0.14118,0.59091,0.39,0.66667,0.6,0.6,1,1,1,1,0.6,0.6,1,1,0.8,0.6,0.2,1,0.42857,0.5,0,0.8,1,0.2,1,1,1,1,1),(67,1,0.43529,0.59091,0.95,0.66667,1,0.6,0,1,0.8,1,0.8,0.6,0.8,0.8,0.8,1,0.6,0.8,0.57143,0.75,1,0.4,0.8,0.6,0,0.2,0.4,1,0),(68,0,0.27059,0.44545,0.32,0,0.4,0.4,0.4,0.4,0.8,1,0.8,0.8,0.8,0.8,0.6,0.6,0.6,0.8,0,0.5,1,0.6,0.4,0.6,0.4,0.6,0.4,1,0),(69,0,0.31765,0.4,0.18,0.66667,1,0.8,0.2,0.6,0.8,1,0.8,0.8,0.8,0.6,0.8,0.8,0.6,1,0.42857,0.75,0.8,0.8,0.2,1,0.2,0.6,0.8,1,1),(70,0,0.29412,0.45455,0.255,0.33333,1,1,1,1,1,1,0.8,0.8,0.2,1,1,0.6,1,1,0.42857,0.41667,0.4,1,0.8,1,0.4,0,1,1,1),(71,1,0.18824,0.58182,0.4,0.33333,0.4,0.6,0.6,0.8,0.6,1,1,0.8,1,0.6,0.8,1,0.2,0.2,0.57143,0.33333,0,0.4,1,0.2,0.8,1,0.4,0,1),(72,1,0.15294,0.61818,0.4,0.33333,0.8,0.8,0.8,0.8,0.2,1,1,0.4,0.8,0.2,0.8,0.4,0.2,0.6,0.57143,1,0.8,0.8,0.8,1,0.8,1,1,1,1),(73,0,0.31765,0.49091,0.49,0,0.8,0.8,1,0.6,1,1,1,1,1,1,0.6,1,0.8,0.8,0,0.16667,0,0,0.6,1,0.6,0.8,0.4,0,0),(74,1,0.25882,0.60909,0.5,0.33333,0.8,0.2,0.2,0,0.4,0.4,0.4,0.2,0.8,1,0.6,0.6,0.8,0.6,0.28571,0.25,0,0.8,0.8,1,0.8,0.8,0.8,1,0),(75,1,0.2,0.56364,0.37,0,0.8,0.8,1,0.8,1,1,0.6,0.6,0.8,1,1,0.8,1,0.8,0.28571,0.16667,0,0.6,0.6,0.6,0.6,0.6,0.8,1,1),(76,0,0.23529,0.43636,0.48,0.33333,0.4,0.4,0.4,0.4,0.6,1,0.8,0.6,1,1,0.6,0.8,0.8,0.8,1,0.75,0,0.4,0.4,0,0.8,0.4,1,0.8,0),(77,1,0.24706,0.46364,0.64,0,1,0.6,0.6,0.8,0.4,0.8,0.4,0.8,1,0.2,0.8,0.8,0.2,0.8,0.14286,0.25,0,0,0.6,0.6,0.2,0.6,0.8,0.4,0),(78,0,0.23529,0.48182,0.26,0.66667,1,1,1,1,1,1,1,1,0.6,1,1,0.8,0,1,0.71429,0.5,1,0,1,0,0.8,0.8,1,0,0.33333),(79,1,0.25882,0.62727,0.5,0.33333,0.4,0.4,0.4,0.4,0,0.6,0.6,0.6,0,0.6,0.2,0,0,0.6,0.71429,1,0.2,0.4,0.4,0.4,0.2,0,0.4,0,1),(80,1,0.38824,0.61818,0.79,0.66667,0.4,0.4,0.4,0.2,0,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0,0.2,0.71429,0.83333,0,0.6,1,0.4,0.4,1,0.8,0.4,0),(81,0,0.24706,0.49091,0.39,0.33333,0,0,0.2,0.2,0,0.4,0.2,0.2,0.4,0.4,0.2,0.4,0.4,0.4,0.57143,0.5,0.4,0.4,1,0.8,1,0.8,1,0.8,0.33333),(82,0,0.25882,0.38182,0.35,0.33333,0.8,0.8,0.6,0.8,1,1,0.8,0.8,0.8,0.8,1,0.8,0.8,1,0.71429,0.25,0,0,0,0.8,0,0,1,0.6,0),(83,1,0.38824,0.54545,0.61,0,0.2,1,0.8,0.8,0.4,0.4,1,0.8,1,0.2,0.2,1,0.8,0.4,0,0,0,0.4,0,0,0,0,0.8,0,0),(84,0,0.25882,0.51818,0.48,0,1,0.4,0.4,0.6,0.4,1,0.8,0.6,0.6,0.6,1,1,0.6,0.6,0.28571,0.5,0,0,1,1,0,0,0,0.6,0),(85,1,0.52941,0.54545,0.7,0.66667,1,0.6,1,0.2,0,1,0.8,1,0.8,0.8,0.6,1,0,1,0.42857,0.5,0.4,0.2,1,0.8,0.6,0.8,1,0,0),(86,0,0.30588,0.36364,0.25,1,0.6,0.6,0.4,0.8,0.8,0.4,0.8,0.8,0.4,1,0.6,1,0.4,1,0.85714,1,0,0.2,1,0.4,1,1,0.6,0.6,1),(87,1,0.30588,0.57273,0.52,0.33333,1,0.2,1,1,0.6,0.8,1,0.6,1,0.6,0.8,1,0.8,0.6,0.71429,0.5,0,0.6,0.8,0.2,0.8,1,0.6,0.2,1),(88,0,0.29412,0.33636,0.18,0.33333,1,1,0.8,0,0.6,1,1,0.8,0.6,0.8,1,0,0.4,0.8,0.42857,0.25,0,0,0.6,0.8,0.8,0,0.8,0,1),(89,0,0.4,0.4,0.35,0,0.6,0.6,0.6,0.6,0.2,0.8,0.6,1,1,0.6,0.6,1,0.4,1,0.28571,0.25,0.6,0,0.6,1,0.6,0.4,0.8,0.8,0),(90,1,0.45882,0.56364,0.49,0,1,0.8,0.8,0.6,0.6,0.8,0.8,0.8,0.8,1,0.8,0.8,1,1,0.14286,0.58333,0,0,1,0,0.4,0.4,0.6,0.2,0),(91,1,0.22353,0.58182,0.59,0,0.8,0.6,1,1,1,1,0.6,0.8,1,0.4,1,1,1,1,0.28571,1,0.6,1,0.6,1,0.6,0.6,1,1,0),(92,1,0.38824,0.58182,0.48,1,0.6,0.4,0.4,0.8,0.4,0.4,0.8,0.4,1,0.2,0.8,0.6,0.6,0.4,0.71429,0.5,0,1,1,0,1,1,1,0,1),(93,0,0.41176,0.53636,0.34,0.66667,1,0.6,0.6,0.6,1,1,1,1,1,1,1,1,1,1,0.71429,0.375,0.6,0,1,0.8,0.8,0,1,0,1),(94,0,0.4,0.5,0.4,0,0.2,1,0.6,0.6,0.6,0.6,0.8,0.6,1,0.6,0.8,0.8,0.6,0.8,0,0.41667,0,0.6,0.8,0.6,0.6,0.4,0.6,0,0.33333),(95,0,0.21176,0.46364,0.3,0.66667,0.8,0.6,0.6,0.4,1,1,1,0.6,1,0.8,1,1,1,1,0.71429,0.5,0,0,1,0.6,0.6,0.6,1,0.6,0),(96,1,0.25882,0.56364,0.37,0.33333,1,1,1,1,1,1,1,1,1,1,0.8,1,1,1,0.42857,0.25,1,0.8,0.6,0.4,0.2,0.6,1,0.6,0.33333),(97,0,0.22353,0.5,0.25,0,0.2,0,0.2,0.6,0.4,0,0.2,0.2,0.6,0.4,0.6,0.6,0.2,0.4,0.28571,0.25,0.4,0,0.2,0.2,0,0,0.4,0,1),(98,1,0.16471,0.57273,0.52,0.66667,0.6,0.6,0.6,1,0.2,0.8,0.8,0.6,0.6,0.8,0.8,0.6,0.4,0.8,0.14286,0.375,0.6,0.8,0.8,0.4,0.6,1,0.6,0.8,1),(99,0,0.55294,0.40909,0.39,0.66667,0.6,0.4,1,0.6,0.6,0.6,0.6,0.8,1,0.8,0.4,1,0.2,0.6,0.85714,0.66667,1,0,0.8,0.4,0,0,1,1,0),(100,0,0.17647,0.41818,0.26,0.33333,0,0.6,0,0,0,0.6,0.6,0.6,0,0.6,0.4,0,0,0.6,0.42857,0.75,0.2,0,0.2,0.4,0.4,0.2,0.4,0.4,0.33333),(101,1,0.38824,0.70909,0.46,0.66667,0.6,0.6,0.6,0.6,0.4,1,0.6,0.8,0.6,1,0.6,0.4,0.2,1,0.42857,0.33333,0,0,1,0,0.2,1,0.4,0.2,1),(102,1,0.27059,0.60909,0.46,0.33333,1,1,0.6,0,0,1,1,1,0,1,1,0,0,1,0.42857,0.375,0,1,0.6,0.4,1,1,1,0.8,0),(103,1,0.15294,0.59091,0.34,0.33333,0.8,0.8,0.8,0.8,0.6,0.6,0.2,0.4,1,0.6,0.8,1,0.2,0.8,0.14286,0.5,0,0.4,0.2,0,0,0.4,1,0.6,1),(104,1,0.51765,0.56364,0.76,0,0.8,0.8,0.8,0.6,0.8,0.8,0.6,0.6,0.8,0.8,1,1,1,0.8,0.14286,0.5,0,1,0,0,0,0,0.8,0,0),(105,1,0.32941,0.57273,0.54,0,1,0.8,0.6,1,1,0.6,0.8,0.8,1,0.6,1,0.8,1,1,0.28571,0.5,1,0.8,0,0,0,0.2,0.4,0,0),(106,1,0.25882,0.61818,0.44,0.33333,0.8,0.8,1,1,0.8,0.8,0.6,0.4,0.8,0.6,0.6,1,0.2,1,0.42857,0.5,0,0,1,0,0.6,0.8,0.6,0,1),(107,1,0.14118,0.59091,0.4,0.66667,0.6,1,0.6,0.8,0.8,1,1,1,1,1,0.8,0.8,1,1,0.71429,0.25,0,1,1,0,1,1,1,0,1),(108,1,0.30588,0.66364,0.47,1,1,0.2,0.4,0.4,0.2,1,1,0.2,0.4,0,1,0.4,0.2,1,0.85714,0.5,0.2,1,0.8,0,1,0,1,0.2,0.33333),(109,1,0.21176,0.59091,0.39,0,0.8,0.8,0.6,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0,0,0,0,0,0.2,0,0,1,0.2,1),(110,1,0.17647,0.63636,0.35,0.33333,1,0,0,0,0.8,0.8,0.8,0.8,0.8,0.6,1,0,1,1,0.42857,0.5,0.8,0,0.8,0.8,0.8,0.8,0.8,0.8,0.66667),(111,0,0.50588,0.45455,0.27,0.33333,0.8,0.6,0.6,0.8,0.8,1,0.4,0.8,0.6,0.6,0.8,0,1,1,0.71429,0.5,1,1,0.8,0.8,0.8,0.6,1,1,0),(112,0,0.21176,0.45455,0.36,0,0.6,0.6,0.6,0.8,0.8,0.8,0.8,0.6,0.8,0.6,0.4,0.4,0.4,0.8,0.28571,0.25,0.8,0.4,0.8,1,0,0,1,0,0.33333),(113,0,0.21176,0.45455,0.36,0,0.6,0.6,0.6,0.8,0.8,0.8,0.8,0.6,0.8,0.6,0.4,0.4,0.4,0.8,0.28571,0.25,0.8,0.4,0.8,1,0,0,1,0,0.33333),(114,0,0.30588,0.45455,0.9,0,1,0.8,0.6,0.6,0.4,0.8,1,0.8,0.8,0.4,0.6,0.8,0.4,0.4,0.14286,0.25,0,0.2,0,0,0,0,0.4,0,0),(115,1,0.17647,0.54545,0.35,0.66667,0.6,0.4,0.4,0.8,1,1,1,0.4,0.4,0.6,1,0.8,0.8,0.8,0.57143,0.5,0.2,0.8,1,0.4,1,0.8,1,0.4,1),(116,1,0.28235,0.59091,0.44,0,0.2,0.4,0,0.8,1,1,0.8,0.6,1,0.6,0.4,0.8,0.8,0.8,0.14286,0.5,0,0.6,0.2,0.2,0.4,0.4,0.6,0.2,1),(117,0,0.23529,0.5,0.34,1,0.6,0.6,0.4,0.8,0.2,1,0.6,0.6,0,0.6,0.8,0,0,1,0.85714,0.33333,0.6,0,1,0,1,0,0.8,0,0.33333),(118,0,0.24706,0.44545,0.5,0.33333,1,0.8,0.6,0.6,0.2,0.6,0.4,0.6,0.6,0.4,0.4,0.6,0.4,1,0.28571,0.66667,0.8,0.2,0.6,0.6,0,0.8,1,0.4,0),(119,1,0.25882,0.53636,0.51,0,0.6,0.4,0.8,0.8,0.8,0.8,0.8,0.8,1,1,0.6,0.8,0.8,1,0,0.5,0.8,0.6,0.6,0,0.6,0.4,0.8,0.6,0),(120,1,0.37647,0.60909,0.52,0.33333,0.4,0.8,0.6,0.4,0.4,0.4,0.8,0.2,0.4,0.4,0.6,0.6,0.2,0.4,0.42857,0.25,0,0.2,0.6,0.2,0.6,0.6,1,0.4,0),(121,1,0.34118,0.70909,0.64,0.33333,0.8,0.8,0.8,0.6,0,0.6,0.4,0.4,0.8,0.6,0.6,0.6,0,0.4,0.28571,0.5,0,0.2,0,0,0.8,0.8,0.8,0.2,0),(122,1,0.21176,0.63636,0.45,0.33333,0.8,0.4,0.8,0.2,0.8,0.6,0.6,0.6,0.6,0.8,0.4,0.8,0.6,0.8,0.14286,0.75,0,0,0,0,0,0,0,0,0.33333),(123,1,0.6,0.63636,0.68,0.66667,0.2,0,0.2,0,0.8,1,0.8,1,0.2,0.2,0.4,0.2,0.6,0.8,0.85714,0.25,0.2,1,0,0.2,0,0,1,0.4,0.33333),(124,0,0.16471,0.57273,0.43,0.66667,0.6,0.2,0.6,1,1,1,0.6,0.4,1,0.6,0.6,1,0.8,1,0.57143,0.75,0,0,1,0,0,0,0,0,1),(125,1,0.16471,0.77273,0.46,0.66667,0.8,0.4,0,0,0,1,1,1,0,1,0.8,0,0,1,0.42857,0.5,0.2,1,0,0.4,0.2,0,1,0,0.33333),(126,1,0.30588,0.66364,0.56,0.33333,1,1,1,0.8,0.2,0.6,0.4,0.2,0.6,0,0.4,0.4,0.2,0,0.28571,0.25,0,0,0.4,0,0.6,0.2,0.4,0,1),(127,0,0.18824,0.51818,0.3,0.33333,0.6,0.6,0.8,0.8,0.6,0.8,0.6,0.6,0.6,0.8,0.8,0.6,0.6,0.8,0.14286,0.5,1,0.4,0.4,0.8,0.2,0.6,0.6,0.6,0.33333),(128,0,0.21176,0.55455,0.33,0,0.8,0.6,0.6,0.8,0.6,0.4,0.6,0.8,0.6,0.8,0.8,0.6,0.6,0.8,0.28571,0.5,0.4,0.2,0.8,0.4,0,0,0.4,0.4,0),(129,0,0.2,0.34545,0.12,0.33333,0.8,0.2,0.6,0.2,0.8,0.4,0.4,0.4,0.4,0.2,1,0.8,0.4,0.6,0.28571,0.375,0.6,0.6,0.8,0,0,0.6,0.4,0,1),(130,1,0.30588,0.60909,0.49,0.66667,1,1,0,0,0,1,1,1,0,1,1,0,0,1,0.57143,0.5,1,1,0.6,0,1,0,0.8,1,0),(131,1,0.30588,0.68182,0.67,0,0.8,1,0.8,1,1,1,0.6,0,1,1,0.6,0.8,1,1,0.14286,0.75,0,0,1,0,0.2,0,0.6,0.2,1),(132,1,0.25882,0.68182,0.57,0.33333,0.2,1,1,1,0.4,1,0.2,0.4,1,1,0,1,0.6,1,0.71429,0.83333,0,0,1,0,0,1,0,1,1),(133,0,0.47059,0.61818,0.44,0.33333,1,1,0.8,0.6,0.6,1,0.6,0.6,0.8,1,1,0.8,0.8,1,0.14286,0.5,0.6,0.4,0.8,1,0.8,0.8,1,0.4,0),(134,1,0.24706,0.67273,0.4,0.33333,0.8,0.8,0.6,0.6,0.2,0.8,0.8,0.8,0.6,0.6,0.4,0.8,0.2,0.8,0.28571,0.16667,0.6,0.2,0.6,0.6,0.4,0.8,1,0.2,1),(135,1,0.17647,0.68182,0.48,0.66667,0,0,0.8,0,0.6,0.8,0.8,0.8,1,0.6,0.8,1,1,1,0.42857,0.5,0,0,1,0.4,1,0.8,1,0.2,0.33333),(136,0,0.23529,0.59091,0.4,0,0.6,0.6,0.2,0.2,0.8,0.6,0.6,0.6,0.2,0.4,0.8,0,1,0.8,0.14286,0.5,0,0,0.4,0,0,0,0.8,0,0.33333),(137,1,0.27059,0.68182,0.42,0.66667,0.2,0.4,0,0,0,1,0.8,0.8,0,1,0.2,0,0,1,0.71429,0.5,1,0,0.2,0,0.2,0.8,0.6,0,1),(138,0,0.17647,0.62727,0.33,0.33333,0.6,0.4,0.6,0.4,0.4,0.6,0.8,0.8,0.4,0.4,0.6,0.2,0.2,0.8,0.28571,0.25,0,0.4,0.4,0,0.6,0.2,1,0.2,0.33333),(139,1,0.22353,0.72727,0.77,0.66667,0.4,0.4,0.8,0.8,1,1,1,0.6,0,0.4,0.6,0.8,0.8,0.8,0.57143,1,0,0,1,0,0.6,0,0.2,0,0.33333),(140,0,0.2,0.57273,0.38,0.66667,1,0,0.4,0.8,0.4,1,0.8,0.6,0.6,0.4,0.8,0.6,0.4,0.6,0.42857,0.375,0,0,1,0,1,0,0.8,0,0),(141,1,0.18824,0.52727,0.31,0,1,0.8,0.8,0.6,0.6,0.8,0.6,0.4,0.8,0.6,0.8,1,0.8,0.6,0.42857,0.5,0,0,0,0.6,0,0.6,0.6,0,0.33333),(142,1,0.17647,0.62727,0.32,0.33333,0.8,0.6,0.8,0.4,0.6,0.6,0.8,0.6,0.8,0.8,0.8,0.6,0,0.8,0.42857,0.25,0.2,0.8,0.4,0,0.6,0.4,1,0.4,1),(143,1,0.17647,0.67273,0.594,0.66667,0.6,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.6,0.6,0.2,0.2,0,0.8,0.57143,0.33333,0,0,0.6,0,0.6,0,0.8,0,0),(144,1,0.25882,0.6,0.33,1,1,0.4,0.4,1,0.8,1,1,0.4,1,0.4,0.8,0.4,0.2,0.8,1,0.5,1,0.2,0.8,0.2,0.4,0.2,1,0.4,0.33333);
  /*!40000 ALTER TABLE `cf_users_normalised_data` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `cf_users_raw_data`
  --
  
  DROP TABLE IF EXISTS `cf_users_raw_data`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `cf_users_raw_data` (
    `user_id` int NOT NULL,
    `gender` float DEFAULT NULL,
    `age` float DEFAULT NULL,
    `height` float DEFAULT NULL,
    `weight` float DEFAULT NULL,
    `activity_level` float DEFAULT NULL,
    `bread_pref` float DEFAULT NULL,
    `cereal_pref` float DEFAULT NULL,
    `dairy_pref` float DEFAULT NULL,
    `egg_pref` float DEFAULT NULL,
    `fish_pref` float DEFAULT NULL,
    `fruits_pref` float DEFAULT NULL,
    `grains_pref` float DEFAULT NULL,
    `legumes_pref` float DEFAULT NULL,
    `meat_pref` float DEFAULT NULL,
    `nuts_pref` float DEFAULT NULL,
    `pasta_pref` float DEFAULT NULL,
    `poultry_pref` float DEFAULT NULL,
    `seafood_pref` float DEFAULT NULL,
    `vegetables_pref` float DEFAULT NULL,
    `days_pref` float DEFAULT NULL,
    `minutes_pref` float DEFAULT NULL,
    `balance_pref` float DEFAULT NULL,
    `bicycling_pref` float DEFAULT NULL,
    `conditioning_pref` float DEFAULT NULL,
    `dancing_pref` float DEFAULT NULL,
    `running_pref` float DEFAULT NULL,
    `sports_pref` float DEFAULT NULL,
    `walking_pref` float DEFAULT NULL,
    `water_pref` float DEFAULT NULL,
    `wellbeing` float DEFAULT NULL,
    PRIMARY KEY (`user_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `cf_users_raw_data`
  --
  
  LOCK TABLES `cf_users_raw_data` WRITE;
  /*!40000 ALTER TABLE `cf_users_raw_data` DISABLE KEYS */;
  INSERT INTO `cf_users_raw_data` VALUES (0,0,51,177,75,1,5,5,3,3,0,5,4,0,4,5,5,4,0,5,5,1,0,0,0,5,2,1,5,4,0),(1,1,32,169,100,0,5,5,5,5,5,5,5,5,1,5,3,4,0,5,4,60,0,5,5,5,5,1,1,1,0),(2,1,49,180,82,1,2,3,5,3,4,4,4,4,5,5,5,5,3,4,3,120,0,3,0,0,0,0,3,3,1),(3,1,36,172,120,2,2,1,2,2,2,1,1,1,2,0,1,2,2,1,0,0,0,0,0,1,0,1,1,0,0),(4,0,44,163,55,1,3,1,2,5,5,5,4,4,4,5,0,2,2,5,2,25,5,4,3,2,2,2,5,2,3),(5,0,19,162,65,2,5,5,5,2,1,5,5,2,2,5,5,1,1,5,5,30,5,5,5,5,0,5,5,5,0),(6,1,26,169,66,2,1,4,4,0,5,5,5,5,5,5,5,5,1,4,4,120,0,0,5,0,1,4,5,0,3),(7,0,32,157,50,2,5,3,5,5,5,5,4,5,5,5,5,4,3,4,6,65,4,5,3,3,5,4,4,4,3),(8,1,40,170,83,2,4,3,4,3,4,2,4,4,4,3,3,3,0,3,4,50,0,4,0,0,0,2,3,5,0),(9,0,20,168,67,0,5,3,3,5,3,5,5,3,5,1,2,2,2,4,0,30,0,0,0,5,3,2,5,5,0),(10,1,33,176,76,1,4,3,4,5,3,3,4,4,4,2,5,4,5,4,4,60,4,4,3,4,2,1,3,4,3),(11,1,13,150,42,3,5,5,5,3,1,5,4,3,5,4,3,5,2,4,4,120,3,5,3,5,5,5,4,4,3),(12,0,19,160,55,0,5,3,4,3,5,5,5,5,5,5,5,5,5,5,1,120,0,0,5,5,5,2,5,3,3),(13,0,18,163,57,1,0,0,0,5,1,5,0,1,1,5,0,0,5,5,5,70,5,5,5,5,5,5,5,0,1),(14,0,21,165,65,1,5,5,3,3,1,0,3,3,5,3,3,5,1,3,0,60,0,0,3,5,2,2,5,0,3),(15,0,19,160,40,1,5,3,5,4,3,5,4,4,4,4,3,4,3,5,3,60,2,4,5,5,5,3,5,3,2),(16,0,20,150,60,0,1,1,3,3,3,0,0,1,1,0,3,3,3,2,0,0,0,0,0,2,1,0,1,0,0),(17,0,18,158,58,0,5,3,3,5,5,5,5,4,3,5,4,5,5,5,2,120,0,0,0,5,1,0,5,0,0),(18,1,19,174,98,1,0,1,1,2,2,2,2,2,2,1,2,0,2,2,2,80,0,1,1,1,5,5,5,3,0),(19,0,50,170,63,1,5,5,5,5,5,5,5,5,3,2,2,4,1,5,4,60,0,0,4,3,0,1,5,0,3),(20,1,33,184,90,1,2,4,4,3,3,2,4,3,3,2,4,3,2,2,2,60,0,5,3,3,1,3,3,4,1),(21,0,34,174,78,1,5,3,4,5,2,4,4,4,5,5,4,4,3,4,2,30,0,0,0,5,2,2,4,0,0),(22,1,33,170,65,2,5,5,4,5,1,5,4,1,5,5,3,4,0,5,5,75,0,0,5,5,4,1,3,3,3),(23,1,56,170,89,2,4,0,2,0,2,2,3,3,0,2,2,1,3,4,5,80,0,1,5,3,0,1,1,0,0),(24,0,38,153,66,0,2,1,1,2,2,2,2,2,2,1,2,2,1,2,0,0,0,0,0,1,0,0,1,0,0),(25,1,35,162,78,3,3,3,3,4,2,2,2,2,4,2,2,2,1,1,6,120,0,2,2,3,3,3,5,3,1),(26,1,33,170,90,0,3,3,3,5,5,5,5,4,5,3,3,5,5,4,1,20,0,2,5,2,0,3,5,3,0),(27,1,29,176,60,0,4,4,5,5,5,4,4,3,4,3,3,2,2,2,2,120,0,1,5,0,4,3,5,0,3),(28,0,31,162,80,1,2,1,1,2,2,2,2,1,2,2,0,2,0,4,3,30,0,0,2,5,0,0,5,0,0),(29,1,28,162,64,1,5,3,4,5,4,2,3,2,5,2,3,3,0,1,1,20,0,0,5,5,2,0,5,0,3),(30,0,16,157,55,1,2,1,1,3,2,2,2,1,3,2,3,0,3,3,5,60,0,1,2,2,2,2,1,1,0),(31,0,16,160,55.7,3,0,0,0,2,2,5,3,1,1,3,4,2,4,5,7,60,0,2,5,5,3,5,4,5,0),(32,0,16,150,47,0,3,2,3,2,0,4,3,3,2,2,2,2,0,2,2,60,2,1,3,3,1,3,2,3,1),(33,0,38,166,58,1,3,0,1,3,5,5,4,5,1,5,1,1,2,5,4,50,2,0,3,2,2,1,2,0,3),(34,1,32,170,70,2,5,5,5,5,5,5,5,5,5,5,5,5,5,5,7,5,0,5,5,1,5,5,5,0,0),(35,1,24,183,65,1,1,1,0,1,1,2,2,2,2,1,1,1,1,2,2,50,0,0,1,0,1,0,2,0,3),(36,0,39,156,67,0,5,3,3,4,5,5,4,3,5,0,2,2,5,4,0,0,0,0,0,4,4,4,4,0,1),(37,1,34,184,100,0,5,4,4,5,4,5,3,4,5,3,5,5,5,4,1,20,0,0,0,0,0,0,5,0,0),(38,1,31,168,75,0,4,4,5,4,3,4,3,2,5,2,2,4,4,4,0,0,0,0,0,2,1,0,4,3,0),(39,0,30,154,55,2,3,3,3,3,2,2,1,1,3,1,2,2,1,1,4,60,2,0,5,5,5,4,4,1,0),(40,0,42,164,60,1,5,4,2,4,5,2,4,3,5,4,5,5,5,1,3,60,0,1,0,5,0,0,5,0,1),(41,1,32,176,110,1,4,1,5,5,3,5,5,5,5,3,4,5,3,4,3,60,1,1,3,3,0,1,5,5,0),(42,0,47,167,110,0,4,3,2,3,3,4,4,4,1,4,4,4,4,4,1,90,0,0,0,4,0,1,5,4,0),(43,1,38,194,95,1,4,4,3,4,4,2,4,3,3,4,4,2,3,4,2,60,0,2,5,0,1,0,5,1,3),(44,0,32,162,79,1,4,4,3,5,5,5,4,4,3,4,3,5,4,5,3,60,1,1,2,2,1,1,4,2,0),(45,0,33,163,74,1,3,3,5,4,5,5,4,3,5,3,4,5,5,4,5,20,2,1,3,5,4,4,5,5,0),(46,1,38,174,69.7,1,4,4,5,3,5,5,5,5,5,5,4,3,5,5,3,50,0,5,0,0,5,4,4,3,0),(47,1,51,165,75,1,2,2,4,2,1,2,3,3,3,3,3,3,1,2,1,90,0,4,0,0,0,3,1,0,0),(48,1,48,165,59,2,2,5,4,4,5,5,4,5,2,4,4,5,3,5,5,90,3,4,5,0,0,2,4,3,3),(49,1,17,180,114,1,4,4,4,5,2,3,1,1,5,0,5,0,0,0,2,30,0,2,3,0,2,3,2,3,0),(50,1,55,174,74,0,5,0,3,3,3,5,3,5,3,5,3,5,5,5,3,10,0,0,0,5,3,3,5,0,3),(51,1,30,171,64,2,5,4,4,5,4,4,5,3,5,5,5,4,3,4,2,50,2,5,3,3,4,0,5,4,1),(52,0,26,169,65,0,5,5,5,4,4,5,5,4,4,5,5,5,3,5,1,60,5,0,5,0,0,4,5,5,3),(53,1,28,198,86,2,4,4,3,5,4,5,4,5,5,4,4,5,0,5,4,60,0,5,5,0,5,2,4,0,3),(54,1,46,177,79,1,5,0,4,4,2,4,4,3,4,4,2,4,2,4,2,40,2,4,4,0,5,4,5,3,1),(55,1,17,179,64,1,4,4,5,3,3,5,4,4,4,4,5,4,4,4,2,30,0,4,4,1,5,5,3,0,3),(56,0,38,160,70,1,5,0,2,2,5,5,4,4,5,4,4,5,5,5,5,45,0,0,5,5,4,4,4,4,0),(57,0,35,160,69,1,1,2,2,1,1,3,3,3,1,1,1,3,2,3,6,30,0,0,0,1,0,0,2,0,0),(58,1,32,175,99,0,3,2,3,2,1,3,2,1,2,1,2,3,1,2,4,90,0,0,2,2,1,1,2,2,0),(59,1,36,178,110,0,5,5,5,5,4,4,4,3,5,2,3,5,5,4,0,0,0,0,0,5,0,0,2,2,0),(60,1,37,175,80,2,4,3,4,4,4,4,4,4,4,3,5,5,4,4,3,60,0,0,4,0,3,3,2,2,0),(61,1,32,163,64,1,5,5,5,2,2,5,4,1,5,2,5,3,3,1,3,60,5,3,3,0,3,2,5,3,3),(62,0,32,157,77,1,4,0,1,5,1,2,2,3,1,2,3,1,2,2,0,0,0,0,0,4,4,0,5,0,0),(63,1,25,175,60,0,5,4,0,2,3,4,4,4,4,3,5,5,5,5,2,30,0,0,1,1,1,1,5,0,1),(64,1,33,169,82,1,3,4,4,4,3,4,4,3,3,2,3,4,4,4,5,40,0,1,4,2,5,3,5,1,3),(65,0,43,162,67,1,5,3,3,5,5,5,5,5,4,4,4,5,3,5,4,30,5,0,1,2,0,0,3,0,0),(66,1,22,175,69,2,3,3,5,5,5,5,3,3,5,5,4,3,1,5,3,60,0,4,5,1,5,5,5,5,3),(67,1,47,175,125,2,5,3,0,5,4,5,4,3,4,4,4,5,3,4,4,90,5,2,4,3,0,1,2,5,0),(68,0,33,159,62,0,2,2,2,2,4,5,4,4,4,4,3,3,3,4,0,60,5,3,2,3,2,3,2,5,0),(69,0,37,154,48,2,5,4,1,3,4,5,4,4,4,3,4,4,3,5,3,90,4,4,1,5,1,3,4,5,3),(70,0,35,160,55.5,1,5,5,5,5,5,5,4,4,1,5,5,3,5,5,3,50,2,5,4,5,2,0,5,5,3),(71,1,26,174,70,1,2,3,3,4,3,5,5,4,5,3,4,5,1,1,4,40,0,2,5,1,4,5,2,0,3),(72,1,23,178,70,1,4,4,4,4,1,5,5,2,4,1,4,2,1,3,4,120,4,4,4,5,4,5,5,5,3),(73,0,37,164,79,0,4,4,5,3,5,5,5,5,5,5,3,5,4,4,0,20,0,0,3,5,3,4,2,0,0),(74,1,32,177,80,1,4,1,1,0,2,2,2,1,4,5,3,3,4,3,2,30,0,4,4,5,4,4,4,5,0),(75,1,27,172,67,0,4,4,5,4,5,5,3,3,4,5,5,4,5,4,2,20,0,3,3,3,3,3,4,5,3),(76,0,30,158,78,1,2,2,2,2,3,5,4,3,5,5,3,4,4,4,7,90,0,2,2,0,4,2,5,4,0),(77,1,31,161,94,0,5,3,3,4,2,4,2,4,5,1,4,4,1,4,1,30,0,0,3,3,1,3,4,2,0),(78,0,30,163,56,2,5,5,5,5,5,5,5,5,3,5,5,4,0,5,5,60,5,0,5,0,4,4,5,0,1),(79,1,32,179,80,1,2,2,2,2,0,3,3,3,0,3,1,0,0,3,5,120,1,2,2,2,1,0,2,0,3),(80,1,43,178,109,2,2,2,2,1,0,1,1,1,1,1,1,1,0,1,5,100,0,3,5,2,2,5,4,2,0),(81,0,31,164,69,1,0,0,1,1,0,2,1,1,2,2,1,2,2,2,4,60,2,2,5,4,5,4,5,4,1),(82,0,32,152,65,1,4,4,3,4,5,5,4,4,4,4,5,4,4,5,5,30,0,0,0,4,0,0,5,3,0),(83,1,43,170,91,0,1,5,4,4,2,2,5,4,5,1,1,5,4,2,0,0,0,2,0,0,0,0,4,0,0),(84,0,32,167,78,0,5,2,2,3,2,5,4,3,3,3,5,5,3,3,2,60,0,0,5,5,0,0,0,3,0),(85,1,55,170,100,2,5,3,5,1,0,5,4,5,4,4,3,5,0,5,3,60,2,1,5,4,3,4,5,0,0),(86,0,36,150,55,3,3,3,2,4,4,2,4,4,2,5,3,5,2,5,6,120,0,1,5,2,5,5,3,3,3),(87,1,36,173,82,1,5,1,5,5,3,4,5,3,5,3,4,5,4,3,5,60,0,3,4,1,4,5,3,1,3),(88,0,35,147,48,1,5,5,4,0,3,5,5,4,3,4,5,0,2,4,3,30,0,0,3,4,4,0,4,0,3),(89,0,44,154,65,0,3,3,3,3,1,4,3,5,5,3,3,5,2,5,2,30,3,0,3,5,3,2,4,4,0),(90,1,49,172,79,0,5,4,4,3,3,4,4,4,4,5,4,4,5,5,1,70,0,0,5,0,2,2,3,1,0),(91,1,29,174,89,0,4,3,5,5,5,5,3,4,5,2,5,5,5,5,2,120,3,5,3,5,3,3,5,5,0),(92,1,43,174,78,3,3,2,2,4,2,2,4,2,5,1,4,3,3,2,5,60,0,5,5,0,5,5,5,0,3),(93,0,45,169,64,2,5,3,3,3,5,5,5,5,5,5,5,5,5,5,5,45,3,0,5,4,4,0,5,0,3),(94,0,44,165,70,0,1,5,3,3,3,3,4,3,5,3,4,4,3,4,0,50,0,3,4,3,3,2,3,0,1),(95,0,28,161,60,2,4,3,3,2,5,5,5,3,5,4,5,5,5,5,5,60,0,0,5,3,3,3,5,3,0),(96,1,32,172,67,1,5,5,5,5,5,5,5,5,5,5,4,5,5,5,3,30,5,4,3,2,1,3,5,3,1),(97,0,29,165,55,0,1,0,1,3,2,0,1,1,3,2,3,3,1,2,2,30,2,0,1,1,0,0,2,0,3),(98,1,24,173,82,2,3,3,3,5,1,4,4,3,3,4,4,3,2,4,1,45,3,4,4,2,3,5,3,4,3),(99,0,57,155,69,2,3,2,5,3,3,3,3,4,5,4,2,5,1,3,6,80,5,0,4,2,0,0,5,5,0),(100,0,25,156,56,1,0,3,0,0,0,3,3,3,0,3,2,0,0,3,3,90,1,0,1,2,2,1,2,2,1),(101,1,43,188,76,2,3,3,3,3,2,5,3,4,3,5,3,2,1,5,3,40,0,0,5,0,1,5,2,1,3),(102,1,33,177,76,1,5,5,3,0,0,5,5,5,0,5,5,0,0,5,3,45,0,5,3,2,5,5,5,4,0),(103,1,23,175,64,1,4,4,4,4,3,3,1,2,5,3,4,5,1,4,1,60,0,2,1,0,0,2,5,3,3),(104,1,54,172,106,0,4,4,4,3,4,4,3,3,4,4,5,5,5,4,1,60,0,5,0,0,0,0,4,0,0),(105,1,38,173,84,0,5,4,3,5,5,3,4,4,5,3,5,4,5,5,2,60,5,4,0,0,0,1,2,0,0),(106,1,32,178,74,1,4,4,5,5,4,4,3,2,4,3,3,5,1,5,3,60,0,0,5,0,3,4,3,0,3),(107,1,22,175,70,2,3,5,3,4,4,5,5,5,5,5,4,4,5,5,5,30,0,5,5,0,5,5,5,0,3),(108,1,36,183,77,3,5,1,2,2,1,5,5,1,2,0,5,2,1,5,6,60,1,5,4,0,5,0,5,1,1),(109,1,28,175,69,0,4,4,3,4,4,4,4,4,4,4,4,4,4,4,0,0,0,0,0,1,0,0,5,1,3),(110,1,25,180,65,1,5,0,0,0,4,4,4,4,4,3,5,0,5,5,3,60,4,0,4,4,4,4,4,4,2),(111,0,53,160,57,1,4,3,3,4,4,5,2,4,3,3,4,0,5,5,5,60,5,5,4,4,4,3,5,5,0),(112,0,28,160,66,0,3,3,3,4,4,4,4,3,4,3,2,2,2,4,2,30,4,2,4,5,0,0,5,0,1),(113,0,28,160,66,0,3,3,3,4,4,4,4,3,4,3,2,2,2,4,2,30,4,2,4,5,0,0,5,0,1),(114,0,36,160,120,0,5,4,3,3,2,4,5,4,4,2,3,4,2,2,1,30,0,1,0,0,0,0,2,0,0),(115,1,25,170,65,2,3,2,2,4,5,5,5,2,2,3,5,4,4,4,4,60,1,4,5,2,5,4,5,2,3),(116,1,34,175,74,0,1,2,0,4,5,5,4,3,5,3,2,4,4,4,1,60,0,3,1,1,2,2,3,1,3),(117,0,30,165,64,3,3,3,2,4,1,5,3,3,0,3,4,0,0,5,6,40,3,0,5,0,5,0,4,0,1),(118,0,31,159,80,1,5,4,3,3,1,3,2,3,3,2,2,3,2,5,2,80,4,1,3,3,0,4,5,2,0),(119,1,32,169,81,0,3,2,4,4,4,4,4,4,5,5,3,4,4,5,0,60,4,3,3,0,3,2,4,3,0),(120,1,42,177,82,1,2,4,3,2,2,2,4,1,2,2,3,3,1,2,3,30,0,1,3,1,3,3,5,2,0),(121,1,39,188,94,1,4,4,4,3,0,3,2,2,4,3,3,3,0,2,2,60,0,1,0,0,4,4,4,1,0),(122,1,28,180,75,1,4,2,4,1,4,3,3,3,3,4,2,4,3,4,1,90,0,0,0,0,0,0,0,0,1),(123,1,61,180,98,2,1,0,1,0,4,5,4,5,1,1,2,1,3,4,6,30,1,5,0,1,0,0,5,2,1),(124,0,24,173,73,2,3,1,3,5,5,5,3,2,5,3,3,5,4,5,4,90,0,0,5,0,0,0,0,0,3),(125,1,24,195,76,2,4,2,0,0,0,5,5,5,0,5,4,0,0,5,3,60,1,5,0,2,1,0,5,0,1),(126,1,36,183,86,1,5,5,5,4,1,3,2,1,3,0,2,2,1,0,2,30,0,0,2,0,3,1,2,0,3),(127,0,26,167,60,1,3,3,4,4,3,4,3,3,3,4,4,3,3,4,1,60,5,2,2,4,1,3,3,3,1),(128,0,28,171,63,0,4,3,3,4,3,2,3,4,3,4,4,3,3,4,2,60,2,1,4,2,0,0,2,2,0),(129,0,27,148,42,1,4,1,3,1,4,2,2,2,2,1,5,4,2,3,2,45,3,3,4,0,0,3,2,0,3),(130,1,36,177,79,2,5,5,0,0,0,5,5,5,0,5,5,0,0,5,4,60,5,5,3,0,5,0,4,5,0),(131,1,36,185,97,0,4,5,4,5,5,5,3,0,5,5,3,4,5,5,1,90,0,0,5,0,1,0,3,1,3),(132,1,32,185,87,1,1,5,5,5,2,5,1,2,5,5,0,5,3,5,5,100,0,0,5,0,0,5,0,5,3),(133,0,50,178,74,1,5,5,4,3,3,5,3,3,4,5,5,4,4,5,1,60,3,2,4,5,4,4,5,2,0),(134,1,31,184,70,1,4,4,3,3,1,4,4,4,3,3,2,4,1,4,2,20,3,1,3,3,2,4,5,1,3),(135,1,25,185,78,2,0,0,4,0,3,4,4,4,5,3,4,5,5,5,3,60,0,0,5,2,5,4,5,1,1),(136,0,30,175,70,0,3,3,1,1,4,3,3,3,1,2,4,0,5,4,1,60,0,0,2,0,0,0,4,0,1),(137,1,33,185,72,2,1,2,0,0,0,5,4,4,0,5,1,0,0,5,5,60,5,0,1,0,1,4,3,0,3),(138,0,25,179,63,1,3,2,3,2,2,3,4,4,2,2,3,1,1,4,2,30,0,2,2,0,3,1,5,1,1),(139,1,29,190,107,2,2,2,4,4,5,5,5,3,0,2,3,4,4,4,4,120,0,0,5,0,3,0,1,0,1),(140,0,27,173,68,2,5,0,2,4,2,5,4,3,3,2,4,3,2,3,3,45,0,0,5,0,5,0,4,0,0),(141,1,26,168,61,0,5,4,4,3,3,4,3,2,4,3,4,5,4,3,3,60,0,0,0,3,0,3,3,0,1),(142,1,25,179,62,1,4,3,4,2,3,3,4,3,4,4,4,3,0,4,3,30,1,4,2,0,3,2,5,2,3),(143,1,25,184,89.4,2,3,4,4,4,4,4,4,4,3,3,1,1,0,4,4,40,0,0,3,0,3,0,4,0,0),(144,1,32,176,63,3,5,2,2,5,4,5,5,2,5,2,4,2,1,4,7,60,5,1,4,1,2,1,5,2,1);
  /*!40000 ALTER TABLE `cf_users_raw_data` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `exercise_balance`
  --
  
  DROP TABLE IF EXISTS `exercise_balance`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `exercise_balance` (
    `id` tinyint(1) NOT NULL,
    `name` varchar(50) NOT NULL,
    `indoors` tinyint(1) NOT NULL,
    `outdoors` tinyint(1) NOT NULL,
    `intensity` tinyint(1) NOT NULL,
    `met` float NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `exercise_balance`
  --
  
  LOCK TABLES `exercise_balance` WRITE;
  /*!40000 ALTER TABLE `exercise_balance` DISABLE KEYS */;
  INSERT INTO `exercise_balance` VALUES (1,'Slimnastics',1,0,2,6),(2,'Pilates',1,0,1,3),(3,'Fitball exercise',1,0,0,2.8),(4,'Yoga (Hatha)',1,0,0,2.5),(5,'Yoga (Surya Namaskar)',1,0,1,3.3),(6,'Tai-Chi (Qi Gong)',1,0,1,3);
  /*!40000 ALTER TABLE `exercise_balance` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `exercise_bicycling`
  --
  
  DROP TABLE IF EXISTS `exercise_bicycling`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `exercise_bicycling` (
    `id` tinyint(1) NOT NULL,
    `name` varchar(50) NOT NULL,
    `indoors` tinyint(1) NOT NULL,
    `outdoors` tinyint(1) NOT NULL,
    `intensity` tinyint(1) NOT NULL,
    `met` float NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `exercise_bicycling`
  --
  
  LOCK TABLES `exercise_bicycling` WRITE;
  /*!40000 ALTER TABLE `exercise_bicycling` DISABLE KEYS */;
  INSERT INTO `exercise_bicycling` VALUES (1,'Bicycling (to work or pleasure)',0,1,0,4),(2,'Bicycling (general)',0,1,1,5.8),(3,'Bicycling (vigorous)',0,1,2,10);
  /*!40000 ALTER TABLE `exercise_bicycling` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `exercise_conditioning`
  --
  
  DROP TABLE IF EXISTS `exercise_conditioning`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `exercise_conditioning` (
    `id` tinyint(1) NOT NULL,
    `name` varchar(50) NOT NULL,
    `indoors` tinyint(1) NOT NULL,
    `outdoors` tinyint(1) NOT NULL,
    `intensity` tinyint(1) NOT NULL,
    `met` float NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `exercise_conditioning`
  --
  
  LOCK TABLES `exercise_conditioning` WRITE;
  /*!40000 ALTER TABLE `exercise_conditioning` DISABLE KEYS */;
  INSERT INTO `exercise_conditioning` VALUES (1,'Stationary bycicling',1,0,1,3.5),(2,'Stationary bycicling',1,0,2,6.8),(3,'Calisthenics (sit ups, crunches)',1,0,0,2.8),(4,'Calisthenics (push ups, pull ups)',1,0,1,3.8),(5,'Circuit training',1,0,1,4.3),(6,'Eliptical trainer',1,0,1,5),(7,'Resistance training (weight lifting)',1,0,2,6),(8,'Resistance training (weight)',1,0,1,3.5),(10,'Stationary rowing',1,0,1,4.8),(11,'Video exercise workouts',1,0,2,6),(12,'Rope jumping',1,1,1,8.8),(13,'Rope jumping (fast pace)',1,1,2,12.3);
  /*!40000 ALTER TABLE `exercise_conditioning` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `exercise_dancing`
  --
  
  DROP TABLE IF EXISTS `exercise_dancing`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `exercise_dancing` (
    `id` tinyint(1) NOT NULL,
    `name` varchar(50) NOT NULL,
    `indoors` tinyint(1) NOT NULL,
    `outdoors` tinyint(1) NOT NULL,
    `intensity` tinyint(1) NOT NULL,
    `met` float NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `exercise_dancing`
  --
  
  LOCK TABLES `exercise_dancing` WRITE;
  /*!40000 ALTER TABLE `exercise_dancing` DISABLE KEYS */;
  INSERT INTO `exercise_dancing` VALUES (1,'Aerobic (high impact)',1,0,2,7.3),(2,'Aerobic (step)',1,0,1,5.5),(3,'Modern, jazz, general',1,0,1,5),(4,'Salsa, bachata',1,0,0,3.5);
  /*!40000 ALTER TABLE `exercise_dancing` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `exercise_running`
  --
  
  DROP TABLE IF EXISTS `exercise_running`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `exercise_running` (
    `id` tinyint(1) NOT NULL,
    `name` varchar(50) NOT NULL,
    `indoors` tinyint(1) NOT NULL,
    `outdoors` tinyint(1) NOT NULL,
    `intensity` tinyint(1) NOT NULL,
    `met` float NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `exercise_running`
  --
  
  LOCK TABLES `exercise_running` WRITE;
  /*!40000 ALTER TABLE `exercise_running` DISABLE KEYS */;
  INSERT INTO `exercise_running` VALUES (1,'Jogging-walk combination',0,1,2,6),(2,'Jogging (light)',0,1,1,4.5),(3,'Jogging (in place)',0,1,2,8),(4,'Running (ligh)',0,1,1,6),(5,'Running (moderate)',0,1,2,8),(6,'Running (stairs, up)',1,1,2,15);
  /*!40000 ALTER TABLE `exercise_running` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `exercise_sports`
  --
  
  DROP TABLE IF EXISTS `exercise_sports`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `exercise_sports` (
    `id` tinyint(1) NOT NULL,
    `name` varchar(50) NOT NULL,
    `indoors` tinyint(1) NOT NULL,
    `outdoors` tinyint(1) NOT NULL,
    `intensity` tinyint(1) NOT NULL,
    `met` float NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `exercise_sports`
  --
  
  LOCK TABLES `exercise_sports` WRITE;
  /*!40000 ALTER TABLE `exercise_sports` DISABLE KEYS */;
  INSERT INTO `exercise_sports` VALUES (1,'Basketball (non-game)',1,1,2,6),(2,'Billiards',1,0,0,2.5),(3,'Bowling',1,0,0,3),(4,'Football (light)',0,1,1,4),(5,'Freesbee',0,1,0,3),(6,'Skating',0,1,2,7),(7,'Soccer',1,1,2,7),(8,'Ping pong',1,0,1,4),(9,'Tennis ',1,1,2,7),(10,'Volleyball (non-game)',1,1,0,3),(11,'Rollerblading (recreational)',0,1,2,7.5);
  /*!40000 ALTER TABLE `exercise_sports` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `exercise_walking`
  --
  
  DROP TABLE IF EXISTS `exercise_walking`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `exercise_walking` (
    `id` tinyint(1) NOT NULL,
    `name` varchar(50) NOT NULL,
    `indoors` tinyint(1) NOT NULL,
    `outdoors` tinyint(1) NOT NULL,
    `intensity` tinyint(1) NOT NULL,
    `met` float NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `exercise_walking`
  --
  
  LOCK TABLES `exercise_walking` WRITE;
  /*!40000 ALTER TABLE `exercise_walking` DISABLE KEYS */;
  INSERT INTO `exercise_walking` VALUES (1,'Walking (slow)',0,1,0,2),(2,'Walking (for exercise)',0,1,1,4.3),(3,'Stair climbing (slow pace)',0,1,1,4),(4,'Star climbing (fast pace)',0,1,2,8.8),(5,'Walking (very brisk)',0,1,2,7);
  /*!40000 ALTER TABLE `exercise_walking` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `exercise_water`
  --
  
  DROP TABLE IF EXISTS `exercise_water`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `exercise_water` (
    `id` tinyint(1) NOT NULL,
    `name` varchar(50) NOT NULL,
    `indoors` tinyint(1) NOT NULL,
    `outdoors` tinyint(1) NOT NULL,
    `intensity` tinyint(1) NOT NULL,
    `met` float NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `exercise_water`
  --
  
  LOCK TABLES `exercise_water` WRITE;
  /*!40000 ALTER TABLE `exercise_water` DISABLE KEYS */;
  INSERT INTO `exercise_water` VALUES (1,'Water aerobics',1,0,1,5.3),(2,'Swimming (laps, slow)',1,0,1,5.8),(3,'Swimming (laps, vigorious)',1,0,2,9.8);
  /*!40000 ALTER TABLE `exercise_water` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `food_bread`
  --
  
  DROP TABLE IF EXISTS `food_bread`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `food_bread` (
    `id` tinyint(1) NOT NULL,
    `name` varchar(45) NOT NULL,
    `is_main` tinyint(1) NOT NULL,
    `time_breakfast` tinyint(1) NOT NULL,
    `time_lunch` tinyint(1) NOT NULL,
    `time_dinner` tinyint(1) NOT NULL,
    `is_vegetarian` tinyint(1) NOT NULL,
    `is_ vegan` tinyint(1) NOT NULL,
    `serving_size` float NOT NULL,
    `kilocalories` float NOT NULL,
    `protein` float NOT NULL,
    `carbohydrate` float NOT NULL,
    `sugar` float NOT NULL,
    `fiber` float NOT NULL,
    `fat` float NOT NULL,
    `saturated_fat` float NOT NULL,
    `cholesterol` float NOT NULL,
    `sodium` float NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `food_bread`
  --
  
  LOCK TABLES `food_bread` WRITE;
  /*!40000 ALTER TABLE `food_bread` DISABLE KEYS */;
  INSERT INTO `food_bread` VALUES (1,'Bread (French)',0,1,1,1,1,0,35,96,3,18,0,1.1,1,0.2,0,0.213),(2,'Bread (Italian)',0,1,1,1,1,0,35,95,3,18,0,0.9,1,0.3,0,0.204),(3,'Bread (mixed-grain)',0,1,1,1,1,0,35,88,4,16,4,2.2,1,0.3,0,0.17),(4,'Bread (oatmeal)',0,1,1,1,1,0,35,94,3,17,3,1.4,2,0.2,0,0.21),(5,'Bread (pita white)',0,1,1,1,1,0,60,165,5,33,1,1.3,1,0.1,0,0.322),(6,'Bread (pita whole wheat)',0,1,1,1,1,0,64,170,6,35,1,4.7,2,0.3,0,0.34),(7,'Bread (pumpermickel)',0,1,1,1,1,0,35,88,3,17,0,2.3,1,0.3,0,0.235),(8,'Bread (rye)',0,1,1,1,1,0,35,91,3,17,1,2,1,0.2,0,0.231),(9,'Bread (white)',0,1,1,1,1,0,35,93,3,18,2,0.8,1,0.3,0,0.238),(10,'Bread (whole wheat)',0,1,1,1,1,0,35,86,3,16,7,2.4,1,0.3,0,0.184),(11,'Roll (hamburguer or hotdog white)',0,0,1,0,1,0,43,120,4,21,3,0.9,2,0.5,0,0.206),(12,'Roll (hamburguer or hotdog whole wheat)',0,0,1,0,1,0,43,113,4,19,3,1.6,3,0.6,0,0.197),(13,'Tortilla (corn)',0,1,1,1,1,1,19,41,1,8,0,1.2,1,0.1,0,0.009),(14,'Tortilla (whole wheat)',0,1,1,1,1,1,49,159,4,27,0,1.6,3,0.9,0,0.234),(15,'French toast',0,1,0,0,1,0,59,126,4,19,0,0.6,4,0.9,0.048,0.292),(16,'Pancake (homemade)',0,1,0,0,1,0,38,86,2,11,0,0.5,4,0.8,0.022,0.167),(17,'Waffle (homemade)',0,1,0,0,1,0,37,103,3,14,2,0.5,4,0.7,0.033,0.146),(18,'Rusk toast',0,1,1,1,1,0,10,41,1,7,0,0.6,1,0.1,0,0.025),(19,'Crackers (wheat)',0,1,1,1,1,0,20,95,2,13,1,1.4,3,2,0,0.173),(20,'Crackers (whole wheat)',0,1,1,1,1,1,16,71,1,11,0,1.7,3,0.5,0,0.105);
  /*!40000 ALTER TABLE `food_bread` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `food_cereal`
  --
  
  DROP TABLE IF EXISTS `food_cereal`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `food_cereal` (
    `id` tinyint(1) NOT NULL,
    `name` varchar(50) NOT NULL,
    `is_main` tinyint(1) NOT NULL,
    `time_breakfast` tinyint(1) NOT NULL,
    `time_lunch` tinyint(1) NOT NULL,
    `time_dinner` tinyint(1) NOT NULL,
    `is_vegetarian` tinyint(1) NOT NULL,
    `is_vegan` tinyint(1) NOT NULL,
    `serving_size` float NOT NULL,
    `kilocalories` float NOT NULL,
    `protein` float NOT NULL,
    `carbohydrate` float NOT NULL,
    `sugar` float NOT NULL,
    `fiber` float NOT NULL,
    `fat` float NOT NULL,
    `saturated_fat` float NOT NULL,
    `cholesterol` float NOT NULL,
    `sodium` float NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `food_cereal`
  --
  
  LOCK TABLES `food_cereal` WRITE;
  /*!40000 ALTER TABLE `food_cereal` DISABLE KEYS */;
  INSERT INTO `food_cereal` VALUES (1,'Oat bran',1,1,0,1,1,1,179,73,3,12,0,3.4,1,0.3,0,0.001),(2,'All bran (cereal)',1,1,0,1,1,1,35,92,4,27,6,11.8,1,0,0,0.305),(3,'Cheerios honey nut (cereal)',1,1,0,1,1,0,35,134,3,28,12,2.1,1,0,0,0.252),(4,'Corn flakes (cereal)',1,1,0,1,1,1,26,103,2,23,2,0.7,0,0,0,0.19),(5,'Special K',1,1,0,1,1,1,24,94,4,18,2,0.3,0,0,0,0.226),(6,'Weetabix',1,1,0,1,1,1,35,130,4,29,2,4.4,1,0.1,0,0.126),(7,'Froot Loops',1,1,0,1,1,1,30,116,1,26,14,0.6,1,0,0,0.121),(8,'Frosted Flakes',1,1,0,1,1,1,37,142,2,33,15,0.6,0,0,0,0.196);
  /*!40000 ALTER TABLE `food_cereal` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `food_dairy`
  --
  
  DROP TABLE IF EXISTS `food_dairy`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `food_dairy` (
    `id` tinyint(1) NOT NULL,
    `name` varchar(50) NOT NULL,
    `is_main` tinyint(1) NOT NULL,
    `time_breakfast` tinyint(1) NOT NULL,
    `time_lunch` tinyint(1) NOT NULL,
    `time_dinner` tinyint(1) NOT NULL,
    `is_vegetarian` tinyint(1) NOT NULL,
    `is_vegan` tinyint(1) NOT NULL,
    `serving_size` float NOT NULL,
    `kilocalories` float NOT NULL,
    `protein` float NOT NULL,
    `carbohydrate` float NOT NULL,
    `sugar` float NOT NULL,
    `fiber` float NOT NULL,
    `fat` float NOT NULL,
    `saturated_fat` float NOT NULL,
    `cholesterol` float NOT NULL,
    `sodium` float NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `food_dairy`
  --
  
  LOCK TABLES `food_dairy` WRITE;
  /*!40000 ALTER TABLE `food_dairy` DISABLE KEYS */;
  INSERT INTO `food_dairy` VALUES (1,'Milk',0,1,0,0,1,0,259,88,9,13,13,0,0,0.2,0.005,0.109),(2,'Milk (partly skimmed)',0,1,0,0,1,0,258,129,9,12,13,0,5,3.3,0.021,0.106),(3,'Milk (skimmed)',0,1,0,0,1,0,258,155,8,12,14,0,8,5.4,0.026,0.103),(4,'Rice milk',0,1,0,0,1,1,259,127,0,26,0,0,2,0.2,0,0.091),(5,'Soy milk',0,1,0,0,1,1,257,110,7,13,9,0,4,0.5,0,0.12),(6,'Yoghurt',1,1,0,0,1,0,207,145,5,24,24,0,3,2.1,0.012,0.081),(7,'Kefir',1,1,0,0,1,0,165,104,6,7,6,0,6,3.8,0.025,0.07),(8,'Blue cheese',0,0,1,1,1,0,50,177,11,1,0,0,14,9.3,0.038,0.698),(9,'Cheddar chesse',0,0,1,1,1,0,50,202,12,1,0,0,17,10.5,0.053,0.311),(10,'Goat cheese',0,0,1,1,1,0,50,134,9,0,0,0,11,7.3,0.023,0.184),(11,'Cottage cheese',0,1,1,1,1,0,119,86,15,3,3,0,1,0.8,0.005,0.5),(12,'Gouda cheese',0,1,1,1,1,0,50,178,13,1,1,0,14,9,0.058,0.41),(13,'Mozzarella',0,0,1,1,1,0,50,141,10,1,1,0,11,6.8,0.039,0.187);
  /*!40000 ALTER TABLE `food_dairy` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `food_egg`
  --
  
  DROP TABLE IF EXISTS `food_egg`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `food_egg` (
    `id` tinyint(1) NOT NULL,
    `name` varchar(50) NOT NULL,
    `is_main` tinyint(1) NOT NULL,
    `time_breakfast` tinyint(1) NOT NULL,
    `time_lunch` tinyint(1) NOT NULL,
    `time_dinner` tinyint(1) NOT NULL,
    `is_vegetarian` tinyint(1) NOT NULL,
    `is_vegan` tinyint(1) NOT NULL,
    `serving_size` float NOT NULL,
    `kilocalories` float NOT NULL,
    `protein` float NOT NULL,
    `carbohydrate` float NOT NULL,
    `sugar` float NOT NULL,
    `fiber` float NOT NULL,
    `fat` float NOT NULL,
    `saturated_fat` float NOT NULL,
    `cholesterol` float NOT NULL,
    `sodium` float NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `food_egg`
  --
  
  LOCK TABLES `food_egg` WRITE;
  /*!40000 ALTER TABLE `food_egg` DISABLE KEYS */;
  INSERT INTO `food_egg` VALUES (1,'Egg white',1,1,1,1,1,0,33,226,14,0,0,0,0,0,0,0.106),(2,'Egg yolk',1,1,1,1,1,0,17,59,3,1,0,0,6,1.7,0.202,0.034),(3,'Fried egg',1,1,1,1,1,0,92,173,12,2,0,0,14,3.6,0.367,0.322),(4,'Boiled egg',1,1,1,1,1,0,50,78,6,1,0,0,5,1.6,0.216,0.062),(5,'Poached egg',1,1,1,1,1,0,50,74,6,0,0,0,5,1.5,0.215,0.147),(6,'Scrambled egg',1,1,1,1,1,0,124,189,13,4,0,0,14,4.1,0.363,0.476),(7,'Spanish omelet',1,1,1,1,1,0,290,319,15,13,0,0,24,5.7,0.353,0.607);
  /*!40000 ALTER TABLE `food_egg` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `food_fish`
  --
  
  DROP TABLE IF EXISTS `food_fish`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `food_fish` (
    `id` tinyint(1) NOT NULL,
    `name` varchar(50) NOT NULL,
    `is_main` tinyint(1) NOT NULL,
    `time_breakfast` tinyint(1) NOT NULL,
    `time_lunch` tinyint(1) NOT NULL,
    `time_dinner` tinyint(1) NOT NULL,
    `is_vegetarian` tinyint(1) NOT NULL,
    `is_vegan` tinyint(1) NOT NULL,
    `serving_size` float NOT NULL,
    `kilocalories` float NOT NULL,
    `protein` float NOT NULL,
    `carbohydrate` float NOT NULL,
    `sugar` float NOT NULL,
    `fiber` float NOT NULL,
    `fat` float NOT NULL,
    `saturated_fat` float NOT NULL,
    `cholesterol` float NOT NULL,
    `sodium` float NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `food_fish`
  --
  
  LOCK TABLES `food_fish` WRITE;
  /*!40000 ALTER TABLE `food_fish` DISABLE KEYS */;
  INSERT INTO `food_fish` VALUES (1,'Canned anchovies',1,0,1,1,0,0,8,17,2,0,0,0,1,0.2,0.007,0.293),(2,'Herring',1,0,1,1,0,0,75,163,18,0,0,0,9,2.1,0.062,0.689),(3,'Mackerel',1,0,1,1,0,0,75,197,18,0,0,0,13,3.1,0.056,0.062),(4,'Ocean perch',1,0,1,1,0,0,75,91,18,0,0,0,2,0.2,0.041,0.072),(5,'Pollock',1,0,1,1,0,0,75,89,19,0,0,0,1,0.1,0.068,0.083),(6,'Salmon',1,0,1,1,0,0,75,134,18,0,0,0,6,1.5,0.047,0.039),(7,'Canned sarnide',1,0,1,1,0,0,106,220,26,0,0,0,12,1.6,0.151,0.535),(8,'Tuna',1,0,1,1,0,0,75,149,22,0,0,0,6,1.2,0.014,0.266),(9,'Turbot',1,0,1,1,0,0,75,92,15,0,0,0,3,0,0.047,0.144),(10,'Whitefish',1,0,1,1,0,0,75,100,17,0,0,0,3,0.9,0.058,0.033);
  /*!40000 ALTER TABLE `food_fish` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `food_fruit`
  --
  
  DROP TABLE IF EXISTS `food_fruit`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `food_fruit` (
    `id` tinyint(1) NOT NULL,
    `name` varchar(50) NOT NULL,
    `is_main` tinyint(1) NOT NULL,
    `time_breakfast` tinyint(1) NOT NULL,
    `time_lunch` tinyint(1) NOT NULL,
    `time_dinner` tinyint(1) NOT NULL,
    `is_vegetarian` tinyint(1) NOT NULL,
    `is_vegan` tinyint(1) NOT NULL,
    `serving_size` float NOT NULL,
    `kilocalories` float NOT NULL,
    `protein` float NOT NULL,
    `carbohydrate` float NOT NULL,
    `sugar` float NOT NULL,
    `fiber` float NOT NULL,
    `fat` float NOT NULL,
    `saturated_fat` float NOT NULL,
    `cholesterol` float NOT NULL,
    `sodium` float NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `food_fruit`
  --
  
  LOCK TABLES `food_fruit` WRITE;
  /*!40000 ALTER TABLE `food_fruit` DISABLE KEYS */;
  INSERT INTO `food_fruit` VALUES (1,'Apple',1,1,0,1,1,1,138,72,0,19,14,2.6,0,0,0,0.001),(2,'Banana',1,1,0,1,1,1,118,105,1,27,14,2.1,0,0,0,0.001),(3,'Grapes',0,1,0,1,1,1,100,69,1,18,15,1.2,0,0,0,0.002),(4,'Kiwi',1,1,0,1,1,1,76,46,1,11,7,2.3,0,0,0,0.002),(5,'Mango',1,1,0,1,1,1,104,67,1,18,15,1.9,0,0,0,0.002),(6,'Watermelon',1,1,0,1,1,1,80,24,0,6,5,0.3,0,0,0,0.001),(7,'Orange',0,1,0,1,1,1,131,62,1,15,12,2.3,0,0,0,0),(8,'Papaya',1,1,0,1,1,1,74,29,0,7,4,1.3,0,0,0,0.002),(9,'Peach',0,1,0,0,1,1,98,38,1,9,8,1.9,0,0,0,0),(10,'Pear',1,1,0,1,1,1,166,96,1,26,16,5,0,0,0,0.002),(11,'Pineapple',1,1,0,1,1,1,82,42,0,11,8,1.1,0,0,0,0.001),(12,'Mandarin (tangerine)',0,1,0,1,1,1,84,45,1,11,9,1.5,0,0,0,0.002),(13,'Plum',0,1,0,1,1,1,66,30,0,8,7,1.1,0,0,0,0),(14,'Grapefruit',0,1,0,1,1,1,123,52,1,13,8,2,0,0,0,0);
  /*!40000 ALTER TABLE `food_fruit` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `food_grain`
  --
  
  DROP TABLE IF EXISTS `food_grain`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `food_grain` (
    `id` tinyint(1) NOT NULL,
    `name` varchar(50) NOT NULL,
    `is_main` tinyint(1) NOT NULL,
    `time_breakfast` tinyint(1) NOT NULL,
    `time_lunch` tinyint(1) NOT NULL,
    `time_dinner` tinyint(1) NOT NULL,
    `is_vegetarian` tinyint(1) NOT NULL,
    `is_vegan` tinyint(1) NOT NULL,
    `serving_size` float NOT NULL,
    `kilocalories` float NOT NULL,
    `protein` float NOT NULL,
    `carbohydrate` float NOT NULL,
    `sugar` float NOT NULL,
    `fiber` float NOT NULL,
    `fat` float NOT NULL,
    `saturated_fat` float NOT NULL,
    `cholesterol` float NOT NULL,
    `sodium` float NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `food_grain`
  --
  
  LOCK TABLES `food_grain` WRITE;
  /*!40000 ALTER TABLE `food_grain` DISABLE KEYS */;
  INSERT INTO `food_grain` VALUES (1,'Bulgur',0,1,1,1,1,1,96,80,3,18,0,2.7,0,0,0,0.005),(2,'Couscous',0,1,1,1,1,1,83,93,3,19,0,0.7,0,0,0,0.004),(3,'Quinoa',0,1,1,1,1,1,73,70,2,13,0,1.3,1,0.1,0,0.004),(4,'Rice (brown)',0,0,1,0,1,1,103,115,3,24,0,1.5,1,0.2,0,0.005),(5,'Rice (white)',0,0,1,0,1,1,83,109,2,24,0,0.4,0,0.1,0,0.001);
  /*!40000 ALTER TABLE `food_grain` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `food_legume`
  --
  
  DROP TABLE IF EXISTS `food_legume`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `food_legume` (
    `id` tinyint(1) NOT NULL,
    `name` varchar(50) NOT NULL,
    `is_main` tinyint(1) NOT NULL,
    `time_breakfast` tinyint(1) NOT NULL,
    `time_lunch` tinyint(1) NOT NULL,
    `time_dinner` tinyint(1) NOT NULL,
    `is_vegetarian` tinyint(1) NOT NULL,
    `is_vegan` tinyint(1) NOT NULL,
    `serving_size` float NOT NULL,
    `kilocalories` float NOT NULL,
    `protein` float NOT NULL,
    `carbohydrate` float NOT NULL,
    `sugar` float NOT NULL,
    `fiber` float NOT NULL,
    `fat` float NOT NULL,
    `saturated_fat` float NOT NULL,
    `cholesterol` float NOT NULL,
    `sodium` float NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `food_legume`
  --
  
  LOCK TABLES `food_legume` WRITE;
  /*!40000 ALTER TABLE `food_legume` DISABLE KEYS */;
  INSERT INTO `food_legume` VALUES (1,'Meatless chicken nuggets',1,1,1,1,1,0,72,168,15,6,0,3.1,9,0.8,0,0.288),(2,'Meatless ground beef',1,1,1,1,1,0,75,148,16,6,1,3.5,7,1.1,0,0.413),(3,'Tofu (firm)',1,1,1,1,1,1,150,189,21,3,1,0,11,1.3,0,0.026),(4,'Tofu (soft)',1,1,1,1,1,1,150,83,7,4,2,0.2,4,0.5,0,0.008),(5,'Vegetable patty',1,1,1,1,1,1,90,138,18,7,0,5.7,4,1,0,0.411),(6,'Meatless wiener',0,1,1,1,1,1,46,107,9,4,0,1.8,6,0.9,0,0.217),(7,'Beans',0,1,1,1,1,1,187,283,10,40,0,10.3,10,3.6,0,0.79),(8,'Refried beans ',0,1,1,1,1,1,186,175,10,29,0,9.9,2,0.9,0,0.557),(9,'Chickpeas',0,1,1,1,1,1,178,211,9,40,0,7.8,2,0.2,0,0.531),(10,'Falafel',1,1,1,1,1,1,17,57,2,5,0,1.3,3,0.4,0,0.05),(11,'Hummus',0,1,1,1,1,1,57,94,4,8,0,3.4,5,0.8,0,0.215),(12,'Lentils',0,0,1,1,1,1,146,170,13,29,3,6.2,1,0.1,0,0.349),(13,'Peas',0,1,1,1,1,1,145,171,12,31,4,4.2,1,0.1,0,0.003),(14,'Peanuts',0,1,1,1,1,1,37,217,9,8,2,3,18,2.6,0,0.002);
  /*!40000 ALTER TABLE `food_legume` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `food_meat`
  --
  
  DROP TABLE IF EXISTS `food_meat`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `food_meat` (
    `id` tinyint(1) NOT NULL,
    `name` varchar(50) NOT NULL,
    `is_main` tinyint(1) NOT NULL,
    `time_breakfast` tinyint(1) NOT NULL,
    `time_lunch` tinyint(1) NOT NULL,
    `time_dinner` tinyint(1) NOT NULL,
    `is_vegetarian` tinyint(1) NOT NULL,
    `is_vegan` tinyint(1) NOT NULL,
    `serving_size` float NOT NULL,
    `kilocalories` float NOT NULL,
    `protein` float NOT NULL,
    `carbohydrate` float NOT NULL,
    `sugar` float NOT NULL,
    `fiber` float NOT NULL,
    `fat` float NOT NULL,
    `saturated_fat` float NOT NULL,
    `cholesterol` float NOT NULL,
    `sodium` float NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `food_meat`
  --
  
  LOCK TABLES `food_meat` WRITE;
  /*!40000 ALTER TABLE `food_meat` DISABLE KEYS */;
  INSERT INTO `food_meat` VALUES (1,'Beef blade roast',1,0,1,1,0,0,75,200,26,0,0,0,10,4,0.071,0.046),(2,'Beef cross rib roast',1,0,1,1,0,0,75,197,27,0,0,0,9,3.6,0.07,0.052),(3,'Beef flank steak',1,0,1,1,0,0,75,184,25,0,0,0,8,3.6,0.054,0.045),(4,'Beef rib eye steak',1,0,1,1,0,0,75,230,20,0,0,0,16,6.7,0.053,0.04),(5,'Beef rump roast',1,0,1,1,0,0,75,164,21,0,0,0,8,3.2,0.059,0.047),(6,'Beef T-Bone',1,0,1,1,0,0,75,216,22,0,0,0,13,5.6,0.054,0.051),(7,'Beef strip loin',1,0,1,1,0,0,75,191,23,0,0,0,10,4.3,0.055,0.043),(8,'Beef tenderloin',1,0,1,1,0,0,75,170,24,0,0,0,7,3.2,0.059,0.05),(9,'Veal cutlet',1,0,1,1,0,0,75,136,27,0,0,0,2,0.7,0.078,0.033),(10,'Veal stewing meal',1,0,1,1,0,0,75,141,26,0,0,0,3,1,0.109,0.07),(11,'Veal leg',1,0,1,1,0,0,75,120,21,0,0,0,3,1.4,0.077,0.051),(12,'Pork leg',1,0,1,0,0,0,75,189,22,0,0,0,11,3.9,0.072,0.047),(13,'Pork back ribs',1,0,1,0,0,0,75,274,21,0,0,0,20,7.9,0.085,0.1),(14,'Pork loin (pan-fried)',1,0,1,0,0,0,75,199,20,0,0,0,13,4.8,0.055,0.038),(15,'Pork spareribs',1,0,1,0,0,0,75,251,20,0,0,0,18,7,0.074,0.049),(16,'Pork tenderloin',1,0,1,0,0,0,75,108,21,0,0,0,2,0.8,0.052,0.044),(17,'Lamb leg',1,0,1,0,0,0,75,176,19,0,0,0,10,5.1,0.076,0.033),(18,'Lamb loin',1,0,1,0,0,0,75,222,18,0,0,0,16,7.9,0.085,0.038),(19,'Lamb rib',1,0,1,0,0,0,75,238,15,0,0,0,19,9.6,0.074,0.033),(20,'Beef liver',1,0,1,0,0,0,75,131,20,4,0,0,4,1.1,0.286,0.058),(21,'Chicken liver',1,0,1,0,0,0,75,129,19,1,0,0,5,1,0.423,0.069);
  /*!40000 ALTER TABLE `food_meat` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `food_nut`
  --
  
  DROP TABLE IF EXISTS `food_nut`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `food_nut` (
    `id` tinyint(1) NOT NULL,
    `name` varchar(50) NOT NULL,
    `is_main` tinyint(1) NOT NULL,
    `time_breakfast` tinyint(1) NOT NULL,
    `time_lunch` tinyint(1) NOT NULL,
    `time_dinner` tinyint(1) NOT NULL,
    `is_vegetarian` tinyint(1) NOT NULL,
    `is_vegan` tinyint(1) NOT NULL,
    `serving_size` float NOT NULL,
    `kilocalories` float NOT NULL,
    `protein` float NOT NULL,
    `carbohydrate` float NOT NULL,
    `sugar` float NOT NULL,
    `fiber` float NOT NULL,
    `fat` float NOT NULL,
    `saturated_fat` float NOT NULL,
    `cholesterol` float NOT NULL,
    `sodium` float NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `food_nut`
  --
  
  LOCK TABLES `food_nut` WRITE;
  /*!40000 ALTER TABLE `food_nut` DISABLE KEYS */;
  INSERT INTO `food_nut` VALUES (1,'Almond',0,1,1,1,1,1,36,208,8,7,2,4.2,18,1.4,0,0),(2,'Cashew',0,1,1,1,1,1,35,199,5,11,2,1,16,3.2,0,0.222),(3,'Macadamia nut',0,1,1,1,1,1,34,243,3,4,1,2.7,26,4.1,0,0.09),(4,'Mixed nuts (roasted)',0,1,1,1,1,1,35,206,6,9,0,3.1,18,2.4,0,0.004),(5,'Pistachios',0,1,1,1,1,1,31,177,7,8,2,3.2,14,1.7,0,0.126),(6,'Walnuts',0,1,1,1,1,1,25,166,4,3,1,1.7,17,1.6,0,0.001);
  /*!40000 ALTER TABLE `food_nut` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `food_pasta`
  --
  
  DROP TABLE IF EXISTS `food_pasta`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `food_pasta` (
    `id` tinyint(1) NOT NULL,
    `name` varchar(50) NOT NULL,
    `is_main` tinyint(1) NOT NULL,
    `time_breakfast` tinyint(1) NOT NULL,
    `time_lunch` tinyint(1) NOT NULL,
    `time_dinner` tinyint(1) NOT NULL,
    `is_vegetarian` tinyint(1) NOT NULL,
    `is_vegan` tinyint(1) NOT NULL,
    `serving_size` float NOT NULL,
    `kilocalories` float NOT NULL,
    `protein` float NOT NULL,
    `carbohydrate` float NOT NULL,
    `sugar` float NOT NULL,
    `fiber` float NOT NULL,
    `fat` float NOT NULL,
    `saturated_fat` float NOT NULL,
    `cholesterol` float NOT NULL,
    `sodium` float NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `food_pasta`
  --
  
  LOCK TABLES `food_pasta` WRITE;
  /*!40000 ALTER TABLE `food_pasta` DISABLE KEYS */;
  INSERT INTO `food_pasta` VALUES (1,'Macaroni',1,0,1,1,1,0,148,209,7,42,1,1.8,1,0.1,0,0.001),(2,'Noodles',1,0,1,1,1,0,11,60,1,7,0,0.4,4,0.5,0,0.05),(3,'Noodles (egg)',1,0,1,1,1,0,169,225,8,42,1,1.9,2,0.5,0.056,0.012),(4,'Noodles (rice)',1,0,1,1,1,0,186,203,2,46,0,1.9,0,0,0,0.035),(5,'Noodles (ramen)',1,0,1,1,1,0,85,371,9,54,1,2,13,6,0,1.76),(6,'Pasta',1,0,1,1,1,0,169,220,9,40,0,3.7,3,0.7,0.069,0.14),(7,'Spaguetti',1,0,1,1,1,0,148,209,7,42,1,2.5,1,0.1,0,0.001),(8,'Spaguetti (whole weat)',1,0,1,1,1,0,148,183,8,39,1,4.8,1,0.1,0,0.004);
  /*!40000 ALTER TABLE `food_pasta` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `food_poultry`
  --
  
  DROP TABLE IF EXISTS `food_poultry`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `food_poultry` (
    `id` tinyint(1) NOT NULL,
    `name` varchar(50) NOT NULL,
    `is_main` tinyint(1) NOT NULL,
    `time_breakfast` tinyint(1) NOT NULL,
    `time_lunch` tinyint(1) NOT NULL,
    `time_dinner` tinyint(1) NOT NULL,
    `is_vegetarian` tinyint(1) NOT NULL,
    `is_vegan` tinyint(1) NOT NULL,
    `serving_size` float NOT NULL,
    `kilocalories` float NOT NULL,
    `protein` float NOT NULL,
    `carbohydrate` float NOT NULL,
    `sugar` float NOT NULL,
    `fiber` float NOT NULL,
    `fat` float NOT NULL,
    `saturated_fat` float NOT NULL,
    `cholesterol` float NOT NULL,
    `sodium` float NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `food_poultry`
  --
  
  LOCK TABLES `food_poultry` WRITE;
  /*!40000 ALTER TABLE `food_poultry` DISABLE KEYS */;
  INSERT INTO `food_poultry` VALUES (1,'Chicken breast',1,0,1,1,0,0,75,119,25,0,0,0,2,0.4,0.064,0.056),(2,'Chicken drumstick',1,0,1,1,0,0,75,127,19,0,0,0,5,1.4,0.07,0.071),(3,'Chicken flesh',1,0,1,1,0,0,75,143,22,0,0,0,6,1.5,0.067,0.065),(4,'Chicken wing',1,0,1,1,0,0,75,218,20,0,0,0,15,4.1,0.063,0.062),(5,'Chicken lean',1,0,1,1,0,0,75,153,16,0,0,0,9,0,0.059,0.051),(6,'Duck',1,0,1,1,0,0,75,253,14,0,0,0,21,7.3,0.063,0.044),(7,'Turkey dark meat',1,1,1,1,0,0,75,162,17,0,0,0,9,2,0.082,0.062),(8,'Turkey light meat',1,1,1,1,0,0,75,116,21,0,0,0,2,0.7,0.055,0.051);
  /*!40000 ALTER TABLE `food_poultry` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `food_seafood`
  --
  
  DROP TABLE IF EXISTS `food_seafood`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `food_seafood` (
    `id` tinyint(1) NOT NULL,
    `name` varchar(50) NOT NULL,
    `is_main` tinyint(1) NOT NULL,
    `time_breakfast` tinyint(1) NOT NULL,
    `time_lunch` tinyint(1) NOT NULL,
    `time_dinner` tinyint(1) NOT NULL,
    `is_vegetarian` tinyint(1) NOT NULL,
    `is_vegan` tinyint(1) NOT NULL,
    `serving_size` float NOT NULL,
    `kilocalories` float NOT NULL,
    `protein` float NOT NULL,
    `carbohydrate` float NOT NULL,
    `sugar` float NOT NULL,
    `fiber` float NOT NULL,
    `fat` float NOT NULL,
    `saturated_fat` float NOT NULL,
    `cholesterol` float NOT NULL,
    `sodium` float NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `food_seafood`
  --
  
  LOCK TABLES `food_seafood` WRITE;
  /*!40000 ALTER TABLE `food_seafood` DISABLE KEYS */;
  INSERT INTO `food_seafood` VALUES (1,'Clams',1,0,1,1,0,0,85,125,22,4,0,0,2,0.2,0.078,0.095),(2,'Crab',1,0,1,1,0,0,71,71,15,0,0,0,1,0.2,0.063,0.238),(3,'Mussel',1,0,1,1,0,0,75,129,18,6,0,0,3,0.6,0.042,0.277),(4,'Oyster',1,0,1,1,0,0,131,90,9,5,0,0,3,0.8,0.072,0.147),(5,'Scallop',1,0,1,1,0,0,78,87,18,0,0,0,1,0.1,0.041,0.207),(6,'Shrimp',1,0,1,1,0,0,30,30,6,0,0,0,0,0.1,0.059,0.067);
  /*!40000 ALTER TABLE `food_seafood` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `food_vegetable`
  --
  
  DROP TABLE IF EXISTS `food_vegetable`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `food_vegetable` (
    `id` tinyint(1) NOT NULL,
    `name` varchar(50) NOT NULL,
    `is_main` tinyint(1) NOT NULL,
    `time_breakfast` tinyint(1) NOT NULL,
    `time_lunch` tinyint(1) NOT NULL,
    `time_dinner` tinyint(1) NOT NULL,
    `is_vegetarian` tinyint(1) NOT NULL,
    `is_vegan` tinyint(1) NOT NULL,
    `serving_size` float NOT NULL,
    `kilocalories` float NOT NULL,
    `protein` float NOT NULL,
    `carbohydrate` float NOT NULL,
    `sugar` float NOT NULL,
    `fiber` float NOT NULL,
    `fat` float NOT NULL,
    `saturated_fat` float NOT NULL,
    `cholesterol` float NOT NULL,
    `sodium` float NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `food_vegetable`
  --
  
  LOCK TABLES `food_vegetable` WRITE;
  /*!40000 ALTER TABLE `food_vegetable` DISABLE KEYS */;
  INSERT INTO `food_vegetable` VALUES (1,'Alfalfa',0,1,1,1,1,1,8,2,0,0,0,0.2,0,0,0,0.001),(2,'Asparagus',0,0,1,1,1,1,90,18,2,3,1,1.6,0,0,0,0.008),(3,'Bean sprout',0,0,1,1,1,1,66,33,3,7,0,1.2,0,0,0,0.006),(4,'Beet',0,1,1,1,1,1,90,40,2,9,7,1.8,0,0,0,0.069),(5,'Brocoli',0,0,1,1,1,1,97,27,3,5,1,2.3,0,0,0,0.023),(6,'Brussels sprouts',0,0,1,1,1,1,84,33,3,6,2,3.2,0,0,0,0.015),(7,'Carrot',0,1,1,1,1,1,77,28,1,6,3,1.9,0,0,0,0.045),(8,'Cauliflower',0,0,1,1,1,1,66,15,1,3,1,1.8,0,0,0,0.01),(9,'Celery',0,1,1,1,1,1,40,6,0,1,1,0.6,0,0,0,0.032),(10,'Corn',0,0,1,1,1,1,87,82,3,19,3,2,1,0,0,0.008),(11,'Cucumber',0,0,1,1,1,1,28,3,0,1,0,0.2,0,0,0,0.001),(12,'Eggplant',0,0,1,1,1,1,52,18,0,5,2,1.3,0,0,0,0.001),(13,'Kale',0,0,1,1,1,1,69,19,1,4,1,1.4,0,0,0,0.016),(14,'Leek',0,0,1,1,1,1,55,17,0,4,0,0.5,0,0,0,0.005),(15,'Lettuce (looseleaf)',0,0,1,1,1,1,59,9,1,2,0,0.8,0,0,0,0.017),(16,'Mushroom',0,1,1,1,1,1,57,27,2,4,0,2.1,0,0,0,0.003),(17,'Onion',0,1,1,1,1,1,46,61,0,4,2,0.8,5,0,0,0.006),(18,'Green peas',0,1,1,1,1,1,85,66,4,12,4,3.7,0,0,0,0.061),(19,'Green pepper',0,0,1,1,1,1,82,16,1,4,2,1.2,0,0,0,0.002),(20,'Red pepper',0,0,1,1,1,1,60,15,1,4,2,0.8,0,0,0,0.001),(21,'Potato',0,0,1,1,1,1,150,129,3,30,1,2.5,0,0,0,0.007),(22,'Butternut squash',0,0,1,1,1,1,108,43,1,11,2,1.8,0,0,0,0.004),(23,'Tomato',0,1,1,1,1,1,123,22,1,5,3,1.5,0,0,0,0.006),(24,'Spinach',0,0,1,1,1,1,95,22,3,4,0,2.3,0,0,0,0.067),(25,'Zucchini',0,1,1,1,1,1,95,15,1,4,2,1.3,0,0,0,0.003),(26,'Avocado',0,1,1,1,1,1,101,161,2,9,1,6.7,15,0,0,0.007);
  /*!40000 ALTER TABLE `food_vegetable` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `restrictions_food`
  --
  
  DROP TABLE IF EXISTS `restrictions_food`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `restrictions_food` (
    `id` tinyint(1) NOT NULL,
    `inferior_limit` tinyint(1) DEFAULT NULL,
    `superior_limit` tinyint(1) DEFAULT NULL,
    `genre` tinyint(1) DEFAULT NULL,
    `protein` float DEFAULT NULL,
    `carbohydrate` float DEFAULT NULL,
    `sugar` float DEFAULT NULL,
    `fibre` float DEFAULT NULL,
    `fat` float DEFAULT NULL,
    `saturated_fat` float DEFAULT NULL,
    `sodium` float DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `restrictions_food`
  --
  
  LOCK TABLES `restrictions_food` WRITE;
  /*!40000 ALTER TABLE `restrictions_food` DISABLE KEYS */;
  INSERT INTO `restrictions_food` VALUES (1,7,10,0,28.3,227,23,20,66,21,5),(2,7,10,1,28.3,242,24,20,71,22,5),(3,11,14,0,41.2,267,27,25,78,24,6),(4,11,14,1,42.1,333,33,25,97,31,6),(5,15,18,0,45,267,27,30,78,24,6),(6,15,18,1,55.2,333,33,30,97,31,6),(7,19,64,0,45,267,27,30,78,24,6),(8,19,64,1,55.5,333,33,30,97,31,6),(9,65,74,0,46.5,255,26,30,74,23,6),(10,65,74,1,53.3,312,31,30,91,29,6),(11,75,100,0,46.5,245,25,30,72,23,6),(12,75,100,1,53.3,306,31,30,89,28,6);
  /*!40000 ALTER TABLE `restrictions_food` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `user_feedback`
  --
  
  DROP TABLE IF EXISTS `user_feedback`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `user_feedback` (
    `id` varchar(23) NOT NULL,
    `no_response_counter` tinyint DEFAULT NULL,
    `meal_0` tinyint(1) DEFAULT NULL,
    `pa_0` tinyint(1) DEFAULT NULL,
    `is_favorite_0` tinyint(1) DEFAULT NULL,
    `meal_1` tinyint(1) DEFAULT NULL,
    `pa_1` tinyint(1) DEFAULT NULL,
    `is_favorite_1` tinyint(1) DEFAULT NULL,
    `meal_2` tinyint(1) DEFAULT NULL,
    `pa_2` tinyint(1) DEFAULT NULL,
    `is_favorite_2` tinyint(1) DEFAULT NULL,
    `diversity` tinyint(1) DEFAULT NULL,
    `surprising` tinyint(1) DEFAULT NULL,
    `reliability` tinyint(1) DEFAULT NULL,
    `healthy` tinyint(1) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `user_feedback`
  --
  
  LOCK TABLES `user_feedback` WRITE;
  /*!40000 ALTER TABLE `user_feedback` DISABLE KEYS */;
  INSERT INTO `user_feedback` VALUES ('JustATest',0,3,2,0,4,3,1,4,3,1,5,4,4,5);
  /*!40000 ALTER TABLE `user_feedback` 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 2021-10-02 23:32:47
  