Scaffold the next numbered SQL migration file in database/migrations/ and remind user to update all seed profiles
Create a new SQL migration for this project. Follow these steps exactly:
database/migrations/ and find the highest sequence number (format: NNN_verb_noun.sql).005).add_skills_table).database/migrations/NNN_<description>.sql with this template:-- Migration NNN: <description>
-- Created: <today's date>
USE personal_website;
-- TODO: Add your migration SQL here
-- Example:
-- CREATE TABLE example (
-- id INT AUTO_INCREMENT PRIMARY KEY,
-- name VARCHAR(255) NOT NULL,
-- createdAt TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
-- updatedAt TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
-- );
database/seeds/default/ if the new table needs default seed datadatabase/seeds/minimal/ for the minimal seed profiledatabase/seeds/full/ for the full seed profiledocker compose down -v && docker compose up to apply the migration to a fresh DB