class.ilCalendarDBUpdateSteps9.php

Go to the documentation of this file.

<?php
declare(strict_types=1);

class ilCalendarDBUpdateSteps9 implements ilDatabaseUpdateSteps
{
    protected \ilDBInterface $db;

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

    public function step_1(): void
    {
        // Add indices
        if (!$this->db->indexExistsByFields('cal_entries', ['starta'])) {
            $this->db->addIndex('cal_entries', ['starta'], 'i3');
        }
        if (!$this->db->indexExistsByFields('cal_entries', ['enda'])) {
            $this->db->addIndex('cal_entries', ['enda'], 'i4');
        }
    }

    public function step_2(): void
    {
        // Removes is_milestones column from cal_entries
        if($this->db->tableExists('cal_entries')
            && $this->db->tableColumnExists('cal_entries', 'is_milestone')) {
            $this->db->dropTableColumn('cal_entries', 'is_milestone');
        }
        // Removes completion column from cal_entries
        if($this->db->tableExists('cal_entries')
            && $this->db->tableColumnExists('cal_entries', 'completion')) {
            $this->db->dropTableColumn('cal_entries', 'completion');
        }
        // Deletes table cal_entry_responsible
        if($this->db->tableExists('cal_entry_responsible')) {
            $this->db->dropTable('cal_entry_responsible');
        }

        $query = 'delete from settings where ' .
            'keyword = ' . $this->db->quote('enable_grp_milestones', ilDBConstants::T_TEXT) . ' ' .
            'and module = ' . $this->db->quote('calendar', ilDBConstants::T_TEXT);
        $this->db->manipulate($query);
    }
}