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"
        );
    }
}