-- phpMyAdmin SQL Dump
-- version 4.6.6deb5ubuntu0.5
-- https://www.phpmyadmin.net/
--
-- Client :  localhost:3306
-- Généré le :  Jeu 09 Décembre 2021 à 16:24
-- Version du serveur :  5.7.35-0ubuntu0.18.04.2
-- Version de PHP :  7.2.24-0ubuntu0.18.04.9

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Base de données :  `dblebook`
--

-- --------------------------------------------------------

--
-- Structure de la table `categories`
--

CREATE TABLE `categories` (
  `category_id` int(11) NOT NULL,
  `category_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `category_slug` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `category_featured` tinyint(1) NOT NULL DEFAULT '0',
  `category_status` tinyint(1) NOT NULL DEFAULT '1',
  `category_author` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;

-- --------------------------------------------------------

--
-- Structure de la table `cepages`
--

CREATE TABLE `cepages` (
  `cepage_id` int(11) NOT NULL,
  `cepage_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cepage_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `cepage_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;

-- --------------------------------------------------------

--
-- Structure de la table `contenant`
--

CREATE TABLE `contenant` (
  `contenant_id` int(11) NOT NULL,
  `contenant_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `contenant_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `contenant_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;

-- --------------------------------------------------------

--
-- Structure de la table `difficulties`
--

CREATE TABLE `difficulties` (
  `difficult_id` int(11) NOT NULL,
  `difficult_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;

-- --------------------------------------------------------

--
-- Structure de la table `filters`
--

CREATE TABLE `filters` (
  `filter_id` int(11) NOT NULL,
  `filter_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `filter_category` int(11) DEFAULT NULL,
  `filter_status` tinyint(1) NOT NULL DEFAULT '1',
  `filter_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `filter_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `filter_author` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;

-- --------------------------------------------------------

--
-- Structure de la table `filters_1`
--

CREATE TABLE `filters_1` (
  `filter_1_id` int(11) NOT NULL,
  `filter_1_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `filter_1_category` int(11) DEFAULT NULL,
  `filter_1_filter` int(11) DEFAULT NULL,
  `filter_1_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `filter_1_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `filter_1_author` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;

-- --------------------------------------------------------

--
-- Structure de la table `filters_2`
--

CREATE TABLE `filters_2` (
  `filter_2_id` int(11) NOT NULL,
  `filter_2_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `filter_2_category` int(11) DEFAULT NULL,
  `filter_2_filter` int(11) DEFAULT NULL,
  `filter_2_filter_1` int(11) DEFAULT NULL,
  `filter_2_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `filter_2_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `filter_2_author` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;

-- --------------------------------------------------------

--
-- Structure de la table `filters_3`
--

CREATE TABLE `filters_3` (
  `filter_3_id` int(11) NOT NULL,
  `filter_3_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `filter_3_category` int(11) DEFAULT NULL,
  `filter_3_filter` int(11) DEFAULT NULL,
  `filter_3_filter_1` int(11) DEFAULT NULL,
  `filter_3_filter_2` int(11) DEFAULT NULL,
  `filter_3_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `filter_3_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `filter_3_author` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;

-- --------------------------------------------------------

--
-- Structure de la table `menus`
--

CREATE TABLE `menus` (
  `menu_id` int(11) NOT NULL,
  `menu_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `menu_header` tinyint(1) DEFAULT '0',
  `menu_footer` tinyint(1) DEFAULT '0',
  `menu_sidebar` tinyint(1) DEFAULT '0',
  `menu_status` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;

-- --------------------------------------------------------

--
-- Structure de la table `navigations`
--

CREATE TABLE `navigations` (
  `navigation_id` int(11) NOT NULL,
  `navigation_order` int(11) NOT NULL,
  `navigation_url` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `navigation_label` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `navigation_target` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `navigation_type` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `navigation_page` int(11) DEFAULT NULL,
  `navigation_menu` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;

-- --------------------------------------------------------

--
-- Structure de la table `pages`
--

CREATE TABLE `pages` (
  `page_id` int(11) NOT NULL,
  `page_title` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `page_content` text COLLATE utf8_unicode_ci NOT NULL,
  `page_status` tinyint(1) NOT NULL DEFAULT '1',
  `page_private` tinyint(1) NOT NULL DEFAULT '0',
  `page_footer` tinyint(1) NOT NULL DEFAULT '1',
  `page_ad_header` tinyint(1) NOT NULL DEFAULT '0',
  `page_ad_footer` tinyint(1) NOT NULL DEFAULT '0',
  `page_ad_sidebar` tinyint(1) NOT NULL DEFAULT '0',
  `page_template` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'blank',
  `page_slug` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `page_seotitle` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `page_seodescription` text COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;

-- --------------------------------------------------------

--
-- Structure de la table `products`
--

CREATE TABLE `products` (
  `product_id` int(11) NOT NULL,
  `product_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `product_category` int(11) DEFAULT NULL,
  `product_author` int(11) NOT NULL,
  `product_ingredients` text COLLATE utf8_unicode_ci NOT NULL,
  `product_slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `product_status` tinyint(1) NOT NULL DEFAULT '1',
  `product_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `product_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `recipes`
--

CREATE TABLE `recipes` (
  `recipe_id` int(11) NOT NULL,
  `recipe_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `recipe_seotitle` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `recipe_informations` text COLLATE utf8_unicode_ci NOT NULL,
  `recipe_category` int(11) DEFAULT NULL,
  `recipe_time` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `recipe_servings` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `recipe_contenant` int(11) NOT NULL,
  `recipe_servings_1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `recipe_contenant_1` int(11) DEFAULT NULL,
  `recipe_servings_2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `recipe_contenant_2` int(11) DEFAULT NULL,
  `recipe_servings_3` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `recipe_contenant_3` int(11) DEFAULT NULL,
  `recipe_difficult` int(11) DEFAULT NULL,
  `recipe_author` int(11) NOT NULL,
  `recipe_ingredients` text COLLATE utf8_unicode_ci NOT NULL,
  `recipe_instructions` text COLLATE utf8_unicode_ci NOT NULL,
  `recipe_image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `recipe_video` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `recipe_carbs` varchar(55) COLLATE utf8_unicode_ci DEFAULT NULL,
  `recipe_protein` varchar(55) COLLATE utf8_unicode_ci DEFAULT NULL,
  `recipe_fat` varchar(55) COLLATE utf8_unicode_ci DEFAULT NULL,
  `recipe_kcal` varchar(55) COLLATE utf8_unicode_ci DEFAULT NULL,
  `recipe_featured` tinyint(1) NOT NULL DEFAULT '0',
  `recipe_facts` tinyint(1) NOT NULL DEFAULT '1',
  `recipe_status` tinyint(1) NOT NULL DEFAULT '1',
  `recipe_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `recipe_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `recipe_filter` int(11) DEFAULT NULL,
  `recipe_filter_1` int(11) DEFAULT NULL,
  `recipe_filter_2` int(11) DEFAULT NULL,
  `recipe_filter_3` int(11) DEFAULT NULL,
  `recipe_cepages` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `replies`
--

CREATE TABLE `replies` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `comment_id` int(11) NOT NULL,
  `body` text COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;

-- --------------------------------------------------------

--
-- Structure de la table `roles`
--

CREATE TABLE `roles` (
  `role_id` int(11) NOT NULL,
  `role_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;

-- --------------------------------------------------------

--
-- Structure de la table `settings`
--

CREATE TABLE `settings` (
  `id` int(11) NOT NULL,
  `st_dateformat` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'd/m/Y',
  `st_facebook` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `st_twitter` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `st_youtube` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `st_instagram` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `st_linkedin` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `st_whatsapp` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `st_defaultsearchpage` int(11) NOT NULL,
  `st_defaultprivacypage` int(11) NOT NULL,
  `st_defaultmemberspage` int(11) NOT NULL,
  `st_defaulttermspage` int(11) NOT NULL,
  `st_maintenance` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `st_analytics` text COLLATE utf8_unicode_ci NOT NULL,
  `st_recipientemail` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `st_smtphost` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `st_smtpemail` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `st_smtppassword` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `st_smtpencrypt` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `st_smtpport` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `st_recaptchakey` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `st_recaptchasecretkey` varchar(150) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;

-- --------------------------------------------------------

--
-- Structure de la table `subscribers`
--

CREATE TABLE `subscribers` (
  `subscriber_id` int(11) NOT NULL,
  `subscriber_email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `subscriber_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;

-- --------------------------------------------------------

--
-- Structure de la table `theme`
--

CREATE TABLE `theme` (
  `id` int(11) NOT NULL,
  `th_headerstyle` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `th_homestyle` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `th_logo` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `th_whitelogo` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `th_favicon` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `th_homebg` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `th_testimonial` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `th_primarycolor` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '#f26522',
  `th_secondarycolor` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '#0d215a'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;

-- --------------------------------------------------------

--
-- Structure de la table `tokens`
--

CREATE TABLE `tokens` (
  `token_email` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `token_key` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `token_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;

-- --------------------------------------------------------

--
-- Structure de la table `translations`
--

CREATE TABLE `translations` (
  `tr_maintenancepage` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tr_maintenancetitle` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tr_maintenancesub` text COLLATE utf8_unicode_ci NOT NULL,
  `tr_profilepage` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `tr_signinpage` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `tr_signuppage` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `tr_resetpage` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `tr_forgotpage` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `tr_termsandconds` text COLLATE utf8_unicode_ci NOT NULL,
  `tr_aboutus` text COLLATE utf8_unicode_ci NOT NULL,
  `tr_eptitle` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tr_epsubtitle` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tr_eptagline` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `tr_epbutton` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `tr_1` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tr_2` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tr_3` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tr_4` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tr_5` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tr_6` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tr_7` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tr_8` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tr_9` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tr_10` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tr_11` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tr_12` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tr_13` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tr_14` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tr_15` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tr_16` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tr_17` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tr_18` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tr_19` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tr_20` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tr_21` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tr_22` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tr_23` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tr_24` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tr_25` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tr_26` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tr_27` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tr_28` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tr_29` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tr_30` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tr_31` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `tr_32` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `tr_33` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tr_34` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tr_35` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tr_36` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tr_37` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tr_38` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tr_39` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tr_40` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_41` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_42` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_43` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_44` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_45` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_46` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_47` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_48` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_49` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_50` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_51` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_52` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_79` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_80` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_81` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_82` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_83` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_84` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_85` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_86` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_87` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_88` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_89` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_90` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_91` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_92` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_93` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_94` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_95` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_96` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_97` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_98` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_99` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_100` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_101` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_102` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_103` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_104` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_105` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_106` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_107` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_108` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_109` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_110` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_111` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_112` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_113` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_114` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_115` text COLLATE utf8_unicode_ci NOT NULL,
  `tr_116` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_117` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_118` text COLLATE utf8_unicode_ci NOT NULL,
  `tr_119` text COLLATE utf8_unicode_ci NOT NULL,
  `tr_120` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_121` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_122` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_123` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_124` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_125` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_126` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_127` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_128` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_129` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_130` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_131` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_132` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_133` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_134` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_135` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_136` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_137` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_138` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_139` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_140` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_141` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_142` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_143` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_144` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_145` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_146` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_147` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_148` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_149` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_150` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_151` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_152` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_153` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_154` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_155` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_156` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_157` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_158` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_159` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_160` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_161` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_162` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_163` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_164` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_165` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_166` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_167` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_168` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_169` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_170` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_171` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_172` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_173` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_174` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_175` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_176` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_177` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_178` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_179` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_180` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_181` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_182` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_183` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_184` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_185` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_186` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_187` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_188` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_189` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_190` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_191` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_192` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_193` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_194` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_195` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_196` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_197` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_198` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_199` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-',
  `tr_200` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Structure de la table `users`
--

CREATE TABLE `users` (
  `user_id` int(11) NOT NULL,
  `user_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `user_email` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `user_password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `user_description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `user_avatar` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'avatar.png',
  `user_status` tinyint(1) NOT NULL DEFAULT '1',
  `user_verified` tinyint(1) NOT NULL DEFAULT '0',
  `user_role` int(11) NOT NULL DEFAULT '3',
  `user_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `user_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;

--
-- Index pour les tables exportées
--

--
-- Index pour la table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`category_id`);

--
-- Index pour la table `cepages`
--
ALTER TABLE `cepages`
  ADD PRIMARY KEY (`cepage_id`);

--
-- Index pour la table `contenant`
--
ALTER TABLE `contenant`
  ADD PRIMARY KEY (`contenant_id`);

--
-- Index pour la table `difficulties`
--
ALTER TABLE `difficulties`
  ADD PRIMARY KEY (`difficult_id`);

--
-- Index pour la table `filters`
--
ALTER TABLE `filters`
  ADD PRIMARY KEY (`filter_id`);

--
-- Index pour la table `filters_1`
--
ALTER TABLE `filters_1`
  ADD PRIMARY KEY (`filter_1_id`);

--
-- Index pour la table `filters_2`
--
ALTER TABLE `filters_2`
  ADD PRIMARY KEY (`filter_2_id`);

--
-- Index pour la table `filters_3`
--
ALTER TABLE `filters_3`
  ADD PRIMARY KEY (`filter_3_id`);

--
-- Index pour la table `menus`
--
ALTER TABLE `menus`
  ADD PRIMARY KEY (`menu_id`);

--
-- Index pour la table `navigations`
--
ALTER TABLE `navigations`
  ADD PRIMARY KEY (`navigation_id`);

--
-- Index pour la table `pages`
--
ALTER TABLE `pages`
  ADD PRIMARY KEY (`page_id`),
  ADD UNIQUE KEY `page_slug` (`page_slug`);

--
-- Index pour la table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`product_id`),
  ADD UNIQUE KEY `product_slug` (`product_slug`);

--
-- Index pour la table `recipes`
--
ALTER TABLE `recipes`
  ADD PRIMARY KEY (`recipe_id`);

--
-- Index pour la table `replies`
--
ALTER TABLE `replies`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`role_id`);

--
-- Index pour la table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `subscribers`
--
ALTER TABLE `subscribers`
  ADD PRIMARY KEY (`subscriber_id`),
  ADD UNIQUE KEY `subscriber_email` (`subscriber_email`);

--
-- Index pour la table `theme`
--
ALTER TABLE `theme`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`user_id`),
  ADD UNIQUE KEY `user_email` (`user_email`);

--
-- AUTO_INCREMENT pour les tables exportées
--

--
-- AUTO_INCREMENT pour la table `categories`
--
ALTER TABLE `categories`
  MODIFY `category_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;
--
-- AUTO_INCREMENT pour la table `cepages`
--
ALTER TABLE `cepages`
  MODIFY `cepage_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
--
-- AUTO_INCREMENT pour la table `contenant`
--
ALTER TABLE `contenant`
  MODIFY `contenant_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT pour la table `difficulties`
--
ALTER TABLE `difficulties`
  MODIFY `difficult_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT pour la table `filters`
--
ALTER TABLE `filters`
  MODIFY `filter_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=57;
--
-- AUTO_INCREMENT pour la table `filters_1`
--
ALTER TABLE `filters_1`
  MODIFY `filter_1_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=48;
--
-- AUTO_INCREMENT pour la table `filters_2`
--
ALTER TABLE `filters_2`
  MODIFY `filter_2_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;
--
-- AUTO_INCREMENT pour la table `filters_3`
--
ALTER TABLE `filters_3`
  MODIFY `filter_3_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
--
-- AUTO_INCREMENT pour la table `menus`
--
ALTER TABLE `menus`
  MODIFY `menu_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT pour la table `navigations`
--
ALTER TABLE `navigations`
  MODIFY `navigation_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
--
-- AUTO_INCREMENT pour la table `pages`
--
ALTER TABLE `pages`
  MODIFY `page_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT pour la table `products`
--
ALTER TABLE `products`
  MODIFY `product_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT pour la table `recipes`
--
ALTER TABLE `recipes`
  MODIFY `recipe_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=192;
--
-- AUTO_INCREMENT pour la table `replies`
--
ALTER TABLE `replies`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT pour la table `roles`
--
ALTER TABLE `roles`
  MODIFY `role_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT pour la table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT pour la table `subscribers`
--
ALTER TABLE `subscribers`
  MODIFY `subscriber_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT pour la table `theme`
--
ALTER TABLE `theme`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT pour la table `users`
--
ALTER TABLE `users`
  MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
/*!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 */;
