qimall/console/migrations/M230217183124CreateChainGoodsPicTable.php

<?php

namespace app\migrations;

use yii\db\Migration;

/**
 * Class M230217183124CreateChainGoodsPicTable
 */
class M230217183124CreateChainGoodsPicTable extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        $log_sql = "CREATE TABLE `qimall_supply_chain_goods_pic` (
            `id` int(10) NOT NULL AUTO_INCREMENT,
            `mall_id` int(10) NOT NULL COMMENT '商城ID',
            `goods_id` int(10) NOT NULL COMMENT '商品ID',
            `chain_url` varchar(255) NOT NULL COMMENT '供应链商品主图',
            `url` varchar(255) NOT NULL COMMENT '商品主图',
            `updated_at` int(10) DEFAULT NULL,
            `created_at` int(10) DEFAULT NULL,
            PRIMARY KEY (`id`)
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;";
        $this->execute($log_sql);
    }

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

        return false;
    }

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

    }

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

        return false;
    }
    */
}