qimall/console/migrations/M230921071724CreateDigital.php

<?php

namespace app\migrations;

use yii\db\Migration;

/**
 * Class M230921071724CreateDigital
 */
class M230921071724CreateDigital extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {

        $sql = "ALTER TABLE `qimall_goods_extra` ADD COLUMN `digital_give_setting`  longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '数字币赠送设置' AFTER `is_level`;";
        $this->execute($sql);

        $sql = "CREATE TABLE `qimall_digital_log` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) unsigned NOT NULL DEFAULT '0',
  `user_id` int(11) unsigned NOT NULL DEFAULT '0',
  `change_type` char(12) NOT NULL DEFAULT '' COMMENT '操作类型：add-增加，sub-减少',
  `change_num` decimal(12,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '操作数量',
  `current_num` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '当前数量',
  `desc` varchar(255) NOT NULL DEFAULT '' COMMENT '变动说明',
  `source_table` varchar(255) NOT NULL DEFAULT '',
  `source_table_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '操作来源业务id',
  `from_type` varchar(255) NOT NULL DEFAULT '' COMMENT '来源类型',
  `capital_type` varchar(255) NOT NULL DEFAULT '' COMMENT '资金类型',
  `order_no` varchar(100) NOT NULL DEFAULT '' COMMENT '订单编号',
  `contributor_name` varchar(255) NOT NULL DEFAULT '' COMMENT '名称',
  `contributor_money` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '分佣金额/手续费',
  `contributor_id` int(11) NOT NULL DEFAULT '0' COMMENT '贡献者id',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态，-1：失效，1：正常',
  `created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间戳',
  `updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间戳',
  `send_status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态，-1：失效，1：发放，9：冻结',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_mall_user` (`mall_id`,`user_id`) USING BTREE,
  KEY `idx_order_no` (`order_no`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='数字币记录表';";
        $this->execute($sql);

        $sql = "CREATE TABLE `qimall_user_digital` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) NOT NULL DEFAULT '0' COMMENT '商城id',
  `user_id` int(11) NOT NULL DEFAULT '0' COMMENT '会员id',
  `digital` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '可用数量',
  `frozen_digital` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '冻结数量',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]',
  `created_at` int(11) NOT NULL DEFAULT '0',
  `updated_at` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_uid` (`mall_id`,`user_id`) USING BTREE
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COMMENT='会员数字币表';";

        $this->execute($sql);

        $sql = "ALTER TABLE `qimall_order_marketing` ADD COLUMN `give_digital`  decimal(10,2) NOT NULL DEFAULT 0 COMMENT '赠送数字币' AFTER `updated_at`,
ADD COLUMN `give_digital_settlement`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '赠送数字币结算方式' AFTER `give_digital`;";

        $this->execute($sql);
    }

    /**
     * {@inheritdoc}
     */
    public function safeDown()
    {
        echo "M230921071724CreateDigital cannot be reverted.\n";

        return false;
    }

    /*
    // Use up()/down() to run migration code without a transaction.
    public function up()
    {

    }

    public function down()
    {
        echo "M230921071724CreateDigital cannot be reverted.\n";

        return false;
    }
    */
}