Autos Dealer Management System (MySQL Edition)

This project now uses a MySQL backend API instead of Supabase.

Stack

• Frontend: Vite + React + TypeScript + Tailwind
• Backend: Node.js + Express
• Database: MySQL 8+

Setup

1. Install dependencies:

npm install

2. Create .env from .env.example and update values.

3. Create schema and seed data in MySQL:

-- Run in order
SOURCE mysql/migrations/001_schema.sql;
SOURCE mysql/migrations/002_seed.sql;

4. Start backend API:

npm run dev:api

5. Start frontend app:

npm run dev

API Notes

• Auth endpoints:
  • POST /api/auth/signup
  • POST /api/auth/login
  • GET /api/auth/session
  • POST /api/auth/logout
• Data endpoints:
  • GET /api/db/:table
  • POST /api/db/:table
  • PATCH /api/db/:table
  • DELETE /api/db/:table

Default Seed Login

• Email: admin@ultimateautos.com
• Password: admin123

If needed, regenerate a bcrypt hash and update mysql/migrations/002_seed.sql.