去评论
dz插件网

Discuz!X3.5新增购买邀请码业务接入新支付系统QQ钱包支付等需要升级的SQL语句

admin
2021/09/26 09:33:39
Discuz!X3.5新增购买邀请码业务接入新支付系统QQ钱包支付等需要升级的SQL语句：

* install_data格式问题
* Merge branch 'v3.5' of https://gitee.com/Discuz/DiscuzX into v3.5
* php8-libxml_disable_entity_loader禁用处理
* 删除冗余的代码
* 邀请注册支持触摸版
* 购买邀请码业务接入新支付系统
* 删除未使用的代码* 支付宝支付BUG
* !1 优化 代码缩进 & 新增 QQ 钱包支付替代财付通支付
* 新增 QQ 钱包支付替代财付通支付
* 优化 代码缩进* LF修改为CRLF
* 支付服务* Merge branch 'v3.5' of https://gitee.com/nayuan/DiscuzX into v3.5
* Merge branch 'v3.5' of https://gitee.com/nayuan/DiscuzX into v3.5
* 支付服务优化
* 支付优化
* 支付触摸界面优化
* merge* 支付服务触摸界面
* 支付服务优化
* 支付服务
  1. DROP TABLE IF EXISTS pre_common_payment_order;
  2. CREATE TABLE pre_common_payment_order  (
  3.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  4.   `out_biz_no` varchar(64) NOT NULL,
  5.   `type` varchar(255)  NOT NULL,
  6.   `type_name` varchar(255) DEFAULT NULL,
  7.   `uid` int(10) unsigned NOT NULL DEFAULT 0,
  8.   `amount` int(10) unsigned NOT NULL,
  9.   `amount_fee` int(10) unsigned NOT NULL,
  10.   `subject` varchar(255) NOT NULL,
  11.   `description` varchar(255) DEFAULT NULL,
  12.   `expire_time` int(10) unsigned NOT NULL,
  13.   `status` tinyint(1) NOT NULL,
  14.   `return_url` varchar(255) DEFAULT NULL,
  15.   `data` text DEFAULT NULL,
  16.   `clientip` varchar(255) NOT NULL DEFAULT '',
  17.   `remoteport` smallint(6) unsigned NOT NULL DEFAULT 0,
  18.   `dateline` int(10) unsigned NOT NULL,
  19.   `trade_no` varchar(255) DEFAULT NULL,
  20.   `channel` varchar(255) DEFAULT NULL,
  21.   `payment_time` int(10) unsigned DEFAULT NULL,
  22.   `callback_status` tinyint(1) DEFAULT 0,
  23.   PRIMARY KEY (`id`),
  24.   UNIQUE KEY (`out_biz_no`),
  25.   KEY (`uid`),
  26.   KEY (`type`),
  27.   KEY (`status`)
  28. ) ENGINE=InnoDB;

  30. DROP TABLE IF EXISTS pre_common_payment_refund;
  31. CREATE TABLE pre_common_payment_refund  (
  32.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  33.   `order_id` int(10) unsigned NOT NULL,
  34.   `out_biz_no` varchar(64)  NOT NULL,
  35.   `amount` int(10) unsigned NOT NULL,
  36.   `description` varchar(255)  NOT NULL,
  37.   `status` tinyint(1) NOT NULL,
  38.   `error` varchar(255) DEFAULT NULL,
  39.   `refund_time` int(10) DEFAULT NULL,
  40.   `clientip` varchar(255) NOT NULL DEFAULT '',
  41.   `remoteport` smallint(6) unsigned NOT NULL DEFAULT 0,
  42.   `dateline` int(10) NOT NULL,
  43.   PRIMARY KEY (`id`),
  44.   UNIQUE KEY (`out_biz_no`),
  45.   INDEX (`order_id`)
  46. ) ENGINE=InnoDB;

  48. DROP TABLE IF EXISTS pre_common_payment_transfer;
  49. CREATE TABLE pre_common_payment_transfer  (
  50.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  51.   `uid` int(10) unsigned NOT NULL,
  52.   `out_biz_no` varchar(64) NOT NULL,
  53.   `amount` int(10) unsigned NOT NULL,
  54.   `subject` varchar(255) NOT NULL,
  55.   `description` varchar(255) DEFAULT NULL,
  56.   `realname` varchar(255) NOT NULL,
  57.   `account` varchar(255) NOT NULL,
  58.   `channel` varchar(255) DEFAULT NULL,
  59.   `status` tinyint(1) unsigned NOT NULL,
  60.   `error` varchar(255) DEFAULT NULL,
  61.   `trade_no` varchar(255) DEFAULT NULL,
  62.   `trade_time` int(10) unsigned DEFAULT NULL,
  63.   `clientip` varchar(255) NOT NULL DEFAULT '',
  64.   `remoteport` smallint(6) unsigned NOT NULL DEFAULT 0,
  65.   `dateline` int(10) unsigned NOT NULL,
  66.   PRIMARY KEY (`id`),
  67.   UNIQUE KEY (`out_biz_no`),
  68.   KEY (`uid`),
  69.   KEY (`status`)
  70. ) ENGINE=InnoDB;





进入原文参与互动