ilUserTableUpdateSteps.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
class ilUserTableUpdateSteps implements ilDatabaseUpdateSteps
{
    public const TABLE_NAME = 'usr_data';
 
    protected ilDBInterface $db;
 
    public function prepare(ilDBInterface $db): void
    {
        $this->db = $db;
    }
 
    public function step_1(): void
    {
        $query = 'ALTER TABLE ' . self::TABLE_NAME . ' MODIFY firstname VARCHAR(128);';
        $this->db->manipulate($query);
    }
    public function step_2(): void
    {
        $query = 'ALTER TABLE ' . self::TABLE_NAME . ' MODIFY lastname VARCHAR(128);';
        $this->db->manipulate($query);
    }
    public function step_3(): void
    {
        $query = 'ALTER TABLE ' . self::TABLE_NAME . ' MODIFY email VARCHAR(128);';
        $this->db->manipulate($query);
    }
 
}