# 生成迁移脚本
./vendor/bin/doctrine-migrations migrations:generate
# 执行迁移到最新版本
./vendor/bin/doctrine-migrations migrations:migrate
# 回到最初版本
./vendor/bin/doctrine-migrations migrations:migrate first
# 回到上一个版本
./vendor/bin/doctrine-migrations migrations:migrate prev
# 切换到下一个版本
./vendor/bin/doctrine-migrations migrations:migrate next
# --dry-run是空转参数,只显示操作结果,不执行修改
./vendor/bin/doctrine-migrations migrations:migrate --dry-run
# 不执行操作,只写入文件,对于生产环境需要手动验证并执行的场景有用
./vendor/bin/doctrine-migrations migrations:migrate --write-sql=file.sql
# 执行到最新版本,和不使用latest参数效果一样
./vendor/bin/doctrine-migrations migrations:migrate latest
# 查看详细信息
./vendor/bin/doctrine-migrations status
public function up(Schema $schema)
{
$table = $schema->createTable($this->tableName);
$table->addColumn('id', 'integer')->setUnsigned(true)->setAutoincrement(true);
$table->addColumn('uid', 'integer')->setDefault(0)->setUnsigned(true)->setComment('关联user.id');
$table->addColumn('title', 'string')->setComment('标题');
$table->addColumn('status', 'tinyint')->setComment('状态:1.测试1,2.测试2');
$table->addColumn('score', 'decimal')->setLength(5)->setScale(2)->setDefault(0.00)->setComment('分数');
// 添加主键和索引-必须在字段添加之后执行添加,索引一般最后操作索引。
$table->setPrimaryKey(['id'])->addUniqueIndex(['uid'])->addIndex(['status']);
}