qimall/console/migrations/M231111105126InsertQimallTown.php

<?php

namespace app\migrations;

use yii\db\Migration;

/**
 * Class M231111105126InsertQimallTown
 */
class M231111105126InsertQimallTown extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        $sql = "DELETE FROM `qimall_town` WHERE `district_id` = 2267;";
        $sql .= "INSERT INTO `qimall_town`(`id`, `district_id`, `adcode`, `name`, `created_at`, `updated_at`) VALUES 
(47887, 2267, 330205, '华新街街道', 1699671239, 1699671239),
(47888, 2267, 330205, '江北城街道', 1699671239, 1699671239),
(47889, 2267, 330205, '石马河街道', 1699671239, 1699671239),
(47890, 2267, 330205, '大石坝街道', 1699671239, 1699671239),
(47891, 2267, 330205, '寸滩街道', 1699671239, 1699671239),
(47892, 2267, 330205, '观音桥街道', 1699671239, 1699671239),
(47893, 2267, 330205, '五里店街道', 1699671239, 1699671239),
(47894, 2267, 330205, '郭家沱街道', 1699671239, 1699671239),
(47895, 2267, 330205, '铁山坪街道', 1699671239, 1699671239),
(47896, 2267, 330205, '鱼嘴镇', 1699671239, 1699671239),
(47897, 2267, 330205, '复盛镇', 1699671239, 1699671239),
(47898, 2267, 330205, '五宝镇', 1699671239, 1699671239);";
        $this->execute($sql);
    }

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

        return false;
    }

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

    }

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

        return false;
    }
    */
}