YnvP5D8J

1-- phpMyAdmin SQL Dump
2-- version 4.7.9
3-- https://www.phpmyadmin.net/
4--
5-- Hôte : 127.0.0.1:3306
6-- Généré le :  mer. 16 jan. 2019 à 00:12
7-- Version du serveur :  5.7.21
8-- Version de PHP :  5.6.35
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Base de données :  `daw`
23--
24
25-- --------------------------------------------------------
26
27--
28-- Structure de la table `candidat`
29--
30
31DROP TABLE IF EXISTS `candidat`;
32CREATE TABLE IF NOT EXISTS `candidat` (
33  `matricule` int(11) NOT NULL AUTO_INCREMENT,
34  `nom` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
35  `prenom` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
36  `Nbr_prog` int(10) DEFAULT '0',
37  `password` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
38  `date` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
39  `lieu` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
40  `Nbr_rat` int(10) DEFAULT '0',
41  `Nbr_red` int(10) DEFAULT '0',
42  `etat` int(1) DEFAULT '0',
43  `spec` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
44  `moy` int(20) DEFAULT '0',
45  PRIMARY KEY (`matricule`)
46) ENGINE=InnoDB AUTO_INCREMENT=74 DEFAULT CHARSET=latin1;
47
48--
49-- Déchargement des données de la table `candidat`
50--
51
52INSERT INTO `candidat` (`matricule`, `nom`, `prenom`, `Nbr_prog`, `password`, `date`, `lieu`, `Nbr_rat`, `Nbr_red`, `etat`, `spec`, `moy`) VALUES
53(1, '', '', 10, '', '', '', 10, 10, 10, '10', 10),
54(2, '', '', NULL, '', '', '', NULL, NULL, NULL, NULL, NULL),
55(3, '', '', NULL, '', '', '', NULL, NULL, NULL, NULL, NULL),
56(4, '', '', 10, '', '', '', 10, 10, 10, '10', 10),
57(5, '', '', 0, '', '', '', 0, NULL, 0, NULL, 0),
58(6, '', '', 0, '', '', '', 0, 0, 0, NULL, 0),
59(7, '', '', 0, '', '', '', 0, 0, 0, NULL, 0),
60(8, 'min', 'amine', 0, NULL, '1996-12-15', NULL, 0, 0, 0, NULL, 0),
61(9, 'cx', 'cs', 0, NULL, 'cs', NULL, 0, 0, 0, NULL, 0),
62(10, 'aw', 'awa', 0, NULL, 'w', NULL, 0, 0, 0, NULL, 0),
63(11, 'ami', 'amine', 0, NULL, 'cds', NULL, 0, 0, 0, NULL, 0),
64(12, 'ami', 'amin', 0, NULL, 'eac', NULL, 0, 0, 0, NULL, 0),
65(13, 'a', 'aa', 0, NULL, 'b', NULL, 0, 0, 0, NULL, 0),
66(14, 'n', 'nn', 0, NULL, 'a', NULL, 0, 0, 0, NULL, 0),
67(15, 'a', 'av', 0, NULL, 'v', NULL, 0, 0, 0, NULL, 0),
68(16, 'wa', 'ww', 0, NULL, 'w', NULL, 0, 0, 0, NULL, 0),
69(17, 'ww', 'wwww', 0, NULL, 'w', NULL, 0, 0, 0, NULL, 0),
70(18, 'x', 'd', 0, NULL, 'l', NULL, 0, 0, 0, NULL, 0),
71(19, 'aw', 'ww', 0, NULL, 'wwc', NULL, 0, 0, 0, NULL, 0),
72(20, 'a', 'wqq', 0, NULL, 'wqq', NULL, 0, 0, 0, NULL, 0),
73(21, 'wa', 'awa', 0, NULL, 'w', NULL, 0, 0, 0, NULL, 0),
74(22, 'a', 'ww', 0, NULL, 'w', NULL, 0, 0, 0, NULL, 0),
75(23, 'aw', 'w', 0, NULL, 'ww', NULL, 0, 0, 0, NULL, 0),
76(24, 'wa', 'waw', 0, NULL, 'wa', NULL, 0, 0, 0, NULL, 0),
77(25, 'wa', 'wa', 0, NULL, 'a', NULL, 0, 0, 0, NULL, 0),
78(26, 'a', 'awa', 0, NULL, 'w', NULL, 0, 0, 0, NULL, 0),
79(27, 'wali', 'wd', 12, NULL, 'ws', 'jijel', 12, 12, 0, 'gl', 0),
80(28, 'walid', 'bzd', 0, NULL, '151515', NULL, 0, 0, 0, NULL, 0),
81(29, 'ano', 'ad', 0, NULL, 'zd', NULL, 0, 0, 0, NULL, 0),
82(30, 'adel', 'mes', 0, NULL, 'ref', NULL, 0, 0, 0, NULL, 0),
83(31, 'hak', 'hak', 0, NULL, 'fr', NULL, 0, 0, 0, NULL, 0),
84(32, 'hhh', 'hhhh', 12, NULL, 'fd', 'jijel', 12, 12, 0, 'gl', 0),
85(33, 'wa', 'was', 12, NULL, 'wa', 'jijel', 12, 12, 0, 'gl', 0),
86(34, 'walid', 'lounis', 0, NULL, 'xds', 'jijel', 0, 0, 0, 'zd', 0),
87(35, 'tarik', 'mousaoui', 12, NULL, '1996-12-17', 'jijel', 213, 132, 0, 'jijel', 0),
88(36, 'ba', 'ba', 12, NULL, '19', 'jijel', 12, 21, 0, 'gl', 0),
89(37, 'bb', 'bb', 0, NULL, '18', NULL, 0, 0, 0, NULL, 0),
90(38, 'pp', 'pp', 0, NULL, '1996-12-17', 'jjijel', 0, 0, 0, 'si', 0),
91(39, 'vv', 'vv', 10, NULL, '1196-12-12', 'jijel', 10, 10, 0, 'gl', 0),
92(40, 'nn', 'nn', 1, NULL, '1996', 'b', 1, 1, 0, 'ge', 0),
93(41, 'abd', 'abd', 11, NULL, '1997-12-17', 'jijel', 1, 0, 0, 'gl', 0),
94(42, 'rr', 'rr', 66, NULL, 'rr', 'jijel', 66, 66, 0, 'z', 0),
95(43, 'mm', 'mm', 10, NULL, 'mm', 'jijel', 10, 10, 0, 'fl', 0),
96(44, 'test', 'test', 2, NULL, '2019-01-10', 'ouargla', 2, 22, 0, 'si', 0),
97(45, 'zz', 'zz', 0, NULL, '1', NULL, 0, 0, 0, NULL, 0),
98(46, 'ara', 'ara', 23, NULL, '41', 'jije', 23, 23, 0, 'z', 0),
99(47, 'rr', 'rrr', 0, NULL, 'r', NULL, 0, 0, 0, NULL, 0),
100(48, 'bebe', 'bebe', 2, NULL, '1', 'dd', 2, 22, 0, 'a', 0),
101(49, 'tt', 'tt', 20, NULL, '15', 'b', 20, 20, 0, 'z', 0),
102(50, 'ra', 'ra', 0, NULL, '1', NULL, 0, 0, 0, NULL, 0),
103(51, 'raouf', 'raouf', 1, NULL, '1996-14-1', 'f', 1, 1, 0, 'z', 0),
104(52, 'adel', 'adel', 1, NULL, 'adel', 'b', 1, 1, 0, 'a', 0),
105(53, 'Na', 'Na', 1, NULL, '1', 'w', 1, 1, 0, 'wa', 0),
106(54, 'mohamed', 'mohamed', 54, NULL, '1996-12-17', 'w', 54, 54, 0, 'a', 0),
107(55, 'babab', 'babab', 1, NULL, '1', 'c', 1, 1, 0, 'a', 0),
108(56, 'hak', 'hakou', 16, NULL, '18*18', 'wargla', 16, 16, 0, 'a', 0),
109(57, 'hakk', 'hakkou', 10, NULL, '18-15-1', 'jijel', 10, 10, 0, 'z', 0),
110(58, 'kaka', 'kaka', 10, NULL, '199-48-12', 'jijel', 10, 10, 0, 'za', 0),
111(59, 'amm', 'amine', 10, NULL, '199-12-1', 'j', 10, 10, 0, 'rf', 0),
112(60, 'lili', 'lili', 52, NULL, '1996-12-12', 'c', 2, 22, 0, 'd', 0),
113(61, 'lounis', 'walid', 0, NULL, '1996-19-17', 'jijel', 0, 0, 0, 'si', 0),
114(62, 'var', 'var', 12, NULL, '1996-12-14', 'jije', 10, 10, 0, 'ad', 0),
115(63, 'dam', 'dam', 1, NULL, '1996-12-19', 'jijel', 1, 1, 0, 'asa', 0),
116(64, 'p', 'p', 0, NULL, 'p', NULL, 0, 0, 0, NULL, 0),
117(65, 'la', 'la', 0, NULL, 'aa', NULL, 0, 0, 0, NULL, 0),
118(66, 'w', 'ww', 0, NULL, 'w', NULL, 0, 0, 0, NULL, 0),
119(67, 'papa', 'papa', 0, NULL, 'aa', NULL, 0, 0, 0, NULL, 0),
120(68, 'baaa', 'baaa', 0, NULL, 'a', NULL, 0, 0, 0, NULL, 0),
121(69, 'amine', 'bouzid', 1, NULL, '111', 'jijel', 1, 10, 0, 'gl', 0),
122(70, 'ami', 'ami', 10, NULL, '4', 'jijel', 10, 10, 0, ' a:', 0),
123(71, 'amine', 'bouz', 0, NULL, '17/12/1996', NULL, 0, 0, 0, NULL, 0),
124(72, 'am', 'am', 1, NULL, '1221', 'jijel', 1, 1, 0, 'gl', 0),
125(73, 'ad', 'ad', 10, NULL, '12', 'jijel', 10, 10, 0, 'gl', 0);
126
127-- --------------------------------------------------------
128
129--
130-- Structure de la table `moyenne`
131--
132
133DROP TABLE IF EXISTS `moyenne`;
134CREATE TABLE IF NOT EXISTS `moyenne` (
135  `id_mat` int(11) NOT NULL,
136  `s1` float NOT NULL DEFAULT '0',
137  `s2` float NOT NULL DEFAULT '0',
138  `s3` float NOT NULL DEFAULT '0',
139  `s4` float NOT NULL DEFAULT '0',
140  `s5` float NOT NULL DEFAULT '0',
141  `s6` float NOT NULL DEFAULT '0',
142  PRIMARY KEY (`id_mat`)
143) ENGINE=InnoDB DEFAULT CHARSET=latin1;
144
145--
146-- Déchargement des données de la table `moyenne`
147--
148
149INSERT INTO `moyenne` (`id_mat`, `s1`, `s2`, `s3`, `s4`, `s5`, `s6`) VALUES
150(1, 2, 2, 22, 2, 2, 2),
151(2, 2, 2, 22, 2, 2, 2),
152(3, 2, 2, 22, 2, 2, 2),
153(4, 2, 2, 22, 2, 2, 2),
154(27, 2, 2, 22, 2, 2, 2),
155(28, 2, 2, 22, 2, 2, 2),
156(29, 2, 2, 22, 2, 2, 2),
157(30, 2, 2, 22, 2, 2, 2),
158(31, 2, 2, 22, 2, 2, 2),
159(32, 2, 2, 22, 2, 2, 2),
160(33, 2, 2, 22, 2, 2, 2),
161(34, 2, 2, 22, 2, 2, 2),
162(35, 2, 2, 22, 2, 2, 2),
163(36, 2, 2, 22, 2, 2, 2),
164(37, 2, 2, 22, 2, 2, 2),
165(38, 2, 2, 22, 2, 2, 2),
166(39, 2, 2, 22, 2, 2, 2),
167(40, 2, 2, 22, 2, 2, 2),
168(41, 2, 2, 22, 2, 2, 2),
169(42, 2, 2, 22, 2, 2, 2),
170(43, 2, 2, 22, 2, 2, 2),
171(44, 2, 2, 22, 2, 2, 2),
172(45, 2, 2, 22, 2, 2, 2),
173(46, 2, 2, 22, 2, 2, 2),
174(47, 2, 2, 22, 2, 2, 2),
175(48, 2, 2, 22, 2, 2, 2),
176(49, 1, 1, 1, 1, 1, 1),
177(50, 0, 0, 0, 0, 0, 0),
178(51, 1, 1, 1, 1, 11, 1),
179(52, 1, 11, 11, 11, 1, 1),
180(53, 11, 1, 1, 1, 1, 1),
181(54, 54, 54, 54, 54, 54, 54),
182(55, 1, 1, 1, 1, 1, 1),
183(56, 1, 1, 11, 1, 1, 1),
184(57, 10, 101, 10, 10, 10, 10),
185(58, 10, 10, 10, 10, 10, 10),
186(59, 10, 10, 10, 10, 10, 1),
187(60, 1, 1, 1, 1, 1, 1),
188(61, 13, 13, 11, 10, 20, 20),
189(62, 10.2, 12, 1, 1, 1, 1),
190(63, 10.41, 1.1, 1.2, 12.2, 1.21, 1.22),
191(64, 0, 0, 0, 0, 0, 0),
192(65, 0, 0, 0, 0, 0, 0),
193(66, 0, 0, 0, 0, 0, 0),
194(67, 0, 0, 0, 0, 0, 0),
195(68, 0, 0, 0, 0, 0, 0),
196(69, 1, 1, 11, 1, 1, 1),
197(70, 10, 10, 110, 10, 10, 10),
198(71, 0, 0, 0, 0, 0, 0),
199(72, 12, 12, 1212, 121, 12, 12),
200(73, 1, 0, 11, 1, 1, 1);
201
202-- --------------------------------------------------------
203
204--
205-- Structure de la table `postuler`
206--
207
208DROP TABLE IF EXISTS `postuler`;
209CREATE TABLE IF NOT EXISTS `postuler` (
210  `matricule` int(11) NOT NULL,
211  `code_univ` int(10) NOT NULL,
212  `id_spec` int(11) NOT NULL,
213  PRIMARY KEY (`matricule`,`code_univ`,`id_spec`),
214  KEY `code_univ` (`code_univ`)
215) ENGINE=InnoDB DEFAULT CHARSET=latin1;
216
217--
218-- Déchargement des données de la table `postuler`
219--
220
221INSERT INTO `postuler` (`matricule`, `code_univ`, `id_spec`) VALUES
222(72, 1, 0),
223(73, 1, 1),
224(73, 1, 2),
225(73, 2, 3);
226
227-- --------------------------------------------------------
228
229--
230-- Structure de la table `responsable`
231--
232
233DROP TABLE IF EXISTS `responsable`;
234CREATE TABLE IF NOT EXISTS `responsable` (
235  `id_res` int(11) NOT NULL AUTO_INCREMENT,
236  `id_univ` int(11) NOT NULL,
237  `nom` varchar(20) NOT NULL,
238  `prenom` varchar(20) NOT NULL,
239  PRIMARY KEY (`id_res`)
240) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
241
242--
243-- Déchargement des données de la table `responsable`
244--
245
246INSERT INTO `responsable` (`id_res`, `id_univ`, `nom`, `prenom`) VALUES
247(1, 2, 'AMINE', 'BOUZID');
248
249-- --------------------------------------------------------
250
251--
252-- Structure de la table `specality`
253--
254
255DROP TABLE IF EXISTS `specality`;
256CREATE TABLE IF NOT EXISTS `specality` (
257  `id_spec` int(11) NOT NULL AUTO_INCREMENT,
258  `specialiter` varchar(20) NOT NULL,
259  `code_univ` int(11) NOT NULL,
260  `place disponible` int(11) NOT NULL,
261  PRIMARY KEY (`id_spec`),
262  KEY `code_univ` (`code_univ`)
263) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
264
265--
266-- Déchargement des données de la table `specality`
267--
268
269INSERT INTO `specality` (`id_spec`, `specialiter`, `code_univ`, `place disponible`) VALUES
270(1, 'informatique', 1, 0),
271(2, 'sport', 1, 0),
272(3, 'gestion', 2, 0);
273
274-- --------------------------------------------------------
275
276--
277-- Structure de la table `specialiter`
278--
279
280DROP TABLE IF EXISTS `specialiter`;
281CREATE TABLE IF NOT EXISTS `specialiter` (
282  `id_spe` int(11) NOT NULL,
283  `id_specialiter` varchar(20) NOT NULL,
284  PRIMARY KEY (`id_spe`,`id_specialiter`)
285) ENGINE=MyISAM DEFAULT CHARSET=latin1;
286
287--
288-- Déchargement des données de la table `specialiter`
289--
290
291INSERT INTO `specialiter` (`id_spe`, `id_specialiter`) VALUES
292(1, 'GL'),
293(1, 'SCI'),
294(1, 'SI'),
295(1, 'TI'),
296(2, 'sport option 2'),
297(2, 'sport option1');
298
299-- --------------------------------------------------------
300
301--
302-- Structure de la table `university`
303--
304
305DROP TABLE IF EXISTS `university`;
306CREATE TABLE IF NOT EXISTS `university` (
307  `id_univ` int(10) NOT NULL AUTO_INCREMENT,
308  `name` varchar(50) NOT NULL,
309  PRIMARY KEY (`id_univ`)
310) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
311
312--
313-- Déchargement des données de la table `university`
314--
315
316INSERT INTO `university` (`id_univ`, `name`) VALUES
317(1, 'univconst 2'),
318(2, 'univconst 1'),
319(3, 'unv alger 2'),
320(4, 'unv alger 1');
321
322-- --------------------------------------------------------
323
324--
325-- Structure de la table `vice_doyen`
326--
327
328DROP TABLE IF EXISTS `vice_doyen`;
329CREATE TABLE IF NOT EXISTS `vice_doyen` (
330  `id_vice` int(20) NOT NULL AUTO_INCREMENT,
331  `nom` varchar(20) NOT NULL,
332  `prenom` varchar(20) NOT NULL,
333  `password` varchar(20) NOT NULL,
334  `id_univ` int(11) NOT NULL,
335  PRIMARY KEY (`id_vice`),
336  KEY `id_univ` (`id_univ`)
337) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
338
339--
340-- Déchargement des données de la table `vice_doyen`
341--
342
343INSERT INTO `vice_doyen` (`id_vice`, `nom`, `prenom`, `password`, `id_univ`) VALUES
344(1, 'tuck', 'fuker', 'bitch', 1);
345
346--
347-- Contraintes pour les tables déchargées
348--
349
350--
351-- Contraintes pour la table `moyenne`
352--
353ALTER TABLE `moyenne`
354  ADD CONSTRAINT `moyenne_ibfk_1` FOREIGN KEY (`id_mat`) REFERENCES `candidat` (`matricule`);
355
356--
357-- Contraintes pour la table `postuler`
358--
359ALTER TABLE `postuler`
360  ADD CONSTRAINT `postuler_ibfk_1` FOREIGN KEY (`code_univ`) REFERENCES `university` (`id_univ`),
361  ADD CONSTRAINT `postuler_ibfk_2` FOREIGN KEY (`matricule`) REFERENCES `candidat` (`matricule`);
362
363--
364-- Contraintes pour la table `specality`
365--
366ALTER TABLE `specality`
367  ADD CONSTRAINT `specality_ibfk_1` FOREIGN KEY (`code_univ`) REFERENCES `university` (`id_univ`);
368
369--
370-- Contraintes pour la table `vice_doyen`
371--
372ALTER TABLE `vice_doyen`
373  ADD CONSTRAINT `vice_doyen_ibfk_1` FOREIGN KEY (`id_univ`) REFERENCES `university` (`id_univ`);
374COMMIT;
375
376/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
377/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
378/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;