Inheritance diagram for ilStudyProgrammeSettingsTableUpdateSteps:

Collaboration diagram for ilStudyProgrammeSettingsTableUpdateSteps:

Public Member Functions
	prepare (ilDBInterface $db)

	step_1 ()

	step_2 ()

Public Member Functions inherited from ilDatabaseUpdateSteps
	prepare (\ilDBInterface $db)
	Prepare the execution of the steps. More...

Data Fields
const	TABLE_NAME = 'prg_settings'

const	TABLE_PROGRESSES = 'prg_usr_progress'

Protected Attributes
ilDBInterface	$db

Detailed Description

Definition at line 21 of file ilStudyProgrammeSettingsTableUpdateSteps.php.

Member Function Documentation

◆ prepare()

ilStudyProgrammeSettingsTableUpdateSteps::prepare ( ilDBInterface $db )

Definition at line 28 of file ilStudyProgrammeSettingsTableUpdateSteps.php.

References $db.

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

◆ step_1()

ilStudyProgrammeSettingsTableUpdateSteps::step_1 ( )

Definition at line 33 of file ilStudyProgrammeSettingsTableUpdateSteps.php.

                             : void
     {
         $column_name = 'vq_restart_recheck';
 
         if (!$this->db->tableColumnExists(self::TABLE_NAME, $column_name)) {
             $this->db->addTableColumn(
                 self::TABLE_NAME,
                 $column_name,
                 [
                     'type' => 'integer',
                     'length' => 1,
                     'default' => 0,
                     'notnull' => false
                 ]
             );
         }
     }

◆ step_2()

ilStudyProgrammeSettingsTableUpdateSteps::step_2 ( )

Definition at line 51 of file ilStudyProgrammeSettingsTableUpdateSteps.php.

                             : void
     {
         if (!$this->db->indexExistsByFields(self::TABLE_NAME, ['assignment_id', 'prg_id', 'usr_id'])) {
             $this->db->dropPrimaryKey(self::TABLE_PROGRESSES);
             $this->db->addPrimaryKey(
                 self::TABLE_PROGRESSES,
                 [
                     'assignment_id',
                     'prg_id',
                     'usr_id'
                 ]
             );
         }
     }