--
-- Host: localhost    Database: covoit2025
-- ------------------------------------------------------


--
-- Table structure for table `CovoItUser`
--

CREATE TABLE `CovoItUser` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(30) NOT NULL,
  `prenom` varchar(25) NOT NULL,
  `tel` char(10) NOT NULL,
  `mail` varchar(50) NOT NULL,
  `mdp` varchar(64) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `CovoItUser`
--

INSERT INTO `CovoItUser` VALUES (1,'Dupont','Jean','0612345678','jean.dupont@email.com','a109e36947ad56de1dca1cc49f0ef8ac9ad9a7b1aa0df41fb3c4cb73c1ff01ea'),(2,'Martin','Marie','0623456789','marie.martin@email.com','b77f5643318b6f52887b23eba92f0f1068dd75a29a5be2812d4a1c1ccb19bc31'),(3,'Bernard','Pierre','0634567890','pierre.bernard@email.com','c97a00fdec57ad2f948a1f14a2607dc9c99c3d05657e5b758f4374e179adecc8'),(4,'Dubois','Sophie','0645678901','sophie.dubois@email.com','5e9d8c481c921589232875e65920ca624b8dc7a6a67c59f33b274a2d674b114c'),(5,'Moreau','Luc','0656789012','luc.moreau@email.com','826d07fc761a88984203a0b81db2c1ca2424972f74f29a3d1ae1b16626cd791f'),(6,'Dumont','Mathis','0623212319','mathis.dumont@email.com','Mathis2006');

--
-- Table structure for table `OfficeCovoit`
--

CREATE TABLE `OfficeCovoit` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jour` enum('lundi','mardi','mercredi','jeudi','vendredi') NOT NULL,
  `heure` time NOT NULL,
  `date` date NOT NULL,
  `lieu` varchar(40) NOT NULL,
  `chauffeur` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `chauffeur` (`chauffeur`),
  CONSTRAINT `OfficeCovoit_ibfk_1` FOREIGN KEY (`chauffeur`) REFERENCES `CovoItUser` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `OfficeCovoit`
--

INSERT INTO `OfficeCovoit` VALUES (1,'lundi','08:30:00','2024-01-15','Paris Gare de Lyon',1),(2,'mardi','09:00:00','2024-01-16','Paris Opéra',2),(3,'mercredi','08:45:00','2024-01-17','Paris Châtelet',3),(4,'jeudi','08:15:00','2024-01-18','Paris Montparnasse',4),(5,'vendredi','09:30:00','2024-01-19','Paris République',5),(6,'lundi','08:00:00','2024-01-22','Paris Bastille',1),(7,'mardi','08:45:00','2024-01-23','Paris Nation',2);


