qimall/addons/QiJuhe/console/migrations/M240417103321AddTableGoodsIndex.php

<?php

namespace addons\QiJuhe\console\migrations;

use yii\db\Migration;

/**
 * Class M240417103321AddTableGoodsIndex
 */
class M240417103321AddTableGoodsIndex extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        $sql = "ALTER TABLE `qimall_addons_qijuhe_goods` 
            ADD INDEX(`supply_id`),
            ADD INDEX(`goods_id`),
            ADD INDEX(`mall_goods_id`);";
        $this->execute($sql);
    }

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