class.ilUser8DBUpdateSteps.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

class ilUser8DBUpdateSteps implements ilDatabaseUpdateSteps
{
    protected ilDBInterface $db;

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

    public function step_1(): void
    {
        $this->db->modifyTableColumn(
            'usr_session',
            'session_id',
            [
                'type' => ilDBConstants::T_TEXT,
                'length' => '256'
            ]
        );
        $this->db->modifyTableColumn(
            'usr_session_stats_raw',
            'session_id',
            [
                'type' => ilDBConstants::T_TEXT,
                'length' => '256'
            ]
        );
        try {
            $this->db->modifyTableColumn(
                'usr_sess_istorage',
                'session_id',
                [
                    'type' => ilDBConstants::T_TEXT,
                    'length' => '256'
                ]
            );
        } catch (\Exception $e) {
            $message = "DB Hotfix 102: \n\n"
                . "We could not Update the length of the column `session_id` in the table\n"
                . "`usr_session_istorage` as the table engine is MyIsam.\n"
                . "This step will be finished after updating to ILIAS 8.\n"
                . "You could also lengthen the field manually after you ran the migration\n"
                . "to migrate to InnoDB, if you require longer session_ids.";
            global $ilLog;
            $ilLog->warning($message);
        }
    }
    public function step_2(): void
    {
        $this->db->modifyTableColumn(
            'usr_data',
            'time_limit_from',
            [
                'type' => ilDBConstants::T_INTEGER,
                'length' => '8'
            ]
        );
        $this->db->modifyTableColumn(
            'usr_data',
            'time_limit_until',
            [
                'type' => ilDBConstants::T_INTEGER,
                'length' => '8'
            ]
        );
    }

    public function step_3(): void
    {
        if (!$this->db->tableExists('usr_change_email_token')) {
            $this->db->createTable(
                'usr_change_email_token',
                [
                    'token' => [
                        'type'     => 'text',
                        'length'   => 32
                    ],
                    'new_email' => [
                        'type'     => 'text',
                        'length'   => 256
                    ],
                    'valid_until' => [
                        'type'     => 'integer',
                        'length'   => 8
                    ]
                ]
            );
        }
    }

    public function step_4(): void
    {
        if ($this->db->tableColumnExists('usr_data', 'street')) {
            $this->db->modifyTableColumn('usr_data', 'street', [
                'type' => \ilDBConstants::T_TEXT,
                'length' => 512,
                'notnull' => false
            ]);
        }
    }

    public function step_5(): void
    {
        if (!$this->db->indexExistsByFields('usr_change_email_token', ['token'])) {
            $this->db->manipulate('DELETE token1 FROM usr_change_email_token token1 '
                . 'INNER JOIN usr_change_email_token token2 '
                . 'WHERE token1.token = token2.token AND token1.valid_until < token2.valid_until');
            $this->db->addPrimaryKey('usr_change_email_token', ['token']);
        }
    }

    public function step_6(): void
    {
        if ($this->db->tableColumnExists('personal_clipboard', 'title')) {
            $this->db->modifyTableColumn('personal_clipboard', 'title', [
                'type' => \ilDBConstants::T_TEXT,
                'length' => 255,
                'notnull' => false
            ]);
        }
    }
}