ilCourseObjectiveDBUpdateSteps.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

class ilCourseObjectiveDBUpdateSteps implements ilDatabaseUpdateSteps
{
    protected ilDBInterface $db;

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

    public function step_1(): void
    {
        if (!$this->db->indexExistsByFields('loc_settings', ['itest'])) {
            $this->db->addIndex('loc_settings', ['itest'], 'i1');
        }
    }

    public function step_2(): void
    {
        if (!$this->db->indexExistsByFields('loc_settings', ['qtest'])) {
            $this->db->addIndex('loc_settings', ['qtest'], 'i2');
        }
    }

    public function step_3(): void
    {
        if (
            $this->db->tableExists('crs_settings') &&
            !$this->db->tableColumnExists('crs_settings', 'tutorial_support_block')
        ) {
            $this->db->addTableColumn('crs_settings', 'tutorial_support_block', [
                    'type' => 'integer',
                    'notnull' => true,
                    'length' => 1,
                    'default' => 0
            ]);
        }
    }
}