-- https://www.phpmyadmin.net/
--
-- Hôte : 127.0.0.1:3306
-- Généré le : mar. 02 déc. 2025 à 09:19
-- Version du serveur : 9.1.0
-- Version de PHP : 8.3.14

START TRANSACTION;



--
-- Base de données : `negoce-app`
--

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

--
-- Structure de la table `categories`
--

CREATE TABLE IF NOT EXISTS `categories` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `nom` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `coefficient` double DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `categories_nom_unique` (`nom`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `categories`
--

INSERT INTO `categories` (`id`, `nom`, `created_at`, `updated_at`) VALUES
(1, 'Coulissants', '2025-08-28 07:10:32', '2025-08-28 07:10:32'),
(2, 'Battants', '2025-08-28 07:10:32', '2025-08-28 07:10:32'),
(3, 'Portillons', '2025-08-28 07:10:32', '2025-08-28 07:10:32'),
(4, 'Clôture aluminium', '2025-08-28 07:10:32', '2025-08-28 07:10:32'),
(5, 'Profils', '2025-08-28 07:10:32', '2025-08-28 07:10:32'),
(6, 'Poteau au détail', '2025-08-28 07:10:32', '2025-09-01 12:40:01');

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

--
-- Structure de la table `commandes`
--

CREATE TABLE IF NOT EXISTS `commandes` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `devi_id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `role_id` bigint UNSIGNED NOT NULL,
  `entreprise_id` bigint UNSIGNED NOT NULL,
  `reference_client` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `etat` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `commandes_reference_client_unique` (`reference_client`),
  KEY `commandes_devi_id_foreign` (`devi_id`),
  KEY `commandes_user_id_foreign` (`user_id`),
  KEY `commandes_role_id_foreign` (`role_id`),
  KEY `commandes_entreprise_id_foreign` (`entreprise_id`)
) ENGINE=MyISAM AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `commandes`
--

INSERT INTO `commandes` (`id`, `devi_id`, `user_id`, `role_id`, `entreprise_id`, `reference_client`, `etat`, `created_at`, `updated_at`) VALUES
(1, 46, 19, 2, 14, 'PEIO 1', 'Livrée', '2024-10-04 07:12:38', '2025-09-09 13:39:50'),
(2, 45, 19, 2, 14, 'BARONE', 'Livrée', '2024-10-04 07:13:38', '2025-09-09 13:39:35'),
(3, 44, 19, 2, 14, 'LABACHOT', 'Livrée', '2024-11-25 08:05:56', '2025-09-09 13:40:19'),
(4, 43, 19, 2, 14, 'GOMEZ 1', 'Livrée', '2024-11-25 08:06:56', '2025-09-09 13:40:37'),
(5, 42, 19, 2, 14, 'GOMEZ 2', 'Livrée', '2024-11-25 08:07:56', '2025-09-09 13:40:40'),
(6, 41, 19, 2, 14, 'CASTAINGT 1', 'Livrée', '2024-12-05 05:55:20', '2025-09-09 13:40:57'),
(7, 40, 19, 2, 14, 'ANDRE 1', 'Livrée', '2024-12-05 06:55:20', '2025-09-09 13:41:27'),
(8, 39, 19, 2, 14, 'ANDRE 2', 'Livrée', '2024-12-05 07:55:20', '2025-09-09 13:41:30'),
(9, 38, 19, 2, 14, 'BOUIGUE', 'Livrée', '2025-01-10 07:50:09', '2025-09-09 13:41:43'),
(10, 49, 19, 2, 14, 'DULHOSTE', 'Livrée', '2025-01-21 14:10:58', '2025-09-09 13:41:56'),
(11, 37, 19, 2, 14, 'PEIO', 'Livrée', '2025-02-14 12:02:09', '2025-09-09 13:39:55'),
(12, 36, 19, 2, 14, 'FEVRE', 'Livrée', '2025-02-14 13:02:09', '2025-09-09 13:42:08'),
(13, 35, 19, 2, 14, 'CASTAINGT', 'Livrée', '2025-02-14 14:59:31', '2025-09-09 13:41:02'),
(14, 34, 19, 2, 14, 'CLAVERIE', 'Livrée', '2025-03-04 14:57:00', '2025-09-09 13:42:27'),
(15, 48, 19, 2, 14, 'PEDRO 1', 'Livrée', '2025-03-31 09:09:00', '2025-09-09 13:42:46'),
(16, 47, 19, 2, 14, 'PEDRO 2', 'Livrée', '2025-03-31 09:10:00', '2025-09-09 13:42:43'),
(17, 33, 19, 2, 14, 'MAUVOISIN', 'Livrée', '2025-03-31 12:29:35', '2025-09-09 13:42:57'),
(18, 32, 19, 2, 14, 'FEVRE 2', 'Livrée', '2025-03-31 13:27:17', '2025-09-09 13:43:07'),
(19, 31, 19, 2, 14, 'AUDEBERT', 'Livrée', '2025-04-09 13:25:57', '2025-09-09 13:43:25'),
(20, 30, 19, 2, 14, 'DUPEY 1', 'Livrée', '2025-04-24 08:24:40', '2025-09-09 13:43:36'),
(21, 29, 19, 2, 14, 'DUPEY 2', 'Livrée', '2025-04-24 09:23:03', '2025-09-09 13:43:39'),
(22, 28, 19, 2, 14, 'DUPEY 3', 'Livrée', '2025-04-24 10:05:36', '2025-09-09 13:43:42'),
(23, 27, 19, 2, 14, 'DUPEY 4', 'Livrée', '2025-04-24 10:06:27', '2025-09-09 13:43:44'),
(24, 25, 19, 2, 14, 'SAINT AMON', 'Livrée', '2025-05-07 07:33:11', '2025-09-09 13:44:00'),
(25, 26, 19, 2, 14, 'MARTIN', 'Reçue', '2025-05-07 10:02:33', '2025-09-09 13:48:52'),
(26, 24, 19, 2, 14, 'GOD DAVID', 'Reçue', '2025-05-19 07:31:40', '2025-09-09 13:46:37'),
(27, 23, 19, 2, 14, 'FERREIRA', 'Livrée', '2025-05-23 06:24:52', '2025-09-09 13:46:29'),
(28, 22, 19, 2, 14, 'GOD KILIAN', 'Livrée', '2025-05-23 06:53:13', '2025-09-09 13:46:47'),
(29, 21, 19, 2, 14, 'GALLARDO', 'Livrée', '2025-06-25 10:32:06', '2025-09-09 13:46:56'),
(30, 20, 19, 2, 14, 'GALLARDO 2', 'Livrée', '2025-06-25 11:29:06', '2025-09-09 13:46:58'),
(31, 19, 19, 2, 14, 'BAKHALOU', 'Livrée', '2025-06-25 12:24:20', '2025-09-09 13:47:06'),
(32, 18, 19, 2, 14, 'VAZ', 'Livrée', '2025-07-11 12:10:14', '2025-09-09 13:47:14'),
(33, 17, 19, 2, 14, 'GUIRAUTON', 'Livrée', '2025-07-11 12:12:51', '2025-09-09 13:47:21'),
(34, 16, 19, 2, 14, 'CATALANO', 'Livrée', '2025-07-28 12:06:41', '2025-09-09 13:47:26'),
(35, 15, 19, 2, 14, 'G/RENOVATION', 'Livrée', '2025-07-28 12:07:41', '2025-09-09 13:59:33'),
(36, 14, 19, 2, 14, 'DUPLA', 'Livrée', '2025-07-31 12:06:10', '2025-09-09 13:47:49'),
(37, 12, 19, 2, 14, 'MORA', 'Livrée', '2025-08-06 11:56:43', '2025-09-09 13:47:59'),
(38, 13, 19, 2, 14, 'CAMIADE', 'Livrée', '2025-08-06 12:00:32', '2025-09-09 13:48:11');

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

--
-- Structure de la table `couleurs`
--

CREATE TABLE IF NOT EXISTS `couleurs` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `nom` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code_couleur` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `couleurs_nom_unique` (`nom`),
  UNIQUE KEY `couleurs_code_couleur_unique` (`code_couleur`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `couleurs`
--

INSERT INTO `couleurs` (`id`, `nom`, `code_couleur`, `image`, `created_at`, `updated_at`) VALUES
(1, 'RAL 9016 BLANC', '#F3F6F6', NULL, '2025-08-28 07:10:32', '2025-08-28 07:10:32'),
(2, 'RAL 1015 IVOIRE', '#E6D9BD', NULL, '2025-08-28 07:10:32', '2025-08-28 07:10:32'),
(3, 'RAL 3004 ROUGE', '#6C1B2A', NULL, '2025-08-28 07:10:32', '2025-08-28 07:10:32'),
(4, 'RAL 8014 BRUN', '#49372A', NULL, '2025-08-28 07:10:32', '2025-08-28 07:10:32'),
(5, 'RAL 6005 VERT', '#0E4438', NULL, '2025-08-28 07:10:32', '2025-08-28 07:10:32'),
(6, 'RAL 5003 BLEU', '#193058', NULL, '2025-08-28 07:10:32', '2025-08-28 07:10:32'),
(7, 'RAL 7016 GRIS', '#363D43', NULL, '2025-08-28 07:10:32', '2025-08-28 07:10:32'),
(8, 'RAL 9005 NOIR', '#151619', NULL, '2025-08-28 07:10:32', '2025-08-28 07:10:32'),
(9, 'RAL 9006 GRIS ALU', '#A5A8A6', NULL, '2025-08-28 07:10:32', '2025-08-28 07:10:32'),
(10, 'RAL 7006 GRIS BEIGE', '#6D6552', NULL, '2025-09-01 09:05:31', '2025-09-01 09:05:31'),
(11, 'RAL 7030 GRIS PIERRE', '#928E85', NULL, '2025-09-01 09:12:54', '2025-09-01 09:12:54'),
(12, 'RAL 2900 GRIS SABLÉ', NULL, NULL, '2025-09-02 09:08:13', '2025-09-04 08:04:49'),
(13, 'RAL 200 SABLÉ', NULL, NULL, '2025-09-08 13:10:12', '2025-09-08 13:11:19');

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

--
-- Structure de la table `decoupes`
--

CREATE TABLE IF NOT EXISTS `decoupes` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `nom` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `decoupes`
--

INSERT INTO `decoupes` (`id`, `nom`, `image`, `created_at`, `updated_at`) VALUES
(3, 'BRA-1', '3kO1uvgK0Dq244nhIWgNLa8wQsHcAbknEAbYOiyC.jpg', '2025-07-22 08:40:19', '2025-07-22 08:40:19'),
(4, 'BRA-2', 'INGIEKXm4Q28VpWMd7JsbDt3kJSFsW0DFFjcf23o.jpg', '2025-07-22 08:40:32', '2025-07-22 08:40:32'),
(5, 'BRA-3', 'Ppl1jxp9o2bXdfjTPRLzpIXjWpIqrxb82mzZQyQH.jpg', '2025-07-22 08:40:40', '2025-07-22 08:40:40'),
(6, 'DECOUPE LASER PERSO', '3u0CkvQl2Jg2S7cdA4RNSkSHDjMII1TwDZK7DnHr.jpg', '2025-07-22 08:40:46', '2025-07-29 10:58:34'),
(7, 'FE-1', '67Nmd4OT4MrN2JQkwyhTLyAVgaZdQK4buFfrEQYt.jpg', '2025-07-22 08:40:54', '2025-07-22 08:40:54'),
(8, 'FE-2', 'xgIomgMyQrkWxy3sNsNrQVhB2PnMXho9rSqTVCWg.jpg', '2025-07-22 08:41:01', '2025-07-22 08:41:01'),
(9, 'FE-3', 'E7av4CCM8nodo3IDwYKlXo5YnPgRgJUYacgRPAZ7.jpg', '2025-07-22 08:41:09', '2025-07-22 08:41:09'),
(10, 'FE-4', 'uAmPhsZ5BzICLLCv5eIqOIoudYGyZsR7EuouynZY.jpg', '2025-07-22 08:41:16', '2025-07-22 08:41:16'),
(11, 'FRIS-1', 'ltZE73pcB7jz514B6t81xwnRbzMQJ5qM6qtLntGu.jpg', '2025-07-22 08:41:26', '2025-07-22 08:41:26'),
(12, 'GEO-1', 'zQx30gOTF7uko9KJff22wbRAAzQEZTU2E8ekA7Pw.jpg', '2025-07-22 08:41:34', '2025-07-22 08:41:34'),
(13, 'GEO-2', '3EIxqnQYKRGbKhiQgD4ub8IPbgfT4zySMf1h2AxR.jpg', '2025-07-22 08:41:42', '2025-07-22 08:41:42'),
(14, 'GEO-3', 'SwEnMttnQBoBFjSEzSK4XU45tOCSgsI36TqPMxP2.jpg', '2025-07-22 08:41:49', '2025-07-22 08:41:49'),
(15, 'PALM-1', 'rS6SCBBigapMx2kskqtA2gCE87sT8anicVus2daL.png', '2025-07-22 08:41:56', '2025-07-22 08:41:56'),
(16, 'PALM-2', 'crHPVIWKRf2fFCOjlZUtf0s6AmjccpUzFviajVRM.png', '2025-07-22 08:42:04', '2025-07-22 08:42:04'),
(17, 'PE-1', 'VSC3MaNDiADlzLX13O5WztNhmxk6Gd0uqv3wMYxO.jpg', '2025-07-22 08:42:12', '2025-07-22 08:42:12'),
(18, 'PE-2', 'mX2kI0K3tQPl2IdHvlf3kpRM55TXbA3lZHnVyFMZ.jpg', '2025-07-22 08:42:22', '2025-07-22 08:42:22'),
(19, 'ROND-1', 'ODPLMp8XdkdJWDGU6bO3lIUTRMtwocmggouVtVyq.jpg', '2025-07-22 08:42:30', '2025-07-22 08:42:30');

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

--
-- Structure de la table `demandes`
--

CREATE TABLE IF NOT EXISTS `demandes` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `modele_id` bigint UNSIGNED NOT NULL,
  `couleur_id` bigint UNSIGNED NOT NULL,
  `longueur` int DEFAULT NULL,
  `hauteur` int DEFAULT NULL,
  `quantite` int NOT NULL,
  `prix` double DEFAULT NULL,
  `finition` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sens_ouverture` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `poignee` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gonds` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gache` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `piece_jointe` json DEFAULT NULL,
  `inox_id` bigint UNSIGNED DEFAULT NULL,
  `decoupe_id` bigint UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `demandes_modele_id_foreign` (`modele_id`),
  KEY `demandes_couleur_id_foreign` (`couleur_id`),
  KEY `demandes_inox_id_foreign` (`inox_id`),
  KEY `demandes_decoupe_id_foreign` (`decoupe_id`)
) ENGINE=MyISAM AUTO_INCREMENT=111 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `demandes`
--

INSERT INTO `demandes` (`id`, `modele_id`, `couleur_id`, `longueur`, `hauteur`, `quantite`, `prix`, `finition`, `sens_ouverture`, `poignee`, `gonds`, `gache`, `description`, `piece_jointe`, `inox_id`, `decoupe_id`, `created_at`, `updated_at`) VALUES
(52, 7, 1, 3000, 1200, 1, 1143, 'Sablé', 'Droite', 'Non', NULL, NULL, NULL, NULL, NULL, NULL, '2025-08-06 11:56:43', '2025-08-29 11:56:43'),
(53, 1, 7, 3100, 900, 1, 841, 'Sablé', 'Droite', 'Oui', NULL, NULL, NULL, NULL, NULL, NULL, '2025-08-29 12:00:32', '2025-08-29 12:00:32'),
(54, 15, 1, 3350, 1250, 1, 1178, 'Sablé', NULL, 'Oui', 'Réglables', NULL, NULL, NULL, NULL, NULL, '2025-08-29 12:06:10', '2025-08-29 12:06:10'),
(55, 12, 7, 3790, 1300, 1, 1330, 'Sablé', NULL, 'Oui', 'Réglables', NULL, NULL, NULL, NULL, NULL, '2025-08-29 12:07:41', '2025-08-29 12:07:41'),
(56, 9, 1, 3500, 1200, 1, 1295, 'Mât', 'Gauche', 'Oui', NULL, NULL, NULL, NULL, NULL, NULL, '2025-08-29 12:08:45', '2025-08-29 12:08:45'),
(57, 7, 5, 3800, 1500, 1, 1572, 'Sablé', 'Gauche', 'Oui', NULL, NULL, NULL, NULL, NULL, NULL, '2025-08-29 12:12:51', '2025-08-29 12:12:51'),
(58, 3, 7, 4000, 1300, 1, 1387, 'Sablé', 'Droite', 'Oui', NULL, NULL, NULL, NULL, 15, NULL, '2025-08-29 12:16:14', '2025-08-29 12:16:14'),
(59, 3, 7, 3500, 1700, 1, 1453, 'Sablé', 'Gauche', 'Oui', NULL, NULL, NULL, NULL, NULL, NULL, '2025-08-29 12:24:20', '2025-08-29 12:24:20'),
(60, 25, 7, 1000, 1420, 1, 509, 'Sablé', 'Gauche', 'Oui', 'Traditionnels', 'Oui', NULL, NULL, NULL, NULL, '2025-08-29 12:29:06', '2025-08-29 12:29:06'),
(61, 3, 7, 4000, 1500, 1, 1422, 'Sablé', 'Gauche', 'Oui', NULL, NULL, NULL, NULL, NULL, NULL, '2025-08-29 12:32:06', '2025-08-29 12:32:06'),
(62, 3, 10, 4140, 1600, 1, 1580, 'Sablé', 'Droite', 'Oui', NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-01 06:53:13', '2025-09-01 06:53:13'),
(63, 10, 4, 3420, 1320, 1, 1275, 'Mât', 'Droite', 'Non', NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-01 07:24:52', '2025-09-01 07:24:52'),
(64, 32, 4, 1015, 1310, 1, 596, 'Mât', 'Gauche', 'Oui', 'Réglables', 'Non', NULL, NULL, NULL, NULL, '2025-09-01 07:24:52', '2025-09-01 07:24:52'),
(65, 47, 4, NULL, NULL, 3, 297.6, 'Mât', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-01 07:24:52', '2025-09-01 07:24:52'),
(66, 45, 4, NULL, NULL, 15, 172.5, 'Mât', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-01 07:24:52', '2025-09-01 07:24:52'),
(67, 46, 4, NULL, NULL, 15, 208.5, 'Mât', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-01 07:24:52', '2025-09-01 07:24:52'),
(68, 39, 4, NULL, NULL, 21, 1018.5, 'Mât', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-01 07:24:52', '2025-09-01 07:24:52'),
(69, 34, 4, NULL, NULL, 4, 53.6, 'Mât', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-01 07:24:52', '2025-09-01 07:24:52'),
(70, 14, 11, 3100, 1600, 1, 1337, 'Mât', NULL, 'Oui', 'Réglables', NULL, NULL, NULL, NULL, NULL, '2025-09-01 07:31:40', '2025-09-01 07:31:40'),
(71, 2, 7, 3020, 1500, 1, 1180, 'Sablé', 'Droite', 'Oui', NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-01 07:33:11', '2025-09-01 07:33:11'),
(72, 3, 7, 4000, 1400, 1, 1383, 'Sablé', 'Droite', 'Oui', NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-01 10:02:33', '2025-09-01 10:02:33'),
(73, 65, 7, 1500, NULL, 2, 430, 'Sablé', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-01 10:02:33', '2025-09-01 10:02:33'),
(74, 23, 1, 880, 1180, 1, 410, 'Mât', 'Gauche', 'Oui', 'Réglables', 'Non', NULL, NULL, NULL, NULL, '2025-09-01 10:06:27', '2025-09-01 10:06:27'),
(75, 39, 1, NULL, NULL, 13, 630.5, 'Mât', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-01 10:13:36', '2025-09-01 10:13:36'),
(76, 47, 1, NULL, NULL, 2, 198.4, 'Mât', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-01 10:13:36', '2025-09-01 10:13:36'),
(77, 34, 1, NULL, NULL, 2, 26.8, 'Mât', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-01 10:13:36', '2025-09-01 10:13:36'),
(78, 45, 1, NULL, NULL, 8, 92, 'Mât', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-01 10:13:36', '2025-09-01 10:13:36'),
(79, 46, 1, NULL, NULL, 8, 111.2, 'Mât', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-01 10:13:36', '2025-09-01 10:13:36'),
(80, 1, 1, 2480, 1250, 1, 904, 'Mât', 'Gauche', 'Oui', NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-01 13:23:03', '2025-09-01 13:23:03'),
(81, 1, 1, 2660, 1250, 1, 947, 'Mât', 'Gauche', 'Oui', NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-01 13:24:40', '2025-09-01 13:24:40'),
(82, 7, 1, 3050, 1600, 1, 1407, 'Sablé', 'Droite', 'Oui', NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-01 13:25:57', '2025-09-01 13:25:57'),
(83, 24, 1, 1000, 1050, 1, 413, 'Sablé', 'Droite', 'Oui', 'Réglables', 'Non', NULL, NULL, NULL, NULL, '2025-09-01 13:27:17', '2025-09-01 13:27:17'),
(84, 3, 1, 3500, 1800, 1, 1520, 'Sablé', 'Gauche', 'Oui', NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-01 13:29:35', '2025-09-01 13:29:35'),
(85, 19, 7, 3985, 950, 1, 1096, 'Sablé', NULL, 'Oui', 'Réglables', NULL, NULL, NULL, NULL, NULL, '2025-09-01 13:57:00', '2025-09-01 13:57:00'),
(86, 31, 7, 964, 1500, 1, 628, 'Sablé', 'Gauche', 'Oui', 'Traditionnels', 'Non', NULL, NULL, NULL, NULL, '2025-09-01 13:59:31', '2025-09-01 13:59:31'),
(87, 1, 1, 2950, 1200, 1, 988, 'Sablé', 'Droite', 'Oui', NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-01 14:02:09', '2025-09-01 14:02:09'),
(88, 13, 5, 3190, 900, 1, 909, 'Mât', NULL, 'Oui', 'Réglables', NULL, NULL, NULL, NULL, NULL, '2025-09-01 14:03:32', '2025-09-01 14:03:32'),
(89, 42, 1, NULL, NULL, 12, 1258.8, 'Sablé', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 06:50:09', '2025-09-02 06:50:09'),
(90, 41, 1, NULL, NULL, 3, 282, 'Sablé', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 06:50:09', '2025-09-02 06:50:09'),
(91, 36, 1, NULL, NULL, 3, 282, 'Sablé', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 06:50:09', '2025-09-02 06:50:09'),
(92, 47, 1, NULL, NULL, 3, 297.6, 'Sablé', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 06:50:09', '2025-09-02 06:50:09'),
(93, 34, 1, NULL, NULL, 3, 40.2, 'Sablé', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 06:50:09', '2025-09-02 06:50:09'),
(94, 45, 1, NULL, NULL, 14, 161, 'Sablé', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 06:50:09', '2025-09-02 06:50:09'),
(95, 46, 1, NULL, NULL, 14, 194.6, 'Sablé', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 06:50:09', '2025-09-02 06:50:09'),
(96, 25, 7, 1020, 1300, 1, 485, 'Sablé', 'Droite', 'Oui', 'Réglables', 'Non', NULL, NULL, NULL, NULL, '2025-09-02 06:55:20', '2025-09-02 06:55:20'),
(97, 3, 7, 3030, 1340, 1, 1088, 'Sablé', 'Gauche', 'Oui', NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 06:56:53', '2025-09-02 06:56:53'),
(98, 9, 7, 4000, 1600, 1, 1745, 'Sablé', 'Gauche', 'Oui', NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 07:03:58', '2025-09-02 07:03:58'),
(99, 24, 8, 950, 1020, 1, 392, 'Mât', 'Gauche', 'Oui', 'Réglables', 'Non', NULL, NULL, NULL, NULL, '2025-09-02 07:07:56', '2025-09-02 07:07:56'),
(100, 13, 8, 2820, 1050, 1, 927, 'Mât', NULL, 'Oui', 'Réglables', NULL, NULL, NULL, NULL, NULL, '2025-09-02 07:09:25', '2025-09-02 07:09:25'),
(101, 3, 7, 3980, 1600, 1, 1620, 'Mât', 'Gauche', 'Oui', NULL, NULL, NULL, NULL, 1, NULL, '2025-09-02 07:11:21', '2025-09-02 07:11:21'),
(102, 8, 7, 3500, 1200, 1, 1114, 'Mât', 'Gauche', 'Oui', NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 07:13:38', '2025-09-02 07:13:38'),
(103, 24, 5, 800, 900, 1, 327, 'Mât', 'Gauche', 'Oui', 'Réglables', 'Non', NULL, NULL, NULL, NULL, '2025-09-02 07:15:32', '2025-09-02 07:15:32'),
(104, 27, 12, 1010, 1500, 1, 534, 'Sablé', 'Gauche', 'Oui', 'Réglables', 'Non', NULL, NULL, NULL, NULL, '2025-03-31 09:10:00', '2025-09-02 09:10:00'),
(105, 16, 12, 4010, 1600, 1, 1635, 'Sablé', NULL, 'Oui', 'Réglables', NULL, NULL, NULL, NULL, NULL, '2025-09-02 09:11:44', '2025-09-02 09:11:44'),
(106, 66, 13, 9500, 1760, 1, 3820, 'Sablé', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-08 13:10:58', '2025-09-08 13:10:58'),
(110, 12, 7, 3500, 1500, 1, 1497, 'Sablé', NULL, 'Oui', 'Réglables', NULL, NULL, NULL, 4, NULL, '2025-12-02 08:31:53', '2025-12-02 08:31:53');

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

--
-- Structure de la table `demande_devi`
--

CREATE TABLE IF NOT EXISTS `demande_devi` (
  `devi_id` bigint UNSIGNED NOT NULL,
  `demande_id` bigint UNSIGNED NOT NULL,
  KEY `demande_devi_devi_id_foreign` (`devi_id`),
  KEY `demande_devi_demande_id_foreign` (`demande_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `demande_devi`
--

INSERT INTO `demande_devi` (`devi_id`, `demande_id`) VALUES
(18, 58),
(17, 57),
(16, 56),
(15, 55),
(14, 54),
(13, 53),
(12, 52),
(21, 61),
(20, 60),
(19, 59),
(22, 62),
(23, 63),
(23, 64),
(23, 65),
(23, 66),
(23, 67),
(23, 68),
(23, 69),
(24, 70),
(25, 71),
(26, 72),
(26, 73),
(27, 74),
(28, 75),
(28, 76),
(28, 77),
(28, 78),
(28, 79),
(29, 80),
(30, 81),
(31, 82),
(32, 83),
(33, 84),
(34, 85),
(35, 86),
(36, 87),
(37, 88),
(38, 89),
(38, 90),
(38, 91),
(38, 92),
(38, 93),
(38, 94),
(38, 95),
(39, 96),
(40, 97),
(41, 98),
(42, 99),
(43, 100),
(44, 101),
(45, 102),
(46, 103),
(47, 104),
(48, 105),
(49, 106),
(53, 110);

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

--
-- Structure de la table `devis`
--

CREATE TABLE IF NOT EXISTS `devis` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` bigint UNSIGNED NOT NULL,
  `role_id` bigint UNSIGNED NOT NULL,
  `entreprise_id` bigint UNSIGNED NOT NULL,
  `reference_client` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `etat` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `devis_reference_client_unique` (`reference_client`),
  KEY `devis_user_id_foreign` (`user_id`),
  KEY `devis_role_id_foreign` (`role_id`),
  KEY `devis_entreprise_id_foreign` (`entreprise_id`)
) ENGINE=MyISAM AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `devis`
--

INSERT INTO `devis` (`id`, `user_id`, `role_id`, `entreprise_id`, `reference_client`, `etat`, `created_at`, `updated_at`) VALUES
(12, 19, 2, 14, 'MORA', 'Validé', '2025-08-06 11:56:43', '2025-09-09 09:11:59'),
(13, 19, 2, 14, 'CAMIADE', 'Validé', '2025-08-06 12:00:32', '2025-09-09 09:12:00'),
(14, 19, 2, 14, 'DUPLA', 'Validé', '2025-07-31 12:06:10', '2025-09-09 09:11:57'),
(15, 19, 2, 14, 'G/RENOVATION', 'Validé', '2025-07-28 12:07:41', '2025-09-09 09:11:54'),
(16, 19, 2, 14, 'CATALANO', 'Validé', '2025-07-28 12:06:41', '2025-09-09 09:11:52'),
(17, 19, 2, 14, 'GUIRAUTON', 'Validé', '2025-07-11 12:12:51', '2025-09-09 09:11:50'),
(18, 19, 2, 14, 'VAZ', 'Validé', '2025-07-11 12:10:14', '2025-09-09 09:11:47'),
(19, 19, 2, 14, 'BAKHALOU', 'Validé', '2025-06-25 12:24:20', '2025-09-09 09:11:45'),
(20, 19, 2, 14, 'GALLARDO 2', 'Validé', '2025-06-25 11:29:06', '2025-09-09 09:11:42'),
(21, 19, 2, 14, 'GALLARDO', 'Validé', '2025-06-25 10:32:06', '2025-09-09 09:11:39'),
(22, 19, 2, 14, 'GOD KILIAN', 'Validé', '2025-05-23 06:53:13', '2025-09-09 09:11:37'),
(23, 19, 2, 14, 'FERREIRA', 'Validé', '2025-05-23 06:24:52', '2025-09-09 09:11:34'),
(24, 19, 2, 14, 'GOD DAVID', 'Validé', '2025-05-19 07:31:40', '2025-09-09 09:11:32'),
(25, 19, 2, 14, 'SAINT AMON', 'Validé', '2025-05-07 07:33:11', '2025-09-09 09:11:27'),
(26, 19, 2, 14, 'MARTIN', 'Validé', '2025-05-07 10:02:33', '2025-09-09 09:11:29'),
(27, 19, 2, 14, 'DUPEY 4', 'Validé', '2025-04-24 10:06:27', '2025-09-09 09:11:24'),
(28, 19, 2, 14, 'DUPEY 3', 'Validé', '2025-04-24 10:05:36', '2025-09-09 09:11:21'),
(29, 19, 2, 14, 'DUPEY 2', 'Validé', '2025-04-24 09:23:03', '2025-09-09 09:11:18'),
(30, 19, 2, 14, 'DUPEY 1', 'Validé', '2025-04-24 08:24:40', '2025-09-09 09:11:16'),
(31, 19, 2, 14, 'AUDEBERT', 'Validé', '2025-04-09 13:25:57', '2025-09-09 09:11:13'),
(32, 19, 2, 14, 'FEVRE 2', 'Validé', '2025-03-31 13:27:17', '2025-09-09 09:11:10'),
(33, 19, 2, 14, 'MAUVOISIN', 'Validé', '2025-03-31 12:29:35', '2025-09-09 09:11:06'),
(34, 19, 2, 14, 'CLAVERIE', 'Validé', '2025-03-04 14:57:00', '2025-09-09 09:10:54'),
(35, 19, 2, 14, 'CASTAINGT', 'Validé', '2025-02-14 14:59:31', '2025-09-09 09:10:49'),
(36, 19, 2, 14, 'FEVRE', 'Validé', '2025-02-14 13:02:09', '2025-09-09 09:10:45'),
(37, 19, 2, 14, 'PEIO', 'Validé', '2025-02-14 12:02:09', '2025-09-09 09:10:42'),
(38, 19, 2, 14, 'BOUIGUE', 'Validé', '2025-01-10 07:50:09', '2025-09-09 09:10:34'),
(39, 19, 2, 14, 'ANDRE 2', 'Validé', '2024-12-05 07:55:20', '2025-09-09 09:10:32'),
(40, 19, 2, 14, 'ANDRE 1', 'Validé', '2024-12-05 06:55:20', '2025-09-09 09:10:29'),
(41, 19, 2, 14, 'CASTAINGT 1', 'Validé', '2024-12-05 05:55:20', '2025-09-09 09:10:26'),
(42, 19, 2, 14, 'GOMEZ 2', 'Validé', '2024-11-25 08:07:56', '2025-09-09 09:10:23'),
(43, 19, 2, 14, 'GOMEZ 1', 'Validé', '2024-11-25 08:06:56', '2025-09-09 09:10:20'),
(44, 19, 2, 14, 'LABACHOT', 'Validé', '2024-11-25 08:05:56', '2025-09-09 09:10:17'),
(45, 19, 2, 14, 'BARONE', 'Validé', '2024-10-04 07:13:38', '2025-09-09 09:10:14'),
(46, 19, 2, 14, 'PEIO 1', 'Validé', '2024-10-04 07:12:38', '2025-09-09 09:10:12'),
(47, 19, 2, 14, 'PEDRO 2', 'Validé', '2025-03-31 09:10:00', '2025-09-09 09:11:01'),
(48, 19, 2, 14, 'PEDRO 1', 'Validé', '2025-03-31 09:09:00', '2025-09-09 09:10:58'),
(49, 19, 2, 14, 'DULHOSTE', 'Validé', '2025-01-21 14:10:58', '2025-09-09 09:10:38');

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

--
-- Structure de la table `entreprises`
--

CREATE TABLE IF NOT EXISTS `entreprises` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `nom` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `adresse_1` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `adresse_2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code_postal` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ville` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tel` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `entreprises`
--

INSERT INTO `entreprises` (`id`, `nom`, `adresse_1`, `adresse_2`, `code_postal`, `ville`, `tel`, `created_at`, `updated_at`) VALUES
(1, 'ACPORTAIL BEGAAR', 'ZA du Tucat', '', '40400', 'Begaar', '05 58 55 53 14', '2025-08-28 07:10:32', '2025-08-28 07:10:32'),
(2, 'AGRISEM', '3 rue de la roue zi de l\'enclouse', '', '17100', 'SAINTES', '05-46-74-13-59', '2025-08-28 07:10:32', '2025-08-28 07:10:32'),
(3, 'ALTEO SERVICES', '2 rue des ARTISANS', '', '40100', 'DAX', '05-58-58-58-58', '2025-08-28 07:10:32', '2025-08-28 07:10:32'),
(4, 'AQUABAT NEGOCE', '75 route de Marcadé', '', '40090', 'ST PERDON', '05-33-09-47-37', '2025-08-28 07:10:32', '2025-08-28 07:10:32'),
(5, 'ATOUT FERMETURES', '17 Avenue de Londres', '', '13127', 'VITROLLES', '04-42-49-19-17', '2025-08-28 07:10:32', '2025-08-28 07:10:32'),
(6, 'BATILAND ARMAGNAC MATERIAUX', 'ZA DE JAMON', '', '32310', 'VALENCE-SUR-BAISE', '05-58-57-05-15', '2025-08-28 07:10:32', '2025-08-28 07:10:32'),
(7, 'BATILAND BERECIARTUA MATERIAUX', '235 rue Lanzelai', '', '64310', 'ASCAIN', '05-59-85-99-99', '2025-08-28 07:10:32', '2025-08-28 07:10:32'),
(8, 'BATILAND CAMOU-HIRIBARNE', '510 chemin de Zaliondoa', '', '64240', 'HASPARREN', '05-59-29-10-57', '2025-08-28 07:10:32', '2025-08-28 07:10:32'),
(9, 'BATILAND DUMARTHERAY MATERIAUX', 'Zone de Cramat, 2 rue de Gascogne', '', '40140', 'SOUSTONS', '05-58-41-14-39', '2025-08-28 07:10:32', '2025-08-28 07:10:32'),
(10, 'BATILAND ETCHEGINTZA', '2 route du Haut Béarn', '', '64390', 'ST GLADIE ARRIVE MUNEIN', '05-59-38-51-41', '2025-08-28 07:10:32', '2025-08-28 07:10:32'),
(11, 'BATILAND ETS GUILLEMETEAU', '5 La Station', '', '16330', 'ST AMANT DE BOIXE', '05-45-39-72-06', '2025-08-28 07:10:32', '2025-08-28 07:10:32'),
(12, 'BATILAND FARGES SAS', '35 avenue Joseph Vachal - BP 24', '', '19400', 'ARGENTAT', '05-55-28-10-40', '2025-08-28 07:10:32', '2025-08-28 07:10:32'),
(13, 'BATILAND GABORIT', '59 Route de Lourdes', '', '65380', 'LAMARQUE PONTACQ', '05-59-53-50-60', '2025-08-28 07:10:32', '2025-08-28 07:10:32'),
(14, 'BATILAND LANDES MATERIAUX', '32 route des Pyrénées', '', '40180', 'NARROSSE', '05-58-74-23-41', '2025-08-28 07:10:32', '2025-08-28 07:10:32'),
(15, 'BATILAND LARROUY', 'Rue Adoue', '', '64400', 'OLORON SAINTE MARIE', '05-59-39-03-03', '2025-08-28 07:10:32', '2025-08-28 07:10:32'),
(16, 'BATILAND LAVAUD MATERIAUX', '3 rue de Tout Vent BP 24', '', '87500', 'ST YRIEIX LA PERCHE', '05-55-75-03-79', '2025-08-28 07:10:32', '2025-08-28 07:10:32'),
(17, 'BATILAND MAURIN DISTRIBUTION', 'ZA Mamoura Nord, Allée des Mesanges', '', '40090', 'ST AVIT', '05-58-75-75-72', '2025-08-28 07:10:32', '2025-08-28 07:10:32'),
(18, 'BATILAND MTX BAGNERES', '12 avenue Pascal Bagnères', '', '33610', 'CESTAS', '05-57-97-16-20', '2025-08-28 07:10:32', '2025-08-28 07:10:32'),
(19, 'BATILAND PEYRE', '76 ZI Louis', '', '64300', 'ORTHEZ', '05-59-69-93-01', '2025-08-28 07:10:32', '2025-08-28 07:10:32'),
(20, 'BATILAND POUTS-LAJUS', 'Rue des 3 fermes', '', '64510', 'BOEIL BEZING', '05-59-53-24-99', '2025-08-28 07:10:32', '2025-08-28 07:10:32'),
(21, 'BATILAND RAVET SAS', '17 routes de Saintes', '', '33820', 'ETAULIERS', '05-57-64-53-14', '2025-08-28 07:10:32', '2025-08-28 07:10:32'),
(22, 'BATILAND SABALOT MONTOULIEU', '40 avenue Aristide Briand', '', '64260', 'LOUVIE JUZON', '05-59-05-61-35', '2025-08-28 07:10:32', '2025-08-28 07:10:32'),
(23, 'BATILAND SOULARD DECAUD', '1 chemin de chez Louainet', '', '16480', 'BROSSAC', '05-45-98-70-03', '2025-08-28 07:10:32', '2025-08-28 07:10:32'),
(24, 'SARREMEJEAN', 'Rue Jean de Nasse', '', '40260', 'CASTETS', '05-58-57-57-57', '2025-08-28 07:10:32', '2025-08-28 07:10:32');

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

--
-- Structure de la table `failed_jobs`
--

CREATE TABLE IF NOT EXISTS `failed_jobs` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Structure de la table `inoxes`
--

CREATE TABLE IF NOT EXISTS `inoxes` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `nom` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `inoxes`
--

INSERT INTO `inoxes` (`id`, `nom`, `created_at`, `updated_at`) VALUES
(1, 'BAN-01', '2025-07-31 09:52:58', '2025-07-31 09:52:58'),
(2, 'CAR-01', '2025-07-31 10:03:26', '2025-07-31 10:03:26'),
(4, 'LUN-01', '2025-07-31 10:07:04', '2025-07-31 10:07:04'),
(5, 'RECT-01', '2025-07-31 10:08:58', '2025-07-31 10:08:58'),
(6, 'RECT-02', '2025-07-31 10:10:27', '2025-07-31 10:10:27'),
(7, 'RECT-03', '2025-07-31 10:13:06', '2025-07-31 10:13:06'),
(8, 'RECT-04', '2025-07-31 10:14:16', '2025-07-31 10:14:16'),
(10, 'RECT-05', '2025-07-31 10:17:07', '2025-07-31 10:17:07'),
(11, 'RECT-06', '2025-07-31 10:18:38', '2025-07-31 10:18:38'),
(12, 'TRI-01', '2025-07-31 10:20:06', '2025-07-31 10:20:06'),
(13, 'TRI-02', '2025-07-31 10:21:26', '2025-07-31 10:21:26'),
(14, 'TRI-03', '2025-07-31 10:22:34', '2025-07-31 10:22:34'),
(15, 'TRI-01+BAN-01', '2025-07-31 10:23:50', '2025-07-31 10:23:50');

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

--
-- Structure de la table `migrations`
--

CREATE TABLE IF NOT EXISTS `migrations` (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2025_03_06_101942_create_couleurs_table', 1),
(6, '2025_03_06_130946_create_categories_table', 1),
(7, '2025_03_07_113201_create_modeles_table', 1),
(8, '2025_03_10_113000_create_telechargements_table', 1),
(9, '2025_03_12_133209_create_roles_table', 1),
(10, '2025_03_18_123325_create_devis_table', 1),
(11, '2025_03_25_123209_create_demandes_table', 1),
(12, '2025_03_25_123519_create_demande_devi_table', 1),
(13, '2025_04_01_130050_create_entreprises_table', 1),
(14, '2025_04_03_093509_create_telechargement_role_table', 1),
(15, '2025_04_03_134204_create_modele_role_table', 1),
(16, '2025_05_09_143657_create_commandes_table', 1),
(17, '2025_05_16_103208_create_inoxes_table', 1),
(18, '2025_05_19_141144_create_modele_inox_table', 1),
(19, '2025_07_22_091448_create_decoupes_table', 1),
(20, '2025_07_25_112723_create_modele_decoupe_table', 1);

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

--
-- Structure de la table `modeles`
--

CREATE TABLE IF NOT EXISTS `modeles` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nom` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `categorie_id` bigint UNSIGNED NOT NULL,
  `prix` double NOT NULL,
  `marge` double NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `modeles_categorie_id_foreign` (`categorie_id`)
) ENGINE=MyISAM AUTO_INCREMENT=71 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `modeles`
--

INSERT INTO `modeles` (`id`, `image`, `nom`, `categorie_id`, `prix`, `marge`, `created_at`, `updated_at`) VALUES
(1, 'nairobi-100-coulissants.jpg', 'NAIROBI 100', 1, 173, 400, '2025-05-14 04:52:35', '2025-08-07 08:07:31'),
(2, 'nairobi-100v-coulissants.jpg', 'NAIROBI 100V', 1, 173, 400, '2025-05-14 07:42:26', '2025-08-07 08:07:53'),
(3, 'nairobi-200-coulissants.jpg', 'NAIROBI 200', 1, 173, 400, '2025-05-14 07:47:17', '2025-08-07 08:08:11'),
(4, 'nairobi-200v-coulissants.jpg', 'NAIROBI 200V', 1, 173, 400, '2025-05-14 07:47:42', '2025-08-07 08:08:46'),
(5, 'nairobi-300-coulissants.jpg', 'NAIROBI 300', 1, 173, 400, '2025-05-14 07:48:17', '2025-08-07 08:09:19'),
(6, 'nairobi-300v-coulissants.jpg', 'NAIROBI 300V', 1, 173, 400, '2025-05-14 07:48:41', '2025-08-07 08:09:41'),
(7, 'berlin-coulissants.jpg', 'BERLIN', 1, 185, 500, '2025-05-14 07:50:03', '2025-08-07 08:09:58'),
(8, 'denver-coulissants.jpg', 'DENVER', 1, 173, 400, '2025-05-14 07:51:43', '2025-08-07 08:10:10'),
(9, 'tokyo-coulissants.jpg', 'TOKYO', 1, 192, 500, '2025-05-14 07:56:18', '2025-08-07 08:10:23'),
(10, 'lisbonne-coulissants.jpg', 'LISBONNE', 1, 173, 500, '2025-05-14 07:57:16', '2025-08-07 08:10:36'),
(11, 'rio-coulissants.jpg', 'RIO', 1, 240, 500, '2025-05-14 07:58:18', '2025-09-16 13:15:53'),
(12, 'nairobi-100-battants.jpg', 'NAIROBI 100', 2, 187, 400, '2025-05-14 09:46:32', '2025-08-07 08:11:19'),
(13, 'nairobi-100v-battants.jpg', 'NAIROBI 100V', 2, 187, 400, '2025-05-14 09:47:42', '2025-08-07 08:11:34'),
(14, 'nairobi-200-battants.jpg', 'NAIROBI 200', 2, 187, 400, '2025-05-14 09:48:33', '2025-08-07 08:11:52'),
(15, 'nairobi-200v-battants.jpg', 'NAIROBI 200V', 2, 187, 400, '2025-05-14 09:49:03', '2025-08-07 08:12:06'),
(16, 'nairobi-300-battants.jpg', 'NAIROBI 300', 2, 187, 400, '2025-05-14 09:49:43', '2025-08-07 08:12:54'),
(17, 'nairobi-300v-battants.jpg', 'NAIROBI 300V', 2, 187, 400, '2025-05-14 09:50:11', '2025-08-07 08:13:18'),
(18, 'berlin-battants.jpg', 'BERLIN', 2, 195, 500, '2025-05-14 09:50:55', '2025-08-07 08:13:34'),
(19, 'denver-battants.jpg', 'DENVER', 2, 187, 400, '2025-05-14 09:51:56', '2025-08-07 08:13:51'),
(20, 'tokyo-battants.jpg', 'TOKYO', 2, 212, 500, '2025-05-14 09:53:27', '2025-08-07 08:14:19'),
(21, 'lisbonne-battants.jpg', 'LISBONNE', 2, 187, 500, '2025-05-14 09:54:37', '2025-08-07 08:14:36'),
(22, 'rio-battants-68c9676bb3a16.jpg', 'RIO', 2, 260, 500, '2025-05-14 09:55:47', '2025-09-16 13:34:36'),
(23, 'nairobi-100-portillons.jpg', 'NAIROBI 100', 3, 242, 200, '2025-05-14 10:00:45', '2025-08-07 08:15:41'),
(24, 'nairobi-100v-portillons.jpg', 'NAIROBI 100V', 3, 242, 200, '2025-05-14 10:01:35', '2025-08-07 08:15:57'),
(25, 'nairobi-200-portillons.jpg', 'NAIROBI 200', 3, 242, 200, '2025-05-14 10:02:17', '2025-08-07 08:16:24'),
(26, 'nairobi-200v-portillons.jpg', 'NAIROBI 200V', 3, 242, 200, '2025-05-14 10:02:49', '2025-08-07 08:16:39'),
(27, 'nairobi-300-portillons.jpg', 'NAIROBI 300', 3, 242, 200, '2025-05-14 10:03:33', '2025-08-07 08:17:09'),
(28, 'nairobi-300v-portillons.jpg', 'NAIROBI 300V', 3, 242, 200, '2025-05-14 10:03:52', '2025-08-07 08:17:22'),
(29, 'berlin-portillons.jpg', 'BERLIN', 3, 250, 200, '2025-05-14 10:04:30', '2025-08-07 08:17:44'),
(30, 'denver-portillons.jpg', 'DENVER', 3, 242, 200, '2025-05-14 10:05:07', '2025-08-07 08:17:58'),
(31, 'tokyo-portillons.jpg', 'TOKYO', 3, 105, 250, '2025-05-14 10:07:04', '2025-08-07 08:18:14'),
(32, 'lisbonne-portillons.jpg', 'LISBONNE', 3, 250, 300, '2025-05-14 10:08:36', '2025-08-07 08:18:26'),
(33, 'rio-portillons.jpg', 'RIO', 3, 290, 250, '2025-05-14 10:09:29', '2025-09-16 13:15:59'),
(34, 'cache-profil-profils.jpg', 'CACHE PROFIL', 5, 15.37, 0, '2025-07-04 10:01:05', '2025-08-07 07:58:51'),
(35, 'lame-70-mm-ouv-70x20-ep-12-mm-profils.jpg', 'LAME 70 MM OUV 70x20 EP 1.2 MM', 5, 33.64, 0, '2025-07-04 12:06:58', '2025-08-07 07:59:20'),
(36, 'lame-100-mm-f-100x20-ep-13-mm-profils.jpg', 'LAME 100 MM F 100x20 EP 1.3 MM', 5, 53.35, 0, '2025-07-04 11:32:54', '2025-08-07 08:00:03'),
(37, 'lame-100-mm-m-100x20-ep-13-mm-profils.jpg', 'LAME 100 MM M 100x20 EP 1.3 MM', 5, 53.62, 0, '2025-07-04 11:33:27', '2025-08-07 08:04:07'),
(38, 'lame-100-mm-mf-100x20-ep-13-mm-profils.jpg', 'LAME 100 MM M/F 100x20 EP 1.3 MM', 5, 57.58, 0, '2025-07-04 11:34:15', '2025-08-07 08:03:33'),
(39, 'lame-100-mm-ouv-100x20-ep-13-mm-profils.jpg', 'LAME 100 MM OUV 100x20 EP 1.3 MM', 5, 55.24, 0, '2025-07-04 11:34:47', '2025-08-07 08:02:01'),
(40, 'lame-200-mm-f-200x20-ep-13-mm-profils.jpg', 'LAME 200 MM F 200x20 EP 1.3 MM', 5, 94.52, 0, '2025-07-04 11:35:37', '2025-08-07 08:01:38'),
(41, 'lame-200-mm-m-200x20-ep-13-mm-profils.jpg', 'LAME 200 MM M 200x20 EP 1.3 MM', 5, 94.89, 0, '2025-07-04 11:36:09', '2025-08-07 08:01:09'),
(42, 'lame-200-mm-mf-200x20-ep-13-mm-profils.jpg', 'LAME 200 MM M/F 200x20 EP 1.3 MM', 5, 99.51, 0, '2025-07-04 11:36:50', '2025-08-07 08:00:52'),
(43, 'lame-200-mm-ouv-100x20-ep-13-mm-profils.jpg', 'LAME 200 MM OUV 100x20 EP 1.3 MM', 5, 91.82, 0, '2025-07-04 11:37:15', '2025-08-07 08:00:20'),
(44, 'lame-300-mm-mf-200x20-ep-13-mm-profils.jpg', 'LAME 300 MM M/F 200x20 EP 1.3 MM', 5, 150.29, 0, '2025-07-04 11:40:27', '2025-08-07 07:58:38'),
(45, 'chapeau-profils.jpg', 'CHAPEAU', 5, 11.98, 0, '2025-07-04 12:11:39', '2025-08-07 07:58:15'),
(46, 'sabot-profils.jpg', 'SABOT', 5, 13.44, 0, '2025-07-04 12:11:54', '2025-08-07 07:58:02'),
(47, 'poteau-cloture-profils.jpg', 'POTEAU CLÔTURE', 5, 100.08, 0, '2025-07-04 12:12:07', '2025-08-07 07:57:33'),
(48, 'baionnette-profils.jpg', 'BAIONNETTE', 5, 27, 0, '2025-07-08 09:39:58', '2025-08-07 07:57:17'),
(49, 'sabot-de-sol-profils.jpg', 'SABOT DE SOL', 5, 29, 0, '2025-07-08 09:40:29', '2025-08-07 07:56:40'),
(59, 'denver-cloture-aluminium.jpg', 'DENVER', 4, 0, 0, '2025-08-28 07:03:37', '2025-09-16 12:11:52'),
(60, 'nairobi-300-cloture-aluminium.jpg', 'NAIROBI 300', 4, 0, 0, '2025-08-28 07:03:56', '2025-09-16 12:11:28'),
(61, 'nairobi-100-cloture-aluminium.jpg', 'NAIROBI 100', 4, 0, 0, '2025-08-28 07:05:02', '2025-09-16 12:10:57'),
(62, 'nairobi-200-cloture-aluminium.jpg', 'NAIROBI 200', 4, 0, 0, '2025-08-28 07:05:23', '2025-09-16 12:11:12'),
(63, 'poteau-150-chapeau-poteau-au-detail.jpg', 'POTEAU 150 CHAPEAU', 6, 80, 0, '2025-08-29 07:04:02', '2025-08-29 07:04:02'),
(64, 'poteau-150-seul-poteau-au-detail.jpg', 'POTEAU 150 SEUL', 6, 80, 0, '2025-08-29 07:04:44', '2025-08-29 07:04:44'),
(65, 'poteau-150-chapeau-platine-poteau-au-detail.jpg', 'POTEAU 150 CHAPEAU PLATINE', 6, 155, 0, '2025-09-01 07:59:13', '2025-09-01 13:01:21'),
(66, 'persienne-cloture-aluminium.jpg', 'PERSIENNE', 4, 0, 0, '2025-09-08 13:01:22', '2025-09-16 12:12:12'),
(67, 'berlin-cloture-aluminium.jpg', 'BERLIN', 4, 0, 0, '2025-09-16 12:12:31', '2025-09-16 12:12:31'),
(68, 'rio-battants-68c96782a42ad.jpg', 'RIO', 2, 260, 500, '2025-09-16 13:19:18', '2025-09-16 13:34:58'),
(69, 'rio-coulissants-68c967c34f354.jpg', 'RIO', 1, 240, 500, '2025-09-16 13:36:03', '2025-09-16 13:36:03'),
(70, 'rio-cloture-aluminium-68c967d75a602.jpg', 'RIO', 3, 290, 250, '2025-09-16 13:36:23', '2025-09-16 13:36:23');

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

--
-- Structure de la table `modele_decoupe`
--

CREATE TABLE IF NOT EXISTS `modele_decoupe` (
  `modele_id` bigint UNSIGNED NOT NULL,
  `decoupe_id` bigint UNSIGNED NOT NULL,
  KEY `modele_decoupe_modele_id_foreign` (`modele_id`),
  KEY `modele_decoupe_decoupe_id_foreign` (`decoupe_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `modele_decoupe`
--

INSERT INTO `modele_decoupe` (`modele_id`, `decoupe_id`) VALUES
(11, 19),
(22, 19),
(33, 19),
(11, 18),
(22, 18),
(33, 18),
(11, 17),
(22, 17),
(33, 17),
(11, 16),
(22, 16),
(33, 16),
(11, 15),
(22, 15),
(33, 15),
(11, 14),
(22, 14),
(33, 14),
(11, 13),
(22, 13),
(33, 13),
(11, 12),
(22, 12),
(33, 12),
(11, 11),
(22, 11),
(33, 11),
(11, 10),
(22, 10),
(33, 10),
(11, 9),
(22, 9),
(33, 9),
(11, 8),
(22, 8),
(33, 8),
(11, 7),
(22, 7),
(33, 7),
(11, 6),
(22, 6),
(33, 6),
(11, 5),
(22, 5),
(33, 5),
(11, 4),
(22, 4),
(33, 4),
(11, 3),
(22, 3),
(33, 3),
(69, 19),
(68, 19),
(70, 19),
(69, 3),
(68, 3),
(70, 3),
(69, 18),
(68, 18),
(70, 18),
(69, 16),
(68, 16),
(70, 16),
(69, 17),
(68, 17),
(70, 17),
(69, 15),
(68, 15),
(70, 15),
(69, 4),
(68, 4),
(70, 4),
(69, 5),
(68, 5),
(70, 5),
(69, 6),
(68, 6),
(70, 6),
(69, 7),
(68, 7),
(70, 7),
(69, 8),
(68, 8),
(70, 8),
(69, 9),
(68, 9),
(70, 9),
(69, 10),
(68, 10),
(70, 10),
(69, 14),
(68, 14),
(70, 14),
(69, 13),
(68, 13),
(70, 13),
(69, 11),
(68, 11),
(70, 11),
(69, 12),
(68, 12),
(70, 12);

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

--
-- Structure de la table `modele_inox`
--

CREATE TABLE IF NOT EXISTS `modele_inox` (
  `inox_id` bigint UNSIGNED NOT NULL,
  `modele_id` bigint UNSIGNED NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `prix` double NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  KEY `modele_inox_inox_id_foreign` (`inox_id`),
  KEY `modele_inox_modele_id_foreign` (`modele_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `modele_inox`
--

INSERT INTO `modele_inox` (`inox_id`, `modele_id`, `image`, `prix`, `created_at`, `updated_at`) VALUES
(1, 1, 'nairobi-100-coulissants-ban-01.jpg', 100, '2025-07-31 09:52:59', '2025-07-31 09:52:59'),
(1, 12, 'nairobi-100-battants-ban-01.jpg', 100, '2025-07-31 09:53:00', '2025-07-31 09:53:00'),
(1, 23, 'nairobi-100-portillons-ban-01.jpg', 100, '2025-07-31 09:53:00', '2025-07-31 09:53:00'),
(1, 3, 'nairobi-200-coulissants-ban-01.jpg', 100, '2025-07-31 09:53:01', '2025-07-31 09:53:01'),
(1, 14, 'nairobi-200-battants-ban-01.jpg', 100, '2025-07-31 09:53:01', '2025-07-31 09:53:01'),
(1, 25, 'nairobi-200-portillons-ban-01.jpg', 100, '2025-07-31 09:53:02', '2025-07-31 09:53:02'),
(1, 5, 'nairobi-300-coulissants-ban-01.jpg', 100, '2025-07-31 09:53:03', '2025-07-31 09:53:03'),
(1, 16, 'nairobi-300-battants-ban-01.jpg', 100, '2025-07-31 09:53:03', '2025-07-31 09:53:03'),
(1, 27, 'nairobi-300-portillons-ban-01.jpg', 100, '2025-07-31 09:53:04', '2025-07-31 09:53:04'),
(2, 12, 'nairobi-100-battants-car-01.jpg', 100, '2025-07-31 10:03:26', '2025-07-31 10:03:26'),
(2, 1, 'nairobi-100-coulissants-car-01.jpg', 100, '2025-07-31 10:03:27', '2025-07-31 10:03:27'),
(2, 23, 'nairobi-100-portillons-car-01.jpg', 100, '2025-07-31 10:03:27', '2025-07-31 10:03:27'),
(2, 14, 'nairobi-200-battants-car-01.jpg', 100, '2025-07-31 10:03:28', '2025-07-31 10:03:28'),
(2, 3, 'nairobi-200-coulissants-car-01.jpg', 100, '2025-07-31 10:03:29', '2025-07-31 10:03:29'),
(2, 25, 'nairobi-200-portillons-car-01.jpg', 100, '2025-07-31 10:03:29', '2025-07-31 10:03:29'),
(2, 5, 'nairobi-300-coulissants-car-01.jpg', 100, '2025-07-31 10:03:30', '2025-07-31 10:03:30'),
(2, 16, 'nairobi-300-battants-car-01.jpg', 100, '2025-07-31 10:03:30', '2025-07-31 10:03:30'),
(2, 27, 'nairobi-300-portillons-car-01.jpg', 100, '2025-07-31 10:03:31', '2025-07-31 10:03:31'),
(4, 27, 'nairobi-300-portillons-lun-01.jpg', 100, '2025-07-31 10:07:10', '2025-07-31 10:07:10'),
(4, 16, 'nairobi-300-battants-lun-01.jpg', 100, '2025-07-31 10:07:09', '2025-07-31 10:07:09'),
(4, 5, 'nairobi-300-coulissants-lun-01.jpg', 100, '2025-07-31 10:07:08', '2025-07-31 10:07:08'),
(4, 25, 'nairobi-200-portillons-lun-01.jpg', 100, '2025-07-31 10:07:08', '2025-07-31 10:07:08'),
(4, 14, 'nairobi-200-battants-lun-01.jpg', 100, '2025-07-31 10:07:07', '2025-07-31 10:07:07'),
(4, 3, 'nairobi-200-coulissants-lun-01.jpg', 100, '2025-07-31 10:07:07', '2025-07-31 10:07:07'),
(4, 23, 'nairobi-100-portillons-lun-01.jpg', 100, '2025-07-31 10:07:06', '2025-07-31 10:07:06'),
(4, 12, 'nairobi-100-battants-lun-01.jpg', 100, '2025-07-31 10:07:05', '2025-07-31 10:07:05'),
(4, 1, 'nairobi-100-coulissants-lun-01.jpg', 100, '2025-07-31 10:07:05', '2025-07-31 10:07:05'),
(5, 1, 'nairobi-100-coulissants-rect-01.jpg', 100, '2025-07-31 10:08:59', '2025-07-31 10:08:59'),
(5, 12, 'nairobi-100-battants-rect-01.jpg', 100, '2025-07-31 10:08:59', '2025-07-31 10:08:59'),
(5, 23, 'nairobi-100-portillons-rect-01.jpg', 100, '2025-07-31 10:09:00', '2025-07-31 10:09:00'),
(5, 3, 'nairobi-200-coulissants-rect-01.jpg', 100, '2025-07-31 10:09:00', '2025-07-31 10:09:00'),
(5, 14, 'nairobi-200-battants-rect-01.jpg', 100, '2025-07-31 10:09:01', '2025-07-31 10:09:01'),
(5, 25, 'nairobi-200-portillons-rect-01.jpg', 100, '2025-07-31 10:09:02', '2025-07-31 10:09:02'),
(5, 5, 'nairobi-300-coulissants-rect-01.jpg', 100, '2025-07-31 10:09:02', '2025-07-31 10:09:02'),
(5, 16, 'nairobi-300-battants-rect-01.jpg', 100, '2025-07-31 10:09:03', '2025-07-31 10:09:03'),
(5, 27, 'nairobi-300-portillons-rect-01.jpg', 100, '2025-07-31 10:09:04', '2025-07-31 10:09:04'),
(6, 1, 'nairobi-100-coulissants-rect-02.jpg', 100, '2025-07-31 10:10:27', '2025-07-31 10:10:27'),
(6, 12, 'nairobi-100-battants-rect-02.jpg', 100, '2025-07-31 10:10:28', '2025-07-31 10:10:28'),
(6, 23, 'nairobi-100-portillons-rect-02.jpg', 100, '2025-07-31 10:10:28', '2025-07-31 10:10:28'),
(6, 3, 'nairobi-200-coulissants-rect-02.jpg', 100, '2025-07-31 10:10:29', '2025-07-31 10:10:29'),
(6, 14, 'nairobi-200-battants-rect-02.jpg', 100, '2025-07-31 10:10:30', '2025-07-31 10:10:30'),
(6, 25, 'nairobi-200-portillons-rect-02.jpg', 100, '2025-07-31 10:10:30', '2025-07-31 10:10:30'),
(6, 5, 'nairobi-300-coulissants-rect-02.jpg', 100, '2025-07-31 10:10:31', '2025-07-31 10:10:31'),
(6, 16, 'nairobi-300-battants-rect-02.jpg', 100, '2025-07-31 10:10:31', '2025-07-31 10:10:31'),
(6, 27, 'nairobi-300-portillons-rect-02.jpg', 100, '2025-07-31 10:10:32', '2025-07-31 10:10:32'),
(7, 1, 'nairobi-100-coulissants-rect-03.jpg', 100, '2025-07-31 10:13:06', '2025-07-31 10:13:06'),
(7, 12, 'nairobi-100-battants-rect-03.jpg', 100, '2025-07-31 10:13:07', '2025-07-31 10:13:07'),
(7, 23, 'nairobi-100-portillons-rect-03.jpg', 100, '2025-07-31 10:13:07', '2025-07-31 10:13:07'),
(7, 3, 'nairobi-200-coulissants-rect-03.jpg', 100, '2025-07-31 10:13:08', '2025-07-31 10:13:08'),
(7, 14, 'nairobi-200-battants-rect-03.jpg', 100, '2025-07-31 10:13:09', '2025-07-31 10:13:09'),
(7, 25, 'nairobi-200-portillons-rect-03.jpg', 100, '2025-07-31 10:13:09', '2025-07-31 10:13:09'),
(7, 5, 'nairobi-300-coulissants-rect-03.jpg', 100, '2025-07-31 10:13:10', '2025-07-31 10:13:10'),
(7, 16, 'nairobi-300-battants-rect-03.jpg', 100, '2025-07-31 10:13:10', '2025-07-31 10:13:10'),
(7, 27, 'nairobi-300-portillons-rect-03.jpg', 100, '2025-07-31 10:13:11', '2025-07-31 10:13:11'),
(8, 1, 'nairobi-100-coulissants-rect-04.jpg', 100, '2025-07-31 10:14:17', '2025-07-31 10:14:17'),
(8, 12, 'nairobi-100-battants-rect-04.jpg', 100, '2025-07-31 10:14:18', '2025-07-31 10:14:18'),
(8, 23, 'nairobi-100-portillons-rect-04.jpg', 100, '2025-07-31 10:14:18', '2025-07-31 10:14:18'),
(8, 3, 'nairobi-200-coulissants-rect-04.jpg', 100, '2025-07-31 10:14:19', '2025-07-31 10:14:19'),
(8, 14, 'nairobi-200-battants-rect-04.jpg', 100, '2025-07-31 10:14:19', '2025-07-31 10:14:19'),
(8, 25, 'nairobi-200-portillons-rect-04.jpg', 100, '2025-07-31 10:14:20', '2025-07-31 10:14:20'),
(8, 5, 'nairobi-300-coulissants-rect-04.jpg', 100, '2025-07-31 10:14:21', '2025-07-31 10:14:21'),
(8, 16, 'nairobi-300-battants-rect-04.jpg', 100, '2025-07-31 10:14:21', '2025-07-31 10:14:21'),
(8, 27, 'nairobi-300-portillons-rect-04.jpg', 100, '2025-07-31 10:14:22', '2025-07-31 10:14:22'),
(10, 5, 'nairobi-300-coulissants-rect-05.jpg', 100, '2025-07-31 10:17:11', '2025-07-31 10:17:11'),
(10, 25, 'nairobi-200-portillons-rect-05.jpg', 100, '2025-07-31 10:17:11', '2025-07-31 10:17:11'),
(10, 14, 'nairobi-200-battants-rect-05.jpg', 100, '2025-07-31 10:17:10', '2025-07-31 10:17:10'),
(10, 3, 'nairobi-200-coulissants-rect-05.jpg', 100, '2025-07-31 10:17:09', '2025-07-31 10:17:09'),
(10, 23, 'nairobi-100-portillons-rect-05.jpg', 100, '2025-07-31 10:17:09', '2025-07-31 10:17:09'),
(10, 12, 'nairobi-100-battants-rect-05.jpg', 100, '2025-07-31 10:17:08', '2025-07-31 10:17:08'),
(10, 1, 'nairobi-100-coulissants-rect-05.jpg', 100, '2025-07-31 10:17:08', '2025-07-31 10:17:08'),
(10, 16, 'nairobi-300-battants-rect-05.jpg', 100, '2025-07-31 10:17:12', '2025-07-31 10:17:12'),
(10, 27, 'nairobi-300-portillons-rect-05.jpg', 100, '2025-07-31 10:17:12', '2025-07-31 10:17:12'),
(11, 1, 'nairobi-100-coulissants-rect-06.jpg', 100, '2025-07-31 10:18:38', '2025-07-31 10:18:38'),
(11, 12, 'nairobi-100-battants-rect-06.jpg', 100, '2025-07-31 10:18:39', '2025-07-31 10:18:39'),
(11, 23, 'nairobi-100-portillons-rect-06.jpg', 100, '2025-07-31 10:18:39', '2025-07-31 10:18:39'),
(11, 3, 'nairobi-200-coulissants-rect-06.jpg', 100, '2025-07-31 10:18:40', '2025-07-31 10:18:40'),
(11, 14, 'nairobi-200-battants-rect-06.jpg', 100, '2025-07-31 10:18:40', '2025-07-31 10:18:40'),
(11, 25, 'nairobi-200-portillons-rect-06.jpg', 100, '2025-07-31 10:18:41', '2025-07-31 10:18:41'),
(11, 5, 'nairobi-300-coulissants-rect-06.jpg', 100, '2025-07-31 10:18:42', '2025-07-31 10:18:42'),
(11, 16, 'nairobi-300-battants-rect-06.jpg', 100, '2025-07-31 10:18:42', '2025-07-31 10:18:42'),
(11, 27, 'nairobi-300-portillons-rect-06.jpg', 100, '2025-07-31 10:18:43', '2025-07-31 10:18:43'),
(12, 1, 'nairobi-100-coulissants-tri-01.jpg', 100, '2025-07-31 10:20:07', '2025-07-31 10:20:07'),
(12, 12, 'nairobi-100-battants-tri-01.jpg', 100, '2025-07-31 10:20:07', '2025-07-31 10:20:07'),
(12, 23, 'nairobi-100-portillons-tri-01.jpg', 100, '2025-07-31 10:20:08', '2025-07-31 10:20:08'),
(12, 3, 'nairobi-200-coulissants-tri-01.jpg', 100, '2025-07-31 10:20:08', '2025-07-31 10:20:08'),
(12, 14, 'nairobi-200-battants-tri-01.jpg', 100, '2025-07-31 10:20:09', '2025-07-31 10:20:09'),
(12, 25, 'nairobi-200-portillons-tri-01.jpg', 100, '2025-07-31 10:20:09', '2025-07-31 10:20:09'),
(12, 5, 'nairobi-300-coulissants-tri-01.jpg', 100, '2025-07-31 10:20:10', '2025-07-31 10:20:10'),
(12, 16, 'nairobi-300-battants-tri-01.jpg', 100, '2025-07-31 10:20:11', '2025-07-31 10:20:11'),
(12, 27, 'nairobi-300-portillons-tri-01.jpg', 100, '2025-07-31 10:20:11', '2025-07-31 10:20:11'),
(13, 1, 'nairobi-100-coulissants-tri-02.jpg', 100, '2025-07-31 10:21:27', '2025-07-31 10:21:27'),
(13, 12, 'nairobi-100-battants-tri-02.jpg', 100, '2025-07-31 10:21:27', '2025-07-31 10:21:27'),
(13, 23, 'nairobi-100-portillons-tri-02.jpg', 100, '2025-07-31 10:21:28', '2025-07-31 10:21:28'),
(13, 3, 'nairobi-200-coulissants-tri-02.jpg', 100, '2025-07-31 10:21:28', '2025-07-31 10:21:28'),
(13, 14, 'nairobi-200-battants-tri-02.jpg', 100, '2025-07-31 10:21:29', '2025-07-31 10:21:29'),
(13, 25, 'nairobi-200-portillons-tri-02.jpg', 100, '2025-07-31 10:21:30', '2025-07-31 10:21:30'),
(13, 5, 'nairobi-300-coulissants-tri-02.jpg', 100, '2025-07-31 10:21:30', '2025-07-31 10:21:30'),
(13, 16, 'nairobi-300-battants-tri-02.jpg', 100, '2025-07-31 10:21:31', '2025-07-31 10:21:31'),
(13, 27, 'nairobi-300-portillons-tri-02.jpg', 100, '2025-07-31 10:21:31', '2025-07-31 10:21:31'),
(14, 1, 'nairobi-100-coulissants-tri-03.jpg', 100, '2025-07-31 10:22:35', '2025-07-31 10:22:35'),
(14, 12, 'nairobi-100-battants-tri-03.jpg', 100, '2025-07-31 10:22:36', '2025-07-31 10:22:36'),
(14, 23, 'nairobi-100-portillons-tri-03.jpg', 100, '2025-07-31 10:22:36', '2025-07-31 10:22:36'),
(14, 3, 'nairobi-200-coulissants-tri-03.jpg', 100, '2025-07-31 10:22:37', '2025-07-31 10:22:37'),
(14, 14, 'nairobi-200-battants-tri-03.jpg', 100, '2025-07-31 10:22:37', '2025-07-31 10:22:37'),
(14, 25, 'nairobi-200-portillons-tri-03.jpg', 100, '2025-07-31 10:22:38', '2025-07-31 10:22:38'),
(14, 5, 'nairobi-300-coulissants-tri-03.jpg', 100, '2025-07-31 10:22:38', '2025-07-31 10:22:38'),
(14, 16, 'nairobi-300-battants-tri-03.jpg', 100, '2025-07-31 10:22:39', '2025-07-31 10:22:39'),
(14, 27, 'nairobi-300-portillons-tri-03.jpg', 100, '2025-07-31 10:22:40', '2025-07-31 10:22:40'),
(15, 1, 'nairobi-100-coulissants-tri-01ban-01.jpg', 100, '2025-07-31 10:23:50', '2025-07-31 10:23:50'),
(15, 12, 'nairobi-100-battants-tri-01ban-01.jpg', 100, '2025-07-31 10:23:51', '2025-07-31 10:23:51'),
(15, 3, 'nairobi-200-coulissants-tri-01ban-01.jpg', 100, '2025-07-31 10:23:52', '2025-07-31 10:23:52'),
(15, 14, 'nairobi-200-battants-tri-01ban-01.jpg', 100, '2025-07-31 10:23:52', '2025-07-31 10:23:52'),
(15, 5, 'nairobi-300-coulissants-tri-01ban-01.jpg', 100, '2025-07-31 10:23:53', '2025-07-31 10:23:53'),
(15, 16, 'nairobi-300-battants-tri-01ban-01.jpg', 100, '2025-07-31 10:23:53', '2025-07-31 10:23:53');

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

--
-- Structure de la table `modele_role`
--

CREATE TABLE IF NOT EXISTS `modele_role` (
  `modele_id` bigint UNSIGNED NOT NULL,
  `role_id` bigint UNSIGNED NOT NULL,
  KEY `modele_role_modele_id_foreign` (`modele_id`),
  KEY `modele_role_role_id_foreign` (`role_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `modele_role`
--

INSERT INTO `modele_role` (`modele_id`, `role_id`) VALUES
(1, 2),
(1, 5),
(1, 7),
(1, 3),
(1, 6),
(1, 4),
(2, 2),
(2, 7),
(2, 5),
(2, 3),
(2, 6),
(2, 4),
(3, 4),
(3, 6),
(3, 3),
(3, 7),
(3, 2),
(3, 5),
(4, 2),
(5, 4),
(5, 6),
(5, 3),
(5, 7),
(5, 2),
(5, 5),
(6, 4),
(6, 6),
(6, 3),
(6, 7),
(6, 2),
(6, 5),
(7, 4),
(7, 6),
(7, 3),
(7, 7),
(7, 2),
(7, 5),
(8, 4),
(8, 6),
(8, 3),
(8, 7),
(8, 2),
(8, 5),
(9, 4),
(9, 6),
(9, 3),
(9, 7),
(9, 2),
(9, 5),
(10, 4),
(10, 6),
(10, 3),
(10, 7),
(10, 2),
(10, 5),
(11, 4),
(12, 4),
(12, 6),
(12, 3),
(12, 7),
(12, 2),
(12, 5),
(13, 4),
(13, 6),
(13, 3),
(13, 7),
(13, 2),
(13, 5),
(14, 4),
(14, 6),
(14, 3),
(14, 7),
(14, 2),
(14, 5),
(15, 4),
(15, 6),
(15, 3),
(15, 7),
(15, 2),
(15, 5),
(16, 4),
(16, 6),
(16, 3),
(16, 7),
(16, 2),
(16, 5),
(17, 4),
(17, 6),
(17, 3),
(17, 7),
(17, 2),
(17, 5),
(18, 4),
(18, 6),
(18, 3),
(18, 7),
(18, 2),
(18, 5),
(19, 4),
(19, 6),
(19, 3),
(19, 7),
(19, 2),
(19, 5),
(20, 4),
(20, 6),
(20, 3),
(20, 7),
(20, 2),
(20, 5),
(21, 4),
(21, 6),
(21, 3),
(21, 7),
(21, 2),
(21, 5),
(22, 4),
(23, 4),
(23, 6),
(23, 3),
(23, 7),
(23, 2),
(23, 5),
(24, 4),
(24, 6),
(24, 3),
(24, 7),
(24, 2),
(24, 5),
(25, 4),
(25, 6),
(25, 3),
(25, 7),
(25, 2),
(25, 5),
(26, 4),
(26, 6),
(26, 3),
(26, 7),
(26, 2),
(26, 5),
(27, 4),
(27, 6),
(27, 3),
(27, 7),
(27, 2),
(27, 5),
(28, 4),
(28, 6),
(28, 3),
(28, 7),
(28, 2),
(28, 5),
(29, 4),
(29, 6),
(29, 3),
(29, 7),
(29, 2),
(29, 5),
(30, 4),
(30, 6),
(30, 3),
(30, 7),
(30, 2),
(30, 5),
(33, 4),
(32, 4),
(32, 6),
(32, 3),
(32, 7),
(32, 2),
(32, 5),
(31, 4),
(31, 6),
(31, 3),
(31, 7),
(31, 2),
(31, 5),
(34, 4),
(34, 6),
(34, 3),
(34, 7),
(34, 2),
(34, 5),
(51, 4),
(51, 6),
(51, 3),
(51, 7),
(51, 2),
(51, 5),
(50, 4),
(50, 6),
(50, 3),
(50, 7),
(50, 2),
(50, 5),
(49, 4),
(49, 6),
(49, 3),
(49, 7),
(49, 2),
(49, 5),
(44, 4),
(44, 6),
(44, 3),
(44, 7),
(44, 2),
(44, 5),
(43, 4),
(43, 6),
(43, 3),
(43, 7),
(43, 2),
(43, 5),
(42, 4),
(42, 6),
(42, 3),
(42, 7),
(42, 2),
(42, 5),
(41, 4),
(41, 6),
(41, 3),
(41, 7),
(41, 2),
(41, 5),
(40, 4),
(40, 6),
(40, 3),
(40, 7),
(40, 2),
(40, 5),
(39, 4),
(39, 6),
(39, 3),
(39, 7),
(39, 2),
(39, 5),
(38, 4),
(38, 6),
(38, 3),
(38, 7),
(38, 2),
(38, 5),
(37, 4),
(37, 6),
(37, 3),
(37, 7),
(37, 2),
(37, 5),
(36, 4),
(36, 6),
(36, 3),
(36, 7),
(36, 2),
(36, 5),
(35, 4),
(35, 6),
(35, 3),
(35, 7),
(35, 2),
(35, 5),
(4, 7),
(4, 6),
(50, 8),
(51, 8),
(4, 5),
(4, 3),
(4, 4),
(50, 9),
(51, 9),
(57, 4),
(57, 6),
(57, 3),
(57, 7),
(57, 2),
(57, 5),
(58, 4),
(58, 6),
(58, 3),
(58, 7),
(58, 2),
(58, 5),
(45, 4),
(45, 6),
(45, 3),
(45, 7),
(45, 2),
(45, 5),
(48, 4),
(48, 6),
(48, 3),
(48, 7),
(48, 2),
(48, 5),
(47, 4),
(47, 6),
(47, 3),
(47, 7),
(47, 2),
(47, 5),
(46, 4),
(46, 6),
(46, 3),
(46, 7),
(46, 2),
(46, 5),
(59, 4),
(59, 6),
(59, 3),
(59, 7),
(59, 2),
(59, 5),
(60, 4),
(60, 6),
(60, 3),
(60, 7),
(60, 2),
(60, 5),
(61, 4),
(61, 6),
(61, 3),
(61, 7),
(61, 2),
(61, 5),
(62, 4),
(62, 6),
(62, 3),
(62, 7),
(62, 2),
(62, 5),
(63, 4),
(63, 6),
(63, 3),
(63, 7),
(63, 2),
(63, 5),
(64, 4),
(64, 6),
(64, 3),
(64, 7),
(64, 2),
(64, 5),
(65, 4),
(65, 6),
(65, 3),
(65, 7),
(65, 2),
(65, 5),
(66, 4),
(66, 6),
(66, 3),
(66, 7),
(66, 2),
(66, 5),
(67, 4),
(67, 6),
(67, 3),
(67, 7),
(67, 2),
(67, 5),
(11, 6),
(11, 3),
(11, 7),
(11, 5),
(22, 6),
(22, 3),
(22, 7),
(22, 5),
(33, 6),
(33, 3),
(33, 7),
(33, 5),
(68, 2),
(69, 2),
(70, 2);

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

--
-- Structure de la table `password_resets`
--

CREATE TABLE IF NOT EXISTS `password_resets` (
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Structure de la table `personal_access_tokens`
--

CREATE TABLE IF NOT EXISTS `personal_access_tokens` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Structure de la table `roles`
--

CREATE TABLE IF NOT EXISTS `roles` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `nom` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_nom_unique` (`nom`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `roles`
--

INSERT INTO `roles` (`id`, `nom`, `created_at`, `updated_at`) VALUES
(1, 'ADMINISTRATEUR', '2025-07-07 08:51:04', '2025-07-07 08:51:04'),
(2, 'BATILAND', '2025-07-07 08:51:04', '2025-07-07 08:51:04'),
(3, 'AQUABAT', '2025-07-07 08:51:04', '2025-07-07 08:51:04'),
(4, 'AGRISEM', '2025-07-07 08:51:04', '2025-07-07 08:51:04'),
(5, 'SARREMEJEAN', '2025-07-07 08:51:04', '2025-07-07 08:51:04'),
(6, 'ALTEO SERVICES', '2025-07-07 08:51:04', '2025-07-07 08:51:04'),
(7, 'ATOUT FERMETURES', '2025-07-07 08:51:04', '2025-07-07 08:51:04'),
(8, 'ÉDITEUR', '2025-07-07 09:17:55', '2025-07-07 09:17:55');

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

--
-- Structure de la table `telechargements`
--

CREATE TABLE IF NOT EXISTS `telechargements` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `nom` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pdf` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `telechargements`
--

INSERT INTO `telechargements` (`id`, `nom`, `pdf`, `created_at`, `updated_at`) VALUES
(1, 'Prise commande client', '1747378571.pdf', '2025-05-16 06:56:11', '2025-05-16 06:56:11'),
(2, 'Prise commande interactif', '1747378597.pdf', '2025-05-16 06:56:37', '2025-05-16 06:57:06');

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

--
-- Structure de la table `telechargement_role`
--

CREATE TABLE IF NOT EXISTS `telechargement_role` (
  `telechargement_id` bigint UNSIGNED NOT NULL,
  `role_id` bigint UNSIGNED NOT NULL,
  KEY `telechargement_role_telechargement_id_foreign` (`telechargement_id`),
  KEY `telechargement_role_role_id_foreign` (`role_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `telechargement_role`
--

INSERT INTO `telechargement_role` (`telechargement_id`, `role_id`) VALUES
(1, 2),
(2, 2);

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

--
-- Structure de la table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `prenom` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `role_id` bigint UNSIGNED NOT NULL,
  `entreprise_id` bigint UNSIGNED NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tel` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`),
  KEY `users_role_id_foreign` (`role_id`),
  KEY `users_entreprise_id_foreign` (`entreprise_id`)
) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `users`
--

INSERT INTO `users` (`id`, `name`, `prenom`, `role_id`, `entreprise_id`, `email`, `tel`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'Incamps', 'Cyril', 1, 1, 'cyril.incamps@acportail.fr', '06 86 60 97 32', NULL, '$2y$10$PqhQyaijErDIY.Fg5Pt6b.2zPPqUdkIdIRsoIHzd5oozIHtFZvxfO', '3hNJWLSIGVD81M2EDxA98ReQ6R9AcQnd9Zu957YRu2eiuTKJm3dEzqH1dsI8', '2025-08-28 07:10:30', '2025-08-28 07:10:30'),
(2, 'Maitre', 'David', 1, 1, 'david.duarte@acportail.fr', '06 86 60 97 32', NULL, '$2y$10$NeE8Mfq0s1Q8WeggDBX1QuNn/m4yD0MOFdk39tTeDa/Q6lKeu7raK', NULL, '2025-08-28 07:10:30', '2025-08-28 07:10:30'),
(3, 'Robin', 'Marc', 8, 1, 'contact@negoceportail.fr', '05-58-57-57-57', NULL, '$2y$10$zL4EpQHLx7kK5fqa0hIYJe.03AZ/HCpShCvuxCn2DrovrOK6.Le1K', '5D1MQV6VPGvfDbEjkQFlpJbWxrgkbmqIyhbrajScVoKMuZZ7PGdrFNQ2H28L', '2025-08-28 07:10:30', '2025-09-16 13:38:36'),
(4, 'Perron', 'Rudy', 4, 2, 'rudy.perron@agrisem-distribution.fr', NULL, NULL, '$2y$10$0I.Ir3Cze23KhgZygkcRFuFOTD/7E6UeV4mjHk.rhgn1ZVrooI3hO', NULL, '2025-08-28 07:10:30', '2025-09-09 07:19:20'),
(5, 'Bendejac', 'Christophe', 6, 3, 'e.houeye@alteoservices.fr', '06-02-13-62-15', NULL, '$2y$10$T7npEgYCEte/mrvEu4Mpu.8m4jTa85XrIqNatcLqSj6onqVl3ByDG', NULL, '2025-08-28 07:10:30', '2025-09-09 07:19:36'),
(6, 'Bauduz', 'Julien', 3, 4, 'bauduz.aquabat@gmail.com', '07 61 55 88 36', NULL, '$2y$10$rHTWQj.6Sr.F59s6VVov5eed2lUKrKQW4tfETiXrYHh46.yoreXMy', NULL, '2025-08-28 07:10:30', '2025-09-09 07:19:51'),
(7, 'Belaidi', 'Mohamed', 7, 5, 'contact@atout-fermetures.com', NULL, NULL, '$2y$10$/LxsZYrrmXMInpzI6xvgPem6Xw0I1BSuIe0mBbcNX49tDlkVBvoOC', NULL, '2025-08-28 07:10:30', '2025-09-09 07:20:23'),
(8, 'Urthaler', 'Hervé', 2, 6, 'urthaler@batiland.fr', '06 84 54 46 05', NULL, '$2y$10$1ETXn5peLJvPZn7m7SXtxegl3MxI0H/I/FIZlQubnmetxMU5lPOBS', NULL, '2025-08-28 07:10:30', '2025-09-09 07:20:42'),
(9, 'Etchegaray', 'Eric', 2, 7, 'eric.etche@orange.fr', '06 32 28 03 34', NULL, '$2y$10$/KwFANHzsAxiEklBZjq.QuA441s8.POuxw0gqQfFVGtBJhjgjs4HG', NULL, '2025-08-28 07:10:30', '2025-09-09 07:21:06'),
(10, 'Etchegaray', 'Lisa', 2, 7, 'bereciartua.lisa@gmail.com', '06 45 97 78 54', NULL, '$2y$10$ApZnSTUz0JjjHgUYNWV5RuhIILCKoSsIoRacL9jUA/lkhqGQeTyXe', NULL, '2025-08-28 07:10:31', '2025-09-09 07:21:26'),
(11, 'Guillon', 'Miren / Pantxo /', 2, 8, 'camou-hiribarne@batiland.fr', '06 68 74 27 28', NULL, '$2y$10$fCuCcFOiBSw8.Zfoin.3NOb3KdCfoh11Qkm7fJ82pbhFSHKWn654q', NULL, '2025-08-28 07:10:31', '2025-09-09 07:22:11'),
(12, 'Dumartheray', 'Alain', 2, 9, 'contact.alain@dumartheray.fr', NULL, NULL, '$2y$10$3ual2dFNYespz9LhhiYSEuUJe/Q7YCu6kDwzOid8/VWXPd.nj/vWu', NULL, '2025-08-28 07:10:31', '2025-09-09 07:22:28'),
(13, 'Postis', 'Jordan', 2, 9, 'contact.jordan@dumartheray.fr', '06 27 08 24 69', NULL, '$2y$10$n4Jefg601r/qpZEHYsfH9.SxqnXs6.8m5pr/c1rvxyvihUhXhoFEG', NULL, '2025-08-28 07:10:31', '2025-09-09 07:22:50'),
(14, 'Larrondo', 'Patxi', 2, 10, 'p.larrondo@etchegintza.fr', '06 73 55 39 30', NULL, '$2y$10$c.4vVGvvjCEuD0pqkzfj6.igsv6MPOR0ET8EkeHRF0U9cpOZ1FRZy', NULL, '2025-08-28 07:10:31', '2025-09-09 07:23:08'),
(15, 'Rodrigues', 'Marie Déborah', 2, 10, 'md.rodrigues@etchegintza.fr', '06 73 55 39 30', NULL, '$2y$10$Ls6YqKj4zTConu4ulXlEleVgKb.sfxbf0Eq2clwkki1TlcoF7uQfG', NULL, '2025-08-28 07:10:31', '2025-09-09 07:23:31'),
(16, 'Guillemeteau', 'Laurent', 2, 11, 'laurent@guillemeteau.fr', '06 30 30 30 68', NULL, '$2y$10$VU0r8p6CFhPDXDYCVHIi4.9IYI9UK/km8FsDS5PDUYon5r/B/JMZ.', NULL, '2025-08-28 07:10:31', '2025-09-09 07:41:17'),
(17, 'Farges', 'Xavier', 2, 12, 'farges@batiland.fr', '06 84 97 98 73', NULL, '$2y$10$8bsuPD6CKTOyTbajiYlTduAsfN.z.dXLW403VK/ZJ5QNdZTsdIhhe', NULL, '2025-08-28 07:10:31', '2025-09-09 07:41:36'),
(18, 'Gaborit', 'Jean', 2, 13, 'jean@ets-gaborit-fr', '06 86 07 23 91', NULL, '$2y$10$ivDoMtOjgYZTEWQVV6D8.ukkCc1DPFPMm5naYfcpjQ.0dvxLAa9zG', NULL, '2025-08-28 07:10:31', '2025-09-09 07:50:10'),
(19, 'Vieira', 'Mickael', 2, 14, 'landesmateriauxmickael@gmail.com', '06-68-65-49-80', NULL, '$2y$10$df.7kSk7HG13fHO1vmsjDernYTRR7fgvW9EM5qLOBJMGkGTimyOSe', NULL, '2025-08-28 07:10:31', '2025-09-09 07:49:16'),
(21, 'ESPATOLERO', 'Florence', 2, 14, 'landesmateriauxflo@gmail.com', '06-28-83-41-95', NULL, '$2y$10$n5QcdVmL5L/jFd8sqnnr6ePDj0AcPbm5yCGQO1n3.zS97Hp1hjDQC', NULL, '2025-08-28 07:10:31', '2025-09-12 11:32:02'),
(22, 'Larrouy', 'Nicolas', 2, 15, 'n-larrouy@larrouy-batiland.com', '06 76 49 87 92', NULL, '$2y$10$/rjP9SBdwFkTCUG4OmgTeOYiDyeSJsSryQ.8bSse0JANSYHSMv8q2', NULL, '2025-08-28 07:10:31', '2025-09-09 07:48:16'),
(23, 'Lavaud', 'Thierry', 2, 16, 'tlavaud@lavaudmateriaux.fr', '06 76 84 87 20', NULL, '$2y$10$3h3JcBC4VOYtjHmf4lpDR.ACjAHkdL5BbcN2ipimBaGUv5kC3bXPC', NULL, '2025-08-28 07:10:31', '2025-09-09 07:47:53'),
(24, 'Delaballe', 'Adeline', 2, 17, 'adelinedelaballe@gmail.com', '06 13 06 63 18', NULL, '$2y$10$mrYzh/IWgAZOueqVfzsM1O0O/sHMsKS.Ig4DWhdJNX08VGk1aQDmm', NULL, '2025-08-28 07:10:31', '2025-09-09 07:47:32'),
(25, 'Darroman', 'Damien', 2, 18, 'larroman@materiauxbagneres.fr', '06 14 15 11 44', NULL, '$2y$10$joxJNHCOa1fkVIOm9GpuqOj2SUtuBzNxhZ3vDWWFSF4mHKU1ikbHO', NULL, '2025-08-28 07:10:32', '2025-09-09 07:46:28'),
(26, 'Peyre', 'Eric', 2, 19, 'peyre@batiland.fr', '06 07 41 71 33', NULL, '$2y$10$XcwI0Hw7ccXyHcL0XgG8uOzCFEtjRVz/gn7BZ4EbZ.pErDMQyR7uy', NULL, '2025-08-28 07:10:32', '2025-09-09 07:46:08'),
(27, 'Peyré', 'Frederic', 2, 19, 'fdpeyrebatiland@gmail.com', NULL, NULL, '$2y$10$zU6Nbf72ufReOmhvil0UV.bwJ9w7R1f1g0iL/MyeGkq83Liivm3WW', NULL, '2025-08-28 07:10:32', '2025-09-09 07:45:49'),
(28, 'Junca', 'Grégoire', 2, 19, 'gjpeyrebatiland@gmail.com', NULL, NULL, '$2y$10$qpMDpfwlVLKuWXNFgPD1WeMuKLFAMPxghCrzFhIi/Rh.aDkWj8ZPe', NULL, '2025-08-28 07:10:32', '2025-09-09 07:45:31'),
(29, 'Pouts-Lajus', 'Didier', 2, 20, 'batiland@poutslajus.fr', '06 21 39 58 51', NULL, '$2y$10$cKuc2khp1dZQsX7xb9MyceBbwYW.m/QYeEYxGSiavaHJ4fKqwUq.m', NULL, '2025-08-28 07:10:32', '2025-09-09 07:45:01'),
(30, 'Oranger', 'Joris', 2, 21, 'joris.oranger@batiland.fr', '06 31 31 10 23', NULL, '$2y$10$c7dOvnwjaqcEbcAYZiYDJuEjroGsWcv2W5vROQDuaDhnT1TJPOGdq', NULL, '2025-08-28 07:10:32', '2025-09-09 07:44:39'),
(31, 'Montoulieu', 'Michel', 2, 22, 'montoulieu@batiland.fr', '06 88 31 16 10', NULL, '$2y$10$hmfJwlQLXRMQG5MR9Uq2Iu1wS1XryDmxFMH.5biUf.9Ik9X.aN4u2', NULL, '2025-08-28 07:10:32', '2025-09-09 07:44:06'),
(32, 'Decaud', 'Olivier', 2, 23, 'olivier.decaud@batiland.fr', '06 63 58 65 08', NULL, '$2y$10$LXebLs5V8sDinCtxtgSIEehhUrKObvSY7i2MLgDqumfA7d/MrtQua', NULL, '2025-08-28 07:10:32', '2025-09-09 07:43:39'),
(33, 'Vigario', 'Americo', 5, 24, 'contact.francial@gmail.com', '05-58-57-57-57', NULL, '$2y$10$l4ArImGIhsSGgdhcyR01mO5HW2mQipDzIC0mRtlv8V8cuQoP5.x.e', NULL, '2025-08-28 07:10:32', '2025-09-09 07:43:20');
COMMIT;

