qimall/console/migrations/M250902103752AlterMallCapital.php

<?php

namespace app\migrations;

use yii\db\Migration;

/**
 * 移除census_mall_capital 表中所有字段的 unsigned
 * Class M250902103752AlterMallCapital
 */
class M250902103752AlterMallCapital extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        try {
            $sql = <<< SQL
-- 移除多个字段的 unsigned 属性
ALTER TABLE qimall_census_mall_capital
-- 重新定义字段，去掉 unsigned
MODIFY COLUMN total_nums decimal(14,2) NOT NULL DEFAULT '0.00' COMMENT '累计数量',
MODIFY COLUMN use_nums decimal(14,2) NOT NULL DEFAULT '0.00' COMMENT '使用数量',
MODIFY COLUMN surplus_nums decimal(14,2) NOT NULL DEFAULT '0.00' COMMENT '剩余数量',
MODIFY COLUMN withdrawal_nums decimal(14,2) NOT NULL DEFAULT '0.00' COMMENT '提现数量',
MODIFY COLUMN service_charge decimal(14,2) NOT NULL DEFAULT '0.00' COMMENT '手续费',
MODIFY COLUMN cancel_nums decimal(14,2) NOT NULL DEFAULT '0.00' COMMENT '无效数量',
MODIFY COLUMN unsettled decimal(14,2) NOT NULL DEFAULT '0.00' COMMENT '待结算数量';
SQL;
            $this->execute($sql);
        }catch (\Exception $e){

        }

    }

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

        return false;
    }

}