WINDOWS FIX - COMPLETE SOLUTION FOR SIYANTRANSIT EXPRESS
=======================================================

FIXED THE MAIN ISSUES:
1. ✓ Server binding issue (changed from 0.0.0.0 to localhost)  
2. ✓ Windows command issue (using cross-env)
3. ✓ Database connection setup

WHAT TO DO NOW:
==============

STEP 1: CREATE .env FILE
------------------------
Create a file named ".env" (no extension) in your siyantransit folder with this content:

DATABASE_URL="postgresql://postgres:YOUR_POSTGRESQL_PASSWORD@localhost:5432/siyantransit"
HOST=localhost
PORT=5000

Replace YOUR_POSTGRESQL_PASSWORD with the password you set during PostgreSQL installation.

STEP 2: CREATE THE DATABASE
---------------------------
Option A - Using pgAdmin (GUI):
1. Open pgAdmin (installed with PostgreSQL)
2. Connect with your postgres password
3. Right-click "Databases" → Create → Database
4. Name: siyantransit
5. Save

Option B - Using Command Line:
1. Open Command Prompt
2. Type: psql -U postgres
3. Enter your password
4. Type: CREATE DATABASE siyantransit;
5. Type: \q to exit

STEP 3: RUN THE APPLICATION
--------------------------
In your siyantransit folder, run these commands:

npm install --save-dev cross-env
npm run db:push
npm run dev

STEP 4: VERIFY IT WORKS
----------------------
- Backend API: http://localhost:5000
- Website: http://localhost:5173

If you see "serving on localhost:5000" message, it's working!

TROUBLESHOOTING:
===============
- If database error: Check your .env file password matches PostgreSQL password
- If port error: Try different port numbers (5001, 5002, etc.)
- If PostgreSQL connection fails: Make sure PostgreSQL service is running

COMMON COMMANDS:
===============
- Check if PostgreSQL is running: services.msc (look for PostgreSQL)
- Restart PostgreSQL: Right-click PostgreSQL service → Restart
- Test database connection: psql -U postgres -d siyantransit

The server configuration has been updated to work properly on Windows!