-
Notifications
You must be signed in to change notification settings - Fork 5
/
Copy pathgpea.sql
485 lines (410 loc) · 119 KB
/
gpea.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
-- phpMyAdmin SQL Dump
-- version 4.6.4
-- https://www.phpmyadmin.net/
--
-- Client : 127.0.0.1
-- Généré le : Dim 16 Juillet 2017 à 07:33
-- Version du serveur : 5.7.14
-- Version de PHP : 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 */;
--
-- Base de données : `gpea`
--
-- --------------------------------------------------------
--
-- Structure de la table `administration`
--
CREATE TABLE `administration` (
`ID_ADMIN` bigint(20) NOT NULL,
`NOM_ADMIN` varchar(20) DEFAULT NULL,
`PRENOM_ADMIN` varchar(20) DEFAULT NULL,
`EMAIL_ADMIN` varchar(40) DEFAULT NULL,
`MDP_ADMIN` varchar(40) DEFAULT NULL,
`PHOTO_ADMIN` blob
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Contenu de la table `administration`
--
INSERT INTO `administration` (`ID_ADMIN`, `NOM_ADMIN`, `PRENOM_ADMIN`, `EMAIL_ADMIN`, `MDP_ADMIN`, `PHOTO_ADMIN`) VALUES
(2, 'Faraby', 'Youssef', '[email protected]', 'qwerty', NULL),
(1, 'chla', 'aymen', '[email protected]', 'aymen', 0xffd8ffe000104a46494600010200000100010000ffed009c50686f746f73686f7020332e30003842494d04040000000000801c026700145252725a676d43387a4133515563785747416d2d1c0228006246424d4430313030306163303033303030303937303530303030386430393030303032313061303030306536306130303030613131313030303064303138303030303438313930303030313231613030303030363162303030303730323630303030ffe2021c4943435f50524f46494c450001010000020c6c636d73021000006d6e74725247422058595a2007dc00010019000300290039616373704150504c0000000000000000000000000000000000000000000000000000f6d6000100000000d32d6c636d7300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000a64657363000000fc0000005e637072740000015c0000000b777470740000016800000014626b70740000017c000000147258595a00000190000000146758595a000001a4000000146258595a000001b80000001472545243000001cc0000004067545243000001cc0000004062545243000001cc0000004064657363000000000000000363320000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000074657874000000004642000058595a20000000000000f6d6000100000000d32d58595a20000000000000031600000333000002a458595a200000000000006fa2000038f50000039058595a2000000000000062990000b785000018da58595a2000000000000024a000000f840000b6cf63757276000000000000001a000000cb01c903630592086b0bf6103f15511b3421f1299032183b92460551775ded6b707a0589b19a7cac69bf7dd3c3e930ffffffdb00430006040506050406060506070706080a100a0a09090a140e0f0c1017141818171416161a1d251f1a1b231c1616202c20232627292a29191f2d302d283025282928ffdb0043010707070a080a130a0a13281a161a2828282828282828282828282828282828282828282828282828282828282828282828282828282828282828282828282828ffc200110800a000a003002200011101021101ffc4001b00000203010101000000000000000000000304020506010007ffc400190100030101010000000000000000000000010203000405ffc400190100030101010000000000000000000000010203000405ffda000c0300000111021100000187b85f5bcd1f89cda1e08e6ecfab012a5c42bfb0b38181615582d312ad41ad608579b7343535f78abeae395f69a2f5eacad55076c41a0f5cac196182d415fc55b10999e6d1810a3017b6afcb58070f40f588cf168723c3a33ac688747d08234598e611cfdc389588f60fa4104ebc83b542ceb154bd871650f76ac477025206124664e7381ad034875848f1ec8a0c3be5082d71e18d5f24a55349d234a3aaf13653b290317eaae260d202f9538fd202540cda1ec08db46b2485b2caab4f35a2a956d751d8d4ba563564d15a06ed24ad522be002af4fc5752123e61449122af35ada7bc57dcd15ea9022d424f58fd76c293a88f17067c7860cba62ab004caaafe5e3619c739d6946f2633da36fa352a01b0e54d8235c827946996eaa34819789964619a0ab67bcde810e4d2de731c7e4be8ff24ebe61b1acb0b4726bea644652c686c15ad5da3dc735cb53689aee57de5da533ba4ecc0207cc10197335b2384fa8d2dd33ba6ce696b38a5d6b6f9e392d132934a5e725d0b2a4d2ecdce3d9b7a70991531b38b0ab66d7db5586aee03fceacd377ab9ecabc69103d96336b0b7fffc40029100003000203000202000505000000000001020300041112132122052310142031410624323344ffda0008010000010502fe8e3fa0f00774e3d0652a46777c3d8e79961e0c15a3f5488e6d364c4e9c8743fc4f030ec4861d84c3b04834761c23280a304d581947cdfcd04401947ec9e9f5a62ff7ab82cc62ea38cf6a4820b6ce2e8e269a86a69f5c9ebf70faea69392a4c02cfc718e7a270014f2ca73c899ebe44e7ce5110af1d313579c96a20c550b97af45d7b1a5080d948f244cf4e1b6162c279ee5b264d3027c75e33c4904f1848cf8ca6cd132a88f3d75c551878e0a82a8403f2187c653e338e0ec357b337ae70bc22f5ce3bb4d781d4f621b972eacf4e1254191211549c3cb671c290b3a2b2f27ae39cebd904f91c75414e329c95d7989e01ce71f6f321e9cae19bd1eaeeafb24a225938f400508e1de44d366717a6c9193d8352799a05a394745c7d8181b96680e5e2bd9fea7b7c59d98b2d1b14a76675c751cb47ea15b2338d725afa8b21af2c2ccd8bff00063691e3e9d8b614eccc815197953d42b75c0dd52d6fb00e1ae594c99ec5a55c54a9cd6fd77af8977f439b556e5f5f7429b307f51e0fe5e6f48c8ff3334c3b0cf49ca6f649cfb548591f6759aec502f5aa6acbc257dbe990bfebf708e5136db8fa140c94002aa4ab6167388ac14a5028e7597f148bebb5fea0826cfaeafe5b540c659909094f045b97d86d5aee3d37708af5036b946030a4ba0114c9823168c8128bc764679bb2a1255b7ea410381aaf6d76975b25a67884a90957bd52d0275fc80d692f0c2a9ea4fdcf7cfda19d9933d09023318bf2385e25c71b936633e58ea7080270eeac199f834deb769af6aaedfb01b33194b0444b52b804b15539e546757c34623ee7109cafd85511a043caba1dabb15fae1fb3fdd735fb473af29593a5e5aee31fe1654b62bbf07af0ac1457973e4ca67d9557f60b6c0853676c36c2fce7e3f4dbc77f685763da4e25e447167cdaf690a1ad0c7a88bd38ced7a3b13750b34c1cf203d8be9db3c195213f4cb53b51664e443a1adab6cff1df217fadf4fcf1a4ec23a9b4b9574ea8bc6330cf6fbeab7679e97a154006138f36f4639a71d67988e99cf08f6fe575892df6d3ff00bf72f3ae6b5e6f53f005854a15188a2ccba42ca93e01e065a8115c85544f596cebf80e3e3f1f43e69d5f2fdb19d9623fbccf0674f33a7ad2d79d2b3ebea8ca357bc96438ebc6738cdc10ff000cff000a6f0a4b4ae51346246b8f3aaaa94683f3b63b4e12f5b7e37f1e362b0d1edb47435de94fc7eb669cd12607f1e39cadd62e36274cff00715cbb3afe3f4ff20b581d7ed3ff00d28ec99f538edce6ac390aa5470d89a3261bba7d134d91b5867f80bce1fa8698ae2c66b80f5579caf1a695b5487ebab06fd6653f35835053b6b3e9399d4b3b27ffc4002111000202010403010100000000000000000001021110122021310304411332ffda0008010211013f01aac2f14dfc17ad27d8bd45f58bd78214123494347e68d3451c158a2b6d6fa2cb68ec7c1a8acbc3e0bbc36451d6253ae08c94b1d89145091589479211ae711d8b0f8352639a876292975859d46a3cb26ca63bfa41d3c418de7925072eb1f3834b650b6a2f1e3fe4ffc4002111000202020301010003000000000000000001021110210312314104203261ffda0008010111013f01524fc2c7cf05f497eb82f097ed97c44bf5cdeac7c8dfa776776291dfaf83e46cec7665e2cb1163621e162f08b297d293f0d2f4491d7167a2558425585a1bcc78db2717064742d0e4596335884b5472caf47f848d165e3c12b141c4507c8f44a2e3e94484562d9c08b426be1c8ae232485a2f0887228fa33eec734bd3b58f6bf8cb3cdfd8ffc400351000010303020404050303050100000000010002110312213141132251612332718104104252916282a1203372304373b1c192ffda0008010000063f02ff00432614de21080b9623aacb965d2a40e52b60846145ce0b94ca02cfcac387cf242f32e5cffe2905a1739ccf550419f543ff0057316b54b9e49ecb475db4ae7e671fc05840159f9117410ad73a495391ecb1ed2b531fc237b8928dedf4ca2584b87452c2defd944bb4ce251b8182bc375314ba6a5795f3d828735f7bb40a6daaf77d4764d0ea475c2b1ada6cf75e76fb05ccf323a23e5f57544e2f34e47d8839ad7b49c07b88479c06ad25dff4a202eead74903aecb94a0461dd53dce7baf1a841ce63809d094e2c14f9446360a6f88e8d5c4a85d24c33d111e21df55fd98f550594fd508e123a7e50d2e9fb754de2da1a7cc0353c52a00c8c1400754016160c2ebeab948074211d485841dd35f446c0d23ba80ea61872e41b7b75e6c28e2120746a9f13dd132f1daf50477cad07b05d90b7f945b51f59a0ec4056f19f4e98d24492b489d16028017741f7f68e8b72119b90856f2c8fb90b4327d3747cd7690d5915277e55cb207ac2cb587b9ca26e6117142da873d02278af3d97d4fe9cc831d74b79ed7bf9535aee17363cb80a7a2dfd1087b4a9763d11f2c141cc0e9850e2dc8990bca31ba25a254baa1f62832e683d672acb8ff942b58daaf1b94d6db13fab28431ac3acb57315a85cbcede88db4a0fe11616b41d0973911129b1ca4f4c2d500fd06e13b8ad6ce97830bc604bfd51707973db9b2134b80cf4c04e8c3bd506901fba07c218d15cdaa83cbfd61121d0e1912549a86f8eb0ae700f1f92a7cac1b230f0d9fc2e63b7442adae34c7d51013ea169b27542d6481a95b37d53eec03ca15a3ca7757d4c3da7065716813c43d1bb21c3b9cefd611f0b5e8506556b9b54080b2e6ba33696a90fa433ba6da28bc1c177458b4f5202f08b38719b99a2792d6d5e5fa1b10b0ca8d23609c386eb8e45c1002ad174f99a53994fe9e528d3e231cdb672342bcdcbd611e0c3ddd5438e4ee55ad836892ae061c3a2b6a3063f0a1818d8fbb2b06a98d20a976badce185804d6dad6e13c5ede23f5a658b86d152c03ed1a26b43aa705d8feda78352ab3e1e98987084d142839cca7bcc4abbe1cdb5758d0fa2c9a83f7287b29fe1134fe29d251e30a5c38d86573389a7b764394883ba6368d324acfc383f850ef86e16e4daa038c1c4872735b52a9dba8944b5d53f7355bc40e9ce5ba204fc4516c7da11b8b6a3be9396950f639e67524c27bc52b87db769dd00c8e71a07cc2d117d1d75579665d9828b1a22460ca6b4d36388e90835ee3f95e29bab93d5536b8c6e70b5910ac0e130a002e1d91e58037721670cfe9051b9cd68d64a2d2e641e832b9ae11a39add172f143a35515293a48d065470de1e3b2b831f68ea9c194ee91bab6a30873f97d91229968da1fa2c63792e43a9dc655a5a1a7fe9710dcf6b063b950e8696a86b8389eca29fc39118d375e33386d3a34cac3a992eea51024f768d5431bafb9fc2f10b437fe358c0f55cd55d1d41534dd57d480a78b5074d93c0aee2088f3046cb5c07546a5439023d11b88d57298c6b12a388ccf64dad529021e61b22536d8ceb22253dd4fe1eab49112cd1713ca670162e2e6e5bea8bbe2e93cc22451e1ddb9d978d55b03d94d16000ee70bccf3dc086a710193aeba2e627ffb0beb0ddb953581cca8d3a9332d57536868dcb7758d1715ee0d6ef2a69791a2dff250fa33d20a05b4f4dc04d7f85d23edf440b417fee46e7981a0d5539fab79dd45205cf5c9461ad3abdc9a2a3b13914c4ff2b0207ebc9465c6d1f5bf2b91c5ded85301dd86ead2df4e509c1d51ecf46e4277339db4bbe5e685e2d473be76def667109f55b55f255e6eb271272535b0e0c71928358d10decb98a33755eda34225d0e819b7002a90c75479d09d14d774b7ec180a07cea54111f2612d92e6ce5cbfb3fceea0fc311ee5603c7ee46130168749882a29b1edcfdc8328d3c01e6857731c68a1b93e88873944beaf6d1a10e2cdbadba28d07ca4831e8a654b5cdca7834aa34807fdcc1f935823075403f519195059a6e0ea9e4b4b6d19f902bc3f39c03ba863ef3bfaab4e9eaada6d303a68800489c98feb7d3a4da8ee98c27bbe20dd55de5ccda9eead9749d30aad368d30b5a7746fb2cbae1ea8da66599c22d1aaa8da92db46c855a62da33aa2e73dc67baf33ff2aca66437fa63e208674eebc3a8d3d72bc0a7fb9f809ed07c66e491a29a821e3541dee5567b896cbf042bb0f9f746dcf51109f88b5a531f4cf8866531f7069220ca00435a3e90a6e781d9ca69bdf8d894c7531023fa45ec0e03ee586307b7cb875013dfba78a7e25289938527ed405cd33f4ce1016c1fb94b6ad48d0894f1c4bd8719dd346c806013dd7fffc4002610010002020202020203010101000000000100112131415161718191a1b1d1f0f1e1c110ffda0008010000013f21a952a57ff152a54768876cd80f6b8ee08f3aa9774c5b307ac0ecfef333df33afa9f1c60a81b7e06a53469cceb43dcaf037f0d3b85258fd26f47ccd92a2d23db3b6fa2637c915967055aca0a03230ff0021e690f28c006f683fb986d06f8d92cd5381cc0aa55b5b332a5eb240a9a55d5de7ea2379932ca79f519b1c6e0d2b6f640964f0db2eaba178d2645e12ce51069814d62d2903ce0d4c08712a1ca4b41b403a657a8f0f3a9b253cb25dd455e00fbbdcc577aaaa41800b64bf73332eebd3c13001e86fef3036e1d315e558ff00847f0c82156988d14afe084656d39afcbb89e31751f0427b167ccfda4d7a5c0e841aad4e40e1511f28b0e905bc4cdb3d13f70b5d7a42bd4a9214c11f304bce4dab67510b75cb9f5f33101a866d2a52f90607cc2dc0f64d88785c402858176c66dcdea2f68567e30c87b9b5955636f36b19a20d8603dcb8baeb2dc54193d1b99be1c459569816fdc0a5599cbb96050f966650c6437266edc1bd1ab965aacf8151cbe9443416c670d4704d58347e6548d5365dca311d64258e7c31305c6eace3539f13a8f888be18d03dc014468ad1c4079bc41c87c38216317a6596d996dc7d233f09999321e298162d9e77330216add15c4d6fedc7d12b72fc4153031140e1f886fd0d94d92d8e4ae540a5c00fe237c8c66aa82485eda830d59a3a77043c00251d626292af5810517e9b8edaee6e6499705d52b17769e5772b3e761cfcc4895451dc587cc81bbeb894a48dc5bf5e65656065cb2bd14d689803cc3cd1e52d4c0c7e221ea85c65eee22a4f15be90c58a80cfa7b850169bc254c72bbdcc0d475d3dfa8fd2e65e1ed61ed02c58fccb9a0da1888a1b01c5e61d8323bed96009a361e7d426cb4acafaee57ad5a5dbea04c19574cd3729c2910c0be2a2bcda33924136deebfda94df5b76d710ba12b05e332c069c587c31f9d84b732c7b3abfe21c8574b93db1703f00fb98a42c662e08704ccdf983404e5fa90749db333f1292bce3312de0f92c0093001d1cb02097c8299b5b154d851a2db2e116dad252df896790a0d76c2fec04a6a14b16a64f9f995e740211ab9c14407e52f14b9a7ae6f594583eb19154bc1ca1adb317f73cfa05d435c6e0e11952ad1cd58ea0b5e2cdbf446304acaa9f89d2becd0116a2dca641ea0836e6fe63ce4ce3f3285aeb4558a50219d97e8f11252ad2c7f318baf9aa61280b94bfe4c811684b5d9031bffa415ccaf80d0735f32964d88e5d6a271044fe0d411a214e49cbb9df9d2bea9dc774d54a56a60c353aa986cc2eecb6a76c95716c016daab20281f84aa983579ec45ab072f1fb9e6560b7cc6085dbf01ee1b896130932d66ab8a42a6ed47644b346d1279035ee0f43a508b75030085dafaa72242c5c4b41b31c0c30c6939800900498b659936e00f98393d2f23f73f8601ee095702b87f6a0a957236cc35313052b73761b59cd44161c7f94bda8e40533581c2d2af31d1a7b23f50d2faa657c4a3cccb37d8d462830186fe679ce0d8c6792355985476aeebf884b5897c25f364f2ef50d1e80a8a7a8ef37daac2c34bf653f30395b59210db2e1a885ebda1b895c4c05b32f40551265fbf88d5a3a9a2fc87894c5032237ec836d16f43c2e55ac395bfa910f3f458b16abcd620a64731ac63a072a352a0e89a6c7d4c30a4ba12353115ad8ac6229fec13973e4a19845d3258787e2ba3894bda8d84ba21e885a05de638b3e53e6039604e6fc0940ac62e8ae350a0edc5453c9b97d8992bfdea28cafd68cbbd467104635e52361af3651326efe2d6fd45f54d2f93070fe2c1ef060e7da0b9c76563cc5349518fb3370555c29b231e1b3770a7b5cfb4c6abd54226042cccbfbe657ee06d74b80ca2d03fb6172b40d21f50a1b915654678da95fecb96b016f697c1c4f1ae749bab75f453a6174d2f002be587d74c27c973bf8aa5a86a06ba960113819f58eb8fa99d3731a78677105b30f64bcd8cbc99edcf318a6b7e104b3aaf6cbaf3f128f85478fb8b8a979298ba521c3fbef30c896818ee32c7bd1de313c45bdd5a7f2f32f4d1ee0533baaa1ef0b27aa885bdfee72db004082b92b287f2897bcdaa6b5aaecb1082d2f133f04a3987165c2db7f10c499073fb9bf41c170cda11ae04a41c6cb992dddefecb31a77c18421180a288820576e165aa5878c4c9031ccb98e2cc5ecf11d1f330d02e4711a08aae86c0276550b254a6b8c41ce21ad2364b02bbce44708f34a63a85b30b89630d7f3467b5615418b095e305a304a6fccda6896d1a465f3e733f6cc2a95ff0042028860c12f82970b498992a8aa6182b202c8a580639543bf88dc45644eea9e1104328b751a74edaa1f89d27cc5ccbaad3713d405c99a8f920f489294df2a47df4e828fa53fecc60856055aef12c50b5430b06cb641a6c114317ee63c5ecaff00e22dab76b142a14abf06a367d33701547ee65604728d26c09d1180e52c8aadf9089e29e12a2be6223bd6a352ae1cc8679840cd80073141f504220179e230cb2e9b3b117116c4b12cd705bf12a7b4a8f05f3ee64287269f551e296c96bb84e54f67a4f396c758e068cfffda000c03000001110211000010c7287de5e0253d46cbb942b4a281c11881c6a8984e2b3470dd1bf12369ad5a00395777a3e4c5258d73eb4af43a240e6e5a152b02efb4ba175c817dcb68562ee22085b381649819ee3472edffc4001d110101010101000301010000000000000001001121314151711061ffda0008010211013f1057a205f2f127bc0bee97772f108327790fa421d208c23a8203dbf23f826f64d839247da0b36cb39b126109eb28e168ec29e137a6d3f11a648725b7e43584a51be168632be48f8b160583588e4eacedc23fd58fe5acb32d747cdfad677597dc6ad98c17b9c4983597e0c40cec2b67f53b09f371fc7237970d23ad8c696e7201eda4bf56dbf26fc0473d9e6040349c581b65b676f2a4e0ef6d3132cb3fffc4002211010101010100020201050000000000000100112131415161817191a1b1d1f0ffda0008010111013f10f65b20eb7b63fcde216fa15d263f88fd4fee72e1084f98c05aa4fb2c9f4d95fbbbf326fa12fb8466da3297d4fbb2c65fa8fca7e7b317d90721204d8e9ea4708c7cce3d631e598cd89e902fb613b6290dd602d873a477d21227770846bb603fea02edc3ce4fe36fe65bdc9eb6e7b9ff007f5833f480ebe2173173e13836026e4a25db9e324581d8bd65278b8a3fb405b3c2c7d4af8b874f6e5901ae5bb966c10309002d091e253ec9c80fc40bf6baf23bd24d2696b6fecb2c8cc84dbd659ac1d3b6c9ffc4002610010002020202020301010003000000000111210031415161718191a1b1d1c1f020e1f1ffda0008010000013f10ff00c3cc39737d19e45ab0647b09c85545649e53a4f45f2f18ab5991b792808e1a26fa8a1ff4e76dc2d527b85b1f1eb158fa84118e27ce25c082412fcb2986c44b4a4fc81aff00d604003dc1fafce0607bcc3800ebad5e6d9701edf83ef1d079d1b77800258e93278329212a0462511713723f3ace58f72121132d3f8c9cd1115cf1698e0520e54d811b46e571b1222469493c58d7bc911920101809752c54c420e10d1f18a5f922080d46ede9c769d47a83ba7461bbd0a4b88f2be7240947836ea9855e1021460d4064c142a694de5c0a0454fbf5977adba835590527886a29b9dbd466a5924023cfde34cd0abf29fe6f2832256c1a159c2814bc363b7ce20c0390a7676f8c6eed1d3ccf070c114492e97a08e1c7b7a6b58a7b48de4c150425a3a372ac61155c036a5877e71c0322696a98624e7245883a2ea9d19deda8242486eef74643a4151083c8133e5714cbe481be12b778202f8041fbc445853a873091eb1c39002ca764fa64bce0a0edcc4d562225062cab4004a7eef242a10c8491881cbbea72610c4a91e638c695054565f264a212eba8afd5628a941483c6222d015471dc7ac9edac028ca122c789cb8e42343978bf59167fb491264e4f7d6f0c96e384db6add992b34a0e1604044bbcd41c316f62edc5d1c02c92c762b95001112533fac999c04d3bb80325e15eecf88c88901190b2992f786306126f66d08e0844519ac34113383d8152c36c2d7a9e7d63428312949f9ca26a8b1daf8c839b1351adfdf8c881a8051cfa1f18801106ba783204a1897938f8c2a0a480c8f323c6cc818dbabd430e135091440d1dc133192e06121887b619ac817205d49ab8e30daf7e684700237909b520100ba8c7c6486584a84d0b3c4983ea2dba0d499644764e7100ae69a6cc6cea3041ba052ec49af3923c410790a41fe64970d8a00a7d7ef2703816b0172d20241893bdfe32d0ee8b1f418fe398ab33c8eff0018a2a4505a761e714c9be1a6ae412379e01c7f05cb3a15dd702fb8c8a0370b03b3a225c96a645a87170ed7095772886d44830c9109280f1cfce0f7df354d7ac0e6483407305a878c0681490d7561038080a2747cb5be3d642834405513ca38e65c68d390930402c7c94635ca108c09617f558e04817c937591a0c21bd7307192a404ce0be7833618aba13d62d59d237ecd6411adb8b90ca3eb11ae0203b38273c64d7d5ad5f491a9c5c0d1d15e6ea4aa5c5969040236c05b8ad2aa8c8bb181e4de3f51a3ca7925229bf187278b01761411cfce2354ce8abfb446f069260800c744a35f3850d20307c9eb19497b22fe719b5299c83b10bf2de1d43c1cdad8721e300ba982d3626d0ef109886e13e86dc099f080958a669d24a09fbf3916f96112e02374859eb1ad48c29ab3c215ef27107120e8a53d464903aa442016f098a0c91bb888eb594fa52922354e3950eda4ea449f0c8e0f1393c20c4bf384cbb84124722cf7d654580085146e3c8ef085948820f0d78c9454302c554852f775892a6c1895fb3f98a52146752d889ffa7159212741bdbfad6001a6922f21d3ce522ea89f3b1d4e4555b29260386dfac1d6a88480e0661c34e0b04627507fb902a802aabe932cb6117374a85a1f8c12a4f3d3076246dc06c787206896a426c6f036216d93b071c645958525ea67de4902171c278bbc29b0e234d0274bae630812c2d0b0d2bff718bed2002dc808bf0e311a12c077627e706c353cab8994acfe324f7f48895a316f8f9c56ad2151e480bf9c07a4f49953275ac844204bc81ebe358e8f604bc2962e3596bc52d6e8800ebf5872ea90dccc2579b75182a09818f56d30ceb17148ca94504f2fb9c8c5254500a3e9803104dfb019a3893000b9cf07b22cc08e4828f5b5753900800a80dca6c7b9c54948806350d5f6733859e8a2042aad92e4ca709c02a457644de270630470a18589a272845ab6e480dbd28e058c59c292d428f8c1f854cca924a4f78db9f0541703475cf0e3b04ced1e7c0f4c8388a055d83627ff0032b9492aba92d8c5420b010b32845ee49ce3b2b8f822888c1ea8487401db803a260041db4b905b76b2e859c1624b4c8a083012d5e4b4922f0fae075aac282a15340480b1a8c64d501902d100f18b57ac8d083a3b6306a281d3b495f583e163060d943f2c6ae9d58049a035373842a693a25554e1b8d62aa59a00104afb58c74ad93647971788714b9118f1807f2cc0258f4cfac7c4fb811a2d6c5cd6f18f28583bd895f78d13624663e510318a84621266a048676c94c09fa3a0183371151e0460e729292050a3ac35b8835174ac97ac944efbca37b90f38e875257b09027cf39340aa8b51220efce445dc8269a435f7ce032e911dcbb38153db525d780f58805674129b4b87bbe72b5aa924262766fc560a9e277ca84a8e7152e96140ecb8c76bb61093c9dc44e0e3182464e5bb9586705a94482cdf8f9c8176126a3aa5e40fa136b3a6261ac8a3888b0ea25499558aac48ec2483db01ac42330a24e8268be5d65bb1ca1c024b2055a5e03310d1135096933fccd1f2da856c5a277ce1e4b40c33285d5edef20109cd6e43e28b431180a489380bdfac6be024807494beb20e9d1798686686f518baa01d43710ff98d0e70b29b98f96558a0495ec89832ed190917b31c7ea8e48bc0e0052900910234477d602054f7c895b8a9b0cd4224640c5b92883253fb6b4cbc4e058415f0a208877bf1818a8a17937a6a758688120c926cbc7b7782a0348a048110edee305339c053ed663bc7011702a3b9a98f392000996ddab68759a63f2d3433b7c07179b626108eb963f73934be40eee557de430d808f08d597ef130446d30ee10899f56e5a7475c11c188526220b3287b9f9c8b6ab06b2c9ac471e0cb44644dd15a4365c8e8f196856db6783a300c181358e98969d95900e198600a4a224fc9ac484843083c8b6cf58ce709d2ba41a086f8645e312a15c0cdff3070a91583e4603db19c2d65b4e60c877ac44f1f1aa1e5ae30619e12f062990f0de422122d3547003ce1b1a8e423d49d732e0a499507960816f71f1888dee08d8412c3def0ea0d01072c21f4611508ed8825f194304a13ce0e4f4dc17d6b1c906bc76a958b32e45861584dc1d62c8aa169ab7ecf1948c00f4c200a99035962b91124c203778214e4f9a6f21858834ea41c489faf9c8a00a190f5e5c406e46419d37f5eb111961892a54be9a4e30e5e0df4a2860138300ec0305ef97b3814104416fbc54168e6300202def249b5219010463d6445dd9f0700f11cb0a623ce56b2229ba0edef1d14651881e4531deaaa0442cd9c7bc9864a658cf3c143427abe72106828d7fdef2101bdabdb44fcb8ca0aa8806e8bfbe3240232268f2c95f6e2310d4083c598214d04c62ecda744ce458831153c3169f590bc304501a2b8c8508bcc1ac97e00e52606301cc64d0ceb218889ca3e5358a5c51ac26c4b0f1bc99ab34713ca61d3a4f05e04aa90c08a603c980090031e48c2156a09860a3ca98cbea5fc626a1d8e1193207249582d5703e7174889051ac0e8787156c0418a5b9e6b122314abf5afde54cdaed1e3536412e12258804d60a6af0835f58465a298af8c6b45dcee72ce80e35387b932f49c9e7056d334a5b1350ec73601820e6ae8fad464e8104b45d0718ac09a58041643def256599a03238d74e146bac066f576016746068e01407097da8255886701772e9c6953b14992b256d8207a7face1f1cba5f9ca6128a2b6ca539e17b64a54e5c6214819ba2300a11adeb13620c2cb604adf67195c20b0440f19488cd463e8bf80c0d2f3a44a92dfab707330d5238ebd61415c03b9bff007255e6b90085e90627470828178d0ef23d95523ce2b7c185b37126194f3bf1922682d01c0ed6562723aa82360eae75888930a20281e8c5d6486017920a89eb05fdcba8fea4d6048806d8217ccf79cb01a0989c44d0c8e9c0ac2bd62cc0500c3392590041de1c65c45a6bd2179627c6b2fc649e195221ececc5f820038da6963ac0945d27a2582ccf7266b2ff001af38f4511b07411279c05d40c9251152c3afce0f27daa948f449ce7000676d7f337107d475e273fffd9);
-- --------------------------------------------------------
--
-- Structure de la table `annonce`
--
CREATE TABLE `annonce` (
`ID_ANNONCE` bigint(20) NOT NULL,
`ID_ADMIN` bigint(20) DEFAULT NULL,
`ID_ENSEIGNANT` bigint(20) DEFAULT NULL,
`TITRE_ANNONCE` varchar(100) DEFAULT NULL,
`DATE_ANNONCE` datetime DEFAULT CURRENT_TIMESTAMP,
`ANNONCE` longtext,
`Destination` varchar(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Contenu de la table `annonce`
--
INSERT INTO `annonce` (`ID_ANNONCE`, `ID_ADMIN`, `ID_ENSEIGNANT`, `TITRE_ANNONCE`, `DATE_ANNONCE`, `ANNONCE`, `Destination`) VALUES
(1, 1, NULL, 'Annonce 1ère Année , 2ème année & 1ère Année Masters', '2017-06-20 00:00:00', '1ère année\npour que vous puissiez récupérer la convention de stage au titre de l\'année universitaire 2016-2017 vous devez:\n1- remettre la fiche de stage format papier stage (la signature et le cachet de l\'entreprise est obligatoire).\n2-remplir le formulaire en ligne\n2ème année & 1ère Année Master\npour que vous puissiez récupérer la convention de stage au titre de l\'année universitaire 2016-2017 vous devez:\n1-remplir le fiche de stage format papier , le sujet proposé par l\'entreprise doit être validé par le chef de filière & la remettre au service de stage (la signature et le cachet de l\'entreprise est obligatoire).\n2-remplir le formulaire en ligne', 'enseignant'),
(2, 1, NULL, 'Annonce Master IFGR 2ème année', '2017-06-22 14:18:13', 'les soutenances programmées aujourd\'hui (jeudi 22/06/2017) à\r\nL4 se dérouleront à Amphi A1\r\nL9 se dérouleront à la salle A3\r\nles soutenances programmées le vendredi 23/06/2017 à\r\nL9 se dérouleront à la salle A1', 'enseignant'),
(3, 2, NULL, 'ANNONCE 2ème ANNEE', '2017-06-21 14:19:54', 'les élèves ingénieurs de deuxième année sont priés de se présenter aux soutenances des projets créations des entreprises munis de deux copies de leurs fiches projets pour les deux membres de jury \r\n* A 9h si samedi n\'est pas le 1er jour du ramadan \r\n*A 10h si samedi est le 1er jour de ramadan', 'enseignant'),
(4, 1, NULL, 'Première année: Mobilité', '2017-06-22 14:21:31', 'les relevés de notes de la première année sont disponibles au service_scolarité.. \r\nles relevés de notes sont délivrés une seule fois. Donc les élèves doivent faire des photocopies légalisés pour les utiliser une autre fois.', 'enseignant'),
(7, NULL, 2, 'Formation en Finance Participative avec CIBAFI', '2017-06-23 03:55:18', 'L\'université Mohammed V de Rabat et l\'ENSIAS ont signé une convention de partenariat avec CIBAFI ( GENERAL COUNCIL FOR ISLAMIC BANKS AND FINANCIAL INSTITUTIONS) qui englobe les plus grandes institutions financières islamiques du monde.\r\n\r\nCIBAFI est une organisation internationale basée à...', 'etudiant'),
(8, NULL, 2, 'Conférence sur le thème "Energy and Smart Cities"', '2017-06-23 03:57:09', 'Conférence sur le thème "Energy and Smart Cities"', 'etudiant'),
(9, NULL, 2, 'Conférence sur le thème "Energy and Smart Cities"', '2017-06-23 04:00:06', 'Conférence sur le thème "Energy and Smart Cities"', 'etudiant'),
(10, NULL, 2, 'Conférence sur le thème "Energy and Smart Cities"', '2017-06-23 04:01:45', 'Conférence sur le thème "Energy and Smart Cities"', 'etudiant'),
(11, NULL, 2, 'The 3rd International Conference on Cloud Computing Technologies and Applications ', '2017-06-23 04:03:09', 'CloudTech?17 is the third edition of ?International Conference of Cloud Computing Technologies and Applications?. \r\nThis is one of the most successful IEEE TCS and IEEE Cloud ', 'etudiant'),
(12, NULL, 2, 'The 3rd International Conference on Cloud Computing Technologies and Applications ', '2017-06-23 04:04:27', 'CloudTech?17 is the third edition of ?International Conference of Cloud Computing Technologies and Applications?. \r\nThis is one of the most successful IEEE TCS and IEEE Cloud ', 'etudiant'),
(13, NULL, 2, 'The 3rd International Conference on Cloud Computing Technologies and Applications ', '2017-06-23 04:06:23', 'CloudTech?17 is the third edition of ?International Conference of Cloud Computing Technologies and Applications?. \r\nThis is one of the most successful IEEE TCS and IEEE Cloud ', 'etudiant'),
(14, NULL, 1, 'Marijuana products with littl', '2017-06-25 01:42:15', '\r\nØ£Ù?Ù?ا اÙ?Ù?Ù? Ù?سÙ?عÙ?Ù? خبار اÙ?Ø®Ù?رØ? Ù?Ù? خدÙ? ربÙ? Ù?اغادÙ?Ø´ Ù?ضÙ?عÙ? Ù? دÙ?Ù?ا دÙ?رÙ? Ù?باÙ?Ù?Ù?Ù? Ø£Ù? اÙ?Ø®Ù?ر Ù?Ù?Ù?ا اختارÙ? اÙ?Ù?Ù? \r\nثاÙ?Ù?ا Ø´Ù?ت بزاÙ? دÙ?اÙ? اÙ?Ù?اس تاÙ?سÙ?Ù?Ù? عÙ?Ù? اÙ?Ù?دارس Ù? Ø´Ù?Ù?Ù? Ù?Ù? ØسÙ?Ø? Ù?صÙ?ØØ© Ù?Ù?Ù? أشرÙ?Ø© Ù?Ù?Ù?رة اÙ?Ù?Ù?Ù?Ù?Ù? "on compare pas l incomparable "Ø? راÙ? Ù?ا Ù?اÙ?Ù?Ù?Ù?Ø´ تÙ?Ù?Ù?بارÙ? ! عÙ?اش Ø? Ø£Ù?Ù?ا Ù?Ù?Ù?ا Ù?Øدة Ù? Ù?Ù? Ù?Ù?Ù?Ù?اغ Ù?Ù? Ù?Ù?Ù?اØ? ثاÙ?Ù?ا Ù?Ù?Ù?ا Ù?درسة Ù? Ù?اش تابعةØ? Ù?عطÙ?Ù?Ù?Ù? Ù?ثاÙ? : ensem تابعة Ù?Ù?جاÙ?عةØ? ehtp تابعة Ù?Ù?زارة اÙ?Ù?Ù?Ù? Ù? اÙ?تجÙ?Ù?ز Ù? بÙ?اÙ?سÙ?غ راÙ? Ù?اشÙ? Ù?Ù?', 'etudiant'),
(15, 1, NULL, 'bonjour', '2017-06-08 09:33:46', 'hello mes amis', 'enseignant'),
(16, 1, NULL, 'lalala', '2017-06-15 13:35:44', 'aaaaaaaaaaaaa', 'enseignant'),
(17, 1, NULL, 'ddddddddddddddddddddddd', '2017-06-02 16:40:10', 'ddddddddddddddzzzzzzzzzzz', 'enseignant'),
(18, NULL, 7, '15487', '2017-06-25 07:40:02', '134587', 'etudiant'),
(19, NULL, 2, '123', '2017-06-25 08:02:31', '321', 'etudiant'),
(20, 1, NULL, 'bonjour les etudiants', '2017-06-22 09:25:31', 'hiiiiiiiiiii', 'etudiant'),
(21, 1, NULL, '<p>azertyuiop</p>', '2017-06-30 00:46:46', NULL, 'enseignant'),
(22, 1, NULL, 'zedfygh', '2017-06-30 00:47:41', NULL, 'enseignant'),
(23, 1, NULL, 'annonces', '2017-06-30 00:48:09', NULL, 'enseignant'),
(24, 1, NULL, 'hello', '2017-06-30 00:49:54', 'word', 'enseignant'),
(25, 1, NULL, 'saaaalama les etuiants', '2017-06-30 00:58:48', 'l\'annonce pour vous', 'etudiant'),
(26, NULL, 21, 'titre', '2017-06-30 01:10:55', 'annonces', 'etudiant'),
(27, NULL, 19, 'fdddd', '2017-06-30 02:02:12', 'fvvfdgfd', 'etudiant'),
(28, NULL, 19, 'Planning des soutenances', '2017-06-30 04:41:49', ' Planning des Soutenances des PFAs de la Première Année\r\nFilière Ingénierie du Web et Informatique Mobile\r\nAnnée : 2016 - 2017', 'etudiant');
-- --------------------------------------------------------
--
-- Structure de la table `compte`
--
CREATE TABLE `compte` (
`ID_COMPTE` bigint(20) NOT NULL,
`ID_ENSEIGNANT` bigint(20) DEFAULT NULL,
`CNE` bigint(20) DEFAULT NULL,
`ID_ADMIN` bigint(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Contenu de la table `compte`
--
INSERT INTO `compte` (`ID_COMPTE`, `ID_ENSEIGNANT`, `CNE`, `ID_ADMIN`) VALUES
(1, 1, NULL, NULL),
(2, 2, NULL, NULL);
-- --------------------------------------------------------
--
-- Structure de la table `contact_us`
--
CREATE TABLE `contact_us` (
`ID_CONTACT` int(11) NOT NULL,
`EMAIL` varchar(50) DEFAULT NULL,
`NOM_CONTACTER` varchar(255) DEFAULT NULL,
`DESCRIPTION_` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Structure de la table `emplois_du_temps`
--
CREATE TABLE `emplois_du_temps` (
`ID_EMPLOIS` bigint(20) NOT NULL,
`ID_ADMIN` bigint(20) NOT NULL,
`ID_FILIERE` bigint(20) NOT NULL,
`NUM_SEMAINE` int(11) DEFAULT NULL,
`FICHIER_EMPLOIS` varchar(40) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Structure de la table `enseignant`
--
CREATE TABLE `enseignant` (
`ID_ENSEIGNANT` bigint(20) NOT NULL,
`NOM_ENSEIGNANT` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`PRENOM_ENSEIGNANT` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`DATE_DE_NAISSANCE` date DEFAULT NULL,
`EMAIL_ENSEIGNANT` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`MDP_ENSEIGNANT` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`DEPARTEMENT_ENSEIGNANT` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`TEL_ENSEIGNANT` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`ADRESSE_ENSEIGNANT` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`SPECIALITE_ENSEIGNANT` text CHARACTER SET utf8 COLLATE utf8_bin,
`PHOTO_ENSEIGNANT` blob
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Contenu de la table `enseignant`
--
INSERT INTO `enseignant` (`ID_ENSEIGNANT`, `NOM_ENSEIGNANT`, `PRENOM_ENSEIGNANT`, `DATE_DE_NAISSANCE`, `EMAIL_ENSEIGNANT`, `MDP_ENSEIGNANT`, `DEPARTEMENT_ENSEIGNANT`, `TEL_ENSEIGNANT`, `ADRESSE_ENSEIGNANT`, `SPECIALITE_ENSEIGNANT`, `PHOTO_ENSEIGNANT`) VALUES
(19, 'Rachad', 'taoufik', '1976-12-12', '[email protected]', '80712808d296312e9c97b84c78f711d1', 'Web and Mobile Engineering', '0645124587', 'casablanca', 'java ee,android', 0xffd8ffe000104a46494600010100000100010000ffdb0084000906070f0f0f0d0f0d0d0d0d0d0d0d0d0d0d0d0d0d0f0f0d0e101511161615151515181d2820181a251b151521312126292b2e2e2e171f3338332d37282d2e2b010a0a0a0d0d0e150f0f152b1d151e302d2e2e2b332d2b2b332d2d2b2b2b2e2d372b37372b2b37322d2f2b2c2b372b2b2b2b2e37372f2d2d2b372b2b372b2b2e37ffc000110800ae012203012200021101031101ffc4001c0000020301010101000000000000000000000102030406070508ffc4003f10000201030104070505060505000000000001020304112105123141061351617181912232a1c1d1074252b1f01423628292e1246372b2c233435354a2ffc4001801010101010100000000000000000000000001020403ffc40020110101000202010501000000000000000000010211032112314171a1f022ffda000c03010002110311003f00fb089a2b4c922a2d44915a64d3089a268ad326809a268822680922488a24809224848680634086000806000030000001800c0403001012002222420100c008889080889a24202245a26c4043003003e2264d32b4c920ab532516569928b08b53268a932680b51345689a02689a2089a02689222892018c0600003000180000c0000600000301000000b0300108908042636201086201322c90981118001cfa64932b4c926156a64932a4c9a605b16591653165916545c99389544b2205a89a2b893881622488a2c4402180c00621e0006200044840806322301800640004003100c04031008436201098c4021606260200181cca64932a4c9a6156264d32b4c9202d4cb22ca62cb62ca8ba2591653165b102d89644aa25880b116265689a2092242430180186eb6d5a5193856bab7a53493709d58466b3aacace40de0627b5adf09aaaa4a5aa94232947d522db5bfa3572a955a751c7de8c669ca3e2b8a0348019eb5f5183c4eac14bf0ef272f45a81a0119e95dc25eeb94b1abc53a9a2ed7a685d42b4269b84a3349eeb7192787d8f1c1f7016605824200c0600003021800843100112420220362022c4484047203003954c926569924156a64932b4c9a02d8b2c8b29896c4a2e896c4a625b108ba25912a896c40b11344224e204d0c43210d1c9ed5e8dd296d4b5bca9edc26a719529e1c3af853fddb4bfd2a6f5e70475657756f1ab0709e7194d38bc4a324f31945f269ea15289f23a616f09d955924e3770dc5675a0dc2b46b4a718c2319ad565b49ae699b55bdcad235e8c972752de5bfe6e3349bf04874f67ca53854af57ad9536dd38461d5d1a72c35bca396dcb0dacb6f19d30547c3a7b16ada50a2a57b715d75d0fdae539b527bf1ea9b8cfde504e4a586df0ce743a7b5a50a78518a8c1728ac12a94d4938c9294649c6516b29a6b0d33253b6ad4d28d3ab09c169155e129544bb37d4967cd67b5b03ec5fca0a1393f6553839c64f470924f0d3e4cf9f469adfb8adaef5d56ebe69f04fab85358eedd847d595dc50a95b0abce1d5a69ba74a128a93fe26e4f2bbb08d4467196188061a200000000010000084c6201086c40210d880400007229934cad32482ad4c9c5952269816a65916548b22517c0b605312e8845d12c89544b6205912c45712c881319144880188614d1210c2180860031000000000000000000080004218804218804c4c6c402000038e44d15264d30ab62c9a6549938b02d896c594c59645946889740cf065d06117c596c5944597440b62588aa2cb22c0b11244132488248688956c8b9fda6f2e2da9acab5b7eb2acfb6acfdc82f2cb6fc176856800008631000c0d5b3edbac93caf6145ef72e29a4bf5d8737d1eda7d6f5d42acd4abdb549d36db5bd520a4d29f7bd30ffb81f6804300000001000008620010080400002130130000003894c9a6549934c2ad4cb22ca53271605d165b1651165b1651a20cba0ccd165d0611a22cb62ca20cb62c0be2cb22ccd3ab182729ca308ae3293518af16cf85b43a6b674b2a1295c4d72a4bd8fea7a7a640ea5328bcda14682deaf5a9d25cb7e6937e0b8b3cd36a74deeeb6634b76da0fff001eb51ff3be1e491cdce52a926e5294a4f59ce4db97abe634ba7a16dde9fd351942c14aa54795d7ce3bb4e1df18bd64fc525e3c0fa5f62b71277174a72729d6a2eace527994a4aa472dbedf6d9e5aa9fe91e8ff00638f17d8fc56d597ff00507f203d3b6becd6dba94d673ace0b8f8a3e31d9b397e97de5ad9c2156bd48d2955a8a1059599be6f1d896af1f16d232321a6cace755e23a457bd37c17d5f7147452f2d2ff00ad952abd67513519c30e0f0d654b5d5c5ebaf733afa7051494524970496122a32d48c2de854970852a73a9293e2f762db6fd0fcf55ee2a42aaad094a1573bdbc9e1a93e3f99ec9f69bb4fa8b09c53c4ae671a0bb777de97c163ccf1bb959e1aac698d5162ba9d99d3ac28c6ea936f44ead26b5ef707f27e474f61b66dabe152ad0727f725eccff00a5eafc8f28953ca6b879f308670bb868d3d980f30b0e915d50d2359ce2bee55f6e3e59d57933a3b1e9ad37855e94a0f9ca9fb51f47aaf88d269d60192c76951aeb346ac67db14f135e317a9a88010c40020100086201098c40002003854c9a6509934c34be2c9a914265916117c596c199e2cb22ca34c5974199a2cb62c0cbb6b6dd3b48c1ce2e73a8da84134b45c5b7c970f5391bfe99dd5478a5bb6f1e4a294a7e727f248b3a7727d7d259d1514d7f5cbe9f03999c7127ebeba81a2f2fab5769d6ab52ab5c37e4da5e0b914a418e048a235278cbec3550a188acaf69fb52f17f431c927c787a1a2d77f9c9b83ceea92f6fd7b3c40955928f8f61db7d91d7c6d0a397efc6ac3d69b7f2382b86753f6735651bcb770599a9bdd8e71bd270924bd70bcc51fa16e2bc69c2752a3dd8538b949f6248fcddd23e9455da7b4655a51c528b74adade5ac61497e2fe27ac9be59e3a23dfb6e2752daabc34a5464d45e8f2e3cfbcfccf6f6f9a9522e5d5a8b7bd369bde7ca092e3face861ac71dbb0d85b4e7657746e2ca9cee1acfed34a197fb8d1d48f7a4bda527a662bbcf79b2baa75a9d3ad464a74aac14e125c1a6799fd87d2a12a77d26e33ba5529d39c5ebb96ee398e3b9c94f3fe9477161b39d954a8a93ff05564ea2a5ffad51e5c9c7f81f6727af68d59d25f8d3cf7ed86ff007aeadedd3ffa5477e4976d497d21f138a82496a6ae91ed3779b42eebaf7655650a6b9a843d88faa59fe633c97ebbcd4449413e0f890eaf5234e59ce1ac6712c3e6b93ec3441706bf5f028cd28e3d07bbf22e93d787c454e20420b0fe28fa96dd21baa2e318d5734db4a3556fc525c78eabd7b0c50a7a908453a937a629c543f99eafe5e80779d1bdb6ee54e9d54956a7afb3a4671ce338e4d7cd1f70f3ce8a56c5e51c3f7d548beff61fcd23d089402002210862602131b130100001e7c9934ca5324a41a5ea4591919d3271904698c8b62ccb191742406a8b2d8b32c645d1914711d32abbd7725f8295387c1cbfe47c8aab583fc50f8a78fa1a76f54dfbab879ffbb28ff4fb3ff128aabf7709764dc7d57f645106c8a7a9197108b0149e2706fdddec3eccbd13f5c1ba6f4324e1bd16b9be0fb1f234519ef413ed5af8f34065abccfbdd09b8eaeeede59f76bd17e4a713e0d5366c39b55161b4f93ec7c80fd1dd30bd56f637155fdca52c78e3ea7e6355db6fbdb7ea7b17db66dec595ad1a6d7f8c92a8d76d38c549fc6513c8ec6df094a5c249eebec6b8e7b1feb9a24be3dbd38f8f2e4ba8e9becc36bbb3da76ee5271a770ff0064aa9e7189b5b8df84f735ef7da7bbf4a6f3a8b3baaafee529b5e38d0fcc75d383df4da94758b5a3525aafd723dabed376f467b2a96e3c4af55b4963f0ce0a65cfbee3d79f098dc64f57976cc86539736cd5538f869de16b4b720976ae246b3ece5f00e650e9625bd1d24f49e384d73cfd4dd18e8bc7267a6f5f234bf102b92795e2594a2f5d3f22b6f57e4cd31f1088f0d5e896be064b493eab7df1a9295479ef79fc89ed6ab8a5517392505fccf77e60e38a708e392415afa353c5e5b77cdaf3717f53d2cf2bd8ba5dda3ff3e9fe783d4c9431008880431360210080064402bce1489c599d489c585688c89c64678c8b130344645b19196322d8c82354645d19e35ecd4c91646faab8d1af25c551a8d78eeb0380ad537a7293fbd2949f9bcfccd1bb9a157f8529af266367d0b48e61513e716bcb0695f362f2cb1196d259f44cd880927c3c474b4735dea4bc1f1f8ffb8867527534dc9764945f7a93c7e78f408855892b19eed45e23aa8aa1a4901f77a63b45dcd4b45296636d65468a4ff1eae5f0dd3e7d1aaa39cacc5e37a39e3d8d3e52ecf8f11ed15ed2970cd38c9f3e0bfb230424e524bb5e173c0f0f28eff39c1c78e53d6fefa6aab49c9a49e638cc658c2ddf0edee3ecdf6d295c4367d0cb71b5a14e0f3db182867d22514231a546539454e1bdbb08ff009984f7df7631a73e7c35c5d1c6e6ead49bccb7e7abf1318e5bebda38f296ff0076f7976fbf9c2f033496ba799a26f433c4db0be8478be78ef2f92e1f42aa1aad7f5c0bb0b545457bbc3873f91749e05a2edd3e842e24b5e3cbf2441f37694f7a54e18e334df82fd236577c16bc3b4f9c9ef5759fbb158f37fd91bae25c0296cdaaa1716f27c215a937e0a6b27ab9e36df1f33d7ad6a6fd3a727c670849f9c53251680099103626020109b0620a0059003fffd9),
(3, 'BENADADA', 'Youssef', '1977-05-11', '[email protected]', 'YoussefBENADADA', 'Web and Mobile Engineering', '', '', '', NULL),
(4, 'EL KOUTBI', 'Mohammed ', '1967-06-07', '[email protected]', 'Mohammed EL KOUTBI', 'Web and Mobile Engineering', '', '', '', NULL),
(5, 'BERBIA', ' Hassan', '1989-04-18', ' [email protected]', ' Hassan BERBIA', 'Web and Mobile Engineering', '', '', '', NULL),
(6, 'EL BAKKALI', 'Hanane ', '1998-06-30', '[email protected]', 'Hanane EL BAKKALI', 'Web and Mobile Engineering', '', '', '', NULL),
(7, 'EL BAKKALI', 'Hanane ', '1998-06-30', '[email protected]', 'Hanane', 'Réseaux de Communication', '0641254879', 'ensias', 'matlab', 0x89504e470d0a1a0a0000000d4948445200000099000000990802000000b33e0fed000000097048597300000b1300000b1301009a9c1800000a4f6943435050686f746f73686f70204943432070726f66696c65000078da9d53675453e9163df7def4424b8880944b6f5215082052428b801491262a2109104a8821a1d91551c1114545041bc8a088038e8e808c15512c0c8a0ad807e421a28e83a3888acafbe17ba36bd6bcf7e6cdfeb5d73ee7acf39db3cf07c0080c9648335135800ca9421e11e083c7c4c6e1e42e40810a2470001008b3642173fd230100f87e3c3c2b22c007be000178d30b0800c04d9bc0301c87ff0fea42995c01808401c07491384b08801400407a8e42a600404601809d98265300a0040060cb6362e300502d0060277fe6d300809df8997b01005b94211501a09100201365884400683b00accf568a450058300014664bc43900d82d00304957664800b0b700c0ce100bb200080c00305188852900047b0060c8232378008499001446f2573cf12bae10e72a00007899b23cb9243945815b082d710757572e1e28ce49172b14366102619a402ec27999193281340fe0f3cc0000a0911511e083f3fd78ce0eaecece368eb60e5f2deabf06ff226262e3fee5cfab70400000e1747ed1fe2c2fb31a803b06806dfea225ee04685e0ba075f78b66b20f40b500a0e9da57f370f87e3c3c45a190b9d9d9e5e4e4d84ac4425b61ca577dfe67c25fc057fd6cf97e3cfcf7f5e0bee22481325d814704f8e0c2ccf44ca51ccf92098462dce68f47fcb70bfffc1dd322c44962b9582a14e35112718e449a8cf332a52289429229c525d2ff64e2df2cfb033edf3500b06a3e017b912da85d6303f64b27105874c0e2f70000f2bb6fc1d4280803806883e1cf77ffef3ffd47a02500806649927100005e44242e54cab33fc708000044a0812ab0411bf4c1182cc0061cc105dcc10bfc6036844224c4c24210420a64801c726029ac82422886cdb01d2a602fd4401d34c051688693700e2ec255b80e3d700ffa61089ec128bc81090441c808136121da8801628a58238e08179985f821c14804128b2420c9881451224b91354831528a542055481df23d720239875c46ba913bc8003282fc86bc47319481b2513dd40cb543b9a8371a8446a20bd06474319a8f16a09bd072b41a3d8c36a1e7d0ab680fda8f3e43c730c0e8180733c46c302ec6c342b1382c099363cbb122ac0cabc61ab056ac03bb89f563cfb17704128145c0093604774220611e4148584c584ed848a8201c243411da093709038451c2272293a84bb426ba11f9c4186232318758482c23d6128f132f107b8843c437241289433227b9900249b1a454d212d246d26e5223e92ca99b34481a2393c9da646bb20739942c202bc885e49de4c3e433e41be421f25b0a9d624071a4f853e22852ca6a4a19e510e534e5066598324155a39a52dda8a15411358f5a42ada1b652af5187a81334759a39cd8316494ba5ada295d31a681768f769afe874ba11dd951e4e97d057d2cbe947e897e803f4770c0d861583c7886728199b18071867197718af984ca619d38b19c754303731eb98e7990f996f55582ab62a7c1591ca0a954a9526951b2a2f54a9aaa6aadeaa0b55f355cb548fa95e537dae46553353e3a909d496ab55aa9d50eb531b5367a93ba887aa67a86f543fa47e59fd890659c34cc34f43a451a0b15fe3bcc6200b6319b3782c216b0dab86758135c426b1cdd97c762abb98fd1dbb8b3daaa9a13943334a3357b352f394663f07e39871f89c744e09e728a797f37e8ade14ef29e2291ba6344cb931655c6baa96979658ab48ab51ab47ebbd36aeeda79da6bd45bb59fb810e41c74a275c2747678fce059de753d953dda70aa7164d3d3af5ae2eaa6ba51ba1bb4477bf6ea7ee989ebe5e809e4c6fa7de79bde7fa1c7d2ffd54fd6dfaa7f5470c5806b30c2406db0cce183cc535716f3c1d2fc7dbf151435dc34043a561956197e18491b9d13ca3d5468d460f8c69c65ce324e36dc66dc6a326062621264b4dea4dee9a524db9a629a63b4c3b4cc7cdcccda2cdd699359b3d31d732e79be79bd79bdfb7605a785a2cb6a8b6b86549b2e45aa659eeb6bc6e855a3959a558555a5db346ad9dad25d6bbadbba711a7b94e934eab9ed667c3b0f1b6c9b6a9b719b0e5d806dbaeb66db67d6167621767b7c5aec3ee93bd937dba7d8dfd3d070d87d90eab1d5a1d7e73b472143a563ade9ace9cee3f7dc5f496e92f6758cf10cfd833e3b613cb29c4699d539bd347671767b97383f3888b894b82cb2e973e2e9b1bc6ddc8bde44a74f5715de17ad2f59d9bb39bc2eda8dbafee36ee69ee87dc9fcc349f299e593373d0c3c843e051e5d13f0b9f95306bdfac7e4f434f8167b5e7232f632f9157add7b0b7a577aaf761ef173ef63e729fe33ee33c37de32de595fcc37c0b7c8b7cb4fc36f9e5f85df437f23ff64ff7affd100a78025016703898141815b02fbf87a7c21bf8e3f3adb65f6b2d9ed418ca0b94115418f82ad82e5c1ad2168c8ec90ad21f7e798ce91ce690e85507ee8d6d00761e6618bc37e0c2785878557863f8e7088581ad131973577d1dc4373df44fa449644de9b67314f39af2d4a352a3eaa2e6a3cda37ba34ba3fc62e6659ccd5589d58496c4b1c392e2aae366e6cbedffcedf387e29de20be37b17982fc85d7079a1cec2f485a716a92e122c3a96404c884e3894f041102aa8168c25f21377258e0a79c21dc267222fd136d188d8435c2a1e4ef2482a4d7a92ec91bc357924c533a52ce5b98427a990bc4c0d4cdd9b3a9e169a76206d323d3abd31839291907142aa214d93b667ea67e66676cbac6585b2fec56e8bb72f1e9507c96bb390ac05592d0ab642a6e8545a28d72a07b267655766bfcd89ca3996ab9e2bcdedccb3cadb90379cef9fffed12c212e192b6a5864b572d1d58e6bdac6a39b23c7179db0ae315052b865606ac3cb88ab62a6dd54fabed5797ae7ebd267a4d6b815ec1ca82c1b5016beb0b550ae5857debdcd7ed5d4f582f59dfb561fa869d1b3e15898aae14db1797157fd828dc78e51b876fcabf99dc94b4a9abc4b964cf66d266e9e6de2d9e5b0e96aa97e6970e6e0dd9dab40ddf56b4edf5f645db2f97cd28dbbb83b643b9a3bf3cb8bc65a7c9cecd3b3f54a454f454fa5436eed2ddb561d7f86ed1ee1b7bbcf634ecd5db5bbcf7fd3ec9bedb5501554dd566d565fb49fbb3f73fae89aae9f896fb6d5dad4e6d71edc703d203fd07230eb6d7b9d4d51dd23d54528fd62beb470ec71fbefe9def772d0d360d558d9cc6e223704479e4e9f709dff71e0d3ada768c7bace107d31f761d671d2f6a429af29a469b539afb5b625bba4fcc3ed1d6eade7afc47db1f0f9c343c59794af354c969dae982d39367f2cf8c9d959d7d7e2ef9dc60dba2b67be763cedf6a0f6fefba1074e1d245ff8be73bbc3bce5cf2b874f2b2dbe51357b8579aaf3a5f6dea74ea3cfe93d34fc7bb9cbb9aaeb95c6bb9ee7abdb57b66f7e91b9e37ceddf4bd79f116ffd6d59e393dddbdf37a6ff7c5f7f5df16dd7e7227fdcecbbbd97727eeadbc4fbc5ff440ed41d943dd87d53f5bfedcd8efdc7f6ac077a0f3d1dc47f7068583cffe91f58f0f43058f998fcb860d86eb9e383e3939e23f72fde9fca743cf64cf269e17fea2fecbae17162f7ef8d5ebd7ced198d1a197f29793bf6d7ca5fdeac0eb19afdbc6c2c61ebec97833315ef456fbedc177dc771defa3df0f4fe47c207f28ff68f9b1f553d0a7fb93199393ff040398f3fc63332ddb000000206348524d00007a25000080830000f9ff000080e9000075300000ea6000003a980000176f925fc54600000f904944415478daec9d498c1c6715c76be97ddfa667b3dd637bc61367bc4e8c9dd87176212b801411092148b820218e4870441cc2890b425c1012128a224080c4a21c1220095948943860c799d8e37556f7787a96def7eaaee264e9fb5560681f90107aeff69feea9faaa5ed7573fbdf7bef7e947671fd6145b5c5c52a561e8aa9c1c3254f9d8ec01559e3832adca43f74fa9b25aaeab72637d4b95a1405095c71e7a04c3d070deebe7ffa6cafcf20d551efddc33aa8ca533aa6cd61b90a5a22a4daf579561feefe2c71fa9f2f65a5e9597e7e65459d343aa6cd44aaa2cb47063dfbd705b95b66dab52736c2a47950f9e3a71f72e89fdbf98f8527c2926be14fbef9967717179878f7d1e13583135a2cadcae21550e85f0cbb8f4fa6baaf47bf0b69f9802284d1c39aacad49e1c58a0dd52e5e1cfccaa723c1356e5d2bbafaa32fdc5e754d96bd47081495cc2e63ce8263a9c0519f5308c6818bc96880449281e55b67b51558ef8bbaa0c06c05ccd263e25eb6854daf90f2fc8732973ac98f8524c7c293630fb9826e8c643e76663d047eedfafcad1005ed16ffef115558ec511f838fbc469554e9e38010619439048f781054c0e2bec9950652016c7cfd38b2fe73fb90814da771f38a2af9150106129dc42442993db8b2fdf9807fbc441375b8b8bf8df2cfef7faf59baa8c919bba1646d5ebe13ef71915d24d439e4b9963c5c49762e24bb181d9c7e74578c2a4730fee43e0630c6f776d6311499f04e3200f3f0ad8993a4ed8c98ce2581c86e6f4b47f8f283a51c8134daa7268f2902a9bcb0bc08a16526f9e3ea228b16104b6d617c03e871e791c43d62eabd21f8aa832954aabb2da46ae2d938c81c86a4d556e571060d20dfa48e3dd30847d648e15135f8a892fc506671f43873b2361bf2acf3c80708c555a51653882b77d2e9e50e5c82e7084278c2f6b3a52605a7f27d8d11ce67918f8709805f2f8400a410f64bdd501b0f4206351d0dded0e18c4ee7354e4a64c06b06311764aeb658c0a712ded402ea5caa5b52a2ed0461ca8ef7a1cefd664c9732973ac98f8524c7c293600fb9826d06057162fffe11028c3ae23f93232b64b9549728469826e1c7284d3ed9084f86566e234029a1b945c48c29891ab6469fb4e4195fba62755d9dadac4dd2137950b6b00a5a1619cb684eaed28536f99484095f902e82615c489925144d0362c5ea0ee907d4c792e658e15135f8a892fc506661f0f934d872711acf1f6012c5d2efb8a304a12a8033a9c3ea215561b691d6f13eb9e8c3eea95357f80c34434ca15f7d1ec1ec9009f7a7981fd26c231f57a8dd78b43f9435cab55c1a2b04402b936a380b55a413fc69c1bc305d61bb81b6b1bb81bc3299cb75c072776ba7c1c25ee2373ac98f8524c7c29760fece3655864721c75c3f1705b95b50e098594e1fa65f42d84271c8da11cd7e225570accf52373e5bc3c3e7e1774a3dbf85faf89708cd7c0a1f25750093d7dfc41559a2b4b808e2680c51cdba3cab01fa3da36c03e1e46c1a6f7ef56658a509989e35e2dde01a0f5fbf6bfbc75f25cca1c2b26be14135f8a0dc03ed964983483c047288cf84bbd8ad7bb2fca055616031226833506dee7bae9e21716c03013a769fa4e28e442305255a78ee266ad077e693251556d563028761d6a3348e40b223ad3f1e18a86471041bb7d671dfc52c3899223586adf6071506e1401a6ebcb48cc9952eb2c73ac98f8524c7c29760fece3ca79c5a37e22089c6d30e0522ce07d3e3182a63cb526725e4e05d0e118e0083f69c67085815c2864bb6a8ec16bf9b97fa8f2da85f75419dc83b5e686c182261e2a9cc232b756b9c04199a437dc9c988fed7e6e21d756db46bd4f248af8da5022c6430185fccca659bd9e3c9732c78a892fc5c4976203b34f24c017b8c184110b76fd01bcdebd0c7c2cb11b8eabe065fbc30f5459aea3922895c622a9538fa3db747a027d85cc10e220bdca1d550674d4cedc5edb56e501f6f7094441199512884c27bfc447268033b66be53d00cdcb24578890a58f61897fb805302cf970db4fcd002a4b2d1416ad179bf25cca1c2b26be14135f8a0dcc3e06432aad2e5ed14116fb6a363822358a17f8fc47a89da927d1b979b5871cd0f90a923eb3497c5a7cf90d553e710e21a4dd271e03835800879e1ff9a34c14470e31cee58b22e5d7aa829b761dc725ac5f7c07cf817918c3e09d75e5e54201965cdb00c3561d55d4cd06bc30c45e028f1e1b53e5fb7379792e658e15135f8a892fc506661fdbc21aa2661dc9974e07f53e8120ded8be10c0c18861f7ab3a9b0a8e8c6135f9d7cf9c54e56818e1a77a11cc55a9927d8209559a619c37ec813cfddc3e555a3d5c60630bfd956d0d819e901fa38a9004ade22a2e3f8a1e3d3d2e28f30703644e32978de4daefcfa38fd2e4307cb46b086556678ee7e4b99439564c7c2926be141b987db249962fb3b1b363e28d6dda5dbede51469cbbef7e55ce1e46e4a3ab13a3b8034428895e39dee8319ca882c222dd83431961a050c883413a3e9082d54456cb69b2d45b63b99305508ac471a85e0774d3aab219b3c9236790b6eb07906b7bf3f2bbaabcb9814b98bbcdfc6018b77ddf70409e4b9963c5c49762e24bb181d9271044a4c3c38dcc4d57c12e5757f7eadb4403a4c05c4d6a7c69acea76bc31920299ab8f977fcbe35ae745c9ce8786dde635e212742f979bb166a7dfc0122a9b0d9583514056ab0d8ceab066c7e2258ccf604b0f7f162894bc84cdbfea1dc47dbaec16b0dcc205e64b1d792e658e15135f8a892fc506669f6a0b1ce10b00586c07a4d0371070f112587456f7da2d84454c16c4e826f7a5e026167d66a65ccbaf34e6e9741f222c7663035f6e03d05c1b51e88cec580d2cbfaa155186939e419eaebd8136cfb55299e7c1adab96504964552fa9729b27ca2651e0b3b65527af1104e5b99439564c7c2926be14bb07f609b384c7cb86ca5d07b2d5776dafeee5978115db792cbff2849030f2a32847d35972ad6b08b8f882eca9e8ee838861e89456a34854e0cf973194ea16dafd942a808eba0e2409719b8ad21d2cbf72d8c0e895377ea2cae51618b3cdfbbc7f0427dae4d6a63d3630d2ef6e7121cfa5ccb162e24b31f1a5d800ec3336820a5dd736153d2f5ec246042bd16b2d046bc20930c92a5bd8f80248ebc4d95f39c07d50752eb5afe76f01d0fa88283916d060fd1ab6571f3d7a920806d673a2c83dc572e3aaacfcfd4fb85b6d1059bd876854974d14bd11b0dec41860efe6f5261d8143cdaf229b363d0e2fac6ce27a9b1d4b9e4b9963c5c49762e24bb181d9c7d586a6c67da6c6725824d5d441464132483280e0c5951aaba85751c3e2b03160cac0cbdf08e06d5fde46deaa9c0746a5b3c08ae143477185095451bb364df5b5014ae929946bef99fdb62aad2668aeba02222b2c010c1b0da0d078162bef8d9ba8062a7151bb8737a750746500819c1e53f6329539564c7c2926be141b9c7d58fea2d5ab883874b90169d382ef7d0ee866970f2195b2172c70891ba87b03cc8879b98968126bbe93a3e868e30b4ee150fc4106c68f00b2589fddac00a3965751b373fdd7bf55e599e79e57e5e8434f91b9b09fd7a309047a3e7eeb2da0500b354a0718caf978159f36badc9683d271f7c096e752e65831f1a598f8526c70f6f1eb808eab8b6839981a41b1ccdafa26e9063f85c9692e196335d06b2b20a3bd43886504b7cbaa0cf510f808e880acfe1230ca8922b273ede51fabf2ca3a77ce1a42e8aad501ebd53a08a9fcf2073f52e557be8ba2a4d1534fa832ba7f5695331de0cceae52baa4cac20ee339a4434ea729edd1a59e0e3daf0c376642f539963c5c49762e24bb1c1d9a75044de6a3e0f148a5e4358646d13a4100be2253cbc822c4f97e5300b801bed9322c8289de2960f35ac8afac5cfffaaca8b37b092ab1346ddf097bff6ac2a9ffd0e6470186d9eb518024ceb57e65479e1d55754f99b1fa25ef91bdf678ba2fd0fa8d2cbadd913236800b03b8df4d9c2261833c8e6d3d51e6e4e97abde4c43d847e65831f1a598f8526c60d3cf9efd82aadb5c4c1e0b21e0a2732ff6540ca19c0cb7846f74f1f2ffe4169650051833fade39e48072433854f9067a1b1ef023d063e70ea8b25801565cfde075558ecc205175f8dc6731aafda815d2d8df67e16da05030854cdce82cf6206b5c7b5f9585dbe0b56a15c8f9c2af2ea8d2b1013bab650ca3d345cc48979c97ccb162e24b31f1a5d8e0e6a970ad96c3b681b6864fbd260b4f0c8427cab5b22a7b5c4dae73657a93352c2f7e8014d8b79e42d974781f82352b3797543956018205bbe0b7cc7d20232d8b7d50df7ae945559e7cf64baa4c1e3a05229b39a8cafc2d3612626191ce6ddd5775543f2586116f7afe0ce26b2fbd8362a8849ff5e83a6ebba94bdc47e65831f1a598f8526c70f6e9b9ded8f4ae6b7fce361b0cb72b28693198e5d1d96e99e771afb79a2f00b27e7711052f5f3dcd1dbb66b017fb5a1109b2be89e0d4c1271f52657c0a919dead9275559b8f01ed8e7083b460790e4aa6da33fe1dc3c88acb9810c607a37c69ce09afeb88da2a4a1344ef4b357b1e9d8f21662467d4dd847e65831f1a598f8526c70f6712d1a72b50dec768124ae9c97ce1e3d8eed3ab8bd030ab98c24a4fdf90a5ad8e4524083a767d18527b617cbc7ad36524285ab5755194a21ee138f231c538c70132e0b21243d88955c7ba72754597230e66a1d5121bf83ad5ced3bd75499892374953d05407b6137c25e3ffd0398eb2f97eec8732973ac98f8524c7c2936a8e9078f9d23fa30d2619a3bb10f71c615cad176fc7467e92634ca6f1e4148e5f45164b53a358052816bd3f69c441868fac9cfabb2be8e963dfd362e21b61f6beb9dad1bb88430aa9016aeccabb2ec05a08d4651ea1d6b21e7e58d62b3338d0d7d5cdbb1b6ea2d792e658e15135f8a892fc506358fe3b83648c0c7ee4f770c127dcaeee1dbee13f1cb516b4995972ea21c667301919d681080d6eb011cb46492ecf3b42a234c453909ff0ee8e778b0a65fb3908a0ab531c88539ac204beccb817d328828b97a12991e0cc31f65d3c888ec692173ac98f8524c7c29762fec83d7ac4de83059fafc29147276441d7d0714fad497f187bdc6aa2a2723684818328924ba6b5b549cd7d0012ceda6c54171907e2c37d36aac66e6b662ba176bebade2b22a03217c9a35509414d2b9d49e8374d8d0c776d564b96364863c9732c78a892fc5c49762f7c03e2e0a7171049dcdddd6f986fe0fb0e34a81454d1cea910c1255e3117cb9db46ed6fdf42458f69a32ac72229f8b83babc7c32b72ed10cf956b8e0624b14937cd3524c85a45047a1ac53206c99859209676c31fd8872ee190f51ef0cdb97b37e4b99439564c7c2926be141b807d1e3836a3ea8fe6903f324c570c85d2d8e987c1555fdaee3028e399297c1c8ba21ca6db44454f937b63755b2d92828b0570a2601099a9ec047628b3dba89dd1fd08d6f4b9077c731b5539f5421effebe0bc1d0e329c4692cbe13a75c761dcc7158d629748a7877e0046242bcfa5ccb162ffabf6cf01000716f6d0743871770000000049454e44ae426082),
(20, 'chla', 'aymen', '2017-06-24', '[email protected]', '14512c47208b70be8b3267d43b8bfc94', 'Génie Logiciel', '0784523154', 'ensias', '[email protected]', 0xffd8ffe000104a46494600010200000100010000ffed009c50686f746f73686f7020332e30003842494d04040000000000801c026700145252725a676d43387a4133515563785747416d2d1c0228006246424d4430313030306163303033303030303937303530303030386430393030303032313061303030306536306130303030613131313030303064303138303030303438313930303030313231613030303030363162303030303730323630303030ffe2021c4943435f50524f46494c450001010000020c6c636d73021000006d6e74725247422058595a2007dc00010019000300290039616373704150504c0000000000000000000000000000000000000000000000000000f6d6000100000000d32d6c636d7300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000a64657363000000fc0000005e637072740000015c0000000b777470740000016800000014626b70740000017c000000147258595a00000190000000146758595a000001a4000000146258595a000001b80000001472545243000001cc0000004067545243000001cc0000004062545243000001cc0000004064657363000000000000000363320000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000074657874000000004642000058595a20000000000000f6d6000100000000d32d58595a20000000000000031600000333000002a458595a200000000000006fa2000038f50000039058595a2000000000000062990000b785000018da58595a2000000000000024a000000f840000b6cf63757276000000000000001a000000cb01c903630592086b0bf6103f15511b3421f1299032183b92460551775ded6b707a0589b19a7cac69bf7dd3c3e930ffffffdb00430006040506050406060506070706080a100a0a09090a140e0f0c1017141818171416161a1d251f1a1b231c1616202c20232627292a29191f2d302d283025282928ffdb0043010707070a080a130a0a13281a161a2828282828282828282828282828282828282828282828282828282828282828282828282828282828282828282828282828ffc200110800a000a003002200011101021101ffc4001b00000203010101000000000000000000000304020506010007ffc400190100030101010000000000000000000000010203000405ffc400190100030101010000000000000000000000010203000405ffda000c0300000111021100000187b85f5bcd1f89cda1e08e6ecfab012a5c42bfb0b38181615582d312ad41ad608579b7343535f78abeae395f69a2f5eacad55076c41a0f5cac196182d415fc55b10999e6d1810a3017b6afcb58070f40f588cf168723c3a33ac688747d08234598e611cfdc389588f60fa4104ebc83b542ceb154bd871650f76ac477025206124664e7381ad034875848f1ec8a0c3be5082d71e18d5f24a55349d234a3aaf13653b290317eaae260d202f9538fd202540cda1ec08db46b2485b2caab4f35a2a956d751d8d4ba563564d15a06ed24ad522be002af4fc5752123e61449122af35ada7bc57dcd15ea9022d424f58fd76c293a88f17067c7860cba62ab004caaafe5e3619c739d6946f2633da36fa352a01b0e54d8235c827946996eaa34819789964619a0ab67bcde810e4d2de731c7e4be8ff24ebe61b1acb0b4726bea644652c686c15ad5da3dc735cb53689aee57de5da533ba4ecc0207cc10197335b2384fa8d2dd33ba6ce696b38a5d6b6f9e392d132934a5e725d0b2a4d2ecdce3d9b7a70991531b38b0ab66d7db5586aee03fceacd377ab9ecabc69103d96336b0b7fffc40029100003000203000202000505000000000001020300041112132122052310142031410624323344ffda0008010000010502fe8e3fa0f00774e3d0652a46777c3d8e79961e0c15a3f5488e6d364c4e9c8743fc4f030ec4861d84c3b04834761c23280a304d581947cdfcd04401947ec9e9f5a62ff7ab82cc62ea38cf6a4820b6ce2e8e269a86a69f5c9ebf70faea69392a4c02cfc718e7a270014f2ca73c899ebe44e7ce5110af1d313579c96a20c550b97af45d7b1a5080d948f244cf4e1b6162c279ee5b264d3027c75e33c4904f1848cf8ca6cd132a88f3d75c551878e0a82a8403f2187c653e338e0ec357b337ae70bc22f5ce3bb4d781d4f621b972eacf4e1254191211549c3cb671c290b3a2b2f27ae39cebd904f91c75414e329c95d7989e01ce71f6f321e9cae19bd1eaeeafb24a225938f400508e1de44d366717a6c9193d8352799a05a394745c7d8181b96680e5e2bd9fea7b7c59d98b2d1b14a76675c751cb47ea15b2338d725afa8b21af2c2ccd8bff00063691e3e9d8b614eccc815197953d42b75c0dd52d6fb00e1ae594c99ec5a55c54a9cd6fd77af8977f439b556e5f5f7429b307f51e0fe5e6f48c8ff3334c3b0cf49ca6f649cfb548591f6759aec502f5aa6acbc257dbe990bfebf708e5136db8fa140c94002aa4ab6167388ac14a5028e7597f148bebb5fea0826cfaeafe5b540c659909094f045b97d86d5aee3d37708af5036b946030a4ba0114c9823168c8128bc764679bb2a1255b7ea410381aaf6d76975b25a67884a90957bd52d0275fc80d692f0c2a9ea4fdcf7cfda19d9933d09023318bf2385e25c71b936633e58ea7080270eeac199f834deb769af6aaedfb01b33194b0444b52b804b15539e546757c34623ee7109cafd85511a043caba1dabb15fae1fb3fdd735fb473af29593a5e5aee31fe1654b62bbf07af0ac1457973e4ca67d9557f60b6c0853676c36c2fce7e3f4dbc77f685763da4e25e447167cdaf690a1ad0c7a88bd38ced7a3b13750b34c1cf203d8be9db3c195213f4cb53b51664e443a1adab6cff1df217fadf4fcf1a4ec23a9b4b9574ea8bc6330cf6fbeab7679e97a154006138f36f4639a71d67988e99cf08f6fe575892df6d3ff00bf72f3ae6b5e6f53f005854a15188a2ccba42ca93e01e065a8115c85544f596cebf80e3e3f1f43e69d5f2fdb19d9623fbccf0674f33a7ad2d79d2b3ebea8ca357bc96438ebc6738cdc10ff000cff000a6f0a4b4ae51346246b8f3aaaa94683f3b63b4e12f5b7e37f1e362b0d1edb47435de94fc7eb669cd12607f1e39cadd62e36274cff00715cbb3afe3f4ff20b581d7ed3ff00d28ec99f538edce6ac390aa5470d89a3261bba7d134d91b5867f80bce1fa8698ae2c66b80f5579caf1a695b5487ebab06fd6653f35835053b6b3e9399d4b3b27ffc4002111000202010403010100000000000000000001021110122021310304411332ffda0008010211013f01aac2f14dfc17ad27d8bd45f58bd78214123494347e68d3451c158a2b6d6fa2cb68ec7c1a8acbc3e0bbc36451d6253ae08c94b1d89145091589479211ae711d8b0f8352639a876292975859d46a3cb26ca63bfa41d3c418de7925072eb1f3834b650b6a2f1e3fe4ffc4002111000202020301010003000000000000000001021110210312314104203261ffda0008010111013f01524fc2c7cf05f497eb82f097ed97c44bf5cdeac7c8dfa776776291dfaf83e46cec7665e2cb1163621e162f08b297d293f0d2f4491d7167a2558425585a1bcc78db2717064742d0e4596335884b5472caf47f848d165e3c12b141c4507c8f44a2e3e94484562d9c08b426be1c8ae232485a2f0887228fa33eec734bd3b58f6bf8cb3cdfd8ffc400351000010303020404050303050100000000010002110312213141132251612332718104104252916282a1203372304373b1c192ffda0008010000063f02ff00432614de21080b9623aacb965d2a40e52b60846145ce0b94ca02cfcac387cf242f32e5cffe2905a1739ccf550419f543ff0057316b54b9e49ecb475db4ae7e671fc05840159f9117410ad73a495391ecb1ed2b531fc237b8928dedf4ca2584b87452c2defd944bb4ce251b8182bc375314ba6a5795f3d828735f7bb40a6daaf77d4764d0ea475c2b1ada6cf75e76fb05ccf323a23e5f57544e2f34e47d8839ad7b49c07b88479c06ad25dff4a202eead74903aecb94a0461dd53dce7baf1a841ce63809d094e2c14f9446360a6f88e8d5c4a85d24c33d111e21df55fd98f550594fd508e123a7e50d2e9fb754de2da1a7cc0353c52a00c8c1400754016160c2ebeab948074211d485841dd35f446c0d23ba80ea61872e41b7b75e6c28e2120746a9f13dd132f1daf50477cad07b05d90b7f945b51f59a0ec4056f19f4e98d24492b489d16028017741f7f68e8b72119b90856f2c8fb90b4327d3747cd7690d5915277e55cb207ac2cb587b9ca26e6117142da873d02278af3d97d4fe9cc831d74b79ed7bf9535aee17363cb80a7a2dfd1087b4a9763d11f2c141cc0e9850e2dc8990bca31ba25a254baa1f62832e683d672acb8ff942b58daaf1b94d6db13fab28431ac3acb57315a85cbcede88db4a0fe11616b41d0973911129b1ca4f4c2d500fd06e13b8ad6ce97830bc604bfd51707973db9b2134b80cf4c04e8c3bd506901fba07c218d15cdaa83cbfd61121d0e1912549a86f8eb0ae700f1f92a7cac1b230f0d9fc2e63b7442adae34c7d51013ea169b27542d6481a95b37d53eec03ca15a3ca7757d4c3da7065716813c43d1bb21c3b9cefd611f0b5e8506556b9b54080b2e6ba33696a90fa433ba6da28bc1c177458b4f5202f08b38719b99a2792d6d5e5fa1b10b0ca8d23609c386eb8e45c1002ad174f99a53994fe9e528d3e231cdb672342bcdcbd611e0c3ddd5438e4ee55ad836892ae061c3a2b6a3063f0a1818d8fbb2b06a98d20a976badce185804d6dad6e13c5ede23f5a658b86d152c03ed1a26b43aa705d8feda78352ab3e1e98987084d142839cca7bcc4abbe1cdb5758d0fa2c9a83f7287b29fe1134fe29d251e30a5c38d86573389a7b764394883ba6368d324acfc383f850ef86e16e4daa038c1c4872735b52a9dba8944b5d53f7355bc40e9ce5ba204fc4516c7da11b8b6a3be9396950f639e67524c27bc52b87db769dd00c8e71a07cc2d117d1d75579665d9828b1a22460ca6b4d36388e90835ee3f95e29bab93d5536b8c6e70b5910ac0e130a002e1d91e58037721670cfe9051b9cd68d64a2d2e641e832b9ae11a39add172f143a35515293a48d065470de1e3b2b831f68ea9c194ee91bab6a30873f97d91229968da1fa2c63792e43a9dc655a5a1a7fe9710dcf6b063b950e8696a86b8389eca29fc39118d375e33386d3a34cac3a992eea51024f768d5431bafb9fc2f10b437fe358c0f55cd55d1d41534dd57d480a78b5074d93c0aee2088f3046cb5c07546a5439023d11b88d57298c6b12a388ccf64dad529021e61b22536d8ceb22253dd4fe1eab49112cd1713ca670162e2e6e5bea8bbe2e93cc22451e1ddb9d978d55b03d94d16000ee70bccf3dc086a710193aeba2e627ffb0beb0ddb953581cca8d3a9332d57536868dcb7758d1715ee0d6ef2a69791a2dff250fa33d20a05b4f4dc04d7f85d23edf440b417fee46e7981a0d5539fab79dd45205cf5c9461ad3abdc9a2a3b13914c4ff2b0207ebc9465c6d1f5bf2b91c5ded85301dd86ead2df4e509c1d51ecf46e4277339db4bbe5e685e2d473be76def667109f55b55f255e6eb271272535b0e0c71928358d10decb98a33755eda34225d0e819b7002a90c75479d09d14d774b7ec180a07cea54111f2612d92e6ce5cbfb3fceea0fc311ee5603c7ee46130168749882a29b1edcfdc8328d3c01e6857731c68a1b93e88873944beaf6d1a10e2cdbadba28d07ca4831e8a654b5cdca7834aa34807fdcc1f935823075403f519195059a6e0ea9e4b4b6d19f902bc3f39c03ba863ef3bfaab4e9eaada6d303a68800489c98feb7d3a4da8ee98c27bbe20dd55de5ccda9eead9749d30aad368d30b5a7746fb2cbae1ea8da66599c22d1aaa8da92db46c855a62da33aa2e73dc67baf33ff2aca66437fa63e208674eebc3a8d3d72bc0a7fb9f809ed07c66e491a29a821e3541dee5567b896cbf042bb0f9f746dcf51109f88b5a531f4cf8866531f7069220ca00435a3e90a6e781d9ca69bdf8d894c7531023fa45ec0e03ee586307b7cb875013dfba78a7e25289938527ed405cd33f4ce1016c1fb94b6ad48d0894f1c4bd8719dd346c806013dd7fffc4002610010002020202020203010101000000000100112131415161718191a1b1d1f0f1e1c110ffda0008010000013f21a952a57ff152a54768876cd80f6b8ee08f3aa9774c5b307ac0ecfef333df33afa9f1c60a81b7e06a53469cceb43dcaf037f0d3b85258fd26f47ccd92a2d23db3b6fa2637c915967055aca0a03230ff0021e690f28c006f683fb986d06f8d92cd5381cc0aa55b5b332a5eb240a9a55d5de7ea2379932ca79f519b1c6e0d2b6f640964f0db2eaba178d2645e12ce51069814d62d2903ce0d4c08712a1ca4b41b403a657a8f0f3a9b253cb25dd455e00fbbdcc577aaaa41800b64bf73332eebd3c13001e86fef3036e1d315e558ff00847f0c82156988d14afe084656d39afcbb89e31751f0427b167ccfda4d7a5c0e841aad4e40e1511f28b0e905bc4cdb3d13f70b5d7a42bd4a9214c11f304bce4dab67510b75cb9f5f33101a866d2a52f90607cc2dc0f64d88785c402858176c66dcdea2f68567e30c87b9b5955636f36b19a20d8603dcb8baeb2dc54193d1b99be1c459569816fdc0a5599cbb96050f966650c6437266edc1bd1ab965aacf8151cbe9443416c670d4704d58347e6548d5365dca311d64258e7c31305c6eace3539f13a8f888be18d03dc014468ad1c4079bc41c87c38216317a6596d996dc7d233f09999321e298162d9e77330216add15c4d6fedc7d12b72fc4153031140e1f886fd0d94d92d8e4ae540a5c00fe237c8c66aa82485eda830d59a3a77043c00251d626292af5810517e9b8edaee6e6499705d52b17769e5772b3e761cfcc4895451dc587cc81bbeb894a48dc5bf5e65656065cb2bd14d689803cc3cd1e52d4c0c7e221ea85c65eee22a4f15be90c58a80cfa7b850169bc254c72bbdcc0d475d3dfa8fd2e65e1ed61ed02c58fccb9a0da1888a1b01c5e61d8323bed96009a361e7d426cb4acafaee57ad5a5dbea04c19574cd3729c2910c0be2a2bcda33924136deebfda94df5b76d710ba12b05e332c069c587c31f9d84b732c7b3abfe21c8574b93db1703f00fb98a42c662e08704ccdf983404e5fa90749db333f1292bce3312de0f92c0093001d1cb02097c8299b5b154d851a2db2e116dad252df896790a0d76c2fec04a6a14b16a64f9f995e740211ab9c14407e52f14b9a7ae6f594583eb19154bc1ca1adb317f73cfa05d435c6e0e11952ad1cd58ea0b5e2cdbf446304acaa9f89d2becd0116a2dca641ea0836e6fe63ce4ce3f3285aeb4558a50219d97e8f11252ad2c7f318baf9aa61280b94bfe4c811684b5d9031bffa415ccaf80d0735f32964d88e5d6a271044fe0d411a214e49cbb9df9d2bea9dc774d54a56a60c353aa986cc2eecb6a76c95716c016daab20281f84aa983579ec45ab072f1fb9e6560b7cc6085dbf01ee1b896130932d66ab8a42a6ed47644b346d1279035ee0f43a508b75030085dafaa72242c5c4b41b31c0c30c6939800900498b659936e00f98393d2f23f73f8601ee095702b87f6a0a957236cc35313052b73761b59cd44161c7f94bda8e40533581c2d2af31d1a7b23f50d2faa657c4a3cccb37d8d462830186fe679ce0d8c6792355985476aeebf884b5897c25f364f2ef50d1e80a8a7a8ef37daac2c34bf653f30395b59210db2e1a885ebda1b895c4c05b32f40551265fbf88d5a3a9a2fc87894c5032237ec836d16f43c2e55ac395bfa910f3f458b16abcd620a64731ac63a072a352a0e89a6c7d4c30a4ba12353115ad8ac6229fec13973e4a19845d3258787e2ba3894bda8d84ba21e885a05de638b3e53e6039604e6fc0940ac62e8ae350a0edc5453c9b97d8992bfdea28cafd68cbbd467104635e52361af3651326efe2d6fd45f54d2f93070fe2c1ef060e7da0b9c76563cc5349518fb3370555c29b231e1b3770a7b5cfb4c6abd54226042cccbfbe657ee06d74b80ca2d03fb6172b40d21f50a1b915654678da95fecb96b016f697c1c4f1ae749bab75f453a6174d2f002be587d74c27c973bf8aa5a86a06ba960113819f58eb8fa99d3731a78677105b30f64bcd8cbc99edcf318a6b7e104b3aaf6cbaf3f128f85478fb8b8a979298ba521c3fbef30c896818ee32c7bd1de313c45bdd5a7f2f32f4d1ee0533baaa1ef0b27aa885bdfee72db004082b92b287f2897bcdaa6b5aaecb1082d2f133f04a3987165c2db7f10c499073fb9bf41c170cda11ae04a41c6cb992dddefecb31a77c18421180a288820576e165aa5878c4c9031ccb98e2cc5ecf11d1f330d02e4711a08aae86c0276550b254a6b8c41ce21ad2364b02bbce44708f34a63a85b30b89630d7f3467b5615418b095e305a304a6fccda6896d1a465f3e733f6cc2a95ff0042028860c12f82970b498992a8aa6182b202c8a580639543bf88dc45644eea9e1104328b751a74edaa1f89d27cc5ccbaad3713d405c99a8f920f489294df2a47df4e828fa53fecc60856055aef12c50b5430b06cb641a6c114317ee63c5ecaff00e22dab76b142a14abf06a367d33701547ee65604728d26c09d1180e52c8aadf9089e29e12a2be6223bd6a352ae1cc8679840cd80073141f504220179e230cb2e9b3b117116c4b12cd705bf12a7b4a8f05f3ee64287269f551e296c96bb84e54f67a4f396c758e068cfffda000c03000001110211000010c7287de5e0253d46cbb942b4a281c11881c6a8984e2b3470dd1bf12369ad5a00395777a3e4c5258d73eb4af43a240e6e5a152b02efb4ba175c817dcb68562ee22085b381649819ee3472edffc4001d110101010101000301010000000000000001001121314151711061ffda0008010211013f1057a205f2f127bc0bee97772f108327790fa421d208c23a8203dbf23f826f64d839247da0b36cb39b126109eb28e168ec29e137a6d3f11a648725b7e43584a51be168632be48f8b160583588e4eacedc23fd58fe5acb32d747cdfad677597dc6ad98c17b9c4983597e0c40cec2b67f53b09f371fc7237970d23ad8c696e7201eda4bf56dbf26fc0473d9e6040349c581b65b676f2a4e0ef6d3132cb3fffc4002211010101010100020201050000000000000100112131415161817191a1b1d1f0ffda0008010111013f10f65b20eb7b63fcde216fa15d263f88fd4fee72e1084f98c05aa4fb2c9f4d95fbbbf326fa12fb8466da3297d4fbb2c65fa8fca7e7b317d90721204d8e9ea4708c7cce3d631e598cd89e902fb613b6290dd602d873a477d21227770846bb603fea02edc3ce4fe36fe65bdc9eb6e7b9ff007f5833f480ebe2173173e13836026e4a25db9e324581d8bd65278b8a3fb405b3c2c7d4af8b874f6e5901ae5bb966c10309002d091e253ec9c80fc40bf6baf23bd24d2696b6fecb2c8cc84dbd659ac1d3b6c9ffc4002610010002020202020301010003000000000111210031415161718191a1b1d1c1f020e1f1ffda0008010000013f10ff00c3cc39737d19e45ab0647b09c85545649e53a4f45f2f18ab5991b792808e1a26fa8a1ff4e76dc2d527b85b1f1eb158fa84118e27ce25c082412fcb2986c44b4a4fc81aff00d604003dc1fafce0607bcc3800ebad5e6d9701edf83ef1d079d1b77800258e93278329212a0462511713723f3ace58f72121132d3f8c9cd1115cf1698e0520e54d811b46e571b1222469493c58d7bc911920101809752c54c420e10d1f18a5f922080d46ede9c769d47a83ba7461bbd0a4b88f2be7240947836ea9855e1021460d4064c142a694de5c0a0454fbf5977adba835590527886a29b9dbd466a5924023cfde34cd0abf29fe6f2832256c1a159c2814bc363b7ce20c0390a7676f8c6eed1d3ccf070c114492e97a08e1c7b7a6b58a7b48de4c150425a3a372ac61155c036a5877e71c0322696a98624e7245883a2ea9d19deda8242486eef74643a4151083c8133e5714cbe481be12b778202f8041fbc445853a873091eb1c39002ca764fa64bce0a0edcc4d562225062cab4004a7eef242a10c8491881cbbea72610c4a91e638c695054565f264a212eba8afd5628a941483c6222d015471dc7ac9edac028ca122c789cb8e42343978bf59167fb491264e4f7d6f0c96e384db6add992b34a0e1604044bbcd41c316f62edc5d1c02c92c762b95001112533fac999c04d3bb80325e15eecf88c88901190b2992f786306126f66d08e0844519ac34113383d8152c36c2d7a9e7d63428312949f9ca26a8b1daf8c839b1351adfdf8c881a8051cfa1f18801106ba783204a1897938f8c2a0a480c8f323c6cc818dbabd430e135091440d1dc133192e06121887b619ac817205d49ab8e30daf7e684700237909b520100ba8c7c6486584a84d0b3c4983ea2dba0d499644764e7100ae69a6cc6cea3041ba052ec49af3923c410790a41fe64970d8a00a7d7ef2703816b0172d20241893bdfe32d0ee8b1f418fe398ab33c8eff0018a2a4505a761e714c9be1a6ae412379e01c7f05cb3a15dd702fb8c8a0370b03b3a225c96a645a87170ed7095772886d44830c9109280f1cfce0f7df354d7ac0e6483407305a878c0681490d7561038080a2747cb5be3d642834405513ca38e65c68d390930402c7c94635ca108c09617f558e04817c937591a0c21bd7307192a404ce0be7833618aba13d62d59d237ecd6411adb8b90ca3eb11ae0203b38273c64d7d5ad5f491a9c5c0d1d15e6ea4aa5c5969040236c05b8ad2aa8c8bb181e4de3f51a3ca7925229bf187278b01761411cfce2354ce8abfb446f069260800c744a35f3850d20307c9eb19497b22fe719b5299c83b10bf2de1d43c1cdad8721e300ba982d3626d0ef109886e13e86dc099f080958a669d24a09fbf3916f96112e02374859eb1ad48c29ab3c215ef27107120e8a53d464903aa442016f098a0c91bb888eb594fa52922354e3950eda4ea449f0c8e0f1393c20c4bf384cbb84124722cf7d654580085146e3c8ef085948820f0d78c9454302c554852f775892a6c1895fb3f98a52146752d889ffa7159212741bdbfad6001a6922f21d3ce522ea89f3b1d4e4555b29260386dfac1d6a88480e0661c34e0b04627507fb902a802aabe932cb6117374a85a1f8c12a4f3d3076246dc06c787206896a426c6f036216d93b071c645958525ea67de4902171c278bbc29b0e234d0274bae630812c2d0b0d2bff718bed2002dc808bf0e311a12c077627e706c353cab8994acfe324f7f48895a316f8f9c56ad2151e480bf9c07a4f49953275ac844204bc81ebe358e8f604bc2962e3596bc52d6e8800ebf5872ea90dccc2579b75182a09818f56d30ceb17148ca94504f2fb9c8c5254500a3e9803104dfb019a3893000b9cf07b22cc08e4828f5b5753900800a80dca6c7b9c54948806350d5f6733859e8a2042aad92e4ca709c02a457644de270630470a18589a272845ab6e480dbd28e058c59c292d428f8c1f854cca924a4f78db9f0541703475cf0e3b04ced1e7c0f4c8388a055d83627ff0032b9492aba92d8c5420b010b32845ee49ce3b2b8f822888c1ea8487401db803a260041db4b905b76b2e859c1624b4c8a083012d5e4b4922f0fae075aac282a15340480b1a8c64d501902d100f18b57ac8d083a3b6306a281d3b495f583e163060d943f2c6ae9d58049a035373842a693a25554e1b8d62aa59a00104afb58c74ad93647971788714b9118f1807f2cc0258f4cfac7c4fb811a2d6c5cd6f18f28583bd895f78d13624663e510318a84621266a048676c94c09fa3a0183371151e0460e729292050a3ac35b8835174ac97ac944efbca37b90f38e875257b09027cf39340aa8b51220efce445dc8269a435f7ce032e911dcbb38153db525d780f58805674129b4b87bbe72b5aa924262766fc560a9e277ca84a8e7152e96140ecb8c76bb61093c9dc44e0e3182464e5bb9586705a94482cdf8f9c8176126a3aa5e40fa136b3a6261ac8a3888b0ea25499558aac48ec2483db01ac42330a24e8268be5d65bb1ca1c024b2055a5e03310d1135096933fccd1f2da856c5a277ce1e4b40c33285d5edef20109cd6e43e28b431180a489380bdfac6be024807494beb20e9d1798686686f518baa01d43710ff98d0e70b29b98f96558a0495ec89832ed190917b31c7ea8e48bc0e0052900910234477d602054f7c895b8a9b0cd4224640c5b92883253fb6b4cbc4e058415f0a208877bf1818a8a17937a6a758688120c926cbc7b7782a0348a048110edee305339c053ed663bc7011702a3b9a98f392000996ddab68759a63f2d3433b7c07179b626108eb963f73934be40eee557de430d808f08d597ef130446d30ee10899f56e5a7475c11c188526220b3287b9f9c8b6ab06b2c9ac471e0cb44644dd15a4365c8e8f196856db6783a300c181358e98969d95900e198600a4a224fc9ac484843083c8b6cf58ce709d2ba41a086f8645e312a15c0cdff3070a91583e4603db19c2d65b4e60c877ac44f1f1aa1e5ae30619e12f062990f0de422122d3547003ce1b1a8e423d49d732e0a499507960816f71f1888dee08d8412c3def0ea0d01072c21f4611508ed8825f194304a13ce0e4f4dc17d6b1c906bc76a958b32e45861584dc1d62c8aa169ab7ecf1948c00f4c200a99035962b91124c203778214e4f9a6f21858834ea41c489faf9c8a00a190f5e5c406e46419d37f5eb111961892a54be9a4e30e5e0df4a2860138300ec0305ef97b3814104416fbc54168e6300202def249b5219010463d6445dd9f0700f11cb0a623ce56b2229ba0edef1d14651881e4531deaaa0442cd9c7bc9864a658cf3c143427abe72106828d7fdef2101bdabdb44fcb8ca0aa8806e8bfbe3240232268f2c95f6e2310d4083c598214d04c62ecda744ce458831153c3169f590bc304501a2b8c8508bcc1ac97e00e52606301cc64d0ceb218889ca3e5358a5c51ac26c4b0f1bc99ab34713ca61d3a4f05e04aa90c08a603c980090031e48c2156a09860a3ca98cbea5fc626a1d8e1193207249582d5703e7174889051ac0e8787156c0418a5b9e6b122314abf5afde54cdaed1e3536412e12258804d60a6af0835f58465a298af8c6b45dcee72ce80e35387b932f49c9e7056d334a5b1350ec73601820e6ae8fad464e8104b45d0718ac09a58041643def256599a03238d74e146bac066f576016746068e01407097da8255886701772e9c6953b14992b256d8207a7face1f1cba5f9ca6128a2b6ca539e17b64a54e5c6214819ba2300a11adeb13620c2cb604adf67195c20b0440f19488cd463e8bf80c0d2f3a44a92dfab707330d5238ebd61415c03b9bff007255e6b90085e90627470828178d0ef23d95523ce2b7c185b37126194f3bf1922682d01c0ed6562723aa82360eae75888930a20281e8c5d6486017920a89eb05fdcba8fea4d6048806d8217ccf79cb01a0989c44d0c8e9c0ac2bd62cc0500c3392590041de1c65c45a6bd2179627c6b2fc649e195221ececc5f820038da6963ac0945d27a2582ccf7266b2ff001af38f4511b07411279c05d40c9251152c3afce0f27daa948f449ce7000676d7f337107d475e273fffd9);
INSERT INTO `enseignant` (`ID_ENSEIGNANT`, `NOM_ENSEIGNANT`, `PRENOM_ENSEIGNANT`, `DATE_DE_NAISSANCE`, `EMAIL_ENSEIGNANT`, `MDP_ENSEIGNANT`, `DEPARTEMENT_ENSEIGNANT`, `TEL_ENSEIGNANT`, `ADRESSE_ENSEIGNANT`, `SPECIALITE_ENSEIGNANT`, `PHOTO_ENSEIGNANT`) VALUES
(21, 'jabbari', 'youssef', '1998-05-05', '[email protected]', '25f9e794323b453885f5181f1b624d0b', 'Web and Mobile Engineering', '558784', 'ensias', 'cryptage rsa,phyton', 0xffd8ffe000104a46494600010200000100010000ffed009c50686f746f73686f7020332e30003842494d04040000000000801c026700145252725a676d43387a4133515563785747416d2d1c0228006246424d4430313030306163303033303030303937303530303030386430393030303032313061303030306536306130303030613131313030303064303138303030303438313930303030313231613030303030363162303030303730323630303030ffe2021c4943435f50524f46494c450001010000020c6c636d73021000006d6e74725247422058595a2007dc00010019000300290039616373704150504c0000000000000000000000000000000000000000000000000000f6d6000100000000d32d6c636d7300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000a64657363000000fc0000005e637072740000015c0000000b777470740000016800000014626b70740000017c000000147258595a00000190000000146758595a000001a4000000146258595a000001b80000001472545243000001cc0000004067545243000001cc0000004062545243000001cc0000004064657363000000000000000363320000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000074657874000000004642000058595a20000000000000f6d6000100000000d32d58595a20000000000000031600000333000002a458595a200000000000006fa2000038f50000039058595a2000000000000062990000b785000018da58595a2000000000000024a000000f840000b6cf63757276000000000000001a000000cb01c903630592086b0bf6103f15511b3421f1299032183b92460551775ded6b707a0589b19a7cac69bf7dd3c3e930ffffffdb00430006040506050406060506070706080a100a0a09090a140e0f0c1017141818171416161a1d251f1a1b231c1616202c20232627292a29191f2d302d283025282928ffdb0043010707070a080a130a0a13281a161a2828282828282828282828282828282828282828282828282828282828282828282828282828282828282828282828282828ffc200110800a000a003002200011101021101ffc4001b00000203010101000000000000000000000304020506010007ffc400190100030101010000000000000000000000010203000405ffc400190100030101010000000000000000000000010203000405ffda000c0300000111021100000187b85f5bcd1f89cda1e08e6ecfab012a5c42bfb0b38181615582d312ad41ad608579b7343535f78abeae395f69a2f5eacad55076c41a0f5cac196182d415fc55b10999e6d1810a3017b6afcb58070f40f588cf168723c3a33ac688747d08234598e611cfdc389588f60fa4104ebc83b542ceb154bd871650f76ac477025206124664e7381ad034875848f1ec8a0c3be5082d71e18d5f24a55349d234a3aaf13653b290317eaae260d202f9538fd202540cda1ec08db46b2485b2caab4f35a2a956d751d8d4ba563564d15a06ed24ad522be002af4fc5752123e61449122af35ada7bc57dcd15ea9022d424f58fd76c293a88f17067c7860cba62ab004caaafe5e3619c739d6946f2633da36fa352a01b0e54d8235c827946996eaa34819789964619a0ab67bcde810e4d2de731c7e4be8ff24ebe61b1acb0b4726bea644652c686c15ad5da3dc735cb53689aee57de5da533ba4ecc0207cc10197335b2384fa8d2dd33ba6ce696b38a5d6b6f9e392d132934a5e725d0b2a4d2ecdce3d9b7a70991531b38b0ab66d7db5586aee03fceacd377ab9ecabc69103d96336b0b7fffc40029100003000203000202000505000000000001020300041112132122052310142031410624323344ffda0008010000010502fe8e3fa0f00774e3d0652a46777c3d8e79961e0c15a3f5488e6d364c4e9c8743fc4f030ec4861d84c3b04834761c23280a304d581947cdfcd04401947ec9e9f5a62ff7ab82cc62ea38cf6a4820b6ce2e8e269a86a69f5c9ebf70faea69392a4c02cfc718e7a270014f2ca73c899ebe44e7ce5110af1d313579c96a20c550b97af45d7b1a5080d948f244cf4e1b6162c279ee5b264d3027c75e33c4904f1848cf8ca6cd132a88f3d75c551878e0a82a8403f2187c653e338e0ec357b337ae70bc22f5ce3bb4d781d4f621b972eacf4e1254191211549c3cb671c290b3a2b2f27ae39cebd904f91c75414e329c95d7989e01ce71f6f321e9cae19bd1eaeeafb24a225938f400508e1de44d366717a6c9193d8352799a05a394745c7d8181b96680e5e2bd9fea7b7c59d98b2d1b14a76675c751cb47ea15b2338d725afa8b21af2c2ccd8bff00063691e3e9d8b614eccc815197953d42b75c0dd52d6fb00e1ae594c99ec5a55c54a9cd6fd77af8977f439b556e5f5f7429b307f51e0fe5e6f48c8ff3334c3b0cf49ca6f649cfb548591f6759aec502f5aa6acbc257dbe990bfebf708e5136db8fa140c94002aa4ab6167388ac14a5028e7597f148bebb5fea0826cfaeafe5b540c659909094f045b97d86d5aee3d37708af5036b946030a4ba0114c9823168c8128bc764679bb2a1255b7ea410381aaf6d76975b25a67884a90957bd52d0275fc80d692f0c2a9ea4fdcf7cfda19d9933d09023318bf2385e25c71b936633e58ea7080270eeac199f834deb769af6aaedfb01b33194b0444b52b804b15539e546757c34623ee7109cafd85511a043caba1dabb15fae1fb3fdd735fb473af29593a5e5aee31fe1654b62bbf07af0ac1457973e4ca67d9557f60b6c0853676c36c2fce7e3f4dbc77f685763da4e25e447167cdaf690a1ad0c7a88bd38ced7a3b13750b34c1cf203d8be9db3c195213f4cb53b51664e443a1adab6cff1df217fadf4fcf1a4ec23a9b4b9574ea8bc6330cf6fbeab7679e97a154006138f36f4639a71d67988e99cf08f6fe575892df6d3ff00bf72f3ae6b5e6f53f005854a15188a2ccba42ca93e01e065a8115c85544f596cebf80e3e3f1f43e69d5f2fdb19d9623fbccf0674f33a7ad2d79d2b3ebea8ca357bc96438ebc6738cdc10ff000cff000a6f0a4b4ae51346246b8f3aaaa94683f3b63b4e12f5b7e37f1e362b0d1edb47435de94fc7eb669cd12607f1e39cadd62e36274cff00715cbb3afe3f4ff20b581d7ed3ff00d28ec99f538edce6ac390aa5470d89a3261bba7d134d91b5867f80bce1fa8698ae2c66b80f5579caf1a695b5487ebab06fd6653f35835053b6b3e9399d4b3b27ffc4002111000202010403010100000000000000000001021110122021310304411332ffda0008010211013f01aac2f14dfc17ad27d8bd45f58bd78214123494347e68d3451c158a2b6d6fa2cb68ec7c1a8acbc3e0bbc36451d6253ae08c94b1d89145091589479211ae711d8b0f8352639a876292975859d46a3cb26ca63bfa41d3c418de7925072eb1f3834b650b6a2f1e3fe4ffc4002111000202020301010003000000000000000001021110210312314104203261ffda0008010111013f01524fc2c7cf05f497eb82f097ed97c44bf5cdeac7c8dfa776776291dfaf83e46cec7665e2cb1163621e162f08b297d293f0d2f4491d7167a2558425585a1bcc78db2717064742d0e4596335884b5472caf47f848d165e3c12b141c4507c8f44a2e3e94484562d9c08b426be1c8ae232485a2f0887228fa33eec734bd3b58f6bf8cb3cdfd8ffc400351000010303020404050303050100000000010002110312213141132251612332718104104252916282a1203372304373b1c192ffda0008010000063f02ff00432614de21080b9623aacb965d2a40e52b60846145ce0b94ca02cfcac387cf242f32e5cffe2905a1739ccf550419f543ff0057316b54b9e49ecb475db4ae7e671fc05840159f9117410ad73a495391ecb1ed2b531fc237b8928dedf4ca2584b87452c2defd944bb4ce251b8182bc375314ba6a5795f3d828735f7bb40a6daaf77d4764d0ea475c2b1ada6cf75e76fb05ccf323a23e5f57544e2f34e47d8839ad7b49c07b88479c06ad25dff4a202eead74903aecb94a0461dd53dce7baf1a841ce63809d094e2c14f9446360a6f88e8d5c4a85d24c33d111e21df55fd98f550594fd508e123a7e50d2e9fb754de2da1a7cc0353c52a00c8c1400754016160c2ebeab948074211d485841dd35f446c0d23ba80ea61872e41b7b75e6c28e2120746a9f13dd132f1daf50477cad07b05d90b7f945b51f59a0ec4056f19f4e98d24492b489d16028017741f7f68e8b72119b90856f2c8fb90b4327d3747cd7690d5915277e55cb207ac2cb587b9ca26e6117142da873d02278af3d97d4fe9cc831d74b79ed7bf9535aee17363cb80a7a2dfd1087b4a9763d11f2c141cc0e9850e2dc8990bca31ba25a254baa1f62832e683d672acb8ff942b58daaf1b94d6db13fab28431ac3acb57315a85cbcede88db4a0fe11616b41d0973911129b1ca4f4c2d500fd06e13b8ad6ce97830bc604bfd51707973db9b2134b80cf4c04e8c3bd506901fba07c218d15cdaa83cbfd61121d0e1912549a86f8eb0ae700f1f92a7cac1b230f0d9fc2e63b7442adae34c7d51013ea169b27542d6481a95b37d53eec03ca15a3ca7757d4c3da7065716813c43d1bb21c3b9cefd611f0b5e8506556b9b54080b2e6ba33696a90fa433ba6da28bc1c177458b4f5202f08b38719b99a2792d6d5e5fa1b10b0ca8d23609c386eb8e45c1002ad174f99a53994fe9e528d3e231cdb672342bcdcbd611e0c3ddd5438e4ee55ad836892ae061c3a2b6a3063f0a1818d8fbb2b06a98d20a976badce185804d6dad6e13c5ede23f5a658b86d152c03ed1a26b43aa705d8feda78352ab3e1e98987084d142839cca7bcc4abbe1cdb5758d0fa2c9a83f7287b29fe1134fe29d251e30a5c38d86573389a7b764394883ba6368d324acfc383f850ef86e16e4daa038c1c4872735b52a9dba8944b5d53f7355bc40e9ce5ba204fc4516c7da11b8b6a3be9396950f639e67524c27bc52b87db769dd00c8e71a07cc2d117d1d75579665d9828b1a22460ca6b4d36388e90835ee3f95e29bab93d5536b8c6e70b5910ac0e130a002e1d91e58037721670cfe9051b9cd68d64a2d2e641e832b9ae11a39add172f143a35515293a48d065470de1e3b2b831f68ea9c194ee91bab6a30873f97d91229968da1fa2c63792e43a9dc655a5a1a7fe9710dcf6b063b950e8696a86b8389eca29fc39118d375e33386d3a34cac3a992eea51024f768d5431bafb9fc2f10b437fe358c0f55cd55d1d41534dd57d480a78b5074d93c0aee2088f3046cb5c07546a5439023d11b88d57298c6b12a388ccf64dad529021e61b22536d8ceb22253dd4fe1eab49112cd1713ca670162e2e6e5bea8bbe2e93cc22451e1ddb9d978d55b03d94d16000ee70bccf3dc086a710193aeba2e627ffb0beb0ddb953581cca8d3a9332d57536868dcb7758d1715ee0d6ef2a69791a2dff250fa33d20a05b4f4dc04d7f85d23edf440b417fee46e7981a0d5539fab79dd45205cf5c9461ad3abdc9a2a3b13914c4ff2b0207ebc9465c6d1f5bf2b91c5ded85301dd86ead2df4e509c1d51ecf46e4277339db4bbe5e685e2d473be76def667109f55b55f255e6eb271272535b0e0c71928358d10decb98a33755eda34225d0e819b7002a90c75479d09d14d774b7ec180a07cea54111f2612d92e6ce5cbfb3fceea0fc311ee5603c7ee46130168749882a29b1edcfdc8328d3c01e6857731c68a1b93e88873944beaf6d1a10e2cdbadba28d07ca4831e8a654b5cdca7834aa34807fdcc1f935823075403f519195059a6e0ea9e4b4b6d19f902bc3f39c03ba863ef3bfaab4e9eaada6d303a68800489c98feb7d3a4da8ee98c27bbe20dd55de5ccda9eead9749d30aad368d30b5a7746fb2cbae1ea8da66599c22d1aaa8da92db46c855a62da33aa2e73dc67baf33ff2aca66437fa63e208674eebc3a8d3d72bc0a7fb9f809ed07c66e491a29a821e3541dee5567b896cbf042bb0f9f746dcf51109f88b5a531f4cf8866531f7069220ca00435a3e90a6e781d9ca69bdf8d894c7531023fa45ec0e03ee586307b7cb875013dfba78a7e25289938527ed405cd33f4ce1016c1fb94b6ad48d0894f1c4bd8719dd346c806013dd7fffc4002610010002020202020203010101000000000100112131415161718191a1b1d1f0f1e1c110ffda0008010000013f21a952a57ff152a54768876cd80f6b8ee08f3aa9774c5b307ac0ecfef333df33afa9f1c60a81b7e06a53469cceb43dcaf037f0d3b85258fd26f47ccd92a2d23db3b6fa2637c915967055aca0a03230ff0021e690f28c006f683fb986d06f8d92cd5381cc0aa55b5b332a5eb240a9a55d5de7ea2379932ca79f519b1c6e0d2b6f640964f0db2eaba178d2645e12ce51069814d62d2903ce0d4c08712a1ca4b41b403a657a8f0f3a9b253cb25dd455e00fbbdcc577aaaa41800b64bf73332eebd3c13001e86fef3036e1d315e558ff00847f0c82156988d14afe084656d39afcbb89e31751f0427b167ccfda4d7a5c0e841aad4e40e1511f28b0e905bc4cdb3d13f70b5d7a42bd4a9214c11f304bce4dab67510b75cb9f5f33101a866d2a52f90607cc2dc0f64d88785c402858176c66dcdea2f68567e30c87b9b5955636f36b19a20d8603dcb8baeb2dc54193d1b99be1c459569816fdc0a5599cbb96050f966650c6437266edc1bd1ab965aacf8151cbe9443416c670d4704d58347e6548d5365dca311d64258e7c31305c6eace3539f13a8f888be18d03dc014468ad1c4079bc41c87c38216317a6596d996dc7d233f09999321e298162d9e77330216add15c4d6fedc7d12b72fc4153031140e1f886fd0d94d92d8e4ae540a5c00fe237c8c66aa82485eda830d59a3a77043c00251d626292af5810517e9b8edaee6e6499705d52b17769e5772b3e761cfcc4895451dc587cc81bbeb894a48dc5bf5e65656065cb2bd14d689803cc3cd1e52d4c0c7e221ea85c65eee22a4f15be90c58a80cfa7b850169bc254c72bbdcc0d475d3dfa8fd2e65e1ed61ed02c58fccb9a0da1888a1b01c5e61d8323bed96009a361e7d426cb4acafaee57ad5a5dbea04c19574cd3729c2910c0be2a2bcda33924136deebfda94df5b76d710ba12b05e332c069c587c31f9d84b732c7b3abfe21c8574b93db1703f00fb98a42c662e08704ccdf983404e5fa90749db333f1292bce3312de0f92c0093001d1cb02097c8299b5b154d851a2db2e116dad252df896790a0d76c2fec04a6a14b16a64f9f995e740211ab9c14407e52f14b9a7ae6f594583eb19154bc1ca1adb317f73cfa05d435c6e0e11952ad1cd58ea0b5e2cdbf446304acaa9f89d2becd0116a2dca641ea0836e6fe63ce4ce3f3285aeb4558a50219d97e8f11252ad2c7f318baf9aa61280b94bfe4c811684b5d9031bffa415ccaf80d0735f32964d88e5d6a271044fe0d411a214e49cbb9df9d2bea9dc774d54a56a60c353aa986cc2eecb6a76c95716c016daab20281f84aa983579ec45ab072f1fb9e6560b7cc6085dbf01ee1b896130932d66ab8a42a6ed47644b346d1279035ee0f43a508b75030085dafaa72242c5c4b41b31c0c30c6939800900498b659936e00f98393d2f23f73f8601ee095702b87f6a0a957236cc35313052b73761b59cd44161c7f94bda8e40533581c2d2af31d1a7b23f50d2faa657c4a3cccb37d8d462830186fe679ce0d8c6792355985476aeebf884b5897c25f364f2ef50d1e80a8a7a8ef37daac2c34bf653f30395b59210db2e1a885ebda1b895c4c05b32f40551265fbf88d5a3a9a2fc87894c5032237ec836d16f43c2e55ac395bfa910f3f458b16abcd620a64731ac63a072a352a0e89a6c7d4c30a4ba12353115ad8ac6229fec13973e4a19845d3258787e2ba3894bda8d84ba21e885a05de638b3e53e6039604e6fc0940ac62e8ae350a0edc5453c9b97d8992bfdea28cafd68cbbd467104635e52361af3651326efe2d6fd45f54d2f93070fe2c1ef060e7da0b9c76563cc5349518fb3370555c29b231e1b3770a7b5cfb4c6abd54226042cccbfbe657ee06d74b80ca2d03fb6172b40d21f50a1b915654678da95fecb96b016f697c1c4f1ae749bab75f453a6174d2f002be587d74c27c973bf8aa5a86a06ba960113819f58eb8fa99d3731a78677105b30f64bcd8cbc99edcf318a6b7e104b3aaf6cbaf3f128f85478fb8b8a979298ba521c3fbef30c896818ee32c7bd1de313c45bdd5a7f2f32f4d1ee0533baaa1ef0b27aa885bdfee72db004082b92b287f2897bcdaa6b5aaecb1082d2f133f04a3987165c2db7f10c499073fb9bf41c170cda11ae04a41c6cb992dddefecb31a77c18421180a288820576e165aa5878c4c9031ccb98e2cc5ecf11d1f330d02e4711a08aae86c0276550b254a6b8c41ce21ad2364b02bbce44708f34a63a85b30b89630d7f3467b5615418b095e305a304a6fccda6896d1a465f3e733f6cc2a95ff0042028860c12f82970b498992a8aa6182b202c8a580639543bf88dc45644eea9e1104328b751a74edaa1f89d27cc5ccbaad3713d405c99a8f920f489294df2a47df4e828fa53fecc60856055aef12c50b5430b06cb641a6c114317ee63c5ecaff00e22dab76b142a14abf06a367d33701547ee65604728d26c09d1180e52c8aadf9089e29e12a2be6223bd6a352ae1cc8679840cd80073141f504220179e230cb2e9b3b117116c4b12cd705bf12a7b4a8f05f3ee64287269f551e296c96bb84e54f67a4f396c758e068cfffda000c03000001110211000010c7287de5e0253d46cbb942b4a281c11881c6a8984e2b3470dd1bf12369ad5a00395777a3e4c5258d73eb4af43a240e6e5a152b02efb4ba175c817dcb68562ee22085b381649819ee3472edffc4001d110101010101000301010000000000000001001121314151711061ffda0008010211013f1057a205f2f127bc0bee97772f108327790fa421d208c23a8203dbf23f826f64d839247da0b36cb39b126109eb28e168ec29e137a6d3f11a648725b7e43584a51be168632be48f8b160583588e4eacedc23fd58fe5acb32d747cdfad677597dc6ad98c17b9c4983597e0c40cec2b67f53b09f371fc7237970d23ad8c696e7201eda4bf56dbf26fc0473d9e6040349c581b65b676f2a4e0ef6d3132cb3fffc4002211010101010100020201050000000000000100112131415161817191a1b1d1f0ffda0008010111013f10f65b20eb7b63fcde216fa15d263f88fd4fee72e1084f98c05aa4fb2c9f4d95fbbbf326fa12fb8466da3297d4fbb2c65fa8fca7e7b317d90721204d8e9ea4708c7cce3d631e598cd89e902fb613b6290dd602d873a477d21227770846bb603fea02edc3ce4fe36fe65bdc9eb6e7b9ff007f5833f480ebe2173173e13836026e4a25db9e324581d8bd65278b8a3fb405b3c2c7d4af8b874f6e5901ae5bb966c10309002d091e253ec9c80fc40bf6baf23bd24d2696b6fecb2c8cc84dbd659ac1d3b6c9ffc4002610010002020202020301010003000000000111210031415161718191a1b1d1c1f020e1f1ffda0008010000013f10ff00c3cc39737d19e45ab0647b09c85545649e53a4f45f2f18ab5991b792808e1a26fa8a1ff4e76dc2d527b85b1f1eb158fa84118e27ce25c082412fcb2986c44b4a4fc81aff00d604003dc1fafce0607bcc3800ebad5e6d9701edf83ef1d079d1b77800258e93278329212a0462511713723f3ace58f72121132d3f8c9cd1115cf1698e0520e54d811b46e571b1222469493c58d7bc911920101809752c54c420e10d1f18a5f922080d46ede9c769d47a83ba7461bbd0a4b88f2be7240947836ea9855e1021460d4064c142a694de5c0a0454fbf5977adba835590527886a29b9dbd466a5924023cfde34cd0abf29fe6f2832256c1a159c2814bc363b7ce20c0390a7676f8c6eed1d3ccf070c114492e97a08e1c7b7a6b58a7b48de4c150425a3a372ac61155c036a5877e71c0322696a98624e7245883a2ea9d19deda8242486eef74643a4151083c8133e5714cbe481be12b778202f8041fbc445853a873091eb1c39002ca764fa64bce0a0edcc4d562225062cab4004a7eef242a10c8491881cbbea72610c4a91e638c695054565f264a212eba8afd5628a941483c6222d015471dc7ac9edac028ca122c789cb8e42343978bf59167fb491264e4f7d6f0c96e384db6add992b34a0e1604044bbcd41c316f62edc5d1c02c92c762b95001112533fac999c04d3bb80325e15eecf88c88901190b2992f786306126f66d08e0844519ac34113383d8152c36c2d7a9e7d63428312949f9ca26a8b1daf8c839b1351adfdf8c881a8051cfa1f18801106ba783204a1897938f8c2a0a480c8f323c6cc818dbabd430e135091440d1dc133192e06121887b619ac817205d49ab8e30daf7e684700237909b520100ba8c7c6486584a84d0b3c4983ea2dba0d499644764e7100ae69a6cc6cea3041ba052ec49af3923c410790a41fe64970d8a00a7d7ef2703816b0172d20241893bdfe32d0ee8b1f418fe398ab33c8eff0018a2a4505a761e714c9be1a6ae412379e01c7f05cb3a15dd702fb8c8a0370b03b3a225c96a645a87170ed7095772886d44830c9109280f1cfce0f7df354d7ac0e6483407305a878c0681490d7561038080a2747cb5be3d642834405513ca38e65c68d390930402c7c94635ca108c09617f558e04817c937591a0c21bd7307192a404ce0be7833618aba13d62d59d237ecd6411adb8b90ca3eb11ae0203b38273c64d7d5ad5f491a9c5c0d1d15e6ea4aa5c5969040236c05b8ad2aa8c8bb181e4de3f51a3ca7925229bf187278b01761411cfce2354ce8abfb446f069260800c744a35f3850d20307c9eb19497b22fe719b5299c83b10bf2de1d43c1cdad8721e300ba982d3626d0ef109886e13e86dc099f080958a669d24a09fbf3916f96112e02374859eb1ad48c29ab3c215ef27107120e8a53d464903aa442016f098a0c91bb888eb594fa52922354e3950eda4ea449f0c8e0f1393c20c4bf384cbb84124722cf7d654580085146e3c8ef085948820f0d78c9454302c554852f775892a6c1895fb3f98a52146752d889ffa7159212741bdbfad6001a6922f21d3ce522ea89f3b1d4e4555b29260386dfac1d6a88480e0661c34e0b04627507fb902a802aabe932cb6117374a85a1f8c12a4f3d3076246dc06c787206896a426c6f036216d93b071c645958525ea67de4902171c278bbc29b0e234d0274bae630812c2d0b0d2bff718bed2002dc808bf0e311a12c077627e706c353cab8994acfe324f7f48895a316f8f9c56ad2151e480bf9c07a4f49953275ac844204bc81ebe358e8f604bc2962e3596bc52d6e8800ebf5872ea90dccc2579b75182a09818f56d30ceb17148ca94504f2fb9c8c5254500a3e9803104dfb019a3893000b9cf07b22cc08e4828f5b5753900800a80dca6c7b9c54948806350d5f6733859e8a2042aad92e4ca709c02a457644de270630470a18589a272845ab6e480dbd28e058c59c292d428f8c1f854cca924a4f78db9f0541703475cf0e3b04ced1e7c0f4c8388a055d83627ff0032b9492aba92d8c5420b010b32845ee49ce3b2b8f822888c1ea8487401db803a260041db4b905b76b2e859c1624b4c8a083012d5e4b4922f0fae075aac282a15340480b1a8c64d501902d100f18b57ac8d083a3b6306a281d3b495f583e163060d943f2c6ae9d58049a035373842a693a25554e1b8d62aa59a00104afb58c74ad93647971788714b9118f1807f2cc0258f4cfac7c4fb811a2d6c5cd6f18f28583bd895f78d13624663e510318a84621266a048676c94c09fa3a0183371151e0460e729292050a3ac35b8835174ac97ac944efbca37b90f38e875257b09027cf39340aa8b51220efce445dc8269a435f7ce032e911dcbb38153db525d780f58805674129b4b87bbe72b5aa924262766fc560a9e277ca84a8e7152e96140ecb8c76bb61093c9dc44e0e3182464e5bb9586705a94482cdf8f9c8176126a3aa5e40fa136b3a6261ac8a3888b0ea25499558aac48ec2483db01ac42330a24e8268be5d65bb1ca1c024b2055a5e03310d1135096933fccd1f2da856c5a277ce1e4b40c33285d5edef20109cd6e43e28b431180a489380bdfac6be024807494beb20e9d1798686686f518baa01d43710ff98d0e70b29b98f96558a0495ec89832ed190917b31c7ea8e48bc0e0052900910234477d602054f7c895b8a9b0cd4224640c5b92883253fb6b4cbc4e058415f0a208877bf1818a8a17937a6a758688120c926cbc7b7782a0348a048110edee305339c053ed663bc7011702a3b9a98f392000996ddab68759a63f2d3433b7c07179b626108eb963f73934be40eee557de430d808f08d597ef130446d30ee10899f56e5a7475c11c188526220b3287b9f9c8b6ab06b2c9ac471e0cb44644dd15a4365c8e8f196856db6783a300c181358e98969d95900e198600a4a224fc9ac484843083c8b6cf58ce709d2ba41a086f8645e312a15c0cdff3070a91583e4603db19c2d65b4e60c877ac44f1f1aa1e5ae30619e12f062990f0de422122d3547003ce1b1a8e423d49d732e0a499507960816f71f1888dee08d8412c3def0ea0d01072c21f4611508ed8825f194304a13ce0e4f4dc17d6b1c906bc76a958b32e45861584dc1d62c8aa169ab7ecf1948c00f4c200a99035962b91124c203778214e4f9a6f21858834ea41c489faf9c8a00a190f5e5c406e46419d37f5eb111961892a54be9a4e30e5e0df4a2860138300ec0305ef97b3814104416fbc54168e6300202def249b5219010463d6445dd9f0700f11cb0a623ce56b2229ba0edef1d14651881e4531deaaa0442cd9c7bc9864a658cf3c143427abe72106828d7fdef2101bdabdb44fcb8ca0aa8806e8bfbe3240232268f2c95f6e2310d4083c598214d04c62ecda744ce458831153c3169f590bc304501a2b8c8508bcc1ac97e00e52606301cc64d0ceb218889ca3e5358a5c51ac26c4b0f1bc99ab34713ca61d3a4f05e04aa90c08a603c980090031e48c2156a09860a3ca98cbea5fc626a1d8e1193207249582d5703e7174889051ac0e8787156c0418a5b9e6b122314abf5afde54cdaed1e3536412e12258804d60a6af0835f58465a298af8c6b45dcee72ce80e35387b932f49c9e7056d334a5b1350ec73601820e6ae8fad464e8104b45d0718ac09a58041643def256599a03238d74e146bac066f576016746068e01407097da8255886701772e9c6953b14992b256d8207a7face1f1cba5f9ca6128a2b6ca539e17b64a54e5c6214819ba2300a11adeb13620c2cb604adf67195c20b0440f19488cd463e8bf80c0d2f3a44a92dfab707330d5238ebd61415c03b9bff007255e6b90085e90627470828178d0ef23d95523ce2b7c185b37126194f3bf1922682d01c0ed6562723aa82360eae75888930a20281e8c5d6486017920a89eb05fdcba8fea4d6048806d8217ccf79cb01a0989c44d0c8e9c0ac2bd62cc0500c3392590041de1c65c45a6bd2179627c6b2fc649e195221ececc5f820038da6963ac0945d27a2582ccf7266b2ff001af38f4511b07411279c05d40c9251152c3afce0f27daa948f449ce7000676d7f337107d475e273fffd9);
-- --------------------------------------------------------
--
-- Structure de la table `etudiant`
--
CREATE TABLE `etudiant` (
`CNE` bigint(20) NOT NULL,
`ID_SEMESTER` bigint(20) NOT NULL,
`NOM_ETUDIANT` varchar(20) DEFAULT NULL,
`PRENOM_ETUDIANT` varchar(20) DEFAULT NULL,
`DATE_DE_NAISSANCE` date DEFAULT NULL,
`EMAIL_ETUDIANT` varchar(40) DEFAULT NULL,
`MDP_ETUDIANT` varchar(20) DEFAULT NULL,
`CODE_APOGE` bigint(20) DEFAULT NULL,
`TEL_ETUDIANT` varchar(20) NOT NULL,
`PHOTO_ETUDIANT` blob,
`ADRESSE_ETUDIANT` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Contenu de la table `etudiant`
--
INSERT INTO `etudiant` (`CNE`, `ID_SEMESTER`, `NOM_ETUDIANT`, `PRENOM_ETUDIANT`, `DATE_DE_NAISSANCE`, `EMAIL_ETUDIANT`, `MDP_ETUDIANT`, `CODE_APOGE`, `TEL_ETUDIANT`, `PHOTO_ETUDIANT`, `ADRESSE_ETUDIANT`) VALUES
(1264, 1, 'chla', 'aymen', '2017-05-09', 'sasa', 'sasas', 16548, '', NULL, ''),
(2, 22, 'faraby', 'youssef', '2017-05-09', 'sasa', 'sasas', 16548, '', NULL, ''),
(1254, 22, 'chla', 'aymen', '2017-08-11', '[email protected]', '123', 123456789, '0643462112', 0xffd8ffe000104a46494600010200000100010000ffed009c50686f746f73686f7020332e30003842494d04040000000000801c026700145252725a676d43387a4133515563785747416d2d1c0228006246424d4430313030306163303033303030303937303530303030386430393030303032313061303030306536306130303030613131313030303064303138303030303438313930303030313231613030303030363162303030303730323630303030ffe2021c4943435f50524f46494c450001010000020c6c636d73021000006d6e74725247422058595a2007dc00010019000300290039616373704150504c0000000000000000000000000000000000000000000000000000f6d6000100000000d32d6c636d7300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000a64657363000000fc0000005e637072740000015c0000000b777470740000016800000014626b70740000017c000000147258595a00000190000000146758595a000001a4000000146258595a000001b80000001472545243000001cc0000004067545243000001cc0000004062545243000001cc0000004064657363000000000000000363320000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000074657874000000004642000058595a20000000000000f6d6000100000000d32d58595a20000000000000031600000333000002a458595a200000000000006fa2000038f50000039058595a2000000000000062990000b785000018da58595a2000000000000024a000000f840000b6cf63757276000000000000001a000000cb01c903630592086b0bf6103f15511b3421f1299032183b92460551775ded6b707a0589b19a7cac69bf7dd3c3e930ffffffdb00430006040506050406060506070706080a100a0a09090a140e0f0c1017141818171416161a1d251f1a1b231c1616202c20232627292a29191f2d302d283025282928ffdb0043010707070a080a130a0a13281a161a2828282828282828282828282828282828282828282828282828282828282828282828282828282828282828282828282828ffc200110800a000a003002200011101021101ffc4001b00000203010101000000000000000000000304020506010007ffc400190100030101010000000000000000000000010203000405ffc400190100030101010000000000000000000000010203000405ffda000c0300000111021100000187b85f5bcd1f89cda1e08e6ecfab012a5c42bfb0b38181615582d312ad41ad608579b7343535f78abeae395f69a2f5eacad55076c41a0f5cac196182d415fc55b10999e6d1810a3017b6afcb58070f40f588cf168723c3a33ac688747d08234598e611cfdc389588f60fa4104ebc83b542ceb154bd871650f76ac477025206124664e7381ad034875848f1ec8a0c3be5082d71e18d5f24a55349d234a3aaf13653b290317eaae260d202f9538fd202540cda1ec08db46b2485b2caab4f35a2a956d751d8d4ba563564d15a06ed24ad522be002af4fc5752123e61449122af35ada7bc57dcd15ea9022d424f58fd76c293a88f17067c7860cba62ab004caaafe5e3619c739d6946f2633da36fa352a01b0e54d8235c827946996eaa34819789964619a0ab67bcde810e4d2de731c7e4be8ff24ebe61b1acb0b4726bea644652c686c15ad5da3dc735cb53689aee57de5da533ba4ecc0207cc10197335b2384fa8d2dd33ba6ce696b38a5d6b6f9e392d132934a5e725d0b2a4d2ecdce3d9b7a70991531b38b0ab66d7db5586aee03fceacd377ab9ecabc69103d96336b0b7fffc40029100003000203000202000505000000000001020300041112132122052310142031410624323344ffda0008010000010502fe8e3fa0f00774e3d0652a46777c3d8e79961e0c15a3f5488e6d364c4e9c8743fc4f030ec4861d84c3b04834761c23280a304d581947cdfcd04401947ec9e9f5a62ff7ab82cc62ea38cf6a4820b6ce2e8e269a86a69f5c9ebf70faea69392a4c02cfc718e7a270014f2ca73c899ebe44e7ce5110af1d313579c96a20c550b97af45d7b1a5080d948f244cf4e1b6162c279ee5b264d3027c75e33c4904f1848cf8ca6cd132a88f3d75c551878e0a82a8403f2187c653e338e0ec357b337ae70bc22f5ce3bb4d781d4f621b972eacf4e1254191211549c3cb671c290b3a2b2f27ae39cebd904f91c75414e329c95d7989e01ce71f6f321e9cae19bd1eaeeafb24a225938f400508e1de44d366717a6c9193d8352799a05a394745c7d8181b96680e5e2bd9fea7b7c59d98b2d1b14a76675c751cb47ea15b2338d725afa8b21af2c2ccd8bff00063691e3e9d8b614eccc815197953d42b75c0dd52d6fb00e1ae594c99ec5a55c54a9cd6fd77af8977f439b556e5f5f7429b307f51e0fe5e6f48c8ff3334c3b0cf49ca6f649cfb548591f6759aec502f5aa6acbc257dbe990bfebf708e5136db8fa140c94002aa4ab6167388ac14a5028e7597f148bebb5fea0826cfaeafe5b540c659909094f045b97d86d5aee3d37708af5036b946030a4ba0114c9823168c8128bc764679bb2a1255b7ea410381aaf6d76975b25a67884a90957bd52d0275fc80d692f0c2a9ea4fdcf7cfda19d9933d09023318bf2385e25c71b936633e58ea7080270eeac199f834deb769af6aaedfb01b33194b0444b52b804b15539e546757c34623ee7109cafd85511a043caba1dabb15fae1fb3fdd735fb473af29593a5e5aee31fe1654b62bbf07af0ac1457973e4ca67d9557f60b6c0853676c36c2fce7e3f4dbc77f685763da4e25e447167cdaf690a1ad0c7a88bd38ced7a3b13750b34c1cf203d8be9db3c195213f4cb53b51664e443a1adab6cff1df217fadf4fcf1a4ec23a9b4b9574ea8bc6330cf6fbeab7679e97a154006138f36f4639a71d67988e99cf08f6fe575892df6d3ff00bf72f3ae6b5e6f53f005854a15188a2ccba42ca93e01e065a8115c85544f596cebf80e3e3f1f43e69d5f2fdb19d9623fbccf0674f33a7ad2d79d2b3ebea8ca357bc96438ebc6738cdc10ff000cff000a6f0a4b4ae51346246b8f3aaaa94683f3b63b4e12f5b7e37f1e362b0d1edb47435de94fc7eb669cd12607f1e39cadd62e36274cff00715cbb3afe3f4ff20b581d7ed3ff00d28ec99f538edce6ac390aa5470d89a3261bba7d134d91b5867f80bce1fa8698ae2c66b80f5579caf1a695b5487ebab06fd6653f35835053b6b3e9399d4b3b27ffc4002111000202010403010100000000000000000001021110122021310304411332ffda0008010211013f01aac2f14dfc17ad27d8bd45f58bd78214123494347e68d3451c158a2b6d6fa2cb68ec7c1a8acbc3e0bbc36451d6253ae08c94b1d89145091589479211ae711d8b0f8352639a876292975859d46a3cb26ca63bfa41d3c418de7925072eb1f3834b650b6a2f1e3fe4ffc4002111000202020301010003000000000000000001021110210312314104203261ffda0008010111013f01524fc2c7cf05f497eb82f097ed97c44bf5cdeac7c8dfa776776291dfaf83e46cec7665e2cb1163621e162f08b297d293f0d2f4491d7167a2558425585a1bcc78db2717064742d0e4596335884b5472caf47f848d165e3c12b141c4507c8f44a2e3e94484562d9c08b426be1c8ae232485a2f0887228fa33eec734bd3b58f6bf8cb3cdfd8ffc400351000010303020404050303050100000000010002110312213141132251612332718104104252916282a1203372304373b1c192ffda0008010000063f02ff00432614de21080b9623aacb965d2a40e52b60846145ce0b94ca02cfcac387cf242f32e5cffe2905a1739ccf550419f543ff0057316b54b9e49ecb475db4ae7e671fc05840159f9117410ad73a495391ecb1ed2b531fc237b8928dedf4ca2584b87452c2defd944bb4ce251b8182bc375314ba6a5795f3d828735f7bb40a6daaf77d4764d0ea475c2b1ada6cf75e76fb05ccf323a23e5f57544e2f34e47d8839ad7b49c07b88479c06ad25dff4a202eead74903aecb94a0461dd53dce7baf1a841ce63809d094e2c14f9446360a6f88e8d5c4a85d24c33d111e21df55fd98f550594fd508e123a7e50d2e9fb754de2da1a7cc0353c52a00c8c1400754016160c2ebeab948074211d485841dd35f446c0d23ba80ea61872e41b7b75e6c28e2120746a9f13dd132f1daf50477cad07b05d90b7f945b51f59a0ec4056f19f4e98d24492b489d16028017741f7f68e8b72119b90856f2c8fb90b4327d3747cd7690d5915277e55cb207ac2cb587b9ca26e6117142da873d02278af3d97d4fe9cc831d74b79ed7bf9535aee17363cb80a7a2dfd1087b4a9763d11f2c141cc0e9850e2dc8990bca31ba25a254baa1f62832e683d672acb8ff942b58daaf1b94d6db13fab28431ac3acb57315a85cbcede88db4a0fe11616b41d0973911129b1ca4f4c2d500fd06e13b8ad6ce97830bc604bfd51707973db9b2134b80cf4c04e8c3bd506901fba07c218d15cdaa83cbfd61121d0e1912549a86f8eb0ae700f1f92a7cac1b230f0d9fc2e63b7442adae34c7d51013ea169b27542d6481a95b37d53eec03ca15a3ca7757d4c3da7065716813c43d1bb21c3b9cefd611f0b5e8506556b9b54080b2e6ba33696a90fa433ba6da28bc1c177458b4f5202f08b38719b99a2792d6d5e5fa1b10b0ca8d23609c386eb8e45c1002ad174f99a53994fe9e528d3e231cdb672342bcdcbd611e0c3ddd5438e4ee55ad836892ae061c3a2b6a3063f0a1818d8fbb2b06a98d20a976badce185804d6dad6e13c5ede23f5a658b86d152c03ed1a26b43aa705d8feda78352ab3e1e98987084d142839cca7bcc4abbe1cdb5758d0fa2c9a83f7287b29fe1134fe29d251e30a5c38d86573389a7b764394883ba6368d324acfc383f850ef86e16e4daa038c1c4872735b52a9dba8944b5d53f7355bc40e9ce5ba204fc4516c7da11b8b6a3be9396950f639e67524c27bc52b87db769dd00c8e71a07cc2d117d1d75579665d9828b1a22460ca6b4d36388e90835ee3f95e29bab93d5536b8c6e70b5910ac0e130a002e1d91e58037721670cfe9051b9cd68d64a2d2e641e832b9ae11a39add172f143a35515293a48d065470de1e3b2b831f68ea9c194ee91bab6a30873f97d91229968da1fa2c63792e43a9dc655a5a1a7fe9710dcf6b063b950e8696a86b8389eca29fc39118d375e33386d3a34cac3a992eea51024f768d5431bafb9fc2f10b437fe358c0f55cd55d1d41534dd57d480a78b5074d93c0aee2088f3046cb5c07546a5439023d11b88d57298c6b12a388ccf64dad529021e61b22536d8ceb22253dd4fe1eab49112cd1713ca670162e2e6e5bea8bbe2e93cc22451e1ddb9d978d55b03d94d16000ee70bccf3dc086a710193aeba2e627ffb0beb0ddb953581cca8d3a9332d57536868dcb7758d1715ee0d6ef2a69791a2dff250fa33d20a05b4f4dc04d7f85d23edf440b417fee46e7981a0d5539fab79dd45205cf5c9461ad3abdc9a2a3b13914c4ff2b0207ebc9465c6d1f5bf2b91c5ded85301dd86ead2df4e509c1d51ecf46e4277339db4bbe5e685e2d473be76def667109f55b55f255e6eb271272535b0e0c71928358d10decb98a33755eda34225d0e819b7002a90c75479d09d14d774b7ec180a07cea54111f2612d92e6ce5cbfb3fceea0fc311ee5603c7ee46130168749882a29b1edcfdc8328d3c01e6857731c68a1b93e88873944beaf6d1a10e2cdbadba28d07ca4831e8a654b5cdca7834aa34807fdcc1f935823075403f519195059a6e0ea9e4b4b6d19f902bc3f39c03ba863ef3bfaab4e9eaada6d303a68800489c98feb7d3a4da8ee98c27bbe20dd55de5ccda9eead9749d30aad368d30b5a7746fb2cbae1ea8da66599c22d1aaa8da92db46c855a62da33aa2e73dc67baf33ff2aca66437fa63e208674eebc3a8d3d72bc0a7fb9f809ed07c66e491a29a821e3541dee5567b896cbf042bb0f9f746dcf51109f88b5a531f4cf8866531f7069220ca00435a3e90a6e781d9ca69bdf8d894c7531023fa45ec0e03ee586307b7cb875013dfba78a7e25289938527ed405cd33f4ce1016c1fb94b6ad48d0894f1c4bd8719dd346c806013dd7fffc4002610010002020202020203010101000000000100112131415161718191a1b1d1f0f1e1c110ffda0008010000013f21a952a57ff152a54768876cd80f6b8ee08f3aa9774c5b307ac0ecfef333df33afa9f1c60a81b7e06a53469cceb43dcaf037f0d3b85258fd26f47ccd92a2d23db3b6fa2637c915967055aca0a03230ff0021e690f28c006f683fb986d06f8d92cd5381cc0aa55b5b332a5eb240a9a55d5de7ea2379932ca79f519b1c6e0d2b6f640964f0db2eaba178d2645e12ce51069814d62d2903ce0d4c08712a1ca4b41b403a657a8f0f3a9b253cb25dd455e00fbbdcc577aaaa41800b64bf73332eebd3c13001e86fef3036e1d315e558ff00847f0c82156988d14afe084656d39afcbb89e31751f0427b167ccfda4d7a5c0e841aad4e40e1511f28b0e905bc4cdb3d13f70b5d7a42bd4a9214c11f304bce4dab67510b75cb9f5f33101a866d2a52f90607cc2dc0f64d88785c402858176c66dcdea2f68567e30c87b9b5955636f36b19a20d8603dcb8baeb2dc54193d1b99be1c459569816fdc0a5599cbb96050f966650c6437266edc1bd1ab965aacf8151cbe9443416c670d4704d58347e6548d5365dca311d64258e7c31305c6eace3539f13a8f888be18d03dc014468ad1c4079bc41c87c38216317a6596d996dc7d233f09999321e298162d9e77330216add15c4d6fedc7d12b72fc4153031140e1f886fd0d94d92d8e4ae540a5c00fe237c8c66aa82485eda830d59a3a77043c00251d626292af5810517e9b8edaee6e6499705d52b17769e5772b3e761cfcc4895451dc587cc81bbeb894a48dc5bf5e65656065cb2bd14d689803cc3cd1e52d4c0c7e221ea85c65eee22a4f15be90c58a80cfa7b850169bc254c72bbdcc0d475d3dfa8fd2e65e1ed61ed02c58fccb9a0da1888a1b01c5e61d8323bed96009a361e7d426cb4acafaee57ad5a5dbea04c19574cd3729c2910c0be2a2bcda33924136deebfda94df5b76d710ba12b05e332c069c587c31f9d84b732c7b3abfe21c8574b93db1703f00fb98a42c662e08704ccdf983404e5fa90749db333f1292bce3312de0f92c0093001d1cb02097c8299b5b154d851a2db2e116dad252df896790a0d76c2fec04a6a14b16a64f9f995e740211ab9c14407e52f14b9a7ae6f594583eb19154bc1ca1adb317f73cfa05d435c6e0e11952ad1cd58ea0b5e2cdbf446304acaa9f89d2becd0116a2dca641ea0836e6fe63ce4ce3f3285aeb4558a50219d97e8f11252ad2c7f318baf9aa61280b94bfe4c811684b5d9031bffa415ccaf80d0735f32964d88e5d6a271044fe0d411a214e49cbb9df9d2bea9dc774d54a56a60c353aa986cc2eecb6a76c95716c016daab20281f84aa983579ec45ab072f1fb9e6560b7cc6085dbf01ee1b896130932d66ab8a42a6ed47644b346d1279035ee0f43a508b75030085dafaa72242c5c4b41b31c0c30c6939800900498b659936e00f98393d2f23f73f8601ee095702b87f6a0a957236cc35313052b73761b59cd44161c7f94bda8e40533581c2d2af31d1a7b23f50d2faa657c4a3cccb37d8d462830186fe679ce0d8c6792355985476aeebf884b5897c25f364f2ef50d1e80a8a7a8ef37daac2c34bf653f30395b59210db2e1a885ebda1b895c4c05b32f40551265fbf88d5a3a9a2fc87894c5032237ec836d16f43c2e55ac395bfa910f3f458b16abcd620a64731ac63a072a352a0e89a6c7d4c30a4ba12353115ad8ac6229fec13973e4a19845d3258787e2ba3894bda8d84ba21e885a05de638b3e53e6039604e6fc0940ac62e8ae350a0edc5453c9b97d8992bfdea28cafd68cbbd467104635e52361af3651326efe2d6fd45f54d2f93070fe2c1ef060e7da0b9c76563cc5349518fb3370555c29b231e1b3770a7b5cfb4c6abd54226042cccbfbe657ee06d74b80ca2d03fb6172b40d21f50a1b915654678da95fecb96b016f697c1c4f1ae749bab75f453a6174d2f002be587d74c27c973bf8aa5a86a06ba960113819f58eb8fa99d3731a78677105b30f64bcd8cbc99edcf318a6b7e104b3aaf6cbaf3f128f85478fb8b8a979298ba521c3fbef30c896818ee32c7bd1de313c45bdd5a7f2f32f4d1ee0533baaa1ef0b27aa885bdfee72db004082b92b287f2897bcdaa6b5aaecb1082d2f133f04a3987165c2db7f10c499073fb9bf41c170cda11ae04a41c6cb992dddefecb31a77c18421180a288820576e165aa5878c4c9031ccb98e2cc5ecf11d1f330d02e4711a08aae86c0276550b254a6b8c41ce21ad2364b02bbce44708f34a63a85b30b89630d7f3467b5615418b095e305a304a6fccda6896d1a465f3e733f6cc2a95ff0042028860c12f82970b498992a8aa6182b202c8a580639543bf88dc45644eea9e1104328b751a74edaa1f89d27cc5ccbaad3713d405c99a8f920f489294df2a47df4e828fa53fecc60856055aef12c50b5430b06cb641a6c114317ee63c5ecaff00e22dab76b142a14abf06a367d33701547ee65604728d26c09d1180e52c8aadf9089e29e12a2be6223bd6a352ae1cc8679840cd80073141f504220179e230cb2e9b3b117116c4b12cd705bf12a7b4a8f05f3ee64287269f551e296c96bb84e54f67a4f396c758e068cfffda000c03000001110211000010c7287de5e0253d46cbb942b4a281c11881c6a8984e2b3470dd1bf12369ad5a00395777a3e4c5258d73eb4af43a240e6e5a152b02efb4ba175c817dcb68562ee22085b381649819ee3472edffc4001d110101010101000301010000000000000001001121314151711061ffda0008010211013f1057a205f2f127bc0bee97772f108327790fa421d208c23a8203dbf23f826f64d839247da0b36cb39b126109eb28e168ec29e137a6d3f11a648725b7e43584a51be168632be48f8b160583588e4eacedc23fd58fe5acb32d747cdfad677597dc6ad98c17b9c4983597e0c40cec2b67f53b09f371fc7237970d23ad8c696e7201eda4bf56dbf26fc0473d9e6040349c581b65b676f2a4e0ef6d3132cb3fffc4002211010101010100020201050000000000000100112131415161817191a1b1d1f0ffda0008010111013f10f65b20eb7b63fcde216fa15d263f88fd4fee72e1084f98c05aa4fb2c9f4d95fbbbf326fa12fb8466da3297d4fbb2c65fa8fca7e7b317d90721204d8e9ea4708c7cce3d631e598cd89e902fb613b6290dd602d873a477d21227770846bb603fea02edc3ce4fe36fe65bdc9eb6e7b9ff007f5833f480ebe2173173e13836026e4a25db9e324581d8bd65278b8a3fb405b3c2c7d4af8b874f6e5901ae5bb966c10309002d091e253ec9c80fc40bf6baf23bd24d2696b6fecb2c8cc84dbd659ac1d3b6c9ffc4002610010002020202020301010003000000000111210031415161718191a1b1d1c1f020e1f1ffda0008010000013f10ff00c3cc39737d19e45ab0647b09c85545649e53a4f45f2f18ab5991b792808e1a26fa8a1ff4e76dc2d527b85b1f1eb158fa84118e27ce25c082412fcb2986c44b4a4fc81aff00d604003dc1fafce0607bcc3800ebad5e6d9701edf83ef1d079d1b77800258e93278329212a0462511713723f3ace58f72121132d3f8c9cd1115cf1698e0520e54d811b46e571b1222469493c58d7bc911920101809752c54c420e10d1f18a5f922080d46ede9c769d47a83ba7461bbd0a4b88f2be7240947836ea9855e1021460d4064c142a694de5c0a0454fbf5977adba835590527886a29b9dbd466a5924023cfde34cd0abf29fe6f2832256c1a159c2814bc363b7ce20c0390a7676f8c6eed1d3ccf070c114492e97a08e1c7b7a6b58a7b48de4c150425a3a372ac61155c036a5877e71c0322696a98624e7245883a2ea9d19deda8242486eef74643a4151083c8133e5714cbe481be12b778202f8041fbc445853a873091eb1c39002ca764fa64bce0a0edcc4d562225062cab4004a7eef242a10c8491881cbbea72610c4a91e638c695054565f264a212eba8afd5628a941483c6222d015471dc7ac9edac028ca122c789cb8e42343978bf59167fb491264e4f7d6f0c96e384db6add992b34a0e1604044bbcd41c316f62edc5d1c02c92c762b95001112533fac999c04d3bb80325e15eecf88c88901190b2992f786306126f66d08e0844519ac34113383d8152c36c2d7a9e7d63428312949f9ca26a8b1daf8c839b1351adfdf8c881a8051cfa1f18801106ba783204a1897938f8c2a0a480c8f323c6cc818dbabd430e135091440d1dc133192e06121887b619ac817205d49ab8e30daf7e684700237909b520100ba8c7c6486584a84d0b3c4983ea2dba0d499644764e7100ae69a6cc6cea3041ba052ec49af3923c410790a41fe64970d8a00a7d7ef2703816b0172d20241893bdfe32d0ee8b1f418fe398ab33c8eff0018a2a4505a761e714c9be1a6ae412379e01c7f05cb3a15dd702fb8c8a0370b03b3a225c96a645a87170ed7095772886d44830c9109280f1cfce0f7df354d7ac0e6483407305a878c0681490d7561038080a2747cb5be3d642834405513ca38e65c68d390930402c7c94635ca108c09617f558e04817c937591a0c21bd7307192a404ce0be7833618aba13d62d59d237ecd6411adb8b90ca3eb11ae0203b38273c64d7d5ad5f491a9c5c0d1d15e6ea4aa5c5969040236c05b8ad2aa8c8bb181e4de3f51a3ca7925229bf187278b01761411cfce2354ce8abfb446f069260800c744a35f3850d20307c9eb19497b22fe719b5299c83b10bf2de1d43c1cdad8721e300ba982d3626d0ef109886e13e86dc099f080958a669d24a09fbf3916f96112e02374859eb1ad48c29ab3c215ef27107120e8a53d464903aa442016f098a0c91bb888eb594fa52922354e3950eda4ea449f0c8e0f1393c20c4bf384cbb84124722cf7d654580085146e3c8ef085948820f0d78c9454302c554852f775892a6c1895fb3f98a52146752d889ffa7159212741bdbfad6001a6922f21d3ce522ea89f3b1d4e4555b29260386dfac1d6a88480e0661c34e0b04627507fb902a802aabe932cb6117374a85a1f8c12a4f3d3076246dc06c787206896a426c6f036216d93b071c645958525ea67de4902171c278bbc29b0e234d0274bae630812c2d0b0d2bff718bed2002dc808bf0e311a12c077627e706c353cab8994acfe324f7f48895a316f8f9c56ad2151e480bf9c07a4f49953275ac844204bc81ebe358e8f604bc2962e3596bc52d6e8800ebf5872ea90dccc2579b75182a09818f56d30ceb17148ca94504f2fb9c8c5254500a3e9803104dfb019a3893000b9cf07b22cc08e4828f5b5753900800a80dca6c7b9c54948806350d5f6733859e8a2042aad92e4ca709c02a457644de270630470a18589a272845ab6e480dbd28e058c59c292d428f8c1f854cca924a4f78db9f0541703475cf0e3b04ced1e7c0f4c8388a055d83627ff0032b9492aba92d8c5420b010b32845ee49ce3b2b8f822888c1ea8487401db803a260041db4b905b76b2e859c1624b4c8a083012d5e4b4922f0fae075aac282a15340480b1a8c64d501902d100f18b57ac8d083a3b6306a281d3b495f583e163060d943f2c6ae9d58049a035373842a693a25554e1b8d62aa59a00104afb58c74ad93647971788714b9118f1807f2cc0258f4cfac7c4fb811a2d6c5cd6f18f28583bd895f78d13624663e510318a84621266a048676c94c09fa3a0183371151e0460e729292050a3ac35b8835174ac97ac944efbca37b90f38e875257b09027cf39340aa8b51220efce445dc8269a435f7ce032e911dcbb38153db525d780f58805674129b4b87bbe72b5aa924262766fc560a9e277ca84a8e7152e96140ecb8c76bb61093c9dc44e0e3182464e5bb9586705a94482cdf8f9c8176126a3aa5e40fa136b3a6261ac8a3888b0ea25499558aac48ec2483db01ac42330a24e8268be5d65bb1ca1c024b2055a5e03310d1135096933fccd1f2da856c5a277ce1e4b40c33285d5edef20109cd6e43e28b431180a489380bdfac6be024807494beb20e9d1798686686f518baa01d43710ff98d0e70b29b98f96558a0495ec89832ed190917b31c7ea8e48bc0e0052900910234477d602054f7c895b8a9b0cd4224640c5b92883253fb6b4cbc4e058415f0a208877bf1818a8a17937a6a758688120c926cbc7b7782a0348a048110edee305339c053ed663bc7011702a3b9a98f392000996ddab68759a63f2d3433b7c07179b626108eb963f73934be40eee557de430d808f08d597ef130446d30ee10899f56e5a7475c11c188526220b3287b9f9c8b6ab06b2c9ac471e0cb44644dd15a4365c8e8f196856db6783a300c181358e98969d95900e198600a4a224fc9ac484843083c8b6cf58ce709d2ba41a086f8645e312a15c0cdff3070a91583e4603db19c2d65b4e60c877ac44f1f1aa1e5ae30619e12f062990f0de422122d3547003ce1b1a8e423d49d732e0a499507960816f71f1888dee08d8412c3def0ea0d01072c21f4611508ed8825f194304a13ce0e4f4dc17d6b1c906bc76a958b32e45861584dc1d62c8aa169ab7ecf1948c00f4c200a99035962b91124c203778214e4f9a6f21858834ea41c489faf9c8a00a190f5e5c406e46419d37f5eb111961892a54be9a4e30e5e0df4a2860138300ec0305ef97b3814104416fbc54168e6300202def249b5219010463d6445dd9f0700f11cb0a623ce56b2229ba0edef1d14651881e4531deaaa0442cd9c7bc9864a658cf3c143427abe72106828d7fdef2101bdabdb44fcb8ca0aa8806e8bfbe3240232268f2c95f6e2310d4083c598214d04c62ecda744ce458831153c3169f590bc304501a2b8c8508bcc1ac97e00e52606301cc64d0ceb218889ca3e5358a5c51ac26c4b0f1bc99ab34713ca61d3a4f05e04aa90c08a603c980090031e48c2156a09860a3ca98cbea5fc626a1d8e1193207249582d5703e7174889051ac0e8787156c0418a5b9e6b122314abf5afde54cdaed1e3536412e12258804d60a6af0835f58465a298af8c6b45dcee72ce80e35387b932f49c9e7056d334a5b1350ec73601820e6ae8fad464e8104b45d0718ac09a58041643def256599a03238d74e146bac066f576016746068e01407097da8255886701772e9c6953b14992b256d8207a7face1f1cba5f9ca6128a2b6ca539e17b64a54e5c6214819ba2300a11adeb13620c2cb604adf67195c20b0440f19488cd463e8bf80c0d2f3a44a92dfab707330d5238ebd61415c03b9bff007255e6b90085e90627470828178d0ef23d95523ce2b7c185b37126194f3bf1922682d01c0ed6562723aa82360eae75888930a20281e8c5d6486017920a89eb05fdcba8fea4d6048806d8217ccf79cb01a0989c44d0c8e9c0ac2bd62cc0500c3392590041de1c65c45a6bd2179627c6b2fc649e195221ececc5f820038da6963ac0945d27a2582ccf7266b2ff001af38f4511b07411279c05d40c9251152c3afce0f27daa948f449ce7000676d7f337107d475e273fffd9, 'ensias');
-- --------------------------------------------------------
--
-- Structure de la table `exam`
--
CREATE TABLE `exam` (
`ID_MODULE` bigint(20) NOT NULL,
`CNE` bigint(20) NOT NULL,
`SESSION_EXAM` varchar(20) DEFAULT NULL,
`NOTE_EXAM` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Contenu de la table `exam`
--
INSERT INTO `exam` (`ID_MODULE`, `CNE`, `SESSION_EXAM`, `NOTE_EXAM`) VALUES
(3, 2, 'NORMAL', 15),
(3, 1254, 'NORMAL', 15),
(4, 2, 'NORMAL', 19),
(4, 1254, 'NORMAL', 19);
-- --------------------------------------------------------
--
-- Structure de la table `filiere`
--
CREATE TABLE `filiere` (
`ID_SEMESTER` bigint(20) NOT NULL,
`ID_EMPLOIS` bigint(20) DEFAULT NULL,
`NOM_FILIERE` varchar(255) DEFAULT NULL,
`NOM_FORMATION` longtext,
`SEMESTER` varchar(4) DEFAULT NULL,
`CHEF_DE_FILIERE` bigint(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Contenu de la table `filiere`
--
INSERT INTO `filiere` (`ID_SEMESTER`, `ID_EMPLOIS`, `NOM_FILIERE`, `NOM_FORMATION`, `SEMESTER`, `CHEF_DE_FILIERE`) VALUES
(1, 1, 'GL', 'Génie Logiciel (GL)', '1', 1),
(3, 3, 'GL', 'Génie Logiciel (GL)', '3', 1),
(2, 2, 'GL', 'Génie Logiciel (GL)', '2', 1),
(4, 4, 'GL', 'Génie Logiciel (GL)', '4', 1),
(5, 5, 'GL', 'Génie Logiciel (GL)', '5', 1),
(6, 6, 'GL', 'Génie Logiciel (GL)', '6', 1),
(7, 7, 'eMBI', ' e-Management et Business Intelligence (eMBI)', '1', 2),
(8, 8, 'eMBI', ' e-Management et Business Intelligence (eMBI)', '2', 2),
(9, 9, 'eMBI', ' e-Management et Business Intelligence (eMBI)', '3', 2),
(10, 10, 'eMBI', ' e-Management et Business Intelligence (eMBI)', '4', 2),
(11, 11, 'eMBI', ' e-Management et Business Intelligence (eMBI)', '5', 2),
(12, 12, 'eMBI', ' e-Management et Business Intelligence (eMBI)', '6', 2),
(13, 13, 'IeL', 'Ingénierie e-Logistique (IeL)', '1', 3),
(14, 14, 'IeL', 'Ingénierie e-Logistique (IeL)', '2', 3),
(15, 15, 'IeL', 'Ingénierie e-Logistique (IeL)', '3', 3),
(16, 16, 'IeL', 'Ingénierie e-Logistique (IeL)', '4', 3),
(17, 17, 'IeL', 'Ingénierie e-Logistique (IeL)', '5', 3),
(18, 18, 'IeL', 'Ingénierie e-Logistique (IeL)', '6', 3),
(19, 19, 'IWIM', 'Ingénierie du Web et Informatique Mobile (IWIM)', '1', 4),
(20, 20, 'IWIM', 'Ingénierie du Web et Informatique Mobile (IWIM)', '2', 4),
(21, 21, 'IWIM', 'Ingénierie du Web et Informatique Mobile (IWIM)', '3', 4),
(22, 22, 'IWIM', 'Ingénierie du Web et Informatique Mobile (IWIM)', '4', 4),
(23, 23, 'IWIM', 'Ingénierie du Web et Informatique Mobile (IWIM)', '5', 4),
(24, 24, 'IWIM', 'Ingénierie du Web et Informatique Mobile (IWIM)', '6', 4),
(25, 25, 'ISEM', ' Ingénierie des Systèmes Embarqués, Mobiles (ISEM)', '1', 5),
(26, 26, 'ISEM', ' Ingénierie des Systèmes Embarqués, Mobiles (ISEM)', '2', 5),
(27, 27, 'ISEM', ' Ingénierie des Systèmes Embarqués, Mobiles (ISEM)', '3', 5),
(28, 28, 'ISEM', ' Ingénierie des Systèmes Embarqués, Mobiles (ISEM)', '4', 5),
(29, 29, 'ISEM', ' Ingénierie des Systèmes Embarqués, Mobiles (ISEM)', '5', 5),
(30, 30, 'ISEM', ' Ingénierie des Systèmes Embarqués, Mobiles (ISEM)', '6', 5),
(31, 31, 'SSI', 'Sécurité des Systèmes d\'Information (SSI)', '1', 6),
(32, 32, 'SSI', 'Sécurité des Systèmes d\'Information (SSI)', '2', 6),
(33, 33, 'SSI', 'Sécurité des Systèmes d\'Information (SSI)', '3', 6),
(34, 34, 'SSI', 'Sécurité des Systèmes d\'Information (SSI)', '4', 6),
(35, 35, 'SSI', 'Sécurité des Systèmes d\'Information (SSI)', '5', 6),
(36, 36, 'SSI', 'Sécurité des Systèmes d\'Information (SSI)', '6', 6);
-- --------------------------------------------------------
--
-- Structure de la table `messages`
--
CREATE TABLE `messages` (
`ID_COMPTE_SOURCE` bigint(20) NOT NULL,
`ID_COMPTE_DESTINATION` bigint(20) DEFAULT '0',
`OBJET_MSG` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`VUE` int(11) DEFAULT NULL,
`DATE_MESSAGE` date DEFAULT NULL,
`MESSAGE` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Contenu de la table `messages`
--
INSERT INTO `messages` (`ID_COMPTE_SOURCE`, `ID_COMPTE_DESTINATION`, `OBJET_MSG`, `VUE`, `DATE_MESSAGE`, `MESSAGE`) VALUES
(2, 0, 'La formation d\'ingénieur à l\'ENSIAS', 0, '2017-06-22', '\n- Génie Logiciel,\n- Business Intelligence,\n- E-logistique,\n- Ingénierie des Télécommunication et Réseaux,\n- Systèmes Embarqués et Mobiles,\n- Sécurité des Systèmes d\'Information. '),
(2, 0, 'séminaire au Laboratoire LIG de l\'IMAG Grenoble ??', 0, '2017-06-23', 'Séminaire au Laboratoire LIG de l\'IMAG Grenoble intitulé "...??'),
(2, 0, 'this.getServletContext().getRequestDispatcher("/WEB-INF/index.jsp").forward(request, response);', 0, '2017-06-23', 'this.getServletContext().getRequestDispatcher("/WEB-INF/index.jsp").forward(request, response);'),
(2, 0, 'this.getServletContext().getRequestDispatcher("/WEB-INF/index.jsp").forward(request, response);', 0, '2017-06-23', 'this.getServletContext().getRequestDispatcher("/WEB-INF/index.jsp").forward(request, response);'),
(2, 0, 'this.getServletContext().getRequestDispatcher("/WEB-INF/index.jsp").forward(request, response);', 0, '2017-06-23', 'this.getServletContext().getRequestDispatcher("/WEB-INF/index.jsp").forward(request, response);'),
(2, 0, 'this.getServletContext().getRequestDispatcher("/WEB-INF/index.jsp").forward(request, response);', 0, '2017-06-23', 'this.getServletContext().getRequestDispatcher("/WEB-INF/index.jsp").forward(request, response);'),
(2, 0, 'this.getServletContext().getRequestDispatcher("/WEB-INF/index.jsp").forward(request, response);', 0, '2017-06-23', 'this.getServletContext().getRequestDispatcher("/WEB-INF/index.jsp").forward(request, response);');
-- --------------------------------------------------------
--
-- Structure de la table `module`
--
CREATE TABLE `module` (
`ID_MODULE` bigint(20) NOT NULL,
`ID_ENSEIGNANT` bigint(20) NOT NULL,
`ID_SEMESTER` bigint(20) NOT NULL,
`NOM_MODULE` varchar(25) DEFAULT NULL,
`NOMBRE_D_HEURE` int(11) DEFAULT NULL,
`NOMBRE_ELEMENT` int(11) DEFAULT NULL,
`DEBUT_ENSEIGNEMENT` date DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Contenu de la table `module`
--
INSERT INTO `module` (`ID_MODULE`, `ID_ENSEIGNANT`, `ID_SEMESTER`, `NOM_MODULE`, `NOMBRE_D_HEURE`, `NOMBRE_ELEMENT`, `DEBUT_ENSEIGNEMENT`) VALUES
(1, 1, 1, 'RO', 72, 2, '2017-06-08'),
(2, 1, 2, 'RO', 75, 2, '2017-06-06'),
(3, 19, 22, 'Android', 72, 1, '2017-09-01'),
(4, 19, 22, 'JAVA EE', 72, 1, '2017-09-01');
-- --------------------------------------------------------
--
-- Structure de la table `publier`
--
CREATE TABLE `publier` (
`ID_ANNONCE` bigint(20) NOT NULL,
`ID_SEMESTER` bigint(20) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Contenu de la table `publier`
--
INSERT INTO `publier` (`ID_ANNONCE`, `ID_SEMESTER`) VALUES
(7, 0),
(8, 0),
(9, 0),
(10, 12),
(11, 0),
(12, 35),
(13, 31),
(14, 0),
(18, 19),
(19, 3),
(26, 1),
(28, 0);
--
-- Index pour les tables exportées
--
--
-- Index pour la table `administration`
--
ALTER TABLE `administration`
ADD PRIMARY KEY (`ID_ADMIN`);
--
-- Index pour la table `annonce`
--
ALTER TABLE `annonce`
ADD PRIMARY KEY (`ID_ANNONCE`),
ADD KEY `FK_POSTERANNOCEPROF` (`ID_ENSEIGNANT`),
ADD KEY `FK_POSTERANNONCEADMIN` (`ID_ADMIN`);
--
-- Index pour la table `compte`
--
ALTER TABLE `compte`
ADD PRIMARY KEY (`ID_COMPTE`),
ADD KEY `FK_AVOIR_ADMIN2` (`ID_ADMIN`),
ADD KEY `FK_AVOIR_ENSEIGNANT2` (`ID_ENSEIGNANT`),
ADD KEY `FK_AVOIR_ETUD2` (`CNE`);
--
-- Index pour la table `contact_us`
--
ALTER TABLE `contact_us`
ADD PRIMARY KEY (`ID_CONTACT`);
--
-- Index pour la table `emplois_du_temps`
--
ALTER TABLE `emplois_du_temps`
ADD PRIMARY KEY (`ID_EMPLOIS`),
ADD KEY `FK_CONTIENT` (`ID_FILIERE`),
ADD KEY `FK_POSTEREMPLOIS` (`ID_ADMIN`);
--
-- Index pour la table `enseignant`
--
ALTER TABLE `enseignant`
ADD PRIMARY KEY (`ID_ENSEIGNANT`);
--
-- Index pour la table `etudiant`
--
ALTER TABLE `etudiant`
ADD PRIMARY KEY (`CNE`),
ADD KEY `FK_COMPORTE` (`ID_SEMESTER`);
--
-- Index pour la table `exam`
--
ALTER TABLE `exam`
ADD PRIMARY KEY (`ID_MODULE`,`CNE`),
ADD KEY `FK_EXAM2` (`CNE`);
--
-- Index pour la table `filiere`
--
ALTER TABLE `filiere`
ADD PRIMARY KEY (`ID_SEMESTER`),
ADD KEY `FK_CONTIENT2` (`ID_EMPLOIS`);
--
-- Index pour la table `messages`
--
ALTER TABLE `messages`
ADD KEY `ID_COMPTE_SOURCE` (`ID_COMPTE_SOURCE`),
ADD KEY `ID_COMPTE_DESTINATION` (`ID_COMPTE_DESTINATION`);
--
-- Index pour la table `module`
--
ALTER TABLE `module`
ADD PRIMARY KEY (`ID_MODULE`),
ADD KEY `FK_AVOIR` (`ID_SEMESTER`),
ADD KEY `FK_ENSEIGNER` (`ID_ENSEIGNANT`);
--
-- Index pour la table `publier`
--
ALTER TABLE `publier`
ADD PRIMARY KEY (`ID_ANNONCE`,`ID_SEMESTER`),
ADD KEY `FK_PUBLIER2` (`ID_SEMESTER`);
--
-- AUTO_INCREMENT pour les tables exportées
--
--
-- AUTO_INCREMENT pour la table `administration`
--
ALTER TABLE `administration`
MODIFY `ID_ADMIN` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT pour la table `annonce`
--
ALTER TABLE `annonce`
MODIFY `ID_ANNONCE` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;
--
-- AUTO_INCREMENT pour la table `compte`
--
ALTER TABLE `compte`
MODIFY `ID_COMPTE` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT pour la table `enseignant`
--
ALTER TABLE `enseignant`
MODIFY `ID_ENSEIGNANT` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;
/*!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 */;