1 Star 0 Fork 34

McJeremy/letucrm

加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)
免费加入
文件
克隆/下载
letucrm.sql 171.87 KB
一键复制 编辑 原始数据 按行查看 历史
LetuCRM 提交于 2019-10-17 23:43 . 添加数据库脚本
1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431243224332434243524362437243824392440244124422443244424452446244724482449245024512452245324542455245624572458245924602461246224632464246524662467246824692470247124722473247424752476247724782479248024812482248324842485248624872488248924902491249224932494249524962497249824992500250125022503250425052506250725082509251025112512251325142515251625172518251925202521252225232524252525262527252825292530253125322533253425352536253725382539254025412542254325442545254625472548254925502551255225532554255525562557255825592560256125622563256425652566256725682569257025712572257325742575257625772578257925802581258225832584258525862587258825892590259125922593259425952596259725982599260026012602260326042605260626072608260926102611261226132614261526162617261826192620262126222623262426252626262726282629263026312632263326342635263626372638263926402641264226432644264526462647264826492650265126522653265426552656265726582659266026612662266326642665266626672668266926702671267226732674267526762677267826792680268126822683268426852686268726882689269026912692269326942695269626972698269927002701270227032704270527062707270827092710271127122713271427152716271727182719272027212722272327242725272627272728272927302731273227332734273527362737273827392740274127422743274427452746274727482749275027512752275327542755275627572758275927602761276227632764276527662767276827692770277127722773277427752776277727782779278027812782278327842785278627872788278927902791279227932794279527962797279827992800280128022803280428052806280728082809281028112812281328142815281628172818281928202821282228232824282528262827282828292830283128322833283428352836283728382839284028412842284328442845284628472848284928502851285228532854285528562857285828592860286128622863286428652866286728682869287028712872287328742875287628772878287928802881288228832884288528862887288828892890289128922893289428952896289728982899290029012902290329042905290629072908290929102911291229132914291529162917291829192920292129222923292429252926292729282929293029312932293329342935293629372938293929402941294229432944294529462947294829492950295129522953295429552956295729582959296029612962296329642965296629672968296929702971297229732974297529762977297829792980298129822983298429852986298729882989299029912992299329942995299629972998299930003001300230033004300530063007300830093010301130123013301430153016301730183019302030213022302330243025302630273028302930303031303230333034303530363037303830393040304130423043304430453046304730483049305030513052305330543055305630573058305930603061306230633064306530663067306830693070307130723073307430753076307730783079308030813082308330843085308630873088308930903091309230933094309530963097309830993100310131023103310431053106310731083109311031113112311331143115311631173118311931203121312231233124312531263127312831293130313131323133313431353136313731383139314031413142314331443145314631473148314931503151315231533154315531563157315831593160316131623163316431653166316731683169317031713172317331743175317631773178317931803181318231833184318531863187318831893190319131923193319431953196319731983199320032013202320332043205320632073208320932103211321232133214321532163217321832193220322132223223322432253226322732283229323032313232323332343235323632373238323932403241324232433244324532463247324832493250325132523253325432553256325732583259326032613262326332643265326632673268326932703271327232733274327532763277327832793280328132823283328432853286328732883289329032913292329332943295329632973298329933003301330233033304330533063307330833093310331133123313331433153316331733183319332033213322332333243325332633273328332933303331333233333334333533363337333833393340334133423343334433453346334733483349335033513352335333543355335633573358335933603361336233633364336533663367336833693370337133723373337433753376337733783379338033813382338333843385338633873388338933903391339233933394339533963397339833993400340134023403340434053406340734083409341034113412341334143415341634173418341934203421342234233424342534263427342834293430343134323433343434353436343734383439344034413442344334443445344634473448344934503451345234533454345534563457345834593460346134623463346434653466346734683469347034713472347334743475347634773478347934803481348234833484348534863487348834893490349134923493349434953496349734983499350035013502350335043505350635073508350935103511351235133514351535163517351835193520352135223523352435253526352735283529353035313532353335343535353635373538353935403541354235433544354535463547354835493550355135523553355435553556355735583559356035613562356335643565356635673568356935703571357235733574357535763577357835793580358135823583358435853586358735883589359035913592359335943595359635973598359936003601360236033604360536063607360836093610361136123613361436153616361736183619362036213622362336243625362636273628362936303631363236333634363536363637363836393640364136423643364436453646364736483649365036513652365336543655365636573658365936603661366236633664366536663667366836693670367136723673367436753676367736783679368036813682368336843685368636873688368936903691369236933694369536963697369836993700370137023703370437053706370737083709371037113712371337143715371637173718371937203721372237233724372537263727372837293730373137323733373437353736373737383739374037413742374337443745374637473748374937503751375237533754375537563757375837593760376137623763376437653766376737683769377037713772377337743775377637773778377937803781378237833784378537863787378837893790379137923793379437953796379737983799380038013802380338043805380638073808380938103811381238133814381538163817381838193820382138223823382438253826382738283829383038313832383338343835383638373838383938403841384238433844384538463847384838493850385138523853385438553856385738583859386038613862386338643865386638673868386938703871387238733874387538763877387838793880388138823883388438853886388738883889389038913892389338943895389638973898389939003901390239033904390539063907390839093910391139123913391439153916391739183919392039213922392339243925392639273928392939303931393239333934393539363937393839393940394139423943394439453946394739483949395039513952395339543955395639573958395939603961396239633964396539663967396839693970397139723973397439753976397739783979398039813982398339843985398639873988398939903991399239933994399539963997399839994000400140024003400440054006400740084009401040114012401340144015401640174018401940204021402240234024402540264027402840294030403140324033403440354036403740384039404040414042404340444045404640474048404940504051405240534054405540564057405840594060406140624063406440654066406740684069407040714072407340744075407640774078407940804081408240834084408540864087408840894090409140924093409440954096409740984099410041014102410341044105410641074108410941104111411241134114411541164117411841194120412141224123412441254126412741284129413041314132413341344135413641374138413941404141414241434144414541464147414841494150415141524153415441554156415741584159416041614162416341644165416641674168416941704171417241734174417541764177417841794180418141824183418441854186418741884189419041914192419341944195419641974198419942004201420242034204420542064207420842094210421142124213421442154216421742184219422042214222422342244225422642274228422942304231423242334234423542364237423842394240424142424243424442454246424742484249425042514252425342544255425642574258425942604261426242634264426542664267426842694270427142724273427442754276427742784279428042814282428342844285428642874288428942904291429242934294429542964297429842994300430143024303430443054306430743084309431043114312431343144315431643174318431943204321432243234324432543264327432843294330433143324333433443354336433743384339434043414342434343444345434643474348434943504351435243534354435543564357435843594360436143624363436443654366436743684369437043714372437343744375437643774378437943804381438243834384438543864387438843894390439143924393439443954396439743984399440044014402440344044405440644074408440944104411441244134414441544164417441844194420442144224423442444254426442744284429443044314432443344344435443644374438443944404441444244434444444544464447444844494450445144524453445444554456445744584459446044614462446344644465446644674468446944704471447244734474447544764477447844794480448144824483448444854486448744884489449044914492449344944495449644974498449945004501450245034504450545064507450845094510451145124513451445154516451745184519452045214522452345244525452645274528452945304531453245334534453545364537453845394540454145424543454445454546454745484549455045514552455345544555
-- phpMyAdmin SQL Dump
-- version 4.8.3
-- https://www.phpmyadmin.net/
--
-- 主机: localhost
-- 生成日期: 2019-10-17 15:29:30
-- 服务器版本: 10.2.27-MariaDB
-- PHP 版本: 7.2.4
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- 数据库: `letucrm`
--
-- --------------------------------------------------------
--
-- 表的结构 `crm_clue`
--
CREATE TABLE `crm_clue` (
`clue_id` int(11) NOT NULL COMMENT '线索ID',
`customer_id` int(11) NOT NULL DEFAULT 0 COMMENT '客户ID',
`clue_time` int(11) NOT NULL DEFAULT 0 COMMENT '线索时间',
`clue_content` varchar(1000) NOT NULL DEFAULT '' COMMENT '线索内容',
`clue_uid` int(11) NOT NULL DEFAULT 0 COMMENT '线索情报员ID',
`add_uid` int(11) NOT NULL DEFAULT 0 COMMENT '添加用户ID',
`add_time` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
`edit_uid` int(11) NOT NULL DEFAULT 0 COMMENT '编辑用户ID',
`edit_time` int(11) NOT NULL DEFAULT 0 COMMENT '编辑时间',
`is_del` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否删除:0 正常 1 删除'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='客户线索';
-- --------------------------------------------------------
--
-- 表的结构 `crm_customer`
--
CREATE TABLE `crm_customer` (
`customer_id` int(11) NOT NULL COMMENT '客户ID',
`customer_name` char(100) NOT NULL DEFAULT '' COMMENT '客户名称',
`mobile` char(100) NOT NULL DEFAULT '' COMMENT '手机号:多个手机号用","分隔',
`sex` tinyint(4) NOT NULL DEFAULT 0 COMMENT '性别:0 女 1 男 2 保密',
`stature` int(11) NOT NULL DEFAULT 0 COMMENT '身高:cm',
`weight` int(11) NOT NULL DEFAULT 0 COMMENT '体重:kg',
`somatotype` tinyint(4) NOT NULL DEFAULT 0 COMMENT '体型:0 标准 1 微瘦 2 瘦小 3 偏瘦 4 魁梧 5 微胖 6 偏胖',
`marital_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '婚姻状况:0 单身 1 已婚 2 离异 3 再婚 4 丧偶',
`birthdate` int(11) NOT NULL DEFAULT 0 COMMENT '出生日期',
`customer_relations` tinyint(4) NOT NULL DEFAULT 0 COMMENT '客户关系:0 陌生 1 老客 2 同事 3 同学 4 朋友 5 亲戚 6 亲人 7 家人',
`customer_class` char(3) NOT NULL DEFAULT '' COMMENT '客户分类:A,B,C,D',
`industry_id` int(11) NOT NULL DEFAULT 0 COMMENT '所属行业',
`position_id` int(11) NOT NULL DEFAULT 0 COMMENT '职位ID',
`post_id` int(11) NOT NULL DEFAULT 0 COMMENT '岗位ID',
`education_id` tinyint(4) NOT NULL DEFAULT 0 COMMENT '学历:0 不详 1 小学 2 初中 3 高中 4 中专 5 大专 6 本科 7 研究生 8 博士 9 博士后',
`specialty_id` int(11) NOT NULL DEFAULT 0 COMMENT '专业',
`school_id` int(11) NOT NULL DEFAULT 0 COMMENT '毕业学校',
`birth_province_id` int(11) NOT NULL DEFAULT 0 COMMENT '出生省份ID',
`birth_city_id` int(11) NOT NULL DEFAULT 0 COMMENT '出生城市ID',
`birth_region_id` int(11) NOT NULL DEFAULT 0 COMMENT '出生区域ID',
`birth_province_name` char(50) NOT NULL DEFAULT '' COMMENT '出生省份名称',
`birth_city_name` char(50) NOT NULL DEFAULT '' COMMENT '出生城市名称',
`birth_region_name` char(50) NOT NULL DEFAULT '' COMMENT '出生区域名称',
`birth_address` char(200) NOT NULL DEFAULT '' COMMENT '出生住址',
`reside_province_id` int(11) NOT NULL DEFAULT 0 COMMENT '居住省份ID',
`reside_city_id` int(11) NOT NULL DEFAULT 0 COMMENT '居住城市ID',
`reside_region_id` int(11) NOT NULL DEFAULT 0 COMMENT '居住区域ID',
`reside_province_name` char(50) NOT NULL DEFAULT '' COMMENT '居住省份名称',
`reside_city_name` char(50) NOT NULL DEFAULT '' COMMENT '居住城市名称',
`reside_region_name` char(50) NOT NULL DEFAULT '' COMMENT '居住区域名称',
`reside_address` char(200) NOT NULL DEFAULT '' COMMENT '居住住址',
`company_name` char(200) NOT NULL DEFAULT '' COMMENT '企业名称',
`office_address` char(200) NOT NULL DEFAULT '' COMMENT '办公地址',
`office_phone` char(50) NOT NULL DEFAULT '' COMMENT '办公电话',
`fax` char(50) NOT NULL DEFAULT '' COMMENT '传真号码',
`company_site` char(200) NOT NULL DEFAULT '' COMMENT '企业网址',
`person_site` char(200) NOT NULL DEFAULT '' COMMENT '个人网址',
`company_email` char(100) NOT NULL DEFAULT '' COMMENT '企业邮箱',
`person_email` char(100) NOT NULL DEFAULT '' COMMENT '个人邮箱',
`hobbies_ids` char(255) NOT NULL DEFAULT '' COMMENT '兴趣爱好:多个有","分隔',
`customer_detail` text DEFAULT NULL COMMENT '客户详情',
`add_uid` int(11) NOT NULL DEFAULT 0 COMMENT '添加用户ID',
`add_time` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
`edit_uid` int(11) NOT NULL DEFAULT 0 COMMENT '编辑用户ID',
`edit_time` int(11) NOT NULL DEFAULT 0 COMMENT '编辑时间',
`is_del` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否删除:0 正常 1 删除',
`regular_customer` tinyint(4) NOT NULL DEFAULT 0 COMMENT '新老客户:0 新 1 老',
`aim_list` tinyint(4) NOT NULL DEFAULT 0 COMMENT '目标名单:0 否 1 是'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='客户资料';
-- --------------------------------------------------------
--
-- 表的结构 `crm_follow`
--
CREATE TABLE `crm_follow` (
`follow_id` int(11) NOT NULL COMMENT '跟进ID',
`customer_id` int(11) NOT NULL DEFAULT 0 COMMENT '客户ID',
`follow_time` int(11) NOT NULL DEFAULT 0 COMMENT '跟进时间',
`follow_log` varchar(1000) NOT NULL DEFAULT '' COMMENT '跟进日志',
`follow_type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '跟进类型:0 拜访 1 跟进 2 促成 3 成交 4 回访',
`follow_uid` int(11) NOT NULL DEFAULT 0 COMMENT '跟进人员',
`add_uid` int(11) NOT NULL DEFAULT 0 COMMENT '添加用户ID',
`add_time` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
`edit_uid` int(11) NOT NULL DEFAULT 0 COMMENT '编辑用户ID',
`edit_time` int(11) NOT NULL DEFAULT 0 COMMENT '编辑时间',
`is_del` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否删除:0 正常 1 删除'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='客户跟进';
-- --------------------------------------------------------
--
-- 表的结构 `flow_info`
--
CREATE TABLE `flow_info` (
`info_id` int(11) NOT NULL COMMENT '统计ID',
`user_id` int(11) NOT NULL DEFAULT 0 COMMENT '用户ID',
`visit_ip` char(40) NOT NULL DEFAULT '' COMMENT '访问IP',
`visit_time` int(11) NOT NULL DEFAULT 0 COMMENT '访问时间',
`visit_url` varchar(500) NOT NULL DEFAULT '' COMMENT '访问地址',
`visit_url_md5` char(255) NOT NULL DEFAULT '' COMMENT '访问地址MD5',
`visit_agent` varchar(500) NOT NULL DEFAULT '' COMMENT '访问Agent'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='流量统计';
--
-- 表的结构 `industry`
--
CREATE TABLE `industry` (
`industry_id` int(11) NOT NULL COMMENT '行业ID',
`industry_name` char(100) NOT NULL DEFAULT '' COMMENT '行业名称',
`name_first_letter` char(50) NOT NULL DEFAULT '' COMMENT '名称首字母',
`add_uid` int(11) NOT NULL DEFAULT 0 COMMENT '添加用户ID',
`add_time` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
`edit_uid` int(11) NOT NULL DEFAULT 0 COMMENT '编辑用户ID',
`edit_time` int(11) NOT NULL DEFAULT 0 COMMENT '编辑时间',
`is_del` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否删除:0 正常 1 删除'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='行业';
--
-- 转存表中的数据 `industry`
--
INSERT INTO `industry` (`industry_id`, `industry_name`, `name_first_letter`, `add_uid`, `add_time`, `edit_uid`, `edit_time`, `is_del`) VALUES
(1, '房地产', 'FDC', 1, 1538570263, 1, 1538570263, 0),
(2, '金融', 'JR', 1, 1538570362, 1, 1538570362, 0),
(3, '培训教育', 'PXJY', 1, 1538570576, 1, 1538570576, 0),
(4, '影视文化', 'YSWH', 1, 1538574007, 1, 1538574007, 0),
(5, '体育赛事', 'TYSS', 1, 1538574085, 1, 1538574085, 0),
(6, '互联网', 'HLW', 1, 1538577196, 1, 1538577196, 0),
(7, '律师', 'LS', 1, 1538577271, 1, 1538577271, 0),
(8, '医生', 'YS', 1, 1538577719, 1, 1538577719, 0),
(9, '保险', 'BX', 1, 1538756725, 1, 1538756725, 0),
(10, '家具商', 'JQX', 3, 1540950877, 3, 1540950877, 0);
-- --------------------------------------------------------
--
-- 表的结构 `message`
--
CREATE TABLE `message` (
`msg_id` int(11) NOT NULL COMMENT '消息ID',
`receive_uid` int(11) NOT NULL DEFAULT 0 COMMENT '接收者ID',
`send_uid` int(11) NOT NULL DEFAULT 0 COMMENT '发送者ID:0 代表系统发送者',
`msg_type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '消息类型:0 系统 1 客户 2 保单 3 目标',
`msg_title` char(100) NOT NULL DEFAULT '' COMMENT '标题',
`msg_summary` char(200) NOT NULL DEFAULT '' COMMENT '消息摘要',
`msg_content` varchar(4000) NOT NULL DEFAULT '' COMMENT '消息内容',
`msg_time` int(11) NOT NULL DEFAULT 0 COMMENT '消息时间',
`is_read` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否阅读:0 未读 1 已读',
`read_time` int(11) NOT NULL DEFAULT 0 COMMENT '阅读时间',
`add_uid` int(11) NOT NULL DEFAULT 0 COMMENT '添加用户ID',
`add_time` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
`edit_uid` int(11) NOT NULL DEFAULT 0 COMMENT '编辑用户ID',
`edit_time` int(11) NOT NULL DEFAULT 0 COMMENT '编辑时间',
`is_del` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否删除:0 正常 1 删除',
`source_id` int(11) NOT NULL DEFAULT 0 COMMENT '消息源ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='消息';
-- --------------------------------------------------------
--
-- 表的结构 `my_insurance`
--
CREATE TABLE `my_insurance` (
`insurance_id` int(11) NOT NULL COMMENT '保险单ID',
`user_id` int(11) NOT NULL DEFAULT 0 COMMENT '用户ID',
`insurance_company` char(200) NOT NULL DEFAULT '' COMMENT '保险公司',
`service_telephone` char(50) NOT NULL DEFAULT '' COMMENT '客服电话',
`policy_holder` char(50) NOT NULL DEFAULT '' COMMENT '投保人',
`customer_id` int(11) NOT NULL DEFAULT 0 COMMENT '客户ID',
`insured` char(50) NOT NULL DEFAULT '' COMMENT '被保险人',
`people_relation` tinyint(4) NOT NULL DEFAULT 0 COMMENT '人员关系:0 本人 1 丈夫 2 妻子 3 儿子 4 女儿 5 父亲 6 母亲 7 员工',
`first_pay_date` int(11) NOT NULL DEFAULT 0 COMMENT '首次缴费日期',
`next_pay_date` int(11) NOT NULL DEFAULT 0 COMMENT '下次缴费日期',
`effective_date` int(11) NOT NULL DEFAULT 0 COMMENT '生效日期',
`first_premium` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '首年保费',
`insurance_main` char(200) NOT NULL DEFAULT '' COMMENT '主险名称',
`pay_year` smallint(6) NOT NULL DEFAULT 0 COMMENT '缴费年限',
`insurance_detail` text DEFAULT NULL COMMENT '保险明细:险种名称/保障期限/交费期限/保额',
`policy_type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '保单类别:0 我的 1 客户',
`link_phone` char(50) NOT NULL DEFAULT '' COMMENT '联系电话',
`link_address` char(200) NOT NULL DEFAULT '' COMMENT '联系地址',
`add_uid` int(11) NOT NULL DEFAULT 0 COMMENT '添加用户ID',
`add_time` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
`edit_uid` int(11) NOT NULL DEFAULT 0 COMMENT '编辑用户ID',
`edit_time` int(11) NOT NULL DEFAULT 0 COMMENT '编辑时间',
`is_del` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否删除:0 正常 1 删除'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='保险单';
-- --------------------------------------------------------
--
-- 表的结构 `my_talk_script`
--
CREATE TABLE `my_talk_script` (
`script_id` int(11) NOT NULL COMMENT '话术ID',
`user_id` int(11) NOT NULL DEFAULT 0 COMMENT '用户ID',
`script_type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '话术类别:0 销售 1 增员 2 客服',
`script_title` char(200) NOT NULL DEFAULT '' COMMENT '话术标题',
`script_content` text DEFAULT NULL COMMENT '话术内容',
`add_uid` int(11) NOT NULL DEFAULT 0 COMMENT '添加用户ID',
`add_time` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
`edit_uid` int(11) NOT NULL DEFAULT 0 COMMENT '编辑用户ID',
`edit_time` int(11) NOT NULL DEFAULT 0 COMMENT '编辑时间',
`is_del` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否删除:0 正常 1 删除'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='话术';
-- --------------------------------------------------------
--
-- 表的结构 `province_city`
--
CREATE TABLE `province_city` (
`pcity_id` int(11) NOT NULL COMMENT '省份城市ID',
`parent_id` int(11) NOT NULL DEFAULT 0 COMMENT '父ID',
`pcity_name` char(80) NOT NULL DEFAULT '' COMMENT '省份城市名称',
`pcity_level` tinyint(4) NOT NULL DEFAULT 0 COMMENT '省分城市级别:0=>国家,1=>省,2=>市,3=>区或县,北京等直辖市也为1',
`pinyin` char(80) NOT NULL DEFAULT '' COMMENT '拼音',
`first_letter` char(1) NOT NULL DEFAULT '' COMMENT '前缀首字母'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='省份城市';
--
-- 转存表中的数据 `province_city`
--
INSERT INTO `province_city` (`pcity_id`, `parent_id`, `pcity_name`, `pcity_level`, `pinyin`, `first_letter`) VALUES
(1, 0, '北京', 1, '', ''),
(2, 0, '上海', 1, '', ''),
(3, 0, '天津', 1, '', ''),
(4, 0, '重庆', 1, '', ''),
(5, 0, '河北', 1, '', ''),
(6, 0, '山西', 1, '', ''),
(7, 0, '河南', 1, '', ''),
(8, 0, '辽宁', 1, '', ''),
(9, 0, '吉林', 1, '', ''),
(10, 0, '黑龙江', 1, '', ''),
(11, 0, '内蒙古', 1, '', ''),
(12, 0, '江苏', 1, '', ''),
(13, 0, '山东', 1, '', ''),
(14, 0, '安徽', 1, '', ''),
(15, 0, '浙江', 1, '', ''),
(16, 0, '福建', 1, '', ''),
(17, 0, '湖北', 1, '', ''),
(18, 0, '湖南', 1, '', ''),
(19, 0, '广东', 1, '', ''),
(20, 0, '广西', 1, '', ''),
(21, 0, '江西', 1, '', ''),
(22, 0, '四川', 1, '', ''),
(23, 0, '海南', 1, '', ''),
(24, 0, '贵州', 1, '', ''),
(25, 0, '云南', 1, '', ''),
(26, 0, '西藏', 1, '', ''),
(27, 0, '陕西', 1, '', ''),
(28, 0, '甘肃', 1, '', ''),
(29, 0, '青海', 1, '', ''),
(30, 0, '宁夏', 1, '', ''),
(31, 0, '新疆', 1, '', ''),
(32, 0, '台湾', 1, '', ''),
(42, 0, '香港', 1, '', ''),
(43, 0, '澳门', 1, '', ''),
(72, 1, '朝阳区', 2, '', ''),
(78, 2, '黄浦区', 2, '', ''),
(79, 78, '内环以内', 3, '', ''),
(80, 78, '内环中环之间', 3, '', ''),
(81, 78, '中环外环之间', 3, '', ''),
(83, 3, '天津市', 2, '', ''),
(84, 0, '钓鱼岛', 1, '', ''),
(85, 83, '西青区', 3, '', ''),
(86, 83, '北辰区', 3, '', ''),
(87, 4, '重庆市', 2, '', ''),
(88, 87, '江北区', 3, '', ''),
(89, 83, '东丽区', 3, '', ''),
(91, 83, '汉沽区', 3, '', ''),
(97, 83, '津南区', 3, '', ''),
(98, 83, '蓟县', 3, '', ''),
(99, 83, '武清县', 3, '', ''),
(100, 83, '宁河县', 3, '', ''),
(101, 83, '宝坻县', 3, '', ''),
(102, 83, '静海县', 3, '', ''),
(103, 87, '渝中区', 3, '', ''),
(104, 87, '巴南区', 3, '', ''),
(105, 87, '万盛区', 3, '', ''),
(106, 87, '九龙坡区', 3, '', ''),
(109, 87, '北碚区', 3, '', ''),
(111, 87, '大渡口区', 3, '', ''),
(113, 87, '万州区', 3, '', ''),
(114, 87, '涪陵区', 3, '', ''),
(115, 87, '梁平县', 3, '', ''),
(119, 87, '南川区', 3, '', ''),
(123, 87, '潼南县', 3, '', ''),
(126, 87, '大足区', 3, '', ''),
(128, 87, '黔江区', 3, '', ''),
(129, 87, '武隆县', 3, '', ''),
(130, 87, '丰都县', 3, '', ''),
(131, 87, '奉节县', 3, '', ''),
(132, 87, '开县', 3, '', ''),
(133, 87, '云阳县', 3, '', ''),
(134, 87, '忠县', 3, '', ''),
(135, 87, '巫溪县', 3, '', ''),
(136, 87, '巫山县', 3, '', ''),
(137, 87, '石柱县', 3, '', ''),
(138, 87, '彭水县', 3, '', ''),
(139, 87, '垫江县', 3, '', ''),
(140, 87, '酉阳县', 3, '', ''),
(141, 87, '秀山县', 3, '', ''),
(142, 5, '石家庄市', 2, '', ''),
(143, 142, '辛集市', 3, '', ''),
(145, 142, '晋州市', 3, '', ''),
(146, 142, '新乐市', 3, '', ''),
(148, 5, '邯郸市', 2, '', ''),
(153, 142, '井陉县', 3, '', ''),
(154, 142, '栾城县', 3, '', ''),
(155, 142, '正定县', 3, '', ''),
(156, 142, '行唐县', 3, '', ''),
(157, 142, '灵寿县', 3, '', ''),
(158, 142, '高邑县', 3, '', ''),
(159, 142, '赵县', 3, '', ''),
(160, 142, '赞皇县', 3, '', ''),
(161, 142, '深泽县', 3, '', ''),
(162, 142, '无极县', 3, '', ''),
(163, 142, '元氏县', 3, '', ''),
(164, 5, '邢台市', 2, '', ''),
(165, 142, '矿区', 3, '', ''),
(167, 148, '邯郸县', 3, '', ''),
(168, 148, '峰峰矿区', 3, '', ''),
(169, 148, '曲周县', 3, '', ''),
(170, 148, '馆陶县', 3, '', ''),
(171, 148, '魏县', 3, '', ''),
(172, 148, '成安县', 3, '', ''),
(173, 148, '大名县', 3, '', ''),
(174, 148, '涉县', 3, '', ''),
(175, 148, '鸡泽县', 3, '', ''),
(176, 148, '邱县', 3, '', ''),
(177, 148, '广平县', 3, '', ''),
(178, 148, '肥乡县', 3, '', ''),
(180, 148, '磁县', 3, '', ''),
(183, 164, '邢台县', 3, '', ''),
(184, 164, '南宫市', 3, '', ''),
(185, 164, '沙河市', 3, '', ''),
(186, 164, '柏乡县', 3, '', ''),
(187, 164, '任县', 3, '', ''),
(188, 164, '清河县', 3, '', ''),
(189, 164, '隆尧县', 3, '', ''),
(190, 164, '临城县', 3, '', ''),
(191, 164, '广宗县', 3, '', ''),
(192, 164, '临西县', 3, '', ''),
(193, 164, '内丘县', 3, '', ''),
(194, 164, '平乡县', 3, '', ''),
(195, 164, '巨鹿县', 3, '', ''),
(196, 164, '新河县', 3, '', ''),
(197, 164, '南和县', 3, '', ''),
(199, 5, '保定市', 2, '', ''),
(203, 199, '安国市', 3, '', ''),
(205, 199, '满城县', 3, '', ''),
(206, 199, '清苑县', 3, '', ''),
(207, 199, '涞水县', 3, '', ''),
(208, 199, '阜平县', 3, '', ''),
(209, 199, '徐水县', 3, '', ''),
(210, 199, '定兴县', 3, '', ''),
(211, 199, '唐县', 3, '', ''),
(212, 199, '高阳县', 3, '', ''),
(213, 199, '容城县', 3, '', ''),
(214, 199, '涞源县', 3, '', ''),
(215, 199, '望都县', 3, '', ''),
(217, 199, '易县', 3, '', ''),
(218, 199, '曲阳县', 3, '', ''),
(219, 199, '蠡县', 3, '', ''),
(220, 199, '顺平县', 3, '', ''),
(221, 199, '博野县', 3, '', ''),
(222, 199, '雄县', 3, '', ''),
(224, 5, '张家口市', 2, '', ''),
(225, 224, '宣化县', 3, '', ''),
(226, 224, '康保县', 3, '', ''),
(227, 224, '张北县', 3, '', ''),
(228, 224, '阳原县', 3, '', ''),
(229, 224, '赤城县', 3, '', ''),
(230, 224, '怀安县', 3, '', ''),
(231, 224, '怀来县', 3, '', ''),
(232, 224, '崇礼县', 3, '', ''),
(233, 224, '尚义县', 3, '', ''),
(234, 224, '蔚县', 3, '', ''),
(235, 224, '涿鹿县', 3, '', ''),
(236, 224, '万全县', 3, '', ''),
(238, 224, '下花园区', 3, '', ''),
(239, 5, '承德市', 2, '', ''),
(241, 239, '兴隆县', 3, '', ''),
(242, 239, '平泉县', 3, '', ''),
(243, 239, '滦平县', 3, '', ''),
(245, 239, '丰宁满族自治县', 3, '', ''),
(246, 239, '围场满族蒙古族自治县', 3, '', ''),
(247, 239, '宽城满族自治县', 3, '', ''),
(248, 5, '秦皇岛市', 2, '', ''),
(257, 164, '宁晋县', 3, '', ''),
(258, 5, '唐山市', 2, '', ''),
(261, 248, '卢龙县', 3, '', ''),
(262, 248, '青龙满族自治县', 3, '', ''),
(263, 248, '昌黎县', 3, '', ''),
(264, 5, '沧州市', 2, '', ''),
(265, 264, '沧县', 3, '', ''),
(266, 264, '泊头市', 3, '', ''),
(267, 264, '任丘市', 3, '', ''),
(268, 264, '河间市', 3, '', ''),
(269, 264, '献县', 3, '', ''),
(270, 264, '肃宁县', 3, '', ''),
(271, 264, '青县', 3, '', ''),
(272, 264, '东光县', 3, '', ''),
(273, 264, '吴桥县', 3, '', ''),
(274, 5, '廊坊市', 2, '', ''),
(275, 5, '衡水市', 2, '', ''),
(276, 264, '南皮县', 3, '', ''),
(277, 264, '盐山县', 3, '', ''),
(278, 264, '海兴县', 3, '', ''),
(279, 264, '孟村回族自治县', 3, '', ''),
(283, 274, '三河市', 3, '', ''),
(284, 274, '固安县', 3, '', ''),
(285, 274, '永清县', 3, '', ''),
(286, 274, '香河县', 3, '', ''),
(287, 274, '大城县', 3, '', ''),
(288, 274, '文安县', 3, '', ''),
(289, 274, '大厂回族自治县', 3, '', ''),
(291, 275, '冀州市', 3, '', ''),
(292, 275, '深州市', 3, '', ''),
(293, 275, '饶阳县', 3, '', ''),
(294, 275, '枣强县', 3, '', ''),
(295, 275, '故城县', 3, '', ''),
(296, 275, '阜城县', 3, '', ''),
(297, 275, '安平县', 3, '', ''),
(298, 275, '武邑县', 3, '', ''),
(299, 275, '景县', 3, '', ''),
(300, 275, '武强县', 3, '', ''),
(301, 275, '桃城区', 3, '', ''),
(303, 6, '太原市', 2, '', ''),
(304, 303, '阳曲县', 3, '', ''),
(305, 303, '古交市', 3, '', ''),
(306, 303, '娄烦县', 3, '', ''),
(307, 303, '清徐县', 3, '', ''),
(309, 6, '大同市', 2, '', ''),
(310, 309, '大同县', 3, '', ''),
(311, 309, '天镇县', 3, '', ''),
(312, 309, '灵丘县', 3, '', ''),
(313, 309, '阳高县', 3, '', ''),
(314, 309, '左云县', 3, '', ''),
(315, 309, '浑源县', 3, '', ''),
(316, 309, '广灵县', 3, '', ''),
(318, 6, '阳泉市', 2, '', ''),
(319, 318, '盂县', 3, '', ''),
(320, 318, '平定县', 3, '', ''),
(321, 318, '郊区', 3, '', ''),
(325, 6, '晋城市', 2, '', ''),
(326, 325, '高平市', 3, '', ''),
(327, 325, '阳城县', 3, '', ''),
(328, 325, '沁水县', 3, '', ''),
(329, 325, '陵川县', 3, '', ''),
(330, 6, '朔州市', 2, '', ''),
(331, 330, '山阴县', 3, '', ''),
(332, 330, '右玉县', 3, '', ''),
(333, 330, '应县', 3, '', ''),
(334, 330, '怀仁县', 3, '', ''),
(335, 330, '朔城区', 3, '', ''),
(336, 6, '晋中市', 2, '', ''),
(338, 336, '介休市', 3, '', ''),
(339, 336, '昔阳县', 3, '', ''),
(341, 336, '祁县', 3, '', ''),
(342, 336, '左权县', 3, '', ''),
(343, 336, '寿阳县', 3, '', ''),
(344, 336, '太谷县', 3, '', ''),
(345, 336, '和顺县', 3, '', ''),
(346, 336, '灵石县', 3, '', ''),
(347, 336, '平遥县', 3, '', ''),
(348, 336, '榆社县', 3, '', ''),
(350, 6, '忻州市', 2, '', ''),
(351, 350, '原平市', 3, '', ''),
(352, 350, '代县', 3, '', ''),
(353, 350, '神池县', 3, '', ''),
(354, 350, '五寨县', 3, '', ''),
(357, 87, '綦江县', 3, '', ''),
(358, 350, '五台县', 3, '', ''),
(359, 350, '偏关县', 3, '', ''),
(360, 350, '宁武县', 3, '', ''),
(361, 350, '静乐县', 3, '', ''),
(362, 350, '繁峙县', 3, '', ''),
(363, 350, '河曲县', 3, '', ''),
(364, 350, '保德县', 3, '', ''),
(365, 350, '定襄县', 3, '', ''),
(366, 350, '忻府区', 3, '', ''),
(367, 350, '岢岚县', 3, '', ''),
(368, 6, '吕梁市', 2, '', ''),
(369, 368, '离石区', 3, '', ''),
(370, 368, '孝义市', 3, '', ''),
(371, 368, '汾阳市', 3, '', ''),
(372, 368, '文水县', 3, '', ''),
(373, 368, '中阳县', 3, '', ''),
(374, 368, '兴县', 3, '', ''),
(375, 368, '临县', 3, '', ''),
(376, 368, '方山县', 3, '', ''),
(377, 368, '柳林县', 3, '', ''),
(378, 368, '岚县', 3, '', ''),
(379, 6, '临汾市', 2, '', ''),
(380, 379, '侯马市', 3, '', ''),
(381, 379, '霍州市', 3, '', ''),
(382, 379, '汾西县', 3, '', ''),
(383, 379, '吉县', 3, '', ''),
(384, 379, '安泽县', 3, '', ''),
(386, 379, '浮山县', 3, '', ''),
(387, 379, '大宁县', 3, '', ''),
(388, 379, '古县', 3, '', ''),
(389, 379, '隰县', 3, '', ''),
(390, 379, '襄汾县', 3, '', ''),
(391, 379, '翼城县', 3, '', ''),
(392, 379, '永和县', 3, '', ''),
(393, 379, '乡宁县', 3, '', ''),
(395, 379, '洪洞县', 3, '', ''),
(396, 379, '蒲县', 3, '', ''),
(398, 6, '运城市', 2, '', ''),
(399, 398, '河津市', 3, '', ''),
(400, 398, '永济市', 3, '', ''),
(402, 398, '新绛县', 3, '', ''),
(403, 398, '平陆县', 3, '', ''),
(404, 398, '垣曲县', 3, '', ''),
(405, 398, '绛县', 3, '', ''),
(406, 398, '稷山县', 3, '', ''),
(407, 398, '芮城县', 3, '', ''),
(408, 398, '夏县', 3, '', ''),
(409, 398, '临猗县', 3, '', ''),
(410, 398, '万荣县', 3, '', ''),
(412, 7, '郑州市', 2, '', ''),
(413, 412, '巩义市', 3, '', ''),
(415, 412, '新密市', 3, '', ''),
(416, 412, '登封市', 3, '', ''),
(417, 412, '中牟县', 3, '', ''),
(420, 7, '开封市', 2, '', ''),
(421, 420, '开封县', 3, '', ''),
(422, 420, '杞县', 3, '', ''),
(423, 420, '兰考县', 3, '', ''),
(425, 420, '尉氏县', 3, '', ''),
(427, 7, '洛阳市', 2, '', ''),
(428, 427, '偃师市', 3, '', ''),
(429, 427, '孟津县', 3, '', ''),
(430, 427, '汝阳县', 3, '', ''),
(431, 427, '伊川县', 3, '', ''),
(432, 427, '洛宁县', 3, '', ''),
(434, 427, '宜阳县', 3, '', ''),
(435, 427, '栾川县', 3, '', ''),
(436, 427, '新安县', 3, '', ''),
(438, 7, '平顶山市', 2, '', ''),
(439, 438, '汝州市', 3, '', ''),
(440, 438, '舞钢市', 3, '', ''),
(441, 438, '郏县', 3, '', ''),
(442, 438, '叶县', 3, '', ''),
(443, 438, '鲁山县', 3, '', ''),
(444, 438, '宝丰县', 3, '', ''),
(446, 7, '焦作市', 2, '', ''),
(447, 446, '沁阳市', 3, '', ''),
(448, 446, '孟州市', 3, '', ''),
(449, 446, '修武县', 3, '', ''),
(450, 446, '温县', 3, '', ''),
(451, 446, '武陟县', 3, '', ''),
(452, 446, '博爱县', 3, '', ''),
(453, 446, '山阳区', 3, '', ''),
(454, 7, '鹤壁市', 2, '', ''),
(455, 454, '浚县', 3, '', ''),
(456, 454, '淇县', 3, '', ''),
(457, 454, '鹤山区', 3, '', ''),
(458, 7, '新乡市', 2, '', ''),
(459, 458, '卫辉市', 3, '', ''),
(460, 458, '辉县市', 3, '', ''),
(461, 458, '新乡县', 3, '', ''),
(462, 458, '获嘉县', 3, '', ''),
(463, 458, '原阳县', 3, '', ''),
(464, 458, '长垣县', 3, '', ''),
(465, 458, '延津县', 3, '', ''),
(466, 458, '封丘县', 3, '', ''),
(468, 7, '安阳市', 2, '', ''),
(469, 468, '林州市', 3, '', ''),
(470, 468, '安阳县', 3, '', ''),
(471, 468, '滑县', 3, '', ''),
(472, 468, '汤阴县', 3, '', ''),
(473, 468, '内黄县', 3, '', ''),
(474, 468, '龙安区', 3, '', ''),
(475, 7, '濮阳市', 2, '', ''),
(476, 475, '濮阳县', 3, '', ''),
(477, 475, '南乐县', 3, '', ''),
(478, 475, '台前县', 3, '', ''),
(479, 475, '清丰县', 3, '', ''),
(480, 475, '范县', 3, '', ''),
(481, 475, '华龙区', 3, '', ''),
(482, 7, '许昌市', 2, '', ''),
(483, 482, '禹州市', 3, '', ''),
(484, 482, '长葛市', 3, '', ''),
(485, 482, '许昌县', 3, '', ''),
(486, 482, '鄢陵县', 3, '', ''),
(487, 482, '襄城县', 3, '', ''),
(488, 482, '魏都区', 3, '', ''),
(489, 7, '漯河市', 2, '', ''),
(490, 489, '郾城区', 3, '', ''),
(492, 489, '临颍县', 3, '', ''),
(493, 489, '召陵区', 3, '', ''),
(494, 489, '舞阳县', 3, '', ''),
(495, 7, '三门峡市', 2, '', ''),
(496, 495, '义马市', 3, '', ''),
(497, 495, '灵宝市', 3, '', ''),
(498, 495, '陕县', 3, '', ''),
(499, 495, '卢氏县', 3, '', ''),
(502, 7, '南阳市', 2, '', ''),
(503, 502, '邓州市', 3, '', ''),
(504, 502, '桐柏县', 3, '', ''),
(505, 502, '方城县', 3, '', ''),
(506, 502, '淅川县', 3, '', ''),
(507, 502, '镇平县', 3, '', ''),
(508, 502, '唐河县', 3, '', ''),
(509, 502, '南召县', 3, '', ''),
(510, 502, '内乡县', 3, '', ''),
(511, 502, '新野县', 3, '', ''),
(512, 502, '社旗县', 3, '', ''),
(515, 502, '西峡县', 3, '', ''),
(516, 502, '卧龙区', 3, '', ''),
(517, 7, '商丘市', 2, '', ''),
(518, 517, '永城市', 3, '', ''),
(519, 517, '宁陵县', 3, '', ''),
(520, 517, '虞城县', 3, '', ''),
(521, 517, '民权县', 3, '', ''),
(522, 517, '夏邑县', 3, '', ''),
(523, 517, '柘城县', 3, '', ''),
(524, 517, '睢县', 3, '', ''),
(526, 517, '睢阳区', 3, '', ''),
(527, 7, '周口市', 2, '', ''),
(529, 527, '项城市', 3, '', ''),
(530, 527, '商水县', 3, '', ''),
(531, 527, '淮阳县', 3, '', ''),
(532, 527, '太康县', 3, '', ''),
(533, 527, '鹿邑县', 3, '', ''),
(534, 527, '西华县', 3, '', ''),
(535, 527, '扶沟县', 3, '', ''),
(536, 527, '沈丘县', 3, '', ''),
(537, 527, '郸城县', 3, '', ''),
(538, 7, '驻马店市', 2, '', ''),
(540, 538, '确山县', 3, '', ''),
(541, 538, '新蔡县', 3, '', ''),
(542, 538, '上蔡县', 3, '', ''),
(543, 538, '泌阳县', 3, '', ''),
(544, 538, '西平县', 3, '', ''),
(545, 538, '遂平县', 3, '', ''),
(546, 538, '汝南县', 3, '', ''),
(547, 538, '平舆县', 3, '', ''),
(548, 538, '正阳县', 3, '', ''),
(549, 7, '信阳市', 2, '', ''),
(551, 549, '潢川县', 3, '', ''),
(552, 549, '淮滨县', 3, '', ''),
(553, 549, '息县', 3, '', ''),
(554, 549, '新县', 3, '', ''),
(556, 549, '固始县', 3, '', ''),
(557, 549, '罗山县', 3, '', ''),
(558, 549, '光山县', 3, '', ''),
(560, 8, '沈阳市', 2, '', ''),
(563, 560, '大东区', 3, '', ''),
(565, 560, '东陵区', 3, '', ''),
(566, 560, '于洪区', 3, '', ''),
(567, 560, '苏家屯区', 3, '', ''),
(569, 560, '新民市', 3, '', ''),
(570, 560, '法库县', 3, '', ''),
(571, 560, '辽中县', 3, '', ''),
(572, 560, '康平县', 3, '', ''),
(573, 8, '大连市', 2, '', ''),
(574, 573, '普兰店市', 3, '', ''),
(575, 573, '瓦房店市', 3, '', ''),
(576, 573, '庄河市', 3, '', ''),
(577, 573, '长海县', 3, '', ''),
(579, 8, '鞍山市', 2, '', ''),
(580, 579, '台安县', 3, '', ''),
(581, 579, '海城市', 3, '', ''),
(583, 579, '岫岩满族自治县', 3, '', ''),
(584, 8, '抚顺市', 2, '', ''),
(585, 584, '抚顺县', 3, '', ''),
(586, 584, '新宾满族自治县', 3, '', ''),
(587, 584, '清原满族自治县', 3, '', ''),
(589, 8, '本溪市', 2, '', ''),
(591, 589, '桓仁满族自治县', 3, '', ''),
(593, 8, '丹东市', 2, '', ''),
(594, 593, '东港市', 3, '', ''),
(595, 593, '凤城市', 3, '', ''),
(596, 593, '宽甸满族自治县', 3, '', ''),
(598, 8, '锦州市', 2, '', ''),
(599, 598, '义县', 3, '', ''),
(600, 598, '凌海市', 3, '', ''),
(601, 598, '北镇市', 3, '', ''),
(602, 598, '黑山县', 3, '', ''),
(604, 8, '葫芦岛市', 2, '', ''),
(605, 604, '兴城市', 3, '', ''),
(606, 604, '绥中县', 3, '', ''),
(607, 604, '建昌县', 3, '', ''),
(608, 604, '南票区', 3, '', ''),
(609, 8, '营口市', 2, '', ''),
(610, 609, '大石桥市', 3, '', ''),
(611, 609, '盖州市', 3, '', ''),
(613, 8, '盘锦市', 2, '', ''),
(614, 613, '盘山县', 3, '', ''),
(615, 613, '大洼县', 3, '', ''),
(617, 8, '阜新市', 2, '', ''),
(618, 617, '阜新蒙古族自治县', 3, '', ''),
(619, 617, '彰武县', 3, '', ''),
(621, 8, '辽阳市', 2, '', ''),
(622, 621, '灯塔市', 3, '', ''),
(623, 621, '辽阳县', 3, '', ''),
(632, 8, '朝阳市', 2, '', ''),
(633, 632, '凌源市', 3, '', ''),
(634, 632, '北票市', 3, '', ''),
(635, 632, '喀喇沁左翼蒙古族自治县', 3, '', ''),
(636, 632, '朝阳县', 3, '', ''),
(637, 632, '建平县', 3, '', ''),
(638, 632, '双塔区', 3, '', ''),
(639, 9, '长春市', 2, '', ''),
(640, 639, '榆树市', 3, '', ''),
(641, 639, '九台市', 3, '', ''),
(642, 639, '农安县', 3, '', ''),
(644, 9, '吉林市', 2, '', ''),
(645, 644, '舒兰市', 3, '', ''),
(646, 644, '桦甸市', 3, '', ''),
(647, 644, '蛟河市', 3, '', ''),
(648, 644, '磐石市', 3, '', ''),
(649, 644, '永吉县', 3, '', ''),
(650, 644, '丰满区', 3, '', ''),
(651, 9, '四平市', 2, '', ''),
(652, 651, '公主岭市', 3, '', ''),
(653, 651, '双辽市', 3, '', ''),
(654, 651, '梨树县', 3, '', ''),
(656, 651, '伊通满族自治县', 3, '', ''),
(657, 9, '通化市', 2, '', ''),
(658, 657, '梅河口市', 3, '', ''),
(659, 657, '集安市', 3, '', ''),
(660, 657, '通化县', 3, '', ''),
(661, 657, '辉南县', 3, '', ''),
(662, 657, '柳河县', 3, '', ''),
(663, 657, '二道江区', 3, '', ''),
(664, 9, '白山市', 2, '', ''),
(665, 664, '临江市', 3, '', ''),
(669, 664, '江源区', 3, '', ''),
(670, 664, '浑江区', 3, '', ''),
(671, 664, '靖宇县', 3, '', ''),
(672, 664, '抚松县', 3, '', ''),
(673, 664, '长白朝鲜族自治县', 3, '', ''),
(674, 9, '松原市', 2, '', ''),
(675, 674, '乾安县', 3, '', ''),
(676, 674, '长岭县', 3, '', ''),
(677, 674, '扶余县', 3, '', ''),
(678, 674, '前郭尔罗斯蒙古族自治县', 3, '', ''),
(679, 674, '宁江区', 3, '', ''),
(681, 9, '白城市', 2, '', ''),
(682, 681, '大安市', 3, '', ''),
(683, 681, '洮南市', 3, '', ''),
(684, 681, '通榆县', 3, '', ''),
(685, 681, '镇赍市', 3, '', ''),
(686, 681, '洮北区', 3, '', ''),
(687, 9, '延边朝鲜族自治州', 2, '', ''),
(698, 10, '哈尔滨市', 2, '', ''),
(699, 698, '阿城区', 3, '', ''),
(700, 698, '尚志市', 3, '', ''),
(701, 698, '双城市', 3, '', ''),
(702, 698, '五常市', 3, '', ''),
(703, 698, '呼兰区', 3, '', ''),
(704, 698, '方正县', 3, '', ''),
(705, 698, '宾县', 3, '', ''),
(706, 698, '依兰县', 3, '', ''),
(707, 698, '巴彦县', 3, '', ''),
(708, 698, '通河县', 3, '', ''),
(709, 698, '木兰县', 3, '', ''),
(710, 698, '延寿县', 3, '', ''),
(712, 10, '齐齐哈尔市', 2, '', ''),
(713, 712, '梅里斯达斡尔族区', 3, '', ''),
(714, 712, '昂昂溪区', 3, '', ''),
(715, 712, '富拉尔基区', 3, '', ''),
(716, 712, '碾子山区', 3, '', ''),
(717, 712, '讷河市', 3, '', ''),
(718, 712, '富裕县', 3, '', ''),
(719, 712, '拜泉县', 3, '', ''),
(720, 712, '甘南县', 3, '', ''),
(721, 712, '依安县', 3, '', ''),
(722, 712, '克山县', 3, '', ''),
(723, 712, '龙江县', 3, '', ''),
(724, 712, '克东县', 3, '', ''),
(725, 712, '泰来县', 3, '', ''),
(727, 10, '鹤岗市', 2, '', ''),
(728, 727, '萝北县', 3, '', ''),
(729, 727, '绥宾县', 3, '', ''),
(731, 10, '双鸭山市', 2, '', ''),
(733, 731, '集贤县', 3, '', ''),
(734, 731, '宝清县', 3, '', ''),
(735, 731, '友谊县', 3, '', ''),
(736, 731, '饶河县', 3, '', ''),
(737, 10, '鸡西市', 2, '', ''),
(739, 737, '密山市', 3, '', ''),
(740, 737, '虎林市', 3, '', ''),
(741, 737, '鸡东县', 3, '', ''),
(742, 10, '大庆市', 2, '', ''),
(744, 742, '萨尔图区', 3, '', ''),
(745, 742, '龙凤区', 3, '', ''),
(746, 742, '让胡路区', 3, '', ''),
(747, 742, '红岗区', 3, '', ''),
(748, 742, '大同区', 3, '', ''),
(749, 742, '林甸县', 3, '', ''),
(750, 742, '肇州县', 3, '', ''),
(751, 742, '肇源县', 3, '', ''),
(752, 742, '杜尔伯特蒙古族', 3, '', ''),
(753, 10, '伊春市', 2, '', ''),
(754, 753, '铁力市', 3, '', ''),
(755, 753, '嘉荫县', 3, '', ''),
(757, 10, '牡丹江市', 2, '', ''),
(758, 757, '海林市', 3, '', ''),
(760, 757, '宁安市', 3, '', ''),
(761, 757, '穆棱市', 3, '', ''),
(762, 757, '林口县', 3, '', ''),
(763, 757, '东宁县', 3, '', ''),
(765, 10, '佳木斯市', 2, '', ''),
(766, 765, '同江市', 3, '', ''),
(767, 765, '富锦市', 3, '', ''),
(768, 765, '桦川县', 3, '', ''),
(769, 765, '抚远县', 3, '', ''),
(770, 765, '桦南县', 3, '', ''),
(771, 765, '汤原县', 3, '', ''),
(773, 10, '七台河市', 2, '', ''),
(774, 773, '勃利县', 3, '', ''),
(776, 10, '黑河市', 2, '', ''),
(777, 776, '北安市', 3, '', ''),
(778, 776, '五大连池市', 3, '', ''),
(779, 776, '逊克县', 3, '', ''),
(780, 776, '孙吴县', 3, '', ''),
(782, 10, '绥化市', 2, '', ''),
(784, 782, '安达市', 3, '', ''),
(785, 782, '肇东市', 3, '', ''),
(786, 782, '海伦市', 3, '', ''),
(787, 782, '绥棱县', 3, '', ''),
(788, 782, '兰西县', 3, '', ''),
(789, 782, '明水县', 3, '', ''),
(790, 782, '青冈县', 3, '', ''),
(791, 782, '庆安县', 3, '', ''),
(792, 782, '望奎县', 3, '', ''),
(793, 10, '大兴安岭地区', 2, '', ''),
(794, 793, '呼玛县', 3, '', ''),
(795, 793, '塔河县', 3, '', ''),
(796, 793, '漠河县', 3, '', ''),
(799, 11, '呼和浩特市', 2, '', ''),
(801, 799, '土默特左旗', 3, '', ''),
(802, 799, '和林格尔县', 3, '', ''),
(803, 799, '武川县', 3, '', ''),
(804, 799, '托克托县', 3, '', ''),
(805, 11, '包头市', 2, '', ''),
(807, 805, '固阳县', 3, '', ''),
(808, 805, '土默特右旗', 3, '', ''),
(809, 805, '达尔罕茂明安联合旗', 3, '', ''),
(810, 11, '乌海市', 2, '', ''),
(811, 810, '海勃湾区', 3, '', ''),
(812, 11, '赤峰市', 2, '', ''),
(814, 812, '宁城县', 3, '', ''),
(815, 812, '敖汉旗', 3, '', ''),
(816, 812, '喀喇沁旗', 3, '', ''),
(817, 812, '翁牛特旗', 3, '', ''),
(818, 812, '巴林右旗', 3, '', ''),
(819, 812, '林西县', 3, '', ''),
(820, 812, '克什克腾旗', 3, '', ''),
(821, 812, '巴林左旗', 3, '', ''),
(822, 812, '阿鲁科尔沁旗', 3, '', ''),
(823, 11, '乌兰察布市', 2, '', ''),
(824, 823, '集宁区', 3, '', ''),
(825, 823, '丰镇市', 3, '', ''),
(826, 823, '兴和县', 3, '', ''),
(827, 823, '卓资县', 3, '', ''),
(828, 823, '商都县', 3, '', ''),
(829, 823, '凉城县', 3, '', ''),
(830, 823, '化德县', 3, '', ''),
(831, 823, '察哈尔右翼前旗', 3, '', ''),
(832, 823, '察哈尔右翼中旗', 3, '', ''),
(833, 823, '察哈尔右翼后旗', 3, '', ''),
(834, 823, '四子王旗', 3, '', ''),
(835, 11, '锡林郭勒盟', 2, '', ''),
(836, 835, '锡林浩特市', 3, '', ''),
(837, 835, '二连浩特市', 3, '', ''),
(838, 835, '多伦县', 3, '', ''),
(839, 835, '阿巴嘎旗', 3, '', ''),
(840, 835, '西乌朱穆沁旗', 3, '', ''),
(841, 835, '东乌朱穆沁旗', 3, '', ''),
(842, 835, '苏尼特右旗', 3, '', ''),
(843, 835, '苏尼特左旗', 3, '', ''),
(844, 835, '太仆寺旗', 3, '', ''),
(845, 835, '正镶白旗', 3, '', ''),
(846, 835, '正蓝旗', 3, '', ''),
(847, 835, '镶黄旗', 3, '', ''),
(848, 11, '呼伦贝尔市', 2, '', ''),
(849, 848, '海拉尔区', 3, '', ''),
(850, 848, '满洲里市', 3, '', ''),
(851, 848, '牙克石市', 3, '', ''),
(852, 848, '扎兰屯市', 3, '', ''),
(853, 848, '根河市', 3, '', ''),
(854, 848, '额尔古纳市', 3, '', ''),
(855, 848, '陈巴尔虎旗', 3, '', ''),
(856, 848, '阿荣旗', 3, '', ''),
(857, 848, '新巴尔虎左旗', 3, '', ''),
(858, 848, '新巴尔虎右旗', 3, '', ''),
(859, 848, '鄂伦春旗', 3, '', ''),
(860, 848, '莫力达瓦旗', 3, '', ''),
(861, 848, '鄂温克族旗', 3, '', ''),
(870, 11, '鄂尔多斯市', 2, '', ''),
(871, 870, '东胜区', 3, '', ''),
(872, 870, '准格尔旗', 3, '', ''),
(874, 870, '伊金霍洛旗', 3, '', ''),
(875, 870, '乌审旗', 3, '', ''),
(876, 870, '杭锦旗', 3, '', ''),
(877, 870, '鄂托克旗', 3, '', ''),
(878, 870, '鄂托克前旗', 3, '', ''),
(879, 870, '达拉特旗', 3, '', ''),
(880, 11, '巴彦淖尔市', 2, '', ''),
(881, 880, '临河区', 3, '', ''),
(882, 880, '五原县', 3, '', ''),
(883, 880, '磴口县', 3, '', ''),
(884, 880, '杭锦后旗', 3, '', ''),
(885, 880, '乌拉特中旗', 3, '', ''),
(888, 880, '乌拉特后旗', 3, '', ''),
(890, 880, '乌拉特前旗', 3, '', ''),
(891, 11, '阿拉善盟', 2, '', ''),
(892, 891, '阿拉善右旗', 3, '', ''),
(893, 891, '阿拉善左旗', 3, '', ''),
(894, 891, '额济纳旗', 3, '', ''),
(895, 11, '兴安盟', 2, '', ''),
(896, 895, '乌兰浩特市', 3, '', ''),
(897, 895, '阿尔山市', 3, '', ''),
(898, 895, '突泉县', 3, '', ''),
(899, 895, '扎赍特旗', 3, '', ''),
(900, 895, '科尔沁右翼前旗', 3, '', ''),
(901, 895, '科尔沁右翼中旗', 3, '', ''),
(902, 11, '通辽市', 2, '', ''),
(904, 12, '南京市', 2, '', ''),
(905, 904, '江宁区', 3, '', ''),
(907, 904, '高淳县', 3, '', ''),
(908, 904, '六合区', 3, '', ''),
(911, 12, '徐州市', 2, '', ''),
(912, 911, '邳州市', 3, '', ''),
(913, 911, '新沂市', 3, '', ''),
(914, 911, '铜山县', 3, '', ''),
(915, 911, '睢宁县', 3, '', ''),
(916, 911, '沛县', 3, '', ''),
(917, 911, '丰县', 3, '', ''),
(919, 12, '连云港市', 2, '', ''),
(920, 919, '赣榆县', 3, '', ''),
(921, 919, '灌云县', 3, '', ''),
(922, 919, '东海县', 3, '', ''),
(923, 919, '灌南县', 3, '', ''),
(925, 12, '淮安市', 2, '', ''),
(926, 925, '楚州区', 3, '', ''),
(929, 925, '洪泽县', 3, '', ''),
(930, 925, '金湖县', 3, '', ''),
(931, 925, '盱眙县', 3, '', ''),
(933, 12, '宿迁市', 2, '', ''),
(934, 933, '宿豫区', 3, '', ''),
(937, 933, '泗洪县', 3, '', ''),
(939, 12, '盐城市', 2, '', ''),
(940, 939, '东台市', 3, '', ''),
(941, 939, '大丰市', 3, '', ''),
(944, 939, '盐都区', 3, '', ''),
(945, 939, '建湖县', 3, '', ''),
(946, 939, '响水县', 3, '', ''),
(947, 939, '射阳县', 3, '', ''),
(948, 939, '阜宁县', 3, '', ''),
(949, 939, '滨海县', 3, '', ''),
(951, 12, '扬州市', 2, '', ''),
(953, 951, '江都市', 3, '', ''),
(954, 951, '仪征市', 3, '', ''),
(955, 951, '广陵区', 3, '', ''),
(956, 951, '邗江区', 3, '', ''),
(957, 951, '宝应县', 3, '', ''),
(959, 12, '泰州市', 2, '', ''),
(960, 959, '泰兴市', 3, '', ''),
(961, 959, '姜堰市', 3, '', ''),
(962, 959, '靖江市', 3, '', ''),
(963, 959, '兴化市', 3, '', ''),
(965, 12, '南通市', 2, '', ''),
(966, 965, '如皋市', 3, '', ''),
(967, 965, '通州区', 3, '', ''),
(968, 965, '海门市', 3, '', ''),
(969, 965, '启东市', 3, '', ''),
(970, 965, '如东县', 3, '', ''),
(972, 12, '镇江市', 2, '', ''),
(973, 972, '扬中市', 3, '', ''),
(974, 972, '丹阳市', 3, '', ''),
(975, 972, '句容市', 3, '', ''),
(976, 972, '丹徒区', 3, '', ''),
(978, 12, '常州市', 2, '', ''),
(980, 978, '金坛市', 3, '', ''),
(981, 978, '溧阳市', 3, '', ''),
(984, 12, '无锡市', 2, '', ''),
(988, 12, '苏州市', 2, '', ''),
(991, 988, '昆山市', 3, '', ''),
(993, 988, '常熟市', 3, '', ''),
(994, 988, '张家港市', 3, '', ''),
(997, 988, '吴江区', 3, '', ''),
(1000, 13, '济南市', 2, '', ''),
(1001, 1000, '章丘市', 3, '', ''),
(1002, 1000, '长清区', 3, '', ''),
(1003, 1000, '平阴县', 3, '', ''),
(1004, 1000, '济阳县', 3, '', ''),
(1005, 1000, '商河县', 3, '', ''),
(1007, 13, '青岛市', 2, '', ''),
(1013, 1007, '即墨市', 3, '', ''),
(1014, 1007, '莱西市', 3, '', ''),
(1016, 13, '淄博市', 2, '', ''),
(1019, 1016, '高青县', 3, '', ''),
(1020, 1016, '沂源县', 3, '', ''),
(1021, 1016, '桓台县', 3, '', ''),
(1022, 13, '枣庄市', 2, '', ''),
(1023, 1022, '滕州市', 3, '', ''),
(1025, 13, '东营市', 2, '', ''),
(1026, 1025, '河口区', 3, '', ''),
(1027, 1025, '广饶县', 3, '', ''),
(1028, 1025, '利津县', 3, '', ''),
(1029, 1025, '垦利县', 3, '', ''),
(1030, 1025, '东营区', 3, '', ''),
(1032, 13, '潍坊市', 2, '', ''),
(1033, 1032, '青州市', 3, '', ''),
(1034, 1032, '诸城市', 3, '', ''),
(1036, 1032, '安丘市', 3, '', ''),
(1037, 1032, '高密市', 3, '', ''),
(1038, 1032, '昌邑市', 3, '', ''),
(1039, 1032, '昌乐县', 3, '', ''),
(1041, 1032, '临朐县', 3, '', ''),
(1042, 13, '烟台市', 2, '', ''),
(1044, 1042, '莱阳市', 3, '', ''),
(1047, 1042, '招远市', 3, '', ''),
(1048, 1042, '蓬莱市', 3, '', ''),
(1049, 1042, '栖霞市', 3, '', ''),
(1050, 1042, '海阳市', 3, '', ''),
(1051, 1042, '长岛县', 3, '', ''),
(1053, 13, '威海市', 2, '', ''),
(1054, 1053, '乳山市', 3, '', ''),
(1056, 1053, '荣成市', 3, '', ''),
(1057, 1053, '环翠区', 3, '', ''),
(1058, 13, '莱芜市', 2, '', ''),
(1059, 1058, '莱城区', 3, '', ''),
(1060, 13, '德州市', 2, '', ''),
(1061, 1060, '乐陵市', 3, '', ''),
(1062, 1060, '禹城市', 3, '', ''),
(1063, 1060, '陵县', 3, '', ''),
(1064, 1060, '宁津县', 3, '', ''),
(1066, 1060, '武城县', 3, '', ''),
(1067, 1060, '庆云县', 3, '', ''),
(1068, 1060, '平原县', 3, '', ''),
(1069, 1060, '临邑县', 3, '', ''),
(1071, 1060, '夏津县', 3, '', ''),
(1072, 13, '临沂市', 2, '', ''),
(1073, 1072, '沂南县', 3, '', ''),
(1074, 1072, '沂水县', 3, '', ''),
(1075, 1072, '苍山县', 3, '', ''),
(1076, 1072, '费县', 3, '', ''),
(1077, 1072, '平邑县', 3, '', ''),
(1078, 1072, '蒙阴县', 3, '', ''),
(1079, 1072, '临沭县', 3, '', ''),
(1081, 13, '聊城市', 2, '', ''),
(1082, 1081, '临清市', 3, '', ''),
(1083, 1081, '东昌府区', 3, '', ''),
(1084, 1081, '阳谷县', 3, '', ''),
(1085, 1081, '茌平县', 3, '', ''),
(1086, 1081, '莘县', 3, '', ''),
(1087, 1081, '东阿县', 3, '', ''),
(1088, 1081, '冠县', 3, '', ''),
(1090, 13, '滨州市', 2, '', ''),
(1092, 1090, '邹平县', 3, '', ''),
(1093, 1090, '沾化县', 3, '', ''),
(1094, 1090, '惠民县', 3, '', ''),
(1095, 1090, '博兴县', 3, '', ''),
(1096, 1090, '阳信县', 3, '', ''),
(1099, 13, '菏泽市', 2, '', ''),
(1101, 1099, '单县', 3, '', ''),
(1102, 1099, '曹县', 3, '', ''),
(1103, 1099, '定陶县', 3, '', ''),
(1104, 1099, '巨野县', 3, '', ''),
(1105, 1099, '成武县', 3, '', ''),
(1106, 1099, '东明县', 3, '', ''),
(1107, 1099, '郓城县', 3, '', ''),
(1108, 13, '日照市', 2, '', ''),
(1111, 1108, '东港区', 3, '', ''),
(1112, 13, '泰安市', 2, '', ''),
(1114, 14, '铜陵市', 2, '', ''),
(1115, 1114, '铜陵县', 3, '', ''),
(1116, 14, '合肥市', 2, '', ''),
(1119, 1116, '肥东县', 3, '', ''),
(1121, 14, '淮南市', 2, '', ''),
(1122, 1121, '凤台县', 3, '', ''),
(1124, 14, '淮北市', 2, '', ''),
(1127, 14, '芜湖市', 2, '', ''),
(1128, 1127, '芜湖县', 3, '', ''),
(1129, 1127, '繁昌县', 3, '', ''),
(1130, 1127, '南陵县', 3, '', ''),
(1132, 14, '蚌埠市', 2, '', ''),
(1133, 1132, '怀远县', 3, '', ''),
(1134, 1132, '固镇县', 3, '', ''),
(1135, 1132, '五河县', 3, '', ''),
(1137, 14, '马鞍山市', 2, '', ''),
(1138, 1137, '当涂县', 3, '', ''),
(1139, 14, '当涂县', 2, '', ''),
(1140, 14, '安庆市', 2, '', ''),
(1141, 1140, '桐城市', 3, '', ''),
(1142, 1140, '宿松县', 3, '', ''),
(1143, 1140, '枞阳县', 3, '', ''),
(1144, 1140, '太湖县', 3, '', ''),
(1145, 1140, '怀宁县', 3, '', ''),
(1146, 1140, '岳西县', 3, '', ''),
(1147, 1140, '望江县', 3, '', ''),
(1148, 1140, '潜山县', 3, '', ''),
(1151, 14, '黄山市', 2, '', ''),
(1153, 1151, '休宁县', 3, '', ''),
(1154, 1151, '歙县', 3, '', ''),
(1155, 1151, '黟县', 3, '', ''),
(1156, 1151, '祁门县', 3, '', ''),
(1158, 15, '宁波市', 2, '', ''),
(1159, 14, '滁州市', 2, '', ''),
(1161, 1159, '明光市', 3, '', ''),
(1162, 1159, '全椒县', 3, '', ''),
(1163, 1159, '来安县', 3, '', ''),
(1164, 1159, '定远县', 3, '', ''),
(1165, 1159, '凤阳县', 3, '', ''),
(1167, 14, '阜阳市', 2, '', ''),
(1168, 1167, '界首市', 3, '', ''),
(1169, 1167, '太和县', 3, '', ''),
(1170, 1167, '阜南县', 3, '', ''),
(1171, 1167, '颍上县', 3, '', ''),
(1172, 1167, '临泉县', 3, '', ''),
(1174, 14, '亳州市', 2, '', ''),
(1176, 1174, '利辛县', 3, '', ''),
(1177, 1174, '蒙城县', 3, '', ''),
(1178, 1174, '涡阳县', 3, '', ''),
(1180, 14, '宿州市', 2, '', ''),
(1181, 1180, '灵壁县', 3, '', ''),
(1182, 1180, '泗县', 3, '', ''),
(1183, 1180, '萧县', 3, '', ''),
(1184, 1180, '砀山县', 3, '', ''),
(1187, 1137, '含山县', 3, '', ''),
(1188, 1137, '和县', 3, '', ''),
(1189, 1127, '无为县', 3, '', ''),
(1190, 1116, '庐江县', 3, '', ''),
(1201, 14, '池州市', 2, '', ''),
(1202, 1201, '东至县', 3, '', ''),
(1203, 1201, '石台县', 3, '', ''),
(1204, 1201, '青阳县', 3, '', ''),
(1206, 14, '六安市', 2, '', ''),
(1207, 1206, '寿县', 3, '', ''),
(1208, 1206, '霍山县', 3, '', ''),
(1209, 1206, '金寨县', 3, '', ''),
(1210, 1206, '霍邱县', 3, '', ''),
(1211, 1206, '舒城县', 3, '', ''),
(1213, 15, '杭州市', 2, '', ''),
(1214, 1213, '余杭区', 3, '', ''),
(1215, 1213, '萧山区', 3, '', ''),
(1217, 1213, '富阳市', 3, '', ''),
(1218, 1213, '桐庐县', 3, '', ''),
(1219, 1213, '建德市', 3, '', ''),
(1220, 1213, '淳安县', 3, '', ''),
(1224, 1158, '慈溪市', 3, '', ''),
(1225, 1158, '余姚市', 3, '', ''),
(1226, 1158, '奉化市', 3, '', ''),
(1227, 1158, '宁海县', 3, '', ''),
(1228, 1158, '象山县', 3, '', ''),
(1230, 1158, '北仑区', 3, '', ''),
(1233, 15, '温州市', 2, '', ''),
(1234, 1233, '瑞安市', 3, '', ''),
(1235, 1233, '乐清市', 3, '', ''),
(1237, 1233, '文成县', 3, '', ''),
(1238, 1233, '平阳县', 3, '', ''),
(1239, 1233, '泰顺县', 3, '', ''),
(1240, 1233, '洞头县', 3, '', ''),
(1241, 1233, '苍南县', 3, '', ''),
(1243, 15, '嘉兴市', 2, '', ''),
(1244, 1243, '海宁市', 3, '', ''),
(1248, 1243, '海盐县', 3, '', ''),
(1250, 15, '湖州市', 2, '', ''),
(1251, 1250, '长兴县', 3, '', ''),
(1252, 1250, '德清县', 3, '', ''),
(1253, 1250, '安吉县', 3, '', ''),
(1255, 15, '绍兴市', 2, '', ''),
(1257, 1255, '诸暨市', 3, '', ''),
(1258, 1255, '上虞市', 3, '', ''),
(1259, 1255, '嵊州市', 3, '', ''),
(1260, 1255, '新昌县', 3, '', ''),
(1261, 1255, '绍兴市市区', 3, '', ''),
(1262, 15, '金华市', 2, '', ''),
(1263, 1262, '金东区', 3, '', ''),
(1264, 1262, '兰溪市', 3, '', ''),
(1265, 1262, '婺城区', 3, '', ''),
(1266, 1262, '义乌市', 3, '', ''),
(1267, 1262, '东阳市', 3, '', ''),
(1268, 1262, '永康市', 3, '', ''),
(1269, 1262, '武义县', 3, '', ''),
(1270, 1262, '浦江县', 3, '', ''),
(1271, 1262, '磐安县', 3, '', ''),
(1273, 15, '衢州市', 2, '', ''),
(1275, 1273, '江山市', 3, '', ''),
(1276, 1273, '常山县', 3, '', ''),
(1277, 1273, '开化县', 3, '', ''),
(1278, 1273, '龙游县', 3, '', ''),
(1280, 15, '丽水市', 2, '', ''),
(1281, 1280, '龙泉市', 3, '', ''),
(1282, 1280, '缙云县', 3, '', ''),
(1283, 1280, '遂昌县', 3, '', ''),
(1284, 1280, '松阳县', 3, '', ''),
(1285, 1280, '景宁畚族自治县', 3, '', ''),
(1286, 1280, '云和县', 3, '', ''),
(1288, 1280, '青田县', 3, '', ''),
(1290, 15, '台州市', 2, '', ''),
(1291, 1290, '临海市', 3, '', ''),
(1292, 1290, '温岭市', 3, '', ''),
(1293, 1290, '玉环县', 3, '', ''),
(1294, 1290, '三门县', 3, '', ''),
(1295, 1290, '天台县', 3, '', ''),
(1296, 1290, '仙居县', 3, '', ''),
(1298, 15, '舟山市', 2, '', ''),
(1299, 1298, '普陀区', 3, '', ''),
(1300, 1298, '岱山县', 3, '', ''),
(1301, 1298, '嵊泗县', 3, '', ''),
(1303, 16, '福州市', 2, '', ''),
(1305, 1303, '长乐市', 3, '', ''),
(1308, 1303, '平潭县', 3, '', ''),
(1309, 1303, '连江县', 3, '', ''),
(1310, 84, '钓鱼岛', 2, '', ''),
(1311, 1310, '钓鱼岛', 3, '', ''),
(1312, 1303, '罗源县', 3, '', ''),
(1313, 1303, '永泰县', 3, '', ''),
(1314, 1303, '闽清县', 3, '', ''),
(1315, 16, '厦门市', 2, '', ''),
(1316, 1315, '思明区', 3, '', ''),
(1317, 16, '三明市', 2, '', ''),
(1319, 1317, '永安市', 3, '', ''),
(1320, 1317, '明溪县', 3, '', ''),
(1321, 1317, '将乐县', 3, '', ''),
(1322, 1317, '大田县', 3, '', ''),
(1323, 1317, '宁化县', 3, '', ''),
(1324, 1317, '建宁县', 3, '', ''),
(1325, 1317, '沙县', 3, '', ''),
(1326, 1317, '尤溪县', 3, '', ''),
(1327, 1317, '清流县', 3, '', ''),
(1328, 1317, '泰宁县', 3, '', ''),
(1329, 16, '莆田市', 2, '', ''),
(1331, 1329, '仙游县', 3, '', ''),
(1332, 16, '泉州市', 2, '', ''),
(1334, 1332, '石狮市', 3, '', ''),
(1336, 1332, '南安市', 3, '', ''),
(1337, 1332, '惠安县', 3, '', ''),
(1338, 1332, '安溪县', 3, '', ''),
(1339, 1332, '德化县', 3, '', ''),
(1340, 1332, '永春县', 3, '', ''),
(1341, 16, '漳州市', 2, '', ''),
(1343, 1341, '龙海市', 3, '', ''),
(1344, 1341, '平和县', 3, '', ''),
(1345, 1341, '南靖县', 3, '', ''),
(1346, 1341, '诏安县', 3, '', ''),
(1347, 1341, '漳浦县', 3, '', ''),
(1348, 1341, '华安县', 3, '', ''),
(1349, 1341, '云霄县', 3, '', ''),
(1350, 1341, '东山县', 3, '', ''),
(1351, 1341, '长泰县', 3, '', ''),
(1352, 16, '南平市', 2, '', ''),
(1354, 1352, '建瓯市', 3, '', ''),
(1355, 1352, '邵武市', 3, '', ''),
(1356, 1352, '武夷山市', 3, '', ''),
(1357, 1352, '建阳市', 3, '', ''),
(1358, 1352, '松溪县', 3, '', ''),
(1359, 1352, '顺昌县', 3, '', ''),
(1360, 1352, '浦城县', 3, '', ''),
(1361, 1352, '政和县', 3, '', ''),
(1362, 16, '龙岩市', 2, '', ''),
(1364, 1362, '漳平市', 3, '', ''),
(1365, 1362, '长汀县', 3, '', ''),
(1366, 1362, '武平县', 3, '', ''),
(1367, 1362, '永定县', 3, '', ''),
(1368, 1362, '上杭县', 3, '', ''),
(1369, 1362, '连城县', 3, '', ''),
(1370, 16, '宁德市', 2, '', ''),
(1372, 1370, '福安市', 3, '', ''),
(1373, 1370, '福鼎市', 3, '', ''),
(1374, 1370, '寿宁县', 3, '', ''),
(1375, 1370, '霞浦县', 3, '', ''),
(1376, 1370, '柘荣县', 3, '', ''),
(1377, 1370, '屏南县', 3, '', ''),
(1378, 1370, '古田县', 3, '', ''),
(1379, 1370, '周宁县', 3, '', ''),
(1381, 17, '武汉市', 2, '', ''),
(1383, 1381, '江夏区', 3, '', ''),
(1384, 1381, '新洲区', 3, '', ''),
(1386, 1381, '江岸区', 3, '', ''),
(1387, 17, '黄石市', 2, '', ''),
(1389, 1387, '黄石港区', 3, '', ''),
(1391, 1387, '下陆区', 3, '', ''),
(1392, 1387, '铁山区', 3, '', ''),
(1393, 1387, '大冶市', 3, '', ''),
(1394, 1387, '阳新县', 3, '', ''),
(1396, 17, '襄阳市', 2, '', ''),
(1397, 1396, '老河口市', 3, '', ''),
(1398, 1396, '枣阳市', 3, '', ''),
(1399, 1396, '宜城市', 3, '', ''),
(1401, 1396, '南漳县', 3, '', ''),
(1402, 1396, '保康县', 3, '', ''),
(1403, 1396, '谷城县', 3, '', ''),
(1405, 17, '十堰市', 2, '', ''),
(1406, 1405, '丹江口市', 3, '', ''),
(1407, 1405, '房县', 3, '', ''),
(1408, 1405, '竹山县', 3, '', ''),
(1409, 1405, '竹溪县', 3, '', ''),
(1410, 1405, '郧县', 3, '', ''),
(1411, 1405, '郧西县', 3, '', ''),
(1413, 17, '荆州市', 2, '', ''),
(1414, 1413, '江陵县', 3, '', ''),
(1415, 1413, '洪湖市', 3, '', ''),
(1416, 1413, '石首市', 3, '', ''),
(1417, 1413, '松滋市', 3, '', ''),
(1418, 1413, '监利县', 3, '', ''),
(1419, 1413, '公安县', 3, '', ''),
(1421, 17, '宜昌市', 2, '', ''),
(1423, 1421, '当阳市', 3, '', ''),
(1424, 1421, '枝江市', 3, '', ''),
(1425, 1421, '夷陵区', 3, '', ''),
(1426, 1421, '秭归县', 3, '', ''),
(1427, 1421, '兴山县', 3, '', ''),
(1428, 1421, '远安县', 3, '', ''),
(1429, 1421, '五峰土家族自治县', 3, '', ''),
(1430, 1421, '长阳土家族自治县', 3, '', ''),
(1432, 17, '孝感市', 2, '', ''),
(1433, 1432, '应城市', 3, '', ''),
(1434, 1432, '安陆市', 3, '', ''),
(1435, 1432, '汉川市', 3, '', ''),
(1437, 1432, '云梦县', 3, '', ''),
(1438, 1432, '大悟县', 3, '', ''),
(1439, 1432, '孝昌县', 3, '', ''),
(1441, 17, '黄冈市', 2, '', ''),
(1442, 1441, '麻城市', 3, '', ''),
(1443, 1441, '武穴市', 3, '', ''),
(1444, 1441, '红安县', 3, '', ''),
(1445, 1441, '罗田县', 3, '', ''),
(1446, 1441, '浠水县', 3, '', ''),
(1447, 1441, '黄梅县', 3, '', ''),
(1448, 1441, '英山县', 3, '', ''),
(1449, 1441, '团风县', 3, '', ''),
(1457, 1441, '蕲春县', 3, '', ''),
(1458, 17, '咸宁市', 2, '', ''),
(1459, 1458, '咸安区', 3, '', ''),
(1461, 1458, '嘉鱼县', 3, '', ''),
(1462, 1458, '通山县', 3, '', ''),
(1463, 1458, '崇阳县', 3, '', ''),
(1464, 1458, '通城县', 3, '', ''),
(1466, 17, '恩施州', 2, '', ''),
(1467, 1466, '恩施市', 3, '', ''),
(1468, 1466, '利川市', 3, '', ''),
(1469, 1466, '建始县', 3, '', ''),
(1470, 1466, '来凤县', 3, '', ''),
(1471, 1466, '巴东县', 3, '', ''),
(1472, 1466, '鹤峰县', 3, '', ''),
(1473, 1466, '宣恩县', 3, '', ''),
(1474, 1466, '咸丰县', 3, '', ''),
(1475, 17, '鄂州市', 2, '', ''),
(1477, 17, '荆门市', 2, '', ''),
(1478, 1477, '京山县', 3, '', ''),
(1479, 17, '随州市', 2, '', ''),
(1481, 1432, '孝南区', 3, '', ''),
(1482, 18, '长沙市', 2, '', ''),
(1483, 1482, '浏阳市', 3, '', ''),
(1485, 1482, '望城县', 3, '', ''),
(1486, 1482, '宁乡县', 3, '', ''),
(1488, 18, '株洲市', 2, '', ''),
(1489, 1488, '醴陵市', 3, '', ''),
(1490, 1488, '株洲县', 3, '', ''),
(1491, 1488, '攸县', 3, '', ''),
(1492, 1488, '茶陵县', 3, '', ''),
(1493, 1488, '炎陵县', 3, '', ''),
(1494, 1488, '天元区', 3, '', ''),
(1495, 18, '湘潭市', 2, '', ''),
(1496, 1495, '湘乡市', 3, '', ''),
(1497, 1495, '湘潭县', 3, '', ''),
(1498, 1495, '韶山市', 3, '', ''),
(1499, 18, '韶山市', 2, '', ''),
(1500, 1499, '韶山市区内', 3, '', ''),
(1501, 18, '衡阳市', 2, '', ''),
(1502, 1501, '常宁市', 3, '', ''),
(1503, 1501, '衡阳县', 3, '', ''),
(1504, 1501, '耒阳市', 3, '', ''),
(1505, 1501, '衡东县', 3, '', ''),
(1506, 1501, '衡南县', 3, '', ''),
(1507, 1501, '衡山县', 3, '', ''),
(1508, 1501, '祁东县', 3, '', ''),
(1509, 1501, '南岳区', 3, '', ''),
(1511, 18, '邵阳市', 2, '', ''),
(1512, 1511, '武冈市', 3, '', ''),
(1513, 1511, '邵东县', 3, '', ''),
(1514, 1511, '洞口县', 3, '', ''),
(1515, 1511, '新邵县', 3, '', ''),
(1516, 1511, '绥宁县', 3, '', ''),
(1517, 1511, '新宁县', 3, '', ''),
(1518, 1511, '邵阳县', 3, '', ''),
(1519, 1511, '隆回县', 3, '', ''),
(1520, 1511, '城步苗族自治县', 3, '', ''),
(1521, 1511, '北塔区', 3, '', ''),
(1522, 18, '岳阳市', 2, '', ''),
(1523, 1522, '临湘市', 3, '', ''),
(1524, 1522, '汩罗市', 3, '', ''),
(1525, 1522, '岳阳县', 3, '', ''),
(1526, 1522, '湘阴县', 3, '', ''),
(1527, 1522, '华容县', 3, '', ''),
(1528, 1522, '平江县', 3, '', ''),
(1530, 18, '常德市', 2, '', ''),
(1532, 1530, '津市市', 3, '', ''),
(1533, 1530, '澧县', 3, '', ''),
(1534, 1530, '临澧县', 3, '', ''),
(1535, 1530, '桃源县', 3, '', ''),
(1536, 1530, '汉寿县', 3, '', ''),
(1537, 1530, '石门县', 3, '', ''),
(1538, 1530, '安乡县', 3, '', ''),
(1539, 1530, '鼎城区', 3, '', ''),
(1540, 18, '张家界市', 2, '', ''),
(1541, 1540, '慈利县', 3, '', ''),
(1542, 1540, '桑植县', 3, '', ''),
(1543, 1540, '武陵源区', 3, '', ''),
(1544, 18, '郴州市', 2, '', ''),
(1545, 1544, '资兴市', 3, '', ''),
(1546, 1544, '宜章县', 3, '', ''),
(1547, 1544, '安仁县', 3, '', ''),
(1548, 1544, '汝城县', 3, '', ''),
(1549, 1544, '嘉禾县', 3, '', ''),
(1550, 1544, '临武县', 3, '', ''),
(1551, 1544, '桂东县', 3, '', ''),
(1552, 1544, '永兴县', 3, '', ''),
(1553, 1544, '桂阳县', 3, '', ''),
(1554, 1544, '苏仙区', 3, '', ''),
(1555, 18, '益阳市', 2, '', ''),
(1556, 1555, '南县', 3, '', ''),
(1557, 1555, '桃江县', 3, '', ''),
(1558, 1555, '安化县', 3, '', ''),
(1559, 1555, '资阳区', 3, '', ''),
(1560, 18, '永州市', 2, '', ''),
(1561, 1560, '冷水滩区', 3, '', ''),
(1563, 1560, '祁阳县', 3, '', ''),
(1564, 1560, '双牌县', 3, '', ''),
(1565, 1555, '沅江市', 3, '', ''),
(1566, 1560, '道县', 3, '', ''),
(1567, 1560, '江永县', 3, '', ''),
(1568, 1560, '江华瑶族自治县', 3, '', ''),
(1569, 1560, '宁远县', 3, '', ''),
(1570, 1560, '新田县', 3, '', ''),
(1571, 1560, '蓝山县', 3, '', ''),
(1572, 1560, '东安县', 3, '', ''),
(1573, 1560, '零陵区', 3, '', ''),
(1574, 18, '怀化市', 2, '', ''),
(1575, 1574, '洪江市', 3, '', ''),
(1576, 1574, '会同县', 3, '', ''),
(1578, 1574, '溆浦县', 3, '', ''),
(1579, 1574, '辰溪县', 3, '', ''),
(1580, 1574, '靖州苗族侗族自治县', 3, '', ''),
(1581, 1574, '通道侗族自治县', 3, '', ''),
(1582, 1574, '芷江侗族自治县', 3, '', ''),
(1583, 1574, '新晃侗族自治县', 3, '', ''),
(1584, 1574, '麻阳苗族自治县', 3, '', ''),
(1586, 18, '娄底市', 2, '', ''),
(1588, 1586, '冷水江市', 3, '', ''),
(1589, 1586, '涟源市', 3, '', ''),
(1590, 1586, '新化县', 3, '', ''),
(1591, 1586, '双峰县', 3, '', ''),
(1592, 18, '湘西州', 2, '', ''),
(1593, 1592, '吉首市', 3, '', ''),
(1594, 1592, '古丈县', 3, '', ''),
(1595, 1592, '龙山县', 3, '', ''),
(1596, 1592, '永顺县', 3, '', ''),
(1597, 1592, '泸溪县', 3, '', ''),
(1598, 1592, '凤凰县', 3, '', ''),
(1599, 1592, '花垣县', 3, '', ''),
(1600, 1592, '保靖县', 3, '', ''),
(1601, 19, '广州市', 2, '', ''),
(1602, 1601, '花都区', 3, '', ''),
(1603, 1601, '番禺区', 3, '', ''),
(1604, 1601, '从化市', 3, '', ''),
(1607, 19, '深圳市', 2, '', ''),
(1609, 19, '珠海市', 2, '', ''),
(1611, 19, '汕头市', 2, '', ''),
(1614, 1611, '南澳县', 3, '', ''),
(1615, 1611, '金平区', 3, '', ''),
(1616, 1611, '濠江区', 3, '', ''),
(1617, 19, '韶关市', 2, '', ''),
(1618, 1617, '南雄市', 3, '', ''),
(1619, 1617, '乐昌市', 3, '', ''),
(1620, 1617, '仁化县', 3, '', ''),
(1621, 1617, '始兴县', 3, '', ''),
(1622, 1617, '翁源县', 3, '', ''),
(1624, 1617, '新丰县', 3, '', ''),
(1625, 1617, '乳源瑶族自治县', 3, '', ''),
(1626, 1617, '曲江区', 3, '', ''),
(1627, 19, '河源市', 2, '', ''),
(1628, 1627, '和平县', 3, '', ''),
(1629, 1627, '龙川县', 3, '', ''),
(1630, 1627, '紫金县', 3, '', ''),
(1631, 1627, '连平县', 3, '', ''),
(1632, 1627, '东源县', 3, '', ''),
(1634, 19, '梅州市', 2, '', ''),
(1635, 1634, '兴宁市', 3, '', ''),
(1636, 1634, '梅县', 3, '', ''),
(1637, 1634, '蕉岭县', 3, '', ''),
(1638, 1634, '大埔县', 3, '', ''),
(1639, 1634, '丰顺县', 3, '', ''),
(1640, 1634, '五华县', 3, '', ''),
(1641, 1634, '平远县', 3, '', ''),
(1642, 1634, '梅江区', 3, '', ''),
(1643, 19, '惠州市', 2, '', ''),
(1644, 1643, '惠阳区', 3, '', ''),
(1647, 1643, '龙门县', 3, '', ''),
(1650, 19, '汕尾市', 2, '', ''),
(1653, 1650, '陆河县', 3, '', ''),
(1654, 1650, '城区', 3, '', ''),
(1655, 19, '东莞市', 2, '', ''),
(1656, 1655, '东城区', 3, '', ''),
(1657, 19, '中山市', 2, '', ''),
(1658, 1657, '中山市区内', 3, '', ''),
(1659, 19, '江门市', 2, '', ''),
(1660, 1659, '台山市', 3, '', ''),
(1663, 1659, '鹤山市', 3, '', ''),
(1665, 1659, '江海区', 3, '', ''),
(1666, 19, '佛山市', 2, '', ''),
(1667, 1666, '三水区', 3, '', ''),
(1668, 1666, '南海区', 3, '', ''),
(1669, 1666, '顺德区', 3, '', ''),
(1671, 1666, '禅城区', 3, '', ''),
(1672, 19, '阳江市', 2, '', ''),
(1673, 1672, '阳春市', 3, '', ''),
(1674, 1672, '阳西县', 3, '', ''),
(1675, 1672, '阳东县', 3, '', ''),
(1677, 19, '湛江市', 2, '', ''),
(1679, 1677, '雷州市', 3, '', ''),
(1680, 1677, '吴川市', 3, '', ''),
(1682, 1677, '徐闻县', 3, '', ''),
(1683, 1677, '麻章区', 3, '', ''),
(1684, 19, '茂名市', 2, '', ''),
(1687, 1684, '信宜市', 3, '', ''),
(1690, 19, '肇庆市', 2, '', ''),
(1691, 1690, '高要市', 3, '', ''),
(1692, 1690, '四会市', 3, '', ''),
(1693, 1690, '广宁县', 3, '', ''),
(1694, 1690, '德庆县', 3, '', ''),
(1695, 1690, '怀集县', 3, '', ''),
(1696, 1690, '封开县', 3, '', ''),
(1697, 1690, '鼎湖区', 3, '', ''),
(1698, 19, '云浮市', 2, '', ''),
(1700, 1698, '云安县', 3, '', ''),
(1701, 1698, '新兴县', 3, '', ''),
(1702, 1698, '郁南县', 3, '', ''),
(1703, 1698, '云城区', 3, '', ''),
(1704, 19, '清远市', 2, '', ''),
(1705, 19, '潮州市', 2, '', ''),
(1707, 1705, '饶平县', 3, '', ''),
(1709, 19, '揭阳市', 2, '', ''),
(1711, 1709, '揭东县', 3, '', ''),
(1712, 1709, '揭西县', 3, '', ''),
(1713, 1709, '惠来县', 3, '', ''),
(1715, 20, '南宁市', 2, '', ''),
(1716, 1715, '武鸣县', 3, '', ''),
(1720, 20, '柳州市', 2, '', ''),
(1721, 1720, '柳江县', 3, '', ''),
(1722, 1720, '柳城县', 3, '', ''),
(1724, 1715, '邕宁区', 3, '', ''),
(1725, 1720, '鹿寨县', 3, '', ''),
(1726, 20, '桂林市', 2, '', ''),
(1727, 1726, '阳朔县', 3, '', ''),
(1728, 1726, '临桂县', 3, '', ''),
(1729, 1726, '灵川县', 3, '', ''),
(1730, 1726, '全州县', 3, '', ''),
(1731, 1726, '平乐县', 3, '', ''),
(1732, 1726, '兴安县', 3, '', ''),
(1733, 1726, '灌阳县', 3, '', ''),
(1734, 1726, '荔浦县', 3, '', ''),
(1735, 1726, '资源县', 3, '', ''),
(1736, 1726, '永福县', 3, '', ''),
(1738, 1726, '龙胜各族自治县', 3, '', ''),
(1740, 20, '梧州市', 2, '', ''),
(1741, 1740, '岑溪市', 3, '', ''),
(1742, 1740, '苍梧县', 3, '', ''),
(1743, 1740, '藤县', 3, '', ''),
(1744, 1740, '蒙山县', 3, '', ''),
(1745, 1740, '长洲区', 3, '', ''),
(1746, 20, '北海市', 2, '', ''),
(1747, 1746, '合浦县', 3, '', ''),
(1748, 1746, '铁山港区', 3, '', ''),
(1749, 20, '防城港市', 2, '', ''),
(1750, 1749, '东兴市', 3, '', ''),
(1751, 1749, '上思县', 3, '', ''),
(1753, 20, '钦州市', 2, '', ''),
(1754, 1753, '浦北县', 3, '', ''),
(1755, 1753, '灵山县', 3, '', ''),
(1756, 1753, '钦南区', 3, '', ''),
(1757, 20, '贵港市', 2, '', ''),
(1758, 1757, '桂平市', 3, '', ''),
(1759, 1757, '平南县', 3, '', ''),
(1760, 1757, '覃塘区', 3, '', ''),
(1761, 20, '玉林市', 2, '', ''),
(1762, 1761, '北流市', 3, '', ''),
(1763, 1761, '容县', 3, '', ''),
(1764, 1761, '博白县', 3, '', ''),
(1765, 1761, '陆川县', 3, '', ''),
(1766, 1761, '兴业县', 3, '', ''),
(1767, 1761, '玉州区', 3, '', ''),
(1792, 20, '贺州市', 2, '', ''),
(1795, 1704, '连州市', 3, '', ''),
(1796, 1704, '佛冈县', 3, '', ''),
(1797, 1704, '阳山县', 3, '', ''),
(1798, 1704, '清新县', 3, '', ''),
(1799, 1704, '连山壮族瑶族自治县', 3, '', ''),
(1800, 1704, '连南瑶族自治区', 3, '', ''),
(1801, 1704, '清城区', 3, '', ''),
(1802, 1792, '八步区', 3, '', ''),
(1803, 1792, '钟山县', 3, '', ''),
(1804, 1792, '昭平县', 3, '', ''),
(1805, 1792, '富川瑶族自治县', 3, '', ''),
(1806, 20, '百色市', 2, '', ''),
(1807, 1806, '右江区', 3, '', ''),
(1808, 1806, '平果县', 3, '', ''),
(1809, 1806, '乐业县', 3, '', ''),
(1810, 1806, '田阳县', 3, '', ''),
(1811, 1806, '西林县', 3, '', ''),
(1812, 1806, '田林县', 3, '', ''),
(1813, 1806, '德保县', 3, '', ''),
(1814, 1806, '靖西县', 3, '', ''),
(1815, 1806, '田东县', 3, '', ''),
(1816, 1806, '那坡县', 3, '', ''),
(1817, 1806, '隆林县', 3, '', ''),
(1818, 20, '河池市', 2, '', ''),
(1820, 1818, '宜州市', 3, '', ''),
(1821, 1818, '天峨县', 3, '', ''),
(1822, 1818, '凤山县', 3, '', ''),
(1823, 1818, '南丹县', 3, '', ''),
(1824, 1818, '东兰县', 3, '', ''),
(1825, 1818, '巴马县', 3, '', ''),
(1826, 1818, '环江县', 3, '', ''),
(1827, 21, '南昌市', 2, '', ''),
(1828, 1827, '南昌县', 3, '', ''),
(1829, 1827, '进贤县', 3, '', ''),
(1830, 1827, '安义县', 3, '', ''),
(1832, 21, '景德镇市', 2, '', ''),
(1833, 1832, '乐平市', 3, '', ''),
(1834, 1832, '浮梁县', 3, '', ''),
(1836, 21, '萍乡市', 2, '', ''),
(1837, 1836, '湘东区', 3, '', ''),
(1838, 1836, '莲花县', 3, '', ''),
(1839, 1836, '上栗县', 3, '', ''),
(1840, 1836, '芦溪县', 3, '', ''),
(1842, 21, '新余市', 2, '', ''),
(1843, 1842, '分宜县', 3, '', ''),
(1845, 21, '九江市', 2, '', ''),
(1846, 1845, '九江县', 3, '', ''),
(1847, 1845, '瑞昌市', 3, '', ''),
(1848, 1845, '星子县', 3, '', ''),
(1849, 1845, '武宁县', 3, '', ''),
(1850, 1845, '澎泽县', 3, '', ''),
(1851, 1845, '永修县', 3, '', ''),
(1852, 1845, '修水县', 3, '', ''),
(1853, 1845, '湖口县', 3, '', ''),
(1854, 1845, '德安县', 3, '', ''),
(1855, 1845, '都昌县', 3, '', ''),
(1857, 21, '鹰潭市', 2, '', ''),
(1858, 1857, '余江县', 3, '', ''),
(1859, 1857, '贵溪市', 3, '', ''),
(1860, 1857, '月湖区', 3, '', ''),
(1861, 21, '上饶市', 2, '', ''),
(1863, 1861, '德兴市', 3, '', ''),
(1864, 1861, '广丰县', 3, '', ''),
(1865, 1861, '鄱阳县', 3, '', ''),
(1866, 1861, '婺源县', 3, '', ''),
(1867, 1861, '余干县', 3, '', ''),
(1868, 1861, '横峰县', 3, '', ''),
(1869, 1861, '弋阳县', 3, '', ''),
(1870, 1861, '铅山县', 3, '', ''),
(1871, 1861, '玉山县', 3, '', ''),
(1872, 1861, '万年县', 3, '', ''),
(1874, 21, '宜春市', 2, '', ''),
(1875, 1874, '丰城市', 3, '', ''),
(1876, 1874, '樟树市', 3, '', ''),
(1877, 1874, '高安市', 3, '', ''),
(1878, 1874, '铜鼓县', 3, '', ''),
(1879, 1874, '靖安县', 3, '', ''),
(1880, 1874, '宜丰县', 3, '', ''),
(1881, 1874, '奉新县', 3, '', ''),
(1882, 1874, '万载县', 3, '', ''),
(1883, 1874, '上高县', 3, '', ''),
(1885, 21, '抚州市', 2, '', ''),
(1886, 1885, '临川区', 3, '', ''),
(1887, 1885, '南丰县', 3, '', ''),
(1888, 1885, '乐安县', 3, '', ''),
(1889, 1885, '金溪县', 3, '', ''),
(1890, 1885, '南城县', 3, '', ''),
(1891, 1885, '东乡县', 3, '', ''),
(1892, 1885, '资溪县', 3, '', ''),
(1893, 1885, '宜黄县', 3, '', ''),
(1894, 1885, '崇仁县', 3, '', ''),
(1895, 1885, '黎川县', 3, '', ''),
(1896, 1885, '广昌县', 3, '', ''),
(1898, 21, '吉安市', 2, '', ''),
(1899, 1898, '井冈山市', 3, '', ''),
(1900, 1898, '吉安县', 3, '', ''),
(1901, 1898, '永丰县', 3, '', ''),
(1902, 1898, '永新县', 3, '', ''),
(1903, 1898, '新干县', 3, '', ''),
(1904, 1898, '泰和县', 3, '', ''),
(1905, 1898, '峡江县', 3, '', ''),
(1906, 1898, '遂川县', 3, '', ''),
(1907, 1898, '安福县', 3, '', ''),
(1908, 1898, '吉水县', 3, '', ''),
(1909, 1898, '万安县', 3, '', ''),
(1910, 1898, '吉州区', 3, '', ''),
(1911, 21, '赣州市', 2, '', ''),
(1912, 1911, '南康市', 3, '', ''),
(1913, 1911, '瑞金市', 3, '', ''),
(1914, 1911, '石城县', 3, '', ''),
(1915, 1911, '安远县', 3, '', ''),
(1916, 1911, '赣县', 3, '', ''),
(1917, 1911, '宁都县', 3, '', ''),
(1918, 1911, '寻乌县', 3, '', ''),
(1919, 1911, '兴国县', 3, '', ''),
(1920, 1911, '定南县', 3, '', ''),
(1921, 1911, '上犹县', 3, '', ''),
(1922, 1911, '于都县', 3, '', ''),
(1923, 1911, '龙南县', 3, '', ''),
(1924, 1911, '崇义县', 3, '', ''),
(1925, 1911, '大余县', 3, '', ''),
(1926, 1911, '信丰县', 3, '', ''),
(1927, 1911, '全南县', 3, '', ''),
(1928, 1911, '会昌县', 3, '', ''),
(1930, 22, '成都市', 2, '', ''),
(1931, 1930, '龙泉驿区', 3, '', ''),
(1933, 1930, '都江堰市', 3, '', ''),
(1935, 1930, '崇州市', 3, '', ''),
(1936, 1930, '金堂县', 3, '', ''),
(1938, 1930, '新津县', 3, '', ''),
(1940, 1930, '郫县', 3, '', ''),
(1941, 1930, '双流县', 3, '', ''),
(1942, 1930, '邛崃市', 3, '', ''),
(1944, 1930, '大邑县', 3, '', ''),
(1946, 22, '自贡市', 2, '', ''),
(1947, 1946, '荣县', 3, '', ''),
(1948, 1946, '富顺县', 3, '', ''),
(1949, 1946, '自流井区', 3, '', ''),
(1950, 22, '攀枝花市', 2, '', ''),
(1951, 1950, '米易县', 3, '', ''),
(1952, 1950, '盐边县', 3, '', ''),
(1953, 1950, '仁和区', 3, '', ''),
(1954, 22, '泸州市', 2, '', ''),
(1955, 1954, '泸县', 3, '', ''),
(1956, 1954, '合江县', 3, '', ''),
(1957, 1954, '叙永县', 3, '', ''),
(1958, 1954, '古蔺县', 3, '', ''),
(1959, 1954, '江阳区', 3, '', ''),
(1960, 22, '绵阳市', 2, '', ''),
(1962, 22, '德阳市', 2, '', ''),
(1963, 1962, '广汉市', 3, '', ''),
(1964, 1962, '什邡市', 3, '', ''),
(1965, 1962, '罗江县', 3, '', ''),
(1966, 1962, '中江县', 3, '', ''),
(1967, 1962, '旌阳区', 3, '', ''),
(1970, 1960, '盐亭县', 3, '', ''),
(1971, 1960, '三台县', 3, '', ''),
(1972, 1960, '平武县', 3, '', ''),
(1973, 1960, '北川羌族自治县', 3, '', ''),
(1974, 1960, '安县', 3, '', ''),
(1975, 1960, '梓潼县', 3, '', ''),
(1976, 1960, '涪城区', 3, '', ''),
(1977, 22, '广元市', 2, '', ''),
(1978, 1977, '青川县', 3, '', ''),
(1979, 1977, '旺苍县', 3, '', ''),
(1980, 1977, '剑阁县', 3, '', ''),
(1981, 1977, '苍溪县', 3, '', ''),
(1982, 1977, '利州区', 3, '', ''),
(1983, 22, '遂宁市', 2, '', ''),
(1984, 1983, '射洪县', 3, '', ''),
(1985, 1983, '蓬溪县', 3, '', ''),
(1986, 1983, '大英县', 3, '', ''),
(1987, 1983, '安居区', 3, '', ''),
(1988, 22, '内江市', 2, '', ''),
(1989, 1988, '资中县', 3, '', ''),
(1990, 1988, '隆昌县', 3, '', ''),
(1991, 1988, '威远县', 3, '', ''),
(1992, 1988, '市中区', 3, '', ''),
(1993, 22, '乐山市', 2, '', ''),
(1994, 1993, '五通桥区', 3, '', ''),
(1995, 1993, '沙湾区', 3, '', ''),
(1996, 1993, '金口河区', 3, '', ''),
(1997, 1993, '峨眉山市', 3, '', ''),
(1998, 1993, '夹江县', 3, '', ''),
(1999, 1993, '井研县', 3, '', ''),
(2000, 1993, '犍为县', 3, '', ''),
(2001, 1993, '沐川县', 3, '', ''),
(2002, 1993, '峨边彝族自治县', 3, '', ''),
(2003, 1993, '马边彝族自治县', 3, '', ''),
(2004, 1993, '市中区', 3, '', ''),
(2005, 22, '宜宾市', 2, '', ''),
(2006, 2005, '宜宾县', 3, '', ''),
(2007, 2005, '南溪县', 3, '', ''),
(2008, 2005, '江安县', 3, '', ''),
(2009, 2005, '长宁县', 3, '', ''),
(2010, 2005, '兴文县', 3, '', ''),
(2011, 2005, '珙县', 3, '', ''),
(2012, 2005, '高县', 3, '', ''),
(2013, 2005, '屏山县', 3, '', ''),
(2015, 2005, '筠连县', 3, '', ''),
(2016, 22, '广安市', 2, '', ''),
(2017, 2016, '岳池县', 3, '', ''),
(2018, 2016, '武胜县', 3, '', ''),
(2019, 2016, '邻水县', 3, '', ''),
(2020, 2016, '广安区', 3, '', ''),
(2021, 2016, '华蓥市', 3, '', ''),
(2022, 22, '南充市', 2, '', ''),
(2023, 2022, '顺庆区', 3, '', ''),
(2024, 2022, '高坪区', 3, '', ''),
(2025, 2022, '嘉陵区', 3, '', ''),
(2026, 2022, '南部县', 3, '', ''),
(2027, 2022, '西充县', 3, '', ''),
(2028, 2022, '仪陇县', 3, '', ''),
(2029, 2022, '蓬安县', 3, '', ''),
(2030, 2022, '营山县', 3, '', ''),
(2032, 2022, '阆中市', 3, '', ''),
(2033, 22, '达州市', 2, '', ''),
(2034, 2033, '通川区', 3, '', ''),
(2035, 2033, '达县', 3, '', ''),
(2036, 2033, '大竹县', 3, '', ''),
(2037, 2033, '渠县', 3, '', ''),
(2038, 2033, '万源市', 3, '', ''),
(2039, 2033, '宣汉县', 3, '', ''),
(2040, 2033, '开江县', 3, '', ''),
(2042, 22, '巴中市', 2, '', ''),
(2044, 2042, '南江县', 3, '', ''),
(2045, 2042, '平昌县', 3, '', ''),
(2046, 2042, '通江县', 3, '', ''),
(2047, 22, '雅安市', 2, '', ''),
(2049, 2047, '芦山县', 3, '', ''),
(2052, 2047, '石棉县', 3, '', ''),
(2053, 2047, '名山县', 3, '', ''),
(2054, 2047, '天全县', 3, '', ''),
(2055, 2047, '荥经县', 3, '', ''),
(2056, 2047, '汉源县', 3, '', ''),
(2057, 2047, '宝兴县', 3, '', ''),
(2058, 22, '眉山市', 2, '', ''),
(2059, 2058, '东坡区', 3, '', ''),
(2060, 2058, '仁寿县', 3, '', ''),
(2061, 2058, '彭山县', 3, '', ''),
(2062, 2058, '洪雅县', 3, '', ''),
(2063, 2058, '丹棱县', 3, '', ''),
(2064, 2058, '青神县', 3, '', ''),
(2065, 22, '资阳市', 2, '', ''),
(2067, 2065, '简阳市', 3, '', ''),
(2068, 2065, '安岳县', 3, '', ''),
(2069, 2065, '乐至县', 3, '', ''),
(2070, 22, '阿坝藏族羌族自治州', 2, '', ''),
(2071, 2070, '马尔康县', 3, '', ''),
(2072, 2070, '九寨沟县', 3, '', ''),
(2073, 2070, '红原县', 3, '', ''),
(2075, 2070, '阿坝县', 3, '', ''),
(2076, 2070, '理县', 3, '', ''),
(2077, 2070, '若尔盖县', 3, '', ''),
(2078, 2070, '金川县', 3, '', ''),
(2079, 2070, '小金县', 3, '', ''),
(2080, 2070, '黑水县', 3, '', ''),
(2081, 2070, '松潘县', 3, '', ''),
(2082, 2070, '壤塘县', 3, '', ''),
(2083, 2070, '茂县', 3, '', ''),
(2084, 22, '甘孜州', 2, '', ''),
(2085, 2084, '康定县', 3, '', ''),
(2086, 2084, '泸定县', 3, '', ''),
(2087, 2084, '九龙县', 3, '', ''),
(2088, 2084, '丹巴县', 3, '', ''),
(2089, 2084, '道孚县', 3, '', ''),
(2090, 2084, '炉霍县', 3, '', ''),
(2091, 2084, '色达县', 3, '', ''),
(2092, 2084, '甘孜县', 3, '', ''),
(2093, 2084, '新龙县', 3, '', ''),
(2094, 2084, '白玉县', 3, '', ''),
(2095, 2084, '德格县', 3, '', ''),
(2096, 2084, '石渠县', 3, '', ''),
(2097, 2084, '雅江县', 3, '', ''),
(2098, 2084, '理塘县', 3, '', ''),
(2099, 2084, '巴塘县', 3, '', ''),
(2100, 2084, '稻城县', 3, '', ''),
(2101, 2084, '乡城县', 3, '', ''),
(2102, 2084, '得荣县', 3, '', ''),
(2103, 22, '凉山彝族自治州', 2, '', ''),
(2105, 2103, '美姑县', 3, '', ''),
(2106, 2103, '昭觉县', 3, '', ''),
(2107, 2103, '会理县', 3, '', ''),
(2108, 2103, '会东县', 3, '', ''),
(2109, 2103, '普格县', 3, '', ''),
(2110, 2103, '宁南县', 3, '', ''),
(2111, 2103, '德昌县', 3, '', ''),
(2112, 2103, '冕宁县', 3, '', ''),
(2113, 2103, '盐源县', 3, '', ''),
(2114, 2103, '金阳县', 3, '', ''),
(2115, 2103, '布拖县', 3, '', ''),
(2116, 2103, '雷波县', 3, '', ''),
(2117, 2103, '越西县', 3, '', ''),
(2118, 2103, '喜德县', 3, '', ''),
(2119, 2103, '甘洛县', 3, '', ''),
(2120, 2103, '木里藏族自治县', 3, '', ''),
(2121, 23, '海口市', 2, '', ''),
(2144, 24, '贵阳市', 2, '', ''),
(2145, 2144, '清镇市', 3, '', ''),
(2146, 2144, '开阳县', 3, '', ''),
(2147, 2144, '修文县', 3, '', ''),
(2148, 2144, '息峰县', 3, '', ''),
(2149, 2144, '乌当区', 3, '', ''),
(2150, 24, '六盘水市', 2, '', ''),
(2151, 2150, '盘县', 3, '', ''),
(2152, 2150, '六枝特区', 3, '', ''),
(2153, 2150, '水城县', 3, '', ''),
(2154, 2150, '钟山区', 3, '', ''),
(2155, 24, '遵义市', 2, '', ''),
(2156, 2155, '赤水市', 3, '', ''),
(2157, 2155, '仁怀市', 3, '', ''),
(2158, 2155, '遵义县', 3, '', ''),
(2159, 2155, '桐梓县', 3, '', ''),
(2160, 2155, '绥阳县', 3, '', ''),
(2161, 2155, '习水县', 3, '', ''),
(2162, 2155, '凤冈县', 3, '', ''),
(2163, 2155, '正安县', 3, '', ''),
(2164, 2155, '湄潭县', 3, '', ''),
(2165, 2155, '余庆县', 3, '', ''),
(2166, 2155, '道真仡佬族苗族', 3, '', ''),
(2167, 2155, '务川仡佬族苗族', 3, '', ''),
(2169, 24, '铜仁市', 2, '', ''),
(2170, 2169, '碧江区', 3, '', ''),
(2171, 2169, '德江县', 3, '', ''),
(2172, 2169, '江口县', 3, '', ''),
(2173, 2169, '思南县', 3, '', ''),
(2174, 2169, '万山区', 3, '', ''),
(2175, 2169, '石阡县', 3, '', ''),
(2176, 2169, '玉屏侗族自治县', 3, '', ''),
(2177, 2169, '松桃苗族自治县', 3, '', ''),
(2178, 2169, '印江土家族苗族自治县', 3, '', ''),
(2179, 2169, '沿河土家族自治县', 3, '', ''),
(2180, 24, '毕节市', 2, '', ''),
(2182, 2180, '黔西县', 3, '', ''),
(2183, 2180, '大方县', 3, '', ''),
(2184, 2180, '织金县', 3, '', ''),
(2185, 2180, '金沙县', 3, '', ''),
(2186, 2180, '赫章县', 3, '', ''),
(2187, 2180, '纳雍县', 3, '', ''),
(2188, 2180, '威宁彝族回族苗族自治县', 3, '', ''),
(2189, 24, '安顺市', 2, '', ''),
(2190, 2189, '西秀区', 3, '', ''),
(2191, 2189, '普定县', 3, '', ''),
(2192, 2189, '平坝县', 3, '', ''),
(2193, 2189, '镇宁布依族苗族自治县', 3, '', ''),
(2194, 2189, '关岭布依族苗族自治县', 3, '', ''),
(2195, 2189, '紫云苗族布依族自治县', 3, '', ''),
(2196, 24, '黔西南州', 2, '', ''),
(2197, 2196, '兴义市', 3, '', ''),
(2198, 2196, '望谟县', 3, '', ''),
(2199, 2196, '兴仁县', 3, '', ''),
(2200, 2196, '普安县', 3, '', ''),
(2201, 2196, '册亨县', 3, '', '');
INSERT INTO `province_city` (`pcity_id`, `parent_id`, `pcity_name`, `pcity_level`, `pinyin`, `first_letter`) VALUES
(2202, 2196, '晴隆县', 3, '', ''),
(2203, 2196, '贞丰县', 3, '', ''),
(2204, 2196, '安龙县', 3, '', ''),
(2205, 24, '黔东南州', 2, '', ''),
(2206, 2205, '凯里市', 3, '', ''),
(2207, 2205, '施秉市', 3, '', ''),
(2208, 2205, '从江县', 3, '', ''),
(2209, 2205, '锦屏县', 3, '', ''),
(2210, 2205, '镇远县', 3, '', ''),
(2211, 2205, '麻江县', 3, '', ''),
(2212, 2205, '台江县', 3, '', ''),
(2213, 2205, '天柱县', 3, '', ''),
(2214, 2205, '黄平县', 3, '', ''),
(2215, 2205, '榕江县', 3, '', ''),
(2216, 2205, '剑河县', 3, '', ''),
(2217, 2205, '三穗县', 3, '', ''),
(2218, 2205, '雷山县', 3, '', ''),
(2219, 2205, '黎平县', 3, '', ''),
(2220, 2205, '岑巩县', 3, '', ''),
(2221, 2205, '丹寨县', 3, '', ''),
(2222, 24, '黔南州', 2, '', ''),
(2223, 2222, '都匀市', 3, '', ''),
(2224, 2222, '福泉市', 3, '', ''),
(2225, 2222, '贵定市', 3, '', ''),
(2226, 2222, '惠水县', 3, '', ''),
(2227, 2222, '罗甸县', 3, '', ''),
(2228, 2222, '瓮安县', 3, '', ''),
(2229, 2222, '荔波县', 3, '', ''),
(2230, 2222, '龙里县', 3, '', ''),
(2231, 2222, '平塘县', 3, '', ''),
(2232, 2222, '长顺县', 3, '', ''),
(2233, 2222, '独山县', 3, '', ''),
(2234, 2222, '三都县', 3, '', ''),
(2235, 25, '昆明市', 2, '', ''),
(2236, 2235, '东川区', 3, '', ''),
(2237, 2235, '安宁县', 3, '', ''),
(2238, 2235, '富民县', 3, '', ''),
(2239, 2235, '蒿明县', 3, '', ''),
(2241, 2235, '晋宁县', 3, '', ''),
(2242, 2235, '宜良县', 3, '', ''),
(2243, 2235, '禄劝彝族苗族自治县', 3, '', ''),
(2244, 2235, '石林彝族自治县', 3, '', ''),
(2245, 2235, '寻甸回族彝族自治县', 3, '', ''),
(2246, 2235, '盘龙区', 3, '', ''),
(2247, 25, '曲靖市', 2, '', ''),
(2249, 2247, '马龙县', 3, '', ''),
(2250, 2247, '宣威市', 3, '', ''),
(2251, 2247, '富源县', 3, '', ''),
(2252, 2247, '会泽县', 3, '', ''),
(2253, 2247, '陆良县', 3, '', ''),
(2254, 2247, '师宗县', 3, '', ''),
(2255, 2247, '罗平县', 3, '', ''),
(2256, 2247, '沾益县', 3, '', ''),
(2258, 25, '玉溪市', 2, '', ''),
(2260, 2258, '华宁县', 3, '', ''),
(2261, 2258, '澄江县', 3, '', ''),
(2262, 2258, '易门县', 3, '', ''),
(2263, 2258, '通海县', 3, '', ''),
(2264, 2258, '江川县', 3, '', ''),
(2265, 2258, '元江哈尼族彝族自治县', 3, '', ''),
(2266, 2258, '新平彝族傣族自治县', 3, '', ''),
(2267, 2258, '峨山彝族自治县', 3, '', ''),
(2270, 25, '昭通市', 2, '', ''),
(2271, 2270, '昭阳区', 3, '', ''),
(2272, 2270, '镇雄县', 3, '', ''),
(2273, 2270, '永善县', 3, '', ''),
(2274, 2270, '大关县', 3, '', ''),
(2275, 2270, '盐津县', 3, '', ''),
(2276, 2270, '彝良县', 3, '', ''),
(2277, 2270, '水富县', 3, '', ''),
(2278, 2270, '巧家县', 3, '', ''),
(2279, 2270, '威信县', 3, '', ''),
(2281, 25, '普洱市', 2, '', ''),
(2282, 2281, '思茅区', 3, '', ''),
(2283, 2281, '宁洱县', 3, '', ''),
(2284, 2281, '景东县', 3, '', ''),
(2285, 2281, '镇沅县', 3, '', ''),
(2286, 2281, '景谷县', 3, '', ''),
(2287, 2281, '墨江县', 3, '', ''),
(2288, 2281, '澜沧县', 3, '', ''),
(2289, 2281, '西盟县', 3, '', ''),
(2290, 2281, '江城县', 3, '', ''),
(2291, 25, '临沧市', 2, '', ''),
(2292, 2291, '临翔区', 3, '', ''),
(2293, 2291, '镇康县', 3, '', ''),
(2294, 2291, '凤庆县', 3, '', ''),
(2295, 2291, '云县', 3, '', ''),
(2296, 2291, '永德县', 3, '', ''),
(2297, 2291, '耿马县', 3, '', ''),
(2298, 25, '保山市', 2, '', ''),
(2299, 2298, '隆阳区', 3, '', ''),
(2300, 2298, '施甸县', 3, '', ''),
(2301, 2298, '昌宁县', 3, '', ''),
(2302, 2298, '龙陵县', 3, '', ''),
(2303, 2298, '腾冲县', 3, '', ''),
(2304, 25, '丽江地区', 2, '', ''),
(2305, 2304, '玉龙纳西族自治县', 3, '', ''),
(2306, 2304, '华坪县', 3, '', ''),
(2307, 2304, '永胜县', 3, '', ''),
(2308, 2304, '宁蒗彝族自治县', 3, '', ''),
(2309, 25, '文山州', 2, '', ''),
(2310, 2309, '文山市', 3, '', ''),
(2311, 2309, '麻栗坡县', 3, '', ''),
(2312, 2309, '砚山县', 3, '', ''),
(2313, 2309, '广南县', 3, '', ''),
(2314, 2309, '马关县', 3, '', ''),
(2315, 2309, '富宁县', 3, '', ''),
(2316, 2309, '西畴县', 3, '', ''),
(2317, 2309, '丘北县', 3, '', ''),
(2318, 25, '红河州', 2, '', ''),
(2319, 2318, '个旧市', 3, '', ''),
(2320, 2318, '开远市', 3, '', ''),
(2321, 2318, '弥勒县', 3, '', ''),
(2322, 2318, '红河县', 3, '', ''),
(2323, 2318, '绿春县', 3, '', ''),
(2324, 2318, '蒙自市', 3, '', ''),
(2325, 2318, '泸西县', 3, '', ''),
(2326, 2318, '建水县', 3, '', ''),
(2327, 2318, '元阳县', 3, '', ''),
(2328, 2318, '石屏县', 3, '', ''),
(2329, 2318, '金平县', 3, '', ''),
(2330, 2318, '屏边县', 3, '', ''),
(2331, 2318, '河口县', 3, '', ''),
(2332, 25, '西双版纳州', 2, '', ''),
(2333, 2332, '景洪市', 3, '', ''),
(2334, 2332, '勐海县', 3, '', ''),
(2335, 2332, '勐腊县', 3, '', ''),
(2336, 25, '楚雄彝族自治州', 2, '', ''),
(2337, 2336, '楚雄市', 3, '', ''),
(2338, 2336, '元谋县', 3, '', ''),
(2339, 2336, '南华县', 3, '', ''),
(2340, 2336, '牟定县', 3, '', ''),
(2341, 2336, '武定县', 3, '', ''),
(2342, 2336, '大姚县', 3, '', ''),
(2343, 2336, '双柏县', 3, '', ''),
(2344, 2336, '禄丰县', 3, '', ''),
(2345, 2336, '永仁县', 3, '', ''),
(2347, 25, '大理白族自治州', 2, '', ''),
(2348, 2347, '大理市', 3, '', ''),
(2349, 2347, '剑川县', 3, '', ''),
(2350, 2347, '弥渡县', 3, '', ''),
(2351, 2347, '云龙县', 3, '', ''),
(2352, 2347, '洱源县', 3, '', ''),
(2353, 2347, '鹤庆县', 3, '', ''),
(2354, 2347, '宾川县', 3, '', ''),
(2355, 2347, '祥云县', 3, '', ''),
(2356, 2347, '永平县', 3, '', ''),
(2357, 2347, '巍山彝族回族自治州', 3, '', ''),
(2358, 2347, '漾濞彝族自治县', 3, '', ''),
(2359, 2347, '南涧彝族自治县', 3, '', ''),
(2360, 25, '德宏州', 2, '', ''),
(2361, 2360, '芒市', 3, '', ''),
(2362, 2360, '瑞丽市', 3, '', ''),
(2363, 2360, '盈江县', 3, '', ''),
(2364, 2360, '梁河县', 3, '', ''),
(2365, 2360, '陇川县', 3, '', ''),
(2366, 25, '怒江州', 2, '', ''),
(2367, 2366, '泸水县', 3, '', ''),
(2368, 2366, '福贡县', 3, '', ''),
(2369, 2366, '兰坪县', 3, '', ''),
(2370, 2366, '贡山县', 3, '', ''),
(2376, 27, '西安市', 2, '', ''),
(2377, 2376, '阎良区', 3, '', ''),
(2378, 2376, '临潼区', 3, '', ''),
(2380, 2376, '高陵县', 3, '', ''),
(2381, 2376, '蓝田县', 3, '', ''),
(2382, 2376, '户县', 3, '', ''),
(2383, 2376, '周至县', 3, '', ''),
(2386, 27, '铜川市', 2, '', ''),
(2387, 2386, '印台区', 3, '', ''),
(2388, 2386, '宜君县', 3, '', ''),
(2389, 2386, '王益区', 3, '', ''),
(2390, 27, '宝鸡市', 2, '', ''),
(2391, 2390, '陈仓区', 3, '', ''),
(2392, 2390, '岐山县', 3, '', ''),
(2393, 2390, '太白县', 3, '', ''),
(2394, 2390, '凤翔县', 3, '', ''),
(2395, 2390, '陇县', 3, '', ''),
(2396, 2390, '麟游县', 3, '', ''),
(2397, 2390, '千阳县', 3, '', ''),
(2398, 2390, '扶风县', 3, '', ''),
(2399, 2390, '凤县', 3, '', ''),
(2400, 2390, '眉县', 3, '', ''),
(2401, 2390, '渭滨区', 3, '', ''),
(2402, 27, '咸阳市', 2, '', ''),
(2403, 2402, '兴平市', 3, '', ''),
(2404, 2402, '礼泉县', 3, '', ''),
(2405, 2402, '泾阳县', 3, '', ''),
(2406, 2402, '永寿县', 3, '', ''),
(2407, 2402, '三原县', 3, '', ''),
(2408, 2402, '彬县', 3, '', ''),
(2409, 2402, '旬邑县', 3, '', ''),
(2411, 2402, '长武县', 3, '', ''),
(2412, 2402, '乾县', 3, '', ''),
(2413, 2402, '武功县', 3, '', ''),
(2414, 2402, '淳化县', 3, '', ''),
(2416, 27, '渭南市', 2, '', ''),
(2417, 2416, '韩城市', 3, '', ''),
(2418, 2416, '华阴市', 3, '', ''),
(2419, 2416, '蒲城县', 3, '', ''),
(2420, 2416, '华县', 3, '', ''),
(2421, 2416, '潼关县', 3, '', ''),
(2422, 2416, '大荔县', 3, '', ''),
(2423, 2416, '澄城县', 3, '', ''),
(2424, 2416, '合阳县', 3, '', ''),
(2425, 2416, '白水县', 3, '', ''),
(2426, 2416, '富平县', 3, '', ''),
(2428, 27, '延安市', 2, '', ''),
(2429, 2428, '安塞县', 3, '', ''),
(2430, 2428, '洛川县', 3, '', ''),
(2431, 2428, '子长县', 3, '', ''),
(2432, 2428, '黄陵县', 3, '', ''),
(2433, 2428, '延长县', 3, '', ''),
(2434, 2428, '宜川县', 3, '', ''),
(2435, 2428, '延川县', 3, '', ''),
(2436, 2428, '甘泉县', 3, '', ''),
(2437, 2428, '富县', 3, '', ''),
(2438, 2428, '志丹县', 3, '', ''),
(2439, 2428, '黄龙县', 3, '', ''),
(2440, 2428, '吴起县', 3, '', ''),
(2442, 27, '汉中市', 2, '', ''),
(2443, 2442, '南郑县', 3, '', ''),
(2444, 2442, '城固县', 3, '', ''),
(2445, 2442, '洋县', 3, '', ''),
(2446, 2442, '佛坪县', 3, '', ''),
(2447, 2442, '留坝县', 3, '', ''),
(2448, 2442, '镇巴县', 3, '', ''),
(2449, 2442, '西乡县', 3, '', ''),
(2450, 2442, '勉县', 3, '', ''),
(2451, 2442, '略阳县', 3, '', ''),
(2452, 2442, '宁强县', 3, '', ''),
(2454, 27, '榆林市', 2, '', ''),
(2456, 2454, '清涧县', 3, '', ''),
(2457, 2454, '绥德县', 3, '', ''),
(2459, 2454, '佳县', 3, '', ''),
(2460, 2454, '神木县', 3, '', ''),
(2461, 2454, '府谷县', 3, '', ''),
(2462, 2454, '子洲县', 3, '', ''),
(2464, 2454, '横山县', 3, '', ''),
(2465, 2454, '米脂县', 3, '', ''),
(2466, 2454, '吴堡县', 3, '', ''),
(2467, 2454, '定边县', 3, '', ''),
(2468, 27, '商洛市', 2, '', ''),
(2469, 2468, '商州区', 3, '', ''),
(2470, 2468, '镇安县', 3, '', ''),
(2471, 2468, '山阳县', 3, '', ''),
(2472, 2468, '洛南县', 3, '', ''),
(2473, 2468, '商南县', 3, '', ''),
(2474, 2468, '丹凤县', 3, '', ''),
(2475, 2468, '柞水县', 3, '', ''),
(2476, 27, '安康市', 2, '', ''),
(2478, 2476, '紫阳县', 3, '', ''),
(2479, 2476, '岚皋县', 3, '', ''),
(2480, 2476, '旬阳县', 3, '', ''),
(2481, 2476, '镇坪县', 3, '', ''),
(2482, 2476, '平利县', 3, '', ''),
(2483, 2476, '宁陕县', 3, '', ''),
(2484, 2476, '汉阴县', 3, '', ''),
(2485, 2476, '石泉县', 3, '', ''),
(2486, 2476, '白河县', 3, '', ''),
(2487, 28, '兰州市', 2, '', ''),
(2488, 2487, '永登县', 3, '', ''),
(2489, 2487, '榆中县', 3, '', ''),
(2490, 2487, '皋兰县', 3, '', ''),
(2491, 2487, '城关区', 3, '', ''),
(2492, 28, '金昌市', 2, '', ''),
(2493, 2492, '永昌县', 3, '', ''),
(2494, 2492, '金川区', 3, '', ''),
(2495, 28, '白银市', 2, '', ''),
(2496, 2495, '白银区', 3, '', ''),
(2497, 2495, '平川区', 3, '', ''),
(2498, 2495, '靖远县', 3, '', ''),
(2499, 2495, '景泰县', 3, '', ''),
(2500, 2495, '会宁县', 3, '', ''),
(2501, 28, '天水市', 2, '', ''),
(2504, 2501, '甘谷区', 3, '', ''),
(2505, 2501, '武山县', 3, '', ''),
(2506, 2501, '清水县', 3, '', ''),
(2507, 2501, '秦安县', 3, '', ''),
(2508, 2501, '张家川回族自治县', 3, '', ''),
(2509, 28, '嘉峪关市', 2, '', ''),
(2518, 28, '平凉市', 2, '', ''),
(2519, 2518, '华亭县', 3, '', ''),
(2520, 2518, '崇信县', 3, '', ''),
(2521, 2518, '泾川县', 3, '', ''),
(2522, 2518, '灵台县', 3, '', ''),
(2523, 2518, '镇原县', 3, '', ''),
(2524, 2518, '庄浪县', 3, '', ''),
(2525, 28, '庆阳市', 2, '', ''),
(2526, 2525, '西峰区', 3, '', ''),
(2528, 2525, '镇原县', 3, '', ''),
(2529, 2525, '合水县', 3, '', ''),
(2530, 2525, '华池县', 3, '', ''),
(2531, 2525, '环县', 3, '', ''),
(2532, 2525, '宁县', 3, '', ''),
(2533, 2525, '正宁县', 3, '', ''),
(2534, 28, '陇南市', 2, '', ''),
(2535, 2534, '成县', 3, '', ''),
(2536, 2534, '礼县', 3, '', ''),
(2537, 2534, '康县', 3, '', ''),
(2538, 2534, '武都区', 3, '', ''),
(2539, 2534, '文县', 3, '', ''),
(2540, 2534, '两当县', 3, '', ''),
(2541, 2534, '徽县', 3, '', ''),
(2542, 2534, '宕昌县', 3, '', ''),
(2543, 2534, '西和县', 3, '', ''),
(2544, 28, '武威市', 2, '', ''),
(2545, 2544, '凉州区', 3, '', ''),
(2546, 2544, '古浪县', 3, '', ''),
(2547, 2544, '天祝县', 3, '', ''),
(2548, 2544, '民勤县', 3, '', ''),
(2549, 28, '张掖市', 2, '', ''),
(2550, 2549, '甘州区', 3, '', ''),
(2551, 2549, '山丹县', 3, '', ''),
(2552, 2549, '临泽县', 3, '', ''),
(2553, 2549, '高台县', 3, '', ''),
(2554, 2549, '肃南县', 3, '', ''),
(2555, 2549, '民乐县', 3, '', ''),
(2556, 28, '酒泉市', 2, '', ''),
(2558, 2556, '玉门市', 3, '', ''),
(2559, 2556, '敦煌市', 3, '', ''),
(2560, 2556, '金塔县', 3, '', ''),
(2562, 2556, '阿克塞县', 3, '', ''),
(2563, 2556, '肃北县', 3, '', ''),
(2564, 28, '甘南州', 2, '', ''),
(2565, 2564, '合作市', 3, '', ''),
(2566, 2564, '夏河县', 3, '', ''),
(2567, 2564, '碌曲县', 3, '', ''),
(2568, 2564, '舟曲县', 3, '', ''),
(2569, 2564, '玛曲县', 3, '', ''),
(2570, 2564, '迭部县', 3, '', ''),
(2571, 2564, '临潭县', 3, '', ''),
(2572, 2564, '卓尼县', 3, '', ''),
(2573, 28, '临夏州', 2, '', ''),
(2574, 2573, '临夏县', 3, '', ''),
(2575, 2573, '康乐县', 3, '', ''),
(2576, 2573, '永靖县', 3, '', ''),
(2577, 2573, '和政县', 3, '', ''),
(2578, 2573, '东乡族自治县', 3, '', ''),
(2579, 2573, '积石山县', 3, '', ''),
(2580, 29, '西宁市', 2, '', ''),
(2581, 2580, '湟中县', 3, '', ''),
(2582, 2580, '湟源县', 3, '', ''),
(2583, 2580, '大通回族土族自治县', 3, '', ''),
(2584, 2580, '城中区', 3, '', ''),
(2585, 29, '海东地区', 2, '', ''),
(2586, 2585, '平安县', 3, '', ''),
(2587, 2585, '乐都县', 3, '', ''),
(2588, 2585, '民和县', 3, '', ''),
(2589, 2585, '互助县', 3, '', ''),
(2590, 2585, '化隆县', 3, '', ''),
(2591, 2585, '循化县', 3, '', ''),
(2592, 29, '海北州', 2, '', ''),
(2593, 2592, '海晏县', 3, '', ''),
(2594, 2592, '祁连县', 3, '', ''),
(2595, 2592, '刚察县', 3, '', ''),
(2596, 2592, '门源县', 3, '', ''),
(2597, 29, '黄南州', 2, '', ''),
(2598, 2597, '尖扎县', 3, '', ''),
(2599, 2597, '同仁县', 3, '', ''),
(2600, 2597, '泽库县', 3, '', ''),
(2602, 2597, '河南县', 3, '', ''),
(2603, 29, '海南州', 2, '', ''),
(2605, 29, '果洛州', 2, '', ''),
(2606, 2605, '玛沁县', 3, '', ''),
(2607, 2605, '甘德县', 3, '', ''),
(2608, 2605, '达日县', 3, '', ''),
(2609, 2605, '班玛县', 3, '', ''),
(2610, 2605, '久治县', 3, '', ''),
(2611, 2605, '玛多县', 3, '', ''),
(2612, 29, '玉树州', 2, '', ''),
(2613, 2612, '玉树县', 3, '', ''),
(2614, 2612, '称多县', 3, '', ''),
(2615, 2612, '囊谦县', 3, '', ''),
(2616, 2612, '杂多县', 3, '', ''),
(2617, 2612, '治多县', 3, '', ''),
(2618, 2612, '曲麻莱县', 3, '', ''),
(2620, 29, '海西州', 2, '', ''),
(2621, 2620, '德令哈市', 3, '', ''),
(2622, 2620, '乌兰县', 3, '', ''),
(2623, 2620, '天峻县', 3, '', ''),
(2624, 2620, '都兰县', 3, '', ''),
(2625, 2620, '大柴旦行委', 3, '', ''),
(2626, 2620, '冷湖行委', 3, '', ''),
(2627, 2620, '茫崖行委', 3, '', ''),
(2628, 30, '银川市', 2, '', ''),
(2629, 2628, '灵武市', 3, '', ''),
(2630, 2628, '永宁县', 3, '', ''),
(2631, 2628, '贺兰县', 3, '', ''),
(2632, 30, '石嘴山市', 2, '', ''),
(2633, 2632, '平罗县', 3, '', ''),
(2635, 2632, '惠农区', 3, '', ''),
(2636, 2632, '大武口区', 3, '', ''),
(2637, 30, '吴忠市', 2, '', ''),
(2638, 2637, '青铜峡市', 3, '', ''),
(2641, 2637, '同心县', 3, '', ''),
(2642, 2637, '盐池县', 3, '', ''),
(2643, 2637, '红寺堡开发区', 3, '', ''),
(2644, 30, '固原市', 2, '', ''),
(2647, 2644, '西吉县', 3, '', ''),
(2648, 2644, '隆德县', 3, '', ''),
(2649, 2644, '泾源县', 3, '', ''),
(2650, 2644, '彭阳县', 3, '', ''),
(2651, 2644, '原州区', 3, '', ''),
(2652, 31, '乌鲁木齐市', 2, '', ''),
(2653, 2652, '乌鲁木齐县', 3, '', ''),
(2654, 31, '克拉玛依市', 2, '', ''),
(2655, 2654, '克拉玛依区', 3, '', ''),
(2656, 31, '石河子市', 2, '', ''),
(2657, 2656, '石河子市', 3, '', ''),
(2658, 31, '吐鲁番地区', 2, '', ''),
(2659, 2658, '吐鲁番市', 3, '', ''),
(2660, 2658, '托克逊县', 3, '', ''),
(2661, 2658, '鄯善县', 3, '', ''),
(2662, 31, '哈密地区', 2, '', ''),
(2663, 2662, '哈密市', 3, '', ''),
(2664, 2662, '巴里昆县', 3, '', ''),
(2665, 2662, '伊吾县', 3, '', ''),
(2666, 31, '和田地区', 2, '', ''),
(2667, 2666, '和田市', 3, '', ''),
(2669, 2666, '墨玉县', 3, '', ''),
(2670, 2666, '洛浦县', 3, '', ''),
(2671, 2666, '策勒县', 3, '', ''),
(2672, 2666, '于田县', 3, '', ''),
(2673, 2666, '民丰县', 3, '', ''),
(2674, 2666, '皮山县', 3, '', ''),
(2675, 31, '阿克苏地区', 2, '', ''),
(2676, 2675, '阿克苏市', 3, '', ''),
(2678, 2675, '温宿县', 3, '', ''),
(2679, 2675, '沙雅县', 3, '', ''),
(2680, 2675, '拜城县', 3, '', ''),
(2681, 2675, '阿瓦提县', 3, '', ''),
(2682, 2675, '库车县', 3, '', ''),
(2683, 2675, '柯坪县', 3, '', ''),
(2684, 2675, '新和县', 3, '', ''),
(2685, 2675, '乌什县', 3, '', ''),
(2686, 31, '喀什地区', 2, '', ''),
(2687, 2686, '喀什市', 3, '', ''),
(2688, 2686, '巴楚县', 3, '', ''),
(2689, 2686, '泽普县', 3, '', ''),
(2690, 2686, '伽师县', 3, '', ''),
(2691, 2686, '叶城县', 3, '', ''),
(2692, 2686, '岳普湖县', 3, '', ''),
(2693, 2686, '疏附县', 3, '', ''),
(2694, 2686, '疏勒县', 3, '', ''),
(2695, 2686, '英吉沙县', 3, '', ''),
(2696, 2686, '麦盖提县', 3, '', ''),
(2697, 2686, '莎车县', 3, '', ''),
(2698, 2686, '塔什库尔干县', 3, '', ''),
(2699, 31, '克孜勒苏州', 2, '', ''),
(2700, 2699, '阿图什市', 3, '', ''),
(2701, 2699, '阿合奇县', 3, '', ''),
(2702, 2699, '乌恰县', 3, '', ''),
(2703, 2699, '阿克陶县', 3, '', ''),
(2704, 31, '巴音郭楞州', 2, '', ''),
(2705, 2704, '库尔勒市', 3, '', ''),
(2706, 2704, '尉犁县', 3, '', ''),
(2707, 2704, '和静县', 3, '', ''),
(2708, 2704, '博湖县', 3, '', ''),
(2709, 2704, '和硕县', 3, '', ''),
(2710, 2704, '轮台县', 3, '', ''),
(2711, 2704, '若羌县', 3, '', ''),
(2712, 2704, '且末县', 3, '', ''),
(2713, 2704, '焉耆县', 3, '', ''),
(2714, 31, '昌吉州', 2, '', ''),
(2715, 2714, '昌吉市', 3, '', ''),
(2716, 2714, '阜康市', 3, '', ''),
(2718, 2714, '奇台县', 3, '', ''),
(2719, 2714, '玛纳斯县', 3, '', ''),
(2720, 2714, '吉木萨尔县', 3, '', ''),
(2721, 2714, '呼图壁县', 3, '', ''),
(2722, 2714, '木垒县', 3, '', ''),
(2723, 31, '博尔塔拉州', 2, '', ''),
(2724, 2723, '博乐市', 3, '', ''),
(2725, 2723, '精河县', 3, '', ''),
(2726, 2723, '温泉县', 3, '', ''),
(2727, 31, '伊犁州', 2, '', ''),
(2728, 2727, '伊宁市', 3, '', ''),
(2729, 2727, '特克斯县', 3, '', ''),
(2730, 2727, '尼勒克县', 3, '', ''),
(2731, 2727, '昭苏县', 3, '', ''),
(2732, 2727, '新源县', 3, '', ''),
(2733, 2727, '霍城县', 3, '', ''),
(2734, 2727, '察布查尔县', 3, '', ''),
(2735, 2727, '巩留县', 3, '', ''),
(2736, 31, '塔城地区', 2, '', ''),
(2737, 2736, '塔城市', 3, '', ''),
(2738, 2736, '乌苏市', 3, '', ''),
(2739, 2736, '额敏县', 3, '', ''),
(2740, 2736, '裕民县', 3, '', ''),
(2741, 2736, '沙湾县', 3, '', ''),
(2742, 2736, '托里县', 3, '', ''),
(2743, 2736, '和布克赛尔县', 3, '', ''),
(2744, 31, '阿勒泰地区', 2, '', ''),
(2745, 2744, '阿勒泰市', 3, '', ''),
(2746, 2744, '富蕴县', 3, '', ''),
(2747, 2744, '青河县', 3, '', ''),
(2748, 2744, '吉木乃县', 3, '', ''),
(2749, 2744, '布尔津县', 3, '', ''),
(2750, 2744, '福海县', 3, '', ''),
(2751, 2744, '哈巴河县', 3, '', ''),
(2754, 42, '香港特别行政区', 2, '', ''),
(2755, 2754, '香港市区内', 3, '', ''),
(2756, 258, '遵化市', 3, '', ''),
(2757, 258, '丰南区', 3, '', ''),
(2759, 258, '迁西县', 3, '', ''),
(2760, 258, '滦南县', 3, '', ''),
(2761, 258, '丰润区', 3, '', ''),
(2762, 258, '玉田县', 3, '', ''),
(2763, 258, '唐海县', 3, '', ''),
(2764, 258, '乐亭县', 3, '', ''),
(2765, 258, '滦县', 3, '', ''),
(2767, 239, '隆化县', 3, '', ''),
(2768, 32, '台湾市', 2, '', ''),
(2769, 2768, '台湾市区内', 3, '', ''),
(2770, 43, '澳门市', 2, '', ''),
(2771, 2770, '澳门市区内', 3, '', ''),
(2772, 1090, '无棣县', 3, '', ''),
(2773, 1099, '鄄城县', 3, '', ''),
(2774, 965, '海安县', 3, '', ''),
(2777, 1657, '南朗镇', 3, '', ''),
(2780, 7, '济源市', 2, '', ''),
(2781, 560, '和平区', 3, '', ''),
(2782, 412, '上街区', 3, '', ''),
(2799, 72, '三环以内', 3, '', ''),
(2800, 1, '海淀区', 2, '', ''),
(2801, 1, '西城区', 2, '', ''),
(2802, 1, '东城区', 2, '', ''),
(2803, 1, '崇文区', 2, '', ''),
(2804, 1, '宣武区', 2, '', ''),
(2805, 1, '丰台区', 2, '', ''),
(2806, 1, '石景山区', 2, '', ''),
(2807, 1, '门头沟', 2, '', ''),
(2808, 1, '房山区', 2, '', ''),
(2809, 1, '通州区', 2, '', ''),
(2810, 1, '大兴区', 2, '', ''),
(2811, 2, '卢湾区', 2, '', ''),
(2812, 1, '顺义区', 2, '', ''),
(2813, 2, '徐汇区', 2, '', ''),
(2814, 1, '怀柔区', 2, '', ''),
(2815, 2, '长宁区', 2, '', ''),
(2816, 1, '密云区', 2, '', ''),
(2817, 2, '静安区', 2, '', ''),
(2819, 72, '三环到四环之间', 3, '', ''),
(2820, 2, '闸北区', 2, '', ''),
(2821, 2802, '内环到三环里', 3, '', ''),
(2822, 2, '虹口区', 2, '', ''),
(2823, 2, '杨浦区', 2, '', ''),
(2824, 2, '宝山区', 2, '', ''),
(2825, 2, '闵行区', 2, '', ''),
(2826, 2, '嘉定区', 2, '', ''),
(2827, 2801, '内环到二环里', 3, '', ''),
(2828, 2804, '内环到三环里', 3, '', ''),
(2829, 2803, '一环到二环', 3, '', ''),
(2830, 2, '浦东新区', 2, '', ''),
(2831, 2806, '四环到五环内', 3, '', ''),
(2832, 2805, '四环到五环之间', 3, '', ''),
(2833, 2, '青浦区', 2, '', ''),
(2834, 2, '松江区', 2, '', ''),
(2835, 2, '金山区', 2, '', ''),
(2836, 2, '南汇区', 2, '', ''),
(2837, 2, '奉贤区', 2, '', ''),
(2839, 72, '四环到五环之间', 3, '', ''),
(2840, 72, '五环到六环之间', 3, '', ''),
(2841, 2, '普陀区', 2, '', ''),
(2842, 2803, '二环到三环', 3, '', ''),
(2843, 2807, '郊区', 3, '', ''),
(2844, 2808, '郊区', 3, '', ''),
(2847, 2814, '郊区', 3, '', ''),
(2848, 2800, '三环以内', 3, '', ''),
(2849, 2800, '三环到四环之间', 3, '', ''),
(2850, 2800, '四环到五环之间', 3, '', ''),
(2851, 2800, '五环到六环之间', 3, '', ''),
(2852, 2800, '六环以外', 3, '', ''),
(2853, 2801, '二环到三环', 3, '', ''),
(2854, 2805, '二环到三环', 3, '', ''),
(2855, 2805, '三环到四环之间', 3, '', ''),
(2856, 2822, '内环中环之间', 3, '', ''),
(2857, 2811, '内环中环之间', 3, '', ''),
(2858, 2809, '六环以外', 3, '', ''),
(2860, 2811, '内环以内', 3, '', ''),
(2861, 2811, '中环外环之间', 3, '', ''),
(2862, 2816, '城区以外', 3, '', ''),
(2863, 2813, '内环以内', 3, '', ''),
(2864, 2826, '外环以外', 3, '', ''),
(2865, 2813, '内环中环之间', 3, '', ''),
(2866, 2834, '外环以外', 3, '', ''),
(2868, 2835, '外环以外', 3, '', ''),
(2869, 2833, '外环以外', 3, '', ''),
(2870, 2815, '内环以内', 3, '', ''),
(2871, 2815, '内环中环之间', 3, '', ''),
(2872, 2815, '中环外环之间', 3, '', ''),
(2873, 2817, '内环以内', 3, '', ''),
(2874, 2817, '内环中环之间', 3, '', ''),
(2875, 2817, '中环外环之间', 3, '', ''),
(2876, 2841, '内环以内', 3, '', ''),
(2877, 2841, '内环中环之间', 3, '', ''),
(2878, 2841, '中环外环之间', 3, '', ''),
(2879, 2820, '内环以内', 3, '', ''),
(2880, 2820, '中环外环之间', 3, '', ''),
(2881, 2820, '内环中环之间', 3, '', ''),
(2882, 2822, '内环以内', 3, '', ''),
(2883, 2822, '中环外环之间', 3, '', ''),
(2884, 2823, '内环以内', 3, '', ''),
(2885, 2823, '内环中环之间', 3, '', ''),
(2886, 2823, '中环外环之间', 3, '', ''),
(2888, 2837, '外环以外', 3, '', ''),
(2889, 2824, '中环以内', 3, '', ''),
(2890, 2824, '中环外环之间', 3, '', ''),
(2891, 2824, '外环以外', 3, '', ''),
(2892, 2825, '中环以内', 3, '', ''),
(2893, 2825, '外环以外', 3, '', ''),
(2894, 2830, '中环以内', 3, '', ''),
(2895, 2830, '外环以外', 3, '', ''),
(2896, 2825, '中环外环之间', 3, '', ''),
(2897, 2830, '中环外环之间', 3, '', ''),
(2900, 13, '济宁市', 2, '', ''),
(2901, 1, '昌平区', 2, '', ''),
(2902, 1657, '小榄镇', 3, '', ''),
(2903, 2836, '祝桥镇', 3, '', ''),
(2904, 2836, '新场镇', 3, '', ''),
(2906, 2901, '城区以外', 3, '', ''),
(2907, 83, '南开区', 3, '', ''),
(2908, 2900, '梁山县', 3, '', ''),
(2910, 2900, '兖州市', 3, '', ''),
(2912, 2900, '微山县', 3, '', ''),
(2913, 2900, '汶上县', 3, '', ''),
(2914, 2900, '泗水县', 3, '', ''),
(2915, 2900, '嘉祥县', 3, '', ''),
(2916, 2900, '鱼台县', 3, '', ''),
(2917, 2900, '金乡县', 3, '', ''),
(2919, 2, '崇明县', 2, '', ''),
(2922, 17, '潜江市', 2, '', ''),
(2924, 1016, '周村区', 3, '', ''),
(2925, 1930, '新都区', 3, '', ''),
(2926, 1072, '莒南县', 3, '', ''),
(2927, 978, '新北区', 3, '', ''),
(2930, 2654, '独山子区', 3, '', ''),
(2931, 2805, '五环以外', 3, '', ''),
(2932, 2652, '天山区', 3, '', ''),
(2934, 1108, '五莲县', 3, '', ''),
(2935, 2836, '惠南镇', 3, '', ''),
(2937, 2836, '康桥镇', 3, '', ''),
(2938, 2836, '宣桥镇', 3, '', ''),
(2939, 2836, '书院镇', 3, '', ''),
(2940, 2836, '大团镇', 3, '', ''),
(2941, 2836, '周浦镇', 3, '', ''),
(2942, 2836, '芦潮港镇', 3, '', ''),
(2943, 2836, '泥城镇', 3, '', ''),
(2944, 2836, '六灶镇', 3, '', ''),
(2945, 2836, '航头镇', 3, '', ''),
(2946, 2836, '万祥镇', 3, '', ''),
(2947, 2836, '老港镇', 3, '', ''),
(2949, 1655, '虎门镇', 3, '', ''),
(2950, 1655, '中堂镇', 3, '', ''),
(2951, 26, '拉萨市', 2, '', ''),
(2952, 2951, '城关区', 3, '', ''),
(2953, 1, '平谷区', 2, '', ''),
(2954, 2953, '城区以外', 3, '', ''),
(2955, 1352, '延平区', 3, '', ''),
(2956, 1352, '光泽县', 3, '', ''),
(2957, 1657, '古镇', 3, '', ''),
(2958, 2281, '孟连县', 3, '', ''),
(2959, 1158, '镇海区', 3, '', ''),
(2962, 1016, '淄川区', 3, '', ''),
(2963, 1213, '江干区', 3, '', ''),
(2964, 1042, '牟平区', 3, '', ''),
(2966, 2637, '利通区', 3, '', ''),
(2967, 325, '泽州县', 3, '', ''),
(2968, 1016, '博山区', 3, '', ''),
(2969, 1016, '临淄区', 3, '', ''),
(2970, 2509, '雄关区', 3, '', ''),
(2971, 14, '宣城市', 2, '', ''),
(2972, 2971, '泾县', 3, '', ''),
(2973, 1477, '钟祥市', 3, '', ''),
(2974, 1072, '郯城县', 3, '', ''),
(2975, 1007, '城阳区', 3, '', ''),
(2978, 9, '公主岭市', 2, '', ''),
(2980, 17, '天门市', 2, '', ''),
(2983, 17, '仙桃市', 2, '', ''),
(2984, 83, '和平区', 3, '', ''),
(2985, 83, '河西区', 3, '', ''),
(2986, 83, '红桥区', 3, '', ''),
(2987, 83, '河北区', 3, '', ''),
(2989, 248, '山海关区', 3, '', ''),
(2990, 248, '北戴河区', 3, '', ''),
(2991, 1818, '罗城县', 3, '', ''),
(2992, 9, '辽源市', 2, '', ''),
(2993, 2992, '龙山区', 3, '', ''),
(2994, 2992, '西安区', 3, '', ''),
(2995, 2992, '东丰县', 3, '', ''),
(2996, 2992, '东辽县', 3, '', ''),
(2997, 1643, '大亚湾区', 3, '', ''),
(2999, 1753, '钦北区', 3, '', ''),
(3000, 83, '河东区', 3, '', ''),
(3001, 1657, '坦洲镇', 3, '', ''),
(3002, 2270, '鲁甸县', 3, '', ''),
(3003, 2270, '绥江县', 3, '', ''),
(3005, 1715, '宾阳县', 3, '', ''),
(3006, 2654, '白碱滩区', 3, '', ''),
(3007, 1657, '黄圃镇', 3, '', ''),
(3009, 1007, '崂山区', 3, '', ''),
(3016, 1657, '三乡镇', 3, '', ''),
(3017, 1206, '金安区', 3, '', ''),
(3021, 2620, '格尔木市', 3, '', ''),
(3022, 1329, '涵江区', 3, '', ''),
(3023, 2518, '崆峒区', 3, '', ''),
(3024, 904, '溧水县', 3, '', ''),
(3027, 1611, '潮阳区', 3, '', ''),
(3034, 23, '儋州市', 2, '', ''),
(3037, 1650, '海丰县', 3, '', ''),
(3038, 1213, '滨江区', 3, '', ''),
(3040, 2978, '公主岭市市区', 3, '', ''),
(3041, 1655, '东坑镇', 3, '', ''),
(3044, 20, '来宾市', 2, '', ''),
(3045, 1280, '庆元县', 3, '', ''),
(3046, 3044, '兴宾区', 3, '', ''),
(3047, 3044, '合山市', 3, '', ''),
(3048, 3044, '忻城县', 3, '', ''),
(3049, 3044, '武宣县', 3, '', ''),
(3050, 3044, '象州县', 3, '', ''),
(3051, 3044, '金秀县', 3, '', ''),
(3055, 1477, '沙洋县', 3, '', ''),
(3065, 1, '延庆县', 2, '', ''),
(3066, 3065, '百泉京新高速康张京银', 3, '', ''),
(3067, 1657, '东凤镇', 3, '', ''),
(3068, 1108, '莒县', 3, '', ''),
(3070, 1574, '沅陵县', 3, '', ''),
(3071, 30, '中卫市', 2, '', ''),
(3072, 3071, '中宁县', 3, '', ''),
(3073, 325, '城区', 3, '', ''),
(3074, 6, '长治市', 2, '', ''),
(3075, 3074, '长治县', 3, '', ''),
(3076, 87, '高新区', 3, '', ''),
(3077, 148, '临漳县', 3, '', ''),
(3078, 1655, '道滘镇', 3, '', ''),
(3079, 1381, '武昌区', 3, '', ''),
(3080, 28, '定西市', 2, '', ''),
(3081, 3080, '岷县', 3, '', ''),
(3082, 988, '相城区', 3, '', ''),
(3083, 988, '金阊区', 3, '', ''),
(3084, 988, '吴中区', 3, '', ''),
(3085, 988, '虎丘区', 3, '', ''),
(3087, 988, '平江区', 3, '', ''),
(3088, 988, '沧浪区', 3, '', ''),
(3092, 239, '承德县', 3, '', ''),
(3096, 776, '嫩江县', 3, '', ''),
(3097, 1655, '沙田镇', 3, '', ''),
(3098, 164, '威县', 3, '', ''),
(3100, 1655, '高步镇', 3, '', ''),
(3102, 1655, '石龙镇', 3, '', ''),
(3104, 1655, '石排镇', 3, '', ''),
(3105, 1655, '企石镇', 3, '', ''),
(3107, 26, '那曲地区', 2, '', ''),
(3108, 3107, '索县', 3, '', ''),
(3109, 3074, '潞城市', 3, '', ''),
(3110, 2841, '桃浦新村', 3, '', ''),
(3111, 1655, '石碣镇', 3, '', ''),
(3112, 1657, '横栏镇', 3, '', ''),
(3113, 495, '渑池县', 3, '', ''),
(3115, 23, '琼海市', 2, '', ''),
(3116, 1655, '洪梅镇', 3, '', ''),
(3117, 1332, '泉港区', 3, '', ''),
(3118, 330, '平鲁区', 3, '', ''),
(3119, 549, '商城县', 3, '', ''),
(3120, 1655, '麻涌镇', 3, '', ''),
(3121, 1988, '东兴区', 3, '', ''),
(3123, 2951, '林周县', 3, '', ''),
(3125, 3034, '那大镇', 3, '', ''),
(3126, 1042, '芝罘区', 3, '', ''),
(3127, 420, '通许县', 3, '', ''),
(3128, 2971, '旌德县', 3, '', ''),
(3129, 26, '山南地区', 2, '', ''),
(3130, 3129, '贡嘎县', 3, '', ''),
(3132, 1112, '东平县', 3, '', ''),
(3133, 799, '清水河县', 3, '', ''),
(3134, 1655, '桥头镇', 3, '', ''),
(3135, 1643, '惠城区', 3, '', ''),
(3136, 379, '曲沃县', 3, '', ''),
(3137, 23, '万宁市', 2, '', ''),
(3138, 26, '昌都地区', 2, '', ''),
(3139, 3138, '昌都县', 3, '', ''),
(3142, 902, '霍林郭勒市', 3, '', ''),
(3143, 1657, '三角镇', 3, '', ''),
(3144, 26, '日喀则地区', 2, '', ''),
(3147, 2971, '宁国市', 3, '', ''),
(3148, 3071, '海原县', 3, '', ''),
(3151, 1655, '望牛墩镇', 3, '', ''),
(3152, 1818, '大化县', 3, '', ''),
(3154, 17, '神农架林区', 2, '', ''),
(3155, 1607, '南山区', 3, '', ''),
(3156, 224, '沽源县', 3, '', ''),
(3158, 3154, '神农架林区', 3, '', ''),
(3160, 3144, '聂拉木县', 3, '', ''),
(3163, 1479, '广水市', 3, '', ''),
(3164, 1479, '曾都区', 3, '', ''),
(3166, 3144, '昂仁县', 3, '', ''),
(3168, 20, '崇左市', 2, '', ''),
(3169, 3168, '江州区', 3, '', ''),
(3171, 1655, '茶山镇', 3, '', ''),
(3172, 639, '德惠市', 3, '', ''),
(3173, 23, '东方市', 2, '', ''),
(3175, 2573, '临夏市', 3, '', ''),
(3176, 1657, '南头镇', 3, '', ''),
(3177, 142, '长安区', 3, '', ''),
(3181, 142, '裕华区', 3, '', ''),
(3182, 142, '井陉矿区', 3, '', ''),
(3183, 148, '丛台区', 3, '', ''),
(3186, 148, '复兴区', 3, '', ''),
(3187, 148, '永年县', 3, '', ''),
(3188, 164, '桥西区', 3, '', ''),
(3190, 199, '新市区', 3, '', ''),
(3191, 199, '北市区', 3, '', ''),
(3192, 199, '南市区', 3, '', ''),
(3193, 199, '安新县', 3, '', ''),
(3194, 224, '桥西区', 3, '', ''),
(3196, 239, '双桥区', 3, '', ''),
(3197, 239, '双滦区', 3, '', ''),
(3198, 239, '鹰手营子矿区', 3, '', ''),
(3199, 812, '元宝山区', 3, '', ''),
(3201, 258, '路南区', 3, '', ''),
(3202, 258, '古冶区', 3, '', ''),
(3203, 258, '开平区 ', 3, '', ''),
(3204, 264, '运河区', 3, '', ''),
(3205, 264, '新华区', 3, '', ''),
(3206, 274, '安次区', 3, '', ''),
(3207, 274, '广阳区', 3, '', ''),
(3208, 303, '杏花岭区', 3, '', ''),
(3209, 303, '小店区', 3, '', ''),
(3210, 303, '迎泽区', 3, '', ''),
(3211, 303, '尖草坪区', 3, '', ''),
(3212, 303, '万柏林区', 3, '', ''),
(3214, 309, '新荣区', 3, '', ''),
(3216, 309, '南郊区', 3, '', ''),
(3217, 309, '矿区', 3, '', ''),
(3218, 309, '城区', 3, '', ''),
(3219, 318, '矿区', 3, '', ''),
(3220, 318, '城区', 3, '', ''),
(3221, 3074, '城区', 3, '', ''),
(3222, 3074, '郊区', 3, '', ''),
(3223, 3074, '襄垣县', 3, '', ''),
(3224, 3074, '屯留县', 3, '', ''),
(3225, 3074, '平顺县', 3, '', ''),
(3226, 3074, '黎城县', 3, '', ''),
(3227, 3074, '壶关县', 3, '', ''),
(3228, 3074, '长子县', 3, '', ''),
(3229, 3074, '武乡县', 3, '', ''),
(3230, 3074, '沁县', 3, '', ''),
(3231, 3074, '沁源县', 3, '', ''),
(3233, 398, '闻喜县', 3, '', ''),
(3235, 368, '交口县', 3, '', ''),
(3236, 368, '交城县', 3, '', ''),
(3237, 368, '石楼县', 3, '', ''),
(3238, 799, '回民区', 3, '', ''),
(3240, 799, '玉泉区', 3, '', ''),
(3241, 799, '赛罕区', 3, '', ''),
(3242, 805, '昆都仑区', 3, '', ''),
(3243, 805, '东河区', 3, '', ''),
(3244, 805, '青山区', 3, '', ''),
(3245, 805, '石拐区', 3, '', ''),
(3246, 805, '白云矿区', 3, '', ''),
(3247, 805, '九原区', 3, '', ''),
(3248, 810, '海南区', 3, '', ''),
(3249, 810, '乌达区', 3, '', ''),
(3251, 812, '松山区', 3, '', ''),
(3252, 902, '开鲁县', 3, '', ''),
(3253, 902, '库伦旗', 3, '', ''),
(3254, 902, '奈曼旗', 3, '', ''),
(3255, 902, '扎鲁特旗 ', 3, '', ''),
(3256, 902, '科尔沁左翼中旗', 3, '', ''),
(3258, 902, '科尔沁左翼后旗', 3, '', ''),
(3259, 560, '沈北新区', 3, '', ''),
(3261, 573, '沙河口区', 3, '', ''),
(3263, 573, '西岗区', 3, '', ''),
(3264, 579, '铁东区', 3, '', ''),
(3265, 579, '铁西区', 3, '', ''),
(3266, 579, '立山区', 3, '', ''),
(3267, 579, '千山区', 3, '', ''),
(3268, 584, '望花区', 3, '', ''),
(3269, 584, '东洲区', 3, '', ''),
(3270, 584, '新抚区', 3, '', ''),
(3271, 584, '顺城区', 3, '', ''),
(3275, 589, '南芬区', 3, '', ''),
(3277, 593, '元宝区', 3, '', ''),
(3278, 593, '振兴区', 3, '', ''),
(3282, 609, '老边区', 3, '', ''),
(3283, 609, '西市区', 3, '', ''),
(3286, 617, '清河门区', 3, '', ''),
(3287, 617, '太平区', 3, '', ''),
(3288, 617, '新邱区', 3, '', ''),
(3289, 617, '海州区', 3, '', ''),
(3290, 621, '太子河区', 3, '', ''),
(3291, 621, '弓长岭区', 3, '', ''),
(3292, 621, '宏伟区', 3, '', ''),
(3294, 621, '白塔区', 3, '', ''),
(3295, 613, '兴隆台区', 3, '', ''),
(3296, 613, '双台子区', 3, '', ''),
(3299, 632, '龙城区', 3, '', ''),
(3300, 604, '龙港区', 3, '', ''),
(3301, 604, '连山区', 3, '', ''),
(3302, 639, '南关区', 3, '', ''),
(3303, 639, '宽城区', 3, '', ''),
(3304, 639, '二道区', 3, '', ''),
(3306, 639, '双阳区', 3, '', ''),
(3309, 644, '船营区', 3, '', ''),
(3311, 657, '东昌区', 3, '', ''),
(3312, 687, '图们市', 3, '', ''),
(3313, 687, '敦化市', 3, '', ''),
(3314, 687, '珲春市', 3, '', ''),
(3315, 687, '龙井市', 3, '', ''),
(3316, 687, '和龙市', 3, '', ''),
(3317, 687, '汪清县', 3, '', ''),
(3318, 687, '安图县', 3, '', ''),
(3321, 698, '南岗区', 3, '', ''),
(3325, 712, '建华区', 3, '', ''),
(3327, 712, '铁锋区', 3, '', ''),
(3328, 737, '鸡冠区', 3, '', ''),
(3329, 737, '恒山区', 3, '', ''),
(3330, 737, '滴道区', 3, '', ''),
(3331, 737, '梨树区', 3, '', ''),
(3332, 737, '城子河区', 3, '', ''),
(3333, 737, '麻山区', 3, '', ''),
(3334, 727, '兴山区', 3, '', ''),
(3335, 727, '向阳区', 3, '', ''),
(3336, 727, '工农区 ', 3, '', ''),
(3337, 727, '南山区', 3, '', ''),
(3338, 727, '兴安区', 3, '', ''),
(3339, 727, '东山区', 3, '', ''),
(3340, 731, '尖山区', 3, '', ''),
(3341, 731, '岭东区', 3, '', ''),
(3342, 731, '四方台区', 3, '', ''),
(3343, 731, '宝山区', 3, '', ''),
(3344, 753, '伊春区 ', 3, '', ''),
(3345, 753, '南岔区', 3, '', ''),
(3346, 753, '友好区', 3, '', ''),
(3347, 753, '西林区', 3, '', ''),
(3348, 753, '翠峦区', 3, '', ''),
(3349, 753, '新青区', 3, '', ''),
(3350, 753, '美溪区', 3, '', ''),
(3351, 753, '金山屯区', 3, '', ''),
(3352, 753, '五营区', 3, '', ''),
(3353, 753, '乌马河区', 3, '', ''),
(3354, 753, '汤旺河区', 3, '', ''),
(3355, 753, '带岭区', 3, '', ''),
(3356, 753, '乌伊岭区 ', 3, '', ''),
(3357, 753, '红星区', 3, '', ''),
(3358, 753, '上甘岭区', 3, '', ''),
(3359, 765, '前进区', 3, '', ''),
(3360, 765, '永红区', 3, '', ''),
(3361, 765, '向阳区', 3, '', ''),
(3364, 773, '桃山区', 3, '', ''),
(3365, 773, '新兴区', 3, '', ''),
(3366, 773, '茄子河区', 3, '', ''),
(3367, 757, '爱民区', 3, '', ''),
(3368, 757, '东安区', 3, '', ''),
(3369, 757, '阳明区', 3, '', ''),
(3370, 757, '西安区', 3, '', ''),
(3371, 776, '爱辉区', 3, '', ''),
(3373, 904, '玄武区', 3, '', ''),
(3374, 904, '白下区', 3, '', ''),
(3375, 904, '秦淮区', 3, '', ''),
(3376, 904, '建邺区', 3, '', ''),
(3377, 904, '鼓楼区', 3, '', ''),
(3378, 904, '栖霞区', 3, '', ''),
(3379, 904, '雨花台区', 3, '', ''),
(3380, 904, '下关区', 3, '', ''),
(3381, 984, '崇安区', 3, '', ''),
(3382, 984, '南长区', 3, '', ''),
(3383, 984, '北塘区', 3, '', ''),
(3384, 984, '锡山区', 3, '', ''),
(3385, 984, '惠山区', 3, '', ''),
(3386, 984, '滨湖区', 3, '', ''),
(3388, 911, '贾汪区', 3, '', ''),
(3389, 911, '云龙区', 3, '', ''),
(3391, 978, '戚墅堰区', 3, '', ''),
(3392, 978, '钟楼区', 3, '', ''),
(3393, 978, '天宁区', 3, '', ''),
(3394, 965, '港闸区', 3, '', ''),
(3395, 965, '崇川区', 3, '', ''),
(3398, 919, '新浦区', 3, '', ''),
(3401, 939, '亭湖区', 3, '', ''),
(3402, 951, '维扬区', 3, '', ''),
(3403, 972, '润州区', 3, '', ''),
(3404, 972, '京口区', 3, '', ''),
(3405, 959, '高港区', 3, '', ''),
(3406, 959, '海陵区', 3, '', ''),
(3407, 933, '宿城区', 3, '', ''),
(3408, 1213, '上城区', 3, '', ''),
(3409, 1213, '下城区', 3, '', ''),
(3410, 1213, '拱墅区', 3, '', ''),
(3411, 1213, '西湖区', 3, '', ''),
(3412, 1158, '海曙区', 3, '', ''),
(3413, 1158, '江东区', 3, '', ''),
(3414, 1158, '江北区', 3, '', ''),
(3416, 1233, '龙湾区', 3, '', ''),
(3418, 1243, '南湖区', 3, '', ''),
(3419, 1243, '秀洲区', 3, '', ''),
(3420, 1250, '吴兴区', 3, '', ''),
(3426, 1298, '定海区', 3, '', ''),
(3427, 1290, '椒江区', 3, '', ''),
(3431, 1116, '包河区', 3, '', ''),
(3432, 1116, '蜀山区', 3, '', ''),
(3433, 1116, '瑶海区', 3, '', ''),
(3434, 1116, '庐阳区', 3, '', ''),
(3435, 1127, '鸠江区', 3, '', ''),
(3436, 1127, '新芜区', 3, '', ''),
(3437, 1127, '马塘区', 3, '', ''),
(3438, 1127, '镜湖区', 3, '', ''),
(3439, 1132, '淮上区', 3, '', ''),
(3442, 1132, '蚌山区', 3, '', ''),
(3444, 988, '工业园区', 3, '', ''),
(3447, 1121, '田家庵区', 3, '', ''),
(3448, 1121, '大通区', 3, '', ''),
(3449, 1121, '谢家集区', 3, '', ''),
(3450, 1121, '八公山区', 3, '', ''),
(3451, 1121, '潘集区', 3, '', ''),
(3453, 1137, '花山区', 3, '', ''),
(3454, 1137, '雨山区', 3, '', ''),
(3455, 1124, '烈山区', 3, '', ''),
(3456, 1124, '杜集区', 3, '', ''),
(3460, 1140, '郊区', 3, '', ''),
(3461, 1140, '大观区', 3, '', ''),
(3462, 1140, '迎江区', 3, '', ''),
(3463, 1151, '屯溪区', 3, '', ''),
(3464, 1151, '黄山区', 3, '', ''),
(3466, 1159, '琅琊区', 3, '', ''),
(3467, 1159, '南谯区', 3, '', ''),
(3469, 1167, '颍东区', 3, '', ''),
(3470, 1167, '颍泉区', 3, '', ''),
(3472, 1180, '埇桥区', 3, '', ''),
(3474, 1174, '谯城区', 3, '', ''),
(3475, 1201, '贵池区', 3, '', ''),
(3477, 2971, '郎溪县', 3, '', ''),
(3478, 2971, '广德县', 3, '', ''),
(3479, 2971, '绩溪县', 3, '', ''),
(3480, 1303, '晋安区', 3, '', ''),
(3482, 1303, '仓山区', 3, '', ''),
(3483, 1303, '台江区', 3, '', ''),
(3484, 1303, '鼓楼区', 3, '', ''),
(3486, 1315, '湖里区', 3, '', ''),
(3487, 1315, '集美区', 3, '', ''),
(3489, 1315, '翔安区', 3, '', ''),
(3490, 1329, '城厢区', 3, '', ''),
(3491, 1329, '荔城区', 3, '', ''),
(3492, 1329, '秀屿区', 3, '', ''),
(3493, 1317, '梅列区', 3, '', ''),
(3494, 1317, '三元区', 3, '', ''),
(3495, 1332, '金门县', 3, '', ''),
(3497, 1332, '丰泽区', 3, '', ''),
(3498, 1332, '洛江区', 3, '', ''),
(3499, 1341, '芗城区', 3, '', ''),
(3500, 1341, '龙文区', 3, '', ''),
(3502, 1827, '新建县', 3, '', ''),
(3503, 1827, '青山湖区', 3, '', ''),
(3504, 1827, '湾里区', 3, '', ''),
(3505, 1827, '青云谱区', 3, '', ''),
(3506, 1827, '西湖区', 3, '', ''),
(3507, 1827, '东湖区', 3, '', ''),
(3508, 1832, '珠山区', 3, '', ''),
(3512, 1845, '浔阳区', 3, '', ''),
(3514, 1000, '天桥区', 3, '', ''),
(3519, 1007, '四方区', 3, '', ''),
(3520, 1007, '市北区', 3, '', ''),
(3521, 1007, '市南区', 3, '', ''),
(3522, 1022, '山亭区', 3, '', ''),
(3523, 1022, '台儿庄区', 3, '', ''),
(3524, 1022, '峄城区', 3, '', ''),
(3525, 1022, '薛城区', 3, '', ''),
(3526, 1022, '市中区', 3, '', ''),
(3527, 1042, '福山区', 3, '', ''),
(3528, 1042, '莱山区', 3, '', ''),
(3530, 1032, '坊子区', 3, '', ''),
(3531, 1032, '寒亭区', 3, '', ''),
(3532, 1032, '潍城区', 3, '', ''),
(3533, 2900, '任城区', 3, '', ''),
(3535, 1112, '宁阳县', 3, '', ''),
(3537, 1112, '岱岳区', 3, '', ''),
(3539, 1058, '钢城区', 3, '', ''),
(3540, 1072, '罗庄区', 3, '', ''),
(3541, 1072, '兰山区', 3, '', ''),
(3542, 1060, '德城区', 3, '', ''),
(3543, 1099, '牡丹区', 3, '', ''),
(3544, 412, '惠济区', 3, '', ''),
(3545, 412, '金水区', 3, '', ''),
(3546, 412, '管城回族区', 3, '', ''),
(3547, 412, '二七区', 3, '', ''),
(3548, 412, '中原区', 3, '', ''),
(3554, 427, '洛龙区', 3, '', ''),
(3555, 427, '吉利区', 3, '', ''),
(3556, 427, '涧西区', 3, '', ''),
(3557, 427, '瀍河回族区', 3, '', ''),
(3558, 427, '老城区', 3, '', ''),
(3559, 427, '西工区', 3, '', ''),
(3560, 438, '石龙区', 3, '', ''),
(3562, 438, '卫东区', 3, '', ''),
(3564, 446, '马村区', 3, '', ''),
(3565, 446, '中站区', 3, '', ''),
(3566, 446, '解放区', 3, '', ''),
(3567, 454, '山城区', 3, '', ''),
(3570, 458, '凤泉区', 3, '', ''),
(3572, 458, '卫滨区', 3, '', ''),
(3573, 468, '殷都区', 3, '', ''),
(3574, 468, '文峰区', 3, '', ''),
(3575, 468, '北关区', 3, '', ''),
(3576, 489, '源汇区', 3, '', ''),
(3577, 502, '宛城区', 3, '', ''),
(3580, 527, '川汇区', 3, '', ''),
(3582, 1381, '江汉区', 3, '', ''),
(3583, 1381, '硚口区', 3, '', ''),
(3587, 1381, '东西湖区', 3, '', ''),
(3589, 1396, '襄州区', 3, '', ''),
(3590, 1396, '樊城区', 3, '', ''),
(3593, 1413, '沙市区', 3, '', ''),
(3594, 1421, '宜都市', 3, '', ''),
(3595, 1421, '猇亭区', 3, '', ''),
(3596, 1421, '点军区', 3, '', ''),
(3597, 1421, '伍家岗区', 3, '', ''),
(3598, 1421, '西陵区', 3, '', ''),
(3599, 1477, '掇刀区', 3, '', ''),
(3600, 1477, '东宝区', 3, '', ''),
(3601, 1475, '梁子湖区', 3, '', ''),
(3602, 1475, '华容区', 3, '', ''),
(3604, 1482, '开福区', 3, '', ''),
(3605, 1482, '天心区', 3, '', ''),
(3606, 1482, '芙蓉区', 3, '', ''),
(3607, 1482, '岳麓区', 3, '', ''),
(3608, 1488, '石峰区', 3, '', ''),
(3610, 1488, '荷塘区', 3, '', ''),
(3614, 1501, '石鼓区', 3, '', ''),
(3615, 1501, '珠晖区', 3, '', ''),
(3617, 1511, '大祥区', 3, '', ''),
(3618, 1511, '双清区', 3, '', ''),
(3619, 1522, '君山区', 3, '', ''),
(3620, 1522, '云溪区', 3, '', ''),
(3622, 1540, '永定区', 3, '', ''),
(3624, 1544, '北湖区', 3, '', ''),
(3626, 1574, '中方县', 3, '', ''),
(3627, 1586, '娄星区', 3, '', ''),
(3628, 560, '浑南新区', 3, '', ''),
(3633, 1601, '天河区', 3, '', ''),
(3634, 1601, '海珠区', 3, '', ''),
(3635, 1601, '荔湾区', 3, '', ''),
(3637, 1601, '越秀区', 3, '', ''),
(3638, 1607, '罗湖区', 3, '', ''),
(3639, 1607, '福田区', 3, '', ''),
(3640, 1609, '斗门区', 3, '', ''),
(3641, 1609, '金湾区', 3, '', ''),
(3643, 1617, '武江区', 3, '', ''),
(3644, 1617, '浈江区', 3, '', ''),
(3645, 1659, '蓬江区', 3, '', ''),
(3646, 1677, '坡头区', 3, '', ''),
(3648, 1677, '赤坎区', 3, '', ''),
(3650, 1715, '横县', 3, '', ''),
(3651, 1715, '上林县', 3, '', ''),
(3652, 1715, '隆安县', 3, '', ''),
(3653, 1715, '马山县', 3, '', ''),
(3657, 1715, '兴宁区', 3, '', ''),
(3658, 1715, '青秀区', 3, '', ''),
(3659, 1720, '融安县', 3, '', ''),
(3660, 1720, '三江侗族自治县', 3, '', ''),
(3661, 1720, '融水苗族自治县', 3, '', ''),
(3662, 1720, '柳北区', 3, '', ''),
(3665, 1720, '城中区', 3, '', ''),
(3666, 1726, '恭城瑶族自治县', 3, '', ''),
(3667, 1726, '七星区', 3, '', ''),
(3669, 1726, '叠彩区', 3, '', ''),
(3670, 1726, '象山区', 3, '', ''),
(3671, 1740, '蝶山区', 3, '', ''),
(3672, 1740, '万秀区', 3, '', ''),
(3673, 1746, '银海区', 3, '', ''),
(3674, 1746, '海城区', 3, '', ''),
(3677, 1757, '港北区', 3, '', ''),
(3678, 1806, '凌云县', 3, '', ''),
(3679, 1818, '都安县', 3, '', ''),
(3680, 1818, '金城江区', 3, '', ''),
(3681, 3168, '凭祥市', 3, '', ''),
(3682, 3168, '扶绥县', 3, '', ''),
(3683, 3168, '大新县', 3, '', ''),
(3684, 3168, '天等县', 3, '', ''),
(3685, 3168, '宁明县 ', 3, '', ''),
(3686, 3168, '龙州县', 3, '', ''),
(3689, 2121, '美兰区', 3, '', ''),
(3690, 23, '三亚市', 2, '', ''),
(3691, 3690, '河西区', 3, '', ''),
(3693, 3690, '海棠湾镇', 3, '', ''),
(3694, 3690, '田独镇', 3, '', ''),
(3695, 3690, '凤凰镇', 3, '', ''),
(3696, 3690, '天涯镇', 3, '', ''),
(3697, 3690, '育才镇', 3, '', ''),
(3698, 23, '文昌市', 2, '', ''),
(3699, 23, '五指山市', 2, '', ''),
(3701, 23, '临高县', 2, '', ''),
(3702, 23, '澄迈县', 2, '', ''),
(3703, 23, '定安县', 2, '', ''),
(3704, 23, '屯昌县', 2, '', ''),
(3705, 23, '昌江县', 2, '', ''),
(3706, 23, '白沙县', 2, '', ''),
(3707, 23, '琼中县', 2, '', ''),
(3708, 23, '陵水县', 2, '', ''),
(3709, 23, '保亭县', 2, '', ''),
(3710, 23, '乐东县', 2, '', ''),
(3711, 23, '三沙市', 2, '', ''),
(3712, 3699, '通什镇', 3, '', ''),
(3713, 3699, '南圣镇', 3, '', ''),
(3714, 3699, '毛阳镇', 3, '', ''),
(3715, 3699, '番阳镇', 3, '', ''),
(3716, 3699, '畅好乡', 3, '', ''),
(3717, 3699, '毛道乡', 3, '', ''),
(3718, 412, '荥阳市', 3, '', ''),
(3719, 3699, '水满乡', 3, '', ''),
(3720, 3115, '嘉积镇', 3, '', ''),
(3721, 3115, '万泉镇', 3, '', ''),
(3722, 3115, '石壁镇', 3, '', ''),
(3723, 3115, '中原镇', 3, '', ''),
(3724, 3115, '博鳌镇', 3, '', ''),
(3725, 3115, '阳江镇', 3, '', ''),
(3727, 3115, '龙江镇', 3, '', ''),
(3728, 3115, '潭门镇', 3, '', ''),
(3729, 3115, '塔洋镇', 3, '', ''),
(3730, 3115, '长坡镇', 3, '', ''),
(3731, 3115, '大路镇', 3, '', ''),
(3732, 3115, '会山镇', 3, '', ''),
(3733, 3034, '和庆镇', 3, '', ''),
(3734, 3034, '南丰镇', 3, '', ''),
(3735, 3034, '大成镇', 3, '', ''),
(3736, 3034, '雅星镇', 3, '', ''),
(3737, 3034, '兰洋镇', 3, '', ''),
(3738, 3034, '光村镇', 3, '', ''),
(3739, 3034, '木棠镇', 3, '', ''),
(3740, 3034, '海头镇', 3, '', ''),
(3741, 3034, '峨蔓镇', 3, '', ''),
(3742, 988, '高新区', 3, '', ''),
(3743, 1657, '沙溪镇', 3, '', ''),
(3744, 3034, '三都镇', 3, '', ''),
(3745, 3034, '王五镇', 3, '', ''),
(3746, 3034, '白马井镇', 3, '', ''),
(3747, 3034, '中和镇', 3, '', ''),
(3748, 3034, '排浦镇', 3, '', ''),
(3749, 3034, '东成镇', 3, '', ''),
(3750, 3034, '新州镇', 3, '', ''),
(3751, 3034, '洋浦经济开发区', 3, '', ''),
(3752, 3698, '文城镇', 3, '', ''),
(3753, 3698, '重兴镇', 3, '', ''),
(3754, 3698, '蓬莱镇', 3, '', ''),
(3755, 3698, '会文镇', 3, '', ''),
(3756, 3698, '东路镇', 3, '', ''),
(3757, 3698, '潭牛镇', 3, '', ''),
(3758, 3698, '东阁镇', 3, '', ''),
(3759, 3698, '文教镇', 3, '', ''),
(3760, 3698, '东郊镇', 3, '', ''),
(3761, 3698, '龙楼镇', 3, '', ''),
(3762, 3698, '昌洒镇', 3, '', ''),
(3763, 3698, '翁田镇', 3, '', ''),
(3764, 3698, '抱罗镇', 3, '', ''),
(3765, 3698, '冯坡镇', 3, '', ''),
(3766, 3698, '锦山镇', 3, '', ''),
(3767, 3698, '铺前镇', 3, '', ''),
(3768, 3137, '万城镇', 3, '', ''),
(3769, 3137, '龙滚镇', 3, '', ''),
(3770, 3137, '和乐镇', 3, '', ''),
(3771, 3137, '后安镇', 3, '', ''),
(3772, 3137, '大茂镇', 3, '', ''),
(3773, 3137, '东澳镇', 3, '', ''),
(3774, 3137, '礼纪镇', 3, '', ''),
(3775, 3137, '长丰镇', 3, '', ''),
(3776, 3137, '山根镇', 3, '', ''),
(3777, 3137, '北大镇', 3, '', ''),
(3778, 3137, '南桥镇', 3, '', ''),
(3779, 3137, '三更罗镇', 3, '', ''),
(3780, 3173, '八所镇', 3, '', ''),
(3781, 3173, '东河镇', 3, '', ''),
(3782, 3173, '大田镇', 3, '', ''),
(3783, 3173, '感城镇', 3, '', ''),
(3784, 3173, '板桥镇', 3, '', ''),
(3785, 3173, '三家镇', 3, '', ''),
(3786, 3173, '四更镇', 3, '', ''),
(3787, 3173, '新龙镇', 3, '', ''),
(3788, 3173, '天安乡', 3, '', ''),
(3789, 3173, '江边乡', 3, '', ''),
(3790, 3701, '临城镇', 3, '', ''),
(3791, 3701, '波莲镇', 3, '', ''),
(3792, 3701, '东英镇', 3, '', ''),
(3793, 3701, '博厚镇', 3, '', ''),
(3794, 3701, '皇桐镇', 3, '', ''),
(3795, 3701, '多文镇', 3, '', ''),
(3796, 3701, '和舍镇', 3, '', ''),
(3797, 3701, '南宝镇', 3, '', ''),
(3798, 3701, '新盈镇', 3, '', ''),
(3799, 3701, '调楼镇', 3, '', ''),
(3800, 3701, '加来镇', 3, '', ''),
(3801, 3702, '金江镇', 3, '', ''),
(3802, 3702, '老城镇', 3, '', ''),
(3803, 3702, '瑞溪镇', 3, '', ''),
(3804, 3702, '永发镇', 3, '', ''),
(3805, 3702, '加乐镇', 3, '', ''),
(3806, 3702, '文儒镇', 3, '', ''),
(3807, 3702, '中兴镇', 3, '', ''),
(3808, 3702, '仁兴镇', 3, '', ''),
(3809, 3702, '福山镇', 3, '', ''),
(3810, 3702, '桥头镇', 3, '', ''),
(3811, 3703, '定城镇', 3, '', ''),
(3812, 3703, '新竹镇', 3, '', ''),
(3813, 3703, '龙湖镇', 3, '', ''),
(3814, 3703, '雷鸣镇', 3, '', ''),
(3815, 3703, '龙门镇', 3, '', ''),
(3816, 3703, '龙河镇', 3, '', ''),
(3817, 3703, '岭口镇', 3, '', ''),
(3818, 3703, '翰林镇', 3, '', ''),
(3819, 3703, '富文镇', 3, '', ''),
(3820, 3704, '屯城镇', 3, '', ''),
(3821, 3704, '新兴镇', 3, '', ''),
(3822, 3704, '枫木镇', 3, '', ''),
(3823, 3704, '乌坡镇', 3, '', ''),
(3824, 3704, '南吕镇', 3, '', ''),
(3825, 3704, '南坤镇', 3, '', ''),
(3826, 3704, '坡心镇', 3, '', ''),
(3827, 3704, '西昌镇', 3, '', ''),
(3828, 3705, '石碌镇', 3, '', ''),
(3829, 3705, '叉河镇', 3, '', ''),
(3830, 3705, '十月田镇', 3, '', ''),
(3831, 3705, '乌烈镇', 3, '', ''),
(3832, 3705, '昌化镇', 3, '', ''),
(3833, 3705, '海尾镇', 3, '', ''),
(3834, 3706, '牙叉镇', 3, '', ''),
(3835, 3706, '七坊镇', 3, '', ''),
(3836, 3706, '邦溪镇', 3, '', ''),
(3837, 3706, '打安镇', 3, '', ''),
(3838, 3706, '细水乡', 3, '', ''),
(3839, 3706, '元门乡', 3, '', ''),
(3840, 3706, '南开乡', 3, '', ''),
(3841, 3706, '阜龙乡', 3, '', ''),
(3842, 3706, '青松乡', 3, '', ''),
(3843, 3706, '金波乡', 3, '', ''),
(3844, 3706, '荣邦乡', 3, '', ''),
(3845, 3710, '抱由镇', 3, '', ''),
(3846, 3710, '万冲镇', 3, '', ''),
(3847, 3710, '大安镇', 3, '', ''),
(3848, 1609, '吉大区', 3, '', ''),
(3849, 3710, '志仲镇', 3, '', ''),
(3850, 1609, '拱北区', 3, '', ''),
(3851, 3710, '千家镇', 3, '', ''),
(3852, 3710, '九所镇', 3, '', ''),
(3853, 3710, '利国镇', 3, '', ''),
(3854, 3710, '黄流镇', 3, '', ''),
(3855, 3710, '佛罗镇', 3, '', ''),
(3856, 3710, '尖峰镇', 3, '', ''),
(3857, 3710, '莺歌海镇', 3, '', ''),
(3858, 3708, '椰林镇', 3, '', ''),
(3859, 3708, '光坡镇', 3, '', ''),
(3860, 3708, '三才镇', 3, '', ''),
(3861, 3708, '英州镇', 3, '', ''),
(3862, 3708, '隆广镇', 3, '', ''),
(3863, 3708, '文罗镇', 3, '', ''),
(3864, 3708, '本号镇', 3, '', ''),
(3865, 3708, '新村镇', 3, '', ''),
(3866, 3708, '黎安镇', 3, '', ''),
(3867, 3708, '提蒙乡', 3, '', ''),
(3868, 3708, '群英乡', 3, '', ''),
(3869, 3709, '保城镇', 3, '', ''),
(3870, 3709, '什玲镇', 3, '', ''),
(3871, 3709, '加茂镇', 3, '', ''),
(3872, 3709, '响水镇', 3, '', ''),
(3873, 3709, '新政镇', 3, '', ''),
(3874, 3709, '三道镇', 3, '', ''),
(3875, 3709, '六弓乡', 3, '', ''),
(3876, 3709, '南林乡', 3, '', ''),
(3877, 3709, '毛感乡', 3, '', ''),
(3878, 3707, '营根镇', 3, '', ''),
(3879, 3707, '湾岭镇', 3, '', ''),
(3880, 3707, '黎母山镇', 3, '', ''),
(3881, 3707, '和平镇', 3, '', ''),
(3882, 3707, '长征镇', 3, '', ''),
(3883, 3707, '红毛镇', 3, '', ''),
(3884, 3707, '中平镇', 3, '', ''),
(3885, 3707, '上安乡', 3, '', ''),
(3886, 3707, '什运乡', 3, '', ''),
(3887, 3711, '西沙群岛', 3, '', ''),
(3888, 3711, '南沙群岛', 3, '', ''),
(3890, 1930, '金牛区', 3, '', ''),
(3893, 1946, '大安区', 3, '', ''),
(3894, 1946, '贡井区', 3, '', ''),
(3895, 1946, '沿滩区', 3, '', ''),
(3896, 1950, '西区', 3, '', ''),
(3897, 1950, '东区', 3, '', ''),
(3898, 1954, '纳溪区', 3, '', ''),
(3900, 1960, '游仙区', 3, '', ''),
(3901, 1977, '元坝区', 3, '', ''),
(3902, 1977, '朝天区', 3, '', ''),
(3904, 2042, '巴州区', 3, '', ''),
(3905, 2065, '雁江区', 3, '', ''),
(3906, 2144, '南明区', 3, '', ''),
(3907, 2144, '云岩区', 3, '', ''),
(3908, 2144, '花溪区', 3, '', ''),
(3909, 2144, '白云区', 3, '', ''),
(3912, 2235, '五华区', 3, '', ''),
(3913, 2235, '官渡区', 3, '', ''),
(3914, 2235, '西山区', 3, '', ''),
(3915, 2291, '双江县', 3, '', ''),
(3916, 2291, '沧源县', 3, '', ''),
(3917, 2336, '姚安县', 3, '', ''),
(3918, 2951, '当雄县', 3, '', ''),
(3919, 2951, '尼木县', 3, '', ''),
(3920, 2951, '曲水县', 3, '', ''),
(3921, 2951, '堆龙德庆县', 3, '', ''),
(3922, 2951, '达孜县', 3, '', ''),
(3923, 2951, '墨竹工卡县', 3, '', ''),
(3924, 3138, '江达县', 3, '', ''),
(3925, 3138, '贡觉县', 3, '', ''),
(3926, 3138, '类乌齐县', 3, '', ''),
(3927, 3138, '丁青县', 3, '', ''),
(3928, 3138, '察雅县', 3, '', ''),
(3929, 3138, '八宿县', 3, '', ''),
(3930, 3138, '左贡县', 3, '', ''),
(3931, 3138, '芒康县', 3, '', ''),
(3932, 3138, '洛隆县', 3, '', ''),
(3933, 3138, '边坝县', 3, '', ''),
(3934, 3129, '扎囊县', 3, '', ''),
(3935, 3129, '乃东县', 3, '', ''),
(3936, 3129, '桑日县', 3, '', ''),
(3937, 3129, '琼结县', 3, '', ''),
(3938, 3129, '曲松县', 3, '', ''),
(3939, 3129, '措美县', 3, '', ''),
(3940, 3129, '洛扎县', 3, '', ''),
(3941, 3129, '加查县', 3, '', ''),
(3942, 3129, '隆子县', 3, '', ''),
(3943, 3129, '错那县', 3, '', ''),
(3944, 3129, '浪卡子县', 3, '', ''),
(3945, 3144, '日喀则市', 3, '', ''),
(3946, 3144, '南木林县', 3, '', ''),
(3947, 3144, '江孜县', 3, '', ''),
(3948, 3144, '定日县', 3, '', ''),
(3949, 3144, '萨迦县 ', 3, '', ''),
(3950, 3144, '拉孜县', 3, '', ''),
(3951, 3144, '谢通门县', 3, '', ''),
(3952, 3144, '白朗县', 3, '', ''),
(3953, 3144, '仁布县', 3, '', ''),
(3954, 3144, '康马县', 3, '', ''),
(3955, 3144, '定结县', 3, '', ''),
(3956, 3144, '仲巴县', 3, '', ''),
(3957, 3144, '亚东县', 3, '', ''),
(3958, 3144, '吉隆县', 3, '', ''),
(3959, 3144, '萨嘎县', 3, '', ''),
(3960, 3144, '岗巴县', 3, '', ''),
(3961, 3107, '那曲县', 3, '', ''),
(3962, 3107, '嘉黎县', 3, '', ''),
(3963, 3107, '比如县', 3, '', ''),
(3964, 3107, '聂荣县', 3, '', ''),
(3965, 3107, '安多县', 3, '', ''),
(3966, 3107, '申扎县', 3, '', ''),
(3967, 3107, '班戈县', 3, '', ''),
(3968, 3107, '巴青县', 3, '', ''),
(3969, 3107, '尼玛县', 3, '', ''),
(3970, 26, '阿里地区', 2, '', ''),
(3971, 26, '林芝地区', 2, '', ''),
(3972, 3970, '噶尔县', 3, '', ''),
(3973, 3970, '普兰县', 3, '', ''),
(3974, 3970, '札达县 ', 3, '', ''),
(3975, 3970, '日土县', 3, '', ''),
(3976, 3970, '革吉县', 3, '', ''),
(3977, 3970, '改则县', 3, '', ''),
(3978, 3970, '措勤县', 3, '', ''),
(3979, 3971, '林芝县', 3, '', ''),
(3980, 3971, '工布江达县', 3, '', ''),
(3981, 3971, '米林县', 3, '', ''),
(3982, 3971, '墨脱县', 3, '', ''),
(3983, 3971, '波密县', 3, '', ''),
(3984, 3971, '察隅县', 3, '', ''),
(3985, 3971, '朗县', 3, '', ''),
(3986, 2376, '碑林区', 3, '', ''),
(3989, 2386, '耀州区', 3, '', ''),
(3990, 2390, '金台区', 3, '', ''),
(3993, 2476, '汉滨区', 3, '', ''),
(3994, 2487, '七里河区', 3, '', ''),
(3995, 2487, '西固区', 3, '', ''),
(3997, 2487, '红古区', 3, '', ''),
(3998, 2518, '静宁县', 3, '', ''),
(3999, 2556, '瓜州县', 3, '', ''),
(4000, 2556, '肃州区', 3, '', ''),
(4001, 2525, '庆城县', 3, '', ''),
(4002, 3080, '安定区', 3, '', ''),
(4003, 3080, '通渭县', 3, '', ''),
(4004, 3080, '临洮县', 3, '', ''),
(4005, 3080, '漳县', 3, '', ''),
(4006, 3080, '渭源县', 3, '', ''),
(4007, 3080, '陇西县', 3, '', ''),
(4008, 2573, '广河县', 3, '', ''),
(4009, 2580, '城东区', 3, '', ''),
(4010, 2580, '城西区', 3, '', ''),
(4011, 2580, '城北区', 3, '', ''),
(4012, 2603, '共和县', 3, '', ''),
(4013, 2603, '同德县', 3, '', ''),
(4014, 2603, '贵德县', 3, '', ''),
(4015, 2603, '兴海县', 3, '', ''),
(4016, 2603, '贵南县', 3, '', ''),
(4017, 2628, '兴庆区', 3, '', ''),
(4020, 3071, '沙坡头区', 3, '', ''),
(4024, 2652, '头屯河区', 3, '', ''),
(4025, 2652, '达坂城区', 3, '', ''),
(4026, 2652, '米东区', 3, '', ''),
(4027, 2654, '乌尔禾区', 3, '', ''),
(4028, 2727, '奎屯市', 3, '', ''),
(4029, 984, '新区', 3, '', ''),
(4031, 1609, '金唐区', 3, '', ''),
(4032, 604, '杨家杖子经济开发区', 3, '', ''),
(4036, 502, '高新区', 3, '', ''),
(4037, 14, '凤阳县', 2, '', ''),
(4039, 1827, '高新区', 3, '', ''),
(4040, 1601, '南沙区', 3, '', ''),
(4042, 1657, '五桂山镇', 3, '', ''),
(4043, 1081, '高唐', 3, '', ''),
(4044, 639, '净月开发区', 3, '', ''),
(4046, 224, '宣化区', 3, '', ''),
(4075, 1140, '安庆市开发区', 3, '', ''),
(4076, 1657, '阜沙镇', 3, '', ''),
(4078, 1413, '荆州区', 3, '', ''),
(4080, 1657, '东升镇', 3, '', ''),
(4081, 2454, '靖边县', 3, '', ''),
(4086, 2304, '古城区', 3, '', ''),
(4087, 1655, '谢岗镇', 3, '', ''),
(4090, 2376, '杨凌区', 3, '', ''),
(4093, 248, '抚宁县', 3, '', ''),
(4094, 9, '珲春市', 2, '', ''),
(4095, 965, '开发区', 3, '', ''),
(4096, 2376, '高新区', 3, '', ''),
(4097, 274, '开发区', 3, '', ''),
(4100, 1930, '高新区', 3, '', ''),
(4101, 1827, '昌北区', 3, '', ''),
(4102, 1657, '板芙镇', 3, '', ''),
(4103, 427, '洛南新区', 3, '', ''),
(4105, 142, '经济技术开发区', 3, '', ''),
(4108, 25, '迪庆州', 2, '', ''),
(4110, 31, '五家渠市', 2, '', ''),
(4111, 1960, '高新区', 3, '', ''),
(4113, 1108, '岚山区', 3, '', ''),
(4114, 793, '加格达奇区', 3, '', ''),
(4115, 793, '松岭区', 3, '', ''),
(4116, 793, '呼中区', 3, '', ''),
(4119, 4037, '凤阳县', 3, '', ''),
(4122, 4110, '五家渠市', 3, '', ''),
(4123, 4094, '珲春市', 3, '', ''),
(4124, 1139, '当涂县', 3, '', ''),
(4127, 1657, '神湾镇', 3, '', ''),
(4130, 1250, '南浔区', 3, '', ''),
(4131, 1053, '高区', 3, '', ''),
(4132, 2800, '上地', 3, '', ''),
(4134, 2800, '西三旗', 3, '', ''),
(4135, 2901, '六环以内', 3, '', ''),
(4136, 2901, '城区', 3, '', ''),
(4137, 72, '管庄', 3, '', ''),
(4139, 72, '北苑', 3, '', ''),
(4140, 1930, '温江区', 3, '', ''),
(4141, 1657, '港口镇', 3, '', ''),
(4144, 1053, '经济技术开发区', 3, '', ''),
(4145, 1677, '湛江经济技术开发区', 3, '', ''),
(4147, 1655, '松山湖', 3, '', ''),
(4148, 757, '绥芬河市', 3, '', ''),
(4150, 427, '嵩县', 3, '', ''),
(4158, 142, '平山县', 3, '', ''),
(4159, 2836, '申港街道', 3, '', ''),
(4161, 1845, '共青城', 3, '', ''),
(4162, 2390, '高新区', 3, '', ''),
(4163, 31, '博尔塔拉蒙古自治州阿拉山口口岸', 2, '', ''),
(4164, 87, '城口县', 3, '', ''),
(4171, 2675, '阿拉尔市', 3, '', ''),
(4172, 1127, '弋江区', 3, '', ''),
(4173, 1116, '经济技术开发区', 3, '', ''),
(4175, 2809, '五环到六环之间', 3, '', ''),
(4180, 2836, '临港新城', 3, '', ''),
(4182, 3690, '崖城镇', 3, '', ''),
(4183, 199, '保定市', 3, '', ''),
(4185, 639, '经济技术开发区', 3, '', ''),
(4186, 1140, '宜秀区', 3, '', ''),
(4187, 2806, '石景山城区', 3, '', ''),
(4188, 2806, '八大处科技园区', 3, '', ''),
(4190, 1657, '大涌镇', 3, '', ''),
(4191, 3690, '河东区', 3, '', ''),
(4192, 1116, '高新技术开发区', 3, '', ''),
(4194, 2810, '四环至五环之间', 3, '', ''),
(4196, 1108, '新市区', 3, '', ''),
(4197, 412, '高新区', 3, '', ''),
(4198, 1441, '仙桃市', 3, '', ''),
(4203, 2800, '清河', 3, '', ''),
(4205, 2810, '六环以外', 3, '', ''),
(4206, 2812, '左提顺平高白机场', 3, '', ''),
(4207, 2800, '圆明园西路', 3, '', ''),
(4208, 2800, '农业大学西校区', 3, '', ''),
(4209, 2800, '西二旗', 3, '', ''),
(4211, 72, '定福庄', 3, '', ''),
(4212, 72, '北京经济技术开发区', 3, '', ''),
(4214, 3034, '富克镇', 3, '', ''),
(4223, 911, '金山桥开发区', 3, '', ''),
(4224, 911, '铜山经济技术开发区', 3, '', ''),
(4225, 911, '郑集镇', 3, '', ''),
(4226, 911, '大吴镇', 3, '', ''),
(4227, 911, '大庙镇', 3, '', ''),
(4228, 911, '八段工业园区', 3, '', ''),
(4229, 911, '柳新镇', 3, '', ''),
(4230, 2144, '金阳新区', 3, '', ''),
(4238, 1705, '枫溪区', 3, '', ''),
(4242, 1601, '增城市', 3, '', ''),
(4248, 919, '连云区', 3, '', ''),
(4250, 18, '耒阳市', 2, '', ''),
(4251, 4250, '耒阳市', 3, '', ''),
(4252, 4250, '蔡子池区', 3, '', ''),
(4253, 1158, '高新科技开发区', 3, '', ''),
(4255, 1655, '莞城区', 3, '', ''),
(4256, 1655, '南城区', 3, '', ''),
(4267, 87, '沙坪坝区', 3, '', ''),
(4268, 2376, '莲湖区', 3, '', ''),
(4269, 2376, '未央区', 3, '', ''),
(4270, 2376, '灞桥区', 3, '', ''),
(4271, 2376, '长安区', 3, '', ''),
(4272, 1000, '历下区', 3, '', ''),
(4273, 1000, '历城区', 3, '', ''),
(4274, 1000, '市中区', 3, '', ''),
(4275, 1000, '槐荫区', 3, '', ''),
(4277, 1000, '高新区', 3, '', ''),
(4278, 1930, '青羊区', 3, '', ''),
(4279, 1930, '锦江区', 3, '', ''),
(4281, 1930, '武侯区', 3, '', ''),
(4282, 1930, '成华区', 3, '', ''),
(4284, 1930, '高新西区', 3, '', ''),
(4285, 1213, '下沙区', 3, '', ''),
(4287, 1158, '鄞州区', 3, '', ''),
(4298, 87, '南岸区', 3, '', ''),
(4305, 925, '经济开发区', 3, '', ''),
(4312, 1482, '雨花区', 3, '', ''),
(4320, 698, '道里区', 3, '', ''),
(4321, 698, '道外区', 3, '', ''),
(4326, 1233, '鹿城区', 3, '', ''),
(4328, 1233, '瓯海区', 3, '', ''),
(4337, 412, '郑东新区', 3, '', ''),
(4341, 1233, '永嘉县', 3, '', ''),
(4342, 1233, '温州茶山高教园区', 3, '', ''),
(4343, 2376, '雁塔区', 3, '', ''),
(4346, 988, '太仓市', 3, '', ''),
(4349, 1609, '香洲区', 3, '', ''),
(4359, 303, '晋源区', 3, '', ''),
(4360, 2919, '崇明岛', 3, '', ''),
(4361, 2919, '长兴岛', 3, '', ''),
(4362, 2919, '横沙岛', 3, '', ''),
(4364, 1233, '郭溪镇', 3, '', ''),
(4365, 1233, '瞿溪镇', 3, '', ''),
(4366, 1233, '潘桥镇', 3, '', ''),
(4367, 1233, '南白象镇', 3, '', ''),
(4370, 639, '高新区', 3, '', ''),
(4371, 639, '绿园区', 3, '', ''),
(4377, 639, '汽车产业开发区', 3, '', ''),
(4385, 965, '南通经济技术开发区', 3, '', ''),
(4394, 639, '朝阳区', 3, '', ''),
(4395, 1213, '良渚镇', 3, '', ''),
(4396, 1213, '临平镇', 3, '', ''),
(4399, 1213, '闲林镇', 3, '', ''),
(4401, 1213, '瓶窑镇', 3, '', ''),
(4403, 1213, '乔司镇', 3, '', ''),
(4414, 142, '桥东区', 3, '', ''),
(4415, 142, '桥西区', 3, '', ''),
(4416, 142, '新华区', 3, '', ''),
(4417, 904, '浦口区', 3, '', ''),
(4419, 1158, '宁波保税区', 3, '', ''),
(4423, 1381, '青山区', 3, '', ''),
(4424, 1381, '武汉经济技术开发区', 3, '', ''),
(4429, 1243, '桐乡市', 3, '', ''),
(4430, 1243, '平湖市', 3, '', ''),
(4431, 1243, '嘉善县', 3, '', ''),
(4432, 2487, '安宁区', 3, '', ''),
(4435, 1715, '西乡塘区', 3, '', '');
INSERT INTO `province_city` (`pcity_id`, `parent_id`, `pcity_name`, `pcity_level`, `pinyin`, `first_letter`) VALUES
(4438, 1715, '良庆区', 3, '', ''),
(4439, 799, '新城区', 3, '', ''),
(4454, 1726, '秀峰区', 3, '', ''),
(4457, 1726, '雁山区', 3, '', ''),
(4458, 2376, '新城区', 3, '', ''),
(4459, 978, '武进区', 3, '', ''),
(4468, 573, '中山区', 3, '', ''),
(4472, 560, '沈河区', 3, '', ''),
(4474, 1290, '路桥区', 3, '', ''),
(4475, 1290, '黄岩区', 3, '', ''),
(4476, 1332, '鲤城区', 3, '', ''),
(4479, 1960, '经开区', 3, '', ''),
(4483, 1255, '袍江工业区', 3, '', ''),
(4493, 1720, '柳南区', 3, '', ''),
(4494, 1720, '鱼峰区', 3, '', ''),
(4498, 3703, '黄竹镇', 3, '', ''),
(4499, 2727, '伊宁县', 3, '', ''),
(4748, 248, '海港区', 3, '', ''),
(4750, 2121, '龙华区', 3, '', ''),
(4751, 2121, '秀英区', 3, '', ''),
(4752, 2121, '琼山区', 3, '', ''),
(4755, 1611, '龙湖区', 3, '', ''),
(4759, 1677, '霞山区', 3, '', ''),
(4760, 1655, '长安镇', 3, '', ''),
(4763, 258, '路北区', 3, '', ''),
(4765, 83, '塘沽区', 3, '', ''),
(4767, 2652, '沙依巴克区', 3, '', ''),
(4768, 2652, '水磨沟区', 3, '', ''),
(4769, 2652, '新市区', 3, '', ''),
(4770, 911, '泉山区', 3, '', ''),
(4772, 911, '鼓楼区', 3, '', ''),
(4773, 1607, '宝安区', 3, '', ''),
(4779, 2402, '秦都区', 3, '', ''),
(4780, 2402, '渭城区', 3, '', ''),
(4781, 1690, '端州区', 3, '', ''),
(4788, 925, '清河区', 3, '', ''),
(4789, 925, '清浦区', 3, '', ''),
(4790, 925, '淮阴区', 3, '', ''),
(4793, 919, '海州区', 3, '', ''),
(4798, 1488, '芦淞区', 3, '', ''),
(4804, 1137, '金家庄区', 3, '', ''),
(4806, 2628, '金凤区', 3, '', ''),
(4807, 2628, '西夏区', 3, '', ''),
(4808, 1911, '章贡区', 3, '', ''),
(4811, 1132, '禹会区', 3, '', ''),
(4812, 1132, '龙子湖区', 3, '', ''),
(4820, 148, '邯山区', 3, '', ''),
(4821, 1672, '江城区', 3, '', ''),
(4830, 1167, '颍州区', 3, '', ''),
(4832, 1167, '阜阳经济技术开发区', 3, '', ''),
(4833, 1280, '莲都区', 3, '', ''),
(4837, 1715, '江南区', 3, '', ''),
(4839, 1684, '茂南区', 3, '', ''),
(4840, 1627, '源城区', 3, '', ''),
(4851, 1332, '晋江市', 3, '', ''),
(4852, 1657, '火炬开发区', 3, '', ''),
(4855, 698, '香坊区', 3, '', ''),
(4860, 579, '鞍山高新区', 3, '', ''),
(4862, 1954, '龙马潭区', 3, '', ''),
(4863, 2005, '宜宾市区', 3, '', ''),
(4864, 2005, '翠屏区', 3, '', ''),
(4866, 1655, '寮步镇', 3, '', ''),
(4867, 1381, '汉阳区', 3, '', ''),
(4871, 1655, '大岭山镇', 3, '', ''),
(4874, 712, '龙沙区', 3, '', ''),
(4876, 765, '东风区', 3, '', ''),
(4879, 765, '郊区', 3, '', ''),
(4881, 1381, '蔡甸区', 3, '', ''),
(4884, 1381, '黄陂区', 3, '', ''),
(4885, 1381, '汉南区', 3, '', ''),
(4886, 1655, '常平镇', 3, '', ''),
(4890, 2144, '小河区', 3, '', ''),
(4895, 1495, '雨湖区', 3, '', ''),
(4896, 1495, '岳塘区', 3, '', ''),
(4898, 224, '桥东区', 3, '', ''),
(4900, 1845, '庐山区', 3, '', ''),
(4906, 458, '牧野区', 3, '', ''),
(4907, 458, '红旗区', 3, '', ''),
(4909, 1007, '李沧区', 3, '', ''),
(4910, 1655, '厚街镇', 3, '', ''),
(4911, 1655, '万江区', 3, '', ''),
(4912, 598, '古塔区', 3, '', ''),
(4913, 598, '凌河区', 3, '', ''),
(4914, 598, '太和区', 3, '', ''),
(4916, 972, '镇江新区', 3, '', ''),
(4932, 1655, '樟木头镇', 3, '', ''),
(4933, 1655, '黄江镇', 3, '', ''),
(4934, 1705, '湘桥区', 3, '', ''),
(4960, 1121, '淮南高新技术开发区', 3, '', ''),
(4961, 1983, '船山区', 3, '', ''),
(4962, 1930, '彭州市', 3, '', ''),
(4963, 2047, '雨城区', 3, '', ''),
(4964, 1151, '徽州区', 3, '', ''),
(4967, 644, '昌邑区', 3, '', ''),
(4969, 644, '龙潭区', 3, '', ''),
(4971, 593, '振安区', 3, '', ''),
(4974, 420, '金明区', 3, '', ''),
(4975, 420, '鼓楼区', 3, '', ''),
(4976, 420, '龙亭区', 3, '', ''),
(4977, 420, '顺河回族区', 3, '', ''),
(4978, 420, '禹王台区', 3, '', ''),
(4979, 1441, '黄州区', 3, '', ''),
(4980, 1655, '大朗镇', 3, '', ''),
(4985, 1827, '红谷滩新区', 3, '', ''),
(5454, 538, '驿城区', 3, '', ''),
(5455, 1530, '武陵区', 3, '', ''),
(5457, 1655, '塘厦镇', 3, '', ''),
(5459, 1112, '泰山区', 3, '', ''),
(5461, 1114, '铜官山区', 3, '', ''),
(5462, 1114, '狮子山区', 3, '', ''),
(5463, 1114, '郊区', 3, '', ''),
(5465, 1522, '岳阳楼区', 3, '', ''),
(5471, 549, '平桥区', 3, '', ''),
(5472, 549, '浉河区', 3, '', ''),
(5473, 1655, '凤岗镇', 3, '', ''),
(5476, 1016, '张店区', 3, '', ''),
(5477, 1273, '柯城区', 3, '', ''),
(5478, 1273, '衢江区', 3, '', ''),
(5482, 1387, '西塞山区', 3, '', ''),
(5484, 1709, '东山区', 3, '', ''),
(5485, 1709, '大南山华侨管理区', 3, '', ''),
(5486, 1709, '普宁华侨管理区', 3, '', ''),
(5487, 1709, '揭阳经济开发试验区', 3, '', ''),
(5489, 1709, '榕城区', 3, '', ''),
(5492, 1396, '襄城区', 3, '', ''),
(5499, 1206, '裕安区', 3, '', ''),
(5504, 621, '文圣区', 3, '', ''),
(5505, 1007, '黄岛区', 3, '', ''),
(5506, 1032, '奎文区', 3, '', ''),
(5508, 1303, '福清市', 3, '', ''),
(5510, 1501, '雁峰区', 3, '', ''),
(5511, 1501, '蒸湘区', 3, '', ''),
(5513, 1405, '张湾区', 3, '', ''),
(5514, 1405, '茅箭区', 3, '', ''),
(5864, 1709, '普宁市', 3, '', ''),
(5865, 1677, '廉江市', 3, '', ''),
(5866, 687, '延吉市', 3, '', ''),
(5869, 1655, '清溪镇', 3, '', ''),
(5897, 2155, '汇川区', 3, '', ''),
(5898, 2155, '红花岗区', 3, '', ''),
(5899, 2900, '市中区', 3, '', ''),
(5905, 1655, '横沥镇', 3, '', ''),
(5909, 573, '甘井子区', 3, '', ''),
(6000, 925, '涟水县', 3, '', ''),
(6005, 1482, '长沙县', 3, '', ''),
(6006, 1180, '经济开发区', 3, '', ''),
(6008, 2900, '邹城市', 3, '', ''),
(6115, 2814, '城区以内', 3, '', ''),
(6117, 1116, '北城新区', 3, '', ''),
(6118, 1116, '滨湖新区', 3, '', ''),
(6119, 1116, '政务文化新区', 3, '', ''),
(6120, 1116, '新站综合开发试验区', 3, '', ''),
(6491, 2807, '城区以内', 3, '', ''),
(6492, 2808, '城区以内', 3, '', ''),
(6501, 2810, '五环至六环之间', 3, '', ''),
(6561, 573, '高新园区', 3, '', ''),
(6627, 573, '大连开发区', 3, '', ''),
(6628, 609, '站前区', 3, '', ''),
(6631, 573, '旅顺口区', 3, '', ''),
(6634, 617, '细河区', 3, '', ''),
(6635, 698, '松北区', 3, '', ''),
(6637, 698, '平房区', 3, '', ''),
(6638, 1659, '新会区', 3, '', ''),
(6639, 1930, '青白江区', 3, '', ''),
(6641, 651, '铁东区', 3, '', ''),
(6642, 651, '铁西区', 3, '', ''),
(6645, 1072, '河东区', 3, '', ''),
(6659, 1458, '赤壁市', 3, '', ''),
(6665, 1090, '滨城区', 3, '', ''),
(6666, 2953, '城区', 3, '', ''),
(6667, 2816, '城区', 3, '', ''),
(6669, 1362, '新罗区', 3, '', ''),
(6670, 164, '桥东区', 3, '', ''),
(6674, 1607, '龙华新区', 3, '', ''),
(6675, 1607, '光明新区', 3, '', ''),
(6681, 1381, '洪山区', 3, '', ''),
(6685, 1659, '开平市', 3, '', ''),
(6689, 336, '榆次区', 3, '', ''),
(6690, 1124, '相山区', 3, '', ''),
(6693, 1124, '濉溪县', 3, '', ''),
(6697, 609, '鲅鱼圈区', 3, '', ''),
(6699, 2103, '西昌市', 3, '', ''),
(6710, 1315, '海沧区', 3, '', ''),
(6712, 782, '北林区', 3, '', ''),
(6714, 2070, '汶川县', 3, '', ''),
(6715, 1930, '蒲江县', 3, '', ''),
(6724, 438, '新华区', 3, '', ''),
(6725, 438, '湛河区', 3, '', ''),
(6726, 1962, '绵竹市', 3, '', ''),
(6728, 1960, '江油市', 3, '', ''),
(6729, 560, '皇姑区', 3, '', ''),
(6735, 1607, '龙岗区', 3, '', ''),
(6736, 1607, '坪山新区', 3, '', ''),
(6737, 1607, '大鹏新区', 3, '', ''),
(6739, 1032, '潍坊高新技术开发区', 3, '', ''),
(6745, 258, '迁安市', 3, '', ''),
(6747, 199, '涿州市', 3, '', ''),
(6748, 2971, '宣州区', 3, '', ''),
(6754, 517, '梁园区', 3, '', ''),
(6757, 1127, '三山区', 3, '', ''),
(6759, 1116, '肥西县', 3, '', ''),
(6760, 1116, '长丰县', 3, '', ''),
(6766, 589, '本溪满族自治县', 3, '', ''),
(6768, 199, '高碑店市', 3, '', ''),
(6770, 1574, '鹤城区', 3, '', ''),
(6771, 148, '武安市', 3, '', ''),
(6775, 2258, '红塔区', 3, '', ''),
(6779, 1555, '赫山区', 3, '', ''),
(6782, 1475, '鄂城区', 3, '', ''),
(6784, 87, '渝北区', 3, '', ''),
(6785, 1874, '袁州区', 3, '', ''),
(6790, 598, '锦州经济技术开发区', 3, '', ''),
(6791, 1042, '烟台开发区', 3, '', ''),
(6792, 1898, '青原区', 3, '', ''),
(6797, 1666, '高明区', 3, '', ''),
(6798, 2247, '麒麟区', 3, '', ''),
(6804, 495, '湖滨区', 3, '', ''),
(6805, 454, '淇滨区', 3, '', ''),
(6818, 573, '金州区', 3, '', ''),
(6822, 2744, '北屯市', 3, '', ''),
(6823, 4108, '香格里拉县', 3, '', ''),
(6824, 4108, '德钦县', 3, '', ''),
(6825, 4108, '维西县', 3, '', ''),
(6827, 1705, '潮安县', 3, '', ''),
(6831, 589, '平山区', 3, '', ''),
(6832, 589, '溪湖区', 3, '', ''),
(6833, 589, '明山区', 3, '', ''),
(6834, 1611, '澄海区', 3, '', ''),
(6837, 1060, '齐河县', 3, '', ''),
(6839, 1370, '蕉城区', 3, '', ''),
(6841, 1303, '闽侯县', 3, '', ''),
(6843, 560, '铁西区', 3, '', ''),
(6846, 1757, '港南区', 3, '', ''),
(6848, 951, '高邮市', 3, '', ''),
(6851, 1684, '化州市', 3, '', ''),
(6856, 1684, '高州市', 3, '', ''),
(6857, 2454, '榆阳区', 3, '', ''),
(6858, 8, '铁岭市', 2, '', ''),
(6859, 6858, '银州区', 3, '', ''),
(6860, 6858, '清河区', 3, '', ''),
(6861, 6858, '调兵山市', 3, '', ''),
(6862, 6858, '开原市', 3, '', ''),
(6863, 6858, '铁岭县', 3, '', ''),
(6864, 6858, '西丰县', 3, '', ''),
(6865, 6858, '昌图县', 3, '', ''),
(6866, 2428, '宝塔区', 3, '', ''),
(6867, 2501, '秦州区', 3, '', ''),
(6868, 2501, '麦积区', 3, '', ''),
(6869, 2442, '汉台区', 3, '', ''),
(6871, 2780, '济源市', 3, '', ''),
(6874, 1116, '巢湖市', 3, '', ''),
(6876, 1112, '新泰市', 3, '', ''),
(6877, 398, '盐湖区', 3, '', ''),
(6881, 812, '红山区', 3, '', ''),
(6883, 1315, '同安区', 3, '', ''),
(6887, 274, '霸州市', 3, '', ''),
(6891, 1159, '天长市', 3, '', ''),
(6895, 142, '藁城市', 3, '', ''),
(6897, 142, '鹿泉市', 3, '', ''),
(6898, 1749, '防城区', 3, '', ''),
(6901, 1749, '港口区', 3, '', ''),
(6902, 1213, '临安市', 3, '', ''),
(6904, 199, '定州市', 3, '', ''),
(6907, 1659, '恩平市', 3, '', ''),
(6910, 379, '尧都区', 3, '', ''),
(6912, 412, '新郑市', 3, '', ''),
(6913, 1832, '昌江区', 3, '', ''),
(6915, 1861, '信州区', 3, '', ''),
(6917, 1861, '上饶县', 3, '', ''),
(6924, 1684, '电白县', 3, '', ''),
(6926, 1684, '茂港区', 3, '', ''),
(6928, 2922, '潜江市', 3, '', ''),
(6930, 2980, '天门市', 3, '', ''),
(6931, 2983, '仙桃市', 3, '', ''),
(6933, 1698, '罗定市', 3, '', ''),
(6936, 1842, '渝水区', 3, '', ''),
(6938, 1704, '英德市', 3, '', ''),
(6940, 1643, '惠东县', 3, '', ''),
(6945, 264, '黄骅市', 3, '', ''),
(6948, 1042, '龙口市', 3, '', ''),
(6950, 1053, '文登市', 3, '', ''),
(6955, 1007, '胶州市', 3, '', ''),
(6957, 1007, '平度市', 3, '', ''),
(6960, 2900, '曲阜市', 3, '', ''),
(6961, 1601, '白云区', 3, '', ''),
(6963, 1137, '博望区', 3, '', ''),
(6964, 1601, '黄埔区', 3, '', ''),
(6968, 902, '科尔沁区', 3, '', ''),
(6970, 1677, '遂溪县', 3, '', ''),
(6998, 87, '璧山县', 3, '', ''),
(6999, 87, '合川区', 3, '', ''),
(7002, 87, '江津区', 3, '', ''),
(7004, 87, '荣昌县', 3, '', ''),
(7006, 87, '铜梁县', 3, '', ''),
(7008, 87, '永川区', 3, '', ''),
(7010, 87, '长寿区', 3, '', ''),
(7011, 2235, '呈贡区', 3, '', ''),
(7357, 1479, '随县', 3, '', ''),
(7396, 1112, '肥城市', 3, '', ''),
(7398, 1607, '盐田区', 3, '', ''),
(8138, 1032, '寿光市', 3, '', ''),
(8141, 1042, '莱州市', 3, '', ''),
(8142, 2416, '临渭区', 3, '', ''),
(8145, 1303, '马尾区', 3, '', ''),
(8188, 1650, '陆丰市', 3, '', ''),
(8538, 1611, '潮南区', 3, '', ''),
(8540, 1657, '民众镇', 3, '', ''),
(8541, 1643, '博罗县', 3, '', ''),
(8545, 83, '大港区', 3, '', ''),
(8558, 933, '沭阳县', 3, '', ''),
(8559, 933, '泗阳县', 3, '', ''),
(8891, 2180, '七星关区', 3, '', ''),
(9752, 1601, '萝岗区', 3, '', ''),
(11432, 793, '新林区', 3, '', ''),
(12746, 3699, '畅好农场', 3, '', ''),
(12747, 3115, '彬村山华侨农场', 3, '', ''),
(12748, 3115, '东太农场', 3, '', ''),
(12749, 3115, '东红农场', 3, '', ''),
(12750, 3115, '东升农场', 3, '', ''),
(12751, 3115, '南俸农场', 3, '', ''),
(12752, 3034, '西培农场', 3, '', ''),
(12753, 3034, '西联农场', 3, '', ''),
(12754, 3034, '蓝洋农场', 3, '', ''),
(12755, 3034, '八一农场', 3, '', ''),
(12756, 3034, '西华农场', 3, '', ''),
(12757, 3034, '西庆农场', 3, '', ''),
(12758, 3034, '西流农场', 3, '', ''),
(12759, 3034, '新盈农场', 3, '', ''),
(12760, 3034, '龙山农场', 3, '', ''),
(12761, 3034, '红岭农场', 3, '', ''),
(12762, 3698, '公坡镇', 3, '', ''),
(12763, 3698, '迈号镇', 3, '', ''),
(12764, 3698, '清谰镇', 3, '', ''),
(12765, 3698, '南阳镇', 3, '', ''),
(12766, 3698, '新桥镇', 3, '', ''),
(12767, 3698, '头苑镇', 3, '', ''),
(12768, 3698, '宝芳乡', 3, '', ''),
(12769, 3698, '龙马乡', 3, '', ''),
(12770, 3698, '湖山乡', 3, '', ''),
(12771, 3698, '东路农场', 3, '', ''),
(12772, 3698, '南阳农场', 3, '', ''),
(12773, 3698, '罗豆农场', 3, '', ''),
(12774, 3698, '橡胶研究所', 3, '', ''),
(12775, 3137, '六连林场', 3, '', ''),
(12776, 3137, '东兴农场', 3, '', ''),
(12777, 3137, '东和农场', 3, '', ''),
(12778, 3137, '新中农场', 3, '', ''),
(12779, 3137, '兴隆华侨农场', 3, '', ''),
(12780, 3173, '广坝农场', 3, '', ''),
(12781, 3173, '东方华侨农场', 3, '', ''),
(12782, 3703, '金鸡岭农场', 3, '', ''),
(12783, 3703, '中瑞农场', 3, '', ''),
(12784, 3703, '南海农场', 3, '', ''),
(12785, 3704, '中建农场', 3, '', ''),
(12786, 3704, '中坤农场', 3, '', ''),
(12787, 3702, '大丰镇', 3, '', ''),
(12788, 3702, '红光农场', 3, '', ''),
(12789, 3702, '西达农场', 3, '', ''),
(12790, 3702, '金安农场', 3, '', ''),
(12791, 3701, '红华农场', 3, '', ''),
(12792, 3701, '加来农场', 3, '', ''),
(12793, 3706, '白沙农场', 3, '', ''),
(12794, 3706, '龙江农场', 3, '', ''),
(12795, 3706, '邦溪农场', 3, '', ''),
(12796, 3705, '七叉镇', 3, '', ''),
(12797, 3705, '王下乡', 3, '', ''),
(12798, 3705, '海南矿业公司', 3, '', ''),
(12799, 3705, '霸王岭林场', 3, '', ''),
(12800, 3705, '红林农场', 3, '', ''),
(12801, 3710, '尖峰岭林业公司', 3, '', ''),
(12802, 3710, '莺歌海盐场', 3, '', ''),
(12803, 3710, '山荣农场', 3, '', ''),
(12804, 3710, '乐光农场', 3, '', ''),
(12805, 3710, '保国农场', 3, '', ''),
(12806, 3708, '吊罗山林业公司', 3, '', ''),
(12807, 3708, '岭门农场', 3, '', ''),
(12808, 3708, '南平农场', 3, '', ''),
(12809, 3709, '保亭研究所', 3, '', ''),
(12810, 3709, '新星农场', 3, '', ''),
(12811, 3709, '金江农场', 3, '', ''),
(12812, 3709, '三道农场', 3, '', ''),
(12813, 3707, '吊罗山乡', 3, '', ''),
(12814, 3707, '黎母山林业公司', 3, '', ''),
(12815, 3707, '阳江农场', 3, '', ''),
(12816, 3707, '乌石农场', 3, '', ''),
(12817, 3707, '加钗农场', 3, '', ''),
(12818, 3707, '长征农场', 3, '', ''),
(12819, 3711, '中沙群岛', 3, '', ''),
(12824, 3034, '热作学院', 3, '', ''),
(13989, 984, '江阴市', 3, '', ''),
(14848, 2666, '和田县', 3, '', ''),
(15943, 984, '宜兴市', 3, '', ''),
(15944, 1255, '绍兴县', 3, '', ''),
(15945, 31, '阿拉尔市', 2, '', ''),
(15946, 31, '图木舒克市', 2, '', ''),
(15947, 15946, '图木舒克市', 3, '', ''),
(15948, 15945, '阿拉尔市', 3, '', ''),
(16899, 2509, '长城区', 3, '', ''),
(16923, 2509, '镜铁区', 3, '', ''),
(18317, 1836, '安源区', 3, '', ''),
(18374, 870, '康巴什新区', 3, '', '');
-- --------------------------------------------------------
--
-- 表的结构 `school`
--
CREATE TABLE `school` (
`school_id` int(11) NOT NULL COMMENT '学校ID',
`school_name` char(100) NOT NULL DEFAULT '' COMMENT '学校名称',
`name_first_letter` char(50) NOT NULL DEFAULT '' COMMENT '名称首字母',
`add_uid` int(11) NOT NULL DEFAULT 0 COMMENT '添加用户ID',
`add_time` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
`edit_uid` int(11) NOT NULL DEFAULT 0 COMMENT '编辑用户ID',
`edit_time` int(11) NOT NULL DEFAULT 0 COMMENT '编辑时间',
`is_del` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否删除:0 正常 1 删除'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='学校';
--
-- 转存表中的数据 `school`
--
INSERT INTO `school` (`school_id`, `school_name`, `name_first_letter`, `add_uid`, `add_time`, `edit_uid`, `edit_time`, `is_del`) VALUES
(1, '海南大学', 'HNDX', 1, 1538634061, 1, 1538634061, 0),
(2, '海南师范', 'HNSF', 1, 1538634089, 1, 1538634089, 0),
(3, '琼台师范', 'QTSF', 1, 1538634105, 1, 1538634105, 0),
(4, '海南医学院', 'HNYXY', 1, 1538634128, 1, 1538634128, 0),
(5, '北京大学', 'BJDX', 1, 1538634141, 1, 1538634141, 0),
(6, '复旦大学', 'FDDX', 1, 1538634158, 1, 1538634158, 0);
-- --------------------------------------------------------
--
-- 表的结构 `sell_flow`
--
CREATE TABLE `sell_flow` (
`customer_id` int(11) NOT NULL DEFAULT 0 COMMENT '客户ID',
`sandler_trust` tinyint(4) NOT NULL DEFAULT 0 COMMENT '桑德拉_信任:0 否 1 是',
`sandler_appoint` tinyint(4) NOT NULL DEFAULT 0 COMMENT '桑德拉_约定:0 否 1 是',
`sandler_pain` tinyint(4) NOT NULL DEFAULT 0 COMMENT '桑德拉_痛点:0 否 1 是',
`sandler_budget` tinyint(4) NOT NULL DEFAULT 0 COMMENT '桑德拉_预算:0 否 1 是',
`sandler_decision` tinyint(4) NOT NULL DEFAULT 0 COMMENT '桑德拉_决策:0 否 1 是',
`sandler_scheme` tinyint(4) NOT NULL DEFAULT 0 COMMENT '桑德拉_方案:0 否 1 是',
`sandler_deal` tinyint(4) NOT NULL DEFAULT 0 COMMENT '桑德拉_后售:0 否 1 是',
`trust_content` text DEFAULT NULL COMMENT '信任_内容',
`appoint_content` text DEFAULT NULL COMMENT '约定_内容',
`pain_content` text DEFAULT NULL COMMENT '痛点_内容',
`budget_content` text DEFAULT NULL COMMENT '预算_内容',
`decision_content` text DEFAULT NULL COMMENT '决策_内容',
`scheme_content` text DEFAULT NULL COMMENT '方案_内容',
`deal_content` text DEFAULT NULL COMMENT '后售_内容'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='销售流程';
-- --------------------------------------------------------
--
-- 表的结构 `sell_record`
--
CREATE TABLE `sell_record` (
`record_id` int(11) NOT NULL COMMENT '销售记录ID',
`customer_id` int(11) NOT NULL DEFAULT 0 COMMENT '客户ID',
`sell_date` int(11) NOT NULL DEFAULT 0 COMMENT '销售日期',
`sell_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '销售金额',
`sell_explain` varchar(1000) NOT NULL DEFAULT '' COMMENT '销售说明',
`add_uid` int(11) NOT NULL DEFAULT 0 COMMENT '添加用户ID',
`add_time` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
`edit_uid` int(11) NOT NULL DEFAULT 0 COMMENT '编辑用户ID',
`edit_time` int(11) NOT NULL DEFAULT 0 COMMENT '编辑时间',
`is_del` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否删除:0 正常 1 删除'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='销售记录';
-- --------------------------------------------------------
--
-- 表的结构 `specialty`
--
CREATE TABLE `specialty` (
`specialty_id` int(11) NOT NULL COMMENT '专业ID',
`specialty_name` char(50) NOT NULL DEFAULT '' COMMENT '专业名称',
`name_first_letter` char(50) NOT NULL DEFAULT '' COMMENT '名称首字母',
`add_uid` int(11) NOT NULL DEFAULT 0 COMMENT '添加用户ID',
`add_time` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
`edit_uid` int(11) NOT NULL DEFAULT 0 COMMENT '编辑用户ID',
`edit_time` int(11) NOT NULL DEFAULT 0 COMMENT '编辑时间',
`is_del` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否删除:0 正常 1 删除'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='专业';
--
-- 转存表中的数据 `specialty`
--
INSERT INTO `specialty` (`specialty_id`, `specialty_name`, `name_first_letter`, `add_uid`, `add_time`, `edit_uid`, `edit_time`, `is_del`) VALUES
(1, '计算机', 'JSJ', 1, 1538633987, 1, 1538633987, 0),
(2, '法律', 'FL', 1, 1538634004, 1, 1538634004, 0),
(3, '医学', 'YX', 1, 1538634020, 1, 1538634020, 0),
(4, '金融', 'JR', 1, 1538634041, 1, 1538634041, 0),
(5, '幼师', 'YS', 1, 1538756819, 1, 1538756819, 0);
-- --------------------------------------------------------
--
-- 表的结构 `user`
--
CREATE TABLE `user` (
`user_id` int(11) NOT NULL COMMENT '用户ID',
`user_name` char(200) NOT NULL DEFAULT '' COMMENT '名称',
`nickname` char(50) NOT NULL DEFAULT '' COMMENT '昵称',
`reg_mobile` char(20) NOT NULL DEFAULT '' COMMENT '注册手机号',
`reg_email` char(100) NOT NULL DEFAULT '' COMMENT '注册邮箱',
`reg_source` tinyint(4) NOT NULL DEFAULT 0 COMMENT '注册来源:0 default 1 web 2 mobile 3 android 4 ios',
`reg_time` int(11) NOT NULL DEFAULT 0 COMMENT '注册时间',
`thirdparty_bind` tinyint(4) NOT NULL DEFAULT 0 COMMENT '第三方绑定登录:0 nil 1 weixin 2 qq 3 alipay 4 taobao 5 weibo ',
`login_password` char(255) NOT NULL DEFAULT '' COMMENT '登录密码',
`sex` tinyint(4) NOT NULL DEFAULT 0 COMMENT '性别:0 女 1 男 2 保密',
`birthdate` int(11) NOT NULL DEFAULT 0 COMMENT '出生日期',
`login_fail` tinyint(4) NOT NULL DEFAULT 0 COMMENT '登录失败次数:一天登录失败5次,就自动禁用登录账号',
`login_datetime` int(11) NOT NULL DEFAULT 0 COMMENT '登录日期',
`verify_code` char(100) NOT NULL DEFAULT '' COMMENT '验证码:短信,邮件',
`verify_type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '验证类型:0 短信 1 邮件',
`code_sendtime` int(11) NOT NULL DEFAULT 0 COMMENT '验证码发送时间',
`user_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '用户状态:0 禁用 1 激活',
`add_uid` int(11) NOT NULL DEFAULT 0 COMMENT '添加用户ID',
`add_time` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
`edit_uid` int(11) NOT NULL DEFAULT 0 COMMENT '编辑用户ID',
`edit_time` int(11) NOT NULL DEFAULT 0 COMMENT '编辑时间',
`is_del` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否删除:0 正常 1 删除',
`user_logo` char(255) NOT NULL DEFAULT '' COMMENT '用户头像',
`vip_level` tinyint(4) NOT NULL DEFAULT 0 COMMENT '会员等级:0 青铜 1 白银 2 黄金 3 铂金 4 黑金 33 创始人',
`user_type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '用户类型:0 会员 1 管理员',
`lecoin` bigint(20) NOT NULL DEFAULT 0 COMMENT '乐币',
`init_password` char(60) NOT NULL DEFAULT '' COMMENT '初始密码',
`init_password_change` tinyint(4) NOT NULL DEFAULT 0 COMMENT '初始密码更改:0 否 1 是'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户';
--
-- 转存表中的数据 `user`
--
INSERT INTO `user` (`user_id`, `user_name`, `nickname`, `reg_mobile`, `reg_email`, `reg_source`, `reg_time`, `thirdparty_bind`, `login_password`, `sex`, `birthdate`, `login_fail`, `login_datetime`, `verify_code`, `verify_type`, `code_sendtime`, `user_status`, `add_uid`, `add_time`, `edit_uid`, `edit_time`, `is_del`, `user_logo`, `vip_level`, `user_type`, `lecoin`, `init_password`, `init_password_change`) VALUES
(1, 'admin', 'admin', '13876888888', '', 0, 1537978643, 0, 'e10adc3949ba59abbe56e057f20f883e', 1, 0, 0, 1540998551, '', 0, 0, 1, 0, 0, 0, 0, 0, '', 33, 1, 0, '', 0);
-- --------------------------------------------------------
--
-- 表的结构 `work_aim`
--
CREATE TABLE `work_aim` (
`aim_id` int(11) NOT NULL COMMENT '目标ID',
`user_id` int(11) NOT NULL DEFAULT 0 COMMENT '用户ID',
`aim_name` char(200) NOT NULL DEFAULT '' COMMENT '目标名称',
`date_begin` int(11) NOT NULL DEFAULT 0 COMMENT '目标开始日期',
`date_end` int(11) NOT NULL DEFAULT 0 COMMENT '目标结束日期',
`realize_plan` text DEFAULT NULL COMMENT '目标实现计划',
`finish_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '完成状态:0 未完成 1 已完成',
`finish_summary` char(255) NOT NULL DEFAULT '' COMMENT '目标完成总结',
`add_uid` int(11) NOT NULL DEFAULT 0 COMMENT '添加用户ID',
`add_time` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
`edit_uid` int(11) NOT NULL DEFAULT 0 COMMENT '编辑用户ID',
`edit_time` int(11) NOT NULL DEFAULT 0 COMMENT '编辑时间',
`is_del` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否删除:0 正常 1 删除'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='目标';
-- --------------------------------------------------------
--
-- 表的结构 `work_position`
--
CREATE TABLE `work_position` (
`position_id` int(11) NOT NULL COMMENT '职位ID',
`position_name` char(50) NOT NULL DEFAULT '' COMMENT '职位名称',
`name_first_letter` char(50) NOT NULL DEFAULT '' COMMENT '名称首字母',
`add_uid` int(11) NOT NULL DEFAULT 0 COMMENT '添加用户ID',
`add_time` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
`edit_uid` int(11) NOT NULL DEFAULT 0 COMMENT '编辑用户ID',
`edit_time` int(11) NOT NULL DEFAULT 0 COMMENT '编辑时间',
`is_del` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否删除:0 正常 1 删除'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='工作职位';
--
-- 转存表中的数据 `work_position`
--
INSERT INTO `work_position` (`position_id`, `position_name`, `name_first_letter`, `add_uid`, `add_time`, `edit_uid`, `edit_time`, `is_del`) VALUES
(1, '董事长', 'DSZ', 1, 1538620244, 1, 1538620244, 0),
(2, '总经理', 'ZJL', 1, 1538621051, 1, 1538621051, 0),
(3, '财务总监', 'CWZJ', 1, 1538621235, 1, 1538621235, 0),
(4, '项目经理', 'XMJL', 1, 1538621260, 1, 1538621260, 0),
(5, '技术经理', 'JSJL', 1, 1538624005, 1, 1538624005, 0),
(6, '客户经理', 'KHJL', 1, 1538756751, 1, 1538756751, 0),
(7, '运营经理', 'YYJL', 1, 1538757497, 1, 1538757497, 0),
(8, '区域总监', 'QYZJ', 1, 1538819878, 1, 1538819878, 0);
-- --------------------------------------------------------
--
-- 表的结构 `work_post`
--
CREATE TABLE `work_post` (
`post_id` int(11) NOT NULL COMMENT '岗位ID',
`post_name` char(50) NOT NULL DEFAULT '' COMMENT '岗位名称',
`name_first_letter` char(50) NOT NULL DEFAULT '' COMMENT '名称首字母',
`add_uid` int(11) NOT NULL DEFAULT 0 COMMENT '添加用户ID',
`add_time` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
`edit_uid` int(11) NOT NULL DEFAULT 0 COMMENT '编辑用户ID',
`edit_time` int(11) NOT NULL DEFAULT 0 COMMENT '编辑时间',
`is_del` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否删除:0 正常 1 删除'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='工作岗位';
--
-- 转存表中的数据 `work_post`
--
INSERT INTO `work_post` (`post_id`, `post_name`, `name_first_letter`, `add_uid`, `add_time`, `edit_uid`, `edit_time`, `is_del`) VALUES
(1, 'PHP程序员', 'PHPCXY', 1, 1538623385, 1, 1538623385, 0),
(2, 'Java程序员', 'JAVACXY', 1, 1538623415, 1, 1538623415, 0),
(3, 'UI设计', 'UISJ', 1, 1538623721, 1, 1538623721, 0),
(4, '前端开发', 'QDKF', 1, 1538623746, 1, 1538623746, 0),
(5, 'iOS工程师', 'IOSGCS', 1, 1538623770, 1, 1538623770, 0),
(6, 'android工程师', 'AGCS', 1, 1538623790, 1, 1538623790, 0),
(7, '运维工程师', 'YWGCS', 1, 1538623851, 1, 1538623851, 0),
(8, '保险营销员', 'BXYXY', 1, 1538756789, 1, 1538756789, 0),
(9, '活动策划', 'HDCH', 1, 1538757541, 1, 1538757541, 0);
-- --------------------------------------------------------
--
-- 表的结构 `work_schedule`
--
CREATE TABLE `work_schedule` (
`schedule_id` int(11) NOT NULL COMMENT '日程ID',
`user_id` int(11) NOT NULL DEFAULT 0 COMMENT '用户ID',
`schedule_date` int(11) NOT NULL DEFAULT 0 COMMENT '日程日期',
`add_uid` int(11) NOT NULL DEFAULT 0 COMMENT '添加用户ID',
`add_time` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
`edit_uid` int(11) NOT NULL DEFAULT 0 COMMENT '编辑用户ID',
`edit_time` int(11) NOT NULL DEFAULT 0 COMMENT '编辑时间',
`is_del` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否删除:0 正常 1 删除'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='日程';
-- --------------------------------------------------------
--
-- 表的结构 `work_schedule_task`
--
CREATE TABLE `work_schedule_task` (
`task_id` int(11) NOT NULL COMMENT '日程任务ID',
`schedule_id` int(11) NOT NULL DEFAULT 0 COMMENT '日程ID',
`task_time` int(11) NOT NULL DEFAULT 0 COMMENT '任务时间',
`task_title` char(100) NOT NULL DEFAULT '' COMMENT '任务标题',
`task_content` varchar(2000) NOT NULL DEFAULT '' COMMENT '任务内容',
`task_level` tinyint(4) NOT NULL DEFAULT 0 COMMENT '任务级别:0 一般 1 重要 2 紧急',
`task_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '任务状态:0 未完成 1 已完成',
`is_del` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否删除:0 正常 1 删除'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='日程任务';
--
-- 转储表的索引
--
--
-- 表的索引 `crm_clue`
--
ALTER TABLE `crm_clue`
ADD PRIMARY KEY (`clue_id`);
--
-- 表的索引 `crm_customer`
--
ALTER TABLE `crm_customer`
ADD PRIMARY KEY (`customer_id`);
--
-- 表的索引 `crm_follow`
--
ALTER TABLE `crm_follow`
ADD PRIMARY KEY (`follow_id`);
--
-- 表的索引 `flow_info`
--
ALTER TABLE `flow_info`
ADD PRIMARY KEY (`info_id`);
--
-- 表的索引 `industry`
--
ALTER TABLE `industry`
ADD PRIMARY KEY (`industry_id`);
--
-- 表的索引 `message`
--
ALTER TABLE `message`
ADD PRIMARY KEY (`msg_id`);
--
-- 表的索引 `my_insurance`
--
ALTER TABLE `my_insurance`
ADD PRIMARY KEY (`insurance_id`);
--
-- 表的索引 `my_talk_script`
--
ALTER TABLE `my_talk_script`
ADD PRIMARY KEY (`script_id`);
--
-- 表的索引 `province_city`
--
ALTER TABLE `province_city`
ADD PRIMARY KEY (`pcity_id`);
--
-- 表的索引 `school`
--
ALTER TABLE `school`
ADD PRIMARY KEY (`school_id`);
--
-- 表的索引 `sell_flow`
--
ALTER TABLE `sell_flow`
ADD PRIMARY KEY (`customer_id`);
--
-- 表的索引 `sell_record`
--
ALTER TABLE `sell_record`
ADD PRIMARY KEY (`record_id`);
--
-- 表的索引 `specialty`
--
ALTER TABLE `specialty`
ADD PRIMARY KEY (`specialty_id`);
--
-- 表的索引 `user`
--
ALTER TABLE `user`
ADD PRIMARY KEY (`user_id`);
--
-- 表的索引 `work_aim`
--
ALTER TABLE `work_aim`
ADD PRIMARY KEY (`aim_id`);
--
-- 表的索引 `work_position`
--
ALTER TABLE `work_position`
ADD PRIMARY KEY (`position_id`);
--
-- 表的索引 `work_post`
--
ALTER TABLE `work_post`
ADD PRIMARY KEY (`post_id`);
--
-- 表的索引 `work_schedule`
--
ALTER TABLE `work_schedule`
ADD PRIMARY KEY (`schedule_id`);
--
-- 表的索引 `work_schedule_task`
--
ALTER TABLE `work_schedule_task`
ADD PRIMARY KEY (`task_id`);
--
-- 在导出的表使用AUTO_INCREMENT
--
--
-- 使用表AUTO_INCREMENT `crm_clue`
--
ALTER TABLE `crm_clue`
MODIFY `clue_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '线索ID';
--
-- 使用表AUTO_INCREMENT `crm_customer`
--
ALTER TABLE `crm_customer`
MODIFY `customer_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '客户ID';
--
-- 使用表AUTO_INCREMENT `crm_follow`
--
ALTER TABLE `crm_follow`
MODIFY `follow_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '跟进ID';
--
-- 使用表AUTO_INCREMENT `flow_info`
--
ALTER TABLE `flow_info`
MODIFY `info_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '统计ID', AUTO_INCREMENT=94;
--
-- 使用表AUTO_INCREMENT `industry`
--
ALTER TABLE `industry`
MODIFY `industry_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '行业ID', AUTO_INCREMENT=11;
--
-- 使用表AUTO_INCREMENT `message`
--
ALTER TABLE `message`
MODIFY `msg_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '消息ID';
--
-- 使用表AUTO_INCREMENT `my_insurance`
--
ALTER TABLE `my_insurance`
MODIFY `insurance_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '保险单ID';
--
-- 使用表AUTO_INCREMENT `my_talk_script`
--
ALTER TABLE `my_talk_script`
MODIFY `script_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '话术ID';
--
-- 使用表AUTO_INCREMENT `province_city`
--
ALTER TABLE `province_city`
MODIFY `pcity_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '省份城市ID', AUTO_INCREMENT=18375;
--
-- 使用表AUTO_INCREMENT `school`
--
ALTER TABLE `school`
MODIFY `school_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '学校ID', AUTO_INCREMENT=7;
--
-- 使用表AUTO_INCREMENT `sell_record`
--
ALTER TABLE `sell_record`
MODIFY `record_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '销售记录ID';
--
-- 使用表AUTO_INCREMENT `specialty`
--
ALTER TABLE `specialty`
MODIFY `specialty_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '专业ID', AUTO_INCREMENT=6;
--
-- 使用表AUTO_INCREMENT `user`
--
ALTER TABLE `user`
MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户ID', AUTO_INCREMENT=66;
--
-- 使用表AUTO_INCREMENT `work_aim`
--
ALTER TABLE `work_aim`
MODIFY `aim_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '目标ID';
--
-- 使用表AUTO_INCREMENT `work_position`
--
ALTER TABLE `work_position`
MODIFY `position_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '职位ID', AUTO_INCREMENT=9;
--
-- 使用表AUTO_INCREMENT `work_post`
--
ALTER TABLE `work_post`
MODIFY `post_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '岗位ID', AUTO_INCREMENT=10;
--
-- 使用表AUTO_INCREMENT `work_schedule`
--
ALTER TABLE `work_schedule`
MODIFY `schedule_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '日程ID';
--
-- 使用表AUTO_INCREMENT `work_schedule_task`
--
ALTER TABLE `work_schedule_task`
MODIFY `task_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '日程任务ID';
COMMIT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
PHP
1
https://gitee.com/mcjeremy/letucrm.git
git@gitee.com:mcjeremy/letucrm.git
mcjeremy
letucrm
letucrm
master

搜索帮助