Hands-On Full-Stack Web Development with GraphQL and React

Your first database migration

Until now, MySQL has not known anything about our plan to save posts inside of it. Our database tables and columns need to be created, of course, and this is why the migration file was created.

A migration file has multiple advantages, such as the following:

1. Migrations allow us to track database changes through our regular version control system, such as Git or SVN. Every change to our database structure should be covered in a migration file.
2. It also enables us to write updates that automatically apply database changes for new versions of our application.

Our first migration file creates a Posts table and adds all required columns, as follows:

'use strict';module.exports = { up: (queryInterface, Sequelize) ...