<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Support\Facades\DB;

class DeletePendingMembersConfig extends Migration
{
    public function up(): void
    {
        DB::raw('DELETE FROM `config` WHERE (`collection` LIKE \'%pending%\' OR `name` LIKE \'%pending%\' OR
                            `data` LIKE \'%pending%\') AND ((`collection` = \'language.fr\' AND
                             `collection` = \'language.fr\' COLLATE utf8mb4_bin AND
                             `name` = \'field.field.node.groups.field_pending_members\' AND
                             `name` = \'field.field.node.groups.field_pending_members\' COLLATE utf8mb4_bin))');
    }
}
