Database
Manage schema changes and seed data with migrations.
JamilX connects to MySQL or MariaDB via .env credentials, ships an installer SQL file, and supports migrations and seeders.
Run Migrations
php jamilx db:migrate
Ensure DB_HOST, DB_USER, DB_PASS, and DB_NAME are set before running migrations.
Seed Data
php jamilx db:seed
Seeders can return a callable or an array of SQL statements for quick setup.
Installer SQL
The installer runs installer/sql.sql to create core tables.
Migration Files
Each migration returns up and down arrays, tracked in jx_migrations with batch numbers.
Blog Tables
Sample blog tables live in database/blog.sql for prototypes.