qimall/console/migrations/M250902103752AlterMallCapitalStatistics.php

<?php

namespace app\migrations;

use yii\db\Migration;

/**
 * 移除census_mall_capital_statistics 表中所有字段的 unsigned
 * Class M250902103752AlterMallCapital
 */
class M250902103752AlterMallCapitalStatistics extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        try {
            $sql = <<<SQL
-- 移除多个字段的 unsigned 属性
ALTER TABLE qimall_census_mall_capital_statistics
-- 重新定义字段，去掉 unsigned
MODIFY COLUMN balance_surplus_nums decimal(14,2) NOT NULL DEFAULT '0.00' COMMENT '余额剩余数量',
MODIFY COLUMN commission_surplus_nums decimal(14,2) NOT NULL DEFAULT '0.00' COMMENT '佣金剩余数量',
MODIFY COLUMN score_surplus_nums decimal(14,2) NOT NULL DEFAULT '0.00' COMMENT '积分剩余数量';
SQL;
            $this->execute($sql);
        }catch (\Exception $e){

        }

    }

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

        return false;
    }

}