-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathcommunity.sql
More file actions
929 lines (886 loc) · 294 KB
/
Copy pathcommunity.sql
File metadata and controls
929 lines (886 loc) · 294 KB
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
/*
Navicat Premium Data Transfer
Source Server : MySQL
Source Server Type : MySQL
Source Server Version : 80022
Source Host : localhost:3306
Source Schema : community
Target Server Type : MySQL
Target Server Version : 80022
File Encoding : 65001
Date: 04/05/2022 08:26:09
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for article_type
-- ----------------------------
DROP TABLE IF EXISTS `article_type`;
CREATE TABLE `article_type` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`audit_state` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '审核状态',
`name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '名称',
`description` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '描述',
`ref_count` bigint NOT NULL DEFAULT '0' COMMENT '引用统计',
`scope` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '作用域',
`creator_id` bigint DEFAULT NULL COMMENT '创建人',
`is_delete` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '删除标识(0:未删除、1:已删除)',
`create_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '记录创建时间',
`update_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '记录修改时间',
PRIMARY KEY (`id`),
UNIQUE KEY `uniq_name_state` (`name`,`audit_state`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='文章类别表';
-- ----------------------------
-- Records of article_type
-- ----------------------------
BEGIN;
INSERT INTO `article_type` (`id`, `audit_state`, `name`, `description`, `ref_count`, `scope`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (1, 'PASS', '活动', '官方活动', 0, 'OFFICIAL', 16, 1, '2021-11-10 12:03:01', '2022-04-18 16:45:38');
INSERT INTO `article_type` (`id`, `audit_state`, `name`, `description`, `ref_count`, `scope`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (2, 'PASS', '公告', '官方公告', 0, 'OFFICIAL', 16, 1, '2021-11-10 12:03:01', '2022-04-18 16:45:43');
INSERT INTO `article_type` (`id`, `audit_state`, `name`, `description`, `ref_count`, `scope`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (3, 'PASS', '前端', '前端', 9, 'USER', 16, 0, '2021-11-10 12:03:01', '2022-04-18 16:45:43');
INSERT INTO `article_type` (`id`, `audit_state`, `name`, `description`, `ref_count`, `scope`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (4, 'PASS', '后端', '后端', 11, 'USER', 16, 0, '2021-11-10 12:03:01', '2022-04-18 16:45:43');
INSERT INTO `article_type` (`id`, `audit_state`, `name`, `description`, `ref_count`, `scope`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (5, 'PASS', '小程序', '小程序', 0, 'USER', 16, 0, '2021-11-10 12:03:01', '2022-04-18 16:45:43');
INSERT INTO `article_type` (`id`, `audit_state`, `name`, `description`, `ref_count`, `scope`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (6, 'PASS', '公众号', '公众号', 10, 'USER', 16, 0, '2021-11-10 12:03:01', '2022-04-18 16:45:43');
INSERT INTO `article_type` (`id`, `audit_state`, `name`, `description`, `ref_count`, `scope`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (7, 'PASS', 'iOS', 'iOS类别', 0, 'USER', 16, 0, '2021-11-10 12:03:01', '2022-04-18 16:45:43');
INSERT INTO `article_type` (`id`, `audit_state`, `name`, `description`, `ref_count`, `scope`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (8, 'PASS', 'Android', 'Android类别', 1, 'USER', 16, 0, '2021-11-10 12:03:01', '2022-04-18 16:45:43');
INSERT INTO `article_type` (`id`, `audit_state`, `name`, `description`, `ref_count`, `scope`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (9, 'PASS', 'AI', 'AI 类别', 0, 'USER', 16, 0, '2021-11-10 12:03:01', '2022-04-18 16:45:43');
INSERT INTO `article_type` (`id`, `audit_state`, `name`, `description`, `ref_count`, `scope`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (10, 'PASS', '云计算', '云计算 类别', 0, 'USER', 16, 0, '2021-11-10 12:03:01', '2022-04-18 16:45:43');
INSERT INTO `article_type` (`id`, `audit_state`, `name`, `description`, `ref_count`, `scope`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (11, 'PASS', '游戏', '游戏 类别', 0, 'USER', 16, 0, '2021-11-10 12:03:01', '2022-04-18 16:45:43');
INSERT INTO `article_type` (`id`, `audit_state`, `name`, `description`, `ref_count`, `scope`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (12, 'PASS', '安全', '安全 类别', 0, 'USER', 16, 0, '2021-11-10 12:03:01', '2022-04-18 16:45:43');
INSERT INTO `article_type` (`id`, `audit_state`, `name`, `description`, `ref_count`, `scope`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (14, 'PASS', '区块链', '区块链 类别', 0, 'USER', 16, 0, '2021-11-10 12:03:01', '2022-04-18 16:45:43');
INSERT INTO `article_type` (`id`, `audit_state`, `name`, `description`, `ref_count`, `scope`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (15, 'PASS', '开源', '开源 类别', 1, 'USER', 16, 0, '2021-11-10 12:03:01', '2022-04-18 16:45:43');
INSERT INTO `article_type` (`id`, `audit_state`, `name`, `description`, `ref_count`, `scope`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (16, 'PASS', '工具', '工具 类别', 2, 'USER', 16, 0, '2021-11-10 12:03:01', '2022-04-18 16:45:43');
INSERT INTO `article_type` (`id`, `audit_state`, `name`, `description`, `ref_count`, `scope`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (18, 'PASS', '行业', '行业 类别', 0, 'USER', 16, 0, '2021-11-10 12:03:01', '2022-04-18 16:45:43');
INSERT INTO `article_type` (`id`, `audit_state`, `name`, `description`, `ref_count`, `scope`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (19, 'PASS', '其他', '其他 类别', 0, 'USER', 16, 0, '2021-11-10 12:03:01', '2022-04-18 16:45:43');
INSERT INTO `article_type` (`id`, `audit_state`, `name`, `description`, `ref_count`, `scope`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (29, NULL, '测试', '11111111', 0, NULL, NULL, 1, '2022-04-18 16:44:19', '2022-04-18 16:44:19');
INSERT INTO `article_type` (`id`, `audit_state`, `name`, `description`, `ref_count`, `scope`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (30, NULL, '测试2', '2222222222', 0, NULL, NULL, 1, '2022-04-18 16:44:19', '2022-04-18 16:44:19');
INSERT INTO `article_type` (`id`, `audit_state`, `name`, `description`, `ref_count`, `scope`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (31, NULL, '测试3', '333333', 0, NULL, NULL, 1, '2022-04-18 16:44:19', '2022-04-18 16:44:19');
INSERT INTO `article_type` (`id`, `audit_state`, `name`, `description`, `ref_count`, `scope`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (42, NULL, '测试4', '测试4测试4测试4', 0, NULL, NULL, 1, '2022-04-18 19:20:13', '2022-04-18 19:20:13');
COMMIT;
-- ----------------------------
-- Table structure for comment
-- ----------------------------
DROP TABLE IF EXISTS `comment`;
CREATE TABLE `comment` (
`id` int NOT NULL AUTO_INCREMENT COMMENT '评论id',
`user_id` int DEFAULT NULL COMMENT '用户id',
`entity_type` int DEFAULT NULL COMMENT '评论对象类型(评论2或者帖子1)',
`entity_id` int DEFAULT NULL COMMENT '所评论的帖子或评论的id',
`target_id` int DEFAULT NULL COMMENT '回复对象的id(针对个人的回复)',
`content` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '评论内容',
`status` int DEFAULT NULL COMMENT '评论状态',
`create_time` timestamp NULL DEFAULT NULL COMMENT '评论时间',
PRIMARY KEY (`id`),
KEY `index_user_id` (`user_id`) /*!80000 INVISIBLE */,
KEY `index_entity_id` (`entity_id`)
) ENGINE=InnoDB AUTO_INCREMENT=320 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of comment
-- ----------------------------
BEGIN;
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (232, 153, 1, 286, 0, '对帖子的评论', 0, '2022-02-09 15:26:33');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (233, 153, 2, 232, 0, '对评论进行回复', 0, '2022-02-09 15:27:13');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (234, 149, 2, 232, 0, '对评论进行回复2', 0, '2022-02-09 15:27:57');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (235, 149, 2, 232, 153, '对用户进行回复', 0, '2022-02-09 15:28:08');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (236, 149, 1, 286, 0, '对帖子的评论2', 0, '2022-02-09 15:49:58');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (241, 111, 1, 286, 0, '。。。。', 0, '2022-02-11 21:57:46');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (242, 111, 2, 232, 149, '。。。。', 0, '2022-02-11 21:57:55');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (243, 111, 1, 284, 0, '11111111111111111111', 0, '2022-02-11 22:46:12');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (244, 153, 1, 284, 0, '第二条评论', 0, '2022-02-12 21:13:58');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (245, 153, 2, 243, 0, '评论的评论', 0, '2022-02-12 21:14:04');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (246, 153, 1, 283, 0, '111', 0, '2022-02-12 21:14:53');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (247, 153, 2, 246, 0, '1111', 0, '2022-02-12 21:14:55');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (248, 153, 1, 285, 0, '111', 0, '2022-02-12 21:14:59');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (249, 153, 1, 285, 0, '222222', 0, '2022-02-12 21:15:03');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (250, 153, 2, 249, 0, '对评论进行回复', 0, '2022-02-12 21:15:21');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (251, 153, 1, 280, 0, '111111', 0, '2022-02-12 21:22:40');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (252, 153, 2, 251, 0, '```', 0, '2022-02-12 21:22:57');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (253, 153, 2, 243, 153, '...', 0, '2022-02-12 21:28:00');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (254, 153, 1, 290, 0, '点赞 ', 0, '2022-02-12 21:32:12');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (255, 153, 1, 290, 0, '支持对**帖子**、**评论**点赞 ', 0, '2022-02-12 21:32:17');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (256, 153, 1, 290, 0, '第1次点赞,第2次取消点赞。 ', 0, '2022-02-12 21:32:22');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (257, 153, 1, 290, 0, '为什么发布评论的默认赞的数量是1', 0, '2022-02-12 21:32:44');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (258, 153, 2, 243, 0, '111', 0, '2022-02-12 21:33:25');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (259, 153, 1, 284, 0, '1111', 0, '2022-02-12 21:33:29');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (260, 153, 1, 284, 0, '2222', 0, '2022-02-12 21:33:39');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (261, 153, 1, 284, 0, '3333333333', 0, '2022-02-12 21:33:44');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (262, 153, 1, 284, 0, 's's's', 0, '2022-02-12 21:34:04');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (263, 153, 1, 284, 0, 'aaaaaaaa', 0, '2022-02-12 21:34:16');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (264, 153, 2, 262, 0, 'ssss', 0, '2022-02-12 21:34:36');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (265, 153, 2, 243, 153, '1111111111', 0, '2022-02-12 21:34:44');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (266, 153, 2, 243, 0, '1111111', 0, '2022-02-12 21:34:50');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (267, 153, 1, 284, 0, '啊啊啊啊啊啊啊啊', 0, '2022-02-12 21:35:04');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (268, 153, 2, 246, 0, '1', 0, '2022-02-12 21:36:16');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (269, 153, 2, 246, 153, '2', 0, '2022-02-12 21:36:20');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (270, 153, 1, 283, 0, '3', 0, '2022-02-12 21:36:27');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (271, 153, 1, 283, 0, '34', 0, '2022-02-12 21:36:37');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (272, 111, 2, 251, 153, '......', 0, '2022-02-12 21:40:54');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (273, 111, 1, 280, 0, '........', 0, '2022-02-12 21:41:11');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (274, 111, 2, 251, 0, '...............', 0, '2022-02-12 21:41:26');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (275, 111, 2, 262, 153, '222', 0, '2022-02-12 21:47:39');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (276, 111, 2, 262, 0, '1111111111', 0, '2022-02-12 21:47:45');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (277, 153, 2, 244, 0, '1111111111', 0, '2022-02-12 21:50:49');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (278, 153, 2, 243, 153, '111', 0, '2022-02-13 11:39:31');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (279, 153, 2, 243, 153, '1111', 0, '2022-02-13 11:39:34');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (281, 149, 1, 284, 0, 'kafka测试', 0, '2022-02-14 21:24:21');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (282, 149, 1, 284, 0, 'kafka测试kafka测试', 0, '2022-02-14 21:29:30');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (283, 153, 1, 284, 0, '如果数据库里面没有数据,Message message = messageService.findLatestNotice(user.getId(), TOPIC_COMMENT); 返回null,影响模版的生成。导致报错', 0, '2022-02-15 14:47:46');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (284, 153, 2, 261, 0, '1111', 0, '2022-02-15 14:48:11');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (285, 111, 2, 243, 0, 'aaaaaaaaaa', 0, '2022-02-15 14:52:13');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (286, 111, 2, 243, 153, 'ssssssssss', 0, '2022-02-15 14:52:33');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (287, 111, 2, 261, 0, '.............', 0, '2022-02-15 14:53:02');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (288, 111, 1, 284, 0, '1111', 0, '2022-02-15 15:40:32');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (289, 111, 1, 284, 0, '1111', 0, '2022-02-15 15:40:34');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (290, 111, 1, 292, 0, '1111', 0, '2022-02-15 15:41:47');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (291, 111, 2, 283, 0, 'xxxx', 0, '2022-02-15 15:54:09');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (292, 111, 1, 284, 0, '11111111111111111', 0, '2022-02-16 13:06:20');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (293, 153, 1, 283, 0, '开发社区搜索功能', 0, '2022-02-16 17:14:44');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (302, 11, 1, 280, 0, '1233123123123123啊实打实的爱上爱上 爱上爱上啊啊 啊啊啊撒啊啊啊啊', 0, '2022-02-18 21:23:25');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (306, 11, 1, 309, 0, '留言测试', 0, '2022-03-12 20:23:59');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (308, 11, 1, 309, 0, '留言测试2', 0, '2022-03-12 21:00:20');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (309, 11, 2, 308, 0, '留言测试3', 0, '2022-03-12 21:00:29');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (310, 11, 2, 308, 11, '留言测试4', 0, '2022-03-12 21:11:36');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (311, 11, 1, 309, 0, '测试', 0, '2022-03-12 21:12:50');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (312, 11, 1, 309, 0, '测试', 0, '2022-03-12 21:43:46');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (313, 11, 1, 309, 0, '测试测试测试测试测试测试', 0, '2022-03-12 21:48:15');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (314, 11, 1, 309, 0, '111111', 0, '2022-03-12 22:03:53');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (315, 11, 1, 340, 0, '敏感词过滤测试******************', 0, '2022-04-19 23:01:44');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (316, 11, 1, 340, 0, '可口可乐', 0, '2022-04-19 23:04:14');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (317, 11, 1, 340, 0, '***', 0, '2022-04-19 23:05:39');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (318, 11, 2, 315, 0, '对文章340的用户11进行回复', 0, '2022-04-28 11:33:25');
INSERT INTO `comment` (`id`, `user_id`, `entity_type`, `entity_id`, `target_id`, `content`, `status`, `create_time`) VALUES (319, 11, 2, 315, 11, '对用户11的回复进行回复', 0, '2022-04-28 11:33:55');
COMMIT;
-- ----------------------------
-- Table structure for discuss_post
-- ----------------------------
DROP TABLE IF EXISTS `discuss_post`;
CREATE TABLE `discuss_post` (
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
`user_id` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '关联user表',
`title` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '帖子标题',
`content` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '帖子内容',
`type` int DEFAULT NULL COMMENT '0-普通; 1-置顶;',
`status` int DEFAULT NULL COMMENT '0-正常; 1-精华; 2-拉黑;',
`create_time` timestamp NULL DEFAULT NULL COMMENT '发布时间',
`comment_count` int DEFAULT NULL COMMENT '回帖数量,使用频繁,冗余存储,不需要每次查comment表',
`score` double DEFAULT NULL COMMENT '热度排名分',
`type_id` int DEFAULT NULL COMMENT '帖子类型id',
PRIMARY KEY (`id`),
KEY `index_user_id` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=341 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of discuss_post
-- ----------------------------
BEGIN;
INSERT INTO `discuss_post` (`id`, `user_id`, `title`, `content`, `type`, `status`, `create_time`, `comment_count`, `score`, `type_id`) VALUES (1, '12', 'Amazing!巧用 CSS 视差实现酷炫交互动效', 'SSH serves to prevent such vulnerabilities and allows you to access a remote server\'s shell without compromising security. You must be the change you wish to see in the world. It is used while your ISPs do not allow direct connections, but allows establishing HTTP connections. There is no way to happiness. Happiness is the way. Navicat Monitor requires a repository to store alerts and metrics for historical analysis. I may not have gone where I intended to go, but I think I have ended up where I needed to be. All journeys have secret destinations of which the traveler is unaware. Export Wizard allows you to export data from tables, collections, views, or query results to any available formats. To connect to a database or schema, simply double-click it in the pane. Anyone who has ever made anything of importance was disciplined. Typically, it is employed as an encrypted version of Telnet. It provides strong authentication and secure encrypted communications between two hosts, known as SSH Port Forwarding (Tunneling), over an insecure network. Navicat Monitor is a safe, simple and agentless remote server monitoring tool that is packed with powerful features to make your monitoring effective as possible. A man is not old until regrets take the place of dreams. The reason why a great man is great is that he resolves to be a great man. Actually it is just in an idea when feel oneself can achieve and cannot achieve. How we spend our days is, of course, how we spend our lives. Navicat provides a wide range advanced features, such as compelling code editing capabilities, smart code-completion, SQL formatting, and more. To open a query using an external editor, control-click it and select Open with External Editor. You can set the file path of an external editor in Preferences. You cannot save people, you can just love them. Import Wizard allows you to import data to tables/collections from CSV, TXT, XML, DBF and more. What you get by achieving your goals is not as important as what you become by achieving your goals. Such sessions are also susceptible to session hijacking, where a malicious user takes over your session once you have authenticated. The Main Window consists of several toolbars and panes for you to work on connections, database objects and advanced tools. Monitored servers include MySQL, MariaDB and SQL Server, and compatible with cloud databases like Amazon RDS, Amazon Aurora, Oracle Cloud, Google Cloud and Microsoft Azure. If opportunity doesn’t knock, build a door. Navicat is a multi-connections Database Administration tool allowing you to connect to MySQL, Oracle, PostgreSQL, SQLite, SQL Server, MariaDB and/or MongoDB databases, making database administration to multiple kinds of database so easy. If it scares you, it might be a good thing to try. The reason why a great man is great is that he resolves to be a great man. You will succeed because most people are lazy. The first step is as good as half over. A man is not old until regrets take the place of dreams. The Information Pane shows the detailed object information, project activities, the DDL of database objects, object dependencies, membership of users/roles and preview. In the middle of winter I at last discovered that there was in me an invincible summer. Actually it is just in an idea when feel oneself can achieve and cannot achieve. To clear or reload various internal caches, flush tables, or acquire locks, control-click your connection in the Navigation pane and select Flush and choose the flush option. You must have the reload privilege to use this feature. Always keep your eyes open. Keep watching. Because whatever you see can inspire you. Navicat authorizes you to make connection to remote servers running on different platforms (i.e. Windows, macOS, Linux and UNIX), and supports PAM and GSSAPI authentication. The Synchronize to Database function will give you a full picture of all database differences. Success consists of going from failure to failure without loss of enthusiasm. If you wait, all that happens is you get older. It can also manage cloud databases such as Amazon Redshift, Amazon RDS, Alibaba Cloud. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs, yet easy to learn for users who are new to database server. To start working with your server in Navicat, you should first establish a connection or several connections using the Connection window. If the Show objects under schema in navigation pane option is checked at the Preferences window, all database objects are also displayed in the pane. Monitored servers include MySQL, MariaDB and SQL Server, and compatible with cloud databases like Amazon RDS, Amazon Aurora, Oracle Cloud, Google Cloud and Microsoft Azure. The Information Pane shows the detailed object information, project activities, the DDL of database objects, object dependencies, membership of users/roles and preview. Navicat Monitor is a safe, simple and agentless remote server monitoring tool that is packed with powerful features to make your monitoring effective as possible. After logged in the Navicat Cloud feature, the Navigation pane will be divided into Navicat Cloud and My Connections sections. All the Navicat Cloud objects are located under different projects. You can share the project to other Navicat Cloud accounts for collaboration. To clear or reload various internal caches, flush tables, or acquire locks, control-click your connection in the Navigation pane and select Flush and choose the flush option. You must have the reload privilege to use this feature. Navicat is a multi-connections Database Administration tool allowing you to connect to MySQL, Oracle, PostgreSQL, SQLite, SQL Server, MariaDB and/or MongoDB databases, making database administration to multiple kinds of database so easy. To connect to a database or schema, simply double-click it in the pane. What you get by achieving your goals is not as important as what you become by achieving your goals. Navicat Monitor is a safe, simple and agentless remote server monitoring tool that is packed with powerful features to make your monitoring effective as possible. The On Startup feature allows you to control what tabs appear when you launch Navicat. SQL Editor allows you to create and edit SQL text, prepare and execute selected queries. The Information Pane shows the detailed object information, project activities, the DDL of database objects, object dependencies, membership of users/roles and preview. Anyone who has ever made anything of importance was disciplined. In a Telnet session, all communications, including username and password, are transmitted in plain-text, allowing anyone to listen-in on your session and steal passwords and other information. Anyone who has never made a mistake has never tried anything new. The Main Window consists of several toolbars and panes for you to work on connections, database objects and advanced tools. Navicat provides a wide range advanced features, such as compelling code editing capabilities, smart code-completion, SQL formatting, and more. The first step is as good as half over. Such sessions are also susceptible to session hijacking, where a malicious user takes over your session once you have authenticated. To start working with your server in Navicat, you should first establish a connection or several connections using the Connection window. Creativity is intelligence having fun. A man’s best friends are his ten fingers. You cannot save people, you can just love them. Navicat Data Modeler enables you to build high-quality conceptual, logical and physical data models for a wide variety of audiences. Navicat authorizes you to make connection to remote servers running on different platforms (i.e. Windows, macOS, Linux and UNIX), and supports PAM and GSSAPI authentication. You cannot save people, you can just love them. If it scares you, it might be a good thing to try. If your Internet Service Provider (ISP) does not provide direct access to its server, Secure Tunneling Protocol (SSH) / HTTP is another solution. If opportunity doesn’t knock, build a door. The first step is as good as half over. Navicat provides powerful tools for working with queries: Query Editor for editing the query text directly, and Query Builder, Find Builder or Aggregate Builder for building queries visually. The repository database can be an existing MySQL, MariaDB, PostgreSQL, SQL Server, or Amazon RDS instance. It collects process metrics such as CPU load, RAM usage, and a variety of other resources over SSH/SNMP. To start working with your server in Navicat, you should first establish a connection or several connections using the Connection window. The first step is as good as half over. How we spend our days is, of course, how we spend our lives. Champions keep playing until they get it right. I will greet this day with love in my heart. You must be the change you wish to see in the world. Monitored servers include MySQL, MariaDB and SQL Server, and compatible with cloud databases like Amazon RDS, Amazon Aurora, Oracle Cloud, Google Cloud and Microsoft Azure.', 0, 0, '2004-08-27 22:41:29', 0, 1, 3);
INSERT INTO `discuss_post` (`id`, `user_id`, `title`, `content`, `type`, `status`, `create_time`, `comment_count`, `score`, `type_id`) VALUES (2, '13', '微服务的全链路请求(RequestContextHolder)', 'It wasn’t raining when Noah built the ark. If you wait, all that happens is you get older. It provides strong authentication and secure encrypted communications between two hosts, known as SSH Port Forwarding (Tunneling), over an insecure network.', 0, 2, '2010-01-01 01:00:02', 0, 1, 3);
INSERT INTO `discuss_post` (`id`, `user_id`, `title`, `content`, `type`, `status`, `create_time`, `comment_count`, `score`, `type_id`) VALUES (3, '22', '支付宝小程序 横屏电子版签字 ,canvas实现', 'In other words, Navicat provides the ability for data in different databases and/or schemas to be kept up-to-date so that each repository contains the same information. A man’s best friends are his ten fingers. Creativity is intelligence having fun. Navicat allows you to transfer data from one database and/or schema to another with detailed analytical process. Navicat authorizes you to make connection to remote servers running on different platforms (i.e. Windows, macOS, Linux and UNIX), and supports PAM and GSSAPI authentication. I will greet this day with love in my heart. Flexible settings enable you to set up a custom key for comparison and synchronization. To connect to a database or schema, simply double-click it in the pane. What you get by achieving your goals is not as important as what you become by achieving your goals. After comparing data, the window shows the number of records that will be inserted, updated or deleted in the target. After logged in the Navicat Cloud feature, the Navigation pane will be divided into Navicat Cloud and My Connections sections. The first step is as good as half over. With its well-designed Graphical User Interface(GUI), Navicat lets you quickly and easily create, organize, access and share information in a secure and easy way. Navicat authorizes you to make connection to remote servers running on different platforms (i.e. Windows, macOS, Linux and UNIX), and supports PAM and GSSAPI authentication. Anyone who has ever made anything of importance was disciplined. Navicat Data Modeler is a powerful and cost-effective database design tool which helps you build high-quality conceptual, logical and physical data models. After comparing data, the window shows the number of records that will be inserted, updated or deleted in the target. I destroy my enemies when I make them my friends. To successfully establish a new connection to local/remote server - no matter via SSL or SSH, set the database login information in the General tab. Navicat Cloud provides a cloud service for synchronizing connections, queries, model files and virtual group information from Navicat, other Navicat family members, different machines and different platforms. Navicat Data Modeler is a powerful and cost-effective database design tool which helps you build high-quality conceptual, logical and physical data models.', 0, 1, '2009-06-02 20:26:36', 0, 1, 3);
INSERT INTO `discuss_post` (`id`, `user_id`, `title`, `content`, `type`, `status`, `create_time`, `comment_count`, `score`, `type_id`) VALUES (4, '22', '正则表达式提取 git 提交记录中的新增代码行', 'The reason why a great man is great is that he resolves to be a great man. Champions keep playing until they get it right. What you get by achieving your goals is not as important as what you become by achieving your goals. It wasn’t raining when Noah built the ark. The Main Window consists of several toolbars and panes for you to work on connections, database objects and advanced tools. To clear or reload various internal caches, flush tables, or acquire locks, control-click your connection in the Navigation pane and select Flush and choose the flush option. You must have the reload privilege to use this feature. Navicat Monitor is a safe, simple and agentless remote server monitoring tool that is packed with powerful features to make your monitoring effective as possible. The reason why a great man is great is that he resolves to be a great man. Sometimes you win, sometimes you learn. Monitored servers include MySQL, MariaDB and SQL Server, and compatible with cloud databases like Amazon RDS, Amazon Aurora, Oracle Cloud, Google Cloud and Microsoft Azure. Navicat is a multi-connections Database Administration tool allowing you to connect to MySQL, Oracle, PostgreSQL, SQLite, SQL Server, MariaDB and/or MongoDB databases, making database administration to multiple kinds of database so easy. Always keep your eyes open. Keep watching. Because whatever you see can inspire you. With its well-designed Graphical User Interface(GUI), Navicat lets you quickly and easily create, organize, access and share information in a secure and easy way. If the plan doesn’t work, change the plan, but never the goal. Navicat Cloud could not connect and access your databases. By which it means, it could only store your connection settings, queries, model files, and virtual group; your database passwords and data (e.g. tables, views, etc) will not be stored to Navicat Cloud. Difficult circumstances serve as a textbook of life for people. Flexible settings enable you to set up a custom key for comparison and synchronization. A comfort zone is a beautiful place, but nothing ever grows there. Navicat is a multi-connections Database Administration tool allowing you to connect to MySQL, Oracle, PostgreSQL, SQLite, SQL Server, MariaDB and/or MongoDB databases, making database administration to multiple kinds of database so easy. If your Internet Service Provider (ISP) does not provide direct access to its server, Secure Tunneling Protocol (SSH) / HTTP is another solution. Navicat Cloud provides a cloud service for synchronizing connections, queries, model files and virtual group information from Navicat, other Navicat family members, different machines and different platforms. If the plan doesn’t work, change the plan, but never the goal. A comfort zone is a beautiful place, but nothing ever grows there. The Main Window consists of several toolbars and panes for you to work on connections, database objects and advanced tools. Typically, it is employed as an encrypted version of Telnet. Anyone who has never made a mistake has never tried anything new. Remember that failure is an event, not a person. The Information Pane shows the detailed object information, project activities, the DDL of database objects, object dependencies, membership of users/roles and preview. In the middle of winter I at last discovered that there was in me an invincible summer. The Main Window consists of several toolbars and panes for you to work on connections, database objects and advanced tools. Navicat Monitor requires a repository to store alerts and metrics for historical analysis. Anyone who has ever made anything of importance was disciplined. Remember that failure is an event, not a person. Anyone who has ever made anything of importance was disciplined. A query is used to extract data from the database in a readable format according to the user\'s request. The Synchronize to Database function will give you a full picture of all database differences. If you wait, all that happens is you get older. The Navigation pane employs tree structure which allows you to take action upon the database and their objects through their pop-up menus quickly and easily. Secure SHell (SSH) is a program to log in into another computer over a network, execute commands on a remote server, and move files from one machine to another. After logged in the Navicat Cloud feature, the Navigation pane will be divided into Navicat Cloud and My Connections sections. Navicat authorizes you to make connection to remote servers running on different platforms (i.e. Windows, macOS, Linux and UNIX), and supports PAM and GSSAPI authentication. After comparing data, the window shows the number of records that will be inserted, updated or deleted in the target. To clear or reload various internal caches, flush tables, or acquire locks, control-click your connection in the Navigation pane and select Flush and choose the flush option. You must have the reload privilege to use this feature. To successfully establish a new connection to local/remote server - no matter via SSL or SSH, set the database login information in the General tab. Such sessions are also susceptible to session hijacking, where a malicious user takes over your session once you have authenticated. Navicat Cloud provides a cloud service for synchronizing connections, queries, model files and virtual group information from Navicat, other Navicat family members, different machines and different platforms. With its well-designed Graphical User Interface(GUI), Navicat lets you quickly and easily create, organize, access and share information in a secure and easy way. To get a secure connection, the first thing you need to do is to install OpenSSL Library and download Database Source. I may not have gone where I intended to go, but I think I have ended up where I needed to be. In the Objects tab, you can use the List List, Detail Detail and ER Diagram ER Diagram buttons to change the object view. Flexible settings enable you to set up a custom key for comparison and synchronization. SQL Editor allows you to create and edit SQL text, prepare and execute selected queries. The repository database can be an existing MySQL, MariaDB, PostgreSQL, SQL Server, or Amazon RDS instance. In the Objects tab, you can use the List List, Detail Detail and ER Diagram ER Diagram buttons to change the object view. The Main Window consists of several toolbars and panes for you to work on connections, database objects and advanced tools. Navicat Monitor is a safe, simple and agentless remote server monitoring tool that is packed with powerful features to make your monitoring effective as possible. Navicat 15 has added support for the system-wide dark mode. Secure Sockets Layer(SSL) is a protocol for transmitting private documents via the Internet. The past has no power over the present moment. If the Show objects under schema in navigation pane option is checked at the Preferences window, all database objects are also displayed in the pane. With its well-designed Graphical User Interface(GUI), Navicat lets you quickly and easily create, organize, access and share information in a secure and easy way. Anyone who has ever made anything of importance was disciplined. The past has no power over the present moment. In other words, Navicat provides the ability for data in different databases and/or schemas to be kept up-to-date so that each repository contains the same information. Navicat Monitor can be installed on any local computer or virtual machine and does not require any software installation on the servers being monitored. Anyone who has never made a mistake has never tried anything new. Actually it is just in an idea when feel oneself can achieve and cannot achieve. Optimism is the one quality more associated with success and happiness than any other. The Information Pane shows the detailed object information, project activities, the DDL of database objects, object dependencies, membership of users/roles and preview. I destroy my enemies when I make them my friends. Remember that failure is an event, not a person. Sometimes you win, sometimes you learn. It can also manage cloud databases such as Amazon Redshift, Amazon RDS, Alibaba Cloud. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs, yet easy to learn for users who are new to database server. To successfully establish a new connection to local/remote server - no matter via SSL or SSH, set the database login information in the General tab.', 0, 0, '2000-10-14 21:17:29', 0, 1, 3);
INSERT INTO `discuss_post` (`id`, `user_id`, `title`, `content`, `type`, `status`, `create_time`, `comment_count`, `score`, `type_id`) VALUES (6, '24', '人工智能领域又一突破!京东探索研究院推出超级深度学习模型ViTAEv2 准确度高达91.2%', 'Export Wizard allows you to export data from tables, collections, views, or query results to any available formats. In other words, Navicat provides the ability for data in different databases and/or schemas to be kept up-to-date so that each repository contains the same information. After logged in the Navicat Cloud feature, the Navigation pane will be divided into Navicat Cloud and My Connections sections. Always keep your eyes open. Keep watching. Because whatever you see can inspire you. Genius is an infinite capacity for taking pains. How we spend our days is, of course, how we spend our lives. The first step is as good as half over. Champions keep playing until they get it right. Anyone who has never made a mistake has never tried anything new. Champions keep playing until they get it right. The Synchronize to Database function will give you a full picture of all database differences. Typically, it is employed as an encrypted version of Telnet. HTTP Tunneling is a method for connecting to a server that uses the same protocol (http://) and the same port (port 80) as a web server does. Navicat provides powerful tools for working with queries: Query Editor for editing the query text directly, and Query Builder, Find Builder or Aggregate Builder for building queries visually. Navicat is a multi-connections Database Administration tool allowing you to connect to MySQL, Oracle, PostgreSQL, SQLite, SQL Server, MariaDB and/or MongoDB databases, making database administration to multiple kinds of database so easy. In the Objects tab, you can use the List List, Detail Detail and ER Diagram ER Diagram buttons to change the object view. There is no way to happiness. Happiness is the way. Optimism is the one quality more associated with success and happiness than any other. Genius is an infinite capacity for taking pains. Navicat 15 has added support for the system-wide dark mode. Export Wizard allows you to export data from tables, collections, views, or query results to any available formats. A man is not old until regrets take the place of dreams. To connect to a database or schema, simply double-click it in the pane. The Information Pane shows the detailed object information, project activities, the DDL of database objects, object dependencies, membership of users/roles and preview. Navicat 15 has added support for the system-wide dark mode. You will succeed because most people are lazy. To start working with your server in Navicat, you should first establish a connection or several connections using the Connection window. After comparing data, the window shows the number of records that will be inserted, updated or deleted in the target. What you get by achieving your goals is not as important as what you become by achieving your goals. Navicat Cloud provides a cloud service for synchronizing connections, queries, model files and virtual group information from Navicat, other Navicat family members, different machines and different platforms. To start working with your server in Navicat, you should first establish a connection or several connections using the Connection window. Genius is an infinite capacity for taking pains. In other words, Navicat provides the ability for data in different databases and/or schemas to be kept up-to-date so that each repository contains the same information. SSH serves to prevent such vulnerabilities and allows you to access a remote server\'s shell without compromising security. Actually it is just in an idea when feel oneself can achieve and cannot achieve. The Main Window consists of several toolbars and panes for you to work on connections, database objects and advanced tools.', 0, 0, '2004-04-14 18:37:54', 0, 1, 3);
INSERT INTO `discuss_post` (`id`, `user_id`, `title`, `content`, `type`, `status`, `create_time`, `comment_count`, `score`, `type_id`) VALUES (7, '25', 'petite-vue源码剖析-逐行解读@vue-reactivity之effect', 'Navicat Data Modeler is a powerful and cost-effective database design tool which helps you build high-quality conceptual, logical and physical data models. After comparing data, the window shows the number of records that will be inserted, updated or deleted in the target. You cannot save people, you can just love them. You will succeed because most people are lazy. The past has no power over the present moment. Navicat Monitor requires a repository to store alerts and metrics for historical analysis. I will greet this day with love in my heart. To start working with your server in Navicat, you should first establish a connection or several connections using the Connection window. In the Objects tab, you can use the List List, Detail Detail and ER Diagram ER Diagram buttons to change the object view. Anyone who has ever made anything of importance was disciplined. If your Internet Service Provider (ISP) does not provide direct access to its server, Secure Tunneling Protocol (SSH) / HTTP is another solution. It collects process metrics such as CPU load, RAM usage, and a variety of other resources over SSH/SNMP. Navicat Monitor can be installed on any local computer or virtual machine and does not require any software installation on the servers being monitored. Navicat provides powerful tools for working with queries: Query Editor for editing the query text directly, and Query Builder, Find Builder or Aggregate Builder for building queries visually. Genius is an infinite capacity for taking pains. To clear or reload various internal caches, flush tables, or acquire locks, control-click your connection in the Navigation pane and select Flush and choose the flush option. You must have the reload privilege to use this feature.', 0, 0, '2001-04-07 21:40:16', 0, 1, 3);
INSERT INTO `discuss_post` (`id`, `user_id`, `title`, `content`, `type`, `status`, `create_time`, `comment_count`, `score`, `type_id`) VALUES (8, '111', '搞懂 TypeScript 中的映射类型(Mapped Types)', 'To successfully establish a new connection to local/remote server - no matter via SSL or SSH, set the database login information in the General tab. Navicat 15 has added support for the system-wide dark mode. Navicat Monitor can be installed on any local computer or virtual machine and does not require any software installation on the servers being monitored. Always keep your eyes open. Keep watching. Because whatever you see can inspire you. I will greet this day with love in my heart. To successfully establish a new connection to local/remote server - no matter via SSL, SSH or HTTP, set the database login information in the General tab. After comparing data, the window shows the number of records that will be inserted, updated or deleted in the target. Navicat authorizes you to make connection to remote servers running on different platforms (i.e. Windows, macOS, Linux and UNIX), and supports PAM and GSSAPI authentication. A query is used to extract data from the database in a readable format according to the user\'s request. I will greet this day with love in my heart. You must be the change you wish to see in the world. It is used while your ISPs do not allow direct connections, but allows establishing HTTP connections. It collects process metrics such as CPU load, RAM usage, and a variety of other resources over SSH/SNMP. Difficult circumstances serve as a textbook of life for people. Import Wizard allows you to import data to tables/collections from CSV, TXT, XML, DBF and more. In the middle of winter I at last discovered that there was in me an invincible summer. Optimism is the one quality more associated with success and happiness than any other. To connect to a database or schema, simply double-click it in the pane. Creativity is intelligence having fun. The On Startup feature allows you to control what tabs appear when you launch Navicat. The repository database can be an existing MySQL, MariaDB, PostgreSQL, SQL Server, or Amazon RDS instance. A man is not old until regrets take the place of dreams. Anyone who has ever made anything of importance was disciplined. It is used while your ISPs do not allow direct connections, but allows establishing HTTP connections. The reason why a great man is great is that he resolves to be a great man. A man’s best friends are his ten fingers. You can select any connections, objects or projects, and then select the corresponding buttons on the Information Pane. If the Show objects under schema in navigation pane option is checked at the Preferences window, all database objects are also displayed in the pane. A query is used to extract data from the database in a readable format according to the user\'s request. Navicat allows you to transfer data from one database and/or schema to another with detailed analytical process.', 0, 0, '2018-10-03 20:58:04', 0, 1, 3);
INSERT INTO `discuss_post` (`id`, `user_id`, `title`, `content`, `type`, `status`, `create_time`, `comment_count`, `score`, `type_id`) VALUES (9, '112', 'ECMAScript 新提案:.findLast()和.findLastIndex()从尾到头搜索数组', 'With its well-designed Graphical User Interface(GUI), Navicat lets you quickly and easily create, organize, access and share information in a secure and easy way. Navicat 15 has added support for the system-wide dark mode. Navicat Cloud could not connect and access your databases. By which it means, it could only store your connection settings, queries, model files, and virtual group; your database passwords and data (e.g. tables, views, etc) will not be stored to Navicat Cloud. Actually it is just in an idea when feel oneself can achieve and cannot achieve. You cannot save people, you can just love them. Genius is an infinite capacity for taking pains. After comparing data, the window shows the number of records that will be inserted, updated or deleted in the target. To clear or reload various internal caches, flush tables, or acquire locks, control-click your connection in the Navigation pane and select Flush and choose the flush option. You must have the reload privilege to use this feature. To successfully establish a new connection to local/remote server - no matter via SSL, SSH or HTTP, set the database login information in the General tab. If the Show objects under schema in navigation pane option is checked at the Preferences window, all database objects are also displayed in the pane. Instead of wondering when your next vacation is, maybe you should set up a life you don’t need to escape from. To connect to a database or schema, simply double-click it in the pane. The reason why a great man is great is that he resolves to be a great man. After comparing data, the window shows the number of records that will be inserted, updated or deleted in the target. In the middle of winter I at last discovered that there was in me an invincible summer. A query is used to extract data from the database in a readable format according to the user\'s request. With its well-designed Graphical User Interface(GUI), Navicat lets you quickly and easily create, organize, access and share information in a secure and easy way. To start working with your server in Navicat, you should first establish a connection or several connections using the Connection window. Remember that failure is an event, not a person. It collects process metrics such as CPU load, RAM usage, and a variety of other resources over SSH/SNMP. Navicat provides a wide range advanced features, such as compelling code editing capabilities, smart code-completion, SQL formatting, and more. Sometimes you win, sometimes you learn. In a Telnet session, all communications, including username and password, are transmitted in plain-text, allowing anyone to listen-in on your session and steal passwords and other information. Navicat Data Modeler enables you to build high-quality conceptual, logical and physical data models for a wide variety of audiences. Typically, it is employed as an encrypted version of Telnet. Typically, it is employed as an encrypted version of Telnet. In other words, Navicat provides the ability for data in different databases and/or schemas to be kept up-to-date so that each repository contains the same information. It wasn’t raining when Noah built the ark. You cannot save people, you can just love them. A comfort zone is a beautiful place, but nothing ever grows there. You cannot save people, you can just love them. If you wait, all that happens is you get older. Always keep your eyes open. Keep watching. Because whatever you see can inspire you. The Information Pane shows the detailed object information, project activities, the DDL of database objects, object dependencies, membership of users/roles and preview. You cannot save people, you can just love them. A man’s best friends are his ten fingers. It can also manage cloud databases such as Amazon Redshift, Amazon RDS, Alibaba Cloud. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs, yet easy to learn for users who are new to database server. Import Wizard allows you to import data to tables/collections from CSV, TXT, XML, DBF and more. Flexible settings enable you to set up a custom key for comparison and synchronization. Difficult circumstances serve as a textbook of life for people. To successfully establish a new connection to local/remote server - no matter via SSL, SSH or HTTP, set the database login information in the General tab. The Information Pane shows the detailed object information, project activities, the DDL of database objects, object dependencies, membership of users/roles and preview. SQL Editor allows you to create and edit SQL text, prepare and execute selected queries. Anyone who has ever made anything of importance was disciplined. The Navigation pane employs tree structure which allows you to take action upon the database and their objects through their pop-up menus quickly and easily. The Navigation pane employs tree structure which allows you to take action upon the database and their objects through their pop-up menus quickly and easily. It collects process metrics such as CPU load, RAM usage, and a variety of other resources over SSH/SNMP. Instead of wondering when your next vacation is, maybe you should set up a life you don’t need to escape from. Always keep your eyes open. Keep watching. Because whatever you see can inspire you. Sometimes you win, sometimes you learn. Import Wizard allows you to import data to tables/collections from CSV, TXT, XML, DBF and more. Typically, it is employed as an encrypted version of Telnet. SSH serves to prevent such vulnerabilities and allows you to access a remote server\'s shell without compromising security. A comfort zone is a beautiful place, but nothing ever grows there. Navicat Cloud provides a cloud service for synchronizing connections, queries, model files and virtual group information from Navicat, other Navicat family members, different machines and different platforms. The repository database can be an existing MySQL, MariaDB, PostgreSQL, SQL Server, or Amazon RDS instance. It is used while your ISPs do not allow direct connections, but allows establishing HTTP connections. Secure Sockets Layer(SSL) is a protocol for transmitting private documents via the Internet. Navicat Data Modeler is a powerful and cost-effective database design tool which helps you build high-quality conceptual, logical and physical data models. Export Wizard allows you to export data from tables, collections, views, or query results to any available formats. Navicat is a multi-connections Database Administration tool allowing you to connect to MySQL, Oracle, PostgreSQL, SQLite, SQL Server, MariaDB and/or MongoDB databases, making database administration to multiple kinds of database so easy. I may not have gone where I intended to go, but I think I have ended up where I needed to be. Remember that failure is an event, not a person. Export Wizard allows you to export data from tables, collections, views, or query results to any available formats. Sometimes you win, sometimes you learn. How we spend our days is, of course, how we spend our lives. The On Startup feature allows you to control what tabs appear when you launch Navicat. In the middle of winter I at last discovered that there was in me an invincible summer. If opportunity doesn’t knock, build a door. The first step is as good as half over. Such sessions are also susceptible to session hijacking, where a malicious user takes over your session once you have authenticated. After logged in the Navicat Cloud feature, the Navigation pane will be divided into Navicat Cloud and My Connections sections. Secure SHell (SSH) is a program to log in into another computer over a network, execute commands on a remote server, and move files from one machine to another. Navicat Monitor can be installed on any local computer or virtual machine and does not require any software installation on the servers being monitored. What you get by achieving your goals is not as important as what you become by achieving your goals. With its well-designed Graphical User Interface(GUI), Navicat lets you quickly and easily create, organize, access and share information in a secure and easy way. I will greet this day with love in my heart. If it scares you, it might be a good thing to try. You must be the change you wish to see in the world. To clear or reload various internal caches, flush tables, or acquire locks, control-click your connection in the Navigation pane and select Flush and choose the flush option. You must have the reload privilege to use this feature. Actually it is just in an idea when feel oneself can achieve and cannot achieve. If you wait, all that happens is you get older. Export Wizard allows you to export data from tables, collections, views, or query results to any available formats. Navicat 15 has added support for the system-wide dark mode. Remember that failure is an event, not a person. Sometimes you win, sometimes you learn. Difficult circumstances serve as a textbook of life for people. Optimism is the one quality more associated with success and happiness than any other. Success consists of going from failure to failure without loss of enthusiasm. To successfully establish a new connection to local/remote server - no matter via SSL, SSH or HTTP, set the database login information in the General tab. You can select any connections, objects or projects, and then select the corresponding buttons on the Information Pane. Navicat Data Modeler is a powerful and cost-effective database design tool which helps you build high-quality conceptual, logical and physical data models. You cannot save people, you can just love them.', 0, 0, '2020-03-17 23:30:16', 0, 1, 3);
INSERT INTO `discuss_post` (`id`, `user_id`, `title`, `content`, `type`, `status`, `create_time`, `comment_count`, `score`, `type_id`) VALUES (10, '113', '支付宝小程序 横屏电子版签字 ,canvas实现', 'In other words, Navicat provides the ability for data in different databases and/or schemas to be kept up-to-date so that each repository contains the same information. A man’s best friends are his ten fingers. The reason why a great man is great is that he resolves to be a great man. Such sessions are also susceptible to session hijacking, where a malicious user takes over your session once you have authenticated. Secure SHell (SSH) is a program to log in into another computer over a network, execute commands on a remote server, and move files from one machine to another. I will greet this day with love in my heart. You can select any connections, objects or projects, and then select the corresponding buttons on the Information Pane. Navicat Data Modeler is a powerful and cost-effective database design tool which helps you build high-quality conceptual, logical and physical data models.', 0, 0, '2015-04-28 03:21:35', 0, 1, 3);
INSERT INTO `discuss_post` (`id`, `user_id`, `title`, `content`, `type`, `status`, `create_time`, `comment_count`, `score`, `type_id`) VALUES (11, '114', '正则表达式提取 git 提交记录中的新增代码行', 'If it scares you, it might be a good thing to try. It collects process metrics such as CPU load, RAM usage, and a variety of other resources over SSH/SNMP. If it scares you, it might be a good thing to try. SQL Editor allows you to create and edit SQL text, prepare and execute selected queries. Navicat provides a wide range advanced features, such as compelling code editing capabilities, smart code-completion, SQL formatting, and more. Navicat 15 has added support for the system-wide dark mode. Navicat provides powerful tools for working with queries: Query Editor for editing the query text directly, and Query Builder, Find Builder or Aggregate Builder for building queries visually. Import Wizard allows you to import data to tables/collections from CSV, TXT, XML, DBF and more. Navicat allows you to transfer data from one database and/or schema to another with detailed analytical process. SSH serves to prevent such vulnerabilities and allows you to access a remote server\'s shell without compromising security.', 0, 0, '2000-02-10 02:34:09', 0, 1, 4);
INSERT INTO `discuss_post` (`id`, `user_id`, `title`, `content`, `type`, `status`, `create_time`, `comment_count`, `score`, `type_id`) VALUES (12, '115', '人工智能领域又一突破!京东探索研究院推出超级深度学习模型ViTAEv2 准确度高达91.2%', 'SSH serves to prevent such vulnerabilities and allows you to access a remote server\'s shell without compromising security. Navicat authorizes you to make connection to remote servers running on different platforms (i.e. Windows, macOS, Linux and UNIX), and supports PAM and GSSAPI authentication. To connect to a database or schema, simply double-click it in the pane. Export Wizard allows you to export data from tables, collections, views, or query results to any available formats. Such sessions are also susceptible to session hijacking, where a malicious user takes over your session once you have authenticated. To open a query using an external editor, control-click it and select Open with External Editor. You can set the file path of an external editor in Preferences. A man is not old until regrets take the place of dreams. Flexible settings enable you to set up a custom key for comparison and synchronization. The first step is as good as half over. A man is not old until regrets take the place of dreams. If the Show objects under schema in navigation pane option is checked at the Preferences window, all database objects are also displayed in the pane. Typically, it is employed as an encrypted version of Telnet. Navicat Monitor requires a repository to store alerts and metrics for historical analysis. In a Telnet session, all communications, including username and password, are transmitted in plain-text, allowing anyone to listen-in on your session and steal passwords and other information. The Main Window consists of several toolbars and panes for you to work on connections, database objects and advanced tools. To successfully establish a new connection to local/remote server - no matter via SSL or SSH, set the database login information in the General tab. If you wait, all that happens is you get older. Difficult circumstances serve as a textbook of life for people. It wasn’t raining when Noah built the ark. In a Telnet session, all communications, including username and password, are transmitted in plain-text, allowing anyone to listen-in on your session and steal passwords and other information. I destroy my enemies when I make them my friends. I may not have gone where I intended to go, but I think I have ended up where I needed to be. To open a query using an external editor, control-click it and select Open with External Editor. You can set the file path of an external editor in Preferences.', 0, 0, '2002-12-29 11:18:04', 0, 0, 4);
INSERT INTO `discuss_post` (`id`, `user_id`, `title`, `content`, `type`, `status`, `create_time`, `comment_count`, `score`, `type_id`) VALUES (13, '116', 'petite-vue源码剖析-逐行解读@vue-reactivity之effect', 'To successfully establish a new connection to local/remote server - no matter via SSL or SSH, set the database login information in the General tab. Creativity is intelligence having fun. Sometimes you win, sometimes you learn. Navicat is a multi-connections Database Administration tool allowing you to connect to MySQL, Oracle, PostgreSQL, SQLite, SQL Server, MariaDB and/or MongoDB databases, making database administration to multiple kinds of database so easy. After logged in the Navicat Cloud feature, the Navigation pane will be divided into Navicat Cloud and My Connections sections. If it scares you, it might be a good thing to try. A man is not old until regrets take the place of dreams. It wasn’t raining when Noah built the ark. Anyone who has ever made anything of importance was disciplined. In the middle of winter I at last discovered that there was in me an invincible summer. In a Telnet session, all communications, including username and password, are transmitted in plain-text, allowing anyone to listen-in on your session and steal passwords and other information. In other words, Navicat provides the ability for data in different databases and/or schemas to be kept up-to-date so that each repository contains the same information. Navicat Monitor can be installed on any local computer or virtual machine and does not require any software installation on the servers being monitored. Typically, it is employed as an encrypted version of Telnet. Anyone who has ever made anything of importance was disciplined. After logged in the Navicat Cloud feature, the Navigation pane will be divided into Navicat Cloud and My Connections sections. Navicat Data Modeler is a powerful and cost-effective database design tool which helps you build high-quality conceptual, logical and physical data models. Flexible settings enable you to set up a custom key for comparison and synchronization. A man is not old until regrets take the place of dreams. The Synchronize to Database function will give you a full picture of all database differences. I destroy my enemies when I make them my friends. I will greet this day with love in my heart. In the Objects tab, you can use the List List, Detail Detail and ER Diagram ER Diagram buttons to change the object view. To get a secure connection, the first thing you need to do is to install OpenSSL Library and download Database Source. Anyone who has ever made anything of importance was disciplined. To clear or reload various internal caches, flush tables, or acquire locks, control-click your connection in the Navigation pane and select Flush and choose the flush option. You must have the reload privilege to use this feature. Navicat Monitor can be installed on any local computer or virtual machine and does not require any software installation on the servers being monitored. SQL Editor allows you to create and edit SQL text, prepare and execute selected queries. The On Startup feature allows you to control what tabs appear when you launch Navicat. If your Internet Service Provider (ISP) does not provide direct access to its server, Secure Tunneling Protocol (SSH) / HTTP is another solution. In a Telnet session, all communications, including username and password, are transmitted in plain-text, allowing anyone to listen-in on your session and steal passwords and other information. A comfort zone is a beautiful place, but nothing ever grows there. With its well-designed Graphical User Interface(GUI), Navicat lets you quickly and easily create, organize, access and share information in a secure and easy way. You cannot save people, you can just love them. Secure Sockets Layer(SSL) is a protocol for transmitting private documents via the Internet. Such sessions are also susceptible to session hijacking, where a malicious user takes over your session once you have authenticated. You cannot save people, you can just love them. It wasn’t raining when Noah built the ark. After comparing data, the window shows the number of records that will be inserted, updated or deleted in the target. All the Navicat Cloud objects are located under different projects. You can share the project to other Navicat Cloud accounts for collaboration. Navicat Monitor is a safe, simple and agentless remote server monitoring tool that is packed with powerful features to make your monitoring effective as possible. You cannot save people, you can just love them. If the plan doesn’t work, change the plan, but never the goal. Navicat 15 has added support for the system-wide dark mode. After logged in the Navicat Cloud feature, the Navigation pane will be divided into Navicat Cloud and My Connections sections. In other words, Navicat provides the ability for data in different databases and/or schemas to be kept up-to-date so that each repository contains the same information. Difficult circumstances serve as a textbook of life for people. What you get by achieving your goals is not as important as what you become by achieving your goals. Navicat Monitor requires a repository to store alerts and metrics for historical analysis. HTTP Tunneling is a method for connecting to a server that uses the same protocol (http://) and the same port (port 80) as a web server does. Such sessions are also susceptible to session hijacking, where a malicious user takes over your session once you have authenticated. To successfully establish a new connection to local/remote server - no matter via SSL or SSH, set the database login information in the General tab. A man is not old until regrets take the place of dreams.', 0, 0, '2002-12-09 05:18:54', 0, 0, 4);
INSERT INTO `discuss_post` (`id`, `user_id`, `title`, `content`, `type`, `status`, `create_time`, `comment_count`, `score`, `type_id`) VALUES (14, '117', '搞懂 TypeScript 中的映射类型(Mapped Types)', 'Typically, it is employed as an encrypted version of Telnet. Navicat Monitor requires a repository to store alerts and metrics for historical analysis. To open a query using an external editor, control-click it and select Open with External Editor. You can set the file path of an external editor in Preferences. Typically, it is employed as an encrypted version of Telnet. Optimism is the one quality more associated with success and happiness than any other. To clear or reload various internal caches, flush tables, or acquire locks, control-click your connection in the Navigation pane and select Flush and choose the flush option. You must have the reload privilege to use this feature. Secure Sockets Layer(SSL) is a protocol for transmitting private documents via the Internet. In the middle of winter I at last discovered that there was in me an invincible summer. To connect to a database or schema, simply double-click it in the pane. Navicat is a multi-connections Database Administration tool allowing you to connect to MySQL, Oracle, PostgreSQL, SQLite, SQL Server, MariaDB and/or MongoDB databases, making database administration to multiple kinds of database so easy. To start working with your server in Navicat, you should first establish a connection or several connections using the Connection window. You cannot save people, you can just love them. It can also manage cloud databases such as Amazon Redshift, Amazon RDS, Alibaba Cloud. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs, yet easy to learn for users who are new to database server. Genius is an infinite capacity for taking pains. To connect to a database or schema, simply double-click it in the pane. I destroy my enemies when I make them my friends. It provides strong authentication and secure encrypted communications between two hosts, known as SSH Port Forwarding (Tunneling), over an insecure network. All journeys have secret destinations of which the traveler is unaware. You will succeed because most people are lazy. You must be the change you wish to see in the world. You can select any connections, objects or projects, and then select the corresponding buttons on the Information Pane. The Main Window consists of several toolbars and panes for you to work on connections, database objects and advanced tools. To get a secure connection, the first thing you need to do is to install OpenSSL Library and download Database Source. Navicat provides a wide range advanced features, such as compelling code editing capabilities, smart code-completion, SQL formatting, and more. Navicat Data Modeler is a powerful and cost-effective database design tool which helps you build high-quality conceptual, logical and physical data models. Optimism is the one quality more associated with success and happiness than any other. After logged in the Navicat Cloud feature, the Navigation pane will be divided into Navicat Cloud and My Connections sections. To clear or reload various internal caches, flush tables, or acquire locks, control-click your connection in the Navigation pane and select Flush and choose the flush option. You must have the reload privilege to use this feature. Navicat provides a wide range advanced features, such as compelling code editing capabilities, smart code-completion, SQL formatting, and more. A man is not old until regrets take the place of dreams. It can also manage cloud databases such as Amazon Redshift, Amazon RDS, Alibaba Cloud. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs, yet easy to learn for users who are new to database server. HTTP Tunneling is a method for connecting to a server that uses the same protocol (http://) and the same port (port 80) as a web server does. Navicat Monitor can be installed on any local computer or virtual machine and does not require any software installation on the servers being monitored. If it scares you, it might be a good thing to try. A comfort zone is a beautiful place, but nothing ever grows there. The past has no power over the present moment. It collects process metrics such as CPU load, RAM usage, and a variety of other resources over SSH/SNMP. If you wait, all that happens is you get older. It wasn’t raining when Noah built the ark. Success consists of going from failure to failure without loss of enthusiasm. It provides strong authentication and secure encrypted communications between two hosts, known as SSH Port Forwarding (Tunneling), over an insecure network. Navicat Data Modeler enables you to build high-quality conceptual, logical and physical data models for a wide variety of audiences. Navicat Cloud provides a cloud service for synchronizing connections, queries, model files and virtual group information from Navicat, other Navicat family members, different machines and different platforms. What you get by achieving your goals is not as important as what you become by achieving your goals. To get a secure connection, the first thing you need to do is to install OpenSSL Library and download Database Source. In a Telnet session, all communications, including username and password, are transmitted in plain-text, allowing anyone to listen-in on your session and steal passwords and other information. The Navigation pane employs tree structure which allows you to take action upon the database and their objects through their pop-up menus quickly and easily. It collects process metrics such as CPU load, RAM usage, and a variety of other resources over SSH/SNMP. Navicat Cloud could not connect and access your databases. By which it means, it could only store your connection settings, queries, model files, and virtual group; your database passwords and data (e.g. tables, views, etc) will not be stored to Navicat Cloud. If the Show objects under schema in navigation pane option is checked at the Preferences window, all database objects are also displayed in the pane. Navicat is a multi-connections Database Administration tool allowing you to connect to MySQL, Oracle, PostgreSQL, SQLite, SQL Server, MariaDB and/or MongoDB databases, making database administration to multiple kinds of database so easy. It provides strong authentication and secure encrypted communications between two hosts, known as SSH Port Forwarding (Tunneling), over an insecure network. In the Objects tab, you can use the List List, Detail Detail and ER Diagram ER Diagram buttons to change the object view. Genius is an infinite capacity for taking pains. All the Navicat Cloud objects are located under different projects. You can share the project to other Navicat Cloud accounts for collaboration. Difficult circumstances serve as a textbook of life for people. Secure Sockets Layer(SSL) is a protocol for transmitting private documents via the Internet. The Main Window consists of several toolbars and panes for you to work on connections, database objects and advanced tools. To open a query using an external editor, control-click it and select Open with External Editor. You can set the file path of an external editor in Preferences. I will greet this day with love in my heart. All the Navicat Cloud objects are located under different projects. You can share the project to other Navicat Cloud accounts for collaboration. A comfort zone is a beautiful place, but nothing ever grows there. A man is not old until regrets take the place of dreams. If your Internet Service Provider (ISP) does not provide direct access to its server, Secure Tunneling Protocol (SSH) / HTTP is another solution. The Synchronize to Database function will give you a full picture of all database differences. In a Telnet session, all communications, including username and password, are transmitted in plain-text, allowing anyone to listen-in on your session and steal passwords and other information. Anyone who has never made a mistake has never tried anything new. Anyone who has ever made anything of importance was disciplined. Creativity is intelligence having fun. I destroy my enemies when I make them my friends. To clear or reload various internal caches, flush tables, or acquire locks, control-click your connection in the Navigation pane and select Flush and choose the flush option. You must have the reload privilege to use this feature. It provides strong authentication and secure encrypted communications between two hosts, known as SSH Port Forwarding (Tunneling), over an insecure network.', 0, 0, '2003-02-26 01:10:38', 0, 0, 4);
INSERT INTO `discuss_post` (`id`, `user_id`, `title`, `content`, `type`, `status`, `create_time`, `comment_count`, `score`, `type_id`) VALUES (15, '118', 'ECMAScript 新提案:.findLast()和.findLastIndex()从尾到头搜索数组', 'A man’s best friends are his ten fingers. To connect to a database or schema, simply double-click it in the pane. Instead of wondering when your next vacation is, maybe you should set up a life you don’t need to escape from. HTTP Tunneling is a method for connecting to a server that uses the same protocol (http://) and the same port (port 80) as a web server does. To successfully establish a new connection to local/remote server - no matter via SSL or SSH, set the database login information in the General tab. HTTP Tunneling is a method for connecting to a server that uses the same protocol (http://) and the same port (port 80) as a web server does. How we spend our days is, of course, how we spend our lives. To open a query using an external editor, control-click it and select Open with External Editor. You can set the file path of an external editor in Preferences. The first step is as good as half over. Navicat is a multi-connections Database Administration tool allowing you to connect to MySQL, Oracle, PostgreSQL, SQLite, SQL Server, MariaDB and/or MongoDB databases, making database administration to multiple kinds of database so easy. The first step is as good as half over. To successfully establish a new connection to local/remote server - no matter via SSL or SSH, set the database login information in the General tab. After logged in the Navicat Cloud feature, the Navigation pane will be divided into Navicat Cloud and My Connections sections. If opportunity doesn’t knock, build a door. To get a secure connection, the first thing you need to do is to install OpenSSL Library and download Database Source. With its well-designed Graphical User Interface(GUI), Navicat lets you quickly and easily create, organize, access and share information in a secure and easy way. The repository database can be an existing MySQL, MariaDB, PostgreSQL, SQL Server, or Amazon RDS instance. I destroy my enemies when I make them my friends. The reason why a great man is great is that he resolves to be a great man. Navicat Data Modeler is a powerful and cost-effective database design tool which helps you build high-quality conceptual, logical and physical data models. To clear or reload various internal caches, flush tables, or acquire locks, control-click your connection in the Navigation pane and select Flush and choose the flush option. You must have the reload privilege to use this feature. You cannot save people, you can just love them. It wasn’t raining when Noah built the ark. In the middle of winter I at last discovered that there was in me an invincible summer. Navicat Monitor is a safe, simple and agentless remote server monitoring tool that is packed with powerful features to make your monitoring effective as possible. You can select any connections, objects or projects, and then select the corresponding buttons on the Information Pane. In other words, Navicat provides the ability for data in different databases and/or schemas to be kept up-to-date so that each repository contains the same information. Instead of wondering when your next vacation is, maybe you should set up a life you don’t need to escape from. Navicat Monitor can be installed on any local computer or virtual machine and does not require any software installation on the servers being monitored. The repository database can be an existing MySQL, MariaDB, PostgreSQL, SQL Server, or Amazon RDS instance. It collects process metrics such as CPU load, RAM usage, and a variety of other resources over SSH/SNMP. Remember that failure is an event, not a person. Creativity is intelligence having fun. Difficult circumstances serve as a textbook of life for people. Optimism is the one quality more associated with success and happiness than any other. Navicat Cloud provides a cloud service for synchronizing connections, queries, model files and virtual group information from Navicat, other Navicat family members, different machines and different platforms. Creativity is intelligence having fun. To successfully establish a new connection to local/remote server - no matter via SSL, SSH or HTTP, set the database login information in the General tab. If it scares you, it might be a good thing to try. Navicat Cloud provides a cloud service for synchronizing connections, queries, model files and virtual group information from Navicat, other Navicat family members, different machines and different platforms. HTTP Tunneling is a method for connecting to a server that uses the same protocol (http://) and the same port (port 80) as a web server does. HTTP Tunneling is a method for connecting to a server that uses the same protocol (http://) and the same port (port 80) as a web server does. Navicat Cloud could not connect and access your databases. By which it means, it could only store your connection settings, queries, model files, and virtual group; your database passwords and data (e.g. tables, views, etc) will not be stored to Navicat Cloud. It can also manage cloud databases such as Amazon Redshift, Amazon RDS, Alibaba Cloud. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs, yet easy to learn for users who are new to database server.', 0, 0, '2002-09-17 11:45:48', 0, 3, 4);
INSERT INTO `discuss_post` (`id`, `user_id`, `title`, `content`, `type`, `status`, `create_time`, `comment_count`, `score`, `type_id`) VALUES (16, '119', 'Ms.', 'A man’s best friends are his ten fingers. Navicat provides a wide range advanced features, such as compelling code editing capabilities, smart code-completion, SQL formatting, and more. There is no way to happiness. Happiness is the way. Navicat Cloud could not connect and access your databases. By which it means, it could only store your connection settings, queries, model files, and virtual group; your database passwords and data (e.g. tables, views, etc) will not be stored to Navicat Cloud. If you wait, all that happens is you get older. Optimism is the one quality more associated with success and happiness than any other. Secure Sockets Layer(SSL) is a protocol for transmitting private documents via the Internet. Navicat Cloud could not connect and access your databases. By which it means, it could only store your connection settings, queries, model files, and virtual group; your database passwords and data (e.g. tables, views, etc) will not be stored to Navicat Cloud. Navicat Data Modeler enables you to build high-quality conceptual, logical and physical data models for a wide variety of audiences. The past has no power over the present moment. To successfully establish a new connection to local/remote server - no matter via SSL, SSH or HTTP, set the database login information in the General tab. The Information Pane shows the detailed object information, project activities, the DDL of database objects, object dependencies, membership of users/roles and preview. Remember that failure is an event, not a person. Navicat authorizes you to make connection to remote servers running on different platforms (i.e. Windows, macOS, Linux and UNIX), and supports PAM and GSSAPI authentication. The Synchronize to Database function will give you a full picture of all database differences. Navicat Data Modeler is a powerful and cost-effective database design tool which helps you build high-quality conceptual, logical and physical data models. Such sessions are also susceptible to session hijacking, where a malicious user takes over your session once you have authenticated. Monitored servers include MySQL, MariaDB and SQL Server, and compatible with cloud databases like Amazon RDS, Amazon Aurora, Oracle Cloud, Google Cloud and Microsoft Azure. You cannot save people, you can just love them. The Navigation pane employs tree structure which allows you to take action upon the database and their objects through their pop-up menus quickly and easily. Success consists of going from failure to failure without loss of enthusiasm. Sometimes you win, sometimes you learn. The On Startup feature allows you to control what tabs appear when you launch Navicat. Optimism is the one quality more associated with success and happiness than any other. In the middle of winter I at last discovered that there was in me an invincible summer. Navicat provides a wide range advanced features, such as compelling code editing capabilities, smart code-completion, SQL formatting, and more. To start working with your server in Navicat, you should first establish a connection or several connections using the Connection window. Navicat provides powerful tools for working with queries: Query Editor for editing the query text directly, and Query Builder, Find Builder or Aggregate Builder for building queries visually. There is no way to happiness. Happiness is the way. It is used while your ISPs do not allow direct connections, but allows establishing HTTP connections. A comfort zone is a beautiful place, but nothing ever grows there. Monitored servers include MySQL, MariaDB and SQL Server, and compatible with cloud databases like Amazon RDS, Amazon Aurora, Oracle Cloud, Google Cloud and Microsoft Azure. To connect to a database or schema, simply double-click it in the pane. Navicat authorizes you to make connection to remote servers running on different platforms (i.e. Windows, macOS, Linux and UNIX), and supports PAM and GSSAPI authentication. A comfort zone is a beautiful place, but nothing ever grows there. Always keep your eyes open. Keep watching. Because whatever you see can inspire you. Secure SHell (SSH) is a program to log in into another computer over a network, execute commands on a remote server, and move files from one machine to another. You will succeed because most people are lazy. Anyone who has ever made anything of importance was disciplined. It provides strong authentication and secure encrypted communications between two hosts, known as SSH Port Forwarding (Tunneling), over an insecure network. Such sessions are also susceptible to session hijacking, where a malicious user takes over your session once you have authenticated. With its well-designed Graphical User Interface(GUI), Navicat lets you quickly and easily create, organize, access and share information in a secure and easy way. You will succeed because most people are lazy. SQL Editor allows you to create and edit SQL text, prepare and execute selected queries. I may not have gone where I intended to go, but I think I have ended up where I needed to be. All the Navicat Cloud objects are located under different projects. You can share the project to other Navicat Cloud accounts for collaboration. The past has no power over the present moment. Genius is an infinite capacity for taking pains. Flexible settings enable you to set up a custom key for comparison and synchronization. If opportunity doesn’t knock, build a door. Optimism is the one quality more associated with success and happiness than any other. The Main Window consists of several toolbars and panes for you to work on connections, database objects and advanced tools. A man’s best friends are his ten fingers. I may not have gone where I intended to go, but I think I have ended up where I needed to be. Navicat Monitor can be installed on any local computer or virtual machine and does not require any software installation on the servers being monitored. A man is not old until regrets take the place of dreams. I may not have gone where I intended to go, but I think I have ended up where I needed to be. Anyone who has never made a mistake has never tried anything new. Navicat 15 has added support for the system-wide dark mode. You will succeed because most people are lazy. If opportunity doesn’t knock, build a door. Navicat Data Modeler enables you to build high-quality conceptual, logical and physical data models for a wide variety of audiences. The past has no power over the present moment. Flexible settings enable you to set up a custom key for comparison and synchronization. Instead of wondering when your next vacation is, maybe you should set up a life you don’t need to escape from. I may not have gone where I intended to go, but I think I have ended up where I needed to be. If opportunity doesn’t knock, build a door. Navicat Cloud could not connect and access your databases. By which it means, it could only store your connection settings, queries, model files, and virtual group; your database passwords and data (e.g. tables, views, etc) will not be stored to Navicat Cloud. Typically, it is employed as an encrypted version of Telnet. Typically, it is employed as an encrypted version of Telnet. Creativity is intelligence having fun. In other words, Navicat provides the ability for data in different databases and/or schemas to be kept up-to-date so that each repository contains the same information. If opportunity doesn’t knock, build a door. Import Wizard allows you to import data to tables/collections from CSV, TXT, XML, DBF and more. It can also manage cloud databases such as Amazon Redshift, Amazon RDS, Alibaba Cloud. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs, yet easy to learn for users who are new to database server. The reason why a great man is great is that he resolves to be a great man. I will greet this day with love in my heart. In a Telnet session, all communications, including username and password, are transmitted in plain-text, allowing anyone to listen-in on your session and steal passwords and other information. Navicat authorizes you to make connection to remote servers running on different platforms (i.e. Windows, macOS, Linux and UNIX), and supports PAM and GSSAPI authentication. Champions keep playing until they get it right. Navicat Monitor can be installed on any local computer or virtual machine and does not require any software installation on the servers being monitored. All journeys have secret destinations of which the traveler is unaware. In the middle of winter I at last discovered that there was in me an invincible summer. Success consists of going from failure to failure without loss of enthusiasm. Navicat Cloud could not connect and access your databases. By which it means, it could only store your connection settings, queries, model files, and virtual group; your database passwords and data (e.g. tables, views, etc) will not be stored to Navicat Cloud.', 0, 0, '2009-07-30 07:04:04', 0, 3, 4);
INSERT INTO `discuss_post` (`id`, `user_id`, `title`, `content`, `type`, `status`, `create_time`, `comment_count`, `score`, `type_id`) VALUES (17, '120', 'Mr.', 'All the Navicat Cloud objects are located under different projects. You can share the project to other Navicat Cloud accounts for collaboration. I destroy my enemies when I make them my friends. You will succeed because most people are lazy. Navicat Data Modeler enables you to build high-quality conceptual, logical and physical data models for a wide variety of audiences. Monitored servers include MySQL, MariaDB and SQL Server, and compatible with cloud databases like Amazon RDS, Amazon Aurora, Oracle Cloud, Google Cloud and Microsoft Azure. In other words, Navicat provides the ability for data in different databases and/or schemas to be kept up-to-date so that each repository contains the same information. Secure Sockets Layer(SSL) is a protocol for transmitting private documents via the Internet. Creativity is intelligence having fun. A man is not old until regrets take the place of dreams. You will succeed because most people are lazy. Secure SHell (SSH) is a program to log in into another computer over a network, execute commands on a remote server, and move files from one machine to another. It is used while your ISPs do not allow direct connections, but allows establishing HTTP connections. To get a secure connection, the first thing you need to do is to install OpenSSL Library and download Database Source. Optimism is the one quality more associated with success and happiness than any other. Success consists of going from failure to failure without loss of enthusiasm. After logged in the Navicat Cloud feature, the Navigation pane will be divided into Navicat Cloud and My Connections sections. I will greet this day with love in my heart. Navicat authorizes you to make connection to remote servers running on different platforms (i.e. Windows, macOS, Linux and UNIX), and supports PAM and GSSAPI authentication. The Synchronize to Database function will give you a full picture of all database differences. Remember that failure is an event, not a person. Navicat allows you to transfer data from one database and/or schema to another with detailed analytical process. Anyone who has ever made anything of importance was disciplined. Navicat provides a wide range advanced features, such as compelling code editing capabilities, smart code-completion, SQL formatting, and more. A man’s best friends are his ten fingers. Optimism is the one quality more associated with success and happiness than any other. To successfully establish a new connection to local/remote server - no matter via SSL, SSH or HTTP, set the database login information in the General tab. If you wait, all that happens is you get older. It collects process metrics such as CPU load, RAM usage, and a variety of other resources over SSH/SNMP. You will succeed because most people are lazy. Actually it is just in an idea when feel oneself can achieve and cannot achieve. Flexible settings enable you to set up a custom key for comparison and synchronization. Genius is an infinite capacity for taking pains. Navicat Data Modeler enables you to build high-quality conceptual, logical and physical data models for a wide variety of audiences.', 0, 0, '2021-01-09 12:09:13', 0, 3, 4);
INSERT INTO `discuss_post` (`id`, `user_id`, `title`, `content`, `type`, `status`, `create_time`, `comment_count`, `score`, `type_id`) VALUES (18, '121', 'Mr.', 'In the middle of winter I at last discovered that there was in me an invincible summer. If you wait, all that happens is you get older. Navicat Data Modeler is a powerful and cost-effective database design tool which helps you build high-quality conceptual, logical and physical data models. To start working with your server in Navicat, you should first establish a connection or several connections using the Connection window. If the plan doesn’t work, change the plan, but never the goal. The On Startup feature allows you to control what tabs appear when you launch Navicat. What you get by achieving your goals is not as important as what you become by achieving your goals. Import Wizard allows you to import data to tables/collections from CSV, TXT, XML, DBF and more. Navicat Data Modeler is a powerful and cost-effective database design tool which helps you build high-quality conceptual, logical and physical data models. You cannot save people, you can just love them. To successfully establish a new connection to local/remote server - no matter via SSL, SSH or HTTP, set the database login information in the General tab. In the middle of winter I at last discovered that there was in me an invincible summer. The On Startup feature allows you to control what tabs appear when you launch Navicat. The past has no power over the present moment. A man is not old until regrets take the place of dreams.', 0, 0, '2019-01-05 07:29:21', 0, 3, 4);
INSERT INTO `discuss_post` (`id`, `user_id`, `title`, `content`, `type`, `status`, `create_time`, `comment_count`, `score`, `type_id`) VALUES (19, '122', 'Ms.', 'Typically, it is employed as an encrypted version of Telnet. Actually it is just in an idea when feel oneself can achieve and cannot achieve. Navicat Cloud provides a cloud service for synchronizing connections, queries, model files and virtual group information from Navicat, other Navicat family members, different machines and different platforms. Navicat 15 has added support for the system-wide dark mode. You will succeed because most people are lazy. The Synchronize to Database function will give you a full picture of all database differences. Success consists of going from failure to failure without loss of enthusiasm. To start working with your server in Navicat, you should first establish a connection or several connections using the Connection window. I may not have gone where I intended to go, but I think I have ended up where I needed to be. With its well-designed Graphical User Interface(GUI), Navicat lets you quickly and easily create, organize, access and share information in a secure and easy way. How we spend our days is, of course, how we spend our lives. Anyone who has ever made anything of importance was disciplined. To open a query using an external editor, control-click it and select Open with External Editor. You can set the file path of an external editor in Preferences. To open a query using an external editor, control-click it and select Open with External Editor. You can set the file path of an external editor in Preferences. To connect to a database or schema, simply double-click it in the pane. Flexible settings enable you to set up a custom key for comparison and synchronization. It provides strong authentication and secure encrypted communications between two hosts, known as SSH Port Forwarding (Tunneling), over an insecure network. With its well-designed Graphical User Interface(GUI), Navicat lets you quickly and easily create, organize, access and share information in a secure and easy way. Sometimes you win, sometimes you learn. Navicat Data Modeler is a powerful and cost-effective database design tool which helps you build high-quality conceptual, logical and physical data models. I will greet this day with love in my heart. To get a secure connection, the first thing you need to do is to install OpenSSL Library and download Database Source. HTTP Tunneling is a method for connecting to a server that uses the same protocol (http://) and the same port (port 80) as a web server does. The Main Window consists of several toolbars and panes for you to work on connections, database objects and advanced tools. You will succeed because most people are lazy. Monitored servers include MySQL, MariaDB and SQL Server, and compatible with cloud databases like Amazon RDS, Amazon Aurora, Oracle Cloud, Google Cloud and Microsoft Azure. Monitored servers include MySQL, MariaDB and SQL Server, and compatible with cloud databases like Amazon RDS, Amazon Aurora, Oracle Cloud, Google Cloud and Microsoft Azure. A comfort zone is a beautiful place, but nothing ever grows there. If it scares you, it might be a good thing to try. To open a query using an external editor, control-click it and select Open with External Editor. You can set the file path of an external editor in Preferences. Navicat Monitor requires a repository to store alerts and metrics for historical analysis. The On Startup feature allows you to control what tabs appear when you launch Navicat. Creativity is intelligence having fun. HTTP Tunneling is a method for connecting to a server that uses the same protocol (http://) and the same port (port 80) as a web server does. Navicat Monitor is a safe, simple and agentless remote server monitoring tool that is packed with powerful features to make your monitoring effective as possible. Typically, it is employed as an encrypted version of Telnet.', 0, 0, '2000-06-26 06:09:57', 0, 3, 4);
INSERT INTO `discuss_post` (`id`, `user_id`, `title`, `content`, `type`, `status`, `create_time`, `comment_count`, `score`, `type_id`) VALUES (20, '123', 'Ms.', 'You will succeed because most people are lazy. How we spend our days is, of course, how we spend our lives. A query is used to extract data from the database in a readable format according to the user\'s request. To connect to a database or schema, simply double-click it in the pane. Genius is an infinite capacity for taking pains. Navicat Data Modeler is a powerful and cost-effective database design tool which helps you build high-quality conceptual, logical and physical data models. You cannot save people, you can just love them. Genius is an infinite capacity for taking pains. Remember that failure is an event, not a person. The On Startup feature allows you to control what tabs appear when you launch Navicat. Difficult circumstances serve as a textbook of life for people. In the Objects tab, you can use the List List, Detail Detail and ER Diagram ER Diagram buttons to change the object view. Monitored servers include MySQL, MariaDB and SQL Server, and compatible with cloud databases like Amazon RDS, Amazon Aurora, Oracle Cloud, Google Cloud and Microsoft Azure. Navicat provides a wide range advanced features, such as compelling code editing capabilities, smart code-completion, SQL formatting, and more. In the middle of winter I at last discovered that there was in me an invincible summer.', 0, 0, '2003-11-30 22:49:38', 0, 3, 4);
INSERT INTO `discuss_post` (`id`, `user_id`, `title`, `content`, `type`, `status`, `create_time`, `comment_count`, `score`, `type_id`) VALUES (21, '124', 'Ms.', 'If the plan doesn’t work, change the plan, but never the goal. Navicat Monitor is a safe, simple and agentless remote server monitoring tool that is packed with powerful features to make your monitoring effective as possible. Import Wizard allows you to import data to tables/collections from CSV, TXT, XML, DBF and more. Anyone who has ever made anything of importance was disciplined. It wasn’t raining when Noah built the ark. Genius is an infinite capacity for taking pains. To start working with your server in Navicat, you should first establish a connection or several connections using the Connection window. A comfort zone is a beautiful place, but nothing ever grows there. To connect to a database or schema, simply double-click it in the pane. All journeys have secret destinations of which the traveler is unaware. You cannot save people, you can just love them. Optimism is the one quality more associated with success and happiness than any other. Import Wizard allows you to import data to tables/collections from CSV, TXT, XML, DBF and more. Navicat allows you to transfer data from one database and/or schema to another with detailed analytical process. Anyone who has never made a mistake has never tried anything new. The Main Window consists of several toolbars and panes for you to work on connections, database objects and advanced tools. To successfully establish a new connection to local/remote server - no matter via SSL or SSH, set the database login information in the General tab. Navicat Monitor is a safe, simple and agentless remote server monitoring tool that is packed with powerful features to make your monitoring effective as possible. Sometimes you win, sometimes you learn. All the Navicat Cloud objects are located under different projects. You can share the project to other Navicat Cloud accounts for collaboration. SQL Editor allows you to create and edit SQL text, prepare and execute selected queries. After comparing data, the window shows the number of records that will be inserted, updated or deleted in the target. The On Startup feature allows you to control what tabs appear when you launch Navicat. It can also manage cloud databases such as Amazon Redshift, Amazon RDS, Alibaba Cloud. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs, yet easy to learn for users who are new to database server. Monitored servers include MySQL, MariaDB and SQL Server, and compatible with cloud databases like Amazon RDS, Amazon Aurora, Oracle Cloud, Google Cloud and Microsoft Azure. Navicat provides a wide range advanced features, such as compelling code editing capabilities, smart code-completion, SQL formatting, and more.', 0, 0, '2010-04-02 11:38:00', 0, 3, 5);
INSERT INTO `discuss_post` (`id`, `user_id`, `title`, `content`, `type`, `status`, `create_time`, `comment_count`, `score`, `type_id`) VALUES (22, '125', 'Ms.', 'In other words, Navicat provides the ability for data in different databases and/or schemas to be kept up-to-date so that each repository contains the same information. Export Wizard allows you to export data from tables, collections, views, or query results to any available formats. To connect to a database or schema, simply double-click it in the pane. After comparing data, the window shows the number of records that will be inserted, updated or deleted in the target. I may not have gone where I intended to go, but I think I have ended up where I needed to be. Secure Sockets Layer(SSL) is a protocol for transmitting private documents via the Internet. Actually it is just in an idea when feel oneself can achieve and cannot achieve. The Main Window consists of several toolbars and panes for you to work on connections, database objects and advanced tools. It can also manage cloud databases such as Amazon Redshift, Amazon RDS, Alibaba Cloud. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs, yet easy to learn for users who are new to database server. The past has no power over the present moment. Instead of wondering when your next vacation is, maybe you should set up a life you don’t need to escape from. The Main Window consists of several toolbars and panes for you to work on connections, database objects and advanced tools. A query is used to extract data from the database in a readable format according to the user\'s request. If the Show objects under schema in navigation pane option is checked at the Preferences window, all database objects are also displayed in the pane. Navicat provides powerful tools for working with queries: Query Editor for editing the query text directly, and Query Builder, Find Builder or Aggregate Builder for building queries visually. You cannot save people, you can just love them. The Main Window consists of several toolbars and panes for you to work on connections, database objects and advanced tools. You will succeed because most people are lazy. A comfort zone is a beautiful place, but nothing ever grows there. After comparing data, the window shows the number of records that will be inserted, updated or deleted in the target. In other words, Navicat provides the ability for data in different databases and/or schemas to be kept up-to-date so that each repository contains the same information. SSH serves to prevent such vulnerabilities and allows you to access a remote server\'s shell without compromising security. It can also manage cloud databases such as Amazon Redshift, Amazon RDS, Alibaba Cloud. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs, yet easy to learn for users who are new to database server. Actually it is just in an idea when feel oneself can achieve and cannot achieve. The repository database can be an existing MySQL, MariaDB, PostgreSQL, SQL Server, or Amazon RDS instance. A query is used to extract data from the database in a readable format according to the user\'s request. Always keep your eyes open. Keep watching. Because whatever you see can inspire you. With its well-designed Graphical User Interface(GUI), Navicat lets you quickly and easily create, organize, access and share information in a secure and easy way. Navicat is a multi-connections Database Administration tool allowing you to connect to MySQL, Oracle, PostgreSQL, SQLite, SQL Server, MariaDB and/or MongoDB databases, making database administration to multiple kinds of database so easy. Secure SHell (SSH) is a program to log in into another computer over a network, execute commands on a remote server, and move files from one machine to another. Navicat Cloud provides a cloud service for synchronizing connections, queries, model files and virtual group information from Navicat, other Navicat family members, different machines and different platforms. In the middle of winter I at last discovered that there was in me an invincible summer.', 0, 0, '2019-09-19 21:49:08', 0, 3, 8);
INSERT INTO `discuss_post` (`id`, `user_id`, `title`, `content`, `type`, `status`, `create_time`, `comment_count`, `score`, `type_id`) VALUES (23, '126', 'Mrs.', 'Navicat authorizes you to make connection to remote servers running on different platforms (i.e. Windows, macOS, Linux and UNIX), and supports PAM and GSSAPI authentication. To start working with your server in Navicat, you should first establish a connection or several connections using the Connection window. To get a secure connection, the first thing you need to do is to install OpenSSL Library and download Database Source. Flexible settings enable you to set up a custom key for comparison and synchronization. The Main Window consists of several toolbars and panes for you to work on connections, database objects and advanced tools. Navicat Monitor can be installed on any local computer or virtual machine and does not require any software installation on the servers being monitored. If opportunity doesn’t knock, build a door. If the plan doesn’t work, change the plan, but never the goal. A comfort zone is a beautiful place, but nothing ever grows there. I may not have gone where I intended to go, but I think I have ended up where I needed to be. Import Wizard allows you to import data to tables/collections from CSV, TXT, XML, DBF and more. Typically, it is employed as an encrypted version of Telnet. Navicat Cloud provides a cloud service for synchronizing connections, queries, model files and virtual group information from Navicat, other Navicat family members, different machines and different platforms. The Main Window consists of several toolbars and panes for you to work on connections, database objects and advanced tools. Navicat Monitor requires a repository to store alerts and metrics for historical analysis. Export Wizard allows you to export data from tables, collections, views, or query results to any available formats. Export Wizard allows you to export data from tables, collections, views, or query results to any available formats. If you wait, all that happens is you get older. If the plan doesn’t work, change the plan, but never the goal. Navicat Monitor requires a repository to store alerts and metrics for historical analysis. Navicat Cloud provides a cloud service for synchronizing connections, queries, model files and virtual group information from Navicat, other Navicat family members, different machines and different platforms. The Main Window consists of several toolbars and panes for you to work on connections, database objects and advanced tools. To get a secure connection, the first thing you need to do is to install OpenSSL Library and download Database Source. The Information Pane shows the detailed object information, project activities, the DDL of database objects, object dependencies, membership of users/roles and preview. To successfully establish a new connection to local/remote server - no matter via SSL, SSH or HTTP, set the database login information in the General tab. If it scares you, it might be a good thing to try. Flexible settings enable you to set up a custom key for comparison and synchronization. You will succeed because most people are lazy. Creativity is intelligence having fun. In a Telnet session, all communications, including username and password, are transmitted in plain-text, allowing anyone to listen-in on your session and steal passwords and other information. SSH serves to prevent such vulnerabilities and allows you to access a remote server\'s shell without compromising security. After comparing data, the window shows the number of records that will be inserted, updated or deleted in the target. Navicat provides a wide range advanced features, such as compelling code editing capabilities, smart code-completion, SQL formatting, and more.', 0, 0, '2007-08-04 22:49:05', 0, 3, 5);
INSERT INTO `discuss_post` (`id`, `user_id`, `title`, `content`, `type`, `status`, `create_time`, `comment_count`, `score`, `type_id`) VALUES (24, '127', 'Prof.', 'If the Show objects under schema in navigation pane option is checked at the Preferences window, all database objects are also displayed in the pane. Navicat Monitor can be installed on any local computer or virtual machine and does not require any software installation on the servers being monitored. If the Show objects under schema in navigation pane option is checked at the Preferences window, all database objects are also displayed in the pane. It provides strong authentication and secure encrypted communications between two hosts, known as SSH Port Forwarding (Tunneling), over an insecure network. In a Telnet session, all communications, including username and password, are transmitted in plain-text, allowing anyone to listen-in on your session and steal passwords and other information. It is used while your ISPs do not allow direct connections, but allows establishing HTTP connections. If opportunity doesn’t knock, build a door. In the middle of winter I at last discovered that there was in me an invincible summer. If your Internet Service Provider (ISP) does not provide direct access to its server, Secure Tunneling Protocol (SSH) / HTTP is another solution. Remember that failure is an event, not a person. It provides strong authentication and secure encrypted communications between two hosts, known as SSH Port Forwarding (Tunneling), over an insecure network. A query is used to extract data from the database in a readable format according to the user\'s request. Optimism is the one quality more associated with success and happiness than any other. To get a secure connection, the first thing you need to do is to install OpenSSL Library and download Database Source. To successfully establish a new connection to local/remote server - no matter via SSL or SSH, set the database login information in the General tab. Sometimes you win, sometimes you learn. Navicat is a multi-connections Database Administration tool allowing you to connect to MySQL, Oracle, PostgreSQL, SQLite, SQL Server, MariaDB and/or MongoDB databases, making database administration to multiple kinds of database so easy. The Information Pane shows the detailed object information, project activities, the DDL of database objects, object dependencies, membership of users/roles and preview. It can also manage cloud databases such as Amazon Redshift, Amazon RDS, Alibaba Cloud. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs, yet easy to learn for users who are new to database server. Navicat Data Modeler enables you to build high-quality conceptual, logical and physical data models for a wide variety of audiences. The Information Pane shows the detailed object information, project activities, the DDL of database objects, object dependencies, membership of users/roles and preview. Navicat Monitor can be installed on any local computer or virtual machine and does not require any software installation on the servers being monitored. The past has no power over the present moment. You can select any connections, objects or projects, and then select the corresponding buttons on the Information Pane. A query is used to extract data from the database in a readable format according to the user\'s request. The Synchronize to Database function will give you a full picture of all database differences. You will succeed because most people are lazy. It wasn’t raining when Noah built the ark. Navicat Monitor requires a repository to store alerts and metrics for historical analysis. Difficult circumstances serve as a textbook of life for people. Navicat Monitor requires a repository to store alerts and metrics for historical analysis. If opportunity doesn’t knock, build a door. You will succeed because most people are lazy. To get a secure connection, the first thing you need to do is to install OpenSSL Library and download Database Source. How we spend our days is, of course, how we spend our lives. I will greet this day with love in my heart. The Main Window consists of several toolbars and panes for you to work on connections, database objects and advanced tools. All journeys have secret destinations of which the traveler is unaware. In the Objects tab, you can use the List List, Detail Detail and ER Diagram ER Diagram buttons to change the object view. I will greet this day with love in my heart. In the Objects tab, you can use the List List, Detail Detail and ER Diagram ER Diagram buttons to change the object view. Export Wizard allows you to export data from tables, collections, views, or query results to any available formats. The Information Pane shows the detailed object information, project activities, the DDL of database objects, object dependencies, membership of users/roles and preview. You must be the change you wish to see in the world. I destroy my enemies when I make them my friends. In the middle of winter I at last discovered that there was in me an invincible summer. If your Internet Service Provider (ISP) does not provide direct access to its server, Secure Tunneling Protocol (SSH) / HTTP is another solution. To successfully establish a new connection to local/remote server - no matter via SSL, SSH or HTTP, set the database login information in the General tab. If opportunity doesn’t knock, build a door. Navicat Cloud provides a cloud service for synchronizing connections, queries, model files and virtual group information from Navicat, other Navicat family members, different machines and different platforms. I will greet this day with love in my heart. Import Wizard allows you to import data to tables/collections from CSV, TXT, XML, DBF and more. Genius is an infinite capacity for taking pains. Navicat Cloud could not connect and access your databases. By which it means, it could only store your connection settings, queries, model files, and virtual group; your database passwords and data (e.g. tables, views, etc) will not be stored to Navicat Cloud. You cannot save people, you can just love them. All the Navicat Cloud objects are located under different projects. You can share the project to other Navicat Cloud accounts for collaboration. Navicat Data Modeler is a powerful and cost-effective database design tool which helps you build high-quality conceptual, logical and physical data models. All journeys have secret destinations of which the traveler is unaware. Navicat Cloud could not connect and access your databases. By which it means, it could only store your connection settings, queries, model files, and virtual group; your database passwords and data (e.g. tables, views, etc) will not be stored to Navicat Cloud. A man is not old until regrets take the place of dreams. The first step is as good as half over. Import Wizard allows you to import data to tables/collections from CSV, TXT, XML, DBF and more. The On Startup feature allows you to control what tabs appear when you launch Navicat. Navicat Cloud provides a cloud service for synchronizing connections, queries, model files and virtual group information from Navicat, other Navicat family members, different machines and different platforms. All the Navicat Cloud objects are located under different projects. You can share the project to other Navicat Cloud accounts for collaboration. With its well-designed Graphical User Interface(GUI), Navicat lets you quickly and easily create, organize, access and share information in a secure and easy way. All the Navicat Cloud objects are located under different projects. You can share the project to other Navicat Cloud accounts for collaboration. Import Wizard allows you to import data to tables/collections from CSV, TXT, XML, DBF and more. Optimism is the one quality more associated with success and happiness than any other. It wasn’t raining when Noah built the ark. I may not have gone where I intended to go, but I think I have ended up where I needed to be. You must be the change you wish to see in the world. To clear or reload various internal caches, flush tables, or acquire locks, control-click your connection in the Navigation pane and select Flush and choose the flush option. You must have the reload privilege to use this feature. You cannot save people, you can just love them. The Navigation pane employs tree structure which allows you to take action upon the database and their objects through their pop-up menus quickly and easily. Champions keep playing until they get it right. With its well-designed Graphical User Interface(GUI), Navicat lets you quickly and easily create, organize, access and share information in a secure and easy way. If opportunity doesn’t knock, build a door. A man’s best friends are his ten fingers. Anyone who has ever made anything of importance was disciplined. It can also manage cloud databases such as Amazon Redshift, Amazon RDS, Alibaba Cloud. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs, yet easy to learn for users who are new to database server. Navicat Monitor can be installed on any local computer or virtual machine and does not require any software installation on the servers being monitored.', 0, 0, '2004-02-25 07:22:43', 0, 0, 5);
INSERT INTO `discuss_post` (`id`, `user_id`, `title`, `content`, `type`, `status`, `create_time`, `comment_count`, `score`, `type_id`) VALUES (25, '128', 'Mrs.', 'It collects process metrics such as CPU load, RAM usage, and a variety of other resources over SSH/SNMP. Remember that failure is an event, not a person. In the Objects tab, you can use the List List, Detail Detail and ER Diagram ER Diagram buttons to change the object view. Secure SHell (SSH) is a program to log in into another computer over a network, execute commands on a remote server, and move files from one machine to another. Navicat Cloud provides a cloud service for synchronizing connections, queries, model files and virtual group information from Navicat, other Navicat family members, different machines and different platforms. The first step is as good as half over. I destroy my enemies when I make them my friends. Such sessions are also susceptible to session hijacking, where a malicious user takes over your session once you have authenticated. You must be the change you wish to see in the world. Navicat Cloud provides a cloud service for synchronizing connections, queries, model files and virtual group information from Navicat, other Navicat family members, different machines and different platforms. Navicat 15 has added support for the system-wide dark mode. A man is not old until regrets take the place of dreams. Actually it is just in an idea when feel oneself can achieve and cannot achieve. You must be the change you wish to see in the world. A query is used to extract data from the database in a readable format according to the user\'s request. Instead of wondering when your next vacation is, maybe you should set up a life you don’t need to escape from. To successfully establish a new connection to local/remote server - no matter via SSL or SSH, set the database login information in the General tab. If the Show objects under schema in navigation pane option is checked at the Preferences window, all database objects are also displayed in the pane. Navicat provides a wide range advanced features, such as compelling code editing capabilities, smart code-completion, SQL formatting, and more. You cannot save people, you can just love them. Export Wizard allows you to export data from tables, collections, views, or query results to any available formats. Such sessions are also susceptible to session hijacking, where a malicious user takes over your session once you have authenticated. Anyone who has never made a mistake has never tried anything new. It provides strong authentication and secure encrypted communications between two hosts, known as SSH Port Forwarding (Tunneling), over an insecure network. SSH serves to prevent such vulnerabilities and allows you to access a remote server\'s shell without compromising security. SSH serves to prevent such vulnerabilities and allows you to access a remote server\'s shell without compromising security. If it scares you, it might be a good thing to try. If opportunity doesn’t knock, build a door. I will greet this day with love in my heart. It collects process metrics such as CPU load, RAM usage, and a variety of other resources over SSH/SNMP. Always keep your eyes open. Keep watching. Because whatever you see can inspire you. I will greet this day with love in my heart. Navicat authorizes you to make connection to remote servers running on different platforms (i.e. Windows, macOS, Linux and UNIX), and supports PAM and GSSAPI authentication. Secure SHell (SSH) is a program to log in into another computer over a network, execute commands on a remote server, and move files from one machine to another. You must be the change you wish to see in the world. The Synchronize to Database function will give you a full picture of all database differences. HTTP Tunneling is a method for connecting to a server that uses the same protocol (http://) and the same port (port 80) as a web server does. Secure Sockets Layer(SSL) is a protocol for transmitting private documents via the Internet. The first step is as good as half over. If you wait, all that happens is you get older. Secure Sockets Layer(SSL) is a protocol for transmitting private documents via the Internet. With its well-designed Graphical User Interface(GUI), Navicat lets you quickly and easily create, organize, access and share information in a secure and easy way. In a Telnet session, all communications, including username and password, are transmitted in plain-text, allowing anyone to listen-in on your session and steal passwords and other information. Anyone who has never made a mistake has never tried anything new. The Information Pane shows the detailed object information, project activities, the DDL of database objects, object dependencies, membership of users/roles and preview. It provides strong authentication and secure encrypted communications between two hosts, known as SSH Port Forwarding (Tunneling), over an insecure network. To connect to a database or schema, simply double-click it in the pane. Anyone who has never made a mistake has never tried anything new. The Navigation pane employs tree structure which allows you to take action upon the database and their objects through their pop-up menus quickly and easily. If you wait, all that happens is you get older. The Information Pane shows the detailed object information, project activities, the DDL of database objects, object dependencies, membership of users/roles and preview. A query is used to extract data from the database in a readable format according to the user\'s request. Navicat provides a wide range advanced features, such as compelling code editing capabilities, smart code-completion, SQL formatting, and more. To successfully establish a new connection to local/remote server - no matter via SSL or SSH, set the database login information in the General tab. It can also manage cloud databases such as Amazon Redshift, Amazon RDS, Alibaba Cloud. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs, yet easy to learn for users who are new to database server. Secure SHell (SSH) is a program to log in into another computer over a network, execute commands on a remote server, and move files from one machine to another. HTTP Tunneling is a method for connecting to a server that uses the same protocol (http://) and the same port (port 80) as a web server does. The reason why a great man is great is that he resolves to be a great man. Anyone who has ever made anything of importance was disciplined. Always keep your eyes open. Keep watching. Because whatever you see can inspire you. The Navigation pane employs tree structure which allows you to take action upon the database and their objects through their pop-up menus quickly and easily. Flexible settings enable you to set up a custom key for comparison and synchronization. It collects process metrics such as CPU load, RAM usage, and a variety of other resources over SSH/SNMP. After comparing data, the window shows the number of records that will be inserted, updated or deleted in the target. Navicat provides powerful tools for working with queries: Query Editor for editing the query text directly, and Query Builder, Find Builder or Aggregate Builder for building queries visually. How we spend our days is, of course, how we spend our lives. The first step is as good as half over. The Main Window consists of several toolbars and panes for you to work on connections, database objects and advanced tools. A query is used to extract data from the database in a readable format according to the user\'s request. The Information Pane shows the detailed object information, project activities, the DDL of database objects, object dependencies, membership of users/roles and preview. With its well-designed Graphical User Interface(GUI), Navicat lets you quickly and easily create, organize, access and share information in a secure and easy way. I destroy my enemies when I make them my friends. Such sessions are also susceptible to session hijacking, where a malicious user takes over your session once you have authenticated. It provides strong authentication and secure encrypted communications between two hosts, known as SSH Port Forwarding (Tunneling), over an insecure network. If it scares you, it might be a good thing to try. To successfully establish a new connection to local/remote server - no matter via SSL or SSH, set the database login information in the General tab.', 0, 0, '2011-12-25 07:24:33', 0, 8, 5);
INSERT INTO `discuss_post` (`id`, `user_id`, `title`, `content`, `type`, `status`, `create_time`, `comment_count`, `score`, `type_id`) VALUES (26, '129', 'Prof.', 'Navicat Data Modeler enables you to build high-quality conceptual, logical and physical data models for a wide variety of audiences. A man is not old until regrets take the place of dreams. Flexible settings enable you to set up a custom key for comparison and synchronization. The Information Pane shows the detailed object information, project activities, the DDL of database objects, object dependencies, membership of users/roles and preview. The first step is as good as half over. Navicat Monitor requires a repository to store alerts and metrics for historical analysis. In the Objects tab, you can use the List List, Detail Detail and ER Diagram ER Diagram buttons to change the object view. Typically, it is employed as an encrypted version of Telnet. Optimism is the one quality more associated with success and happiness than any other. I destroy my enemies when I make them my friends. I may not have gone where I intended to go, but I think I have ended up where I needed to be. To clear or reload various internal caches, flush tables, or acquire locks, control-click your connection in the Navigation pane and select Flush and choose the flush option. You must have the reload privilege to use this feature. To clear or reload various internal caches, flush tables, or acquire locks, control-click your connection in the Navigation pane and select Flush and choose the flush option. You must have the reload privilege to use this feature. The Information Pane shows the detailed object information, project activities, the DDL of database objects, object dependencies, membership of users/roles and preview. Remember that failure is an event, not a person. It can also manage cloud databases such as Amazon Redshift, Amazon RDS, Alibaba Cloud. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs, yet easy to learn for users who are new to database server. I destroy my enemies when I make them my friends. Secure Sockets Layer(SSL) is a protocol for transmitting private documents via the Internet. Navicat 15 has added support for the system-wide dark mode. To open a query using an external editor, control-click it and select Open with External Editor. You can set the file path of an external editor in Preferences.', 0, 0, '2006-09-21 11:28:38', 0, 8, 5);
INSERT INTO `discuss_post` (`id`, `user_id`, `title`, `content`, `type`, `status`, `create_time`, `comment_count`, `score`, `type_id`) VALUES (27, '131', 'Mrs.', 'SQL Editor allows you to create and edit SQL text, prepare and execute selected queries. SSH serves to prevent such vulnerabilities and allows you to access a remote server\'s shell without compromising security. The Main Window consists of several toolbars and panes for you to work on connections, database objects and advanced tools. HTTP Tunneling is a method for connecting to a server that uses the same protocol (http://) and the same port (port 80) as a web server does. Secure SHell (SSH) is a program to log in into another computer over a network, execute commands on a remote server, and move files from one machine to another. A query is used to extract data from the database in a readable format according to the user\'s request. All journeys have secret destinations of which the traveler is unaware. It can also manage cloud databases such as Amazon Redshift, Amazon RDS, Alibaba Cloud. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs, yet easy to learn for users who are new to database server. Genius is an infinite capacity for taking pains. You cannot save people, you can just love them. Navicat Cloud could not connect and access your databases. By which it means, it could only store your connection settings, queries, model files, and virtual group; your database passwords and data (e.g. tables, views, etc) will not be stored to Navicat Cloud. It can also manage cloud databases such as Amazon Redshift, Amazon RDS, Alibaba Cloud. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs, yet easy to learn for users who are new to database server. Instead of wondering when your next vacation is, maybe you should set up a life you don’t need to escape from. All the Navicat Cloud objects are located under different projects. You can share the project to other Navicat Cloud accounts for collaboration. Navicat Monitor is a safe, simple and agentless remote server monitoring tool that is packed with powerful features to make your monitoring effective as possible. Navicat is a multi-connections Database Administration tool allowing you to connect to MySQL, Oracle, PostgreSQL, SQLite, SQL Server, MariaDB and/or MongoDB databases, making database administration to multiple kinds of database so easy. What you get by achieving your goals is not as important as what you become by achieving your goals. If opportunity doesn’t knock, build a door. I may not have gone where I intended to go, but I think I have ended up where I needed to be. Champions keep playing until they get it right. To clear or reload various internal caches, flush tables, or acquire locks, control-click your connection in the Navigation pane and select Flush and choose the flush option. You must have the reload privilege to use this feature. In a Telnet session, all communications, including username and password, are transmitted in plain-text, allowing anyone to listen-in on your session and steal passwords and other information. Instead of wondering when your next vacation is, maybe you should set up a life you don’t need to escape from. Anyone who has never made a mistake has never tried anything new. To clear or reload various internal caches, flush tables, or acquire locks, control-click your connection in the Navigation pane and select Flush and choose the flush option. You must have the reload privilege to use this feature. To clear or reload various internal caches, flush tables, or acquire locks, control-click your connection in the Navigation pane and select Flush and choose the flush option. You must have the reload privilege to use this feature. Remember that failure is an event, not a person. HTTP Tunneling is a method for connecting to a server that uses the same protocol (http://) and the same port (port 80) as a web server does. SSH serves to prevent such vulnerabilities and allows you to access a remote server\'s shell without compromising security. To start working with your server in Navicat, you should first establish a connection or several connections using the Connection window. SQL Editor allows you to create and edit SQL text, prepare and execute selected queries. Navicat Cloud could not connect and access your databases. By which it means, it could only store your connection settings, queries, model files, and virtual group; your database passwords and data (e.g. tables, views, etc) will not be stored to Navicat Cloud. Navicat Monitor is a safe, simple and agentless remote server monitoring tool that is packed with powerful features to make your monitoring effective as possible. With its well-designed Graphical User Interface(GUI), Navicat lets you quickly and easily create, organize, access and share information in a secure and easy way. It collects process metrics such as CPU load, RAM usage, and a variety of other resources over SSH/SNMP. Navicat Cloud could not connect and access your databases. By which it means, it could only store your connection settings, queries, model files, and virtual group; your database passwords and data (e.g. tables, views, etc) will not be stored to Navicat Cloud. Import Wizard allows you to import data to tables/collections from CSV, TXT, XML, DBF and more. Navicat Cloud provides a cloud service for synchronizing connections, queries, model files and virtual group information from Navicat, other Navicat family members, different machines and different platforms. Remember that failure is an event, not a person. If your Internet Service Provider (ISP) does not provide direct access to its server, Secure Tunneling Protocol (SSH) / HTTP is another solution. You must be the change you wish to see in the world. After logged in the Navicat Cloud feature, the Navigation pane will be divided into Navicat Cloud and My Connections sections. How we spend our days is, of course, how we spend our lives. A comfort zone is a beautiful place, but nothing ever grows there. To get a secure connection, the first thing you need to do is to install OpenSSL Library and download Database Source. After comparing data, the window shows the number of records that will be inserted, updated or deleted in the target. If the Show objects under schema in navigation pane option is checked at the Preferences window, all database objects are also displayed in the pane. Navicat Data Modeler enables you to build high-quality conceptual, logical and physical data models for a wide variety of audiences. The Navigation pane employs tree structure which allows you to take action upon the database and their objects through their pop-up menus quickly and easily. Export Wizard allows you to export data from tables, collections, views, or query results to any available formats. It wasn’t raining when Noah built the ark. A man is not old until regrets take the place of dreams. Export Wizard allows you to export data from tables, collections, views, or query results to any available formats. If the plan doesn’t work, change the plan, but never the goal. The Navigation pane employs tree structure which allows you to take action upon the database and their objects through their pop-up menus quickly and easily. SSH serves to prevent such vulnerabilities and allows you to access a remote server\'s shell without compromising security. If opportunity doesn’t knock, build a door. SSH serves to prevent such vulnerabilities and allows you to access a remote server\'s shell without compromising security. To connect to a database or schema, simply double-click it in the pane. In a Telnet session, all communications, including username and password, are transmitted in plain-text, allowing anyone to listen-in on your session and steal passwords and other information. Secure Sockets Layer(SSL) is a protocol for transmitting private documents via the Internet. If the plan doesn’t work, change the plan, but never the goal. Import Wizard allows you to import data to tables/collections from CSV, TXT, XML, DBF and more. To get a secure connection, the first thing you need to do is to install OpenSSL Library and download Database Source. To successfully establish a new connection to local/remote server - no matter via SSL, SSH or HTTP, set the database login information in the General tab. If your Internet Service Provider (ISP) does not provide direct access to its server, Secure Tunneling Protocol (SSH) / HTTP is another solution. It wasn’t raining when Noah built the ark. Navicat Cloud could not connect and access your databases. By which it means, it could only store your connection settings, queries, model files, and virtual group; your database passwords and data (e.g. tables, views, etc) will not be stored to Navicat Cloud.', 0, 0, '2007-09-24 18:42:21', 0, 8, 5);
INSERT INTO `discuss_post` (`id`, `user_id`, `title`, `content`, `type`, `status`, `create_time`, `comment_count`, `score`, `type_id`) VALUES (28, '132', 'Mrs.', 'Typically, it is employed as an encrypted version of Telnet. The reason why a great man is great is that he resolves to be a great man. To connect to a database or schema, simply double-click it in the pane. Navicat Data Modeler is a powerful and cost-effective database design tool which helps you build high-quality conceptual, logical and physical data models. In the Objects tab, you can use the List List, Detail Detail and ER Diagram ER Diagram buttons to change the object view. It is used while your ISPs do not allow direct connections, but allows establishing HTTP connections. Import Wizard allows you to import data to tables/collections from CSV, TXT, XML, DBF and more. What you get by achieving your goals is not as important as what you become by achieving your goals. It collects process metrics such as CPU load, RAM usage, and a variety of other resources over SSH/SNMP. Export Wizard allows you to export data from tables, collections, views, or query results to any available formats. In the middle of winter I at last discovered that there was in me an invincible summer. If it scares you, it might be a good thing to try. Navicat provides a wide range advanced features, such as compelling code editing capabilities, smart code-completion, SQL formatting, and more. The first step is as good as half over. Anyone who has never made a mistake has never tried anything new. To open a query using an external editor, control-click it and select Open with External Editor. You can set the file path of an external editor in Preferences.', 0, 0, '2004-05-16 01:34:33', 0, 8, 5);
INSERT INTO `discuss_post` (`id`, `user_id`, `title`, `content`, `type`, `status`, `create_time`, `comment_count`, `score`, `type_id`) VALUES (29, '133', 'Ms.', 'With its well-designed Graphical User Interface(GUI), Navicat lets you quickly and easily create, organize, access and share information in a secure and easy way. Success consists of going from failure to failure without loss of enthusiasm. A query is used to extract data from the database in a readable format according to the user\'s request. Remember that failure is an event, not a person. Champions keep playing until they get it right. In the Objects tab, you can use the List List, Detail Detail and ER Diagram ER Diagram buttons to change the object view. A comfort zone is a beautiful place, but nothing ever grows there. Typically, it is employed as an encrypted version of Telnet. How we spend our days is, of course, how we spend our lives. How we spend our days is, of course, how we spend our lives. In the middle of winter I at last discovered that there was in me an invincible summer. The Main Window consists of several toolbars and panes for you to work on connections, database objects and advanced tools. The repository database can be an existing MySQL, MariaDB, PostgreSQL, SQL Server, or Amazon RDS instance. To successfully establish a new connection to local/remote server - no matter via SSL or SSH, set the database login information in the General tab. Actually it is just in an idea when feel oneself can achieve and cannot achieve. It wasn’t raining when Noah built the ark. A query is used to extract data from the database in a readable format according to the user\'s request. I may not have gone where I intended to go, but I think I have ended up where I needed to be. Genius is an infinite capacity for taking pains. Remember that failure is an event, not a person. Navicat Cloud could not connect and access your databases. By which it means, it could only store your connection settings, queries, model files, and virtual group; your database passwords and data (e.g. tables, views, etc) will not be stored to Navicat Cloud. Monitored servers include MySQL, MariaDB and SQL Server, and compatible with cloud databases like Amazon RDS, Amazon Aurora, Oracle Cloud, Google Cloud and Microsoft Azure. After logged in the Navicat Cloud feature, the Navigation pane will be divided into Navicat Cloud and My Connections sections. In a Telnet session, all communications, including username and password, are transmitted in plain-text, allowing anyone to listen-in on your session and steal passwords and other information. In the middle of winter I at last discovered that there was in me an invincible summer. To successfully establish a new connection to local/remote server - no matter via SSL or SSH, set the database login information in the General tab. The Synchronize to Database function will give you a full picture of all database differences. Import Wizard allows you to import data to tables/collections from CSV, TXT, XML, DBF and more. Navicat Cloud provides a cloud service for synchronizing connections, queries, model files and virtual group information from Navicat, other Navicat family members, different machines and different platforms. Success consists of going from failure to failure without loss of enthusiasm. Navicat Cloud could not connect and access your databases. By which it means, it could only store your connection settings, queries, model files, and virtual group; your database passwords and data (e.g. tables, views, etc) will not be stored to Navicat Cloud. Navicat Monitor can be installed on any local computer or virtual machine and does not require any software installation on the servers being monitored. To successfully establish a new connection to local/remote server - no matter via SSL or SSH, set the database login information in the General tab. Remember that failure is an event, not a person. To successfully establish a new connection to local/remote server - no matter via SSL, SSH or HTTP, set the database login information in the General tab. I may not have gone where I intended to go, but I think I have ended up where I needed to be. Actually it is just in an idea when feel oneself can achieve and cannot achieve. It collects process metrics such as CPU load, RAM usage, and a variety of other resources over SSH/SNMP. To open a query using an external editor, control-click it and select Open with External Editor. You can set the file path of an external editor in Preferences. Monitored servers include MySQL, MariaDB and SQL Server, and compatible with cloud databases like Amazon RDS, Amazon Aurora, Oracle Cloud, Google Cloud and Microsoft Azure. SSH serves to prevent such vulnerabilities and allows you to access a remote server\'s shell without compromising security. It can also manage cloud databases such as Amazon Redshift, Amazon RDS, Alibaba Cloud. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs, yet easy to learn for users who are new to database server. Secure SHell (SSH) is a program to log in into another computer over a network, execute commands on a remote server, and move files from one machine to another. Import Wizard allows you to import data to tables/collections from CSV, TXT, XML, DBF and more. Navicat Cloud provides a cloud service for synchronizing connections, queries, model files and virtual group information from Navicat, other Navicat family members, different machines and different platforms. Navicat Data Modeler is a powerful and cost-effective database design tool which helps you build high-quality conceptual, logical and physical data models. Navicat Cloud provides a cloud service for synchronizing connections, queries, model files and virtual group information from Navicat, other Navicat family members, different machines and different platforms. Navicat 15 has added support for the system-wide dark mode. Secure SHell (SSH) is a program to log in into another computer over a network, execute commands on a remote server, and move files from one machine to another. Difficult circumstances serve as a textbook of life for people. It collects process metrics such as CPU load, RAM usage, and a variety of other resources over SSH/SNMP. Navicat Data Modeler enables you to build high-quality conceptual, logical and physical data models for a wide variety of audiences. Navicat Monitor is a safe, simple and agentless remote server monitoring tool that is packed with powerful features to make your monitoring effective as possible. Typically, it is employed as an encrypted version of Telnet. In the Objects tab, you can use the List List, Detail Detail and ER Diagram ER Diagram buttons to change the object view. It collects process metrics such as CPU load, RAM usage, and a variety of other resources over SSH/SNMP. Anyone who has ever made anything of importance was disciplined. I may not have gone where I intended to go, but I think I have ended up where I needed to be. You must be the change you wish to see in the world. Navicat Monitor requires a repository to store alerts and metrics for historical analysis. It collects process metrics such as CPU load, RAM usage, and a variety of other resources over SSH/SNMP. Flexible settings enable you to set up a custom key for comparison and synchronization.', 0, 0, '2000-02-16 21:33:30', 0, 8, 5);
INSERT INTO `discuss_post` (`id`, `user_id`, `title`, `content`, `type`, `status`, `create_time`, `comment_count`, `score`, `type_id`) VALUES (30, '134', 'Prof.', 'To successfully establish a new connection to local/remote server - no matter via SSL or SSH, set the database login information in the General tab. With its well-designed Graphical User Interface(GUI), Navicat lets you quickly and easily create, organize, access and share information in a secure and easy way. Monitored servers include MySQL, MariaDB and SQL Server, and compatible with cloud databases like Amazon RDS, Amazon Aurora, Oracle Cloud, Google Cloud and Microsoft Azure. Navicat Data Modeler enables you to build high-quality conceptual, logical and physical data models for a wide variety of audiences. The repository database can be an existing MySQL, MariaDB, PostgreSQL, SQL Server, or Amazon RDS instance. In other words, Navicat provides the ability for data in different databases and/or schemas to be kept up-to-date so that each repository contains the same information. Anyone who has ever made anything of importance was disciplined. The Main Window consists of several toolbars and panes for you to work on connections, database objects and advanced tools. I may not have gone where I intended to go, but I think I have ended up where I needed to be. The Main Window consists of several toolbars and panes for you to work on connections, database objects and advanced tools. You will succeed because most people are lazy. It wasn’t raining when Noah built the ark. Secure SHell (SSH) is a program to log in into another computer over a network, execute commands on a remote server, and move files from one machine to another. Sometimes you win, sometimes you learn. Navicat allows you to transfer data from one database and/or schema to another with detailed analytical process. To clear or reload various internal caches, flush tables, or acquire locks, control-click your connection in the Navigation pane and select Flush and choose the flush option. You must have the reload privilege to use this feature. A comfort zone is a beautiful place, but nothing ever grows there. Actually it is just in an idea when feel oneself can achieve and cannot achieve. To connect to a database or schema, simply double-click it in the pane. If it scares you, it might be a good thing to try. Navicat Monitor requires a repository to store alerts and metrics for historical analysis. Navicat provides a wide range advanced features, such as compelling code editing capabilities, smart code-completion, SQL formatting, and more. Navicat provides a wide range advanced features, such as compelling code editing capabilities, smart code-completion, SQL formatting, and more. Champions keep playing until they get it right. Optimism is the one quality more associated with success and happiness than any other. In the Objects tab, you can use the List List, Detail Detail and ER Diagram ER Diagram buttons to change the object view. A query is used to extract data from the database in a readable format according to the user\'s request. Navicat Cloud could not connect and access your databases. By which it means, it could only store your connection settings, queries, model files, and virtual group; your database passwords and data (e.g. tables, views, etc) will not be stored to Navicat Cloud. Such sessions are also susceptible to session hijacking, where a malicious user takes over your session once you have authenticated.', 0, 0, '2002-12-27 21:24:54', 0, 0, 5);
INSERT INTO `discuss_post` (`id`, `user_id`, `title`, `content`, `type`, `status`, `create_time`, `comment_count`, `score`, `type_id`) VALUES (31, '137', 'Mr.', 'I destroy my enemies when I make them my friends. Optimism is the one quality more associated with success and happiness than any other. If opportunity doesn’t knock, build a door. Monitored servers include MySQL, MariaDB and SQL Server, and compatible with cloud databases like Amazon RDS, Amazon Aurora, Oracle Cloud, Google Cloud and Microsoft Azure. Export Wizard allows you to export data from tables, collections, views, or query results to any available formats. Navicat allows you to transfer data from one database and/or schema to another with detailed analytical process. Navicat Data Modeler enables you to build high-quality conceptual, logical and physical data models for a wide variety of audiences. To get a secure connection, the first thing you need to do is to install OpenSSL Library and download Database Source. Navicat 15 has added support for the system-wide dark mode. Monitored servers include MySQL, MariaDB and SQL Server, and compatible with cloud databases like Amazon RDS, Amazon Aurora, Oracle Cloud, Google Cloud and Microsoft Azure. A man is not old until regrets take the place of dreams. Actually it is just in an idea when feel oneself can achieve and cannot achieve. Import Wizard allows you to import data to tables/collections from CSV, TXT, XML, DBF and more.', 0, 0, '2006-07-27 22:18:05', 0, 0, 6);
INSERT INTO `discuss_post` (`id`, `user_id`, `title`, `content`, `type`, `status`, `create_time`, `comment_count`, `score`, `type_id`) VALUES (281, '153', '测试帖子发布', '测试帖子发布测试帖子发布测试帖子发布测试帖子发布测试帖子发布测试帖子发布测试帖子发布', 0, 0, '2022-01-08 14:45:26', 0, 0, 6);
INSERT INTO `discuss_post` (`id`, `user_id`, `title`, `content`, `type`, `status`, `create_time`, `comment_count`, `score`, `type_id`) VALUES (283, '153', '<script>alert('哈哈');</script>', NULL, 0, 2, '2022-02-08 14:47:19', 4, 0, 6);
INSERT INTO `discuss_post` (`id`, `user_id`, `title`, `content`, `type`, `status`, `create_time`, `comment_count`, `score`, `type_id`) VALUES (284, '153', '***敏感词过滤测试***', '***敏感词过滤测试******敏感词过滤测试******敏感词过滤测试***', 0, 0, '2022-02-08 14:48:59', 14, 0, 6);
INSERT INTO `discuss_post` (`id`, `user_id`, `title`, `content`, `type`, `status`, `create_time`, `comment_count`, `score`, `type_id`) VALUES (285, '153', 'Git、GitHub 和 GitLab', 'Linus Torvalds 为了帮助管理 Linux 内核开发,开发了目前世界上最先进的分布式版本控制系统 Git', 0, 0, '2022-02-08 21:03:10', 2, 0, 6);
INSERT INTO `discuss_post` (`id`, `user_id`, `title`, `content`, `type`, `status`, `create_time`, `comment_count`, `score`, `type_id`) VALUES (290, '111', '2.12 今天做了简单的点赞功能', '生成Redis key的工具:`util/RedisKeyUtil.java`\n\n业务层:`service/LikeService.java`\n\n表示层:`controller/LikeController.java` \n\n帖子详情页面:`discuss-detail.html`、`discuss.js`\n\n首页赞的数量和状态的显示:`HomeController.java` 、`index.html`\n\n\n\n', 0, 0, '2022-02-12 21:11:52', 4, 0, 6);
INSERT INTO `discuss_post` (`id`, `user_id`, `title`, `content`, `type`, `status`, `create_time`, `comment_count`, `score`, `type_id`) VALUES (291, '153', '关注、取消关注', '* 需求 \n * 开发关注、取消关注功能。 \n * 统计用户的关注数、粉丝数。 \n* 关键 \n * 若A关注了B,则A是B的 Follower(粉丝),B是A的 Followee(目标)\n * 关注的目标可以是用户、帖子、题目等,在实现时将这些目标抽象为实体。\n\n', 0, 0, '2022-02-13 15:08:41', 0, 0, 6);
INSERT INTO `discuss_post` (`id`, `user_id`, `title`, `content`, `type`, `status`, `create_time`, `comment_count`, `score`, `type_id`) VALUES (292, '153', '关注列表、粉丝列表', 'Redis 操作比较简单,所以没单独写dao\n\n1. `FollowService.java` 查询某用户关注的人、查询某用户的粉丝\n2. `FollowController.java` 表现层,请求方法\n3. `profile.html` 处理入口链接\n4. `followee.html`、`follower.html` 关注页面、粉丝页面', 0, 0, '2022-02-13 16:55:36', 1, 0, 6);
INSERT INTO `discuss_post` (`id`, `user_id`, `title`, `content`, `type`, `status`, `create_time`, `comment_count`, `score`, `type_id`) VALUES (293, '153', '我的帖子、我的回复', '我的帖子、我的回复我的帖子、我的回复我的帖子、我的回复我的帖子、我的回复我的帖子、我的回复我的帖子、我的回复我的帖子、我的回复', 0, 0, '2022-02-13 17:45:12', 0, 0, 6);
INSERT INTO `discuss_post` (`id`, `user_id`, `title`, `content`, `type`, `status`, `create_time`, `comment_count`, `score`, `type_id`) VALUES (295, '153', '开发社区搜索功能', '1. `ElasticsearchService.java` 业务层,添加对es服务器的操作方法\n2. ` DiscussPostController.java` 、`CommentController.java` 表现层,触发发帖事件\n3. `event/EventConsumer.java` 消费发帖事件(更新到es服务器)\n4. `SearchController.java` 搜索功能接口\n5. `index.html`、`search.html` 返回页面', 0, 0, '2022-02-16 17:13:26', 0, 46, 5);
INSERT INTO `discuss_post` (`id`, `user_id`, `title`, `content`, `type`, `status`, `create_time`, `comment_count`, `score`, `type_id`) VALUES (303, '153', '终端模拟器入门指南', '[TOC]\n\n操作系统分为两个部分,一部分叫**内核**,另一部分叫**用户交互界面**\n在UNIX/LINUX系统中,用户登录系统后会有一个Shell进程,它是一个用 C 语言编写的程序,既是一种命令语言,又是一种程序设计语言,它是管理系统的**命令解析器**,终端是敲命令的工具,是连接内核与交互界面的桥梁 \n\n# 美化终端\n\n以 macOS 为例,安装 [iTerm2](https://www.iterm2.com/) \n\n更换 [主题](https://gitee.com/jasonwood/iTerm2-Color-Schemes) :\n\n`Preferences -> Profiles -> ColorPresets -> Import` \n\n导入 `iTerm2-Color-Schemes/schemes/xxx.itermcolors`\n\n打开 **Statu***ar** :\n\n`Preferences -> Profiles -> Session -> Statu***ar -> Configure Status Bar`\n\n终端一般默认的shell都是 **bash**,建议安装更换 **zsh**、**fish** ... \n\n查看已安装的shell:`cat /etc/shells` \n\n更换shell:`chsh -s [shell路径]`\n\n## zsh\n\nMacOS 默认的shell为 bash,但自带了 zsh\n\n\n\n \n\n1. 安装 [oh-my-zsh](https://ohmyz.sh) (切换到zsh后进行安装)\n\n ```\n Shell successfully changed to '/bin/zsh'.\n __ __\n ____ / /_ ____ ___ __ __ ____ _____/ /_\n / __ \\/ __ \\ / __ `__ \\/ / / / /_ / / ___/ __ \\\n / /_/ / / / / / / / / / / /_/ / / /_(__ ) / / /\n \\____/_/ /_/ /_/ /_/ /_/\\__, / /___/____/_/ /_/\n /____/ ....is now installed!\n Please look over the ~/.zshrc file to select plugins, themes, and options.\n ```\n\n2. 更换[主题](https://github.com/ohmyzsh/ohmyzsh/wiki/themes)\n\n 下载 [powerlevel10k](https://github.com/romkatv/powerlevel10k#oh-my-zsh)(需要安装 Hack Nerd Font 字体和配置)\n\n 编辑 `~/.zshrc` ,修改 `ZSH_THEME="powerlevel10k/powerlevel10k"` \n\n  \n\n3. 安装插件\n\n [**zsh-syntax-highlighting** ](https://github.com/zsh-users/zsh-syntax-highlighting)语法高亮\n\n `git clone https://github.com/zsh-users/zsh-syntax-highlighting.git ${ZSH_CUSTOM:-~/.oh-my-zsh/custom}/plugins/zsh-syntax-highlighting`\n\n [**zsh-autosuggestions**](https://github.com/zsh-users/zsh-autosuggestions) 自动补全\n\n `git clone https://github.com/zsh-users/zsh-autosuggestions ${ZSH_CUSTOM:-~/.oh-my-zsh/custom}/plugins/zsh-autosuggestions`\n\n 下载后编辑 `~/.zshrc` ,添加:\n\n ```\n plugins=(\n git\n zsh-syntax-highlighting\n zsh-autosuggestions\n )\n ```\n\n 执行 `source ~/.zshrc` 后重启 zsh \n\n **[zsh-incremental](https://mimosa-pudica.net/zsh-incremental.html)** 提示补全\n\n 1. `brew install wget`\n 2. `wget -O incr-0.2.zsh https://mimosa-pudica.net/src/incr-0.2.zsh`\n 3. `cp incr-0.2.zsh ~/.oh-my-zsh/plugins/`\n 4. 添加 `source ~/.oh-my-zsh/plugins/incr*.zsh` 到 `~/.zshrc` 中\n\n \n\n  \n## fish\n\nfish 开箱即用,不需要怎么配置\n\n \n\nhttp://fishshell.com\n\n`brew install fish`\n\n> 按`Ctrl+F`或者 右方向键`→`, 即可自动补全\n\n设置fish为默认shell:\n\n`sudo vim /etc/shells`,添加 /usr/local/bin/fish \n\n```\n# List of acceptable shells for chpass(1).\n# Ftpd will not allow users to connect who are not using\n# one of these shell***in/bash\n/bin/csh\n/bin/ksh\n/bin/sh\n/bin/tcsh\n/bin/zsh\n/usr/local/bin/fish\n```\n\n`chsh -s /usr/local/bin/fish` 更换shell\n\nfish插件管理:[oh-my-fish](https://github.com/oh-my-fish/oh-my-fish)\n\n`fish_config` 网页可视化配置 \n\nfish 的PATH路径为:`~/.config/fish/config.fish`\n\n格式:`set PATH /usr/local/mysql/bin $PATH`\n\n\n\n# 常用快捷键\n\n| 快捷键 | 描述 |\n| :--------------: | :--------------------------------: |\n| Command+T | 新建标签页 |\n| Command+W | 关闭标签页 |\n| Command+N | 新建终端窗口 |\n| Command+Q | 关闭终端窗口 |\n| Command+N | 切换到第N个标签页(N=1,2,…) |\n| Command+- | 缩写窗口(包括窗口内的字体) |\n| Command+0 | 普通大小(阿拉伯数字0) |\n| Ctrl+D | 在空白处执行将结束当前会话 |\n| Ctrl+P | 显示上一条历史命令 |\n| Ctrl+N | 显示下一条历史命令 |\n| Ctrl+R | 反向搜索历史命令 |\n| Ctrl+J | 回车(同enter键功能) |\n| Ctrl+M | 回车(同enter键功能) |\n| Ctrl+O | 执行并保留命令 |\n| Ctrl+A | 光标移动到行的开头 |\n| Ctrl+E | 光标移动到行的结尾 |\n| Ctrl+B | 光标向后移动一个位置(backward) |\n| Ctrl+F | 光标向前移动一个位置(forward),补全提示 |\n| Ctrl+Left-Arrow | 光标移动到上一个单词的词首 |\n| Ctrl+Right-Arrow | 光标移动到下一个单词的词尾 |\n| Ctrl+T | 将光标字符和前一个字符进行位置交换 |\n| Ctrl+U | 剪切从行的开头到光标前一个所有字符 |\n| Ctrl+K | 剪切从光标位置到行末的所有字符 |\n| Ctrl+Y | 粘贴剪切的内容(撤销删除) |\n| Ctrl+H | 删除光标前一个字符 |\n| Ctrl+* | 删除光标前一个字符 |\n| Ctrl+D | 删除光标后一个字符 |\n| Ctrl+C | 终止命令 |\n| Ctrl+W | 删除光标前一个单词 |\n| Ctrl+L | 清除当前屏幕内容 |\n| Ctrl+S | 暂停屏幕输出 |\n| Ctrl+Q | 继续屏幕输出 |\n\n**小提示**\nLinux 下同理,把 `Command` 换成 `Ctrl+Shift` 或 `Ctrl`\n在终端窗口命令提示符下,按一次 ` Tab` 键补全;未匹配到命令时,连续按两次 `Tab` 键 或 按 `Ctrl+i` ,将显示所有的命令及工具名称', 1, 1, '2022-02-19 16:53:43', 1, 50.95904139232109, 6);
INSERT INTO `discuss_post` (`id`, `user_id`, `title`, `content`, `type`, `status`, `create_time`, `comment_count`, `score`, `type_id`) VALUES (307, '11', '测试侧边栏目录', '[TOC]\n\n#欢迎使用 Markdown在线编辑器\n\n**Markdown是一种轻量级的「标记语言」**\n\nMarkdown是一种可以使用普通文本编辑器编写的标记语言,通过简单的标记语法,它可以使普通文本内容具有一定的格式。它允许人们使用易读易写的纯文本格式编写文档,然后转换成格式丰富的HTML页面,Markdown文件的后缀名便是&ldquo;.md&rdquo;\n\n\n#### 行内代码 Inline code\n\n执行命令:`npm install marked`\n\n#### 缩进风格\n\n即缩进四个空格,也做为实现类似`&lt;pre&gt;`预格式化文本(Preformatted Text)的功能。\n\n &lt;?php\n echo &quot;Hello world!&quot;;\n ?&gt;\n\n#### HTML代码 HTML codes\n\n```html\n&lt;!DOCTYPE html&gt;\n&lt;html&gt;\n &lt;head&gt;\n &lt;mate charest=&quot;utf-8&quot; /&gt;\n &lt;title&gt;Hello world!&lt;/title&gt;\n &lt;/head&gt;\n &lt;body&gt;\n &lt;h1&gt;Hello world!&lt;/h1&gt;\n &lt;/body&gt;\n&lt;/html&gt;\n```\n\n\n### 绘制表格 Tables\n\n| 项目 | 价格 | 数量 |\n| -------- | -----: | :----: |\n| 计算机 | $1600 | 5 |\n| 手机 | $12 | 12 |\n| 管线 | $1 | 234 |\n\n----\n ', 0, 0, '2022-03-12 15:46:37', 0, 70, 4);
INSERT INTO `discuss_post` (`id`, `user_id`, `title`, `content`, `type`, `status`, `create_time`, `comment_count`, `score`, `type_id`) VALUES (338, '11', ' Git、GitHub 和 GitLab', '[TOC]\n\n# Git基础\n\n## 安装 \n\n* 进入[官网](https://git-scm.com)下载安装包 \n* 使用各种包管理工具用命令行进行安装 \n\n```bash\nsudo apt-get install git\nsudo yum install git\nsudo pacman -S git\nbrew install git\n...\n```\n\n`git --version` 查看安装的 git 版本\n\n## 最小配置\n\n```bash\ngit config --global user.name "hcjjj"\ngit config --global user.email "hcjjj@foxmail.com"\n# 查看配置\ngit config --list --global\n# local 对当前仓库有效, 比global优先级高\n# global 当前用户所有仓库 \n# system 系统所有登录的的用户\n```\n\n## 流程体验\n\n```bash\n~/Desktop\n❯ git init git_learning\n已初始化空的 Git 仓库于 /Users/hcj/Desktop/git_learning/.git/\n\n~/Desktop\n❯ cd git_learning\n\n~/Desktop/git_learning master\n❯ ls -la\ntotal 0\ndrwxr-xr-x 3 hcj staff 96 1 14 15:31 .\ndrwx------+ 11 hcj staff 352 1 14 15:31 ..\ndrwxr-xr-x 10 hcj staff 320 1 14 15:31 .git\n\n~/Desktop/git_learning master\n❯ touch readme.md\n\n~/Desktop/git_learning master*\n❯ git add readme.md\n\n~/Desktop/git_learning master*\n❯ git status\n位于分支 master\n尚无提交\n要提交的变更:\n (使用 "git rm --cached <文件>..." 以取消暂存)\n 新文件: readme.md\n\n~/Desktop/git_learning master*\n❯ git commit -m "Add readme"\n[master(根提交) fc5e57e] Add readme\n 1 file changed, 0 insertions(+), 0 deletions(-)\n create mode 100644 readme.md\n \n~/Desktop/git_learning master\n❯ git log\ncommit fc5e57e970f38fb2d4865a3df11f63c6f54793f3 (HEAD -> master)\nAuthor: 大风声 <hcjjj@foxmail.com>\nDate: Fri Jan 14 15:34:05 2022 +0800\n```\n\n## 工作区和暂存区\n\n**Git 本地的三个工作区域:**\n\n* 工作目录 (Working Directory)\n\n* 暂存区 (Stage/Index)\n\n* 资源库 (Repository/Git Directory) \n\n**文件的四种状态:**\n\n- Untracked: 未跟踪,不参与版本控制,`git add` 变为Staged\n- Staged: 暂存状态,`git commit` 同步到库中\n- Unmodify: 修改后变为Modified,`git rm ` 移出版本库,变为Untracked\n- Modified: 文件已修改,`git add` 进入staged状态, `git checkout` 丢弃修改\n\n## 常用命令\n\n```bash\n# 初始化本地git仓库,多了.git隐藏目录\ngit init\n# 查看所有文件状态\ngit status\n# 查看指定文件状态\ngit status <filename>\n# 添加指定文件到暂存区\ngit add <filename>\n# 添加所有文件到暂存区\ngit add .\n# 添加已经受到管理的文件到暂存区\ngit add -u\n# 删除在仓库中的文件\ngit rm <filename>\n# 取消文件暂存\ngit restore --staged <filename>... \n# 提交暂存区中的内容到本地仓库\ngit commit -m '备注信息'\n# 添加远程仓库信息\ngit remote add <仓库名> <远程仓库地址>\n# 查看所有的远程仓储名称及地址\ngit remote -v \n# 删除本地指定的远程地址\ngit remote remove origin\n# 推送到远程仓库\ngit push [仓库名] [分支名]\n# 从远程仓库拉取数据\ngit pull \n# 克隆远程仓库到本地\ngit clone <url> [本地目录]\n```\n\n`git push -u` git push origin master\n\n`git push -f` 推送到远程仓库并覆盖,**谨慎操作**\n\n> 创建与账户同名的仓库可用于托管静态页面(项目展示、个人博客)\n\n## 文件重命名\n\n太麻烦了:\n\n```bash\n~/Desktop/git_learning master\n❯ mv images images.jpg\n\n~/Desktop/git_learning master*\n❯ git status\n位于分支 master\n尚未暂存以备提交的变更:\n (使用 "git add/rm <文件>..." 更新要提交的内容)\n (使用 "git restore <文件>..." 丢弃工作区的改动)\n 删除: images\n\n未跟踪的文件:\n (使用 "git add <文件>..." 以包含要提交的内容)\n images.jpg\n\n修改尚未加入提交(使用 "git add" 和/或 "git commit -a")\n\n~/Desktop/git_learning master*\n❯ git rm images\nrm 'images'\n\n~/Desktop/git_learning master*\n❯ git add images.jpg\n\n~/Desktop/git_learning master*\n❯ git status\n位于分支 master\n要提交的变更:\n (使用 "git restore --staged <文件>..." 以取消暂存)\n 重命名: images -> images.jpg\n \n# 恢复工作区和暂存区\n❯ git reset --hard\nHEAD 现在位于 abdc16c Add html js image\n\n~/Desktop/git_learning master\n❯ ls -la\ntotal 0\ndrwxr-xr-x 7 hcj staff 224 1 14 17:25 .\ndrwx------+ 11 hcj staff 352 1 14 15:31 ..\ndrwxr-xr-x 14 hcj staff 448 1 14 17:25 .git\n-rw-r--r-- 1 hcj staff 0 1 14 17:25 images\n\n~/Desktop/git_learning master\n❯ git log\ncommit abdc16cf14640bccdc6072137dee8a46d1270b61 (HEAD -> master)\nAuthor: hcjjj <hcjjj@foxmail.com>\nDate: Fri Jan 14 16:52:18 2022 +0800\n\n Add html js image\n\ncommit fc5e57e970f38fb2d4865a3df11f63c6f54793f3\nAuthor: 大风声 <hcjjj@foxmail.com>\nDate: Fri Jan 14 15:34:05 2022 +0800\n\n Add readme\n```\n\n简便方法:\n\n```bash\n~/Desktop/git_learning master 7s\n❯ git mv images images.jpg\n\n~/Desktop/git_learning master*\n❯ git status\n位于分支 master\n要提交的变更:\n (使用 "git restore --staged <文件>..." 以取消暂存)\n 重命名: images -> images.jpg\n\n~/Desktop/git_learning master*\n❯ git commit -m "Move images to images.jpg"\n[master e8897af] Move images to images.jpg\n 1 file changed, 0 insertions(+), 0 deletions(-)\n rename images => images.jpg (100%)\n\n~/Desktop/git_learning master\n❯ git log\ncommit e8897aff912281f92290a88554ded83f2ea5cf30 (HEAD -> master)\nAuthor: hcjjj <hcjjj@foxmail.com>\nDate: Fri Jan 14 17:28:16 2022 +0800\n\n Move images to images.jpg\n\ncommit abdc16cf14640bccdc6072137dee8a46d1270b61\nAuthor: hcjjj <hcjjj@foxmail.com>\nDate: Fri Jan 14 16:52:18 2022 +0800\n\n Add html js image\n\ncommit fc5e57e970f38fb2d4865a3df11f63c6f54793f3\nAuthor: 大风声 <hcjjj@foxmail.com>\nDate: Fri Jan 14 15:34:05 2022 +0800\n\n Add readme\n```\n\n## 查看版本演变\n\n```bash\n❯ git log --oneline\n❯ git log --oneline <分支名>\n❯ git log --oneline -n2 #最近的两次 \n❯ git log --oneline -all #所有分支 \n❯ git log --all --graph #直观查看分支\n❯ git help --web log\n```\n## 图形化\n\n```bash\n❯ brew install git-gui\n```\n\n\n\n## Git分支\n\n```bash\n# 查看本地分支\ngit branch\ngit branch -v\n# 查看远程分支\ngit branch -r\n# 新建一个分支\ngit branch <分支名>\n# 切换到分支\ngit checkout <分支名>\n# 新建一个分支并切换\ngit checkout -b <分支名> \ngit checkout -b <分支名> <版本号>\n# 合并指定分支到当前分支\ngit merge <branch>\n# 删除本地分支\ngit branch -d <分支名>\n# 删除远程分支\ngit push origin --delete <分支名>\ngit branch -dr <remote/branch>\n```\n\n\n## 忽略文件\n\n在主目录下建立 ".gitignore" 文件,执行 `git add . ` 时:\n\n```bash\n*.txt \n# 忽略所有.txt结尾的文件\n!lib.txt \n# 但lib.txt除外\ndoc/ \n# 忽略doc目录下的所有文件\ndoc/*.txt \n# 忽略doc目录下的txt文件\n/temp \n# 仅忽略项目根目录下的temp文件\n```\n\n## 配置\n\n```bash\n#查看所有配置\ngit config -l\n#查看系统配置\ngit config --system --list\n#查看当前用户配置\ngit config --global --list\n#配置用户名\ngit config --global user.name 'your name'\n#配置邮箱\ngit config --global user.email 'your email'\n#设置后响应到:`~/.gitconfig` \n`--global` 为全局配置,不加为某个项目的特定配置\n```', 0, 1, '2022-04-13 08:49:40', 0, 103.8750612633917, 16);
INSERT INTO `discuss_post` (`id`, `user_id`, `title`, `content`, `type`, `status`, `create_time`, `comment_count`, `score`, `type_id`) VALUES (339, '11', 'SSH 连接云服务器', '[TOC]\n\nSSH 为 Secure Shell 的缩写,最初是UNIX系统上的一个程序,专为 **远程登录会话** 和其他网络服务提供安全性的协议。\n<!-- more -->\n简单来说就是可以通过 ssh 以命令行的方式远程控制自己的电脑或者远程服务器\n\n\n# 连接服务器\n`ssh user@remote (-v -p port) `\n\n如:ssh root@112.74.xx.xx\n\n`user` 是在远程机器上的用户名 \n\n`remote` 是云服务器的地址,可以是IP或域名 \n\n`port` 是SSH Server监听的端口,默认值为22 \n\n`-v` 打印出详细的连接信息\n\n`-p` 指定连接SSH Server的端口\n\n`ssh user@remote [指令]` 连接远程服务器并执行指令,发回 stdout 到本机后结束连接 \n\n# 免密登入\n\n公私钥非对称加密方式登入:\n\n1、配置公钥 \n\n在自己计算机的终端中执行 `ssh-keygen` 即可生成SSH钥匙 (一路回车即可) \n\n生成的文件在 `~/.ssh` \n\n2、上传公钥到服务器 \n\n执行 `ssh-copy-id user@remote` \n\n如:ssh-copy-id root@112.74.xx.xx \n\n让远程服务器记住我们自己的计算机,文件保存在服务器的 `~/.ssh/authorized_keys`\n\n这样子既方便又安全\n\n# 上传下载文件\n\n **s**ecure **c**o**p**y \n\n1、上传本地文件到服务器\n\n`scp /path/filename(本地文件) username@remote:/remote_dir(远程目录或文件)`\n\n2、上传本地目录到服务器\n\n`scp -r /local_dir/(本地目录) username@remote:/remote_dir/(远程目录)`\n\n3、下载服务器上的文件\n\n`scp username@remote:/path/filename(远程文件)/local_dir(本地目录或文件)`\n\n4、下载服务器上的目录\n\n`scp -r username@remote:/remote_dir/(远程目录) /local_dir/(本地目录)`\n\n# 配置文件 \n\n**本地**:\n\n编辑 `~/.ssh/config`,添加\n\n```bash\nHost *\n ServerAliveInterval 60\n # 每60秒发送一个no-op包,防止空闲时被服务器断开\n # 保持ssh连接不断开\n \nHost yun\n Hostname 112.74.xx.xx\n User root\n Port 22\n \nHost xxx\n ......\n```\n\n`yun` 服务器别名\n\n`Hostname` 服务器地址\n\n保存后即可使用 `ssh yun` 来登入对应的服务器 \n\n\n\n**服务端**:\n\n文件在 `/etc/ssh/ssh_config`\n\n\n\nSSH 的默认保留端口为22,可以修改为其他合理的端口\n\n修改后需要重启服务器或ssh服务\n\n```bash\n❯ curl 112.74.38.53:22 # 可以查看端口是否可连接\nSSH-2.0-OpenSSH_7.4\ncurl: (56) Recv failure: Connection reset by peer\n\n❯ curl 112.74.38.53:80 # http\n<!doctype html>\n<html lang="en">\n<head>\n<meta charset="utf-8">\n<title>Hidden track</title>\n ......\n```\n\n', 0, 0, '2022-04-13 08:52:19', 0, 102, 16);
INSERT INTO `discuss_post` (`id`, `user_id`, `title`, `content`, `type`, `status`, `create_time`, `comment_count`, `score`, `type_id`) VALUES (340, '11', 'Linux 入门指南', '[TOC]\n\n**Linux** 是一套免费使用和自由传播的类Unix操作系统,它继承了Unix以网络为核心的设计思想,是一个性能稳定的多用户网络操作系统。<!-- more -->它的内核是由芬兰人 **Linus** 编写的,后来经过世界各地程序员的共同努力,衍生了几百种发行版本。 \n\n\n\n**参考阅读:**\n\n[半人半神,Unix、C语言和Linux诞生记](https://www.jianshu.com/p/ba48ac98aff6)\n\n[关于Unix/Linux的终端、伪终端、控制台和Shell](https://www.linuxidc.com/Linux/2017-10/147315.htm)\n\n[2019 年最好的 Linux 发行版](https://linux.cn/article-11411-1.html?pr) \n\n# 部署学习环境\n\n## 使用虚拟机\n\n**安装虚拟机软件**\n\n[VirtualBox](https://www.virtualbox.org) 是一款开源[虚拟机软件](http***aike.baidu.com/item/虚拟机软件/9003764)。VirtualBox 是由德国 Innotek 公司开发,由Sun Microsystems公司出品的软件,使用[Qt](http***aike.baidu.com/item/Qt)编写,在 Sun 被 [Oracle](http***aike.baidu.com/item/Oracle) 收购后正式更名成 Oracle VM VirtualBox\n\n\n\n**在虚拟机上安装 linux**\n\n下载镜像:https://www.centos.org/download\n\n创建虚拟机:\n\n\n\n设置 - 存储 - 分配光盘 - 加载ISO文件 ,启动虚拟机进行 CentOS 安装\n\n## 使用安卓设备\n\n \n\n<center> 设备:华为平板M6</center> \n\n1. 安装使用 termux,参考**国光**的教程:\n\n [Termux 高级终端安装使用配置教程](https://www.sqlsec.com/2018/05/termux.html)\n\n2. 在 GNU/Linux 和Android-Termux上一键安装 GNU/Linux容器,**Moe** :\n\n https://gitee.com/mo2/linux \n\n## 使用云服务器 \n\n\n\n[**使用SSH远程连接**](http://www.allalright.site/post/ssh): \n\n \n\n# 快速入门\n\n## 终端\n\n三种linux终端的使用方式:\n\n* 图像终端(桌面环境)\n* 命令行终端(命令行模式)\n* 远程终端(SSH、VNC)\n\n普通用户的命令提示符:**$**\n\nRoot用户的命令提示符:**#**\n\n## 目录结构\n\n现在大多数 Linux 的文件系统是 EXT4( Fourth extended filesystem 第四代扩展文件系统)\n\n所有文件都在 `/` 根目录下:\n`root` root用户的家目录\n`home/username` 普通用户的家目录\n`etc` 系统配置文件目录\n`bin` 可执行文件(程序)目录\n`boot` 系统启动相关\n`dev` 硬件(一切皆文件,以文件的形式表现出来)\n`mnt` 挂载(U盘、光盘...)\n`opt` 第三方程序目录\n`proc` 进程文件夹\n`srv` 服务文件夹\n`sys` 系统文件夹( 更改屏幕亮度...)\n`tmp` 存放临时文件\n`usr` Unix Software Resource\n`var` 程序缓存\n\n## 软件包\n\n**deb**\ndeb是Debian软件包格式的文件扩展名,在Debian系linux中,双击deb包即可进入自动安装进程\n**rpm**\nRPM(Redhat Linux Packet Manager)是Red Hat公司随Redhat Linux推出了一个软件包管理器,通过它能够更加轻松容易地实现软件的安装\n**tar.gz**\n是一种压缩文件,在所有的Linux版本中都能使用,但安装过程麻烦一点点\n\n## 帮助命令\n\n* man\n* help\n* info\n\n`man ls` 查看 ls 命令的功能及使用方法\n\n`man man` 查看 man 命令的功能及使用方法(共有9个章节的帮助)\n\n`man 1 passwd` 查看命令 passwd 的帮助\n\n`man 5 passwd` 查看文件 passwd 的帮助\n\n`man -a passwd` 查看关键字 passwd 的帮助\n\n---\n\nshell(命令解释器)自带的命令称为内部命令,其他的是外部命令\n\n`type cd` 查看cd是内部还是外部命令\n\n查看内部命令cd的帮助:`help cd`\n\n> `man cd` 查看的是命令解释器的帮助\n\n查看外部命令ls的帮助:`ls --help`\n\n---\n\nInfo 帮助比help更详细,比man page编写得要更友好、更容易理解,但全是英文版的\n\n# 文件管理\n\nLinux 中所有内容都是以文件的形式保存和管理的,即 **一切皆文件**\n\n普通文件是文件,目录(文件夹)是文件,硬件设备(键盘、硬盘、打印机...)是文件,就连套接字(socket)、网络通信等资源也都是文件\n\n## 文件查看\n\n`su - root` 切换为root用户\n\n`exit` 退出当前用户( Ctrl + d ) \n\n`pwd` 显示当前目录名称(类似资源管理器的地址栏)\n\n`clear` 清除页面内容( Ctrl + l )\n\n### ls 命令\n\nls [选项,选项...] [参数...(目录对象)] \n\n> 不同颜色的目录代表不同的权限\n\n`ls /root /` 显示 root用户目录 及 根目录(目录之间用至少用一个空格间隔开)\n\n`ls -l` 以长格式显示当前目录(第一个字符 `-` 表示普通文件 `d` 表示是一个目录)\n\n> 类型 数量 创建者 创建者所属的用户组 大小 最后修改时间 名称\n\n`ls -a` 显示隐藏文件(隐藏文件为了避免误操作)\n\n`ls -r` 逆序显示文件(默认以文件名排序)\n\n`ls -lh` 人性化显示文件大小\n\n`ls -ltr` 按时间顺序逆向显示文件\n\n`ls -R` 递归显示文件\n\n### cd 命令\n\n> 更改当前的操作目录,按 Tab 键进行目录补全 \n\n`cd ~` 切换到当前用户的家目录 \n\n`cd -` 回到上一目录\n\n`cd ..` 回到上一级目录\n\n`cd /path/to/...` 绝对路经(`/` 表示根目录)\n\n`cd ./path/to/...` 相对路经(`./` 表示当前目录)\n\n`cd ./path/to/...` 相对路经(`../` 表示上一级目录)\n\n### 文本内容查看\n\n**cat** 查看文件所有内容,显示到终端\n\n**head** 查看文件开头\n\n`head -3 filename` 查看文本前3行\n\n**tail** 查看文件结尾\n\n> -f 文件内容更新后,显示信息同步更新(ctrl+c 停止命令)\n\n**wc** 统计文件内容信息\n\n> -l 查看文件行数\n\n**more**、**less** 分行显示(空格翻页,回车换行)\n\n> less不必读整个文件,加载速度会比more更快\n> less退出后不会留下刚显示的内容,more会\n> less可以按键盘上下方向键显示上下内容,more不能\n\n\n## 文件操作\n### 创建\n`touch filea` 在当前位置创建文件a \n`mkdir a` 在当前位置新建目录a\n`mkdir b c d` 新建多个目录b c d\n`mkdir /a/b/c` 在目录a/b/下新建目录c\n`mkdir -p /a/b/c` 新建多级目录 /a/b/c\n### 删除\n`rm filea` 删除文件a\n`rmdir a` 删除空目录a\n`rm -r a` 删除目录a(包括目录内的所有文件)\n\n`rm -rf a` 删除目录a(不进行提示)\n\n`sudo rm -rf /` 机毁人亡\n\n### 复制\n`cp -r /root/a /tmp` 复制root下的目录a到/tmp\n`cp filea /tmp` 复制文件filea到/tmp\n> -v 显示复制信息 -p 保留源文件时间 \n> -a 保留权限、属组、时间\n### 移动\n`mv dira /tmp` 移动目录dira到/tmp\n`mv filea fileb` 重命名filea为fileb\n`mv fileb /tmp/filea` 移动fileb到/tmp并重命名为filea\n\n### 通配符\n\n`*` 匹配任意字符\n`?` 匹配一个字符\n`cp file* /tmp` 复制当前文件夹所有以file开头的文件到/tmp\n`cp file? /tmp` 复制当前文件夹所有以file开头并且后面只有一个字符的的文件到/tmp\n\n### 压缩和解压缩\n\n* 最早Linux备份介质是磁带,使用的命令是 **tar**\n* 可以对打包后的磁带文件进行压缩储存,压缩的命令是 **gzip** 和 **bzip2**\n* 经常使用的拓展名是 `.tar.gz` `.tar.bz2` ` .tar`( `.tgz` `.tbz2` ) \n\n`tar cf /tmp/etc-backup.tar /etc ` 将/etc目录打包到/tmp下的etc-backup.tar\n\n> -c:建立一个压缩文件 (create) \n>\n> -f :使用档名 \n>\n> -v : 显示解压信息\n\n`tar czf /tmp/etc-backuo.tar.gz /etc` 打包并**压缩**\n\n`yum install -y bzip2` 安装 bzip2\n\n`tar cjf /tmp/etc-backuo.tar.bz2 /etc` 压缩比率更高,速度比gzip慢\n\n\n\n`tar xf etc-backup.tar -C /root` 解压etc-backup.tar到root目录\n\n## 用户与权限管理\nuseradd 新建用户\nuserdel 删除用户\npasswd 修改用户密码\nusermod 修改用户属性\nchage 修改用户属性\n### 新建\n`useradd hcj` 新建用户hcj\n`id hcj` 查看用户hcj是否存在\n> 用户会被记录到 /etc/passwd 和 /etc/shadow\n> 没有指定用户组的时候会自动创建一个同名的用户组\n> root用户才有创建普通用户的权限\n\n`passwd hcj` 为用户hcj创建密码\n### 删除\n`userdel hcj` 删除用户hcj,但是保留相关数据\n`userdel -r hcj` 删除用户及其相关文件数据\n### 修改\n`useradd h`\n`usermod -d /home/h1 h` 修改用户h的家目录为h1\n### 用户组\n`groupadd group1` 新建用户组group1\n`suermod -g group1 h` 将用户h的用户组改为group1\n`useradd -g group1 user2` 新建用户user2并加入group1中\n\n### 用户切换\n`su - user1` 切换到用户user1( `-` 改变当前工作目录以及HOME,SHELL,USER,LOGNAME,切换为新用户的工作环境)\n> switch user 切换用户\n> sudo是一种权限管理机制,依赖于/etc/sudoers,其定义了授权给哪个用户可以以管理员的身份能够执行什么样的管理命令\n\n### 用户和用户组的配置文件\n\n用户配置文件: /etc/passwd \n`用户名称` : `x 需要密码验证` : `uid` : `gid` : `注释` : `家目录位置` : `登入后使用的命令解释器`\n\n> `/***in/nologin` 不允许登入终端\n\n用户密码相关:/etc/shadow\n`用户名` : `加密后的密码`\n\n用户组相关:/etc/group\n`用户组名称` : `x 需要密码验证` : `gid` : `同时属于其他组`\n\n## 文件权限\n\n### 权限的表示\n前十个字符(- --- --- ---):\n\n第一个:文件类型\n\n前三个:当前用户对该文件有什么权限\n\n中三个:当前用户组对该文件有什么权限\n\n后三个:其他人对该文件有什么权限\n\n\n### 文件类型\n\n`-` 普通文件\n\n> 字符:r读 w写 x执行\n> 数字:r=4 w=2 x=1\n\n`d` 目录文件\n\n> r查看目录内文件 w删除目录内文件 x进入目录\n\n`b` 块特殊文件(插入的设备)\n\n`c` 字符特殊文件(终端)\n\n`l` 符号链接(快捷方式)\n\n`f` 命名管道\n\n`s` 套接字文件\n\n### 修改权限\n```bash \n[root@aliyun ~]# mkdir test\n[root@aliyun ~]# ls -ld test\ndrwxr-xr-x 2 root root 4096 Jan 4 17:07 test\n```\n**修改属主与属组**\n`chown user1 test` 修改目录test的属主为user1\n`chown :group1 test` 修改目录test的属组为group1\n`chown user1:group1 test` 修改目属主为user1 属组为group1\n`chgrp group1 test` 修改目录test的属组为group1\n > ctrl + r 搜索命令历史记录\n\n `u` 属主\n `g` 属组\n `o` 其他\n `a` 所有\n\n `+` 增加权限\n `-` 减少权限\n `=` 设置权限 \n\n**字符**\n`chmod u+x testfile` 添加文件testfile的属主对它的执行权限\n**数字**\n`chmod 446 testfile` 只读 只读 读写\n`chmod 777 testfile` 赋予所有用户最大权限\n\n### 特殊权限\n\n**SUID** 用于**二进制可执行文件**,执行命令时取得文件属主权限\n> 如 /usr/bin/passwd \n> 执行passwd命令时候,会自动获取root用户的身份,让每个用户都有修改自己密码的权限(/etc/shadow 的权限为 000 ) \n\n**SGID** 用于**目录**,在该目录下创建新的文件和目录,权限自动更改为该目录的属组\n> 文件共享的情况会使用到\n\n**SBIT** 用于**目录**,该目录下新建的文件和目录,仅root和自己可以删除\n> 如 /tmp\n\n特殊权限不建议手动设置\n\n\n## 网络管理\n\n## 进程管理\n\n', 1, 1, '2022-04-13 08:59:36', 3, 103.8750612633917, 15);
COMMIT;
-- ----------------------------
-- Table structure for login_ticket
-- ----------------------------
DROP TABLE IF EXISTS `login_ticket`;
CREATE TABLE `login_ticket` (
`id` int NOT NULL AUTO_INCREMENT COMMENT '登入凭证id',
`user_id` int NOT NULL COMMENT '用户id',
`ticket` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '凭证',
`status` int DEFAULT '0' COMMENT '0-有效; 1-无效;',
`expired` timestamp NOT NULL COMMENT '过期时间',
PRIMARY KEY (`id`),
KEY `index_ticket` (`ticket`(20))
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of login_ticket
-- ----------------------------
BEGIN;
INSERT INTO `login_ticket` (`id`, `user_id`, `ticket`, `status`, `expired`) VALUES (3, 153, 'd337c517a95041cb9d88fa14f315a116', 1, '2022-02-07 10:44:58');
INSERT INTO `login_ticket` (`id`, `user_id`, `ticket`, `status`, `expired`) VALUES (4, 153, 'ed9dff4991e34dc2b95339071ecb8825', 1, '2022-02-08 01:00:58');
INSERT INTO `login_ticket` (`id`, `user_id`, `ticket`, `status`, `expired`) VALUES (5, 153, 'f982ecf75d7344f28f62f1b6dbae5441', 1, '2022-02-08 01:23:30');
INSERT INTO `login_ticket` (`id`, `user_id`, `ticket`, `status`, `expired`) VALUES (6, 153, '6c7fb5afc2aa4842afd55138e67a6953', 1, '2022-02-08 02:22:02');
INSERT INTO `login_ticket` (`id`, `user_id`, `ticket`, `status`, `expired`) VALUES (7, 153, '07dd7d6394ae4400b08a04a5972a9750', 1, '2022-02-08 02:22:49');
INSERT INTO `login_ticket` (`id`, `user_id`, `ticket`, `status`, `expired`) VALUES (8, 153, 'd7a47dc4362a474a93783924b36b4a62', 1, '2022-02-08 02:52:08');
INSERT INTO `login_ticket` (`id`, `user_id`, `ticket`, `status`, `expired`) VALUES (9, 153, '2a11f44f453e457597918668963b7f89', 1, '2022-02-08 02:53:04');
INSERT INTO `login_ticket` (`id`, `user_id`, `ticket`, `status`, `expired`) VALUES (10, 153, '10e3f1c175f14910aefe44d3326298d5', 0, '2022-02-09 04:39:37');
INSERT INTO `login_ticket` (`id`, `user_id`, `ticket`, `status`, `expired`) VALUES (11, 153, 'ed71821a441640a18678bed16f84733b', 1, '2022-02-10 05:20:29');
INSERT INTO `login_ticket` (`id`, `user_id`, `ticket`, `status`, `expired`) VALUES (12, 149, '0b68460d60ea400aa58da4205c297225', 0, '2022-02-10 03:27:37');
INSERT INTO `login_ticket` (`id`, `user_id`, `ticket`, `status`, `expired`) VALUES (13, 111, '19d1f114c34f469597568ef4ed826030', 1, '2022-02-11 03:13:13');
INSERT INTO `login_ticket` (`id`, `user_id`, `ticket`, `status`, `expired`) VALUES (14, 153, 'eea41e54517c4b07b11d58a927faef26', 1, '2022-02-11 04:20:32');
INSERT INTO `login_ticket` (`id`, `user_id`, `ticket`, `status`, `expired`) VALUES (15, 111, 'd95f3dd3401e49ec8057a98eda42cdc7', 0, '2022-02-11 04:21:29');
INSERT INTO `login_ticket` (`id`, `user_id`, `ticket`, `status`, `expired`) VALUES (16, 111, '779ea524f0ac4e42bf2fccf966d4bc00', 0, '2022-02-12 05:54:02');
INSERT INTO `login_ticket` (`id`, `user_id`, `ticket`, `status`, `expired`) VALUES (17, 111, 'b9ed664ea72b496faf07a8a110a33a10', 0, '2022-02-12 10:41:40');
INSERT INTO `login_ticket` (`id`, `user_id`, `ticket`, `status`, `expired`) VALUES (18, 111, 'a8442750f484448493639781df7ea8cf', 1, '2022-02-13 08:54:36');
INSERT INTO `login_ticket` (`id`, `user_id`, `ticket`, `status`, `expired`) VALUES (19, 111, '73de1a2bd76f43da802d1ccb87cc98f6', 1, '2022-02-13 10:51:54');
INSERT INTO `login_ticket` (`id`, `user_id`, `ticket`, `status`, `expired`) VALUES (20, 153, 'b99b965a29fc4c20bee70b7336eac0e5', 1, '2022-02-13 11:07:22');
INSERT INTO `login_ticket` (`id`, `user_id`, `ticket`, `status`, `expired`) VALUES (21, 111, '57d040319fc741549355b26b65bd6d87', 0, '2022-02-13 11:33:47');
INSERT INTO `login_ticket` (`id`, `user_id`, `ticket`, `status`, `expired`) VALUES (22, 153, 'c2108fd926b34d1a928da260d5aff7e7', 0, '2022-02-13 11:44:14');
INSERT INTO `login_ticket` (`id`, `user_id`, `ticket`, `status`, `expired`) VALUES (23, 111, '8180b0861fce4f8ba9f784ccce119fc8', 1, '2022-02-14 01:50:18');
INSERT INTO `login_ticket` (`id`, `user_id`, `ticket`, `status`, `expired`) VALUES (24, 153, 'afbfe07d054b457d9b3da4c72235779b', 1, '2022-02-14 03:05:30');
INSERT INTO `login_ticket` (`id`, `user_id`, `ticket`, `status`, `expired`) VALUES (25, 149, 'e8429d4eb1db4023b8748534b228c657', 1, '2022-02-14 05:03:27');
INSERT INTO `login_ticket` (`id`, `user_id`, `ticket`, `status`, `expired`) VALUES (26, 153, 'b56a26af9e134ddfb40df0693baa4900', 1, '2022-02-14 06:48:34');
INSERT INTO `login_ticket` (`id`, `user_id`, `ticket`, `status`, `expired`) VALUES (27, 153, '60c808e6472e4d02b87724bb1d3abca8', 1, '2022-02-14 07:00:58');
INSERT INTO `login_ticket` (`id`, `user_id`, `ticket`, `status`, `expired`) VALUES (28, 153, '2f3acddf05ef4e92bb1d877266e0e4cc', 0, '2022-02-14 07:03:21');
COMMIT;
-- ----------------------------
-- Table structure for message
-- ----------------------------
DROP TABLE IF EXISTS `message`;
CREATE TABLE `message` (
`id` int NOT NULL AUTO_INCREMENT COMMENT '消息的id',
`from_id` int DEFAULT NULL COMMENT '消息发送者id,1表示系统通知',
`to_id` int DEFAULT NULL COMMENT '消息接收者id',
`conversation_id` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '会话id,由from_id组合to_id,小的id放前面,冗余的数据,方便查询',
`content` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '消息内容',
`status` int DEFAULT NULL COMMENT '消息状态,0-未读;1-已读;2-删除;',
`create_time` timestamp NULL DEFAULT NULL COMMENT '消息时间',
PRIMARY KEY (`id`),
KEY `index_from_id` (`from_id`),
KEY `index_to_id` (`to_id`),
KEY `index_conversation_id` (`conversation_id`)
) ENGINE=InnoDB AUTO_INCREMENT=504 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of message
-- ----------------------------
BEGIN;
INSERT INTO `message` (`id`, `from_id`, `to_id`, `conversation_id`, `content`, `status`, `create_time`) VALUES (463, 11, 153, '11_153', '测试消息', 0, '2022-03-06 19:55:04');
INSERT INTO `message` (`id`, `from_id`, `to_id`, `conversation_id`, `content`, `status`, `create_time`) VALUES (464, 11, 153, '11_153', '1111', 0, '2022-03-06 19:55:14');
INSERT INTO `message` (`id`, `from_id`, `to_id`, `conversation_id`, `content`, `status`, `create_time`) VALUES (465, 1, 153, 'follow', '{"entityType":3,"entityId":153,"userId":11}', 0, '2022-03-06 19:56:06');
INSERT INTO `message` (`id`, `from_id`, `to_id`, `conversation_id`, `content`, `status`, `create_time`) VALUES (466, 1, 21, 'follow', '{"entityType":3,"entityId":21,"userId":153}', 0, '2022-03-06 21:07:47');
INSERT INTO `message` (`id`, `from_id`, `to_id`, `conversation_id`, `content`, `status`, `create_time`) VALUES (467, 1, 11, 'follow', '{"entityType":3,"entityId":11,"userId":153}', 2, '2022-03-06 21:07:52');
INSERT INTO `message` (`id`, `from_id`, `to_id`, `conversation_id`, `content`, `status`, `create_time`) VALUES (468, 1, 111, 'follow', '{"entityType":3,"entityId":111,"userId":153}', 0, '2022-03-06 23:03:23');
INSERT INTO `message` (`id`, `from_id`, `to_id`, `conversation_id`, `content`, `status`, `create_time`) VALUES (469, 1, 153, 'follow', '{"entityType":3,"entityId":153,"userId":11}', 0, '2022-03-09 21:48:56');
INSERT INTO `message` (`id`, `from_id`, `to_id`, `conversation_id`, `content`, `status`, `create_time`) VALUES (470, 1, 21, 'like', '{"entityType":1,"entityId":302,"postId":302,"userId":11}', 0, '2022-03-09 21:50:18');
INSERT INTO `message` (`id`, `from_id`, `to_id`, `conversation_id`, `content`, `status`, `create_time`) VALUES (471, 1, 11, 'like', '{"entityType":2,"entityId":306,"postId":309,"userId":11}', 2, '2022-03-12 20:24:30');
INSERT INTO `message` (`id`, `from_id`, `to_id`, `conversation_id`, `content`, `status`, `create_time`) VALUES (472, 1, 11, 'comment', '{"entityType":2,"entityId":306,"postId":309,"userId":11}', 2, '2022-03-12 20:24:51');
INSERT INTO `message` (`id`, `from_id`, `to_id`, `conversation_id`, `content`, `status`, `create_time`) VALUES (473, 1, 11, 'comment', '{"entityType":2,"entityId":308,"postId":309,"userId":11}', 2, '2022-03-12 21:00:29');
INSERT INTO `message` (`id`, `from_id`, `to_id`, `conversation_id`, `content`, `status`, `create_time`) VALUES (474, 1, 11, 'comment', '{"entityType":2,"entityId":308,"postId":309,"userId":11}', 2, '2022-03-12 21:11:36');
INSERT INTO `message` (`id`, `from_id`, `to_id`, `conversation_id`, `content`, `status`, `create_time`) VALUES (476, 1, 111, 'follow', '{"entityType":3,"entityId":111,"userId":11}', 0, '2022-03-24 13:33:42');
INSERT INTO `message` (`id`, `from_id`, `to_id`, `conversation_id`, `content`, `status`, `create_time`) VALUES (477, 1, 153, 'follow', '{"entityType":3,"entityId":153,"userId":11}', 1, '2022-03-24 13:34:02');
INSERT INTO `message` (`id`, `from_id`, `to_id`, `conversation_id`, `content`, `status`, `create_time`) VALUES (478, 1, 131, 'follow', '{"entityType":3,"entityId":131,"userId":153}', 0, '2022-03-24 13:38:51');
INSERT INTO `message` (`id`, `from_id`, `to_id`, `conversation_id`, `content`, `status`, `create_time`) VALUES (479, 1, 111, 'follow', '{"entityType":3,"entityId":111,"userId":11}', 0, '2022-04-03 15:13:23');
INSERT INTO `message` (`id`, `from_id`, `to_id`, `conversation_id`, `content`, `status`, `create_time`) VALUES (480, 1, 11, 'like', '{"entityType":2,"entityId":306,"postId":309,"userId":11}', 2, '2022-04-07 14:23:15');
INSERT INTO `message` (`id`, `from_id`, `to_id`, `conversation_id`, `content`, `status`, `create_time`) VALUES (481, 1, 11, 'like', '{"entityType":1,"entityId":309,"postId":309,"userId":11}', 2, '2022-04-08 16:35:45');
INSERT INTO `message` (`id`, `from_id`, `to_id`, `conversation_id`, `content`, `status`, `create_time`) VALUES (482, 1, 11, 'like', '{"entityType":1,"entityId":309,"postId":309,"userId":11}', 2, '2022-04-08 16:35:48');
INSERT INTO `message` (`id`, `from_id`, `to_id`, `conversation_id`, `content`, `status`, `create_time`) VALUES (483, 1, 11, 'like', '{"entityType":1,"entityId":309,"postId":309,"userId":11}', 2, '2022-04-08 16:35:50');
INSERT INTO `message` (`id`, `from_id`, `to_id`, `conversation_id`, `content`, `status`, `create_time`) VALUES (484, 1, 11, 'like', '{"entityType":1,"entityId":309,"postId":309,"userId":11}', 2, '2022-04-08 16:46:13');
INSERT INTO `message` (`id`, `from_id`, `to_id`, `conversation_id`, `content`, `status`, `create_time`) VALUES (485, 1, 11, 'like', '{"entityType":1,"entityId":309,"postId":309,"userId":11}', 2, '2022-04-08 16:50:23');
INSERT INTO `message` (`id`, `from_id`, `to_id`, `conversation_id`, `content`, `status`, `create_time`) VALUES (486, 1, 11, 'like', '{"entityType":2,"entityId":308,"postId":309,"userId":11}', 2, '2022-04-08 16:51:54');
INSERT INTO `message` (`id`, `from_id`, `to_id`, `conversation_id`, `content`, `status`, `create_time`) VALUES (487, 1, 11, 'like', '{"entityType":1,"entityId":309,"postId":309,"userId":11}', 2, '2022-04-08 19:09:54');
INSERT INTO `message` (`id`, `from_id`, `to_id`, `conversation_id`, `content`, `status`, `create_time`) VALUES (488, 1, 11, 'like', '{"entityType":1,"entityId":309,"postId":309,"userId":153}', 2, '2022-04-08 19:42:24');
INSERT INTO `message` (`id`, `from_id`, `to_id`, `conversation_id`, `content`, `status`, `create_time`) VALUES (489, 1, 153, 'follow', '{"entityType":3,"entityId":153,"userId":11}', 1, '2022-04-08 20:24:30');
INSERT INTO `message` (`id`, `from_id`, `to_id`, `conversation_id`, `content`, `status`, `create_time`) VALUES (490, 1, 112, 'follow', '{"entityType":3,"entityId":112,"userId":11}', 0, '2022-04-08 20:24:43');
INSERT INTO `message` (`id`, `from_id`, `to_id`, `conversation_id`, `content`, `status`, `create_time`) VALUES (491, 1, 153, 'follow', '{"entityType":3,"entityId":153,"userId":11}', 1, '2022-04-10 14:06:34');
INSERT INTO `message` (`id`, `from_id`, `to_id`, `conversation_id`, `content`, `status`, `create_time`) VALUES (492, 1, 153, 'follow', '{"entityType":3,"entityId":153,"userId":11}', 1, '2022-04-10 14:13:20');
INSERT INTO `message` (`id`, `from_id`, `to_id`, `conversation_id`, `content`, `status`, `create_time`) VALUES (493, 1, 153, 'follow', '{"entityType":3,"entityId":153,"userId":11}', 1, '2022-04-10 14:17:24');
INSERT INTO `message` (`id`, `from_id`, `to_id`, `conversation_id`, `content`, `status`, `create_time`) VALUES (494, 1, 11, 'follow', '{"entityType":3,"entityId":11,"userId":153}', 2, '2022-04-13 09:03:07');
INSERT INTO `message` (`id`, `from_id`, `to_id`, `conversation_id`, `content`, `status`, `create_time`) VALUES (495, 1, 11, 'like', '{"entityType":1,"entityId":340,"postId":340,"userId":11}', 1, '2022-04-15 17:39:20');
INSERT INTO `message` (`id`, `from_id`, `to_id`, `conversation_id`, `content`, `status`, `create_time`) VALUES (496, 1, 111, 'follow', '{"entityType":3,"entityId":111,"userId":153}', 0, '2022-04-26 13:08:45');
INSERT INTO `message` (`id`, `from_id`, `to_id`, `conversation_id`, `content`, `status`, `create_time`) VALUES (497, 1, 120, 'follow', '{"entityType":3,"entityId":120,"userId":153}', 0, '2022-04-26 13:10:34');
INSERT INTO `message` (`id`, `from_id`, `to_id`, `conversation_id`, `content`, `status`, `create_time`) VALUES (498, 1, 120, 'follow', '{"entityType":3,"entityId":120,"userId":153}', 0, '2022-04-26 13:11:10');
INSERT INTO `message` (`id`, `from_id`, `to_id`, `conversation_id`, `content`, `status`, `create_time`) VALUES (499, 1, 11, 'like', '{"entityType":1,"entityId":340,"postId":340,"userId":153}', 0, '2022-04-26 13:21:18');
INSERT INTO `message` (`id`, `from_id`, `to_id`, `conversation_id`, `content`, `status`, `create_time`) VALUES (500, 1, 11, 'like', '{"entityType":2,"entityId":315,"postId":340,"userId":153}', 0, '2022-04-26 13:22:58');
INSERT INTO `message` (`id`, `from_id`, `to_id`, `conversation_id`, `content`, `status`, `create_time`) VALUES (501, 1, 11, 'comment', '{"entityType":2,"entityId":315,"postId":340,"userId":11}', 1, '2022-04-28 11:33:25');
INSERT INTO `message` (`id`, `from_id`, `to_id`, `conversation_id`, `content`, `status`, `create_time`) VALUES (502, 1, 11, 'comment', '{"entityType":2,"entityId":315,"postId":340,"userId":11}', 1, '2022-04-28 11:33:55');
INSERT INTO `message` (`id`, `from_id`, `to_id`, `conversation_id`, `content`, `status`, `create_time`) VALUES (503, 1, 153, 'follow', '{"entityType":3,"entityId":153,"userId":11}', 0, '2022-04-29 17:16:47');
COMMIT;
-- ----------------------------
-- Table structure for QRTZ_BLOB_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_BLOB_TRIGGERS`;
CREATE TABLE `QRTZ_BLOB_TRIGGERS` (
`SCHED_NAME` varchar(120) NOT NULL,
`TRIGGER_NAME` varchar(190) NOT NULL,
`TRIGGER_GROUP` varchar(190) NOT NULL,
`BLOB_DATA` blob,
PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
KEY `SCHED_NAME` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
CONSTRAINT `qrtz_blob_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- ----------------------------
-- Records of QRTZ_BLOB_TRIGGERS
-- ----------------------------
BEGIN;
COMMIT;
-- ----------------------------
-- Table structure for QRTZ_CALENDARS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_CALENDARS`;
CREATE TABLE `QRTZ_CALENDARS` (
`SCHED_NAME` varchar(120) NOT NULL,
`CALENDAR_NAME` varchar(190) NOT NULL,
`CALENDAR` blob NOT NULL,
PRIMARY KEY (`SCHED_NAME`,`CALENDAR_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- ----------------------------
-- Records of QRTZ_CALENDARS
-- ----------------------------
BEGIN;
COMMIT;
-- ----------------------------
-- Table structure for QRTZ_CRON_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_CRON_TRIGGERS`;
CREATE TABLE `QRTZ_CRON_TRIGGERS` (
`SCHED_NAME` varchar(120) NOT NULL,
`TRIGGER_NAME` varchar(190) NOT NULL,
`TRIGGER_GROUP` varchar(190) NOT NULL,
`CRON_EXPRESSION` varchar(120) NOT NULL,
`TIME_ZONE_ID` varchar(80) DEFAULT NULL,
PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
CONSTRAINT `qrtz_cron_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- ----------------------------
-- Records of QRTZ_CRON_TRIGGERS
-- ----------------------------
BEGIN;
COMMIT;
-- ----------------------------
-- Table structure for QRTZ_FIRED_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_FIRED_TRIGGERS`;
CREATE TABLE `QRTZ_FIRED_TRIGGERS` (
`SCHED_NAME` varchar(120) NOT NULL,
`ENTRY_ID` varchar(95) NOT NULL,
`TRIGGER_NAME` varchar(190) NOT NULL,
`TRIGGER_GROUP` varchar(190) NOT NULL,
`INSTANCE_NAME` varchar(190) NOT NULL,
`FIRED_TIME` bigint NOT NULL,
`SCHED_TIME` bigint NOT NULL,
`PRIORITY` int NOT NULL,
`STATE` varchar(16) NOT NULL,
`JOB_NAME` varchar(190) DEFAULT NULL,
`JOB_GROUP` varchar(190) DEFAULT NULL,
`IS_NONCONCURRENT` varchar(1) DEFAULT NULL,
`REQUESTS_RECOVERY` varchar(1) DEFAULT NULL,
PRIMARY KEY (`SCHED_NAME`,`ENTRY_ID`),
KEY `IDX_QRTZ_FT_TRIG_INST_NAME` (`SCHED_NAME`,`INSTANCE_NAME`),
KEY `IDX_QRTZ_FT_INST_JOB_REQ_RCVRY` (`SCHED_NAME`,`INSTANCE_NAME`,`REQUESTS_RECOVERY`),
KEY `IDX_QRTZ_FT_J_G` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
KEY `IDX_QRTZ_FT_JG` (`SCHED_NAME`,`JOB_GROUP`),
KEY `IDX_QRTZ_FT_T_G` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
KEY `IDX_QRTZ_FT_TG` (`SCHED_NAME`,`TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- ----------------------------
-- Records of QRTZ_FIRED_TRIGGERS
-- ----------------------------
BEGIN;
COMMIT;
-- ----------------------------
-- Table structure for QRTZ_JOB_DETAILS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_JOB_DETAILS`;
CREATE TABLE `QRTZ_JOB_DETAILS` (
`SCHED_NAME` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '定时任务名称',
`JOB_NAME` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '工作名称',
`JOB_GROUP` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '工作分组',
`DESCRIPTION` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '工作描述',
`JOB_CLASS_NAME` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '对应哪个类',
`IS_DURABLE` varchar(1) NOT NULL,
`IS_NONCONCURRENT` varchar(1) NOT NULL,
`IS_UPDATE_DATA` varchar(1) NOT NULL,
`REQUESTS_RECOVERY` varchar(1) NOT NULL,
`JOB_DATA` blob,
PRIMARY KEY (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
KEY `IDX_QRTZ_J_REQ_RECOVERY` (`SCHED_NAME`,`REQUESTS_RECOVERY`),
KEY `IDX_QRTZ_J_GRP` (`SCHED_NAME`,`JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- ----------------------------
-- Records of QRTZ_JOB_DETAILS
-- ----------------------------
BEGIN;
INSERT INTO `QRTZ_JOB_DETAILS` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`, `DESCRIPTION`, `JOB_CLASS_NAME`, `IS_DURABLE`, `IS_NONCONCURRENT`, `IS_UPDATE_DATA`, `REQUESTS_RECOVERY`, `JOB_DATA`) VALUES ('communityScheduler', 'postScoreRefreshJob', 'communityJobGroup', NULL, 'com.coder.community.quartz.PostScoreRefreshJob', '1', '0', '0', '1', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787000737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F40000000000010770800000010000000007800);
COMMIT;
-- ----------------------------
-- Table structure for QRTZ_LOCKS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_LOCKS`;
CREATE TABLE `QRTZ_LOCKS` (
`SCHED_NAME` varchar(120) NOT NULL,
`LOCK_NAME` varchar(40) NOT NULL,
PRIMARY KEY (`SCHED_NAME`,`LOCK_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- ----------------------------
-- Records of QRTZ_LOCKS
-- ----------------------------
BEGIN;
INSERT INTO `QRTZ_LOCKS` (`SCHED_NAME`, `LOCK_NAME`) VALUES ('communityScheduler', 'STATE_ACCESS');
INSERT INTO `QRTZ_LOCKS` (`SCHED_NAME`, `LOCK_NAME`) VALUES ('communityScheduler', 'TRIGGER_ACCESS');
COMMIT;
-- ----------------------------
-- Table structure for QRTZ_PAUSED_TRIGGER_GRPS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_PAUSED_TRIGGER_GRPS`;
CREATE TABLE `QRTZ_PAUSED_TRIGGER_GRPS` (
`SCHED_NAME` varchar(120) NOT NULL,
`TRIGGER_GROUP` varchar(190) NOT NULL,
PRIMARY KEY (`SCHED_NAME`,`TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- ----------------------------
-- Records of QRTZ_PAUSED_TRIGGER_GRPS
-- ----------------------------
BEGIN;
COMMIT;
-- ----------------------------
-- Table structure for QRTZ_SCHEDULER_STATE
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_SCHEDULER_STATE`;
CREATE TABLE `QRTZ_SCHEDULER_STATE` (
`SCHED_NAME` varchar(120) NOT NULL,
`INSTANCE_NAME` varchar(190) NOT NULL,
`LAST_CHECKIN_TIME` bigint NOT NULL,
`CHECKIN_INTERVAL` bigint NOT NULL,
PRIMARY KEY (`SCHED_NAME`,`INSTANCE_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- ----------------------------
-- Records of QRTZ_SCHEDULER_STATE
-- ----------------------------
BEGIN;
INSERT INTO `QRTZ_SCHEDULER_STATE` (`SCHED_NAME`, `INSTANCE_NAME`, `LAST_CHECKIN_TIME`, `CHECKIN_INTERVAL`) VALUES ('communityScheduler', 'HiddenTrack.local1651571758288', 1651592788548, 7500);
COMMIT;
-- ----------------------------
-- Table structure for QRTZ_SIMPLE_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_SIMPLE_TRIGGERS`;
CREATE TABLE `QRTZ_SIMPLE_TRIGGERS` (
`SCHED_NAME` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '任务名',
`TRIGGER_NAME` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '触发器名',
`TRIGGER_GROUP` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '触发器组',
`REPEAT_COUNT` bigint NOT NULL COMMENT '执行了多少次',
`REPEAT_INTERVAL` bigint NOT NULL,
`TIMES_TRIGGERED` bigint NOT NULL,
PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
CONSTRAINT `qrtz_simple_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- ----------------------------
-- Records of QRTZ_SIMPLE_TRIGGERS
-- ----------------------------
BEGIN;
INSERT INTO `QRTZ_SIMPLE_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`, `REPEAT_COUNT`, `REPEAT_INTERVAL`, `TIMES_TRIGGERED`) VALUES ('communityScheduler', 'postScoreRefreshTrigger', 'communityTriggerGroup', -1, 300000, 15231);
COMMIT;
-- ----------------------------
-- Table structure for QRTZ_SIMPROP_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_SIMPROP_TRIGGERS`;
CREATE TABLE `QRTZ_SIMPROP_TRIGGERS` (
`SCHED_NAME` varchar(120) NOT NULL,
`TRIGGER_NAME` varchar(190) NOT NULL,
`TRIGGER_GROUP` varchar(190) NOT NULL,
`STR_PROP_1` varchar(512) DEFAULT NULL,
`STR_PROP_2` varchar(512) DEFAULT NULL,
`STR_PROP_3` varchar(512) DEFAULT NULL,
`INT_PROP_1` int DEFAULT NULL,
`INT_PROP_2` int DEFAULT NULL,
`LONG_PROP_1` bigint DEFAULT NULL,
`LONG_PROP_2` bigint DEFAULT NULL,
`DEC_PROP_1` decimal(13,4) DEFAULT NULL,
`DEC_PROP_2` decimal(13,4) DEFAULT NULL,
`BOOL_PROP_1` varchar(1) DEFAULT NULL,
`BOOL_PROP_2` varchar(1) DEFAULT NULL,
PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
CONSTRAINT `qrtz_simprop_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- ----------------------------
-- Records of QRTZ_SIMPROP_TRIGGERS
-- ----------------------------
BEGIN;
COMMIT;
-- ----------------------------
-- Table structure for QRTZ_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_TRIGGERS`;
CREATE TABLE `QRTZ_TRIGGERS` (
`SCHED_NAME` varchar(120) NOT NULL,
`TRIGGER_NAME` varchar(190) NOT NULL,
`TRIGGER_GROUP` varchar(190) NOT NULL,
`JOB_NAME` varchar(190) NOT NULL,
`JOB_GROUP` varchar(190) NOT NULL,
`DESCRIPTION` varchar(250) DEFAULT NULL,
`NEXT_FIRE_TIME` bigint DEFAULT NULL,
`PREV_FIRE_TIME` bigint DEFAULT NULL,
`PRIORITY` int DEFAULT NULL,
`TRIGGER_STATE` varchar(16) NOT NULL,
`TRIGGER_TYPE` varchar(8) NOT NULL,
`START_TIME` bigint NOT NULL,
`END_TIME` bigint DEFAULT NULL,
`CALENDAR_NAME` varchar(190) DEFAULT NULL,
`MISFIRE_INSTR` smallint DEFAULT NULL,
`JOB_DATA` blob,
PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
KEY `IDX_QRTZ_T_J` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
KEY `IDX_QRTZ_T_JG` (`SCHED_NAME`,`JOB_GROUP`),
KEY `IDX_QRTZ_T_C` (`SCHED_NAME`,`CALENDAR_NAME`),
KEY `IDX_QRTZ_T_G` (`SCHED_NAME`,`TRIGGER_GROUP`),
KEY `IDX_QRTZ_T_STATE` (`SCHED_NAME`,`TRIGGER_STATE`),
KEY `IDX_QRTZ_T_N_STATE` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
KEY `IDX_QRTZ_T_N_G_STATE` (`SCHED_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
KEY `IDX_QRTZ_T_NEXT_FIRE_TIME` (`SCHED_NAME`,`NEXT_FIRE_TIME`),
KEY `IDX_QRTZ_T_NFT_ST` (`SCHED_NAME`,`TRIGGER_STATE`,`NEXT_FIRE_TIME`),
KEY `IDX_QRTZ_T_NFT_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`),
KEY `IDX_QRTZ_T_NFT_ST_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_STATE`),
KEY `IDX_QRTZ_T_NFT_ST_MISFIRE_GRP` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
CONSTRAINT `qrtz_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `qrtz_job_details` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- ----------------------------
-- Records of QRTZ_TRIGGERS
-- ----------------------------
BEGIN;
INSERT INTO `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`, `JOB_NAME`, `JOB_GROUP`, `DESCRIPTION`, `NEXT_FIRE_TIME`, `PREV_FIRE_TIME`, `PRIORITY`, `TRIGGER_STATE`, `TRIGGER_TYPE`, `START_TIME`, `END_TIME`, `CALENDAR_NAME`, `MISFIRE_INSTR`, `JOB_DATA`) VALUES ('communityScheduler', 'postScoreRefreshTrigger', 'communityTriggerGroup', 'postScoreRefreshJob', 'communityJobGroup', NULL, 1649903416775, 1649903116775, 0, 'ERROR', 'SIMPLE', 1645334116775, 0, NULL, 0, '');
COMMIT;
-- ----------------------------
-- Table structure for tag
-- ----------------------------
DROP TABLE IF EXISTS `tag`;
CREATE TABLE `tag` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`audit_state` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '审核状态',
`group_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '所属分组',
`name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '名称',
`description` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '描述',
`ref_count` bigint NOT NULL DEFAULT '0' COMMENT '引用统计',
`creator_id` bigint DEFAULT NULL COMMENT '创建人',
`is_delete` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '删除标识(0:未删除、1:已删除)',
`create_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '记录创建时间',
`update_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '记录修改时间',
PRIMARY KEY (`id`),
UNIQUE KEY `uniq_name_state` (`name`,`audit_state`)
) ENGINE=InnoDB AUTO_INCREMENT=385 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='标签表';
-- ----------------------------
-- Records of tag
-- ----------------------------
BEGIN;
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (188, 'PASS', '开发语言', 'java', 'Java 是由 Sun Microsystems 公司于 1995 年 5 月推出的高级程序设计语言。\n\nJava 可运行于多个平台,如 Windows, Mac OS 及其他多种 UNIX 版本的系统。\n\n本教程通过简单的实例将让大家更好的了解 Java 编程语言。\n\n移动操作系统 Android 大部分的代码采用 Java 编程语言编程。', 2, 25, 0, '2020-11-10 12:03:01', '2022-04-14 11:22:22');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (189, 'PASS', '开发语言', 'c', 'C 语言是一种通用的、面向过程式的计算机程序设计语言。1972 年,为了移植与开发 UNIX 操作系统,丹尼斯·里奇在贝尔电话实验室设计开发了 C 语言。\n\nC 语言是一种广泛使用的计算机语言,它与 Java 编程语言一样普及,二者在现代软件程序员之间都得到广泛使用。\n\n当前最新的 C 语言标准为 C18 ,在它之前的 C 语言标准有 C17、C11...C99 等。', 0, 25, 0, '2020-11-10 12:03:01', '2022-04-12 17:55:08');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (190, 'PASS', '开发语言', 'c++', 'C++ 是一种高级语言,它是由 Bjarne Stroustrup 于 1979 年在贝尔实验室开始设计开发的。C++ 进一步扩充和完善了 C 语言,是一种面向对象的程序设计语言。C++ 可运行于多种平台上,如 Windows、MAC 操作系统以及 UNIX 的各种版本。', 0, 25, 0, '2022-04-19 22:33:33', '2022-04-19 22:33:33');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (191, 'PASS', '开发语言', 'php', 'PHP 是一种创建动态交互性站点的强有力的服务器端脚本语言。\n\nPHP 是免费的,并且使用非常广泛。同时,对于像微软 ASP 这样的竞争者来说,PHP 无疑是另一种高效率的选项。', 0, 25, 0, '2022-04-19 22:33:52', '2022-04-19 22:33:52');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (192, 'PASS', '开发语言', 'perl', ' perl 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2022-04-08 14:48:47');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (193, 'PASS', '开发语言', 'python', ' python 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (194, 'PASS', '开发语言', 'javascript', ' javascript 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2022-04-12 16:38:55');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (195, 'PASS', '开发语言', 'c#', ' c# 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (196, 'PASS', '开发语言', 'ruby', ' ruby 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (197, 'PASS', '开发语言', 'go', ' go 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (198, 'PASS', '开发语言', 'lua', ' lua 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (199, 'PASS', '开发语言', 'node.js', ' node.js 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2022-04-12 16:38:55');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (200, 'PASS', '开发语言', 'erlang', ' erlang 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (201, 'PASS', '开发语言', 'scala', ' scala 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (202, 'PASS', '开发语言', 'bash', ' bash 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (203, 'PASS', '开发语言', 'actionscript', ' actionscript 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (204, 'PASS', '开发语言', 'golang', ' golang 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (205, 'PASS', '开发语言', 'typescript', ' typescript 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (206, 'PASS', '开发语言', 'flutter', ' flutter 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (207, 'PASS', '前端开发', 'html', ' html 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2022-04-12 16:38:55');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (208, 'PASS', '前端开发', 'html5', ' html5 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2022-04-12 16:38:55');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (209, 'PASS', '前端开发', 'css', ' css 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2022-04-12 16:38:55');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (211, 'PASS', '前端开发', 'jquery', ' jquery 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (212, 'PASS', '前端开发', 'json', ' json 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2022-04-12 16:38:55');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (213, 'PASS', '前端开发', 'ajax', ' ajax 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2022-04-12 16:38:55');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (214, 'PASS', '前端开发', '正则表达式', ' 正则表达式 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2022-04-12 16:38:55');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (215, 'PASS', '前端开发', 'bootstrap', ' bootstrap 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (216, 'PASS', 'JavaScript 开发', 'chrome', ' chrome 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (217, 'PASS', 'JavaScript 开发', 'firefox', ' firefox 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (218, 'PASS', 'JavaScript 开发', 'internet-explorer', ' internet-explorer 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (219, 'PASS', 'JavaScript 开发', 'angular.js', ' angular.js 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2022-04-12 16:38:55');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (220, 'PASS', 'JavaScript 开发', 'ecmascript', ' ecmascript 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (221, 'PASS', 'JavaScript 开发', 'vue.js', ' vue.js 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2022-04-12 16:38:55');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (222, 'PASS', 'JavaScript 开发', 'react.js', ' react.js 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2022-04-12 16:38:55');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (223, 'PASS', '小程序开发', '小程序', ' 小程序 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (224, 'PASS', '小程序开发', '微信小程序', ' 微信小程序 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (225, 'PASS', '小程序开发', '支付宝小程序', ' 支付宝小程序 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (226, 'PASS', '小程序开发', '百度智能小程序', ' 百度智能小程序 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (227, 'PASS', '小程序开发', '微信开发者工具', ' 微信开发者工具 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (228, 'PASS', '小程序开发', '头条小程序', ' 头条小程序 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (229, 'PASS', '小程序开发', '小程序云开发', ' 小程序云开发 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (230, 'PASS', '小程序开发', 'wepy', ' wepy 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (231, 'PASS', '小程序开发', 'mpvue', ' mpvue 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (232, 'PASS', '小程序开发', 'taro', ' taro 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (233, 'PASS', '小程序开发', 'uni-app', ' uni-app 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (234, 'PASS', '小程序开发', 'mpx', ' mpx 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (235, 'PASS', '区块链', '比特币', ' 比特币 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2022-04-12 16:38:55');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (236, 'PASS', '区块链', '区块链', ' 区块链 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2022-04-12 16:38:55');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (237, 'PASS', '区块链', 'ico', ' ico 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (238, 'PASS', '区块链', '智能合约', ' 智能合约 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (239, 'PASS', '区块链', '以太坊', ' 以太坊 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (240, 'PASS', '区块链', '数字化货币', ' 数字化货币 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2022-04-12 16:38:55');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (241, 'PASS', '人工智能', '人工智能', ' 人工智能 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (242, 'PASS', '人工智能', '自然语言处理', ' 自然语言处理 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (243, 'PASS', '人工智能', '自动驾驶', ' 自动驾驶 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (244, 'PASS', '人工智能', '神经网络', ' 神经网络 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (245, 'PASS', '人工智能', '数据挖掘', ' 数据挖掘 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (246, 'PASS', '人工智能', '机器学习', ' 机器学习 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (247, 'PASS', '人工智能', '深度学习', ' 深度学习 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (248, 'PASS', '人工智能', 'tensorflow', ' tensorflow 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (249, 'PASS', 'iOS 开发', 'ios', ' ios 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (250, 'PASS', 'iOS 开发', 'objective-c', ' objective-c 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (251, 'PASS', 'iOS 开发', 'sqlite', ' sqlite 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (252, 'PASS', 'iOS 开发', 'safari', ' safari 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (253, 'PASS', 'iOS 开发', 'xcode', ' xcode 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (254, 'PASS', 'iOS 开发', 'phonegap', ' phonegap 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (255, 'PASS', 'iOS 开发', 'cocoa', ' cocoa 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (256, 'PASS', 'iOS 开发', 'macos', ' macos 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (257, 'PASS', 'iOS 开发', 'iphone', ' iphone 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (258, 'PASS', 'iOS 开发', 'ipad', ' ipad 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (259, 'PASS', 'iOS 开发', 'swift', ' swift 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (260, 'PASS', 'Android 开发', 'android', ' android 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (261, 'PASS', 'Android 开发', 'eclipse', ' eclipse 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (262, 'PASS', 'Android 开发', 'xml', ' xml 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (263, 'PASS', 'Android 开发', 'webview', ' webview 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (264, 'PASS', 'Android 开发', 'android-studio', ' android-studio 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (265, 'PASS', '数据库', 'mysql', ' mysql 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2022-04-12 16:38:55');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (266, 'PASS', 'PHP 开发', 'apache', ' apache 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (267, 'PASS', 'PHP 开发', 'nginx', ' nginx 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2022-04-08 14:48:47');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (268, 'PASS', 'PHP 开发', 'mvc', ' mvc 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (269, 'PASS', 'PHP 开发', 'symfony', ' symfony 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (270, 'PASS', 'PHP 开发', 'zend-framework', ' zend-framework 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (271, 'PASS', 'PHP 开发', 'composer', ' composer 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (272, 'PASS', 'PHP 开发', 'laravel', ' laravel 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (273, 'PASS', '数据库', '数据库', ' 数据库 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (274, 'PASS', '数据库', 'oracle', ' oracle 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (275, 'PASS', '数据库', 'sql', ' sql 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (276, 'PASS', '数据库', 'nosql', ' nosql 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (277, 'PASS', '数据库', 'redis', ' redis 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2022-04-12 16:38:55');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (278, 'PASS', '数据库', 'mongodb', ' mongodb 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (279, 'PASS', '数据库', 'memcached', ' memcached 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (280, 'PASS', '数据库', 'postgresql', ' postgresql 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (281, 'PASS', '.NET 开发', '.net', ' .net 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (282, 'PASS', '.NET 开发', 'asp.net', ' asp.net 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (283, 'PASS', '.NET 开发', 'visual-studio', ' visual-studio 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (284, 'PASS', '.NET 开发', 'microsoft', ' microsoft 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (285, 'PASS', 'Python 开发', 'List', ' List 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (286, 'PASS', 'Python 开发', 'django', ' django 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (287, 'PASS', 'Python 开发', 'flask', ' flask 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (288, 'PASS', 'Python 开发', 'tornado', ' tornado 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (289, 'PASS', 'Python 开发', 'web.py', ' web.py 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (290, 'PASS', 'Python 开发', 'sqlalchemy', ' sqlalchemy 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (291, 'PASS', 'Python 开发', 'virtualenv', ' virtualenv 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (292, 'PASS', 'Ruby 开发', 'ruby-on-rails', ' ruby-on-rails 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (293, 'PASS', 'Ruby 开发', 'rubygems', ' rubygems 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (294, 'PASS', 'Ruby 开发', 'rvm', ' rvm 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (295, 'PASS', 'Ruby 开发', 'macosx', ' macosx 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (296, 'PASS', 'Ruby 开发', 'bundle', ' bundle 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (297, 'PASS', '开发工具', 'vim', ' vim 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (298, 'PASS', '开发工具', 'emacs', ' emacs 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (299, 'PASS', '开发工具', 'ide', ' ide 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (300, 'PASS', '开发工具', 'intellij-idea', ' intellij-idea 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (301, 'PASS', '开发工具', 'textmate', ' textmate 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (302, 'PASS', '开发工具', 'sublime-text', ' sublime-text 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (303, 'PASS', '开发工具', 'git', ' git 标签描述', 1, 25, 0, '2020-11-10 12:03:01', '2022-04-13 08:49:40');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (304, 'PASS', '开发工具', 'github', ' github 标签描述', 1, 25, 0, '2020-11-10 12:03:01', '2022-04-13 08:49:40');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (305, 'PASS', '开发工具', 'svn', ' svn 标签描述', 1, 25, 0, '2020-11-10 12:03:01', '2022-04-13 08:49:40');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (306, 'PASS', '开发工具', 'hg', ' hg 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (307, 'PASS', '开发工具', 'docker', ' docker 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2022-04-12 16:38:55');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (308, 'PASS', '开发工具', 'ci', ' ci 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (309, 'PASS', '云计算', '云计算', ' 云计算 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (310, 'PASS', '云计算', '又拍云存储', ' 又拍云存储 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (311, 'PASS', '云计算', '七牛云存储', ' 七牛云存储 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (312, 'PASS', '云计算', 'amazon-web-services', ' amazon-web-services 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (313, 'PASS', '云计算', '百度云', ' 百度云 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (314, 'PASS', '云计算', '金山云', ' 金山云 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (315, 'PASS', '云计算', '美团云', ' 美团云 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (316, 'PASS', '云计算', '腾讯云', ' 腾讯云 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (317, 'PASS', '云计算', '云杉网络', ' 云杉网络 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (318, 'PASS', '云计算', 'deepflow', ' deepflow 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (319, 'PASS', '云计算', 'ucloud', ' ucloud 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (320, 'PASS', '云计算', '灵雀云', ' 灵雀云 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (321, 'PASS', '云计算', 'alauda', ' alauda 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (322, 'PASS', '大数据', '大数据', ' 大数据 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2022-04-08 14:48:47');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (323, 'PASS', '大数据', 'talkingdata', ' talkingdata 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (324, 'PASS', '大数据', '涛思数据', ' 涛思数据 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (325, 'PASS', '大数据', 'kylin', ' kylin 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (326, 'PASS', '大数据', 'flink', ' flink 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (327, 'PASS', '大数据', 'kafka', ' kafka 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2022-04-08 14:48:47');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (328, 'PASS', '大数据', 'tdengine', ' tdengine 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (329, 'PASS', '大数据', 'hadoop', ' hadoop 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (330, 'PASS', '大数据', 'spark', ' spark 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (331, 'PASS', '大数据', 'hdfs', ' hdfs 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (332, 'PASS', '大数据', 'mapreduce', ' mapreduce 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (333, 'PASS', '大数据', 'cloudera', ' cloudera 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (334, 'PASS', '大数据', 'hive', ' hive 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (335, 'PASS', '大数据', 'ambari', ' ambari 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (336, 'PASS', '大数据', 'sqoop', ' sqoop 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (337, 'PASS', '大数据', 'zookeeper', ' zookeeper 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (338, 'PASS', 'Java 开发', 'java-ee', ' java-ee 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2022-04-12 16:38:55');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (339, 'PASS', 'Java 开发', 'jar', ' jar 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (340, 'PASS', 'Java 开发', 'spring', ' spring 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2022-04-12 16:38:55');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (341, 'PASS', 'Java 开发', 'hibernate', ' hibernate 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (342, 'PASS', 'Java 开发', 'struts', ' struts 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (343, 'PASS', 'Java 开发', 'tomcat', ' tomcat 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2022-04-12 16:38:55');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (344, 'PASS', 'Java 开发', 'maven', ' maven 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (345, 'PASS', '搜索', '搜索引擎', ' 搜索引擎 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2022-04-12 16:38:55');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (346, 'PASS', '搜索', '中文分词', ' 中文分词 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2022-04-12 16:38:55');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (347, 'PASS', '搜索', '全文检索', ' 全文检索 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2022-04-12 16:38:55');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (348, 'PASS', '搜索', 'lucene', ' lucene 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2022-04-12 16:38:55');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (349, 'PASS', '搜索', 'solr', ' solr 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (350, 'PASS', '搜索', 'sphinx', ' sphinx 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (351, 'PASS', '搜索', 'analyzer', ' analyzer 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (352, 'PASS', '搜索', 'elasticsearch', ' elasticsearch 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2022-04-12 16:38:55');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (353, 'PASS', '搜索', 'elastic', ' elastic 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (354, 'PASS', '开放平台', '微信', ' 微信 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2022-04-12 16:38:55');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (355, 'PASS', '开放平台', '百度', ' 百度 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (356, 'PASS', '开放平台', 'facebook', ' facebook 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (357, 'PASS', '开放平台', 'twitter', ' twitter 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (358, 'PASS', '开放平台', 'paddle', ' paddle 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (359, 'PASS', '开放平台', '微信公众平台', ' 微信公众平台 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (360, 'PASS', '开放平台', '微信开放平台', ' 微信开放平台 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2022-04-08 14:30:05');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (361, 'PASS', '服务器', 'linux', ' linux 标签描述', 1, 25, 0, '2020-11-10 12:03:01', '2022-04-13 08:59:35');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (362, 'PASS', '服务器', 'unix', 'Unix是20世纪70年代初出现的一个操作系统,除了作为网络操作系统之外,还可以作为单机操作系统使用。Unix作为一种开发平台和台式操作系统获得了广泛使用,主要用于工程应用和科学计算等领域。', 1, 25, 0, '2020-11-10 12:03:01', '2022-04-13 12:46:04');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (363, 'PASS', '服务器', 'ubuntu', ' ubuntu 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (364, 'PASS', '服务器', 'windows-server', ' windows-server 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (365, 'PASS', '服务器', 'centos', ' centos 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (366, 'PASS', '服务器', '负载均衡', ' 负载均衡 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2022-04-08 14:30:05');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (367, 'PASS', '服务器', '缓存', ' 缓存 标签描述', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (368, 'PASS', '开源', '社区', '社区标签描述', 1, 25, 0, '2020-11-10 12:03:01', '2022-04-13 08:59:35');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (369, 'PASS', '其他', '读书', '读书分享、读书心得、读书笔记', 0, 25, 0, '2020-11-10 12:03:01', '2022-04-08 14:30:05');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (370, 'PASS', 'Java 开发', 'netty', 'netty是异步的、事件驱动的网络应用程序框架和工具。', 0, 25, 0, '2020-11-10 12:03:01', '2022-04-08 14:30:05');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (371, 'PASS', 'Java 开发', 'spring boot', 'spring boot开发脚手架', 0, 25, 0, '2020-11-10 12:03:01', '2022-04-08 14:30:05');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (372, 'PASS', '安全', 'ddos', 'ddos分布式拒绝服务攻击', 0, 25, 0, '2020-11-10 12:03:01', '2022-04-08 14:30:05');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (373, 'PASS', 'Java 开发', 'dubbo', 'dubbo rpc框架', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (374, 'PASS', 'Java 开发', 'spring cloud', 'spring cloud微服务开发框架', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (375, 'PASS', 'Java 开发', 'jvm', 'java虚拟机', 0, 25, 0, '2020-11-10 12:03:01', '2022-04-08 14:30:05');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (376, 'PASS', '其他', '其他', '其他', 0, 25, 0, '2020-11-10 12:03:01', '2022-04-08 14:30:05');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (377, 'PASS', '开源', '开源', '“开源(open source)”这个词,指的是事物规划为可以公开访问的,因此人们可以修改并分享。\n\n这个词最初是起源于软件开发中,指的是一种开发软件的特殊形式。但到了今天,“开源”已经泛指一组概念——就是我们称之为的“开源的方式”。这些概念包括开源项目、产品,或是自发倡导并欢迎开放变化、协作参与、快速原型、公开透明、精英体制以及面向社区开发的原则。', 2, 25, 0, '2020-11-10 12:03:01', '2022-04-13 12:38:51');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (378, 'PASS', 'Java 开发', 'rabbitmq', 'rabbitmq消息队列', 0, 25, 0, '2020-11-10 12:03:01', '2022-04-08 14:30:05');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (379, 'PASS', 'Java 开发', 'rocketmq', 'rocketmq消息队列', 0, 25, 0, '2020-11-10 12:03:01', '2020-11-10 12:03:01');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (383, NULL, '测试测试测试', '测试测试测试', '测试测试测试测试测试\n测试测试测试测试测试\n测试测试测试测试测试\n测试测试测试测试测试', 0, NULL, 1, '2022-04-19 15:50:30', '2022-04-19 15:50:30');
INSERT INTO `tag` (`id`, `audit_state`, `group_name`, `name`, `description`, `ref_count`, `creator_id`, `is_delete`, `create_at`, `update_at`) VALUES (384, NULL, '开发语言', '测试测试', '测试测试', 0, NULL, 1, '2022-04-19 15:51:08', '2022-04-19 15:51:08');
COMMIT;
-- ----------------------------
-- Table structure for tag_posts_mapping
-- ----------------------------
DROP TABLE IF EXISTS `tag_posts_mapping`;
CREATE TABLE `tag_posts_mapping` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`tag_id` bigint NOT NULL COMMENT '标签ID',
`posts_id` bigint NOT NULL COMMENT '帖子ID',
`is_delete` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '删除标识(0:未删除、1:已删除)',
`create_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '记录创建时间',
`update_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '记录修改时间',
PRIMARY KEY (`id`),
UNIQUE KEY `uniq_posts_tag` (`posts_id`,`tag_id`)
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='标签-帖子关系表';
-- ----------------------------
-- Records of tag_posts_mapping
-- ----------------------------
BEGIN;
INSERT INTO `tag_posts_mapping` (`id`, `tag_id`, `posts_id`, `is_delete`, `create_at`, `update_at`) VALUES (5, 208, 295, 0, '2022-03-03 01:10:32', '2022-04-09 14:24:37');
INSERT INTO `tag_posts_mapping` (`id`, `tag_id`, `posts_id`, `is_delete`, `create_at`, `update_at`) VALUES (6, 236, 295, 0, '2022-03-03 01:16:06', '2022-04-09 14:24:37');
INSERT INTO `tag_posts_mapping` (`id`, `tag_id`, `posts_id`, `is_delete`, `create_at`, `update_at`) VALUES (7, 235, 295, 0, '2022-03-03 01:16:06', '2022-04-09 14:24:37');
INSERT INTO `tag_posts_mapping` (`id`, `tag_id`, `posts_id`, `is_delete`, `create_at`, `update_at`) VALUES (8, 240, 295, 0, '2022-03-03 01:16:32', '2022-04-09 14:24:37');
INSERT INTO `tag_posts_mapping` (`id`, `tag_id`, `posts_id`, `is_delete`, `create_at`, `update_at`) VALUES (9, 236, 309, 0, '2022-03-07 20:25:29', '2022-04-08 14:04:11');
INSERT INTO `tag_posts_mapping` (`id`, `tag_id`, `posts_id`, `is_delete`, `create_at`, `update_at`) VALUES (10, 188, 303, 0, '2022-04-13 09:11:50', '2022-04-13 09:11:50');
INSERT INTO `tag_posts_mapping` (`id`, `tag_id`, `posts_id`, `is_delete`, `create_at`, `update_at`) VALUES (11, 188, 295, 0, '2022-03-03 01:10:32', '2022-04-09 14:24:37');
INSERT INTO `tag_posts_mapping` (`id`, `tag_id`, `posts_id`, `is_delete`, `create_at`, `update_at`) VALUES (12, 209, 295, 0, '2022-03-03 01:10:32', '2022-04-09 14:24:37');
INSERT INTO `tag_posts_mapping` (`id`, `tag_id`, `posts_id`, `is_delete`, `create_at`, `update_at`) VALUES (13, 207, 295, 0, '2022-03-03 01:10:32', '2022-04-09 14:24:37');
INSERT INTO `tag_posts_mapping` (`id`, `tag_id`, `posts_id`, `is_delete`, `create_at`, `update_at`) VALUES (14, 218, 295, 0, '2022-03-03 01:10:32', '2022-04-09 14:24:37');
INSERT INTO `tag_posts_mapping` (`id`, `tag_id`, `posts_id`, `is_delete`, `create_at`, `update_at`) VALUES (15, 218, 285, 0, '2022-03-03 01:10:32', '2022-04-09 14:24:37');
INSERT INTO `tag_posts_mapping` (`id`, `tag_id`, `posts_id`, `is_delete`, `create_at`, `update_at`) VALUES (16, 207, 319, 0, '2022-03-03 01:10:32', '2022-04-09 14:24:37');
INSERT INTO `tag_posts_mapping` (`id`, `tag_id`, `posts_id`, `is_delete`, `create_at`, `update_at`) VALUES (54, 303, 338, 0, '2022-04-13 08:49:40', '2022-04-13 08:49:40');
INSERT INTO `tag_posts_mapping` (`id`, `tag_id`, `posts_id`, `is_delete`, `create_at`, `update_at`) VALUES (55, 304, 338, 0, '2022-04-13 08:49:40', '2022-04-13 08:49:40');
INSERT INTO `tag_posts_mapping` (`id`, `tag_id`, `posts_id`, `is_delete`, `create_at`, `update_at`) VALUES (56, 305, 338, 0, '2022-04-13 08:49:40', '2022-04-13 08:49:40');
INSERT INTO `tag_posts_mapping` (`id`, `tag_id`, `posts_id`, `is_delete`, `create_at`, `update_at`) VALUES (57, 377, 339, 0, '2022-04-13 08:52:18', '2022-04-13 08:52:18');
INSERT INTO `tag_posts_mapping` (`id`, `tag_id`, `posts_id`, `is_delete`, `create_at`, `update_at`) VALUES (58, 361, 340, 0, '2022-04-13 08:59:35', '2022-04-13 08:59:35');
INSERT INTO `tag_posts_mapping` (`id`, `tag_id`, `posts_id`, `is_delete`, `create_at`, `update_at`) VALUES (59, 362, 340, 0, '2022-04-13 08:59:35', '2022-04-13 08:59:35');
INSERT INTO `tag_posts_mapping` (`id`, `tag_id`, `posts_id`, `is_delete`, `create_at`, `update_at`) VALUES (60, 368, 340, 0, '2022-04-13 08:59:35', '2022-04-13 08:59:35');
INSERT INTO `tag_posts_mapping` (`id`, `tag_id`, `posts_id`, `is_delete`, `create_at`, `update_at`) VALUES (61, 377, 340, 0, '2022-04-13 08:59:35', '2022-04-13 08:59:35');
COMMIT;
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` int NOT NULL AUTO_INCREMENT,
`username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名',
`password` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户密码',
`salt` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '辅助密码加密存储',
`email` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '邮箱',
`type` int DEFAULT NULL COMMENT '0-普通用户; 1-超级管理员; 2-版主;',
`status` int DEFAULT NULL COMMENT '0-未激活; 1-已激活;',
`activation_code` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '激活码',
`header_url` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '头像url',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
PRIMARY KEY (`id`),
KEY `index_username` (`username`(20)),
KEY `index_email` (`email`(20))
) ENGINE=InnoDB AUTO_INCREMENT=164 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` (`id`, `username`, `password`, `salt`, `email`, `type`, `status`, `activation_code`, `header_url`, `create_time`) VALUES (1, 'SYSTEM', 'SYSTEM', 'SYSTEM', 'coder@sina.com', -1, -1, NULL, 'http://static.nowcoder.com/images/head/notify.png', '2022-04-19 21:31:27');
INSERT INTO `user` (`id`, `username`, `password`, `salt`, `email`, `type`, `status`, `activation_code`, `header_url`, `create_time`) VALUES (11, 'admin', 'f631a105e881566aafae7a883aaa1949', '49f10', 'coder@sina.com', 1, 1, NULL, 'http://localhost:8080/community/user-avatar/3cdd865f632a4784b566323486a8b111.jpg', '2019-04-17 17:11:27');
INSERT INTO `user` (`id`, `username`, `password`, `salt`, `email`, `type`, `status`, `activation_code`, `header_url`, `create_time`) VALUES (12, 'admin2', 'f631a105e881566aafae7a883aaa1949', '49f10', 'coder@sina.com', 2, 1, NULL, 'http://images.nowcoder.com/head/12t.png', '2022-04-26 21:06:26');
INSERT INTO `user` (`id`, `username`, `password`, `salt`, `email`, `type`, `status`, `activation_code`, `header_url`, `create_time`) VALUES (13, 'coder13', '25ac0a2e8bd0f28928de3c56149283d6', '49f10', 'coder@sina.com', 2, 1, NULL, 'http://images.nowcoder.com/head/13t.png', '2022-04-19 21:35:47');
INSERT INTO `user` (`id`, `username`, `password`, `salt`, `email`, `type`, `status`, `activation_code`, `header_url`, `create_time`) VALUES (22, 'coder22', '25ac0a2e8bd0f28928de3c56149283d6', '49f10', 'coder@sina.com', 0, 0, NULL, 'http://images.nowcoder.com/head/22t.png', '2022-04-19 21:36:09');
INSERT INTO `user` (`id`, `username`, `password`, `salt`, `email`, `type`, `status`, `activation_code`, `header_url`, `create_time`) VALUES (23, 'coder23', '25ac0a2e8bd0f28928de3c56149283d6', '49f10', 'coder@sina.com', 0, 0, NULL, 'http://images.nowcoder.com/head/23t.png', '2022-04-19 21:36:09');
INSERT INTO `user` (`id`, `username`, `password`, `salt`, `email`, `type`, `status`, `activation_code`, `header_url`, `create_time`) VALUES (24, 'coder24', '25ac0a2e8bd0f28928de3c56149283d6', '49f10', 'coder@sina.com', 0, 1, NULL, 'http://images.nowcoder.com/head/24t.png', '2022-04-19 21:36:09');
INSERT INTO `user` (`id`, `username`, `password`, `salt`, `email`, `type`, `status`, `activation_code`, `header_url`, `create_time`) VALUES (25, 'coder25', '25ac0a2e8bd0f28928de3c56149283d6', '49f10', 'coder@sina.com', 0, 1, NULL, 'http://images.nowcoder.com/head/25t.png', '2022-04-19 21:36:09');
INSERT INTO `user` (`id`, `username`, `password`, `salt`, `email`, `type`, `status`, `activation_code`, `header_url`, `create_time`) VALUES (111, 'aaa', 'b8ca3cbc6fd57c78736c66611a7e7044', '167f9', 'coder@sina.com', 0, 1, NULL, 'http://localhost:8080/community/user-avatar/d8c85120ee1e40eb806ded40f42b4b72.jpg', '2019-04-03 15:31:19');
INSERT INTO `user` (`id`, `username`, `password`, `salt`, `email`, `type`, `status`, `activation_code`, `header_url`, `create_time`) VALUES (112, 'bbb', '216dc48902665b6a6dba534717d49592', '90ad0', 'coder@sina.com', 0, 1, NULL, 'http://images.nowcoder.com/head/112t.png', '2019-04-04 18:36:24');
INSERT INTO `user` (`id`, `username`, `password`, `salt`, `email`, `type`, `status`, `activation_code`, `header_url`, `create_time`) VALUES (113, 'ccc', '511247cf6bf9cf3d37aef555d0dd9b75', 'fe290', 'coder@sina.com', 0, 1, NULL, 'http://images.nowcoder.com/head/705t.png', '2019-04-06 21:29:52');
INSERT INTO `user` (`id`, `username`, `password`, `salt`, `email`, `type`, `status`, `activation_code`, `header_url`, `create_time`) VALUES (114, 'ddd', 'd432b1aaec9197cb6e23ed8e335fe42f', 'fd1b1', 'coder@sina.com', 0, 1, NULL, 'http://images.nowcoder.com/head/972t.png', '2019-04-06 21:30:36');
INSERT INTO `user` (`id`, `username`, `password`, `salt`, `email`, `type`, `status`, `activation_code`, `header_url`, `create_time`) VALUES (115, 'eee', 'caca1fe634005d505afd82ef7874fc4f', '0c8d2', 'coder@sina.com', 0, 1, NULL, 'http://images.nowcoder.com/head/316t.png', '2019-04-06 21:30:48');
INSERT INTO `user` (`id`, `username`, `password`, `salt`, `email`, `type`, `status`, `activation_code`, `header_url`, `create_time`) VALUES (116, 'fff', 'deda51913a3ae16d9915fc4c520ac4b6', '19341', 'coder@sina.com', 0, 1, NULL, 'http://images.nowcoder.com/head/180t.png', '2019-04-06 21:31:00');
INSERT INTO `user` (`id`, `username`, `password`, `salt`, `email`, `type`, `status`, `activation_code`, `header_url`, `create_time`) VALUES (117, 'ggg', '4e85bff4afbb34b2dd676f5e5737050f', '9931d', 'coder@sina.com', 0, 1, NULL, 'http://images.nowcoder.com/head/896t.png', '2019-04-06 21:31:19');
INSERT INTO `user` (`id`, `username`, `password`, `salt`, `email`, `type`, `status`, `activation_code`, `header_url`, `create_time`) VALUES (118, 'hhh', '8d4c0d490ea1585cd7973bb55bd39d07', 'e123d', 'coder@sina.com', 0, 1, NULL, 'http://images.nowcoder.com/head/834t.png', '2019-04-06 21:38:18');
INSERT INTO `user` (`id`, `username`, `password`, `salt`, `email`, `type`, `status`, `activation_code`, `header_url`, `create_time`) VALUES (119, 'iii', '2214de584a27c7c28dd46a9505bfdc8b', 'f8880', 'coder@sina.com', 0, 1, NULL, 'http://images.nowcoder.com/head/240t.png', '2019-04-06 21:38:33');
INSERT INTO `user` (`id`, `username`, `password`, `salt`, `email`, `type`, `status`, `activation_code`, `header_url`, `create_time`) VALUES (120, 'jjj', '9522866891d647323a7fb5c640b8fa37', '12c25', 'coder@sina.com', 0, 1, NULL, 'http://images.nowcoder.com/head/760t.png', '2019-04-06 21:39:45');
INSERT INTO `user` (`id`, `username`, `password`, `salt`, `email`, `type`, `status`, `activation_code`, `header_url`, `create_time`) VALUES (121, 'kkk', '5a80e7d897dec9b0aec2919fb42a158e', 'b8710', 'coder@sina.com', 0, 1, NULL, 'http://images.nowcoder.com/head/358t.png', '2019-04-06 21:41:34');
INSERT INTO `user` (`id`, `username`, `password`, `salt`, `email`, `type`, `status`, `activation_code`, `header_url`, `create_time`) VALUES (122, 'lll', 'fdc3616df634614bc0ffacee17f735bd', 'b067f', 'coder@sina.com', 0, 1, NULL, 'http://images.nowcoder.com/head/70t.png', '2019-04-06 21:45:36');
INSERT INTO `user` (`id`, `username`, `password`, `salt`, `email`, `type`, `status`, `activation_code`, `header_url`, `create_time`) VALUES (123, 'mmm', 'd9b57ddfa9faa06c581c803dc2811edb', 'f7014', 'coder@sina.com', 0, 1, NULL, 'http://images.nowcoder.com/head/160t.png', '2019-04-06 21:48:34');
INSERT INTO `user` (`id`, `username`, `password`, `salt`, `email`, `type`, `status`, `activation_code`, `header_url`, `create_time`) VALUES (124, 'nnn', 'f878b7181a95a3330d90198deab16aca', 'bbf47', 'coder@sina.com', 0, 1, NULL, 'http://images.nowcoder.com/head/506t.png', '2019-04-06 21:49:39');
INSERT INTO `user` (`id`, `username`, `password`, `salt`, `email`, `type`, `status`, `activation_code`, `header_url`, `create_time`) VALUES (125, 'ooo', 'f71e07cc9c6ebb9e8cfc1fc58265ff33', 'ff72a', 'coder@sina.com', 0, 1, NULL, 'http://images.nowcoder.com/head/45t.png', '2019-04-06 21:50:35');
INSERT INTO `user` (`id`, `username`, `password`, `salt`, `email`, `type`, `status`, `activation_code`, `header_url`, `create_time`) VALUES (126, 'ppp', 'e2f178c5076dabbb35b73da19774b271', '5027b', 'coder@sina.com', 0, 1, NULL, 'http://images.nowcoder.com/head/771t.png', '2019-04-06 21:51:42');
INSERT INTO `user` (`id`, `username`, `password`, `salt`, `email`, `type`, `status`, `activation_code`, `header_url`, `create_time`) VALUES (127, 'qqq', 'd209b28b19fdcb4aafc3a795157a4651', '3aebf', 'coder@sina.com', 0, 1, NULL, 'http://images.nowcoder.com/head/492t.png', '2019-04-06 21:52:29');
INSERT INTO `user` (`id`, `username`, `password`, `salt`, `email`, `type`, `status`, `activation_code`, `header_url`, `create_time`) VALUES (128, 'rrr', 'a6043995e741593540687d87c1ce40e8', 'c543c', 'coder@sina.com', 0, 1, NULL, 'http://images.nowcoder.com/head/779t.png', '2019-04-06 21:53:19');
INSERT INTO `user` (`id`, `username`, `password`, `salt`, `email`, `type`, `status`, `activation_code`, `header_url`, `create_time`) VALUES (129, 'sss', 'ae8754f0d791f9fea1627a1862c4de5f', 'd3641', 'coder@sina.com', 0, 1, NULL, 'http://images.nowcoder.com/head/977t.png', '2019-04-06 21:57:34');
INSERT INTO `user` (`id`, `username`, `password`, `salt`, `email`, `type`, `status`, `activation_code`, `header_url`, `create_time`) VALUES (131, 'ttt', 'd50960f067142c59cc3bdac61b87759f', '72450', 'coder@sina.com', 0, 1, NULL, 'http://images.nowcoder.com/head/677t.png', '2019-04-08 12:05:49');
INSERT INTO `user` (`id`, `username`, `password`, `salt`, `email`, `type`, `status`, `activation_code`, `header_url`, `create_time`) VALUES (132, 'uuu', 'a80ba77157d2fd9c67dd3187907cef42', 'f1113', 'coder@sina.com', 0, 1, NULL, 'http://images.nowcoder.com/head/278t.png', '2019-04-08 14:07:04');
INSERT INTO `user` (`id`, `username`, `password`, `salt`, `email`, `type`, `status`, `activation_code`, `header_url`, `create_time`) VALUES (133, 'vvv', '252c226ba0a601ec3fa4d7c58b2291d9', '13211', 'coder@sina.com', 0, 1, NULL, 'http://images.nowcoder.com/head/133t.png', '2019-04-19 11:08:55');
INSERT INTO `user` (`id`, `username`, `password`, `salt`, `email`, `type`, `status`, `activation_code`, `header_url`, `create_time`) VALUES (134, 'www', '3d3aeebb9cd302ae581dfa8fedd86ceb', 'dfc00', 'coder@sina.com', 0, 1, NULL, 'http://images.nowcoder.com/head/134t.png', '2019-04-19 18:13:57');
INSERT INTO `user` (`id`, `username`, `password`, `salt`, `email`, `type`, `status`, `activation_code`, `header_url`, `create_time`) VALUES (137, 'xxx', '046291c11cdfb896aa7cd48714bb6352', '968fc', 'coder@sina.com', 0, 1, NULL, 'http://images.nowcoder.com/head/677t.png', '2019-04-26 19:48:31');
INSERT INTO `user` (`id`, `username`, `password`, `salt`, `email`, `type`, `status`, `activation_code`, `header_url`, `create_time`) VALUES (138, 'yyy', '046291c11cdfb896aa7cd48714bb6352', '968fc', 'coder@sina.com', 0, 1, '69dcd69f4c0145058df820e90820ba1e', 'http://images.nowcoder.com/head/138t.png', '2019-04-25 15:18:07');
INSERT INTO `user` (`id`, `username`, `password`, `salt`, `email`, `type`, `status`, `activation_code`, `header_url`, `create_time`) VALUES (144, 'zzz', '07b83b7747ca08bc4b0153d5b8ce7519', '21e8b', 'coder@sina.com', 0, 1, '107eb2cbb8454fbe96848790e6a730b1', 'http://images.nowcoder.com/head/144t.png', '2019-04-26 16:59:50');
INSERT INTO `user` (`id`, `username`, `password`, `salt`, `email`, `type`, `status`, `activation_code`, `header_url`, `create_time`) VALUES (145, 'lhh', 'd980a16ea0b3c8a81062ee806e65a4bc', '5abfc', 'coder@sina.com', 0, 1, 'f217b637e9544e2a9b4a88f78c583d03', 'http://images.nowcoder.com/head/145t.png', '2019-04-28 15:30:36');
INSERT INTO `user` (`id`, `username`, `password`, `salt`, `email`, `type`, `status`, `activation_code`, `header_url`, `create_time`) VALUES (146, 'lihonghe', '100489ece9bacfa4d57eb5777b4d4643', '00d7a', 'coder@sina.com', 0, 1, '5a61faee7af94e89ba7237b1277c9fed', 'http://images.nowcoder.com/head/146t.png', '2019-04-29 11:47:24');
INSERT INTO `user` (`id`, `username`, `password`, `salt`, `email`, `type`, `status`, `activation_code`, `header_url`, `create_time`) VALUES (149, 'hcjjj', 'ebce124c4ba2de3be92dc9a3bc1ea75b', '90196', 'coder@sina.com', 0, 1, 'd7a5714a145b4461b5a4199cc5a0014f', 'http://images.nowcoder.com/head/149t.png', '2022-04-19 21:16:06');
INSERT INTO `user` (`id`, `username`, `password`, `salt`, `email`, `type`, `status`, `activation_code`, `header_url`, `create_time`) VALUES (153, 'hcj', '4bfc7071a2e6a4f0d21253ac35068f61', 'c78ce', 'hcj@foxmail.com', 0, 1, 'ba50f2978b68489da49d7de33677d9b1', 'http://localhost:8080/community/user-avatar/0a6b5d6205a246ada5417e4ef6597236.jpg', '2022-02-05 16:03:25');
INSERT INTO `user` (`id`, `username`, `password`, `salt`, `email`, `type`, `status`, `activation_code`, `header_url`, `create_time`) VALUES (163, 'test', 'a028576dbd84be00d0fcfe6449649212', '12a99', 'hcjjj@foxmail.com', 0, 1, 'b3bb3389ff3d4055bbb4f1ca1190ad7b', 'http://images.nowcoder.com/head/253t.png', '2022-04-27 15:53:48');
COMMIT;
SET FOREIGN_KEY_CHECKS = 1;