Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 4.6.4
- -- https://www.phpmyadmin.net/
- --
- -- Host: 127.0.0.1
- -- Generation Time: Apr 03, 2017 at 10:22 AM
- -- Server version: 5.7.14
- -- PHP Version: 5.6.25
- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
- 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 */;
- --
- -- Database: `etudiant`
- --
- CREATE DATABASE IF NOT EXISTS `etudiant` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
- USE `etudiant`;
- --
- -- Database: `lycee`
- --
- CREATE DATABASE IF NOT EXISTS `lycee` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
- USE `lycee`;
- -- --------------------------------------------------------
- --
- -- Table structure for table `bulletin`
- --
- CREATE TABLE `bulletin` (
- `id` int(11) NOT NULL,
- `numsem` int(11) NOT NULL,
- `numel` int(11) NOT NULL,
- `codemat` int(11) NOT NULL,
- `notefinal` float NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `bulletin`
- --
- INSERT INTO `bulletin` (`id`, `numsem`, `numel`, `codemat`, `notefinal`) VALUES
- (1, 1, 8, 17, 15.12),
- (5, 3, 3, 10, 14.25),
- (3, 4, 3, 5, 14.785),
- (6, 3, 4, 10, 14.5);
- -- --------------------------------------------------------
- --
- -- Table structure for table `classe`
- --
- CREATE TABLE `classe` (
- `codecl` int(11) NOT NULL,
- `nom` text NOT NULL,
- `numprofcoord` int(11) NOT NULL,
- `promotion` int(11) NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `classe`
- --
- INSERT INTO `classe` (`codecl`, `nom`, `numprofcoord`, `promotion`) VALUES
- (1, 'GI', 2, 2008),
- (2, 'TM', 1, 2008),
- (3, 'GRH', 3, 2008),
- (4, 'GI', 1, 2009),
- (5, 'TM', 2, 2009),
- (6, 'GRH', 4, 2009);
- -- --------------------------------------------------------
- --
- -- Table structure for table `conseil`
- --
- CREATE TABLE `conseil` (
- `id` int(11) NOT NULL,
- `numsem` int(11) NOT NULL,
- `codecl` int(11) NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `conseil`
- --
- INSERT INTO `conseil` (`id`, `numsem`, `codecl`) VALUES
- (1, 1, 4),
- (6, 3, 1),
- (4, 2, 5);
- -- --------------------------------------------------------
- --
- -- Table structure for table `devoir`
- --
- CREATE TABLE `devoir` (
- `numdev` int(11) NOT NULL,
- `date_dev` text NOT NULL,
- `coeficient` int(11) NOT NULL,
- `codemat` int(11) NOT NULL,
- `codecl` int(11) NOT NULL,
- `numsem` int(11) NOT NULL,
- `n_devoir` int(1) NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `devoir`
- --
- INSERT INTO `devoir` (`numdev`, `date_dev`, `coeficient`, `codemat`, `codecl`, `numsem`, `n_devoir`) VALUES
- (1, '12/01/2010', 4, 3, 2, 3, 1),
- (2, '01/03/2010', 3, 1, 4, 2, 1),
- (3, '02/05/2010', 4, 10, 1, 3, 1),
- (4, '20/01/2010', 5, 3, 3, 3, 1),
- (5, '02/04/2011', 3, 5, 1, 4, 1),
- (6, '04/03/2010', 4, 4, 5, 2, 1),
- (7, '10/02/2010', 3, 1, 4, 2, 2),
- (8, '10/10/2010', 3, 3, 2, 4, 1),
- (9, '23/32/2010', 4, 10, 1, 3, 2),
- (11, '10/10/2010', 3, 5, 1, 4, 2),
- (14, '10/02/2010', 5, 8, 4, 2, 1),
- (19, '12/02/2010', 4, 4, 5, 2, 2);
- -- --------------------------------------------------------
- --
- -- Table structure for table `diplome`
- --
- CREATE TABLE `diplome` (
- `numdip` int(11) NOT NULL,
- `titre_dip` text NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `diplome`
- --
- INSERT INTO `diplome` (`numdip`, `titre_dip`) VALUES
- (1, 'DUT_GI'),
- (2, 'DUT_TM'),
- (6, 'DUT_GRH');
- -- --------------------------------------------------------
- --
- -- Table structure for table `eleve`
- --
- CREATE TABLE `eleve` (
- `numel` int(11) NOT NULL,
- `nomel` text NOT NULL,
- `prenomel` text NOT NULL,
- `date_naissance` text NOT NULL,
- `adresse` text NOT NULL,
- `telephone` text NOT NULL,
- `codecl` int(11) NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `eleve`
- --
- INSERT INTO `eleve` (`numel`, `nomel`, `prenomel`, `date_naissance`, `adresse`, `telephone`, `codecl`) VALUES
- (3, 'LAGMAR', 'Ayoub', '02/19/1999', 'Casablanca', '029329452', 1),
- (4, 'Nohad', 'Imad', '21/01/1990', 'Casablanca', '029329452', 1),
- (5, 'OUBARKA', 'Samir', '19/11/1990', 'barnoussin<br />\r\nCasablanca', '029329452', 2),
- (6, 'Kadir', 'Younes', '19/19/1999', 'Ouazzan', '029329452', 3),
- (7, 'Zemzami', 'Mehdi', '20/07/1991', 'maarif<br />\r\nCasablanca', '029355552', 5),
- (8, 'Achraf', 'Achraf', '19/19/1989', 'Casablanca', '029329452', 4),
- (9, 'Fadil', 'Hamada', '19/00/1999', 'Casablanca', '029329452', 6),
- (10, 'Chaimaa', 'Chaimma', '19/19/1989', 'Casablanca', '029329452', 3),
- (11, 'Alamai', 'Karim', '19/19/1988', 'Settat', '029329452', 6),
- (13, 'Alami', 'Meriem', '21/03/1990', 'Berrechid', '097217342', 5),
- (14, 'Alami', 'Meriem', '21/03/1990', 'Berrechid', '097217342', 5);
- -- --------------------------------------------------------
- --
- -- Table structure for table `eleve_diplome`
- --
- CREATE TABLE `eleve_diplome` (
- `id` int(11) NOT NULL,
- `numdip` int(11) NOT NULL,
- `numel` int(11) NOT NULL,
- `note` float NOT NULL,
- `commentaire` text NOT NULL,
- `etablissement` text NOT NULL,
- `lieu` text NOT NULL,
- `annee_obtention` int(11) NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `eleve_diplome`
- --
- INSERT INTO `eleve_diplome` (`id`, `numdip`, `numel`, `note`, `commentaire`, `etablissement`, `lieu`, `annee_obtention`) VALUES
- (1, 1, 3, 14.54, 'Bien', 'ESTB', 'ESTB', 2010),
- (2, 2, 5, 13, 'Assez bien', 'ESTB', 'ESTB', 2010),
- (3, 3, 5, 12, 'SZDQS', 'SDFS', 'SD', 1212);
- -- --------------------------------------------------------
- --
- -- Table structure for table `enseignement`
- --
- CREATE TABLE `enseignement` (
- `id` int(11) NOT NULL,
- `codecl` int(11) NOT NULL,
- `codemat` int(11) NOT NULL,
- `numprof` int(11) NOT NULL,
- `numsem` int(11) NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `enseignement`
- --
- INSERT INTO `enseignement` (`id`, `codecl`, `codemat`, `numprof`, `numsem`) VALUES
- (1, 1, 5, 3, 4),
- (2, 2, 9, 6, 4),
- (3, 5, 4, 6, 2),
- (4, 2, 3, 6, 3),
- (5, 1, 10, 4, 3),
- (6, 4, 1, 2, 2),
- (7, 3, 3, 6, 3),
- (8, 6, 11, 6, 2),
- (9, 1, 12, 1, 4),
- (10, 4, 8, 5, 2),
- (13, 3, 7, 6, 3),
- (14, 1, 18, 4, 3),
- (15, 5, 5, 5, 1),
- (16, 5, 17, 5, 1),
- (17, 4, 2, 3, 1);
- -- --------------------------------------------------------
- --
- -- Table structure for table `evaluation`
- --
- CREATE TABLE `evaluation` (
- `numeval` int(11) NOT NULL,
- `numdev` int(11) NOT NULL,
- `numel` int(11) NOT NULL,
- `note` float NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `evaluation`
- --
- INSERT INTO `evaluation` (`numeval`, `numdev`, `numel`, `note`) VALUES
- (1, 1, 5, 12.18),
- (2, 5, 4, 14),
- (3, 6, 7, 15.25),
- (4, 7, 8, 17),
- (5, 5, 3, 13.57),
- (6, 3, 3, 15),
- (7, 4, 10, 18),
- (8, 14, 8, 15),
- (9, 2, 8, 13.75),
- (11, 3, 4, 14.75),
- (17, 19, 7, 16.25),
- (13, 11, 3, 16),
- (14, 1, 4, 13),
- (15, 9, 3, 13.5),
- (16, 9, 4, 14.25);
- -- --------------------------------------------------------
- --
- -- Table structure for table `login`
- --
- CREATE TABLE `login` (
- `id` int(11) NOT NULL,
- `Num` int(11) NOT NULL,
- `pseudo` text NOT NULL,
- `passe` text NOT NULL,
- `type` text NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `login`
- --
- INSERT INTO `login` (`id`, `Num`, `pseudo`, `passe`, `type`) VALUES
- (1, 1, 'SNOUNI', 'leila', 'prof'),
- (3, 100, 'admin', 'admin', 'admin'),
- (4, 3, 'LAGMAR', 'Ayoub', 'etudiant');
- -- --------------------------------------------------------
- --
- -- Table structure for table `matiere`
- --
- CREATE TABLE `matiere` (
- `codemat` int(11) NOT NULL,
- `nommat` text NOT NULL,
- `codecl` int(11) NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `matiere`
- --
- INSERT INTO `matiere` (`codemat`, `nommat`, `codecl`) VALUES
- (1, 'mathematique', 4),
- (2, 'Algorithme', 4),
- (3, 'Comptabilite', 2),
- (4, 'Marketing', 5),
- (5, 'Programmation', 1),
- (6, 'psychiatrie', 6),
- (7, 'Gestion des ressource', 3),
- (8, 'Communication_gi', 4),
- (9, 'Qualité', 2),
- (10, 'Reseau', 1),
- (11, 'Gestion de projet', 6),
- (12, 'Multimedia', 1),
- (14, 'Anglais', 5),
- (16, 'Droit social', 6),
- (17, 'Economie generale', 5);
- -- --------------------------------------------------------
- --
- -- Table structure for table `prof`
- --
- CREATE TABLE `prof` (
- `numprof` int(11) NOT NULL,
- `nom` text NOT NULL,
- `prenom` text NOT NULL,
- `adresse` text NOT NULL,
- `telephone` text NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `prof`
- --
- INSERT INTO `prof` (`numprof`, `nom`, `prenom`, `adresse`, `telephone`) VALUES
- (1, 'SNOUNI', 'Leila', 'Salé', '023294532'),
- (2, 'NAFIDI', 'Ahmed', 'casablanca', '0293287425'),
- (3, 'Naimi', 'Mohamad', 'Rabat', '34328724'),
- (4, 'Nasserdin', 'Bouchaib', 'SETTAT', '02932842342'),
- (5, 'Laghrissi', 'Nadia', 'Settat', '0293248235'),
- (6, 'CHROKI', 'RAZAN', 'SETTAT', '029328472'),
- (8, 'LAKIR', 'Mohamed', 'Casablanca\'', '0900223');
- -- --------------------------------------------------------
- --
- -- Table structure for table `semestre`
- --
- CREATE TABLE `semestre` (
- `numsem` int(11) NOT NULL,
- `date_debut` text NOT NULL,
- `date_fin` text NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `semestre`
- --
- INSERT INTO `semestre` (`numsem`, `date_debut`, `date_fin`) VALUES
- (1, '10/11/2010', '01/04/2011'),
- (2, '10/04/2010', '10/08/2010'),
- (3, '02/03/2010', '02/06/2010'),
- (4, '20/06/2010', '20/09/2010');
- -- --------------------------------------------------------
- --
- -- Table structure for table `stage`
- --
- CREATE TABLE `stage` (
- `numstage` int(11) NOT NULL,
- `lieu_stage` text NOT NULL,
- `date_debut` text NOT NULL,
- `date_fin` text NOT NULL,
- `numel` int(11) NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `stage`
- --
- INSERT INTO `stage` (`numstage`, `lieu_stage`, `date_debut`, `date_fin`, `numel`) VALUES
- (1, 'dell', '04/03/2010', '11/03/2010', 3),
- (2, 'COREMI', '01/07/2009', '01/08/2009', 5),
- (3, 'OCP', '01/07/2009', '01/08/2009', 4),
- (8, 'Microsoft', '01/07/2010', '01/08/2010', 8);
- --
- -- Indexes for dumped tables
- --
- --
- -- Indexes for table `bulletin`
- --
- ALTER TABLE `bulletin`
- ADD PRIMARY KEY (`id`);
- --
- -- Indexes for table `classe`
- --
- ALTER TABLE `classe`
- ADD PRIMARY KEY (`codecl`);
- --
- -- Indexes for table `conseil`
- --
- ALTER TABLE `conseil`
- ADD PRIMARY KEY (`id`);
- --
- -- Indexes for table `devoir`
- --
- ALTER TABLE `devoir`
- ADD PRIMARY KEY (`numdev`);
- --
- -- Indexes for table `diplome`
- --
- ALTER TABLE `diplome`
- ADD PRIMARY KEY (`numdip`);
- --
- -- Indexes for table `eleve`
- --
- ALTER TABLE `eleve`
- ADD PRIMARY KEY (`numel`),
- ADD KEY `codecl2` (`codecl`);
- --
- -- Indexes for table `eleve_diplome`
- --
- ALTER TABLE `eleve_diplome`
- ADD PRIMARY KEY (`id`);
- --
- -- Indexes for table `enseignement`
- --
- ALTER TABLE `enseignement`
- ADD PRIMARY KEY (`id`);
- --
- -- Indexes for table `evaluation`
- --
- ALTER TABLE `evaluation`
- ADD PRIMARY KEY (`numeval`);
- --
- -- Indexes for table `login`
- --
- ALTER TABLE `login`
- ADD PRIMARY KEY (`id`);
- --
- -- Indexes for table `matiere`
- --
- ALTER TABLE `matiere`
- ADD PRIMARY KEY (`codemat`);
- --
- -- Indexes for table `prof`
- --
- ALTER TABLE `prof`
- ADD PRIMARY KEY (`numprof`);
- --
- -- Indexes for table `semestre`
- --
- ALTER TABLE `semestre`
- ADD PRIMARY KEY (`numsem`);
- --
- -- Indexes for table `stage`
- --
- ALTER TABLE `stage`
- ADD PRIMARY KEY (`numstage`),
- ADD KEY `numel1` (`numel`);
- --
- -- AUTO_INCREMENT for dumped tables
- --
- --
- -- AUTO_INCREMENT for table `bulletin`
- --
- ALTER TABLE `bulletin`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
- --
- -- AUTO_INCREMENT for table `classe`
- --
- ALTER TABLE `classe`
- MODIFY `codecl` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
- --
- -- AUTO_INCREMENT for table `conseil`
- --
- ALTER TABLE `conseil`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
- --
- -- AUTO_INCREMENT for table `devoir`
- --
- ALTER TABLE `devoir`
- MODIFY `numdev` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;
- --
- -- AUTO_INCREMENT for table `diplome`
- --
- ALTER TABLE `diplome`
- MODIFY `numdip` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
- --
- -- AUTO_INCREMENT for table `eleve`
- --
- ALTER TABLE `eleve`
- MODIFY `numel` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
- --
- -- AUTO_INCREMENT for table `eleve_diplome`
- --
- ALTER TABLE `eleve_diplome`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
- --
- -- AUTO_INCREMENT for table `enseignement`
- --
- ALTER TABLE `enseignement`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
- --
- -- AUTO_INCREMENT for table `evaluation`
- --
- ALTER TABLE `evaluation`
- MODIFY `numeval` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
- --
- -- AUTO_INCREMENT for table `login`
- --
- ALTER TABLE `login`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
- --
- -- AUTO_INCREMENT for table `matiere`
- --
- ALTER TABLE `matiere`
- MODIFY `codemat` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;
- --
- -- AUTO_INCREMENT for table `prof`
- --
- ALTER TABLE `prof`
- MODIFY `numprof` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
- --
- -- AUTO_INCREMENT for table `semestre`
- --
- ALTER TABLE `semestre`
- MODIFY `numsem` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
- --
- -- AUTO_INCREMENT for table `stage`
- --
- ALTER TABLE `stage`
- MODIFY `numstage` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;--
- -- Database: `pfe2017`
- --
- CREATE DATABASE IF NOT EXISTS `pfe2017` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
- USE `pfe2017`;
- -- --------------------------------------------------------
- --
- -- Table structure for table `etudiant`
- --
- CREATE TABLE `etudiant` (
- `nom` varchar(258) NOT NULL,
- `prenom` varchar(250) NOT NULL,
- `adresse` varchar(258) NOT NULL,
- `email` varchar(35) NOT NULL,
- `filliere` varchar(125) NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `etudiant`
- --
- INSERT INTO `etudiant` (`nom`, `prenom`, `adresse`, `email`, `filliere`) VALUES
- ('test', 'test', 'test', 'ets', 'test'),
- ('', '', '', '', ''),
- ('', '', '', '', ''),
- ('elmendili', 'yassir', 'sale', 'yassirmendili@gmail.com', 'sri'),
- ('', '', '', '', ''),
- ('', '', '', '', ''),
- ('mendili', 'yassir', 'hzev', 'izegl', 'sri'),
- ('Mendili', 'Yassir', 'Hay karima imm 59 app 08', 'yassirelmendili@yahoo.com', 'SRI'),
- ('Mendili', 'Yassir', 'Hay karima imm 59 app 08', 'yassirelmendili@yahoo.com', 'SRI'),
- ('erberne', 'ererbeb', 'etnetntnt', 'tenetnntrn', 'SRI');
- -- --------------------------------------------------------
- --
- -- Table structure for table `login`
- --
- CREATE TABLE `login` (
- `id` int(3) NOT NULL,
- `email` varchar(20) NOT NULL,
- `username` varchar(20) NOT NULL,
- `password` varchar(50) NOT NULL,
- `type` varchar(20) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `login`
- --
- INSERT INTO `login` (`id`, `email`, `username`, `password`, `type`) VALUES
- (4, '', 'test', 'test', ''),
- (5, '', 'paco', 'paco', '');
- --
- -- Indexes for dumped tables
- --
- --
- -- Indexes for table `login`
- --
- ALTER TABLE `login`
- ADD PRIMARY KEY (`id`);
- --
- -- AUTO_INCREMENT for dumped tables
- --
- --
- -- AUTO_INCREMENT for table `login`
- --
- ALTER TABLE `login`
- MODIFY `id` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;--
- -- Database: `test`
- --
- CREATE DATABASE IF NOT EXISTS `test` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
- USE `test`;
- -- --------------------------------------------------------
- --
- -- Table structure for table `ensegner`
- --
- CREATE TABLE `ensegner` (
- `ID` int(11) NOT NULL,
- `ID_Matiere` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- --------------------------------------------------------
- --
- -- Table structure for table `etudiant`
- --
- CREATE TABLE `etudiant` (
- `ID` int(11) NOT NULL,
- `Nom` char(25) DEFAULT NULL,
- `Prenom` char(25) DEFAULT NULL,
- `Sexe` char(1) DEFAULT NULL,
- `Nationalite` char(25) DEFAULT NULL,
- `Date_N` date DEFAULT NULL,
- `Lieu_N` char(25) DEFAULT NULL,
- `CIN` varchar(25) DEFAULT NULL,
- `Numero_inscription` decimal(10,0) DEFAULT NULL,
- `CNE` varchar(25) DEFAULT NULL,
- `Type_BAC` char(25) DEFAULT NULL,
- `Date_inscription_1er` date DEFAULT NULL,
- `Date_inscription_2em` date DEFAULT NULL,
- `moyenne_1er_annee` float DEFAULT NULL,
- `Institue_d_origine` varchar(25) DEFAULT NULL,
- `Tel` decimal(10,0) DEFAULT NULL,
- `Email` varchar(25) DEFAULT NULL,
- `Adresse` varchar(25) DEFAULT NULL,
- `Niveaux` varchar(25) DEFAULT NULL,
- `Filiere` varchar(25) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- --------------------------------------------------------
- --
- -- Table structure for table `etudier`
- --
- CREATE TABLE `etudier` (
- `ID` int(11) NOT NULL,
- `ID_Matiere` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- --------------------------------------------------------
- --
- -- Table structure for table `matiere`
- --
- CREATE TABLE `matiere` (
- `ID` int(11) NOT NULL,
- `Nom` char(25) DEFAULT NULL,
- `MOY_ds` float DEFAULT NULL,
- `MOY_examen` float DEFAULT NULL,
- `MOY_generale` float DEFAULT NULL,
- `Coefficient` int(11) DEFAULT NULL,
- `Prof` char(25) DEFAULT NULL,
- `Unite` char(25) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- --------------------------------------------------------
- --
- -- Table structure for table `obtenir_note`
- --
- CREATE TABLE `obtenir_note` (
- `ID` int(11) NOT NULL,
- `ID_Professeur` int(11) NOT NULL,
- `ID_Professeur_1` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- --------------------------------------------------------
- --
- -- Table structure for table `professeur`
- --
- CREATE TABLE `professeur` (
- `ID` int(11) NOT NULL,
- `Nom` char(25) DEFAULT NULL,
- `Prenom` char(25) DEFAULT NULL,
- `Matiere` char(25) DEFAULT NULL,
- `Tel` decimal(10,0) DEFAULT NULL,
- `Email` varchar(25) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Indexes for dumped tables
- --
- --
- -- Indexes for table `ensegner`
- --
- ALTER TABLE `ensegner`
- ADD PRIMARY KEY (`ID`,`ID_Matiere`),
- ADD KEY `FK_Ensegner_ID_Matiere` (`ID_Matiere`);
- --
- -- Indexes for table `etudiant`
- --
- ALTER TABLE `etudiant`
- ADD PRIMARY KEY (`ID`);
- --
- -- Indexes for table `etudier`
- --
- ALTER TABLE `etudier`
- ADD PRIMARY KEY (`ID`,`ID_Matiere`),
- ADD KEY `FK_Etudier_ID_Matiere` (`ID_Matiere`);
- --
- -- Indexes for table `matiere`
- --
- ALTER TABLE `matiere`
- ADD PRIMARY KEY (`ID`);
- --
- -- Indexes for table `obtenir_note`
- --
- ALTER TABLE `obtenir_note`
- ADD PRIMARY KEY (`ID`,`ID_Professeur`,`ID_Professeur_1`),
- ADD KEY `FK_Obtenir_note_ID_Professeur` (`ID_Professeur`),
- ADD KEY `FK_Obtenir_note_ID_Professeur_1` (`ID_Professeur_1`);
- --
- -- Indexes for table `professeur`
- --
- ALTER TABLE `professeur`
- ADD PRIMARY KEY (`ID`);
- --
- -- AUTO_INCREMENT for dumped tables
- --
- --
- -- AUTO_INCREMENT for table `etudiant`
- --
- ALTER TABLE `etudiant`
- MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `matiere`
- --
- ALTER TABLE `matiere`
- MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `professeur`
- --
- ALTER TABLE `professeur`
- MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
- --
- -- Constraints for dumped tables
- --
- --
- -- Constraints for table `ensegner`
- --
- ALTER TABLE `ensegner`
- ADD CONSTRAINT `FK_Ensegner_ID` FOREIGN KEY (`ID`) REFERENCES `professeur` (`ID`),
- ADD CONSTRAINT `FK_Ensegner_ID_Matiere` FOREIGN KEY (`ID_Matiere`) REFERENCES `matiere` (`ID`);
- --
- -- Constraints for table `etudier`
- --
- ALTER TABLE `etudier`
- ADD CONSTRAINT `FK_Etudier_ID` FOREIGN KEY (`ID`) REFERENCES `etudiant` (`ID`),
- ADD CONSTRAINT `FK_Etudier_ID_Matiere` FOREIGN KEY (`ID_Matiere`) REFERENCES `matiere` (`ID`);
- --
- -- Constraints for table `obtenir_note`
- --
- ALTER TABLE `obtenir_note`
- ADD CONSTRAINT `FK_Obtenir_note_ID` FOREIGN KEY (`ID`) REFERENCES `etudiant` (`ID`),
- ADD CONSTRAINT `FK_Obtenir_note_ID_Professeur` FOREIGN KEY (`ID_Professeur`) REFERENCES `professeur` (`ID`),
- ADD CONSTRAINT `FK_Obtenir_note_ID_Professeur_1` FOREIGN KEY (`ID_Professeur_1`) REFERENCES `professeur` (`ID`);
- /*!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 */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement