DBHTMLExportUpdateSteps.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
namespace ILIAS\Export\HTML\Setup;
 
use ilDatabaseUpdateSteps;
use ilDBConstants;
use ilDBInterface;
 
class DBHTMLExportUpdateSteps 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_html")) {
            $this->db->createTable("export_files_html", [
                'object_id' => [
                    'type' => 'integer',
                    'length' => 8,
                    'default' => 0,
                    'notnull' => true
                ],
                'rid' => [
                    'type' => 'text',
                    'length' => 64,
                    'default' => '',
                    'notnull' => true
                ],
                'timestamp' => [
                    'type' => 'timestamp',
                    'notnull' => false
                ],
                'type' => [
                    'type' => 'text',
                    'length' => 10,
                    'default' => '',
                    'notnull' => true
                ],
            ]);
            $this->db->addPrimaryKey("export_files_html", ["object_id", "rid"]);
        }
    }
 
    public function step_2(): void
    {
    }
 
    public function step_3(): void
    {
    }
 
    public function step_4(): void
    {
        $this->db->modifyTableColumn("export_files_html", "type", [
            'type' => 'text',
            'length' => 40,
            'default' => '',
            'notnull' => true
        ]);
    }
}