

alter table `lb_member` add column  `agent_source`  tinyint(4) DEFAULT NULL COMMENT '代理商来源：1->直属  2->邀请';
alter table `lb_order` add column  `agent_Id`  int(11) DEFAULT NULL COMMENT '代理商ID';
alter table `lb_order` add column  `agent_Id_source` tinyint(4) DEFAULT NULL COMMENT '代理商来源： 1->直属  2->邀请 3->区域';

CREATE TABLE `lb_profits_detail` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL COMMENT '订单id',
  `order_pay_amount` decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT '订单支付金额',
  `agent_id` int(11) DEFAULT NULL COMMENT '参与分佣代理商ID',
  `agent_Id_source` tinyint(4) DEFAULT NULL COMMENT '代理商来源： 1->直属  2->邀请 3->区域 4-> 间接',
  `dsp_id` int(11) DEFAULT NULL COMMENT '参与分佣渠道ID',
  `order_type` int(11) DEFAULT '0' COMMENT '1->外卖订单  2->配送订单',
  `amount` decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT '参与分佣总金额',
  `commission` decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT '收益金额',
  `source` int(11) DEFAULT '0' COMMENT '分佣来源:1->自己分钱记录  2->上级分钱记录',
  `rate` decimal(11,2) DEFAULT NULL COMMENT '佣金比例(百分比)',
  `delivery_type` int(11) DEFAULT '0' COMMENT '配送类型:参照DeliveryTypeEnums枚举',
  `delivery_name` varchar(30) DEFAULT NULL COMMENT '配送平台名称',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` tinyint(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='代理商/渠道分佣明细';



-------------------------------04-25
alter table `lb_coupon` add column  `member_recive_num` int(11) DEFAULT '1' COMMENT '用户领取数量';


-------------------------------0506
alter table `lb_shop` add column  `biz_license`  varchar(255) DEFAULT NULL COMMENT '营业执照';
alter table `lb_shop` add column  `biz_license_no`  varchar(30) DEFAULT NULL COMMENT '营业执照号码';
alter table `lb_shop` add column  `legal_person`  varchar(20) DEFAULT NULL COMMENT '法人姓名';
alter table `lb_shop` add column  `idcard_no`  varchar(20) DEFAULT NULL COMMENT '身份证号码';
alter table `lb_shop` add column  `idcard_front`  varchar(255) DEFAULT NULL COMMENT '法人身份证正面照片';
alter table `lb_shop` add column  `idcard_back`  varchar(255) DEFAULT NULL COMMENT '法人身份证反面照片';
alter table `lb_shop` add column  `biz_license_idcard`  varchar(255) DEFAULT NULL COMMENT '门店拥有人手持身份证、营业执照图片(蜂鸟)';

ALTER TABLE `lb_member_balance_log`
ADD COLUMN `merchant_id`  int NULL AFTER `deleted`;
alter table `lb_profits_detail` add column  `is_source`  tinyint(2) NOT NULL DEFAULT '0' COMMENT '0->正式数据  1->测试数据';

-- local.sql
alter table `lb_order_delivery` add column  `commission`  decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '佣金';
alter table `lb_order_delivery` add column  `is_mine`  int(11) DEFAULT '2' COMMENT '支付使用的平台 0->猎豹平台，1->自己运力平台，2->未知';
alter table `lb_order_delivery` add column  `origin_amount`  decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '原始支付金额';
alter table `lb_order_delivery` add column  `hll_status` int(11) DEFAULT NULL COMMENT '货拉拉订单状态';
alter table `lb_profits_detail` add column  `origin_source` tinyint(2) NOT NULL DEFAULT '0' COMMENT '来源：1->第三方支付订单，0->平台支付订单';
alter table `lb_profits_detail` add column  `type` tinyint(2) NOT NULL DEFAULT '0' COMMENT '分佣固定类型：1->金额，0->比例';

-- 20211014_billing.sql
ALTER TABLE `lb_order` ADD COLUMN `save_flag` tinyint(1) DEFAULT 0 COMMENT '手动发单保存标识(普通预约单手动发单此字段有效 0-非预约发单保存 1-预约发单保存)' AFTER `cancel_type`;
ALTER TABLE `lb_order` ADD COLUMN `invoice_title` varchar(255) DEFAULT NULL COMMENT '发票抬头' AFTER `cancel_type`;
ALTER TABLE `lb_order` ADD COLUMN `taxpayer_id` varchar(255) DEFAULT NULL COMMENT '发票税号' AFTER `cancel_type`;

-- 20211028_account.sql
ALTER TABLE `lb_member_balance_log` ADD COLUMN `payment_type` tinyint(2) DEFAULT NULL COMMENT '支付类型：1->支付宝支付 2->微信支付 3->银联支付 4->余额支付 5->三方运力支付' AFTER `order_id`;
ALTER TABLE `lb_member_config` ADD COLUMN `show_food_img` tinyint(1) DEFAULT 1 COMMENT '是否显示商品图片: 1->显示，0->不显示' AFTER `shield_delivery_ids`;

-- 20211108_print_opt.sql
ALTER TABLE `lb_shop_device` ADD COLUMN `width` int(11) DEFAULT '0' COMMENT '打印小票宽度(毫米)' AFTER `status`;
INSERT INTO `lb_device` (`name`,`img`,`type`,`remark`,`price`,`url`,
`app_id`,`app_secert`,`sort`,`is_hot`,`status`)
VALUES('USB打印机','',99,NULL,'0.00',NULL,NULL,NULL,0,0,1);

-- 20211119 shop表增加是否打印二维码字段
ALTER TABLE `lb_shop` ADD COLUMN `open_qr_code` tinyint(2) DEFAULT '0' COMMENT '打印二维码：1->打印，0->不打印';


-- feature/20211112_valuation_opt分支, 20211125已上线
-- 佣金包
CREATE TABLE `lb_package_commission` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `type` tinyint(2) NOT NULL DEFAULT '0' COMMENT '佣金包类型(0-比例  1-梯度增减)',
  `name` varchar(100) NOT NULL DEFAULT '' COMMENT '佣金包名称',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除(0-未删除 1-删除)',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='佣金包';

-- 佣金包明细
CREATE TABLE `lb_package_commission_detail` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `commission_package_id` bigint(20) NOT NULL COMMENT '佣金包主键id',
  `delivery_type` int(5) NOT NULL COMMENT '运力类型',
  `gradient_id` bigint(20) DEFAULT NULL COMMENT '梯度id',
  `gradient_name` varchar(50) DEFAULT NULL COMMENT '梯度名称',
  `value` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '值(比例或者金额)',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除(0-未删除 1-删除)',
  PRIMARY KEY (`id`),
  KEY `idx_commission_package_id` (`commission_package_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='佣金包明细';

-- 运力包
CREATE TABLE `lb_package_delivery` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(100) NOT NULL DEFAULT '' COMMENT '运力包名称',
  `type` tinyint(2) NOT NULL DEFAULT '0' COMMENT '运力包类型(0-价格优先  1-自定义)',
  `bill_duration_type` tinyint(2) NOT NULL COMMENT '发单时间类型(0-默认 1-自定义)',
  `bill_duration_str` varchar(255) DEFAULT '' COMMENT '发单时长(单位秒, 多个用逗号分隔)',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除(0-未删除 1-删除)',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='运力包';

-- 运力包明细
CREATE TABLE `lb_package_delivery_detail` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `delivery_package_id` bigint(20) NOT NULL COMMENT '运力包主键id',
  `delivery_type` int(5) NOT NULL COMMENT '运力类型',
  `sort` int(11) NOT NULL DEFAULT '0' COMMENT '运力排序',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除(0-未删除 1-删除)',
  PRIMARY KEY (`id`),
  KEY `idx_delivery_package_id` (`delivery_package_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='运力包明细';

-- 优惠包
CREATE TABLE `lb_package_discount` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(100) NOT NULL DEFAULT '' COMMENT '优惠包名称',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除(0-未删除 1-删除)',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='优惠包';

-- 优惠包明细
CREATE TABLE `lb_package_discount_detail` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `discount_package_id` bigint(20) NOT NULL COMMENT '优惠包主键id',
  `type` tinyint(2) NOT NULL DEFAULT '0' COMMENT '优惠包类型(0-折扣  1-梯度增减)',
  `delivery_type` int(5) NOT NULL COMMENT '运力类型',
  `gradient_id` bigint(20) DEFAULT NULL COMMENT '梯度id(type为1时此字段有效)',
  `gradient_name` varchar(50) DEFAULT NULL COMMENT '梯度名称(冗余,type为1时此字段有效)',
  `value` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT '值(折扣或者金额)',
  `max_value` decimal(12,4) DEFAULT '0.0000' COMMENT '峰值(type为0时此字段有效)',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除(0-未删除 1-删除)',
  PRIMARY KEY (`id`),
  KEY `idx_discount_package_id` (`discount_package_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='优惠包明细';

-- 优惠包配置表
CREATE TABLE `lb_package_gradient_config` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `type` tinyint(2) NOT NULL COMMENT '梯度配置类型(0-优惠包梯度 1-佣金包梯度)',
  `name` varchar(50) NOT NULL DEFAULT '' COMMENT '梯度名称',
  `left_value` decimal(12,4) DEFAULT '0.0000' COMMENT '梯度左边值',
  `right_value` decimal(12,4) DEFAULT '0.0000' COMMENT '梯度右边值',
  `sort` tinyint(2) NOT NULL DEFAULT '0' COMMENT '梯度排序',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='梯度配置表';

-- 新增表lb_package_city_config
CREATE TABLE `lb_package_city_config` (
`id` BIGINT ( 20 ) NOT NULL AUTO_INCREMENT,
`package_type` TINYINT ( 2 ) NOT NULL COMMENT '包类型(0-运力包 1-优惠包 2-佣金包)',
`package_id` BIGINT ( 20 ) DEFAULT NULL COMMENT '包id',
`province_id` VARCHAR ( 11 ) DEFAULT NULL COMMENT '所在省',
`province_name` VARCHAR ( 255 ) DEFAULT NULL COMMENT '省名称',
`city_id` varchar(11) DEFAULT NULL COMMENT '市id',
`city_code` VARCHAR ( 10 ) DEFAULT NULL COMMENT '市code(为0时表示全国)',
`city_name` VARCHAR ( 255 ) DEFAULT NULL COMMENT '市名称',
`create_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`update_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`deleted` TINYINT ( 1 ) NOT NULL DEFAULT '0',
PRIMARY KEY ( `id` )
) ENGINE = INNODB DEFAULT CHARSET = utf8mb4 COMMENT = '城市运力/优惠/佣金配置表';

-- 门店表增加字段
ALTER TABLE `lb_shop` ADD COLUMN `package_delivery_id` bigint(20) DEFAULT NULL COMMENT '运力包id';
ALTER TABLE `lb_shop` ADD COLUMN `package_discount_id` bigint(20) DEFAULT NULL COMMENT '优惠包id';
ALTER TABLE `lb_shop` ADD COLUMN `package_commission_id` bigint(20) DEFAULT NULL COMMENT '佣金包id';

-- 代理商表增加字段
ALTER TABLE `lb_agent` ADD COLUMN `package_discount_id` bigint(20) DEFAULT NULL COMMENT '优惠包id';
ALTER TABLE `lb_agent` ADD COLUMN `package_commission_id` bigint(20) DEFAULT NULL COMMENT '佣金包id';
-- 以上线上环境已执行




-- 数据初始化
-- 全国运力包
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
-- 绑定全国运力包
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);


-- 全国佣金包
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
-- 绑定全国佣金包
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);

-- 全国优惠包
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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
-- 绑定全国优惠包
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);



-- 广州优惠包
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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);

-- 惠州优惠包
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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);


-- 珠海运力包
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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);

-- 大同运力包
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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);

-- 淮安优惠包
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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);

-- 泰州优惠包
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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);

-- 上海优惠包
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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);

-- 吉安优惠包
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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);

-- 廊坊优惠包
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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);

-- 乌鲁木齐优惠包
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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);

-- 马鞍山优惠包
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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);

-- 呼和浩特优惠包
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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);

-- 东莞优惠包
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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);

-- 西安优惠包
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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);


-- 菏泽优惠包
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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);

-- 济南优惠包
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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);


-- 青岛优惠包
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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);

-- 唐山优惠包
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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);

-- 邢台优惠包
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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);

-- 武汉优惠包
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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);

-- 南充优惠包
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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);

-- 厦门优惠包
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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);

-- 郑州优惠包
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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);

-- 昆明优惠包
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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);
INSERT INTO `lb_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);


-- 代理商绑定优惠包
update lb_agent set package_discount_id = 14 where id = 106;
update lb_agent set package_discount_id = 5 where id = 105;
update lb_agent set package_discount_id = 8 where id = 155;
update lb_agent set package_discount_id = 9 where id = 34;
update lb_agent set package_discount_id = 15 where id = 64;
update lb_agent set package_discount_id = 15 where id = 184;
update lb_agent set package_discount_id = 15 where id = 198;
update lb_agent set package_discount_id = 16 where id = 169;
update lb_agent set package_discount_id = 3 where id = 196;
update lb_agent set package_discount_id = 17 where id = 180;
update lb_agent set package_discount_id = 17 where id = 182;
update lb_agent set package_discount_id = 18 where id = 102;
update lb_agent set package_discount_id = 20 where id = 86;
update lb_agent set package_discount_id = 21 where id = 78;
update lb_agent set package_discount_id = 21 where id = 153;
update lb_agent set package_discount_id = 23 where id = 22;
update lb_agent set package_discount_id = 24 where id = 41;
update lb_agent set package_discount_id = 24 where id = 159;
update lb_agent set package_discount_id = 25 where id = 178;
update lb_agent set package_discount_id = 25 where id = 191;
update lb_agent set package_discount_id = 23 where id = 23;
update lb_agent set package_discount_id = 23 where id = 24;
update lb_agent set package_discount_id = 23 where id = 25;
update lb_agent set package_discount_id = 23 where id = 26;
update lb_agent set package_discount_id = 23 where id = 31;
update lb_agent set package_discount_id = 15 where id = 72;
update lb_agent set package_discount_id = 15 where id = 73;
update lb_agent set package_discount_id = 15 where id = 74;
update lb_agent set package_discount_id = 23 where id = 76;
update lb_agent set package_discount_id = 21 where id = 79;
update lb_agent set package_discount_id = 23 where id = 83;
update lb_agent set package_discount_id = 15 where id = 84;
update lb_agent set package_discount_id = 20 where id = 87;
update lb_agent set package_discount_id = 23 where id = 97;
update lb_agent set package_discount_id = 23 where id = 99;
update lb_agent set package_discount_id = 18 where id = 103;
update lb_agent set package_discount_id = 24 where id = 107;
update lb_agent set package_discount_id = 24 where id = 108;
update lb_agent set package_discount_id = 14 where id = 110;
update lb_agent set package_discount_id = 14 where id = 111;
update lb_agent set package_discount_id = 14 where id = 112;
update lb_agent set package_discount_id = 14 where id = 113;
update lb_agent set package_discount_id = 14 where id = 114;
update lb_agent set package_discount_id = 18 where id = 143;
update lb_agent set package_discount_id = 5 where id = 146;
update lb_agent set package_discount_id = 21 where id = 154;
update lb_agent set package_discount_id = 8 where id = 156;
update lb_agent set package_discount_id = 24 where id = 160;
update lb_agent set package_discount_id = 16 where id = 170;
update lb_agent set package_discount_id = 25 where id = 179;
update lb_agent set package_discount_id = 17 where id = 181;
update lb_agent set package_discount_id = 17 where id = 183;
update lb_agent set package_discount_id = 15 where id = 185;
update lb_agent set package_discount_id = 25 where id = 192;
update lb_agent set package_discount_id = 3 where id = 197;
update lb_agent set package_discount_id = 20 where id = 88;
update lb_agent set package_discount_id = 20 where id = 89;

-- 20211202_delivery_opt 自运力绑定改造
CREATE TABLE `lb_shop_delivery_bind` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `merchant_id` int(11) DEFAULT NULL COMMENT '商家ID',
  `shop_id` int(11) DEFAULT NULL COMMENT '门店ID(为空就表示该运力绑定为商户模式)',
  `delivery_id` int(11) DEFAULT NULL COMMENT '配送平台ID',
  `account` varchar(30) DEFAULT NULL COMMENT '配送登录账号(如果是达达则是商家在达达那边名称)',
  `balance` decimal(18,2) DEFAULT '0.00' COMMENT '配送平台余额',
  `bind_status` tinyint(2) DEFAULT NULL COMMENT '绑定状态：1->绑定，0：未绑定，2-> 审核中，3->拒绝，4->待完善资料',
  `third_shop_id` varchar(40) DEFAULT NULL COMMENT '三方门店ID',
  `dada_shop_no` varchar(40) DEFAULT NULL COMMENT '达达门店编号',
  `dada_yz_shop_no` varchar(40) DEFAULT NULL COMMENT '达达优质门店编号',
  `dada_bind_type` tinyint(2) DEFAULT '1' COMMENT '达达绑定方式(1-多门店模式 2-APP模式)',
  `auth_token` varchar(255) DEFAULT NULL COMMENT '商家授权token',
  `auth_msg` longtext COMMENT '授权原因/(或者：达达和顺丰失败原因)',
  `expires_in` bigint(20) DEFAULT NULL COMMENT '过期时间',
  `refresh_token` varchar(255) DEFAULT NULL COMMENT '刷新token',
   `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  `deleted` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '0：未删除，1：已删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='商家绑定配送平台';

-- 达达配送商相关 20220113已上线
DROP TABLE IF EXISTS `lb_package_freight`;
CREATE TABLE `lb_package_freight` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(100) NOT NULL COMMENT '运费包名称',
  `dada_dsp_id` bigint(20) NOT NULL COMMENT '配送商id',
  `dimension` tinyint(3) NOT NULL DEFAULT '0' COMMENT '配送维度(0-通用 1-按商户 2-按门店)',
  `amount` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT '基础运费',
  `max_amount` decimal(12,4) DEFAULT NULL COMMENT '最高运费',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `last_update_user` bigint(20) DEFAULT NULL COMMENT '最后修改用户id(sys_user)',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除(0-未删除 1-删除)',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='运费包';

DROP TABLE IF EXISTS `lb_package_freight_distance`;
CREATE TABLE `lb_package_freight_distance` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `freight_package_id` bigint(20) NOT NULL COMMENT '运费包主键id',
  `start_distance` decimal(12,2) DEFAULT NULL COMMENT '起始距离',
  `end_distance` decimal(12,2) DEFAULT NULL COMMENT '结束距离(默认无穷大)',
  `distance` decimal(12,2) DEFAULT NULL COMMENT '配置距离',
  `price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT '加价金额',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除(0-未删除 1-删除)',
  PRIMARY KEY (`id`),
  KEY `idx_freight_package_id` (`freight_package_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='运费包距离加价配置';

DROP TABLE IF EXISTS `lb_package_freight_weight`;
CREATE TABLE `lb_package_freight_weight` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `freight_package_id` bigint(20) NOT NULL COMMENT '运费包主键id',
  `start_weight` decimal(12,2) DEFAULT NULL COMMENT '起始重量',
  `end_weight` decimal(12,2) DEFAULT NULL COMMENT '结束重量(默认无穷大)',
  `weight` decimal(12,2) DEFAULT NULL COMMENT '配置重量',
  `price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT '加价金额',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除(0-未删除 1-删除)',
  PRIMARY KEY (`id`),
  KEY `idx_freight_package_id` (`freight_package_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='运费包重量加价配置';

DROP TABLE IF EXISTS `lb_package_freight_money`;
CREATE TABLE `lb_package_freight_money` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `freight_package_id` bigint(20) NOT NULL COMMENT '运费包主键id',
  `start_money` decimal(12,4) DEFAULT NULL COMMENT '起始商品金额',
  `end_money` decimal(12,4) DEFAULT NULL COMMENT '结束商品金额(默认无穷大)',
  `price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT '加价金额',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除(0-未删除 1-删除)',
  PRIMARY KEY (`id`),
  KEY `idx_freight_package_id` (`freight_package_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='运费包商品金额加价配置';

DROP TABLE IF EXISTS `lb_package_freight_time`;
CREATE TABLE `lb_package_freight_time` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `freight_package_id` bigint(20) NOT NULL COMMENT '运费包主键id',
  `start_time` varchar(20) DEFAULT NULL COMMENT '起始时间段',
  `end_time` varchar(20) DEFAULT NULL COMMENT '结束时间段',
  `price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT '加价金额',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除(0-未删除 1-删除)',
  PRIMARY KEY (`id`),
  KEY `idx_freight_package_id` (`freight_package_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='运费包时间段加价配置';

DROP TABLE IF EXISTS `lb_package_freight_date`;
CREATE TABLE `lb_package_freight_date` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `freight_package_id` bigint(20) NOT NULL COMMENT '运费包主键id',
  `start_date` date DEFAULT NULL COMMENT '起始日期',
  `end_date` date DEFAULT NULL COMMENT '结束日期',
  `price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT '加价金额',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除(0-未删除 1-删除)',
  PRIMARY KEY (`id`),
  KEY `idx_freight_package_id` (`freight_package_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='运费包日期加价配置';

DROP TABLE IF EXISTS `lb_package_freight_week`;
CREATE TABLE `lb_package_freight_week` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `freight_package_id` bigint(20) NOT NULL COMMENT '运费包主键id',
  `week` int(7) DEFAULT NULL COMMENT '1->星期日，2->星期一，3->星期二，4->星期三，5->星期四，6->星期五，7->星期六',
  `price` decimal(12,1) NOT NULL DEFAULT '0.0' COMMENT '加价金额',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除(0-未删除 1-删除)',
  PRIMARY KEY (`id`),
  KEY `idx_freight_package_id` (`freight_package_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='运费包每周加价配置';

DROP TABLE IF EXISTS `lb_order_freight`;
CREATE TABLE `lb_order_freight` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `order_id` bigint(20) NOT NULL COMMENT '订单id',
  `freight_package_id` bigint(20) NOT NULL COMMENT '运费包id',
  `amount` decimal(12,4) DEFAULT '0.0000' COMMENT '基础运费',
  `max_amount` decimal(12,4) DEFAULT '0.0000' COMMENT '下单时的运费包最高运费价(冗余字段)',
  `distance_add` decimal(12,4) DEFAULT '0.0000' COMMENT '距离加价',
  `weight_add` decimal(12,4) DEFAULT '0.0000' COMMENT '重量加价',
  `product_amount_add` decimal(12,4) DEFAULT '0.0000' COMMENT '商品金额加价',
  `time_add` decimal(12,4) DEFAULT '0.0000' COMMENT '时间段加价',
  `date_add` decimal(12,4) DEFAULT '0.0000' COMMENT '日期加价',
  `week_add` decimal(12,4) DEFAULT '0.0000' COMMENT '每周固定日加价',
  `delivery_amount` decimal(12,4) DEFAULT '0.0000' COMMENT '运费金额',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除(0-未删除 1-删除)',
  PRIMARY KEY (`id`),
  KEY `idx_freight_package_id` (`freight_package_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='订单加价详情';

DROP TABLE IF EXISTS `lb_dada_dsp`;
CREATE TABLE `lb_dada_dsp` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL COMMENT '服务名称',
  `province_id` varchar(11) NOT NULL COMMENT '所在省',
  `city_id` varchar(11) NOT NULL COMMENT '所在城市',
  `district_id` varchar(2000) DEFAULT NULL COMMENT '所在区(多个以逗号拼接)',
  `province_name` varchar(255) DEFAULT NULL COMMENT '省名称',
  `city_name` varchar(255) DEFAULT NULL COMMENT '市名称',
  `district_name` varchar(255) DEFAULT NULL COMMENT '区名称(多个以逗号拼接)',
  `dsp_role` int(11) DEFAULT NULL COMMENT '服务商角色(0->自配送服务商 1->运费包服务商)',
  `contact_name` varchar(40) NOT NULL COMMENT '联系人',
  `mobile` varchar(15) NOT NULL COMMENT '联系手机',
  `address` varchar(255) DEFAULT NULL COMMENT '地址',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` tinyint(2) NOT NULL DEFAULT '0' COMMENT '删除标识位: 0正常 1删除',
  `status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '状态：1->正常，0->注销',
  `amount` decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT '服务商账户余额',
  `qr_code` varchar(100) DEFAULT NULL COMMENT '服务商二维码',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `version` int(11) NOT NULL DEFAULT '0' COMMENT '乐观锁版本号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='达达配送服务商';
-- 商户表增加字段
ALTER TABLE `lb_merchant` ADD COLUMN `dada_dsp_id` bigint(20) DEFAULT NULL COMMENT '达达配送服务商id';
ALTER TABLE `lb_merchant` ADD COLUMN `freight_package_id` bigint(20) DEFAULT NULL COMMENT '运费包id';
-- 用户表增加字段
ALTER TABLE `lb_member` ADD COLUMN `dada_dsp_id` bigint(20) DEFAULT NULL COMMENT '达达配送服务商id';
-- 系统用户表增加字段
ALTER TABLE `sys_user` ADD COLUMN `dada_dsp_id` bigint(20) DEFAULT NULL COMMENT '达达配送服务商id';
-- 门店表增加字段
ALTER TABLE `lb_shop` ADD COLUMN `freight_package_id` bigint(20) DEFAULT NULL COMMENT '运费包id';
-- 订单表增加字段
ALTER TABLE `lb_order` ADD COLUMN `dada_dsp_type` tinyint(2) DEFAULT NULL COMMENT '达达配送商类型(1-收付配送商 2-非收付配送商)';
ALTER TABLE `lb_order` ADD COLUMN `dada_dsp_id` bigint(20) DEFAULT NULL COMMENT '达达配送商id';
-- 分佣明细表增加字段
ALTER TABLE `lb_profits_detail` ADD COLUMN `dada_dsp_id` bigint(20) DEFAULT NULL COMMENT '达达配送服务商id';
-- 达达收付服务商服务费配置
INSERT INTO `sys_config` (`config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark` )
VALUES('达达收付配送商服务费(单位: 元)', 'dada_rap_fee', '0.1', 'N', 'admin', '2021-12-24 15:57:51', 'admin', '2022-01-05 13:43:00', '达达收付配送商, 服务费配置' );
-- 员工表
CREATE TABLE `lb_dada_dsp_personnel` (
  `id` bigint(20) NOT NULL  AUTO_INCREMENT,
  `name` varchar(50) NOT NULL COMMENT '员工名称',
  `mobile` varchar(15) NOT NULL COMMENT '联系手机',
  `dada_dsp_id` bigint(20) DEFAULT NULL COMMENT '代理商ID',
  `type` TINYINT(2) DEFAULT NULL COMMENT '员工账号类型(0-达达员工账号 1- 配送商员工账号)',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` tinyint(2) NOT NULL DEFAULT '0' COMMENT '删除标识位: 0正常 1删除',
  PRIMARY KEY (`id`),
  KEY `idx_dada_dsp_id` (`dada_dsp_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='配送商员工表';
-- 配送商银行卡表
CREATE TABLE `lb_dada_dsp_bank_card` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL COMMENT '姓名',
  `card_no` varchar(100) NOT NULL COMMENT '银行卡号',
  `bank_name` varchar(255) NOT NULL COMMENT '开户行',
  `dada_dsp_id` bigint(20) DEFAULT NULL COMMENT '配送商id',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` tinyint(2) NOT NULL DEFAULT '0' COMMENT '删除标识位: 0正常 1删除',
  PRIMARY KEY (`id`),
  KEY `idx_dada_dsp_id` (`dada_dsp_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='配送商银行卡表';
-- 配送商提现申请
CREATE TABLE `lb_dada_dsp_withdrawal` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `type` tinyint(2) DEFAULT NULL COMMENT '提现方式(0-支付宝 1-银行卡)',
  `status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '状态：1->结算入账，2->待处理，3->已同意，4 ->已拒绝',
  `amount` decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT '金额',
  `dada_dsp_id` bigint(20) NOT NULL COMMENT '配送商ID',
  `account` varchar(255) NOT NULL COMMENT '账号',
  `zfb_name` varchar(255) DEFAULT NULL COMMENT '支付宝姓名',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` tinyint(2) NOT NULL DEFAULT '0' COMMENT '删除标识位: 0正常 1删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='配送商提现申请';
-- 配送商收益报表
CREATE TABLE `lb_profits_dada_dsp` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `dada_dsp_id` int(11) NOT NULL COMMENT '达达配送商ID',
  `year` int(11) NOT NULL COMMENT '年份',
  `month` int(11) NOT NULL COMMENT '月份',
  `day` int(11) NOT NULL COMMENT '天',
  `total_order_num` int(11) NOT NULL DEFAULT '0' COMMENT '订单总数',
  `total_amount` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '收益总金额',
  `waimai_order_num` int(11) NOT NULL DEFAULT '0' COMMENT '外卖总订单数',
  `waimai_amount` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '外卖订单总金额',
  `delivery_order_num` int(11) NOT NULL DEFAULT '0' COMMENT '配送总订单数',
  `delivery_amount` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '配送订单总金额',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `delivery_commission` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '配送结算返佣总金额',
  `waimai_commission` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '外卖结算返佣总金额',
  `dada_amount` decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT '达达配送订单结算返佣金额',
  PRIMARY KEY (`id`) USING BTREE,
	KEY `idx_dada_dsp_id` (`dada_dsp_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- 添加达达部门
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');
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);
-- 添加达达账号
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);
-- 菜单管理
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, '');
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', '');
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', '');
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', '');
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, '');
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', '');
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', '');
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', '');
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', '');
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', '');
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, '');
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, '');
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', '');
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, '');
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', '');
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', '');
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', '');
-- 添加角色
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);
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);
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);
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);
-- 添加角色部门
INSERT INTO `sys_role_dept`(`role_id`, `dept_id`) VALUES (5, 100);
INSERT INTO `sys_role_dept`(`role_id`, `dept_id`) VALUES (5, 101);
INSERT INTO `sys_role_dept`(`role_id`, `dept_id`) VALUES (5, 102);
INSERT INTO `sys_role_dept`(`role_id`, `dept_id`) VALUES (5, 110);



-- 蜂鸟跑腿统计
-- ----------------------------
-- 渠道商统计字段添加
-- ----------------------------
ALTER TABLE lb_profits_dsp ADD COLUMN fengniao_pt_commission decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT '蜂鸟跑腿订单结算返佣金额';
ALTER TABLE lb_profits_dsp ADD COLUMN fengniao_pt_amount decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT '蜂鸟跑腿配送订单总金额';
ALTER TABLE lb_profits_dsp ADD COLUMN fengniao_pt_num int(11) NOT NULL DEFAULT '0' COMMENT '蜂鸟跑腿配送订单总笔数';
-- ----------------------------
-- 代理商统计字段添加
-- ----------------------------
ALTER TABLE lb_profits_agent ADD COLUMN fengniao_pt_amount decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT '蜂鸟跑腿配送订单结算返佣金额';
-- ----------------------------
-- 配送统计字段添加
-- ----------------------------
ALTER TABLE lb_profits_delivery ADD COLUMN fengniao_pt_amount decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT '蜂鸟跑腿配送订单总金额';
ALTER TABLE lb_profits_delivery ADD COLUMN fengniao_pt_num int(11) DEFAULT '0' COMMENT '蜂鸟跑腿配送订单总笔数';
-- ----------------------------
-- 商户统计字段添加
-- ----------------------------
ALTER TABLE lb_profits_merchant ADD COLUMN fengniao_pt_amount decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT '蜂鸟跑腿配送订单总金额';
ALTER TABLE lb_profits_merchant ADD COLUMN pt_num int(11) NOT NULL DEFAULT '0' COMMENT '蜂鸟跑腿配送订单总笔数';


-- 增加签名 20220304已上线
-- 应用信息
CREATE TABLE `lb_app_info` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(100) NOT NULL COMMENT '应用名称',
  `app_id` varchar(50) NOT NULL COMMENT 'appId',
  `app_secret` varchar(50) NOT NULL COMMENT 'appSecret',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除(0-未删除 1-删除)',
  PRIMARY KEY (`id`),
  KEY `idx_app_id` (`app_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='应用信息';
-- 初始化数据
INSERT INTO `lb_app_info` ( `id`, `name`, `app_id`, `app_secret`, `create_time`, `update_time`, `deleted` )
VALUES
	( 1, '猎豹AI', 'lLaHTExpJyVg7jSM8', 'kRF7JyRXrUJMT2shJRXxd0x83uAp72ge', '2022-02-24 11:00:16', '2022-02-24 11:28:49', 0 );
INSERT INTO `lb_delivery`.`lb_app_info` ( `id`, `name`, `app_id`, `app_secret`, `create_time`, `update_time`, `deleted` )
VALUES
	( 2, '山塘', '3zo8IAsv3pouuR7mi', 'Z87hWXtzxULewXqfVxdmjtBkdEUF3tvJ', '2022-02-24 11:30:33', '2022-02-24 11:30:33', 0 );


-- app新版本  20220309已上线

-- 外卖预约单延迟配送表增加字段,延时时长(单位分钟)
ALTER TABLE `lb_order_delay` ADD COLUMN `delay_time_minute` int(11) DEFAULT 0 COMMENT '延时时长 单位分钟';

-- 订单表增加平台类型、流水号、预约单提前发单时间
ALTER TABLE `lb_order` ADD COLUMN `platform_type` int(11) DEFAULT 0 COMMENT '平台类型,对应dsp_waimai的type(0-猎豹 1-美团 2-饿了么 3-饿百零售 5-美团闪购)';
ALTER TABLE `lb_order` ADD COLUMN `lb_day_seq` varchar (5) DEFAULT NULL COMMENT '猎豹生成的订单流水号';
ALTER TABLE `lb_order` ADD COLUMN `auto_delivery_minutes` int(11) DEFAULT 0 COMMENT '用户设置中预约单提前发单时间快照';
ALTER TABLE `lb_order` ADD COLUMN `send_street` varchar(200) DEFAULT NULL COMMENT '发件地址门牌号';
ALTER TABLE `lb_order` ADD COLUMN `receipt_street` varchar(200) DEFAULT NULL COMMENT '收件地址门牌号';

-- 预约单开启自动配送、设置自动发起配送时间
ALTER TABLE `lb_member_config` ADD COLUMN `open_booking_autodelivery` tinyint(2) DEFAULT 0 COMMENT '预约单开启自动配送: 1->开启，0->关闭';
ALTER TABLE `lb_member_config` ADD COLUMN `booking_autodelivery_order_time` int(11) DEFAULT '1800' COMMENT '预约单自动配送时间(单位秒,默认30分钟,即距离用户期望送达时间30分钟时会自动发起配送)';

-- 门店表增加POI地址字段
ALTER TABLE `lb_shop` ADD COLUMN `poi_address` varchar(255) DEFAULT NULL COMMENT 'POI地址';

-- 物品信息表增加图片字段
ALTER TABLE `lb_product` ADD COLUMN `image` varchar(255) DEFAULT NULL COMMENT '物品图片';
UPDATE lb_product set image = 'https://ecloud-cdn.51sssd.com/20220225/4cb0aebce7e641589046c7cb2e1ae7d5.png' where id = 1;
UPDATE lb_product set image = 'https://ecloud-cdn.51sssd.com/20220225/a280e1d466ce4a5987221e4567cd5f0b.png' where id = 2;
UPDATE lb_product set image = 'https://ecloud-cdn.51sssd.com/20220225/f3737e0928e444648b1d2a1d1ad69c27.png' where id = 3;
UPDATE lb_product set image = 'https://ecloud-cdn.51sssd.com/20220225/23b07d48f5e14712b21aaff846730269.png' where id = 4;
UPDATE lb_product set image = 'https://ecloud-cdn.51sssd.com/20220225/8d42c31adc5f48c0b224363a2442c462.png' where id = 5;
UPDATE lb_product set image = 'https://ecloud-cdn.51sssd.com/20220225/a217b0262acf4175bfa7dd25f769e845.png' where id = 6;
UPDATE lb_product set image = 'https://ecloud-cdn.51sssd.com/20220225/9ee1ad8d88e948f8bd732541a4e3aba5.png' where id = 7;
UPDATE lb_product set image = 'https://ecloud-cdn.51sssd.com/20220225/214bb31c9c2b4335a090b0840ce95403.png' where id = 8;
UPDATE lb_product set image = 'https://ecloud-cdn.51sssd.com/20220225/ff2c659b61b04a6f9eb16216c1fb2a67.png' where id = 9;
UPDATE lb_product set image = 'https://ecloud-cdn.51sssd.com/20220225/72b3c96769ce49fab7feb145fffe5802.png' where id = 10;
UPDATE lb_product set image = 'https://ecloud-cdn.51sssd.com/20220225/cafdd12af34b47559ec0fddf5e9ece9f.png' where id = 11;
UPDATE lb_product set image = 'https://ecloud-cdn.51sssd.com/20220225/3922c811095043fb9eca762a7a7908f2.png' where id = 12;


-- app优化 20220327已上线
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);