1 Star 0 Fork 78

为完成 / IDEMaker-php开源订餐系统

Create your Gitee Account
Explore and code with more than 6 million developers,Free private repositories !:)
Sign up
This repository doesn't specify license. Without author's permission, this code is only for learning and cannot be used for other purposes.
Clone or download
oam.sql 299.10 KB
Copy Edit Web IDE Raw Blame History
IDEMaker authored 2017-12-05 10:40 . 添加数据库sql文件
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511251225132514251525162517251825192520252125222523252425252526252725282529253025312532253325342535253625372538253925402541254225432544254525462547254825492550255125522553255425552556255725582559256025612562256325642565256625672568256925702571257225732574257525762577257825792580258125822583258425852586258725882589259025912592259325942595259625972598259926002601260226032604260526062607260826092610261126122613261426152616261726182619262026212622262326242625262626272628262926302631263226332634263526362637263826392640264126422643264426452646264726482649265026512652265326542655265626572658265926602661266226632664266526662667266826692670267126722673267426752676267726782679268026812682268326842685268626872688268926902691269226932694269526962697269826992700270127022703270427052706270727082709271027112712271327142715271627172718271927202721272227232724272527262727272827292730273127322733273427352736273727382739274027412742274327442745274627472748274927502751275227532754275527562757275827592760276127622763276427652766276727682769277027712772277327742775277627772778277927802781278227832784278527862787278827892790279127922793279427952796279727982799280028012802280328042805280628072808280928102811281228132814281528162817281828192820282128222823282428252826282728282829283028312832283328342835283628372838283928402841284228432844284528462847284828492850285128522853285428552856285728582859286028612862286328642865286628672868286928702871287228732874287528762877287828792880288128822883288428852886288728882889289028912892289328942895289628972898289929002901290229032904290529062907290829092910291129122913291429152916291729182919292029212922292329242925292629272928292929302931293229332934293529362937293829392940294129422943294429452946294729482949295029512952295329542955295629572958295929602961296229632964296529662967296829692970297129722973297429752976297729782979298029812982298329842985298629872988298929902991299229932994299529962997299829993000300130023003300430053006300730083009301030113012301330143015301630173018301930203021302230233024302530263027302830293030303130323033303430353036303730383039304030413042304330443045304630473048304930503051305230533054305530563057305830593060306130623063306430653066306730683069307030713072307330743075307630773078307930803081308230833084308530863087308830893090309130923093309430953096309730983099310031013102310331043105310631073108310931103111311231133114311531163117311831193120312131223123312431253126312731283129313031313132313331343135313631373138313931403141314231433144314531463147314831493150315131523153315431553156315731583159316031613162316331643165316631673168316931703171317231733174317531763177317831793180318131823183318431853186318731883189319031913192319331943195319631973198319932003201320232033204320532063207320832093210321132123213321432153216321732183219322032213222322332243225322632273228322932303231323232333234323532363237323832393240324132423243324432453246324732483249325032513252325332543255325632573258325932603261326232633264326532663267326832693270327132723273327432753276327732783279328032813282328332843285328632873288328932903291329232933294329532963297329832993300330133023303330433053306330733083309331033113312331333143315331633173318331933203321332233233324332533263327332833293330333133323333333433353336333733383339334033413342334333443345334633473348334933503351335233533354335533563357335833593360336133623363336433653366336733683369337033713372337333743375337633773378337933803381338233833384338533863387338833893390339133923393339433953396339733983399340034013402340334043405340634073408340934103411341234133414341534163417341834193420342134223423342434253426342734283429343034313432343334343435343634373438343934403441344234433444344534463447344834493450345134523453345434553456345734583459346034613462346334643465346634673468346934703471347234733474347534763477347834793480348134823483348434853486348734883489349034913492349334943495349634973498349935003501350235033504350535063507350835093510351135123513351435153516351735183519352035213522352335243525352635273528352935303531353235333534353535363537353835393540354135423543354435453546354735483549355035513552355335543555355635573558355935603561356235633564356535663567356835693570357135723573357435753576357735783579358035813582358335843585358635873588358935903591359235933594359535963597359835993600360136023603360436053606360736083609361036113612361336143615361636173618361936203621362236233624362536263627362836293630363136323633363436353636363736383639364036413642364336443645364636473648364936503651365236533654365536563657365836593660366136623663366436653666366736683669367036713672367336743675367636773678367936803681368236833684368536863687368836893690369136923693369436953696369736983699370037013702370337043705370637073708370937103711371237133714371537163717371837193720372137223723372437253726372737283729373037313732373337343735373637373738373937403741374237433744374537463747374837493750375137523753375437553756375737583759376037613762376337643765376637673768376937703771377237733774377537763777377837793780378137823783378437853786378737883789379037913792379337943795379637973798379938003801380238033804380538063807380838093810381138123813381438153816381738183819382038213822382338243825382638273828382938303831383238333834383538363837383838393840384138423843384438453846384738483849385038513852385338543855385638573858385938603861386238633864386538663867386838693870387138723873387438753876387738783879388038813882388338843885388638873888388938903891389238933894389538963897389838993900390139023903390439053906390739083909391039113912391339143915391639173918391939203921392239233924392539263927392839293930393139323933393439353936393739383939394039413942394339443945394639473948394939503951395239533954395539563957395839593960396139623963396439653966396739683969397039713972397339743975397639773978397939803981398239833984398539863987398839893990399139923993399439953996399739983999400040014002400340044005400640074008400940104011401240134014401540164017401840194020402140224023402440254026402740284029403040314032403340344035403640374038403940404041404240434044404540464047404840494050405140524053405440554056405740584059406040614062406340644065406640674068406940704071407240734074407540764077407840794080408140824083408440854086408740884089409040914092409340944095409640974098409941004101410241034104410541064107410841094110411141124113411441154116411741184119412041214122412341244125412641274128412941304131413241334134413541364137413841394140414141424143414441454146414741484149415041514152415341544155415641574158415941604161416241634164416541664167416841694170417141724173417441754176417741784179418041814182418341844185418641874188418941904191419241934194419541964197419841994200420142024203420442054206420742084209421042114212421342144215421642174218421942204221422242234224422542264227422842294230423142324233423442354236423742384239424042414242424342444245424642474248424942504251425242534254425542564257425842594260426142624263426442654266426742684269427042714272427342744275427642774278427942804281428242834284428542864287428842894290429142924293429442954296429742984299430043014302430343044305430643074308430943104311431243134314431543164317431843194320432143224323432443254326432743284329433043314332433343344335433643374338433943404341434243434344434543464347434843494350
/*
Navicat MySQL Data Transfer
Source Server : 呵呵
Source Server Version : 50547
Source Host : localhost:3306
Source Database : oam
Target Server Type : MYSQL
Target Server Version : 50547
File Encoding : 65001
Date: 2017-12-02 17:35:35
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for dfz_admin
-- ----------------------------
DROP TABLE IF EXISTS `dfz_admin`;
CREATE TABLE `dfz_admin` (
`id` int(5) NOT NULL AUTO_INCREMENT,
`username` varchar(30) DEFAULT NULL,
`password` varchar(32) DEFAULT NULL,
`email` varchar(40) DEFAULT NULL,
`shopPhone` varchar(15) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of dfz_admin
-- ----------------------------
INSERT INTO `dfz_admin` VALUES ('11', 'admin', '21232f297a57a5a743894a0e4a801fc3', '80252797@qq.com', '18710051929');
INSERT INTO `dfz_admin` VALUES ('64', 'shop1001', 'b8c37e33defde51cf91e1e03e51657da', null, '17600361387');
-- ----------------------------
-- Table structure for dfz_advice
-- ----------------------------
DROP TABLE IF EXISTS `dfz_advice`;
CREATE TABLE `dfz_advice` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`advice` varchar(150) DEFAULT NULL,
`username` varchar(20) DEFAULT NULL,
`time` varchar(13) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of dfz_advice
-- ----------------------------
-- ----------------------------
-- Table structure for dfz_areas
-- ----------------------------
DROP TABLE IF EXISTS `dfz_areas`;
CREATE TABLE `dfz_areas` (
`region_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`parent_id` smallint(5) unsigned NOT NULL DEFAULT '0',
`region_name` varchar(120) NOT NULL DEFAULT '',
`region_type` tinyint(1) NOT NULL DEFAULT '2',
`agency_id` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`region_id`),
KEY `parent_id` (`parent_id`),
KEY `region_type` (`region_type`),
KEY `agency_id` (`agency_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4045 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of dfz_areas
-- ----------------------------
INSERT INTO `dfz_areas` VALUES ('1', '0', '中国', '0', '0');
INSERT INTO `dfz_areas` VALUES ('2', '1', '北京', '1', '0');
INSERT INTO `dfz_areas` VALUES ('3', '1', '天津', '1', '0');
INSERT INTO `dfz_areas` VALUES ('4', '1', '河北省', '1', '0');
INSERT INTO `dfz_areas` VALUES ('5', '1', '山西省', '1', '0');
INSERT INTO `dfz_areas` VALUES ('6', '1', '内蒙古自治区', '1', '0');
INSERT INTO `dfz_areas` VALUES ('7', '1', '辽宁省', '1', '0');
INSERT INTO `dfz_areas` VALUES ('8', '1', '吉林省', '1', '0');
INSERT INTO `dfz_areas` VALUES ('9', '1', '黑龙江省', '1', '0');
INSERT INTO `dfz_areas` VALUES ('10', '1', '上海', '1', '0');
INSERT INTO `dfz_areas` VALUES ('11', '1', '江苏省', '1', '0');
INSERT INTO `dfz_areas` VALUES ('12', '1', '浙江省', '1', '0');
INSERT INTO `dfz_areas` VALUES ('13', '1', '安徽省', '1', '0');
INSERT INTO `dfz_areas` VALUES ('14', '1', '福建省', '1', '0');
INSERT INTO `dfz_areas` VALUES ('15', '1', '江西省', '1', '0');
INSERT INTO `dfz_areas` VALUES ('16', '1', '山东省', '1', '0');
INSERT INTO `dfz_areas` VALUES ('17', '1', '河南省', '1', '0');
INSERT INTO `dfz_areas` VALUES ('18', '1', '湖北省', '1', '0');
INSERT INTO `dfz_areas` VALUES ('19', '1', '湖南省', '1', '0');
INSERT INTO `dfz_areas` VALUES ('20', '1', '广东省', '1', '0');
INSERT INTO `dfz_areas` VALUES ('21', '1', '广西壮族自治区', '1', '0');
INSERT INTO `dfz_areas` VALUES ('22', '1', '海南省', '1', '0');
INSERT INTO `dfz_areas` VALUES ('23', '1', '重庆', '1', '0');
INSERT INTO `dfz_areas` VALUES ('24', '1', '四川省', '1', '0');
INSERT INTO `dfz_areas` VALUES ('25', '1', '贵州省', '1', '0');
INSERT INTO `dfz_areas` VALUES ('26', '1', '云南省', '1', '0');
INSERT INTO `dfz_areas` VALUES ('27', '1', '西藏自治区', '1', '0');
INSERT INTO `dfz_areas` VALUES ('28', '1', '陕西省', '1', '0');
INSERT INTO `dfz_areas` VALUES ('29', '1', '甘肃省', '1', '0');
INSERT INTO `dfz_areas` VALUES ('30', '1', '青海省', '1', '0');
INSERT INTO `dfz_areas` VALUES ('31', '1', '宁夏回族自治区', '1', '0');
INSERT INTO `dfz_areas` VALUES ('32', '1', '新疆维吾尔自治区', '1', '0');
INSERT INTO `dfz_areas` VALUES ('33', '1', '台湾', '1', '0');
INSERT INTO `dfz_areas` VALUES ('34', '1', '香港特别行政区', '1', '0');
INSERT INTO `dfz_areas` VALUES ('35', '1', '澳门特别行政区', '1', '0');
INSERT INTO `dfz_areas` VALUES ('36', '1', '海外', '1', '0');
INSERT INTO `dfz_areas` VALUES ('37', '2', '北京市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('38', '3', '天津市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('39', '4', '石家庄市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('40', '4', '唐山市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('41', '4', '秦皇岛市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('42', '4', '邯郸市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('43', '4', '邢台市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('44', '4', '保定市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('45', '4', '张家口市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('46', '4', '承德市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('47', '4', '沧州市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('48', '4', '廊坊市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('49', '4', '衡水市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('50', '5', '太原市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('51', '5', '大同市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('52', '5', '阳泉市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('53', '5', '长治市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('54', '5', '晋城市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('55', '5', '朔州市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('56', '5', '晋中市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('57', '5', '运城市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('58', '5', '忻州市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('59', '5', '临汾市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('60', '5', '吕梁市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('61', '6', '呼和浩特市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('62', '6', '包头市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('63', '6', '乌海市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('64', '6', '赤峰市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('65', '6', '通辽市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('66', '6', '鄂尔多斯市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('67', '6', '呼伦贝尔市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('68', '6', '巴彦淖尔市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('69', '6', '乌兰察布市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('70', '6', '兴安盟', '2', '0');
INSERT INTO `dfz_areas` VALUES ('71', '6', '锡林郭勒盟', '2', '0');
INSERT INTO `dfz_areas` VALUES ('72', '6', '阿拉善盟', '2', '0');
INSERT INTO `dfz_areas` VALUES ('73', '7', '沈阳市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('74', '7', '大连市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('75', '7', '鞍山市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('76', '7', '抚顺市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('77', '7', '本溪市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('78', '7', '丹东市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('79', '7', '锦州市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('80', '7', '营口市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('81', '7', '阜新市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('82', '7', '辽阳市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('83', '7', '盘锦市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('84', '7', '铁岭市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('85', '7', '朝阳市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('86', '7', '葫芦岛市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('87', '8', '长春市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('88', '8', '吉林市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('89', '8', '四平市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('90', '8', '辽源市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('91', '8', '通化市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('92', '8', '白山市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('93', '8', '松原市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('94', '8', '白城市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('95', '8', '延边朝鲜族自治州', '2', '0');
INSERT INTO `dfz_areas` VALUES ('96', '9', '哈尔滨市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('97', '9', '齐齐哈尔市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('98', '9', '鸡西市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('99', '9', '鹤岗市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('100', '9', '双鸭山市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('101', '9', '大庆市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('102', '9', '伊春市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('103', '9', '佳木斯市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('104', '9', '七台河市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('105', '9', '牡丹江市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('106', '9', '黑河市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('107', '9', '绥化市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('108', '9', '大兴安岭地区', '2', '0');
INSERT INTO `dfz_areas` VALUES ('109', '10', '上海市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('110', '11', '南京市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('111', '11', '无锡市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('112', '11', '徐州市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('113', '11', '常州市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('114', '11', '苏州市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('115', '11', '南通市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('116', '11', '连云港市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('117', '11', '淮安市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('118', '11', '盐城市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('119', '11', '扬州市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('120', '11', '镇江市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('121', '11', '泰州市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('122', '11', '宿迁市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('123', '12', '杭州市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('124', '12', '宁波市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('125', '12', '温州市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('126', '12', '嘉兴市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('127', '12', '湖州市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('128', '12', '绍兴市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('129', '12', '金华市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('130', '12', '衢州市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('131', '12', '舟山市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('132', '12', '台州市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('133', '12', '丽水市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('134', '13', '合肥市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('135', '13', '芜湖市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('136', '13', '蚌埠市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('137', '13', '淮南市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('138', '13', '马鞍山市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('139', '13', '淮北市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('140', '13', '铜陵市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('141', '13', '安庆市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('142', '13', '黄山市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('143', '13', '滁州市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('144', '13', '阜阳市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('145', '13', '宿州市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('146', '13', '六安市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('147', '13', '亳州市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('148', '13', '池州市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('149', '13', '宣城市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('150', '14', '福州市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('151', '14', '厦门市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('152', '14', '莆田市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('153', '14', '三明市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('154', '14', '泉州市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('155', '14', '漳州市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('156', '14', '南平市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('157', '14', '龙岩市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('158', '14', '宁德市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('159', '15', '南昌市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('160', '15', '景德镇市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('161', '15', '萍乡市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('162', '15', '九江市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('163', '15', '新余市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('164', '15', '鹰潭市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('165', '15', '赣州市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('166', '15', '吉安市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('167', '15', '宜春市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('168', '15', '抚州市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('169', '15', '上饶市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('170', '16', '济南市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('171', '16', '青岛市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('172', '16', '淄博市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('173', '16', '枣庄市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('174', '16', '东营市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('175', '16', '烟台市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('176', '16', '潍坊市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('177', '16', '济宁市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('178', '16', '泰安市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('179', '16', '威海市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('180', '16', '日照市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('181', '16', '莱芜市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('182', '16', '临沂市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('183', '16', '德州市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('184', '16', '聊城市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('185', '16', '滨州市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('186', '16', '菏泽市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('187', '17', '郑州市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('188', '17', '开封市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('189', '17', '洛阳市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('190', '17', '平顶山市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('191', '17', '安阳市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('192', '17', '鹤壁市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('193', '17', '新乡市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('194', '17', '焦作市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('195', '17', '濮阳市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('196', '17', '许昌市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('197', '17', '漯河市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('198', '17', '三门峡市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('199', '17', '南阳市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('200', '17', '商丘市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('201', '17', '信阳市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('202', '17', '周口市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('203', '17', '驻马店市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('204', '18', '武汉市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('205', '18', '黄石市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('206', '18', '十堰市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('207', '18', '宜昌市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('208', '18', '襄阳市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('209', '18', '鄂州市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('210', '18', '荆门市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('211', '18', '孝感市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('212', '18', '荆州市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('213', '18', '黄冈市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('214', '18', '咸宁市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('215', '18', '随州市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('216', '18', '恩施土家族苗族自治州', '2', '0');
INSERT INTO `dfz_areas` VALUES ('217', '19', '长沙市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('218', '19', '株洲市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('219', '19', '湘潭市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('220', '19', '衡阳市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('221', '19', '邵阳市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('222', '19', '岳阳市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('223', '19', '常德市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('224', '19', '张家界市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('225', '19', '益阳市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('226', '19', '郴州市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('227', '19', '永州市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('228', '19', '怀化市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('229', '19', '娄底市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('230', '19', '湘西土家族苗族自治州', '2', '0');
INSERT INTO `dfz_areas` VALUES ('231', '20', '广州市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('232', '20', '韶关市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('233', '20', '深圳市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('234', '20', '珠海市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('235', '20', '汕头市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('236', '20', '佛山市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('237', '20', '江门市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('238', '20', '湛江市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('239', '20', '茂名市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('240', '20', '肇庆市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('241', '20', '惠州市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('242', '20', '梅州市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('243', '20', '汕尾市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('244', '20', '河源市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('245', '20', '阳江市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('246', '20', '清远市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('247', '20', '东莞市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('248', '20', '中山市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('249', '20', '东沙群岛', '2', '0');
INSERT INTO `dfz_areas` VALUES ('250', '20', '潮州市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('251', '20', '揭阳市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('252', '20', '云浮市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('253', '21', '南宁市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('254', '21', '柳州市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('255', '21', '桂林市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('256', '21', '梧州市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('257', '21', '北海市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('258', '21', '防城港市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('259', '21', '钦州市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('260', '21', '贵港市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('261', '21', '玉林市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('262', '21', '百色市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('263', '21', '贺州市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('264', '21', '河池市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('265', '21', '来宾市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('266', '21', '崇左市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('267', '22', '海口市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('268', '22', '三亚市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('269', '22', '三沙市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('270', '23', '重庆市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('271', '24', '成都市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('272', '24', '自贡市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('273', '24', '攀枝花市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('274', '24', '泸州市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('275', '24', '德阳市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('276', '24', '绵阳市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('277', '24', '广元市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('278', '24', '遂宁市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('279', '24', '内江市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('280', '24', '乐山市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('281', '24', '南充市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('282', '24', '眉山市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('283', '24', '宜宾市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('284', '24', '广安市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('285', '24', '达州市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('286', '24', '雅安市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('287', '24', '巴中市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('288', '24', '资阳市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('289', '24', '阿坝藏族羌族自治州', '2', '0');
INSERT INTO `dfz_areas` VALUES ('290', '24', '甘孜藏族自治州', '2', '0');
INSERT INTO `dfz_areas` VALUES ('291', '24', '凉山彝族自治州', '2', '0');
INSERT INTO `dfz_areas` VALUES ('292', '25', '贵阳市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('293', '25', '六盘水市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('294', '25', '遵义市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('295', '25', '安顺市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('296', '25', '铜仁市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('297', '25', '黔西南布依族苗族自治州', '2', '0');
INSERT INTO `dfz_areas` VALUES ('298', '25', '毕节市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('299', '25', '黔东南苗族侗族自治州', '2', '0');
INSERT INTO `dfz_areas` VALUES ('300', '25', '黔南布依族苗族自治州', '2', '0');
INSERT INTO `dfz_areas` VALUES ('301', '26', '昆明市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('302', '26', '曲靖市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('303', '26', '玉溪市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('304', '26', '保山市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('305', '26', '昭通市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('306', '26', '丽江市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('307', '26', '普洱市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('308', '26', '临沧市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('309', '26', '楚雄彝族自治州', '2', '0');
INSERT INTO `dfz_areas` VALUES ('310', '26', '红河哈尼族彝族自治州', '2', '0');
INSERT INTO `dfz_areas` VALUES ('311', '26', '文山壮族苗族自治州', '2', '0');
INSERT INTO `dfz_areas` VALUES ('312', '26', '西双版纳傣族自治州', '2', '0');
INSERT INTO `dfz_areas` VALUES ('313', '26', '大理白族自治州', '2', '0');
INSERT INTO `dfz_areas` VALUES ('314', '26', '德宏傣族景颇族自治州', '2', '0');
INSERT INTO `dfz_areas` VALUES ('315', '26', '怒江傈僳族自治州', '2', '0');
INSERT INTO `dfz_areas` VALUES ('316', '26', '迪庆藏族自治州', '2', '0');
INSERT INTO `dfz_areas` VALUES ('317', '27', '拉萨市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('318', '27', '昌都市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('319', '27', '山南地区', '2', '0');
INSERT INTO `dfz_areas` VALUES ('320', '27', '日喀则市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('321', '27', '那曲地区', '2', '0');
INSERT INTO `dfz_areas` VALUES ('322', '27', '阿里地区', '2', '0');
INSERT INTO `dfz_areas` VALUES ('323', '27', '林芝市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('324', '28', '西安市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('325', '28', '铜川市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('326', '28', '宝鸡市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('327', '28', '咸阳市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('328', '28', '渭南市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('329', '28', '延安市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('330', '28', '汉中市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('331', '28', '榆林市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('332', '28', '安康市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('333', '28', '商洛市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('334', '29', '兰州市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('335', '29', '嘉峪关市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('336', '29', '金昌市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('337', '29', '白银市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('338', '29', '天水市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('339', '29', '武威市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('340', '29', '张掖市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('341', '29', '平凉市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('342', '29', '酒泉市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('343', '29', '庆阳市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('344', '29', '定西市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('345', '29', '陇南市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('346', '29', '临夏回族自治州', '2', '0');
INSERT INTO `dfz_areas` VALUES ('347', '29', '甘南藏族自治州', '2', '0');
INSERT INTO `dfz_areas` VALUES ('348', '30', '西宁市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('349', '30', '海东市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('350', '30', '海北藏族自治州', '2', '0');
INSERT INTO `dfz_areas` VALUES ('351', '30', '黄南藏族自治州', '2', '0');
INSERT INTO `dfz_areas` VALUES ('352', '30', '海南藏族自治州', '2', '0');
INSERT INTO `dfz_areas` VALUES ('353', '30', '果洛藏族自治州', '2', '0');
INSERT INTO `dfz_areas` VALUES ('354', '30', '玉树藏族自治州', '2', '0');
INSERT INTO `dfz_areas` VALUES ('355', '30', '海西蒙古族藏族自治州', '2', '0');
INSERT INTO `dfz_areas` VALUES ('356', '31', '银川市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('357', '31', '石嘴山市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('358', '31', '吴忠市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('359', '31', '固原市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('360', '31', '中卫市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('361', '32', '乌鲁木齐市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('362', '32', '克拉玛依市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('363', '32', '吐鲁番市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('364', '32', '哈密地区', '2', '0');
INSERT INTO `dfz_areas` VALUES ('365', '32', '昌吉回族自治州', '2', '0');
INSERT INTO `dfz_areas` VALUES ('366', '32', '博尔塔拉蒙古自治州', '2', '0');
INSERT INTO `dfz_areas` VALUES ('367', '32', '巴音郭楞蒙古自治州', '2', '0');
INSERT INTO `dfz_areas` VALUES ('368', '32', '阿克苏地区', '2', '0');
INSERT INTO `dfz_areas` VALUES ('369', '32', '克孜勒苏柯尔克孜自治州', '2', '0');
INSERT INTO `dfz_areas` VALUES ('370', '32', '喀什地区', '2', '0');
INSERT INTO `dfz_areas` VALUES ('371', '32', '和田地区', '2', '0');
INSERT INTO `dfz_areas` VALUES ('372', '32', '伊犁哈萨克自治州', '2', '0');
INSERT INTO `dfz_areas` VALUES ('373', '32', '塔城地区', '2', '0');
INSERT INTO `dfz_areas` VALUES ('374', '32', '阿勒泰地区', '2', '0');
INSERT INTO `dfz_areas` VALUES ('375', '33', '台北市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('376', '33', '高雄市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('377', '33', '台南市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('378', '33', '台中市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('379', '33', '金门县', '2', '0');
INSERT INTO `dfz_areas` VALUES ('380', '33', '南投县', '2', '0');
INSERT INTO `dfz_areas` VALUES ('381', '33', '基隆市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('382', '33', '新竹市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('383', '33', '嘉义市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('384', '33', '新北市', '2', '0');
INSERT INTO `dfz_areas` VALUES ('385', '33', '宜兰县', '2', '0');
INSERT INTO `dfz_areas` VALUES ('386', '33', '新竹县', '2', '0');
INSERT INTO `dfz_areas` VALUES ('387', '33', '桃园县', '2', '0');
INSERT INTO `dfz_areas` VALUES ('388', '33', '苗栗县', '2', '0');
INSERT INTO `dfz_areas` VALUES ('389', '33', '彰化县', '2', '0');
INSERT INTO `dfz_areas` VALUES ('390', '33', '嘉义县', '2', '0');
INSERT INTO `dfz_areas` VALUES ('391', '33', '云林县', '2', '0');
INSERT INTO `dfz_areas` VALUES ('392', '33', '屏东县', '2', '0');
INSERT INTO `dfz_areas` VALUES ('393', '33', '台东县', '2', '0');
INSERT INTO `dfz_areas` VALUES ('394', '33', '花莲县', '2', '0');
INSERT INTO `dfz_areas` VALUES ('395', '33', '澎湖县', '2', '0');
INSERT INTO `dfz_areas` VALUES ('396', '33', '连江县', '2', '0');
INSERT INTO `dfz_areas` VALUES ('397', '34', '香港岛', '2', '0');
INSERT INTO `dfz_areas` VALUES ('398', '34', '九龙', '2', '0');
INSERT INTO `dfz_areas` VALUES ('399', '34', '新界', '2', '0');
INSERT INTO `dfz_areas` VALUES ('400', '35', '澳门半岛', '2', '0');
INSERT INTO `dfz_areas` VALUES ('401', '35', '离岛', '2', '0');
INSERT INTO `dfz_areas` VALUES ('402', '36', '海外', '2', '0');
INSERT INTO `dfz_areas` VALUES ('403', '37', '东城区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('404', '37', '西城区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('405', '37', '崇文区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('406', '37', '宣武区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('407', '37', '朝阳区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('408', '37', '丰台区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('409', '37', '石景山区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('410', '37', '海淀区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('411', '37', '门头沟区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('412', '37', '房山区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('413', '37', '通州区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('414', '37', '顺义区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('415', '37', '昌平区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('416', '37', '大兴区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('417', '37', '怀柔区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('418', '37', '平谷区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('419', '37', '密云县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('420', '37', '延庆县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('421', '37', '其它区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('422', '38', '和平区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('423', '38', '河东区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('424', '38', '河西区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('425', '38', '南开区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('426', '38', '河北区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('427', '38', '红桥区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('428', '38', '塘沽区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('429', '38', '汉沽区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('430', '38', '大港区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('431', '38', '东丽区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('432', '38', '西青区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('433', '38', '津南区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('434', '38', '北辰区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('435', '38', '武清区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('436', '38', '宝坻区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('437', '38', '滨海新区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('438', '38', '宁河县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('439', '38', '静海县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('440', '38', '蓟县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('441', '38', '其它区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('442', '39', '长安区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('443', '39', '桥东区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('444', '39', '桥西区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('445', '39', '新华区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('446', '39', '井陉矿区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('447', '39', '裕华区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('448', '39', '井陉县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('449', '39', '正定县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('450', '39', '栾城区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('451', '39', '行唐县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('452', '39', '灵寿县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('453', '39', '高邑县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('454', '39', '深泽县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('455', '39', '赞皇县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('456', '39', '无极县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('457', '39', '平山县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('458', '39', '元氏县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('459', '39', '赵县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('460', '39', '辛集市', '3', '0');
INSERT INTO `dfz_areas` VALUES ('461', '39', '藁城区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('462', '39', '晋州市', '3', '0');
INSERT INTO `dfz_areas` VALUES ('463', '39', '新乐市', '3', '0');
INSERT INTO `dfz_areas` VALUES ('464', '39', '鹿泉区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('465', '39', '其它区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('466', '40', '路南区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('467', '40', '路北区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('468', '40', '古冶区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('469', '40', '开平区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('470', '40', '丰南区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('471', '40', '丰润区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('472', '40', '滦县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('473', '40', '滦南县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('474', '40', '乐亭县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('475', '40', '迁西县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('476', '40', '玉田县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('477', '40', '曹妃甸区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('478', '40', '遵化市', '3', '0');
INSERT INTO `dfz_areas` VALUES ('479', '40', '迁安市', '3', '0');
INSERT INTO `dfz_areas` VALUES ('480', '40', '其它区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('481', '41', '海港区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('482', '41', '山海关区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('483', '41', '北戴河区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('484', '41', '青龙满族自治县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('485', '41', '昌黎县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('486', '41', '抚宁县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('487', '41', '卢龙县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('488', '41', '其它区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('489', '41', '经济技术开发区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('490', '42', '邯山区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('491', '42', '丛台区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('492', '42', '复兴区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('493', '42', '峰峰矿区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('494', '42', '邯郸县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('495', '42', '临漳县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('496', '42', '成安县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('497', '42', '大名县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('498', '42', '涉县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('499', '42', '磁县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('500', '42', '肥乡县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('501', '42', '永年县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('502', '42', '邱县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('503', '42', '鸡泽县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('504', '42', '广平县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('505', '42', '馆陶县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('506', '42', '魏县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('507', '42', '曲周县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('508', '42', '武安市', '3', '0');
INSERT INTO `dfz_areas` VALUES ('509', '42', '其它区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('510', '43', '桥东区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('511', '43', '桥西区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('512', '43', '邢台县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('513', '43', '临城县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('514', '43', '内丘县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('515', '43', '柏乡县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('516', '43', '隆尧县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('517', '43', '任县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('518', '43', '南和县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('519', '43', '宁晋县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('520', '43', '巨鹿县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('521', '43', '新河县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('522', '43', '广宗县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('523', '43', '平乡县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('524', '43', '威县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('525', '43', '清河县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('526', '43', '临西县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('527', '43', '南宫市', '3', '0');
INSERT INTO `dfz_areas` VALUES ('528', '43', '沙河市', '3', '0');
INSERT INTO `dfz_areas` VALUES ('529', '43', '其它区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('530', '44', '新市区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('531', '44', '北市区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('532', '44', '南市区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('533', '44', '满城县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('534', '44', '清苑县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('535', '44', '涞水县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('536', '44', '阜平县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('537', '44', '徐水县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('538', '44', '定兴县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('539', '44', '唐县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('540', '44', '高阳县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('541', '44', '容城县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('542', '44', '涞源县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('543', '44', '望都县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('544', '44', '安新县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('545', '44', '易县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('546', '44', '曲阳县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('547', '44', '蠡县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('548', '44', '顺平县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('549', '44', '博野县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('550', '44', '雄县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('551', '44', '涿州市', '3', '0');
INSERT INTO `dfz_areas` VALUES ('552', '44', '定州市', '3', '0');
INSERT INTO `dfz_areas` VALUES ('553', '44', '安国市', '3', '0');
INSERT INTO `dfz_areas` VALUES ('554', '44', '高碑店市', '3', '0');
INSERT INTO `dfz_areas` VALUES ('555', '44', '高开区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('556', '44', '其它区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('557', '45', '桥东区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('558', '45', '桥西区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('559', '45', '宣化区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('560', '45', '下花园区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('561', '45', '宣化县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('562', '45', '张北县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('563', '45', '康保县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('564', '45', '沽源县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('565', '45', '尚义县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('566', '45', '蔚县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('567', '45', '阳原县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('568', '45', '怀安县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('569', '45', '万全县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('570', '45', '怀来县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('571', '45', '涿鹿县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('572', '45', '赤城县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('573', '45', '崇礼县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('574', '45', '其它区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('575', '46', '双桥区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('576', '46', '双滦区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('577', '46', '鹰手营子矿区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('578', '46', '承德县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('579', '46', '兴隆县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('580', '46', '平泉县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('581', '46', '滦平县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('582', '46', '隆化县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('583', '46', '丰宁满族自治县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('584', '46', '宽城满族自治县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('585', '46', '围场满族蒙古族自治县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('586', '46', '其它区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('587', '47', '新华区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('588', '47', '运河区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('589', '47', '沧县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('590', '47', '青县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('591', '47', '东光县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('592', '47', '海兴县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('593', '47', '盐山县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('594', '47', '肃宁县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('595', '47', '南皮县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('596', '47', '吴桥县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('597', '47', '献县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('598', '47', '孟村回族自治县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('599', '47', '泊头市', '3', '0');
INSERT INTO `dfz_areas` VALUES ('600', '47', '任丘市', '3', '0');
INSERT INTO `dfz_areas` VALUES ('601', '47', '黄骅市', '3', '0');
INSERT INTO `dfz_areas` VALUES ('602', '47', '河间市', '3', '0');
INSERT INTO `dfz_areas` VALUES ('603', '47', '其它区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('604', '48', '安次区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('605', '48', '广阳区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('606', '48', '固安县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('607', '48', '永清县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('608', '48', '香河县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('609', '48', '大城县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('610', '48', '文安县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('611', '48', '大厂回族自治县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('612', '48', '开发区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('613', '48', '燕郊经济技术开发区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('614', '48', '霸州市', '3', '0');
INSERT INTO `dfz_areas` VALUES ('615', '48', '三河市', '3', '0');
INSERT INTO `dfz_areas` VALUES ('616', '48', '其它区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('617', '49', '桃城区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('618', '49', '枣强县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('619', '49', '武邑县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('620', '49', '武强县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('621', '49', '饶阳县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('622', '49', '安平县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('623', '49', '故城县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('624', '49', '景县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('625', '49', '阜城县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('626', '49', '冀州市', '3', '0');
INSERT INTO `dfz_areas` VALUES ('627', '49', '深州市', '3', '0');
INSERT INTO `dfz_areas` VALUES ('628', '49', '其它区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('629', '50', '小店区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('630', '50', '迎泽区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('631', '50', '杏花岭区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('632', '50', '尖草坪区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('633', '50', '万柏林区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('634', '50', '晋源区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('635', '50', '清徐县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('636', '50', '阳曲县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('637', '50', '娄烦县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('638', '50', '古交市', '3', '0');
INSERT INTO `dfz_areas` VALUES ('639', '50', '其它区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('640', '51', '城区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('641', '51', '矿区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('642', '51', '南郊区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('643', '51', '新荣区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('644', '51', '阳高县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('645', '51', '天镇县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('646', '51', '广灵县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('647', '51', '灵丘县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('648', '51', '浑源县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('649', '51', '左云县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('650', '51', '大同县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('651', '51', '其它区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('652', '52', '城区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('653', '52', '矿区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('654', '52', '郊区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('655', '52', '平定县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('656', '52', '盂县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('657', '52', '其它区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('658', '53', '长治县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('659', '53', '襄垣县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('660', '53', '屯留县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('661', '53', '平顺县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('662', '53', '黎城县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('663', '53', '壶关县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('664', '53', '长子县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('665', '53', '武乡县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('666', '53', '沁县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('667', '53', '沁源县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('668', '53', '潞城市', '3', '0');
INSERT INTO `dfz_areas` VALUES ('669', '53', '城区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('670', '53', '郊区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('671', '53', '高新区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('672', '53', '其它区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('673', '54', '城区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('674', '54', '沁水县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('675', '54', '阳城县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('676', '54', '陵川县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('677', '54', '泽州县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('678', '54', '高平市', '3', '0');
INSERT INTO `dfz_areas` VALUES ('679', '54', '其它区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('680', '55', '朔城区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('681', '55', '平鲁区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('682', '55', '山阴县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('683', '55', '应县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('684', '55', '右玉县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('685', '55', '怀仁县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('686', '55', '其它区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('687', '56', '榆次区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('688', '56', '榆社县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('689', '56', '左权县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('690', '56', '和顺县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('691', '56', '昔阳县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('692', '56', '寿阳县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('693', '56', '太谷县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('694', '56', '祁县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('695', '56', '平遥县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('696', '56', '灵石县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('697', '56', '介休市', '3', '0');
INSERT INTO `dfz_areas` VALUES ('698', '56', '其它区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('699', '57', '盐湖区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('700', '57', '临猗县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('701', '57', '万荣县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('702', '57', '闻喜县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('703', '57', '稷山县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('704', '57', '新绛县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('705', '57', '绛县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('706', '57', '垣曲县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('707', '57', '夏县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('708', '57', '平陆县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('709', '57', '芮城县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('710', '57', '永济市', '3', '0');
INSERT INTO `dfz_areas` VALUES ('711', '57', '河津市', '3', '0');
INSERT INTO `dfz_areas` VALUES ('712', '57', '其它区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('713', '58', '忻府区', '3', '0');
INSERT INTO `dfz_areas` VALUES ('714', '58', '定襄县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('715', '58', '五台县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('716', '58', '代县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('717', '58', '繁峙县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('718', '58', '宁武县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('719', '58', '静乐县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('720', '58', '神池县', '3', '0');
INSERT INTO `dfz_areas` VALUES ('721', '58', '五寨县', '3', '0');
INSERT INTO `dfz_areas` VALUES