ProgressBlockUpdateSteps11.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
namespace ILIAS\Tracking\Setup;
 
use ilDatabaseUpdateSteps;
use ilDBConstants;
use ilDBInterface;
 
class ProgressBlockUpdateSteps11 implements ilDatabaseUpdateSteps
{
    protected ilDBInterface $db;
 
    public function prepare(ilDBInterface $db): void
    {
        $this->db = $db;
    }
 
    public function step_1(): void
    {
        if ($this->db->tableExists('ut_progress_block')) {
            return;
        }
        $this->db->createTable('ut_progress_block', [
            'obj_id' => [
                'type' => ilDBConstants::T_TEXT,
                'length' => 4,
                'default' => 0,
                'notnull' => true
            ],
            'show_block' => [
                'type' => ilDBConstants::T_INTEGER,
                'length' => 1,
                'default' => 0,
                'notnull' => true
            ]
        ]);
        $this->db->addPrimaryKey('ut_progress_block', ['obj_id']);
    }
 
    public function step_2(): void
    {
        if (
            !$this->db->tableExists('ut_progress_block') ||
            !$this->db->tableColumnExists('ut_progress_block', 'obj_id')
        ) {
            return;
        }
        $this->db->modifyTableColumn(
            'ut_progress_block',
            'obj_id',
            [
                'type' => ilDBConstants::T_INTEGER,
                'length' => 4,
                'default' => 0,
                'notnull' => true
            ]
        );
    }
}