vaping/数据库修改记录/旧版本/v2.0.8.sql

## 本文件是v2.0.3版本的数据库修改记录，通过查看后端根目录下的version.json文件确定当前系统版本号
## 说明：如果你当前的版本号小于v2.0.3，那么在升级时需要执行本文件的sql内容



# v2.0.8
# 修改时间：2023-04-24
UPDATE `yoshop_region` SET `code`='110100' WHERE (`id`='2');
UPDATE `yoshop_region` SET `code`='120100' WHERE (`id`='20');
UPDATE `yoshop_region` SET `code`='310100' WHERE (`id`='783');
UPDATE `yoshop_region` SET `code`='500100' WHERE (`id`='2224');

DELETE FROM `yoshop_region` WHERE (`pid`='1495' AND `level`='3');
DELETE FROM `yoshop_region` WHERE (`pid`='1671' AND `level`='3');
DELETE FROM `yoshop_region` WHERE (`pid`='2195' AND `level`='3');
DELETE FROM `yoshop_region` WHERE (`pid`='3094' AND `level`='3');

INSERT INTO `yoshop_region` VALUES ('3706', '省直辖县级行政区划', '1495', '419000', '2');
INSERT INTO `yoshop_region` VALUES ('3707', '省直辖县级行政区划', '1671', '429000', '2');
INSERT INTO `yoshop_region` VALUES ('3708', '省直辖县级行政区划', '2195', '469000', '2');
INSERT INTO `yoshop_region` VALUES ('3709', '县', '2223', '500200', '2');
INSERT INTO `yoshop_region` VALUES ('3710', '自治区直辖县级行政区划', '3094', '659000', '2');
INSERT INTO `yoshop_region` VALUES ('3711', '石家庄高新技术产业开发区', '38', '130171', '3');
INSERT INTO `yoshop_region` VALUES ('3712', '石家庄循环化工园区', '38', '130172', '3');
INSERT INTO `yoshop_region` VALUES ('3713', '河北唐山芦台经济开发区', '61', '130271', '3');
INSERT INTO `yoshop_region` VALUES ('3714', '唐山市汉沽管理区', '61', '130272', '3');
INSERT INTO `yoshop_region` VALUES ('3715', '唐山高新技术产业开发区', '61', '130273', '3');
INSERT INTO `yoshop_region` VALUES ('3716', '河北唐山海港经济开发区', '61', '130274', '3');
INSERT INTO `yoshop_region` VALUES ('3717', '秦皇岛市经济技术开发区', '76', '130371', '3');
INSERT INTO `yoshop_region` VALUES ('3718', '北戴河新区', '76', '130372', '3');
INSERT INTO `yoshop_region` VALUES ('3719', '邯郸经济技术开发区', '84', '130471', '3');
INSERT INTO `yoshop_region` VALUES ('3720', '邯郸冀南新区', '84', '130473', '3');
INSERT INTO `yoshop_region` VALUES ('3721', '襄都区', '103', '130502', '3');
INSERT INTO `yoshop_region` VALUES ('3722', '信都区', '103', '130503', '3');
INSERT INTO `yoshop_region` VALUES ('3723', '任泽区', '103', '130505', '3');
INSERT INTO `yoshop_region` VALUES ('3724', '南和区', '103', '130506', '3');
INSERT INTO `yoshop_region` VALUES ('3725', '河北邢台经济开发区', '103', '130571', '3');
INSERT INTO `yoshop_region` VALUES ('3726', '保定高新技术产业开发区', '123', '130671', '3');
INSERT INTO `yoshop_region` VALUES ('3727', '保定白沟新城', '123', '130672', '3');
INSERT INTO `yoshop_region` VALUES ('3728', '张家口经济开发区', '148', '130771', '3');
INSERT INTO `yoshop_region` VALUES ('3729', '张家口市察北管理区', '148', '130772', '3');
INSERT INTO `yoshop_region` VALUES ('3730', '张家口市塞北管理区', '148', '130773', '3');
INSERT INTO `yoshop_region` VALUES ('3731', '承德高新技术产业开发区', '165', '130871', '3');
INSERT INTO `yoshop_region` VALUES ('3732', '河北沧州经济开发区', '177', '130971', '3');
INSERT INTO `yoshop_region` VALUES ('3733', '沧州高新技术产业开发区', '177', '130972', '3');
INSERT INTO `yoshop_region` VALUES ('3734', '沧州渤海新区', '177', '130973', '3');
INSERT INTO `yoshop_region` VALUES ('3735', '廊坊经济技术开发区', '194', '131071', '3');
INSERT INTO `yoshop_region` VALUES ('3736', '河北衡水高新技术产业开发区', '205', '131171', '3');
INSERT INTO `yoshop_region` VALUES ('3737', '衡水滨湖新区', '205', '131172', '3');
INSERT INTO `yoshop_region` VALUES ('3738', '山西转型综合改革示范区', '218', '140171', '3');
INSERT INTO `yoshop_region` VALUES ('3739', '山西大同经济开发区', '229', '140271', '3');
INSERT INTO `yoshop_region` VALUES ('3740', '山西长治高新技术产业园区', '246', '140471', '3');
INSERT INTO `yoshop_region` VALUES ('3741', '山西朔州经济开发区', '266', '140671', '3');
INSERT INTO `yoshop_region` VALUES ('3742', '五台山风景名胜区', '299', '140971', '3');
INSERT INTO `yoshop_region` VALUES ('3743', '呼和浩特经济技术开发区', '347', '150172', '3');
INSERT INTO `yoshop_region` VALUES ('3744', '包头稀土高新技术产业开发区', '357', '150271', '3');
INSERT INTO `yoshop_region` VALUES ('3745', '通辽经济技术开发区', '384', '150571', '3');
INSERT INTO `yoshop_region` VALUES ('3746', '乌拉盖管委会', '445', '152571', '3');
INSERT INTO `yoshop_region` VALUES ('3747', '内蒙古阿拉善高新技术产业开发区', '458', '152971', '3');
INSERT INTO `yoshop_region` VALUES ('3748', '长春经济技术开发区', '578', '220171', '3');
INSERT INTO `yoshop_region` VALUES ('3749', '长春净月高新技术产业开发区', '578', '220172', '3');
INSERT INTO `yoshop_region` VALUES ('3750', '长春高新技术产业开发区', '578', '220173', '3');
INSERT INTO `yoshop_region` VALUES ('3751', '长春汽车经济技术开发区', '578', '220174', '3');
INSERT INTO `yoshop_region` VALUES ('3752', '公主岭市', '578', '220184', '3');
INSERT INTO `yoshop_region` VALUES ('3753', '吉林经济开发区', '589', '220271', '3');
INSERT INTO `yoshop_region` VALUES ('3754', '吉林高新技术产业开发区', '589', '220272', '3');
INSERT INTO `yoshop_region` VALUES ('3755', '吉林中国新加坡食品区', '589', '220273', '3');
INSERT INTO `yoshop_region` VALUES ('3756', '吉林松原经济开发区', '626', '220771', '3');
INSERT INTO `yoshop_region` VALUES ('3757', '吉林白城经济开发区', '632', '220871', '3');
INSERT INTO `yoshop_region` VALUES ('3758', '大庆高新技术产业开发区', '712', '230671', '3');
INSERT INTO `yoshop_region` VALUES ('3759', '牡丹江经济技术开发区', '749', '231071', '3');
INSERT INTO `yoshop_region` VALUES ('3760', '加格达奇区', '778', '232761', '3');
INSERT INTO `yoshop_region` VALUES ('3761', '松岭区', '778', '232762', '3');
INSERT INTO `yoshop_region` VALUES ('3762', '新林区', '778', '232763', '3');
INSERT INTO `yoshop_region` VALUES ('3763', '呼中区', '778', '232764', '3');
INSERT INTO `yoshop_region` VALUES ('3764', '徐州经济技术开发区', '821', '320371', '3');
INSERT INTO `yoshop_region` VALUES ('3765', '苏州工业园区', '839', '320571', '3');
INSERT INTO `yoshop_region` VALUES ('3766', '崇川区', '849', '320613', '3');
INSERT INTO `yoshop_region` VALUES ('3767', '海门区', '849', '320614', '3');
INSERT INTO `yoshop_region` VALUES ('3768', '南通经济技术开发区', '849', '320671', '3');
INSERT INTO `yoshop_region` VALUES ('3769', '连云港经济技术开发区', '858', '320771', '3');
INSERT INTO `yoshop_region` VALUES ('3770', '连云港高新技术产业开发区', '858', '320772', '3');
INSERT INTO `yoshop_region` VALUES ('3771', '淮安经济技术开发区', '865', '320871', '3');
INSERT INTO `yoshop_region` VALUES ('3772', '盐城经济技术开发区', '873', '320971', '3');
INSERT INTO `yoshop_region` VALUES ('3773', '扬州经济技术开发区', '883', '321071', '3');
INSERT INTO `yoshop_region` VALUES ('3774', '镇江新区', '890', '321171', '3');
INSERT INTO `yoshop_region` VALUES ('3775', '泰州医药高新技术产业开发区', '897', '321271', '3');
INSERT INTO `yoshop_region` VALUES ('3776', '宿迁经济技术开发区', '904', '321371', '3');
INSERT INTO `yoshop_region` VALUES ('3777', '临平区', '911', '330113', '3');
INSERT INTO `yoshop_region` VALUES ('3778', '钱塘区', '911', '330114', '3');
INSERT INTO `yoshop_region` VALUES ('3779', '合肥高新技术产业开发区', '1013', '340171', '3');
INSERT INTO `yoshop_region` VALUES ('3780', '合肥经济技术开发区', '1013', '340172', '3');
INSERT INTO `yoshop_region` VALUES ('3781', '合肥新站高新技术产业开发区', '1013', '340173', '3');
INSERT INTO `yoshop_region` VALUES ('3782', '弋江区', '1023', '340209', '3');
INSERT INTO `yoshop_region` VALUES ('3783', '湾沚区', '1023', '340210', '3');
INSERT INTO `yoshop_region` VALUES ('3784', '繁昌区', '1023', '340212', '3');
INSERT INTO `yoshop_region` VALUES ('3785', '芜湖经济技术开发区', '1023', '340271', '3');
INSERT INTO `yoshop_region` VALUES ('3786', '安徽芜湖三山经济开发区', '1023', '340272', '3');
INSERT INTO `yoshop_region` VALUES ('3787', '蚌埠市高新技术开发区', '1032', '340371', '3');
INSERT INTO `yoshop_region` VALUES ('3788', '蚌埠市经济开发区', '1032', '340372', '3');
INSERT INTO `yoshop_region` VALUES ('3789', '安徽安庆经济开发区', '1065', '340871', '3');
INSERT INTO `yoshop_region` VALUES ('3790', '中新苏滁高新技术产业开发区', '1084', '341171', '3');
INSERT INTO `yoshop_region` VALUES ('3791', '滁州经济技术开发区', '1084', '341172', '3');
INSERT INTO `yoshop_region` VALUES ('3792', '阜阳合肥现代产业园区', '1093', '341271', '3');
INSERT INTO `yoshop_region` VALUES ('3793', '阜阳经济技术开发区', '1093', '341272', '3');
INSERT INTO `yoshop_region` VALUES ('3794', '宿州马鞍山现代产业园区', '1102', '341371', '3');
INSERT INTO `yoshop_region` VALUES ('3795', '宿州经济技术开发区', '1102', '341372', '3');
INSERT INTO `yoshop_region` VALUES ('3796', '宣城市经济开发区', '1126', '341871', '3');
INSERT INTO `yoshop_region` VALUES ('3797', '三元区', '1162', '350404', '3');
INSERT INTO `yoshop_region` VALUES ('3798', '沙县区', '1162', '350405', '3');
INSERT INTO `yoshop_region` VALUES ('3799', '龙海区', '1188', '350604', '3');
INSERT INTO `yoshop_region` VALUES ('3800', '长泰区', '1188', '350605', '3');
INSERT INTO `yoshop_region` VALUES ('3801', '龙南市', '1272', '360783', '3');
INSERT INTO `yoshop_region` VALUES ('3802', '济南高新技术产业开发区', '1342', '370171', '3');
INSERT INTO `yoshop_region` VALUES ('3803', '青岛高新技术产业开发区', '1355', '370271', '3');
INSERT INTO `yoshop_region` VALUES ('3804', '东营经济技术开发区', '1382', '370571', '3');
INSERT INTO `yoshop_region` VALUES ('3805', '东营港经济开发区', '1382', '370572', '3');
INSERT INTO `yoshop_region` VALUES ('3806', '蓬莱区', '1388', '370614', '3');
INSERT INTO `yoshop_region` VALUES ('3807', '烟台高新技术产业开发区', '1388', '370671', '3');
INSERT INTO `yoshop_region` VALUES ('3808', '烟台经济技术开发区', '1388', '370672', '3');
INSERT INTO `yoshop_region` VALUES ('3809', '潍坊滨海经济技术开发区', '1401', '370772', '3');
INSERT INTO `yoshop_region` VALUES ('3810', '济宁高新技术产业开发区', '1414', '370871', '3');
INSERT INTO `yoshop_region` VALUES ('3811', '威海火炬高技术产业开发区', '1433', '371071', '3');
INSERT INTO `yoshop_region` VALUES ('3812', '威海经济技术开发区', '1433', '371072', '3');
INSERT INTO `yoshop_region` VALUES ('3813', '威海临港经济技术开发区', '1433', '371073', '3');
INSERT INTO `yoshop_region` VALUES ('3814', '日照经济技术开发区', '1438', '371171', '3');
INSERT INTO `yoshop_region` VALUES ('3815', '临沂高新技术产业开发区', '1443', '371371', '3');
INSERT INTO `yoshop_region` VALUES ('3816', '德州天衢新区', '1456', '371471', '3');
INSERT INTO `yoshop_region` VALUES ('3817', '菏泽经济技术开发区', '1485', '371771', '3');
INSERT INTO `yoshop_region` VALUES ('3818', '菏泽高新技术开发区', '1485', '371772', '3');
INSERT INTO `yoshop_region` VALUES ('3819', '郑州经济技术开发区', '1496', '410171', '3');
INSERT INTO `yoshop_region` VALUES ('3820', '郑州高新技术产业开发区', '1496', '410172', '3');
INSERT INTO `yoshop_region` VALUES ('3821', '郑州航空港经济综合实验区', '1496', '410173', '3');
INSERT INTO `yoshop_region` VALUES ('3822', '偃师区', '1519', '410307', '3');
INSERT INTO `yoshop_region` VALUES ('3823', '孟津区', '1519', '410308', '3');
INSERT INTO `yoshop_region` VALUES ('3824', '洛阳高新技术产业开发区', '1519', '410371', '3');
INSERT INTO `yoshop_region` VALUES ('3825', '平顶山高新技术产业开发区', '1535', '410471', '3');
INSERT INTO `yoshop_region` VALUES ('3826', '平顶山市城乡一体化示范区', '1535', '410472', '3');
INSERT INTO `yoshop_region` VALUES ('3827', '安阳高新技术产业开发区', '1546', '410571', '3');
INSERT INTO `yoshop_region` VALUES ('3828', '鹤壁经济技术开发区', '1556', '410671', '3');
INSERT INTO `yoshop_region` VALUES ('3829', '新乡高新技术产业开发区', '1562', '410771', '3');
INSERT INTO `yoshop_region` VALUES ('3830', '新乡经济技术开发区', '1562', '410772', '3');
INSERT INTO `yoshop_region` VALUES ('3831', '新乡市平原城乡一体化示范区', '1562', '410773', '3');
INSERT INTO `yoshop_region` VALUES ('3832', '焦作城乡一体化示范区', '1575', '410871', '3');
INSERT INTO `yoshop_region` VALUES ('3833', '河南濮阳工业园区', '1586', '410971', '3');
INSERT INTO `yoshop_region` VALUES ('3834', '濮阳经济技术开发区', '1586', '410972', '3');
INSERT INTO `yoshop_region` VALUES ('3835', '许昌经济技术开发区', '1593', '411071', '3');
INSERT INTO `yoshop_region` VALUES ('3836', '漯河经济技术开发区', '1600', '411171', '3');
INSERT INTO `yoshop_region` VALUES ('3837', '河南三门峡经济开发区', '1606', '411271', '3');
INSERT INTO `yoshop_region` VALUES ('3838', '南阳高新技术产业开发区', '1613', '411371', '3');
INSERT INTO `yoshop_region` VALUES ('3839', '南阳市城乡一体化示范区', '1613', '411372', '3');
INSERT INTO `yoshop_region` VALUES ('3840', '豫东综合物流产业聚集区', '1627', '411471', '3');
INSERT INTO `yoshop_region` VALUES ('3841', '河南商丘经济开发区', '1627', '411472', '3');
INSERT INTO `yoshop_region` VALUES ('3842', '信阳高新技术产业开发区', '1637', '411571', '3');
INSERT INTO `yoshop_region` VALUES ('3843', '河南周口经济开发区', '1648', '411671', '3');
INSERT INTO `yoshop_region` VALUES ('3844', '河南驻马店经济开发区', '1659', '411771', '3');
INSERT INTO `yoshop_region` VALUES ('3845', '济源市', '3706', '419001', '3');
INSERT INTO `yoshop_region` VALUES ('3846', '荆州经济技术开发区', '1744', '421071', '3');
INSERT INTO `yoshop_region` VALUES ('3847', '监利市', '1744', '421088', '3');
INSERT INTO `yoshop_region` VALUES ('3848', '龙感湖管理区', '1753', '421171', '3');
INSERT INTO `yoshop_region` VALUES ('3849', '仙桃市', '3707', '429004', '3');
INSERT INTO `yoshop_region` VALUES ('3850', '潜江市', '3707', '429005', '3');
INSERT INTO `yoshop_region` VALUES ('3851', '天门市', '3707', '429006', '3');
INSERT INTO `yoshop_region` VALUES ('3852', '神农架林区', '3707', '429021', '3');
INSERT INTO `yoshop_region` VALUES ('3853', '湖南湘潭高新技术产业园区', '1809', '430371', '3');
INSERT INTO `yoshop_region` VALUES ('3854', '湘潭昭山示范区', '1809', '430372', '3');
INSERT INTO `yoshop_region` VALUES ('3855', '湘潭九华示范区', '1809', '430373', '3');
INSERT INTO `yoshop_region` VALUES ('3856', '衡阳综合保税区', '1815', '430471', '3');
INSERT INTO `yoshop_region` VALUES ('3857', '湖南衡阳高新技术产业园区', '1815', '430472', '3');
INSERT INTO `yoshop_region` VALUES ('3858', '湖南衡阳松木经济开发区', '1815', '430473', '3');
INSERT INTO `yoshop_region` VALUES ('3859', '岳阳市屈原管理区', '1841', '430671', '3');
INSERT INTO `yoshop_region` VALUES ('3860', '常德市西洞庭管理区', '1851', '430771', '3');
INSERT INTO `yoshop_region` VALUES ('3861', '益阳市大通湖管理区', '1866', '430971', '3');
INSERT INTO `yoshop_region` VALUES ('3862', '湖南益阳高新技术产业园区', '1866', '430972', '3');
INSERT INTO `yoshop_region` VALUES ('3863', '永州经济技术开发区', '1885', '431171', '3');
INSERT INTO `yoshop_region` VALUES ('3864', '永州市回龙圩管理区', '1885', '431173', '3');
INSERT INTO `yoshop_region` VALUES ('3865', '祁阳市', '1885', '431181', '3');
INSERT INTO `yoshop_region` VALUES ('3866', '怀化市洪江管理区', '1897', '431271', '3');
INSERT INTO `yoshop_region` VALUES ('3867', '东城街道', '2051', '441900', '3');
INSERT INTO `yoshop_region` VALUES ('3868', '东莞滨海湾新区', '2051', '441900', '3');
INSERT INTO `yoshop_region` VALUES ('3869', '石岐街道', '2052', '442000', '3');
INSERT INTO `yoshop_region` VALUES ('3870', '民众街道', '2052', '442000', '3');
INSERT INTO `yoshop_region` VALUES ('3871', '南朗街道', '2052', '442000', '3');
INSERT INTO `yoshop_region` VALUES ('3872', '横州市', '2070', '450181', '3');
INSERT INTO `yoshop_region` VALUES ('3873', '西沙群岛', '2206', '460321', '3');
INSERT INTO `yoshop_region` VALUES ('3874', '那大镇', '2207', '460400', '3');
INSERT INTO `yoshop_region` VALUES ('3875', '五指山市', '3708', '469001', '3');
INSERT INTO `yoshop_region` VALUES ('3876', '琼海市', '3708', '469002', '3');
INSERT INTO `yoshop_region` VALUES ('3877', '文昌市', '3708', '469005', '3');
INSERT INTO `yoshop_region` VALUES ('3878', '万宁市', '3708', '469006', '3');
INSERT INTO `yoshop_region` VALUES ('3879', '东方市', '3708', '469007', '3');
INSERT INTO `yoshop_region` VALUES ('3880', '定安县', '3708', '469021', '3');
INSERT INTO `yoshop_region` VALUES ('3881', '屯昌县', '3708', '469022', '3');
INSERT INTO `yoshop_region` VALUES ('3882', '澄迈县', '3708', '469023', '3');
INSERT INTO `yoshop_region` VALUES ('3883', '临高县', '3708', '469024', '3');
INSERT INTO `yoshop_region` VALUES ('3884', '白沙黎族自治县', '3708', '469025', '3');
INSERT INTO `yoshop_region` VALUES ('3885', '昌江黎族自治县', '3708', '469026', '3');
INSERT INTO `yoshop_region` VALUES ('3886', '乐东黎族自治县', '3708', '469027', '3');
INSERT INTO `yoshop_region` VALUES ('3887', '陵水黎族自治县', '3708', '469028', '3');
INSERT INTO `yoshop_region` VALUES ('3888', '保亭黎族苗族自治县', '3708', '469029', '3');
INSERT INTO `yoshop_region` VALUES ('3889', '琼中黎族苗族自治县', '3708', '469030', '3');
INSERT INTO `yoshop_region` VALUES ('3890', '城口县', '3709', '500229', '3');
INSERT INTO `yoshop_region` VALUES ('3891', '丰都县', '3709', '500230', '3');
INSERT INTO `yoshop_region` VALUES ('3892', '垫江县', '3709', '500231', '3');
INSERT INTO `yoshop_region` VALUES ('3893', '忠县', '3709', '500233', '3');
INSERT INTO `yoshop_region` VALUES ('3894', '云阳县', '3709', '500235', '3');
INSERT INTO `yoshop_region` VALUES ('3895', '奉节县', '3709', '500236', '3');
INSERT INTO `yoshop_region` VALUES ('3896', '巫山县', '3709', '500237', '3');
INSERT INTO `yoshop_region` VALUES ('3897', '巫溪县', '3709', '500238', '3');
INSERT INTO `yoshop_region` VALUES ('3898', '石柱土家族自治县', '3709', '500240', '3');
INSERT INTO `yoshop_region` VALUES ('3899', '秀山土家族苗族自治县', '3709', '500241', '3');
INSERT INTO `yoshop_region` VALUES ('3900', '酉阳土家族苗族自治县', '3709', '500242', '3');
INSERT INTO `yoshop_region` VALUES ('3901', '彭水苗族土家族自治县', '3709', '500243', '3');
INSERT INTO `yoshop_region` VALUES ('3902', '新津区', '2264', '510118', '3');
INSERT INTO `yoshop_region` VALUES ('3903', '会理市', '2450', '513402', '3');
INSERT INTO `yoshop_region` VALUES ('3904', '水城区', '2480', '520204', '3');
INSERT INTO `yoshop_region` VALUES ('3905', '黔西市', '2507', '520581', '3');
INSERT INTO `yoshop_region` VALUES ('3906', '禄丰市', '2646', '532302', '3');
INSERT INTO `yoshop_region` VALUES ('3907', '格尔木藏青工业园区', '2713', '540171', '3');
INSERT INTO `yoshop_region` VALUES ('3908', '拉萨经济技术开发区', '2713', '540172', '3');
INSERT INTO `yoshop_region` VALUES ('3909', '西藏文化旅游创意园区', '2713', '540173', '3');
INSERT INTO `yoshop_region` VALUES ('3910', '达孜工业园区', '2713', '540174', '3');
INSERT INTO `yoshop_region` VALUES ('3911', '凤翔区', '2814', '610305', '3');
INSERT INTO `yoshop_region` VALUES ('3912', '旬阳市', '2893', '610981', '3');
INSERT INTO `yoshop_region` VALUES ('3913', '兰州新区', '2913', '620171', '3');
INSERT INTO `yoshop_region` VALUES ('3914', '市辖区', '2922', '620201', '3');
INSERT INTO `yoshop_region` VALUES ('3915', '同仁市', '3034', '632301', '3');
INSERT INTO `yoshop_region` VALUES ('3916', '大柴旦行政委员会', '3059', '632857', '3');
INSERT INTO `yoshop_region` VALUES ('3917', '库尔勒经济技术开发区', '3130', '652871', '3');
INSERT INTO `yoshop_region` VALUES ('3918', '沙湾市', '3189', '654203', '3');
INSERT INTO `yoshop_region` VALUES ('3919', '石河子市', '3710', '659001', '3');
INSERT INTO `yoshop_region` VALUES ('3920', '阿拉尔市', '3710', '659002', '3');
INSERT INTO `yoshop_region` VALUES ('3921', '图木舒克市', '3710', '659003', '3');
INSERT INTO `yoshop_region` VALUES ('3922', '五家渠市', '3710', '659004', '3');
INSERT INTO `yoshop_region` VALUES ('3923', '北屯市', '3710', '659005', '3');
INSERT INTO `yoshop_region` VALUES ('3924', '铁门关市', '3710', '659006', '3');
INSERT INTO `yoshop_region` VALUES ('3925', '双河市', '3710', '659007', '3');
INSERT INTO `yoshop_region` VALUES ('3926', '可克达拉市', '3710', '659008', '3');
INSERT INTO `yoshop_region` VALUES ('3927', '昆玉市', '3710', '659009', '3');
INSERT INTO `yoshop_region` VALUES ('3928', '胡杨河市', '3710', '659010', '3');
INSERT INTO `yoshop_region` VALUES ('3929', '新星市', '3710', '659011', '3');

DELETE FROM `yoshop_region` WHERE (`id`='104');
DELETE FROM `yoshop_region` WHERE (`id`='105');
DELETE FROM `yoshop_region` WHERE (`id`='106');
DELETE FROM `yoshop_region` WHERE (`id`='111');
DELETE FROM `yoshop_region` WHERE (`id`='112');
DELETE FROM `yoshop_region` WHERE (`id`='604');
DELETE FROM `yoshop_region` WHERE (`id`='850');
DELETE FROM `yoshop_region` WHERE (`id`='851');
DELETE FROM `yoshop_region` WHERE (`id`='856');
DELETE FROM `yoshop_region` WHERE (`id`='913');
DELETE FROM `yoshop_region` WHERE (`id`='914');
DELETE FROM `yoshop_region` WHERE (`id`='1025');
DELETE FROM `yoshop_region` WHERE (`id`='1027');
DELETE FROM `yoshop_region` WHERE (`id`='1028');
DELETE FROM `yoshop_region` WHERE (`id`='1029');
DELETE FROM `yoshop_region` WHERE (`id`='1163');
DELETE FROM `yoshop_region` WHERE (`id`='1164');
DELETE FROM `yoshop_region` WHERE (`id`='1170');
DELETE FROM `yoshop_region` WHERE (`id`='1184');
DELETE FROM `yoshop_region` WHERE (`id`='1194');
DELETE FROM `yoshop_region` WHERE (`id`='1199');
DELETE FROM `yoshop_region` WHERE (`id`='1281');
DELETE FROM `yoshop_region` WHERE (`id`='1393');
DELETE FROM `yoshop_region` WHERE (`id`='1397');
DELETE FROM `yoshop_region` WHERE (`id`='1524');
DELETE FROM `yoshop_region` WHERE (`id`='1526');
DELETE FROM `yoshop_region` WHERE (`id`='1534');
DELETE FROM `yoshop_region` WHERE (`id`='1748');
DELETE FROM `yoshop_region` WHERE (`id`='1888');
DELETE FROM `yoshop_region` WHERE (`id`='3620');
DELETE FROM `yoshop_region` WHERE (`id`='3655');
DELETE FROM `yoshop_region` WHERE (`id`='3663');
DELETE FROM `yoshop_region` WHERE (`id`='3665');
DELETE FROM `yoshop_region` WHERE (`id`='3674');
DELETE FROM `yoshop_region` WHERE (`id`='2082');
DELETE FROM `yoshop_region` WHERE (`id`='3679');
DELETE FROM `yoshop_region` WHERE (`id`='3682');
DELETE FROM `yoshop_region` WHERE (`id`='2251');
DELETE FROM `yoshop_region` WHERE (`id`='2252');
DELETE FROM `yoshop_region` WHERE (`id`='2253');
DELETE FROM `yoshop_region` WHERE (`id`='2254');
DELETE FROM `yoshop_region` WHERE (`id`='2255');
DELETE FROM `yoshop_region` WHERE (`id`='2256');
DELETE FROM `yoshop_region` WHERE (`id`='2257');
DELETE FROM `yoshop_region` WHERE (`id`='2258');
DELETE FROM `yoshop_region` WHERE (`id`='2259');
DELETE FROM `yoshop_region` WHERE (`id`='2260');
DELETE FROM `yoshop_region` WHERE (`id`='2261');
DELETE FROM `yoshop_region` WHERE (`id`='2262');
DELETE FROM `yoshop_region` WHERE (`id`='2279');
DELETE FROM `yoshop_region` WHERE (`id`='2455');
DELETE FROM `yoshop_region` WHERE (`id`='2483');
DELETE FROM `yoshop_region` WHERE (`id`='2510');
DELETE FROM `yoshop_region` WHERE (`id`='2656');
DELETE FROM `yoshop_region` WHERE (`id`='2818');
DELETE FROM `yoshop_region` WHERE (`id`='2902');
DELETE FROM `yoshop_region` WHERE (`id`='3700');
DELETE FROM `yoshop_region` WHERE (`id`='3701');
DELETE FROM `yoshop_region` WHERE (`id`='3702');
DELETE FROM `yoshop_region` WHERE (`id`='3703');
DELETE FROM `yoshop_region` WHERE (`id`='3704');
DELETE FROM `yoshop_region` WHERE (`id`='3035');
DELETE FROM `yoshop_region` WHERE (`id`='3193');