class.ilMDUpdateSteps10.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

class ilMDUpdateSteps10 implements ilDatabaseUpdateSteps
{
    protected \ilDBInterface $db;

    public function prepare(\ilDBInterface $db): void
    {
        $this->db = $db;
    }

    public function step_1(): void
    {
        if (!$this->db->tableExists('il_meta_oer_exposed')) {
            $this->db->createTable(
                'il_meta_oer_exposed',
                [
                    'obj_id' => [
                        'type' => ilDBConstants::T_INTEGER,
                        'notnull' => true,
                        'length' => 4
                    ],
                    'identifier' => [
                        'type' => ilDBConstants::T_TEXT,
                        'notnull' => true,
                        'length' => 64
                    ],
                    'datestamp' => [
                        'type' => ilDBConstants::T_INTEGER,
                        'notnull' => true,
                        'length' => 8
                    ],
                    'metadata' => [
                        'type' => ilDBConstants::T_CLOB,
                        'notnull' => true
                    ]
                ]
            );
            $this->db->addPrimaryKey('il_meta_oer_exposed', ['obj_id']);
        }
    }
}