Now let’s say you realize that you made a design error and you want to roll back the last migration run. You can do the same for a specific bundle by using the same command but with the bundle’s name. You can however run all the migrations in the application folder by the command: php artisan migrate application
To execute all outstanding migrations, run: php artisan migrateĬurrently it is not possible to run a specific migration. Now this file won’t do anything if it just sits there. The down() method is simpler than its predecessor and simply tells the database to drop the users table. The final columns are created by the timestamps() method which creates “created_at” and “updated_at” columns. “username”) and the second is the size of the column (e.g. The first parameter to string() is the name of the column (e.g. The first is an auto-incrementing ID column, followed by VARCHAR columns for a username, email, and password. The up() method runs when the migration is executed and creates the users table which holds five columns. Open the file and you’ll see a class with the two methods up() and down(). Be sure to use a descriptive name so that it’s clear what the migration does from just a glance. Artisan adds the date and time of the command’s execution as a prefix to the file, so the file would be named something like “2012_07_25_071925_create_users_table.php”. You can find your migration file inside the application/migrations folder. This creates the migration file which handles the users table. To create a new migration, run this command: php artisan migrate:make create_users_table This command causes Artisan to create a special table in your database to keep track of what migrations have already been executed.
Run the following command: php artisan migrate:install Open a console and navigate to the root directory of your Laravel install.
#ARTISAN ROLL TABLE INSTALL#
It all seems pretty cool, doesn’t it? But how does it work for Laravel? First you have to configure your database connection, and then you use Artisan, Laravel’s command line interface, to install the migrations table and run, revert, create… migrations. Not happy with it? Revert it and you’re back on track.
#ARTISAN ROLL TABLE UPDATE#
If you need to update the database, you just create a new migration and voilà. The down() method is run to revert the changes. The up() method is run when the migration is executed to apply changes to the database. In short, migrations are files which contain a class definition with both an up() and a down() method. Laravel, the MVC framework which I wrote about previously, offers you migrations. For those who struggle with maintaining their database schema, or who have problems applying updates and often revert them, there is a solution.
0 kommentar(er)
