PhysioCare database setup
===========================

1. Create the application database (e.g. CREATE DATABASE physionew CHARACTER SET utf8mb4 ...).

2. Apply your existing baseline schema scripts (branches, users, appointments, billing, etc.) from this folder if you maintain them separately.

3. Apply incremental migrations, for example from the Backend folder:
   npm run migrate
   Or: node database/runMigration.js
   Or (Windows): database\run-migration.bat
   To run a specific file:
   node database/runMigration.js path/to/your.sql

4. If a migration fails with "Duplicate column", the change may already be applied—skip or edit the script.

This repository does not ship one monolithic "full dump" of every table; use migrations plus your environment-specific baseline.