-- MySQL dump 10.13  Distrib 8.0.40, for macos11.7 (x86_64)
--
-- Host: localhost    Database: univ
-- ------------------------------------------------------
-- Server version	8.0.40

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

DROP TABLE IF EXISTS `cours`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cours` (
  `nomcours` varchar(30) NOT NULL,
  `prerequis` varchar(30) NOT NULL,
  `numsalle` tinyint DEFAULT NULL,
  PRIMARY KEY (`nomcours`),
  KEY `fk_cours_salles` (`numsalle`),
  CONSTRAINT `fk_cours_salles` FOREIGN KEY (`numsalle`) REFERENCES `salles` (`numsalle`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cours`
--

LOCK TABLES `cours` WRITE;
/*!40000 ALTER TABLE `cours` DISABLE KEYS */;
INSERT INTO `cours` VALUES ('analyse 1','aucun',1),('analyse 2','analyse 1',1),('analyse 3','analyse 2',1),('anglais','aucun',12),('atomistique','aucun',11),('cristallographie','analyse 1',8),('electricite generale','aucun',3),('electronique','electricite generale',9),('electrostatique','theorie des champs',3),('informatique','aucun',13),('magnetostatique','electrostatique',3),('mecanique generale','aucun',2),('mecanique quantique','analyse 3',2),('mecanique relativiste','mecanique generale',2),('mecanique statistique','statistiques',2),('optique geometrique','aucun',6),('optique physique','optique geometrique',7),('physique du solide','mecanique quantique',10),('propagation','magnetostatique',5),('statistiques','analyse 2',1),('theorie des champs','analyse 2',4),('thermodynamique','aucun',11);
/*!40000 ALTER TABLE `cours` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `etudiants`
--

DROP TABLE IF EXISTS `etudiants`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `etudiants` (
  `numero` char(5) NOT NULL,
  `nom` varchar(30) NOT NULL,
  `prenom` varchar(30) NOT NULL,
  `ville` varchar(30) NOT NULL,
  PRIMARY KEY (`numero`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `etudiants`
--

LOCK TABLES `etudiants` WRITE;
/*!40000 ALTER TABLE `etudiants` DISABLE KEYS */;
INSERT INTO `etudiants` VALUES ('12024','RAVEL','Maurice','SAINT ETIENNE'),('12042','MALRAUX','Andre','GRENOBLE'),('12057','FRANK','Cesar','PARIS'),('12086','BRASSENS','Georges','SETE'),('12104','BERLIOZ','Hector','LA COTE ST ANDRE'),('12115','ARAGON','Louis','PARIS'),('12124','MERIMEE','Prosper','VILLEURBANNE'),('12129','HUGO','Victor','SAINT ETIENNE'),('12149','COURBET','Gustave','LYON'),('12183','COMTE','Auguste','GRENOBLE'),('12186','ELUARD','Paul','PARIS'),('12239','BREL','Jacques','PARIS'),('12245','CAMUS','Albert','LYON'),('12284','PROUST','Marcel','LYON'),('12289','FAURE','Gabriel','VILLEURBANNE'),('12291','GALOIS','Evariste','LYON'),('12306','ZOLA','Emile','BOURG EN BRESSE'),('12309','SAND','George','VIENNE'),('12319','BASTIE','Maryse','GRENOBLE'),('12333','GREEN','Julien','PARIS'),('12335','PAPIN','Denis','PARIS'),('12342','VERLAINE','Paul','GRENOBLE'),('12351','MALLARME','Stephane','LYON'),('12362','NIEPCE','Nicephore','CHALON SUR SAONE'),('12407','LUMIERE','Auguste','LYON'),('12417','LALO','Edouard','PARIS'),('12442','LEGER','Fernand','ANNECY'),('12444','DEBUSSY','Claude','CHAMBERY'),('12473','PAGNOL','Marcel','MARSEILLE'),('12477','PASCAL','Blaise','CLERMONT FERRAND'),('12487','SARTRE','Jean Paul','PARIS'),('12541','BERNARD','Claude','LYON'),('12544','CURIE','Marie','PARIS'),('12554','YOURCENAR','Margueritte','PARIS'),('12555','BLERIOT','Louis','PARIS'),('12601','DUHAMEL','Georges','LE HAVRE'),('12609','RENOIR','Auguste','LYON'),('12639','PREVERT','Jacques','VILLEURBANNE'),('12664','GIDE','Andre','LYON'),('12713','CURIE','Irene','PARIS'),('12714','GAUGUIN','Paul','LILLE'),('12729','MANET','Edouard','PARIS'),('12741','MERMOZ','Jean','BRON'),('12810','RENOIR','Jean','VILLEURBANNE'),('12841','DUKAS','Paul','BRON'),('12849','LUMIERE','Louis','LYON'),('12904','CARTIER','Jacques','MONTREAL'),('12907','BIZET','Georges','ARLES'),('12917','DURAS','Margueritte','PARIS'),('12958','VERNE','Jules','BRON');
/*!40000 ALTER TABLE `etudiants` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `horaires`
--

DROP TABLE IF EXISTS `horaires`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `horaires` (
  `nomcours` varchar(30) NOT NULL,
  `jour` varchar(30) NOT NULL,
  `heure` int NOT NULL,
  PRIMARY KEY (`nomcours`,`jour`,`heure`),
  CONSTRAINT `fk_horaires_cours` FOREIGN KEY (`nomcours`) REFERENCES `cours` (`nomcours`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `horaires`
--

LOCK TABLES `horaires` WRITE;
/*!40000 ALTER TABLE `horaires` DISABLE KEYS */;
INSERT INTO `horaires` VALUES ('analyse 1','jeudi',10),('analyse 1','lundi',8),('analyse 1','mardi',8),('analyse 2','lundi',11),('analyse 2','mercredi',9),('analyse 3','jeudi',15),('analyse 3','vendredi',10),('anglais','lundi',16),('anglais','mardi',11),('anglais','mercredi',18),('atomistique','jeudi',16),('atomistique','mardi',10),('cristallographie','vendredi',11),('electricite generale','lundi',14),('electricite generale','mercredi',14),('electronique','jeudi',11),('electronique','mercredi',8),('electrostatique','lundi',9),('electrostatique','mercredi',15),('informatique','mardi',17),('magnetostatique','jeudi',14),('magnetostatique','lundi',18),('mecanique generale','lundi',17),('mecanique generale','mercredi',11),('mecanique quantique','jeudi',8),('mecanique quantique','mardi',11),('mecanique relativiste','jeudi',17),('mecanique relativiste','vendredi',16),('mecanique statistique','mardi',16),('mecanique statistique','vendredi',8),('optique geometrique','jeudi',9),('optique geometrique','mardi',11),('optique physique','jeudi',18),('optique physique','mardi',14),('physique du solide','mardi',18),('physique du solide','mercredi',10),('propagation','mercredi',16),('propagation','vendredi',17),('statistiques','vendredi',9),('theorie des champs','lundi',10),('theorie des champs','mercredi',17),('thermodynamique','mardi',15),('thermodynamique','vendredi',14);
/*!40000 ALTER TABLE `horaires` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `notes`
--

DROP TABLE IF EXISTS `notes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `notes` (
  `NumEtudiant` char(5) NOT NULL,
  `cours` varchar(30) NOT NULL,
  `valeur` tinyint DEFAULT NULL,
  PRIMARY KEY (`NumEtudiant`,`cours`),
  KEY `fk_notes_cours` (`cours`),
  CONSTRAINT `fk_notes_cours` FOREIGN KEY (`cours`) REFERENCES `cours` (`nomcours`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_notes_etudiant` FOREIGN KEY (`NumEtudiant`) REFERENCES `etudiants` (`numero`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `notes`
--

LOCK TABLES `notes` WRITE;
/*!40000 ALTER TABLE `notes` DISABLE KEYS */;
INSERT INTO `notes` VALUES ('12024','analyse 1',17),('12024','analyse 2',15),('12024','analyse 3',NULL),('12042','analyse 1',NULL),('12042','atomistique',18),('12042','electricite generale',NULL),('12042','mecanique generale',NULL),('12042','optique geometrique',14),('12057','electricite generale',NULL),('12086','anglais',NULL),('12086','informatique',14),('12104','analyse 1',15),('12115','analyse 1',NULL),('12124','optique geometrique',NULL),('12129','mecanique generale',NULL),('12149','analyse 1',NULL),('12149','mecanique generale',12),('12183','optique geometrique',NULL),('12186','optique geometrique',NULL),('12239','anglais',13),('12239','atomistique',NULL),('12245','analyse 1',13),('12245','analyse 2',NULL),('12245','electrostatique',NULL),('12245','theorie des champs',11),('12284','optique geometrique',NULL),('12289','analyse 1',NULL),('12291','analyse 1',15),('12291','analyse 2',16),('12291','analyse 3',NULL),('12291','statistiques',NULL),('12306','atomistique',NULL),('12309','analyse 1',10),('12309','atomistique',NULL),('12309','electricite generale',NULL),('12319','informatique',NULL),('12333','anglais',NULL),('12335','informatique',NULL),('12342','thermodynamique',NULL),('12351','anglais',15),('12362','optique geometrique',15),('12362','optique physique',NULL),('12407','electricite generale',17),('12407','electronique',NULL),('12407','optique geometrique',14),('12407','optique physique',NULL),('12407','thermodynamique',NULL),('12417','analyse 1',NULL),('12442','anglais',NULL),('12444','anglais',NULL),('12444','atomistique',NULL),('12444','informatique',15),('12444','thermodynamique',NULL),('12473','analyse 1',NULL),('12477','analyse 1',18),('12477','analyse 2',20),('12477','analyse 3',19),('12477','mecanique generale',19),('12477','mecanique quantique',NULL),('12477','mecanique relativiste',NULL),('12477','mecanique statistique',18),('12477','statistiques',17),('12487','electricite generale',NULL),('12541','analyse 1',17),('12544','analyse 1',19),('12544','analyse 2',20),('12544','anglais',NULL),('12544','mecanique statistique',NULL),('12544','statistiques',20),('12554','atomistique',NULL),('12555','analyse 1',16),('12601','analyse 1',NULL),('12609','atomistique',NULL),('12639','anglais',NULL),('12639','informatique',14),('12664','analyse 1',NULL),('12713','analyse 1',19),('12713','analyse 2',18),('12713','analyse 3',19),('12713','informatique',NULL),('12713','mecanique generale',15),('12713','mecanique quantique',20),('12713','mecanique relativiste',18),('12714','electricite generale',NULL),('12729','electricite generale',12),('12741','analyse 1',12),('12741','cristallographie',NULL),('12810','analyse 1',NULL),('12841','analyse 1',15),('12841','analyse 2',17),('12841','electrostatique',16),('12841','magnetostatique',NULL),('12841','theorie des champs',15),('12849','electricite generale',15),('12849','electronique',NULL),('12849','optique geometrique',16),('12849','optique physique',16),('12904','atomistique',NULL),('12907','analyse 1',NULL),('12917','analyse 1',NULL),('12958','analyse 1',12);
/*!40000 ALTER TABLE `notes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `salles`
--

DROP TABLE IF EXISTS `salles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `salles` (
  `numsalle` tinyint NOT NULL,
  `adresse` varchar(30) NOT NULL,
  PRIMARY KEY (`numsalle`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `salles`
--

LOCK TABLES `salles` WRITE;
/*!40000 ALTER TABLE `salles` DISABLE KEYS */;
INSERT INTO `salles` VALUES (1,'Ampere sud'),(2,'Lagrange nord'),(3,'Ampere nord'),(4,'Maxwell est'),(5,'Maxwell ouest'),(6,'Gauss sud'),(7,'Young est'),(8,'Bragg sud'),(9,'Hertz est'),(10,'Fermi sud'),(11,'Bohr ouest'),(12,'salle 207'),(13,'salle 109');
/*!40000 ALTER TABLE `salles` 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 2025-03-31 14:56:57
