ALTER TABLE `system_app_access` ADD `supplier_pic_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '门店海报';

ALTER TABLE `shop_goods` MODIFY COLUMN `pay_number`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '{"type":"0","number":"0"}' COMMENT '最低购买数量' AFTER `pay_end_time`;
ALTER TABLE `shop_goods` CHANGE `is_preheat` `is_preheat` INT(8) NOT NULL DEFAULT '0' COMMENT '是否预热商品 0=false 其他=预热活动id'; 
ALTER TABLE `shop_goods` CHANGE `look` `look` INT(10) NOT NULL DEFAULT '0' COMMENT '查看量'; 
UPDATE `system_diy_express_template` SET `delete_time` = '1602552663' WHERE ( `id` = '1' or `id` = '3' or `id` = '4' or `id` = '5' or `id` = '7' ); 
UPDATE `shop_diy_express_template` SET `delete_time` = '1602552663' WHERE ( `system_express_template_id` = '1' or `system_express_template_id` = '3' or `system_express_template_id` = '4' or `system_express_template_id` = '5' or `system_express_template_id` = '7' ); 
CREATE TABLE `shop_preheat` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `merchant_id` int(8) NOT NULL,
  `title` varchar(100) NOT NULL,
  `start_time` int(11) NOT NULL,
  `end_time` int(11) NOT NULL,
  `goods_id` longtext NOT NULL,
  `status` int(1) NOT NULL,
  `create_time` int(11) NOT NULL,
  `update_time` int(11) DEFAULT NULL,
  `delete_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
ALTER TABLE `shop_goods` ADD COLUMN `is_preheat`  tinyint(8) NOT NULL DEFAULT 0 COMMENT '是否预热商品 0=false 其他=预热活动id' AFTER `is_advance_sale`;
ALTER TABLE `system_app_access` ADD COLUMN `category_view`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '分类样式 0 横排 1 大图' AFTER `is_show_online_service`;
ALTER TABLE `system_app_access` ADD COLUMN `cancel_order`  int(4) NOT NULL DEFAULT 1440 COMMENT '分钟取消订单' AFTER `open_advertisement`;
ALTER TABLE `system_app_access` ADD COLUMN `sold`  int(1) NOT NULL DEFAULT 0 COMMENT '商品销量 0 总销量 1 今日销量' AFTER `open_advertisement`;
CREATE TABLE `shop_advance_sale_order` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `sale_order_sn` varchar(50) NOT NULL COMMENT '预售预付款订单号',
  `order_sn` varchar(50) NOT NULL COMMENT '订单编号',
  `transaction_id` varchar(50) NOT NULL COMMENT '预售预付款微信订单号',
  `user_id` int(8) NOT NULL,
  `goods_id` int(8) NOT NULL,
  `price` float(8,2) NOT NULL COMMENT '预售商品价格',
  `front_money` float(8,2) NOT NULL COMMENT '预付款',
  `money` float(8,2) NOT NULL COMMENT '尾款',
  `pay_start_time` varchar(12) NOT NULL COMMENT '付尾款开始时间',
  `pay_end_time` varchar(12) NOT NULL COMMENT '付尾款结束时间',
  `status` int(1) NOT NULL DEFAULT '0' COMMENT '状态 0未付款 1已付款  2已退款 3退款中 4已付尾款',
  `is_send` int(1) NOT NULL DEFAULT '0' COMMENT '是否发送付款通知',
  `sale_id` int(8) NOT NULL COMMENT '预售活动id',
  `remarks` varchar(255) NOT NULL COMMENT '备注 退款信息',
  `create_time` varchar(12) NOT NULL,
  `update_time` varchar(12) DEFAULT NULL,
  `delete_time` varchar(12) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
ALTER TABLE `shop_diy_express_template` MODIFY COLUMN `width` int(6) NOT NULL DEFAULT 0 COMMENT '宽度';
ALTER TABLE `shop_diy_express_template` MODIFY COLUMN `height` int(6) NOT NULL DEFAULT 0 COMMENT '高度';
ALTER TABLE `shop_tuan_warehouse` MODIFY COLUMN `leaders`  longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL AFTER `merchant_id`;
truncate shop_menu;
INSERT INTO `shop_menu` VALUES ('1', '登录', '/login', '1', '0', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('2', '页面不存在', '/404', '1', '0', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('3', '', '/', '1', '0', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('4', '应用列表', '/', '0', '3', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('5', '应用信息', '/appinfo', '0', '3', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('6', '修改密码', '/info/updatePW', '1', '0', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('7', '修改密码', '/', '0', '6', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('8', '总览', '/dashboard', '0', '0', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('9', '数据概览', '/dashboard', '0', '8', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('10', '升级日志', '/upgrade', '0', '8', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('11', '消息中心', '/news', '1', '8', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('12', '商品', '/goods/list', '0', '0', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('13', '商品列表', '/goods/list', '0', '12', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('14', '商品分类', '/goods/group', '0', '12', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('15', '集团分组', '/goods/groupGrouping', '0', '12', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('16', '商品标签', '/goods/label', '0', '12', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('17', '回收站', '/goods/recyclebin', '0', '12', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('18', '商品添加', '/goods/add', '1', '12', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('19', '订单', '/order/manage1', '0', '0', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('20', '订单管理', '/order/manage1', '0', '19', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('21', '订单概述', '/order/summary', '0', '19', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('22', '评价管理', '/order/comment', '0', '19', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('23', '订单配送', '/order/print', '0', '19', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('24', '订单管理1', '/order/manage', '1', '19', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('25', '订单详情', '/order/details', '1', '19', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('26', '会员', '/vip/list', '0', '0', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('27', '会员列表', '/vip/list', '0', '26', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('28', '会员等级', '/vip/unpay', '0', '26', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('29', '团长', '/customers/head', '0', '0', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('30', '团长', '/customers/head', '0', '29', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('31', '团长审核', '/customers/audit', '0', '29', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('32', '团长等级', '/customers/leave', '0', '29', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('33', '路线', '/customers/warehouse', '0', '29', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('34', '设置', '/setting/tuanconfig', '0', '29', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('35', '佣金流水', '/finance/record', '0', '29', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('36', '提现申请', '/finance/apply', '0', '29', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('37', '应用', '/marketing/index', '0', '0', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('38', '应用管理', '/marketing/index', '0', '37', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('39', '优惠券', '/marketing/coupon', '1', '37', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('40', '购物返现', '/marketing/buyCashback', '1', '37', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('41', '秒杀', '/marketing/seckill', '1', '37', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('42', '签到', '/marketing/singin', '1', '37', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('43', '订阅信息', '/marketing/apptamplate', '1', '37', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('44', '拼团', '/marketing/assemble', '1', '37', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('45', '充值', '/marketing/pay', '1', '37', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('46', '砍价', '/marketing/bargain', '1', '37', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('47', '满减', '/marketing/reduction', '1', '37', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('48', '新人专享', '/marketing/recuits', '1', '37', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('49', '积分商城', '/marketing/score', '1', '37', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('50', '预约送达', '/marketing/estimated', '1', '37', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('51', '会员PLUS', '/vip/pay', '1', '37', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('52', '自定义版权', '/marketing/copyright', '1', '37', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('53', '签到记录', '/marketing/record', '1', '37', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('54', '预售', '/marketing/advanceSale', '1', '37', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('55', '商品推荐', '/marketing/recommend', '1', '37', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('56', '群接龙', '/marketing/jielong', '1', '37', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('57', '海报生成', '/marketing/poster', '1', '37', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('58', '门店小程序后台', '/marketing/storeapp', '1', '37', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('59', '专题', '/marketing/special', '1', '37', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('60', '商品采集', '/marketing/collection', '1', '37', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('61', '抽奖', '/marketing/luckdraw', '1', '37', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('62', '分销', '/subCommission', '1', '37', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('63', '仓库', '/warehouse', '1', '37', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('64', '入库详情', '/warehouse/inComings/info', '1', '37', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('65', '入库新增', '/warehouse/inComings/add', '1', '37', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('66', '出库新增', '/warehouse/outbounds/add', '1', '37', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('67', '出库详情', '/warehouse/outbounds/info', '1', '37', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('68', '盘点新增', '/warehouse/inventories/add', '1', '37', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('69', '盘点详情', '/warehouse/inventories/info', '1', '37', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('70', '门店', '/supplier', '1', '37', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('71', '数据', '/finance/apply', '0', '0', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('72', '销售统计', '/statistics/sales', '0', '71', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('73', '商品销售统计', '/statistics/goodsSales', '0', '71', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('74', '团长销售统计', '/statistics/leaderSales', '0', '71', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('75', '用户排行统计', '/statistics/userSales', '0', '71', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('76', '小程序', '/applet/baseconfig', '0', '0', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('77', '基础设置', '/applet/baseconfig', '0', '76', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('78', '开屏广告', '/applet/openadvertising', '0', '76', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('79', '小程序上传', '/applet/upload', '0', '76', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('80', '权限', '/employee/manage', '0', '0', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('81', '员工管理', '/employee/manage', '0', '80', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('82', '角色管理', '/employee/role', '0', '80', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('83', '客服管理', '/employee/kefu', '1', '80', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('84', '设置', '/setting/appsetting', '0', '0', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('85', '基础设置', '/setting/appsetting', '0', '84', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('86', '运费模板', '/setting/express', '0', '84', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('87', '收货信息', '/setting/takegoods', '0', '84', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('88', '电子面单', '/setting/expressdoc', '0', '84', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('89', '页面配置', '/setting/viewconfig', '0', '84', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('90', 'UU跑腿', '/setting/uu', '0', '84', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('91', '点我达', '/setting/dianwoda', '0', '84', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('92', '蜂鸟', '/setting/fengniao', '0', '84', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('93', '小票打印', '/setting/yly', '0', '84', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('94', '小票打印模板', '/setting/ylyTemplate', '0', '84', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('95', '分享海报', '/setting/posters', '0', '84', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('96', '常见问题', '/setting/help', '0', '84', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('97', '销售时间', '/setting/salestime', '0', '84', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('98', '附件', '/setting/enclosure', '0', '84', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('99', '短信', '/setting/sms', '0', '84', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('100', '物流查询', '/setting/logistics', '0', '84', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('101', '地址库', '/setting/addressLibrary', '0', '84', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('102', '日志', '/operationlog', '0', '0', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('103', '操作记录', '/operationlog', '0', '102', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('104', '装修', '/renovation/personalcenter', '0', '0', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('105', '个人中心', '/renovation/personalcenter', '0', '104', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('106', '主题配色', '/renovation/theme', '0', '104', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('107', '底部导航', '/renovation/bottomnav', '0', '104', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('108', '装修', '/goToOld', '0', '104', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('109', '直播', '/liveBroadcast', '1', '0', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('110', '直播', '/liveBroadcast', '0', '109', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('111', '积分商城', '/score/list/add', '1', '0', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('112', '积分商品添加', '/score/list/add', '0', '111', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('113', '未授权', '/didopen', '1', '0', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('114', '未授权', '/didopen', '0', '113', '1601453379', '1601453379', null);
INSERT INTO `shop_menu` VALUES ('115', '页面不存在', '*', '1', '0', '1601453379', '1601453379', null);
/*2020-09-30*/

ALTER TABLE `shop_goods` ADD COLUMN `limit_time`  int(11) DEFAULT 0 NOT NULL AFTER `limit_number`;
ALTER TABLE `system_app_access` MODIFY COLUMN `phone`  char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客服电话' AFTER `name`;
ALTER TABLE `shop_stock` MODIFY COLUMN `number` int(11) DEFAULT 0 COMMENT '库存数量';
ALTER TABLE `shop_goods` ADD COLUMN `pay_time_type`  int(1) NOT NULL DEFAULT 0 COMMENT '销售时间 0=系统设置 1 单独设置' AFTER `take_goods_time`;
ALTER TABLE `shop_goods` MODIFY COLUMN `pay_number`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '最低购买数量' AFTER `pay_end_time`;
ALTER TABLE `system_app_access` MODIFY COLUMN `pay_time`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '销售时间' AFTER `is_show_supplier_goods`;
ALTER TABLE `shop_stock` ADD COLUMN `score` int(11) DEFAULT 0 COMMENT '积分' AFTER `number`;
ALTER TABLE `shop_goods` ADD COLUMN `pay_start_time`  int(11) NULL COMMENT '销售开始时间 显示' AFTER `take_goods_time`, ADD COLUMN `pay_end_time`  int(11) NULL COMMENT '结束销售时间 显示' AFTER `pay_start_time`, ADD COLUMN `pay_number`  varchar(100) NOT NULL DEFAULT '0' COMMENT '最低购买数量' AFTER `pay_end_time`;
ALTER TABLE `system_app_access` ADD COLUMN `pay_time`  varchar(255) NOT NULL COMMENT '销售时间' AFTER `is_show_supplier_goods`;
ALTER TABLE `shop_grouping` ADD COLUMN `sort` int(11) DEFAULT 0 COMMENT '排序' AFTER `name`;
ALTER TABLE `system_app_access` ADD COLUMN `lain_is_open` tinyint(1) NOT NULL DEFAULT 1 COMMENT '提示音开关 0=关闭 1=开启' AFTER `status`;
CREATE TABLE `shop_lucky_draw`  (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  `key` char(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '唯一标识符',
  `merchant_id` int(11) NOT NULL COMMENT '商户id',
  `start_time` int(11) NOT NULL COMMENT '开始时间',
  `end_time` int(11) NOT NULL COMMENT '结束时间',
  `bg_color` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '背景色',
  `top_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '顶部背景图',
  `poster_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '海报图',
  `luck_draw_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '抽奖图标',
  `partake_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '谢谢参与图标',
  `require_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '参与抽奖要求类型  0=关闭 1=每天免费次数 2=每人免费次数',
  `require_num` int(10) NOT NULL DEFAULT 0 COMMENT '免费次数',
  `points_exchange_is_open` tinyint(1) NOT NULL DEFAULT 0 COMMENT '积分兑换是否开启 0=关闭 1=开启',
  `points_exchange` int(10) NOT NULL DEFAULT 0 COMMENT '积分兑换抽奖次数 (X分/次)',
  `order_money` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '订单消费额',
  `order_num` int(10) NOT NULL DEFAULT 0 COMMENT '订单达标赠送次数',
  `activity_rules` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '活动规则',
  `event_prizes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '活动奖品',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态 0=关闭 1=开启',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '修改时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '九宫格抽奖活动表' ROW_FORMAT = Compact;
CREATE TABLE `shop_lucky_draw_record`  (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  `lucky_draw_id` int(11) NOT NULL DEFAULT 0 COMMENT '抽奖活动id',
  `user_id` int(11) NOT NULL DEFAULT 0 COMMENT '用户id',
  `user_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '用户信息',
  `type` tinyint(1) NOT NULL COMMENT '奖品类型 1=实物 2=积分 3=优惠券 4=谢谢惠顾',
  `prize_id` int(11) NOT NULL DEFAULT 0 COMMENT '奖品id(9=谢谢参与)',
  `name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '奖品名称',
  `integral` int(11) DEFAULT 0 COMMENT '积分数量',
  `coupon` int(11) DEFAULT 0 COMMENT '优惠券id',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '奖品发放备注',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '发放状态 0=未发放 1=已发放',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '修改时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '九宫格抽奖活动记录表' ROW_FORMAT = Compact;
ALTER TABLE `shop_user` ADD COLUMN `every_day_draw_num` int(11) DEFAULT 0 COMMENT '每天赠送的抽奖次数' AFTER `score`;
ALTER TABLE `shop_user` ADD COLUMN `everyone_draw_num` int(11) DEFAULT 0 COMMENT '每人赠送的抽奖次数' AFTER `score`;
ALTER TABLE `shop_user` ADD COLUMN `draw_num` int(11) DEFAULT 0 COMMENT '抽奖次数' AFTER `score`;
ALTER TABLE `shop_tuan_leader` ADD COLUMN `id_card` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '身份证号' AFTER `realname`;
ALTER TABLE `shop_stock` ADD COLUMN `score`  int(10) NOT NULL DEFAULT 0 COMMENT '积分' AFTER `cost_price`;
CREATE TABLE `shop_posters` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `key` char(6) NOT NULL DEFAULT '' COMMENT '唯一标识符',
  `merchant_id` int(11) NOT NULL COMMENT '商户id',
  `name` varchar(52) NOT NULL DEFAULT '' COMMENT '名称',
  `type` int(1) NOT NULL COMMENT '0 是首页 1 详情页',
  `content` longtext NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态 1=启用 0=禁用',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='商城生成海报表';

CREATE TABLE `shop_collect_config`  (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `key` char(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '唯一标识符',
  `merchant_id` int(11) NOT NULL COMMENT '商户id',
  `apikey` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'apikey',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品采集配置表' ROW_FORMAT = Compact;

ALTER TABLE `system_app_access` ADD COLUMN `flash_pic_url`  varchar(200) NOT NULL DEFAULT '' COMMENT '秒杀图片' AFTER `bargain_rotation`;
ALTER TABLE `system_app_access` ADD COLUMN `is_get_phone` tinyint(1) NOT NULL DEFAULT 0 COMMENT '获取手机号开关 1为开启 0为关闭' AFTER `is_location`;
CREATE TABLE `shop_special`  (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  `key` char(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '唯一标识符',
  `merchant_id` int(11) NOT NULL COMMENT '商户id',
  `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '专题名称',
  `pic_urls` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '轮播图',
  `bg_color` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '背景色',
  `start_time` int(11) NOT NULL COMMENT '开始时间',
  `end_time` int(11) NOT NULL COMMENT '结束时间',
  `is_show_sales` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否显示销量 0=否 1=是',
  `goods_style` tinyint(1) NOT NULL DEFAULT 1 COMMENT '商品样式 1=横排 2=一排2个',
  `share_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '分享标题',
  `share_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '分享海报',
  `sort` int(5) NOT NULL DEFAULT 0 COMMENT '排序',
  `goods_ids` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品id',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否启用 0=否 1=是',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '修改时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '专题活动表' ROW_FORMAT = Compact;
ALTER TABLE `shop_order` ADD COLUMN `refund`  varchar(255) NULL AFTER `after_status`;
CREATE TABLE `shop_marchant_category_group`  (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  `key` char(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '唯一标识符',
  `merchant_id` int(11) NOT NULL COMMENT '商户id',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '类目名称',
  `supplier_id` int(11) NOT NULL DEFAULT 0 COMMENT '门店id',
  `pic_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '图片地址',
  `sort` int(5) UNSIGNED DEFAULT 0 COMMENT '排序',
  `category_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '分类id（json）',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态 1激活 0未激活',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '修改时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '分类分组表' ROW_FORMAT = Compact;
ALTER TABLE `system_app_access` ADD COLUMN `is_show_online_service` tinyint(1) NOT NULL DEFAULT 1 COMMENT '(小程序)在线客服是否显示 1=是 0=否' AFTER `status`;
ALTER TABLE `system_operation_record` MODIFY COLUMN `merchant_id` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '操作人账号' AFTER `key`;
ALTER TABLE `shop_live` ADD COLUMN `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '主播头像' AFTER `anchor_name`;
ALTER TABLE `shop_goods` ADD COLUMN `is_vip` int(11) NOT NULL DEFAULT 0 COMMENT '接龙活动ID' AFTER `grouping_id`;
CREATE TABLE `shop_personal_center`  (
  `id` mediumint(11) NOT NULL AUTO_INCREMENT,
  `key` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '唯一标识符',
  `merchant_id` int(4) NOT NULL COMMENT '商户id',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '名称',
  `pic_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '图标地址',
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '链接地址',
  `type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '类型 1=功能入口  2=轮播图',
  `sort` int(11) DEFAULT 0 COMMENT '排序',
  `status` int(1) NOT NULL DEFAULT 1 COMMENT '是否显示 1=是  0=否',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '修改时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '个人中心表' ROW_FORMAT = Compact;
ALTER TABLE `system_app_access` ADD COLUMN `is_show_pick_up_code` tinyint(1) NOT NULL DEFAULT 1 COMMENT '(小程序)提货码是否显示 1=是 0=否' AFTER `status`;
ALTER TABLE `system_app_access` ADD COLUMN `is_show_my_leader` tinyint(1) NOT NULL DEFAULT 1 COMMENT '(小程序)我的团长是否显示 1=是 0=否' AFTER `status`;
DELETE from shop_leader_level where type =1;
ALTER TABLE `system_merchant_design` ADD COLUMN `index_padding`  varchar(50) NOT NULL AFTER `is_enable`, ADD COLUMN `index_padding_color`  varchar(50) NOT NULL AFTER `index_padding`, ADD COLUMN `index_padding_radius`  varchar(50) NOT NULL AFTER `index_padding_color`, ADD COLUMN `index_margin_bottom`  varchar(50) NOT NULL AFTER `index_padding_radius`;
DROP TABLE  wolive_business;
DROP TABLE  wolive_chats;
DROP TABLE  wolive_group;
DROP TABLE  wolive_message;
DROP TABLE  wolive_question;
DROP TABLE  wolive_queue;
DROP TABLE  wolive_reply;
DROP TABLE  wolive_sentence;
DROP TABLE  wolive_service;
DROP TABLE  wolive_tablist;
DROP TABLE  wolive_visiter;
DROP TABLE  wolive_weixin;
ALTER TABLE `system_app_access` ADD COLUMN `supplier_express`  int(1) NOT NULL COMMENT '门店运费计算规则' AFTER `is_show_supplier_goods`;
ALTER TABLE `system_app_access` ADD COLUMN `express`  int(1) NOT NULL COMMENT '运费计算规则' AFTER `is_show_supplier_goods`;
ALTER TABLE `shop_order` ADD COLUMN   `leader_money` decimal(8,2) DEFAULT '0.00' COMMENT '团长佣金' AFTER `status`;
ALTER TABLE `shop_order` ADD COLUMN   `commission_money` decimal(8,2) DEFAULT '0.00' COMMENT '分销佣金' AFTER `status`;
ALTER TABLE `shop_order` ADD COLUMN   `voucher` decimal(8,2) DEFAULT '0.00' COMMENT '优惠卷' AFTER `status`;
ALTER TABLE `shop_order` ADD COLUMN   `vip` decimal(8,2) DEFAULT '0.00' COMMENT 'vip' AFTER `status`;
ALTER TABLE `shop_order` ADD COLUMN   `reduction_decrease` decimal(8,2) DEFAULT '0.00' COMMENT '满减' AFTER `status`;
ALTER TABLE `shop_order` ADD COLUMN   `send_express_type` tinyint(1) DEFAULT NULL COMMENT '卖家实际发货方式 0=快递 1=本地配送' AFTER `status`;
ALTER TABLE `shop_order` ADD COLUMN   `after_sale` tinyint(1) DEFAULT '-1' COMMENT '退款状态 -1=未售后 0=退款中 1=同意退款 2=拒绝退款' AFTER `status`;
ALTER TABLE `shop_order` ADD COLUMN   `after_type` tinyint(1) DEFAULT '0' COMMENT '退款类型 1=退款退货 2=只退款' AFTER `status`;
ALTER TABLE `shop_order` ADD COLUMN   `after_phone` varchar(20) DEFAULT '0' AFTER `status`;
ALTER TABLE `shop_order` ADD COLUMN   `after_addr` varchar(100) DEFAULT NULL AFTER `status`;
ALTER TABLE `shop_order` ADD COLUMN   `after_remark` varchar(255) DEFAULT NULL AFTER `status`;
ALTER TABLE `shop_order` ADD COLUMN   `after_imgs` varchar(255) DEFAULT NULL AFTER `status`;
ALTER TABLE `shop_order` ADD COLUMN   `after_express_number` varchar(50) DEFAULT NULL AFTER `status`;
ALTER TABLE `shop_order` ADD COLUMN   `after_admin_imgs` varchar(255) DEFAULT NULL AFTER `status`;
ALTER TABLE `shop_order` ADD COLUMN   `after_admin_remark` varchar(255) DEFAULT NULL AFTER `status`;
ALTER TABLE `shop_order` ADD COLUMN   `after_status` varchar(255) DEFAULT NULL AFTER `status`;
ALTER TABLE `shop_goods` ADD COLUMN `is_live_goods` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否为小程序直播商品 0=否  1=是 ' AFTER `distribution`;
ALTER TABLE `shop_recharge_balance_access` MODIFY COLUMN `pay_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '购买类型  1=微信 2=支付宝 5=扫呗 6=线下支付' AFTER `remain_money`;
ALTER TABLE `shop_recharge_balance_access` ADD COLUMN `recharge_type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '充值类型  1=余额 2=积分' AFTER `pay_type`;
ALTER TABLE `shop_user` ADD COLUMN `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '真实姓名' AFTER `nickname`;
CREATE TABLE `shop_admin_mini_config`  (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `key` char(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '唯一标识符',
  `merchant_id` int(11) NOT NULL COMMENT '商户id',
  `app_id` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '小程序app_id',
  `secret` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '小程序secret',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '后台小程序配置表' ROW_FORMAT = Compact;
CREATE TABLE `shop_admin_user`  (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `union_id` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '微信标识符',
  `wx_open_id` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '微信openid',
  `mini_open_id` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '小程序openid',
  `key` char(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '唯一标识符',
  `merchant_id` int(11) NOT NULL COMMENT '商户id',
  `nickname` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '昵称',
  `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '头像',
  `supplier_id` int(11) DEFAULT 0 COMMENT '门店id',
  `is_admin` tinyint(1) DEFAULT 0 COMMENT '是否管理员 1=是 0=否',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门店、管理员用户表' ROW_FORMAT = Compact;
ALTER TABLE `system_app_access` ADD COLUMN `supplier_sort`  int(1) NOT NULL DEFAULT 0 COMMENT '门店排序规则' AFTER `is_location`;
ALTER TABLE `shop_solitaire` MODIFY COLUMN `detail_info`  text CHARACTER SET utf8mb4 NULL COMMENT '详细说明(富文本)' AFTER `pic_urls`;
ALTER TABLE `system_app_access` ADD COLUMN `is_location`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '定位开关' AFTER `is_recruits_show`;
ALTER TABLE `shop_unpaid_vip` DROP `voucher_count`;
ALTER TABLE `shop_unpaid_vip` DROP `voucher_type_id`;
ALTER TABLE `shop_unpaid_vip` DROP `score_times`;
ALTER TABLE `shop_order_group` ADD COLUMN `pick_up_code` int(6) DEFAULT NULL COMMENT '取货码' AFTER `solitaire_id`;
ALTER TABLE `shop_order_group` MODIFY COLUMN `pick_up_code` char(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '取货码' AFTER `solitaire_id`;
CREATE TABLE `shop_subscribe_message_num`  (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `key` char(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '唯一标识符',
  `merchant_id` int(11) NOT NULL COMMENT '商户id',
  `user_id` int(11) NOT NULL COMMENT '用户id',
  `template_id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '小程序订阅消息模板id',
  `num` int(11) NOT NULL COMMENT '次数',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户订阅消息授权次数表' ROW_FORMAT = Compact;
CREATE TABLE `shop_bird_account`  (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `key` char(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '唯一标识符',
  `merchant_id` int(11) NOT NULL COMMENT '商户id',
  `app_id` char(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '蜂鸟账户app_id',
  `secret_key` char(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '蜂鸟账户secret_key',
  `chain_store_code` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '蜂鸟门店编号',
  `transport_name` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '蜂鸟门店名称',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商户蜂鸟配送账号表' ROW_FORMAT = Compact;
CREATE TABLE `shop_bird_order`  (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `order_sn` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '订单编码',
  `open_order_code` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '蜂鸟配送订单号',
  `order_status` int(5) NOT NULL COMMENT '订单状态 1=系统已接单 20=已分配骑手 80=骑手已到店 2=配送中 3=已送达 5=异常 4=已取消 ',
  `push_time` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '状态推送时间(毫秒)',
  `carrier_driver_name` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '蜂鸟配送员姓名',
  `carrier_driver_phone` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '蜂鸟配送员电话',
  `platform_code` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '(未知返回参数，蜂鸟接口未说明)',
  `tracking_id` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '(未知返回参数，蜂鸟接口未说明)',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'UU跑腿订单表' ROW_FORMAT = Compact;
ALTER TABLE `system_app_access` ADD COLUMN `bird_is_open` tinyint(1) NOT NULL DEFAULT 0 COMMENT '蜂鸟配送  1为开启  0为关闭' AFTER `dianwoda_is_open`;
CREATE TABLE `shop_solitaire_comment`  (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  `key` char(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '唯一标识符',
  `merchant_id` int(11) NOT NULL COMMENT '商户id',
  `user_id` int(11) NOT NULL COMMENT '用户id',
  `solitaire_id` int(11) NOT NULL DEFAULT 0 COMMENT '接龙id',
  `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '评论内容',
  `pic_urls` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '评论图片',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '修改时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '接龙活动评论表' ROW_FORMAT = Compact;
ALTER TABLE `shop_order_group` ADD COLUMN `vip`  decimal(8,2) NULL DEFAULT 0.00 COMMENT 'vip 优惠' AFTER `reduction_achieve`;
ALTER TABLE `shop_order_group` ADD COLUMN `is_advance`  int(1) NOT NULL DEFAULT 0 COMMENT '预购订单' AFTER `is_assemble`;
ALTER TABLE `shop_order_group` ADD COLUMN `solitaire_id` int(11) DEFAULT 0 COMMENT '接龙活动ID' AFTER `leader_money`;
truncate shop_menu;
INSERT INTO `shop_menu` VALUES ('1', '', '/login', '1', '0', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('2', '', '/404', '1', '0', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('3', '', '/', '1', '0', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('4', '应用列表', '/', '0', '3', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('5', '应用信息', '/appinfo', '0', '3', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('6', '', '/info/updatePW', '1', '0', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('7', '修改密码', '/', '0', '6', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('8', '', '/dashboard', '0', '0', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('9', '数据概览', '/dashboard', '0', '8', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('10', '升级日志', '/upgrade', '0', '8', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('11', '', '/goods/list', '0', '0', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('12', '商品列表', '/goods/list', '0', '11', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('13', '商品分类', '/goods/group', '0', '11', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('14', '集团分组', '/goods/groupGrouping', '0', '11', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('15', '商品标签', '/goods/label', '0', '11', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('16', '回收站', '/goods/recyclebin', '0', '11', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('17', '商品添加', '/goods/add', '1', '11', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('18', '', '/order/manage', '0', '0', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('19', '订单管理', '/order/manage', '0', '18', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('20', '订单概述', '/order/summary', '0', '18', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('21', '评价管理', '/order/comment', '0', '18', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('22', '订单配送', '/order/print', '0', '18', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('23', '', '/vip/list', '0', '0', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('24', '会员列表', '/vip/list', '0', '23', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('25', '会员等级', '/vip/unpay', '0', '23', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('26', '', '/customers/head', '0', '0', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('27', '团长', '/customers/head', '0', '26', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('28', '团长审核', '/customers/audit', '0', '26', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('29', '团长等级', '/customers/leave', '0', '26', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('30', '路线', '/customers/warehouse', '0', '26', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('31', '设置', '/setting/tuanconfig', '0', '26', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('32', '佣金流水', '/finance/record', '0', '26', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('33', '提现申请', '/finance/apply', '0', '26', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('34', '', '/marketing/index', '0', '0', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('35', '应用管理', '/marketing/index', '0', '34', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('36', '优惠券', '/marketing/coupon', '1', '34', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('37', '购物返现', '/marketing/buyCashback', '1', '34', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('38', '秒杀', '/marketing/seckill', '1', '34', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('39', '签到', '/marketing/singin', '1', '34', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('40', '订阅信息', '/marketing/apptamplate', '1', '34', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('41', '拼团', '/marketing/assemble', '1', '34', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('42', '充值', '/marketing/pay', '1', '34', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('43', '砍价', '/marketing/bargain', '1', '34', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('44', '满减', '/marketing/reduction', '1', '34', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('45', '新人专享', '/marketing/recuits', '1', '34', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('46', '积分商城', '/marketing/score', '1', '34', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('47', '预约送达', '/marketing/estimated', '1', '34', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('48', '会员PLUS', '/vip/pay', '1', '34', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('49', '自定义版权', '/marketing/copyright', '1', '34', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('50', '签到记录', '/marketing/record', '1', '34', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('51', '预售', '/marketing/advanceSale', '1', '34', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('52', '商品推荐', '/marketing/recommend', '1', '34', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('53', '群接龙', '/marketing/jielong', '1', '34', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('54', '海报生成', '/marketing/poster', '1', '34', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('55', '门店小程序后台', '/marketing/storeapp', '1', '34', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('56', '分销', '/subCommission', '1', '34', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('57', '仓库', '/warehouse', '1', '34', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('58', '门店', '/supplier', '1', '34', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('59', '', '/finance/apply', '0', '0', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('60', '销售统计', '/statistics/sales', '0', '59', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('61', '商品销售统计', '/statistics/goodsSales', '0', '59', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('62', '团长销售统计', '/statistics/leaderSales', '0', '59', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('63', '用户排行统计', '/statistics/userSales', '0', '59', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('64', '', '/applet/baseconfig', '0', '0', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('65', '基础设置', '/applet/baseconfig', '0', '64', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('66', '开屏广告', '/applet/openadvertising', '0', '64', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('67', '小程序上传', '/applet/upload', '0', '64', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('68', '', '/employee/manage', '0', '0', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('69', '员工管理', '/employee/manage', '0', '68', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('70', '角色管理', '/employee/role', '0', '68', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('71', '客服管理', '/employee/kefu', '1', '68', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('72', '', '/setting/appsetting', '0', '0', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('73', '基础设置', '/setting/appsetting', '0', '72', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('74', '运费模板', '/setting/express', '0', '72', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('75', '收货信息', '/setting/takegoods', '0', '72', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('76', '电子面单', '/setting/expressdoc', '0', '72', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('77', '页面配置', '/setting/viewconfig', '0', '72', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('78', 'UU跑腿', '/setting/uu', '0', '72', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('79', '点我达', '/setting/dianwoda', '0', '72', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('80', '蜂鸟', '/setting/fengniao', '0', '72', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('81', '小票打印', '/setting/yly', '0', '72', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('82', '小票打印模板', '/setting/ylyTemplate', '0', '72', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('83', '分享海报', '/setting/posters', '0', '72', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('84', '常见问题', '/setting/help', '0', '72', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('85', '附件', '/setting/enclosure', '0', '72', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('86', '短信', '/setting/sms', '0', '72', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('87', '物流查询', '/setting/logistics', '0', '72', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('88', '', '/operationlog', '0', '0', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('89', '操作记录', '/operationlog', '0', '88', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('90', '', '/goToOld', '0', '0', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('91', '装修', '/goToOld', '0', '90', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('92', '', '/liveBroadcast', '1', '0', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('93', '直播', '/liveBroadcast', '0', '92', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('94', '', '/score/list/add', '1', '0', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('95', '积分商品添加', '/score/list/add', '0', '94', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('96', '', '/didopen', '1', '0', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('97', '未授权', '/didopen', '0', '96', '1601363769', '1601363769', null);
INSERT INTO `shop_menu` VALUES ('98', '', '*', '1', '0', '1601363769', '1601363769', null);
/*2020-09-30*/

ALTER TABLE `shop_goods` ADD COLUMN `limit_time`  int(11) DEFAULT 0 NOT NULL AFTER `limit_number`;
ALTER TABLE `system_app_access` MODIFY COLUMN `phone`  char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客服电话' AFTER `name`;
ALTER TABLE `shop_stock` MODIFY COLUMN `number` int(11) DEFAULT 0 COMMENT '库存数量';
ALTER TABLE `shop_goods` ADD COLUMN `pay_time_type`  int(1) NOT NULL DEFAULT 0 COMMENT '销售时间 0=系统设置 1 单独设置' AFTER `take_goods_time`;
ALTER TABLE `shop_goods` MODIFY COLUMN `pay_number`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '最低购买数量' AFTER `pay_end_time`;
ALTER TABLE `system_app_access` MODIFY COLUMN `pay_time`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '销售时间' AFTER `is_show_supplier_goods`;
ALTER TABLE `shop_stock` ADD COLUMN `score` int(11) DEFAULT 0 COMMENT '积分' AFTER `number`;
ALTER TABLE `shop_goods` ADD COLUMN `pay_start_time`  int(11) NULL COMMENT '销售开始时间 显示' AFTER `take_goods_time`, ADD COLUMN `pay_end_time`  int(11) NULL COMMENT '结束销售时间 显示' AFTER `pay_start_time`, ADD COLUMN `pay_number`  varchar(100) NOT NULL DEFAULT '0' COMMENT '最低购买数量' AFTER `pay_end_time`;
ALTER TABLE `system_app_access` ADD COLUMN `pay_time`  varchar(255) NOT NULL COMMENT '销售时间' AFTER `is_show_supplier_goods`;
ALTER TABLE `shop_grouping` ADD COLUMN `sort` int(11) DEFAULT 0 COMMENT '排序' AFTER `name`;
ALTER TABLE `system_app_access` ADD COLUMN `lain_is_open` tinyint(1) NOT NULL DEFAULT 1 COMMENT '提示音开关 0=关闭 1=开启' AFTER `status`;
CREATE TABLE `shop_lucky_draw`  (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  `key` char(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '唯一标识符',
  `merchant_id` int(11) NOT NULL COMMENT '商户id',
  `start_time` int(11) NOT NULL COMMENT '开始时间',
  `end_time` int(11) NOT NULL COMMENT '结束时间',
  `bg_color` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '背景色',
  `top_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '顶部背景图',
  `poster_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '海报图',
  `luck_draw_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '抽奖图标',
  `partake_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '谢谢参与图标',
  `require_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '参与抽奖要求类型  0=关闭 1=每天免费次数 2=每人免费次数',
  `require_num` int(10) NOT NULL DEFAULT 0 COMMENT '免费次数',
  `points_exchange_is_open` tinyint(1) NOT NULL DEFAULT 0 COMMENT '积分兑换是否开启 0=关闭 1=开启',
  `points_exchange` int(10) NOT NULL DEFAULT 0 COMMENT '积分兑换抽奖次数 (X分/次)',
  `order_money` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '订单消费额',
  `order_num` int(10) NOT NULL DEFAULT 0 COMMENT '订单达标赠送次数',
  `activity_rules` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '活动规则',
  `event_prizes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '活动奖品',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态 0=关闭 1=开启',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '修改时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '九宫格抽奖活动表' ROW_FORMAT = Compact;
CREATE TABLE `shop_lucky_draw_record`  (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  `lucky_draw_id` int(11) NOT NULL DEFAULT 0 COMMENT '抽奖活动id',
  `user_id` int(11) NOT NULL DEFAULT 0 COMMENT '用户id',
  `user_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '用户信息',
  `type` tinyint(1) NOT NULL COMMENT '奖品类型 1=实物 2=积分 3=优惠券 4=谢谢惠顾',
  `prize_id` int(11) NOT NULL DEFAULT 0 COMMENT '奖品id(9=谢谢参与)',
  `name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '奖品名称',
  `integral` int(11) DEFAULT 0 COMMENT '积分数量',
  `coupon` int(11) DEFAULT 0 COMMENT '优惠券id',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '奖品发放备注',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '发放状态 0=未发放 1=已发放',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '修改时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '九宫格抽奖活动记录表' ROW_FORMAT = Compact;
ALTER TABLE `shop_user` ADD COLUMN `every_day_draw_num` int(11) DEFAULT 0 COMMENT '每天赠送的抽奖次数' AFTER `score`;
ALTER TABLE `shop_user` ADD COLUMN `everyone_draw_num` int(11) DEFAULT 0 COMMENT '每人赠送的抽奖次数' AFTER `score`;
ALTER TABLE `shop_user` ADD COLUMN `draw_num` int(11) DEFAULT 0 COMMENT '抽奖次数' AFTER `score`;
ALTER TABLE `shop_tuan_leader` ADD COLUMN `id_card` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '身份证号' AFTER `realname`;
ALTER TABLE `shop_stock` ADD COLUMN `score`  int(10) NOT NULL DEFAULT 0 COMMENT '积分' AFTER `cost_price`;
CREATE TABLE `shop_posters` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `key` char(6) NOT NULL DEFAULT '' COMMENT '唯一标识符',
  `merchant_id` int(11) NOT NULL COMMENT '商户id',
  `name` varchar(52) NOT NULL DEFAULT '' COMMENT '名称',
  `type` int(1) NOT NULL COMMENT '0 是首页 1 详情页',
  `content` longtext NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态 1=启用 0=禁用',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='商城生成海报表';

CREATE TABLE `shop_collect_config`  (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `key` char(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '唯一标识符',
  `merchant_id` int(11) NOT NULL COMMENT '商户id',
  `apikey` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'apikey',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品采集配置表' ROW_FORMAT = Compact;

ALTER TABLE `system_app_access` ADD COLUMN `flash_pic_url`  varchar(200) NOT NULL DEFAULT '' COMMENT '秒杀图片' AFTER `bargain_rotation`;
ALTER TABLE `system_app_access` ADD COLUMN `is_get_phone` tinyint(1) NOT NULL DEFAULT 0 COMMENT '获取手机号开关 1为开启 0为关闭' AFTER `is_location`;
CREATE TABLE `shop_special`  (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  `key` char(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '唯一标识符',
  `merchant_id` int(11) NOT NULL COMMENT '商户id',
  `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '专题名称',
  `pic_urls` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '轮播图',
  `bg_color` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '背景色',
  `start_time` int(11) NOT NULL COMMENT '开始时间',
  `end_time` int(11) NOT NULL COMMENT '结束时间',
  `is_show_sales` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否显示销量 0=否 1=是',
  `goods_style` tinyint(1) NOT NULL DEFAULT 1 COMMENT '商品样式 1=横排 2=一排2个',
  `share_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '分享标题',
  `share_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '分享海报',
  `sort` int(5) NOT NULL DEFAULT 0 COMMENT '排序',
  `goods_ids` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品id',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否启用 0=否 1=是',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '修改时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '专题活动表' ROW_FORMAT = Compact;
ALTER TABLE `shop_order` ADD COLUMN `refund`  varchar(255) NULL AFTER `after_status`;
CREATE TABLE `shop_marchant_category_group`  (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  `key` char(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '唯一标识符',
  `merchant_id` int(11) NOT NULL COMMENT '商户id',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '类目名称',
  `supplier_id` int(11) NOT NULL DEFAULT 0 COMMENT '门店id',
  `pic_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '图片地址',
  `sort` int(5) UNSIGNED DEFAULT 0 COMMENT '排序',
  `category_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '分类id（json）',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态 1激活 0未激活',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '修改时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '分类分组表' ROW_FORMAT = Compact;
ALTER TABLE `system_app_access` ADD COLUMN `is_show_online_service` tinyint(1) NOT NULL DEFAULT 1 COMMENT '(小程序)在线客服是否显示 1=是 0=否' AFTER `status`;
ALTER TABLE `system_operation_record` MODIFY COLUMN `merchant_id` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '操作人账号' AFTER `key`;
ALTER TABLE `shop_live` ADD COLUMN `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '主播头像' AFTER `anchor_name`;
ALTER TABLE `shop_goods` ADD COLUMN `is_vip` int(11) NOT NULL DEFAULT 0 COMMENT '接龙活动ID' AFTER `grouping_id`;
CREATE TABLE `shop_personal_center`  (
  `id` mediumint(11) NOT NULL AUTO_INCREMENT,
  `key` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '唯一标识符',
  `merchant_id` int(4) NOT NULL COMMENT '商户id',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '名称',
  `pic_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '图标地址',
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '链接地址',
  `type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '类型 1=功能入口  2=轮播图',
  `sort` int(11) DEFAULT 0 COMMENT '排序',
  `status` int(1) NOT NULL DEFAULT 1 COMMENT '是否显示 1=是  0=否',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '修改时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '个人中心表' ROW_FORMAT = Compact;
ALTER TABLE `system_app_access` ADD COLUMN `is_show_pick_up_code` tinyint(1) NOT NULL DEFAULT 1 COMMENT '(小程序)提货码是否显示 1=是 0=否' AFTER `status`;
ALTER TABLE `system_app_access` ADD COLUMN `is_show_my_leader` tinyint(1) NOT NULL DEFAULT 1 COMMENT '(小程序)我的团长是否显示 1=是 0=否' AFTER `status`;
DELETE from shop_leader_level where type =1;
ALTER TABLE `system_merchant_design` ADD COLUMN `index_padding`  varchar(50) NOT NULL AFTER `is_enable`, ADD COLUMN `index_padding_color`  varchar(50) NOT NULL AFTER `index_padding`, ADD COLUMN `index_padding_radius`  varchar(50) NOT NULL AFTER `index_padding_color`, ADD COLUMN `index_margin_bottom`  varchar(50) NOT NULL AFTER `index_padding_radius`;
DROP TABLE  wolive_business;
DROP TABLE  wolive_chats;
DROP TABLE  wolive_group;
DROP TABLE  wolive_message;
DROP TABLE  wolive_question;
DROP TABLE  wolive_queue;
DROP TABLE  wolive_reply;
DROP TABLE  wolive_sentence;
DROP TABLE  wolive_service;
DROP TABLE  wolive_tablist;
DROP TABLE  wolive_visiter;
DROP TABLE  wolive_weixin;
ALTER TABLE `system_app_access` ADD COLUMN `supplier_express`  int(1) NOT NULL COMMENT '门店运费计算规则' AFTER `is_show_supplier_goods`;
ALTER TABLE `system_app_access` ADD COLUMN `express`  int(1) NOT NULL COMMENT '运费计算规则' AFTER `is_show_supplier_goods`;
ALTER TABLE `shop_order` ADD COLUMN   `leader_money` decimal(8,2) DEFAULT '0.00' COMMENT '团长佣金' AFTER `status`;
ALTER TABLE `shop_order` ADD COLUMN   `commission_money` decimal(8,2) DEFAULT '0.00' COMMENT '分销佣金' AFTER `status`;
ALTER TABLE `shop_order` ADD COLUMN   `voucher` decimal(8,2) DEFAULT '0.00' COMMENT '优惠卷' AFTER `status`;
ALTER TABLE `shop_order` ADD COLUMN   `vip` decimal(8,2) DEFAULT '0.00' COMMENT 'vip' AFTER `status`;
ALTER TABLE `shop_order` ADD COLUMN   `reduction_decrease` decimal(8,2) DEFAULT '0.00' COMMENT '满减' AFTER `status`;
ALTER TABLE `shop_order` ADD COLUMN   `send_express_type` tinyint(1) DEFAULT NULL COMMENT '卖家实际发货方式 0=快递 1=本地配送' AFTER `status`;
ALTER TABLE `shop_order` ADD COLUMN   `after_sale` tinyint(1) DEFAULT '-1' COMMENT '退款状态 -1=未售后 0=退款中 1=同意退款 2=拒绝退款' AFTER `status`;
ALTER TABLE `shop_order` ADD COLUMN   `after_type` tinyint(1) DEFAULT '0' COMMENT '退款类型 1=退款退货 2=只退款' AFTER `status`;
ALTER TABLE `shop_order` ADD COLUMN   `after_phone` varchar(20) DEFAULT '0' AFTER `status`;
ALTER TABLE `shop_order` ADD COLUMN   `after_addr` varchar(100) DEFAULT NULL AFTER `status`;
ALTER TABLE `shop_order` ADD COLUMN   `after_remark` varchar(255) DEFAULT NULL AFTER `status`;
ALTER TABLE `shop_order` ADD COLUMN   `after_imgs` varchar(255) DEFAULT NULL AFTER `status`;
ALTER TABLE `shop_order` ADD COLUMN   `after_express_number` varchar(50) DEFAULT NULL AFTER `status`;
ALTER TABLE `shop_order` ADD COLUMN   `after_admin_imgs` varchar(255) DEFAULT NULL AFTER `status`;
ALTER TABLE `shop_order` ADD COLUMN   `after_admin_remark` varchar(255) DEFAULT NULL AFTER `status`;
ALTER TABLE `shop_order` ADD COLUMN   `after_status` varchar(255) DEFAULT NULL AFTER `status`;
ALTER TABLE `shop_goods` ADD COLUMN `is_live_goods` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否为小程序直播商品 0=否  1=是 ' AFTER `distribution`;
ALTER TABLE `shop_recharge_balance_access` MODIFY COLUMN `pay_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '购买类型  1=微信 2=支付宝 5=扫呗 6=线下支付' AFTER `remain_money`;
ALTER TABLE `shop_recharge_balance_access` ADD COLUMN `recharge_type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '充值类型  1=余额 2=积分' AFTER `pay_type`;
ALTER TABLE `shop_user` ADD COLUMN `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '真实姓名' AFTER `nickname`;
CREATE TABLE `shop_admin_mini_config`  (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `key` char(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '唯一标识符',
  `merchant_id` int(11) NOT NULL COMMENT '商户id',
  `app_id` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '小程序app_id',
  `secret` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '小程序secret',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '后台小程序配置表' ROW_FORMAT = Compact;
CREATE TABLE `shop_admin_user`  (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `union_id` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '微信标识符',
  `wx_open_id` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '微信openid',
  `mini_open_id` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '小程序openid',
  `key` char(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '唯一标识符',
  `merchant_id` int(11) NOT NULL COMMENT '商户id',
  `nickname` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '昵称',
  `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '头像',
  `supplier_id` int(11) DEFAULT 0 COMMENT '门店id',
  `is_admin` tinyint(1) DEFAULT 0 COMMENT '是否管理员 1=是 0=否',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门店、管理员用户表' ROW_FORMAT = Compact;
ALTER TABLE `system_app_access` ADD COLUMN `supplier_sort`  int(1) NOT NULL DEFAULT 0 COMMENT '门店排序规则' AFTER `is_location`;
ALTER TABLE `shop_solitaire` MODIFY COLUMN `detail_info`  text CHARACTER SET utf8mb4 NULL COMMENT '详细说明(富文本)' AFTER `pic_urls`;
ALTER TABLE `system_app_access` ADD COLUMN `is_location`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '定位开关' AFTER `is_recruits_show`;
ALTER TABLE `shop_unpaid_vip` DROP `voucher_count`;
ALTER TABLE `shop_unpaid_vip` DROP `voucher_type_id`;
ALTER TABLE `shop_unpaid_vip` DROP `score_times`;
ALTER TABLE `shop_order_group` ADD COLUMN `pick_up_code` int(6) DEFAULT NULL COMMENT '取货码' AFTER `solitaire_id`;
ALTER TABLE `shop_order_group` MODIFY COLUMN `pick_up_code` char(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '取货码' AFTER `solitaire_id`;
CREATE TABLE `shop_subscribe_message_num`  (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `key` char(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '唯一标识符',
  `merchant_id` int(11) NOT NULL COMMENT '商户id',
  `user_id` int(11) NOT NULL COMMENT '用户id',
  `template_id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '小程序订阅消息模板id',
  `num` int(11) NOT NULL COMMENT '次数',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户订阅消息授权次数表' ROW_FORMAT = Compact;
CREATE TABLE `shop_bird_account`  (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `key` char(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '唯一标识符',
  `merchant_id` int(11) NOT NULL COMMENT '商户id',
  `app_id` char(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '蜂鸟账户app_id',
  `secret_key` char(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '蜂鸟账户secret_key',
  `chain_store_code` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '蜂鸟门店编号',
  `transport_name` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '蜂鸟门店名称',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商户蜂鸟配送账号表' ROW_FORMAT = Compact;
CREATE TABLE `shop_bird_order`  (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `order_sn` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '订单编码',
  `open_order_code` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '蜂鸟配送订单号',
  `order_status` int(5) NOT NULL COMMENT '订单状态 1=系统已接单 20=已分配骑手 80=骑手已到店 2=配送中 3=已送达 5=异常 4=已取消 ',
  `push_time` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '状态推送时间(毫秒)',
  `carrier_driver_name` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '蜂鸟配送员姓名',
  `carrier_driver_phone` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '蜂鸟配送员电话',
  `platform_code` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '(未知返回参数，蜂鸟接口未说明)',
  `tracking_id` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '(未知返回参数，蜂鸟接口未说明)',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'UU跑腿订单表' ROW_FORMAT = Compact;
ALTER TABLE `system_app_access` ADD COLUMN `bird_is_open` tinyint(1) NOT NULL DEFAULT 0 COMMENT '蜂鸟配送  1为开启  0为关闭' AFTER `dianwoda_is_open`;
CREATE TABLE `shop_solitaire_comment`  (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  `key` char(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '唯一标识符',
  `merchant_id` int(11) NOT NULL COMMENT '商户id',
  `user_id` int(11) NOT NULL COMMENT '用户id',
  `solitaire_id` int(11) NOT NULL DEFAULT 0 COMMENT '接龙id',
  `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '评论内容',
  `pic_urls` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '评论图片',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '修改时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '接龙活动评论表' ROW_FORMAT = Compact;
ALTER TABLE `shop_order_group` ADD COLUMN `vip`  decimal(8,2) NULL DEFAULT 0.00 COMMENT 'vip 优惠' AFTER `reduction_achieve`;
ALTER TABLE `shop_order_group` ADD COLUMN `is_advance`  int(1) NOT NULL DEFAULT 0 COMMENT '预购订单' AFTER `is_assemble`;
ALTER TABLE `shop_order_group` ADD COLUMN `solitaire_id` int(11) DEFAULT 0 COMMENT '接龙活动ID' AFTER `leader_money`;
CREATE TABLE `shop_solitaire`  (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  `key` char(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '唯一标识符',
  `merchant_id` int(11) NOT NULL COMMENT '商户id',
  `name` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '活动名称',
  `end_time` int(11) NOT NULL COMMENT '截至时间',
  `take_delivery_time` int(11) NOT NULL COMMENT '提货时间',
  `is_comment` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否支持评论 0=否 1=是',
  `video_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '视频地址',
  `pic_urls` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '介绍图',
  `detail_info` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '详细说明(富文本)',
  `goods_ids` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品id',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '修改时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '接龙活动表' ROW_FORMAT = Compact;
ALTER TABLE `shop_goods` ADD COLUMN `solitaire_id` int(11) NOT NULL DEFAULT 0 COMMENT '接龙活动ID' AFTER `grouping_id`;
ALTER TABLE `shop_solitaire` ADD COLUMN `is_check` tinyint(1) NOT NULL DEFAULT 0 COMMENT '评论需要审核 0=否 1=是' AFTER `is_comment`;
ALTER TABLE `shop_solitaire_comment` ADD COLUMN `is_check` tinyint(1) DEFAULT 0 COMMENT '审核状态 0=未审核 1=审核' AFTER `pic_urls`;
ALTER TABLE `shop_goods` ADD COLUMN `is_stock_open`  tinyint(1) NOT NULL DEFAULT 1 COMMENT '库存为0下架' AFTER `stocks`;
ALTER TABLE `shop_goods` ADD COLUMN `time_icon`  varchar(256) NOT NULL COMMENT '时效图标' AFTER `stocks`;
UPDATE `system_diy_config` SET `title` = '资质规则' WHERE `id` = 5;
UPDATE `system_diy_config` SET `title` = '资质规则' WHERE `id` = 6;
UPDATE `system_diy_config` SET `title` = '资质规则' WHERE `id` = 7;
UPDATE `shop_menu` set `name`='基础设置' where `id` = 85;
UPDATE `shop_menu` set `name`='小票打印' where `id` = 98;
UPDATE `shop_menu` set `name`='订阅消息' where `id` = 45;
UPDATE `shop_goods` set `is_check`=1 where `supplier_id` = 0;
ALTER TABLE `shop_goods` ADD COLUMN `thum_pic`  text NOT NULL COMMENT '缩略图' AFTER `pic_urls`;
ALTER TABLE `shop_advance_sale` ADD COLUMN `days`  int(4) NOT NULL DEFAULT 0 COMMENT '发货天数' AFTER `detail_info`;
CREATE TABLE `shop_grouping`  (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  `key` char(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '唯一标识符',
  `merchant_id` int(11) NOT NULL COMMENT '商户id',
  `name` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '集团分组名称',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态 1有效 0无效',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '修改时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品集团分组表' ROW_FORMAT = Compact;
ALTER TABLE `shop_goods` ADD COLUMN `grouping_id` int(11) NOT NULL DEFAULT 0 COMMENT '集团分组ID' AFTER `partner_id`;
UPDATE `system_diy_express_template` SET `name` = '团长单', `english_name` = 'leader_order', `appid` = 2, `keywords_ids` = '[{\"name\":\"商家信息\",\"id\":\"2\",\"type\":\"0\",\"child\":[{\"name\":\"商家姓名\",\"id\":\"70\",\"parentId\":\"2\",\"pic_url\":\"\",\"english_name\":\"merchant_name\"},{\"name\":\"商家地址\",\"id\":\"21\",\"parentId\":\"2\",\"pic_url\":\"\",\"english_name\":\"merchant_addr\"},{\"name\":\"商家电话\",\"id\":\"20\",\"parentId\":\"2\",\"pic_url\":\"\",\"english_name\":\"merchant_phone\"},{\"name\":\"商家名称\",\"id\":\"19\",\"parentId\":\"2\",\"pic_url\":\"\",\"english_name\":\"widget_name\"}]},{\"name\":\"表格信息\",\"id\":\"3\",\"type\":\"1\",\"child\":[{\"name\":\"货号\",\"id\":\"68\",\"parentId\":\"3\",\"pic_url\":\"\",\"english_name\":\"goods_code\"},{\"name\":\"商品ID\",\"id\":\"67\",\"parentId\":\"3\",\"pic_url\":\"\",\"english_name\":\"goods_id\"},{\"name\":\"规格\",\"id\":\"66\",\"parentId\":\"3\",\"pic_url\":\"\",\"english_name\":\"property\"},{\"name\":\"单价\",\"id\":\"7\",\"parentId\":\"3\",\"pic_url\":\"\",\"english_name\":\"price\"},{\"name\":\"数量\",\"id\":\"4\",\"parentId\":\"3\",\"pic_url\":\"\",\"english_name\":\"number\"},{\"name\":\"商品名称\",\"id\":\"2\",\"parentId\":\"3\",\"pic_url\":\"\",\"english_name\":\"goodsname\"},{\"name\":\"标签\",\"id\":\"16\",\"parentId\":\"3\",\"pic_url\":\"\",\"english_name\":\"label\"},{\"name\":\"短标题\",\"id\":\"17\",\"parentId\":\"3\",\"pic_url\":\"\",\"english_name\":\"short_name\"}]},{\"name\":\"团长信息\",\"id\":\"5\",\"type\":\"0\",\"child\":[{\"name\":\"路线\",\"id\":\"41\",\"parentId\":\"5\",\"pic_url\":\"\",\"english_name\":\"route\"},{\"name\":\"配送方式\",\"id\":\"40\",\"parentId\":\"5\",\"pic_url\":\"\",\"english_name\":\"express_type\"},{\"name\":\"团长城市\",\"id\":\"39\",\"parentId\":\"5\",\"pic_url\":\"\",\"english_name\":\"leader_city\"},{\"name\":\"团长小区\",\"id\":\"38\",\"parentId\":\"5\",\"pic_url\":\"\",\"english_name\":\"leader_area_name\"},{\"name\":\"取货点\",\"id\":\"69\",\"parentId\":\"5\",\"pic_url\":\"\",\"english_name\":\"leader_addr\"},{\"name\":\"团长ID\",\"id\":\"37\",\"parentId\":\"5\",\"pic_url\":\"\",\"english_name\":\"leader_uid\"},{\"name\":\"团长电话\",\"id\":\"36\",\"parentId\":\"5\",\"pic_url\":\"\",\"english_name\":\"leader_phone\"},{\"name\":\"团长姓名\",\"id\":\"35\",\"parentId\":\"5\",\"pic_url\":\"\",\"english_name\":\"leader_name\"},{\"name\":\"团长昵称\",\"id\":\"34\",\"parentId\":\"5\",\"pic_url\":\"\",\"english_name\":\"leader_nickname\"}]},{\"name\":\"图片信息\",\"id\":\"6\",\"type\":\"2\",\"child\":[{\"name\":\"小程序码\",\"id\":\"24\",\"parentId\":\"6\",\"pic_url\":\"https://imgs.juanpao.com/admin%2Fprint%2F15622281435d1db5af6d82a.jpeg\",\"english_name\":\"widget_code\"},{\"name\":\"LOGO\",\"id\":\"23\",\"parentId\":\"6\",\"pic_url\":\"https://imgs.juanpao.com/admin%2Fprint%2F15622281705d1db5ca42e1b.jpeg\",\"english_name\":\"logo\"}]}]', `keywrod_info` = '[{\"id\":2,\"name\":\"商家信息\",\"type\":0,\"child\":[{\"id\":\"70\",\"name\":\"商家姓名\",\"pic_url\":\"\",\"parentId\":\"2\",\"english_name\":\"merchant_name\"},{\"id\":\"21\",\"name\":\"商家地址\",\"pic_url\":\"\",\"parentId\":\"2\",\"english_name\":\"merchant_addr\"},{\"id\":\"20\",\"name\":\"商家电话\",\"pic_url\":\"\",\"parentId\":\"2\",\"english_name\":\"merchant_phone\"},{\"id\":\"19\",\"name\":\"商家名称\",\"pic_url\":\"\",\"parentId\":\"2\",\"english_name\":\"widget_name\"}]},{\"id\":5,\"name\":\"团长信息\",\"type\":0,\"child\":[{\"id\":\"37\",\"name\":\"团长ID\",\"pic_url\":\"\",\"parentId\":\"5\",\"english_name\":\"leader_uid\"},{\"id\":\"35\",\"name\":\"团长姓名\",\"pic_url\":\"\",\"parentId\":\"5\",\"english_name\":\"leader_name\"},{\"id\":\"34\",\"name\":\"团长昵称\",\"pic_url\":\"\",\"parentId\":\"5\",\"english_name\":\"leader_nickname\"},{\"id\":\"36\",\"name\":\"团长电话\",\"pic_url\":\"\",\"parentId\":\"5\",\"english_name\":\"leader_phone\"},{\"id\":\"69\",\"name\":\"取货点\",\"pic_url\":\"\",\"parentId\":\"5\",\"english_name\":\"leader_addr\"},{\"id\":\"38\",\"name\":\"团长小区\",\"pic_url\":\"\",\"parentId\":\"5\",\"english_name\":\"leader_area_name\"},{\"id\":\"40\",\"name\":\"配送方式\",\"pic_url\":\"\",\"parentId\":\"5\",\"english_name\":\"express_type\"},{\"id\":\"39\",\"name\":\"团长城市\",\"pic_url\":\"\",\"parentId\":\"5\",\"english_name\":\"leader_city\"}]},{\"id\":3,\"name\":\"表格信息\",\"type\":1,\"child\":[{\"id\":\"67\",\"name\":\"商品ID\",\"pic_url\":\"\",\"parentId\":\"3\",\"english_name\":\"goods_id\"},{\"id\":\"68\",\"name\":\"货号\",\"pic_url\":\"\",\"parentId\":\"3\",\"english_name\":\"goods_code\"},{\"id\":\"17\",\"name\":\"短标题\",\"pic_url\":\"\",\"parentId\":\"3\",\"english_name\":\"short_name\"},{\"id\":\"16\",\"name\":\"标签\",\"pic_url\":\"\",\"parentId\":\"3\",\"english_name\":\"label\"},{\"id\":\"66\",\"name\":\"规格\",\"pic_url\":\"\",\"parentId\":\"3\",\"english_name\":\"property\"},{\"id\":\"4\",\"name\":\"数量\",\"pic_url\":\"\",\"parentId\":\"3\",\"english_name\":\"number\"},{\"id\":\"7\",\"name\":\"单价\",\"pic_url\":\"\",\"parentId\":\"3\",\"english_name\":\"price\"}]}]', `info` = '<div class=\"edit-box\" style=\"width: 380px; height: 982px;\">\n					<div class=\"item 70\" id=\"item-active\" data-name=\"70\" data-englishname=\"merchant_name\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 0px; top: 0px;\"><span>商家姓名:$merchant_name</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item 21\" id=\"item-active\" data-name=\"21\" data-englishname=\"merchant_addr\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; height: 26px; z-index: 0; left: 0px; top: 21px;\"><span>商家地址:$merchant_addr</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item 20\" id=\"item-active\" data-name=\"20\" data-englishname=\"merchant_phone\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 0px; top: 43px;\"><span>商家电话:$merchant_phone</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item 37\" id=\"item-active\" data-name=\"37\" data-englishname=\"leader_uid\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 163px; top: 0px;\"><span>团长ID:$leader_uid</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item 35\" id=\"item-active\" data-name=\"35\" data-englishname=\"leader_name\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 162px; top: 22px;\"><span>团长姓名:$leader_name</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item 34\" id=\"item-active\" data-name=\"34\" data-englishname=\"leader_nickname\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 163px; top: 42px;\"><span>团长昵称:$leader_nickname</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item 36\" id=\"item-active\" data-name=\"36\" data-englishname=\"leader_phone\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 163px; top: 65px;\"><span>团长电话:$leader_phone</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item 69\" id=\"item-active\" data-name=\"69\" data-englishname=\"leader_addr\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 0px; top: 86px;\"><span>取货点:$leader_addr</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item 38\" id=\"item-active\" data-name=\"38\" data-englishname=\"leader_area_name\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 162px; top: 91px;\"><span>团长小区:$leader_area_name</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item 40\" id=\"item-active\" data-name=\"40\" data-englishname=\"express_type\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 0px; top: 115px;\"><span>配送方式:$express_type</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item 39\" id=\"item-active\" data-name=\"39\" data-englishname=\"leader_city\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 162px; top: 114px;\"><span>团长城市:$leader_city</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item item-table\" data-name=\"name-table\" style=\"left: 0px; top: 143px; position: absolute; cursor: move; z-index: 0;\" l_zoom_mode=\"auto\"><table style=\"white-space:normal;border:1px solid black;\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\"><tbody><tr><th data-englishname=\"goods_id\" style=\"border:1px solid black;padding:10px;\">商品ID</th><th data-englishname=\"goods_code\" style=\"border:1px solid black;padding:10px;\">货号</th><th data-englishname=\"short_name\" style=\"border:1px solid black;padding:10px;\">短标题</th><th data-englishname=\"label\" style=\"border:1px solid black;padding:10px;\">标签</th><th data-englishname=\"property\" style=\"border:1px solid black;padding:10px;\">规格</th><th data-englishname=\"number\" style=\"border:1px solid black;padding:10px;\">数量</th><th data-englishname=\"price\" style=\"border:1px solid black;padding:10px;\">单价</th></tr></tbody></table><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item 19 item-active\" id=\"item-active\" data-name=\"19\" data-englishname=\"widget_name\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 0px; top: 63px;\"><span>商家名称:$widget_name</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div></div>', `width` = 378.00, `height` = 980.00, `remark` = NULL, `status` = 1, `admin_remark` = NULL, `create_time` = 1562233324, `update_time` = 1588062284, `delete_time` = NULL WHERE `id` = 1;
UPDATE `system_diy_express_template` SET `name` = '发货单', `english_name` = 'Invoice', `appid` = 2, `keywords_ids` = '[{\"name\":\"商家信息\",\"id\":\"2\",\"type\":\"0\",\"child\":[{\"name\":\"商家姓名\",\"id\":\"70\",\"parentId\":\"2\",\"pic_url\":\"\",\"english_name\":\"merchant_name\"},{\"name\":\"商家地址\",\"id\":\"21\",\"parentId\":\"2\",\"pic_url\":\"\",\"english_name\":\"merchant_addr\"},{\"name\":\"商家电话\",\"id\":\"20\",\"parentId\":\"2\",\"pic_url\":\"\",\"english_name\":\"merchant_phone\"},{\"name\":\"商家名称\",\"id\":\"19\",\"parentId\":\"2\",\"pic_url\":\"\",\"english_name\":\"widget_name\"}]},{\"name\":\"表格信息\",\"id\":\"3\",\"type\":\"1\",\"child\":[{\"name\":\"商品ID\",\"id\":\"67\",\"parentId\":\"3\",\"pic_url\":\"\",\"english_name\":\"goods_id\"},{\"name\":\"规格\",\"id\":\"66\",\"parentId\":\"3\",\"pic_url\":\"\",\"english_name\":\"property\"},{\"name\":\"单价\",\"id\":\"7\",\"parentId\":\"3\",\"pic_url\":\"\",\"english_name\":\"price\"},{\"name\":\"数量\",\"id\":\"4\",\"parentId\":\"3\",\"pic_url\":\"\",\"english_name\":\"number\"},{\"name\":\"商品名称\",\"id\":\"2\",\"parentId\":\"3\",\"pic_url\":\"\",\"english_name\":\"goodsname\"}]},{\"name\":\"买家信息\",\"id\":\"4\",\"type\":\"0\",\"child\":[{\"name\":\"预约送货时间\",\"id\":\"74\",\"parentId\":\"4\",\"pic_url\":\"\",\"english_name\":\"estimated_service_time\"},{\"name\":\"买家电话\",\"id\":\"9\",\"parentId\":\"4\",\"pic_url\":\"\",\"english_name\":\"phone\"},{\"name\":\"买家姓名\",\"id\":\"6\",\"parentId\":\"4\",\"pic_url\":\"\",\"english_name\":\"name\"},{\"name\":\"买家区域\",\"id\":\"33\",\"parentId\":\"4\",\"pic_url\":\"\",\"english_name\":\"buyer_area\"},{\"name\":\"买家城市\",\"id\":\"32\",\"parentId\":\"4\",\"pic_url\":\"\",\"english_name\":\"buyer_city\"},{\"name\":\"买家留言\",\"id\":\"31\",\"parentId\":\"4\",\"pic_url\":\"\",\"english_name\":\"remark\"},{\"name\":\"实付金额\",\"id\":\"29\",\"parentId\":\"4\",\"pic_url\":\"\",\"english_name\":\"payment_money\"},{\"name\":\"订单号\",\"id\":\"28\",\"parentId\":\"4\",\"pic_url\":\"\",\"english_name\":\"order_sn\"},{\"name\":\"买家地址\",\"id\":\"26\",\"parentId\":\"4\",\"pic_url\":\"\",\"english_name\":\"address\"}]},{\"name\":\"团长信息\",\"id\":\"5\",\"type\":\"0\",\"child\":[{\"name\":\"路线\",\"id\":\"41\",\"parentId\":\"5\",\"pic_url\":\"\",\"english_name\":\"route\"},{\"name\":\"配送方式\",\"id\":\"40\",\"parentId\":\"5\",\"pic_url\":\"\",\"english_name\":\"express_type\"},{\"name\":\"团长城市\",\"id\":\"39\",\"parentId\":\"5\",\"pic_url\":\"\",\"english_name\":\"leader_city\"},{\"name\":\"团长小区\",\"id\":\"38\",\"parentId\":\"5\",\"pic_url\":\"\",\"english_name\":\"leader_area_name\"},{\"name\":\"取货点\",\"id\":\"69\",\"parentId\":\"5\",\"pic_url\":\"\",\"english_name\":\"leader_addr\"},{\"name\":\"团长ID\",\"id\":\"37\",\"parentId\":\"5\",\"pic_url\":\"\",\"english_name\":\"leader_uid\"},{\"name\":\"团长电话\",\"id\":\"36\",\"parentId\":\"5\",\"pic_url\":\"\",\"english_name\":\"leader_phone\"},{\"name\":\"团长姓名\",\"id\":\"35\",\"parentId\":\"5\",\"pic_url\":\"\",\"english_name\":\"leader_name\"},{\"name\":\"团长昵称\",\"id\":\"34\",\"parentId\":\"5\",\"pic_url\":\"\",\"english_name\":\"leader_nickname\"}]},{\"name\":\"图片信息\",\"id\":\"6\",\"type\":\"2\",\"child\":[{\"name\":\"小程序码\",\"id\":\"24\",\"parentId\":\"6\",\"pic_url\":\"https://imgs.juanpao.com/admin%2Fprint%2F15622281435d1db5af6d82a.jpeg\",\"english_name\":\"widget_code\"},{\"name\":\"LOGO\",\"id\":\"23\",\"parentId\":\"6\",\"pic_url\":\"https://imgs.juanpao.com/admin%2Fprint%2F15622281705d1db5ca42e1b.jpeg\",\"english_name\":\"logo\"}]}]', `keywrod_info` = '[{\"id\":2,\"name\":\"商家信息\",\"type\":0,\"child\":[{\"id\":\"70\",\"name\":\"商家姓名\",\"pic_url\":\"\",\"parentId\":\"2\",\"english_name\":\"merchant_name\"},{\"id\":\"20\",\"name\":\"商家电话\",\"pic_url\":\"\",\"parentId\":\"2\",\"english_name\":\"merchant_phone\"},{\"id\":\"21\",\"name\":\"商家地址\",\"pic_url\":\"\",\"parentId\":\"2\",\"english_name\":\"merchant_addr\"},{\"id\":\"19\",\"name\":\"商家名称\",\"pic_url\":\"\",\"parentId\":\"2\",\"english_name\":\"widget_name\"}]},{\"id\":4,\"name\":\"买家信息\",\"type\":0,\"child\":[{\"id\":\"9\",\"name\":\"买家电话\",\"pic_url\":\"\",\"parentId\":\"4\",\"english_name\":\"phone\"},{\"id\":\"6\",\"name\":\"买家姓名\",\"pic_url\":\"\",\"parentId\":\"4\",\"english_name\":\"name\"},{\"id\":\"33\",\"name\":\"买家区域\",\"pic_url\":\"\",\"parentId\":\"4\",\"english_name\":\"buyer_area\"},{\"id\":\"32\",\"name\":\"买家城市\",\"pic_url\":\"\",\"parentId\":\"4\",\"english_name\":\"buyer_city\"},{\"id\":\"26\",\"name\":\"买家地址\",\"pic_url\":\"\",\"parentId\":\"4\",\"english_name\":\"address\"},{\"id\":\"31\",\"name\":\"买家留言\",\"pic_url\":\"\",\"parentId\":\"4\",\"english_name\":\"remark\"},{\"id\":\"29\",\"name\":\"实付金额\",\"pic_url\":\"\",\"parentId\":\"4\",\"english_name\":\"payment_money\"}]},{\"id\":5,\"name\":\"团长信息\",\"type\":0,\"child\":[{\"id\":\"40\",\"name\":\"配送方式\",\"pic_url\":\"\",\"parentId\":\"5\",\"english_name\":\"express_type\"}]},{\"id\":3,\"name\":\"表格信息\",\"type\":1,\"child\":[{\"id\":\"67\",\"name\":\"商品ID\",\"pic_url\":\"\",\"parentId\":\"3\",\"english_name\":\"goods_id\"},{\"id\":\"2\",\"name\":\"商品名称\",\"pic_url\":\"\",\"parentId\":\"3\",\"english_name\":\"goodsname\"},{\"id\":\"66\",\"name\":\"规格\",\"pic_url\":\"\",\"parentId\":\"3\",\"english_name\":\"property\"},{\"id\":\"7\",\"name\":\"单价\",\"pic_url\":\"\",\"parentId\":\"3\",\"english_name\":\"price\"},{\"id\":\"4\",\"name\":\"数量\",\"pic_url\":\"\",\"parentId\":\"3\",\"english_name\":\"number\"}]}]', `info` = '<div class=\"edit-box\" style=\"width: 380px; height: 682px;\">\n					<div class=\"item 70\" id=\"item-active\" data-name=\"70\" data-englishname=\"merchant_name\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 0px; top: 24px;\"><span>商家姓名:$merchant_name</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item 20\" id=\"item-active\" data-name=\"20\" data-englishname=\"merchant_phone\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 173px; top: 25px;\"><span>商家电话:$merchant_phone</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item 21\" id=\"item-active\" data-name=\"21\" data-englishname=\"merchant_addr\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 0px; top: 47px;\"><span>商家地址:$merchant_addr</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item 9\" id=\"item-active\" data-name=\"9\" data-englishname=\"phone\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 173px; top: 69px;\"><span>买家电话:$phone</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item 6\" id=\"item-active\" data-name=\"6\" data-englishname=\"name\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 0px; top: 68px;\"><span>买家姓名:$name</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item 33\" id=\"item-active\" data-name=\"33\" data-englishname=\"buyer_area\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 0px; top: 92px;\"><span>买家区域:$buyer_area</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item 32\" id=\"item-active\" data-name=\"32\" data-englishname=\"buyer_city\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 171px; top: 91px;\"><span>买家城市:$buyer_city</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item 26\" id=\"item-active\" data-name=\"26\" data-englishname=\"address\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 0px; top: 116px;\"><span>买家地址:$address</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item 40\" id=\"item-active\" data-name=\"40\" data-englishname=\"express_type\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 171px; top: 117px;\"><span>配送方式:$express_type</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item 31\" id=\"item-active\" data-name=\"31\" data-englishname=\"remark\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 0px; top: 137px;\"><span>买家留言:$remark</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item 29\" id=\"item-active\" data-name=\"29\" data-englishname=\"payment_money\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 169px; top: 136px;\"><span>实付金额:$payment_money</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item item-table\" data-name=\"name-table\" style=\"left: 4px; top: 171px; position: absolute; cursor: move; z-index: 0; width: 369px;\" l_zoom_mode=\"auto\"><table style=\"white-space:normal;border:1px solid black;\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\"><tbody><tr><th data-englishname=\"goods_id\" style=\"border:1px solid black;padding:10px;\">商品ID</th><th data-englishname=\"goodsname\" style=\"border:1px solid black;padding:10px;\">商品名称</th><th data-englishname=\"property\" style=\"border:1px solid black;padding:10px;\">规格</th><th data-englishname=\"price\" style=\"border:1px solid black;padding:10px;\">单价</th><th data-englishname=\"number\" style=\"border:1px solid black;padding:10px;\">数量</th></tr></tbody></table><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item 19 item-active\" id=\"item-active\" data-name=\"19\" data-englishname=\"widget_name\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 92px; top: 3px;\"><span>商家名称:$widget_name</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div></div>', `width` = 378.00, `height` = 680.00, `remark` = NULL, `status` = 1, `admin_remark` = NULL, `create_time` = 1562233713, `update_time` = 1594777804, `delete_time` = NULL WHERE `id` = 2;
UPDATE `system_diy_express_template` SET `name` = '采购单', `english_name` = 'purchasing_order', `appid` = 2, `keywords_ids` = '[{\"name\":\"商家信息\",\"id\":\"2\",\"type\":\"0\",\"child\":[{\"name\":\"商家姓名\",\"id\":\"70\",\"parentId\":\"2\",\"pic_url\":\"\",\"english_name\":\"merchant_name\"},{\"name\":\"商家地址\",\"id\":\"21\",\"parentId\":\"2\",\"pic_url\":\"\",\"english_name\":\"merchant_addr\"},{\"name\":\"商家电话\",\"id\":\"20\",\"parentId\":\"2\",\"pic_url\":\"\",\"english_name\":\"merchant_phone\"},{\"name\":\"商家名称\",\"id\":\"19\",\"parentId\":\"2\",\"pic_url\":\"\",\"english_name\":\"widget_name\"}]},{\"name\":\"表格信息\",\"id\":\"3\",\"type\":\"1\",\"child\":[{\"name\":\"货号\",\"id\":\"68\",\"parentId\":\"3\",\"pic_url\":\"\",\"english_name\":\"goods_code\"},{\"name\":\"商品ID\",\"id\":\"67\",\"parentId\":\"3\",\"pic_url\":\"\",\"english_name\":\"goods_id\"},{\"name\":\"规格\",\"id\":\"66\",\"parentId\":\"3\",\"pic_url\":\"\",\"english_name\":\"property\"},{\"name\":\"单价\",\"id\":\"7\",\"parentId\":\"3\",\"pic_url\":\"\",\"english_name\":\"price\"},{\"name\":\"数量\",\"id\":\"4\",\"parentId\":\"3\",\"pic_url\":\"\",\"english_name\":\"number\"},{\"name\":\"商品名称\",\"id\":\"2\",\"parentId\":\"3\",\"pic_url\":\"\",\"english_name\":\"goodsname\"},{\"name\":\"标签\",\"id\":\"16\",\"parentId\":\"3\",\"pic_url\":\"\",\"english_name\":\"label\"},{\"name\":\"短标题\",\"id\":\"17\",\"parentId\":\"3\",\"pic_url\":\"\",\"english_name\":\"short_name\"}]},{\"name\":\"图片信息\",\"id\":\"6\",\"type\":\"2\",\"child\":[{\"name\":\"小程序码\",\"id\":\"24\",\"parentId\":\"6\",\"pic_url\":\"https://imgs.juanpao.com/admin%2Fprint%2F15622281435d1db5af6d82a.jpeg\",\"english_name\":\"widget_code\"},{\"name\":\"LOGO\",\"id\":\"23\",\"parentId\":\"6\",\"pic_url\":\"https://imgs.juanpao.com/admin%2Fprint%2F15622281705d1db5ca42e1b.jpeg\",\"english_name\":\"logo\"}]}]', `keywrod_info` = '[{\"id\":3,\"name\":\"表格信息\",\"type\":1,\"child\":[{\"id\":\"67\",\"name\":\"商品ID\",\"pic_url\":\"\",\"parentId\":\"3\",\"english_name\":\"goods_id\"},{\"id\":\"68\",\"name\":\"货号\",\"pic_url\":\"\",\"parentId\":\"3\",\"english_name\":\"goods_code\"},{\"id\":\"17\",\"name\":\"短标题\",\"pic_url\":\"\",\"parentId\":\"3\",\"english_name\":\"short_name\"},{\"id\":\"16\",\"name\":\"标签\",\"pic_url\":\"\",\"parentId\":\"3\",\"english_name\":\"label\"},{\"id\":\"66\",\"name\":\"规格\",\"pic_url\":\"\",\"parentId\":\"3\",\"english_name\":\"property\"},{\"id\":\"4\",\"name\":\"数量\",\"pic_url\":\"\",\"parentId\":\"3\",\"english_name\":\"number\"},{\"id\":\"7\",\"name\":\"单价\",\"pic_url\":\"\",\"parentId\":\"3\",\"english_name\":\"price\"}]},{\"id\":2,\"name\":\"商家信息\",\"type\":0,\"child\":[{\"id\":\"19\",\"name\":\"商家名称\",\"pic_url\":\"\",\"parentId\":\"2\",\"english_name\":\"widget_name\"}]}]', `info` = '<div class=\"edit-box\" style=\"width: 380px; height: 682px;\">\n					<div class=\"item 19\" id=\"item-active\" data-name=\"19\" data-englishname=\"widget_name\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 98px; top: 15px;\"><span>商家名称:$widget_name</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item item-table item-active\" data-name=\"name-table\" style=\"left: 0px; top: 48px; position: absolute; cursor: move;\" l_zoom_mode=\"auto\"><table style=\"white-space:normal;border:1px solid black;\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\"><tbody><tr><th data-englishname=\"goods_id\" style=\"border:1px solid black;padding:10px;\">商品ID</th><th data-englishname=\"goods_code\" style=\"border:1px solid black;padding:10px;\">货号</th><th data-englishname=\"short_name\" style=\"border:1px solid black;padding:10px;\">短标题</th><th data-englishname=\"label\" style=\"border:1px solid black;padding:10px;\">标签</th><th data-englishname=\"property\" style=\"border:1px solid black;padding:10px;\">规格</th><th data-englishname=\"number\" style=\"border:1px solid black;padding:10px;\">数量</th><th data-englishname=\"price\" style=\"border:1px solid black;padding:10px;\">单价</th></tr></tbody></table><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div></div>', `width` = 378.00, `height` = 680.00, `remark` = NULL, `status` = 1, `admin_remark` = NULL, `create_time` = 1562233991, `update_time` = 1591262596, `delete_time` = NULL WHERE `id` = 3;
UPDATE `system_diy_express_template` SET `name` = '配货单', `english_name` = 'distribution_bill', `appid` = 2, `keywords_ids` = '[{\"name\":\"商品信息\",\"id\":\"1\",\"type\":\"0\",\"child\":[{\"name\":\"货号\",\"id\":\"46\",\"parentId\":\"1\",\"pic_url\":\"\",\"english_name\":\"goods_code\"},{\"name\":\"商品ID\",\"id\":\"45\",\"parentId\":\"1\",\"pic_url\":\"\",\"english_name\":\"goods_id\"},{\"name\":\"规格\",\"id\":\"44\",\"parentId\":\"1\",\"pic_url\":\"\",\"english_name\":\"property\"},{\"name\":\"短标题\",\"id\":\"43\",\"parentId\":\"1\",\"pic_url\":\"\",\"english_name\":\"short_name\"},{\"name\":\"标签\",\"id\":\"42\",\"parentId\":\"1\",\"pic_url\":\"\",\"english_name\":\"label\"},{\"name\":\"单价\",\"id\":\"8\",\"parentId\":\"1\",\"pic_url\":\"\",\"english_name\":\"price\"},{\"name\":\"数量\",\"id\":\"3\",\"parentId\":\"1\",\"pic_url\":\"\",\"english_name\":\"number\"},{\"name\":\"商品名称\",\"id\":\"1\",\"parentId\":\"1\",\"pic_url\":\"\",\"english_name\":\"goodsname\"}]},{\"name\":\"商家信息\",\"id\":\"2\",\"type\":\"0\",\"child\":[{\"name\":\"商家姓名\",\"id\":\"70\",\"parentId\":\"2\",\"pic_url\":\"\",\"english_name\":\"merchant_name\"},{\"name\":\"商家地址\",\"id\":\"21\",\"parentId\":\"2\",\"pic_url\":\"\",\"english_name\":\"merchant_addr\"},{\"name\":\"商家电话\",\"id\":\"20\",\"parentId\":\"2\",\"pic_url\":\"\",\"english_name\":\"merchant_phone\"},{\"name\":\"商家名称\",\"id\":\"19\",\"parentId\":\"2\",\"pic_url\":\"\",\"english_name\":\"widget_name\"}]},{\"name\":\"表格信息\",\"id\":\"3\",\"type\":\"1\",\"child\":[{\"name\":\"取货点\",\"id\":\"71\",\"parentId\":\"3\",\"pic_url\":\"\",\"english_name\":\"leader_addr\"},{\"name\":\"路线\",\"id\":\"65\",\"parentId\":\"3\",\"pic_url\":\"\",\"english_name\":\"route\"},{\"name\":\"配送方式\",\"id\":\"64\",\"parentId\":\"3\",\"pic_url\":\"\",\"english_name\":\"express_type\"},{\"name\":\"团长城市\",\"id\":\"63\",\"parentId\":\"3\",\"pic_url\":\"\",\"english_name\":\"leader_city\"},{\"name\":\"团长小区\",\"id\":\"62\",\"parentId\":\"3\",\"pic_url\":\"\",\"english_name\":\"leader_area_name\"},{\"name\":\"团长ID\",\"id\":\"61\",\"parentId\":\"3\",\"pic_url\":\"\",\"english_name\":\"leader_uid\"},{\"name\":\"团长电话\",\"id\":\"60\",\"parentId\":\"3\",\"pic_url\":\"\",\"english_name\":\"leader_phone\"},{\"name\":\"团长昵称\",\"id\":\"59\",\"parentId\":\"3\",\"pic_url\":\"\",\"english_name\":\"leader_nickname\"},{\"name\":\"数量\",\"id\":\"4\",\"parentId\":\"3\",\"pic_url\":\"\",\"english_name\":\"number\"},{\"name\":\"团长姓名\",\"id\":\"18\",\"parentId\":\"3\",\"pic_url\":\"\",\"english_name\":\"leader_name\"}]}]', `keywrod_info` = '[{\"id\":1,\"name\":\"商品信息\",\"type\":0,\"child\":[{\"id\":\"45\",\"name\":\"商品ID\",\"pic_url\":\"\",\"parentId\":\"1\",\"english_name\":\"goods_id\"},{\"id\":\"46\",\"name\":\"货号\",\"pic_url\":\"\",\"parentId\":\"1\",\"english_name\":\"goods_code\"},{\"id\":\"1\",\"name\":\"商品名称\",\"pic_url\":\"\",\"parentId\":\"1\",\"english_name\":\"goodsname\"},{\"id\":\"43\",\"name\":\"短标题\",\"pic_url\":\"\",\"parentId\":\"1\",\"english_name\":\"short_name\"},{\"id\":\"42\",\"name\":\"标签\",\"pic_url\":\"\",\"parentId\":\"1\",\"english_name\":\"label\"},{\"id\":\"44\",\"name\":\"规格\",\"pic_url\":\"\",\"parentId\":\"1\",\"english_name\":\"property\"},{\"id\":\"3\",\"name\":\"数量\",\"pic_url\":\"\",\"parentId\":\"1\",\"english_name\":\"number\"},{\"id\":\"8\",\"name\":\"单价\",\"pic_url\":\"\",\"parentId\":\"1\",\"english_name\":\"price\"}]},{\"id\":3,\"name\":\"表格信息\",\"type\":1,\"child\":[{\"id\":\"65\",\"name\":\"路线\",\"pic_url\":\"\",\"parentId\":\"3\",\"english_name\":\"route\"},{\"id\":\"61\",\"name\":\"团长ID\",\"pic_url\":\"\",\"parentId\":\"3\",\"english_name\":\"leader_uid\"},{\"id\":\"62\",\"name\":\"团长小区\",\"pic_url\":\"\",\"parentId\":\"3\",\"english_name\":\"leader_area_name\"},{\"id\":\"71\",\"name\":\"取货点\",\"pic_url\":\"\",\"parentId\":\"3\",\"english_name\":\"leader_addr\"},{\"id\":\"18\",\"name\":\"团长姓名\",\"pic_url\":\"\",\"parentId\":\"3\",\"english_name\":\"leader_name\"},{\"id\":\"60\",\"name\":\"团长电话\",\"pic_url\":\"\",\"parentId\":\"3\",\"english_name\":\"leader_phone\"}]}]', `info` = '<div class=\"edit-box\" style=\"width: 380px; height: 682px;\">\n					<div class=\"item 45\" id=\"item-active\" data-name=\"45\" data-englishname=\"goods_id\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 0px; top: 0px;\"><span>商品ID:$goods_id</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item 46\" id=\"item-active\" data-name=\"46\" data-englishname=\"goods_code\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 0px; top: 52px;\"><span>货号:$goods_code</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item 1\" id=\"item-active\" data-name=\"1\" data-englishname=\"goodsname\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 175px; top: 0px;\"><span>商品名称:$goodsname</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item 43\" id=\"item-active\" data-name=\"43\" data-englishname=\"short_name\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 177px; top: 26px;\"><span>短标题:$short_name</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item 42\" id=\"item-active\" data-name=\"42\" data-englishname=\"label\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 0px; top: 27px;\"><span>标签:$label</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item 44\" id=\"item-active\" data-name=\"44\" data-englishname=\"property\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 176px; top: 54px;\"><span>规格:$property</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item 3\" id=\"item-active\" data-name=\"3\" data-englishname=\"number\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 0px; top: 80px;\"><span>数量:$number</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item 8\" id=\"item-active\" data-name=\"8\" data-englishname=\"price\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 173px; top: 80px;\"><span>单价:$price</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item item-table item-active\" data-name=\"name-table\" style=\"left: 0px; top: 108px; position: absolute; cursor: move; z-index: 0;\" l_zoom_mode=\"auto\"><table style=\"white-space:normal;border:1px solid black;\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\"><tbody><tr><th data-englishname=\"route\" style=\"border:1px solid black;padding:10px;\">路线</th><th data-englishname=\"leader_uid\" style=\"border:1px solid black;padding:10px;\">团长ID</th><th data-englishname=\"leader_area_name\" style=\"border:1px solid black;padding:10px;\">团长小区</th><th data-englishname=\"leader_addr\" style=\"border:1px solid black;padding:10px;\">取货点</th><th data-englishname=\"leader_name\" style=\"border:1px solid black;padding:10px;\">团长姓名</th><th data-englishname=\"leader_phone\" style=\"border:1px solid black;padding:10px;\">团长电话</th></tr></tbody></table><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div></div>', `width` = 378.00, `height` = 680.00, `remark` = NULL, `status` = 1, `admin_remark` = NULL, `create_time` = 1562234447, `update_time` = 1588062480, `delete_time` = NULL WHERE `id` = 4;
UPDATE `system_diy_express_template` SET `name` = '团长路线单', `english_name` = 'leader_route', `appid` = 2, `keywords_ids` = '[{\"name\":\"商家信息\",\"id\":\"2\",\"type\":\"0\",\"child\":[{\"name\":\"商家姓名\",\"id\":\"70\",\"parentId\":\"2\",\"pic_url\":\"\",\"english_name\":\"merchant_name\"},{\"name\":\"商家地址\",\"id\":\"21\",\"parentId\":\"2\",\"pic_url\":\"\",\"english_name\":\"merchant_addr\"},{\"name\":\"商家电话\",\"id\":\"20\",\"parentId\":\"2\",\"pic_url\":\"\",\"english_name\":\"merchant_phone\"},{\"name\":\"商家名称\",\"id\":\"19\",\"parentId\":\"2\",\"pic_url\":\"\",\"english_name\":\"widget_name\"}]},{\"name\":\"表格信息\",\"id\":\"3\",\"type\":\"1\",\"child\":[{\"name\":\"取货点\",\"id\":\"71\",\"parentId\":\"3\",\"pic_url\":\"\",\"english_name\":\"leader_addr\"},{\"name\":\"团长小区\",\"id\":\"62\",\"parentId\":\"3\",\"pic_url\":\"\",\"english_name\":\"leader_area_name\"},{\"name\":\"团长电话\",\"id\":\"60\",\"parentId\":\"3\",\"pic_url\":\"\",\"english_name\":\"leader_phone\"},{\"name\":\"团长姓名\",\"id\":\"18\",\"parentId\":\"3\",\"pic_url\":\"\",\"english_name\":\"leader_name\"}]},{\"name\":\"团长信息\",\"id\":\"5\",\"type\":\"0\",\"child\":[{\"name\":\"路线\",\"id\":\"41\",\"parentId\":\"5\",\"pic_url\":\"\",\"english_name\":\"route\"}]},{\"name\":\"图片信息\",\"id\":\"6\",\"type\":\"2\",\"child\":[{\"name\":\"小程序码\",\"id\":\"24\",\"parentId\":\"6\",\"pic_url\":\"https://imgs.juanpao.com/admin%2Fprint%2F15622281435d1db5af6d82a.jpeg\",\"english_name\":\"widget_code\"},{\"name\":\"LOGO\",\"id\":\"23\",\"parentId\":\"6\",\"pic_url\":\"https://imgs.juanpao.com/admin%2Fprint%2F15622281705d1db5ca42e1b.jpeg\",\"english_name\":\"logo\"}]}]', `keywrod_info` = '[{\"id\":2,\"name\":\"商家信息\",\"type\":0,\"child\":[{\"id\":\"70\",\"name\":\"商家姓名\",\"pic_url\":\"\",\"parentId\":\"2\",\"english_name\":\"merchant_name\"},{\"id\":\"21\",\"name\":\"商家地址\",\"pic_url\":\"\",\"parentId\":\"2\",\"english_name\":\"merchant_addr\"},{\"id\":\"20\",\"name\":\"商家电话\",\"pic_url\":\"\",\"parentId\":\"2\",\"english_name\":\"merchant_phone\"},{\"id\":\"19\",\"name\":\"商家名称\",\"pic_url\":\"\",\"parentId\":\"2\",\"english_name\":\"widget_name\"}]},{\"id\":3,\"name\":\"表格信息\",\"type\":1,\"child\":[{\"id\":\"18\",\"name\":\"团长姓名\",\"pic_url\":\"\",\"parentId\":\"3\",\"english_name\":\"leader_name\"},{\"id\":\"60\",\"name\":\"团长电话\",\"pic_url\":\"\",\"parentId\":\"3\",\"english_name\":\"leader_phone\"},{\"id\":\"62\",\"name\":\"团长小区\",\"pic_url\":\"\",\"parentId\":\"3\",\"english_name\":\"leader_area_name\"},{\"id\":\"71\",\"name\":\"取货点\",\"pic_url\":\"\",\"parentId\":\"3\",\"english_name\":\"leader_addr\"}]},{\"id\":5,\"name\":\"团长信息\",\"type\":0,\"child\":[{\"id\":\"41\",\"name\":\"路线\",\"pic_url\":\"\",\"parentId\":\"5\",\"english_name\":\"route\"}]}]', `info` = '<div class=\"edit-box\" style=\"width: 380px; height: 682px;\">\n					<div class=\"item 70\" id=\"item-active\" data-name=\"70\" data-englishname=\"merchant_name\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 8px; top: 36px;\"><span>商家姓名:$merchant_name</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item 21\" id=\"item-active\" data-name=\"21\" data-englishname=\"merchant_addr\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 184px; top: 40px;\"><span>商家地址:$merchant_addr</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item 20\" id=\"item-active\" data-name=\"20\" data-englishname=\"merchant_phone\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 6px; top: 62px;\"><span>商家电话:$merchant_phone</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item 41\" id=\"item-active\" data-name=\"41\" data-englishname=\"route\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 133px; top: 9px;\"><span>路线:$route</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item item-table\" data-name=\"name-table\" style=\"left: 4px; top: 92px; position: absolute; cursor: move; z-index: 0;\" l_zoom_mode=\"auto\"><table style=\"white-space:normal;border:1px solid black;\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\"><tbody><tr><th data-englishname=\"leader_name\" style=\"border:1px solid black;padding:10px;\">团长姓名</th><th data-englishname=\"leader_phone\" style=\"border:1px solid black;padding:10px;\">团长电话</th><th data-englishname=\"leader_area_name\" style=\"border:1px solid black;padding:10px;\">团长小区</th><th data-englishname=\"leader_addr\" style=\"border:1px solid black;padding:10px;\">取货点</th></tr></tbody></table><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item 19 item-active\" id=\"item-active\" data-name=\"19\" data-englishname=\"widget_name\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 181px; top: 63px;\"><span>商家名称:$widget_name</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div></div>', `width` = 378.00, `height` = 680.00, `remark` = NULL, `status` = 1, `admin_remark` = NULL, `create_time` = 1562234501, `update_time` = 1588062521, `delete_time` = NULL WHERE `id` = 5;
UPDATE `system_diy_express_template` SET `name` = '仓库路线单', `english_name` = 'warehouse_route', `appid` = 2, `keywords_ids` = '[{\"name\":\"商家信息\",\"id\":\"2\",\"type\":\"0\",\"child\":[{\"name\":\"商家姓名\",\"id\":\"70\",\"parentId\":\"2\",\"pic_url\":\"\",\"english_name\":\"merchant_name\"},{\"name\":\"商家地址\",\"id\":\"21\",\"parentId\":\"2\",\"pic_url\":\"\",\"english_name\":\"merchant_addr\"},{\"name\":\"商家电话\",\"id\":\"20\",\"parentId\":\"2\",\"pic_url\":\"\",\"english_name\":\"merchant_phone\"},{\"name\":\"商家名称\",\"id\":\"19\",\"parentId\":\"2\",\"pic_url\":\"\",\"english_name\":\"widget_name\"}]},{\"name\":\"表格信息\",\"id\":\"3\",\"type\":\"1\",\"child\":[{\"name\":\"仓库地址\",\"id\":\"73\",\"parentId\":\"3\",\"pic_url\":\"\",\"english_name\":\"warehouse_addr\"},{\"name\":\"仓库名称\",\"id\":\"72\",\"parentId\":\"3\",\"pic_url\":\"\",\"english_name\":\"warehouse_name\"}]},{\"name\":\"团长信息\",\"id\":\"5\",\"type\":\"0\",\"child\":[{\"name\":\"路线\",\"id\":\"41\",\"parentId\":\"5\",\"pic_url\":\"\",\"english_name\":\"route\"}]},{\"name\":\"图片信息\",\"id\":\"6\",\"type\":\"2\",\"child\":[{\"name\":\"小程序码\",\"id\":\"24\",\"parentId\":\"6\",\"pic_url\":\"https://imgs.juanpao.com/admin%2Fprint%2F15622281435d1db5af6d82a.jpeg\",\"english_name\":\"widget_code\"},{\"name\":\"LOGO\",\"id\":\"23\",\"parentId\":\"6\",\"pic_url\":\"https://imgs.juanpao.com/admin%2Fprint%2F15622281705d1db5ca42e1b.jpeg\",\"english_name\":\"logo\"}]}]', `keywrod_info` = '[{\"id\":5,\"name\":\"团长信息\",\"type\":0,\"child\":[{\"id\":\"41\",\"name\":\"路线\",\"pic_url\":\"\",\"parentId\":\"5\",\"english_name\":\"route\"}]},{\"id\":2,\"name\":\"商家信息\",\"type\":0,\"child\":[{\"id\":\"70\",\"name\":\"商家姓名\",\"pic_url\":\"\",\"parentId\":\"2\",\"english_name\":\"merchant_name\"},{\"id\":\"21\",\"name\":\"商家地址\",\"pic_url\":\"\",\"parentId\":\"2\",\"english_name\":\"merchant_addr\"},{\"id\":\"20\",\"name\":\"商家电话\",\"pic_url\":\"\",\"parentId\":\"2\",\"english_name\":\"merchant_phone\"},{\"id\":\"19\",\"name\":\"商家名称\",\"pic_url\":\"\",\"parentId\":\"2\",\"english_name\":\"widget_name\"}]},{\"id\":3,\"name\":\"表格信息\",\"type\":1,\"child\":[{\"id\":\"72\",\"name\":\"仓库名称\",\"pic_url\":\"\",\"parentId\":\"3\",\"english_name\":\"warehouse_name\"},{\"id\":\"73\",\"name\":\"仓库地址\",\"pic_url\":\"\",\"parentId\":\"3\",\"english_name\":\"warehouse_addr\"}]}]', `info` = '<div class=\"edit-box\" style=\"width: 380px; height: 682px;\">\n					<div class=\"item 41\" id=\"item-active\" data-name=\"41\" data-englishname=\"route\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 141px; top: 12px;\"><span>路线:$route</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item 70\" id=\"item-active\" data-name=\"70\" data-englishname=\"merchant_name\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 7px; top: 38px;\"><span>商家姓名:$merchant_name</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item 21\" id=\"item-active\" data-name=\"21\" data-englishname=\"merchant_addr\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 182px; top: 37px;\"><span>商家地址:$merchant_addr</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item 20\" id=\"item-active\" data-name=\"20\" data-englishname=\"merchant_phone\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 6px; top: 58px;\"><span>商家电话:$merchant_phone</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item item-table\" data-name=\"name-table\" style=\"left: 8px; top: 89px; position: absolute; cursor: move; z-index: 0;\" l_zoom_mode=\"auto\"><table style=\"white-space:normal;border:1px solid black;\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\"><tbody><tr><th data-englishname=\"warehouse_name\" style=\"border:1px solid black;padding:10px;\">仓库名称</th><th data-englishname=\"warehouse_addr\" style=\"border:1px solid black;padding:10px;\">仓库地址</th></tr></tbody></table><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item 19 item-active\" id=\"item-active\" data-name=\"19\" data-englishname=\"widget_name\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 181px; top: 60px;\"><span>商家名称:$widget_name</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div></div>', `width` = 378.00, `height` = 680.00, `remark` = NULL, `status` = 1, `admin_remark` = NULL, `create_time` = 1587368291, `update_time` = 1588062544, `delete_time` = NULL WHERE `id` = 7;
INSERT INTO `system_diy_express_template` VALUES (7, '仓库路线单', 'warehouse_route', 2, '[{\"name\":\"商家信息\",\"id\":\"2\",\"type\":\"0\",\"child\":[{\"name\":\"商家姓名\",\"id\":\"70\",\"parentId\":\"2\",\"pic_url\":\"\",\"english_name\":\"merchant_name\"},{\"name\":\"商家地址\",\"id\":\"21\",\"parentId\":\"2\",\"pic_url\":\"\",\"english_name\":\"merchant_addr\"},{\"name\":\"商家电话\",\"id\":\"20\",\"parentId\":\"2\",\"pic_url\":\"\",\"english_name\":\"merchant_phone\"},{\"name\":\"商家名称\",\"id\":\"19\",\"parentId\":\"2\",\"pic_url\":\"\",\"english_name\":\"widget_name\"}]},{\"name\":\"表格信息\",\"id\":\"3\",\"type\":\"1\",\"child\":[{\"name\":\"仓库地址\",\"id\":\"73\",\"parentId\":\"3\",\"pic_url\":\"\",\"english_name\":\"warehouse_addr\"},{\"name\":\"仓库名称\",\"id\":\"72\",\"parentId\":\"3\",\"pic_url\":\"\",\"english_name\":\"warehouse_name\"}]},{\"name\":\"团长信息\",\"id\":\"5\",\"type\":\"0\",\"child\":[{\"name\":\"路线\",\"id\":\"41\",\"parentId\":\"5\",\"pic_url\":\"\",\"english_name\":\"route\"}]},{\"name\":\"图片信息\",\"id\":\"6\",\"type\":\"2\",\"child\":[{\"name\":\"小程序码\",\"id\":\"24\",\"parentId\":\"6\",\"pic_url\":\"https://imgs.juanpao.com/admin%2Fprint%2F15622281435d1db5af6d82a.jpeg\",\"english_name\":\"widget_code\"},{\"name\":\"LOGO\",\"id\":\"23\",\"parentId\":\"6\",\"pic_url\":\"https://imgs.juanpao.com/admin%2Fprint%2F15622281705d1db5ca42e1b.jpeg\",\"english_name\":\"logo\"}]}]', '[{\"id\":5,\"name\":\"团长信息\",\"type\":0,\"child\":[{\"id\":\"41\",\"name\":\"路线\",\"pic_url\":\"\",\"parentId\":\"5\",\"english_name\":\"route\"}]},{\"id\":2,\"name\":\"商家信息\",\"type\":0,\"child\":[{\"id\":\"70\",\"name\":\"商家姓名\",\"pic_url\":\"\",\"parentId\":\"2\",\"english_name\":\"merchant_name\"},{\"id\":\"21\",\"name\":\"商家地址\",\"pic_url\":\"\",\"parentId\":\"2\",\"english_name\":\"merchant_addr\"},{\"id\":\"20\",\"name\":\"商家电话\",\"pic_url\":\"\",\"parentId\":\"2\",\"english_name\":\"merchant_phone\"},{\"id\":\"19\",\"name\":\"商家名称\",\"pic_url\":\"\",\"parentId\":\"2\",\"english_name\":\"widget_name\"}]},{\"id\":3,\"name\":\"表格信息\",\"type\":1,\"child\":[{\"id\":\"72\",\"name\":\"仓库名称\",\"pic_url\":\"\",\"parentId\":\"3\",\"english_name\":\"warehouse_name\"},{\"id\":\"73\",\"name\":\"仓库地址\",\"pic_url\":\"\",\"parentId\":\"3\",\"english_name\":\"warehouse_addr\"}]}]', '<div class=\"edit-box\" style=\"width: 380px; height: 682px;\">\n					<div class=\"item 41\" id=\"item-active\" data-name=\"41\" data-englishname=\"route\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 141px; top: 12px;\"><span>路线:$route</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item 70\" id=\"item-active\" data-name=\"70\" data-englishname=\"merchant_name\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 7px; top: 38px;\"><span>商家姓名:$merchant_name</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item 21\" id=\"item-active\" data-name=\"21\" data-englishname=\"merchant_addr\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 182px; top: 37px;\"><span>商家地址:$merchant_addr</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item 20\" id=\"item-active\" data-name=\"20\" data-englishname=\"merchant_phone\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 6px; top: 58px;\"><span>商家电话:$merchant_phone</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item item-table\" data-name=\"name-table\" style=\"left: 8px; top: 89px; position: absolute; cursor: move; z-index: 0;\" l_zoom_mode=\"auto\"><table style=\"white-space:normal;border:1px solid black;\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\"><tbody><tr><th data-englishname=\"warehouse_name\" style=\"border:1px solid black;padding:10px;\">仓库名称</th><th data-englishname=\"warehouse_addr\" style=\"border:1px solid black;padding:10px;\">仓库地址</th></tr></tbody></table><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div><div class=\"item 19 item-active\" id=\"item-active\" data-name=\"19\" data-englishname=\"widget_name\" l_zoom_mode=\"auto\" style=\"position: absolute; cursor: move; z-index: 0; left: 181px; top: 60px;\"><span>商家名称:$widget_name</span><div class=\"zoom_right\"></div><div class=\"zoom_rb\"></div><div class=\"zoom_bottom\"></div></div></div>', 378.00, 680.00, NULL, 1, NULL, 1587368291, 1588062544, NULL);
CREATE TABLE `shop_recommend_goods`  (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  `key` char(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '唯一标识符',
  `merchant_id` int(11) NOT NULL COMMENT '商户id',
  `supplier_id` int(10) NOT NULL DEFAULT 0 COMMENT '供应商id，0为系统',
  `config` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '推荐商品信息(json)',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '修改时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '推荐商品表' ROW_FORMAT = Compact;
ALTER TABLE `system_app_access` ADD COLUMN `is_show_supplier_goods`  int(1) NOT NULL DEFAULT 0 COMMENT '是否显示门店商品' AFTER `commissions`;
CREATE TABLE `shop_advance_sale` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `key` char(6) NOT NULL COMMENT '唯一标识符',
  `merchant_id` int(11) NOT NULL COMMENT '商户id',
  `supplier_id` int(11) NOT NULL,
  `name` varchar(128) NOT NULL COMMENT '预售名称',
  `detail_info` varchar(512) NOT NULL DEFAULT '' COMMENT '预售描述',
  `preheat_time` int(11) NOT NULL COMMENT '预热开始时间',
  `start_time` int(11) NOT NULL COMMENT '开始售卖时间',
  `end_time` int(11) NOT NULL COMMENT '结束售卖时间',
  `pay_start_time` int(11) NOT NULL COMMENT '付款开始时间',
  `pay_end_time` int(11) NOT NULL COMMENT '付款结束时间',
  `goods_id` varchar(256) NOT NULL COMMENT '商品id',
  `front_money` float(10,2) NOT NULL DEFAULT '0.00',
  `deduction` float(10,2) NOT NULL DEFAULT '0.00' COMMENT '抵扣金额',
  `goods_info` varchar(512) NOT NULL COMMENT '商品信息',
  `is_refund` int(1) NOT NULL DEFAULT '0' COMMENT '0=不退款 1退款',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态 1有效 0无效',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '修改时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='商品-预售';
ALTER TABLE `system_sub_admin` ADD COLUMN `yly_print` tinyint(1) NOT NULL DEFAULT 0 COMMENT '门店小票自动打印开关  0=关闭 1=开启' AFTER `leader`;
ALTER TABLE system_sub_admin DROP COLUMN `yly_config`;
ALTER TABLE `shop_ylyprint` ADD COLUMN `supplier_id` int(11) NOT NULL DEFAULT 0 COMMENT '门店id' AFTER `merchant_id`;
ALTER TABLE `shop_ylyprint` ADD COLUMN `type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '类型 1=易联云 2=飞鹅云' AFTER `partner`;
ALTER TABLE `shop_ylyprint` MODIFY COLUMN `partner` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '易联云用户id' AFTER `msign`;
ALTER TABLE `shop_tuan_warehouse` ADD COLUMN `houses`  varchar(200) NOT NULL  COMMENT '仓库id' AFTER `name`;
ALTER TABLE `shop_tuan_warehouse` ADD COLUMN `leaders` varchar(200) NOT NULL  COMMENT '团长id' AFTER `name`;
ALTER TABLE `shop_tuan_warehouse` MODIFY COLUMN `leaders`  varchar(200) NOT NULL AFTER `merchant_id`;
ALTER TABLE `shop_tuan_warehouse` MODIFY COLUMN `houses` varchar(200) NOT NULL  COMMENT '团长id' AFTER `name`;
UPDATE `shop_tuan_warehouse` SET `leaders`='',`houses`='' WHERE leaders=0 or houses=0;
ALTER TABLE `shop_bargain_info` MODIFY COLUMN `goods_price`  float(11,2) NOT NULL COMMENT '当前商品价格' AFTER `stock_id`, MODIFY COLUMN `price`  float(11,2) NOT NULL COMMENT '砍的价格' AFTER `goods_price`;
ALTER TABLE `shop_goods` ADD COLUMN `is_advance_sale`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否预售商品' AFTER `is_cart`;
ALTER TABLE `shop_goods` ADD COLUMN `is_parcel`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否单独包邮' AFTER `is_cart`;
ALTER TABLE `system_express`ADD COLUMN `abbreviation_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '拼音名称（阿里云）' AFTER `simple_name`;
UPDATE `system_express` SET `name` = '顺丰速运', `simple_name` = 'SF', `abbreviation_name` = 'shunfeng', `phone` = '', `img_url` = '', `url` = '', `remarks` = '', `is_ok` = 1, `status` = 1, `create_time` = 1540524600, `update_time` = NULL, `delete_time` = NULL WHERE `id` = 1;
UPDATE `system_express` SET `name` = '百世快递', `simple_name` = 'HTKY', `abbreviation_name` = 'huitong', `phone` = '', `img_url` = '', `url` = '', `remarks` = '', `is_ok` = 1, `status` = 1, `create_time` = 1540524600, `update_time` = NULL, `delete_time` = NULL WHERE `id` = 2;
UPDATE `system_express` SET `name` = '中通快递', `simple_name` = 'ZTO', `abbreviation_name` = 'zhongtong', `phone` = '', `img_url` = '', `url` = '', `remarks` = '', `is_ok` = 1, `status` = 1, `create_time` = 1540524600, `update_time` = NULL, `delete_time` = NULL WHERE `id` = 3;
UPDATE `system_express` SET `name` = '申通快递', `simple_name` = 'STO', `abbreviation_name` = 'shentong', `phone` = '', `img_url` = '', `url` = '', `remarks` = '', `is_ok` = 1, `status` = 1, `create_time` = 1540524600, `update_time` = NULL, `delete_time` = NULL WHERE `id` = 4;
UPDATE `system_express` SET `name` = '圆通速递', `simple_name` = 'YTO', `abbreviation_name` = 'yuantong', `phone` = '', `img_url` = '', `url` = '', `remarks` = '', `is_ok` = 1, `status` = 1, `create_time` = 1540524600, `update_time` = NULL, `delete_time` = NULL WHERE `id` = 5;
UPDATE `system_express` SET `name` = '韵达速递', `simple_name` = 'YD', `abbreviation_name` = 'yunda', `phone` = '', `img_url` = '', `url` = '', `remarks` = '', `is_ok` = 1, `status` = 1, `create_time` = 1540524600, `update_time` = NULL, `delete_time` = NULL WHERE `id` = 6;
UPDATE `system_express` SET `name` = '邮政快递包裹', `simple_name` = 'YZPY', `abbreviation_name` = 'pingyou', `phone` = '', `img_url` = '', `url` = '', `remarks` = '', `is_ok` = 1, `status` = 1, `create_time` = 1540524600, `update_time` = NULL, `delete_time` = NULL WHERE `id` = 7;
UPDATE `system_express` SET `name` = 'EMS', `simple_name` = 'EMS', `abbreviation_name` = 'emsen', `phone` = '', `img_url` = '', `url` = '', `remarks` = '', `is_ok` = 1, `status` = 1, `create_time` = 1540524600, `update_time` = NULL, `delete_time` = NULL WHERE `id` = 8;
UPDATE `system_express` SET `name` = '天天快递', `simple_name` = 'HHTT', `abbreviation_name` = 'tiantian', `phone` = '', `img_url` = '', `url` = '', `remarks` = '', `is_ok` = 1, `status` = 1, `create_time` = 1540524600, `update_time` = NULL, `delete_time` = NULL WHERE `id` = 9;
UPDATE `system_express` SET `name` = '京东快递', `simple_name` = 'JD', `abbreviation_name` = 'jingdong', `phone` = '', `img_url` = '', `url` = '', `remarks` = '', `is_ok` = 1, `status` = 1, `create_time` = 1540524600, `update_time` = NULL, `delete_time` = NULL WHERE `id` = 10;
UPDATE `system_express` SET `name` = '优速快递', `simple_name` = 'UC', `abbreviation_name` = 'yousu', `phone` = '', `img_url` = '', `url` = '', `remarks` = '', `is_ok` = 1, `status` = 1, `create_time` = 1540524600, `update_time` = NULL, `delete_time` = NULL WHERE `id` = 11;
UPDATE `system_express` SET `name` = '德邦快递', `simple_name` = 'DBL', `abbreviation_name` = 'debang', `phone` = '', `img_url` = '', `url` = '', `remarks` = '', `is_ok` = 1, `status` = 1, `create_time` = 1540524600, `update_time` = NULL, `delete_time` = NULL WHERE `id` = 12;
UPDATE `system_express` SET `name` = '宅急送', `simple_name` = 'ZJS', `abbreviation_name` = 'zhaijisong', `phone` = '', `img_url` = '', `url` = '', `remarks` = '', `is_ok` = 1, `status` = 1, `create_time` = 1540524600, `update_time` = NULL, `delete_time` = NULL WHERE `id` = 13;
UPDATE `system_express` SET `name` = '安能物流', `simple_name` = 'ANE', `abbreviation_name` = 'anneng', `phone` = '', `img_url` = '', `url` = '', `remarks` = '', `is_ok` = 1, `status` = 1, `create_time` = 1540524600, `update_time` = NULL, `delete_time` = NULL WHERE `id` = 25;
UPDATE `system_express` SET `name` = '国通快递', `simple_name` = 'GTO', `abbreviation_name` = 'guotong', `phone` = '', `img_url` = '', `url` = '', `remarks` = '', `is_ok` = 1, `status` = 1, `create_time` = 1540524600, `update_time` = NULL, `delete_time` = NULL WHERE `id` = 68;
UPDATE `system_express` SET `name` = '龙邦快递', `simple_name` = 'LB', `abbreviation_name` = 'longbang', `phone` = '', `img_url` = '', `url` = '', `remarks` = '', `is_ok` = 1, `status` = 1, `create_time` = 1540524600, `update_time` = NULL, `delete_time` = NULL WHERE `id` = 107;
UPDATE `system_express` SET `name` = '品骏快递', `simple_name` = 'PJ', `abbreviation_name` = 'pjbest', `phone` = '', `img_url` = '', `url` = '', `remarks` = '', `is_ok` = 1, `status` = 1, `create_time` = 1540524600, `update_time` = NULL, `delete_time` = NULL WHERE `id` = 120;
UPDATE `system_express` SET `name` = '速尔快递', `simple_name` = 'SURE', `abbreviation_name` = 'sure', `phone` = '', `img_url` = '', `url` = '', `remarks` = '', `is_ok` = 1, `status` = 1, `create_time` = 1540524600, `update_time` = NULL, `delete_time` = NULL WHERE `id` = 142;
UPDATE `system_express` SET `name` = '全一快递', `simple_name` = 'UAPEX', `abbreviation_name` = 'quanyi', `phone` = '', `img_url` = '', `url` = '', `remarks` = '', `is_ok` = 1, `status` = 1, `create_time` = 1540524600, `update_time` = NULL, `delete_time` = NULL WHERE `id` = 150;
UPDATE `system_express` SET `name` = '信丰物流', `simple_name` = 'XFEX', `abbreviation_name` = 'xinfeng', `phone` = '', `img_url` = '', `url` = '', `remarks` = '', `is_ok` = 1, `status` = 1, `create_time` = 1540524600, `update_time` = NULL, `delete_time` = NULL WHERE `id` = 161;
UPDATE `system_express` SET `name` = '远成物流', `simple_name` = 'YCWL', `abbreviation_name` = 'ycgky', `phone` = '', `img_url` = '', `url` = '', `remarks` = '', `is_ok` = 1, `status` = 1, `create_time` = 1540524600, `update_time` = NULL, `delete_time` = NULL WHERE `id` = 165;
UPDATE `system_express` SET `name` = '中铁快运', `simple_name` = 'ZTKY', `abbreviation_name` = 'zhongtie', `phone` = '', `img_url` = '', `url` = '', `remarks` = '', `is_ok` = 0, `status` = 1, `create_time` = 1540524600, `update_time` = NULL, `delete_time` = NULL WHERE `id` = 185;
ALTER TABLE `system_logistics_config` MODIFY COLUMN `type` int(5) NOT NULL DEFAULT 1 COMMENT '类型 1=快递鸟  2=阿里云' AFTER `config`;
ALTER TABLE `shop_goods`ADD COLUMN `label_id`  varchar(50) NOT NULL COMMENT '标签id' AFTER `label`;
CREATE TABLE `shop_goods_label` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `key` varchar(8) NOT NULL,
  `merchant_id` int(8) NOT NULL DEFAULT '0',
  `supplier_id` int(8) NOT NULL DEFAULT '0',
  `title` varchar(10) NOT NULL,
  `status` int(1) NOT NULL DEFAULT '1' COMMENT '0未开启 1开启',
  `create_time` varchar(12) NOT NULL,
  `update_time` varchar(12) DEFAULT NULL,
  `delete_time` varchar(12) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `shop_order_group` ADD COLUMN `modify_price` decimal(8,2) NULL DEFAULT 0 COMMENT '卖家修改后原付款价格' AFTER `payment_money`;
ALTER TABLE `shop_after_info`ADD COLUMN `user_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '姓名' AFTER `merchant_id`;
ALTER TABLE `shop_express_template`ADD COLUMN `supplier_id` int(10) NOT NULL DEFAULT 0 COMMENT '门店id（非门店为0）' AFTER `merchant_id`;
ALTER TABLE `shop_express_template_details`ADD COLUMN `supplier_id` int(10) NOT NULL DEFAULT 0 COMMENT '门店id（非门店为0）' AFTER `merchant_id`;
ALTER TABLE `shop_electronics` MODIFY COLUMN `phone` char(11) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '发件人手机' AFTER `tel`;
ALTER TABLE `system_app_access`ADD COLUMN `open_advertisement` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '开屏广告信息（json）' AFTER `thum_width`;
ALTER TABLE `shop_goods`ADD COLUMN `is_cart` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否允许加入购物车，1允许 0不允许 为0时只能单独购买' AFTER `regimental_only`;
ALTER TABLE `system_sub_admin`ADD COLUMN `sort`  int(4) NOT NULL AFTER `status`;
ALTER TABLE `shop_order_group` ADD COLUMN `leader_money` float(8,2) NOT NULL AFTER `commissions_pool`;
ALTER TABLE `shop_live` ADD COLUMN `share_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '分享图链接' AFTER `anchor_name`;
ALTER TABLE `system_merchant_design` ADD COLUMN `bg_color` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '#F2F2F2' COMMENT '背景色' AFTER `info`;
ALTER TABLE `shop_tuan_leader` ADD COLUMN `level_reward_ratio`  float(8,2) NOT NULL AFTER `recommend_uid`;
DROP TABLE IF EXISTS `shop_ylyprint_template`;
CREATE TABLE `shop_ylyprint_template`  (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  `key` char(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '唯一标识符',
  `merchant_id` int(11) NOT NULL COMMENT '商户id',
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字段名称',
  `sign` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字段标识',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态 1启用 0关闭',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '修改时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '易联云小票模板表' ROW_FORMAT = Compact;
INSERT INTO `shop_ylyprint_template` VALUES (1, 'ccvWPn', 13, '店铺名称', 'shop_name', 1, 1586856861, 1586859610, NULL);
INSERT INTO `shop_ylyprint_template` VALUES (2, 'ccvWPn', 13, '订单时间', 'order_time', 1, 1586856938, 1586856938, NULL);
INSERT INTO `shop_ylyprint_template` VALUES (3, 'ccvWPn', 13, '订单编号', 'order_sn', 1, 1586858701, 1586858701, NULL);
INSERT INTO `shop_ylyprint_template` VALUES (4, 'ccvWPn', 13, '商品', 'goods', 1, 1586858745, 1586858745, NULL);
INSERT INTO `shop_ylyprint_template` VALUES (5, 'ccvWPn', 13, '小计', 'total_price', 1, 1586858813, 1586858813, NULL);
INSERT INTO `shop_ylyprint_template` VALUES (6, 'ccvWPn', 13, '运费', 'express_price', 1, 1586858827, 1586858827, NULL);
INSERT INTO `shop_ylyprint_template` VALUES (7, 'ccvWPn', 13, '折扣', 'voucher_price', 1, 1586858844, 1586858844, NULL);
INSERT INTO `shop_ylyprint_template` VALUES (8, 'ccvWPn', 13, '订单总价', 'payment_money', 1, 1586858864, 1586858864, NULL);
INSERT INTO `shop_ylyprint_template` VALUES (9, 'ccvWPn', 13, '买家姓名', 'buyer_name', 1, 1586858914, 1586858914, NULL);
INSERT INTO `shop_ylyprint_template` VALUES (10, 'ccvWPn', 13, '买家电话', 'buyer_phone', 1, 1586858939, 1586858939, NULL);
INSERT INTO `shop_ylyprint_template` VALUES (11, 'ccvWPn', 13, '买家地址', 'buyer_address', 1, 1586858954, 1586858954, NULL);
INSERT INTO `shop_ylyprint_template` VALUES (12, 'ccvWPn', 13, '买家备注', 'buyer_remark', 1, 1586858970, 1586858970, NULL);
INSERT INTO `shop_ylyprint_template` VALUES (13, 'ccvWPn', 13, '商家备注', 'merchant_remark', 1, 1586859001, 1586859001, NULL);
INSERT INTO `shop_ylyprint_template` VALUES (14, 'ccvWPn', 13, '团长姓名', 'leader_name', 1, 1586859055, 1586859055, NULL);
INSERT INTO `shop_ylyprint_template` VALUES (15, 'ccvWPn', 13, '团长电话', 'leader_phone', 1, 1586859071, 1586859071, NULL);
INSERT INTO `shop_ylyprint_template` VALUES (16, 'ccvWPn', 13, '团长地址', 'leader_address', 1, 1586859100, 1586859100, NULL);
INSERT INTO `shop_ylyprint_template` VALUES (17, 'ccvWPn', 13, '团长小区', 'leader_area', 1, 1586859148, 1586863724, NULL);
ALTER TABLE `shop_stock` MODIFY COLUMN `weight`  double(10,2) NOT NULL DEFAULT 0.00 COMMENT '商品重量' AFTER `code`;
CREATE TABLE `system_sms_template_access`  (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  `phone` char(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '手机号',
  `template_id` int(11) NOT NULL DEFAULT 0 COMMENT '短信模板id',
  `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '短信参数',
  `type` int(5) NOT NULL DEFAULT 0 COMMENT '短信类型 1=商家发货提醒',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '修改时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '模板短信记录表' ROW_FORMAT = Compact;
CREATE TABLE `system_sms_template_id`  (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  `config` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '模板id信息(json)',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '修改时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '短信模板ID表' ROW_FORMAT = Compact;
CREATE TABLE `shop_menu` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `name` varchar(125) NOT NULL,
  `path` varchar(125) NOT NULL,
  `hidden` tinyint(1) NOT NULL,
  `pid` int(8) NOT NULL,
  `create_time` int(11) NOT NULL,
  `update_time` int(11) DEFAULT NULL,
  `delete_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `shop_menu` VALUES ('1', '', '/login', '1', '0', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('2', '', '/404', '1', '0', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('3', '', '/', '1', '0', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('4', '应用列表', '/', '0', '3', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('5', '应用信息', '/appinfo', '0', '3', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('6', '', '/info/updatePW', '1', '0', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('7', '修改密码', '/', '0', '6', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('8', '总览', '/dashboard', '0', '0', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('9', '数据概览', '/dashboard', '0', '8', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('10', '升级日志', '/upgrade', '0', '8', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('11', '商品', '/goods/list', '0', '0', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('12', '商品列表', '/goods/list', '0', '11', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('13', '商品分组', '/goods/group', '0', '11', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('14', '回收站', '/goods/recyclebin', '0', '11', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('15', '商品添加', '/goods/add', '1', '11', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('16', '订单', '/order/manage', '0', '0', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('17', '订单管理', '/order/manage', '0', '16', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('18', '订单概述', '/order/summary', '0', '16', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('19', '评价管理', '/order/comment', '0', '16', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('20', '订单配送', '/order/print', '0', '16', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('21', '会员', '/vip/list', '0', '0', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('22', '会员列表', '/vip/list', '0', '21', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('23', '会员等级', '/vip/unpay', '0', '21', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('24', '团长', '/customers/head', '0', '0', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('25', '团长', '/customers/head', '0', '24', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('26', '团长审核', '/customers/audit', '0', '24', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('27', '团长等级', '/customers/leave', '0', '24', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('28', '路线', '/customers/warehouse', '0', '24', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('29', '设置', '/setting/tuanconfig', '0', '24', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('30', '佣金流水', '/finance/record', '0', '24', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('31', '分销', '/subCommission/setting', '0', '0', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('32', '超级会员', '/subCommission/setting', '0', '31', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('33', '代理商', '/subCommission/agent', '0', '31', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('34', '运营商', '/subCommission/operator', '0', '31', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('35', '佣金记录', '/subCommission/record', '0', '31', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('36', '会员审核', '/subCommission/upUser', '0', '31', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('37', '设置', '/subCommission/distribution', '0', '31', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('38', '分销商', '/subCommission/distributors', '0', '31', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('39', '应用', '/marketing/index', '0', '0', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('40', '应用管理', '/marketing/index', '0', '39', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('41', '优惠券', '/marketing/coupon', '1', '39', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('42', '购物返现', '/marketing/buyCashback', '1', '39', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('43', '秒杀', '/marketing/seckill', '1', '39', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('44', '签到', '/marketing/singin', '1', '39', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('45', '订阅信息', '/marketing/apptamplate', '1', '39', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('46', '拼团', '/marketing/assemble', '1', '39', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('47', '充值', '/marketing/pay', '1', '39', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('48', '砍价', '/marketing/bargain', '1', '39', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('49', '满减', '/marketing/reduction', '1', '39', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('50', '新人专享', '/marketing/recuits', '1', '39', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('51', '积分商城', '/marketing/score', '1', '39', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('52', '预约送达', '/marketing/estimated', '1', '39', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('53', '会员PLUS', '/vip/pay', '1', '39', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('54', '自定义版权', '/marketing/copyright', '1', '39', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('55', '数据', '/finance/apply', '0', '0', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('56', '提现申请', '/finance/apply', '0', '55', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('57', '销售统计', '/statistics/sales', '0', '55', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('58', '商品销售统计', '/statistics/goodsSales', '0', '55', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('59', '团长销售统计', '/statistics/leaderSales', '0', '55', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('60', '用户排行统计', '/statistics/userSales', '0', '55', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('61', '仓库', '/warehouse/list', '0', '0', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('62', '仓库管理', '/warehouse/list', '0', '61', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('63', '配送小区', '/warehouse/warehouseLeader', '0', '61', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('64', '入库管理', '/warehouse/inComings', '0', '61', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('65', '入库新增', '/warehouse/inComings/add', '1', '61', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('66', '入库详情', '/warehouse/inComings/info', '1', '61', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('67', '入库查询', '/warehouse/inComingsSearch', '0', '61', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('68', '出库管理', '/warehouse/outbounds', '0', '61', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('69', '出库新增', '/warehouse/outbounds/add', '1', '61', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('70', '出库详情', '/warehouse/outbounds/info', '1', '61', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('71', '出库查询', '/warehouse/outboundsSearch', '0', '61', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('72', '盘点管理', '/warehouse/inventories', '0', '61', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('73', '盘点新增', '/warehouse/inventories/add', '1', '61', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('74', '盘点详情', '/warehouse/inventories/info', '1', '61', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('75', '现有库存', '/warehouse/realStock', '0', '61', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('76', '门店', '/supplier/apply', '0', '0', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('77', '申请列表', '/supplier/apply', '0', '76', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('78', '配置', '/supplier/supplierConfig', '0', '76', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('79', '门店', '/supplier/list', '0', '76', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('80', '商品', '/supplier/goods', '0', '76', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('81', '订单', '/supplier/order', '0', '76', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('82', '提现', '/supplier/withdrawal', '0', '76', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('83', '到店付款', '/marketing/PaymentInStore', '0', '76', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('84', '小程序', '/applet/baseconfig', '0', '0', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('85', '支付', '/applet/baseconfig', '0', '84', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('86', '权限', '/employee/manage', '0', '0', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('87', '员工管理', '/employee/manage', '0', '86', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('88', '角色管理', '/employee/role', '0', '86', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('89', '客服管理', '/employee/kefu', '0', '86', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('90', '设置', '/setting/appsetting', '0', '0', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('91', '基础设置', '/setting/appsetting', '0', '90', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('92', '运费模板', '/setting/express', '0', '90', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('93', '收货信息', '/setting/takegoods', '0', '90', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('94', '电子面单', '/setting/expressdoc', '0', '90', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('95', '页面配置', '/setting/viewconfig', '0', '90', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('96', 'UU跑腿', '/setting/uu', '0', '90', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('97', '点我达', '/setting/dianwoda', '0', '90', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('98', '小票打印', '/setting/yly', '0', '90', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('99', '分享海报', '/setting/posters', '0', '90', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('100', '常见问题', '/setting/help', '0', '90', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('101', '附件', '/setting/enclosure', '0', '90', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('102', '短信', '/setting/sms', '0', '90', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('103', '物流查询', '/setting/logistics', '0', '90', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('104', '日志', '/operationlog', '0', '0', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('105', '操作记录', '/operationlog', '0', '104', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('106', '装修', '/goToOld', '0', '0', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('107', '装修', '/goToOld', '0', '106', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('108', '直播', '/liveBroadcast', '1', '0', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('109', '直播', '/liveBroadcast', '0', '108', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('110', '积分商城', '/score/list/add', '1', '0', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('111', '积分商品添加', '/score/list/add', '0', '110', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('112', '未授权', '/didopen', '1', '0', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('113', '未授权', '/didopen', '0', '112', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('114', '', '*', '1', '0', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('115', '集团分组', '/goods/groupGrouping', '1', '11', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('116', '商品标签', '/goods/label', '1', '11', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('117', '商品推荐', '/marketing/recommend', '1', '39', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('118', '开屏广告', '/applet/openadvertising', '1', '84', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('119', '小程序上传', '/applet/upload', '1', '84', '1586418114', '1586418114', null);
INSERT INTO `shop_menu` VALUES ('120', '小票打印模板', '/setting/ylyTemplate', '1', '90', '1586418114', '1586418114', null);

ALTER TABLE `system_sms` DROP COLUMN `appid`;
ALTER TABLE `system_sms` DROP COLUMN `appkey`;
ALTER TABLE `system_sms` ADD COLUMN `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态 0=关闭 1=启用' AFTER `id`;
ALTER TABLE `system_sms` ADD COLUMN `type` int(5) NOT NULL DEFAULT 1 COMMENT '类型 1=腾讯云' AFTER `id`;
ALTER TABLE `system_sms` ADD COLUMN `config` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '短信配置(josn)' AFTER `id`;
ALTER TABLE `shop_user` ADD COLUMN `total_score` int(11) DEFAULT 0 COMMENT '总积分(计算积分等级不会减少)' AFTER `score`;
ALTER TABLE `system_sms` MODIFY COLUMN `type` int(5) NOT NULL DEFAULT 1 COMMENT '类型 1=腾讯云  2=阿里云' AFTER `config`;

CREATE TABLE `shop_live`  (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '直播房间名',
  `roomid` int(11) NOT NULL COMMENT '直播房间ID',
  `cover_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '封面图片地址',
  `start_time` int(11) NOT NULL COMMENT '直播计划开始时间',
  `end_time` int(11) NOT NULL COMMENT '直播计划结束时间',
  `anchor_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主播名',
  `goods` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品列表json',
  `live_status` int(5) NOT NULL COMMENT '直播状态 101: 直播中, 102: 未开始, 103: 已结束, 104: 禁播, 105: 暂停中, 106: 异常, 107: 已过期',
  `sort` int(3) NOT NULL DEFAULT 0 COMMENT '排序(0~999 越大排越前)',
  `replay` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '回放源视频(json)',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否在商品显示 0=否 1=是',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '修改时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '小程序直播房间表' ROW_FORMAT = Compact;
ALTER TABLE `shop_user` ADD COLUMN `check_time`  int(11) NULL AFTER `is_check`;
ALTER TABLE `shop_user` ADD COLUMN `reg_time`  int(11) NULL AFTER `is_check`;
ALTER TABLE `shop_stock` MODIFY COLUMN `pic_url`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '图片' AFTER `incoming_number`;

CREATE TABLE `system_logistics_config`  (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `config` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '配置信息(json)',
  `type` int(5) NOT NULL COMMENT '类型 1=快递鸟',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态 0=关闭 1=启用(全部关闭默认使用本地)',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '修改时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '物流查询api配置表' ROW_FORMAT = Compact;
ALTER TABLE `shop_tuan_leader` ADD `alipay_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '支付宝姓名';
ALTER TABLE `shop_tuan_leader` ADD `alipay_account` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '支付宝账号';
ALTER TABLE `shop_tuan_leader` ADD `bank_card_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '银行卡号';
ALTER TABLE `shop_tuan_leader` ADD `bank_card_branch` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '银行卡所属分行';
ALTER TABLE `shop_tuan_leader` ADD `name_of_cardholder` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '持卡人姓名';
ALTER TABLE `system_app_access` ADD `supplier_pic_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '门店海报';
ALTER TABLE `system_app_access` ADD `thum_is_open` tinyint(1) NOT NULL DEFAULT 0 COMMENT '缩略图开关  1为开启  0为关闭';
ALTER TABLE `system_app_access` ADD `thum_width` int(8) NOT NULL COMMENT '缩略图宽度（px）';

CREATE TABLE `system_pic_server` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `config` text CHARACTER SET utf8 NOT NULL COMMENT '服务器配置json',
  `type` int(5) NOT NULL COMMENT '类型 1=腾讯云 2=阿里云 3=七牛云',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态 0=关闭 1=启用(全部关闭默认使用本地)',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '修改时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='图片存储服务器';

ALTER TABLE `shop_picture` MODIFY COLUMN `pic_url` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '图片地址';
ALTER TABLE `shop_marchant_category` ADD COLUMN `supplier_id`  int(11) NOT NULL AFTER `merchant_id`;
ALTER TABLE `shop_flash_sale` ADD COLUMN `line_price`  decimal(10,2) NOT NULL AFTER `flash_price`;
ALTER TABLE `shop_express_template_details` MODIFY COLUMN `distance`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '距离价格' AFTER `expand_price`;
ALTER TABLE `shop_order_group` ADD `send_express_type` tinyint(1) DEFAULT NULL COMMENT '卖家实际发货方式 0=快递 1=本地配送';
CREATE TABLE `system_merchant_mini_subscribe_template`  (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `key` char(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '唯一标识符',
  `merchant_id` int(11) NOT NULL COMMENT '商户id',
  `template_id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '小程序订阅消息模板id',
  `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '小程序订阅消息模板名称',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '模板内容',
  `example` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '模板内容示例',
  `template_purpose` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '小程序模板用途,例:pay_order',
  `type` tinyint(1) NOT NULL DEFAULT 2 COMMENT '模版类型  2=一次性订阅 3=长期订阅',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 73 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统-小程序订阅消息模板表' ROW_FORMAT = Compact;

SET FOREIGN_KEY_CHECKS = 1;
CREATE TABLE `system_merchant_mini_subscribe_template_access`  (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `key` char(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '唯一标识符',
  `merchant_id` int(11) NOT NULL COMMENT '商户id',
  `mini_open_id` varchar(52) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用户id',
  `template_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '小程序订阅消息模板id',
  `number` tinyint(1) NOT NULL DEFAULT 0 COMMENT '发送次数 大于5次不操作',
  `template_params` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '参数信息',
  `template_purpose` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '小程序模板用途,例:pay_order',
  `page` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '跳转页',
  `status` tinyint(1) DEFAULT 1 COMMENT '用户状态 1=推送成功 -1=未推送  0=推送中 2=推送失败',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统-商户小程序订阅消息推送记录表' ROW_FORMAT = Compact;

SET FOREIGN_KEY_CHECKS = 1;

INSERT INTO `system_express` VALUES ('243', 'UU跑腿', 'UU', '', '', '', '', '', '0', '1', '1540524600', null, null);
INSERT INTO `system_express` VALUES ('244', '点我达', 'DWD', '', '', '', '', '', '0', '1', '1540524600', null, null);
INSERT INTO `system_express` VALUES ('245', '蜂鸟配送', 'FN', '', '', '', '', '', '0', '1', '1540524600', null, null);
ALTER TABLE `shop_assemble` ADD `assemble_group_discount` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '团长优惠比例';
ALTER TABLE `shop_assemble` COMMENT '商品拼团信息表';
ALTER TABLE `shop_assemble_access` COMMENT '拼团订单记录表';
ALTER TABLE `shop_user` ADD `level_id` int(8) DEFAULT 0 COMMENT '分销小等级ID';
ALTER TABLE `shop_user` ADD `up_level_id` int(8) DEFAULT 0 COMMENT '手动审核的分销小等级ID';
ALTER TABLE `shop_stock` ADD `assemble_price` decimal(10, 2) NOT NULL COMMENT '拼团价';
ALTER TABLE `shop_order_group` ADD `commissions_pool` decimal(11, 2) NOT NULL DEFAULT 0.00 COMMENT '未分配完的分销佣金';
ALTER TABLE `shop_distribution_access` MODIFY COLUMN `type` int(11) NOT NULL DEFAULT '1';
ALTER TABLE `shop_distribution_access` MODIFY COLUMN `type` int(11) NOT NULL DEFAULT '1' COMMENT '佣金来源 1=下线提佣 2=股权分佣 3=自购提佣 4=退款减佣';