qimall/console/migrations/M240925094712ModifyTownForDistrictId3015.php

<?php

namespace app\migrations;

use yii\db\Migration;

/**
 * Class M240925094712ModifyTownForDistrictId3015
 */
class M240925094712ModifyTownForDistrictId3015 extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        $sql = <<<SQL
            DELETE FROM `qimall_town` WHERE `district_id` = '3015';
            INSERT INTO `qimall_town` (`district_id`, `adcode`, `name`, `created_at`, `updated_at`) VALUES 
                (3015, 621026, '九岘乡', 1727229186, 1727229186),
                (3015, 621026, '金村乡', 1727229186, 1727229186),
                (3015, 621026, '瓦斜乡', 1727229186, 1727229186),
                (3015, 621026, '南义乡', 1727229186, 1727229186),
                (3015, 621026, '春荣镇', 1727229186, 1727229186),
                (3015, 621026, '太昌镇', 1727229186, 1727229186),
                (3015, 621026, '良平镇', 1727229186, 1727229186),
                (3015, 621026, '米桥镇', 1727229186, 1727229186),
                (3015, 621026, '焦村镇', 1727229186, 1727229186),
                (3015, 621026, '中村镇', 1727229186, 1727229186),
                (3015, 621026, '盘克镇', 1727229186, 1727229186),
                (3015, 621026, '新庄镇', 1727229186, 1727229186),
                (3015, 621026, '湘乐镇', 1727229186, 1727229186),
                (3015, 621026, '和盛镇', 1727229186, 1727229186),
                (3015, 621026, '长庆桥镇', 1727229186, 1727229186),
                (3015, 621026, '早胜镇', 1727229186, 1727229186),
                (3015, 621026, '平子镇', 1727229186, 1727229186),
                (3015, 621026, '新宁镇', 1727229186, 1727229186);
SQL;
        $this->execute($sql);
    }

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

        return false;
    }
}