final class Version20261101100000 extends AbstractMigration
{
    public function getDescription(): string
    {
        return 'A table for news notes';
    }

    public function up( Schema $schema ): void
    {
        $this->addSql( 'CREATE TABLE news_note (id INT NOT NULL, title VARCHAR(150) NOT NULL, PRIMARY KEY(id))' );
    }

    public function down( Schema $schema ): void
    {
        $this->addSql( 'DROP TABLE news_note' );
    }
}

<?php
// description: A table for news notes
namespace Site\Migrations;

final class NewsNote20261101100000 extends \expMigrationPhp
{
    const TABLE = 'news_note';

    public static function schema()
    {
        return array( self::TABLE => array(
            'name' => self::TABLE,
            'fields' => array(
                'id' => array( 'length' => 11, 'type' => 'int', 'not_null' => '1', 'default' => 0 ),
                'title' => array( 'length' => 150, 'type' => 'varchar', 'not_null' => '1', 'default' => '' ),
            ),
            'indexes' => array( 'PRIMARY' => array( 'type' => 'primary', 'fields' => array( 'id' ) ) ),
        ) );
    }

    public function plan( $context )
    {
        return array( 'create the table ' . self::TABLE );
    }

    public function detect( $context )
    {
        return \expKernelTableSchema::exists( self::TABLE, $context->db(), true ) ? \expMigration::DONE : null;
    }

    public function up( $context )
    {
        $messages = array();
        if ( !\expKernelTableSchema::install( array( self::TABLE ), $context->db(), self::schema(), $messages ) )
            throw new \RuntimeException( 'the table could not be created: ' . implode( '; ', $messages ) );
        return array( 'created ' . self::TABLE );
    }

    public function down( $context )
    {
        $context->db()->query( 'DROP TABLE ' . self::TABLE );
        \expKernelTableSchema::reset();
        return array( 'dropped ' . self::TABLE );
    }
}