-- MariaDB dump 10.19  Distrib 10.4.32-MariaDB, for Win64 (AMD64)
--
-- Host: localhost    Database: appels_offres_db
-- ------------------------------------------------------
-- Server version	10.4.32-MariaDB

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `cache`
--

DROP TABLE IF EXISTS `cache`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cache` (
  `key` varchar(255) NOT NULL,
  `value` mediumtext NOT NULL,
  `expiration` int(11) NOT NULL,
  PRIMARY KEY (`key`),
  KEY `cache_expiration_index` (`expiration`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cache`
--

LOCK TABLES `cache` WRITE;
/*!40000 ALTER TABLE `cache` DISABLE KEYS */;
/*!40000 ALTER TABLE `cache` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cache_locks`
--

DROP TABLE IF EXISTS `cache_locks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cache_locks` (
  `key` varchar(255) NOT NULL,
  `owner` varchar(255) NOT NULL,
  `expiration` int(11) NOT NULL,
  PRIMARY KEY (`key`),
  KEY `cache_locks_expiration_index` (`expiration`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cache_locks`
--

LOCK TABLES `cache_locks` WRITE;
/*!40000 ALTER TABLE `cache_locks` DISABLE KEYS */;
/*!40000 ALTER TABLE `cache_locks` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `company_certifications`
--

DROP TABLE IF EXISTS `company_certifications`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `company_certifications` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `company_profile_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `code` varchar(255) NOT NULL,
  `issuing_organization` varchar(255) DEFAULT NULL,
  `issue_date` date DEFAULT NULL,
  `expiry_date` date DEFAULT NULL,
  `is_valid` tinyint(1) NOT NULL DEFAULT 1,
  `document_path` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `company_certifications_company_profile_id_foreign` (`company_profile_id`),
  KEY `company_certifications_code_index` (`code`),
  CONSTRAINT `company_certifications_company_profile_id_foreign` FOREIGN KEY (`company_profile_id`) REFERENCES `company_profiles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `company_certifications`
--

LOCK TABLES `company_certifications` WRITE;
/*!40000 ALTER TABLE `company_certifications` DISABLE KEYS */;
INSERT INTO `company_certifications` VALUES (1,1,'ISO 9001:2015','ISO-9001','Bureau Veritas','2026-01-20','2028-09-20',1,NULL,'2026-09-20 17:02:31','2026-09-20 17:02:31'),(2,1,'ISO 14001:2015','ISO-14001','SGS International','2026-01-20','2028-09-20',1,NULL,'2026-09-20 17:02:31','2026-09-20 17:02:31'),(3,1,'Label ENEC & ENEC+','ENEC','VDE Testing Institute','2026-01-20','2028-09-20',1,NULL,'2026-09-20 17:02:31','2026-09-20 17:02:31'),(4,1,'Rapport LM-79 / LM-80 Photométrie','LM-79','Laboratoire LPEE / TÜV Rheinland','2026-01-20','2028-09-20',1,NULL,'2026-09-20 17:02:31','2026-09-20 17:02:31');
/*!40000 ALTER TABLE `company_certifications` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `company_profiles`
--

DROP TABLE IF EXISTS `company_profiles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `company_profiles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `company_name` varchar(255) NOT NULL,
  `trade_register` varchar(255) DEFAULT NULL COMMENT 'Registre de Commerce (RC)',
  `tax_id` varchar(255) DEFAULT NULL COMMENT 'IF / ICE',
  `legal_form` varchar(255) NOT NULL DEFAULT 'SARL-AU',
  `share_capital` decimal(15,2) NOT NULL DEFAULT 1000000.00,
  `annual_turnover_avg` decimal(15,2) NOT NULL DEFAULT 15000000.00 COMMENT 'CA annuel moyen',
  `max_bank_guarantee` decimal(15,2) NOT NULL DEFAULT 500000.00 COMMENT 'Plafond caution bancaire',
  `employee_count` int(11) NOT NULL DEFAULT 25,
  `technical_staff_count` int(11) NOT NULL DEFAULT 12,
  `address` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `website` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `company_profiles`
--

LOCK TABLES `company_profiles` WRITE;
/*!40000 ALTER TABLE `company_profiles` DISABLE KEYS */;
INSERT INTO `company_profiles` VALUES (1,'LUMITEC ÉNERGIE & INFRASTRUCTURE SARL','RC 189423 Casablanca','IF 40291845 / ICE 002349182000045','SARL d\'Associé Unique',3000000.00,24500000.00,450000.00,38,16,'Lotissement Industriel Sidi Maârouf, N° 45, Casablanca','+212 522 89 44 20','contact@lumitec-maroc.com','https://www.lumitec-maroc.com','2026-09-20 17:02:30','2026-09-20 17:02:30');
/*!40000 ALTER TABLE `company_profiles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `company_qualifications`
--

DROP TABLE IF EXISTS `company_qualifications`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `company_qualifications` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `company_profile_id` bigint(20) unsigned NOT NULL,
  `sector_code` varchar(255) NOT NULL COMMENT 'ex: J4, D1',
  `sector_name` varchar(255) NOT NULL COMMENT 'ex: Éclairage public, Réseau MT/BT',
  `class_level` int(11) NOT NULL COMMENT 'ex: 1, 2, 3, 4, 5 (1 etant la plus elevee ou inversement selon la nomenclature)',
  `class_label` varchar(255) NOT NULL COMMENT 'ex: Classe 3',
  `max_contract_amount` decimal(15,2) DEFAULT NULL,
  `expiration_date` date DEFAULT NULL,
  `certificate_number` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `company_qualifications_company_profile_id_foreign` (`company_profile_id`),
  CONSTRAINT `company_qualifications_company_profile_id_foreign` FOREIGN KEY (`company_profile_id`) REFERENCES `company_profiles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `company_qualifications`
--

LOCK TABLES `company_qualifications` WRITE;
/*!40000 ALTER TABLE `company_qualifications` DISABLE KEYS */;
INSERT INTO `company_qualifications` VALUES (1,1,'J4','Éclairage public et illuminations architecturales',3,'Classe 3',12000000.00,'2028-03-20','MIN-EQUIP-2024-J4-089','2026-09-20 17:02:30','2026-09-20 17:02:30'),(2,1,'D1','Réseaux de distribution électrique Basse & Moyenne Tension',4,'Classe 4',6000000.00,'2027-11-20','MIN-EQUIP-2024-D1-142','2026-09-20 17:02:30','2026-09-20 17:02:30');
/*!40000 ALTER TABLE `company_qualifications` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `company_references`
--

DROP TABLE IF EXISTS `company_references`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `company_references` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `company_profile_id` bigint(20) unsigned NOT NULL,
  `project_title` varchar(255) NOT NULL,
  `client_name` varchar(255) NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  `execution_year` int(11) NOT NULL,
  `domain` varchar(255) DEFAULT NULL,
  `certificate_of_completion` tinyint(1) NOT NULL DEFAULT 1,
  `notes` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `company_references_company_profile_id_foreign` (`company_profile_id`),
  CONSTRAINT `company_references_company_profile_id_foreign` FOREIGN KEY (`company_profile_id`) REFERENCES `company_profiles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `company_references`
--

LOCK TABLES `company_references` WRITE;
/*!40000 ALTER TABLE `company_references` DISABLE KEYS */;
INSERT INTO `company_references` VALUES (1,1,'Rénovation du réseau d\'éclairage public 3200 points lumineux LED','Commune de Rabat - SDL Rabat Région Mobilité',4200000.00,2024,'Éclairage public LED & Télégestion',1,NULL,'2026-09-20 17:02:31','2026-09-20 17:02:31'),(2,1,'Illumination architecturale de la Corniche et avenues principales','Wilaya de la Région Tanger-Tétouan-Al Hoceïma',3850000.00,2025,'Éclairage urbain & Mâts design',1,NULL,'2026-09-20 17:02:31','2026-09-20 17:02:31'),(3,1,'Extension réseau MT/BT et lampadaires solaires hybrides','Régie Autonome Multi-Services (RADEEMA)',1950000.00,2023,'Réseaux MT/BT & Photovoltaïque',1,NULL,'2026-09-20 17:02:31','2026-09-20 17:02:31');
/*!40000 ALTER TABLE `company_references` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `failed_jobs`
--

DROP TABLE IF EXISTS `failed_jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `failed_jobs`
--

LOCK TABLES `failed_jobs` WRITE;
/*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `job_batches`
--

DROP TABLE IF EXISTS `job_batches`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `job_batches`
--

LOCK TABLES `job_batches` WRITE;
/*!40000 ALTER TABLE `job_batches` DISABLE KEYS */;
/*!40000 ALTER TABLE `job_batches` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jobs`
--

DROP TABLE IF EXISTS `jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) unsigned NOT NULL,
  `reserved_at` int(10) unsigned DEFAULT NULL,
  `available_at` int(10) unsigned NOT NULL,
  `created_at` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `jobs`
--

LOCK TABLES `jobs` WRITE;
/*!40000 ALTER TABLE `jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `jobs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `migrations`
--

DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `migrations`
--

LOCK TABLES `migrations` WRITE;
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
INSERT INTO `migrations` VALUES (1,'0001_01_01_000000_create_users_table',1),(2,'0001_01_01_000001_create_cache_table',1),(3,'0001_01_01_000002_create_jobs_table',1),(4,'2026_09_20_000001_create_company_profiles_and_relations_tables',2),(5,'2026_09_20_000002_create_products_table',2),(6,'2026_09_20_000003_create_tenders_and_relations_tables',2);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `password_reset_tokens`
--

DROP TABLE IF EXISTS `password_reset_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `password_reset_tokens`
--

LOCK TABLES `password_reset_tokens` WRITE;
/*!40000 ALTER TABLE `password_reset_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `password_reset_tokens` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `products`
--

DROP TABLE IF EXISTS `products`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `products` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `reference` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `brand` varchar(255) DEFAULT NULL,
  `category` varchar(255) NOT NULL DEFAULT 'Luminaire Routier LED',
  `power_watts` decimal(8,2) DEFAULT NULL,
  `luminous_flux_lumens` decimal(10,2) DEFAULT NULL,
  `efficacy_lm_per_w` decimal(6,2) DEFAULT NULL,
  `color_temp_cct` varchar(255) DEFAULT NULL COMMENT 'ex: 3000K, 4000K',
  `cri` int(11) NOT NULL DEFAULT 70,
  `ip_protection` varchar(255) NOT NULL DEFAULT 'IP66',
  `ik_protection` varchar(255) NOT NULL DEFAULT 'IK09',
  `enec_certified` tinyint(1) NOT NULL DEFAULT 1,
  `lm79_tested` tinyint(1) NOT NULL DEFAULT 1,
  `surge_protection_kv` varchar(255) NOT NULL DEFAULT '10kV',
  `unit_price` decimal(12,2) DEFAULT NULL,
  `datasheet_path` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `products_reference_unique` (`reference`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `products`
--

LOCK TABLES `products` WRITE;
/*!40000 ALTER TABLE `products` DISABLE KEYS */;
INSERT INTO `products` VALUES (1,'LUM-URBAN-060','Luminaire Urbain LED Aura 60W','Lumitec Pro','Luminaire Routier LED',60.00,8400.00,140.00,'3000K / 4000K',70,'IP66','IK09',1,1,'10kV',1450.00,NULL,'2026-09-20 17:02:31','2026-09-20 17:02:31'),(2,'LUM-AVENUE-120','Luminaire Grandes Artères Highway 120W','Lumitec Pro','Luminaire Voies Rapides',120.00,18000.00,150.00,'4000K',75,'IP66','IK10',1,1,'10kV / 20kV',2850.00,NULL,'2026-09-20 17:02:31','2026-09-20 17:02:31');
/*!40000 ALTER TABLE `products` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sessions`
--

DROP TABLE IF EXISTS `sessions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sessions`
--

LOCK TABLES `sessions` WRITE;
/*!40000 ALTER TABLE `sessions` DISABLE KEYS */;
INSERT INTO `sessions` VALUES ('9jRlFcXNuYbVpyGf2u7GrgwU3v2CON2ykSlGAZPP',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:155.0) Gecko/20100101 Firefox/155.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiMEs2QXVrY0dTVUhhdnR2OWtHeVJjU2tReWNEc1J2OEhoWU5pbEVGTSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDk6Imh0dHA6Ly9sb2NhbGhvc3QvYXBwc2xhcmF2L3B1YmxpYy9jb21wYW55LXByb2ZpbGUiO3M6NToicm91dGUiO3M6MTU6ImNvbXBhbnkucHJvZmlsZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1789924415);
/*!40000 ALTER TABLE `sessions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tender_criteria_evaluations`
--

DROP TABLE IF EXISTS `tender_criteria_evaluations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tender_criteria_evaluations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tender_id` bigint(20) unsigned NOT NULL,
  `tender_requirement_id` bigint(20) unsigned NOT NULL,
  `status` enum('compliant','warning','blocking_fail') NOT NULL DEFAULT 'compliant',
  `match_score` int(11) NOT NULL DEFAULT 100,
  `actual_company_value` varchar(255) DEFAULT NULL COMMENT 'Ce que possède l''entreprise en comparaison',
  `explanation` text DEFAULT NULL,
  `recommendation` text DEFAULT NULL,
  `missing_document_hint` varchar(255) DEFAULT NULL COMMENT 'Document manquant à préparer pour soumissionner',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tender_criteria_evaluations_tender_id_foreign` (`tender_id`),
  KEY `tender_criteria_evaluations_tender_requirement_id_foreign` (`tender_requirement_id`),
  CONSTRAINT `tender_criteria_evaluations_tender_id_foreign` FOREIGN KEY (`tender_id`) REFERENCES `tenders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `tender_criteria_evaluations_tender_requirement_id_foreign` FOREIGN KEY (`tender_requirement_id`) REFERENCES `tender_requirements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tender_criteria_evaluations`
--

LOCK TABLES `tender_criteria_evaluations` WRITE;
/*!40000 ALTER TABLE `tender_criteria_evaluations` DISABLE KEYS */;
INSERT INTO `tender_criteria_evaluations` VALUES (1,1,1,'compliant',100,'Classe 3 (Valide jusqu\'au 20/03/2028)','Qualification conforme : L\'entreprise détient la Classe 3 (Secteur J4), ce qui satisfait l\'exigence de Classe 3.','Joindre la copie conforme du certificat de qualification et de classification en cours de validité.',NULL,'2026-09-20 17:02:31','2026-09-20 17:02:31'),(2,1,2,'compliant',100,'Certifié Label ENEC & ENEC+','Certification validée : Label ENEC & ENEC+ détenue et active.','Insérer les fiches d\'homologation et copies de certificats dans le dossier technique.',NULL,'2026-09-20 17:02:31','2026-09-20 17:02:31'),(3,1,3,'compliant',100,'Certifié Rapport LM-79 / LM-80 Photométrie','Certification validée : Rapport LM-79 / LM-80 Photométrie détenue et active.','Insérer les fiches d\'homologation et copies de certificats dans le dossier technique.',NULL,'2026-09-20 17:02:31','2026-09-20 17:02:31'),(4,1,4,'compliant',100,'Certifié ISO 9001:2015','Certification validée : ISO 9001:2015 détenue et active.','Insérer les fiches d\'homologation et copies de certificats dans le dossier technique.',NULL,'2026-09-20 17:02:31','2026-09-20 17:02:31'),(5,1,5,'compliant',100,'Gamme disponible au catalogue (ex: Luminaires IP66/IK09 certifiés)','Spécification technique standard couverte par le catalogue de luminaires de l\'entreprise.','Joindre la fiche technique produit certifiée par le laboratoire d\'usine.',NULL,'2026-09-20 17:02:31','2026-09-20 17:02:31'),(6,1,11,'compliant',100,'Plafond disponible : 450 000,00 DH','Capacité financière et caution bancaire suffisantes pour couvrir l\'appel d\'offres.','Demander l\'émission de la caution provisoire au moins 4 jours avant le dépôt.',NULL,'2026-09-20 17:02:31','2026-09-20 17:02:31'),(7,2,6,'compliant',100,'Classe 3 (Valide jusqu\'au 20/03/2028)','Qualification conforme : L\'entreprise détient la Classe 3 (Secteur J4), ce qui satisfait l\'exigence de Classe 3.','Joindre la copie conforme du certificat de qualification et de classification en cours de validité.',NULL,'2026-09-20 17:02:31','2026-09-20 17:02:31'),(8,2,7,'warning',50,'Non répertoriée','Certification Certification Santé & Sécurité ISO 45001 non répertoriée dans le profil actif de l\'entreprise.','Solliciter l\'attestation fabricant/fournisseur partenaire pour cette norme.','Attestation / Rapport de conformité ISO-45001','2026-09-20 17:02:31','2026-09-20 17:02:31'),(9,2,8,'compliant',100,'Certifié Label ENEC & ENEC+','Certification validée : Label ENEC & ENEC+ détenue et active.','Insérer les fiches d\'homologation et copies de certificats dans le dossier technique.',NULL,'2026-09-20 17:02:31','2026-09-20 17:02:31'),(10,2,12,'compliant',100,'Plafond disponible : 450 000,00 DH','Capacité financière et caution bancaire suffisantes pour couvrir l\'appel d\'offres.','Demander l\'émission de la caution provisoire au moins 4 jours avant le dépôt.',NULL,'2026-09-20 17:02:31','2026-09-20 17:02:31'),(11,3,9,'blocking_fail',0,'Non détenue','L\'entreprise ne dispose pas de la qualification exigée J4-CLASSE-1 (Agrément BTP Secteur J4 Classe 1).','Candidater en groupement conjoint avec un partenaire qualifié dans ce secteur.','Certificat de qualification BTP secteur J4-CLASSE-1','2026-09-20 17:02:31','2026-09-20 17:02:31'),(12,3,10,'blocking_fail',0,'Non répertoriée','Certification Homologation Balisage OACI Annexe 14 non répertoriée dans le profil actif de l\'entreprise.','Solliciter l\'attestation fabricant/fournisseur partenaire pour cette norme.','Attestation / Rapport de conformité OACI-FAA','2026-09-20 17:02:31','2026-09-20 17:02:31'),(13,3,13,'blocking_fail',20,'Plafond caution : 450 000,00 DH','Dépassement du plafond de cautionnement de l\'entreprise.','Négocier une extension temporaire avec votre banque ou envisager un groupement solidaire.','Attestation d\'engagement bancaire','2026-09-20 17:02:31','2026-09-20 17:02:31'),(14,6,14,'compliant',100,'Plafond disponible : 450 000,00 DH','Capacité financière et caution bancaire suffisantes pour couvrir l\'appel d\'offres.','Demander l\'émission de la caution provisoire au moins 4 jours avant le dépôt.',NULL,'2026-09-20 17:12:52','2026-09-20 17:12:52');
/*!40000 ALTER TABLE `tender_criteria_evaluations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tender_documents`
--

DROP TABLE IF EXISTS `tender_documents`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tender_documents` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tender_id` bigint(20) unsigned NOT NULL,
  `original_name` varchar(255) NOT NULL,
  `file_path` varchar(255) NOT NULL,
  `document_type` enum('cps','reglement_consultation','bordereau_prix','acte_engagement','dce_complet','autre') NOT NULL DEFAULT 'cps',
  `mime_type` varchar(255) DEFAULT NULL,
  `file_size` bigint(20) unsigned DEFAULT NULL,
  `extracted_text` longtext DEFAULT NULL COMMENT 'Texte brut extrait pour analyse regex / IA',
  `is_ocr_processed` tinyint(1) NOT NULL DEFAULT 0,
  `parsing_status` enum('pending','parsed','failed') NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tender_documents_tender_id_foreign` (`tender_id`),
  CONSTRAINT `tender_documents_tender_id_foreign` FOREIGN KEY (`tender_id`) REFERENCES `tenders` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tender_documents`
--

LOCK TABLES `tender_documents` WRITE;
/*!40000 ALTER TABLE `tender_documents` DISABLE KEYS */;
INSERT INTO `tender_documents` VALUES (1,1,'CPS_AO_18_2026_Casablanca_Eclairage_Anfa.pdf','demo/cps_18_2026.pdf','cps','application/pdf',3840120,'Royaume du Maroc - Commune de Casablanca. Appel d\'offres ouvert N° 18/2026/CASABLANCA. Objet : Mise à niveau de l\'éclairage public. Estimation du maître d\'ouvrage : 3.600.000,00 DH TTC. Cautionnement provisoire : 50.000,00 DH. Le concurrent doit justifier du Secteur J4 Classe 3 ou supérieure. Certifications obligatoires : ENEC pour les luminaires, rapport d\'essais photométriques LM-79, système de management ISO 9001. Bureau d\'Études Techniques : BET Alami Ingénierie Casablanca. Tél : 0522-334455, Email : contact@alami-bet.ma.',1,'parsed','2026-09-20 17:02:31','2026-09-20 17:02:31'),(2,2,'CPS_AO_42_2026_Marrakech_Solaire.pdf','demo/cps_42_2026.pdf','cps','application/pdf',4201000,'Région Marrakech-Safi. AO N° 42/2026/MARRAKECH. Montant estimatif : 5.900.000 DH. Caution provisoire : 95.000 DH. Qualification exigée : Secteur J4 Classe 3. Certification ISO 45001 requise (Santé et Sécurité au Travail). Certification ENEC pour appareillage. Architecte : Cabinet Archikrakh Marrakech. Tél : 0524-448899.',1,'parsed','2026-09-20 17:02:31','2026-09-20 17:02:31'),(3,3,'CPS_ONDA_AO_05_2026_Balisage.pdf','demo/cps_05_2026.pdf','cps','application/pdf',8500200,'ONDA - AO N° 05/2026/ONDA. Montant estimatif : 38.000.000 DH. Cautionnement provisoire : 600.000 DH. Qualification BTP exigée : Secteur J4 Classe 1 (Exclusivement). Certification FAA / OACI balisage aéroportuaire. Bureau d\'études : Bureau International Egis Airports.',1,'parsed','2026-09-20 17:02:31','2026-09-20 17:02:31'),(4,4,'Facture_44_2026.pdf','tender_documents/4/1789924002_facture-44-2026.pdf','cps','application/pdf',62494,NULL,0,'pending','2026-09-20 17:06:42','2026-09-20 17:06:42');
/*!40000 ALTER TABLE `tender_documents` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tender_requirements`
--

DROP TABLE IF EXISTS `tender_requirements`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tender_requirements` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tender_id` bigint(20) unsigned NOT NULL,
  `category` enum('qualification','certification','technique','administratif','financier','humain','reference') NOT NULL DEFAULT 'qualification',
  `code` varchar(255) DEFAULT NULL COMMENT 'ex: J4, ENEC, ISO-9001, IP66, CAUTION',
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `required_value` varchar(255) DEFAULT NULL COMMENT 'ex: Classe 3, 20.000 DH, Certifié LM-79',
  `is_mandatory` tinyint(1) NOT NULL DEFAULT 1,
  `is_blocking` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Si non respecté, rend l''AO non-compatible immédiatement',
  `detection_method` enum('regex','ai','manual') NOT NULL DEFAULT 'regex',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tender_requirements_tender_id_foreign` (`tender_id`),
  CONSTRAINT `tender_requirements_tender_id_foreign` FOREIGN KEY (`tender_id`) REFERENCES `tenders` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tender_requirements`
--

LOCK TABLES `tender_requirements` WRITE;
/*!40000 ALTER TABLE `tender_requirements` DISABLE KEYS */;
INSERT INTO `tender_requirements` VALUES (1,1,'qualification','J4','Agrément BTP Secteur J4','Qualification BTP Secteur J4 Classe 3 ou supérieure exigée.','Classe 3',1,1,'regex','2026-09-20 17:02:31','2026-09-20 17:02:31'),(2,1,'certification','ENEC','Certification ENEC / ENEC+','Certificat de sécurité électrique et performance luminaire ENEC.','Certificat valide',1,1,'regex','2026-09-20 17:02:31','2026-09-20 17:02:31'),(3,1,'certification','LM-79','Rapport LM-79 Laboratoire','Essais photométriques complets selon méthode IES LM-79.','Rapport officiel',1,1,'regex','2026-09-20 17:02:31','2026-09-20 17:02:31'),(4,1,'certification','ISO-9001','Management de la qualité ISO 9001','Système de management de la qualité ISO 9001:2015.','Certificat actif',1,0,'regex','2026-09-20 17:02:31','2026-09-20 17:02:31'),(5,1,'technique','IP66','Indice de protection IP66 / IK09','Bloc optique étanche IP66 et protection IK09 minimum.','IP66 IK09',1,0,'regex','2026-09-20 17:02:31','2026-09-20 17:02:31'),(6,2,'qualification','J4','Agrément BTP Secteur J4','Secteur J4 Classe 3 ou supérieure.','Classe 3',1,1,'regex','2026-09-20 17:02:31','2026-09-20 17:02:31'),(7,2,'certification','ISO-45001','Certification Santé & Sécurité ISO 45001','Certificat du système de management SST ISO 45001:2018.','Certificat valide',0,0,'regex','2026-09-20 17:02:31','2026-09-20 17:02:31'),(8,2,'certification','ENEC','Certification ENEC','Marquage de conformité européenne ENEC.','Certifié',1,1,'regex','2026-09-20 17:02:31','2026-09-20 17:02:31'),(9,3,'qualification','J4-CLASSE-1','Agrément BTP Secteur J4 Classe 1','Qualification ministérielle Classe 1 (Chiffre d\'affaires et moyens exceptionnels requis).','Classe 1',1,1,'regex','2026-09-20 17:02:31','2026-09-20 17:02:31'),(10,3,'certification','OACI-FAA','Homologation Balisage OACI Annexe 14','Certificat international pour éclairage aéronautique.','OACI Valide',1,1,'regex','2026-09-20 17:02:31','2026-09-20 17:02:31'),(11,1,'financier','CAUTION','Cautionnement Provisoire Requis','Montant de la caution bancaire exigée : 50 000,00 DH','50 000,00 DH',1,1,'regex','2026-09-20 17:02:31','2026-09-20 17:02:31'),(12,2,'financier','CAUTION','Cautionnement Provisoire Requis','Montant de la caution bancaire exigée : 95 000,00 DH','95 000,00 DH',1,1,'regex','2026-09-20 17:02:31','2026-09-20 17:02:31'),(13,3,'financier','CAUTION','Cautionnement Provisoire Requis','Montant de la caution bancaire exigée : 600 000,00 DH','600 000,00 DH',1,1,'regex','2026-09-20 17:02:31','2026-09-20 17:02:31'),(14,6,'financier','CAUTION','Cautionnement Provisoire Requis','Montant de la caution bancaire exigée : 6 000,00 DH','6 000,00 DH',1,1,'regex','2026-09-20 17:12:52','2026-09-20 17:12:52');
/*!40000 ALTER TABLE `tender_requirements` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tender_stakeholders`
--

DROP TABLE IF EXISTS `tender_stakeholders`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tender_stakeholders` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tender_id` bigint(20) unsigned NOT NULL,
  `role` enum('maitre_ouvrage','bet','architecte','bureau_controle','fournisseur','autre') NOT NULL DEFAULT 'bet',
  `name` varchar(255) NOT NULL,
  `organization` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `detected_from_signature` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tender_stakeholders_tender_id_foreign` (`tender_id`),
  CONSTRAINT `tender_stakeholders_tender_id_foreign` FOREIGN KEY (`tender_id`) REFERENCES `tenders` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tender_stakeholders`
--

LOCK TABLES `tender_stakeholders` WRITE;
/*!40000 ALTER TABLE `tender_stakeholders` DISABLE KEYS */;
INSERT INTO `tender_stakeholders` VALUES (1,1,'maitre_ouvrage','Commune de Casablanca - Division Éclairage','Commune de Casablanca','+212 522 20 11 00','marches@casablanca.ma','Place Mohammed V, Casablanca',0,NULL,'2026-09-20 17:02:31','2026-09-20 17:02:31'),(2,1,'bet','Ing. Khalid Alami','BET Alami Ingénierie & Énergie','+212 522 33 44 55','contact@alami-bet.ma','24 Boulevard Zerktouni, Casablanca',1,'Signature et cachet identifiés en page de garde du CPS','2026-09-20 17:02:31','2026-09-20 17:02:31'),(3,2,'architecte','Arch. Youssef Marrakech','Atelier Architecture & Urbanisme Guéliz','+212 524 44 88 99','youssef@archigueliz.ma','Avenue Mohammed V, Marrakech',1,NULL,'2026-09-20 17:02:31','2026-09-20 17:02:31');
/*!40000 ALTER TABLE `tender_stakeholders` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tenders`
--

DROP TABLE IF EXISTS `tenders`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tenders` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `reference` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `client_name` varchar(255) NOT NULL COMMENT 'Maître d''ouvrage',
  `client_type` varchar(255) DEFAULT NULL COMMENT 'Commune, Ministère, Régie, Privé',
  `location` varchar(255) DEFAULT NULL,
  `sector` varchar(255) NOT NULL DEFAULT 'Éclairage public / Installations Électriques',
  `estimated_budget` decimal(15,2) DEFAULT NULL COMMENT 'Montant estimatif du marché (TTC/HT)',
  `provisional_guarantee` decimal(15,2) DEFAULT NULL COMMENT 'Cautionnement provisoire',
  `publication_date` date DEFAULT NULL,
  `submission_deadline` datetime NOT NULL COMMENT 'Date et heure limite de remise des offres',
  `opening_session_date` datetime DEFAULT NULL COMMENT 'Séance d''ouverture des plis',
  `execution_delay_days` int(11) DEFAULT NULL COMMENT 'Délai d''exécution en jours ou mois',
  `status` enum('nouveau','en_analyse','analyse_terminee','offre_deposee','archive') NOT NULL DEFAULT 'nouveau',
  `decision_status` enum('compatible','a_verifier','non_compatible','en_attente') NOT NULL DEFAULT 'en_attente',
  `compatibility_score` int(11) NOT NULL DEFAULT 0 COMMENT 'Pourcentage 0-100%',
  `preparation_time_days` int(11) NOT NULL DEFAULT 5 COMMENT 'Estimation du temps nécessaire pour préparer l''offre',
  `decision_summary` text DEFAULT NULL COMMENT 'Synthèse de conformité et alertes',
  `ai_analysis_summary` longtext DEFAULT NULL COMMENT 'Compte-rendu détaillé généré par IA / OCR',
  `estimated_margin_rate` decimal(5,2) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tenders_reference_unique` (`reference`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tenders`
--

LOCK TABLES `tenders` WRITE;
/*!40000 ALTER TABLE `tenders` DISABLE KEYS */;
INSERT INTO `tenders` VALUES (1,'AO-18/2026/CASABLANCA','Mise à niveau et rénovation du parc d\'éclairage public par luminaires LED - Boulevard d\'Anfa et Corniche','Commune de Casablanca - Direction Générale des Services Techniques','Collectivité Territoriale','Casablanca - Arrondissement Anfa','Éclairage public / Efficacité énergétique',3600000.00,50000.00,'2026-09-14','2026-10-12 11:00:31','2026-10-12 11:30:31',120,'analyse_terminee','compatible',100,6,'🟢 COMPATIBLE (Score: 100%) - Feu vert total. L\'entreprise satisfait l\'ensemble des qualifications requises, certifications (ENEC, LM-79, ISO), et dispose de la capacité financière nécessaire.',NULL,NULL,'2026-09-20 17:02:31','2026-09-20 17:02:31'),(2,'AO-42/2026/MARRAKECH','Fourniture et pose de mâts décoratifs, candélabres solaires et extensions MT - Voie de contournement Palmeraie','Conseil Régional Marrakech-Safi','Région / Établissement Public','Marrakech','Éclairage public & Énergie Solaire',5900000.00,95000.00,'2026-09-16','2026-09-27 10:00:31','2026-09-27 10:30:31',150,'analyse_terminee','a_verifier',75,5,'🟠 À VÉRIFIER (Score: 75%) - Opportunité intéressante avec 1 point(s) d\'attention technique ou administratif à lever. Documents / Démarches clés : Attestation ISO-45001',NULL,NULL,'2026-09-20 17:02:31','2026-09-20 17:02:31'),(3,'AO-05/2026/ONDA','Éclairage haute puissance des aires de stationnement avions et balisage piste Terminal 3','Office National Des Aéroports (ONDA)','Établissement Public Stratégique','Nouaceur - Aéroport Mohammed V','Infrastructures Aéroportuaires / Haute Puissance',38000000.00,600000.00,'2026-09-18','2026-10-18 10:00:31','2026-10-18 10:30:31',240,'analyse_terminee','non_compatible',0,8,'🔴 NON COMPATIBLE (Score: 0%) - Présence de points bloquants éliminatoires : L\'entreprise ne dispose pas de la qualification exigée J4-CLASSE-1 (Agrément BTP Secteur J4 Classe 1). • Certification Homologation Balisage OACI Annexe 14 non répertoriée dans le profil actif de l\'entreprise. • La caution provisoire (600 000 DH) dépasse le plafond bancaire de l\'entreprise (450 000 DH).',NULL,NULL,'2026-09-20 17:02:31','2026-09-20 17:02:31'),(4,'343234','dfdf','Markos',NULL,NULL,'Éclairage public / Installations Électriques',NULL,NULL,'2026-09-20','2026-10-10 10:00:42',NULL,NULL,'en_analyse','en_attente',0,5,NULL,NULL,NULL,'2026-09-20 17:06:42','2026-09-20 17:06:42'),(6,'34323','dfdf','Markos',NULL,NULL,'Éclairage public / Installations Électriques',7000.00,6000.00,'2026-09-20','2026-09-20 12:00:00',NULL,NULL,'analyse_terminee','a_verifier',100,5,'🟠 À VÉRIFIER (Score: 100%) - Opportunité intéressante avec 1 point(s) d\'attention technique ou administratif à lever. Documents / Démarches clés : Accélération urgente du montage de l\'offre technique et financière (J-0 restant)',NULL,NULL,'2026-09-20 17:12:52','2026-09-20 17:12:52');
/*!40000 ALTER TABLE `tenders` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'Directeur Technique (Lumitec)','admin@tenderpulse.com',NULL,'$2y$12$esiRnfTtEVeNV3Yl2WxcMuI8lfNExdEmQK3mMHwJ54Qh/eVHqxMY6',NULL,'2026-09-20 17:19:39','2026-09-20 17:19:39');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-09-20 17:20:24
