· 9 years ago · Apr 03, 2017, 10:24 AM
1-- phpMyAdmin SQL Dump
2-- version 4.6.4
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1
6-- Generation Time: Apr 03, 2017 at 10:22 AM
7-- Server version: 5.7.14
8-- PHP Version: 5.6.25
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8mb4 */;
18
19--
20-- Database: `etudiant`
21--
22CREATE DATABASE IF NOT EXISTS `etudiant` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
23USE `etudiant`;
24--
25-- Database: `lycee`
26--
27CREATE DATABASE IF NOT EXISTS `lycee` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
28USE `lycee`;
29
30-- --------------------------------------------------------
31
32--
33-- Table structure for table `bulletin`
34--
35
36CREATE TABLE `bulletin` (
37 `id` int(11) NOT NULL,
38 `numsem` int(11) NOT NULL,
39 `numel` int(11) NOT NULL,
40 `codemat` int(11) NOT NULL,
41 `notefinal` float NOT NULL
42) ENGINE=MyISAM DEFAULT CHARSET=latin1;
43
44--
45-- Dumping data for table `bulletin`
46--
47
48INSERT INTO `bulletin` (`id`, `numsem`, `numel`, `codemat`, `notefinal`) VALUES
49(1, 1, 8, 17, 15.12),
50(5, 3, 3, 10, 14.25),
51(3, 4, 3, 5, 14.785),
52(6, 3, 4, 10, 14.5);
53
54-- --------------------------------------------------------
55
56--
57-- Table structure for table `classe`
58--
59
60CREATE TABLE `classe` (
61 `codecl` int(11) NOT NULL,
62 `nom` text NOT NULL,
63 `numprofcoord` int(11) NOT NULL,
64 `promotion` int(11) NOT NULL
65) ENGINE=MyISAM DEFAULT CHARSET=latin1;
66
67--
68-- Dumping data for table `classe`
69--
70
71INSERT INTO `classe` (`codecl`, `nom`, `numprofcoord`, `promotion`) VALUES
72(1, 'GI', 2, 2008),
73(2, 'TM', 1, 2008),
74(3, 'GRH', 3, 2008),
75(4, 'GI', 1, 2009),
76(5, 'TM', 2, 2009),
77(6, 'GRH', 4, 2009);
78
79-- --------------------------------------------------------
80
81--
82-- Table structure for table `conseil`
83--
84
85CREATE TABLE `conseil` (
86 `id` int(11) NOT NULL,
87 `numsem` int(11) NOT NULL,
88 `codecl` int(11) NOT NULL
89) ENGINE=MyISAM DEFAULT CHARSET=latin1;
90
91--
92-- Dumping data for table `conseil`
93--
94
95INSERT INTO `conseil` (`id`, `numsem`, `codecl`) VALUES
96(1, 1, 4),
97(6, 3, 1),
98(4, 2, 5);
99
100-- --------------------------------------------------------
101
102--
103-- Table structure for table `devoir`
104--
105
106CREATE TABLE `devoir` (
107 `numdev` int(11) NOT NULL,
108 `date_dev` text NOT NULL,
109 `coeficient` int(11) NOT NULL,
110 `codemat` int(11) NOT NULL,
111 `codecl` int(11) NOT NULL,
112 `numsem` int(11) NOT NULL,
113 `n_devoir` int(1) NOT NULL
114) ENGINE=MyISAM DEFAULT CHARSET=latin1;
115
116--
117-- Dumping data for table `devoir`
118--
119
120INSERT INTO `devoir` (`numdev`, `date_dev`, `coeficient`, `codemat`, `codecl`, `numsem`, `n_devoir`) VALUES
121(1, '12/01/2010', 4, 3, 2, 3, 1),
122(2, '01/03/2010', 3, 1, 4, 2, 1),
123(3, '02/05/2010', 4, 10, 1, 3, 1),
124(4, '20/01/2010', 5, 3, 3, 3, 1),
125(5, '02/04/2011', 3, 5, 1, 4, 1),
126(6, '04/03/2010', 4, 4, 5, 2, 1),
127(7, '10/02/2010', 3, 1, 4, 2, 2),
128(8, '10/10/2010', 3, 3, 2, 4, 1),
129(9, '23/32/2010', 4, 10, 1, 3, 2),
130(11, '10/10/2010', 3, 5, 1, 4, 2),
131(14, '10/02/2010', 5, 8, 4, 2, 1),
132(19, '12/02/2010', 4, 4, 5, 2, 2);
133
134-- --------------------------------------------------------
135
136--
137-- Table structure for table `diplome`
138--
139
140CREATE TABLE `diplome` (
141 `numdip` int(11) NOT NULL,
142 `titre_dip` text NOT NULL
143) ENGINE=MyISAM DEFAULT CHARSET=latin1;
144
145--
146-- Dumping data for table `diplome`
147--
148
149INSERT INTO `diplome` (`numdip`, `titre_dip`) VALUES
150(1, 'DUT_GI'),
151(2, 'DUT_TM'),
152(6, 'DUT_GRH');
153
154-- --------------------------------------------------------
155
156--
157-- Table structure for table `eleve`
158--
159
160CREATE TABLE `eleve` (
161 `numel` int(11) NOT NULL,
162 `nomel` text NOT NULL,
163 `prenomel` text NOT NULL,
164 `date_naissance` text NOT NULL,
165 `adresse` text NOT NULL,
166 `telephone` text NOT NULL,
167 `codecl` int(11) NOT NULL
168) ENGINE=MyISAM DEFAULT CHARSET=latin1;
169
170--
171-- Dumping data for table `eleve`
172--
173
174INSERT INTO `eleve` (`numel`, `nomel`, `prenomel`, `date_naissance`, `adresse`, `telephone`, `codecl`) VALUES
175(3, 'LAGMAR', 'Ayoub', '02/19/1999', 'Casablanca', '029329452', 1),
176(4, 'Nohad', 'Imad', '21/01/1990', 'Casablanca', '029329452', 1),
177(5, 'OUBARKA', 'Samir', '19/11/1990', 'barnoussin<br />\r\nCasablanca', '029329452', 2),
178(6, 'Kadir', 'Younes', '19/19/1999', 'Ouazzan', '029329452', 3),
179(7, 'Zemzami', 'Mehdi', '20/07/1991', 'maarif<br />\r\nCasablanca', '029355552', 5),
180(8, 'Achraf', 'Achraf', '19/19/1989', 'Casablanca', '029329452', 4),
181(9, 'Fadil', 'Hamada', '19/00/1999', 'Casablanca', '029329452', 6),
182(10, 'Chaimaa', 'Chaimma', '19/19/1989', 'Casablanca', '029329452', 3),
183(11, 'Alamai', 'Karim', '19/19/1988', 'Settat', '029329452', 6),
184(13, 'Alami', 'Meriem', '21/03/1990', 'Berrechid', '097217342', 5),
185(14, 'Alami', 'Meriem', '21/03/1990', 'Berrechid', '097217342', 5);
186
187-- --------------------------------------------------------
188
189--
190-- Table structure for table `eleve_diplome`
191--
192
193CREATE TABLE `eleve_diplome` (
194 `id` int(11) NOT NULL,
195 `numdip` int(11) NOT NULL,
196 `numel` int(11) NOT NULL,
197 `note` float NOT NULL,
198 `commentaire` text NOT NULL,
199 `etablissement` text NOT NULL,
200 `lieu` text NOT NULL,
201 `annee_obtention` int(11) NOT NULL
202) ENGINE=MyISAM DEFAULT CHARSET=latin1;
203
204--
205-- Dumping data for table `eleve_diplome`
206--
207
208INSERT INTO `eleve_diplome` (`id`, `numdip`, `numel`, `note`, `commentaire`, `etablissement`, `lieu`, `annee_obtention`) VALUES
209(1, 1, 3, 14.54, 'Bien', 'ESTB', 'ESTB', 2010),
210(2, 2, 5, 13, 'Assez bien', 'ESTB', 'ESTB', 2010),
211(3, 3, 5, 12, 'SZDQS', 'SDFS', 'SD', 1212);
212
213-- --------------------------------------------------------
214
215--
216-- Table structure for table `enseignement`
217--
218
219CREATE TABLE `enseignement` (
220 `id` int(11) NOT NULL,
221 `codecl` int(11) NOT NULL,
222 `codemat` int(11) NOT NULL,
223 `numprof` int(11) NOT NULL,
224 `numsem` int(11) NOT NULL
225) ENGINE=MyISAM DEFAULT CHARSET=latin1;
226
227--
228-- Dumping data for table `enseignement`
229--
230
231INSERT INTO `enseignement` (`id`, `codecl`, `codemat`, `numprof`, `numsem`) VALUES
232(1, 1, 5, 3, 4),
233(2, 2, 9, 6, 4),
234(3, 5, 4, 6, 2),
235(4, 2, 3, 6, 3),
236(5, 1, 10, 4, 3),
237(6, 4, 1, 2, 2),
238(7, 3, 3, 6, 3),
239(8, 6, 11, 6, 2),
240(9, 1, 12, 1, 4),
241(10, 4, 8, 5, 2),
242(13, 3, 7, 6, 3),
243(14, 1, 18, 4, 3),
244(15, 5, 5, 5, 1),
245(16, 5, 17, 5, 1),
246(17, 4, 2, 3, 1);
247
248-- --------------------------------------------------------
249
250--
251-- Table structure for table `evaluation`
252--
253
254CREATE TABLE `evaluation` (
255 `numeval` int(11) NOT NULL,
256 `numdev` int(11) NOT NULL,
257 `numel` int(11) NOT NULL,
258 `note` float NOT NULL
259) ENGINE=MyISAM DEFAULT CHARSET=latin1;
260
261--
262-- Dumping data for table `evaluation`
263--
264
265INSERT INTO `evaluation` (`numeval`, `numdev`, `numel`, `note`) VALUES
266(1, 1, 5, 12.18),
267(2, 5, 4, 14),
268(3, 6, 7, 15.25),
269(4, 7, 8, 17),
270(5, 5, 3, 13.57),
271(6, 3, 3, 15),
272(7, 4, 10, 18),
273(8, 14, 8, 15),
274(9, 2, 8, 13.75),
275(11, 3, 4, 14.75),
276(17, 19, 7, 16.25),
277(13, 11, 3, 16),
278(14, 1, 4, 13),
279(15, 9, 3, 13.5),
280(16, 9, 4, 14.25);
281
282-- --------------------------------------------------------
283
284--
285-- Table structure for table `login`
286--
287
288CREATE TABLE `login` (
289 `id` int(11) NOT NULL,
290 `Num` int(11) NOT NULL,
291 `pseudo` text NOT NULL,
292 `passe` text NOT NULL,
293 `type` text NOT NULL
294) ENGINE=MyISAM DEFAULT CHARSET=latin1;
295
296--
297-- Dumping data for table `login`
298--
299
300INSERT INTO `login` (`id`, `Num`, `pseudo`, `passe`, `type`) VALUES
301(1, 1, 'SNOUNI', 'leila', 'prof'),
302(3, 100, 'admin', 'admin', 'admin'),
303(4, 3, 'LAGMAR', 'Ayoub', 'etudiant');
304
305-- --------------------------------------------------------
306
307--
308-- Table structure for table `matiere`
309--
310
311CREATE TABLE `matiere` (
312 `codemat` int(11) NOT NULL,
313 `nommat` text NOT NULL,
314 `codecl` int(11) NOT NULL
315) ENGINE=MyISAM DEFAULT CHARSET=latin1;
316
317--
318-- Dumping data for table `matiere`
319--
320
321INSERT INTO `matiere` (`codemat`, `nommat`, `codecl`) VALUES
322(1, 'mathematique', 4),
323(2, 'Algorithme', 4),
324(3, 'Comptabilite', 2),
325(4, 'Marketing', 5),
326(5, 'Programmation', 1),
327(6, 'psychiatrie', 6),
328(7, 'Gestion des ressource', 3),
329(8, 'Communication_gi', 4),
330(9, 'Qualité', 2),
331(10, 'Reseau', 1),
332(11, 'Gestion de projet', 6),
333(12, 'Multimedia', 1),
334(14, 'Anglais', 5),
335(16, 'Droit social', 6),
336(17, 'Economie generale', 5);
337
338-- --------------------------------------------------------
339
340--
341-- Table structure for table `prof`
342--
343
344CREATE TABLE `prof` (
345 `numprof` int(11) NOT NULL,
346 `nom` text NOT NULL,
347 `prenom` text NOT NULL,
348 `adresse` text NOT NULL,
349 `telephone` text NOT NULL
350) ENGINE=MyISAM DEFAULT CHARSET=latin1;
351
352--
353-- Dumping data for table `prof`
354--
355
356INSERT INTO `prof` (`numprof`, `nom`, `prenom`, `adresse`, `telephone`) VALUES
357(1, 'SNOUNI', 'Leila', 'Salé', '023294532'),
358(2, 'NAFIDI', 'Ahmed', 'casablanca', '0293287425'),
359(3, 'Naimi', 'Mohamad', 'Rabat', '34328724'),
360(4, 'Nasserdin', 'Bouchaib', 'SETTAT', '02932842342'),
361(5, 'Laghrissi', 'Nadia', 'Settat', '0293248235'),
362(6, 'CHROKI', 'RAZAN', 'SETTAT', '029328472'),
363(8, 'LAKIR', 'Mohamed', 'Casablanca\'', '0900223');
364
365-- --------------------------------------------------------
366
367--
368-- Table structure for table `semestre`
369--
370
371CREATE TABLE `semestre` (
372 `numsem` int(11) NOT NULL,
373 `date_debut` text NOT NULL,
374 `date_fin` text NOT NULL
375) ENGINE=MyISAM DEFAULT CHARSET=latin1;
376
377--
378-- Dumping data for table `semestre`
379--
380
381INSERT INTO `semestre` (`numsem`, `date_debut`, `date_fin`) VALUES
382(1, '10/11/2010', '01/04/2011'),
383(2, '10/04/2010', '10/08/2010'),
384(3, '02/03/2010', '02/06/2010'),
385(4, '20/06/2010', '20/09/2010');
386
387-- --------------------------------------------------------
388
389--
390-- Table structure for table `stage`
391--
392
393CREATE TABLE `stage` (
394 `numstage` int(11) NOT NULL,
395 `lieu_stage` text NOT NULL,
396 `date_debut` text NOT NULL,
397 `date_fin` text NOT NULL,
398 `numel` int(11) NOT NULL
399) ENGINE=MyISAM DEFAULT CHARSET=latin1;
400
401--
402-- Dumping data for table `stage`
403--
404
405INSERT INTO `stage` (`numstage`, `lieu_stage`, `date_debut`, `date_fin`, `numel`) VALUES
406(1, 'dell', '04/03/2010', '11/03/2010', 3),
407(2, 'COREMI', '01/07/2009', '01/08/2009', 5),
408(3, 'OCP', '01/07/2009', '01/08/2009', 4),
409(8, 'Microsoft', '01/07/2010', '01/08/2010', 8);
410
411--
412-- Indexes for dumped tables
413--
414
415--
416-- Indexes for table `bulletin`
417--
418ALTER TABLE `bulletin`
419 ADD PRIMARY KEY (`id`);
420
421--
422-- Indexes for table `classe`
423--
424ALTER TABLE `classe`
425 ADD PRIMARY KEY (`codecl`);
426
427--
428-- Indexes for table `conseil`
429--
430ALTER TABLE `conseil`
431 ADD PRIMARY KEY (`id`);
432
433--
434-- Indexes for table `devoir`
435--
436ALTER TABLE `devoir`
437 ADD PRIMARY KEY (`numdev`);
438
439--
440-- Indexes for table `diplome`
441--
442ALTER TABLE `diplome`
443 ADD PRIMARY KEY (`numdip`);
444
445--
446-- Indexes for table `eleve`
447--
448ALTER TABLE `eleve`
449 ADD PRIMARY KEY (`numel`),
450 ADD KEY `codecl2` (`codecl`);
451
452--
453-- Indexes for table `eleve_diplome`
454--
455ALTER TABLE `eleve_diplome`
456 ADD PRIMARY KEY (`id`);
457
458--
459-- Indexes for table `enseignement`
460--
461ALTER TABLE `enseignement`
462 ADD PRIMARY KEY (`id`);
463
464--
465-- Indexes for table `evaluation`
466--
467ALTER TABLE `evaluation`
468 ADD PRIMARY KEY (`numeval`);
469
470--
471-- Indexes for table `login`
472--
473ALTER TABLE `login`
474 ADD PRIMARY KEY (`id`);
475
476--
477-- Indexes for table `matiere`
478--
479ALTER TABLE `matiere`
480 ADD PRIMARY KEY (`codemat`);
481
482--
483-- Indexes for table `prof`
484--
485ALTER TABLE `prof`
486 ADD PRIMARY KEY (`numprof`);
487
488--
489-- Indexes for table `semestre`
490--
491ALTER TABLE `semestre`
492 ADD PRIMARY KEY (`numsem`);
493
494--
495-- Indexes for table `stage`
496--
497ALTER TABLE `stage`
498 ADD PRIMARY KEY (`numstage`),
499 ADD KEY `numel1` (`numel`);
500
501--
502-- AUTO_INCREMENT for dumped tables
503--
504
505--
506-- AUTO_INCREMENT for table `bulletin`
507--
508ALTER TABLE `bulletin`
509 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
510--
511-- AUTO_INCREMENT for table `classe`
512--
513ALTER TABLE `classe`
514 MODIFY `codecl` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
515--
516-- AUTO_INCREMENT for table `conseil`
517--
518ALTER TABLE `conseil`
519 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
520--
521-- AUTO_INCREMENT for table `devoir`
522--
523ALTER TABLE `devoir`
524 MODIFY `numdev` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;
525--
526-- AUTO_INCREMENT for table `diplome`
527--
528ALTER TABLE `diplome`
529 MODIFY `numdip` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
530--
531-- AUTO_INCREMENT for table `eleve`
532--
533ALTER TABLE `eleve`
534 MODIFY `numel` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
535--
536-- AUTO_INCREMENT for table `eleve_diplome`
537--
538ALTER TABLE `eleve_diplome`
539 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
540--
541-- AUTO_INCREMENT for table `enseignement`
542--
543ALTER TABLE `enseignement`
544 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
545--
546-- AUTO_INCREMENT for table `evaluation`
547--
548ALTER TABLE `evaluation`
549 MODIFY `numeval` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
550--
551-- AUTO_INCREMENT for table `login`
552--
553ALTER TABLE `login`
554 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
555--
556-- AUTO_INCREMENT for table `matiere`
557--
558ALTER TABLE `matiere`
559 MODIFY `codemat` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;
560--
561-- AUTO_INCREMENT for table `prof`
562--
563ALTER TABLE `prof`
564 MODIFY `numprof` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
565--
566-- AUTO_INCREMENT for table `semestre`
567--
568ALTER TABLE `semestre`
569 MODIFY `numsem` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
570--
571-- AUTO_INCREMENT for table `stage`
572--
573ALTER TABLE `stage`
574 MODIFY `numstage` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;--
575-- Database: `pfe2017`
576--
577CREATE DATABASE IF NOT EXISTS `pfe2017` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
578USE `pfe2017`;
579
580-- --------------------------------------------------------
581
582--
583-- Table structure for table `etudiant`
584--
585
586CREATE TABLE `etudiant` (
587 `nom` varchar(258) NOT NULL,
588 `prenom` varchar(250) NOT NULL,
589 `adresse` varchar(258) NOT NULL,
590 `email` varchar(35) NOT NULL,
591 `filliere` varchar(125) NOT NULL
592) ENGINE=MyISAM DEFAULT CHARSET=latin1;
593
594--
595-- Dumping data for table `etudiant`
596--
597
598INSERT INTO `etudiant` (`nom`, `prenom`, `adresse`, `email`, `filliere`) VALUES
599('test', 'test', 'test', 'ets', 'test'),
600('', '', '', '', ''),
601('', '', '', '', ''),
602('elmendili', 'yassir', 'sale', 'yassirmendili@gmail.com', 'sri'),
603('', '', '', '', ''),
604('', '', '', '', ''),
605('mendili', 'yassir', 'hzev', 'izegl', 'sri'),
606('Mendili', 'Yassir', 'Hay karima imm 59 app 08', 'yassirelmendili@yahoo.com', 'SRI'),
607('Mendili', 'Yassir', 'Hay karima imm 59 app 08', 'yassirelmendili@yahoo.com', 'SRI'),
608('erberne', 'ererbeb', 'etnetntnt', 'tenetnntrn', 'SRI');
609
610-- --------------------------------------------------------
611
612--
613-- Table structure for table `login`
614--
615
616CREATE TABLE `login` (
617 `id` int(3) NOT NULL,
618 `email` varchar(20) NOT NULL,
619 `username` varchar(20) NOT NULL,
620 `password` varchar(50) NOT NULL,
621 `type` varchar(20) NOT NULL
622) ENGINE=InnoDB DEFAULT CHARSET=latin1;
623
624--
625-- Dumping data for table `login`
626--
627
628INSERT INTO `login` (`id`, `email`, `username`, `password`, `type`) VALUES
629(4, '', 'test', 'test', ''),
630(5, '', 'paco', 'paco', '');
631
632--
633-- Indexes for dumped tables
634--
635
636--
637-- Indexes for table `login`
638--
639ALTER TABLE `login`
640 ADD PRIMARY KEY (`id`);
641
642--
643-- AUTO_INCREMENT for dumped tables
644--
645
646--
647-- AUTO_INCREMENT for table `login`
648--
649ALTER TABLE `login`
650 MODIFY `id` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;--
651-- Database: `test`
652--
653CREATE DATABASE IF NOT EXISTS `test` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
654USE `test`;
655
656-- --------------------------------------------------------
657
658--
659-- Table structure for table `ensegner`
660--
661
662CREATE TABLE `ensegner` (
663 `ID` int(11) NOT NULL,
664 `ID_Matiere` int(11) NOT NULL
665) ENGINE=InnoDB DEFAULT CHARSET=latin1;
666
667-- --------------------------------------------------------
668
669--
670-- Table structure for table `etudiant`
671--
672
673CREATE TABLE `etudiant` (
674 `ID` int(11) NOT NULL,
675 `Nom` char(25) DEFAULT NULL,
676 `Prenom` char(25) DEFAULT NULL,
677 `Sexe` char(1) DEFAULT NULL,
678 `Nationalite` char(25) DEFAULT NULL,
679 `Date_N` date DEFAULT NULL,
680 `Lieu_N` char(25) DEFAULT NULL,
681 `CIN` varchar(25) DEFAULT NULL,
682 `Numero_inscription` decimal(10,0) DEFAULT NULL,
683 `CNE` varchar(25) DEFAULT NULL,
684 `Type_BAC` char(25) DEFAULT NULL,
685 `Date_inscription_1er` date DEFAULT NULL,
686 `Date_inscription_2em` date DEFAULT NULL,
687 `moyenne_1er_annee` float DEFAULT NULL,
688 `Institue_d_origine` varchar(25) DEFAULT NULL,
689 `Tel` decimal(10,0) DEFAULT NULL,
690 `Email` varchar(25) DEFAULT NULL,
691 `Adresse` varchar(25) DEFAULT NULL,
692 `Niveaux` varchar(25) DEFAULT NULL,
693 `Filiere` varchar(25) DEFAULT NULL
694) ENGINE=InnoDB DEFAULT CHARSET=latin1;
695
696-- --------------------------------------------------------
697
698--
699-- Table structure for table `etudier`
700--
701
702CREATE TABLE `etudier` (
703 `ID` int(11) NOT NULL,
704 `ID_Matiere` int(11) NOT NULL
705) ENGINE=InnoDB DEFAULT CHARSET=latin1;
706
707-- --------------------------------------------------------
708
709--
710-- Table structure for table `matiere`
711--
712
713CREATE TABLE `matiere` (
714 `ID` int(11) NOT NULL,
715 `Nom` char(25) DEFAULT NULL,
716 `MOY_ds` float DEFAULT NULL,
717 `MOY_examen` float DEFAULT NULL,
718 `MOY_generale` float DEFAULT NULL,
719 `Coefficient` int(11) DEFAULT NULL,
720 `Prof` char(25) DEFAULT NULL,
721 `Unite` char(25) DEFAULT NULL
722) ENGINE=InnoDB DEFAULT CHARSET=latin1;
723
724-- --------------------------------------------------------
725
726--
727-- Table structure for table `obtenir_note`
728--
729
730CREATE TABLE `obtenir_note` (
731 `ID` int(11) NOT NULL,
732 `ID_Professeur` int(11) NOT NULL,
733 `ID_Professeur_1` int(11) NOT NULL
734) ENGINE=InnoDB DEFAULT CHARSET=latin1;
735
736-- --------------------------------------------------------
737
738--
739-- Table structure for table `professeur`
740--
741
742CREATE TABLE `professeur` (
743 `ID` int(11) NOT NULL,
744 `Nom` char(25) DEFAULT NULL,
745 `Prenom` char(25) DEFAULT NULL,
746 `Matiere` char(25) DEFAULT NULL,
747 `Tel` decimal(10,0) DEFAULT NULL,
748 `Email` varchar(25) DEFAULT NULL
749) ENGINE=InnoDB DEFAULT CHARSET=latin1;
750
751--
752-- Indexes for dumped tables
753--
754
755--
756-- Indexes for table `ensegner`
757--
758ALTER TABLE `ensegner`
759 ADD PRIMARY KEY (`ID`,`ID_Matiere`),
760 ADD KEY `FK_Ensegner_ID_Matiere` (`ID_Matiere`);
761
762--
763-- Indexes for table `etudiant`
764--
765ALTER TABLE `etudiant`
766 ADD PRIMARY KEY (`ID`);
767
768--
769-- Indexes for table `etudier`
770--
771ALTER TABLE `etudier`
772 ADD PRIMARY KEY (`ID`,`ID_Matiere`),
773 ADD KEY `FK_Etudier_ID_Matiere` (`ID_Matiere`);
774
775--
776-- Indexes for table `matiere`
777--
778ALTER TABLE `matiere`
779 ADD PRIMARY KEY (`ID`);
780
781--
782-- Indexes for table `obtenir_note`
783--
784ALTER TABLE `obtenir_note`
785 ADD PRIMARY KEY (`ID`,`ID_Professeur`,`ID_Professeur_1`),
786 ADD KEY `FK_Obtenir_note_ID_Professeur` (`ID_Professeur`),
787 ADD KEY `FK_Obtenir_note_ID_Professeur_1` (`ID_Professeur_1`);
788
789--
790-- Indexes for table `professeur`
791--
792ALTER TABLE `professeur`
793 ADD PRIMARY KEY (`ID`);
794
795--
796-- AUTO_INCREMENT for dumped tables
797--
798
799--
800-- AUTO_INCREMENT for table `etudiant`
801--
802ALTER TABLE `etudiant`
803 MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
804--
805-- AUTO_INCREMENT for table `matiere`
806--
807ALTER TABLE `matiere`
808 MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
809--
810-- AUTO_INCREMENT for table `professeur`
811--
812ALTER TABLE `professeur`
813 MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
814--
815-- Constraints for dumped tables
816--
817
818--
819-- Constraints for table `ensegner`
820--
821ALTER TABLE `ensegner`
822 ADD CONSTRAINT `FK_Ensegner_ID` FOREIGN KEY (`ID`) REFERENCES `professeur` (`ID`),
823 ADD CONSTRAINT `FK_Ensegner_ID_Matiere` FOREIGN KEY (`ID_Matiere`) REFERENCES `matiere` (`ID`);
824
825--
826-- Constraints for table `etudier`
827--
828ALTER TABLE `etudier`
829 ADD CONSTRAINT `FK_Etudier_ID` FOREIGN KEY (`ID`) REFERENCES `etudiant` (`ID`),
830 ADD CONSTRAINT `FK_Etudier_ID_Matiere` FOREIGN KEY (`ID_Matiere`) REFERENCES `matiere` (`ID`);
831
832--
833-- Constraints for table `obtenir_note`
834--
835ALTER TABLE `obtenir_note`
836 ADD CONSTRAINT `FK_Obtenir_note_ID` FOREIGN KEY (`ID`) REFERENCES `etudiant` (`ID`),
837 ADD CONSTRAINT `FK_Obtenir_note_ID_Professeur` FOREIGN KEY (`ID_Professeur`) REFERENCES `professeur` (`ID`),
838 ADD CONSTRAINT `FK_Obtenir_note_ID_Professeur_1` FOREIGN KEY (`ID_Professeur_1`) REFERENCES `professeur` (`ID`);
839
840/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
841/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
842/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;