[BLOB]\" style=\"width: 586.75px;\" data-filename=\"4.png\"></p></figure><div class=\"row\"><div class=\"col-xl-12 col-md-12\"><div class=\"post__tag\"><ul>\r\n                                                </ul>\r\n                                            </div>\r\n                                        </div>\r\n                                        \r\n                                    </div>\r\n                                </div>', 'dessss', 'xzszszsz', NULL, NULL, '2025-05-28 12:31:58', '2025-05-28 12:31:58');
INSERT INTO `pages` (`id`, `title`, `slug`, `content`, `meta_title`, `meta_description`, `meta_image`, `keywords`, `created_at`, `updated_at`) VALUES
(22, 'RGPD', 'rgpd', NULL, NULL, NULL, NULL, NULL, '2025-06-26 14:20:26', '2025-06-26 14:20:26'),
(23, 'Mentions légales', 'mentions-legales', NULL, NULL, NULL, NULL, NULL, '2025-06-26 14:21:21', '2025-06-26 14:21:21'),
(24, 'Services pratiques et numériques', 'services-complementaires', '<span id=\"docs-internal-guid-de2bc6ea-7fff-8c7a-ad91-dbb273f7032f\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt;\"><span style=\"font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; font-variant-emoji: normal; vertical-align: baseline; white-space-collapse: preserve;\">Notre imprimerie vous propose une gamme de services complémentaires pour vous accompagner dans tous vos besoins du quotidien : préparation de fichiers, numérisation, diffusion par mail, finitions manuelles, et bien plus encore.</span></p><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt;\"><span style=\"font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; font-variant-emoji: normal; vertical-align: baseline; white-space-collapse: preserve;\">Qu’il s’agisse de retoucher une photo, scanner des documents, transférer des fichiers, plier ou massicoter vos impressions, notre équipe est là pour vous assister avec efficacité.</span></p><h3 dir=\"ltr\" style=\"line-height:1.38;margin-top:14pt;margin-bottom:4pt;\"><span style=\"font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; font-variant-emoji: normal; vertical-align: baseline; white-space-collapse: preserve;\">Nos services incluent notamment :</span></h3><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt;\"><span style=\"font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; font-variant-emoji: normal; vertical-align: baseline; white-space-collapse: preserve;\">Scan de documents feuille à feuille</span><span style=\"font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; font-variant-emoji: normal; vertical-align: baseline; white-space-collapse: preserve;\"> : 2,50 € la première page, puis 0,25 € par page supplémentaire</span><span style=\"font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; font-variant-emoji: normal; vertical-align: baseline; white-space-collapse: preserve;\"><br><br></span></p><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt;\"><span style=\"font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; font-variant-emoji: normal; vertical-align: baseline; white-space-collapse: preserve;\">Scan de photos</span><span style=\"font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; font-variant-emoji: normal; vertical-align: baseline; white-space-collapse: preserve;\"> : 2,50 € la première, puis 0,25 € les suivantes</span><span style=\"font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; font-variant-emoji: normal; vertical-align: baseline; white-space-collapse: preserve;\"><br><br></span></p><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt;\"><span style=\"font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; font-variant-emoji: normal; vertical-align: baseline; white-space-collapse: preserve;\">Retouche photo</span><span style=\"font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; font-variant-emoji: normal; vertical-align: baseline; white-space-collapse: preserve;\"> : 1,00 €</span><span style=\"font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; font-variant-emoji: normal; vertical-align: baseline; white-space-collapse: preserve;\"><br><br></span></p><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt;\"><span style=\"font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; font-variant-emoji: normal; vertical-align: baseline; white-space-collapse: preserve;\">Découpe au massicot</span><span style=\"font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; font-variant-emoji: normal; vertical-align: baseline; white-space-collapse: preserve;\"> : 1,00 € la coupe</span><span style=\"font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; font-variant-emoji: normal; vertical-align: baseline; white-space-collapse: preserve;\"><br><br></span></p><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt;\"><span style=\"font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; font-variant-emoji: normal; vertical-align: baseline; white-space-collapse: preserve;\">Pliage ou rainage de papier</span><span style=\"font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; font-variant-emoji: normal; vertical-align: baseline; white-space-collapse: preserve;\"> : 0,10 €</span><span style=\"font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; font-variant-emoji: normal; vertical-align: baseline; white-space-collapse: preserve;\"><br><br></span></p><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt;\"><span style=\"font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; font-variant-emoji: normal; vertical-align: baseline; white-space-collapse: preserve;\">Ouverture de fichier (clé USB ou mail)</span><span style=\"font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; font-variant-emoji: normal; vertical-align: baseline; white-space-collapse: preserve;\"> : 0,50 €</span><span style=\"font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; font-variant-emoji: normal; vertical-align: baseline; white-space-collapse: preserve;\"><br><br></span></p><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt;\"><span style=\"font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; font-variant-emoji: normal; vertical-align: baseline; white-space-collapse: preserve;\">Envoi d’un fichier par mail</span><span style=\"font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; font-variant-emoji: normal; vertical-align: baseline; white-space-collapse: preserve;\"> : 1,50 €</span><span style=\"font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; font-variant-emoji: normal; vertical-align: baseline; white-space-collapse: preserve;\"><br><br></span></p><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt;\"><span style=\"font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; font-variant-emoji: normal; vertical-align: baseline; white-space-collapse: preserve;\">Transfert de fichiers (clé USB, disque dur, etc.)</span><span style=\"font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; font-variant-emoji: normal; vertical-align: baseline; white-space-collapse: preserve;\"> : 5,00 €</span><span style=\"font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; font-variant-emoji: normal; vertical-align: baseline; white-space-collapse: preserve;\"><br><br></span></p><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt;\"><span style=\"font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; font-variant-emoji: normal; vertical-align: baseline; white-space-collapse: preserve;\">Gravure CD / DVD</span><span style=\"font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; font-variant-emoji: normal; vertical-align: baseline; white-space-collapse: preserve;\"> : 6,00 €</span><span style=\"font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; font-variant-emoji: normal; vertical-align: baseline; white-space-collapse: preserve;\"><br><br></span></p><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt;\"><span style=\"font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; font-variant-emoji: normal; vertical-align: baseline; white-space-collapse: preserve;\">Saisie de CV ou de documents</span><span style=\"font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; font-variant-emoji: normal; vertical-align: baseline; white-space-collapse: preserve;\"> : 10,00 € / page</span><span style=\"font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; font-variant-emoji: normal; vertical-align: baseline; white-space-collapse: preserve;\"><br><br></span></p><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt;\"><span style=\"font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; font-variant-emoji: normal; vertical-align: baseline; white-space-collapse: preserve;\">Agrafage</span><span style=\"font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; font-variant-emoji: normal; vertical-align: baseline; white-space-collapse: preserve;\"> : 0,10 €</span><span style=\"font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; font-variant-emoji: normal; vertical-align: baseline; white-space-collapse: preserve;\"><br><br></span></p><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt;\"><span style=\"font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; font-variant-emoji: normal; vertical-align: baseline; white-space-collapse: preserve;\">Façonnage livret machine</span><span style=\"font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; font-variant-emoji: normal; vertical-align: baseline; white-space-collapse: preserve;\"> : 1,10 €</span><span style=\"font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; font-variant-emoji: normal; vertical-align: baseline; white-space-collapse: preserve;\"><br><br></span></p><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt;\"><span style=\"font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; font-variant-emoji: normal; vertical-align: baseline; white-space-collapse: preserve;\">Accès Internet – 15 minutes</span><span style=\"font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; font-variant-emoji: normal; vertical-align: baseline; white-space-collapse: preserve;\"> : 1,00 €</span></p></span>', NULL, NULL, NULL, NULL, '2025-07-03 07:33:28', '2025-07-03 07:45:50');

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

--
-- Table structure for table `posts`
--

CREATE TABLE `posts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `type` varchar(255) DEFAULT NULL,
  `content` longtext DEFAULT NULL,
  `slug` varchar(255) NOT NULL,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_description` text DEFAULT NULL,
  `meta_image` varchar(255) DEFAULT NULL,
  `keywords` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `posts`
--

INSERT INTO `posts` (`id`, `title`, `type`, `content`, `slug`, `meta_title`, `meta_description`, `meta_image`, `keywords`, `date`, `created_at`, `updated_at`) VALUES
(2, 'Tombola Lachapelle-Sous-Aubenas', 'Tombola Lachapelle-Sous-Aubenas', '<p>Notre imprimerie a r&eacute;cemment eu le plaisir de collaborer avec L&#39;Amicale La&iuml;que de Lachapelle-Sous-Aubenas pour l&#39;impression de 4000 tickets de tombola.&nbsp;</p>\r\n\r\n<p>Chaque ticket a &eacute;t&eacute; imprim&eacute;, d&eacute;coup&eacute;, rainur&eacute; et agraf&eacute; par nos soins dans notre local. Gr&acirc;ce &agrave; notre savoir-faire et &agrave; nos &eacute;quipements professionnels, nous avons pu garantir une livraison rapide et un rendu impeccable.</p>\r\n\r\n<p>A noter que l&rsquo;ensemble des b&eacute;n&eacute;fices seront revers&eacute;s pour les activit&eacute;s scolaires des &eacute;l&egrave;ves de L&rsquo;Ecole du Vignoble. &nbsp;</p>\r\n\r\n<p>Nous sommes fiers de contribuer &agrave; la r&eacute;ussite de manifestation locale et&nbsp;de mettre notre expertise au service d&rsquo;initiatives solidaires et festives.</p>', 'privacy', NULL, NULL, 'uploads/meta_images/1748006804_meta_image.jpg', 'tombola, ticket, lots, juin', '2025-05-23', '2025-03-03 15:27:22', '2025-06-06 08:48:10'),
(12, 'Photocall Raid\'O\'Féminin', 'Photocall Raid\'O\'Féminin', '<p>Dans le cadre de la prochaine &eacute;dition du Raid&#39;O&#39;F&eacute;minin, pr&eacute;vue le 25 mai 2025 &agrave; Montr&eacute;al, en Ard&egrave;che, notre imprimerie a &eacute;t&eacute; sollicit&eacute;e pour concevoir une b&acirc;che personnalis&eacute;e. Cet &eacute;v&eacute;nement rassemble chaque ann&eacute;e de nombreuses participantes et partenaires autour de valeurs fortes : engagement, entraide et d&eacute;passement de soi. Pour r&eacute;pondre &agrave; cette dynamique, un support visuel de qualit&eacute; &eacute;tait essentiel.</p>\r\n\r\n<p>La b&acirc;che r&eacute;alis&eacute;e a &eacute;t&eacute; sp&eacute;cifiquement con&ccedil;ue pour servir de photocall lors de l&rsquo;&eacute;v&eacute;nement. Elle permettra aux participantes et aux partenaires de disposer d&rsquo;un arri&egrave;re-plan valorisant pour leurs photos officielles ou souvenirs.</p>\r\n\r\n<p>Ce type de support visuel met en avant les partenaires, renforce leur visibilit&eacute; aupr&egrave;s du public et des m&eacute;dias, tout en cr&eacute;ant un espace de communication fort.</p>\r\n\r\n<p>En tant qu&rsquo;imprimeur local, nous sommes fiers d&rsquo;avoir apport&eacute; notre expertise technique et cr&eacute;ative &agrave; ce projet.</p>', 'photocall-raidofeminin', NULL, NULL, 'uploads/meta_images/1747990140_meta_image.png', 'féminine, raid, photocall', '2025-05-19', '2025-05-23 08:38:01', '2025-05-23 13:28:38');

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

--
-- Table structure for table `prices`
--

CREATE TABLE `prices` (
  `id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `sub_category_id` int(11) DEFAULT NULL,
  `paper_size` varchar(10) NOT NULL,
  `color_type` varchar(20) NOT NULL,
  `label` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_german2_ci DEFAULT NULL,
  `from_page` int(11) DEFAULT NULL,
  `to_page` int(11) DEFAULT NULL,
  `price_per_page` decimal(10,4) DEFAULT NULL,
  `price_with_tax` decimal(10,2) GENERATED ALWAYS AS (round(`price_per_page` + `price_per_page` * `tax_percentage` / 100,2)) STORED,
  `tax_percentage` decimal(5,2) DEFAULT 0.00,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `prices`
--

INSERT INTO `prices` (`id`, `category_id`, `sub_category_id`, `paper_size`, `color_type`, `label`, `from_page`, `to_page`, `price_per_page`, `tax_percentage`, `created_at`, `updated_at`) VALUES
(158, 2, NULL, 'A4', 'Noir et Blanc', NULL, 1, 2, 0.4200, 20.00, '2025-06-16 09:15:35', '2025-06-16 09:15:35'),
(159, 2, NULL, 'A4', 'Noir et Blanc', NULL, 3, 6, 0.2100, 20.00, '2025-06-16 09:15:35', '2025-06-16 09:15:35'),
(160, 2, NULL, 'A4', 'Noir et Blanc', NULL, 7, 100, 0.1250, 20.00, '2025-06-16 09:15:35', '2025-06-20 13:48:39'),
(161, 2, NULL, 'A4', 'Noir et Blanc', NULL, 101, 202, 0.0800, 20.00, '2025-06-16 09:15:35', '2025-06-20 13:48:27'),
(162, 2, NULL, 'A4', 'Noir et Blanc', NULL, 203, 1000, 0.0700, 20.00, '2025-06-16 09:15:35', '2025-06-16 09:15:35'),
(163, 1, NULL, 'A3', 'Noir et Blanc', NULL, 3, 6, 0.1700, 20.00, '2025-06-16 09:15:35', '2025-06-16 09:15:35'),
(164, 1, NULL, 'A3', 'Noir et Blanc', NULL, 7, 102, 0.1250, 20.00, '2025-06-16 09:15:35', '2025-06-20 15:20:46'),
(165, 1, NULL, 'A3', 'Noir et Blanc', NULL, 102, 202, 0.0800, 20.00, '2025-06-16 09:15:35', '2025-06-16 09:15:35'),
(166, 1, NULL, 'A3', 'Noir et Blanc', NULL, 203, 1000, 0.0700, 20.00, '2025-06-16 09:15:35', '2025-06-16 09:15:35'),
(167, 2, NULL, 'A4', 'Couleur', NULL, 1, 10, 0.6250, 20.00, '2025-06-16 09:15:35', '2025-06-17 14:12:30'),
(168, 2, NULL, 'A4', 'Couleur', NULL, 11, 20, 0.5800, 20.00, '2025-06-16 09:15:35', '2025-06-16 09:15:35'),
(169, 2, NULL, 'A4', 'Couleur', NULL, 21, 30, 0.5400, 20.00, '2025-06-16 09:15:35', '2025-06-16 09:15:35'),
(170, 2, NULL, 'A4', 'Couleur', NULL, 31, 40, 0.5000, 20.00, '2025-06-16 09:15:35', '2025-06-16 09:15:35'),
(171, 2, NULL, 'A4', 'Couleur', NULL, 41, 50, 0.4600, 20.00, '2025-06-16 09:15:35', '2025-06-16 09:15:35'),
(172, 2, NULL, 'A4', 'Couleur', NULL, 51, 60, 0.4200, 20.00, '2025-06-16 09:15:35', '2025-06-16 09:15:35'),
(173, 2, NULL, 'A4', 'Couleur', NULL, 61, 70, 0.3800, 20.00, '2025-06-16 09:15:35', '2025-06-16 09:15:35'),
(174, 2, NULL, 'A4', 'Couleur', NULL, 71, 80, 0.3300, 20.00, '2025-06-16 09:15:35', '2025-06-16 09:15:35'),
(175, 2, NULL, 'A4', 'Couleur', NULL, 81, 90, 0.2900, 20.00, '2025-06-16 09:15:35', '2025-06-16 09:15:35'),
(176, 2, NULL, 'A4', 'Couleur', NULL, 91, 100, 0.2500, 20.00, '2025-06-16 09:15:35', '2025-06-16 09:15:35'),
(177, 2, NULL, 'A4', 'Couleur', NULL, 101, 1000, 0.2100, 20.00, '2025-06-16 09:15:35', '2025-06-20 13:55:58'),
(178, 1, NULL, 'A3', 'Couleur', NULL, 1, 5, 1.2500, 20.00, '2025-06-16 09:15:35', '2025-06-16 09:15:35'),
(179, 1, NULL, 'A3', 'Couleur', NULL, 6, 10, 1.1700, 20.00, '2025-06-16 09:15:35', '2025-06-16 09:15:35'),
(180, 1, NULL, 'A3', 'Couleur', NULL, 11, 15, 1.0800, 20.00, '2025-06-16 09:15:35', '2025-06-16 09:15:35'),
(181, 1, NULL, 'A3', 'Couleur', NULL, 16, 20, 1.0000, 20.00, '2025-06-16 09:15:35', '2025-06-16 09:15:35'),
(182, 1, NULL, 'A3', 'Couleur', NULL, 21, 25, 0.9200, 20.00, '2025-06-16 09:15:35', '2025-06-16 09:15:35'),
(183, 1, NULL, 'A3', 'Couleur', NULL, 26, 30, 0.8300, 20.00, '2025-06-16 09:15:35', '2025-06-16 09:15:35'),
(184, 1, NULL, 'A3', 'Couleur', NULL, 31, 35, 0.7500, 20.00, '2025-06-16 09:15:35', '2025-06-16 09:15:35'),
(185, 1, NULL, 'A3', 'Couleur', NULL, 36, 40, 0.6700, 20.00, '2025-06-16 09:15:35', '2025-06-16 09:15:35'),
(186, 1, NULL, 'A3', 'Couleur', NULL, 41, 45, 0.5800, 20.00, '2025-06-16 09:15:35', '2025-06-16 09:15:35'),
(187, 1, NULL, 'A3', 'Couleur', NULL, 46, 50, 0.5000, 20.00, '2025-06-16 09:15:35', '2025-06-16 09:15:35'),
(188, 1, NULL, 'A3', 'Couleur', NULL, 51, 1000, 0.4200, 20.00, '2025-06-16 09:15:35', '2025-06-16 09:15:35');

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

--
-- Table structure for table `pricing`
--

CREATE TABLE `pricing` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `plan_name` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `billing_period` varchar(255) NOT NULL,
  `price` decimal(8,2) NOT NULL,
  `features` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`features`)),
  `button_text` varchar(255) NOT NULL,
  `button_link` varchar(255) NOT NULL,
  `is_featured` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pricing`
--

INSERT INTO `pricing` (`id`, `plan_name`, `description`, `billing_period`, `price`, `features`, `button_text`, `button_link`, `is_featured`, `created_at`, `updated_at`) VALUES
(1, 'Standard', 'L\'offre simple et économique pour vos impressions du quotidien.', 'Mensuel', 15.00, '[\"100 impressions\",\"        15 scan de documents\",\"        15 envois de mail\"]', 'Souscrire', 'contact', 0, '2025-02-23 15:03:26', '2025-05-13 14:15:04'),
(2, 'Essentiel', 'Pensé pour les professionnels et les structures actives.', 'Mensuel', 40.00, '[\"500 impressions\",\"        50 scan de documents\",\"        50 envois de mail\"]', 'Souscrire', 'contact', 1, '2025-02-23 15:03:26', '2025-05-13 14:15:04'),
(3, 'Premium', 'La qualité professionnelle, toute l\'année, pour un tarif maîtrisé.', 'Annuel', 390.00, '[\"1500 impressions\",\"        200 scan de documents\",\"        200 envois de mail\"]', 'Souscrire', 'contact', 0, '2025-02-23 15:03:26', '2025-05-13 14:15:04');

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

--
-- Table structure for table `print_calibrations`
--

CREATE TABLE `print_calibrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `top_margin` varchar(255) DEFAULT NULL,
  `bottom_margin` varchar(255) DEFAULT NULL,
  `left_margin` varchar(255) DEFAULT NULL,
  `right_margin` varchar(255) DEFAULT NULL,
  `paper_type` enum('A3','A4','SRA3') DEFAULT 'A4',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `file_requirement` text DEFAULT NULL,
  `business_card_format` text DEFAULT NULL,
  `square_card_format` text DEFAULT NULL,
  `a6_card_format` text DEFAULT NULL,
  `correspondence_card_format` text DEFAULT NULL,
  `bleed_info` text DEFAULT NULL,
  `frame_info` text DEFAULT NULL,
  `indesign_template_link` varchar(255) DEFAULT NULL,
  `pdf_template_link` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `print_calibrations`
--

INSERT INTO `print_calibrations` (`id`, `top_margin`, `bottom_margin`, `left_margin`, `right_margin`, `paper_type`, `created_at`, `updated_at`, `file_requirement`, `business_card_format`, `square_card_format`, `a6_card_format`, `correspondence_card_format`, `bleed_info`, `frame_info`, `indesign_template_link`, `pdf_template_link`) VALUES
(1, '5', '5', '5', '5', 'A4', '2025-04-24 12:57:16', '2025-07-03 13:34:37', 'PDF 300 dpi, CMJN, sans Pantone ni ton direct', '85 x 55 mm ou 55 x 85 mm + 3 mm bords perdus', '150 x 150 mm ou 100 x 100 mm + 3 mm bords perdus', '150 x 100 mm ou 100 x 150 mm + 3 mm bords perdus', '210 x 100 mm + 3 mm bords perdus', '3 mm minimum tout le tour', '3 mm minimum', 'templates/indesign/lTkNZdJD8KJ1zPNwgsQTLjRtQMB5669aoAe9MtLi.zip', 'templates/pdf/qSsrBRir7vXoceWILhjTV0a7U1QSknlgxSsdjnPl.pdf');

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

--
-- Table structure for table `print_methods`
--

CREATE TABLE `print_methods` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(100) NOT NULL,
  `description` text DEFAULT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT 0,
  `permission_flags` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`permission_flags`)),
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`, `description`, `is_default`, `permission_flags`, `created_at`, `updated_at`) VALUES
(1, 'test 1', 'testt', 1, '\"[]\"', '2025-06-13 12:36:57', '2025-06-13 12:36:57');

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

--
-- Table structure for table `sections`
--

CREATE TABLE `sections` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `is_visible` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sections`
--

INSERT INTO `sections` (`id`, `name`, `is_visible`, `created_at`, `updated_at`) VALUES
(1, 'header', 1, '2025-02-23 15:03:26', '2025-05-27 07:14:04'),
(2, 'slider', 1, '2025-02-23 15:03:26', '2025-05-27 07:14:04'),
(3, 'services', 1, '2025-02-23 15:03:26', '2025-05-27 07:14:04'),
(4, 'about', 1, '2025-02-23 15:03:26', '2025-05-27 07:14:04'),
(5, 'cta', 1, '2025-02-23 15:03:26', '2025-05-27 07:14:04'),
(6, 'services_three', 1, '2025-02-23 15:03:26', '2025-05-27 07:14:04'),
(7, 'gallery', 1, '2025-02-23 15:03:26', '2025-05-27 07:14:04'),
(8, 'pricing', 0, '2025-02-23 15:03:26', '2025-05-27 07:14:04'),
(9, 'brand', 1, '2025-02-23 15:03:26', '2025-05-27 07:14:04'),
(10, 'testimonial', 0, '2025-02-23 15:03:26', '2025-05-27 07:14:04'),
(11, 'blog', 1, '2025-02-23 15:03:26', '2025-05-27 07:14:04'),
(12, 'footer', 1, '2025-02-23 15:03:26', '2025-05-27 07:14:04'),
(13, 'services_menu', 1, '2025-05-15 10:40:01', '2025-05-27 07:14:04'),
(14, 'faq', 1, '2025-05-15 11:22:32', '2025-05-27 07:14:04');

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

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `service_firstHeading` varchar(255) NOT NULL,
  `service_firstPara` varchar(255) NOT NULL,
  `service_secondHeading` varchar(255) NOT NULL,
  `service_secondPara` varchar(255) NOT NULL,
  `service_thirdHeading` varchar(255) NOT NULL,
  `service_thirdPara` varchar(255) NOT NULL,
  `service_firstImage` varchar(255) NOT NULL,
  `service_secondImage` varchar(255) NOT NULL,
  `service_thirdImage` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `services`
--

INSERT INTO `services` (`id`, `service_firstHeading`, `service_firstPara`, `service_secondHeading`, `service_secondPara`, `service_thirdHeading`, `service_thirdPara`, `service_firstImage`, `service_secondImage`, `service_thirdImage`, `created_at`, `updated_at`) VALUES
(1, 'Impression Digitale', 'La flexibilité au service de l\'impression.', 'Risographie', 'Une impression aux couleurs franches, parfaite pour les projets créatifs.', 'Impression 3D', 'L’impression 3D donne forme à vos idées : prototypes, objets sur mesure ou pièces techniques.', 'uploads/1746436737_service_firstImage.png', 'uploads/1746436798_service_secondImage.png', 'uploads/1742374543_service_thirdImage.png', '2025-02-23 15:35:43', '2025-05-26 12:19:25');

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

--
-- Table structure for table `services_menu`
--

CREATE TABLE `services_menu` (
  `id` int(10) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `subtitle` varchar(255) DEFAULT NULL,
  `icon_path` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `order` int(11) DEFAULT 0,
  `is_visible` tinyint(1) DEFAULT 1,
  `show_order_button` tinyint(1) DEFAULT 0,
  `order_button_link` varchar(255) DEFAULT NULL,
  `application_redirect` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `services_menu`
--

INSERT INTO `services_menu` (`id`, `title`, `slug`, `subtitle`, `icon_path`, `name`, `description`, `link`, `order`, `is_visible`, `show_order_button`, `order_button_link`, `application_redirect`, `created_at`, `updated_at`) VALUES
(1, 'Stickers et étiquettes', 'stickers-et-etiquettes', 'Stickers et étiquettes', 'img/icon/sve-icon10.png', 'Stickers et étiquettes', 'Nos stickers et étiquettes personnalisés sont conçus pour répondre à tous vos besoins en matière d\'identification ou de communication visuelle.', 'https://laptiteimprimerie.fr/stickers-et-etiquettes', 1, 1, 0, NULL, NULL, '2025-05-15 09:50:18', '2025-06-29 14:16:40'),
(2, 'Grands formats', NULL, 'Grands formats', 'img/icon/sve-icon7.png', 'Grands formats', 'Notre service grands formats propose des impressions de haute qualité, résistantes et adaptées à un usage intérieur comme extérieur.', 'https://laptiteimprimerie.fr/grands-formats', 1, 1, 0, NULL, NULL, '2025-05-15 09:51:24', '2025-05-23 13:10:47'),
(3, 'Plastification et reliure', NULL, 'Plastification et reliure', 'img/icon/sve-icon5.png', 'Plastification et reliure', 'Protégez, valorisez et donnez une finition professionnelle à vos documents grâce à nos services de plastification et de reliure.', 'https://laptiteimprimerie.fr/plastification-et-reliure', 3, 1, 0, NULL, NULL, '2025-05-15 09:51:56', '2025-05-23 13:11:12'),
(4, 'Impression et numérisation', 'impression-et-numerisation', 'Impression et numérisation', 'img/icon/sve-icon9.png', 'Impression et numérisation', 'icic', 'https://laptiteimprimerie.fr/impression-et-numerisation', 0, 1, 1, 'https://laptiteimprimerie.fr/print/upload', NULL, '2025-05-15 09:52:19', '2025-06-29 14:15:50'),
(5, 'Personnalisation textile et objets', NULL, 'Personnalisation textile et objets', 'img/icon/c_d01.png', 'Personnalisation textile et objets', 'Exprimez votre identité ou valorisez votre marque grâce à notre service de personnalisation sur textile et objets. Idéal pour les cadeaux personnalisés ou les événements.', 'https://laptiteimprimerie.fr/personnalisation-textile-et-objets', 5, 1, 0, NULL, NULL, '2025-05-21 07:44:42', '2025-05-23 13:11:33'),
(6, 'Impression 3D', 'impression-3d', 'Impression 3D', 'img/icon/sve-icon6.png', 'Impression 3D', 'Notre service d\'impression 3D vous permet de transformer vos idées en objets concrets.', 'https://laptiteimprimerie.fr/impression-3d', 6, 1, 1, NULL, NULL, '2025-05-21 07:45:27', '2025-06-22 18:49:19');

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

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('GBdmLtCzvGotOib1A8WPPUqLZO06qszZPPI3Zmrj', NULL, '39.52.105.229', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiSk1acng1OTV0MjZsdm5WQktMNTNQcDh3RzhkQVVJQUZLZERKNjE1UCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzQ6Imh0dHBzOi8vbGFwdGl0ZWltcHJpbWVyaWUuZnIvbG9naW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1750337162),
('h8w7oWdKZfTevd1FodeS2oAsLUFnEz6dv3rICiDP', NULL, '66.249.77.139', 'Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.7151.103 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoicVRYOGQ4UlpJUnVXVTh6bmJNNWg3RnU2RzM3QW0xbzVzOEV0UmNoSiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjg6Imh0dHBzOi8vbGFwdGl0ZWltcHJpbWVyaWUuZnIiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1750336212),
('LYhDC1iKqnEmbkAcDLjNiipS2dedKWx9czVebaOT', NULL, '63.34.144.45', 'Plesk screenshot bot https://support.plesk.com/hc/en-us/articles/10301006946066', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoicUJTSWJHbWt4empWUG9yWXBDaUlpUFZHdmFEa1ZrRnp1bExFOEoybSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjg6Imh0dHBzOi8vbGFwdGl0ZWltcHJpbWVyaWUuZnIiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1750332994),
('SwZnE3pFVv5C9qgaDALEtJrjHfy6WwTQsiS0zrJY', 2, '92.161.92.142', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36', 'YTo2OntzOjY6Il90b2tlbiI7czo0MDoiNllBM1BSOFUwZk5nNkJuQ2sxVlZoOXNSd1ZKNjQydDhSYjQxOEpFMiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTU6Imh0dHBzOi8vbGFwdGl0ZWltcHJpbWVyaWUuZnIvY2xpZW50L2NyZWF0ZS9QcmludFN5c3RlbXMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aToyO3M6MTU6ImN1cnJlbnRfcGFja2FnZSI7czoxMjoiUHJpbnRTeXN0ZW1zIjtzOjE0OiJwYXltZW50RW5hYmxlZCI7YjoxO30=', 1750338441);

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(11) NOT NULL,
  `shop_name` varchar(255) DEFAULT NULL,
  `company` varchar(255) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `country` varchar(100) DEFAULT NULL,
  `state` varchar(100) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `zip_code` varchar(20) DEFAULT NULL,
  `tax_id` varchar(50) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `shop_name`, `company`, `phone`, `email`, `country`, `state`, `city`, `address`, `zip_code`, `tax_id`, `created_at`, `updated_at`) VALUES
(1, 'La P\'tite imprimerie', 'Ardèche Laser Création', '0475874980', 'contact@laptiteimprimerie.fr', 'France', NULL, 'Saint Didier sous AUBENAS', 'CC Les Terres de Millet', '07200', 'FR10 529 127 789', '2025-03-13 11:40:02', '2025-06-26 07:14:35');

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

--
-- Table structure for table `taxes`
--

CREATE TABLE `taxes` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(100) NOT NULL,
  `percentage` decimal(5,2) NOT NULL DEFAULT 0.00,
  `priority` int(11) DEFAULT 1,
  `rules` text DEFAULT NULL,
  `status` enum('Published','Unpublished') DEFAULT 'Published',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `taxes`
--

INSERT INTO `taxes` (`id`, `name`, `percentage`, `priority`, `rules`, `status`, `created_at`, `updated_at`) VALUES
(2, 'TVA 20%', 20.00, 1, NULL, 'Published', '2025-06-03 06:58:26', '2025-06-03 06:58:26');

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

--
-- Table structure for table `tax_settings`
--

CREATE TABLE `tax_settings` (
  `id` int(11) NOT NULL,
  `enable_tax` tinyint(1) DEFAULT 0,
  `default_tax_id` int(10) UNSIGNED DEFAULT NULL,
  `display_price_including_tax` tinyint(1) DEFAULT 0,
  `display_company_invoice_fields` tinyint(1) DEFAULT 0,
  `display_tax_info_on_price` tinyint(1) DEFAULT 0,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `tax_settings`
--

INSERT INTO `tax_settings` (`id`, `enable_tax`, `default_tax_id`, `display_price_including_tax`, `display_company_invoice_fields`, `display_tax_info_on_price`, `updated_at`) VALUES
(1, 1, 2, 1, 1, 1, '2025-06-03 06:58:34');

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

--
-- Table structure for table `teams`
--

CREATE TABLE `teams` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `role` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `website` varchar(255) DEFAULT NULL,
  `bio` text DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `facebook` varchar(255) DEFAULT NULL,
  `twitter` varchar(255) DEFAULT NULL,
  `instagram` varchar(255) DEFAULT NULL,
  `skills` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`skills`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `teams`
--

INSERT INTO `teams` (`id`, `name`, `role`, `email`, `phone`, `address`, `website`, `bio`, `image`, `facebook`, `twitter`, `instagram`, `skills`, `created_at`, `updated_at`) VALUES
(1, 'Nicolas', 'Directeur et chef de projet', 'howard.holmes@example.com', '0612345678', '12 rue de Paris, 75001 Paris, France', 'https://howarddesigns.com', 'Designer passionné spécialisé en UI/UX avec 7 ans d\'expérience dans la création d\'interfaces intuitives.', 'teams/I0I5HDxQyW1MVTkPyydOHury2RAhsujETvKzgsXb.jpg', 'https://facebook.com/howardholmes', 'https://twitter.com/howardholmes', 'https://instagram.com/howardholmes', '[{\"name\":\"Figma\",\"level\":\"Expert\"},{\"name\":\"Photoshop\",\"level\":\"Moyen\"},{\"name\":\"Illustrator\",\"level\":\"Débutant\"}]', '2025-06-28 15:38:40', '2025-07-03 08:15:44'),
(2, 'Sylvie', 'Assistante d\'administration', 'ella.thompson@example.com', '0623456789', '45 avenue des Champs Elysées, 75008 Paris, France', 'https://elladev.com', 'Développeuse fullstack spécialisée en Laravel et Vue.js, aimant concevoir des applications performantes.', 'teams/fy3pskr65DLx1c4uFqy9shQszbHuwn3Flmibrjrz.png', 'https://facebook.com/ellathompson', 'https://twitter.com/ellathompson', 'https://instagram.com/ellathompson', '[{\"name\":\"Laravel\",\"level\":\"Expert\"},{\"name\":\"Vue.js\",\"level\":\"Moyen\"},{\"name\":\"MySQL\",\"level\":\"Expert\"}]', '2025-06-28 15:38:40', '2025-07-01 14:24:18');

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

--
-- Table structure for table `testimonials`
--

CREATE TABLE `testimonials` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `avatar` varchar(255) DEFAULT NULL,
  `quote` text NOT NULL,
  `name` varchar(255) NOT NULL,
  `designation` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `testimonials`
--

INSERT INTO `testimonials` (`id`, `avatar`, `quote`, `name`, `designation`, `created_at`, `updated_at`) VALUES
(1, 'frontend/img/testimonial/testi_avatar.png', '“Morbi nisi, tincidunt nec erat vitae, viverra porttitor lorem. Fusce tempor nunc at luctus blandit. Donec eget fermentum magna.we dedicate financial on services the teams serve all Curabitur ac tortor ante. Sed quis dignissim”', 'Margie Dosee', 'Web Developer', '2025-02-23 15:16:00', '2025-03-03 14:44:05'),
(2, 'frontend/img/testimonial/testi_avatar_02.png', '“Morbi neque nisi, tincidunt nec erat vitae, viverra porttitor lorem. Fusce tempor nunc at luctus blandit. Donec eget fermentum magna.we dedicate financial on services the teams serve all Curabitur ac tortor ante. Sed quis dignissim”', 'Jone Walker', 'Web Designer', '2025-02-23 15:16:00', '2025-02-23 15:16:00'),
(3, 'frontend/img/testimonial/testi_avatar_02.png', '“Morbi neque nisi, tincidunt nec erat vitae, viverra porttitor lorem. Fusce tempor nunc at luctus blandit. Donec eget fermentum magna.we dedicate financial on services the teams serve all Curabitur ac tortor ante. Sed quis dignissim”', 'Dose Robot', 'Web Developer', '2025-02-23 15:16:00', '2025-02-23 15:16:00'),
(4, 'frontend/img/testimonial/testi_avatar.png', '“Morbi neque nisi, tincidunt nec erat vitae, viverra porttitor lorem. Fusce tempor nunc at luctus blandit. Donec eget fermentum magna.we dedicate financial on services the teams serve all Curabitur ac tortor ante. Sed quis dignissim”', 'Jone Walker', 'Web Designer', '2025-02-23 15:16:00', '2025-02-23 15:16:00'),
(5, 'frontend/img/testimonial/testi_avatar_02.png', '“Morbi neque nisi, tincidunt nec erat vitae, viverra porttitor lorem. Fusce tempor nunc at luctus blandit. Donec eget fermentum magna.we dedicate financial on services the teams serve all Curabitur ac tortor ante. Sed quis dignissim”', 'Margie Dose', 'Web Developer', '2025-02-23 15:16:00', '2025-02-23 15:16:00'),
(6, 'frontend/img/testimonial/testi_avatar.png', '“Morbi neque nisi, tincidunt nec erat vitae, viverra porttitor lorem. Fusce tempor nunc at luctus blandit. Donec eget fermentum magna.we dedicate financial on services the teams serve all Curabitur ac tortor ante. Sed quis dignissim”', 'Jone Walker', 'Web Designer', '2025-02-23 15:16:00', '2025-02-23 15:16:00');

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

--
-- Table structure for table `three_services`
--

CREATE TABLE `three_services` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `icon` varchar(255) NOT NULL,
  `order` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `three_services`
--

INSERT INTO `three_services` (`id`, `title`, `description`, `icon`, `order`, `created_at`, `updated_at`) VALUES
(1, 'Importez', 'Commencez par téléverser votre fichier prêt à être imprimer (PDF ou JPG.).', 'uploads/icons/1740401176_service_icon_1.png', 1, '2025-02-23 15:16:45', '2025-05-16 07:53:13'),
(2, 'Personnalisez', 'Choisissez le format souhaité, le nombre d\'exemplaires, ainsi que les options d\'impressions.', 'uploads/icons/1740401163_service_icon_2.png', 2, '2025-02-23 15:16:45', '2025-05-16 07:55:00'),
(3, 'Validez', 'Entrez vos informations de livraison et réglez votre commande en ligne.', 'uploads/icons/1740401163_service_icon_3.png', 3, '2025-02-23 15:16:45', '2025-05-16 07:56:33'),
(4, 'Imprimez', 'Lancez l\'impression et venez récupérer votre commande en magasin.', 'uploads/icons/1740401163_service_icon_4.png', 4, '2025-02-23 15:16:45', '2025-05-16 08:23:44');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `about`
--
ALTER TABLE `about`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `activity_logs`
--
ALTER TABLE `activity_logs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `applications`
--
ALTER TABLE `applications`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `folder_name` (`folder_name`);

--
-- Indexes for table `body_slider`
--
ALTER TABLE `body_slider`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `brands`
--
ALTER TABLE `brands`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `business_cards`
--
ALTER TABLE `business_cards`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cart_settings`
--
ALTER TABLE `cart_settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `parent_id` (`parent_id`);

--
-- Indexes for table `clients`
--
ALTER TABLE `clients`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `clients_2`
--
ALTER TABLE `clients_2`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `email` (`email`);

--
-- Indexes for table `cookie_consents`
--
ALTER TABLE `cookie_consents`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cta`
--
ALTER TABLE `cta`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `ecommerce_seos`
--
ALTER TABLE `ecommerce_seos`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `emails`
--
ALTER TABLE `emails`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `faqs`
--
ALTER TABLE `faqs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `files`
--
ALTER TABLE `files`
  ADD PRIMARY KEY (`id`),
  ADD KEY `files_order_id_foreign` (`order_id`);

--
-- Indexes for table `footer`
--
ALTER TABLE `footer`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `galleries`
--
ALTER TABLE `galleries`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `general_settings`
--
ALTER TABLE `general_settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `google_analytics_settings`
--
ALTER TABLE `google_analytics_settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `headers`
--
ALTER TABLE `headers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

--
-- Indexes for table `job_batches`
--
ALTER TABLE `job_batches`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `layout_settings`
--
ALTER TABLE `layout_settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `menu_items`
--
ALTER TABLE `menu_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `menu_items_parent_id_foreign` (`parent_id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `newsletters`
--
ALTER TABLE `newsletters`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `online_print_settings`
--
ALTER TABLE `online_print_settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `order_items`
--
ALTER TABLE `order_items`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `pages`
--
ALTER TABLE `pages`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `slug` (`slug`),
  ADD UNIQUE KEY `unique_slug` (`slug`);

--
-- Indexes for table `posts`
--
ALTER TABLE `posts`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `posts_slug_unique` (`slug`);

--
-- Indexes for table `prices`
--
ALTER TABLE `prices`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_price_category` (`category_id`),
  ADD KEY `fk_price_sub_category` (`sub_category_id`);

--
-- Indexes for table `pricing`
--
ALTER TABLE `pricing`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `print_calibrations`
--
ALTER TABLE `print_calibrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `print_methods`
--
ALTER TABLE `print_methods`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `sections`
--
ALTER TABLE `sections`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `sections_name_unique` (`name`);

--
-- Indexes for table `services`
--
ALTER TABLE `services`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `services_menu`
--
ALTER TABLE `services_menu`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `taxes`
--
ALTER TABLE `taxes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tax_settings`
--
ALTER TABLE `tax_settings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `default_tax_id` (`default_tax_id`);

--
-- Indexes for table `teams`
--
ALTER TABLE `teams`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `testimonials`
--
ALTER TABLE `testimonials`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `three_services`
--
ALTER TABLE `three_services`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `about`
--
ALTER TABLE `about`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `activity_logs`
--
ALTER TABLE `activity_logs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `applications`
--
ALTER TABLE `applications`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- AUTO_INCREMENT for table `body_slider`
--
ALTER TABLE `body_slider`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `brands`
--
ALTER TABLE `brands`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `business_cards`
--
ALTER TABLE `business_cards`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cart_settings`
--
ALTER TABLE `cart_settings`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `clients`
--
ALTER TABLE `clients`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=129;

--
-- AUTO_INCREMENT for table `clients_2`
--
ALTER TABLE `clients_2`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `cookie_consents`
--
ALTER TABLE `cookie_consents`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `cta`
--
ALTER TABLE `cta`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `ecommerce_seos`
--
ALTER TABLE `ecommerce_seos`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `emails`
--
ALTER TABLE `emails`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `faqs`
--
ALTER TABLE `faqs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `files`
--
ALTER TABLE `files`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `footer`
--
ALTER TABLE `footer`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `galleries`
--
ALTER TABLE `galleries`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `general_settings`
--
ALTER TABLE `general_settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `google_analytics_settings`
--
ALTER TABLE `google_analytics_settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `headers`
--
ALTER TABLE `headers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `layout_settings`
--
ALTER TABLE `layout_settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `menu_items`
--
ALTER TABLE `menu_items`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `newsletters`
--
ALTER TABLE `newsletters`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `online_print_settings`
--
ALTER TABLE `online_print_settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=117;

--
-- AUTO_INCREMENT for table `order_items`
--
ALTER TABLE `order_items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=195;

--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- AUTO_INCREMENT for table `posts`
--
ALTER TABLE `posts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `prices`
--
ALTER TABLE `prices`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=189;

--
-- AUTO_INCREMENT for table `pricing`
--
ALTER TABLE `pricing`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `print_calibrations`
--
ALTER TABLE `print_calibrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `print_methods`
--
ALTER TABLE `print_methods`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `sections`
--
ALTER TABLE `sections`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `services`
--
ALTER TABLE `services`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `services_menu`
--
ALTER TABLE `services_menu`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `taxes`
--
ALTER TABLE `taxes`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `teams`
--
ALTER TABLE `teams`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `testimonials`
--
ALTER TABLE `testimonials`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `three_services`
--
ALTER TABLE `three_services`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `categories`
--
ALTER TABLE `categories`
  ADD CONSTRAINT `categories_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `menu_items`
--
ALTER TABLE `menu_items`
  ADD CONSTRAINT `menu_items_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `menu_items` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `prices`
--
ALTER TABLE `prices`
  ADD CONSTRAINT `fk_price_category` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_price_sub_category` FOREIGN KEY (`sub_category_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `tax_settings`
--
ALTER TABLE `tax_settings`
  ADD CONSTRAINT `tax_settings_ibfk_1` FOREIGN KEY (`default_tax_id`) REFERENCES `taxes` (`id`) ON DELETE SET NULL;
COMMIT;

