ilECSUpdateSteps8.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
class ilECSUpdateSteps8 implements ilDatabaseUpdateSteps
{
    protected ilDBInterface $db;
 
    public function prepare(ilDBInterface $db): void
    {
        $this->db = $db;
    }
 
    public function step_1(): void
    {
        if (!$this->db->tableExists('ecs_user_consent')) {
            $this->db->createTable('ecs_user_consent', [
                'usr_id' => [
                    'type' => ilDBConstants::T_INTEGER,
                    'length' => 4,
                    'notnull' => true
                ],
                'mid' => [
                    'type' => ilDBConstants::T_INTEGER,
                    'length' => 4,
                    'notnull' => true,
                ]
            ]);
            $this->db->addPrimaryKey('ecs_user_consent', ['usr_id', 'mid']);
        }
    }
 
    public function step_2(): void
    {
        if (!$this->db->tableColumnExists('ecs_part_settings', 'username_placeholders')) {
            $this->db->addTableColumn(
                'ecs_part_settings',
                'username_placeholders',
                [
                    'type' => ilDBConstants::T_TEXT,
                    'notnull' => false,
                    'length' => 500,
                    'default' => null
                ]
            );
        }
    }
 
    public function step_3(): void
    {
        if (!$this->db->tableColumnExists('ecs_part_settings', 'incoming_auth_type')) {
            $this->db->addTableColumn(
                'ecs_part_settings',
                'incoming_auth_type',
                [
                    'type' => ilDBConstants::T_TEXT,
                    'notnull' => true,
                    'length' => 1,
                    'default' => 0
                ]
            );
        }
    }
 
    public function step_4(): void
    {
        if (!$this->db->tableColumnExists('ecs_part_settings', 'incoming_local_accounts')) {
            $this->db->addTableColumn(
                'ecs_part_settings',
                'incoming_local_accounts',
                [
                    'type' => ilDBConstants::T_INTEGER,
                    'notnull' => true,
                    'length' => 1,
                    'default' => 1
                ]
            );
        }
    }
 
    public function step_5(): void
    {
        if (!$this->db->tableColumnExists('ecs_part_settings', 'outgoing_auth_mode')) {
            $this->db->addTableColumn(
                'ecs_part_settings',
                'outgoing_auth_mode',
                [
                    'type' => ilDBConstants::T_TEXT,
                    'notnull' => false,
                    'length' => 64,
                    'default' => ''
                ]
            );
        }
    }
 
    public function step_6(): void
    {
        if ($this->db->tableColumnExists('ecs_part_settings', 'outgoing_auth_mode')) {
            $this->db->renameTableColumn(
                'ecs_part_settings',
                'outgoing_auth_mode',
                'outgoing_auth_modes'
            );
        }
    }
 
    public function step_7(): void
    {
        if (!$this->db->tableColumnExists('ecs_user_consent', 'server_id')) {
            $this->db->addTableColumn(
                'ecs_user_consent',
                'server_id',
                [
                    'type' => ilDBConstants::T_INTEGER,
                    'length' => 4,
                    'notnull' => true
                ]
            );
        }
    }
}