forked from blixit/kitjambon
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathnacderneyykitjam.sql
7852 lines (7733 loc) · 783 KB
/
nacderneyykitjam.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
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
-- phpMyAdmin SQL Dump
-- version 4.1.9
-- http://www.phpmyadmin.net
--
-- Client : mysql51-135.perso
-- Généré le : Lun 16 Mars 2015 à 21:07
-- Version du serveur : 5.1.73-2+squeeze+build1+1-log
-- Version de PHP : 5.3.8
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 utf8 */;
--
-- Base de données : `nacderneyykitjam`
--
-- --------------------------------------------------------
--
-- Structure de la table `contact_membre`
--
CREATE TABLE IF NOT EXISTS `contact_membre` (
`mem_id_1` int(11) NOT NULL AUTO_INCREMENT COMMENT 'celui qui entre le 1er en contact',
`mem_id_2` int(11) NOT NULL COMMENT 'celui qui accepte le contact',
`cm_valid` varchar(1) NOT NULL COMMENT '1=> le contact est établi, 0=> non',
PRIMARY KEY (`mem_id_1`,`mem_id_2`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=174 ;
--
-- Contenu de la table `contact_membre`
--
INSERT INTO `contact_membre` (`mem_id_1`, `mem_id_2`, `cm_valid`) VALUES
(1, 9, '1'),
(1, 10, '1'),
(1, 25, '1'),
(1, 27, '0'),
(1, 28, '1'),
(1, 29, '1'),
(1, 31, '1'),
(1, 32, '1'),
(1, 33, '1'),
(1, 34, '1'),
(1, 35, '0'),
(1, 36, '1'),
(1, 37, '1'),
(1, 38, '1'),
(1, 39, '1'),
(1, 40, '1'),
(1, 41, '1'),
(1, 42, '1'),
(1, 43, '1'),
(49, 1, '1'),
(50, 1, '1'),
(51, 1, '1'),
(53, 1, '1'),
(54, 1, '1'),
(55, 1, '1'),
(56, 1, '1'),
(57, 1, '1'),
(58, 1, '1'),
(59, 1, '1'),
(60, 1, '1'),
(61, 1, '1'),
(62, 1, '1'),
(63, 1, '1'),
(64, 1, '1'),
(65, 1, '1'),
(66, 1, '1'),
(67, 1, '1'),
(68, 1, '1'),
(69, 1, '1'),
(70, 1, '1'),
(71, 1, '1'),
(72, 1, '1'),
(73, 1, '1'),
(74, 1, '0'),
(75, 1, '1'),
(76, 1, '1'),
(77, 1, '0'),
(78, 1, '0'),
(79, 1, '1'),
(80, 1, '1'),
(81, 1, '0'),
(82, 1, '0'),
(83, 1, '0'),
(84, 1, '0'),
(85, 1, '0'),
(86, 1, '0'),
(87, 1, '0'),
(88, 1, '0'),
(89, 1, '0'),
(90, 1, '1'),
(91, 1, '0'),
(92, 1, '0'),
(93, 1, '0'),
(94, 1, '0'),
(95, 1, '0'),
(96, 1, '0'),
(97, 1, '0'),
(98, 1, '0'),
(99, 1, '0'),
(100, 1, '0'),
(101, 1, '0'),
(102, 1, '0'),
(103, 1, '0'),
(104, 1, '0'),
(105, 1, '0'),
(106, 1, '0'),
(107, 1, '0'),
(108, 1, '0'),
(109, 1, '0'),
(110, 1, '0'),
(111, 1, '1'),
(112, 1, '0'),
(113, 1, '0'),
(114, 1, '0'),
(115, 1, '0'),
(116, 1, '0'),
(117, 1, '0'),
(118, 1, '0'),
(119, 1, '0'),
(120, 1, '0'),
(121, 1, '0'),
(122, 1, '0'),
(123, 1, '0'),
(124, 1, '0'),
(125, 1, '0'),
(126, 1, '0'),
(127, 1, '0'),
(128, 1, '0'),
(129, 1, '0'),
(130, 1, '0'),
(131, 1, '0'),
(132, 1, '0'),
(133, 1, '0'),
(134, 1, '0'),
(135, 1, '0'),
(136, 1, '1'),
(137, 1, '1'),
(138, 1, '1'),
(139, 1, '1'),
(140, 1, '1'),
(141, 1, '1'),
(142, 1, '1'),
(143, 1, '1'),
(144, 1, '1'),
(145, 1, '1'),
(146, 1, '0'),
(147, 1, '0'),
(148, 1, '0'),
(149, 1, '0'),
(150, 1, '0'),
(151, 1, '0'),
(152, 1, '0'),
(153, 1, '1'),
(154, 1, '0'),
(155, 1, '0'),
(156, 1, '0'),
(157, 1, '0'),
(158, 1, '0'),
(159, 1, '0'),
(160, 1, '0'),
(160, 161, '0'),
(161, 1, '0'),
(162, 1, '0'),
(163, 1, '0'),
(164, 1, '0'),
(165, 1, '0'),
(166, 1, '0'),
(167, 1, '0'),
(168, 1, '0'),
(169, 1, '0'),
(170, 1, '0'),
(171, 1, '0'),
(172, 1, '0'),
(173, 1, '0');
-- --------------------------------------------------------
--
-- Structure de la table `document`
--
CREATE TABLE IF NOT EXISTS `document` (
`doc_id` int(11) NOT NULL AUTO_INCREMENT,
`doc_name` varchar(255) NOT NULL,
`doc_path` varchar(1024) NOT NULL,
`doc_size` int(11) NOT NULL,
`doc_year` int(11) NOT NULL,
`doc_ue` varchar(15) NOT NULL,
`doc_catg` varchar(15) NOT NULL COMMENT 'ds, tp, ta,...',
`doc_code` varchar(255) NOT NULL,
`doc_valid` tinyint(4) NOT NULL COMMENT 'true = valide',
`doc_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`doc_id`),
UNIQUE KEY `doc_code` (`doc_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;
--
-- Contenu de la table `document`
--
INSERT INTO `document` (`doc_id`, `doc_name`, `doc_path`, `doc_size`, `doc_year`, `doc_ue`, `doc_catg`, `doc_code`, `doc_valid`, `doc_date`) VALUES
(1, 'suggestions.txt', 'files/ei1/algpr/ds/', 992, 1, 'algpr', 'ds', '41305', 0, '0000-00-00 00:00:00'),
(2, 'tableurs.zip', 'files/ei1/algpr/dsc/', 2983599, 1, 'algpr', 'dsc', '66811', 0, '0000-00-00 00:00:00'),
(3, 'tableurs.zip', 'files/ei1/algpr/dsc/', 2983599, 1, 'algpr', 'dsc', '847742', 0, '0000-00-00 00:00:00'),
(4, 'tableurs.zip', 'files/ei1/algpr/dsc/', 2983599, 1, 'algpr', 'dsc', '424539', 0, '0000-00-00 00:00:00'),
(5, 'tableurs.zip', 'files/ei1/algpr/dsc/', 2983599, 1, 'algpr', 'dsc', '360190', 0, '0000-00-00 00:00:00'),
(6, 'tableurs.zip', 'files/ei1/algpr/dsc/', 2983599, 1, 'algpr', 'dsc', '830370', 0, '0000-00-00 00:00:00'),
(7, 'Capture.JPG', 'files/ei1/algpr/ds/', 40850, 1, 'algpr', 'ds', '756534', 0, '0000-00-00 00:00:00'),
(8, '7.jpg', 'files/ei1/algpr/ta/', 26998, 1, 'algpr', 'ta', '911930', 0, '0000-00-00 00:00:00'),
(9, '7.jpg', 'files/ei1/algpr/ta/2013/', 26998, 1, 'algpr', 'ta', '360192', 0, '0000-00-00 00:00:00'),
(10, 'test.php', 'files/ei1/sstem/tp/', 33, 1, 'sstem', 'tp', '844599', 0, '0000-00-00 00:00:00'),
(11, 'test.php', 'files/ei1/algpr/ds/', 53, 1, 'algpr', 'ds', '896516', 0, '0000-00-00 00:00:00'),
(12, '7.jpg', 'files/ei1/algpr/ta/', 26998, 1, 'algpr', 'ta', '524876', 0, '0000-00-00 00:00:00'),
(13, 'test.txt', 'files/ei1/fluid/ta/', 33, 1, 'fluid', 'ta', '95364', 0, '0000-00-00 00:00:00');
-- --------------------------------------------------------
--
-- Structure de la table `groupe`
--
CREATE TABLE IF NOT EXISTS `groupe` (
`gr_id` int(11) NOT NULL AUTO_INCREMENT,
`gr_nom` varchar(50) NOT NULL,
PRIMARY KEY (`gr_id`),
UNIQUE KEY `gr_nom` (`gr_nom`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- Contenu de la table `groupe`
--
INSERT INTO `groupe` (`gr_id`, `gr_nom`) VALUES
(3, 'Les zouzous'),
(2, 'maths_1'),
(1, 'Programmeurs foux');
-- --------------------------------------------------------
--
-- Structure de la table `groupe_membre`
--
CREATE TABLE IF NOT EXISTS `groupe_membre` (
`gr_id` int(11) NOT NULL AUTO_INCREMENT,
`mem_id` int(11) NOT NULL,
PRIMARY KEY (`gr_id`,`mem_id`),
KEY `mem_id` (`mem_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- Contenu de la table `groupe_membre`
--
INSERT INTO `groupe_membre` (`gr_id`, `mem_id`) VALUES
(1, 2),
(1, 4),
(2, 26),
(3, 1),
(3, 26);
-- --------------------------------------------------------
--
-- Structure de la table `history`
--
CREATE TABLE IF NOT EXISTS `history` (
`hh_id` int(11) NOT NULL AUTO_INCREMENT,
`hh_mem_id` int(11) NOT NULL,
`hh_concerne` varchar(50) NOT NULL,
`hh_resume` text NOT NULL,
`hh_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`hh_net_id` int(11) NOT NULL,
`hh_gr_id` int(11) NOT NULL,
PRIMARY KEY (`hh_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=275 ;
--
-- Contenu de la table `history`
--
INSERT INTO `history` (`hh_id`, `hh_mem_id`, `hh_concerne`, `hh_resume`, `hh_date`, `hh_net_id`, `hh_gr_id`) VALUES
(1, 0, 'Tous', 'Bienvenue sur la plateforme kit jambon consacree a l''upload et au telechargement de fichiers. Nous sommes heureux de t''accueillir au sein de cette communaute grandissante et ton arrivee apporte un souffle nouveau. </br>Le site est simple d''utilisation et l''interface actuelle te permet de communiquer avec plusieurs membres en choisissant la visibilite adequate. N''hesite pas a rejoindre des reseaux pour voir leur membre et ainsi creer des affinites. </br>Tu peux aussi creer des groupes de travail et inviter d''autres membres (fonctionnalite a venir). </br>\r\nPour visionner les repertoires de fichiers, direction Menu->module et pour uploader Maison->Ajouter un fichier. </br>\r\nVoila le tour est fait. N''hésite pas a naviguer sur le site et surtout profite de ton annee. Ciaooo!!</br></br> PS: En cas de souci ou de bugs, envoie un message a ton admin : @wdadmin ', '2014-10-01 22:16:37', 0, 0),
(2, 1, 'Tous', 'Je viens de m''inscrire sur kit jambon!', '2014-09-02 20:24:34', 2, 1),
(49, 1, 'wdadmin', '<a href="http://isf.campus-ecn.fr">klkljk</a>', '2014-09-03 16:06:08', 0, 0),
(60, 1, 'Upload', 'wdadmin vient d''uploader le fichier suggestions.txt .', '2014-09-04 03:11:35', 0, 0),
(61, 1, 'Upload', 'wdadmin vient d''uploader le fichier tableurs.zip .', '2014-09-04 03:29:12', 0, 0),
(62, 1, 'Upload', 'wdadmin vient d''uploader le fichier Capture.JPG .', '2014-09-04 03:45:07', 0, 0),
(63, 2, 'Upload', 'ineslunga vient d''uploader le fichier 7.jpg .', '2014-09-04 07:11:43', 0, 0),
(64, 1, 'Upload', 'wdadmin vient d''uploader le fichier test.php .', '2014-09-04 09:22:02', 0, 0),
(75, 27, 'maligne44', 'Qui est fort en algpr ??', '2014-09-07 03:42:45', 1, 0),
(66, 2, 'Upload', 'ineslunga vient d''uploader le fichier 7.jpg .', '2014-09-04 09:29:09', 0, 0),
(67, 25, 'Un nouveau membre', 'nicolas vient de rejoindre la communauté des jambonneurs.', '2014-09-04 11:34:19', 0, 0),
(68, 25, 'Upload', ' vient d''uploader le fichier test.txt .', '2014-09-04 11:37:47', 0, 0),
(76, 27, 'maligne44', '??? il y a des gens ici ???', '2014-09-07 03:49:58', 10, 0),
(71, 26, 'Un nouveau membre', 'thewriter vient de rejoindre la communauté des jambonneurs.', '2014-09-06 05:40:29', 0, 0),
(72, 26, 'thewriter', 'je teste', '2014-09-06 05:42:56', 0, 0),
(73, 27, 'Un nouveau membre', 'maligne44 vient de rejoindre la communauté des jambonneurs.', '2014-09-07 03:06:22', 0, 0),
(74, 27, 'maligne44', 'bonjour je suis maligne44!!! je cherche des infos sur le ds de maths de demain.', '2014-09-07 03:39:07', 0, 0),
(77, 28, 'Un nouveau membre', 'AlexOrhan vient de rejoindre la communauté des jambonneurs.', '2014-09-16 13:33:15', 0, 0),
(78, 29, 'Un nouveau membre', 'amirmehdi vient de rejoindre la communauté des jambonneurs.', '2014-09-17 09:10:29', 0, 0),
(79, 30, 'Un nouveau membre', 'particulier vient de rejoindre la communauté des jambonneurs.', '2014-09-17 13:50:22', 0, 0),
(80, 28, 'wdadmin', 'wdadmin veut entrer en contact avec vous. Voici son mail [email protected]', '2014-10-01 02:16:01', 0, 0),
(81, 29, 'wdadmin', 'wdadmin veut entrer en contact avec vous. Voici son mail [email protected]', '2014-10-01 02:16:24', 0, 0),
(82, 31, 'Inscription', 'alain52km vient de rejoindre la communauté.', '2014-10-01 21:06:58', 1, 0),
(83, 31, 'wdadmin', 'wdadmin veut entrer en contact avec vous. Voici son mail [email protected]', '2014-10-02 16:39:24', 0, 0),
(84, 31, 'Inscription au réseau', 'ALAIN52KM vient de rejoindre le réseau', '2014-10-02 21:56:02', 8, 0),
(85, 9, 'wdadmin', 'wdadmin veut entrer en contact avec vous. Voici son mail [email protected]', '2014-10-03 17:25:10', 0, 0),
(86, 10, 'wdadmin', 'wdadmin veut entrer en contact avec vous. Voici son mail [email protected]', '2014-10-03 17:25:33', 0, 0),
(87, 32, 'Inscription', 'sazo1994 vient de rejoindre la communauté.', '2014-10-07 08:42:04', 15, 0),
(88, 33, 'Inscription', 'akoukou vient de rejoindre la communauté.', '2014-10-07 21:26:32', 13, 0),
(89, 34, 'Inscription', 'Maxtol vient de rejoindre la communauté.', '2014-10-10 13:28:24', 8, 0),
(90, 33, 'wdadmin', 'wdadmin veut entrer en contact avec vous. Voici son mail [email protected]', '2014-10-14 00:39:55', 0, 0),
(91, 34, 'wdadmin', 'wdadmin veut entrer en contact avec vous. Voici son mail [email protected]', '2014-10-14 00:40:22', 0, 0),
(92, 32, 'wdadmin', 'wdadmin veut entrer en contact avec vous. Voici son mail [email protected]', '2014-10-14 00:40:37', 0, 0),
(93, 35, 'Inscription', 'bdesvaux vient de rejoindre la communauté.', '2014-10-19 15:13:40', 146, 0),
(94, 36, 'Inscription', 'Macrois vient de rejoindre la communauté.', '2014-10-29 21:57:37', 4, 0),
(95, 37, 'Inscription', 'egombaul vient de rejoindre la communauté.', '2014-10-31 09:07:10', 121, 0),
(96, 36, 'wdadmin', 'wdadmin veut entrer en contact avec vous. Voici son mail [email protected]', '2014-10-31 19:36:32', 0, 0),
(97, 37, 'wdadmin', 'wdadmin veut entrer en contact avec vous. Voici son mail [email protected]', '2014-10-31 19:37:06', 0, 0),
(98, 38, 'Inscription', 'hbelkhou vient de rejoindre la communauté.', '2014-11-03 19:39:26', 122, 0),
(99, 38, 'Inscription au réseau', 'HBELKHOU vient de rejoindre le réseau', '2014-11-03 19:41:55', 97, 0),
(100, 38, 'Inscription au réseau', 'HBELKHOU vient de rejoindre le réseau', '2014-11-03 19:42:19', 149, 0),
(101, 38, 'wdadmin', 'wdadmin veut entrer en contact avec vous. Voici son mail [email protected]', '2014-11-05 15:44:16', 0, 0),
(102, 25, 'wdadmin', 'wdadmin veut entrer en contact avec vous. Voici son mail [email protected]', '2014-11-06 13:56:17', 0, 0),
(103, 39, 'Inscription', 'ynsifr vient de rejoindre la communauté.', '2014-11-07 09:29:08', 13, 0),
(104, 39, 'wdadmin', 'wdadmin veut entrer en contact avec vous. Voici son mail [email protected]', '2014-11-07 10:52:04', 0, 0),
(105, 40, 'Inscription', 'aaycartl vient de rejoindre la communauté.', '2014-11-07 13:45:02', 13, 0),
(106, 41, 'Inscription', 'baptiste vient de rejoindre la communauté.', '2014-11-07 13:45:51', 13, 0),
(107, 42, 'Inscription', 'sdadian vient de rejoindre la communauté.', '2014-11-07 18:23:44', 15, 0),
(108, 40, 'wdadmin', 'wdadmin veut entrer en contact avec vous. Voici son mail [email protected]', '2014-11-07 19:21:34', 0, 0),
(109, 41, 'wdadmin', 'wdadmin veut entrer en contact avec vous. Voici son mail [email protected]', '2014-11-07 19:22:10', 0, 0),
(110, 42, 'wdadmin', 'wdadmin veut entrer en contact avec vous. Voici son mail [email protected]', '2014-11-07 19:23:09', 0, 0),
(111, 43, 'Inscription', 'zoulettedu76 vient de rejoindre la communauté.', '2014-11-07 22:25:46', 2, 0),
(112, 43, 'wdadmin', 'wdadmin veut entrer en contact avec vous. Voici son mail [email protected]', '2014-11-07 22:49:58', 0, 0),
(113, 44, 'Inscription', 'Lobont vient de rejoindre la communauté.', '2014-11-07 23:21:29', 2, 0),
(114, 45, 'Inscription', 'simolaraki vient de rejoindre la communauté.', '2014-11-08 01:22:14', 15, 0),
(115, 46, 'Inscription', 'Jeremy vient de rejoindre la communauté.', '2014-11-08 01:41:21', 16, 0),
(116, 47, 'Inscription', 'ametay vient de rejoindre la communauté.', '2014-11-08 01:48:13', 2, 0),
(117, 1, 'Tous', 'De nouveaux fichiers dans le répertoire EI1-maths.', '2014-11-08 01:52:05', 0, 0),
(118, 48, 'Inscription', 'barbarien vient de rejoindre la communauté.', '2014-11-08 02:59:44', 20, 0),
(119, 49, 'Inscription', 'barbarien vient de rejoindre la communauté.', '2014-11-08 03:06:45', 5, 0),
(120, 41, 'Inscription au réseau', 'BAPTISTE vient de rejoindre le réseau', '2014-11-08 12:00:47', 2, 0),
(121, 41, 'Inscription au réseau', 'BAPTISTE vient de rejoindre le réseau', '2014-11-08 12:01:52', 16, 0),
(122, 50, 'Inscription', 'MathieuH vient de rejoindre la communauté.', '2014-11-08 15:01:59', 8, 0),
(123, 51, 'Inscription', 'Crevette vient de rejoindre la communauté.', '2014-11-08 16:09:44', 25, 0),
(124, 1, 'Inscription au réseau', 'WDADMIN vient de rejoindre le réseau', '2014-11-08 17:03:17', 15, 0),
(125, 52, 'Inscription', 'ldomingu vient de rejoindre la communauté.', '2014-11-09 19:56:40', 13, 0),
(126, 53, 'Inscription', 'serghe vient de rejoindre la communauté.', '2014-11-09 20:13:35', 16, 0),
(127, 54, 'Inscription', 'BaPpppp vient de rejoindre la communauté.', '2014-11-10 07:51:55', 83, 0),
(128, 35, 'wdadmin', 'wdadmin veut entrer en contact avec vous. Voici son mail [email protected]', '2014-11-10 11:14:14', 0, 0),
(129, 27, 'wdadmin', 'wdadmin veut entrer en contact avec vous. Voici son mail [email protected]', '2014-11-10 11:16:16', 0, 0),
(130, 55, 'Inscription', 'Lberkman vient de rejoindre la communauté.', '2014-11-10 12:25:33', 19, 0),
(131, 56, 'Inscription', 'mndong vient de rejoindre la communauté.', '2014-11-10 12:52:25', 16, 0),
(132, 53, 'Inscription au réseau', 'SERGHE vient de rejoindre le réseau', '2014-11-10 21:35:24', 2, 0),
(133, 57, 'Inscription', 'dglotin vient de rejoindre la communauté.', '2014-11-11 09:22:20', 15, 0),
(134, 57, 'Inscription au réseau', 'DGLOTIN vient de rejoindre le réseau', '2014-11-11 09:35:38', 2, 0),
(135, 58, 'Inscription', 'lbrianco vient de rejoindre la communauté.', '2014-11-11 13:45:37', 166, 0),
(136, 59, 'Inscription', 'chloptr vient de rejoindre la communauté.', '2014-11-11 13:56:11', 53, 0),
(137, 60, 'Inscription', 'mfaure vient de rejoindre la communauté.', '2014-11-11 14:07:35', 196, 0),
(138, 61, 'Inscription', 'Walid EL AGHA EL SAOUDI vient de rejoindre la communauté.', '2014-11-11 14:50:10', 2, 0),
(139, 62, 'Inscription', 'Benoit vient de rejoindre la communauté.', '2014-11-11 15:24:40', 10, 0),
(140, 63, 'Inscription', 'ilyesbouss vient de rejoindre la communauté.', '2014-11-11 15:33:53', 15, 0),
(141, 64, 'Inscription', 'epuroski vient de rejoindre la communauté.', '2014-11-11 16:19:13', 4, 0),
(142, 65, 'Inscription', 'ldouteau vient de rejoindre la communauté.', '2014-11-11 17:26:42', 38, 0),
(143, 66, 'Inscription', 'Jujuweb vient de rejoindre la communauté.', '2014-11-12 10:40:43', 1, 0),
(144, 67, 'Inscription', 'ibancel vient de rejoindre la communauté.', '2014-11-13 06:31:22', 1, 0),
(145, 68, 'Inscription', 'clestang vient de rejoindre la communauté.', '2014-11-13 13:12:23', 3, 0),
(146, 68, 'Inscription au réseau', 'CLESTANG vient de rejoindre le réseau', '2014-11-13 13:49:18', 1, 0),
(147, 69, 'Inscription', 'ridane vient de rejoindre la communauté.', '2014-11-13 17:13:30', 15, 0),
(148, 69, 'Inscription au réseau', 'RIDANE vient de rejoindre le réseau', '2014-11-13 17:34:51', 2, 0),
(149, 70, 'Inscription', 'Quentin Reynaud vient de rejoindre la communauté.', '2014-11-13 17:36:28', 1, 0),
(150, 71, 'Inscription', 'pychassain vient de rejoindre la communauté.', '2014-11-14 16:24:56', 16, 0),
(151, 72, 'Inscription', 'gael17 vient de rejoindre la communauté.', '2014-11-16 20:26:18', 1, 0),
(152, 73, 'Inscription', 'marieb vient de rejoindre la communauté.', '2014-11-16 21:45:21', 1, 0),
(153, 74, 'Inscription', 'antonior vient de rejoindre la communauté.', '2014-11-18 11:55:09', 2, 0),
(154, 75, 'Inscription', 'antoniode vient de rejoindre la communauté.', '2014-11-18 12:00:15', 2, 0),
(155, 76, 'Inscription', 'cdaoudal vient de rejoindre la communauté.', '2014-11-18 17:31:05', 8, 0),
(156, 77, 'Inscription', 'Drouet vient de rejoindre la communauté.', '2014-11-19 07:21:20', 14, 0),
(157, 1, 'Tous', 'test', '2014-11-19 23:20:24', 0, 0),
(158, 78, 'Inscription', 'fthomas vient de rejoindre la communauté.', '2014-11-21 12:17:11', 15, 0),
(159, 57, 'Inscription au réseau', 'DGLOTIN vient de rejoindre le réseau', '2014-11-22 15:12:25', 16, 0),
(160, 79, 'Inscription', 'VoniaR vient de rejoindre la communauté.', '2014-11-22 16:51:31', 3, 0),
(161, 80, 'Inscription', 'Laura Guillot vient de rejoindre la communauté.', '2014-11-23 14:39:22', 13, 0),
(162, 81, 'Inscription', 'nantoine vient de rejoindre la communauté.', '2014-11-23 16:33:58', 2, 0),
(163, 81, 'Inscription au réseau', 'NANTOINE vient de rejoindre le réseau', '2014-11-23 16:44:28', 16, 0),
(164, 82, 'Inscription', 'Helixir vient de rejoindre la communauté.', '2014-11-23 21:01:01', 16, 0),
(165, 83, 'Inscription', 'redumas vient de rejoindre la communauté.', '2014-11-23 22:23:01', 59, 0),
(166, 43, 'Inscription au réseau', 'ZOULETTEDU76 vient de rejoindre le réseau', '2014-11-24 21:55:46', 14, 0),
(167, 84, 'Inscription', 'vaurien vient de rejoindre la communauté.', '2014-11-26 12:17:06', 14, 0),
(168, 85, 'Inscription', 'jbalberge vient de rejoindre la communauté.', '2014-11-26 14:43:39', 16, 0),
(169, 86, 'Inscription', 'Bernardo vient de rejoindre la communauté.', '2014-12-01 14:30:09', 13, 0),
(170, 86, 'Inscription au réseau', 'BERNARDO vient de rejoindre le réseau', '2014-12-01 14:38:24', 2, 0),
(171, 87, 'Inscription', 'cmoutard vient de rejoindre la communauté.', '2014-12-01 19:06:11', 8, 0),
(172, 88, 'Inscription', 'ctriquet vient de rejoindre la communauté.', '2014-12-05 10:16:27', 2, 0),
(173, 89, 'Inscription', 'aandujar vient de rejoindre la communauté.', '2014-12-06 18:29:33', 2, 0),
(174, 90, 'Inscription', 'SebastienG vient de rejoindre la communauté.', '2014-12-09 19:27:45', 1, 0),
(175, 90, 'Inscription au réseau', 'SEBASTIENG vient de rejoindre le réseau', '2014-12-09 19:28:42', 15, 0),
(176, 91, 'Inscription', 'Robin Hood vient de rejoindre la communauté.', '2014-12-10 12:27:26', 13, 0),
(177, 91, 'Inscription au réseau', 'ROBIN HOOD vient de rejoindre le réseau', '2014-12-10 12:29:50', 14, 0),
(178, 92, 'Inscription', 'Remy M vient de rejoindre la communauté.', '2014-12-15 19:48:24', 1, 0),
(179, 43, 'Inscription au réseau', 'ZOULETTEDU76 vient de rejoindre le réseau', '2014-12-17 13:43:26', 16, 0),
(180, 93, 'Inscription', 'ahijos vient de rejoindre la communauté.', '2014-12-19 16:40:53', 16, 0),
(181, 90, 'Inscription au réseau', 'SEBASTIENG vient de rejoindre le réseau', '2014-12-25 16:47:49', 18, 0),
(182, 94, 'Inscription', 'Kirzzz vient de rejoindre la communauté.', '2015-01-05 17:45:14', 2, 0),
(183, 95, 'Inscription', 'ighirmehdi vient de rejoindre la communauté.', '2015-01-08 22:11:18', 16, 0),
(184, 34, 'Inscription au réseau', 'MAXTOL vient de rejoindre le réseau', '2015-01-11 12:33:10', 15, 0),
(185, 96, 'Inscription', 'tanguy vient de rejoindre la communauté.', '2015-01-12 20:15:40', 1, 0),
(186, 96, 'Inscription au réseau', 'TANGUY vient de rejoindre le réseau', '2015-01-12 20:28:17', 3, 0),
(187, 96, 'Inscription au réseau', 'TANGUY vient de rejoindre le réseau', '2015-01-12 20:29:25', 107, 0),
(188, 97, 'Inscription', 'Violette vient de rejoindre la communauté.', '2015-01-13 18:07:47', 1, 0),
(189, 98, 'Inscription', 'amnfissi vient de rejoindre la communauté.', '2015-01-13 21:17:12', 1, 0),
(190, 99, 'Inscription', 'yfletberliac vient de rejoindre la communauté.', '2015-01-14 11:48:40', 77, 0),
(191, 100, 'Inscription', 'oagneray vient de rejoindre la communauté.', '2015-01-14 15:06:35', 1, 0),
(192, 78, 'Inscription au réseau', 'FTHOMAS vient de rejoindre le réseau', '2015-01-15 09:27:34', 5, 0),
(193, 101, 'Inscription', 'desmoit vient de rejoindre la communauté.', '2015-01-17 16:47:08', 8, 0),
(194, 41, 'Inscription au réseau', 'BAPTISTE vient de rejoindre le réseau', '2015-01-17 17:31:42', 3, 0),
(195, 96, 'Inscription au réseau', 'TANGUY vient de rejoindre le réseau', '2015-01-18 08:51:35', 8, 0),
(196, 41, 'Inscription au réseau', 'BAPTISTE vient de rejoindre le réseau', '2015-01-18 15:15:18', 14, 0),
(197, 102, 'Inscription', 'Andrea vient de rejoindre la communauté.', '2015-01-18 15:42:46', 13, 0),
(198, 103, 'Inscription', 'marnal vient de rejoindre la communauté.', '2015-01-18 16:01:17', 2, 0),
(199, 104, 'Inscription', 'patataburger vient de rejoindre la communauté.', '2015-01-18 16:05:10', 8, 0),
(200, 105, 'Inscription', 'maraldi vient de rejoindre la communauté.', '2015-01-18 16:34:24', 16, 0),
(201, 105, 'Inscription au réseau', 'MARALDI vient de rejoindre le réseau', '2015-01-18 17:38:09', 14, 0),
(202, 106, 'Inscription', 'rbertran vient de rejoindre la communauté.', '2015-01-18 17:57:32', 15, 0),
(203, 53, 'Inscription au réseau', 'SERGHE vient de rejoindre le réseau', '2015-01-18 21:47:37', 5, 0),
(204, 107, 'Inscription', 'CaroleLeBol vient de rejoindre la communauté.', '2015-01-19 11:46:10', 8, 0),
(205, 108, 'Inscription', 'mpetitpi vient de rejoindre la communauté.', '2015-01-19 15:57:14', 2, 0),
(206, 109, 'Inscription', 'Simooon vient de rejoindre la communauté.', '2015-01-19 16:22:53', 1, 0),
(207, 110, 'Inscription', 'nlaroche vient de rejoindre la communauté.', '2015-01-19 20:55:27', 18, 0),
(208, 112, 'Inscription', 'bouboubou vient de rejoindre la communauté.', '2015-01-20 10:33:46', 3, 0),
(209, 113, 'Inscription', 'anto6927 vient de rejoindre la communauté.', '2015-01-20 10:35:17', 2, 0),
(210, 113, 'Inscription au réseau', 'ANTO6927 vient de rejoindre le réseau', '2015-01-20 10:40:34', 5, 0),
(211, 114, 'Inscription', 'aecenci vient de rejoindre la communauté.', '2015-01-20 11:30:44', 17, 0),
(212, 115, 'Inscription', 'florianabadie vient de rejoindre la communauté.', '2015-01-20 11:54:44', 13, 0),
(213, 116, 'Inscription', 'LeanaRosePicot vient de rejoindre la communauté.', '2015-01-20 13:49:49', 4, 0),
(214, 117, 'Inscription', 'luciadgg vient de rejoindre la communauté.', '2015-01-20 15:18:51', 13, 0),
(215, 118, 'Inscription', 'louispap vient de rejoindre la communauté.', '2015-01-20 16:10:34', 2, 0),
(216, 119, 'Inscription', 'mkernec vient de rejoindre la communauté.', '2015-01-20 18:47:14', 8, 0),
(217, 120, 'Inscription', 'akempfer vient de rejoindre la communauté.', '2015-01-20 19:48:56', 16, 0),
(218, 120, 'Inscription au réseau', 'AKEMPFER vient de rejoindre le réseau', '2015-01-20 19:53:27', 3, 0),
(219, 121, 'Inscription', 'aarguell vient de rejoindre la communauté.', '2015-01-21 09:16:08', 4, 0),
(220, 95, 'Inscription au réseau', 'IGHIRMEHDI vient de rejoindre le réseau', '2015-01-21 10:06:41', 5, 0),
(221, 122, 'Inscription', 'hantmoody vient de rejoindre la communauté.', '2015-01-21 10:41:35', 1, 0),
(222, 123, 'Inscription', 'nat8546 vient de rejoindre la communauté.', '2015-01-21 13:26:36', 15, 0),
(223, 124, 'Inscription', 'ntodorov vient de rejoindre la communauté.', '2015-01-21 13:35:52', 15, 0),
(224, 125, 'Inscription', 'TIMMAZ vient de rejoindre la communauté.', '2015-01-21 14:48:32', 8, 0),
(225, 126, 'Inscription', 'tygen02 vient de rejoindre la communauté.', '2015-01-21 15:43:30', 2, 0),
(226, 127, 'Inscription', 'Spelou vient de rejoindre la communauté.', '2015-01-21 15:44:36', 2, 0),
(227, 128, 'Inscription', 'Sweetch001 vient de rejoindre la communauté.', '2015-01-21 18:07:10', 16, 0),
(228, 129, 'Inscription', 'Menand vient de rejoindre la communauté.', '2015-01-22 11:02:02', 16, 0),
(229, 130, 'Inscription', 'jcvuille vient de rejoindre la communauté.', '2015-01-22 14:27:49', 11, 0),
(230, 131, 'Inscription', 'abigourd vient de rejoindre la communauté.', '2015-01-22 20:13:37', 8, 0),
(231, 132, 'Inscription', 'lhassan94 vient de rejoindre la communauté.', '2015-01-23 14:17:04', 16, 0),
(232, 133, 'Inscription', 'Marcel vient de rejoindre la communauté.', '2015-01-24 11:55:24', 16, 0),
(233, 134, 'Inscription', 'Nebonobo vient de rejoindre la communauté.', '2015-01-24 15:32:07', 8, 0),
(234, 135, 'Inscription', 'porain vient de rejoindre la communauté.', '2015-01-24 17:53:35', 15, 0),
(235, 136, 'Inscription', 'Blondine vient de rejoindre la communauté.', '2015-01-24 17:58:31', 8, 0),
(236, 137, 'Inscription', 'Sylvie vient de rejoindre la communauté.', '2015-01-24 18:04:09', 86, 0),
(237, 138, 'Inscription', 'JLeTallec vient de rejoindre la communauté.', '2015-01-24 18:09:22', 9, 0),
(238, 139, 'Inscription', 'jvuillam vient de rejoindre la communauté.', '2015-01-24 18:10:26', 4, 0),
(239, 140, 'Inscription', 'Tweick vient de rejoindre la communauté.', '2015-01-24 18:17:22', 8, 0),
(240, 141, 'Inscription', 'Laszlo Horvath vient de rejoindre la communauté.', '2015-01-24 18:23:33', 15, 0),
(241, 142, 'Inscription', 'Luisreyes vient de rejoindre la communauté.', '2015-01-24 18:35:37', 2, 0),
(242, 143, 'Inscription', 'elio bassil vient de rejoindre la communauté.', '2015-01-24 18:58:33', 2, 0),
(243, 144, 'Inscription', 'jtheveno vient de rejoindre la communauté.', '2015-01-24 19:10:54', 11, 0),
(244, 145, 'Inscription', 'jambon vient de rejoindre la communauté.', '2015-01-24 19:55:23', 11, 0),
(245, 146, 'Inscription', 'qduponta vient de rejoindre la communauté.', '2015-01-25 07:31:23', 1, 0),
(246, 147, 'Inscription', 'ddinello vient de rejoindre la communauté.', '2015-01-25 09:57:23', 8, 0),
(247, 148, 'Inscription', 'vladimir vient de rejoindre la communauté.', '2015-01-25 10:08:29', 18, 0),
(248, 149, 'Inscription', 'p139426 vient de rejoindre la communauté.', '2015-01-25 13:25:30', 17, 0),
(249, 150, 'Inscription', 'apohibou vient de rejoindre la communauté.', '2015-01-25 14:16:13', 8, 0),
(250, 151, 'Inscription', 'darksinus vient de rejoindre la communauté.', '2015-01-25 19:38:09', 1, 0),
(251, 152, 'Inscription', 'muhammad vient de rejoindre la communauté.', '2015-01-25 21:26:33', 1, 0),
(252, 153, 'Inscription', 'Monique vient de rejoindre la communauté.', '2015-01-25 21:43:35', 8, 0),
(253, 154, 'Inscription', 'johndu69 vient de rejoindre la communauté.', '2015-01-25 21:46:03', 134, 0),
(254, 155, 'Inscription', 'gmorin vient de rejoindre la communauté.', '2015-01-25 22:10:49', 14, 0),
(255, 156, 'Inscription', 'jmlegoff vient de rejoindre la communauté.', '2015-01-26 08:06:42', 134, 0),
(256, 157, 'Inscription', 'meimei vient de rejoindre la communauté.', '2015-01-26 16:56:26', 2, 0),
(257, 158, 'Inscription', 'cl2327 vient de rejoindre la communauté.', '2015-01-26 17:15:45', 3, 0),
(258, 159, 'Inscription', 'dinyguy vient de rejoindre la communauté.', '2015-01-26 21:35:34', 1, 0),
(259, 160, 'Inscription', 'theoreg vient de rejoindre la communauté.', '2015-01-27 17:09:23', 8, 0),
(260, 161, 'Inscription', 'marineldl vient de rejoindre la communauté.', '2015-01-27 21:07:05', 138, 0),
(261, 161, 'theoreg', 'theoreg veut entrer en contact avec vous. Voici son mail [email protected]', '2015-01-27 21:16:44', 0, 0),
(262, 162, 'Inscription', 'Hermillion vient de rejoindre la communauté.', '2015-01-27 23:11:19', 11, 0),
(263, 163, 'Inscription', 'phebrard vient de rejoindre la communauté.', '2015-01-30 15:29:05', 202, 0),
(264, 164, 'Inscription', 'BokuNoPico vient de rejoindre la communauté.', '2015-02-11 01:23:11', 13, 0),
(265, 165, 'Inscription', 'Gabrielle G vient de rejoindre la communauté.', '2015-02-15 11:24:13', 16, 0),
(266, 166, 'Inscription', 'mrodari vient de rejoindre la communauté.', '2015-03-05 17:52:23', 70, 0),
(267, 167, 'Inscription', 'Pierre Grison vient de rejoindre la communauté.', '2015-03-05 21:54:08', 16, 0),
(268, 168, 'Inscription', 'Zoulette37 vient de rejoindre la communauté.', '2015-03-09 22:27:05', 14, 0),
(269, 169, 'Inscription', 'yannc26 vient de rejoindre la communauté.', '2015-03-12 15:01:53', 1, 0),
(270, 170, 'Inscription', 'hoskian vient de rejoindre la communauté.', '2015-03-13 09:51:09', 13, 0),
(271, 171, 'Inscription', 'fmahe56 vient de rejoindre la communauté.', '2015-03-15 17:48:41', 13, 0),
(272, 172, 'Inscription', 'Fanny C vient de rejoindre la communauté.', '2015-03-15 21:22:13', 4, 0),
(273, 173, 'Inscription', 'BastosLaRafale vient de rejoindre la communauté.', '2015-03-15 21:54:07', 1, 0),
(274, 1, 'Tous', 'hkjk\r\n', '2015-03-16 17:12:11', 0, 0);
-- --------------------------------------------------------
--
-- Structure de la table `membre`
--
CREATE TABLE IF NOT EXISTS `membre` (
`mem_id` int(11) NOT NULL AUTO_INCREMENT,
`mem_mail` varchar(255) NOT NULL,
`mem_login` varchar(40) NOT NULL,
`mem_pass` varchar(255) NOT NULL,
`mem_droit` varchar(10) NOT NULL,
`mem_year` int(11) NOT NULL,
`mem_ue` varchar(15) NOT NULL,
`mem_token` varchar(255) NOT NULL,
`temperament` varchar(30) NOT NULL,
`mem_date_joined` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`mem_etat` tinyint(4) NOT NULL COMMENT '1 ou 0',
`mem_renew_pass` varchar(255) NOT NULL COMMENT 'code pour activer compte et récuper mot de passe',
PRIMARY KEY (`mem_id`),
UNIQUE KEY `mem_login` (`mem_login`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=174 ;
--
-- Contenu de la table `membre`
--
INSERT INTO `membre` (`mem_id`, `mem_mail`, `mem_login`, `mem_pass`, `mem_droit`, `mem_year`, `mem_ue`, `mem_token`, `temperament`, `mem_date_joined`, `mem_etat`, `mem_renew_pass`) VALUES
(1, '[email protected]', 'wdadmin', '520684e4e69f3b4901328c5dd95b54dbcce03363', 'admin', 1, 'algpr', 'KIT645142c', 'Curieux', '2014-09-01 23:09:57', 1, 'KIT645142c'),
(2, '[email protected]', 'ineslunga', 'ines5689', 'user', 0, '', '', '', '2014-08-03 02:08:25', 0, ''),
(3, '[email protected]', 'misterpol', 'admin56', 'admin', 0, '', '', '', '2014-08-03 02:23:09', 0, ''),
(4, '[email protected]', 'der03', 'vagdonEklre', 'user', 0, '', '', '', '2014-08-03 02:26:15', 0, ''),
(5, '[email protected]', 'Login', '123456pc?', 'user', 0, '', '', '', '2014-08-03 05:56:22', 0, ''),
(6, '[email protected]', 'mart53', 'mart23*,', 'user', 0, '', '', '', '2014-08-03 06:04:06', 0, ''),
(7, '[email protected]', 'egomba', 'egomba89', 'user', 0, '', '', '', '2014-08-10 13:55:31', 0, ''),
(8, '[email protected]', 'fsdsddfdfd', '123456789', '', 0, '', '', '', '2014-09-01 20:49:03', 0, 'US6917114c'),
(9, '[email protected]', 'babinet', '123456789', 'user', 1, 'maths', '', 'Trop pénard desfois', '2014-09-01 21:47:59', 0, 'KIT4038086c'),
(10, '[email protected]', 'baiurte', 'a305529a8b045953e7174f4e422958a3edac11db', 'user', 1, 'algpr', '', 'Beau goss', '2014-09-01 22:48:42', 0, 'KIT7098388c'),
(23, '[email protected]', 'mariano', '123456789', 'user', 1, 'memco', '', 'Curieux', '2014-09-02 23:51:50', 0, 'KIT7709961c'),
(24, '[email protected]', 'hjhack', '123456789', 'user', 1, 'memco', '', 'Curieux', '2014-09-02 23:55:21', 0, 'KIT3375855c'),
(25, '[email protected]', 'nicolas', '123456789', 'user', 1, 'fluid', '', 'Dramaturge', '2014-09-04 11:34:19', 0, 'KIT1011963c'),
(26, '[email protected]', 'thewriter', '123456789', 'user', 1, 'codep', '', 'Curieux', '2014-09-06 05:40:29', 0, 'KIT3818046c'),
(27, '[email protected]', 'maligne44', 'maligne44', 'user', 1, 'algpr', '', 'Bilan des tonnes', '2014-09-07 03:06:22', 0, 'KIT2471008c'),
(28, '[email protected]', 'AlexOrhan', '29b443d550014255dff298a6b2d6b282a825ac5b', 'user', 1, 'algpr', '', 'Sympathique', '2014-09-16 13:33:15', 0, 'KIT5875707c'),
(29, '[email protected]', 'amirmehdi', '70cbc7f294ebcb9c257a0035c7fc7af25be1e741', 'user', 1, 'maths', '', 'omomom', '2014-09-17 09:10:29', 0, 'KIT1887102c'),
(30, '[email protected]', 'particulier', 'f7c3bc1d808e04732adf679965ccc34ca7ae3441', 'user', 1, 'algpr', '', 'Testeur ', '2014-09-17 13:50:22', 0, 'KIT5825466c'),
(31, '[email protected]', 'alain52km', 'd641b392a480e88db20b7326be83f117787f9aed', 'user', 1, 'algpr', '5b30746fe566be0943303647ee114e33', 'se la coule douce', '2014-10-01 21:06:58', 1, 'e129474234a3adffebc99b867c1c69b4'),
(32, '[email protected]', 'sazo1994', '4c20f89bd9f573708344e012cb0cd73a287870d8', 'user', 1, 'maths', 'fa10754d16ec1dd239afa4eda3f62709', 'Sérieux', '2014-10-07 08:42:04', 1, 'aabd1251e143a5a69c0876dfbba2f52a'),
(33, '[email protected]', 'akoukou', '93b13a2e1aca62a9e15ec8499b20ecfaebc405d5', 'user', 1, 'fluid', '34443ab99b1c4c0577a0de1c12f21882', 'Rigoureux', '2014-10-07 21:26:32', 1, 'KIT5744897c'),
(132, '[email protected]', 'lhassan94', 'a4b12ff3f69b1394937cee3ca8a24503bd8ac717', 'user', 1, 'memco', 'f44cd7ebba52ab0b6252240d407ad7e9', 'Rigoureux', '2015-01-23 14:17:04', 1, 'KIT4490209c'),
(34, '[email protected]', 'Maxtol', '269b32d719effdf6c2c4790c9448bfdb9ddf94d5', 'user', 1, 'energ', '66da2f0a14c525d9a67ea87486878e3c', 'rageux', '2014-10-10 13:28:24', 1, 'KIT8377498c'),
(35, '[email protected]', 'bdesvaux', '72ced46091a2276c6479fd83b1d77a23f7fd9734', 'user', 2, 'geomod3d', '09ac4c0fabf4fe5fa2d7dda2b6429781', 'Rigoureux', '2014-10-19 15:13:40', 1, '196eec9953d461e03a79d3127caa181b'),
(36, '[email protected]', 'Macrois', '14a4f885b1f1c89fc3f2967375de22dfdaeecf10', 'user', 1, 'codep', '7f1d0ca897d6318dfa55f12eaf3fd9db', 'Jambon rigoureu', '2014-10-29 21:57:37', 1, '5a8e19b31efbb1cd9ea342c7a84fbf45'),
(37, '[email protected]', 'egombaul', 'b4446ffc6e57846b588c070eb102297a27e8f2f5', 'user', 2, 'mnmnl', '54b21647c07f33cc001a0cb7edae7a3b', 'Bosseur fou', '2014-10-31 09:07:10', 1, '897417ca5ef91899f0af324f911ed0e3'),
(38, '[email protected]', 'hbelkhou', '8b524317e2d33d24494e8b400835e8197b99e799', 'user', 2, 'modyn', 'e112ae5ffbb1b095f83839b04fba3b32', 'coco bobo', '2014-11-03 19:39:26', 1, 'KIT4137029c'),
(39, '[email protected]', 'ynsifr', 'cc940bcb1de903bdc215657670d3dc3f469e683d', 'user', 1, 'fluid', '93b7caf10231d9d3f1f5341787a46341', 'Parfois rigoureux', '2014-11-07 09:29:08', 1, 'KIT307655c'),
(40, '[email protected]', 'aaycartl', '7dcd660d9615232012bbfa30a97ae37ce765576e', 'user', 1, 'fluid', 'ff9ce9fe5f422daad48aeb5b0eae05e8', 'espagnol', '2014-11-07 13:45:02', 1, 'c10f17b58cec62564e05ecbfacc193db'),
(41, '[email protected]', 'baptiste', '041dc5fe61d7ab3c349404e02b26e0417fce7d23', 'user', 1, 'fluid', '7649e41042342d5a517aba8cabfa0da2', 'tranquille', '2014-11-07 13:45:51', 1, '4f6fb1baaf7c8eb8395a77ac4eafcc32'),
(42, '[email protected]', 'sdadian', 'f00ea5b7668c5755bf9c5765a053b5afd7cf2797', 'user', 1, 'maths', '276a691036c90ebf42089fe8477f0e21', 'cooool', '2014-11-07 18:23:44', 1, '6f4e096c757198186ce2da5ac0e6be48'),
(43, '[email protected]', 'zoulettedu76', '22e758b00d492ed7522718322c81b9299a013a9e', 'user', 1, 'ccube', 'a1d0461d4371a776a4638761c2f3b54a', 'bosseurfou', '2014-11-07 22:25:46', 1, '9cc6eda998a38b144e57c88adc0bd115'),
(44, '[email protected]', 'Lobont', '72c4055240086cb78e4a5843d03f56d0c25034ad', 'user', 1, 'ccube', 'a0d7049e470e9877317bf7d3dad5b1ee', 'serieux', '2014-11-07 23:21:29', 1, '33a55f90b4ddde3d149369182e829c0a'),
(45, '[email protected]', 'simolaraki', 'c946bcdfebbaf3654dc073f87ca8d8aefac96cc0', 'user', 1, 'maths', '17ceeb3e96eb56c5ee2b1939eac88a31', 'Rigoureux, cool, bosseur fou', '2014-11-08 01:22:14', 1, 'KIT3738816c'),
(46, '[email protected]', 'Jeremy', 'c80e802a18e6a0ade9a16a4db53714456214c4d7', 'user', 1, 'memco', '9a869ca5d2bf3cbd8bbcb5f30c5958a7', 'Rigoureux', '2014-11-08 01:41:21', 1, 'KIT116765c'),
(47, '[email protected]', 'ametay', '867d677bc1228d7f17d98df127ef44dedc429ab9', 'user', 1, 'ccube', 'f6c3a0186e0cd8c19f94967eb51ba8bd', 'coolcool', '2014-11-08 01:48:13', 1, 'c638854213abbd8960324b86b4462bf8'),
(49, '[email protected]', 'barbarien', '28e4fb9fe419a2115e0bf3d81f194c6b887ebaf9', 'admin', 1, 'coens', 'd6426c5360e7ed72df380b100bc7f4a0', 'barbarien', '2014-11-08 03:06:45', 1, '496ca3c7df9df6835e40b3acc5b66acc'),
(50, '[email protected]', 'MathieuH', 'c5d8edb3a55cf4a2a4e343b2fb25f46f717de854', 'user', 1, 'energ', '44d27220876c755b677193e92977e56f', 'Rigoureux', '2014-11-08 15:01:59', 1, '494ae28fc8f520b9c4d881651b176272'),
(51, '[email protected]', 'Crevette', '598d7ca5cf25188d89318d2d0b3a3239f5215859', 'user', 2, 'isn', 'db44d94ecd49edb7e1abc8d8bc8f7709', 'Rigoureux', '2014-11-08 16:09:44', 1, '62e3a9193634eab77a7d005f4eafbc34'),
(66, '[email protected]', 'Jujuweb', 'c9241ba32b804f05c202f9c0e5d11f124bb6d6e2', 'user', 1, 'algpr', '5742f2da06404e72e8b0f8316464772d', 'Fou furieux', '2014-11-12 10:40:43', 1, '4bc0d40a9c170f7dfa46b4f3e8c7667f'),
(53, '[email protected]', 'serghe', 'd608ee3392c8101837a243df7f38180b198c334c', 'user', 1, 'memco', 'a2d295be6caaa3520811c15c5352bd1c', 'au taquet', '2014-11-09 20:13:35', 1, '4ef09e2bdd34eaf856a30996c2819fc8'),
(54, '[email protected]', 'BaPpppp', '05422f50639c6fdef4b5b828bb556b8930a53701', 'user', 2, 'desin', 'bad8fdf49a378863d348a84beb37b693', 'Pragmatique', '2014-11-10 07:51:55', 1, 'aa2f7d6f559eb43dcdbb72ab5e1132f2'),
(55, '[email protected]', 'Lberkman', '17408eb3ad2eaffb423643e6b659ae3323a5507c', 'user', 1, 'prepas', '5eec8485d3d8735a9349cbc3c5f954dc', 'Addict au taff', '2014-11-10 12:25:33', 1, 'af65b8f15902c9a95082f95222a1396c'),
(56, '[email protected]', 'mndong', '93b0d5bbc622ed479349e14c0a3334552586118c', 'user', 1, 'memco', 'ef414e219bb82a33580da6f7b454b5c3', 'aigrie ', '2014-11-10 12:52:25', 1, '10151a9353e5a472e1aa0f4068395acd'),
(57, '[email protected]', 'dglotin', '2dab8c891a070350319b3bad4d4ac9fb08b56273', 'user', 1, 'maths', 'a899497c6106f30c58463b1e51d50d2b', 'Curieux', '2014-11-11 09:22:20', 1, 'b9c44040c4467d97b57fab46914b05ea'),
(58, '[email protected]', 'lbrianco', '6a8030f0f07d4a096583b887a88a5e73dcdf38b9', 'user', 2, 'therm', 'd830ec19aa089b31132fb271b15b94f5', 'Bien trop chouette', '2014-11-11 13:45:37', 1, '5e78462d5d969a5a59fab0bed9be195c'),
(59, '[email protected]', 'chloptr', '1f71d42f8fb2b14abb5d4c01c9e0fa01872e1ad8', 'user', 2, 'gcsol', 'f518fef0657c40b0a131434b013c16a8', 'kikoooo', '2014-11-11 13:56:11', 1, '8641a8d1ce11cb7b2c5ebb3f289c7518'),
(60, '[email protected]', 'mfaure', 'bad4dd3670ff741ade7876d5ab8ecb83b1fd7ba1', 'user', 2, 'arsig', '45c1a0f40e83ab9b7d0481725c1cdd40', 'juste géniale ', '2014-11-11 14:07:35', 1, '40c74bf6e9817b72acf156b1e73f257b'),
(61, '[email protected]', 'Walid EL AGHA EL SAOUDI', '8d5f16bff73f81ae3325b3dc6b169128cffdf756', 'user', 1, 'ccube', '238324d141a1b23e1b460be59f099e46', 'Rigoureux', '2014-11-11 14:50:10', 1, 'KIT8685735c'),
(101, '[email protected]', 'desmoit', '22f52245c15d5db52f7213a9a3f0b93090dae2e5', 'user', 1, 'energ', '0ea77e28de12a682ea83f2fbbbf688f6', 'Bosseur fou', '2015-01-17 16:47:08', 1, 'cb77c1a16257926f13de8f30cdd48f74'),
(62, '[email protected]', 'Benoit', 'e148a70fe1c9d2586a2f06ec6ab3a72d6e32a2ab', 'user', 1, 'ephil', '55265afc5064f74b5af474d6839f2e2d', 'Procrastinateur', '2014-11-11 15:24:40', 1, '1c22d1af888665f39f1858b4e145a446'),
(63, '[email protected]', 'ilyesbouss', 'aecdeb45d489a64a0802c6932f9b03070eebddf7', 'user', 1, 'maths', '0f36dbae0d481a57341b8e7c3140ea83', 'un peu flemmard', '2014-11-11 15:33:53', 1, '850262f118249f0415c84b77a7b89862'),
(64, '[email protected]', 'epuroski', '03328386be11afd07a4c395579cf4c11b057f5a4', 'user', 1, 'codep', 'c4a67f695dec1d66a0769354d5746c90', 'Rugbeuse', '2014-11-11 16:19:13', 1, 'f01bf4252b9895196bc3cc11414a6da1'),
(65, '[email protected]', 'ldouteau', '25e0fd8725683747c5289de383db9d3b0a67e045', 'user', 2, 'metod', 'b7d85c91d9aeb476d488d6b205dd30c1', 'Escroc', '2014-11-11 17:26:42', 1, '1dd05cbf68f6799900de18e4ca455c28'),
(67, '[email protected]', 'ibancel', 'e400130359d77ce8cbd927e5bcf5ebc1d1d8fe4f', 'user', 1, 'algpr', '5bef1583a1b4c9611f230b22a61604d9', 'normal', '2014-11-13 06:31:22', 1, 'b5f6cf5f92f20c9f557e22db553e4703'),
(68, '[email protected]', 'clestang ', '1fb78b150fb916b4e7e426bc45fe4a74e7594583', 'user', 1, 'ceshs', '28f4e1d79a7f5aba6f677545d23087fd', 'grimpeur ', '2014-11-13 13:12:23', 1, 'KIT8332143c'),
(69, '[email protected]', 'ridane', 'cbc62e57ebfd0380a21162ceda9fe117f0763034', 'user', 1, 'maths', 'd0e57225c4ac5f8ce19c50af62b1f281', 'chill !', '2014-11-13 17:13:30', 1, '2d363532515f1cadba09c3eefd5ca57c'),
(70, '[email protected]', 'Quentin Reynaud', '2b3125f8f287e04522376443cbd5034df11a7e5b', 'user', 1, 'algpr', 'b6f0039ca1b3db9638c1e2a11e16da13', 'Rigoureux', '2014-11-13 17:36:28', 1, '14f60fb6cdbdb79103f5b3ddddaf3ad6'),
(71, '[email protected]', 'pychassain', '09728404f1e51196c689e47d179d3991b40bd615', 'user', 1, 'memco', 'a75157ecbe884dde3396e321b7220015', 'Rigoureux', '2014-11-14 16:24:56', 1, 'cbe9ca1e920a14c263bd3ef8a81d1390'),
(72, '[email protected]', 'gael17', '432ba3388656ab330ec3d8a302898a0f92def1af', 'user', 1, 'algpr', 'd40d073992f795eb1813a0ca2059199e', 'Sixtoys', '2014-11-16 20:26:18', 1, '5725da2a951679a162acd5b377964301'),
(73, '[email protected]', 'marieb', '9934f43b4b3c21b367c3c7b52589b404af491379', 'user', 1, 'algpr', '695c31484795f4c9182e0ba77c5af515', 'flemmarde', '2014-11-16 21:45:21', 1, '4ece2072c65d795aca7dff87e62cae88'),
(74, '[email protected]', 'antonior', '03064790203546e59e08e5f29cf2b80b6690ddbc', 'user', 1, 'ccube', '56e994ec39d920ef5031d53434d7f92b', 'cool....', '2014-11-18 11:55:09', 0, '20c6e1c98927c7681c37d6994a8f477d'),
(75, '[email protected]', 'antoniode', 'fbe7784e70e96ae624be98a0b5ecf7ef96646e7e', 'user', 1, 'ccube', 'a0ee9ff7f0355b89895c55a398a8e7dc', '...cool.', '2014-11-18 12:00:15', 1, '58fa6e451ee2c069fd2318b6bdaafcec'),
(76, '[email protected]', 'cdaoudal', 'caf09615e73b98db70a1012c1e3a06a23d045490', 'user', 1, 'energ', '6b0b87ac03a6c9563d9fa9d8d3177002', 'frileuse', '2014-11-18 17:31:05', 1, 'KIT5754871c'),
(77, '[email protected]', 'Drouet', '81c0472a7ba15379f64f7f3d63a58d49f61a66a2', 'user', 1, 'mater', '21b2b574fe6df8dedfdd6c47eda5f712', 'Occupé', '2014-11-19 07:21:20', 1, 'KIT1356252c'),
(78, '[email protected]', 'fthomas', 'adee968b30d18ef6779e504d0ffbe2c0ead6ed3f', 'user', 1, 'maths', 'efa6dfcb751c3371af3ccb8f7ab3f6a8', 'Coolos', '2014-11-21 12:17:11', 1, 'a2c52097be17f8576ec5b7cd4c87fe34'),
(79, '[email protected]', 'VoniaR', '51964c0259f249706a5a04832d1614c7cbce29b1', 'user', 1, 'ceshs', '6c3008e2991c387552daf6cc098a1d4c', 'perfectionniste flemmarde', '2014-11-22 16:51:30', 1, 'cb3b91b468cda064b0aea3c1582024a5'),
(80, '[email protected]', 'Laura Guillot', 'c7a4554cddd369c57850ede01011155f8c64c9be', 'user', 1, 'fluid', '482f60391009bca36571aeabd72c9018', 'Rigoureuse', '2014-11-23 14:39:21', 1, '5281152a6196103742e5f2c80e32d974'),
(81, '[email protected]', 'nantoine', '2d75468ee8cfe34477d756896bf72553a45efc36', 'user', 1, 'ccube', '43b94c46c14a1b4d3cd569682150e2be', 'Gentil', '2014-11-23 16:33:58', 1, '16638d7e48da90a856fdbe3b02ac2bb0'),
(82, '[email protected]', 'Helixir', '4dc44eb494f10242a506bfdf06373424e15db72a', 'user', 1, 'memco', 'ebc6cdbf62dce52d9ed8f438a584c8ee', 'rigoureux', '2014-11-23 21:01:01', 1, '4f75509b738aeca21541eeeec3e9cac5'),
(83, '[email protected]', 'redumas', '5fe342d56b5cfc6ccb7bddcd4f9a4fced0689497', 'user', 2, 'change', '752540ce95cac137ec6aaf95ec921865', 'coucou', '2014-11-23 22:23:01', 1, 'e1a674b8bca9b55fc6c86ec2678a308a'),
(84, '[email protected]', 'vaurien', '7c1c23a437cd4b9e5f56a2eccf0a3015cd0fe6ae', 'user', 1, 'mater', 'ac921fdcd7d4caa5334f6faff1383dec', 'BAD ;)', '2014-11-26 12:17:06', 1, 'a788963c82d46969f1fe6898c41f35d0'),
(85, '[email protected]', 'jbalberge', '06149ed11438b0c906370a5e167e0a2696cec5bf', 'user', 1, 'memco', '8775b59879ed962109939d7676c963e4', 'oui oui', '2014-11-26 14:43:39', 1, '84e21c991c2abeb341b0467bf91cb6b2'),
(86, '[email protected]', 'Bernardo', 'c53a74b5e834fc562a4f348bc85c75dab460aa0d', 'user', 1, 'fluid', 'b4a8581547f4784f0d90d9662e5dbef6', 'Rigoureux', '2014-12-01 14:30:09', 1, 'fe1d6334b894e9d84342edc2ab5fef63'),
(87, '[email protected]', 'cmoutard', '524dff13d3115bc12d44bcfd1cd9d9cb6963cb20', 'user', 1, 'energ', '0996921b0e16858cf59e22a42ea42ad2', 'Cool, Stressée', '2014-12-01 19:06:11', 1, 'e4227d5c180e0577149ed03f265d7f0e'),
(88, '[email protected]', 'ctriquet', '836f415c7175831597464f9d6789693bc59d8fb7', 'user', 1, 'ccube', 'a370ea0069c15caec059a89e313365de', 'tranquille', '2014-12-05 10:16:27', 1, 'c5144873f050af5c9ac74ac0465f8188'),
(89, '[email protected]', 'aandujar', '999caf3367e89975043b731b0a1cf871d8aa2643', 'user', 1, 'ccube', 'a6a9e09cfcbbc619cbfc3fd6148fffaf', 'Rigoureux', '2014-12-06 18:29:33', 1, 'e82bb5eaf26649e73250a07fcbea0dfb'),
(90, '[email protected]', 'SebastienG', '3347a37e771851aa9fa31fb965b1dcec43fc90e4', 'user', 1, 'algpr', '41a3da07182980cf350d669a1240282b', 'Rigoureux', '2014-12-09 19:27:45', 1, 'f75840898219498bb33207e636055d0c'),
(91, '[email protected]', 'Robin Hood', 'e0d8fec6db6a60c3a7cc3acb1f39fd73c230c063', 'user', 1, 'fluid', '625a7de90b34cf1f2c36e48cd5833c7e', 'taquin', '2014-12-10 12:27:26', 1, '7f3fd12b799771bf869ff2067bbb1d22'),
(92, '[email protected]', 'Remy M', 'cb6049e416b33a0222e7cc2f2f24905cafcc86d6', 'user', 1, 'algpr', '874fcf1fcc76f917a12c9c120381f3c4', 'Trooll', '2014-12-15 19:48:24', 1, 'c8397c15b514744815a9cb35e99573db'),
(93, '[email protected]', 'ahijos', '1c49a8cdad7be83096b9b1dfa0cf2e7596b05881', 'user', 1, 'memco', 'd0e315aa3795c2a32063d255328ee69b', 'cooool', '2014-12-19 16:40:53', 1, 'KIT3880234c'),
(96, '[email protected]', 'tanguy', '54209da9d45a698aa161d37fbcb9e3f9d9395081', 'user', 1, 'algpr', 'e5ac06552fc3786439716367fc03c4bc', 'coolos', '2015-01-12 20:15:40', 1, '1b155265e2a4564d64d4ea8a475e7698'),
(94, '[email protected]', 'Kirzzz', '633398533ef8a0920b09601913eacd477c0d7ec1', 'user', 1, 'ccube', 'eb342d33c1b441b9a72d70297c4711e7', 'ohohoh', '2015-01-05 17:45:14', 1, '030e31d0035b781c2cbbd91722ebd1b3'),
(95, '[email protected]', 'ighirmehdi', '0ecb07b078c11228c490116da2e572151305efd3', 'user', 1, 'memco', '7abe3c0bb053f8fc2e1c0cdbb5b48b82', 'Paresseux, cool, absent', '2015-01-08 22:11:18', 1, 'KIT1552577c'),
(122, '[email protected]', 'hantmoody', '62b9097d97cba3e56e96a77989a5d899ffd37ca2', 'user', 1, 'algpr', 'd0e55d83e4b4f7da0bc94cc56ec8145a', 'Rigoureux', '2015-01-21 10:41:35', 1, '324643201e090fafbb7fbc62e91e817d'),
(97, '[email protected]', 'Violette', '511b49fe6d5e043080c2380e0866f15fcb94cedb', 'user', 1, 'algpr', 'a52e461051ae8927c98e80a67d9a017c', 'rigoureuse', '2015-01-13 18:07:47', 1, '669120a4038c1731b1e0fffa5189f8f8'),
(98, '[email protected]', 'amnfissi', '70cbc7f294ebcb9c257a0035c7fc7af25be1e741', 'user', 1, 'algpr', 'f12dbd9c4007f1032f53b15a6d216f3b', 'cooool', '2015-01-13 21:17:12', 1, 'KIT2091562c'),
(99, '[email protected]', 'yfletberliac', '4f33b27ca24150edfda6435d9f2ceb8993c5dbcf', 'user', 2, 'objet', '28062377e081f8b097557796c32132d3', 'rigoureux (tres)', '2015-01-14 11:48:39', 1, 'KIT4015923c'),
(100, '[email protected]', 'oagneray', '25bc9bf6c8673d256371c4cd8929784226a11ed8', 'user', 1, 'algpr', 'a84b95f976159112956e8216e5799a37', 'Bosseur mais pas trop', '2015-01-14 15:06:35', 1, 'KIT8352951c'),
(102, '[email protected]', 'Andrea', '04f7892e940238a42e0217bc876ef5cd038c7118', 'user', 1, 'fluid', '4f3b01a0ba1aee18de0e1188c52646c6', 'Cool mais rigoureuse', '2015-01-18 15:42:46', 1, 'f9c0677baf823e36b61bb1e3eee23e9d'),
(103, '[email protected]', 'marnal', 'a3ec4c9e4048d1c01e13af66b04853a168ab3777', 'user', 1, 'ccube', '26de4c7f6dc74eb3ea84dfd6dbbe6109', 'no stress', '2015-01-18 16:01:17', 1, '10613ecabca85c36c47df5333267a287'),
(104, '[email protected]', 'patataburger', '5ce3ff9a3a164df3669277e736bf4d3b390e0242', 'user', 1, 'energ', 'bb28cdd885d1da7de8f511cfeec0c728', 'bosseur occasionnel', '2015-01-18 16:05:10', 0, '5c447e6c15a0a5e9dab0dfd6e6ff9b56'),
(105, '[email protected]', 'maraldi', 'b3c94333c5d25b5d0a3a8babf90cc71d79b4e0fe', 'user', 1, 'memco', '3827f1a654be6e7e73d694e7d22781ce', 'Normal', '2015-01-18 16:34:24', 1, '71d08df3b15c8c9abbb13ec2de60b03b'),
(106, '[email protected]', 'rbertran', '537325d6ed1b256a8a5e42cc62723a3f282fa830', 'user', 1, 'maths', '127ecfaa15b3b12df5d5276cf97394bc', 'rigoureux ', '2015-01-18 17:57:32', 1, 'f06c2938bf9ee5767aa03a7e3242db7e'),
(107, '[email protected]', 'CaroleLeBol', 'ea670bce6b201869a32f1c377282c9e1e092da24', 'user', 1, 'energ', 'eee5eda28b73ca5aaf57109287376989', 'Volleyeuse', '2015-01-19 11:46:10', 1, 'f5bea2d98b8b1c1f1a17abaf2ca88615'),
(108, '[email protected]', 'mpetitpi', 'd1fa011257da30412d6c3a59e4f27f8ac39190a6', 'user', 1, 'ccube', '7d2d2bfa04230f2dce798b4e6e599de0', ' ', '2015-01-19 15:57:14', 1, '7ce6339e5cff4e23ffc85b4e4830407a'),
(109, '[email protected]', 'Simooon', 'ea7bae821eca9e71535844561886f826366a5557', 'user', 1, 'algpr', 'b705075cbf039d9044c565f9bd249381', 'Rigoureux', '2015-01-19 16:22:53', 1, '627e19d346b9d90bb0c8d974f21f197e'),
(110, '[email protected]', 'nlaroche', '0100838afe9147e60c6495e2fc8c77a5a71c3996', 'user', 1, 'sstem', 'e9a1b70ecee4b8ee61a3415bd96529bf', 'Bosseur Fou', '2015-01-19 20:55:27', 1, 'f700d7eac1cd2973e8f9c834b1987550'),
(111, '[email protected]', 'Vilegoff', '71e8f76c6fb389464ebbe7a06ac8a19c2116b47d', 'user', 1, 'ccube', '7110eda4d09e062aa5e4a390b0a572ac0d2c0220', 'Perdu d''Audencia', '2015-01-19 22:52:20', 1, 'KIT9380551c'),
(112, '[email protected]', 'bouboubou', 'f132ba73f7962385fbc9bf7fa4dd5a51771c9c8c', 'user', 1, 'ceshs', '45b2439015cbc3cd1ed772e44d4e49f2', 'énorme', '2015-01-20 10:33:46', 1, 'KIT3161490c'),
(113, '[email protected]', 'anto6927', 'f4823269e5821ac931d257089d7a763fb836ffc5', 'user', 1, 'ccube', 'da3e8a7a8553f6ac5d83bdaf2138398e', 'bosseur', '2015-01-20 10:35:17', 1, '8efbadf1de4aa5b7d0eba0f0f420efae'),
(114, '[email protected]', 'aecenci', 'a4be35857ad706abf2b4068d27a8b1bf8596a477', 'user', 1, 'selec', 'c7e9efefd2b1591c534b5582cac9679e', 'Rigoureux', '2015-01-20 11:30:44', 1, 'cad2e5878ad9930124ac36dd6990e3cb'),
(115, '[email protected]', 'florianabadie', '53b942c9b95b8a29e3f8f9bfd3b566427db94ac5', 'user', 1, 'fluid', 'f7e19bd3199df61e0a04bee6ab31699b', 'Rigolo', '2015-01-20 11:54:44', 1, 'dda818aed078ba30463e327b5e0fcfa8'),
(116, '[email protected]', 'LeanaRosePicot', 'dd7f8369b1c6791a9d93b59f93a521acea312500', 'user', 1, 'codep', '6e8068c45eb913acb28b95d860170327', 'Procrastinant', '2015-01-20 13:49:49', 1, '9553c83c9b14bc93d23e08c0780f34cd'),
(117, '[email protected]', 'luciadgg', '853fe5e34baef079c2dd64cb74cdfc7645922434', 'user', 1, 'fluid', 'e66ff683c6e98f186b76294ee4c5a6ab', 'Espagnol', '2015-01-20 15:18:51', 1, 'c29e3f03b9969977f4d79bb280563996'),
(118, '[email protected]', 'louispap', '87f8a54059a6c7133fb7ec8f63872c1507ce1c60', 'user', 1, 'ccube', 'c6f6c60bb36246fd5b85d8394e909495', 'coolos', '2015-01-20 16:10:33', 1, 'd2e5f5ec4d3c17882b6cce58b6ece730'),
(119, '[email protected]', 'mkernec', '26583f90247659bcca7c84bc7267d4f74a77be55', 'user', 1, 'energ', 'b61edb3e7dacb254a1f4715ae30c2472', 'rigoureux', '2015-01-20 18:47:14', 1, '7db91dd0bb6b5ac98a57e238f2bc80bd'),
(120, '[email protected]', 'akempfer', '552ba01c25784bf90dcb0a24e1d9274210d35da7', 'user', 1, 'memco', '56f464b3fa04d88bfdf10f163ff6ef67', 'Bosseur généreux', '2015-01-20 19:48:55', 1, '05077102247d0f75d463544647202cf3'),
(121, '[email protected]', 'aarguell', '724e1043eb68ff6103b7c1d931e5009b5f6f0d92', 'user', 1, 'codep', '84a63f5dd84fc41ac6620e1e4edeee88', 'Tranquille', '2015-01-21 09:16:08', 1, 'baf507c0d2ac6550edd64ca916490beb'),
(123, '[email protected]', 'nat8546', 'fd1f2881cd98d530ac3e3084ba21fbb6a0cb1b59', 'user', 1, 'maths', '09a79654e309e57bfe14386e5d148d72', 'cool, rigoureux, ', '2015-01-21 13:26:36', 1, '7a8895411947bdaa394529b053758d39'),
(124, '[email protected]', 'ntodorov', 'bc5516f685e2c180405c8eb2e407d809d0ec8070', 'user', 1, 'maths', '77be64db4ee7e7e012458e1debc5aa55', 'Rigoureux', '2015-01-21 13:35:52', 1, 'd485eeff2ed6140ee11250107dd3594d'),
(125, '[email protected]', 'TIMMAZ', '1d40597d7fe73f344ab7eeeb279f35f2da79fd5e', 'user', 1, 'energ', 'e1cd00e5acea397674cfca7dfc715cf4', 'rigoureux', '2015-01-21 14:48:32', 1, '639e783aea01c2d2b5fa2b332cd786b3'),
(126, '[email protected]', 'tygen02', 'd9d72e8aed1c2ef2e7710033db092674fd673e5c', 'user', 1, 'ccube', '1d52e2f4aed1856dec18320279a4e029', 'fataliste', '2015-01-21 15:43:30', 1, '7e41d78ac756401939ae22361bdca89d'),
(127, '[email protected]', 'Spelou', 'a8cdfce52109a18524ba6f5d0b1b7deb0f9ba765', 'user', 1, 'ccube', '85ae26ab2a89318c853312235e934df9', 'motivé', '2015-01-21 15:44:36', 1, 'KIT3390441c'),
(128, '[email protected]', 'Sweetch001', '77bbf1f395a22695123e9967f2d7af3bc3bcb72c', 'user', 1, 'memco', '17aee524fa10e030ddd7dfaeeaf13d6d', 'Rigoureux', '2015-01-21 18:07:10', 1, 'KIT6607456c'),
(129, '[email protected]', 'Menand', 'aae2200d8349720796b9c4112d13ce52ad124701', 'user', 1, 'memco', '113392996184dcf14ce0814e1c803388', 'Pas cool', '2015-01-22 11:02:02', 1, 'KIT5873085c'),
(130, '[email protected]', 'jcvuille', 'abf0b50a7a70b5a170c1c989aca9e7ade85d6834', 'user', 1, 'erels', '3ae5069be9fbcc0f826ba1779c824ac8', 'peu impliqué', '2015-01-22 14:27:49', 1, '9af7e6a081bbc6a5de4e938c0c54a44a'),
(131, '[email protected]', 'abigourd', 'a4f46b59ff289f5824ed523e8b4d8ee5118c864c', 'user', 1, 'energ', '387f30e3cd079bb39e9d8fa8aa41631a', 'feignant', '2015-01-22 20:13:37', 1, '90e7fce23ac666dc94a6913f0125ca98'),
(133, '[email protected]', 'Marcel', '787b90fcf103a7d36e8554eff1fbf94287e5de47', 'user', 1, 'memco', '0d88f9780512abdbc580fcb791507135', 'Glandu', '2015-01-24 11:55:24', 1, 'c1e010c0cbc0df6e253d9d97135e7fd9'),
(134, '[email protected]', 'Nebonobo', 'd8e1e5bb1ebdff7b934263320b5fc65e462c45ed', 'user', 1, 'energ', '3ef324fb91d650c8bf122d8314373f2e', 'Rigourax, coolax', '2015-01-24 15:32:07', 1, '142d4ba7ffb169aff3b78bf87e9481ad'),
(135, '[email protected]', 'porain', '7201f589caf4c81d85fde7bdad78edf9aca76366', 'user', 1, 'maths', '0a5a486f30b675765a5d29b05ca1f260', '#chapeau', '2015-01-24 17:53:35', 1, 'c8cd567718a2f8a57b4ce21c3dd3e30c'),
(136, '[email protected]', 'Blondine', 'cdb0e25a04d6ce537cbfcc4e8775ffc4281a6e62', 'user', 1, 'energ', 'c2bfa0e006e23ae44a5e29d3f6a30a69', 'Perchée', '2015-01-24 17:58:31', 1, 'e89ca7896b1669a51979459ff1bc72e6'),
(137, '[email protected]', 'Sylvie', '339ac83c01b2ccc0e3707860f4d09765da87eccf', 'user', 2, 'momaq', '72a998e9c5ed7db5c1fd1bcc8a13762b', 'Bonjour', '2015-01-24 18:04:09', 1, '018646b41648eaeb5acc568f26e7a89b'),
(138, '[email protected]', 'JLeTallec', '117d542645eda5f8e6e595d64b9cb2e9a829a0ed', 'user', 1, 'ensar', 'b4c207319bd399844ca67e5055a11963', 'bosseuse quand il faut', '2015-01-24 18:09:22', 1, '549bbce31b9e4107f9820b36b135ba9a'),
(139, '[email protected]', 'jvuillam', 'bda09613b4df3e30aa7f74ccdf0a69b96d8ea316', 'user', 1, 'codep', 'f375e93b761b17345cbf50d064221671', 'chaud ou froid', '2015-01-24 18:10:26', 1, 'KIT9701822c'),
(140, '[email protected]', 'Tweick', '87acec17cd9dcd20a716cc2cf67417b71c8a7016', 'user', 1, 'energ', 'f1ba973d4be4ae6a856421502606288e', 'Opportuniste', '2015-01-24 18:17:22', 1, '15cd3b0a719d4b7c36bc1c7ac414820b'),
(141, '[email protected]', 'Laszlo Horvath', '7451b5d97e4f342760b99aeffb5ad4b32399ce75', 'user', 1, 'maths', 'df372d61d9348935b0c9c5517fccdc4b', 'Rigoureux', '2015-01-24 18:23:33', 1, '5ed84aae7626df9ed222922ca1dc1b63'),
(142, '[email protected]', 'Luisreyes', '8a1f9f729ebad0e751f889d81ba15e3a96dc5fa4', 'user', 1, 'ccube', '5868c15e7773329dafa6b291b440ce68', 'heureux', '2015-01-24 18:35:37', 1, 'a1ad3634db1764f46fc03ccdb13f1c3c'),
(143, '[email protected]', 'elio bassil', '927842c68b0c4644d16666f0a3e44c636056bc7d', 'user', 1, 'ccube', '6a8ed536b710d45d2884aec0fcd0f98a', 'rigoureux', '2015-01-24 18:58:33', 1, 'c7e38e4a6d44ff48e00b49a22c043529'),
(144, '[email protected]', 'jtheveno', '293a93149742ed5169c3e866277c4490d8ffae2b', 'user', 1, 'erels', '49dec2240416e0de110212a3a7d02c70', 'coolesttd', '2015-01-24 19:10:54', 1, 'cc0b76d0b5f162057a9fd81b0e5a8406'),
(145, '[email protected]', 'jambon', 'bc5516f685e2c180405c8eb2e407d809d0ec8070', 'user', 1, 'erels', 'e3f0b8db9e995879901f60a2c0bf3625', 'ydyhjd', '2015-01-24 19:55:23', 1, '002babd331faa7bf7d2bd0626df3e334'),
(146, '[email protected]', 'qduponta', '4ab1a126f928cf3c0022acecfb807ab3648ec221', 'user', 1, 'algpr', '6e40521194a5e228dd7a33ef1b43a3de', 'aetzrg', '2015-01-25 07:31:23', 1, '289901e360306f5c0a95a4011ed285af'),
(147, '[email protected]', 'ddinello', '03d6dcd43fb922ddd321c42624edf5ce73d60b00', 'user', 1, 'energ', 'e386d0516debacd5ea215656ce0c5b05', 'tranquil', '2015-01-25 09:57:23', 1, 'd163d63df5d51cfe91a1354a84082b46'),
(148, '[email protected]', 'vladimir', 'df5c474ca698ab4427c2396b55c551ef59c1d2b0', 'user', 1, 'sstem', '80b96449e7722f00b911c0c5b66a6a23', 'changeant', '2015-01-25 10:08:29', 1, 'KIT7549681c'),
(149, '[email protected]', 'p139426', '0a1590207481a09f4b2eae466378257023865342', 'user', 1, 'selec', '98ccbf3f022d1469998fb054a4bcc731', '123456', '2015-01-25 13:25:30', 1, 'edd1f63206f818f92ace936ac0ce93b7'),
(150, '[email protected]', 'apohibou', 'db2f5f0e7cff36c9e583eb52f86184822c6b438a', 'user', 1, 'energ', 'c5093fe03093abc3102b456e10e42bf0', 'flemmarde', '2015-01-25 14:16:13', 1, '2f1c2513e9cea3afdfa8091f914529b6'),
(151, '[email protected]', 'darksinus', 'b0ef98496a7c843e68a6c51c40b26039872010e8', 'user', 1, 'algpr', 'f6392de6c7647a979d1f367f456ca795', 'Je suis un ei1 !', '2015-01-25 19:38:09', 1, 'b600e0b7f2f345e6f0c6df724a73799d'),
(152, '[email protected]', 'muhammad', '698ab40c0a492e24087cbe8fac4a03abf63ac7bc', 'user', 1, 'algpr', 'ed852761a07603b8fedf8ac4dca1c769', 'simple', '2015-01-25 21:26:33', 1, 'KIT8102140c'),
(153, '[email protected]', 'Monique', 'fa5d0387c0452f435b41c57ab4a3798d0d66e382', 'user', 1, 'energ', 'd052f3deec9bfd2c5f6069c5827dfe46', 'Bosseur', '2015-01-25 21:43:35', 1, '2bbb90d99a28821402447e75d13701ef'),
(154, '[email protected]', 'johndu69', '990bfe48de99753d4781b916f539c9a14490a8af', 'user', 2, 'envma', '962d947f65fc8b5c104bf25ac2c47ac1', 'Matlab ambassador', '2015-01-25 21:46:03', 1, 'KIT1647187c'),
(155, '[email protected]', 'gmorin', '59eff7d20d7f0365821ad5064058c5a871c5545a', 'user', 1, 'mater', '9cb37987259d2330fe61a03a912e1ce5', 'glandu', '2015-01-25 22:10:49', 1, 'cf2d2236e36317f13330405b0e93ee57'),
(156, '[email protected]', 'jmlegoff', '619f1b661ef5b2c713956c2b3dbe40aa2510267d', 'user', 2, 'envma', '74f2414cec8d89fc10a3bbc27a4912c1', 'Rigoureux, cool, bosseur fou', '2015-01-26 08:06:41', 1, '287a1e68dd2ccd234f921f2b4dc602cc'),
(157, '[email protected]', 'meimei', 'e2e3f4f1b2c291888d491c330f1378a713e45876', 'user', 1, 'ccube', '210a7e4bf3c8227dd28e66439e7f803d', 'CoolCool', '2015-01-26 16:56:25', 1, '35896d3b432e674a7810b346373c9191'),
(158, '[email protected]', 'cl2327', '2340c8f74cadd4cc388f4d39d99c5baebf18e347', 'user', 1, 'ceshs', '2d1421b0a65c3f2d2216ccc451489101', 'rigoureuse', '2015-01-26 17:15:45', 1, '6b808b8eda9008ef8309873215fae391'),
(159, '[email protected]', 'dinyguy', 'd66f7ff1cc77ab1bf0649866cd412c307c83af15', 'user', 1, 'algpr', '3325b17d942d103b714c355b387aa9aa', 'flemmard', '2015-01-26 21:35:34', 1, '756d61b2e8ad5b4fc00974de58859a48'),
(160, '[email protected]', 'theoreg', '1aa85d8ef7593cffbf52d72f19619ece51b00764', 'user', 1, 'energ', '23d2376db6daf8045035aafda8476fdf', 'Plutôt cool', '2015-01-27 17:09:23', 1, '0831c09a9f4d1603e0f62ae213b62a91'),
(161, '[email protected]', 'marineldl', '017fe59a1b949c489f377faae6cb80d46750f4d9', 'user', 2, 'm_sma_m2_temer', 'a29e8ec02bfa20f94fa3c8655e763695', 'Kikou poney', '2015-01-27 21:07:05', 1, 'a6abe9b2e0fd4fd9c5d25dccf37eaec5'),
(162, '[email protected]', 'Hermillion', 'c3dee453705e6c7ea5fd7e3f7473625c3d63c871', 'user', 1, 'erels', '704d715481956101d8b6847b5740354c', 'Glandeur', '2015-01-27 23:11:19', 1, '69d71c7a21b681d1de38081f410be6c0'),
(163, '[email protected]', 'phebrard', 'bc5516f685e2c180405c8eb2e407d809d0ec8070', 'user', 2, 'smult', '622c937bff411280a2d77cb99c64f27a', 'rigoureux cool', '2015-01-30 15:29:05', 1, 'KIT1471985c'),
(164, '[email protected]', 'BokuNoPico', '5a9bf472621d6119dff6d57a265f936015ddd513', 'user', 1, 'fluid', '2d2350d5311a8debea1ad9ecf8923472', 'jambonneur', '2015-02-11 01:23:11', 1, 'c185a161fdd4fd89463cddb4e6b0c203'),
(165, '[email protected]', 'Gabrielle G', 'd200c2f1932f492507e70c3276f98da5fc7d16a0', 'user', 1, 'memco', '56885ef3f3ddb120b1c691fd1016a97a', 'Rigoureux', '2015-02-15 11:24:13', 1, '48e0b55f4b06366462b64cee18883e14'),
(166, '[email protected]', 'mrodari', '635341faf9ac5c3767e4bb0ded704470bfad2f49', 'user', 2, 'treel', '94df512a590cb3e89a427670dd729dec', 'jolie zouz', '2015-03-05 17:52:23', 1, '4a073ca7ee7334f8443d6c8515b8d99e'),
(167, '[email protected]', 'Pierre Grison', '6b580a8340daa45e0a15b35e8b9116fa1021f7a6', 'user', 1, 'memco', 'ebb5ba55a4a1403360fa1aac4d4183e5', 'Glandeur fou', '2015-03-05 21:54:08', 1, '663bf7f41f68dbf6628764dcd5d607ba'),
(168, '[email protected]', 'Zoulette37', '99d721cafbfeaf19bf994a731157f8cee04e2044', 'user', 1, 'mater', '532306f39706ffbedf2ba5a71f49cb0a', 'Enervé', '2015-03-09 22:27:05', 1, 'b82a82b8b2a99999953c20d8eff7b8d1'),
(169, '[email protected]', 'yannc26', 'b01903a0d888b6d2de1b04b874ded4db70e67d85', 'user', 1, 'algpr', 'f614fb5b0b1e2f574607087264b0e5ff', 'Bizarre', '2015-03-12 15:01:53', 1, '83726a6be7296d5e36561762c4ab72fa'),
(170, '[email protected]', 'hoskian', '0845029a30c05aabf2c0497d77f0ac7392f89084', 'user', 1, 'fluid', 'b3adb7a29ea0774d932a2e38b4969a09', 'realisateur', '2015-03-13 09:51:09', 1, '48e58b142c6be6ae073b00caedfe24b9'),
(171, '[email protected]', 'fmahe56', '684419def96bb995b86958ae599b690091c8d8bb', 'user', 1, 'fluid', 'ea5a5f4ad55a3c670cccc82f145a0ea6', 'Sérieux', '2015-03-15 17:48:40', 1, '4a0441f60051bf0ebc3f31b0789816ee'),
(172, '[email protected]', 'Fanny C', 'dba4a556ad6b1971d1a893a1aa5cc6f37dea8c23', 'user', 1, 'codep', '07809b07debe170120032359d41d500b', 'Tranquille', '2015-03-15 21:22:13', 1, 'fac243d0b27cc9cb7b72e3aef69bedaa'),
(173, '[email protected]', 'BastosLaRafale', 'da260dd5a9e73a52b8043346e2c6473460b8e236', 'user', 1, 'algpr', 'e08aecb4a13793fb0ecdc59fb6219e98', 'Easy Money', '2015-03-15 21:54:07', 1, 'e152c263738ffd815330b751079f43e9');
-- --------------------------------------------------------
--
-- Structure de la table `openu_acl`
--
CREATE TABLE IF NOT EXISTS `openu_acl` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`module` varchar(100) NOT NULL,
`action` varchar(100) NOT NULL,
`group_name` varchar(50) NOT NULL,
`access` varchar(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=22 ;
--
-- Contenu de la table `openu_acl`
--
INSERT INTO `openu_acl` (`id`, `module`, `action`, `group_name`, `access`) VALUES
(1, '*', '*', 'admins', 'allow'),
(2, 'admin', '*', 'admins', 'allow'),
(3, 'admin', '*', '*', 'deny'),
(19, 'auth', 'login', 'unregistered', 'allow'),
(20, 'auth', 'register', 'unregistered', 'deny'),
(21, 'auth', '*', 'unregistered', 'deny'),
(7, 'auth', '*', '*', 'allow'),
(17, 'files', 'g', 'unregistered', 'allow'),
(18, 'files', '*', 'unregistered', 'deny'),
(11, 'files', '*', '*', 'allow');
-- --------------------------------------------------------
--
-- Structure de la table `openu_activitylog`
--
CREATE TABLE IF NOT EXISTS `openu_activitylog` (
`id` int(20) NOT NULL AUTO_INCREMENT,
`level` varchar(20) NOT NULL,
`log_time` datetime NOT NULL,
`ip` varchar(20) NOT NULL,
`user_login` varchar(100) NOT NULL,
`module` varchar(50) NOT NULL,
`action` varchar(50) NOT NULL,
`realaction` varchar(50) DEFAULT NULL,
`plugin` varchar(50) DEFAULT NULL,
`result` varchar(100) DEFAULT NULL,
`moreinfo` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=180 ;
--
-- Contenu de la table `openu_activitylog`
--
INSERT INTO `openu_activitylog` (`id`, `level`, `log_time`, `ip`, `user_login`, `module`, `action`, `realaction`, `plugin`, `result`, `moreinfo`) VALUES
(1, 'notice', '2014-09-30 11:17:23', '81.220.67.23', 'admin', 'files', 'u', 'uploadConfirm', '', 'ALLOW', 'vNlqmW4jbV'),
(2, 'notice', '2014-09-30 11:18:41', '81.220.67.23', 'admin', 'files', 'u', 'uploadConfirm', '', 'ALLOW', 'KW8SFoRfRF'),
(3, 'warning', '2014-09-30 11:22:02', '81.220.67.23', 'admin', 'files', 'u', 'uploadOptions', '', 'DENY', 'Upload error: Partial file transfer error!'),
(4, 'security', '2014-09-30 11:26:53', '81.220.67.23', '', 'auth', 'login', 'authenticate', '', 'DENY', 'Login failed: admin'),
(5, 'security', '2014-09-30 11:26:53', '81.220.67.23', '', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged out'),
(6, 'security', '2014-09-30 11:27:38', '81.220.67.23', 'admin', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(7, 'notice', '2014-09-30 11:28:27', '81.220.67.23', 'admin', 'files', 'u', 'uploadConfirm', '', 'ALLOW', '6v9Jjuie7H'),
(8, 'security', '2014-09-30 11:29:33', '81.220.67.23', 'admin', 'auth', 'logout', 'authenticate', '', 'ALLOW', 'User logged out'),
(9, 'security', '2014-09-30 11:30:27', '81.220.67.23', 'admin', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(10, 'notice', '2014-09-30 11:30:32', '81.220.67.23', 'admin', 'files', 'g', 'serveFile', '', 'ALLOW', '6v9Jjuie7H'),
(11, 'security', '2014-09-30 11:33:34', '81.220.67.23', 'admin', 'auth', 'logout', 'authenticate', '', 'ALLOW', 'User logged out'),
(12, 'security', '2014-09-30 11:34:29', '81.220.67.23', '', 'auth', 'login', 'authenticate', '', 'DENY', 'Login failed: machine'),
(13, 'security', '2014-09-30 11:34:29', '81.220.67.23', '', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged out'),
(14, 'security', '2014-09-30 11:34:52', '81.220.67.23', '', 'auth', 'login', 'authenticate', '', 'DENY', 'Login failed: machine'),
(15, 'security', '2014-09-30 11:34:52', '81.220.67.23', '', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged out'),
(16, 'security', '2014-09-30 11:47:32', '81.220.67.23', '', 'auth', 'login', 'authenticate', '', 'DENY', 'Login failed: machine'),
(17, 'security', '2014-09-30 11:47:32', '81.220.67.23', '', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged out'),
(18, 'security', '2014-09-30 11:48:54', '81.220.67.23', '', 'auth', 'login', 'authenticate', '', 'DENY', 'Login failed: machine'),
(19, 'security', '2014-09-30 11:48:54', '81.220.67.23', '', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged out'),
(20, 'security', '2014-09-30 11:48:56', '81.220.67.23', '', 'auth', 'login', 'authenticate', '', 'DENY', 'Login failed: machine'),
(21, 'security', '2014-09-30 11:48:56', '81.220.67.23', '', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged out'),
(22, 'security', '2014-09-30 11:49:08', '81.220.67.23', '', 'auth', 'login', 'authenticate', '', 'DENY', 'Login failed: machine'),
(23, 'security', '2014-09-30 11:49:08', '81.220.67.23', '', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged out'),
(24, 'security', '2014-09-30 11:50:22', '81.220.67.23', '', 'auth', 'login', 'authenticate', '', 'DENY', 'Login failed: machine'),
(25, 'security', '2014-09-30 11:50:22', '81.220.67.23', '', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged out'),
(26, 'notice', '2014-09-30 11:57:06', '81.220.67.23', '', 'auth', 'register', 'registerEnable', '', 'OK', 'machine'),
(27, 'security', '2014-09-30 11:57:14', '81.220.67.23', 'machine', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(28, 'notice', '2014-09-30 12:00:33', '81.220.67.23', 'machine', 'files', 'u', 'uploadConfirm', '', 'ALLOW', 'JkSafKgXSl'),
(29, 'security', '2014-09-30 12:01:08', '81.220.67.23', 'machine', 'auth', 'logout', 'authenticate', '', 'ALLOW', 'User logged out'),
(30, 'security', '2014-09-30 12:01:15', '81.220.67.23', '', 'auth', 'login', 'authenticate', '', 'DENY', 'Login failed: admin2'),
(31, 'security', '2014-09-30 12:01:15', '81.220.67.23', '', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged out'),
(32, 'security', '2014-09-30 12:01:45', '81.220.67.23', 'admin', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(33, 'notice', '2014-09-30 12:18:08', '81.220.67.23', 'admin', 'files', 'u', 'uploadConfirm', '', 'ALLOW', '0858129615'),
(34, 'security', '2014-09-30 19:31:29', '81.220.67.23', '', 'auth', 'login', 'authenticate', '', 'DENY', 'Login failed: admin2'),
(35, 'security', '2014-09-30 19:31:29', '81.220.67.23', '', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged out'),
(36, 'security', '2014-09-30 19:31:39', '81.220.67.23', 'admin', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(37, 'security', '2014-09-30 19:34:07', '81.220.67.23', 'admin', 'admin', 'adminbanned', 'banned', '', 'DENY', ''),
(38, 'security', '2014-09-30 20:08:14', '80.215.196.253', 'admin', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(39, 'security', '2014-10-01 04:48:05', '81.220.67.23', 'admin', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(40, 'notice', '2014-10-01 04:48:17', '81.220.67.23', 'admin', 'files', 'g', 'serveFile', '', 'ALLOW', '6v9Jjuie7H'),
(41, 'security', '2014-10-31 20:40:21', '83.156.188.170', 'admin', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(42, 'security', '2014-11-02 15:34:21', '83.156.188.170', 'admin', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(43, 'security', '2014-11-06 14:53:56', '130.66.205.76', '', 'files', 'u', 'banned', '', 'DENY', ''),
(44, 'security', '2014-11-06 14:54:08', '130.66.205.76', '', 'files', 'u', 'banned', '', 'DENY', ''),
(45, 'security', '2014-11-06 14:55:09', '130.66.205.76', '', 'files', 'u', 'banned', '', 'DENY', ''),
(46, 'security', '2014-11-06 14:58:53', '130.66.205.76', '', 'files', 'u', 'banned', '', 'DENY', ''),
(47, 'security', '2014-11-07 12:16:21', '81.220.67.23', 'admin', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(48, 'notice', '2014-11-07 12:18:10', '81.220.67.23', 'admin', 'files', 'u', 'uploadConfirm', '', 'ALLOW', '2228655895'),
(49, 'notice', '2014-11-07 12:19:33', '81.220.67.23', 'admin', 'files', 'u', 'uploadConfirm', '', 'ALLOW', '5951441983'),
(50, 'notice', '2014-11-07 12:20:20', '81.220.67.23', 'admin', 'files', 'u', 'uploadConfirm', '', 'ALLOW', '3365298245'),
(51, 'security', '2014-11-07 20:23:21', '81.220.67.23', 'admin', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(52, 'notice', '2014-11-07 20:26:17', '81.220.67.23', 'admin', 'files', 'u', 'uploadConfirm', '', 'ALLOW', '0472373847'),
(53, 'notice', '2014-11-07 20:28:10', '81.220.67.23', 'admin', 'files', 'u', 'uploadConfirm', '', 'ALLOW', '5576482081'),
(54, 'notice', '2014-11-07 20:28:56', '81.220.67.23', 'admin', 'files', 'u', 'uploadConfirm', '', 'ALLOW', '2831868878'),
(55, 'notice', '2014-11-07 20:30:20', '81.220.67.23', 'admin', 'files', 'u', 'uploadConfirm', '', 'ALLOW', '4624563174'),
(56, 'notice', '2014-11-07 20:31:04', '81.220.67.23', 'admin', 'files', 'u', 'uploadConfirm', '', 'ALLOW', '3345189259'),
(57, 'notice', '2014-11-07 20:31:41', '81.220.67.23', 'admin', 'files', 'u', 'uploadConfirm', '', 'ALLOW', '4834167136'),
(58, 'notice', '2014-11-07 20:32:22', '81.220.67.23', 'admin', 'files', 'u', 'uploadConfirm', '', 'ALLOW', '8431569602'),
(59, 'notice', '2014-11-07 20:33:26', '81.220.67.23', 'admin', 'files', 'u', 'uploadConfirm', '', 'ALLOW', '8659511211'),
(60, 'notice', '2014-11-07 20:36:12', '81.220.67.23', 'admin', 'files', 'u', 'uploadConfirm', '', 'ALLOW', '4812525523'),
(61, 'notice', '2014-11-07 20:36:53', '81.220.67.23', 'admin', 'files', 'u', 'uploadConfirm', '', 'ALLOW', '4096755755'),
(62, 'notice', '2014-11-07 20:37:13', '81.220.67.23', 'admin', 'files', 'g', 'serveFile', '', 'ALLOW', '4096755755'),
(63, 'security', '2014-11-08 02:03:38', '81.220.67.23', 'admin', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(64, 'security', '2014-11-08 03:26:47', '80.215.226.193', 'simolaraki', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(65, 'notice', '2014-11-08 03:26:51', '80.215.226.193', 'simolaraki', 'files', 'g', 'serveFile', '', 'ALLOW', '2831868878'),
(66, 'security', '2014-11-08 04:46:11', '81.220.67.23', 'admin', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(67, 'security', '2014-11-08 15:24:42', '81.220.67.23', 'admin', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(68, 'security', '2014-11-08 17:55:32', '81.220.67.23', 'admin', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(69, 'notice', '2014-11-08 17:55:37', '81.220.67.23', 'admin', 'files', 'g', 'serveFile', '', 'ALLOW', '2228655895'),
(70, 'security', '2014-11-08 20:02:51', '92.102.90.48', '', 'auth', 'login', 'authenticate', '', 'DENY', 'Login failed: admin'),
(71, 'security', '2014-11-08 20:02:51', '92.102.90.48', '', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged out'),
(72, 'security', '2014-11-08 20:03:28', '92.102.90.48', '', 'auth', 'login', 'authenticate', '', 'DENY', 'Login failed: admin'),
(73, 'security', '2014-11-08 20:03:28', '92.102.90.48', '', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged out'),
(74, 'security', '2014-11-08 20:03:42', '92.102.90.48', 'admin', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(75, 'notice', '2014-11-08 20:04:21', '92.102.90.48', 'admin', 'files', 'g', 'serveFile', '', 'ALLOW', '3365298245'),
(76, 'notice', '2014-11-08 20:05:49', '92.102.90.48', 'admin', 'files', 'u', 'uploadConfirm', '', 'ALLOW', '2250559101'),
(77, 'notice', '2014-11-08 20:06:45', '92.102.90.48', 'admin', 'files', 'g', 'serveFile', '', 'ALLOW', '2250559101'),
(78, 'security', '2014-11-08 20:07:40', '92.102.90.48', 'admin', 'auth', 'logout', 'authenticate', '', 'ALLOW', 'User logged out'),
(79, 'security', '2014-11-09 04:08:07', '81.220.67.23', 'admin', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(80, 'notice', '2014-11-09 04:08:24', '81.220.67.23', 'admin', 'files', 'r', 'removeResult', '', 'ALLOW', '2250559101'),
(81, 'security', '2014-11-10 15:49:07', '130.66.101.1', '', 'files', 'u', 'banned', '', 'DENY', ''),
(82, 'security', '2014-11-10 16:34:28', '81.220.67.23', 'admin', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(83, 'security', '2014-11-11 21:20:16', '81.220.67.23', 'admin', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(84, 'notice', '2014-11-11 21:21:11', '81.220.67.23', 'admin', 'files', 'g', 'serveFile', '', 'ALLOW', '2228655895'),
(85, 'security', '2014-11-11 22:45:31', '81.220.67.23', 'admin', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(86, 'notice', '2014-11-11 22:45:50', '81.220.67.23', 'admin', 'files', 'g', 'serveFile', '', 'ALLOW', '2228655895'),
(87, 'notice', '2014-11-11 22:49:00', '81.220.67.23', 'admin', 'files', 'g', 'serveFile', '', 'ALLOW', '2228655895'),
(88, 'notice', '2014-11-12 00:46:23', '81.220.67.23', 'admin', 'files', 'u', 'uploadConfirm', '', 'ALLOW', '5728350869'),
(89, 'notice', '2014-11-12 00:49:13', '81.220.67.23', 'admin', 'files', 'u', 'uploadConfirm', '', 'ALLOW', '0234915013'),
(90, 'security', '2014-11-12 00:51:21', '81.220.67.23', 'admin', 'auth', 'logout', 'authenticate', '', 'ALLOW', 'User logged out'),
(91, 'security', '2014-11-12 00:51:31', '81.220.67.23', 'barbarien', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(92, 'security', '2014-11-12 00:52:12', '81.220.67.23', 'barbarien', 'auth', 'logout', 'authenticate', '', 'ALLOW', 'User logged out'),
(93, 'security', '2014-11-12 00:52:14', '81.220.67.23', 'barbarien', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(94, 'notice', '2014-11-12 00:53:33', '81.220.67.23', 'barbarien', 'files', 'u', 'uploadConfirm', '', 'ALLOW', '3604395065'),
(95, 'security', '2014-11-21 13:19:48', '92.95.45.101', 'fthomas', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(96, 'notice', '2014-11-21 13:19:51', '92.95.45.101', 'fthomas', 'files', 'g', 'serveFile', '', 'ALLOW', '3604395065'),
(97, 'notice', '2014-11-21 13:20:04', '92.95.45.101', 'fthomas', 'files', 'g', 'serveFile', '', 'ALLOW', '5728350869'),
(98, 'notice', '2014-11-21 13:20:25', '92.95.45.101', 'fthomas', 'files', 'g', 'serveFile', '', 'ALLOW', '0234915013'),
(99, 'security', '2014-11-23 21:27:22', '81.220.67.23', 'barbarien', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(100, 'notice', '2014-11-23 21:27:27', '81.220.67.23', 'barbarien', 'files', 'g', 'serveFile', '', 'ALLOW', '3365298245'),
(101, 'security', '2014-11-28 08:04:03', '92.95.45.101', 'fthomas', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(102, 'notice', '2014-11-28 08:04:06', '92.95.45.101', 'fthomas', 'files', 'g', 'serveFile', '', 'ALLOW', '0234915013'),
(103, 'notice', '2014-11-28 08:04:31', '92.95.45.101', 'fthomas', 'files', 'g', 'serveFile', '', 'ALLOW', '3604395065'),
(104, 'security', '2014-12-09 20:30:31', '46.193.140.217', 'SebastienG', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(105, 'notice', '2014-12-09 20:30:34', '46.193.140.217', 'SebastienG', 'files', 'g', 'serveFile', '', 'ALLOW', '0234915013'),
(106, 'security', '2014-12-15 18:25:23', '130.66.100.218', 'fthomas', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(107, 'notice', '2014-12-15 18:25:25', '130.66.100.218', 'fthomas', 'files', 'g', 'serveFile', '', 'ALLOW', '3604395065'),
(108, 'security', '2014-12-17 08:29:43', '130.66.100.102', 'fthomas', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(109, 'notice', '2014-12-17 08:29:45', '130.66.100.102', 'fthomas', 'files', 'g', 'serveFile', '', 'ALLOW', '3604395065'),
(110, 'security', '2014-12-20 00:11:44', '86.192.182.208', 'SebastienG', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(111, 'notice', '2014-12-20 00:11:47', '86.192.182.208', 'SebastienG', 'files', 'g', 'serveFile', '', 'ALLOW', '3604395065'),
(112, 'security', '2015-01-18 22:09:02', '46.193.140.217', '', 'auth', 'login', 'authenticate', '', 'DENY', 'Login failed: sgondron'),
(113, 'security', '2015-01-18 22:09:02', '46.193.140.217', '', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged out'),
(114, 'security', '2015-01-18 22:09:07', '46.193.140.217', 'SebastienG', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(115, 'notice', '2015-01-18 22:09:10', '46.193.140.217', 'SebastienG', 'files', 'g', 'serveFile', '', 'ALLOW', '3604395065'),
(116, 'security', '2015-01-20 07:52:31', '80.118.5.210', 'nantoine', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(117, 'security', '2015-01-20 19:53:27', '80.118.5.210', 'mkernec', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(118, 'security', '2015-01-21 13:16:01', '81.220.61.191', 'barbarien', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(119, 'notice', '2015-01-21 13:20:42', '81.220.61.191', 'barbarien', 'files', 'u', 'uploadConfirm', '', 'ALLOW', '3968348946'),
(120, 'security', '2015-01-21 13:48:45', '81.220.61.191', 'barbarien', 'auth', 'logout', 'authenticate', '', 'ALLOW', 'User logged out'),
(121, 'security', '2015-01-21 13:49:40', '81.220.61.191', 'barbarien', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(122, 'security', '2015-01-21 13:50:06', '81.220.61.191', 'barbarien', 'auth', 'logout', 'authenticate', '', 'ALLOW', 'User logged out'),
(123, 'security', '2015-01-24 19:12:25', '89.158.17.231', 'JLeTallec', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(124, 'notice', '2015-01-24 19:12:28', '89.158.17.231', 'JLeTallec', 'files', 'g', 'serveFile', '', 'ALLOW', '4096755755'),
(125, 'security', '2015-01-24 20:12:50', '81.220.61.191', 'barbarien', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(126, 'notice', '2015-01-24 20:12:52', '81.220.61.191', 'barbarien', 'files', 'g', 'serveFile', '', 'ALLOW', '4096755755'),
(127, 'security', '2015-01-25 22:48:26', '80.118.5.210', 'muhammad', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(128, 'notice', '2015-01-25 22:48:43', '80.118.5.210', 'muhammad', 'files', 'g', 'serveFile', '', 'ALLOW', '3968348946'),
(129, 'notice', '2015-01-25 23:06:33', '80.118.5.210', 'muhammad', 'files', 'g', 'serveFile', '', 'ALLOW', '5951441983'),
(130, 'security', '2015-01-29 22:23:16', '80.118.5.210', '', 'auth', 'login', 'authenticate', '', 'DENY', 'Login failed: vladimir'),
(131, 'security', '2015-01-29 22:23:16', '80.118.5.210', '', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged out'),
(132, 'security', '2015-01-29 22:23:38', '80.118.5.210', '', 'auth', 'login', 'authenticate', '', 'DENY', 'Login failed: [email protected]'),
(133, 'security', '2015-01-29 22:23:38', '80.118.5.210', '', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged out'),
(134, 'security', '2015-01-29 22:23:50', '80.118.5.210', '', 'auth', 'login', 'authenticate', '', 'DENY', 'Login failed: glescure'),
(135, 'security', '2015-01-29 22:23:50', '80.118.5.210', '', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged out'),
(136, 'security', '2015-01-31 01:30:50', '81.220.61.191', '', 'auth', 'login', 'authenticate', '', 'DENY', 'Login failed: wdadmin'),
(137, 'security', '2015-01-31 01:30:50', '81.220.61.191', '', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged out'),
(138, 'security', '2015-01-31 01:31:13', '81.220.61.191', '', 'auth', 'login', 'authenticate', '', 'DENY', 'Login failed: admin'),
(139, 'security', '2015-01-31 01:31:13', '81.220.61.191', '', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged out'),
(140, 'security', '2015-01-31 01:31:20', '81.220.61.191', '', 'auth', 'login', 'authenticate', '', 'DENY', 'Login failed: wdadmin'),
(141, 'security', '2015-01-31 01:31:20', '81.220.61.191', '', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged out'),
(142, 'security', '2015-01-31 01:31:49', '81.220.61.191', '', 'auth', 'login', 'authenticate', '', 'DENY', 'Login failed: barbarien'),
(143, 'security', '2015-01-31 01:31:49', '81.220.61.191', '', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged out'),
(144, 'security', '2015-01-31 01:33:02', '81.220.61.191', '', 'auth', 'login', 'authenticate', '', 'DENY', 'Login failed: admin'),
(145, 'security', '2015-01-31 01:33:02', '81.220.61.191', '', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged out'),
(146, 'security', '2015-01-31 01:33:17', '81.220.61.191', 'admin', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(147, 'notice', '2015-01-31 01:36:24', '81.220.61.191', 'admin', 'files', 'u', 'uploadConfirm', '', 'ALLOW', '0271412043'),
(148, 'notice', '2015-01-31 01:37:02', '81.220.61.191', 'admin', 'files', 'r', 'removeResult', '', 'ALLOW', '0271412043'),
(149, 'notice', '2015-01-31 01:46:36', '81.220.61.191', 'admin', 'files', 'u', 'uploadConfirm', '', 'ALLOW', '0953172819'),
(150, 'security', '2015-01-31 01:49:46', '81.220.61.191', 'barbarien', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(151, 'notice', '2015-01-31 02:11:58', '81.220.61.191', 'admin', 'files', 'r', 'removeResult', '', 'ALLOW', '0953172819'),
(152, 'security', '2015-02-08 15:36:35', '81.220.61.191', '', 'auth', 'login', 'authenticate', '', 'DENY', 'Login failed: '' OR 1=1'),
(153, 'security', '2015-02-08 15:36:36', '81.220.61.191', '', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged out'),
(154, 'security', '2015-02-08 15:36:56', '81.220.61.191', '', 'auth', 'login', 'authenticate', '', 'DENY', 'Login failed: \\'' OR 1=1'),
(155, 'security', '2015-02-08 15:36:56', '81.220.61.191', '', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged out'),
(156, 'security', '2015-02-08 15:38:00', '81.220.61.191', '', 'auth', 'login', 'authenticate', '', 'DENY', 'Login failed: '' OR 1=1;#'),
(157, 'security', '2015-02-08 15:38:00', '81.220.61.191', '', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged out'),
(158, 'security', '2015-02-15 18:04:56', '90.62.236.138', 'Gabrielle G', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(159, 'notice', '2015-02-15 18:05:00', '90.62.236.138', 'Gabrielle G', 'files', 'g', 'serveFile', '', 'ALLOW', '3365298245'),
(160, 'security', '2015-03-01 10:59:43', '109.29.99.215', '', 'auth', 'login', 'authenticate', '', 'DENY', 'Login failed: lhassan94'),
(161, 'security', '2015-03-01 10:59:43', '109.29.99.215', '', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged out'),
(162, 'security', '2015-03-01 10:59:51', '109.29.99.215', '', 'auth', 'login', 'authenticate', '', 'DENY', 'Login failed: lhassan94'),
(163, 'security', '2015-03-01 10:59:51', '109.29.99.215', '', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged out'),
(164, 'security', '2015-03-01 11:00:11', '109.29.99.215', '', 'auth', 'login', 'authenticate', '', 'DENY', 'Login failed: lhassan94'),
(165, 'security', '2015-03-01 11:00:11', '109.29.99.215', '', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged out'),
(166, 'security', '2015-03-01 11:00:42', '109.29.99.215', '', 'auth', 'login', 'authenticate', '', 'DENY', 'Login failed: lhassan94'),
(167, 'security', '2015-03-01 11:00:42', '109.29.99.215', '', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged out'),
(168, 'security', '2015-03-11 13:15:35', '130.66.204.116', 'barbarien', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(169, 'security', '2015-03-12 12:54:33', '130.66.204.116', 'barbarien', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(170, 'security', '2015-03-13 09:43:11', '130.66.204.116', 'barbarien', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(171, 'notice', '2015-03-13 09:43:42', '130.66.204.116', 'barbarien', 'files', 'u', 'uploadConfirm', '', 'ALLOW', '1134517623'),
(172, 'security', '2015-03-15 17:58:03', '80.118.5.210', 'dglotin', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(173, 'notice', '2015-03-15 17:58:10', '80.118.5.210', 'dglotin', 'files', 'g', 'serveFile', '', 'ALLOW', '5728350869'),
(174, 'security', '2015-03-16 14:15:50', '130.66.100.81', 'Remy M', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(175, 'notice', '2015-03-16 14:15:53', '130.66.100.81', 'Remy M', 'files', 'g', 'serveFile', '', 'ALLOW', '5728350869'),
(176, 'security', '2015-03-16 16:42:22', '130.66.207.234', '', 'auth', 'login', 'authenticate', '', 'DENY', 'Login failed: tygen02'),
(177, 'security', '2015-03-16 16:42:22', '130.66.207.234', '', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged out'),
(178, 'security', '2015-03-16 16:42:33', '130.66.207.234', 'tygen02', 'auth', 'login', 'authenticate', '', 'ALLOW', 'User logged in'),
(179, 'notice', '2015-03-16 16:42:37', '130.66.207.234', 'tygen02', 'files', 'g', 'serveFile', '', 'ALLOW', '2228655895');
-- --------------------------------------------------------
--
-- Structure de la table `openu_banned`
--
CREATE TABLE IF NOT EXISTS `openu_banned` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ip` varchar(50) NOT NULL,
`access` varchar(50) NOT NULL,
`priority` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
--
-- Contenu de la table `openu_banned`
--
INSERT INTO `openu_banned` (`id`, `ip`, `access`, `priority`) VALUES
(1, '127.0.0.1', 'allow', 1),
(2, '0.0.0.0/0', 'allow', 9999999),
(3, '130.66.0.0/16', 'allow', 99999);
-- --------------------------------------------------------
--
-- Structure de la table `openu_files`
--
CREATE TABLE IF NOT EXISTS `openu_files` (
`id` varchar(100) NOT NULL,
`name` varchar(200) NOT NULL,
`mime` varchar(200) NOT NULL,
`description` text NOT NULL,
`size` int(12) NOT NULL,
`remove` varchar(100) NOT NULL,
`user_login` varchar(100) NOT NULL,
`ip` varchar(40) NOT NULL,
`upload_date` datetime NOT NULL,
`year` int(11) NOT NULL,
`ue` varchar(15) NOT NULL,
`catg` varchar(15) NOT NULL,
`hits` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Contenu de la table `openu_files`
--
INSERT INTO `openu_files` (`id`, `name`, `mime`, `description`, `size`, `remove`, `user_login`, `ip`, `upload_date`, `year`, `ue`, `catg`, `hits`) VALUES
('2228655895', 'rapport_TP4.pdf', 'application/octet-stream', 'Rapport du TP4', 23328, '2800568770', 'admin', '81.220.67.23', '2014-11-07 12:18:10', 1, 'algpr', 'tp', 3),
('5951441983', 'TP5 corection.docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document', 'TP5', 17421, '8492675849', 'admin', '81.220.67.23', '2014-11-07 12:19:33', 1, 'algpr', 'tp', 1),
('3365298245', 'Fourmis TP 6.docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document', 'TP6', 13206, '8035383920', 'admin', '81.220.67.23', '2014-11-07 12:20:20', 1, 'algpr', 'tp', 4),
('0472373847', 'DS_07_04_2014_enonce.pdf', 'application/pdf', '', 126844, '1367396509', 'admin', '81.220.67.23', '2014-11-07 20:26:17', 1, 'maths', 'ds', 0),
('5576482081', 'DS_07_04_2014_solution.pdf', 'application/pdf', '', 188708, '1612463480', 'admin', '81.220.67.23', '2014-11-07 20:28:10', 1, 'maths', 'dsc', 0),
('2831868878', 'DS_12_11_2013_enonce.pdf', 'application/pdf', '', 130332, '1199661297', 'admin', '81.220.67.23', '2014-11-07 20:28:56', 1, 'maths', 'ds', 1),
('4624563174', 'DS_12_11_2013_indication.pdf', 'application/pdf', '', 142917, '9877340501', 'admin', '81.220.67.23', '2014-11-07 20:30:20', 1, 'maths', 'ds', 0),
('3345189259', 'DS_12_11_2013_solution.pdf', 'application/pdf', '', 157794, '0971417353', 'admin', '81.220.67.23', '2014-11-07 20:31:04', 1, 'maths', 'dsc', 0),
('4834167136', 'DS_20_06_2014_enonce.pdf', 'application/pdf', '', 145376, '3170622368', 'admin', '81.220.67.23', '2014-11-07 20:31:41', 1, 'maths', 'ds', 0),
('8431569602', 'DS_20_06_2014_solution.pdf', 'application/pdf', '', 203731, '6315519436', 'admin', '81.220.67.23', '2014-11-07 20:32:22', 1, 'maths', 'dsc', 0),
('8659511211', 'DS_31_01_2014_enonce.pdf', 'application/pdf', '', 194841, '5220489444', 'admin', '81.220.67.23', '2014-11-07 20:33:26', 1, 'maths', 'ds', 0),
('4812525523', 'DS_31_01_2014_indication.pdf', 'application/pdf', '', 203395, '5684526983', 'admin', '81.220.67.23', '2014-11-07 20:36:12', 1, 'maths', 'ds', 1),
('4096755755', 'DS_31_01_2014_solution.pdf', 'application/pdf', '', 228889, '1501797417', 'admin', '81.220.67.23', '2014-11-07 20:36:53', 1, 'maths', 'dsc', 2),
('5728350869', 'Compte rendu TP2.docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document', '', 18969, '3008502436', 'admin', '81.220.67.23', '2014-11-12 00:46:23', 1, 'maths', 'tp', 12),
('0234915013', 'rapport_TP5.pdf', 'application/pdf', '', 979589, '0544708457', 'admin', '81.220.67.23', '2014-11-12 00:49:13', 1, 'maths', 'tp', 5),