INSERT INTO `sd_set` (`id`, `set_name`, `set_value`) VALUES ('63', 'wePay_recharge', '{\"a\":0}');
INSERT INTO `sd_set` (`id`, `set_name`, `set_value`) VALUES ('64', 'passwordStrength', '4');
ALTER TABLE sd_order ADD INDEX idx_covering (time, ddid, payno, pay_trade_no, email);
ALTER TABLE sd_order ADD INDEX idx_ddid (ddid);
ALTER TABLE sd_order ADD INDEX idx_payno (payno);
ALTER TABLE sd_order ADD INDEX idx_pay_trade_non (pay_trade_no);
ALTER TABLE sd_order ADD INDEX idx_emaill (email);
ALTER TABLE sd_order ADD INDEX idx_time (time);
ALTER TABLE `sd_pay_channel` ADD `pid` VARCHAR(20) NOT NULL AFTER `pay_time`, ADD `pay_method` INT(1) NOT NULL DEFAULT '0' COMMENT '0=普通收款码 1=带备注跳转模式 2=无备注跳转模式 3=手动输入金额跳转模式 ' AFTER `pid`, ADD `private_key` TEXT NOT NULL AFTER `pay_method`, ADD `public_key` TEXT NOT NULL AFTER `private_key`, ADD `appid` VARCHAR(20) NOT NULL AFTER `public_key`;
ALTER TABLE `sd_pay_order` ADD `h5_url` VARCHAR(255) NULL DEFAULT NULL AFTER `pay_url`;
ALTER TABLE `sd_pay_order` ADD `pay_channel` INT(11) NOT NULL COMMENT '支付通道' AFTER `type`;
ALTER TABLE `sd_pay_order` ADD `alipay_order_no` VARCHAR(255) NOT NULL COMMENT '支付宝回调订单号' AFTER `order_id`;