qimall/console/migrations/M230809165238InsertQimallTown.php

<?php

namespace app\migrations;

use yii\db\Migration;

/**
 * Class M230807172326InsertQimallTown
 */
class M230809165238InsertQimallTown extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        $sql = "DELETE FROM `qimall_town` WHERE `district_id` = 584;";
        $sql.="INSERT INTO `qimall_town`(`id`, `district_id`, `adcode`, `name`, `created_at`, `updated_at`) VALUES 
(39012, 584, 110105, '富锋街道', 1594556414, 1594556414),
(39013, 584, 110105, '桂林街道', 1594556414, 1594556414),
(39014, 584, 110105, '红旗街道', 1594556414, 1594556414),
(39015, 584, 110105, '湖西街道', 1594556414, 1594556414),
(39016, 584, 110105, '乐山镇', 1594556414, 1594556414),
(39017, 584, 110105, '南湖街道', 1594556414, 1594556414),
(39018, 584, 110105, '前进街道', 1594556414, 1594556414),
(39019, 584, 110105, '清和街道', 1594556414, 1594556414),
(39020, 584, 110105, '永昌街道', 1594556414, 1594556414),
(39021, 584, 110105, '永春镇', 1594556414, 1594556414),
(39022, 584, 110105, '重庆街道', 1594556414, 1594556414);";
        $this->execute($sql);
    }

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

        return false;
    }

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

    }

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

        return false;
    }
    */
}