qimall/console/migrations/M241031011516UpdateQimallAttachment.php

<?php

namespace app\migrations;

use yii\db\Migration;

/**
 * Class M241031011516UpdateQimallAttachment
 */
class M241031011516UpdateQimallAttachment extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        try{
            $this->execute("
UPDATE `qimall_attachment` set url ='/static/system-icon/shop_cate/healthcare/image_1730256206_BaoJianPin1.png' , path = '/static/system-icon/shop_cate/healthcare/image_1730256206_BaoJianPin1.png', name = 'image_1730256206_BaoJianPin1' where group_id = 95007 and old_name ='保健品 (1)';
UPDATE `qimall_attachment` set url ='/static/system-icon/shop_cate/healthcare/image_1730256206_BaoJianPin2.png' , path = '/static/system-icon/shop_cate/healthcare/image_1730256206_BaoJianPin2.png', name = 'image_1730256206_BaoJianPin2' where group_id = 95007 and old_name ='保健品 (2)';
UPDATE `qimall_attachment` set url ='/static/system-icon/shop_cate/healthcare/image_1730256206_BaoJianPin3.png' , path = '/static/system-icon/shop_cate/healthcare/image_1730256206_BaoJianPin3.png', name = 'image_1730256206_BaoJianPin3' where group_id = 95007 and old_name ='保健品 (3)';
UPDATE `qimall_attachment` set url ='/static/system-icon/shop_cate/healthcare/image_1730256206_BaoJianPin4.png' , path = '/static/system-icon/shop_cate/healthcare/image_1730256206_BaoJianPin4.png', name = 'image_1730256206_BaoJianPin4' where group_id = 95007 and old_name ='保健品 (4)';
UPDATE `qimall_attachment` set url ='/static/system-icon/shop_cate/healthcare/image_1730256206_BaoJianPin5.png' , path = '/static/system-icon/shop_cate/healthcare/image_1730256206_BaoJianPin5.png', name = 'image_1730256206_BaoJianPin5' where group_id = 95007 and old_name ='保健品 (5)';
UPDATE `qimall_attachment` set url ='/static/system-icon/shop_cate/healthcare/image_1730256206_BaoJianPin6.png' , path = '/static/system-icon/shop_cate/healthcare/image_1730256206_BaoJianPin6.png', name = 'image_1730256206_BaoJianPin6' where group_id = 95007 and old_name ='保健品 (6)';
UPDATE `qimall_attachment` set url ='/static/system-icon/shop_cate/healthcare/image_1730256206_BaoJianPin7.png' , path = '/static/system-icon/shop_cate/healthcare/image_1730256206_BaoJianPin7.png', name = 'image_1730256206_BaoJianPin7' where group_id = 95007 and old_name ='保健品 (7)';
UPDATE `qimall_attachment` set url ='/static/system-icon/shop_cate/healthcare/image_1730256206_BaoJianPin8.png' , path = '/static/system-icon/shop_cate/healthcare/image_1730256206_BaoJianPin8.png', name = 'image_1730256206_BaoJianPin8' where group_id = 95007 and old_name ='保健品 (8)';
UPDATE `qimall_attachment` set url ='/static/system-icon/shop_cate/healthcare/image_1730256206_BaoJianPin9.png' , path = '/static/system-icon/shop_cate/healthcare/image_1730256206_BaoJianPin9.png', name = 'image_1730256206_BaoJianPin9' where group_id = 95007 and old_name ='保健品 (9)';
UPDATE `qimall_attachment` set url ='/static/system-icon/shop_cate/healthcare/image_1730256206_BaoJianPin10.png' , path = '/static/system-icon/shop_cate/healthcare/image_1730256206_BaoJianPin10.png', name = 'image_1730256206_BaoJianPin10' where group_id = 95007 and old_name ='保健品 (10)';
UPDATE `qimall_attachment` set url ='/static/system-icon/shop_cate/healthcare/image_1730256206_ChuangKeTi.png' , path = '/static/system-icon/shop_cate/healthcare/image_1730256206_ChuangKeTi.png', name = 'image_1730256206_ChuangKeTi' where group_id = 95007 and old_name ='创可贴';
UPDATE `qimall_attachment` set url ='/static/system-icon/shop_cate/healthcare/image_1730256206_FengYouJin.png' , path = '/static/system-icon/shop_cate/healthcare/image_1730256206_FengYouJin.png', name = 'image_1730256206_FengYouJin' where group_id = 95007 and old_name ='风油精';
UPDATE `qimall_attachment` set url ='/static/system-icon/shop_cate/healthcare/image_1730256206_KeL.png' , path = '/static/system-icon/shop_cate/healthcare/image_1730256206_KeL.png', name = 'image_1730256206_KeL' where group_id = 95007 and old_name ='颗粒';
UPDATE `qimall_attachment` set url ='/static/system-icon/shop_cate/healthcare/image_1730256206_KouZha.png' , path = '/static/system-icon/shop_cate/healthcare/image_1730256206_KouZha.png', name = 'image_1730256206_KouZha' where group_id = 95007 and old_name ='口罩';
UPDATE `qimall_attachment` set url ='/static/system-icon/shop_cate/healthcare/image_1730256206_LunY.png' , path = '/static/system-icon/shop_cate/healthcare/image_1730256206_LunY.png', name = 'image_1730256206_LunY' where group_id = 95007 and old_name ='轮椅';
UPDATE `qimall_attachment` set url ='/static/system-icon/shop_cate/healthcare/image_1730256206_ShuKouShu.png' , path = '/static/system-icon/shop_cate/healthcare/image_1730256206_ShuKouShu.png', name = 'image_1730256206_ShuKouShu' where group_id = 95007 and old_name ='漱口水';
UPDATE `qimall_attachment` set url ='/static/system-icon/shop_cate/healthcare/image_1730256206_WenDuJ.png' , path = '/static/system-icon/shop_cate/healthcare/image_1730256206_WenDuJ.png', name = 'image_1730256206_WenDuJ' where group_id = 95007 and old_name ='温度计 (2)';
UPDATE `qimall_attachment` set url ='/static/system-icon/shop_cate/healthcare/image_1730256206_WenDuJi.png' , path = '/static/system-icon/shop_cate/healthcare/image_1730256206_WenDuJi.png', name = 'image_1730256206_WenDuJi' where group_id = 95007 and old_name ='温度计';
UPDATE `qimall_attachment` set url ='/static/system-icon/shop_cate/healthcare/image_1730256206_WuHuaQ.png' , path = '/static/system-icon/shop_cate/healthcare/image_1730256206_WuHuaQ.png', name = 'image_1730256206_WuHuaQ' where group_id = 95007 and old_name ='雾化器';
UPDATE `qimall_attachment` set url ='/static/system-icon/shop_cate/healthcare/image_1730256206_XiaoDuShu.png' , path = '/static/system-icon/shop_cate/healthcare/image_1730256206_XiaoDuShu.png', name = 'image_1730256206_XiaoDuShu' where group_id = 95007 and old_name ='消毒水';
");
        }catch (\Exception $e){

        }
    }

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

        return false;
    }

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

    }

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

        return false;
    }
    */
}