ilCertificateDatabaseUpdateSteps11.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

class ilCertificateDatabaseUpdateSteps11 implements ilDatabaseUpdateSteps
{
    protected ilDBInterface $db;

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

    public function step_1(): void
    {
        if ($this->db->tableExists('il_cert_user_cert') &&
            $this->db->tableColumnExists('il_cert_user_cert', 'thumbnail_image_path')) {
            $this->db->renameTableColumn(
                'il_cert_user_cert',
                'thumbnail_image_path',
                'tile_image_path'
            );
        }
        if ($this->db->tableExists('il_cert_template') &&
            $this->db->tableColumnExists('il_cert_template', 'thumbnail_image_path')) {
            $this->db->renameTableColumn(
                'il_cert_template',
                'thumbnail_image_path',
                'tile_image_path'
            );
        }

        if ($this->db->tableExists('il_cert_user_cert') &&
            $this->db->tableColumnExists('il_cert_user_cert', 'thumbnail_image_ident')) {
            $this->db->renameTableColumn(
                'il_cert_user_cert',
                'thumbnail_image_ident',
                'tile_image_ident'
            );
        }
        if ($this->db->tableExists('il_cert_template') &&
            $this->db->tableColumnExists('il_cert_template', 'thumbnail_image_ident')) {
            $this->db->renameTableColumn(
                'il_cert_template',
                'thumbnail_image_ident',
                'tile_image_ident'
            );
        }
    }
}