yoshop2.0
/
数据库修改记录.txt


# 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');


# v2.0.7
# 修改时间：2023-02-20
UPDATE `yoshop_region` SET `name`='北京市' WHERE (`id`='1');
UPDATE `yoshop_region` SET `name`='天津市' WHERE (`id`='19');
UPDATE `yoshop_region` SET `name`='上海市' WHERE (`id`='782');
UPDATE `yoshop_region` SET `name`='重庆市' WHERE (`id`='2223');
UPDATE `yoshop_region` SET `name`='北京市' WHERE (`id`='1');

# 修改时间：2022-04-18
INSERT INTO `yoshop_store_api` VALUES ('11186', '上传视频文件', '/upload/video', '11008', '112', '1614556800', '1614556800');

# 修改时间：2022-03-03
INSERT INTO `yoshop_store_menu_api` VALUES ('10664', '10015', '11025', '1614556800');
INSERT INTO `yoshop_store_menu_api` VALUES ('10665', '10015', '11022', '1614556800');
INSERT INTO `yoshop_store_menu_api` VALUES ('10666', '10015', '11020', '1614556800');

-------------------------------------

# v2.0.5
# 修改时间：2022-01-24
ALTER TABLE `yoshop_goods`
ADD COLUMN `video_id`  int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '主图视频ID' AFTER `goods_no`,
ADD COLUMN `video_cover_id`  int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '主图视频ID' AFTER `video_id`;

# v2.0.4
# 修改时间：2021-11-29
ALTER TABLE `yoshop_wxapp` COMMENT='微信小程序记录表（已废弃）';

CREATE TABLE `yoshop_wxapp_setting` (
  `key` varchar(30) NOT NULL DEFAULT '' COMMENT '设置项标示',
  `describe` varchar(255) NOT NULL DEFAULT '' COMMENT '设置项描述',
  `values` mediumtext NOT NULL COMMENT '设置内容(json格式)',
  `store_id` int unsigned NOT NULL DEFAULT '0' COMMENT '商城ID',
  `update_time` int unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  UNIQUE KEY `unique_key` (`key`,`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='微信小程序设置表';


CREATE TABLE `yoshop_h5_setting` (
  `key` varchar(30) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '设置项标示',
  `describe` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '设置项描述',
  `values` mediumtext CHARACTER SET utf8 NOT NULL COMMENT '设置内容(json格式)',
  `store_id` int unsigned NOT NULL DEFAULT '0' COMMENT '商城ID',
  `update_time` int unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  UNIQUE KEY `unique_key` (`key`,`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='H5端设置表';


UPDATE `yoshop_store_api` SET `url`='/client.wxapp.setting/update', `sort`='105' WHERE (`api_id`='11153');
UPDATE `yoshop_store_api` SET `url`='/client.wxapp.setting/detail', `sort`='100' WHERE (`api_id`='11182');

INSERT INTO `yoshop_store_api` VALUES ('11270', 'H5端', '-', '11151', '105', '1614556800', '1614556800');
INSERT INTO `yoshop_store_api` VALUES ('11271', '获取设置项', '/client.h5.setting/detail', '11270', '100', '1614556800', '1614556800');
INSERT INTO `yoshop_store_api` VALUES ('11272', '更新设置项', '/client.h5.setting/update', '11270', '105', '1614556800', '1614556800');


--------------------------------------------

# v2.0.3
# 修改时间：2021-10-19
DROP TABLE IF EXISTS `yoshop_order_export`;
CREATE TABLE `yoshop_order_export` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `start_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '下单时间(开始)',
  `end_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '下单时间(结束)',
  `file_path` varchar(255) NOT NULL DEFAULT '' COMMENT 'excel文件路径',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '导出状态(10进行中 20已完成 30失败)',
  `store_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '商城ID',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `store_id` (`store_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10001 DEFAULT CHARSET=utf8 COMMENT='订单导出Excel记录表';


# v2.0.3
# 修改时间：2021-10-19
INSERT INTO `yoshop_store_api` VALUES ('11185', '删除订单', '/order.event/delete', '11132', '135', '1614556800', '1614556800');
INSERT INTO `yoshop_store_menu` VALUES ('10141', '20', '删除订单', '', 'delete', '10051', '115', '1614556800', '1614556800');
INSERT INTO `yoshop_store_menu_api` VALUES ('10661', '10141', '11185', '1614556800');
INSERT INTO `yoshop_store_menu_api` VALUES ('10662', '10141', '11132', '1614556800');
INSERT INTO `yoshop_store_menu_api` VALUES ('10663', '10141', '11076', '1614556800');


# v2.0.3
# 修改时间：2021-10-19
ALTER TABLE `yoshop_order`
ADD COLUMN `platform`  varchar(20) NOT NULL DEFAULT '' COMMENT '来源客户端 (APP、H5、小程序等)' AFTER `order_source_id`;

--------------------------------------------


# v2.0.1
# 修改时间：2021-3-26
ALTER TABLE `yoshop_user_oauth` ADD INDEX `oauth_type_2` (`oauth_type`, `oauth_id`) USING BTREE ;


# v2.0.1
# 修改时间：2021-3-26
ALTER TABLE `yoshop_user_oauth`
ADD COLUMN `is_delete`  tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否删除' AFTER `store_id` ;


# v2.0.1
# 修改时间：2021-6-2
INSERT INTO `yoshop_region` VALUES ('3620', '东城街道', '2051', '44190', '3');
INSERT INTO `yoshop_region` VALUES ('3621', '南城街道', '2051', '441900', '3');
INSERT INTO `yoshop_region` VALUES ('3622', '万江街道', '2051', '441900', '3');
INSERT INTO `yoshop_region` VALUES ('3623', '莞城街道', '2051', '441900', '3');
INSERT INTO `yoshop_region` VALUES ('3624', '石碣镇', '2051', '441900', '3');
INSERT INTO `yoshop_region` VALUES ('3625', '石龙镇', '2051', '441900', '3');
INSERT INTO `yoshop_region` VALUES ('3626', '茶山镇', '2051', '441900', '3');
INSERT INTO `yoshop_region` VALUES ('3627', '石排镇', '2051', '441900', '3');
INSERT INTO `yoshop_region` VALUES ('3628', '企石镇', '2051', '441900', '3');
INSERT INTO `yoshop_region` VALUES ('3629', '横沥镇', '2051', '441900', '3');
INSERT INTO `yoshop_region` VALUES ('3630', '桥头镇', '2051', '441900', '3');
INSERT INTO `yoshop_region` VALUES ('3631', '谢岗镇', '2051', '441900', '3');
INSERT INTO `yoshop_region` VALUES ('3632', '东坑镇', '2051', '441900', '3');
INSERT INTO `yoshop_region` VALUES ('3633', '常平镇', '2051', '441900', '3');
INSERT INTO `yoshop_region` VALUES ('3634', '寮步镇', '2051', '441900', '3');
INSERT INTO `yoshop_region` VALUES ('3635', '樟木头镇', '2051', '441900', '3');
INSERT INTO `yoshop_region` VALUES ('3636', '大朗镇', '2051', '441900', '3');
INSERT INTO `yoshop_region` VALUES ('3637', '黄江镇', '2051', '441900', '3');
INSERT INTO `yoshop_region` VALUES ('3638', '清溪镇', '2051', '441900', '3');
INSERT INTO `yoshop_region` VALUES ('3639', '塘厦镇', '2051', '441900', '3');
INSERT INTO `yoshop_region` VALUES ('3640', '凤岗镇', '2051', '441900', '3');
INSERT INTO `yoshop_region` VALUES ('3641', '大岭山镇', '2051', '441900', '3');
INSERT INTO `yoshop_region` VALUES ('3642', '长安镇', '2051', '441900', '3');
INSERT INTO `yoshop_region` VALUES ('3643', '虎门镇', '2051', '441900', '3');
INSERT INTO `yoshop_region` VALUES ('3644', '厚街镇', '2051', '441900', '3');
INSERT INTO `yoshop_region` VALUES ('3645', '沙田镇', '2051', '441900', '3');
INSERT INTO `yoshop_region` VALUES ('3646', '道滘镇', '2051', '441900', '3');
INSERT INTO `yoshop_region` VALUES ('3647', '洪梅镇', '2051', '441900', '3');
INSERT INTO `yoshop_region` VALUES ('3648', '麻涌镇', '2051', '441900', '3');
INSERT INTO `yoshop_region` VALUES ('3649', '望牛墩镇', '2051', '441900', '3');
INSERT INTO `yoshop_region` VALUES ('3650', '中堂镇', '2051', '441900', '3');
INSERT INTO `yoshop_region` VALUES ('3651', '高埗镇', '2051', '441900', '3');
INSERT INTO `yoshop_region` VALUES ('3652', '松山湖', '2051', '441900', '3');
INSERT INTO `yoshop_region` VALUES ('3653', '东莞港', '2051', '441900', '3');
INSERT INTO `yoshop_region` VALUES ('3654', '东莞生态园', '2051', '441900', '3');
INSERT INTO `yoshop_region` VALUES ('3655', '石岐街道', '2052', '44200', '3');
INSERT INTO `yoshop_region` VALUES ('3656', '东区街道', '2052', '442000', '3');
INSERT INTO `yoshop_region` VALUES ('3657', '中山港街道', '2052', '442000', '3');
INSERT INTO `yoshop_region` VALUES ('3658', '西区街道', '2052', '442000', '3');
INSERT INTO `yoshop_region` VALUES ('3659', '南区街道', '2052', '442000', '3');
INSERT INTO `yoshop_region` VALUES ('3660', '五桂山街道', '2052', '442000', '3');
INSERT INTO `yoshop_region` VALUES ('3661', '小榄镇', '2052', '442000', '3');
INSERT INTO `yoshop_region` VALUES ('3662', '黄圃镇', '2052', '442000', '3');
INSERT INTO `yoshop_region` VALUES ('3663', '民众镇', '2052', '442000', '3');
INSERT INTO `yoshop_region` VALUES ('3664', '东凤镇', '2052', '442000', '3');
INSERT INTO `yoshop_region` VALUES ('3665', '东升镇', '2052', '442000', '3');
INSERT INTO `yoshop_region` VALUES ('3666', '古镇镇', '2052', '442000', '3');
INSERT INTO `yoshop_region` VALUES ('3667', '沙溪镇', '2052', '442000', '3');
INSERT INTO `yoshop_region` VALUES ('3668', '坦洲镇', '2052', '442000', '3');
INSERT INTO `yoshop_region` VALUES ('3669', '港口镇', '2052', '442000', '3');
INSERT INTO `yoshop_region` VALUES ('3670', '三角镇', '2052', '442000', '3');
INSERT INTO `yoshop_region` VALUES ('3671', '横栏镇', '2052', '442000', '3');
INSERT INTO `yoshop_region` VALUES ('3672', '南头镇', '2052', '442000', '3');
INSERT INTO `yoshop_region` VALUES ('3673', '阜沙镇', '2052', '442000', '3');
INSERT INTO `yoshop_region` VALUES ('3674', '南朗镇', '2052', '442000', '3');
INSERT INTO `yoshop_region` VALUES ('3675', '三乡镇', '2052', '442000', '3');
INSERT INTO `yoshop_region` VALUES ('3676', '板芙镇', '2052', '442000', '3');
INSERT INTO `yoshop_region` VALUES ('3677', '大涌镇', '2052', '442000', '3');
INSERT INTO `yoshop_region` VALUES ('3678', '神湾镇', '2052', '442000', '3');
INSERT INTO `yoshop_region` VALUES ('3679', '西沙群岛', '2206', '46032', '3');
INSERT INTO `yoshop_region` VALUES ('3680', '南沙群岛', '2206', '460322', '3');
INSERT INTO `yoshop_region` VALUES ('3681', '中沙群岛的岛礁及其海域', '2206', '460323', '3');
INSERT INTO `yoshop_region` VALUES ('3682', '那大镇', '2207', '46040', '3');
INSERT INTO `yoshop_region` VALUES ('3683', '和庆镇', '2207', '460400', '3');
INSERT INTO `yoshop_region` VALUES ('3684', '南丰镇', '2207', '460400', '3');
INSERT INTO `yoshop_region` VALUES ('3685', '大成镇', '2207', '460400', '3');
INSERT INTO `yoshop_region` VALUES ('3686', '雅星镇', '2207', '460400', '3');
INSERT INTO `yoshop_region` VALUES ('3687', '兰洋镇', '2207', '460400', '3');
INSERT INTO `yoshop_region` VALUES ('3688', '光村镇', '2207', '460400', '3');
INSERT INTO `yoshop_region` VALUES ('3689', '木棠镇', '2207', '460400', '3');
INSERT INTO `yoshop_region` VALUES ('3690', '海头镇', '2207', '460400', '3');
INSERT INTO `yoshop_region` VALUES ('3691', '峨蔓镇', '2207', '460400', '3');
INSERT INTO `yoshop_region` VALUES ('3692', '王五镇', '2207', '460400', '3');
INSERT INTO `yoshop_region` VALUES ('3693', '白马井镇', '2207', '460400', '3');
INSERT INTO `yoshop_region` VALUES ('3694', '中和镇', '2207', '460400', '3');
INSERT INTO `yoshop_region` VALUES ('3695', '排浦镇', '2207', '460400', '3');
INSERT INTO `yoshop_region` VALUES ('3696', '东成镇', '2207', '460400', '3');
INSERT INTO `yoshop_region` VALUES ('3697', '新州镇', '2207', '460400', '3');
INSERT INTO `yoshop_region` VALUES ('3698', '洋浦经济开发区', '2207', '460400', '3');
INSERT INTO `yoshop_region` VALUES ('3699', '华南热作学院', '2207', '460400', '3');
INSERT INTO `yoshop_region` VALUES ('3700', '雄关街道', '2922', '62020', '3');
INSERT INTO `yoshop_region` VALUES ('3701', '钢城街道', '2922', '620201', '3');
INSERT INTO `yoshop_region` VALUES ('3702', '新城镇', '2922', '620201', '3');
INSERT INTO `yoshop_region` VALUES ('3703', '峪泉镇', '2922', '620201', '3');
INSERT INTO `yoshop_region` VALUES ('3704', '文殊镇', '2922', '620201', '3');