class.ilWebResourceDBUpdateSteps.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

class ilWebResourceDBUpdateSteps implements ilDatabaseUpdateSteps
{
    protected \ilDBInterface $db;

    public function prepare(\ilDBInterface $db): void
    {
        $this->db = $db;
    }

    public function step_1(): void
    {
        // Add index
        if (!$this->db->indexExistsByFields('webr_items', ['webr_id'])) {
            $this->db->addIndex('webr_items', ['webr_id'], 'i3');
        }
    }

    public function step_2(): void
    {
        // Add combined index
        // 32201
        if (
            $this->db->tableExists('webr_items') &&
            !$this->db->indexExistsByFields('webr_items', ['webr_id', 'active'])
        ) {
            $this->db->addIndex('webr_items', ['webr_id', 'active'], 'i4');
        }
    }
}