ldc-legaulois/database/schema/mysql-schema.sql

/*M!999999\- enable the sandbox mode */ 
/*!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' */;
/*M!100616 SET @OLD_NOTE_VERBOSITY=@@NOTE_VERBOSITY, NOTE_VERBOSITY=0 */;
DROP TABLE IF EXISTS `activity_logs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `activity_logs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned DEFAULT NULL COMMENT 'Id of the user associated, or nullable for a deleted user.',
  `is_anonymous` tinyint(1) NOT NULL COMMENT 'If there is no user connected when action was realised.',
  `is_console` tinyint(1) NOT NULL COMMENT 'If the action was realised in console.',
  `model_class` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Target model.',
  `model_id` int NOT NULL COMMENT 'Id of the target model.',
  `event` int NOT NULL COMMENT 'Event of this activity (ActivityLogsEventEnum).',
  `data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT 'List of changes (old and new values).',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'The date on which the user was published.',
  PRIMARY KEY (`id`),
  KEY `activity_logs_user_id_foreign` (`user_id`),
  CONSTRAINT `activity_logs_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `activity_logs_chk_1` CHECK (json_valid(`data`))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `approaches`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `approaches` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `type` tinyint unsigned NOT NULL COMMENT 'Approach type (label or demarche).',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Approach name.',
  `picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Approach picture.',
  `picture_alt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Picture alt attribute.',
  `picture_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Picture title attribute.',
  `button_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Approach button url (only for demarche).',
  `published` tinyint(1) NOT NULL COMMENT 'Approach publication status.',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `block_lists`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `block_lists` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` bigint unsigned DEFAULT NULL,
  `blocked_id` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `block_lists_customer_id_foreign` (`customer_id`),
  KEY `block_lists_blocked_id_foreign` (`blocked_id`),
  CONSTRAINT `block_lists_blocked_id_foreign` FOREIGN KEY (`blocked_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE,
  CONSTRAINT `block_lists_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `brand_advantages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `brand_advantages` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Brand advantage title',
  `sustitle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Brand advantage sustitle',
  `picto` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Brand advantage pictogram',
  `picto_alt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Pictogram alt attribute',
  `picto_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Pictogram title attribute',
  `text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Brand advantage text',
  `is_large` tinyint(1) NOT NULL COMMENT 'Brand advantage block width',
  `order` int NOT NULL COMMENT 'Brand advantage order',
  `published` tinyint(1) NOT NULL COMMENT 'Brand advantage publish status',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `breeders`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `breeders` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `breeder_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `inuav_codes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `first_name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `picture_alt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Picture alt attribute.',
  `picture_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Picture title attribute.',
  `postal_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `department` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Breeder department - enum',
  `place` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `testimony` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `latitude` double NOT NULL,
  `longitude` double NOT NULL,
  `geo_type` smallint unsigned NOT NULL,
  `ocbStatus` smallint unsigned NOT NULL,
  `ocbType` smallint unsigned NOT NULL,
  `audit` tinyint(1) NOT NULL,
  `valid_marketing_date` date DEFAULT NULL,
  `presentation_type` int NOT NULL DEFAULT '0',
  `video_link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `picture1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `picture2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `picture3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `approaches` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Array of associated approches',
  `order` int unsigned NOT NULL COMMENT 'Breeder order',
  `published` tinyint(1) NOT NULL DEFAULT '0',
  `is_highlighted` tinyint(1) NOT NULL COMMENT 'Is the breeder highlighted ? (visible in carousel)',
  `display_random` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `breeders_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `category_approaches`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `category_approaches` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `claims`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `claims` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Claim label.',
  `published` tinyint(1) NOT NULL COMMENT 'Claim publish status.',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `consumption_moments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `consumption_moments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The title of the consumption moment.',
  `subtitle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Consumption moment subtitle of the page.',
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Consumption moment title slug.',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Consumption moment description of the page.',
  `picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Consumption moment picture.',
  `picture_alt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Picture alt attribute.',
  `picture_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Picture title attribute.',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `customer_password_resets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `customer_password_resets` (
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `csutomer_password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `customerables`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `customerables` (
  `customer_id` bigint unsigned NOT NULL COMMENT 'The customer to associate.',
  `customerable_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `customerable_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  KEY `customerables_customer_id_foreign` (`customer_id`),
  KEY `customerables_customerable_type_customerable_id_index` (`customerable_type`,`customerable_id`),
  CONSTRAINT `customerables_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `customers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `customers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Customer unique email.',
  `hashcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Customer unique username.',
  `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `last_connection` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `customers_email_unique` (`email`),
  UNIQUE KEY `customers_username_unique` (`username`),
  UNIQUE KEY `customers_hashcode_unique` (`hashcode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `delivery_addresses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `delivery_addresses` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `firstname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Delivery address author firstname.',
  `lastname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Delivery address author lastname.',
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Delivery address address.',
  `postcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Delivery address postcode.',
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Delivery address author phone.',
  `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Delivery address city.',
  `civility` tinyint NOT NULL COMMENT 'Delivery address author civility.',
  `order_id` bigint unsigned NOT NULL COMMENT 'Order associated to the delivery address.',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `delivery_addresses_order_id_foreign` (`order_id`),
  CONSTRAINT `delivery_addresses_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `demarche_slides`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `demarche_slides` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Slide title.',
  `picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Slide picture.',
  `picture_alt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Slide picture alt attribute.',
  `picture_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Slide picture title attribute.',
  `button_1_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Slide button n°1 text.',
  `button_1_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Slide button n°1 url.',
  `button_2_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Slide button n°2 text.',
  `button_2_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Slide button n°2 url.',
  `text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Slide text content.',
  `order` int NOT NULL COMMENT 'Slide order.',
  `button_1_status` tinyint(1) NOT NULL COMMENT 'Slide button n°1 publish status.',
  `button_1_target` tinyint(1) NOT NULL COMMENT 'Slide button n°1 target.',
  `button_2_status` tinyint(1) NOT NULL COMMENT 'Slide button n°2 publish status.',
  `button_2_target` tinyint(1) NOT NULL COMMENT 'Slide button n°2 target.',
  `published` tinyint(1) NOT NULL COMMENT 'Slide publish status.',
  `published_at` timestamp NULL DEFAULT NULL COMMENT 'Slide publishment date.',
  `unpublished_at` timestamp NULL DEFAULT NULL COMMENT 'Slide unpublishment date.',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `departaimants`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `departaimants` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `type` smallint unsigned NOT NULL,
  `col1` bigint unsigned NOT NULL DEFAULT '0',
  `col2` bigint unsigned NOT NULL DEFAULT '0',
  `col3` bigint unsigned NOT NULL DEFAULT '0',
  `col4` bigint unsigned NOT NULL DEFAULT '0',
  `customer_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `departaimants_type_customer_id_unique` (`type`,`customer_id`),
  KEY `departaimants_customer_id_foreign` (`customer_id`),
  CONSTRAINT `departaimants_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `discounts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `discounts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Discount name.',
  `desktop_image_available` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Discount desktop image available.',
  `desktop_image_unavailable` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Discount desktop image unavailable.',
  `mobile_image_available` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Discount mobile image available.',
  `mobile_image_unavailable` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Discount mobile image unavailable.',
  `code` bigint NOT NULL COMMENT 'Discount code.',
  `value` double NOT NULL COMMENT 'Discount value.',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `discounts_code_unique` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `failed_jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `general_settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `general_settings` (
  `type` tinyint unsigned NOT NULL COMMENT 'General settings enum type (SettingsType).',
  `value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'General settings value (json).',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  UNIQUE KEY `general_settings_type_unique` (`type`),
  CONSTRAINT `general_settings_chk_1` CHECK (json_valid(`value`))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `golden_crush_games`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `golden_crush_games` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` bigint unsigned NOT NULL,
  `choice` tinyint unsigned NOT NULL,
  `ip_address` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `golden_crush_games_customer_id_unique` (`customer_id`),
  CONSTRAINT `golden_crush_games_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `historical_milestones`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `historical_milestones` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `year` year NOT NULL COMMENT 'Historical milestone year.',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Historical milestone title.',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Historical milestone description.',
  `picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Historical milestone picture.',
  `picture_alt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Picture alt attribute.',
  `picture_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Picture title attribute.',
  `video_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Historical milestone video ID.',
  `picto` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Historical milestone picto.',
  `picto_alt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Picture alt attribute.',
  `picto_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Picture title attribute.',
  `picto_position` tinyint DEFAULT NULL COMMENT 'Historical milestone picto position.',
  `published` tinyint(1) NOT NULL COMMENT 'Historical milestone publish status.',
  `order` int NOT NULL COMMENT 'Historical milestone order.',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `inco_nutritional_values`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `inco_nutritional_values` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'Inco id.',
  `product_id` bigint unsigned DEFAULT NULL COMMENT 'Inco product id.',
  `energy` double DEFAULT NULL COMMENT 'Inco energy value.',
  `energy_kj` double DEFAULT NULL COMMENT 'Inco energy (kj) value.',
  `protein` double DEFAULT NULL COMMENT 'Inco protein value.',
  `carbohydrates` double DEFAULT NULL COMMENT 'Inco carbohydrates value.',
  `sugar` double DEFAULT NULL COMMENT 'Inco sugar value.',
  `fat` double DEFAULT NULL COMMENT 'Inco fat value.',
  `saturated_fatty_acids` double DEFAULT NULL COMMENT 'Inco saturated fatty acids value.',
  `dietary_fiber` double DEFAULT NULL COMMENT 'Inco dietary fiber value.',
  `salt` double DEFAULT NULL COMMENT 'Inco salt value.',
  `salt_percent` double(8,2) DEFAULT NULL COMMENT 'Inco salt percent.',
  `energy_percent` double(8,2) DEFAULT NULL COMMENT 'Inco energy percent value.',
  `energy_kj_percent` double(8,2) DEFAULT NULL COMMENT 'Inco energy (kj) percent value.',
  `protein_percent` double(8,2) DEFAULT NULL COMMENT 'Inco protein percent value.',
  `carbohydrates_percent` double(8,2) DEFAULT NULL COMMENT 'Inco carbohydrates percent value.',
  `sugar_percent` double(8,2) DEFAULT NULL COMMENT 'Inco salt percent value.',
  `fat_percent` double(8,2) DEFAULT NULL COMMENT 'Inco fat percent value.',
  `saturated_fatty_acids_percent` double(8,2) DEFAULT NULL COMMENT 'Inco saturated fatty acids percent value.',
  `dietary_fiber_percent` double(8,2) DEFAULT NULL COMMENT 'Inco dietary fiber percent value.',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `inco_nutritional_values_product_id_foreign` (`product_id`),
  CONSTRAINT `inco_nutritional_values_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint unsigned NOT NULL,
  `reserved_at` int unsigned DEFAULT NULL,
  `available_at` int unsigned NOT NULL,
  `created_at` int unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `key_numbers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `key_numbers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `picto` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Picto path.',
  `picto_alt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Picto alt attribute.',
  `picto_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Picto title attribute.',
  `text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Picto legend.',
  `source` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order` int NOT NULL COMMENT 'Display order bo.',
  `published` tinyint(1) NOT NULL COMMENT 'Picto publish status.',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `main_slides`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `main_slides` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Slide title.',
  `subtitle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Slide subtitle.',
  `background` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Slide background.',
  `background_alt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Background alt attribute.',
  `background_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Background title attribute.',
  `picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Slide picture.',
  `picture_alt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Picture alt attribute.',
  `picture_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Picture title attribute.',
  `button_1_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Slide button n°1 text.',
  `button_1_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Slide button n°1 url.',
  `button_2_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Text of the button n°2 in the slide.',
  `button_2_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Url of the button n°2 in the slide.',
  `approach_id` bigint unsigned DEFAULT NULL,
  `color_block` bigint unsigned NOT NULL COMMENT 'Slide block background color.',
  `button_1_color_text` bigint unsigned NOT NULL COMMENT 'Slide button n°1 text color.',
  `button_1_color_background` bigint unsigned NOT NULL COMMENT 'Slide button n°1 background color.',
  `button_2_color_text` bigint unsigned NOT NULL COMMENT 'Slide button n°2 text color.',
  `button_2_color_background` bigint unsigned NOT NULL COMMENT 'Slide button n°2 background color.',
  `order` int NOT NULL COMMENT 'Slide order.',
  `button_1_status` tinyint(1) NOT NULL COMMENT 'Slide button n°1 publish status.',
  `button_1_target` tinyint(1) NOT NULL COMMENT 'Slide button n°1 target.',
  `button_2_status` tinyint(1) NOT NULL COMMENT 'Slide button n°2 publish status.',
  `button_2_target` tinyint(1) NOT NULL COMMENT 'Open the url of the button n°2 in a new tab.',
  `new` tinyint(1) NOT NULL COMMENT 'Slide picto new.',
  `published` tinyint(1) NOT NULL COMMENT 'Slide publish status.',
  `published_at` timestamp NULL DEFAULT NULL COMMENT 'Slide publishment date.',
  `unpublished_at` timestamp NULL DEFAULT NULL COMMENT 'Slide unpublishment date.',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `main_slides_approach_id_foreign` (`approach_id`),
  CONSTRAINT `main_slides_approach_id_foreign` FOREIGN KEY (`approach_id`) REFERENCES `approaches` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `meats`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `meats` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Meat label.',
  `subtitle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Meat subtitle of the page.',
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Meat slug.',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Meat description.',
  `banner` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Meat banner',
  `banner_alt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Banner alt attribute',
  `banner_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Banner title attribute',
  `picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Meat picture.',
  `picture_alt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Picture alt attribute.',
  `picture_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Picture title attribute.',
  `color` bigint unsigned NOT NULL COMMENT 'Meat associated color.',
  `order` int NOT NULL COMMENT 'Meat order',
  `published` tinyint(1) NOT NULL COMMENT 'Meat publish status',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `menu_node_data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `menu_node_data` (
  `type` smallint unsigned NOT NULL COMMENT 'Enum MenuNodeType, this is unique since we do not use this for links.',
  `sub_label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(Left part) Link label',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(Right part) Sub title',
  `text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(Right part) Sub text',
  `text_color` bigint unsigned NOT NULL COMMENT '(Right part) Sub text color',
  `link_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(Right part) Link url',
  `link_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(Right part) Link title',
  `link_target` tinyint(1) NOT NULL COMMENT '(Right part) Link target',
  `link_status` tinyint(1) NOT NULL COMMENT '(Right part) Link status',
  `picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(Right part) Picture',
  `picture_alt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(Right part) Picture alt text',
  `picture_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(Right part) Picture title text',
  `picture_status` tinyint(1) NOT NULL COMMENT '(Right part) Picture status',
  `background_picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(Right part) Menu picture',
  `background_picture_alt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(Right part) Menu picture alt text',
  `background_picture_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(Right part) Menu picture title text',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `messages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `messages` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `hide_from` tinyint(1) NOT NULL DEFAULT '0',
  `hide_to` tinyint(1) NOT NULL DEFAULT '0',
  `from` bigint unsigned DEFAULT NULL,
  `to` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `messages_from_foreign` (`from`),
  KEY `messages_to_foreign` (`to`),
  CONSTRAINT `messages_from_foreign` FOREIGN KEY (`from`) REFERENCES `customers` (`id`) ON DELETE CASCADE,
  CONSTRAINT `messages_to_foreign` FOREIGN KEY (`to`) REFERENCES `customers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `news`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `news` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `seo_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The seo title of the news.',
  `seo_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The seo description of the news.',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The title of the news.',
  `subtitle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'The title of the news.',
  `picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Picture path.',
  `picture_alt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Picture alt attribute.',
  `picture_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Picture title attribute.',
  `thumbnail` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Thumbnail path.',
  `thumbnail_alt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Thumbnail alt attribute.',
  `thumbnail_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Thumbnail title attribute.',
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Unique title slug',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The content of the news.',
  `news_category_id` bigint unsigned NOT NULL,
  `highlight` tinyint(1) NOT NULL COMMENT 'Highlight status.',
  `published` tinyint(1) NOT NULL COMMENT 'News publish status.',
  `publish_at` timestamp NULL DEFAULT NULL COMMENT 'News publishment date.',
  `unpublish_at` timestamp NULL DEFAULT NULL COMMENT 'News unpublishment date.',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `news_slug_unique` (`slug`),
  KEY `news_news_category_id_foreign` (`news_category_id`),
  CONSTRAINT `news_news_category_id_foreign` FOREIGN KEY (`news_category_id`) REFERENCES `news_categories` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `news_breedings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `news_breedings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `seo_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The seo title of the news breeding.',
  `seo_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The seo description of the news breeding.',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The title of the news breeding.',
  `subtitle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'The title of the news breeding.',
  `picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Picture path.',
  `picture_alt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Picture alt attribute.',
  `picture_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Picture title attribute.',
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Unique title slug',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The content of the news breeding.',
  `static_page_id` bigint unsigned NOT NULL DEFAULT '16' COMMENT 'News breeding associated static page.',
  `order` int NOT NULL COMMENT 'News breeding order',
  `published` tinyint(1) NOT NULL COMMENT 'News breeding publish status.',
  `publish_at` timestamp NULL DEFAULT NULL COMMENT 'News breeding publishment date.',
  `unpublish_at` timestamp NULL DEFAULT NULL COMMENT 'News breeding unpublishment date.',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `news_breedings_static_page_id_foreign` (`static_page_id`),
  CONSTRAINT `news_breedings_static_page_id_foreign` FOREIGN KEY (`static_page_id`) REFERENCES `static_pages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `news_categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `news_categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `seo_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The seo title of the news category.',
  `seo_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The seo description of the news category.',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'News category title.',
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'News category title slug.',
  `color` bigint unsigned NOT NULL COMMENT 'News associated color.',
  `order` int NOT NULL COMMENT 'News category order.',
  `published` tinyint(1) NOT NULL COMMENT 'News category publish status.',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `news_categories_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `news_clubs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `news_clubs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'News club title.',
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'News club title slug.',
  `picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'News club picture path.',
  `picture_alt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Picture alt attribute.',
  `picture_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Picture title attribute.',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'News club content.',
  `type` int NOT NULL COMMENT 'News club type.',
  `multiple_answers` tinyint(1) NOT NULL COMMENT 'News club multiple answers.',
  `published` tinyint(1) NOT NULL COMMENT 'News club publish status.',
  `publish_at` timestamp NULL DEFAULT NULL COMMENT 'News club publishment date.',
  `unpublish_at` timestamp NULL DEFAULT NULL COMMENT 'News club unpublishment date.',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `news_clubs_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `news_corporates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `news_corporates` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The title of the news.',
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The content of the news.',
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Linkedin url link.',
  `picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Picture path.',
  `picture_alt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Picture alt attribute.',
  `picture_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Picture title attribute.',
  `published` tinyint(1) NOT NULL COMMENT 'News publish status.',
  `publish_at` timestamp NULL DEFAULT NULL COMMENT 'Slide publishment date.',
  `unpublish_at` timestamp NULL DEFAULT NULL COMMENT 'Slide unpublishment date.',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `notifications`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `notifications` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `type` tinyint NOT NULL,
  `notifiable_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `notifiable_id` bigint unsigned NOT NULL,
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `customer_id` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`),
  KEY `notifications_customer_id_foreign` (`customer_id`),
  CONSTRAINT `notifications_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `notifications_read`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `notifications_read` (
  `notification_id` bigint unsigned NOT NULL,
  `customer_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`notification_id`,`customer_id`),
  KEY `notifications_read_customer_id_foreign` (`customer_id`),
  CONSTRAINT `notifications_read_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`),
  CONSTRAINT `notifications_read_notification_id_foreign` FOREIGN KEY (`notification_id`) REFERENCES `notifications` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ocb_breeders`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `ocb_breeders` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'OCB breeder id.',
  `first_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'OCB breeder first name.',
  `last_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'OCB breeder last name.',
  `department` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'OCB breeder department.',
  `postal_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'OCB breeder postal code.',
  `type` tinyint NOT NULL COMMENT 'OCB breeder type.',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'OCB breeder created at date.',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'OCB breeder updated at date.',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `offers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `offers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Offer title.',
  `location_street` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Offer location street.',
  `location_zip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Offer location zip.',
  `location_city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Offer location city.',
  `location_state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Offer location state.',
  `location_country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Offer location country.',
  `location_details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Offer location details.',
  `location_latitude` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Offer location latitude.',
  `location_longitude` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Offer location longitude.',
  `contract` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Offer contract.',
  `contract_period` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Offer contract period.',
  `function` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Offer function.',
  `experience_level` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Offer experience level.',
  `qualifications` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Offer qualifications.',
  `skills` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Offer skills.',
  `picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Offer picture.',
  `picture_alt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Picture alt attribute.',
  `picture_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Picture title attribute.',
  `link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Offer link.',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Offer description.',
  `recruiter_firstname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Offer recruiter firstname.',
  `recruiter_lastname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Offer recruiter lastname.',
  `recruiter_job` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Offer recruiter job.',
  `recruiter_picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Offer recruiter picture.',
  `published` tinyint(1) NOT NULL COMMENT 'Offer publish status.',
  `published_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Slide publishment date.',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `optin_consents`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `optin_consents` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `hashcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `optin_consents_email_unique` (`email`),
  UNIQUE KEY `optin_consents_hashcode_unique` (`hashcode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `order_sell_item`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `order_sell_item` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `quantity` smallint NOT NULL COMMENT 'Order sell items quantity.',
  `order_id` bigint unsigned NOT NULL COMMENT 'Order associated to the sell item.',
  `sell_item_id` bigint unsigned NOT NULL COMMENT 'Sell item associated to the order.',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `order_sell_item_order_id_foreign` (`order_id`),
  KEY `order_sell_item_sell_item_id_foreign` (`sell_item_id`),
  CONSTRAINT `order_sell_item_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `order_sell_item_sell_item_id_foreign` FOREIGN KEY (`sell_item_id`) REFERENCES `sell_items` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `orders`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `orders` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `ref` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Order reference.',
  `firstname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Order firstname author.',
  `lastname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Order lastname author.',
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Order address author.',
  `postcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Order postcode author.',
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Order phone author.',
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Order email author.',
  `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Order city author.',
  `civility` tinyint NOT NULL COMMENT 'Order civility author.',
  `status` tinyint NOT NULL COMMENT 'Order status.',
  `payementType` tinyint NOT NULL COMMENT 'Order payement type.',
  `confirmMailSent` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Order sent mail confirm.',
  `customer_id` bigint unsigned NOT NULL COMMENT 'Customer associated to the order.',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `orders_ref_unique` (`ref`),
  KEY `orders_customer_id_foreign` (`customer_id`),
  CONSTRAINT `orders_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `password_resets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `password_resets` (
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `product_types`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `product_types` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Product type description.',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Product type description.',
  `picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Product type picture.',
  `picture_alt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Picture alt attribute.',
  `picture_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Picture title attribute.',
  `button_status` tinyint(1) NOT NULL COMMENT 'Product type button publish status.',
  `published` tinyint(1) NOT NULL COMMENT 'Product type publish status.',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `productables`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `productables` (
  `product_id` bigint unsigned NOT NULL COMMENT 'The product to associate',
  `productable_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `productable_id` bigint unsigned NOT NULL,
  KEY `productables_product_id_foreign` (`product_id`),
  KEY `productables_productable_type_productable_id_index` (`productable_type`,`productable_id`),
  CONSTRAINT `productables_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `products`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `products` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `seo_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Product seo title.',
  `seo_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Product seo description.',
  `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Product label.',
  `claim_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'The claim title for a product.',
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Product slug.',
  `picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `picture_alt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `picture_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `banner` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `banner_alt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `banner_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `packaging` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Product packaging.',
  `packaging_alt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Packaging alt attribute.',
  `packaging_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Packaging title attribute.',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Product description.',
  `details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Product details.',
  `preparation` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Product preparation.',
  `ingredients` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Product ingrédients.',
  `meat_id` bigint unsigned DEFAULT NULL COMMENT 'Product meat.',
  `submeat_id` bigint unsigned DEFAULT NULL COMMENT 'Product submeat.',
  `range_id` bigint unsigned DEFAULT NULL COMMENT 'Product range.',
  `subrange_id` bigint unsigned DEFAULT NULL COMMENT 'Product subrange.',
  `approach_id` bigint unsigned DEFAULT NULL COMMENT 'Product approach (demarche).',
  `new` tinyint(1) DEFAULT NULL COMMENT 'Product new.',
  `discover` tinyint(1) NOT NULL COMMENT 'Product discover.',
  `published` tinyint(1) NOT NULL COMMENT 'Product publish status.',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `products_approach_id_foreign` (`approach_id`),
  KEY `products_meat_id_foreign` (`meat_id`),
  KEY `products_submeat_id_foreign` (`submeat_id`),
  KEY `products_range_id_foreign` (`range_id`),
  KEY `products_subrange_id_foreign` (`subrange_id`),
  CONSTRAINT `products_approach_id_foreign` FOREIGN KEY (`approach_id`) REFERENCES `approaches` (`id`) ON DELETE SET NULL ON UPDATE SET NULL,
  CONSTRAINT `products_meat_id_foreign` FOREIGN KEY (`meat_id`) REFERENCES `meats` (`id`) ON DELETE SET NULL ON UPDATE SET NULL,
  CONSTRAINT `products_range_id_foreign` FOREIGN KEY (`range_id`) REFERENCES `ranges` (`id`) ON DELETE SET NULL ON UPDATE SET NULL,
  CONSTRAINT `products_submeat_id_foreign` FOREIGN KEY (`submeat_id`) REFERENCES `submeats` (`id`) ON DELETE SET NULL ON UPDATE SET NULL,
  CONSTRAINT `products_subrange_id_foreign` FOREIGN KEY (`subrange_id`) REFERENCES `subranges` (`id`) ON DELETE SET NULL ON UPDATE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `professions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `professions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Profession title.',
  `picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Profession picture.',
  `picture_alt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Picture alt attribute.',
  `picture_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Picture title attribute.',
  `jobs_list` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Profession list of jobs.',
  `job_url` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Digital recruiters url.',
  `published` tinyint(1) NOT NULL COMMENT 'Profession publish status.',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ranges`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `ranges` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Range label.',
  `subtitle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Range subtitle of the page.',
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Range slug.',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Range description.',
  `banner` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Range banner',
  `banner_alt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Banner alt attribute',
  `banner_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Banner title attribute',
  `banner_ambiance` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Range ambiance banner',
  `banner_ambiance_alt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Ambiance banner alt attribute',
  `banner_ambiance_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Ambiance banner title attribute',
  `picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Range picture.',
  `picture_alt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Picture alt attribute.',
  `picture_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Picture title attribute.',
  `color` bigint unsigned NOT NULL COMMENT 'Range associated color.',
  `order` int NOT NULL COMMENT 'Range order',
  `published` tinyint(1) NOT NULL COMMENT 'Range publish status',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ratings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `ratings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` bigint unsigned NOT NULL COMMENT 'Rating associated customer.',
  `rating_id` bigint unsigned NOT NULL COMMENT 'Rating key of the associated model.',
  `rate` tinyint unsigned NOT NULL COMMENT 'Rating note (Enum RatingEnum).',
  `rating_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Rating associated model.',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ratings_customer_id_rating_id_rating_type_unique` (`customer_id`,`rating_id`,`rating_type`),
  CONSTRAINT `ratings_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `recipes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `recipes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `seo_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Recipe seo title.',
  `seo_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Recipe seo description.',
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Recipe slug.',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Recipe title.',
  `tips` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Recipe picture.',
  `picture_alt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Picture alt attribute.',
  `picture_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Picture title attribute.',
  `ingredients_list` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'Recipe list of ingredients.',
  `preparation` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Recipe preparation.',
  `advice` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `video_id` bigint unsigned DEFAULT NULL COMMENT 'Recipe video.',
  `consumption_moment_id` bigint unsigned NOT NULL COMMENT 'Recipe consumption moment.',
  `preparation_time` smallint unsigned NOT NULL COMMENT 'Recipe preparation time.',
  `cooking_time` smallint unsigned DEFAULT NULL,
  `nb_guests` smallint unsigned NOT NULL COMMENT 'Number of reference persons for ingredient list of the recipe.',
  `difficulty` tinyint unsigned NOT NULL COMMENT 'Recipe difficulty.',
  `highlight` tinyint(1) NOT NULL COMMENT 'Recipe highlight.',
  `published` tinyint(1) NOT NULL COMMENT 'Recipe publish status.',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `recipes_video_id_foreign` (`video_id`),
  KEY `recipes_consumption_moment_id_foreign` (`consumption_moment_id`),
  CONSTRAINT `recipes_consumption_moment_id_foreign` FOREIGN KEY (`consumption_moment_id`) REFERENCES `consumption_moments` (`id`),
  CONSTRAINT `recipes_video_id_foreign` FOREIGN KEY (`video_id`) REFERENCES `videos` (`id`),
  CONSTRAINT `recipes_chk_1` CHECK (json_valid(`ingredients_list`))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `saml2_tenants`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `saml2_tenants` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `idp_entity_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `idp_login_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `idp_logout_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `idp_x509_cert` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `metadata` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `relay_state_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name_id_format` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'persistent',
  PRIMARY KEY (`id`),
  CONSTRAINT `saml2_tenants_chk_1` CHECK (json_valid(`metadata`))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `section_approaches`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `section_approaches` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'content.',
  `picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'picture path.',
  `picture_alt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Picture alt attribute.',
  `picture_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Picture title attribute.',
  `category_id` bigint unsigned NOT NULL,
  `page_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `section_approaches_category_id_foreign` (`category_id`),
  KEY `section_approaches_page_id_foreign` (`page_id`),
  CONSTRAINT `section_approaches_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `category_approaches` (`id`) ON DELETE CASCADE,
  CONSTRAINT `section_approaches_page_id_foreign` FOREIGN KEY (`page_id`) REFERENCES `static_pages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `sell_items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `sell_items` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'Sell item id.',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Sell item name.',
  `picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Sell item picture path.',
  `picture_alt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Picture alt attribute.',
  `picture_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Picture title attribute.',
  `price` double NOT NULL COMMENT 'Sell item price.',
  `arcadia_weight` smallint NOT NULL DEFAULT '0' COMMENT 'Sell item arcadia weight.',
  `arcadia_id` int NOT NULL COMMENT 'Sell item arcadia id.',
  `order` int NOT NULL COMMENT 'Sell item order',
  `type` tinyint NOT NULL DEFAULT '1' COMMENT 'Sell item type.',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sell_items_arcadia_id_unique` (`arcadia_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `static_pages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `static_pages` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `type` tinyint unsigned NOT NULL COMMENT 'Page type (StaticPageEnum)',
  `seo_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Static page SEO title.',
  `seo_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Static page SEO description.',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Static page title.',
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Unique title slug',
  `subtitle` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Static page subtitle.',
  `picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Static page picture.',
  `picture_alt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Picture alt attribute.',
  `picture_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Picture title attribute.',
  `content` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Static page content.',
  `data` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Static page data.',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `static_pages_type_unique` (`type`),
  UNIQUE KEY `static_pages_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `submeats`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `submeats` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Submeat label.',
  `subtitle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Submeat subtitle of the page.',
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Submeat slug.',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Submeat description.',
  `picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Submeat picture.',
  `picture_alt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Picture alt attribute.',
  `picture_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Picture title attribute.',
  `meat_id` bigint unsigned NOT NULL COMMENT 'Associated meat',
  `order` int NOT NULL COMMENT 'Submeat order',
  `published` tinyint(1) NOT NULL COMMENT 'Submeat publish status',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `submeats_meat_id_foreign` (`meat_id`),
  CONSTRAINT `submeats_meat_id_foreign` FOREIGN KEY (`meat_id`) REFERENCES `meats` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `subranges`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `subranges` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Subrange label.',
  `subtitle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Subrange subtitle of the page.',
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Subrange slug.',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Subrange description.',
  `picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Subrange picture.',
  `picture_alt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Picture alt attribute.',
  `picture_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Picture title attribute.',
  `range_id` bigint unsigned NOT NULL COMMENT 'Associated range',
  `order` int NOT NULL COMMENT 'Subrange order',
  `published` tinyint(1) NOT NULL COMMENT 'Subrange publish status',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `subranges_range_id_foreign` (`range_id`),
  CONSTRAINT `subranges_range_id_foreign` FOREIGN KEY (`range_id`) REFERENCES `ranges` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `surveys_answers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `surveys_answers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `news_club_id` bigint unsigned NOT NULL COMMENT 'Survey answer news club associated.',
  `order` int NOT NULL COMMENT 'Survey answer order.',
  `published` tinyint(1) NOT NULL COMMENT 'Survey answer status.',
  `answer` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Survey answer.',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `surveys_answers_news_club_id_foreign` (`news_club_id`),
  CONSTRAINT `surveys_answers_news_club_id_foreign` FOREIGN KEY (`news_club_id`) REFERENCES `news_clubs` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `telescope_entries`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `telescope_entries` (
  `sequence` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `family_hash` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `should_display_on_index` tinyint(1) NOT NULL DEFAULT '1',
  `type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`sequence`),
  UNIQUE KEY `telescope_entries_uuid_unique` (`uuid`),
  KEY `telescope_entries_batch_id_index` (`batch_id`),
  KEY `telescope_entries_family_hash_index` (`family_hash`),
  KEY `telescope_entries_created_at_index` (`created_at`),
  KEY `telescope_entries_type_should_display_on_index_index` (`type`,`should_display_on_index`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `telescope_entries_tags`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `telescope_entries_tags` (
  `entry_uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tag` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`entry_uuid`,`tag`),
  KEY `telescope_entries_tags_tag_index` (`tag`),
  CONSTRAINT `telescope_entries_tags_entry_uuid_foreign` FOREIGN KEY (`entry_uuid`) REFERENCES `telescope_entries` (`uuid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `telescope_monitoring`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `telescope_monitoring` (
  `tag` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`tag`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `testimonials`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `testimonials` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `catchline` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Testimonial catchline',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Testimonial content',
  `identity` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Identity of the person',
  `job` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Job of the person',
  `picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Path of the picture of the testimonial (550x315)',
  `picture_alt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Alt attribute of the picture',
  `picture_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Title attribute of the picture',
  `video_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Id of the video to display (youtube)',
  `order` int NOT NULL COMMENT 'Testimonial order.',
  `published` tinyint(1) NOT NULL COMMENT 'Testimonial publish status.',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `first_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'First name of the user.',
  `last_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Last name of the user.',
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Email of the user.',
  `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `role` tinyint unsigned NOT NULL COMMENT 'Role of the user who defines the rights/access.',
  `last_connection` date DEFAULT NULL,
  `published` tinyint(1) NOT NULL COMMENT 'The user is acivated or not.',
  `published_at` timestamp NULL DEFAULT NULL COMMENT 'The date on which the user was activated.',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `uwil_redirections`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `uwil_redirections` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `hash` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Hash of the redirection (from old_query).',
  `old_model_slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Old slug of the model.',
  `old_query` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Old URL.',
  `new_query` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'New URL to redirect.',
  `model_redirectable_id` bigint unsigned NOT NULL COMMENT 'Primary key of the model.',
  `model_redirectable_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Class of the model.',
  `redirect_type` tinyint unsigned NOT NULL COMMENT 'Type of the redirection (enum RedirectionType).',
  `redirect_code` smallint unsigned NOT NULL COMMENT 'HTTP Code of the redirection (enum RedirectionCode).',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `uwil_redirections_hash` (`hash`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `videos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `videos` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Video title.',
  `video_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The video ID.',
  `is_on_homepage` tinyint(1) NOT NULL COMMENT 'Is display on homepage ?',
  `product_id` bigint unsigned DEFAULT NULL COMMENT 'Associated product',
  `order` int NOT NULL COMMENT 'Video order.',
  `published` tinyint(1) NOT NULL COMMENT 'Video publish status.',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `videos_product_id_foreign` (`product_id`),
  CONSTRAINT `videos_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!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 */;
/*M!100616 SET NOTE_VERBOSITY=@OLD_NOTE_VERBOSITY */;

/*M!999999\- enable the sandbox mode */ 
SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0;
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1,'2014_10_12_000000_create_users_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (2,'2014_10_12_100000_create_password_resets_table',2);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (3,'2019_08_19_000000_create_failed_jobs_table',3);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (4,'2021_11_19_102529_create_jobs_table',4);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (5,'2023_09_08_102717_create_actitivy_logs_table',5);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (6,'2023_10_19_094711_create_static_pages',6);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (7,'2024_03_27_163722_create_brand_advantages_table',7);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (8,'2024_03_27_165252_create_professions_table',8);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (9,'2024_03_29_092817_create_key_numbers_table',9);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (10,'2024_04_04_115045_create_demarche_slides_table',10);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (13,'2024_04_11_155435_create_ranges_table',13);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (14,'2024_04_11_161238_create_subranges_table',14);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (15,'2024_04_11_162113_create_meats_table',15);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (16,'2024_04_11_162347_create_submeats_table',16);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (17,'2024_04_12_084956_create_approaches_table',17);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (18,'2024_04_12_094030_create_products_table',18);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (19,'2024_04_12_095316_create_productables_table',19);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (20,'2024_04_13_115045_create_main_slides_table',20);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (21,'2030_01_01_000001_mandatory_seeds',21);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (22,'2024_04_08_100253_create_general_settings_table',22);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (23,'2024_04_11_093924_create_menu_node_data_table',23);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (24,'2024_04_25_151849_create_consumption_moments_table',24);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (25,'2024_04_29_164213_create_video_table',25);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (26,'2024_04_29_171346_create_recipes_table',26);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (28,'2030_01_01_000002_development_seeds',27);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (29,'2024_05_22_162212_alter_consumption_moment_table',28);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (30,'2024_05_30_123252_add_picture_to_static_pages_table',29);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (31,'2024_06_06_161707_create_product_types_table',30);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (32,'2024_06_10_122602_create_claims_table',31);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (33,'2024_06_10_141752_alter_products_table',32);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (34,'2024_06_11_112251_add_products_to_general_settings_table',33);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (35,'2024_06_12_103004_create_inco_nutritional_values_table',34);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (38,'2024_06_12_122730_clean_database_for_re7',35);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (39,'2024_06_13_101337_alter_images_products_table',36);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (40,'2024_06_13_104248_add_slug_products_table',37);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (41,'2024_06_13_142049_alter_relations_products_table',38);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (42,'2024_06_13_164818_add_published_product_types_table',39);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (43,'2024_06_20_125638_alter_routes_general_settings_table',40);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (44,'2024_06_26_170458_add_button_link_demarches_table',41);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (45,'2024_06_26_175000_add_subtitle_and_text_to_models_for_index_pages',42);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (46,'2024_07_01_101346_create_customer_password_resets_table',43);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (47,'2024_07_01_101346_create_customers_table',44);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (48,'2024_07_05_150846_add_date_fileds_on_customers',45);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (49,'2024_07_05_150846_add_soft_delete_to_customers',46);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (50,'2024_07_05_150846_rename_table_csutomer_password_resets_to_customer_password_resets',47);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (51,'2024_07_05_155210_add_password_to_customer',48);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (52,'2024_07_10_111948_create_historical_milestones_table',49);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (53,'2024_07_10_153957_add_minicrud_static_pages_table',50);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (54,'2024_07_11_115612_add_seo_fields_to_products_and_recipes_table',51);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (55,'2024_07_12_115553_create_offers_table',52);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (56,'2024_12_02_141232_create_departaimants_table',53);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (57,'2024_12_09_112347_create_messages_table',54);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (58,'2024_12_10_171912_create_block_lists_table',55);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (59,'2024_12_24_160304_create_notifications',56);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (60,'2024_12_24_161902_create_notifications_read',57);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (61,'2024_12_24_171920_add_customer_id_to_notifications_table',58);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (62,'2024_12_24_171921_update_relations_options_products_table',59);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (63,'2024_12_25_104803_add_fields_to_static_page_offers_table',60);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (64,'2024_12_25_175858_add_published_at_offers_table',61);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (65,'2024_12_25_175900_add_count_offers_from_job_general_settings_table',62);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (66,'2024_12_26_114011_add_link_offers_table',63);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (67,'2024_07_25_122152_create_testimonials_table',64);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (68,'2024_07_31_092856_create_news_corporates_table',64);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (69,'2024_08_06_160317_add_selling_to_static_pages',64);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (70,'2024_12_26_154709_alter_recruitments_static_pages_table',64);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (71,'2024_21_26_161928_message_as_encrypted',64);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (72,'2024_21_27_112704_add_titles_descriptions_story_static_pages_table',64);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (73,'2024_21_27_113004_alter_historical_milestones_table',64);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (74,'2024_08_27_160303_make_product_id_nullable_on_videos_table',65);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (75,'2024_08_27_164534_replace_submeat_id_in_products',65);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (76,'2024_08_09_155605_create_news_categories_table',66);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (77,'2024_08_10_153246_create_news_table',67);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (78,'2024_08_22_105618_add_news_and_social_to_static_pages',68);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (79,'2024_08_29_094103_alter_breeders_table',69);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (80,'2024_09_05_155517_add_breeder_map_text_to_general_settings_table',70);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (81,'2024_09_03_155707_create_news_breedings_table',71);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (82,'2024_09_03_171124_add_breeding_to_static_pages',71);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (83,'2024_09_04_095651_create_customer_favorites_table',71);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (84,'2024_21_27_114005_alter_customers_table',71);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (85,'2024_21_27_114006_create_news_clubs_table',71);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (86,'2024_21_27_114007_create_surveys_answers_table',71);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (87,'2024_21_27_123904_create_discounts_table',71);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (88,'2019_06_24_140207_create_saml2_tenants_table',72);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (89,'2020_10_22_140856_add_relay_state_url_column_to_saml2_tenants_table',73);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (90,'2020_10_23_072902_add_name_id_format_column_to_saml2_tenants_table',74);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (91,'2024_09_18_084846_alter_routes_general_settings_table',75);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (92,'2024_09_18_123033_alter_tips_recipes_table',76);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (93,'2024_09_18_124241_alter_advice_recipes_table',77);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (94,'2024_09_18_150649_remove_required_on_banner_in_products_table',78);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (95,'2024_09_19_084122_alter_users_for_saml',79);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (96,'2024_09_19_093926_alter_cookingtime_recipes_table',80);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (97,'2024_09_19_100415_alter_tips_length_recipes_table',81);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (98,'2024_09_19_111335_remove_required_on_picture_in_products_table',82);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (99,'2024_09_20_115443_alter_customers_for_migration',82);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (100,'2024_09_20_150909_alter_product_static_pages_table',82);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (101,'2024_09_20_154248_add_claim_title_to_product_table',82);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (102,'2024_09_23_092214_alter_tips_recipes_table',82);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (103,'2024_21_27_123909_add_order_to_survey_answers_table',82);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (104,'2024_09_19_114210_add_picto_placement_historical_milestone_table',83);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (105,'2024_09_19_125103_add_order_to_historical_milestones_table',83);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (106,'2024_09_19_142211_alter_source_key_numbers_table',83);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (107,'2024_10_04_100723_add_color_to_news_categories_table',84);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (108,'2024_21_27_123905_create_sell_items_table',85);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (109,'2024_21_27_123906_create_orders_table',85);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (110,'2024_21_27_123907_create_order_sell_item_table',85);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (111,'2024_21_27_123908_create_delivery_addresses_table',85);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (112,'2024_21_27_123910_add_type_sell_items_table',85);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (113,'2024_21_27_123911_alter_menu_node_general_settings_table',86);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (114,'2024_21_27_123912_add_elements_in_sellitems_table',87);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (115,'2018_08_08_100000_create_telescope_entries_table',88);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (116,'2024_21_27_123912_alter_tables_for_unit_tests',88);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (117,'2024_21_27_123913_add_OCB_breeders_table',89);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (118,'2024_11_13_120306_create_uwil_redirections_table',90);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (119,'2024_21_27_123913_add_search_type_static_pages_table',91);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (120,'2025_04_03_095319_add_static_page_game_rules',92);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (122,'2025_06_05_100921_add_fields_to_offers_table',93);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (123,'2025_06_18_095049_add_offer_location_address_details_table',94);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (124,'2025_06_18_110532_alter_uwil_redirections_table',95);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (125,'2025_06_18_171424_change_associated_page_field_in_news_breedings_table',95);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (126,'2025_06_19_144056_add_ratings_table',96);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (127,'2025_09_05_161808_alter_customerables_table',97);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (128,'2025_11_07_093313_create_optin_consents_table',98);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (129,'2026_02_20_133806_create_categories_approaches',99);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (130,'2026_02_20_134045_create_sections_approaches',99);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (131,'2026_03_03_092239_add_data_for_static_page_exit_outside',99);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (132,'2026_03_04_123521_add_data_to_static_page_oui_c_bon',99);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (133,'2026_03_10_105432_add_data_by_default_to_static_page_our_farms',99);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (134,'2026_03_13_124146_add_data_for_breeding_static_page',99);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (135,'2026_04_28_124147_create_game_golden-crush_table',99);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (136,'2026_04_30_115934_add_data_to_static_page_tdf',99);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (137,'2026_05_07_144145_add_section_for_oui_c_bon_page',99);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (138,'2026_06_03_124556_increase_static_pages_content_size',99);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (139,'2026_06_10_130304_update_data_to_static_page_tdf',99);
COMMIT;
SET AUTOCOMMIT=@OLD_AUTOCOMMIT;