ilCourseDBUpdateSteps Class Reference

Inheritance diagram for ilCourseDBUpdateSteps:

Collaboration diagram for ilCourseDBUpdateSteps:

Public Member Functions
	prepare (ilDBInterface $db)
	step_1 ()
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 ilCourseDBUpdateSteps.php.

Member Function Documentation

prepare()

ilCourseDBUpdateSteps::prepare

(

ilDBInterface

$db

)

Definition at line 25 of file ilCourseDBUpdateSteps.php.

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

References $db.

step_1()

ilCourseDBUpdateSteps::step_1

(

)

Definition at line 30 of file ilCourseDBUpdateSteps.php.

                            : void
    {
        $ilDB = $this->db;
 
 
        if ($ilDB->tableColumnExists('crs_archives', 'archive_date')) {
            $ilDB->modifyTableColumn('crs_archives', 'archive_date', [
                'type' => 'integer',
                'length' => 8,
                'notnull' => false,
                'default' => null
            ]);
        }
        if ($ilDB->tableColumnExists('crs_items', 'timing_start')) {
            $ilDB->modifyTableColumn('crs_items', 'timing_start', [
                'type' => 'integer',
                'length' => 8,
                'notnull' => true,
                'default' => 0
            ]);
        }
        if ($ilDB->tableColumnExists('crs_items', 'timing_end')) {
            $ilDB->modifyTableColumn('crs_items', 'timing_end', [
                'type' => 'integer',
                'length' => 8,
                'notnull' => true,
                'default' => 0
            ]);
        }
        if ($ilDB->tableColumnExists('crs_items', 'suggestion_start')) {
            $ilDB->modifyTableColumn('crs_items', 'suggestion_start', [
                'type' => 'integer',
                'length' => 8,
                'notnull' => true,
                'default' => 0
            ]);
        }
        if ($ilDB->tableColumnExists('crs_items', 'suggestion_end')) {
            $ilDB->modifyTableColumn('crs_items', 'suggestion_end', [
                'type' => 'integer',
                'length' => 8,
                'notnull' => true,
                'default' => 0
            ]);
        }
        if ($ilDB->tableColumnExists('crs_items', 'suggestion_start_rel')) {
            $ilDB->modifyTableColumn('crs_items', 'suggestion_start_rel', [
                'type' => 'integer',
                'length' => 8,
                'notnull' => false,
                'default' => 0
            ]);
        }
        if ($ilDB->tableColumnExists('crs_items', 'suggestion_end_rel')) {
            $ilDB->modifyTableColumn('crs_items', 'suggestion_end_rel', [
                'type' => 'integer',
                'length' => 8,
                'notnull' => false,
                'default' => 0
            ]);
        }
        if ($ilDB->tableColumnExists('crs_lm_history', 'last_access')) {
            $ilDB->modifyTableColumn('crs_lm_history', 'last_access', [
                'type' => 'integer',
                'length' => 8,
                'notnull' => true,
                'default' => 0
            ]);
        }
        if ($ilDB->tableColumnExists('crs_settings', 'activation_start')) {
            $ilDB->modifyTableColumn('crs_settings', 'activation_start', [
                'type' => 'integer',
                'length' => 8,
                'notnull' => false,
                'default' => null
            ]);
        }
        if ($ilDB->tableColumnExists('crs_settings', 'activation_end')) {
            $ilDB->modifyTableColumn('crs_settings', 'activation_end', [
                'type' => 'integer',
                'length' => 8,
                'notnull' => false,
                'default' => null
            ]);
        }
        if ($ilDB->tableColumnExists('crs_settings', 'sub_start')) {
            $ilDB->modifyTableColumn('crs_settings', 'sub_start', [
                'type' => 'integer',
                'length' => 8,
                'notnull' => false,
                'default' => null
            ]);
        }
        if ($ilDB->tableColumnExists('crs_settings', 'sub_end')) {
            $ilDB->modifyTableColumn('crs_settings', 'sub_end', [
                'type' => 'integer',
                'length' => 8,
                'notnull' => false,
                'default' => null
            ]);
        }
        if ($ilDB->tableColumnExists('crs_settings', 'archive_start')) {
            $ilDB->modifyTableColumn('crs_settings', 'archive_start', [
                'type' => 'integer',
                'length' => 8,
                'notnull' => false,
                'default' => null
            ]);
        }
        if ($ilDB->tableColumnExists('crs_settings', 'archive_end')) {
            $ilDB->modifyTableColumn('crs_settings', 'archive_end', [
                'type' => 'integer',
                'length' => 8,
                'notnull' => false,
                'default' => null
            ]);
        }
        if ($ilDB->tableColumnExists('crs_settings', 'crs_start')) {
            $ilDB->modifyTableColumn('crs_settings', 'crs_start', [
                'type' => 'integer',
                'length' => 8,
                'notnull' => false,
                'default' => null
            ]);
        }
        if ($ilDB->tableColumnExists('crs_settings', 'crs_end')) {
            $ilDB->modifyTableColumn('crs_settings', 'crs_end', [
                'type' => 'integer',
                'length' => 8,
                'notnull' => false,
                'default' => null
            ]);
        }
        if ($ilDB->tableColumnExists('crs_settings', 'leave_end')) {
            $ilDB->modifyTableColumn('crs_settings', 'leave_end', [
                'type' => 'integer',
                'length' => 8,
                'notnull' => false,
                'default' => null
            ]);
        }
        if ($ilDB->tableColumnExists('crs_timings_planed', 'planed_start')) {
            $ilDB->modifyTableColumn('crs_timings_planed', 'planed_start', [
                'type' => 'integer',
                'length' => 8,
                'notnull' => true,
                'default' => 0
            ]);
        }
        if ($ilDB->tableColumnExists('crs_timings_planed', 'planed_end')) {
            $ilDB->modifyTableColumn('crs_timings_planed', 'planed_end', [
                'type' => 'integer',
                'length' => 8,
                'notnull' => true,
                'default' => 0
            ]);
        }
        if ($ilDB->tableColumnExists('crs_timings_user', 'sstart')) {
            $ilDB->modifyTableColumn('crs_timings_user', 'sstart', [
                'type' => 'integer',
                'length' => 8,
                'notnull' => true,
                'default' => 0
            ]);
        }
        if ($ilDB->tableColumnExists('crs_timings_user', 'ssend')) {
            $ilDB->modifyTableColumn('crs_timings_user', 'ssend', [
                'type' => 'integer',
                'length' => 8,
                'notnull' => true,
                'default' => 0
            ]);
        }
        if ($ilDB->tableColumnExists('crs_waiting_list', 'sub_time')) {
            $ilDB->modifyTableColumn('crs_waiting_list', 'sub_time', [
                'type' => 'integer',
                'length' => 8,
                'notnull' => true,
                'default' => 0
            ]);
        }
    }

References $db, and $ilDB.

Field Documentation

$db

ilDBInterface ilCourseDBUpdateSteps::$db

protected

Definition at line 23 of file ilCourseDBUpdateSteps.php.

Referenced by prepare(), and step_1().

---

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

• components/ILIAS/Course/Setup/ilCourseDBUpdateSteps.php