class.ilAdministrationDBUpdateSteps.php

Go to the documentation of this file.

<?php
 
namespace ILIAS\Administration\Setup;
 
class ilAdministrationDBUpdateSteps implements \ilDatabaseUpdateSteps
{
    protected \ilDBInterface $db;
 
    public function prepare(\ilDBInterface $db): void
    {
        $this->db = $db;
    }
 
    public function step_1(): void
    {
        $this->db->addTableColumn(
            'settings',
            'value2',
            array(      "type" => "text",
                      "length" => 4000,
                      "notnull" => false,
                      "default" => null)
        );
 
        $this->db->query("UPDATE settings SET value2 = SUBSTRING(value, 1, 4000)");
        $this->db->dropTableColumn('settings', 'value');
        $this->db->renameTableColumn('settings', 'value2', 'value');
    }
}