forked from yincart/basic
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathyincart-basic-data.1.1.0rc8.sql
6415 lines (6104 loc) · 540 KB
/
yincart-basic-data.1.1.0rc8.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
-- phpMyAdmin SQL Dump
-- version 4.0.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Mar 13, 2014 at 07:30 AM
-- Server version: 5.6.12-log
-- PHP Version: 5.4.12
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `yincart-basic`
--
CREATE DATABASE IF NOT EXISTS `yincart-basic` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `yincart-basic`;
-- --------------------------------------------------------
--
-- Table structure for table `ad`
--
CREATE TABLE IF NOT EXISTS `ad` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(100) NOT NULL,
`pic` varchar(100) NOT NULL,
`url` varchar(50) NOT NULL,
`theme` varchar(50) DEFAULT 'default',
`content` text,
`sort_order` int(11) NOT NULL DEFAULT '255',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;
--
-- Dumping data for table `ad`
--
INSERT INTO `ad` (`id`, `title`, `pic`, `url`, `theme`, `content`, `sort_order`) VALUES
(1, 'WOMEN', '20130615/20130615043050_12315.jpg', '', 'ultimo', 'here is your place', 1),
(2, 'Customizable Theme', '20130615/20130615043115_89562.jpg', '', 'ultimo', 'You can change colors of almost every element', 2),
(3, '手表', '20130620/20130620024422_32634.jpg', '', 'default', '', 3),
(4, '围巾', '20130620/20130620024555_34436.jpg', '', 'default', '', 4),
(5, '太阳镜', '20130620/20130620024609_62311.jpg', '', 'default', '', 5),
(6, '皮带', '20130620/20130620024632_89911.jpg', '', 'default', '', 255),
(7, 'banner', 'upload/ad/pidiao/banner01.gif', 'banner', 'leather', 'banner', 1),
(8, 'banner', 'upload/ad/pidiao/banner02.jpg', 'banner', 'leather', 'banner', 2),
(9, 'banner', 'upload/ad/pidiao/banner03.jpg', 'banner', 'leather', 'banner', 3),
(10, 'banner', 'upload/ad/pidiao/banner04.jpg', 'banner', 'leather', 'banner', 4),
(11, 'banner', 'upload/ad/pidiao/banner05.jpg', 'banner', 'leather', 'banner', 5);
-- --------------------------------------------------------
--
-- Table structure for table `address_result`
--
CREATE TABLE IF NOT EXISTS `address_result` (
`contact_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '地址库ID',
`user_id` int(10) unsigned DEFAULT NULL,
`contact_name` varchar(45) DEFAULT NULL COMMENT '联系人姓名',
`country` varchar(45) DEFAULT NULL,
`state` varchar(45) DEFAULT NULL,
`city` varchar(45) DEFAULT NULL,
`district` varchar(45) DEFAULT NULL,
`zipcode` varchar(45) DEFAULT NULL,
`address` varchar(255) DEFAULT NULL,
`phone` varchar(45) DEFAULT NULL,
`mobile_phone` varchar(45) DEFAULT NULL,
`memo` text COMMENT '备注',
`is_default` tinyint(1) unsigned DEFAULT '0',
`create_time` int(10) unsigned DEFAULT NULL,
`update_time` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`contact_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `address_result`
--
INSERT INTO `address_result` (`contact_id`, `user_id`, `contact_name`, `country`, `state`, `city`, `district`, `zipcode`, `address`, `phone`, `mobile_phone`, `memo`, `is_default`, `create_time`, `update_time`) VALUES
(1, 1, '小明', NULL, '130000', '130300', '130304', '1111111', '11111', '021-877777222', '13338888899', '', 1, 1359685567, 1359685567),
(2, 6, '小明', NULL, '150000', '150200', '150202', '1420', '213.21', '00000000', '13566666666', '', 0, 1388983054, 1388983054);
-- --------------------------------------------------------
--
-- Table structure for table `admin_user`
--
CREATE TABLE IF NOT EXISTS `admin_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
`password` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
`email` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
`profile` text COLLATE utf8_unicode_ci,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;
--
-- Dumping data for table `admin_user`
--
INSERT INTO `admin_user` (`id`, `username`, `password`, `email`, `profile`) VALUES
(1, 'demo', '$2a$10$.ln8efv0ruje1k5DwmNNzetuHhPcJNn2N7Wgn.ktuMuw3NC4Yomv2', '[email protected]', ''),
(2, 'admin', '$2a$10$5nUz94KR4Tt5DcE.7IkAuObfGB//HcP/x61vQBBwaJslEj8sE.LFK', '[email protected]', '');
-- --------------------------------------------------------
--
-- Table structure for table `admin_user2`
--
CREATE TABLE IF NOT EXISTS `admin_user2` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(45) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
`salt` varchar(255) DEFAULT NULL,
`password_strategy` varchar(50) DEFAULT NULL,
`requires_new_password` tinyint(1) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`login_attempts` int(11) DEFAULT NULL,
`login_time` int(11) DEFAULT NULL,
`login_ip` varchar(32) DEFAULT NULL,
`validation_key` varchar(255) DEFAULT NULL,
`create_id` int(11) DEFAULT NULL,
`create_time` int(11) DEFAULT NULL,
`update_id` int(11) DEFAULT NULL,
`update_time` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`),
UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
--
-- Dumping data for table `admin_user2`
--
INSERT INTO `admin_user2` (`id`, `username`, `password`, `salt`, `password_strategy`, `requires_new_password`, `email`, `login_attempts`, `login_time`, `login_ip`, `validation_key`, `create_id`, `create_time`, `update_id`, `update_time`) VALUES
(6, 'demo', '$2a$14$T.y5HFok8VztysxcQtEUoedkiZZo0q6OyJi87Svt/n7O41.YVChzW', '$2a$14$T.y5HFok8VztysxcQtEUog', 'bcrypt', NULL, '[email protected]', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(7, 'admin', '$2a$14$DQ1E6wAXpsqZHkC72kRd4.cJFUtXgi4F9JEv1ndcT/hBhAhg1oHIO', '$2a$14$DQ1E6wAXpsqZHkC72kRd4A', 'bcrypt', NULL, '[email protected]', 1, NULL, NULL, '27ab3ac3c487c47667f873e697dc1944', NULL, NULL, NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `area`
--
CREATE TABLE IF NOT EXISTS `area` (
`area_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`parent_id` int(10) unsigned NOT NULL DEFAULT '0',
`path` varchar(255) NOT NULL,
`grade` int(10) unsigned NOT NULL DEFAULT '0',
`name` varchar(45) NOT NULL,
`language` varchar(20) NOT NULL,
PRIMARY KEY (`area_id`),
KEY `fk_area_area1_idx` (`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=990101 ;
--
-- Dumping data for table `area`
--
INSERT INTO `area` (`area_id`, `parent_id`, `path`, `grade`, `name`, `language`) VALUES
(100000, 100000, '110000', 0, '中国', 'mainland'),
(110000, 100000, ',110000', 1, '北京', 'mainland'),
(110100, 110000, ',110000,110100', 2, '北京市', 'mainland'),
(110101, 110100, ',110000,110100,110101', 3, '东城区', 'mainland'),
(110102, 110100, ',110000,110100,110102', 3, '西城区', 'mainland'),
(110103, 110100, ',110000,110100,110103', 3, '崇文区', 'mainland'),
(110104, 110100, ',110000,110100,110104', 3, '宣武区', 'mainland'),
(110105, 110100, ',110000,110100,110105', 3, '朝阳区', 'mainland'),
(110106, 110100, ',110000,110100,110106', 3, '丰台区', 'mainland'),
(110107, 110100, ',110000,110100,110107', 3, '石景山区', 'mainland'),
(110108, 110100, ',110000,110100,110108', 3, '海淀区', 'mainland'),
(110109, 110100, ',110000,110100,110109', 3, '门头沟区', 'mainland'),
(110111, 110100, ',110000,110100,110111', 3, '房山区', 'mainland'),
(110112, 110100, ',110000,110100,110112', 3, '通州区', 'mainland'),
(110113, 110100, ',110000,110100,110113', 3, '顺义区', 'mainland'),
(110114, 110100, ',110000,110100,110114', 3, '昌平区', 'mainland'),
(110115, 110100, ',110000,110100,110115', 3, '大兴区', 'mainland'),
(110116, 110100, ',110000,110100,110116', 3, '怀柔区', 'mainland'),
(110117, 110100, ',110000,110100,110117', 3, '平谷区', 'mainland'),
(110228, 110100, ',110000,110100,110228', 3, '密云县', 'mainland'),
(110229, 110100, ',110000,110100,110229', 3, '延庆县', 'mainland'),
(110230, 110100, ',110000,110100,110230', 3, '其它区', 'mainland'),
(120000, 100000, ',120000', 1, '天津', 'mainland'),
(120100, 120000, ',120000,120100', 2, '天津市', 'mainland'),
(120101, 120100, ',120000,120100,120101', 3, '和平区', 'mainland'),
(120102, 120100, ',120000,120100,120102', 3, '河东区', 'mainland'),
(120103, 120100, ',120000,120100,120103', 3, '河西区', 'mainland'),
(120104, 120100, ',120000,120100,120104', 3, '南开区', 'mainland'),
(120105, 120100, ',120000,120100,120105', 3, '河北区', 'mainland'),
(120106, 120100, ',120000,120100,120106', 3, '红桥区', 'mainland'),
(120107, 120100, ',120000,120100,120107', 3, '塘沽区', 'mainland'),
(120108, 120100, ',120000,120100,120108', 3, '汉沽区', 'mainland'),
(120109, 120100, ',120000,120100,120109', 3, '大港区', 'mainland'),
(120110, 120100, ',120000,120100,120110', 3, '东丽区', 'mainland'),
(120111, 120100, ',120000,120100,120111', 3, '西青区', 'mainland'),
(120112, 120100, ',120000,120100,120112', 3, '津南区', 'mainland'),
(120113, 120100, ',120000,120100,120113', 3, '北辰区', 'mainland'),
(120114, 120100, ',120000,120100,120114', 3, '武清区', 'mainland'),
(120115, 120100, ',120000,120100,120115', 3, '宝坻区', 'mainland'),
(120221, 120100, ',120000,120100,120221', 3, '宁河县', 'mainland'),
(120223, 120100, ',120000,120100,120223', 3, '静海县', 'mainland'),
(120225, 120100, ',120000,120100,120225', 3, '蓟县', 'mainland'),
(120226, 120100, ',120000,120100,120226', 3, '其它区', 'mainland'),
(130000, 100000, ',130000', 1, '河北省', 'mainland'),
(130100, 130000, ',130000,130100', 2, '石家庄市', 'mainland'),
(130102, 130100, ',130000,130100,130102', 3, '长安区', 'mainland'),
(130103, 130100, ',130000,130100,130103', 3, '桥东区', 'mainland'),
(130104, 130100, ',130000,130100,130104', 3, '桥西区', 'mainland'),
(130105, 130100, ',130000,130100,130105', 3, '新华区', 'mainland'),
(130107, 130100, ',130000,130100,130107', 3, '井陉矿区', 'mainland'),
(130108, 130100, ',130000,130100,130108', 3, '裕华区', 'mainland'),
(130121, 130100, ',130000,130100,130121', 3, '井陉县', 'mainland'),
(130123, 130100, ',130000,130100,130123', 3, '正定县', 'mainland'),
(130124, 130100, ',130000,130100,130124', 3, '栾城县', 'mainland'),
(130125, 130100, ',130000,130100,130125', 3, '行唐县', 'mainland'),
(130126, 130100, ',130000,130100,130126', 3, '灵寿县', 'mainland'),
(130127, 130100, ',130000,130100,130127', 3, '高邑县', 'mainland'),
(130128, 130100, ',130000,130100,130128', 3, '深泽县', 'mainland'),
(130129, 130100, ',130000,130100,130129', 3, '赞皇县', 'mainland'),
(130130, 130100, ',130000,130100,130130', 3, '无极县', 'mainland'),
(130131, 130100, ',130000,130100,130131', 3, '平山县', 'mainland'),
(130132, 130100, ',130000,130100,130132', 3, '元氏县', 'mainland'),
(130133, 130100, ',130000,130100,130133', 3, '赵县', 'mainland'),
(130181, 130100, ',130000,130100,130181', 3, '辛集市', 'mainland'),
(130182, 130100, ',130000,130100,130182', 3, '藁城市', 'mainland'),
(130183, 130100, ',130000,130100,130183', 3, '晋州市', 'mainland'),
(130184, 130100, ',130000,130100,130184', 3, '新乐市', 'mainland'),
(130185, 130100, ',130000,130100,130185', 3, '鹿泉市', 'mainland'),
(130186, 130100, ',130000,130100,130186', 3, '其它区', 'mainland'),
(130200, 130000, ',130000,130200', 2, '唐山市', 'mainland'),
(130202, 130200, ',130000,130200,130202', 3, '路南区', 'mainland'),
(130203, 130200, ',130000,130200,130203', 3, '路北区', 'mainland'),
(130204, 130200, ',130000,130200,130204', 3, '古冶区', 'mainland'),
(130205, 130200, ',130000,130200,130205', 3, '开平区', 'mainland'),
(130207, 130200, ',130000,130200,130207', 3, '丰南区', 'mainland'),
(130208, 130200, ',130000,130200,130208', 3, '丰润区', 'mainland'),
(130223, 130200, ',130000,130200,130223', 3, '滦县', 'mainland'),
(130224, 130200, ',130000,130200,130224', 3, '滦南县', 'mainland'),
(130225, 130200, ',130000,130200,130225', 3, '乐亭县', 'mainland'),
(130227, 130200, ',130000,130200,130227', 3, '迁西县', 'mainland'),
(130229, 130200, ',130000,130200,130229', 3, '玉田县', 'mainland'),
(130230, 130200, ',130000,130200,130230', 3, '唐海县', 'mainland'),
(130281, 130200, ',130000,130200,130281', 3, '遵化市', 'mainland'),
(130283, 130200, ',130000,130200,130283', 3, '迁安市', 'mainland'),
(130284, 130200, ',130000,130200,130284', 3, '其它区', 'mainland'),
(130300, 130000, ',130000,130300', 2, '秦皇岛市', 'mainland'),
(130302, 130300, ',130000,130300,130302', 3, '海港区', 'mainland'),
(130303, 130300, ',130000,130300,130303', 3, '山海关区', 'mainland'),
(130304, 130300, ',130000,130300,130304', 3, '北戴河区', 'mainland'),
(130321, 130300, ',130000,130300,130321', 3, '青龙满族自治县', 'mainland'),
(130322, 130300, ',130000,130300,130322', 3, '昌黎县', 'mainland'),
(130323, 130300, ',130000,130300,130323', 3, '抚宁县', 'mainland'),
(130324, 130300, ',130000,130300,130324', 3, '卢龙县', 'mainland'),
(130398, 130300, ',130000,130300,130398', 3, '其它区', 'mainland'),
(130399, 130300, ',130000,130300,130399', 3, '经济技术开发区', 'mainland'),
(130400, 130000, ',130000,130400', 2, '邯郸市', 'mainland'),
(130402, 130400, ',130000,130400,130402', 3, '邯山区', 'mainland'),
(130403, 130400, ',130000,130400,130403', 3, '丛台区', 'mainland'),
(130404, 130400, ',130000,130400,130404', 3, '复兴区', 'mainland'),
(130406, 130400, ',130000,130400,130406', 3, '峰峰矿区', 'mainland'),
(130421, 130400, ',130000,130400,130421', 3, '邯郸县', 'mainland'),
(130423, 130400, ',130000,130400,130423', 3, '临漳县', 'mainland'),
(130424, 130400, ',130000,130400,130424', 3, '成安县', 'mainland'),
(130425, 130400, ',130000,130400,130425', 3, '大名县', 'mainland'),
(130426, 130400, ',130000,130400,130426', 3, '涉县', 'mainland'),
(130427, 130400, ',130000,130400,130427', 3, '磁县', 'mainland'),
(130428, 130400, ',130000,130400,130428', 3, '肥乡县', 'mainland'),
(130429, 130400, ',130000,130400,130429', 3, '永年县', 'mainland'),
(130430, 130400, ',130000,130400,130430', 3, '邱县', 'mainland'),
(130431, 130400, ',130000,130400,130431', 3, '鸡泽县', 'mainland'),
(130432, 130400, ',130000,130400,130432', 3, '广平县', 'mainland'),
(130433, 130400, ',130000,130400,130433', 3, '馆陶县', 'mainland'),
(130434, 130400, ',130000,130400,130434', 3, '魏县', 'mainland'),
(130435, 130400, ',130000,130400,130435', 3, '曲周县', 'mainland'),
(130481, 130400, ',130000,130400,130481', 3, '武安市', 'mainland'),
(130482, 130400, ',130000,130400,130482', 3, '其它区', 'mainland'),
(130500, 130000, ',130000,130500', 2, '邢台市', 'mainland'),
(130502, 130500, ',130000,130500,130502', 3, '桥东区', 'mainland'),
(130503, 130500, ',130000,130500,130503', 3, '桥西区', 'mainland'),
(130521, 130500, ',130000,130500,130521', 3, '邢台县', 'mainland'),
(130522, 130500, ',130000,130500,130522', 3, '临城县', 'mainland'),
(130523, 130500, ',130000,130500,130523', 3, '内丘县', 'mainland'),
(130524, 130500, ',130000,130500,130524', 3, '柏乡县', 'mainland'),
(130525, 130500, ',130000,130500,130525', 3, '隆尧县', 'mainland'),
(130526, 130500, ',130000,130500,130526', 3, '任县', 'mainland'),
(130527, 130500, ',130000,130500,130527', 3, '南和县', 'mainland'),
(130528, 130500, ',130000,130500,130528', 3, '宁晋县', 'mainland'),
(130529, 130500, ',130000,130500,130529', 3, '巨鹿县', 'mainland'),
(130530, 130500, ',130000,130500,130530', 3, '新河县', 'mainland'),
(130531, 130500, ',130000,130500,130531', 3, '广宗县', 'mainland'),
(130532, 130500, ',130000,130500,130532', 3, '平乡县', 'mainland'),
(130533, 130500, ',130000,130500,130533', 3, '威县', 'mainland'),
(130534, 130500, ',130000,130500,130534', 3, '清河县', 'mainland'),
(130535, 130500, ',130000,130500,130535', 3, '临西县', 'mainland'),
(130581, 130500, ',130000,130500,130581', 3, '南宫市', 'mainland'),
(130582, 130500, ',130000,130500,130582', 3, '沙河市', 'mainland'),
(130583, 130500, ',130000,130500,130583', 3, '其它区', 'mainland'),
(130600, 130000, ',130000,130600', 2, '保定市', 'mainland'),
(130602, 130600, ',130000,130600,130602', 3, '新市区', 'mainland'),
(130603, 130600, ',130000,130600,130603', 3, '北市区', 'mainland'),
(130604, 130600, ',130000,130600,130604', 3, '南市区', 'mainland'),
(130621, 130600, ',130000,130600,130621', 3, '满城县', 'mainland'),
(130622, 130600, ',130000,130600,130622', 3, '清苑县', 'mainland'),
(130623, 130600, ',130000,130600,130623', 3, '涞水县', 'mainland'),
(130624, 130600, ',130000,130600,130624', 3, '阜平县', 'mainland'),
(130625, 130600, ',130000,130600,130625', 3, '徐水县', 'mainland'),
(130626, 130600, ',130000,130600,130626', 3, '定兴县', 'mainland'),
(130627, 130600, ',130000,130600,130627', 3, '唐县', 'mainland'),
(130628, 130600, ',130000,130600,130628', 3, '高阳县', 'mainland'),
(130629, 130600, ',130000,130600,130629', 3, '容城县', 'mainland'),
(130630, 130600, ',130000,130600,130630', 3, '涞源县', 'mainland'),
(130631, 130600, ',130000,130600,130631', 3, '望都县', 'mainland'),
(130632, 130600, ',130000,130600,130632', 3, '安新县', 'mainland'),
(130633, 130600, ',130000,130600,130633', 3, '易县', 'mainland'),
(130634, 130600, ',130000,130600,130634', 3, '曲阳县', 'mainland'),
(130635, 130600, ',130000,130600,130635', 3, '蠡县', 'mainland'),
(130636, 130600, ',130000,130600,130636', 3, '顺平县', 'mainland'),
(130637, 130600, ',130000,130600,130637', 3, '博野县', 'mainland'),
(130638, 130600, ',130000,130600,130638', 3, '雄县', 'mainland'),
(130681, 130600, ',130000,130600,130681', 3, '涿州市', 'mainland'),
(130682, 130600, ',130000,130600,130682', 3, '定州市', 'mainland'),
(130683, 130600, ',130000,130600,130683', 3, '安国市', 'mainland'),
(130684, 130600, ',130000,130600,130684', 3, '高碑店市', 'mainland'),
(130698, 130600, ',130000,130600,130698', 3, '高开区', 'mainland'),
(130699, 130600, ',130000,130600,130699', 3, '其它区', 'mainland'),
(130700, 130000, ',130000,130700', 2, '张家口市', 'mainland'),
(130702, 130700, ',130000,130700,130702', 3, '桥东区', 'mainland'),
(130703, 130700, ',130000,130700,130703', 3, '桥西区', 'mainland'),
(130705, 130700, ',130000,130700,130705', 3, '宣化区', 'mainland'),
(130706, 130700, ',130000,130700,130706', 3, '下花园区', 'mainland'),
(130721, 130700, ',130000,130700,130721', 3, '宣化县', 'mainland'),
(130722, 130700, ',130000,130700,130722', 3, '张北县', 'mainland'),
(130723, 130700, ',130000,130700,130723', 3, '康保县', 'mainland'),
(130724, 130700, ',130000,130700,130724', 3, '沽源县', 'mainland'),
(130725, 130700, ',130000,130700,130725', 3, '尚义县', 'mainland'),
(130726, 130700, ',130000,130700,130726', 3, '蔚县', 'mainland'),
(130727, 130700, ',130000,130700,130727', 3, '阳原县', 'mainland'),
(130728, 130700, ',130000,130700,130728', 3, '怀安县', 'mainland'),
(130729, 130700, ',130000,130700,130729', 3, '万全县', 'mainland'),
(130730, 130700, ',130000,130700,130730', 3, '怀来县', 'mainland'),
(130731, 130700, ',130000,130700,130731', 3, '涿鹿县', 'mainland'),
(130732, 130700, ',130000,130700,130732', 3, '赤城县', 'mainland'),
(130733, 130700, ',130000,130700,130733', 3, '崇礼县', 'mainland'),
(130734, 130700, ',130000,130700,130734', 3, '其它区', 'mainland'),
(130800, 130000, ',130000,130800', 2, '承德市', 'mainland'),
(130802, 130800, ',130000,130800,130802', 3, '双桥区', 'mainland'),
(130803, 130800, ',130000,130800,130803', 3, '双滦区', 'mainland'),
(130804, 130800, ',130000,130800,130804', 3, '鹰手营子矿区', 'mainland'),
(130821, 130800, ',130000,130800,130821', 3, '承德县', 'mainland'),
(130822, 130800, ',130000,130800,130822', 3, '兴隆县', 'mainland'),
(130823, 130800, ',130000,130800,130823', 3, '平泉县', 'mainland'),
(130824, 130800, ',130000,130800,130824', 3, '滦平县', 'mainland'),
(130825, 130800, ',130000,130800,130825', 3, '隆化县', 'mainland'),
(130826, 130800, ',130000,130800,130826', 3, '丰宁满族自治县', 'mainland'),
(130827, 130800, ',130000,130800,130827', 3, '宽城满族自治县', 'mainland'),
(130828, 130800, ',130000,130800,130828', 3, '围场满族蒙古族自治县', 'mainland'),
(130829, 130800, ',130000,130800,130829', 3, '其它区', 'mainland'),
(130900, 130000, ',130000,130900', 2, '沧州市', 'mainland'),
(130902, 130900, ',130000,130900,130902', 3, '新华区', 'mainland'),
(130903, 130900, ',130000,130900,130903', 3, '运河区', 'mainland'),
(130921, 130900, ',130000,130900,130921', 3, '沧县', 'mainland'),
(130922, 130900, ',130000,130900,130922', 3, '青县', 'mainland'),
(130923, 130900, ',130000,130900,130923', 3, '东光县', 'mainland'),
(130924, 130900, ',130000,130900,130924', 3, '海兴县', 'mainland'),
(130925, 130900, ',130000,130900,130925', 3, '盐山县', 'mainland'),
(130926, 130900, ',130000,130900,130926', 3, '肃宁县', 'mainland'),
(130927, 130900, ',130000,130900,130927', 3, '南皮县', 'mainland'),
(130928, 130900, ',130000,130900,130928', 3, '吴桥县', 'mainland'),
(130929, 130900, ',130000,130900,130929', 3, '献县', 'mainland'),
(130930, 130900, ',130000,130900,130930', 3, '孟村回族自治县', 'mainland'),
(130981, 130900, ',130000,130900,130981', 3, '泊头市', 'mainland'),
(130982, 130900, ',130000,130900,130982', 3, '任丘市', 'mainland'),
(130983, 130900, ',130000,130900,130983', 3, '黄骅市', 'mainland'),
(130984, 130900, ',130000,130900,130984', 3, '河间市', 'mainland'),
(130985, 130900, ',130000,130900,130985', 3, '其它区', 'mainland'),
(131000, 130000, ',130000,131000', 2, '廊坊市', 'mainland'),
(131002, 131000, ',130000,131000,131002', 3, '安次区', 'mainland'),
(131003, 131000, ',130000,131000,131003', 3, '广阳区', 'mainland'),
(131022, 131000, ',130000,131000,131022', 3, '固安县', 'mainland'),
(131023, 131000, ',130000,131000,131023', 3, '永清县', 'mainland'),
(131024, 131000, ',130000,131000,131024', 3, '香河县', 'mainland'),
(131025, 131000, ',130000,131000,131025', 3, '大城县', 'mainland'),
(131026, 131000, ',130000,131000,131026', 3, '文安县', 'mainland'),
(131028, 131000, ',130000,131000,131028', 3, '大厂回族自治县', 'mainland'),
(131051, 131000, ',130000,131000,131051', 3, '开发区', 'mainland'),
(131052, 131000, ',130000,131000,131052', 3, '燕郊经济技术开发区', 'mainland'),
(131081, 131000, ',130000,131000,131081', 3, '霸州市', 'mainland'),
(131082, 131000, ',130000,131000,131082', 3, '三河市', 'mainland'),
(131083, 131000, ',130000,131000,131083', 3, '其它区', 'mainland'),
(131100, 130000, ',130000,131100', 2, '衡水市', 'mainland'),
(131102, 131100, ',130000,131100,131102', 3, '桃城区', 'mainland'),
(131121, 131100, ',130000,131100,131121', 3, '枣强县', 'mainland'),
(131122, 131100, ',130000,131100,131122', 3, '武邑县', 'mainland'),
(131123, 131100, ',130000,131100,131123', 3, '武强县', 'mainland'),
(131124, 131100, ',130000,131100,131124', 3, '饶阳县', 'mainland'),
(131125, 131100, ',130000,131100,131125', 3, '安平县', 'mainland'),
(131126, 131100, ',130000,131100,131126', 3, '故城县', 'mainland'),
(131127, 131100, ',130000,131100,131127', 3, '景县', 'mainland'),
(131128, 131100, ',130000,131100,131128', 3, '阜城县', 'mainland'),
(131181, 131100, ',130000,131100,131181', 3, '冀州市', 'mainland'),
(131182, 131100, ',130000,131100,131182', 3, '深州市', 'mainland'),
(131183, 131100, ',130000,131100,131183', 3, '其它区', 'mainland'),
(140000, 100000, ',140000', 1, '山西省', 'mainland'),
(140100, 140000, ',140000,140100', 2, '太原市', 'mainland'),
(140105, 140100, ',140000,140100,140105', 3, '小店区', 'mainland'),
(140106, 140100, ',140000,140100,140106', 3, '迎泽区', 'mainland'),
(140107, 140100, ',140000,140100,140107', 3, '杏花岭区', 'mainland'),
(140108, 140100, ',140000,140100,140108', 3, '尖草坪区', 'mainland'),
(140109, 140100, ',140000,140100,140109', 3, '万柏林区', 'mainland'),
(140110, 140100, ',140000,140100,140110', 3, '晋源区', 'mainland'),
(140121, 140100, ',140000,140100,140121', 3, '清徐县', 'mainland'),
(140122, 140100, ',140000,140100,140122', 3, '阳曲县', 'mainland'),
(140123, 140100, ',140000,140100,140123', 3, '娄烦县', 'mainland'),
(140181, 140100, ',140000,140100,140181', 3, '古交市', 'mainland'),
(140182, 140100, ',140000,140100,140182', 3, '其它区', 'mainland'),
(140200, 140000, ',140000,140200', 2, '大同市', 'mainland'),
(140202, 140200, ',140000,140200,140202', 3, '城区', 'mainland'),
(140203, 140200, ',140000,140200,140203', 3, '矿区', 'mainland'),
(140211, 140200, ',140000,140200,140211', 3, '南郊区', 'mainland'),
(140212, 140200, ',140000,140200,140212', 3, '新荣区', 'mainland'),
(140221, 140200, ',140000,140200,140221', 3, '阳高县', 'mainland'),
(140222, 140200, ',140000,140200,140222', 3, '天镇县', 'mainland'),
(140223, 140200, ',140000,140200,140223', 3, '广灵县', 'mainland'),
(140224, 140200, ',140000,140200,140224', 3, '灵丘县', 'mainland'),
(140225, 140200, ',140000,140200,140225', 3, '浑源县', 'mainland'),
(140226, 140200, ',140000,140200,140226', 3, '左云县', 'mainland'),
(140227, 140200, ',140000,140200,140227', 3, '大同县', 'mainland'),
(140228, 140200, ',140000,140200,140228', 3, '其它区', 'mainland'),
(140300, 140000, ',140000,140300', 2, '阳泉市', 'mainland'),
(140302, 140300, ',140000,140300,140302', 3, '城区', 'mainland'),
(140303, 140300, ',140000,140300,140303', 3, '矿区', 'mainland'),
(140311, 140300, ',140000,140300,140311', 3, '郊区', 'mainland'),
(140321, 140300, ',140000,140300,140321', 3, '平定县', 'mainland'),
(140322, 140300, ',140000,140300,140322', 3, '盂县', 'mainland'),
(140323, 140300, ',140000,140300,140323', 3, '其它区', 'mainland'),
(140400, 140000, ',140000,140400', 2, '长治市', 'mainland'),
(140421, 140400, ',140000,140400,140421', 3, '长治县', 'mainland'),
(140423, 140400, ',140000,140400,140423', 3, '襄垣县', 'mainland'),
(140424, 140400, ',140000,140400,140424', 3, '屯留县', 'mainland'),
(140425, 140400, ',140000,140400,140425', 3, '平顺县', 'mainland'),
(140426, 140400, ',140000,140400,140426', 3, '黎城县', 'mainland'),
(140427, 140400, ',140000,140400,140427', 3, '壶关县', 'mainland'),
(140428, 140400, ',140000,140400,140428', 3, '长子县', 'mainland'),
(140429, 140400, ',140000,140400,140429', 3, '武乡县', 'mainland'),
(140430, 140400, ',140000,140400,140430', 3, '沁县', 'mainland'),
(140431, 140400, ',140000,140400,140431', 3, '沁源县', 'mainland'),
(140481, 140400, ',140000,140400,140481', 3, '潞城市', 'mainland'),
(140482, 140400, ',140000,140400,140482', 3, '城区', 'mainland'),
(140483, 140400, ',140000,140400,140483', 3, '郊区', 'mainland'),
(140484, 140400, ',140000,140400,140484', 3, '高新区', 'mainland'),
(140485, 140400, ',140000,140400,140485', 3, '其它区', 'mainland'),
(140500, 140000, ',140000,140500', 2, '晋城市', 'mainland'),
(140502, 140500, ',140000,140500,140502', 3, '城区', 'mainland'),
(140521, 140500, ',140000,140500,140521', 3, '沁水县', 'mainland'),
(140522, 140500, ',140000,140500,140522', 3, '阳城县', 'mainland'),
(140524, 140500, ',140000,140500,140524', 3, '陵川县', 'mainland'),
(140525, 140500, ',140000,140500,140525', 3, '泽州县', 'mainland'),
(140581, 140500, ',140000,140500,140581', 3, '高平市', 'mainland'),
(140582, 140500, ',140000,140500,140582', 3, '其它区', 'mainland'),
(140600, 140000, ',140000,140600', 2, '朔州市', 'mainland'),
(140602, 140600, ',140000,140600,140602', 3, '朔城区', 'mainland'),
(140603, 140600, ',140000,140600,140603', 3, '平鲁区', 'mainland'),
(140621, 140600, ',140000,140600,140621', 3, '山阴县', 'mainland'),
(140622, 140600, ',140000,140600,140622', 3, '应县', 'mainland'),
(140623, 140600, ',140000,140600,140623', 3, '右玉县', 'mainland'),
(140624, 140600, ',140000,140600,140624', 3, '怀仁县', 'mainland'),
(140625, 140600, ',140000,140600,140625', 3, '其它区', 'mainland'),
(140700, 140000, ',140000,140700', 2, '晋中市', 'mainland'),
(140702, 140700, ',140000,140700,140702', 3, '榆次区', 'mainland'),
(140721, 140700, ',140000,140700,140721', 3, '榆社县', 'mainland'),
(140722, 140700, ',140000,140700,140722', 3, '左权县', 'mainland'),
(140723, 140700, ',140000,140700,140723', 3, '和顺县', 'mainland'),
(140724, 140700, ',140000,140700,140724', 3, '昔阳县', 'mainland'),
(140725, 140700, ',140000,140700,140725', 3, '寿阳县', 'mainland'),
(140726, 140700, ',140000,140700,140726', 3, '太谷县', 'mainland'),
(140727, 140700, ',140000,140700,140727', 3, '祁县', 'mainland'),
(140728, 140700, ',140000,140700,140728', 3, '平遥县', 'mainland'),
(140729, 140700, ',140000,140700,140729', 3, '灵石县', 'mainland'),
(140781, 140700, ',140000,140700,140781', 3, '介休市', 'mainland'),
(140782, 140700, ',140000,140700,140782', 3, '其它区', 'mainland'),
(140800, 140000, ',140000,140800', 2, '运城市', 'mainland'),
(140802, 140800, ',140000,140800,140802', 3, '盐湖区', 'mainland'),
(140821, 140800, ',140000,140800,140821', 3, '临猗县', 'mainland'),
(140822, 140800, ',140000,140800,140822', 3, '万荣县', 'mainland'),
(140823, 140800, ',140000,140800,140823', 3, '闻喜县', 'mainland'),
(140824, 140800, ',140000,140800,140824', 3, '稷山县', 'mainland'),
(140825, 140800, ',140000,140800,140825', 3, '新绛县', 'mainland'),
(140826, 140800, ',140000,140800,140826', 3, '绛县', 'mainland'),
(140827, 140800, ',140000,140800,140827', 3, '垣曲县', 'mainland'),
(140828, 140800, ',140000,140800,140828', 3, '夏县', 'mainland'),
(140829, 140800, ',140000,140800,140829', 3, '平陆县', 'mainland'),
(140830, 140800, ',140000,140800,140830', 3, '芮城县', 'mainland'),
(140881, 140800, ',140000,140800,140881', 3, '永济市', 'mainland'),
(140882, 140800, ',140000,140800,140882', 3, '河津市', 'mainland'),
(140883, 140800, ',140000,140800,140883', 3, '其它区', 'mainland'),
(140900, 140000, ',140000,140900', 2, '忻州市', 'mainland'),
(140902, 140900, ',140000,140900,140902', 3, '忻府区', 'mainland'),
(140921, 140900, ',140000,140900,140921', 3, '定襄县', 'mainland'),
(140922, 140900, ',140000,140900,140922', 3, '五台县', 'mainland'),
(140923, 140900, ',140000,140900,140923', 3, '代县', 'mainland'),
(140924, 140900, ',140000,140900,140924', 3, '繁峙县', 'mainland'),
(140925, 140900, ',140000,140900,140925', 3, '宁武县', 'mainland'),
(140926, 140900, ',140000,140900,140926', 3, '静乐县', 'mainland'),
(140927, 140900, ',140000,140900,140927', 3, '神池县', 'mainland'),
(140928, 140900, ',140000,140900,140928', 3, '五寨县', 'mainland'),
(140929, 140900, ',140000,140900,140929', 3, '岢岚县', 'mainland'),
(140930, 140900, ',140000,140900,140930', 3, '河曲县', 'mainland'),
(140931, 140900, ',140000,140900,140931', 3, '保德县', 'mainland'),
(140932, 140900, ',140000,140900,140932', 3, '偏关县', 'mainland'),
(140981, 140900, ',140000,140900,140981', 3, '原平市', 'mainland'),
(140982, 140900, ',140000,140900,140982', 3, '其它区', 'mainland'),
(141000, 140000, ',140000,141000', 2, '临汾市', 'mainland'),
(141002, 141000, ',140000,141000,141002', 3, '尧都区', 'mainland'),
(141021, 141000, ',140000,141000,141021', 3, '曲沃县', 'mainland'),
(141022, 141000, ',140000,141000,141022', 3, '翼城县', 'mainland'),
(141023, 141000, ',140000,141000,141023', 3, '襄汾县', 'mainland'),
(141024, 141000, ',140000,141000,141024', 3, '洪洞县', 'mainland'),
(141025, 141000, ',140000,141000,141025', 3, '古县', 'mainland'),
(141026, 141000, ',140000,141000,141026', 3, '安泽县', 'mainland'),
(141027, 141000, ',140000,141000,141027', 3, '浮山县', 'mainland'),
(141028, 141000, ',140000,141000,141028', 3, '吉县', 'mainland'),
(141029, 141000, ',140000,141000,141029', 3, '乡宁县', 'mainland'),
(141030, 141000, ',140000,141000,141030', 3, '大宁县', 'mainland'),
(141031, 141000, ',140000,141000,141031', 3, '隰县', 'mainland'),
(141032, 141000, ',140000,141000,141032', 3, '永和县', 'mainland'),
(141033, 141000, ',140000,141000,141033', 3, '蒲县', 'mainland'),
(141034, 141000, ',140000,141000,141034', 3, '汾西县', 'mainland'),
(141081, 141000, ',140000,141000,141081', 3, '侯马市', 'mainland'),
(141082, 141000, ',140000,141000,141082', 3, '霍州市', 'mainland'),
(141083, 141000, ',140000,141000,141083', 3, '其它区', 'mainland'),
(141100, 140000, ',140000,141100', 2, '吕梁市', 'mainland'),
(141102, 141100, ',140000,141100,141102', 3, '离石区', 'mainland'),
(141121, 141100, ',140000,141100,141121', 3, '文水县', 'mainland'),
(141122, 141100, ',140000,141100,141122', 3, '交城县', 'mainland'),
(141123, 141100, ',140000,141100,141123', 3, '兴县', 'mainland'),
(141124, 141100, ',140000,141100,141124', 3, '临县', 'mainland'),
(141125, 141100, ',140000,141100,141125', 3, '柳林县', 'mainland'),
(141126, 141100, ',140000,141100,141126', 3, '石楼县', 'mainland'),
(141127, 141100, ',140000,141100,141127', 3, '岚县', 'mainland'),
(141128, 141100, ',140000,141100,141128', 3, '方山县', 'mainland'),
(141129, 141100, ',140000,141100,141129', 3, '中阳县', 'mainland'),
(141130, 141100, ',140000,141100,141130', 3, '交口县', 'mainland'),
(141181, 141100, ',140000,141100,141181', 3, '孝义市', 'mainland'),
(141182, 141100, ',140000,141100,141182', 3, '汾阳市', 'mainland'),
(141183, 141100, ',140000,141100,141183', 3, '其它区', 'mainland'),
(150000, 100000, ',150000', 1, '内蒙古自治区', 'mainland'),
(150100, 150000, ',150000,150100', 2, '呼和浩特市', 'mainland'),
(150102, 150100, ',150000,150100,150102', 3, '新城区', 'mainland'),
(150103, 150100, ',150000,150100,150103', 3, '回民区', 'mainland'),
(150104, 150100, ',150000,150100,150104', 3, '玉泉区', 'mainland'),
(150105, 150100, ',150000,150100,150105', 3, '赛罕区', 'mainland'),
(150121, 150100, ',150000,150100,150121', 3, '土默特左旗', 'mainland'),
(150122, 150100, ',150000,150100,150122', 3, '托克托县', 'mainland'),
(150123, 150100, ',150000,150100,150123', 3, '和林格尔县', 'mainland'),
(150124, 150100, ',150000,150100,150124', 3, '清水河县', 'mainland'),
(150125, 150100, ',150000,150100,150125', 3, '武川县', 'mainland'),
(150126, 150100, ',150000,150100,150126', 3, '其它区', 'mainland'),
(150200, 150000, ',150000,150200', 2, '包头市', 'mainland'),
(150202, 150200, ',150000,150200,150202', 3, '东河区', 'mainland'),
(150203, 150200, ',150000,150200,150203', 3, '昆都仑区', 'mainland'),
(150204, 150200, ',150000,150200,150204', 3, '青山区', 'mainland'),
(150205, 150200, ',150000,150200,150205', 3, '石拐区', 'mainland'),
(150206, 150200, ',150000,150200,150206', 3, '白云矿区', 'mainland'),
(150207, 150200, ',150000,150200,150207', 3, '九原区', 'mainland'),
(150221, 150200, ',150000,150200,150221', 3, '土默特右旗', 'mainland'),
(150222, 150200, ',150000,150200,150222', 3, '固阳县', 'mainland'),
(150223, 150200, ',150000,150200,150223', 3, '达尔罕茂明安联合旗', 'mainland'),
(150224, 150200, ',150000,150200,150224', 3, '其它区', 'mainland'),
(150300, 150000, ',150000,150300', 2, '乌海市', 'mainland'),
(150302, 150300, ',150000,150300,150302', 3, '海勃湾区', 'mainland'),
(150303, 150300, ',150000,150300,150303', 3, '海南区', 'mainland'),
(150304, 150300, ',150000,150300,150304', 3, '乌达区', 'mainland'),
(150305, 150300, ',150000,150300,150305', 3, '其它区', 'mainland'),
(150400, 150000, ',150000,150400', 2, '赤峰市', 'mainland'),
(150402, 150400, ',150000,150400,150402', 3, '红山区', 'mainland'),
(150403, 150400, ',150000,150400,150403', 3, '元宝山区', 'mainland'),
(150404, 150400, ',150000,150400,150404', 3, '松山区', 'mainland'),
(150421, 150400, ',150000,150400,150421', 3, '阿鲁科尔沁旗', 'mainland'),
(150422, 150400, ',150000,150400,150422', 3, '巴林左旗', 'mainland'),
(150423, 150400, ',150000,150400,150423', 3, '巴林右旗', 'mainland'),
(150424, 150400, ',150000,150400,150424', 3, '林西县', 'mainland'),
(150425, 150400, ',150000,150400,150425', 3, '克什克腾旗', 'mainland'),
(150426, 150400, ',150000,150400,150426', 3, '翁牛特旗', 'mainland'),
(150428, 150400, ',150000,150400,150428', 3, '喀喇沁旗', 'mainland'),
(150429, 150400, ',150000,150400,150429', 3, '宁城县', 'mainland'),
(150430, 150400, ',150000,150400,150430', 3, '敖汉旗', 'mainland'),
(150431, 150400, ',150000,150400,150431', 3, '其它区', 'mainland'),
(150500, 150000, ',150000,150500', 2, '通辽市', 'mainland'),
(150502, 150500, ',150000,150500,150502', 3, '科尔沁区', 'mainland'),
(150521, 150500, ',150000,150500,150521', 3, '科尔沁左翼中旗', 'mainland'),
(150522, 150500, ',150000,150500,150522', 3, '科尔沁左翼后旗', 'mainland'),
(150523, 150500, ',150000,150500,150523', 3, '开鲁县', 'mainland'),
(150524, 150500, ',150000,150500,150524', 3, '库伦旗', 'mainland'),
(150525, 150500, ',150000,150500,150525', 3, '奈曼旗', 'mainland'),
(150526, 150500, ',150000,150500,150526', 3, '扎鲁特旗', 'mainland'),
(150581, 150500, ',150000,150500,150581', 3, '霍林郭勒市', 'mainland'),
(150582, 150500, ',150000,150500,150582', 3, '其它区', 'mainland'),
(150600, 150000, ',150000,150600', 2, '鄂尔多斯市', 'mainland'),
(150602, 150600, ',150000,150600,150602', 3, '东胜区', 'mainland'),
(150621, 150600, ',150000,150600,150621', 3, '达拉特旗', 'mainland'),
(150622, 150600, ',150000,150600,150622', 3, '准格尔旗', 'mainland'),
(150623, 150600, ',150000,150600,150623', 3, '鄂托克前旗', 'mainland'),
(150624, 150600, ',150000,150600,150624', 3, '鄂托克旗', 'mainland'),
(150625, 150600, ',150000,150600,150625', 3, '杭锦旗', 'mainland'),
(150626, 150600, ',150000,150600,150626', 3, '乌审旗', 'mainland'),
(150627, 150600, ',150000,150600,150627', 3, '伊金霍洛旗', 'mainland'),
(150628, 150600, ',150000,150600,150628', 3, '其它区', 'mainland'),
(150700, 150000, ',150000,150700', 2, '呼伦贝尔市', 'mainland'),
(150702, 150700, ',150000,150700,150702', 3, '海拉尔区', 'mainland'),
(150721, 150700, ',150000,150700,150721', 3, '阿荣旗', 'mainland'),
(150722, 150700, ',150000,150700,150722', 3, '莫力达瓦达斡尔族自治旗', 'mainland'),
(150723, 150700, ',150000,150700,150723', 3, '鄂伦春自治旗', 'mainland'),
(150724, 150700, ',150000,150700,150724', 3, '鄂温克族自治旗', 'mainland'),
(150725, 150700, ',150000,150700,150725', 3, '陈巴尔虎旗', 'mainland'),
(150726, 150700, ',150000,150700,150726', 3, '新巴尔虎左旗', 'mainland'),
(150727, 150700, ',150000,150700,150727', 3, '新巴尔虎右旗', 'mainland'),
(150781, 150700, ',150000,150700,150781', 3, '满洲里市', 'mainland'),
(150782, 150700, ',150000,150700,150782', 3, '牙克石市', 'mainland'),
(150783, 150700, ',150000,150700,150783', 3, '扎兰屯市', 'mainland'),
(150784, 150700, ',150000,150700,150784', 3, '额尔古纳市', 'mainland'),
(150785, 150700, ',150000,150700,150785', 3, '根河市', 'mainland'),
(150786, 150700, ',150000,150700,150786', 3, '其它区', 'mainland'),
(150800, 150000, ',150000,150800', 2, '巴彦淖尔市', 'mainland'),
(150802, 150800, ',150000,150800,150802', 3, '临河区', 'mainland'),
(150821, 150800, ',150000,150800,150821', 3, '五原县', 'mainland'),
(150822, 150800, ',150000,150800,150822', 3, '磴口县', 'mainland'),
(150823, 150800, ',150000,150800,150823', 3, '乌拉特前旗', 'mainland'),
(150824, 150800, ',150000,150800,150824', 3, '乌拉特中旗', 'mainland'),
(150825, 150800, ',150000,150800,150825', 3, '乌拉特后旗', 'mainland'),
(150826, 150800, ',150000,150800,150826', 3, '杭锦后旗', 'mainland'),
(150827, 150800, ',150000,150800,150827', 3, '其它区', 'mainland'),
(150900, 150000, ',150000,150900', 2, '乌兰察布市', 'mainland'),
(150902, 150900, ',150000,150900,150902', 3, '集宁区', 'mainland'),
(150921, 150900, ',150000,150900,150921', 3, '卓资县', 'mainland'),
(150922, 150900, ',150000,150900,150922', 3, '化德县', 'mainland'),
(150923, 150900, ',150000,150900,150923', 3, '商都县', 'mainland'),
(150924, 150900, ',150000,150900,150924', 3, '兴和县', 'mainland'),
(150925, 150900, ',150000,150900,150925', 3, '凉城县', 'mainland'),
(150926, 150900, ',150000,150900,150926', 3, '察哈尔右翼前旗', 'mainland'),
(150927, 150900, ',150000,150900,150927', 3, '察哈尔右翼中旗', 'mainland'),
(150928, 150900, ',150000,150900,150928', 3, '察哈尔右翼后旗', 'mainland'),
(150929, 150900, ',150000,150900,150929', 3, '四子王旗', 'mainland'),
(150981, 150900, ',150000,150900,150981', 3, '丰镇市', 'mainland'),
(150982, 150900, ',150000,150900,150982', 3, '其它区', 'mainland'),
(152200, 150000, ',150000,152200', 2, '兴安盟', 'mainland'),
(152201, 152200, ',150000,152200,152201', 3, '乌兰浩特市', 'mainland'),
(152202, 152200, ',150000,152200,152202', 3, '阿尔山市', 'mainland'),
(152221, 152200, ',150000,152200,152221', 3, '科尔沁右翼前旗', 'mainland'),
(152222, 152200, ',150000,152200,152222', 3, '科尔沁右翼中旗', 'mainland'),
(152223, 152200, ',150000,152200,152223', 3, '扎赉特旗', 'mainland'),
(152224, 152200, ',150000,152200,152224', 3, '突泉县', 'mainland'),
(152225, 152200, ',150000,152200,152225', 3, '其它区', 'mainland'),
(152500, 150000, ',150000,152500', 2, '锡林郭勒盟', 'mainland'),
(152501, 152500, ',150000,152500,152501', 3, '二连浩特市', 'mainland'),
(152502, 152500, ',150000,152500,152502', 3, '锡林浩特市', 'mainland'),
(152522, 152500, ',150000,152500,152522', 3, '阿巴嘎旗', 'mainland'),
(152523, 152500, ',150000,152500,152523', 3, '苏尼特左旗', 'mainland'),
(152524, 152500, ',150000,152500,152524', 3, '苏尼特右旗', 'mainland'),
(152525, 152500, ',150000,152500,152525', 3, '东乌珠穆沁旗', 'mainland'),
(152526, 152500, ',150000,152500,152526', 3, '西乌珠穆沁旗', 'mainland'),
(152527, 152500, ',150000,152500,152527', 3, '太仆寺旗', 'mainland'),
(152528, 152500, ',150000,152500,152528', 3, '镶黄旗', 'mainland'),
(152529, 152500, ',150000,152500,152529', 3, '正镶白旗', 'mainland'),
(152530, 152500, ',150000,152500,152530', 3, '正蓝旗', 'mainland'),
(152531, 152500, ',150000,152500,152531', 3, '多伦县', 'mainland'),
(152532, 152500, ',150000,152500,152532', 3, '其它区', 'mainland'),
(152900, 150000, ',150000,152900', 2, '阿拉善盟', 'mainland'),
(152921, 152900, ',150000,152900,152921', 3, '阿拉善左旗', 'mainland'),
(152922, 152900, ',150000,152900,152922', 3, '阿拉善右旗', 'mainland'),
(152923, 152900, ',150000,152900,152923', 3, '额济纳旗', 'mainland'),
(152924, 152900, ',150000,152900,152924', 3, '其它区', 'mainland'),
(210000, 100000, ',210000', 1, '辽宁省', 'mainland'),
(210100, 210000, ',210000,210100', 2, '沈阳市', 'mainland'),
(210102, 210100, ',210000,210100,210102', 3, '和平区', 'mainland'),
(210103, 210100, ',210000,210100,210103', 3, '沈河区', 'mainland'),
(210104, 210100, ',210000,210100,210104', 3, '大东区', 'mainland'),
(210105, 210100, ',210000,210100,210105', 3, '皇姑区', 'mainland'),
(210106, 210100, ',210000,210100,210106', 3, '铁西区', 'mainland'),
(210111, 210100, ',210000,210100,210111', 3, '苏家屯区', 'mainland'),
(210112, 210100, ',210000,210100,210112', 3, '东陵区', 'mainland'),
(210113, 210100, ',210000,210100,210113', 3, '新城子区', 'mainland'),
(210114, 210100, ',210000,210100,210114', 3, '于洪区', 'mainland'),
(210122, 210100, ',210000,210100,210122', 3, '辽中县', 'mainland'),
(210123, 210100, ',210000,210100,210123', 3, '康平县', 'mainland'),
(210124, 210100, ',210000,210100,210124', 3, '法库县', 'mainland'),
(210181, 210100, ',210000,210100,210181', 3, '新民市', 'mainland'),
(210182, 210100, ',210000,210100,210182', 3, '浑南新区', 'mainland'),
(210183, 210100, ',210000,210100,210183', 3, '张士开发区', 'mainland'),
(210184, 210100, ',210000,210100,210184', 3, '沈北新区', 'mainland'),
(210185, 210100, ',210000,210100,210185', 3, '其它区', 'mainland'),
(210200, 210000, ',210000,210200', 2, '大连市', 'mainland'),
(210202, 210200, ',210000,210200,210202', 3, '中山区', 'mainland'),
(210203, 210200, ',210000,210200,210203', 3, '西岗区', 'mainland'),
(210204, 210200, ',210000,210200,210204', 3, '沙河口区', 'mainland'),
(210211, 210200, ',210000,210200,210211', 3, '甘井子区', 'mainland'),
(210212, 210200, ',210000,210200,210212', 3, '旅顺口区', 'mainland'),
(210213, 210200, ',210000,210200,210213', 3, '金州区', 'mainland'),
(210224, 210200, ',210000,210200,210224', 3, '长海县', 'mainland'),
(210251, 210200, ',210000,210200,210251', 3, '开发区', 'mainland'),
(210281, 210200, ',210000,210200,210281', 3, '瓦房店市', 'mainland'),
(210282, 210200, ',210000,210200,210282', 3, '普兰店市', 'mainland'),
(210283, 210200, ',210000,210200,210283', 3, '庄河市', 'mainland'),
(210297, 210200, ',210000,210200,210297', 3, '岭前区', 'mainland'),
(210298, 210200, ',210000,210200,210298', 3, '其它区', 'mainland'),
(210300, 210000, ',210000,210300', 2, '鞍山市', 'mainland'),
(210302, 210300, ',210000,210300,210302', 3, '铁东区', 'mainland'),
(210303, 210300, ',210000,210300,210303', 3, '铁西区', 'mainland'),
(210304, 210300, ',210000,210300,210304', 3, '立山区', 'mainland'),
(210311, 210300, ',210000,210300,210311', 3, '千山区', 'mainland'),
(210321, 210300, ',210000,210300,210321', 3, '台安县', 'mainland'),
(210323, 210300, ',210000,210300,210323', 3, '岫岩满族自治县', 'mainland'),
(210351, 210300, ',210000,210300,210351', 3, '高新区', 'mainland'),
(210381, 210300, ',210000,210300,210381', 3, '海城市', 'mainland'),
(210382, 210300, ',210000,210300,210382', 3, '其它区', 'mainland'),
(210400, 210000, ',210000,210400', 2, '抚顺市', 'mainland'),
(210402, 210400, ',210000,210400,210402', 3, '新抚区', 'mainland'),
(210403, 210400, ',210000,210400,210403', 3, '东洲区', 'mainland'),
(210404, 210400, ',210000,210400,210404', 3, '望花区', 'mainland'),
(210411, 210400, ',210000,210400,210411', 3, '顺城区', 'mainland'),
(210421, 210400, ',210000,210400,210421', 3, '抚顺县', 'mainland'),
(210422, 210400, ',210000,210400,210422', 3, '新宾满族自治县', 'mainland'),
(210423, 210400, ',210000,210400,210423', 3, '清原满族自治县', 'mainland'),
(210424, 210400, ',210000,210400,210424', 3, '其它区', 'mainland'),
(210500, 210000, ',210000,210500', 2, '本溪市', 'mainland'),
(210502, 210500, ',210000,210500,210502', 3, '平山区', 'mainland'),
(210503, 210500, ',210000,210500,210503', 3, '溪湖区', 'mainland'),
(210504, 210500, ',210000,210500,210504', 3, '明山区', 'mainland'),
(210505, 210500, ',210000,210500,210505', 3, '南芬区', 'mainland'),
(210521, 210500, ',210000,210500,210521', 3, '本溪满族自治县', 'mainland'),
(210522, 210500, ',210000,210500,210522', 3, '桓仁满族自治县', 'mainland'),
(210523, 210500, ',210000,210500,210523', 3, '其它区', 'mainland'),
(210600, 210000, ',210000,210600', 2, '丹东市', 'mainland'),
(210602, 210600, ',210000,210600,210602', 3, '元宝区', 'mainland'),
(210603, 210600, ',210000,210600,210603', 3, '振兴区', 'mainland'),
(210604, 210600, ',210000,210600,210604', 3, '振安区', 'mainland'),
(210624, 210600, ',210000,210600,210624', 3, '宽甸满族自治县', 'mainland'),
(210681, 210600, ',210000,210600,210681', 3, '东港市', 'mainland'),
(210682, 210600, ',210000,210600,210682', 3, '凤城市', 'mainland'),
(210683, 210600, ',210000,210600,210683', 3, '其它区', 'mainland'),
(210700, 210000, ',210000,210700', 2, '锦州市', 'mainland'),
(210702, 210700, ',210000,210700,210702', 3, '古塔区', 'mainland'),
(210703, 210700, ',210000,210700,210703', 3, '凌河区', 'mainland'),
(210711, 210700, ',210000,210700,210711', 3, '太和区', 'mainland'),
(210726, 210700, ',210000,210700,210726', 3, '黑山县', 'mainland'),
(210727, 210700, ',210000,210700,210727', 3, '义县', 'mainland'),
(210781, 210700, ',210000,210700,210781', 3, '凌海市', 'mainland'),
(210782, 210700, ',210000,210700,210782', 3, '北镇市', 'mainland'),
(210783, 210700, ',210000,210700,210783', 3, '其它区', 'mainland'),
(210800, 210000, ',210000,210800', 2, '营口市', 'mainland'),
(210802, 210800, ',210000,210800,210802', 3, '站前区', 'mainland'),
(210803, 210800, ',210000,210800,210803', 3, '西市区', 'mainland'),
(210804, 210800, ',210000,210800,210804', 3, '鲅鱼圈区', 'mainland'),
(210811, 210800, ',210000,210800,210811', 3, '老边区', 'mainland'),
(210881, 210800, ',210000,210800,210881', 3, '盖州市', 'mainland'),
(210882, 210800, ',210000,210800,210882', 3, '大石桥市', 'mainland'),
(210883, 210800, ',210000,210800,210883', 3, '其它区', 'mainland'),
(210900, 210000, ',210000,210900', 2, '阜新市', 'mainland'),
(210902, 210900, ',210000,210900,210902', 3, '海州区', 'mainland'),
(210903, 210900, ',210000,210900,210903', 3, '新邱区', 'mainland'),
(210904, 210900, ',210000,210900,210904', 3, '太平区', 'mainland'),
(210905, 210900, ',210000,210900,210905', 3, '清河门区', 'mainland'),
(210911, 210900, ',210000,210900,210911', 3, '细河区', 'mainland'),
(210921, 210900, ',210000,210900,210921', 3, '阜新蒙古族自治县', 'mainland'),
(210922, 210900, ',210000,210900,210922', 3, '彰武县', 'mainland'),
(210923, 210900, ',210000,210900,210923', 3, '其它区', 'mainland'),
(211000, 210000, ',210000,211000', 2, '辽阳市', 'mainland'),
(211002, 211000, ',210000,211000,211002', 3, '白塔区', 'mainland'),
(211003, 211000, ',210000,211000,211003', 3, '文圣区', 'mainland'),
(211004, 211000, ',210000,211000,211004', 3, '宏伟区', 'mainland'),
(211005, 211000, ',210000,211000,211005', 3, '弓长岭区', 'mainland'),
(211011, 211000, ',210000,211000,211011', 3, '太子河区', 'mainland'),
(211021, 211000, ',210000,211000,211021', 3, '辽阳县', 'mainland'),
(211081, 211000, ',210000,211000,211081', 3, '灯塔市', 'mainland'),
(211082, 211000, ',210000,211000,211082', 3, '其它区', 'mainland'),
(211100, 210000, ',210000,211100', 2, '盘锦市', 'mainland'),
(211102, 211100, ',210000,211100,211102', 3, '双台子区', 'mainland'),
(211103, 211100, ',210000,211100,211103', 3, '兴隆台区', 'mainland'),
(211121, 211100, ',210000,211100,211121', 3, '大洼县', 'mainland'),
(211122, 211100, ',210000,211100,211122', 3, '盘山县', 'mainland'),
(211123, 211100, ',210000,211100,211123', 3, '其它区', 'mainland'),
(211200, 210000, ',210000,211200', 2, '铁岭市', 'mainland'),
(211202, 211200, ',210000,211200,211202', 3, '银州区', 'mainland'),
(211204, 211200, ',210000,211200,211204', 3, '清河区', 'mainland'),
(211221, 211200, ',210000,211200,211221', 3, '铁岭县', 'mainland'),
(211223, 211200, ',210000,211200,211223', 3, '西丰县', 'mainland'),
(211224, 211200, ',210000,211200,211224', 3, '昌图县', 'mainland'),
(211281, 211200, ',210000,211200,211281', 3, '调兵山市', 'mainland'),
(211282, 211200, ',210000,211200,211282', 3, '开原市', 'mainland'),
(211283, 211200, ',210000,211200,211283', 3, '其它区', 'mainland'),
(211300, 210000, ',210000,211300', 2, '朝阳市', 'mainland'),
(211302, 211300, ',210000,211300,211302', 3, '双塔区', 'mainland'),
(211303, 211300, ',210000,211300,211303', 3, '龙城区', 'mainland'),
(211321, 211300, ',210000,211300,211321', 3, '朝阳县', 'mainland'),
(211322, 211300, ',210000,211300,211322', 3, '建平县', 'mainland'),
(211324, 211300, ',210000,211300,211324', 3, '喀喇沁左翼蒙古族自治县', 'mainland'),
(211381, 211300, ',210000,211300,211381', 3, '北票市', 'mainland'),
(211382, 211300, ',210000,211300,211382', 3, '凌源市', 'mainland'),
(211383, 211300, ',210000,211300,211383', 3, '其它区', 'mainland'),
(211400, 210000, ',210000,211400', 2, '葫芦岛市', 'mainland'),
(211402, 211400, ',210000,211400,211402', 3, '连山区', 'mainland'),
(211403, 211400, ',210000,211400,211403', 3, '龙港区', 'mainland'),
(211404, 211400, ',210000,211400,211404', 3, '南票区', 'mainland'),
(211421, 211400, ',210000,211400,211421', 3, '绥中县', 'mainland'),
(211422, 211400, ',210000,211400,211422', 3, '建昌县', 'mainland'),
(211481, 211400, ',210000,211400,211481', 3, '兴城市', 'mainland'),
(211482, 211400, ',210000,211400,211482', 3, '其它区', 'mainland'),
(220000, 100000, ',220000', 1, '吉林省', 'mainland'),
(220100, 220000, ',220000,220100', 2, '长春市', 'mainland'),
(220102, 220100, ',220000,220100,220102', 3, '南关区', 'mainland'),
(220103, 220100, ',220000,220100,220103', 3, '宽城区', 'mainland'),
(220104, 220100, ',220000,220100,220104', 3, '朝阳区', 'mainland'),
(220105, 220100, ',220000,220100,220105', 3, '二道区', 'mainland'),
(220106, 220100, ',220000,220100,220106', 3, '绿园区', 'mainland'),
(220112, 220100, ',220000,220100,220112', 3, '双阳区', 'mainland'),
(220122, 220100, ',220000,220100,220122', 3, '农安县', 'mainland'),
(220181, 220100, ',220000,220100,220181', 3, '九台市', 'mainland'),
(220182, 220100, ',220000,220100,220182', 3, '榆树市', 'mainland'),
(220183, 220100, ',220000,220100,220183', 3, '德惠市', 'mainland'),
(220184, 220100, ',220000,220100,220184', 3, '高新技术产业开发区', 'mainland'),
(220185, 220100, ',220000,220100,220185', 3, '汽车产业开发区', 'mainland'),
(220186, 220100, ',220000,220100,220186', 3, '经济技术开发区', 'mainland'),
(220187, 220100, ',220000,220100,220187', 3, '净月旅游开发区', 'mainland'),
(220188, 220100, ',220000,220100,220188', 3, '其它区', 'mainland'),
(220200, 220000, ',220000,220200', 2, '吉林市', 'mainland'),
(220202, 220200, ',220000,220200,220202', 3, '昌邑区', 'mainland'),
(220203, 220200, ',220000,220200,220203', 3, '龙潭区', 'mainland'),
(220204, 220200, ',220000,220200,220204', 3, '船营区', 'mainland'),
(220211, 220200, ',220000,220200,220211', 3, '丰满区', 'mainland'),
(220221, 220200, ',220000,220200,220221', 3, '永吉县', 'mainland'),
(220281, 220200, ',220000,220200,220281', 3, '蛟河市', 'mainland'),
(220282, 220200, ',220000,220200,220282', 3, '桦甸市', 'mainland'),
(220283, 220200, ',220000,220200,220283', 3, '舒兰市', 'mainland'),
(220284, 220200, ',220000,220200,220284', 3, '磐石市', 'mainland'),
(220285, 220200, ',220000,220200,220285', 3, '其它区', 'mainland'),
(220300, 220000, ',220000,220300', 2, '四平市', 'mainland'),
(220302, 220300, ',220000,220300,220302', 3, '铁西区', 'mainland'),
(220303, 220300, ',220000,220300,220303', 3, '铁东区', 'mainland'),
(220322, 220300, ',220000,220300,220322', 3, '梨树县', 'mainland'),
(220323, 220300, ',220000,220300,220323', 3, '伊通满族自治县', 'mainland'),
(220381, 220300, ',220000,220300,220381', 3, '公主岭市', 'mainland'),
(220382, 220300, ',220000,220300,220382', 3, '双辽市', 'mainland'),
(220383, 220300, ',220000,220300,220383', 3, '其它区', 'mainland'),
(220400, 220000, ',220000,220400', 2, '辽源市', 'mainland'),
(220402, 220400, ',220000,220400,220402', 3, '龙山区', 'mainland'),
(220403, 220400, ',220000,220400,220403', 3, '西安区', 'mainland'),
(220421, 220400, ',220000,220400,220421', 3, '东丰县', 'mainland'),
(220422, 220400, ',220000,220400,220422', 3, '东辽县', 'mainland'),
(220423, 220400, ',220000,220400,220423', 3, '其它区', 'mainland'),
(220500, 220000, ',220000,220500', 2, '通化市', 'mainland'),
(220502, 220500, ',220000,220500,220502', 3, '东昌区', 'mainland'),
(220503, 220500, ',220000,220500,220503', 3, '二道江区', 'mainland'),
(220521, 220500, ',220000,220500,220521', 3, '通化县', 'mainland'),
(220523, 220500, ',220000,220500,220523', 3, '辉南县', 'mainland'),
(220524, 220500, ',220000,220500,220524', 3, '柳河县', 'mainland'),
(220581, 220500, ',220000,220500,220581', 3, '梅河口市', 'mainland'),
(220582, 220500, ',220000,220500,220582', 3, '集安市', 'mainland'),
(220583, 220500, ',220000,220500,220583', 3, '其它区', 'mainland'),
(220600, 220000, ',220000,220600', 2, '白山市', 'mainland'),
(220602, 220600, ',220000,220600,220602', 3, '八道江区', 'mainland'),
(220621, 220600, ',220000,220600,220621', 3, '抚松县', 'mainland'),
(220622, 220600, ',220000,220600,220622', 3, '靖宇县', 'mainland'),
(220623, 220600, ',220000,220600,220623', 3, '长白朝鲜族自治县', 'mainland'),
(220625, 220600, ',220000,220600,220625', 3, '江源县', 'mainland'),
(220681, 220600, ',220000,220600,220681', 3, '临江市', 'mainland'),
(220682, 220600, ',220000,220600,220682', 3, '其它区', 'mainland'),
(220700, 220000, ',220000,220700', 2, '松原市', 'mainland'),
(220702, 220700, ',220000,220700,220702', 3, '宁江区', 'mainland'),
(220721, 220700, ',220000,220700,220721', 3, '前郭尔罗斯蒙古族自治县', 'mainland'),
(220722, 220700, ',220000,220700,220722', 3, '长岭县', 'mainland'),
(220723, 220700, ',220000,220700,220723', 3, '乾安县', 'mainland'),
(220724, 220700, ',220000,220700,220724', 3, '扶余县', 'mainland'),
(220725, 220700, ',220000,220700,220725', 3, '其它区', 'mainland'),
(220800, 220000, ',220000,220800', 2, '白城市', 'mainland'),
(220802, 220800, ',220000,220800,220802', 3, '洮北区', 'mainland'),
(220821, 220800, ',220000,220800,220821', 3, '镇赉县', 'mainland'),
(220822, 220800, ',220000,220800,220822', 3, '通榆县', 'mainland'),
(220881, 220800, ',220000,220800,220881', 3, '洮南市', 'mainland'),
(220882, 220800, ',220000,220800,220882', 3, '大安市', 'mainland'),
(220883, 220800, ',220000,220800,220883', 3, '其它区', 'mainland');
INSERT INTO `area` (`area_id`, `parent_id`, `path`, `grade`, `name`, `language`) VALUES
(222400, 220000, ',220000,222400', 2, '延边朝鲜族自治州', 'mainland'),
(222401, 222400, ',220000,222400,222401', 3, '延吉市', 'mainland'),
(222402, 222400, ',220000,222400,222402', 3, '图们市', 'mainland'),
(222403, 222400, ',220000,222400,222403', 3, '敦化市', 'mainland'),
(222404, 222400, ',220000,222400,222404', 3, '珲春市', 'mainland'),
(222405, 222400, ',220000,222400,222405', 3, '龙井市', 'mainland'),
(222406, 222400, ',220000,222400,222406', 3, '和龙市', 'mainland'),
(222424, 222400, ',220000,222400,222424', 3, '汪清县', 'mainland'),
(222426, 222400, ',220000,222400,222426', 3, '安图县', 'mainland'),
(222427, 222400, ',220000,222400,222427', 3, '其它区', 'mainland'),
(230000, 100000, ',230000', 1, '黑龙江省', 'mainland'),
(230100, 230000, ',230000,230100', 2, '哈尔滨市', 'mainland'),
(230102, 230100, ',230000,230100,230102', 3, '道里区', 'mainland'),
(230103, 230100, ',230000,230100,230103', 3, '南岗区', 'mainland'),
(230104, 230100, ',230000,230100,230104', 3, '道外区', 'mainland'),
(230106, 230100, ',230000,230100,230106', 3, '香坊区', 'mainland'),
(230107, 230100, ',230000,230100,230107', 3, '动力区', 'mainland'),
(230108, 230100, ',230000,230100,230108', 3, '平房区', 'mainland'),
(230109, 230100, ',230000,230100,230109', 3, '松北区', 'mainland'),
(230111, 230100, ',230000,230100,230111', 3, '呼兰区', 'mainland'),
(230123, 230100, ',230000,230100,230123', 3, '依兰县', 'mainland'),
(230124, 230100, ',230000,230100,230124', 3, '方正县', 'mainland'),
(230125, 230100, ',230000,230100,230125', 3, '宾县', 'mainland'),
(230126, 230100, ',230000,230100,230126', 3, '巴彦县', 'mainland'),
(230127, 230100, ',230000,230100,230127', 3, '木兰县', 'mainland'),
(230128, 230100, ',230000,230100,230128', 3, '通河县', 'mainland'),
(230129, 230100, ',230000,230100,230129', 3, '延寿县', 'mainland'),
(230181, 230100, ',230000,230100,230181', 3, '阿城市', 'mainland'),
(230182, 230100, ',230000,230100,230182', 3, '双城市', 'mainland'),
(230183, 230100, ',230000,230100,230183', 3, '尚志市', 'mainland'),
(230184, 230100, ',230000,230100,230184', 3, '五常市', 'mainland'),
(230185, 230100, ',230000,230100,230185', 3, '阿城市', 'mainland'),
(230186, 230100, ',230000,230100,230186', 3, '其它区', 'mainland'),
(230200, 230000, ',230000,230200', 2, '齐齐哈尔市', 'mainland'),
(230202, 230200, ',230000,230200,230202', 3, '龙沙区', 'mainland'),
(230203, 230200, ',230000,230200,230203', 3, '建华区', 'mainland'),
(230204, 230200, ',230000,230200,230204', 3, '铁锋区', 'mainland'),
(230205, 230200, ',230000,230200,230205', 3, '昂昂溪区', 'mainland'),
(230206, 230200, ',230000,230200,230206', 3, '富拉尔基区', 'mainland'),
(230207, 230200, ',230000,230200,230207', 3, '碾子山区', 'mainland'),
(230208, 230200, ',230000,230200,230208', 3, '梅里斯达斡尔族区', 'mainland'),
(230221, 230200, ',230000,230200,230221', 3, '龙江县', 'mainland'),
(230223, 230200, ',230000,230200,230223', 3, '依安县', 'mainland'),
(230224, 230200, ',230000,230200,230224', 3, '泰来县', 'mainland'),
(230225, 230200, ',230000,230200,230225', 3, '甘南县', 'mainland'),
(230227, 230200, ',230000,230200,230227', 3, '富裕县', 'mainland'),
(230229, 230200, ',230000,230200,230229', 3, '克山县', 'mainland'),
(230230, 230200, ',230000,230200,230230', 3, '克东县', 'mainland'),
(230231, 230200, ',230000,230200,230231', 3, '拜泉县', 'mainland'),
(230281, 230200, ',230000,230200,230281', 3, '讷河市', 'mainland'),
(230282, 230200, ',230000,230200,230282', 3, '其它区', 'mainland'),
(230300, 230000, ',230000,230300', 2, '鸡西市', 'mainland'),
(230302, 230300, ',230000,230300,230302', 3, '鸡冠区', 'mainland'),
(230303, 230300, ',230000,230300,230303', 3, '恒山区', 'mainland'),
(230304, 230300, ',230000,230300,230304', 3, '滴道区', 'mainland'),
(230305, 230300, ',230000,230300,230305', 3, '梨树区', 'mainland'),
(230306, 230300, ',230000,230300,230306', 3, '城子河区', 'mainland'),
(230307, 230300, ',230000,230300,230307', 3, '麻山区', 'mainland'),
(230321, 230300, ',230000,230300,230321', 3, '鸡东县', 'mainland'),
(230381, 230300, ',230000,230300,230381', 3, '虎林市', 'mainland'),
(230382, 230300, ',230000,230300,230382', 3, '密山市', 'mainland'),
(230383, 230300, ',230000,230300,230383', 3, '其它区', 'mainland'),
(230400, 230000, ',230000,230400', 2, '鹤岗市', 'mainland'),
(230402, 230400, ',230000,230400,230402', 3, '向阳区', 'mainland'),
(230403, 230400, ',230000,230400,230403', 3, '工农区', 'mainland'),
(230404, 230400, ',230000,230400,230404', 3, '南山区', 'mainland'),
(230405, 230400, ',230000,230400,230405', 3, '兴安区', 'mainland'),
(230406, 230400, ',230000,230400,230406', 3, '东山区', 'mainland'),
(230407, 230400, ',230000,230400,230407', 3, '兴山区', 'mainland'),
(230421, 230400, ',230000,230400,230421', 3, '萝北县', 'mainland'),
(230422, 230400, ',230000,230400,230422', 3, '绥滨县', 'mainland'),
(230423, 230400, ',230000,230400,230423', 3, '其它区', 'mainland'),
(230500, 230000, ',230000,230500', 2, '双鸭山市', 'mainland'),
(230502, 230500, ',230000,230500,230502', 3, '尖山区', 'mainland'),
(230503, 230500, ',230000,230500,230503', 3, '岭东区', 'mainland'),
(230505, 230500, ',230000,230500,230505', 3, '四方台区', 'mainland'),
(230506, 230500, ',230000,230500,230506', 3, '宝山区', 'mainland'),
(230521, 230500, ',230000,230500,230521', 3, '集贤县', 'mainland'),
(230522, 230500, ',230000,230500,230522', 3, '友谊县', 'mainland'),
(230523, 230500, ',230000,230500,230523', 3, '宝清县', 'mainland'),
(230524, 230500, ',230000,230500,230524', 3, '饶河县', 'mainland'),
(230525, 230500, ',230000,230500,230525', 3, '其它区', 'mainland'),
(230600, 230000, ',230000,230600', 2, '大庆市', 'mainland'),
(230602, 230600, ',230000,230600,230602', 3, '萨尔图区', 'mainland'),
(230603, 230600, ',230000,230600,230603', 3, '龙凤区', 'mainland'),
(230604, 230600, ',230000,230600,230604', 3, '让胡路区', 'mainland'),
(230605, 230600, ',230000,230600,230605', 3, '红岗区', 'mainland'),
(230606, 230600, ',230000,230600,230606', 3, '大同区', 'mainland'),
(230621, 230600, ',230000,230600,230621', 3, '肇州县', 'mainland'),
(230622, 230600, ',230000,230600,230622', 3, '肇源县', 'mainland'),
(230623, 230600, ',230000,230600,230623', 3, '林甸县', 'mainland'),
(230624, 230600, ',230000,230600,230624', 3, '杜尔伯特蒙古族自治县', 'mainland'),
(230625, 230600, ',230000,230600,230625', 3, '其它区', 'mainland'),
(230700, 230000, ',230000,230700', 2, '伊春市', 'mainland'),
(230702, 230700, ',230000,230700,230702', 3, '伊春区', 'mainland'),
(230703, 230700, ',230000,230700,230703', 3, '南岔区', 'mainland'),
(230704, 230700, ',230000,230700,230704', 3, '友好区', 'mainland'),
(230705, 230700, ',230000,230700,230705', 3, '西林区', 'mainland'),
(230706, 230700, ',230000,230700,230706', 3, '翠峦区', 'mainland'),
(230707, 230700, ',230000,230700,230707', 3, '新青区', 'mainland'),
(230708, 230700, ',230000,230700,230708', 3, '美溪区', 'mainland'),
(230709, 230700, ',230000,230700,230709', 3, '金山屯区', 'mainland'),
(230710, 230700, ',230000,230700,230710', 3, '五营区', 'mainland'),
(230711, 230700, ',230000,230700,230711', 3, '乌马河区', 'mainland'),
(230712, 230700, ',230000,230700,230712', 3, '汤旺河区', 'mainland'),
(230713, 230700, ',230000,230700,230713', 3, '带岭区', 'mainland'),
(230714, 230700, ',230000,230700,230714', 3, '乌伊岭区', 'mainland'),
(230715, 230700, ',230000,230700,230715', 3, '红星区', 'mainland'),
(230716, 230700, ',230000,230700,230716', 3, '上甘岭区', 'mainland'),