qimall/console/migrations/M240819144128UpdateTownDistId803.php

<?php

namespace app\migrations;

use yii\db\Migration;

/**
 * 修复上海宝山区街道数据
 */
class M240819144128UpdateTownDistId803 extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        $sql = <<<SQL
            -- 删除
            DELETE FROM qimall_town WHERE district_id = 803;
            -- 添加
            INSERT INTO `qimall_town` (`district_id`, `adcode`, `name`, `created_at`, `updated_at`) VALUES 
            (803, 310113, '友谊路街道', 1594556465, 1594556465),
            (803, 310113, '吴淞街道', 1594556465, 1594556465),
            (803, 310113, '张庙街道', 1594556465, 1594556465),
            (803, 310113, '罗店镇', 1594556465, 1594556465),
            (803, 310113, '大场镇', 1594556465, 1594556465),
            (803, 310113, '杨行镇', 1594556465, 1594556465),
            (803, 310113, '月浦镇', 1594556465, 1594556465),
            (803, 310113, '罗泾镇', 1594556465, 1594556465),
            (803, 310113, '顾村镇', 1594556465, 1594556465),
            (803, 310113, '高境镇', 1594556465, 1594556465),
            (803, 310113, '庙行镇', 1594556465, 1594556465),
            (803, 310113, '淞南镇', 1594556465, 1594556465),
            (803, 310113, '宝山工业园区', 1594556465, 1594556465);
SQL;
        $this->execute($sql);
    }

    /**
     * {@inheritdoc}
     */
    public function safeDown()
    {
        return false;
    }
}