-- update/database/mysql/news/dbupdate-news-1.1.sql
ALTER TABLE exp_news_note ADD COLUMN archived INT NOT NULL DEFAULT 0;
UPDATE exp_news_note SET archived = 1 WHERE id < 100;

./console exp:migration:generate --skeleton news_note_archived --description="The column archived of exp_news_note, set on the old notes" --apply

Exponential migrations: generate
Wrote migrations/20261101160000_news_note_archived.php
Migration 20261101160000_news_note_archived, class \Site\Migrations\NewsNoteArchived20261101160000
Next: fill in plan() and up(), then ./console exp:migration:check and ./console exp:migration:dry-run
PASS

<?php
// description: The column archived of exp_news_note, set on the old notes
// engines: mysql, postgresql, sqlite, oracle
// author: Site team
namespace Site\Migrations;

final class NewsNoteArchived20261101160000 extends \expMigrationPhp
{
    const TABLE = 'exp_news_note';

    public function plan( $context )
    {
        return array( 'add the column ' . self::TABLE . '.archived', 'mark the notes below id 100 as archived' );
    }

    public function up( $context )
    {
        $db = $context->db();
        $done = array();
        if ( \expUpgradeCatalog::hasColumn( $db, self::TABLE, 'archived' ) !== true )
        {
            $type = $context->engine() === 'oracle' ? 'NUMBER(11)' : 'INTEGER';
            \expUpgradeCatalog::execute( $db, 'ALTER TABLE ' . self::TABLE . " ADD archived $type DEFAULT 0 NOT NULL;\n" );
            \expKernelTableSchema::reset();
            $done[] = 'added the column ' . self::TABLE . '.archived';
        }
        $db->query( 'UPDATE ' . self::TABLE . ' SET archived = 1 WHERE id < 100' );
        $done[] = 'marked the notes below id 100 as archived';
        return $done;
    }

    public function down( $context )
    {
        \expUpgradeCatalog::execute( $context->db(), 'ALTER TABLE ' . self::TABLE . " DROP COLUMN archived;\n" );
        \expKernelTableSchema::reset();
        return array( 'dropped the column ' . self::TABLE . '.archived' );
    }
}

./console exp:migration:check
./console exp:migration:migrate
./console exp:migration:migrate --apply

  applied     20261101160000_news_note_archived             site               The column archived of exp_news_note, set on the old notes
              added the column exp_news_note.archived
              marked the notes below id 100 as archived

Captions: pre 20261101-160105, post 20261101-160106
Repository: commit 9a8b7c6d5e4f, tag migrations/staging/20261101-160105-1f2e3d, push pushed