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); -- 后台权限控制 20220401已上线 CREATE TABLE `lb_sys_user_bind_agent` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `user_id` bigint(20) NOT NULL COMMENT '用户id(sys_user表主键)', `agent_id` varchar(1000) 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_user_id` (`user_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='员工关联代理商表'; -- 达达配送商 20220401已上线 ALTER TABLE lb_dada_dsp ADD COLUMN open_qr_code tinyint(2) DEFAULT '0' COMMENT '打印二维码：1->打印，0->不打印'; ALTER TABLE lb_merchant ADD COLUMN open_qr_code tinyint(2) DEFAULT '0' COMMENT '打印二维码：1->打印，0->不打印'; ALTER TABLE lb_dada_dsp_withdrawal ADD COLUMN before_amount decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT '提现前金额'; ALTER TABLE lb_dada_dsp_withdrawal ADD COLUMN after_amount decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT '提现后金额';