class.ilIndividualAssessmentRectifyMembersTableDBUpdateSteps.php

Go to the documentation of this file.

<?php

class ilIndividualAssessmentRectifyMembersTableDBUpdateSteps implements \ilDatabaseUpdateSteps
{
    private const TABLE_NAME = "iass_members";

    protected \ilDBInterface $db;

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

    public function step_1(): void
    {
        $this->db->modifyTableColumn(
            self::TABLE_NAME,
            "examiner_id",
            [
                "type" => "integer",
                "length" => 4,
                "notnull" => false,
                "default" => null
            ]
        );
    }

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