ShortlinksDBSteps11.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
namespace ILIAS\StaticURL\Setup\Shortlinks;
 
class ShortlinksDBSteps11 implements \ilDatabaseUpdateSteps
{
    private \ilDBInterface $db;
 
    public function prepare(\ilDBInterface $db): void
    {
        $this->db = $db;
    }
 
    public function step_1(): void
    {
        $fields = [
            'id' => [
                'type' => 'text',
                'length' => 32,
                'notnull' => true,
            ],
            'alias' => [
                'type' => 'text',
                'length' => 255,
                'notnull' => true
            ],
            'target_type' => [
                'type' => 'text',
                'length' => 8,
                'notnull' => true
            ],
            'target_type_data' => [
                'type' => 'clob',
                'notnull' => false,
            ],
            'position' => [
                'type' => 'integer',
                'notnull' => true,
            ],
            'active' => [
                'type' => 'integer',
                'length' => 1,
                'notnull' => true,
                'default' => 1,
            ],
            'used' => [
                'type' => 'integer',
                'notnull' => true,
                'default' => 0,
            ],
        ];
 
        $this->db->createTable('il_shortlinks', $fields);
 
        $this->db->addPrimaryKey(
            'il_shortlinks',
            ['id']
        );
 
        $this->db->addIndex(
            'il_shortlinks',
            ['alias'],
            'i1'
        );
    }
 
}