Migrations are used to create and/or edit the database structure. To generate a new migration file, use this command:
php vendor/bin/doctrine-migrations migrations:generate
It creates a PHP file like this one /data/doctrine/migrations/Version20220606131835.php
that can then be edited in the IDE.
You can add new queries in:
public function up
- these are executed when the migration is run.public function down
- these are optional queries that undo the above changes.This example creates a new column named test
.
Add this in public function up
:
$this->addSql('ALTER TABLE users ADD test VARCHAR(255) NOT NULL');
And its opposite in public function down
:
$this->addSql('ALTER TABLE users DROP test');