class.ilPortfolioDBUpdateSteps.php

Go to the documentation of this file.

<?php

namespace ILIAS\Portfolio\Setup;

class ilPortfolioDBUpdateSteps implements \ilDatabaseUpdateSteps
{
    protected \ilDBInterface $db;

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

    public function step_1(): void
    {
        $db = $this->db;
        if (!$db->tableExists('prtf_role_assignment')) {
            $fields = [
                'role_id' => [
                    'type' => 'integer',
                    'length' => 4,
                    'notnull' => true,
                    'default' => 0
                ],
                'template_ref_id' => [
                    'type' => 'integer',
                    'length' => 4,
                    'notnull' => true,
                    'default' => 0
                ]
            ];
            $db->createTable('prtf_role_assignment', $fields);
            $db->addPrimaryKey('prtf_role_assignment', ['role_id', 'template_ref_id']);
        }
    }
}