-- --------------------------------------------------------
-- Hôte:                         127.0.0.1
-- Version du serveur:           10.4.32-MariaDB - mariadb.org binary distribution
-- SE du serveur:                Win64
-- HeidiSQL Version:             12.7.0.6850
-- --------------------------------------------------------


-- Listage de la structure de table raamshop_front. brands
CREATE TABLE IF NOT EXISTS `brands` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL,
  `status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `logo` varchar(255) NOT NULL,
  `summary` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.brands : ~8 rows (environ)
INSERT INTO `brands` (`id`, `title`, `code`, `status`, `created_at`, `updated_at`, `deleted_at`, `logo`, `summary`) VALUES
	(1, 'La Roche-Posay', '000001', 'Active', '2024-04-22 16:50:01', '2024-04-24 07:21:07', NULL, 'storage/brands/la-roche-posay-1713950467.png', 'La Roche-Posay est une marque dermatologique de parapharmacie proposant des soins aussi bien pour le visage que pour le corps, des produits solaires, des soins pour le bébé, ou des produits de maquillage, notamment pour les peaux sensibles. Retrouvez les gammes de produits La Roche-Posay comme par exemple Lipikar.');
INSERT INTO `brands` (`id`, `title`, `code`, `status`, `created_at`, `updated_at`, `deleted_at`, `logo`, `summary`) VALUES
	(2, 'IN\'OYA', '000002', 'Active', '2024-04-24 07:42:55', '2024-04-24 07:42:55', NULL, 'storage/brands/inoya-1713951775.png', 'Professionnels, passionnés, et d&#039;origine multi-ethnique, les experts en dermatologie des peaux noires et mates composant l&#039;équipe scientifique d&#039;IN&#039;OYA mettent à la disposition de la femme noire des produits innovants, efficaces et sans aucun effet secondaire. Issues des recherches brevetées, nos formules garantissent efficacité et innocuité. Sans hydroquinone ni parabène, IN&#039;OYA s&#039;engage à formuler des produits qui prennent soin des peaux et de la santé de toutes les femmes noires et mates. Aucun produit ou ingrédient IN&#039;OYA n&#039;est testé sur des animaux. Au sein des laboratoires, les produits sont testés cliniquement aussi bien avec les technologies les plus avancées issues des recherches sur les modèles alternatifs (culture cellulaire, épiderme reconstituée...) que sur des volontaires sains. Les résultats prouvent l&#039;absence d&#039;effets secondaires indésirables et confirment l&#039;efficacité souhaitée.');
INSERT INTO `brands` (`id`, `title`, `code`, `status`, `created_at`, `updated_at`, `deleted_at`, `logo`, `summary`) VALUES
	(3, 'Biolissime Paris', '000003', 'Active', '2024-04-24 07:47:11', '2024-04-24 07:47:53', NULL, 'storage/brands/biolissime-paris-1713952072.png', 'Bintou Camara, créatrice de la marque Biolissime Paris souhaite à travers sa gamme de soins cosmétiques rendre hommage à l’Afrique somptueuse, à la beauté d’un continent puissant et prodigieux dont elle est originaire. Biolissime vous emmène dans un véritable voyage au cœur de la profusion de la vie végétale africaine, à la découverte des senteurs les plus exquises et des textures les plus douces.');
INSERT INTO `brands` (`id`, `title`, `code`, `status`, `created_at`, `updated_at`, `deleted_at`, `logo`, `summary`) VALUES
	(4, 'CeraVe', '000004', 'Active', '2024-04-24 07:54:34', '2024-04-24 07:54:34', NULL, 'storage/brands/cerave-1713952474.png', 'Développé avec des dermatologues, CeraVe propose une gamme complète de nettoyants, d&#039;hydratants et plus encore qui contiennent trois céramides essentiels.\r\nQue vous ayez une peau sensible, grasse, mixte, sèche, à tendance acnéique ou des affections cutanées spécifiques comme l&#039;eczéma ou le psoriasis, CeraVe vous propose des soins dermatologiques répondant à vos besoins.');
INSERT INTO `brands` (`id`, `title`, `code`, `status`, `created_at`, `updated_at`, `deleted_at`, `logo`, `summary`) VALUES
	(5, 'JUMISO', '000005', 'Active', '2024-04-24 07:58:04', '2024-04-24 07:58:04', NULL, 'storage/brands/jumiso-1713952684.png', 'Filiale de la marque HELLOSKIN, JUMISO propose des masques et autres produits de soin de la peau en privilégiant avant tout la satisfaction du client. La marque tire son nom des mots coréens « ju », qui signifie « donner », et « miso », qui signifie « sourire ». JUMISO fabrique tous ses produits en Corée, y compris ses best-sellers Rich Nourishment Mask, First Skin Lightening Mask, Whoa Whoa Soothing Mask et Water Splash Mask.');
INSERT INTO `brands` (`id`, `title`, `code`, `status`, `created_at`, `updated_at`, `deleted_at`, `logo`, `summary`) VALUES
	(6, 'SOME BY MI', '000006', 'Active', '2024-04-24 12:40:34', '2024-04-24 12:48:40', NULL, 'storage/brands/some-by-mi-1713970120.png', 'SOME BY MI estime que la beauté naturelle mérite plus d’attention. Le nom de la marque vient du mot coréen « mi » signifiant « beauté » : elle fabrique tous ses produits en Corée. SOME BY MI propose une large gamme de soins pour la peau et produits de maquillage, notamment ses produits phares : le toner AHA BHA PHA 30 Days Miracle Toner, le cushion Coverst Moisture Outstanding Cushion, ainsi que les crèmes Rose Intensive Tone-Up Cream et Rose Intensive Body Tone-Up Cream.');
INSERT INTO `brands` (`id`, `title`, `code`, `status`, `created_at`, `updated_at`, `deleted_at`, `logo`, `summary`) VALUES
	(7, 'AXIS-Y', '000007', 'Active', '2024-04-24 13:02:45', '2024-04-24 13:02:45', NULL, 'storage/brands/axis-y-1713970965.png', 'La marque de soins de la peau AXIS - Y a développé sa gamme de produits conçus pour les peaux grasses à tendance acnéique, en tenant compte des changements climatiques et des saisons. Cruelty-free, elle a une approche minimaliste des soins de la peau avec une formule 6+1+1, enrichissant ses produits avec six types d&#039;extraits de plantes, un ingrédient principal ciblant un problème de peau particulier et un ingrédient breveté. Tous les produits AXIS - Y sont fabriqués à 100% en Corée et ne contiennent ni parabènes, ni huiles minérales, ni colorants ni parfums artificiels. La marque est surtout connue pour son toner Daily Purifying Treatment et son ampoule Artichoke Intensive Skin Barrier.');
INSERT INTO `brands` (`id`, `title`, `code`, `status`, `created_at`, `updated_at`, `deleted_at`, `logo`, `summary`) VALUES
	(8, 'Good Molecules', '000008', 'Active', '2024-05-23 14:17:04', '2024-05-23 14:17:04', NULL, 'storage/brands/good-molecules-1716481024.webp', 'L’idée derrière Good Molecules est simple : des soins pour la peau efficaces au juste prix. Fondée par une équipe de vétérans de l’industrie de la beauté, Good Molecules crée des solutions de soins pour la peau avec des ingrédients de premier plan, soutenues par la recherche et formulées pour une efficacité optimale. En travaillant directement avec les meilleurs laboratoires, Good Molecules propose des produits qui ciblent les problèmes de peau tels que l’acné, les rougeurs et l’hyperpigmentation.');

-- Listage de la structure de table raamshop_front. carts
CREATE TABLE IF NOT EXISTS `carts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `products_json` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`products_json`)),
  `status` enum('Conservé','Abandonné','Expiré') NOT NULL DEFAULT 'Conservé',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `ordered` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `carts_user_id_foreign` (`user_id`),
  CONSTRAINT `carts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.carts : ~5 rows (environ)
INSERT INTO `carts` (`id`, `user_id`, `products_json`, `status`, `created_at`, `updated_at`, `deleted_at`, `ordered`) VALUES
	(1, 4, '{"000007":{"name":"Facetheory Clarifying","image":"storage\\/products\\/facetheory-clarifying-1712674918.jpg","quantity":1,"raw_price":12500,"discount":5,"price":11875,"total":11875},"000012":{"name":"Ginseng Cleansing Oil","image":"storage\\/products\\/ginseng-cleansing-oil-1712734534.jpg","quantity":1,"raw_price":22000,"discount":0,"price":22000,"total":22000},"000013":{"name":"IN\'OYA","image":"storage\\/products\\/inoya-1712734843.jpg","quantity":1,"raw_price":25000,"discount":0,"price":25000,"total":25000},"000001":{"name":"Quinoa Gel Cleanser","image":"storage\\/products\\/quinoa-gel-cleanser-1712674414.jpg","quantity":2,"raw_price":15000,"discount":12,"price":13200,"total":26400},"000009":{"name":"JUMISO All Day Vitamin","image":"storage\\/products\\/jumiso-all-day-vitamin-1712675731.jpg","quantity":1,"raw_price":35000,"discount":0,"price":35000,"total":35000}}', 'Expiré', '2024-04-01 11:47:18', '2024-04-26 15:32:58', NULL, 1);
INSERT INTO `carts` (`id`, `user_id`, `products_json`, `status`, `created_at`, `updated_at`, `deleted_at`, `ordered`) VALUES
	(3, 4, '{"000010":{"name":"Nineless A-Control","image":"storage\\/products\\/nineless-a-control-1712682049.jpg","quantity":1,"raw_price":12500,"discount":0,"price":12500,"total":12500},"000007":{"name":"Facetheory Clarifying","image":"storage\\/products\\/facetheory-clarifying-1712674918.jpg","quantity":1,"raw_price":12500,"discount":5,"price":11875,"total":11875}}', 'Expiré', '2024-04-26 16:25:52', '2024-04-26 16:27:33', NULL, 1);
INSERT INTO `carts` (`id`, `user_id`, `products_json`, `status`, `created_at`, `updated_at`, `deleted_at`, `ordered`) VALUES
	(4, 8, '{"000016":{"name":"ANUA HeartLeaf 77%","image":"storage\\/products\\/anua-heartleaf-77-1712933962.jpg","quantity":2,"raw_price":17000,"discount":0,"price":17000,"total":34000},"000017":{"name":"AHA.BHA.PHA","image":"storage\\/products\\/ahabhapha-1713980478.jpg","quantity":7,"raw_price":27000,"discount":0,"price":27000,"total":189000},"000008":{"name":"B-BOOST 10% Niacinamide Serum","image":"storage\\/products\\/b-boost-10-niacinamide-serum-1712675404.jpg","quantity":29,"raw_price":23800,"discount":0,"price":23800,"total":690200},"000014":{"name":"TOCOBO","image":"storage\\/products\\/tocobo-1712735050.jpg","quantity":6,"raw_price":52000,"discount":0,"price":52000,"total":312000}}', 'Expiré', '2024-04-30 16:00:33', '2024-05-06 16:39:15', NULL, 1);
INSERT INTO `carts` (`id`, `user_id`, `products_json`, `status`, `created_at`, `updated_at`, `deleted_at`, `ordered`) VALUES
	(5, 9, '{"000017":{"name":"AHA.BHA.PHA","image":"storage\\/products\\/ahabhapha-1713980478.jpg","quantity":2,"raw_price":27000,"discount":0,"price":27000,"total":54000},"000007":{"name":"Facetheory Clarifying","image":"storage\\/products\\/facetheory-clarifying-1712674918.jpg","quantity":5,"raw_price":12500,"discount":5,"price":11875,"total":59375},"000010":{"name":"Nineless A-Control","image":"storage\\/products\\/nineless-a-control-1712682049.jpg","quantity":2,"raw_price":12500,"discount":0,"price":12500,"total":25000}}', 'Conservé', '2024-05-07 13:25:43', '2024-05-07 13:26:21', NULL, 0);
INSERT INTO `carts` (`id`, `user_id`, `products_json`, `status`, `created_at`, `updated_at`, `deleted_at`, `ordered`) VALUES
	(6, 8, '{"000016":{"name":"ANUA HeartLeaf 77%","image":"storage\\/products\\/anua-heartleaf-77-1712933962.jpg","quantity":2,"raw_price":17000,"discount":0,"price":17000,"total":34000},"000010":{"name":"Nineless A-Control","image":"storage\\/products\\/nineless-a-control-1712682049.jpg","quantity":6,"raw_price":12500,"discount":0,"price":12500,"total":75000},"000018":{"name":"Discoloration Correcting Body Treatment","image":"storage\\/products\\/discoloration-correcting-body-treatment-1716481577.jpg","quantity":1,"raw_price":10000,"discount":1,"price":9900,"total":9900}}', 'Conservé', '2024-05-07 16:07:08', '2024-05-24 14:31:31', NULL, 0);

-- Listage de la structure de table raamshop_front. categories
CREATE TABLE IF NOT EXISTS `categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `summary` longtext DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
  `is_parent` tinyint(1) NOT NULL DEFAULT 1,
  `parent_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.categories : ~8 rows (environ)
INSERT INTO `categories` (`id`, `code`, `name`, `created_at`, `updated_at`, `deleted_at`, `summary`, `photo`, `status`, `is_parent`, `parent_id`) VALUES
	(1, '000001', 'Nouveauté', '2024-03-06 22:08:10', '2024-04-09 11:41:46', '2024-04-09 11:41:46', NULL, NULL, 'Inactive', 1, NULL);
INSERT INTO `categories` (`id`, `code`, `name`, `created_at`, `updated_at`, `deleted_at`, `summary`, `photo`, `status`, `is_parent`, `parent_id`) VALUES
	(2, '000002', 'Souvent Acheté', '2024-03-06 22:08:10', '2024-04-09 11:41:57', '2024-04-09 11:41:57', NULL, NULL, 'Inactive', 1, NULL);
INSERT INTO `categories` (`id`, `code`, `name`, `created_at`, `updated_at`, `deleted_at`, `summary`, `photo`, `status`, `is_parent`, `parent_id`) VALUES
	(3, '000003', 'Populaire', '2024-03-06 22:08:10', '2024-04-09 11:41:52', '2024-04-09 11:41:52', NULL, NULL, 'Inactive', 1, NULL);
INSERT INTO `categories` (`id`, `code`, `name`, `created_at`, `updated_at`, `deleted_at`, `summary`, `photo`, `status`, `is_parent`, `parent_id`) VALUES
	(4, '000004', 'Tendance', '2024-03-15 15:04:26', '2024-03-15 15:04:46', '2024-03-15 15:04:46', NULL, NULL, 'Inactive', 1, NULL);
INSERT INTO `categories` (`id`, `code`, `name`, `created_at`, `updated_at`, `deleted_at`, `summary`, `photo`, `status`, `is_parent`, `parent_id`) VALUES
	(5, '000005', 'Soins de la Peau', '2024-04-09 08:53:04', '2024-05-05 17:15:40', NULL, 'Les soins de la peau regroupent une large gamme de produits et de pratiques visant à maintenir la santé et l\'apparence de la peau. Cela inclut le nettoyage, l\'hydratation, la protection solaire et le traitement de problèmes spécifiques tels que l\'acné, les rides et la sécheresse.', NULL, 'Active', 1, NULL);
INSERT INTO `categories` (`id`, `code`, `name`, `created_at`, `updated_at`, `deleted_at`, `summary`, `photo`, `status`, `is_parent`, `parent_id`) VALUES
	(6, '000006', 'Maquillages', '2024-04-09 08:58:41', '2024-04-09 08:58:41', NULL, NULL, NULL, 'Active', 1, NULL);
INSERT INTO `categories` (`id`, `code`, `name`, `created_at`, `updated_at`, `deleted_at`, `summary`, `photo`, `status`, `is_parent`, `parent_id`) VALUES
	(7, '000007', 'Hidratants', '2024-04-09 09:58:44', '2024-04-09 09:58:44', NULL, NULL, NULL, 'Active', 1, NULL);
INSERT INTO `categories` (`id`, `code`, `name`, `created_at`, `updated_at`, `deleted_at`, `summary`, `photo`, `status`, `is_parent`, `parent_id`) VALUES
	(8, '000008', 'Produits Naturels', '2024-04-09 11:51:22', '2024-04-09 11:51:22', NULL, NULL, NULL, 'Active', 1, NULL);

-- Listage de la structure de table raamshop_front. category_product
CREATE TABLE IF NOT EXISTS `category_product` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` bigint(20) unsigned NOT NULL,
  `product_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `category_product_category_id_foreign` (`category_id`),
  KEY `category_product_product_id_foreign` (`product_id`),
  CONSTRAINT `category_product_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`),
  CONSTRAINT `category_product_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.category_product : ~24 rows (environ)
INSERT INTO `category_product` (`id`, `category_id`, `product_id`, `created_at`, `updated_at`) VALUES
	(1, 1, 1, NULL, NULL);
INSERT INTO `category_product` (`id`, `category_id`, `product_id`, `created_at`, `updated_at`) VALUES
	(2, 1, 2, NULL, NULL);
INSERT INTO `category_product` (`id`, `category_id`, `product_id`, `created_at`, `updated_at`) VALUES
	(3, 1, 3, NULL, NULL);
INSERT INTO `category_product` (`id`, `category_id`, `product_id`, `created_at`, `updated_at`) VALUES
	(4, 1, 4, NULL, NULL);
INSERT INTO `category_product` (`id`, `category_id`, `product_id`, `created_at`, `updated_at`) VALUES
	(5, 3, 4, NULL, NULL);
INSERT INTO `category_product` (`id`, `category_id`, `product_id`, `created_at`, `updated_at`) VALUES
	(6, 2, 5, NULL, NULL);
INSERT INTO `category_product` (`id`, `category_id`, `product_id`, `created_at`, `updated_at`) VALUES
	(7, 5, 6, NULL, NULL);
INSERT INTO `category_product` (`id`, `category_id`, `product_id`, `created_at`, `updated_at`) VALUES
	(8, 8, 7, NULL, NULL);
INSERT INTO `category_product` (`id`, `category_id`, `product_id`, `created_at`, `updated_at`) VALUES
	(9, 6, 8, NULL, NULL);
INSERT INTO `category_product` (`id`, `category_id`, `product_id`, `created_at`, `updated_at`) VALUES
	(10, 7, 9, NULL, NULL);
INSERT INTO `category_product` (`id`, `category_id`, `product_id`, `created_at`, `updated_at`) VALUES
	(11, 8, 10, NULL, NULL);
INSERT INTO `category_product` (`id`, `category_id`, `product_id`, `created_at`, `updated_at`) VALUES
	(12, 5, 10, NULL, NULL);
INSERT INTO `category_product` (`id`, `category_id`, `product_id`, `created_at`, `updated_at`) VALUES
	(13, 8, 11, NULL, NULL);
INSERT INTO `category_product` (`id`, `category_id`, `product_id`, `created_at`, `updated_at`) VALUES
	(14, 5, 11, NULL, NULL);
INSERT INTO `category_product` (`id`, `category_id`, `product_id`, `created_at`, `updated_at`) VALUES
	(15, 5, 12, NULL, NULL);
INSERT INTO `category_product` (`id`, `category_id`, `product_id`, `created_at`, `updated_at`) VALUES
	(16, 6, 13, NULL, NULL);
INSERT INTO `category_product` (`id`, `category_id`, `product_id`, `created_at`, `updated_at`) VALUES
	(17, 5, 14, NULL, NULL);
INSERT INTO `category_product` (`id`, `category_id`, `product_id`, `created_at`, `updated_at`) VALUES
	(18, 5, 15, NULL, NULL);
INSERT INTO `category_product` (`id`, `category_id`, `product_id`, `created_at`, `updated_at`) VALUES
	(19, 6, 15, NULL, NULL);
INSERT INTO `category_product` (`id`, `category_id`, `product_id`, `created_at`, `updated_at`) VALUES
	(20, 7, 16, NULL, NULL);
INSERT INTO `category_product` (`id`, `category_id`, `product_id`, `created_at`, `updated_at`) VALUES
	(21, 6, 17, NULL, NULL);
INSERT INTO `category_product` (`id`, `category_id`, `product_id`, `created_at`, `updated_at`) VALUES
	(22, 8, 17, NULL, NULL);
INSERT INTO `category_product` (`id`, `category_id`, `product_id`, `created_at`, `updated_at`) VALUES
	(23, 5, 18, NULL, NULL);
INSERT INTO `category_product` (`id`, `category_id`, `product_id`, `created_at`, `updated_at`) VALUES
	(24, 7, 19, NULL, NULL);

-- Listage de la structure de table raamshop_front. commands
CREATE TABLE IF NOT EXISTS `commands` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `date` datetime NOT NULL,
  `code` varchar(255) NOT NULL DEFAULT '1709766458',
  `supplier_id` bigint(20) unsigned DEFAULT NULL,
  `products` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`products`)),
  `discount_on_total` varchar(255) NOT NULL DEFAULT '0',
  `total` double NOT NULL DEFAULT 0,
  `payment_method_id` bigint(20) unsigned DEFAULT NULL,
  `tva` varchar(255) NOT NULL DEFAULT '0',
  `state_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `commands_supplier_id_foreign` (`supplier_id`),
  KEY `commands_payment_method_id_foreign` (`payment_method_id`),
  KEY `commands_state_id_foreign` (`state_id`),
  CONSTRAINT `commands_payment_method_id_foreign` FOREIGN KEY (`payment_method_id`) REFERENCES `payment_methods` (`id`),
  CONSTRAINT `commands_state_id_foreign` FOREIGN KEY (`state_id`) REFERENCES `states` (`id`),
  CONSTRAINT `commands_supplier_id_foreign` FOREIGN KEY (`supplier_id`) REFERENCES `suppliers` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.commands : ~0 rows (environ)

-- Listage de la structure de table raamshop_front. companies
CREATE TABLE IF NOT EXISTS `companies` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `slogan` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `phone1` varchar(255) DEFAULT NULL,
  `phone2` varchar(255) DEFAULT NULL,
  `phone3` varchar(255) DEFAULT NULL,
  `phone4` varchar(255) DEFAULT NULL,
  `email1` varchar(255) DEFAULT NULL,
  `email2` varchar(255) DEFAULT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.companies : ~1 rows (environ)
INSERT INTO `companies` (`id`, `name`, `slogan`, `address`, `phone1`, `phone2`, `phone3`, `phone4`, `email1`, `email2`, `logo`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, 'Ra\'am Shop', '', 'Agoè - Limousine', '+22812345678', '', '', '', 'email@raamshop.com', '', 'assets/images/logo/logo-dark-120.png', '2024-03-06 22:08:10', '2024-03-06 22:08:10', NULL);

-- Listage de la structure de table raamshop_front. coupons
CREATE TABLE IF NOT EXISTS `coupons` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `type` enum('Fixé','Pourcentage') NOT NULL DEFAULT 'Fixé',
  `value` decimal(20,2) NOT NULL,
  `status` enum('Actif','Inactif') NOT NULL DEFAULT 'Inactif',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `coupons_code_unique` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.coupons : ~2 rows (environ)
INSERT INTO `coupons` (`id`, `code`, `type`, `value`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, 'CPN-54SDF757F56', 'Fixé', 10000.00, 'Actif', '2024-04-16 18:11:07', NULL, NULL);
INSERT INTO `coupons` (`id`, `code`, `type`, `value`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(2, 'CPN-45Z782DF3Q9', 'Pourcentage', 20.00, 'Actif', '2024-05-06 18:11:07', NULL, NULL);

-- Listage de la structure de table raamshop_front. customers
CREATE TABLE IF NOT EXISTS `customers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `phone_number` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `state` int(11) NOT NULL,
  `city` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `customers_user_id_foreign` (`user_id`),
  CONSTRAINT `customers_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.customers : ~2 rows (environ)
INSERT INTO `customers` (`id`, `first_name`, `last_name`, `phone_number`, `email`, `country`, `state`, `city`, `created_at`, `updated_at`, `deleted_at`, `user_id`) VALUES
	(1, 'John', 'Doe', '+22899887766', 'johndoe@gestapp.com', 'TG', 2576, 'Lomé', '2024-04-26 15:32:58', '2024-04-26 15:32:58', NULL, 4);
INSERT INTO `customers` (`id`, `first_name`, `last_name`, `phone_number`, `email`, `country`, `state`, `city`, `created_at`, `updated_at`, `deleted_at`, `user_id`) VALUES
	(2, 'Bola', 'Adeyemi', '+234648523617', 'boladeyemi@gestapp.com', 'MO', 2579, 'Lagos', '2024-05-06 16:39:15', '2024-05-06 16:39:15', NULL, NULL);

-- Listage de la structure de table raamshop_front. debtors
CREATE TABLE IF NOT EXISTS `debtors` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` bigint(20) unsigned DEFAULT NULL,
  `sell_id` bigint(20) unsigned DEFAULT NULL,
  `paid_amount` double NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `debtors_customer_id_foreign` (`customer_id`),
  KEY `debtors_sell_id_foreign` (`sell_id`),
  CONSTRAINT `debtors_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`),
  CONSTRAINT `debtors_sell_id_foreign` FOREIGN KEY (`sell_id`) REFERENCES `sells` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.debtors : ~0 rows (environ)

-- Listage de la structure de table raamshop_front. expenses
CREATE TABLE IF NOT EXISTS `expenses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `expense_type_id` bigint(20) unsigned DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `receipt` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `expenses_expense_type_id_foreign` (`expense_type_id`),
  CONSTRAINT `expenses_expense_type_id_foreign` FOREIGN KEY (`expense_type_id`) REFERENCES `expense_types` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.expenses : ~0 rows (environ)

-- Listage de la structure de table raamshop_front. expense_types
CREATE TABLE IF NOT EXISTS `expense_types` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.expense_types : ~0 rows (environ)

-- Listage de la structure de table raamshop_front. failed_jobs
CREATE TABLE IF NOT EXISTS `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;

-- Listage des données de la table raamshop_front.failed_jobs : ~0 rows (environ)

-- Listage de la structure de table raamshop_front. inventories
CREATE TABLE IF NOT EXISTS `inventories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.inventories : ~0 rows (environ)

-- Listage de la structure de table raamshop_front. invoices
CREATE TABLE IF NOT EXISTS `invoices` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.invoices : ~0 rows (environ)

-- Listage de la structure de table raamshop_front. logs
CREATE TABLE IF NOT EXISTS `logs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `action` varchar(255) NOT NULL,
  `detail` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `logs_user_id_foreign` (`user_id`),
  CONSTRAINT `logs_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.logs : ~0 rows (environ)

-- Listage de la structure de table raamshop_front. messages
CREATE TABLE IF NOT EXISTS `messages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `subject` text NOT NULL,
  `message` longtext NOT NULL,
  `read_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.messages : ~3 rows (environ)
INSERT INTO `messages` (`id`, `name`, `email`, `phone`, `photo`, `subject`, `message`, `read_at`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, 'John Doe', 'johndoe@gestapp.com', NULL, 'images/user.png', 'Just a test', 'This is a simple message test. Have a nice Day!', '2024-05-23 13:44:42', '2024-04-19 11:44:29', '2024-05-23 13:44:42', NULL);
INSERT INTO `messages` (`id`, `name`, `email`, `phone`, `photo`, `subject`, `message`, `read_at`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(2, 'Utilisatrice de Quinoa', 'quinoa@utilisatrice.com', NULL, 'images/user.png', 'A quand le retour de Quinoa ?', 'Bonjour. J\'aimerais savoir si votre produit "Quinoa Gel Cleanser" sera bientôt de retour. Parce que je trouve que c\'est un très bon produit, mais cela fait quand même un moment que nous ne le voyons plus en rayon. \r\n\r\nMerci.', NULL, '2024-04-19 15:56:05', '2024-04-19 15:56:05', NULL);
INSERT INTO `messages` (`id`, `name`, `email`, `phone`, `photo`, `subject`, `message`, `read_at`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(3, 'Super Admin', 'sa@proconsulting-info.com', NULL, 'images/user.png', 'Une petite salutation', 'Ceci est un autre message de test (oui, en français cette fois-ci ☺️) envoyé depuis mon téléphone portable.\r\nA ceux et celles qui liront ce message, bonne journée !', '2024-05-23 15:17:34', '2024-04-20 10:09:27', '2024-05-23 15:17:34', NULL);

-- Listage de la structure de table raamshop_front. migrations
CREATE TABLE IF NOT EXISTS `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=80 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.migrations : ~77 rows (environ)
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_reset_tokens_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(3, '2014_10_12_100000_create_password_resets_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, '2019_12_14_000001_create_personal_access_tokens_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(6, '2020_07_27_174857_create_categories_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(7, '2020_07_27_175010_create_unit_measures_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(8, '2020_07_27_175016_create_products_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(9, '2020_07_27_175017_create_product_details_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(10, '2020_07_27_175018_create_states_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(11, '2020_07_27_175424_create_payment_methods_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(12, '2020_07_27_180334_create_movement_types_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(13, '2020_07_27_180455_create_inventories_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(14, '2020_07_27_180722_create_suppliers_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(15, '2020_07_27_180803_create_customers_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(16, '2020_07_29_162525_create_expense_types_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(17, '2020_07_29_162535_create_expenses_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(18, '2020_07_29_162609_create_invoices_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(19, '2020_07_30_055205_create_stocks_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(20, '2020_07_30_063705_create_out_types_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(21, '2020_07_30_063706_create_sells_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(22, '2020_08_06_150846_create_logs_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(23, '2020_08_17_095047_create_companies_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(24, '2020_08_18_063346_create_reports_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(25, '2020_08_19_141815_create_roles_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(26, '2020_08_19_141930_create_permissions_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(27, '2020_08_19_141950_create_tables_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(28, '2020_08_19_142024_create_role_user_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(29, '2020_08_19_142044_create_permission_role_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(30, '2020_08_19_142107_create_permission_table_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(31, '2020_08_20_115644_create_debtors_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(32, '2020_08_25_100729_create_printer_types_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(33, '2020_08_25_100759_create_printers_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(34, '2020_08_26_073717_create_navigator_types_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(35, '2020_08_26_088604_create_navigators_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(36, '2020_08_28_114520_create_role_table_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(37, '2020_10_22_083406_create_commands_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(38, '2021_01_02_121724_create_product_unit_measure_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(39, '2021_04_23_111417_create_supplier_credits_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(40, '2021_05_07_120456_create_return_stocks_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(41, '2023_11_29_092332_create_category_products_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(42, '2024_03_06_223936_create_settings_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(43, '2024_03_10_181656_updated_brand_category_product_models', 2);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(44, '2024_03_10_192028_redo_softdeletes_for-users', 3);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(45, '2024_03_11_100229_update_permission_table', 4);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(46, '2024_03_11_100245_update_permissionrole_table', 4);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(47, '2024_03_11_123113_create_carts_table', 4);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(48, '2024_03_11_130105_create_coupons_table', 4);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(49, '2024_03_11_164904_create_shippings_table', 5);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(50, '2024_03_11_133057_create_orders_table', 6);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(51, '2024_03_11_161133_create_permission_role_resources_table', 6);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(52, '2024_03_11_163338_create_sales_table', 6);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(53, '2024_03_11_170038_create_wishlists_table', 6);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(54, '2024_03_25_142639_add_category_id_to_products', 7);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(55, '2024_03_25_163807_update_status_to_products', 8);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(56, '2024_03_25_165439_add_status_to_products', 9);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(57, '2024_03_26_172612_edit_status_in_categories', 10);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(58, '2024_03_27_114602_edit_discount_in_products', 11);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(60, '2024_03_30_160947_add_foreign_key_to_orders_table', 12);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(61, '2024_03_11_133056_create_shippings_table', 13);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(62, '2024_03_30_152423_add_ordered_to_carts_table', 13);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(63, '2024_03_30_170757_modify_status_column_in_carts_table', 14);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(64, '2024_03_30_180942_modify_columns_in_products_table', 15);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(65, '2024_04_01_135152_add_cart_id_column_in_wishlists_table', 16);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(66, '2024_04_09_143239_change_summary_type_in_products', 17);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(67, '2024_04_17_145040_add_in_detail_available_quantity_to_products', 18);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(69, '2024_04_19_114014_create_messages_table', 19);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(70, '2024_04_22_162456_update_brands_table', 20);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(71, '2024_04_22_163747_update_brand_id_type_in_products_table', 21);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(72, '2024_04_26_153454_add_columns_in_shippings_table', 22);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(73, '2024_04_26_155310_add_columns_in_customers_table', 23);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(74, '2024_04_26_155921_add_columns_in_orders_table', 23);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(75, '2024_04_26_181535_add_column_user_id_in_customers_table', 24);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(76, '2024_05_03_152259_add_wholesale_available_quantity_to_products', 25);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(77, '2024_05_05_190634_update_summary_in_categories', 26);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(78, '2024_05_06_183119_update_sub_total_in_orders', 27);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(79, '2024_05_21_145713_update_column_state_in_orders_table', 28);

-- Listage de la structure de table raamshop_front. movement_types
CREATE TABLE IF NOT EXISTS `movement_types` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `movement` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.movement_types : ~0 rows (environ)

-- Listage de la structure de table raamshop_front. navigators
CREATE TABLE IF NOT EXISTS `navigators` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `navigator_type_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `navigators_navigator_type_id_foreign` (`navigator_type_id`),
  CONSTRAINT `navigators_navigator_type_id_foreign` FOREIGN KEY (`navigator_type_id`) REFERENCES `navigator_types` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.navigators : ~0 rows (environ)

-- Listage de la structure de table raamshop_front. navigator_types
CREATE TABLE IF NOT EXISTS `navigator_types` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.navigator_types : ~0 rows (environ)

-- Listage de la structure de table raamshop_front. orders
CREATE TABLE IF NOT EXISTS `orders` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `order_number` varchar(255) NOT NULL,
  `sub_total` double(12,2) unsigned NOT NULL,
  `cart_id` bigint(20) unsigned NOT NULL,
  `status` enum('Nouvelle','Traitée','Livrée','Annulée') NOT NULL DEFAULT 'Nouvelle',
  `total_amount` double(12,2) unsigned NOT NULL,
  `payment_method_id` bigint(20) unsigned NOT NULL,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `phone` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `post_code` varchar(255) DEFAULT NULL,
  `address1` varchar(255) NOT NULL,
  `address2` varchar(255) DEFAULT NULL,
  `payment_status` enum('Payé','Impayé') NOT NULL DEFAULT 'Impayé',
  `coupon_code` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `state` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `latitude` varchar(255) NOT NULL,
  `longitude` varchar(255) NOT NULL,
  `customer_id` bigint(20) unsigned DEFAULT NULL,
  `note` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `orders_order_number_unique` (`order_number`),
  KEY `orders_user_id_foreign` (`user_id`),
  KEY `orders_cart_id_foreign` (`cart_id`),
  KEY `orders_payment_method_id_foreign` (`payment_method_id`),
  KEY `orders_customer_id_foreign` (`customer_id`),
  CONSTRAINT `orders_cart_id_foreign` FOREIGN KEY (`cart_id`) REFERENCES `carts` (`id`),
  CONSTRAINT `orders_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE,
  CONSTRAINT `orders_payment_method_id_foreign` FOREIGN KEY (`payment_method_id`) REFERENCES `payment_methods` (`id`),
  CONSTRAINT `orders_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.orders : ~3 rows (environ)
INSERT INTO `orders` (`id`, `user_id`, `order_number`, `sub_total`, `cart_id`, `status`, `total_amount`, `payment_method_id`, `first_name`, `last_name`, `phone`, `email`, `country`, `post_code`, `address1`, `address2`, `payment_status`, `coupon_code`, `created_at`, `updated_at`, `deleted_at`, `state`, `city`, `latitude`, `longitude`, `customer_id`, `note`) VALUES
	(1, 4, 'ORD-HCD1F6YVID/1', 120275.00, 1, 'Livrée', 125275.00, 2, 'John', 'Doe', '+22899887766', 'johndoe@gestapp.com', 'TG', '0487', 'Agoè - Cacavéli', 'Bvd 30 aout, Résidence Akpenè Apt2', 'Payé', 'CPN-54SDF757F56', '2024-04-26 15:32:58', '2024-05-05 14:03:07', NULL, '2576', 'Lomé', '6.2144982', '1.1983422', 1, 'J\'aime bien vos produits, continuez comme ça 😊👌.');
INSERT INTO `orders` (`id`, `user_id`, `order_number`, `sub_total`, `cart_id`, `status`, `total_amount`, `payment_method_id`, `first_name`, `last_name`, `phone`, `email`, `country`, `post_code`, `address1`, `address2`, `payment_status`, `coupon_code`, `created_at`, `updated_at`, `deleted_at`, `state`, `city`, `latitude`, `longitude`, `customer_id`, `note`) VALUES
	(2, 4, 'ORD-PBT7R6TDI6/2', 24375.00, 3, 'Traitée', 34375.00, 3, 'John', 'Doe', '+22899887766', 'johndoe@gestapp.com', 'TG', '0488', 'Sokodé', 'Apt2', 'Payé', NULL, '2024-04-26 16:27:33', '2024-05-04 13:40:54', NULL, '2576', 'Sokodé', '6.2144688', '1.1983429', 1, 'RAS');
INSERT INTO `orders` (`id`, `user_id`, `order_number`, `sub_total`, `cart_id`, `status`, `total_amount`, `payment_method_id`, `first_name`, `last_name`, `phone`, `email`, `country`, `post_code`, `address1`, `address2`, `payment_status`, `coupon_code`, `created_at`, `updated_at`, `deleted_at`, `state`, `city`, `latitude`, `longitude`, `customer_id`, `note`) VALUES
	(3, 8, 'ORD-ZRDQWT4Y08/3', 1225200.00, 4, 'Nouvelle', 1325200.00, 4, 'Bola', 'Adeyemi', '+234648523617', 'boladeyemi@gestapp.com', 'MO', '820001', 'Ibadan street 9500', 'Gest House, Apt5', 'Impayé', 'CPN-45Z782DF3Q9', '2024-05-06 16:39:15', '2024-05-06 16:39:15', NULL, '2579', 'Lagos', '6.2144331', '1.1984344', 2, 'Can you ship it from your place to Nigeria ? It seems a little bit messed up but i hope everything will go well... 😅');

-- Listage de la structure de table raamshop_front. out_types
CREATE TABLE IF NOT EXISTS `out_types` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.out_types : ~4 rows (environ)
INSERT INTO `out_types` (`id`, `code`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, NULL, 'Vente', NULL, NULL, NULL);
INSERT INTO `out_types` (`id`, `code`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(2, NULL, 'Echantillon', NULL, NULL, NULL);
INSERT INTO `out_types` (`id`, `code`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(3, NULL, 'Administration', NULL, NULL, NULL);
INSERT INTO `out_types` (`id`, `code`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(4, NULL, 'Autre', NULL, NULL, NULL);

-- Listage de la structure de table raamshop_front. payment_methods
CREATE TABLE IF NOT EXISTS `payment_methods` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `method` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.payment_methods : ~7 rows (environ)
INSERT INTO `payment_methods` (`id`, `method`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, 'Especes', NULL, NULL, NULL);
INSERT INTO `payment_methods` (`id`, `method`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(2, 'Flooz', NULL, NULL, NULL);
INSERT INTO `payment_methods` (`id`, `method`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(3, 'Tmoney', NULL, NULL, NULL);
INSERT INTO `payment_methods` (`id`, `method`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(4, 'Virement Bancaire', NULL, NULL, NULL);
INSERT INTO `payment_methods` (`id`, `method`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(5, 'Cheque', NULL, NULL, NULL);
INSERT INTO `payment_methods` (`id`, `method`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(6, 'Credit', NULL, NULL, NULL);
INSERT INTO `payment_methods` (`id`, `method`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(7, 'Assurance', NULL, NULL, NULL);

-- Listage de la structure de table raamshop_front. permissions
CREATE TABLE IF NOT EXISTS `permissions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.permissions : ~4 rows (environ)
INSERT INTO `permissions` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`, `description`) VALUES
	(1, 'browse', NULL, NULL, NULL, NULL);
INSERT INTO `permissions` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`, `description`) VALUES
	(2, 'edit', NULL, NULL, NULL, NULL);
INSERT INTO `permissions` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`, `description`) VALUES
	(3, 'add', NULL, NULL, NULL, NULL);
INSERT INTO `permissions` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`, `description`) VALUES
	(4, 'delete', NULL, NULL, NULL, NULL);

-- Listage de la structure de table raamshop_front. permission_role
CREATE TABLE IF NOT EXISTS `permission_role` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `permission_id` bigint(20) unsigned DEFAULT NULL,
  `role_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `create` tinyint(1) DEFAULT NULL,
  `read` tinyint(1) DEFAULT NULL,
  `update` tinyint(1) DEFAULT NULL,
  `delete` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `permission_role_permission_id_foreign` (`permission_id`),
  KEY `permission_role_role_id_foreign` (`role_id`),
  CONSTRAINT `permission_role_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`),
  CONSTRAINT `permission_role_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.permission_role : ~8 rows (environ)
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`, `create`, `read`, `update`, `delete`) VALUES
	(1, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`, `create`, `read`, `update`, `delete`) VALUES
	(2, 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`, `create`, `read`, `update`, `delete`) VALUES
	(3, 3, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`, `create`, `read`, `update`, `delete`) VALUES
	(4, 4, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`, `create`, `read`, `update`, `delete`) VALUES
	(5, 1, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`, `create`, `read`, `update`, `delete`) VALUES
	(6, 2, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`, `create`, `read`, `update`, `delete`) VALUES
	(7, 3, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`, `create`, `read`, `update`, `delete`) VALUES
	(8, 4, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

-- Listage de la structure de table raamshop_front. permission_role_resources
CREATE TABLE IF NOT EXISTS `permission_role_resources` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `permission_id` bigint(20) unsigned NOT NULL,
  `role_id` bigint(20) unsigned NOT NULL,
  `resource` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `permission_role_resources_permission_id_foreign` (`permission_id`),
  KEY `permission_role_resources_role_id_foreign` (`role_id`),
  CONSTRAINT `permission_role_resources_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`),
  CONSTRAINT `permission_role_resources_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.permission_role_resources : ~0 rows (environ)

-- Listage de la structure de table raamshop_front. permission_table
CREATE TABLE IF NOT EXISTS `permission_table` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `permission_id` bigint(20) unsigned DEFAULT NULL,
  `table_id` bigint(20) unsigned DEFAULT NULL,
  `role_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `permission_table_permission_id_foreign` (`permission_id`),
  KEY `permission_table_table_id_foreign` (`table_id`),
  KEY `permission_table_role_id_foreign` (`role_id`),
  CONSTRAINT `permission_table_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`),
  CONSTRAINT `permission_table_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`),
  CONSTRAINT `permission_table_table_id_foreign` FOREIGN KEY (`table_id`) REFERENCES `tables` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=377 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.permission_table : ~376 rows (environ)
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, 1, 1, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(2, 2, 1, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(3, 3, 1, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(4, 4, 1, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(5, 1, 2, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(6, 2, 2, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(7, 3, 2, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(8, 4, 2, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(9, 1, 3, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(10, 2, 3, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(11, 3, 3, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(12, 4, 3, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(13, 1, 4, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(14, 2, 4, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(15, 3, 4, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(16, 4, 4, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(17, 1, 5, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(18, 2, 5, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(19, 3, 5, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(20, 4, 5, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(21, 1, 6, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(22, 2, 6, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(23, 3, 6, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(24, 4, 6, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(25, 1, 7, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(26, 2, 7, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(27, 3, 7, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(28, 4, 7, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(29, 1, 8, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(30, 2, 8, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(31, 3, 8, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(32, 4, 8, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(33, 1, 9, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(34, 2, 9, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(35, 3, 9, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(36, 4, 9, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(37, 1, 10, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(38, 2, 10, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(39, 3, 10, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(40, 4, 10, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(41, 1, 11, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(42, 2, 11, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(43, 3, 11, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(44, 4, 11, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(45, 1, 12, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(46, 2, 12, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(47, 3, 12, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(48, 4, 12, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(49, 1, 13, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(50, 2, 13, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(51, 3, 13, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(52, 4, 13, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(53, 1, 14, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(54, 2, 14, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(55, 3, 14, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(56, 4, 14, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(57, 1, 15, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(58, 2, 15, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(59, 3, 15, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(60, 4, 15, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(61, 1, 16, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(62, 2, 16, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(63, 3, 16, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(64, 4, 16, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(65, 1, 17, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(66, 2, 17, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(67, 3, 17, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(68, 4, 17, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(69, 1, 18, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(70, 2, 18, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(71, 3, 18, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(72, 4, 18, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(73, 1, 19, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(74, 2, 19, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(75, 3, 19, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(76, 4, 19, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(77, 1, 20, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(78, 2, 20, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(79, 3, 20, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(80, 4, 20, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(81, 1, 21, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(82, 2, 21, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(83, 3, 21, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(84, 4, 21, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(85, 1, 22, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(86, 2, 22, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(87, 3, 22, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(88, 4, 22, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(89, 1, 23, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(90, 2, 23, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(91, 3, 23, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(92, 4, 23, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(93, 1, 24, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(94, 2, 24, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(95, 3, 24, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(96, 4, 24, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(97, 1, 25, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(98, 2, 25, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(99, 3, 25, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(100, 4, 25, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(101, 1, 26, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(102, 2, 26, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(103, 3, 26, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(104, 4, 26, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(105, 1, 27, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(106, 2, 27, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(107, 3, 27, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(108, 4, 27, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(109, 1, 28, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(110, 2, 28, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(111, 3, 28, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(112, 4, 28, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(113, 1, 29, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(114, 2, 29, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(115, 3, 29, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(116, 4, 29, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(117, 1, 30, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(118, 2, 30, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(119, 3, 30, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(120, 4, 30, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(121, 1, 31, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(122, 2, 31, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(123, 3, 31, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(124, 4, 31, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(125, 1, 32, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(126, 2, 32, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(127, 3, 32, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(128, 4, 32, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(129, 1, 33, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(130, 2, 33, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(131, 3, 33, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(132, 4, 33, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(133, 1, 34, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(134, 2, 34, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(135, 3, 34, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(136, 4, 34, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(137, 1, 35, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(138, 2, 35, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(139, 3, 35, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(140, 4, 35, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(141, 1, 36, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(142, 2, 36, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(143, 3, 36, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(144, 4, 36, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(145, 1, 37, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(146, 2, 37, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(147, 3, 37, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(148, 4, 37, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(149, 1, 38, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(150, 2, 38, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(151, 3, 38, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(152, 4, 38, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(153, 1, 39, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(154, 2, 39, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(155, 3, 39, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(156, 4, 39, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(157, 1, 40, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(158, 2, 40, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(159, 3, 40, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(160, 4, 40, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(161, 1, 41, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(162, 2, 41, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(163, 3, 41, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(164, 4, 41, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(165, 1, 42, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(166, 2, 42, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(167, 3, 42, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(168, 4, 42, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(169, 1, 43, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(170, 2, 43, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(171, 3, 43, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(172, 4, 43, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(173, 1, 1, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(174, 2, 1, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(175, 3, 1, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(176, 4, 1, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(177, 1, 2, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(178, 2, 2, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(179, 3, 2, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(180, 4, 2, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(181, 1, 3, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(182, 2, 3, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(183, 3, 3, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(184, 4, 3, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(185, 1, 4, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(186, 2, 4, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(187, 3, 4, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(188, 4, 4, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(189, 1, 5, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(190, 2, 5, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(191, 3, 5, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(192, 4, 5, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(193, 1, 6, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(194, 2, 6, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(195, 3, 6, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(196, 4, 6, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(197, 1, 7, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(198, 2, 7, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(199, 3, 7, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(200, 4, 7, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(201, 1, 8, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(202, 2, 8, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(203, 3, 8, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(204, 4, 8, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(205, 1, 9, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(206, 2, 9, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(207, 3, 9, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(208, 4, 9, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(209, 1, 10, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(210, 2, 10, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(211, 3, 10, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(212, 4, 10, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(213, 1, 11, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(214, 2, 11, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(215, 3, 11, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(216, 4, 11, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(217, 1, 12, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(218, 2, 12, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(219, 3, 12, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(220, 4, 12, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(221, 1, 13, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(222, 2, 13, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(223, 3, 13, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(224, 4, 13, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(225, 1, 14, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(226, 2, 14, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(227, 3, 14, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(228, 4, 14, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(229, 1, 15, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(230, 2, 15, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(231, 3, 15, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(232, 4, 15, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(233, 1, 16, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(234, 2, 16, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(235, 3, 16, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(236, 4, 16, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(237, 1, 17, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(238, 2, 17, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(239, 3, 17, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(240, 4, 17, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(241, 1, 18, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(242, 2, 18, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(243, 3, 18, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(244, 4, 18, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(245, 1, 19, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(246, 2, 19, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(247, 3, 19, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(248, 4, 19, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(249, 1, 20, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(250, 2, 20, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(251, 3, 20, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(252, 4, 20, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(253, 1, 21, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(254, 2, 21, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(255, 3, 21, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(256, 4, 21, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(257, 1, 22, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(258, 2, 22, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(259, 3, 22, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(260, 4, 22, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(261, 1, 23, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(262, 2, 23, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(263, 3, 23, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(264, 4, 23, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(265, 1, 24, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(266, 2, 24, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(267, 3, 24, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(268, 4, 24, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(269, 1, 25, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(270, 2, 25, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(271, 3, 25, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(272, 4, 25, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(273, 1, 26, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(274, 2, 26, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(275, 3, 26, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(276, 4, 26, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(277, 1, 27, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(278, 2, 27, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(279, 3, 27, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(280, 4, 27, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(281, 1, 28, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(282, 2, 28, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(283, 3, 28, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(284, 4, 28, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(285, 1, 29, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(286, 2, 29, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(287, 3, 29, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(288, 4, 29, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(289, 1, 30, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(290, 2, 30, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(291, 3, 30, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(292, 4, 30, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(293, 1, 31, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(294, 2, 31, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(295, 3, 31, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(296, 4, 31, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(297, 1, 32, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(298, 2, 32, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(299, 3, 32, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(300, 4, 32, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(301, 1, 33, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(302, 2, 33, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(303, 3, 33, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(304, 4, 33, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(305, 1, 34, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(306, 2, 34, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(307, 3, 34, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(308, 4, 34, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(309, 1, 35, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(310, 2, 35, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(311, 3, 35, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(312, 4, 35, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(313, 1, 36, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(314, 2, 36, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(315, 3, 36, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(316, 4, 36, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(317, 1, 37, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(318, 2, 37, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(319, 3, 37, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(320, 4, 37, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(321, 1, 38, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(322, 2, 38, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(323, 3, 38, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(324, 4, 38, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(325, 1, 39, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(326, 2, 39, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(327, 3, 39, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(328, 4, 39, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(329, 1, 40, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(330, 2, 40, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(331, 3, 40, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(332, 4, 40, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(333, 1, 41, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(334, 2, 41, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(335, 3, 41, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(336, 4, 41, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(337, 1, 42, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(338, 2, 42, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(339, 3, 42, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(340, 4, 42, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(341, 1, 43, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(342, 2, 43, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(343, 3, 43, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(344, 4, 43, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(345, 1, 35, 2, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(346, 1, 5, 2, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(347, 1, 6, 2, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(348, 1, 8, 2, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(349, 2, 35, 2, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(350, 2, 5, 2, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(351, 2, 6, 2, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(352, 2, 8, 2, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(353, 3, 35, 2, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(354, 3, 5, 2, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(355, 3, 6, 2, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(356, 3, 8, 2, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(357, 4, 35, 2, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(358, 4, 5, 2, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(359, 4, 6, 2, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(360, 4, 8, 2, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(361, 1, 44, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(362, 2, 44, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(363, 3, 44, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(364, 4, 44, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(365, 1, 45, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(366, 2, 45, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(367, 3, 45, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(368, 4, 45, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(369, 1, 45, 2, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(370, 1, 44, 2, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(371, 3, 45, 3, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(372, 1, 46, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(373, 2, 46, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(374, 3, 46, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(375, 4, 46, 1, NULL, NULL, NULL);
INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(376, 1, 46, 2, NULL, NULL, NULL);

-- Listage des données de la table raamshop_front.personal_access_tokens : ~0 rows (environ)

-- Listage de la structure de table raamshop_front. printers
CREATE TABLE IF NOT EXISTS `printers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `printer_type_id` bigint(20) unsigned DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `port` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `printers_printer_type_id_foreign` (`printer_type_id`),
  CONSTRAINT `printers_printer_type_id_foreign` FOREIGN KEY (`printer_type_id`) REFERENCES `printer_types` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.printers : ~0 rows (environ)

-- Listage de la structure de table raamshop_front. printer_types
CREATE TABLE IF NOT EXISTS `printer_types` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.printer_types : ~6 rows (environ)
INSERT INTO `printer_types` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, 'Laser', NULL, NULL, NULL);
INSERT INTO `printer_types` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(2, 'Thermique', NULL, NULL, NULL);
INSERT INTO `printer_types` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(3, 'Jet d\'encre', NULL, NULL, NULL);
INSERT INTO `printer_types` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(4, 'Bulle d\'encre', NULL, NULL, NULL);
INSERT INTO `printer_types` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(5, 'Matricielle', NULL, NULL, NULL);
INSERT INTO `printer_types` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(6, 'LED', NULL, NULL, NULL);

-- Listage de la structure de table raamshop_front. products
CREATE TABLE IF NOT EXISTS `products` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `reference` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `tva` varchar(255) NOT NULL DEFAULT '0%',
  `expiration_date` date DEFAULT NULL,
  `security_stock` double NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `brand_id` bigint(20) unsigned NOT NULL,
  `discount` varchar(255) NOT NULL DEFAULT '0%',
  `is_featured` tinyint(1) NOT NULL DEFAULT 0,
  `summary` text NOT NULL,
  `status` enum('Disponible','Non Disponible','En Promotion','Arreté') NOT NULL DEFAULT 'Disponible',
  `selling_price` double NOT NULL DEFAULT 0,
  `in_detail_available_quantity` int(11) NOT NULL DEFAULT 0,
  `wholesale_available_quantity` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `products_brand_id_foreign` (`brand_id`),
  CONSTRAINT `products_brand_id_foreign` FOREIGN KEY (`brand_id`) REFERENCES `brands` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.products : ~19 rows (environ)
INSERT INTO `products` (`id`, `code`, `name`, `reference`, `image`, `tva`, `expiration_date`, `security_stock`, `created_at`, `updated_at`, `deleted_at`, `brand_id`, `discount`, `is_featured`, `summary`, `status`, `selling_price`, `in_detail_available_quantity`, `wholesale_available_quantity`) VALUES
	(1, NULL, 'Clair comme Clarisse', '12345678', 'storage/products/clair-comme-clarisse-1710505345.png', '10%', '2025-04-23', 10, '2024-03-15 11:22:26', '2024-03-15 13:10:06', '2024-03-15 13:10:06', 1, '0', 0, 'not null', 'Disponible', 0, 0, 0);
INSERT INTO `products` (`id`, `code`, `name`, `reference`, `image`, `tva`, `expiration_date`, `security_stock`, `created_at`, `updated_at`, `deleted_at`, `brand_id`, `discount`, `is_featured`, `summary`, `status`, `selling_price`, `in_detail_available_quantity`, `wholesale_available_quantity`) VALUES
	(2, NULL, 'Clair comme Clarisse', '12345678', 'storage/products/clair-comme-clarisse-1710511881.png', '10%', '2025-11-14', 15, '2024-03-15 13:11:21', '2024-03-15 13:16:53', '2024-03-15 13:16:53', 1, '0', 0, 'not null', 'Disponible', 0, 0, 0);
INSERT INTO `products` (`id`, `code`, `name`, `reference`, `image`, `tva`, `expiration_date`, `security_stock`, `created_at`, `updated_at`, `deleted_at`, `brand_id`, `discount`, `is_featured`, `summary`, `status`, `selling_price`, `in_detail_available_quantity`, `wholesale_available_quantity`) VALUES
	(3, '000003', 'Clair comme Clarisse', '12345678', 'storage/products/clair-comme-clarisse-1711549312.jpg', '10%', NULL, 0, '2024-03-15 13:17:48', '2024-04-09 11:41:46', '2024-04-09 11:41:46', 1, '0', 0, 'not null', 'Disponible', 0, 0, 0);
INSERT INTO `products` (`id`, `code`, `name`, `reference`, `image`, `tva`, `expiration_date`, `security_stock`, `created_at`, `updated_at`, `deleted_at`, `brand_id`, `discount`, `is_featured`, `summary`, `status`, `selling_price`, `in_detail_available_quantity`, `wholesale_available_quantity`) VALUES
	(4, '000004', 'simple comme simplice', 'P-000004', 'storage/products/simple-comme-simplice-1711540414.png', '0%', NULL, 30, '2024-03-27 10:53:34', '2024-04-09 11:41:46', '2024-04-09 11:41:46', 1, '12%', 0, 'Le produit qu&#039;il vous faut pour devenir aussi simple que Simplice !', 'Disponible', 13000, 0, 0);
INSERT INTO `products` (`id`, `code`, `name`, `reference`, `image`, `tva`, `expiration_date`, `security_stock`, `created_at`, `updated_at`, `deleted_at`, `brand_id`, `discount`, `is_featured`, `summary`, `status`, `selling_price`, `in_detail_available_quantity`, `wholesale_available_quantity`) VALUES
	(5, '000005', 'Franc comme François', 'P000005', 'storage/products/franc-comme-francois-1711556079.png', '0%', NULL, 40, '2024-03-27 15:14:39', '2024-04-09 11:41:57', '2024-04-09 11:41:57', 1, '10%', 0, 'Avec ce produit, vous serez aussi franc que François', 'Disponible', 750, 0, 0);
INSERT INTO `products` (`id`, `code`, `name`, `reference`, `image`, `tva`, `expiration_date`, `security_stock`, `created_at`, `updated_at`, `deleted_at`, `brand_id`, `discount`, `is_featured`, `summary`, `status`, `selling_price`, `in_detail_available_quantity`, `wholesale_available_quantity`) VALUES
	(6, '000001', 'Quinoa Gel Cleanser', 'P000001', 'storage/products/quinoa-gel-cleanser-1712674414.jpg', '0%', '2029-04-25', 20, '2024-04-09 12:53:34', '2024-04-09 12:53:34', NULL, 1, '12%', 0, 'Un nettoyant doux qui élimine le maquillage et les pores en une seule étape, tout en offrant un lavage doux et hydratant au pH naturel de votre peau. La combinaison de quinoa et de nutriments sains élimine les toxines de l&#039;environnement pour révéler une peau saine et vivante.\r\n\r\nListe complète des ingrédients\r\nEau, Decyl Glucoside, Sodium Cocoyl Glutamate, Chenopodium Quinoa Seed Extract, Glycerin, Sodium Lauroyl Glutamate, Betaine, Glycine Soja (Soybean Oil), Melaleuca Alternifolia (Tea Tree) Extract, Chlorphenesin, Hydroxyacetophenone, Ethylhexylglycerin, Extrait de feuille de Camellia Sinensis, extrait de Humulus Lupulus (houblon), extrait d&#039;Ocimum Tenuiflorum, extrait de Centella Asiatica, extrait de fleur de Calendula Officinalis, extrait de fruit de Prunus Amygdalus Dulcis (amande douce), acide citrique, huile de Geranium Maculatum, allantoïne.', 'Disponible', 15000, 300, 0);
INSERT INTO `products` (`id`, `code`, `name`, `reference`, `image`, `tva`, `expiration_date`, `security_stock`, `created_at`, `updated_at`, `deleted_at`, `brand_id`, `discount`, `is_featured`, `summary`, `status`, `selling_price`, `in_detail_available_quantity`, `wholesale_available_quantity`) VALUES
	(7, '000007', 'Facetheory Clarifying', 'P000007', 'storage/products/facetheory-clarifying-1712674918.jpg', '0%', '2026-08-11', 0, '2024-04-09 13:01:58', '2024-04-09 13:01:58', NULL, 1, '5%', 1, 'Notre crème nettoyante clarifiante la plus vendue contient un puissant trio d&#039;acides à pH bas pour les peaux grasses, congestionnées et sujettes aux imperfections.\r\nContient 2 % d&#039;acide salicylique, qui pénètre profondément dans les pores pour éliminer les impuretés et réduire l&#039;apparence des points noirs.\r\nFormulé avec de l&#039;acide glycolique (4 %) et de l&#039;acide lactique (1 %) pour exfolier la peau, éliminer les cellules mortes et améliorer la texture et l&#039;aspect général de la peau.\r\nL&#039;acide salicylique (2 %) pénètre profondément dans les pores.\r\nSans parabènes, silicones, PEG, SLS, SLES et huiles minérales.\r\nVégétalien et sans cruauté. \r\nFabriqué au Royaume-Uni.\r\nLes produits Facetheory contiennent une forte concentration d&#039;actifs, de sorte que seule une petite quantité est nécessaire à chaque utilisation. 180ml durent généralement deux mois.\r\nNe pas utiliser si vous avez moins de 18 ans ou si vous êtes enceinte. \r\nDemandez conseil à votre médecin.', 'Disponible', 12500, 0, 0);
INSERT INTO `products` (`id`, `code`, `name`, `reference`, `image`, `tva`, `expiration_date`, `security_stock`, `created_at`, `updated_at`, `deleted_at`, `brand_id`, `discount`, `is_featured`, `summary`, `status`, `selling_price`, `in_detail_available_quantity`, `wholesale_available_quantity`) VALUES
	(8, '000008', 'B-BOOST 10% Niacinamide Serum', 'P000008', 'storage/products/b-boost-10-niacinamide-serum-1712675404.jpg', '0%', NULL, 0, '2024-04-09 13:10:04', '2024-04-09 13:10:04', NULL, 1, '0%', 0, 'Découvrez la puissance de notre sérum à 10 % de niacinamide, une formule puissante conçue pour transformer votre peau. Ce sérum associe les bienfaits de la niacinamide, de l&#039;extrait de centella asiatica et d&#039;autres ingrédients soigneusement sélectionnés pour répondre à de multiples préoccupations cutanées.\r\n\r\nNotre sérum régule efficacement la production de sébum, minimise l&#039;apparence des pores et améliore la texture de la peau, pour un teint plus lisse et plus raffiné. Le niacinamide apaise et calme la peau, réduisant les rougeurs et les irritations.\r\n\r\nGrâce à l&#039;ajout de filtrat de sécrétion d&#039;escargot et de glycérine, ce sérum procure une hydratation intense, laissant votre peau rebondie, souple et profondément hydratée. Le niacinamide aide également à estomper les taches sombres, l&#039;hyperpigmentation et les cicatrices d&#039;acné, révélant ainsi un teint plus lumineux et plus uniforme.', 'Disponible', 23800, 0, 0);
INSERT INTO `products` (`id`, `code`, `name`, `reference`, `image`, `tva`, `expiration_date`, `security_stock`, `created_at`, `updated_at`, `deleted_at`, `brand_id`, `discount`, `is_featured`, `summary`, `status`, `selling_price`, `in_detail_available_quantity`, `wholesale_available_quantity`) VALUES
	(9, '000009', 'JUMISO All Day Vitamin', 'P000009', 'storage/products/jumiso-all-day-vitamin-1712675731.jpg', '7%', '2026-06-09', 25, '2024-04-09 13:15:32', '2024-04-09 14:46:32', NULL, 5, '0%', 0, 'Cette version améliorée du sérum culte à la vitamine C Drop The Vita C présente une texture légère et non collante qui pénètre rapidement la peau. Enrichi en extraits d’arbre de vitamine et de centella asiatica pour apaiser, en acide hyaluronique pour hydrater la peau, et en extrait de camomille pour réguler la production de sébum. Convient à tous les types de peaux.\r\n\r\nHippophae Rhamnoides (Sea Buckthorn) Fruit Extract (86.14%), Methylpropanediol, Glycerin, Niacinamide, Dipropylene Glycol, Sodium Hyaluronate, PEG-Hydrogenated Castor Oil, Centella Asiatica (Gotu Kola) Extract, Polygonum Cuspidatum (Japanese Knotweed) Root Extract, Scutellaria Baicalensis (Baikal Skullcap) Root Extract, Camellia Sinensis (Green Tea) Leaf Extract, Glycyrrhiza Glabra (Licorice) Root Extract, Chamomilla Recutita (Matricaria) Flower Extract, Rosmarinus Officinalis (Rosemary) Leaf Extract, Panthenol, Betaine, Ascorbic Acid, Hydroxyacetophenone, Pentylene Glycol, Caprylyl Glycol, Butylene Glycol, Chlorphenesin, Carbomer, Arginine, Disodium EDTA, Pelargonium Graveolens (Geranium) Flower Oil, Cymbopogon Martini (Palmarosa) Oil, Cananga Odorata (Ylang Ylang) Oil, Citrus Aurantium Bergamia (Bergamot) Peel Oil, Rosa Damascena (Rose) Flower Oil\r\n\r\nNB : Les ingrédients peuvent changer à la discrétion du fabricant. Pour connaître la liste complète et à jour des ingrédients, veuillez vous référer au packaging.\r\n\r\nDétails\r\nInformations produit\r\nCruelty free :	Oui\r\nPays d&#039;importation :	Corée du Sud\r\nRéférence :	1068569767\r\nCe sérum à la vitamine C riche en antioxydants illumine et restaure l’équilibre naturel de la peau, tout en la protégeant du stress oxydatif tout au long de la journée.Le sérum illuminateur et rééquilibrant All Day Vitamin est la nouvelle version du sérum à la vitamine C Drop The Vita C.\r\nBienfaits et avantages :\r\nGrâce à sa vitamine C pure et à son adénosine antioxydantes, ce sérum réduit les ridules, pour une peau visiblement plus belle.\r\nConvient à tous les types de peaux.\r\n* Lors de l’utilisation de ce sérum, vous pouvez ressentir une brève sensation de chaleur au moment de l’absorption de la vitamine pure par votre peau.\r\nUtilisation :\r\nÀ utiliser lors de votre routine du soir. Après le nettoyage, appliquez uniformément une petite quantité de produit sur votre visage.\r\nÀ propos de la marque : JUMISO\r\nFiliale de HELLOSKIN, JUMISO propose des masques et d’autres soins de la peau qui mettent en premier lieu l’accent sur la satisfaction du consommateur. Le nom de la marque vient du coréen « ju », donner, et « miso », sourire. JUMISO fabrique tous ses produits en Corée, notamment ses produits stars : le masque nourrissant Rich Nourishment Mask, le masque éclaircissant First Skin Lightening Mask, le masque apaisant Whoa Whoa Soothing Mask et le Water Splash Mask.', 'Disponible', 35000, 0, 0);
INSERT INTO `products` (`id`, `code`, `name`, `reference`, `image`, `tva`, `expiration_date`, `security_stock`, `created_at`, `updated_at`, `deleted_at`, `brand_id`, `discount`, `is_featured`, `summary`, `status`, `selling_price`, `in_detail_available_quantity`, `wholesale_available_quantity`) VALUES
	(10, '000010', 'Nineless A-Control', 'P000010', 'storage/products/nineless-a-control-1712682049.jpg', '0%', NULL, 0, '2024-04-09 15:00:49', '2024-04-09 15:00:49', NULL, 1, '0%', 1, 'Voici notre sérum azélaïque à 10 %, une formule puissante qui aide à éclaircir et à unifier le teint de la peau tout en réduisant l&#039;apparence des imperfections et des ridules. Ce sérum est parfait pour les personnes ayant une peau sujette à l&#039;acné ou hyperpigmentée et convient à tous les types de peau.\r\n\r\nNotre sérum contient un mélange puissant d&#039;extrait de centella asiatica, d&#039;acide azélaïque et de niacinamide, qui agissent ensemble pour apaiser la peau irritée.\r\n\r\nL&#039;ajout de filtrat de sécrétion d&#039;escargot aide à hydrater et à promouvoir la production de collagène, tandis que l&#039;acide lactique exfolie en douceur et améliore la texture de la peau.\r\n\r\nNotre sérum est exempt de parabènes, de sulfates et de parfums artificiels, ce qui vous donne l&#039;assurance d&#039;utiliser un produit sûr et efficace. Avec une utilisation continue, notre sérum azélaïque à 10% laissera votre peau radieuse, claire et saine.', 'Disponible', 12500, 0, 0);
INSERT INTO `products` (`id`, `code`, `name`, `reference`, `image`, `tva`, `expiration_date`, `security_stock`, `created_at`, `updated_at`, `deleted_at`, `brand_id`, `discount`, `is_featured`, `summary`, `status`, `selling_price`, `in_detail_available_quantity`, `wholesale_available_quantity`) VALUES
	(11, '000011', 'AHA.BHA.PHA', 'P000011', 'storage/products/ahabhapha-1712734225.jpg', '0%', '2026-08-03', 0, '2024-04-10 05:30:27', '2024-04-24 15:26:35', '2024-04-24 15:26:35', 6, '0%', 0, 'Découvrez les trois ingrédients qui changent et sauvent votre peau en difficulté - AHA BHA PHA. Fréquemment appelés «trio exfoliant» dans une routine de soin de la peau, ces trois ingrédients de soin servent à des fins similaires mais ciblées pour vos problèmes de peau. Les AHA, connus sous le nom d&#039;acides alpha-hydroxy, sont des acides solubles dans l&#039;eau fabriqués à partir de fruits sucrés. Ils aident à décoller la surface de votre peau afin que de nouvelles cellules cutanées plus uniformément pigmentées puissent se générer pour révéler un teint plus éclatant. Les BHA, en revanche, sont les meilleurs pour les peaux à tendance acnéique et peuvent pénétrer davantage dans la peau pour contrôler la production de sébum et d&#039;huile. Les PHA agissent en exfoliant les cellules mortes de la peau à la surface comme les AHA et sont idéales pour les peaux sensibles plus sujettes aux irritations. La combinaison de l&#039;AHA, du BHA et du PHA offre un large éventail d&#039;avantages pour la peau qui aide à améliorer la texture et le teint de votre peau.', 'Disponible', 27000, 60, 0);
INSERT INTO `products` (`id`, `code`, `name`, `reference`, `image`, `tva`, `expiration_date`, `security_stock`, `created_at`, `updated_at`, `deleted_at`, `brand_id`, `discount`, `is_featured`, `summary`, `status`, `selling_price`, `in_detail_available_quantity`, `wholesale_available_quantity`) VALUES
	(12, '000012', 'Ginseng Cleansing Oil', 'P000012', 'storage/products/ginseng-cleansing-oil-1712734534.jpg', '0%', '2027-07-29', 20, '2024-04-10 05:35:34', '2024-04-10 05:35:34', NULL, 1, '0%', 0, 'Enrichie à 50 % en huile de soja et à 0,1 % en huile de graines de ginseng, pour nettoyer votre visage tout en douceur.\r\nAbsorbe et dissout tout en douceur les résidus de maquillage et les impuretés incrustées dans les pores, tout en lissant le grain de peau en un instant.\r\nProtège la peau des agressions extérieures, et hydrate la peau intensément et en profondeur.\r\nSa texture légère de type huile liquide s’applique sans effort, et sans fini gras.\r\nSon huile de graines de ginseng présente une subtile senteur de plantes, pour faire de l&#039;étape nettoyage un pur moment de relaxation.\r\nUtilisation :\r\n1. Appliquez une quantité appropriée de produit sur visage sec, et massez délicatement en effectuant des mouvements circulaires jusqu&#039;à dissolution complète du maquillage et des impuretés.\r\n2. Rincez soigneusement à l’eau tiède.\r\n\r\nÀ propos de la marque : Beauty of Joseon\r\nRéputée pour sa crème Dynasty, la marque coréenne Beauty of Joseon emploie des plantes orientales raffinées pour créer des soins ciblant les femmes de la vingtaine à la quarantaine. La marque puise son inspiration dans une encyclopédie du 19e siècle décrivant les secrets cosmétiques des femmes de la haute société coréenne de l’époque. Avec ses produits entièrement fabriqués en Corée, Beauty of Joseon révèle la beauté naturelle de la peau en améliorant son état général et en résolvant des problèmes de base tels qu’une peau rêche ou déshydratée, ou un teint terne.', 'Disponible', 22000, 0, 0);
INSERT INTO `products` (`id`, `code`, `name`, `reference`, `image`, `tva`, `expiration_date`, `security_stock`, `created_at`, `updated_at`, `deleted_at`, `brand_id`, `discount`, `is_featured`, `summary`, `status`, `selling_price`, `in_detail_available_quantity`, `wholesale_available_quantity`) VALUES
	(13, '000013', 'IN\'OYA', 'P000013', 'storage/products/inoya-1712734843.jpg', '0%', '2026-01-20', 10, '2024-04-10 05:40:43', '2024-05-03 13:34:04', NULL, 2, '0%', 1, 'Mon Lait Corps « Unifiant Hydratant » MEL’OYA® Lite est le soin corporel parfait pour les peaux noires, mates et métissées. Formulé avec des actifs nourrissants, protecteurs et relipidants, il permet d&#039;hydrater la peau durant 24 heures et de renforcer sa barrière cutanée.\r\n\r\nIl contient également des actifs unifiant issus de la technologie brevetée MEL’OYA® Lite qui permettent d&#039;illuminer et de révéler l&#039;éclat naturel de la peau sans l&#039;éclaircir.\r\n\r\nIl contribue ainsi à estomper tous types de taches pigmentaires. En plus de pénétrer rapidement dans la peau sans laisser de film gras, il laisse la peau douce, lumineuse et soyeuse avec un délicat parfum poudré. Sa contenance est de 400mL pour permettre une utilisation quotidienne durant plusieurs semaines.\r\n\r\nQUAND Matin et/ou soir sur peau nettoyée\r\n\r\nBÉNÉFICES Peau douce, lumineuse et soyeuse', 'Disponible', 25000, 30, 4);
INSERT INTO `products` (`id`, `code`, `name`, `reference`, `image`, `tva`, `expiration_date`, `security_stock`, `created_at`, `updated_at`, `deleted_at`, `brand_id`, `discount`, `is_featured`, `summary`, `status`, `selling_price`, `in_detail_available_quantity`, `wholesale_available_quantity`) VALUES
	(14, '000014', 'TOCOBO', 'P000014', 'storage/products/tocobo-1712735050.jpg', '0%', '2027-08-30', 25, '2024-04-10 05:44:10', '2024-04-10 05:44:10', NULL, 1, '0%', 1, 'La marque coréenne et végane de soin du visage TOCOBO s&#039;attache à développer des produits efficaces, pour vous aider à révéler votre beauté intérieure. TOCOBO met l&#039;accent sur la clarté, la modernité et la satisfaction dans le développement de ses produits, en restant toujours transparente sur les ingrédients utilisés dans ses formules, et en garantissant que ses produits suivent les dernières tendances beauté tout en étant à la hauteur des attentes des client.e.s. Les produits les plus populaires de la marque incluent notamment sa crème solaire aqueuse et bio FPS 50 PA++++, un produit hybride entre le sérum et la crème solaire, qui offre un effet apaisant en plus de sa protection solaire. Son stick solaire doux Cotton Soft FPS 50 PA++++, qui protège et hydrate la peau, est également très apprécié. Enfin, n&#039;oublions pas de mentionner également son tonique aux AHA, BHA et citron, muni d&#039;un capuchon adorable en forme de citron. Tous les produits de chez TOCOBO sont entièrement fabriqués en Corée.', 'Disponible', 52000, 0, 0);
INSERT INTO `products` (`id`, `code`, `name`, `reference`, `image`, `tva`, `expiration_date`, `security_stock`, `created_at`, `updated_at`, `deleted_at`, `brand_id`, `discount`, `is_featured`, `summary`, `status`, `selling_price`, `in_detail_available_quantity`, `wholesale_available_quantity`) VALUES
	(15, '000015', 'REVOX', 'P000015', 'storage/products/revox-1712933631.jpg', '0%', '2025-07-22', 15, '2024-04-12 12:53:52', '2024-04-12 12:53:52', NULL, 1, '0%', 0, 'REVOX B77 JUST ALPHA ARBUTIN 2% + HA est un sérum éclaircissant pour le visage et le cou. L&#039;alpha-arbutine purifiée est un agent éclaircissant doux mais très puissant. Dans sa concentration élevée de 2%, il agit efficacement pour réduire la production de pigments de la peau, prévenir une nouvelle pigmentation et unifier le teint. Cette formule avancée est enrichie en acide hyaluronique pour un conditionnement et un confort supplémentaires de la peau. Le produit cible les rougeurs post-imperfections, les taches de vieillesse et de soleil, ainsi que les cicatrices d&#039;acné pigmentées. Il convient à tous les types de peau. Combiner avec REVOX B77 JUST Vitamine C 20% pour une protection antioxydante, et avec REVOX B77 JUST Acide Hyaluronique 5% ou REVOX B77 JUST Huile d&#039;Argan 100% pour l&#039;hydratation.', 'Disponible', 14500, 0, 0);
INSERT INTO `products` (`id`, `code`, `name`, `reference`, `image`, `tva`, `expiration_date`, `security_stock`, `created_at`, `updated_at`, `deleted_at`, `brand_id`, `discount`, `is_featured`, `summary`, `status`, `selling_price`, `in_detail_available_quantity`, `wholesale_available_quantity`) VALUES
	(16, '000016', 'ANUA HeartLeaf 77%', 'P000016', 'storage/products/anua-heartleaf-77-1712933962.jpg', '0%', NULL, 20, '2024-04-12 12:59:22', '2024-04-12 12:59:22', NULL, 1, '0%', 0, 'Anua estime qu’une peau saine ne dépend pas uniquement des produits de soins de la peau, mais aussi d’un esprit détendu et d’un mode de vie adapté. La marque se concentre sur le choix d’ingrédients purs et biologiques pour maximiser l’efficacité de ses soins et minimiser les effets nocifs sur la peau. Ses produits respectueux de l’environnement et durables sont fabriqués à 100 % en Corée et conçus avec des emballages simples. Ses best-sellers incluent le toner apaisant Heartleaf 77% Soothing Toner, l’ampoule apaisante Heartleaf 80% Soothing Ampoule et la crème solaire 5-Zero Mild Sun Cream.', 'Disponible', 17000, 0, 0);
INSERT INTO `products` (`id`, `code`, `name`, `reference`, `image`, `tva`, `expiration_date`, `security_stock`, `created_at`, `updated_at`, `deleted_at`, `brand_id`, `discount`, `is_featured`, `summary`, `status`, `selling_price`, `in_detail_available_quantity`, `wholesale_available_quantity`) VALUES
	(17, '000017', 'AHA.BHA.PHA', 'P000017', 'storage/products/ahabhapha-1713980478.jpg', '0%', NULL, 10, '2024-04-24 15:41:18', '2024-04-24 15:41:18', NULL, 6, '0%', 0, 'Découvrez les trois ingrédients qui changent et sauvent votre peau en difficulté - AHA BHA PHA. Fréquemment appelés «trio exfoliant» dans une routine de soin de la peau, ces trois ingrédients de soin servent à des fins similaires mais ciblées pour vos problèmes de peau. Les AHA, connus sous le nom d&amp;#039;acides alpha-hydroxy, sont des acides solubles dans l&amp;#039;eau fabriqués à partir de fruits sucrés. Ils aident à décoller la surface de votre peau afin que de nouvelles cellules cutanées plus uniformément pigmentées puissent se générer pour révéler un teint plus éclatant. Les BHA, en revanche, sont les meilleurs pour les peaux à tendance acnéique et peuvent pénétrer davantage dans la peau pour contrôler la production de sébum et d&amp;#039;huile. Les PHA agissent en exfoliant les cellules mortes de la peau à la surface comme les AHA et sont idéales pour les peaux sensibles plus sujettes aux irritations. La combinaison de l&amp;#039;AHA, du BHA et du PHA offre un large éventail d&amp;#039;avantages pour la peau qui aide à améliorer la texture et le teint de votre peau.', 'Disponible', 27000, 60, 60);
INSERT INTO `products` (`id`, `code`, `name`, `reference`, `image`, `tva`, `expiration_date`, `security_stock`, `created_at`, `updated_at`, `deleted_at`, `brand_id`, `discount`, `is_featured`, `summary`, `status`, `selling_price`, `in_detail_available_quantity`, `wholesale_available_quantity`) VALUES
	(18, '000018', 'Discoloration Correcting Body Treatment', 'P000018', 'storage/products/discoloration-correcting-body-treatment-1716481577.jpg', '2%', '2026-06-16', 15, '2024-05-23 14:26:17', '2024-05-23 14:32:28', NULL, 8, '1%', 0, 'Cette crème pour le corps contient une forme avancée d&#039;acide tranexamique pour améliorer l&#039;apparence des tâches brunes, des taches de vieillesse, de l&#039;hyperpigmentation, des dommages causés par le soleil et du teint irrégulier. Léger et non gras, il pénètre instantanément pour aider à estomper les décolorations tenaces et révéler un teint uniforme.', 'Disponible', 10000, 100, 1);
INSERT INTO `products` (`id`, `code`, `name`, `reference`, `image`, `tva`, `expiration_date`, `security_stock`, `created_at`, `updated_at`, `deleted_at`, `brand_id`, `discount`, `is_featured`, `summary`, `status`, `selling_price`, `in_detail_available_quantity`, `wholesale_available_quantity`) VALUES
	(19, '000019', 'Retinol Intense', 'P000019', 'storage/products/retinol-intense-1716553430.jpg', '2%', '2027-02-24', 10, '2024-05-23 14:40:33', '2024-05-24 10:23:50', NULL, 6, '0%', 0, 'Combattez les ridules, les cernes et les signes de l&#039;âge avec cette puissante crème contour des yeux enrichie en niacinamide illuminateur, ainsi qu&#039;en acide hyaluronique et en panthénol pour hydrater la peau en profondeur. Pour un résultat optimal, appliquez le produit sur le coin interne de vos yeux, avant de l&#039;étirer vers l&#039;extérieur.', 'Disponible', 18000, 30, 30);

-- Listage de la structure de table raamshop_front. product_details
CREATE TABLE IF NOT EXISTS `product_details` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `product_id` bigint(20) unsigned DEFAULT NULL,
  `data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`data`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_details_product_id_foreign` (`product_id`),
  CONSTRAINT `product_details_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.product_details : ~6 rows (environ)
INSERT INTO `product_details` (`id`, `product_id`, `data`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, 7, '[{"000001":{"instructions":"sdgs"}},{"000001":{"name":"jkm\\u00f9","email":"sgjo","phone":"ssdggs","message":"hsjhfsd","reply":{"name":"jkm\\u00f9","email":"sgjo","phone":"ssdggs","message":"hsjhfsd","reply":[]}}},{"000001":{"name":"FNU LNU","email":null,"phone":null,"rating":"5","rev":null}}]', '2024-05-24 17:51:41', '2024-05-24 17:51:41', '2024-05-26 10:30:58');
INSERT INTO `product_details` (`id`, `product_id`, `data`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(2, 7, '[{"000002":{"instructions":"sdgs"}},{"000002":{"name":"jkm\\u00f9","email":"sgjo","phone":"ssdggs","message":"hsjhfsd","reply":{"name":"jkm\\u00f9","email":"sgjo","phone":"ssdggs","message":"hsjhfsd","reply":[]}}},{"000002":{"name":"FNU LNU","email":null,"phone":null,"rating":"5","rev":null}}]', '2024-05-24 17:52:16', '2024-05-24 17:52:16', '2024-05-26 10:31:01');
INSERT INTO `product_details` (`id`, `product_id`, `data`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(3, 7, '[{"000003":{"instructions":"sdgs"}},{"000003":{"name":"jkm\\u00f9","email":"sgjo","phone":"ssdggs","message":"hsjhfsd","reply":{"name":"jkm\\u00f9","email":"sgjo","phone":"ssdggs","message":"hsjhfsd","reply":[]}}},{"000003":{"name":"FNU LNU","email":null,"phone":null,"rating":"5","rev":null}}]', '2024-05-24 18:12:07', '2024-05-24 18:12:07', '2024-05-26 10:31:03');
INSERT INTO `product_details` (`id`, `product_id`, `data`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(4, 7, '{"reviews":{"000001":{"name":"John Doe","email":"johndoe@gestapp.com","phone":"+22899887766","rating":"5","rev":"Ce produit est une merveille ! Je le recommande \\u00e0 tous ceux et celles qui ont les peaux grasses."},"000002":{"name":"Bola Adeyemi","email":"boladeyemi@gestapp.com","phone":"+234940215362","rating":"5","rev":"Honn\\u00eatement, ce produit est on ne peut plus parfait \\ud83d\\udc4cDepuis que j\'ai commenc\\u00e9 \\u00e0 l\'utiliser, j\'ai observ\\u00e9 une nette am\\u00e9lioration."},"000003":{"name":"Mary-Jane Kwami","email":"mjkwami@gestapp.com","phone":"+234940215362","rating":"3","rev":"This product is good, but i think it doesn\'t suit my skin beacause since i\'m using it boils keep appearing on my face..."}},"comments":{"000001":{"name":"Mary-Jane Kwami","email":"mjkwami@gestapp.com","phone":"+234940215362","message":"You\'re doing a good work! Keep up with it \\ud83d\\ude01","date":"2024-05-27T11:49:22.273061Z","reply_to":null},"000002":{"name":"John Doe","email":"johndoe@gestapp.com","phone":"+22892458726","message":"L\'une des choses que j\'aime chez vous, c\'est que vos prix sont tr\\u00e8s comp\\u00e9titifs, en plus de votre service impeccable ! Bravo","date":"2024-05-27T14:29:40.536616Z","reply_to":null},"000003":{"name":"Bola Adeyemi","email":"boladeyemi@gestapp.com","phone":"+22765458726","message":"Totally agree with you \\ud83d\\udc4d","date":"2024-05-27T14:58:09.134408Z","reply_to":"000002"}},"usage":[]}', '2024-05-26 08:32:44', '2024-05-27 12:58:09', NULL);
INSERT INTO `product_details` (`id`, `product_id`, `data`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(5, 8, '{"reviews":[],"comments":{"000001":{"name":"John Doe","email":"johndoe@gestapp.com","phone":"+22892458726","message":"Le B-Boost de Nineless Essentials \\u00e9tait le produit qu\'il me fallait !","date":"2024-05-27T15:53:37.155556Z","reply_to":null}},"usage":[]}', '2024-05-27 13:53:37', '2024-05-27 13:53:37', NULL);
INSERT INTO `product_details` (`id`, `product_id`, `data`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(6, 9, '{"reviews":{"000001":{"name":"Bola Adeyemi","email":"boladeyemi@gestapp.com","phone":"+234940215362","rating":"5","rev":"Super produit ! La Cor\\u00e9e ne pouvait pas nous faire meilleur cadeau \\ud83d\\ude0a"}},"comments":[],"usage":[]}', '2024-05-27 14:02:49', '2024-05-27 14:02:49', NULL);

-- Listage de la structure de table raamshop_front. product_unit_measure
CREATE TABLE IF NOT EXISTS `product_unit_measure` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `product_id` bigint(20) unsigned DEFAULT NULL,
  `unit_measure_id` bigint(20) unsigned DEFAULT NULL,
  `unit_price` double NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_unit_measure_product_id_foreign` (`product_id`),
  KEY `product_unit_measure_unit_measure_id_foreign` (`unit_measure_id`),
  CONSTRAINT `product_unit_measure_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`),
  CONSTRAINT `product_unit_measure_unit_measure_id_foreign` FOREIGN KEY (`unit_measure_id`) REFERENCES `unit_measures` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.product_unit_measure : ~21 rows (environ)
INSERT INTO `product_unit_measure` (`id`, `product_id`, `unit_measure_id`, `unit_price`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, 1, 5, 0, NULL, NULL, NULL);
INSERT INTO `product_unit_measure` (`id`, `product_id`, `unit_measure_id`, `unit_price`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(2, 2, 5, 2000, NULL, NULL, NULL);
INSERT INTO `product_unit_measure` (`id`, `product_id`, `unit_measure_id`, `unit_price`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(3, 3, 5, 2000, NULL, NULL, NULL);
INSERT INTO `product_unit_measure` (`id`, `product_id`, `unit_measure_id`, `unit_price`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(4, 4, 7, 13000, NULL, NULL, NULL);
INSERT INTO `product_unit_measure` (`id`, `product_id`, `unit_measure_id`, `unit_price`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(5, 5, 9, 750, NULL, NULL, NULL);
INSERT INTO `product_unit_measure` (`id`, `product_id`, `unit_measure_id`, `unit_price`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(6, 5, 1, 7500, NULL, NULL, NULL);
INSERT INTO `product_unit_measure` (`id`, `product_id`, `unit_measure_id`, `unit_price`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(7, 6, 5, 15000, NULL, NULL, NULL);
INSERT INTO `product_unit_measure` (`id`, `product_id`, `unit_measure_id`, `unit_price`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(8, 7, 7, 12500, NULL, NULL, NULL);
INSERT INTO `product_unit_measure` (`id`, `product_id`, `unit_measure_id`, `unit_price`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(9, 8, 5, 23800, NULL, NULL, NULL);
INSERT INTO `product_unit_measure` (`id`, `product_id`, `unit_measure_id`, `unit_price`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(10, 9, 5, 35000, NULL, NULL, NULL);
INSERT INTO `product_unit_measure` (`id`, `product_id`, `unit_measure_id`, `unit_price`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(11, 10, 5, 12500, NULL, NULL, NULL);
INSERT INTO `product_unit_measure` (`id`, `product_id`, `unit_measure_id`, `unit_price`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(12, 10, 1, 150000, NULL, NULL, NULL);
INSERT INTO `product_unit_measure` (`id`, `product_id`, `unit_measure_id`, `unit_price`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(14, 12, 8, 22000, NULL, NULL, NULL);
INSERT INTO `product_unit_measure` (`id`, `product_id`, `unit_measure_id`, `unit_price`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(15, 13, 7, 25000, NULL, NULL, NULL);
INSERT INTO `product_unit_measure` (`id`, `product_id`, `unit_measure_id`, `unit_price`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(16, 13, 4, 100000, NULL, NULL, NULL);
INSERT INTO `product_unit_measure` (`id`, `product_id`, `unit_measure_id`, `unit_price`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(17, 14, 7, 52000, NULL, NULL, NULL);
INSERT INTO `product_unit_measure` (`id`, `product_id`, `unit_measure_id`, `unit_price`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(18, 15, 5, 14500, NULL, NULL, NULL);
INSERT INTO `product_unit_measure` (`id`, `product_id`, `unit_measure_id`, `unit_price`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(19, 16, 8, 17000, NULL, NULL, NULL);
INSERT INTO `product_unit_measure` (`id`, `product_id`, `unit_measure_id`, `unit_price`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(20, 17, 5, 27000, NULL, NULL, NULL);
INSERT INTO `product_unit_measure` (`id`, `product_id`, `unit_measure_id`, `unit_price`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(21, 18, 3, 10000, NULL, NULL, NULL);
INSERT INTO `product_unit_measure` (`id`, `product_id`, `unit_measure_id`, `unit_price`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(22, 19, 3, 18000, NULL, NULL, NULL);

-- Listage de la structure de table raamshop_front. reports
CREATE TABLE IF NOT EXISTS `reports` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.reports : ~0 rows (environ)

-- Listage de la structure de table raamshop_front. return_stocks
CREATE TABLE IF NOT EXISTS `return_stocks` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `date` datetime NOT NULL,
  `code` varchar(255) NOT NULL DEFAULT '1709766459',
  `supplier_id` bigint(20) unsigned DEFAULT NULL,
  `products` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`products`)),
  `discount_on_total` varchar(255) NOT NULL DEFAULT '0',
  `total` double NOT NULL DEFAULT 0,
  `payment_method_id` bigint(20) unsigned DEFAULT NULL,
  `tva` varchar(255) NOT NULL DEFAULT '0',
  `state_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `return_stocks_supplier_id_foreign` (`supplier_id`),
  KEY `return_stocks_payment_method_id_foreign` (`payment_method_id`),
  KEY `return_stocks_state_id_foreign` (`state_id`),
  CONSTRAINT `return_stocks_payment_method_id_foreign` FOREIGN KEY (`payment_method_id`) REFERENCES `payment_methods` (`id`),
  CONSTRAINT `return_stocks_state_id_foreign` FOREIGN KEY (`state_id`) REFERENCES `states` (`id`),
  CONSTRAINT `return_stocks_supplier_id_foreign` FOREIGN KEY (`supplier_id`) REFERENCES `suppliers` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.return_stocks : ~0 rows (environ)

-- Listage de la structure de table raamshop_front. roles
CREATE TABLE IF NOT EXISTS `roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.roles : ~3 rows (environ)
INSERT INTO `roles` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, 'admin', NULL, NULL, NULL);
INSERT INTO `roles` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(2, 'vendeur', NULL, NULL, NULL);
INSERT INTO `roles` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(3, 'user', NULL, NULL, NULL);

-- Listage de la structure de table raamshop_front. role_table
CREATE TABLE IF NOT EXISTS `role_table` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `role_id` bigint(20) unsigned DEFAULT NULL,
  `table_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `role_table_role_id_foreign` (`role_id`),
  KEY `role_table_table_id_foreign` (`table_id`),
  CONSTRAINT `role_table_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`),
  CONSTRAINT `role_table_table_id_foreign` FOREIGN KEY (`table_id`) REFERENCES `tables` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.role_table : ~43 rows (environ)
INSERT INTO `role_table` (`id`, `role_id`, `table_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, 1, 1, NULL, NULL, NULL);
INSERT INTO `role_table` (`id`, `role_id`, `table_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(2, 1, 2, NULL, NULL, NULL);
INSERT INTO `role_table` (`id`, `role_id`, `table_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(3, 1, 3, NULL, NULL, NULL);
INSERT INTO `role_table` (`id`, `role_id`, `table_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(4, 1, 4, NULL, NULL, NULL);
INSERT INTO `role_table` (`id`, `role_id`, `table_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(7, 1, 7, NULL, NULL, NULL);
INSERT INTO `role_table` (`id`, `role_id`, `table_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(9, 1, 9, NULL, NULL, NULL);
INSERT INTO `role_table` (`id`, `role_id`, `table_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(10, 1, 10, NULL, NULL, NULL);
INSERT INTO `role_table` (`id`, `role_id`, `table_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(11, 1, 11, NULL, NULL, NULL);
INSERT INTO `role_table` (`id`, `role_id`, `table_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(12, 1, 12, NULL, NULL, NULL);
INSERT INTO `role_table` (`id`, `role_id`, `table_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(13, 1, 13, NULL, NULL, NULL);
INSERT INTO `role_table` (`id`, `role_id`, `table_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(14, 1, 14, NULL, NULL, NULL);
INSERT INTO `role_table` (`id`, `role_id`, `table_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(15, 1, 15, NULL, NULL, NULL);
INSERT INTO `role_table` (`id`, `role_id`, `table_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(16, 1, 16, NULL, NULL, NULL);
INSERT INTO `role_table` (`id`, `role_id`, `table_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(17, 1, 17, NULL, NULL, NULL);
INSERT INTO `role_table` (`id`, `role_id`, `table_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(18, 1, 18, NULL, NULL, NULL);
INSERT INTO `role_table` (`id`, `role_id`, `table_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(19, 1, 19, NULL, NULL, NULL);
INSERT INTO `role_table` (`id`, `role_id`, `table_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(20, 1, 20, NULL, NULL, NULL);
INSERT INTO `role_table` (`id`, `role_id`, `table_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(21, 1, 21, NULL, NULL, NULL);
INSERT INTO `role_table` (`id`, `role_id`, `table_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(22, 1, 22, NULL, NULL, NULL);
INSERT INTO `role_table` (`id`, `role_id`, `table_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(23, 1, 23, NULL, NULL, NULL);
INSERT INTO `role_table` (`id`, `role_id`, `table_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(24, 1, 24, NULL, NULL, NULL);
INSERT INTO `role_table` (`id`, `role_id`, `table_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(25, 1, 25, NULL, NULL, NULL);
INSERT INTO `role_table` (`id`, `role_id`, `table_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(26, 1, 26, NULL, NULL, NULL);
INSERT INTO `role_table` (`id`, `role_id`, `table_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(27, 1, 27, NULL, NULL, NULL);
INSERT INTO `role_table` (`id`, `role_id`, `table_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(28, 1, 28, NULL, NULL, NULL);
INSERT INTO `role_table` (`id`, `role_id`, `table_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(29, 1, 29, NULL, NULL, NULL);
INSERT INTO `role_table` (`id`, `role_id`, `table_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(30, 1, 30, NULL, NULL, NULL);
INSERT INTO `role_table` (`id`, `role_id`, `table_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(31, 1, 31, NULL, NULL, NULL);
INSERT INTO `role_table` (`id`, `role_id`, `table_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(32, 1, 32, NULL, NULL, NULL);
INSERT INTO `role_table` (`id`, `role_id`, `table_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(33, 1, 33, NULL, NULL, NULL);
INSERT INTO `role_table` (`id`, `role_id`, `table_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(34, 1, 34, NULL, NULL, NULL);
INSERT INTO `role_table` (`id`, `role_id`, `table_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(36, 1, 36, NULL, NULL, NULL);
INSERT INTO `role_table` (`id`, `role_id`, `table_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(37, 1, 37, NULL, NULL, NULL);
INSERT INTO `role_table` (`id`, `role_id`, `table_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(38, 1, 38, NULL, NULL, NULL);
INSERT INTO `role_table` (`id`, `role_id`, `table_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(39, 1, 39, NULL, NULL, NULL);
INSERT INTO `role_table` (`id`, `role_id`, `table_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(40, 1, 40, NULL, NULL, NULL);
INSERT INTO `role_table` (`id`, `role_id`, `table_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(41, 1, 41, NULL, NULL, NULL);
INSERT INTO `role_table` (`id`, `role_id`, `table_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(42, 1, 42, NULL, NULL, NULL);
INSERT INTO `role_table` (`id`, `role_id`, `table_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(43, 1, 43, NULL, NULL, NULL);
INSERT INTO `role_table` (`id`, `role_id`, `table_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(44, 2, 35, NULL, NULL, NULL);
INSERT INTO `role_table` (`id`, `role_id`, `table_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(45, 2, 5, NULL, NULL, NULL);
INSERT INTO `role_table` (`id`, `role_id`, `table_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(46, 2, 6, NULL, NULL, NULL);
INSERT INTO `role_table` (`id`, `role_id`, `table_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(47, 2, 8, NULL, NULL, NULL);

-- Listage de la structure de table raamshop_front. role_user
CREATE TABLE IF NOT EXISTS `role_user` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `role_id` bigint(20) unsigned DEFAULT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `role_user_role_id_foreign` (`role_id`),
  KEY `role_user_user_id_foreign` (`user_id`),
  CONSTRAINT `role_user_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`),
  CONSTRAINT `role_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.role_user : ~3 rows (environ)
INSERT INTO `role_user` (`id`, `role_id`, `user_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, 1, 1, NULL, NULL, NULL);
INSERT INTO `role_user` (`id`, `role_id`, `user_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(2, 1, 2, NULL, NULL, NULL);
INSERT INTO `role_user` (`id`, `role_id`, `user_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(3, 2, 3, NULL, NULL, NULL);

-- Listage de la structure de table raamshop_front. sales
CREATE TABLE IF NOT EXISTS `sales` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `date` datetime NOT NULL,
  `code` varchar(255) NOT NULL DEFAULT '1710177648',
  `customer_id` bigint(20) unsigned DEFAULT NULL,
  `order_id` bigint(20) unsigned NOT NULL,
  `discount_on_total` varchar(255) NOT NULL DEFAULT '0',
  `discount_on_coupon` varchar(255) NOT NULL DEFAULT '0',
  `total` double NOT NULL DEFAULT 0,
  `debtor_paid_amount` double NOT NULL DEFAULT 0,
  `tva` varchar(255) NOT NULL DEFAULT '0',
  `out_type_id` bigint(20) unsigned DEFAULT NULL,
  `state_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sales_customer_id_foreign` (`customer_id`),
  KEY `sales_order_id_foreign` (`order_id`),
  KEY `sales_out_type_id_foreign` (`out_type_id`),
  KEY `sales_state_id_foreign` (`state_id`),
  CONSTRAINT `sales_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`),
  CONSTRAINT `sales_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`),
  CONSTRAINT `sales_out_type_id_foreign` FOREIGN KEY (`out_type_id`) REFERENCES `out_types` (`id`),
  CONSTRAINT `sales_state_id_foreign` FOREIGN KEY (`state_id`) REFERENCES `states` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.sales : ~0 rows (environ)

-- Listage de la structure de table raamshop_front. sells
CREATE TABLE IF NOT EXISTS `sells` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `date` datetime NOT NULL,
  `code` varchar(255) NOT NULL DEFAULT '1709766452',
  `customer_id` bigint(20) unsigned DEFAULT NULL,
  `achats` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`achats`)),
  `shipping` double NOT NULL DEFAULT 0,
  `discount_on_total` varchar(255) NOT NULL DEFAULT '0',
  `total` double NOT NULL DEFAULT 0,
  `payment_method_id` bigint(20) unsigned DEFAULT NULL,
  `debtor_paid_amount` double NOT NULL DEFAULT 0,
  `tva` varchar(255) NOT NULL DEFAULT '0',
  `out_type_id` bigint(20) unsigned DEFAULT NULL,
  `state_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sells_customer_id_foreign` (`customer_id`),
  KEY `sells_payment_method_id_foreign` (`payment_method_id`),
  KEY `sells_out_type_id_foreign` (`out_type_id`),
  KEY `sells_state_id_foreign` (`state_id`),
  CONSTRAINT `sells_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`),
  CONSTRAINT `sells_out_type_id_foreign` FOREIGN KEY (`out_type_id`) REFERENCES `out_types` (`id`),
  CONSTRAINT `sells_payment_method_id_foreign` FOREIGN KEY (`payment_method_id`) REFERENCES `payment_methods` (`id`),
  CONSTRAINT `sells_state_id_foreign` FOREIGN KEY (`state_id`) REFERENCES `states` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.sells : ~0 rows (environ)

-- Listage de la structure de table raamshop_front. settings
CREATE TABLE IF NOT EXISTS `settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `description` longtext NOT NULL,
  `short_des` text NOT NULL,
  `logo` varchar(255) NOT NULL,
  `photo` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.settings : ~1 rows (environ)
INSERT INTO `settings` (`id`, `description`, `short_des`, `logo`, `photo`, `address`, `phone`, `email`, `created_at`, `updated_at`) VALUES
	(1, 'Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. sed ut perspiciatis unde sunt in culpa qui officia deserunt mollit anim id est laborum. sed ut perspiciatis unde omnis iste natus error sit voluptatem Excepteusunt in culpa qui officia deserunt mollit anim id est laborum. sed ut perspiciatis Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. sed ut perspi deserunt mollit anim id est laborum. sed ut perspi.', 'Praesent dapibus, neque id cursus ucibus, tortor neque egestas augue, magna eros eu erat. Aliquam erat volutpat. Nam dui mi, tincidunt quis, accumsan porttitor, facilisis luctus, metus.', 'images/logo/logo-dark.png', 'images/others/hero.jpg', 'NO. 342 - Lome Rue de 30 Aout, 012 Togo', '+228 00 11 22 33', 'raamshop@gmail.com', NULL, NULL);

-- Listage de la structure de table raamshop_front. shippings
CREATE TABLE IF NOT EXISTS `shippings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `status` enum('En Cours','Effectuée','Annulée') NOT NULL,
  `order_id` bigint(20) unsigned DEFAULT NULL,
  `cost` decimal(8,2) NOT NULL DEFAULT 0.00,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `shippings_order_id_foreign` (`order_id`),
  CONSTRAINT `shippings_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.shippings : ~2 rows (environ)
INSERT INTO `shippings` (`id`, `code`, `location`, `status`, `order_id`, `cost`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, '000001', 'https://maps.google.com/?q=6.2144982,1.1983422', 'Effectuée', 1, 5000.00, '2024-05-04 12:19:39', '2024-05-05 14:03:07', NULL);
INSERT INTO `shippings` (`id`, `code`, `location`, `status`, `order_id`, `cost`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(2, '000002', 'https://maps.google.com/?q=6.2144688,1.1983429', 'En Cours', 2, 10000.00, '2024-05-04 13:32:03', '2024-05-05 14:00:21', NULL);

-- Listage de la structure de table raamshop_front. states
CREATE TABLE IF NOT EXISTS `states` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.states : ~16 rows (environ)
INSERT INTO `states` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, 'DRAFT', NULL, NULL, NULL);
INSERT INTO `states` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(2, 'SENT', NULL, NULL, NULL);
INSERT INTO `states` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(3, 'ACCEPTED', NULL, NULL, NULL);
INSERT INTO `states` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(4, 'REJECTED', NULL, NULL, NULL);
INSERT INTO `states` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(5, 'PERFECT', NULL, NULL, NULL);
INSERT INTO `states` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(6, 'SEALED', NULL, NULL, NULL);
INSERT INTO `states` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(7, 'UNPAID', NULL, NULL, NULL);
INSERT INTO `states` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(8, 'PAID', NULL, NULL, NULL);
INSERT INTO `states` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(9, 'SEMIPAID', NULL, NULL, NULL);
INSERT INTO `states` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(10, 'SUCCESS', NULL, NULL, NULL);
INSERT INTO `states` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(11, 'WARNING', NULL, NULL, NULL);
INSERT INTO `states` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(12, 'ERROR', NULL, NULL, NULL);
INSERT INTO `states` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(13, 'CLOSED', NULL, NULL, NULL);
INSERT INTO `states` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(14, 'CANCELED', NULL, NULL, NULL);
INSERT INTO `states` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(15, 'PENDING', NULL, NULL, NULL);
INSERT INTO `states` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(16, 'ADDED', NULL, NULL, NULL);

-- Listage de la structure de table raamshop_front. stocks
CREATE TABLE IF NOT EXISTS `stocks` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `supplier_id` bigint(20) unsigned DEFAULT NULL,
  `product_id` bigint(20) unsigned DEFAULT NULL,
  `wholesale_measure_id` bigint(20) unsigned DEFAULT NULL,
  `wholesale_initial_quantity` double NOT NULL DEFAULT 0,
  `wholesale_unit_purchase_price` double NOT NULL DEFAULT 0,
  `in_detail_measure_id` bigint(20) unsigned DEFAULT NULL,
  `in_detail_quantity` double NOT NULL DEFAULT 0,
  `in_detail_unit_purchase_price` double NOT NULL DEFAULT 0,
  `payment_method_id` bigint(20) unsigned DEFAULT NULL,
  `credit_paid_amount` double NOT NULL DEFAULT 0,
  `total_purchase_cost` double NOT NULL DEFAULT 0,
  `receipt` varchar(255) DEFAULT NULL,
  `tva` varchar(255) DEFAULT NULL,
  `charge` double NOT NULL DEFAULT 0,
  `shipping` double NOT NULL DEFAULT 0,
  `discharge` double NOT NULL DEFAULT 0,
  `state_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `stocks_supplier_id_foreign` (`supplier_id`),
  KEY `stocks_product_id_foreign` (`product_id`),
  KEY `stocks_wholesale_measure_id_foreign` (`wholesale_measure_id`),
  KEY `stocks_in_detail_measure_id_foreign` (`in_detail_measure_id`),
  KEY `stocks_payment_method_id_foreign` (`payment_method_id`),
  KEY `stocks_state_id_foreign` (`state_id`),
  CONSTRAINT `stocks_in_detail_measure_id_foreign` FOREIGN KEY (`in_detail_measure_id`) REFERENCES `unit_measures` (`id`),
  CONSTRAINT `stocks_payment_method_id_foreign` FOREIGN KEY (`payment_method_id`) REFERENCES `payment_methods` (`id`),
  CONSTRAINT `stocks_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`),
  CONSTRAINT `stocks_state_id_foreign` FOREIGN KEY (`state_id`) REFERENCES `states` (`id`),
  CONSTRAINT `stocks_supplier_id_foreign` FOREIGN KEY (`supplier_id`) REFERENCES `suppliers` (`id`),
  CONSTRAINT `stocks_wholesale_measure_id_foreign` FOREIGN KEY (`wholesale_measure_id`) REFERENCES `unit_measures` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.stocks : ~5 rows (environ)
INSERT INTO `stocks` (`id`, `date`, `supplier_id`, `product_id`, `wholesale_measure_id`, `wholesale_initial_quantity`, `wholesale_unit_purchase_price`, `in_detail_measure_id`, `in_detail_quantity`, `in_detail_unit_purchase_price`, `payment_method_id`, `credit_paid_amount`, `total_purchase_cost`, `receipt`, `tva`, `charge`, `shipping`, `discharge`, `state_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, '2024-04-17', 1, 6, 5, 300, 11000, 5, 300, 11000, 1, 0, 3340000, 'storage/receipt/INV_STOCK-1713353984.png', NULL, 15000, 10000, 15000, 1, '2024-04-17 09:39:45', '2024-04-17 09:39:45', NULL);
INSERT INTO `stocks` (`id`, `date`, `supplier_id`, `product_id`, `wholesale_measure_id`, `wholesale_initial_quantity`, `wholesale_unit_purchase_price`, `in_detail_measure_id`, `in_detail_quantity`, `in_detail_unit_purchase_price`, `payment_method_id`, `credit_paid_amount`, `total_purchase_cost`, `receipt`, `tva`, `charge`, `shipping`, `discharge`, `state_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(2, '2024-04-09', 2, 13, 4, 4, 80000, 7, 30, 20000, 5, 0, 2425000, '', NULL, 5000, 15000, 5000, 6, '2024-04-17 11:54:45', '2024-05-03 13:34:04', NULL);
INSERT INTO `stocks` (`id`, `date`, `supplier_id`, `product_id`, `wholesale_measure_id`, `wholesale_initial_quantity`, `wholesale_unit_purchase_price`, `in_detail_measure_id`, `in_detail_quantity`, `in_detail_unit_purchase_price`, `payment_method_id`, `credit_paid_amount`, `total_purchase_cost`, `receipt`, `tva`, `charge`, `shipping`, `discharge`, `state_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(3, '2024-03-12', 2, 17, 5, 60, 20000, 5, 60, 20000, 4, 0, 1250000, '', NULL, 0, 50000, 0, 6, '2024-04-17 13:17:45', '2024-04-24 15:26:35', NULL);
INSERT INTO `stocks` (`id`, `date`, `supplier_id`, `product_id`, `wholesale_measure_id`, `wholesale_initial_quantity`, `wholesale_unit_purchase_price`, `in_detail_measure_id`, `in_detail_quantity`, `in_detail_unit_purchase_price`, `payment_method_id`, `credit_paid_amount`, `total_purchase_cost`, `receipt`, `tva`, `charge`, `shipping`, `discharge`, `state_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(4, '2024-05-22', 1, 18, 3, 1, 6000, 3, 100, 6000, 4, 0, 14000, 'storage/receipts/INV_STOCK-1716481927.png', NULL, 3000, 2000, 3000, 6, '2024-05-23 14:32:07', '2024-05-23 14:32:28', NULL);
INSERT INTO `stocks` (`id`, `date`, `supplier_id`, `product_id`, `wholesale_measure_id`, `wholesale_initial_quantity`, `wholesale_unit_purchase_price`, `in_detail_measure_id`, `in_detail_quantity`, `in_detail_unit_purchase_price`, `payment_method_id`, `credit_paid_amount`, `total_purchase_cost`, `receipt`, `tva`, `charge`, `shipping`, `discharge`, `state_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(5, '2024-05-13', 2, 19, 3, 30, 13500, 3, 30, 13500, 5, 0, 418000, '', NULL, 5000, 3000, 5000, 6, '2024-05-23 14:44:52', '2024-05-23 14:45:06', NULL);

-- Listage de la structure de table raamshop_front. suppliers
CREATE TABLE IF NOT EXISTS `suppliers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `phones` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `particular_name` varchar(255) DEFAULT NULL,
  `particular_phones` varchar(255) DEFAULT NULL,
  `particular_email` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.suppliers : ~3 rows (environ)
INSERT INTO `suppliers` (`id`, `name`, `phones`, `email`, `address`, `particular_name`, `particular_phones`, `particular_email`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, 'Seven Young', '+3376695278', 'orders@sevenyoung.com', '9907 rue des petits champs, Paris, France', 'Emilie Dequenes', '+336521479663', 'emiliedequenes@gmail.com', '2024-04-17 09:11:03', '2024-04-17 09:21:05', NULL);
INSERT INTO `suppliers` (`id`, `name`, `phones`, `email`, `address`, `particular_name`, `particular_phones`, `particular_email`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(2, 'YesStyle', '+85227860817', 'support@yesstyle.com', 'KC100, 5/F, 100 Kwai Cheong Rd, Kwai Chung, Hong Kong', 'Joshua K. Lau', '+85221289810', 'joshualau@gmail.com', '2024-04-17 09:19:36', '2024-04-17 09:19:36', NULL);
INSERT INTO `suppliers` (`id`, `name`, `phones`, `email`, `address`, `particular_name`, `particular_phones`, `particular_email`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(3, 'Facetheory Skincare', '+4408963089', 'help@facetheory.com', 'Unit E, Old Colliery Way Sheffield S20 1DJ United Kingom', 'Jane Young', '+4485120713', 'janeyoung@yahoo.com', '2024-04-17 09:26:29', '2024-04-17 09:26:29', NULL);

-- Listage de la structure de table raamshop_front. supplier_credits
CREATE TABLE IF NOT EXISTS `supplier_credits` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `supplier_id` bigint(20) unsigned DEFAULT NULL,
  `stock_id` bigint(20) unsigned DEFAULT NULL,
  `paid_amount` double NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `supplier_credits_supplier_id_foreign` (`supplier_id`),
  KEY `supplier_credits_stock_id_foreign` (`stock_id`),
  CONSTRAINT `supplier_credits_stock_id_foreign` FOREIGN KEY (`stock_id`) REFERENCES `stocks` (`id`),
  CONSTRAINT `supplier_credits_supplier_id_foreign` FOREIGN KEY (`supplier_id`) REFERENCES `suppliers` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.supplier_credits : ~0 rows (environ)

-- Listage de la structure de table raamshop_front. tables
CREATE TABLE IF NOT EXISTS `tables` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.tables : ~46 rows (environ)
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, 'categories', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(2, 'category_product', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(3, 'commands', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(4, 'companies', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(5, 'customers', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(6, 'debtors', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(7, 'expense_types', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(8, 'expenses', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(9, 'failed_jobs', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(10, 'inventories', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(11, 'invoices', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(12, 'logs', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(13, 'migrations', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(14, 'movement_types', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(15, 'navigator_types', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(16, 'navigators', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(17, 'out_types', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(18, 'password_reset_tokens', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(19, 'password_resets', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(20, 'payment_methods', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(21, 'permission_role', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(22, 'permission_table', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(23, 'permissions', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(24, 'personal_access_tokens', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(25, 'printer_types', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(26, 'printers', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(27, 'product_details', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(28, 'product_unit_measure', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(29, 'products', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(30, 'reports', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(31, 'return_stocks', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(32, 'role_table', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(33, 'role_user', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(34, 'roles', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(35, 'sells', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(36, 'settings', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(37, 'states', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(38, 'stocks', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(39, 'supplier_credits', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(40, 'suppliers', '2024-03-06 22:08:06', '2024-03-06 22:08:06', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(41, 'tables', '2024-03-06 22:08:06', '2024-03-06 22:08:06', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(42, 'unit_measures', '2024-03-06 22:08:06', '2024-03-06 22:08:06', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(43, 'users', '2024-03-06 22:08:06', '2024-03-06 22:08:06', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(44, 'brands', '2024-04-22 18:11:24', '2024-04-22 18:11:24', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(45, 'orders', '2024-04-30 14:41:22', '2024-04-30 14:41:22', NULL);
INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(46, 'shippings', '2024-05-04 10:01:27', '2024-05-04 10:01:28', NULL);

-- Listage de la structure de table raamshop_front. unit_measures
CREATE TABLE IF NOT EXISTS `unit_measures` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `unit` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.unit_measures : ~9 rows (environ)
INSERT INTO `unit_measures` (`id`, `unit`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, 'Carton', NULL, NULL, NULL);
INSERT INTO `unit_measures` (`id`, `unit`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(2, 'Sac', NULL, NULL, NULL);
INSERT INTO `unit_measures` (`id`, `unit`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(3, 'Sachet', NULL, NULL, NULL);
INSERT INTO `unit_measures` (`id`, `unit`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(4, 'Casier', NULL, NULL, NULL);
INSERT INTO `unit_measures` (`id`, `unit`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(5, 'Bouteille', NULL, NULL, NULL);
INSERT INTO `unit_measures` (`id`, `unit`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(6, 'Rouleau', NULL, NULL, NULL);
INSERT INTO `unit_measures` (`id`, `unit`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(7, 'Piece', NULL, NULL, NULL);
INSERT INTO `unit_measures` (`id`, `unit`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(8, 'Bidon', NULL, NULL, NULL);
INSERT INTO `unit_measures` (`id`, `unit`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(9, 'Plaquette', NULL, NULL, NULL);

-- Listage de la structure de table raamshop_front. wishlists
CREATE TABLE IF NOT EXISTS `wishlists` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `products_json` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`products_json`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `cart_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `wishlists_user_id_foreign` (`user_id`),
  KEY `wishlists_cart_id_foreign` (`cart_id`),
  CONSTRAINT `wishlists_cart_id_foreign` FOREIGN KEY (`cart_id`) REFERENCES `carts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `wishlists_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table raamshop_front.wishlists : ~3 rows (environ)
INSERT INTO `wishlists` (`id`, `user_id`, `products_json`, `created_at`, `updated_at`, `deleted_at`, `cart_id`) VALUES
	(1, 4, '[]', '2024-04-13 08:18:52', '2024-04-20 07:50:59', NULL, 1);
INSERT INTO `wishlists` (`id`, `user_id`, `products_json`, `created_at`, `updated_at`, `deleted_at`, `cart_id`) VALUES
	(2, 8, '{"000012":{"name":"Ginseng Cleansing Oil","image":"storage\\/products\\/ginseng-cleansing-oil-1712734534.jpg","raw_price":22000,"discount":0,"price":22000},"000001":{"name":"Quinoa Gel Cleanser","image":"storage\\/products\\/quinoa-gel-cleanser-1712674414.jpg","raw_price":15000,"discount":"12","price":13200}}', '2024-05-05 21:01:41', '2024-05-24 14:29:13', NULL, 4);
INSERT INTO `wishlists` (`id`, `user_id`, `products_json`, `created_at`, `updated_at`, `deleted_at`, `cart_id`) VALUES
	(3, 9, '[]', '2024-05-07 13:25:13', '2024-05-07 13:25:52', NULL, 5);

