ホーム エクスプローラ ヘルプ
登録 サインイン
liebao
/
liebao-cloud
2
0
Fork 0
ファイル 課題 0 プルリクエスト 0 Wiki
ツリー: f645f53e15
ブランチ タグ
liebao-cloud
/
doc
/
history.sql

history.sql 139 KB
履歴 Raw

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033 
  1. 

  2. 

  3. alter table `lb_member` add column  `agent_source`  tinyint(4) DEFAULT NULL COMMENT '代理商来源：1->直属  2->邀请';
    4. 

  4. alter table `lb_order` add column  `agent_Id`  int(11) DEFAULT NULL COMMENT '代理商ID';
    5. 

  5. alter table `lb_order` add column  `agent_Id_source` tinyint(4) DEFAULT NULL COMMENT '代理商来源： 1->直属  2->邀请 3->区域';
    6. 

  6. 

  7. CREATE TABLE `lb_profits_detail` (
    8. 

  8.   `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    9. 

  9.   `order_id` int(11) NOT NULL COMMENT '订单id',
    10. 

  10.   `order_pay_amount` decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT '订单支付金额',
    11. 

  11.   `agent_id` int(11) DEFAULT NULL COMMENT '参与分佣代理商ID',
    12. 

  12.   `agent_Id_source` tinyint(4) DEFAULT NULL COMMENT '代理商来源： 1->直属  2->邀请 3->区域 4-> 间接',
    13. 

  13.   `dsp_id` int(11) DEFAULT NULL COMMENT '参与分佣渠道ID',
    14. 

  14.   `order_type` int(11) DEFAULT '0' COMMENT '1->外卖订单  2->配送订单',
    15. 

  15.   `amount` decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT '参与分佣总金额',
    16. 

  16.   `commission` decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT '收益金额',
    17. 

  17.   `source` int(11) DEFAULT '0' COMMENT '分佣来源:1->自己分钱记录  2->上级分钱记录',
    18. 

  18.   `rate` decimal(11,2) DEFAULT NULL COMMENT '佣金比例(百分比)',
    19. 

  19.   `delivery_type` int(11) DEFAULT '0' COMMENT '配送类型:参照DeliveryTypeEnums枚举',
    20. 

  20.   `delivery_name` varchar(30) DEFAULT NULL COMMENT '配送平台名称',
    21. 

  21.   `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    22. 

  22.   `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
    23. 

  23.   `deleted` tinyint(2) NOT NULL DEFAULT '0',
    24. 

  24.   PRIMARY KEY (`id`) USING BTREE
    25. 

  25. ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='代理商/渠道分佣明细';
    26. 

  26. 

  27. 

  28. 

  29. -------------------------------04-25
    30. 

  30. alter table `lb_coupon` add column  `member_recive_num` int(11) DEFAULT '1' COMMENT '用户领取数量';
    31. 

  31. 

  32. 

  33. -------------------------------0506
    34. 

  34. alter table `lb_shop` add column  `biz_license`  varchar(255) DEFAULT NULL COMMENT '营业执照';
    35. 

  35. alter table `lb_shop` add column  `biz_license_no`  varchar(30) DEFAULT NULL COMMENT '营业执照号码';
    36. 

  36. alter table `lb_shop` add column  `legal_person`  varchar(20) DEFAULT NULL COMMENT '法人姓名';
    37. 

  37. alter table `lb_shop` add column  `idcard_no`  varchar(20) DEFAULT NULL COMMENT '身份证号码';
    38. 

  38. alter table `lb_shop` add column  `idcard_front`  varchar(255) DEFAULT NULL COMMENT '法人身份证正面照片';
    39. 

  39. alter table `lb_shop` add column  `idcard_back`  varchar(255) DEFAULT NULL COMMENT '法人身份证反面照片';
    40. 

  40. alter table `lb_shop` add column  `biz_license_idcard`  varchar(255) DEFAULT NULL COMMENT '门店拥有人手持身份证、营业执照图片(蜂鸟)';
    41. 

  41. 

  42. ALTER TABLE `lb_member_balance_log`
    43. 

  43. ADD COLUMN `merchant_id`  int NULL AFTER `deleted`;
    44. 

  44. alter table `lb_profits_detail` add column  `is_source`  tinyint(2) NOT NULL DEFAULT '0' COMMENT '0->正式数据  1->测试数据';
    45. 

  45. 

  46. -- local.sql
    47. 

  47. alter table `lb_order_delivery` add column  `commission`  decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '佣金';
    48. 

  48. alter table `lb_order_delivery` add column  `is_mine`  int(11) DEFAULT '2' COMMENT '支付使用的平台 0->猎豹平台，1->自己运力平台，2->未知';
    49. 

  49. alter table `lb_order_delivery` add column  `origin_amount`  decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '原始支付金额';
    50. 

  50. alter table `lb_order_delivery` add column  `hll_status` int(11) DEFAULT NULL COMMENT '货拉拉订单状态';
    51. 

  51. alter table `lb_profits_detail` add column  `origin_source` tinyint(2) NOT NULL DEFAULT '0' COMMENT '来源：1->第三方支付订单，0->平台支付订单';
    52. 

  52. alter table `lb_profits_detail` add column  `type` tinyint(2) NOT NULL DEFAULT '0' COMMENT '分佣固定类型：1->金额，0->比例';
    53. 

  53. 

  54. -- 20211014_billing.sql
    55. 

  55. ALTER TABLE `lb_order` ADD COLUMN `save_flag` tinyint(1) DEFAULT 0 COMMENT '手动发单保存标识(普通预约单手动发单此字段有效 0-非预约发单保存 1-预约发单保存)' AFTER `cancel_type`;
    56. 

  56. ALTER TABLE `lb_order` ADD COLUMN `invoice_title` varchar(255) DEFAULT NULL COMMENT '发票抬头' AFTER `cancel_type`;
    57. 

  57. ALTER TABLE `lb_order` ADD COLUMN `taxpayer_id` varchar(255) DEFAULT NULL COMMENT '发票税号' AFTER `cancel_type`;
    58. 

  58. 

  59. -- 20211028_account.sql
    60. 

  60. ALTER TABLE `lb_member_balance_log` ADD COLUMN `payment_type` tinyint(2) DEFAULT NULL COMMENT '支付类型：1->支付宝支付 2->微信支付 3->银联支付 4->余额支付 5->三方运力支付' AFTER `order_id`;
    61. 

  61. ALTER TABLE `lb_member_config` ADD COLUMN `show_food_img` tinyint(1) DEFAULT 1 COMMENT '是否显示商品图片: 1->显示，0->不显示' AFTER `shield_delivery_ids`;
    62. 

  62. 

  63. -- 20211108_print_opt.sql
    64. 

  64. ALTER TABLE `lb_shop_device` ADD COLUMN `width` int(11) DEFAULT '0' COMMENT '打印小票宽度(毫米)' AFTER `status`;
    65. 

  65. INSERT INTO `lb_device` (`name`,`img`,`type`,`remark`,`price`,`url`,
    66. 

  66. `app_id`,`app_secert`,`sort`,`is_hot`,`status`)
    67. 

  67. VALUES('USB打印机','',99,NULL,'0.00',NULL,NULL,NULL,0,0,1);
    68. 

  68. 

  69. -- 20211119 shop表增加是否打印二维码字段
    70. 

  70. ALTER TABLE `lb_shop` ADD COLUMN `open_qr_code` tinyint(2) DEFAULT '0' COMMENT '打印二维码：1->打印，0->不打印';
    71. 

  71. 

  72. 

  73. -- feature/20211112_valuation_opt分支, 20211125已上线
    74. 

  74. -- 佣金包
    75. 

  75. CREATE TABLE `lb_package_commission` (
    76. 

  76.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    77. 

  77.   `type` tinyint(2) NOT NULL DEFAULT '0' COMMENT '佣金包类型(0-比例  1-梯度增减)',
    78. 

  78.   `name` varchar(100) NOT NULL DEFAULT '' COMMENT '佣金包名称',
    79. 

  79.   `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    80. 

  80.   `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    81. 

  81.   `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除(0-未删除 1-删除)',
    82. 

  82.   PRIMARY KEY (`id`)
    83. 

  83. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='佣金包';
    84. 

  84. 

  85. -- 佣金包明细
    86. 

  86. CREATE TABLE `lb_package_commission_detail` (
    87. 

  87.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    88. 

  88.   `commission_package_id` bigint(20) NOT NULL COMMENT '佣金包主键id',
    89. 

  89.   `delivery_type` int(5) NOT NULL COMMENT '运力类型',
    90. 

  90.   `gradient_id` bigint(20) DEFAULT NULL COMMENT '梯度id',
    91. 

  91.   `gradient_name` varchar(50) DEFAULT NULL COMMENT '梯度名称',
    92. 

  92.   `value` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '值(比例或者金额)',
    93. 

  93.   `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    94. 

  94.   `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    95. 

  95.   `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除(0-未删除 1-删除)',
    96. 

  96.   PRIMARY KEY (`id`),
    97. 

  97.   KEY `idx_commission_package_id` (`commission_package_id`)
    98. 

  98. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='佣金包明细';
    99. 

  99. 

  100. -- 运力包
    101. 

  101. CREATE TABLE `lb_package_delivery` (
    102. 

  102.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    103. 

  103.   `name` varchar(100) NOT NULL DEFAULT '' COMMENT '运力包名称',
    104. 

  104.   `type` tinyint(2) NOT NULL DEFAULT '0' COMMENT '运力包类型(0-价格优先  1-自定义)',
    105. 

  105.   `bill_duration_type` tinyint(2) NOT NULL COMMENT '发单时间类型(0-默认 1-自定义)',
    106. 

  106.   `bill_duration_str` varchar(255) DEFAULT '' COMMENT '发单时长(单位秒, 多个用逗号分隔)',
    107. 

  107.   `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    108. 

  108.   `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    109. 

  109.   `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除(0-未删除 1-删除)',
    110. 

  110.   PRIMARY KEY (`id`)
    111. 

  111. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='运力包';
    112. 

  112. 

  113. -- 运力包明细
    114. 

  114. CREATE TABLE `lb_package_delivery_detail` (
    115. 

  115.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    116. 

  116.   `delivery_package_id` bigint(20) NOT NULL COMMENT '运力包主键id',
    117. 

  117.   `delivery_type` int(5) NOT NULL COMMENT '运力类型',
    118. 

  118.   `sort` int(11) NOT NULL DEFAULT '0' COMMENT '运力排序',
    119. 

  119.   `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    120. 

  120.   `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    121. 

  121.   `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除(0-未删除 1-删除)',
    122. 

  122.   PRIMARY KEY (`id`),
    123. 

  123.   KEY `idx_delivery_package_id` (`delivery_package_id`)
    124. 

  124. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='运力包明细';
    125. 

  125. 

  126. -- 优惠包
    127. 

  127. CREATE TABLE `lb_package_discount` (
    128. 

  128.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    129. 

  129.   `name` varchar(100) NOT NULL DEFAULT '' COMMENT '优惠包名称',
    130. 

  130.   `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    131. 

  131.   `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    132. 

  132.   `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除(0-未删除 1-删除)',
    133. 

  133.   PRIMARY KEY (`id`)
    134. 

  134. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='优惠包';
    135. 

  135. 

  136. -- 优惠包明细
    137. 

  137. CREATE TABLE `lb_package_discount_detail` (
    138. 

  138.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    139. 

  139.   `discount_package_id` bigint(20) NOT NULL COMMENT '优惠包主键id',
    140. 

  140.   `type` tinyint(2) NOT NULL DEFAULT '0' COMMENT '优惠包类型(0-折扣  1-梯度增减)',
    141. 

  141.   `delivery_type` int(5) NOT NULL COMMENT '运力类型',
    142. 

  142.   `gradient_id` bigint(20) DEFAULT NULL COMMENT '梯度id(type为1时此字段有效)',
    143. 

  143.   `gradient_name` varchar(50) DEFAULT NULL COMMENT '梯度名称(冗余,type为1时此字段有效)',
    144. 

  144.   `value` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT '值(折扣或者金额)',
    145. 

  145.   `max_value` decimal(12,4) DEFAULT '0.0000' COMMENT '峰值(type为0时此字段有效)',
    146. 

  146.   `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    147. 

  147.   `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    148. 

  148.   `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除(0-未删除 1-删除)',
    149. 

  149.   PRIMARY KEY (`id`),
    150. 

  150.   KEY `idx_discount_package_id` (`discount_package_id`)
    151. 

  151. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='优惠包明细';
    152. 

  152. 

  153. -- 优惠包配置表
    154. 

  154. CREATE TABLE `lb_package_gradient_config` (
    155. 

  155.   `id` bigint(20) NOT NULL AUTO_INCREMENT,
    156. 

  156.   `type` tinyint(2) NOT NULL COMMENT '梯度配置类型(0-优惠包梯度 1-佣金包梯度)',
    157. 

  157.   `name` varchar(50) NOT NULL DEFAULT '' COMMENT '梯度名称',
    158. 

  158.   `left_value` decimal(12,4) DEFAULT '0.0000' COMMENT '梯度左边值',
    159. 

  159.   `right_value` decimal(12,4) DEFAULT '0.0000' COMMENT '梯度右边值',
    160. 

  160.   `sort` tinyint(2) NOT NULL DEFAULT '0' COMMENT '梯度排序',
    161. 

  161.   `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    162. 

  162.   `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    163. 

  163.   `deleted` tinyint(1) NOT NULL DEFAULT '0',
    164. 

  164.   PRIMARY KEY (`id`)
    165. 

  165. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='梯度配置表';
    166. 

  166. 

  167. -- 新增表lb_package_city_config
    168. 

  168. CREATE TABLE `lb_package_city_config` (
    169. 

  169. `id` BIGINT ( 20 ) NOT NULL AUTO_INCREMENT,
    170. 

  170. `package_type` TINYINT ( 2 ) NOT NULL COMMENT '包类型(0-运力包 1-优惠包 2-佣金包)',
    171. 

  171. `package_id` BIGINT ( 20 ) DEFAULT NULL COMMENT '包id',
    172. 

  172. `province_id` VARCHAR ( 11 ) DEFAULT NULL COMMENT '所在省',
    173. 

  173. `province_name` VARCHAR ( 255 ) DEFAULT NULL COMMENT '省名称',
    174. 

  174. `city_id` varchar(11) DEFAULT NULL COMMENT '市id',
    175. 

  175. `city_code` VARCHAR ( 10 ) DEFAULT NULL COMMENT '市code(为0时表示全国)',
    176. 

  176. `city_name` VARCHAR ( 255 ) DEFAULT NULL COMMENT '市名称',
    177. 

  177. `create_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    178. 

  178. `update_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    179. 

  179. `deleted` TINYINT ( 1 ) NOT NULL DEFAULT '0',
    180. 

  180. PRIMARY KEY ( `id` )
    181. 

  181. ) ENGINE = INNODB DEFAULT CHARSET = utf8mb4 COMMENT = '城市运力/优惠/佣金配置表';
    182. 

  182. 

  183. -- 门店表增加字段
    184. 

  184. ALTER TABLE `lb_shop` ADD COLUMN `package_delivery_id` bigint(20) DEFAULT NULL COMMENT '运力包id';
    185. 

  185. ALTER TABLE `lb_shop` ADD COLUMN `package_discount_id` bigint(20) DEFAULT NULL COMMENT '优惠包id';
    186. 

  186. ALTER TABLE `lb_shop` ADD COLUMN `package_commission_id` bigint(20) DEFAULT NULL COMMENT '佣金包id';
    187. 

  187. 

  188. -- 代理商表增加字段
    189. 

  189. ALTER TABLE `lb_agent` ADD COLUMN `package_discount_id` bigint(20) DEFAULT NULL COMMENT '优惠包id';
    190. 

  190. ALTER TABLE `lb_agent` ADD COLUMN `package_commission_id` bigint(20) DEFAULT NULL COMMENT '佣金包id';
    191. 

  191. -- 以上线上环境已执行
    192. 

  192. 

  193. 

  194. 

  195. 

  196. -- 数据初始化
    197. 

  197. -- 全国运力包
    198. 

  198. INSERT INTO `lb_delivery`.`lb_package_delivery`(`id`, `name`, `type`, `bill_duration_type`, `bill_duration_str`, `create_time`, `update_time`, `deleted`) VALUES (1, '全国运力包', 0, 0, NULL, '2021-11-24 16:18:43', '2021-11-24 16:18:55', 0);
    199. 

  199. INSERT INTO `lb_delivery`.`lb_package_delivery_detail`(`delivery_package_id`, `delivery_type`, `sort`, `create_time`, `update_time`, `deleted`) VALUES (1, 1, 0, '2021-11-24 16:18:55', '2021-11-24 16:18:55', 0);
    200. 

  200. INSERT INTO `lb_delivery`.`lb_package_delivery_detail`(`delivery_package_id`, `delivery_type`, `sort`, `create_time`, `update_time`, `deleted`) VALUES (1, 4, 0, '2021-11-24 16:18:55', '2021-11-24 16:18:55', 0);
    201. 

  201. INSERT INTO `lb_delivery`.`lb_package_delivery_detail`(`delivery_package_id`, `delivery_type`, `sort`, `create_time`, `update_time`, `deleted`) VALUES (1, 5, 0, '2021-11-24 16:18:55', '2021-11-24 16:18:55', 0);
    202. 

  202. INSERT INTO `lb_delivery`.`lb_package_delivery_detail`(`delivery_package_id`, `delivery_type`, `sort`, `create_time`, `update_time`, `deleted`) VALUES (1, 7, 0, '2021-11-24 16:18:55', '2021-11-24 16:18:55', 0);
    203. 

  203. INSERT INTO `lb_delivery`.`lb_package_delivery_detail`(`delivery_package_id`, `delivery_type`, `sort`, `create_time`, `update_time`, `deleted`) VALUES (1, 2, 0, '2021-11-24 16:18:55', '2021-11-24 16:18:55', 0);
    204. 

  204. INSERT INTO `lb_delivery`.`lb_package_delivery_detail`(`delivery_package_id`, `delivery_type`, `sort`, `create_time`, `update_time`, `deleted`) VALUES (1, 8, 0, '2021-11-24 16:18:55', '2021-11-24 16:18:55', 0);
    205. 

  205. INSERT INTO `lb_delivery`.`lb_package_delivery_detail`(`delivery_package_id`, `delivery_type`, `sort`, `create_time`, `update_time`, `deleted`) VALUES (1, 3, 0, '2021-11-24 16:18:55', '2021-11-24 16:18:55', 0);
    206. 

  206. INSERT INTO `lb_delivery`.`lb_package_delivery_detail`(`delivery_package_id`, `delivery_type`, `sort`, `create_time`, `update_time`, `deleted`) VALUES (1, 9, 0, '2021-11-24 16:18:55', '2021-11-24 16:18:55', 0);
    207. 

  207. INSERT INTO `lb_delivery`.`lb_package_delivery_detail`(`delivery_package_id`, `delivery_type`, `sort`, `create_time`, `update_time`, `deleted`) VALUES (1, 10, 0, '2021-11-24 16:18:55', '2021-11-24 16:18:55', 0);
    208. 

  208. INSERT INTO `lb_delivery`.`lb_package_delivery_detail`(`delivery_package_id`, `delivery_type`, `sort`, `create_time`, `update_time`, `deleted`) VALUES (1, 12, 0, '2021-11-24 16:18:55', '2021-11-24 16:18:55', 0);
    209. 

  209. INSERT INTO `lb_delivery`.`lb_package_delivery_detail`(`delivery_package_id`, `delivery_type`, `sort`, `create_time`, `update_time`, `deleted`) VALUES (1, 13, 0, '2021-11-24 16:18:55', '2021-11-24 16:18:55', 0);
    210. 

  210. -- 绑定全国运力包
    211. 

  211. INSERT INTO `lb_delivery`.`lb_package_city_config`(`package_type`, `package_id`, `province_id`, `province_name`, `city_id`, `city_code`, `city_name`, `create_time`, `update_time`, `deleted`) VALUES (0, 1, '', '', '', '0', '', '2021-11-24 16:18:55', '2021-11-24 16:18:55', 0);
    212. 

  212. 

  213. 

  214. -- 全国佣金包
    215. 

  215. INSERT INTO `lb_delivery`.`lb_package_commission`(`id`, `type`, `name`, `create_time`, `update_time`, `deleted`) VALUES (1, 0, '全国佣金包', '2021-11-24 16:21:53', '2021-11-24 16:21:53', 0);
    216. 

  216. INSERT INTO `lb_delivery`.`lb_package_commission_detail`(`commission_package_id`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `create_time`, `update_time`, `deleted`) VALUES (1, 1, NULL, NULL, 6.00, '2021-11-24 16:21:53', '2021-11-24 16:21:53', 0);
    217. 

  217. INSERT INTO `lb_delivery`.`lb_package_commission_detail`(`commission_package_id`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `create_time`, `update_time`, `deleted`) VALUES (1, 4, NULL, NULL, 6.00, '2021-11-24 16:21:53', '2021-11-24 16:21:53', 0);
    218. 

  218. INSERT INTO `lb_delivery`.`lb_package_commission_detail`(`commission_package_id`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `create_time`, `update_time`, `deleted`) VALUES (1, 5, NULL, NULL, 6.00, '2021-11-24 16:21:53', '2021-11-24 16:21:53', 0);
    219. 

  219. INSERT INTO `lb_delivery`.`lb_package_commission_detail`(`commission_package_id`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `create_time`, `update_time`, `deleted`) VALUES (1, 7, NULL, NULL, 6.00, '2021-11-24 16:21:53', '2021-11-24 16:21:53', 0);
    220. 

  220. INSERT INTO `lb_delivery`.`lb_package_commission_detail`(`commission_package_id`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `create_time`, `update_time`, `deleted`) VALUES (1, 2, NULL, NULL, 6.00, '2021-11-24 16:21:53', '2021-11-24 16:21:53', 0);
    221. 

  221. INSERT INTO `lb_delivery`.`lb_package_commission_detail`(`commission_package_id`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `create_time`, `update_time`, `deleted`) VALUES (1, 8, NULL, NULL, 6.00, '2021-11-24 16:21:53', '2021-11-24 16:21:53', 0);
    222. 

  222. INSERT INTO `lb_delivery`.`lb_package_commission_detail`(`commission_package_id`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `create_time`, `update_time`, `deleted`) VALUES (1, 3, NULL, NULL, 6.00, '2021-11-24 16:21:53', '2021-11-24 16:21:53', 0);
    223. 

  223. INSERT INTO `lb_delivery`.`lb_package_commission_detail`(`commission_package_id`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `create_time`, `update_time`, `deleted`) VALUES (1, 9, NULL, NULL, 6.00, '2021-11-24 16:21:53', '2021-11-24 16:21:53', 0);
    224. 

  224. INSERT INTO `lb_delivery`.`lb_package_commission_detail`(`commission_package_id`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `create_time`, `update_time`, `deleted`) VALUES (1, 10, NULL, NULL, 6.00, '2021-11-24 16:21:53', '2021-11-24 16:21:53', 0);
    225. 

  225. INSERT INTO `lb_delivery`.`lb_package_commission_detail`(`commission_package_id`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `create_time`, `update_time`, `deleted`) VALUES (1, 12, NULL, NULL, 6.00, '2021-11-24 16:21:53', '2021-11-24 16:21:53', 0);
    226. 

  226. INSERT INTO `lb_delivery`.`lb_package_commission_detail`(`commission_package_id`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `create_time`, `update_time`, `deleted`) VALUES (1, 13, NULL, NULL, 6.00, '2021-11-24 16:21:53', '2021-11-24 16:21:53', 0);
    227. 

  227. -- 绑定全国佣金包
    228. 

  228. INSERT INTO `lb_delivery`.`lb_package_city_config`(`package_type`, `package_id`, `province_id`, `province_name`, `city_id`, `city_code`, `city_name`, `create_time`, `update_time`, `deleted`) VALUES (2, 1, '', '', '', '0', '', '2021-11-24 16:21:53', '2021-11-24 16:21:53', 0);
    229. 

  229. 

  230. -- 全国优惠包
    231. 

  231. INSERT INTO `lb_delivery`.`lb_package_discount`(`id`, `name`, `create_time`, `update_time`, `deleted`) VALUES (1, '全国优惠包', '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    232. 

  232. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (1, 0, 1, NULL, NULL, 9.1500, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    233. 

  233. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (1, 0, 4, NULL, NULL, 9.1500, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    234. 

  234. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (1, 0, 5, NULL, NULL, 9.6000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    235. 

  235. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (1, 0, 7, NULL, NULL, 9.1500, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    236. 

  236. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (1, 0, 2, NULL, NULL, 9.1500, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    237. 

  237. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (1, 0, 8, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    238. 

  238. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (1, 0, 3, NULL, NULL, 9.1000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    239. 

  239. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (1, 0, 9, NULL, NULL, 9.1500, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    240. 

  240. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (1, 0, 10, NULL, NULL, 9.1000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    241. 

  241. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (1, 0, 12, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    242. 

  242. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (1, 0, 13, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    243. 

  243. -- 绑定全国优惠包
    244. 

  244. INSERT INTO `lb_delivery`.`lb_package_city_config`(`package_type`, `package_id`, `province_id`, `province_name`, `city_id`, `city_code`, `city_name`, `create_time`, `update_time`, `deleted`) VALUES (1, 1, '', '', '', '0', '', '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    245. 

  245. 

  246. 

  247. 

  248. -- 广州优惠包
    249. 

  249. INSERT INTO `lb_delivery`.`lb_package_discount`(`id`, `name`, `create_time`, `update_time`, `deleted`) VALUES (2, '广州优惠包', '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    250. 

  250. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (2, 0, 1, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    251. 

  251. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (2, 0, 4, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    252. 

  252. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (2, 0, 5, NULL, NULL, 9.6000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    253. 

  253. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (2, 0, 7, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    254. 

  254. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (2, 0, 2, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    255. 

  255. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (2, 0, 8, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    256. 

  256. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (2, 0, 3, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    257. 

  257. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (2, 0, 9, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    258. 

  258. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (2, 0, 10, NULL, NULL, 9.1000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    259. 

  259. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (2, 0, 12, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    260. 

  260. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (2, 0, 13, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    261. 

  261. 

  262. -- 惠州优惠包
    263. 

  263. INSERT INTO `lb_delivery`.`lb_package_discount`(`id`, `name`, `create_time`, `update_time`, `deleted`) VALUES (3, '惠州优惠包', '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    264. 

  264. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (3, 0, 1, NULL, NULL, 9.5000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    265. 

  265. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (3, 0, 4, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    266. 

  266. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (3, 0, 5, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    267. 

  267. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (3, 0, 7, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    268. 

  268. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (3, 0, 2, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    269. 

  269. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (3, 0, 8, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    270. 

  270. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (3, 0, 3, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    271. 

  271. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (3, 0, 9, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    272. 

  272. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (3, 0, 10, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    273. 

  273. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (3, 0, 12, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    274. 

  274. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (3, 0, 13, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    275. 

  275. 

  276. 

  277. -- 珠海运力包
    278. 

  278. INSERT INTO `lb_delivery`.`lb_package_discount`(`id`, `name`, `create_time`, `update_time`, `deleted`) VALUES (4, '珠海优惠包', '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    279. 

  279. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (4, 0, 1, NULL, NULL, 9.1500, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    280. 

  280. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (4, 0, 4, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    281. 

  281. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (4, 0, 5, NULL, NULL, 9.6000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    282. 

  282. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (4, 0, 7, NULL, NULL, 9.1500, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    283. 

  283. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (4, 0, 2, NULL, NULL, 9.1500, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    284. 

  284. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (4, 0, 8, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    285. 

  285. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (4, 0, 3, NULL, NULL, 9.1000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    286. 

  286. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (4, 0, 9, NULL, NULL, 9.1500, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    287. 

  287. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (4, 0, 10, NULL, NULL, 9.1000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    288. 

  288. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (4, 0, 12, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    289. 

  289. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (4, 0, 13, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    290. 

  290. 

  291. -- 大同运力包
    292. 

  292. INSERT INTO `lb_delivery`.`lb_package_discount`(`id`, `name`, `create_time`, `update_time`, `deleted`) VALUES (5, '大同优惠包', '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    293. 

  293. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (5, 0, 1, NULL, NULL, 9.5000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    294. 

  294. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (5, 0, 4, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    295. 

  295. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (5, 0, 5, NULL, NULL, 9.6000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    296. 

  296. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (5, 0, 7, NULL, NULL, 9.1500, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    297. 

  297. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (5, 0, 2, NULL, NULL, 9.1500, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    298. 

  298. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (5, 0, 8, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    299. 

  299. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (5, 0, 3, NULL, NULL, 9.1000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    300. 

  300. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (5, 0, 9, NULL, NULL, 9.1500, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    301. 

  301. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (5, 0, 10, NULL, NULL, 9.1000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    302. 

  302. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (5, 0, 12, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    303. 

  303. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (5, 0, 13, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    304. 

  304. 

  305. -- 淮安优惠包
    306. 

  306. INSERT INTO `lb_delivery`.`lb_package_discount`(`id`, `name`, `create_time`, `update_time`, `deleted`) VALUES (6, '淮安优惠包', '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    307. 

  307. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (6, 0, 1, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    308. 

  308. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (6, 0, 4, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    309. 

  309. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (6, 0, 5, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    310. 

  310. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (6, 0, 7, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    311. 

  311. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (6, 0, 2, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    312. 

  312. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (6, 0, 8, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    313. 

  313. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (6, 0, 3, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    314. 

  314. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (6, 0, 9, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    315. 

  315. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (6, 0, 10, NULL, NULL, 9.1000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    316. 

  316. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (6, 0, 12, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    317. 

  317. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (6, 0, 13, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    318. 

  318. 

  319. -- 泰州优惠包
    320. 

  320. INSERT INTO `lb_delivery`.`lb_package_discount`(`id`, `name`, `create_time`, `update_time`, `deleted`) VALUES (7, '泰州优惠包', '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    321. 

  321. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (7, 0, 1, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    322. 

  322. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (7, 0, 4, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    323. 

  323. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (7, 0, 5, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    324. 

  324. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (7, 0, 7, NULL, NULL, 9.1500, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    325. 

  325. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (7, 0, 2, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    326. 

  326. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (7, 0, 8, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    327. 

  327. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (7, 0, 3, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    328. 

  328. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (7, 0, 9, NULL, NULL, 9.1500, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    329. 

  329. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (7, 0, 10, NULL, NULL, 9.1000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    330. 

  330. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (7, 0, 12, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    331. 

  331. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (7, 0, 13, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    332. 

  332. 

  333. -- 上海优惠包
    334. 

  334. INSERT INTO `lb_delivery`.`lb_package_discount`(`id`, `name`, `create_time`, `update_time`, `deleted`) VALUES (8, '上海优惠包', '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    335. 

  335. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (8, 0, 1, NULL, NULL, 9.5000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    336. 

  336. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (8, 0, 4, NULL, NULL, 9.5000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    337. 

  337. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (8, 0, 5, NULL, NULL, 9.6000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    338. 

  338. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (8, 0, 7, NULL, NULL, 9.1500, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    339. 

  339. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (8, 0, 2, NULL, NULL, 9.5000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    340. 

  340. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (8, 0, 8, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    341. 

  341. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (8, 0, 3, NULL, NULL, 9.1000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    342. 

  342. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (8, 0, 9, NULL, NULL, 9.1500, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    343. 

  343. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (8, 0, 10, NULL, NULL, 9.1000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    344. 

  344. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (8, 0, 12, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    345. 

  345. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (8, 0, 13, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    346. 

  346. 

  347. -- 吉安优惠包
    348. 

  348. INSERT INTO `lb_delivery`.`lb_package_discount`(`id`, `name`, `create_time`, `update_time`, `deleted`) VALUES (9, '吉安优惠包', '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    349. 

  349. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (9, 0, 1, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    350. 

  350. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (9, 0, 4, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    351. 

  351. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (9, 0, 5, NULL, NULL, 9.6000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    352. 

  352. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (9, 0, 7, NULL, NULL, 9.1500, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    353. 

  353. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (9, 0, 2, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    354. 

  354. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (9, 0, 8, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    355. 

  355. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (9, 0, 3, NULL, NULL, 9.1000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    356. 

  356. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (9, 0, 9, NULL, NULL, 9.1500, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    357. 

  357. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (9, 0, 10, NULL, NULL, 9.1000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    358. 

  358. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (9, 0, 12, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    359. 

  359. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (9, 0, 13, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    360. 

  360. 

  361. -- 廊坊优惠包
    362. 

  362. INSERT INTO `lb_delivery`.`lb_package_discount`(`id`, `name`, `create_time`, `update_time`, `deleted`) VALUES (10, '廊坊优惠包', '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    363. 

  363. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (10, 0, 1, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    364. 

  364. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (10, 0, 4, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    365. 

  365. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (10, 0, 5, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    366. 

  366. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (10, 0, 7, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    367. 

  367. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (10, 0, 2, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    368. 

  368. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (10, 0, 8, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    369. 

  369. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (10, 0, 3, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    370. 

  370. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (10, 0, 9, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    371. 

  371. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (10, 0, 10, NULL, NULL, 9.1000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    372. 

  372. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (10, 0, 12, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    373. 

  373. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (10, 0, 13, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    374. 

  374. 

  375. -- 乌鲁木齐优惠包
    376. 

  376. INSERT INTO `lb_delivery`.`lb_package_discount`(`id`, `name`, `create_time`, `update_time`, `deleted`) VALUES (11, '乌鲁木齐优惠包', '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    377. 

  377. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (11, 0, 1, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    378. 

  378. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (11, 0, 4, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    379. 

  379. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (11, 0, 5, NULL, NULL, 9.6000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    380. 

  380. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (11, 0, 7, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    381. 

  381. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (11, 0, 2, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    382. 

  382. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (11, 0, 8, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    383. 

  383. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (11, 0, 3, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    384. 

  384. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (11, 0, 9, NULL, NULL, 9.1500, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    385. 

  385. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (11, 0, 10, NULL, NULL, 9.1000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    386. 

  386. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (11, 0, 12, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    387. 

  387. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (11, 0, 13, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    388. 

  388. 

  389. -- 马鞍山优惠包
    390. 

  390. INSERT INTO `lb_delivery`.`lb_package_discount`(`id`, `name`, `create_time`, `update_time`, `deleted`) VALUES (12, '马鞍山优惠包', '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    391. 

  391. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (12, 0, 1, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    392. 

  392. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (12, 0, 4, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    393. 

  393. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (12, 0, 5, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    394. 

  394. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (12, 0, 7, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    395. 

  395. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (12, 0, 2, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    396. 

  396. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (12, 0, 8, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    397. 

  397. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (12, 0, 3, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    398. 

  398. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (12, 0, 9, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    399. 

  399. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (12, 0, 10, NULL, NULL, 9.1000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    400. 

  400. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (12, 0, 12, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    401. 

  401. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (12, 0, 13, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    402. 

  402. 

  403. -- 呼和浩特优惠包
    404. 

  404. INSERT INTO `lb_delivery`.`lb_package_discount`(`id`, `name`, `create_time`, `update_time`, `deleted`) VALUES (13, '呼和浩特优惠包', '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    405. 

  405. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (13, 0, 1, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    406. 

  406. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (13, 0, 4, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    407. 

  407. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (13, 0, 5, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    408. 

  408. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (13, 0, 7, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    409. 

  409. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (13, 0, 2, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    410. 

  410. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (13, 0, 8, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    411. 

  411. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (13, 0, 3, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    412. 

  412. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (13, 0, 9, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    413. 

  413. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (13, 0, 10, NULL, NULL, 9.1000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    414. 

  414. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (13, 0, 12, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    415. 

  415. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (13, 0, 13, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    416. 

  416. 

  417. -- 东莞优惠包
    418. 

  418. INSERT INTO `lb_delivery`.`lb_package_discount`(`id`, `name`, `create_time`, `update_time`, `deleted`) VALUES (14, '东莞优惠包', '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    419. 

  419. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (14, 0, 1, NULL, NULL, 9.1500, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    420. 

  420. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (14, 0, 4, NULL, NULL, 9.1500, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    421. 

  421. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (14, 0, 5, NULL, NULL, 9.6000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    422. 

  422. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (14, 0, 7, NULL, NULL, 9.1500, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    423. 

  423. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (14, 0, 2, NULL, NULL, 9.1500, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    424. 

  424. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (14, 0, 8, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    425. 

  425. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (14, 0, 3, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    426. 

  426. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (14, 0, 9, NULL, NULL, 9.1500, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    427. 

  427. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (14, 0, 10, NULL, NULL, 9.1000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    428. 

  428. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (14, 0, 12, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    429. 

  429. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (14, 0, 13, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    430. 

  430. 

  431. -- 西安优惠包
    432. 

  432. INSERT INTO `lb_delivery`.`lb_package_discount`(`id`, `name`, `create_time`, `update_time`, `deleted`) VALUES (15, '西安优惠包', '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    433. 

  433. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (15, 0, 1, NULL, NULL, 9.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    434. 

  434. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (15, 0, 4, NULL, NULL, 9.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    435. 

  435. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (15, 0, 5, NULL, NULL, 9.5000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    436. 

  436. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (15, 0, 7, NULL, NULL, 9.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    437. 

  437. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (15, 0, 2, NULL, NULL, 9.1500, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    438. 

  438. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (15, 0, 8, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    439. 

  439. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (15, 0, 3, NULL, NULL, 9.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    440. 

  440. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (15, 0, 9, NULL, NULL, 9.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    441. 

  441. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (15, 0, 10, NULL, NULL, 9.5000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    442. 

  442. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (15, 0, 12, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    443. 

  443. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (15, 0, 13, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    444. 

  444. 

  445. 

  446. -- 菏泽优惠包
    447. 

  447. INSERT INTO `lb_delivery`.`lb_package_discount`(`id`, `name`, `create_time`, `update_time`, `deleted`) VALUES (16, '菏泽优惠包', '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    448. 

  448. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (16, 0, 1, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    449. 

  449. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (16, 0, 4, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    450. 

  450. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (16, 0, 5, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    451. 

  451. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (16, 0, 7, NULL, NULL, 9.1500, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    452. 

  452. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (16, 0, 2, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    453. 

  453. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (16, 0, 8, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    454. 

  454. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (16, 0, 3, NULL, NULL, 9.1000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    455. 

  455. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (16, 0, 9, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    456. 

  456. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (16, 0, 10, NULL, NULL, 9.1000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    457. 

  457. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (16, 0, 12, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    458. 

  458. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (16, 0, 13, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    459. 

  459. 

  460. -- 济南优惠包
    461. 

  461. INSERT INTO `lb_delivery`.`lb_package_discount`(`id`, `name`, `create_time`, `update_time`, `deleted`) VALUES (17, '济南优惠包', '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    462. 

  462. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (17, 0, 1, NULL, NULL, 9.5000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    463. 

  463. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (17, 0, 4, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    464. 

  464. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (17, 0, 5, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    465. 

  465. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (17, 0, 7, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    466. 

  466. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (17, 0, 2, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    467. 

  467. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (17, 0, 8, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    468. 

  468. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (17, 0, 3, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    469. 

  469. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (17, 0, 9, NULL, NULL, 9.5000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    470. 

  470. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (17, 0, 10, NULL, NULL, 9.1000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    471. 

  471. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (17, 0, 12, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    472. 

  472. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (17, 0, 13, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    473. 

  473. 

  474. 

  475. -- 青岛优惠包
    476. 

  476. INSERT INTO `lb_delivery`.`lb_package_discount`(`id`, `name`, `create_time`, `update_time`, `deleted`) VALUES (18, '青岛优惠包', '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    477. 

  477. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (18, 0, 1, NULL, NULL, 9.5000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    478. 

  478. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (18, 0, 4, NULL, NULL, 9.7000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    479. 

  479. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (18, 0, 5, NULL, NULL, 9.6000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    480. 

  480. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (18, 0, 7, NULL, NULL, 9.1500, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    481. 

  481. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (18, 0, 2, NULL, NULL, 9.1500, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    482. 

  482. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (18, 0, 8, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    483. 

  483. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (18, 0, 3, NULL, NULL, 9.1000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    484. 

  484. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (18, 0, 9, NULL, NULL, 9.5000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    485. 

  485. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (18, 0, 10, NULL, NULL, 9.1000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    486. 

  486. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (18, 0, 12, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    487. 

  487. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (18, 0, 13, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    488. 

  488. 

  489. -- 唐山优惠包
    490. 

  490. INSERT INTO `lb_delivery`.`lb_package_discount`(`id`, `name`, `create_time`, `update_time`, `deleted`) VALUES (19, '唐山优惠包', '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    491. 

  491. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (19, 0, 1, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    492. 

  492. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (19, 0, 4, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    493. 

  493. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (19, 0, 5, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    494. 

  494. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (19, 0, 7, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    495. 

  495. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (19, 0, 2, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    496. 

  496. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (19, 0, 8, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    497. 

  497. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (19, 0, 3, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    498. 

  498. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (19, 0, 9, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    499. 

  499. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (19, 0, 10, NULL, NULL, 9.1000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    500. 

  500. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (19, 0, 12, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    501. 

  501. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (19, 0, 13, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    502. 

  502. 

  503. -- 邢台优惠包
    504. 

  504. INSERT INTO `lb_delivery`.`lb_package_discount`(`id`, `name`, `create_time`, `update_time`, `deleted`) VALUES (20, '邢台优惠包', '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    505. 

  505. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (20, 0, 1, NULL, NULL, 9.5000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    506. 

  506. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (20, 0, 4, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    507. 

  507. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (20, 0, 5, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    508. 

  508. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (20, 0, 7, NULL, NULL, 9.1500, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    509. 

  509. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (20, 0, 2, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    510. 

  510. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (20, 0, 8, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    511. 

  511. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (20, 0, 3, NULL, NULL, 9.1000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    512. 

  512. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (20, 0, 9, NULL, NULL, 9.1500, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    513. 

  513. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (20, 0, 10, NULL, NULL, 9.1000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    514. 

  514. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (20, 0, 12, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    515. 

  515. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (20, 0, 13, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    516. 

  516. 

  517. -- 武汉优惠包
    518. 

  518. INSERT INTO `lb_delivery`.`lb_package_discount`(`id`, `name`, `create_time`, `update_time`, `deleted`) VALUES (21, '武汉优惠包', '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    519. 

  519. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (21, 0, 1, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    520. 

  520. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (21, 0, 4, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    521. 

  521. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (21, 0, 5, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    522. 

  522. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (21, 0, 7, NULL, NULL, 9.1500, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    523. 

  523. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (21, 0, 2, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    524. 

  524. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (21, 0, 8, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    525. 

  525. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (21, 0, 3, NULL, NULL, 9.1000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    526. 

  526. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (21, 0, 9, NULL, NULL, 9.1500, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    527. 

  527. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (21, 0, 10, NULL, NULL, 9.1000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    528. 

  528. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (21, 0, 12, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    529. 

  529. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (21, 0, 13, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    530. 

  530. 

  531. -- 南充优惠包
    532. 

  532. INSERT INTO `lb_delivery`.`lb_package_discount`(`id`, `name`, `create_time`, `update_time`, `deleted`) VALUES (22, '南充优惠包', '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    533. 

  533. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (22, 0, 1, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    534. 

  534. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (22, 0, 4, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    535. 

  535. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (22, 0, 5, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    536. 

  536. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (22, 0, 7, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    537. 

  537. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (22, 0, 2, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    538. 

  538. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (22, 0, 8, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    539. 

  539. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (22, 0, 3, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    540. 

  540. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (22, 0, 9, NULL, NULL, 9.1500, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    541. 

  541. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (22, 0, 10, NULL, NULL, 9.1000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    542. 

  542. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (22, 0, 12, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    543. 

  543. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (22, 0, 13, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    544. 

  544. 

  545. -- 厦门优惠包
    546. 

  546. INSERT INTO `lb_delivery`.`lb_package_discount`(`id`, `name`, `create_time`, `update_time`, `deleted`) VALUES (23, '厦门优惠包', '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    547. 

  547. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (23, 0, 1, NULL, NULL, 8.8000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    548. 

  548. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (23, 0, 4, NULL, NULL, 9.1500, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    549. 

  549. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (23, 0, 5, NULL, NULL, 9.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    550. 

  550. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (23, 0, 7, NULL, NULL, 9.1500, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    551. 

  551. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (23, 0, 2, NULL, NULL, 9.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    552. 

  552. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (23, 0, 8, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    553. 

  553. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (23, 0, 3, NULL, NULL, 9.1000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    554. 

  554. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (23, 0, 9, NULL, NULL, 8.8000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    555. 

  555. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (23, 0, 10, NULL, NULL, 9.1000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    556. 

  556. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (23, 0, 12, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    557. 

  557. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (23, 0, 13, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    558. 

  558. 

  559. -- 郑州优惠包
    560. 

  560. INSERT INTO `lb_delivery`.`lb_package_discount`(`id`, `name`, `create_time`, `update_time`, `deleted`) VALUES (24, '郑州优惠包', '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    561. 

  561. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (24, 0, 1, NULL, NULL, 9.1500, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    562. 

  562. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (24, 0, 4, NULL, NULL, 9.1500, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    563. 

  563. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (24, 0, 5, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    564. 

  564. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (24, 0, 7, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    565. 

  565. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (24, 0, 2, NULL, NULL, 9.1500, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    566. 

  566. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (24, 0, 8, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    567. 

  567. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (24, 0, 3, NULL, NULL, 9.1000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    568. 

  568. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (24, 0, 9, NULL, NULL, 9.1500, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    569. 

  569. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (24, 0, 10, NULL, NULL, 9.1000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    570. 

  570. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (24, 0, 12, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    571. 

  571. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (24, 0, 13, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    572. 

  572. 

  573. -- 昆明优惠包
    574. 

  574. INSERT INTO `lb_delivery`.`lb_package_discount`(`id`, `name`, `create_time`, `update_time`, `deleted`) VALUES (25, '昆明优惠包', '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    575. 

  575. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (25, 0, 1, NULL, NULL, 9.2000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    576. 

  576. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (25, 0, 4, NULL, NULL, 9.2500, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    577. 

  577. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (25, 0, 5, NULL, NULL, 9.6000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    578. 

  578. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (25, 0, 7, NULL, NULL, 9.3000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    579. 

  579. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (25, 0, 2, NULL, NULL, 9.2500, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    580. 

  580. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (25, 0, 8, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    581. 

  581. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (25, 0, 3, NULL, NULL, 9.1000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    582. 

  582. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (25, 0, 9, NULL, NULL, 9.2500, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    583. 

  583. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (25, 0, 10, NULL, NULL, 9.1000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    584. 

  584. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (25, 0, 12, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    585. 

  585. INSERT INTO `lb_delivery`.`lb_package_discount_detail`(`discount_package_id`, `type`, `delivery_type`, `gradient_id`, `gradient_name`, `value`, `max_value`, `create_time`, `update_time`, `deleted`) VALUES (25, 0, 13, NULL, NULL, 10.0000, 2.0000, '2021-11-24 16:59:18', '2021-11-24 16:59:18', 0);
    586. 

  586. 

  587. 

  588. -- 代理商绑定优惠包
    589. 

  589. update lb_agent set package_discount_id = 14 where id = 106;
    590. 

  590. update lb_agent set package_discount_id = 5 where id = 105;
    591. 

  591. update lb_agent set package_discount_id = 8 where id = 155;
    592. 

  592. update lb_agent set package_discount_id = 9 where id = 34;
    593. 

  593. update lb_agent set package_discount_id = 15 where id = 64;
    594. 

  594. update lb_agent set package_discount_id = 15 where id = 184;
    595. 

  595. update lb_agent set package_discount_id = 15 where id = 198;
    596. 

  596. update lb_agent set package_discount_id = 16 where id = 169;
    597. 

  597. update lb_agent set package_discount_id = 3 where id = 196;
    598. 

  598. update lb_agent set package_discount_id = 17 where id = 180;
    599. 

  599. update lb_agent set package_discount_id = 17 where id = 182;
    600. 

  600. update lb_agent set package_discount_id = 18 where id = 102;
    601. 

  601. update lb_agent set package_discount_id = 20 where id = 86;
    602. 

  602. update lb_agent set package_discount_id = 21 where id = 78;
    603. 

  603. update lb_agent set package_discount_id = 21 where id = 153;
    604. 

  604. update lb_agent set package_discount_id = 23 where id = 22;
    605. 

  605. update lb_agent set package_discount_id = 24 where id = 41;
    606. 

  606. update lb_agent set package_discount_id = 24 where id = 159;
    607. 

  607. update lb_agent set package_discount_id = 25 where id = 178;
    608. 

  608. update lb_agent set package_discount_id = 25 where id = 191;
    609. 

  609. update lb_agent set package_discount_id = 23 where id = 23;
    610. 

  610. update lb_agent set package_discount_id = 23 where id = 24;
    611. 

  611. update lb_agent set package_discount_id = 23 where id = 25;
    612. 

  612. update lb_agent set package_discount_id = 23 where id = 26;
    613. 

  613. update lb_agent set package_discount_id = 23 where id = 31;
    614. 

  614. update lb_agent set package_discount_id = 15 where id = 72;
    615. 

  615. update lb_agent set package_discount_id = 15 where id = 73;
    616. 

  616. update lb_agent set package_discount_id = 15 where id = 74;
    617. 

  617. update lb_agent set package_discount_id = 23 where id = 76;
    618. 

  618. update lb_agent set package_discount_id = 21 where id = 79;
    619. 

  619. update lb_agent set package_discount_id = 23 where id = 83;
    620. 

  620. update lb_agent set package_discount_id = 15 where id = 84;
    621. 

  621. update lb_agent set package_discount_id = 20 where id = 87;
    622. 

  622. update lb_agent set package_discount_id = 23 where id = 97;
    623. 

  623. update lb_agent set package_discount_id = 23 where id = 99;
    624. 

  624. update lb_agent set package_discount_id = 18 where id = 103;
    625. 

  625. update lb_agent set package_discount_id = 24 where id = 107;
    626. 

  626. update lb_agent set package_discount_id = 24 where id = 108;
    627. 

  627. update lb_agent set package_discount_id = 14 where id = 110;
    628. 

  628. update lb_agent set package_discount_id = 14 where id = 111;
    629. 

  629. update lb_agent set package_discount_id = 14 where id = 112;
    630. 

  630. update lb_agent set package_discount_id = 14 where id = 113;
    631. 

  631. update lb_agent set package_discount_id = 14 where id = 114;
    632. 

  632. update lb_agent set package_discount_id = 18 where id = 143;
    633. 

  633. update lb_agent set package_discount_id = 5 where id = 146;
    634. 

  634. update lb_agent set package_discount_id = 21 where id = 154;
    635. 

  635. update lb_agent set package_discount_id = 8 where id = 156;
    636. 

  636. update lb_agent set package_discount_id = 24 where id = 160;
    637. 

  637. update lb_agent set package_discount_id = 16 where id = 170;
    638. 

  638. update lb_agent set package_discount_id = 25 where id = 179;
    639. 

  639. update lb_agent set package_discount_id = 17 where id = 181;
    640. 

  640. update lb_agent set package_discount_id = 17 where id = 183;
    641. 

  641. update lb_agent set package_discount_id = 15 where id = 185;
    642. 

  642. update lb_agent set package_discount_id = 25 where id = 192;
    643. 

  643. update lb_agent set package_discount_id = 3 where id = 197;
    644. 

  644. update lb_agent set package_discount_id = 20 where id = 88;
    645. 

  645. update lb_agent set package_discount_id = 20 where id = 89;
    646. 

  646. 

  647. -- 20211202_delivery_opt 自运力绑定改造
    648. 

  648. CREATE TABLE `lb_shop_delivery_bind` (
    649. 

  649.   `id` int(11) NOT NULL AUTO_INCREMENT,
    650. 

  650.   `merchant_id` int(11) DEFAULT NULL COMMENT '商家ID',
    651. 

  651.   `shop_id` int(11) DEFAULT NULL COMMENT '门店ID(为空就表示该运力绑定为商户模式)',
    652. 

  652.   `delivery_id` int(11) DEFAULT NULL COMMENT '配送平台ID',
    653. 

  653.   `account` varchar(30) DEFAULT NULL COMMENT '配送登录账号(如果是达达则是商家在达达那边名称)',
    654. 

  654.   `balance` decimal(18,2) DEFAULT '0.00' COMMENT '配送平台余额',
    655. 

  655.   `bind_status` tinyint(2) DEFAULT NULL COMMENT '绑定状态：1->绑定，0：未绑定，2-> 审核中，3->拒绝，4->待完善资料',
    656. 

  656.   `third_shop_id` varchar(40) DEFAULT NULL COMMENT '三方门店ID',
    657. 

  657.   `dada_shop_no` varchar(40) DEFAULT NULL COMMENT '达达门店编号',
    658. 

  658.   `dada_yz_shop_no` varchar(40) DEFAULT NULL COMMENT '达达优质门店编号',
    659. 

  659.   `dada_bind_type` tinyint(2) DEFAULT '1' COMMENT '达达绑定方式(1-多门店模式 2-APP模式)',
    660. 

  660.   `auth_token` varchar(255) DEFAULT NULL COMMENT '商家授权token',
    661. 

  661.   `auth_msg` longtext COMMENT '授权原因/(或者：达达和顺丰失败原因)',
    662. 

  662.   `expires_in` bigint(20) DEFAULT NULL COMMENT '过期时间',
    663. 

  663.   `refresh_token` varchar(255) DEFAULT NULL COMMENT '刷新token',
    664. 

  664.    `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    665. 

  665.   `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
    666. 

  666.   `deleted` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '0：未删除，1：已删除',
    667. 

  667.   PRIMARY KEY (`id`) USING BTREE
    668. 

  668. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='商家绑定配送平台';
    669. 

  669. 

  670. -- 达达配送商相关 20220113已上线
    671. 

  671. DROP TABLE IF EXISTS `lb_package_freight`;
    672. 

  672. CREATE TABLE `lb_package_freight` (
    673. 

  673.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    674. 

  674.   `name` varchar(100) NOT NULL COMMENT '运费包名称',
    675. 

  675.   `dada_dsp_id` bigint(20) NOT NULL COMMENT '配送商id',
    676. 

  676.   `dimension` tinyint(3) NOT NULL DEFAULT '0' COMMENT '配送维度(0-通用 1-按商户 2-按门店)',
    677. 

  677.   `amount` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT '基础运费',
    678. 

  678.   `max_amount` decimal(12,4) DEFAULT NULL COMMENT '最高运费',
    679. 

  679.   `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    680. 

  680.   `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    681. 

  681.   `last_update_user` bigint(20) DEFAULT NULL COMMENT '最后修改用户id(sys_user)',
    682. 

  682.   `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除(0-未删除 1-删除)',
    683. 

  683.   PRIMARY KEY (`id`)
    684. 

  684. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='运费包';
    685. 

  685. 

  686. DROP TABLE IF EXISTS `lb_package_freight_distance`;
    687. 

  687. CREATE TABLE `lb_package_freight_distance` (
    688. 

  688.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    689. 

  689.   `freight_package_id` bigint(20) NOT NULL COMMENT '运费包主键id',
    690. 

  690.   `start_distance` decimal(12,2) DEFAULT NULL COMMENT '起始距离',
    691. 

  691.   `end_distance` decimal(12,2) DEFAULT NULL COMMENT '结束距离(默认无穷大)',
    692. 

  692.   `distance` decimal(12,2) DEFAULT NULL COMMENT '配置距离',
    693. 

  693.   `price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT '加价金额',
    694. 

  694.   `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    695. 

  695.   `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    696. 

  696.   `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除(0-未删除 1-删除)',
    697. 

  697.   PRIMARY KEY (`id`),
    698. 

  698.   KEY `idx_freight_package_id` (`freight_package_id`)
    699. 

  699. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='运费包距离加价配置';
    700. 

  700. 

  701. DROP TABLE IF EXISTS `lb_package_freight_weight`;
    702. 

  702. CREATE TABLE `lb_package_freight_weight` (
    703. 

  703.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    704. 

  704.   `freight_package_id` bigint(20) NOT NULL COMMENT '运费包主键id',
    705. 

  705.   `start_weight` decimal(12,2) DEFAULT NULL COMMENT '起始重量',
    706. 

  706.   `end_weight` decimal(12,2) DEFAULT NULL COMMENT '结束重量(默认无穷大)',
    707. 

  707.   `weight` decimal(12,2) DEFAULT NULL COMMENT '配置重量',
    708. 

  708.   `price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT '加价金额',
    709. 

  709.   `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    710. 

  710.   `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    711. 

  711.   `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除(0-未删除 1-删除)',
    712. 

  712.   PRIMARY KEY (`id`),
    713. 

  713.   KEY `idx_freight_package_id` (`freight_package_id`)
    714. 

  714. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='运费包重量加价配置';
    715. 

  715. 

  716. DROP TABLE IF EXISTS `lb_package_freight_money`;
    717. 

  717. CREATE TABLE `lb_package_freight_money` (
    718. 

  718.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    719. 

  719.   `freight_package_id` bigint(20) NOT NULL COMMENT '运费包主键id',
    720. 

  720.   `start_money` decimal(12,4) DEFAULT NULL COMMENT '起始商品金额',
    721. 

  721.   `end_money` decimal(12,4) DEFAULT NULL COMMENT '结束商品金额(默认无穷大)',
    722. 

  722.   `price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT '加价金额',
    723. 

  723.   `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    724. 

  724.   `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    725. 

  725.   `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除(0-未删除 1-删除)',
    726. 

  726.   PRIMARY KEY (`id`),
    727. 

  727.   KEY `idx_freight_package_id` (`freight_package_id`)
    728. 

  728. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='运费包商品金额加价配置';
    729. 

  729. 

  730. DROP TABLE IF EXISTS `lb_package_freight_time`;
    731. 

  731. CREATE TABLE `lb_package_freight_time` (
    732. 

  732.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    733. 

  733.   `freight_package_id` bigint(20) NOT NULL COMMENT '运费包主键id',
    734. 

  734.   `start_time` varchar(20) DEFAULT NULL COMMENT '起始时间段',
    735. 

  735.   `end_time` varchar(20) DEFAULT NULL COMMENT '结束时间段',
    736. 

  736.   `price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT '加价金额',
    737. 

  737.   `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    738. 

  738.   `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    739. 

  739.   `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除(0-未删除 1-删除)',
    740. 

  740.   PRIMARY KEY (`id`),
    741. 

  741.   KEY `idx_freight_package_id` (`freight_package_id`)
    742. 

  742. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='运费包时间段加价配置';
    743. 

  743. 

  744. DROP TABLE IF EXISTS `lb_package_freight_date`;
    745. 

  745. CREATE TABLE `lb_package_freight_date` (
    746. 

  746.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    747. 

  747.   `freight_package_id` bigint(20) NOT NULL COMMENT '运费包主键id',
    748. 

  748.   `start_date` date DEFAULT NULL COMMENT '起始日期',
    749. 

  749.   `end_date` date DEFAULT NULL COMMENT '结束日期',
    750. 

  750.   `price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT '加价金额',
    751. 

  751.   `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    752. 

  752.   `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    753. 

  753.   `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除(0-未删除 1-删除)',
    754. 

  754.   PRIMARY KEY (`id`),
    755. 

  755.   KEY `idx_freight_package_id` (`freight_package_id`)
    756. 

  756. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='运费包日期加价配置';
    757. 

  757. 

  758. DROP TABLE IF EXISTS `lb_package_freight_week`;
    759. 

  759. CREATE TABLE `lb_package_freight_week` (
    760. 

  760.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    761. 

  761.   `freight_package_id` bigint(20) NOT NULL COMMENT '运费包主键id',
    762. 

  762.   `week` int(7) DEFAULT NULL COMMENT '1->星期日，2->星期一，3->星期二，4->星期三，5->星期四，6->星期五，7->星期六',
    763. 

  763.   `price` decimal(12,1) NOT NULL DEFAULT '0.0' COMMENT '加价金额',
    764. 

  764.   `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    765. 

  765.   `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    766. 

  766.   `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除(0-未删除 1-删除)',
    767. 

  767.   PRIMARY KEY (`id`),
    768. 

  768.   KEY `idx_freight_package_id` (`freight_package_id`)
    769. 

  769. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='运费包每周加价配置';
    770. 

  770. 

  771. DROP TABLE IF EXISTS `lb_order_freight`;
    772. 

  772. CREATE TABLE `lb_order_freight` (
    773. 

  773.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    774. 

  774.   `order_id` bigint(20) NOT NULL COMMENT '订单id',
    775. 

  775.   `freight_package_id` bigint(20) NOT NULL COMMENT '运费包id',
    776. 

  776.   `amount` decimal(12,4) DEFAULT '0.0000' COMMENT '基础运费',
    777. 

  777.   `max_amount` decimal(12,4) DEFAULT '0.0000' COMMENT '下单时的运费包最高运费价(冗余字段)',
    778. 

  778.   `distance_add` decimal(12,4) DEFAULT '0.0000' COMMENT '距离加价',
    779. 

  779.   `weight_add` decimal(12,4) DEFAULT '0.0000' COMMENT '重量加价',
    780. 

  780.   `product_amount_add` decimal(12,4) DEFAULT '0.0000' COMMENT '商品金额加价',
    781. 

  781.   `time_add` decimal(12,4) DEFAULT '0.0000' COMMENT '时间段加价',
    782. 

  782.   `date_add` decimal(12,4) DEFAULT '0.0000' COMMENT '日期加价',
    783. 

  783.   `week_add` decimal(12,4) DEFAULT '0.0000' COMMENT '每周固定日加价',
    784. 

  784.   `delivery_amount` decimal(12,4) DEFAULT '0.0000' COMMENT '运费金额',
    785. 

  785.   `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    786. 

  786.   `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    787. 

  787.   `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除(0-未删除 1-删除)',
    788. 

  788.   PRIMARY KEY (`id`),
    789. 

  789.   KEY `idx_freight_package_id` (`freight_package_id`)
    790. 

  790. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='订单加价详情';
    791. 

  791. 

  792. DROP TABLE IF EXISTS `lb_dada_dsp`;
    793. 

  793. CREATE TABLE `lb_dada_dsp` (
    794. 

  794.   `id` bigint(20) NOT NULL AUTO_INCREMENT,
    795. 

  795.   `name` varchar(50) NOT NULL COMMENT '服务名称',
    796. 

  796.   `province_id` varchar(11) NOT NULL COMMENT '所在省',
    797. 

  797.   `city_id` varchar(11) NOT NULL COMMENT '所在城市',
    798. 

  798.   `district_id` varchar(2000) DEFAULT NULL COMMENT '所在区(多个以逗号拼接)',
    799. 

  799.   `province_name` varchar(255) DEFAULT NULL COMMENT '省名称',
    800. 

  800.   `city_name` varchar(255) DEFAULT NULL COMMENT '市名称',
    801. 

  801.   `district_name` varchar(255) DEFAULT NULL COMMENT '区名称(多个以逗号拼接)',
    802. 

  802.   `dsp_role` int(11) DEFAULT NULL COMMENT '服务商角色(0->自配送服务商 1->运费包服务商)',
    803. 

  803.   `contact_name` varchar(40) NOT NULL COMMENT '联系人',
    804. 

  804.   `mobile` varchar(15) NOT NULL COMMENT '联系手机',
    805. 

  805.   `address` varchar(255) DEFAULT NULL COMMENT '地址',
    806. 

  806.   `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    807. 

  807.   `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
    808. 

  808.   `deleted` tinyint(2) NOT NULL DEFAULT '0' COMMENT '删除标识位: 0正常 1删除',
    809. 

  809.   `status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '状态：1->正常，0->注销',
    810. 

  810.   `amount` decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT '服务商账户余额',
    811. 

  811.   `qr_code` varchar(100) DEFAULT NULL COMMENT '服务商二维码',
    812. 

  812.   `remark` varchar(255) DEFAULT NULL COMMENT '备注',
    813. 

  813.   `version` int(11) NOT NULL DEFAULT '0' COMMENT '乐观锁版本号',
    814. 

  814.   PRIMARY KEY (`id`) USING BTREE
    815. 

  815. ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='达达配送服务商';
    816. 

  816. -- 商户表增加字段
    817. 

  817. ALTER TABLE `lb_merchant` ADD COLUMN `dada_dsp_id` bigint(20) DEFAULT NULL COMMENT '达达配送服务商id';
    818. 

  818. ALTER TABLE `lb_merchant` ADD COLUMN `freight_package_id` bigint(20) DEFAULT NULL COMMENT '运费包id';
    819. 

  819. -- 用户表增加字段
    820. 

  820. ALTER TABLE `lb_member` ADD COLUMN `dada_dsp_id` bigint(20) DEFAULT NULL COMMENT '达达配送服务商id';
    821. 

  821. -- 系统用户表增加字段
    822. 

  822. ALTER TABLE `sys_user` ADD COLUMN `dada_dsp_id` bigint(20) DEFAULT NULL COMMENT '达达配送服务商id';
    823. 

  823. -- 门店表增加字段
    824. 

  824. ALTER TABLE `lb_shop` ADD COLUMN `freight_package_id` bigint(20) DEFAULT NULL COMMENT '运费包id';
    825. 

  825. -- 订单表增加字段
    826. 

  826. ALTER TABLE `lb_order` ADD COLUMN `dada_dsp_type` tinyint(2) DEFAULT NULL COMMENT '达达配送商类型(1-收付配送商 2-非收付配送商)';
    827. 

  827. ALTER TABLE `lb_order` ADD COLUMN `dada_dsp_id` bigint(20) DEFAULT NULL COMMENT '达达配送商id';
    828. 

  828. -- 分佣明细表增加字段
    829. 

  829. ALTER TABLE `lb_profits_detail` ADD COLUMN `dada_dsp_id` bigint(20) DEFAULT NULL COMMENT '达达配送服务商id';
    830. 

  830. -- 达达收付服务商服务费配置
    831. 

  831. INSERT INTO `sys_config` (`config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark` )
    832. 

  832. VALUES('达达收付配送商服务费(单位: 元)', 'dada_rap_fee', '0.1', 'N', 'admin', '2021-12-24 15:57:51', 'admin', '2022-01-05 13:43:00', '达达收付配送商, 服务费配置' );
    833. 

  833. -- 员工表
    834. 

  834. CREATE TABLE `lb_dada_dsp_personnel` (
    835. 

  835.   `id` bigint(20) NOT NULL  AUTO_INCREMENT,
    836. 

  836.   `name` varchar(50) NOT NULL COMMENT '员工名称',
    837. 

  837.   `mobile` varchar(15) NOT NULL COMMENT '联系手机',
    838. 

  838.   `dada_dsp_id` bigint(20) DEFAULT NULL COMMENT '代理商ID',
    839. 

  839.   `type` TINYINT(2) DEFAULT NULL COMMENT '员工账号类型(0-达达员工账号 1- 配送商员工账号)',
    840. 

  840.   `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    841. 

  841.   `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
    842. 

  842.   `deleted` tinyint(2) NOT NULL DEFAULT '0' COMMENT '删除标识位: 0正常 1删除',
    843. 

  843.   PRIMARY KEY (`id`),
    844. 

  844.   KEY `idx_dada_dsp_id` (`dada_dsp_id`) USING BTREE
    845. 

  845. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='配送商员工表';
    846. 

  846. -- 配送商银行卡表
    847. 

  847. CREATE TABLE `lb_dada_dsp_bank_card` (
    848. 

  848.   `id` bigint(20) NOT NULL AUTO_INCREMENT,
    849. 

  849.   `name` varchar(50) NOT NULL COMMENT '姓名',
    850. 

  850.   `card_no` varchar(100) NOT NULL COMMENT '银行卡号',
    851. 

  851.   `bank_name` varchar(255) NOT NULL COMMENT '开户行',
    852. 

  852.   `dada_dsp_id` bigint(20) DEFAULT NULL COMMENT '配送商id',
    853. 

  853.   `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    854. 

  854.   `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
    855. 

  855.   `deleted` tinyint(2) NOT NULL DEFAULT '0' COMMENT '删除标识位: 0正常 1删除',
    856. 

  856.   PRIMARY KEY (`id`),
    857. 

  857.   KEY `idx_dada_dsp_id` (`dada_dsp_id`) USING BTREE
    858. 

  858. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='配送商银行卡表';
    859. 

  859. -- 配送商提现申请
    860. 

  860. CREATE TABLE `lb_dada_dsp_withdrawal` (
    861. 

  861.   `id` bigint(20) NOT NULL AUTO_INCREMENT,
    862. 

  862.   `type` tinyint(2) DEFAULT NULL COMMENT '提现方式(0-支付宝 1-银行卡)',
    863. 

  863.   `status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '状态：1->结算入账，2->待处理，3->已同意，4 ->已拒绝',
    864. 

  864.   `amount` decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT '金额',
    865. 

  865.   `dada_dsp_id` bigint(20) NOT NULL COMMENT '配送商ID',
    866. 

  866.   `account` varchar(255) NOT NULL COMMENT '账号',
    867. 

  867.   `zfb_name` varchar(255) DEFAULT NULL COMMENT '支付宝姓名',
    868. 

  868.   `remark` varchar(255) DEFAULT NULL COMMENT '备注',
    869. 

  869.   `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    870. 

  870.   `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
    871. 

  871.   `deleted` tinyint(2) NOT NULL DEFAULT '0' COMMENT '删除标识位: 0正常 1删除',
    872. 

  872.   PRIMARY KEY (`id`) USING BTREE
    873. 

  873. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='配送商提现申请';
    874. 

  874. -- 配送商收益报表
    875. 

  875. CREATE TABLE `lb_profits_dada_dsp` (
    876. 

  876.   `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    877. 

  877.   `dada_dsp_id` int(11) NOT NULL COMMENT '达达配送商ID',
    878. 

  878.   `year` int(11) NOT NULL COMMENT '年份',
    879. 

  879.   `month` int(11) NOT NULL COMMENT '月份',
    880. 

  880.   `day` int(11) NOT NULL COMMENT '天',
    881. 

  881.   `total_order_num` int(11) NOT NULL DEFAULT '0' COMMENT '订单总数',
    882. 

  882.   `total_amount` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '收益总金额',
    883. 

  883.   `waimai_order_num` int(11) NOT NULL DEFAULT '0' COMMENT '外卖总订单数',
    884. 

  884.   `waimai_amount` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '外卖订单总金额',
    885. 

  885.   `delivery_order_num` int(11) NOT NULL DEFAULT '0' COMMENT '配送总订单数',
    886. 

  886.   `delivery_amount` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '配送订单总金额',
    887. 

  887.   `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    888. 

  888.   `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
    889. 

  889.   `delivery_commission` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '配送结算返佣总金额',
    890. 

  890.   `waimai_commission` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '外卖结算返佣总金额',
    891. 

  891.   `dada_amount` decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT '达达配送订单结算返佣金额',
    892. 

  892.   PRIMARY KEY (`id`) USING BTREE,
    893. 

  893. 	KEY `idx_dada_dsp_id` (`dada_dsp_id`) USING BTREE
    894. 

  894. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
    895. 

  895. -- 添加达达部门
    896. 

  896. INSERT INTO `sys_dept`(`dept_id`, `parent_id`, `ancestors`, `dept_name`, `order_num`, `leader`, `phone`, `email`, `status`, `del_flag`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (102, 0, '4', '达达', 2, '达达负责人', NULL, '', '0', '0', 'admin', '2021-01-17 15:42:41', '13681629065', '2021-12-15 15:10:30');
    897. 

  897. INSERT INTO `sys_dept`(`dept_id`, `parent_id`, `ancestors`, `dept_name`, `order_num`, `leader`, `phone`, `email`, `status`, `del_flag`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (110, 102, '4,102', '配送商', 2, NULL, NULL, NULL, '0', '0', 'admin', '2021-12-13 16:21:29', '', NULL);
    898. 

  898. -- 添加达达账号
    899. 

  899. INSERT INTO `sys_user`(`user_id`, `dept_id`, `user_name`, `nick_name`, `type`, `email`, `phonenumber`, `sex`, `avatar`, `password`, `status`, `del_flag`, `login_ip`, `login_date`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `agent_id`, `dsp_id`, `dada_dsp_id`) VALUES (346, 102, 'dada_admin', '达达总帐号', 3, '', '15092164909', '0', '', '$2a$10$CXStL6tVZNyiBwSR3rV1M.9upi9Qjv1mNFKVGtIGY9cLtxAuCoa7y', '0', '0', '', NULL, 'admin', '2021-12-15 16:10:21', 'admin', '2022-01-06 11:32:58', NULL, NULL, NULL, NULL);
    900. 

  900. -- 菜单管理
    901. 

  901. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2980, '达达提现管理', 2800, 3, '/dadaWithdrawal', 'module/dadaWithdrawal/index', 1, 0, 'C', '0', '0', NULL, '#', 'admin', '2022-01-10 16:39:31', '', NULL, '');
    902. 

  902. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2979, '门店详情', 2968, 2, 'dadaShop/info', 'module/dadaShop/info', 1, 0, 'C', '1', '0', '', '#', 'admin', '2021-12-30 20:03:15', 'admin', '2021-12-30 20:15:00', '');
    903. 

  903. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2978, '门店列表', 2968, 2, 'dadaShop/index', 'module/dadaShop/index', 1, 0, 'C', '0', '0', '', '#', 'admin', '2021-12-30 17:10:39', 'admin', '2021-12-30 17:11:39', '');
    904. 

  904. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2977, '收支明细', 2974, 3, '/accountDetailIndex', 'module/dadaAccountManagement/accountDetailIndex', 1, 0, 'C', '0', '0', '', '#', 'admin', '2021-12-29 14:39:30', 'admin', '2021-12-29 18:23:31', '');
    905. 

  905. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2976, '我的账户', 2974, 1, '/accountIndex', 'module/dadaAccountManagement/accountIndex', 1, 0, 'C', '0', '0', NULL, '#', 'admin', '2021-12-29 14:37:28', '', NULL, '');
    906. 

  906. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2975, '银行卡管理', 2974, 2, '/bankCardIndex', 'module/dadaAccountManagement/bankCardIndex', 1, 0, 'C', '0', '0', '', '#', 'admin', '2021-12-28 15:28:36', 'admin', '2021-12-29 14:37:45', '');
    907. 

  907. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2974, '账户管理', 0, 3, 'dadaAccountManagement', NULL, 1, 0, 'M', '0', '0', '', 'money', 'admin', '2021-12-28 15:25:53', 'admin', '2021-12-31 12:36:18', '');
    908. 

  908. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2973, '员工管理', 2966, 2, 'dadaDsp/personIndex', 'module/dadaDsp/personIndex', 1, 0, 'C', '0', '0', '', '#', 'admin', '2021-12-27 13:59:34', 'admin', '2021-12-27 14:00:40', '');
    909. 

  909. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2972, '配送订单(达达)', 2600, 1, 'dadaOrder', 'module/dadaOrder/index', 1, 0, 'C', '0', '0', 'module:dadaOrder:list', '#', 'admin', '2021-12-24 17:07:07', 'admin', '2021-12-31 12:36:44', '');
    910. 

  910. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2971, '商户详情', 2968, 1, 'dadaDspMerchant/info', 'module/dadaDspMerchant/info', 1, 0, 'C', '1', '0', '', '#', 'admin', '2021-12-24 09:41:36', 'admin', '2021-12-24 11:06:26', '');
    911. 

  911. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2970, '配送商详情', 2966, 1, 'dadaDsp/info', 'module/dadaDsp/info', 1, 1, 'C', '1', '0', 'module.dadaDsp.info', '#', 'admin', '2021-12-21 23:01:01', '', NULL, '');
    912. 

  912. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2969, '商家列表', 2968, 1, 'dadaDspMerchant/index', 'module/dadaDspMerchant/index', 1, 1, 'C', '0', '0', NULL, '#', 'admin', '2021-12-20 15:15:45', '', NULL, '');
    913. 

  913. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2968, '服务商户管理', 0, 2, 'dadaDspMerchant', NULL, 1, 0, 'M', '0', '0', '', 'documentation', 'admin', '2021-12-20 15:15:01', 'admin', '2021-12-31 12:40:45', '');
    914. 

  914. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2967, '配送商信息', 2966, 1, 'dadaDsp/index', 'module/dadaDsp/index', 1, 1, 'C', '0', '0', NULL, '#', 'admin', '2021-12-20 10:51:28', '', NULL, '');
    915. 

  915. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2966, '配送商管理', 0, 1, 'dadaDsp', NULL, 1, 0, 'M', '0', '0', '', 'guide', 'admin', '2021-12-20 10:50:37', 'admin', '2021-12-31 12:41:03', '');
    916. 

  916. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2965, '运费包配置', 2964, 1, 'dadaPackage/freight', 'module/dadaPackage/freight', 1, 1, 'C', '0', '0', '', '#', 'admin', '2021-12-13 10:11:56', 'admin', '2021-12-13 10:13:09', '');
    917. 

  917. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2964, '运费包', 0, 5, 'dadaPackage', NULL, 1, 0, 'M', '0', '0', '', 'table', 'admin', '2021-12-13 10:10:41', 'admin', '2021-12-31 12:40:06', '');
    918. 

  918. -- 添加角色
    919. 

  919. INSERT INTO `sys_role`(`role_id`, `role_name`, `role_key`, `role_sort`, `data_scope`, `menu_check_strictly`, `dept_check_strictly`, `status`, `del_flag`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (5, '达达', 'dada', 5, '2', 1, 1, '0', '0', 'admin', '2021-12-14 15:17:54', 'admin', '2022-01-04 11:22:57', NULL);
    920. 

  920. INSERT INTO `sys_role`(`role_id`, `role_name`, `role_key`, `role_sort`, `data_scope`, `menu_check_strictly`, `dept_check_strictly`, `status`, `del_flag`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (6, '配送服务商（收付）', 'dadaDeliveryRap', 6, '1', 1, 1, '0', '0', 'admin', '2021-12-14 16:08:58', 'admin', '2021-12-31 16:02:26', NULL);
    921. 

  921. INSERT INTO `sys_role`(`role_id`, `role_name`, `role_key`, `role_sort`, `data_scope`, `menu_check_strictly`, `dept_check_strictly`, `status`, `del_flag`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (7, '配送服务商', 'dadaDelivery', 7, '1', 1, 1, '0', '0', 'admin', '2021-12-20 14:04:46', 'admin', '2021-12-31 16:02:31', NULL);
    922. 

  922. INSERT INTO `sys_role`(`role_id`, `role_name`, `role_key`, `role_sort`, `data_scope`, `menu_check_strictly`, `dept_check_strictly`, `status`, `del_flag`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (8, '达达商户', 'dadaMerchant', 8, '1', 1, 1, '0', '0', 'admin', '2021-12-22 18:28:29', 'admin', '2021-12-24 17:08:55', NULL);
    923. 

  923. -- 添加角色部门
    924. 

  924. INSERT INTO `sys_role_dept`(`role_id`, `dept_id`) VALUES (5, 100);
    925. 

  925. INSERT INTO `sys_role_dept`(`role_id`, `dept_id`) VALUES (5, 101);
    926. 

  926. INSERT INTO `sys_role_dept`(`role_id`, `dept_id`) VALUES (5, 102);
    927. 

  927. INSERT INTO `sys_role_dept`(`role_id`, `dept_id`) VALUES (5, 110);
    928. 

  928. 

  929. 

  930. 

  931. -- 蜂鸟跑腿统计
    932. 

  932. -- ----------------------------
    933. 

  933. -- 渠道商统计字段添加
    934. 

  934. -- ----------------------------
    935. 

  935. ALTER TABLE lb_profits_dsp ADD COLUMN fengniao_pt_commission decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT '蜂鸟跑腿订单结算返佣金额';
    936. 

  936. ALTER TABLE lb_profits_dsp ADD COLUMN fengniao_pt_amount decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT '蜂鸟跑腿配送订单总金额';
    937. 

  937. ALTER TABLE lb_profits_dsp ADD COLUMN fengniao_pt_num int(11) NOT NULL DEFAULT '0' COMMENT '蜂鸟跑腿配送订单总笔数';
    938. 

  938. -- ----------------------------
    939. 

  939. -- 代理商统计字段添加
    940. 

  940. -- ----------------------------
    941. 

  941. ALTER TABLE lb_profits_agent ADD COLUMN fengniao_pt_amount decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT '蜂鸟跑腿配送订单结算返佣金额';
    942. 

  942. -- ----------------------------
    943. 

  943. -- 配送统计字段添加
    944. 

  944. -- ----------------------------
    945. 

  945. ALTER TABLE lb_profits_delivery ADD COLUMN fengniao_pt_amount decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT '蜂鸟跑腿配送订单总金额';
    946. 

  946. ALTER TABLE lb_profits_delivery ADD COLUMN fengniao_pt_num int(11) DEFAULT '0' COMMENT '蜂鸟跑腿配送订单总笔数';
    947. 

  947. -- ----------------------------
    948. 

  948. -- 商户统计字段添加
    949. 

  949. -- ----------------------------
    950. 

  950. ALTER TABLE lb_profits_merchant ADD COLUMN fengniao_pt_amount decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT '蜂鸟跑腿配送订单总金额';
    951. 

  951. ALTER TABLE lb_profits_merchant ADD COLUMN pt_num int(11) NOT NULL DEFAULT '0' COMMENT '蜂鸟跑腿配送订单总笔数';
    952. 

  952. 

  953. 

  954. -- 增加签名 20220304已上线
    955. 

  955. -- 应用信息
    956. 

  956. CREATE TABLE `lb_app_info` (
    957. 

  957.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    958. 

  958.   `name` varchar(100) NOT NULL COMMENT '应用名称',
    959. 

  959.   `app_id` varchar(50) NOT NULL COMMENT 'appId',
    960. 

  960.   `app_secret` varchar(50) NOT NULL COMMENT 'appSecret',
    961. 

  961.   `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    962. 

  962.   `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    963. 

  963.   `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除(0-未删除 1-删除)',
    964. 

  964.   PRIMARY KEY (`id`),
    965. 

  965.   KEY `idx_app_id` (`app_id`)
    966. 

  966. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='应用信息';
    967. 

  967. -- 初始化数据
    968. 

  968. INSERT INTO `lb_app_info` ( `id`, `name`, `app_id`, `app_secret`, `create_time`, `update_time`, `deleted` )
    969. 

  969. VALUES
    970. 

  970. 	( 1, '猎豹AI', 'lLaHTExpJyVg7jSM8', 'kRF7JyRXrUJMT2shJRXxd0x83uAp72ge', '2022-02-24 11:00:16', '2022-02-24 11:28:49', 0 );
    971. 

  971. INSERT INTO `lb_delivery`.`lb_app_info` ( `id`, `name`, `app_id`, `app_secret`, `create_time`, `update_time`, `deleted` )
    972. 

  972. VALUES
    973. 

  973. 	( 2, '山塘', '3zo8IAsv3pouuR7mi', 'Z87hWXtzxULewXqfVxdmjtBkdEUF3tvJ', '2022-02-24 11:30:33', '2022-02-24 11:30:33', 0 );
    974. 

  974. 

  975. 

  976. -- app新版本  20220309已上线
    977. 

  977. 

  978. -- 外卖预约单延迟配送表增加字段,延时时长(单位分钟)
    979. 

  979. ALTER TABLE `lb_order_delay` ADD COLUMN `delay_time_minute` int(11) DEFAULT 0 COMMENT '延时时长 单位分钟';
    980. 

  980. 

  981. -- 订单表增加平台类型、流水号、预约单提前发单时间
    982. 

  982. ALTER TABLE `lb_order` ADD COLUMN `platform_type` int(11) DEFAULT 0 COMMENT '平台类型,对应dsp_waimai的type(0-猎豹 1-美团 2-饿了么 3-饿百零售 5-美团闪购)';
    983. 

  983. ALTER TABLE `lb_order` ADD COLUMN `lb_day_seq` varchar (5) DEFAULT NULL COMMENT '猎豹生成的订单流水号';
    984. 

  984. ALTER TABLE `lb_order` ADD COLUMN `auto_delivery_minutes` int(11) DEFAULT 0 COMMENT '用户设置中预约单提前发单时间快照';
    985. 

  985. ALTER TABLE `lb_order` ADD COLUMN `send_street` varchar(200) DEFAULT NULL COMMENT '发件地址门牌号';
    986. 

  986. ALTER TABLE `lb_order` ADD COLUMN `receipt_street` varchar(200) DEFAULT NULL COMMENT '收件地址门牌号';
    987. 

  987. 

  988. -- 预约单开启自动配送、设置自动发起配送时间
    989. 

  989. ALTER TABLE `lb_member_config` ADD COLUMN `open_booking_autodelivery` tinyint(2) DEFAULT 0 COMMENT '预约单开启自动配送: 1->开启，0->关闭';
    990. 

  990. ALTER TABLE `lb_member_config` ADD COLUMN `booking_autodelivery_order_time` int(11) DEFAULT '1800' COMMENT '预约单自动配送时间(单位秒,默认30分钟,即距离用户期望送达时间30分钟时会自动发起配送)';
    991. 

  991. 

  992. -- 门店表增加POI地址字段
    993. 

  993. ALTER TABLE `lb_shop` ADD COLUMN `poi_address` varchar(255) DEFAULT NULL COMMENT 'POI地址';
    994. 

  994. 

  995. -- 物品信息表增加图片字段
    996. 

  996. ALTER TABLE `lb_product` ADD COLUMN `image` varchar(255) DEFAULT NULL COMMENT '物品图片';
    997. 

  997. UPDATE lb_product set image = 'https://ecloud-cdn.51sssd.com/20220225/4cb0aebce7e641589046c7cb2e1ae7d5.png' where id = 1;
    998. 

  998. UPDATE lb_product set image = 'https://ecloud-cdn.51sssd.com/20220225/a280e1d466ce4a5987221e4567cd5f0b.png' where id = 2;
    999. 

  999. UPDATE lb_product set image = 'https://ecloud-cdn.51sssd.com/20220225/f3737e0928e444648b1d2a1d1ad69c27.png' where id = 3;
    1000. 

  1000. UPDATE lb_product set image = 'https://ecloud-cdn.51sssd.com/20220225/23b07d48f5e14712b21aaff846730269.png' where id = 4;
    1001. 

  1001. UPDATE lb_product set image = 'https://ecloud-cdn.51sssd.com/20220225/8d42c31adc5f48c0b224363a2442c462.png' where id = 5;
    1002. 

  1002. UPDATE lb_product set image = 'https://ecloud-cdn.51sssd.com/20220225/a217b0262acf4175bfa7dd25f769e845.png' where id = 6;
    1003. 

  1003. UPDATE lb_product set image = 'https://ecloud-cdn.51sssd.com/20220225/9ee1ad8d88e948f8bd732541a4e3aba5.png' where id = 7;
    1004. 

  1004. UPDATE lb_product set image = 'https://ecloud-cdn.51sssd.com/20220225/214bb31c9c2b4335a090b0840ce95403.png' where id = 8;
    1005. 

  1005. UPDATE lb_product set image = 'https://ecloud-cdn.51sssd.com/20220225/ff2c659b61b04a6f9eb16216c1fb2a67.png' where id = 9;
    1006. 

  1006. UPDATE lb_product set image = 'https://ecloud-cdn.51sssd.com/20220225/72b3c96769ce49fab7feb145fffe5802.png' where id = 10;
    1007. 

  1007. UPDATE lb_product set image = 'https://ecloud-cdn.51sssd.com/20220225/cafdd12af34b47559ec0fddf5e9ece9f.png' where id = 11;
    1008. 

  1008. UPDATE lb_product set image = 'https://ecloud-cdn.51sssd.com/20220225/3922c811095043fb9eca762a7a7908f2.png' where id = 12;
    1009. 

  1009. 

  1010. 

  1011. -- app优化 20220327已上线
    1012. 

  1012. INSERT INTO `sys_config`(`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (17, '隐私号失效时长', 'PRIVATE_NUMBER_INVALID_TIME', '3', 'Y', 'admin', '2022-03-24 14:18:33', 'admin', '2022-03-24 14:42:41', NULL);
    1013. 

  1013. 

  1014. -- 后台权限控制 20220401已上线
    1015. 

  1015. CREATE TABLE `lb_sys_user_bind_agent` (
    1016. 

  1016.   `id` bigint(20) NOT NULL  AUTO_INCREMENT,
    1017. 

  1017.   `user_id` bigint(20) NOT NULL COMMENT '用户id(sys_user表主键)',
    1018. 

  1018.   `agent_id` varchar(1000) DEFAULT NULL COMMENT '关联的代理商id,多个用英文逗号分割',
    1019. 

  1019.   `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    1020. 

  1020.   `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
    1021. 

  1021.   `deleted` tinyint(2) NOT NULL DEFAULT '0' COMMENT '删除标识位: 0正常 1删除',
    1022. 

  1022.   PRIMARY KEY (`id`),
    1023. 

  1023.   KEY `idx_user_id` (`user_id`) USING BTREE
    1024. 

  1024. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='员工关联代理商表';
    1025. 

  1025. 

  1026. -- 达达配送商 20220401已上线
    1027. 

  1027. ALTER TABLE lb_dada_dsp ADD COLUMN open_qr_code tinyint(2) DEFAULT '0' COMMENT '打印二维码：1->打印，0->不打印';
    1028. 

  1028. 

  1029. ALTER TABLE lb_merchant ADD COLUMN open_qr_code tinyint(2) DEFAULT '0' COMMENT '打印二维码：1->打印，0->不打印';
    1030. 

  1030. 

  1031. ALTER TABLE lb_dada_dsp_withdrawal ADD COLUMN before_amount decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT '提现前金额';
    1032. 

  1032. 

  1033. ALTER TABLE lb_dada_dsp_withdrawal ADD COLUMN after_amount decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT '提现后金额';
    1034.