Penggunaan Yii2 Migration

Published 9 years ago in Yii2 1 min read

Referensi: http://www.yiiframework.com/doc-2.0/guide-db-migrations.html Buka terminal, masuk ke root folder project: Ceritanya mau bikin table pegawai

ketik: yii migrate/create create_pegawai_table -> akan menggenerate skeleton code di folder migrations (m160928_024257_create_pegawai_table.php)

edit file: m160928_024257_create_pegawai_table.php (Referensi: http://www.yiiframework.com/doc-2.0/yii-db-schemabuildertrait.html) misal:

$this->createTable('pegawai', [
    'id' => $this->primaryKey(),
    'name' => $this->string(64)->notNull(),
    'type' => $this->integer()->notNull()->defaultValue(10),
    'description' => $this->text(),
    'rule_name' => $this->string(64),
    'data' => $this->text(),
    'created_at' => $this->datetime()->notNull(),
    'updated_at' => $this->datetime(),
]);

ketik: yii migrate -> eksekusi migrate ke versi terakhir
revert migration: yii migrate/down default Yii2, down berarti drop table
misal ada perubahan pada migration file, untuk update, bisa yii migrate/down dulu, baru kemudian yii migrate lagi
CMIIW