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

704 lines
45 KiB
MySQL
Raw Permalink Normal View History

/*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' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
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) NOT NULL,
`token` varchar(255) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
UNIQUE KEY `password_resets_email_unique` (`email`),
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 `customers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `customers` (
`id` char(36) NOT NULL,
`email` varchar(255) NOT NULL,
`hashcode` char(36) NOT NULL,
`remember_token` varchar(100) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`last_login_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `customers_email_unique` (`email`),
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 `discounts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `discounts` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`type` bigint(20) unsigned NOT NULL DEFAULT 1,
`value` int(10) unsigned NOT NULL,
`is_old_price_displayed` tinyint(1) NOT NULL COMMENT 'Should the old price be displayed ?',
`date_start` timestamp NULL DEFAULT NULL,
`date_end` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `promotions_discount_type_id_foreign` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `employees`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `employees` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`customer_id` char(36) DEFAULT NULL,
`matricule` varchar(255) NOT NULL,
`nom` varchar(255) NOT NULL,
`prenom` varchar(255) NOT NULL,
`start_date` date DEFAULT NULL,
`end_date` date DEFAULT NULL,
`etablissement` varchar(255) NOT NULL,
`site` varchar(255) NOT NULL,
`service` varchar(255) NOT NULL,
`code` varchar(10) NOT NULL,
`last_sync` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `salaries_code_unique` (`code`),
UNIQUE KEY `employees_matricule_unique` (`matricule`),
KEY `employees_customer_id_foreign` (`customer_id`),
CONSTRAINT `employees_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) 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(20) unsigned NOT NULL AUTO_INCREMENT,
`uuid` varchar(255) NOT NULL,
`connection` text NOT NULL,
`queue` text NOT NULL,
`payload` longtext NOT NULL,
`exception` longtext 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 `faqs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `faqs` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`question` varchar(255) NOT NULL,
`answer` text NOT NULL,
`order` int(10) unsigned NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `faqs_order_unique` (`order`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `invalid_orders`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `invalid_orders` (
`id` char(36) NOT NULL,
`shop_id` bigint(20) unsigned DEFAULT NULL,
`reference` varchar(255) NOT NULL,
`employee` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'Domain\\ValueObjects\\OrderEmployee' CHECK (json_valid(`employee`)),
`delivery_address` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`delivery_address`)),
`pickup_day` date DEFAULT NULL,
`total` int(10) unsigned NOT NULL,
`status` bigint(20) unsigned NOT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`employee_matricule` varchar(255) GENERATED ALWAYS AS (json_unquote(json_extract(`employee`,'$.matricule'))) VIRTUAL,
PRIMARY KEY (`id`),
UNIQUE KEY `invalid_orders_reference_unique` (`reference`),
KEY `invalid_orders_employee_matricule_index` (`employee_matricule`)
) 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(20) unsigned NOT NULL AUTO_INCREMENT,
`queue` varchar(255) NOT NULL,
`payload` longtext NOT NULL,
`attempts` tinyint(3) unsigned NOT NULL,
`reserved_at` int(10) unsigned DEFAULT NULL,
`available_at` int(10) unsigned NOT NULL,
`created_at` int(10) 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 `migrations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `migrations` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`migration` varchar(255) NOT NULL,
`batch` int(11) 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 `order_lines`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `order_lines` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`order_id` char(36) NOT NULL,
`product` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'Domain\\Models\\ValueObjects\\OrderLineProduct' CHECK (json_valid(`product`)),
`quantity` int(10) unsigned NOT NULL DEFAULT 1,
`unit_price` int(10) unsigned NOT NULL,
`unit_tax` int(10) unsigned NOT NULL,
`unit_discount` int(10) unsigned NOT NULL,
`tax_rate` smallint(5) unsigned NOT NULL,
`total_ttc` int(10) unsigned NOT NULL,
`total_ht` int(10) unsigned NOT NULL,
`total_tax` int(10) unsigned NOT NULL,
`total_discount` int(10) unsigned NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `order_lines_order_id_foreign` (`order_id`),
CONSTRAINT `order_lines_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`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 `orders`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `orders` (
`id` char(36) NOT NULL,
`shop_id` char(36) DEFAULT NULL,
`reference` varchar(255) NOT NULL,
`employee` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`employee`)),
`delivery_address` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`delivery_address`)),
`pickup_day` date DEFAULT NULL,
`total` int(10) unsigned NOT NULL,
`status` bigint(20) unsigned NOT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`employee_matricule` varchar(255) GENERATED ALWAYS AS (json_unquote(json_extract(`employee`,'$.matricule'))) VIRTUAL,
PRIMARY KEY (`id`),
UNIQUE KEY `orders_reference_unique` (`reference`),
KEY `orders_status_id_foreign` (`status`),
KEY `orders_employee_matricule_index` (`employee_matricule`),
KEY `orders_shop_id_foreign` (`shop_id`),
CONSTRAINT `orders_shop_id_foreign` FOREIGN KEY (`shop_id`) REFERENCES `shops` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `pages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `pages` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`slug` varchar(255) NOT NULL,
`seo_title` varchar(255) NOT NULL,
`seo_description` varchar(255) NOT NULL,
`title` varchar(255) DEFAULT NULL,
`content` text NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `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 `pickup_exceptions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `pickup_exceptions` (
`id` char(36) NOT NULL,
`date` date NOT NULL,
`label` varchar(255) NOT NULL,
`repeatable` tinyint(1) NOT NULL,
`repeat_frequency` varchar(255) NOT NULL DEFAULT 'Weekly' COMMENT 'Enum Domain\\Enums\\RepeatFrequency',
`auto_updated` tinyint(1) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `pickup_exceptions_date_label_unique` (`date`,`label`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `product_incos`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `product_incos` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`product_id` char(36) NOT NULL,
`no_art` int(10) unsigned NOT NULL,
`ingredients` text DEFAULT NULL,
`preparation` text DEFAULT NULL,
`servings` varchar(20) DEFAULT NULL,
`allergens` text DEFAULT NULL,
`selling_argument` text DEFAULT NULL,
`nv_ref_weight_g` double unsigned DEFAULT NULL,
`nv_kj` double unsigned DEFAULT NULL,
`nv_kcal` double unsigned DEFAULT NULL,
`nv_fat_g` double unsigned DEFAULT NULL,
`nv_sat_fat_g` double unsigned DEFAULT NULL,
`nv_carb_g` double unsigned DEFAULT NULL,
`nv_sugar_g` double unsigned DEFAULT NULL,
`nv_fiber_g` double unsigned DEFAULT NULL,
`nv_protein_g` double unsigned DEFAULT NULL,
`nv_salt_g` double unsigned DEFAULT NULL,
`nv_serving_size_g` double unsigned DEFAULT NULL,
`nv_serving_kj` double unsigned DEFAULT NULL,
`nv_serving_kcal` double unsigned DEFAULT NULL,
`nv_serving_fat_g` double unsigned DEFAULT NULL,
`nv_serving_sat_fat_g` double unsigned DEFAULT NULL,
`nv_serving_carb_g` double unsigned DEFAULT NULL,
`nv_serving_sugar_g` double unsigned DEFAULT NULL,
`nv_serving_fiber_g` double unsigned DEFAULT NULL,
`nv_serving_protein_g` double unsigned DEFAULT NULL,
`nv_serving_salt_g` double unsigned DEFAULT NULL,
`nv_daily_energy` double unsigned DEFAULT NULL,
`nv_daily_fat` double unsigned DEFAULT NULL,
`nv_daily_sat_fat` double unsigned DEFAULT NULL,
`nv_daily_carb` double unsigned DEFAULT NULL,
`nv_daily_sugar` double unsigned DEFAULT NULL,
`nv_daily_fiber` double unsigned DEFAULT NULL,
`nv_daily_protein` double unsigned DEFAULT NULL,
`nv_daily_salt` double unsigned DEFAULT NULL,
`nutriscore` varchar(255) DEFAULT NULL,
`nutriscore_args` text DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `product_incos_no_art_unique` (`no_art`),
KEY `product_incos_product_id_foreign` (`product_id`),
CONSTRAINT `product_incos_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 `product_product`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `product_product` (
`product_id` char(36) NOT NULL,
`associated_id` char(36) NOT NULL,
`sort_order` int(11) NOT NULL DEFAULT 0,
KEY `product_product_product_id_foreign` (`product_id`),
KEY `product_product_associated_id_foreign` (`associated_id`),
CONSTRAINT `product_product_associated_id_foreign` FOREIGN KEY (`associated_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
CONSTRAINT `product_product_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 `product_tag`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `product_tag` (
`product_id` char(36) NOT NULL,
`tag_id` bigint(20) unsigned NOT NULL,
KEY `product_tag_tag_id_foreign` (`tag_id`),
KEY `product_tag_product_id_foreign` (`product_id`),
CONSTRAINT `product_tag_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
CONSTRAINT `product_tag_tag_id_foreign` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`)
) 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` char(36) NOT NULL,
`name` varchar(255) NOT NULL,
`brand` varchar(255) NOT NULL,
`description` text NOT NULL,
`short_description` text DEFAULT NULL,
`picture` varchar(255) DEFAULT NULL,
`picture_alt` varchar(255) NOT NULL,
`picture_title` varchar(255) NOT NULL,
`picture_large` varchar(255) DEFAULT NULL,
`picture_large_alt` varchar(255) NOT NULL,
`picture_large_title` varchar(255) NOT NULL,
`price` int(11) NOT NULL,
`invoicing_unit` varchar(255) NOT NULL,
`tax_rate` tinyint(3) unsigned NOT NULL DEFAULT 1,
`stock` int(11) NOT NULL DEFAULT 0,
`sell_unit` varchar(255) NOT NULL,
`order_unit` varchar(255) DEFAULT NULL,
`weight` int(10) unsigned DEFAULT NULL,
`weight_variable` tinyint(1) NOT NULL DEFAULT 0,
`slug` varchar(255) NOT NULL,
`star` tinyint(1) NOT NULL DEFAULT 0,
`status` tinyint(1) NOT NULL,
`orderable_start` timestamp NULL DEFAULT NULL,
`orderable_end` timestamp NULL DEFAULT NULL,
`range_id` bigint(20) unsigned NOT NULL,
`discount_id` bigint(20) unsigned DEFAULT NULL,
`order` bigint(20) unsigned NOT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `products_order_unique` (`order`),
KEY `products_range_id_foreign` (`range_id`),
KEY `products_tax_rate_id_foreign` (`tax_rate`),
KEY `products_discount_id_foreign` (`discount_id`),
CONSTRAINT `products_discount_id_foreign` FOREIGN KEY (`discount_id`) REFERENCES `discounts` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT `products_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 `ranges`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `ranges` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`slug` varchar(255) NOT NULL,
`description` text DEFAULT NULL,
`picture` varchar(255) DEFAULT NULL,
`picture_alt` varchar(255) NOT NULL,
`picture_title` varchar(255) NOT NULL,
`status` tinyint(1) NOT NULL DEFAULT 0,
`order` int(10) unsigned NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `ranges_order_unique` (`order`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `settings`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `settings` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`employee_sites` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`employee_sites`)),
`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 */;
INSERT IGNORE INTO `settings` (`id`, `employee_sites`, `created_at`, `updated_at`) VALUES (1, '[]', NOW(), NOW());
DROP TABLE IF EXISTS `shop_employee_exception`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `shop_employee_exception` (
`shop_id` char(36) NOT NULL,
`matricule` varchar(255) NOT NULL,
PRIMARY KEY (`matricule`,`shop_id`),
KEY `shop_employee_exception_shop_id_foreign` (`shop_id`),
CONSTRAINT `shop_employee_exception_matricule_foreign` FOREIGN KEY (`matricule`) REFERENCES `employees` (`matricule`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `shop_employee_exception_shop_id_foreign` FOREIGN KEY (`shop_id`) REFERENCES `shops` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Exceptions pour certains salariés afin de pallier au manque de cohérence coté régate';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `shop_employees`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `shop_employees` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`site_code` varchar(255) NOT NULL,
`service_code` varchar(255) DEFAULT NULL,
`shop_id` char(36) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `magasin_salarie_site_code_service_code_unique` (`site_code`,`service_code`),
KEY `shop_employees_shop_id_foreign` (`shop_id`),
CONSTRAINT `shop_employees_shop_id_foreign` FOREIGN KEY (`shop_id`) REFERENCES `shops` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Permet de résoudre le magasin pour un salarie en fonction du site et éventuellement du service';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `shop_pickup_exception`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `shop_pickup_exception` (
`shop_id` char(36) NOT NULL,
`pickup_exception_id` char(36) NOT NULL,
`replacement_date` date DEFAULT NULL,
`order_deadline_at` datetime DEFAULT NULL,
UNIQUE KEY `shop_pickup_exception_shop_id_pickup_exception_id_unique` (`shop_id`,`pickup_exception_id`),
KEY `shop_pickup_exception_pickup_exception_id_foreign` (`pickup_exception_id`),
CONSTRAINT `shop_pickup_exception_pickup_exception_id_foreign` FOREIGN KEY (`pickup_exception_id`) REFERENCES `pickup_exceptions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `shop_pickup_exception_shop_id_foreign` FOREIGN KEY (`shop_id`) REFERENCES `shops` (`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 `shoppingcart`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `shoppingcart` (
`identifier` varchar(255) NOT NULL,
`instance` varchar(255) NOT NULL,
`content` longtext NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`identifier`,`instance`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `shops`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `shops` (
`id` char(36) NOT NULL,
`name` varchar(255) NOT NULL,
`address` varchar(255) NOT NULL,
`postcode` varchar(255) NOT NULL,
`city` varchar(255) NOT NULL,
`phone` varchar(255) DEFAULT NULL,
`latitude` varchar(255) DEFAULT NULL,
`longitude` varchar(255) DEFAULT NULL,
`default` tinyint(1) NOT NULL DEFAULT 0,
`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 `slides`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `slides` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL,
`text` text DEFAULT NULL,
`picture` varchar(255) DEFAULT NULL,
`picture_alt` varchar(255) DEFAULT NULL,
`picture_title` varchar(255) DEFAULT NULL,
`link_label` varchar(255) DEFAULT NULL,
`link` varchar(255) DEFAULT NULL,
`link_new_tab` tinyint(1) NOT NULL DEFAULT 0,
`connected` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Slide visible only for connected customers.',
`order` int(10) unsigned NOT NULL,
`status` tinyint(1) NOT NULL,
`date_start` timestamp NULL DEFAULT NULL,
`date_end` timestamp NULL DEFAULT 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 `stats`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `stats` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`product_id` char(36) NOT NULL,
`date` date NOT NULL,
`margin` double NOT NULL DEFAULT 0,
`nb_sale` bigint(20) unsigned NOT NULL DEFAULT 0,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `stats_product_id_foreign` (`product_id`),
CONSTRAINT `stats_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 `tags`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tags` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`label` varchar(255) NOT NULL,
`slug` varchar(255) NOT NULL,
`order` int(10) unsigned NOT NULL,
`status` tinyint(1) NOT NULL DEFAULT 1,
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(20) unsigned NOT NULL AUTO_INCREMENT,
`firstname` varchar(255) NOT NULL,
`lastname` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`email_verified_at` timestamp NULL DEFAULT NULL,
`password` varchar(255) NOT NULL,
`role` int(11) NOT NULL,
`remember_token` varchar(100) DEFAULT NULL,
`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(20) unsigned NOT NULL AUTO_INCREMENT,
`hash` varchar(255) NOT NULL COMMENT 'Hash of the redirection (from old_query).',
`old_model_slug` varchar(255) NOT NULL COMMENT 'Old slug of the model.',
`old_query` varchar(255) NOT NULL COMMENT 'Old URL.',
`new_query` varchar(255) NOT NULL COMMENT 'New URL to redirect.',
`model_redirectable_id` bigint(20) unsigned NOT NULL COMMENT 'Primary key of the model.',
`model_redirectable_type` varchar(255) NOT NULL COMMENT 'Class of the model.',
`redirect_type` tinyint(3) unsigned NOT NULL COMMENT 'Type of the redirection (enum RedirectionType).',
`redirect_code` smallint(5) 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 */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*M!999999\- enable the sandbox mode */
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',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (3,'2018_12_23_120000_create_shoppingcart_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (4,'2019_08_19_000000_create_failed_jobs_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (5,'2020_11_04_132346_create_contents',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (6,'2020_11_04_132538_create_settings',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (7,'2020_11_04_133603_create_faqs',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (8,'2020_11_05_084122_create_ranges',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (9,'2020_11_05_084142_create_products',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (10,'2020_11_05_105239_create_old_slugs',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (11,'2020_11_09_113830_create_stats',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (12,'2020_11_09_125215_create_orders_status',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (13,'2020_11_09_125304_create_orders',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (14,'2020_11_09_161858_create_orders_products',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (15,'2021_02_04_175136_create_customers_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (16,'2021_02_04_180000_constrain_orders_to_customers',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (17,'2021_03_16_111337_add_fields_to_products',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (18,'2021_03_16_135155_create_food_products',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (19,'2021_03_16_140753_create_products_products',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (20,'2021_03_17_093244_add_fields_to_contents',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (21,'2021_03_27_163403_create_order_lines_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (22,'2021_03_29_114933_create_timeslots_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (23,'2021_04_06_153634_create_discount_types_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (24,'2021_04_06_154003_create_promotions_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (25,'2021_04_07_100613_create_product_promotion_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (26,'2021_04_07_153852_create_tax_rates_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (27,'2021_04_07_154718_add_fields_to_products_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (28,'2021_04_09_081311_create_tags_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (29,'2021_04_09_081345_create_product_tag_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (30,'2021_04_13_142701_remove_deprecated_tables',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (31,'2021_04_14_115938_create_sliders_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (32,'2021_04_14_115954_create_slides_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (33,'2021_04_19_145945_extend_champ_description_in_ranges_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (34,'2021_04_19_155920_change_optional_fields_in_products_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (35,'2021_04_20_154225_create_timeslot_settings_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (36,'2021_04_21_092030_create_jobs_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (37,'2021_04_21_101455_create_xml_incos_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (38,'2021_04_21_154354_create_collecte_exceptions_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (39,'2021_04_21_165607_create_magasins_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (40,'2021_04_22_153147_make_child_of_magasins_time_settings_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (41,'2021_04_23_112008_add_magasin_to_timeslots_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (42,'2021_04_26_161004_make_unique_no_art_inf_food_products_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (43,'2021_05_03_173156_alter_products_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (44,'2021_05_06_121330_create_tool_products_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (45,'2021_05_06_121546_create_anifood_products_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (46,'2021_05_06_121656_create_garment_products_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (47,'2021_05_07_091803_add_management_flags_to_tags_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (48,'2021_05_25_100049_add_fields_to_anifood_products_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (49,'2021_05_25_101151_add_fields_to_garment_products_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (50,'2021_06_07_124924_add_orderable_dates_to_products_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (51,'2021_07_20_141844_create_salaries_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (52,'2021_07_27_103748_add_required_for_order_export_fields_to_products_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (53,'2021_09_24_091612_add_code_societe_to_salaries_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (54,'2021_11_18_144311_alter_price_to_products_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (55,'2022_03_12_115802_add_nom_to_xml_incos_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (56,'2022_04_14_143040_remove_crm_id_from_customers',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (57,'2022_09_12_160131_add_brand_to_products',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (58,'2022_09_14_090354_add_fields_to_salaries',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (59,'2022_09_20_171712_link_magasin_to_salaries',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (60,'2022_10_11_163252_add_variable_weight_to_products_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (61,'2022_10_20_111255_alter_ranges_description_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (62,'2023_03_30_110313_alter_product_serving_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (63,'2023_07_04_151150_alter_code_salaries_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (64,'2023_07_04_151446_format_day_in_timeslots_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (65,'2023_07_26_091913_add_order_products_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (66,'2023_07_27_145254_alter_birth_users_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (67,'2023_07_27_150324_alter_role_users_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (68,'2023_07_27_153349_alter_clean_salaries_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (69,'2024_11_13_120306_create_uwil_redirections_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (70,'2025_02_10_112337_add_type_to_exceptions_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (71,'2025_06_18_110532_alter_uwil_redirections_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (72,'2026_02_04_102119_add_connected_field_in_slides_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (73,'2026_02_25_102520_reorder_all_products',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (74,'2026_02_25_111055_add_boolean_display_old_value_for_promotions_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (75,'2026_04_09_111244_delete_promotion_tag',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (76,'2026_04_27_152343_add_unique_to_password_resets',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (77,'2026_04_29_110121_rename_table_password_resets_to_customer_password_resets',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (78,'2026_04_29_120913_remove_id_from_customer_password_resets',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (79,'2026_05_06_164734_fix_slides_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (80,'2026_05_07_090552_delete_sliders_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (81,'2026_05_07_104436_migrate_slides_pictures',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (82,'2026_05_07_115830_add_image_attributes_on_sliders',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (83,'2026_05_07_123948_add_status_to_slides',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (84,'2026_05_12_162815_update_order_on_tags',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (85,'2026_05_12_172419_drop_anifoods_product_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (86,'2026_05_12_172830_rename_food_products',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (87,'2026_05_12_174606_drop_garment_products',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (88,'2026_05_12_174709_drop_tool_products',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (89,'2026_05_12_175637_drop_product_type_on_products',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (90,'2026_05_13_165615_resole_salarie_shop_dynamically',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (91,'2026_05_15_085114_rename_tables',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (92,'2026_05_15_094440_drop_discount_type_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (93,'2026_05_15_095409_drop_ordre_status_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (94,'2026_05_15_095736_drop_order_products',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (95,'2026_05_15_100312_drop_tax_rates',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (96,'2026_05_15_102945_drop_settings',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (97,'2026_05_15_110705_add_unique_to_matricule_employees_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (98,'2026_05_15_130940_add_unique_to_pages',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (99,'2026_05_15_131427_remove_heading_from_pages_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (100,'2026_05_15_133554_rename_promotions',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (101,'2026_05_15_165156_add_order_to_faqs_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (102,'2026_05_15_172544_add_seo_fields_on_pages_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (103,'2026_05_18_113005_migrate_old_slugs_to_redirect_package',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (104,'2026_05_18_125014_migrate_ranges_pictures',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (105,'2026_05_18_142859_add_order_to_ranges',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (106,'2026_05_18_152042_add_picture_title_to_ranges_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (107,'2026_05_18_152043_add_picture_title_to_products_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (108,'2026_05_19_094421_change_some_columns_on_products_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (109,'2026_05_19_101521_change_order_status',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (110,'2026_05_19_101521_migrate_products_pictures',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (111,'2026_05_19_101522_change_some_columns_2_on_products_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (112,'2026_05_20_113304_add_sort_order_to_product_product_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (113,'2026_05_20_123658_remove_margin_from_products_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (114,'2026_05_20_160028_change_product_inco_relation_with_product',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (115,'2026_05_21_103837_change_product_order_column',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (116,'2026_05_21_120644_remove_home_statis_page',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (117,'2026_05_21_122658_rename_offers_to_discounts',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (118,'2026_05_21_131414_rename_offers_discounts',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (119,'2026_05_21_142044_change_product_discount_relation_to_belongs_to',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (120,'2026_05_21_163851_simplify_shops_map',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (121,'2026_05_22_101939_remove_time_slot_settings',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (122,'2026_05_22_102624_remove_timeslot_time',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (123,'2026_05_22_102934_rename_shop_column_on_timeslots_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (124,'2026_05_22_104824_rename_time_slot_exceptions_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (125,'2026_05_22_124529_refactor_pickup_exception',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (126,'2026_05_26_095455_add_auto_updated_on_pickup_exceptions_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (127,'2026_05_26_143214_add_replacements_day_to_shop_pickup_exception_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (128,'2026_05_26_154849_convert_all_dates_to_utc',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (129,'2026_05_28_095941_remove_order_comment',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (130,'2026_05_28_101213_consolidate_order',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (131,'2026_05_28_101213_convert_discount_value_as_int',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (132,'2026_05_28_101213_convert_order_total_as_int',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (133,'2026_05_28_101213_convert_product_prices_as_int',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (134,'2026_05_28_101213_rename_columns_on_discount_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (135,'2026_05_28_102411_consolidate_order_lines',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (136,'2026_06_01_130113_update_sliders_links',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (137,'2026_06_01_150709_update_page_title',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (138,'2026_06_03_143713_add_short_description_to_products_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (139,'2026_06_04_154533_change_columns_to_int_on_products_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (140,'2026_06_05_082126_strip_product_short_description',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (141,'2026_06_05_112425_add_delivery_address_to_orders',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (142,'2026_06_06_181952_migrate_products_to_uuidv7',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (143,'2026_06_06_181953_migrate_orders_to_uuidv7',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (144,'2026_06_07_072414_migrate_customers_to_uuidv7',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (145,'2026_06_07_172027_drop_date_column_from_orders_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (146,'2026_06_07_175730_add_reference_to_orders_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (147,'2026_06_07_180625_simplify_timeslot_into_orders',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (148,'2026_06_07_193825_update_shop_employee_exception_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (149,'2026_06_08_164207_add_employee_matricule_virtual_index_to_orders_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (150,'2026_06_10_221046_make_invoicing_and_sell_unit_not_nullable_on_products_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (151,'2026_06_11_091414_move_invalid_orders_and_make_employee_non_nullable',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (152,'2026_06_11_104029_add_last_login_at_to_customers_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (153,'2026_06_11_160000_migrate_weights_to_grams',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (154,'2026_06_12_120149_convert_weight_variable_to_boolean_in_order_lines_product',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (155,'2026_06_12_122322_populate_null_discounted_price_in_order_lines_product',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (156,'2026_06_13_151618_migrate_shops_and_pickup_exceptions_to_uuidv7',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (157,'2026_10_01_123336_add_last_sync_to_employees',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (158,'2026_10_01_150950_fix_employee_service_code',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (159,'2026_10_01_163000_create_settings_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (160,'2026_10_02_130500_fix_ambiguous_employee_codes',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (161,'2026_10_02_143800_fix_orders_employee_column',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (162,'2026_10_02_222500_drop_xml_incos_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (163,'2026_10_07_100650_recalculate_products_order',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (164,'2026_11_02_111000_fix_inco_id_in_order_lines_product',1);