-
Notifications
You must be signed in to change notification settings - Fork 0
/
mysql.sql
1923 lines (1630 loc) · 217 KB
/
mysql.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
# ************************************************************
# Sequel Pro SQL dump
# Version 4096
#
# http://www.sequelpro.com/
# http://code.google.com/p/sequel-pro/
#
# Host: db-public-2 (MySQL 5.5.31)
# Database: wiki
# Generation Time: 2014-11-27 09:36:47 +0000
# ************************************************************
CREATE DATABASE wiki;
use wiki;
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
# Dump of table wiki_activation
# ------------------------------------------------------------
DROP TABLE IF EXISTS `wiki_activation`;
CREATE TABLE `wiki_activation` (
`uid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`code` char(32) NOT NULL,
`time` int(10) unsigned NOT NULL DEFAULT '0',
`available` tinyint(1) NOT NULL DEFAULT '1',
`type` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
# Dump of table wiki_advertisement
# ------------------------------------------------------------
DROP TABLE IF EXISTS `wiki_advertisement`;
CREATE TABLE `wiki_advertisement` (
`advid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`available` tinyint(1) NOT NULL DEFAULT '0',
`type` varchar(50) NOT NULL DEFAULT '0',
`title` varchar(255) NOT NULL DEFAULT '',
`targets` text NOT NULL,
`position` tinyint(2) NOT NULL DEFAULT '0',
`parameters` text NOT NULL,
`code` text NOT NULL,
`starttime` int(10) unsigned NOT NULL DEFAULT '0',
`endtime` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`advid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
# Dump of table wiki_attachment
# ------------------------------------------------------------
DROP TABLE IF EXISTS `wiki_attachment`;
CREATE TABLE `wiki_attachment` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`did` mediumint(8) unsigned NOT NULL DEFAULT '0',
`time` int(10) unsigned NOT NULL DEFAULT '0',
`filename` char(100) NOT NULL DEFAULT '',
`description` char(100) NOT NULL DEFAULT '',
`filetype` char(50) NOT NULL DEFAULT '',
`filesize` int(10) unsigned NOT NULL DEFAULT '0',
`attachment` char(100) NOT NULL DEFAULT '',
`downloads` mediumint(8) NOT NULL DEFAULT '0',
`coindown` smallint(4) NOT NULL DEFAULT '0',
`isimage` tinyint(1) unsigned NOT NULL DEFAULT '0',
`uid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`state` tinyint(4) NOT NULL DEFAULT '0',
`focus` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `did` (`did`),
KEY `uid` (`uid`),
KEY `time` (`time`),
KEY `downloads` (`downloads`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
LOCK TABLES `wiki_attachment` WRITE;
/*!40000 ALTER TABLE `wiki_attachment` DISABLE KEYS */;
INSERT INTO `wiki_attachment` (`id`, `did`, `time`, `filename`, `description`, `filetype`, `filesize`, `attachment`, `downloads`, `coindown`, `isimage`, `uid`, `state`, `focus`)
VALUES
(1,15,1416207024,'无标题.png','报错Log','png',57487,'uploads/201411/1416207024JDQkmTjU.png',0,0,1,7,0,1);
/*!40000 ALTER TABLE `wiki_attachment` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table wiki_autosave
# ------------------------------------------------------------
DROP TABLE IF EXISTS `wiki_autosave`;
CREATE TABLE `wiki_autosave` (
`aid` int(8) unsigned NOT NULL AUTO_INCREMENT,
`uid` int(6) unsigned NOT NULL,
`did` int(8) unsigned NOT NULL,
`id` int(4) NOT NULL,
`content` mediumtext NOT NULL,
`time` int(10) unsigned NOT NULL,
PRIMARY KEY (`aid`),
KEY `uid` (`uid`),
KEY `did` (`did`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
# Dump of table wiki_banned
# ------------------------------------------------------------
DROP TABLE IF EXISTS `wiki_banned`;
CREATE TABLE `wiki_banned` (
`id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
`ip1` smallint(3) NOT NULL DEFAULT '0',
`ip2` smallint(3) NOT NULL DEFAULT '0',
`ip3` smallint(3) NOT NULL DEFAULT '0',
`ip4` smallint(3) NOT NULL DEFAULT '0',
`admin` varchar(15) NOT NULL,
`time` int(10) unsigned NOT NULL DEFAULT '0',
`expiration` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
# Dump of table wiki_blacklist
# ------------------------------------------------------------
DROP TABLE IF EXISTS `wiki_blacklist`;
CREATE TABLE `wiki_blacklist` (
`uid` mediumint(8) unsigned NOT NULL,
`blacklist` text NOT NULL,
PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
# Dump of table wiki_block
# ------------------------------------------------------------
DROP TABLE IF EXISTS `wiki_block`;
CREATE TABLE `wiki_block` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`theme` varchar(50) NOT NULL DEFAULT '',
`file` varchar(50) NOT NULL DEFAULT '',
`area` varchar(50) NOT NULL DEFAULT '',
`areaorder` tinyint(3) unsigned NOT NULL DEFAULT '0',
`block` varchar(50) NOT NULL DEFAULT '',
`fun` varchar(30) NOT NULL DEFAULT '',
`tpl` varchar(50) DEFAULT NULL,
`params` longtext,
`modified` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
LOCK TABLES `wiki_block` WRITE;
/*!40000 ALTER TABLE `wiki_block` DISABLE KEYS */;
INSERT INTO `wiki_block` (`id`, `theme`, `file`, `area`, `areaorder`, `block`, `fun`, `tpl`, `params`, `modified`)
VALUES
(1,'default','index','ctop1',0,'doc','hotdocs','hotdocs.htm','a:2:{s:3:\"num\";s:0:\"\";s:5:\"style\";s:0:\"\";}',NULL),
(2,'default','index','ctop2',0,'doc','wonderdocs','wonderdocs.htm','a:1:{s:5:\"style\";s:0:\"\";}',NULL),
(3,'default','index','right',0,'user','login','login.htm','',NULL),
(4,'default','index','right',1,'news','recentnews','recentnews.htm','a:1:{s:5:\"style\";s:0:\"\";}',NULL),
(5,'default','index','right',2,'doc','cooperatedocs','cooperatedocs.htm','a:1:{s:5:\"style\";s:0:\"\";}',NULL),
(6,'default','index','cbottoml',0,'doc','recentdocs','recentdocs.htm','a:2:{s:3:\"num\";s:0:\"\";s:5:\"style\";s:0:\"\";}',NULL),
(7,'default','index','cbottoml',1,'comment','recentcomment','recentcomment.htm','a:1:{s:3:\"num\";s:0:\"\";}',NULL),
(8,'default','index','cbottomr',0,'pic','recentpics','recentpics.htm','a:1:{s:3:\"num\";s:0:\"\";}',NULL),
(9,'default','index','cbottomr',1,'doc','commenddocs','commenddocs.htm','a:1:{s:5:\"style\";s:0:\"\";}',NULL),
(10,'default','index','bottom',0,'doc','hottags','hottags.htm','a:1:{s:5:\"style\";s:0:\"\";}',NULL),
(11,'default','giftlist','price',0,'gift','giftpricerange','giftpricerange.htm','',NULL),
(12,'default','giftlist','right',0,'gift','giftnotice','giftnotice.htm','',NULL),
(13,'default','categorylist','right',0,'doc','hottags','hottags.htm','a:1:{s:5:\"style\";s:0:\"\";}',NULL),
(14,'default','categorylist','right',1,'doc','getletterdocs','getletterdocs.htm','a:1:{s:5:\"style\";s:0:\"\";}',NULL),
(15,'default','viewcomment','right',0,'doc','hotcommentdocs','hotcommentdocs.htm','a:1:{s:3:\"num\";s:2:\"10\";}',NULL),
(16,'default','index','bottom',1,'links','friendlinks','friendlinks.htm','a:1:{s:5:\"style\";s:0:\"\";}',NULL),
(17,'default','index','right',3,'doc','getletterdocs','getletterdocs.htm','a:1:{s:5:\"style\";s:0:\"\";}',NULL);
/*!40000 ALTER TABLE `wiki_block` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table wiki_category
# ------------------------------------------------------------
DROP TABLE IF EXISTS `wiki_category`;
CREATE TABLE `wiki_category` (
`cid` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
`pid` smallint(6) unsigned NOT NULL DEFAULT '0',
`name` char(50) NOT NULL DEFAULT '',
`displayorder` tinyint(3) NOT NULL DEFAULT '0',
`docs` mediumint(8) unsigned NOT NULL DEFAULT '0',
`image` varchar(255) NOT NULL DEFAULT '',
`navigation` text NOT NULL,
`description` text NOT NULL,
PRIMARY KEY (`cid`),
KEY `pid` (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
LOCK TABLES `wiki_category` WRITE;
/*!40000 ALTER TABLE `wiki_category` DISABLE KEYS */;
INSERT INTO `wiki_category` (`cid`, `pid`, `name`, `displayorder`, `docs`, `image`, `navigation`, `description`)
VALUES
(1,0,'合作开发',0,19,'','a:1:{i:0;a:2:{s:3:\"cid\";s:1:\"1\";s:4:\"name\";s:12:\"合作开发\";}}',''),
(2,1,'拼包',0,5,'','a:2:{i:0;a:2:{s:3:\"cid\";s:1:\"1\";s:4:\"name\";s:12:\"合作开发\";}i:1;a:2:{s:3:\"cid\";s:1:\"2\";s:4:\"name\";s:6:\"拼包\";}}',''),
(3,1,'PatchRom',1,8,'','a:2:{i:0;a:2:{s:3:\"cid\";s:1:\"1\";s:4:\"name\";s:12:\"合作开发\";}i:1;a:2:{s:3:\"cid\";s:1:\"3\";s:4:\"name\";s:8:\"PatchRom\";}}',''),
(6,0,'平台特有问题',2,3,'','a:1:{i:0;a:2:{s:3:\"cid\";s:1:\"6\";s:4:\"name\";s:18:\"平台特有问题\";}}',''),
(5,0,'官方开发',1,5,'','a:1:{i:0;a:2:{s:3:\"cid\";s:1:\"5\";s:4:\"name\";s:12:\"官方开发\";}}',''),
(7,0,'android技术文献',3,7,'','a:1:{i:0;a:2:{s:3:\"cid\";i:7;s:4:\"name\";s:19:\"android技术文献\";}}','');
/*!40000 ALTER TABLE `wiki_category` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table wiki_categorylink
# ------------------------------------------------------------
DROP TABLE IF EXISTS `wiki_categorylink`;
CREATE TABLE `wiki_categorylink` (
`id` int(8) unsigned NOT NULL AUTO_INCREMENT,
`did` int(8) unsigned NOT NULL DEFAULT '0',
`cid` int(8) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `did` (`did`),
KEY `cid` (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
LOCK TABLES `wiki_categorylink` WRITE;
/*!40000 ALTER TABLE `wiki_categorylink` DISABLE KEYS */;
INSERT INTO `wiki_categorylink` (`id`, `did`, `cid`)
VALUES
(10,7,3),
(9,7,1),
(8,6,3),
(7,6,1),
(5,5,1),
(6,5,3),
(11,8,1),
(12,8,3),
(13,9,5),
(14,10,1),
(15,11,1),
(16,11,2),
(17,12,1),
(18,12,3),
(19,13,1),
(20,13,2),
(21,14,1),
(22,14,2),
(23,14,3),
(24,14,5),
(25,15,1),
(26,15,3),
(27,16,7),
(28,17,1),
(29,17,2),
(30,18,1),
(31,18,7),
(37,22,1),
(36,21,2),
(38,23,7),
(39,24,5),
(43,26,3),
(42,26,1),
(45,28,6),
(46,29,7),
(47,30,7),
(48,30,6),
(49,30,5),
(50,31,1),
(52,33,7),
(53,34,7),
(54,35,6),
(55,36,1),
(56,36,5);
/*!40000 ALTER TABLE `wiki_categorylink` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table wiki_channel
# ------------------------------------------------------------
DROP TABLE IF EXISTS `wiki_channel`;
CREATE TABLE `wiki_channel` (
`id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
`name` char(50) NOT NULL DEFAULT '',
`url` char(200) NOT NULL DEFAULT '',
`displayorder` smallint(3) unsigned NOT NULL DEFAULT '0',
`available` tinyint(1) NOT NULL DEFAULT '1',
`position` tinyint(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
LOCK TABLES `wiki_channel` WRITE;
/*!40000 ALTER TABLE `wiki_channel` DISABLE KEYS */;
INSERT INTO `wiki_channel` (`id`, `name`, `url`, `displayorder`, `available`, `position`)
VALUES
(1,'首页','http://wiki.beta.lewaos.com/index.php',0,1,2),
(2,'百科分类','http://wiki.beta.lewaos.com/index.php?category',1,1,2),
(3,'排行榜','http://wiki.beta.lewaos.com/index.php?list',2,1,2),
(4,'图片百科','http://wiki.beta.lewaos.com/index.php?pic-piclist-2',3,1,2),
(5,'礼品商店','http://wiki.beta.lewaos.com/index.php?gift',4,0,2);
/*!40000 ALTER TABLE `wiki_channel` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table wiki_comment
# ------------------------------------------------------------
DROP TABLE IF EXISTS `wiki_comment`;
CREATE TABLE `wiki_comment` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`did` mediumint(8) unsigned NOT NULL DEFAULT '0',
`comment` char(200) NOT NULL DEFAULT '',
`reply` mediumtext NOT NULL,
`author` varchar(15) NOT NULL DEFAULT '',
`authorid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`oppose` tinyint(6) unsigned NOT NULL DEFAULT '0',
`aegis` tinyint(6) unsigned NOT NULL DEFAULT '0',
`time` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `time` (`time`),
KEY `did` (`did`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
LOCK TABLES `wiki_comment` WRITE;
/*!40000 ALTER TABLE `wiki_comment` DISABLE KEYS */;
INSERT INTO `wiki_comment` (`id`, `did`, `comment`, `reply`, `author`, `authorid`, `oppose`, `aegis`, `time`)
VALUES
(1,6,'aaaa','','admin',1,0,0,1416809851),
(2,23,'IP经常变化啊,有什么好办法自己找出速度最快的ip?','','wuxianlin',9,1,1,1416838584),
(3,9,'bbs<br />\nbbs3-2','','imac',15,2,2,1416906736),
(4,9,'与 iOS 相比,Android 的用户体验有个相对糟糕的开始。在很长的时间里,界面一直丑小鸭,卡顿也是挥不去的痛。不过,在 Google 的全力推动,以及硬件厂商的响应下,Android 还是跨越各种阻碍,逐渐壮大起来了。<br />\r\n在此过程中,Google 也在经历着重大的变化。它逐渐从一个只重视数据的公司,转变为一个重视设计和用户体验的公司。从 Android 4.0 开始,Androi','','乾坤大挪移',19,1,1,1417058982),
(5,9,'好','','180.166.124.62',0,0,2,1417059963),
(6,30,'地方地方','','乾坤大挪移',19,1,6,1417069963),
(7,30,'第三方地方','','乾坤大挪移',19,1,1,1417070495),
(8,30,'frf','','乾坤大挪移',19,0,2,1417070590),
(9,8,'dfasdfasdf','','theme',3,1,1,1417074254),
(10,30,'fw','','theme',3,0,0,1417074412),
(11,30,'fsa','','theme',3,0,0,1417074458),
(12,26,'t67yut6','','SJ伊诺',18,1,1,1417080649);
/*!40000 ALTER TABLE `wiki_comment` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table wiki_creditdetail
# ------------------------------------------------------------
DROP TABLE IF EXISTS `wiki_creditdetail`;
CREATE TABLE `wiki_creditdetail` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`uid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`operation` varchar(100) NOT NULL DEFAULT '',
`credit2` smallint(6) NOT NULL DEFAULT '0',
`credit1` smallint(6) NOT NULL DEFAULT '0',
`time` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
LOCK TABLES `wiki_creditdetail` WRITE;
/*!40000 ALTER TABLE `wiki_creditdetail` DISABLE KEYS */;
INSERT INTO `wiki_creditdetail` (`id`, `uid`, `operation`, `credit2`, `credit1`, `time`)
VALUES
(1,1,'user-register',20,20,1415328806),
(2,1,'user-login',1,1,1415328828),
(3,1,'doc-create',5,2,1415328933),
(4,1,'doc-create',5,2,1415342097),
(5,1,'user-login',1,1,1415597797),
(6,1,'doc-create',5,2,1415600210),
(7,1,'user-login',1,1,1415764581),
(8,0,'doc-edit',3,1,1415871509),
(9,4,'user-register',20,20,1415871620),
(10,0,'doc-create',5,2,1415871648),
(11,0,'doc-edit',3,1,1415875411),
(12,7,'doc-create',5,2,1416194295),
(13,1,'remove_doc',-5,0,1416194340),
(14,1,'remove_doc',-5,0,1416194340),
(15,1,'remove_doc',-5,0,1416194340),
(16,0,'remove_doc',-5,0,1416194340),
(17,7,'doc-create',5,2,1416194448),
(18,7,'doc-create',5,2,1416195045),
(19,7,'doc-create',5,2,1416195503),
(20,7,'doc-create',5,2,1416195837),
(21,7,'doc-create',5,2,1416196235),
(22,8,'doc-create',5,2,1416196434),
(23,7,'doc-create',5,2,1416196517),
(24,8,'doc-create',5,2,1416204119),
(25,7,'doc-create',5,2,1416205823),
(26,7,'attachment-upload',2,1,1416207024),
(27,7,'doc-create',5,2,1416207102),
(28,8,'doc-create',5,2,1416207174),
(29,11,'doc-create',5,2,1416207669),
(30,7,'doc-create',5,2,1416207903),
(31,1,'doc-create',5,2,1416208041),
(32,1,'remove_doc',-5,0,1416208119),
(33,7,'doc-create',5,2,1416208355),
(34,7,'doc-create',5,2,1416208564),
(35,11,'doc-edit',3,1,1416208671),
(36,7,'doc-create',5,2,1416208889),
(37,8,'doc-edit',3,1,1416211999),
(38,8,'doc-create',5,2,1416213743),
(39,13,'user-register',20,20,1416536114),
(40,1,'user-comment',2,1,1416809851),
(41,14,'user-register',20,20,1416816898),
(42,9,'user-comment',2,1,1416838584),
(43,15,'doc-edit',3,1,1416906164),
(44,15,'user-comment',2,1,1416906736),
(45,19,'user-pms',1,0,1417055045),
(46,19,'user-pms',1,0,1417055067),
(47,19,'user-pms',1,0,1417055085),
(48,19,'user-pms',1,0,1417055747),
(49,19,'user-pms',1,0,1417055919),
(50,19,'user-comment',2,1,1417058982),
(51,19,'user-comment',2,1,1417059963),
(52,19,'doc-create',5,2,1417067328),
(53,18,'user-pms',1,0,1417069463),
(54,19,'user-comment',2,1,1417069963),
(55,19,'user-comment',2,1,1417070495),
(56,19,'user-comment',2,1,1417070590),
(57,3,'doc-create',5,2,1417073698),
(58,3,'user-comment',2,1,1417074254),
(59,3,'user-comment',2,1,1417074412),
(60,3,'user-comment',2,1,1417074458),
(61,19,'doc-create',5,2,1417075369),
(62,19,'doc-edit',3,1,1417075422),
(63,19,'doc-edit',3,1,1417075454),
(64,19,'doc-edit',3,1,1417075465),
(65,18,'doc-create',5,2,1417075542),
(66,18,'doc-create',5,2,1417075630),
(67,19,'doc-edit',3,1,1417075656),
(68,18,'doc-create',5,2,1417078631),
(69,18,'user-comment',2,1,1417080649),
(70,18,'doc-edit',3,1,1417080791);
/*!40000 ALTER TABLE `wiki_creditdetail` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table wiki_datacall
# ------------------------------------------------------------
DROP TABLE IF EXISTS `wiki_datacall`;
CREATE TABLE `wiki_datacall` (
`id` smallint(5) NOT NULL AUTO_INCREMENT,
`name` varchar(60) NOT NULL,
`type` varchar(60) NOT NULL,
`category` varchar(60) NOT NULL DEFAULT '0',
`classname` varchar(60) NOT NULL DEFAULT 'sql',
`function` varchar(60) NOT NULL,
`desc` varchar(255) NOT NULL,
`param` text NOT NULL,
`cachetime` int(10) NOT NULL DEFAULT '0',
`available` tinyint(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `category` (`category`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
LOCK TABLES `wiki_datacall` WRITE;
/*!40000 ALTER TABLE `wiki_datacall` DISABLE KEYS */;
INSERT INTO `wiki_datacall` (`id`, `name`, `type`, `category`, `classname`, `function`, `desc`, `param`, `cachetime`, `available`)
VALUES
(1,'doc_most_visited','sql','doc','sql','sql','访问最多词条','a:9:{s:7:\"tplcode\";s:175:\"<dl class=\"col-dl \"><dt><a title=\"[title]\" href=\"index.php?doc-view-[did]\"> [title]</a></dt><dd>[summary][<a class=\"entry\" href=\"index.php?doc-view-[did]\">view</a>]</dd> </dl>\";s:13:\"empty_tplcode\";s:0:\"\";s:3:\"sql\";s:84:\"select did,title,summary from {DB_TABLEPRE}doc where 1 order by views desc limit 10;\";s:6:\"select\";s:0:\"\";s:4:\"from\";s:0:\"\";s:5:\"where\";s:0:\"\";s:5:\"other\";s:0:\"\";s:7:\"orderby\";s:0:\"\";s:5:\"limit\";s:4:\"0,10\";}',1000,1),
(2,'user_total_num','sql','user','sql','sql','注册会员数','a:9:{s:7:\"tplcode\";s:9:\"[usernum]\";s:13:\"empty_tplcode\";s:0:\"\";s:3:\"sql\";s:49:\"SELECT COUNT(*) AS usernum FROM {DB_TABLEPRE}user\";s:6:\"select\";s:0:\"\";s:4:\"from\";s:0:\"\";s:5:\"where\";s:0:\"\";s:5:\"other\";s:0:\"\";s:7:\"orderby\";s:0:\"\";s:5:\"limit\";s:4:\"0,10\";}',1000,1),
(3,'doc_total_num','sql','doc','sql','sql','网站所有词条数','a:9:{s:7:\"tplcode\";s:20:\"doc total num: [num]\";s:13:\"empty_tplcode\";s:0:\"\";s:3:\"sql\";s:0:\"\";s:6:\"select\";s:18:\"count(did) as num \";s:4:\"from\";s:16:\"{DB_TABLEPRE}doc\";s:5:\"where\";s:1:\"1\";s:5:\"other\";s:0:\"\";s:7:\"orderby\";s:0:\"\";s:5:\"limit\";s:3:\"0,1\";}',1000,1),
(4,'doc_most_comment','sql','doc','sql','sql','评论最多词条列表','a:9:{s:7:\"tplcode\";s:181:\"<dl class=\"col-dl \"><dt><a title=\"[title]\" href=\"index.php?doc-view-[did]\"> [title]([num])</a></dt><dd>[comment][<a class=\"entry\" href=\"index.php?doc-view-[did]\">view</a>]</dd></dl>\";s:13:\"empty_tplcode\";s:0:\"\";s:3:\"sql\";s:0:\"\";s:6:\"select\";s:44:\"d.did,d.title,c.comment, count(c.did) AS num\";s:4:\"from\";s:68:\"{DB_TABLEPRE}doc AS d LEFT JOIN {DB_TABLEPRE}comment AS c USING(did)\";s:5:\"where\";s:0:\"\";s:5:\"other\";s:14:\"GROUP BY c.did\";s:7:\"orderby\";s:8:\"num desc\";s:5:\"limit\";s:4:\"0,10\";}',1000,1),
(5,'doc_recommends','sql','doc','sql','sql','推荐词条信息','a:9:{s:7:\"tplcode\";s:175:\"<dl class=\"col-dl \"><dt><a title=\"[title]\" href=\"index.php?doc-view-[did]\"> [title]</a></dt><dd>[summary][<a class=\"entry\" href=\"index.php?doc-view-[did]\">view</a>]</dd> </dl>\";s:13:\"empty_tplcode\";s:0:\"\";s:3:\"sql\";s:91:\"select did,title,summary from {DB_TABLEPRE}focus where `type`=1 order by did desc limit 10;\";s:6:\"select\";s:0:\"\";s:4:\"from\";s:0:\"\";s:5:\"where\";s:0:\"\";s:5:\"other\";s:0:\"\";s:7:\"orderby\";s:0:\"\";s:5:\"limit\";s:4:\"0,10\";}',1000,1),
(6,'doc_wonderful','sql','doc','sql','sql','精彩词条','a:9:{s:7:\"tplcode\";s:175:\"<dl class=\"col-dl \"><dt><a title=\"[title]\" href=\"index.php?doc-view-[did]\"> [title]</a></dt><dd>[summary][<a class=\"entry\" href=\"index.php?doc-view-[did]\">view</a>]</dd> </dl>\";s:13:\"empty_tplcode\";s:0:\"\";s:3:\"sql\";s:91:\"select did,title,summary from {DB_TABLEPRE}focus where `type`=3 order by did desc limit 10;\";s:6:\"select\";s:0:\"\";s:4:\"from\";s:0:\"\";s:5:\"where\";s:0:\"\";s:5:\"other\";s:0:\"\";s:7:\"orderby\";s:0:\"\";s:5:\"limit\";s:4:\"0,10\";}',1000,1),
(7,'user_new_register','sql','user','sql','sql','最新注册用户','a:9:{s:7:\"tplcode\";s:104:\"<dl class=\"col-dl \"><dt><a href=\"index.php?user-space-[uid]\"> [username]</a></dt><dd>[regtime]</dd></dl>\";s:13:\"empty_tplcode\";s:0:\"\";s:3:\"sql\";s:109:\"SELECT uid,username,from_unixtime( regtime ) as regtime FROM {DB_TABLEPRE}user order by regtime desc limit 1\";s:6:\"select\";s:0:\"\";s:4:\"from\";s:0:\"\";s:5:\"where\";s:0:\"\";s:5:\"other\";s:0:\"\";s:7:\"orderby\";s:0:\"\";s:5:\"limit\";s:4:\"0,10\";}',1000,1),
(8,'cat_doc','sql','doc','sql','sql','调用某个分类下的词条,不包括子分类;默认是调用分类ID等于10的词条,如需调用其它分类下词条,修改“SQL完整表达式”下面cid=10中10的值','a:9:{s:7:\"tplcode\";s:175:\"<dl class=\"col-dl \"><dt><a title=\"[title]\" href=\"index.php?doc-view-[did]\"> [title]</a></dt><dd>[summary][<a class=\"entry\" href=\"index.php?doc-view-[did]\">view</a>]</dd> </dl>\";s:13:\"empty_tplcode\";s:0:\"\";s:3:\"sql\";s:116:\"select did,title,summary from {DB_TABLEPRE}doc WHERE did IN (select did from {DB_TABLEPRE}categorylink where cid=10)\";s:6:\"select\";s:0:\"\";s:4:\"from\";s:0:\"\";s:5:\"where\";s:0:\"\";s:5:\"other\";s:0:\"\";s:7:\"orderby\";s:0:\"\";s:5:\"limit\";s:4:\"0,10\";}',1000,1),
(9,'cat_subcat','sql','category','sql','sql','调用某个分类下子分类,默认是调用分类ID等于3下子分类,如需调用其它分类下子分类,修改“SQL完整表达式”下面pid=3的pid值','a:9:{s:7:\"tplcode\";s:101:\"<dl class=\"col-dl \"><dd><a title=\"[title]\" href=\"index.php?category-view-[cid]\"> [name]</a></dd></dl>\";s:13:\"empty_tplcode\";s:0:\"\";s:3:\"sql\";s:57:\"select cid, name from {DB_TABLEPRE}category where pid=3\";s:6:\"select\";s:0:\"\";s:4:\"from\";s:0:\"\";s:5:\"where\";s:0:\"\";s:5:\"other\";s:0:\"\";s:7:\"orderby\";s:0:\"\";s:5:\"limit\";s:4:\"0,10\";}',1000,1);
/*!40000 ALTER TABLE `wiki_datacall` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table wiki_doc
# ------------------------------------------------------------
DROP TABLE IF EXISTS `wiki_doc`;
CREATE TABLE `wiki_doc` (
`did` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`cid` int(6) unsigned NOT NULL,
`letter` char(1) NOT NULL,
`title` varchar(80) NOT NULL DEFAULT '',
`tag` varchar(250) NOT NULL,
`summary` varchar(250) NOT NULL,
`content` mediumtext NOT NULL,
`author` varchar(15) NOT NULL DEFAULT '',
`authorid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`time` int(10) unsigned NOT NULL DEFAULT '0',
`lastedit` int(10) unsigned NOT NULL DEFAULT '0',
`lasteditor` char(15) NOT NULL DEFAULT '',
`lasteditorid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`views` int(10) unsigned NOT NULL DEFAULT '0',
`edits` mediumint(8) unsigned NOT NULL DEFAULT '0',
`editions` mediumint(8) unsigned NOT NULL DEFAULT '0',
`comments` mediumint(8) unsigned NOT NULL DEFAULT '0',
`votes` mediumint(8) unsigned NOT NULL DEFAULT '0',
`visible` tinyint(1) NOT NULL DEFAULT '1',
`locked` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`did`),
KEY `title` (`title`),
KEY `cid` (`cid`),
KEY `authorid` (`authorid`),
KEY `letter` (`letter`),
KEY `lastedit` (`lastedit`),
KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
LOCK TABLES `wiki_doc` WRITE;
/*!40000 ALTER TABLE `wiki_doc` DISABLE KEYS */;
INSERT INTO `wiki_doc` (`did`, `cid`, `letter`, `title`, `tag`, `summary`, `content`, `author`, `authorid`, `time`, `lastedit`, `lasteditor`, `lasteditorid`, `views`, `edits`, `editions`, `comments`, `votes`, `visible`, `locked`)
VALUES
(6,0,'r','如何编译patch rom','','. build/envsetup.sh\r\n\r\nmkdir 机型名\r\n\r\ncd 机型名\r\n\r\nadb reboot recovery\r\n\r\n../tools/releasetools/ota_target','<pre style=\"box-sizing: border-box; overflow: auto; font-family: Consolas, \'Liberation Mono\', Menlo, Courier, monospace; margin-bottom: 16px; line-height: 1.45; padding: 16px; background-color: rgb(247, 247, 247); border-top-left-radius: 3px; border-top-right-radius: 3px; border-bottom-right-radius: 3px; border-bottom-left-radius: 3px; word-wrap: normal; color: rgb(51, 51, 51);\"><code style=\"box-sizing: border-box; font-family: Consolas, \'Liberation Mono\', Menlo, Courier, monospace; line-height: inherit; padding: 0px; margin: 0px; background-color: transparent; border-top-left-radius: 3px; border-top-right-radius: 3px; border-bottom-right-radius: 3px; border-bottom-left-radius: 3px; word-break: normal; border: 0px; display: inline; word-wrap: normal;\">. build/envsetup.sh\r\n\r\nmkdir 机型名\r\n\r\ncd <span style=\"font-family: \'Courier New\', Courier, monospace; background-color: transparent; line-height: inherit;\">机型名</span><br />\r\n\r\nadb reboot recovery\r\n\r\n../tools/releasetools/ota_target_from_phone -r (this will generate a stockrom.zip, flash this zip in recovery mode to ensure it works)\r\n\r\ncp ../build/makefile . (change the local-zip-files to stockrom.zip, read the comments in makefile)\r\n\r\nmake workspace\r\n\r\nmake firstpatch (this command will patch the lewa code into framework.jar, services.jar and android.policy.jar, you should resolve the conflict in temp/reject)\r\n\r\nmake fullota</code></pre>','Rom_舜',7,1416194448,1416194448,'Rom_舜',7,25,0,0,1,0,1,0),
(5,0,'r','如何获取patch代码','','4.1代码获取:repo init -u git://github.com/LeWaCode/patchrom.git -b jellybeanrepo sync4.2代码获取:repo init -u','<p><b style=\"line-height: 1.5;\">4.1代码获取:</b></p><b>repo init -u git://github.com/LeWaCode/patchrom.git -b jellybean</b><div><b>repo sync<br /></b><p><br /></p></div><p><b>4.2代码获取:</b></p><p><b>repo init -u git://github.com/LeWaCode/patchrom.git -b jellybean42</b></p><p><b>repo sync </b></p><p><b><br /></b></p><p><b>4.4代码获取:</b></p><p><b>repo init -u git://github.com/LeWaCode/patchrom.git -b kitkat</b></p><p><b>repo sync</b></p>','Rom_舜',7,1416194295,1416194295,'Rom_舜',7,13,0,0,0,0,1,0),
(7,0,'t','提取包过程中签名报错的处理','','例如三星等包,非常的大,会导致签名报错而无法提交,遇到此类的情况我们只需要让他最后打包不要签名即可。将tools/releasetools/ota_from_target_files中的common.S','<p>例如三星等包,非常的大,会导致签名报错而无法提交,遇到此类的情况我们只需要让他最后打包不要签名即可。</p><p>将tools/releasetools/ota_from_target_files中的</p><p>common.SignFile(temp_zip_name, output_zip_name, OPTIONS.package_key, pw,<span style=\"line-height: 1.5;\"> whole_file=True)</span></p><p>改为</p><p>common.SignFile(temp_zip_name, output_zip_name, OPTIONS.package_key, pw,<span style=\"line-height: 1.5;\"> whole_file=False)</span></p><p>即可</p>','Rom_舜',7,1416195045,1416195045,'Rom_舜',7,29,0,0,0,1,1,0),
(8,0,'p','patch T9无法使用','','确认一下是否已经使用乐蛙提供的libsqlite.so。如果没有使用adb push libsqlite.so system/lib。','<p>确认一下是否已经使用乐蛙提供的libsqlite.so。如果没有使用adb push libsqlite.so system/lib。</p>','Rom_舜',7,1416195503,1416195503,'Rom_舜',7,34,0,0,1,2,1,0),
(9,0,'A','ART无法使用','',' 为了保证Android4.4平台中 ART模式 的正常运行,在修改Framework 代码时,请注意两个地方: 1. 类的static','<p> 为了保证Android4.4平台中 ART模式 的正常运行,在修改Framework 代码<span style=\"line-height: 1.5;\">时,请注意两个地方:</span></p><p> 1. 类的static {} 代码区域内 禁止调用 JNI 的方法</p><p> 2. 类的static 变量初始化时,禁止调用JNI的方法</p><p> SystemProperties.get(\"XX\", \"XX\");</p><p> native_XXX();</p><p><br /></p><p>如果art无法使用请确认是否存在如上所述的问题。</p>','Rom_舜',7,1416195837,1416906164,'imac',15,60,1,1,3,4,1,0),
(30,0,'*','&^','sdgfdggg','dsgsgsgs','<p>edfsdfsf99440j非gjjgjskdm fdgvs;gkjsre000--9-=0-0-0-0-mfkgjskmdg m jnadfjfm08903^**)_)_jgos##%^*)反反复复</p>','乾坤大挪移',19,1417067328,1417075465,'乾坤大挪移',19,26,2,2,5,1,1,0),
(10,0,'g','官方framework.jar 过大 将部分内容从 framework 移到framework2 的情况','','例如三星机器, framework.jar 中有部分内容被移到framework2中, 这时我们在make firstpatch 时不能够通过命令将移到framework2中的内容正确的patch. 所','<p>例如三星机器, framework.jar 中有部分内容被移到framework2中, 这时我们在make firstpatch 时不能够通过命令将移到framework2中的内容正确的patch. 所以我们在make firstpatch之前需要将这些更改(移走的内容)还原后再执行make firstpatch命令。在make firstpatch之后 需要还原官方的更改,并且在make fullota 之前学要在脚本之中加入移除多patch加入的部分内容。<br /></p>','玛法里奥',8,1416196434,1416196434,'玛法里奥',8,28,0,0,0,1,1,0),
(11,0,'z','指南针无法使用','','一般遇到指南针无法使用基本都是由于sensor造成的问题。可以替换如下几个文件,基本就可以修复sensor的问题。system/bin/sensorservice&nbsp;system/bin/mse','<p>一般遇到指南针无法使用基本都是由于sensor造成的问题。可以替换如下几个文件,基本就可以修复sensor的问题。</p><p>system/bin/sensorservice </p><p>system/bin/msensord</p><p>system/lib/libsensorservice.so</p><div><br /></div>','Rom_舜',7,1416196235,1416196235,'Rom_舜',7,3,0,0,0,0,1,0),
(12,0,'p','patch 定制apk','','patch有部分应用需要使用官方,有部分需要使用乐蛙的,在脚本中可以进行定制。phoneapps.mk &nbsp;里面可以定制一些需要拷贝官方的apkmakefile中local-lewa-remov','<p>patch有部分应用需要使用官方,有部分需要使用乐蛙的,在脚本中可以进行定制。</p><p>phoneapps.mk <span style=\"line-height: 1.5;\">里面可以定制一些需要拷贝官方的apk</span></p><p>makefile中</p><p>local-lewa-removed-apps字段为需要从包中移除的app </p><p>local-lewa-removed-priv-apps字段为需要从包中移除的 私有app</p>','Rom_舜',7,1416196517,1416196517,'Rom_舜',7,8,0,0,0,1,1,0),
(13,0,'p','拼包掉基带问题','','拼包后机器启动后可能发现基带丢失问题。这时先将 官方rail 相关的内库替换掉重启查看 是否有基带。没有的话刷回关方包查看是否有基带。如果有 可以更换成官方的boot 查看rild 是否能够启动。如果刷','拼包后机器启动后可能发现基带丢失问题。这时先将 官方rail 相关的内库替换掉重启查看 是否有基带。没有的话刷回关方包查看是否有基带。如果有 可以更换成官方的boot 查看rild 是否能够启动。如果刷回官方基带仍然丢失,请用救砖线包尝试!刷回官方后将我们拼好的包换官方boot 尝试,如果有基带 对比boot 区别!<br />','玛法里奥',8,1416204119,1416204119,'玛法里奥',8,4,0,0,0,0,1,0),
(14,0,'s','手机读取不到信号问题定位','','手机读取不到信号可以能由于如下几点:1、首先确定是否有基带?如果没有,试试卡刷回官方的ROM。如果依旧没有说明基带丢失了。有可能是boot.img recovery.img 和刷机脚本导致。如果有基带。','<p>手机读取不到信号可以能由于如下几点:</p><p>1、首先确定是否有基带?</p><p>如果没有,试试卡刷回官方的ROM。如果依旧没有说明基带丢失了。有可能是boot.img recovery.img 和刷机脚本导致。</p><p>如果有基带。那说明rom包里面的文件如bin下面有问题。相机可以看丢基带的解决方的词条。</p><p>2、如果有基带,那么adb shell进入手机。ps |grep rild看一下。是否rild的进程已经起来?</p><p>如果没有起来,轻确认boot是否好,还有rild、rild2的库是否使用了官方的库。</p><p>3、如果rild进程起来了,库都用对了,就是没有信号。那么就需要抓取Log来分析。</p><p>需要两个log。adb logcat -b radio -b main>log.txt</p>','Rom_舜',7,1416205823,1416205823,'Rom_舜',7,9,0,0,0,0,1,0),
(15,0,'k','开机SystemUI出错(锁屏篇)','','很多人遇到了开机以后systemUI进程出错的问题。实际从Log中分析可以看出是由于锁屏的布局加载导致。因为4.4锁屏是跑在systemUI进程中的。后举一个锁屏报错的例子,Log见附件。解决方法就是解','<p>很多人遇到了开机以后systemUI进程出错的问题。实际从Log中分析可以看出是由于锁屏的布局加载导致。</p><p>因为4.4锁屏是跑在systemUI进程中的。</p><p>后举一个锁屏报错的例子,Log见附件。</p><p>解决方法就是解开官方的keyguard应用和乐蛙的keyguard应用对比GlowPadView的布局文件。然后将官方替换到乐蛙。回编译乐蛙的keyguard。push到手机中就可以解决。</p><p><br /><br /><div class=\"img img_l\" style=\"width:300px;\"><a title=\"报错Log\" href=\"uploads/201411/1416207024JDQkmTjU.png\" target=\"_blank\"><img title=\"报错Log\" alt=\"报错Log\" src=\"uploads/201411/1416207024JDQkmTjU_s.png\" /></a><strong>报错Log</strong></div><br /><br /></p>','Rom_舜',7,1416207102,1416207102,'Rom_舜',7,45,0,0,0,2,1,0),
(16,0,'A','ART和davik区别','','&nbsp;\r\n &nbsp; &nbsp; &nbsp; \r\n我们知道,Dalvik虚拟机实则也算是一个Java虚拟机,只不过它执行的不是class文件,而是dex文件。因此,ART运行时最理想的方式','<p> \r\n \r\n我们知道,Dalvik虚拟机实则也算是一个Java虚拟机,只不过它执行的不是class文件,而是dex文件。因此,ART运行时最理想的方式也是实\r\n现为一个Java虚拟机的形式,这样就可以很容易地将Dalvik虚拟机替换掉。注意,我们这里说实现为Java虚拟机的形式,实际上是指提供一套完全与\r\nJava虚拟机兼容的接口。例如,Dalvik虚拟机在接口上与Java虚拟机是一致的,但是它的内部可以是完全不一样的东西。</p><p> 实际上,ART运行时就是真的和Dalvik虚拟机一样,实现了一套完全兼容Java虚拟机的接口。为了方便描述,接下来我们就将ART运行时称为ART虚拟机,它和Dalvik虚拟机、Java虚拟机的关系如图1所示:</p><p style=\"text-align: center;\"><img src=\"http://img.blog.csdn.net/20140111165827656?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvTHVvc2hlbmd5YW5n/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast\" alt=\"\" /><br /></p><p style=\"text-align: center;\">图1 Java虚拟机、Dalvik虚拟机和ART运行时的关系</p><p> 从图1可以知道,Dalvik虚拟机和ART虚拟机都实现了三个用来抽象Java虚拟机的接口:</p><p> 1. JNI_GetDefaultJavaVMInitArgs -- 获取虚拟机的默认初始化参数</p><p> 2. JNI_CreateJavaVM -- 在进程中创建虚拟机实例</p><p> 3. JNI_GetCreatedJavaVMs -- 获取进程中创建的虚拟机实例</p><p> \r\n \r\n 在Android系统中,Davik虚拟机实现在libdvm.so中,ART虚拟机实现在libart.so中。也就是说,libdvm.so和\r\nlibart.so导出了JNI_GetDefaultJavaVMInitArgs、JNI_CreateJavaVM和\r\nJNI_GetCreatedJavaVMs这三个接口,供外界调用。</p><p> \r\n 此外,Android系统还提供了一个系统属性persist.sys.dalvik.vm.lib,它的值要么等于libdvm.so,要么等于\r\nlibart.so。当等于libdvm.so时,就表示当前用的是Dalvik虚拟机,而当等于libart.so时,就表示当前用的是ART虚拟机。</p><p> \r\n \r\n 以上描述的Dalvik虚拟机和ART虚拟机的共同之处,当然它们之间最显著还是不同之处。不同的地方就在于,Dalvik虚拟机执行的是dex字节\r\n码,ART虚拟机执行的是本地机器码。这意味着Dalvik虚拟机包含有一个解释器,用来执行dex字节码,具体可以参考<a target=\"_blank\" href=\"http://blog.csdn.net/luoshengyang/article/details/8852432\">Dalvik虚拟机简要介绍和学习计划</a>这\r\n个系列的文章。当然,Android从2.2开始,也包含有JIT(Just-In-Time),用来在运行时动态地将执行频率很高的dex字节码翻译成\r\n本地机器码,然后再执行。通过JIT,就可以有效地提高Dalvik虚拟机的执行效率。但是,将dex字节码翻译成本地机器码是发生在应用程序的运行过程\r\n中的,并且应用程序每一次重新运行的时候,都要做重做这个翻译工作的。因此,即使用采用了JIT,Dalvik虚拟机的总体性能还是不能与直接执行本地机\r\n器码的ART虚拟机相比。</p><p> \r\n那么,ART虚拟机执行的本地机器码是从哪里来的呢?Android的运行时从Dalvik虚拟机替换成ART虚拟机,并不要求开发者要将重新将自己的应\r\n用直接编译成目标机器码。也就是说,开发者开发出的应用程序经过编译和打包之后,仍然是一个包含dex字节码的APK文件。既然应用程序包含的仍然是\r\ndex字节码,而ART虚拟机需要的是本地机器码,这就必然要有一个翻译的过程。这个翻译的过程当然不能发生应用程序运行的时候,否则的话就和\r\nDalvik虚拟机的JIT一样了。在计算机的世界里,与JIT相对的是AOT。AOT进Ahead-Of-Time的简称,它发生在程序运行之前。我们\r\n用静态语言(例如C/C++)来开发应用程序的时候,编译器直接就把它们翻译成目标机器码。这种静态语言的编译方式也是AOT的一种。但是前面我们提\r\n到,ART虚拟机并不要求开发者将自己的应用直接编译成目标机器码。这样,将应用的dex字节码翻译成本地机器码的最恰当AOT时机就发生在应用安装的时\r\n候。</p><p> \r\n 我们知道,没有ART虚拟机之前,应用在安装的过程,其实也会执行一次“翻译”的过程。只不过这个“翻译”的过程是将dex字节码进行优化,也就是由\r\ndex文件生成odex文件。这个过程由安装服务PackageManagerService请求守护进程installd来执行的。从这个角度来说,在\r\n应用安装的过程中将dex字节码翻译成本地机器码对原来的应用安装流程基本上就不会产生什么影响。</p><p><br /></p><p>详情参见:http://blog.csdn.net/luoshengyang/article/details/18006645 <br /></p>','玛法里奥',8,1416207174,1416207174,'玛法里奥',8,6,0,0,0,0,1,0),
(17,0,'j','基带问题','','bug:进入系统后发现基带丢失解决方法:找到system/bin/gsm0710muxdmd2 gsm0710muxd 和 vold文件(替换官方的即可)','<p><b>bug:进入系统后发现基带丢失</b></p><p><b><br /></b></p><p>解决方法:找到system/bin/gsm0710muxdmd2 gsm0710muxd 和 vold文件(替换官方的即可) </p>','shenanan101',11,1416207669,1417080791,'SJ伊诺',18,10,1,1,0,0,1,0),
(18,0,'y','源码aosp/cm编译问题','','最近有合作开发想要自己编译源码。这里介绍一下编译的相关命令全编代码:. build/envsetup.shlunch 机型make -j4如果在未全编的项目下,你像很快的编译出来一个模块例如framew','<p>最近有合作开发想要自己编译源码。这里介绍一下编译的相关命令</p><p>全编代码:</p><p>. build/envsetup.sh</p><p>lunch 机型</p><p>make -j4</p><p><br /></p><p>如果在未全编的项目下,你像很快的编译出来一个模块例如framework.jar,你可以这样做:</p><p>. build/envsetup.sh</p><p>lunch 机型</p><p>make <font color=\"#ff0000\">framework //这里的framework对应的是你要编译的模块名,而非路径</font></p><p><font color=\"#ff0000\"><br /></font></p><p><br /></p><p>如果你已经全变过代码,或者你需要的编译的模块已经单独make过了。那么你只需要</p><p style=\"font-size: 13.63636302948px; line-height: 19.0909080505371px;\">. build/envsetup.sh</p><p style=\"font-size: 13.63636302948px; line-height: 19.0909080505371px;\">lunch 机型</p><p>mmm frameworks/base/</p>','Rom_舜',7,1416207903,1416207903,'Rom_舜',7,6,0,0,0,1,1,0),
(21,0,'','手机卡在第一第一屏','','&nbsp; &nbsp; libmali.so存在差异(需要更换为官方的libmali.so库)','<p> libmali.so存在差异(需要更换为官方的libmali.so库)</p>','shenanan101',11,1416208157,1416208671,'shenanan101',11,14,1,1,0,0,1,0),
(22,0,'4','4.4 boot.img里面哪里添加lewa-framework','','4.4如何添加lewa-framework.jar到启动。以前大家都是在init.rc里面添加。现在4.4有一个专门的文件用于添加。init.environ.rc 文件可以用于添加。','<p>4.4如何添加lewa-framework.jar到启动。以前大家都是在init.rc里面添加。现在4.4有一个专门的文件用于添加。init.environ.rc 文件可以用于添加。</p>','Rom_舜',7,1416208355,1416208355,'Rom_舜',7,2,0,0,0,0,1,0),
(23,0,'t','同步5.0代码的问题','','目前很多在同步5.0代码的时候会出现非常慢,无法同步的情况。因此我们需要在host中加入如下两条,这样就可以顺利的同步谷歌的代码啦如果同步代码总是有问题,请修改下host,与代码同步有关的站点就两个74','<p>目前很多在同步5.0代码的时候会出现非常慢,无法同步的情况。因此我们需要在host中加入如下两条,这样就可以顺利的同步谷歌的代码啦</p><p><span style=\"font-family: 微软雅黑, Tahoma; font-size: large; line-height: normal;\">如果同步代码总是有问题,请修改下host,与代码同步有关的站点就两个</span><br style=\"font-family: 微软雅黑, Tahoma; font-size: large; line-height: normal;\"><span style=\"font-family: 微软雅黑, Tahoma; font-size: large; line-height: normal;\">74.125.21.98 android.googlesource.com</span><br style=\"font-family: 微软雅黑, Tahoma; font-size: large; line-height: normal;\"><span style=\"font-family: 微软雅黑, Tahoma; font-size: large; line-height: normal;\">74.125.21.98 gerrit.googlesource.com</span></p>','Rom_舜',7,1416208564,1416208564,'Rom_舜',7,8,0,0,1,0,1,0),
(24,0,'I','Input事件传递','','主要有两个功能点1.Native 层,将Native 的MotionEvent 对象传送到java 层&nbsp; aosp 的代码中 默认是没有将 Native层 的 MotionEvent 的对象传','<p><span class=\"pun\" style=\"font-family: 微软雅黑, Tahoma; font-size: 14px; line-height: normal;\">主要有两个功能点<br />1.Native 层,将Native 的MotionEvent 对象传送到java 层<br /> aosp 的代码中 默认是没有将 Native层 的 MotionEvent 的对象传送到Java层的(Native层 的 KeyEvent 都是传送到Java层的) 。我们需要 修改 input 中的代码 将 Native 的 MotionEvent 传送到<br />Java 层。具体做法实在 InputDispatch.h 中 添加 接口 </span><br style=\"font-family: 微软雅黑, Tahoma; font-size: 14px; line-height: normal;\"><span class=\"pun\" style=\"font-family: 微软雅黑, Tahoma; font-size: 14px; line-height: normal;\"><span class=\"kwd\">virtual</span><span class=\"pln\"> </span><span class=\"kwd\">void</span><span class=\"pln\"> interceptMotionBeforeQueueing</span><span class=\"pun\">(</span><span class=\"kwd\">const</span><span class=\"pln\"> </span><span class=\"typ\">MotionEvent</span><span class=\"pun\">*</span><span class=\"pln\"> motionEvent</span><span class=\"pun\">,</span><span class=\"typ\">nsecs_t</span><span class=\"pln\"> </span><span class=\"kwd\">when</span><span class=\"pun\">,</span><span class=\"pln\"> </span><span class=\"typ\">uint32_t</span><span class=\"pun\">&</span><span class=\"pln\"> policyFlags</span><span class=\"pun\">)</span><span class=\"pln\"> </span><span class=\"pun\">=</span><span class=\"pln\"> </span><span class=\"lit\">0</span><span class=\"pun\">;<br />以及 在 触摸事件分发的过程中 将这个 native 的对象 传送到 Java 层进行处理。<br /></span><font size=\"+1\">2</font></span><font size=\"+1\" style=\"font-family: 微软雅黑, Tahoma; line-height: normal;\">.java层,处理 native 层传送过来的MotionEvent对象<br /> 在 WindowManagerPolicy(android.view.WindowManagerPolicy) 中添加接口</font><br style=\"font-family: 微软雅黑, Tahoma; font-size: 14px; line-height: normal;\"><span class=\"kwd\" style=\"font-family: 微软雅黑, Tahoma; font-size: 14px; line-height: normal;\"> public</span><span class=\"pln\" style=\"font-family: 微软雅黑, Tahoma; font-size: 14px; line-height: normal;\"> </span><span class=\"kwd\" style=\"font-family: 微软雅黑, Tahoma; font-size: 14px; line-height: normal;\">int</span><span class=\"pln\" style=\"font-family: 微软雅黑, Tahoma; font-size: 14px; line-height: normal;\"> interceptMotionBeforeQueueing</span><span class=\"pun\" style=\"font-family: 微软雅黑, Tahoma; font-size: 14px; line-height: normal;\">(</span><span class=\"typ\" style=\"font-family: 微软雅黑, Tahoma; font-size: 14px; line-height: normal;\">MotionEvent</span><span class=\"pln\" style=\"font-family: 微软雅黑, Tahoma; font-size: 14px; line-height: normal;\"> event</span><span class=\"pun\" style=\"font-family: 微软雅黑, Tahoma; font-size: 14px; line-height: normal;\">,</span><span class=\"pln\" style=\"font-family: 微软雅黑, Tahoma; font-size: 14px; line-height: normal;\"> </span><span class=\"kwd\" style=\"font-family: 微软雅黑, Tahoma; font-size: 14px; line-height: normal;\">int</span><span class=\"pln\" style=\"font-family: 微软雅黑, Tahoma; font-size: 14px; line-height: normal;\"> policyFlags</span><span class=\"pun\" style=\"font-family: 微软雅黑, Tahoma; font-size: 14px; line-height: normal;\">,</span><span class=\"pln\" style=\"font-family: 微软雅黑, Tahoma; font-size: 14px; line-height: normal;\"> </span><span class=\"kwd\" style=\"font-family: 微软雅黑, Tahoma; font-size: 14px; line-height: normal;\">boolean</span><span class=\"pln\" style=\"font-family: 微软雅黑, Tahoma; font-size: 14px; line-height: normal;\"> isScreenOn</span><span class=\"pun\" style=\"font-family: 微软雅黑, Tahoma; font-size: 14px; line-height: normal;\">)<br /> 所有 与 </span><font size=\"+1\" style=\"font-family: 微软雅黑, Tahoma; line-height: normal;\">WindowManagerPolicy 相关的 类 如 InputManagerService.java,InputMonitor.java,PhoneWindowManager 都要实现这个接口。<br /> 我们可以在 PhoneWindowManager 或者 LewaPhoneWindowManager 中实现上述接口,在触摸事件分发到应用窗口之前进行处理。<br />具体代码的修改 </font></p><p><font size=\"+1\" style=\"font-family: 微软雅黑, Tahoma; line-height: normal;\">请查看gerrit 提交记录(mtk6592_kitkat)<a class=\"moz-txt-link-freetext\" href=\"http://review.lewatek.com/gerrit/#/c/58686/\" style=\"text-decoration: none !important;\">http://review.lewatek.com/gerrit/#/c/58686/</a><br /><br /></font></p>','Rom_舜',7,1416208889,1416208889,'Rom_舜',7,5,0,0,0,0,1,0),
(26,0,'','4.4刷机脚本变化','','4.4 update-binary 学要在 customize_target_files.sh 中加入 cp -f other/updater out/target_files/OTA/bin/ oth','<p>4.4 update-binary 学要在 customize_target_files.sh 中加入 cp -f other/updater out/target_files/OTA/bin/ other 中的 updater 由底包中考出。二 updater-script 为 make fullota的过程中生成, 而后的set_metadata 相关函数可以通过 脚本最后的写入添加进去来确保 编译出的包可以刷机<br /> <br /></p>','玛法里奥',8,1416210203,1416211999,'玛法里奥',8,21,1,1,1,0,1,0),
(28,0,'','Wiki1111','','','','theme',3,1416210899,1416210899,'theme',3,20,0,0,0,1,1,0),
(29,0,'a','android sensor 架构','','1、Android sensor架构Android4.0系统内置对传感器的支持达13种,它们分别是:加速度传感器(accelerometer)、磁力\r\n传感器(magnetic \r\nfield)、方向传','<p class=\"grey\"><strong>1、Android sensor架构</strong></p><p class=\"grey\">Android4.0系统内置对传感器的支持达13种,它们分别是:加速度传感器(accelerometer)、磁力\r\n传感器(magnetic \r\nfield)、方向传感器(orientation)、陀螺仪(gyroscope)、环境光照传感器(light)、压力传感器(pressure)、\r\n温度传感器(temperature)和距离传感器(proximity)等。</p><p class=\"grey\">Android实现传感器系统包括以下几个部分:</p><p align=\"center\"><img src=\"http://www.embedu.org/Column/images/Column605-1.jpg\" alt=\"\" height=\"300\" width=\"561\" /></p><p class=\"grey\" align=\"center\">各部分之间架构图如下:<br /><img src=\"http://www.embedu.org/Column/images/Column605-2.jpg\" alt=\"\" height=\"370\" width=\"580\" /></p><p class=\"grey\"><strong>2、Sensor HAL层接口</strong></p><p class=\"grey\">Google为Sensor提供了统一的HAL接口,不同的硬件厂商需要根据该接口来实现并完成具体的硬件抽象层,Android中Sensor的HAL接口定义在:hardware/libhardware/include/hardware/sensors.h</p><p class=\"grey\">对传感器类型的定义:</p><p align=\"center\"><img src=\"http://www.embedu.org/Column/images/Column605-3.jpg\" alt=\"\" height=\"240\" width=\"477\" /></p><p class=\"grey\">传感器模块的定义结构体如下:</p><p align=\"center\"><img src=\"http://www.embedu.org/Column/images/Column605-4.jpg\" alt=\"\" height=\"141\" width=\"580\" /></p><p class=\"grey\">该接口的定义实际上是对标准的硬件模块hw_module_t的一个扩展,增加了一个get_sensors_list函数,用于获取传感器的列表。</p><p class=\"grey\">对任意一个sensor设备都会有一个sensor_t结构体,其定义如下:</p><p align=\"center\"><img src=\"http://www.embedu.org/Column/images/Column605-5.jpg\" alt=\"\" height=\"416\" width=\"580\" /></p><p class=\"grey\">每个传感器的数据由sensors_event_t结构体表示,定义如下:</p><p align=\"center\"><img src=\"http://www.embedu.org/Column/images/Column605-6.jpg\" alt=\"\" height=\"497\" width=\"580\" /></p><p class=\"grey\">其中,sensor为传感器的标志符,而不同的传感器则采用union方式来表示,sensors_vec_t结构体用来表示不同传感器的数据,sensors_vec_t定义如下:</p><p align=\"center\"><img src=\"http://www.embedu.org/Column/images/Column605-7.jpg\" alt=\"\" height=\"241\" width=\"412\" /></p><p class=\"grey\">Sensor设备结构体sensors_poll_device_t,对标准硬件设备hw_device_t结构体的扩\r\n展,主要完成读取底层数据,并将数据存储在struct \r\nsensors_poll_device_t结构体中,poll函数用来获取底层数据,调用时将被阻塞定义如下:</p><p align=\"center\"><img src=\"http://www.embedu.org/Column/images/Column605-8.jpg\" alt=\"\" height=\"206\" width=\"580\" /></p><p class=\"grey\">控制设备打开/关闭结构体定义如下:</p><p align=\"center\"><img src=\"http://www.embedu.org/Column/images/Column605-9.jpg\" alt=\"\" height=\"136\" width=\"580\" /></p><p class=\"grey\"><strong>3、Sensor HAL实现(以LM75温度传感器为例子)</strong></p><p class=\"grey\">(1)打开设备流程图</p><p align=\"center\"><img src=\"http://www.embedu.org/Column/images/Column605-10.jpg\" alt=\"\" height=\"694\" width=\"653\" /></p><p class=\"grey\">(2)实现代码分析</p><p class=\"grey\">在代码中含有两个传感器ADC电位器和LM75温度传感器,所以在sensor.c中,首先需要定义传感器数组device_sensor_list[],其实就是初始化struct sensor_t结构体,初始化如下:</p><p align=\"center\"><img src=\"http://www.embedu.org/Column/images/Column605-11.jpg\" alt=\"\" height=\"400\" width=\"580\" /></p><p class=\"grey\">定义open_sensors函数,来打开Sensor模块,代码如下:</p><p align=\"center\"><img src=\"http://www.embedu.org/Column/images/Column605-12.jpg\" alt=\"\" height=\"338\" width=\"591\" /></p><p class=\"grey\">在这个方法中,首先需要为hw_device_t分配内存空间,并对其初始化,设置重要方法的实现。</p><p class=\"grey\">control_open_data_source()打开传感器并使能设备:</p><p align=\"center\"><img src=\"http://www.embedu.org/Column/images/Column605-13.jpg\" alt=\"\" height=\"254\" width=\"615\" /></p><p class=\"grey\">调用sensor__data_poll方法读取数据:</p>\r\n/*轮询读取数据*/<br />\r\n static int sensors__data_poll(struct sensors_data_context_t *dev, sensors_data_t * values)<br />\r\n {<br />\r\n int n;<br />\r\n int mag;<br />\r\n float temp;<br />\r\n char buf[10];<br />\r\n while (1) {<br />\r\n if(count % 3 == 2) // 读取ADC值<br />\r\n {<br />\r\n if( read(dev->event_fd[0], &mag, sizeof(mag)) < 0)<br />\r\n {<br />\r\n LOGE(\"read adc error\");<br />\r\n }else{ <br />\r\n dev->sensors[ID_MAGNETIC_FIELD].magnetic.v[0] =(float)mag; <br />\r\n LOGE(\"read adc %f\\n\",(float)mag);<br />\r\n *values = dev->sensors[ID_MAGNETIC_FIELD];<br />\r\n values->sensor = ID_MAGNETIC_FIELD;<br />\r\n count++;<br />\r\n }<br />\r\n usleep(500000);<br />\r\n return ID_MAGNETIC_FIELD;<br />\r\n }<br />\r\n else if(count%3 == 1) //读取温度传感器值<br />\r\n {<br />\r\n memset(buf, 0 ,sizeof(buf));<br />\r\n if((n = read(dev->event_fd[1], buf, 10)) < 0)<br />\r\n {<br />\r\n LOGE(\"read temp error\");<br />\r\n }else{<br />\r\n buf[n - 1] = \'\\0\';<br />\r\n temp =(float) (atoi(buf) / 1000);<br />\r\n dev->sensors[ID_TEMPERATURE].temperature = temp;<br />\r\n LOGE(\"read temp %f\\n\",temp);<br />\r\n *values = dev->sensors[ID_TEMPERATURE];<br />\r\n values->sensor = ID_TEMPERATURE;<br />\r\n count++;<br />\r\n }<br />\r\n close(dev->event_fd[1]);<br />\r\n dev->event_fd[1]= open(\"/sys/bus/i2c/devices/0-0048/temp1_input\", O_RDONLY);<br />\r\n usleep(500000);<br />\r\n return ID_TEMPERATURE;<br />\r\n }<br />\r\n else if(count%3 == 0) //读取方向传感器模拟值<br />\r\n {<br />\r\n LOGI(\"read orientation\\n\");<br />\r\n /* fill up data of orientation */<br />\r\n dev->sensors[ID_ORIENTATION].orientation.azimuth = x + 5;<br />\r\n dev->sensors[ID_ORIENTATION].orientation.pitch = y + 5;<br />\r\n dev->sensors[ID_ORIENTATION].orientation.roll = z + 5;<br />\r\n *values = dev->sensors[ID_ORIENTATION];<br />\r\n values->sensor = ID_ORIENTATION;<br />\r\n count++;<br />\r\n x += 0.0001; y += 0.0001; z += 0.0001;<br />\r\n usleep (500000);<br />\r\n return ID_ORIENTATION;<br />\r\n }<br />\r\n }<br />\r\n }','玛法里奥',8,1416213743,1416213743,'玛法里奥',8,23,0,0,0,1,1,0),
(31,0,'c','测试','','测试测试','<p>测试测试</p>','theme',3,1417073698,1417073698,'theme',3,4,0,0,0,0,1,0),
(33,0,'d','地方','ff','放放风','<p>放放风法规法规</p>','乾坤大挪移',19,1417075369,1417075422,'乾坤大挪移',19,3,1,1,0,0,1,0),
(34,0,'d','dfd','','tyhythyh','<p>tyhythyh <br /></p>','SJ伊诺',18,1417075542,1417075542,'SJ伊诺',18,2,0,0,0,0,1,0),
(35,0,'d','dd','','erfrrfdfgfrrg','<p>erfrrfdfgfrrg方刚刚噶<br /></p>','SJ伊诺',18,1417075630,1417075656,'乾坤大挪移',19,6,1,1,0,0,1,0),
(36,0,'s','sdfd','','dfdf','<p>dfdf<br /></p>','SJ伊诺',18,1417078631,1417078631,'SJ伊诺',18,8,0,0,0,0,1,0);
/*!40000 ALTER TABLE `wiki_doc` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table wiki_docfavorite
# ------------------------------------------------------------
DROP TABLE IF EXISTS `wiki_docfavorite`;
CREATE TABLE `wiki_docfavorite` (
`id` mediumint(8) NOT NULL AUTO_INCREMENT,
`uid` mediumint(8) NOT NULL,
`did` mediumint(8) NOT NULL,
PRIMARY KEY (`id`),
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
# Dump of table wiki_docreference
# ------------------------------------------------------------
DROP TABLE IF EXISTS `wiki_docreference`;
CREATE TABLE `wiki_docreference` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`did` int(11) NOT NULL DEFAULT '0',
`name` varchar(200) NOT NULL,
`url` varchar(200) NOT NULL,
PRIMARY KEY (`id`),
KEY `did` (`did`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
# Dump of table wiki_edition
# ------------------------------------------------------------
DROP TABLE IF EXISTS `wiki_edition`;
CREATE TABLE `wiki_edition` (
`eid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`cid` smallint(6) unsigned NOT NULL DEFAULT '0',
`did` mediumint(8) unsigned NOT NULL DEFAULT '0',
`author` varchar(15) NOT NULL DEFAULT '',
`authorid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`time` int(10) unsigned NOT NULL DEFAULT '0',
`ip` varchar(15) NOT NULL DEFAULT '',
`title` varchar(80) NOT NULL DEFAULT '',
`tag` varchar(250) NOT NULL,
`summary` varchar(250) NOT NULL,
`content` mediumtext NOT NULL,
`words` int(10) unsigned NOT NULL DEFAULT '0',
`images` int(10) unsigned NOT NULL DEFAULT '0',
`type` tinyint(1) NOT NULL DEFAULT '0',
`judge` tinyint(1) NOT NULL DEFAULT '0',
`excellent` tinyint(1) NOT NULL DEFAULT '0',
`big` tinyint(1) NOT NULL DEFAULT '0',
`reason` varchar(250) NOT NULL DEFAULT '',
`coins` int(10) NOT NULL DEFAULT '0',
PRIMARY KEY (`eid`),
KEY `cid` (`cid`),
KEY `authorid` (`authorid`),
KEY `time` (`time`),
KEY `did` (`did`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
LOCK TABLES `wiki_edition` WRITE;
/*!40000 ALTER TABLE `wiki_edition` DISABLE KEYS */;
INSERT INTO `wiki_edition` (`eid`, `cid`, `did`, `author`, `authorid`, `time`, `ip`, `title`, `tag`, `summary`, `content`, `words`, `images`, `type`, `judge`, `excellent`, `big`, `reason`, `coins`)
VALUES
(4,0,26,'玛法里奥',8,1416210203,'180.166.124.62','4.4刷机脚本变化','','','',0,0,1,0,0,0,'全文编辑',0),
(5,0,9,'imac',15,1416195837,'180.166.124.62','ART无法使用','','&nbsp; &nbsp; 为了保证Android4.4平台中 ART模式 的正常运行,在修改Framework 代码时,请注意两个地方:&nbsp; &nbsp; &nbsp;1. 类的static','<p> 为了保证Android4.4平台中 ART模式 的正常运行,在修改Framework 代码<span style=\"line-height: 1.5;\">时,请注意两个地方:</span></p><p> 1. 类的static {} 代码区域内 禁止调用 JNI 的方法</p><p> 2. 类的static 变量初始化时,禁止调用JNI的方法</p><p> SystemProperties.get(\"XX\", \"XX\");</p><p> native_XXX();</p><p><br /></p><p>如果art无法使用请确认是否存在如上所述的问题。</p>',366,0,1,0,0,0,'测试测试',0),
(3,0,21,'shenanan101',11,1416208157,'180.166.124.62','手机卡在第一第一屏','','','',0,0,1,0,0,0,'新增内容',0),
(6,0,33,'乾坤大挪移',19,1417075369,'180.166.124.62','地方','','放放风','<p>放放风</p>',10,0,1,0,0,0,'全文编辑,新增内容',0),
(7,0,30,'乾坤大挪移',19,1417067328,'180.166.124.62','&^','','dsgsgsgs','<p>edfsdfsf99440jgjjgjskdm fdgvs;gkjsre000--9-=0-0-0-0-mfkgjskmdg m jnadfjfm08903^**)_)_jgos##%^*)</p>',72,0,1,0,0,0,'全文编辑,修正错误',0),
(8,0,30,'乾坤大挪移',19,1417075454,'180.166.124.62','&^','','dsgsgsgs','<p>edfsdfsf99440jgjjgjskdm fdgvs;gkjsre000--9-=0-0-0-0-mfkgjskmdg m jnadfjfm08903^**)_)_jgos##%^*)反反复复</p>',80,0,1,0,0,0,'全文编辑',0),
(9,0,35,'乾坤大挪移',19,1417075630,'180.166.124.62','dd','','erfrrfdfgfrrg','<p>erfrrfdfgfrrg<br /></p>',17,0,1,0,0,0,'全文编辑',0),
(10,0,17,'SJ伊诺',18,1416207669,'180.166.124.62','基带问题','','bug:进入系统后发现基带丢失解决方法:找到system/bin/gsm0710muxdmd2 &nbsp;gsm0710muxd 和 vold文件(替换官方的即可)','<p><b>bug:进入系统后发现基带丢失</b></p><p><b><br /></b></p><p>解决方法:找到system/bin/gsm0710muxdmd2 gsm0710muxd 和 vold文件(替换官方的即可)</p>',124,0,1,0,0,0,'新增内容',0);
/*!40000 ALTER TABLE `wiki_edition` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table wiki_focus
# ------------------------------------------------------------
DROP TABLE IF EXISTS `wiki_focus`;
CREATE TABLE `wiki_focus` (
`did` mediumint(8) unsigned NOT NULL DEFAULT '0',
`title` varchar(80) NOT NULL DEFAULT '',
`tag` varchar(250) NOT NULL DEFAULT '',
`summary` varchar(250) NOT NULL DEFAULT '',
`image` varchar(255) NOT NULL DEFAULT '',
`time` int(10) unsigned NOT NULL DEFAULT '0',
`displayorder` tinyint(4) NOT NULL DEFAULT '0',
`type` tinyint(4) NOT NULL DEFAULT '1',
PRIMARY KEY (`did`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
LOCK TABLES `wiki_focus` WRITE;
/*!40000 ALTER TABLE `wiki_focus` DISABLE KEYS */;
INSERT INTO `wiki_focus` (`did`, `title`, `tag`, `summary`, `image`, `time`, `displayorder`, `type`)
VALUES
(15,'开机SystemUI出错(锁屏篇)','','很多人遇到了开机以后systemUI进程出错的问题。实际从Log中分析可以看出是由于锁屏的布局加载导致。因为4.4锁屏是跑在systemUI进程中的。后举一个锁屏报错的例子,Log见附件。解决方法就是解','uploads/201411/s_f_1416207024JDQkmTjU_s.png',1416384024,0,1),
(7,'提取包过程中签名报错的处理','','例如三星等包,非常的大,会导致签名报错而无法提交,遇到此类的情','',1416381594,0,2),
(11,'指南针无法使用','','一般遇到指南针无法使用基本都是由于sensor造成的问题。可以替换如下几个文件,基本就可以修复sensor的问题。system/bin/sensorservice system/bin/mse','',1416203711,0,1),
(13,'拼包掉基带问题','','','',1416203711,0,1),
(9,'ART无法使用','',' 为了保证Android4.4平台中','',1416206264,0,2),
(10,'官方framework.jar 过大 将部分内容从 framework 移到framework2 的情况','','例如三星机器, framework.jar 中有部分内容被移到','',1416206264,0,2),
(12,'patch 定制apk','','patch有部分应用需要使用官方,有部分需要使用乐蛙的,在脚本','',1416206264,0,2),
(6,'如何编译patch rom','','. build/envsetup.sh\r\n\r\nmkdir 机型名\r\n\r\ncd 机型名\r\n\r\nadb reboot recovery\r\n\r\n../tools/releasetools/ota_target','',1416384024,0,1),
(8,'patch T9无法使用','','确认一下是否已经使用乐蛙提供的libsqlite.so。如果没有使用adb push libsqlite.so system/lib。','',1416384038,0,3);
/*!40000 ALTER TABLE `wiki_focus` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table wiki_friendlink
# ------------------------------------------------------------
DROP TABLE IF EXISTS `wiki_friendlink`;
CREATE TABLE `wiki_friendlink` (
`id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`url` varchar(100) NOT NULL,
`logo` varchar(100) DEFAULT NULL,
`description` varchar(200) DEFAULT NULL,
`displayorder` tinyint(2) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
# Dump of table wiki_gift
# ------------------------------------------------------------
DROP TABLE IF EXISTS `wiki_gift`;
CREATE TABLE `wiki_gift` (
`id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(80) NOT NULL,
`description` varchar(250) NOT NULL,
`image` varchar(250) NOT NULL,
`credit` int(10) NOT NULL DEFAULT '0',
`time` int(11) NOT NULL,
`available` tinyint(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
# Dump of table wiki_giftlog
# ------------------------------------------------------------
DROP TABLE IF EXISTS `wiki_giftlog`;
CREATE TABLE `wiki_giftlog` (
`id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
`uid` int(6) unsigned NOT NULL,
`gid` smallint(6) NOT NULL,
`extra` text NOT NULL,
`time` int(11) NOT NULL,
`status` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
# Dump of table wiki_innerlinkcache
# ------------------------------------------------------------
DROP TABLE IF EXISTS `wiki_innerlinkcache`;
CREATE TABLE `wiki_innerlinkcache` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`did` int(11) NOT NULL,
`title` varchar(200) NOT NULL,
`titleid` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `did` (`did`),
KEY `title` (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
# Dump of table wiki_language
# ------------------------------------------------------------
DROP TABLE IF EXISTS `wiki_language`;
CREATE TABLE `wiki_language` (
`id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(20) NOT NULL DEFAULT '',
`available` tinyint(1) NOT NULL DEFAULT '1',
`path` varchar(100) NOT NULL,
`copyright` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
LOCK TABLES `wiki_language` WRITE;
/*!40000 ALTER TABLE `wiki_language` DISABLE KEYS */;
INSERT INTO `wiki_language` (`id`, `name`, `available`, `path`, `copyright`)
VALUES
(1,'简体中文',1,'zh','baike.com');
/*!40000 ALTER TABLE `wiki_language` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table wiki_lock
# ------------------------------------------------------------
DROP TABLE IF EXISTS `wiki_lock`;
CREATE TABLE `wiki_lock` (
`did` mediumint(8) unsigned NOT NULL DEFAULT '0',
`uid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`time` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`did`,`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
LOCK TABLES `wiki_lock` WRITE;
/*!40000 ALTER TABLE `wiki_lock` DISABLE KEYS */;
INSERT INTO `wiki_lock` (`did`, `uid`, `time`)
VALUES
(3,6,1415960086),
(2,1,1415344053),
(4,6,1415959852),
(1,6,1415960021),
(10,19,1417058632),
(14,10,1416206209),
(18,3,1416381325),
(21,7,1416209032),
(26,19,1417056838),
(28,3,1416210899),
(15,3,1416213507),
(29,19,1417067165),
(7,1,1416382185),
(8,19,1417059826),
(33,19,1417075559),
(31,19,1417075337),
(36,18,1417080953);
/*!40000 ALTER TABLE `wiki_lock` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table wiki_mailqueue
# ------------------------------------------------------------
DROP TABLE IF EXISTS `wiki_mailqueue`;
CREATE TABLE `wiki_mailqueue` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`touid` mediumint(8) NOT NULL DEFAULT '0',
`tomail` varchar(100) NOT NULL,
`frommail` varchar(100) NOT NULL,
`subject` varchar(255) NOT NULL,
`message` text NOT NULL,
`html` tinyint(1) NOT NULL DEFAULT '0',
`priority` tinyint(1) NOT NULL DEFAULT '1',
`time` int(10) unsigned NOT NULL,
`failures` tinyint(3) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
# Dump of table wiki_nav
# ------------------------------------------------------------
DROP TABLE IF EXISTS `wiki_nav`;
CREATE TABLE `wiki_nav` (
`id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
`name` char(15) NOT NULL,
`code` text NOT NULL,
`position` tinyint(1) DEFAULT NULL,
`time` int(10) NOT NULL,
`lastedit` int(10) NOT NULL,
`lasteditor` char(15) NOT NULL,
`lasteditorid` mediumint(8) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `AK_name` (`name`),
KEY `AK_lastedit` (`lastedit`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
# Dump of table wiki_navlink
# ------------------------------------------------------------
DROP TABLE IF EXISTS `wiki_navlink`;
CREATE TABLE `wiki_navlink` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`navid` varchar(15) DEFAULT NULL,
`did` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `navid` (`navid`,`did`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
# Dump of table wiki_navmodel
# ------------------------------------------------------------
DROP TABLE IF EXISTS `wiki_navmodel`;
CREATE TABLE `wiki_navmodel` (
`id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(15) NOT NULL,
`code` text NOT NULL,
`status` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
LOCK TABLES `wiki_navmodel` WRITE;
/*!40000 ALTER TABLE `wiki_navmodel` DISABLE KEYS */;
INSERT INTO `wiki_navmodel` (`id`, `name`, `code`, `status`)
VALUES
(1,'简语+链接集合','<p class=\"bor-ccc bg_g\">与“物质文化”相对,人类在社会历史实践过程中所创造的各种精神文化。本任务即盘点我国民间的舞蹈。</p><table class=\"table\"> <tr> <td> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E6%9C%9D%E9%98%B3%E6%B0%91%E9%97%B4%E7%A7%A7%E6%AD%8C\" target=\"_blank\" title=\"朝阳民间秧歌\"> 朝阳民间秧歌</a><br/> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%A4%A7%E6%A0%85%E6%A0%8F%E4%BA%94%E6%96%97%E6%96%8B%E9%AB%98%E8%B7%B7%E7%A7%A7%E6%AD%8C\" target=\"_blank\"title=\"大栅栏五斗斋高跷秧歌\"> 大栅栏五斗斋高跷秧歌</a><br/> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E4%BA%AC%E8%A5%BF%E5%A4%AA%E5%B9%B3%E9%BC%93\" target=\"_blank\" title=\"京西太平鼓\"> 京西太平鼓</a><br/> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E6%89%93%E9%94%A3%E9%95%B2\" target=\"_blank\" title=\"打锣镲\"> 打锣镲</a> <br/> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E6%9C%AC%E6%BA%AA%E7%A4%BE%E7%81%AB\" target=\"_blank\" title=\"本溪社火\"> 本溪社火</a><br/> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%82%A3%E6%97%8F%E7%99%BD%E8%B1%A1%E8%88%9E\" target=\"_blank\" title=\"傣族白象舞\"> 傣族白象舞</a><br/> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%AF%86%E4%BA%91%E8%9D%B4%E8%9D%B6%E4%BC%9A\" target=\"_blank\" title=\"密云蝴蝶会\"> 密云蝴蝶会</a><br/> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%BB%B6%E5%BA%86%E6%97%B1%E8%88%B9\" target=\"_blank\" title=\"延庆旱船\"> 延庆旱船</a><br/> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E9%80%9A%E5%B7%9E%E8%BF%90%E6%B2%B3%E9%BE%99%E7%81%AF\" target=\"_blank\" title=\"通州运河龙灯\"> 通州运河龙灯</a> <br/> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E6%9D%BF%E5%87%B3%E9%BE%99\" target=\"_blank\" title=\"板凳龙\"> 板凳龙</a> </td> <td> <p> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E9%87%91%E5%B7%9E%E9%BE%99%E8%88%9E\" target=\"_blank\" title=\"金州龙舞\"> 金州龙舞</a><br/> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E9%9D%92%E9%BE%99%E5%9C%AA%E6%A0%8F%E6%A3%92\" target=\"_blank\" title=\"青龙圪栏棒\"> 青龙圪栏棒</a><br/> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E7%9B%96%E5%B7%9E%E9%AB%98%E8%B7%B7%E7%A7%A7%E6%AD%8C\" target=\"_blank\" title=\"盖州高跷秧歌\"> 盖州高跷秧歌</a><br/> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E4%B8%8A%E5%8F%A3%E5%AD%90%E9%AB%98%E8%B7%B7%E7%A7%A7%E6%AD%8C\" target=\"_blank\" title=\"上口子高跷秧歌\"> 上口子高跷秧歌</a><br/> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%AE%89%E5%BA%B7%E5%B0%8F%E5%9C%BA%E5%AD%90\" target=\"_blank\" title=\"安康小场子\"> 安康小场子</a><br/> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E9%80%9A%E5%9F%8E%E6%8B%8D%E6%89%93\" target=\"_blank\" title=\"通城拍打\"> 通城拍打</a><br/> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E7%99%BD%E7%BA%B8%E5%9D%8A%E5%A4%AA%E7%8B%AE\" target=\"_blank\" title=\"白纸坊太狮\"> 白纸坊太狮</a><br/> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E4%B8%9C%E5%82%A8%E5%8F%8C%E9%BE%99%E4%BC%9A\" target=\"_blank\" title=\"东储双龙会\"> 东储双龙会</a><br/> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E6%92%B5%E8%8A%B1\" target=\"_blank\" title=\"撵花\"> 撵花</a><br/> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E6%98%93%E5%8E%BF%E6%91%86%E5%AD%97%E9%BE%99%E7%81%AF\" target=\"_blank\" title=\"易县摆字龙灯\"> 易县摆字龙灯</a></p> </td> <td> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E9%9E%91%E5%AD%90%E7%A7%A7%E6%AD%8C\" target=\"_blank\" title=\"鞑子秧歌\"> 鞑子秧歌</a><br/> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E8%B5%AB%E5%93%B2%E6%97%8F%E8%90%A8%E6%BB%A1%E8%88%9E\" target=\"_blank\" title=\"赫哲族萨满舞\"> 赫哲族萨满舞</a><br/> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E7%B1%B3%E7%B2%AE%E5%B1%AF%E9%AB%98%E8%B7%B7\" target=\"_blank\" title=\"米粮屯高跷\"> 米粮屯高跷</a><br/> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E7%81%AB%E7%BB%AB%E5%AD%90%E4%BC%9E%E8%88%9E\" target=\"_blank\" title=\"火绫子伞舞\"> 火绫子伞舞</a><br/> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%85%AB%E9%97%BD%E5%8D%83%E5%A7%BF%E8%88%9E\" target=\"_blank\" title=\"八闽千姿舞\"> 八闽千姿舞</a><br/> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%BE%B7%E5%AE%89%E6%BD%98%E5%85%AC%E6%88%8F\" target=\"_blank\" title=\"德安潘公戏\"> 德安潘公戏</a><br/> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E4%B9%8C%E6%8B%89%E6%BB%A1%E6%97%8F%E7%A7%A7%E6%AD%8C\" target=\"_blank\" title=\"乌拉满族秧歌\"> 乌拉满族秧歌</a><br/> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E6%98%8C%E5%B9%B3%E5%90%8E%E7%89%9B%E5%9D%8A%E6%9D%91%E8%8A%B1%E9%92%B9%E5%A4%A7%E9%BC%93\" target=\"_blank\" title=\"昌平后牛坊村花钹大鼓\"> 昌平后牛坊村花钹大鼓</a><br/> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E8%B5%9E%E7%9A%87%E9%93%81%E9%BE%99%E7%81%AF\" target=\"_blank\" title=\"赞皇铁龙灯\"> 赞皇铁龙灯</a> </td> <td> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E9%86%89%E9%BE%99%E8%88%9E\" target=\"_blank\" title=\"醉龙舞\">醉龙舞</a><br/> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E9%9A%86%E5%B0%A7%E6%8B%9B%E5%AD%90%E9%BC%93\" target=\"_blank\" title=\"隆尧招子鼓\"> 隆尧招子鼓</a> <br/> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E6%99%8B%E5%B7%9E%E5%AE%98%E4%BC%9E\" target=\"_blank\" title=\"晋州官伞\"> 晋州官伞</a><br/> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E9%A9%AC%E9%B9%BF%E8%88%9E\" target=\"_blank\" title=\"马鹿舞\"> 马鹿舞</a><br/> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E4%B8%B0%E5%AE%81%E8%9D%B4%E8%9D%B6%E8%88%9E\" target=\"_blank\" title=\"丰宁蝴蝶舞\"> 丰宁蝴蝶舞</a><br/> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%B4%87%E4%BB%81%E8%B7%B3%E5%85%AB%E4%BB%99\" target=\"_blank\" title=\"崇仁跳八仙\"> 崇仁跳八仙</a><br/> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E4%B8%89%E8%8A%82%E9%BE%99%C2%B7%E8%B7%B3%E9%BC%93\" target=\"_blank\" title=\"三节龙·跳鼓\"> 三节龙·跳鼓</a><br/> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E6%B5%B7%E6%B7%80%E6%89%91%E8%9D%B4%E8%9D%B6\" target=\"_blank\" title=\"海淀扑蝴蝶\"> 海淀扑蝴蝶</a><br/> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E8%B4%AF%E6%BA%AA%E6%9D%91%E5%9C%B0%E5%9B%B4%E5%AD%90\" target=\"_blank\" title=\"贯溪村地围子\"> 贯溪村地围子</a> </td> </tr></table>',1),
(2,'两列表格','<table class=\"table\"> <tr> <td class=\"w-70\">网络红人</td> <td>红人简介</td> </tr> <tr> <td><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E7%AB%A0%E6%B3%BD%E5%A4%A9\" target=\"_blank\" title=\"章泽天\">章泽天</a></td> <td>女,江苏南京人,南京外国语学校学生。2009年12月在网络走红,被网友称为奶茶美眉。2011年1月4日,清华大学证实,南外高三学生章泽天的确被清华大学认定为文科保送生。</td> </tr> <tr> <td><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%8D%96%E8%8F%9C%E5%93%A5\" target=\"_blank\" title=\"卖菜哥\">卖菜哥</a> </td> <td>寒冬时节,两名穿着厚棉服的小伙子在乌鲁木齐一个居民小区户外,出售仅比批发价高出几毛钱的各类蔬菜,所到之处往往人头攒动,被老百姓亲切地称为“卖菜哥”。 <br /> </td> </tr> <tr> <td><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E8%8B%8F%E7%B4%AB%E7%B4%AB\" target=\"_blank\" title=\"苏紫紫\"> 苏紫紫</a></td> <td>女,湖北省宜昌市人,中国人民大学艺术系二年级学生,也是一名人体模特。2010年12月,她在学校里办了个人体艺术私拍展,引发学校老师同学的议论,遭受白眼。</td> </tr> <tr> <td><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E6%8A%80%E6%9C%AF%E5%A5%B3\" target=\"_blank\" title=\"技术女\"> 技术女</a></td> <td>某技术女与一位名叫jack weppler 的男友分手之后,制作了N张男友的PS照片(主要是PS文字),然后上传到网上,并通过SEO,让Google 图片搜索jack weppler 之后会出现这些照片。</td> </tr> <tr> <td><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E6%B5%87%E6%B0%B4%E5%93%A5\" target=\"_blank\" title=\"浇水哥\">浇水哥</a></td> <td>情侣吵架纵火烧房,淡定"浇水哥"楼顶救火走红,上班后不久,“浇水哥”的照片被人发上了网,他淡定的动作和众网友搞笑的跟帖,一下子使他在单位“火”了。</td> </tr></table>',1),
(3,'免责声明','<P class=\"bor-ccc bg_g\">本站声明:该内容为网友协作,并不代表本站观点。由此产生的后果,于本站无关。</P>',1),
(4,'两列表格_有标题','<table class=\"table\"> <tr> <td class=\"bold\" colspan=\"2\"><strong>2010年年度十大网络红人</strong></td> </tr> <tr> <td class=\"w-70\">网络红人 </td> <td>红人简介</td> </tr> <tr> <td><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E7%AB%A0%E6%B3%BD%E5%A4%A9\" target=\"_blank\" title=\"章泽天\">章泽天</a></td> <td>女,江苏南京人,南京外国语学校学生。2009年12月在网络走红,被网友称为奶茶美眉。2011年1月4日,清华大学证实,南外高三学生章泽天的确被清华大学认定为文科保送生。</td> </tr> <tr> <td><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%8D%96%E8%8F%9C%E5%93%A5\" target=\"_blank\" title=\"卖菜哥\">卖菜哥</a> </td> <td>寒冬时节,两名穿着厚棉服的小伙子在乌鲁木齐一个居民小区户外,出售仅比批发价高出几毛钱的各类蔬菜,所到之处往往人头攒动,被老百姓亲切地称为“卖菜哥”。 </td> </tr> <tr> <td><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E8%8B%8F%E7%B4%AB%E7%B4%AB\" target=\"_blank\" title=\"苏紫紫\"> 苏紫紫</a></td> <td>女,湖北省宜昌市人,中国人民大学艺术系二年级学生,也是一名人体模特。2010年12月,她在学校里办了个人体艺术私拍展,引发学校老师同学的议论,遭受白眼。</td> </tr> <tr> <td><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E6%8A%80%E6%9C%AF%E5%A5%B3\" target=\"_blank\" title=\"技术女\"> 技术女</a></td> <td>某技术女与一位名叫jack weppler 的男友分手之后,制作了N张男友的PS照片(主要是PS文字),然后上传到网上,并通过SEO,让Google 图片搜索jack weppler 之后会出现这些照片。</td> </tr> <tr> <td><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E6%B5%87%E6%B0%B4%E5%93%A5\" target=\"_blank\" title=\"浇水哥\">浇水哥</a></td> <td>情侣吵架纵火烧房,淡定"浇水哥"楼顶救火走红,上班后不久,“浇水哥”的照片被人发上了网,他淡定的动作和众网友搞笑的跟帖,一下子使他在单位“火”了。</td> </tr></table>',1),
(5,'图文混排','<table class=\"table\" vertical-align=\"top\"> <tr> <td rowspan=\"2\"> <div class=\"img img_l\" style=\"WIDTH: 140px\"> <a href=\"style/default/zt.jpg\" target=\"_blank\" title=\"主题图片\"> <img alt=\"主题图片\" src=\"style/default/zt.jpg\" title=\"主题图片\"/></a><br /> <strong>主题图片</strong></div> </td> <td class=\"bold\">模块标题</td> </tr> <tr> <td class=\"p_a_m\"> <p> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E6%A8%A1%E5%9D%97%E6%A0%87%E9%A2%98\" target=\"_blank\" title=\"模块标题\"> 模块标题</a> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E6%A8%A1%E5%9D%97%E6%A0%87%E9%A2%98\" target=\"_blank\" title=\"模块标题\"> 模块标题</a> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E6%A8%A1%E5%9D%97%E6%A0%87%E9%A2%98\" target=\"_blank\" title=\"模块标题\"> 模块标题</a> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E6%A8%A1%E5%9D%97%E6%A0%87%E9%A2%98\" target=\"_blank\" title=\"模块标题\"> 模块标题</a> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\"> 内容词条</a> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\"> 内容词条</a> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\"> 内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E6%A8%A1%E5%9D%97%E6%A0%87%E9%A2%98\" target=\"_blank\" title=\"模块标题\">模块标题</a> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E6%A8%A1%E5%9D%97%E6%A0%87%E9%A2%98\" target=\"_blank\" title=\"模块标题\"> 模块标题</a> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E6%A8%A1%E5%9D%97%E6%A0%87%E9%A2%98\" target=\"_blank\" title=\"模块标题\"> 模块标题</a> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E6%A8%A1%E5%9D%97%E6%A0%87%E9%A2%98\" target=\"_blank\" title=\"模块标题\"> 模块标题</a> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\"> 内容词条</a> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\"> 内容词条</a> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\"> 内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E6%A8%A1%E5%9D%97%E6%A0%87%E9%A2%98\" target=\"_blank\" title=\"模块标题\">模块标题</a> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E6%A8%A1%E5%9D%97%E6%A0%87%E9%A2%98\" target=\"_blank\" title=\"模块标题\"> 模块标题</a> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E6%A8%A1%E5%9D%97%E6%A0%87%E9%A2%98\" target=\"_blank\" title=\"模块标题\"> 模块标题</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E6%A8%A1%E5%9D%97%E6%A0%87%E9%A2%98\" target=\"_blank\" title=\"模块标题\">模块标题</a> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E6%A8%A1%E5%9D%97%E6%A0%87%E9%A2%98\" target=\"_blank\" title=\"模块标题\"> 模块标题</a> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E6%A8%A1%E5%9D%97%E6%A0%87%E9%A2%98\" target=\"_blank\" title=\"模块标题\"> 模块标题</a> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E6%A8%A1%E5%9D%97%E6%A0%87%E9%A2%98\" target=\"_blank\" title=\"模块标题\"> 模块标题</a> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\"> 内容词条</a> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\"> 内容词条</a> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\"> 内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E6%A8%A1%E5%9D%97%E6%A0%87%E9%A2%98\" target=\"_blank\" title=\"模块标题\">模块标题</a> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E6%A8%A1%E5%9D%97%E6%A0%87%E9%A2%98\" target=\"_blank\" title=\"模块标题\"> 模块标题</a> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E6%A8%A1%E5%9D%97%E6%A0%87%E9%A2%98\" target=\"_blank\" title=\"模块标题\"> 模块标题</a> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E6%A8%A1%E5%9D%97%E6%A0%87%E9%A2%98\" target=\"_blank\" title=\"模块标题\"> 模块标题</a> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\"> 内容词条</a> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\"> 内容词条</a> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\"> 内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E5%86%85%E5%AE%B9%E8%AF%8D%E6%9D%A1\" target=\"_blank\" title=\"内容词条\">内容词条</a><a class=\"innerlink\" href=\"index.php?doc-innerlink-%E6%A8%A1%E5%9D%97%E6%A0%87%E9%A2%98\" target=\"_blank\" title=\"模块标题\">模块标题</a> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E6%A8%A1%E5%9D%97%E6%A0%87%E9%A2%98\" target=\"_blank\" title=\"模块标题\"> 模块标题</a> <a class=\"innerlink\" href=\"index.php?doc-innerlink-%E6%A8%A1%E5%9D%97%E6%A0%87%E9%A2%98\" target=\"_blank\" title=\"模块标题\"> 模块标题</a> </p> </td> </tr></table>',1);
/*!40000 ALTER TABLE `wiki_navmodel` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table wiki_plugin
# ------------------------------------------------------------
DROP TABLE IF EXISTS `wiki_plugin`;
CREATE TABLE `wiki_plugin` (
`pluginid` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
`available` tinyint(1) NOT NULL DEFAULT '1',
`name` varchar(40) NOT NULL DEFAULT '',
`identifier` varchar(40) NOT NULL DEFAULT '',
`description` varchar(255) NOT NULL DEFAULT '',
`datatables` varchar(255) NOT NULL DEFAULT '',
`type` tinyint(1) NOT NULL DEFAULT '1',
`copyright` varchar(100) NOT NULL DEFAULT '',
`homepage` varchar(100) NOT NULL DEFAULT '',
`version` varchar(100) NOT NULL DEFAULT 'v1.0',
`suit` varchar(100) NOT NULL DEFAULT '',
`modules` text,
PRIMARY KEY (`pluginid`),
UNIQUE KEY `identifier` (`identifier`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
# Dump of table wiki_pluginhook
# ------------------------------------------------------------
DROP TABLE IF EXISTS `wiki_pluginhook`;
CREATE TABLE `wiki_pluginhook` (
`pluginhookid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`pluginid` smallint(6) unsigned NOT NULL DEFAULT '0',
`available` tinyint(1) NOT NULL DEFAULT '0',
`title` varchar(255) NOT NULL DEFAULT '',
`description` mediumtext NOT NULL,
`code` mediumtext NOT NULL,
PRIMARY KEY (`pluginhookid`),
KEY `pluginid` (`pluginid`),
KEY `available` (`available`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
# Dump of table wiki_pluginvar
# ------------------------------------------------------------
DROP TABLE IF EXISTS `wiki_pluginvar`;
CREATE TABLE `wiki_pluginvar` (
`pluginvarid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`pluginid` smallint(6) unsigned NOT NULL DEFAULT '0',
`displayorder` tinyint(3) NOT NULL DEFAULT '0',
`title` varchar(100) NOT NULL DEFAULT '',
`description` varchar(255) NOT NULL DEFAULT '',
`variable` varchar(40) NOT NULL DEFAULT '',
`type` varchar(20) NOT NULL DEFAULT 'text',
`value` text NOT NULL,
`extra` text NOT NULL,
PRIMARY KEY (`pluginvarid`),
KEY `pluginid` (`pluginid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
# Dump of table wiki_pms
# ------------------------------------------------------------
DROP TABLE IF EXISTS `wiki_pms`;
CREATE TABLE `wiki_pms` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`from` varchar(15) NOT NULL,
`fromid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`toid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`to` varchar(15) NOT NULL,
`drafts` tinyint(1) NOT NULL DEFAULT '0',
`new` tinyint(1) NOT NULL DEFAULT '0',
`subject` varchar(75) NOT NULL,
`message` text NOT NULL,
`time` int(10) unsigned NOT NULL DEFAULT '0',
`delstatus` tinyint(1) NOT NULL DEFAULT '0',
`og` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `toid` (`toid`,`drafts`,`time`),
KEY `fromid` (`fromid`,`drafts`,`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
LOCK TABLES `wiki_pms` WRITE;