qimall/addons/AvoidTax/console/migrations/M230524180422ChangeConfigTable.php

<?php

namespace addons\AvoidTax\console\migrations;

use yii\db\Migration;

/**
 * Class M230524180422ChangeConfigTable
 */
class M230524180422ChangeConfigTable extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        try {
            // 插入表数据
            $sql = "ALTER TABLE `qimall_addons_tax_config` 
                ADD COLUMN `api_type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1xinlong\n2luyong' AFTER `mall_id`,
                ADD COLUMN `ly_config` text NULL COMMENT 'luyong配置' AFTER `tax_config`;
                ALTER TABLE `qimall_addons_tax_order` 
                ADD COLUMN `alipay_response` longtext NULL COMMENT '支付响应' AFTER `job_detail_id`;
            ";
            $this->execute($sql);
        } catch (\Exception $e) {

        }
    }

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

        return false;
    }
}