class.ilLearningSequenceRectifyPostConditionsTableDBUpdateSteps.php

Go to the documentation of this file.

<?php

class ilLearningSequenceRectifyPostConditionsTableDBUpdateSteps implements \ilDatabaseUpdateSteps
{
    private const TABLE_NAME = "post_conditions";

    protected \ilDBInterface $db;

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

    public function step_1(): void
    {
        $this->db->dropPrimaryKey(self::TABLE_NAME);
        $this->db->addPrimaryKey(self::TABLE_NAME, ["ref_id"]);
    }

    public function step_2(): void
    {
        $this->db->modifyTableColumn(
            self::TABLE_NAME,
            "value",
            [
                "type" => "text",
                "length" => 255,
                "notnull" => false
            ]
        );
    }

    public function step_3(): void
    {
        $this->db->manipulate(
            "UPDATE " . self::TABLE_NAME . " SET value = NULL WHERE value = 0"
        );
    }
}