703 lines
45 KiB
SQL
703 lines
45 KiB
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' */;
|
|
/*!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);
|