Yii2 migrate/create with {{%table}} option

Question

Is it possible to create a migration using the yii migrate/create command in Yii2, which can create a table with table prefix?

For example:

public function up()
{
    $this->createTable('{{%settings}}', [
        'id' => $this->primaryKey(),
        'keyname' => $this->string()->unique(),
        'description' => $this->text(),
        'value' => $this->string(),
        'type' => $this->string()
    ]);
}

I want to get result like above example, but yii migrate/create command creates without {{%...}}

score 3 · Accepted Answer · answered Sep 27 '17 at 07:32

3

Use

yii migrate/create name --useTablePrefix=1

answered Sep 27 '17 at 07:32

Bizley

17,392
5
49
59

May I know what's the purpose of `{{%...}}`? thankyou – Blackjack Nov 30 '17 at 14:03
1

@Blackjack https://stackoverflow.com/questions/38698129/yii2-migrations-percentage-sign-and-brackets-in-table-name – Bizley Nov 30 '17 at 14:06
@Bizley thanks for the knowledge :) I've any issue about prefix, can you take a look my SO? – Blackjack Nov 30 '17 at 14:29

Yii2 migrate/create with {{%table}} option

1 Answers1