ilUser8DBUpdateSteps Class Reference

Inheritance diagram for ilUser8DBUpdateSteps:

Collaboration diagram for ilUser8DBUpdateSteps:

Public Member Functions
	prepare (ilDBInterface $db)
	step_1 ()
	step_2 ()
	step_3 ()
	step_4 ()
	step_5 ()
	step_6 ()
Public Member Functions inherited from ilDatabaseUpdateSteps
	prepare (\ilDBInterface $db)
	Prepare the execution of the steps. More...

Protected Attributes
ilDBInterface	$db

Detailed Description

Definition at line 21 of file class.ilUser8DBUpdateSteps.php.

Member Function Documentation

prepare()

ilUser8DBUpdateSteps::prepare

(

ilDBInterface

$db

)

Definition at line 25 of file class.ilUser8DBUpdateSteps.php.

References $db.

                                              : void
    {
        $this->db = $db;
    }

step_1()

ilUser8DBUpdateSteps::step_1

(

)

Definition at line 30 of file class.ilUser8DBUpdateSteps.php.

References Vendor\Package\$e, $message, and ilDBConstants\T_TEXT.

                            : void
    {
        $this->db->modifyTableColumn(
            'usr_session',
            'session_id',
            [
                'type' => ilDBConstants::T_TEXT,
                'length' => '256'
            ]
        );
        $this->db->modifyTableColumn(
            'usr_session_stats_raw',
            'session_id',
            [
                'type' => ilDBConstants::T_TEXT,
                'length' => '256'
            ]
        );
        try {
            $this->db->modifyTableColumn(
                'usr_sess_istorage',
                'session_id',
                [
                    'type' => ilDBConstants::T_TEXT,
                    'length' => '256'
                ]
            );
        } catch (\Exception $e) {
            $message = "DB Hotfix 102: \n\n"
                . "We could not Update the length of the column `session_id` in the table\n"
                . "`usr_session_istorage` as the table engine is MyIsam.\n"
                . "This step will be finished after updating to ILIAS 8.\n"
                . "You could also lengthen the field manually after you ran the migration\n"
                . "to migrate to InnoDB, if you require longer session_ids.";
            global $ilLog;
            $ilLog->warning($message);
        }
    }

step_2()

ilUser8DBUpdateSteps::step_2

(

)

Definition at line 68 of file class.ilUser8DBUpdateSteps.php.

References ilDBConstants\T_INTEGER.

                            : void
    {
        $this->db->modifyTableColumn(
            'usr_data',
            'time_limit_from',
            [
                'type' => ilDBConstants::T_INTEGER,
                'length' => '8'
            ]
        );
        $this->db->modifyTableColumn(
            'usr_data',
            'time_limit_until',
            [
                'type' => ilDBConstants::T_INTEGER,
                'length' => '8'
            ]
        );
    }

step_3()

ilUser8DBUpdateSteps::step_3

(

)

Definition at line 88 of file class.ilUser8DBUpdateSteps.php.

                            : void
    {
        if (!$this->db->tableExists('usr_change_email_token')) {
            $this->db->createTable(
                'usr_change_email_token',
                [
                    'token' => [
                        'type'     => 'text',
                        'length'   => 32
                    ],
                    'new_email' => [
                        'type'     => 'text',
                        'length'   => 256
                    ],
                    'valid_until' => [
                        'type'     => 'integer',
                        'length'   => 8
                    ]
                ]
            );
        }
    }

step_4()

ilUser8DBUpdateSteps::step_4

(

)

Definition at line 111 of file class.ilUser8DBUpdateSteps.php.

References ilDBConstants\T_TEXT.

                            : void
    {
        if ($this->db->tableColumnExists('usr_data', 'street')) {
            $this->db->modifyTableColumn('usr_data', 'street', [
                'type' => \ilDBConstants::T_TEXT,
                'length' => 512,
                'notnull' => false
            ]);
        }
    }

step_5()

ilUser8DBUpdateSteps::step_5

(

)

Definition at line 122 of file class.ilUser8DBUpdateSteps.php.

                            : void
    {
        if (!$this->db->indexExistsByFields('usr_change_email_token', ['token'])) {
            $this->db->manipulate('DELETE token1 FROM usr_change_email_token token1 '
                . 'INNER JOIN usr_change_email_token token2 '
                . 'WHERE token1.token = token2.token AND token1.valid_until < token2.valid_until');
            $this->db->addPrimaryKey('usr_change_email_token', ['token']);
        }
    }

step_6()

ilUser8DBUpdateSteps::step_6

(

)

Definition at line 132 of file class.ilUser8DBUpdateSteps.php.

References ilDBConstants\T_TEXT.

                            : void
    {
        if ($this->db->tableColumnExists('personal_clipboard', 'title')) {
            $this->db->modifyTableColumn('personal_clipboard', 'title', [
                'type' => \ilDBConstants::T_TEXT,
                'length' => 255,
                'notnull' => false
            ]);
        }
    }

Field Documentation

$db

ilDBInterface ilUser8DBUpdateSteps::$db

protected

Definition at line 23 of file class.ilUser8DBUpdateSteps.php.

Referenced by prepare().

---

The documentation for this class was generated from the following file:

• Services/User/classes/Setup/class.ilUser8DBUpdateSteps.php