Create the migrations folder

Instead of putting all of our SQL directly into phpMyAdmin, we'll save it in a migration file. This makes the database setup easier to:

A simple PHP project can look like this:

code text

your-project/
│
├── app/
│
├── database/
│   └── migrations/
│
├── public/
│
└── index.php

Inside database/migrations, create:

code text

database/
└── migrations/
    └── 001_initial_library.sql

The 001_ prefix tells us that this is the first migration. As the application grows, additional migrations can follow the same pattern:

code text

001_initial_library.sql
002_add_categories.sql
003_add_users.sql

This makes it easy to understand the order in which database changes were introduced.

format_list_numbered Step 4 of 19