db-reseed

name	db-reseed
description	Rebuild the SchoolSync database with realistic demo data and verify it. Use to reset local data or after schema changes.

Reseed the database

php artisan migrate:fresh --seed drops everything and rebuilds: schema + roles/permissions + demo users + a working demo school (students, teachers, guardians, fees, a published exam with marks and ranked report cards, SMS templates, attendance).

Run

php artisan migrate:fresh --seed

Over a remote MySQL this is slow (thousands of round-trips, a few minutes) — run it in the background and watch for completion.

Seeder chain (database/seeders/DatabaseSeeder.php)

RolePermissionSeeder → super-admin + school-owner users → DemoUserSeeder (demo-school tenant + role users) → SampleDataSeeder (academic structure + people) → DemoOperationsSeeder (fees, exams/results, SMS, attendance).

Verify (read-only)

php artisan db:show --counts

Expect roughly: 74 users, 30 students, 90 fee allocations, 63 payments, 90 exam results, 30 published report cards, attendance + SMS rows.

Notes

• Demo fee payments are recorded as cash (online MFS payments are disabled — see PAYMENT_ONLINE_ENABLED).
• Demo login: [e-mail] (super admin) / [e-mail] (school owner), password password.
• On Windows, avoid PHP $variables inside tinker --execute "..." from PowerShell — it eats $. Prefer db:show or write a temporary script.