INSERT INTO `sys_provinces` (`id`, `title`, `pid`, `short_title`, `areacode`, `zipcode`, `pinyin`, `lng`, `lat`, `level`, `tree`, `sort`) VALUES
(623021, '临潭县', 623000, '', 0, 0, 'L', '103.36053329624', '34.698639411522', 3, 'tr_0 tr_620000 tr_623000 ', 0),
(623022, '卓尼县', 623000, '', 0, 0, 'Z', '103.51361578396', '34.594916432804', 3, 'tr_0 tr_620000 tr_623000 ', 0),
(623023, '舟曲县', 623000, '', 0, 0, 'Z', '104.37748996239', '33.790814973644', 3, 'tr_0 tr_620000 tr_623000 ', 0),
(623024, '迭部县', 623000, '', 0, 0, 'D', '103.22844034558', '34.062020054097', 3, 'tr_0 tr_620000 tr_623000 ', 0),
(623025, '玛曲县', 623000, '', 0, 0, 'M', '102.07860004026', '34.003358168342', 3, 'tr_0 tr_620000 tr_623000 ', 0),
(623026, '碌曲县', 623000, '', 0, 0, 'L', '102.49442413371', '34.597087271566', 3, 'tr_0 tr_620000 tr_623000 ', 0),
(623027, '夏河县', 623000, '', 0, 0, 'X', '102.52857708038', '35.208324325541', 3, 'tr_0 tr_620000 tr_623000 ', 0),
(630000, '青海省', 0, '', 0, 0, 'Q', '101.78646183587', '36.627158579235', 1, 'tr_0 ', 0),
(630100, '西宁市', 630000, '', 0, 0, 'X', '101.78445017051', '36.623384696517', 2, 'tr_0 tr_630000 ', 0),
(630102, '城东区', 630100, '', 0, 0, 'C', '101.80956903833', '36.605707645661', 3, 'tr_0 tr_630000 tr_630100 ', 0),
(630103, '城中区', 630100, '', 0, 0, 'C', '101.79048354964', '36.628800570589', 3, 'tr_0 tr_630000 tr_630100 ', 0),
(630104, '城西区', 630100, '', 0, 0, 'C', '101.77241422413', '36.634496979524', 3, 'tr_0 tr_630000 tr_630100 ', 0),
(630105, '城北区', 630100, '', 0, 0, 'C', '101.77240488176', '36.656293630837', 3, 'tr_0 tr_630000 tr_630100 ', 0),
(630121, '大通回族土族自治县', 630100, '', 0, 0, 'D', '101.69256375752', '36.932666463407', 3, 'tr_0 tr_630000 tr_630100 ', 0),
(630122, '湟中县', 630100, '', 0, 0, 'H', '101.57861675782', '36.506627546281', 3, 'tr_0 tr_630000 tr_630100 ', 0),
(630123, '湟源县', 630100, '', 0, 0, 'H', '101.26244861154', '36.688587514903', 3, 'tr_0 tr_630000 tr_630100 ', 0),
(630200, '海东市', 630000, '', 0, 0, 'H', '102.11044407228', '36.508511080941', 2, 'tr_0 tr_630000 ', 0),
(630202, '乐都区', 630200, '', 0, 0, 'L', '102.40856633883', '36.487820051522', 3, 'tr_0 tr_630000 tr_630200 ', 0),
(630203, '平安区', 630200, '', 0, 0, 'P', '102.11442787756', '36.506553573162', 3, 'tr_0 tr_630000 tr_630200 ', 0),
(630222, '民和回族土族自治县', 630200, '', 0, 0, 'M', '102.11044407228', '36.508511080941', 3, 'tr_0 tr_630000 tr_630200 ', 0),
(630223, '互助土族自治县', 630200, '', 0, 0, 'H', '101.96456904899', '36.850021613826', 3, 'tr_0 tr_630000 tr_630200 ', 0),
(630224, '化隆回族自治县', 630200, '', 0, 0, 'H', '102.27044827345', '36.100988250893', 3, 'tr_0 tr_630000 tr_630200 ', 0),
(630225, '循化撒拉族自治县', 630200, '', 0, 0, 'X', '102.4953853206', '35.856667223862', 3, 'tr_0 tr_630000 tr_630200 ', 0),
(632200, '海北藏族自治州', 630000, '', 0, 0, 'H', '100.90743432146', '36.96066282413', 2, 'tr_0 tr_630000 ', 0),
(632221, '门源回族自治县', 632200, '', 0, 0, 'M', '101.62843803903', '37.382180626313', 3, 'tr_0 tr_630000 tr_632200 ', 0),
(632222, '祁连县', 632200, '', 0, 0, 'Q', '100.25962157243', '38.182924871569', 3, 'tr_0 tr_630000 tr_632200 ', 0),
(632223, '海晏县', 632200, '', 0, 0, 'H', '101.0005855486', '36.902376022515', 3, 'tr_0 tr_630000 tr_632200 ', 0),
(632224, '刚察县', 632200, '', 0, 0, 'G', '100.15360607139', '37.327320072254', 3, 'tr_0 tr_630000 tr_632200 ', 0),
(632300, '黄南藏族自治州', 630000, '', 0, 0, 'H', '102.02242827808', '35.525804586516', 2, 'tr_0 tr_630000 ', 0),
(632321, '同仁县', 632300, '', 0, 0, 'T', '102.0254377812', '35.521865150524', 3, 'tr_0 tr_630000 tr_632300 ', 0),
(632322, '尖扎县', 632300, '', 0, 0, 'J', '102.0375073242', '35.944284459868', 3, 'tr_0 tr_630000 tr_632300 ', 0),
(632323, '泽库县', 632300, '', 0, 0, 'Z', '101.47359451319', '35.0420144951', 3, 'tr_0 tr_630000 tr_632300 ', 0),
(632324, '河南蒙古族自治县', 632300, '', 0, 0, 'H', '101.62247338027', '34.740396071091', 3, 'tr_0 tr_630000 tr_632300 ', 0),
(632500, '海南藏族自治州', 630000, '', 0, 0, 'H', '100.62662114446', '36.292102479899', 2, 'tr_0 tr_630000 ', 0),
(632521, '共和县', 632500, '', 0, 0, 'G', '100.62662348005', '36.288703317865', 3, 'tr_0 tr_630000 tr_632500 ', 0),
(632522, '同德县', 632500, '', 0, 0, 'T', '100.58542386564', '35.259857775817', 3, 'tr_0 tr_630000 tr_632500 ', 0),
(632523, '贵德县', 632500, '', 0, 0, 'G', '101.43953310384', '36.046158080751', 3, 'tr_0 tr_630000 tr_632500 ', 0),
(632524, '兴海县', 632500, '', 0, 0, 'X', '99.994380072293', '35.594629879949', 3, 'tr_0 tr_630000 tr_632500 ', 0),
(632525, '贵南县', 632500, '', 0, 0, 'G', '100.75359321473', '35.592415454611', 3, 'tr_0 tr_630000 tr_632500 ', 0),
(632600, '果洛藏族自治州', 630000, '', 0, 0, 'G', '100.2515919788', '34.477193866471', 2, 'tr_0 tr_630000 ', 0),
(632621, '玛沁县', 632600, '', 0, 0, 'M', '100.24556434882', '34.483569486002', 3, 'tr_0 tr_630000 tr_632600 ', 0),
(632622, '班玛县', 632600, '', 0, 0, 'B', '100.74360459645', '32.93850392747', 3, 'tr_0 tr_630000 tr_632600 ', 0),
(632623, '甘德县', 632600, '', 0, 0, 'G', '99.907510695578', '33.975003677602', 3, 'tr_0 tr_630000 tr_632600 ', 0),
(632624, '达日县', 632600, '', 0, 0, 'D', '99.658010113065', '33.754937373991', 3, 'tr_0 tr_630000 tr_632600 ', 0),
(632625, '久治县', 632600, '', 0, 0, 'J', '101.48853225585', '33.434773499408', 3, 'tr_0 tr_630000 tr_632600 ', 0),
(632626, '玛多县', 632600, '', 0, 0, 'M', '98.215883832099', '34.920748646186', 3, 'tr_0 tr_630000 tr_632600 ', 0),
(632700, '玉树藏族自治州', 630000, '', 0, 0, 'Y', '97.013180762773', '33.010979585143', 2, 'tr_0 tr_630000 ', 0),
(632701, '玉树市', 632700, '', 0, 0, 'Y', '97.015376401101', '32.999555650886', 3, 'tr_0 tr_630000 tr_632700 ', 0),
(632722, '杂多县', 632700, '', 0, 0, 'Z', '95.306964878828', '32.89924067586', 3, 'tr_0 tr_630000 tr_632700 ', 0),
(632723, '称多县', 632700, '', 0, 0, 'C', '97.115000009277', '33.374225698944', 3, 'tr_0 tr_630000 tr_632700 ', 0),
(632724, '治多县', 632700, '', 0, 0, 'Z', '95.61979357437', '33.857953267719', 3, 'tr_0 tr_630000 tr_632700 ', 0),
(632725, '囊谦县', 632700, '', 0, 0, 'N', '96.486918271283', '32.209194368698', 3, 'tr_0 tr_630000 tr_632700 ', 0),
(632726, '曲麻莱县', 632700, '', 0, 0, 'Q', '95.803750013992', '34.132298666997', 3, 'tr_0 tr_630000 tr_632700 ', 0),
(632800, '海西蒙古族藏族自治州', 630000, '', 0, 0, 'H', '97.376299116019', '37.382750462527', 2, 'tr_0 tr_630000 ', 0),
(632801, '格尔木市', 632800, '', 0, 0, 'G', '94.933310210425', '36.412371046954', 3, 'tr_0 tr_630000 tr_632800 ', 0),
(632802, '德令哈市', 632800, '', 0, 0, 'D', '97.367470299975', '37.375345907463', 3, 'tr_0 tr_630000 tr_632800 ', 0),
(632803, '茫崖市', 632800, '', 0, 0, 'M', '90.87951750334', '38.261902814972', 3, 'tr_0 tr_630000 tr_632800 ', 0),
(632821, '乌兰县', 632800, '', 0, 0, 'W', '98.486735699295', '36.935747859032', 3, 'tr_0 tr_630000 tr_632800 ', 0),
(632822, '都兰县', 632800, '', 0, 0, 'D', '98.102704793777', '36.307611028682', 3, 'tr_0 tr_630000 tr_632800 ', 0),
(632823, '天峻县', 632800, '', 0, 0, 'T', '99.029242967967', '37.306903395111', 3, 'tr_0 tr_630000 tr_632800 ', 0),
(632857, '大柴旦行政委员会', 632800, '', 0, 0, 'D', '95.371722465415', '37.857987655919', 3, 'tr_0 tr_630000 tr_632800 ', 0),
(640000, '宁夏回族自治区', 0, '', 0, 0, 'N', '106.26560480701', '38.476877967911', 1, 'tr_0 ', 0),
(640100, '银川市', 640000, '', 0, 0, 'Y', '106.2384935874', '38.49246005551', 2, 'tr_0 tr_640000 ', 0),
(640104, '兴庆区', 640100, '', 0, 0, 'X', '106.29549376692', '38.479578929456', 3, 'tr_0 tr_640000 tr_640100 ', 0),
(640105, '西夏区', 640100, '', 0, 0, 'X', '106.15658124015', '38.496817469604', 3, 'tr_0 tr_640000 tr_640100 ', 0),
(640106, '金凤区', 640100, '', 0, 0, 'J', '106.24956089094', '38.478695238722', 3, 'tr_0 tr_640000 tr_640100 ', 0),
(640121, '永宁县', 640100, '', 0, 0, 'Y', '106.25960457536', '38.283001541521', 3, 'tr_0 tr_640000 tr_640100 ', 0),
(640122, '贺兰县', 640100, '', 0, 0, 'H', '106.3565182653', '38.560406689579', 3, 'tr_0 tr_640000 tr_640100 ', 0),
(640181, '灵武市', 640100, '', 0, 0, 'L', '106.34644035545', '38.108658666793', 3, 'tr_0 tr_640000 tr_640100 ', 0),
(640200, '石嘴山市', 640000, '', 0, 0, 'S', '106.3906004255', '38.989682839915', 2, 'tr_0 tr_640000 ', 0),
(640202, '大武口区', 640200, '', 0, 0, '', '', '', 3, 'tr_0 tr_640000 tr_640200 ', 0),
(640205, '惠农区', 640200, '', 0, 0, '', '', '', 3, 'tr_0 tr_640000 tr_640200 ', 0),
(640221, '平罗县', 640200, '', 0, 0, '', '', '', 3, 'tr_0 tr_640000 tr_640200 ', 0),
(640300, '吴忠市', 640000, '', 0, 0, 'W', '106.20537126664', '38.003712913453', 2, 'tr_0 tr_640000 ', 0),
(640302, '利通区', 640300, '', 0, 0, 'L', '106.21940702074', '37.990746080857', 3, 'tr_0 tr_640000 tr_640300 ', 0),
(640303, '红寺堡区', 640300, '', 0, 0, 'H', '106.06842117808', '37.431882454446', 3, 'tr_0 tr_640000 tr_640300 ', 0),
(640323, '盐池县', 640300, '', 0, 0, 'Y', '107.41337954864', '37.789295649909', 3, 'tr_0 tr_640000 tr_640300 ', 0),
(640324, '同心县', 640300, '', 0, 0, 'T', '105.9205990776', '36.986269629165', 3, 'tr_0 tr_640000 tr_640300 ', 0),
(640381, '青铜峡市', 640300, '', 0, 0, 'Q', '106.08537031661', '38.027412223967', 3, 'tr_0 tr_640000 tr_640300 ', 0),
(640400, '固原市', 640000, '', 0, 0, 'G', '106.24857742607', '36.021617258011', 2, 'tr_0 tr_640000 ', 0),
(640402, '原州区', 640400, '', 0, 0, 'Y', '106.29451461392', '36.009367675763', 3, 'tr_0 tr_640000 tr_640400 ', 0),
(640422, '西吉县', 640400, '', 0, 0, 'X', '105.73538590857', '35.97007642089', 3, 'tr_0 tr_640000 tr_640400 ', 0),
(640423, '隆德县', 640400, '', 0, 0, 'L', '106.1184982967', '35.631762315094', 3, 'tr_0 tr_640000 tr_640400 ', 0),
(640424, '泾源县', 640400, '', 0, 0, 'J', '106.33739343083', '35.504361637679', 3, 'tr_0 tr_640000 tr_640400 ', 0),
(640425, '彭阳县', 640400, '', 0, 0, 'P', '106.64454429656', '35.85540546349', 3, 'tr_0 tr_640000 tr_640400 ', 0),
(640500, '中卫市', 640000, '', 0, 0, 'Z', '105.20357090089', '37.505701418703', 2, 'tr_0 tr_640000 ', 0),
(640502, '沙坡头区', 640500, '', 0, 0, 'S', '105.20357090089', '37.505701418703', 3, 'tr_0 tr_640000 tr_640500 ', 0),
(640521, '中宁县', 640500, '', 0, 0, 'Z', '105.6915371912', '37.497420805579', 3, 'tr_0 tr_640000 tr_640500 ', 0),
(640522, '海原县', 640500, '', 0, 0, 'H', '105.65055514638', '36.570781489719', 3, 'tr_0 tr_640000 tr_640500 ', 0),
(650000, '新疆维吾尔自治区', 0, '', 0, 0, 'X', '87.633473205738', '43.79923810129', 1, 'tr_0 ', 0),
(650100, '乌鲁木齐市', 650000, '', 0, 0, 'W', '87.62443993536', '43.83076320429', 2, 'tr_0 tr_650000 ', 0),
(650102, '天山区', 650100, '', 0, 0, 'T', '87.638407777566', '43.800271358313', 3, 'tr_0 tr_650000 tr_650100 ', 0),
(650103, '沙依巴克区', 650100, '', 0, 0, 'S', '87.604670027697', '43.807262352761', 3, 'tr_0 tr_650000 tr_650100 ', 0),
(650104, '新市区', 650100, '', 0, 0, 'X', '87.575908441201', '43.861394002748', 3, 'tr_0 tr_650000 tr_650100 ', 0),
(650105, '水磨沟区', 650100, '', 0, 0, 'S', '87.648896662192', '43.838251163831', 3, 'tr_0 tr_650000 tr_650100 ', 0),
(650106, '头屯河区', 650100, '', 0, 0, 'T', '87.434506709858', '43.882653022602', 3, 'tr_0 tr_650000 tr_650100 ', 0),
(650107, '达坂城区', 650100, '', 0, 0, 'D', '88.317397656607', '43.36994274634', 3, 'tr_0 tr_650000 tr_650100 ', 0),
(650109, '米东区', 650100, '', 0, 0, 'M', '87.662134271848', '43.979247426398', 3, 'tr_0 tr_650000 tr_650100 ', 0),
(650121, '乌鲁木齐县', 650100, '', 0, 0, 'W', '87.416028745179', '43.477086065793', 3, 'tr_0 tr_650000 tr_650100 ', 0),
(650171, '乌鲁木齐经济技术开发区', 650100, '', 0, 0, 'W', '87.523118529771', '43.868981036009', 3, 'tr_0 tr_650000 tr_650100 ', 0),
(650172, '乌鲁木齐高新技术产业开发区', 650100, '', 0, 0, 'W', '87.58408445863', '43.87767236981', 3, 'tr_0 tr_650000 tr_650100 ', 0),
(650200, '克拉玛依市', 650000, '', 0, 0, 'K', '84.895900538875', '45.585675237814', 2, 'tr_0 tr_650000 ', 0),
(650202, '独山子区', 650200, '', 0, 0, 'D', '84.893613283343', '44.334407392365', 3, 'tr_0 tr_650000 tr_650200 ', 0),
(650203, '克拉玛依区', 650200, '', 0, 0, 'K', '84.866221962114', '45.596624206981', 3, 'tr_0 tr_650000 tr_650200 ', 0),
(650204, '白碱滩区', 650200, '', 0, 0, 'B', '85.139510123686', '45.693951629764', 3, 'tr_0 tr_650000 tr_650200 ', 0),
(650205, '乌尔禾区', 650200, '', 0, 0, 'W', '85.700304826442', '46.095295184689', 3, 'tr_0 tr_650000 tr_650200 ', 0),
(650400, '吐鲁番市', 650000, '', 0, 0, 'T', '89.266025488642', '42.678924820794', 2, 'tr_0 tr_650000 ', 0),
(650402, '高昌区', 650400, '', 0, 0, 'G', '89.192458882701', '42.948548691684', 3, 'tr_0 tr_650000 tr_650400 ', 0),
(650421, '鄯善县', 650400, '', 0, 0, 'S', '90.220093886103', '42.874759228479', 3, 'tr_0 tr_650000 tr_650400 ', 0),
(650422, '托克逊县', 650400, '', 0, 0, 'T', '88.660164359541', '42.798545831023', 3, 'tr_0 tr_650000 tr_650400 ', 0),
(650500, '哈密市', 650000, '', 0, 0, 'H', '93.529373012389', '42.344467104552', 2, 'tr_0 tr_650000 ', 0),
(650502, '伊州区', 650500, '', 0, 0, 'Y', '93.521320462369', '42.832824924721', 3, 'tr_0 tr_650000 tr_650500 ', 0),
(650521, '巴里坤哈萨克自治县', 650500, '', 0, 0, 'B', '93.022930953564', '43.605688770787', 3, 'tr_0 tr_650000 tr_650500 ', 0),
(650522, '伊吾县', 650500, '', 0, 0, 'Y', '94.703825671285', '43.260676527466', 3, 'tr_0 tr_650000 tr_650500 ', 0),
(652300, '昌吉回族自治州', 650000, '', 0, 0, 'C', '87.315001624474', '44.01685415992', 2, 'tr_0 tr_650000 ', 0),
(652301, '昌吉市', 652300, '', 0, 0, 'C', '87.27386462195', '44.020126845939', 3, 'tr_0 tr_650000 tr_652300 ', 0),
(652302, '阜康市', 652300, '', 0, 0, 'F', '87.993677905062', '44.163137321346', 3, 'tr_0 tr_650000 tr_652300 ', 0),
(652323, '呼图壁县', 652300, '', 0, 0, 'H', '86.905143806731', '44.197654596132', 3, 'tr_0 tr_650000 tr_652300 ', 0),
(652324, '玛纳斯县', 652300, '', 0, 0, 'M', '86.220643452199', '44.3100628588', 3, 'tr_0 tr_650000 tr_652300 ', 0),
(652325, '奇台县', 652300, '', 0, 0, 'Q', '89.601080811724', '44.026897819018', 3, 'tr_0 tr_650000 tr_652300 ', 0),
(652327, '吉木萨尔县', 652300, '', 0, 0, 'J', '89.187122858141', '44.005717795203', 3, 'tr_0 tr_650000 tr_652300 ', 0),
(652328, '木垒哈萨克自治县', 652300, '', 0, 0, 'M', '90.292514737334', '43.840308302807', 3, 'tr_0 tr_650000 tr_652300 ', 0),
(652700, '博尔塔拉蒙古自治州', 650000, '', 0, 0, 'B', '82.072914758274', '44.912196413465', 2, 'tr_0 tr_650000 ', 0),
(652701, '博乐市', 652700, '', 0, 0, 'B', '82.057972254591', '44.860009784639', 3, 'tr_0 tr_650000 tr_652700 ', 0),
(652702, '阿拉山口市', 652700, '', 0, 0, 'A', '82.560725272438', '45.179670079921', 3, 'tr_0 tr_650000 tr_652700 ', 0),
(652722, '精河县', 652700, '', 0, 0, 'J', '82.900655316205', '44.606645943492', 3, 'tr_0 tr_650000 tr_652700 ', 0),
(652723, '温泉县', 652700, '', 0, 0, 'W', '81.031145546486', '44.974856638705', 3, 'tr_0 tr_650000 tr_652700 ', 0),
(652800, '巴音郭楞蒙古自治州', 650000, '', 0, 0, 'B', '86.151713865333', '41.77028733045', 2, 'tr_0 tr_650000 ', 0),
(652801, '库尔勒市', 652800, '', 0, 0, 'K', '86.181494309938', '41.732373221412', 3, 'tr_0 tr_650000 tr_652800 ', 0),
(652822, '轮台县', 652800, '', 0, 0, 'L', '84.258212152054', '41.783813000515', 3, 'tr_0 tr_650000 tr_652800 ', 0),
(652823, '尉犁县', 652800, '', 0, 0, 'W', '86.266036536399', '41.350122782054', 3, 'tr_0 tr_650000 tr_652800 ', 0),
(652824, '若羌县', 652800, '', 0, 0, 'R', '88.175324441896', '39.028991037175', 3, 'tr_0 tr_650000 tr_652800 ', 0),
(652825, '且末县', 652800, '', 0, 0, 'Q', '85.535990385731', '38.15138769413', 3, 'tr_0 tr_650000 tr_652800 ', 0),
(652826, '焉耆回族自治县', 652800, '', 0, 0, 'Y', '86.581222026277', '42.064850858728', 3, 'tr_0 tr_650000 tr_652800 ', 0),
(652827, '和静县', 652800, '', 0, 0, 'H', '86.390398220692', '42.329365035879', 3, 'tr_0 tr_650000 tr_652800 ', 0),
(652828, '和硕县', 652800, '', 0, 0, 'H', '86.883689037252', '42.288065062428', 3, 'tr_0 tr_650000 tr_652800 ', 0),
(652829, '博湖县', 652800, '', 0, 0, 'B', '86.638469149986', '41.986430356829', 3, 'tr_0 tr_650000 tr_652800 ', 0),
(652871, '库尔勒经济技术开发区', 652800, '', 0, 0, 'K', '86.229512961483', '41.71760888729', 3, 'tr_0 tr_650000 tr_652800 ', 0),
(652900, '阿克苏地区', 650000, '', 0, 0, 'A', '80.266943484735', '41.175029860077', 2, 'tr_0 tr_650000 ', 0),
(652901, '阿克苏市', 652900, '', 0, 0, 'A', '80.269926757334', '41.173859926953', 3, 'tr_0 tr_650000 tr_652900 ', 0),
(652922, '温宿县', 652900, '', 0, 0, 'W', '80.245564352581', '41.282567249887', 3, 'tr_0 tr_650000 tr_652900 ', 0),
(652923, '库车县', 652900, '', 0, 0, 'K', '82.968458787284', '41.723447514833', 3, 'tr_0 tr_650000 tr_652900 ', 0),
(652924, '沙雅县', 652900, '', 0, 0, 'S', '82.788823736148', '41.227749329027', 3, 'tr_0 tr_650000 tr_652900 ', 0),
(652925, '新和县', 652900, '', 0, 0, 'X', '82.615823030526', '41.553999628477', 3, 'tr_0 tr_650000 tr_652900 ', 0),
(652926, '拜城县', 652900, '', 0, 0, 'B', '81.858516272038', '41.800706601984', 3, 'tr_0 tr_650000 tr_652900 ', 0),
(652927, '乌什县', 652900, '', 0, 0, 'W', '79.230868990897', '41.220871106999', 3, 'tr_0 tr_650000 tr_652900 ', 0),
(652928, '阿瓦提县', 652900, '', 0, 0, 'A', '80.381849245908', '40.649358802911', 3, 'tr_0 tr_650000 tr_652900 ', 0),
(652929, '柯坪县', 652900, '', 0, 0, 'K', '79.053213535614', '40.514055520966', 3, 'tr_0 tr_650000 tr_652900 ', 0),
(653000, '克孜勒苏柯尔克孜自治州', 650000, '', 0, 0, 'K', '76.174308676212', '39.720471204871', 2, 'tr_0 tr_650000 ', 0),
(653001, '阿图什市', 653000, '', 0, 0, 'A', '76.174906408698', '39.722079128589', 3, 'tr_0 tr_650000 tr_653000 ', 0),
(653022, '阿克陶县', 653000, '', 0, 0, 'A', '75.953725266709', '39.153888517642', 3, 'tr_0 tr_650000 tr_653000 ', 0),
(653023, '阿合奇县', 653000, '', 0, 0, 'A', '78.45253927839', '40.942958224222', 3, 'tr_0 tr_650000 tr_653000 ', 0),
(653024, '乌恰县', 653000, '', 0, 0, 'W', '75.26533363237', '39.725123590953', 3, 'tr_0 tr_650000 tr_653000 ', 0),
(653100, '喀什地区', 650000, '', 0, 0, 'K', '75.996390556397', '39.476096748645', 2, 'tr_0 tr_650000 ', 0),
(653101, '喀什市', 653100, '', 0, 0, 'K', '76.000312737915', '39.473649532912', 3, 'tr_0 tr_650000 tr_653100 ', 0),
(653121, '疏附县', 653100, '', 0, 0, 'S', '75.869168667361', '39.381291555212', 3, 'tr_0 tr_650000 tr_653100 ', 0),
(653122, '疏勒县', 653100, '', 0, 0, 'S', '76.056614395075', '39.406709108732', 3, 'tr_0 tr_650000 tr_653100 ', 0),
(653123, '英吉沙县', 653100, '', 0, 0, 'Y', '76.182075425651', '38.935670863521', 3, 'tr_0 tr_650000 tr_653100 ', 0),
(653124, '泽普县', 653100, '', 0, 0, 'Z', '77.266559423761', '38.190725516333', 3, 'tr_0 tr_650000 tr_653100 ', 0),
(653125, '莎车县', 653100, '', 0, 0, 'S', '77.252436713686', '38.420156752419', 3, 'tr_0 tr_650000 tr_653100 ', 0),
(653126, '叶城县', 653100, '', 0, 0, 'Y', '77.420097621865', '37.889166844427', 3, 'tr_0 tr_650000 tr_653100 ', 0),
(653127, '麦盖提县', 653100, '', 0, 0, 'M', '77.658824287414', '38.911194315553', 3, 'tr_0 tr_650000 tr_653100 ', 0),
(653128, '岳普湖县', 653100, '', 0, 0, 'Y', '76.78414771574', '39.239387333945', 3, 'tr_0 tr_650000 tr_653100 ', 0),
(653129, '伽师县', 653100, '', 0, 0, 'J', '76.730385568257', '39.493851605868', 3, 'tr_0 tr_650000 tr_653100 ', 0),
(653130, '巴楚县', 653100, '', 0, 0, 'B', '78.5557014018', '39.79078837708', 3, 'tr_0 tr_650000 tr_653100 ', 0),
(653131, '塔什库尔干塔吉克自治县', 653100, '', 0, 0, 'T', '75.230804744838', '37.779045640763', 3, 'tr_0 tr_650000 tr_653100 ', 0),
(653200, '和田地区', 650000, '', 0, 0, 'H', '79.928507063512', '37.120446463042', 2, 'tr_0 tr_650000 ', 0),
(653201, '和田市', 653200, '', 0, 0, 'H', '79.920212469755', '37.118335544466', 3, 'tr_0 tr_650000 tr_653200 ', 0),
(653221, '和田县', 653200, '', 0, 0, 'H', '79.866215595042', '37.090362410221', 3, 'tr_0 tr_650000 tr_653200 ', 0),
(653222, '墨玉县', 653200, '', 0, 0, 'M', '79.735479265358', '37.282993446907', 3, 'tr_0 tr_650000 tr_653200 ', 0),
(653223, '皮山县', 653200, '', 0, 0, 'P', '78.289871062405', '37.627248714375', 3, 'tr_0 tr_650000 tr_653200 ', 0),
(653224, '洛浦县', 653200, '', 0, 0, 'L', '80.195387611879', '37.079611030988', 3, 'tr_0 tr_650000 tr_653200 ', 0),
(653225, '策勒县', 653200, '', 0, 0, 'C', '80.813201268742', '37.004122359371', 3, 'tr_0 tr_650000 tr_653200 ', 0),
(653226, '于田县', 653200, '', 0, 0, 'Y', '81.683782914748', '36.86295413611', 3, 'tr_0 tr_650000 tr_653200 ', 0),
(653227, '民丰县', 653200, '', 0, 0, 'M', '82.702713427589', '37.070256968231', 3, 'tr_0 tr_650000 tr_653200 ', 0),
(654000, '伊犁哈萨克自治州', 650000, '', 0, 0, 'Y', '81.330537747532', '43.922723137492', 2, 'tr_0 tr_650000 ', 0),
(654002, '伊宁市', 654000, '', 0, 0, 'Y', '81.284242405278', '43.915299436243', 3, 'tr_0 tr_650000 tr_654000 ', 0),
(654003, '奎屯市', 654000, '', 0, 0, 'K', '84.909449241687', '44.432057210004', 3, 'tr_0 tr_650000 tr_654000 ', 0),
(654004, '霍尔果斯市', 654000, '', 0, 0, 'H', '80.427129772427', '44.235308556093', 3, 'tr_0 tr_650000 tr_654000 ', 0),
(654021, '伊宁县', 654000, '', 0, 0, 'Y', '81.533906479394', '43.982909125124', 3, 'tr_0 tr_650000 tr_654000 ', 0),
(654022, '察布查尔锡伯自治县', 654000, '', 0, 0, 'C', '81.157924570907', '43.846690330452', 3, 'tr_0 tr_650000 tr_654000 ', 0),
(654023, '霍城县', 654000, '', 0, 0, 'H', '80.885281123201', '44.062249507399', 3, 'tr_0 tr_650000 tr_654000 ', 0),
(654024, '巩留县', 654000, '', 0, 0, 'G', '82.238225609409', '43.488485559536', 3, 'tr_0 tr_650000 tr_654000 ', 0),
(654025, '新源县', 654000, '', 0, 0, 'X', '83.267022301497', '43.435927002185', 3, 'tr_0 tr_650000 tr_654000 ', 0),
(654026, '昭苏县', 654000, '', 0, 0, 'Z', '81.137377539147', '43.163496741509', 3, 'tr_0 tr_650000 tr_654000 ', 0),
(654027, '特克斯县', 654000, '', 0, 0, 'T', '81.842587249244', '43.224248213467', 3, 'tr_0 tr_650000 tr_654000 ', 0),
(654028, '尼勒克县', 654000, '', 0, 0, 'N', '82.51800753168', '43.804594836238', 3, 'tr_0 tr_650000 tr_654000 ', 0),
(654200, '塔城地区', 650000, '', 0, 0, 'T', '82.987235518406', '46.750948254373', 2, 'tr_0 tr_650000 ', 0),
(654201, '塔城市', 654200, '', 0, 0, 'T', '82.987235518406', '46.750948254373', 3, 'tr_0 tr_650000 tr_654200 ', 0),
(654202, '乌苏市', 654200, '', 0, 0, 'W', '84.720088146964', '44.424048034452', 3, 'tr_0 tr_650000 tr_654200 ', 0),
(654221, '额敏县', 654200, '', 0, 0, 'E', '83.633374454783', '46.531884861309', 3, 'tr_0 tr_650000 tr_654200 ', 0),
(654223, '沙湾县', 654200, '', 0, 0, 'S', '85.626144686035', '44.331949461741', 3, 'tr_0 tr_650000 tr_654200 ', 0),
(654224, '托里县', 654200, '', 0, 0, 'T', '83.612909438315', '45.94274280505', 3, 'tr_0 tr_650000 tr_654200 ', 0),
(654225, '裕民县', 654200, '', 0, 0, 'Y', '82.9894387025', '46.207453546928', 3, 'tr_0 tr_650000 tr_654200 ', 0),
(654226, '和布克赛尔蒙古自治县', 654200, '', 0, 0, 'H', '85.735008883548', '46.798685112637', 3, 'tr_0 tr_650000 tr_654200 ', 0),
(654300, '阿勒泰地区', 650000, '', 0, 0, 'A', '88.147926203735', '47.850727870102', 2, 'tr_0 tr_650000 ', 0),
(654301, '阿勒泰市', 654300, '', 0, 0, 'A', '88.139226564024', '47.832752648475', 3, 'tr_0 tr_650000 tr_654300 ', 0),
(654321, '布尔津县', 654300, '', 0, 0, 'B', '86.881360170273', '47.707951723888', 3, 'tr_0 tr_650000 tr_654300 ', 0),
(654322, '富蕴县', 654300, '', 0, 0, 'F', '89.531953408055', '46.999951053055', 3, 'tr_0 tr_650000 tr_654300 ', 0),
(654323, '福海县', 654300, '', 0, 0, 'F', '87.493157246325', '47.118140737535', 3, 'tr_0 tr_650000 tr_654300 ', 0),
(654324, '哈巴河县', 654300, '', 0, 0, 'H', '86.424817684664', '48.066148902458', 3, 'tr_0 tr_650000 tr_654300 ', 0),
(654325, '青河县', 654300, '', 0, 0, 'Q', '90.389444407193', '46.68019396705', 3, 'tr_0 tr_650000 tr_654300 ', 0),
(654326, '吉木乃县', 654300, '', 0, 0, 'J', '85.880818240706', '47.449018413257', 3, 'tr_0 tr_650000 tr_654300 ', 0),
(659000, '自治区直辖县级行政区划', 650000, '', 0, 0, 'Z', '87.633473205738', '43.79923810129', 2, 'tr_0 tr_650000 ', 0),
(659001, '石河子市', 659000, '', 0, 0, 'S', '114.5163190347', '36.772534944449', 3, 'tr_0 tr_650000 tr_659000 ', 0),
(659002, '阿拉尔市', 659000, '', 0, 0, 'A', '81.287354225395', '40.553263894706', 3, 'tr_0 tr_650000 tr_659000 ', 0),
(659003, '图木舒克市', 659000, '', 0, 0, 'T', '79.075616286896', '39.871209077425', 3, 'tr_0 tr_650000 tr_659000 ', 0),
(659004, '五家渠市', 659000, '', 0, 0, 'W', '87.549936632296', '44.172444518901', 3, 'tr_0 tr_650000 tr_659000 ', 0),
(659006, '铁门关市', 659000, '', 0, 0, 'T', '85.686857831724', '41.863648697693', 3, 'tr_0 tr_650000 tr_659000 ', 0),
(810000, '香港特别行政区', 0, '', 0, 0, 'X', '114.18612410257', '22.29358599328', 1, 'tr_0 ', 0),
(810100, '九龙', 810000, '', 0, 0, 'J', '101.51341566718', '29.006431902925', 2, 'tr_0 tr_810000 ', 0),
(810101, '观塘区', 810100, '', 0, 0, 'G', '114.23743100142', '22.316803500017', 3, 'tr_0 tr_810000 tr_810100 ', 0),
(810102, '黄大仙区', 810100, '', 0, 0, 'H', '114.2055528338', '22.344516581114', 3, 'tr_0 tr_810000 tr_810100 ', 0),
(810103, '九龙城区', 810100, '', 0, 0, 'J', '114.19855413557', '22.325722838593', 3, 'tr_0 tr_810000 tr_810100 ', 0),
(810104, '深水埗区', 810100, '', 0, 0, 'S', '114.17556515012', '22.334814518942', 3, 'tr_0 tr_810000 tr_810100 ', 0),
(810105, '油尖旺区', 810100, '', 0, 0, 'Y', '114.17854456', '22.306583887776', 3, 'tr_0 tr_810000 tr_810100 ', 0),
(810200, '香港岛', 810000, '', 0, 0, 'X', '114.1838696432', '22.272099587606', 2, 'tr_0 tr_810000 ', 0),
(810201, '东区', 810200, '', 0, 0, 'D', '114.03675495515', '32.983906128946', 3, 'tr_0 tr_810000 tr_810200 ', 0),
(810202, '南区', 810200, '', 0, 0, 'N', '114.18612410257', '22.29358599328', 3, 'tr_0 tr_810000 tr_810200 ', 0),
(810203, '湾仔区', 810200, '', 0, 0, 'W', '114.1838696432', '22.272099587606', 3, 'tr_0 tr_810000 tr_810200 ', 0),
(810204, '中西区', 810200, '', 0, 0, 'Z', '114.15949141031', '22.291342714292', 3, 'tr_0 tr_810000 tr_810200 ', 0),
(810300, '新界', 810000, '', 0, 0, 'X', '114.18612410257', '22.29358599328', 2, 'tr_0 tr_810000 ', 0),
(810301, '北区', 810300, '', 0, 0, 'B', '114.56208137457', '38.029818054403', 3, 'tr_0 tr_810000 tr_810300 ', 0),
(810302, '大埔区', 810300, '', 0, 0, 'D', '114.14670082713', '22.427434108219', 3, 'tr_0 tr_810000 tr_810300 ', 0),
(810303, '葵青区', 810300, '', 0, 0, 'K', '114.14347453324', '22.36661881253', 3, 'tr_0 tr_810000 tr_810300 ', 0),
(810304, '离岛区', 810300, '', 0, 0, 'L', '113.95154733906', '22.286066480198', 3, 'tr_0 tr_810000 tr_810300 ', 0),
(810305, '荃湾区', 810300, '', 0, 0, 'Q', '114.126440954', '22.378243962528', 3, 'tr_0 tr_810000 tr_810300 ', 0),
(810306, '沙田区', 810300, '', 0, 0, 'S', '114.19855144065', '22.388522255034', 3, 'tr_0 tr_810000 tr_810300 ', 0),
(810307, '屯门区', 810300, '', 0, 0, 'T', '113.98745602385', '22.393584799271', 3, 'tr_0 tr_810000 tr_810300 ', 0),
(810308, '西贡区', 810300, '', 0, 0, 'X', '114.28352485373', '22.385077305939', 3, 'tr_0 tr_810000 tr_810300 ', 0),
(810309, '元朗区', 810300, '', 0, 0, 'Y', '114.03850969037', '22.448564780865', 3, 'tr_0 tr_810000 tr_810300 ', 0),
(820000, '澳门特别行政区', 0, '', 0, 0, 'A', '113.55751910182', '22.204117988443', 1, 'tr_0 ', 0),
(820100, '离岛', 820000, '', 0, 0, 'L', '113.55751910182', '22.204117988443', 2, 'tr_0 tr_820000 ', 0),
(820101, '嘉模堂区', 820100, '', 0, 0, 'J', '113.56551473951', '22.163142309955', 3, 'tr_0 tr_820000 tr_820100 ', 0),
(820102, '路氹填海区', 820100, '', 0, 0, 'L', '113.95154733906', '22.286066480198', 3, 'tr_0 tr_820000 tr_820100 ', 0),
(820103, '圣方济各堂区', 820100, '', 0, 0, 'S', '113.95154733906', '22.286066480198', 3, 'tr_0 tr_820000 tr_820100 ', 0),
(820200, '澳门半岛', 820000, '', 0, 0, 'A', '113.56643233517', '22.195004159218', 2, 'tr_0 tr_820000 ', 0),
(820201, '大堂区', 820200, '', 0, 0, 'D', '113.55648488269', '22.18919700752', 3, 'tr_0 tr_820000 tr_820200 ', 0),
(820202, '风顺堂区', 820200, '', 0, 0, 'F', '113.54545108595', '22.192783044934', 3, 'tr_0 tr_820000 tr_820200 ', 0),
(820203, '花地玛堂区', 820200, '', 0, 0, 'H', '113.55751029843', '22.212783524768', 3, 'tr_0 tr_820000 tr_820200 ', 0),
(820204, '花王堂区', 820200, '', 0, 0, 'H', '113.5544936987', '22.206635725923', 3, 'tr_0 tr_820000 tr_820200 ', 0),
(820205, '望德堂区', 820200, '', 0, 0, 'W', '113.5615137766', '22.202511136588', 3, 'tr_0 tr_820000 tr_820200 ', 0),
(830000, '台湾省', 0, '', 0, 0, 'T', '121.97387097872', '24.086956718805', 1, 'tr_0 ', 0),
(830100, '台北市', 830000, '', 0, 0, 'T', '121.5201088108', '25.063029935612', 2, 'tr_0 tr_830000 ', 0),
(830101, '中正区', 830100, '', 0, 0, 'Z', '121.5201088108', '25.063029935612', 3, 'tr_0 tr_830000 tr_830100 ', 0),
(830102, '大同区', 830100, '', 0, 0, 'D', '124.81937675979', '46.045583951311', 3, 'tr_0 tr_830000 tr_830100 ', 0),
(830103, '中山区', 830100, '', 0, 0, 'Z', '121.65154739367', '38.924511115496', 3, 'tr_0 tr_830000 tr_830100 ', 0),
(830104, '万华区', 830100, '', 0, 0, 'W', '121.5201088108', '25.063029935612', 3, 'tr_0 tr_830000 tr_830100 ', 0),
(830105, '信义区', 830100, '', 0, 0, 'X', '121.5201088108', '25.063029935612', 3, 'tr_0 tr_830000 tr_830100 ', 0),
(830106, '松山区', 830100, '', 0, 0, 'S', '118.9394138505', '42.292481572694', 3, 'tr_0 tr_830000 tr_830100 ', 0),
(830107, '大安区', 830100, '', 0, 0, 'D', '104.78041635328', '29.369928541322', 3, 'tr_0 tr_830000 tr_830100 ', 0),
(830108, '南港区', 830100, '', 0, 0, 'N', '121.5201088108', '25.063029935612', 3, 'tr_0 tr_830000 tr_830100 ', 0),
(830109, '北投区', 830100, '', 0, 0, 'B', '121.5201088108', '25.063029935612', 3, 'tr_0 tr_830000 tr_830100 ', 0),
(830110, '内湖区', 830100, '', 0, 0, 'N', '121.5201088108', '25.063029935612', 3, 'tr_0 tr_830000 tr_830100 ', 0),
(830111, '士林区', 830100, '', 0, 0, 'S', '121.5201088108', '25.063029935612', 3, 'tr_0 tr_830000 tr_830100 ', 0),
(830112, '文山区', 830100, '', 0, 0, 'W', '121.5201088108', '25.063029935612', 3, 'tr_0 tr_830000 tr_830100 ', 0),
(830200, '新北市', 830000, '', 0, 0, 'X', '121.97387097872', '24.086956718805', 2, 'tr_0 tr_830000 ', 0),
(830201, '板桥区', 830200, '', 0, 0, 'B', '121.46374631322', '25.009264935203', 3, 'tr_0 tr_830000 tr_830200 ', 0),
(830202, '土城区', 830200, '', 0, 0, 'T', '121.45638215646', '24.969575575642', 3, 'tr_0 tr_830000 tr_830200 ', 0),
(830203, '新庄区', 830200, '', 0, 0, 'X', '121.44987794847', '25.035900513246', 3, 'tr_0 tr_830000 tr_830200 ', 0),
(830204, '新店区', 830200, '', 0, 0, 'X', '121.54851057293', '24.931579077246', 3, 'tr_0 tr_830000 tr_830200 ', 0),
(830205, '深坑区', 830200, '', 0, 0, 'S', '121.63248449446', '25.000182732355', 3, 'tr_0 tr_830000 tr_830200 ', 0),
(830206, '石碇区', 830200, '', 0, 0, 'S', '121.64666268478', '24.953083429509', 3, 'tr_0 tr_830000 tr_830200 ', 0),
(830207, '坪林区', 830200, '', 0, 0, 'P', '121.73478767877', '24.915696554977', 3, 'tr_0 tr_830000 tr_830200 ', 0),
(830208, '乌来区', 830200, '', 0, 0, 'W', '121.53050817209', '24.786532168822', 3, 'tr_0 tr_830000 tr_830200 ', 0),
(830209, '五股区', 830200, '', 0, 0, 'W', '121.44461965429', '25.100233770435', 3, 'tr_0 tr_830000 tr_830200 ', 0),
(830210, '八里区', 830200, '', 0, 0, 'B', '121.40465098523', '25.130119585774', 3, 'tr_0 tr_830000 tr_830200 ', 0),
(830211, '林口区', 830200, '', 0, 0, 'L', '121.35894397022', '25.103036147515', 3, 'tr_0 tr_830000 tr_830200 ', 0),
(830212, '淡水区', 830200, '', 0, 0, 'D', '121.47260573633', '25.187238161176', 3, 'tr_0 tr_830000 tr_830200 ', 0),
(830213, '中和区', 830200, '', 0, 0, 'Z', '119.97751429276', '31.836323947624', 3, 'tr_0 tr_830000 tr_830200 ', 0),
(830214, '永和区', 830200, '', 0, 0, 'Y', '121.52736966421', '25.010500528231', 3, 'tr_0 tr_830000 tr_830200 ', 0),
(830215, '三重区', 830200, '', 0, 0, 'S', '121.49687574316', '25.069790814298', 3, 'tr_0 tr_830000 tr_830200 ', 0),
(830216, '芦洲区', 830200, '', 0, 0, 'L', '121.47982274435', '25.091134839883', 3, 'tr_0 tr_830000 tr_830200 ', 0),
(830217, '泰山区', 830200, '', 0, 0, 'T', '117.14141108582', '36.199444601195', 3, 'tr_0 tr_830000 tr_830200 ', 0),
(830218, '树林区', 830200, '', 0, 0, 'S', '121.412622083', '24.984757647837', 3, 'tr_0 tr_830000 tr_830200 ', 0),
(830219, '莺歌区', 830200, '', 0, 0, 'Y', '121.35899891418', '24.958676651245', 3, 'tr_0 tr_830000 tr_830200 ', 0),
(830220, '三峡区', 830200, '', 0, 0, 'S', '121.42609502893', '24.87480469353', 3, 'tr_0 tr_830000 tr_830200 ', 0),
(830221, '汐止区', 830200, '', 0, 0, 'X', '121.66100298061', '25.086721897126', 3, 'tr_0 tr_830000 tr_830200 ', 0),
(830222, '金山区', 830200, '', 0, 0, 'J', '121.34848004512', '30.74785237657', 3, 'tr_0 tr_830000 tr_830200 ', 0),
(830223, '万里区', 830200, '', 0, 0, 'W', '121.66558782234', '25.179420721026', 3, 'tr_0 tr_830000 tr_830200 ', 0),
(830224, '三芝区', 830200, '', 0, 0, 'S', '121.53552324466', '25.233947831353', 3, 'tr_0 tr_830000 tr_830200 ', 0),
(830225, '石门区', 830200, '', 0, 0, 'S', '121.59364212175', '25.261063301582', 3, 'tr_0 tr_830000 tr_830200 ', 0),
(830226, '瑞芳区', 830200, '', 0, 0, 'R', '121.81592241951', '25.092372901641', 3, 'tr_0 tr_830000 tr_830200 ', 0),
(830227, '贡寮区', 830200, '', 0, 0, 'G', '121.92278316131', '25.044375645825', 3, 'tr_0 tr_830000 tr_830200 ', 0),
(830228, '双溪区', 830200, '', 0, 0, 'S', '121.8310510997', '25.001750367683', 3, 'tr_0 tr_830000 tr_830200 ', 0),
(830229, '平溪区', 830200, '', 0, 0, 'P', '121.75897792057', '25.028954662262', 3, 'tr_0 tr_830000 tr_830200 ', 0),
(830300, '桃园市', 830000, '', 0, 0, 'T', '121.97387097872', '24.086956718805', 2, 'tr_0 tr_830000 ', 0),
(830301, '桃园区', 830300, '', 0, 0, 'T', '115.95771247803', '39.980514890446', 3, 'tr_0 tr_830000 tr_830300 ', 0),
(830302, '中坜区', 830300, '', 0, 0, 'Z', '115.95771247803', '39.980514890446', 3, 'tr_0 tr_830000 tr_830300 ', 0),
(830303, '平镇区', 830300, '', 0, 0, 'P', '115.95771247803', '39.980514890446', 3, 'tr_0 tr_830000 tr_830300 ', 0),
(830304, '八德区', 830300, '', 0, 0, 'B', '115.95771247803', '39.980514890446', 3, 'tr_0 tr_830000 tr_830300 ', 0),
(830305, '杨梅区', 830300, '', 0, 0, 'Y', '110.86164512823', '21.447395667888', 3, 'tr_0 tr_830000 tr_830300 ', 0),
(830306, '芦竹区', 830300, '', 0, 0, 'L', '115.95771247803', '39.980514890446', 3, 'tr_0 tr_830000 tr_830300 ', 0),
(830307, '大溪区', 830300, '', 0, 0, 'D', '115.95771247803', '39.980514890446', 3, 'tr_0 tr_830000 tr_830300 ', 0),
(830308, '龙潭区', 830300, '', 0, 0, 'L', '126.56854459242', '43.91634255363', 3, 'tr_0 tr_830000 tr_830300 ', 0),
(830309, '龟山区', 830300, '', 0, 0, 'G', '115.95771247803', '39.980514890446', 3, 'tr_0 tr_830000 tr_830300 ', 0),
(830310, '大园区', 830300, '', 0, 0, 'D', '115.95771247803', '39.980514890446', 3, 'tr_0 tr_830000 tr_830300 ', 0),
(830311, '观音区', 830300, '', 0, 0, 'G', '120.42538525561', '36.169241550407', 3, 'tr_0 tr_830000 tr_830300 ', 0),
(830312, '新屋区', 830300, '', 0, 0, 'X', '115.95771247803', '39.980514890446', 3, 'tr_0 tr_830000 tr_830300 ', 0),
(830313, '复兴区', 830300, '', 0, 0, 'F', '114.44809470749', '36.610368592227', 3, 'tr_0 tr_830000 tr_830300 ', 0),
(830400, '台中市', 830000, '', 0, 0, 'T', '121.97387097872', '24.086956718805', 2, 'tr_0 tr_830000 ', 0),
(830401, '中区', 830400, '', 0, 0, 'Z', '119.33696304538', '26.091557030419', 3, 'tr_0 tr_830000 tr_830400 ', 0),
(830402, '东区', 830400, '', 0, 0, 'D', '119.33696304538', '26.091557030419', 3, 'tr_0 tr_830000 tr_830400 ', 0),
(830403, '西区', 830400, '', 0, 0, 'X', '119.33696304538', '26.091557030419', 3, 'tr_0 tr_830000 tr_830400 ', 0),
(830404, '南区', 830400, '', 0, 0, 'N', '119.33696304538', '26.091557030419', 3, 'tr_0 tr_830000 tr_830400 ', 0),
(830405, '北区', 830400, '', 0, 0, 'B', '119.33696304538', '26.091557030419', 3, 'tr_0 tr_830000 tr_830400 ', 0),
(830406, '西屯区', 830400, '', 0, 0, 'X', '119.33696304538', '26.091557030419', 3, 'tr_0 tr_830000 tr_830400 ', 0),
(830407, '南屯区', 830400, '', 0, 0, 'N', '119.33696304538', '26.091557030419', 3, 'tr_0 tr_830000 tr_830400 ', 0),
(830408, '北屯区', 830400, '', 0, 0, 'B', '119.33696304538', '26.091557030419', 3, 'tr_0 tr_830000 tr_830400 ', 0),
(830409, '丰原区', 830400, '', 0, 0, 'F', '119.33696304538', '26.091557030419', 3, 'tr_0 tr_830000 tr_830400 ', 0),
(830410, '大里区', 830400, '', 0, 0, 'D', '119.33696304538', '26.091557030419', 3, 'tr_0 tr_830000 tr_830400 ', 0),
(830411, '太平区', 830400, '', 0, 0, 'T', '121.68538413681', '42.016967854141', 3, 'tr_0 tr_830000 tr_830400 ', 0),
(830412, '东势区', 830400, '', 0, 0, 'D', '119.33696304538', '26.091557030419', 3, 'tr_0 tr_830000 tr_830400 ', 0),
(830413, '大甲区', 830400, '', 0, 0, 'D', '119.33696304538', '26.091557030419', 3, 'tr_0 tr_830000 tr_830400 ', 0),
(830414, '清水区', 830400, '', 0, 0, 'Q', '119.33696304538', '26.091557030419', 3, 'tr_0 tr_830000 tr_830400 ', 0),
(830415, '沙鹿区', 830400, '', 0, 0, 'S', '119.33696304538', '26.091557030419', 3, 'tr_0 tr_830000 tr_830400 ', 0),
(830416, '梧栖区', 830400, '', 0, 0, 'W', '119.33696304538', '26.091557030419', 3, 'tr_0 tr_830000 tr_830400 ', 0),
(830417, '后里区', 830400, '', 0, 0, 'H', '119.33696304538', '26.091557030419', 3, 'tr_0 tr_830000 tr_830400 ', 0),
(830418, '神冈区', 830400, '', 0, 0, 'S', '119.33696304538', '26.091557030419', 3, 'tr_0 tr_830000 tr_830400 ', 0),
(830419, '潭子区', 830400, '', 0, 0, 'T', '119.33696304538', '26.091557030419', 3, 'tr_0 tr_830000 tr_830400 ', 0),
(830420, '大雅区', 830400, '', 0, 0, 'D', '119.33696304538', '26.091557030419', 3, 'tr_0 tr_830000 tr_830400 ', 0),
(830421, '新小区', 830400, '', 0, 0, 'X', '119.33696304538', '26.091557030419', 3, 'tr_0 tr_830000 tr_830400 ', 0),
(830422, '石冈区', 830400, '', 0, 0, 'S', '119.33696304538', '26.091557030419', 3, 'tr_0 tr_830000 tr_830400 ', 0),
(830423, '外埔区', 830400, '', 0, 0, 'W', '119.33696304538', '26.091557030419', 3, 'tr_0 tr_830000 tr_830400 ', 0),
(830424, '大安区', 830400, '', 0, 0, 'D', '104.78041635328', '29.369928541322', 3, 'tr_0 tr_830000 tr_830400 ', 0),
(830425, '乌日区', 830400, '', 0, 0, 'W', '119.33696304538', '26.091557030419', 3, 'tr_0 tr_830000 tr_830400 ', 0),
(830426, '大肚区', 830400, '', 0, 0, 'D', '119.33696304538', '26.091557030419', 3, 'tr_0 tr_830000 tr_830400 ', 0),
(830427, '龙井区', 830400, '', 0, 0, 'L', '119.33696304538', '26.091557030419', 3, 'tr_0 tr_830000 tr_830400 ', 0),
(830428, '雾峰区', 830400, '', 0, 0, 'W', '119.33696304538', '26.091557030419', 3, 'tr_0 tr_830000 tr_830400 ', 0),
(830429, '和平区', 830400, '', 0, 0, 'H', '117.2214669949', '39.12339025328', 3, 'tr_0 tr_830000 tr_830400 ', 0),
(830500, '台南市', 830000, '', 0, 0, 'T', '121.97387097872', '24.086956718805', 2, 'tr_0 tr_830000 ', 0),
(830501, '中西区', 830500, '', 0, 0, 'Z', '114.15949141031', '22.291342714292', 3, 'tr_0 tr_830000 tr_830500 ', 0),
(830502, '东区', 830500, '', 0, 0, 'D', '121.36052796411', '38.965848756262', 3, 'tr_0 tr_830000 tr_830500 ', 0),
(830503, '南区', 830500, '', 0, 0, 'N', '121.36052796411', '38.965848756262', 3, 'tr_0 tr_830000 tr_830500 ', 0),
(830504, '北区', 830500, '', 0, 0, 'B', '121.36052796411', '38.965848756262', 3, 'tr_0 tr_830000 tr_830500 ', 0),
(830505, '安平区', 830500, '', 0, 0, 'A', '121.36052796411', '38.965848756262', 3, 'tr_0 tr_830000 tr_830500 ', 0),
(830506, '安南区', 830500, '', 0, 0, 'A', '121.36052796411', '38.965848756262', 3, 'tr_0 tr_830000 tr_830500 ', 0),
(830507, '永康区', 830500, '', 0, 0, 'Y', '121.36052796411', '38.965848756262', 3, 'tr_0 tr_830000 tr_830500 ', 0),
(830508, '归仁区', 830500, '', 0, 0, 'G', '121.36052796411', '38.965848756262', 3, 'tr_0 tr_830000 tr_830500 ', 0),
(830509, '新化区', 830500, '', 0, 0, 'X', '121.36052796411', '38.965848756262', 3, 'tr_0 tr_830000 tr_830500 ', 0),
(830510, '左镇区', 830500, '', 0, 0, 'Z', '121.36052796411', '38.965848756262', 3, 'tr_0 tr_830000 tr_830500 ', 0),
(830511, '玉井区', 830500, '', 0, 0, 'Y', '121.36052796411', '38.965848756262', 3, 'tr_0 tr_830000 tr_830500 ', 0),
(830512, '楠西区', 830500, '', 0, 0, 'N', '121.36052796411', '38.965848756262', 3, 'tr_0 tr_830000 tr_830500 ', 0),
(830513, '南化区', 830500, '', 0, 0, 'N', '121.36052796411', '38.965848756262', 3, 'tr_0 tr_830000 tr_830500 ', 0),
(830514, '仁德区', 830500, '', 0, 0, 'R', '121.36052796411', '38.965848756262', 3, 'tr_0 tr_830000 tr_830500 ', 0),
(830515, '关庙区', 830500, '', 0, 0, 'G', '121.36052796411', '38.965848756262', 3, 'tr_0 tr_830000 tr_830500 ', 0),
(830516, '龙崎区', 830500, '', 0, 0, 'L', '121.36052796411', '38.965848756262', 3, 'tr_0 tr_830000 tr_830500 ', 0),
(830517, '官田区', 830500, '', 0, 0, 'G', '121.36052796411', '38.965848756262', 3, 'tr_0 tr_830000 tr_830500 ', 0),
(830518, '麻豆区', 830500, '', 0, 0, 'M', '121.36052796411', '38.965848756262', 3, 'tr_0 tr_830000 tr_830500 ', 0),
(830519, '佳里区', 830500, '', 0, 0, 'J', '121.36052796411', '38.965848756262', 3, 'tr_0 tr_830000 tr_830500 ', 0),
(830520, '西港区', 830500, '', 0, 0, 'X', '121.36052796411', '38.965848756262', 3, 'tr_0 tr_830000 tr_830500 ', 0),
(830521, '七股区', 830500, '', 0, 0, 'Q', '121.36052796411', '38.965848756262', 3, 'tr_0 tr_830000 tr_830500 ', 0),
(830522, '将军区', 830500, '', 0, 0, 'J', '121.36052796411', '38.965848756262', 3, 'tr_0 tr_830000 tr_830500 ', 0),
(830523, '学甲区', 830500, '', 0, 0, 'X', '121.36052796411', '38.965848756262', 3, 'tr_0 tr_830000 tr_830500 ', 0),
(830524, '北门区', 830500, '', 0, 0, 'B', '121.36052796411', '38.965848756262', 3, 'tr_0 tr_830000 tr_830500 ', 0),
(830525, '新营区', 830500, '', 0, 0, 'X', '121.36052796411', '38.965848756262', 3, 'tr_0 tr_830000 tr_830500 ', 0),
(830526, '后壁区', 830500, '', 0, 0, 'H', '121.36052796411', '38.965848756262', 3, 'tr_0 tr_830000 tr_830500 ', 0),
(830527, '白河区', 830500, '', 0, 0, 'B', '121.36052796411', '38.965848756262', 3, 'tr_0 tr_830000 tr_830500 ', 0),
(830528, '东山区', 830500, '', 0, 0, 'D', '130.32336109407', '47.344987135573', 3, 'tr_0 tr_830000 tr_830500 ', 0),
(830529, '六甲区', 830500, '', 0, 0, 'L', '121.36052796411', '38.965848756262', 3, 'tr_0 tr_830000 tr_830500 ', 0),
(830530, '下营区', 830500, '', 0, 0, 'X', '121.36052796411', '38.965848756262', 3, 'tr_0 tr_830000 tr_830500 ', 0),
(830531, '柳营区', 830500, '', 0, 0, 'L', '121.36052796411', '38.965848756262', 3, 'tr_0 tr_830000 tr_830500 ', 0),
(830532, '盐水区', 830500, '', 0, 0, 'Y', '121.36052796411', '38.965848756262', 3, 'tr_0 tr_830000 tr_830500 ', 0),
(830533, '善化区', 830500, '', 0, 0, 'S', '121.36052796411', '38.965848756262', 3, 'tr_0 tr_830000 tr_830500 ', 0),
(830534, '大内区', 830500, '', 0, 0, 'D', '121.36052796411', '38.965848756262', 3, 'tr_0 tr_830000 tr_830500 ', 0),
(830535, '山上区', 830500, '', 0, 0, 'S', '121.36052796411', '38.965848756262', 3, 'tr_0 tr_830000 tr_830500 ', 0),
(830536, '新市区', 830500, '', 0, 0, 'X', '115.41224520287', '38.88118294749', 3, 'tr_0 tr_830000 tr_830500 ', 0),
(830537, '安定区', 830500, '', 0, 0, 'A', '104.61650040265', '35.585600016725', 3, 'tr_0 tr_830000 tr_830500 ', 0),
(830600, '高雄市', 830000, '', 0, 0, 'G', '121.97387097872', '24.086956718805', 2, 'tr_0 tr_830000 ', 0),
(830601, '楠梓区', 830600, '', 0, 0, 'N', '114.29349244944', '30.607022895804', 3, 'tr_0 tr_830000 tr_830600 ', 0),
(830602, '左营区', 830600, '', 0, 0, 'Z', '114.29349244944', '30.607022895804', 3, 'tr_0 tr_830000 tr_830600 ', 0),
(830603, '鼓山区', 830600, '', 0, 0, 'G', '114.29349244944', '30.607022895804', 3, 'tr_0 tr_830000 tr_830600 ', 0),
(830604, '三民区', 830600, '', 0, 0, 'S', '114.29349244944', '30.607022895804', 3, 'tr_0 tr_830000 tr_830600 ', 0),
(830605, '盐埕区', 830600, '', 0, 0, 'Y', '114.29349244944', '30.607022895804', 3, 'tr_0 tr_830000 tr_830600 ', 0),
(830606, '前金区', 830600, '', 0, 0, 'Q', '114.29349244944', '30.607022895804', 3, 'tr_0 tr_830000 tr_830600 ', 0),
(830607, '新兴区', 830600, '', 0, 0, 'X', '130.93837086995', '45.822310328543', 3, 'tr_0 tr_830000 tr_830600 ', 0),
(830608, '苓雅区', 830600, '', 0, 0, 'L', '114.29349244944', '30.607022895804', 3, 'tr_0 tr_830000 tr_830600 ', 0),
(830609, '前镇区', 830600, '', 0, 0, 'Q', '114.29349244944', '30.607022895804', 3, 'tr_0 tr_830000 tr_830600 ', 0),
(830610, '旗津区', 830600, '', 0, 0, 'Q', '114.29349244944', '30.607022895804', 3, 'tr_0 tr_830000 tr_830600 ', 0),
(830611, '小港区', 830600, '', 0, 0, 'X', '114.29349244944', '30.607022895804', 3, 'tr_0 tr_830000 tr_830600 ', 0),
(830612, '凤山区', 830600, '', 0, 0, 'F', '114.29349244944', '30.607022895804', 3, 'tr_0 tr_830000 tr_830600 ', 0),
(830613, '大寮区', 830600, '', 0, 0, 'D', '114.29349244944', '30.607022895804', 3, 'tr_0 tr_830000 tr_830600 ', 0),
(830614, '鸟松区', 830600, '', 0, 0, 'N', '114.29349244944', '30.607022895804', 3, 'tr_0 tr_830000 tr_830600 ', 0),
(830615, '林园区', 830600, '', 0, 0, 'L', '114.29349244944', '30.607022895804', 3, 'tr_0 tr_830000 tr_830600 ', 0),
(830616, '仁武区', 830600, '', 0, 0, 'R', '114.29349244944', '30.607022895804', 3, 'tr_0 tr_830000 tr_830600 ', 0),
(830617, '大树区', 830600, '', 0, 0, 'D', '114.29349244944', '30.607022895804', 3, 'tr_0 tr_830000 tr_830600 ', 0),
(830618, '大社区', 830600, '', 0, 0, 'D', '114.29349244944', '30.607022895804', 3, 'tr_0 tr_830000 tr_830600 ', 0),
(830619, '冈山区', 830600, '', 0, 0, 'G', '114.29349244944', '30.607022895804', 3, 'tr_0 tr_830000 tr_830600 ', 0),
(830620, '路竹区', 830600, '', 0, 0, 'L', '114.29349244944', '30.607022895804', 3, 'tr_0 tr_830000 tr_830600 ', 0),
(830621, '桥头区', 830600, '', 0, 0, 'Q', '114.29349244944', '30.607022895804', 3, 'tr_0 tr_830000 tr_830600 ', 0),
(830622, '梓官区', 830600, '', 0, 0, 'Z', '114.29349244944', '30.607022895804', 3, 'tr_0 tr_830000 tr_830600 ', 0),
(830623, '弥陀区', 830600, '', 0, 0, 'M', '114.29349244944', '30.607022895804', 3, 'tr_0 tr_830000 tr_830600 ', 0),
(830624, '永安区', 830600, '', 0, 0, 'Y', '114.29349244944', '30.607022895804', 3, 'tr_0 tr_830000 tr_830600 ', 0),
(830625, '燕巢区', 830600, '', 0, 0, 'Y', '114.29349244944', '30.607022895804', 3, 'tr_0 tr_830000 tr_830600 ', 0),
(830626, '阿莲区', 830600, '', 0, 0, 'A', '114.29349244944', '30.607022895804', 3, 'tr_0 tr_830000 tr_830600 ', 0),
(830627, '茄萣区', 830600, '', 0, 0, 'J', '114.29349244944', '30.607022895804', 3, 'tr_0 tr_830000 tr_830600 ', 0),
(830628, '湖内区', 830600, '', 0, 0, 'H', '114.29349244944', '30.607022895804', 3, 'tr_0 tr_830000 tr_830600 ', 0),
(830629, '旗山区', 830600, '', 0, 0, 'Q', '114.29349244944', '30.607022895804', 3, 'tr_0 tr_830000 tr_830600 ', 0),
(830630, '美浓区', 830600, '', 0, 0, 'M', '114.29349244944', '30.607022895804', 3, 'tr_0 tr_830000 tr_830600 ', 0),
(830631, '内门区', 830600, '', 0, 0, 'N', '114.29349244944', '30.607022895804', 3, 'tr_0 tr_830000 tr_830600 ', 0),
(830632, '杉林区', 830600, '', 0, 0, 'S', '114.29349244944', '30.607022895804', 3, 'tr_0 tr_830000 tr_830600 ', 0),
(830633, '甲仙区', 830600, '', 0, 0, 'J', '114.29349244944', '30.607022895804', 3, 'tr_0 tr_830000 tr_830600 ', 0),
(830634, '六龟区', 830600, '', 0, 0, 'L', '114.29349244944', '30.607022895804', 3, 'tr_0 tr_830000 tr_830600 ', 0),
(830635, '茂林区', 830600, '', 0, 0, 'M', '114.29349244944', '30.607022895804', 3, 'tr_0 tr_830000 tr_830600 ', 0),
(830636, '桃源区', 830600, '', 0, 0, 'T', '114.29349244944', '30.607022895804', 3, 'tr_0 tr_830000 tr_830600 ', 0),
(830637, '那玛夏区', 830600, '', 0, 0, 'N', '120.71415692906', '23.273513646073', 3, 'tr_0 tr_830000 tr_830600 ', 0),
(830700, '基隆市', 830000, '', 0, 0, 'J', '121.97387097872', '24.086956718805', 2, 'tr_0 tr_830000 ', 0),
(830701, '中正区', 830700, '', 0, 0, 'Z', '118.53225032938', '24.6210238893', 3, 'tr_0 tr_830000 tr_830700 ', 0),
(830702, '七堵区', 830700, '', 0, 0, 'Q', '118.53225032938', '24.6210238893', 3, 'tr_0 tr_830000 tr_830700 ', 0),
(830703, '暖暖区', 830700, '', 0, 0, 'N', '118.53225032938', '24.6210238893', 3, 'tr_0 tr_830000 tr_830700 ', 0),
(830704, '仁爱区', 830700, '', 0, 0, 'R', '118.53225032938', '24.6210238893', 3, 'tr_0 tr_830000 tr_830700 ', 0),
(830705, '中山区', 830700, '', 0, 0, 'Z', '121.65154739367', '38.924511115496', 3, 'tr_0 tr_830000 tr_830700 ', 0),
(830706, '安乐区', 830700, '', 0, 0, 'A', '118.53225032938', '24.6210238893', 3, 'tr_0 tr_830000 tr_830700 ', 0),
(830707, '信义区', 830700, '', 0, 0, 'X', '118.53225032938', '24.6210238893', 3, 'tr_0 tr_830000 tr_830700 ', 0),
(830800, '新竹市', 830000, '', 0, 0, 'X', '121.97387097872', '24.086956718805', 2, 'tr_0 tr_830000 ', 0),
(830801, '东区', 830800, '', 0, 0, 'D', '119.76701381388', '49.221741849328', 3, 'tr_0 tr_830000 tr_830800 ', 0),
(830802, '北区', 830800, '', 0, 0, 'B', '119.76701381388', '49.221741849328', 3, 'tr_0 tr_830000 tr_830800 ', 0),
(830803, '香山区', 830800, '', 0, 0, 'X', '119.76701381388', '49.221741849328', 3, 'tr_0 tr_830000 tr_830800 ', 0),
(830900, '嘉义市', 830000, '', 0, 0, 'J', '121.97387097872', '24.086956718805', 2, 'tr_0 tr_830000 ', 0),
(830901, '东区', 830900, '', 0, 0, 'D', '114.2466374103', '22.728825804821', 3, 'tr_0 tr_830000 tr_830900 ', 0),
(830902, '西区', 830900, '', 0, 0, 'X', '114.2466374103', '22.728825804821', 3, 'tr_0 tr_830000 tr_830900 ', 0),
(839001, '宜兰县', 839000, '', 0, 0, 'Y', '121.39369436652', '31.211883015985', 3, 'tr_0 tr_830000 tr_839000 ', 0),
(839002, '新竹县', 839000, '', 0, 0, 'X', '119.76701381388', '49.221741849328', 3, 'tr_0 tr_830000 tr_839000 ', 0),
(839003, '苗栗县', 839000, '', 0, 0, 'M', '', '', 3, 'tr_0 tr_830000 tr_839000 ', 0),
(839004, '彰化县', 839000, '', 0, 0, 'Z', '109.04292985822', '26.632603089128', 3, 'tr_0 tr_830000 tr_839000 ', 0),
(839005, '南投县', 839000, '', 0, 0, 'N', '', '', 3, 'tr_0 tr_830000 tr_839000 ', 0),
(839006, '嘉义县', 839000, '', 0, 0, 'J', '114.2466374103', '22.728825804821', 3, 'tr_0 tr_830000 tr_839000 ', 0),
(839007, '云林县', 839000, '', 0, 0, 'Y', '124.7995182988', '42.918396678776', 3, 'tr_0 tr_830000 tr_839000 ', 0),
(839008, '屏东县', 839000, '', 0, 0, 'P', '119.30846756124', '26.107056743573', 3, 'tr_0 tr_830000 tr_839000 ', 0),
(839009, '台东县', 839000, '', 0, 0, 'T', '119.33983605008', '26.095631255982', 3, 'tr_0 tr_830000 tr_839000 ', 0),
(839010, '花莲县', 839000, '', 0, 0, 'H', '120.16162991211', '33.366606824641', 3, 'tr_0 tr_830000 tr_839000 ', 0),
(839011, '澎湖县', 839000, '', 0, 0, 'P', '121.13156576447', '30.875327117717', 3, 'tr_0 tr_830000 tr_839000 ', 0),
(839012, '金门县', 839000, '', 0, 0, 'J', '118.3304151596', '24.440444541055', 3, 'tr_0 tr_830000 tr_839000 ', 0),
(839013, '连江县', 839000, '', 0, 0, 'L', '119.54647881621', '26.203583291029', 3, 'tr_0 tr_830000 tr_839000 ', 0),
(441900003, '东城街道办事处', 441900, '', 0, 0, 'D', '113.78961542643', '23.033927867022', 3, 'tr_0 tr_440000 tr_441900 ', 0),
(441900004, '南城街道办事处', 441900, '', 0, 0, 'N', '113.74972154669', '23.02491560037', 3, 'tr_0 tr_440000 tr_441900 ', 0),
(441900005, '万江街道办事处', 441900, '', 0, 0, 'W', '113.70128466119', '23.044382337638', 3, 'tr_0 tr_440000 tr_441900 ', 0),
(441900006, '莞城街道办事处', 441900, '', 0, 0, 'G', '113.7555643548', '23.04532373021', 3, 'tr_0 tr_440000 tr_441900 ', 0),
(441900101, '石碣镇', 441900, '', 0, 0, 'S', '113.81395530616', '23.105172244651', 3, 'tr_0 tr_440000 tr_441900 ', 0),
(441900102, '石龙镇', 441900, '', 0, 0, 'S', '113.84749077289', '23.115219876975', 3, 'tr_0 tr_440000 tr_441900 ', 0),
(441900103, '茶山镇', 441900, '', 0, 0, 'C', '113.89350241139', '23.069002516534', 3, 'tr_0 tr_440000 tr_441900 ', 0),
(441900104, '石排镇', 441900, '', 0, 0, 'S', '113.96394649371', '23.088334509001', 3, 'tr_0 tr_440000 tr_441900 ', 0),
(441900105, '企石镇', 441900, '', 0, 0, 'Q', '114.04851828338', '23.070690716193', 3, 'tr_0 tr_440000 tr_441900 ', 0),
(441900106, '横沥镇', 441900, '', 0, 0, 'H', '113.98801324096', '23.030051448767', 3, 'tr_0 tr_440000 tr_441900 ', 0),
(441900107, '桥头镇', 441900, '', 0, 0, 'Q', '114.10677408198', '23.020458678747', 3, 'tr_0 tr_440000 tr_441900 ', 0),
(441900108, '谢岗镇', 441900, '', 0, 0, 'X', '114.19511437465', '22.946513843008', 3, 'tr_0 tr_440000 tr_441900 ', 0),
(441900109, '东坑镇', 441900, '', 0, 0, 'D', '113.95246820282', '23.002958656049', 3, 'tr_0 tr_440000 tr_441900 ', 0),
(441900110, '常平镇', 441900, '', 0, 0, 'C', '114.02458867145', '22.979369177741', 3, 'tr_0 tr_440000 tr_441900 ', 0),
(441900111, '寮步镇', 441900, '', 0, 0, 'L', '113.88349112257', '22.996428153649', 3, 'tr_0 tr_440000 tr_441900 ', 0),
(441900112, '樟木头镇', 441900, '', 0, 0, 'Z', '114.11559876672', '22.912795269745', 3, 'tr_0 tr_440000 tr_441900 ', 0),
(441900113, '大朗镇', 441900, '', 0, 0, 'D', '113.94820653279', '22.912348752542', 3, 'tr_0 tr_440000 tr_441900 ', 0),
(441900114, '黄江镇', 441900, '', 0, 0, 'H', '114.00621531625', '22.872431801821', 3, 'tr_0 tr_440000 tr_441900 ', 0),
(441900115, '清溪镇', 441900, '', 0, 0, 'Q', '114.18744982903', '22.841601621999', 3, 'tr_0 tr_440000 tr_441900 ', 0);
INSERT INTO `sys_provinces` (`id`, `title`, `pid`, `short_title`, `areacode`, `zipcode`, `pinyin`, `lng`, `lat`, `level`, `tree`, `sort`) VALUES
(441900116, '塘厦镇', 441900, '', 0, 0, 'T', '114.08442795001', '22.811576132112', 3, 'tr_0 tr_440000 tr_441900 ', 0),
(441900117, '凤岗镇', 441900, '', 0, 0, 'F', '114.17560299034', '22.722315801247', 3, 'tr_0 tr_440000 tr_441900 ', 0),
(441900118, '大岭山镇', 441900, '', 0, 0, 'D', '113.83293372133', '22.903546239236', 3, 'tr_0 tr_440000 tr_441900 ', 0),
(441900119, '长安镇', 441900, '', 0, 0, 'Z', '113.76998309965', '22.795308241444', 3, 'tr_0 tr_440000 tr_441900 ', 0),
(441900121, '虎门镇', 441900, '', 0, 0, 'H', '113.68188667267', '22.818449805406', 3, 'tr_0 tr_440000 tr_441900 ', 0),
(441900122, '厚街镇', 441900, '', 0, 0, 'H', '113.7081456375', '22.923357615893', 3, 'tr_0 tr_440000 tr_441900 ', 0),
(441900123, '沙田镇', 441900, '', 0, 0, 'S', '113.60821459687', '22.907479676518', 3, 'tr_0 tr_440000 tr_441900 ', 0),
(441900124, '道滘镇', 441900, '', 0, 0, 'D', '113.66267069882', '22.982801242639', 3, 'tr_0 tr_440000 tr_441900 ', 0),
(441900125, '洪梅镇', 441900, '', 0, 0, 'H', '113.6125183112', '22.978946913376', 3, 'tr_0 tr_440000 tr_441900 ', 0),
(441900126, '麻涌镇', 441900, '', 0, 0, 'M', '113.58837988097', '23.057083015858', 3, 'tr_0 tr_440000 tr_441900 ', 0),
(441900127, '望牛墩镇', 441900, '', 0, 0, 'W', '113.64023583492', '23.047597838769', 3, 'tr_0 tr_440000 tr_441900 ', 0),
(441900128, '中堂镇', 441900, '', 0, 0, 'Z', '113.65890566238', '23.096485679975', 3, 'tr_0 tr_440000 tr_441900 ', 0),
(441900129, '高埗镇', 441900, '', 0, 0, 'G', '113.74213386638', '23.100270479205', 3, 'tr_0 tr_440000 tr_441900 ', 0),
(441900401, '松山湖管委会', 441900, '', 0, 0, 'S', '113.90386183402', '22.928504587758', 3, 'tr_0 tr_440000 tr_441900 ', 0),
(441900402, '东莞港', 441900, '', 0, 0, 'D', '113.75842045788', '23.027308411643', 3, 'tr_0 tr_440000 tr_441900 ', 0),
(441900403, '东莞生态园', 441900, '', 0, 0, 'D', '113.93331900631', '23.069150651008', 3, 'tr_0 tr_440000 tr_441900 ', 0),
(442000001, '石岐区街道办事处', 442000, '', 0, 0, 'S', '113.39476330111', '22.543405990677', 3, 'tr_0 tr_440000 tr_442000 ', 0),
(442000002, '东区街道办事处', 442000, '', 0, 0, 'D', '113.39942236263', '22.522314670791', 3, 'tr_0 tr_440000 tr_442000 ', 0),
(442000003, '火炬开发区街道办事处', 442000, '', 0, 0, 'H', '113.47638423802', '22.54191612433', 3, 'tr_0 tr_440000 tr_442000 ', 0),
(442000004, '西区街道办事处', 442000, '', 0, 0, 'X', '113.34742851429', '22.557446683319', 3, 'tr_0 tr_440000 tr_442000 ', 0),
(442000005, '南区街道办事处', 442000, '', 0, 0, 'N', '113.34166389111', '22.474593624741', 3, 'tr_0 tr_440000 tr_442000 ', 0),
(442000006, '五桂山街道办事处', 442000, '', 0, 0, 'W', '113.40930659782', '22.451434375841', 3, 'tr_0 tr_440000 tr_442000 ', 0),
(442000100, '小榄镇', 442000, '', 0, 0, 'X', '113.25710033351', '22.668653898989', 3, 'tr_0 tr_440000 tr_442000 ', 0),
(442000101, '黄圃镇', 442000, '', 0, 0, 'H', '113.38940119784', '22.732151367196', 3, 'tr_0 tr_440000 tr_442000 ', 0),
(442000102, '民众镇', 442000, '', 0, 0, 'M', '113.50030740281', '22.624234006676', 3, 'tr_0 tr_440000 tr_442000 ', 0),
(442000103, '东凤镇', 442000, '', 0, 0, 'D', '113.26337563889', '22.696772350456', 3, 'tr_0 tr_440000 tr_442000 ', 0),
(442000104, '东升镇', 442000, '', 0, 0, 'D', '113.31347763067', '22.605137527398', 3, 'tr_0 tr_440000 tr_442000 ', 0),
(442000105, '古镇镇', 442000, '', 0, 0, 'G', '113.18899941194', '22.636034421686', 3, 'tr_0 tr_440000 tr_442000 ', 0),
(442000106, '沙溪镇', 442000, '', 0, 0, 'S', '113.35710852331', '22.513668030794', 3, 'tr_0 tr_440000 tr_442000 ', 0),
(442000107, '坦洲镇', 442000, '', 0, 0, 'T', '113.46831862593', '22.283731940242', 3, 'tr_0 tr_440000 tr_442000 ', 0),
(442000108, '港口镇', 442000, '', 0, 0, 'G', '113.38354521878', '22.577121999043', 3, 'tr_0 tr_440000 tr_442000 ', 0),
(442000109, '三角镇', 442000, '', 0, 0, 'S', '113.42740190231', '22.685663488493', 3, 'tr_0 tr_440000 tr_442000 ', 0),
(442000110, '横栏镇', 442000, '', 0, 0, 'H', '113.24834255727', '22.574461443704', 3, 'tr_0 tr_440000 tr_442000 ', 0),
(442000111, '南头镇', 442000, '', 0, 0, 'N', '113.29481042537', '22.721261074602', 3, 'tr_0 tr_440000 tr_442000 ', 0),
(442000112, '阜沙镇', 442000, '', 0, 0, 'F', '113.34269477842', '22.666128002352', 3, 'tr_0 tr_440000 tr_442000 ', 0),
(442000113, '南朗镇', 442000, '', 0, 0, 'N', '113.56057493505', '22.519486447352', 3, 'tr_0 tr_440000 tr_442000 ', 0),
(442000114, '三乡镇', 442000, '', 0, 0, 'S', '113.42695556574', '22.371470122528', 3, 'tr_0 tr_440000 tr_442000 ', 0),
(442000115, '板芙镇', 442000, '', 0, 0, 'B', '113.33339573359', '22.395149046719', 3, 'tr_0 tr_440000 tr_442000 ', 0),
(442000116, '大涌镇', 442000, '', 0, 0, 'D', '113.29404791311', '22.483908949365', 3, 'tr_0 tr_440000 tr_442000 ', 0),
(442000117, '神湾镇', 442000, '', 0, 0, 'S', '113.35331518036', '22.32576323421', 3, 'tr_0 tr_440000 tr_442000 ', 0),
(460400100, '那大镇', 460400, '', 0, 0, 'N', '109.552961497', '19.52127763772', 3, 'tr_0 tr_460000 tr_460400 ', 0),
(460400101, '和庆镇', 460400, '', 0, 0, 'H', '109.64738779153', '19.531275426074', 3, 'tr_0 tr_460000 tr_460400 ', 0),
(460400102, '南丰镇', 460400, '', 0, 0, 'N', '109.6054369934', '19.346095790543', 3, 'tr_0 tr_460000 tr_460400 ', 0),
(460400103, '大成镇', 460400, '', 0, 0, 'D', '109.42116531507', '19.548276240672', 3, 'tr_0 tr_460000 tr_460400 ', 0),
(460400104, '雅星镇', 460400, '', 0, 0, 'Y', '109.19716320191', '19.517956948407', 3, 'tr_0 tr_460000 tr_460400 ', 0),
(460400105, '兰洋镇', 460400, '', 0, 0, 'L', '109.67367138789', '19.466430878427', 3, 'tr_0 tr_460000 tr_460400 ', 0),
(460400106, '光村镇', 460400, '', 0, 0, 'G', '109.50795789562', '19.809145677126', 3, 'tr_0 tr_460000 tr_460400 ', 0),
(460400107, '木棠镇', 460400, '', 0, 0, 'M', '109.35673473687', '19.809926770596', 3, 'tr_0 tr_460000 tr_460400 ', 0),
(460400108, '海头镇', 460400, '', 0, 0, 'H', '108.95966166166', '19.509695855917', 3, 'tr_0 tr_460000 tr_460400 ', 0),
(460400109, '峨蔓镇', 460400, '', 0, 0, 'E', '109.30390924357', '19.863144800976', 3, 'tr_0 tr_460000 tr_460400 ', 0),
(460400111, '王五镇', 460400, '', 0, 0, 'W', '109.33806829512', '19.645800769747', 3, 'tr_0 tr_460000 tr_460400 ', 0),
(460400112, '白马井镇', 460400, '', 0, 0, 'B', '109.58745583569', '19.527146110044', 3, 'tr_0 tr_460000 tr_460400 ', 0),
(460400113, '中和镇', 460400, '', 0, 0, 'Z', '109.35613533713', '19.749465537088', 3, 'tr_0 tr_460000 tr_460400 ', 0),
(460400114, '排浦镇', 460400, '', 0, 0, 'P', '109.16975400269', '19.644673698003', 3, 'tr_0 tr_460000 tr_460400 ', 0),
(460400115, '东成镇', 460400, '', 0, 0, 'D', '109.4680333127', '19.709924104042', 3, 'tr_0 tr_460000 tr_460400 ', 0),
(460400116, '新州镇', 460400, '', 0, 0, 'X', '109.32260133284', '19.720234743232', 3, 'tr_0 tr_460000 tr_460400 ', 0),
(460400499, '洋浦经济开发区', 460400, '', 0, 0, 'Y', '109.19229656623', '19.775218244804', 3, 'tr_0 tr_460000 tr_460400 ', 0),
(460400500, '华南热作学院', 460400, '', 0, 0, 'H', '109.58745583569', '19.527146110044', 3, 'tr_0 tr_460000 tr_460400 ', 0);

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

--
-- 表的结构 `sys_resources`
--

CREATE TABLE `sys_resources` (
  `resource_id` bigint(20) NOT NULL COMMENT 'api编号',
  `path` varchar(128) NOT NULL COMMENT '访问路径',
  `method` varchar(10) NOT NULL COMMENT '访问方法',
  `cat` varchar(16) NOT NULL COMMENT '类别',
  `title` varchar(250) NOT NULL COMMENT '说明',
  `tags` varchar(255) NOT NULL COMMENT '标签',
  `created_at` datetime NOT NULL COMMENT '添加时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- 转存表中的数据 `sys_resources`
--

INSERT INTO `sys_resources` (`resource_id`, `path`, `method`, `cat`, `title`, `tags`, `created_at`) VALUES
(1, '/admin/post/name_unique', 'get', 'admin', '岗位名称是否唯一', 'post', '2023-07-13 06:45:05'),
(2, '/mall/fav/list', 'post', 'mall', '收藏列表', '商品收藏', '2023-07-13 06:45:05'),
(3, '/admin/member_group/get_list_by_shop_id', 'post', 'admin', '根据店铺id获取会员组列表', 'member_group', '2023-07-13 06:45:05'),
(4, '/admin/shippingpolicy/priority/update', 'post', 'admin', '修改优先发货策略', 'shippingpolicy', '2023-07-13 06:45:05'),
(5, '/admin/warehouse/stock/read', 'post', 'admin', '读取仓库商品库存', 'warehouse', '2023-07-13 06:45:05'),
(6, '/admin/cat/list', 'post', 'admin', '类目列表', 'cat', '2023-07-13 06:45:05'),
(7, '/admin/config/view', 'get', 'admin', '获取指定信息', 'config', '2023-07-13 06:45:05'),
(8, '/admin/login/sign', 'post', 'admin', '商户登录', 'login', '2023-07-13 06:45:05'),
(9, '/admin/member/update_avatar', 'post', 'admin', '更新会员头像', 'merchant', '2023-07-13 06:45:05'),
(10, '/docs/open', '', 'docs', '', '', '2023-07-13 06:45:05'),
(11, '/admin/article/cat/sub/add', 'post', 'admin', '类目副本新增/编辑', 'article', '2023-07-13 06:45:05'),
(12, '/admin/good/info/list', 'post', 'admin', '标准类目列表', 'good_view', '2023-07-13 06:45:05'),
(13, '/admin/member/is_shop_blacklist', 'post', 'admin', '是否在商店黑名单', 'member', '2023-07-13 06:45:05'),
(14, '/admin/member_group/add', 'post', 'admin', '添加会员组', 'member_group', '2023-07-13 06:45:05'),
(15, '/admin/sku/value/add', 'post', 'admin', '规格值新增/编辑', 'good_edit', '2023-07-13 06:45:06'),
(16, '/admin/member/shop_blacklist/remove', 'post', 'admin', '将用户移出商店黑名单', 'member', '2023-07-13 06:45:06'),
(17, '/admin/member/unbind_member_to_shop', 'post', 'admin', '解绑会员到商店', 'member', '2023-07-13 06:45:06'),
(18, '/mall/order/insured', 'post', 'mall', '生成保险单', '商城订单', '2023-07-13 06:45:06'),
(19, '/admin/cat/add', 'post', 'admin', '新增/编辑类目', 'cat', '2023-07-13 06:45:06'),
(20, '/admin/domain/get', 'post', 'admin', '查询域名', 'domain', '2023-07-13 06:45:06'),
(21, '/admin/lang/get', 'post', 'admin', '获取语言', 'lang', '2023-07-13 06:45:06'),
(22, '/admin/member/email_unique', 'get', 'admin', '邮箱是否唯一', 'merchant', '2023-07-13 06:45:06'),
(23, '/admin/menu/max_sort', 'get', 'admin', '菜单最大排序', 'menu', '2023-07-13 06:45:06'),
(24, '/mall/cart/add', 'post', 'mall', '添加购物车', '购物车', '2023-07-13 06:45:06'),
(25, '/admin/member_group/update', 'post', 'admin', '更新会员组', 'member_group', '2023-07-13 06:45:06'),
(26, '/admin/post/max_sort', 'get', 'admin', '岗位最大排序', 'post', '2023-07-13 06:45:06'),
(27, '/admin/warehouse/update', 'post', 'admin', '更新仓库', 'warehouse', '2023-07-13 06:45:06'),
(28, '/mall/cart/get', 'post', 'mall', '获取购物车商品信息', '购物车', '2023-07-13 06:45:06'),
(29, '/mall/member/logout', 'post', 'mall', '注销', '商城会员', '2023-07-13 06:45:06'),
(30, '/mall/order/create', 'post', 'mall', '订单创建', '商城订单', '2023-07-13 06:45:06'),
(31, '/admin/member/shop_blacklist', 'post', 'admin', '指定商店黑名单', 'member', '2023-07-13 06:45:06'),
(32, '/admin/order/push/log', 'post', 'admin', '订单推送日志', 'order', '2023-07-13 06:45:06'),
(33, '/admin/pmethod/currencyrates/set', 'post', 'admin', '获取币种汇率关系', 'pmethod', '2023-07-13 06:45:06'),
(34, '/admin/submember/delete', 'post', 'admin', '删除子账户', 'submember', '2023-07-13 06:45:06'),
(35, '/admin/tax_rate/rate_list', 'post', 'admin', 'sku税率列表', 'good_view', '2023-07-13 06:45:06'),
(36, '/admin/warehouse/delete', 'post', 'admin', '删除仓库', 'warehouse', '2023-07-13 06:45:06'),
(37, '/mall/fav/add', 'post', 'mall', '添加收藏', '商品收藏', '2023-07-13 06:45:06'),
(38, '/mall/member/change_pwd', 'post', 'mall', '修改密码', '商城会员', '2023-07-13 06:45:06'),
(39, '/admin/ai/trans', 'post', 'admin', '翻译', 'ai', '2023-07-13 06:45:06'),
(40, '/admin/dept/list_tree', 'get', 'admin', '获取部门列表树', 'dept', '2023-07-13 06:45:06'),
(41, '/admin/login/logout', 'post', 'admin', '注销登录', 'login', '2023-07-13 06:45:06'),
(42, '/admin/member_tag/update/name', 'post', 'admin', '更新标签名称', 'member_tag', '2023-07-13 06:45:06'),
(43, '/admin/postfee/mode-add', 'post', 'admin', '运费方式新增/编辑', 'postfee', '2023-07-13 06:45:06'),
(44, '/admin/sku/props/list', 'post', 'admin', '规格列表', 'good_view', '2023-07-13 06:45:06'),
(45, '/api/log/export', 'get', 'api', '导出日志', '日志接口', '2023-07-13 06:45:06'),
(46, '/api/sku/receiverate', 'post', 'api', '接收商品税率', '商品', '2023-07-13 06:45:06'),
(47, '/admin/article/cat/add', 'post', 'admin', '类目新增/编辑', 'article', '2023-07-13 06:45:06'),
(48, '/admin/good/hscode/search', 'post', 'admin', '查询hscode信息', 'good_view', '2023-07-13 06:45:06'),
(49, '/admin/good/info', 'post', 'admin', '商品详情', 'good_view', '2023-07-13 06:45:06'),
(50, '/admin/member/shop_blacklist/add', 'post', 'admin', '将用户加入商店黑名单', 'member', '2023-07-13 06:45:06'),
(51, '/admin/good/sub/add', 'post', 'admin', '副本商品新增/编辑', 'good_edit', '2023-07-13 06:45:06'),
(52, '/admin/member/remark/add', 'post', 'admin', '添加会员备注', 'member_remark', '2023-07-13 06:45:06'),
(53, '/admin/member_grade/get_unbind_member_list_by_grade_id', 'post', 'admin', '根据等级ID获取未绑定的会员详细信息', 'member_grade', '2023-07-13 06:45:06'),
(54, '/admin/role/shop/add', 'post', 'admin', '增加店铺授权', 'role', '2023-07-13 06:45:06'),
(55, '/admin/config/max_sort', 'get', 'admin', '配置最大排序', 'config', '2023-07-13 06:45:06'),
(56, '/admin/domain/add', 'post', 'admin', '域名新增/编辑', 'domain', '2023-07-13 06:45:06'),
(57, '/admin/good/customs_item/search', 'post', 'admin', '查询备案商品信息', 'good_view', '2023-07-13 06:45:06'),
(58, '/admin/good/on_shelves', 'post', 'admin', '商品上下架', 'good_edit', '2023-07-13 06:45:06'),
(59, '/admin/resource/group_add', 'post', 'admin', '添加资源分组', 'resource', '2023-07-13 06:45:06'),
(60, '/admin/cat/delete', 'post', 'admin', '删除类目', 'cat', '2023-07-13 06:45:06'),
(61, '/admin/member_grade/unbind', 'post', 'admin', '解绑会员等级', 'member_grade', '2023-07-13 06:45:06'),
(62, '/mall/address/delete', 'post', 'mall', '删除收货地址', '商城收货地址', '2023-07-13 06:45:06'),
(63, '/mall/member/profile', 'post', 'mall', '个人信息', '商城会员', '2023-07-13 06:45:06'),
(64, '/admin/member/get_member_by_group_id_and_shop_id', 'post', 'admin', '根据分组ID和商店ID获取会员', 'member', '2023-07-13 06:45:06'),
(65, '/admin/shop/change_shop', 'post', 'admin', '切换店铺', 'shop', '2023-07-13 06:45:06'),
(66, '/mall/good/same/cat', 'post', 'mall', '同类目商品', '商城商品', '2023-07-13 06:45:06'),
(67, '/admin/member_grade/get_list_by_shop_id', 'post', 'admin', '根据店铺id获取会员等级列表', 'member_grade', '2023-07-13 06:45:06'),
(68, '/admin/sku/list', 'post', 'admin', 'sku列表', 'good_view', '2023-07-13 06:45:06'),
(69, '/admin/sku/value/delete', 'post', 'admin', '删除规格值', 'good_delete', '2023-07-13 06:45:06'),
(70, '/admin/sku/value/sub/add', 'post', 'admin', '规格值副本新增/编辑', 'good_edit', '2023-07-13 06:45:06'),
(71, '/admin/tax_rate/get_rate', 'post', 'admin', '获取sku税率', 'good_view', '2023-07-13 06:45:06'),
(72, '/admin/config/get_value', 'get', 'admin', '获取指定配置键的值', 'config', '2023-07-13 06:45:06'),
(73, '/admin/mallconfig/list', 'post', 'admin', '商城配置列表', 'mall_config', '2023-07-13 06:45:06'),
(74, '/admin/review/list', 'post', 'admin', '订单评论列表', 'order', '2023-07-13 06:45:06'),
(75, '/admin/shop/view/add', 'post', 'admin', '修改/新增', 'shop_view', '2023-07-13 06:45:06'),
(76, '/api/login/check', 'get', 'api', '登录效验', '登录接口', '2023-07-13 06:45:06'),
(77, '/admin/article/list', 'post', 'admin', '文章列表', 'article', '2023-07-13 06:45:06'),
(78, '/admin/member/get_member_by_tag_id_and_shop_id', 'post', 'admin', '根据标签ID和商店ID获取会员', 'member', '2023-07-13 06:45:06'),
(79, '/admin/shop/view/open_auto_trans', 'post', 'admin', '开启自动翻译', 'shop_view', '2023-07-13 06:45:06'),
(80, '/admin/tax_rate/delete', 'post', 'admin', '删除sku税率', 'good_delete', '2023-07-13 06:45:06'),
(81, '/admin/article/get', 'post', 'admin', '查询文章', 'article', '2023-07-13 06:45:06'),
(82, '/admin/submember/name_unique', 'get', 'admin', '会员名称是否唯一', 'submember', '2023-07-13 06:45:06'),
(83, '/admin/warehouse/stock/paging', 'post', 'admin', '读取仓库商品库存', 'warehouse', '2023-07-13 06:45:06'),
(84, '/mall/order/sales_order/list', 'post', 'mall', '售后单列表', '商城订单', '2023-07-13 06:45:06'),
(85, '/admin/member/remark/list', 'post', 'admin', '获取会员备注列表', 'member_remark', '2023-07-13 06:45:06'),
(86, '/admin/member_grade/delete', 'post', 'admin', '删除会员等级', 'member_grade', '2023-07-13 06:45:06'),
(87, '/admin/sku/stock/get', 'post', 'admin', '获取sku库存', 'good_stock', '2023-07-13 06:45:06'),
(88, '/api/log/list', 'get', 'api', '获取日志列表', '日志接口', '2023-07-13 06:45:06'),
(89, '/admin/tongji/user-buy', 'post', 'admin', '用户购买统计', 'tongji', '2023-07-13 06:45:06'),
(90, '/admin/benefit_code/statistics', 'post', 'admin', '统计信息', 'benefit_code', '2023-07-13 06:45:06'),
(91, '/admin/cat/sub/add', 'post', 'admin', '类目副本新增/编辑', 'cat', '2023-07-13 06:45:06'),
(92, '/admin/sku/delete', 'post', 'admin', '删除sku', 'good_delete', '2023-07-13 06:45:06'),
(93, '/mall/cart/update', 'post', 'mall', '购物车商品数量更新', '购物车', '2023-07-13 06:45:06'),
(94, '/admin/after_sales/refund', 'post', 'admin', '发起退款', 'after_sales', '2023-07-13 06:45:06'),
(95, '/mall/order/after_sales/apply', 'post', 'mall', '申请售后', '商城订单', '2023-07-13 06:45:06'),
(96, '/mall/config/all', 'post', 'mall', '配置列表', '商城店铺', '2023-07-13 06:45:06'),
(97, '/admin/config/edit', 'post', 'admin', '修改/新增配置', 'config', '2023-07-13 06:45:06'),
(98, '/admin/member_grade/list', 'post', 'admin', '获取会员等级列表', 'member_grade', '2023-07-13 06:45:06'),
(99, '/admin/shop/update_bind', 'post', 'admin', '商户子账户绑定店铺', 'shop', '2023-07-13 06:45:06'),
(100, '/mall/cart/num', 'post', 'mall', '获取商品数量', '购物车', '2023-07-13 06:45:06'),
(101, '/admin/standard/cat', 'post', 'admin', '标准类目列表', 'standard_cat', '2023-07-13 06:45:06'),
(102, '/admin/tax_rate/create', 'post', 'admin', '创建sku税率', 'good_edit', '2023-07-13 06:45:06'),
(103, '/admin/good/delete', 'post', 'admin', '删除商品', 'good_delete', '2023-07-13 06:45:06'),
(104, '/admin/member_grade/update_bind', 'post', 'admin', '更新会员等级绑定', 'member_grade', '2023-07-13 06:45:06'),
(105, '/admin/member_group_relation/get_list_by_group_id', 'post', 'admin', '根据群组id获取已经绑定的会员详细信息列表', 'member_group', '2023-07-13 06:45:06'),
(106, '/admin/member_tag/bound/list', 'post', 'admin', '获取标签绑定会员列表', 'member_tag', '2023-07-13 06:45:06'),
(107, '/admin/postfee/list', 'post', 'admin', '运费列表', 'postfee', '2023-07-13 06:45:06'),
(108, '/admin/warehouse/stock/create', 'post', 'admin', '创建仓库商品库存', 'warehouse', '2023-07-13 06:45:06'),
(109, '/mall/member/update', 'post', 'mall', '更新', '商城会员', '2023-07-13 06:45:06'),
(110, '/admin/benefit_code/add', 'post', 'admin', '添加折扣码', 'benefit_code', '2023-07-13 06:45:06'),
(111, '/admin/dict/attribute', 'get', 'admin', '获取指定字典类型的属性数据', 'dict_data', '2023-07-13 06:45:06'),
(112, '/admin/email/setting', 'post', 'admin', '邮件服务设置', 'email', '2023-07-13 06:45:06'),
(113, '/admin/mall_config/save', 'post', 'admin', '保存店铺配置', 'shop_config', '2023-07-13 06:45:06'),
(114, '/mall/address/list', 'post', 'mall', '收货地址列表', '商城收货地址', '2023-07-13 06:45:06'),
(115, '/admin/dict_data/list', 'get', 'admin', '获取字典数据列表', 'dict_data', '2023-07-13 06:45:06'),
(116, '/admin/order/push', 'post', 'admin', '推送订单', 'order', '2023-07-13 06:45:06'),
(117, '/admin/synconfig/del', 'post', 'admin', '删除配置', 'sync_goods', '2023-07-13 06:45:06'),
(118, '/admin/trans_task/add_shop_job', 'post', 'admin', '投递商店级翻译任务', 'trans_task', '2023-07-13 06:45:06'),
(119, '/mall/cat/info', 'post', 'mall', '类目详情', '商城商品类目', '2023-07-13 06:45:06'),
(120, '/mall/member/login', 'post', 'mall', '登录', '商城会员', '2023-07-13 06:45:06'),
(121, '/admin/dict_type/view', 'get', 'admin', '获取指定字典类型信息', 'dict_data', '2023-07-13 06:45:06'),
(122, '/admin/sku/add', 'post', 'admin', 'sku新增或编辑', 'good_edit', '2023-07-13 06:45:06'),
(123, '/admin/trans_task/add_good_job', 'post', 'admin', '投递商品级翻译任务', 'trans_task', '2023-07-13 06:45:06'),
(124, '/mall/address/receiving_country', 'post', 'mall', '收货国家列表', '商城收货地址', '2023-07-13 06:45:06'),
(125, '/admin/member_group/list', 'post', 'admin', '会员组列表', 'member_group', '2023-07-13 06:45:06'),
(126, '/admin/role/list', 'get', 'admin', '获取角色列表', 'role', '2023-07-13 06:45:06'),
(127, '/mall/fav/delete', 'post', 'mall', '取消收藏', '商品收藏', '2023-07-13 06:45:06'),
(128, '/admin/cat/info', 'post', 'admin', '类目详情', 'cat', '2023-07-13 06:45:06'),
(129, '/admin/dict_data/max_sort', 'get', 'admin', '查询字典数据最大排序', 'dict_data', '2023-07-13 06:45:06'),
(130, '/admin/email/pull', 'post', 'admin', '拉取邮件', 'email', '2023-07-13 06:45:06'),
(131, '/admin/log/clear', 'post', 'admin', '清空日志', 'log', '2023-07-13 06:45:06'),
(132, '/admin/dict_data/view', 'get', 'admin', '获取指定字典数据信息', 'dict_data', '2023-07-13 06:45:06'),
(133, '/admin/warehouse/read', 'get', 'admin', '读取仓库列表', 'warehouse', '2023-07-13 06:45:06'),
(134, '/admin/member_group_relation/get_by_ids', 'post', 'admin', '根据ids获取会员组关系', 'member_group', '2023-07-13 06:45:06'),
(135, '/admin/member_tag/add', 'post', 'admin', '添加会员标签', 'member_tag', '2023-07-13 06:45:06'),
(136, '/admin/tax_rate/read', 'post', 'admin', '查询sku税率', 'good_view', '2023-07-13 06:45:06'),
(137, '/admin/tongji/goods-num', 'post', 'admin', '商品总数', 'tongji', '2023-07-13 06:45:06'),
(138, '/admin/email/list', 'post', 'admin', '获取邮件列表', 'email', '2023-07-13 06:45:06'),
(139, '/admin/member/mobile_unique', 'get', 'admin', '手机号是否唯一', 'merchant', '2023-07-13 06:45:06'),
(140, '/admin/member/profile', 'get', 'admin', '获取登录用户的基本信息', 'merchant', '2023-07-13 06:45:06'),
(141, '/admin/member_grade/update', 'post', 'admin', '更新会员等级', 'member_grade', '2023-07-13 06:45:06'),
(142, '/api/base/ip_location', 'get', 'api', '获取IP归属地信息', '基础接口', '2023-07-13 06:45:06'),
(143, '/admin/member/update_profile', 'post', 'admin', '更新会员资料', 'merchant', '2023-07-13 06:45:06'),
(144, '/mall/member/register', 'post', 'mall', '注册', '商城会员', '2023-07-13 06:45:06'),
(145, '/admin/article/delete', 'post', 'admin', '删除文章', 'article', '2023-07-13 06:45:06'),
(146, '/admin/dict_type/export', 'get', 'admin', '导出字典类型', 'dict_data', '2023-07-13 06:45:06'),
(147, '/admin/email/bind', 'post', 'admin', '绑定邮箱', 'email', '2023-07-13 06:45:06'),
(148, '/admin/member/blacklist', 'post', 'admin', '全局黑名单', 'merchant', '2023-07-13 06:45:06'),
(149, '/admin/dict_type/unique', 'get', 'admin', '类型是否唯一', 'dict_data', '2023-07-13 06:45:06'),
(150, '/admin/member/list', 'get', 'admin', '获取会员列表', 'merchant', '2023-07-13 06:45:06'),
(151, '/admin/member_group/delete', 'post', 'admin', '删除会员组', 'member_group', '2023-07-13 06:45:06'),
(152, '/admin/role/post_edit', 'post', 'admin', '岗位权限菜单编辑', 'post', '2023-07-13 06:45:06'),
(153, '/admin/good/add', 'post', 'admin', '商品新增/编辑', 'good_edit', '2023-07-13 06:45:06'),
(154, '/admin/log/export', 'get', 'admin', '导出日志', 'log', '2023-07-13 06:45:06'),
(155, '/admin/member_tag/unbound/list/tag', 'post', 'admin', '标签ID查询未绑定的会员列表', 'member_tag', '2023-07-13 06:45:06'),
(156, '/mall/config/list', 'post', 'mall', '获取店铺单个配置', '商城店铺', '2023-07-13 06:45:06'),
(157, '/mall/member/verify_email/apply', 'post', 'mall', '验证邮箱', '商城会员', '2023-07-13 06:45:06'),
(158, '/admin/mallconfig/save', 'post', 'admin', '保存商城配置', 'mall_config', '2023-07-13 06:45:06'),
(159, '/admin/member_grade/get_member_list_by_grade_id_with_bind', 'post', 'admin', '根据会员等级ID查询对应的用户信息列表，包含用户信息和是否存在绑定关系', 'member_grade', '2023-07-13 06:45:06'),
(160, '/admin/post/code_unique', 'get', 'admin', '岗位编码是否唯一', 'post', '2023-07-13 06:45:06'),
(161, '/api/base/lang', 'get', 'api', '获取lang信息', '基础接口', '2023-07-13 06:45:06'),
(162, '/admin/after_sales/switch', 'post', 'admin', '启用或关闭售后', 'after_sales', '2023-07-13 06:45:06'),
(163, '/admin/article/cat/info', 'post', 'admin', '类目详情', 'article', '2023-07-13 06:45:06'),
(164, '/admin/member/shop_member_list', 'post', 'admin', '商城会员列表', 'member', '2023-07-13 06:45:06'),
(165, '/mall/order/query', 'get', 'mall', '交易查询', '商城订单', '2023-07-13 06:45:06'),
(166, '/admin/dict_data/unique', 'get', 'admin', '数据键值是否唯一', 'dict_data', '2023-07-13 06:45:06'),
(167, '/admin/member/update_pwd', 'post', 'admin', '重置密码', 'merchant', '2023-07-13 06:45:06'),
(168, '/admin/upload/file/delete', 'post', 'admin', '删除文件', 'upload', '2023-07-13 06:45:06'),
(169, '/mall/order/sales_order/create', 'post', 'mall', '生成售后单', '商城订单', '2023-07-13 06:45:06'),
(170, '/admin/member_group_relation/delete', 'post', 'admin', '删除会员组关系', 'member_group', '2023-07-13 06:45:06'),
(171, '/admin/postfee/mode-list', 'post', 'admin', '运费方式列表', 'postfee', '2023-07-13 06:45:06'),
(172, '/admin/shop/view/info', 'post', 'admin', '详情', 'shop_view', '2023-07-13 06:45:06'),
(173, '/mall/benefit_code/operate', 'post', 'mall', '使用折扣码', '商城折扣码', '2023-07-13 06:45:06'),
(174, '/admin/trans/add', 'post', 'admin', '后端翻译添加', 'trans', '2023-07-13 06:45:06'),
(175, '/admin/warehouse/create', 'post', 'admin', '创建仓库', 'warehouse', '2023-07-13 06:45:06'),
(176, '/api/base/export', 'get', 'api', '导出字典类型', '字典接口', '2023-07-13 06:45:06'),
(177, '/mall/order/prepay/list', 'post', 'mall', '获取预支付订单', '商城订单', '2023-07-13 06:45:06'),
(178, '/admin/benefit_code/zend_country_list', 'post', 'admin', '树状国家列表', 'benefit_code', '2023-07-13 06:45:06'),
(179, '/admin/cat/parent/list', 'post', 'admin', '父级类目列表', 'cat', '2023-07-13 06:45:06'),
(180, '/admin/member/register', 'post', 'admin', '用户注册', 'merchant', '2023-07-13 06:45:06'),
(181, '/admin/synconfig/list', 'post', 'admin', '配置列表', 'sync_goods', '2023-07-13 06:45:06'),
(182, '/admin/post/view', 'get', 'admin', '获取指定信息', 'post', '2023-07-13 06:45:06'),
(183, '/admin/shop/get_bind_shop', 'post', 'admin', '已绑定店铺列表', 'shop', '2023-07-13 06:45:07'),
(184, '/admin/tongji/goods-sales', 'post', 'admin', '商品销售额', 'tongji', '2023-07-13 06:45:07'),
(185, '/admin/upload/file', 'post', 'admin', '上传文件', 'upload', '2023-07-13 06:45:07'),
(186, '/admin/dict_type/list', 'get', 'admin', '获取字典类型列表', 'dict_data', '2023-07-13 06:45:07'),
(187, '/admin/domain/get_main', 'post', 'admin', '查询主域名', 'domain', '2023-07-13 06:45:07'),
(188, '/admin/good/info/add', 'post', 'admin', '标准类目参数新增/编辑', 'standard_cat', '2023-07-13 06:45:07'),
(189, '/admin/menu/sub_role_list', 'get', 'admin', '查询角色菜单列表', 'menu', '2023-07-13 06:45:07'),
(190, '/mall/member/captcha', 'get', 'mall', '验证码', '商城会员', '2023-07-13 06:45:07'),
(191, '/admin/member_grade/add', 'post', 'admin', '创建会员等级', 'member_grade', '2023-07-13 06:45:07'),
(192, '/admin/member_grade/get_bind_list_by_grade', 'post', 'admin', '根据等级id获取会员等级绑定用户列表', 'member_grade', '2023-07-13 06:45:07'),
(193, '/api/log/clear', 'post', 'api', '清空日志', '日志接口', '2023-07-13 06:45:07'),
(194, '/mall/article/cat/list', 'post', 'mall', '类目列表', '商城文章类目', '2023-07-13 06:45:07'),
(195, '/admin/after_sales/list', 'post', 'admin', '售后单列表', 'after_sales', '2023-07-13 06:45:07'),
(196, '/admin/benefit_code/list', 'post', 'admin', '折扣码列表', 'benefit_code', '2023-07-13 06:45:07'),
(197, '/admin/good/filing/add', 'post', 'admin', '商品备案', 'good_edit', '2023-07-13 06:45:07'),
(198, '/admin/member/bind_member_to_shop', 'post', 'admin', '绑定会员到商店', 'member', '2023-07-13 06:45:07'),
(199, '/admin/member_group_relation/get_list_by_group_id_not_bind', 'post', 'admin', '根据群组id获取未绑定的会员详细信息列表', 'member_group', '2023-07-13 06:45:07'),
(200, '/admin/resource/list', 'post', 'admin', '获取API列表', 'resource', '2023-07-13 06:45:07'),
(201, '/admin/sku/props/add', 'post', 'admin', '规格新增/编辑', 'good_edit', '2023-07-13 06:45:07'),
(202, '/admin/synconfig/save', 'post', 'admin', '保存配置', 'sync_goods', '2023-07-13 06:45:07'),
(203, '/admin/dict_type/edit', 'post', 'admin', '修改/新增字典类型', 'dict_data', '2023-07-13 06:45:07'),
(204, '/admin/good/info/delete/one', 'post', 'admin', '标准类目参数删除', 'standard_cat', '2023-07-13 06:45:07'),
(205, '/admin/member_grade/get_bind_list_by_member', 'post', 'admin', '根据会员id获取用户会员等级绑定列表', 'member_grade', '2023-07-13 06:45:07'),
(206, '/admin/member_group_relation/get_list', 'post', 'admin', '获取会员组关系列表', 'member_group', '2023-07-13 06:45:07'),
(207, '/mall/article/list', 'post', 'mall', '商城底部菜单列表', '商城文章', '2023-07-13 06:45:07'),
(208, '/admin/resource/group_resource_list', 'post', 'admin', '分组资源列表', 'resource', '2023-07-13 06:45:07'),
(209, '/admin/role/dynamic', 'get', 'admin', '获取动态路由', 'role', '2023-07-13 06:45:07'),
(210, '/admin/upload/file/list', 'post', 'admin', '文件列表', 'upload', '2023-07-13 06:45:07'),
(211, '/mall/order/payer/update', 'post', 'mall', '更新支付人信息', '商城订单', '2023-07-13 06:45:07'),
(212, '/admin/dept/name_unique', 'get', 'admin', '部门名称是否唯一', 'dept', '2023-07-13 06:45:07'),
(213, '/admin/dict_type/refresh_cache', 'get', 'admin', '刷新字典缓存', 'dict_data', '2023-07-13 06:45:07'),
(214, '/admin/member/blacklist/add', 'post', 'admin', '将用户加入黑名单(全局）', 'merchant', '2023-07-13 06:45:07'),
(215, '/admin/member_tag/bound/list/tag', 'post', 'admin', '标签ID查询已经绑定的会员列表', 'member_tag', '2023-07-13 06:45:07'),
(216, '/admin/dict_data/edit', 'post', 'admin', '修改/新增字典数据', 'dict_data', '2023-07-13 06:45:07'),
(217, '/admin/log/list', 'get', 'admin', '获取日志列表', 'log', '2023-07-13 06:45:07'),
(218, '/admin/member_group_relation/update', 'post', 'admin', '更新会员组关系', 'member_group', '2023-07-13 06:45:07'),
(219, '/admin/menu/delete', 'post', 'admin', '删除菜单', 'menu', '2023-07-13 06:45:07'),
(220, '/admin/member/name_unique', 'get', 'admin', '会员名称是否唯一', 'merchant', '2023-07-13 06:45:07'),
(221, '/admin/menu/list', 'get', 'admin', '获取菜单列表', 'menu', '2023-07-13 06:45:07'),
(222, '/admin/shop/getinfo', 'post', 'admin', '店铺详细信息', 'shop', '2023-07-13 06:45:07'),
(223, '/admin/shop/list', 'post', 'admin', '店铺列表', 'shop', '2023-07-13 06:45:07'),
(224, '/admin/article/add', 'post', 'admin', '文章新增/编辑', 'article', '2023-07-13 06:45:07'),
(225, '/admin/dict_data/delete', 'post', 'admin', '删除字典数据', 'dict_data', '2023-07-13 06:45:07'),
(226, '/admin/good/list', 'post', 'admin', '商品列表', 'good_view', '2023-07-13 06:45:07'),
(227, '/admin/member/info', 'get', 'admin', '获取登录用户信息', 'merchant', '2023-07-13 06:45:07'),
(228, '/admin/syngoods/trigger', 'post', 'admin', '同步商品', 'sync_goods', '2023-07-13 06:45:07'),
(229, '/mall/cart/clear', 'post', 'mall', '清空购物车', '购物车', '2023-07-13 06:45:07'),
(230, '/mall/fav/num', 'post', 'mall', '收藏总数量', '商品收藏', '2023-07-13 06:45:07'),
(231, '/mall/order/payment/credential', 'post', 'mall', '生成支付凭据', '商城订单', '2023-07-13 06:45:07'),
(232, '/admin/post/list', 'get', 'admin', '获取岗位列表', 'post', '2023-07-13 06:45:07'),
(233, '/admin/postfee/add', 'post', 'admin', '运费模板新增/编辑', 'postfee', '2023-07-13 06:45:07'),
(234, '/admin/role/member_list', 'get', 'admin', '获取角色下的会员列表', 'role', '2023-07-13 06:45:07'),
(235, '/admin/shop/view/list', 'post', 'admin', '列表', 'shop_view', '2023-07-13 06:45:07'),
(236, '/admin/member_tag/bound/member/list', 'post', 'admin', '获取会员绑定标签列表', 'member_tag', '2023-07-13 06:45:07'),
(237, '/admin/member_tag/delete', 'post', 'admin', '删除会员标签', 'member_tag', '2023-07-13 06:45:07'),
(238, '/admin/menu/code_unique', 'get', 'admin', '菜单编码是否唯一', 'menu', '2023-07-13 06:45:07'),
(239, '/admin/order/items', 'post', 'admin', '订单商品', 'order', '2023-07-13 06:45:07'),
(240, '/mall/member/verify_email/confirm', 'post', 'mall', '验证邮箱确认', '商城会员', '2023-07-13 06:45:07'),
(241, '/mall/email/send', 'post', 'mall', '发送邮件', '商城-邮件', '2023-07-13 06:45:07'),
(242, '/mall/member/reset_password/apply', 'post', 'mall', '重置密码', '商城会员', '2023-07-13 06:45:07'),
(243, '/admin/member/reset_pwd', 'post', 'admin', '重置密码', 'merchant', '2023-07-13 06:45:07'),
(244, '/admin/member_group/get_list_by_ids', 'post', 'admin', '根据id获取会员组列表', 'member_group', '2023-07-13 06:45:07'),
(245, '/admin/submember/list', 'get', 'admin', '获取会员列表', 'submember', '2023-07-13 06:45:07'),
(246, '/admin/warehouse/stock/update', 'post', 'admin', '更新仓库商品库存', 'warehouse', '2023-07-13 06:45:07'),
(247, '/admin/notice/view', 'get', 'admin', '获取指定信息', 'notice', '2023-07-13 06:45:07'),
(248, '/admin/post/delete', 'post', 'admin', '删除岗位', 'post', '2023-07-13 06:45:07'),
(249, '/admin/submember/mobile_unique', 'get', 'admin', '手机号是否唯一', 'submember', '2023-07-13 06:45:07'),
(250, '/api/login/sign', 'post', 'api', '提交登录', '登录接口', '2023-07-13 06:45:07'),
(251, '/admin/dept/delete', 'post', 'admin', '删除部门', 'dept', '2023-07-13 06:45:07'),
(252, '/admin/menu/view', 'get', 'admin', '获取指定菜单信息', 'menu', '2023-07-13 06:45:07'),
(253, '/admin/notice/delete', 'post', 'admin', '删除公告', 'notice', '2023-07-13 06:45:07'),
(254, '/admin/notice/name_unique', 'get', 'admin', '公告名称是否唯一', 'notice', '2023-07-13 06:45:07'),
(255, '/docs/admin', '', 'docs', '', '', '2023-07-13 06:45:07'),
(256, '/mall/review/add', 'post', 'mall', '订单评论增加', '订单评论', '2023-07-13 06:45:07'),
(257, '/admin/login/sub_sign', 'post', 'admin', '商户子账号登录', 'login', '2023-07-13 06:45:07'),
(258, '/admin/order/insure', 'post', 'admin', '保单推送日志', 'order', '2023-07-13 06:45:07'),
(259, '/admin/role/shop/list', 'post', 'admin', '列表店铺授权', 'role', '2023-07-13 06:45:07'),
(260, '/mall/order/preorder', 'post', 'mall', '商品预下单', '商城订单', '2023-07-13 06:45:07'),
(261, '/admin/menu/role_list', 'get', 'admin', '查询角色菜单列表', 'menu', '2023-07-13 06:45:07'),
(262, '/admin/submember/email_unique', 'get', 'admin', '邮箱是否唯一', 'submember', '2023-07-13 06:45:07'),
(263, '/admin/tongji/real-time-data', 'post', 'admin', '实时数据', 'tongji', '2023-07-13 06:45:07'),
(264, '/admin/benefit_code/country_list', 'post', 'admin', '国家列表', 'benefit_code', '2023-07-13 06:45:07'),
(265, '/admin/member_group_relation/add', 'post', 'admin', '添加会员组关系', 'member_group', '2023-07-13 06:45:07'),
(266, '/admin/member_tag/list', 'post', 'admin', '获取会员标签列表', 'member_tag', '2023-07-13 06:45:07'),
(267, '/admin/member_tag/unbound', 'post', 'admin', '解绑会员标签', 'member_tag', '2023-07-13 06:45:07'),
(268, '/admin/config/list', 'get', 'admin', '获取配置列表', 'config', '2023-07-13 06:45:07'),
(269, '/api/log/examine/receive', 'post', 'api', '接收申报回执', '日志接口', '2023-07-13 06:45:07'),
(270, '/mall/cart/remove', 'post', 'mall', '购物车商品移出', '购物车', '2023-07-13 06:45:07'),
(271, '/mall/order/list', 'post', 'mall', '订单列表', '商城订单', '2023-07-13 06:45:07'),
(272, '/admin/dept/view', 'get', 'admin', '获取指定信息', 'dept', '2023-07-13 06:45:07'),
(273, '/admin/good/sku/search', 'post', 'admin', '查询sku信息', 'good_view', '2023-07-13 06:45:07'),
(274, '/admin/member/get_member_by_level_id_and_shop_id', 'post', 'admin', '根据等级ID和商店ID获取会员', 'member', '2023-07-13 06:45:07'),
(275, '/admin/post/edit', 'post', 'admin', '修改/新增岗位', 'post', '2023-07-13 06:45:07'),
(276, '/admin/resource/group_add_resource', 'post', 'admin', '分组添加资源', 'resource', '2023-07-13 06:45:07'),
(277, '/admin/shop/view/close_auto_trans', 'post', 'admin', '关闭自动翻译', 'shop_view', '2023-07-13 06:45:07'),
(278, '/mall/pmethod/get', 'post', 'mall', '获取支付方式', '支付方式', '2023-07-13 06:45:07'),
(279, '/mall/review/list', 'post', 'mall', '订单评论列表', '订单评论', '2023-07-13 06:45:07'),
(280, '/admin/member_tag/list/shop', 'post', 'admin', '获取店铺下的会员标签列表', 'member_tag', '2023-07-13 06:45:07'),
(281, '/admin/role/edit', 'post', 'admin', '编辑角色菜单权限', 'role', '2023-07-13 06:45:07'),
(282, '/admin/sku/stock/update', 'post', 'admin', '更新sku库存', 'good_stock', '2023-07-13 06:45:07'),
(283, '/admin/member_tag/bind', 'post', 'admin', '绑定会员标签', 'member_tag', '2023-07-13 06:45:07'),
(284, '/admin/order/ship', 'post', 'admin', '订单发货', 'order', '2023-07-13 06:45:07'),
(285, '/admin/tax_rate/update', 'post', 'admin', '更新sku税率', 'good_edit', '2023-07-13 06:45:07'),
(286, '/api/order/receiveship', 'post', 'api', '接收运单回执', '订单', '2023-07-13 06:45:07'),
(287, '/admin/config/name_unique', 'get', 'admin', '配置名称是否唯一', 'config', '2023-07-13 06:45:07'),
(288, '/admin/good/info/value/delete/one', 'post', 'admin', '删除商品参数值', 'good_delete', '2023-07-13 06:45:07'),
(289, '/admin/member/edit', 'post', 'admin', '修改/新增会员', 'merchant', '2023-07-13 06:45:07'),
(290, '/admin/member/view', 'get', 'admin', '获取指定信息', 'merchant', '2023-07-13 06:45:07'),
(291, '/mall/article/new_list', 'post', 'mall', '文章列表', '商城文章', '2023-07-13 06:45:07'),
(292, '/api/member/profile', 'get', 'api', '获取登录用户的基本信息', '会员接口', '2023-07-13 06:45:07'),
(293, '/admin/login/captcha', 'get', 'admin', '获取登录验证码', 'login', '2023-07-13 06:45:07'),
(294, '/admin/resource/group_list', 'post', 'admin', '获取所有API分组列表', 'resource', '2023-07-13 06:45:07'),
(295, '/admin/shippingpolicy/priority/create', 'post', 'admin', '创建优先发货策略', 'shippingpolicy', '2023-07-13 06:45:07'),
(296, '/admin/submember/view', 'get', 'admin', '获取指定信息', 'submember', '2023-07-13 06:45:07'),
(297, '/admin/config/delete', 'post', 'admin', '删除配置', 'config', '2023-07-13 06:45:07'),
(298, '/admin/member_grade/check_bind_exist', 'post', 'admin', '检查会员等级绑定是否存在', 'member_grade', '2023-07-13 06:45:07'),
(299, '/admin/submember/reset_pwd', 'post', 'admin', '重置密码', 'submember', '2023-07-13 06:45:07'),
(300, '/admin/tongji/order-money', 'post', 'admin', '订单金额', 'tongji', '2023-07-13 06:45:07'),
(301, '/admin/role/shop/del', 'post', 'admin', '移除店铺授权', 'role', '2023-07-13 06:45:07'),
(302, '/admin/sku/sub/add', 'post', 'admin', 'sku副本新增或编辑', 'good_edit', '2023-07-13 06:45:07'),
(303, '/mall/cat/list', 'post', 'mall', '类目列表', '商城商品类目', '2023-07-13 06:45:07'),
(304, '/admin/dept/max_sort', 'get', 'admin', '部门最大排序', 'dept', '2023-07-13 06:45:07'),
(305, '/admin/member/max_sort', 'get', 'admin', '会员最大排序', 'merchant', '2023-07-13 06:45:07'),
(306, '/admin/menu/edit', 'post', 'admin', '修改/新增菜单', 'menu', '2023-07-13 06:45:07'),
(307, '/admin/notice/edit', 'post', 'admin', '修改/新增公告', 'notice', '2023-07-13 06:45:07'),
(308, '/api/dict/attribute', 'get', 'api', '获取指定字典类型的属性数据', 'dict_data', '2023-07-13 06:45:07'),
(309, '/mall/address/add', 'post', 'mall', '收货地址添加和更新', '商城收货地址', '2023-07-13 06:45:07'),
(310, '/mall/member/reset_password/confirm', 'post', 'mall', '重置密码确认', '商城会员', '2023-07-13 06:45:07'),
(311, '/mall/order/payment', 'post', 'mall', '订单支付', '商城订单', '2023-07-13 06:45:07'),
(312, '/admin/mall_config/get', 'post', 'admin', '获取店铺配置', 'shop_config', '2023-07-13 06:45:07'),
(313, '/admin/notice/max_sort', 'get', 'admin', '公告最大排序', 'notice', '2023-07-13 06:45:07'),
(314, '/admin/resource/group_batch_add_resource', 'post', 'admin', '分组批量添加资源', 'resource', '2023-07-13 06:45:07'),
(315, '/admin/sku/prop/delete', 'post', 'admin', '删除规格', 'good_delete', '2023-07-13 06:45:07'),
(316, '/admin/member_tag/bound/list/tag/member', 'post', 'admin', '根据标签ID查询对应的用户信息列表，包含用户信息和是否存在绑定关系', 'member_tag', '2023-07-13 06:45:07'),
(317, '/admin/notice/list', 'get', 'admin', '获取公告列表', 'notice', '2023-07-13 06:45:07'),
(318, '/admin/pmethod/currency/get', 'get', 'admin', '获取币种类型', 'pmethod', '2023-07-13 06:45:07'),
(319, '/admin/submember/edit', 'post', 'admin', '修改/新增子账户', 'submember', '2023-07-13 06:45:07'),
(320, '/admin/dept/edit', 'post', 'admin', '修改/新增部门', 'dept', '2023-07-13 06:45:07'),
(321, '/admin/dict_type/delete', 'post', 'admin', '删除字典类型', 'dict_data', '2023-07-13 06:45:07'),
(322, '/admin/member/blacklist/remove', 'post', 'admin', '将用户移出黑名单(全局)', 'merchant', '2023-07-13 06:45:07'),
(323, '/admin/member_grade/get_member_list_by_grade_id', 'post', 'admin', '根据等级ID获取会员详细信息', 'member_grade', '2023-07-13 06:45:07'),
(324, '/mall/good/list', 'post', 'mall', '商品列表', '商品', '2023-07-13 06:45:07'),
(325, '/admin/member_grade/bind', 'post', 'admin', '绑定会员等级', 'member_grade', '2023-07-13 06:45:07'),
(326, '/mall/good/info', 'post', 'mall', '商品详情', '商城商品', '2023-07-13 06:45:07'),
(327, '/admin/article/cat/list', 'post', 'admin', '类目列表', 'article', '2023-07-13 06:45:07'),
(328, '/admin/article/sub/add', 'post', 'admin', '文章副本新增/编辑', 'article', '2023-07-13 06:45:07'),
(329, '/admin/dept/list', 'get', 'admin', '获取部门列表', 'dept', '2023-07-13 06:45:07'),
(330, '/admin/domain/list', 'post', 'admin', '域名列表', 'domain', '2023-07-13 06:45:07'),
(331, '/admin/order/list', 'post', 'admin', '订单列表', 'order', '2023-07-13 06:45:07'),
(332, '/admin/tongji/order-data', 'post', 'admin', '订单数据', 'tongji', '2023-07-13 06:45:07'),
(333, '/mall/article/get', 'post', 'mall', '查询文章', '商城文章', '2023-07-13 06:45:07'),
(334, '/mall/member/refresh_token', 'post', 'mall', '刷新token', '商城会员', '2023-07-13 06:45:07'),
(335, '/admin/menu/name_unique', 'get', 'admin', '菜单名称是否唯一', 'menu', '2023-07-13 06:45:07'),
(336, '/admin/menu/search_list', 'get', 'admin', '获取菜单列表', 'menu', '2023-07-13 06:45:07'),
(337, '/admin/sku/props/sub/add', 'post', 'admin', '规格副本新增/编辑', 'good_edit', '2023-07-13 06:45:07'),
(338, '/api/login/logout', 'get', 'api', '注销登录', '登录接口', '2023-07-13 06:45:07'),
(339, '/admin/email/send', 'post', 'admin', '发送邮件', 'email', '2023-07-13 06:45:07'),
(340, '/admin/member/delete', 'post', 'admin', '删除会员', 'merchant', '2023-07-13 06:45:07'),
(341, '/admin/member/email/verify', 'post', 'admin', '验证注册邮箱', 'merchant', '2023-07-13 06:45:07'),
(342, '/admin/member/remark_list', 'post', 'admin', '会员备注列表', 'member_remark', '2023-07-13 06:45:07'),
(343, '/docs/mall', '', 'docs', '', '', '2023-07-13 06:45:07'),
(344, '/mall/shop/view', 'post', 'mall', '列表', '商城视图', '2023-07-13 06:55:23'),
(345, '/mall/subscribes/delete', 'post', 'mall', '删除订阅', '订阅', '2023-07-13 06:55:23'),
(346, '/mall/sitemap.xml', 'get', 'mall', '生成siteMap', 'siteMap', '2023-07-13 06:55:23'),
(347, '/mall/subscribes/add', 'post', 'mall', '添加订阅', '订阅', '2023-07-13 06:55:24'),
(348, '/mall/standard/cat', 'post', 'mall', '商城标准类目列表', '商城商品', '2023-07-13 06:55:24'),
(349, '/mall/subscribes/list', 'post', 'mall', '订阅列表', '订阅', '2023-07-13 06:55:24'),
(350, '/mall/shop-config/get', 'post', 'mall', '店铺配置单个查询', '商城店铺', '2023-07-13 06:55:24'),
(351, '/mall/shop/list', 'get', 'mall', '店铺列表', '商城店铺', '2023-07-13 06:55:24'),
(352, '/mall/shop-config/all', 'post', 'mall', '店铺配置列表', '商城店铺', '2023-07-13 06:55:24'),
(353, '/mall/trans/add', 'post', 'mall', '前端翻译添加', '翻译', '2023-07-13 06:55:24'),
(354, '/notify/wechatpay/basic/payment', 'post', 'notify', '直连商户支付回调通知', '微信支付回调通知', '2023-07-13 08:51:04'),
(355, '/notify/wechatpay/refund', 'post', 'notify', '微信支付退款回调通知', '微信支付回调通知', '2023-07-13 08:51:04'),
(356, '/oauth/google', 'get', 'oauth', 'Google授权', '第三方授权', '2023-07-13 08:51:04'),
(357, '/notify/paypal/payment', 'post', 'notify', '订单支付成功通知', 'paypal事件回调', '2023-07-13 08:51:05'),
(358, '/notify/wechatpay/payment', 'post', 'notify', '微信支付支付回调通知', '微信支付回调通知', '2023-07-13 08:51:05'),
(359, '/oauth/facebook/callback', 'get', 'oauth', 'Facebook授权回调', '第三方授权', '2023-07-13 08:51:05'),
(360, '/notify/paypal/refund', 'post', 'notify', '订单退款成功通知', 'paypal事件回调', '2023-07-13 08:51:05'),
(361, '/oauth/facebook', 'get', 'oauth', 'Facebook授权', '第三方授权', '2023-07-13 08:51:05'),
(362, '/oauth/twitter/callback', 'get', 'oauth', 'Twitter授权回调', '第三方授权', '2023-07-13 13:03:55'),
(363, '/oauth/google/callback', 'get', 'oauth', 'Google授权回调', '第三方授权', '2023-07-13 13:03:55'),
(364, '/oauth/wechat', 'get', 'oauth', '微信授权', '第三方授权', '2023-07-13 13:03:55'),
(365, '/oauth/twitter', 'get', 'oauth', 'Twitter授权', '第三方授权', '2023-07-13 13:03:55'),
(366, '/oauth/wechat/callback', 'get', 'oauth', '微信授权回调', '第三方授权', '2023-07-13 13:03:55'),
(367, '/oauth/microsoft/callback', 'get', 'oauth', '微软授权回调', '第三方授权', '2023-07-13 13:03:56'),
(368, '/oauth/microsoft', 'get', 'oauth', '微软授权', '第三方授权', '2023-07-13 13:03:56'),
(369, '/admin/order/waybill/list', 'post', 'admin', '订单物流', 'order', '2023-07-17 01:24:12'),
(370, '/oauth/wechat/check', 'get', 'oauth', '微信授权检测', '第三方授权', '2023-07-17 08:53:06'),
(371, '/admin/login/sub/sign', 'post', 'admin', '商户子账号登录', 'login', '2023-07-18 07:42:07'),
(372, '/admin/domain/delete', 'post', 'admin', '删除域名', 'domain', '2023-07-18 07:42:08'),
(373, '/admin/order/after_sales/apply', 'post', 'admin', '申请售后', 'order', '2023-07-19 07:27:10'),
(374, '/admin/shop/add', 'post', 'admin', '新增店铺', 'shop', '2023-07-19 07:27:10'),
(375, '/admin/google/oauth/callback', 'get', 'admin', '谷歌授权回调', 'google', '2023-08-17 06:22:46'),
(376, '/admin/google/add', 'post', 'admin', '添加域名', 'google', '2023-08-17 06:22:46'),
(377, '/admin/shop/info', 'post', 'admin', '店铺信息', 'shop', '2023-08-17 06:22:46'),
(378, '/admin/member/get_member_list', 'post', 'admin', '获取会员列表', 'member', '2023-08-17 06:22:46'),
(379, '/admin/login/sub/auth', 'post', 'admin', '子账户授权', 'login', '2023-08-17 06:22:46'),
(380, '/notify/refunded', '', 'notify', '', '消息通知', '2023-08-17 06:22:46'),
(381, '/admin/google/list', 'post', 'admin', '获取谷歌站点列表', 'google', '2023-08-17 06:22:46'),
(382, '/notify/paid', '', 'notify', '', '消息通知', '2023-08-17 06:22:46'),
(383, '/admin/google/search', 'post', 'admin', '获取网站搜索分析数据', 'google', '2023-08-17 06:22:46'),
(384, '/mall/member/phone/verify', 'post', 'mall', '验证注册手机号', 'member', '2023-08-17 06:22:46'),
(385, '/admin/recharge', 'get', 'admin', '充值', 'shop', '2023-08-17 06:22:47'),
(386, '/admin/config/sys/get', 'post', 'admin', '获取指定系统级别配置的值', 'config', '2023-08-17 06:22:47'),
(387, '/admin/order/import', 'post', 'admin', '订单导入', 'order', '2023-08-17 06:22:47'),
(388, '/mall/member/email/verify', 'post', 'mall', '验证注册邮箱', 'member', '2023-08-17 06:22:47'),
(389, '/admin/config/sys/set', 'post', 'admin', '获取指定系统级别配置的值', 'config', '2023-08-17 06:22:47'),
(390, '/admin/config/copyright', 'post', 'admin', '蜂洞授权信息', 'config', '2023-08-17 06:22:47'),
(391, '/admin/order/export', 'post', 'admin', '订单导出', 'order', '2023-08-17 06:22:47'),
(392, '/admin/google/urlindex', 'post', 'admin', '获取网址索引', 'google', '2023-08-17 06:22:47'),
(393, '/admin/shop/funds', 'get', 'admin', '查询店铺资金', 'shop', '2023-08-17 06:22:47'),
(394, '/admin/google/submit', 'post', 'admin', '提交网站地图', 'google', '2023-08-17 06:22:47'),
(395, '/admin/service/list', 'post', 'admin', '增值服务列表', 'service', '2023-08-25 02:57:54'),
(396, '/admin/service/add', 'post', 'admin', '增值服务添加/编辑', 'service', '2023-08-25 02:57:55'),
(397, '/admin/init/data', 'post', 'admin', '初始化数据', 'sync_goods', '2023-08-25 02:57:55'),
(398, '/admin/service/pause', 'post', 'admin', '增值服务暂停/开启', 'service', '2023-08-25 02:57:55'),
(399, '/admin/order/cancel_after_sales', 'post', 'admin', '取消售后', 'order', '2023-08-25 02:57:55'),
(400, '/admin/service/detail', 'post', 'admin', '增值服务详情', 'service', '2023-08-25 02:57:55');

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

--
-- 表的结构 `sys_resource_groups`
--

CREATE TABLE `sys_resource_groups` (
  `res_group_id` bigint(20) NOT NULL COMMENT '分组编号',
  `title` varchar(64) NOT NULL COMMENT '分组名称',
  `des` text NOT NULL COMMENT '分组描述',
  `cat` int(10) NOT NULL COMMENT '分组类别'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='资源分组表';

--
-- 转存表中的数据 `sys_resource_groups`
--

INSERT INTO `sys_resource_groups` (`res_group_id`, `title`, `des`, `cat`) VALUES
(1, 'post', 'post', 0),
(2, 'member_group', 'member_group', 0),
(3, 'shippingpolicy', 'shippingpolicy', 0),
(4, 'warehouse', 'warehouse', 0),
(5, 'cat', 'cat', 0),
(6, 'config', 'config', 0),
(7, 'login', 'login', 0),
(8, 'merchant', 'merchant', 0),
(9, 'article', 'article', 0),
(10, 'good_view', 'good_view', 0),
(11, 'member', 'member', 0),
(12, 'good_edit', 'good_edit', 0),
(13, 'domain', 'domain', 0),
(14, 'lang', 'lang', 0),
(15, 'menu', 'menu', 0),
(16, 'order', 'order', 0),
(17, 'pmethod', 'pmethod', 0),
(18, 'submember', 'submember', 0),
(19, 'ai', 'ai', 0),
(20, 'dept', 'dept', 0),
(21, 'member_tag', 'member_tag', 0),
(22, 'postfee', 'postfee', 0),
(23, 'member_remark', 'member_remark', 0),
(24, 'member_grade', 'member_grade', 0),
(25, 'role', 'role', 0),
(26, 'resource', 'resource', 0),
(27, 'shop', 'shop', 0),
(28, 'good_delete', 'good_delete', 0),
(29, 'mall_config', 'mall_config', 0),
(30, 'shop_view', 'shop_view', 0),
(31, 'good_stock', 'good_stock', 0),
(32, 'tongji', 'tongji', 0),
(33, 'benefit_code', 'benefit_code', 0),
(34, 'after_sales', 'after_sales', 0),
(35, 'standard_cat', 'standard_cat', 0),
(36, 'dict_data', 'dict_data', 0),
(37, 'email', 'email', 0),
(38, 'shop_config', 'shop_config', 0),
(39, 'sync_goods', 'sync_goods', 0),
(40, 'trans_task', 'trans_task', 0),
(41, 'log', 'log', 0),
(42, 'upload', 'upload', 0),
(43, 'trans', 'trans', 0),
(44, 'notice', 'notice', 0),
(45, 'search_customs_item_info', 'search_customs_item_info', 0),
(46, 'search_hs_code_info', 'search_hs_code_info', 0),
(47, 'search_sku_info', 'search_sku_info', 0),
(48, '商城订单', '商城订单', 0),
(49, 'google', 'google', 0),
(50, 'service', 'service', 0),
(51, 'review', 'review', 0),
(53, 'config_read_only', 'config_read_only', 0);

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

--
-- 表的结构 `sys_resource_group_apis`
--

CREATE TABLE `sys_resource_group_apis` (
  `res_group_id` bigint(20) NOT NULL COMMENT '资源分组编号',
  `resource_id` bigint(20) NOT NULL COMMENT 'api资源编号'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='资源组包含资源关系表';

--
-- 转存表中的数据 `sys_resource_group_apis`
--

INSERT INTO `sys_resource_group_apis` (`res_group_id`, `resource_id`) VALUES
(1, 1),
(1, 26),
(1, 152),
(1, 160),
(1, 182),
(1, 232),
(1, 248),
(1, 275),
(2, 3),
(2, 14),
(2, 25),
(2, 105),
(2, 125),
(2, 134),
(2, 151),
(2, 170),
(2, 199),
(2, 206),
(2, 218),
(2, 244),
(2, 265),
(3, 4),
(3, 295),
(4, 5),
(4, 27),
(4, 36),
(4, 83),
(4, 108),
(4, 133),
(4, 175),
(4, 246),
(5, 6),
(5, 19),
(5, 60),
(5, 91),
(5, 128),
(5, 179),
(6, 7),
(6, 55),
(6, 72),
(6, 97),
(6, 268),
(6, 287),
(6, 297),
(6, 386),
(6, 389),
(6, 390),
(7, 8),
(7, 41),
(7, 257),
(7, 293),
(7, 371),
(7, 379),
(8, 9),
(8, 22),
(8, 139),
(8, 140),
(8, 143),
(8, 148),
(8, 150),
(8, 167),
(8, 180),
(8, 214),
(8, 220),
(8, 227),
(8, 243),
(8, 289),
(8, 290),
(8, 305),
(8, 322),
(8, 340),
(8, 341),
(9, 11),
(9, 47),
(9, 77),
(9, 81),
(9, 145),
(9, 163),
(9, 224),
(9, 327),
(9, 328),
(10, 12),
(10, 35),
(10, 44),
(10, 48),
(10, 49),
(10, 57),
(10, 68),
(10, 71),
(10, 136),
(10, 226),
(10, 273),
(11, 13),
(11, 16),
(11, 17),
(11, 31),
(11, 50),
(11, 64),
(11, 78),
(11, 164),
(11, 198),
(11, 274),
(11, 378),
(12, 15),
(12, 51),
(12, 58),
(12, 70),
(12, 102),
(12, 122),
(12, 153),
(12, 197),
(12, 201),
(12, 285),
(12, 302),
(12, 337),
(13, 20),
(13, 56),
(13, 187),
(13, 330),
(13, 372),
(14, 21),
(15, 23),
(15, 189),
(15, 219),
(15, 221),
(15, 238),
(15, 252),
(15, 261),
(15, 306),
(15, 335),
(15, 336),
(16, 32),
(16, 74),
(16, 116),
(16, 239),
(16, 258),
(16, 284),
(16, 331),
(16, 369),
(16, 373),
(16, 387),
(16, 391),
(16, 399),
(16, 407),
(17, 33),
(17, 318),
(18, 34),
(18, 82),
(18, 245),
(18, 249),
(18, 262),
(18, 296),
(18, 299),
(18, 319),
(19, 39),
(20, 40),
(20, 212),
(20, 251),
(20, 272),
(20, 304),
(20, 320),
(20, 329),
(21, 42),
(21, 106),
(21, 135),
(21, 155),
(21, 215),
(21, 236),
(21, 237),
(21, 266),
(21, 267),
(21, 280),
(21, 283),
(21, 316),
(22, 43),
(22, 107),
(22, 171),
(22, 233),
(23, 52),
(23, 85),
(23, 342),
(24, 53),
(24, 61),
(24, 67),
(24, 86),
(24, 98),
(24, 104),
(24, 141),
(24, 159),
(24, 191),
(24, 192),
(24, 205),
(24, 298),
(24, 323),
(24, 325),
(25, 54),
(25, 126),
(25, 209),
(25, 234),
(25, 259),
(25, 281),
(25, 301),
(26, 59),
(26, 200),
(26, 208),
(26, 276),
(26, 294),
(26, 314),
(27, 65),
(27, 99),
(27, 183),
(27, 222),
(27, 223),
(27, 374),
(27, 377),
(27, 385),
(27, 393),
(28, 69),
(28, 80),
(28, 92),
(28, 103),
(28, 288),
(28, 315),
(29, 73),
(29, 158),
(30, 75),
(30, 79),
(30, 172),
(30, 235),
(30, 277),
(31, 87),
(31, 282),
(32, 89),
(32, 137),
(32, 184),
(32, 263),
(32, 300),
(32, 332),
(33, 90),
(33, 110),
(33, 178),
(33, 196),
(33, 264),
(34, 94),
(34, 162),
(34, 195),
(35, 101),
(35, 188),
(35, 204),
(36, 111),
(36, 115),
(36, 121),
(36, 129),
(36, 132),
(36, 146),
(36, 149),
(36, 166),
(36, 186),
(36, 203),
(36, 213),
(36, 216),
(36, 225),
(36, 321),
(37, 112),
(37, 130),
(37, 138),
(37, 147),
(37, 339),
(38, 113),
(38, 312),
(39, 117),
(39, 181),
(39, 202),
(39, 228),
(39, 397),
(40, 118),
(40, 123),
(41, 131),
(41, 154),
(41, 217),
(42, 168),
(42, 185),
(42, 210),
(43, 174),
(44, 247),
(44, 253),
(44, 254),
(44, 307),
(44, 313),
(44, 317),
(45, 57),
(46, 48),
(47, 273),
(48, 373),
(49, 375),
(49, 376),
(49, 381),
(49, 383),
(49, 392),
(49, 394),
(50, 395),
(50, 396),
(50, 398),
(50, 400),
(51, 74),
(53, 386);

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

--
-- 表的结构 `sys_role_group_paichu_apis`
--

CREATE TABLE `sys_role_group_paichu_apis` (
  `role_id` bigint(20) NOT NULL COMMENT '角色编号',
  `res_group_id` bigint(20) NOT NULL COMMENT '权限组编号',
  `resource_id` bigint(20) NOT NULL COMMENT '权限编号'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- 表的结构 `sys_version`
--

CREATE TABLE `sys_version` (
  `id` bigint(20) UNSIGNED NOT NULL COMMENT '表主键',
  `version` varchar(100) NOT NULL COMMENT '版本号',
  `create_time` datetime NOT NULL COMMENT '数据创建时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- 转储表的索引
--

--
-- 表的索引 `admin_alibaba_category`
--
ALTER TABLE `admin_alibaba_category`
  ADD PRIMARY KEY (`id`),
  ADD KEY `uniq` (`category_id`,`name`);

--
-- 表的索引 `admin_alibaba_order`
--
ALTER TABLE `admin_alibaba_order`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `order_id` (`order_id`,`shop_id`,`alibaba_order_id`) USING BTREE,
  ADD KEY `shop_id` (`shop_id`);

--
-- 表的索引 `admin_alibaba_order_items`
--
ALTER TABLE `admin_alibaba_order_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_id` (`order_id`,`shop_id`);

--
-- 表的索引 `admin_bank_info`
--
ALTER TABLE `admin_bank_info`
  ADD PRIMARY KEY (`bank_id`);

--
-- 表的索引 `admin_beehole_order`
--
ALTER TABLE `admin_beehole_order`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uniq` (`order_id`,`shop_id`,`config_id`,`login_to_shop_id`,`purchase_id`) USING BTREE;

--
-- 表的索引 `admin_beehole_order_items`
--
ALTER TABLE `admin_beehole_order_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `uniq` (`order_id`,`out_order_id`,`reference_id`,`good_id`,`sku_id`);

--
-- 表的索引 `admin_bigcommerce_product`
--
ALTER TABLE `admin_bigcommerce_product`
  ADD PRIMARY KEY (`id`),
  ADD KEY `admin_bigcommerce_product_shop_id_index` (`shop_id`);

--
-- 表的索引 `admin_chat_topics`
--
ALTER TABLE `admin_chat_topics`
  ADD PRIMARY KEY (`topic_id`);

--
-- 表的索引 `admin_configs`
--
ALTER TABLE `admin_configs`
  ADD PRIMARY KEY (`name`);

--
-- 表的索引 `admin_dept`
--
ALTER TABLE `admin_dept`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `admin_division_rule`
--
ALTER TABLE `admin_division_rule`
  ADD PRIMARY KEY (`rule_id`);

--
-- 表的索引 `admin_division_rule_log`
--
ALTER TABLE `admin_division_rule_log`
  ADD PRIMARY KEY (`log_id`);

--
-- 表的索引 `admin_ebay_product`
--
ALTER TABLE `admin_ebay_product`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `admin_yahoo_product_shop_id_item_code_uindex` (`shop_id`,`item_id`);

--
-- 表的索引 `admin_express_company`
--
ALTER TABLE `admin_express_company`
  ADD PRIMARY KEY (`express_id`),
  ADD UNIQUE KEY `logistics_code` (`logistics_code`),
  ADD KEY `logistics_code_2` (`logistics_code`),
  ADD KEY `express_id` (`express_id`),
  ADD KEY `logistics_name` (`logistics_name`);

--
-- 表的索引 `admin_fuwu`
--
ALTER TABLE `admin_fuwu`
  ADD PRIMARY KEY (`fuwu_id`);

--
-- 表的索引 `admin_fuwu_order`
--
ALTER TABLE `admin_fuwu_order`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fuwu_order_id` (`fuwu_order_id`);

--
-- 表的索引 `admin_fx_clearing`
--
ALTER TABLE `admin_fx_clearing`
  ADD PRIMARY KEY (`clearing_id`);

--
-- 表的索引 `admin_fx_clearing_detail`
--
ALTER TABLE `admin_fx_clearing_detail`
  ADD PRIMARY KEY (`clearing_detail_id`);

--
-- 表的索引 `admin_fx_detail`
--
ALTER TABLE `admin_fx_detail`
  ADD PRIMARY KEY (`detail_id`);

--
-- 表的索引 `admin_fx_distributor`
--
ALTER TABLE `admin_fx_distributor`
  ADD PRIMARY KEY (`distributor_id`);

--
-- 表的索引 `admin_fx_distributor_relation`
--
ALTER TABLE `admin_fx_distributor_relation`
  ADD PRIMARY KEY (`relation_id`);

--
-- 表的索引 `admin_fx_grade`
--
ALTER TABLE `admin_fx_grade`
  ADD PRIMARY KEY (`grade_id`);

--
-- 表的索引 `admin_gigab2b_order`
--
ALTER TABLE `admin_gigab2b_order`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `order_id` (`order_id`,`shop_id`),
  ADD KEY `shop_id` (`shop_id`);

--
-- 表的索引 `admin_gigab2b_order_items`
--
ALTER TABLE `admin_gigab2b_order_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_id` (`order_id`,`shop_id`);

--
-- 表的索引 `admin_giga_products`
--
ALTER TABLE `admin_giga_products`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uniq` (`sku`,`mpn`,`region`) USING BTREE,
  ADD KEY `search` (`sku`,`name`(191),`category_code`,`category`(191));

--
-- 表的索引 `admin_gmc_product`
--
ALTER TABLE `admin_gmc_product`
  ADD PRIMARY KEY (`id`),
  ADD KEY `admin_gmc_product_shop_id_index` (`shop_id`);

--
-- 表的索引 `admin_goods_public`
--
ALTER TABLE `admin_goods_public`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uniq` (`main_shop_id`,`main_good_id`,`main_view_id`,`son_shop_id`);

--
-- 表的索引 `admin_goods_supply`
--
ALTER TABLE `admin_goods_supply`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unq` (`shop_id`,`good_id`,`main_shop_id`);
ALTER TABLE `admin_goods_supply` ADD FULLTEXT KEY `search` (`good_data`);

--
-- 表的索引 `admin_goods_supply_stock_log`
--
ALTER TABLE `admin_goods_supply_stock_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sid` (`supply_id`,`son_shop_id`,`main_shop_id`,`main_good_id`,`main_sku_id`);

--
-- 表的索引 `admin_good_cang_shipping_method`
--
ALTER TABLE `admin_good_cang_shipping_method`
  ADD PRIMARY KEY (`id`),
  ADD KEY `wareShipping` (`shop_id`,`code`(128));

--
-- 表的索引 `admin_good_cang_shipping_methods`
--
ALTER TABLE `admin_good_cang_shipping_methods`
  ADD PRIMARY KEY (`id`),
  ADD KEY `wareShipping` (`code`);

--
-- 表的索引 `admin_good_cang_warehouse`
--
ALTER TABLE `admin_good_cang_warehouse`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `warehouse` (`shop_id`,`warehouse_code`) USING BTREE;

--
-- 表的索引 `admin_jiufang_shipping_method`
--
ALTER TABLE `admin_jiufang_shipping_method`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idx_code` (`code`,`warehouse_code`) USING BTREE,
  ADD KEY `idx_warehouse_code` (`wms_id`);

--
-- 表的索引 `admin_jiufang_warehouse`
--
ALTER TABLE `admin_jiufang_warehouse`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `warehouse_id` (`warehouse_id`),
  ADD KEY `idx_warehouse_code` (`warehouse_code`);

--
-- 表的索引 `admin_member_grade`
--
ALTER TABLE `admin_member_grade`
  ADD PRIMARY KEY (`grade_id`);

--
-- 表的索引 `admin_member_post`
--
ALTER TABLE `admin_member_post`
  ADD PRIMARY KEY (`member_id`,`post_id`);

--
-- 表的索引 `admin_member_role`
--
ALTER TABLE `admin_member_role`
  ADD PRIMARY KEY (`member_id`,`role_id`);

--
-- 表的索引 `admin_menu`
--
ALTER TABLE `admin_menu`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pid` (`pid`);

--
-- 表的索引 `admin_menu_perms`
--
ALTER TABLE `admin_menu_perms`
  ADD UNIQUE KEY `menu_id` (`menu_id`,`res_group_id`);

--
-- 表的索引 `admin_netsea_cats`
--
ALTER TABLE `admin_netsea_cats`
  ADD PRIMARY KEY (`cat_id`);

--
-- 表的索引 `admin_notice`
--
ALTER TABLE `admin_notice`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `admin_ozon_product`
--
ALTER TABLE `admin_ozon_product`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `admin_ozon_product_shop_id_goods_id_uindex` (`shop_id`,`goods_id`);

--
-- 表的索引 `admin_payment_entities`
--
ALTER TABLE `admin_payment_entities`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `admin_payment_entities_pk_2` (`payment_id`,`shop_id`);

--
-- 表的索引 `admin_payment_updates`
--
ALTER TABLE `admin_payment_updates`
  ADD PRIMARY KEY (`id`),
  ADD KEY `admin_payment_updates_payment_id_index` (`payment_id`),
  ADD KEY `admin_payment_updates_serial_id_index` (`serial_id`);

--
-- 表的索引 `admin_post`
--
ALTER TABLE `admin_post`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `admin_post_menu`
--
ALTER TABLE `admin_post_menu`
  ADD PRIMARY KEY (`post_id`,`menu_id`) USING BTREE;

--
-- 表的索引 `admin_rakuten_genre`
--
ALTER TABLE `admin_rakuten_genre`
  ADD PRIMARY KEY (`genre_id`),
  ADD KEY `p_gid` (`p_genre_id`);

--
-- 表的索引 `admin_rakuten_product`
--
ALTER TABLE `admin_rakuten_product`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `good_id` (`shop_id`,`good_id`,`rakuten_good_id`,`rakuten_shop_url`) USING BTREE;

--
-- 表的索引 `admin_read_notice`
--
ALTER TABLE `admin_read_notice`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `admin_rechare_application`
--
ALTER TABLE `admin_rechare_application`
  ADD PRIMARY KEY (`application_id`);

--
-- 表的索引 `admin_role_dept`
--
ALTER TABLE `admin_role_dept`
  ADD PRIMARY KEY (`role_id`,`dept_id`);

--
-- 表的索引 `admin_role_menu`
--
ALTER TABLE `admin_role_menu`
  ADD PRIMARY KEY (`role_id`,`menu_id`);

--
-- 表的索引 `admin_role_shop`
--
ALTER TABLE `admin_role_shop`
  ADD UNIQUE KEY `role_id` (`role_id`,`shop_id`);

--
-- 表的索引 `admin_submember_shop`
--
ALTER TABLE `admin_submember_shop`
  ADD UNIQUE KEY `submember_id` (`submember_id`,`shop_id`);

--
-- 表的索引 `admin_supply_orders`
--
ALTER TABLE `admin_supply_orders`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD UNIQUE KEY `order` (`order_id`,`user_id`,`shop_id`);

--
-- 表的索引 `admin_supply_order_item_relationship`
--
ALTER TABLE `admin_supply_order_item_relationship`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_id` (`order_id`),
  ADD KEY `good_id` (`main_good_id`) USING BTREE;

--
-- 表的索引 `admin_tiktok_invoice`
--
ALTER TABLE `admin_tiktok_invoice`
  ADD PRIMARY KEY (`id`),
  ADD KEY `o` (`shop_id`,`order_id`,`package_id`);

--
-- 表的索引 `admin_tiktok_product`
--
ALTER TABLE `admin_tiktok_product`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `good_id` (`shop_id`,`good_id`,`tiktok_shop_id`,`tiktok_good_id`,`tiktok_good_type`) USING BTREE;

--
-- 表的索引 `admin_tiktok_uploads`
--
ALTER TABLE `admin_tiktok_uploads`
  ADD PRIMARY KEY (`id`),
  ADD KEY `shop_id` (`shop_id`);

--
-- 表的索引 `admin_trans`
--
ALTER TABLE `admin_trans`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `nameLang` (`name`,`lang`) USING BTREE;

--
-- 表的索引 `admin_video_dubbing`
--
ALTER TABLE `admin_video_dubbing`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `admin_video_dubbing_shop_id_digest_uindex` (`shop_id`,`digest`),
  ADD KEY `admin_video_dubbing_status_index` (`status`);

--
-- 表的索引 `admin_wms_config`
--
ALTER TABLE `admin_wms_config`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `wms` (`shop_id`,`wms_type`) USING BTREE;

--
-- 表的索引 `admin_work_order`
--
ALTER TABLE `admin_work_order`
  ADD PRIMARY KEY (`id`),
  ADD KEY `admin_work_order_ewc_index` (`executee_shop_id`,`work_order_type`,`complaint_ref_id`),
  ADD KEY `admin_work_order_executor_shop_id_work_order_type_index` (`executor_shop_id`,`work_order_type`);

--
-- 表的索引 `admin_work_order_execution_result`
--
ALTER TABLE `admin_work_order_execution_result`
  ADD PRIMARY KEY (`id`),
  ADD KEY `admin_work_order_execution_results_work_order_id_index` (`work_order_id`);

--
-- 表的索引 `admin_yahoo_product`
--
ALTER TABLE `admin_yahoo_product`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `admin_yahoo_product_shop_id_item_code_uindex` (`shop_id`,`item_code`);

--
-- 表的索引 `mall_address`
--
ALTER TABLE `mall_address`
  ADD PRIMARY KEY (`address_id`),
  ADD KEY `member_id_2` (`member_id`,`sort`);

--
-- 表的索引 `mall_aftersale_items`
--
ALTER TABLE `mall_aftersale_items`
  ADD KEY `mall_aftersale_items_after_sale_id_IDX` (`after_sale_id`) USING BTREE,
  ADD KEY `after_sale_id` (`after_sale_id`);

--
-- 表的索引 `mall_after_sales`
--
ALTER TABLE `mall_after_sales`
  ADD PRIMARY KEY (`after_sale_id`,`order_id`) USING BTREE;

--
-- 表的索引 `mall_articles`
--
ALTER TABLE `mall_articles`
  ADD PRIMARY KEY (`article_id`),
  ADD KEY `shop_id` (`shop_id`),
  ADD KEY `type` (`type`),
  ADD KEY `title` (`title`),
  ADD KEY `status` (`status`),
  ADD KEY `sort` (`sort`),
  ADD KEY `ai` (`ai`),
  ADD KEY `stimated` (`status`,`estimated_time`);

--
-- 表的索引 `mall_articles_cats`
--
ALTER TABLE `mall_articles_cats`
  ADD PRIMARY KEY (`cat_id`);

--
-- 表的索引 `mall_articles_cats_sub`
--
ALTER TABLE `mall_articles_cats_sub`
  ADD PRIMARY KEY (`cat_id`,`view_id`) USING BTREE,
  ADD KEY `cat_id` (`cat_id`,`shop_id`,`view_id`,`ai`);

--
-- 表的索引 `mall_articles_sub`
--
ALTER TABLE `mall_articles_sub`
  ADD UNIQUE KEY `article_id` (`article_id`,`view_id`) USING BTREE,
  ADD KEY `article_id_2` (`article_id`,`shop_id`,`view_id`,`ai`);

--
-- 表的索引 `mall_association_tag`
--
ALTER TABLE `mall_association_tag`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `article` (`article_id`,`tag_id`,`shop_id`,`good_id`) USING BTREE,
  ADD KEY `tag_id` (`tag_id`);

--
-- 表的索引 `mall_association_tag_detail`
--
ALTER TABLE `mall_association_tag_detail`
  ADD PRIMARY KEY (`tag_id`),
  ADD UNIQUE KEY `tag` (`tag_name`,`shop_id`) USING BTREE,
  ADD KEY `shop_id` (`shop_id`);

--
-- 表的索引 `mall_benefit_code`
--
ALTER TABLE `mall_benefit_code`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `code` (`promotion_code`),
  ADD UNIQUE KEY `shopid,code,type` (`shop_id`,`promotion_code`,`benefit_type`) USING BTREE,
  ADD KEY `discount` (`shop_id`,`benefit_type`,`effect_scope_type`,`id`,`activity_status`) USING BTREE;

--
-- 表的索引 `mall_benefit_code_order_items_logs`
--
ALTER TABLE `mall_benefit_code_order_items_logs`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `order_id` (`order_id`);

--
-- 表的索引 `mall_benefit_code_order_logs`
--
ALTER TABLE `mall_benefit_code_order_logs`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD UNIQUE KEY `mall_order_UN` (`order_id`,`member_id`,`promo_code`) USING BTREE,
  ADD KEY `index_0` (`create_time`);

--
-- 表的索引 `mall_benefit_condition`
--
ALTER TABLE `mall_benefit_condition`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `mall_benefit_effect_scope_goods_list`
--
ALTER TABLE `mall_benefit_effect_scope_goods_list`
  ADD PRIMARY KEY (`id`),
  ADD KEY `codeId,effectScopeType` (`code_id`,`effect_scope_type`);

--
-- 表的索引 `mall_benefit_env_custom_info`
--
ALTER TABLE `mall_benefit_env_custom_info`
  ADD PRIMARY KEY (`id`),
  ADD KEY `codeId` (`code_id`);

--
-- 表的索引 `mall_benefit_scope_goods_list`
--
ALTER TABLE `mall_benefit_scope_goods_list`
  ADD PRIMARY KEY (`id`),
  ADD KEY `codeid,scoptype` (`code_id`,`benefit_scope_type`) USING BTREE;

--
-- 表的索引 `mall_benefit_target_user_info_list`
--
ALTER TABLE `mall_benefit_target_user_info_list`
  ADD PRIMARY KEY (`id`),
  ADD KEY `codeId,userType` (`code_id`,`target_user_type`) USING BTREE;

--
-- 表的索引 `mall_billing_address`
--
ALTER TABLE `mall_billing_address`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mall_billing_address_order_id_IDX` (`order_id`) USING BTREE;

--
-- 表的索引 `mall_bulk_send_part`
--
ALTER TABLE `mall_bulk_send_part`
  ADD PRIMARY KEY (`id`),
  ADD KEY `bulk_id` (`bulk_id`);

--
-- 表的索引 `mall_bulk_send_records`
--
ALTER TABLE `mall_bulk_send_records`
  ADD PRIMARY KEY (`id`),
  ADD KEY `bulk_id` (`bulk_id`,`shop_id`);
ALTER TABLE `mall_bulk_send_records` ADD FULLTEXT KEY `subject` (`subject`);

--
-- 表的索引 `mall_carry_mode`
--
ALTER TABLE `mall_carry_mode`
  ADD PRIMARY KEY (`carry_id`);

--
-- 表的索引 `mall_carry_mode_item`
--
ALTER TABLE `mall_carry_mode_item`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `mall_carry_sub_mode`
--
ALTER TABLE `mall_carry_sub_mode`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `mall_cart`
--
ALTER TABLE `mall_cart`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD UNIQUE KEY `mall_shopping_cart_UN` (`member_id`,`shop_id`,`sku_id`) USING BTREE;

--
-- 表的索引 `mall_cats`
--
ALTER TABLE `mall_cats`
  ADD PRIMARY KEY (`cat_id`),
  ADD UNIQUE KEY `shop_id` (`shop_id`,`name`);

--
-- 表的索引 `mall_cats_sub`
--
ALTER TABLE `mall_cats_sub`
  ADD PRIMARY KEY (`cat_id`,`view_id`) USING BTREE,
  ADD KEY `cat_id` (`cat_id`,`shop_id`,`view_id`,`ai`);

--
-- 表的索引 `mall_configs`
--
ALTER TABLE `mall_configs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `shop_id` (`shop_id`,`name`,`lang`);

--
-- 表的索引 `mall_country`
--
ALTER TABLE `mall_country`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `mall_delivery_method`
--
ALTER TABLE `mall_delivery_method`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `mall_email_log`
--
ALTER TABLE `mall_email_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `create_time` (`create_time`);

--
-- 表的索引 `mall_email_reply_log`
--
ALTER TABLE `mall_email_reply_log`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `mall_fare_template`
--
ALTER TABLE `mall_fare_template`
  ADD PRIMARY KEY (`fare_id`);

--
-- 表的索引 `mall_favs`
--
ALTER TABLE `mall_favs`
  ADD PRIMARY KEY (`fav_id`),
  ADD UNIQUE KEY `good_id` (`member_id`,`good_id`,`sku_id`) USING BTREE;

--
-- 表的索引 `mall_fx_clearing`
--
ALTER TABLE `mall_fx_clearing`
  ADD PRIMARY KEY (`clearing_id`);

--
-- 表的索引 `mall_fx_clearing_detail`
--
ALTER TABLE `mall_fx_clearing_detail`
  ADD PRIMARY KEY (`clearing_detail_id`);

--
-- 表的索引 `mall_fx_detail`
--
ALTER TABLE `mall_fx_detail`
  ADD PRIMARY KEY (`detail_id`);

--
-- 表的索引 `mall_fx_distributor`
--
ALTER TABLE `mall_fx_distributor`
  ADD PRIMARY KEY (`distributor_id`);

--
-- 表的索引 `mall_fx_distributor_relation`
--
ALTER TABLE `mall_fx_distributor_relation`
  ADD PRIMARY KEY (`relation_id`);

--
-- 表的索引 `mall_fx_grade`
--
ALTER TABLE `mall_fx_grade`
  ADD PRIMARY KEY (`grade_id`);

--
-- 表的索引 `mall_goods`
--
ALTER TABLE `mall_goods`
  ADD PRIMARY KEY (`good_id`) USING BTREE,
  ADD KEY `from_platform` (`from_platform`,`from_good_id`),
  ADD KEY `shop_id` (`shop_id`),
  ADD KEY `shop_id_2` (`shop_id`,`good_id`),
  ADD KEY `estimated_on_shelves` (`on_shelves`,`estimated_time`),
  ADD KEY `index_0` (`shop_id`,`on_shelves`,`isgift`),
  ADD KEY `index_1` (`cat_id`,`shop_id`,`on_shelves`,`isgift`);

--
-- 表的索引 `mall_goods_relate`
--
ALTER TABLE `mall_goods_relate`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `goodId` (`good_id`) USING BTREE,
  ADD KEY `shop_id` (`shop_id`),
  ADD KEY `hash_id` (`hash_id`);

--
-- 表的索引 `mall_goods_specs`
--
ALTER TABLE `mall_goods_specs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mall_goods_specs_pk` (`shop_id`,`out_id`);

--
-- 表的索引 `mall_goods_sub`
--
ALTER TABLE `mall_goods_sub`
  ADD UNIQUE KEY `good_id` (`good_id`,`view_id`) USING BTREE,
  ADD KEY `good_id_2` (`good_id`,`shop_id`,`view_id`,`ai`),
  ADD KEY `good_id_3` (`good_id`,`shop_id`,`ai`,`language`) USING BTREE;

--
-- 表的索引 `mall_goods_trans`
--
ALTER TABLE `mall_goods_trans`
  ADD PRIMARY KEY (`trans_id`) USING BTREE;

--
-- 表的索引 `mall_goods_wholesale`
--
ALTER TABLE `mall_goods_wholesale`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `mall_goods_wholesale_activities`
--
ALTER TABLE `mall_goods_wholesale_activities`
  ADD PRIMARY KEY (`activity_id`);

--
-- 表的索引 `mall_good_infos`
--
ALTER TABLE `mall_good_infos`
  ADD PRIMARY KEY (`info_id`) USING BTREE;

--
-- 表的索引 `mall_grade_conditions`
--
ALTER TABLE `mall_grade_conditions`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD UNIQUE KEY `grade_id` (`grade_id`) USING BTREE;

--
-- 表的索引 `mall_jifens`
--
ALTER TABLE `mall_jifens`
  ADD UNIQUE KEY `unique` (`member_id`,`shop_id`) USING BTREE;

--
-- 表的索引 `mall_jifen_logs`
--
ALTER TABLE `mall_jifen_logs`
  ADD PRIMARY KEY (`jifen_log_id`),
  ADD UNIQUE KEY `unique` (`member_id`,`jifen_trade_no`) USING BTREE;

--
-- 表的索引 `mall_labels`
--
ALTER TABLE `mall_labels`
  ADD PRIMARY KEY (`label_id`);

--
-- 表的索引 `mall_labels_item`
--
ALTER TABLE `mall_labels_item`
  ADD PRIMARY KEY (`label_item_id`),
  ADD UNIQUE KEY `label_id` (`label_id`,`good_id`);

--
-- 表的索引 `mall_labels_sub`
--
ALTER TABLE `mall_labels_sub`
  ADD PRIMARY KEY (`label_id`);

--
-- 表的索引 `mall_member_benefit_code`
--
ALTER TABLE `mall_member_benefit_code`
  ADD PRIMARY KEY (`id`),
  ADD KEY `member_id` (`member_id`),
  ADD KEY `member_id,shop_id` (`member_id`,`shop_id`),
  ADD KEY `search` (`member_id`,`shop_id`,`benefit_code_id`,`promotion_code`);

--
-- 表的索引 `mall_member_grades`
--
ALTER TABLE `mall_member_grades`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- 表的索引 `mall_member_grade_relations`
--
ALTER TABLE `mall_member_grade_relations`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `mall_member_groups`
--
ALTER TABLE `mall_member_groups`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- 表的索引 `mall_member_group_relations`
--
ALTER TABLE `mall_member_group_relations`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- 表的索引 `mall_member_remarks`
--
ALTER TABLE `mall_member_remarks`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- 表的索引 `mall_member_tags`
--
ALTER TABLE `mall_member_tags`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- 表的索引 `mall_member_tag_associations`
--
ALTER TABLE `mall_member_tag_associations`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- 表的索引 `mall_messages`
--
ALTER TABLE `mall_messages`
  ADD PRIMARY KEY (`msg_id`);

--
-- 表的索引 `mall_message_recipients`
--
ALTER TABLE `mall_message_recipients`
  ADD PRIMARY KEY (`rec_id`);

--
-- 表的索引 `mall_notification_records`
--
ALTER TABLE `mall_notification_records`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `mall_notification_switch`
--
ALTER TABLE `mall_notification_switch`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mall_notification_switch_shop_id_sort_uindex` (`shop_id`,`sort`);

--
-- 表的索引 `mall_notification_template`
--
ALTER TABLE `mall_notification_template`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mall_notification_template_pk` (`shop_id`,`sort`,`sender_type`);

--
-- 表的索引 `mall_oauth_google`
--
ALTER TABLE `mall_oauth_google`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mall_oauth_google_UN` (`member_id`,`third_userid`);

--
-- 表的索引 `mall_oauth_microsoft`
--
ALTER TABLE `mall_oauth_microsoft`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mall_oauth_microsoft_UN` (`member_id`,`third_userid`);

--
-- 表的索引 `mall_oauth_wechat`
--
ALTER TABLE `mall_oauth_wechat`
  ADD PRIMARY KEY (`id`),
  ADD KEY `openid` (`openid`);

--
-- 表的索引 `mall_order`
--
ALTER TABLE `mall_order`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD UNIQUE KEY `mall_order_UN` (`order_id`,`member_id`,`status`) USING BTREE,
  ADD KEY `index_0` (`status`,`create_time`),
  ADD KEY `user_id` (`user_id`) USING BTREE,
  ADD KEY `sidUid` (`user_id`,`shop_id`),
  ADD KEY `sidFid` (`from_id`,`shop_id`);

--
-- 表的索引 `mall_order_actual_tongji`
--
ALTER TABLE `mall_order_actual_tongji`
  ADD PRIMARY KEY (`id`),
  ADD KEY `shop_id` (`shop_id`,`tongji_date`,`order_type`,`pay_way_id`);

--
-- 表的索引 `mall_order_handlepay`
--
ALTER TABLE `mall_order_handlepay`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_id` (`order_id`),
  ADD KEY `shop_id` (`shop_id`);

--
-- 表的索引 `mall_order_insured`
--
ALTER TABLE `mall_order_insured`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_id` (`order_id`) USING BTREE;

--
-- 表的索引 `mall_order_items`
--
ALTER TABLE `mall_order_items`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD UNIQUE KEY `uni` (`order_id`,`shop_id`,`good_id`,`sku_id`) USING BTREE,
  ADD KEY `order_id` (`order_id`),
  ADD KEY `shop_id` (`shop_id`),
  ADD KEY `good_id` (`good_id`),
  ADD KEY `shop_id_2` (`shop_id`,`good_id`);

--
-- 表的索引 `mall_order_tongji`
--
ALTER TABLE `mall_order_tongji`
  ADD PRIMARY KEY (`id`),
  ADD KEY `shop_id` (`shop_id`,`tongji_date`,`order_type`,`pay_way_id`);

--
-- 表的索引 `mall_order_wander_template`
--
ALTER TABLE `mall_order_wander_template`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique` (`shop_id`,`template_type`,`order_status`) USING BTREE,
  ADD KEY `shop_id` (`shop_id`),
  ADD KEY `shop_id、type、order_status` (`shop_id`,`template_type`,`order_status`) USING BTREE;

--
-- 表的索引 `mall_order_waybill_express`
--
ALTER TABLE `mall_order_waybill_express`
  ADD PRIMARY KEY (`id`),
  ADD KEY `orderId` (`order_id`),
  ADD KEY `orderId,shipCode` (`order_id`,`shipping_code`) USING BTREE;

--
-- 表的索引 `mall_order_waybill_express_details`
--
ALTER TABLE `mall_order_waybill_express_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `reference_id` (`reference_id`);

--
-- 表的索引 `mall_paying_flow`
--
ALTER TABLE `mall_paying_flow`
  ADD PRIMARY KEY (`id`),
  ADD KEY `paying_id` (`paying_id`),
  ADD KEY `order_id` (`order_id`,`status`);

--
-- 表的索引 `mall_payment_method`
--
ALTER TABLE `mall_payment_method`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- 表的索引 `mall_prepay`
--
ALTER TABLE `mall_prepay`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD UNIQUE KEY `prepay_id` (`prepay_id`),
  ADD KEY `index_0` (`status`,`create_time`),
  ADD KEY `midUid` (`member_id`,`user_id`),
  ADD KEY `midFid` (`member_id`,`from_id`);

--
-- 表的索引 `mall_prepay_details`
--
ALTER TABLE `mall_prepay_details`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD UNIQUE KEY `prepay_id` (`prepay_id`,`detail_id`),
  ADD KEY `detail_id` (`detail_id`);

--
-- 表的索引 `mall_printers`
--
ALTER TABLE `mall_printers`
  ADD PRIMARY KEY (`printer_id`),
  ADD KEY `shop_id` (`shop_id`);

--
-- 表的索引 `mall_printer_template`
--
ALTER TABLE `mall_printer_template`
  ADD PRIMARY KEY (`template_id`),
  ADD KEY `type` (`shop_id`,`type`,`status`);

--
-- 表的索引 `mall_printer_template_relation`
--
ALTER TABLE `mall_printer_template_relation`
  ADD PRIMARY KEY (`relation_id`),
  ADD KEY `shop_id` (`shop_id`);

--
-- 表的索引 `mall_purchase`
--
ALTER TABLE `mall_purchase`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `purchaseId` (`purchase_id`) USING BTREE;

--
-- 表的索引 `mall_purchase_import`
--
ALTER TABLE `mall_purchase_import`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `s` (`shop_id`,`sub_shop_id`,`purchase_id`,`import_order_id`);

--
-- 表的索引 `mall_purchase_items`
--
ALTER TABLE `mall_purchase_items`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `mall_purchase_orders`
--
ALTER TABLE `mall_purchase_orders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mall_purchase_orders_purchase_id_IDX` (`purchase_id`) USING BTREE,
  ADD KEY `mall_purchase_orders_order_id_IDX` (`order_id`) USING BTREE;

--
-- 表的索引 `mall_purchase_prepay`
--
ALTER TABLE `mall_purchase_prepay`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mall_purchase_prepay_UN` (`prepay_id`),
  ADD KEY `status` (`status`);

--
-- 表的索引 `mall_purchase_prepay_details`
--
ALTER TABLE `mall_purchase_prepay_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mall_purchase_prepay_details_prepay_id_IDX` (`prepay_id`) USING BTREE;

--
-- 表的索引 `mall_push_order_logs`
--
ALTER TABLE `mall_push_order_logs`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `mall_review`
--
ALTER TABLE `mall_review`
  ADD PRIMARY KEY (`review_id`),
  ADD KEY `order_id` (`order_id`,`sku_id`) USING BTREE;

--
-- 表的索引 `mall_sales_order_status`
--
ALTER TABLE `mall_sales_order_status`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oid` (`order_id`);

--
-- 表的索引 `mall_scats`
--
ALTER TABLE `mall_scats`
  ADD PRIMARY KEY (`cid`) USING BTREE,
  ADD KEY `cid` (`cid`);

--
-- 表的索引 `mall_search_meta_delivery_country`
--
ALTER TABLE `mall_search_meta_delivery_country`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mall_search_meta_delivery_country_goods_id_index` (`goods_id`),
  ADD KEY `mall_search_meta_delivery_country_shop_id_delivery_country_index` (`shop_id`,`delivery_country`);

--
-- 表的索引 `mall_search_meta_out_id`
--
ALTER TABLE `mall_search_meta_out_id`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mall_search_meta_out_id_goods_id_index` (`goods_id`),
  ADD KEY `mall_search_meta_out_id_shop_id_out_id_index` (`shop_id`,`out_id`);

--
-- 表的索引 `mall_seo_baidu`
--
ALTER TABLE `mall_seo_baidu`
  ADD PRIMARY KEY (`id`),
  ADD KEY `shopId` (`shop_id`) USING BTREE,
  ADD KEY `shopId,createTime` (`shop_id`,`create_time`);

--
-- 表的索引 `mall_seo_bing`
--
ALTER TABLE `mall_seo_bing`
  ADD PRIMARY KEY (`id`),
  ADD KEY `shopId` (`shop_id`) USING BTREE,
  ADD KEY `shopId,createTime` (`shop_id`,`create_time`);

--
-- 表的索引 `mall_seo_google`
--
ALTER TABLE `mall_seo_google`
  ADD PRIMARY KEY (`id`),
  ADD KEY `shopId` (`shop_id`) USING BTREE,
  ADD KEY `shopId,auditStatus` (`shop_id`,`audit_status`),
  ADD KEY `shopId,seoStatus` (`shop_id`,`seo_status`),
  ADD KEY `shopId,createTime` (`shop_id`,`create_time`);

--
-- 表的索引 `mall_service`
--
ALTER TABLE `mall_service`
  ADD PRIMARY KEY (`service_id`),
  ADD KEY `service_name` (`service_name`),
  ADD KEY `status` (`status`),
  ADD KEY `service_id` (`service_id`),
  ADD KEY `service_id_2` (`service_id`,`status`);

--
-- 表的索引 `mall_service_cat`
--
ALTER TABLE `mall_service_cat`
  ADD KEY `cat_id` (`cat_id`),
  ADD KEY `service_id` (`service_id`);

--
-- 表的索引 `mall_service_goods`
--
ALTER TABLE `mall_service_goods`
  ADD KEY `good_id` (`good_id`),
  ADD KEY `service_id` (`service_id`);

--
-- 表的索引 `mall_service_order`
--
ALTER TABLE `mall_service_order`
  ADD PRIMARY KEY (`service_order_id`),
  ADD KEY `service_id` (`service_id`,`order_id`,`sku_id`);

--
-- 表的索引 `mall_service_scat`
--
ALTER TABLE `mall_service_scat`
  ADD KEY `scat_id` (`scat_id`),
  ADD KEY `service_id` (`service_id`);

--
-- 表的索引 `mall_ships`
--
ALTER TABLE `mall_ships`
  ADD PRIMARY KEY (`ship_id`),
  ADD KEY `shop_id` (`shop_id`);

--
-- 表的索引 `mall_shops_express_config`
--
ALTER TABLE `mall_shops_express_config`
  ADD PRIMARY KEY (`id`),
  ADD KEY `shopId` (`shop_id`) USING BTREE;

--
-- 表的索引 `mall_shop_configs`
--
ALTER TABLE `mall_shop_configs`
  ADD PRIMARY KEY (`shop_config_id`,`shop_id`),
  ADD UNIQUE KEY `shop_id` (`shop_id`,`name`);

--
-- 表的索引 `mall_shop_domain`
--
ALTER TABLE `mall_shop_domain`
  ADD PRIMARY KEY (`domain_id`),
  ADD UNIQUE KEY `domain` (`domain`),
  ADD KEY `is_main` (`is_main`),
  ADD KEY `shop_id` (`shop_id`,`domain`),
  ADD KEY `shop_id_2` (`shop_id`);

--
-- 表的索引 `mall_shop_funds`
--
ALTER TABLE `mall_shop_funds`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mall_shop_funds_sub_shop_id_IDX` (`sub_shop_id`) USING BTREE;

--
-- 表的索引 `mall_shop_funds_change_log`
--
ALTER TABLE `mall_shop_funds_change_log`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `mall_shop_recharge_log`
--
ALTER TABLE `mall_shop_recharge_log`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `mall_shop_view`
--
ALTER TABLE `mall_shop_view`
  ADD PRIMARY KEY (`view_id`) USING BTREE,
  ADD UNIQUE KEY `shop_id_2` (`shop_id`,`language`),
  ADD KEY `shop_id` (`shop_id`,`language`,`auto_trans`);

--
-- 表的索引 `mall_skus`
--
ALTER TABLE `mall_skus`
  ADD PRIMARY KEY (`sku_id`),
  ADD UNIQUE KEY `shop_id` (`shop_id`,`good_id`,`props_ids`),
  ADD KEY `index_0` (`good_id`);

--
-- 表的索引 `mall_skus_map`
--
ALTER TABLE `mall_skus_map`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uniq` (`from_platform`,`shop_id`,`out_id`,`from_platform_out_id`) USING BTREE;

--
-- 表的索引 `mall_skus_sub`
--
ALTER TABLE `mall_skus_sub`
  ADD UNIQUE KEY `shop_id` (`shop_id`,`good_id`,`view_id`,`sku_id`) USING BTREE,
  ADD KEY `index_0` (`view_id`,`good_id`);

--
-- 表的索引 `mall_sku_props`
--
ALTER TABLE `mall_sku_props`
  ADD PRIMARY KEY (`prop_id`),
  ADD UNIQUE KEY `prop_name` (`prop_name`,`good_id`),
  ADD KEY `shop_id` (`shop_id`),
  ADD KEY `good_id` (`good_id`);

--
-- 表的索引 `mall_sku_props_sub`
--
ALTER TABLE `mall_sku_props_sub`
  ADD UNIQUE KEY `prop_name` (`prop_id`,`view_id`) USING BTREE,
  ADD KEY `index_0` (`view_id`,`good_id`),
  ADD KEY `prop_id` (`prop_id`,`view_id`,`ai`),
  ADD KEY `good_id` (`good_id`,`language`);

--
-- 表的索引 `mall_sku_tax`
--
ALTER TABLE `mall_sku_tax`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `sku_id` (`sku_id`,`country_code`,`state_code`);

--
-- 表的索引 `mall_sku_values`
--
ALTER TABLE `mall_sku_values`
  ADD PRIMARY KEY (`value_id`),
  ADD UNIQUE KEY `prop_id` (`prop_id`,`prop_value`,`good_id`),
  ADD KEY `shop_id` (`shop_id`);

--
-- 表的索引 `mall_sku_values_sub`
--
ALTER TABLE `mall_sku_values_sub`
  ADD UNIQUE KEY `prop_id` (`prop_id`,`view_id`,`good_id`,`value_id`) USING BTREE,
  ADD KEY `index_0` (`view_id`,`good_id`),
  ADD KEY `value_id` (`value_id`,`prop_id`,`ai`),
  ADD KEY `index_1` (`good_id`,`language`);

--
-- 表的索引 `mall_sku_warehouse_relation`
--
ALTER TABLE `mall_sku_warehouse_relation`
  ADD PRIMARY KEY (`relation_id`);

--
-- 表的索引 `mall_stockchange_log`
--
ALTER TABLE `mall_stockchange_log`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `stock_change_log_UN` (`order_id`,`sku_id`,`warehouse_id`),
  ADD KEY `shop_status` (`shop_id`,`out_id`,`status`) USING BTREE;

--
-- 表的索引 `mall_stocks_locked`
--
ALTER TABLE `mall_stocks_locked`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_id` (`id`),
  ADD KEY `idx_out_id` (`out_id`),
  ADD KEY `idx_out_id_country_shop_id` (`out_id`,`country`,`shop_id`),
  ADD KEY `idx_out_id_shop_id` (`out_id`,`shop_id`),
  ADD KEY `idx_out_country` (`out_id`,`country`),
  ADD KEY `idx_shop_out_country` (`shop_id`,`out_id`,`country`);

--
-- 表的索引 `mall_stocks_locked_logs`
--
ALTER TABLE `mall_stocks_locked_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_out_id` (`out_id`),
  ADD KEY `idx_shop_id` (`shop_id`),
  ADD KEY `idx_order_id` (`order_id`),
  ADD KEY `idx_ctime` (`ctime`),
  ADD KEY `idx_shop_id_order_id` (`shop_id`,`order_id`),
  ADD KEY `idx_shop_id_order_id_type` (`shop_id`,`order_id`,`type`),
  ADD KEY `idx_order_type` (`order_id`,`type`);

--
-- 表的索引 `mall_stocks_logs`
--
ALTER TABLE `mall_stocks_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_out_id` (`out_id`),
  ADD KEY `idx_shop_id` (`shop_id`),
  ADD KEY `idx_warehouse_id` (`warehouse_id`),
  ADD KEY `idx_order_id` (`order_id`),
  ADD KEY `idx_type` (`type`),
  ADD KEY `idx_shop_out_warehouse` (`shop_id`,`out_id`,`warehouse_id`);

--
-- 表的索引 `mall_stocks_pre`
--
ALTER TABLE `mall_stocks_pre`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uk_order_sku` (`order_id`,`out_id`),
  ADD KEY `idx_order_id` (`order_id`),
  ADD KEY `idx_out_id_country` (`out_id`,`country`),
  ADD KEY `idx_out_country_status` (`out_id`,`country`,`status`),
  ADD KEY `idx_order_status` (`order_id`,`status`),
  ADD KEY `idx_out_shop_country_status` (`out_id`,`shop_id`,`country`,`status`),
  ADD KEY `idx_expire_status` (`expire_at`,`status`);

--
-- 表的索引 `mall_subscribes`
--
ALTER TABLE `mall_subscribes`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `member_id` (`member_id`,`shop_id`,`email`) USING BTREE;

--
-- 表的索引 `mall_trans`
--
ALTER TABLE `mall_trans`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `nameLang` (`name`,`lang`) USING BTREE;

--
-- 表的索引 `mall_trans_task`
--
ALTER TABLE `mall_trans_task`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD UNIQUE KEY `uindex` (`shop_id`,`md5`,`lang`,`xid`,`type_name`,`type_id`) USING BTREE,
  ADD KEY `shop_id` (`shop_id`,`md5`) USING BTREE COMMENT '查询使用组合索引',
  ADD KEY `status` (`status`,`shop_id`),
  ADD KEY `good_id` (`xid`,`lang`,`status`),
  ADD KEY `shop_id_2` (`shop_id`,`md5`,`lang`,`status`);

--
-- 表的索引 `mall_trans_task_logs`
--
ALTER TABLE `mall_trans_task_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `shop_id` (`shop_id`),
  ADD KEY `update_time` (`update_time`),
  ADD KEY `trans_task_uniqe_id` (`trans_task_uniqe_id`) USING BTREE;

--
-- 表的索引 `mall_trans_task_unique`
--
ALTER TABLE `mall_trans_task_unique`
  ADD PRIMARY KEY (`trans_task_uniqe_id`) USING BTREE,
  ADD UNIQUE KEY `md5` (`shop_id`,`md5`) USING BTREE,
  ADD KEY `status` (`status`) USING BTREE,
  ADD KEY `status_2` (`shop_id`,`status`) USING BTREE;

--
-- 表的索引 `mall_trans_words`
--
ALTER TABLE `mall_trans_words`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `shop_id` (`shop_id`,`words_md5`);

--
-- 表的索引 `mall_uploads`
--
ALTER TABLE `mall_uploads`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `shop_id` (`shop_id`),
  ADD KEY `good_id` (`good_id`,`shop_id`),
  ADD KEY `mall_uploads_id_shop_id_name_index` (`shop_id`,`name`);

--
-- 表的索引 `mall_uploads_attachments`
--
ALTER TABLE `mall_uploads_attachments`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `uniq` (`shop_id`,`member_id`);

--
-- 表的索引 `mall_warehouse`
--
ALTER TABLE `mall_warehouse`
  ADD PRIMARY KEY (`warehouse_id`),
  ADD KEY `shop_id` (`shop_id`);

--
-- 表的索引 `mall_warehouse_priority_shipping`
--
ALTER TABLE `mall_warehouse_priority_shipping`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mall_warehouse_priority_shipping_pk` (`shop_id`,`warehouse_id`),
  ADD KEY `mall_warehouse_priority_shipping_shop_id_weight_index` (`shop_id`,`weight`),
  ADD KEY `warehouse_id` (`warehouse_id`) USING BTREE;

--
-- 表的索引 `mall_warehouse_region_delivery`
--
ALTER TABLE `mall_warehouse_region_delivery`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mall_warehouse_region_delivery_pk` (`shop_id`,`country_code`,`warehouse_id`),
  ADD KEY `mall_warehouse_region_delivery_shop_id_country_code_status_index` (`shop_id`,`country_code`,`status`);

--
-- 表的索引 `mall_warehouse_stock`
--
ALTER TABLE `mall_warehouse_stock`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idx_unique` (`shop_id`,`warehouse_id`,`out_id`);

--
-- 表的索引 `mall_webhook_logs`
--
ALTER TABLE `mall_webhook_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mall_webhook_logs_push_times_IDX` (`push_times`,`success_time`) USING BTREE,
  ADD KEY `shop_id` (`shop_id`),
  ADD KEY `shop_id_2` (`shop_id`,`status`);

--
-- 表的索引 `sys_dict_data`
--
ALTER TABLE `sys_dict_data`
  ADD PRIMARY KEY (`id`),
  ADD KEY `dict_data_idx` (`type`);

--
-- 表的索引 `sys_dict_type`
--
ALTER TABLE `sys_dict_type`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD UNIQUE KEY `dict_type` (`type`);

--
-- 表的索引 `sys_log`
--
ALTER TABLE `sys_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `error_code` (`error_code`),
  ADD KEY `req_id` (`req_id`),
  ADD KEY `status` (`status`);

--
-- 表的索引 `sys_provinces`
--
ALTER TABLE `sys_provinces`
  ADD PRIMARY KEY (`id`),
  ADD KEY `parentid` (`pid`);

--
-- 表的索引 `sys_resources`
--
ALTER TABLE `sys_resources`
  ADD PRIMARY KEY (`resource_id`),
  ADD UNIQUE KEY `path` (`path`);

--
-- 表的索引 `sys_resource_groups`
--
ALTER TABLE `sys_resource_groups`
  ADD PRIMARY KEY (`res_group_id`),
  ADD UNIQUE KEY `title` (`title`,`cat`);

--
-- 表的索引 `sys_resource_group_apis`
--
ALTER TABLE `sys_resource_group_apis`
  ADD UNIQUE KEY `res_group_id` (`res_group_id`,`resource_id`);

--
-- 表的索引 `sys_role_group_paichu_apis`
--
ALTER TABLE `sys_role_group_paichu_apis`
  ADD UNIQUE KEY `role_id` (`role_id`,`res_group_id`,`resource_id`);

--
-- 表的索引 `sys_version`
--
ALTER TABLE `sys_version`
  ADD PRIMARY KEY (`id`);

--
-- 在导出的表使用AUTO_INCREMENT
--

--
-- 使用表AUTO_INCREMENT `admin_alibaba_category`
--
ALTER TABLE `admin_alibaba_category`
  MODIFY `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键', AUTO_INCREMENT=12527;

--
-- 使用表AUTO_INCREMENT `admin_alibaba_order`
--
ALTER TABLE `admin_alibaba_order`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '大健云仓订单信息';

--
-- 使用表AUTO_INCREMENT `admin_alibaba_order_items`
--
ALTER TABLE `admin_alibaba_order_items`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `admin_bank_info`
--
ALTER TABLE `admin_bank_info`
  MODIFY `bank_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号';

--
-- 使用表AUTO_INCREMENT `admin_beehole_order`
--
ALTER TABLE `admin_beehole_order`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键';

--
-- 使用表AUTO_INCREMENT `admin_beehole_order_items`
--
ALTER TABLE `admin_beehole_order_items`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `admin_bigcommerce_product`
--
ALTER TABLE `admin_bigcommerce_product`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '表主键';

--
-- 使用表AUTO_INCREMENT `admin_chat_topics`
--
ALTER TABLE `admin_chat_topics`
  MODIFY `topic_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主题编号';

--
-- 使用表AUTO_INCREMENT `admin_dept`
--
ALTER TABLE `admin_dept`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '部门id';

--
-- 使用表AUTO_INCREMENT `admin_division_rule`
--
ALTER TABLE `admin_division_rule`
  MODIFY `rule_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '规则编号';

--
-- 使用表AUTO_INCREMENT `admin_division_rule_log`
--
ALTER TABLE `admin_division_rule_log`
  MODIFY `log_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志编号';

--
-- 使用表AUTO_INCREMENT `admin_ebay_product`
--
ALTER TABLE `admin_ebay_product`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表主键';

--
-- 使用表AUTO_INCREMENT `admin_express_company`
--
ALTER TABLE `admin_express_company`
  MODIFY `express_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '快递公司编号', AUTO_INCREMENT=128;

--
-- 使用表AUTO_INCREMENT `admin_fuwu`
--
ALTER TABLE `admin_fuwu`
  MODIFY `fuwu_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '服务编号';

--
-- 使用表AUTO_INCREMENT `admin_fuwu_order`
--
ALTER TABLE `admin_fuwu_order`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `admin_fx_clearing`
--
ALTER TABLE `admin_fx_clearing`
  MODIFY `clearing_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '结算编号';

--
-- 使用表AUTO_INCREMENT `admin_fx_clearing_detail`
--
ALTER TABLE `admin_fx_clearing_detail`
  MODIFY `clearing_detail_id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `admin_fx_detail`
--
ALTER TABLE `admin_fx_detail`
  MODIFY `detail_id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `admin_fx_distributor`
--
ALTER TABLE `admin_fx_distributor`
  MODIFY `distributor_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '代理商编号';

--
-- 使用表AUTO_INCREMENT `admin_fx_distributor_relation`
--
ALTER TABLE `admin_fx_distributor_relation`
  MODIFY `relation_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '关系编号';

--
-- 使用表AUTO_INCREMENT `admin_fx_grade`
--
ALTER TABLE `admin_fx_grade`
  MODIFY `grade_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '等级编号', AUTO_INCREMENT=2;

--
-- 使用表AUTO_INCREMENT `admin_gigab2b_order`
--
ALTER TABLE `admin_gigab2b_order`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '大健云仓订单信息', AUTO_INCREMENT=2;

--
-- 使用表AUTO_INCREMENT `admin_gigab2b_order_items`
--
ALTER TABLE `admin_gigab2b_order_items`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- 使用表AUTO_INCREMENT `admin_giga_products`
--
ALTER TABLE `admin_giga_products`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键';

--
-- 使用表AUTO_INCREMENT `admin_gmc_product`
--
ALTER TABLE `admin_gmc_product`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '表主键';

--
-- 使用表AUTO_INCREMENT `admin_goods_public`
--
ALTER TABLE `admin_goods_public`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键', AUTO_INCREMENT=2;

--
-- 使用表AUTO_INCREMENT `admin_goods_supply`
--
ALTER TABLE `admin_goods_supply`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '供应ID 主键', AUTO_INCREMENT=19;

--
-- 使用表AUTO_INCREMENT `admin_goods_supply_stock_log`
--
ALTER TABLE `admin_goods_supply_stock_log`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `admin_good_cang_shipping_method`
--
ALTER TABLE `admin_good_cang_shipping_method`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', AUTO_INCREMENT=4957;

--
-- 使用表AUTO_INCREMENT `admin_good_cang_shipping_methods`
--
ALTER TABLE `admin_good_cang_shipping_methods`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键';

--
-- 使用表AUTO_INCREMENT `admin_good_cang_warehouse`
--
ALTER TABLE `admin_good_cang_warehouse`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键';

--
-- 使用表AUTO_INCREMENT `admin_jiufang_shipping_method`
--
ALTER TABLE `admin_jiufang_shipping_method`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增ID';

--
-- 使用表AUTO_INCREMENT `admin_jiufang_warehouse`
--
ALTER TABLE `admin_jiufang_warehouse`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增ID';

--
-- 使用表AUTO_INCREMENT `admin_member_grade`
--
ALTER TABLE `admin_member_grade`
  MODIFY `grade_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '等级编号';

--
-- 使用表AUTO_INCREMENT `admin_menu`
--
ALTER TABLE `admin_menu`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '菜单ID', AUTO_INCREMENT=2185;

--
-- 使用表AUTO_INCREMENT `admin_notice`
--
ALTER TABLE `admin_notice`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '公告ID';

--
-- 使用表AUTO_INCREMENT `admin_ozon_product`
--
ALTER TABLE `admin_ozon_product`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表主键';

--
-- 使用表AUTO_INCREMENT `admin_payment_entities`
--
ALTER TABLE `admin_payment_entities`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表主键';

--
-- 使用表AUTO_INCREMENT `admin_payment_updates`
--
ALTER TABLE `admin_payment_updates`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表主键';

--
-- 使用表AUTO_INCREMENT `admin_post`
--
ALTER TABLE `admin_post`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '岗位ID';

--
-- 使用表AUTO_INCREMENT `admin_rakuten_product`
--
ALTER TABLE `admin_rakuten_product`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键';

--
-- 使用表AUTO_INCREMENT `admin_read_notice`
--
ALTER TABLE `admin_read_notice`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `admin_rechare_application`
--
ALTER TABLE `admin_rechare_application`
  MODIFY `application_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '申请编号';

--
-- 使用表AUTO_INCREMENT `admin_supply_orders`
--
ALTER TABLE `admin_supply_orders`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- 使用表AUTO_INCREMENT `admin_supply_order_item_relationship`
--
ALTER TABLE `admin_supply_order_item_relationship`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- 使用表AUTO_INCREMENT `admin_tiktok_invoice`
--
ALTER TABLE `admin_tiktok_invoice`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键';

--
-- 使用表AUTO_INCREMENT `admin_tiktok_product`
--
ALTER TABLE `admin_tiktok_product`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键';

--
-- 使用表AUTO_INCREMENT `admin_tiktok_uploads`
--
ALTER TABLE `admin_tiktok_uploads`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键';

--
-- 使用表AUTO_INCREMENT `admin_trans`
--
ALTER TABLE `admin_trans`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID';

--
-- 使用表AUTO_INCREMENT `admin_video_dubbing`
--
ALTER TABLE `admin_video_dubbing`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表主键';

--
-- 使用表AUTO_INCREMENT `admin_wms_config`
--
ALTER TABLE `admin_wms_config`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键';

--
-- 使用表AUTO_INCREMENT `admin_work_order`
--
ALTER TABLE `admin_work_order`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表主键';

--
-- 使用表AUTO_INCREMENT `admin_work_order_execution_result`
--
ALTER TABLE `admin_work_order_execution_result`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '表主键';

--
-- 使用表AUTO_INCREMENT `admin_yahoo_product`
--
ALTER TABLE `admin_yahoo_product`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表主键';

--
-- 使用表AUTO_INCREMENT `mall_address`
--
ALTER TABLE `mall_address`
  MODIFY `address_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '地址编号';

--
-- 使用表AUTO_INCREMENT `mall_articles`
--
ALTER TABLE `mall_articles`
  MODIFY `article_id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `mall_articles_cats`
--
ALTER TABLE `mall_articles_cats`
  MODIFY `cat_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '分类编号';

--
-- 使用表AUTO_INCREMENT `mall_articles_sub`
--
ALTER TABLE `mall_articles_sub`
  MODIFY `article_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '文章编号';

--
-- 使用表AUTO_INCREMENT `mall_association_tag`
--
ALTER TABLE `mall_association_tag`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', AUTO_INCREMENT=3;

--
-- 使用表AUTO_INCREMENT `mall_association_tag_detail`
--
ALTER TABLE `mall_association_tag_detail`
  MODIFY `tag_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', AUTO_INCREMENT=4;

--
-- 使用表AUTO_INCREMENT `mall_benefit_code`
--
ALTER TABLE `mall_benefit_code`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '折扣码主键';

--
-- 使用表AUTO_INCREMENT `mall_benefit_code_order_items_logs`
--
ALTER TABLE `mall_benefit_code_order_items_logs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表主键';

--
-- 使用表AUTO_INCREMENT `mall_benefit_code_order_logs`
--
ALTER TABLE `mall_benefit_code_order_logs`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `mall_benefit_condition`
--
ALTER TABLE `mall_benefit_condition`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键';

--
-- 使用表AUTO_INCREMENT `mall_benefit_effect_scope_goods_list`
--
ALTER TABLE `mall_benefit_effect_scope_goods_list`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键';

--
-- 使用表AUTO_INCREMENT `mall_benefit_env_custom_info`
--
ALTER TABLE `mall_benefit_env_custom_info`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键';

--
-- 使用表AUTO_INCREMENT `mall_benefit_scope_goods_list`
--
ALTER TABLE `mall_benefit_scope_goods_list`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键';

--
-- 使用表AUTO_INCREMENT `mall_benefit_target_user_info_list`
--
ALTER TABLE `mall_benefit_target_user_info_list`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `mall_billing_address`
--
ALTER TABLE `mall_billing_address`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表主键';

--
-- 使用表AUTO_INCREMENT `mall_bulk_send_part`
--
ALTER TABLE `mall_bulk_send_part`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表主键';

--
-- 使用表AUTO_INCREMENT `mall_bulk_send_records`
--
ALTER TABLE `mall_bulk_send_records`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表主键';

--
-- 使用表AUTO_INCREMENT `mall_carry_mode`
--
ALTER TABLE `mall_carry_mode`
  MODIFY `carry_id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `mall_carry_mode_item`
--
ALTER TABLE `mall_carry_mode_item`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `mall_carry_sub_mode`
--
ALTER TABLE `mall_carry_sub_mode`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `mall_cats`
--
ALTER TABLE `mall_cats`
  MODIFY `cat_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '类目编号';

--
-- 使用表AUTO_INCREMENT `mall_configs`
--
ALTER TABLE `mall_configs`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键';

--
-- 使用表AUTO_INCREMENT `mall_country`
--
ALTER TABLE `mall_country`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1458;

--
-- 使用表AUTO_INCREMENT `mall_delivery_method`
--
ALTER TABLE `mall_delivery_method`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `mall_fare_template`
--
ALTER TABLE `mall_fare_template`
  MODIFY `fare_id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `mall_favs`
--
ALTER TABLE `mall_favs`
  MODIFY `fav_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `mall_fx_clearing`
--
ALTER TABLE `mall_fx_clearing`
  MODIFY `clearing_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '结算编号';

--
-- 使用表AUTO_INCREMENT `mall_fx_clearing_detail`
--
ALTER TABLE `mall_fx_clearing_detail`
  MODIFY `clearing_detail_id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `mall_fx_detail`
--
ALTER TABLE `mall_fx_detail`
  MODIFY `detail_id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `mall_fx_distributor`
--
ALTER TABLE `mall_fx_distributor`
  MODIFY `distributor_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '代理商编号';

--
-- 使用表AUTO_INCREMENT `mall_fx_distributor_relation`
--
ALTER TABLE `mall_fx_distributor_relation`
  MODIFY `relation_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '关系编号';

--
-- 使用表AUTO_INCREMENT `mall_fx_grade`
--
ALTER TABLE `mall_fx_grade`
  MODIFY `grade_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '等级编号';

--
-- 使用表AUTO_INCREMENT `mall_goods`
--
ALTER TABLE `mall_goods`
  MODIFY `good_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号';

--
-- 使用表AUTO_INCREMENT `mall_goods_relate`
--
ALTER TABLE `mall_goods_relate`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键';

--
-- 使用表AUTO_INCREMENT `mall_goods_specs`
--
ALTER TABLE `mall_goods_specs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表主键';

--
-- 使用表AUTO_INCREMENT `mall_goods_trans`
--
ALTER TABLE `mall_goods_trans`
  MODIFY `trans_id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `mall_goods_wholesale`
--
ALTER TABLE `mall_goods_wholesale`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `mall_goods_wholesale_activities`
--
ALTER TABLE `mall_goods_wholesale_activities`
  MODIFY `activity_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '活动编号';

--
-- 使用表AUTO_INCREMENT `mall_good_infos`
--
ALTER TABLE `mall_good_infos`
  MODIFY `info_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '标准类目参数ID', AUTO_INCREMENT=2;

--
-- 使用表AUTO_INCREMENT `mall_grade_conditions`
--
ALTER TABLE `mall_grade_conditions`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `mall_jifen_logs`
--
ALTER TABLE `mall_jifen_logs`
  MODIFY `jifen_log_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '积分logId';

--
-- 使用表AUTO_INCREMENT `mall_labels`
--
ALTER TABLE `mall_labels`
  MODIFY `label_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '标签编号';

--
-- 使用表AUTO_INCREMENT `mall_labels_item`
--
ALTER TABLE `mall_labels_item`
  MODIFY `label_item_id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `mall_labels_sub`
--
ALTER TABLE `mall_labels_sub`
  MODIFY `label_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '标签编号';

--
-- 使用表AUTO_INCREMENT `mall_member_benefit_code`
--
ALTER TABLE `mall_member_benefit_code`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键', AUTO_INCREMENT=37;

--
-- 使用表AUTO_INCREMENT `mall_member_grades`
--
ALTER TABLE `mall_member_grades`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `mall_member_grade_relations`
--
ALTER TABLE `mall_member_grade_relations`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键';

--
-- 使用表AUTO_INCREMENT `mall_member_groups`
--
ALTER TABLE `mall_member_groups`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `mall_member_group_relations`
--
ALTER TABLE `mall_member_group_relations`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `mall_member_remarks`
--
ALTER TABLE `mall_member_remarks`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `mall_member_tags`
--
ALTER TABLE `mall_member_tags`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '标签的id';

--
-- 使用表AUTO_INCREMENT `mall_member_tag_associations`
--
ALTER TABLE `mall_member_tag_associations`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '标签的id';

--
-- 使用表AUTO_INCREMENT `mall_messages`
--
ALTER TABLE `mall_messages`
  MODIFY `msg_id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `mall_message_recipients`
--
ALTER TABLE `mall_message_recipients`
  MODIFY `rec_id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `mall_notification_records`
--
ALTER TABLE `mall_notification_records`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表主键', AUTO_INCREMENT=9;

--
-- 使用表AUTO_INCREMENT `mall_notification_switch`
--
ALTER TABLE `mall_notification_switch`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '表主键';

--
-- 使用表AUTO_INCREMENT `mall_notification_template`
--
ALTER TABLE `mall_notification_template`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表主键', AUTO_INCREMENT=4;

--
-- 使用表AUTO_INCREMENT `mall_oauth_google`
--
ALTER TABLE `mall_oauth_google`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表主键';

--
-- 使用表AUTO_INCREMENT `mall_oauth_microsoft`
--
ALTER TABLE `mall_oauth_microsoft`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表主键';

--
-- 使用表AUTO_INCREMENT `mall_oauth_wechat`
--
ALTER TABLE `mall_oauth_wechat`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表主键';

--
-- 使用表AUTO_INCREMENT `mall_order`
--
ALTER TABLE `mall_order`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `mall_order_actual_tongji`
--
ALTER TABLE `mall_order_actual_tongji`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `mall_order_handlepay`
--
ALTER TABLE `mall_order_handlepay`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键';

--
-- 使用表AUTO_INCREMENT `mall_order_insured`
--
ALTER TABLE `mall_order_insured`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '保险单ID';

--
-- 使用表AUTO_INCREMENT `mall_order_items`
--
ALTER TABLE `mall_order_items`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表主键';

--
-- 使用表AUTO_INCREMENT `mall_order_tongji`
--
ALTER TABLE `mall_order_tongji`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `mall_order_wander_template`
--
ALTER TABLE `mall_order_wander_template`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '订单流转消息模板ID';

--
-- 使用表AUTO_INCREMENT `mall_order_waybill_express`
--
ALTER TABLE `mall_order_waybill_express`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键';

--
-- 使用表AUTO_INCREMENT `mall_order_waybill_express_details`
--
ALTER TABLE `mall_order_waybill_express_details`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表主键';

--
-- 使用表AUTO_INCREMENT `mall_paying_flow`
--
ALTER TABLE `mall_paying_flow`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表主键';

--
-- 使用表AUTO_INCREMENT `mall_payment_method`
--
ALTER TABLE `mall_payment_method`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '表主键', AUTO_INCREMENT=4;

--
-- 使用表AUTO_INCREMENT `mall_prepay`
--
ALTER TABLE `mall_prepay`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表主键';

--
-- 使用表AUTO_INCREMENT `mall_prepay_details`
--
ALTER TABLE `mall_prepay_details`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表主键';

--
-- 使用表AUTO_INCREMENT `mall_printers`
--
ALTER TABLE `mall_printers`
  MODIFY `printer_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增主键';

--
-- 使用表AUTO_INCREMENT `mall_printer_template`
--
ALTER TABLE `mall_printer_template`
  MODIFY `template_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '模板编号';

--
-- 使用表AUTO_INCREMENT `mall_printer_template_relation`
--
ALTER TABLE `mall_printer_template_relation`
  MODIFY `relation_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '关系编号';

--
-- 使用表AUTO_INCREMENT `mall_purchase`
--
ALTER TABLE `mall_purchase`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表主键', AUTO_INCREMENT=22;

--
-- 使用表AUTO_INCREMENT `mall_purchase_import`
--
ALTER TABLE `mall_purchase_import`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键', AUTO_INCREMENT=3;

--
-- 使用表AUTO_INCREMENT `mall_purchase_items`
--
ALTER TABLE `mall_purchase_items`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表主键', AUTO_INCREMENT=22;

--
-- 使用表AUTO_INCREMENT `mall_purchase_orders`
--
ALTER TABLE `mall_purchase_orders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表主键', AUTO_INCREMENT=15;

--
-- 使用表AUTO_INCREMENT `mall_purchase_prepay`
--
ALTER TABLE `mall_purchase_prepay`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表主键', AUTO_INCREMENT=6;

--
-- 使用表AUTO_INCREMENT `mall_purchase_prepay_details`
--
ALTER TABLE `mall_purchase_prepay_details`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表主键', AUTO_INCREMENT=6;

--
-- 使用表AUTO_INCREMENT `mall_push_order_logs`
--
ALTER TABLE `mall_push_order_logs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键';

--
-- 使用表AUTO_INCREMENT `mall_review`
--
ALTER TABLE `mall_review`
  MODIFY `review_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '评论编号';

--
-- 使用表AUTO_INCREMENT `mall_sales_order_status`
--
ALTER TABLE `mall_sales_order_status`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- 使用表AUTO_INCREMENT `mall_search_meta_delivery_country`
--
ALTER TABLE `mall_search_meta_delivery_country`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '表主键';

--
-- 使用表AUTO_INCREMENT `mall_search_meta_out_id`
--
ALTER TABLE `mall_search_meta_out_id`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `mall_seo_baidu`
--
ALTER TABLE `mall_seo_baidu`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键', AUTO_INCREMENT=2;

--
-- 使用表AUTO_INCREMENT `mall_seo_bing`
--
ALTER TABLE `mall_seo_bing`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键';

--
-- 使用表AUTO_INCREMENT `mall_seo_google`
--
ALTER TABLE `mall_seo_google`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键';

--
-- 使用表AUTO_INCREMENT `mall_service`
--
ALTER TABLE `mall_service`
  MODIFY `service_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '增值服务ID';

--
-- 使用表AUTO_INCREMENT `mall_service_order`
--
ALTER TABLE `mall_service_order`
  MODIFY `service_order_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '服务单号';

--
-- 使用表AUTO_INCREMENT `mall_ships`
--
ALTER TABLE `mall_ships`
  MODIFY `ship_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '配送模板Id';

--
-- 使用表AUTO_INCREMENT `mall_shops_express_config`
--
ALTER TABLE `mall_shops_express_config`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '快递表主键', AUTO_INCREMENT=13;

--
-- 使用表AUTO_INCREMENT `mall_shop_configs`
--
ALTER TABLE `mall_shop_configs`
  MODIFY `shop_config_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '配置编号';

--
-- 使用表AUTO_INCREMENT `mall_shop_domain`
--
ALTER TABLE `mall_shop_domain`
  MODIFY `domain_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '域名编号';

--
-- 使用表AUTO_INCREMENT `mall_shop_funds`
--
ALTER TABLE `mall_shop_funds`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表主键';

--
-- 使用表AUTO_INCREMENT `mall_shop_funds_change_log`
--
ALTER TABLE `mall_shop_funds_change_log`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表主键';

--
-- 使用表AUTO_INCREMENT `mall_shop_recharge_log`
--
ALTER TABLE `mall_shop_recharge_log`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表主键', AUTO_INCREMENT=10;

--
-- 使用表AUTO_INCREMENT `mall_shop_view`
--
ALTER TABLE `mall_shop_view`
  MODIFY `view_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '视图id';

--
-- 使用表AUTO_INCREMENT `mall_skus`
--
ALTER TABLE `mall_skus`
  MODIFY `sku_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '规格编号';

--
-- 使用表AUTO_INCREMENT `mall_skus_map`
--
ALTER TABLE `mall_skus_map`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', AUTO_INCREMENT=3;

--
-- 使用表AUTO_INCREMENT `mall_sku_props`
--
ALTER TABLE `mall_sku_props`
  MODIFY `prop_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '类型编号';

--
-- 使用表AUTO_INCREMENT `mall_sku_tax`
--
ALTER TABLE `mall_sku_tax`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键';

--
-- 使用表AUTO_INCREMENT `mall_sku_values`
--
ALTER TABLE `mall_sku_values`
  MODIFY `value_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '属性值编号';

--
-- 使用表AUTO_INCREMENT `mall_sku_warehouse_relation`
--
ALTER TABLE `mall_sku_warehouse_relation`
  MODIFY `relation_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '关系编号';

--
-- 使用表AUTO_INCREMENT `mall_stockchange_log`
--
ALTER TABLE `mall_stockchange_log`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表主键';

--
-- 使用表AUTO_INCREMENT `mall_stocks_locked`
--
ALTER TABLE `mall_stocks_locked`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `mall_stocks_locked_logs`
--
ALTER TABLE `mall_stocks_locked_logs`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `mall_stocks_logs`
--
ALTER TABLE `mall_stocks_logs`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `mall_stocks_pre`
--
ALTER TABLE `mall_stocks_pre`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `mall_subscribes`
--
ALTER TABLE `mall_subscribes`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID';

--
-- 使用表AUTO_INCREMENT `mall_trans`
--
ALTER TABLE `mall_trans`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID';

--
-- 使用表AUTO_INCREMENT `mall_trans_task`
--
ALTER TABLE `mall_trans_task`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID';

--
-- 使用表AUTO_INCREMENT `mall_trans_task_logs`
--
ALTER TABLE `mall_trans_task_logs`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `mall_trans_task_unique`
--
ALTER TABLE `mall_trans_task_unique`
  MODIFY `trans_task_uniqe_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID';

--
-- 使用表AUTO_INCREMENT `mall_trans_words`
--
ALTER TABLE `mall_trans_words`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `mall_uploads`
--
ALTER TABLE `mall_uploads`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增id';

--
-- 使用表AUTO_INCREMENT `mall_uploads_attachments`
--
ALTER TABLE `mall_uploads_attachments`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增id';

--
-- 使用表AUTO_INCREMENT `mall_warehouse_priority_shipping`
--
ALTER TABLE `mall_warehouse_priority_shipping`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表主键';

--
-- 使用表AUTO_INCREMENT `mall_warehouse_region_delivery`
--
ALTER TABLE `mall_warehouse_region_delivery`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表主键';

--
-- 使用表AUTO_INCREMENT `mall_warehouse_stock`
--
ALTER TABLE `mall_warehouse_stock`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表主键';

--
-- 使用表AUTO_INCREMENT `mall_webhook_logs`
--
ALTER TABLE `mall_webhook_logs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表主键';

--
-- 使用表AUTO_INCREMENT `sys_dict_data`
--
ALTER TABLE `sys_dict_data`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '字典编码', AUTO_INCREMENT=116;

--
-- 使用表AUTO_INCREMENT `sys_dict_type`
--
ALTER TABLE `sys_dict_type`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '字典主键', AUTO_INCREMENT=25;

--
-- 使用表AUTO_INCREMENT `sys_log`
--
ALTER TABLE `sys_log`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `sys_resources`
--
ALTER TABLE `sys_resources`
  MODIFY `resource_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'api编号', AUTO_INCREMENT=401;

--
-- 使用表AUTO_INCREMENT `sys_resource_groups`
--
ALTER TABLE `sys_resource_groups`
  MODIFY `res_group_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '分组编号', AUTO_INCREMENT=54;

--
-- 使用表AUTO_INCREMENT `sys_version`
--
ALTER TABLE `sys_version`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表主键';
COMMIT;

