-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathalexa_admin.sql
More file actions
1163 lines (1108 loc) · 61.9 KB
/
alexa_admin.sql
File metadata and controls
1163 lines (1108 loc) · 61.9 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
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
-- phpMyAdmin SQL Dump
-- version 4.6.5.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: 2018-01-12 10:58:06
-- 服务器版本： 10.1.21-MariaDB
-- PHP Version: 5.6.30
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `alexa_admin`
--
-- --------------------------------------------------------
--
-- 表的结构 `alexa_admin`
--
CREATE TABLE `alexa_admin` (
`id` int(11) NOT NULL,
`username` varchar(20) NOT NULL,
`password` varchar(225) NOT NULL,
`count` int(11) DEFAULT '1',
`email` varchar(100) NOT NULL,
`role` tinyint(1) DEFAULT '1' COMMENT '0为超级管理员,1为管理员',
`switch` varchar(5) DEFAULT 'true' COMMENT 'true为开启,false为关闭',
`update_time` int(11) DEFAULT NULL,
`create_time` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
--
-- 转存表中的数据 `alexa_admin`
--
INSERT INTO `alexa_admin` (`id`, `username`, `password`, `count`, `email`, `role`, `switch`, `update_time`, `create_time`) VALUES
(1, 'ferre', '6226514790b1175cf90bca075f3887a6c54ef58e', 55, '1573646491@qq.com', 0, 'true', 1515750624, 1513926388),
(3, 'root', '6226514790b1175cf90bca075f3887a6c54ef58e', 8, '1573646491@qq.com', 1, 'true', 1515575528, 1514172018),
(4, 'alexa', '6226514790b1175cf90bca075f3887a6c54ef58e', 3, '123@qq.com', 1, 'true', 1514969258, 1514966522),
(7, 'Rick', '7110eda4d09e062aa5e4a390b0a572ac0d2c0220', 1, '123@qq.com', 1, 'false', 1515576815, 1515576815),
(8, 'Freeze', '7110eda4d09e062aa5e4a390b0a572ac0d2c0220', 1, '1573646491@qq.com', 1, 'false', 1515577073, 1515577073),
(17, 'YYF', 'cb89c0b02495e9bbd1d2f99f1abe1b6c01b2e38b', 1, '1573646491@qq.com', 0, 'false', 1515651524, 1515638468),
(18, 'asd', '011c945f30ce2cbafc452f39840f025693339c42', 1, '1573646491@qq.com', 0, 'true', 1515728342, 1515728342);
-- --------------------------------------------------------
--
-- 表的结构 `alexa_alog`
--
CREATE TABLE `alexa_alog` (
`id` int(11) NOT NULL,
`type` tinyint(4) NOT NULL,
`name` varchar(255) NOT NULL,
`ip` varchar(255) NOT NULL,
`time` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `alexa_alog`
--
INSERT INTO `alexa_alog` (`id`, `type`, `name`, `ip`, `time`) VALUES
(1, 1, 'ferre', '127.0.0.1', 1512548564),
(2, 1, '127.0.0.1', '127.0.0.1', 1512548920),
(3, 1, 'ferre', '127.0.0.1', 1512548928),
(4, 1, 'ferre', '127.0.0.1', 1512549457),
(5, 0, '127.0.0.1', '127.0.0.1', 1512549461),
(6, 1, 'ferre', '127.0.0.1', 1512549466),
(7, 0, '弗雷尔', '127.0.0.1', 1512549887),
(8, 1, 'ferre', '127.0.0.1', 1512549892),
(9, 1, 'ferre', '127.0.0.1', 1512612399),
(10, 1, 'ferre', '127.0.0.1', 1512700862),
(11, 1, 'ferre', '127.0.0.1', 1512976444),
(12, 1, 'ferre', '127.0.0.1', 1513130910),
(13, 0, 'ferre', '127.0.0.1', 1513931337),
(14, 0, 'ferre', '127.0.0.1', 1513931370),
(15, 1, 'ferre', '127.0.0.1', 1513931422),
(16, 0, '123', '127.0.0.1', 1513931565),
(17, 0, '123', '127.0.0.1', 1513931567),
(18, 0, '123', '127.0.0.1', 1513932261),
(19, 0, '213', '127.0.0.1', 1513932353),
(20, 1, 'ferre', '127.0.0.1', 1513932358),
(21, 1, 'ferre', '127.0.0.1', 1513932466),
(22, 1, 'ferre', '127.0.0.1', 1513932485),
(23, 1, 'ferre', '127.0.0.1', 1513932494),
(24, 1, 'ferre', '127.0.0.1', 1513932539),
(25, 1, 'ferre', '127.0.0.1', 1513932589),
(26, 1, 'ferre', '127.0.0.1', 1513932718),
(27, 1, 'ferre', '127.0.0.1', 1513933220),
(28, 1, 'ferre', '127.0.0.1', 1513933311),
(29, 1, 'ferre', '127.0.0.1', 1513933432),
(30, 0, 'root', '127.0.0.1', 1513936006),
(31, 0, 'root', '127.0.0.1', 1513936078),
(32, 1, 'ferre', '127.0.0.1', 1513936085),
(33, 0, 'root', '127.0.0.1', 1513936110),
(34, 1, 'root', '127.0.0.1', 1514166200),
(35, 1, 'root', '127.0.0.1', 1514166204),
(36, 1, 'ferre', '127.0.0.1', 1514167965),
(37, 1, 'root', '127.0.0.1', 1514167973),
(38, 1, 'root', '127.0.0.1', 1514167980),
(39, 1, 'root', '127.0.0.1', 1514169474),
(40, 1, 'root', '127.0.0.1', 1514169490),
(41, 1, 'root', '127.0.0.1', 1514172027),
(42, 1, 'root', '127.0.0.1', 1514190751),
(43, 1, 'root', '127.0.0.1', 1514192690),
(44, 1, 'ferre', '127.0.0.1', 1514193952),
(45, 1, 'root', '127.0.0.1', 1514194000),
(46, 1, 'ferre', '127.0.0.1', 1514273313),
(47, 1, 'root', '127.0.0.1', 1514273505),
(48, 1, 'ferre', '127.0.0.1', 1514519440),
(49, 1, 'ferre', '127.0.0.1', 1514945977),
(50, 1, 'ferre', '127.0.0.1', 1514965498),
(51, 1, 'ferre', '127.0.0.1', 1514965611),
(52, 1, 'ferre', '127.0.0.1', 1514965630),
(53, 1, 'ferre', '127.0.0.1', 1514965673),
(54, 1, 'ferre', '127.0.0.1', 1514965724),
(55, 1, 'root', '127.0.0.1', 1514965948),
(56, 1, 'ferre', '127.0.0.1', 1514966218),
(57, 1, 'alexa', '127.0.0.1', 1514966529),
(58, 1, 'ferre', '127.0.0.1', 1514966627),
(59, 0, 'alexa', '127.0.0.1', 1514966943),
(60, 1, 'ferre', '127.0.0.1', 1514966949),
(61, 1, 'ferre', '127.0.0.1', 1514967411),
(62, 1, 'ferre', '127.0.0.1', 1514969132),
(63, 1, 'alexa', '127.0.0.1', 1514969159),
(64, 1, 'ferre', '127.0.0.1', 1514969244),
(65, 1, 'alexa', '127.0.0.1', 1514969257),
(66, 1, 'ferre', '127.0.0.1', 1515033598),
(67, 1, 'ferre', '127.0.0.1', 1515050225),
(68, 0, 'alexa1', '123', 1514966943),
(69, 1, 'ferre', '123', 1514966627),
(71, 0, 'alexa', '123', 1514793094),
(72, 1, 'freeze', '321', 1514793094),
(73, 0, 'hate', '213', 1514793094),
(74, 0, 'as', '1', 1514793094),
(75, 1, 'ferre', '127.0.0.1', 1515119061),
(76, 1, 'ferre', '127.0.0.1', 1515402042),
(77, 1, 'ferre', '127.0.0.1', 1515479746),
(78, 1, 'root', '127.0.0.1', 1515479865),
(79, 1, 'ferre', '127.0.0.1', 1515480169),
(80, 1, 'ferre', '127.0.0.1', 1515484508),
(81, 1, 'ferre', '127.0.0.1', 1515492059),
(82, 1, 'ferre', '127.0.0.1', 1515553231),
(83, 1, 'ferre', '127.0.0.1', 1515636357),
(84, 0, 'ferre超级管理员', '127.0.0.1', 1515643296),
(85, 1, 'ferre', '127.0.0.1', 1515643304),
(86, 1, 'ferre', '127.0.0.1', 1515750624);
-- --------------------------------------------------------
--
-- 表的结构 `alexa_article`
--
CREATE TABLE `alexa_article` (
`id` int(11) NOT NULL,
`author` varchar(50) NOT NULL DEFAULT 'Ferre',
`title` text NOT NULL,
`cate` text NOT NULL,
`order` int(11) NOT NULL,
`content` text NOT NULL,
`thumb` text NOT NULL,
`desc` text NOT NULL,
`see` int(11) NOT NULL,
`keywords` text NOT NULL,
`time` int(11) DEFAULT NULL,
`pic` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `alexa_article`
--
INSERT INTO `alexa_article` (`id`, `author`, `title`, `cate`, `order`, `content`, `thumb`, `desc`, `see`, `keywords`, `time`, `pic`) VALUES
(3, 'Ferre', 'Alexa', '1', 1, '<p>风景指的是供<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E8%A7%82%E8%B5%8F\" style=\"color: rgb(19, 110, 194); text-decoration-line: none;\">观赏</a>的自然风光、景物，包括<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E8%87%AA%E7%84%B6%E6%99%AF%E8%A7%82/68027\" data-lemmaid=\"68027\" style=\"color: rgb(19, 110, 194); text-decoration-line: none;\">自然景观</a>和<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E4%BA%BA%E6%96%87%E6%99%AF%E8%A7%82\" style=\"color: rgb(19, 110, 194); text-decoration-line: none;\">人文景观</a>。</p><p>风景是由光对物的反映所显露出来的一种<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E6%99%AF%E8%B1%A1\" style=\"color: rgb(19, 110, 194); text-decoration-line: none;\">景象</a>。犹言<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E9%A3%8E%E5%85%89/32760\" data-lemmaid=\"32760\" style=\"color: rgb(19, 110, 194); text-decoration-line: none;\">风光</a>或<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E6%99%AF%E7%89%A9\" style=\"color: rgb(19, 110, 194); text-decoration-line: none;\">景物</a>、<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E6%99%AF%E8%89%B2\" style=\"color: rgb(19, 110, 194); text-decoration-line: none;\">景色</a>等，含义广泛。在中国古书上，尤其纯文艺作品的<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E8%AF%97%E6%96%87\" style=\"color: rgb(19, 110, 194); text-decoration-line: none;\">诗文</a>方面，更是延用已久<em>，</em>甚至写景多于<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E8%A8%80%E6%83%85\" style=\"color: rgb(19, 110, 194); text-decoration-line: none;\">言情</a>，几乎和<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E6%97%85%E6%B8%B8\" style=\"color: rgb(19, 110, 194); text-decoration-line: none;\">旅游</a>打成一片。而且还有一大部分作品是<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E5%80%9F%E6%99%AF%E6%8A%92%E6%83%85\" style=\"color: rgb(19, 110, 194); text-decoration-line: none;\">借景抒情</a>，<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E5%AF%93%E6%83%85%E4%BA%8E%E6%99%AF\" style=\"color: rgb(19, 110, 194); text-decoration-line: none;\">寓情于景</a>。</p><p><br/></p>', '/uploads/thumb/alexa15129800274b84b15bff6ee5796152495a230e45e3d7e947d9.jpg', 'About Alexa', 12, 'Alexa,Ferre', 1512979599, '/uploads/20171211\\09ca4b1627b23eda96ed46c719d5156a.jpg'),
(4, 'Ferre', 'Alexa Ferre', '1', 2, '<p>Alexa Internet公司是<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E4%BA%9A%E9%A9%AC%E9%80%8A%E5%85%AC%E5%8F%B8\" style=\"color: rgb(19, 110, 194); text-decoration-line: none;\">亚马逊公司</a>的一家子公司，总部位于<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E5%8A%A0%E5%88%A9%E7%A6%8F%E5%B0%BC%E4%BA%9A%E5%B7%9E\" style=\"color: rgb(19, 110, 194); text-decoration-line: none;\">加利福尼亚州</a><a target=\"_blank\" href=\"https://baike.baidu.com/item/%E6%97%A7%E9%87%91%E5%B1%B1/29211\" data-lemmaid=\"29211\" style=\"color: rgb(19, 110, 194); text-decoration-line: none;\">旧金山</a>。于1996年由布鲁斯特·卡利（Brewster Kahle）及布鲁斯·吉里亚特（Bruce Gilliat）成立，作为Internet Archive的分支，受到杰奎琳·萨福拉的埃托勒投资支持。在1999年，被<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E4%BA%9A%E9%A9%AC%E9%80%8A/21766\" data-lemmaid=\"21766\" style=\"color: rgb(19, 110, 194); text-decoration-line: none;\">亚马逊</a>公司以约价值两亿五千万美元的股票买下。</p><p>Alexa是一家专门发布网站世界排名的网站。以<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E6%90%9C%E7%B4%A2%E5%BC%95%E6%93%8E\" style=\"color: rgb(19, 110, 194); text-decoration-line: none;\">搜索引擎</a>起家的Alexa创建于1996年4月（美国），目的是让互联网网友在分享虚拟世界资源的同时，更多地参与互联网资源的组织。</p><p>Alexa每天在网上搜集超过1,000GB的信息，不仅给出多达几十亿的网址链接，而且为其中的每一个网站进行了排名。可以说，Alexa是当前拥有<a target=\"_blank\" href=\"https://baike.baidu.com/item/URL\" style=\"color: rgb(19, 110, 194); text-decoration-line: none;\">URL</a>数量最庞大，排名信息发布最详尽的网站。</p><p><br/></p>', '/uploads/thumb/alexa15129800204b84b15bff6ee5796152495a230e45e3d7e947d9.jpg', 'About Alexa', 123, 'Alexa,Ferre', 1512979650, '/uploads/20171211\\d7556d4d1be26526165c81a6c47e95d9.jpg'),
(5, 'Ferre', 'Alexa Set', '1', 6, '<p>Alexa中国免费提供Alexa中文排名官方数据查询，网站<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E8%AE%BF%E9%97%AE%E9%87%8F\" style=\"color: rgb(19, 110, 194); text-decoration-line: none;\">访问量</a>查询，网站<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E6%B5%8F%E8%A7%88%E9%87%8F\" style=\"color: rgb(19, 110, 194); text-decoration-line: none;\">浏览量</a>查询，排名变化趋势数据查询。<br/> Alexa 是互联网首屈一指的免费提供<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E7%BD%91%E7%AB%99%E6%B5%81%E9%87%8F\" style=\"color: rgb(19, 110, 194); text-decoration-line: none;\">网站流量</a>信息的公司，创建于1996年，一直致力于开发<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E7%BD%91%E9%A1%B5%E6%8A%93%E5%8F%96\" style=\"color: rgb(19, 110, 194); text-decoration-line: none;\">网页抓取</a>和网站流量计算的工具。<a target=\"_blank\" href=\"https://baike.baidu.com/item/Alexa%E6%8E%92%E5%90%8D\" style=\"color: rgb(19, 110, 194); text-decoration-line: none;\">Alexa排名</a>是常引用的用来评价某一网站访问量的一个指标。总部位于<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E7%BE%8E%E5%9B%BD%E6%97%A7%E9%87%91%E5%B1%B1\" style=\"color: rgb(19, 110, 194); text-decoration-line: none;\">美国旧金山</a>的Alexa是亚马逊集团旗下的子公司之一。</p><p><span style=\"font-weight: 700;\">经历变化</span></p><p>2002年5月Alexa全新改版，放弃了搜索引擎转而与<a target=\"_blank\" href=\"https://baike.baidu.com/item/Google\" style=\"color: rgb(19, 110, 194); text-decoration-line: none;\">Google</a>合作，变身为一家专门发布网站世界排名的网站。Alexa每天在网上搜集超过1,000GB的信息，然后进行整合发布。</p><p><br/></p><p><img src=\"/ueditor/php/upload/image/20171211/1512979686547364.jpg\" title=\"1512979686547364.jpg\" alt=\"SouthEast.jpg\"/></p>', '/uploads/thumb/alexa15129800094b84b15bff6ee5796152495a230e45e3d7e947d9.jpg', 'About Alexa', 16, 'Alexa,Ferre', 1512979690, '/uploads/20171211\\049af93cd0a346780165c4068ba658b1.jpg'),
(6, 'Ferre', 'Wagner', '1', 5, '<p><img src=\"/ueditor/php/upload/image/20171211/1512980846698707.png\" title=\"1512980846698707.png\" alt=\"bpg5.png\"/></p>', '/uploads/thumb/alexa15129808494b84b15bff6ee5796152495a230e45e3d7e947d9.png', 'About Alexa', 15, 'Alexa,Ferre', 1512980849, '/uploads/20171211\\f75f3b3f636669fc395445cda43a30c6.png'),
(7, 'Ferre', 'Fate', '1', 4, '<p><img src=\"/ueditor/php/upload/image/20171211/1512980877486904.png\" title=\"1512980877486904.png\" alt=\"strip.png\"/></p>', '/uploads/thumb/alexa15129808814b84b15bff6ee5796152495a230e45e3d7e947d9.png', 'About Alexa', 17, 'Alexa,Ferre', 1512980881, '/uploads/20171211\\16af1d28f2fc57ed0cbf617aa62f77e3.png'),
(8, 'Ferre', 'Break', '1', 7, '<p><img src=\"/ueditor/php/upload/image/20171211/1512980890111714.png\" title=\"1512980890111714.png\" alt=\"1240.png\"/></p>', '/uploads/thumb/alexa15129809044b84b15bff6ee5796152495a230e45e3d7e947d9.png', 'About Alexa', 13, 'Alexa,Ferre', 1512980904, '/uploads/20171211\\0f26e116889ed945e6158caa77ed964f.png'),
(9, 'Ferre', 'Pike', '3', 8, '<p><img src=\"/ueditor/php/upload/image/20171211/1512980977975573.png\" title=\"1512980977975573.png\" alt=\"notice.png\"/></p>', '/uploads/thumb/alexa15129809934b84b15bff6ee5796152495a230e45e3d7e947d9.png', 'About Alexa', 12, 'Alexa,Ferre', 1512980993, '/uploads/20171211\\1c3900a5f9288e427abd9667eff62cbb.png'),
(10, 'Ferre', 'Alexa fake', '1', 6, '<p><img src=\"/ueditor/php/upload/image/20171212/1513067463111602.jpg\" title=\"1513067463111602.jpg\" alt=\"1499923696559.jpg\" width=\"843\" height=\"501\" style=\"width: 843px; height: 501px;\"/></p>', '/uploads/thumb/alexa15130674664b84b15bff6ee5796152495a230e45e3d7e947d9.jpg', 'About Alexa', 28, 'Alexa,Ferre', 1513067466, '/uploads/20171212\\e56bb90ecb138fedbbfb15a5f83c2b34.jpg'),
(11, 'Ferre', 'Alexa213', '1', 6, '<p>321</p>', '', 'About Alexa', 12, 'Alexa,Ferre', 1514195719, ''),
(15, 'Ferre', 'Alexa123啊', '1', 6, '<p>打</p>', '', 'About Alexa', 12, 'Alexa,Ferre', 1515492171, ''),
(18, 'Ferre', 'Alexafake', '1', 6, '<p>2</p>', '', 'About Alexa', 12, 'Alexa,Ferre', 1515492392, ''),
(19, 'Ferre', 'Alexa897', '1', 6, '<p>123</p>', '/uploads/thumb/alexa15156575964b84b15bff6ee5796152495a230e45e3d7e947d9.png', 'About Alexa', 12, 'Alexa,Ferre', 1515657596, '/uploads/20180111\\303e5f5f3c5893845a18840302c8a4f3.png'),
(20, 'Ferre', 'Alexa123213', '1', 6, '<p>213</p>', '', 'About Alexa', 12, 'Alexa,Ferre', 1515747727, ''),
(21, 'Ferre', 'Alexa faith1', '1', 6, '<p>213</p>', '', 'About Alexa', 12, 'Alexa,Ferre', 1515748438, ''),
(22, 'Ferre', 'Alexaasddsaa', '1', 6, '<p>1</p>', 'p28s35qla.bkt.clouddn.com/alexa6f501201801121715175398.jpg', 'About Alexa', 12, 'Alexa,Ferre', 1515748517, ''),
(23, 'Ferre', 'Alexasadsad', '1', 6, '<p>sad</p>', '/uploads/thumb/alexa15157509194b84b15bff6ee5796152495a230e45e3d7e947d9.png', 'About Alexa', 12, 'Alexa,Ferre', 1515750919, '/uploads/20180112\\bb62329a7a0f162a728747713bf6423f.png'),
(24, 'Ferre', 'Alexadasdas', '1', 6, '<p>sad</p>', 'p28s35qla.bkt.clouddn.com/alexa8f8ce201801121756177791.png', 'About Alexa', 12, 'Alexa,Ferre', 1515750977, '');
-- --------------------------------------------------------
--
-- 表的结构 `alexa_artsee`
--
CREATE TABLE `alexa_artsee` (
`id` int(11) NOT NULL,
`type` varchar(50) NOT NULL,
`rid` int(11) NOT NULL,
`ip` varchar(255) NOT NULL,
`country` varchar(255) DEFAULT NULL,
`province` varchar(255) DEFAULT NULL,
`city` varchar(255) DEFAULT NULL,
`time` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `alexa_artsee`
--
INSERT INTO `alexa_artsee` (`id`, `type`, `rid`, `ip`, `country`, `province`, `city`, `time`) VALUES
(1, 'Chrome', 2, '58.211.2.138', NULL, NULL, NULL, 1513753957),
(2, 'Chrome', 2, '101.71.55.105', NULL, NULL, NULL, 1513754454),
(3, 'Safari', 2, '101.71.55.120', NULL, NULL, NULL, 1513754458),
(4, 'Chrome', 72, '58.211.2.138', NULL, NULL, NULL, 1513755437),
(5, 'Chrome', 70, '58.211.2.138', NULL, NULL, NULL, 1513755446),
(6, 'Chrome', 74, '58.211.2.138', NULL, NULL, NULL, 1513755454),
(7, 'Chrome', 72, '58.211.2.54', NULL, NULL, NULL, 1513755497),
(8, 'Safari', 72, '58.211.2.72', NULL, NULL, NULL, 1513755501),
(9, 'Chrome', 74, '58.211.2.66', NULL, NULL, NULL, 1513755513),
(10, 'Safari', 74, '101.71.55.120', NULL, NULL, NULL, 1513755516),
(11, 'chrome', 75, '58.211.2.138', NULL, NULL, NULL, 1513761801),
(12, 'chrome', 73, '58.211.2.138', NULL, NULL, NULL, 1513762151),
(13, 'chrome', 73, '58.211.2.54', NULL, NULL, NULL, 1513762211),
(14, 'safari', 73, '101.71.55.105', NULL, NULL, NULL, 1513762215),
(15, 'chrome', 73, '122.190.2.66', NULL, NULL, NULL, 1513778086),
(16, 'fox', 71, '101.71.55.140', NULL, NULL, NULL, 1513778129),
(17, 'safari', 71, '58.211.2.54', NULL, NULL, NULL, 1513778136),
(18, 'chrome', 71, '122.190.2.66', NULL, NULL, NULL, 1513778975),
(19, 'safari', 75, '117.34.13.60', NULL, NULL, NULL, 1513779703),
(20, 'chrome', 61, '122.190.2.66', NULL, NULL, NULL, 1513784404),
(21, 'chrome', 61, '101.71.55.105', NULL, NULL, NULL, 1513784463),
(22, 'chrome', 59, '122.190.2.66', NULL, NULL, NULL, 1513784561),
(23, 'chrome', 60, '122.190.2.66', NULL, NULL, NULL, 1513784569),
(24, 'chrome', 59, '101.71.55.80', NULL, NULL, NULL, 1513784621),
(25, 'safari', 59, '58.211.2.72', NULL, NULL, NULL, 1513784623),
(26, 'chrome', 60, '101.71.55.140', NULL, NULL, NULL, 1513784629),
(27, 'safari', 60, '58.211.2.54', NULL, NULL, NULL, 1513784632),
(28, 'fox', 68, '125.39.239.72', NULL, NULL, NULL, 1513814135),
(29, 'chrome', 72, '101.71.55.120', NULL, NULL, NULL, 1513820204),
(30, 'chrome', 68, '58.211.2.12', NULL, NULL, NULL, 1513821517),
(31, 'chrome', 68, '101.71.55.105', NULL, NULL, NULL, 1513821536),
(32, 'chrome', 65, '58.211.2.12', NULL, NULL, NULL, 1513823010),
(33, 'chrome', 64, '58.211.2.12', NULL, NULL, NULL, 1513823023),
(34, 'chrome', 63, '58.211.2.12', NULL, NULL, NULL, 1513823040),
(35, 'chrome', 62, '58.211.2.12', NULL, NULL, NULL, 1513823050),
(36, 'safari', 65, '101.71.55.105', NULL, NULL, NULL, 1513823074),
(37, 'notidentify', 64, '58.211.2.42', NULL, NULL, NULL, 1513823083),
(38, 'safari', 64, '58.211.2.102', NULL, NULL, NULL, 1513823086),
(39, 'notidentify', 63, '58.211.2.102', NULL, NULL, NULL, 1513823100),
(40, 'safari', 63, '101.71.55.90', NULL, NULL, NULL, 1513823103),
(41, 'chrome', 62, '101.71.55.90', NULL, NULL, NULL, 1513823111),
(42, 'safari', 62, '101.71.55.140', NULL, NULL, NULL, 1513823114),
(43, 'chrome', 56, '58.211.2.12', NULL, NULL, NULL, 1513823534),
(44, 'chrome', 56, '101.71.55.100', NULL, NULL, NULL, 1513823595),
(45, 'safari', 56, '101.71.55.110', NULL, NULL, NULL, 1513823598),
(46, 'chrome', 73, '58.211.2.12', NULL, NULL, NULL, 1513838964),
(47, 'chrome', 74, '58.211.2.12', NULL, NULL, NULL, 1513845238),
(48, 'chrome', 74, '101.71.55.115', NULL, NULL, NULL, 1513845298),
(49, 'safari', 74, '58.211.2.78', NULL, NULL, NULL, 1513845301),
(50, 'chrome', 71, '122.190.2.42', NULL, NULL, NULL, 1513864159),
(51, 'chrome', 73, '122.190.2.42', NULL, NULL, NULL, 1513864170),
(52, 'chrome', 75, '122.190.2.42', NULL, NULL, NULL, 1513864179),
(53, 'chrome', 75, '101.71.55.105', NULL, NULL, NULL, 1513864239),
(54, 'fox', 61, '125.39.239.78', NULL, NULL, NULL, 1513875758),
(55, 'fox', 60, '125.39.239.12', NULL, NULL, NULL, 1513875758),
(56, 'fox', 59, '125.39.239.42', NULL, NULL, NULL, 1513875758),
(57, 'fox', 72, '125.39.239.60', NULL, NULL, NULL, 1513875758),
(58, 'fox', 73, '125.39.239.102', NULL, NULL, NULL, 1513875759),
(59, 'fox', 74, '125.39.239.120', NULL, NULL, NULL, 1513875759),
(60, 'fox', 71, '125.39.239.72', NULL, NULL, NULL, 1513875759),
(61, 'fox', 75, '125.39.239.96', NULL, NULL, NULL, 1513875762),
(62, 'fox', 72, '58.211.2.36', NULL, NULL, NULL, 1513880685),
(63, 'fox', 68, '58.211.2.102', NULL, NULL, NULL, 1513880791),
(64, 'fox', 66, '58.211.2.84', NULL, NULL, NULL, 1513880816),
(65, 'fox', 64, '58.211.2.36', NULL, NULL, NULL, 1513881127),
(66, 'fox', 65, '117.34.13.12', NULL, NULL, NULL, 1513881135),
(67, 'fox', 62, '117.34.13.24', NULL, NULL, NULL, 1513881174),
(68, 'fox', 63, '58.211.2.138', NULL, NULL, NULL, 1513881191),
(69, 'fox', 56, '59.51.81.161', NULL, NULL, NULL, 1513881200),
(70, 'fox', 65, '59.51.81.136', NULL, NULL, NULL, 1513881263),
(71, 'fox', 68, '58.211.2.36', NULL, NULL, NULL, 1513881297),
(72, 'fox', 56, '59.51.81.146', NULL, NULL, NULL, 1513881319),
(73, 'fox', 62, '117.34.13.42', NULL, NULL, NULL, 1513881376),
(74, 'fox', 63, '58.211.2.84', NULL, NULL, NULL, 1513881395),
(75, 'fox', 56, '58.211.2.6', NULL, NULL, NULL, 1513881437),
(76, 'fox', 64, '58.211.2.66', NULL, NULL, NULL, 1513881471),
(77, 'fox', 62, '58.211.2.30', NULL, NULL, NULL, 1513881478),
(78, 'fox', 68, '58.211.2.108', NULL, NULL, NULL, 1513881493),
(79, 'fox', 56, '58.211.2.126', NULL, NULL, NULL, 1513881507),
(80, 'fox', 73, '117.34.13.42', NULL, NULL, NULL, 1513883400),
(81, 'fox', 74, '58.211.2.126', NULL, NULL, NULL, 1513884111),
(82, 'fox', 71, '117.34.13.84', NULL, NULL, NULL, 1513886950),
(83, 'fox', 75, '117.34.13.42', NULL, NULL, NULL, 1513887011),
(84, 'fox', 71, '58.211.2.60', NULL, NULL, NULL, 1513887024),
(85, 'fox', 62, '58.211.2.120', NULL, NULL, NULL, 1513888493),
(86, 'fox', 63, '59.51.81.136', NULL, NULL, NULL, 1513888500),
(87, 'fox', 64, '59.51.81.172', NULL, NULL, NULL, 1513888528),
(88, 'fox', 65, '58.211.2.42', NULL, NULL, NULL, 1513888548),
(89, 'fox', 75, '58.211.2.126', NULL, NULL, NULL, 1513889591),
(90, 'fox', 64, '117.34.13.48', NULL, NULL, NULL, 1513890538),
(91, 'fox', 73, '58.211.2.42', NULL, NULL, NULL, 1513891880),
(92, 'notidentify', 56, '162.158.88.35', NULL, NULL, NULL, 1513893727),
(93, 'notidentify', 70, '162.158.89.28', NULL, NULL, NULL, 1513896525),
(94, 'fox', 62, '58.211.2.144', NULL, NULL, NULL, 1513896883),
(95, 'fox', 65, '58.211.2.6', NULL, NULL, NULL, 1513896931),
(96, 'fox', 64, '58.211.2.138', NULL, NULL, NULL, 1513896978),
(97, 'fox', 72, '59.51.81.178', NULL, NULL, NULL, 1513896986),
(98, 'fox', 63, '59.51.81.161', NULL, NULL, NULL, 1513897158),
(99, 'fox', 56, '117.34.13.60', NULL, NULL, NULL, 1513897159),
(100, 'fox', 65, '58.211.2.108', NULL, NULL, NULL, 1513897209),
(101, 'fox', 64, '58.211.2.96', NULL, NULL, NULL, 1513897226),
(102, 'fox', 68, '59.51.81.161', NULL, NULL, NULL, 1513897251),
(103, 'fox', 66, '117.34.13.60', NULL, NULL, NULL, 1513897263),
(104, 'fox', 56, '58.211.2.138', NULL, NULL, NULL, 1513897267),
(105, 'fox', 63, '117.34.13.42', NULL, NULL, NULL, 1513897270),
(106, 'fox', 73, '59.51.81.183', NULL, NULL, NULL, 1513897319),
(107, 'fox', 60, '58.211.2.144', NULL, NULL, NULL, 1513897321),
(108, 'fox', 59, '58.211.2.108', NULL, NULL, NULL, 1513897325),
(109, 'fox', 71, '59.51.81.146', NULL, NULL, NULL, 1513897374),
(110, 'fox', 61, '58.211.2.6', NULL, NULL, NULL, 1513897402),
(111, 'fox', 68, '117.34.13.78', NULL, NULL, NULL, 1513898863),
(112, 'fox', 66, '117.34.13.48', NULL, NULL, NULL, 1513899360),
(113, 'fox', 62, '117.34.13.60', NULL, NULL, NULL, 1513899370),
(114, 'fox', 72, '58.211.2.42', NULL, NULL, NULL, 1513899425),
(115, 'notidentify', 74, '162.158.92.205', NULL, NULL, NULL, 1513905436),
(116, 'notidentify', 72, '162.158.92.181', NULL, NULL, NULL, 1513912527),
(117, 'notidentify', 71, '162.158.89.34', NULL, NULL, NULL, 1513915289),
(118, 'notidentify', 50, '162.158.90.147', NULL, NULL, NULL, 1513918242),
(119, 'fox', 71, '58.211.2.78', NULL, NULL, NULL, 1513924197),
(120, 'fox', 64, '58.211.2.6', NULL, NULL, NULL, 1513924234),
(121, 'fox', 73, '58.211.2.102', NULL, NULL, NULL, 1513924244),
(122, 'fox', 65, '58.211.2.66', NULL, NULL, NULL, 1513924264),
(123, 'fox', 63, '58.211.2.54', NULL, NULL, NULL, 1513924266),
(124, 'fox', 62, '58.211.2.48', NULL, NULL, NULL, 1513924268),
(125, 'fox', 75, '58.211.2.66', NULL, NULL, NULL, 1513924280),
(126, 'fox', 64, '117.34.13.24', NULL, NULL, NULL, 1513924354),
(127, 'fox', 73, '117.34.13.66', NULL, NULL, NULL, 1513924367),
(128, 'fox', 65, '58.211.2.36', NULL, NULL, NULL, 1513924379),
(129, 'fox', 63, '58.211.2.78', NULL, NULL, NULL, 1513924383),
(130, 'fox', 75, '117.34.13.24', NULL, NULL, NULL, 1513924397),
(131, 'fox', 71, '58.211.2.36', NULL, NULL, NULL, 1513924452),
(132, 'fox', 64, '58.211.2.72', NULL, NULL, NULL, 1513924481),
(133, 'fox', 73, '58.211.2.66', NULL, NULL, NULL, 1513924494),
(134, 'fox', 63, '58.211.2.120', NULL, NULL, NULL, 1513924506),
(135, 'fox', 62, '117.34.13.48', NULL, NULL, NULL, 1513924508),
(136, 'fox', 65, '58.211.2.78', NULL, NULL, NULL, 1513924510),
(137, 'fox', 75, '58.211.2.54', NULL, NULL, NULL, 1513924522),
(138, 'fox', 71, '58.211.2.6', NULL, NULL, NULL, 1513924573),
(139, 'fox', 64, '58.211.2.54', NULL, NULL, NULL, 1513924607),
(140, 'fox', 73, '117.34.13.60', NULL, NULL, NULL, 1513924614),
(141, 'fox', 65, '117.34.13.60', NULL, NULL, NULL, 1513924624),
(142, 'fox', 75, '58.211.2.102', NULL, NULL, NULL, 1513924641),
(143, 'fox', 71, '58.211.2.102', NULL, NULL, NULL, 1513924689),
(144, 'fox', 64, '58.211.2.78', NULL, NULL, NULL, 1513924717),
(145, 'fox', 73, '58.211.2.108', NULL, NULL, NULL, 1513924734),
(146, 'fox', 63, '58.211.2.108', NULL, NULL, NULL, 1513924743),
(147, 'fox', 62, '58.211.2.66', NULL, NULL, NULL, 1513924745),
(148, 'fox', 75, '58.211.2.30', NULL, NULL, NULL, 1513924759),
(149, 'chrome', 75, '58.211.2.12', NULL, NULL, NULL, 1513925189),
(150, 'notidentify', 55, '162.158.90.159', NULL, NULL, NULL, 1513925249),
(151, 'fox', 74, '58.211.2.54', NULL, NULL, NULL, 1513925430),
(152, 'fox', 74, '117.34.13.48', NULL, NULL, NULL, 1513925552),
(153, 'fox', 64, '117.34.13.60', NULL, NULL, NULL, 1513927725),
(154, 'fox', 73, '117.34.13.24', NULL, NULL, NULL, 1513927789),
(155, 'fox', 73, '58.211.2.6', NULL, NULL, NULL, 1513928223),
(156, 'notidentify', 73, '162.158.88.137', NULL, NULL, NULL, 1513929746),
(157, 'notidentify', 75, '162.158.92.67', NULL, NULL, NULL, 1513936155),
(158, 'fox', 71, '59.51.81.161', NULL, NULL, NULL, 1513947321),
(159, 'fox', 64, '59.51.81.136', NULL, NULL, NULL, 1513947352),
(160, 'fox', 73, '59.51.81.178', NULL, NULL, NULL, 1513947359),
(161, 'fox', 63, '59.51.81.172', NULL, NULL, NULL, 1513947375),
(162, 'fox', 75, '58.211.2.36', NULL, NULL, NULL, 1513947385),
(163, 'fox', 64, '117.34.13.42', NULL, NULL, NULL, 1513948516),
(164, 'fox', 56, '59.51.81.141', NULL, NULL, NULL, 1513948516),
(165, 'fox', 63, '58.211.2.36', NULL, NULL, NULL, 1513948537),
(166, 'fox', 72, '117.34.13.36', NULL, NULL, NULL, 1513948571),
(167, 'fox', 73, '58.211.2.84', NULL, NULL, NULL, 1513948843),
(168, 'fox', 65, '59.51.81.146', NULL, NULL, NULL, 1513949842),
(169, 'fox', 59, '117.34.13.60', NULL, NULL, NULL, 1513949847),
(170, 'fox', 72, '58.211.2.66', NULL, NULL, NULL, 1513949857),
(171, 'fox', 64, '59.51.81.178', NULL, NULL, NULL, 1513949881),
(172, 'fox', 75, '58.211.2.96', NULL, NULL, NULL, 1513949898),
(173, 'fox', 68, '58.211.2.30', NULL, NULL, NULL, 1513949911),
(174, 'fox', 71, '59.51.81.166', NULL, NULL, NULL, 1513949915),
(175, 'fox', 56, '59.51.81.136', NULL, NULL, NULL, 1513949919),
(176, 'fox', 62, '59.51.81.136', NULL, NULL, NULL, 1513949924),
(177, 'fox', 66, '117.34.13.42', NULL, NULL, NULL, 1513949932),
(178, 'fox', 72, '58.211.2.96', NULL, NULL, NULL, 1513949957),
(179, 'fox', 59, '59.51.81.136', NULL, NULL, NULL, 1513949959),
(180, 'fox', 64, '117.34.13.12', NULL, NULL, NULL, 1513949981),
(181, 'fox', 60, '59.51.81.172', NULL, NULL, NULL, 1513949981),
(182, 'fox', 63, '117.34.13.66', NULL, NULL, NULL, 1513949985),
(183, 'fox', 61, '117.34.13.78', NULL, NULL, NULL, 1513949988),
(184, 'fox', 75, '58.211.2.6', NULL, NULL, NULL, 1513950003),
(185, 'fox', 68, '59.51.81.183', NULL, NULL, NULL, 1513950017),
(186, 'fox', 71, '117.34.13.60', NULL, NULL, NULL, 1513950022),
(187, 'fox', 56, '117.34.13.66', NULL, NULL, NULL, 1513950034),
(188, 'fox', 65, '58.211.2.54', NULL, NULL, NULL, 1513950038),
(189, 'fox', 59, '58.211.2.36', NULL, NULL, NULL, 1513950059),
(190, 'fox', 72, '59.51.81.161', NULL, NULL, NULL, 1513950063),
(191, 'fox', 60, '117.34.13.36', NULL, NULL, NULL, 1513950087),
(192, 'fox', 61, '58.211.2.54', NULL, NULL, NULL, 1513950093),
(193, 'fox', 75, '59.51.81.166', NULL, NULL, NULL, 1513950108),
(194, 'fox', 71, '59.51.81.141', NULL, NULL, NULL, 1513950126),
(195, 'fox', 66, '58.211.2.6', NULL, NULL, NULL, 1513950129),
(196, 'fox', 71, '58.211.2.12', NULL, NULL, NULL, 1513955574),
(197, 'fox', 63, '117.34.13.12', NULL, NULL, NULL, 1513955584),
(198, 'fox', 65, '59.51.81.183', NULL, NULL, NULL, 1513955593),
(199, 'fox', 73, '59.51.81.161', NULL, NULL, NULL, 1513955620),
(200, 'fox', 62, '58.211.2.60', NULL, NULL, NULL, 1513955635),
(201, 'fox', 75, '59.51.81.161', NULL, NULL, NULL, 1513955641),
(202, 'fox', 73, '117.34.13.12', NULL, NULL, NULL, 1513955696),
(203, 'fox', 63, '117.34.13.24', NULL, NULL, NULL, 1513957438),
(204, 'fox', 75, '59.51.81.136', NULL, NULL, NULL, 1513957476),
(205, 'fox', 65, '117.34.13.24', NULL, NULL, NULL, 1513957487),
(206, 'fox', 73, '59.51.81.166', NULL, NULL, NULL, 1513957497),
(207, 'fox', 71, '58.211.2.126', NULL, NULL, NULL, 1513957825),
(208, 'fox', 66, '58.211.2.102', NULL, NULL, NULL, 1513957843),
(209, 'fox', 59, '58.211.2.96', NULL, NULL, NULL, 1513957846),
(210, 'fox', 56, '58.211.2.120', NULL, NULL, NULL, 1513957850),
(211, 'fox', 61, '58.211.2.18', NULL, NULL, NULL, 1513957852),
(212, 'fox', 60, '117.34.13.24', NULL, NULL, NULL, 1513957853),
(213, 'fox', 72, '59.51.81.183', NULL, NULL, NULL, 1513957883),
(214, 'fox', 63, '117.34.13.60', NULL, NULL, NULL, 1513957886),
(215, 'fox', 62, '58.211.2.96', NULL, NULL, NULL, 1513957906),
(216, 'fox', 65, '58.211.2.60', NULL, NULL, NULL, 1513964754),
(217, 'fox', 61, '58.211.2.84', NULL, NULL, NULL, 1513964762),
(218, 'fox', 64, '59.51.81.166', NULL, NULL, NULL, 1513964881),
(219, 'fox', 74, '58.211.2.84', NULL, NULL, NULL, 1513964898),
(220, 'fox', 59, '59.51.81.178', NULL, NULL, NULL, 1513964913),
(221, 'fox', 60, '58.211.2.36', NULL, NULL, NULL, 1513965015),
(222, 'fox', 72, '117.34.13.78', NULL, NULL, NULL, 1513965039),
(223, 'fox', 75, '59.51.81.178', NULL, NULL, NULL, 1513965041),
(224, 'notidentify', 74, '172.68.11.248', NULL, NULL, NULL, 1513965376),
(225, 'fox', 73, '59.51.81.146', NULL, NULL, NULL, 1513978003),
(226, 'fox', 68, '117.34.13.42', NULL, NULL, NULL, 1513978010),
(227, 'fox', 56, '58.211.2.96', NULL, NULL, NULL, 1513978027),
(228, 'fox', 65, '59.51.81.172', NULL, NULL, NULL, 1513978052),
(229, 'fox', 71, '58.211.2.108', NULL, NULL, NULL, 1513978075),
(230, 'fox', 60, '59.51.81.183', NULL, NULL, NULL, 1513978084),
(231, 'fox', 62, '58.211.2.78', NULL, NULL, NULL, 1513978087),
(232, 'fox', 61, '58.211.2.48', NULL, NULL, NULL, 1513978094),
(233, 'fox', 72, '58.211.2.18', NULL, NULL, NULL, 1513978117),
(234, 'fox', 64, '58.211.2.60', NULL, NULL, NULL, 1513984374),
(235, 'fox', 74, '59.51.81.136', NULL, NULL, NULL, 1513984375),
(236, 'fox', 59, '58.211.2.66', NULL, NULL, NULL, 1513984404),
(237, 'fox', 68, '59.51.81.146', NULL, NULL, NULL, 1513984427),
(238, 'fox', 66, '58.211.2.12', NULL, NULL, NULL, 1513984438),
(239, 'fox', 62, '59.51.81.141', NULL, NULL, NULL, 1513984446),
(240, 'notidentify', 74, '172.68.10.67', NULL, NULL, NULL, 1513989251),
(241, 'notidentify', 72, '172.68.244.213', NULL, NULL, NULL, 1513989255),
(242, 'notidentify', 73, '172.69.62.79', NULL, NULL, NULL, 1513990373),
(243, 'fox', 59, '117.34.13.42', NULL, NULL, NULL, 1513991446),
(244, 'fox', 62, '58.211.2.108', NULL, NULL, NULL, 1513991446),
(245, 'fox', 65, '59.51.81.161', NULL, NULL, NULL, 1513991448),
(246, 'fox', 71, '58.211.2.84', NULL, NULL, NULL, 1513991457),
(247, 'fox', 68, '59.51.81.141', NULL, NULL, NULL, 1513991457),
(248, 'fox', 61, '59.51.81.166', NULL, NULL, NULL, 1513991473),
(249, 'notidentify', 55, '162.158.92.103', NULL, NULL, NULL, 1513991476),
(250, 'fox', 60, '59.51.81.161', NULL, NULL, NULL, 1513991487),
(251, 'fox', 56, '58.211.2.102', NULL, NULL, NULL, 1513991490),
(252, 'fox', 72, '117.34.13.60', NULL, NULL, NULL, 1513991515),
(253, 'fox', 64, '125.39.239.60', NULL, NULL, NULL, 1513994619),
(254, 'fox', 74, '117.34.13.60', NULL, NULL, NULL, 1513994760),
(255, 'fox', 60, '58.211.2.18', NULL, NULL, NULL, 1513998355),
(256, 'fox', 65, '58.211.2.96', NULL, NULL, NULL, 1513998361),
(257, 'fox', 55, '58.211.2.66', NULL, NULL, NULL, 1513998366),
(258, 'fox', 73, '58.211.2.78', NULL, NULL, NULL, 1513998369),
(259, 'fox', 72, '58.211.2.6', NULL, NULL, NULL, 1513998374),
(260, 'fox', 68, '117.34.13.60', NULL, NULL, NULL, 1513998375),
(261, 'fox', 66, '58.211.2.126', NULL, NULL, NULL, 1513998393),
(262, 'fox', 61, '117.34.13.24', NULL, NULL, NULL, 1513998407),
(263, 'fox', 62, '58.211.2.84', NULL, NULL, NULL, 1513998418),
(264, 'notidentify', 71, '172.68.10.115', NULL, NULL, NULL, 1514002608),
(265, 'fox', 74, '58.211.2.6', NULL, NULL, NULL, 1514003170),
(266, 'fox', 64, '58.211.2.48', NULL, NULL, NULL, 1514003176),
(267, 'fox', 73, '117.34.13.78', NULL, NULL, NULL, 1514003186),
(268, 'fox', 72, '59.51.81.136', NULL, NULL, NULL, 1514003207),
(269, 'notidentify', 56, '108.162.246.236', NULL, NULL, NULL, 1514005236),
(270, 'notidentify', 71, '108.162.246.86', NULL, NULL, NULL, 1514005242),
(271, 'notidentify', 74, '108.162.245.79', NULL, NULL, NULL, 1514005248),
(272, 'notidentify', 75, '108.162.246.158', NULL, NULL, NULL, 1514005253),
(273, 'notidentify', 72, '108.162.245.211', NULL, NULL, NULL, 1514005259),
(274, 'notidentify', 75, '172.68.244.93', NULL, NULL, NULL, 1514014695),
(275, 'notidentify', 50, '162.158.90.93', NULL, NULL, NULL, 1514016946),
(276, 'notidentify', 70, '172.68.174.103', NULL, NULL, NULL, 1514033478),
(277, 'notidentify', 73, '108.162.246.68', NULL, NULL, NULL, 1514033489),
(278, 'notidentify', 57, '108.162.245.85', NULL, NULL, NULL, 1514033733),
(279, 'notidentify', 55, '172.68.174.31', NULL, NULL, NULL, 1514033761),
(280, 'notidentify', 53, '108.162.246.140', NULL, NULL, NULL, 1514033907),
(281, 'notidentify', 49, '108.162.245.199', NULL, NULL, NULL, 1514033936),
(282, 'notidentify', 69, '162.158.106.57', NULL, NULL, NULL, 1514033938),
(283, 'notidentify', 50, '172.68.174.37', NULL, NULL, NULL, 1514033945),
(284, 'notidentify', 64, '108.162.245.121', NULL, NULL, NULL, 1514033953),
(285, 'notidentify', 65, '108.162.246.50', NULL, NULL, NULL, 1514033959),
(286, 'notidentify', 61, '108.162.245.43', NULL, NULL, NULL, 1514033966),
(287, 'notidentify', 66, '162.158.106.15', NULL, NULL, NULL, 1514033972),
(288, 'notidentify', 62, '162.158.106.63', NULL, NULL, NULL, 1514033979),
(289, 'notidentify', 68, '108.162.245.163', NULL, NULL, NULL, 1514033985),
(290, 'notidentify', 59, '108.162.245.67', NULL, NULL, NULL, 1514033992),
(291, 'notidentify', 67, '108.162.245.7', NULL, NULL, NULL, 1514033999),
(292, 'notidentify', 63, '108.162.245.205', NULL, NULL, NULL, 1514034005),
(293, 'notidentify', 52, '172.68.174.91', NULL, NULL, NULL, 1514034011),
(294, 'notidentify', 51, '108.162.246.224', NULL, NULL, NULL, 1514034018),
(295, 'notidentify', 60, '108.162.245.19', NULL, NULL, NULL, 1514034026),
(296, 'notidentify', 54, '162.158.106.15', NULL, NULL, NULL, 1514034031),
(297, 'notidentify', 58, '108.162.245.13', NULL, NULL, NULL, 1514034057),
(298, 'fox', 66, '59.51.81.166', NULL, NULL, NULL, 1514041783),
(299, 'fox', 59, '117.34.13.24', NULL, NULL, NULL, 1514041789),
(300, 'fox', 71, '117.34.13.12', NULL, NULL, NULL, 1514041809),
(301, 'fox', 62, '58.211.2.6', NULL, NULL, NULL, 1514041870),
(302, 'fox', 75, '58.211.2.18', NULL, NULL, NULL, 1514041874),
(303, 'fox', 56, '58.211.2.84', NULL, NULL, NULL, 1514041875),
(304, 'fox', 55, '59.51.81.166', NULL, NULL, NULL, 1514041880),
(305, 'fox', 63, '59.51.81.183', NULL, NULL, NULL, 1514041884),
(306, 'fox', 71, '117.34.13.90', NULL, NULL, NULL, 1514042137),
(307, 'fox', 73, '58.211.2.60', NULL, NULL, NULL, 1514042154),
(308, 'fox', 72, '117.34.13.48', NULL, NULL, NULL, 1514042392),
(309, 'fox', 71, '117.34.13.36', NULL, NULL, NULL, 1514042405),
(310, 'fox', 75, '117.34.13.36', NULL, NULL, NULL, 1514042976),
(311, 'fox', 50, '58.211.2.126', NULL, NULL, NULL, 1514043362),
(312, 'fox', 61, '59.51.81.178', NULL, NULL, NULL, 1514044648),
(313, 'fox', 55, '59.51.81.146', NULL, NULL, NULL, 1514044648),
(314, 'fox', 49, '59.51.81.172', NULL, NULL, NULL, 1514044652),
(315, 'fox', 57, '58.211.2.60', NULL, NULL, NULL, 1514044657),
(316, 'fox', 50, '59.51.81.141', NULL, NULL, NULL, 1514044681),
(317, 'fox', 66, '58.211.2.108', NULL, NULL, NULL, 1514044683),
(318, 'fox', 59, '117.34.13.48', NULL, NULL, NULL, 1514044687),
(319, 'fox', 73, '58.211.2.36', NULL, NULL, NULL, 1514044694),
(320, 'fox', 53, '58.211.2.96', NULL, NULL, NULL, 1514044707),
(321, 'fox', 69, '58.211.2.18', NULL, NULL, NULL, 1514044724),
(322, 'fox', 70, '117.34.13.60', NULL, NULL, NULL, 1514044727),
(323, 'safari', 56, '162.158.79.164', NULL, NULL, NULL, 1514135011),
(324, 'ie8', 70, '162.158.182.7', NULL, NULL, NULL, 1514163891),
(325, 'notidentify', 56, '172.68.246.197', NULL, NULL, NULL, 1514167018),
(326, 'notidentify', 74, '172.68.10.235', NULL, NULL, NULL, 1514167062),
(327, 'notidentify', 51, '172.68.65.141', NULL, NULL, NULL, 1514167545),
(328, 'notidentify', 51, '172.68.10.241', NULL, NULL, NULL, 1514167694),
(329, 'notidentify', 55, '172.68.11.200', NULL, NULL, NULL, 1514167700),
(330, 'notidentify', 57, '172.68.245.118', NULL, NULL, NULL, 1514167703),
(331, 'notidentify', 62, '162.158.90.81', NULL, NULL, NULL, 1514168294),
(332, 'notidentify', 66, '162.158.92.79', NULL, NULL, NULL, 1514168298),
(333, 'notidentify', 66, '162.158.78.13', NULL, NULL, NULL, 1514168302),
(334, 'notidentify', 63, '172.68.245.142', NULL, NULL, NULL, 1514168305),
(335, 'notidentify', 50, '172.68.244.213', NULL, NULL, NULL, 1514168310),
(336, 'notidentify', 57, '172.68.245.250', NULL, NULL, NULL, 1514180905),
(337, 'chrome', 69, '58.211.2.12', NULL, NULL, NULL, 1514188723),
(338, 'chrome', 67, '58.211.2.12', NULL, NULL, NULL, 1514188732),
(339, 'notidentify', 69, '42.236.93.51', NULL, NULL, NULL, 1514188783),
(340, 'chrome', 67, '42.236.93.71', NULL, NULL, NULL, 1514188792),
(341, 'safari', 67, '42.236.93.26', NULL, NULL, NULL, 1514188797),
(342, 'fox', 72, '125.39.239.6', NULL, NULL, NULL, 1514192911),
(343, 'fox', 63, '125.39.239.6', NULL, NULL, NULL, 1514192911),
(344, 'fox', 74, '125.39.239.36', NULL, NULL, NULL, 1514192911),
(345, 'fox', 49, '125.39.239.54', NULL, NULL, NULL, 1514192911),
(346, 'fox', 57, '125.39.239.6', NULL, NULL, NULL, 1514192912),
(347, 'fox', 62, '125.39.239.90', NULL, NULL, NULL, 1514192912),
(348, 'fox', 69, '125.39.239.42', NULL, NULL, NULL, 1514192912),
(349, 'fox', 56, '125.39.239.12', NULL, NULL, NULL, 1514192912),
(350, 'fox', 53, '125.39.239.54', NULL, NULL, NULL, 1514192912),
(351, 'fox', 70, '125.39.239.18', NULL, NULL, NULL, 1514192912),
(352, 'fox', 65, '125.39.239.96', NULL, NULL, NULL, 1514192912),
(353, 'fox', 66, '125.39.239.36', NULL, NULL, NULL, 1514192912),
(354, 'fox', 50, '125.39.239.54', NULL, NULL, NULL, 1514192912),
(355, 'fox', 68, '125.39.239.102', NULL, NULL, NULL, 1514192913),
(356, 'fox', 55, '125.39.239.102', NULL, NULL, NULL, 1514192913),
(357, 'notidentify', 71, '162.158.92.145', NULL, NULL, NULL, 1514202997),
(358, 'notidentify', 49, '162.158.89.148', NULL, NULL, NULL, 1514204696),
(359, 'notidentify', 73, '162.158.88.41', NULL, NULL, NULL, 1514205706),
(360, 'notidentify', 70, '162.158.93.72', NULL, NULL, NULL, 1514209423),
(361, 'notidentify', 75, '162.158.88.101', NULL, NULL, NULL, 1514211682),
(362, 'notidentify', 50, '162.158.89.142', NULL, NULL, NULL, 1514211847),
(363, 'notidentify', 69, '162.158.93.156', NULL, NULL, NULL, 1514213640),
(364, 'notidentify', 49, '172.68.11.146', NULL, NULL, NULL, 1514215064),
(365, 'notidentify', 65, '162.158.91.50', NULL, NULL, NULL, 1514215363),
(366, 'notidentify', 56, '162.158.88.227', NULL, NULL, NULL, 1514215452),
(367, 'notidentify', 67, '172.68.10.37', NULL, NULL, NULL, 1514218098),
(368, 'notidentify', 70, '162.158.91.20', NULL, NULL, NULL, 1514222637),
(369, 'notidentify', 70, '172.68.246.245', NULL, NULL, NULL, 1514222640),
(370, 'notidentify', 75, '162.158.91.236', NULL, NULL, NULL, 1514226142),
(371, 'notidentify', 72, '162.158.88.77', NULL, NULL, NULL, 1514229833),
(372, 'notidentify', 51, '162.158.90.57', NULL, NULL, NULL, 1514235149),
(373, 'notidentify', 66, '162.158.79.32', NULL, NULL, NULL, 1514236113),
(374, 'notidentify', 69, '162.158.92.205', NULL, NULL, NULL, 1514238817),
(375, 'notidentify', 64, '172.68.65.9', NULL, NULL, NULL, 1514239644),
(376, 'notidentify', 72, '172.68.244.15', NULL, NULL, NULL, 1514240701),
(377, 'notidentify', 68, '172.68.11.128', NULL, NULL, NULL, 1514242479),
(378, 'notidentify', 55, '162.158.91.32', NULL, NULL, NULL, 1514242615),
(379, 'notidentify', 55, '162.158.79.68', NULL, NULL, NULL, 1514242619),
(380, 'notidentify', 54, '172.68.244.153', NULL, NULL, NULL, 1514244354),
(381, 'notidentify', 67, '162.158.90.99', NULL, NULL, NULL, 1514247650),
(382, 'notidentify', 54, '162.158.92.187', NULL, NULL, NULL, 1514247807),
(383, 'notidentify', 68, '172.68.244.63', NULL, NULL, NULL, 1514249264),
(384, 'notidentify', 63, '162.158.89.76', NULL, NULL, NULL, 1514249650),
(385, 'notidentify', 64, '172.68.244.249', NULL, NULL, NULL, 1514250518),
(386, 'notidentify', 50, '172.68.246.29', NULL, NULL, NULL, 1514251097),
(387, 'notidentify', 75, '172.68.11.212', NULL, NULL, NULL, 1514252723),
(388, 'notidentify', 73, '162.158.91.98', NULL, NULL, NULL, 1514260455),
(389, 'notidentify', 65, '172.68.10.121', NULL, NULL, NULL, 1514260929),
(390, 'notidentify', 62, '162.158.78.61', NULL, NULL, NULL, 1514261436),
(391, 'notidentify', 71, '162.158.78.7', NULL, NULL, NULL, 1514261457),
(392, 'chrome', 75, '58.211.2.78', NULL, NULL, NULL, 1514282890),
(393, 'chrome', 75, '42.236.93.36', NULL, NULL, NULL, 1514282950),
(394, 'safari', 75, '58.211.2.72', NULL, NULL, NULL, 1514282956),
(395, 'chrome', 66, '58.211.2.78', NULL, NULL, NULL, 1514283563),
(396, 'notidentify', 74, '172.68.65.105', NULL, NULL, NULL, 1514300258),
(397, 'fox', 67, '125.39.239.36', NULL, NULL, NULL, 1514302597),
(398, 'notidentify', 73, '162.158.78.31', NULL, NULL, NULL, 1514307272),
(399, 'notidentify', 50, '173.245.54.28', NULL, NULL, NULL, 1514311927),
(400, 'notidentify', 70, '172.68.244.33', NULL, NULL, NULL, 1514323180),
(401, 'chrome', 74, '42.236.93.31', NULL, NULL, NULL, 1514341920),
(402, 'safari', 74, '42.236.93.21', NULL, NULL, NULL, 1514341928),
(403, 'notidentify', 73, '162.158.88.251', NULL, NULL, NULL, 1514368288),
(404, 'notidentify', 70, '172.68.11.20', NULL, NULL, NULL, 1514371931),
(405, 'notidentify', 58, '172.68.10.121', NULL, NULL, NULL, 1514375518),
(406, 'notidentify', 61, '172.68.11.80', NULL, NULL, NULL, 1514389833),
(407, 'notidentify', 52, '172.68.244.105', NULL, NULL, NULL, 1514396163),
(408, 'chrome', 72, '58.211.2.78', NULL, NULL, NULL, 1514428207),
(409, 'notidentify', 58, '172.68.65.69', NULL, NULL, NULL, 1514455584),
(410, 'notidentify', 68, '162.158.89.52', NULL, NULL, NULL, 1514469047),
(411, 'notidentify', 60, '172.68.10.199', NULL, NULL, NULL, 1514469212),
(412, 'notidentify', 57, '162.158.88.71', NULL, NULL, NULL, 1514476630),
(413, 'notidentify', 54, '162.158.78.31', NULL, NULL, NULL, 1514483606),
(414, 'notidentify', 64, '162.158.92.151', NULL, NULL, NULL, 1514483699),
(415, 'notidentify', 75, '172.68.65.21', NULL, NULL, NULL, 1514483869),
(416, 'notidentify', 53, '162.158.91.236', NULL, NULL, NULL, 1514487351),
(417, 'notidentify', 62, '162.158.91.134', NULL, NULL, NULL, 1514493105),
(418, 'notidentify', 56, '162.158.78.235', NULL, NULL, NULL, 1514496682),
(419, 'notidentify', 61, '162.158.88.83', NULL, NULL, NULL, 1514496902),
(420, 'notidentify', 72, '162.158.90.105', NULL, NULL, NULL, 1514499506),
(421, 'notidentify', 67, '162.158.90.27', NULL, NULL, NULL, 1514504077),
(422, 'notidentify', 71, '162.158.93.156', NULL, NULL, NULL, 1514504151),
(423, 'notidentify', 66, '162.158.92.85', NULL, NULL, NULL, 1514504184),
(424, 'notidentify', 71, '162.158.90.15', NULL, NULL, NULL, 1514505137),
(425, 'notidentify', 75, '162.158.91.92', NULL, NULL, NULL, 1514505616),
(426, 'notidentify', 73, '162.158.78.157', NULL, NULL, NULL, 1514505623),
(427, 'notidentify', 72, '172.68.244.99', NULL, NULL, NULL, 1514505641),
(428, 'notidentify', 74, '162.158.90.63', NULL, NULL, NULL, 1514505641),
(429, 'notidentify', 75, '172.68.244.243', NULL, NULL, NULL, 1514505648),
(430, 'notidentify', 72, '162.158.90.81', NULL, NULL, NULL, 1514510414),
(431, 'notidentify', 59, '172.68.11.188', NULL, NULL, NULL, 1514516128),
(432, 'chrome', 55, '58.211.2.78', NULL, NULL, NULL, 1514516846),
(433, 'chrome', 73, '58.211.2.72', NULL, NULL, NULL, 1514516871),
(434, 'safari', 73, '42.236.93.26', NULL, NULL, NULL, 1514516875),
(435, 'chrome', 55, '42.236.93.71', NULL, NULL, NULL, 1514516906),
(436, 'notidentify', 49, '162.158.93.12', NULL, NULL, NULL, 1514519680),
(437, 'notidentify', 60, '162.158.92.133', NULL, NULL, NULL, 1514616295),
(438, 'notidentify', 52, '162.158.92.151', NULL, NULL, NULL, 1514644503),
(439, 'notidentify', 53, '172.68.65.75', NULL, NULL, NULL, 1514645044),
(440, 'notidentify', 59, '162.158.90.129', NULL, NULL, NULL, 1514654462),
(441, 'notidentify', 49, '172.69.62.175', NULL, NULL, NULL, 1514869591),
(442, 'chrome', 70, '58.211.2.66', NULL, NULL, NULL, 1514885597),
(443, 'chrome', 70, '101.71.55.85', NULL, NULL, NULL, 1514885657),
(444, 'safari', 70, '58.211.2.18', NULL, NULL, NULL, 1514885662),
(445, 'chrome', 72, '101.71.55.110', NULL, NULL, NULL, 1514888096),
(446, 'notidentify', 54, '162.158.90.213', NULL, NULL, NULL, 1514889217),
(447, 'chrome', 75, '122.190.2.66', NULL, NULL, NULL, 1514903169),
(448, 'chrome', 76, '122.190.2.66', NULL, NULL, NULL, 1514903178),
(449, 'safari', 75, '58.211.2.60', NULL, NULL, NULL, 1514903241),
(450, 'safari', 76, '101.71.55.125', NULL, NULL, NULL, 1514903254),
(451, 'notidentify', 56, '162.158.93.60', NULL, NULL, NULL, 1514912016),
(452, 'notidentify', 76, '162.158.89.208', NULL, NULL, NULL, 1514924489),
(453, 'hehe', 65, '123', NULL, NULL, NULL, 1515037955);
-- --------------------------------------------------------
--
-- 表的结构 `alexa_category`
--
CREATE TABLE `alexa_category` (
`id` int(11) NOT NULL,
`catename` varchar(255) NOT NULL,
`sort` int(11) NOT NULL,
`desc` varchar(255) NOT NULL DEFAULT 'Alexa Zhang',
`pid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
--
-- 转存表中的数据 `alexa_category`
--
INSERT INTO `alexa_category` (`id`, `catename`, `sort`, `desc`, `pid`) VALUES
(1, 'Alexa', 3, 'Alexa Zhang', 0),
(2, 'Ferre', 6, '', 1),
(3, 'Ashly', 7, '', 2),
(4, 'Freeze', 9, '', 2),
(5, '老铁', 123, '', 0),
(6, '222', 222, '', 0);
-- --------------------------------------------------------
--
-- 表的结构 `alexa_link`
--
CREATE TABLE `alexa_link` (
`id` int(11) NOT NULL,
`name` varchar(50) NOT NULL,
`url` text NOT NULL,
`sort` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
--
-- 转存表中的数据 `alexa_link`
--
INSERT INTO `alexa_link` (`id`, `name`, `url`, `sort`) VALUES
(1, '谷歌首页', 'http://google.com', '111'),
(2, '百度', 'http://www.baidu.com', '1'),
(9, 'freeze', 'http://alexa.ferre.top', '2');
-- --------------------------------------------------------
--
-- 表的结构 `alexa_system`
--
CREATE TABLE `alexa_system` (
`id` int(11) NOT NULL,
`is_close` tinyint(4) NOT NULL,
`title` text NOT NULL,
`keywords` text NOT NULL,
`desc` text NOT NULL,
`is_mail` tinyint(1) NOT NULL,
`type` tinyint(1) NOT NULL COMMENT '0为本地存储；1为七牛云；2为阿里云OSS',
`record` varchar(50) NOT NULL DEFAULT '',
`is_update` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `alexa_system`
--
INSERT INTO `alexa_system` (`id`, `is_close`, `title`, `keywords`, `desc`, `is_mail`, `type`, `record`, `is_update`) VALUES
(1, 0, 'Alexa 1', '萨法1', 'About Alexa', 1, 1, '蜀ICP备17036283号-2', 0);
-- --------------------------------------------------------
--
-- 表的结构 `alexa_tourist`
--
CREATE TABLE `alexa_tourist` (
`id` int(11) NOT NULL,
`ip` varchar(50) NOT NULL,
`time` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `alexa_tourist`
--
INSERT INTO `alexa_tourist` (`id`, `ip`, `time`) VALUES
(448, '58.211.2.138', '1513754219'),
(449, '101.71.55.105', '1513754454'),
(450, '101.71.55.120', '1513754458'),
(451, '58.211.2.54', '1513755497'),
(452, '58.211.2.72', '1513755501'),
(453, '58.211.2.66', '1513755513'),
(454, '172.68.246.179', '1513756379'),
(455, '108.162.245.67', '1513761377'),
(456, '101.71.55.95', '1513761480'),
(457, '101.71.55.100', '1513762583'),
(458, '58.211.2.102', '1513762807'),
(459, '59.51.81.146', '1513762807'),
(460, '172.68.174.67', '1513763009'),
(461, '58.211.2.96', '1513764404'),
(462, '59.51.81.166', '1513764472'),
(463, '59.51.81.136', '1513764472'),
(464, '58.211.2.120', '1513764728'),
(465, '122.190.2.6', '1513773343'),
(466, '172.68.245.58', '1513775894'),
(467, '172.68.65.51', '1513777089'),
(468, '122.190.2.66', '1513778054'),
(469, '101.71.55.140', '1513778129'),
(470, '162.158.92.67', '1513778699'),
(471, '117.34.13.60', '1513779696'),
(472, '59.51.81.161', '1513784116'),
(473, '101.71.55.115', '1513784448'),
(474, '101.71.55.110', '1513784459'),
(475, '101.71.55.80', '1513784621'),
(476, '172.68.245.76', '1513803036'),
(477, '125.39.239.72', '1513814135'),
(478, '125.39.239.24', '1513819193'),
(479, '58.211.2.12', '1513820142'),
(480, '172.68.246.239', '1513821467'),
(481, '172.68.246.137', '1513822539'),
(482, '162.158.79.158', '1513822663'),
(483, '162.158.90.159', '1513822666'),
(484, '58.211.2.42', '1513823083'),
(485, '101.71.55.90', '1513823103'),
(486, '58.211.2.108', '1513823534'),
(487, '117.34.13.12', '1513828119'),
(488, '58.211.2.78', '1513845301'),
(489, '59.51.81.172', '1513854152'),
(490, '42.236.93.91', '1513856992'),
(491, '42.236.93.66', '1513857593'),
(492, '122.190.2.42', '1513864151'),
(493, '42.236.93.61', '1513865990'),
(494, '125.39.239.78', '1513875758'),
(495, '125.39.239.12', '1513875758'),
(496, '125.39.239.42', '1513875758'),
(497, '125.39.239.60', '1513875758'),
(498, '125.39.239.102', '1513875758'),
(499, '125.39.239.120', '1513875759'),
(500, '125.39.239.96', '1513875762'),
(501, '162.158.89.130', '1513877822'),
(502, '58.211.2.36', '1513880685'),
(503, '58.211.2.84', '1513880816'),
(504, '117.34.13.24', '1513881174'),
(505, '162.158.182.187', '1513881279'),
(506, '117.34.13.42', '1513881376'),
(507, '58.211.2.6', '1513881437'),
(508, '58.211.2.30', '1513881478'),
(509, '58.211.2.126', '1513881507'),
(510, '117.34.13.84', '1513886950'),
(511, '58.211.2.60', '1513887024'),
(512, '117.34.13.48', '1513890538'),
(513, '162.158.88.35', '1513893727'),
(514, '162.158.89.28', '1513896525'),
(515, '162.158.89.238', '1513896693'),
(516, '58.211.2.144', '1513896883'),
(517, '59.51.81.178', '1513896986'),
(518, '162.158.79.200', '1513897223'),
(519, '59.51.81.183', '1513897319'),
(520, '117.34.13.36', '1513898201'),
(521, '117.34.13.78', '1513898863'),
(522, '162.158.92.235', '1513898949'),
(523, '162.158.93.12', '1513899847'),
(524, '162.158.89.94', '1513900573'),
(525, '162.158.92.205', '1513905436'),
(526, '122.190.2.12', '1513909666'),
(527, '42.236.93.71', '1513909709'),
(528, '162.158.92.181', '1513912527'),
(529, '162.158.89.34', '1513915289'),
(530, '172.68.10.7', '1513915699'),
(531, '125.39.239.114', '1513916398'),
(532, '162.158.90.147', '1513918242'),
(533, '58.211.2.48', '1513918743'),
(534, '42.236.93.46', '1513922797'),
(535, '42.236.93.21', '1513922839'),
(536, '162.158.89.160', '1513923492'),
(537, '117.34.13.66', '1513924367'),
(538, '162.158.88.137', '1513929746'),
(539, '162.158.93.96', '1513931395'),
(540, '113.207.101.18', '1513935968'),
(541, '162.158.91.236', '1513937216'),
(542, '59.51.81.141', '1513948516'),
(543, '162.158.90.117', '1513950824'),
(544, '58.211.2.18', '1513957852'),
(545, '172.68.11.248', '1513965376'),
(546, '162.158.78.133', '1513981359'),
(547, '117.34.13.72', '1513982723'),
(548, '172.68.10.67', '1513989251'),
(549, '172.68.244.213', '1513989255'),
(550, '162.158.91.230', '1513990234'),
(551, '162.158.90.69', '1513990238'),
(552, '172.69.62.79', '1513990373'),
(553, '162.158.92.103', '1513991476'),
(554, '162.158.88.5', '1513995996'),
(555, '172.68.10.151', '1513997197'),
(556, '42.236.93.81', '1514001989'),
(557, '172.68.10.115', '1514002608'),
(558, '162.158.93.174', '1514004630'),
(559, '108.162.246.68', '1514005230'),
(560, '108.162.246.236', '1514005236'),
(561, '108.162.246.86', '1514005242'),
(562, '108.162.245.79', '1514005248'),
(563, '108.162.246.158', '1514005253'),
(564, '108.162.245.211', '1514005259'),
(565, '113.207.101.36', '1514010303'),
(566, '172.68.244.93', '1514014695'),
(567, '162.158.90.93', '1514016946'),
(568, '117.34.13.30', '1514022326'),
(569, '172.68.174.103', '1514033478'),
(570, '172.68.174.37', '1514033503'),
(571, '108.162.245.205', '1514033529'),
(572, '172.68.174.97', '1514033555'),
(573, '172.68.174.19', '1514033579'),
(574, '172.68.174.85', '1514033604'),
(575, '108.162.245.7', '1514033629'),
(576, '108.162.245.157', '1514033654'),
(577, '172.68.174.55', '1514033680'),
(578, '108.162.245.85', '1514033733'),
(579, '172.68.174.31', '1514033761'),
(580, '108.162.246.140', '1514033907'),
(581, '108.162.245.199', '1514033936'),
(582, '162.158.106.57', '1514033938'),
(583, '108.162.245.121', '1514033953'),
(584, '108.162.246.50', '1514033959'),
(585, '108.162.245.43', '1514033966'),
(586, '162.158.106.15', '1514033972'),
(587, '162.158.106.63', '1514033979'),
(588, '108.162.245.163', '1514033985'),
(589, '172.68.174.91', '1514034011'),
(590, '108.162.246.224', '1514034018'),
(591, '108.162.245.19', '1514034026'),
(592, '108.162.246.56', '1514034038'),
(593, '108.162.246.8', '1514034044'),
(594, '108.162.246.74', '1514034051'),
(595, '108.162.245.13', '1514034057'),
(596, '162.158.106.9', '1514034076'),
(597, '117.34.13.90', '1514042137'),
(598, '172.68.182.199', '1514083010'),
(599, '122.190.2.60', '1514097659'),
(600, '113.207.101.30', '1514121176'),
(601, '172.68.245.124', '1514133238'),
(602, '162.158.79.164', '1514135011'),
(603, '122.190.2.78', '1514157484'),
(604, '162.158.182.7', '1514163891'),
(605, '172.68.246.197', '1514167018'),
(606, '172.68.10.235', '1514167062'),
(607, '172.68.65.141', '1514167545'),
(608, '172.68.10.241', '1514167694'),
(609, '172.68.11.200', '1514167700'),
(610, '172.68.245.118', '1514167703'),
(611, '162.158.90.81', '1514168294'),
(612, '162.158.92.79', '1514168298'),
(613, '162.158.78.13', '1514168302'),
(614, '172.68.245.142', '1514168305'),
(615, '172.68.245.250', '1514180905'),
(616, '42.236.93.51', '1514188783'),
(617, '42.236.93.26', '1514188797'),
(618, '125.39.239.6', '1514192911'),
(619, '125.39.239.36', '1514192911'),
(620, '125.39.239.54', '1514192911'),
(621, '125.39.239.90', '1514192912'),
(622, '125.39.239.18', '1514192912'),
(623, '162.158.92.145', '1514202997'),
(624, '162.158.89.148', '1514204696'),
(625, '162.158.88.41', '1514205706'),
(626, '162.158.93.72', '1514209423'),
(627, '162.158.88.101', '1514211682'),
(628, '162.158.89.142', '1514211847'),
(629, '162.158.93.156', '1514213640'),
(630, '172.68.11.146', '1514215064'),
(631, '172.68.11.38', '1514215261'),
(632, '162.158.91.50', '1514215363'),
(633, '162.158.88.227', '1514215452'),
(634, '172.68.246.11', '1514215487'),
(635, '172.68.10.37', '1514218098'),
(636, '162.158.91.20', '1514222637'),
(637, '172.68.246.245', '1514222640'),
(638, '172.68.10.19', '1514229628'),
(639, '162.158.88.77', '1514229833'),
(640, '172.68.245.88', '1514231268'),
(641, '162.158.90.57', '1514235149'),
(642, '172.68.246.23', '1514235358'),
(643, '162.158.79.32', '1514236113'),
(644, '172.68.65.9', '1514239644'),
(645, '172.68.246.155', '1514240480'),
(646, '172.68.244.15', '1514240701'),
(647, '172.68.244.141', '1514240905'),
(648, '172.68.11.128', '1514242479'),
(649, '162.158.91.32', '1514242615'),
(650, '162.158.79.68', '1514242619'),
(651, '172.68.244.153', '1514244354'),
(652, '162.158.91.14', '1514245411'),
(653, '172.68.244.249', '1514245416'),
(654, '162.158.90.99', '1514247650'),
(655, '162.158.92.187', '1514247807'),
(656, '172.68.244.63', '1514249264'),
(657, '162.158.89.76', '1514249650'),
(658, '172.68.246.29', '1514251097'),
(659, '172.68.244.237', '1514251419'),
(660, '172.68.10.169', '1514251453'),
(661, '172.68.11.212', '1514252723'),
(662, '172.68.246.227', '1514257709'),
(663, '162.158.91.98', '1514260455'),
(664, '172.68.10.121', '1514260929'),
(665, '162.158.78.61', '1514261436'),
(666, '162.158.78.7', '1514261457'),
(667, '172.68.10.43', '1514262233'),
(668, '172.68.244.159', '1514265023'),
(669, '172.68.244.9', '1514280876'),
(670, '172.68.245.136', '1514280876'),
(671, '42.236.93.36', '1514282950'),
(672, '172.68.65.105', '1514300258'),
(673, '125.39.239.48', '1514302597'),
(674, '162.158.78.31', '1514307272'),
(675, '173.245.54.28', '1514311927'),
(676, '172.68.244.33', '1514323180'),
(677, '42.236.93.31', '1514341920'),
(678, '162.158.89.190', '1514344651'),
(679, '162.158.91.92', '1514364662'),