ilStudyProgrammeSettingsTableUpdateSteps.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

class ilStudyProgrammeSettingsTableUpdateSteps implements ilDatabaseUpdateSteps
{
    public const TABLE_NAME = 'prg_settings';
    public const TABLE_PROGRESSES = 'prg_usr_progress';

    protected ilDBInterface $db;

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

    public function step_1(): void
    {
        $column_name = 'vq_restart_recheck';

        if (!$this->db->tableColumnExists(self::TABLE_NAME, $column_name)) {
            $this->db->addTableColumn(
                self::TABLE_NAME,
                $column_name,
                [
                    'type' => 'integer',
                    'length' => 1,
                    'default' => 0,
                    'notnull' => false
                ]
            );
        }
    }

    public function step_2(): void
    {
        if (!$this->db->indexExistsByFields(self::TABLE_NAME, ['assignment_id', 'prg_id', 'usr_id'])) {
            $this->db->dropPrimaryKey(self::TABLE_PROGRESSES);
            $this->db->addPrimaryKey(
                self::TABLE_PROGRESSES,
                [
                    'assignment_id',
                    'prg_id',
                    'usr_id'
                ]
            );
        }
    }
}