DBUpdateSteps10.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
namespace ILIAS\Export\Setup;
 
use ilDatabaseUpdateSteps;
use ilDBConstants;
use ilDBInterface;
 
class DBUpdateSteps10 implements ilDatabaseUpdateSteps
{
    protected ilDBInterface $db;
 
    public function prepare(ilDBInterface $db): void
    {
        $this->db = $db;
    }
 
    public function step_1(): void
    {
        if ($this->db->tableExists("export_files")) {
            return;
        }
        $this->db->createTable("export_files", [
            'object_id' => [
                'type' => 'integer',
                'length' => 8,
                'default' => 0,
                'notnull' => true
            ],
            'rid' => [
                'type' => 'text',
                'length' => 64,
                'default' => '',
                'notnull' => true
            ],
            'owner_id' => [
                'type' => 'integer',
                'length' => 8,
                'default' => 0,
                'notnull' => true
            ],
            'timestamp' => [
                'type' => 'timestamp',
                'notnull' => false
            ],
        ]);
        $this->db->addPrimaryKey("export_files", ["object_id", "rid"]);
    }
 
    public function step_2(): void
    {
        if ($this->db->tableExists("export_public_access")) {
            return;
        }
        $this->db->createTable("export_public_access", [
            'object_id' => [
                'type' => 'integer',
                'length' => 8,
                'default' => 0,
                'notnull' => true
            ],
            'export_option_id' => [
                'type' => 'text',
                'length' => 64,
                'default' => '',
                'notnull' => true
            ],
            'identification' => [
                'type' => 'text',
                'length' => 64,
                'default' => '',
                'notnull' => true
            ],
            'timestamp' => [
                'type' => 'timestamp',
                'notnull' => false
            ],
        ]);
        $this->db->addPrimaryKey("export_public_access", ["object_id"]);
    }
 
    public function step_3(): void
    {
        if (!$this->db->tableExists("export_file_info")) {
            return;
        }
        if (
            $this->db->tableColumnExists("export_file_info", "migrated")
        ) {
            return;
        }
        $this->db->addTableColumn("export_file_info", "migrated", [
            'type' => ilDBConstants::T_INTEGER,
            'length' => 4,
            'default' => 0
        ]);
    }
}