-
Notifications
You must be signed in to change notification settings - Fork 2
/
phpcms_db.sql
6228 lines (6025 loc) · 557 KB
/
phpcms_db.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
/*
Navicat MySQL Data Transfer
Source Server : localhost
Source Server Version : 50553
Source Host : localhost:3306
Source Database : phpcms_db
Target Server Type : MYSQL
Target Server Version : 50553
File Encoding : 65001
Date: 2021-03-21 01:02:48
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for v9_admin
-- ----------------------------
DROP TABLE IF EXISTS `v9_admin`;
CREATE TABLE `v9_admin` (
`userid` mediumint(6) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(20) DEFAULT NULL,
`password` varchar(32) DEFAULT NULL,
`roleid` smallint(5) DEFAULT '0',
`encrypt` varchar(6) DEFAULT NULL,
`lastloginip` varchar(15) DEFAULT NULL,
`lastlogintime` int(10) unsigned DEFAULT '0',
`email` varchar(40) DEFAULT NULL,
`realname` varchar(50) NOT NULL DEFAULT '',
`card` varchar(255) NOT NULL,
`lang` varchar(6) NOT NULL,
PRIMARY KEY (`userid`),
KEY `username` (`username`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of v9_admin
-- ----------------------------
INSERT INTO `v9_admin` VALUES ('1', 'admin', '1fbc5f794fad2e23436ec74b827ea890', '1', 'DaINMc', '127.0.0.1', '1553100531', '1215551519@qq.com', '', '', '');
-- ----------------------------
-- Table structure for v9_admin_panel
-- ----------------------------
DROP TABLE IF EXISTS `v9_admin_panel`;
CREATE TABLE `v9_admin_panel` (
`menuid` mediumint(8) unsigned NOT NULL,
`userid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`name` char(32) DEFAULT NULL,
`url` char(255) DEFAULT NULL,
`datetime` int(10) unsigned DEFAULT '0',
UNIQUE KEY `userid` (`menuid`,`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of v9_admin_panel
-- ----------------------------
-- ----------------------------
-- Table structure for v9_admin_role
-- ----------------------------
DROP TABLE IF EXISTS `v9_admin_role`;
CREATE TABLE `v9_admin_role` (
`roleid` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
`rolename` varchar(50) NOT NULL,
`description` text NOT NULL,
`listorder` smallint(5) unsigned NOT NULL DEFAULT '0',
`disabled` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`roleid`),
KEY `listorder` (`listorder`),
KEY `disabled` (`disabled`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of v9_admin_role
-- ----------------------------
INSERT INTO `v9_admin_role` VALUES ('1', '超级管理员', '超级管理员', '0', '0');
INSERT INTO `v9_admin_role` VALUES ('2', '站点管理员', '站点管理员', '0', '0');
INSERT INTO `v9_admin_role` VALUES ('3', '运营总监', '运营总监', '1', '0');
INSERT INTO `v9_admin_role` VALUES ('4', '总编', '总编', '5', '0');
INSERT INTO `v9_admin_role` VALUES ('5', '编辑', '编辑', '1', '0');
INSERT INTO `v9_admin_role` VALUES ('7', '发布人员', '发布人员', '0', '0');
-- ----------------------------
-- Table structure for v9_admin_role_priv
-- ----------------------------
DROP TABLE IF EXISTS `v9_admin_role_priv`;
CREATE TABLE `v9_admin_role_priv` (
`roleid` tinyint(3) unsigned NOT NULL DEFAULT '0',
`m` char(20) NOT NULL,
`c` char(20) NOT NULL,
`a` char(20) NOT NULL,
`data` char(30) NOT NULL DEFAULT '',
`siteid` smallint(5) unsigned NOT NULL DEFAULT '0',
KEY `roleid` (`roleid`,`m`,`c`,`a`,`siteid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of v9_admin_role_priv
-- ----------------------------
-- ----------------------------
-- Table structure for v9_announce
-- ----------------------------
DROP TABLE IF EXISTS `v9_announce`;
CREATE TABLE `v9_announce` (
`aid` smallint(4) unsigned NOT NULL AUTO_INCREMENT,
`siteid` smallint(5) unsigned NOT NULL DEFAULT '0',
`title` char(80) NOT NULL,
`content` text NOT NULL,
`starttime` date NOT NULL DEFAULT '1000-01-01',
`endtime` date NOT NULL DEFAULT '1000-01-01',
`username` varchar(40) NOT NULL,
`addtime` int(10) unsigned NOT NULL DEFAULT '0',
`hits` smallint(5) unsigned NOT NULL DEFAULT '0',
`passed` tinyint(1) unsigned NOT NULL DEFAULT '0',
`style` char(15) NOT NULL,
`show_template` char(30) NOT NULL,
PRIMARY KEY (`aid`),
KEY `siteid` (`siteid`,`passed`,`endtime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of v9_announce
-- ----------------------------
-- ----------------------------
-- Table structure for v9_attachment
-- ----------------------------
DROP TABLE IF EXISTS `v9_attachment`;
CREATE TABLE `v9_attachment` (
`aid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`module` char(15) NOT NULL,
`catid` smallint(5) unsigned NOT NULL DEFAULT '0',
`filename` char(50) NOT NULL,
`filepath` char(200) NOT NULL,
`filesize` int(10) unsigned NOT NULL DEFAULT '0',
`fileext` char(10) NOT NULL,
`isimage` tinyint(1) unsigned NOT NULL DEFAULT '0',
`isthumb` tinyint(1) unsigned NOT NULL DEFAULT '0',
`downloads` mediumint(8) unsigned NOT NULL DEFAULT '0',
`userid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`uploadtime` int(10) unsigned NOT NULL DEFAULT '0',
`uploadip` char(15) NOT NULL,
`status` tinyint(1) NOT NULL DEFAULT '0',
`authcode` char(32) NOT NULL,
`siteid` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`aid`),
KEY `authcode` (`authcode`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of v9_attachment
-- ----------------------------
-- ----------------------------
-- Table structure for v9_attachment_index
-- ----------------------------
DROP TABLE IF EXISTS `v9_attachment_index`;
CREATE TABLE `v9_attachment_index` (
`keyid` char(30) NOT NULL,
`aid` char(10) NOT NULL,
KEY `keyid` (`keyid`),
KEY `aid` (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of v9_attachment_index
-- ----------------------------
-- ----------------------------
-- Table structure for v9_badword
-- ----------------------------
DROP TABLE IF EXISTS `v9_badword`;
CREATE TABLE `v9_badword` (
`badid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`badword` char(20) NOT NULL,
`level` tinyint(5) NOT NULL DEFAULT '1',
`replaceword` char(20) NOT NULL DEFAULT '0',
`lastusetime` int(10) unsigned NOT NULL DEFAULT '0',
`listorder` tinyint(3) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`badid`),
UNIQUE KEY `badword` (`badword`),
KEY `usetimes` (`replaceword`,`listorder`),
KEY `hits` (`listorder`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of v9_badword
-- ----------------------------
-- ----------------------------
-- Table structure for v9_block
-- ----------------------------
DROP TABLE IF EXISTS `v9_block`;
CREATE TABLE `v9_block` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`siteid` smallint(5) unsigned DEFAULT '0',
`name` char(50) DEFAULT NULL,
`pos` char(30) DEFAULT NULL,
`type` tinyint(1) DEFAULT '0',
`data` text,
`template` text,
PRIMARY KEY (`id`),
KEY `pos` (`pos`),
KEY `type` (`type`),
KEY `siteid` (`siteid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of v9_block
-- ----------------------------
-- ----------------------------
-- Table structure for v9_block_history
-- ----------------------------
DROP TABLE IF EXISTS `v9_block_history`;
CREATE TABLE `v9_block_history` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`blockid` int(10) unsigned DEFAULT '0',
`data` text,
`creat_at` int(10) unsigned DEFAULT '0',
`userid` mediumint(8) unsigned DEFAULT '0',
`username` char(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of v9_block_history
-- ----------------------------
-- ----------------------------
-- Table structure for v9_block_priv
-- ----------------------------
DROP TABLE IF EXISTS `v9_block_priv`;
CREATE TABLE `v9_block_priv` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`roleid` tinyint(3) unsigned DEFAULT '0',
`siteid` smallint(5) unsigned DEFAULT '0',
`blockid` int(10) unsigned DEFAULT '0',
PRIMARY KEY (`id`),
KEY `blockid` (`blockid`),
KEY `roleid` (`roleid`,`siteid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of v9_block_priv
-- ----------------------------
-- ----------------------------
-- Table structure for v9_cache
-- ----------------------------
DROP TABLE IF EXISTS `v9_cache`;
CREATE TABLE `v9_cache` (
`filename` char(50) NOT NULL,
`path` char(50) NOT NULL,
`data` mediumtext NOT NULL,
PRIMARY KEY (`filename`,`path`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of v9_cache
-- ----------------------------
INSERT INTO `v9_cache` VALUES ('mood_program.cache.php', 'caches_commons/caches_data/', '<?php\nreturn array (\n 1 => \n array (\n 1 => \n array (\n \'use\' => \'1\',\n \'name\' => \'震惊\',\n \'pic\' => \'mood/a1.gif\',\n ),\n 2 => \n array (\n \'use\' => \'1\',\n \'name\' => \'不解\',\n \'pic\' => \'mood/a2.gif\',\n ),\n 3 => \n array (\n \'use\' => \'1\',\n \'name\' => \'愤怒\',\n \'pic\' => \'mood/a3.gif\',\n ),\n 4 => \n array (\n \'use\' => \'1\',\n \'name\' => \'杯具\',\n \'pic\' => \'mood/a4.gif\',\n ),\n 5 => \n array (\n \'use\' => \'1\',\n \'name\' => \'无聊\',\n \'pic\' => \'mood/a5.gif\',\n ),\n 6 => \n array (\n \'use\' => \'1\',\n \'name\' => \'高兴\',\n \'pic\' => \'mood/a6.gif\',\n ),\n 7 => \n array (\n \'use\' => \'1\',\n \'name\' => \'支持\',\n \'pic\' => \'mood/a7.gif\',\n ),\n 8 => \n array (\n \'use\' => \'1\',\n \'name\' => \'超赞\',\n \'pic\' => \'mood/a8.gif\',\n ),\n 9 => \n array (\n \'use\' => NULL,\n \'name\' => \'\',\n \'pic\' => \'\',\n ),\n 10 => \n array (\n \'use\' => NULL,\n \'name\' => \'\',\n \'pic\' => \'\',\n ),\n ),\n);\n?>');
INSERT INTO `v9_cache` VALUES ('category_content.cache.php', 'caches_commons/caches_data/', '<?php\nreturn array (\n 1 => \'1\',\n 2 => \'1\',\n 3 => \'1\',\n 4 => \'1\',\n 5 => \'1\',\n);\n?>');
INSERT INTO `v9_cache` VALUES ('category_content_1.cache.php', 'caches_commons/caches_data/', '<?php\nreturn array (\n 1 => \n array (\n \'catid\' => \'1\',\n \'siteid\' => \'1\',\n \'type\' => \'1\',\n \'modelid\' => \'0\',\n \'parentid\' => \'0\',\n \'arrparentid\' => \'0\',\n \'child\' => \'1\',\n \'arrchildid\' => \'1,2,3,5,162\',\n \'catname\' => \'网站介绍\',\n \'style\' => \'\',\n \'image\' => \'\',\n \'description\' => \'\',\n \'parentdir\' => \'\',\n \'catdir\' => \'about\',\n \'url\' => \'/html/about/\',\n \'items\' => \'0\',\n \'hits\' => \'0\',\n \'setting\' => \'array (\n \\\'ishtml\\\' => \\\'1\\\',\n \\\'template_list\\\' => \\\'default\\\',\n \\\'page_template\\\' => \\\'page\\\',\n \\\'meta_title\\\' => \\\'\\\',\n \\\'meta_keywords\\\' => \\\'\\\',\n \\\'meta_description\\\' => \\\'\\\',\n \\\'category_ruleid\\\' => \\\'1\\\',\n \\\'show_ruleid\\\' => \\\'\\\',\n \\\'repeatchargedays\\\' => \\\'1\\\',\n)\',\n \'listorder\' => \'1\',\n \'ismenu\' => \'0\',\n \'sethtml\' => \'0\',\n \'letter\' => \'wangzhanjieshao\',\n \'usable_type\' => \'\',\n \'create_to_html_root\' => NULL,\n \'ishtml\' => \'1\',\n \'content_ishtml\' => NULL,\n \'category_ruleid\' => \'1\',\n \'show_ruleid\' => \'\',\n \'workflowid\' => NULL,\n \'isdomain\' => \'0\',\n ),\n 2 => \n array (\n \'catid\' => \'2\',\n \'siteid\' => \'1\',\n \'type\' => \'1\',\n \'modelid\' => \'0\',\n \'parentid\' => \'1\',\n \'arrparentid\' => \'0,1\',\n \'child\' => \'0\',\n \'arrchildid\' => \'2\',\n \'catname\' => \'关于我们\',\n \'style\' => \'\',\n \'image\' => \'\',\n \'description\' => \'\',\n \'parentdir\' => \'about/\',\n \'catdir\' => \'aboutus\',\n \'url\' => \'/html/about/aboutus/\',\n \'items\' => \'0\',\n \'hits\' => \'0\',\n \'setting\' => \'array (\n \\\'ishtml\\\' => \\\'1\\\',\n \\\'template_list\\\' => \\\'default\\\',\n \\\'page_template\\\' => \\\'page\\\',\n \\\'meta_title\\\' => \\\'关于我们\\\',\n \\\'meta_keywords\\\' => \\\'关于我们\\\',\n \\\'meta_description\\\' => \\\'关于我们\\\',\n \\\'category_ruleid\\\' => \\\'1\\\',\n \\\'show_ruleid\\\' => \\\'\\\',\n \\\'repeatchargedays\\\' => \\\'1\\\',\n)\',\n \'listorder\' => \'1\',\n \'ismenu\' => \'1\',\n \'sethtml\' => \'0\',\n \'letter\' => \'guanyuwomen\',\n \'usable_type\' => \'\',\n \'create_to_html_root\' => NULL,\n \'ishtml\' => \'1\',\n \'content_ishtml\' => NULL,\n \'category_ruleid\' => \'1\',\n \'show_ruleid\' => \'\',\n \'workflowid\' => NULL,\n \'isdomain\' => \'0\',\n ),\n 3 => \n array (\n \'catid\' => \'3\',\n \'siteid\' => \'1\',\n \'type\' => \'1\',\n \'modelid\' => \'0\',\n \'parentid\' => \'1\',\n \'arrparentid\' => \'0,1\',\n \'child\' => \'0\',\n \'arrchildid\' => \'3\',\n \'catname\' => \'联系方式\',\n \'style\' => \'\',\n \'image\' => \'\',\n \'description\' => \'\',\n \'parentdir\' => \'about/\',\n \'catdir\' => \'contactus\',\n \'url\' => \'/html/about/contactus/\',\n \'items\' => \'0\',\n \'hits\' => \'0\',\n \'setting\' => \'array (\n \\\'ishtml\\\' => \\\'1\\\',\n \\\'template_list\\\' => \\\'default\\\',\n \\\'page_template\\\' => \\\'page\\\',\n \\\'meta_title\\\' => \\\'联系方式\\\',\n \\\'meta_keywords\\\' => \\\'联系方式\\\',\n \\\'meta_description\\\' => \\\'联系方式\\\',\n \\\'category_ruleid\\\' => \\\'1\\\',\n \\\'show_ruleid\\\' => \\\'\\\',\n \\\'repeatchargedays\\\' => \\\'1\\\',\n)\',\n \'listorder\' => \'2\',\n \'ismenu\' => \'1\',\n \'sethtml\' => \'0\',\n \'letter\' => \'lianxifangshi\',\n \'usable_type\' => \'\',\n \'create_to_html_root\' => NULL,\n \'ishtml\' => \'1\',\n \'content_ishtml\' => NULL,\n \'category_ruleid\' => \'1\',\n \'show_ruleid\' => \'\',\n \'workflowid\' => NULL,\n \'isdomain\' => \'0\',\n ),\n 4 => \n array (\n \'catid\' => \'4\',\n \'siteid\' => \'1\',\n \'type\' => \'1\',\n \'modelid\' => \'0\',\n \'parentid\' => \'1\',\n \'arrparentid\' => \'0,1\',\n \'child\' => \'0\',\n \'arrchildid\' => \'4\',\n \'catname\' => \'版权声明\',\n \'style\' => \'\',\n \'image\' => \'\',\n \'description\' => \'\',\n \'parentdir\' => \'about/\',\n \'catdir\' => \'copyright\',\n \'url\' => \'http://test.phpcms.cn/index.php?m=content&c=index&a=lists&catid=4\',\n \'items\' => \'0\',\n \'hits\' => \'0\',\n \'setting\' => \'array (\n \\\'ishtml\\\' => \\\'0\\\',\n \\\'template_list\\\' => \\\'default\\\',\n \\\'page_template\\\' => \\\'page\\\',\n \\\'meta_title\\\' => \\\'版权声明\\\',\n \\\'meta_keywords\\\' => \\\'版权声明\\\',\n \\\'meta_description\\\' => \\\'版权声明\\\',\n \\\'category_ruleid\\\' => \\\'6\\\',\n \\\'show_ruleid\\\' => \\\'\\\',\n \\\'repeatchargedays\\\' => \\\'1\\\',\n)\',\n \'listorder\' => \'3\',\n \'ismenu\' => \'1\',\n \'sethtml\' => \'0\',\n \'letter\' => \'banquanshengming\',\n \'usable_type\' => \'\',\n \'create_to_html_root\' => NULL,\n \'ishtml\' => \'0\',\n \'content_ishtml\' => NULL,\n \'category_ruleid\' => \'6\',\n \'show_ruleid\' => \'\',\n \'workflowid\' => NULL,\n \'isdomain\' => \'0\',\n ),\n 5 => \n array (\n \'catid\' => \'5\',\n \'siteid\' => \'1\',\n \'type\' => \'1\',\n \'modelid\' => \'0\',\n \'parentid\' => \'1\',\n \'arrparentid\' => \'0,1\',\n \'child\' => \'0\',\n \'arrchildid\' => \'5\',\n \'catname\' => \'招聘信息\',\n \'style\' => \'\',\n \'image\' => \'\',\n \'description\' => \'\',\n \'parentdir\' => \'about/\',\n \'catdir\' => \'hr\',\n \'url\' => \'/html/about/hr/\',\n \'items\' => \'0\',\n \'hits\' => \'0\',\n \'setting\' => \'array (\n \\\'ishtml\\\' => \\\'1\\\',\n \\\'template_list\\\' => \\\'default\\\',\n \\\'page_template\\\' => \\\'page\\\',\n \\\'meta_title\\\' => \\\'\\\',\n \\\'meta_keywords\\\' => \\\'\\\',\n \\\'meta_description\\\' => \\\'\\\',\n \\\'category_ruleid\\\' => \\\'1\\\',\n \\\'show_ruleid\\\' => \\\'\\\',\n \\\'repeatchargedays\\\' => \\\'1\\\',\n)\',\n \'listorder\' => \'4\',\n \'ismenu\' => \'1\',\n \'sethtml\' => \'0\',\n \'letter\' => \'zhaopinxinxi\',\n \'usable_type\' => \'\',\n \'create_to_html_root\' => NULL,\n \'ishtml\' => \'1\',\n \'content_ishtml\' => NULL,\n \'category_ruleid\' => \'1\',\n \'show_ruleid\' => \'\',\n \'workflowid\' => NULL,\n \'isdomain\' => \'0\',\n ),\n);\n?>');
INSERT INTO `v9_cache` VALUES ('sitelist.cache.php', 'caches_commons/caches_data/', '<?php\nreturn array (\n 1 => \n array (\n \'siteid\' => \'1\',\n \'name\' => \'默认站点\',\n \'dirname\' => \'\',\n \'domain\' => \'http://phpcms.com/\',\n \'site_title\' => \'PHPCMS演示站\',\n \'keywords\' => \'PHPCMS演示站\',\n \'description\' => \'PHPCMS演示站\',\n \'release_point\' => \'\',\n \'default_style\' => \'default\',\n \'template\' => \'default\',\n \'setting\' => \'array (\n \\\'upload_maxsize\\\' => \\\'2048\\\',\n \\\'upload_allowext\\\' => \\\'jpg|jpeg|gif|bmp|png|doc|docx|xls|xlsx|ppt|pptx|pdf|txt|rar|zip|swf\\\',\n \\\'watermark_enable\\\' => \\\'1\\\',\n \\\'watermark_minwidth\\\' => \\\'300\\\',\n \\\'watermark_minheight\\\' => \\\'300\\\',\n \\\'watermark_img\\\' => \\\'/statics/images/water/mark.png\\\',\n \\\'watermark_pct\\\' => \\\'85\\\',\n \\\'watermark_quality\\\' => \\\'80\\\',\n \\\'watermark_pos\\\' => \\\'9\\\',\n)\',\n \'uuid\' => \'\',\n \'url\' => \'http://phpcms.com/\',\n ),\n);\n?>');
INSERT INTO `v9_cache` VALUES ('downservers.cache.php', 'caches_commons/caches_data/', '<?php\nreturn NULL;\n?>');
INSERT INTO `v9_cache` VALUES ('badword.cache.php', 'caches_commons/caches_data/', '<?php\nreturn array (\n);\n?>');
INSERT INTO `v9_cache` VALUES ('ipbanned.cache.php', 'caches_commons/caches_data/', '<?php\nreturn array (\n);\n?>');
INSERT INTO `v9_cache` VALUES ('keylink.cache.php', 'caches_commons/caches_data/', '<?php\nreturn array (\n);\n?>');
INSERT INTO `v9_cache` VALUES ('position.cache.php', 'caches_commons/caches_data/', '<?php\nreturn array (\n 2 => \n array (\n \'posid\' => \'2\',\n \'modelid\' => \'0\',\n \'catid\' => \'0\',\n \'name\' => \'首页头条推荐\',\n \'maxnum\' => \'20\',\n \'extention\' => NULL,\n \'listorder\' => \'4\',\n \'siteid\' => \'1\',\n \'thumb\' => \'\',\n ),\n 1 => \n array (\n \'posid\' => \'1\',\n \'modelid\' => \'0\',\n \'catid\' => \'0\',\n \'name\' => \'首页焦点图推荐\',\n \'maxnum\' => \'20\',\n \'extention\' => NULL,\n \'listorder\' => \'1\',\n \'siteid\' => \'1\',\n \'thumb\' => \'\',\n ),\n 16 => \n array (\n \'posid\' => \'16\',\n \'modelid\' => \'0\',\n \'catid\' => \'0\',\n \'name\' => \'视频首页每日热点\',\n \'maxnum\' => \'20\',\n \'extention\' => \'\',\n \'listorder\' => \'0\',\n \'siteid\' => \'1\',\n \'thumb\' => \'\',\n ),\n 15 => \n array (\n \'posid\' => \'15\',\n \'modelid\' => \'0\',\n \'catid\' => \'0\',\n \'name\' => \'视频首页头条推荐\',\n \'maxnum\' => \'20\',\n \'extention\' => \'\',\n \'listorder\' => \'0\',\n \'siteid\' => \'1\',\n \'thumb\' => \'\',\n ),\n 14 => \n array (\n \'posid\' => \'14\',\n \'modelid\' => \'0\',\n \'catid\' => \'0\',\n \'name\' => \'视频首页焦点图\',\n \'maxnum\' => \'20\',\n \'extention\' => \'\',\n \'listorder\' => \'0\',\n \'siteid\' => \'1\',\n \'thumb\' => \'\',\n ),\n 12 => \n array (\n \'posid\' => \'12\',\n \'modelid\' => \'0\',\n \'catid\' => \'0\',\n \'name\' => \'首页图片推荐\',\n \'maxnum\' => \'20\',\n \'extention\' => NULL,\n \'listorder\' => \'0\',\n \'siteid\' => \'1\',\n \'thumb\' => \'\',\n ),\n 10 => \n array (\n \'posid\' => \'10\',\n \'modelid\' => \'0\',\n \'catid\' => \'0\',\n \'name\' => \'栏目首页推荐\',\n \'maxnum\' => \'20\',\n \'extention\' => NULL,\n \'listorder\' => \'0\',\n \'siteid\' => \'1\',\n \'thumb\' => \'\',\n ),\n 9 => \n array (\n \'posid\' => \'9\',\n \'modelid\' => \'0\',\n \'catid\' => \'0\',\n \'name\' => \'网站顶部推荐\',\n \'maxnum\' => \'20\',\n \'extention\' => NULL,\n \'listorder\' => \'0\',\n \'siteid\' => \'1\',\n \'thumb\' => \'\',\n ),\n 8 => \n array (\n \'posid\' => \'8\',\n \'modelid\' => \'30\',\n \'catid\' => \'54\',\n \'name\' => \'图片频道首页焦点图\',\n \'maxnum\' => \'20\',\n \'extention\' => NULL,\n \'listorder\' => \'0\',\n \'siteid\' => \'1\',\n \'thumb\' => \'\',\n ),\n 5 => \n array (\n \'posid\' => \'5\',\n \'modelid\' => \'69\',\n \'catid\' => \'0\',\n \'name\' => \'推荐下载\',\n \'maxnum\' => \'20\',\n \'extention\' => NULL,\n \'listorder\' => \'0\',\n \'siteid\' => \'1\',\n \'thumb\' => \'\',\n ),\n 13 => \n array (\n \'posid\' => \'13\',\n \'modelid\' => \'82\',\n \'catid\' => \'0\',\n \'name\' => \'栏目页焦点图\',\n \'maxnum\' => \'20\',\n \'extention\' => NULL,\n \'listorder\' => \'0\',\n \'siteid\' => \'1\',\n \'thumb\' => \'\',\n ),\n 17 => \n array (\n \'posid\' => \'17\',\n \'modelid\' => \'0\',\n \'catid\' => \'0\',\n \'name\' => \'视频栏目精彩推荐\',\n \'maxnum\' => \'20\',\n \'extention\' => \'\',\n \'listorder\' => \'0\',\n \'siteid\' => \'1\',\n \'thumb\' => \'\',\n ),\n);\n?>');
INSERT INTO `v9_cache` VALUES ('role_siteid.cache.php', 'caches_commons/caches_data/', '<?php\nreturn array (\n);\n?>');
INSERT INTO `v9_cache` VALUES ('role.cache.php', 'caches_commons/caches_data/', '<?php\nreturn array (\n 1 => \'超级管理员\',\n 2 => \'站点管理员\',\n 3 => \'运营总监\',\n 4 => \'总编\',\n 5 => \'编辑\',\n 7 => \'发布人员\',\n);\n?>');
INSERT INTO `v9_cache` VALUES ('urlrules_detail.cache.php', 'caches_commons/caches_data/', '<?php\nreturn array (\n 1 => \n array (\n \'urlruleid\' => \'1\',\n \'module\' => \'content\',\n \'file\' => \'category\',\n \'ishtml\' => \'1\',\n \'urlrule\' => \'{$categorydir}{$catdir}/index.html|{$categorydir}{$catdir}/{$page}.html\',\n \'example\' => \'news/china/1000.html\',\n ),\n 6 => \n array (\n \'urlruleid\' => \'6\',\n \'module\' => \'content\',\n \'file\' => \'category\',\n \'ishtml\' => \'0\',\n \'urlrule\' => \'index.php?m=content&c=index&a=lists&catid={$catid}|index.php?m=content&c=index&a=lists&catid={$catid}&page={$page}\',\n \'example\' => \'index.php?m=content&c=index&a=lists&catid=1&page=1\',\n ),\n 11 => \n array (\n \'urlruleid\' => \'11\',\n \'module\' => \'content\',\n \'file\' => \'show\',\n \'ishtml\' => \'1\',\n \'urlrule\' => \'{$year}/{$catdir}_{$month}{$day}/{$id}.html|{$year}/{$catdir}_{$month}{$day}/{$id}_{$page}.html\',\n \'example\' => \'2010/catdir_0720/1_2.html\',\n ),\n 12 => \n array (\n \'urlruleid\' => \'12\',\n \'module\' => \'content\',\n \'file\' => \'show\',\n \'ishtml\' => \'1\',\n \'urlrule\' => \'{$categorydir}{$catdir}/{$year}/{$month}{$day}/{$id}.html|{$categorydir}{$catdir}/{$year}/{$month}{$day}/{$id}_{$page}.html\',\n \'example\' => \'it/product/2010/0720/1_2.html\',\n ),\n 16 => \n array (\n \'urlruleid\' => \'16\',\n \'module\' => \'content\',\n \'file\' => \'show\',\n \'ishtml\' => \'0\',\n \'urlrule\' => \'index.php?m=content&c=index&a=show&catid={$catid}&id={$id}|index.php?m=content&c=index&a=show&catid={$catid}&id={$id}&page={$page}\',\n \'example\' => \'index.php?m=content&c=index&a=show&catid=1&id=1\',\n ),\n 17 => \n array (\n \'urlruleid\' => \'17\',\n \'module\' => \'content\',\n \'file\' => \'show\',\n \'ishtml\' => \'0\',\n \'urlrule\' => \'show-{$catid}-{$id}-{$page}.html\',\n \'example\' => \'show-1-2-1.html\',\n ),\n 18 => \n array (\n \'urlruleid\' => \'18\',\n \'module\' => \'content\',\n \'file\' => \'show\',\n \'ishtml\' => \'0\',\n \'urlrule\' => \'content-{$catid}-{$id}-{$page}.html\',\n \'example\' => \'content-1-2-1.html\',\n ),\n 30 => \n array (\n \'urlruleid\' => \'30\',\n \'module\' => \'content\',\n \'file\' => \'category\',\n \'ishtml\' => \'0\',\n \'urlrule\' => \'list-{$catid}-{$page}.html\',\n \'example\' => \'list-1-1.html\',\n ),\n);\n?>');
INSERT INTO `v9_cache` VALUES ('urlrules.cache.php', 'caches_commons/caches_data/', '<?php\nreturn array (\n 1 => \'{$categorydir}{$catdir}/index.html|{$categorydir}{$catdir}/{$page}.html\',\n 6 => \'index.php?m=content&c=index&a=lists&catid={$catid}|index.php?m=content&c=index&a=lists&catid={$catid}&page={$page}\',\n 11 => \'{$year}/{$catdir}_{$month}{$day}/{$id}.html|{$year}/{$catdir}_{$month}{$day}/{$id}_{$page}.html\',\n 12 => \'{$categorydir}{$catdir}/{$year}/{$month}{$day}/{$id}.html|{$categorydir}{$catdir}/{$year}/{$month}{$day}/{$id}_{$page}.html\',\n 16 => \'index.php?m=content&c=index&a=show&catid={$catid}&id={$id}|index.php?m=content&c=index&a=show&catid={$catid}&id={$id}&page={$page}\',\n 17 => \'show-{$catid}-{$id}-{$page}.html\',\n 18 => \'content-{$catid}-{$id}-{$page}.html\',\n 30 => \'list-{$catid}-{$page}.html\',\n);\n?>');
INSERT INTO `v9_cache` VALUES ('modules.cache.php', 'caches_commons/caches_data/', '<?php\nreturn array (\n \'admin\' => \n array (\n \'module\' => \'admin\',\n \'name\' => \'admin\',\n \'url\' => \'\',\n \'iscore\' => \'1\',\n \'version\' => \'1.0\',\n \'description\' => \'\',\n \'setting\' => \'array (\n \\\'admin_email\\\' => \\\'phpcms@phpcms.cn\\\',\n \\\'adminaccessip\\\' => \\\'0\\\',\n \\\'maxloginfailedtimes\\\' => \\\'8\\\',\n \\\'maxiplockedtime\\\' => \\\'15\\\',\n \\\'minrefreshtime\\\' => \\\'2\\\',\n \\\'mail_type\\\' => \\\'1\\\',\n \\\'mail_server\\\' => \\\'smtp.qq.com\\\',\n \\\'mail_port\\\' => \\\'25\\\',\n \\\'mail_user\\\' => \\\'phpcms.cn@foxmail.com\\\',\n \\\'mail_auth\\\' => \\\'1\\\',\n \\\'mail_from\\\' => \\\'phpcms.cn@foxmail.com\\\',\n \\\'mail_password\\\' => \\\'\\\',\n \\\'errorlog_size\\\' => \\\'20\\\',\n)\',\n \'listorder\' => \'0\',\n \'disabled\' => \'0\',\n \'installdate\' => \'2010-10-18\',\n \'updatedate\' => \'2010-10-18\',\n ),\n \'member\' => \n array (\n \'module\' => \'member\',\n \'name\' => \'会员\',\n \'url\' => \'\',\n \'iscore\' => \'1\',\n \'version\' => \'1.0\',\n \'description\' => \'\',\n \'setting\' => \'array (\n \\\'allowregister\\\' => \\\'1\\\',\n \\\'choosemodel\\\' => \\\'1\\\',\n \\\'enablemailcheck\\\' => \\\'0\\\',\n \\\'registerverify\\\' => \\\'0\\\',\n \\\'showapppoint\\\' => \\\'0\\\',\n \\\'rmb_point_rate\\\' => \\\'10\\\',\n \\\'defualtpoint\\\' => \\\'0\\\',\n \\\'defualtamount\\\' => \\\'0\\\',\n \\\'showregprotocol\\\' => \\\'0\\\',\n \\\'regprotocol\\\' => \\\' 欢迎您注册成为phpcms用户\r\n请仔细阅读下面的协议，只有接受协议才能继续进行注册。 \r\n1．服务条款的确认和接纳\r\n phpcms用户服务的所有权和运作权归phpcms拥有。phpcms所提供的服务将按照有关章程、服务条款和操作规则严格执行。用户通过注册程序点击“我同意” 按钮，即表示用户与phpcms达成协议并接受所有的服务条款。\r\n2． phpcms服务简介\r\n phpcms通过国际互联网为用户提供新闻及文章浏览、图片浏览、软件下载、网上留言和BBS论坛等服务。\r\n 用户必须： \r\n 1)购置设备，包括个人电脑一台、调制解调器一个及配备上网装置。 \r\n 2)个人上网和支付与此服务有关的电话费用、网络费用。\r\n 用户同意： \r\n 1)提供及时、详尽及准确的个人资料。 \r\n 2)不断更新注册资料，符合及时、详尽、准确的要求。所有原始键入的资料将引用为注册资料。 \r\n 3)用户同意遵守《中华人民共和国保守国家秘密法》、《中华人民共和国计算机信息系统安全保护条例》、《计算机软件保护条例》等有关计算机及互联网规定的法律和法规、实施办法。在任何情况下，phpcms合理地认为用户的行为可能违反上述法律、法规，phpcms可以在任何时候，不经事先通知终止向该用户提供服务。用户应了解国际互联网的无国界性，应特别注意遵守当地所有有关的法律和法规。\r\n3． 服务条款的修改\r\n phpcms会不定时地修改服务条款，服务条款一旦发生变动，将会在相关页面上提示修改内容。如果您同意改动，则再一次点击“我同意”按钮。 如果您不接受，则及时取消您的用户使用服务资格。\r\n4． 服务修订\r\n phpcms保留随时修改或中断服务而不需知照用户的权利。phpcms行使修改或中断服务的权利，不需对用户或第三方负责。\r\n5． 用户隐私制度\r\n 尊重用户个人隐私是phpcms的 基本政策。phpcms不会公开、编辑或透露用户的注册信息，除非有法律许可要求，或phpcms在诚信的基础上认为透露这些信息在以下三种情况是必要的： \r\n 1)遵守有关法律规定，遵从合法服务程序。 \r\n 2)保持维护phpcms的商标所有权。 \r\n 3)在紧急情况下竭力维护用户个人和社会大众的隐私安全。 \r\n 4)符合其他相关的要求。 \r\n6．用户的帐号，密码和安全性\r\n 一旦注册成功成为phpcms用户，您将得到一个密码和帐号。如果您不保管好自己的帐号和密码安全，将对因此产生的后果负全部责任。另外，每个用户都要对其帐户中的所有活动和事件负全责。您可随时根据指示改变您的密码，也可以结束旧的帐户重开一个新帐户。用户同意若发现任何非法使用用户帐号或安全漏洞的情况，立即通知phpcms。\r\n7． 免责条款\r\n 用户明确同意网站服务的使用由用户个人承担风险。 \r\n phpcms不作任何类型的担保，不担保服务一定能满足用户的要求，也不担保服务不会受中断，对服务的及时性，安全性，出错发生都不作担保。用户理解并接受：任何通过phpcms服务取得的信息资料的可靠性取决于用户自己，用户自己承担所有风险和责任。 \r\n8．有限责任\r\n phpcms对任何直接、间接、偶然、特殊及继起的损害不负责任。\r\n9． 不提供零售和商业性服务 \r\n 用户使用网站服务的权利是个人的。用户只能是一个单独的个体而不能是一个公司或实体商业性组织。用户承诺不经phpcms同意，不能利用网站服务进行销售或其他商业用途。\r\n10．用户责任 \r\n 用户单独承担传输内容的责任。用户必须遵循： \r\n 1)从中国境内向外传输技术性资料时必须符合中国有关法规。 \r\n 2)使用网站服务不作非法用途。 \r\n 3)不干扰或混乱网络服务。 \r\n 4)不在论坛BBS或留言簿发表任何与政治相关的信息。 \r\n 5)遵守所有使用网站服务的网络协议、规定、程序和惯例。\r\n 6)不得利用本站危害国家安全、泄露国家秘密，不得侵犯国家社会集体的和公民的合法权益。\r\n 7)不得利用本站制作、复制和传播下列信息： \r\n 1、煽动抗拒、破坏宪法和法律、行政法规实施的；\r\n 2、煽动颠覆国家政权，推翻社会主义制度的；\r\n 3、煽动分裂国家、破坏国家统一的；\r\n 4、煽动民族仇恨、民族歧视，破坏民族团结的；\r\n 5、捏造或者歪曲事实，散布谣言，扰乱社会秩序的；\r\n 6、宣扬封建迷信、淫秽、色情、赌博、暴力、凶杀、恐怖、教唆犯罪的；\r\n 7、公然侮辱他人或者捏造事实诽谤他人的，或者进行其他恶意攻击的；\r\n 8、损害国家机关信誉的；\r\n 9、其他违反宪法和法律行政法规的；\r\n 10、进行商业广告行为的。\r\n 用户不能传输任何教唆他人构成犯罪行为的资料；不能传输长国内不利条件和涉及国家安全的资料；不能传输任何不符合当地法规、国家法律和国际法 律的资料。未经许可而非法进入其它电脑系统是禁止的。若用户的行为不符合以上的条款，phpcms将取消用户服务帐号。\r\n11．网站内容的所有权\r\n phpcms定义的内容包括：文字、软件、声音、相片、录象、图表；在广告中全部内容；电子邮件的全部内容；phpcms为用户提供的商业信息。所有这些内容受版权、商标、标签和其它财产所有权法律的保护。所以，用户只能在phpcms和广告商授权下才能使用这些内容，而不能擅自复制、篡改这些内容、或创造与内容有关的派生产品。\r\n12．附加信息服务\r\n 用户在享用phpcms提供的免费服务的同时，同意接受phpcms提供的各类附加信息服务。\r\n13．解释权\r\n 本注册协议的解释权归phpcms所有。如果其中有任何条款与国家的有关法律相抵触，则以国家法律的明文规定为准。 \\\',\n \\\'registerverifymessage\\\' => \\\' 欢迎您注册成为phpcms用户，您的账号需要邮箱认证，点击下面链接进行认证：{click}\r\n或者将网址复制到浏览器：{url}\\\',\n \\\'forgetpassword\\\' => \\\' phpcms密码找回，请在一小时内点击下面链接进行操作：{click}\r\n或者将网址复制到浏览器：{url}\\\',\n)\',\n \'listorder\' => \'0\',\n \'disabled\' => \'0\',\n \'installdate\' => \'2010-09-06\',\n \'updatedate\' => \'2010-09-06\',\n ),\n \'pay\' => \n array (\n \'module\' => \'pay\',\n \'name\' => \'支付\',\n \'url\' => \'\',\n \'iscore\' => \'1\',\n \'version\' => \'1.0\',\n \'description\' => \'\',\n \'setting\' => \'\',\n \'listorder\' => \'0\',\n \'disabled\' => \'0\',\n \'installdate\' => \'2010-09-06\',\n \'updatedate\' => \'2010-09-06\',\n ),\n \'digg\' => \n array (\n \'module\' => \'digg\',\n \'name\' => \'顶一下\',\n \'url\' => \'\',\n \'iscore\' => \'0\',\n \'version\' => \'1.0\',\n \'description\' => \'\',\n \'setting\' => \'\',\n \'listorder\' => \'0\',\n \'disabled\' => \'0\',\n \'installdate\' => \'2010-09-06\',\n \'updatedate\' => \'2010-09-06\',\n ),\n \'special\' => \n array (\n \'module\' => \'special\',\n \'name\' => \'专题\',\n \'url\' => \'\',\n \'iscore\' => \'0\',\n \'version\' => \'1.0\',\n \'description\' => \'\',\n \'setting\' => \'\',\n \'listorder\' => \'0\',\n \'disabled\' => \'0\',\n \'installdate\' => \'2010-09-06\',\n \'updatedate\' => \'2010-09-06\',\n ),\n \'content\' => \n array (\n \'module\' => \'content\',\n \'name\' => \'内容模块\',\n \'url\' => \'\',\n \'iscore\' => \'1\',\n \'version\' => \'1.0\',\n \'description\' => \'\',\n \'setting\' => \'\',\n \'listorder\' => \'0\',\n \'disabled\' => \'0\',\n \'installdate\' => \'2010-09-06\',\n \'updatedate\' => \'2010-09-06\',\n ),\n \'search\' => \n array (\n \'module\' => \'search\',\n \'name\' => \'全站搜索\',\n \'url\' => \'\',\n \'iscore\' => \'0\',\n \'version\' => \'1.0\',\n \'description\' => \'\',\n \'setting\' => \'array (\n \\\'fulltextenble\\\' => \\\'1\\\',\n \\\'relationenble\\\' => \\\'1\\\',\n \\\'suggestenable\\\' => \\\'1\\\',\n \\\'sphinxenable\\\' => \\\'0\\\',\n \\\'sphinxhost\\\' => \\\'10.228.134.102\\\',\n \\\'sphinxport\\\' => \\\'9312\\\',\n)\',\n \'listorder\' => \'0\',\n \'disabled\' => \'0\',\n \'installdate\' => \'2010-09-06\',\n \'updatedate\' => \'2010-09-06\',\n ),\n \'scan\' => \n array (\n \'module\' => \'scan\',\n \'name\' => \'木马扫描\',\n \'url\' => \'scan\',\n \'iscore\' => \'0\',\n \'version\' => \'1.0\',\n \'description\' => \'\',\n \'setting\' => \'\',\n \'listorder\' => \'0\',\n \'disabled\' => \'0\',\n \'installdate\' => \'2010-09-01\',\n \'updatedate\' => \'2010-09-06\',\n ),\n \'attachment\' => \n array (\n \'module\' => \'attachment\',\n \'name\' => \'附件\',\n \'url\' => \'attachment\',\n \'iscore\' => \'1\',\n \'version\' => \'1.0\',\n \'description\' => \'\',\n \'setting\' => \'\',\n \'listorder\' => \'0\',\n \'disabled\' => \'0\',\n \'installdate\' => \'2010-09-01\',\n \'updatedate\' => \'2010-09-06\',\n ),\n \'block\' => \n array (\n \'module\' => \'block\',\n \'name\' => \'碎片\',\n \'url\' => \'\',\n \'iscore\' => \'1\',\n \'version\' => \'1.0\',\n \'description\' => \'\',\n \'setting\' => \'\',\n \'listorder\' => \'0\',\n \'disabled\' => \'0\',\n \'installdate\' => \'2010-09-01\',\n \'updatedate\' => \'2010-09-06\',\n ),\n \'collection\' => \n array (\n \'module\' => \'collection\',\n \'name\' => \'采集模块\',\n \'url\' => \'collection\',\n \'iscore\' => \'1\',\n \'version\' => \'1.0\',\n \'description\' => \'\',\n \'setting\' => \'\',\n \'listorder\' => \'0\',\n \'disabled\' => \'0\',\n \'installdate\' => \'2010-09-01\',\n \'updatedate\' => \'2010-09-06\',\n ),\n \'dbsource\' => \n array (\n \'module\' => \'dbsource\',\n \'name\' => \'数据源\',\n \'url\' => \'\',\n \'iscore\' => \'1\',\n \'version\' => \'\',\n \'description\' => \'\',\n \'setting\' => \'\',\n \'listorder\' => \'0\',\n \'disabled\' => \'0\',\n \'installdate\' => \'2010-09-01\',\n \'updatedate\' => \'2010-09-06\',\n ),\n \'template\' => \n array (\n \'module\' => \'template\',\n \'name\' => \'模板风格\',\n \'url\' => \'\',\n \'iscore\' => \'1\',\n \'version\' => \'1.0\',\n \'description\' => \'\',\n \'setting\' => \'\',\n \'listorder\' => \'0\',\n \'disabled\' => \'0\',\n \'installdate\' => \'2010-09-01\',\n \'updatedate\' => \'2010-09-06\',\n ),\n \'release\' => \n array (\n \'module\' => \'release\',\n \'name\' => \'发布点\',\n \'url\' => \'\',\n \'iscore\' => \'1\',\n \'version\' => \'1.0\',\n \'description\' => \'\',\n \'setting\' => \'\',\n \'listorder\' => \'0\',\n \'disabled\' => \'0\',\n \'installdate\' => \'2010-09-01\',\n \'updatedate\' => \'2010-09-06\',\n ),\n \'video\' => \n array (\n \'module\' => \'video\',\n \'name\' => \'视频库\',\n \'url\' => \'\',\n \'iscore\' => \'0\',\n \'version\' => \'1.0\',\n \'description\' => \'\',\n \'setting\' => \'\',\n \'listorder\' => \'0\',\n \'disabled\' => \'0\',\n \'installdate\' => \'2012-09-28\',\n \'updatedate\' => \'2012-09-28\',\n ),\n \'announce\' => \n array (\n \'module\' => \'announce\',\n \'name\' => \'公告\',\n \'url\' => \'announce/\',\n \'iscore\' => \'0\',\n \'version\' => \'1.0\',\n \'description\' => \'公告\',\n \'setting\' => \'\',\n \'listorder\' => \'0\',\n \'disabled\' => \'0\',\n \'installdate\' => \'2019-03-21\',\n \'updatedate\' => \'2019-03-21\',\n ),\n \'comment\' => \n array (\n \'module\' => \'comment\',\n \'name\' => \'评论\',\n \'url\' => \'comment/\',\n \'iscore\' => \'0\',\n \'version\' => \'1.0\',\n \'description\' => \'评论\',\n \'setting\' => \'\',\n \'listorder\' => \'0\',\n \'disabled\' => \'0\',\n \'installdate\' => \'2019-03-21\',\n \'updatedate\' => \'2019-03-21\',\n ),\n \'link\' => \n array (\n \'module\' => \'link\',\n \'name\' => \'友情链接\',\n \'url\' => \'\',\n \'iscore\' => \'0\',\n \'version\' => \'1.0\',\n \'description\' => \'\',\n \'setting\' => \'array (\n 1 => \n array (\n \\\'is_post\\\' => \\\'1\\\',\n \\\'enablecheckcode\\\' => \\\'0\\\',\n ),\n)\',\n \'listorder\' => \'0\',\n \'disabled\' => \'0\',\n \'installdate\' => \'2010-09-06\',\n \'updatedate\' => \'2010-09-06\',\n ),\n \'vote\' => \n array (\n \'module\' => \'vote\',\n \'name\' => \'投票\',\n \'url\' => \'\',\n \'iscore\' => \'0\',\n \'version\' => \'1.0\',\n \'description\' => \'\',\n \'setting\' => \'array (\r\n 1 => \r\n array (\r\n \\\'default_style\\\' => \\\'default\\\',\r\n \\\'vote_tp_template\\\' => \\\'vote_tp\\\',\r\n \\\'allowguest\\\' => \\\'1\\\',\r\n \\\'enabled\\\' => \\\'1\\\',\r\n \\\'interval\\\' => \\\'1\\\',\r\n \\\'credit\\\' => \\\'1\\\',\r\n ),\r\n)\',\n \'listorder\' => \'0\',\n \'disabled\' => \'0\',\n \'installdate\' => \'2010-09-06\',\n \'updatedate\' => \'2010-09-06\',\n ),\n \'message\' => \n array (\n \'module\' => \'message\',\n \'name\' => \'短消息\',\n \'url\' => \'\',\n \'iscore\' => \'0\',\n \'version\' => \'1.0\',\n \'description\' => \'\',\n \'setting\' => \'\',\n \'listorder\' => \'0\',\n \'disabled\' => \'0\',\n \'installdate\' => \'2010-09-06\',\n \'updatedate\' => \'2010-09-06\',\n ),\n \'mood\' => \n array (\n \'module\' => \'mood\',\n \'name\' => \'新闻心情\',\n \'url\' => \'mood/\',\n \'iscore\' => \'0\',\n \'version\' => \'1.0\',\n \'description\' => \'新闻心情\',\n \'setting\' => \'\',\n \'listorder\' => \'0\',\n \'disabled\' => \'0\',\n \'installdate\' => \'2019-03-21\',\n \'updatedate\' => \'2019-03-21\',\n ),\n \'poster\' => \n array (\n \'module\' => \'poster\',\n \'name\' => \'广告模块\',\n \'url\' => \'poster/\',\n \'iscore\' => \'0\',\n \'version\' => \'1.0\',\n \'description\' => \'广告模块\',\n \'setting\' => \'\',\n \'listorder\' => \'0\',\n \'disabled\' => \'0\',\n \'installdate\' => \'2019-03-21\',\n \'updatedate\' => \'2019-03-21\',\n ),\n \'formguide\' => \n array (\n \'module\' => \'formguide\',\n \'name\' => \'表单向导\',\n \'url\' => \'formguide/\',\n \'iscore\' => \'0\',\n \'version\' => \'1.0\',\n \'description\' => \'formguide\',\n \'setting\' => \'array (\n \\\'allowmultisubmit\\\' => \\\'1\\\',\n \\\'interval\\\' => \\\'30\\\',\n \\\'allowunreg\\\' => \\\'0\\\',\n \\\'mailmessage\\\' => \\\'用户向我们提交了表单数据，赶快去看看吧。\\\',\n)\',\n \'listorder\' => \'0\',\n \'disabled\' => \'0\',\n \'installdate\' => \'2010-10-20\',\n \'updatedate\' => \'2010-10-20\',\n ),\n \'wap\' => \n array (\n \'module\' => \'wap\',\n \'name\' => \'手机门户\',\n \'url\' => \'wap/\',\n \'iscore\' => \'0\',\n \'version\' => \'1.0\',\n \'description\' => \'手机门户\',\n \'setting\' => \'\',\n \'listorder\' => \'0\',\n \'disabled\' => \'0\',\n \'installdate\' => \'2019-03-21\',\n \'updatedate\' => \'2019-03-21\',\n ),\n \'upgrade\' => \n array (\n \'module\' => \'upgrade\',\n \'name\' => \'在线升级\',\n \'url\' => \'\',\n \'iscore\' => \'0\',\n \'version\' => \'1.0\',\n \'description\' => \'\',\n \'setting\' => \'\',\n \'listorder\' => \'0\',\n \'disabled\' => \'0\',\n \'installdate\' => \'2011-05-18\',\n \'updatedate\' => \'2011-05-18\',\n ),\n \'tag\' => \n array (\n \'module\' => \'tag\',\n \'name\' => \'标签向导\',\n \'url\' => \'tag/\',\n \'iscore\' => \'0\',\n \'version\' => \'1.0\',\n \'description\' => \'标签向导\',\n \'setting\' => \'\',\n \'listorder\' => \'0\',\n \'disabled\' => \'0\',\n \'installdate\' => \'2019-03-21\',\n \'updatedate\' => \'2019-03-21\',\n ),\n \'sms\' => \n array (\n \'module\' => \'sms\',\n \'name\' => \'短信平台\',\n \'url\' => \'sms/\',\n \'iscore\' => \'0\',\n \'version\' => \'1.0\',\n \'description\' => \'短信平台\',\n \'setting\' => \'\',\n \'listorder\' => \'0\',\n \'disabled\' => \'0\',\n \'installdate\' => \'2011-09-02\',\n \'updatedate\' => \'2011-09-02\',\n ),\n);\n?>');
INSERT INTO `v9_cache` VALUES ('model.cache.php', 'caches_commons/caches_data/', '<?php\nreturn array (\n 1 => \n array (\n \'modelid\' => \'1\',\n \'siteid\' => \'1\',\n \'name\' => \'文章模型\',\n \'description\' => \'\',\n \'tablename\' => \'news\',\n \'setting\' => \'\',\n \'addtime\' => \'0\',\n \'items\' => \'0\',\n \'enablesearch\' => \'1\',\n \'disabled\' => \'0\',\n \'default_style\' => \'default\',\n \'category_template\' => \'category\',\n \'list_template\' => \'list\',\n \'show_template\' => \'show\',\n \'js_template\' => \'\',\n \'admin_list_template\' => \'\',\n \'member_add_template\' => \'\',\n \'member_list_template\' => \'\',\n \'sort\' => \'0\',\n \'type\' => \'0\',\n ),\n 2 => \n array (\n \'modelid\' => \'2\',\n \'siteid\' => \'1\',\n \'name\' => \'下载模型\',\n \'description\' => \'\',\n \'tablename\' => \'download\',\n \'setting\' => \'\',\n \'addtime\' => \'0\',\n \'items\' => \'0\',\n \'enablesearch\' => \'1\',\n \'disabled\' => \'0\',\n \'default_style\' => \'default\',\n \'category_template\' => \'category_download\',\n \'list_template\' => \'list_download\',\n \'show_template\' => \'show_download\',\n \'js_template\' => \'\',\n \'admin_list_template\' => \'\',\n \'member_add_template\' => \'\',\n \'member_list_template\' => \'\',\n \'sort\' => \'0\',\n \'type\' => \'0\',\n ),\n 3 => \n array (\n \'modelid\' => \'3\',\n \'siteid\' => \'1\',\n \'name\' => \'图片模型\',\n \'description\' => \'\',\n \'tablename\' => \'picture\',\n \'setting\' => \'\',\n \'addtime\' => \'0\',\n \'items\' => \'0\',\n \'enablesearch\' => \'1\',\n \'disabled\' => \'0\',\n \'default_style\' => \'default\',\n \'category_template\' => \'category_picture\',\n \'list_template\' => \'list_picture\',\n \'show_template\' => \'show_picture\',\n \'js_template\' => \'\',\n \'admin_list_template\' => \'\',\n \'member_add_template\' => \'\',\n \'member_list_template\' => \'\',\n \'sort\' => \'0\',\n \'type\' => \'0\',\n ),\n 11 => \n array (\n \'modelid\' => \'11\',\n \'siteid\' => \'1\',\n \'name\' => \'视频模型\',\n \'description\' => \'\',\n \'tablename\' => \'video\',\n \'setting\' => \'\',\n \'addtime\' => \'0\',\n \'items\' => \'0\',\n \'enablesearch\' => \'1\',\n \'disabled\' => \'0\',\n \'default_style\' => \'default\',\n \'category_template\' => \'category_video\',\n \'list_template\' => \'list_video\',\n \'show_template\' => \'show_video\',\n \'js_template\' => \'\',\n \'admin_list_template\' => \'\',\n \'member_add_template\' => \'\',\n \'member_list_template\' => \'\',\n \'sort\' => \'0\',\n \'type\' => \'0\',\n ),\n);\n?>');
INSERT INTO `v9_cache` VALUES ('workflow_1.cache.php', 'caches_commons/caches_data/', '<?php\nreturn array (\n 1 => \n array (\n \'workflowid\' => \'1\',\n \'siteid\' => \'1\',\n \'steps\' => \'1\',\n \'workname\' => \'一级审核\',\n \'description\' => \'审核一次\',\n \'setting\' => \'\',\n \'flag\' => \'0\',\n ),\n 2 => \n array (\n \'workflowid\' => \'2\',\n \'siteid\' => \'1\',\n \'steps\' => \'2\',\n \'workname\' => \'二级审核\',\n \'description\' => \'审核两次\',\n \'setting\' => \'\',\n \'flag\' => \'0\',\n ),\n 3 => \n array (\n \'workflowid\' => \'3\',\n \'siteid\' => \'1\',\n \'steps\' => \'3\',\n \'workname\' => \'三级审核\',\n \'description\' => \'审核三次\',\n \'setting\' => \'\',\n \'flag\' => \'0\',\n ),\n 4 => \n array (\n \'workflowid\' => \'4\',\n \'siteid\' => \'1\',\n \'steps\' => \'4\',\n \'workname\' => \'四级审核\',\n \'description\' => \'四级审核\',\n \'setting\' => \'\',\n \'flag\' => \'0\',\n ),\n);\n?>');
INSERT INTO `v9_cache` VALUES ('member_model.cache.php', 'caches_commons/caches_data/', '<?php\nreturn array (\n 10 => \n array (\n \'modelid\' => \'10\',\n \'siteid\' => \'1\',\n \'name\' => \'普通会员\',\n \'description\' => \'普通会员\',\n \'tablename\' => \'member_detail\',\n \'setting\' => \'\',\n \'addtime\' => \'0\',\n \'items\' => \'0\',\n \'enablesearch\' => \'1\',\n \'disabled\' => \'0\',\n \'default_style\' => \'\',\n \'category_template\' => \'\',\n \'list_template\' => \'\',\n \'show_template\' => \'\',\n \'js_template\' => \'\',\n \'admin_list_template\' => \'\',\n \'member_add_template\' => \'\',\n \'member_list_template\' => \'\',\n \'sort\' => \'0\',\n \'type\' => \'2\',\n ),\n);\n?>');
INSERT INTO `v9_cache` VALUES ('special.cache.php', 'caches_commons/caches_data/', '<?php\nreturn array (\n);\n?>');
INSERT INTO `v9_cache` VALUES ('common.cache.php', 'caches_commons/caches_data/', '<?php\nreturn array (\n \'admin_email\' => \'phpcms@phpcms.cn\',\n \'adminaccessip\' => \'0\',\n \'maxloginfailedtimes\' => \'8\',\n \'maxiplockedtime\' => \'15\',\n \'minrefreshtime\' => \'2\',\n \'mail_type\' => \'1\',\n \'mail_server\' => \'smtp.qq.com\',\n \'mail_port\' => \'25\',\n \'mail_user\' => \'phpcms.cn@foxmail.com\',\n \'mail_auth\' => \'1\',\n \'mail_from\' => \'phpcms.cn@foxmail.com\',\n \'mail_password\' => \'\',\n \'errorlog_size\' => \'20\',\n);\n?>');
-- ----------------------------
-- Table structure for v9_category
-- ----------------------------
DROP TABLE IF EXISTS `v9_category`;
CREATE TABLE `v9_category` (
`catid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`siteid` smallint(5) unsigned NOT NULL DEFAULT '0',
`module` varchar(15) NOT NULL,
`type` tinyint(1) unsigned NOT NULL DEFAULT '0',
`modelid` smallint(5) unsigned NOT NULL DEFAULT '0',
`parentid` smallint(5) unsigned NOT NULL DEFAULT '0',
`arrparentid` varchar(255) NOT NULL,
`child` tinyint(1) unsigned NOT NULL DEFAULT '0',
`arrchildid` mediumtext NOT NULL,
`catname` varchar(30) NOT NULL,
`style` varchar(5) NOT NULL,
`image` varchar(100) NOT NULL,
`description` mediumtext NOT NULL,
`parentdir` varchar(100) NOT NULL,
`catdir` varchar(30) NOT NULL,
`url` varchar(100) NOT NULL,
`items` mediumint(8) unsigned NOT NULL DEFAULT '0',
`hits` int(10) unsigned NOT NULL DEFAULT '0',
`setting` mediumtext NOT NULL,
`listorder` smallint(5) unsigned NOT NULL DEFAULT '0',
`ismenu` tinyint(1) unsigned NOT NULL DEFAULT '1',
`sethtml` tinyint(1) unsigned NOT NULL DEFAULT '0',
`letter` varchar(30) NOT NULL,
`usable_type` varchar(255) NOT NULL,
PRIMARY KEY (`catid`),
KEY `module` (`module`,`parentid`,`listorder`,`catid`),
KEY `siteid` (`siteid`,`type`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of v9_category
-- ----------------------------
INSERT INTO `v9_category` VALUES ('1', '1', 'content', '1', '0', '0', '0', '1', '1,2,3,5,162', '网站介绍', '', '', '', '', 'about', '/html/about/', '0', '0', 'array (\n \'ishtml\' => \'1\',\n \'template_list\' => \'default\',\n \'page_template\' => \'page\',\n \'meta_title\' => \'\',\n \'meta_keywords\' => \'\',\n \'meta_description\' => \'\',\n \'category_ruleid\' => \'1\',\n \'show_ruleid\' => \'\',\n \'repeatchargedays\' => \'1\',\n)', '1', '0', '0', 'wangzhanjieshao', '');
INSERT INTO `v9_category` VALUES ('2', '1', 'content', '1', '0', '1', '0,1', '0', '2', '关于我们', '', '', '', 'about/', 'aboutus', '/html/about/aboutus/', '0', '0', 'array (\n \'ishtml\' => \'1\',\n \'template_list\' => \'default\',\n \'page_template\' => \'page\',\n \'meta_title\' => \'关于我们\',\n \'meta_keywords\' => \'关于我们\',\n \'meta_description\' => \'关于我们\',\n \'category_ruleid\' => \'1\',\n \'show_ruleid\' => \'\',\n \'repeatchargedays\' => \'1\',\n)', '1', '1', '0', 'guanyuwomen', '');
INSERT INTO `v9_category` VALUES ('3', '1', 'content', '1', '0', '1', '0,1', '0', '3', '联系方式', '', '', '', 'about/', 'contactus', '/html/about/contactus/', '0', '0', 'array (\n \'ishtml\' => \'1\',\n \'template_list\' => \'default\',\n \'page_template\' => \'page\',\n \'meta_title\' => \'联系方式\',\n \'meta_keywords\' => \'联系方式\',\n \'meta_description\' => \'联系方式\',\n \'category_ruleid\' => \'1\',\n \'show_ruleid\' => \'\',\n \'repeatchargedays\' => \'1\',\n)', '2', '1', '0', 'lianxifangshi', '');
INSERT INTO `v9_category` VALUES ('4', '1', 'content', '1', '0', '1', '0,1', '0', '4', '版权声明', '', '', '', 'about/', 'copyright', 'http://test.phpcms.cn/index.php?m=content&c=index&a=lists&catid=4', '0', '0', 'array (\n \'ishtml\' => \'0\',\n \'template_list\' => \'default\',\n \'page_template\' => \'page\',\n \'meta_title\' => \'版权声明\',\n \'meta_keywords\' => \'版权声明\',\n \'meta_description\' => \'版权声明\',\n \'category_ruleid\' => \'6\',\n \'show_ruleid\' => \'\',\n \'repeatchargedays\' => \'1\',\n)', '3', '1', '0', 'banquanshengming', '');
INSERT INTO `v9_category` VALUES ('5', '1', 'content', '1', '0', '1', '0,1', '0', '5', '招聘信息', '', '', '', 'about/', 'hr', '/html/about/hr/', '0', '0', 'array (\n \'ishtml\' => \'1\',\n \'template_list\' => \'default\',\n \'page_template\' => \'page\',\n \'meta_title\' => \'\',\n \'meta_keywords\' => \'\',\n \'meta_description\' => \'\',\n \'category_ruleid\' => \'1\',\n \'show_ruleid\' => \'\',\n \'repeatchargedays\' => \'1\',\n)', '4', '1', '0', 'zhaopinxinxi', '');
INSERT INTO `v9_category` VALUES ('6', '1', 'content', 1, 0, 1, '0,1', 0, '6', '相册-照片墙', '', '', '', 'about/', 'photos', '/index.php?m=content&c=index&a=lists&catid=6', 0, 0, '{\"ishtml\":\"0\",\"template_list\":\"default\",\"page_template\":\"page_photo_show\",\"meta_title\":\"照片墙\",\"meta_keywords\":\"照片墙\",\"meta_description\":\"照片墙\",\"category_ruleid\":\"6\",\"show_ruleid\":\"\",\"repeatchargedays\":\"1\"}', 6, 1, 0, 'xiangce', '');
-- ----------------------------
-- Table structure for v9_category_priv
-- ----------------------------
DROP TABLE IF EXISTS `v9_category_priv`;
CREATE TABLE `v9_category_priv` (
`catid` smallint(5) unsigned NOT NULL DEFAULT '0',
`siteid` smallint(5) unsigned NOT NULL DEFAULT '0',
`roleid` smallint(5) unsigned NOT NULL DEFAULT '0',
`is_admin` tinyint(1) unsigned NOT NULL DEFAULT '0',
`action` char(30) NOT NULL,
KEY `catid` (`catid`,`roleid`,`is_admin`,`action`),
KEY `siteid` (`siteid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of v9_category_priv
-- ----------------------------
-- ----------------------------
-- Table structure for v9_collection_content
-- ----------------------------
DROP TABLE IF EXISTS `v9_collection_content`;
CREATE TABLE `v9_collection_content` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`nodeid` int(10) unsigned NOT NULL DEFAULT '0',
`siteid` mediumint(5) unsigned NOT NULL DEFAULT '0',
`status` tinyint(1) unsigned NOT NULL DEFAULT '0',
`url` char(255) NOT NULL,
`title` char(100) NOT NULL,
`data` text NOT NULL,
PRIMARY KEY (`id`),
KEY `nodeid` (`nodeid`,`siteid`),
KEY `status` (`status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of v9_collection_content
-- ----------------------------
-- ----------------------------
-- Table structure for v9_collection_history
-- ----------------------------
DROP TABLE IF EXISTS `v9_collection_history`;
CREATE TABLE `v9_collection_history` (
`md5` char(32) NOT NULL,
`siteid` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`md5`,`siteid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of v9_collection_history
-- ----------------------------
-- ----------------------------
-- Table structure for v9_collection_node
-- ----------------------------
DROP TABLE IF EXISTS `v9_collection_node`;
CREATE TABLE `v9_collection_node` (
`nodeid` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(20) NOT NULL,
`lastdate` int(10) unsigned NOT NULL DEFAULT '0',
`siteid` smallint(5) unsigned NOT NULL DEFAULT '0',
`sourcecharset` varchar(8) NOT NULL,
`sourcetype` tinyint(1) unsigned NOT NULL DEFAULT '0',
`urlpage` text NOT NULL,
`pagesize_start` tinyint(3) unsigned NOT NULL DEFAULT '0',
`pagesize_end` mediumint(8) unsigned NOT NULL DEFAULT '0',
`page_base` char(255) NOT NULL,
`par_num` tinyint(3) unsigned NOT NULL DEFAULT '1',
`url_contain` char(100) NOT NULL,
`url_except` char(100) NOT NULL,
`url_start` char(100) NOT NULL DEFAULT '',
`url_end` char(100) NOT NULL DEFAULT '',
`title_rule` char(100) NOT NULL,
`title_html_rule` text NOT NULL,
`author_rule` char(100) NOT NULL,
`author_html_rule` text NOT NULL,
`comeform_rule` char(100) NOT NULL,
`comeform_html_rule` text NOT NULL,
`time_rule` char(100) NOT NULL,
`time_html_rule` text NOT NULL,
`content_rule` char(100) NOT NULL,
`content_html_rule` text NOT NULL,
`content_page_start` char(100) NOT NULL,
`content_page_end` char(100) NOT NULL,
`content_page_rule` tinyint(1) unsigned NOT NULL DEFAULT '0',
`content_page` tinyint(1) unsigned NOT NULL DEFAULT '0',
`content_nextpage` char(100) NOT NULL,
`down_attachment` tinyint(1) unsigned NOT NULL DEFAULT '0',
`watermark` tinyint(1) unsigned NOT NULL DEFAULT '0',
`coll_order` tinyint(3) unsigned NOT NULL DEFAULT '0',
`customize_config` text NOT NULL,
PRIMARY KEY (`nodeid`),
KEY `siteid` (`siteid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of v9_collection_node
-- ----------------------------
-- ----------------------------
-- Table structure for v9_collection_program
-- ----------------------------
DROP TABLE IF EXISTS `v9_collection_program`;
CREATE TABLE `v9_collection_program` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`siteid` smallint(5) unsigned NOT NULL DEFAULT '0',
`nodeid` int(10) unsigned NOT NULL DEFAULT '0',
`modelid` mediumint(6) unsigned NOT NULL DEFAULT '0',
`catid` int(10) unsigned NOT NULL DEFAULT '0',
`config` text NOT NULL,
PRIMARY KEY (`id`),
KEY `siteid` (`siteid`),
KEY `nodeid` (`nodeid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of v9_collection_program
-- ----------------------------
-- ----------------------------
-- Table structure for v9_comment
-- ----------------------------
DROP TABLE IF EXISTS `v9_comment`;
CREATE TABLE `v9_comment` (
`commentid` char(30) NOT NULL,
`siteid` smallint(5) NOT NULL DEFAULT '0',
`title` char(255) NOT NULL,
`url` char(255) NOT NULL,
`total` int(8) unsigned DEFAULT '0',
`square` mediumint(8) unsigned DEFAULT '0',
`anti` mediumint(8) unsigned DEFAULT '0',
`neutral` mediumint(8) unsigned DEFAULT '0',
`display_type` tinyint(1) DEFAULT '0',
`tableid` mediumint(8) unsigned DEFAULT '0',
`lastupdate` int(10) unsigned DEFAULT '0',
PRIMARY KEY (`commentid`),
KEY `lastupdate` (`lastupdate`),
KEY `siteid` (`siteid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of v9_comment
-- ----------------------------
-- ----------------------------
-- Table structure for v9_comment_check
-- ----------------------------
DROP TABLE IF EXISTS `v9_comment_check`;
CREATE TABLE `v9_comment_check` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`comment_data_id` int(10) DEFAULT '0' COMMENT '论评ID号',
`siteid` smallint(5) NOT NULL DEFAULT '0' COMMENT '站点ID',
`tableid` mediumint(8) DEFAULT '0' COMMENT '数据存储表ID',
PRIMARY KEY (`id`),
KEY `siteid` (`siteid`),
KEY `comment_data_id` (`comment_data_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of v9_comment_check
-- ----------------------------
-- ----------------------------
-- Table structure for v9_comment_data_1
-- ----------------------------
DROP TABLE IF EXISTS `v9_comment_data_1`;
CREATE TABLE `v9_comment_data_1` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '评论ID',
`commentid` char(30) NOT NULL DEFAULT '' COMMENT '评论ID号',
`siteid` smallint(5) NOT NULL DEFAULT '0' COMMENT '站点ID',
`userid` int(10) unsigned DEFAULT '0' COMMENT '用户ID',
`username` varchar(20) DEFAULT NULL COMMENT '用户名',
`creat_at` int(10) DEFAULT NULL COMMENT '发布时间',
`ip` varchar(15) DEFAULT NULL COMMENT '用户IP地址',
`status` tinyint(1) DEFAULT '0' COMMENT '评论状态{0:未审核,-1:未通过审核,1:通过审核}',
`content` text COMMENT '评论内容',
`direction` tinyint(1) DEFAULT '0' COMMENT '评论方向{0:无方向,1:正文,2:反方,3:中立}',
`support` mediumint(8) unsigned DEFAULT '0' COMMENT '支持数',
`reply` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否为回复',
PRIMARY KEY (`id`),
KEY `commentid` (`commentid`),
KEY `direction` (`direction`),
KEY `siteid` (`siteid`),
KEY `support` (`support`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of v9_comment_data_1
-- ----------------------------
-- ----------------------------
-- Table structure for v9_comment_setting
-- ----------------------------
DROP TABLE IF EXISTS `v9_comment_setting`;
CREATE TABLE `v9_comment_setting` (
`siteid` smallint(5) NOT NULL DEFAULT '0' COMMENT '站点ID',
`guest` tinyint(1) DEFAULT '0' COMMENT '是否允许游客评论',
`check` tinyint(1) DEFAULT '0' COMMENT '是否需要审核',
`code` tinyint(1) DEFAULT '0' COMMENT '是否开启验证码',
`add_point` tinyint(3) unsigned DEFAULT '0' COMMENT '添加的积分数',
`del_point` tinyint(3) unsigned DEFAULT '0' COMMENT '扣除的积分数',
PRIMARY KEY (`siteid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of v9_comment_setting
-- ----------------------------
INSERT INTO `v9_comment_setting` VALUES ('1', '0', '0', '0', '0', '0');
-- ----------------------------
-- Table structure for v9_comment_table
-- ----------------------------
DROP TABLE IF EXISTS `v9_comment_table`;
CREATE TABLE `v9_comment_table` (
`tableid` mediumint(8) NOT NULL AUTO_INCREMENT COMMENT '表ID号',
`total` int(10) unsigned DEFAULT '0' COMMENT '数据总量',
`creat_at` int(10) DEFAULT '0' COMMENT '创建时间',
PRIMARY KEY (`tableid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of v9_comment_table
-- ----------------------------
INSERT INTO `v9_comment_table` VALUES ('1', '0', '0');
-- ----------------------------
-- Table structure for v9_content_check
-- ----------------------------
DROP TABLE IF EXISTS `v9_content_check`;
CREATE TABLE `v9_content_check` (
`checkid` char(15) NOT NULL,
`catid` smallint(5) unsigned NOT NULL DEFAULT '0',
`siteid` smallint(5) unsigned NOT NULL DEFAULT '0',
`title` char(80) NOT NULL,
`username` char(20) NOT NULL,
`inputtime` int(10) unsigned NOT NULL DEFAULT '0',
`status` tinyint(1) unsigned NOT NULL DEFAULT '0',
KEY `username` (`username`),
KEY `checkid` (`checkid`),
KEY `status` (`status`,`inputtime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of v9_content_check
-- ----------------------------
-- ----------------------------
-- Table structure for v9_copyfrom
-- ----------------------------
DROP TABLE IF EXISTS `v9_copyfrom`;
CREATE TABLE `v9_copyfrom` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`siteid` smallint(5) unsigned NOT NULL DEFAULT '0',
`sitename` varchar(30) NOT NULL,
`siteurl` varchar(100) NOT NULL,
`thumb` varchar(100) NOT NULL,
`listorder` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of v9_copyfrom
-- ----------------------------
-- ----------------------------
-- Table structure for v9_datacall
-- ----------------------------
DROP TABLE IF EXISTS `v9_datacall`;
CREATE TABLE `v9_datacall` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`name` char(40) DEFAULT NULL,
`dis_type` tinyint(1) unsigned DEFAULT '0',
`type` tinyint(1) DEFAULT '0',
`module` char(20) DEFAULT NULL,
`action` char(20) DEFAULT NULL,
`data` text,
`template` text,
`cache` mediumint(8) DEFAULT NULL,
`num` smallint(6) unsigned DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `type` (`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of v9_datacall
-- ----------------------------
-- ----------------------------
-- Table structure for v9_dbsource
-- ----------------------------
DROP TABLE IF EXISTS `v9_dbsource`;
CREATE TABLE `v9_dbsource` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`siteid` smallint(5) unsigned NOT NULL DEFAULT '0',
`name` varchar(50) NOT NULL,
`host` varchar(20) NOT NULL,
`port` int(5) NOT NULL DEFAULT '3306',
`username` varchar(50) NOT NULL,
`password` varchar(50) NOT NULL,
`dbname` varchar(50) NOT NULL,
`dbtablepre` varchar(30) NOT NULL,
`charset` varchar(10) NOT NULL,
PRIMARY KEY (`id`),
KEY `siteid` (`siteid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of v9_dbsource
-- ----------------------------
-- ----------------------------
-- Table structure for v9_download
-- ----------------------------
DROP TABLE IF EXISTS `v9_download`;
CREATE TABLE `v9_download` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`catid` smallint(5) unsigned NOT NULL DEFAULT '0',
`typeid` smallint(5) unsigned NOT NULL,
`title` char(80) NOT NULL DEFAULT '',
`style` char(24) NOT NULL DEFAULT '',
`thumb` varchar(100) NOT NULL DEFAULT '',
`keywords` char(40) NOT NULL DEFAULT '',
`description` char(255) NOT NULL DEFAULT '',
`posids` tinyint(1) unsigned NOT NULL DEFAULT '0',
`url` char(100) NOT NULL,
`listorder` tinyint(3) unsigned NOT NULL DEFAULT '0',
`status` tinyint(2) unsigned NOT NULL DEFAULT '1',
`sysadd` tinyint(1) unsigned NOT NULL DEFAULT '0',
`islink` tinyint(1) unsigned NOT NULL DEFAULT '0',
`username` char(20) NOT NULL,
`inputtime` int(10) unsigned NOT NULL DEFAULT '0',
`updatetime` int(10) unsigned NOT NULL DEFAULT '0',
`systems` varchar(100) NOT NULL DEFAULT 'Win2000/WinXP/Win2003',
`copytype` varchar(15) NOT NULL DEFAULT '',
`language` varchar(10) NOT NULL DEFAULT '',
`classtype` varchar(20) NOT NULL DEFAULT '',
`version` varchar(20) NOT NULL DEFAULT '',
`filesize` varchar(10) NOT NULL DEFAULT 'Unkown',
`stars` varchar(20) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `status` (`status`,`listorder`,`id`),
KEY `listorder` (`catid`,`status`,`listorder`,`id`),
KEY `catid` (`catid`,`status`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of v9_download
-- ----------------------------
-- ----------------------------
-- Table structure for v9_download_data
-- ----------------------------
DROP TABLE IF EXISTS `v9_download_data`;
CREATE TABLE `v9_download_data` (
`id` mediumint(8) unsigned DEFAULT '0',
`content` text NOT NULL,
`readpoint` smallint(5) unsigned NOT NULL DEFAULT '0',
`groupids_view` varchar(100) NOT NULL,
`paginationtype` tinyint(1) NOT NULL,
`maxcharperpage` mediumint(6) NOT NULL,
`template` varchar(30) NOT NULL,
`paytype` tinyint(1) unsigned NOT NULL DEFAULT '0',
`relation` varchar(255) NOT NULL DEFAULT '',
`allow_comment` tinyint(1) unsigned NOT NULL DEFAULT '1',
`downfiles` mediumtext NOT NULL,
`downfile` varchar(255) NOT NULL DEFAULT '',
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of v9_download_data
-- ----------------------------
-- ----------------------------
-- Table structure for v9_downservers
-- ----------------------------
DROP TABLE IF EXISTS `v9_downservers`;
CREATE TABLE `v9_downservers` (
`id` mediumint(8) NOT NULL AUTO_INCREMENT,
`sitename` varchar(100) DEFAULT NULL,
`siteurl` varchar(255) DEFAULT NULL,
`listorder` smallint(5) unsigned NOT NULL DEFAULT '0',
`siteid` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of v9_downservers
-- ----------------------------
-- ----------------------------
-- Table structure for v9_extend_setting
-- ----------------------------
DROP TABLE IF EXISTS `v9_extend_setting`;
CREATE TABLE `v9_extend_setting` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`key` char(30) NOT NULL,
`data` mediumtext,
PRIMARY KEY (`id`),
KEY `key` (`key`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of v9_extend_setting
-- ----------------------------
-- ----------------------------
-- Table structure for v9_favorite
-- ----------------------------
DROP TABLE IF EXISTS `v9_favorite`;
CREATE TABLE `v9_favorite` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`userid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`title` char(100) NOT NULL,
`url` char(100) NOT NULL,
`adddate` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of v9_favorite
-- ----------------------------
-- ----------------------------
-- Table structure for v9_hits
-- ----------------------------
DROP TABLE IF EXISTS `v9_hits`;
CREATE TABLE `v9_hits` (
`hitsid` char(30) NOT NULL,
`catid` smallint(5) unsigned NOT NULL DEFAULT '0',
`views` int(10) unsigned NOT NULL DEFAULT '0',
`yesterdayviews` int(10) unsigned NOT NULL DEFAULT '0',
`dayviews` int(10) unsigned NOT NULL DEFAULT '0',
`weekviews` int(10) unsigned NOT NULL DEFAULT '0',
`monthviews` int(10) unsigned NOT NULL DEFAULT '0',
`updatetime` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`hitsid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of v9_hits
-- ----------------------------
-- ----------------------------
-- Table structure for v9_ipbanned
-- ----------------------------
DROP TABLE IF EXISTS `v9_ipbanned`;
CREATE TABLE `v9_ipbanned` (
`ipbannedid` smallint(5) NOT NULL AUTO_INCREMENT,
`ip` char(15) NOT NULL,
`expires` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`ipbannedid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of v9_ipbanned
-- ----------------------------
-- ----------------------------
-- Table structure for v9_keylink
-- ----------------------------
DROP TABLE IF EXISTS `v9_keylink`;
CREATE TABLE `v9_keylink` (
`keylinkid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`word` char(40) NOT NULL,
`url` char(100) NOT NULL,
PRIMARY KEY (`keylinkid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of v9_keylink
-- ----------------------------
-- ----------------------------
-- Table structure for v9_keyword
-- ----------------------------
DROP TABLE IF EXISTS `v9_keyword`;
CREATE TABLE `v9_keyword` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`siteid` smallint(5) unsigned NOT NULL DEFAULT '0',
`keyword` char(100) NOT NULL,
`pinyin` char(100) NOT NULL,
`videonum` int(11) NOT NULL DEFAULT '0',
`searchnums` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `keyword` (`keyword`,`siteid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of v9_keyword
-- ----------------------------
-- ----------------------------
-- Table structure for v9_keyword_data
-- ----------------------------
DROP TABLE IF EXISTS `v9_keyword_data`;
CREATE TABLE `v9_keyword_data` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`tagid` int(10) unsigned NOT NULL DEFAULT '0',
`siteid` smallint(5) unsigned NOT NULL DEFAULT '0',
`contentid` char(30) NOT NULL,
PRIMARY KEY (`id`),
KEY `tagid` (`tagid`,`siteid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of v9_keyword_data
-- ----------------------------
-- ----------------------------
-- Table structure for v9_link
-- ----------------------------
DROP TABLE IF EXISTS `v9_link`;
CREATE TABLE `v9_link` (
`linkid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`siteid` smallint(5) unsigned DEFAULT '0',
`typeid` smallint(5) unsigned NOT NULL DEFAULT '0',
`linktype` tinyint(1) unsigned NOT NULL DEFAULT '0',
`name` varchar(50) NOT NULL DEFAULT '',
`url` varchar(255) NOT NULL DEFAULT '',
`logo` varchar(255) NOT NULL DEFAULT '',
`introduce` text NOT NULL,
`username` varchar(30) NOT NULL DEFAULT '',
`listorder` smallint(5) unsigned NOT NULL DEFAULT '0',
`elite` tinyint(1) unsigned NOT NULL DEFAULT '0',
`passed` tinyint(1) unsigned NOT NULL DEFAULT '0',
`addtime` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`linkid`),
KEY `typeid` (`typeid`,`passed`,`listorder`,`linkid`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of v9_link
-- ----------------------------
INSERT INTO `v9_link` VALUES ('1', '1', '0', '1', 'PHPCMS', 'http://www.phpcms.cn', 'http://www.phpcms.cn/images/logo_88_31.gif', '', '', '0', '0', '1', '1553097824');
INSERT INTO `v9_link` VALUES ('2', '1', '0', '1', '盛大在线', 'http://www.sdo.com', 'http://www.snda.com/cn/logo/comp_logo_sdo.gif', '', '', '0', '0', '1', '1553097824');
-- ----------------------------
-- Table structure for v9_linkage
-- ----------------------------
DROP TABLE IF EXISTS `v9_linkage`;
CREATE TABLE `v9_linkage` (
`linkageid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(30) NOT NULL,
`style` varchar(35) NOT NULL,
`parentid` smallint(5) unsigned NOT NULL DEFAULT '0',
`child` tinyint(1) NOT NULL,
`arrchildid` mediumtext NOT NULL,
`keyid` smallint(5) unsigned NOT NULL DEFAULT '0',
`listorder` smallint(5) unsigned NOT NULL DEFAULT '0',
`description` varchar(255) DEFAULT NULL,
`setting` varchar(255) DEFAULT NULL,
`siteid` smallint(5) NOT NULL DEFAULT '0',
PRIMARY KEY (`linkageid`,`keyid`),
KEY `parentid` (`parentid`,`listorder`)
) ENGINE=MyISAM AUTO_INCREMENT=3360 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of v9_linkage
-- ----------------------------
INSERT INTO `v9_linkage` VALUES ('1', '中国', '1', '0', '0', '', '0', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('2', '北京市', '0', '0', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('3', '上海市', '0', '0', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('4', '天津市', '0', '0', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('5', '重庆市', '0', '0', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('6', '河北省', '0', '0', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('7', '山西省', '0', '0', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('8', '内蒙古', '0', '0', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('9', '辽宁省', '0', '0', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('10', '吉林省', '0', '0', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('11', '黑龙江省', '0', '0', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('12', '江苏省', '0', '0', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('13', '浙江省', '0', '0', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('14', '安徽省', '0', '0', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('15', '福建省', '0', '0', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('16', '江西省', '0', '0', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('17', '山东省', '0', '0', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('18', '河南省', '0', '0', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('19', '湖北省', '0', '0', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('20', '湖南省', '0', '0', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('21', '广东省', '0', '0', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('22', '广西', '0', '0', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('23', '海南省', '0', '0', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('24', '四川省', '0', '0', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('25', '贵州省', '0', '0', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('26', '云南省', '0', '0', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('27', '西藏', '0', '0', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('28', '陕西省', '0', '0', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('29', '甘肃省', '0', '0', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('30', '青海省', '0', '0', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('31', '宁夏', '0', '0', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('32', '新疆', '0', '0', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('33', '台湾省', '0', '0', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('34', '香港', '0', '0', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('35', '澳门', '0', '0', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('36', '东城区', '0', '2', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('37', '西城区', '0', '2', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('38', '崇文区', '0', '2', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('39', '宣武区', '0', '2', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('40', '朝阳区', '0', '2', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('41', '石景山区', '0', '2', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('42', '海淀区', '0', '2', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('43', '门头沟区', '0', '2', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('44', '房山区', '0', '2', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('45', '通州区', '0', '2', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('46', '顺义区', '0', '2', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('47', '昌平区', '0', '2', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('48', '大兴区', '0', '2', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('49', '怀柔区', '0', '2', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('50', '平谷区', '0', '2', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('51', '密云县', '0', '2', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('52', '延庆县', '0', '2', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('53', '黄浦区', '0', '3', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('54', '卢湾区', '0', '3', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('55', '徐汇区', '0', '3', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('56', '长宁区', '0', '3', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('57', '静安区', '0', '3', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('58', '普陀区', '0', '3', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('59', '闸北区', '0', '3', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('60', '虹口区', '0', '3', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('61', '杨浦区', '0', '3', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('62', '闵行区', '0', '3', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('63', '宝山区', '0', '3', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('64', '嘉定区', '0', '3', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('65', '浦东新区', '0', '3', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('66', '金山区', '0', '3', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('67', '松江区', '0', '3', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('68', '青浦区', '0', '3', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('69', '南汇区', '0', '3', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('70', '奉贤区', '0', '3', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('71', '崇明县', '0', '3', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('72', '和平区', '0', '4', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('73', '河东区', '0', '4', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('74', '河西区', '0', '4', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('75', '南开区', '0', '4', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('76', '河北区', '0', '4', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('77', '红桥区', '0', '4', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('78', '塘沽区', '0', '4', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('79', '汉沽区', '0', '4', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('80', '大港区', '0', '4', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('81', '东丽区', '0', '4', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('82', '西青区', '0', '4', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('83', '津南区', '0', '4', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('84', '北辰区', '0', '4', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('85', '武清区', '0', '4', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('86', '宝坻区', '0', '4', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('87', '宁河县', '0', '4', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('88', '静海县', '0', '4', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('89', '蓟县', '0', '4', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('90', '万州区', '0', '5', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('91', '涪陵区', '0', '5', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('92', '渝中区', '0', '5', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('93', '大渡口区', '0', '5', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('94', '江北区', '0', '5', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('95', '沙坪坝区', '0', '5', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('96', '九龙坡区', '0', '5', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('97', '南岸区', '0', '5', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('98', '北碚区', '0', '5', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('99', '万盛区', '0', '5', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('100', '双桥区', '0', '5', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('101', '渝北区', '0', '5', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('102', '巴南区', '0', '5', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('103', '黔江区', '0', '5', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('104', '长寿区', '0', '5', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('105', '綦江县', '0', '5', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('106', '潼南县', '0', '5', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('107', '铜梁县', '0', '5', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('108', '大足县', '0', '5', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('109', '荣昌县', '0', '5', '0', '', '1', '0', '', null, '0');
INSERT INTO `v9_linkage` VALUES ('110', '璧山县', '0', '5', '0', '', '1', '0', '', null, '0');