-
Notifications
You must be signed in to change notification settings - Fork 0
/
tr18lx.sql
5457 lines (5349 loc) · 539 KB
/
tr18lx.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
/*
Navicat Premium Data Transfer
Source Server : local
Source Server Type : MySQL
Source Server Version : 50720
Source Host : localhost:3306
Source Schema : tr18lx
Target Server Type : MySQL
Target Server Version : 50720
File Encoding : 65001
Date: 02/03/2018 14:28:18
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for aoa_attachment_list
-- ----------------------------
DROP TABLE IF EXISTS `aoa_attachment_list`;
CREATE TABLE `aoa_attachment_list` (
`attachment_id` bigint(20) NOT NULL AUTO_INCREMENT,
`attachment_name` varchar(255) DEFAULT NULL,
`attachment_path` varchar(255) DEFAULT NULL,
`attachment_shuffix` varchar(255) DEFAULT NULL,
`attachment_size` varchar(255) DEFAULT NULL,
`attachment_type` varchar(255) DEFAULT NULL,
`model` varchar(255) DEFAULT NULL,
`upload_time` datetime DEFAULT NULL,
`user_id` varchar(255) DEFAULT NULL,
PRIMARY KEY (`attachment_id`)
) ENGINE=InnoDB AUTO_INCREMENT=83 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of aoa_attachment_list
-- ----------------------------
BEGIN;
INSERT INTO `aoa_attachment_list` VALUES (3, '5.jpg', '/2017/09/罗密欧/a554a26e-546f-4da5-b9ed-80454851e590.jpg', 'jpg', '175797', 'image/jpeg', 'note', '2017-09-18 16:33:25', '1');
INSERT INTO `aoa_attachment_list` VALUES (6, '4.jpg', '/2017/09/罗密欧/74b9678a-1689-4a62-9345-68825e256cd6.jpg', 'jpg', '133831', 'image/jpeg', 'note', '2017-09-15 11:01:08', '1');
INSERT INTO `aoa_attachment_list` VALUES (7, '3.jpg', '/2017/09/罗密欧/fb8d46c2-fe8c-4e5e-9d1e-a7e937a16d77.jpg', 'jpg', '231999', 'image/jpeg', 'note', '2017-09-15 11:04:38', '1');
INSERT INTO `aoa_attachment_list` VALUES (8, '3.jpg', '/2017/09/罗密欧/67ea8f24-1a07-4618-acf8-7a4b2f093e0d.jpg', 'jpg', '231999', 'image/jpeg', 'note', '2017-09-15 11:09:21', '1');
INSERT INTO `aoa_attachment_list` VALUES (9, '2.jpg', '/2017/09/罗密欧/2818321d-76df-4b3f-80ea-a62effe28690.jpg', 'jpg', '302654', 'image/jpeg', 'note', '2017-09-23 16:43:50', '1');
INSERT INTO `aoa_attachment_list` VALUES (10, '5.jpg', '/2017/09/罗密欧/e9a07fda-551f-4351-af86-68dfe5e8bad4.jpg', 'jpg', '175797', 'image/jpeg', 'note', '2017-09-15 20:11:22', '1');
INSERT INTO `aoa_attachment_list` VALUES (11, '5.jpg', '/2017/09/罗密欧/0cdd59d1-1d49-4e03-aa9c-2f56779303f1.jpg', 'jpg', '175797', 'image/jpeg', 'note', '2017-09-15 20:14:50', '1');
INSERT INTO `aoa_attachment_list` VALUES (12, '5.jpg', '/2017/09/罗密欧/9700c576-58bc-4036-aecd-e704b22f7175.jpg', 'jpg', '175797', 'image/jpeg', 'note', '2017-09-15 20:37:24', '1');
INSERT INTO `aoa_attachment_list` VALUES (13, '5.jpg', '/2017/09/罗密欧/eec316a6-f7e8-4b85-a8d5-72f2af01256a.jpg', 'jpg', '175797', 'image/jpeg', 'note', '2017-09-15 23:06:24', '1');
INSERT INTO `aoa_attachment_list` VALUES (44, '1.jpg', '/2017/09/罗密欧/aa5be2a8-5705-4199-b1ba-0df2424e3eb8.jpg', 'jpg', '191177', 'image/jpeg', 'note', '2017-09-23 15:30:09', '1');
INSERT INTO `aoa_attachment_list` VALUES (46, '4.jpg', '/2017/09/罗密欧/f459a35a-439a-4d4d-a684-731d3bc48c88.jpg', 'jpg', '133831', 'image/jpeg', 'note', '2017-09-23 16:11:11', '1');
INSERT INTO `aoa_attachment_list` VALUES (47, '1.jpg', '/2017/09/罗密欧/44bc1ad7-0e2e-4569-afc1-385783a955bf.jpg', 'jpg', '191177', 'image/jpeg', 'note', '2017-09-23 16:37:05', '1');
INSERT INTO `aoa_attachment_list` VALUES (48, 'touxiang.jpg', '/2017/09/罗密欧/32bd13b9-40f6-4273-bb4a-96a064db8931.jpg', 'jpg', '12124', 'image/jpeg', 'mail', '2017-09-28 19:40:05', '1');
INSERT INTO `aoa_attachment_list` VALUES (49, '30D06FF1176D3C568E37CBE221D2E542.png', '/2017/09/罗密欧/db7577dd-c8aa-4276-a0af-44a1a19866f8.png', 'png', '71260', 'image/png', 'mail', '2017-09-28 21:24:38', '1');
INSERT INTO `aoa_attachment_list` VALUES (50, 'wenwu.gif', '/2017/09/罗密欧/ebbf1830-0808-4cd8-ac43-f40bef5eb514.gif', 'gif', '3532', 'image/gif', 'mail', '2017-09-28 21:27:45', '1');
INSERT INTO `aoa_attachment_list` VALUES (51, 'wenwu.gif', '/2017/09/罗密欧/f86b2292-0ebe-4d34-bf44-ef042b9b7869.gif', 'gif', '3532', 'image/gif', 'mail', '2017-09-28 21:30:40', '1');
INSERT INTO `aoa_attachment_list` VALUES (52, 'touxiang.jpg', '/2017/09/罗密欧/8235e27e-3ad3-4b86-bd6d-f26503d9f394.jpg', 'jpg', '12124', 'image/jpeg', 'mail', '2017-09-28 21:37:44', '1');
INSERT INTO `aoa_attachment_list` VALUES (53, 'touxiang.jpg', '/2017/09/罗密欧/fc55113a-d2ed-4d7a-bed1-8659c9cb301e.jpg', 'jpg', '12124', 'image/jpeg', 'mail', '2017-09-28 21:46:48', '1');
INSERT INTO `aoa_attachment_list` VALUES (54, 'touxiang.jpg', '/2017/09/罗密欧/e2bbea23-4b30-4407-b0c2-0fdced499a54.jpg', 'jpg', '12124', 'image/jpeg', 'mail', '2017-09-28 21:53:24', '1');
INSERT INTO `aoa_attachment_list` VALUES (55, 'touxiang.jpg', '/2017/09/罗密欧/3e3f94aa-b956-460f-811a-91af4438f9f3.jpg', 'jpg', '12124', 'image/jpeg', 'mail', '2017-09-28 22:00:37', '1');
INSERT INTO `aoa_attachment_list` VALUES (56, 'touxiang.jpg', '/2017/09/罗密欧/0c75fe6e-0e3b-4e3e-b1c2-50de92f09664.jpg', 'jpg', '12124', 'image/jpeg', 'mail', '2017-09-28 22:03:46', '1');
INSERT INTO `aoa_attachment_list` VALUES (57, 'touxiang.jpg', '/2017/09/罗密欧/9ef69729-1a49-4d3c-9ed1-75a601d0ae20.jpg', 'jpg', '12124', 'image/jpeg', 'mail', '2017-09-28 22:20:12', '1');
INSERT INTO `aoa_attachment_list` VALUES (58, '截图.png', '/2017/09/罗密欧/61c319da-b1ea-4d83-815c-5abb824e977c.png', 'png', '195652', 'image/png', 'mail', '2017-09-29 22:09:51', '1');
INSERT INTO `aoa_attachment_list` VALUES (59, 'touxiang.jpg', '/2017/10/朱丽叶/e59201dd-65ef-4f0f-801d-999d31be6d75.jpg', 'jpg', '12124', 'image/jpeg', 'mail', '2017-10-01 12:46:44', '2');
INSERT INTO `aoa_attachment_list` VALUES (60, 'touxiang.jpg', '/2017/10/罗密欧/e54faef8-b6aa-4451-8fef-a7c14aea2b86.jpg', 'jpg', '12124', 'image/jpeg', 'mail', '2017-10-01 19:39:14', '1');
INSERT INTO `aoa_attachment_list` VALUES (61, '30D06FF1176D3C568E37CBE221D2E542.png', '/2017/10/罗密欧/7ab2398a-0295-4e53-8037-10e10b5519fb.png', 'png', '71260', 'image/png', 'mail', '2017-10-02 14:49:56', '1');
INSERT INTO `aoa_attachment_list` VALUES (62, 'touxiang.jpg', '/2017/10/罗密欧/e2036a84-4bf0-4637-bf0f-18888745986d.jpg', 'jpg', '12124', 'image/jpeg', 'mail', '2017-10-06 11:02:49', '1');
INSERT INTO `aoa_attachment_list` VALUES (64, '4.jpg', '/2017/10/罗密欧/280308d8-2aca-40af-8868-b138aee8d71d.jpg', 'jpg', '133831', 'image/jpeg', 'note', '2017-10-07 16:03:03', '1');
INSERT INTO `aoa_attachment_list` VALUES (65, '1.jpg', '/2017/10/罗密欧/eabc7cbe-5406-491a-a7f5-52214af201cc.jpg', 'jpg', '191177', 'image/jpeg', 'note', '2017-10-07 16:03:58', '1');
INSERT INTO `aoa_attachment_list` VALUES (66, 'touxiang.jpg', '/2017/10/光宇/ea6c9723-9a0f-46e0-adbc-1cf41b44a805.jpg', 'jpg', '12124', 'image/jpeg', 'aoa_bursement', '2017-10-12 23:25:57', '18');
INSERT INTO `aoa_attachment_list` VALUES (67, 'touxiang.jpg', '/2017/10/伊丽莎白/b11342e1-bcf1-4196-b6a3-b900a5ce1c7a.jpg', 'jpg', '12124', 'image/jpeg', 'aoa_bursement', '2017-10-14 21:22:35', '3');
INSERT INTO `aoa_attachment_list` VALUES (68, 'touxiang.jpg', '/2017/10/光宇/d2377f04-95b7-49a3-95d1-e7ea7d51b204.jpg', 'jpg', '12124', 'image/jpeg', 'aoa_bursement', '2017-10-15 19:17:46', '18');
INSERT INTO `aoa_attachment_list` VALUES (69, 'touxiang.jpg', '/2017/10/光宇/ab5ebe75-a3ca-482f-96ea-ab353b3521fd.jpg', 'jpg', '12124', 'image/jpeg', 'mail', '2017-10-16 17:17:51', '18');
INSERT INTO `aoa_attachment_list` VALUES (70, 'touxiang.jpg', '/2017/10/罗密欧/3190c54b-ccdd-435c-8796-59f3d714b605.jpg', 'jpg', '12124', 'image/jpeg', 'mail', '2017-10-16 17:42:16', '1');
INSERT INTO `aoa_attachment_list` VALUES (71, '3.jpg', '/2017/10/罗密欧/49cca32e-a317-4cb3-b804-7a7ffe6b70ea.jpg', 'jpg', '231999', 'image/jpeg', 'note', '2017-10-18 16:13:02', '1');
INSERT INTO `aoa_attachment_list` VALUES (72, 'touxiang.jpg', '/2017/10/罗密欧/9bb7b8a0-cdc2-4e6a-bbf9-76741ec6d9f8.jpg', 'jpg', '12124', 'image/jpeg', 'mail', '2017-10-18 17:45:16', '1');
INSERT INTO `aoa_attachment_list` VALUES (73, 'timg.jpeg', '/2017/10/soli/f8055ab3-eb20-47bd-b015-b5b602ddb905.jpeg', 'jpeg', '696381', 'image/jpeg', 'note', '2017-10-19 23:37:37', '5');
INSERT INTO `aoa_attachment_list` VALUES (74, '2.jpg', '/2017/10/小李父斯基/294ccc18-1710-4fbf-8fff-4d547102d9d4.jpg', 'jpg', '302654', 'image/jpeg', 'note', '2017-10-20 10:35:00', '4');
INSERT INTO `aoa_attachment_list` VALUES (75, '3.jpg', '/2017/10/小李父斯基/7d7ffa12-5120-4c2d-85f0-71f3e61cde78.jpg', 'jpg', '231999', 'image/jpeg', 'note', '2017-10-20 10:36:07', '4');
INSERT INTO `aoa_attachment_list` VALUES (76, '5.jpg', '/2017/10/甄姬/9fbe4e2b-21be-40a4-bc95-0e10fdbc6183.jpg', 'jpg', '175797', 'image/jpeg', 'note', '2017-10-20 10:40:03', '7');
INSERT INTO `aoa_attachment_list` VALUES (77, '3.jpg', '/2017/10/罗密欧/1b01a1e2-17bf-4e96-98e5-dc8f30526c1c.jpg', 'jpg', '231999', 'image/jpeg', 'note', '2017-10-22 09:21:27', '1');
INSERT INTO `aoa_attachment_list` VALUES (78, '4.jpg', '/2017/10/罗密欧/96d0f196-b218-4e26-88e5-5ec1116271a1.jpg', 'jpg', '133831', 'image/jpeg', 'note', '2017-10-22 09:13:12', '1');
INSERT INTO `aoa_attachment_list` VALUES (79, '4.jpg', '/2017/10/罗密欧/3ac1f528-dac7-4635-8911-2d39e3ac6b03.jpg', 'jpg', '133831', 'image/jpeg', 'note', '2017-10-22 09:26:33', '1');
INSERT INTO `aoa_attachment_list` VALUES (80, '2.jpg', '/2017/10/罗密欧/5026b08c-354d-427d-8fb2-37c0f7b70199.jpg', 'jpg', '302654', 'image/jpeg', 'note', '2017-10-22 09:33:49', '1');
INSERT INTO `aoa_attachment_list` VALUES (81, '1.jpg', '/2017/10/罗密欧/000d6a4f-1a29-44fc-8daf-fe4208eebc54.jpg', 'jpg', '191177', 'image/jpeg', 'note', '2017-10-22 10:00:19', '1');
INSERT INTO `aoa_attachment_list` VALUES (82, '1.jpg', '/2017/10/罗密欧/976c2665-b059-4303-8e59-1ebc1a495ea5.jpg', 'jpg', '191177', 'image/jpeg', 'note', '2017-10-22 11:28:16', '1');
COMMIT;
-- ----------------------------
-- Table structure for aoa_attends_list
-- ----------------------------
DROP TABLE IF EXISTS `aoa_attends_list`;
CREATE TABLE `aoa_attends_list` (
`attends_id` bigint(20) NOT NULL AUTO_INCREMENT,
`attends_ip` varchar(20) DEFAULT NULL,
`attends_remark` varchar(20) DEFAULT NULL,
`attends_time` datetime DEFAULT NULL,
`status_id` bigint(20) DEFAULT NULL,
`type_id` bigint(20) DEFAULT NULL,
`attends_user_id` bigint(20) DEFAULT NULL,
`attend_hmtime` varchar(255) DEFAULT NULL,
`week_ofday` varchar(255) DEFAULT NULL,
`holiday_days` double(255,0) DEFAULT '0',
`holiday_start` date DEFAULT NULL,
PRIMARY KEY (`attends_id`),
KEY `FKaxgqsm98npnl1rxysh9upfjee` (`attends_user_id`),
CONSTRAINT `FKaxgqsm98npnl1rxysh9upfjee` FOREIGN KEY (`attends_user_id`) REFERENCES `aoa_user` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of aoa_attends_list
-- ----------------------------
BEGIN;
INSERT INTO `aoa_attends_list` VALUES (1, '127.0.0.1', '上班正常4', '2017-09-27 08:16:36', 10, 8, 4, '08:16', '星期三', 0, NULL);
INSERT INTO `aoa_attends_list` VALUES (2, '127.0.0.1', '上班迟到2', '2017-08-15 12:40:35', 11, 8, 4, '12:40', '星期二', 0, NULL);
INSERT INTO `aoa_attends_list` VALUES (3, '127.0.0.1', '下班正常', '2017-09-02 18:49:13', 10, 9, 4, '18:49', '星期六', 0, NULL);
INSERT INTO `aoa_attends_list` VALUES (12, NULL, NULL, '2017-09-28 22:17:16', 11, 8, 2, '22:17', '星期四', 0, NULL);
INSERT INTO `aoa_attends_list` VALUES (13, NULL, NULL, '2017-09-28 22:35:24', 10, 9, 2, '22:35', '星期四', 0, NULL);
INSERT INTO `aoa_attends_list` VALUES (14, NULL, NULL, '2017-09-29 13:04:10', 11, 8, 2, '09:50', '星期五', 0, NULL);
INSERT INTO `aoa_attends_list` VALUES (15, NULL, NULL, '2017-09-29 18:49:42', 10, 9, 2, '18:49', '星期五', 0, NULL);
INSERT INTO `aoa_attends_list` VALUES (22, NULL, NULL, '2017-09-06 20:02:40', NULL, 8, 2, NULL, NULL, 0, NULL);
INSERT INTO `aoa_attends_list` VALUES (23, NULL, NULL, '2017-09-14 20:03:20', NULL, 8, 2, NULL, NULL, 0, NULL);
INSERT INTO `aoa_attends_list` VALUES (24, NULL, NULL, '2017-10-01 10:49:32', 11, 8, 2, '10:49', '星期日', 0, NULL);
INSERT INTO `aoa_attends_list` VALUES (25, NULL, NULL, '2017-10-01 20:29:38', 10, 9, 2, '20:29', '星期日', 0, NULL);
INSERT INTO `aoa_attends_list` VALUES (26, NULL, NULL, '2017-10-02 13:10:48', 11, 8, 2, '13:10', '星期一', 0, NULL);
INSERT INTO `aoa_attends_list` VALUES (27, NULL, NULL, '2017-10-02 18:53:15', 10, 9, 2, '18:53', '星期一', 0, NULL);
INSERT INTO `aoa_attends_list` VALUES (28, NULL, NULL, '2017-10-03 12:30:51', 11, 8, 2, '12:30', '星期二', 0, NULL);
INSERT INTO `aoa_attends_list` VALUES (29, NULL, NULL, '2017-10-05 13:26:12', 11, 8, 2, '13:26', '星期四', 0, NULL);
INSERT INTO `aoa_attends_list` VALUES (30, NULL, NULL, '2017-10-05 13:29:58', 12, 9, 2, '13:29', '星期四', 0, NULL);
INSERT INTO `aoa_attends_list` VALUES (31, NULL, NULL, '2017-10-07 16:11:07', 11, 8, 2, '16:11', '星期六', 0, NULL);
INSERT INTO `aoa_attends_list` VALUES (32, NULL, NULL, '2017-10-07 16:24:15', 10, 9, 2, '16:24', '星期六', 0, NULL);
INSERT INTO `aoa_attends_list` VALUES (33, NULL, NULL, '2017-10-08 10:19:24', 11, 8, 2, '10:19', '星期日', 0, NULL);
INSERT INTO `aoa_attends_list` VALUES (34, NULL, NULL, '2017-10-09 10:59:13', 11, 8, 2, '10:59', '星期一', 0, NULL);
INSERT INTO `aoa_attends_list` VALUES (35, '192.168.43.91', NULL, '2017-10-09 14:05:52', 12, 9, 2, '14:05', '星期一', 0, NULL);
INSERT INTO `aoa_attends_list` VALUES (36, '172.31.16.188', NULL, '2017-10-09 16:08:00', 11, 8, 1, '16:08', '星期一', 0, NULL);
INSERT INTO `aoa_attends_list` VALUES (37, '192.168.43.91', NULL, '2017-10-12 15:22:36', 11, 8, 1, '15:22', '星期四', 0, NULL);
INSERT INTO `aoa_attends_list` VALUES (39, '172.31.17.170', NULL, '2017-10-21 15:08:36', 11, 8, 5, '15:08', '星期六', 0, NULL);
INSERT INTO `aoa_attends_list` VALUES (40, '172.31.17.170', NULL, '2017-10-21 15:09:16', 12, 9, 5, '15:09', '星期六', 0, NULL);
INSERT INTO `aoa_attends_list` VALUES (41, '172.31.17.170', '娃娃', '2017-10-21 15:09:58', 11, 8, 6, '15:09', '星期六', 0, NULL);
INSERT INTO `aoa_attends_list` VALUES (42, '172.31.17.170', NULL, '2017-10-21 15:10:05', 12, 9, 6, '15:10', '星期六', 0, NULL);
INSERT INTO `aoa_attends_list` VALUES (43, '172.31.17.170', NULL, '2017-10-21 15:10:53', 11, 8, 7, '15:10', '星期六', 0, NULL);
INSERT INTO `aoa_attends_list` VALUES (44, '172.31.17.170', NULL, '2017-10-21 15:11:09', 12, 9, 7, '15:11', '星期六', 0, NULL);
INSERT INTO `aoa_attends_list` VALUES (45, '172.31.17.170', '迟到了 尴尬', '2017-10-21 16:03:34', 11, 8, 4, '16:03', '星期六', 0, NULL);
INSERT INTO `aoa_attends_list` VALUES (46, NULL, NULL, NULL, 46, NULL, 7, NULL, NULL, 3, '2017-10-19');
INSERT INTO `aoa_attends_list` VALUES (47, '172.31.17.170', NULL, '2017-10-21 16:18:39', 11, 8, 3, '16:18', '星期六', 0, NULL);
INSERT INTO `aoa_attends_list` VALUES (48, '192.168.1.233', NULL, '2017-10-22 10:28:57', 11, 8, 7, '10:28', '星期日', NULL, NULL);
COMMIT;
-- ----------------------------
-- Table structure for aoa_bursement
-- ----------------------------
DROP TABLE IF EXISTS `aoa_bursement`;
CREATE TABLE `aoa_bursement` (
`bursement_id` bigint(20) NOT NULL AUTO_INCREMENT,
`all_money` double DEFAULT NULL,
`allinvoices` int(11) DEFAULT NULL,
`burse_time` datetime DEFAULT NULL,
`financial_advice` varchar(255) DEFAULT NULL,
`manager_advice` varchar(255) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`type_id` bigint(20) DEFAULT NULL,
`operation_name` bigint(20) DEFAULT NULL,
`pro_id` bigint(20) DEFAULT NULL,
`user_name` bigint(20) DEFAULT NULL,
PRIMARY KEY (`bursement_id`),
KEY `FKt3xu5y23deh0mtqkfk3ly6219` (`operation_name`),
KEY `FK666vswh4nl3voq8qalu73v2sq` (`pro_id`),
KEY `FKgnqp4eax31sh7mn3lt2su7olr` (`user_name`),
CONSTRAINT `FK666vswh4nl3voq8qalu73v2sq` FOREIGN KEY (`pro_id`) REFERENCES `aoa_process_list` (`process_id`),
CONSTRAINT `FKgnqp4eax31sh7mn3lt2su7olr` FOREIGN KEY (`user_name`) REFERENCES `aoa_user` (`user_id`),
CONSTRAINT `FKt3xu5y23deh0mtqkfk3ly6219` FOREIGN KEY (`operation_name`) REFERENCES `aoa_user` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of aoa_bursement
-- ----------------------------
BEGIN;
INSERT INTO `aoa_bursement` VALUES (1, 25, 3, NULL, NULL, NULL, '刘敏', 25, NULL, 1, 1);
INSERT INTO `aoa_bursement` VALUES (2, 11, 1, '2017-10-11 22:40:26', '防微杜渐返回为子发hi黯然无光狂热就', '防微杜渐返回为子发hi黯然无光狂热就', '咕咕咕咕', 25, 5, 2, 3);
INSERT INTO `aoa_bursement` VALUES (3, 33, 3, NULL, NULL, NULL, '刘敏', 25, NULL, 3, 9);
INSERT INTO `aoa_bursement` VALUES (4, 11, 1, NULL, NULL, NULL, '刘敏', 25, NULL, 4, 8);
INSERT INTO `aoa_bursement` VALUES (5, 11, 1, '2017-10-11 22:31:50', '范德萨地方大发地方撒大', '范德萨地方大发地方撒大', '宋佳', 25, NULL, 5, 9);
INSERT INTO `aoa_bursement` VALUES (6, 11, 1, NULL, NULL, NULL, '多对多', 25, NULL, 6, 4);
INSERT INTO `aoa_bursement` VALUES (7, 5, 1, NULL, NULL, '属实', '宋佳', 25, NULL, 7, 9);
INSERT INTO `aoa_bursement` VALUES (8, 1000, 1, NULL, NULL, NULL, '宋佳', 25, NULL, 8, 2);
INSERT INTO `aoa_bursement` VALUES (9, 1000, 1, NULL, NULL, NULL, '刘敏', 25, NULL, 9, 9);
COMMIT;
-- ----------------------------
-- Table structure for aoa_catalog
-- ----------------------------
DROP TABLE IF EXISTS `aoa_catalog`;
CREATE TABLE `aoa_catalog` (
`catalog_id` bigint(20) NOT NULL AUTO_INCREMENT,
`catalog_name` varchar(255) DEFAULT NULL,
`parent_id` int(11) DEFAULT NULL,
`cata_user_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`catalog_id`),
KEY `FKbsk5nkjlqmd8j9rmkarse6j1x` (`cata_user_id`),
CONSTRAINT `FKbsk5nkjlqmd8j9rmkarse6j1x` FOREIGN KEY (`cata_user_id`) REFERENCES `aoa_user` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of aoa_catalog
-- ----------------------------
BEGIN;
INSERT INTO `aoa_catalog` VALUES (1, 'note', 1, 1);
INSERT INTO `aoa_catalog` VALUES (2, '诗词记录', 1, 1);
INSERT INTO `aoa_catalog` VALUES (9, '秒懂百科', 1, 2);
INSERT INTO `aoa_catalog` VALUES (11, '上课要案', 1, 3);
INSERT INTO `aoa_catalog` VALUES (12, '错题收集', 1, 3);
INSERT INTO `aoa_catalog` VALUES (32, '规划(3)', 1, 1);
INSERT INTO `aoa_catalog` VALUES (33, '根目录', 1, NULL);
INSERT INTO `aoa_catalog` VALUES (34, '规划(4)', 1, 1);
COMMIT;
-- ----------------------------
-- Table structure for aoa_comment_list
-- ----------------------------
DROP TABLE IF EXISTS `aoa_comment_list`;
CREATE TABLE `aoa_comment_list` (
`comment_id` bigint(20) NOT NULL AUTO_INCREMENT,
`comment` varchar(255) DEFAULT NULL,
`time` datetime DEFAULT NULL,
`comment_user_id` bigint(20) DEFAULT NULL,
`reply_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`comment_id`),
KEY `FK2k00kkfhh93949ybod7qn56ax` (`comment_user_id`),
KEY `FKeopff14rxco5thbwwlu7exglo` (`reply_id`),
CONSTRAINT `FK2k00kkfhh93949ybod7qn56ax` FOREIGN KEY (`comment_user_id`) REFERENCES `aoa_user` (`user_id`),
CONSTRAINT `FKeopff14rxco5thbwwlu7exglo` FOREIGN KEY (`reply_id`) REFERENCES `aoa_reply_list` (`reply_id`)
) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of aoa_comment_list
-- ----------------------------
BEGIN;
INSERT INTO `aoa_comment_list` VALUES (2, '范德萨发', '2017-10-01 22:07:29', 2, 2);
INSERT INTO `aoa_comment_list` VALUES (8, '@朱丽叶 你要干嘛?', '2017-10-02 13:37:48', 1, 2);
INSERT INTO `aoa_comment_list` VALUES (9, '哇哇哇,interesting', '2017-10-02 13:38:20', 1, 3);
INSERT INTO `aoa_comment_list` VALUES (10, 'N这个死鬼', '2017-10-02 13:48:28', 1, 4);
INSERT INTO `aoa_comment_list` VALUES (15, '有什么问题么?', '2017-10-02 16:48:21', 1, 8);
INSERT INTO `aoa_comment_list` VALUES (21, 'fasd fds ', '2017-10-03 00:35:14', 1, 7);
INSERT INTO `aoa_comment_list` VALUES (23, '年轻人,年轻的一批', '2017-10-03 00:52:28', 1, 16);
INSERT INTO `aoa_comment_list` VALUES (24, '你要干嘛?', '2017-10-03 00:55:03', 1, 14);
INSERT INTO `aoa_comment_list` VALUES (25, ' 哇哇,你真的是过分呀', '2017-10-03 00:55:27', 1, 9);
INSERT INTO `aoa_comment_list` VALUES (26, '大四范德萨', '2017-10-03 01:03:01', 1, 17);
INSERT INTO `aoa_comment_list` VALUES (27, '范德萨发爱迪生', '2017-10-03 01:03:43', 1, 17);
INSERT INTO `aoa_comment_list` VALUES (29, '@罗密欧 你好;', '2017-10-03 11:20:37', 1, 17);
INSERT INTO `aoa_comment_list` VALUES (30, '@罗密欧 你好;;', '2017-10-03 11:21:25', 1, 17);
INSERT INTO `aoa_comment_list` VALUES (31, ' 回复你又没有问题;', '2017-10-03 11:22:06', 1, 18);
INSERT INTO `aoa_comment_list` VALUES (34, '发生大法师', '2017-10-04 01:33:18', 2, 61);
INSERT INTO `aoa_comment_list` VALUES (35, '富士达发', '2017-10-04 01:36:40', 2, 61);
INSERT INTO `aoa_comment_list` VALUES (36, '范德萨', '2017-10-04 01:36:48', 2, 61);
INSERT INTO `aoa_comment_list` VALUES (37, '@朱丽叶 有意思', '2017-10-04 01:37:51', 2, 61);
INSERT INTO `aoa_comment_list` VALUES (38, '你哟啊干嘛?', '2017-10-04 01:38:05', 2, 61);
INSERT INTO `aoa_comment_list` VALUES (39, '@朱丽叶 回复可以么?', '2017-10-04 01:40:22', 2, 61);
INSERT INTO `aoa_comment_list` VALUES (40, ' 来恢复把', '2017-10-04 01:41:28', 2, 62);
INSERT INTO `aoa_comment_list` VALUES (41, '第一次回复是可以的', '2017-10-04 01:45:47', 2, 61);
INSERT INTO `aoa_comment_list` VALUES (42, '@朱丽叶 第二次回复', '2017-10-04 01:46:07', 2, 61);
INSERT INTO `aoa_comment_list` VALUES (43, '@朱丽叶 第二次回复,第三次回复', '2017-10-04 01:46:25', 2, 61);
INSERT INTO `aoa_comment_list` VALUES (44, '@朱丽叶 你就是朱丽叶呀', '2017-10-04 01:46:43', 2, 61);
INSERT INTO `aoa_comment_list` VALUES (45, '@朱丽叶 你就是朱丽叶呀,我不是,我什么都不是', '2017-10-04 01:46:58', 2, 61);
INSERT INTO `aoa_comment_list` VALUES (46, ' 没有东西是吧', '2017-10-04 01:51:41', 2, 64);
INSERT INTO `aoa_comment_list` VALUES (47, '@朱丽叶 克可达', '2017-10-04 01:51:51', 2, 64);
INSERT INTO `aoa_comment_list` VALUES (48, '你要干啥?', '2017-10-04 01:52:00', 2, 64);
INSERT INTO `aoa_comment_list` VALUES (49, ' 我也想知道为什么?', '2017-10-04 01:53:02', 2, 66);
INSERT INTO `aoa_comment_list` VALUES (50, ' 来,再加一条', '2017-10-04 01:54:12', 2, 66);
INSERT INTO `aoa_comment_list` VALUES (51, '这一次试试', '2017-10-04 01:56:16', 2, 67);
INSERT INTO `aoa_comment_list` VALUES (52, '第八条', '2017-10-04 01:57:53', 2, 67);
INSERT INTO `aoa_comment_list` VALUES (53, ' 再试一下', '2017-10-04 01:59:52', 2, 67);
INSERT INTO `aoa_comment_list` VALUES (54, '发生', '2017-10-04 03:25:38', 2, 60);
INSERT INTO `aoa_comment_list` VALUES (55, '范德萨', '2017-10-04 03:25:43', 2, 60);
INSERT INTO `aoa_comment_list` VALUES (56, '@朱丽叶发 是粉色是', '2017-10-04 03:25:59', 2, 60);
INSERT INTO `aoa_comment_list` VALUES (57, '@朱丽叶 现在开始没有entity了', '2017-10-04 03:26:34', 2, 60);
INSERT INTO `aoa_comment_list` VALUES (58, ' 再是一次', '2017-10-04 03:29:28', 2, 60);
INSERT INTO `aoa_comment_list` VALUES (59, ' 回复一下', '2017-10-04 03:30:23', 2, 60);
INSERT INTO `aoa_comment_list` VALUES (60, ' 没有评论,我怎么办嘛\n', '2017-10-04 03:31:42', 2, 71);
INSERT INTO `aoa_comment_list` VALUES (61, '再来一次', '2017-10-04 03:31:56', 2, 72);
INSERT INTO `aoa_comment_list` VALUES (64, '@朱丽叶6666666', '2017-10-05 23:02:39', 2, 73);
INSERT INTO `aoa_comment_list` VALUES (65, '@朱丽叶 地方撒', '2017-10-05 23:03:14', 2, 73);
INSERT INTO `aoa_comment_list` VALUES (66, '@朱丽叶6767', '2017-10-05 23:04:05', 2, 73);
INSERT INTO `aoa_comment_list` VALUES (67, '@朱丽叶鼎折覆餗', '2017-10-05 23:04:24', 2, 73);
INSERT INTO `aoa_comment_list` VALUES (68, '让他', '2017-10-05 23:07:36', 2, 58);
INSERT INTO `aoa_comment_list` VALUES (69, '手动阀', '2017-10-05 23:07:47', 2, 58);
INSERT INTO `aoa_comment_list` VALUES (70, '@朱丽叶大', '2017-10-05 23:07:54', 2, 58);
INSERT INTO `aoa_comment_list` VALUES (71, '发生', '2017-10-05 23:18:47', 7, 73);
INSERT INTO `aoa_comment_list` VALUES (72, '@甄姬而我若', '2017-10-05 23:19:06', 7, 73);
INSERT INTO `aoa_comment_list` VALUES (73, ' 加一条评论', '2017-10-06 13:38:56', 1, 33);
INSERT INTO `aoa_comment_list` VALUES (74, ' 再加一条', '2017-10-06 13:39:19', 1, 33);
INSERT INTO `aoa_comment_list` VALUES (75, ' 哟哟\n', '2017-10-06 13:46:02', 2, 2);
INSERT INTO `aoa_comment_list` VALUES (76, '@朱丽叶 回复有问题么?', '2017-10-06 13:46:13', 2, 2);
INSERT INTO `aoa_comment_list` VALUES (81, '回复jia1', '2017-10-06 14:16:20', 2, 84);
INSERT INTO `aoa_comment_list` VALUES (82, ' 有问题么?', '2017-10-06 15:25:41', 2, 58);
INSERT INTO `aoa_comment_list` VALUES (83, '没有问题撒', '2017-10-06 16:53:48', 2, 2);
INSERT INTO `aoa_comment_list` VALUES (84, '', '2017-10-06 16:54:05', 2, 2);
INSERT INTO `aoa_comment_list` VALUES (85, '@朱丽叶 一点点小小的问题', '2017-10-06 16:54:05', 2, 2);
INSERT INTO `aoa_comment_list` VALUES (86, '', '2017-10-06 16:54:18', 2, 2);
INSERT INTO `aoa_comment_list` VALUES (87, '@朱丽叶 ??', '2017-10-06 16:54:18', 2, 2);
INSERT INTO `aoa_comment_list` VALUES (88, '', '2017-10-06 16:54:18', 2, 2);
INSERT INTO `aoa_comment_list` VALUES (89, '', '2017-10-06 16:54:18', 2, 2);
INSERT INTO `aoa_comment_list` VALUES (90, ' 不知道发生什么问题了', '2017-10-06 16:56:22', 2, 2);
INSERT INTO `aoa_comment_list` VALUES (91, '该配合你演出的我视而不见😂😂😂', '2017-10-08 15:24:03', 8, 73);
INSERT INTO `aoa_comment_list` VALUES (92, '@罗密欧 好吧,你很棒棒', '2017-10-08 15:27:41', 8, 3);
COMMIT;
-- ----------------------------
-- Table structure for aoa_dept
-- ----------------------------
DROP TABLE IF EXISTS `aoa_dept`;
CREATE TABLE `aoa_dept` (
`dept_id` bigint(20) NOT NULL AUTO_INCREMENT,
`dept_addr` varchar(255) DEFAULT NULL,
`dept_fax` varchar(255) DEFAULT NULL,
`dept_name` varchar(255) DEFAULT NULL,
`dept_tel` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`deptmanager` bigint(20) DEFAULT NULL,
`end_time` datetime DEFAULT NULL,
`start_time` datetime DEFAULT NULL,
PRIMARY KEY (`dept_id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of aoa_dept
-- ----------------------------
BEGIN;
INSERT INTO `aoa_dept` VALUES (1, '五楼', NULL, '总经办', '888888888', '[email protected]', 3, '2017-11-15 22:50:05', '2017-11-07 22:50:11');
INSERT INTO `aoa_dept` VALUES (2, '四楼', NULL, '研发部', '66666666', 'as@fwgh', 4, '2017-09-13 19:04:07', '2010-05-23 00:00:00');
INSERT INTO `aoa_dept` VALUES (3, '三楼', NULL, '财务部', '233333', '[email protected]', 5, '2017-09-19 16:46:26', '2016-09-19 16:46:32');
INSERT INTO `aoa_dept` VALUES (4, '六楼', NULL, '市场部', '666888', '[email protected]', 6, '2016-07-19 16:48:09', '2014-09-19 16:48:20');
INSERT INTO `aoa_dept` VALUES (5, '六楼', NULL, '人事部', '33332222', '[email protected]', 7, '2017-10-07 14:12:05', '2017-05-09 14:12:14');
COMMIT;
-- ----------------------------
-- Table structure for aoa_detailsburse
-- ----------------------------
DROP TABLE IF EXISTS `aoa_detailsburse`;
CREATE TABLE `aoa_detailsburse` (
`detailsburse_id` bigint(20) NOT NULL AUTO_INCREMENT,
`descript` varchar(255) DEFAULT NULL,
`detailmoney` double NOT NULL,
`invoices` int(11) DEFAULT NULL,
`produce_time` datetime DEFAULT NULL,
`subject` varchar(255) DEFAULT NULL,
`bursment_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`detailsburse_id`),
KEY `FKi02w0bghxr73fsc5sbpeyqdnn` (`bursment_id`),
CONSTRAINT `FKi02w0bghxr73fsc5sbpeyqdnn` FOREIGN KEY (`bursment_id`) REFERENCES `aoa_bursement` (`bursement_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of aoa_detailsburse
-- ----------------------------
BEGIN;
INSERT INTO `aoa_detailsburse` VALUES (1, '油费', 12, 1, '2017-10-06 21:53:50', '车辆油费', 1);
INSERT INTO `aoa_detailsburse` VALUES (2, '推广', 13, 2, '2017-10-06 21:54:28', '市场推广费', 1);
INSERT INTO `aoa_detailsburse` VALUES (3, '得到', 11, 1, '2017-10-07 19:42:14', '投标保证金', 2);
INSERT INTO `aoa_detailsburse` VALUES (4, '方法', 11, 1, '2017-10-07 20:34:53', '车辆油费', 3);
INSERT INTO `aoa_detailsburse` VALUES (5, '车费', 22, 2, '2017-10-07 20:36:04', '市场推广费', 3);
INSERT INTO `aoa_detailsburse` VALUES (6, '发发发', 11, 1, '2017-10-07 20:36:53', '房租', 4);
INSERT INTO `aoa_detailsburse` VALUES (7, '房租', 11, 1, '2017-10-07 20:40:56', '房租', 5);
INSERT INTO `aoa_detailsburse` VALUES (8, '发发发', 11, 1, '2017-10-07 22:08:08', '市内交通费', 6);
INSERT INTO `aoa_detailsburse` VALUES (9, '电话费', 5, 1, '2017-10-12 12:56:28', '固定电话费', 7);
INSERT INTO `aoa_detailsburse` VALUES (10, '交房租', 1000, 1, '2017-10-12 22:06:09', '房租', 8);
INSERT INTO `aoa_detailsburse` VALUES (11, '交季度房租', 1000, 1, '2017-10-12 23:24:51', '房租', 9);
COMMIT;
-- ----------------------------
-- Table structure for aoa_director
-- ----------------------------
DROP TABLE IF EXISTS `aoa_director`;
CREATE TABLE `aoa_director` (
`director_id` bigint(20) NOT NULL AUTO_INCREMENT,
`address` varchar(255) DEFAULT NULL,
`company_number` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`image_path` int(11) DEFAULT NULL,
`phone_number` varchar(255) DEFAULT NULL,
`pinyin` varchar(255) DEFAULT NULL,
`remark` varchar(255) DEFAULT NULL,
`sex` varchar(255) DEFAULT NULL,
`user_name` varchar(255) DEFAULT NULL,
`user_id` bigint(20) DEFAULT NULL,
`companyname` varchar(255) DEFAULT NULL,
PRIMARY KEY (`director_id`),
KEY `FKi6pfdnqhbc6js940e2o1vape5` (`user_id`),
CONSTRAINT `FKi6pfdnqhbc6js940e2o1vape5` FOREIGN KEY (`user_id`) REFERENCES `aoa_user` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of aoa_director
-- ----------------------------
BEGIN;
INSERT INTO `aoa_director` VALUES (1, '', '', '[email protected]', NULL, '18173328976', 'zhangsan', '', '男', '张三', 1, '百度科技有限公司');
INSERT INTO `aoa_director` VALUES (2, '35栋517', '66666', '[email protected]', NULL, '18634344455', 'xiongtao', 'nice!', '男', '熊涛', 1, '517小分队');
INSERT INTO `aoa_director` VALUES (3, '湖南省株洲市', '10023', '[email protected]', NULL, '18877665544', 'wangwu', '范德萨', '男', '王五', 1, 'google公司');
INSERT INTO `aoa_director` VALUES (5, '湖南省株洲市天元区', '96578888888', '[email protected]', NULL, '18899999900', 'zhangqifeng', '卫龙、你爱吗?,我不是很爱', '女', '张奇风', 2, '辣条有限公司+百度');
INSERT INTO `aoa_director` VALUES (6, '34栋', '888666', '[email protected]', NULL, '18866554433', 'songjia', '宋氏集团总裁', '男', '宋佳', 1, '宋氏集团');
INSERT INTO `aoa_director` VALUES (7, '泰山西路', '41233243', '[email protected]', NULL, '18877665544', 'xiaoli', '没有什么备注', '男', '小李', 2, 'xi小小公司');
INSERT INTO `aoa_director` VALUES (8, '湖工大', '98877', '[email protected]', NULL, '18877665544', 'xiongxiong', 'interesting', '男', '熊熊', 1, '工大ccu');
INSERT INTO `aoa_director` VALUES (9, '35栋517', '517666', '[email protected]', NULL, '18899887766', 'xuxu', '小分队的名字不错', '男', 'xuxu', 1, '517小分队');
INSERT INTO `aoa_director` VALUES (10, '团员去', '98877', '[email protected]', NULL, '18173328976', 'aa', '有事', '男', 'aa', 18, 'google');
INSERT INTO `aoa_director` VALUES (11, 'timg.jpeg', '12342', '[email protected]', 73, '18876665544', 'wanglaowu', '有意思', '男', '王老五', 5, '联通');
COMMIT;
-- ----------------------------
-- Table structure for aoa_director_users
-- ----------------------------
DROP TABLE IF EXISTS `aoa_director_users`;
CREATE TABLE `aoa_director_users` (
`director_users_id` bigint(20) NOT NULL AUTO_INCREMENT,
`catelog_name` varchar(255) DEFAULT NULL,
`is_handle` int(11) DEFAULT NULL,
`director_id` bigint(20) DEFAULT NULL,
`user_id` bigint(20) DEFAULT NULL,
`share_user_id` bigint(20) DEFAULT NULL,
`sharetime` datetime DEFAULT NULL,
PRIMARY KEY (`director_users_id`),
KEY `FK675oqfmv4kx9w6bgi9rgsb8nw` (`director_id`),
KEY `FK7hq4xk2ja9eka4210qkqq03hi` (`user_id`),
KEY `FKibwkjvmp9383ltkfew1kyy6ny` (`share_user_id`),
CONSTRAINT `FK675oqfmv4kx9w6bgi9rgsb8nw` FOREIGN KEY (`director_id`) REFERENCES `aoa_director` (`director_id`),
CONSTRAINT `FK7hq4xk2ja9eka4210qkqq03hi` FOREIGN KEY (`user_id`) REFERENCES `aoa_user` (`user_id`),
CONSTRAINT `FKibwkjvmp9383ltkfew1kyy6ny` FOREIGN KEY (`share_user_id`) REFERENCES `aoa_user` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of aoa_director_users
-- ----------------------------
BEGIN;
INSERT INTO `aoa_director_users` VALUES (2, '大学咯', 1, 2, 1, NULL, '2017-10-15 18:49:46');
INSERT INTO `aoa_director_users` VALUES (4, '大学同学', 1, NULL, 2, NULL, NULL);
INSERT INTO `aoa_director_users` VALUES (5, '', 1, 5, 1, NULL, NULL);
INSERT INTO `aoa_director_users` VALUES (10, '', 1, 1, 1, NULL, NULL);
INSERT INTO `aoa_director_users` VALUES (14, '', 1, 6, 1, NULL, '2017-10-15 18:39:36');
INSERT INTO `aoa_director_users` VALUES (15, '同学情', 1, 3, 2, 1, '2017-10-14 16:20:49');
INSERT INTO `aoa_director_users` VALUES (19, NULL, 1, 1, 3, 1, '2017-10-14 16:30:26');
INSERT INTO `aoa_director_users` VALUES (20, '小李父斯基的分类', 1, 1, 4, 1, '2017-10-14 16:30:27');
INSERT INTO `aoa_director_users` VALUES (21, NULL, 0, 1, 5, 1, '2017-10-14 16:30:27');
INSERT INTO `aoa_director_users` VALUES (22, '重要客户', 1, 5, 2, 1, '2017-10-14 16:31:31');
INSERT INTO `aoa_director_users` VALUES (23, NULL, 1, 5, 3, 1, '2017-10-14 16:31:31');
INSERT INTO `aoa_director_users` VALUES (25, NULL, 0, 5, 5, 1, '2017-10-14 16:31:31');
INSERT INTO `aoa_director_users` VALUES (26, NULL, 1, 3, 8, 1, '2017-10-14 16:32:35');
INSERT INTO `aoa_director_users` VALUES (27, NULL, 0, 3, 10, 1, '2017-10-14 16:33:23');
INSERT INTO `aoa_director_users` VALUES (28, NULL, 0, 2, 9, 1, '2017-10-14 16:37:02');
INSERT INTO `aoa_director_users` VALUES (29, NULL, 0, 6, 6, 1, '2017-10-14 16:39:48');
INSERT INTO `aoa_director_users` VALUES (30, NULL, 0, 3, 14, 1, '2017-10-14 16:40:55');
INSERT INTO `aoa_director_users` VALUES (31, NULL, 0, 3, 22, 1, '2017-10-14 16:42:22');
INSERT INTO `aoa_director_users` VALUES (32, '', 1, 3, 23, 1, '2017-10-14 16:48:06');
INSERT INTO `aoa_director_users` VALUES (33, NULL, 0, 5, 14, 1, '2017-10-14 16:48:39');
INSERT INTO `aoa_director_users` VALUES (34, '重要客户', 1, 7, 1, 2, '2017-10-14 21:46:48');
INSERT INTO `aoa_director_users` VALUES (36, '', 1, 8, 1, NULL, '2017-10-15 18:46:05');
INSERT INTO `aoa_director_users` VALUES (37, '大学咯', 0, NULL, 1, NULL, '2017-10-15 18:48:56');
INSERT INTO `aoa_director_users` VALUES (38, NULL, 0, NULL, 1, NULL, '2017-10-15 18:50:57');
INSERT INTO `aoa_director_users` VALUES (39, NULL, 1, 9, 1, NULL, '2017-10-15 18:52:05');
INSERT INTO `aoa_director_users` VALUES (40, '重要客户', 0, NULL, 1, NULL, '2017-10-15 18:53:02');
INSERT INTO `aoa_director_users` VALUES (41, '同学情', 0, NULL, 2, NULL, '2017-10-15 18:58:34');
INSERT INTO `aoa_director_users` VALUES (42, NULL, 0, NULL, 3, NULL, '2017-10-15 19:01:00');
INSERT INTO `aoa_director_users` VALUES (43, '第二分类', 0, NULL, 3, NULL, '2017-10-15 19:01:35');
INSERT INTO `aoa_director_users` VALUES (44, '小李父斯基的分类', 0, NULL, 4, NULL, '2017-10-15 19:11:54');
INSERT INTO `aoa_director_users` VALUES (45, NULL, 0, 1, 7, 4, '2017-10-15 19:13:26');
INSERT INTO `aoa_director_users` VALUES (46, NULL, 0, 1, 8, 4, '2017-10-15 19:13:26');
INSERT INTO `aoa_director_users` VALUES (47, NULL, 0, 1, 9, 4, '2017-10-15 19:13:27');
INSERT INTO `aoa_director_users` VALUES (48, 'yoyo', 0, NULL, 4, NULL, '2017-10-15 23:54:26');
INSERT INTO `aoa_director_users` VALUES (49, NULL, 0, 5, 7, 4, '2017-10-15 23:54:50');
INSERT INTO `aoa_director_users` VALUES (50, '', 1, 10, 18, NULL, '2017-10-18 19:54:11');
INSERT INTO `aoa_director_users` VALUES (51, 'aaa', 0, NULL, 18, NULL, '2017-10-18 19:54:46');
INSERT INTO `aoa_director_users` VALUES (52, '', 1, 11, 5, NULL, '2017-10-19 23:37:37');
INSERT INTO `aoa_director_users` VALUES (53, NULL, 0, 3, 9, 23, '2018-02-03 22:16:38');
INSERT INTO `aoa_director_users` VALUES (54, NULL, 0, 3, 13, 23, '2018-02-03 22:20:57');
INSERT INTO `aoa_director_users` VALUES (55, NULL, 0, 5, 11, 1, '2018-02-03 22:34:09');
COMMIT;
-- ----------------------------
-- Table structure for aoa_discuss_list
-- ----------------------------
DROP TABLE IF EXISTS `aoa_discuss_list`;
CREATE TABLE `aoa_discuss_list` (
`discuss_id` bigint(20) NOT NULL AUTO_INCREMENT,
`attachment_id` int(11) DEFAULT NULL,
`content` text,
`create_time` datetime DEFAULT NULL,
`status_id` bigint(20) DEFAULT NULL,
`title` varchar(255) DEFAULT NULL,
`type_id` bigint(20) DEFAULT NULL,
`visit_num` int(11) DEFAULT NULL,
`discuss_user_id` bigint(20) DEFAULT NULL,
`vote_id` bigint(20) DEFAULT NULL,
`modify_time` datetime DEFAULT NULL,
PRIMARY KEY (`discuss_id`),
KEY `FKt8hvx0ai5fto20mmxmy2g8j4g` (`discuss_user_id`),
KEY `FK17yi8arj4vjdr5mm5dhjov10j` (`vote_id`),
CONSTRAINT `FK17yi8arj4vjdr5mm5dhjov10j` FOREIGN KEY (`vote_id`) REFERENCES `aoa_vote_list` (`vote_id`),
CONSTRAINT `FKt8hvx0ai5fto20mmxmy2g8j4g` FOREIGN KEY (`discuss_user_id`) REFERENCES `aoa_user` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of aoa_discuss_list
-- ----------------------------
BEGIN;
INSERT INTO `aoa_discuss_list` VALUES (1, NULL, 'fdsfasfdsfasfsa', '2017-09-29 21:48:28', NULL, 'fsda', 19, 12, 1, NULL, '2017-09-29 21:48:28');
INSERT INTO `aoa_discuss_list` VALUES (6, NULL, '富士达奥奥奥奥奥奥奥奥奥奥奥奥奥奥奥奥奥奥奥奥奥奥奥奥奥奥奥奥奥', '2017-09-29 21:48:28', NULL, 'what????', 20, 7, 2, NULL, '2017-10-04 18:06:39');
INSERT INTO `aoa_discuss_list` VALUES (7, NULL, '发生地方撒范德萨反反复复付付付付付付付付付付付付8', '2017-09-30 13:07:03', NULL, '发生富士达', 19, 20, 2, NULL, '2017-10-05 22:58:38');
INSERT INTO `aoa_discuss_list` VALUES (8, NULL, 'fsdaaaaaaaaaaaaaaafsaaaaaaaaaaa', '2017-09-30 13:12:33', NULL, '同一人', 19, 29, 2, NULL, '2017-10-05 22:59:02');
INSERT INTO `aoa_discuss_list` VALUES (9, NULL, '发生的多多多多多多多多多多多多多多多多多多多多多多多多多多多多多多', '2017-09-30 13:16:51', NULL, '范德萨', 20, 11, 2, NULL, '2017-09-30 13:07:03');
INSERT INTO `aoa_discuss_list` VALUES (12, NULL, 'fsdaaaaaaaaaaaaaaafsaaaaaaaaaaa', '2017-09-30 15:30:26', NULL, '修改了这个名字2333', 19, 96, 2, NULL, '2017-10-04 21:24:09');
INSERT INTO `aoa_discuss_list` VALUES (13, NULL, '<p>\r\n 今天还是不错的,完成了一些内容,比如:修复了分页的小bug;还有一些其他的东西;再把讨论区好好的晚上一下\r\n</p>', '2017-10-01 14:25:26', NULL, '第一天的公告,++小整合', 19, 339, 1, NULL, '2017-10-01 14:25:26');
INSERT INTO `aoa_discuss_list` VALUES (14, NULL, 'afsdddddddd fasdddddddddddddddd', '2017-10-01 14:37:39', NULL, 'fads ', 19, 29, 1, NULL, '2017-10-01 14:37:39');
INSERT INTO `aoa_discuss_list` VALUES (15, NULL, 'afsddddddddddddddddddddddddddddddddddddddd', '2017-10-01 14:40:08', NULL, 'dsaf ', 19, 24, 1, NULL, '2017-10-01 14:40:08');
INSERT INTO `aoa_discuss_list` VALUES (17, NULL, '<p style=\"color:#3F3F3F;font-family:"background-color:#FFFFFF;\">\r\n 每个对象在出生的时候就有一把钥匙(监视器Monitor),那么被synchronized 修饰的方法相当于给方法加了一个锁,这个方法就可以进行同步,在多线程的时候,不会出现线程安全问题。\r\n</p>\r\n<p style=\"color:#3F3F3F;font-family:"background-color:#FFFFFF;\">\r\n <span>注:Monitor是 Java中用以实现线程之间的互斥与协作的主要手段,它可以看成是对象或者 Class的锁。每一个对象都有,也仅有一个 Monitor。</span>\r\n</p>\r\n<p style=\"color:#3F3F3F;font-family:"background-color:#FFFFFF;\">\r\n 下面通过一张图片进行讲解:\r\n</p>\r\n<h4 id=\"1一张图片\" style=\"font-family:"font-weight:300;color:#3F3F3F;font-size:1.25em;background-color:#FFFFFF;\">\r\n <a name=\"t0\"></a>1.一张图片\r\n</h4>\r\n<p style=\"color:#3F3F3F;font-family:"background-color:#FFFFFF;\">\r\n <span>图片看不清,请点击这里 :</span> <a href=\"http://img.blog.csdn.net/20170929230249738?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvdTAxMDY0ODU1NQ==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast\" target=\"_blank\">高清大图</a>\r\n</p>\r\n<p style=\"color:#3F3F3F;font-family:"background-color:#FFFFFF;\">\r\n <img src=\"http://img.blog.csdn.net/20170929230249738?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvdTAxMDY0ODU1NQ==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast\" alt=\"这里写图片描述\" title=\"\" style=\"height:auto;\" />\r\n</p>\r\n<h4 id=\"2图片对应的代码\" style=\"font-family:"font-weight:300;color:#3F3F3F;font-size:1.25em;background-color:#FFFFFF;\">\r\n <a name=\"t1\"></a>2.图片对应的代码\r\n</h4>\r\n<pre class=\"prettyprint\"><span class=\"hljs-keyword\" style=\"color:#000088;\">import</span> java.util.Date; <span class=\"hljs-javadoc\" style=\"color:#880000;\">/**\r\n * 测试的object类\r\n *\r\n *<span class=\"hljs-javadoctag\" style=\"color:#660066;\"> @author</span>:dufy\r\n *<span class=\"hljs-javadoctag\" style=\"color:#660066;\"> @version</span>:1.0.0\r\n *<span class=\"hljs-javadoctag\" style=\"color:#660066;\"> @date</span> 2017/9/29\r\n *<span class=\"hljs-javadoctag\" style=\"color:#660066;\"> @email</span> [email protected]\r\n */</span> <span class=\"hljs-keyword\" style=\"color:#000088;\">public</span> <span class=\"hljs-class\"><span class=\"hljs-keyword\" style=\"color:#000088;\">class</span> <span class=\"hljs-title\" style=\"color:#660066;\">ObjectTest</span> {</span> <span class=\"hljs-keyword\" style=\"color:#000088;\">public</span> <span class=\"hljs-keyword\" style=\"color:#000088;\">synchronized</span> <span class=\"hljs-keyword\" style=\"color:#000088;\">void</span> <span class=\"hljs-title\">methodA</span>(){ <span class=\"hljs-keyword\" style=\"color:#000088;\">try</span> {\r\n System.out.println(<span class=\"hljs-string\" style=\"color:#008800;\">\"This is methodA ....\"</span> + Thread.currentThread().getName() + <span class=\"hljs-string\" style=\"color:#008800;\">\": \"</span> + <span class=\"hljs-keyword\" style=\"color:#000088;\">new</span> Date());\r\n Thread.sleep(<span class=\"hljs-number\" style=\"color:#006666;\">1000</span>);\r\n } <span class=\"hljs-keyword\" style=\"color:#000088;\">catch</span> (InterruptedException e) {\r\n e.printStackTrace();\r\n }\r\n\r\n } <span class=\"hljs-keyword\" style=\"color:#000088;\">public</span> <span class=\"hljs-keyword\" style=\"color:#000088;\">void</span> <span class=\"hljs-title\">methodB</span>(){\r\n\r\n System.out.println(<span class=\"hljs-string\" style=\"color:#008800;\">\"This is methodB ....\"</span> + Thread.currentThread().getName() + <span class=\"hljs-string\" style=\"color:#008800;\">\": \"</span> + <span class=\"hljs-keyword\" style=\"color:#000088;\">new</span> Date());\r\n } <span class=\"hljs-keyword\" style=\"color:#000088;\">public</span> <span class=\"hljs-keyword\" style=\"color:#000088;\">synchronized</span> <span class=\"hljs-keyword\" style=\"color:#000088;\">void</span> <span class=\"hljs-title\">methodC</span>(){ <span class=\"hljs-keyword\" style=\"color:#000088;\">try</span> {\r\n System.out.println(<span class=\"hljs-string\" style=\"color:#008800;\">\"This is methodC ....\"</span> + Thread.currentThread().getName() + <span class=\"hljs-string\" style=\"color:#008800;\">\": \"</span> + <span class=\"hljs-keyword\" style=\"color:#000088;\">new</span> Date());\r\n Thread.sleep(<span class=\"hljs-number\" style=\"color:#006666;\">3000</span>);\r\n } <span class=\"hljs-keyword\" style=\"color:#000088;\">catch</span> (InterruptedException e) {\r\n e.printStackTrace();\r\n }\r\n\r\n }\r\n\r\n\r\n}</pre>', '2017-10-01 15:18:40', NULL, 'fsdaaaaaaaaaa ', 21, 8, 1, NULL, '2017-10-01 15:18:40');
INSERT INTO `aoa_discuss_list` VALUES (23, NULL, 'afdsssssssssssssssssssssssssssssssssssssssssfffffffffffffffffHHHHHHFFFFFFFFFF1111112222222', '2017-10-01 16:38:44', NULL, 'yyyyyyyyyyHHHHHHHHHFFFFFF11111112222', 21, 4, 1, NULL, '2017-10-01 16:38:44');
INSERT INTO `aoa_discuss_list` VALUES (31, NULL, '投票标题test1111投票标题test1111投票标题test1111投票标题test1111', '2017-10-03 21:53:12', NULL, '投票标题test1111', 21, 15, 2, 1, '2017-10-03 21:53:12');
INSERT INTO `aoa_discuss_list` VALUES (32, NULL, '他的44444他的44444他的44444他的44444', '2017-10-03 21:55:10', NULL, '他的44444', 21, 71, 2, 2, '2017-10-03 21:55:09');
INSERT INTO `aoa_discuss_list` VALUES (33, NULL, ' 投票的测试 投票的测试 投票的测试 投票的测试', '2017-10-03 23:25:08', NULL, ' 投票的测试随机颜色的测试', 21, 92, 2, 3, '2017-10-03 23:25:07');
INSERT INTO `aoa_discuss_list` VALUES (34, NULL, '这是一个多选的投票这是一个多选的投票这是一个多选的投票', '2017-10-04 02:58:16', NULL, '这是一个多选的投票', 21, 16, 2, 4, '2017-10-04 02:58:15');
INSERT INTO `aoa_discuss_list` VALUES (35, NULL, '想去哪个地方,尽情发言,,,,,,,反正我们也不会去的,<img src=\"http://localhost:8080/plugins/kindeditor/plugins/emoticons/images/13.gif\" border=\"0\" alt=\"\" /><img src=\"http://localhost:8080/plugins/kindeditor/plugins/emoticons/images/13.gif\" border=\"0\" alt=\"\" /><img src=\"http://localhost:8080/plugins/kindeditor/plugins/emoticons/images/13.gif\" border=\"0\" alt=\"\" />', '2017-10-04 03:19:52', NULL, '旅欧地点投票,单选', 21, 24, 2, 5, '2017-10-04 03:19:52');
INSERT INTO `aoa_discuss_list` VALUES (37, NULL, '未开始时间投票测试未开始时间投票测试未开始时间投票测试', '2017-10-04 15:27:36', NULL, 'xiugai ;未开始时间投票测试', 21, 23, 2, 7, '2017-10-04 18:05:52');
INSERT INTO `aoa_discuss_list` VALUES (38, NULL, 'dfasfsdfafdsfsfasddddddddddddddddddd222', '2017-10-04 16:01:49', NULL, '修改d ;我知道能够修改成功,在修改依稀呢?', 21, 10, 2, 8, '2017-10-04 18:03:16');
INSERT INTO `aoa_discuss_list` VALUES (39, NULL, '333333333333333333333333333333333333333333333333333333', '2017-10-05 22:54:27', NULL, '电风扇', 21, 1, 2, 9, '2017-10-05 22:54:26');
INSERT INTO `aoa_discuss_list` VALUES (40, NULL, '<h2>\r\n 这是投票11234这是投票11234这是投票11234这是投票11234这是投票11234这是投票11234这是投票11234\r\n</h2>', '2017-10-05 22:57:41', NULL, '这是投票11234', 21, 2, 2, 10, '2017-10-05 22:57:41');
INSERT INTO `aoa_discuss_list` VALUES (41, NULL, '4555555555555555555555555555555555555555555', '2017-10-05 22:58:29', NULL, '手动阀123', 21, 3, 2, 11, '2017-10-06 17:03:53');
INSERT INTO `aoa_discuss_list` VALUES (42, NULL, '4444444444444这是投票11234这是投票11234', '2017-10-05 23:17:52', NULL, '大师傅', 20, 4, 7, NULL, '2017-10-05 23:17:52');
INSERT INTO `aoa_discuss_list` VALUES (43, NULL, '[email protected]@[email protected]@[email protected]@qq.com', '2017-10-05 23:25:50', NULL, '范德萨', 21, 2, 7, 12, '2017-10-05 23:25:50');
COMMIT;
-- ----------------------------
-- Table structure for aoa_evection
-- ----------------------------
DROP TABLE IF EXISTS `aoa_evection`;
CREATE TABLE `aoa_evection` (
`evection_id` bigint(20) NOT NULL AUTO_INCREMENT,
`type_id` bigint(20) DEFAULT NULL,
`pro_id` bigint(20) DEFAULT NULL,
`personnel_advice` varchar(255) DEFAULT NULL,
`manager_advice` varchar(255) DEFAULT NULL,
PRIMARY KEY (`evection_id`),
KEY `FKql1c10e5u2vefisjqjbu2d5pa` (`pro_id`),
CONSTRAINT `FKql1c10e5u2vefisjqjbu2d5pa` FOREIGN KEY (`pro_id`) REFERENCES `aoa_process_list` (`process_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of aoa_evection
-- ----------------------------
BEGIN;
INSERT INTO `aoa_evection` VALUES (1, 28, 12, NULL, '发发发');
INSERT INTO `aoa_evection` VALUES (2, 28, 21, NULL, NULL);
INSERT INTO `aoa_evection` VALUES (3, 28, 22, NULL, NULL);
INSERT INTO `aoa_evection` VALUES (4, 28, 23, NULL, NULL);
COMMIT;
-- ----------------------------
-- Table structure for aoa_evectionmoney
-- ----------------------------
DROP TABLE IF EXISTS `aoa_evectionmoney`;
CREATE TABLE `aoa_evectionmoney` (
`evectionmoney_id` bigint(20) NOT NULL AUTO_INCREMENT,
`financial_advice` varchar(255) DEFAULT NULL,
`manager_advice` varchar(255) DEFAULT NULL,
`money` double NOT NULL,
`name` varchar(255) DEFAULT NULL,
`pro_id` bigint(20) DEFAULT NULL,
`pro` int(255) DEFAULT NULL,
PRIMARY KEY (`evectionmoney_id`),
KEY `FKcpuubnshaf2cg47hns9m0h1dq` (`pro_id`),
CONSTRAINT `FKcpuubnshaf2cg47hns9m0h1dq` FOREIGN KEY (`pro_id`) REFERENCES `aoa_process_list` (`process_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of aoa_evectionmoney
-- ----------------------------
BEGIN;
INSERT INTO `aoa_evectionmoney` VALUES (1, NULL, '去项目支持', 1100, '刘敏', 10, NULL);
INSERT INTO `aoa_evectionmoney` VALUES (2, '批准', '情况属实!!!!', 2800, '刘敏', 11, NULL);
INSERT INTO `aoa_evectionmoney` VALUES (3, NULL, '', 940, '得到', 24, 23);
COMMIT;
-- ----------------------------
-- Table structure for aoa_file_list
-- ----------------------------
DROP TABLE IF EXISTS `aoa_file_list`;
CREATE TABLE `aoa_file_list` (
`file_id` bigint(20) NOT NULL AUTO_INCREMENT,
`file_name` varchar(255) DEFAULT NULL,
`file_path` varchar(255) DEFAULT NULL,
`file_shuffix` varchar(255) DEFAULT NULL,
`content_type` varchar(255) DEFAULT NULL,
`model` varchar(255) DEFAULT NULL,
`path_id` bigint(20) DEFAULT NULL,
`size` bigint(20) DEFAULT NULL,
`upload_time` datetime DEFAULT NULL,
`file_user_id` bigint(20) DEFAULT NULL,
`file_istrash` bigint(1) unsigned zerofill DEFAULT '0',
`file_isshare` bigint(20) DEFAULT NULL,
PRIMARY KEY (`file_id`),
KEY `FKfshy9n300pqxjsweo9247jgqs` (`path_id`),
KEY `FKlj6l9qroivus28aiqluue4bew` (`file_user_id`),
CONSTRAINT `FKfshy9n300pqxjsweo9247jgqs` FOREIGN KEY (`path_id`) REFERENCES `aoa_file_path` (`path_id`),
CONSTRAINT `FKlj6l9qroivus28aiqluue4bew` FOREIGN KEY (`file_user_id`) REFERENCES `aoa_user` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=130 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Table structure for aoa_file_path
-- ----------------------------
DROP TABLE IF EXISTS `aoa_file_path`;
CREATE TABLE `aoa_file_path` (
`path_id` bigint(20) NOT NULL AUTO_INCREMENT,
`parent_id` bigint(20) DEFAULT NULL,
`path_name` varchar(255) DEFAULT NULL,
`path_user_id` bigint(20) DEFAULT NULL,
`path_istrash` bigint(20) DEFAULT '0',
PRIMARY KEY (`path_id`)
) ENGINE=InnoDB AUTO_INCREMENT=94 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of aoa_file_path
-- ----------------------------
BEGIN;
INSERT INTO `aoa_file_path` VALUES (1, 0, '根目录', NULL, 0);
INSERT INTO `aoa_file_path` VALUES (6, 1, '罗密欧', 1, 0);
INSERT INTO `aoa_file_path` VALUES (89, 1, '无双', 10, 0);
INSERT INTO `aoa_file_path` VALUES (90, 1, '甄姬', 7, 0);
INSERT INTO `aoa_file_path` VALUES (91, 90, '新建文件夹', 7, 0);
INSERT INTO `aoa_file_path` VALUES (92, 91, '新建文件5夹', 7, 0);
INSERT INTO `aoa_file_path` VALUES (93, 1, '于彤', 13, 0);
COMMIT;
-- ----------------------------
-- Table structure for aoa_holiday
-- ----------------------------
DROP TABLE IF EXISTS `aoa_holiday`;
CREATE TABLE `aoa_holiday` (
`holiday_id` bigint(20) NOT NULL AUTO_INCREMENT,
`leave_days` int(11) DEFAULT NULL,
`type_id` bigint(20) DEFAULT NULL,
`pro_id` bigint(20) DEFAULT NULL,
`manager_advice` varchar(255) DEFAULT NULL,
`personnel_advice` varchar(255) DEFAULT NULL,
PRIMARY KEY (`holiday_id`),
KEY `FK1glo2wpb4kuiop1ymjxs0knxj` (`pro_id`),
CONSTRAINT `FK1glo2wpb4kuiop1ymjxs0knxj` FOREIGN KEY (`pro_id`) REFERENCES `aoa_process_list` (`process_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of aoa_holiday
-- ----------------------------
BEGIN;
INSERT INTO `aoa_holiday` VALUES (1, 2, 38, 16, '准假', NULL);
INSERT INTO `aoa_holiday` VALUES (2, 1, 37, 25, 'as电饭锅', 'as电饭锅和');
COMMIT;
-- ----------------------------
-- Table structure for aoa_in_mail_list
-- ----------------------------
DROP TABLE IF EXISTS `aoa_in_mail_list`;
CREATE TABLE `aoa_in_mail_list` (
`mail_id` bigint(20) NOT NULL AUTO_INCREMENT,
`mail_content` text,
`mail_create_time` datetime DEFAULT NULL,
`mail_file_id` bigint(20) DEFAULT NULL,
`mail_title` varchar(255) NOT NULL,
`mail_type` bigint(20) DEFAULT NULL,
`mail_in_push_user_id` bigint(20) DEFAULT NULL,
`in_receiver` varchar(255) DEFAULT NULL,
`mail_status_id` bigint(20) DEFAULT NULL,
`mail_number_id` bigint(20) DEFAULT NULL,
`mail_del` int(11) DEFAULT NULL,
`mail_push` int(11) DEFAULT NULL,
`mail_star` int(11) DEFAULT NULL,
PRIMARY KEY (`mail_id`),
KEY `FK33o7j8f0xk8n8vrk576iktglc` (`mail_file_id`),
KEY `FK933q7ouoddu584qg08rbvwvxi` (`mail_in_push_user_id`),
KEY `FKghibt111d1yvc3f02x06sihjp` (`mail_number_id`),
CONSTRAINT `FK33o7j8f0xk8n8vrk576iktglc` FOREIGN KEY (`mail_file_id`) REFERENCES `aoa_attachment_list` (`attachment_id`),
CONSTRAINT `FK933q7ouoddu584qg08rbvwvxi` FOREIGN KEY (`mail_in_push_user_id`) REFERENCES `aoa_user` (`user_id`),
CONSTRAINT `FKghibt111d1yvc3f02x06sihjp` FOREIGN KEY (`mail_number_id`) REFERENCES `aoa_mailnumber` (`mail_number_id`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of aoa_in_mail_list
-- ----------------------------
BEGIN;
INSERT INTO `aoa_in_mail_list` VALUES (2, '<p>\r\n 咕咕咕咕\r\n</p>\r\n<p>\r\n 一月又一月\r\n</p>', '2017-09-28 19:40:05', 48, '啊啊啊啊', 16, 1, '朱丽叶', 20, NULL, 0, 1, 0);
INSERT INTO `aoa_in_mail_list` VALUES (3, '<p>\r\n 哈哈哈哈或\r\n</p>\r\n<p>\r\n 哈哈哈哈或或\r\n</p>', '2017-09-28 20:08:25', NULL, '啊啊啊啊啊', 16, 1, '[email protected]', 20, 1, 0, 1, 0);
INSERT INTO `aoa_in_mail_list` VALUES (4, '<p>\r\n 的点点滴滴多多多多\r\n</p>\r\n<p>\r\n 咯咯咯咯咯过过过\r\n</p>\r\n<p>\r\n 哈哈哈哈或或或或\r\n</p>', '2017-09-28 21:24:39', 49, '趣味体育活动当天的决定', 16, 1, '[email protected]', 20, 1, 0, 1, 0);
INSERT INTO `aoa_in_mail_list` VALUES (5, '反反复复付', '2017-09-28 21:27:45', 50, '多对多', 16, 1, '伊丽莎白', 20, NULL, 0, 1, 0);
INSERT INTO `aoa_in_mail_list` VALUES (6, '凄凄切切群群群群群', '2017-09-28 21:30:40', 51, '凄凄切切', 16, 1, '[email protected]', 20, 1, 0, 1, 0);
INSERT INTO `aoa_in_mail_list` VALUES (7, '<p>\r\n 咯咯咯咯咯\r\n</p>\r\n<p>\r\n 哈哈哈哈或\r\n</p>', '2017-09-28 21:37:44', 52, '凄凄切切', 16, 1, '[email protected]', 20, 1, 1, 1, 0);
INSERT INTO `aoa_in_mail_list` VALUES (8, '沉浸在这美好的安然中,你会喜欢上这最绚丽的色彩,爱上这段沉静的时光,恋上这份清怡的静美。', '2017-09-28 21:46:48', 53, '试试', 16, 1, '[email protected];[email protected]', 20, 1, 0, 1, 0);
INSERT INTO `aoa_in_mail_list` VALUES (9, '<p>\r\n 沉浸在这美好的安然中,你会喜欢上这最绚丽的色彩,\r\n</p>\r\n<p>\r\n 爱上这段沉静的时光,恋上这份清怡的静美。\r\n</p>', '2017-09-28 21:53:25', 54, '试试', 16, 1, '[email protected];[email protected]', 20, 1, 0, 1, 0);
INSERT INTO `aoa_in_mail_list` VALUES (10, '<p>\r\n <span style=\"color:#333333;font-family:宋体;font-size:14px;background-color:#FFFFFF;\">他便过来抱着我说:“孩子,爸爸也想给你一个妈妈。”可是,爸爸真的做不到。</span>\r\n</p>\r\n<p>\r\n <span style=\"color:#333333;font-family:宋体;font-size:14px;background-color:#FFFFFF;\">爸爸会尽力像妈妈一样的爱你。我总是能从他的眼里看到晶莹闪光的东西,想掉又掉不下来。</span>\r\n</p>\r\n<p>\r\n <span style=\"color:#333333;font-family:宋体;font-size:14px;background-color:#FFFFFF;\">那一年我四岁半,似懂非懂的点点头,迎合着我唯一能抓住的亲人。</span>\r\n</p>', '2017-09-28 22:00:37', 55, '再试试', 16, 1, '[email protected];[email protected]', 20, 1, 1, 1, 0);
INSERT INTO `aoa_in_mail_list` VALUES (11, '<a href=\"http://www.jj59.com/zti/tongnian/\" class=\"keywordlink\">童年</a><span style=\"color:#333333;font-family:宋体;font-size:14px;background-color:#FFFFFF;\">的时光总是很短暂,最</span><a href=\"http://www.jj59.com/zti/kuaile/\" class=\"keywordlink\">快乐</a><span style=\"color:#333333;font-family:宋体;font-size:14px;background-color:#FFFFFF;\">的几年都在恍惚的小学中度过了,那个时候学习没有什么压力,爸爸每天忙着赚钱。基本上也不怎么过问我的功课,但是只要我成绩下来了。就一定尝到劈头盖脸的一顿臭骂。无论他怎么忙,每天下班回家一定陪我,周末的</span><a href=\"http://www.jj59.com/zti/time/\" class=\"keywordlink\">时间</a><span style=\"color:#333333;font-family:宋体;font-size:14px;background-color:#FFFFFF;\">全是我的。所以,我放学就可以和朋友尽情玩耍。白天有同学陪,放学有爸爸陪。渐渐的也就忘却了妈妈的存在。随着时光的推移也就理解了爸爸口中的遥远是什么含义。</span><br />\r\n<span style=\"color:#333333;font-family:宋体;font-size:14px;background-color:#FFFFFF;\"> </span>', '2017-09-28 22:03:46', 56, '咯咯咯咯咯过过过', 16, 1, '[email protected];[email protected]', 20, 1, 0, 1, 0);
INSERT INTO `aoa_in_mail_list` VALUES (12, '<span style=\"color:#111111;font-family:Arial, Helvetica, sans-serif;font-size:14px;background-color:#FFFFFF;\">最近有个朋友生日,聚会上有人送了他一对精致的杯子做礼物,据说这对杯子做工质地讲究,连配图都出自绘画大师之手。然而,就在朋友得知这对杯子价格近千块的时候,他直接炸了:“不就是个盛水的东西,跟我用的十块钱的玻璃杯有什么区别?这俩杯子哪里值千多块钱啊!</span>', '2017-09-28 22:20:12', 57, '最后一次', 16, 1, '[email protected];[email protected]', 20, 1, 0, 1, 0);
INSERT INTO `aoa_in_mail_list` VALUES (13, '发发发发发发付或或或', '2017-09-29 13:57:20', NULL, '大家点击度假酒店', 16, 1, '朱丽叶;伊丽莎白', 20, NULL, 0, 1, 0);
INSERT INTO `aoa_in_mail_list` VALUES (15, '通过副本', '2017-09-29 19:53:52', NULL, '根本', 16, 2, '罗密欧', 20, NULL, 1, 1, 0);
INSERT INTO `aoa_in_mail_list` VALUES (16, '<p>\r\n 我去复制一段话来\r\n</p>\r\n<p>\r\n <span style=\"color:#404040;font-family:"font-size:18px;background-color:#FFFFFF;\">1953年秋天,27岁的赫夫纳向亲友借了8000美元,花500美元买下梦露半裸照的版权,创办了《花花公子》</span>\r\n</p>', '2017-09-29 22:09:52', 58, '我自己这边发的', 16, 1, '[email protected];[email protected]', 20, 1, 0, 1, 0);
INSERT INTO `aoa_in_mail_list` VALUES (17, '儿歌个TV登革热vgt', '2017-09-30 15:52:07', NULL, '私事客服', 16, 2, '伊丽莎白;小李父斯基', 20, NULL, 0, 1, 0);
INSERT INTO `aoa_in_mail_list` VALUES (18, '柔柔弱弱', '2017-09-30 16:24:46', NULL, '呃呃呃', 18, 2, '罗密欧', 20, NULL, 1, 1, 0);
INSERT INTO `aoa_in_mail_list` VALUES (19, '哈哈不过', '2017-09-30 17:02:22', NULL, '得到', 16, 2, '小李父斯基', 21, NULL, 0, 1, 1);
INSERT INTO `aoa_in_mail_list` VALUES (20, '闺女胡', '2017-09-30 17:04:19', NULL, '嘉年华', 16, 2, '朱丽叶', 22, NULL, 0, 1, 0);
INSERT INTO `aoa_in_mail_list` VALUES (21, '房地产和好', '2017-09-30 17:26:05', NULL, '办法VSX', 16, 2, '朱丽叶', 20, NULL, 1, 1, 0);
INSERT INTO `aoa_in_mail_list` VALUES (22, '还好吧GV', '2017-09-30 21:01:57', NULL, '密密麻麻', 16, 2, NULL, 20, NULL, 0, 0, 1);
INSERT INTO `aoa_in_mail_list` VALUES (23, '发v', '2017-10-01 12:46:44', 59, '信息', 16, 2, '罗密欧;朱丽叶', 20, NULL, 0, 1, 0);
INSERT INTO `aoa_in_mail_list` VALUES (24, '得出', '2017-10-01 12:47:15', NULL, '就你那', 17, 2, '朱丽叶;伊丽莎白', 22, NULL, 0, 1, 0);
INSERT INTO `aoa_in_mail_list` VALUES (25, '反复发热的是v车<br />\r\n<hr />\r\n调查色粉', '2017-10-01 16:59:41', NULL, '【回复】发v显示', 16, 1, '朱丽叶;罗密欧', 20, NULL, 0, 1, 0);
INSERT INTO `aoa_in_mail_list` VALUES (26, '湖不过均', '2017-10-01 12:48:07', NULL, '客家话', 16, 2, '朱丽叶;伊丽莎白', 20, NULL, 0, 1, 0);
INSERT INTO `aoa_in_mail_list` VALUES (27, '护肤措施', '2017-10-01 12:48:25', NULL, '举横幅', 16, 2, '朱丽叶;伊丽莎白', 20, NULL, 0, 1, 0);
INSERT INTO `aoa_in_mail_list` VALUES (28, '高铁都不', '2017-10-01 12:48:46', NULL, '好一点v', 16, 2, '小李父斯基;soli;红之花', 20, NULL, 0, 1, 0);
INSERT INTO `aoa_in_mail_list` VALUES (29, '谷朊粉', '2017-10-01 12:49:10', NULL, '共同市场', 16, 2, '伊丽莎白;soli', 20, NULL, 0, 1, 0);
INSERT INTO `aoa_in_mail_list` VALUES (30, '柔肤水过一遍', '2017-10-01 12:49:33', NULL, '枯黄的', 16, 2, '朱丽叶;伊丽莎白;soli;红之花', 20, NULL, 0, 1, 0);
INSERT INTO `aoa_in_mail_list` VALUES (32, '包含', '2017-10-01 14:36:12', NULL, '包含', 18, 1, '朱丽叶;伊丽莎白', 22, NULL, 0, 1, 0);
INSERT INTO `aoa_in_mail_list` VALUES (33, '<p style=\"color:#434343;font-size:16px;text-indent:2em;font-family:Helvetica, Arial, sans-serif;background-color:#FFFFFF;\">\r\n 八月的夜空,月色清明,云彩轻扬;八月的芳草地,花香迷朦,一池秋水清浅温婉。在花开花谢的流转里,时光坐在月色背后,冷艳如初。\r\n</p>\r\n<p style=\"color:#434343;font-size:16px;text-indent:2em;font-family:Helvetica, Arial, sans-serif;background-color:#FFFFFF;\">\r\n ——题记\r\n</p>\r\n<p style=\"color:#434343;font-size:16px;text-indent:2em;font-family:Helvetica, Arial, sans-serif;background-color:#FFFFFF;\">\r\n 月光开始沉醉,起初,只是一抹淡淡的凝脂色,夜色宁静,慢慢明亮,圆润。像极了伊宁静盈暖的眼眸。七夕刚过,夜带着神秘的气息,薄薄的云彩,清透含蓄。抬头寻找,记忆中的渺渺银河,偌大的天宇,两三点星光,若隐若无,温柔的隔海相望。\r\n</p>\r\n<p style=\"color:#434343;font-size:16px;text-indent:2em;font-family:Helvetica, Arial, sans-serif;background-color:#FFFFFF;\">\r\n 月光总是太美,让人遐想,让人怜爱。夏天的花影,次第流转,清风明月思年华,而爱情总是太美,遥远如星空,茫茫人间,有烟火色便为红尘,遇见,爱上,一生何求?\r\n</p>\r\n<p style=\"color:#434343;font-size:16px;text-indent:2em;font-family:Helvetica, Arial, sans-serif;background-color:#FFFFFF;\">\r\n 如果可以,有一片海可以穿越爱的极限,我愿意,与你一同前往。\r\n</p>\r\n<p style=\"color:#434343;font-size:16px;text-indent:2em;font-family:Helvetica, Arial, sans-serif;background-color:#FFFFFF;\">\r\n 轻拨心灵的琴弦,远处,是否有伊在轻轻和奏?\r\n</p>\r\n<p style=\"color:#434343;font-size:16px;text-indent:2em;font-family:Helvetica, Arial, sans-serif;background-color:#FFFFFF;\">\r\n <img src=\"https://www.yueduwen.com/uploads/allimg/c1408/140920921250-H521.jpg\" /><span class=\"yueduwencom\">(<a href=\"http://www.yueduwen.com/\">悦读文网</a> www.yueduwen.com)</span>\r\n</p>\r\n<p style=\"color:#434343;font-size:16px;text-indent:2em;font-family:Helvetica, Arial, sans-serif;background-color:#FFFFFF;\">\r\n 爱是感动,爱是相守,爱是牵挂,爱是月光里最美的诗行。我知道,有一片天空,始终有我的等待,那是你的方向。只是,天涯咫尺,我只能执手泪眼问相思。\r\n</p>\r\n<p style=\"color:#434343;font-size:16px;text-indent:2em;font-family:Helvetica, Arial, sans-serif;background-color:#FFFFFF;\">\r\n 用心把远方托付给远方,把故事深藏在星光深处。那些苦涩的回忆不是忧伤,那甜美的记忆已成芬芳,是我幸福的奢华,余有暗香。\r\n</p>\r\n<p style=\"color:#434343;font-size:16px;text-indent:2em;font-family:Helvetica, Arial, sans-serif;background-color:#FFFFFF;\">\r\n 恬淡,遥远。像今夜的月亮。\r\n</p>\r\n<p style=\"color:#434343;font-size:16px;text-indent:2em;font-family:Helvetica, Arial, sans-serif;background-color:#FFFFFF;\">\r\n 我还站在昨天的月光里,用心轻吻一朵月色下的玫瑰。\r\n</p>\r\n<p style=\"color:#434343;font-size:16px;text-indent:2em;font-family:Helvetica, Arial, sans-serif;background-color:#FFFFFF;\">\r\n 今夜的月光是行走的思念,静静与我,相守。\r\n</p>\r\n<p style=\"color:#434343;font-size:16px;text-indent:2em;font-family:Helvetica, Arial, sans-serif;background-color:#FFFFFF;\">\r\n 内心,一半是海水的潮湿,一半是火焰的炽热。守在月色下,开始朝着你的方向一路飞奔,把爱放在温热的掌心,一路小心的呵护,担心遗落在风雨中。\r\n</p>\r\n<p style=\"color:#434343;font-size:16px;text-indent:2em;font-family:Helvetica, Arial, sans-serif;background-color:#FFFFFF;\">\r\n 月下的人间,盛开一条河流,我坐在河对岸,静静祈祷,相思过去,一切如旧,不曾挑明,只是以一种形式的相守,坚守你我的这份爱。\r\n</p>\r\n<p style=\"color:#434343;font-size:16px;text-indent:2em;font-family:Helvetica, Arial, sans-serif;background-color:#FFFFFF;\">\r\n 就像今晚的月亮,这么明亮,这么清澈,是你么,带着温暖的耳语,仿佛遥远,又近在咫尺。\r\n</p>', '2017-10-01 15:21:25', NULL, '的放入他', 16, 1, '朱丽叶', 20, NULL, 0, 1, 0);
INSERT INTO `aoa_in_mail_list` VALUES (34, '发发发通天塔<br />\r\n<hr />\r\n反复发热的是v车<br />\r\n<hr />\r\n调查色粉', '2017-10-01 17:16:14', NULL, '【回复】【回复】发v显示', 16, 1, '朱丽叶', 20, NULL, 0, 1, 0);
INSERT INTO `aoa_in_mail_list` VALUES (35, '给你<br />\r\n<hr />\r\n发v', '2017-10-01 17:24:15', NULL, '【转发】信息', 16, 1, '朱丽叶', 20, NULL, 0, 1, 0);
INSERT INTO `aoa_in_mail_list` VALUES (37, '<table width=\"100%\" style=\"padding:0px;margin:0px;color:#333333;font-family:Helvetica, Arial, sans-serif;font-size:16px;background-color:#FFFFFF;\">\r\n <tbody>\r\n <tr>\r\n <td>\r\n <div id=\"contentMidPicAD\" style=\"padding:0px;margin:0px;vertical-align:top;\">\r\n </div>\r\n <p style=\"color:#434343;font-size:16px;text-indent:2em;\">\r\n <img alt=\"唯美图片爱情\" src=\"https://www.yueduwen.com/uploads/allimg/1702/1-1F226213T1602.jpg\" />\r\n </p>\r\n <p style=\"color:#434343;font-size:16px;text-indent:2em;\">\r\n 太过用力,会纠缠于内心,会让所有的饱满太过张力,是一张拉满了的弓,射得一定远吗?怕是会断掉。\r\n </p>\r\n <p style=\"color:#434343;font-size:16px;text-indent:2em;\">\r\n 一场情事,泼墨太多了,用力太猛了,自己都收不住。洪水泛滥的结果是将自己淹没了。\r\n </p>\r\n <p style=\"color:#434343;font-size:16px;text-indent:2em;\">\r\n 也许好的爱情应该是云淡风轻,安静地看着对方,对方是自己的一块清新的糖,想起时,安静地抿一下,就够了,有的时候,爱情需要距离,需要空间。\r\n </p>\r\n <p style=\"color:#434343;font-size:16px;text-indent:2em;\">\r\n 爱上一个人,总会动荡些时日,半夜跑去写情书,私情这东西总怕沉溺。但不沉溺又是错的。\r\n </p>\r\n <p style=\"color:#434343;font-size:16px;text-indent:2em;\">\r\n 爱这个人,哪怕知道他坏他烂,可是,因为贪恋这人世间的一点点爱一点点温暖,便飞蛾一样,扑向了火。这一场盛宴,是一个人的盛宴,与现实的爱情如此格格不入,不温暖,不体贴,不妥当,带着罂粟的邪恶与放荡——但她一意孤行,一定要一意孤行。\r\n </p>\r\n <p style=\"color:#434343;font-size:16px;text-indent:2em;\">\r\n 最坚固的爱情是懂得一个人的灵魂与心,就像杨绛懂得钱钟书,这种懂得,似读一本值得读的好书,读一生,也不会倦。而他们的用力,是持续的温度,是持续的力度,一直是这样,不高,不低,不温,不火。<span class=\"yueduwencom\">(<a href=\"http://www.yueduwen.com/\">悦读文网</a> www.yueduwen.com)</span>\r\n </p>\r\n <p style=\"color:#434343;font-size:16px;text-indent:2em;\">\r\n 用力地爱一个人,趁着还有一颗爱的心,其实是幸福——哪怕最后碎了灭了,而心里,永远会有这个人,永远会有。\r\n </p>\r\n <p style=\"color:#434343;font-size:16px;text-indent:2em;\">\r\n 女人总对事物有所迷恋,而迷人比迷东西更诱人。大体说来,一是迷恋衣服,二是迷恋男人。衣服和男人同时到来,则男人第一。\r\n </p>\r\n <p style=\"color:#434343;font-size:16px;text-indent:2em;\">\r\n 爱情是最不实用的东西,伤筋动骨的,不如迷恋别的东西实惠。迷恋这个东西,带着痴的成分,爱情这个东西,当个点缀时还好,可是,一用力起来就会盛大,又惊心动魄又无聊。\r\n </p>\r\n <p style=\"color:#434343;font-size:16px;text-indent:2em;\">\r\n 太浓烈的爱情,来得快,一定去得也快。\r\n </p>\r\n <p style=\"color:#434343;font-size:16px;text-indent:2em;\">\r\n 爱情原来是有条件的,原来是和别的气氛在一起的——特别是人前,如果感觉到他们在相爱,一个眼神就足够了。\r\n </p>\r\n <p style=\"color:#434343;font-size:16px;text-indent:2em;\">\r\n 最干净的爱情,一定清淡似水,应该浓烈时浓烈,应该清淡时就清淡。\r\n </p>\r\n <p style=\"color:#434343;font-size:16px;text-indent:2em;\">\r\n 只剩下爱情,一定离分手很近了,因为再也没有别的话——有趣的爱情,是和趣味、气味、气场相互联系的,比如两个人的共同爱好,哪怕一起爱上美食,其实最后拼的是生活习惯和灵魂距离。如果单纯色相吸引,爱情最难维持,时间最短的爱情一定是一见钟情——只凭貌相,那样的爱情过于单薄,连维持下去都要努力。\r\n </p>\r\n <p style=\"color:#434343;font-size:16px;text-indent:2em;\">\r\n 最厚实的爱情,一定是踏实肯定,连缺点也要喜欢,连习惯都雷同,爱到忘记了爱是怎么回事,只记得他爱吃茴香馅,她爱穿安瑞井……如果只是为爱而爱,哪怕私奔到天涯,一定还要离散。\r\n </p>\r\n <p style=\"color:#434343;font-size:16px;text-indent:2em;\">\r\n 爱一个人,需要傻到没有自己,和爱情相比,自己太轻了,太单了,太势孤了,而只有爱情,可以让人焕发了光彩,那样的熠熠夺目,是自己没有过的样子。就像张中行老先生说,还是男女之情最有意思。因为像鸦片,有瘾,有毒,离不了,忘不了,相互吸引,又相互刺痛。\r\n </p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n</table>', '2017-10-01 19:39:14', 60, '来了', 16, 1, '[email protected];[email protected]', 20, 1, 0, 1, 0);
INSERT INTO `aoa_in_mail_list` VALUES (42, '咕咕咕咕拖拖拖拖多多多多多', '2017-10-01 20:29:51', NULL, '点点滴滴', 16, 1, '[email protected]', 20, 1, 0, 1, 0);
INSERT INTO `aoa_in_mail_list` VALUES (43, '麻烦得很', '2017-10-02 14:49:56', 61, '给你给你', 16, 1, '[email protected]', 20, 1, 0, 1, 0);
INSERT INTO `aoa_in_mail_list` VALUES (44, '<p style=\"color:#434343;font-size:16px;text-indent:2em;font-family:Helvetica, Arial, sans-serif;background-color:#FFFFFF;\">\r\n 在一档电视节目中,主持人问马云,如果人生可以重来,你有什么遗憾需要弥补?马云淡淡地说,我的人生一切都刚刚好。\r\n</p>\r\n<p style=\"color:#434343;font-size:16px;text-indent:2em;font-family:Helvetica, Arial, sans-serif;background-color:#FFFFFF;\">\r\n 这样的回答,可以说是自信,因为一切都恰到好处;也可以说是知足,因为没有留下遗憾。\r\n</p>\r\n<p style=\"color:#434343;font-size:16px;text-indent:2em;font-family:Helvetica, Arial, sans-serif;background-color:#FFFFFF;\">\r\n 一切都刚刚好,这话说出来简单,做起来却大不易。什么叫刚刚好,理性一点说就是适度。什么叫度,理科老师告诉你,度就是一定事物保持自己质的数量界限,比如说冰点、熔点、沸点;文科老师告诉你,度就是事物所达到的境界,比如说高度、风度、气度。在《登徒子好色赋》中,宋玉用两个排比句,来描述东邻女孩的美貌:增之一分则太长,减之一分则太短;着粉则太白,施朱则太赤。这话听起来有些夸张,其实不过是说这个女孩长得恰如其分,刚刚好。\r\n</p>\r\n<p style=\"color:#434343;font-size:16px;text-indent:2em;font-family:Helvetica, Arial, sans-serif;background-color:#FFFFFF;\">\r\n 世间一切事物,都是由过程表现出来的,这个过程无非是由量变到质变,由渐变到突变。变与不变的节点就是度。作为人生哲学的度,则是指在做人处世中拿捏的分寸,掌握的火候,遵循的法则。这种度,不是衡器测量出来的,而是用心掂量出来的。\r\n</p>\r\n<p style=\"color:#434343;font-size:16px;text-indent:2em;font-family:Helvetica, Arial, sans-serif;background-color:#FFFFFF;\">\r\n 古代圣贤留给我们的人生智慧和哲理很多,以至于穷其一生也未必都能学完、用好,但若看多了、悟透了,就会觉得,大道至简,道法自然,归根结底不过两个字:适度。就是说,凡事有度,适可而止,过犹不及,物极必反。即便是优点,过了头也会坏事;即便是美德,过了头也会显得不美;只有恰到好处,才会趋于完美。\r\n</p>\r\n<p style=\"color:#434343;font-size:16px;text-indent:2em;font-family:Helvetica, Arial, sans-serif;background-color:#FFFFFF;\">\r\n 比方说,性情耿直的人心直口快是优点,倘若不注意场合与对象,出言不逊,出口伤人,就会让人讨厌。蔡明表演的以“毒舌”为语言特征的小品,为什么会一再登上央视春晚舞台,并非人们喜欢“毒舌”,而是因为她塑造的“毒舌”,形象惟妙惟肖,语言尖酸刻薄,对缺乏口德者的讽刺力度入木三分,从而使人们在爆笑的同时,更加讨厌“毒舌”,远离“毒舌”,也能让那些以“刀子嘴豆腐心”自诩的人反观自照,明心见性,在社会交往中不再以“毒舌”相向。即便以“毒舌”显示幽默,也要看对方的接受能力,顾及他人的尊严。\r\n</p>', '2017-10-02 14:55:07', NULL, '多对多多对多多', 16, 1, '[email protected]', 20, 1, 0, 1, 0);
INSERT INTO `aoa_in_mail_list` VALUES (45, '<table width=\"100%\" style=\"padding:0px;margin:0px;color:#333333;font-family:Helvetica, Arial, sans-serif;font-size:16px;background-color:#FFFFFF;\">\r\n <tbody>\r\n <tr>\r\n <td>\r\n <div id=\"contentMidPicAD\" style=\"padding:0px;margin:0px;vertical-align:top;\">\r\n </div>\r\n<img alt=\"\" height=\"441\" src=\"http://www.yueduwen.com/uploads/allimg/c170225/14X01CI261Z-1131J.jpg\" width=\"590\" />\r\n <p style=\"color:#434343;font-size:16px;text-indent:2em;\">\r\n 他一岁的时候,父亲被打成右派,被送进江西某农场劳动改造。他的母亲是一名小学教师,因为身边还带着大他一岁的哥哥,母亲自知没有多余的精力把他拉扯成人。就在一个雨夜,母亲怀抱着他,把他托付给原来的老邻居,即他日后经常挂在嘴边的张公张婆。\r\n </p>\r\n <p style=\"color:#434343;font-size:16px;text-indent:2em;\">\r\n 张公是安徽人,人长得高大,心地善良,日本侵华时,他挑着担子,逃难来到湖南沅陵麻溪铺。张公的左脚就是在逃难时被日本飞机丢响的炸弹震坏的,因此,走起路来,一颠一颠的。保姆婆是从凤凰逃难到本地,当年她只有十五岁。两位苦难的人在异乡相依为命,他们一生没有生育。\r\n </p>\r\n <p style=\"color:#434343;font-size:16px;text-indent:2em;\">\r\n 在麻溪铺镇上,临着街,张公和张婆拥有一间不大的屋子,那屋子由裱有报纸的隔板分成两小间。靠外的一间,是现代意义上的客厅。中间有一个火塘,火塘上有一个木架,常年挂着几排黑乎乎的东西,那是当地人喜欢的腊肉。在隆冬季节,大雪封山的日子,张婆会切下一段腊肉,把肉皮在炭火上烧烤。几分钟,洗出来之后,黑色的肉皮就变成黄金糕的颜色了。腊肉的香味极具诱惑。\r\n </p>\r\n <p style=\"color:#434343;font-size:16px;text-indent:2em;\">\r\n 靠里那一间,他和张公张婆挤在一张木板床上,怕他半夜摔下来,老人让他睡在中间。那屋子下雨时漏雨,刮风时透风。于是,张公就在屋顶扯起一块塑料布。每逢下雨,瓦缝的水有节奏地滴进塑料布里,发出嗒—嗒—嗒—的声音。南方雨水多,那嗒嗒嗒的雨声就成了他的催眠曲。为了防止泥巴地发潮,张公张婆在那木板床的下面,塞满了黑乎乎的木炭,果木的清香残留在木炭的骨子里,伴着他一天天长大成人。\r\n </p>\r\n <p style=\"color:#434343;font-size:16px;text-indent:2em;\">\r\n 转眼,他六岁了,到了读书的时候。有一天,张公拿过他削得尖尖的铅笔说,崽呀,这铅笔你若削尖了,一用力就断了,很浪费。张公示范着说,铅笔只要用菜刀把木头削掉,露出铅笔芯就可以写字了,这样既节省又不易折断。他一直按照张公的办法去做,以至于现在不仅能写得一手好字,关键是字粗而且大,极易辨认。在每一个小鸟啼叫的早晨和炊烟袅袅的黄昏,像吊死鬼儿一样贴在他屁股上的黄色书包里,除了几本卷了角的书本,就是一支秃头秃脑的铅笔。\r\n </p>\r\n <p style=\"color:#434343;font-size:16px;text-indent:2em;\">\r\n 张婆做得一手好菜。当他还没有灶台高的时候,张婆搬来一个高脚竹椅子摆在灶台边,把他抱上去,他就趴在灶台上,看张婆怎样炒菜,怎样放佐料。他打小就明白了切菜的刀功极为重要,也懂得炒菜的时候哪些应该盖锅盖,哪些菜是不需要盖锅盖的。在每一道菜出锅的时候,他记得张婆都会用洁白的抹布在碗口边缘擦一圈,残留的痕迹便不复存在了。张婆常说,孔夫子不吃豆腐,吃东西讲究色香味,讲究刀法,老祖宗留下的够我们一辈子去学。\r\n </p>\r\n <p style=\"color:#434343;font-size:16px;text-indent:2em;\">\r\n 如今,他做饭做得可口,全家人都跟着他享口福。看到全家老小一脸享受地吃着他做的饭菜,他一脸的幸福。他夹一口菜,刨一口饭,敲一下碗边儿,嗯,可以,可以,这味道可以。<span class=\"yueduwencom\">(<a href=\"http://www.yueduwen.com/\">悦读文网</a> www.yueduwen.com)</span>\r\n </p>\r\n <p style=\"color:#434343;font-size:16px;text-indent:2em;\">\r\n 距离张公张婆的屋不远,有一所女子中学,张公是那学校的校工。当时的学校,没有电铃,上课下课,都是靠敲钟。张公就是那敲钟的人。钟也不是什么好材料做的,是一个长锈的铁环,用麻绳系着,挂在一根房梁上面。\r\n </p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n</table>', '2017-10-06 11:02:49', 62, '最后一试', 16, 1, '[email protected]', 20, 1, 0, 1, 0);
INSERT INTO `aoa_in_mail_list` VALUES (46, '<p style=\"color:#434343;font-size:16px;text-indent:2em;font-family:Helvetica, Arial, sans-serif;background-color:#FFFFFF;\">\r\n <img alt=\"\" src=\"https://www.yueduwen.com/uploads/allimg/1705/1-1F520161G2E9.jpg\" /><img src=\"https://www.yueduwen.com/uploads/allimg/1705/1-1F520161G2E9.jpg\" />\r\n</p>\r\n<p style=\"color:#434343;font-size:16px;text-indent:2em;font-family:Helvetica, Arial, sans-serif;background-color:#FFFFFF;\">\r\n 去岁盛夏返乡,时近黄昏,禽鸟归巢,晚风吹拂,我独自漫步在房前不远处的三米宽的水泥质地镶有不锈钢围栏的小桥上。桥下流水潺潺,清澈见底。举目四望,满眼青翠,一片碧绿:周围稻田碧浪翻滚,稻穗飘香;稍远处玉米吐穗,绿叶婆娑;远处青山含黛,松柏飘香。白练似的水泥小路盘旋乡间逶迤远方,随之一同飘去的还有我的一片思绪。\r\n</p>\r\n<p style=\"color:#434343;font-size:16px;text-indent:2em;font-family:Helvetica, Arial, sans-serif;background-color:#FFFFFF;\">\r\n 小时候,穿过一条狭窄蜿蜒的田埂来到小河边,就见一座木石结构的小桥横跨河上。小桥宽约两米,长有丈余,全桥由三根直径约二十公分的柏树为基底,上以质地坚硬的青石板严密覆盖,下有两根柏木立柱在河中支撑。我们村两个组的近三百群众都要通过该桥来往,去到对岸的碎石公路,走向远方。印象中,小桥从我记事起就一直存在,它是我们对外联系的纽带。尽管它外形单调,结构简单,却十分坚固,即使人们牵着体型硕大的黑水牛从上面悠然走过也安然无恙,而且还经受住了几次巨大洪水冲击的考验呢。\r\n</p>\r\n<p style=\"color:#434343;font-size:16px;text-indent:2em;font-family:Helvetica, Arial, sans-serif;background-color:#FFFFFF;\">\r\n 童年的夏天,好像比现在还要炎热许多,蝉也叫得特别响亮,我和小伙伴们常在桥下游泳,河中嬉戏。有时仰头看着小桥,感觉它无比高大雄伟。如果有人敢站在桥上做出各种姿势往下跳水,常会赢得孩子们的无比羡慕和大声喝彩。\r\n</p>\r\n<p style=\"color:#434343;font-size:16px;text-indent:2em;font-family:Helvetica, Arial, sans-serif;background-color:#FFFFFF;\">\r\n 小桥也是通向对岸外婆家的唯一大道,傍晚回家,外婆家的大黄狗必要送我回来。让我百思不得其解的是,大黄狗每次都是把我送到小桥边就默默离去了,从来不越雷池半步,好像它对桥心存敬畏,很放心把我交给小桥似的。\r\n</p>\r\n<p style=\"color:#434343;font-size:16px;text-indent:2em;font-family:Helvetica, Arial, sans-serif;background-color:#FFFFFF;\">\r\n 遗憾的是,我长大成年了,小桥却衰老了。年久失修,上面的青石板风化掉落得厉害,最后只剩下三根孤零零的朽木了,大人们在上面还能如履平地,年幼的孩子们就惨了,很多只能在上面缓缓爬行,战战兢兢,如履薄冰。又过了一年,小桥的通过能力几乎完全丧失,大人们也早将关注的重点转移到了农作上,忙于打理自家的承包地。再加上雨水连年减少,河床干涸见底,河底裂纹密布,人们下河底爬河堤也不甚费力,小桥就渐渐被人们遗忘了,最后就连几根枯朽的柏木也不见踪影,可能是被村民扛回去作柴禾了吧。河水充盈时,人们往往行走于集体夯筑的土堰上,但不得不面对土堰随时崩塌的危险。\r\n</p>\r\n<p style=\"color:#434343;font-size:16px;text-indent:2em;font-family:Helvetica, Arial, sans-serif;background-color:#FFFFFF;\">\r\n 一年夏天,暴发了三十年未遇的特大洪水。顷刻间,一切堤堰土崩瓦解,想要出行十分困难,况且还有许多农产品要运出去许多农资要运进来呢。人们这才认识到架座小桥的必要性,于是乎发动群众,有钱出钱,有力出力,准备建一座有两个桥墩的水泥板桥。<span class=\"yueduwencom\">(<a href=\"http://www.yueduwen.com/\">悦读文网</a> www.yueduwen.com)</span>\r\n</p>\r\n<p style=\"color:#434343;font-size:16px;text-indent:2em;font-family:Helvetica, Arial, sans-serif;background-color:#FFFFFF;\">\r\n 乡民的本性始终是淳朴良善的,认为修桥补路是积德行善,都踊跃出钱出力,很快前期准备就完成了。修桥由经验丰富的老石匠亲自掌墨,开始挖基脚,抬石头,拌水泥,砌桥墩,搭桥板。老石匠认为这可能是自己人生最后一件大作品,认真到了严苛的程度,所谓慢工出细活,这桥修了近半年之久。看到这座新落成的水泥板桥,听到人们的啧啧称赞,老石匠就好像看着自己的刚出生的孩子,高兴得裂开干瘪的嘴唇,嘿嘿地笑出声来。\r\n</p>\r\n<p style=\"color:#434343;font-size:16px;text-indent:2em;font-family:Helvetica, Arial, sans-serif;background-color:#FFFFFF;\">\r\n 这一下,新桥很快就成了人们聚集谈天的场所。盛夏的夜晚,在桥上休憩纳凉的人语声久久不绝,争相述说着生活的美好;严冬的中午,沐浴暖阳的人笑声不断,竞相谈论着故乡的变迁。\r\n</p>\r\n<p style=\"color:#434343;font-size:16px;text-indent:2em;font-family:Helvetica, Arial, sans-serif;background-color:#FFFFFF;\">\r\n 后来,村民个人集资,再加上国家补贴,开始将小桥两边安上不锈钢栏杆,并将穿过小桥两边的乡间小道拓宽硬化,通到家家户户,大大方便了人们出行。远在他乡多年未归的游子也纷纷驾车返乡,当漂亮舒适的轿车轻吻小桥时,他们说分明听到了小桥的咯咯笑声,好像是独自在家的慈母在热烈欢迎久别孩子的归来。\r\n</p>\r\n<p style=\"color:#434343;font-size:16px;text-indent:2em;font-family:Helvetica, Arial, sans-serif;background-color:#FFFFFF;\">\r\n 突然“滴——滴——”声起,将我的思绪拉回眼前,原来是阔别多年的儿时好友晓敏在打招呼。我俩就在桥头攀谈起来,诉说着各自的生活和家乡的美好。\r\n</p>\r\n<p style=\"color:#434343;font-size:16px;text-indent:2em;font-family:Helvetica, Arial, sans-serif;background-color:#FFFFFF;\">\r\n 此时,夜色渐浓,小桥无语。是啊,故乡的小桥不仅见证了家乡由贫穷到富裕的发展变化,见证了家乡人们从奔波到闲适的生活,也必将见证家乡不可限量的辉煌未来。\r\n</p>', '2017-10-07 21:51:26', NULL, 'ssss', 16, 1, '[email protected]', 20, 1, 0, 1, 0);
INSERT INTO `aoa_in_mail_list` VALUES (47, '发发发发发发付付付', '2017-10-16 17:17:51', 69, '啛啛喳喳', 16, 18, '甄嬛;无双', 20, NULL, 0, 1, 0);
INSERT INTO `aoa_in_mail_list` VALUES (48, '多对多', '2017-10-16 17:42:16', 70, '多对多', 16, 1, '无双', 20, NULL, 0, 1, 0);
INSERT INTO `aoa_in_mail_list` VALUES (49, '少时诵诗书所所所所所', '2017-10-18 17:45:16', 72, '少时诵诗书', 16, 1, '[email protected]', 20, 1, 0, 1, 0);
COMMIT;
-- ----------------------------
-- Table structure for aoa_love_discuss_user
-- ----------------------------
DROP TABLE IF EXISTS `aoa_love_discuss_user`;
CREATE TABLE `aoa_love_discuss_user` (
`discuss_id` bigint(20) NOT NULL,
`user_id` bigint(20) NOT NULL,
PRIMARY KEY (`discuss_id`,`user_id`),
KEY `FKkl0fitgg3qixkg5gg9mmjp5e7` (`user_id`),
CONSTRAINT `FKkl0fitgg3qixkg5gg9mmjp5e7` FOREIGN KEY (`user_id`) REFERENCES `aoa_user` (`user_id`),
CONSTRAINT `FKnhdtxclyun4is9ne5o99nqw1c` FOREIGN KEY (`discuss_id`) REFERENCES `aoa_discuss_list` (`discuss_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of aoa_love_discuss_user
-- ----------------------------
BEGIN;
INSERT INTO `aoa_love_discuss_user` VALUES (8, 1);
INSERT INTO `aoa_love_discuss_user` VALUES (12, 1);
INSERT INTO `aoa_love_discuss_user` VALUES (15, 1);
INSERT INTO `aoa_love_discuss_user` VALUES (33, 1);
INSERT INTO `aoa_love_discuss_user` VALUES (7, 2);
INSERT INTO `aoa_love_discuss_user` VALUES (12, 2);
INSERT INTO `aoa_love_discuss_user` VALUES (13, 2);
INSERT INTO `aoa_love_discuss_user` VALUES (33, 2);
INSERT INTO `aoa_love_discuss_user` VALUES (37, 2);
INSERT INTO `aoa_love_discuss_user` VALUES (38, 2);
INSERT INTO `aoa_love_discuss_user` VALUES (39, 2);
INSERT INTO `aoa_love_discuss_user` VALUES (33, 3);
INSERT INTO `aoa_love_discuss_user` VALUES (33, 7);
INSERT INTO `aoa_love_discuss_user` VALUES (13, 8);
COMMIT;
-- ----------------------------
-- Table structure for aoa_love_user
-- ----------------------------
DROP TABLE IF EXISTS `aoa_love_user`;
CREATE TABLE `aoa_love_user` (
`reply_id` bigint(20) NOT NULL,
`user_id` bigint(20) NOT NULL,
KEY `FK7fv96y8gbqcnb44qao4ey4rmn` (`user_id`),
KEY `FKcuptpmm0l1e0b9pjv0xksqqai` (`reply_id`),
CONSTRAINT `FK7fv96y8gbqcnb44qao4ey4rmn` FOREIGN KEY (`user_id`) REFERENCES `aoa_user` (`user_id`),
CONSTRAINT `FKcuptpmm0l1e0b9pjv0xksqqai` FOREIGN KEY (`reply_id`) REFERENCES `aoa_reply_list` (`reply_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of aoa_love_user
-- ----------------------------
BEGIN;
INSERT INTO `aoa_love_user` VALUES (7, 2);
INSERT INTO `aoa_love_user` VALUES (9, 2);
INSERT INTO `aoa_love_user` VALUES (6, 1);
INSERT INTO `aoa_love_user` VALUES (3, 1);
INSERT INTO `aoa_love_user` VALUES (2, 1);
INSERT INTO `aoa_love_user` VALUES (9, 1);
INSERT INTO `aoa_love_user` VALUES (16, 1);
INSERT INTO `aoa_love_user` VALUES (15, 1);
INSERT INTO `aoa_love_user` VALUES (14, 1);
INSERT INTO `aoa_love_user` VALUES (17, 1);
INSERT INTO `aoa_love_user` VALUES (18, 1);
INSERT INTO `aoa_love_user` VALUES (62, 2);
INSERT INTO `aoa_love_user` VALUES (61, 2);
INSERT INTO `aoa_love_user` VALUES (67, 2);
INSERT INTO `aoa_love_user` VALUES (4, 2);
INSERT INTO `aoa_love_user` VALUES (2, 2);
INSERT INTO `aoa_love_user` VALUES (2, 2);
INSERT INTO `aoa_love_user` VALUES (3, 2);
INSERT INTO `aoa_love_user` VALUES (3, 2);
INSERT INTO `aoa_love_user` VALUES (60, 2);
INSERT INTO `aoa_love_user` VALUES (68, 2);
INSERT INTO `aoa_love_user` VALUES (69, 2);
INSERT INTO `aoa_love_user` VALUES (72, 2);
INSERT INTO `aoa_love_user` VALUES (72, 2);
INSERT INTO `aoa_love_user` VALUES (73, 2);
INSERT INTO `aoa_love_user` VALUES (73, 2);
INSERT INTO `aoa_love_user` VALUES (59, 2);
INSERT INTO `aoa_love_user` VALUES (59, 2);
INSERT INTO `aoa_love_user` VALUES (59, 2);
INSERT INTO `aoa_love_user` VALUES (59, 2);
INSERT INTO `aoa_love_user` VALUES (59, 2);
INSERT INTO `aoa_love_user` VALUES (59, 2);
INSERT INTO `aoa_love_user` VALUES (84, 2);
INSERT INTO `aoa_love_user` VALUES (73, 8);
INSERT INTO `aoa_love_user` VALUES (73, 1);
COMMIT;
-- ----------------------------
-- Table structure for aoa_mail_reciver
-- ----------------------------
DROP TABLE IF EXISTS `aoa_mail_reciver`;
CREATE TABLE `aoa_mail_reciver` (
`pk_id` bigint(20) NOT NULL AUTO_INCREMENT,
`is_read` int(11) NOT NULL,
`mail_id` bigint(20) DEFAULT NULL,
`mail_reciver_id` bigint(20) DEFAULT NULL,
`is_star` int(11) DEFAULT NULL,
`is_del` int(11) DEFAULT NULL,
PRIMARY KEY (`pk_id`),
KEY `FKj8ki52vm052q6qdal2rkh2c9q` (`mail_id`),
KEY `FK65vdrbmq9hu4hrhvtw6slwxlc` (`mail_reciver_id`),
CONSTRAINT `FK65vdrbmq9hu4hrhvtw6slwxlc` FOREIGN KEY (`mail_reciver_id`) REFERENCES `aoa_user` (`user_id`),
CONSTRAINT `FKj8ki52vm052q6qdal2rkh2c9q` FOREIGN KEY (`mail_id`) REFERENCES `aoa_in_mail_list` (`mail_id`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of aoa_mail_reciver
-- ----------------------------
BEGIN;
INSERT INTO `aoa_mail_reciver` VALUES (3, 1, 5, 3, 0, 0);
INSERT INTO `aoa_mail_reciver` VALUES (5, 0, 13, 3, 0, 0);
INSERT INTO `aoa_mail_reciver` VALUES (6, 0, 15, 1, 0, 0);
INSERT INTO `aoa_mail_reciver` VALUES (7, 1, 18, 1, 0, 0);
INSERT INTO `aoa_mail_reciver` VALUES (8, 0, 19, 4, 0, 0);
INSERT INTO `aoa_mail_reciver` VALUES (10, 1, 21, 2, 1, 0);
INSERT INTO `aoa_mail_reciver` VALUES (11, 1, 23, 1, 0, 0);
INSERT INTO `aoa_mail_reciver` VALUES (12, 0, 23, 2, 0, 0);
INSERT INTO `aoa_mail_reciver` VALUES (13, 0, 24, 2, 0, 0);
INSERT INTO `aoa_mail_reciver` VALUES (14, 0, 24, 3, 0, 0);
INSERT INTO `aoa_mail_reciver` VALUES (15, 1, 25, 1, 0, 0);
INSERT INTO `aoa_mail_reciver` VALUES (16, 0, 25, 2, 0, 0);
INSERT INTO `aoa_mail_reciver` VALUES (17, 0, 25, 4, 0, 0);
INSERT INTO `aoa_mail_reciver` VALUES (18, 0, 26, 2, 0, 0);
INSERT INTO `aoa_mail_reciver` VALUES (19, 0, 26, 3, 0, 0);
INSERT INTO `aoa_mail_reciver` VALUES (20, 0, 27, 2, 0, 0);
INSERT INTO `aoa_mail_reciver` VALUES (21, 0, 27, 3, 0, 0);
INSERT INTO `aoa_mail_reciver` VALUES (22, 0, 28, 4, 0, 0);
INSERT INTO `aoa_mail_reciver` VALUES (23, 0, 28, 5, 0, 0);
INSERT INTO `aoa_mail_reciver` VALUES (24, 0, 28, 6, 0, 0);
INSERT INTO `aoa_mail_reciver` VALUES (25, 0, 29, 3, 0, 0);
INSERT INTO `aoa_mail_reciver` VALUES (26, 0, 29, 5, 0, 0);
INSERT INTO `aoa_mail_reciver` VALUES (27, 0, 30, 2, 0, 0);
INSERT INTO `aoa_mail_reciver` VALUES (28, 0, 30, 3, 0, 0);
INSERT INTO `aoa_mail_reciver` VALUES (29, 0, 30, 5, 0, 0);
INSERT INTO `aoa_mail_reciver` VALUES (30, 0, 30, 6, 0, 0);
INSERT INTO `aoa_mail_reciver` VALUES (31, 0, 32, 2, 0, 0);
INSERT INTO `aoa_mail_reciver` VALUES (32, 0, 32, 3, 0, 0);
INSERT INTO `aoa_mail_reciver` VALUES (33, 0, 33, 2, 0, 0);
INSERT INTO `aoa_mail_reciver` VALUES (36, 1, 34, 2, 0, 0);
INSERT INTO `aoa_mail_reciver` VALUES (37, 1, 35, 2, 0, 0);
INSERT INTO `aoa_mail_reciver` VALUES (38, 0, 47, 9, 0, 0);
INSERT INTO `aoa_mail_reciver` VALUES (39, 0, 47, 10, 0, 0);
INSERT INTO `aoa_mail_reciver` VALUES (40, 0, 48, 10, 0, 0);
COMMIT;
-- ----------------------------
-- Table structure for aoa_mailnumber
-- ----------------------------
DROP TABLE IF EXISTS `aoa_mailnumber`;
CREATE TABLE `aoa_mailnumber` (
`mail_number_id` bigint(20) NOT NULL AUTO_INCREMENT,
`mail_account` varchar(255) NOT NULL,
`mail_create_time` datetime DEFAULT NULL,
`mail_des` varchar(255) DEFAULT NULL,
`mail_type` bigint(20) DEFAULT NULL,
`mail_user_name` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`status` bigint(20) DEFAULT NULL,
`mail_num_user_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`mail_number_id`),
KEY `FKn9qg20uba4xn2k5m62jrcyc6c` (`mail_num_user_id`),
CONSTRAINT `FKn9qg20uba4xn2k5m62jrcyc6c` FOREIGN KEY (`mail_num_user_id`) REFERENCES `aoa_user` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of aoa_mailnumber
-- ----------------------------
BEGIN;
INSERT INTO `aoa_mailnumber` VALUES (1, '[email protected]', '2017-09-24 12:23:26', NULL, 1, '宋佳', 'scdvszfjjfrpbeaa', 1, 1);
INSERT INTO `aoa_mailnumber` VALUES (2, '[email protected]', '2017-09-13 13:29:28', NULL, 1, '李明', '123456', 2, 1);
INSERT INTO `aoa_mailnumber` VALUES (3, 'ffffff', '2017-09-22 14:02:51', NULL, 2, 'ggg', '33333', 1, 1);
INSERT INTO `aoa_mailnumber` VALUES (4, '[email protected]', '2017-09-24 18:26:31', '的点点滴滴', 1, '私事', '333', 1, 1);
INSERT INTO `aoa_mailnumber` VALUES (5, '[email protected]', '2017-09-24 18:27:26', '的点点滴滴', 1, '哈哈哈哈', '55555', 1, 1);
INSERT INTO `aoa_mailnumber` VALUES (6, '[email protected]', '2017-09-24 18:37:06', '的点点滴滴', 1, '滚滚滚', '55555', 2, 1);
INSERT INTO `aoa_mailnumber` VALUES (8, 'ggg', '2017-09-28 20:33:06', 'hhh', 1, 'llll', '11111', 1, 2);
INSERT INTO `aoa_mailnumber` VALUES (9, '[email protected]', '2017-09-25 18:45:52', '', 1, '多对多', '发vwv ', 1, 1);
INSERT INTO `aoa_mailnumber` VALUES (10, '[email protected]', '2017-09-25 18:46:22', '是是是', 1, '吗vwjrerg ', '14982', 1, 1);
INSERT INTO `aoa_mailnumber` VALUES (11, '[email protected]', '2017-09-25 18:46:53', '', 1, '点点滴滴', 'dbetet', 2, 1);
INSERT INTO `aoa_mailnumber` VALUES (12, '[email protected]', '2017-09-25 18:47:15', '', 1, '反反复复', '34455', 1, 1);
INSERT INTO `aoa_mailnumber` VALUES (13, '[email protected]', '2017-09-25 18:47:35', '', 1, '别发额', '457895780', 1, 1);
COMMIT;
-- ----------------------------
-- Table structure for aoa_note_list
-- ----------------------------
DROP TABLE IF EXISTS `aoa_note_list`;
CREATE TABLE `aoa_note_list` (
`note_id` bigint(20) NOT NULL AUTO_INCREMENT,
`content` varchar(15000) DEFAULT NULL,
`create_time` datetime DEFAULT NULL,
`status_id` bigint(20) DEFAULT NULL,
`title` varchar(255) DEFAULT NULL,
`type_id` bigint(20) DEFAULT NULL,
`catalog_id` bigint(20) DEFAULT NULL,
`attach_id` bigint(20) DEFAULT NULL,
`is_collected` bigint(20) DEFAULT '0',
`createman_id` bigint(20) DEFAULT NULL,
`receiver` varchar(255) DEFAULT NULL,
PRIMARY KEY (`note_id`),
KEY `FK3e1rxyyg851r231ln3ucnrg7q` (`catalog_id`),
CONSTRAINT `FK3e1rxyyg851r231ln3ucnrg7q` FOREIGN KEY (`catalog_id`) REFERENCES `aoa_catalog` (`catalog_id`)
) ENGINE=InnoDB AUTO_INCREMENT=210 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of aoa_note_list
-- ----------------------------
BEGIN;
INSERT INTO `aoa_note_list` VALUES (1, 'sdfa', '2017-09-08 20:43:08', 8, 'hg', 6, 1, 46, 1, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (90, 'zxc', '2017-09-07 19:12:07', 8, '90', 6, 2, 3, 1, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (93, 'dfasf', '2017-09-14 10:04:34', 9, '93', 6, 1, 3, 1, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (96, '哈哈', '2017-09-15 11:01:08', 8, '这张图片必须显示96', 5, 1, 6, 0, 2, NULL);
INSERT INTO `aoa_note_list` VALUES (101, '分享应该可以了吧', '2017-09-15 20:11:23', 8, '666101', 7, 1, 10, 1, 2, NULL);
INSERT INTO `aoa_note_list` VALUES (102, '快点老兄', '2017-09-15 20:14:51', 8, '666102', 7, 1, 11, 0, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (111, '的说法', '2017-09-15 23:53:04', 8, '地方撒111', 7, 1, 7, 0, 1, '小李父斯基');
INSERT INTO `aoa_note_list` VALUES (120, 'dsaf', '2017-09-18 11:04:48', 8, 'werq 120', 5, 1, 9, 1, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (122, 'dsaf但是', '2017-09-18 11:06:24', 8, '修改122', 5, 1, NULL, 1, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (126, '大', '2017-09-23 11:43:05', 8, '地方撒发生126', 7, 1, NULL, 0, 1, 'soli;红之花');
INSERT INTO `aoa_note_list` VALUES (127, 'dsfa', '2017-09-23 12:34:05', 8, 'dfsa的127', 5, 1, NULL, 1, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (128, 'sdaf', '2017-09-23 12:37:21', 8, 'dsa128', 6, 1, 42, 1, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (137, '第三方', '2017-10-01 14:18:54', 8, '大师傅137', 7, 1, NULL, 0, 1, ';伊丽莎白');
INSERT INTO `aoa_note_list` VALUES (138, '发多少', '2017-10-01 14:30:48', 8, '分公司', 7, 1, NULL, 0, 1, '伊丽莎白');
INSERT INTO `aoa_note_list` VALUES (139, '士大夫', '2017-10-01 14:31:26', 8, '士大夫', 6, 1, NULL, 1, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (140, '士大夫', '2017-10-01 14:36:19', 8, '手动阀', 7, 1, NULL, 0, 1, '伊丽莎白;小李父斯基');
INSERT INTO `aoa_note_list` VALUES (143, '发多少', '2017-10-01 14:57:13', 8, 'fdas ', 7, 1, NULL, 1, 1, ';发给');
INSERT INTO `aoa_note_list` VALUES (145, 'fd', '2017-10-01 16:01:33', 8, 'fggfd', 5, 1, NULL, 0, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (146, '', '2017-10-01 16:02:51', 8, '新建发给', 5, 1, NULL, 1, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (149, '地方撒1222222222222222', '2017-10-01 17:50:20', 8, '范德萨', 5, 1, NULL, 0, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (150, '士大夫1111111111111', '2017-10-01 17:55:31', 8, '的是非得失', 5, 1, NULL, 0, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (151, '更丰富付付付付付付付付付付付付付付付付', '2017-10-01 18:06:21', 8, '华哥', 5, 1, NULL, 0, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (152, '22222222222222222222', '2017-10-01 18:09:32', 8, '地方撒', 5, 1, NULL, 0, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (153, '1111111111111111111111', '2017-10-01 18:11:05', 8, '大师', 5, 1, NULL, 0, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (154, '222222222222222222222', '2017-10-01 18:19:10', 8, '第三方', 5, 1, NULL, 0, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (155, '哈哈哈哈或或或或或或或或或或或或或或或或或或或或或或或发凡方法付付', '2017-10-01 18:25:10', 8, '过后会或或', 5, 1, NULL, 0, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (156, '东方时尚所说付发的大多多多多多多多', '2017-10-01 18:30:08', 8, ' 胡歌封帝', 5, 1, NULL, 1, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (157, '东方时尚所所所所所所所所所', '2017-10-01 18:35:07', 8, '咯咯咯咯咯滚滚滚', 5, 1, NULL, 0, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (158, '333333333333333', '2017-10-01 19:20:29', 8, '第三方', 5, 1, NULL, 0, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (159, '2111111111111111111111111111', '2017-10-01 19:38:13', 8, '的说法', 5, 1, NULL, 0, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (160, '2222222222222222222222222', '2017-10-01 19:42:55', 8, '的说法', 5, 1, NULL, 0, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (161, '2222222222222222222222222222', '2017-10-01 19:49:55', 8, '大方法', 5, 1, NULL, 0, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (162, '43333333333333333333333333', '2017-10-01 19:57:19', 8, '的说法', 5, 1, NULL, 0, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (163, '444444444444444444444444444444444', '2017-10-01 19:59:18', 8, '第三方', 5, 1, NULL, 0, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (164, '55555555555555555555555555555555', '2017-10-01 20:03:07', 8, '的说法', 5, 1, NULL, 0, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (165, '3443242243333333333333', '2017-10-01 20:05:10', 8, '范德萨', 5, 1, NULL, 1, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (166, '22222222222222222222222222', '2017-10-01 20:08:25', 8, '大对方是否收费', 5, 1, NULL, 0, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (167, '3333333333333333333333', '2017-10-01 20:17:13', 8, '发生的', 5, 1, NULL, 0, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (168, '11111111111111111111111', '2017-10-01 20:26:29', 8, '地方撒', 5, 1, NULL, 0, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (169, '333333333333333333333', '2017-10-01 20:26:58', 8, '第', 5, 1, NULL, 0, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (170, '知道吗 这个世界 随处都有万有引力', '2017-10-05 19:49:17', 8, '无语的n此房', 7, 1, NULL, 0, 1, '罗密欧;甄姬');
INSERT INTO `aoa_note_list` VALUES (171, '11111111111111111111111111111111111', '2017-10-05 20:19:31', 8, '的说法', 5, 2, NULL, 0, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (172, '阿斯蒂芬三分333333333333', '2017-10-05 20:23:02', 8, '地方撒', 5, 2, NULL, 0, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (173, '(⊙o⊙)…334334', '2017-10-05 20:23:27', 8, '的说法', 5, 2, NULL, 1, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (174, '1321131314124', '2017-10-05 20:25:30', 8, '三大东方', 7, 2, NULL, 0, 1, '罗密欧;伊丽莎白');
INSERT INTO `aoa_note_list` VALUES (175, '213131对方是否收费 23', '2017-10-05 20:27:17', 8, '范德萨23', 7, 1, NULL, 0, 1, '罗密欧;伊丽莎白');
INSERT INTO `aoa_note_list` VALUES (176, '2222222222222222222222222222', '2017-10-05 20:40:18', 8, '听说对方', 6, 2, NULL, 0, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (177, '233333333333333333333333', '2017-10-05 20:43:01', 8, '发生的发生', 7, 2, NULL, 0, 1, '小李父斯基;soli');
INSERT INTO `aoa_note_list` VALUES (178, '2333333333333333333333333333333', '2017-10-05 20:43:31', 9, '地方撒发生', 5, 2, NULL, 0, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (179, '2333333333333333333333333333', '2017-10-05 20:48:03', 8, '大三', 5, 1, NULL, 0, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (180, '33333333333333333333333', '2017-10-05 20:48:49', 8, '地方', 5, 2, NULL, 0, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (181, '22222222222222222222222222222222', '2017-10-05 20:50:57', 8, '33333333333333', 5, 2, NULL, 0, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (182, '3333333333333333', '2017-10-05 20:57:28', 9, '地方撒', 5, 2, NULL, 0, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (183, '大师傅444444444444444444444', '2017-10-05 21:01:41', 8, '的说法', 5, 2, NULL, 0, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (184, '3333333333333333333333333333333333', '2017-10-05 21:03:03', 8, 'ad231', 5, 2, NULL, 0, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (187, '44444444444444444444444444444444444444', '2017-10-05 21:22:28', 8, '安抚第三方', 5, 1, NULL, 1, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (188, '324242533333333333333333390', '2017-10-05 22:48:20', 8, '大三', 5, 1, NULL, 0, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (189, 'dsafffffff555555555555555555555555', '2017-10-06 11:15:14', 8, 'dfas ', 5, 33, NULL, 0, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (190, '3333333333333333333333333333333333333', '2017-10-06 11:23:34', 8, 'sdfa ', 5, 33, NULL, 0, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (191, '222222222222222222222222222222222222222222222222', '2017-10-06 11:29:14', 8, '34242423', 5, 33, NULL, 0, 7, NULL);
INSERT INTO `aoa_note_list` VALUES (192, '2323232323232323232323232323232323', '2017-10-06 22:29:33', 8, '发给', 5, 33, NULL, 0, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (193, '<span style=\"color:#333333;font-family:arial, 宋体, sans-serif;font-size:14px;background-color:#FFFFFF;\">1995年,互联网的蓬勃发展给了Oak机会。业界为了使死板、单调的静态网页能够“灵活”起来,急需一种软件技术来开发一种程序,这种程序可以通过网络传播并且能够跨平台运行。于是,世界各大</span><a target=\"_blank\" href=\"https://baike.baidu.com/item/IT/16684878\">IT</a><span style=\"color:#333333;font-family:arial, 宋体, sans-serif;font-size:14px;background-color:#FFFFFF;\">企业为此纷纷投入了大量的人力、物力和财力。这个时候,Sun公司想起了那个被搁置起来很久的Oak,并且重新审视了那个用软件编写的试验平台,由于它是按照嵌入式系统硬件平台体系结构进行编写的,所以非常小,特别适用于网络上的传输系统,而Oak也是一种精简的语言,程序非常小,适合在网络上传输。Sun公司首先推出了可以嵌入网页并且可以随同网页在网络上传输的</span><a target=\"_blank\" href=\"https://baike.baidu.com/item/Applet\">Applet</a><i>(Applet是一种将小程序嵌入到网页中进行执行的技术)</i><span style=\"color:#333333;font-family:arial, 宋体, sans-serif;font-size:14px;background-color:#FFFFFF;\">,并将Oak更名为Java</span>', '2017-10-06 22:32:04', 8, '最终版本', 7, 33, 81, 0, 1, '丹琪;于彤');
INSERT INTO `aoa_note_list` VALUES (194, '444444444444444444444444444444', '2017-10-07 16:03:03', 8, '有附件', 5, 33, 64, 0, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (195, '322222222222222222222222222222222222222222222', '2017-10-07 20:14:48', 9, '范德萨', 6, 33, NULL, 0, 23, NULL);
INSERT INTO `aoa_note_list` VALUES (196, '<a target=\"_blank\" href=\"https://baike.baidu.com/item/Java/85979\">Java</a><span style=\"color:#333333;font-family:arial, 宋体, sans-serif;font-size:14px;background-color:#FFFFFF;\">是一门</span><a target=\"_blank\" href=\"https://baike.baidu.com/item/%E9%9D%A2%E5%90%91%E5%AF%B9%E8%B1%A1\">面向对象</a><span style=\"color:#333333;font-family:arial, 宋体, sans-serif;font-size:14px;background-color:#FFFFFF;\">编程语言,不仅吸收了</span><a target=\"_blank\" href=\"https://baike.baidu.com/item/C%2B%2B\">C++</a><span style=\"color:#333333;font-family:arial, 宋体, sans-serif;font-size:14px;background-color:#FFFFFF;\">语言的各种优点,还摒弃了C++里难以理解的</span><a target=\"_blank\" href=\"https://baike.baidu.com/item/%E5%A4%9A%E7%BB%A7%E6%89%BF\">多继承</a><span style=\"color:#333333;font-family:arial, 宋体, sans-serif;font-size:14px;background-color:#FFFFFF;\">、</span><a target=\"_blank\" href=\"https://baike.baidu.com/item/%E6%8C%87%E9%92%88\">指针</a><span style=\"color:#333333;font-family:arial, 宋体, sans-serif;font-size:14px;background-color:#FFFFFF;\">等概念,因此Java语言具有功能强大和简单易用两个特征。Java语言作为静态面向对象编程语言的代表,极好地实现了面向对象理论,允许程序员以优雅的思维方式进行复杂的编程</span><span style=\"font-size:12px;line-height:0;vertical-align:baseline;color:#3366CC;font-family:arial, 宋体, sans-serif;background-color:#FFFFFF;\">[1]</span><a name=\"ref_[1]_12654100\"></a> <span style=\"color:#333333;font-family:arial, 宋体, sans-serif;font-size:14px;background-color:#FFFFFF;\"> 。</span>', '2017-10-08 16:22:44', 8, '上课要义', 5, 33, 77, 0, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (198, '<span style=\"color:#333333;font-family:arial, 宋体, sans-serif;font-size:14px;background-color:#FFFFFF;\">由于在开发Oak语言时,尚且不存在运行字节码的硬件平台,所以为了在开发时可以对这种语言进行实验研究,他们就在已有的硬件和软件平台基础上,按照自己所指定的规范,用软件建设了一个运行平台,整个系统除了比C++更加简单之外,没有什么大的区别。1992年的夏天,当Oak语言开发成功后,研究者们向硬件生产商进行演示了Green操作系统、Oak的程序设计语言、类库和其硬件,以说服他们使用Oak语言生产硬件芯片,但是,硬件生产商并未对此产生极大的热情。因为他们认为,在所有人对Oak语言还一无所知的情况下,就生产硬件产品的风险实在太大了,所以Oak语言也就因为缺乏硬件的支持而无法进入市场,从而被搁置了下来</span>', '2017-10-18 15:39:45', 8, '测试', 5, 33, NULL, 0, 1, NULL);
INSERT INTO `aoa_note_list` VALUES (199, '<span style=\"color:#333333;font-family:arial, 宋体, sans-serif;font-size:14px;background-color:#FFFFFF;\">由于</span><a target=\"_blank\" href=\"https://baike.baidu.com/item/C%2B%2B\">C++</a><span style=\"color:#333333;font-family:arial, 宋体, sans-serif;font-size:14px;background-color:#FFFFFF;\">所具有的优势,该项目组的研究人员首先考虑采用C++来编写程序。但对于</span><a target=\"_blank\" href=\"https://baike.baidu.com/item/%E7%A1%AC%E4%BB%B6\">硬件</a><span style=\"color:#333333;font-family:arial, 宋体, sans-serif;font-size:14px;background-color:#FFFFFF;\">资源极其匮乏的单片式系统来说,C++程序过于复杂和庞大。另外由于消费电子产品所采用的嵌入式处理器芯片的种类繁杂,如何让编写的程序</span><a target=\"_blank\" href=\"https://baike.baidu.com/item/%E8%B7%A8%E5%B9%B3%E5%8F%B0\">跨平台</a><span style=\"color:#333333;font-family:arial, 宋体, sans-serif;font-size:14px;background-color:#FFFFFF;\">运行也是个难题。为了解决困难,他们首先着眼于语言的开发,假设了一种结构简单、符合嵌入式应用需要的硬件平台体系结构并为其制定了相应的规范,其中就定义了这种硬件平台的</span><a target=\"_blank\" href=\"https://baike.baidu.com/item/%E4%BA%8C%E8%BF%9B%E5%88%B6\">二进制</a><span style=\"color:#333333;font-family:arial, 宋体, sans-serif;font-size:14px;background-color:#FFFFFF;\">机器码指令系统</span><i>(即后来成为“</i><a target=\"_blank\" href=\"https://baike.baidu.com/item/%E5%AD%97%E8%8A%82%E7%A0%81\"><i>字节码</i></a><i>”的指令系统)</i><span style=\"color:#333333;font-family:arial, 宋体, sans-serif;font-size:14px;background-color:#FFFFFF;\">,以待语言开发成功后,能有</span><a target=\"_blank\" href=\"https://baike.baidu.com/item/%E5%8D%8A%E5%AF%BC%E4%BD%93%E8%8A%AF%E7%89%87\">半导体芯片</a><span style=\"color:#333333;font-family:arial, 宋体, sans-serif;font-size:14px;background-color:#FFFFFF;\">生产商开发和生产这种硬件平台。对于新语言的设计,Sun公司研发人员并没有开发一种全新的语言,而是根据嵌入式软件的要求,对C++进行了改造,去除了留在C++的一些不太实用及影响安全的成分,并结合嵌入式系统的实时性要求,开发了一种称为</span><a target=\"_blank\" href=\"https://baike.baidu.com/item/Oak\">Oak</a><span style=\"color:#333333;font-family:arial, 宋体, sans-serif;font-size:14px;background-color:#FFFFFF;\">的</span><a target=\"_blank\" href=\"https://baike.baidu.com/item/%E9%9D%A2%E5%90%91%E5%AF%B9%E8%B1%A1%E8%AF%AD%E8%A8%80\">面向对象语言</a><span style=\"color:#333333;font-family:arial, 宋体, sans-serif;font-size:14px;background-color:#FFFFFF;\">。</span>', '2017-10-18 15:40:44', 8, '讨论', 7, 33, NULL, 0, 1, '甄姬2;无双');
INSERT INTO `aoa_note_list` VALUES (201, '312111111111111111111111111111111111111111111111111111111111', '2017-10-19 23:15:51', 8, '1231321', 5, 33, NULL, 0, 10, NULL);