-
Notifications
You must be signed in to change notification settings - Fork 0
/
25.3.2019.txt
1343 lines (1209 loc) · 64.6 KB
/
25.3.2019.txt
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.8.5
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Mar 25, 2019 at 10:32 AM
-- Server version: 10.1.38-MariaDB
-- PHP Version: 7.3.3
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `artify`
--
CREATE DATABASE IF NOT EXISTS `artify` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `artify`;
-- --------------------------------------------------------
--
-- Table structure for table `apply`
--
CREATE TABLE `apply` (
`apply_id` int(11) NOT NULL,
`usr_id` int(11) NOT NULL,
`content` text NOT NULL,
`imgPath` text NOT NULL,
`approval` int(3) NOT NULL DEFAULT '0',
`requestedDateTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `apply`
--
INSERT INTO `apply` (`apply_id`, `usr_id`, `content`, `imgPath`, `approval`, `requestedDateTime`) VALUES
(1, 2, 'This is a Test', '../image/Apply/RyanSu/1.jpg', 1, '2019-03-10 17:17:56'),
(2, 1, 'This is another Test', '../image/Apply/jyling16/1.png', 1, '2019-03-10 17:17:56'),
(5, 5, 'I Just want to be a artist Please', '../image/Apply/Peter/1.jpg', 1, '2019-03-11 18:11:46'),
(6, 4, 'LoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsu', '../image/Apply/NewUser/1.png', 1, '2019-03-12 09:31:51'),
(7, 4, 'This is a test', '../image/Apply/NewUser/2.jpg', 1, '2019-03-16 12:22:37'),
(8, 4, 'efewfsffesfs', '../image/Apply/NewUser/3.jpg', 1, '2019-03-16 12:38:27'),
(9, 4, 'seffs', '../image/Apply/NewUser/4.jpg', 1, '2019-03-16 12:42:59'),
(10, 4, 'efesfwefew', '../image/Apply/NewUser/5.jpg', 1, '2019-03-16 12:53:30'),
(11, 1, 'Testing, i want to be a artist', '../image/Apply/jyling16/4.png', 1, '2019-03-19 14:26:00'),
(12, 1, 'rgergrgergegee', '../image/Apply/jyling16/5.png', 1, '2019-03-19 14:32:38');
-- --------------------------------------------------------
--
-- Table structure for table `art_category`
--
CREATE TABLE `art_category` (
`category_id` int(11) NOT NULL,
`name` varchar(64) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `art_category`
--
INSERT INTO `art_category` (`category_id`, `name`) VALUES
(1, 'Digital Art'),
(2, '3D Art'),
(3, 'Animation'),
(4, 'Drawings & Paintings'),
(5, 'Pixel Art'),
(6, 'Text Art'),
(7, 'Vector'),
(8, 'Traditional Art'),
(9, 'Photography'),
(10, 'Designs & Interfaces\r\n'),
(11, 'Cartoons & Comics'),
(12, 'Manga & Anime'),
(13, 'Fan Art'),
(14, 'Line Art');
-- --------------------------------------------------------
--
-- Table structure for table `art_purchase`
--
CREATE TABLE `art_purchase` (
`purchase_id` int(11) NOT NULL,
`usr_id` int(11) DEFAULT NULL,
`post_id` int(11) DEFAULT NULL,
`artPath` varchar(255) NOT NULL,
`compressedImg` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `art_purchase`
--
INSERT INTO `art_purchase` (`purchase_id`, `usr_id`, `post_id`, `artPath`, `compressedImg`) VALUES
(5, 4, 10, '../image/Post/Peter/13.jpg', '../image/Post/Peter/compressed/1553142045.png'),
(6, 4, NULL, '../image/Post/Jack Desu/1.jpg', '../image/Post/Jack Desu/compressed/1553142698.png'),
(7, 1, 8, '../image/Post/Peter/10.png', '../image/Post/Peter/compressed/1552718228.png'),
(8, 3, 2, '../image/Post/Peter/4.jpg', '../image/Post/Peter/compressed/2.png'),
(9, 3, 7, '../image/Post/Peter/9.png', '../image/Post/Peter/compressed/1552716192.png');
-- --------------------------------------------------------
--
-- Table structure for table `ban`
--
CREATE TABLE `ban` (
`ban_id` int(11) NOT NULL,
`ban_date` datetime NOT NULL,
`ban_till` datetime NOT NULL,
`ban_reason` text NOT NULL,
`usr_id` int(11) NOT NULL,
`valid` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `ban`
--
INSERT INTO `ban` (`ban_id`, `ban_date`, `ban_till`, `ban_reason`, `usr_id`, `valid`) VALUES
(1, '2019-03-11 16:30:10', '2019-03-12 01:00:00', 'Reason for Ban:\r\nYou broke the Rules\r\n\r\nReport Type : Harassment\r\nDescription :\r\nThis is a Test for a REALLY LOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOONG STRING ', 4, 0),
(2, '2019-03-12 08:07:41', '2019-03-12 08:07:41', 'Reason for Ban:\r\nYou broke the Rules\r\n\r\nReport Type : Harassment\r\nDescription :\r\nThis is a Test ', 4, 0),
(3, '2019-03-12 15:42:08', '2019-03-12 15:42:08', 'Reason for Ban:\r\nYou broke the Rules\r\n\r\nReport Type : Harassment\r\nDescription :\r\nThis is a Test ', 4, 0),
(4, '2019-03-12 16:04:10', '2019-03-12 16:04:10', 'Reason for Ban:\r\nYou broke the Rules\r\n\r\nReport Type : Harassment\r\nDescription :\r\nThis is a Test ', 4, 0),
(5, '2019-03-12 16:05:54', '2019-03-12 16:05:54', 'Reason for Ban:\r\nYou broke the Rules\r\n\r\nReport Type : Harassment\r\nDescription :\r\nThis is a Test ', 4, 0),
(6, '2019-03-12 16:07:40', '2019-03-13 16:07:40', 'Reason for Ban:\r\nYou broke the Rules\r\n\r\nReport Type : Harassment\r\nDescription :\r\nThis is a Test ', 4, 0),
(7, '2019-03-12 16:09:09', '2019-03-12 16:09:09', 'Reason for Ban:\r\nYou broke the Rules\r\n\r\nReport Type : Harassment\r\nDescription :\r\nThis is a Test ', 4, 0),
(8, '2019-03-14 16:07:44', '2019-03-15 16:07:44', 'Reason for Ban:\r\nYou broke the Rules\r\n\r\nReport Type : Harassment\r\nDescription :\r\nTesting ', 4, 0),
(9, '2019-03-14 16:08:07', '2019-03-14 16:17:07', 'Reason for Ban:\r\nYou broke the Rules\r\n\r\nReport Type : Harassment\r\nDescription :\r\nTesting ', 4, 0),
(10, '2019-03-14 16:26:46', '2019-03-15 16:26:46', 'Reason for Ban:\r\nYou broke the Rules\r\n\r\nReport Type : Harassment\r\nDescription :\r\nTesting ', 4, 0),
(11, '2019-03-16 12:32:53', '2019-03-16 12:32:53', 'Reason for Ban:\r\nYou broke the Rules\r\n\r\nReport Type : Harassment\r\nDescription :\r\nadeadefeafe ', 4, 0),
(12, '2019-03-16 12:40:29', '2019-03-16 12:40:29', 'Reason for Ban:\r\nYou broke the Rules\r\n\r\nReport Type : Harassment\r\nDescription :\r\nadeadefeafe ', 4, 0),
(13, '2019-03-16 12:44:06', '2019-03-16 12:44:06', 'Reason for Ban:\r\nYou broke the Rules\r\n\r\nReport Type : Harassment\r\nDescription :\r\nadeadefeafe ', 4, 0),
(14, '2019-03-19 14:28:29', '2019-03-19 14:28:29', 'Reason for Ban:\r\nYou broke the Rules\r\n\r\nReport Type : Harassment\r\nDescription :\r\nThis is a Test for reporting user ', 1, 0);
-- --------------------------------------------------------
--
-- Table structure for table `comment`
--
CREATE TABLE `comment` (
`comment_id` int(11) NOT NULL,
`usr_id` int(11) NOT NULL,
`post_id` int(11) NOT NULL,
`content` text NOT NULL,
`commented_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `comment`
--
INSERT INTO `comment` (`comment_id`, `usr_id`, `post_id`, `content`, `commented_time`) VALUES
(1, 5, 2, 'Donec fringilla. Donec feugiat metus sit amet ante. Vivamus', '2013-08-26 10:32:15'),
(2, 3, 7, 'augue, eu', '2013-08-27 09:58:42'),
(3, 1, 5, 'Donec sollicitudin adipiscing ligula. Aenean', '2017-06-19 20:00:50'),
(4, 1, 8, 'libero. Integer in magna.', '2018-02-19 00:06:55'),
(5, 4, 7, 'volutpat. Nulla dignissim. Maecenas', '2013-04-13 03:03:24'),
(6, 3, 4, 'ultrices iaculis odio.', '2016-01-03 04:23:18'),
(7, 2, 2, 'leo elementum', '2017-01-15 10:10:56'),
(8, 1, 8, 'sagittis augue,', '2018-06-09 11:59:16'),
(9, 3, 7, 'Suspendisse non leo. Vivamus nibh dolor, nonummy', '2018-12-31 07:42:10'),
(10, 1, 10, 'Mauris molestie pharetra nibh.', '2013-04-10 16:50:29'),
(12, 3, 10, 'lorem ut', '2013-03-06 22:48:08'),
(13, 4, 1, 'penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec', '2017-09-01 17:41:30'),
(14, 3, 11, 'sit', '2015-05-03 07:30:51'),
(15, 5, 11, 'laoreet lectus quis massa. Mauris vestibulum, neque sed dictum', '2018-06-19 23:18:17'),
(17, 5, 7, 'orci lacus vestibulum lorem,', '2013-05-08 19:11:33'),
(18, 5, 11, 'arcu. Nunc mauris. Morbi non sapien molestie orci', '2015-07-24 23:50:08'),
(19, 5, 10, 'adipiscing non, luctus sit amet, faucibus ut, nulla. Cras', '2018-06-18 22:19:44'),
(21, 3, 10, 'Praesent interdum ligula eu enim. Etiam', '2015-08-17 04:08:50'),
(22, 2, 11, 'in lobortis tellus justo sit amet nulla. Donec', '2016-03-08 14:54:20'),
(23, 3, 4, 'mi eleifend egestas. Sed pharetra, felis eget', '2015-04-06 06:59:07'),
(24, 4, 3, 'euismod mauris eu elit. Nulla facilisi. Sed neque. Sed', '2018-08-07 14:46:51'),
(25, 5, 3, 'eget massa. Suspendisse', '2017-03-05 11:26:35'),
(26, 3, 7, 'Donec tempus, lorem', '2014-07-22 20:35:58'),
(27, 1, 2, 'vitae odio sagittis semper. Nam tempor diam', '2016-05-08 20:21:44'),
(28, 1, 9, 'facilisis lorem tristique aliquet. Phasellus fermentum convallis', '2017-12-30 20:46:04'),
(29, 4, 8, 'conubia nostra, per inceptos', '2017-07-20 10:21:43'),
(30, 4, 11, 'lobortis ultrices. Vivamus rhoncus. Donec est. Nunc ullamcorper, velit', '2019-01-27 16:05:07'),
(31, 3, 11, 'fermentum convallis ligula. Donec luctus aliquet odio.', '2016-03-09 06:51:20'),
(32, 2, 9, 'eros nec tellus. Nunc', '2016-06-20 06:34:05'),
(33, 5, 11, 'risus.', '2017-04-22 03:11:26'),
(34, 3, 10, 'fringilla cursus purus. Nullam scelerisque neque sed sem egestas blandit.', '2014-06-26 19:42:15'),
(35, 2, 4, 'nunc sit amet metus. Aliquam erat volutpat. Nulla facilisis. Suspendisse', '2013-12-30 01:25:47'),
(36, 2, 4, 'Vestibulum accumsan neque et', '2018-09-06 22:23:24'),
(37, 5, 10, 'Nulla facilisi. Sed neque. Sed eget', '2013-09-29 23:25:33'),
(38, 4, 7, 'Etiam bibendum fermentum', '2017-09-18 23:15:31'),
(39, 5, 2, 'Maecenas malesuada fringilla est. Mauris eu turpis. Nulla aliquet.', '2016-06-29 01:53:43'),
(40, 3, 7, 'dignissim. Maecenas ornare egestas ligula.', '2014-07-17 05:09:02'),
(41, 4, 7, 'Cras lorem lorem, luctus ut, pellentesque eget,', '2016-01-24 15:59:55'),
(42, 5, 3, 'arcu. Vestibulum ante ipsum primis in', '2017-02-13 20:30:54'),
(43, 1, 1, 'Quisque fringilla euismod enim. Etiam gravida molestie arcu.', '2015-05-21 04:48:23'),
(45, 1, 5, 'ipsum', '2017-09-22 03:36:55'),
(46, 2, 5, 'imperdiet dictum', '2017-10-14 19:55:21'),
(47, 3, 9, 'tempus scelerisque, lorem ipsum sodales', '2013-05-18 12:22:40'),
(48, 3, 2, 'Aliquam nisl. Nulla eu neque pellentesque massa lobortis ultrices. Vivamus', '2014-10-09 00:56:46'),
(49, 5, 9, 'Phasellus elit', '2015-05-09 02:21:44'),
(50, 4, 5, 'eget varius ultrices, mauris ipsum porta elit, a feugiat tellus', '2019-02-06 12:10:27'),
(51, 5, 9, 'sit amet, dapibus id, blandit', '2014-01-07 21:40:11'),
(52, 2, 4, 'ac metus vitae velit egestas lacinia. Sed', '2014-11-20 01:27:35'),
(53, 1, 8, 'erat, in consectetuer ipsum nunc id enim. Curabitur', '2013-04-01 01:29:33'),
(54, 2, 2, 'ut ipsum ac mi eleifend egestas. Sed pharetra, felis', '2019-01-27 15:03:41'),
(55, 2, 9, 'aliquam', '2014-10-05 09:45:03'),
(56, 1, 5, 'scelerisque scelerisque dui. Suspendisse ac metus vitae velit', '2018-09-21 22:58:29'),
(57, 2, 6, 'Integer mollis. Integer tincidunt', '2015-08-10 13:47:19'),
(59, 3, 8, 'Aliquam erat volutpat. Nulla facilisis. Suspendisse commodo', '2018-04-12 22:58:52'),
(60, 4, 6, 'faucibus. Morbi', '2016-11-26 20:57:50'),
(61, 5, 4, 'Proin ultrices. Duis volutpat', '2014-07-12 12:04:05'),
(62, 1, 11, 'nibh dolor, nonummy ac,', '2013-04-02 23:19:50'),
(63, 5, 6, 'vitae risus.', '2017-10-03 17:20:51'),
(64, 4, 3, 'a sollicitudin orci sem eget', '2014-05-29 18:07:29'),
(65, 3, 8, 'a, auctor non, feugiat nec,', '2014-09-19 17:58:06'),
(66, 1, 2, 'at pede. Cras', '2013-04-30 22:05:14'),
(67, 2, 4, 'nulla.', '2018-01-11 20:19:46'),
(68, 5, 4, 'ac mi eleifend egestas. Sed pharetra, felis eget varius', '2016-10-13 19:28:40'),
(70, 4, 11, 'ac nulla. In tincidunt congue turpis. In', '2017-06-06 01:34:45'),
(71, 3, 10, 'nec,', '2018-08-26 09:49:52'),
(72, 4, 9, 'Cum sociis natoque penatibus et magnis', '2019-01-02 01:59:18'),
(73, 3, 6, 'eget', '2016-07-02 04:09:14'),
(74, 3, 11, 'nunc sed libero.', '2015-10-22 17:41:33'),
(76, 5, 2, 'Cras dolor dolor, tempus non,', '2013-07-04 13:26:07'),
(77, 3, 5, 'non, sollicitudin a,', '2014-10-30 01:28:57'),
(78, 3, 7, 'consectetuer adipiscing elit. Aliquam auctor, velit eget laoreet posuere,', '2014-04-12 23:58:28'),
(79, 1, 8, 'sit', '2018-12-20 22:57:22'),
(80, 1, 4, 'sit', '2014-07-10 06:13:06'),
(81, 2, 4, 'neque et', '2013-10-25 01:07:43'),
(82, 2, 1, 'risus varius orci, in consequat enim diam vel arcu.', '2013-04-08 04:42:33'),
(84, 2, 10, 'convallis in, cursus et, eros. Proin ultrices. Duis volutpat', '2015-05-31 09:59:15'),
(86, 2, 7, 'Morbi', '2015-09-24 18:55:04'),
(87, 2, 10, 'et pede. Nunc sed orci lobortis augue scelerisque mollis. Phasellus', '2017-03-01 14:08:31'),
(88, 1, 6, 'nibh vulputate mauris sagittis placerat. Cras dictum', '2017-10-08 08:06:06'),
(89, 5, 6, 'sem elit, pharetra ut, pharetra sed, hendrerit a, arcu. Sed', '2018-07-26 16:03:22'),
(90, 5, 10, 'ac', '2014-11-19 07:18:36'),
(91, 3, 4, 'dignissim. Maecenas', '2018-01-05 16:08:52'),
(92, 2, 8, 'sit amet, dapibus id, blandit at,', '2017-03-11 02:02:59'),
(93, 5, 10, 'malesuada malesuada. Integer id magna et', '2014-10-02 23:54:40'),
(94, 1, 7, 'libero. Integer in magna. Phasellus', '2016-10-25 15:32:31'),
(96, 1, 5, 'justo eu arcu. Morbi', '2016-10-03 08:25:55'),
(98, 1, 2, 'Nunc mauris', '2013-08-22 13:18:15'),
(99, 5, 5, 'fermentum risus, at fringilla', '2014-08-19 08:48:52'),
(100, 5, 11, 'porttitor scelerisque neque. Nullam nisl. Maecenas malesuada fringilla est. Mauris', '2016-06-14 07:14:04'),
(101, 3, 11, 'ac sem ut dolor dapibus gravida. Aliquam', '2017-04-12 20:17:48'),
(103, 4, 10, 'dictum sapien. Aenean massa. Integer vitae nibh.', '2013-07-03 00:10:11'),
(107, 5, 8, 'vitae, aliquet nec, imperdiet nec, leo.', '2015-05-03 09:40:26'),
(108, 1, 4, 'Nunc', '2016-04-05 10:05:01'),
(109, 2, 4, 'mollis nec, cursus a, enim. Suspendisse aliquet, sem ut', '2016-12-23 06:37:20'),
(110, 4, 7, 'sem elit, pharetra ut, pharetra sed,', '2015-06-28 03:51:46'),
(111, 2, 8, 'id, erat. Etiam vestibulum massa rutrum', '2018-09-01 19:18:47'),
(112, 3, 11, 'Mauris magna. Duis dignissim tempor', '2017-11-11 00:19:15'),
(113, 4, 7, 'felis orci,', '2018-01-13 04:23:49'),
(115, 1, 3, 'tristique aliquet. Phasellus fermentum convallis ligula. Donec luctus', '2013-10-08 05:43:40'),
(116, 3, 10, 'arcu. Aliquam ultrices', '2015-12-29 23:24:25'),
(118, 4, 5, 'at pretium aliquet,', '2018-05-12 18:14:54'),
(119, 4, 2, 'pede,', '2019-03-03 20:40:19'),
(120, 5, 10, 'ut, pharetra sed, hendrerit a, arcu. Sed et libero.', '2013-06-16 07:46:30'),
(121, 5, 6, 'volutpat nunc', '2017-03-06 23:42:57'),
(123, 2, 10, 'vel turpis. Aliquam', '2016-10-03 05:50:47'),
(124, 5, 3, 'Cras lorem lorem, luctus ut, pellentesque eget, dictum', '2018-04-30 18:41:28'),
(125, 5, 8, 'dui, semper et, lacinia vitae, sodales', '2017-07-22 12:26:54'),
(126, 4, 4, 'dui', '2018-01-24 19:58:03'),
(127, 2, 1, 'eget mollis lectus pede et', '2015-03-08 20:32:47'),
(130, 2, 11, 'in sodales elit erat vitae risus. Duis a', '2017-12-22 18:17:38'),
(131, 2, 7, 'vitae aliquam eros turpis non enim. Mauris quis turpis', '2018-11-24 01:27:20'),
(132, 4, 11, 'lectus, a sollicitudin orci sem eget massa. Suspendisse eleifend.', '2016-01-25 09:30:41'),
(134, 3, 5, 'ac orci. Ut semper pretium neque. Morbi quis urna.', '2013-05-09 02:03:42'),
(135, 5, 8, 'Fusce feugiat. Lorem ipsum dolor sit amet, consectetuer adipiscing', '2017-08-15 23:40:46'),
(136, 4, 11, 'accumsan laoreet ipsum. Curabitur consequat,', '2018-01-24 07:02:36'),
(137, 2, 3, 'eu nibh vulputate mauris sagittis', '2016-12-20 07:50:58'),
(138, 2, 10, 'ante bibendum ullamcorper. Duis cursus, diam at', '2015-05-27 20:05:51'),
(139, 3, 6, 'vestibulum massa', '2018-12-19 21:13:32'),
(140, 1, 7, 'Duis a mi fringilla mi', '2015-05-10 07:46:15'),
(141, 5, 4, 'ridiculus mus. Proin', '2018-05-19 08:37:19'),
(143, 2, 8, 'placerat,', '2015-04-16 06:47:12'),
(144, 1, 10, 'pede, nonummy ut, molestie', '2018-07-22 11:33:35'),
(145, 2, 10, 'cursus.', '2014-09-29 03:43:38'),
(146, 5, 2, 'orci sem eget', '2014-05-24 02:04:21'),
(147, 3, 11, 'dictum. Phasellus in felis. Nulla tempor', '2016-04-18 08:33:41'),
(150, 5, 7, 'justo sit amet nulla. Donec non justo. Proin non massa', '2015-09-04 11:41:19'),
(151, 2, 3, 'dolor', '2013-05-17 00:38:00'),
(153, 4, 9, 'rutrum lorem ac risus. Morbi metus. Vivamus euismod', '2015-01-11 01:36:38'),
(154, 3, 5, 'leo. Morbi', '2018-02-20 09:28:58'),
(155, 2, 4, 'est mauris, rhoncus', '2017-05-01 07:30:54'),
(156, 4, 3, 'fringilla cursus purus. Nullam scelerisque neque sed sem', '2018-01-14 07:22:33'),
(157, 4, 4, 'montes, nascetur ridiculus', '2013-07-30 05:12:07'),
(158, 2, 4, 'inceptos hymenaeos. Mauris ut quam vel', '2016-04-02 05:18:03'),
(159, 4, 11, 'tellus eu augue porttitor interdum.', '2014-10-04 13:17:31'),
(160, 2, 5, 'facilisis lorem tristique aliquet.', '2018-08-12 03:36:32'),
(161, 5, 10, 'semper', '2016-11-07 11:09:20'),
(162, 3, 6, 'sem mollis dui, in', '2015-04-23 20:26:19'),
(165, 1, 8, 'mi pede, nonummy ut, molestie in, tempus eu, ligula. Aenean', '2016-11-15 18:38:59'),
(166, 3, 11, 'nibh vulputate', '2013-11-27 07:28:13'),
(167, 3, 3, 'mi lorem, vehicula et, rutrum eu, ultrices sit amet,', '2017-10-01 09:34:22'),
(168, 2, 9, 'sit', '2018-11-28 10:21:33'),
(169, 5, 4, 'facilisis. Suspendisse commodo tincidunt nibh. Phasellus', '2013-04-26 00:14:15'),
(170, 3, 10, 'nibh lacinia orci,', '2013-11-18 20:29:45'),
(171, 3, 3, 'Proin mi. Aliquam gravida mauris ut mi. Duis risus odio,', '2016-09-14 01:13:40'),
(172, 2, 6, 'nunc, ullamcorper eu, euismod ac, fermentum vel, mauris. Integer', '2017-05-20 07:59:05'),
(173, 2, 1, 'Cum sociis natoque', '2013-04-26 18:50:19'),
(174, 4, 7, 'ultrices sit', '2018-03-24 19:54:02'),
(175, 4, 9, 'Duis elementum, dui', '2018-01-22 15:50:00'),
(176, 3, 8, 'scelerisque mollis. Phasellus', '2015-09-15 01:19:29'),
(177, 2, 1, 'neque. Morbi quis urna. Nunc quis', '2018-04-09 11:08:12'),
(178, 4, 8, 'a tortor. Nunc commodo auctor velit. Aliquam', '2017-09-08 17:50:12'),
(179, 1, 2, 'lorem ut aliquam iaculis, lacus pede sagittis augue, eu tempor', '2014-03-07 12:18:28'),
(181, 5, 4, 'feugiat', '2017-12-20 07:49:43'),
(182, 1, 2, 'Morbi metus. Vivamus euismod urna. Nullam lobortis quam a felis', '2014-05-29 05:31:39'),
(183, 4, 4, 'convallis est, vitae sodales', '2014-09-07 09:43:30'),
(184, 2, 5, 'ornare tortor at risus. Nunc ac sem ut dolor dapibus', '2018-10-16 11:23:12'),
(185, 1, 1, 'Integer aliquam adipiscing lacus. Ut', '2018-02-17 22:10:58'),
(186, 4, 1, 'eleifend. Cras sed leo. Cras vehicula aliquet libero. Integer in', '2019-03-23 12:50:42'),
(187, 5, 4, 'habitant morbi tristique senectus', '2013-09-20 03:01:24'),
(188, 1, 7, 'purus. Nullam scelerisque neque', '2018-02-02 16:53:20'),
(190, 4, 11, 'elit, pellentesque a, facilisis non, bibendum', '2015-10-28 09:17:48'),
(191, 3, 8, 'augue ut lacus. Nulla tincidunt,', '2016-02-13 03:02:23'),
(194, 3, 10, 'eleifend non, dapibus', '2013-08-07 18:54:28'),
(195, 5, 11, 'augue. Sed molestie. Sed id risus quis', '2014-07-31 14:32:45'),
(196, 3, 9, 'id, libero. Donec consectetuer mauris id', '2018-02-14 09:26:42'),
(197, 1, 11, 'tellus', '2019-01-20 20:54:32'),
(198, 2, 3, 'erat, eget tincidunt dui', '2013-08-28 07:33:14'),
(199, 3, 8, 'odio. Nam interdum', '2015-10-16 23:18:58'),
(200, 1, 11, 'enim, condimentum eget,', '2018-10-22 04:33:05'),
(201, 2, 2, 'risus. Donec egestas. Duis ac arcu. Nunc mauris. Morbi', '2019-03-18 22:23:27'),
(202, 2, 3, 'nisi.', '2015-08-25 13:07:10'),
(203, 3, 5, 'pretium neque. Morbi quis urna.', '2015-11-23 21:06:04'),
(206, 1, 4, 'lacus. Quisque purus sapien, gravida non, sollicitudin', '2014-02-13 20:29:37'),
(207, 3, 10, 'augue ac ipsum.', '2015-12-30 11:47:25'),
(208, 5, 8, 'quis urna. Nunc quis arcu vel quam dignissim pharetra.', '2017-06-21 17:21:29'),
(210, 5, 2, 'tellus justo sit amet nulla. Donec non', '2019-01-30 13:48:51'),
(211, 5, 5, 'lacus. Quisque', '2019-02-08 11:33:08'),
(213, 3, 3, 'Maecenas mi felis, adipiscing fringilla, porttitor vulputate, posuere', '2016-02-12 01:44:34'),
(214, 5, 4, 'elit. Curabitur sed tortor. Integer aliquam adipiscing', '2017-04-04 14:15:48'),
(216, 5, 7, 'sem, vitae aliquam eros turpis non', '2014-07-02 11:33:31'),
(217, 4, 10, 'turpis non enim. Mauris', '2015-08-11 04:47:05'),
(218, 3, 9, 'sed dolor. Fusce mi lorem, vehicula et,', '2017-03-31 01:22:48'),
(219, 2, 11, 'erat volutpat. Nulla', '2017-04-08 11:11:45'),
(220, 5, 4, 'montes, nascetur ridiculus mus.', '2018-07-06 13:59:22'),
(221, 4, 3, 'cursus, diam at', '2015-07-28 09:17:07'),
(222, 4, 10, 'sagittis lobortis mauris. Suspendisse aliquet', '2015-05-30 10:27:54'),
(223, 1, 8, 'tincidunt, nunc ac mattis ornare, lectus ante dictum', '2015-05-14 13:39:52'),
(224, 5, 1, 'bibendum', '2014-07-09 04:30:33'),
(225, 2, 9, 'gravida', '2017-04-17 23:05:46'),
(226, 2, 6, 'metus. Aenean sed pede nec ante blandit viverra.', '2015-01-03 01:32:41'),
(227, 3, 2, 'cursus', '2014-01-28 09:49:05'),
(228, 3, 4, 'montes, nascetur ridiculus mus. Proin vel arcu eu odio', '2017-08-07 04:13:24'),
(230, 3, 4, 'blandit mattis.', '2013-06-21 03:31:51'),
(231, 1, 6, 'lobortis tellus justo sit amet nulla. Donec non justo.', '2018-09-04 22:12:40'),
(232, 2, 11, 'eleifend nec, malesuada ut, sem. Nulla interdum.', '2015-06-06 14:18:24'),
(233, 1, 4, 'elit, a feugiat tellus lorem eu metus. In lorem.', '2016-07-12 07:19:09'),
(234, 4, 5, 'nisi sem semper erat, in consectetuer ipsum nunc', '2013-06-24 08:02:48'),
(235, 3, 3, 'auctor, nunc nulla vulputate dui, nec tempus mauris erat', '2017-05-05 19:59:53'),
(237, 3, 4, 'elit. Etiam', '2014-02-01 11:37:45'),
(238, 5, 3, 'ligula consectetuer rhoncus. Nullam velit dui, semper', '2017-09-04 14:13:54'),
(240, 5, 6, 'non, feugiat nec, diam. Duis', '2018-08-26 17:38:55'),
(241, 1, 7, 'Duis elementum, dui', '2017-02-20 11:15:42'),
(242, 3, 6, 'quis', '2013-12-09 08:25:39'),
(243, 2, 4, 'placerat. Cras dictum ultricies ligula. Nullam enim.', '2013-06-21 15:11:37'),
(244, 2, 4, 'dictum magna. Ut tincidunt', '2014-05-02 15:32:00'),
(245, 5, 10, 'enim. Suspendisse aliquet,', '2017-02-19 21:03:52'),
(246, 2, 9, 'semper pretium neque. Morbi', '2013-04-15 22:03:55'),
(247, 4, 5, 'Sed neque. Sed eget', '2018-05-12 01:29:49'),
(248, 3, 7, 'odio sagittis semper. Nam tempor diam dictum sapien.', '2017-11-25 18:41:44'),
(249, 4, 10, 'accumsan neque', '2013-10-19 16:36:31'),
(250, 5, 7, 'rhoncus. Nullam velit dui, semper et, lacinia vitae,', '2015-12-23 05:16:21'),
(251, 4, 4, 'risus. Donec egestas. Aliquam nec enim. Nunc ut erat. Sed', '2015-05-10 03:45:05'),
(252, 5, 1, 'neque pellentesque massa lobortis ultrices. Vivamus rhoncus.', '2017-05-08 16:16:48'),
(253, 5, 6, 'neque. Nullam ut', '2016-02-21 17:32:50'),
(256, 4, 10, 'adipiscing elit. Etiam laoreet,', '2013-05-29 01:55:09'),
(257, 2, 8, 'ligula consectetuer rhoncus.', '2013-10-02 20:38:20'),
(258, 1, 7, 'Pellentesque tincidunt tempus risus. Donec egestas. Duis', '2014-03-18 16:03:38'),
(259, 3, 10, 'lobortis mauris. Suspendisse aliquet molestie tellus.', '2017-12-17 09:13:20'),
(260, 4, 5, 'risus. Quisque libero lacus, varius et, euismod et, commodo at,', '2014-12-23 07:17:13'),
(261, 2, 8, 'rutrum eu, ultrices sit amet, risus. Donec nibh', '2013-10-31 09:01:38'),
(262, 2, 7, 'et libero.', '2015-07-19 10:02:36'),
(263, 5, 7, 'Nunc pulvinar arcu et pede. Nunc sed orci lobortis', '2017-12-26 00:42:06'),
(264, 2, 5, 'est', '2016-10-25 07:25:46'),
(265, 3, 6, 'turpis nec mauris', '2017-01-05 21:25:23'),
(266, 1, 10, 'quam quis', '2017-01-08 06:54:23'),
(267, 2, 9, 'dui, in sodales elit erat vitae risus. Duis a mi', '2016-05-15 06:34:52'),
(269, 1, 6, 'adipiscing lacus.', '2016-09-28 02:48:17'),
(270, 5, 5, 'Suspendisse', '2016-04-05 19:06:02'),
(271, 1, 6, 'tristique ac,', '2013-08-18 17:11:28'),
(273, 5, 1, 'sodales at, velit. Pellentesque', '2013-08-14 08:56:11'),
(274, 5, 5, 'purus gravida sagittis. Duis gravida. Praesent eu nulla at', '2018-11-04 13:51:44'),
(275, 3, 5, 'Proin', '2018-12-08 22:54:16'),
(276, 1, 7, 'a, enim. Suspendisse aliquet, sem ut cursus luctus, ipsum', '2015-11-14 03:48:17'),
(277, 1, 8, 'Praesent interdum ligula', '2013-07-20 02:44:35'),
(278, 5, 8, 'posuere vulputate, lacus. Cras interdum. Nunc', '2019-03-07 02:04:04'),
(279, 2, 2, 'felis orci, adipiscing non, luctus sit', '2015-02-05 17:48:50'),
(281, 2, 11, 'eget metus eu erat semper rutrum. Fusce dolor quam,', '2014-09-24 06:57:21'),
(282, 1, 10, 'risus. Morbi metus.', '2017-10-17 01:06:25'),
(283, 1, 2, 'est. Nunc laoreet', '2013-08-19 01:04:11'),
(284, 2, 1, 'magna. Duis dignissim tempor arcu. Vestibulum ut eros non enim', '2018-05-29 05:15:21'),
(285, 2, 1, 'eget magna. Suspendisse tristique neque venenatis lacus. Etiam', '2018-12-17 13:47:18'),
(286, 4, 8, 'lectus. Nullam suscipit, est ac facilisis facilisis, magna', '2018-05-21 20:56:41'),
(288, 3, 10, 'in lobortis tellus justo sit amet nulla. Donec', '2018-08-11 12:45:32'),
(289, 2, 4, 'semper erat, in consectetuer', '2017-03-04 14:27:43'),
(290, 2, 1, 'vel, convallis in, cursus et, eros.', '2016-05-09 14:19:24'),
(292, 5, 6, 'Nunc lectus pede,', '2015-01-02 10:57:49'),
(293, 1, 1, 'et magnis', '2019-01-16 02:02:29'),
(294, 3, 6, 'ornare. Fusce mollis. Duis sit amet diam eu dolor egestas', '2013-12-01 19:33:48'),
(295, 3, 9, 'cursus et, magna. Praesent interdum', '2014-04-29 00:16:05'),
(296, 3, 6, 'vitae velit egestas lacinia. Sed congue, elit sed', '2018-05-02 10:16:46'),
(297, 4, 1, 'vulputate ullamcorper magna. Sed eu eros. Nam consequat dolor vitae', '2015-11-09 12:21:09'),
(298, 2, 9, 'quis, pede. Suspendisse dui. Fusce diam', '2018-09-09 02:18:40'),
(299, 3, 10, 'lacinia orci, consectetuer euismod est arcu ac orci. Ut', '2015-04-08 06:54:29'),
(300, 1, 3, 'tristique', '2014-05-12 13:18:47'),
(302, 1, 8, 'urna.', '2016-04-26 22:14:03'),
(303, 4, 9, 'varius ultrices, mauris ipsum', '2017-01-17 20:02:27'),
(304, 2, 9, 'eros non enim commodo hendrerit.', '2015-01-08 00:54:14'),
(305, 2, 7, 'non, cursus non,', '2015-08-07 11:32:59'),
(306, 4, 6, 'ipsum porta elit, a feugiat', '2017-01-18 07:53:07'),
(308, 1, 3, 'et, euismod et,', '2018-01-09 08:42:56'),
(309, 4, 5, 'pharetra ut, pharetra sed, hendrerit a, arcu. Sed et', '2013-06-11 07:54:01'),
(310, 3, 1, 'enim. Curabitur massa. Vestibulum accumsan', '2018-12-03 17:28:24'),
(311, 2, 1, 'ac mattis', '2015-08-06 15:52:41'),
(312, 5, 5, 'Fusce feugiat. Lorem ipsum dolor', '2013-08-02 01:57:21'),
(313, 1, 9, 'lacinia orci, consectetuer euismod est arcu ac orci. Ut', '2018-04-20 16:37:32'),
(314, 1, 2, 'pede, nonummy ut, molestie', '2017-07-15 17:04:19'),
(315, 2, 1, 'varius orci, in consequat enim', '2018-09-02 04:36:19'),
(316, 4, 5, 'eleifend non, dapibus rutrum, justo. Praesent luctus.', '2018-10-31 01:08:49'),
(317, 1, 7, 'vitae diam. Proin dolor. Nulla semper tellus id nunc', '2014-12-27 11:41:53'),
(318, 3, 10, 'neque. Morbi quis urna. Nunc quis arcu vel quam dignissim', '2018-06-22 18:23:03'),
(319, 4, 9, 'ultrices posuere cubilia', '2017-12-18 10:02:48'),
(320, 5, 5, 'adipiscing', '2018-02-07 03:38:17'),
(321, 2, 1, 'dignissim lacus. Aliquam rutrum lorem ac risus. Morbi', '2015-05-10 15:30:15'),
(322, 5, 9, 'in, tempus eu, ligula. Aenean euismod', '2017-10-07 12:10:32'),
(323, 3, 5, 'sit amet ornare lectus justo eu arcu.', '2013-06-14 21:53:14'),
(324, 3, 10, 'mauris elit, dictum eu, eleifend nec,', '2013-08-22 06:00:17'),
(325, 1, 7, 'ut cursus luctus, ipsum', '2016-05-28 23:12:37'),
(326, 5, 9, 'ante blandit viverra. Donec tempus, lorem fringilla ornare', '2014-07-29 09:13:33'),
(327, 5, 3, 'in aliquet lobortis, nisi nibh lacinia orci, consectetuer', '2015-09-06 10:52:24'),
(328, 5, 4, 'In faucibus. Morbi vehicula. Pellentesque tincidunt tempus risus.', '2018-08-12 08:55:18'),
(329, 3, 7, 'a, facilisis non, bibendum', '2017-11-26 02:20:24'),
(330, 2, 8, 'non leo. Vivamus', '2015-09-10 17:21:40'),
(331, 3, 9, 'fames ac turpis egestas. Aliquam fringilla cursus purus. Nullam scelerisque', '2018-12-10 05:26:56'),
(332, 5, 9, 'ipsum dolor sit amet, consectetuer adipiscing elit.', '2017-09-27 20:53:27'),
(333, 2, 6, 'nunc id enim. Curabitur massa. Vestibulum accumsan', '2015-06-13 08:23:00'),
(334, 2, 6, 'quam a felis ullamcorper', '2015-04-13 01:22:05'),
(335, 4, 10, 'ac mattis ornare, lectus ante dictum mi, ac mattis velit', '2018-03-27 10:15:55'),
(336, 1, 3, 'eget nisi dictum augue malesuada malesuada. Integer id magna', '2014-11-08 17:54:20'),
(337, 2, 6, 'sapien, cursus in, hendrerit consectetuer, cursus et, magna. Praesent', '2018-08-18 23:59:54'),
(339, 2, 8, 'risus. Nulla eget metus', '2014-11-08 04:22:47'),
(340, 4, 10, 'sem, vitae aliquam eros turpis', '2016-11-12 00:55:03'),
(341, 3, 4, 'eget ipsum. Suspendisse sagittis. Nullam vitae', '2015-10-01 05:23:48'),
(342, 5, 1, 'montes, nascetur ridiculus', '2019-01-06 21:31:01'),
(343, 3, 4, 'fringilla. Donec feugiat metus', '2013-08-14 04:19:22'),
(344, 2, 10, 'in consequat enim diam vel arcu. Curabitur ut', '2013-06-29 22:05:14'),
(345, 1, 10, 'orci', '2016-08-21 13:30:49'),
(346, 1, 9, 'metus sit amet ante. Vivamus non lorem vitae', '2018-10-18 13:50:56'),
(347, 1, 1, 'varius. Nam porttitor', '2013-08-26 14:26:21'),
(349, 3, 7, 'massa. Vestibulum accumsan neque', '2017-10-24 09:18:12'),
(350, 2, 3, 'eu neque pellentesque massa lobortis', '2018-10-02 23:25:32'),
(351, 4, 10, 'sit amet, risus. Donec nibh enim,', '2019-01-21 08:26:05'),
(352, 1, 9, 'metus facilisis lorem tristique', '2014-12-03 03:46:19'),
(353, 1, 11, 'sit amet ultricies sem magna nec quam. Curabitur vel lectus.', '2018-11-11 01:00:41'),
(355, 5, 10, 'erat semper rutrum. Fusce', '2018-06-03 02:40:38'),
(356, 4, 6, 'nec, cursus a, enim. Suspendisse aliquet, sem ut', '2014-01-07 16:13:19'),
(357, 2, 9, 'Fusce aliquam,', '2016-05-20 04:39:30'),
(358, 3, 4, 'velit eu sem. Pellentesque ut', '2014-09-11 18:32:33'),
(359, 2, 11, 'odio semper cursus. Integer mollis. Integer tincidunt aliquam', '2019-02-05 05:16:12'),
(360, 5, 2, 'nisi. Mauris nulla. Integer urna. Vivamus molestie', '2013-12-02 23:32:33'),
(361, 4, 5, 'Duis cursus, diam at pretium aliquet, metus', '2016-03-29 20:21:47'),
(362, 5, 9, 'felis. Donec tempor, est ac mattis semper, dui lectus rutrum', '2017-12-10 19:44:34'),
(363, 2, 9, 'Ut sagittis lobortis mauris.', '2017-07-16 05:16:01'),
(364, 5, 6, 'auctor quis, tristique ac, eleifend vitae, erat.', '2017-08-31 13:52:43'),
(365, 2, 6, 'et, magna.', '2016-09-10 08:09:30'),
(366, 2, 3, 'Donec non justo. Proin non massa non ante bibendum', '2014-10-21 13:35:26'),
(369, 4, 4, 'luctus sit', '2014-02-25 14:32:13'),
(370, 3, 3, 'faucibus leo, in lobortis', '2015-04-15 07:03:25'),
(371, 2, 4, 'nunc id', '2018-07-11 05:14:19'),
(372, 5, 9, 'at, velit. Cras lorem lorem, luctus ut, pellentesque eget,', '2016-12-18 11:48:27'),
(373, 2, 8, 'ullamcorper. Duis at lacus. Quisque purus sapien, gravida', '2015-12-31 21:05:15'),
(374, 3, 4, 'In condimentum. Donec', '2017-11-03 14:09:22'),
(375, 4, 3, 'neque. Nullam nisl. Maecenas malesuada fringilla est. Mauris eu turpis.', '2013-09-21 15:28:08'),
(376, 1, 5, 'ac,', '2018-05-06 10:34:15'),
(377, 5, 11, 'Cras eu tellus', '2017-02-19 23:46:29'),
(378, 4, 2, 'id, mollis', '2018-10-12 00:22:05'),
(379, 2, 3, 'massa. Integer vitae', '2018-01-27 09:47:35'),
(380, 4, 7, 'urna. Nullam lobortis quam a felis', '2016-09-20 20:51:37'),
(381, 3, 2, 'in consectetuer ipsum nunc id enim. Curabitur massa. Vestibulum accumsan', '2018-05-25 19:51:28'),
(382, 3, 11, 'libero. Donec consectetuer mauris', '2013-12-18 15:38:57'),
(383, 1, 8, 'ornare. In faucibus. Morbi vehicula. Pellentesque tincidunt tempus risus. Donec', '2018-07-26 08:38:34'),
(385, 5, 2, 'ultricies dignissim', '2017-05-26 06:59:54'),
(386, 3, 7, 'at risus. Nunc', '2013-03-19 11:54:19'),
(387, 1, 7, 'In tincidunt', '2017-03-19 17:19:20'),
(388, 4, 10, 'egestas nunc sed libero.', '2013-04-18 23:14:30'),
(390, 4, 3, 'non massa non ante bibendum ullamcorper. Duis cursus,', '2018-01-30 06:01:05'),
(391, 1, 5, 'magnis dis parturient montes,', '2018-01-29 09:06:23'),
(392, 3, 5, 'molestie. Sed id risus quis diam', '2018-09-13 06:42:38'),
(394, 4, 8, 'Curabitur massa. Vestibulum accumsan neque', '2017-02-03 23:45:08'),
(395, 4, 1, 'arcu. Vivamus sit amet risus. Donec egestas.', '2013-12-31 16:52:17'),
(396, 5, 10, 'vehicula et, rutrum eu, ultrices sit amet,', '2013-04-18 01:11:27'),
(398, 5, 8, 'volutpat nunc sit amet metus.', '2018-10-02 14:16:26'),
(399, 2, 5, 'dolor sit amet, consectetuer adipiscing elit. Curabitur sed tortor.', '2017-09-26 16:13:03'),
(400, 2, 6, 'aliquet, sem ut cursus', '2019-03-13 12:51:12'),
(402, 2, 9, 'Ut semper pretium neque. Morbi quis urna. Nunc quis arcu', '2018-05-08 20:02:00'),
(403, 4, 1, 'dolor sit amet, consectetuer adipiscing elit. Etiam laoreet,', '2013-10-03 23:22:18'),
(404, 3, 11, 'posuere cubilia Curae; Phasellus', '2018-06-29 09:14:09'),
(405, 1, 11, 'mauris ipsum porta elit, a feugiat tellus', '2013-11-15 04:37:09'),
(406, 5, 9, 'convallis est, vitae sodales nisi magna sed dui. Fusce', '2016-01-29 22:11:50'),
(407, 1, 10, 'Suspendisse ac metus vitae velit egestas lacinia. Sed congue, elit', '2015-09-07 09:14:13'),
(408, 2, 9, 'aliquet. Phasellus fermentum convallis ligula. Donec luctus', '2019-03-13 19:38:46'),
(409, 3, 8, 'eu', '2014-05-01 10:42:11'),
(410, 4, 8, 'tempus risus. Donec egestas.', '2019-01-08 22:41:51'),
(411, 1, 6, 'adipiscing', '2013-06-18 07:17:49'),
(412, 5, 7, 'facilisis vitae, orci. Phasellus', '2016-12-17 09:44:53'),
(413, 1, 5, 'lectus, a sollicitudin orci sem eget massa. Suspendisse eleifend. Cras', '2018-03-28 11:55:51'),
(414, 3, 3, 'mauris. Suspendisse aliquet molestie tellus. Aenean egestas hendrerit neque. In', '2018-12-08 11:21:34'),
(416, 3, 3, 'Pellentesque ut ipsum ac', '2016-08-23 10:47:42'),
(417, 5, 8, 'mauris erat eget ipsum. Suspendisse sagittis. Nullam', '2015-09-24 16:53:42'),
(418, 4, 8, 'lacinia. Sed congue, elit sed consequat', '2016-08-27 10:47:35'),
(419, 5, 9, 'nulla magna, malesuada vel, convallis in,', '2018-06-15 17:47:51'),
(420, 2, 2, 'nec,', '2017-01-17 17:22:49'),
(421, 1, 8, 'iaculis enim, sit amet ornare', '2018-06-19 05:43:29'),
(422, 3, 5, 'pede. Suspendisse dui. Fusce diam nunc, ullamcorper eu, euismod ac,', '2013-09-18 03:18:52'),
(423, 4, 1, 'vulputate velit eu sem. Pellentesque ut', '2013-06-03 14:26:08'),
(424, 1, 2, 'Phasellus ornare.', '2014-12-27 04:59:32'),
(425, 3, 10, 'non,', '2014-10-20 16:42:42'),
(426, 5, 7, 'et tristique pellentesque, tellus sem mollis dui,', '2016-11-16 13:53:10'),
(427, 1, 1, 'a,', '2013-03-03 17:29:54'),
(428, 1, 5, 'consequat dolor vitae dolor. Donec fringilla. Donec feugiat', '2013-10-08 18:13:00'),
(429, 4, 5, 'leo. Morbi neque tellus, imperdiet non, vestibulum', '2013-08-24 02:12:28'),
(430, 3, 4, 'pede et risus. Quisque libero lacus,', '2016-03-08 22:39:30'),
(431, 5, 3, 'vitae mauris sit amet lorem semper auctor. Mauris', '2015-03-31 02:06:56'),
(432, 4, 2, 'nostra,', '2018-02-06 16:00:42'),
(433, 3, 3, 'tristique senectus', '2014-03-14 23:37:24'),
(434, 4, 2, 'adipiscing', '2018-12-24 15:40:05'),
(435, 3, 2, 'nec, imperdiet nec, leo. Morbi neque tellus,', '2017-06-02 23:28:24'),
(436, 1, 11, 'auctor non, feugiat nec,', '2018-07-06 23:21:32'),
(437, 3, 3, 'nibh enim, gravida sit amet, dapibus id, blandit at, nisi.', '2019-03-01 02:12:39'),
(438, 3, 4, 'eleifend non, dapibus rutrum, justo.', '2019-02-12 21:12:01'),
(440, 4, 10, 'Nullam scelerisque neque sed sem egestas blandit. Nam', '2015-06-26 22:56:52'),
(442, 2, 3, 'interdum enim non nisi. Aenean eget', '2016-09-03 23:29:30'),
(443, 5, 6, 'neque sed sem egestas blandit. Nam nulla magna, malesuada', '2017-02-21 01:59:55'),
(444, 3, 6, 'Duis sit amet diam eu', '2015-06-16 00:36:19'),
(445, 2, 11, 'Maecenas libero est, congue a, aliquet', '2016-11-15 11:24:14'),
(446, 1, 10, 'mauris. Integer sem elit,', '2014-05-26 22:31:33'),
(447, 4, 10, 'at, velit. Cras lorem lorem, luctus ut, pellentesque', '2013-09-11 11:18:40'),
(449, 4, 5, 'Donec tempus,', '2016-05-01 17:56:21'),
(450, 5, 8, 'lobortis tellus justo sit', '2019-03-06 21:58:07'),
(451, 1, 5, 'penatibus et magnis dis parturient', '2015-05-20 01:43:59'),
(452, 4, 4, 'libero.', '2014-01-21 12:22:17'),
(453, 1, 10, 'sit amet', '2018-05-12 00:48:11'),
(454, 4, 11, 'sed, est. Nunc', '2013-10-04 20:56:06'),
(455, 4, 4, 'Quisque porttitor eros', '2017-04-03 05:20:41'),
(456, 1, 2, 'Cras dolor dolor, tempus non, lacinia at, iaculis', '2014-09-25 21:00:41'),
(457, 5, 2, 'Donec egestas. Aliquam nec enim.', '2018-08-21 01:02:50'),
(459, 5, 2, 'faucibus id, libero. Donec consectetuer', '2015-07-04 13:12:45'),
(460, 4, 1, 'Vivamus non lorem vitae odio sagittis semper. Nam tempor diam', '2018-01-26 11:31:47'),
(461, 3, 7, 'dis parturient montes, nascetur ridiculus', '2013-07-03 05:12:13'),
(462, 2, 8, 'gravida nunc sed pede. Cum sociis natoque penatibus et magnis', '2015-08-07 09:20:22'),
(463, 3, 8, 'Sed neque. Sed eget lacus. Mauris non', '2018-10-17 11:24:23'),
(464, 5, 11, 'tellus. Phasellus elit pede, malesuada vel, venenatis', '2013-07-13 04:06:04'),
(465, 3, 10, 'feugiat metus sit amet ante. Vivamus non', '2013-07-30 02:41:22'),
(467, 5, 3, 'sit amet risus. Donec egestas.', '2016-03-04 13:35:57'),
(468, 4, 3, 'non nisi. Aenean eget metus. In nec orci.', '2014-07-30 19:46:48'),
(469, 5, 11, 'est,', '2013-09-17 05:57:40'),
(470, 4, 5, 'tellus lorem eu metus. In', '2013-06-29 18:52:26'),
(472, 4, 7, 'risus. Duis a mi fringilla mi lacinia mattis. Integer eu', '2016-04-22 22:48:48'),
(473, 4, 5, 'tristique pharetra. Quisque ac libero nec ligula', '2018-10-29 17:57:35'),
(474, 4, 4, 'pede. Cras vulputate', '2018-07-22 13:25:15'),
(475, 3, 11, 'sapien imperdiet', '2016-07-31 13:36:28'),
(476, 4, 9, 'ullamcorper', '2018-05-03 17:21:36'),
(477, 1, 8, 'Donec', '2015-12-22 12:08:39'),
(478, 4, 9, 'cursus et, eros. Proin ultrices. Duis', '2013-06-08 00:02:17'),
(479, 1, 8, 'rhoncus. Nullam velit dui, semper et, lacinia vitae, sodales', '2017-08-19 12:31:09'),
(480, 4, 11, 'pede, malesuada vel,', '2013-06-24 16:45:12'),
(481, 2, 5, 'malesuada vel, convallis in, cursus', '2018-04-28 10:45:52'),
(482, 1, 2, 'Quisque fringilla', '2017-03-20 20:31:07'),
(483, 2, 6, 'lacus. Etiam', '2016-11-12 01:48:58'),
(484, 2, 2, 'mauris elit,', '2018-06-01 02:47:27'),
(486, 3, 10, 'Suspendisse commodo tincidunt nibh. Phasellus nulla. Integer', '2017-02-14 22:47:11'),
(487, 4, 7, 'luctus et ultrices posuere cubilia Curae; Donec tincidunt. Donec', '2018-04-19 08:40:49'),
(488, 2, 9, 'Cras dictum ultricies ligula. Nullam', '2019-02-11 07:04:51'),
(489, 5, 1, 'consectetuer euismod est arcu ac', '2017-08-22 13:55:43'),
(490, 2, 4, 'Cras vulputate velit', '2015-09-24 03:33:41'),
(492, 3, 1, 'magna. Lorem', '2015-07-13 16:50:33'),
(494, 1, 5, 'sociosqu', '2013-11-17 02:09:07'),
(495, 1, 11, 'ipsum sodales purus, in molestie tortor nibh sit amet', '2019-02-01 08:04:25'),
(496, 2, 4, 'ipsum nunc id enim. Curabitur massa.', '2019-01-15 15:27:37'),
(497, 5, 4, 'quis accumsan convallis, ante lectus convallis est, vitae', '2016-03-08 18:20:26'),
(499, 5, 5, 'mi, ac mattis velit justo nec ante.', '2015-07-09 00:03:03'),
(500, 5, 5, 'commodo tincidunt', '2016-06-12 21:28:30'),
(501, 3, 11, 'we try your eye, but can you change everything?, give us a complimentary logo along with the website we don\'t need a contract', '2019-03-24 22:53:16'),
(502, 3, 11, 'test', '2019-03-25 10:45:07'),
(503, 3, 11, 'There are more projects lined up charge extra the next time this is just a 5 minutes job.', '2019-03-25 10:46:35'),
(504, 3, 11, 'test', '2019-03-25 10:48:51'),
(505, 3, 11, 'Mmm, exactly like that, but different. We are a startup. Make it sexy is there a way we can make the page feel more introductory without being cheesy nor jazz it up a little can the black be darker.', '2019-03-25 10:50:19'),
(506, 3, 11, 'efsogfisrhgisgighesioghsogihseighsegsgosehgisoeghosieghosighosiehgioseghosiehgoisehgiosehgiosehgoisehgoisehgoseihgoisehgoisehgoeishgsioeghseoihgoseigheoihgsoighseoighoseighseoighseighseoighsoeighseoig', '2019-03-25 11:18:32');
-- --------------------------------------------------------
--
-- Table structure for table `discussion`
--
CREATE TABLE `discussion` (
`comment_id` int(11) NOT NULL,
`usr_id` int(11) NOT NULL,
`target_id` int(11) NOT NULL,
`content` text NOT NULL,
`commented_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `discussion`
--
INSERT INTO `discussion` (`comment_id`, `usr_id`, `target_id`, `content`, `commented_time`) VALUES
(1, 3, 5, 'Hello', '2019-03-14 15:06:31'),
(2, 3, 5, 'This is a Test', '2019-03-14 15:06:56'),
(3, 3, 5, 'hahaha', '2019-03-14 15:07:16'),
(4, 3, 5, 'Test', '2019-03-14 15:08:43'),
(5, 3, 5, 'Hello', '2019-03-14 15:09:53'),
(6, 3, 5, 'this is a test', '2019-03-14 15:10:05'),
(7, 3, 3, 'Own Profile Test', '2019-03-14 15:14:38'),
(8, 4, 3, 'Samuel is a nerd, NERRRRRRRRRRRRRRRRRRDDDDDDD', '2019-03-14 15:16:33'),
(9, 4, 3, 'is this double ?', '2019-03-14 15:19:51'),
(10, 4, 3, 'wut?', '2019-03-14 15:20:02'),
(11, 4, 4, 'No, You are the real nerd', '2019-03-14 15:21:00'),
(12, 3, 3, 'NO U', '2019-03-15 08:49:22'),
(13, 3, 3, 'test', '2019-03-17 12:38:34'),
(14, 1, 1, 'Testing', '2019-03-19 14:23:57'),
(15, 1, 1, 'Test 2', '2019-03-19 14:24:28');
-- --------------------------------------------------------
--
-- Table structure for table `follow`
--
CREATE TABLE `follow` (
`id` int(11) NOT NULL,
`usr_id` int(11) NOT NULL,
`target_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `follow`
--
INSERT INTO `follow` (`id`, `usr_id`, `target_id`) VALUES
(1, 4, 3),
(2, 3, 3),
(3, 3, 4),
(4, 3, 5),
(5, 1, 5);
-- --------------------------------------------------------
--
-- Table structure for table `likes`
--
CREATE TABLE `likes` (
`like_id` int(11) NOT NULL,
`usr_id` int(11) NOT NULL,
`post_id` int(11) NOT NULL,
`value` int(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `likes`
--
INSERT INTO `likes` (`like_id`, `usr_id`, `post_id`, `value`) VALUES
(3, 3, 9, 1),
(5, 3, 8, 1),
(6, 1, 7, 1),
(8, 1, 2, 0),
(9, 5, 1, 0),
(10, 3, 1, 0),
(11, 3, 2, 0),
(12, 2, 1, 0),
(13, 1, 9, 1),
(14, 5, 9, 1),
(15, 2, 3, 1),
(16, 4, 2, 0),
(17, 2, 5, 1),
(18, 3, 4, 1),
(19, 2, 8, 0),
(20, 2, 1, 1),
(21, 2, 3, 1),
(22, 4, 10, 1),
(23, 5, 7, 0),
(24, 1, 8, 1),
(25, 2, 1, 1),
(26, 5, 3, 1),
(27, 1, 1, 0),
(28, 2, 4, 1),
(29, 4, 4, 1),
(30, 5, 4, 1),
(31, 3, 7, 1),
(32, 5, 1, 0),
(33, 4, 9, 1),
(34, 1, 9, 0),
(35, 3, 3, 0),
(36, 2, 2, 1),
(37, 4, 7, 1),
(38, 1, 5, 1),
(39, 3, 8, 1),
(40, 4, 5, 1),
(41, 3, 3, 0),
(42, 5, 3, 1),
(43, 2, 8, 1),
(44, 1, 11, 1),
(45, 3, 10, 1),
(46, 2, 2, 1),
(47, 5, 1, 0),
(48, 3, 6, 1),
(49, 1, 4, 0),
(50, 1, 5, 1),
(51, 4, 11, 1),
(52, 1, 11, 0),
(53, 5, 2, 0),
(54, 5, 8, 1),
(55, 2, 4, 0),
(56, 1, 10, 0),
(57, 5, 8, 0),
(58, 4, 2, 0),
(59, 5, 5, 1),
(60, 5, 7, 1),
(61, 2, 11, 0),
(62, 4, 5, 0),
(63, 1, 11, 0),
(64, 3, 9, 0),
(65, 1, 8, 1),
(66, 3, 6, 1),
(67, 3, 9, 0),
(68, 2, 2, 0),
(69, 4, 4, 1),
(70, 1, 3, 1),
(71, 2, 9, 0),
(72, 3, 4, 0),
(73, 3, 8, 0),
(74, 3, 3, 0),
(75, 2, 4, 0),
(76, 3, 2, 1),
(77, 3, 7, 0),
(78, 5, 7, 0),
(79, 1, 4, 0),
(80, 5, 4, 0),
(81, 4, 10, 0),
(82, 3, 10, 0),
(83, 5, 6, 0),
(84, 2, 5, 0),
(85, 1, 5, 0),
(86, 5, 1, 1),
(87, 4, 1, 1),
(88, 3, 5, 1),
(89, 5, 1, 0),
(90, 2, 6, 0),
(91, 5, 11, 1),
(92, 4, 11, 0),
(93, 4, 6, 1),
(94, 5, 4, 0),
(95, 3, 1, 0),
(96, 1, 9, 1),
(97, 2, 2, 1),
(98, 3, 7, 0),
(99, 1, 6, 0),
(100, 5, 10, 1),
(101, 4, 10, 0),
(102, 1, 8, 0),
(103, 1, 6, 0),
(104, 4, 2, 0),
(105, 5, 8, 1),
(106, 1, 10, 0),
(107, 5, 10, 1),
(108, 3, 3, 0),
(111, 3, 11, 1);
-- --------------------------------------------------------
--
-- Table structure for table `package`
--
CREATE TABLE `package` (
`id` int(11) NOT NULL,
`package` varchar(255) NOT NULL,
`cost` int(11) NOT NULL,
`coins` int(11) NOT NULL,
`imgPath` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `package`
--
INSERT INTO `package` (`id`, `package`, `cost`, `coins`, `imgPath`) VALUES
(1, '100 coins', 3500, 100, '../asset/icons/coin-1.png'),
(2, '200 coins', 6000, 200, '../asset/icons/coin-2.png'),
(3, '340 coins', 11500, 340, '../asset/icons/coin-3.png'),
(4, '450 coins', 15000, 450, '../asset/icons/coin-4.png');
-- --------------------------------------------------------
--
-- Table structure for table `post`
--
CREATE TABLE `post` (
`post_id` int(11) NOT NULL,
`usr_id` int(11) NOT NULL,
`collab` text NOT NULL,
`edited_date` datetime DEFAULT NULL,
`posted_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`title` varchar(32) NOT NULL,
`content` text NOT NULL,
`category_id` int(11) NOT NULL,
`artPathRaw` text NOT NULL,
`artThumbnail` text NOT NULL,
`artCompressed` text NOT NULL,
`cost` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `post`
--
INSERT INTO `post` (`post_id`, `usr_id`, `collab`, `edited_date`, `posted_date`, `title`, `content`, `category_id`, `artPathRaw`, `artThumbnail`, `artCompressed`, `cost`) VALUES
(1, 3, '', NULL, '2019-03-15 19:17:41', 'This is a test for Compression', 'You can get my logo from facebook can you make the font bigger? but could you solutionize that for me. Can\'t you just take a picture from the internet?', 14, '../image/Post/Peter/1.png', '../image/Post/Peter//thumbnail/1.png', '../image/Post/Peter//compressed/1.png', 25),
(2, 4, '', NULL, '2019-03-16 12:54:05', 'This is a Test', 'This is another test', 1, '../image/Post/Peter/4.jpg', '../image/Post/Peter/thumbnail/2.png', '../image/Post/Peter/compressed/2.png', 25),
(3, 4, '', NULL, '2019-03-16 13:53:10', 'This is a Test 2', 'This is another Test', 1, '../image/Post/Peter/5.png', '../image/Post/Peter/thumbnail/1552715589.png', '../image/Post/Peter/compressed/1552715590.png', 0),
(4, 3, '', NULL, '2019-03-16 13:59:15', 'png transparent test', 'We don\'t need a backup, it never goes down! can you make it pop. Make it original. We are a non-profit organization can you make pink a little more pinkish.', 14, '../image/Post/Peter/6.png', '../image/Post/Peter/thumbnail/1552715955.png', '../image/Post/Peter/compressed/1552715955.png', 25),
(5, 3, '', NULL, '2019-03-16 13:59:57', 'Png transparent 2', 'for we try your eye, but can you change everything? concept is bang on, but can we look at a better execution I need a website. How much will it cost, but I like it, but can the snow look a little warmer, yet can we barter services?.', 14, '../image/Post/Jack Desu/1553484157.jpg', '../image/Post/Jack Desu/thumbnail/1553484157.png', '../image/Post/Jack Desu/compressed/1553484157.png', 25),
(6, 3, '', NULL, '2019-03-16 14:00:43', 'Png transparent test 3', 'but totally different but doing some work for us "pro bono" will really add to your portfolio i promise. Could you do an actual logo instead of a font other agencies charge much lesser.', 14, '../image/Post/Peter/8.png', '../image/Post/Peter/thumbnail/1552716042.png', '../image/Post/Peter/compressed/1552716043.png', 25),
(7, 4, '', NULL, '2019-03-16 14:03:12', 'Very Low Quality Thumnail', 'Very Low Quality Thumnail', 1, '../image/Post/Peter/9.png', '../image/Post/Peter/thumbnail/1552716191.png', '../image/Post/Peter/compressed/1552716192.png', 250),
(8, 3, '', NULL, '2019-03-16 14:37:08', 'Discussion 4', 'More watermark testing', 12, '../image/Post/Peter/10.png', '../image/Post/Peter/thumbnail/1552718227.png', '../image/Post/Peter/compressed/1552718228.png', 25),
(9, 3, '', NULL, '2019-03-16 16:58:33', 'portrait mode', 'Start on it today and we will talk about what i want next time can you rework to make the pizza look more delicious anyway, you are the designer, you know what to do, try a more powerful colour, for is this the best we can do, nor can you make it pop.', 14, '../image/Post/Peter/11.jpg', '../image/Post/Peter/thumbnail/1552726713.png', '../image/Post/Peter/compressed/1552726713.png', 25),
(10, 3, '', NULL, '2019-03-21 12:20:45', 'Buy Test', 'Can you use a high definition screenshot. I got your invoice...it seems really high, why did you charge so much I really think this could go viral could you do an actual logo instead of a font I know somebody who can do this for a reasonable cost, but make', 14, '../image/Post/Jack Desu/6.jpg', '../image/Post/Jack Desu/thumbnail/1553414038.png', '../image/Post/Jack Desu/compressed/1553414038.png', 25),
(11, 3, '', NULL, '2019-03-21 12:25:02', 'Discussion 4', 'start on it today and we will talk about what i want next time nor I want you to take it to the next level start on it today and we will talk about what i want next time or that sandwich needs to be more playful it needs to be the same', 14, '../image/Post/Peter/14.png', '../image/Post/Peter/thumbnail/1553142302.png', '../image/Post/Peter/compressed/1553142302.png', 1);
-- --------------------------------------------------------
--
-- Table structure for table `report_post`
--
CREATE TABLE `report_post` (
`report_id` int(11) NOT NULL,
`usr_id` int(11) NOT NULL,
`post_id` int(11) NOT NULL,
`report_type` varchar(64) NOT NULL,
`report_content` text NOT NULL,
`reportedDateTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `report_user`
--
CREATE TABLE `report_user` (
`report_id` int(11) NOT NULL,
`usr_id` int(11) NOT NULL,
`target_id` int(11) NOT NULL,
`report_type` varchar(64) NOT NULL,
`report_title` varchar(64) DEFAULT NULL,
`report_content` text NOT NULL,
`reportedDateTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`dismiss` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `report_user`
--
INSERT INTO `report_user` (`report_id`, `usr_id`, `target_id`, `report_type`, `report_title`, `report_content`, `reportedDateTime`, `dismiss`) VALUES
(1, 3, 1, 'Harassment', 'This is a Test', 'This is a Test for reporting user', '2019-03-11 11:16:13', 0),
(2, 3, 4, 'Harassment', 'Discussion 4', 'This is another Test', '2019-03-11 11:27:52', 2),
(3, 3, 4, 'Others', 'This is a test for others', 'This is a test for others', '2019-03-11 11:28:59', 2),
(4, 3, 4, 'Harassment', NULL, 'This is a Test for a REALLY LOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOONG STRING', '2019-03-11 11:35:44', 2),
(5, 5, 4, 'Spam', NULL, 'He spams alot in the comment section', '2019-03-11 18:25:17', 0),
(6, 5, 4, 'Harassment', NULL, 'This is a Test', '2019-03-12 08:06:37', 0),
(7, 3, 4, 'Harassment', NULL, 'Testing', '2019-03-14 15:56:34', 0),
(8, 3, 4, 'Harassment', NULL, 'adeadefeafe', '2019-03-16 12:31:18', 0),
(9, 3, 1, 'Harassment', NULL, 'Ban hammer', '2019-03-19 14:28:12', 0);
-- --------------------------------------------------------
--
-- Table structure for table `transaction`
--
CREATE TABLE `transaction` (
`id` varchar(255) NOT NULL,
`usr_id` int(11) NOT NULL,
`cus_id` varchar(255) NOT NULL,
`package` varchar(255) NOT NULL,
`amount` varchar(255) NOT NULL,
`currency` varchar(255) NOT NULL,
`status` varchar(255) NOT NULL,
`created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `transaction`
--
INSERT INTO `transaction` (`id`, `usr_id`, `cus_id`, `package`, `amount`, `currency`, `status`, `created`) VALUES
('ch_1EFaxEF0CW8e8rzonAw3pFyP', 3, 'cus_Ej33hGBnfzFKLW', '450 coins', '15000', 'myr', 'succeeded', '2019-03-19 13:57:42'),
('ch_1EFbD1F0CW8e8rzo44NHi1Wb', 4, 'cus_Ej3JonfltorKYL', '450 coins', '15000', 'myr', 'succeeded', '2019-03-19 14:14:02'),
('ch_1EFbeoF0CW8e8rzoP4krpwrP', 1, 'cus_Ej3m1wiNB5qQG1', '450 coins', '15000', 'myr', 'succeeded', '2019-03-19 14:42:45'),
('ch_1EFEl1F0CW8e8rzoKKHUg3cR', 3, 'cus_Eig7uPnlBEAtHK', '100 coins', '3500', 'myr', '0', '2019-03-18 14:15:37'),
('ch_1EFFRGF0CW8e8rzo37jEZl25', 3, 'cus_EigoX1uBAnkKKk', '450 coins', '15000', 'myr', 'succeeded', '2019-03-18 14:59:15'),
('ch_1EFGKJF0CW8e8rzo7AuQ92aw', 3, 'cus_Eihjl0ho53QKIS', '450 coins', '15000', 'myr', 'succeeded', '2019-03-18 15:56:09'),
('ch_1EFIPrF0CW8e8rzoAueuJ8wv', 3, 'cus_Eijt0lZpAQ0mf1', '200 coins', '6000', 'myr', 'succeeded', '2019-03-18 18:10:00'),
('ch_1EFLgKF0CW8e8rzo6BnCgfw9', 1, 'cus_EinGk6j2PlLvoa', '100 coins', '3500', 'myr', 'succeeded', '2019-03-18 21:39:13'),
('ch_1EFLXDF0CW8e8rzo9gQNIBdw', 1, 'cus_Ein7wKqfINwMKg', '450 coins', '15000', 'myr', 'succeeded', '2019-03-18 21:29:50'),
('ch_1EFLXMF0CW8e8rzoBf3EGHtx', 1, 'cus_Ein70oIg1aIecT', '450 coins', '15000', 'myr', 'succeeded', '2019-03-18 21:29:58'),
('ch_1EFWKOF0CW8e8rzozayq5kRo', 3, 'cus_EiyGRhxcNzQS07', '450 coins', '15000', 'myr', 'succeeded', '2019-03-19 09:01:19'),
('ch_1EGz6NF0CW8e8rzoqI6ZSXbF', 3, 'cus_EkU4Vj2KPQpDGE', '450 coins', '15000', 'myr', 'succeeded', '2019-03-23 09:56:52');
-- --------------------------------------------------------
--
-- Table structure for table `usr`
--
CREATE TABLE `usr` (
`usr_id` int(11) NOT NULL,
`profileImgPath` varchar(255) NOT NULL DEFAULT '../image/Profile/default/1.png',
`usrnm` varchar(32) NOT NULL,
`pwd` varchar(64) NOT NULL,
`nickname` varchar(32) NOT NULL,
`email` varchar(64) NOT NULL,
`joined` datetime NOT NULL,
`score` double NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `usr`
--
INSERT INTO `usr` (`usr_id`, `profileImgPath`, `usrnm`, `pwd`, `nickname`, `email`, `joined`, `score`) VALUES
(1, '../image/Profile/jyling16/1553478519.png', 'jyling16', '$2y$10$UhyBDQscUpMk5U3actM2m.oCw17gzmAD9Ak8P4eT25FArvAs1dll2', 'Jack', '[email protected]', '2019-03-05 08:57:41', 0.9),
(2, '../image/Profile/RyanSu/1553478542.png', 'RyanSu', '$2y$10$2v/wPA77ClZPSRgqija7juG6vtw8KOGjtmzGfh9nKgaEl6ubPOWz.', 'Jedi', '[email protected]', '2019-03-05 09:00:37', 0.9),
(3, '../image/Profile/Jack Desu/1553478490.png', 'Jack Desu', '$2y$10$.j1Uq5G7NFmQTr3KFPjdhOrz94ri3X5/DMleGLGn8o/svq2X3tvBa', 'Samuel Ling', '[email protected]', '2019-03-05 09:00:58', 0.9),
(4, '../image/Profile/NewUser/1553478934.png', 'NewUser', '$2y$10$YgMeQcQ4ZLs9ENo3xb12j.zHUP5qa.tglh7MZxIo/x3dGR81tOJvC', 'missingNo', '[email protected]', '2019-03-06 00:33:39', 0.9),
(5, '../image/Profile/Peter/1553478596.png', 'Peter', '$2y$10$DSx20zySU9FhgyQpaV8JMewL8uFVv00imwZnb5UysxOGHVlV38wma', 'Peter', '[email protected]', '2019-03-11 18:08:29', 0.9);
-- --------------------------------------------------------
--
-- Table structure for table `usr_coin`
--
CREATE TABLE `usr_coin` (
`usr_id` int(11) NOT NULL,
`coins` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `usr_coin`
--
INSERT INTO `usr_coin` (`usr_id`, `coins`) VALUES
(1, 425),
(3, 675),
(4, 350);
-- --------------------------------------------------------
--
-- Table structure for table `usr_group`
--
CREATE TABLE `usr_group` (
`usr_id` int(11) NOT NULL,
`permission` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `usr_group`
--
INSERT INTO `usr_group` (`usr_id`, `permission`) VALUES
(1, '{\"usr\":{\"accType\":\"artist\",\"permission\":{\"post\":true,\"comment\":true}}}'),
(2, '{\r\n \"usr\": {\r\n \"accType\" : \"normal\",\r\n \"permission\": {\r\n \"post\": false,\r\n \"comment\": false\r\n }\r\n }\r\n }'),
(3, '{\r\n \"usr\": {\r\n \"accType\" : \"admin\",\r\n \"permission\": {\r\n \"post\": true,\r\n \"comment\": false\r\n }\r\n }\r\n }'),
(4, '{\"usr\":{\"accType\":\"artist\",\"permission\":{\"post\":true,\"comment\":true}}}'),
(5, '{\"usr\":{\"accType\":\"artist\",\"permission\":{\"post\":true,\"comment\":false}}}');