class.ilScorm2004DatabaseUpdateSteps.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
class ilScorm2004DatabaseUpdateSteps implements ilDatabaseUpdateSteps
{
    protected ilDBInterface $db;
 
    public function prepare(ilDBInterface $db): void
    {
        $this->db = $db;
    }
 
    public function step_1(): void
    {
        $this->db->modifyTableColumn("cmi_interaction", "c_timestamp", array("type" => "text", "length" => 40, "notnull" => false, 'default' => null));
    }
 
    public function step_2(): void
    {
        $this->db->modifyTableColumn("cp_dependency", "resourceid", array("type" => "text", "length" => 200, "notnull" => false, 'default' => null));
    }
 
    public function step_3(): void
    {
        if (!$this->db->indexExistsByFields('sahs_user', ['user_id'])) {
            $this->db->addIndex('sahs_user', ['user_id'], 'i1');
        }
    }
}