Migrations in Tina4

You want to create a table for the database? Migrations are sequential SQL statements which keep track of your database changes. We recommend using migrations especially when you want to apply changes to a running system or when working in a team.

Windows

 c:\projectfolder\migrations\

Linux

 /home/username/Documents/projectfolder/migrations

Start up the built in web service

   composer start

Click on the following link to create a migration for your project

• On this screen you can enter a description for your migration and then type in the SQL you want to run
• SQL statements should be separated by a “;”
• If you write a stored procedure or trigger then only one of those statements is allowed per migration
• You will be shown that the migration was created and a SQL file with the table you just created will be in the migration folder.

Migrations will be run every time you hit up the /migrate route of your project.