bloc2_java_projet_autoecole.sql

-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Hôte : 127.0.0.1:3306
-- Généré le : ven. 31 mars 2023 à 10:40
-- Version du serveur : 8.0.31
-- Version de PHP : 8.0.26

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!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 */;

--
-- Base de données : `bloc2_java_projet_autoecole`
--

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

--
-- Structure de la table `administrateur`
--

DROP TABLE IF EXISTS `administrateur`;
CREATE TABLE IF NOT EXISTS `administrateur` (
  `CodeAdministrateur` int NOT NULL AUTO_INCREMENT,
  `Nom` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Prenom` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Sexe` tinyint NOT NULL,
  `DateDeNaissance` date DEFAULT NULL,
  `Adresse` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `CodePostal` varchar(5) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Ville` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Telephone` varchar(11) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Login` varchar(32) NOT NULL,
  `Password` varchar(256) NOT NULL,
  PRIMARY KEY (`CodeAdministrateur`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `administrateur` (`CodeAdministrateur`, `Nom`, `Prenom`, `Sexe`, `DateDeNaissance`, `Adresse`, `CodePostal`, `Ville`, `Telephone`, `Login`, `Password`) VALUES
(1, 'Buffeteau', 'Jacques', 1, '1975-12-19', '5 rue des Morrilons', '75015', 'Paris', '061818271', 'jBuff', 'Mbappe07&'),
(2, 'Tahiri', 'Brahim', 0, '2023-03-01', '1 rue place d\'Italie', '75000', 'Paris', '0600000000', 'btahiri', 'btahiri');

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

--
-- Structure de la table `categorie`
--

DROP TABLE IF EXISTS `categorie`;
CREATE TABLE IF NOT EXISTS `categorie` (
  `CodeCategorie` int NOT NULL,
  `Libelle` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Prix` double(5,2) NOT NULL,
  PRIMARY KEY (`CodeCategorie`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `categorie` (`CodeCategorie`, `Libelle`, `Prix`) VALUES
(1, 'Automobile', 34.95),
(2, 'Poids lourd', 43.00),
(3, 'Bateau', 51.25),
(4, 'Moto', 38.15),
(5, 'Transport en commun', 40.50);

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

--
-- Structure de la table `eleve`
--

DROP TABLE IF EXISTS `eleve`;
CREATE TABLE IF NOT EXISTS `eleve` (
  `CodeEleve` int NOT NULL,
  `NOM` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Prenom` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Sexe` varchar(5) DEFAULT NULL,
  `DateDeNaissance` date DEFAULT NULL,
  `Adresse` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `CodePostal` int DEFAULT NULL,
  `Ville` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Telephone` varchar(12) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Login` varchar(32) NOT NULL,
  `Password` varchar(256) NOT NULL,
  PRIMARY KEY (`CodeEleve`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `eleve` (`CodeEleve`, `NOM`, `Prenom`, `Sexe`, `DateDeNaissance`, `Adresse`, `CodePostal`, `Ville`, `Telephone`, `Login`, `Password`) VALUES
(8, 'Gnocchi', 'Gwendoline', '1', NULL, NULL, 75008, 'Paris', '0104310779', 'GnoGwennie', 'jAimeLesPates'),
(16, 'Macaroni', 'Mazarine', '1', '1982-06-01', NULL, 75016, 'Paris', '0118060182', 'MacronMaza', 'BrigittelABosse'),
(18, 'Ossobucco', 'Omer', '0', '1981-07-03', '4 rue des averons', 75018, 'Paris', '0117070381', 'Osso', 'Os'),
(22, 'Spaghetti', 'Sophie', '1', '1979-09-07', NULL, 75002, 'Paris', '0115090779', 'Bolognaise', 'Càrbonara08'),
(23, 'Tortellini', 'Théodule', '0', NULL, NULL, 75003, 'Paris', '0114210880', 'théoCredule', 'Tortelloé'),
(41, 'Pomadoro', 'Pistache', '1', NULL, NULL, 75001, 'Paris', '0116141178', '', ''),
(53, 'Cannelloni', 'Célestine', '1', NULL, NULL, 75003, 'Paris', '0171737579', '', ''),
(57, 'Ravioli', 'Romuald', '0', NULL, NULL, 75017, 'Paris', '0109210781', '', ''),
(63, 'Baccalaõ', 'Brutus', '0', '1979-11-09', NULL, 75003, 'Paris', '0145464748', '', ''),
(64, 'Tortilla', 'Tania', '1', NULL, NULL, 75004, 'Paris', '0122270181', '', ''),
(70, 'Vermicellini', 'Véronique', '1', NULL, NULL, 75010, 'Paris', '0128220381', '', ''),
(71, 'Tagliatelli', 'Thomas', '0', NULL, NULL, 75011, 'Paris', '', '', ''),
(77, 'Ghappati', 'Gontrand', '0', '1981-12-02', NULL, 75017, 'Paris', '0135120281', '', ''),
(84, 'Busecca', 'Bruce', '0', '1981-11-07', NULL, 75004, 'Paris', '0187868584', '', ''),
(85, 'Carpaccio', 'Clémentine', '1', NULL, NULL, 75005, 'Paris', '0142130781', '', ''),
(87, 'Chipolata', 'Charlotte', '1', NULL, NULL, 75007, 'Paris', '0144220379', '', ''),
(91, 'Broccoli', 'Basile', '0', '1981-02-07', NULL, 75011, 'Paris', '0176757473', '', ''),
(92, 'Farfalle', 'Fernande', '1', NULL, NULL, 75012, 'Paris', '0148141281', '', ''),
(93, 'Lasagne', 'Lazare', '0', NULL, NULL, 75013, 'Paris', '0149130481', '', ''),
(95, 'Risotto', 'Rolande', '1', NULL, NULL, 75015, 'Paris', '0151170280', '', ''),
(96, 'Polenta', 'Paule', '1', NULL, NULL, 75016, 'Paris', '0152290379', '', ''),
(97, 'Tapioca', 'Thérèse', '1', '1980-08-05', NULL, 75017, 'Paris', '0153080580', '', ''),
(100, 'Mozzarella', 'Milène', '1', '1979-09-10', NULL, 75020, 'Paris', '0156091079', '', ''),
(102, 'Caponata', 'Clovis', '0', '1980-07-06', NULL, 75002, 'Paris', '0158070680', '', ''),
(106, 'Clafouti', 'Cornelia', '1', NULL, NULL, 75006, 'Paris', '0162210281', '', ''),
(110, 'Fettucine', 'Félicie', '1', '1981-06-05', NULL, 75010, 'Paris', '0110060581', '', ''),
(111, 'Rigatoni', 'Rita', '1', NULL, NULL, 75011, 'Paris', '0161280681', '', ''),
(112, 'Cappelletti', 'Clémence', '1', '1981-12-10', NULL, 75012, 'Paris', '0165091011', '', ''),
(113, 'Antipasta', 'Amadeus', '0', NULL, NULL, 75013, 'Paris', '0123242526', '', ''),
(114, 'Scaloppine', 'Scarlet', '1', NULL, NULL, 75014, 'Paris', '0127091283', '', ''),
(115, 'Anguilla', 'Amandine', '1', NULL, NULL, 75015, 'Paris', '0112131415', '', ''),
(116, 'Bagnacauda', 'Brigitte', '1', NULL, NULL, 75016, 'Paris', '0156575859', '', ''),
(117, 'Funghi', 'Fiona', '1', NULL, NULL, 75017, 'Paris', '0187767583', '', ''),
(118, 'Melanzane', 'Mélanie', '1', NULL, NULL, 75018, 'Paris', '0154467985', '', ''),
(119, 'Fagioli', 'Ferdinand', '0', NULL, NULL, 75019, 'Paris', '0189888786', '', ''),
(120, 'Vongole', 'Véronica', '1', NULL, NULL, 75020, 'Paris', '0145464748', '', ''),
(121, 'Pesce', 'Pascaline', '1', NULL, NULL, 75001, 'Paris', '0131323334', '', ''),
(122, 'Cozze', 'Charline', '1', NULL, NULL, 75002, 'Paris', '0117191613', '', ''),
(123, 'Stracciatella', 'Sabrina', '1', '1975-05-05', NULL, 75003, 'Paris', '0131649728', '', ''),
(124, 'Minestrone', 'Martina', '1', NULL, NULL, 75004, 'Paris', '0195969798', '', ''),
(125, 'Pavese', 'Pietro', '0', '1979-08-07', NULL, 75005, 'Paris', '0107080910', '', ''),
(126, 'Fonduta', 'Florence', '1', '1979-09-09', NULL, 75006, 'Paris', '0103050709', '', ''),
(127, 'Carozza', 'Cunégonde', '1', NULL, NULL, 75007, 'Paris', '0105090307', '', ''),
(128, 'Calzone', 'Corentin', '0', NULL, NULL, 75008, 'Paris', '0186848280', '', ''),
(129, 'Tortino', 'Terrence', '0', '1980-05-12', NULL, 75009, 'Paris', '0104070205', '', ''),
(130, 'Carciofi', 'Christian', '0', NULL, NULL, 75010, 'Paris', '0103060908', '', ''),
(131, 'Scampi', 'Simone', '1', '1982-01-05', NULL, 75011, 'Paris', '0104050607', '', ''),
(132, 'Limone', 'Léon', '0', '1981-08-09', NULL, 75012, 'Paris', '0192969498', '', ''),
(133, 'Bisi', 'Bénédicte', '1', '1979-07-08', NULL, 75013, 'Paris', '0165646362', '', ''),
(134, 'Uova', 'Ursule', '1', NULL, NULL, 75014, 'Paris', '0103050709', '', ''),
(135, 'Carbonara', 'Camille', '1', '1979-11-10', NULL, 75015, 'Paris', '0151535759', '', ''),
(136, 'Uccelletto', 'Ulla', '1', NULL, NULL, 75016, 'Paris', '0108060402', '', ''),
(137, 'Cavoli', 'Constant', '0', NULL, NULL, 75017, 'Paris', '0104040404', '', ''),
(138, 'Prosciutto', 'Priscilla', '1', NULL, NULL, 75018, 'Paris', '0151525354', '', ''),
(139, 'Peperonata', 'Patricia', '1', '1972-08-05', NULL, 75019, 'Paris', '0159575553', '', ''),
(140, 'Spinaci', 'Steve', '0', '1979-06-04', NULL, 75020, 'Paris', '0186848280', '', ''),
(141, 'Parmigiana', 'Patrick', '0', NULL, NULL, 75001, 'Paris', '0102050809', '', ''),
(142, 'Tegame', 'Thierry', '0', '1976-06-16', NULL, 75002, 'Paris', '0104060709', '', ''),
(143, 'Zucchini', 'Zoé', '1', NULL, NULL, 75003, 'Paris', '0108070504', '', ''),
(144, 'Aragosta', 'Armande', '1', NULL, NULL, 75004, 'Paris', '0134353637', '', ''),
(145, 'Trotelle', 'Teresa', '1', NULL, NULL, 75005, 'Paris', '0160824281', '', ''),
(146, 'Cacciucco', 'Christelle', '1', '1980-09-11', NULL, 57006, 'Paris', '0197959391', '', ''),
(147, 'Ostriche', 'Ornella', '1', NULL, NULL, 75007, 'Paris', '0194989692', '', ''),
(148, 'Triglie', 'Théodule', '0', NULL, NULL, 75008, 'Paris', '0168646662', '', ''),
(149, 'Pollo', 'Polo', '0', NULL, NULL, 75009, 'Paris', '0174859652', '', ''),
(150, 'Cacciatora', 'Carmen', '1', '1979-09-09', NULL, 75010, 'Paris', '0198979695', '', ''),
(151, 'Peperoni', 'Pierre', '0', '1981-11-11', NULL, 75011, 'Paris', '0197643231', '', ''),
(152, 'Vitello', 'Vincent', '0', '1982-12-02', NULL, 75012, 'Paris', '0189452365', '', ''),
(153, 'Cima', 'Céline', '1', NULL, NULL, 75013, 'Paris', '0131649782', '', ''),
(154, 'Polpette', 'Pauline', '1', NULL, NULL, 75014, 'Paris', '0148592615', '', ''),
(155, 'Manzo', 'Marceline', '1', NULL, NULL, 75015, 'Paris', '0136353433', '', ''),
(156, 'Abbacchio', 'Alberte', '1', NULL, NULL, 75016, 'Paris', '0102030405', '', ''),
(157, 'Vaccinara', 'Valentine', '1', NULL, NULL, 75017, 'Paris', '0134373895', '', ''),
(158, 'RakotomalalaALALALLA', 'Cédric', '1', '2022-12-30', '2 rue de villa', 18, 'Paris', '06281', 'Ced', 'Rak'),
(159, 'Test1', 'Test2', '1', '2022-12-18', '2 rue de villa', 75014, 'Paris', '06254881', 'test', 'test'),
(160, 'CedricTest', 'RakotoTest', '0', '2022-12-24', '2 rue de villa', 75015, 'Paris', '0628471', 'Ce', 'Ra'),
(161, 'test3', 'test3', '1', '2022-12-15', '2 rue de Villa', 78511, 'Paris', '06284517', 'test3', 'test3'),
(162, 'RAKOTO', 'CED', '0', '2023-03-10', '3 rue de la Sorbonne', 75001, 'Paris', '064859232', 'test1', 'EAZ');

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

--
-- Structure de la table `lecon`
--

DROP TABLE IF EXISTS `lecon`;
CREATE TABLE IF NOT EXISTS `lecon` (
  `CodeLecon` int NOT NULL AUTO_INCREMENT,
  `Date` date DEFAULT NULL,
  `Heure` varchar(50) DEFAULT NULL,
  `CodeMoniteur` int DEFAULT NULL,
  `CodeEleve` int DEFAULT NULL,
  `Immatriculation` varchar(50) DEFAULT NULL,
  `Reglee` int NOT NULL,
  PRIMARY KEY (`CodeLecon`),
  KEY `CodeMoniteur` (`CodeMoniteur`),
  KEY `CodeEleve` (`CodeEleve`),
  KEY `Immatriculation` (`Immatriculation`)
) ENGINE=InnoDB AUTO_INCREMENT=157 DEFAULT CHARSET=latin1;

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

INSERT INTO `lecon` (`CodeLecon`, `Date`, `Heure`, `CodeMoniteur`, `CodeEleve`, `Immatriculation`, `Reglee`) VALUES
(8, '2019-08-23', '10:00:00', 11, 22, '123 AB 21', 1),
(9, '2019-07-23', '10:00:00', 11, 63, '234 BC 21', 1),
(10, '2015-12-24', '10:00:00', 11, 63, '234 BC 21', 1),
(11, '2019-06-07', '10:00:00', 11, 63, '234 BC 21', 1),
(16, '2019-09-05', '10:00:00', 14, 113, '789 GH 21', 1),
(17, '2019-04-03', '10:00:00', 14, 113, '789 GH 21', 1),
(18, '2019-03-31', '10:00:00', 14, 113, '789 GH 21', 1),
(19, '2019-07-16', '10:00:00', 14, 113, '789 GH 21', 1),
(20, '2019-07-12', '10:00:00', 14, 113, '789 GH 21', 1),
(21, '2019-08-28', '10:00:00', 8, 113, '234 BC 21', 1),
(22, '2015-12-29', '10:00:00', 8, 8, '234 BC 21', 1),
(23, '2019-01-02', '10:00:00', 8, 16, '234 BC 21', 1),
(24, '2019-09-22', '10:00:00', 11, 22, '456 DE 21', 1),
(25, '2019-01-30', '10:00:00', 14, 23, '345 CD 21', 1),
(26, '2019-04-09', '10:00:00', 8, 18, '234 BC 21', 1),
(27, '2019-08-01', '10:00:00', 11, 8, '234 BC 21', 1),
(28, '2019-02-14', '10:00:00', 14, 16, '234 BC 21', 1),
(29, '2019-01-16', '10:00:00', 11, 23, '234 BC 21', 1),
(30, '2019-01-12', '10:00:00', 8, 53, '234 BC 21', 1),
(31, '2019-08-09', '10:00:00', 11, 22, '234 BC 21', 1),
(32, '2019-04-02', '10:00:00', 8, 8, '234 BC 21', 1),
(33, '2019-08-25', '10:00:00', 8, 8, '234 BC 21', 1),
(34, '2019-02-06', '10:00:00', 8, 8, '234 BC 21', 1),
(35, '2019-03-29', '10:00:00', 8, 8, '234 BC 21', 0),
(36, '2015-12-25', '10:00:00', 8, 8, '234 BC 21', 1),
(37, '2019-02-06', '10:00:00', 8, 8, '234 BC 21', 1),
(38, '2019-08-16', '10:00:00', 11, 8, '234 BC 21', 1),
(39, '2019-05-20', '10:00:00', 14, 16, '345 CD 21', 1),
(40, '2019-08-08', '10:00:00', 14, 53, '456 DE 21', 1),
(41, '2019-07-06', '10:00:00', 14, 18, '456 DE 21', 1),
(42, '2019-02-01', '10:00:00', 11, 148, '567 EF 21', 1),
(43, '2015-12-09', '10:00:00', 11, 57, '234 BC 21', 1),
(44, '2019-07-13', '10:00:00', 14, 71, '456 DE 21', 1),
(45, '2019-04-30', '10:00:00', 14, 71, '456 DE 21', 1),
(46, '2015-12-22', '10:00:00', 14, 71, '456 DE 21', 1),
(47, '2019-08-23', '10:00:00', 14, 71, '456 DE 21', 1),
(48, '2019-06-05', '10:00:00', 14, 71, '456 DE 21', 1),
(49, '2019-05-02', '10:00:00', 8, 116, '234 BC 21', 1),
(50, '2019-08-27', '10:00:00', 8, 96, '234 BC 21', 1),
(51, '2019-01-21', '10:00:00', 14, 41, '345 CD 21', 1),
(52, '2019-01-09', '10:00:00', 11, 115, '345 CD 21', 1),
(53, '2019-04-20', '10:00:00', 14, 128, '789 GH 21', 1),
(54, '2019-01-24', '10:00:00', 14, 128, '789 GH 21', 1),
(56, '2019-06-10', '10:00:00', 11, 148, '567 EF 21', 1),
(57, '2019-07-11', '10:00:00', 11, 148, '567 EF 21', 1),
(58, '2019-09-08', '10:00:00', 8, 85, '890 HJ 21', 1),
(59, '2019-08-07', '10:00:00', 8, 145, '890 HJ 21', 1),
(60, '2019-02-09', '10:00:00', 11, 8, '456 DE 21', 1),
(61, '2019-06-07', '10:00:00', 11, 8, '234 BC 21', 1),
(62, '2019-01-14', '10:00:00', 11, 157, '678 FG 21', 1),
(63, '2019-08-10', '10:00:00', 11, 157, '678 FG 21', 1),
(64, '2019-07-29', '10:00:00', 11, 157, '678 FG 21', 1),
(65, '2019-06-24', '10:00:00', 11, 157, '678 FG 21', 1),
(66, '2019-04-12', '10:00:00', 14, 157, '678 FG 21', 1),
(67, '2019-08-10', '10:00:00', 11, 132, '123 AB 21', 1),
(68, '2019-03-25', '10:00:00', 14, 8, '234 BC 21', 1),
(69, '2019-07-14', '10:00:00', 15, 16, '345 CD 21', 1),
(73, '2019-03-27', '10:00:00', 15, 8, '123 AB 21', 1),
(74, '2019-02-19', '10:00:00', 15, 8, '123 AB 21', 1),
(75, '2019-07-29', '10:00:00', 11, 8, '123 AB 21', 1),
(76, '2019-02-01', '10:00:00', 14, 16, '234 BC 21', 1),
(77, '2019-03-10', '10:00:00', 15, 18, '345 CD 21', 1),
(79, '2019-01-19', '10:00:00', 14, 8, '234 BC 21', 1),
(80, '2019-07-04', '10:00:00', 15, 16, '345 CD 21', 1),
(81, '2019-04-03', '10:00:00', 11, 8, '123 AB 21', 1),
(85, '2019-01-11', '10:00:00', 14, 16, '234 BC 21', 1),
(86, '2019-04-29', '10:00:00', 15, 18, '345 CD 21', 1),
(87, '2019-07-06', '10:00:00', 11, 8, '123 AB 21', 1),
(88, '2019-06-16', '10:00:00', 14, 16, '234 BC 21', 0),
(89, '2019-02-02', '10:00:00', 15, 18, '345 CD 21', 1),
(90, '2019-08-23', '10:00:00', 15, 18, '789 GH 21', 0),
(91, '2019-08-22', '10:00:00', 14, 18, '567 EF 21', 0),
(92, '2022-09-02', '13:56:00', 11, 63, '456 DE 21', 0),
(93, '2022-09-02', '13:58:00', 11, 129, '345 CD 21', 0),
(94, '2022-09-02', '14:00:00', 11, 64, '345 CD 21', 0),
(95, '2022-09-02', '14:09:00', 14, 64, '678 FG 21', 0),
(96, '2022-09-02', '15:00:00', 11, 70, '678 FG 21', 0),
(97, '2022-09-02', '14:13:00', 14, 84, '234 BC 21', 0),
(98, '2022-11-17', '09:15:00', 15, 156, '890 HJ 21', 0),
(99, '2022-08-23', '10:00:00', 8, 23, '567 EF 21', 0),
(100, '2022-09-02', '14:19:00', 11, 16, '567 EF 21', 1),
(101, '2022-09-02', '14:20:00', 14, 123, '345 CD 21', 0),
(102, '2022-09-02', '14:23:00', 14, 8, '456 DE 21', 0),
(103, '2022-09-02', '14:26:00', 11, 141, '456 DE 21', 0),
(104, '2022-09-02', '14:28:00', 8, 16, '345 CD 21', 0),
(105, '2022-09-02', '14:29:00', 11, 16, '456 DE 21', 0),
(106, '2022-09-02', '14:30:00', 14, 77, '345 CD 21', 0),
(107, '2022-09-02', '14:36:00', 14, 16, '234 BC 21', 0),
(108, '2022-09-02', '14:40:00', 14, 16, '234 BC 21', 0),
(109, '2022-09-05', '14:43:00', 11, 8, '456 DE 21', 0),
(110, '2022-09-02', '08:46:00', 11, 8, '345 CD 21', 0),
(111, '2022-09-05', '11:47:00', 8, 16, '345 CD 21', 0),
(112, '2022-09-02', '15:03:00', 11, 8, '456 DE 21', 0),
(113, '2022-09-29', '18:07:00', 11, 16, '234 BC 21', 0),
(114, '2022-11-14', '02:10:00', 11, 128, '789 GH 21', 0),
(115, '2022-09-02', '18:16:00', 11, 8, '345 CD 21', 0),
(116, '2022-09-02', '13:17:00', 11, 8, '345 CD 21', 0),
(117, '2022-11-02', '13:26:00', 11, 131, '345 CD 21', 0),
(118, '2015-11-11', '02:09:00', 15, 57, '789 GH 21', 0),
(119, '2022-09-09', '18:28:00', 11, 53, '456 DE 21', 0),
(120, '2022-09-22', '08:00:00', 8, 23, '567 EF 21', 0),
(121, '2022-09-22', '16:48:00', 11, 16, '345 CD 21', 0),
(122, '2022-09-22', '02:00:00', 11, 53, '567 EF 21', 0),
(123, '2022-09-27', '08:00:00', 14, 64, '678 FG 21', 0),
(124, '2021-08-17', '09:02:00', 11, 102, '456 DE 21', 0),
(125, '2022-06-24', '11:00:00', 14, 64, '789 GH 21', 0),
(126, '2022-12-16', '14:00:00', 14, 16, '345 CD 21', 0),
(127, '2022-12-16', '14:00:00', 15, 8, '678 FG 21', 0),
(128, '2022-12-16', '15:00:00', 14, 126, '567 EF 21', 0),
(131, '2022-12-22', '2', 11, 158, '123 AB 21', 0),
(133, '2022-12-22', '2', 8, 158, '123 AB 21', 0),
(134, '2022-12-22', '2', 11, 158, '123 AB 21', 1),
(135, '2022-12-23', '2', 11, 158, '123 AB 21', 0),
(138, '2022-12-30', '3', 8, 158, '123 AB 21', 1),
(139, '2022-12-15', '3', 8, 158, '123 AB 21', 0),
(140, '2022-12-29', '3', 8, 158, '123 AB 21', 0),
(141, '2022-12-08', '2', 8, 158, '890 HJ 21', 0),
(142, '2022-12-24', '2', 14, 159, '123 AB 21', 0),
(143, '2022-12-31', '3', 14, 159, '123 AB 21', 1),
(144, '2022-12-30', '2', 14, 18, '123 AB 21', 0),
(145, '2022-12-01', '2', 14, 158, '123 AB 21', 1),
(146, '2022-12-10', '2', 14, 158, '123 AB 21', 1),
(147, '2022-12-30', '2', 11, 161, '678 FG 21', 1),
(148, '2023-07-03', '2', 14, 18, '123 AB 21', 1),
(149, '2023-03-18', '3', 8, 8, '890 HJ 21', 1),
(150, '2023-03-18', '08:30:00', 8, 8, '890 HJ 21', 0),
(155, '2023-03-18', '08:30:00', 8, 8, '567 EF 21', 0),
(156, '2023-03-22', '10:45:00', 11, 8, '123 AB 21', 0);

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

--
-- Structure de la table `licence`
--

DROP TABLE IF EXISTS `licence`;
CREATE TABLE IF NOT EXISTS `licence` (
  `CodeLicence` int NOT NULL,
  `CodeMoniteur` int DEFAULT NULL,
  `CodeCategorie` int DEFAULT NULL,
  `DateObtention` date DEFAULT NULL,
  PRIMARY KEY (`CodeLicence`),
  KEY `CodeMoniteur` (`CodeMoniteur`,`CodeCategorie`),
  KEY `CodeCategorie` (`CodeCategorie`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `licence` (`CodeLicence`, `CodeMoniteur`, `CodeCategorie`, `DateObtention`) VALUES
(1, 11, 1, NULL),
(2, 11, 4, NULL),
(3, 11, 5, NULL),
(4, 8, 3, NULL),
(5, 14, 1, NULL),
(6, 14, 2, NULL),
(7, 14, 5, NULL),
(8, 15, 1, NULL),
(9, 15, 3, NULL),
(10, 11, 2, NULL),
(11, 8, 4, '2022-12-16'),
(12, 11, 3, '2022-12-24'),
(13, 8, 1, '2023-03-18');

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

--
-- Structure de la table `moniteur`
--

DROP TABLE IF EXISTS `moniteur`;
CREATE TABLE IF NOT EXISTS `moniteur` (
  `CodeMoniteur` int NOT NULL,
  `Nom` varchar(64) DEFAULT NULL,
  `Prenom` varchar(64) DEFAULT NULL,
  `Sexe` varchar(5) DEFAULT NULL,
  `DateDeNaissance` date DEFAULT NULL,
  `Adresse` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `CodePostal` varchar(5) DEFAULT NULL,
  `Ville` varchar(32) DEFAULT NULL,
  `Telephone` varchar(12) DEFAULT NULL,
  `Login` varchar(32) NOT NULL,
  `Password` varchar(256) NOT NULL,
  PRIMARY KEY (`CodeMoniteur`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `moniteur` (`CodeMoniteur`, `Nom`, `Prenom`, `Sexe`, `DateDeNaissance`, `Adresse`, `CodePostal`, `Ville`, `Telephone`, `Login`, `Password`) VALUES
(8, 'BéalTestModif', 'Géraldine', '1', '1972-01-23', '12, avenue du Collège', '75004', 'Paris', '0180123456', 'gbeal', 'gbeal'),
(11, 'Ambrosi', 'Pierre', '2', '1969-01-04', '23, rue du Lycée', '75019', 'Paris', '0180234567', 'pambrosi', 'pambrosi'),
(14, 'Catard', 'Olivier', '2', '1963-09-12', '34, boulevard de l\'Université', '75005', 'Paris', '0180345677', 'ocatard', 'ocatard'),
(15, 'Ezard', 'Régine', '1', '1978-04-06', '45, rue des Écoles', '75020', 'Paris', '0180456789', 'rezard', 'rezard');

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

--
-- Structure de la table `vehicule`
--

DROP TABLE IF EXISTS `vehicule`;
CREATE TABLE IF NOT EXISTS `vehicule` (
  `Immatriculation` varchar(50) NOT NULL,
  `Marque` varchar(50) DEFAULT NULL,
  `Modele` varchar(50) DEFAULT NULL,
  `Annee` int DEFAULT NULL,
  `CodeCategorie` int DEFAULT NULL,
  PRIMARY KEY (`Immatriculation`),
  KEY `CodeCategorie` (`CodeCategorie`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `vehicule` (`Immatriculation`, `Marque`, `Modele`, `Annee`, `CodeCategorie`) VALUES
('123 AB 21', 'Mercedes', 'Spania', 2000, 1),
('234 BC 21', 'Peugeot', 'Sisancys', 1996, 1),
('345 CD 21', 'Renault', 'Morgane', 1995, 1),
('456 DE 21', 'Peugeot', 'Catsansys', 1999, 1),
('567 EF 21', 'Kawasaki', 'Zephyr', 1997, 4),
('678 FG 21', 'Renault', 'Betton', 1999, 5),
('789 GH 21', 'Iveco', 'Roader', 1998, 2),
('890 HJ 21', 'Oceansea', 'Tempest', 2005, 3);

--
-- Contraintes pour les tables déchargées
--

--
-- Contraintes pour la table `lecon`
--
ALTER TABLE `lecon`
  ADD CONSTRAINT `lecon_ibfk_1` FOREIGN KEY (`CodeMoniteur`) REFERENCES `moniteur` (`CodeMoniteur`),
  ADD CONSTRAINT `lecon_ibfk_2` FOREIGN KEY (`CodeEleve`) REFERENCES `eleve` (`CodeEleve`),
  ADD CONSTRAINT `lecon_ibfk_3` FOREIGN KEY (`Immatriculation`) REFERENCES `vehicule` (`Immatriculation`);

--
-- Contraintes pour la table `licence`
--
ALTER TABLE `licence`
  ADD CONSTRAINT `licence_ibfk_1` FOREIGN KEY (`CodeMoniteur`) REFERENCES `moniteur` (`CodeMoniteur`),
  ADD CONSTRAINT `licence_ibfk_2` FOREIGN KEY (`CodeCategorie`) REFERENCES `categorie` (`CodeCategorie`);

--
-- Contraintes pour la table `vehicule`
--
ALTER TABLE `vehicule`
  ADD CONSTRAINT `vehicule_ibfk_1` FOREIGN KEY (`CodeCategorie`) REFERENCES `categorie` (`CodeCategorie`);
COMMIT;

/*!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 */;