shenying/update_2_6_0.sql

-- eb_system_config
INSERT INTO `eb_system_config` (`id`, `is_store`, `menu_name`, `type`, `input_type`, `config_tab_id`, `parameter`, `upload_type`, `required`, `width`, `high`, `value`, `info`, `desc`, `sort`, `status`) VALUES
(NULL, '0', 'reminder_deadline_second_card_time', 'text', 'number', 27, '', 0, '', 100, 0, '1', '次卡临期提醒', '次卡商品未核销临期提醒，单位（小时）', 0, 1);

-- 发货信息管理
INSERT INTO `eb_system_config` (`id`, `is_store`, `menu_name`, `type`, `input_type`, `config_tab_id`, `parameter`, `upload_type`, `required`, `width`, `high`, `value`, `info`, `desc`, `sort`, `status`) VALUES
(null, '0', 'order_shipping_open', 'radio', 'input', 7, '1=>开启\n0=>关闭', 1, '', 0, 0, '0', '小程序发货信息管理服务', '小程序有订单发货管理时，请打开此开关，否则会导致订单资金冻结', 0, 1);

-- 供应商财务设置
INSERT INTO `eb_system_config` (`id`, `is_store`, `menu_name`, `type`, `input_type`, `config_tab_id`, `parameter`, `upload_type`, `required`, `width`, `high`, `value`, `info`, `desc`, `sort`, `status`) VALUES
(NULL, 0, 'supplier_extract_min_price', 'text', 'input', 82, '', 1, '', 100, 0, '\"\"', '最低提现金额', '最低提现金额', 0, 1),
(NULL, 0, 'supplier_extract_max_price', 'text', 'input', 82, '', 1, '', 100, 0, '\"\"', '最高提现金额', '最高提现金额', 0, 1);

-- 小票打印设置
INSERT INTO `eb_system_config` (`id`, `is_store`, `menu_name`, `type`, `input_type`, `config_tab_id`, `parameter`, `upload_type`, `required`, `width`, `high`, `value`, `info`, `desc`, `sort`, `status`) VALUES
(NULL, 0, 'print_type', 'radio', 'input', 21, '1=>易联云\n2=>飞鹅云', 1, '', 0, 0, '\"1\"', '平台选择', '打印平台选择', 0, 1),
(NULL, 0, 'fey_user', 'text', 'input', 21, '', 1, '', 0, 0, '\"\"', '飞鹅云USER', '飞鹅云后台注册账号', 10, 1),
(NULL, 0, 'fey_ukey', 'text', 'input', 21, '', 1, '', 0, 0, '\"\"', '飞鹅云UYEK', '飞鹅云后台注册账号后生成的UKEY 【备注：这不是填打印机的KEY】', 7, 1),
(NULL, 0, 'fey_sn', 'text', 'input', 21, '', 1, '', 100, 0, '\"\"', '飞鹅云SN', '打印机标签上的编号，必须要在管理后台里添加打印机或调用API接口添加之后，才能调用API', 0, 1);

-- 小票打印门店设置
INSERT INTO `eb_system_config` (`id`, `is_store`, `menu_name`, `type`, `input_type`, `config_tab_id`, `parameter`, `upload_type`, `required`, `width`, `high`, `value`, `info`, `desc`, `sort`, `status`) VALUES
(NULL, 1, 'store_print_type', 'radio', 'input', 79, '1=>易联云\n2=>飞鹅云', 1, '', 0, 0, '\"1\"', '平台选择', '打印平台选择', 0, 1),
(NULL, 1, 'store_fey_user', 'text', 'input', 79, '', 1, '', 0, 0, '\"\"', '飞鹅云USER', '飞鹅云后台注册账号', 10, 1),
(NULL, 1, 'store_fey_ukey', 'text', 'input', 79, '', 1, '', 0, 0, '\"\"', '飞鹅云UYEK', '飞鹅云后台注册账号后生成的UKEY 【备注：这不是填打印机的KEY】', 7, 1),
(NULL, 1, 'store_fey_sn', 'text', 'input', 79, '', 1, '', 100, 0, '\"\"', '飞鹅云SN', '打印机标签上的编号，必须要在管理后台里添加打印机或调用API接口添加之后，才能调用API', 0, 1);

-- 积分抵扣上限类型
INSERT INTO `eb_system_config` (`id`, `is_store`, `menu_name`, `type`, `input_type`, `config_tab_id`, `parameter`, `upload_type`, `required`, `width`, `high`, `value`, `info`, `desc`, `sort`, `status`) VALUES
(NULL, 0, 'integral_max_type', 'radio', 'input', 11, '1=>最多抵扣积分\n2=>最高抵扣比例', 0, '', 100, 0, '\"1\"', '积分抵扣上限', '', 9, 1),
(NULL, 0, 'integral_max_rate', 'text', 'input', 11, '', 0, '', 100, 0, '\"0\"', '最高抵扣比例', '一笔订单最高可抵扣订单实付金额的百分比(0-100%),0不限制', 9, 1);

-- 用户协议配置
INSERT INTO `eb_system_config` (`id`, `is_store`, `menu_name`, `type`, `input_type`, `config_tab_id`, `parameter`, `upload_type`, `required`, `width`, `high`, `value`, `info`, `desc`, `sort`, `status`) VALUES
(NULL, 0, 'store_user_agreement', 'radio', 'input', 86, '1=>手动同意\n0=>自动同意', 0, '', 100, 0, '\"1\"', '用户协议', '授权登录用户协议1：需要用户手动同意0：表示默认自动同意', 9, 1),
(null, 0, 'routine_auth_type', 'checkbox', 'input', 86, '1=>微信授权\n2=>手机号登录', 1, '', 0, 0, '[\"1\",\"2\"]', '手机号获取方式', '小程序授权登录获取手机号的方式，微信授权和手机号验证码', 90, 1);

-- 修改存储配置
UPDATE `eb_system_config` SET `parameter` = '1=>本地存储\n2=>七牛云存储\n3=>阿里云OSS\n4=>腾讯COS\n5=>京东云存储\n6=>华为云存储\n7=>天翼云存储' WHERE `menu_name` = 'upload_type';
-- 存储配置
INSERT INTO `eb_system_config` (`id`, `is_store`, `menu_name`, `type`, `input_type`, `config_tab_id`, `parameter`, `upload_type`, `required`, `width`, `high`, `value`, `info`, `desc`, `sort`, `status`) VALUES
(NULL, 0, 'jd_accessKey', 'text', 'input', 17, '', 1, '', 100, 0, '\"\"', '京东云accessKey', '京东云accessKey', 0, 1),
(NULL, 0, 'jd_secretKey', 'text', 'input', 17, '', 1, '', 100, 0, '\"\"', '京东云secretKey', '京东云secretKey', 0, 1),
(NULL, 0, 'jd_storage_region', 'text', 'input', 17, '', 0, '', 100, 0, '\"\"', '京东云所属地域', '京东云所属地域', 0, 1),
(NULL, 0, 'hw_accessKey', 'text', 'input', 17, '', 1, '', 100, 0, '\"\"', '华为云accessKey', '华为云accessKey', 0, 1),
(NULL, 0, 'hw_secretKey', 'text', 'input', 17, '', 1, '', 100, 0, '\"\"', '华为云secretKey', '华为云secretKey', 0, 1),
(NULL, 0, 'ty_secretKey', 'text', 'input', 17, '', 1, '', 100, 0, '\"\"', '天翼云secretKey', '天翼云secretKey', 0, 1),
(NULL, 0, 'ty_accessKey', 'text', 'input', 17, '', 1, '', 100, 0, '\"\"', '天翼云accessKey', '天翼云accessKey', 0, 1);




INSERT INTO `eb_system_timer` (`name`, `mark`, `type`, `title`, `is_open`, `cycle`, `last_execution_time`, `update_execution_time`, `is_del`, `add_time`) VALUES
('次卡商品未核销短信提醒', 'reminder_unverified_remind', 1, '', 1, '30', 0, 0, 0, 1687242639);

-- 次卡提醒
INSERT INTO `eb_system_notification` (`id`, `mark`, `name`, `title`, `is_system`, `is_app`, `is_wechat`, `is_routine`, `is_sms`, `is_ent_wechat`, `system_title`, `system_text`, `app_id`, `wechat_id`, `routine_id`, `sms_id`, `ent_wechat_text`, `variable`, `url`, `type`, `add_time`) VALUES
(NULL, 'reminder_verification_status', '核销成功提醒', '购买虚拟商品给用户发送提醒', 1, 0, 0, 0, 1, 0, '核销成功提醒', '尊敬的顾客，您已成功核销商品： 商品名称：{store_name}; 核销日期：{write_time} 感谢您的支持！如有任何疑问，请联系我们的客服', 0, '0', '0', 947454, '', '', '', 1, 0),
(NULL, 'expiration_reminder', '过期提醒', '购买虚拟商品给用户发送提醒', 1, 0, 0, 0, 1, 0, '过期提醒', '尊敬的顾客，您购买的商品{store_name} 已过期，过期日期：{end_time} 感谢您的支持！如有任何疑问，请联系我们的客服。', 0, '0', '0', 947455, '', '', '', 1, 0),
(NULL, 'reminder_brink_death', '临期提醒', '账号异地登录给用户发送提醒', 1, 0, 0, 0, 1, 0, '过期提醒', '尊敬的顾客，您购买的商品{store_name} 购买日期：{pay_time} 有效期至：{end_time} 请您尽快使用，以免商品过期。如有任何疑问，请联系我们的客服。感谢您的支持！', 0, '0', '0', 947456, '', '', '', 1, 0),
(NULL, 'supplier_verify_success', '入驻审核通过通知', '供应商入驻审核通过提醒', 1, 0, 0, 0, 1, 0, '审核通过提醒', '您好，您{date}提交的{supplier}供应商入驻申请已通过，供应商账号：{phone}, 密码：{pwd}，请前往{site_name}商城查看。', 0, '0', '0', 947456, '', '', '', 1, 0),
(NULL, 'supplier_verify_fail', '入驻审核未通过通知', '供应商入驻未审核通过提醒', 1, 0, 0, 0, 1, 0, '审核未通过提醒', '您好，您{date}提交的{supplier}供应商入驻申请审核未通过，请前往{site_name}商城—供应商入驻页面查看。', 0, '0', '0', 947456, '', '', '', 1, 0);



-- 积分订单表
ALTER TABLE `eb_store_integral_order` ADD `trade_no` varchar(100) NOT NULL DEFAULT '' COMMENT '支付订单号' AFTER order_id;

-- 商品
ALTER TABLE `eb_store_product` ADD `video_open` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '商品视频是否开启' AFTER `soure_link`;
ALTER TABLE `eb_store_product`  ADD `show_type` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '展示：0:所有端1:移动端2:收银台'  AFTER `stock`;
-- UPDATE `eb_store_product` set `type` = 0, `relation_id` =0 where `type` = 2;

-- 商品规格增加结算价
ALTER TABLE `eb_store_product_attr_value` ADD `settle_price` DECIMAL(10,2) NOT NULL DEFAULT '0.00' COMMENT '结算价' AFTER `price`;

-- 商品规格加字段
ALTER TABLE `eb_store_product_rule` ADD `type` TINYINT(2) NOT NULL DEFAULT '0' COMMENT '商品所属：0：平台1:门店2:供应商' AFTER `id`;
ALTER TABLE `eb_store_product_rule` ADD `relation_id` INT(10) NOT NULL DEFAULT '0' COMMENT '关联门店、供应商ID'  AFTER `type`;

-- 运费模版加字段
ALTER TABLE `eb_shipping_templates` CHANGE `type` `group` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '计费方式1按件数,2按重量, 3按体积';
ALTER TABLE `eb_shipping_templates_free` CHANGE `type` `group` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '计费方式1按件数,2按重量, 3按体积';
ALTER TABLE `eb_shipping_templates_region` CHANGE `type` `group` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '计费方式1按件数,2按重量, 3按体积';
ALTER TABLE `eb_shipping_templates` ADD `type` TINYINT(2) NOT NULL DEFAULT '0' COMMENT '商品所属：0：平台1:门店2:供应商' AFTER `id`;
ALTER TABLE `eb_shipping_templates` ADD `relation_id` INT(10) NOT NULL DEFAULT '0' COMMENT '关联门店、供应商ID'  AFTER `type`;

-- 商品评价表修改
ALTER TABLE `eb_store_product_reply` CHANGE `type` `type` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '类型：0平台1:门店2:供应商' AFTER `oid`;
ALTER TABLE `eb_store_product_reply` CHANGE `store_id` `relation_id` INT(11) NOT NULL DEFAULT '0' COMMENT '门店、供应商id' AFTER `type`;
UPDATE  `eb_store_product_reply` set `type` = 1 where `relation_id` > 0;

-- 商品评价回复表修改
ALTER TABLE `eb_store_product_reply_comment` ADD `type` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '类型：0平台1:门店2:供应商' AFTER `id`;
ALTER TABLE `eb_store_product_reply_comment` CHANGE `store_id` `relation_id` INT(11) NOT NULL DEFAULT '0' COMMENT '门店、供应商id' AFTER `type`;
UPDATE  `eb_store_product_reply_comment` set `type` = 1 where `relation_id` > 0;

-- 商品保障表
ALTER TABLE `eb_store_product_ensure` CHANGE `type` `type` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '类型：0平台1:门店2:供应商' AFTER `id`;
ALTER TABLE `eb_store_product_ensure` CHANGE `store_id` `relation_id` INT(11) NOT NULL DEFAULT '0' COMMENT '门店、供应商id' AFTER `type`;
UPDATE  `eb_store_product_ensure` set `type` = 0 where `type` = 1;

-- 商品参数表
ALTER TABLE `eb_store_product_specs` CHANGE `type` `type` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '类型：0平台1:门店2:供应商' AFTER `id`;
ALTER TABLE `eb_store_product_specs` CHANGE `store_id` `relation_id` INT(11) NOT NULL DEFAULT '0' COMMENT '门店、供应商id' AFTER `type`;
UPDATE  `eb_store_product_specs` set `type` = 0 where `type` = 1;

-- 商品单位表
ALTER TABLE `eb_store_product_unit` ADD `type` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '类型：0平台1:门店2:供应商' AFTER `id`;
ALTER TABLE `eb_store_product_unit` CHANGE `store_id` `relation_id` INT(11) NOT NULL DEFAULT '0' COMMENT '门店、供应商id' AFTER `type`;

-- 角色表
ALTER TABLE `eb_system_role` CHANGE `type` `type` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '类型：0平台1:门店2:供应商' AFTER `id`;
ALTER TABLE `eb_system_role` CHANGE `store_id` `relation_id` INT(11) NOT NULL DEFAULT '0' COMMENT '门店、供应商id' AFTER `type`;
UPDATE  `eb_system_role` set `type` = 0 where `type` = 1;
UPDATE  `eb_system_role` set `type` = 1 where `type` = 2;

-- 标签分类表
ALTER TABLE `eb_category` CHANGE `type` `type` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '类型：0平台1:门店2:供应商' AFTER `id`;
ALTER TABLE `eb_category` CHANGE `store_id` `relation_id` INT(11) NOT NULL DEFAULT '0' COMMENT '门店、供应商id' AFTER `type`;
UPDATE  `eb_category` set `type` = 0 where `type` = 1;
UPDATE  `eb_category` set `type` = 1 where `type` = 2;

-- 商品关联标签表
ALTER TABLE `eb_store_product_label` CHANGE `type` `type` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '类型：0平台1:门店2:供应商' AFTER `id`;
ALTER TABLE `eb_store_product_label` CHANGE `store_id` `relation_id` INT(11) NOT NULL DEFAULT '0' COMMENT '门店、供应商id' AFTER `type`;
UPDATE  `eb_store_product_label` set `type` = 0 where `type` = 1;
UPDATE  `eb_store_product_label` set `type` = 1 where `type` = 2;

-- 用户标签表
ALTER TABLE `eb_user_label` CHANGE `type` `type` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '类型：0平台1:门店2:供应商' AFTER `id`;
ALTER TABLE `eb_user_label` CHANGE `store_id` `relation_id` INT(11) NOT NULL DEFAULT '0' COMMENT '门店、供应商id' AFTER `type`;
UPDATE  `eb_user_label` set `type` = 0 where `type` = 1;
UPDATE  `eb_user_label` set `type` = 1 where `type` = 2;

-- 用户关联标签表
ALTER TABLE `eb_user_label_relation` add `type` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '类型：0平台1:门店2:供应商' AFTER `uid`;
ALTER TABLE `eb_user_label_relation` CHANGE `store_id` `relation_id` INT(11) NOT NULL DEFAULT '0' COMMENT '门店、供应商id' AFTER `type`;
UPDATE  `eb_user_label_relation` set `type` = 1 where `relation_id` > 0;

-- 配送员表
ALTER TABLE `eb_delivery_service` CHANGE `type` `type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '类型：0平台1:门店2:供应商' AFTER `uid`;
ALTER TABLE `eb_delivery_service` CHANGE `store_id` `relation_id` INT(11) NOT NULL DEFAULT '0' COMMENT '门店、供应商id' AFTER `type`;
UPDATE  `eb_delivery_service` set `type` = 0 where `type` = 1;
UPDATE  `eb_delivery_service` set `type` = 1 where `type` = 2;

-- 门店配置表
ALTER TABLE `eb_store_config` add `type` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '类型：1:门店2:供应商' AFTER `id`;
ALTER TABLE `eb_store_config` CHANGE `store_id` `relation_id` INT(11) NOT NULL DEFAULT '0' COMMENT '门店、供应商id' AFTER `type`;
UPDATE  `eb_store_config` set `type` = 1 where `relation_id` > 0;

-- 删除唯一索引
ALTER TABLE `eb_store_config` DROP INDEX `key`;
ALTER TABLE `eb_store_config` ADD INDEX `type` (`type`, `relation_id`);

-- 增加优惠券适用门店
ALTER TABLE `eb_store_coupon_issue` ADD `applicable_type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '适用门店：0：仅平台1：所有2：部分';
ALTER TABLE `eb_store_coupon_issue` ADD `applicable_store_id` LONGTEXT NULL DEFAULT NULL COMMENT '适用门店ids' AFTER `applicable_type`;

-- ALTER TABLE `eb_store_coupon_user` ADD `applicable_type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '适用门店：0：仅平台1：所有2：部分';
-- ALTER TABLE `eb_store_coupon_user` ADD `applicable_store_id` LONGTEXT NULL DEFAULT NULL COMMENT '适用门店ids' AFTER `applicable_type`;

-- 抽奖记录保存奖品信息
ALTER TABLE `eb_luck_lottery_record` ADD `prize_info` TEXT NULL DEFAULT NULL COMMENT '奖品信息' AFTER `type`;

-- 商城链接
INSERT INTO `eb_page_category` (`id`, `pid`, `type`, `name`, `sort`, `status`, `add_time`) VALUES
(null, 1, 'store_home', '门店主页', 96, 1, 1626831994);

-- 供应商入驻链接
INSERT INTO `eb_page_link` (`id`, `cate_id`, `type`, `name`, `url`, `param`, `example`, `status`, `sort`, `add_time`) VALUES
(null, 5, 1, '供应商入驻', '/pages/users/supplier/index', ' ', '/pages/users/supplier/index', 1, 0, 1626837579);


-- 用户申请门店、供应商
CREATE TABLE `eb_system_user_apply` (
 `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
 `type` TINYINT(2) NOT NULL DEFAULT '0' COMMENT '申请类型1:门店2:供应商',
 `relation_id` int(11) NOT NULL DEFAULT '0' COMMENT '关联商户',
 `uid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
 `phone` varchar(20) NOT NULL DEFAULT '' COMMENT '手机号',
 `system_name` varchar(30) NOT NULL DEFAULT '' COMMENT '商户名称',
 `name` varchar(30) NOT NULL DEFAULT '' COMMENT '联系人名称',
 `images` varchar(2000) NOT NULL DEFAULT '' COMMENT '多图',
 `mark` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
 `status` tinyint(2) NOT NULL DEFAULT '0' COMMENT '处理状态0未处理，1通过 ，2未通过',
 `fail_msg` varchar(255) NOT NULL DEFAULT '' COMMENT '未通过原因',
 `is_del` tinyint(2) NOT NULL DEFAULT '0' COMMENT '删除状态 1删除 ，0未删除',
 `status_time` int(10) NOT NULL DEFAULT '0' COMMENT '审核时间',
 `add_time` int(10) NOT NULL DEFAULT '0' COMMENT '添加时间',
 PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户申请表';

-- 供应商流水
-- 表的结构 `eb_supplier_flowing_water`
--
CREATE TABLE `eb_supplier_flowing_water` (
 `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
 `supplier_id` int(10) NOT NULL DEFAULT '0' COMMENT '供应商ID',
 `uid` int(11) NOT NULL DEFAULT '0' COMMENT '用户id',
 `order_id` varchar(20) NOT NULL DEFAULT '' COMMENT '交易单号',
 `link_id` varchar(50) NOT NULL DEFAULT '' COMMENT '关联订单',
 `pm` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0 = 支出 1 = 获得',
 `number` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '明细',
 `type` varchar(50) NOT NULL DEFAULT '' COMMENT '交易类型(1:支付订单,2:退款订单)',
 `pay_type` varchar(20) NOT NULL DEFAULT '' COMMENT '支付方式',
 `pay_price` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '实际支付金额',
 `pay_postage` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '实际支付邮费',
 `total_price` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '订单总金额',
 `remark` varchar(512) NOT NULL DEFAULT '' COMMENT '平台备注',
 `mark` varchar(255) NOT NULL DEFAULT '' COMMENT '供应商备注',
 `is_del` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除',
 `trade_time` int(11) NOT NULL DEFAULT '0' COMMENT '交易时间',
 `add_time` int(11) NOT NULL DEFAULT '0' COMMENT '添加时间',
 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='供应商流水表';

-- 供应商交易
-- 表的结构 `eb_supplier_transactions`
--
CREATE TABLE `eb_supplier_transactions` (
 `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
 `supplier_id` int(10) NOT NULL DEFAULT '0' COMMENT '供应商ID',
 `uid` int(11) NOT NULL DEFAULT '0' COMMENT '用户id',
 `order_id` varchar(20) NOT NULL DEFAULT '' COMMENT '交易单号',
 `link_id` varchar(50) NOT NULL DEFAULT '' COMMENT '关联订单',
 `pm` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0 = 支出 1 = 获得',
 `type` varchar(50) NOT NULL DEFAULT '' COMMENT '交易类型(1:支付订单,2:退款订单)',
 `pay_type` varchar(20) NOT NULL DEFAULT '' COMMENT '支付方式',
 `pay_price` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '实际支付金额',
 `pay_postage` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '实际支付邮费',
 `total_price` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '订单总金额',
 `remark` varchar(512) NOT NULL DEFAULT '' COMMENT '平台备注',
 `mark` varchar(255) NOT NULL DEFAULT '' COMMENT '供应商备注',
 `is_del` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除',
 `trade_time` int(11) NOT NULL DEFAULT '0' COMMENT '交易时间',
 `add_time` int(11) NOT NULL DEFAULT '0' COMMENT '添加时间',
 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='供应商交易表';

--
-- 表的结构 `eb_supplier_extract`
--
CREATE TABLE `eb_supplier_extract` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
`supplier_id` int(10) NOT NULL DEFAULT '0' COMMENT '供应商ID',
`extract_type` varchar(32) NOT NULL DEFAULT 'bank' COMMENT 'bank = 银行卡 alipay = 支付宝wx=微信',
`bank_code` varchar(32) NOT NULL DEFAULT '0' COMMENT '银行卡',
`bank_address` varchar(256) NOT NULL DEFAULT '' COMMENT '开户地址',
`alipay_account` varchar(64) NOT NULL DEFAULT '' COMMENT '支付宝账号',
`wechat` varchar(15) NOT NULL DEFAULT '' COMMENT '微信号',
`qrcode_url` varchar(255) NOT NULL DEFAULT '' COMMENT '二维码地址',
`extract_price` decimal(8,2) UNSIGNED NOT NULL DEFAULT '0.00' COMMENT '提现金额',
`mark` varchar(512) NOT NULL DEFAULT '',
`balance` decimal(8,2) UNSIGNED NOT NULL DEFAULT '0.00',
`status` tinyint(2) NOT NULL DEFAULT '0' COMMENT '-1 未通过 0 审核中 1 已提现',
`pay_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0 未转账 1 已转账',
`supplier_mark` varchar(255) NOT NULL DEFAULT '' COMMENT '供应商备注',
`admin_id` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '管理员ID',
`fail_msg` varchar(128) NOT NULL DEFAULT '' COMMENT '无效原因',
`fail_time` int(10) UNSIGNED NOT NULL DEFAULT '0',
`voucher_image` varchar(256) NOT NULL DEFAULT '' COMMENT '转账凭证',
`voucher_title` varchar(256) NOT NULL DEFAULT '' COMMENT '转账说明',
`add_time` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '添加时间',
PRIMARY KEY (`id`),
KEY `supplier_id` (`supplier_id`),
KEY `extract_type` (`extract_type`),
KEY `status` (`status`),
KEY `add_time` (`add_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='供应商提现表';

--
-- 修改表的结构 `eb_system_supplier`
--
ALTER TABLE `eb_system_supplier` ADD COLUMN  `bank_code` varchar(32) NOT NULL DEFAULT '0' COMMENT '银行卡' AFTER `detailed_address`;
ALTER TABLE `eb_system_supplier` ADD COLUMN  `bank_address` varchar(256) NOT NULL DEFAULT '' COMMENT '开户地址' AFTER `bank_code`;
ALTER TABLE `eb_system_supplier` ADD COLUMN  `alipay_account` varchar(64) NOT NULL DEFAULT '' COMMENT '支付宝账号' AFTER `bank_address`;
ALTER TABLE `eb_system_supplier` ADD COLUMN  `alipay_qrcode_url` varchar(255) NOT NULL DEFAULT '' COMMENT '支付宝二维码地址' AFTER `alipay_account`;
ALTER TABLE `eb_system_supplier` ADD COLUMN  `wechat` varchar(15) NOT NULL DEFAULT '' COMMENT '微信号' AFTER `alipay_qrcode_url`;
ALTER TABLE `eb_system_supplier` ADD COLUMN  `wechat_qrcode_url` varchar(255) NOT NULL DEFAULT '' COMMENT '二维码地址' AFTER `wechat`;

--
-- 修改表的结构 `eb_system_store`
--
ALTER TABLE `eb_system_store` ADD COLUMN  `default_delivery` tinyint(1) NOT NULL DEFAULT '1' COMMENT '默认设置门店配送方式 1=配送  2=自提' AFTER `is_store`;

--
-- 修改表的结构 `eb_system_attachment`
--
ALTER TABLE `eb_system_attachment` ADD COLUMN  `scan_token` varchar(32) NOT NULL DEFAULT '' COMMENT '扫码上传的token';

--
-- 修改表的结构 `eb_store_order_cart_info`
--
ALTER TABLE `eb_store_order_cart_info` ADD COLUMN  `is_advent_sms` tinyint(1) NOT NULL DEFAULT '0' COMMENT '临期提醒是否发送' AFTER `write_end`;
ALTER TABLE `eb_store_order_cart_info` ADD COLUMN  `is_expire_sms` tinyint(1) NOT NULL DEFAULT '0' COMMENT '过期提醒是否发送' AFTER `is_advent_sms`;

--
-- 修改表的结构 `eb_system_admin`
--
ALTER TABLE `eb_system_admin` ADD COLUMN  `is_way` tinyint(1) NOT NULL DEFAULT '0' COMMENT '图片上传方式 0=本地上传 1=网络图片 2=扫码上传' AFTER `status`;

--
-- 修改表的结构 `eb_system_store_staff`
--
ALTER TABLE `eb_system_store_staff` ADD COLUMN  `is_way` tinyint(1) NOT NULL DEFAULT '0' COMMENT '图片上传方式 0=本地上传 1=网络图片 2=扫码上传' AFTER `notify`;

--
-- 转存表中的数据 `eb_system_notification`
--
UPDATE  `eb_system_notification` set `is_wechat` = 0 where `mark` = 'bind_spread_uid';
UPDATE  `eb_system_notification` set `is_wechat` = 0 where `mark` = 'price_revision';
UPDATE  `eb_system_notification` set `is_wechat` = 0 where `mark` = 'order_pay_false';
UPDATE  `eb_system_notification` set `is_wechat` = 0, `is_sms` = 1 where `mark` = 'integral_accout';
UPDATE  `eb_system_notification` set `is_wechat` = 0, `is_sms` = 1 where `mark` = 'order_brokerage';
UPDATE  `eb_system_notification` set `is_wechat` = 0, `is_sms` = 1 where `mark` = 'bargain_success';
UPDATE  `eb_system_notification` set `is_wechat` = 0, `is_sms` = 1 where `mark` = 'order_user_groups_success';
UPDATE  `eb_system_notification` set `is_wechat` = 0, `is_sms` = 1 where `mark` = 'send_order_pink_fial';
UPDATE  `eb_system_notification` set `is_wechat` = 0, `is_sms` = 1 where `mark` = 'open_pink_success';
UPDATE  `eb_system_notification` set `is_wechat` = 0, `is_sms` = 1 where `mark` = 'user_balance_change';
UPDATE  `eb_system_notification` set `is_wechat` = 0, `is_sms` = 1 where `mark` = 'send_order_pink_clone';
UPDATE  `eb_system_notification` set `is_wechat` = 0, `is_sms` = 1 where `mark` = 'can_pink_success';
UPDATE  `eb_system_notification` set `is_wechat` = 0 where `mark` = 'admin_pay_success_code';
UPDATE  `eb_system_notification` set `is_wechat` = 0 where `mark` = 'send_order_apply_refund';
UPDATE  `eb_system_notification` set `is_wechat` = 0 where `mark` = 'kami_deliver_goods_code';
UPDATE  `eb_system_notification` set `is_wechat` = 0 where `mark` = 'order_deliver_success';

UPDATE  `eb_system_notification` set `is_sms` = 1 where `mark` = 'order_refund';
UPDATE  `eb_system_notification` set `is_sms` = 1 where `mark` = 'user_extract';
UPDATE  `eb_system_notification` set `is_sms` = 1 where `mark` = 'send_order_refund_no_status';

UPDATE  `eb_system_notification` set `name` = '卡密商品发货通知',`title` = '购买卡密商品给用户发送提醒' where `mark` = 'kami_deliver_goods_code';
--
-- 转存表中的数据 `eb_template_message`
--
DELETE FROM `eb_template_message` WHERE `tempkey` = 'OPENTM409880752';
DELETE FROM `eb_template_message` WHERE `tempkey` = 'OPENTM401202515';
DELETE FROM `eb_template_message` WHERE `tempkey` = 'OPENTM408199008';

--
-- 转存表中的数据 `eb_template_message`
--
INSERT INTO `eb_template_message` (`id`, `notification_id`, `type`, `tempkey`, `name`, `kid`, `content`, `example`, `tempid`, `add_time`, `status`) VALUES (NULL, '17', '1', '46232', '退货退款申请结果通知', '', '退款金额{{amount5.DATA}}\r\n订单编号{{character_string8.DATA}}\r\n处理结果{{thing6.DATA}}\r\n结果通知时间{{time9.DATA}}', '', '', '1515053049', '1');

UPDATE  `eb_template_message` set `tempkey` = 43216,`name` = '订单支付成功通知	', `content` = '订单号{{character_string2.DATA}}\r\n商品名称{{thing3.DATA}}\r\n支付金额{{amount5.DATA}}\r\n会员名称{{phrase18.DATA}}\r\n下单时间{{time4.DATA}}' where `tempkey` = 'OPENTM418062102';
UPDATE  `eb_template_message` set `tempkey` = 50439,`name` = '确认收货通知',`content` = '订单编号{{character_string7.DATA}}\r\n商品名称{{thing6.DATA}}\r\n收货时间{{time4.DATA}}' where `tempkey` = 'OPENTM418528119';
UPDATE  `eb_template_message` set `tempkey` = 48058,`name` = '退款成功通知',`notification_id` = '5', `content` = '退款金额{{amount2.DATA}}\r\n退款时间{{time4.DATA}}\r\n订单编号{{character_string5.DATA}}' where `tempkey` = 'OPENTM207284059';
UPDATE  `eb_template_message` set `tempkey` = 42934,`name` = '充值成功提醒',`content` = '充值时间{{time11.DATA}}\r\n充值金额{{amount5.DATA}}' where `tempkey` = 'OPENTM414089457';
UPDATE  `eb_template_message` set `tempkey` = 51729,`name` = '提现到账通知',`content` = '到账金额{{amount3.DATA}}\r\n提现时间{{time4.DATA}}' where `tempkey` = 'OPENTM405876306';
UPDATE  `eb_template_message` set `tempkey` = 42984,`name` = '订单发货通知',`content` = '订单编号{{character_string2.DATA}}\r\n商品名称{{thing4.DATA}}\r\n快递公司{{thing13.DATA}}\r\n快递单号{{character_string14.DATA}}\r\n发货时间{{time12.DATA}}' where `tempkey` = 'OPENTM415939287';