=========================================
 NovaPay Bank — HOW TO RUN ON MACBOOK
 DBMS Project | Node.js + MySQL + HTML
=========================================

DEMO LOGIN CREDENTIALS
-----------------------
Customer : arjun@email.com   / demo123
Admin    : admin@novapay.com / demo123
Staff    : staff@novapay.com / demo123


STEP 1 — Install Node.js (one time)
-------------------------------------
Download from: https://nodejs.org
Choose "LTS" version → Install the .pkg file

Verify in Terminal:
  node --version   (should show v18+)
  npm --version    (should show 9+)


STEP 2 — Install XAMPP (one time)
-------------------------------------
Download from: https://www.apachefriends.org
Install → Open XAMPP → Start MySQL + Apache


STEP 3 — Import Database
-------------------------------------
Open: http://localhost/phpmyadmin
Click: Import → Choose File → select schema.sql → Go

This creates all 8 tables with demo data.


STEP 4 — Install Node packages (one time)
-------------------------------------
Open Terminal:
  cd path/to/banking/backend
  npm install

(Needs internet only this one time)


STEP 5 — Start the Server
-------------------------------------
  node server.js

You will see:
  ✅ NovaPay Bank running → http://localhost:3000
  ✅ MySQL connected to novapay_bank


STEP 6 — Open in Browser
-------------------------------------
  http://localhost:3000          ← Main website
  http://localhost:3000/login.html
  http://localhost:3000/transfer.html
  http://localhost:3000/dashboard.html
  http://localhost:3000/admin-dashboard.html
  http://localhost:3000/api/health


PAGES SUMMARY
--------------
index.html          → Landing page (hero, services, steps, dashboard preview)
login.html          → Login with Bank of Spain building image
open-account.html   → Register new account
transfer.html       → Fund transfer + transaction history table
dashboard.html      → Customer dashboard with sidebar
admin-dashboard.html → Admin panel with stats + customer DB


WORKS 100% OFFLINE
-------------------
After npm install is done once, everything works offline.
If MySQL is not running, server auto-switches to Demo Mode.
All buttons, forms, OTP flow, and modals work in Demo Mode.


TROUBLESHOOTING
----------------
Port in use?         → Change PORT=3001 in backend/.env
MySQL not connecting → Start MySQL in XAMPP panel
node not found?      → Reinstall Node.js from nodejs.org
npm install fails?   → Check internet connection and retry
Images missing?      → Ensure images/ folder is inside frontend/


PROJECT STRUCTURE
------------------
banking/
├── frontend/
│   ├── index.html          ← Main landing page
│   ├── login.html          ← Login (Bank of Spain image)
│   ├── open-account.html   ← Register
│   ├── transfer.html       ← Transfer + transaction table
│   ├── dashboard.html      ← Customer dashboard
│   ├── admin-dashboard.html← Admin panel
│   ├── style.css           ← All styling
│   ├── app.js              ← Frontend JavaScript
│   └── images/             ← All 15 images
├── backend/
│   ├── server.js           ← Express entry point
│   ├── .env                ← DB config
│   ├── package.json
│   ├── config/db.js        ← MySQL connection
│   ├── middleware/auth.js  ← JWT verify
│   └── routes/
│       ├── auth.js         ← login, register
│       ├── accounts.js     ← account data
│       ├── transfer.js     ← ACID transfer + OTP
│       ├── transactions.js ← history
│       ├── admin.js        ← stats, customers
│       └── contact.js      ← contact form
└── schema.sql              ← All 8 MySQL tables

=========================================