qimall/addons/Alitopay/console/migrations/M230714023413AlterQimallAddonsAtpOrder.php

<?php

namespace addons\Alitopay\console\migrations;

use yii\db\Migration;

/**
 * Class M230714023413AlterQimallAddonsAtpOrder
 */
class M230714023413AlterQimallAddonsAtpOrder extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        try {
            $sql="ALTER table qimall_addons_atp_order add `order_id` varchar(255) NOT NULL DEFAULT '' COMMENT '支付宝转账单据号，成功一定返回，失败可能不返回也可能返回。';";
            $this->execute($sql);
            $sql="ALTER table qimall_addons_atp_order add `file_id` varchar(255) NOT NULL DEFAULT '' COMMENT '文件申请号file_id信息。使用file_id可以查询处理状态，有效期：2天';";
            $this->execute($sql);
            $sql="ALTER table qimall_addons_atp_order add `download_url` varchar(1000) NOT NULL DEFAULT '' COMMENT '电子回单下载url';";
            $this->execute($sql);
        } catch (\Exception $e) {

        }

    }

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

        return false;
    }

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

    }

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

        return false;
    }
    */
}