Главная Обзор Помощь
Вход
shishichen
/
qimall
Следить 1
В избранное 0
Ответвить 0
Файлы Обсуждения 0 Запросы на слияние 0 Вики
Ветка: dev
Ветки Метки
qimall
/
addons
/
WangDianTong
/
install.sql

install.sql 40 KB
Постоянная ссылка История Исходник

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217 
  1. INSERT INTO `qimall_express` (`id`, `name`, `code`, `status`, `created_at`, `updated_at`) VALUES (10000, '其他', 'QT', 1, 1631687277, 1631687277);
    2. 

  2. 

  3. CREATE TABLE `qimall_addons_wangdiantong_logistics_company` (
    4. 

  4.     `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '订单id',
    5. 

  5.     `status` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]',
    6. 

  6.     `created_at` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '创建时间',
    7. 

  7.     `updated_at` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '更新时间',
    8. 

  8.     `erp_type` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'ERP物流公司ID',
    9. 

  9.     `erp_name` VARCHAR(50) NOT NULL DEFAULT '' COMMENT 'ERP物流公司名称' COLLATE 'utf8mb4_general_ci',
    10. 

  10.     `express_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '当前系统快递主键',
    11. 

  11.     `express_name` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '当前系统物流公司名称' COLLATE 'utf8mb4_general_ci',
    12. 

  12.     `express_code` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '当前系统物流公司编码' COLLATE 'utf8mb4_general_ci',
    13. 

  13.     PRIMARY KEY (`id`) USING BTREE,
    14. 

  14.     INDEX `express_id` (`express_id`) USING BTREE,
    15. 

  15.     INDEX `erp_id` (`erp_type`) USING BTREE
    16. 

  16. )
    17. 

  17.     COMMENT='物流公司'
    18. 

  18. COLLATE='utf8mb4_general_ci'
    19. 

  19. ENGINE=InnoDB;
    20. 

  20. 

  21. CREATE TABLE `qimall_addons_wangdiantong_logistics_sync` (
    22. 

  22.     `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '订单id',
    23. 

  23.     `mall_id` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '商城ID',
    24. 

  24.     `status` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]',
    25. 

  25.     `created_at` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '创建时间',
    26. 

  26.     `updated_at` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '更新时间',
    27. 

  27.     `rec_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '主键,用于logistics_sync_ack回写状态',
    28. 

  28.     `ack_status` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '0位同步，10同步中，50同步失败，100同步成功',
    29. 

  29.     `order_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '订单号ID',
    30. 

  30.     `logistics_code` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '物流单号' COLLATE 'utf8mb4_general_ci',
    31. 

  31.     `logistics_name` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '物流公司名称' COLLATE 'utf8mb4_general_ci',
    32. 

  32.     `logistics_code_erp` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '旺店通物流单号' COLLATE 'utf8mb4_general_ci',
    33. 

  33.     `logistics_name_erp` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '旺店通物流公司名称' COLLATE 'utf8mb4_general_ci',
    34. 

  34.     `sync_res` JSON NOT NULL COMMENT '旺店通同步数据',
    35. 

  35.     `is_local` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '是否为本地同步至旺店通',
    36. 

  36.     `remark` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '备注信息' COLLATE 'utf8mb4_general_ci',
    37. 

  37.     PRIMARY KEY (`id`) USING BTREE,
    38. 

  38.     INDEX `rec_id` (`rec_id`) USING BTREE,
    39. 

  39.     INDEX `order_id` (`order_id`) USING BTREE
    40. 

  40. )
    41. 

  41.     COMMENT='物流同步'
    42. 

  42. COLLATE='utf8mb4_general_ci'
    43. 

  43. ENGINE=InnoDB;
    44. 

  44. 

  45. CREATE TABLE `qimall_addons_wangdiantong_order_sync_fail` (
    46. 

  46.     `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '订单id',
    47. 

  47.     `mall_id` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '商城ID',
    48. 

  48.     `status` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]',
    49. 

  49.     `created_at` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '创建时间',
    50. 

  50.     `updated_at` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '更新时间',
    51. 

  51.     `data` JSON NOT NULL COMMENT '队列数据',
    52. 

  52.     `consumer_num` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT '已消费次数',
    53. 

  53.     `consumer_class` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '消费对象' COLLATE 'utf8mb4_general_ci',
    54. 

  54.     `consumer_method` VARCHAR(30) NOT NULL DEFAULT '' COMMENT '消费方法' COLLATE 'utf8mb4_general_ci',
    55. 

  55.     `last_consumer_at` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '最后消费时间',
    56. 

  56.     `error_message` JSON NOT NULL COMMENT '消费失败信息',
    57. 

  57.     `data_hash` CHAR(32) NOT NULL DEFAULT '' COMMENT 'mall_id:data:consumer_class:consumer_method的hash值' COLLATE 'utf8mb4_general_ci',
    58. 

  58.     PRIMARY KEY (`id`) USING BTREE,
    59. 

  59.     INDEX `status` (`status`) USING BTREE,
    60. 

  60.     INDEX `data_hash` (`data_hash`) USING BTREE
    61. 

  61. )
    62. 

  62.     COMMENT='订单同步失败表'
    63. 

  63. COLLATE='utf8mb4_general_ci'
    64. 

  64. ENGINE=InnoDB;
    65. 

  65. 

  66. 

  67. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132331, 1684132331, 1, '无单号物流', 0, '', '');
    68. 

  68. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132331, 1684132331, 2, '中国邮政平邮', 9, '邮政快递包裹', 'YZPY');
    69. 

  69. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132331, 1684132439, 3, 'EMS', 7, 'EMS', 'EMS');
    70. 

  70. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132331, 1684132439, 4, '圆通速递', 4, '圆通速递', 'YTO');
    71. 

  71. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132331, 1684132439, 5, '中通快递', 5, '中通快递', 'ZTO');
    72. 

  72. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132331, 1684132439, 6, '申通快递', 2, '申通快递', 'STO');
    73. 

  73. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132331, 1684132439, 7, '全峰快递', 12, '全峰快递', 'QFKD');
    74. 

  74. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132331, 1684132439, 8, '顺丰速运', 1, '顺丰速运', 'SF');
    75. 

  75. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132331, 1684132331, 9, '韵达快递', 3, '韵达速递', 'YD');
    76. 

  76. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132331, 1684132331, 10, '汇通快运', 0, '', '');
    77. 

  77. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132331, 1684132439, 11, '中铁快运', 14, '中铁快运', 'ZTKY');
    78. 

  78. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132331, 1684132331, 12, '中远', 0, '', '');
    79. 

  79. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132331, 1684132331, 13, '龙邦速递', 55, '龙邦快递', 'LB');
    80. 

  80. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132331, 1684132331, 14, '快捷速递', 33, '快捷快递', 'FAST');
    81. 

  81. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132331, 1684132440, 15, '全日通快递', 62, '全日通快递', 'QRT');
    82. 

  82. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132331, 1684132331, 16, '海航天天快递', 0, '', '');
    83. 

  83. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132331, 1684132331, 17, '发网', 0, '', '');
    84. 

  84. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132331, 1684132440, 18, '联昊通', 56, '联昊通速递', 'LHT');
    85. 

  85. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132331, 1684132440, 19, '宅急送', 10, '宅急送', 'ZJS');
    86. 

  86. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132331, 1684132331, 20, '百世物流', 6, '百世快递', 'HTKY');
    87. 

  87. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132331, 1684132331, 21, '联邦快递', 34, 'FEDEX联邦(国内件）', 'FEDEX');
    88. 

  88. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132331, 1684132331, 22, '德邦物流', 18, '德邦', 'DBL');
    89. 

  89. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132331, 1684132440, 23, '华强物流', 42, '华强物流', 'hq568');
    90. 

  90. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132331, 1684132331, 24, '星辰急便', 0, '', '');
    91. 

  91. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132331, 1684132440, 25, '亚风', 86, '亚风快递', 'YFSD');
    92. 

  92. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132331, 1684132331, 26, '长宇', 0, '', '');
    93. 

  93. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132331, 1684132440, 27, '大田', 32, '大田物流', 'DTWL');
    94. 

  94. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132331, 1684132331, 28, '长发', 0, '', '');
    95. 

  95. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132331, 1684132331, 29, '安得', 0, '', '');
    96. 

  96. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132331, 1684132440, 30, 'CCES', 26, 'CCES快递', 'CCES');
    97. 

  97. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132331, 1684132331, 31, '东方汇', 0, '', '');
    98. 

  98. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132331, 1684132331, 32, '首业', 0, '', '');
    99. 

  99. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132331, 1684132331, 33, '远长', 0, '', '');
    100. 

  100. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132331, 1684132440, 34, '新邦物流', 77, '新邦物流', 'XBWL');
    101. 

  101. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132331, 1684132331, 35, '优速物流', 13, '优速快递', 'UC');
    102. 

  102. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132331, 1684132331, 36, '港中能达', 0, '', '');
    103. 

  103. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132331, 1684132440, 37, '全一快递', 74, '全一快递', 'UAPEX');
    104. 

  104. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132331, 1684132331, 38, '黑猫宅急便', 0, '', '');
    105. 

  105. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132331, 1684132331, 39, '浙江ABC', 0, '', '');
    106. 

  106. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132331, 1684132331, 40, '杭州爱彼西', 0, '', '');
    107. 

  107. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132331, 1684132331, 41, '四川快捷', 0, '', '');
    108. 

  108. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 42, '贝业新兄弟', 0, '', '');
    109. 

  109. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 45, 'EMS经济快递', 7, 'EMS', 'EMS');
    110. 

  110. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 46, '飞远配送', 0, '', '');
    111. 

  111. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 47, '尚橙物流', 0, '', '');
    112. 

  112. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 48, '广东EMS', 37, '广东邮政', 'GDEMS');
    113. 

  113. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132440, 49, '城市100', 27, '城市100', 'CITY100');
    114. 

  114. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132440, 50, '汇强快递', 90, '汇强快递', 'ZHQKD');
    115. 

  115. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 51, '邮政国内小包', 1001, '邮政包裹信件', 'YZPY');
    116. 

  116. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132440, 52, '国通快递', 11, '国通快递', 'GTO');
    117. 

  117. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 53, 'E速宝', 0, '', '');
    118. 

  118. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 54, '同城快递', 0, '', '');
    119. 

  119. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 55, '北京EMS', 0, '', '');
    120. 

  120. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 56, '佳吉快递', 47, '佳吉快运', 'JJKY');
    121. 

  121. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 57, '凡宇速递', 0, '', '');
    122. 

  122. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132440, 58, '天地华宇', 41, '天地华宇', 'HOAU');
    123. 

  123. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 59, '居无忧', 0, '', '');
    124. 

  124. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 60, '美国速递', 0, '', '');
    125. 

  125. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 70, '派易国际物流77', 0, '', '');
    126. 

  126. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 71, 'RUSTON', 0, '', '');
    127. 

  127. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132440, 72, '速尔', 72, '速尔快递', 'SURE');
    128. 

  128. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132440, 73, '信丰物流', 78, '信丰物流', 'XFEX');
    129. 

  129. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 74, '燕文北京', 0, '', '');
    130. 

  130. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 75, '燕文广州', 0, '', '');
    131. 

  131. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 76, '燕文国际', 0, '', '');
    132. 

  132. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 77, '燕文上海', 0, '', '');
    133. 

  133. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 78, '燕文深圳', 0, '', '');
    134. 

  134. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 79, '燕文义乌', 0, '', '');
    135. 

  135. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 80, '合众阳晟', 0, '', '');
    136. 

  136. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 81, 'ZTOGZ', 5, '中通快递', 'ZTO');
    137. 

  137. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 82, 'ZTOSH', 5, '中通快递', 'ZTO');
    138. 

  138. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 83, '保宏物流', 0, '', '');
    139. 

  139. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 84, '增益速递', 89, '增益快递', 'ZENY');
    140. 

  140. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 85, '贝海国际速递', 0, '', '');
    141. 

  141. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 86, '如风达配送', 63, '如风达', 'RFD');
    142. 

  142. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132440, 87, '安能快递', 1002, '安能快递', 'ANE');
    143. 

  143. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 88, '德邦快递', 18, '德邦', 'DBL');
    144. 

  144. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 89, '菜鸟智选物流', 0, '', '');
    145. 

  145. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 90, '菜鸟配送', 0, '', '');
    146. 

  146. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132440, 91, '跨越速运', 1016, '跨越速运', 'KYSY');
    147. 

  147. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132441, 92, '百世快运', 20, '百世快运', 'BTWL');
    148. 

  148. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132441, 93, 'D速物流', 31, 'D速物流', 'DSWL');
    149. 

  149. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132441, 94, '德邦快运', 1011, '德邦快运', 'DBLKY');
    150. 

  150. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132441, 95, '安能快运', 22, '安能快运', 'ANEKY');
    151. 

  151. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132441, 96, '壹米滴答', 1023, '壹米滴答', 'YMDD');
    152. 

  152. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132441, 97, '韵达快运', 1020, '韵达快运', 'YDKY');
    153. 

  153. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 98, '品骏（JITX）', 1007, '品骏快递', 'PJ');
    154. 

  154. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 99, '圆通（JITX）', 4, '圆通速递', 'YTO');
    155. 

  155. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 100, '圆通承诺达', 4, '圆通速递', 'YTO');
    156. 

  156. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132441, 101, '品骏快递', 1007, '品骏快递', 'PJ');
    157. 

  157. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 102, '芝麻开门', 0, '', '');
    158. 

  158. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 103, '京东大件物流', 103, '京东物流', 'JD');
    159. 

  159. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 104, '苏宁快递', 0, '', '');
    160. 

  160. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 105, '蜂鸟配送', 0, '', '');
    161. 

  161. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 106, '顺丰快运', 1, '顺丰速运', 'SF');
    162. 

  162. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 107, '京东纯配', 103, '京东物流', 'JD');
    163. 

  163. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 108, '极兔速递', 1024, '极兔快递', 'JTSD');
    164. 

  164. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 109, '众邮快递', 0, '', '');
    165. 

  165. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132441, 201, '九曳供应链', 46, '九曳供应链', 'JIUYE');
    166. 

  166. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 1307, '顺丰同城配', 1, '顺丰速运', 'SF');
    167. 

  167. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 1308, '菜鸟落地配-万象', 0, '', '');
    168. 

  168. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 1309, '青岛日日顺', 0, '', '');
    169. 

  169. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 1311, '京邦达', 0, '', '');
    170. 

  170. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 2000, '其他', 10000, '其他', 'QT');
    171. 

  171. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 2005, '成都东骏快捷物流有限公司', 0, '', '');
    172. 

  172. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 2006, '小家电-陕西黄马甲', 0, '', '');
    173. 

  173. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132441, 2036, '亚马逊', 16, '亚马逊物流', 'AMAZON');
    174. 

  174. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 2039, '八达通物流', 0, '', '');
    175. 

  175. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 2087, '九曳鲜配', 0, '', '');
    176. 

  176. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 2074, '韵达国际', 3, '韵达速递', 'YD');
    177. 

  177. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 2075, '天天国际', 8, '天天快递', 'HHTT');
    178. 

  178. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 2076, '递四方', 0, '', '');
    179. 

  179. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 2077, '中远E环球', 0, '', '');
    180. 

  180. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 2078, '秀驿物流', 0, '', '');
    181. 

  181. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 2079, '优邦速运', 0, '', '');
    182. 

  182. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 2080, 'VoyageOne', 0, '', '');
    183. 

  183. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132441, 2081, 'UEQ', 102, 'UEQ Express', 'UEQ');
    184. 

  184. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 2082, '斑马物联网', 0, '', '');
    185. 

  185. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 2083, '卓志速运', 0, '', '');
    186. 

  186. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 2084, '申通国际', 2, '申通快递', 'STO');
    187. 

  187. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 2085, '威时沛运', 0, '', '');
    188. 

  188. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 2088, '香港邮政', 0, '', '');
    189. 

  189. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 2089, '中通国际', 5, '中通快递', 'ZTO');
    190. 

  190. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 2090, '广东EMS跨境易', 37, '广东邮政', 'GDEMS');
    191. 

  191. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 2093, '日本邮政', 0, '', '');
    192. 

  192. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 2094, '贝海国际', 0, '', '');
    193. 

  193. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 2095, '百世国际', 6, '百世快递', 'HTKY');
    194. 

  194. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132441, 2110, '中通快运', 1005, '中通快运', 'ZTOKY');
    195. 

  195. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 2115, '圆通国际（海外G面单）', 4, '圆通速递', 'YTO');
    196. 

  196. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 2116, '高捷跨境快运', 0, '', '');
    197. 

  197. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 2117, '易客满国际物流', 0, '', '');
    198. 

  198. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132441, 2128, '京广速递', 45, '京广速递', 'JGSD');
    199. 

  199. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 2124, 'EWE GLOBAL', 0, '', '');
    200. 

  200. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132441, 2127, '顺心捷达', 1018, '顺心捷达', 'SX');
    201. 

  201. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 2129, '圆通国际(海外会员版)', 4, '圆通速递', 'YTO');
    202. 

  202. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132441, 2131, '丰网速运', 1025, '丰网速运', 'FWX');
    203. 

  203. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 2132, '淘特官方物流', 0, '', '');
    204. 

  204. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 2133, '1688官方快递', 0, '', '');
    205. 

  205. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 2134, '1688官方快运', 0, '', '');
    206. 

  206. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132442, 2135, '速通物流', 70, '速通物流', 'ST');
    207. 

  207. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 2136, '抖店BIC送货', 0, '', '');
    208. 

  208. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 2137, '韵达同城', 3, '韵达速递', 'YD');
    209. 

  209. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 2138, '菜鸟裹裹同城特快', 0, '', '');
    210. 

  210. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132442, 2139, '加运美', 52, '加运美', 'JYM');
    211. 

  211. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132442, 2140, '平安达腾飞', 60, '平安达腾飞快递', 'PADTF');
    212. 

  212. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 2141, '丹鸟快递', 0, '', '');
    213. 

  213. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 2143, '快弟来了', 0, '', '');
    214. 

  214. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 2146, '京东快递(无店铺)', 103, '京东物流', 'JD');
    215. 

  215. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 3017, '安迅物流', 0, '', '');
    216. 

  216. INSERT INTO `qimall_addons_wangdiantong_logistics_company` (`status`, `created_at`, `updated_at`, `erp_type`, `erp_name`, `express_id`, `express_name`, `express_code`) VALUES (1, 1684132332, 1684132332, 3507, '丹鸟-小家电CODE（菜鸟）', 0, '', '');
    217. 

  217.