What is the best way to write base-independent migrations?

Question

Yii

Actually the question is how best to write migrations? What would they be adaptable to different bases?
Through the Schema class

$this->createTable('{{%someTable}}', [
            'id' => Schema::TYPE_PK,
            'notes' => Schema::TYPE_TEXT,
        ], $tableOptions);

or so?

$this->createTable('{{%someTable}}', [
            'id' => $this->primaryKey(),
            'notes' => $this->text(),
        ], $tableOptions);

Are they equivalent or not?

Answer 1

Are equivalent. Just take a look at the implementation of the methods.

/**
     * Creates a boolean column.
     * @return ColumnSchemaBuilder the column instance which can be further customized.
     * @since 2.0.6
     */
    public function boolean()
    {
        return $this->getDb()->getSchema()->createColumnSchemaBuilder(Schema::TYPE_BOOLEAN);
    }