-- https://www.phpmyadmin.net/
--

START TRANSACTION;



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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `icon` varchar(255) 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 `categories`
--

INSERT INTO `categories` (`id`, `name`, `slug`, `icon`, `created_at`, `updated_at`) VALUES
(1, 'Pneus', 'pneus', 'bi-record-circle', '2025-12-23 14:52:50', '2025-12-23 14:52:50'),
(2, 'Jantes', 'jantes', 'bi-circle-half', '2025-12-23 14:52:50', '2025-12-23 14:52:50'),
(3, 'Plaquettes', 'plaquettes', 'bi-layers', '2025-12-23 14:52:50', '2025-12-23 14:52:50'),
(4, 'Accessoires', 'accessoires', 'bi-wrench', '2025-12-23 14:52:50', '2025-12-23 14:52:50'),
(8, 'Huiles & Lubrifiants', 'huiles-lubrifiants', 'bi-droplet', '2025-12-25 13:59:20', '2025-12-25 13:59:20'),
(9, 'Batteries & Électricité', 'batteries-electricite', 'bi-battery', '2025-12-25 13:59:20', '2025-12-25 13:59:20'),
(10, 'Filtres & Entretien', 'filtres-entretien', 'bi-funnel', '2025-12-25 13:59:20', '2025-12-25 13:59:20'),
(11, 'Suspension & Direction', 'suspension-direction', 'bi-arrows-move', '2025-12-25 13:59:20', '2025-12-25 13:59:20');

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

--
-- Table structure for table `commandes`
--

CREATE TABLE `commandes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name_client` varchar(255) DEFAULT NULL,
  `prenom_client` varchar(255) DEFAULT NULL,
  `telephone_client` varchar(255) DEFAULT NULL,
  `adresse_client` text DEFAULT NULL,
  `total` decimal(10,2) NOT NULL,
  `created_at` datetime NOT NULL,
  `statut` enum('en_attente','en_cours','livres','annulee') NOT NULL DEFAULT 'en_attente'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `commandes`
--

INSERT INTO `commandes` (`id`, `user_id`, `name_client`, `prenom_client`, `telephone_client`, `adresse_client`, `total`, `created_at`, `statut`) VALUES
(20, 5, NULL, NULL, NULL, NULL, 8280.00, '2025-12-25 14:16:51', 'en_attente'),
(21, NULL, 'Laharraf', 'Said', '0777777777', 'settat', 4600.00, '2025-12-25 14:18:13', 'en_attente'),
(23, 5, NULL, NULL, NULL, NULL, 2850.00, '2025-12-25 22:21:51', 'en_attente');

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `login`
--

CREATE TABLE `login` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `isblocked` tinyint(1) NOT NULL DEFAULT 0,
  `isConnected` tinyint(1) NOT NULL DEFAULT 0,
  `last_login` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(8, '0001_01_01_000000_create_users_table', 1),
(9, '0001_01_01_000001_create_cache_table', 1),
(10, '0001_01_01_000002_create_jobs_table', 1),
(11, '2025_11_20_163526_create_login_table', 1),
(12, '2025_11_20_163527_create_commandes_table', 1),
(13, '2025_11_20_163527_create_pneus_table', 1),
(14, '2025_11_20_163528_create_commande_pneus_table', 1),
(15, '2025_12_22_171041_add_image_to_pneus_table', 2),
(16, '2025_12_22_201439_add_guest_fields_to_commandes_table', 3),
(17, '2025_12_23_154636_create_categories_table', 4),
(18, '2025_12_23_154641_rename_pneus_to_products_table', 4),
(19, '2025_12_23_154937_rename_commande_pneus_table', 5),
(20, '2025_12_23_162601_rename_name_to_nom_in_users_table', 6),
(21, '2025_12_23_183551_add_company_fields_to_users_table', 7),
(22, '2025_12_23_200502_add_is_blocked_to_users_table', 8),
(23, '2025_12_24_144309_make_runflat_renforce_nullable_in_products_table', 9),
(24, '2025_12_25_232004_add_is_connected_to_users_table', 10);

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

--
-- Table structure for table `order_items`
--

CREATE TABLE `order_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `commande_id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `quantite` int(11) NOT NULL,
  `prix_unitaire` decimal(10,2) 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 `order_items`
--

INSERT INTO `order_items` (`id`, `commande_id`, `product_id`, `quantite`, `prix_unitaire`, `created_at`, `updated_at`) VALUES
(22, 20, 38, 4, 1200.00, NULL, NULL),
(23, 20, 36, 1, 950.00, NULL, NULL),
(24, 20, 39, 1, 350.00, NULL, NULL),
(25, 20, 31, 1, 220.00, NULL, NULL),
(26, 20, 19, 2, 980.00, NULL, NULL),
(27, 21, 24, 2, 950.00, NULL, NULL),
(28, 21, 22, 2, 1350.00, NULL, NULL),
(30, 23, 36, 3, 950.00, NULL, NULL);

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

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `marque` varchar(255) NOT NULL,
  `type_pneu` enum('Tourisme','4x4 / SUV','Camionnette / Utilitaire') DEFAULT NULL,
  `dot_annee` int(11) DEFAULT NULL,
  `prix_actuel` decimal(10,2) NOT NULL,
  `prix_ancien` decimal(10,2) DEFAULT NULL,
  `pays_fabrication` varchar(100) DEFAULT NULL,
  `largeur` int(11) DEFAULT NULL,
  `hauteur` int(11) DEFAULT NULL,
  `diametre` varchar(10) DEFAULT NULL,
  `dimension` varchar(50) DEFAULT NULL,
  `charge_index` int(11) DEFAULT NULL,
  `vitesse_index` varchar(10) DEFAULT NULL,
  `vitesse_kmh` varchar(50) DEFAULT NULL,
  `adherence_sol_mouille` varchar(1) DEFAULT NULL,
  `bruit_externe_db` int(11) DEFAULT NULL,
  `sku` varchar(100) DEFAULT NULL,
  `runflat` tinyint(1) DEFAULT NULL,
  `renforce` tinyint(1) DEFAULT NULL,
  `conso_carburant` char(1) DEFAULT NULL,
  `saison` enum('4 Saisons','Été','Hiver') DEFAULT NULL,
  `en_stock` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `category_id` bigint(20) UNSIGNED DEFAULT NULL,
  `description` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`id`, `name`, `image`, `marque`, `type_pneu`, `dot_annee`, `prix_actuel`, `prix_ancien`, `pays_fabrication`, `largeur`, `hauteur`, `diametre`, `dimension`, `charge_index`, `vitesse_index`, `vitesse_kmh`, `adherence_sol_mouille`, `bruit_externe_db`, `sku`, `runflat`, `renforce`, `conso_carburant`, `saison`, `en_stock`, `created_at`, `updated_at`, `category_id`, `description`) VALUES
(17, 'Michelin Primacy 4', 'michelin_michelin_primacy_4_17.1766668334.png', 'Michelin', 'Tourisme', 2024, 1250.00, 1400.00, 'France', 205, 55, 'R16', '205/55 R16', 91, 'V', '240 km/h', 'A', 68, 'MIC-P4-2055516', NULL, NULL, 'A', 'Été', 50, '2025-12-25 12:06:56', '2025-12-25 12:12:14', 1, 'Le pneu Michelin Primacy 4 offre une sécurité faite pour durer avec des performances de freinage sur sol mouillé exceptionnelles.'),
(18, 'Bridgestone Blizzak LM005', 'bridgestone_bridgestone_blizzak_lm005_18.1766668275.png', 'Bridgestone', 'Tourisme', 2023, 1100.00, 1250.00, 'Italie', 195, 65, 'R15', '195/65 R15', 91, 'T', '190 km/h', 'A', 71, 'BRI-LM5-1956515', NULL, NULL, 'C', 'Hiver', 30, '2025-12-25 12:06:56', '2025-12-25 12:11:15', 1, 'Un pneu hiver premium offrant un contrôle et une sécurité exceptionnels dans toutes les conditions hivernales.'),
(19, 'Continental ContiEcoContact 7', 'continental_continental_contiecocontact_7_19.1766668238.png', 'Continental', 'Tourisme', 2024, 980.00, 1050.00, 'Allemagne', 185, 60, 'R15', '185/60 R15', 84, 'H', '210 km/h', 'B', 70, 'CON-EC7-1856015', NULL, NULL, 'A', 'Été', 57, '2025-12-25 12:06:56', '2025-12-25 21:42:26', 1, 'Conçu pour une efficacité énergétique maximale et une longue durée de vie.'),
(20, 'Compresseur d\'air Portatif', 'xiaomi_compresseur_dair_portatif_20.1766668176.jpeg', 'Xiaomi', NULL, NULL, 450.00, 550.00, NULL, NULL, NULL, NULL, 'N/A', NULL, NULL, NULL, NULL, NULL, 'XIA-COMP-01', NULL, NULL, NULL, NULL, 10, '2025-12-25 12:06:56', '2025-12-25 12:31:01', 4, 'Compresseur d\'air compact et puissant pour gonfler vos pneus en toute simplicité.'),
(21, 'Michelin Primacy 4', 'michelin_michelin_primacy_4_21.1766668722.png', 'Michelin', 'Tourisme', 2024, 1250.00, 1450.00, 'France', 205, 55, 'R16', '205/55 R16', 91, 'V', '240 km/h', 'A', 69, 'MIC-PRI4-20555R16', NULL, NULL, 'B', 'Été', 20, '2025-12-25 13:14:39', '2025-12-25 12:18:42', 1, 'Excellent confort et adhérence sur sol mouillé'),
(22, 'Continental AllSeasonContact', 'continental_continental_allseasoncontact_22.1766668679.png', 'Continental', 'Tourisme', 2023, 1350.00, NULL, 'Germany', 195, 65, 'R15', '195/65 R15', 91, 'H', '210 km/h', 'B', 71, 'CON-ASC-19565R15', NULL, NULL, 'B', '4 Saisons', 4, '2025-12-25 13:14:39', '2025-12-25 21:12:59', 1, 'Pneu polyvalent toutes saisons'),
(23, 'Bridgestone Dueler H/T', 'bridgestone_bridgestone_dueler_ht_23.1766668646.png', 'Bridgestone', '4x4 / SUV', 2024, 1650.00, 1850.00, 'Japan', 265, 65, 'R17', '265/65 R17', 112, 'T', '190 km/h', 'B', 72, 'BRI-DUE-26565R17', NULL, 1, 'C', 'Été', 10, '2025-12-25 13:14:39', '2025-12-25 12:17:26', 1, 'Idéal pour SUV et routes mixtes'),
(24, 'Jante Aluminium Sport 16', 'oz_racing_jante_aluminium_sport_16_24.1766668792.jpg', 'OZ Racing', NULL, NULL, 950.00, 1100.00, 'Italy', NULL, NULL, '16', NULL, NULL, NULL, NULL, NULL, NULL, 'OZ-ALU-16', NULL, NULL, NULL, NULL, 12, '2025-12-25 13:15:43', '2025-12-25 21:12:59', 2, 'Jante aluminium sportive et légère'),
(25, 'Jante Acier Standard 15', 'generic_jante_acier_standard_15_25.1766668764.jpg', 'Generic', NULL, NULL, 450.00, NULL, 'Turkey', NULL, NULL, '15', NULL, NULL, NULL, NULL, NULL, NULL, 'GEN-AC-15', NULL, NULL, NULL, NULL, 30, '2025-12-25 13:15:43', '2025-12-25 12:19:24', 2, 'Jante acier robuste pour usage quotidien'),
(26, 'Plaquettes de frein avant Bosch', 'bosch_plaquettes_de_frein_avant_bosch_26.1766669064.jpeg', 'Bosch', NULL, NULL, 380.00, 450.00, 'Germany', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'BOS-PF-AV', NULL, NULL, NULL, NULL, 25, '2025-12-25 13:16:07', '2025-12-25 12:24:24', 3, 'Plaquettes de frein avant – haute performance'),
(27, 'Plaquettes de frein arrière Brembo', 'brembo_plaquettes_de_frein_arriere_brembo_27.1766668845.jpeg', 'Brembo', NULL, NULL, 420.00, NULL, 'Italy', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'BRE-PF-AR', NULL, NULL, NULL, NULL, 18, '2025-12-25 13:16:07', '2025-12-25 12:20:45', 3, 'Freinage puissant et durable'),
(29, 'Cric hydraulique 2T', 'michelin_cric_hydraulique_2t_29.1766669360.jpeg', 'Michelin', NULL, NULL, 580.00, NULL, 'maroc', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'MIC-CRIC-2T', NULL, NULL, NULL, NULL, 15, '2025-12-25 13:16:19', '2025-12-25 12:49:21', 4, 'Cric hydraulique capacité 2 tonnes'),
(30, 'Huile moteur 10W40', 'total_huile_moteur_10w40_30.1766671266.jpeg', 'Total', NULL, NULL, 180.00, 200.00, 'France', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'TOT-10W40', NULL, NULL, NULL, NULL, 50, '2025-12-25 13:55:14', '2025-12-25 13:01:06', 8, 'Huile moteur haute performance pour voitures essence et diesel'),
(31, 'Huile synthétique 5W30', 'castrol_huile_synthetique_5w30_31.1766671230.jpeg', 'Castrol', NULL, NULL, 220.00, 250.00, 'Germany', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CAS-5W30', NULL, NULL, NULL, NULL, 46, '2025-12-25 13:55:14', '2025-12-25 21:42:26', 8, 'Huile moteur synthétique pour une meilleure protection du moteur'),
(32, 'Filtre à huile Bosch', 'bosch_filtre_a_huile_bosch_32.1766671499.jpeg', 'Bosch', NULL, NULL, 80.00, 100.00, 'Germany', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'BOS-FH', NULL, NULL, NULL, NULL, 60, '2025-12-25 14:02:11', '2025-12-25 13:04:59', 10, 'Filtre à huile haute performance'),
(33, 'Filtre à air K&N', 'kn_filtre_a_air_kn_33.1766671411.jpeg', 'K&N', NULL, NULL, 150.00, 180.00, 'USA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'KN-FA', NULL, NULL, NULL, NULL, 30, '2025-12-25 14:02:11', '2025-12-25 13:03:31', 10, 'Filtre à air lavable et réutilisable'),
(36, 'Batterie Auto 12V 60Ah', 'exide_batterie_auto_12v_60ah_36.1766671766.jpeg', 'Exide', NULL, NULL, 950.00, 1200.00, 'France', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'EXI-12V60', NULL, NULL, NULL, NULL, 31, '2025-12-25 14:06:54', '2025-12-25 21:42:26', 9, 'Batterie longue durée pour véhicules particuliers'),
(37, 'Ampoule LED H7', 'philips_ampoule_led_h7_37.1766671693.jpeg', 'Philips', NULL, NULL, 120.00, 150.00, 'Netherlands', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'PHI-H7LED', NULL, NULL, NULL, NULL, 5, '2025-12-25 14:06:54', '2025-12-25 22:11:21', 9, 'Ampoule LED pour feux avant, longue durée'),
(38, 'Amortisseur Avant Bilstein B4', 'bilstein_amortisseur_avant_bilstein_b4_38.1766680396.jpeg', 'Bilstein', NULL, NULL, 1200.00, 1400.00, 'Germany', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'BIL-B4-AV', NULL, NULL, NULL, NULL, 39, '2025-12-25 14:12:04', '2025-12-25 21:42:26', 11, 'Amortisseur avant pour une tenue de route optimale'),
(39, 'Rotule de direction TRW', 'trw_rotule_de_direction_trw_39.1766672045.jpeg', 'TRW', NULL, NULL, 350.00, 400.00, 'Germany', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'TRW-ROT-DIR', NULL, NULL, NULL, NULL, 36, '2025-12-25 14:12:04', '2025-12-25 21:42:26', 11, 'Rotule de direction haute qualité pour une direction précise');

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

--
-- 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
('92IEYnDD0yUXOBjxOiVBdMqgjlLtkjg8PJJ8Njdk', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiWVgwMDZycGVlRmNyY2h6SmdoSERiZFNwT00xUHF5V0hkTHNWckpRMCI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMCI7czo1OiJyb3V0ZSI7czo0OiJob21lIjt9fQ==', 1766705833),
('a0W7v7OSFEIU8963y0ly2rSKZqhSCcmgseT2Eout', 1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiYUJRTjJGdVFDY25NS0RIclI4VWplYmFya1M1czNGbGh1NFpJMTNFViI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9hZG1pbi91c2VycyI7czo1OiJyb3V0ZSI7czoxNzoiYWRtaW4udXNlcnMuaW5kZXgiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aToxO30=', 1766704889),
('dYI03tC7hXoeGraEaYIyTneJZAw1Sjy89BvlFK3A', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiYzZ5WEpaS2Rud3J0d01reUljbXhvVHFQdFNXWWFhdUVoZkNZWlhQNCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMCI7czo1OiJyb3V0ZSI7czo0OiJob21lIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1766705143),
('hlK0djhewnYAdG0eiiuhgnViWJEMdkpxif1oUqMB', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoidlA0MkU2cTFsYTJ1QjJvaG54dU9UcXViSFY2RUZhajdDWHRweUowSSI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMCI7czo1OiJyb3V0ZSI7czo0OiJob21lIjt9fQ==', 1766758211),
('UHhcznS3TyOD2oKYDyATL9tkB89xP6iXniafTJ1N', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoieHQ5TVV0Yk9SRzl1Q0FFWjlVZEJUSzZ4MWs3RmdhYm0zUWpGaGprbyI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMCI7czo1OiJyb3V0ZSI7czo0OiJob21lIjt9fQ==', 1766705864);

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

--
-- Indexes for table `commandes`
--
ALTER TABLE `commandes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `commandes_user_id_foreign` (`user_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 `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 `login`
--
ALTER TABLE `login`
  ADD PRIMARY KEY (`id`),
  ADD KEY `login_user_id_foreign` (`user_id`);

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

--
-- Indexes for table `order_items`
--
ALTER TABLE `order_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `commande_pneus_commande_id_foreign` (`commande_id`),
  ADD KEY `commande_pneus_pneu_id_foreign` (`product_id`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `products_category_id_foreign` (`category_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`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `commandes`
--
ALTER TABLE `commandes`
  ADD CONSTRAINT `commandes_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `login`
--
ALTER TABLE `login`
  ADD CONSTRAINT `login_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `order_items`
--
ALTER TABLE `order_items`
  ADD CONSTRAINT `commande_pneus_commande_id_foreign` FOREIGN KEY (`commande_id`) REFERENCES `commandes` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `commande_pneus_pneu_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `products_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL;
COMMIT;

