MailDBUpdateSteps11.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
namespace ILIAS\Mail\Setup;
 
use ilDBConstants;
use ilDBInterface;
use ilDatabaseUpdateSteps;
 
class MailDBUpdateSteps11 implements ilDatabaseUpdateSteps
{
    protected ilDBInterface $db;
 
    public function prepare(ilDBInterface $db): void
    {
        $this->db = $db;
    }
 
    public function step_1(): void
    {
        $this->db->update(
            'mail_obj_data',
            ['title' => [ilDBConstants::T_TEXT, 'f_sent']],
            ['m_type' => [ilDBConstants::T_TEXT, 'sent'], 'title' => [ilDBConstants::T_TEXT, 'e_sent']]
        );
    }
 
    public function step_2(): void
    {
        if (!$this->db->tableColumnExists('mail', 'schedule_datetime')) {
            $this->db->addTableColumn(
                'mail',
                'schedule_datetime',
                [
                    'type' => ilDBConstants::T_TIMESTAMP,
                    'notnull' => false,
                    'default' => null,
                ]
            );
        }
        if (!$this->db->tableColumnExists('mail', 'schedule_timezone')) {
            $this->db->addTableColumn(
                'mail',
                'schedule_timezone',
                [
                    'type' => ilDBConstants::T_TEXT,
                    'length' => 32,
                    'notnull' => false,
                    'default' => null
                ]
            );
        }
    }
}