PHP工作笔记：使用yii migrate管理、生成数据库

phpStudy/WWW/local/ddc_dlss 

./yii migrate

删除files表的data字段

$ ./yii migrate/create del_colum_data_in_files_table

 ./yii migrate m130524_201442_init.php

在file_monitor'表添加order_file_num字段，整形，长度为6

<?php

use yii\db\Migration;
use  yii\db\Schema;
//在file_monitor'表添加order_file_num字段
class m161209_015401_add_colum_order_file_num_in_file_monitor_table extends Migration
{
    public function up()
    {
        if(!isset(Yii::$app->db->getTableSchema('file_monitor')->columns['order_file_num'])){
            $this->addColumn('file_monitor','order_file_num', Schema::TYPE_INTEGER.'(6)  COMMENT "订单文件数"');
        }
    }

    public function down()
    {
        echo "m161209_015401_add_colum_order_file_num_in_file_monitor_table cannot be reverted.\n";

        return false;
    }

    /*
    // Use safeUp/safeDown to run migration code within a transaction
    public function safeUp()
    {
    }

    public function safeDown()
    {
    }
    */
}

Migration.php（各种数据库表创建修改方法）和Schema.php（设置字段类型、长度等用到）看看