installation-bundle/src/Database/Version450Update.php
public function run(): void
    {
        $this->connection->query('
            ALTER TABLE
                tl_content
            ADD
                youtubeOptions text NULL
        ');

        $this->connection->query('
            ALTER TABLE
                tl_content
            ADD
                youtubeStart int(10) unsigned NOT NULL default 0
        ');

        $this->connection->query('
            ALTER TABLE
                tl_content
            ADD
                youtubeStop int(10) unsigned NOT NULL default 0
        ');

        $this->connection->query("
            UPDATE
                tl_form_field
            SET
                type = 'fieldsetStart'
            WHERE
                type = 'fieldset' AND fsType = 'fsStart'
        ");

        $this->connection->query("
            UPDATE
                tl_form_field
            SET
                type = 'fieldsetStop'
            WHERE
                type = 'fieldset' AND fsType = 'fsStop'
        ");

        $columns = $this->connection
            ->getSchemaManager()
            ->listTableColumns('tl_module')
        ;

        if (isset($columns['news_order'])) {
            $this->connection->query("
                UPDATE
                    tl_module
                SET
                    news_order = 'order_date_asc'
                WHERE
                    news_order = 'ascending'
            ");

            $this->connection->query("
                UPDATE
                    tl_module
                SET
                    news_order = 'order_date_desc'
                WHERE
                    news_order = 'descending'
            ");
        }

        $this->connection->query('
            ALTER TABLE
                tl_layout
            ADD
                externalJs BLOB DEFAULT NULL
        ');
    }
public function run(): void
    {
        $this->connection->query('
            ALTER TABLE
                tl_content
            ADD
                youtubeOptions text NULL
        ');

        $this->connection->query('
            ALTER TABLE
                tl_content
            ADD
                youtubeStart int(10) unsigned NOT NULL default 0
        ');

        $this->connection->query('
            ALTER TABLE
                tl_content
            ADD
                youtubeStop int(10) unsigned NOT NULL default 0
        ');

        $this->connection->query("
            UPDATE
                tl_form_field
            SET
                type = 'fieldsetStart'
            WHERE
                type = 'fieldset' AND fsType = 'fsStart'
        ");

        $this->connection->query("
            UPDATE
                tl_form_field
            SET
                type = 'fieldsetStop'
            WHERE
                type = 'fieldset' AND fsType = 'fsStop'
        ");

        $columns = $this->connection
            ->getSchemaManager()
            ->listTableColumns('tl_module')
        ;

        if (isset($columns['news_order'])) {
            $this->connection->query("
                UPDATE
                    tl_module
                SET
                    news_order = 'order_date_asc'
                WHERE
                    news_order = 'ascending'
            ");

            $this->connection->query("
                UPDATE
                    tl_module
                SET
                    news_order = 'order_date_desc'
                WHERE
                    news_order = 'descending'
            ");
        }

        $this->connection->query('
            ALTER TABLE
                tl_layout
            ADD
                externalJs BLOB DEFAULT NULL
        ');
    }
{@inheritdoc}